{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Warnings","Instructions","Assistance","General Project Info","Initialize","PART A","PART B","PART C","Print","PART B Instructions","PART C Instructions","Days","Code"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":33,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Warnings","index":0,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,4,26,14],[8,3,8,14],[23,4,23,14],[25,4,25,14],[25,0,25,3]]}
[]
[null,"DGS FORM CO-12"]
[null,"(Form Number DGS-30-104,  Revised 01/16)"]
[null,"SCHEDULE OF VALUES and CERTIFICATE FOR PAYMENT"]
[]
[null,null,"Before using this Excel form, please read the following:"]
[]
[]
[null,null,null,"If you use Excel 2007 or 2010, you must \"enable macros\" or save this as a \"Macro-Enabled Worksheet\"."]
[]
[null,null,null,"Users may …"]
[]
[null,null,null,null,"Users may add, edit, or delete data in the those cells which are highlighted in yellow.  (e.g.,",null,null,null,null,null,null,null,null,null," )"]
[null,null,null,null,"Users may insert rows by using the Insert New Row button only !"]
[null,null,null,null,"Users may format cells (e.g., bold, underline, italic, font size, etc.)"]
[null,null,null,null,"Users may format rows (e.g., adjust the row height, etc.)"]
[]
[null,null,null,"Users should not …"]
[]
[null,null,null,null,"Users should not modify these worksheets in any manner, other than as noted above !"]
[null,null,null,null,"Users should not \"unprotect\" these worksheets !"]
[null,null,null,null,"Users should not delete rows in these worksheets !"]
[]
[null,null,null,null,"Users should not enter data directly into any cells that are not highlighted in yellow.  Many of the other cells contain formulas which may be accidentally overwritten if spreadsheet is unprotected and data is entered directly into the white cells."]
[]
["WARNING:",null,null,null,"Doing any of the above \"should not\" actions can compromise the integrity of the CO-12 worksheet by overwriting or deleting data and/or formulas.  It is not the responsibility of the DGS staff to help correct worksheets which have been corrupted by users not heeding the above warnings."]
[null,null,null," ","It is highly recommended users make backup copies before starting each new pay request !"]

{"sheet":"Instructions","index":1,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[[27,6,30,9],[5,1,5,9],[16,6,16,9],[17,6,17,9],[7,2,7,6],[9,1,9,4],[9,6,10,9],[12,6,13,9]]}
[]
[null,"DGS FORM CO-12"]
[null,"(Form Number DGS-30-104,  Revised 01/16)"]
[null,"SCHEDULE OF VALUES and CERTIFICATE FOR PAYMENT"]
[]
[null,"MAIN MENU and GENERAL INSTRUCTIONS"]
[]
[null,null,"Before proceeding, please click here to read important warnings."]
[]
[null,"Complete each step below in the order listed.",null,null,null,null,"If you need assistance, click here."]
[null,"1."," Make a backup copy of this Excel file"]
[null,null," before proceeding to the next step."]
[null,null,null,null,null,null,"For questions regarding Retainage, refer to the notes included within Step 3."]
[null,"2."]
[]
[]
[null,"3.",null,null,null,null,"New users, please review the instructions"]
[null,null,null,null,null,null,"below before completing Parts B & C."]
[]
[null,"4."]
[]
[]
[null,"5."]
[]
[]
[null,"6."]
[]
[null,null,null,null,null,null,"To view the complete \"Building Element\" classification structure used in PART B, click here."]
[null,"7."]
[]
[]
[null,"8."," Save each monthly submittal with a unique file name."]
[null,null,"   ( for example:   Project 999-99999 Pay Request 1,  Project 999-99999 Pay Request 2, .... )"]
[]
[null,"9."," Sign and submit the CO-12."]
[]
[]
[null,"NEXT MONTH - Repeat Steps 1 through 9."]

{"sheet":"Assistance","index":2,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[5,2,5,7],[11,2,11,7],[27,2,46,7],[18,3,18,7],[19,3,19,7],[20,3,20,7],[22,3,22,7],[23,3,23,7],[24,3,24,7]]}
[{"$f":"Instructions!B3","v":"(Form Number DGS-30-104,  Revised 01/16)"}]
[]
[]
[null,"If you need assistance:"]
[]
[null,null,"For projects constructed under the provisions of the Higher Education Restructuring Act, please direct ALL questions to that institution, otherwise:"]
[]
[]
[null,null,"For content or procedural questions, such as contingency reductions, contact the Agency Project"]
[null,null,"Manager or their Architectural/Engineering Consultant, as appropriate."]
[]
[null,null,"For problems with the Excel spreadsheet, proper, please enter the information below and e-mail the complete Excel file you are working on as an attachment to the following e-mail address:"]
[]
[null,null,null,null,null,null,null,"capout@dgs.virginia.gov"]
[]
[null,null,"( Please recall that it is not the responsibility of the DGS staff to help users correct worksheets which"]
[null,null,"  have been corrupted by user's failure to heed the warnings provided earlier. )"]
[]
[null,null,"Your Name:"]
[null,null,"   Phone Number:"]
[null,null,"   E-mail address:"]
[]
[null,null,"Agency Project Mgr:"]
[null,null,"   Phone Number:"]
[null,null,"   E-mail address:"]
[]
[null,null,"Question or Description of Problem:"]

{"sheet":"General Project Info","index":3,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,2,1,5]]}
[]
[null,null,"STEP 2  -  Enter Project and Contract Information"]
[]
[null,"A )","Enter the following:"]
[]
[null,null,null,"Project Number:"]
[null,null,null,"Project Title:"]
[null,null,null,"Institution/Agency Name:"]
[null,null,null,"Location of Work:"]
[null,null,null,"A/E Firm Name:"]
[null,null,null,"Contractor Name:"]
[null,null,null,"Contractor FEIN:"]
[null,null,null,"( FEIN = Fed. Employer Identification Number )"]
[]
[null,null,null,"Date Contract Executed"]
[]
[null,null,null,"      Month:"]
[null,null,null,"      Day:"]
[null,null,null,"      Year:"]
[]
[null,null,null,"NOTE:   ","Once the above project and contract information have been entered, unless there are any changes,  "]
[null,null,null,null,"STEP 2 can be bypassed on future monthly updates."]
[]
[]
[null,"B )"]

{"sheet":"Initialize","index":4,"n_rows":72,"n_cols":11,"rows_kept":72,"cut":false,"hidden":false,"merged":[[1,2,1,8],[20,4,20,6],[24,4,28,8],[29,4,31,8],[22,6,22,7]]}
[]
[null,null,"STEP 3  -  Prepare the CO-12 for New Pay Period"]
[]
[]
[null,"WARNING:   Run the Initialize Macro only once before beginning each"]
[null,null,"new monthly pay request.  See the explanation below."]
[null,null,null,null,null,null,null,"Today is:",{"$f":"TODAY()","v":"2024-02-26"}]
[null,"A )",null,null,null,null,null,"NOTE:  This form was last initialized on:","2015-03-19"]
[]
[]
[null,"B )","Update the following data:"]
[]
[null,null,"    Pay Request Number:",null,1]
[]
[null,null,"         For Pay Period Beginning:"]
[]
[null,null,"         For Pay Period Ending:"]
[]
[null,null,"    Pay Request Submittal Date:"]
[]
[null,null,"    Contractor Representative:"]
[]
[]
[]
[null,"C )",null,"* ","Retainage is initially set at the default value of 5%.  With the Owner's PRE-APPROVAL, the retainage percentage may be adjusted.            DO NOT ADJUST the retainage value UNTIL AFTER the INITIALIZE macro is run."]
[]
[]
[]
[]
[null,null,null,null,"For the final pay request, adjusting the retainage value to 0%, AFTER the INITIALIZE macro is run, will release remaining retainage, if approved by the Owner."]
[]
[]
[]
[]
[]
[]
[null,"Initializing Explained ----  what is does and how it works:"]
[]
[null,null,"Initializing is designed to save the user considerable time and effort."]
[]
[null,null,"Initializing the CO-12 Form runs a macro (an automated procedure) which prepares the CO-12"]
[null,null,"for data entry for each new pay application. The macro copies all of the data from the  "]
[null,null,"\"Current Value to Date\" column to the \"Previous Value to Date\" column as shown in the"]
[null,null,"example below."]
[]
[null,null,"This step must be done to compute the correct values for the current pay request."]
[]
[]
[null,null," Example:",null,null,null,"VALUE OF WORK COMPLETED"]
[null,null,null,null,null,"PREVIOUS","VALUE","CURRENT"]
[null,null,null,null,"TOTAL","VALUE","THIS","VALUE","PERCENT"]
[null,null,null,null,"VALUE","TO DATE","REPORT","TO DATE","COMPLETE"]
[]
[]
[null,null," Before initializing:",null,100,20,{"$f":"+H55-F55","v":10},{"$f":"+E55*I55","v":30},0.3]
[null,null,null,null,null,null,null,null,null,null,"Cells with a yellow background"]
[null,null,null,null,null,null,null,null,null,null,"allow data input by the user."]
[null,null," After initializing:",null,100,30,{"$f":"+H58-F58","v":0},{"$f":"+E58*I58","v":30},0.3]
[null,null,null,null,null,null,null,null,null,null,"Cells with a white background are"]
[null,null,null,null,null,null,null,null,null,null,"calculated cells.  These cells are \"locked\""]
[null,null," After updating %:",null,100,30,{"$f":"+H61-F61","v":20},{"$f":"+E61*I61","v":50},0.5,null,"to prevent the user from accidentially"]
[null,null,null,null,null,null,null,null,null,null,"overwriting the embedded formulas."]
[]
[null,null,"The \"Initialize\" macro copies all \"Current Value to Date\" entries to the \"Previous Value to Date\" column."]
[]
[null,null,"After the initializing macro is run, you can now update the \"Percent Complete\" column to reflect new progress."]
[]
[null,null,"After updating the \"Percent Complete\" column, the new \"Current Value to Date\" amount is calculated by"]
[null,null,"a formula which multiplies the \"Percent Complete\" by the \"Total Value\"."]
[]
[null,null,"Another formula calculates the \"Value This Report\" amount by subtracting the \"Previous Value"]
[null,null,"to Date\" amount from the \"Current Value to Date\" amount."]

{"sheet":"PART A","index":5,"n_rows":69,"n_cols":10,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,1,2,3],[7,3,7,6],[38,2,38,3],[36,2,36,3],[36,6,36,9],[40,6,40,9],[49,1,50,9],[8,1,12,1],[4,9,5,9],[4,7,5,8],[4,3,4,6],[5,3,6,6]]}
[null,"STEP 6 - Review PART A",null,null,null,"NOTE:  All information on the PART A page is updated from entries made in the other steps."]
[null,null,null,null,"      Return to General Instructions","If any information on the PART A summary appears incorrect, return to the appropriate step"]
[null,null,null,null,null,"and make changes as required."]
[]
[null," DGS-30-104  ( FORM CO-12 )",null,"SCHEDULE OF VALUES",null,null,null,"PAYMENT REQUEST NO. ",null,{"$f":"Initialize!E13","v":1}]
[null," (Rev. 01/16)",null,"and"]
[null," PART A",null,null,null,null,null,null,"PERIOD BEGINNING DATE: ",{"$f":"Initialize!E15","v":"00:00:00"}]
[null," SUMMARY AND CERTIFICATION",null,"CERTIFICATE FOR PAYMENT",null,null,null,null,"PERIOD ENDING DATE: ",{"$f":"Initialize!E17","v":"00:00:00"}]
[]
[null,null,"PROJECT CODE:  ",{"$f":"'General Project Info'!F6","v":0}]
[null,null,"  AGENCY NAME:  ",{"$f":"'General Project Info'!F8","v":0}]
[null,null,"  PROJECT TITLE:  ",{"$f":"'General Project Info'!F7","v":0}]
[]
[null,null,null,null,null,null,"VALUE OF WORK COMPLETED"]
[null,null,null,null,null,null,"PREVIOUS","VALUE","CURRENT"]
[null,null,null,null,null,"TOTAL","VALUE","THIS","VALUE","PERCENT"]
[null,null,null,null,null,"VALUE","TO DATE","REPORT","TO DATE","COMPLETE"]
[null,null,null,null,null,"A","B","C","D = B + C","E = D / A"]
[null,"  Original Contract Line Items (from CO-12, PART B)",null,null,null,{"$f":"'PART B'!$D$26","v":0},{"$f":"'PART B'!$E$26","v":0},{"$f":"'PART B'!$F$26","v":0},{"$f":"'PART B'!$G$26","v":0},{"$f":"IF(F19=0,0,+I19/F19)","v":0}]
[null,"  Approved Change Orders (from CO-12, PART C)",null,null,null,{"$f":"'PART C'!C24","v":0},{"$f":"'PART C'!D24","v":0},{"$f":"'PART C'!E24","v":0},{"$f":"'PART C'!F24","v":0},{"$f":"IF(F20=0,0,+I20/F20)","v":0}]
[null,"  ADJUSTED CONTRACT TOTAL",null,null,null,{"$f":"F19+F20","v":0},{"$f":"G19+G20","v":0},{"$f":"H19+H20","v":0},{"$f":"I19+I20","v":0},{"$f":"IF(F21=0,0,+I21/F21)","v":0}]
[null,"  Retainage","Retainage Percentage:",{"$f":"Retainage_Current/I21","v":{"$error":"#DIV/0!"}},null,null,0,{"$f":"I22-G22","v":0},{"$f":"-('PART B'!J26+'PART C'!I24)","v":0}]
[null,"  NET REQUISTION AMOUNT",null,null,null,null,{"$f":"G21+G22","v":0},{"$f":"I23-G23","v":0},{"$f":"I21+I22","v":0}]
[null,null,null,null,null,null,null,"Amount Requested"]
[null,"CONTRACTOR CERTIFICATION"]
[]
[null,"  The undersigned Contractor requests payment of that portion of the contract price shown on the last line"]
[null,"  of the foregoing Schedule of Values, and represents and warrants to the Owner that: (1) the data shown on the"]
[null,"  Schedule of Values is accurate and correct; (2) the Work covered by this Certificate has been completed in"]
[null,"  accordance with the Contract Documents; (3) all previous progress payments received from Owner on account of Work done"]
[null,"  under this Contract have been applied to discharge in full (except for allowable retainage) all obligations of Contractor"]
[null,{"$f":"\"  incurred in connection with Work covered by prior \"&IF(Initialize!E13=1,\"Certificates for Payment ( not applicable for Pay Request 1 ) ;\",IF(Initialize!E13=2,\"Certificate for Payment Number 1 and; \", \"Certificates for Payment numbered 1 through \"&FIXED(Initialize!E13-1,0,TRUE)& \", inclusive, and;\"))","v":"  incurred in connection with Work covered by prior Certificates for Payment ( not applicable for Pay Request 1 ) ;"}]
[null,"  (4) title to all materials and equipment for which payment is requested in this Certificate, whether or not incorporated"]
[null,"  in said Work, will pass to Owner at time of payment free and clear of all liens, claims, security interests and"]
[null,"  encumbrances (except such materials and equipment which are covered by a Bond previously accepted by Owner)."]
[]
[null,"  FEIN #: ",{"$f":"IF('General Project Info'!$F$12=0,\"    *** enter FEIN in Step 2 ***\",'General Project Info'!$F$12)","v":"    *** enter FEIN in Step 2 ***"},null,null,"Contractor: ",{"$f":"IF('General Project Info'!$F$11=0,\"    *** enter Contractor name in Step 2 ***\",'General Project Info'!$F$11)","v":"    *** enter Contractor name in Step 2 ***"}]
[]
[null,"  Date: ",{"$f":"Initialize!E19","v":"00:00:00"},null,null,"By: "]
[null,null,null,null,null,null,null,"signature"]
[null,null,null,null,null,"Typed Name:  ",{"$f":"IF(Initialize!E21=0,\"    *** enter Contractor Representative's Name in Step 3 ***\",Initialize!E21)","v":"    *** enter Contractor Representative's Name in Step 3 ***"}]
[]
[]
[null,"ARCHITECT/ENGINEER CERTIFICATION"]
[]
[null,{"$f":"\"  This is to certify that, in accordance with the terms of a contract for Project Number \"&'General Project Info'!$F$6&\" executed\"","v":"  This is to certify that, in accordance with the terms of a contract for Project Number  executed"}]
[null,{"$f":"\"  the \"&'General Project Info'!$E$18&\" day of \"&'General Project Info'!$E$17&\", \"&'General Project Info'!$E$19&\" by and between, \"&'General Project Info'!$F$11&\",\"","v":"  the  day of ,  by and between, ,"}]
[null,{"$f":"\"  the contractor, and the Commonwealth of Virginia, \"&'General Project Info'!$F$8&\",\"","v":"  the contractor, and the Commonwealth of Virginia, ,"}]
[null,{"$f":"\"  the Owner, for work at \"&'General Project Info'!$F$9&\", there is due to the Contractor the amount of\"","v":"  the Owner, for work at , there is due to the Contractor the amount of"}]
[null,{"$f":"\"  \"&spellnumber(H23)&\"    \"&TEXT(H23,\"$#,###.00\")","v":{"$error":"#NAME?"}}]
[]
[null,"  Architect/Engineer:"]
[null,{"$f":"\"          \"&'General Project Info'!$F$10","v":"          "}]
[]
[null,"  By: "]
[null,null,"signature",null,null,null,"printed name",null,"date"]
[]
[]
[null,"AGENCY ACTION"]
[]
[null,"  Amount approved for payment this certificate is:"]
[]
[null,null,null,null,null,null,null," Dollars   (                                              )"]
[]
[null,"  By:"]
[null,null,"signature",null,null,null,"title",null,"date"]
[]
[null,"  By:"]
[null,null,"signature",null,null,null,"title",null,"date"]

{"sheet":"PART B","index":6,"n_rows":26,"n_cols":28,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,7,3,16],[0,0,2,3],[4,16,5,16],[4,3,4,7],[4,10,5,14]]}
["STEP 4 - Complete PART B"]
[]
[]
[]
["  DGS-30-104  ( FORM CO-12 )",null,null,"SCHEDULE OF VALUES AND CERTIFICATE FOR PAYMENT",null,null,null,null,null,null,"PAYMENT REQUEST NO. ",null,null,null,null,null,{"$f":"Initialize!E13","v":1}]
["  (Rev. 01/16)",null,null,"PROJECT CODE:",{"$f":"'General Project Info'!F6","v":0}]
["  PART B",null,null,"AGENCY NAME:",{"$f":"'General Project Info'!F8","v":0},null,null,null,null,null,null,null,null,null,"PERIOD BEGINNING DATE: ",null,{"$f":"Initialize!E15","v":"00:00:00"}]
["  ORIGINAL CONTRACT LINE ITEMS",null,null,"PROJECT TITLE:",{"$f":"'General Project Info'!F7","v":0},null,null,null,null,null,null,null,null,null,"PERIOD ENDING DATE: ",null,{"$f":"Initialize!E17","v":"00:00:00"}]
[]
[null,null,null,null,null,"VALUE OF WORK COMPLETED"]
["ITEM\n NO.","BUILDING ELEMENT","ADDITIONAL \nDESCRIPTION","TOTAL \nVALUE","PREVIOUS VALUE TO DATE","VALUE \nTHIS REPORT","CURRENT VALUE TO DATE","PERCENT COMPLETE","LINE ITEM RETAINAGE (PERCENT)","LINE ITEM RETAINAGE AMOUNT","VENDOR NAME","Micro","Small","Woman","Minority","Dis Vet","DSBSD CERTIFICATE NUMBER"]
[null,null,null,0,0,{"$f":"+G12-E12","v":0},{"$f":"ROUND(+D12*H12,2)","v":0},0,0.05,{"$f":"ROUND(G12*I12,2)","v":0},null,"N","N","N","N","N",null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA('PART B'!$I$12:$I$25)","v":14}]
[null,null,null,null,0,{"$f":"+G13-E13","v":0},{"$f":"ROUND(+D13*H13,2)","v":0},null,0.05,{"$f":"ROUND(G13*I13,2)","v":0},null,"N","N","N","N","N"]
[null,null,null,null,0,{"$f":"+G14-E14","v":0},{"$f":"ROUND(+D14*H14,2)","v":0},null,0.05,0,null,"N","N","N","N","N"]
[null,null,null,null,0,{"$f":"+G15-E15","v":0},{"$f":"ROUND(+D15*H15,2)","v":0},null,0.05,0,null,"N","N","N","N","N"]
[null,null,null,null,0,{"$f":"+G16-E16","v":0},{"$f":"ROUND(+D16*H16,2)","v":0},null,0.05,0,null,"N","N","N","N","N"]
[null,null,null,null,0,{"$f":"+G17-E17","v":0},{"$f":"ROUND(+D17*H17,2)","v":0},null,0.05,0,null,"N","N","N","N","N"]
[null,null,null,null,0,0,0,null,0.05,0,null,"N","N","N","N","N"]
[null,null,null,null,0,0,0,null,0.05,0,null,"N","N","N","N","N"]
[null,null,null,null,0,0,0,null,0.05,0,null,"N","N","N","N","N"]
[null,null,null,null,0,0,0,null,0.05,0,null,"N","N","N","N","N"]
[null,null,null,null,0,0,0,null,0.05,0,null,"N","N","N","N","N"]
[null,null,null,null,0,{"$f":"+G23-E23","v":0},{"$f":"ROUND(+D23*H23,2)","v":0},null,0.05,{"$f":"ROUND(G23*I23,2)","v":0},null,"N","N","N","N","N"]
[null,null,null,null,0,{"$f":"+G24-E24","v":0},{"$f":"ROUND(+D24*H24,2)","v":0},null,0.05,{"$f":"ROUND(G24*I24,2)","v":0},null,"N","N","N","N","N"]
[null,null,"DO NOT EDIT OR DELETE. See 2nd note in red above.",null,0,{"$f":"+G25-E25","v":0},{"$f":"ROUND(+D25*H25,2)","v":0},null,0.05,0,null,"N","N","N","N","N"]
["  TOTAL ORIGINAL CONTRACT",null,null,{"$f":"SUM(D12:D25)","v":0},{"$f":"SUM(E12:E25)","v":0},{"$f":"SUM(F12:F25)","v":0},{"$f":"SUM(G12:G25)","v":0},{"$f":"IF(D26=0,0,G26/D26)","v":0},{"$f":"IF(G26=0,0,J26/G26)","v":0},{"$f":"SUM(J12:J25)","v":0}]

{"sheet":"PART C","index":7,"n_rows":24,"n_cols":28,"rows_kept":24,"cut":false,"hidden":false,"merged":[[4,15,5,15],[4,2,4,6],[4,9,5,12],[0,0,2,2],[0,6,3,15]]}
["STEP 5 - Complete PART C"]
[]
[]
[]
["  DGS-30-104  ( FORM CO-12 )",null,"SCHEDULE OF VALUES AND CERTIFICATE FOR PAYMENT",null,null,null,null,null,null,"PAYMENT REQUEST NO. ",null,null,null,null,null,{"$f":"Initialize!E13","v":1}]
["  (Rev. 01/16)",null,"PROJECT CODE:",{"$f":"'General Project Info'!F6","v":0}]
["  PART C",null,"AGENCY NAME:",{"$f":"'General Project Info'!F8","v":0},null,null,null,null,null,null,null,null,"PERIOD BEGINNING DATE: ",null,null,{"$f":"Initialize!E15","v":"00:00:00"}]
["  CONSTRUCTION CHANGE ORDERS",null,"PROJECT TITLE:",{"$f":"'General Project Info'!F7","v":0},null,null,null,null,null,null,null,null,"PERIOD ENDING DATE: ",null,null,{"$f":"Initialize!E17","v":"00:00:00"}]
[]
[null,null,null,null,"VALUE OF WORK COMPLETED"]
["CHNG. ORD. NO.","ITEM DESCRIPTION","TOTAL \nVALUE","PREVIOUS VALUE\n TO DATE","VALUE THIS REPORT","CURRENT VALUE \nTO DATE","PERCENT COMPLETE","LINE ITEM RETAINAGE (PERCENT)","LINE ITEM RETAINAGE AMOUNT","VENDOR NAME","Micro","Small","Woman","Minority","Dis Vet","DSBSD CERTIFICATE NUMBER"]
[null,null,0,0,{"$f":"+F12-D12","v":0},{"$f":"ROUND(+C12*G12,2)","v":0},0,0.05,{"$f":"ROUND(F12*H12,2)","v":0},null,"N","N","N","N","N",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA('PART C'!$H$12:$H$23)","v":12}]
[null,null,null,0,{"$f":"+F13-D13","v":0},{"$f":"ROUND(+C13*G13,2)","v":0},null,0.05,{"$f":"ROUND(F13*H13,2)","v":0},null,"N","N","N","N","N"]
[null,null,null,0,0,0,null,0.05,0,null,"N","N","N","N","N"]
[null,null,null,0,0,0,null,0.05,0,null,"N","N","N","N","N"]
[null,null,null,0,0,0,null,0.05,0,null,"N","N","N","N","N"]
[null,null,null,0,0,0,null,0.05,0,null,"N","N","N","N","N"]
[null,null,null,0,0,0,null,0.05,0,null,"N","N","N","N","N"]
[null,null,null,0,0,0,null,0.05,0,null,"N","N","N","N","N"]
[null,null,null,0,{"$f":"+F20-D20","v":0},{"$f":"ROUND(+C20*G20,2)","v":0},null,0.05,{"$f":"ROUND(F20*H20,2)","v":0},null,"N","N","N","N","N"]
[null,null,null,0,{"$f":"+F21-D21","v":0},{"$f":"ROUND(+C21*G21,2)","v":0},null,0.05,{"$f":"ROUND(F21*H21,2)","v":0},null,"N","N","N","N","N"]
[null,null,null,0,{"$f":"+F22-D22","v":0},{"$f":"ROUND(+C22*G22,2)","v":0},null,0.05,{"$f":"ROUND(F22*H22,2)","v":0},null,"N","N","N","N","N"]
[null,"DO NOT EDIT OR DELETE.\nSee 2nd note in red above.",null,0,0,0,null,0.05,0,null,"N","N","N","N","N"]
["TOTAL APPROVED CHANGE ORDERS",null,{"$f":"SUM(C12:C23)","v":0},{"$f":"SUM(D12:D23)","v":0},{"$f":"SUM(E12:E23)","v":0},{"$f":"SUM(F12:F23)","v":0},{"$f":"IF(C24=0,0,F24/C24)","v":0},{"$f":"IF(F24=0,0,I24/F24)","v":0},{"$f":"SUM(I12:I23)","v":0}]

{"sheet":"Print","index":8,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,3,3]]}
[]
[null,"STEP 7 - Print the CO-12"]

{"sheet":"PART B Instructions","index":9,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,0,32,12],[30,0,30,8],[14,1,14,12],[24,4,24,12],[20,4,20,12],[28,9,28,16],[1,1,1,6],[26,0,26,12],[28,0,28,6],[17,1,17,12],[21,4,21,12],[18,3,18,12]]}
[]
[null,"PART B Instructions"]
[]
[null,"The ORIGINAL CONTRACT line items ( and progress for same ) are entered in PART B of the CO-12 form."]
[null,"Below is an example PART B with detailed instructions shown in red."]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"VALUE OF WORK COMPLETED"]
["ITEM\n NO.","BUILDING ELEMENT","ADDITIONAL \nDESCRIPTION","TOTAL \nVALUE","PREVIOUS VALUE TO DATE","VALUE \nTHIS REPORT","CURRENT VALUE TO DATE","PERCENT COMPLETE","LINE ITEM RETAINAGE (PERCENT)","LINE ITEM RETAINAGE AMOUNT","VENDOR NAME","Micro","Small","Woman","Minority","Dis Vet","DSBSD CERTIFICATE NUMBER"]
["100 L","B1010  Floor Construction","Structural Steel Material",5675,0,{"$f":"+G14-E14","v":0},{"$f":"ROUND(+D14*H14,2)","v":0},0,0.05,{"$f":"G14*I14","v":0},null,"N","N","N","N","N"]
[null," Enter a unique number for each line item.  ( Examples:  1, 2, 3…..   1A, 1B, 1C……   100, 200, 300…..    100.1, 100.2, 100.3. )  No specific format is mandated for Item Number field."]
[500,"G2020 Parking Lots","Lot A",30000,0,{"$f":"+G16-E16","v":0},{"$f":"ROUND(+D16*H16,2)","v":0},0,0.05,{"$f":"G16*I16","v":0},null,"N","N","N","N","N"]
[null,null,"         Select a Building Element from the ASTM Uniformat list.   Building Elements may be entered multiple times."]
[null,"                                        Enter additional description of the work item ( e.g., floor, wing, etc.), as needed,  to provide sufficient detail for progress to be assessed."]
[null,null,null,"( For Example:   1st Floor, 2nd Floor, …., East Wing, West Wing, …., Chiller A, Chiller B, …. etc.)"]
[501,"G2020 Parking Lots","Lot B",50000,0,{"$f":"+G20-E20","v":0},{"$f":"ROUND(+D20*H20,2)","v":0},0,0.05,{"$f":"G20*I20","v":0},null,"N","N","N","N","N"]
[null,null,null,null,"If payment will be sought for stored materials, labor and materials must be shown on separate lines."]
[null,null,null,null,"Provide other supporting documentation as required by the General Conditions."]
["100 L","B1010  Floor Construction","Structural Steel Material",5675,0,{"$f":"+G23-E23","v":0},{"$f":"ROUND(+D23*H23,2)","v":0},0,0.05,{"$f":"G23*I23","v":0},null,"N","N","N","N","N"]
["100 M","B1010  Floor Construction","Structural Steel Installation",0,0,{"$f":"+G24-E24","v":0},{"$f":"ROUND(+D24*H24,2)","v":0},0,0.05,{"$f":"G24*I24","v":0},null,"N","N","N","N","N"]
[null,null,null,null,"Enter the original contract value for each line item."]
["100 L","B1010  Floor Construction","Structural Steel Material",5675,0,{"$f":"+G26-E26","v":0},{"$f":"ROUND(+D26*H26,2)","v":0},0,0.05,{"$f":"G26*I26","v":0},null,"N","N","N","N","N"]
["                           Do not enter data in these columns.                                                                                   (These values are computed by worksheet formulas. )"]
[500,"G2020 Parking Lots","Lot A",30000,0,{"$f":"+G28-E28","v":0},{"$f":"ROUND(+D28*H28,2)","v":0},0,0.05,{"$f":"G28*I28","v":0},null,"N","N","N","N","N"]
["  Enter the total progress (percent complete) for each line item.",null,null,null,null,null,null,null,null,"  Enter the retainage percentage for each line item."]
[501,"G2020 Parking Lots","Lot B",50000,0,{"$f":"+G30-E30","v":22500},{"$f":"ROUND(+D30*H30,2)","v":22500},0.45,0.05,{"$f":"G30*I30","v":1125},null,"N","N","N","N","N"]
["                    If subcontractor is a Small (S), Woman (W), or Minority (M) - owned business, enter vendor name, and Yes (Y) or No (N) for S, W, M status."]
[502,"G2020 Parking Lots","Lot C",30000,0,{"$f":"+G32-E32","v":7500},{"$f":"ROUND(+D32*H32,2)","v":7500},0.25,0.05,{"$f":"G32*I32","v":375},"Smith's Paving Services","N","N","N","N","N","99999-999"]
["                         If subcontractor is a Small (S), Woman (W), or Minority (M) - owned business, enter their Department of Minority Business Enterprise (DMBE) certificate number."]

{"sheet":"PART C Instructions","index":10,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,0,31,11],[29,0,29,7],[19,1,19,11],[23,3,23,11],[1,1,1,5],[25,0,25,11],[20,2,20,11],[27,0,27,5],[14,1,14,11],[17,1,17,11]]}
[]
[null,"PART C Instructions"]
[]
[null,"The CONSTRUCTION CHANGE ORDERS ( and progress for same ) are entered in PART C of the CO-12 form."]
[null,"Below is an example PART C with detailed instructions shown in red."]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"VALUE OF WORK COMPLETED"]
["ITEM\n NO.","BUILDING ELEMENT","TOTAL \nVALUE","PREVIOUS VALUE TO DATE","VALUE \nTHIS REPORT","CURRENT VALUE TO DATE","PERCENT COMPLETE","LINE ITEM RETAINAGE (PERCENT)","LINE ITEM RETAINAGE AMOUNT","VENDOR NAME","Micro","Small","Woman","Minority","Dis Vet","DSBSD CERTIFICATE NUMBER"]
[1,"ADDITIONAL LANDSCAPING",10000,0,{"$f":"+F14-D14","v":0},{"$f":"ROUND(+C14*G14,2)","v":0},0,0.05,{"$f":"F14*H14","v":0},null,"N","N","N","N","N"]
[null," Enter the Change Order Number.  ( Examples:  1, 2, 3…..).  Additional identifying numbers and/or letters may be added as shown in examples below as needed."]
["1a","ADDITIONAL LANDSCAPING - Additional trees and shrubs",6000,0,{"$f":"+F16-D16","v":0},{"$f":"ROUND(+C16*G16,2)","v":0},0,0.05,{"$f":"F16*H16","v":0},null,"N","N","N","N","N"]
["1b","ADDITIONAL LANDSCAPING - Extend irrigation system",4000,0,{"$f":"+F17-D17","v":0},{"$f":"ROUND(+C17*G17,2)","v":0},0,0.05,{"$f":"F17*H17","v":0},null,"N","N","N","N","N"]
[null," If necessary to provide more detail for a specific Change Order, use multiple lines for each component as needed. "]
[3," EPDM Roofing",0,0,{"$f":"+F19-D19","v":0},{"$f":"ROUND(+C19*G19,2)","v":0},0,0.05,{"$f":"F19*H19","v":0},null,"N","N","N","N","N"]
[null,"                                     Enter a Change Order description.   ( Line items must be broken out in a sufficient level of detail to allow Owner and A/E to assess progress. )"]
[null,null,"    If payment will be sought for stored materials, labor and materials must be entered on separate lines."]
["4 L","Structural Steel - Installation",0,0,{"$f":"+F22-D22","v":0},{"$f":"ROUND(+C22*G22,2)","v":0},0,0.05,{"$f":"F22*H22","v":0},null,"N","N","N","N","N"]
["4 M","Structural Steel - Materials",0,0,{"$f":"+F23-D23","v":0},{"$f":"ROUND(+C23*G23,2)","v":0},0,0.05,{"$f":"F23*H23","v":0},null,"N","N","N","N","N"]
[null,null,null,"Enter the scheduled value for each Change Order or component thereof."]
["5 L","Structural Steel - Installation",5675,0,{"$f":"+F25-D25","v":0},{"$f":"ROUND(+C25*G25,2)","v":0},0,0.05,{"$f":"F25*H25","v":0},null,"N","N","N","N","N"]
[" Do not enter data in these  columns.                                                        (These values are computed by worksheet formulas. )"]
[6.1,"Pave Parking Lot A",30000,0,{"$f":"+F27-D27","v":0},{"$f":"ROUND(+C27*G27,2)","v":0},0,0.05,{"$f":"F27*H27","v":0},null,"N","N","N","N","N"]
["  Enter the total progress (percent complete) for each line item."]
[6.2,"Pave Parking Lot B",50000,0,{"$f":"+F29-D29","v":37500},{"$f":"ROUND(+C29*G29,2)","v":37500},0.75,0.05,{"$f":"F29*H29","v":1875},null,"N","N","N","N","N"]
["  If subcontractor is a Small (S), Woman (W), or Minority (M) - owned business, enter vendor name, and Yes (Y) or No (N) for S, W, M status."]
[6.3,"Pave Parking Lot C",30000,10000,{"$f":"+F31-D31","v":20000},{"$f":"+C31*G31","v":30000},1,0.05,{"$f":"F31*H31","v":1500},"Smith's Paving Services","N","N","N","N","N","99999-999"]
["          If subcontractor is a Small (S), Woman (W), or Minority (M) - owned business, enter their Department of Minority Business Certificate (DMBE) certificate number."]

{"sheet":"Days","index":11,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["first"]
["second"]
["third"]
["fourth"]
["fifth"]
["sixth"]
["seventh"]
["eighth"]
["ninth"]
["tenth"]
["eleventh"]
["twelfth"]
["thirteenth"]
["fourteenth"]
["fifthteenth"]
["sixteenth"]
["seventeenth"]
["eighteenth"]
["nineteenth"]
["twentieth"]
["twenty-first"]
["twenty-second"]
["twenty-third"]
["twenty-fourth"]
["twenty-fifth"]
["twenty-sixth"]
["twenty-seventh"]
["twenty-eighth"]
["twenty-ninth"]
["thirtieth"]
["thirty-first"]

{"sheet":"Code","index":12,"n_rows":95,"n_cols":4,"rows_kept":95,"cut":false,"hidden":false,"merged":[[3,1,5,3],[94,1,94,3]]}
[]
[null,"Use the Level III classification to describe Building Elements in the Schedule of Values."]
[]
[null,"Extracted, with permission, from ASTM E1557-09 Standard Classification for Building Elements and Related Sitework-UNIFORMAT II, copyright ASTM International, 100 Barr Harbor Drive, West Conshohocken, PA 19428.  A copy of the complete standard may be obtained from ASTM International, www.astm.org.\n\n \n"]
[]
[]
[null,"( Click here to visit astm.org )"]
[]
[null,"Level I","Level II","Level III"]
[null,null,null,"Code"]
[null,"A  Substructure","A10  Foundations","A1010  Standard Foundations"]
[null,null,null,"A1020  Special Foundations"]
[null,null,null,"A1030  Slab on Grade"]
[null,null,"A20  Basement Construction","A2010  Basement Excavation"]
[null,null,null,"A2020  Basement Walls"]
[null,"B  Shell","B10  Superstructure","B1010  Floor Construction"]
[null,null,null,"B1020  Roof Construction"]
[null,null,"B20  Exterior Enclosure","B2010  Exterior Walls"]
[null,null,null,"B2020  Exterior Windows"]
[null,null,null,"B2030  Exterior Doors"]
[null,null,"B30  Roofing","B3010  Roof Coverings"]
[null,null,null,"B3020  Roof Openings"]
[null,"C  Interiors","C10  Interior Construction","C1010  Partitions"]
[null,null,null,"C1020  Interior Doors"]
[null,null,null,"C1030  Fittings"]
[null,null,"C20  Stairs","C2010  Stair Construction"]
[null,null,null,"C2020  Stair Finishes"]
[null,null,"C30  Interior Finishes","C3010  Wall Finishes"]
[null,null,null,"C3020  Floor Finishes"]
[null,null,null,"C3030  Ceiling Finishes"]
[null,"D  Services","D10  Conveying","D1010  Elevators & Lifts"]
[null,null,null,"D1020  Escalators & Moving Walks"]
[null,null,null,"D1090  Other Conveying Systems"]
[null,null,"D20  Plumbing","D2010  Plumbing Fixtures"]
[null,null,null,"D2020  Domestic Water Distribution"]
[null,null,null,"D2030  Sanitary Waste"]
[null,null,null,"D2040  Rain Water Drainage"]
[null,null,null,"D2090  Other Plumbing Systems"]
[null,null,"D30  HVAC","D3010  Energy Supply"]
[null,null,null,"D3020  Heat Generating Systems"]
[null,null,null,"D3030  Cooling Generating Systems"]
[null,null,null,"D3040  Distribution Systems"]
[null,null,null,"D3050  Terminal & Package Units"]
[null,null,null,"D3060  Controls & Instrumentation"]
[null,null,null,"D3070  System Testing & Balancing"]
[null,null,null,"D3090  Other HVAC Systems & Equipment"]
[null,null,"D40  Fire Protection","D4010  Sprinklers"]
[null,null,null,"D4020  Standpipes"]
[null,null,null,"D4030  Fire Protection Specialties"]
[null,null,null,"D4090  Other Fire Protection Systems"]
[null,null,"D50  Electrical","D5010  Electrical Service & Distribution"]
[null,null,null,"D5020  Lighting and Branch Wiring"]
[null,null,null,"D5030  Communications & Security"]
[null,null,null,"D5090  Other Electrical Systems"]
[null,"E  Equipment & Furnishings","E10  Equipment","E1010  Commercial Equipment"]
[null,null,null,"E1020  Institutional Equipment"]
[null,null,null,"E1030  Vehicular Equipment"]
[null,null,null,"E1090  Other Equipment"]
[null,null,"E20  Furnishings","E2010  Fixed Furnishings"]
[null,null,null,"E2020  Movable Furnishings"]
[null,"F  Special Construction & Demolition","F10  Special Construction","F1010  Special Structures"]
[null,null,null,"F1020  Integrated Construction"]
[null,null,null,"F1030  Special Construction Systems"]
[null,null,null,"F1040  Special Facilities"]
[null,null,null,"F1050  Special Controls and Instrumentation"]
[null,null,"F20  Selective Building Demolition","F2010  Building Elements Demolition"]
[null,null,null,"F2020  Hazardous Components Abatement"]
[null,"G  Sitework & Utilities","G10  Site Preparation","G1010  Site Clearing"]
[null,null,null,"G1020  Site Demolition and Relocations"]
[null,null,null,"G1030  Site Earthwork"]
[null,null,null,"G1040  Hazardous Waste Removal"]
[null,null,"G20  Site Improvements","G2010  Roadways"]
[null,null,null,"G2020  Parking Lots"]
[null,null,null,"G2030  Pedestrian Paving"]
[null,null,null,"G2040  Site Development"]
[null,null,null,"G2050  Landscaping"]
[null,null,"G30  Site Mechanical Utilities","G3010  Water Supply"]
[null,null,null,"G3020  Sanitary Sewer"]
[null,null,null,"G3030  Storm Sewer"]
[null,null,null,"G3040  Heating Distribution"]
[null,null,null,"G3050  Cooling Distribution"]
[null,null,null,"G3060  Fuel Distribution"]
[null,null,null,"G3090  Other Site Mechanical Utilities"]
[null,null,"G40  Site Electrical Utilities","G4010  Electrical Distribution"]
[null,null,null,"G4020  Site Lighting"]
[null,null,null,"G4030  Site Communications & Security"]
[null,null,null,"G4090  Other Site Electrical Utilities"]
[null,null,"G90  Other Site Construction","G9010  Services and Pedestrian Tunnels"]
[null,null,null,"G9090  Other Site Systems & Equipment"]
["*","Z  Gen'l. Cond. / OH&P","Z  Gen'l. Cond. / OH&P","Z0000  General Conditions / Gen'l Requirements, OH & P"]
[]
["* -","The last entry above is not part of the referenced ASTM Uniformat II classification standard."]
[]
[]
[null,"Click here to view PART B costs summarized by Building Element."]