[Dan Diesing]

It’s more on the side of the actual tracings that I would like to find a faster solution. A lot of the projects don’t have repetitive units, as shown in that screenshot (probably not the best screenshot to use). For instance, it will be 16 units per floor in a 6-story wood-frame building. 2-5 are the same layout, so that’s easy, but every unit on the floor is a different layout.

[Dan Diesing]

Thanks for the replies. I will be looking into PQ now!

[Dan Diesing]

Thanks for the input.

Sounds like a similar flow to what I’m doing.

Try to do only unit types, but more and more projects are having so many unit types (almost no repeats per floor).

I have gone through doorways, but didn’t find much time savings. I am pretty fast at doing the takeoffs, but as my role expands at my current company, I am trying to find any time savings I can.

I was hoping there would be some solution that I was missing, but it does not seem like we are there yet. Maybe in the near future we will have it.

[Dan Diesing]

Thanks, I forgot to mention that I had already sync’d the names between the 2 tables (just wasnt at my work computer for new screenshot).

I will look into pivoting the Columns. Lots to learn, trying to fit it into a busy schedule and still get the work done.

I appreciate the guidance.

[Dan Diesing]

Thanks for checking in Doug. I’m sorry for not getting back to you sooner. It’s been a deep rabbit hole, I also took on another project while trying to learn this. I have had to brush up on my VBA scripting for the other project.

I have got my data almost where I need it to be with power query. It is usable but I’m stuck on the transformation (haven’t had any time to dig into it so it might be simple). Top Table is how I currently have my data. My spreadsheet (how the bosses want it) is the bottom table.

My makeshift workaround is to just pull the data in with this formula:

=IFERROR(INDEX($E$22:$E$40, MATCH(E$6 & $B8, $C$22:$C$40 & $D$22:$D$40, 0)), “0”)

It works but if i get bigger sets of data with more buildings or floors I don’t want to have to tediously double check everyone is working right

[Dan Diesing]

Thanks David,

Currently, everything is done in Excel. I have a decent template made up that once I had the data input into it with quantity link, it would populate all other pages with relevant data. All I would really need to do is update pricing for labor and materials.

[Dan Diesing]

After browsing a few things today. This is exactly what I was looking for (even though not quantity link, didn’t need to be) but now it seems like I have a lot of learning to do! Should make everything more streamlined.

After I get this figured out, I’ll look at ways to optimize my Revu counting/measuring. Hopefully find some more tips and tricks.