Wednesday, October 24, 2012

yogi_Compute Total Number Of Each Part Required For Specified Quantity Of Assemblies

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Oct 24, 2012

Parts Assembly Inventory
OK, I thought this would be simple, but it's quickly becoming a monster - I'll try to give good examples.  I have searched and found nothing useful, so I'm at a loss here. I can't believe nobody has ever needed to do this!

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:

=sum(\$B2*C2)+sum(\$B3*C3)+sum(\$B4*C4)+sum(\$B5*C5)+sum(\$B6*C6)+sum(\$B7*C7)+sum(\$B8*C8)...

I have over 50 assemblies, so this will get quite huge