Estimating - tools, Quantities 2 Plans (Q2P)

Quantities 2 Plans (Q2P) is an Excel workbook ribbon that assists the user in quantity computations, comparing various bid item unit prices, creating miscellaneous quantity tables, and building & maintaining the design project estimate. As an excel spreadsheet, Q2P allows compatibility with either AutoCAD C3D or Microsoft PowerPoint when creating miscellaneous quantity plan sheets. Q2P is also capable of exporting estimate data into AASHTOWareTM Project (AWP). 

User Guide

View Q2P User Guide (August 14, 2019)

View Q2P User Guide (September 15, 2016)

Installation

  • For WisDOT computers, go to MyDOT and select the IT Service Portal. Then once logged in, click on the box for Applications/Software. Click on "Software - Request New" to start a ticket to have Q2P installed on your computer. Once installed, refer to the installation instructions linked below and follow the steps listed under the section "Instruction for PC used by multiple Windows logins" to finish the installation.
  • For users outside of WisDOT, you will need security access to your computer for the ability to run an executable file (.exe). Please consult with your organization's IT security policies and personnel prior to installing. Please follow to the installation instructions linked below. If you don't see the Q2P ribbon after initial install, try following the steps listed under the section "Instruction for PC used by multiple Windows logins". The link to the installation file is listed below.    

Q2P Installation Instructions Read-me (August 15, 2019)

Q2P Installer v2.1.5.zip (August 22, 2019)

Support

WisDOT users encountering issues with Q2P not working on their machine should contact the IT Service Desk or the individuals in each office who are most familiar with the tool, listed below in Q2P Support Staff by Region.

Outside users that have questions or problems with Q2P should email the Q2P mailbox dotq2p@dot.wi.gov.

Anyone interested in Q2P may subscribe to the email distribution list at no charge.

 

 

Additional Resources

PowerPoint MQ Plan Sheet.pptx (Horizontal sheet template to be used for MQ plan sheets)

PowerPoint MQ Plan Sheet Rotated.pptx (Vertical sheet template to be used for MQ plan sheets) 

WisDOT Estimating Tools Website

WisDOT AASHTOWare Project (AWP) Knowledge Base (Instructions on creating estimates and using AWP)

Q2P support staff by region

For questions regarding the content of this page, contact:

Bureau of Project Development
4822 Madison Yards Way
4th Floor South, Room S437
Madison, WI 53705
Phone: (608) 266-1631
Fax: (608) 267-1862
hcci.dtid@dot.wi.gov