How to account for ramp up time for new sales employees in model

XLSNEWB

New Member
Joined
Jan 30, 2018
Messages
1
Hello - first time poster here. I've been trying to figure out how to model a schedule that breaks out Experienced and Inexperienced sales employees. For the first three months, after a new employee is hired, I would like them to be counted as an Inexperienced Seller, then in the 4th month and forward, they should be counted as an Experienced Seller. I'm trying to figure out rows 3 and 4 below.

Headings - columns for each month Jan - Dec
Row 1 - Currently, this counts the total number of sales employees (experienced and inexperienced) in each month by pulling data from a master hiring spreadsheet (The master hiring spreadsheet will be adjusted to suit hiring needs and should feed the rest of the model below)
Row 2 - Currently, this subtracts the previous month's count from the current month's count to get the count of new employees added that month
Row 3 - This should return the number of Experienced Sellers based on the criteria above, so only counting employees that have been employed for 3 months.
Row 4 - This should return the number of Inexperienced Sellers - less than 3 months experience.


Assumptions - new employees start on the first of the month.

Thanks in advance for the help!
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Hi,

Able to share sample data and a mockup of what you're expecting?
 
Upvote 0

Forum statistics

Threads
1,224,828
Messages
6,181,210
Members
453,023
Latest member
alabaz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top