Export a bill of materials from PVcase Concept to review the equipment quantities and unit costs for your design in Excel.
Exporting a bill of materials (XLSX)
- Open the site and restore the scenario you want to export.
- Open the Export panel.
- Click Export next to Bill of materials.
Review site and component information
The exported spreadsheet includes an overview of the exported design, with information such as:
- Site and active scenario details
- Preset specifications
- Material quantities
- Financial inputs (automatically prefilled if entered for the scenario)
Review the materials
The materials section includes the item, specification, quantity, and unit cost. Unit costs reflect the financial inputs entered in Concept.
Check both quantities and unit prices when comparing the workbook with your design assumptions.
Some cost inputs are not exposed in Concept. You may need to complete additional costing, such as string or cable costs not entered in the application.
Understand values and totals
A field labeled “Value” in the site or component overview is not necessarily a price. Read it with its description and unit; it may represent an area or another design measurement.
Review the materials calculations before using the workbook for further costing. If you add or change values in Excel, check the affected totals.
Keep exports identifiable
Use clear scenario names before exporting so the site and scenario information in the workbook helps identify the design being reviewed.