Generate contract item or contract project item detail spreadsheets

Last updated: 2023-03-28

Roles:

  • Project Engineer, Project Manager, Inspector, Contractors, Contract Specialist = modify access
  • Supervisor, Chief, ReadonlyConstr = read only access

Project staff have the ability to export construction contract item detail to two different reports that can be imported into Microsoft Excel.

The Contract Items XLS report is a report of all contract items and includes item number, item description, supplemental description, contract line number, unit, unit price, bid quantity, current quantity, quantity posted to date, quantity paid to date, item complete flag, item source, change order number, specialty item flag, and the subcontractors the item is assigned to.

The Contract Project Items XLS report is a report of all contract project items and includes project, category, item number, item description, supplemental description, project item line number contract line number, unit, unit price, current quantity, quantity posted to date, quantity paid to date, bid quantity, item complete flag, item source, and change order number.

  1. Log into AASHTOWare Project

  2. Select the appropriate role (home button action arrow and select the role).


  3. Select the contract under Contract Administration Overview by searching for the Contract ID, controlling project ID, region, county or contractor in the search box.

    Tip:
    Go to How to Search for the Contract ID by Project ID if only an associated project ID is known.


  4. Click on the contract ID hyperlink for the contract you are working on.


  5. To export the Contract Items XLS report or the Contract Project Items XLS
    • Select Open Component Actions Menu | Reports | Contract Items XLS
      OR
    • Select Open Component Actions Menu | Reports | Contract Project Items XLS


  6. On the Generate Report | Output Options 4 of 5 component, click <Execute>.


  7. Depending upon the Internet browser being used, the data will be exported and most likely saved to the \downloads folder. Locate the file and open in Microsoft Excel.

Data export examples