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

Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 25
Like Tree8Likes

Thread: Total Cost in a schedule

  1. #11
    Moderator
    "Mark Twain"
    mdradvies's Avatar
    Join Date
    December 16, 2010
    Location
    Boxtel, Netherlands
    Posts
    4,551
    Current Local Time
    02:22 AM
    Repped AND PotM!

  2. #12
    Moderator
    "OMG I killed Revit"
    dzatto's Avatar
    Join Date
    December 9, 2010
    Location
    Dallas, TX
    Posts
    5,234
    Current Local Time
    09:22 PM
    Oh yeah, POTM. I forgot we did that.

  3. #13
    Moderator
    "Mark Twain"
    mdradvies's Avatar
    Join Date
    December 16, 2010
    Location
    Boxtel, Netherlands
    Posts
    4,551
    Current Local Time
    02:22 AM
    Don't even know if we still do that but it adds another two points to this little gem

  4. #14
    Forum Addict
    Join Date
    January 27, 2011
    Posts
    2,007
    Current Local Time
    12:22 PM
    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. #15
    Junior Member Stuntmonkee's Avatar
    Join Date
    December 8, 2010
    Location
    Phoenix, Arizona, USA
    Posts
    40
    Current Local Time
    07:22 PM
    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. #16
    Moderator DaveP's Avatar
    Join Date
    January 10, 2011
    Location
    St Paul, MN
    Posts
    2,949
    Current Local Time
    09:22 PM
    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. #17
    Forum Addict
    Join Date
    January 27, 2011
    Posts
    2,007
    Current Local Time
    12:22 PM
    More on embedded schedules can be found at:
    What Revit Wants: Revit 2013 - Embedded Schedules for everyone

  8. #18
    Moderator
    "Mark Twain"
    mdradvies's Avatar
    Join Date
    December 16, 2010
    Location
    Boxtel, Netherlands
    Posts
    4,551
    Current Local Time
    02:22 AM
    Quote Originally Posted by Stuntmonkee View Post
    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. #19
    Member anthonyB's Avatar
    Join Date
    August 31, 2011
    Location
    Sydney, Australia
    Posts
    409
    Current Local Time
    12:22 PM
    Is it possible to perform math on the Grand Total values?
    Total Cost in a schedule-20170521-areascheduletest.jpg
    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.
    Is that possible please?
    Thanking you in advance.
    Anthony

  10. #20
    Senior Member ekkonap's Avatar
    Join Date
    May 23, 2011
    Location
    Netherlands
    Posts
    576
    Current Local Time
    04:22 AM
    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 FirstFirst 123 LastLast

Similar Threads

  1. Cost field in topography schedule
    By nicktanner1 in forum Architecture and General Revit Questions
    Replies: 0
    Last Post: May 30th, 2012, 05:19 PM
  2. Replies: 1
    Last Post: May 20th, 2012, 08:26 AM
  3. Replies: 0
    Last Post: April 18th, 2012, 07:15 AM
  4. David Light: Googles total failure to know who you are
    By David Light Blog in forum Blog Feeds
    Replies: 0
    Last Post: March 17th, 2012, 01:17 AM
  5. TOTAL Duct Lengths in Schedules?
    By Roger in forum MEP - General
    Replies: 8
    Last Post: September 12th, 2011, 08:41 PM

Posting Permissions

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