Headcount forecast in Excel
Jerry Goldberg (Principal, Strategic Capital Corp)
| Aug 3, 2011I have a headcount forecasting worksheet in workbook an ex-employee left behind that has some holes in it. I need a formula in Excel that populates a headcount grid by querying the cells for each employee's start date, and also a formula for allowing for percentage raises . Any brilliant Excel modellers have ideas?
Topics:
Answers
Company: ITW
Not sure of the scope of it, but you can attack this in a minimum of 2 ways. One using Countif/Sumif and the other using PivotTables. In my mind, what you are looking for is pretty straightforward, so in that case I suggest CountIf/SumIf. PivotTables can be quirky and if the data analysis doesn't involve a ton of 'whatif' meaning the grid will be static I suggest the simpler approach. It doesn't appear this forum allows uploads, but if you send me an e-mail at dalexander
thepeerlessgroup [dot] us I'll send you an example spreadsheet that might help
Company: NA
David, I would be interested in this resource and so may other members of the Proformative community. Proformative does allow the posting of resources. Resources is a main site navigation tab. You could post the resource and then share the link in a response to Jerry to get the resource out to the community and "close the loop" with Jerry in addition to sharing your resource with the Proformative community.
Company: NA
David, I saw that you posted the resource, but I did not see the attachment.
Company: ITW
Tim,
Try it again, hopefully it worked this time. Let me know if it helps at all.
http://www.proformative.com/og/resource/general-content/employee-raises-grid-month
Company: Strategic Capital Corp
Thx David
Company: ITW
Can't get the resource posting to upload the file. I get no error, it appears that the file is attached and I click 'Save' to attach. Nothing. Frustrating. Any suggestions?
Company: NA
David, I have worked with Ernie Humphrey who works at Proformative and discussed your issue with him. Can you please send the file to him at ehumphrey
proformative [dot] com so he can add to your resource post and then he will touch base about why the file is not uploading on your end.
Company: ITW
Tim, Thanks for the direction. I sent to Ernie so he can tell me what I'm doing wrong. -David
Company: ITW
Its posted now, Ernie must have worked some magic. Its a simple spreadsheet for pointing out concepts more than anything. Let me know if this was the concept you were looking for.