stevensmatlas
New Member
- Joined
- Jul 19, 2018
- Messages
- 1
Hello MrExcel world!
I am new to the forum. I wanted to get some advice on a project I am working on. The intent is to calculate current seniority percentile and then also forecast percentile change based on known retirement date. The data will look something like this:
EmpId - Hire Date - Retirement Date - Current Percentile
451741 08-01-2016 09/08/2054 82% (percentrank(daysofservice)(range)(significance)
421321 02-03-2017 08/15/2062 91%
I am easily able to calculate current rank. Where I am in need of help is how to create a table that calculates month by month until said retirement date (09/08/2054) For example if there are X number of people who are senior to me with Y retirement date, how will that change my ranking on a month by month basis. With output something like:
2018 AUG SEPT OCT NOV DEC
81.5% 79.8% ETC ETC ETC
I know its a bit of complex problem but I am hopeful you guys may have some ideas. I appreciate any help you can provide!
-Matt
I am new to the forum. I wanted to get some advice on a project I am working on. The intent is to calculate current seniority percentile and then also forecast percentile change based on known retirement date. The data will look something like this:
EmpId - Hire Date - Retirement Date - Current Percentile
451741 08-01-2016 09/08/2054 82% (percentrank(daysofservice)(range)(significance)
421321 02-03-2017 08/15/2062 91%
I am easily able to calculate current rank. Where I am in need of help is how to create a table that calculates month by month until said retirement date (09/08/2054) For example if there are X number of people who are senior to me with Y retirement date, how will that change my ranking on a month by month basis. With output something like:
2018 AUG SEPT OCT NOV DEC
81.5% 79.8% ETC ETC ETC
I know its a bit of complex problem but I am hopeful you guys may have some ideas. I appreciate any help you can provide!
-Matt
