I need help with formulas on Excel
Budget: $250 – $750 AUD
Attached Excel
I'm trying to create a cash flow/ labour forecast tool
I have job data Quote amount (L)x Win Rate (M) then the value distributed on the gant chart durations multiplied by the values pre-set in the S curve tab
I would like to set this up where this is a duplicate tab where the information could be condensed to months not weeks, and also an option on both pages to change the reference from Column L to Column Q easily showing the hours distributed not value
I'm trying to create a cash flow/ labour forecast tool
I have job data Quote amount (L)x Win Rate (M) then the value distributed on the gant chart durations multiplied by the values pre-set in the S curve tab
I would like to set this up where this is a duplicate tab where the information could be condensed to months not weeks, and also an option on both pages to change the reference from Column L to Column Q easily showing the hours distributed not value