TABLE OF CONTENTS
    1. EXCEL-BOM-FREE, excel_bom_free.exe, free version, free distribution, advertising depends on the naming/renaming of the program 1. 
    2. DESCRIPTION OF OPERATION 2. 
        2.1 COPYING AND RENAME THE PROGRAM TO PROMOTE YOUR BRAND 2.1 
        2.2 BOM CALCULATION IS A MULTILEVEL CALCULATION 2.2 
        2.3 PLACING FORMULAS IN TABLES 2.3 
    3. DATA SECURITY AND PROTECTION OF USER PRIVACY 3. 
    4. EXCEL-BOM-PAID, excel_bom_paid.exe, paid version, free distribution, permanent advertising 4. 
    5. PROMOTE YOUR BRAND WITH OUR OTHER PROGRAMS (utilities4promoting) 5. 



Last change (yyyy.mm.dd): 2026.08.07

    1. EXCEL-BOM-FREE, excel_bom_free.exe, free version, free distribution, advertising depends on the naming/renaming of the program
    The program creates calculation models (creates formulas) that enable the calculation of components in the bill of materials (BOM).
    Before using the program, we recommend viewing the web address:
    https://en.wikipedia.org/wiki/Bill_of_materials 
    
    Demo BOM Excel table (demo_bom.csv):
    http://www.utilities4promoting.com/calc-utilities/excel-bom-free/demo_bom.csv 
    Demo BOM Excel table (demo_bom.xlsx):
    http://www.utilities4promoting.com/calc-utilities/excel-bom-free/demo_bom.xlsx 
    Demo BOM Excel formulas (efg_bom.htm):
    http://www.utilities4promoting.com/calc-utilities/excel-bom-free/efg_bom.htm 
    
    Program excel_bom_free.exe:
    http://www.utilities4promoting.com/calc-utilities/excel-bom-free/excel_bom_free.exe 
    bom.zip:
    http://www.utilities4promoting.com/calc-utilities/excel-bom-free/bom.zip 
    
    The free and paid versions of the program have no restrictions on copying and further distribution.
    
    2. DESCRIPTION OF OPERATION
    Based on minimal input data, the program creates a group of MS Excel formulas for calculating component elements in the bill of materials.
    The offered formulas only need to be copied into the BOM table and the calculation is performed immediately without additional editing.
    
        2.1 COPYING AND RENAME THE PROGRAM TO PROMOTE YOUR BRAND
        The excel_bom.free.exe program is a free program, but it must be renamed to actually work.
        The program promotes your website by inserting your web link into the output file with formulas.
        The program decomposes the web address of your web portal from the program name, so the excel_bom_free.exe program must be copied
        and renamed accordingly.
        
        Rename the program according to the address of your website, but the condition is that the new program name begins
        with http..., https..., www...
        URL: http://alsoldbooks.com , renamed program: http.alsoldbooks.com.exe
        URL: https://alsoldbooks.com , renamed program: https.alsoldbooks.com.exe
        URL: http://www.alsoldbooks.com , renamed program: www.alsoldbooks.com.exe
        URL: https://www.alsoldbooks.com , renamed program: www.alsoldbooks.com.exe
        
        2.2 BOM CALCULATION IS A MULTILEVEL CALCULATION
        Therefore, the BOM table must be created in accordance with the BOM structure.
        Subordinate levels (component elements) are defined so that the element record is shifted one field to the right.
        Each element in the table has two pieces of information:
        - alphanumeric code (ID)
        - numeric data for the quantity
        
        2.3 PLACING FORMULAS IN TABLES
        Before using the program, it is necessary to foresee and provide space for placing the formulas in the BOM table.
        In certain cases, it is necessary to create a separate table just for the needs of placing formulas.
        Program write formulas and placement instructions in output files:
        - efg_bom.htm
        
    3. DATA SECURITY AND PROTECTION OF USER PRIVACY
    The paid version of program does not connect to the web, does not display third-party ads,
    and does nothing that could compromise data security and user privacy.
    
    4. EXCEL-BOM-PAID, excel_bom_paid.exe, paid version, free distribution, permanent advertising
    http://www.utilities4promoting.com/calc-utilities/excel-bom-paid/index.htm 
    
    5. PROMOTE YOUR BRAND WITH OUR OTHER PROGRAMS (utilities4promoting)
    The programs have a dual purpose. They are computer tools for increasing personal productivity
    and at the same time a marketing and communication channel for online providers of goods and services.
    The common feature of the programs is that they index the output *.HTML files for all words that have
    at least three (3) letters and place advertising messages in the index of all words.
    The programs are customized for each customer and retrieve advertising messages from the web address
    defined by the customer of the program when ordering.
    http://www.utilities4promoting.com/index.htm 

This document was structured using the TXT-INDENT program.
More info: www.utilities4promoting.com