Bill of materials

Bill of materials

The BOM view counts a procurement list from the layout through a profile. How to read it, fill what is open, edit a line and export it.

The bill of materials, the BOM, is a procurement list counted from the layout you have generated. A profile decides which items the list can hold and how each is specified; the design decides which of them apply and how many.

You do not type the list. Everything measurable is counted from the plant. What the layout cannot know, such as the CCTV system or the wind speed the structure is designed for, shows as a line that needs your answer. Your answers and edits sit on top of the count, so a new layout recounts the plant and keeps them.

Opening the BOM view

Click the BOM tab, or press Ctrl+6. The left column becomes the BOM panel under a green banner titled Bill of Materials, and the list takes the place of the plot. The status bar reads "BOM Mode ON — select a line to see how it is counted; edits apply as you type." Exit BOM gives the column back to the stage tabs. See Views for the other views.

The BOM view: the Bill of Materials column with Profile, Readiness, Line and Add a line on the left, and on the right the Plant table of items with makes, order quantity, basis, source and status, grouped by category.
The BOM view

The BOM is counted the first time the view opens after a Generate, or when an export needs it, under the message "Working out the bill of materials…". Before a layout exists the list reads "Generate a layout to count the plant." Water plots and plots with no tables are not counted.

The list

Nothing is edited in the list itself. Select a row and the Line card on the left shows how it is counted and what you can change.

Three controls run along the top: Plant | By block chooses the table, All | Needs attention filters it, and a search box looks through items, specifications and makes. By block adds a block selector, which starts on All blocks.

The Plant table

Lines are grouped by category, and each group's heading counts its lines and how many need attention.

ColumnWhat it holds
Item & specificationThe item's name, then its specification on a second line. The tooltip carries the line's notes and warnings
MakesThe makes you accept. The PV module and the inverter take theirs from the PAN and OND files
Order qtyThe quantity to order, with the design quantity beneath it and any allowance, such as 3,094 + 5 %. A dash means there is no quantity yet
BasisWhat the quantity comes from, or what is needed to get one
SourceMeasured, Rule or Manual
Status✓ Ready, or what the line is waiting for
SourceWhere the quantity comes from
MeasuredCounted from the design: modules, tables, cable lengths, earth pits
RuleA factor times something counted, such as one mounting stand per string inverter
ManualYou enter it

Order qty is the design quantity × (1 + allowance %), rounded up to the unit's precision.

UnitRounded up to
Nos, set, mWhole numbers
t, m², m³2 decimals
LS, MWpNot rounded

There is no rate or amount column.

The By block table

By block shows one column for each inverter control room (ICR) block, then Shared, Total and Unit. A quantity not tied to a block sits under Shared. An empty cell is zero.

The BOM view on By block with the first line selected: a column for each ICR, Shared, Total and Unit, the All blocks selector, and the line's card on the left.
The BOM by block

Total here is the design quantity, not the order quantity, so it leaves out the allowance. Choosing a block in the selector narrows the table to the lines with a quantity in that block. The block columns and the totals stay those of the whole plant.

Getting to ready

A line is ✓ Ready when it has a quantity and every required part of its specification. Otherwise it carries one status, the first that applies:

StatusWhat the line needsWhere to answer it
! Needs design inputSomething the design has not providedThe Go button, below
! Needs factorA factor for a rule whose factor is blankFactor on the Line card
! Needs quantityA manual quantityQuantity on the Line card
! Needs specificationA required specification fieldThe field marked with an asterisk on the Line card

A new plant always starts with open lines, because some answers cannot come from a layout. Dozens of manual lines need a quantity. The ICR cable tray, its canopy and the equipment-yard light need a factor, as do the earthing cable and lug for central inverters. MMS table (supply package) needs Basic wind speed, MMS being the module mounting structure. The tracker package needs Basic wind speed and OEM and model, and the Power transformer needs Voltage ratio.

The Readiness card

The card opens with the verdict, "✓ All 111 lines ready" or "! 71 of 125 lines ready", and filter chips for each status. Under them, each missing design input has a row saying what to do, where, and how many lines it holds up, with a Go button. Go leaves the BOM view and opens the place named.

Reason on the lineRow readsGo opens
"The AC rating comes from the inverter's OND file." or "Transformer ratings come from the inverter's OND file."Load an OND file · Electrical tabThe inverter card on the Electrical tab
"The module's Isc comes from its PAN file."Load the module's PAN file · Array tabThe module card on the Array tab
"Cable quantities come from the cable calculation, which is off."Turn on Calculate cables · Electrical tabThe Cables card
"No listed transformer rating is large enough for its load."Add a larger transformer rating · Electrical tabThe grouping card
"Piles are counted from the pile pattern, and none is defined."Define a pile pattern · Layout ▸ PilesThe pile window
"No inverters are placed yet."Generate the layout · Generate LayoutGenerate Layout
The Line card for MMS pile reading Needs design input, the sentence that piles are counted from the pile pattern and none is defined, the Define a pile pattern button, and the same step offered with Go under Readiness.
A line that needs a design input

Answer the rest from Needs attention: select a line and fill in what it asks for.

The BOM view with the verdict All 112 lines ready, the Plant table's status column reading Ready throughout, and the project's edits listed on the Profile card with Save as profile….
A BOM with every line ready

Editing a line

Select a line, and the Line card takes its name. It opens with the category, source, nature and status, such as "PV modules · Measured · Supply · ✓ Ready". Edits apply as you type. What the card shows depends on how the line is counted.

LineWhat the card shows
Waiting for a design inputThe reason and a button that opens the fix
MeasuredThe quantity and its basis, read-only
RuleFactor, 0 and up, and Design qty worked out, such as "1.0 × 3,144 strings = 3,144 Nos"
ManualQuantity, 0 and up
The Line card for the PV module: Measured, Supply and Ready, the measured quantity from the layout, Allowance, Order qty, the rated power from the Array tab, cable lead length, the make from the file, Remarks and Turn this entry off.
A measured line

Below that, on every line:

  • Allowance, 0 to 100 %, and the resulting Order qty.
  • The design values, read-only, each with its origin (from Array tab).
  • The specification fields, editable, with a list where the item type has set choices. Required ones are marked with an asterisk.
  • Makes: type into Add a make to add one, or remove one from its chip. The PV module and inverter show "from the file" instead.
  • Remarks.
  • Turn this entry off, or Remove this line on a line you added.
The Line card for DC solar cable with the All 2 sizes and This size only switch, the measured length, Allowance, Order qty, the cross-section from cable sizing, Conductor, Insulation, Voltage and Colour.
A measured line and its specification fields

A rule line and a manual line differ only at the top of the card.

The Line card for a male DC connector, a Rule line: the factor per string, the design quantity it gives, the Allowance with This line and All 37 lines and the BOM setting it follows, Order qty, Type and Rated voltage.
A line worked out by a rule
The Line card for the CCTV system, a Manual line reading Needs quantity, with empty Quantity, Allowance, Order qty, its Scope, and Add a make.
A manual line

One size or all of them

An entry can produce several lines, such as one DC solar cable line per size. On those the card offers All N sizes | This size only, and your edit lands on the whole entry or that one line.

A number that follows a BOM setting

An allowance that follows a BOM setting shows This line | All N lines and a hint, such as "BOM setting · Spare for discrete consumables · 5.0 %". All N lines changes the setting for this project. This line gives this line a number of its own, and Use the setting drops that number again.

Adding a line

Open the Add a line card, or click + Add a line on the empty Line card.

TabYou give it
CatalogItem type and Quantity
RuleItem type, the design quantity to count from, and Factor
New typeName, Category, Unit, the design quantity to count from, and Factor

A preview shows the result, such as "Preview: 40 Nos". Click Add, and the new line is selected. An item type you add this way is a supply item. Add a line says "Generate a layout first." until a layout exists.

The Profile card

The top of the panel says what the list is built from.

PartWhat it says
The profileIts name, kind, version and entries, with Change… to choose another. See BOM profiles
THIS PROJECTHow many edits you have made, such as "54 edits · 5 can go into a profile". Save as profile… keeps them for other projects
BOM settingsHow many of the ten are changed, with Edit…
IN THIS BOMHow many lines come from how many entries, such as "125 lines from 118 of the profile's 173 entries"

Under IN THIS BOM, three counts open to name the entries that have no line.

CountWhy the entry has no line
Not for this designIt belongs to another design type, such as tracker items on a fixed-tilt plant
Switched offIt is off by default in the profile, or you turned it off. One that holds an edit of yours reads "your edit kept"
None on this layoutIt applies, but the layout has none to count

A project that carries a structure kit also shows "This project has a structure kit. The BOM lists the structure as a package; the kit is kept for later."

What survives a new layout

Edits belong to the project and a Generate keeps them. A change to the electrical grouping or to a BOM setting recounts the list and keeps them too.

When a line or entry leaves the design, the edit on it goes to the card No longer in the design, which opens by itself when a new one arrives. It names the line and the edit, such as "make Comet; 3 % allowance". Dismiss deletes that edit for good.

While the inputs are out of date, the view shows the last run's plant with no banner of its own, and the BOM's exports are refused. Inputs changed since the run reach the list after the next Generate.

BOM settings

BOM settings are the numbers many lines share. They come from the project's profile, and a change here is for this project. Open them with Edit… on the Profile card, or at File ▸ Advanced settings… ▸ BOM. All N lines on a line changes one in place. See Advanced settings.

The Advanced settings window on BOM: the groups down the left, a search field, and settings such as spare for consumables, lugs per cable end and the DC protection factors, each with its value beside the profile's.
Advanced settings, BOM
SettingDefaultRangeWhat it does
Spare for discrete consumables5.0 %0–50Added to lugs, glands, connectors, bolt sets and the like
Lugs per 3-core cable end31–6One per core, on LV AC and LV-IDT cable ends. IDT is the inverter duty transformer
Bifacial current gain10.0 %0–30Added to the module's Isc when it is bifacial
String fuse factor1.56 ×1–3Times the design Isc; the fuse is the next size up
DC disconnector factor1.25 ×1–2Times the strings per string monitoring box (SMB) and the design Isc; the next size up
String fuse sizes15, 20, 25, 30, 32, 50, 63 Aeach 1–200The standard fuse sizes to choose from
DC disconnector sizes250, 320, 400, 500, 630 Aeach 50–2000The standard disconnector sizes to choose from
MV cable drum length500 m50–2000A run longer than a drum needs a straight joint per extra drum, per parallel cable
Concrete block spacing0.8 m0.3–3Cable laid above ground rests on a block every this many metres
Cable tie spacing0.50 m0.1–2DC cable is tied to the table or tracker every this many metres

A change recounts the BOM at once, marks the project as changed, and does not put the rest of the results out of date. To keep a value for other projects, save it into a profile.

Remarks from the design checks

A failed design check that concerns a BOM line shows on that line as "Check: <ID> · <the finding>", in the item's tooltip and at the top of the Line card. A remark never changes a quantity, and an accepted check drops off the line. These remarks stay in the application.

Check findingLine
ICR over its rating or not placedICR building
Central inverter overloadedCentral inverter
Spare winding on a transformerInverter duty transformer
AC feeder over its flag, no single run carries it, or the drop is over budgetLV AC cable
DC trunk too longDC trunk cable
DC string dropDC solar cable
A shadow clearance skippedPV module

Exporting

Both exports are on Export ▾ in the view header, and both need active access. BOM · Excel workbook… and BOM · PDF… stay greyed out until the BOM can be written, with "Generate a layout first" or "Inputs changed since the last run. Regenerate first." as the reason. The default file name is BOM - <project> - <yyyy-mm-dd>, with the project taken from the project file's name or else the boundary file's.

An incomplete BOM still exports. Each line goes to one place:

  • A line that is not ready goes to Open items, and its quantity stays off the main list even when the quantity is known.
  • A manual quantity typed as 0 is dropped.
  • Mandatory spares get a section of their own.
  • Everything else goes on the main list.

The Excel workbook

SheetWhat it holds
BOMA heading block, then S.No, Category, Item, Specification, Makes, Nature, Unit, Design qty, Allowance %, Order qty, Source, Basis, Remarks
Block-wiseItem, Specification, Unit, one column per block, Shared, Total, and Check ("✓ adds up" or "! off by N")
Open itemsS.No, Item, Status, What's needed, Where to fix it. Present when something is open
Mandatory sparesPresent when there are any

The heading block gives the project, the capacity, the design, the profile, each BOM setting with its source ("Spare for discrete consumables: 3.0 % (profile 5.0 %, changed in this project)"), the date and the status ("! Incomplete · 56 open items" or "✓ Complete · 21 lines").

The PDF

Each page carries the title, the project, the capacity, design and profile, and a status badge. The body lists the ready lines with S.No, Item & specification, Makes, Unit, Order qty and Basis, then Mandatory spares, Open items on a new page, and BOM settings with the value used against the profile's.

The first page of the bill of materials PDF: the plant's capacity, the incomplete note with its open items, and the lines by category with makes, unit, order quantity and basis.
The bill of materials as a PDF

Exported files carry the design notes that belong to a line, such as "Estimated: the DC strings were routed for a sample of the plot" or "No listed rating: …". They carry no design check remarks.

In the deliverables package

Export deliverables… writes the same workbook as S2. The design report prints the same pages in its Bill of materials section, with nothing recomputed.

What the project keeps

A saved project holds the profile as it was used and your decisions: entry and line edits, entries turned off, added lines and types, and BOM settings. Quantities are not saved. They are counted again when the project opens. A project file with inputs only opens with the default profile. See Projects.

Click Save project when you finish editing the BOM. Your edits reach the project file only when it is saved.

A working order

Finish the design

Load the PAN and OND files and generate with Calculate cables on. Place the main control room and generate again, which routes its MV cables. Define the pile pattern. Cable lengths are usually the largest quantities on the list. See Cable routing.

Size the cleaning fleet, if you want one

Run Robotic Module Cleaning and click Add to BOM. The fleet's lines appear only once it is sized.

Choose the profile

Click Change… on the Profile card if your company has its own. Starting from the right profile saves entering its makes and specifications again.

Clear the design inputs

Open the BOM view and work down the Go rows on the Readiness card.

Answer what is open

Click Needs attention, then give each line its quantity, factor or specification.

Save and export

Click Save project, then export from Export ▾.

Where to go next

On this page