How to upload a schedule or spreadsheet
Purpose
Section titled “Purpose”Get quantities from a Revit schedule or a spreadsheet into the project without a plugin. The file arrives as a submission under Models, where you review it before it becomes a new version.
Prerequisites
Section titled “Prerequisites”- You have write access to the project. With read access only, you can see the submissions but not upload.
- You have a file in one of the formats
.xlsx,.xls,.csv,.tsvor.txt, or you can copy the cells from Revit or Excel.
Prepare the file
Section titled “Prepare the file”The file can be a Revit schedule, a Molio template or an LCAbyg template. LCAbyg recognises which it is by itself and says so at Read as.
A schedule from Revit
Section titled “A schedule from Revit”- Turn on showing units in the quantity columns, e.g. “197 m²”. Only metric units can be read.
- Use a single header row. Rows with “Total” may be included: they are not counted, but are used to check the sum.
- Export the schedule with tab as the delimiter (File > Export > Reports > Schedule), or save it as an Excel file.
Recommended columns are Family and Type (or Type), one quantity column (Area, Volume, Length or Count), Phase created and Phase demolished, classification (BIMTypeCode, CCS, Keynote or Assembly code), Type Mark and Description. The headers can be in Danish or English.
| Column | Headers that are recognised |
|---|---|
| Type | Family and Type, Familie og type, Family, Familie, Type |
| Quantity | Area/Areal, Volume/Rumfang/Volumen, Length/Længde, Count/Antal |
| Phases | Phase Created/Fase oprettet, Phase Demolished/Fase nedrevet |
| Classification | BIMTypeCode, CCSClassCode, CCSTypeId, Keynote, Assembly Code |
| Other | Type Mark, Description/Beskrivelse |
| Pipes and ducts | Size/Størrelse/Diameter/Dimension and System Type/Systemtype |
- Without a Count column, each line counts as one element.
- For pipes and ducts, include Size (or Diameter) and System Type, so each size and system gets its own line.
- If BIMTypeCode or CCS is on the types, LCAbyg suggests the placement from the code.
- Plain numbers from Excel without a unit are read in the column’s own unit (m², m³ or m).
A spreadsheet from LCAbyg’s template
Section titled “A spreadsheet from LCAbyg’s template”Under Schedule or spreadsheet you can download Download empty template and Download example. Use the template’s headers. Columns the template does not know are skipped. Save the sheet as an Excel file, or copy the cells and paste them. The example can be uploaded as it is, so you can try the review.
If the Excel file has several sheets, each sheet with recognised headers is read separately.
- Go to Models in the project menu.
- Click Upload file under New import.
- Choose the file with Choose file…, or drop it in. You can also paste the cells directly into the field Or paste the cells directly, after copying them in Revit or Excel.
- Under What is this file?, choose either A new version of a sheet in the project (and which sheet) or A new sheet (and give it a Name). If you choose an existing sheet, products and choices from last time are kept, and only the changes need reviewing. The file name does not matter, so a date in the file name does not make the file a new sheet.
- Choose Number format in the file: Danish (1.234,5) or English (1,234.5). Revit writes numbers according to the project’s unit settings, so the format cannot be read reliably from the numbers themselves. If the numbers look like the other format, LCAbyg suggests switching.
- Click Check file. Read the overview, see the next section.
- Click Import.
- Review the submission under Models, and approve it. Only the approval creates a new version. Nothing in the project changes until you have approved.
Read the overview before you import
Section titled “Read the overview before you import”Check file shows how the file was read, and nothing has been created yet:
- Read as: the file kind (workbook or text file), the profile (Revit schedule, Molio template or LCAbyg template) and which line the headers are on.
- Columns: the columns LCAbyg recognised, and under Not read those that were not, because the header is unknown.
- In total: total area, volume, length and count. If the file has a total row, it is shown beside it, with whether it matches the rows.
- Rows that are skipped: with the reason. Click Download the list to save them.
If the file cannot be read
Section titled “If the file cannot be read”If the file cannot be read, nothing is created, and the problems are listed per line. This only applies to errors that affect the schedule as a whole. A single bad row is skipped instead and mentioned in the overview.
| Message | What you do |
|---|---|
| There is no type column | Add a column with “Family and Type” or “Type” |
| There is no quantity column | Add a column with Area, Volume, Length or Count |
| The schedule’s total row is not the sum of its rows | If there are groups with subtotals, export without them |
The value is <varies> | Split the schedule so each line has one value |
| ”…” is not a number in the chosen number format | Switch Number format in the file, or fix the number |
| ”…” has no unit | Turn on showing units in the schedule |
| ”…” is not in a metric unit | Show the quantities in metric units |
| ”…” is negative | Fix the quantity |
| ”…” is not a whole count | Round the count to a whole number |
| The schedule has too many lines or columns | Remove the fields you do not need and export again |
If none of the messages fits, check that the file has a single header row and columns as in the table above.
Result
Section titled “Result”The file is listed as a submission under Models with the source Revit schedule or Spreadsheet and the status Awaiting review. When you approve, LCAbyg creates a new version from the lines you have marked.
See also
Section titled “See also”- Models: submissions, review and approval
- How to calculate design variants when the quantities come from a model
- How to import a quantity sheet from Excel: a quantity sheet exported from a version in LCAbyg