help with forecasting/budget spreadsheet

[makaveli80]

hi all,

I am wondering if there is an easier way for me to update a forecasting spreadsheet or even a better way to this overall? I have one spreadsheet called Timesheets where I capture the weekly timesheets that all employees send to me. Each project has it's own budget and expected effort in days.

Right now I'm filling out the "actual utilization" which is basically the hours worked in a week divided by 40. Then I insert that into the Forecast/Budget spreadsheet manually. This enables me to see the "forecasted spend based on burn chart" and lets me know how much is left on the budget if people worked x amount of days/hours on a project.

So I' wondering if there is a good way to fill out the Forecast_Budget tab with the actual utilization (i.e. 1, .5, ) based on the timesheet tab?



I thought I might create a utilization report and maybe do a lookup based on name of person and the week and project but i don't know how complicated that might get.

Any help would be appreciated. Thanks in advance