Revit Schedule for Live data Information

[Jrooker06]

I am trying to creat a new schedule in Revit 2014. It will pull in all of my data drops and outlets. I have already started working on it and after i completed what i know i was asked to add some aditional information to it. My bos would like to place the total on top as a peramitter with a actual and a 25% extra. is this possile?

or Is there other ways in revit i can create this schedule? Like using code or something like that and keep the live data information?

I have also uploade the revit 2014 file i am working on and a excel spread sheet of what i am trying to make it look like.

[Anonymous]

I looked at your xlsx file.

I think there are 2 scenarios:

1) The totallized values of quantity outlet and cables needs to be calculated.This can't be done. You can add the field 'count' and setup the schedule to totallize, however the totallized value can't be used in a schedule. You can use the API to calculated these values and put them in a paramter of a room and add them in a schedule, however this insn't live. So, you always need to have an update function to get the correct values.

2) The totallized values of quantity and cables is a parameter of a room (so it's typed manually). If this is the case, the 25% fields can be 'calculated value' field. No API needed. As long as the quantities are typed correctly, this will be live.

I both cases, it's not ideal.