Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-13-2018, 07:27 AM
makaveli80 makaveli80 is offline help with forecasting/budget spreadsheet Windows 7 64bit help with forecasting/budget spreadsheet Office 2010 64bit
Novice
help with forecasting/budget spreadsheet
 
Join Date: Nov 2017
Posts: 16
makaveli80 is on a distinguished road
Default help with forecasting/budget spreadsheet

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
Attached Files
File Type: zip resource_utilization.zip (542.3 KB, 14 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Budget Resources / Budget Costs / Hourly Labour mattfromcanada Project 0 10-20-2017 11:57 AM
Budget Cost MAJID Project 1 08-10-2017 07:48 PM
Mac 2011 - When I close a spreadsheet, there is a blank spreadsheet left on dock. wvinyard Excel 0 07-27-2017 11:32 AM
Need Help with Advance Data Forecasting fezzyfezz Excel 0 06-24-2015 10:49 AM
Income/Budget Calendar? Guinea Excel 4 03-11-2010 09:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:28 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft