Estimating
Estimating could include material take-offs for simple quantities or complex pricing. Whether you... View more
Organizer:
- Organized by
-
-
Working with data tables
-
Working with data tables
Some of the design drawings we receive provide tables of data. A recent example provided 260 rows of data about pipe sizes and lengths between roof drain fittings. I use a series of custom perimeter tools to measure each pipe run, but need to refer to the table to determine the pipe size between the fittings.
The challenge was that order that the information was provided in the table. The first row was for a fitting/pipe at Building 2. The second row started a group of Building 5 fittings – but in basically a random order. Then there were 2 rows for Building 4 followed by 3 rows for Building 5 then 1 row for Building 3 – you get the idea.
After pulling my hair out for more lines than I’d like to admit I remembered an idea I had the last time I had to go through this exercise – exporting the data to Excel!
Using “File>Export>Excel Workbook>Page Region” I was able to quickly copy the data to an Excel workbook and then sort the information alphabetically! This made it sooo much faster to find the information that I needed!
+2
-
6 Replies
-
Points: 24,547Rank: UC2 Brainery Brown Belt IIII
I was just about to mention the export to Excel tool, but made sure I finished reading. As expected you already did that. Great job! Thanks for sharing!
+2 -
Points: 14,269Rank: UC2 Brainery Blue Belt IIII
Also great for getting the info out of manhole schedules @DavidCutler !
+3 -
Points: 15,956Rank: UC2 Brainery Advanced Blue Belt
I do this all the time with schedules, Door, Millwork, etc.
It just makes it so much easier.+2-
Points: 28,004Rank: UC2 Brainery Advanced Brown Belt I
I may just work this right into my workflow going forward….
0-
Points: 15,956Rank: UC2 Brainery Advanced Blue Belt
if you run into any issue where you need to clean your data, go back and watch the back to back MCR’s I did on cleaning up PDF data.
I can also send you the basic recipe for cleaning stacked headers
+1-
Points: 28,004Rank: UC2 Brainery Advanced Brown Belt I
Thank you for the reminder about that MCR episode. I remember seeing you do that live…
+1
-
-
-
Log in to reply.