I am a very inexperienced excel user and have been working on a spreadsheet for my boss and am in desperate need of some assistance.
The attached file is what I have come up with so far. Excuse the long winded formulas but like i mentioned above my excelpertise are limited
The input contractors sheet allows you to input the amount of 3/6 month contractors for a month and then shows the breakdown of contractors on our books for the next 3/6 months with 50% of the contractors falling off every 3/6 months.
What I need to do now is allow the 3/6 months to become a variable and the percentage (50%) of fall offs to also become a variable.
In addition I have to allow me to replace the forecasted figure with the actual figures after the month has been completed.
Would anyone be able to point me in the right direction? or any direction for that matter!!!
Any help would be much appreciated.