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.
Dear karon! I hope you remember me - have done a work for you some time ago and would be happy to work for you again. Please, check PMB. Sincerely yours, John.
$30 USD în 2 zile
4,7 (11 recenzii)
3,6
3,6
9 freelanceri plasează o ofertă medie de $40 USD pentru proiect
I am well conversant with the assignment / Project you want to get done. I am well qualified and experienced to handle small, medium, and mega Projects / Assignments (please refer to my Profile). I am reliable and available to start your Project / Assignment immediately. Looking forward to a long-lasting, fruitful and trust worthy business relationship reaching towards a win-win situation. Please feel free to contact me for more information / clarifications. Best regards.