Hi There
I have in the attatched spreadsheet a moving forecast based on a gant chart style format. The forecast moves when you change the start date in cell D7 and the contract length in D15 ( You can only change the length of contract based on 4 Contract lengths) and labour (D11) and materials (D12) spread over that period from the start date. Great ! However this spreads the cost evenly and i need to form in sum way a lookup formula to the templates worksheet to times the cost by the given percentage. For example if the contract value is 12 months and starts in April 2014 i need to times what is in (Labour) D11 by C6 (in Templates) (6 Million x 1%) to return 60,000 in J11 and so on. However if you changed the start date to sep14 and the contract date to 24 months then i would need to times what is in D11 by C8 (Templates) to return the value 30,000 in O11 (60000 in O12 and so on). Sorry this is a bit confusing but if someon has the know how to do this i would be greatful to you forever and buy you as many easter eggs as you want !!!
Thank You
Scott
Bookmarks