Create a Fiber InternalBOM Template
- Open the sample FiberCopperBOMTemplate.xls file in Microsoft Excel.
- Do a Save As to create your
own named Bill of Material template. The following sample fields are displayed
in the Excel Spreadsheet displaying some of the BOM functions:
When the BOM creation is launched, the values in the cells containing the BOM Functions are automatically replaced with the values computed by the BOM application.
- In this template shown
above, all the values in Column A, rows 1-7 are user-defined fixed values that
will stay the same each time this template is used for a BOM. The values in
cells A-10, 14, 17, and A-20 contain functions from the list of BOM functions
described below. The values in Column B-2 and 3 are functions, and cells
B-23-26 contain fixed values that the user has defined as labels pointing to
the column C functions for those same cells. Column D cells are fixed price
values entered by the user, and Column E contains the results of the formulae
that were entered in column E. This is the Internal BOM report the sample
template above generated:
The next page shows the sample Commstownspatial template and the InternalBOM functions that were used in that template. Below the caption is a list of InternalBOM functions that can be used to create a custom template. Any or all of these functions can be incorporated into a custom InternalBOM report:
The Internal BOM functions that are available are:- [BOM DATE]: Retrieves the current date.
- [BOM TIME]: Retrieves the current time.
- [BOM FILENAME]: Retrieves the active file name.
- [BOM USER]: Retrieves the username who created the BOM.
- [+Feature]: Retrieves
the count of a specific feature encountered in the active file.
example: [+Splice] means number of splices.
- [@Property.Feature]:
Retrieves the sum of a numerical feature encountered in the active file.
example: [@Length.Sheath] means sum of sheath length.
- [+Feature.Property=value]: Retrieves the count of a specific feature property encountered in the active file. example: [+Splice.Model=NAP] means number of NAP model splices.
- [@Property1.Feature.Property2=value]:
Retrieves the sum of a numerical feature property encountered in the active
file.
example: [@Length.Sheath.Model=AERIAL] means sum of sheath lengths where model = AERIAL
- [~Feature.Property]:
List the entire property feature encountered in the active file.
example: [~Sheath.Model] means list all the sheath’s model.
- Any Excel formula can be added to any cell to calculate column or row totals.
- Add images, cell formatting, borders and colors to ‘standardize’ the BOM to company requirements.
- Once completed, save the FiberCopperBOM template. After the template has been edited and saved, the Internal BOM is ready to be run.