Goal amount for this year: 3000 USD, Received: 1207 USD (40%)

# Thread: Total Cost in a schedule

1. Repped AND PotM!

2. Oh yeah, POTM. I forgot we did that.

3. Don't even know if we still do that but it adds another two points to this little gem

4. The principle is essentially the same as that described in my post:
What Revit Wants: Percentage of Item Count to Total Count in a Schedule

5. So to comlicate this a bit further. Lets say that you want to figure out the SF cost of those units.

Basically (cost/area)

This works if each item IS itemized, but when you DON'T itemize each instance and then select it as a calulated field it results in the combined value of each individual SF Cost calulation.

So taking similar methods. If I wanted to seperate the units to individual levels or areas, how could I find the cost per SF of those levels or areas as a combined value?

6. The technique I was talking about is more value when you're looking at "things" - Furniture, Equipment, Doors - things that are physical. They don't have an area.
If you want to get at areas, that's a Room schedule. You'd probably have to figure out some method of Sorting and Grouping and use the "Calculate Totals" on a field to get those. Or am I not understanding what you want?
Perhaps Luke's post on Embedded Schedules would be a possibilty.

7. More on embedded schedules can be found at:
What Revit Wants: Revit 2013 - Embedded Schedules for everyone

8. Originally Posted by Stuntmonkee
So to comlicate this a bit further. Lets say that you want to figure out the SF cost of those units.

Basically (cost/area)

This works if each item IS itemized, but when you DON'T itemize each instance and then select it as a calulated field it results in the combined value of each individual SF Cost calulation.

So taking similar methods. If I wanted to seperate the units to individual levels or areas, how could I find the cost per SF of those levels or areas as a combined value?
It's possible with ordinary schedules too... There are a few things you need to do:

1. Sort your schedule on the units you want to differentiate on.
2. Add a calculated value, percentage, which calculates the percentage of a single element to the unit total (that's why you need to sort on units, otherwise you can't use the unit total in the percentage calculation)
3. Multiply Area by percentage in a calculated value, and check the "calculate totals"
4. Check off "Itemize every instance". If you did it correctly it now shows proper totals.

This takes some fudging to get it right. If you can't get it done, post an example.

9. Is it possible to perform math on the Grand Total values?

My schedule shows:
* The total area of the carpark on two levels of the building,
* The number of parking spaces on that level (a manual value the user enters),
* The area that these parking spaces occupy (a calculated value),
* The parking efficiency percentage via two calculated value methods.
These efficiency values work fine for each entry in the schedule.
I would also like to determine the overall efficiency.
I want to divide the grand total of carparking area by the grand total of the parking spaces to determine an overall percentage.
Anthony

10. Sure: https://www.revitforum.org/tutorials...al-mayhem.html

By the way, why enter values manually? We tend to model them early on, proper parking places are not very accomodating.

Page 2 of 3 First 123 Last

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•