Excel Expert to develop Project Resources S/S

Excel Expert to develop Project Resources S/S is project number 257086 posted at GetAFreelancer.com. Click here to post your own project.

Closed
(Selected Service Provider johnsinit)

Status:	Closed
Budget:	$30-250
Created:	05/02/2008 at 4:31 EDT
Bidding Ends:	05/04/2008 at 4:31 EDT
Project Creator:	karon   Buyer Rating: (20 reviews)
Description:	I want a spreadsheet developed to show the number of FTEs in each role on each day, over the lifecycle of a project. So the top few rows of the SS will be a calendar. It will show days between 19 May 08 to 31 November 08. I quite like the presentation in the SS I've uploaded that shows Month and first day in the week, then a narrow column for each day. Start of week needs to be expressed as Day/Month not Month/Day. The day columns need to be wide enough to accept data (values 1-99). Role names in the first column of the SS will be: Project Manager Test Manager Change Manager Core Project Team ITS staff Payroll staff Internal trainers Training material developer UAT business representatives I need the flexibility to add additional Role names I will then populate the cells with the appropriate number of FTEs in each role on any particular day. These will need to be totalled in a row at the bottom, and these totals will be used to generate an automated chart showing weekly FTE load across the project. The chart will automatically regenerate when any FTE number is updated. I wish to print this out on a landscape A3 page. Excel experts only please. Additional files submitted: Modify to become Resources Plan.xls
Job Type:	Excel
Database:	MySQL
Operating system:	(None)
Bid count:	10
Average bid:	$ 42