{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Warnings","Instructions","Assistance","General Project Info","Initialize","PART A","PART B","PART C","Print","PART B Instructions","PART C Instructions","Days","Code","ELEMENT SUMMARY"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":31,"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":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[[35,3,35,10]]}
[]
[null,"UNIVERSITY of VIRGINIA ",null,null,null,null,null,null,"HECO - 12 "]
[null,"(Revised 10/10)"]
[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 2003, Macro Security must be set to \"Medium\" !"]
[]
[null,null,null,null,"Check the Excel macro security settings, by picking Tools, Macro, and Security from the"]
[null,null,null,null,"main Excel menu.  If macro security is set at \"High\" or \"Very High\", change it to \"Medium\""]
[null,null,null,null,"and then immediately close Excel.  When Excel is reopened, the new macro security"]
[null,null,null,null,"setting will take effect.  If you get a message to \"Enable\" or \"Disable\" macros, pick \"Enable\"."]
[]
[null,null,null,"If you use Excel 2007, you must 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 white cells "]
[null,null,null,null,"contain formulas which may be accidentally overwritten if spreadsheet is unprotected and data is entered directly"]
[null,null,null,null,"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"]
[null,null,null,null,"by overwriting or deleting data and/or formulas.  It is not the responsibility of the DGS staff to"]
[null,null,null,null,"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,"UNIVERSITY of VIRGINIA ",null,null,null,"HECO - 12 "]
[null,"(Revised 12/06/2010)"]
[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 HECO-12."]
[]
[]
[null,"NEXT MONTH - Repeat Steps 1 through 9."]

{"sheet":"Assistance","index":2,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[[26,2,45,7],[17,3,17,7],[18,3,18,7],[19,3,19,7],[21,3,21,7],[22,3,22,7],[23,3,23,7]]}
[{"$f":"Instructions!B3","v":"(Revised 12/06/2010)"}]
[]
[]
[null,"If you need assistance:"]
[]
[null,null,"For projects constructed under the provisions of the Higher Education Restructuring Act,"]
[null,null,"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 this"]
[null,null,"complete Excel file as an attachment to the following e-mail address:",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":29,"n_cols":5,"rows_kept":29,"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,"UVA PO # "]
[null,null,null,"UVA PIMS Project #"]
[null,null,null,"UVA WO #"]
[null,null,null,"UVA PIMS Acct Code"]
[]
[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":70,"n_cols":11,"rows_kept":70,"cut":false,"hidden":false,"merged":[[1,2,1,8],[20,4,20,6],[24,4,28,8],[29,4,31,8]]}
[]
[null,null,"STEP 3  -  Prepare the HECO-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":"2013-07-01"}]
[null,"A )",null,null,null,null,null,"NOTE:  This form was last initialized on:","2007-08-24"]
[]
[]
[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,null,"    Retainage Percentage:*",null,0.05]
[]
[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 HECO-12 Form runs a macro (an automated procedure) which prepares the HECO-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":"+H53-F53","v":10},{"$f":"+E53*I53","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":"+H56-F56","v":0},{"$f":"+E56*I56","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":"+H59-F59","v":20},{"$f":"+E59*I59","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":70,"n_cols":10,"rows_kept":70,"cut":false,"hidden":false,"merged":[[41,6,41,9],[50,1,51,9],[8,1,13,1],[4,9,5,9],[4,7,5,8],[4,3,4,6],[5,3,6,6],[0,1,2,3],[7,3,7,6],[39,2,39,3],[37,2,37,3],[37,6,37,9]]}
[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,"Univ. of Virginia    (Form HECO-12)",null,"SCHEDULE OF VALUES",null,null,null,"PAYMENT REQUEST NO. ",null,{"$f":"Initialize!E13","v":1}]
[null," (Rev. 12/06/2010)",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,null,null,"UVA PO # ",{"$f":"IF('General Project Info'!$F$14=0,\"*** enter UVA PO# in step 2***\",'General Project Info'!$F$14)","v":"*** enter UVA PO# in step 2***"}]
[null,null,"  AGENCY NAME:  ",{"$f":"'General Project Info'!F8","v":0},null,null,null,null,"PIMS Project:",{"$f":"IF('General Project Info'!$F$15=0,\"*** enter UVA PIMS# in step 2***\",'General Project Info'!$F$15)","v":"*** enter UVA PIMS# in step 2***"}]
[null,null,"  PROJECT TITLE:  ",{"$f":"'General Project Info'!F7","v":0},null,null,null,null,"WO #:",{"$f":"IF('General Project Info'!$F$16=0,\"*** enter UVA WO# in step 2***\",'General Project Info'!$F$16)","v":"*** enter UVA WO# in step 2***"}]
[null,null,null,null,null,null,null,null,"PIMS Acct Code",{"$f":"IF('General Project Info'!$F$17=0,\"*** enter PIMS Acct Code in step 2***\",'General Project Info'!$F$17)","v":"*** enter PIMS Acct Code in step 2***"}]
[]
[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 HECO-12, PART B)",null,null,null,{"$f":"'PART B'!$D$56","v":0},{"$f":"'PART B'!$E$56","v":0},{"$f":"'PART B'!$F$56","v":0},{"$f":"'PART B'!$G$56","v":0},{"$f":"IF(F20=0,0,+I20/F20)","v":0}]
[null,"  Approved Change Orders (from HECO-12, PART C)",null,null,null,{"$f":"'PART C'!C54","v":0},{"$f":"'PART C'!D54","v":0},{"$f":"'PART C'!E54","v":0},{"$f":"'PART C'!F54","v":0},{"$f":"IF(F21=0,0,+I21/F21)","v":0}]
[null,"  ADJUSTED CONTRACT TOTAL",null,null,null,{"$f":"F20+F21","v":0},{"$f":"G20+G21","v":0},{"$f":"H20+H21","v":0},{"$f":"I20+I21","v":0},{"$f":"IF(F22=0,0,+I22/F22)","v":0}]
[null,"  Retainage","Retainage Percentage:",{"$f":"Initialize!E23","v":0.05},null,null,0,{"$f":"I23-G23","v":0},{"$f":"ROUND(-I22*D23,2)","v":0}]
[null,"  NET REQUISTION AMOUNT",null,null,null,null,{"$f":"G22+G23","v":0},{"$f":"I24-G24","v":0},{"$f":"I22+I23","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$22&\" day of \"&'General Project Info'!$E$21&\", \"&'General Project Info'!$E$23&\" 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(H24)&\"    \"&TEXT(H24,\"$#,###.00\")","v":"  No Dollars and No Cents    $.00"}]
[]
[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,{"$f":"\"  \"&spellnumber(H24)&\"\"","v":"  No Dollars and No Cents"}]
[]
[null,null,null,null,null,null,null," Dollars   (                                              )",{"$f":"\"    \"&TEXT(H24,\"$#,###.00\")","v":"    $.00"},"  )"]
[]
[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":56,"n_cols":13,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,7,3,12],[0,0,2,3],[9,1,10,2],[4,12,5,12],[4,3,4,7],[4,8,5,11]]}
["STEP 4 - Complete PART B"]
[]
[]
[]
[" University of Virginia   (Form HECO-12)",null,null,"SCHEDULE OF VALUES AND CERTIFICATE FOR PAYMENT",null,null,null,null,"PAYMENT REQUEST NO. ",null,null,null,{"$f":"Initialize!E13","v":1}]
[{"$f":"'PART A'!B6","v":" (Rev. 12/06/2010)"},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,"PERIOD BEGINNING DATE: ",{"$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,"PERIOD ENDING DATE: ",{"$f":"Initialize!E17","v":"00:00:00"}]
[]
[null,"DESCRIPTION",null,null,null,"VALUE OF WORK COMPLETED"]
[null,null,null,null,"PREVIOUS","VALUE","CURRENT",null,null,null,null,null,"DMBE"]
["ITEM","BUILDING","ADDITONAL","TOTAL","VALUE","THIS","VALUE","PERCENT","VENDOR",null,null,null,"CERTIFICATE"]
["NO.","ELEMENT","DESCRIPTION","VALUE","TO DATE","REPORT","TO DATE","COMPLETE","NAME","S","W","M","NUMBER"]
[]
[null,null,null,0,0,{"$f":"+G15-E15","v":0},{"$f":"ROUND(+D15*H15,2)","v":0},0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,{"$f":"ROUND(+D18*H18,2)","v":0},0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,{"$f":"ROUND(+D20*H20,2)","v":0},0,null,"N","N","N"]
[null,null,null,0,0,{"$f":"+G21-E21","v":0},0,0,null,"N","N","N"]
[null,null,null,0,0,{"$f":"+G22-E22","v":0},0,0,null,"N","N","N"]
[null,null,null,0,0,0,{"$f":"ROUND(+D23*H23,2)","v":0},0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,{"$f":"+G29-E29","v":0},0,0,null,"N","N","N"]
[null,null,null,0,0,{"$f":"+G30-E30","v":0},0,0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,{"$f":"+G36-E36","v":0},0,0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,{"$f":"ROUND(+D50*H50,2)","v":0},0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,{"$f":"ROUND(+D52*H52,2)","v":0},0,null,"N","N","N"]
[null,null,"Do not insert rows below this point !",0,0,0,0,0,null,"N","N","N"]
[null,null,null,0,0,0,0,0,null,"N","N","N"]
[]
["TOTAL ORIGINAL CONTRACT",null,null,{"$f":"SUM(D14:D55)","v":0},{"$f":"SUM(E14:E55)","v":0},{"$f":"SUM(F14:F55)","v":0},{"$f":"SUM(G14:G55)","v":0},{"$f":"IF(D56=0,0,G56/D56)","v":0}]

{"sheet":"PART C","index":7,"n_rows":54,"n_cols":12,"rows_kept":54,"cut":false,"hidden":false,"merged":[[4,11,5,11],[4,2,4,6],[4,7,5,10],[0,0,2,2],[0,6,3,11]]}
["STEP 5 - Complete PART C"]
[]
[]
[]
["University of Virginia   (Form HECO-12)",null,"SCHEDULE OF VALUES AND CERTIFICATE FOR PAYMENT",null,null,null,null,"PAYMENT REQUEST NO. ",null,null,null,{"$f":"Initialize!E13","v":1}]
[{"$f":"'PART A'!B6","v":" (Rev. 12/06/2010)"},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,"PERIOD BEGINNING DATE: ",{"$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,"PERIOD ENDING DATE: ",{"$f":"Initialize!E17","v":"00:00:00"}]
[]
[null,null,null,null,"VALUE OF WORK COMPLETED"]
["CHNG",null,null,"PREVIOUS","VALUE","CURRENT",null,null,null,null,null,"DMBE"]
["ORD.","ITEM","TOTAL","VALUE","THIS","VALUE","PERCENT","VENDOR",null,null,null,"CERTIFICATE"]
["NO.","DESCRIPTION","VALUE","TO DATE","REPORT","TO DATE","COMPLETE","NAME","S","W","M","NUMBER"]
[]
[null,null,0,0,{"$f":"+F15-D15","v":0},{"$f":"ROUND(+C15*G15,2)","v":0},0,null,"N","N","N"]
[null,null,0,0,{"$f":"+F16-D16","v":0},0,0,null,"N","N","N"]
[null,null,0,0,{"$f":"+F17-D17","v":0},0,0,null,"N","N","N"]
[null,null,0,0,{"$f":"+F18-D18","v":0},0,0,null,"N","N","N"]
[null,null,0,0,{"$f":"+F19-D19","v":0},0,0,null,"N","N","N"]
[null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,0,0,0,{"$f":"ROUND(+C21*G21,2)","v":0},0,null,"N","N","N"]
[null,null,0,0,{"$f":"+F22-D22","v":0},0,0,null,"N","N","N"]
[null,null,0,0,{"$f":"+F23-D23","v":0},0,0,null,"N","N","N"]
[null,null,0,0,{"$f":"+F24-D24","v":0},0,0,null,"N","N","N"]
[null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,0,0,0,0,0,null,"N","N","N"]
[null,null,0,0,{"$f":"+F47-D47","v":0},{"$f":"ROUND(+C47*G47,2)","v":0},0,null,"N","N","N"]
[null,null,0,0,{"$f":"+F48-D48","v":0},{"$f":"ROUND(+C48*G48,2)","v":0},0,null,"N","N","N"]
[null,null,0,0,{"$f":"+F49-D49","v":0},{"$f":"ROUND(+C49*G49,2)","v":0},0,null,"N","N","N"]
[null,null,0,0,{"$f":"+F50-D50","v":0},{"$f":"ROUND(+C50*G50,2)","v":0},0,null,"N","N","N"]
[null,"Do not insert rows below this point !",0,0,0,0,0,null,"N","N","N"]
[null,null,0,0,{"$f":"+F52-D52","v":0},0,0,null,"N","N","N"]
[]
["TOTAL APPROVED CHANGE ORDERS",null,{"$f":"SUM(C14:C53)","v":0},{"$f":"SUM(D14:D53)","v":0},{"$f":"SUM(E14:E53)","v":0},{"$f":"SUM(F14:F53)","v":0},{"$f":"IF(C54=0,0,F54/C54)","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 HECO-12"]

{"sheet":"PART B Instructions","index":9,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,0,36,12],[34,0,34,8],[18,1,18,12],[28,4,28,12],[1,1,1,6],[30,0,30,12],[32,0,32,6],[24,0,24,12],[21,1,21,12],[11,1,12,2],[25,4,25,12],[22,3,22,12]]}
[]
[null,"PART B Instructions"]
[]
[null,"The ORIGINAL CONTRACT line items ( and progress for same ) are entered in PART B of the HECO-12 form."]
[null,"Below is an example PART B with detailed instructions shown in red."]
[null,"( Scroll down this page to view the step-by-step instructions. )"]
[]
[]
[]
[]
[]
[null,"DESCRIPTION",null,null,null,"VALUE OF WORK COMPLETED"]
[null,null,null,null,"PREVIOUS","VALUE","CURRENT",null,null,null,null,null,"DMBE"]
["ITEM","BUILDING","ADDITIONAL","TOTAL","VALUE","THIS","VALUE","PERCENT","VENDOR",null,null,null,"CERTIFICATE"]
["NO.","ELEMENT","DESCRIPTION","VALUE","TO DATE","REPORT","TO DATE","COMPLETE","NAME","S","W","M","NUMBER"]
[]
[null,null,null,0,0,{"$f":"+G17-E17","v":0},{"$f":"+D17*H17","v":0},0,null,"N","N","N"]
[1,null,null,0,0,{"$f":"+G18-E18","v":0},{"$f":"+D18*H18","v":0},0,null,"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."]
[1,"B1010  Floor Construction","2nd Floor",0,0,{"$f":"+G20-E20","v":0},{"$f":"+D20*H20","v":0},0,null,"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.)"]
[1,"B1010  Floor Construction","3rd Floor",0,0,{"$f":"+G24-E24","v":0},{"$f":"+D24*H24","v":0},0,null,"N","N","N"]
[]
[null,null,null,null,"    If payment will be sought for material stored off-site, labor and material must be entered on separate lines."]
["100 L","B1010  Floor Construction","Structural Steel Material",0,0,{"$f":"+G27-E27","v":0},{"$f":"+D27*H27","v":0},0,null,"N","N","N"]
["100 M","B1010  Floor Construction","Structural Steel Installation",0,0,{"$f":"+G28-E28","v":0},{"$f":"+D28*H28","v":0},0,null,"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":"+G30-E30","v":0},{"$f":"+D30*H30","v":0},0,null,"N","N","N"]
["                           Do not enter data in these three columns.                                         (These values are computed by worksheet formulas. )"]
[500,"G2020 Parking Lots","Lot A",30000,5000,{"$f":"+G32-E32","v":10000},{"$f":"+D32*H32","v":15000},0.5,null,"N","N","N"]
["  Enter the total progress (percent complete) for each line item."]
[501,"G2020 Parking Lots","Lot B",50000,10000,{"$f":"+G34-E34","v":27500},{"$f":"+D34*H34","v":37500},0.75,null,"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,10000,{"$f":"+G36-E36","v":20000},{"$f":"+D36*H36","v":30000},1,"Smith's Paving Services","Y","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":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,0,35,11],[33,0,33,7],[23,1,23,11],[27,3,27,11],[1,1,1,5],[29,0,29,11],[24,2,24,11],[31,0,31,5],[18,1,18,11],[21,1,21,11]]}
[]
[null,"PART C Instructions"]
[]
[null,"The CONSTRUCTION CHANGE ORDERS ( and progress for same ) are entered in PART C of the HECO-12 form."]
[null,"Below is an example PART C with detailed instructions shown in red."]
[null,"( Scroll down this page to view the step-by-step instructions. )"]
[]
[]
[]
[]
[]
[null,null,null,null,"VALUE OF WORK COMPLETED"]
["CHNG",null,null,"PREVIOUS","VALUE","CURRENT",null,null,null,null,null,"DMBE"]
["ORD.","ITEM","TOTAL","VALUE","THIS","VALUE","PERCENT","VENDOR",null,null,null,"CERTIFICATE"]
["NO.","DESCRIPTION","VALUE","TO DATE","REPORT","TO DATE","COMPLETE","NAME","S","W","M","NUMBER"]
[]
[null,null,0,0,{"$f":"+F17-D17","v":0},{"$f":"+C17*G17","v":0},0,null,"N","N","N"]
[1,"ADDITIONAL LANDSCAPING",10000,0,{"$f":"+F18-D18","v":0},{"$f":"+C18*G18","v":0},0,null,"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":"+F20-D20","v":0},{"$f":"+C20*G20","v":0},0,null,"N","N","N"]
["1b","ADDITIONAL LANDSCAPING - Extend irrigation system",4000,0,{"$f":"+F21-D21","v":0},{"$f":"+C21*G21","v":0},0,null,"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":"+F23-D23","v":0},{"$f":"+C23*G23","v":0},0,null,"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 material stored off-site, labor and material must be entered on separate lines."]
["4 L","Structural Steel - Installation",0,0,{"$f":"+F26-D26","v":0},{"$f":"+C26*G26","v":0},0,null,"N","N","N"]
["4 M","Structural Steel - Materials",0,0,{"$f":"+F27-D27","v":0},{"$f":"+C27*G27","v":0},0,null,"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":"+F29-D29","v":0},{"$f":"+C29*G29","v":0},0,null,"N","N","N"]
[" Do not enter data in these three columns.                               (These values are computed by worksheet formulas. )"]
[6.1,"Pave Parking Lot A",30000,5000,{"$f":"+F31-D31","v":10000},{"$f":"+C31*G31","v":15000},0.5,null,"N","N","N"]
["  Enter the total progress (percent complete) for each line item."]
[6.2,"Pave Parking Lot B",50000,10000,{"$f":"+F33-D33","v":27500},{"$f":"+C33*G33","v":37500},0.75,null,"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":"+F35-D35","v":20000},{"$f":"+C35*G35","v":30000},1,"Smith's Paving Services","Y","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."]

{"sheet":"ELEMENT SUMMARY","index":13,"n_rows":141,"n_cols":88,"rows_kept":141,"cut":false,"hidden":false,"merged":[[5,3,5,4],[6,3,6,4],[7,3,7,4],[1,7,3,7],[3,1,3,5]]}
[]
[null,null,null,null,null,null,null,"DSUM FORMULAS FOR DATA COLLECTION FROM PART B","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT","ELEMENT"]
[null,null,null,null,null,null,null,null,"A1010  Standard Foundations",{"$f":"\"A1020  Special Foundations\"","v":"A1020  Special Foundations"},"A1030  Slab on Grade","A2010  Basement Excavation","A2020  Basement Walls","B1010  Floor Construction","B1020  Roof Construction","B2010  Exterior Walls","B2020  Exterior Windows","B2030  Exterior Doors","B3010  Roof Coverings","B3020  Roof Openings","C1010  Partitions","C1020  Interior Doors","C1030  Fittings","C2010  Stair Construction","C2020  Stair Finishes","C3010  Wall Finishes","C3020  Floor Finishes","C3030  Ceiling Finishes","D1010  Elevators & Lifts","D1020  Escalators & Moving Walks","D1090  Other Conveying Systems","D2010  Plumbing Fixtures","D2020  Domestic Water Distribution","D2030  Sanitary Waste","D2040  Rain Water Drainage","D2090  Other Plumbing Systems","D3010  Energy Supply","D3020  Heat Generating Systems","D3030  Cooling Generating Systems","D3040  Distribution Systems","D3050  Terminal & Package Units","D3060  Controls & Instrumentation","D3070  System Testing & Balancing","D3090  Other HVAC Systems & Equipment","D4010  Sprinklers","D4020  Standpipes","D4030  Fire Protection Specialties","D4090  Other Fire Protection Systems","D5010  Electrical Service & Distribution","D5020  Lighting and Branch Wiring","D5030  Communications & Security","D5090  Other Electrical Systems","E1010  Commercial Equipment","E1020  Institutional Equipment","E1030  Vehicular Equipment","E1090  Other Equipment","E2010  Fixed Furnishings","E2020  Movable Furnishings","F1010  Special Structures","F1020  Integrated Construction","F1030  Special Construction Systems","F1040  Special Facilities","F1050  Special Controls and Instrumentation","F2010  Building Elements Demolition","F2020  Hazardous Components Abatement","G1010  Site Clearing","G1020  Site Demolition and Relocations","G1030  Site Earthwork","G1040  Hazardous Waste Removal","G2010  Roadways","G2020  Parking Lots","G2030  Pedestrian Paving","G2040  Site Development","G2050  Landscaping","G3010  Water Supply","G3020  Sanitary Sewer","G3030  Storm Sewer","G3040  Heating Distribution","G3050  Cooling Distribution","G3060  Fuel Distribution","G3090  Other Site Mechanical Utilities","G4010  Electrical Distribution","G4020  Site Lighting","G4030  Site Communications & Security","G4090  Other Site Electrical Utilities","G9010  Services and Pedestrian Tunnels","G9090  Other Site Systems & Equipment","Z0000  General Conditions / Gen'l Requirements, OH & P"]
[null,"Original CO-12 Contract Values, summarized by Building Element",null,null,null,null,null,null,{"$f":"DSUM(ELEMENT_DATA,\"VALUE\",I2:I3)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"DSUM(ELEMENT_DATA,\"VALUE\",AO2:AO3)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"DSUM(ELEMENT_DATA,\"VALUE\",BU2:BU3)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[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,"LEVEL I SUMMARY "]
[]
[null,null,"CODE","DESCRIPTION","AMOUNT"]
[]
[null,null,"A","Substructure",{"$f":"SUM(E30:E31)","v":0}]
[null,null,"B","Shell",{"$f":"SUM(E32:E34)","v":0}]
[null,null,"C","Interiors",{"$f":"SUM(E35:E37)","v":0}]
[null,null,"D","Services",{"$f":"SUM(E38:E42)","v":0}]
[null,null,"E","Equipment & Furnishings",{"$f":"SUM(E43:E44)","v":0}]
[null,null,"F","Special Construction & Demolition",{"$f":"SUM(E45:E46)","v":0}]
[null,null,"G","Sitework & Utilities",{"$f":"SUM(E47:E51)","v":0}]
[null,null,"Z","Gen'l. Cond. / Gen'l. Reqmnts / OH&P",{"$f":"E52","v":0}]
[null,null,null,"TOTAL",{"$f":"SUM(E15:E22)","v":0}]
[]
[]
[]
[null,null,null,"LEVEL II SUMMARY "]
[]
[null,null,"CODE","DESCRIPTION","AMOUNT"]
[null,null,"A10","Foundations",{"$f":"SUM(E61:E63)","v":0}]
[null,null,"A20","Basement Construction",{"$f":"SUM(E64:E65)","v":0}]
[null,null,"B10","Superstructure",{"$f":"SUM(E66:E67)","v":0}]
[null,null,"B20","Exterior Enclosure",{"$f":"SUM(E68:E70)","v":0}]
[null,null,"B30","Roofing",{"$f":"SUM(E71:E72)","v":0}]
[null,null,"C10","Interior Construction",{"$f":"SUM(E73:E75)","v":0}]
[null,null,"C20","Stairs",{"$f":"SUM(E76:E77)","v":0}]
[null,null,"C30","Interior Finishes",{"$f":"SUM(E78:E80)","v":0}]
[null,null,"D10","Conveying",{"$f":"SUM(E81:E83)","v":0}]
[null,null,"D20","Plumbing",{"$f":"SUM(E84:E88)","v":0}]
[null,null,"D30","HVAC",{"$f":"SUM(E89:E96)","v":0}]
[null,null,"D40","Fire Protection",{"$f":"SUM(E97:E100)","v":0}]
[null,null,"D50","Electrical",{"$f":"SUM(E101:E104)","v":0}]
[null,null,"E10","Equipment",{"$f":"SUM(E105:E108)","v":0}]
[null,null,"E20","Furnishings",{"$f":"SUM(E109:E110)","v":0}]
[null,null,"F10","Special Construction",{"$f":"SUM(E111:E115)","v":0}]
[null,null,"F20","Selective Building Demolition",{"$f":"SUM(E116:E117)","v":0}]
[null,null,"G10","Site Preparation",{"$f":"SUM(E118:E121)","v":0}]
[null,null,"G20","Site Improvements",{"$f":"SUM(E122:E126)","v":0}]
[null,null,"G30","Site Mechanical Utilities",{"$f":"SUM(E127:E133)","v":0}]
[null,null,"G40","Site Electrical Utilities",{"$f":"SUM(E134:E137)","v":0}]
[null,null,"G90","Other Site Construction",{"$f":"SUM(E138:E139)","v":0}]
[null,null,"Z00","Gen'l. Cond. / Gen'l. Reqmnts / OH&P",{"$f":"E140","v":0}]
[null,null,null,"TOTAL",{"$f":"SUM(E30:E52)","v":0}]
[]
[]
[]
[]
[null,null,null,"LEVEL III SUMMARY "]
[]
[null,null,"CODE","DESCRIPTION","AMOUNT"]
[null,null,"A1010","Standard Foundations",{"$f":"I4","v":0}]
[null,null,"A1020","Special Foundations",{"$f":"J4","v":0}]
[null,null,"A1030","Slab on Grade",{"$f":"K4","v":0}]
[null,null,"A2010","Basement Excavation",{"$f":"L4","v":0}]
[null,null,"A2020","Basement Walls",{"$f":"M4","v":0}]
[null,null,"B1010","Floor Construction",{"$f":"N4","v":0}]
[null,null,"B1020","Roof Construction",{"$f":"O4","v":0}]
[null,null,"B2010","Exterior Walls",{"$f":"P4","v":0}]
[null,null,"B2020","Exterior Windows",{"$f":"Q4","v":0}]
[null,null,"B2030","Exterior Doors",{"$f":"R4","v":0}]
[null,null,"B3010","Roof Coverings",{"$f":"S4","v":0}]
[null,null,"B3020","Roof Openings",{"$f":"T4","v":0}]
[null,null,"C1010","Partitions",{"$f":"U4","v":0}]
[null,null,"C1020","Interior Doors",{"$f":"V4","v":0}]
[null,null,"C1030","Fittings",{"$f":"W4","v":0}]
[null,null,"C2010","Stair Construction",{"$f":"X4","v":0}]
[null,null,"C2020","Stair Finishes",{"$f":"Y4","v":0}]
[null,null,"C3010","Wall Finishes",{"$f":"Z4","v":0}]
[null,null,"C3020","Floor Finishes",{"$f":"AA4","v":0}]
[null,null,"C3030","Ceiling Finishes",{"$f":"AB4","v":0}]
[null,null,"D1010","Elevators & Lifts",{"$f":"AC4","v":0}]
[null,null,"D1020","Escalators & Moving Walks",{"$f":"AD4","v":0}]
[null,null,"D1090","Other Conveying Systems",{"$f":"AE4","v":0}]
[null,null,"D2010","Plumbing Fixtures",{"$f":"AF4","v":0}]
[null,null,"D2020","Domestic Water Distribution",{"$f":"AG4","v":0}]
[null,null,"D2030","Sanitary Waste",{"$f":"AH4","v":0}]
[null,null,"D2040","Rain Water Drainage",{"$f":"AI4","v":0}]
[null,null,"D2090","Other Plumbing Systems",{"$f":"AJ4","v":0}]
[null,null,"D3010","Energy Supply",{"$f":"AK4","v":0}]
[null,null,"D3020","Heat Generating Systems",{"$f":"AL4","v":0}]
[null,null,"D3030","Cooling Generating Systems",{"$f":"AM4","v":0}]
[null,null,"D3040","Distribution Systems",{"$f":"AN4","v":0}]
[null,null,"D3050","Terminal & Package Units",{"$f":"AO4","v":0}]
[null,null,"D3060","Controls & Instrumentation",{"$f":"AP4","v":0}]
[null,null,"D3070","System Testing & Balancing",{"$f":"AQ4","v":0}]
[null,null,"D3090","Other HVAC Systems & Equipment",{"$f":"AR4","v":0}]
[null,null,"D4010","Sprinklers",{"$f":"AS4","v":0}]
[null,null,"D4020","Standpipes",{"$f":"AT4","v":0}]
[null,null,"D4030","Fire Protection Specialties",{"$f":"AU4","v":0}]
[null,null,"D4090","Other Fire Protection Systems",{"$f":"AV4","v":0}]
[null,null,"D5010","Electrical Service & Distribution",{"$f":"AW4","v":0}]
[null,null,"D5020","Lighting and Branch Wiring",{"$f":"AX4","v":0}]
[null,null,"D5030","Communications & Security",{"$f":"AY4","v":0}]
[null,null,"D5090","Other Electrical Systems",{"$f":"AZ4","v":0}]
[null,null,"E1010","Commercial Equipment",{"$f":"BA4","v":0}]
[null,null,"E1020","Institutional Equipment",{"$f":"BB4","v":0}]
[null,null,"E1030","Vehicular Equipment",{"$f":"BC4","v":0}]
[null,null,"E1090","Other Equipment",{"$f":"BD4","v":0}]
[null,null,"E2010","Fixed Furnishings",{"$f":"BE4","v":0}]
[null,null,"E2020","Movable Furnishings",{"$f":"BF4","v":0}]
[null,null,"F1010","Special Structures",{"$f":"BG4","v":0}]
[null,null,"F1020","Integrated Construction",{"$f":"BH4","v":0}]
[null,null,"F1030","Special Construction Systems",{"$f":"BI4","v":0}]
[null,null,"F1040","Special Facilities",{"$f":"BJ4","v":0}]
[null,null,"F1050","Special Controls and Instrumentation",{"$f":"BK4","v":0}]
[null,null,"F2010","Building Elements Demolition",{"$f":"BL4","v":0}]
[null,null,"F2020","Hazardous Components Abatement",{"$f":"BM4","v":0}]
[null,null,"G1010","Site Clearing",{"$f":"BN4","v":0}]
[null,null,"G1020","Site Demolition and Relocations",{"$f":"BO4","v":0}]
[null,null,"G1030","Site Earthwork",{"$f":"BP4","v":0}]
[null,null,"G1040","Hazardous Waste Removal",{"$f":"BQ4","v":0}]
[null,null,"G2010","Roadways",{"$f":"BR4","v":0}]
[null,null,"G2020","Parking Lots",{"$f":"BS4","v":0}]
[null,null,"G2030","Pedestrian Paving",{"$f":"BT4","v":0}]
[null,null,"G2040","Site Development",{"$f":"BU4","v":0}]
[null,null,"G2050","Landscaping",{"$f":"BV4","v":0}]
[null,null,"G3010","Water Supply",{"$f":"BW4","v":0}]
[null,null,"G3020","Sanitary Sewer",{"$f":"BX4","v":0}]
[null,null,"G3030","Storm Sewer",{"$f":"BY4","v":0}]
[null,null,"G3040","Heating Distribution",{"$f":"BZ4","v":0}]
[null,null,"G3050","Cooling Distribution",{"$f":"CA4","v":0}]
[null,null,"G3060","Fuel Distribution",{"$f":"CB4","v":0}]
[null,null,"G3090","Other Site Mechanical Utilities",{"$f":"CC4","v":0}]
[null,null,"G4010","Electrical Distribution",{"$f":"CD4","v":0}]
[null,null,"G4020","Site Lighting",{"$f":"CE4","v":0}]
[null,null,"G4030","Site Communications & Security",{"$f":"CF4","v":0}]
[null,null,"G4090","Other Site Electrical Utilities",{"$f":"CG4","v":0}]
[null,null,"G9010","Services and Pedestrian Tunnels",{"$f":"CH4","v":0}]
[null,null,"G9090","Other Site Systems & Equipment",{"$f":"CI4","v":0}]
[null,null,"H0000","Gen'l. Cond. / Gen'l. Reqmnts / OH&P",{"$f":"CJ4","v":0}]
[null,null,null,"TOTAL",{"$f":"SUM(E61:E140)","v":0}]