Hello
Attached is a forecasting spreadsheet that I have been working on. Please excuse the long winded formulas but my excel expertise are very limited.
What the spreadsheet does:
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:
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.
http://www.ozgrid.com/forum/showthread.php?t=143275
Bookmarks