PROMOTE YOUR BRAND WITH OUR PROGRAM
This space is reserved for your advertising message and web links.
The advertising message is limited to 10 lines or 500 characters.
The program is tailored individually for each client.
More info: http://www.utilities4promoting.com/calc-utilities/index.htm
Program creates EXCEL formulas for calculating the BOM table (Bill of materials)
This document was created using the excel_bom_free.exe program.
The program www.delo.si.exe has been copied and renamed excel_bom_free.exe.
Useful link added by the program www.delo.si.exe:
http://www.delo.si
Introduction
BOM table (Bill of materials)
https://en.wikipedia.org/wiki/Bill_of_materials
Column name start with data = E
Row number start with data = 3
Column name end with data = K
Row number end with data = 25
Column name start with free (formulas) area = N
--------------------
step = 1
=IF(E3<>"";F3;"")
Copy formula in cell N3.
Then copy the formula from that cell down the entire column to the end of the table.
--------------------
step = 2
=IF(ISNUMBER(N3);N3;O2)
Copy formula in cell O3.
Then copy the formula from that cell down the entire column to the end of the table.
--------------------
step = 3
=IF(ISNUMBER(G3);G3;"")
Copy formula in cell P3.
Then copy the formula from that cell down the entire column to the end of the table.
--------------------
step = 4
=IF(ISNUMBER(H3);H3;"")
Copy formula in cell Q3.
Then copy the formula from that cell down the entire column to the end of the table.
--------------------
step = 5
=IF(ISNUMBER(I3);I3;"")
Copy formula in cell R3.
Then copy the formula from that cell down the entire column to the end of the table.
--------------------
step = 6
=IF(ISNUMBER(J3);J3;"")
Copy formula in cell S3.
Then copy the formula from that cell down the entire column to the end of the table.
--------------------
step = 7
=IF(ISNUMBER(K3);K3;"")
Copy formula in cell T3.
Then copy the formula from that cell down the entire column to the end of the table.
--------------------
step = 8
=IF(ISNUMBER(P3);(P3*O3);"")
Copy formula in cell U3.
Then copy the formula from that cell down the entire column to the end of the table.
--------------------
step = 9
=IF(ISNUMBER(Q3);(LOOKUP(2;1/(U2:U$3<>"");U2:U$3)*Q3);"")
Copy formula in cell V3.
Then copy the formula from that cell down the entire column to the end of the table.
--------------------
step = 10
=IF(ISNUMBER(R3);(LOOKUP(2;1/(V2:V$3<>"");V2:V$3)*R3);"")
Copy formula in cell W3.
Then copy the formula from that cell down the entire column to the end of the table.
--------------------
step = 11
=IF(ISNUMBER(S3);(LOOKUP(2;1/(W2:W$3<>"");W2:W$3)*S3);"")
Copy formula in cell X3.
Then copy the formula from that cell down the entire column to the end of the table.
--------------------
step = 12
=IF(ISNUMBER(T3);(LOOKUP(2;1/(X2:X$3<>"");X2:X$3)*T3);"")
Copy formula in cell Y3.
Then copy the formula from that cell down the entire column to the end of the table.
--------------------
step = 13
=IF(ISNUMBER(U3);IF(AND(V3="";V4="");F3;"");IF(AND(ISNUMBER(O3);ISNUMBER(O2));IF((AND(O3<>O2;O3<>O4));E3;"");""))
Copy formula in cell Z3.
Then copy the formula from that cell down the entire column to the end of the table.
--------------------
step = 14
=IF(ISNUMBER(V3);IF(AND(W3="";W4="");G3;"");"")
Copy formula in cell AA3.
Then copy the formula from that cell down the entire column to the end of the table.
--------------------
step = 15
=IF(ISNUMBER(W3);IF(AND(X3="";X4="");H3;"");"")
Copy formula in cell AB3.
Then copy the formula from that cell down the entire column to the end of the table.
--------------------
step = 16
=IF(ISNUMBER(X3);IF(AND(Y3="";Y4="");I3;"");"")
Copy formula in cell AC3.
Then copy the formula from that cell down the entire column to the end of the table.
--------------------
step = 17
=IF(ISNUMBER(Y3);IF(AND(Z3="";Z4="");J3;"");"")
Copy formula in cell AD3.
Then copy the formula from that cell down the entire column to the end of the table.
--------------------
step = 18
=XLOOKUP("*";Z3:AD3;Z3:AD3;"";1)
Copy formula in cell AE3.
Then copy the formula from that cell down the entire column to the end of the table.
--------------------
step = 19
=IF(AND(AE3<>"";MAX(U3:Y3)>0);IF(MAX(U3:Y3)>0;MAX(U3:Y3);"");N3)
Copy formula in cell AF3.
Then copy the formula from that cell down the entire column to the end of the table.
--------------------
step = 20
=IF(AE3="";"";IF(COUNTIF(AE2:AE$3;AE3)>0;"";SUMIF(AE$3:AE$25;AE3;AF$3:AF$25)))
Copy formula in cell AG3.
Then copy the formula from that cell down the entire column to the end of the table.
--------------------
step = 21
=IF(AG3<>"";AE3;"")
Copy formula in cell AH3.
Then copy the formula from that cell down the entire column to the end of the table.