Office of Estimating
Welcome to the Office of Estimating General Summary page
This page is intended to provide clarification and tips for getting the most out of the Excel based General Summary required for plan submission.
The General Summary is jointly maintained by CADD and Mapping, and the Bid Analysis and Review Team
News -January 7, 2021
Subsummaries
The subsummary sheets were previously available as a separate download. They are now included in the CADD Standards. Please consult with your IT department for help installing the CADD Standards if it is not currently installed on your computer.
Obsolete Items
A number of common items have become obsolete in the past year. Please refresh the item master to ensure no obsolete items are included at plan file.
Item | Description | Obsolete Date |
632E72901 | SIGNAL SUPPORT,
MECHANICAL DAMPER FOR TC-81.22 MAST ARM (GREATER THAN 39' IN LENGTH), AS PER
PLAN | 12/31/2020 |
625E36000 | PLASTIC
CAUTION TAPE | 12/11/2020 |
202E23010 | PAVEMENT
REMOVED, ASPHALT | 11/20/2020 |
614E12338 | WORK
ZONE IMPACT ATTENUATOR (BIDIRECTIONAL) | 11/20/2020 |
614E12336 | WORK
ZONE IMPACT ATTENUATOR (UNIDIRECTIONAL) | 11/20/2020 |
News -June 22, 2016
The current version of the excel general summary can accommodate the 2016 spec year. Please ensure the correct spec year is indicated on the excel general summary.
To conform to Federal structure nomenclature, the following headings have been changed:
"Structure 20 Foot Span and Over" is now "Structure Over 20 Foot Span"
"Structure Under 20 Foot Span" is now "Structure 20 Foot Span and Under"
News -March 3, 2016
Many updates have been made to the excel general summary in the past year. The change log below reflects the most recent updates.
Please visit the CADD YouTube channel for instructions on how to use the newest features including the Item_Master_addin for excel.
News -September 1, 2015
Video tutorials are available on the CADD YouTube channel. The videos address both standard and complex features of the spreadsheet.
The newest version of the excel general summary spreadsheet is dated 07/17/2015. Several versions were released in the past year, each incrementally building on the last. Please read the "Info" tab for the most recent details.
News -July 21, 2014
A new version of the excel general summary spreadsheet is now available. Please see the Change Log section below for details. It includes a menu to look up and add pay items. Now items can be added by typing in item numbers, pasting in item numbers, or using the lookup function.
Please note that the version numbers will now reflect the release date (Vyy.mm.dd), rather than a 1, 2, 3 nomenclature.
News -April 18, 2014
Version 2.0 is now available. Please see the Change Log section below for details. It will provide a more robust and useful interface to CAD and we hope you will find it more structured and user-friendly.
Upcoming
We are experimenting with version 2.12a-1 of Estimator. If you have a single-funded project, we invite you to export the Estimator file to XML and send it in with your plan package.
Background
CAAD and Mapping originally developed a Microsoft Excel spreadsheet to link with designer plans and assist the design process.
It has grown into a required deliverable to the Office of Estimating.
The end-goal of the General Summary is to import data from construction plans as efficiently and accurately as possible.
Versions
v201Y.MM.DD - Latest GenSum release
2.0 - Phasing out, using the current version will provide more features.
Versions older than 2.0 are no longer supported. Please copy and paste the values on the spreadsheet into a newer version.