Courtni HoldegraverProject Specialist| Enterprise Holdings, Inc.St Louis, Mo, United States
I am in need of a sophisticated excel template that can provide an analysis of forecast hours vs. actual hours worked. Ideally it would also have the 52 weeks itemized to show gaps or congestion in workload. Thanks. Saving Changes...
Sort By:
Stéphane ParentSelf Employed / Semi-retired| Leader MakerPrince Edward Island, Canada
Did you check the Deliverable, Courtni? I remember seeing something a lot like what you are asking for. Saving Changes...
Courtni HoldegraverProject Specialist| Enterprise Holdings, Inc.St Louis, Mo, United States
I did but didn't find what I was needing. The template that was listed is resource hours and I really need something for forecast vs. actual. Thanks. Saving Changes...
Peter KarpiukSenior Consultant| Atos SyntelLouisville, Ky, United States
I would start with using a regression model. Start with the actuals as the observations and then the coefficients would be the 'trend'/Slope and a deviation from the average/Constant.
If you have additional prospective variables that you think 'drive' the trends, you can include these in a multivariate regression. (multiple regression)
If you would be able to provide a sample of the observations for the actuals, I could provide more precisely how this can be performed in Excel if the number of separate regression models is less than 3 or 4.
Hope this helps. Saving Changes...
Sromon DasSenior Project Manager| Mara ConsultingHalifax, Nova Scotia, Canada
If you can draw up a simple draft I can try to create one if you don't find one online
/sd Saving Changes...
Mansoor MustafaSenior PM| Government DepartmentRawalpindi Punjab, Pakistan
Thanks Anupam for sharing smart sheet Saving Changes...
