Layered Takeoffs Training Guide - Version 3 Home | Best Practices | Appendix | Full Training Guide    
image.gif
2.13 View Takeoff Variance Report Detail
A comparison report of baseplan takeoffs for 2 or more baseplan/elevation/project sets. By running the report you will be able to see in which baseplan the item costs differ, as well as, the number of times an item appears in a given baseplan compared to another.
ON THIS PAGE
2.13.1 Running a template report
2.13.2 Creating a new report
2.13.1 Running a template report
Step Action
1. Open View Takeoff Variance Report Detail application.
2. Select a template from the Select a template drop down list:
  • To delete the report template, click .
  • To email report template to someone, enter an email address in the Send Report to (email address) input field, select report format from the drop down list (e.g. HTML) and click .
  • To view the report in print mode and to print it out, click . Review the report and when you are done, click .
  • To view the report online, click .

    To create a duplicate of the report template, fill out the form located at the very bottom of the page. You can make this report template available either to all users or only yourself. Enter a new template name in the Save report as a template named input field, select user access (e.g. all users, only current user) from the For drop down list and click .
Back to the top


2.13.2 Creating a new report
Step Action
1. Open View Takeoff Variance Report Detail application.
2. SELECTING BASEPLANS FOR COMPARISON
The first step is to decide which baseplans you want to compare. To do this, you must enter the baseplan ID's, elevations and projects in both Set 1 and Set 2 columns.




ADDING ADDITIONAL BASEPLAN SETS FOR COMPARISON
To compare costs from more than 2 baseplans, enter the number of additional sets in Add New Column Sets input field and click .

Note: There is no need to enter the number of new column sets, if you only need to add an additional one. Simply click on button.



SETTING UP VARIANCE COLUMNS - Difference in Item Usage
Result of comparison will be displayed in the report's Variance column. Whether the results of Set 1 should be subtracted from Set 2 or vice versa is set up in Setup Variance Columns section of the form. And as you can see in the example below, Set 1 will be subtracted from Set 2.

If you are comparing more than 2 baseplans, you might need to have more than 1 variance column. To do so, enter the number of new variance columns in Add New Variance Columns input field and click .

Note: There is no need to enter the number of new variance columns, if you only need to add an additional one. Simply click on button.



NARROWING DOWN REPORT OUTPUT
Finally, you can narrow down your report output even further by selecting specific items, item groups or cost types.

FORM FAQ
Item To search for item takeoffs for a specific item, enter the item ID or click on the link to find one. To search for more than 1 item, enter the item ID's separated by commas in the Add to input field.
Item Groups To search for takeoffs by item group, select 1 or more groups by holding the key on your keyboard.
Cost Type To search for item takeoffs by cost type, enter the cost type ID or click on the link to find one. To search by more than 1 cost type, enter the cost type ID's separated by commas in the Add to input field.
Show Cost and Total You have an option to display item cost and total (cost multiplied by quantity)...

Or, display only item quantity.

Select Yes or No.
Display Mode Show Cost Types Separately - Items can be sorted by cost type ID in ascending order, with a separate cost type header displaying:

Show Cost Types Across - Or, items can be displayed in a single table sorted by item ID in ascending order. Note: That by selecting this display mode, you will not see cost type ID's in the report.
Display Column Set Info Set information (e.g. baseplan ID, construction type) can be displayed once at the very top of the report:

Or, under each column set title:

Note: The following display option only applies if you have selected "Show Cost Types Separately" from the Display Mode drop down list.
3. When you are ready or .
4. Here is an example of the detailed Takeoff Variance report in online mode; a comparison of 2 different baseplans from the same project. The Variance column displays the difference in item usage. So we can see that item FS was utilized more frequently in baseplan A3003, while item CARPETBOX was only utilized in baseplan A3002.

To view the detailed budget for a given set, click on the set link located at the top of the screen (e.g. ). For details, see View Budget Detail section of Job Costing training guide.
5. When you are done, click .
Back to the top
Updated August 6, 2014