Google Spreadsheet Post #824
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Oct 24, 2012
So if you have a list of qty and assemblies, and multiple columns after each that list parts of the assemblies. You would want to multiply the qty by the number of parts needed to get a sum at the bottom of each column of parts that would tell you how many of that part you needed to assemble the required qty.
What I am using now for the total cells at the bottom of each column is:
I have over 50 assemblies, so this will get quite huge
I have a small example sheet here : https://docs.google.com/
You can see how I built the above formula in cell C9 and then dragged it down the row to fill in the other columns' totals.
In my example, I need 4 widgets, and each one requires 2 1" bars and 2 2" hex bolts, so to make 4 widgets I would need 8 bars and 8 bolts.
At the bottom of each column of parts is the total number of that part required to make the list of assemblies.
The current method works, but is crude and makes for very very long formulas that are time consuming to edit. Is there a better way?
Thanks in advance for any light you may be able to shine on this issue!