Пікірлер
@lobo595
@lobo595 3 күн бұрын
Hi! How do you remove an external link, while preserving the formula, without having to highlight and delete it? Referring to the section 8:45 of the video. Thanks!
@joshuaroelle4938
@joshuaroelle4938 4 күн бұрын
I would love to use this feature and I kind of got it to work but no matter what I do the mileage is just not right for a 24 mile drive it's saying 347 mi I've spent hours trying to figure out why I just can't
@JeffAlmonte
@JeffAlmonte 4 күн бұрын
This was super helpful, thank you!
@ErinatTimeSavingTemplates
@ErinatTimeSavingTemplates 2 күн бұрын
Glad to help!
@saipeyyeti4
@saipeyyeti4 8 күн бұрын
👌 👏 👍
@ErinatTimeSavingTemplates
@ErinatTimeSavingTemplates 2 күн бұрын
thank you!
@NewHomeKnowItAll
@NewHomeKnowItAll 15 күн бұрын
This was very helpful... Saved me sooooo much time! 🍪 Thank You!!
@rogerl8488
@rogerl8488 Ай бұрын
THANK YOU I NEED THIS LOL.
@Grace4405
@Grace4405 Ай бұрын
Hi Erin! Have you done a video on how to calculate internal parity for employees and to determine pay equity? If not, would you consider doing one on this topic?
@ErinatTimeSavingTemplates
@ErinatTimeSavingTemplates Ай бұрын
Thanks for reaching out! So there is a merit increase with job and gender analysis sections. I'll be looking at adding ethnicity/race analysis to this version here (also see video if you scroll down) - timesavingtemplates.com/product/gender-pay-gap-analysis-merit-increase-analysis/ Is that what you're looking for, or more of a review to catch any outliers who are paid differently than the majority?
@DazzleMaine
@DazzleMaine Ай бұрын
Hi do you have free on this template?i badly needed this☹️dont know how to start .
@DazzleMaine
@DazzleMaine Ай бұрын
I hope you can help me miss
@ErinatTimeSavingTemplates
@ErinatTimeSavingTemplates Ай бұрын
@@DazzleMaine Thank you for your interest in the templates! Not all of them are free, but you can find the free resources we have available right here: timesavingtemplates.com/freeresources
@andreap8561
@andreap8561 Ай бұрын
Thank you Erin, these are so helpful. Would you do one to compare city and state minimum wage for a list of employees?
@ErinatTimeSavingTemplates
@ErinatTimeSavingTemplates Ай бұрын
Thank you for reaching out! The minimum wages are constantly changing it seems, so I don't have something that tracks the latest for each state; however I am looking at a template for 'Bring to Minimum' cost analysis - so you could input your minimum wage requirements and/or your salary range minimum, to see the costs to bring anyone below that min. Is that what you are looking for?
@robbmitchell9461
@robbmitchell9461 2 ай бұрын
wasn't sure if this was what I was searching for, but it worked perfect...thank you!!!!
@bikashkonwar3938
@bikashkonwar3938 3 ай бұрын
Do you have any formula to calculate Range Overlap in between the grades
@ErinatTimeSavingTemplates
@ErinatTimeSavingTemplates 3 ай бұрын
Sure! This video goes over the range spread - kzbin.info/www/bejne/l3_dlqt-f9x8j6s&t The range spread will look at the comparison of the min to max within each grade, but typically the higher the range spread, the more overlap between the ranges. The overlap can also vary based on the difference from midpoint to midpoint between each grade. This video goes over midpoint differentials - kzbin.info/www/bejne/hIfJh4SAfbGEY68&t If you are looking for something else, let me know and I can look into it!
@bikashkonwar3938
@bikashkonwar3938 3 ай бұрын
Please make your worksheets free for everyone. Let's everyone learn free.
@ErinatTimeSavingTemplates
@ErinatTimeSavingTemplates 3 ай бұрын
Sure, the free options are listed on this page: timesavingtemplates.com/freeresources/
@oliviertulliez7639
@oliviertulliez7639 3 ай бұрын
exactly what I was looking for, thanks!
@WilliamHobbs-c5m
@WilliamHobbs-c5m 3 ай бұрын
is there a place for you to enter the tenants information (name, phone, email) ?
@ErinatTimeSavingTemplates
@ErinatTimeSavingTemplates 3 ай бұрын
Thanks for your interest in the templates! You can certainly add this information to any of the blank cells in the top sections. The 30 property version includes a labeled section to list out the name and contact information too. If you run into any other questions, please let me know!
@vishnuarrawatia9802
@vishnuarrawatia9802 4 ай бұрын
Nice
@fredye286
@fredye286 4 ай бұрын
Thank you
@ErinatTimeSavingTemplates
@ErinatTimeSavingTemplates 3 ай бұрын
Of course, happy to help!
@MrRummy661
@MrRummy661 5 ай бұрын
Hello I need link to download you format to work
@ErinatTimeSavingTemplates
@ErinatTimeSavingTemplates 4 ай бұрын
Thanks for your interest in the templates! Here is the one covered in the video - timesavingtemplates.com/product/employee-performance-review-template/
@ericpineda2911
@ericpineda2911 5 ай бұрын
If i am looking at a quarter or 6 month you said to enter total salary for those months. How does that impact the rest Of the field? Like The average percentage of OT of base.
@ErinatTimeSavingTemplates
@ErinatTimeSavingTemplates 4 ай бұрын
Hi! The average % of OT is calculated as the total overtime /divided by total base salary. So if you want to look at a 6 month period - you can take your total overtime over 6 months divided by your base pay over 6 months. The percentage is looking at the relation of overtime compared to the base pay - so you wouldn't want to take overtime of just 1 quarter divided by base pay for the year - it will be a lower percentage. I hope this makes sense! Feel free to reach out if you have more questions on that.
@-panitakc6520
@-panitakc6520 5 ай бұрын
Thank you!
@AhmedBawazir-mc4ps
@AhmedBawazir-mc4ps 6 ай бұрын
How about if employee Joined middle of the year then in that case employee will not be eligible for full paid days of calendar year
@ErinatTimeSavingTemplates
@ErinatTimeSavingTemplates 6 ай бұрын
Great question! So for each employee, you can enter their total # of eligible PTO days for the year that you want to keep track of. So you can enter a prorated number for those that are new hires. Some companies have different policies on new hires using vacation, and others the vacation is accrued as they work; either way you can update their total vacation allotted for the year, and the template will track remaining balance for calendar year totals. I hope this helps!
@Lynn-MarieAndrade
@Lynn-MarieAndrade 6 ай бұрын
How do you use the sub category? Main category “Car”, sub would be gas Main category “client”, sub would be meals, gifts
@bdoorH1
@bdoorH1 6 ай бұрын
Thanks ❤
@nicolascorrea708
@nicolascorrea708 6 ай бұрын
What should I do if i want the median following 2-3 criteria, for example with the grade D, E and F. Thank you!
@ErinatTimeSavingTemplates
@ErinatTimeSavingTemplates 4 ай бұрын
Great question! I added another video here about that - kzbin.info/www/bejne/qoeQl2CijL15rqs
@irynaprotan8013
@irynaprotan8013 7 ай бұрын
Could you share with me the file? I am particularly interested how to calculate min, max having only mid point
@ErinatTimeSavingTemplates
@ErinatTimeSavingTemplates 6 ай бұрын
Thanks for your interest in the templates! This is the template shown in the video - timesavingtemplates.com/product/pay-structure-design-template/ The free comp metrics cheatsheet, will also go over how to calculate it: timesavingtemplates.com/compensation-analytics-pdf/ Basically, you will need to determine a range spread to apply to your midpoint, that will get you the min and max: Range Spread - Displayed as a percentage to show the range from the minimum to maximum within each salary band range. When you have the range midpoint, it can help to use a consistent range spread across similar positions/bands to develop the min and max: • Max = Min X (1+ range spread %) • Min = Midpoint / (1 + (range spread/2))
@ErinatTimeSavingTemplates
@ErinatTimeSavingTemplates 6 ай бұрын
This video also goes over range spread & min/max calculation here - kzbin.info/www/bejne/l3_dlqt-f9x8j6s
@joyfulliving3231
@joyfulliving3231 7 ай бұрын
How do you purchase this template?
@ErinatTimeSavingTemplates
@ErinatTimeSavingTemplates 6 ай бұрын
Thanks for your interest in the templates! You can find this one right here - timesavingtemplates.com/product/consignment-tracking-for-stores-inventory-tracking-consignment-sales-tracking/
@LindseyJones-dk8uq
@LindseyJones-dk8uq 7 ай бұрын
where is part 2?
@ErinatTimeSavingTemplates
@ErinatTimeSavingTemplates 6 ай бұрын
Hi! There are 4 videos in that series, all listed on this page : timesavingtemplates.com/hr-analytics-with-excel-compensation-quartiles/
@Just_Manny305
@Just_Manny305 7 ай бұрын
would be better if you just got to the point. This video did not need to be 10 minutes long.
@stepieninstruments8241
@stepieninstruments8241 6 ай бұрын
exactly! the video is definetly not time saving!
@jaquasianicole4371
@jaquasianicole4371 7 ай бұрын
Amazing!
@ErinatTimeSavingTemplates
@ErinatTimeSavingTemplates 7 ай бұрын
thank you!
@Arrogance-es5gm
@Arrogance-es5gm 7 ай бұрын
Hi , If you have any elaborated materials about compensation and salary analysis materials, please share them with me as I am new to this field .. and also pay for it..
@ErinatTimeSavingTemplates
@ErinatTimeSavingTemplates 7 ай бұрын
Thanks for your interest! I have HR/ compensation templates here - timesavingtemplates.com/product-category/humanresourcesadministration/ Or the bundle that includes everything is here- timesavingtemplates.com/sp/all-star-hr/
@StuartGormley-xe4iz
@StuartGormley-xe4iz 8 ай бұрын
Too much junk data before explanation
@JulieBoss-r5n
@JulieBoss-r5n 8 ай бұрын
Thank you so much for this, this helps a lot !
@ErinatTimeSavingTemplates
@ErinatTimeSavingTemplates 7 ай бұрын
thank you! I'm glad it helps!
@EuchariaOgudu
@EuchariaOgudu 9 ай бұрын
This is interesting,29/3/24
@gindginnest3336
@gindginnest3336 9 ай бұрын
__==
@dwayneflax2304
@dwayneflax2304 9 ай бұрын
You made this so simple. Thank you!
@sassy1lady
@sassy1lady 9 ай бұрын
I bought this spreadsheet. Previously I had my own for my rentals. I think this will make it MUCH easier for my accountant. :) Thanks for taking your time to make it. I started using it this year in Feb., and went back to all my Jan. expenses/income before it got too much to go back and do.
@samanthafeigl178
@samanthafeigl178 9 ай бұрын
Hi, do you have a video explaining how to create the stacked column chart with the ranges? TY!
@mahangadeshraddha9462
@mahangadeshraddha9462 9 ай бұрын
Could you please make video on how to make this dashboard step by step including all sheets
@daryaun1111
@daryaun1111 9 ай бұрын
Thanks😊
@marlissavanheerwaarden7365
@marlissavanheerwaarden7365 10 ай бұрын
Thank-you - perfect solution for my calcs.
@satrenagayle
@satrenagayle 10 ай бұрын
I have delayed starting my sewing doll clothes business because i had no clue how to do tracking for taxes. After watching your videos i feel i can do this. I plan to buy this template payday. Thank you for creating it and thank you for not charging a monthly or yearly fee. Im trying to live on very low retirement income so this is a great help to me.
@AndySpeed88
@AndySpeed88 10 ай бұрын
This is good, but the title is misleading as you've only applied it to one group of criteria (Grade or Band) and not multiple criteria...
@ErinatTimeSavingTemplates
@ErinatTimeSavingTemplates 4 ай бұрын
I added another video that goes over the multiple criteria question right here - kzbin.info/www/bejne/qoeQl2CijL15rqs
@funeralparties
@funeralparties 10 ай бұрын
Sorry for what is gonna sound really dumb, but is Inventory (line 32) the dollar amount of all of our items? And is it the wholesale or retail value?
@JaimieJordan-x7l
@JaimieJordan-x7l 11 ай бұрын
Any suggestions if a ctrl + F search for .xl doesn't locate the cell(s)?
@luzar9500
@luzar9500 11 ай бұрын
OMG THANK YOU SO MUCH. VERY HELPFUL!
@marcosofyanbiz
@marcosofyanbiz 11 ай бұрын
thanks alot really helped me out!!
@josephcarey7526
@josephcarey7526 11 ай бұрын
Great video! So helpful with creating a range from scratch for consulting, especially after leaving corporate America where the Mercers and Worlds-at-Work have done it for me in the past; I'll definitely be purchasing the bundle.
@ErinatTimeSavingTemplates
@ErinatTimeSavingTemplates 3 ай бұрын
thank you!
@quratulainraza3078
@quratulainraza3078 Жыл бұрын
I break the links, but the files cannot be saved,,,,, it sucks
@raquelosegueda376
@raquelosegueda376 Жыл бұрын
This is great. Do you have something that shows the actual formulas? Specially scoring based on percentages.
@steveetienne3299
@steveetienne3299 Жыл бұрын
The temple is not free. Why would you lied?
@DestinationRetirement
@DestinationRetirement Жыл бұрын
Hi Erin, would you consider making a custom template? I have two air bnb's in Mexico and I would need to add more tax categories.