✅ ENROLL HERE IN EXCEL CLASS ✅

  • Home
  • Portfolio
  • Plug-and-Play Templates
  • Shop
    • Shop Business Tools
    • Shop Excel Classes
  • Free Calculators
  • Free Downloads
  • Blog
  • About
    • Podcasts
    • Bio
    • Featured In
    • Contact
    • $ Partners $
  • More
    • Home
    • Portfolio
    • Plug-and-Play Templates
    • Shop
      • Shop Business Tools
      • Shop Excel Classes
    • Free Calculators
    • Free Downloads
    • Blog
    • About
      • Podcasts
      • Bio
      • Featured In
      • Contact
      • $ Partners $
  • Home
  • Portfolio
  • Plug-and-Play Templates
  • Shop
    • Shop Business Tools
    • Shop Excel Classes
  • Free Calculators
  • Free Downloads
  • Blog
  • About
    • Podcasts
    • Bio
    • Featured In
    • Contact
    • $ Partners $
XecuteTheVision
Excel + Google Sheets Tips & Tricks

Where strategy meets execution

Where strategy meets executionWhere strategy meets execution

Free HR and People Calculators

Get the numbers needed for the day-to-day operations and to ensure teams are functioning optimally.


• NPS & eNPS Calculator

• Headcount Growth Planning Calculator

• Paid Time Off (PTO) Accrual Calculator

• Salary Increase Calculator

• Employee Turnover Cost Calculator

• Time Duration Calculator

How to calculate Net Promoter Score NPS

How to use a Net promoter Score nps or ENPS calculator

eNPS measures employee loyalty and engagement by asking employees how likely they are to recommend your company as a place to work. They score 0 to 10, 10 being the highest. This is a great way to determine employee satisfaction. Many ask a second question with this which is simply "Why?" This will provide insight into the survey number. 100 isn't necessarily the goal, to score a 75 is quite excellent. Learn more here.


The same concept applies exactly when you use NPS for customer surveys. The formula is the same, the question for customers would be how likely are they to recommend your product or service to their friends and family.


Formula

NPS or eNPS = % Promoters − % Detractors

 

Where employees are classified based on a 0–10 scale:

  • Promoters: 9–10 
  • Passives: 7–8 (ignored in calculation) 
  • Detractors: 0–6
     

Inputs (user enters)

  • Number of Promoters 
  • Number of Passives (optional, not used in calculation) 
  • Number of Detractors
     

Output

  • eNPS or NPS score (between -100 and +100)

How to calculate headcount growth

How to use a headcount growth planning calculator

Headcount Growth Planner

Definition:
Projects your team’s future size over time based on current headcount and an expected growth rate. Helps you plan staffing and resources with confidence.


How to Use:

  1. Enter your current headcount. 
  2. Input the expected growth rate per period (%). 
  3. Enter the number of periods you want to project. 
  4. Click Calculate to see your future headcount.


Future Headcount=  Current Headcount × (1+Growth Rate) ^ Periods 

Where:

  • Current Headcount = your team’s current number of employees 
  • Growth Rate = expected growth rate per period, expressed as a decimal (e.g., 20% → 0.20) 
  • Periods = number of periods you want to project (quarters, months, or years, depending on your input)
     

Example:
If your team has 10 employees, and you expect a 20% growth rate per quarter over 3 quarters, the tool shows a future headcount of 17.

How to calculate Paid time off (PTO) accruals

How to use a pto accrual calculator

Paid Time Off Calculator

Definition:
Calculates how many paid time off (PTO) hours you’ll accumulate over a chosen number of periods, based on your accrual method (per pay period, per hour worked, per month, or per year), starting balance, and an optional cap.


How to use it:

  1. Pick your accrual method. 
  2. Enter the accrual rate (e.g., 3.33 hours per pay period).
  3. Add your current PTO balance
  4. If you accrue “per hour worked,” enter typical hours per period. 5) Choose how many periods to project. 
  5. (Optional) Set a cap if your policy limits maximum PTO. Click Calculate.
     

Example:

  • Method: Hours per pay period 
  • Accrual rate: 3.33 hours 
  • Starting balance: 0 hours 
  • Projection: 26 periods (bi-weekly for a year) 
  • Cap: 120 hours
    → You’ll accrue up to 86.58 hours if the cap isn’t reached; if your balance hits 120 hours, accrual pauses at the cap.
     

Formula:

PTO Accrued = (Hours Worked Per Week) × (Accrual Rate) × (Number of Weeks)


Example:
If you work 40 hours per week, your company gives 0.05 hours of PTO per hour worked, and you work 52 weeks in a year:


40 x 0.05 x 52 = 104 hours of PTO per year

 

Note: The on-page projection assumes no PTO usage; deducting time would reduce subsequent balances.

How to calculate salary increase

How to use a salary increase calculator

Salary Increase Calculator 

Definition: A salary increase is when your pay goes up by a certain percentage. To figure out your new salary, you take your old salary and add the increase.


Formula:

New Salary = Current Salary + (Current Salary × Increase% / 100) 


Example:
If your salary is $50,000 and you get a 5% raise:

50,000 + (50,000 × 0.05) = 50,000 + 2,500 = 52,500


Your new salary is $52,500.

How to calculate employee turnover cost

How to use an employee turnover cost calculator

Employee Turnover Cost Calculator
Replacing an employee costs more than just their salary. Businesses lose money on recruiting, training, and lost productivity while the position is unfilled or the new hire ramps up.


Formula (basic):
Turnover Cost = Recruiting Costs + Training Costs + Lost Productivity


Example:

  • Recruiting Costs = $5,000 
  • Training Costs = $3,000 
  • Lost Productivity = $8,000
     

👉 Turnover Cost = $5,000 + $3,000 + $8,000 = $16,000

This means losing and replacing one employee could cost you $16,000 or more, which is why retention strategies are so important.

How to calculate time duration with start and end time

How to use a time duration calculator

Time Duration Calculator

The Time Duration Calculator helps you quickly find the difference between a start time and an end time. This is useful for tracking work hours, project timelines, or event scheduling.


Formula:

Duration = End Time − Start Time

 

Step 1. Write down the start and end times clearly.
Example: Start = 9:15 AM, End = 1:45 PM

Step 2. Count the full hours first.
From 9:15 → 1:15 = 4 hours

Step 3. Count the remaining minutes.
From 1:15 → 1:45 = 30 minutes

Step 4. Add them together.

4 hours + 30 minutes = 4 hours 30 minutes


Shortcut Method (with subtraction):

  1. Convert both times into minutes since midnight. 
    • 9:15 AM = 9 × 60 + 15 = 555 minutes 
    • 1:45 PM = 13 × 60 + 45 = 825 minutes 

  1. Subtract: 825−555 = 270 minutes 
  2. Convert back to hours + minutes: 
    • 270 / 60 = 4 hours 
    • Remainder = 30 minutes
       

Result: 4 hours 30 minutes ✅

Copyright © 2025 XecuteTheVision™, LLC - All Rights Reserved. | Terms of Service | Privacy Policy

  • Home
  • Portfolio
  • Plug-and-Play Templates
  • Shop Excel Classes
  • Excel problems end here
  • Excel Proficiency Test
  • Free Calculators
  • Blog
  • Contact
  • $ Partners $

XecuteTheVision@gmail.com | Macomb, MI 48042, USA

*NEW* 8/16 Free business calculators. plug in & go.

Let's go!

This website uses cookies.

We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.

DeclineAccept