Carl Wegman
MemberForum Replies Created
-
Points: 590Rank: UC2 Brainery White Belt
Can you share your custom column formula?
What options are you selecting, as well…
-
Points: 590Rank: UC2 Brainery White Belt
I use a count tool and put the column information in the label.
e.g. Column Count W12x26 @ 32′
I do output markups to an excel file and calculate the weight(s) in excel.
-
Points: 590Rank: UC2 Brainery White Belt
-
-
Points: 590Rank: UC2 Brainery White Belt
Admire your ability to check a formula and compare to Bluebeam quantity vs Chat GPT.
Have you tried MS Copilot?
-
Points: 590Rank: UC2 Brainery White Belt
This depends on the document’s author.
Here are some things you can ask the author to consider. (from Procore)
-
Points: 590Rank: UC2 Brainery White Belt
Sorry, the links don’t display on the Forum but the downloads DO open in Revu…
-
-
Points: 590Rank: UC2 Brainery White Belt
Don’t know how to change the output of your CSV file.
Do know how to make a formula in excel to convert decimal feet to feet and inches.
Would that help you at all?
Noteworthy that this type of excel formula would involve formatting, perhaps your steel import file needs the feet and inches formatted in a specific format? Also, what is the accuracy your are seeking? nearest 1/16″?
-
Points: 590Rank: UC2 Brainery White Belt
Here is an excel formula that assumes your decimal feet measurement is in cell A2.
This is from the Microsoft website.
=TRIM(INT(MROUND(A2*12, 0.0625)/12) & ” ft ” & TEXT(MOD(MROUND(A2*12, 0.0625),12),” # ?/?? \i\n”))
-
-
Points: 590Rank: UC2 Brainery White Belt
This is an example of custom columns.
Metal siding panels and insulated metal panels (IMPs) can only be acquired in full pieces. Different manufacturers limit cut off lengths different ways. For estimating, these custom columns allow changing the siding piece width (default s 42″ for IMP) and round up to the nearest length in feet. This example is an area measurement (e.g. an elevation). Pricing is typically based upon a number of factors including length, SF, truckloads, etc. This column example doesn’t address pricing, as manufacturers differ.
Note: This page was set up with layers that I typically use…
-
Points: 590Rank: UC2 Brainery White Belt
What unit is the length in? mm?
-
Points: 590Rank: UC2 Brainery White Belt
-
Points: 590Rank: UC2 Brainery White Belt
Set line weight to 0 point (zero)?