Announcement

Collapse
No announcement yet.

Schedule Totals

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
    #1

    Schedule Totals

    I am currently scheduling structural framing, and I am trying to find out how I can get a grand total length of all beams in the project. I have 2 different types of C-Channel, but multiple lengths of each. I have the schedule formatted to sort by type and then by length, but I am looking to get a total length of all C-Channel of the same type. Is there a way to do this?

    Thank you
    Tags: None
    #2
    Sounds like your schedule should already be doing that. Did you set your length to calculate totals?
    Rob Pivovarnick, AIA
    Senior Project Architect
    Michael Graves Architecture and Design
    LinkedIn Profile | @ Twitter

    Comment

      #3
      I should've been clearer, my apology. I want individual piece lengths, a count of each piece, as well as a total length (for each size). I can't make a calculated total with Count * Length.

      Comment

        #4
        Does this help?
        Revit Forum
        https://www.revitforum.org/tutorials-tips-tricks/8582-total-cost-schedule.html
        Dave Plumb
        BWBR Architects; St Paul, MN

        CADsplaining: When a BIM rookie tells you how you should have done something.

        Comment

          #5
          Yes this does help, thank you! Since I have my schedule sorted by Length as well, I have multiple instances of (ex: C12 X 20.7#), so I was looking to get the total combined length of both those, but I do not think it is possible, this will suffice though. Thanks again!

          Comment

            #6
            Aaron's calculation from percentages might work for what you are looking to do. Essentially find the average length of all the pieces of one type and multiply it by the total number of said type.

            Door Calculations (from Totals)
            https://www.youtube.com/watch?v=VIS2_oXflzA
            A quick demo on new Door calculation possibilities. :)
            Rob Pivovarnick, AIA
            Senior Project Architect
            Michael Graves Architecture and Design
            LinkedIn Profile | @ Twitter

            Comment

              #7
              Just to clarify: What you see in the video is not finding the averages, and multiplying it out. Its using a percentage calculation to determine a given objects percentage of a larger total, and using that to "back the total value" in to a cell you can do calculations on, by multiplying by the inverse. Ekko Nap explained it in a thread called Total Mayhem. I just implemented it in my door library after the fact.
              Aaron "selfish AND petulant" Maller |P A R A L L A X T E A M | Practice Technology Implementation
              @Web | @Twitter | @LinkedIn | @Email

              Comment

                #8
                Originally posted by Dr2430 View Post
                Yes this does help, thank you! Since I have my schedule sorted by Length as well, I have multiple instances of (ex: C12 X 20.7#), so I was looking to get the total combined length of both those, but I do not think it is possible, this will suffice though. Thanks again!
                You can do this quite easily by having a Calc Value (called Combined Length?) = Length and having 1 that colum of Combined Length set to Calculate Totals and the original Column of Length set to not Calculate Totals.

                Then Sort your schedule by Type and by Length and make sure to include a Footer and a Blank line after the Sort by Type Option. No Percentage Calcs required.

                Comment

                  #9
                  Originally posted by Twiceroadsfool View Post
                  Just to clarify: What you see in the video is not finding the averages, and multiplying it out. Its using a percentage calculation to determine a given objects percentage of a larger total, and using that to "back the total value" in to a cell you can do calculations on, by multiplying by the inverse. Ekko Nap explained it in a thread called Total Mayhem. I just implemented it in my door library after the fact.
                  Thanks for clarifying Aaron, I know I've used that system for many non-door related things.
                  Rob Pivovarnick, AIA
                  Senior Project Architect
                  Michael Graves Architecture and Design
                  LinkedIn Profile | @ Twitter

                  Comment

                  Previous template Next

                  Related Topics

                  Collapse
                  Working...
                  X