Creating Excel Templates to export a Cubit Estimating Job

You can create your own Template when exporting to Microsoft Excel. You can use any Template to Customize the columns that are exported and their headings.

To create an Excel Template:

From an open Job:

1. Click the Data tab.

2. Click New Template from the Excel ribbon.

Screenshot_2020-11-25_132153.jpg

Fig 1. New Template

3. The Excel Exporter window will open.

Screenshot_2020-11-25_132337.jpg

Fig 2. Excel Exporter

By default, the following columns are included:

Description, Quantity, Unit, Marked up Rate * Factor and Total.

4. Select what information to export by clicking any row in the Estimate Column.

5. Name any column by clicking any row in Header Name and typing a description.

6. Click the Use the Insert new Excel Column to add a Column above any selected row OR use Add
new Excel Column to add a Column in the final row.       

Screenshot_2020-11-25_134055.jpg

Fig 3. Insert or Add Excel Column

7. You can change the order of your exported columns by selecting the row and move the columns up or down using the arrow buttons.

Note: The letters on the left of each Header Name will signify which column that row is
exported as. The A row will be the A column, which will be the first column on the left.

Screenshot_2020-11-25_134511.jpg

Fig 4. Move column order

8. By default, Include Trade headings and Include Excel header are ticked. You can
uncheck these if you do not want them to be exported.

9. By default, Export all is checked; this will export the entire Job. You can select Export
selected to only export any Trades, Headings or Items you have highlighted in your
Estimate.

10. Click Save Template to save your Excel Exporter Template.

11. Enter a Name for your Template.

Screenshot_2020-11-25_135103.jpg

Fig 5. Save Template

12. Click Export to export the Job.

 

You may also find the following links most helpful:

Export a Cubit Estimating Job to Excel

Managing Excel Templates

Using an Excel Template to export a Cubit Estimating Job

 

 

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.