drew.spriggs
Active member
Howdy,
I've seen people post about this on FB/Reddit, so figure of all places here it will probably be useful too. While the build docs are pretty good, it is a bit frustrating not having values/quantities immediately available. I figured out an easy workflow to get them.
Download the build docs as a PDF, and open them in standalone Adobe (won't work from a browser). Copy/paste the part type colums and values straight into Excel or Google Sheets, then use Data>Split text to Columns to get everything in a usable column. From there, add a row next to the split data, and run the UNIQUE function (=UNIQUE(Range)) on the value column to grab each individual value from the list. From there, move a column over and use the CountIF function (=Countif($Range$, unique value)) to grab a count for each part. Make sure you use the $ command so the range doesn't shift, then you can just copy/paste down for as many rows as you have unique values.
Using this workflow, you can get a buy list in about 30s of work.
I've seen people post about this on FB/Reddit, so figure of all places here it will probably be useful too. While the build docs are pretty good, it is a bit frustrating not having values/quantities immediately available. I figured out an easy workflow to get them.
Download the build docs as a PDF, and open them in standalone Adobe (won't work from a browser). Copy/paste the part type colums and values straight into Excel or Google Sheets, then use Data>Split text to Columns to get everything in a usable column. From there, add a row next to the split data, and run the UNIQUE function (=UNIQUE(Range)) on the value column to grab each individual value from the list. From there, move a column over and use the CountIF function (=Countif($Range$, unique value)) to grab a count for each part. Make sure you use the $ command so the range doesn't shift, then you can just copy/paste down for as many rows as you have unique values.
Using this workflow, you can get a buy list in about 30s of work.
