Announcement

Collapse
No announcement yet.

Greatest of formula used with material takeoff schedule

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

    Greatest of formula used with material takeoff schedule

    Hello

    I'm trying to create a material takeoff schedule, with some sort of greatest of formula, to calculate material informations.

    Example 1: a wall membrane layer is has a dimension of 0 m³, but a areal af 10 m², and if I want to calculate the weight for example if has to be a "m² x weight" formula.

    Example 2: a beam has a dimension of 1 m³, so the formula has to be "m³ x weight"

    My questions is then, is the a way to make a formula like this: "The greatest of (m² or m³) x weight", so a can use the same formula, for all calculations?
    Tags: calculated parameter, formula, greatest of formula, material takeoff, schedule parameters
    #2
    When I installed roofs the Felt came in 15lb & 30lb roles for example. If I was wanting to solve for this in Revit I'd just get the total SQ FT of Membrane (felt) then get the info of how much of linear FT & width of the Felt Role to then solve for my volume.

    Maybe the missing peace of info is how is the membrane being Packaged to the site, & applied with overlap to get the real measurement?
    Last edited by cftrevizo; October 15, 2018, 02:49 PM.

    Comment

      #3
      You’ll need to neutralize the units first but then it’s an easy if/then.


      Sent from my iPhone using Tapatalk
      Greg McDowell Jr
      about.me/GMcDowellJr

      Comment

        #4
        Alright that make sense, could you show me how?


        Thanks

        Comment

          #5
          I got the units neutralized, but then I ran into another problem. I made a timber truss that got a volume of 0,11 m³ and a calculated area of 6,79 m²? But then the neutralized value of "m²" would be greater than the "m³". Is there a way to make a formula that is like, "if m³ > 0 it will use m³, but if m³ < or = 0 it will use m²"

          Comment

            #6
            if(m3>0,m3,if(not(m3>0),m2)
            Greg McDowell Jr
            about.me/GMcDowellJr

            Comment

              #7
              Thank you, but something is still wrong? is it missing a parenthesis?

              "Unexpected end of expression"
              Last edited by Krogstrup; October 17, 2018, 06:24 AM.

              Comment

                #8
                Yeah. Add one to the end.

                You could do some of this by trial and error, you know.

                Do you understand the syntax of the if/then? If not, I’d start there.


                Sent from my iPhone using Tapatalk
                Greg McDowell Jr
                about.me/GMcDowellJr

                Comment

                  #9
                  Thanks, but I already tried that formula:


                  if(m³>0,m³,if(not(m³>0),m²))



                  Then I get this error:
                  "Bad IF-statement format. It should be IF (<boolean>, <result-if-true>, <result-if-false>)."

                  Comment

                    #10
                    you're missing the <result if false> on your nested IF statement.

                    Comment

                    Previous 1 2 template Next

                    Related Topics

                    Collapse
                    Working...
                    X