Resource loading (difficulty with date functions)
 

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