Crackwalker Summary Load

Get this from a library! The crackwalker. [Judith Thompson] -- Theresa, who is worshipped by her boyfriend, is a mentally challenged woman who is. The Crackwalker Written & Directed by Judith Thompson March 22 -April 10.
Theresa, who is worshipped by her boyfriend, is a mentally challenged woman who is extremely sexy, but can never lose her innocence. She does tricks at $5 each, is addicted to Tim Horton donuts, lies without thinking and overflows with endless kindness. A tough, brilliant play about Theresa and three other down-and-outers in Kingston. A peripheral fifth character, a destroyed Native youth, is introduced to show us that even this quartet is not quite the bottommost stratum of society. Rating: (not yet rated) Subjects • • • • More like this •.
I am looking to create a load summary that I can use for the entire electrical system. Windows 7 Ultimate Os Full Version there. I am looking for some help in doing so. I have tried creating a schedules and using connected loads but I am not finding a way to add in the appropriate calculations.
I have also tried to create my own panel schedule template but again no luck. I have a screen shot of what kind of Load Summary we currently use in excel. I would like to replicate this directly into Revit. I want to use the power of revit to have this automate the calculation so I do not have to take time to reference excel for the calculation. If any one has some insight or ideas that can help me accomplish this I would greatly appreciate it.
You won't be able to have the 'removed' data at all - once something is demolished in Revit, it's well and truly demolished, and panel schedules don't have phases. But getting the new load info with demand calcs is pretty simple - it's already in the panel schedule. The existing loads will be too, if you bother to model them correctly. But if you want to document how much load is demolished during a renovation you'll have to model all of the existing conditions exactly, save that model separately, then demolish and add as required by the project, and compare the two in XL.