Replying because I am also struggling to make the BOM feature useful for getting actual measurements of parts.
For my current woodworking project (a stage set that is a center balcony and two staircases hinged to that balcony) I have had to do the following:
1) Get the plug-in called BOM-CSV. Its available as on May/June 2017 in the Fusion plug-in pages.
2) Export the BOM using that plugin, not the native BOM tool. It will create a CSV file where you tell it to.
All the items, measurements, and info about them will be in one column, except for the material which appears in its own column for some reason.
This isn't useful as it is, so you need to edit the CSV file to create new columns and replace unnecessary information in the CSV's second column.
3) Open in Notepad or equivalent.
ADD "," two times after the heading "Dimension" (this prepares for replacing the many " x " entries, keeping the columns consistent)
FIND/REPLACE all instances of ";" with ","
FIND/REPLACE all instances of " x " with ","
FIND/REPLACE all instances of any other extraneous data with null.
4) Open the CSV file in Excel.
You should now see a 6-column spreadsheet. May have weird extra stuff at the top. Delete that weird stuff - in my case it was leftovers from the text editor.
The dimensions will be in columns C, D and E - but they are not in size order (smallest to largest dimension, as would be needed to create cutlists)
Excel won't do this type of sorting in its normal "sort" interface, so it is formula time!
In columns G, H, and I create the sorting formulas for rearranging these values without re-sorting the entire spreadsheet.
Cell G2 gets =SMALL($C1:$E1,1) Cell H2 gets =SMALL($C1:$E1,2) Cell I2 gets =SMALL($C1:$E1,3)
Pull-down the formula to the bottom of your data, on each column.
Now copy the cell range created by the formulas and paste the VALUES back into the original cells. Don't just paste - that'll be no fun.
You can delete columns G, H, and I now if you want.
Next sort by material, size, or other criteria you personally need to sort by - using Excel's plain vanilla sort interface.
What you have now is a sheet with everything sorted and with the size numbers appearing lowest to highest, left to right.
But wait - you will also have a bunch of stuff that doesn't make sense - any of your non-rectangular and non-right-angle to origin planes components.
Some of these are easy - use the BOM data to calculate the hypotenuse for any parts that merely sit at an angle to ONE origin plane.
But as to the rest - if the part sits at an angle to MORE THAN ONE origin plane, or if the part is shaped such that it's Fusion bounding box doesn't reflect the real measures of the part - Ha ha.
Been hunting for almost a week here and there on Google and of course in this community.
Have not found a way to resolve getting Fusion to supply a list of REAL MEASURES on parts, not bounding box measures.
Hope anyone else finding this can at least make headway with the method I describe.
Please PM me if you figure out how to export actual measures instead of bounding boxes.
Fusion
