{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Print-Preview","New_Change_Order","Summary_Justification_Report","Pivot Table","User Guide","TemplateFinalReport","CO Cause Category Mapping","TemplateLists"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":1},"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":"Print-Preview","index":0,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,12],[1,0,14,12]]}
["TN OSA Change Order Summary Report Workbook"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"  "]

{"sheet":"New_Change_Order","index":1,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,0,16,2],[16,3,16,6],[16,7,16,12],[16,13,16,14],[17,0,17,2],[17,3,17,6],[17,7,17,12],[17,13,17,14],[14,0,14,10],[14,11,14,14],[15,0,15,2],[15,3,15,6],[15,7,15,12],[15,13,15,14],[11,0,11,10],[11,11,11,14],[12,0,12,10],[12,11,12,14],[13,0,13,10],[13,11,13,14],[8,0,8,5],[8,6,8,14],[9,0,9,10],[9,11,9,14],[10,0,10,10],[10,11,10,14],[6,1,6,2],[6,4,6,6],[6,7,6,10],[6,11,6,14],[7,0,7,5],[7,6,7,14],[5,0,5,2],[5,4,5,6],[5,7,5,10],[5,11,5,14],[4,0,4,2],[4,4,4,6],[4,7,4,10],[4,11,4,14],[0,0,0,14],[1,0,1,2],[1,3,1,6],[1,7,1,8],[1,9,1,14],[2,0,2,2],[2,3,2,6],[2,7,2,8],[2,9,2,14],[3,0,3,2],[3,3,3,6],[3,7,3,8],[3,10,3,11],[3,13,3,14]]}
["New Change Order - Project Information "]
["SPA",null,null,"Select SPA",null,null,null,"User Agency"]
["Project Title",null,null,null,null,null,null,"Location"]
["SBC No.",null,null,null,null,null,null,"Subprojects",null,null,"Single",null,null,"Multiple"]
[null,null,null,"Bid Target","MACC",null,null,"Contingency",null,null,null,"% of Bid Target:"]
["Master Project",null,null,null,null,null,null,{"$f":"E6-D6","v":0},null,null,null,{"$f":"IFERROR(H6/D6,\"\")","v":""}]
["Subproject #",null,null,null,null,null,null,{"$f":"E7-D7","v":0},null,null,null,{"$f":"IFERROR(H7/D7,\"\")","v":""}]
["Total Amount of Undedicated Funds (After Current Change Order) ",null,null,null,null,null,{"$f":"SUM(G10:O15)","v":0}]
["Provide a simple description of sources of undedicated project funds after this Current Change Order:",null,null,null,null,null,"Provide corresponding amounts of undedicated project funds after this Current Change Order:"]
[]
[]
[]
[]
[]
[]
["Designer",null,null,null,null,null,null,"Construction Completion %"]
["Contractor",null,null,null,null,null,null,"Target Substantial Completion"]
["Base Contract Amount",null,null,null,null,null,null,"Current Change Order #"]

{"sheet":"Summary_Justification_Report","index":2,"n_rows":3,"n_cols":9,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,0,2,5]]}
["Justification For","Initiating Entity","Cause","Time","Cost","CO #","TYPE","Current Justification for Report","All Current Justifications for Report"]
["Current Change Order","Select","Select",null,null,null,{"$f":"CONCATENATE(A2,B2,C2)","v":"Current Change OrderSelectSelect"},{"$f":"IF(A2=\"Current Change Order\",A3,\"\")","v":"Provide summary justification here."},{"$f":"_xlfn.TEXTJOIN(CHAR(10),TRUE,H2:H$97)","v":"Provide summary justification here."}]
["Provide summary justification here."]

{"sheet":"Pivot Table","index":3,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Row Labels","Sum of Time","Sum of Cost"]
["Current Change OrderSelectSelect"]
["(blank)"]
["Grand Total"]

{"sheet":"User Guide","index":4,"n_rows":57,"n_cols":2,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,0,0,10],[50,1,50,10],[1,0,1,10],[44,0,44,10],[48,0,48,10],[49,1,49,10],[45,1,47,10],[45,0,47,0],[8,1,9,10],[56,1,56,10],[51,1,51,10],[52,0,52,10],[53,1,53,10],[54,1,54,10],[55,0,55,10]]}
["User Guide"]
["1. How to resolve \"Microsoft has blocked macros\""]
[]
[]
[]
[]
[]
[null,"How to unblock a macro workbook in Excel"]
[null,"In new versions of Excel, Microsoft has changed the behavior for macro-enabled files downloaded from the internet. Instead of the yellow Security Warning that allows enabling the content straight away, it now often displays a read Security Risk bar with this message: Microsoft has blocked macros from running because the source of this file is untrusted."]
[]
[]
[null,"To unblock a macro that is blocked by Microsoft, this is what you need to do:"]
[]
[null,"1.      Close the workbook containing the blocked macro."]
[null,"2.      In File Explorer, browser to the location where the workbook is saved."]
[null,"3.      Right-click the file, and select Properties from the context menu."]
[null,"4.      In the Properties dialog box, check the Unblock box, and then click OK."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2.  Creating a Change Order Summary Report - Project Information: Printing and Previewing"]
[null,"a. On the \"New_Change_Order\" worksheet, populate the fields.  These fields will automatically populate within the Change Order Summary Report which can be viewed on the Main Menu by clicking the Print/ Preview Final CO Report button."]
[]
[]
["3.  Creating a Summary Justification Report: Printing and Previewing"]
[null,"a.  On the \"Summary_Justification_Report\" worksheet, use the dropdown boxes provided to select the appropriate \"Justification For\", \"Initiating Entity\" and \"Cause\".  Enter the \"Time\", \"Cost\" and \"Change Order Number\" as needed.  A field for the summary justification narrative is provided and can be resized manually based on the amount of text required.  See Section 2d. for information on resizing the text fields. "]
[null,"b. To add multiple summary justifications, click the \"Add Summary Justification\" button.  "]
[null,"d.  To view or print the Summary Justification Report in pdf format, go to the \"Main Menu\" worksheet and click \"Print / Preview Summary Justification Report\". NOTE:  If the justification text field in the summary justification Print Preview is not sufficient to show all text, go to the \"Summary_Justification_Report\" worksheet and manually increase the row height until all text is visible in the Print Preview.  Oversizing the row height by 2 to 3 lines typically resolves the issue."]
["4.  Submitting a Change Order and Summary Justification Report"]
[null,"a.  If the change order contains only Current Summary Justification, print only the Change Order Summary Report to pdf format, sign, date, attach to the CO packet and submit."]
[null,"b.  If the change order contains both Current Change Order Summary Justifications and Previous Change Order Summary Justifications, print both the Change Order Summary Report and Summary Justification Report to pdf format, sign, date, attach both pdf's to the CO packet and submit."]
["5.  Submitting the Change Order Report Excel Workbook to OSA"]
[null,"a.  If a project has reached a CO threshold requiring submission to OSA, at project closeout please email the final OSA CO Report Excel Workbook to:  State.Architect@tn.gov"]

{"sheet":"TemplateFinalReport","index":5,"n_rows":40,"n_cols":17,"rows_kept":40,"cut":false,"hidden":true,"merged":[[39,0,39,1],[39,8,39,9],[30,3,30,4],[24,0,26,2],[26,3,26,4],[24,3,24,4],[33,13,33,14],[35,6,35,9],[37,0,37,14],[36,0,36,14],[34,0,35,2],[34,3,34,5],[34,6,34,9],[34,10,35,14],[35,3,35,5],[27,0,33,2],[33,3,33,4],[29,13,29,14],[33,6,33,7],[29,10,29,11],[33,8,33,9],[33,10,33,11],[32,3,32,4],[32,8,32,9],[29,3,29,4],[29,8,29,9],[26,13,26,14],[26,10,26,11],[19,6,19,7],[28,8,28,9],[27,8,27,9],[24,8,24,9],[24,10,24,11],[25,13,25,14],[25,8,25,9],[24,13,24,14],[27,13,27,14],[28,3,28,4],[27,10,27,11],[25,10,25,11],[25,3,25,4],[32,10,32,11],[32,13,32,14],[30,10,30,11],[30,13,30,14],[31,3,31,4],[31,8,31,9],[31,10,31,11],[31,13,31,14],[30,8,30,9],[7,0,7,5],[7,6,7,14],[8,0,8,10],[10,0,10,10],[26,8,26,9],[28,10,28,11],[28,13,28,14],[27,3,27,4],[22,8,22,9],[22,10,22,11],[22,13,22,14],[23,13,23,14],[20,3,20,4],[20,8,20,9],[20,10,20,11],[20,13,20,14],[21,3,21,4],[16,8,16,12],[15,13,15,14],[16,13,16,14],[15,3,15,7],[16,3,16,7],[18,10,18,14],[18,0,18,9],[3,0,3,2],[3,4,3,6],[3,7,3,10],[3,11,3,14],[6,0,6,5],[6,6,6,14],[4,0,4,2],[4,4,4,6],[4,7,4,10],[4,11,4,14],[5,1,5,2],[5,4,5,6],[5,7,5,10],[5,11,5,14],[0,0,0,2],[0,3,0,6],[0,7,0,8],[0,9,0,14],[1,0,1,2],[1,3,1,6],[1,7,1,8],[1,9,1,14],[2,10,2,11],[2,13,2,14],[2,0,2,2],[2,3,2,6],[2,7,2,8],[8,11,8,14],[15,0,15,2],[15,8,15,12],[14,0,14,14],[39,2,39,6],[40,0,40,14],[39,10,39,14],[9,11,9,14],[10,11,10,14],[11,11,11,14],[12,11,12,14],[13,11,13,14],[9,0,9,10],[38,0,38,14],[19,13,19,14],[21,8,21,9],[21,10,21,11],[21,13,21,14],[16,0,16,2],[17,0,17,2],[17,3,17,4],[19,8,19,9],[19,10,19,11],[22,3,22,4],[20,0,23,2],[19,0,19,2],[19,3,19,4],[17,8,17,9],[17,5,17,6],[17,10,17,11],[17,12,17,14],[11,0,11,10],[12,0,12,10],[13,0,13,10],[23,3,23,4],[23,8,23,9],[23,10,23,11]]}
["SPA",null,null,{"$f":"IFERROR(INDIRECT(\"New_Change_Order!D2\"),\"\")","v":"Select SPA"},null,null,null,"User Agency",null,{"$f":"IFERROR(INDIRECT(\"New_Change_Order!J2\"),\"\")","v":0}]
["Project Title",null,null,{"$f":"IFERROR(INDIRECT(\"New_Change_Order!D3\"),\"\")","v":0},null,null,null,"Location",null,{"$f":"IFERROR(INDIRECT(\"New_Change_Order!J3\"),\"\")","v":0}]
["SBC No.",null,null,{"$f":"IFERROR(INDIRECT(\"New_Change_Order!D4\"),\"\")","v":0},null,null,null,"Subprojects",null,{"$f":"IFERROR(INDIRECT(\"New_Change_Order!J4\"),\"\")","v":0},"Single",null,{"$f":"IFERROR(INDIRECT(\"New_Change_Order!M4\"),\"\")","v":0},"Multiple"]
[null,null,null,"Bid Target","MACC",null,null,"Contingency",null,null,null,"% of Bid Target:"]
["Master Project",null,null,{"$f":"IFERROR(INDIRECT(\"New_Change_Order!D6\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(\"New_Change_Order!E6\"),\"\")","v":0},null,null,{"$f":"IFERROR(INDIRECT(\"New_Change_Order!H6\"),\"\")","v":0},null,null,null,{"$f":"IFERROR(INDIRECT(\"New_Change_Order!L6\"),\"\")","v":""}]
["Subproject #",{"$f":"IFERROR(INDIRECT(\"New_Change_Order!B7\"),\"\")","v":0},null,{"$f":"IFERROR(INDIRECT(\"New_Change_Order!D7\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(\"New_Change_Order!E7\"),\"\")","v":0},null,null,{"$f":"IFERROR(INDIRECT(\"New_Change_Order!H7\"),\"\")","v":0},null,null,null,{"$f":"IFERROR(INDIRECT(\"New_Change_Order!L7\"),\"\")","v":""}]
["Total Amount of Undedicated Funds (After this Change Order) ",null,null,null,null,null,{"$f":"SUM(G9:O14)","v":0}]
["Provide a simple description of sources of undedicated project funds after this Current Change Order:",null,null,null,null,null,"Provide corresponding amounts of undedicated project funds after this Current Change Order:"]
[{"$f":"IFERROR(INDIRECT(\"New_Change_Order!A10\"),\"\")","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDIRECT(\"New_Change_Order!L10\"),\"\")","v":0}]
[{"$f":"IFERROR(INDIRECT(\"New_Change_Order!A11\"),\"\")","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDIRECT(\"New_Change_Order!L11\"),\"\")","v":0}]
[{"$f":"IFERROR(INDIRECT(\"New_Change_Order!A12\"),\"\")","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDIRECT(\"New_Change_Order!L12\"),\"\")","v":0}]
[{"$f":"IFERROR(INDIRECT(\"New_Change_Order!A13\"),\"\")","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDIRECT(\"New_Change_Order!L13\"),\"\")","v":0}]
[{"$f":"IFERROR(INDIRECT(\"New_Change_Order!A14\"),\"\")","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDIRECT(\"New_Change_Order!L14\"),\"\")","v":0}]
[{"$f":"IFERROR(INDIRECT(\"New_Change_Order!A15\"),\"\")","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDIRECT(\"New_Change_Order!L15\"),\"\")","v":0}]
[]
["Designer",null,null,{"$f":"IFERROR(INDIRECT(\"New_Change_Order!D16\"),\"\")","v":0},null,null,null,null,"Construction Completion %",null,null,null,null,{"$f":"IFERROR(INDIRECT(\"New_Change_Order!N16\"),\"\")","v":0}]
["Contractor",null,null,{"$f":"IFERROR(INDIRECT(\"New_Change_Order!D17\"),\"\")","v":0},null,null,null,null,"Target Substantial Completion",null,null,null,null,{"$f":"IFERROR(INDIRECT(\"New_Change_Order!N17\"),\"\")","v":"00:00:00"}]
["Base Contract Amt",null,null,{"$f":"IFERROR(INDIRECT(\"New_Change_Order!D18\"),\"\")","v":0},null,"Current Change Order",null,"#",{"$f":"IFERROR(INDIRECT(\"New_Change_Order!N18\"),\"\")","v":0},null,"Total",null,"Previous Change Order(s)"]
[null,null,null,null,null,null,null,null,null,null,"Including This Change Order"]
["Initiating Entity",null,null,"Cause",null,"Time","Cost",null,"% BCA",null,"Time",null,"Cost","% BCA"]
["External_Factors",null,null,"Hidden Conditions",null,{"$f":"IFERROR(VLOOKUP(P21,'Pivot Table'!A$4:C$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P21,'Pivot Table'!A$4:C$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(R21,'Pivot Table'!C$4:E100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(G21/D$18,\"\")","v":""},null,{"$f":"IFERROR(SUM(VLOOKUP(Q21,'Pivot Table'!A$4:C$100,2,FALSE),F21),F21)","v":""},null,{"$f":"IFERROR(SUM(VLOOKUP(Q21,'Pivot Table'!A$4:C$100,3,FALSE),G21),G21)","v":""},{"$f":"IFERROR(M21/D$18,\"\")","v":""},null,{"$f":"CONCATENATE(TemplateLists!E$2,A21,D21)","v":"Current Change OrderExternal_FactorsHidden Conditions"},{"$f":"CONCATENATE(TemplateLists!E$3,A21,D21)","v":"Previous Change OrderExternal_FactorsHidden Conditions"}]
[null,null,null,"Codes (Provide Code Regulations)",null,{"$f":"IFERROR(VLOOKUP(P22,'Pivot Table'!A$4:C$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P22,'Pivot Table'!A$4:C101,3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(G22/D$18,\"\")","v":""},null,{"$f":"IFERROR(SUM(VLOOKUP(Q22,'Pivot Table'!A$4:C$100,2,FALSE),F22),F22)","v":""},null,{"$f":"IFERROR(SUM(VLOOKUP(Q22,'Pivot Table'!A$4:C$100,3,FALSE),G22),G22)","v":""},{"$f":"IFERROR(M22/D$18,\"\")","v":""},null,{"$f":"CONCATENATE(TemplateLists!E$2,A21,D22)","v":"Current Change OrderExternal_FactorsCodes (Provide Code Regulations)"},{"$f":"CONCATENATE(TemplateLists!E$3,A21,D22)","v":"Previous Change OrderExternal_FactorsCodes (Provide Code Regulations)"}]
[null,null,null,"Unavoidable Delays",null,{"$f":"IFERROR(VLOOKUP(P23,'Pivot Table'!A$4:C$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P23,'Pivot Table'!A$4:C102,3,FALSE),\"\")","v":""},null,"",null,{"$f":"IFERROR(SUM(VLOOKUP(Q23,'Pivot Table'!A$4:C$100,2,FALSE),F23),F23)","v":""},null,{"$f":"IFERROR(SUM(VLOOKUP(Q23,'Pivot Table'!A$4:C$100,3,FALSE),G23),G23)","v":""},"",null,{"$f":"CONCATENATE(TemplateLists!E$2,A21,D23)","v":"Current Change OrderExternal_FactorsUnavoidable Delays"},{"$f":"CONCATENATE(TemplateLists!E$3,A21,D23)","v":"Previous Change OrderExternal_FactorsUnavoidable Delays"}]
[null,null,null,"Other - External Factors",null,{"$f":"IFERROR(VLOOKUP(P24,'Pivot Table'!A$4:C$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P24,'Pivot Table'!A$4:C103,3,FALSE),\"\")","v":""},null,"",null,{"$f":"IFERROR(SUM(VLOOKUP(Q24,'Pivot Table'!A$4:C$100,2,FALSE),F24),F24)","v":""},null,{"$f":"IFERROR(SUM(VLOOKUP(Q24,'Pivot Table'!A$4:C$100,3,FALSE),G24),G24)","v":""},"",null,{"$f":"CONCATENATE(TemplateLists!E$2,A21,D24)","v":"Current Change OrderExternal_FactorsOther - External Factors"},{"$f":"CONCATENATE(TemplateLists!E$3,A21,D24)","v":"Previous Change OrderExternal_FactorsOther - External Factors"}]
["Designer",null,null,"Error",null,{"$f":"IFERROR(VLOOKUP(P25,'Pivot Table'!A$4:C$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P25,'Pivot Table'!A$4:C104,3,FALSE),\"\")","v":""},null,"",null,{"$f":"IFERROR(SUM(VLOOKUP(Q25,'Pivot Table'!A$4:C$100,2,FALSE),F25),F25)","v":""},null,{"$f":"IFERROR(SUM(VLOOKUP(Q25,'Pivot Table'!A$4:C$100,3,FALSE),G25),G25)","v":""},"",null,{"$f":"CONCATENATE(TemplateLists!E$2,A25,D25)","v":"Current Change OrderDesignerError"},{"$f":"CONCATENATE(TemplateLists!E$3,A25,D25)","v":"Previous Change OrderDesignerError"}]
[null,null,null,"Omission",null,{"$f":"IFERROR(VLOOKUP(P26,'Pivot Table'!A$4:C$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P26,'Pivot Table'!A$4:C105,3,FALSE),\"\")","v":""},null,"",null,{"$f":"IFERROR(SUM(VLOOKUP(Q26,'Pivot Table'!A$4:C$100,2,FALSE),F26),F26)","v":""},null,{"$f":"IFERROR(SUM(VLOOKUP(Q26,'Pivot Table'!A$4:C$100,3,FALSE),G26),G26)","v":""},"",null,{"$f":"CONCATENATE(TemplateLists!E$2,A25,D26)","v":"Current Change OrderDesignerOmission"},{"$f":"CONCATENATE(TemplateLists!E$3,A25,D26)","v":"Previous Change OrderDesignerOmission"}]
[null,null,null,"Other - Designer",null,{"$f":"IFERROR(VLOOKUP(P27,'Pivot Table'!A$4:C$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P27,'Pivot Table'!A$4:C106,3,FALSE),\"\")","v":""},null,"",null,{"$f":"IFERROR(SUM(VLOOKUP(Q27,'Pivot Table'!A$4:C$100,2,FALSE),F27),F27)","v":""},null,{"$f":"IFERROR(SUM(VLOOKUP(Q27,'Pivot Table'!A$4:C$100,3,FALSE),G27),G27)","v":""},"",null,{"$f":"CONCATENATE(TemplateLists!E$2,A25,D27)","v":"Current Change OrderDesignerOther - Designer"},{"$f":"CONCATENATE(TemplateLists!E$3,A25,D27)","v":"Previous Change OrderDesignerOther - Designer"}]
["Owner_User_Agency",null,null,"Schedule Modifications",null,{"$f":"IFERROR(VLOOKUP(P28,'Pivot Table'!A$4:C$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P28,'Pivot Table'!A$4:C107,3,FALSE),\"\")","v":""},null,"",null,{"$f":"IFERROR(SUM(VLOOKUP(Q28,'Pivot Table'!A$4:C$100,2,FALSE),F28),F28)","v":""},null,{"$f":"IFERROR(SUM(VLOOKUP(Q28,'Pivot Table'!A$4:C$100,3,FALSE),G28),G28)","v":""},"",null,{"$f":"CONCATENATE(TemplateLists!E$2,A28,D28)","v":"Current Change OrderOwner_User_AgencySchedule Modifications"},{"$f":"CONCATENATE(TemplateLists!E$3,A28,D28)","v":"Previous Change OrderOwner_User_AgencySchedule Modifications"}]
[null,null,null,"Design Modifications",null,{"$f":"IFERROR(VLOOKUP(P29,'Pivot Table'!A$4:C$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P29,'Pivot Table'!A$4:C108,3,FALSE),\"\")","v":""},null,"",null,{"$f":"IFERROR(SUM(VLOOKUP(Q29,'Pivot Table'!A$4:C$100,2,FALSE),F29),F29)","v":""},null,{"$f":"IFERROR(SUM(VLOOKUP(Q29,'Pivot Table'!A$4:C$100,3,FALSE),G29),G29)","v":""},"",null,{"$f":"CONCATENATE(TemplateLists!E$2,A28,D29)","v":"Current Change OrderOwner_User_AgencyDesign Modifications"},{"$f":"CONCATENATE(TemplateLists!E$3,A28,D29)","v":"Previous Change OrderOwner_User_AgencyDesign Modifications"}]
[null,null,null,"Added Scope",null,{"$f":"IFERROR(VLOOKUP(P30,'Pivot Table'!A$4:C$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P30,'Pivot Table'!A$4:C109,3,FALSE),\"\")","v":""},null,"",null,{"$f":"IFERROR(SUM(VLOOKUP(Q30,'Pivot Table'!A$4:C$100,2,FALSE),F30),F30)","v":""},null,{"$f":"IFERROR(SUM(VLOOKUP(Q30,'Pivot Table'!A$4:C$100,3,FALSE),G30),G30)","v":""},"",null,{"$f":"CONCATENATE(TemplateLists!E$2,A28,D30)","v":"Current Change OrderOwner_User_AgencyAdded Scope"},{"$f":"CONCATENATE(TemplateLists!E$3,A28,D30)","v":"Previous Change OrderOwner_User_AgencyAdded Scope"}]
[null,null,null,"Cost Efficiencies",null,{"$f":"IFERROR(VLOOKUP(P31,'Pivot Table'!A$4:C$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P31,'Pivot Table'!A$4:C110,3,FALSE),\"\")","v":""},null,"",null,{"$f":"IFERROR(SUM(VLOOKUP(Q31,'Pivot Table'!A$4:C$100,2,FALSE),F31),F31)","v":""},null,{"$f":"IFERROR(SUM(VLOOKUP(Q31,'Pivot Table'!A$4:C$100,3,FALSE),G31),G31)","v":""},"",null,{"$f":"CONCATENATE(TemplateLists!E$2,A28,D31)","v":"Current Change OrderOwner_User_AgencyCost Efficiencies"},{"$f":"CONCATENATE(TemplateLists!E$3,A28,D31)","v":"Previous Change OrderOwner_User_AgencyCost Efficiencies"}]
[null,null,null,"Value Added",null,{"$f":"IFERROR(VLOOKUP(P32,'Pivot Table'!A$4:C$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P32,'Pivot Table'!A$4:C111,3,FALSE),\"\")","v":""},null,"",null,{"$f":"IFERROR(SUM(VLOOKUP(Q32,'Pivot Table'!A$4:C$100,2,FALSE),F32),F32)","v":""},null,{"$f":"IFERROR(SUM(VLOOKUP(Q32,'Pivot Table'!A$4:C$100,3,FALSE),G32),G32)","v":""},"",null,{"$f":"CONCATENATE(TemplateLists!E$2,A28,D32)","v":"Current Change OrderOwner_User_AgencyValue Added"},{"$f":"CONCATENATE(TemplateLists!E$3,A28,D32)","v":"Previous Change OrderOwner_User_AgencyValue Added"}]
[null,null,null,"Other - Owner / Agency",null,{"$f":"IFERROR(VLOOKUP(P33,'Pivot Table'!A$4:C$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P33,'Pivot Table'!A$4:C112,3,FALSE),\"\")","v":""},null,"",null,{"$f":"IFERROR(SUM(VLOOKUP(Q33,'Pivot Table'!A$4:C$100,2,FALSE),F33),F33)","v":""},null,{"$f":"IFERROR(SUM(VLOOKUP(Q33,'Pivot Table'!A$4:C$100,3,FALSE),G33),G33)","v":""},"",null,{"$f":"CONCATENATE(TemplateLists!E$2,A28,D33)","v":"Current Change OrderOwner_User_AgencyOther - Owner / Agency"},{"$f":"CONCATENATE(TemplateLists!E$3,A28,D33)","v":"Previous Change OrderOwner_User_AgencyOther - Owner / Agency"}]
[null,null,null,"TOTAL",null,{"$f":"SUM(F21:F33)","v":0},{"$f":"SUM(G21:G33)","v":0},null,{"$f":"SUM(I21:J33)","v":0},null,{"$f":"SUM(K21:L33)","v":0},null,{"$f":"SUM(M21:M33)","v":0},{"$f":"SUM(N21:O33)","v":0}]
[null,null,null,"Total Change Orders",null,null,{"$f":"M34","v":0}]
[null,null,null,"Revised Contract Amount",null,null,{"$f":"IFERROR(G35+D18,\"\")","v":0}]
[]
["Provide a summary justification for the Current Change Order to be approved:"]
[{"$f":"Summary_Justification_Report!I2","v":"Provide summary justification here."}]
["Submitted by:",null,null,null,null,null,null,null,"Date:"]

{"sheet":"CO Cause Category Mapping","index":6,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[25,0,25,10],[19,0,19,10],[21,0,21,10],[24,0,24,10],[20,0,20,10],[22,0,22,10],[23,0,23,10],[12,0,12,10],[14,0,14,10],[16,0,16,10],[17,0,17,10],[18,0,18,10],[13,0,13,10],[15,0,15,10],[0,0,0,10],[1,0,1,10],[2,0,2,2],[3,0,3,2],[4,0,4,2],[3,3,3,10],[4,3,4,10],[2,3,2,10],[10,0,10,10],[11,0,11,10],[5,0,5,2],[6,0,6,2],[7,0,7,2],[8,0,8,2],[5,3,5,10],[6,3,6,10],[7,3,7,10],[9,0,9,10],[8,3,8,10]]}
["Change Order Cause Category Mapping"]
["The category mapping below represents a general suggestion.  In cooperation with project teams, Project Manager's and Development Manager's should exercise their own judgement as to selecting the most appropriate category given the specifics of the project.  If there are questions as to the most appropriate category, contact OSA."]
["STREAM Category",null,null,"Suggested Category (Cause)"]
["Hidden Conditions",null,null,"External Factors > Hidden Conditions"]
["Designer Error",null,null,"Designer > Error"]
["Designer Omission",null,null,"Designer > Omission",null,null,null,null,null,null,null," "]
["Program",null,null,"Owner User Agency > Schedule Modifications, Design Modifications, Added Scope, Cost Efficiencies, Value Added,  "]
["Code",null,null,"External Factors > Codes"]
["Miscellaneous",null,null,"External Factors > Other -  External Factors, Designer > Other - Designer, Owner User/Agency > Other - Owner/User Agency"]

{"sheet":"TemplateLists","index":7,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Select","External_Factors","Designer","Owner_User_Agency","CO Domain","SPA"]
[null,"Select","Select","Select","Current Change Order","Select SPA"]
[null,"Hidden Conditions","Error","Schedule Modifications","Previous Change Order","APSU"]
[null,"Codes (Provide Code Regulations)","Omission","Design Modifications",null,"ETSU"]
[null,"Unavoidable Delays","Other - Designer","Added Scope",null,"MTSU"]
[null,"Other - External Factors",null,"Cost Efficiencies",null,"STREAM"]
[null,null,null,"Value Added",null,"TBR"]
[null,null,null,"Other - Owner / Agency",null,"TTU"]
[null,null,null,null,null,"UM"]
[null,null,null,null,null,"UT"]