What you're asking is not the easiest thing to do.

Here you go...I built this some years ago:
Fully functional Excel model that tracks a project, following
Project Management Book of Knowlege/Rapid Product Development(PMBOK/RPD) guidelines.

http://www.savefile.com/files/1271995

Post back if you have questions.