Category:PQS - Revision history

BergK1: Replaced content with " ==Introduction to the Project Quantity Spreadsheet== The Development Guide has moved to a Sharepoint site. If you..."

2025-01-24T16:04:57Z

Replaced content with " ==Introduction to the Project Quantity Spreadsheet== The Development Guide has moved to a Sharepoint site. If you..."

Show changes

BergK1 at 12:55, 19 May 2023

2023-05-19T12:55:59Z

BergK1 at 12:55, 19 May 2023

2023-05-19T12:55:38Z

MelasiN: Fixed apostrophe not appearing correctly in general options section

2021-04-15T19:15:15Z

Fixed apostrophe not appearing correctly in general options section

Arnoldl1: /* General Features */

2021-04-13T19:16:26Z

General Features

BergK1: /* PQS Download */

2020-07-13T14:32:53Z

PQS Download

BergK1: /* PQS Download */

2020-07-13T14:31:50Z

PQS Download

BergK1: /* PQS Download */

2020-07-13T14:30:41Z

PQS Download

BergK1: /* General Features */

2020-06-24T16:48:27Z

General Features

Arnoldl1: /* PQS Download */ Updated download link

2020-06-15T13:16:40Z

PQS Download: Updated download link

@@ Line 4: / Line 4: @@
 '''New Sharepoint site''' The following link contains more information about Project Quantity Spreadsheet. If prompted, select "Request Access".
 [https://stateofmichigan.sharepoint.com/sites/MDOT-SPC-DevelopmentGuide/PQS_TeamSite Project Quantity Spreadsheet]
 :The Project Quantity Spreadsheet (PQS) is a tool designed by MDOT to standardize quantity calculations. It was developed to improve designer efficiency and reduce risk and errors throughout the design process. The PQS has features to streamline project packaging, automate quantity generation, and link quantities with Microstation. Each time the PQS opens it verifies that the pay items are current and up to date. If the pay items are not up to date it will automatically update its pay item list.

← Older revision		Revision as of 12:55, 19 May 2023
Line 2:		Line 2:

	==[[#Introduction to the Project Quantity Spreadsheet\|Introduction to the Project Quantity Spreadsheet]]==		==[[#Introduction to the Project Quantity Spreadsheet\|Introduction to the Project Quantity Spreadsheet]]==
		+	'''New Sharepoint site''' The following link contains more information about Project Quantity Spreadsheet. If prompted, select "Request Access".
		+	[https://stateofmichigan.sharepoint.com/sites/MDOT-SPC-DevelopmentGuide/PQS_TeamSite Project Quantity Spreadsheet]
		+
	:The Project Quantity Spreadsheet (PQS) is a tool designed by MDOT to standardize quantity calculations. It was developed to improve designer efficiency and reduce risk and errors throughout the design process. The PQS has features to streamline project packaging, automate quantity generation, and link quantities with Microstation. Each time the PQS opens it verifies that the pay items are current and up to date. If the pay items are not up to date it will automatically update its pay item list.		:The Project Quantity Spreadsheet (PQS) is a tool designed by MDOT to standardize quantity calculations. It was developed to improve designer efficiency and reduce risk and errors throughout the design process. The PQS has features to streamline project packaging, automate quantity generation, and link quantities with Microstation. Each time the PQS opens it verifies that the pay items are current and up to date. If the pay items are not up to date it will automatically update its pay item list.

← Older revision		Revision as of 19:15, 15 April 2021
Line 34:		Line 34:


−	:The General Option is the most basic functionality of the PQS. The functionality of this option allows users to enter each project item and item quantity into the spreadsheet in a user-friendly format and create an XML file for import into Preconstruction. It has a similar functionality to both Preconstruction and the Stand Alone Project ~~Estimatorâ€™s~~ Worksheet (SAPW) software. A user can also link quantities with Microstation and leverage the quantity calculation features using this option.	+	:The General Option is the most basic functionality of the PQS. The functionality of this option allows users to enter each project item and item quantity into the spreadsheet in a user-friendly format and create an XML file for import into Preconstruction. It has a similar functionality to both Preconstruction and the Stand Alone Project Estimator's Worksheet (SAPW) software. A user can also link quantities with Microstation and leverage the quantity calculation features using this option.

	:This option is often used to verify XML files from SAPW, MERL, or an equivalent XML.		:This option is often used to verify XML files from SAPW, MERL, or an equivalent XML.

@@ Line 107: / Line 107: @@
 :<big>'''Importing Pricing: [https://mdotjboss.state.mi.us/SpecProv/getDocumentById.htm?docGuid=d65ca8e3-8f13-4a26-b05f-2cb826209155&fileName=%22Import%20XML.mp4%22 Video]'''</big>
 :This video walks through how to Import pricing from an XML generated from the PQS, SAPW, MERL, or Preconstruction.
 ===[[#Combining PQS Files|Combining PQS Files]]===

@@ Line 182: / Line 182: @@
 :This link is the current version of the [https://mdotjboss.state.mi.us/SpecProv/getDocumentById.htm?docGuid=6f42d545-269b-4d65-b108-afa8a29887a6 PQS]
-:Note that the default spec book is 2020. Check with your Project Manager to verify if your project will use the 2012 or 2020 spec book. To use the 2012 spec book, select the 2012 from the dropdown list, save, close, and reopen. [https://mdotjboss.state.mi.us/SpecProv/getDocumentById.htm?docGuid=9f997f48-55aa-4a94-bedf-d2b1c3f5fe22&fileName=%22PQS%20and%202020%20Spec%20Book.mp4%22 Video]
+:Note that the default spec book is 2020. Check with your Project Manager to verify if your project will use the 2012 or 2020 spec book. To use the 2012 spec book, select 2012 from the dropdown list, save, close, and reopen. [https://mdotjboss.state.mi.us/SpecProv/getDocumentById.htm?docGuid=9f997f48-55aa-4a94-bedf-d2b1c3f5fe22&fileName=%22PQS%20and%202020%20Spec%20Book.mp4%22 Video]
 {{top}}

@@ Line 89: / Line 89: @@
 :<big>'''Opening the PQS: [https://mdotjboss.state.mi.us/SpecProv/getDocumentById.htm?docGuid=67ac24c6-9c3e-43f4-9b06-c3c8e4321f22&fileName=%22Opening%20the%20PQS.mp4%22 Video]'''</big>
 :This video walks through how to open the PQS.
 :<big>'''PQS Ribbon and How to Use it: [https://mdotjboss.state.mi.us/SpecProv/getDocumentById.htm?docGuid=d623b731-6bdc-4028-ab05-d9debb5356b3&fileName=%22PQS%20Ribbon%20Definition.mp4%22 Video]'''</big>

@@ Line 177: / Line 177: @@
 ==[[#PQS Download|PQS Download]]==
-:This link is the current version of the [https://mdotjboss.state.mi.us/SpecProv/getDocumentById.htm?docGuid=6f42d545-269b-4d65-b108-afa8a29887a6&fileName=%22Project%20Quantity%20Sheet%20V2.1.01.xlsm%22 PQS]
+:This link is the current version of the [https://mdotjboss.state.mi.us/SpecProv/getDocumentById.htm?docGuid=6f42d545-269b-4d65-b108-afa8a29887a6 PQS]
 {{top}}