Resource loading (difficulty with date functions)

R

Russ

Hi: I am trying to create as simple a spreadsheet as possible to
estimate my personal resource loading. That is, I have a list of
projects with start & end dates including the number of hours required
for each job. I want to estimate (in percent) how much of every
workday all of these projects total up to. The idea is to keep from
over committing myself.

I have created a spreadsheet with two tabs. First tab is list of
projects (just has 3 to start). The second tab is where I have
manually calculated and filled in my loading for each day (100% =
full day) based on the project information from first tab.

The file is "test.xls" at this link http://webpages.charter.net/rwpatterson357/temp/

My question is this - how can I automate the creation of that second
tab? I would like to enter the project information on the first tab
and have the entire second tab created without my manual calculation
and data entry.

thanks,
russ
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Base calendar interaction with a resource calendar 0
[Project 2013] More accuracy with resource, unit %, and cost? 0
Level resource allocation error 1
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Receiving unexpected Duration 0
difficult VLOOKUP question: 2
Several projects w/ Excel involving dates ... 0
Sum If formula 1

Top