{"id":191,"date":"2013-07-18T23:58:48","date_gmt":"2013-07-18T23:58:48","guid":{"rendered":"https:\/\/www.xrev.com.au\/news\/?p=191"},"modified":"2013-09-25T22:39:39","modified_gmt":"2013-09-25T22:39:39","slug":"bim-day-out-revit-formulas","status":"publish","type":"post","link":"https:\/\/www.xrev.com.au\/news\/bim-day-out-revit-formulas\/","title":{"rendered":"BIM Day Out – Revit Formulas"},"content":{"rendered":"

Xrev is currenty attending BIM Day Out<\/a> in Perth, Australia. \u00a0We have 2 speaking spots. \u00a0A lab on Revit Formulas and a discussion panel on Revit Manufacturer Content. \u00a0The first, from the feedback seemed to very successful. \u00a0I was a little concerned considering the complexity of the subject matter and the fact it had to be crammed into less than an hour.<\/p>\n

For this session, essentially I had setup a single family containing a number of issues you may face with content creation and how to go about using formulas to make a user friendly solution. \u00a0Below is the formulas we generated, for those that have the datasets and were unable to keep up or forgot to save…<\/p>\n

    \n
  1. Stopping an array breaking\n
      \n
    1. if(Task 1 Length \/ Task 1 Spacing < 2, 2, Task 1 Length \/ Task 1 Spacing)<\/li>\n<\/ol>\n<\/li>\n
    2. Control the number of\u00a0 connectors\n
        \n
      1. if(Task 2 Connector,3,2)<\/li>\n<\/ol>\n<\/li>\n
      2. Control elements based on Family Type selections\n
          \n
        1. if(Task 3 Type = Task 3 Size 1, “1”, if(Task 3 Type = Task 3 Size 2, “2”, “3”))<\/li>\n<\/ol>\n<\/li>\n
        2. Using Trigonometry\n
            \n
          1. Task 4 Offset X * tan(Task 4 Angle)<\/li>\n<\/ol>\n<\/li>\n
          2. Visibility that is mutually exclusive\n
              \n
            1. Task 5 Value = 1, Task 5 Value = 2, Task 5 Value = 3<\/li>\n<\/ol>\n<\/li>\n
            2. Formulas to display error messages\n
                \n
              1. if(and(Task 6 Length > 1000 mm, Task 6 Error), “Too big”, if(and(Task 6 Length < 500 mm, Task 6 Error), “Too Small”, “”))<\/li>\n
              2. or(Task 6 Length > 1000 mm, Task 6 Length < 500 mm)<\/li>\n<\/ol>\n<\/li>\n
              3. Controlling a Void cut\/uncut\n
                  \n
                1. if(Task 7 Cut, 0 mm, 220 mm)<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

                  For those with the datasets these will make a lot more sense.<\/p>\n

                  There was also a little trick that I wanted to get to but ran out of time. \u00a0 It is possible to hide\u00a0shared parameters from end users by editing the share parameters file.<\/p>\n

                   <\/p>\n

                  \"\"<\/a>

                  Hidden Parameters in a shared parameter file<\/p><\/div>\n

                  By changing the last integer to 0, you are effectively hiding the parameter from the end user…<\/p>\n

                  Finally, if you need to write lots of nested if statements it can be somewhat tedious. \u00a0I have generated an excel file that allows you to specify the values and the conditions and then there is a formula in the cell that can be “filled down” to write the Revit formula for you. \u00a0Then all you need to do is copy the bottom formula into your family and your done… \u00a0No need to worry about missing a bracket or syntax errors…<\/p>\n

                  \"\"<\/a>

                  Excel Script<\/p><\/div>\n

                  Download the Excel file here<\/a><\/p>\n

                  Let me know if you find this useful!<\/p>\n","protected":false},"excerpt":{"rendered":"

                  Xrev is currenty attending BIM Day Out in Perth, Australia. \u00a0We have 2 speaking spots. \u00a0A lab on Revit Formulas and a discussion panel on Revit Manufacturer Content. \u00a0The first, from the feedback seemed to very successful. \u00a0I was a … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[26,9],"class_list":["post-191","post","type-post","status-publish","format-standard","hentry","category-promotion","tag-formulas","tag-revit"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.xrev.com.au\/news\/wp-json\/wp\/v2\/posts\/191","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.xrev.com.au\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xrev.com.au\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xrev.com.au\/news\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xrev.com.au\/news\/wp-json\/wp\/v2\/comments?post=191"}],"version-history":[{"count":0,"href":"https:\/\/www.xrev.com.au\/news\/wp-json\/wp\/v2\/posts\/191\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.xrev.com.au\/news\/wp-json\/wp\/v2\/media?parent=191"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xrev.com.au\/news\/wp-json\/wp\/v2\/categories?post=191"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xrev.com.au\/news\/wp-json\/wp\/v2\/tags?post=191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}