The project cut and fill quantities can be imported from a station specific bill of materials in Excel format (.xlsx). It is possible to import multiple excel file sheets into a project where MAGNET Project autodetects column and row settings from basic formats.
Disposal areas, borrow pits and crushing plants are added manually. Drainage and other quantities can also be added with the bill of materials. It is possible to add or edit any quantities later on.
In the video you will see an example of what bill of materials for an area and linear main road line looks like. Area is a point like location that is not station specific.
Bill of quantities for an alignment includes the following information: Column A contains the road line station and its ascending numbering. Columns B forward contain the masses of the road line quantities.
MAGNET Project to import the masses correctly, the following requirements must be met:
1. The cell "Station" has to be in the first column (MAGNET Project begins importing from that row onward).
2. The station numbering needs to be ascending, but the intervals do not necessarily need to be of the same length.
3. The names of the quantity types (e.g. Cut/Fill or Noisebank) and their units don't need to be identical with the quantity types defined in the MAGNET Project template or project file, but this would make the process of importing faster. If quantity type names don't match, user can map quantity type names manually in import dialog.
4. The quantities are formatted as numbers, not as text.
5. There are no summary rows below the quantity table.
Steps for importing a bill of quantities:
1. Start the import by creating a new project from template and import Bill of Quantities by selecting "Import" under "File". In this example we are using default template.
2. Select the correct file (Bill of Quantities) from your computer and click "Open".
3. Make sure the settings for your sheet are correct and connect your bill of quantities to correct location, if you already have locations set up in your project. Then click "Next".
At first page of import dialog you can see
- A list of all imported sheets
- Select sheet from top left list to see its contents and settings
- Unselect sheets that don't contain quantities in case of "One of the selected sheet have problems" notification while import prosess
- Color coded row settings on bottom left are:
- Quantity type row - row where quantity type names are located
- Unit row - row where unit names are located. Set to 0 (= unset) if there are no units in the sheet
- First amount row
- Last amount row
Column types can be edited using a drop list by selecting cell on the top row. Possible column types are:
- Ignore: Column is ignored
- Station: Station of quantity (there can also be two station columns)
- Location: Different location can optionally be defined for each row
- Quantity: Column contains quantity type name and the quantity data (numbers)
- Distance: Distance defines the length of intersection created to default location
- Length: If there is a location column, instead of station columns you can have a length column
After editing (if needed) select "Next".
4. In the second page of import if you don't wish to import some of the data, select "Don't import from the drop-down menu". Match quantity types with correct quantity types if needed. The names of the quantity types in Excel don’t necessarily need to be identical with the ones in the project file because of the possibility of manual editing in mapping page in previous import dialog.
If you are importing actual quantities, check the box for "Import quantities as actuals".
Each item imported from Excel can be mapped to
- Some existing project item
- <Add>: new item is added to project
- <Don't import>: item is not imported
After selections press "Import".
5. Open the Mass Haul View to view imported quantities. Cuts are shown above the line and fills below the line.