{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Navigation","Instructions","CO Log","CO11_Part 1","CO11_Part 2","Reason Codes","CO11a_Part 1","CO11a_Part 2","CO11a_Part 3","Transmittal"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":17,"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":"Navigation","index":0,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Construction Contract Change Order"]
[null,"Navigation Pane"]
[]
[null,"Read instructions for completing each part of the change order.",null,null,"Instructions"]
[]
[null,"Start with this tab and enter project information and change order log info.",null,null,"CO Log"]
[]
[null,"List Construction Change Orders (Summary of Work)",null,null,"CO-11 Part 1"]
[]
[null,"List Construction Change Orders (Itemization of Work)",null,null,"CO-11 Part 2"]
[]
[null,"Enter Change Order Justification ( A/E's Justification )",null,null,"CO-11a Part 1"]
[]
[null,"Enter Change Order Justification ( Agency's Justification )",null,null,"CO-11a Part 2"]
[]
[null,"Refer to this tab for Change Order Justification Reason Codes.",null,null,"CO-11a Part 3"]
[]
[null,"Complete all sections including submittal requirements and description.",null,null,"Transmittal"]

{"sheet":"Instructions","index":1,"n_rows":215,"n_cols":11,"rows_kept":215,"cut":false,"hidden":false,"merged":[[2,2,2,11],[1,2,1,11],[0,0,0,3],[208,10,208,12]]}
["Go to Navigation Sheet"]
[null,null,"INSTRUCTIONS FOR COMPLETING"]
[null,null,"THE CO-11 and CO-11a FORMS"]
[]
["I.  GENERAL INSTRUCTIONS"]
[]
[null,null,"Please read all instructions carefully before using this spreadsheet to create the CO-11 and CO-11a forms."]
[]
[null,null,"Macros must be \"enabled\" to use this template."]
[null,null,"In order for macros to run in Excel, the Excel macro security setting must be set to \"Medium\".  To adjust this"]
[null,null,"setting, go to Tools / Macro / Security on the Excel menubar and adjust security setting to \"Medium\".  You may "]
[null,null,"need to exit Excel once and then re-open Excel for the new security setting to take effect."]
[]
[null,null,"Excel/Office 2007 users may need to save this as a \"Macro-Enabled Worksheet\"."]
[]
[null,null,"This spreadsheet contains a number of built-in calculations to simplify the creation of CO-11 and CO-11a forms."]
[null,null,"To ensure the integrity of the data, please do not attempt to modify the spreadsheet.  Areas where data"]
[null,null,"can be entered are highlighted in yellow."]
[]
[null,null,"It is recommended that the user print a copy of this instruction sheet to use as a reference when completing"]
[null,null,"these forms."]
[]
[null,null,"The various Parts of the CO-11 and CO-11a are accessed by clicking on the blue tabs at the bottom of the screen."]
[]
[null,null,"Use the tab key to move forward to the next fillable field.",null,null,null,null,null,"|----->"]
[]
[null,null,"Use the shift-tab to move backwards to the previous fillable field.",null,null,null,null,null,"<-----|"]
[]
[null,null,"(You can also use the mouse and cursor keys to navigate, but the tab key is generally the most efficient means.)"]
[]
[null,null,"Some fields have \"drop-down\" selection arrows on the right side of the field.  For these"]
[null,null,"types of fields, click on the arrow, then select an appropriate choice from the list."]
[]
[null,null,"Click on the tabs at the bottom of this file to go to the appropriate page."]
[]
[null,"THE TRANSMITTAL"]
[]
[null,null,"The Change Order Transmittal for DEB Review Services is a required part of the submittal for review of a change order."]
[null,null,"See other submittal requirements on the Change Order Transmittal for change order review."]
[]
[null,"THE CHANGE ORDER LOG  ( \"CO Log\" tab )"]
[]
[null,null,"The most important part of this spreadsheet is the \"Contract Summary and Change Order Log\"."]
[]
[null,null,"The \"Contract Summary\" contains general project information, a running tally of all approved change orders, and the"]
[null,null,"original and current contract costs and completion dates."]
[]
[null,null,"The \"Change Order Log\" lists the key cost and schedule data for each change order and also identifies"]
[null,null,"if approval by the Governor's Designee is required."]
[]
[null,null,"The information entered in the Contract Summary and Change Order Log is used to automatically complete portions of"]
[null,null,"the CO-11 and CO-11a forms for the Change Order number entered on the \"CO-11 Part 1\" sheet."]
[null,null,"Specifically, the general information from the Contract Summary and Change Order Log is used to automatically complete:"]
[null,null,null,"- CO-11, Part 1 (Fully completes Part 1.)"]
[null,null,null,"- CO-11, Part 2 (Completes the header information.  Remaining portions must be completed by user.)"]
[null,null,null,"- CO-11a, All Parts (Completes the header information.  Remaining portions must be completed by user.)"]
[]
[null,null,"This built-in automation was designed to save users from redundant keying of data and to eliminate math and transposition errors."]
[]
[null,null,"When entering data in the Change Order Log, always enter the change orders sequentially, starting with the lowest number change order."]
[null,null,"( Do not leave a blank line between change orders or erroneous totals may result ! )"]
[]
[null,null,"Always update the Contract Summary and Change Order Log first, before completing and generating the CO-11 and CO-11a."]
[]
[null,"IF YOU WISH TO RETAIN DETAILED INFORMATION FOR EACH CHANGE ORDER, DO THE FOLLOWING:"]
[]
[null,null,"Before beginning each new CO-11, make a copy of the spreadsheet.  (Do a \"Save as\" and name the new version"]
[null,null,"of the spreadsheet: \"Change Order Number XX\", substituting for \"XX\" the number of the next Change Order to be created.)"]
[null,null,"While the Change Order Log will list summary information for all Change Orders to date, only the detailed information (i.e., the CO-11"]
[null,null,"and CO-11a) for one change order number is saved in the spreadsheet.  ( The spreadsheet is not meant to be a repository"]
[null,null,"of all CO-11 and CO-11a forms. It is intended to be used to create, save, and print information for the latest CO-11 and CO-11a.)"]
[]
["II.  STEP-BY-STEP INSTRUCTIONS"]
[]
[null,"  Change Order Log"]
[]
[1,null,"Save a copy of the previous Change Order spreadsheet file and name it as noted in the preceding paragraph."]
[]
[2,null,"Click on the \"Contract Summary and Change Order Log\" tab."]
[]
[3,null,"In the \"Contract Summary\" section, enter new (or verify existing) data for the cells hignlighted in yellow."]
[]
[4,null,"In the \"Change Order Log\" section, enter the following information:"]
[]
[null,"-","Change Order Number"]
[null,null,null,"- Change Order Numbers are sequential integer numbers.  Start with \"1\".  "]
[null,null,null,"- Enter change orders sequentially in the log - starting with the lowest number change order."]
[null,null,null,"      (See the note below for projects aready in progess.)"]
[null,null,null,"- Don't skip rows between change orders (i.e., don't leave any blank rows between"]
[null,null,null,"       change order entries) or else erroneous results will occur. "]
[]
[null,"-","Change Order Date   (enter in mm/dd/yy format)"]
[]
[null,"-","Change Order Amount (enter the total value of latest Change Order)"]
[]
[null,"-","Schedule Extension (enter the additional number of days the contract will be extended due to latest Change Order)"]
[]
[null,"( All other information shown on the log is computed automatically and is used elsewhere in the spreadsheet. )"]
[]
[null,null,"NOTE:   If this spreadsheet is being implemented for a project already in progress, there are two options for"]
[null,null,null,"entering Change Orders which were issued prior to this new spreadsheet becoming available:"]
[]
[null,null,null,"a) Enter all Change Orders as individual line items in the Log (recommended method), or"]
[]
[null,null,null,"b) Group all Change Orders already executed under one line entry. After this"]
[null,null,null,"    one \"catch up entry\", enter all subsequent Change Orders as individual line items."]
[]
[5,null,"Print a copy of the Log, if desired, using the File/Print menu command.  ( To limit the number of pages printed,"]
[null,null,"enter the appropriate page numbers in the \"Pages\" section of the \"Print Range\" dialog box. )"]
[]
["  CO-11 Part 1,  Construction Change Order (Summary of Work)"]
[]
[null,null,"Part 1 of the CO-11 lists the summary cost and contract completion information related to the current change,"]
[null,null,"the cumulative cost and completion data, and provides signature lines for all affected parties."]
[]
[1,null,"Enter the specific Change Order Number for which you wish to create a CO-11 and CO-11a."]
[null,null,"(NOTE:  The Contract Summary and Change Order Log must be complete for all Change Orders up to and including"]
[null,null,"this Change Order.)"]
[2,null,"Type in the name and title of the various signatories to this Change Order."]
[]
[3,null,"Print a copy of the CO-11 Part 1 using the File/Print menu command or the printer icon. (You can also use the Print"]
[null,null,"or Print Preview buttons on the toolbar below.)"]
[]
["  CO-11 Part 2,  Construction Change Order (Itemization of Work)"]
[]
[null,null,"Part 2 of the CO-11 provides an itemized breakdown of the scope of work to be performed."]
[]
[1,null,"Enter the required data for the each of the five columns highlighted in yellow.  Additional data entry instructions"]
[null,null,"are provided as each cell is selected."]
[]
[2,null,"Once all detail line items have been entered, verify that the sum of all detail line items match the total amount"]
[null,null,"entered earlier in the Change Order Log for this Change Order.  If the amount in the Change Order Log and the sum of the Part 2 detail"]
[null,null,"entries do not match, an error message will appear in red at the top of the Part 2 sheet.  Correct either the detail amounts in Part 2"]
[null,null,"or the total amount entered in the Change Order Log, as needed.  Once the amounts match, the error message will clear."]
[]
[3," ","An asterisk ( * ) appearing adjacent to the amount field on Part 2, denotes that either the \"Initiated By\" or"]
[null,null,"the \"Reason for Change\" fields, or both, were not completed properly.  ( An entry must appear in both of these"]
[null,null,"fields, if an associated dollar amount was entered.)   Fill in these fields with the appropriate entries to clear these"]
[null,null,"error flags."]
[]
[4,null,"Once the errors described in 2 and 3 above have been corrected, print a copy of this sheet using the File/Print "]
[null,null,"menu command.  To limit the number of pages printed, enter the appropriate page numbers in the \"Pages\" "]
[null,null,"section of the \"Print Range\" dialog box."]
[]
["  CO-11a Part 1,  Change Order Justification ( A/E's Justification )"]
[]
[null,null,"Part 1 of the CO-11a is completed by the A/E to:"]
[null,null,null,"- provide a brief narrative summary of work to be performed"]
[null,null,null,"- explain why the change is required"]
[null,null,null,"- identify the A/E's recommendation to the Agency"]
[]
[1,null,"Describe the work."]
[]
[2,null,"Describe why change is required."]
[]
[3,null,"Use the drop-down arrow to select either \"Recommend Approval\" or \"Recommend Disapproval\"."]
[]
[4,null,"Print out the CO-11a Part 1 and obtain signature of the authorized A/E representative."]
[]
["  CO-11a Part 2,  Change Order Justification ( Agency's Justification )"]
[]
[null,null,"Part 2 of the CO-11a is completed by the Agency to:"]
[null,null,null,"- verify that adequate contingency is available"]
[null,null,null,"- identify cost sharing arrangements for design errors or omissions"]
[null,null,null,"- justify Change Orders which are a result of a change in agency requirements"]
[]
[1,null,"Enter the latest APPROVED CO-8 Contingency amount."]
[]
[null,null,"If sufficient contingency is available to accommodate this Change Order, the balance remaining"]
[null,null,"after approval of this Change Order will be displayed."]
[]
[null,null,"If the contingency balance is insufficient, the minimum amount of additional contingency required to "]
[null,null,"accommodate this Change Order will be displayed.  Submit a revised CO-8 concurrent with the Change"]
[null,null,"Order to increase the construction change order contingency amount."]
[]
[2,null,"Complete the two items of information needed for Change Orders which involve \"design errors and omissions\"."]
[]
[3,null,"Complete the four items of information needed for Change Orders which involve \"changes in agency requirements\"."]
[]
[4,null,"Print out the CO-11a Part 1 and obtain signature of the authorized Agency representative."]
[]
["  CO-11a Part 3,  Change Order Justification ( Agency's Justification )"]
[]
[null,null,"Part 3 of the CO-11a is a statistical summary compiled automatically from the entries on Part 2 of the CO-11."]
[]
[1,null,"Verify that the total on this sheet matches the total Change Order amount.  If the total on this sheet is"]
[null,null,"incorrect, return to Part 2 of the CO-11 sheet and ensure that all lines with an \"Amount\" have a corresponding"]
[null,null,"\"Reason Code\"."]
[]
[2,null,"Once correct, print out a copy of this sheet."]
[]
[]
["III.  SUBMITTAL REQUIREMENTS"]
[]
[null,"If approval by DGS is required:"]
[]
[null,null,"Submit a \"hard copy\" of all items identified on the Submittal Requirements section of the Transmittal to DEB"]
[null,null,"immediately after all other applicable signatures have been obtained."]
[]
[null,null,"Include copies of additional supporting backup (e.g., GC-1, SC-1, and SS-1 forms, if used, drawings/sketches,"]
[null,null,"and other additional backup).  This is necessary to provide the Director of the Department of General Services, "]
[null,null,"functioning as the Governor's Designee, sufficient data to understand, evaluate, and approve the proposed"]
[null,null,"Change Order."]
[]
[null,"If approval by DGS is not required:"]
[]
[null,null,"Submit a \"hard copy\", or image file (preferably in pdf format), of the Log, the CO-11 (Parts 1 and 2) and the CO-11a "]
[null,null,"(Parts 1, 2, and 3) to DEB immediately after the authorized agency representative approves the Change Order."]
[null,null,"If forms are in \"pdf\" or other acceptable image format, they may be e-mailed to >>>>>",null,null,null,null,null,null,null,"coforms@dgs.virginia.gov"]
[]
[]
["FINAL NOTES:"]
[]
[null,null,"The Log and Contract Summary were added to assist agencies in preventing math errors, eliminating redundant data entry,"]
[null,null,"and in automatically flagging when approval by the Governor's Designee is required."]

{"sheet":"CO Log","index":2,"n_rows":117,"n_cols":11,"rows_kept":117,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,6,1,8],[18,6,18,8],[4,3,4,8],[5,3,5,8],[6,3,6,8],[7,3,7,8],[8,3,8,8],[9,3,9,8]]}
["Go to Navigation Sheet"]
["CONTRACT SUMMARY:",null,null,null,null,null,{"$f":"IF(C6>0,(\"Project:  \" & C5 & \" - \" & C6 & \" - \" & C7),\"\")","v":""},null,null,null,"Enter applicable data in the"]
[null,null,null,null,null,null,null,null,null,null,"cells highlighted in yellow."]
[null,null,"Code Number","Description"]
["Agency:",null,null,null,null,null,null,null,null,null,"Please be certain to"]
["Project:",null,null,null,null,null,null,null,null,null,"fill out both the adjacent"]
["Sub-Project:",null,null,null,null,null,null,null,null,null,"\"Contract Summary\" and"]
["Location of the Work:",null,null,null,null,null,null,null,null,null,"the \"Change Order Log\""]
["Contractor Name:",null,null,null,null,null,null,null,null,null,"before proceeding to the"]
["Architect/Engineer:",null,null,null,null,null,null,null,null,null,"CO-11 and the CO-11a"]
["Agency has delegated authority ?",null,null,"NO",null,null,null,null,null,null,"forms, proper."]
["Date Contract Ratified:",null,null,null,null,"Original Contract"]
[null,null,null,null,null,"Additive Changes",{"$f":"SUMIF(C25:C117,\">=0\",C25:C117)","v":0},null,null,null,"The data from the"]
["Original Contract Completion Date:",null,null,null,null,"Deductive Changes",{"$f":"SUMIF(C25:C117,\"<0\",C25:C117)","v":0},null,null,null,"\"Change Order Log\""]
["Cumulative Schedule Extensions:",null,null,{"$f":"SUM(D25:D117)","v":0}," days","Total Changes",{"$f":"SUM(C25:C117)","v":0},{"$f":"IF(G12=0,0,+G15/G12)","v":0},null,null,"is used to generate"]
["Revised Contract Completion Date:",null,null,{"$f":"+D14+D15","v":"00:00:00"},null,"Revised Contract",{"$f":"+G12+G15","v":0},null,null,null,"much of the data on"]
[null,null,null,null,null,null,null,null,null,null,"the CO-11 form."]
[]
["CHANGE ORDER LOG:",null,null,null,null,null,{"$f":"IF(C6>0,(\"Project:  \" & C5 & \" - \" & C6 & \" - \" & C7),\"\")","v":""},null,null,null,"Scroll down to view / edit"]
[null,null,"Updated thru Change Order Number:",{"$f":"MAX(A25:A117)","v":0},null,null,null,null,null,null,"the \"Change Order Log\"."]
[null,null,null,null,"Governor's",null,null,"Cumul.","Revised"]
["Change","Change","Change","Schedule","Designee's","Cumulative","Revised","Schedule","Contract"]
["Order","Order","Order","Extension","Approval","Change","Contract","Extension","Completion"]
["Number","Date","Amount","(days)","Required?","Orders","Value","(days)","Date"]
[null,null,null,null,{"$f":"IF(A25=\"\",\"\",IF(AND(C25>0,F25>(0.25*$G$12),F25>50000),\"YES\",\"NO\"))","v":""},{"$f":"C25","v":0},{"$f":"IF(A25=\"\",\"\",+$G$12+F25)","v":""},{"$f":"D25","v":0},{"$f":"IF(A25=\"\",\"\",$D$14+H25)","v":""}]
[null,null,null,null,{"$f":"IF(A26=\"\",\"\",IF(AND(C26>0,F26>(0.25*$G$12),F26>50000),\"YES\",\"NO\"))","v":""},{"$f":"IF(A26=\"\",\"\",F25+C26)","v":""},"",{"$f":"IF(A26=\"\",\"\",H25+D26)","v":""},""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"",{"$f":"IF(A28=\"\",\"\",F27+C28)","v":""},"","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","",{"$f":"IF(A57=\"\",\"\",+$G$12+F57)","v":""},"",{"$f":"IF(A57=\"\",\"\",$D$14+H57)","v":""}]
[null,null,null,null,"",{"$f":"IF(A58=\"\",\"\",F57+C58)","v":""},"",{"$f":"IF(A58=\"\",\"\",H57+D58)","v":""},""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","",{"$f":"IF(A89=\"\",\"\",+$G$12+F89)","v":""},"",{"$f":"IF(A89=\"\",\"\",$D$14+H89)","v":""}]
[null,null,null,null,{"$f":"IF(A90=\"\",\"\",IF(AND(C90>0,F90>(0.25*$G$12),F90>50000),\"YES\",\"NO\"))","v":""},{"$f":"IF(A90=\"\",\"\",F89+C90)","v":""},"",{"$f":"IF(A90=\"\",\"\",H89+D90)","v":""},""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]

{"sheet":"CO11_Part 1","index":3,"n_rows":75,"n_cols":41,"rows_kept":75,"cut":false,"hidden":false,"merged":[[32,2,32,47],[12,6,12,8],[13,0,13,5],[12,10,12,42],[12,43,12,47],[14,10,14,42],[17,2,17,47],[24,38,24,46],[21,2,21,47],[22,2,22,47],[26,2,26,46],[15,0,15,5],[15,6,15,8],[15,10,15,42],[16,0,16,47],[8,0,8,15],[8,32,8,47],[8,16,8,31],[7,16,7,31],[5,40,5,47],[6,40,6,47],[6,8,6,39],[7,32,7,47],[75,16,75,46],[55,16,55,46],[67,1,67,46],[62,1,65,46],[36,1,36,20],[40,13,40,20],[41,13,41,20],[39,39,39,47],[41,39,41,47],[40,39,40,47],[36,24,36,46],[37,24,37,46],[43,1,43,47],[39,13,39,20],[71,16,71,46],[37,1,37,20],[0,0,0,12],[47,16,47,46],[51,16,51,46],[59,16,59,46],[12,0,12,5],[13,6,13,8],[13,10,13,42],[14,0,14,5],[14,6,14,8],[33,2,35,46],[5,0,5,7],[5,8,5,39],[9,0,9,47],[7,0,7,15],[6,0,6,7],[11,0,11,47]]}
["Go to Navigation Sheet"]
[null," Enter the number of this specific Change Order in the first yellow cell below.   Be sure to first enter"]
[null," all data on the \"Contract Summary AND Change Order Log\".   ( This is necessary as the data from"]
[null," the \"Contact Summary and Change Order Log\" is used to generate this Change Order sheet. )"]
[]
["DGS-30-092",null,null,null,null,null,null,null,"CONTRACT CHANGE ORDER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('CO Log'!D11=\"NO\",\"CO-11\",\"HECO-11\")","v":"CO-11"}]
["(Rev. 07/20)",null,null,null,null,null,null,null,"( Summary of Work )",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Part 1"]
["Project Code",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Change Order Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Change Order Date"]
[{"$f":"IF(G15>0,(G14 & \" - \" & G15 & \" - \" & G16),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Q9,[0]!LOG_RANGE,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,null,null,null,null,null,"Code",null,null,null,"Description"]
["Agency:",null,null,null,null,null,{"$f":"'CO Log'!C5","v":0},null,null,null,{"$f":"'CO Log'!D5","v":0}]
["Project:",null,null,null,null,null,{"$f":"'CO Log'!C6","v":0},null,null,null,{"$f":"'CO Log'!D6","v":0}]
["Sub-Project:",null,null,null,null,null,{"$f":"'CO Log'!C7","v":0},null,null,null,{"$f":"IF('CO Log'!D7=\"\",\"\",'CO Log'!D7)","v":""}]
[]
["To:",null,{"$f":"'CO Log'!D9","v":0}]
[]
[]
[]
[null,null,{"$f":"\"Under your contract dated \"&TEXT('CO Log'!D12, \"mmmm d, yyyy\")&\" for work at\"","v":"Under your contract dated January 0, 1900 for work at"}]
[null,null,{"$f":"'CO Log'!D8","v":0}]
[null,null,{"$f":"\"you are hereby authorized to make the specific changes identified on Part 2 of this form and to \"&IF(VLOOKUP(Q9,[0]!LOG_RANGE,3,FALSE)>0,\"ADD TO\",\"DEDUCT FROM\")","v":{"$error":"#N/A"}}]
[null,null,{"$f":"\"the Contract Price, in accordance with the Contract Documents, the sum of \"","v":"the Contract Price, in accordance with the Contract Documents, the sum of "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ABS(VLOOKUP(Q9,[0]!LOG_RANGE,3,FALSE))","v":{"$error":"#N/A"}}]
[]
[null,null,{"$f":"spellnumber(AM25)","v":{"$error":"#VALUE!"}}]
[]
[null,null,{"$f":"\"There will be an extension of \"&VLOOKUP(Q9,[0]!LOG_RANGE,4,FALSE)&\" days for Contract completion.\"","v":{"$error":"#N/A"}}]
[]
[null,null,{"$f":"\"The contract completion date will now be \"&TEXT(VLOOKUP(Q9,[0]!LOG_RANGE,9,FALSE), \"mmmm d, yyyy\")&\".\"","v":{"$error":"#N/A"}}]
[]
[null,null,"Failure to include a specific change in the Contract Completion Date in this Change Order is a waiver to any future adjustment to the Contract Completion Date for the Work and impact of this Change Order unless the parties mutually agree in writing to postpone a determination on any change to the Contract Completion Date, which determination may not be postponed for more than 45 days from the Agency’s approval of this Change Order.  If no determination is reached within the 45-day period, the extension to the Contract Completion Date shall be 0 Days."]
[]
[]
[]
[null,"CONTRACT COST SUMMARY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CONTRACT SCHEDULE SUMMARY"]
[null,"(inclusive of this Change Order)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(inclusive of this Change Order)"]
[]
[null,"Original Contract Amount",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'CO Log'!G12","v":0},null,null,null,null,null,null,null,null,null,null,"Original Contract Completion Date:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'CO Log'!D14","v":"00:00:00"}]
[null,"Cumulative Change Orders",null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Q9,[0]!LOG_RANGE,6,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,"Cumulative Schedule Extension:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Q9,[0]!LOG_RANGE,8,FALSE)&\" days\"","v":{"$error":"#N/A"}}]
[null,"Revised Contract Amount",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N40+N41","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,"Revised Contract Completion Date:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Q9,[0]!LOG_RANGE,9,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,"CHANGE AUTHORIZATION"]
[]
[null,"Issued By:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Authorized A/E Representative",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[]
[null,"Accepted By:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Authorized Contractor Representative",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[]
[null,"Recommended By:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Authorized Agency Representative",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[]
[null,"Approved By:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Authorized Agency Representative",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[]
[]
[null,"Prior approval by the Governor or his designee is required for each Change Order which causes an increase in the Contract Price if the resulting cumulative sum of all Change Orders exceeds 25% of the original Contract Amount or $50,000, whichever is greater."]
[]
[]
[]
[]
[null,{"$f":"IF(VLOOKUP(Q9,[0]!LOG_RANGE,5,FALSE) = \"YES\",\"*** This Change Order REQUIRES the approval of the Governor's designee ***\",\"*** This Change Order does NOT require the approval of the Governor's designee ***\")","v":{"$error":"#N/A"}}]
[]
[null,"Recommended By:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('CO Log'!D11=\"NO\",\"Director, Division of Engineering and Buildings\",\"Authorized Agency Representative\")","v":"Director, Division of Engineering and Buildings"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[]
[null,"Approved By:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('CO Log'!D11=\"NO\",\"Director, Department of General Services\",\"Authorized Agency Representative\")","v":"Director, Department of General Services"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]

{"sheet":"CO11_Part 2","index":4,"n_rows":113,"n_cols":13,"rows_kept":113,"cut":false,"hidden":false,"merged":[[108,0,108,1],[108,2,108,6],[108,9,108,10],[109,0,109,1],[109,2,109,6],[109,9,109,10],[104,9,104,10],[105,0,105,1],[106,0,106,1],[106,2,106,6],[106,9,106,10],[107,0,107,1],[107,2,107,6],[107,9,107,10],[105,2,105,6],[105,9,105,10],[104,0,104,1],[104,2,104,6],[112,0,112,1],[112,2,112,6],[112,9,112,10],[110,0,110,1],[110,2,110,6],[110,9,110,10],[111,0,111,1],[111,2,111,6],[111,9,111,10],[103,0,103,1],[103,2,103,6],[103,9,103,10],[96,9,96,10],[97,0,97,1],[97,2,97,6],[97,9,97,10],[100,9,100,10],[101,0,101,1],[101,2,101,6],[101,9,101,10],[98,0,98,1],[98,2,98,6],[98,9,98,10],[99,0,99,1],[99,2,99,6],[99,9,99,10],[100,0,100,1],[100,2,100,6],[102,0,102,1],[102,2,102,6],[102,9,102,10],[95,0,95,1],[95,2,95,6],[95,9,95,10],[96,0,96,1],[96,2,96,6],[90,0,90,1],[90,2,90,6],[90,9,90,10],[91,0,91,1],[91,2,91,6],[91,9,91,10],[92,0,92,1],[92,2,92,6],[92,9,92,10],[93,0,93,1],[93,2,93,6],[93,9,93,10],[94,0,94,1],[94,2,94,6],[94,9,94,10],[88,0,88,1],[88,2,88,6],[88,9,88,10],[89,0,89,1],[89,2,89,6],[89,9,89,10],[86,0,86,1],[86,2,86,6],[86,9,86,10],[87,0,87,1],[87,2,87,6],[87,9,87,10],[84,0,84,1],[84,2,84,6],[84,9,84,10],[85,0,85,1],[85,2,85,6],[85,9,85,10],[82,0,82,1],[82,2,82,6],[82,9,82,10],[83,0,83,1],[83,2,83,6],[83,9,83,10],[80,0,80,1],[80,2,80,6],[80,9,80,10],[81,0,81,1],[81,2,81,6],[81,9,81,10],[78,0,78,1],[78,2,78,6],[78,9,78,10],[79,0,79,1],[79,2,79,6],[79,9,79,10],[76,0,76,1],[76,2,76,6],[76,9,76,10],[77,0,77,1],[77,2,77,6],[77,9,77,10],[74,0,74,1],[74,2,74,6],[74,9,74,10],[75,0,75,1],[75,2,75,6],[75,9,75,10],[72,0,72,1],[72,2,72,6],[72,9,72,10],[73,0,73,1],[73,2,73,6],[73,9,73,10],[70,0,70,1],[70,2,70,6],[70,9,70,10],[71,0,71,1],[71,2,71,6],[71,9,71,10],[68,0,68,1],[68,2,68,6],[68,9,68,10],[69,0,69,1],[69,2,69,6],[69,9,69,10],[66,0,66,1],[66,2,66,6],[66,9,66,10],[67,0,67,1],[67,2,67,6],[67,9,67,10],[64,0,64,1],[64,2,64,6],[64,9,64,10],[65,0,65,1],[65,2,65,6],[65,9,65,10],[62,0,62,1],[62,2,62,6],[62,9,62,10],[63,0,63,1],[63,2,63,6],[63,9,63,10],[60,0,60,1],[60,2,60,6],[60,9,60,10],[61,0,61,1],[61,2,61,6],[61,9,61,10],[58,0,58,1],[58,2,58,6],[58,9,58,10],[59,0,59,1],[59,2,59,6],[59,9,59,10],[56,0,56,1],[56,2,56,6],[56,9,56,10],[57,0,57,1],[57,2,57,6],[57,9,57,10],[54,0,54,1],[54,2,54,6],[54,9,54,10],[55,0,55,1],[55,2,55,6],[55,9,55,10],[52,0,52,1],[52,2,52,6],[52,9,52,10],[53,0,53,1],[53,2,53,6],[53,9,53,10],[50,0,50,1],[50,2,50,6],[50,9,50,10],[51,0,51,1],[51,2,51,6],[51,9,51,10],[48,0,48,1],[48,2,48,6],[48,9,48,10],[49,0,49,1],[49,2,49,6],[49,9,49,10],[46,0,46,1],[46,2,46,6],[46,9,46,10],[47,0,47,1],[47,2,47,6],[47,9,47,10],[44,0,44,1],[44,2,44,6],[44,9,44,10],[45,0,45,1],[45,2,45,6],[45,9,45,10],[42,0,42,1],[42,2,42,6],[42,9,42,10],[43,0,43,1],[43,2,43,6],[43,9,43,10],[40,0,40,1],[40,2,40,6],[40,9,40,10],[41,0,41,1],[41,2,41,6],[41,9,41,10],[38,0,38,1],[38,2,38,6],[38,9,38,10],[39,0,39,1],[39,2,39,6],[39,9,39,10],[37,0,37,1],[37,2,37,6],[37,9,37,10],[36,0,36,1],[36,2,36,6],[36,9,36,10],[34,0,34,1],[34,2,34,6],[34,9,34,10],[35,0,35,1],[35,2,35,6],[35,9,35,10],[32,0,32,1],[32,2,32,6],[32,9,32,10],[33,0,33,1],[33,2,33,6],[33,9,33,10],[28,2,28,6],[28,9,28,10],[30,0,30,1],[30,2,30,6],[30,9,30,10],[31,0,31,1],[31,2,31,6],[31,9,31,10],[26,0,26,1],[26,2,26,6],[26,9,26,10],[29,0,29,1],[29,2,29,6],[29,9,29,10],[27,0,27,1],[27,2,27,6],[27,9,27,10],[28,0,28,1],[24,0,24,1],[24,2,24,6],[24,9,24,10],[25,0,25,1],[25,2,25,6],[25,9,25,10],[22,0,22,1],[22,2,22,6],[22,9,22,10],[23,0,23,1],[23,2,23,6],[23,9,23,10],[20,0,20,1],[20,2,20,6],[20,9,20,10],[21,0,21,1],[21,2,21,6],[21,9,21,10],[18,0,18,1],[18,2,18,6],[18,9,18,10],[19,0,19,1],[19,2,19,6],[19,9,19,10],[16,0,16,1],[16,2,16,6],[16,9,16,10],[17,0,17,1],[17,2,17,6],[17,9,17,10],[14,0,14,1],[14,2,14,6],[14,9,14,10],[15,0,15,1],[15,2,15,6],[15,9,15,10],[7,9,7,10],[12,9,12,10],[11,9,11,10],[13,0,13,1],[13,2,13,6],[13,9,13,10],[12,0,12,1],[10,0,10,1],[11,0,11,1],[11,2,11,6],[12,2,12,6],[10,2,10,6],[0,0,0,2],[5,0,5,10],[3,0,3,2],[3,3,3,7],[3,8,3,10],[4,0,4,2],[4,3,4,7],[4,8,4,10],[6,9,6,10]]}
["Go to Navigation Sheet"]
[{"$f":"'CO11_Part 1'!A6","v":"DGS-30-092"},null,{"$f":"'CO11_Part 1'!A7","v":"(Rev. 07/20)"},null,null,"CONTRACT CHANGE ORDER",null,null,null,null,{"$f":"'CO11_Part 1'!AO6","v":"CO-11"},null,"   A red asterisk ( * ) is a warning that either"]
["Both the \"Initiated By\" and \"Reason for Change\"",null,null,null,null,"( Itemization of Work )",null,null,null,null,"Part 2",null,"the \"Initiated By\" or the \"Reason for Change\""]
["Project Code",null,null,"Change Order Number",null,null,null,null,"Change Order Date",null,null,null,"fields have not been completed correctly."]
[{"$f":"'CO11_Part 1'!A9","v":""},null,null,{"$f":"'CO11_Part 1'!Q9","v":0},null,null,null,null,{"$f":"'CO11_Part 1'!AG9","v":{"$error":"#N/A"}},null,null,null,"Both of these fields must be filled-in !"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(J7=\"\",\"\",\"Change Order Total (per the Change Order Log and on Part 1 of this form) = \")","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(D5,[0]!LOG_RANGE,3,FALSE)=J8,\"\",VLOOKUP(D5,[0]!LOG_RANGE,3,FALSE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,"Change Order Total (sum of the details listed below) = ",{"$f":"ROUND(SUM(J13:J113),2)","v":0}]
[{"$f":"IF(J8<>VLOOKUP(D5,[0]!LOG_RANGE,3,FALSE),\"WARNING !  The total of all details entered below does not match the amount entered in the Change Order Log and\",\"\")","v":{"$error":"#N/A"}}]
[{"$f":"IF(J8<>VLOOKUP(D5,[0]!LOG_RANGE,3,FALSE),\"Part 1 of this form.  Correct the value entered in the Log or the detail values below as required to obtain match !\",\"\")","v":{"$error":"#N/A"}}]
["Reference",null,null,null,null,null,null,"Initiated","Reason",null,null,null,"Reason for Change"]
["Number",null,"Description / Comments",null,null,null,null,"By","Code","Amount",null,null,"(this entry updates the \"Reason Code\" column)"]
[null,null,null,null,null,null,null,null,{"$f":"LEFT(M13,1)","v":""},null,null,{"$f":"IF(AND(J13<>\"\",OR(H13=\"\",I13=\"\")),\"*\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"LEFT(M14,1)","v":""},null,null,{"$f":"IF(AND(J14<>\"\",OR(H14=\"\",I14=\"\")),\"*\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,{"$f":"LEFT(M78,1)","v":""},null,null,{"$f":"IF(AND(J78<>\"\",OR(H78=\"\",I78=\"\")),\"*\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]

{"sheet":"Reason Codes","index":5,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Reason Code Legend:"]
[]
[null,null,"1 - Unforeseen site conditions."]
[null,null,"2 - Existing bldg or util conditions not as shown."]
[null,null,"3 - Change in agency's requirements."]
[null,null,"4 - Substitution or alternate method."]
[null,null,"5 - Item not as shown or specified."]
[null,null,"6 - Conflict or discrepancy in requirements."]
[null,null,"7 - Other.  Describe below the Work Description. "]

{"sheet":"CO11a_Part 1","index":6,"n_rows":60,"n_cols":11,"rows_kept":60,"cut":false,"hidden":false,"merged":[[58,0,58,2],[33,12,55,21],[9,1,31,10],[33,1,56,10],[5,3,5,7],[5,8,5,10],[0,0,0,2],[1,3,1,7],[2,3,2,7],[6,0,6,10],[4,0,4,2],[4,3,4,7],[4,8,4,10],[5,0,5,2]]}
["Go to Navigation Sheet"]
["DGS-30-096",null,null,"CHANGE ORDER JUSTIFICATION",null,null,null,null,null,null,"CO-11a"]
[{"$f":"'CO11_Part 1'!A7:H7","v":"(Rev. 07/20)"},null,null,"( Architect / Engineer's Justification )",null,null,null,null,null,null,"Part 1"]
[]
["Project Code",null,null,"Change Order Number",null,null,null,null,"Change Order Date"]
[{"$f":"'CO11_Part 1'!A9","v":""},null,null,{"$f":"'CO11_Part 1'!Q9","v":0},null,null,null,null,{"$f":"'CO11_Part 1'!AG9","v":{"$error":"#N/A"}}]
[]
[]
["A/E's DESCRIPTION OF WORK INVOLVED"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["A/E's EXPLANATION OF WHY WORK IS REQUIRED"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["A/E's RECOMMENDATION"]
["Select One"]
[null,null,null,null,"Architect / Engineer",null,null,null,null,"Date"]

{"sheet":"CO11a_Part 2","index":7,"n_rows":61,"n_cols":11,"rows_kept":61,"cut":false,"hidden":false,"merged":[[52,1,57,10],[14,1,14,10],[21,1,26,10],[31,1,36,10],[38,1,43,10],[45,1,50,10],[0,0,0,2],[11,9,11,10],[28,0,28,10],[5,0,5,2],[8,0,8,10],[5,3,5,7],[16,0,16,10],[10,9,10,10],[5,8,5,10],[12,9,12,10],[1,3,1,7],[2,3,2,7],[6,0,6,10],[4,0,4,2],[4,3,4,7],[4,8,4,10]]}
["Go to Navigation Sheet"]
[{"$f":"'CO11a_Part 1'!A2","v":"DGS-30-096"},null,null,"CHANGE ORDER JUSTIFICATION",null,null,null,null,null,null,{"$f":"'CO11a_Part 1'!K2","v":"CO-11a"}]
[{"$f":"'CO11a_Part 1'!A3","v":"(Rev. 07/20)"},null,null,"( Agency's Justification )",null,null,null,null,null,null,"Part 2"]
[]
["Project Code",null,null,"Change Order Number",null,null,null,null,"Change Order Date"]
[{"$f":"'CO11_Part 1'!A9","v":""},null,null,{"$f":"'CO11_Part 1'!Q9","v":0},null,null,null,null,{"$f":"'CO11_Part 1'!AG9","v":{"$error":"#N/A"}}]
[]
[]
["ADDITIONAL CONTINGENCY REQUIRED ?"]
[]
["Construction Contingency Amount Shown on Last Approved CO-8:"]
["Cumulative Amount Of All Change Orders To-Date, Inclusive Of This Change Order:",null,null,null,null,null,null,null,null,{"$f":"'CO11_Part 1'!N41","v":{"$error":"#N/A"}}]
[{"$f":"IF(J13<0,\"If Balance Is Negative, This Is The Minimum Additional Contingency Needed (Submit Revised CO-8)\",\"Remaining Contingency Balance After This Change\")","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,{"$f":"+J11-J12","v":{"$error":"#N/A"}}]
[]
["Remarks:"]
[]
["COST SHARING FOR DESIGN ERRORS AND OMISSIONS"]
[]
["Is this change order required in whole, or in part, because of a design error or omission?",null,null,null,null,null,null,null,null,"No"]
[]
["If \"Yes\", outline the proposed cost sharing, if any, by the responsible design professional:"]
[]
[]
[]
[]
[]
[]
[]
["ADDITIONAL SUPPORT FOR CHANGES IN AGENCY REQUIREMENTS"]
[]
["1) When was the change in requirements (function, mission) known?"]
[]
[]
[]
[]
[]
[]
["2) If known before construction bidding, why were the needed changes excluded from the bid package?"]
[]
[]
[]
[]
[]
[]
["3) What quantitative impact would the lack of this change have on the mission or service provided by the agency?"]
[]
[]
[]
[]
[]
[]
["4) Why can the work not be packaged and bid separately?"]
[]
[]
[]
[]
[]
[]
[]
["By:"]
[null,"Agency Representative",null,null,null,null,null,"Date"]

{"sheet":"CO11a_Part 3","index":8,"n_rows":55,"n_cols":11,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,0,0,2],[4,3,4,7],[5,3,5,7],[24,2,24,3],[26,2,26,3],[28,2,28,3],[7,8,7,10],[8,0,8,2],[8,3,8,7],[8,8,8,10],[9,0,9,10],[14,2,14,3],[16,2,16,3],[7,0,7,2],[7,3,7,7],[22,2,22,3],[13,2,13,3],[20,2,20,3],[18,2,18,3],[12,2,12,3]]}
["Go to Navigation Sheet"]
["No direct data entry is required on this sheet, however, verify the total is correct.  If the total is incorrect, return"]
["to the \"CO-11 Part 2\" sheet and ensure that all lines with an \"Amount\" have a corresponding \"Reason Code\"."]
[]
[{"$f":"'CO11a_Part 1'!A2","v":"DGS-30-096"},null,null,"CHANGE ORDER JUSTIFICATION",null,null,null,null,null,null,{"$f":"'CO11a_Part 1'!K2","v":"CO-11a"}]
[{"$f":"'CO11a_Part 1'!A3","v":"(Rev. 07/20)"},null,null,"( Statistical Summary )",null,null,null,null,null,null,"Part  3"]
[]
["Project Code",null,null,"Change Order Number",null,null,null,null,"Change Order Date"]
[{"$f":"'CO11_Part 1'!A9","v":""},null,null,{"$f":"'CO11_Part 1'!Q9","v":0},null,null,null,null,{"$f":"'CO11_Part 1'!AG9","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,"Reason"]
[null,"Code","Amount",null,null,null,"Reason Code Description"]
[null,1,{"$f":"DSUM('CO11_Part 2'!I12:K113,\"Amount\",'CO11a_Part 3'!C42:C43)","v":0},null,null,"1 - Unforeseen site conditions"]
[]
[null,2,{"$f":"DSUM('CO11_Part 2'!I12:K113,\"Amount\",'CO11a_Part 3'!C44:C45)","v":0},null,null,"2 - Existing building or utility conditions not as shown"]
[]
[null,3,{"$f":"DSUM('CO11_Part 2'!I12:K113,\"Amount\",'CO11a_Part 3'!C46:C47)","v":0},null,null,"3 - Change in agency's requirements"]
[]
[null,4,{"$f":"DSUM('CO11_Part 2'!I12:K113,\"Amount\",'CO11a_Part 3'!C48:C49)","v":0},null,null,"4 - Substitution or alternate method"]
[]
[null,5,{"$f":"DSUM('CO11_Part 2'!I12:K113,\"Amount\",'CO11a_Part 3'!C50:C51)","v":0},null,null,"5 - Item not as shown or specified"]
[]
[null,6,{"$f":"DSUM('CO11_Part 2'!I12:K113,\"Amount\",'CO11a_Part 3'!C52:C53)","v":0},null,null,"6 - Conflict or discrepancy in requirements"]
[]
[null,7,{"$f":"DSUM('CO11_Part 2'!I12:K113,\"Amount\",'CO11a_Part 3'!C54:C55)","v":0},null,null,"7 - Other."]
[]
[null,"Total",{"$f":"SUM(C15:C28)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Criteria Fields for DataSum Operation Above"]
[null,"(do not delete these entries)"]
[]
[null,null,"Code"]
[null,null,1]
[null,null,"Code"]
[null,null,2]
[null,null,"Code"]
[null,null,3]
[null,null,"Code"]
[null,null,4]
[null,null,"Code"]
[null,null,5]
[null,null,"Code"]
[null,null,6]
[null,null,"Code"]
[null,null,7]

{"sheet":"Transmittal","index":9,"n_rows":43,"n_cols":19,"rows_kept":43,"cut":false,"hidden":false,"merged":[[3,0,3,3],[3,6,3,7],[3,9,3,10],[3,16,3,18],[0,0,0,4],[1,1,1,18],[2,0,2,3],[2,6,2,7],[2,9,2,10],[4,0,8,0],[4,6,4,7],[4,9,4,10],[4,16,4,18],[5,4,5,18],[6,4,6,18],[7,4,7,18],[8,4,8,18],[19,1,19,15],[20,1,20,15],[21,1,21,15],[22,1,22,15],[9,0,9,3],[9,4,9,11],[9,13,9,18],[10,0,13,0],[10,4,10,11],[10,12,10,18],[11,4,11,11],[11,12,11,18],[12,4,12,11],[12,12,12,18],[13,4,13,11],[13,12,13,18],[30,17,30,18],[31,1,31,18],[32,1,40,18],[42,0,42,16],[23,1,23,15],[24,1,24,15],[25,1,25,15],[26,1,26,15],[28,0,40,0],[28,1,28,16],[29,1,29,16],[30,1,30,16],[15,0,26,0],[15,1,18,15],[15,16,15,18],[18,16,18,18]]}
["Go to Navigation Sheet"]
[null,"Transmittal for DEB Review Services"]
[]
[null,null,null,null,"Agency #",null,"Project #",null,null,"Subproj.#",null,null,null,null,null,"Date Submitted:"]
["PROJECT","Project Code:",null,null,{"$f":"'CO Log'!C5","v":0},"-",{"$f":"'CO Log'!C6","v":0},null,"-",{"$f":"'CO Log'!C7","v":0},null,null,null,null,null,"Submitted By:"]
[null,"Agency: ",null,null,{"$f":"'CO Log'!D5","v":0}]
[null,"Project Title:",null,null,{"$f":"'CO Log'!D6","v":0}]
[null,"Subproject Title:",null,null,{"$f":"'CO Log'!D7","v":0}]
[null,"Remarks:"]
[null,null,null,null,"Agency Contact",null,null,null,null,null,null,null,null,"Architect/Engineer Contact"]
["CONTACTS","Agency/Firm Name:"]
[null,"Contact Name:"]
[null,"Contact Phone #:"]
[null,"Contact E-mail:"]
[]
["SUBMITTAL REQUIREMENTS","Construction Change Order",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Construction Change Orders exceed:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25% of the original Contract Price or $50,000,","50% of the original Contract Price or $500,000,","100% of the original Contract Price or $1,000,000,"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"whichever is greater","whichever is greater","whichever is greater"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Identify the number of copies of each document submitted in the boxes below)"]
[null,"Cover letter with description of change and indication if work is already complete.   "]
[null,"Use form DGS-30-092 (CO-11)"]
[null,"Use form DGS-30-096 (CO-11a)"]
[null,"Use form DGS-30-200 (GC-1)"]
[null,"Use form DGS-30-204 (SC-1) as needed"]
[null,"Use form DGS-30-208 (SS-1) as needed"]
[null,"Cover letter must be from agency head.   "]
[null,"Emergency declaration in the manner provided in § 2.2-4303"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No"]
["ADDITIONAL INFORMATION","Are funds available within the project to cover the added costs that this change order will cause?"]
[null,"Does this change order add sq. ft. to the project?"]
[null,"If yes, specify total sq. ft. added"]
[null,"Provide a description of the key factors that caused the aggregate construction change orders to increase the contract by this magnitude."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NOTE:  The \"DGS-30...\" forms referenced above are available from the",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DGS Forms Center"]