{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Main Form","Dropdowns","Anticipated Conflicts","A-3","A-5A","A-5D","A-5P","A-5R","A-5T","A-6E","A-6N","A-7PR","A-7PT","A-8","A-9","A-10"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":42,"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":"Main Form","index":0,"n_rows":464,"n_cols":36,"rows_kept":464,"cut":false,"hidden":false,"merged":[[203,15,203,17],[204,15,204,17],[205,15,205,17],[154,8,155,12],[154,13,155,13],[154,14,155,19],[195,7,195,34],[196,7,196,34],[197,7,197,34],[198,7,198,34],[201,1,201,34],[158,8,158,13],[159,8,159,13],[160,8,160,13],[161,8,161,13],[194,7,194,34],[160,16,160,21],[159,24,159,29],[160,24,160,29],[195,2,195,6],[196,2,196,6],[197,2,197,6],[162,16,162,21],[161,16,161,21],[10,26,10,34],[10,4,10,20],[12,9,12,15],[13,9,13,15],[14,9,14,15],[1,28,1,34],[9,26,9,34],[8,26,8,34],[7,26,7,34],[7,4,7,20],[8,4,8,20],[9,4,9,20],[4,1,4,14],[4,15,4,34],[5,1,5,14],[5,15,5,34],[3,29,3,34],[3,1,3,7],[1,4,1,23],[120,2,121,34],[123,2,124,34],[126,2,127,34],[64,2,64,31],[66,2,66,34],[12,16,12,20],[13,16,13,20],[14,16,14,20],[15,16,15,20],[19,2,19,34],[26,2,26,34],[40,2,40,34],[45,2,45,34],[55,2,55,34],[52,2,53,34],[23,2,24,34],[33,3,34,34],[36,3,37,34],[42,2,43,34],[50,4,50,34],[71,2,71,10],[117,2,118,34],[72,2,72,34],[81,2,81,34],[86,2,86,34],[92,2,92,34],[71,11,71,16],[71,17,71,24],[102,2,103,34],[105,2,106,34],[108,2,109,34],[111,2,112,34],[114,2,115,34],[97,2,97,34],[99,2,100,34],[144,7,144,34],[145,7,145,34],[146,7,146,34],[147,7,147,34],[158,24,158,29],[159,16,159,21],[69,2,69,34],[405,6,405,12],[419,6,419,12],[207,6,207,12],[162,8,162,13],[158,16,158,21],[198,2,198,6],[144,2,144,6],[145,2,145,6],[146,2,146,6],[147,2,147,6],[194,2,194,6],[136,2,136,34],[142,2,142,34],[149,2,149,34],[154,7,155,7],[129,2,130,34],[132,2,133,34],[442,6,442,12],[448,6,448,12],[456,6,456,12],[280,6,280,12],[307,6,307,12],[343,6,343,12],[371,6,371,12],[382,6,382,12],[223,6,223,12],[225,6,225,12],[230,6,230,12],[252,6,252,12]]}
[]
[null,null,null,null,"UTILITY WORKSHEET \nWisconsin Department of Transportation",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(OR(F208=-1, F224=-1, F226=-1, F231=-1, F253=-1, F281=-1, F308=-1, F344=-1, F372=-1, F383=-1, F406=-1, F420=-1, F443=-1, F449=-1, F457=-1), \"INCOMPLETE\", \"\")","v":"INCOMPLETE"}]
[null,"DT2236        03/2026        §84.063 Wis. Stats."]
[null,"Locals    03/2026     \nv2.0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Job Aid (See §2.2)"]
[null,"UTILITY FACILITY OWNER (OWNER):"]
[null,"UTILITY FACILITY TYPE:"]
[null,"PROJECT DESCRIPTION:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROJECT ID(S):"]
[null,"Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Design:"]
[null,"Limits:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction:"]
[null,"Highway:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Right of Way:"]
[null,"County:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U and/or UA No:"]
[null,"DATES AND SUBMISSION TRACKING:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RETURN WORK PLAN TO:"]
[null,"Project Plan Transmittal:"]
[null,"Work Plan Due:"]
[null,"Work Plan Returned:"]
[null,"UC Meeting for Shared Utility Space Complete By:"]
[null,"(if applicable)"]
[]
[]
[null,"1.","Does the OWNER listed above have utility facilities within the limits of the project plan?\nSelect one of the following options."]
[]
[]
[]
[]
[]
[]
[null,"2.","Are the OWNER's existing utility facilities shown correctly and completely in the project plan? It is not necessary to address any existing utility facilities that are not depicted in areas where the project plan will not affect the existing utility facilities.\nSelect one of the following options."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3.","Does the OWNER listed above have any existing known discontinued utility facilities within the limits of the project plan? Do not include utility facilities that will be discontinued as part of the OWNER's work plan.\nSelect one of the following options."]
[]
[]
[]
[]
[null,"4.","Will any utility work associated with the project plan involve grant funding?\nSelect one of the following options."]
[]
[null,null,null,"Select all that apply"]
[]
[]
[]
[]
[]
[]
[null,null,"Review the project plan for conflicts between the highway plan(s) and the OWNER's utility facilties. Complete the Anticipated Conflicts table. After the utility conflicts are reviewed in entirety, select only the options that were included in the Anticipated Conflicts table.\nSelect all that apply.",{"$f":"IF(COUNTIF('Anticipated Conflicts'!O:S,\"ü\")>0,\" ( Note: the following have been identified in the AC table: \" & IF(COUNTIF('Anticipated Conflicts'!O:O,\"ü\")>0,\"5A \",\"\") & IF(COUNTIF('Anticipated Conflicts'!P:P,\"ü\")>0,\"5D \",\"\") & IF(COUNTIF('Anticipated Conflicts'!Q:Q,\"ü\")>0,\"5P \",\"\") & IF(COUNTIF('Anticipated Conflicts'!R:R,\"ü\")>0,\"5R \",\"\") & IF(COUNTIF('Anticipated Conflicts'!S:S,\"ü\")>0,\"5T \",\"\") & \")\",\"\")","v":""}]
[null,"5.",{"$f":"C55&D55","v":"Review the project plan for conflicts between the highway plan(s) and the OWNER's utility facilties. Complete the Anticipated Conflicts table. After the utility conflicts are reviewed in entirety, select only the options that were included in the Anticipated Conflicts table.\nSelect all that apply."}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"HYPERLINK(\"#'Anticipated Conflicts'!A11\", \"Please complete the Anticipated Conflicts table prior to answering question 5.\")","v":"Please complete the Anticipated Conflicts table prior to answering question 5."}]
[]
[null,"6.","Is service work required, including removals, discontinuances, modifications, and/or relocations of existing services, and/or coordination of new service installations?\nSelect all that apply."]
[]
[]
[]
[]
[null,null,{"$f":"SUM(IF(NOT($E$383),0,COUNTIF('A-6N'!R:R,\"Provider\")),IF(NOT($E$253),0,COUNTIF('A-5D'!U:U,\"Provider\")),IF(NOT($E$281),0,COUNTIF('A-5P'!T:T,\"Provider\")),IF(NOT($E$308),0,COUNTIF('A-5R'!AE:AE,\"Provider\")),IF(NOT($E$344),0,COUNTIF('A-5T'!V:V,\"Provider\")))","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(IF(NOT($E$383),0,COUNTIF('A-6N'!R:R,\"Participant\")),IF(NOT($E$253),0,COUNTIF('A-5D'!U:U,\"Participant\")),IF(NOT($E$281),0,COUNTIF('A-5P'!T:T,\"Participant\")),IF(NOT($E$308),0,COUNTIF('A-5R'!AE:AE,\"Participant\")),IF(NOT($E$344),0,COUNTIF('A-5T'!V:V,\"Participant\")))","v":0},null,null,null,null,null,{"$f":"IF(AND(C72>0,L72>0),\" (Note: \" & C72 & \" 'Provider' and \" & L72 & \" 'Participant')\",IF(C72>0,\" (Note: \" &C72& \" 'Provider')\",IF(L72>0,\" (Note: \" &L72& \" 'Participant')\",\"\")))","v":""}]
[null,"7.",{"$f":"\"Is the OWNER's utility work dependent on or affected by shared utility spaces (e.g. shared poles, trenches, conduit packages, etc.)?\" & R72 & \"\nSelect one of the following options.\"","v":"Is the OWNER's utility work dependent on or affected by shared utility spaces (e.g. shared poles, trenches, conduit packages, etc.)?\nSelect one of the following options."}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"8.","Does the OWNER need to obtain approvals and/or permits from other entities to perform the utility work?\nSelect one of the following options."]
[]
[]
[]
[]
[null,"9.","Does the project sponsor need to complete the acquisition of any real estate parcels to enable the OWNER to perform the utility work?\nSelect one of the following options."]
[]
[]
[]
[]
[]
[null,"10.","Does the OWNER need to obtain any easements, fee title, and/or long-term leases to enable the OWNER to perform the utility work?\nSelect one of the following options."]
[]
[]
[]
[]
[null,"11.","Will any of the following affect the OWNER's anticipated start date, schedule, and/or required utility work? Provide relevant information that may or will help prevent utility-related construction delays that will affect highway construction.\nSelect and provide detail for all that apply."]
[null,null,"Subsurface Utility Exploration"]
[]
[]
[null,null,"Inventory, condiiton reports, measurements, or survey of existing features"]
[]
[]
[null,null,"Survey staking by utility"]
[]
[]
[null,null,"Law enforcement activities, such as need for rolling stops"]
[]
[]
[null,null,"Rock blasting and removal"]
[]
[]
[null,null,"Maximum allowable cover over the existing facilities has been exceeded"]
[]
[]
[null,null,"Diversion of staff or contractors due to natural disaster"]
[]
[]
[null,null,"Restricted site access"]
[]
[]
[null,null,"Seasonal constraints"]
[]
[]
[null,null,"Required outage of adjacent powerlines"]
[]
[]
[null,null,"Compliance with provisions of environmental permits"]
[]
[]
[null,null,"Other"]
[]
[]
[]
[]
[null,"12.","Will the OWNER be seeking reimbursement for any of the utility work?\nSelect one of the following options."]
[]
[]
[]
[]
[]
[null,"13.","Provide the name, address, phone number and e-mail address of the field contact person for the project ID(s) so that this information may be included in the highway plan(s)."]
[]
[null,null,"Name:"]
[null,null,"Address:"]
[null,null,"Phone Number:"]
[null,null,"E-mail:"]
[]
[null,"14.","Verify that all of the required attachments have been filled out and that any required inclusion will be submitted with this worksheet. Also provide the name, phone number (including extension), and e-mail address of the person who prepared this worksheet and the date the worksheet was prepared."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,1,"= REQUIRED",null,null,null,null,0,"= NOT REQUIRED"]
[]
[]
[null,null,null,null,null,null,null,"ATTACHMENTS                                                                                 "]
[null,null,null,null,null,null,null,0,{"$f":"IF(Attachment3=1,HYPERLINK(\"#'A-3'!A1\", \"Attachment 3\"),\"Attachment 3\")","v":"Attachment 3"},null,null,null,null,null,null,0,{"$f":"IF(Attachment5T=1,HYPERLINK(\"#'A-5T'!A1\", \"Attachment 5T\"),\"Attachment 5T\")","v":"Attachment 5T"},null,null,null,null,null,null,0,{"$f":"IF(Attachment8=1,HYPERLINK(\"#'A-8'!A1\", \"Attachment 8\"),\"Attachment 8\")","v":"Attachment 8"}]
[null,null,null,null,null,null,null,0,{"$f":"IF(Attachment5A=1,HYPERLINK(\"#'A-5A'!A1\", \"Attachment 5A\"),\"Attachment 5A\")","v":"Attachment 5A"},null,null,null,null,null,null,0,{"$f":"IF(Attachment6E=1,HYPERLINK(\"#'A-6E'!A1\", \"Attachment 6E\"),\"Attachment 6E\")","v":"Attachment 6E"},null,null,null,null,null,null,0,{"$f":"IF(Attachment9=1,HYPERLINK(\"#'A-9'!A1\", \"Attachment 9\"),\"Attachment 9\")","v":"Attachment 9"}]
[null,null,null,null,null,null,null,0,{"$f":"IF(Attachment5D=1,HYPERLINK(\"#'A-5D'!A1\", \"Attachment 5D\"),\"Attachment 5D\")","v":"Attachment 5D"},null,null,null,null,null,null,0,{"$f":"IF(Attachment6N=1,HYPERLINK(\"#'A-6N'!A1\", \"Attachment 6N\"),\"Attachment 6N\")","v":"Attachment 6N"},null,null,null,null,null,null,0,{"$f":"IF(Attachment10=1,HYPERLINK(\"#'A-10'!A1\", \"Attachment 10\"),\"Attachment 10\")","v":"Attachment 10"}]
[null,null,null,null,null,null,null,0,{"$f":"IF(Attachment5P=1,HYPERLINK(\"#'A-5P'!A1\", \"Attachment 5P\"),\"Attachment 5P\")","v":"Attachment 5P"},null,null,null,null,null,null,0,{"$f":"IF(Attachment7PR=1,HYPERLINK(\"#'A-7PR'!A1\", \"Attachment 7PR\"),\"Attachment 7PR\")","v":"Attachment 7PR"}]
[null,null,null,null,null,null,null,0,{"$f":"IF(Attachment5R=1,HYPERLINK(\"#'A-5R'!A1\", \"Attachment 5R\"),\"Attachment 5R\")","v":"Attachment 5R"},null,null,null,null,null,null,0,{"$f":"IF(Attachment7PT=1,HYPERLINK(\"#'A-7PT'!A1\", \"Attachment 7PT\"),\"Attachment 7PT\")","v":"Attachment 7PT"}]
[]
[null,null,null,null,null,null,null,"INCLUSIONS                                                                                      "]
[null,null,null,null,null,null,null,0,"A marked up copy of the project plan"]
[null,null,null,null,null,null,null,null,"showing:"]
[null,null,null,null,null,null,null,null,null,"Corrected existing facilities"]
[null,null,null,null,null,null,null,null,null,"Existing known discontinued facilities"]
[null,null,null,null,null,null,null,null,null,"Adjustments to facilities"]
[null,null,null,null,null,null,null,null,null,"Discontinuations and/or removals of facilities"]
[null,null,null,null,null,null,null,null,null,"Protection of existing facilities"]
[null,null,null,null,null,null,null,null,null,"Relocations, reconstructions, rearrangements, and/or new installations of facilities"]
[null,null,null,null,null,null,null,null,null,"Temporary facilities"]
[null,null,null,null,null,null,null,0,"Sketches and XYZ data, exhibits or work requests"]
[null,null,null,null,null,null,null,null,"showing:"]
[null,null,null,null,null,null,null,null,null,"Corrected existing facilities"]
[null,null,null,null,null,null,null,null,null,"Existing known discontinued facilities"]
[null,null,null,null,null,null,null,null,null,"Adjustments to facilities"]
[null,null,null,null,null,null,null,null,null,"Discontinuations and/or removals of facilities"]
[null,null,null,null,null,null,null,null,null,"Protection of existing facilities"]
[null,null,null,null,null,null,null,null,null,"Relocations, reconstructions, rearrangements, and/or new installations of facilities"]
[null,null,null,null,null,null,null,null,null,"Temporary facilities"]
[null,null,null,null,null,null,null,0,"An electronic design file"]
[null,null,null,null,null,null,null,null,"showing:"]
[null,null,null,null,null,null,null,null,null,"Corrected existing facilities"]
[null,null,null,null,null,null,null,null,null,"Existing known discontinued facilities"]
[null,null,null,null,null,null,null,null,null,"Adjustments to facilities"]
[null,null,null,null,null,null,null,null,null,"Discontinuations and/or removals of facilities"]
[null,null,null,null,null,null,null,null,null,"Protection of existing facilities"]
[null,null,null,null,null,null,null,null,null,"Relocations, reconstructions, rearrangements, and/or new installations of facilities"]
[null,null,null,null,null,null,null,null,null,"Temporary facilities"]
[null,null,null,null,null,null,null,0,"An estimate of cost for reimbursement, from question 12"]
[]
[null,null,"Name:"]
[null,null,"Address:"]
[null,null,"Phone Number:"]
[null,null,"E-mail:"]
[null,null,"Date:"]
[]
[]
[null,"END OF MAIN FORM"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-1,"Error - Requires Attention"]
[null,null,null,null,null,null,"CHECK FOR ERRORS",null,null,null,null,null,null,null,null,null,null,null,0,"Warning - Possibly Incomplete Data"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"No Error"]
[]
[null,null,null,null,true,{"$f":"MIN(F209:F223)","v":-1},"Main Form"]
[null,null,null,null,null,{"$f":"IF(Q15=\"\",-1,1)","v":-1},{"$f":"F209","v":-1},"Title Block filled out"]
[null,null,null,null,null,{"$f":"IF(LEFT(X210,1)=\"O\",IF(AA210<>0,1,0),IF(X210<>\"\",1,-1))","v":-1},{"$f":"F210","v":-1},"Answered Question 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"Othe\",X210)),C24,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(X211<>\"\",IF(LEFT(X211,3)=\"No \",IF(Y211<>\"\",IF(AND(IF(ISNUMBER(SEARCH(\"electronic\",Y211)),IF(Z211<>\"\",TRUE,FALSE),TRUE),IF(ISNUMBER(SEARCH(\"narrative\",Y211)),IF(AA211<>0,TRUE,FALSE),TRUE),IF(ISNUMBER(SEARCH(\"Other\",Y211)),IF(AB211<>0,TRUE,FALSE),TRUE)),1,-1),-1),1),-1)","v":-1},-1,"Answered Question 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"narrative\",Y211)),D34,\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"Other\",Y211)),D37,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(X212<>\"\",IF(LEFT(X212,1)=\"U\",IF(AA212<>0,1,-1),1),-1)","v":-1},-1,"Answered Question 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"unknown\",X212)),C43,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(X213=\"\",-1,IF(LEFT(X213,1)=\"Y\",IF(Y213=\"\",-1,IF(ISNUMBER(SEARCH(\"Other\",Y213)),IF(AA213=0,-1,1),1)),IF(LEFT(X213,1)=\"U\",IF(AB213=0,-1,1),1)))","v":-1},-1,"Answered Question 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"Other\",Y213)),E51,\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"Unk\",X213)),C53,\"\")","v":""}]
[null,null,null,null,null,{"$f":"MIN(IF(COUNTIF('Anticipated Conflicts'!O:O,\"ü\")>0,IF(AC214<>\"\",1,-1),IF(AC214<>\"\",-1,1)),IF(COUNTIF('Anticipated Conflicts'!P:P,\"ü\")>0,IF(AD214<>\"\",1,-1),IF(AD214<>\"\",-1,1)),IF(COUNTIF('Anticipated Conflicts'!Q:Q,\"ü\")>0,IF(AE214<>\"\",1,-1),IF(AE214<>\"\",-1,1)),IF(COUNTIF('Anticipated Conflicts'!R:R,\"ü\")>0,IF(AF214<>\"\",1,-1),IF(AF214<>\"\",-1,1)),IF(COUNTIF('Anticipated Conflicts'!S:S,\"ü\")>0,IF(AG214<>\"\",1,-1),IF(AG214<>\"\",-1,1)),IF(LEN(_xlfn.CONCAT(AB214:AG214))=0,-1,1))","v":-1},-1,"Answered Question 5"]
[null,null,null,null,null,{"$f":"IF(OR(E372,E383,AA215,Y215),IF(Y215,IF(LEN(Z215)>0,1,-1),1),-1)","v":-1},-1,"Answered Question 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(Y215,C70,\"\")","v":""},false]
[null,null,null,null,null,{"$f":"IF(X216=\"\",-1,IF(LEFT(X216,1)=\"Y\",IF(Y216=\"\",-1,IF(ISNUMBER(SEARCH(\"combination\",Y216)),IF(AND(C72>0,L72>0),1,-1),IF(ISNUMBER(SEARCH(\"participants\",Y216)),IF(AND(L72>0,C72=0),1,-1),IF(AND(L72=0,C72>0),1,-1)))),1))","v":-1},-1,"Answered Question 7"]
[null,null,null,null,null,{"$f":"IF(X217<>\"\",1,-1)","v":-1},-1,"Answered Question 8"]
[null,null,null,null,null,{"$f":"IF(X218<>\"\",1,-1)","v":-1},-1,"Answered Question 9"]
[null,null,null,null,null,{"$f":"IF(X219<>\"\",1,-1)","v":-1},-1,"Answered Question 10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,null,null,{"$f":"IF(W220,1,IF(X220<>\"\",IF(COUNTIF(Y220:AJ220,0)=0*COUNTIF(Y219:AJ219,TRUE),1,-1),-1))","v":-1},-1,"Answered Question 11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,{"$f":"IF(Y219,C100,\"\")","v":""},{"$f":"IF(Z219,C103,\"\")","v":""},{"$f":"IF(AA219,C106,\"\")","v":""},{"$f":"IF(AB219,C109,\"\")","v":""},{"$f":"IF(AC219,C112,\"\")","v":""},{"$f":"IF(AD219,C115,\"\")","v":""},{"$f":"IF(AE219,C118,\"\")","v":""},{"$f":"IF(AF219,C121,\"\")","v":""},{"$f":"IF(AG219,C124,\"\")","v":""},{"$f":"IF(AH219,C127,\"\")","v":""},{"$f":"IF(AI219,C130,\"\")","v":""},{"$f":"IF(AJ219,C133,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(X221<>\"\",1,-1)","v":-1},-1,"Answered Question 12"]
[null,null,null,null,null,{"$f":"IF(COUNTA(H145:AI148)=0,0,IF(COUNTA(H145:AI148)=4,1,0))","v":0},0,"Answered Question 13"]
[null,null,null,null,null,{"$f":"IF(COUNTA(H195:AI199)=0,-1,IF(COUNTA(H195:AI199)=5,IF(AND(AB223,AC223),1,-1),-1))","v":-1},-1,"Answered Question 14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,{"$f":"IF(AD224,'A-3'!$C$43,\"\")","v":""}]
[null,null,null,null,true,{"$f":"MIN(F225)","v":-1},{"$f":"HYPERLINK(\"#'Anticipated Conflicts'!A1\", \"Anticipated Conflicts\")","v":"Anticipated Conflicts"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false]
[null,null,null,null,null,-1,{"$f":"F225","v":-1},"All conflict statuses determined & checkbox checked",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA226,'A-3'!$D$19,\"\")","v":""},{"$f":"IF(AB226,'A-3'!$D$22,\"\")","v":""},{"$f":"IF(AC226,'A-3'!$D$25,\"\")","v":""},false,false,false,false,false]
[null,null,null,null,false,{"$f":"IF(E226,MIN(F227:F230),1)","v":1},{"$f":"HYPERLINK(\"#'A-3'!A1\", \"Attachment 3\")","v":"Attachment 3"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false]
[null,null,null,null,null,{"$f":"IF(COUNTIF(Z227:AC227,TRUE)=0,-1,IF(AC227,1,IF(OR(Z227:AB227),IF(COUNTIF(Z224:AD224,TRUE)=0,-1,IF(AND(AB224,COUNTIF(AD225:AH225,TRUE)=0),-1,IF(AND(AC224,AC223=0),-1,IF(AND(AD224,AD223=0),-1,IF(AA227,IF(COUNTIF(AA226:AD226,TRUE)=0,-1,IF(AND(AA226,AA225=0),-1,IF(AND(AB226,AB225=0),-1,IF(AND(AC226,AC225=0),-1,1)))),1))))),IF(AA227,IF(COUNTIF(AA226:AD226,TRUE)=0,-1,IF(AND(AA226,AA225=0),-1,IF(AND(AB226,AB225=0),-1,IF(AND(AC226,AC225=0),-1,1)))),-1))))","v":-1},{"$f":"F227","v":-1},"Answered Question 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rough grading complete.Any excavation above the existing discontinued utility facilites, that are to be removed, has been completed.//Rough grading complete./Any excavation above the existing discontinued utility facilites, that are to be removed, has been completed.",false,false,false,false]
[null,null,null,null,null,{"$f":"IF(X228=\"\",-1,IF(LEFT(X228,1)=\"Y\",IF(AA228=0,-1,1),IF(LEFT(X228,1)=\"U\",IF(AB228=0,-1,1),1)))","v":-1},{"$f":"F228","v":-1},"Answered Question 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"Yes\",X228)),'A-3'!$C$50,\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"Unk\",X228)),'A-3'!$C$55,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(X229=\"\",-1,IF(AA229=0,-1,1))","v":-1},{"$f":"F229","v":-1},"Answered Question 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"Other\",X229)),'A-3'!C63,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(X230=\"\",-1,IF(LEFT(X230,1)=\"Y\",IF(AA230=0,-1,1),IF(LEFT(X230,1)=\"U\",IF(AB230=0,-1,1),1)))","v":-1},{"$f":"F230","v":-1},"Answered Question 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"Yes\",X230)),'A-3'!$C$68,\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"Unk\",X230)),'A-3'!$C$72,\"\")","v":""}]
[null,null,null,null,false,{"$f":"IF(E231,MIN(F232:F252),1)","v":1},{"$f":"HYPERLINK(\"#'A-5A'!A1\", \"Attachment 5A\")","v":"Attachment 5A"}]
[null,null,null,null,null,{"$f":"IF(COUNTIF('Anticipated Conflicts'!O:O,\"ü\")=COUNT('A-5A'!A:A),1,-1)","v":1},{"$f":"F232","v":1},"Number of Identified Conflicts Match Number of Imported Conflicts In Table"]
[null,null,null,null,null,{"$f":"MIN(F234:F248)","v":-1},{"$f":"F233","v":-1},"Table filled out"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5A'!B18:B\" & (MATCH(\"X\",'A-5A'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5A'!A1:A447,0)-2-17),1,-1)","v":-1},null,{"$f":"F234","v":-1},"ALIGNMENT"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5A'!C18:C\" & (MATCH(\"X\",'A-5A'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5A'!A1:A447,0)-2-17),1,-1)","v":-1},null,{"$f":"F235","v":-1},"START STATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5A'!D18:D\" & (MATCH(\"X\",'A-5A'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5A'!A1:A447,0)-2-17),1,-1)","v":-1},null,-1,"START OFFSET DISTANCE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5A'!E18:E\" & (MATCH(\"X\",'A-5A'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5A'!A1:A447,0)-2-17),1,-1)","v":-1},null,-1,"START OFFSET LOCATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5A'!F18:F\" & (MATCH(\"X\",'A-5A'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5A'!A1:A447,0)-2-17),1,0)","v":0},null,{"$f":"F238","v":0},"END STATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5A'!G18:G\" & (MATCH(\"X\",'A-5A'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5A'!A1:A447,0)-2-17),1,0)","v":0},null,0,"END OFFSET DISTANCE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5A'!H18:H\" & (MATCH(\"X\",'A-5A'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5A'!A1:A447,0)-2-17),1,0)","v":0},null,0,"END OFFSET LOCATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5A'!I18:I\" & (MATCH(\"X\",'A-5A'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5A'!A1:A447,0)-2-17),1,-1)","v":-1},null,-1,"OH/UG"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5A'!J18:J\" & (MATCH(\"X\",'A-5A'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5A'!A1:A447,0)-2-17),1,0)","v":0},null,0,"FACILITY SIZE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5A'!K18:K\" & (MATCH(\"X\",'A-5A'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5A'!A1:A447,0)-2-17),1,-1)","v":-1},null,-1,"FACILITY COMPONENT"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5A'!L18:L\" & (MATCH(\"X\",'A-5A'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5A'!A1:A447,0)-2-17),1,0)","v":0},null,0,"FACILITY MATERIAL"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5A'!M18:M\" & (MATCH(\"X\",'A-5A'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5A'!A1:A447,0)-2-17),1,-1)","v":-1},null,-1,"CONFLICT / REASON FOR WORK"]
[null,null,null,null,null,{"$f":"IF(AB246,1,IF((COUNTA(INDIRECT(\"'A-5A'!N18:N\" & (MATCH(\"X\",'A-5A'!A1:A447,0)-2)))+COUNTA(INDIRECT(\"'A-5A'!O18:O\" & (MATCH(\"X\",'A-5A'!A1:A447,0)-2))))=(MATCH(\"X\",'A-5A'!A1:A447,0)-2-17),IF(COUNTA(INDIRECT(\"'A-5A'!O18:O\" & (MATCH(\"X\",'A-5A'!A1:A447,0)-2)))=COUNTA(INDIRECT(\"'A-5A'!P18:P\" & (MATCH(\"X\",'A-5A'!A1:A447,0)-2))),1,-1),-1))","v":-1},null,-1,"ANTICIPATED START DATE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5A'!Q18:Q\" & (MATCH(\"X\",'A-5A'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5A'!A1:A447,0)-2-17),1,-1)","v":-1},null,-1,"WORKING DAYS TO PERFORM"]
[null,null,null,null,null,{"$f":"IF(AND(IF(ISNUMBER(SEARCH(\"both\",X249)),IF(COUNTIF(INDIRECT(\"'A-5A'!R18:R\" & (MATCH(\"X\",'A-5A'!A1:A447,0)-2)),\"*OWNER*\") + COUNTIF(INDIRECT(\"'A-5A'!R18:R\" & (MATCH(\"X\",'A-5A'!A1:A447,0)-2)),\"*In Highway Plan*\")=(MATCH(\"X\",'A-5A'!A1:A447,0)-2-17),TRUE,FALSE),TRUE),NOT(SUMPRODUCT((INDIRECT(\"'A-5A'!B18:M\" & (MATCH(\"X\",'A-5A'!A1:A447,0)-2))=\"Other - describe in NARRATIVE\")*(INDIRECT(\"'A-5A'!R18:R\" & (MATCH(\"X\",'A-5A'!A1:A447,0)-2))=\"\"))>0)), 1, -1)","v":1},null,1,"NARRATIVE"]
[null,null,null,null,null,{"$f":"IF(X249<>\"\",1,-1)","v":-1},{"$f":"F249","v":-1},"Answered Question 1"]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"work included\",X249)),1,IF(OR(Z250,AA250,AB250,AC250,AD250),1,-1))","v":-1},{"$f":"F250","v":-1},"Answered Question 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"work included\",X249)),1,IF(X251=\"\",-1,IF(ISNUMBER(SEARCH(\"Yes\",X251)),IF(OR(Z251=\"\",Y251=\"\"),-1,IF(OR(AA251=0,AB251=0),-1,1)),1)))","v":-1},{"$f":"F251","v":-1},"Answered Question 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC251,'A-5A'!$C$48,\"\")","v":""},{"$f":"IF(AD251,'A-5A'!$C$59,\"\")","v":""},false,false]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"work included\",X249)),1,IF(X252=\"\",-1,IF(ISNUMBER(SEARCH(\"electronic\",X252)),IF(Y252=\"\",-1,1),1)))","v":-1},{"$f":"F252","v":-1},"Answered Question 4"]
[null,null,null,null,false,{"$f":"IF(E253,MIN(F254:F280),1)","v":1},{"$f":"HYPERLINK(\"#'A-5D'!A1\", \"Attachment 5D\")","v":"Attachment 5D"}]
[null,null,null,null,null,{"$f":"IF(((COUNTIFS('Anticipated Conflicts'!P:P,\"ü\",'Anticipated Conflicts'!N:N,\"YES\"))+COUNTIFS('Anticipated Conflicts'!P:P,\"ü\",'Anticipated Conflicts'!N:N,\"NO-DISCONTINUE\"))=COUNT('A-5D'!A:A),1,-1)","v":1},{"$f":"F254","v":1},"Number of Identified Conflicts Match Number of Imported Conflicts In Table"]
[null,null,null,null,null,{"$f":"MIN(F256:F274)","v":-1},{"$f":"F255","v":-1},"Table filled out"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5D'!B23:B\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5D'!A1:A447,0)-2-22),1,-1)","v":-1},null,{"$f":"F256","v":-1},"ALIGNMENT"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5D'!C23:C\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5D'!A1:A447,0)-2-22),1,-1)","v":-1},null,{"$f":"F257","v":-1},"START STATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5D'!D23:D\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5D'!A1:A447,0)-2-22),1,-1)","v":-1},null,-1,"START OFFSET DISTANCE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5D'!E23:E\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5D'!A1:A447,0)-2-22),1,-1)","v":-1},null,-1,"START OFFSET LOCATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5D'!F23:F\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5D'!A1:A447,0)-2-22),1,0)","v":0},null,0,"END STATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5D'!G23:G\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5D'!A1:A447,0)-2-22),1,0)","v":0},null,0,"END OFFSET DISTANCE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5D'!H23:H\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5D'!A1:A447,0)-2-22),1,0)","v":0},null,0,"END OFFSET LOCATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5D'!I23:I\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5D'!A1:A447,0)-2-22),1,-1)","v":-1},null,-1,"OH/UG"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5D'!J23:J\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5D'!A1:A447,0)-2-22),1,0)","v":0},null,0,"FACILITY SIZE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5D'!K23:K\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5D'!A1:A447,0)-2-22),1,-1)","v":-1},null,-1,"FACILITY COMPONENT"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5D'!L23:L\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5D'!A1:A447,0)-2-22),1,0)","v":0},null,0,"FACILITY MATERIAL"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5D'!M23:M\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5D'!A1:A447,0)-2-22),1,-1)","v":-1},null,-1,"CONFLICT / REASON FOR WORK"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5D'!N23:N\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5D'!A1:A447,0)-2-22),1,-1)","v":-1},null,-1,"UTILITY WORK PERFORMED"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5D'!O23:O\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5D'!A1:A447,0)-2-22),1,-1)","v":-1},null,-1,"REMOVAL BY"]
[null,null,null,null,null,{"$f":"IF((COUNTA(INDIRECT(\"'A-5D'!P23:P\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2)))+COUNTA(INDIRECT(\"'A-5D'!Q23:Q\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2))))=(MATCH(\"X\",'A-5D'!A1:A447,0)-2-22),IF(COUNTA(INDIRECT(\"'A-5D'!Q23:Q\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2)))=COUNTA(INDIRECT(\"'A-5D'!R23:R\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2))),1,-1),-1)","v":-1},null,-1,"ANTICIPATED START DATE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5D'!S23:S\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5D'!A1:A447,0)-2-22),1,-1)","v":-1},null,-1,"WORKING DAYS TO PERFORM"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5D'!T23:T\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5D'!A1:A447,0)-2-22),1,-1)","v":-1},null,{"$f":"F272","v":-1},"COORDINATION OF A SHARED UTILITY SPACE"]
[null,null,null,null,null,{"$f":"IF(COUNTIF(INDIRECT(\"'A-5D'!T23:T\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2)),\"Yes\")=COUNTA(INDIRECT(\"'A-5D'!U23:U\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2))),1,-1)","v":1},null,null,{"$f":"F273","v":1},"PROVIDER OR PARTICIPANT"]
[null,null,null,null,null,{"$f":"IF(\n  AND(\n    IF(\n      ISNUMBER(SEARCH(\"both\", X277)),\n      IF(\n        COUNTIF(INDIRECT(\"'A-5D'!W23:W\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2)),\"*OWNER*\")\n        + COUNTIF(INDIRECT(\"'A-5D'!W23:W\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2)),\"*In Highway Plan*\")\n        = (MATCH(\"X\",'A-5D'!A1:A447,0)-2-22),\n        TRUE,\n        FALSE\n      ),\n      TRUE\n    ),\n    NOT(\n      SUMPRODUCT(\n        (INDIRECT(\"'A-5D'!B23:U\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2))=\"Other - describe in NARRATIVE\")*\n        (INDIRECT(\"'A-5D'!W23:W\" & (MATCH(\"X\",'A-5D'!A1:A447,0)-2))=\"\")\n      )>0\n    )\n  ),\n  1,\n  -1\n)","v":1},null,{"$f":"F274","v":1},"NARRATIVE"]
[null,null,null,null,null,{"$f":"IF(X275=\"\",-1,IF(LEFT(X275,1)=\"N\",1,IF(LEFT(X275,1)=\"Y\",IF(AA275=0,-1,1),IF(LEFT(X275,1)=\"U\",IF(AB275=0,-1,1)))))","v":-1},{"$f":"F275","v":-1},"Answered Question 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"Yes\",X275)),'A-5D'!$C$31,\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"Unknown\",X275)),'A-5D'!$C$36,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(X276=\"\",-1,IF(LEFT(X276,1)=\"N\",1,IF(LEFT(X276,1)=\"Y\",IF(AA276=0,-1,1),IF(LEFT(X276,1)=\"U\",IF(AB276=0,-1,1)))))","v":-1},-1,"Answered Question 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"Yes\",X276)),'A-5D'!$C$43,\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"Unknown\",X276)),'A-5D'!$C$48,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(X277<>\"\",1,-1)","v":-1},-1,"Answered Question 3"]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"work included\",X277)),1,IF(OR(Z278,AA278,AB278,AC278,AD278),1,-1))","v":-1},-1,"Answered Question 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"work included\",X277)),1,IF(X279=\"\",-1,IF(ISNUMBER(SEARCH(\"Yes\",X279)),IF(OR(Z279=\"\",Y279=\"\"),-1,IF(OR(AA279=0,AB279=0),-1,1)),1)))","v":-1},-1,"Answered Question 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC279,'A-5D'!$C$77,\"\")","v":""},{"$f":"IF(AD279,'A-5D'!$C$88,\"\")","v":""},false,false]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"work included\",X277)),1,IF(X280=\"\",-1,IF(ISNUMBER(SEARCH(\"electronic\",X280)),IF(Y280=\"\",-1,1),1)))","v":-1},-1,"Answered Question 6"]
[null,null,null,null,false,{"$f":"IF(E281,MIN(F282:F307),1)","v":1},{"$f":"HYPERLINK(\"#'A-5P'!A1\", \"Attachment 5P\")","v":"Attachment 5P"}]
[null,null,null,null,null,{"$f":"IF(COUNTIF('Anticipated Conflicts'!Q:Q,\"ü\")=COUNT('A-5P'!A:A),1,-1)","v":1},{"$f":"F282","v":1},"Number of Identified Conflicts Match Number of Imported Conflicts In Table"]
[null,null,null,null,null,{"$f":"MIN(F284:F303)","v":-1},{"$f":"F283","v":-1},"Table filled out"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5P'!B18:B\" & (MATCH(\"X\",'A-5P'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5P'!A1:A447,0)-2-17),1,-1)","v":-1},null,{"$f":"F284","v":-1},"ALIGNMENT"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5P'!C18:C\" & (MATCH(\"X\",'A-5P'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5P'!A1:A447,0)-2-17),1,-1)","v":-1},null,{"$f":"F285","v":-1},"START STATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5P'!D18:D\" & (MATCH(\"X\",'A-5P'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5P'!A1:A447,0)-2-17),1,-1)","v":-1},null,-1,"START OFFSET DISTANCE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5P'!E18:E\" & (MATCH(\"X\",'A-5P'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5P'!A1:A447,0)-2-17),1,-1)","v":-1},null,-1,"START OFFSET LOCATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5P'!F18:F\" & (MATCH(\"X\",'A-5P'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5P'!A1:A447,0)-2-17),1,0)","v":0},null,0,"END STATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5P'!G18:G\" & (MATCH(\"X\",'A-5P'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5P'!A1:A447,0)-2-17),1,0)","v":0},null,0,"END OFFSET DISTANCE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5P'!H18:H\" & (MATCH(\"X\",'A-5P'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5P'!A1:A447,0)-2-17),1,0)","v":0},null,0,"END OFFSET LOCATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5P'!I18:I\" & (MATCH(\"X\",'A-5P'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5P'!A1:A447,0)-2-17),1,-1)","v":-1},null,-1,"OH/UG"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5P'!J18:J\" & (MATCH(\"X\",'A-5P'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5P'!A1:A447,0)-2-17),1,0)","v":0},null,0,"FACILITY SIZE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5P'!K18:K\" & (MATCH(\"X\",'A-5P'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5P'!A1:A447,0)-2-17),1,-1)","v":-1},null,-1,"FACILITY COMPONENT"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5P'!L18:L\" & (MATCH(\"X\",'A-5P'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5P'!A1:A447,0)-2-17),1,0)","v":0},null,0,"FACILITY MATERIAL"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5P'!M18:M\" & (MATCH(\"X\",'A-5P'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5P'!A1:A447,0)-2-17),1,-1)","v":-1},null,-1,"CONFLICT / REASON FOR WORK"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5P'!N18:N\" & (MATCH(\"X\",'A-5P'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5P'!A1:A447,0)-2-17),1,-1)","v":-1},null,-1,"PROTECTION TYPE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5P'!O18:O\" & (MATCH(\"X\",'A-5P'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5P'!A1:A447,0)-2-17),1,-1)","v":-1},null,-1,"PROJECT STAGE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5P'!P18:P\" & (MATCH(\"X\",'A-5P'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5P'!A1:A447,0)-2-17),1,-1)","v":-1},null,-1,"HIGHWAY CONTRACT WORK COMPLETED"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5P'!Q18:Q\" & (MATCH(\"X\",'A-5P'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5P'!A1:A447,0)-2-17),1,-1)","v":-1},null,-1,"WORKING DAYS TO PERFORM"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5P'!R18:R\" & (MATCH(\"X\",'A-5P'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5P'!A1:A447,0)-2-17),1,-1)","v":-1},null,-1,"SPECS FOR CONTRACT DOCS"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5P'!S18:S\" & (MATCH(\"X\",'A-5P'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5P'!A1:A447,0)-2-17),1,-1)","v":-1},null,-1,"COORDINATION OF A SHARED UTILITY SPACE"]
[null,null,null,null,null,{"$f":"IF(COUNTIF(INDIRECT(\"'A-5P'!S23:S\" & (MATCH(\"X\",'A-5P'!A1:A447,0)-2)),\"Yes\")=COUNTA(INDIRECT(\"'A-5P'!T23:T\" & (MATCH(\"X\",'A-5P'!A1:A447,0)-2))),1,-1)","v":1},null,null,{"$f":"F302","v":1},"PROVIDER OR PARTICIPANT"]
[null,null,null,null,null,{"$f":"IF(\n  AND(\n    IF(\n      ISNUMBER(SEARCH(\"both\", X304)),\n      IF(\n        COUNTIF(INDIRECT(\"'A-5P'!V18:V\" & (MATCH(\"X\",'A-5P'!A1:A447,0)-2)),\"*OWNER*\")\n        + COUNTIF(INDIRECT(\"'A-5P'!V18:V\" & (MATCH(\"X\",'A-5P'!A1:A447,0)-2)),\"*In Highway Plan*\")\n        = (MATCH(\"X\",'A-5P'!A1:A447,0)-2-17),\n        TRUE,\n        FALSE\n      ),\n      TRUE\n    ),\n    NOT(\n      SUMPRODUCT(\n        (INDIRECT(\"'A-5P'!B18:T\" & (MATCH(\"X\",'A-5P'!A1:A447,0)-2))=\"Other - describe in NARRATIVE\")*\n        (INDIRECT(\"'A-5P'!V18:V\" & (MATCH(\"X\",'A-5P'!A1:A447,0)-2))=\"\")\n      )>0\n    )\n  ),\n  1,\n  -1\n)","v":1},null,1,"NARRATIVE"]
[null,null,null,null,null,{"$f":"IF(X304<>\"\",1,-1)","v":-1},{"$f":"F304","v":-1},"Answered Question 1"]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"work included\",X304)),1,IF(OR(Z305,AA305,AB305,AC305,AD305),1,-1))","v":-1},{"$f":"F305","v":-1},"Answered Question 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"work included\",X304)),1,IF(X306=\"\",-1,IF(ISNUMBER(SEARCH(\"Yes\",X306)),IF(OR(Z306=\"\",Y306=\"\"),-1,IF(OR(AA306=0,AB306=0),-1,1)),1)))","v":-1},-1,"Answered Question 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC306,'A-5P'!$C$47,\"\")","v":""},{"$f":"IF(AD306,'A-5P'!$C$58,\"\")","v":""},false,false]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"work included\",X304)),1,IF(X307=\"\",-1,IF(ISNUMBER(SEARCH(\"electronic\",X307)),IF(Y307=\"\",-1,1),1)))","v":-1},-1,"Answered Question 4"]
[null,null,null,null,false,{"$f":"IF(E308,MIN(F309:F343),1)","v":1},{"$f":"HYPERLINK(\"#'A-5R'!A1\", \"Attachment 5R\")","v":"Attachment 5R"}]
[null,null,null,null,null,{"$f":"IF(COUNTIF('Anticipated Conflicts'!R:R,\"ü\")=COUNT('A-5R'!A:A),1,-1)","v":1},{"$f":"F309","v":1},"Number of Identified Conflicts Match Number of Imported Conflicts In Table"]
[null,null,null,null,null,{"$f":"MIN(F311:F339)","v":-1},{"$f":"F310","v":-1},"Table filled out"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!B18:B\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,-1)","v":-1},null,{"$f":"F311","v":-1},"ALIGNMENT"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!C18:C\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,-1)","v":-1},null,{"$f":"F312","v":-1},"EX START STATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!D18:D\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,-1)","v":-1},null,-1,"EX START OFFSET DISTANCE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!E18:E\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,-1)","v":-1},null,-1,"EX START OFFSET LOCATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!F18:F\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,0)","v":0},null,0,"EX END STATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!G18:G\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,0)","v":0},null,0,"EX END OFFSET DISTANCE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!H18:H\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,0)","v":0},null,0,"EX END OFFSET LOCATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!I18:I\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,-1)","v":-1},null,-1,"PR START STATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!J18:J\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,-1)","v":-1},null,-1,"PR START OFFSET DISTANCE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!K18:K\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,-1)","v":-1},null,-1,"PR START OFFSET LOCATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!L18:L\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,0)","v":0},null,0,"PR END STATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!M18:M\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,0)","v":0},null,0,"PR END OFFSET DISTANCE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!N18:N\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,0)","v":0},null,0,"PR END OFFSET LOCATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!O18:O\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,-1)","v":-1},null,-1,"EX OH/UG"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!P18:P\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,-1)","v":-1},null,-1,"PR OH/UG"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!Q18:Q\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,0)","v":0},null,0,"EX FACILITY SIZE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!R18:R\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,0)","v":0},null,0,"PR FACILITY SIZE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!S18:S\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,-1)","v":-1},null,-1,"EX FACILITY COMPONENT"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!T18:T\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,-1)","v":-1},null,-1,"PR FACILITY COMPONENT"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!U18:U\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,0)","v":0},null,0,"EX FACILITY MATERIAL"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!V18:V\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,0)","v":0},null,0,"PR FACILITY MATERIAL"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!W18:W\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,-1)","v":-1},null,-1,"CONFLICT / REASON FOR WORK"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!X18:X\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,-1)","v":-1},null,-1,"UTILITY WORK PERFORMED"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!Y18:Y\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,-1)","v":-1},null,-1,"DISCONTINUED OR REMOVED"]
[null,null,null,null,null,{"$f":"IF((COUNTA(INDIRECT(\"'A-5R'!Z18:Z\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))+COUNTA(INDIRECT(\"'A-5R'!AA18:AA\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2))))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),IF(COUNTA(INDIRECT(\"'A-5R'!AA18:AA\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=COUNTA(INDIRECT(\"'A-5R'!AB18:AB\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2))),1,-1),-1)","v":-1},null,-1,"ANTICIPATED START DATE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!AC18:AC\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,-1)","v":-1},null,-1,"WORKING DAYS TO PERFORM"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5R'!AD18:AD\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)))=(MATCH(\"X\",'A-5R'!A1:A406,0)-2-17),1,-1)","v":-1},null,-1,"COORDINATION OF A SHARED UTILITY SPACE"]
[null,null,null,null,null,{"$f":"IF(COUNTIF(INDIRECT(\"'A-5R'!AD23:AD\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2)),\"Yes\")=COUNTA(INDIRECT(\"'A-5R'!AE23:AE\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2))),1,-1)","v":1},null,null,{"$f":"F338","v":1},"PROVIDER OR PARTICIPANT"]
[null,null,null,null,null,{"$f":"IF(\n  AND(\n    IF(\n      ISNUMBER(SEARCH(\"both\", X340)),\n      IF(\n        COUNTIF(INDIRECT(\"'A-5R'!AG18:AG\" & (MATCH(\"X\",'A-5R'!A1:A447,0)-2)),\"*OWNER*\")\n        + COUNTIF(INDIRECT(\"'A-5R'!AG18:AG\" & (MATCH(\"X\",'A-5R'!A1:A447,0)-2)),\"*In Highway Plan*\")\n        = (MATCH(\"X\",'A-5R'!A1:A447,0)-2-17),\n        TRUE,\n        FALSE\n      ),\n      TRUE\n    ),\n    NOT(\n      SUMPRODUCT(\n        (INDIRECT(\"'A-5R'!B18:AE\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2))=\"Other - describe in NARRATIVE\")*\n        (INDIRECT(\"'A-5R'!AG18:AG\" & (MATCH(\"X\",'A-5R'!A1:A406,0)-2))=\"\")\n      )>0\n    )\n  ),\n  1,\n  -1\n)","v":1},null,1,"NARRATIVE"]
[null,null,null,null,null,{"$f":"IF(X340<>\"\",1,-1)","v":-1},{"$f":"F340","v":-1},"Answered Question 1"]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"work included\",X340)),1,IF(OR(Z341,AA341,AB341,AC341,AD341),1,-1))","v":-1},{"$f":"F341","v":-1},"Answered Question 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"work included\",X340)),1,IF(X342=\"\",-1,IF(ISNUMBER(SEARCH(\"Yes\",X342)),IF(OR(Z342=\"\",Y342=\"\"),-1,IF(OR(AA342=0,AB342=0),-1,1)),1)))","v":-1},{"$f":"F342","v":-1},"Answered Question 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC342,'A-5R'!$C$47,\"\")","v":""},{"$f":"IF(AD342,'A-5R'!$C$58,\"\")","v":""},false,false]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"work included\",X340)),1,IF(X343=\"\",-1,IF(ISNUMBER(SEARCH(\"electronic\",X343)),IF(Y343=\"\",-1,1),1)))","v":-1},{"$f":"F343","v":-1},"Answered Question 4"]
[null,null,null,null,false,{"$f":"IF(E344,MIN(F345:F371),1)","v":1},{"$f":"HYPERLINK(\"#'A-5T'!A1\", \"Attachment 5T\")","v":"Attachment 5T"}]
[null,null,null,null,null,{"$f":"IF(COUNTIF('Anticipated Conflicts'!S:S,\"ü\")=COUNT('A-5T'!A:A)/2,1,-1)","v":1},{"$f":"F345","v":1},"Number of Identified Conflicts Match Number of Imported Conflicts In Table"]
[null,null,null,null,null,{"$f":"MIN(F347:F366)","v":-1},{"$f":"F346","v":-1},"Table filled out"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5T'!B17:B\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5T'!A1:A447,0)-2-16),1,-1)","v":-1},null,{"$f":"F347","v":-1},"ALIGNMENT"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5T'!C17:C\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5T'!A1:A447,0)-2-16),1,-1)","v":-1},null,{"$f":"F348","v":-1},"START STATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5T'!D17:D\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5T'!A1:A447,0)-2-16),1,-1)","v":-1},null,-1,"START OFFSET DISTANCE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5T'!E17:E\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5T'!A1:A447,0)-2-16),1,-1)","v":-1},null,-1,"START OFFSET LOCATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5T'!F17:F\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5T'!A1:A447,0)-2-16),1,0)","v":0},null,0,"END STATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5T'!G17:G\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5T'!A1:A447,0)-2-16),1,0)","v":0},null,0,"END OFFSET DISTANCE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5T'!H17:H\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5T'!A1:A447,0)-2-16),1,0)","v":0},null,0,"END OFFSET LOCATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5T'!I17:I\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5T'!A1:A447,0)-2-16),1,-1)","v":-1},null,-1,"OH/UG"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5T'!J17:J\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5T'!A1:A447,0)-2-16),1,0)","v":0},null,0,"FACILITY SIZE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5T'!K17:K\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5T'!A1:A447,0)-2-16),1,-1)","v":-1},null,-1,"FACILITY COMPONENT"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5T'!L17:L\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5T'!A1:A447,0)-2-16),1,0)","v":0},null,0,"FACILITY MATERIAL"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5T'!M17:M\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5T'!A1:A447,0)-2-16),1,-1)","v":-1},null,-1,"CONFLICT / REASON FOR WORK"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5T'!N17:N\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5T'!A1:A447,0)-2-16),1,-1)","v":-1},null,-1,"INSTALL / REMOVE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5T'!O17:O\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5T'!A1:A447,0)-2-16),1,-1)","v":-1},null,-1,"UTILITY WORK PERFORMED"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5T'!P17:P\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5T'!A1:A447,0)-2-16),1,-1)","v":-1},null,-1,"TEMPORARY EASEMENTS, PERMISSIONS, ACCESS"]
[null,null,null,null,null,{"$f":"IF((COUNTA(INDIRECT(\"'A-5T'!Q17:Q\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2)))+COUNTA(INDIRECT(\"'A-5T'!R17:R\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2))))=(MATCH(\"X\",'A-5T'!A1:A447,0)-2-16),IF(COUNTA(INDIRECT(\"'A-5T'!R17:R\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2)))=COUNTA(INDIRECT(\"'A-5T'!S17:S\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2))),1,-1),-1)","v":-1},null,-1,"ANTICIPATED START DATE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5T'!T17:T\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5T'!A1:A447,0)-2-16),1,-1)","v":-1},null,-1,"WORKING DAYS TO PERFORM"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-5T'!U17:U\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2)))=(MATCH(\"X\",'A-5T'!A1:A447,0)-2-16),1,-1)","v":-1},null,-1,"COORDINATION OF A SHARED UTILITY SPACE"]
[null,null,null,null,null,{"$f":"IF(COUNTIF(INDIRECT(\"'A-5T'!U23:U\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2)),\"Yes\")=COUNTA(INDIRECT(\"'A-5T'!V23:V\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2))),1,-1)","v":1},null,null,{"$f":"F365","v":1},"PROVIDER OR PARTICIPANT"]
[null,null,null,null,null,{"$f":"IF(\n  AND(\n    IF(\n      ISNUMBER(SEARCH(\"both\", X368)),\n      IF(\n        COUNTIF(INDIRECT(\"'A-5T'!X17:X\" & (MATCH(\"X\",'A-5T'!A1:A446,0)-2)),\"*OWNER*\")\n        + COUNTIF(INDIRECT(\"'A-5T'!X17:X\" & (MATCH(\"X\",'A-5T'!A1:A446,0)-2)),\"*In Highway Plan*\")\n        = (MATCH(\"X\",'A-5T'!A1:A446,0)-2-16),\n        TRUE,\n        FALSE\n      ),\n      TRUE\n    ),\n    NOT(\n      SUMPRODUCT(\n        (INDIRECT(\"'A-5T'!B17:V\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2))=\"Other - describe in NARRATIVE\")*\n        (INDIRECT(\"'A-5T'!X17:X\" & (MATCH(\"X\",'A-5T'!A1:A447,0)-2))=\"\")\n      )>0\n    )\n  ),\n  1,\n  -1\n)","v":1},null,1,"NARRATIVE"]
[null,null,null,null,null,{"$f":"IF(OR(Z367,AA367,AB367,AC367),IF(AB367,IF(AD367=0,-1,1),1)*1,-1)","v":-1},{"$f":"F367","v":-1},"Answered Question 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,{"$f":"IF(X368<>\"\",1,-1)","v":-1},{"$f":"F368","v":-1},"Answered Question 2"]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"work included\",X368)),1,IF(OR(Z369,AA369,AB369,AC369,AD369),1,-1))","v":-1},{"$f":"F369","v":-1},"Answered Question 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"work included\",X368)),1,IF(X370=\"\",-1,IF(ISNUMBER(SEARCH(\"Yes\",X370)),IF(OR(Z370=\"\",Y370=\"\"),-1,IF(OR(AA370=0,AB370=0),-1,1)),1)))","v":-1},-1,"Answered Question 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC370,'A-5T'!$C$55,\"\")","v":""},{"$f":"IF(AD370,'A-5T'!$C$66,\"\")","v":""},false,false]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"work included\",X368)),1,IF(X371=\"\",-1,IF(ISNUMBER(SEARCH(\"electronic\",X371)),IF(Y371=\"\",-1,1),1)))","v":-1},-1,"Answered Question 5"]
[null,null,null,null,false,{"$f":"IF(E372,MIN(F373:F382),1)","v":1},{"$f":"HYPERLINK(\"#'A-6E'!A1\", \"Attachment 6E\")","v":"Attachment 6E"}]
[null,null,null,null,null,{"$f":"IF(X373<>\"\",IF(LEFT(X373,1)=\"U\",IF(AA373<>0,1,-1),1),-1)","v":-1},{"$f":"F373","v":-1},"Answered Question 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEFT(X373,1)=\"U\",'A-6E'!$C$12,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(X374<>\"\",IF(ISNUMBER(SEARCH(\"Other\",X374)),IF(AA374<>0,1,-1),1),-1)","v":-1},{"$f":"F374","v":-1},"Answered Question 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"Other\",X374)),'A-6E'!$C$25,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(X375=\"\",-1,IF(X375=\"No.\",IF(Y375=\"\",-1,IF(OR(AA375=0,AB375=0,AC375=0),-1,1)),1))","v":-1},-1,"Answered Question 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"Anticipated\",Y375)),'A-6E'!C36,\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"stage\",Y375)),'A-6E'!C40,\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"milestone\",Y375)),'A-6E'!C44,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(X376<>\"\",IF(LEFT(X376,1)=\"Y\",IF(AA376<>0,1,-1),1),-1)","v":-1},-1,"Answered Question 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEFT(X376,1)=\"Y\",'A-6E'!$C$51,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(OR(Z377,AA377,AB377,AC377,AD377,Y377),IF(AC377,IF(AE377=0,-1,1),1),-1)","v":-1},-1,"Answered Question 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,{"$f":"IF(AC377,'A-6E'!$C$63,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"work included\",X373)),1,IF(X378=\"\",-1,IF(ISNUMBER(SEARCH(\"and\",X378)),IF(AA378=0,-1,1),1)))","v":-1},-1,"Answered Question 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"and\",X378)),'A-6E'!$C$72,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"work included\",X373)),1,IF(X379=\"\",-1,IF(ISNUMBER(SEARCH(\"Other\",X379)),IF(AA379=0,-1,1),1)))","v":-1},-1,"Answered Question 7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"Other\",X379)),'A-6E'!$C$81,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"work included\",X373)),1,IF(X380=\"\",-1,IF(LEFT(X380,1)=\"Y\",IF(AA380=0,-1,1),1)))","v":-1},-1,"Answered Question 8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEFT(X380,1)=\"Y\",'A-6E'!$C$87,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"work included\",X373)),1,IF(OR(Z381,AA381,AB381,AC381,Y381),1,-1))","v":-1},-1,"Answered Question 9",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"work included\",X373)),1,IF(X382=\"\",-1,IF(ISNUMBER(SEARCH(\"Yes\",X382)),IF(OR(Z382=\"\",Y382=\"\"),-1,IF(OR(AA382=0,AB382=0),-1,1)),1)))","v":-1},-1,"Answered Question 10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC382,'A-6E'!$D$112,\"\")","v":""},{"$f":"IF(AD382,'A-6E'!$D$123,\"\")","v":""},false,false]
[null,null,null,null,false,{"$f":"IF(E383,MIN(F384:F405),1)","v":1},{"$f":"HYPERLINK(\"#'A-6N'!A1\", \"Attachment 6N\")","v":"Attachment 6N"}]
[null,null,null,null,null,{"$f":"MIN(F385:F400)","v":-1},-1,"Table filled out"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-6N'!B17:B\" & (MATCH(\"X\",'A-6N'!A1:A414,0)-2)))=(MATCH(\"X\",'A-6N'!A1:A414,0)-2-16),1,-1)","v":-1},null,{"$f":"F385","v":-1},"ALIGNMENT"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-6N'!C17:C\" & (MATCH(\"X\",'A-6N'!A1:A414,0)-2)))=(MATCH(\"X\",'A-6N'!A1:A414,0)-2-16),1,-1)","v":-1},null,{"$f":"F386","v":-1},"START STATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-6N'!D17:D\" & (MATCH(\"X\",'A-6N'!A1:A414,0)-2)))=(MATCH(\"X\",'A-6N'!A1:A414,0)-2-16),1,-1)","v":-1},null,-1,"START OFFSET DISTANCE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-6N'!E17:E\" & (MATCH(\"X\",'A-6N'!A1:A414,0)-2)))=(MATCH(\"X\",'A-6N'!A1:A414,0)-2-16),1,-1)","v":-1},null,-1,"START OFFSET LOCATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-6N'!F17:F\" & (MATCH(\"X\",'A-6N'!A1:A414,0)-2)))=(MATCH(\"X\",'A-6N'!A1:A414,0)-2-16),1,0)","v":0},null,0,"END STATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-6N'!G17:G\" & (MATCH(\"X\",'A-6N'!A1:A414,0)-2)))=(MATCH(\"X\",'A-6N'!A1:A414,0)-2-16),1,0)","v":0},null,0,"END OFFSET DISTANCE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-6N'!H17:H\" & (MATCH(\"X\",'A-6N'!A1:A414,0)-2)))=(MATCH(\"X\",'A-6N'!A1:A414,0)-2-16),1,0)","v":0},null,0,"END OFFSET LOCATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-6N'!I17:I\" & (MATCH(\"X\",'A-6N'!A1:A414,0)-2)))=(MATCH(\"X\",'A-6N'!A1:A414,0)-2-16),1,-1)","v":-1},null,-1,"OH/UG"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-6N'!J17:J\" & (MATCH(\"X\",'A-6N'!A1:A414,0)-2)))=(MATCH(\"X\",'A-6N'!A1:A414,0)-2-16),1,0)","v":0},null,0,"FACILITY SIZE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-6N'!K17:K\" & (MATCH(\"X\",'A-6N'!A1:A414,0)-2)))=(MATCH(\"X\",'A-6N'!A1:A414,0)-2-16),1,-1)","v":-1},null,-1,"FACILITY COMPONENT"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-6N'!L17:L\" & (MATCH(\"X\",'A-6N'!A1:A414,0)-2)))=(MATCH(\"X\",'A-6N'!A1:A414,0)-2-16),1,0)","v":0},null,0,"FACILITY MATERIAL"]
[null,null,null,null,null,{"$f":"IF((COUNTA(INDIRECT(\"'A-6N'!M17:M\" & (MATCH(\"X\",'A-6N'!A1:A414,0)-2)))+COUNTA(INDIRECT(\"'A-6N'!N17:N\" & (MATCH(\"X\",'A-6N'!A1:A414,0)-2))))=(MATCH(\"X\",'A-6N'!A1:A414,0)-2-16),IF(COUNTA(INDIRECT(\"'A-6N'!N16:N\" & (MATCH(\"X\",'A-6N'!A1:A414,0)-2)))=COUNTA(INDIRECT(\"'A-6N'!O16:O\" & (MATCH(\"X\",'A-6N'!A1:A414,0)-2))),1,-1),-1)","v":-1},null,-1,"ANTICIPATED START DATE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-6N'!P17:P\" & (MATCH(\"X\",'A-6N'!A1:A414,0)-2)))=(MATCH(\"X\",'A-6N'!A1:A414,0)-2-16),1,-1)","v":-1},null,-1,"WORKING DAYS TO PERFORM"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-6N'!Q17:Q\" & (MATCH(\"X\",'A-6N'!A1:A414,0)-2)))=(MATCH(\"X\",'A-6N'!A1:A414,0)-2-16),1,-1)","v":-1},null,-1,"COORDINATION OF A SHARED UTILITY SPACE"]
[null,null,null,null,null,{"$f":"IF(COUNTIF(INDIRECT(\"'A-6N'!Q17:Q\" & (MATCH(\"X\",'A-6N'!A1:A414,0)-2)),\"Yes\")=COUNTA(INDIRECT(\"'A-6N'!R17:R\" & (MATCH(\"X\",'A-6N'!A1:A414,0)-2))),1,-1)","v":1},null,null,{"$f":"F399","v":1},"PROVIDER OR PARTICIPANT"]
[null,null,null,null,null,{"$f":"IF(\n  AND(\n    IF(\n      ISNUMBER(SEARCH(\"both\", X403)),\n      IF(\n        COUNTIF(INDIRECT(\"'A-6N'!T17:T\" & (MATCH(\"X\",'A-6N'!A1:A459,0)-2)),\"*OWNER*\")\n        + COUNTIF(INDIRECT(\"'A-6N'!T17:T\" & (MATCH(\"X\",'A-6N'!A1:A459,0)-2)),\"*In Highway Plan*\")\n        = (MATCH(\"X\",'A-6N'!A1:A459,0)-2-16),\n        TRUE,\n        FALSE\n      ),\n      TRUE\n    ),\n    NOT(\n      SUMPRODUCT(\n        (INDIRECT(\"'A-6N'!B17:Q\" & (MATCH(\"X\",'A-6N'!A1:A460,0)-2))=\"Other - describe in NARRATIVE\")*\n        (INDIRECT(\"'A-6N'!T17:T\" & (MATCH(\"X\",'A-6N'!A1:A460,0)-2))=\"\")\n      )>0\n    )\n  ),\n  1,\n  -1\n)","v":1},null,1,"NARRATIVE"]
[null,null,null,null,null,{"$f":"IF(OR(Z401,AA401,AB401,AC401,AD401,Y401),IF(AC401,IF(AE401=0,-1,1),1),-1)","v":-1},{"$f":"F401","v":-1},"Answered Question 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,{"$f":"IF(AC401,'A-6N'!$C$30,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(AC402,1,IF(AND(NOT(Y402),NOT(Z402),NOT(AA402),NOT(AB402),NOT(AC402)),-1,IF(COUNTIF(Y402:AB402,TRUE)=0,0,IF(SUMPRODUCT(--(Y402:AB402), --(AD402:AG402=0))>0,-1,1))))","v":-1},{"$f":"F402","v":-1},"Answered Question 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,{"$f":"IF(Y402,'A-6N'!$C$38,\"\")","v":""},{"$f":"IF(Z402,'A-6N'!$C$42,\"\")","v":""},{"$f":"IF(AA402,'A-6N'!$C$46,\"\")","v":""},{"$f":"IF(AB402,'A-6N'!$C$50,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(X403<>\"\",1,-1)","v":-1},{"$f":"F403","v":-1},"Answered Question 3"]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"work included\",X403)),1,IF(OR(Z404,AA404,AB404,AC404,Y404),1,-1))","v":-1},{"$f":"F404","v":-1},"Answered Question 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"work included\",X403)),1,IF(X405=\"\",-1,IF(ISNUMBER(SEARCH(\"Yes\",X405)),IF(OR(Z405=\"\",Y405=\"\"),-1,IF(OR(AA405=0,AB405=0),-1,1)),1)))","v":-1},{"$f":"F405","v":-1},"Answered Question 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC405,'A-6N'!$D$79,\"\")","v":""},{"$f":"IF(AD405,'A-6N'!$D$90,\"\")","v":""},false,false]
[null,null,null,null,false,{"$f":"IF(E406,MIN(F407:F416),1)","v":1},{"$f":"HYPERLINK(\"#'A-7PR'!A1\", \"Attachment 7PR\")","v":"Attachment 7PR"}]
[null,null,null,null,null,{"$f":"IF(SUM(IF((E383),COUNTIFS('A-6N'!Q:Q,\"Yes\",'A-6N'!R:R,\"Provider\"),0),IF((E253),COUNTIFS('A-5D'!T:T,\"Yes\",'A-5D'!U:U,\"Provider\"),0),IF((E281),COUNTIFS('A-5P'!S:S,\"Yes\",'A-5P'!T:T,\"Provider\"),0),IF((E308),COUNTIFS('A-5R'!AD:AD,\"Yes\",'A-5R'!AE:AE,\"Provider\"),0),IF((E344),COUNTIFS('A-5T'!U:U,\"Yes\",'A-5T'!V:V,\"Provider\"),0))=COUNTA('A-7PR'!A:A)-COUNTIF('A-7PR'!A:A,\"X\"),1,-1)","v":1},{"$f":"F407","v":1},"Number of Identified Coordinated Facilities Match Number of Imported Conflicts In Table"]
[null,null,null,null,null,1,{"$f":"F408","v":1},"Utility Work Added"]
[null,null,null,null,null,{"$f":"MIN(F410:F418)","v":-1},{"$f":"F409","v":-1},"Table filled out"]
[null,null,null,null,null,{"$f":"IF(COUNTBLANK(INDIRECT(\"'A-7PR'!B11:B\" & ROW(INDEX('A-7PR'!A1:A401, MAX(IF('A-7PR'!A1:A401=\"X\", ROW('A-7PR'!A1:A401)))))+2))<>(COUNTIF('A-7PR'!A1:A401,\"X\")*9),-1,1)","v":-1},null,{"$f":"F410","v":-1},"COORDINATING ENTITY"]
[null,null,null,null,null,{"$f":"IF(COUNTBLANK(INDIRECT(\"'A-7PR'!C11:C\" & ROW(INDEX('A-7PR'!A1:A401, MAX(IF('A-7PR'!A1:A401=\"X\", ROW('A-7PR'!A1:A401)))))+2))<>(COUNTIF('A-7PR'!A1:A401,\"X\")*11),-1,1)","v":1},null,{"$f":"F411","v":1},"UTILITY TYPE"]
[null,null,null,null,null,{"$f":"IF(COUNTBLANK(INDIRECT(\"'A-7PR'!D11:D\" & ROW(INDEX('A-7PR'!A1:A424, MAX(IF('A-7PR'!A1:A424=\"X\", ROW('A-7PR'!A1:A424)))))+2))<>(COUNTIF('A-7PR'!A1:A424,\"X\")*11),-1,IF(COUNTIF('A-7PR'!D:D,\"No\")>0,-1,1))","v":1},null,{"$f":"F412","v":1},"COORDINATION BETWEEN PROVIDER AND PARTICIPANT COMPLETED"]
[null,null,null,null,null,{"$f":"IF(COUNTBLANK(INDIRECT(\"'A-7PR'!E11:E\" & ROW(INDEX('A-7PR'!A1:A424, MAX(IF('A-7PR'!A1:A424=\"X\", ROW('A-7PR'!A1:A424)))))+2))<>(COUNTIF('A-7PR'!A1:A424,\"X\")*10),-1,1)","v":-1},null,-1,"UTILITY WORK PERFORMED"]
[null,null,null,null,null,{"$f":"IF(COUNTBLANK(INDIRECT(\"'A-7PR'!F11:F\" & ROW(INDEX('A-7PR'!A1:A424, MAX(IF('A-7PR'!A1:A424=\"X\", ROW('A-7PR'!A1:A424)))))+2))<>(COUNTIF('A-7PR'!A1:A424,\"X\")*11),-1,1)","v":1},null,1,"UTILITY WORK PERFORMED BY"]
[null,null,null,null,null,{"$f":"IF(COUNTBLANK(INDIRECT(\"'A-7PR'!G11:G\" & ROW(INDEX('A-7PR'!A1:A424, MAX(IF('A-7PR'!A1:A424=\"X\", ROW('A-7PR'!A1:A424)))))+2))<>(COUNTIF('A-7PR'!A1:A424,\"X\")*11),-1,1)","v":1},null,1,"CONCURRENT WORK POSSIBLE"]
[null,null,null,null,null,{"$f":"IF(COUNTBLANK(INDIRECT(\"'A-7PR'!H11:H\" & ROW(INDEX('A-7PR'!A1:A424, MAX(IF('A-7PR'!A1:A424=\"X\", ROW('A-7PR'!A1:A424)))))+2))<>(COUNTIF('A-7PR'!A1:A424,\"X\")*11),-1,1)","v":1},null,1,"ORDER OF CONSTRUCTION"]
[null,null,null,null,null,{"$f":"IF(OR(IF((COUNTBLANK(INDIRECT(\"'A-7PR'!AD11:AD\" & ROW(INDEX('A-7PR'!A1:A398, MAX(IF('A-7PR'!A1:A398=\"X\", ROW('A-7PR'!A1:A398)))))+2))+COUNTBLANK(INDIRECT(\"'A-7PR'!AE11:AE\"&ROW(INDEX('A-7PR'!A1:A398,MAX(IF('A-7PR'!A1:A398=\"X\",ROW('A-7PR'!A1:A398)))))+2)))=(COUNTIF('A-7PR'!A1:A398,\"X\")*9)+(ROW(INDEX('A-7PR'!A1:A398, MAX(IF('A-7PR'!A1:A398=\"X\", ROW('A-7PR'!A1:A398)))))+2-10-(COUNTIF('A-7PR'!A1:A398,\"X\")*11))+(COUNTIF('A-7PR'!A1:A398,\"X\")*9),TRUE,FALSE),IF((COUNTBLANK(INDIRECT(\"'A-7PR'!AD11:AD\" & ROW(INDEX('A-7PR'!A1:A398, MAX(IF('A-7PR'!A1:A398=\"X\", ROW('A-7PR'!A1:A398)))))+2))+COUNTBLANK(INDIRECT(\"'A-7PR'!AF11:AF\" & ROW(INDEX('A-7PR'!A1:A398, MAX(IF('A-7PR'!A1:A398=\"X\", ROW('A-7PR'!A1:A398)))))+2)))=(COUNTIF('A-7PR'!A1:A398,\"X\")*8)+(ROW(INDEX('A-7PR'!A1:A398, MAX(IF('A-7PR'!A1:A398=\"X\", ROW('A-7PR'!A1:A398)))))+2-10-(COUNTIF('A-7PR'!A1:A398,\"X\")*11))+(COUNTIF('A-7PR'!A1:A398,\"X\")*10),TRUE,FALSE)),IF((COUNTBLANK(INDIRECT(\"'A-7PR'!AE11:AE\"&ROW(INDEX('A-7PR'!A1:A398,MAX(IF('A-7PR'!A1:A398=\"X\",ROW('A-7PR'!A1:A398)))))+2))+COUNTIF('A-7PR'!A1:A398,\"X\"))=COUNTBLANK(INDIRECT(\"'A-7PR'!AF11:AF\" & ROW(INDEX('A-7PR'!A1:A398, MAX(IF('A-7PR'!A1:A398=\"X\", ROW('A-7PR'!A1:A398)))))+2)),1,0),-1)","v":1},null,1,"ANTICIPATED START DATE"]
[null,null,null,null,null,{"$f":"IF(COUNTBLANK(INDIRECT(\"'A-7PR'!AG11:AG\" & ROW(INDEX('A-7PR'!A1:A401, MAX(IF('A-7PR'!A1:A401=\"X\", ROW('A-7PR'!A1:A401)))))+2))<>(COUNTIF('A-7PR'!A1:A401,\"X\")*10),-1,1)","v":-1},null,-1,"WORKING DAYS TO PERFORM"]
[null,null,null,null,null,{"$f":"IF(COUNTBLANK(INDIRECT(\"'A-7PR'!AH11:AH\" & ROW(INDEX('A-7PR'!A1:A401, MAX(IF('A-7PR'!A1:A401=\"X\", ROW('A-7PR'!A1:A401)))))+2))<>(COUNTIF('A-7PR'!A1:A401,\"X\")*11)+COUNTIF('A-7PR'!AD1:AD401,\">1\"),0,0)","v":0},null,0,"STARTING WORKING DAY"]
[null,null,null,null,false,{"$f":"IF(E420,MIN(F421:F442),1)","v":1},{"$f":"HYPERLINK(\"#'A-7PT'!A1\", \"Attachment 7PT\")","v":"Attachment 7PT"}]
[null,null,null,null,null,{"$f":"IF(SUM(IF((E383),COUNTIFS('A-6N'!Q:Q,\"Yes\",'A-6N'!R:R,\"Participant\"),0),IF((E253),COUNTIFS('A-5D'!T:T,\"Yes\",'A-5D'!U:U,\"Participant\"),0),IF((E281),COUNTIFS('A-5P'!S:S,\"Yes\",'A-5P'!T:T,\"Participant\"),0),IF((E308),COUNTIFS('A-5R'!AD:AD,\"Yes\",'A-5R'!AE:AE,\"Participant\"),0),IF((E344),COUNTIFS('A-5T'!U:U,\"Yes\",'A-5T'!V:V,\"Participant\"),0))=COUNTA('A-7PT'!A:A)-COUNTIF('A-7PT'!A:A,\"X\"),1,-1)","v":1},{"$f":"F421","v":1},"Number of Identified Coordinated Facilities Match Number of Imported Conflicts In Table"]
[null,null,null,null,null,{"$f":"MIN(F423:F442)","v":-1},{"$f":"F422","v":-1},"Table filled out"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-7PT'!B15:B\" & (MATCH(\"X\",'A-7PT'!A1:A400,0)-2)))=(MATCH(\"X\",'A-7PT'!A1:A400,0)-2-14),1,-1)","v":-1},null,{"$f":"F423","v":-1},"COORDINATING ENTITY"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-7PT'!C15:C\" & (MATCH(\"X\",'A-7PT'!A1:A400,0)-2)))=(MATCH(\"X\",'A-7PT'!A1:A400,0)-2-14),IF(COUNTIF('A-7PT'!C:C,\"No\")>0,-1,1),-1)","v":-1},null,{"$f":"F424","v":-1},"COORDINATION BETWEEN PROVIDER AND PARTICIPANT COMPLETED"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-7PT'!D15:D\" & (MATCH(\"X\",'A-7PT'!A1:A400,0)-2)))=(MATCH(\"X\",'A-7PT'!A1:A400,0)-2-14),1,-1)","v":-1},null,{"$f":"F425","v":-1},"ALIGNMENT"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-7PT'!E15:E\" & (MATCH(\"X\",'A-7PT'!A1:A400,0)-2)))=(MATCH(\"X\",'A-7PT'!A1:A400,0)-2-14),1,-1)","v":-1},null,-1,"START STATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-7PT'!F15:F\" & (MATCH(\"X\",'A-7PT'!A1:A400,0)-2)))=(MATCH(\"X\",'A-7PT'!A1:A400,0)-2-14),1,-1)","v":-1},null,-1,"START OFFSET DISTANCE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-7PT'!G15:G\" & (MATCH(\"X\",'A-7PT'!A1:A400,0)-2)))=(MATCH(\"X\",'A-7PT'!A1:A400,0)-2-14),1,-1)","v":-1},null,-1,"START OFFSET LOCATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-7PT'!H15:H\" & (MATCH(\"X\",'A-7PT'!A1:A400,0)-2)))=(MATCH(\"X\",'A-7PT'!A1:A400,0)-2-14),1,0)","v":0},null,0,"END STATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-7PT'!I15:I\" & (MATCH(\"X\",'A-7PT'!A1:A400,0)-2)))=(MATCH(\"X\",'A-7PT'!A1:A400,0)-2-14),1,0)","v":0},null,0,"END OFFSET DISTANCE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-7PT'!J15:J\" & (MATCH(\"X\",'A-7PT'!A1:A400,0)-2)))=(MATCH(\"X\",'A-7PT'!A1:A400,0)-2-14),1,0)","v":0},null,0,"END OFFSET LOCATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-7PT'!K15:K\" & (MATCH(\"X\",'A-7PT'!A1:A400,0)-2)))=(MATCH(\"X\",'A-7PT'!A1:A400,0)-2-14),1,-1)","v":-1},null,-1,"OH/UG"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-7PT'!L15:L\" & (MATCH(\"X\",'A-7PT'!A1:A400,0)-2)))=(MATCH(\"X\",'A-7PT'!A1:A400,0)-2-14),1,0)","v":0},null,0,"FACILITY SIZE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-7PT'!M15:M\" & (MATCH(\"X\",'A-7PT'!A1:A400,0)-2)))=(MATCH(\"X\",'A-7PT'!A1:A400,0)-2-14),1,-1)","v":-1},null,-1,"FACILITY COMPONENT"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-7PT'!N15:N\" & (MATCH(\"X\",'A-7PT'!A1:A400,0)-2)))=(MATCH(\"X\",'A-7PT'!A1:A400,0)-2-14),1,0)","v":0},null,0,"FACILITY MATERIAL"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-7PT'!O15:O\" & (MATCH(\"X\",'A-7PT'!A1:A400,0)-2)))=(MATCH(\"X\",'A-7PT'!A1:A400,0)-2-14),1,-1)","v":-1},null,-1,"UTILITY WORK PERFORMED"]
[null,null,null,null,null,{"$f":"IF((COUNTA(INDIRECT(\"'A-7PT'!P15:P\" & (MATCH(\"X\",'A-7PT'!A1:A400,0)-2)))+COUNTA(INDIRECT(\"'A-7PT'!Q15:Q\" & (MATCH(\"X\",'A-7PT'!A1:A400,0)-2))))=(MATCH(\"X\",'A-7PT'!A1:A400,0)-2-14),IF(COUNTA(INDIRECT(\"'A-7PT'!R15:R\" & (MATCH(\"X\",'A-7PT'!A1:A400,0)-2)))=COUNTA(INDIRECT(\"'A-7PT'!Q15:Q\" & (MATCH(\"X\",'A-7PT'!A1:A400,0)-2))),1,-1),-1)","v":-1},null,-1,"ANTICIPATED START DATE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-7PT'!S15:S\" & (MATCH(\"X\",'A-7PT'!A1:A400,0)-2)))=(MATCH(\"X\",'A-7PT'!A1:A400,0)-2-14),1,-1)","v":-1},null,-1,"WORKING DAYS TO PERFORM"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-7PT'!T15:T\" & (MATCH(\"X\",'A-7PT'!A1:A400,0)-2)))=(MATCH(\"X\",'A-7PT'!A1:A400,0)-2-14),1,-1)","v":-1},null,-1,"WORK PERFORMED BY"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-7PT'!U15:U\" & (MATCH(\"X\",'A-7PT'!A1:A400,0)-2)))=(MATCH(\"X\",'A-7PT'!A1:A400,0)-2-14),1,0)","v":0},null,0,"NOTES FOR UCM"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-7PT'!V15:V\" & (MATCH(\"X\",'A-7PT'!A1:A400,0)-2)))=(MATCH(\"X\",'A-7PT'!A1:A400,0)-2-14),1,0)","v":0},null,0,"CONTACT INFO"]
[null,null,null,null,null,{"$f":"IF(SUMPRODUCT((INDIRECT(\"'A-7PT'!B15:V\" & (MATCH(\"X\",'A-7PT'!A1:A400,0)-2))=\"Other - describe in NARRATIVE\")*(INDIRECT(\"'A-7PT'!W15:W\" & (MATCH(\"X\",'A-7PT'!A1:A400,0)-2))=\"\"))>0, -1, 1)","v":1},null,1,"NARRATIVE"]
[null,null,null,null,false,{"$f":"IF(E443,MIN(F444:F448),1)","v":1},{"$f":"HYPERLINK(\"#'A-8'!A1\", \"Attachment 8\")","v":"Attachment 8"}]
[null,null,null,null,null,{"$f":"MIN(F445:F448)","v":-1},{"$f":"F444","v":-1},"Table filled out"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-8'!B20:B\" & (MATCH(\"X\",'A-8'!A1:A400,0)-2)))=(MATCH(\"X\",'A-8'!A1:A400,0)-2-19),1,-1)","v":-1},null,{"$f":"F445","v":-1},"PERMIT"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-8'!C20:C\" & (MATCH(\"X\",'A-8'!A1:A400,0)-2)))=(MATCH(\"X\",'A-8'!A1:A400,0)-2-19),1,-1)","v":-1},null,{"$f":"F446","v":-1},"NAME OF APPROVING AUTHORITY"]
[null,null,null,null,null,{"$f":"IF((COUNTA(INDIRECT(\"'A-8'!D20:D\" & (MATCH(\"X\",'A-8'!A1:A400,0)-2)))+COUNTA(INDIRECT(\"'A-8'!E20:E\" & (MATCH(\"X\",'A-8'!A1:A400,0)-2))))=(MATCH(\"X\",'A-8'!A1:A400,0)-2-19),IF(COUNTA(INDIRECT(\"'A-8'!E20:E\" & (MATCH(\"X\",'A-8'!A1:A400,0)-2)))=COUNTA(INDIRECT(\"'A-8'!F20:F\" & (MATCH(\"X\",'A-8'!A1:A400,0)-2))),1,-1),-1)","v":-1},null,{"$f":"F447","v":-1},"ANTICIPATED SCHEDULE"]
[null,null,null,null,null,{"$f":"IF(SUMPRODUCT((INDIRECT(\"'A-8'!B20:F\" & (MATCH(\"X\",'A-8'!A1:A400,0)-2))=\"Other - describe in NARRATIVE\")*(INDIRECT(\"'A-8'!G20:G\" & (MATCH(\"X\",'A-8'!A1:A400,0)-2))=\"\"))>0, -1, 1)","v":1},null,{"$f":"F448","v":1},"NARRATIVE"]
[null,null,null,null,false,{"$f":"IF(E449,MIN(F450:F456),1)","v":1},{"$f":"HYPERLINK(\"#'A-9'!A1\", \"Attachment 9\")","v":"Attachment 9"}]
[null,null,null,null,null,{"$f":"MIN(F451:F456)","v":-1},{"$f":"F450","v":-1},"Table filled out"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-9'!B35:B\" & (MATCH(\"X\",'A-9'!A1:A399,0)-2)))=(MATCH(\"X\",'A-9'!A1:A399,0)-2-34),1,-1)","v":-1},null,{"$f":"F451","v":-1},"RIGHT OF WAY PLAT OR EXHIBIT ID"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-9'!C35:C\" & (MATCH(\"X\",'A-9'!A1:A399,0)-2)))=(MATCH(\"X\",'A-9'!A1:A399,0)-2-34),1,-1)","v":-1},null,{"$f":"F452","v":-1},"PLAT / EXHIBIT APPROVAL OR LATEST REVISION DATE"]
[null,null,null,null,null,{"$f":"IF((COUNTA(INDIRECT(\"'A-9'!E35:E\" & (MATCH(\"X\",'A-9'!A1:A399,0)-2)))+COUNTA(INDIRECT(\"'A-9'!D35:D\" & (MATCH(\"X\",'A-9'!A1:A399,0)-2))))>=(MATCH(\"X\",'A-9'!A1:A399,0)-2-34),1,-1)","v":-1},null,-1,"PARCEL NUMBER"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-9'!E35:E\" & (MATCH(\"X\",'A-9'!A1:A399,0)-2)))=(MATCH(\"X\",'A-9'!A1:A399,0)-2-34),1,0)","v":0},null,0,"ITEM"]
[null,null,null,null,null,{"$f":"IF((COUNTA(INDIRECT(\"'A-9'!F35:F\" & (MATCH(\"X\",'A-9'!A1:A399,0)-2)))+COUNTA(INDIRECT(\"'A-9'!G35:G\" & (MATCH(\"X\",'A-9'!A1:A399,0)-2))))=(MATCH(\"X\",'A-9'!A1:A399,0)-2-34),IF(COUNTA(INDIRECT(\"'A-9'!G36:G\" & (MATCH(\"X\",'A-9'!A1:A399,0)-2)))=COUNTA(INDIRECT(\"'A-9'!H36:H\" & (MATCH(\"X\",'A-9'!A1:A399,0)-2))),1,-1),-1)","v":-1},null,-1,"ANTICIPATED START DATE"]
[null,null,null,null,null,{"$f":"IF(SUMPRODUCT((INDIRECT(\"'A-9'!B35:I\" & (MATCH(\"X\",'A-9'!A1:A399,0)-2))=\"Other - describe in NARRATIVE\")*(INDIRECT(\"'A-9'!I35:I\" & (MATCH(\"X\",'A-9'!A1:A399,0)-2))=\"\"))>0, -1, 1)","v":1},null,1,"NARRATIVE"]
[null,null,null,null,false,{"$f":"IF(E457,MIN(F458:F464),1)","v":1},{"$f":"HYPERLINK(\"#'A-10'!A1\", \"Attachment 10\")","v":"Attachment 10"}]
[null,null,null,null,null,{"$f":"MIN(F459:F464)","v":-1},{"$f":"F458","v":-1},"Table filled out"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-10'!B14:B\" & (MATCH(\"X\",'A-10'!A1:A402,0)-2)))=(MATCH(\"X\",'A-10'!A1:A402,0)-2-13),1,-1)","v":-1},null,{"$f":"F459","v":-1},"LAND INTEREST REQUIRED"]
[null,null,null,null,null,{"$f":"IF((COUNTA(INDIRECT(\"'A-10'!C14:C\" & (MATCH(\"X\",'A-10'!A1:A404,0)-2)))+(COUNTA(INDIRECT(\"'A-10'!D14:H\" & (MATCH(\"X\",'A-10'!A1:A404,0)-2)))/5)+COUNTA(INDIRECT(\"'A-10'!I14:I\" & (MATCH(\"X\",'A-10'!A1:A404,0)-2))))=(MATCH(\"X\",'A-10'!A1:A404,0)-2-13),1,-1)","v":-1},null,{"$f":"F460","v":-1},"LOCATION"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-10'!J14:J\" & (MATCH(\"X\",'A-10'!A1:A402,0)-2)))=(MATCH(\"X\",'A-10'!A1:A402,0)-2-13),1,-1)","v":-1},null,-1,"APPROX WIDTH"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-10'!K14:K\" & (MATCH(\"X\",'A-10'!A1:A402,0)-2)))=(MATCH(\"X\",'A-10'!A1:A402,0)-2-13),1,-1)","v":-1},null,-1,"ANTICIPATED ACQUISITION DATE"]
[null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'A-10'!L14:L\" & (MATCH(\"X\",'A-10'!A1:A402,0)-2)))=(MATCH(\"X\",'A-10'!A1:A402,0)-2-13),1,-1)","v":-1},null,-1,"REASON FOR ACQUISITION"]
[null,null,null,null,null,{"$f":"IF(SUMPRODUCT((INDIRECT(\"'A-10'!B14:L\" & (MATCH(\"X\",'A-10'!A1:A402,0)-2))=\"Other - describe in NARRATIVE\")*(INDIRECT(\"'A-10'!M14:M\" & (MATCH(\"X\",'A-10'!A1:A402,0)-2))=\"\"))>0, -1, 1)","v":1},null,1,"NARRATIVE"]

{"sheet":"Dropdowns","index":1,"n_rows":2,"n_cols":39,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[null,"ALG",null,null,null,"PRS",null,"UTE",null,null,null,null,"UTT",null,null,null,"CRW",null,"FCO",null,"FMA",null,"HCW",null,"LIR",null,"ITM",null,"PMT",null,"PRO",null,"UWP",null,"RFA",null,"EPA",null,"RBY"]
[null,"ALIGNMENT","MIN STA","MAX STA",null,"PROJECT STAGE",null,"UTILITY NAME","UTILITY FACILITY TYPE","UTILITY ENTITIES","UTILITY ABBR",null,"UTILITY FACILITY TYPE","TUMS ABBR","PLAN ABBR",null,"CONFLICT / REASON FOR WORK",null,"FACILITY COMPONENT",null,"FACILITY MATERIAL",null,"HIGHWAY CONTRACT WORK COMPLETED",null,"LAND INTEREST REQUIRED",null,"ITEM",null,"PERMIT",null,"PROTECTION TYPE",null,"UTILITY WORK PERFORMED",null,"REASON FOR ACQUISITION",null,"TEMPORARY EASEMENTS, PERMISSIONS, ACCESS",null,"REMOVAL BY"]

{"sheet":"Anticipated Conflicts","index":2,"n_rows":20,"n_cols":19,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,1,19,18],[11,2,11,4],[11,5,11,7],[12,2,13,2],[12,3,12,4],[12,5,13,5],[12,6,12,7],[11,8,13,8],[11,10,13,10],[11,11,13,11],[11,9,13,9],[12,14,13,14],[1,1,1,18],[8,2,8,18],[11,1,13,1],[11,12,13,12],[11,14,11,18],[4,2,4,18],[7,2,7,18],[5,2,5,18],[6,2,6,18],[12,15,13,15],[12,16,13,16],[12,17,13,17],[12,18,13,18],[11,13,13,13],[3,1,3,18]]}
[]
[null,"\nANTICIPATED CONFLICTS"]
[null,{"$f":"IF('Main Form'!$P$5 = \"\",\"\",'Main Form'!$P$5 & \" - \" &'Main Form'!$P$6)","v":""}]
[null,"Evaluate each potential utility conflict. This list is not exhaustive and is provided as a benefit to the Utility Facility Owner (OWNER) on behalf of the utility coordinator and project team. Data contained within this table must be imported into the required attachments.\n\nSelect the appropriate response for the CONFLICT ANTICIPATED OR NEW INSTALL column:\n      •  YES → It has been determined that the utility facility is in conflict, select which attachment(s) is appropriate to resolve the utility conflict.\n      •  YES-COMBINED → It has been determined that the utility facility is in conflict, but the resolution is included in another row. This utility conflict will not be imported into any attachments for question 5.\n      •  NO → It has been determined that the utility facility is not in conflict.\n      •  NO-DISCONTINUE → It has been determined that the utility facility is not in conflict, but will be discontinued. The utility conflict will be imported into Attachment 5D.\n      •  NEW INSTALL → For a new installation. Only select this for a new row that has been added to the table. 5R is automatically checked. Fill in all blank columns as proposed information.\n\nIf there are additional utility conflicts that were not identified in the table, use the Add Blank Row In Table button and fill in the required information.\nWhen complete, check the box that is below the table.\n\nJob Aid (See §2.4 & Appendix B Flowcharts)\n\nNOTE: The following is provided to aid in completing the table below:"]
[null,"5A","Adjustment to Finished Grade Required - Utility facilities will require adjustment to match the finished grade of the project plan. Details are provided on Attachment 5A."]
[null,"5D","Discontinuing in Place and/or Removal of Existing Utility Facilities Required - Existing utility facilities will be discontinued in place and/or removed as a part of the work plan. Details are provided on Attachment 5D."]
[null,"5P","Protection of Existing Utility Facilities Required - Existing utility facilities do not conflict with the highway construction, but the utility facilities may or will require protection during highway construction or during the utility work of another utility owner(s). Details are provided on Attachment 5P."]
[null,"5R","Relocation, Reconstruction, Rearrangement, and/or New Installation Required - Conflict(s) are anticipated between the project plan and the existing utility facilities. Installation of new utility facilities may also be required. Details are provided on Attachment 5R."]
[null,"5T","Temporary Utility Facilities Required - Installation of temporary utility facilities is required. Details are provided on Attachment 5T"]
[null," Add Blank Row In Table",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"ALIGNMENT","START",null,null,"END",null,null,"OH/UG","FACILITY SIZE","FACILITY COMPONENT","FACILITY MATERIAL","IN POTENTIAL CONFLICT WITH","CONFLICT ANTICIPATED OR NEW INSTALL","ATTACHMENTS"]
[null,null,"STATION","OFFSET",null,"STATION","OFFSET",null,null,null,null,null,null,null,"5A","5D","5P","5R","5T"]
[null,null,null,"DIST","LOC",null,"DIST","LOC"]
["Y","ALG","START STA","START DIST","START LOC","END STA","END DIST","END LOC","CATEGORY","SIZE","COMPONENT","MATERIAL","IN ANTICIPATED CONFLICT WITH","IN CONFLICT","A","R","D","P","T"]
[]
[]
["X"]
[]
[null,"END OF ANTICIPATED CONFLICTS"]

{"sheet":"A-3","index":3,"n_rows":76,"n_cols":3,"rows_kept":76,"cut":false,"hidden":true,"merged":[[12,2,12,11],[45,2,45,11],[49,2,50,11],[54,2,55,11],[57,2,57,11],[18,3,19,11],[21,3,22,11],[39,2,40,11],[24,3,25,11],[31,2,31,11],[42,2,43,11],[4,1,4,11],[5,1,5,11],[6,2,6,11],[7,2,7,11],[8,2,8,11],[62,2,63,11],[65,2,65,11],[67,2,68,11],[75,1,75,11],[71,2,72,11]]}
[]
[null,"EXISTING KNOWN DISCONTINUED UTILITY FACILITIES"]
[null,"Attachment 3"]
[null,{"$f":"IF('Main Form'!$P$5 = \"\",\"\",'Main Form'!$P$5 & \" - \" &'Main Form'!$P$6)","v":""}]
[null,"Any portion(s) of the Utility Facility Owner's (OWNER) existing known discontinued utility facilities that may or will conflict with the project plan must be removed. Portion(s) of existing known discontinued utility facilities to remain must be properly discontinued by plugging and/or bulkheading pipe or conduit ends, and/or filling the utility facility with flowable fill or sand."]
[null,"Note that conflicting portions of existing known discontinued utility facilities must be removed to the following depths:"]
[null,"•","Within the roadbed, to a depth at least 2 feet below the subgrade or excavation below subgrade (EBS)."]
[null,"•","Outside the roadbed, to a depth at least 2 feet below the finished grade line."]
[null,"•","At any location, to the extent required to avoid interfering with highway construction."]
[null,"Job Aid (See §2.3)"]
[]
[]
[null,"1.","Does the OWNER have existing known discontinued utility facilites that directly conflict with the highway construction and how will the conflicts be addressed?\nSelect all that apply"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Attach at least one of the following items to this worksheet to clearly provide known information about the type(s), location(s), material(s), and size(s) of the existing known discontinued utility facilities.\nSelect all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2.","Does the OWNER's existing known discontinued utility facilities that are to be removed have any asbestos coatings and/or any other hazardous materials (including contaminated soil) associated with them? Note that any required removal or mitigation of such utility facilities is the responsibility of the OWNER. \nSelect one of the following options."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3.","When the existing known utility facility was discontinued, did the OWNER perform any of the following?\nSelect all that apply."]
[]
[]
[]
[]
[]
[]
[]
[null,"4.","Does the OWNER's existing known discontinued utility facilities have any remaining product? Note that removal or mitigation of remaining product is the responsibility of the OWNER. \nSelect one of the following options."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"END OF ATTACHMENT 3"]

{"sheet":"A-5A","index":4,"n_rows":76,"n_cols":18,"rows_kept":76,"cut":false,"hidden":true,"merged":[[5,1,5,12],[47,2,48,18],[58,2,59,18],[10,1,10,13],[75,1,75,17],[14,1,16,1],[14,8,16,8],[14,13,14,15],[14,16,16,16],[14,17,16,17],[14,10,16,10],[14,11,16,11],[15,14,15,15],[14,9,16,9],[14,12,16,12],[14,2,14,4],[14,5,14,7],[15,2,16,2],[15,3,15,4],[15,5,16,5],[15,6,15,7]]}
[]
[null,"ADJUSTMENT TO FINISHED GRADE REQUIRED"]
[null,"Attachment 5A"]
[null,{"$f":"IF('Main Form'!$P$5 = \"\",\"\",'Main Form'!$P$5 & \" - \" &'Main Form'!$P$6)","v":""}]
[null,"Adjustment of utility facilities are required to match the finished grade of the project plan."]
[null,"• Fill in the following table for utility facilities to be adjusted."]
[null,"• All utility facilities requiring adjustment must be identified in the Anticipated Conflicts table, and will be imported over via the button below."]
[null,"• Show adjustments on the marked up copy of the project plan or other approved format."]
[null,"• Answer all questions displayed after the table."]
[null,"Job Aid (See §2.5)"]
[null,"NOTE: If portions of the utility work is independent of utility work by another utility owner(s), list the anticipated start date(s) and location for those portions of the OWNER's utility work. If the OWNER's utility work consists of multiple utility facilities or locations, make sure to list the anticipated start date(s) and location(s) associated with each utility facility or location. Make sure to distinguish between total duration and 'per location' duration."]
[]
[null,"Import Identified Conflicts"]
[]
[null,"ALIGNMENT","START",null,null,"END",null,null,"OH/UG","FACILITY SIZE","FACILITY COMPONENT","FACILITY MATERIAL","CONFLICT / REASON FOR WORK","ANTICIPATED START DATE",null,null,"WORKING DAYS TO PERFORM","NARRATIVE"]
[null,null,"STATION","OFFSET",null,"STATION","OFFSET",null,null,null,null,null,null,"PRIOR TO CONST.","DURING CONSTRUCTION"]
[null,null,null,"DIST","LOC",null,"DIST","LOC",null,null,null,null,null,"CALENDAR DATE","PROJECT STAGE","HIGHWAY CONTRACT WORK COMPLETED"]
[]
[]
["X"]
[]
[]
[null,"1.     Who will be completing the OWNER's utility work?"]
[]
[]
[]
[]
[null,"2.     Is it anticipated that the OWNER's utility work will require any roadway, lane, and/or shoulder closure(s)? Preference for closures will be given to those OWNERs that indicate a need in this worksheet. Select all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3.     Is it anticipated that the OWNER's utility work will impact pedestrian (including curb ramps) and/or bicycle facilities? Preference for closures will be given to those OWNERs that indicate a need for a closure in this worksheet. Select one of the following options."]
[]
[]
[null,"                   How will the OWNER accommodate pedestrian (including curb ramps) and/or bicycle facilities impacted by the utility work? Select all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"                   How will the OWNER restore pedestrian and/or bicycle facilities impacted by the utility work? Select all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"4.     What format will adjustments be shown in addition to the above table?"]
[]
[]
[]
[]
[]
[]
[]
[null,"END OF ATTACHMENT 5A"]

{"sheet":"A-5D","index":5,"n_rows":105,"n_cols":23,"rows_kept":105,"cut":false,"hidden":true,"merged":[[51,1,51,17],[56,1,56,17],[65,1,65,17],[19,21,21,21],[19,15,19,17],[19,5,19,7],[19,1,21,1],[20,6,20,7],[20,5,21,5],[19,9,21,9],[19,12,21,12],[42,2,43,15],[47,2,48,15],[38,1,38,17],[4,1,4,13],[14,1,14,13],[30,2,31,15],[35,2,36,15],[6,1,6,13],[26,1,26,17],[76,2,77,15],[87,2,88,15],[104,1,104,22],[19,2,19,4],[20,2,21,2],[20,3,20,4],[19,10,21,10],[19,11,21,11],[19,8,21,8],[20,16,20,17],[19,18,21,18],[19,19,21,19],[19,20,21,20],[19,22,21,22],[19,13,21,13],[19,14,21,14]]}
[]
[null,"DISCONTINUING IN PLACE AND/OR REMOVING OF EXISTING UTILITY FACILITIES REQUIRED"]
[null,"Attachment 5D"]
[null,{"$f":"IF('Main Form'!$P$5 = \"\",\"\",'Main Form'!$P$5 & \" - \" &'Main Form'!$P$6)","v":""}]
[null,"The Utility Facility Owner's (OWNER) has existing utility facilities to be discontinued in place and/or removed due to conflicts with the project plan. Properly discontinue any existing utility facilities, including services, that will remain by plugging and/or bulkheading pipe or conduit ends, and/or filling the facility with flowable fill or sand."]
[null,"• Fill in the following table for existing utility facilities to be discontinued and/or removed, including the COORDINATION OF A SHARED UTILITY SPACE column."]
[null,"• All utility facilities discontinued in place and/or removed must be identified in the Anticipated Conflicts table, and will be imported over via the button below."]
[null,"• Show discontinuances and/or removals on the marked up copy of the project plan or other approved format."]
[null,"• Answer all questions displayed after the table."]
[null,"Job Aid (See §2.6)"]
[null,"Note that conflicting portions of utility facilities to be discontinued must be removed to the following depths:"]
[null,"• Within the roadbed, to a depth at least 2 feet below the subgrade or excavation below subgrade (EBS) as shown on the project plans."]
[null,"• Outside the roadbed, to a depth at least 2 feet below the finished grade."]
[null,"• At any location, to the extent required to avoid interfering with the highway construction."]
[null,"NOTE: If portions of the OWNER's utility work is independent of utility work by another utility owner(s), list the anticipated start date(s) and location for those portions of the OWNER's utility work. If the OWNER's utility work consists of multiple utility facilities or locations, make sure to list the anticipated start date(s) and location(s) associated with each utility facility or location. Make sure to distinguish between total duration and 'per location' duration."]
[]
[]
[null,"Import Identified Conflicts"]
[]
[null,"ALIGNMENT","START",null,null,"END",null,null,"OH/UG","FACILITY SIZE","FACILITY COMPONENT","FACILITY MATERIAL","CONFLICT / REASON FOR WORK","UTILITY WORK PERFORMED","CONFLICTING PORTION(S) REMOVED BY","ANTICIPATED START DATE",null,null,"WORKING DAYS TO PERFORM","COORDINATION OF A SHARED UTILITY SPACE","PROVIDER OR PARTICIPANT","IMPORTED?","NARRATIVE"]
[null,null,"STATION","OFFSET",null,"STATION","OFFSET",null,null,null,null,null,null,null,null,"PRIOR TO CONST.","DURING CONSTRUCTION"]
[null,null,null,"DIST","LOC",null,"DIST","LOC",null,null,null,null,null,null,null,"CALENDAR DATE","PROJECT STAGE","HIGHWAY CONTRACT WORK COMPLETED"]
[]
[]
["X"]
[]
[null,"1.     Does the OWNER's existing appurtenances, underground utility facilities, and/or utility facilities attached to structures to be discontinued in place and/or removed have any asbestos coatings and/or any other hazardous materials (including contaminated soil) associated with them?"]
[null,"        Note that any required removal or mitigation of such facilities is the responsibility of the facility OWNER. Select one of the following options."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2.     Does the OWNER's existing appurtenances, underground utility facilities, and/or utility facilities attached to structures to be discontinued in place have any remaining product?"]
[null,"        Note that removal or mitigation of remaining product is the responsibility of the facility OWNER. Select one of the following options."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3.     Who will be completing the OWNER's utility work?"]
[]
[]
[]
[]
[null,"4.     Is it anticipated that the OWNER's utility work will require any roadway, lane, and/or shoulder closure(s)? Preference for closures will be given to those OWNERs that indicate a need in this worksheet.\n        Select all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"5.     Is it anticipated that the OWNER's utility work will impact pedestrian (including curb ramps) and/or bicycle facilities? Preference for closures will be given to those OWNERs that indicate a need for a closure in this worksheet.\n        Preference for closures will be given to those OWNERs that indicate a need for a closure in this worksheet. Select one of the following "]
[]
[]
[null,"                   How will the OWNER accommodate pedestrian (including curb ramps) and/or bicycle facilities impacted by the utility work? Select all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"                   How will the OWNER restore pedestrian and/or bicycle facilities impacted by the utility work? Select all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"6.     What format will discontinuances and/or removals be shown in addition to the above table?"]
[]
[]
[]
[]
[]
[]
[]
[null,"END OF ATTACHMENT 5D"]

{"sheet":"A-5P","index":6,"n_rows":75,"n_cols":22,"rows_kept":75,"cut":false,"hidden":true,"merged":[[14,18,16,18],[14,19,16,19],[6,1,6,13],[14,16,16,16],[14,17,16,17],[14,14,14,15],[15,14,16,14],[14,9,16,9],[14,5,14,7],[10,1,10,12],[15,5,16,5],[14,21,16,21],[74,1,74,21],[15,6,15,7],[14,10,16,10],[14,11,16,11],[14,12,16,12],[14,13,16,13],[15,15,16,15],[14,1,16,1],[14,2,14,4],[15,2,16,2],[14,8,16,8],[15,3,15,4],[46,2,47,15],[57,2,58,15],[14,20,16,20]]}
[]
[null,"PROTECTION OF EXISTING UTILITY FACILITIES REQUIRED"]
[null,"Attachment 5P"]
[null,{"$f":"IF('Main Form'!$P$5 = \"\",\"\",'Main Form'!$P$5 & \" - \" &'Main Form'!$P$6)","v":""}]
[null,"The Utility Facility Owner's (OWNER) has utility facilities that require protection as conflicts exist with the project plan. "]
[null,"• Fill in the following table for the protection of utility facilities, including the COORDINATION OF A SHARED UTILITY SPACE column."]
[null,"• All utility facilities to be protected must be identified in the Anticipated Conflicts table, and will be imported over via the button below."]
[null,"• Show protection of the utility facilities on a marked up copy of the project plan or other approved format."]
[null,"• Answer all questions displayed after the table."]
[null,"Job Aid (See §2.7)"]
[null,"NOTE: If portions of the OWNER's utility work is independent of utility work by another utility owner(s), list the anticipated start date(s) and location for those portions of the OWNER's utility work. If the OWNER's utility work consists of multiple utility facilities or locations, make sure to list the anticipated start date(s) and location(s) associated with each utility facility or location. Make sure to distinguish between total duration and 'per location' duration."]
[]
[null,"Import Identified Conflicts"]
[]
[null,"ALIGNMENT","START",null,null,"END",null,null,"OH/UG","FACILITY SIZE","FACILITY COMPONENT","FACILITY MATERIAL","CONFLICT / REASON FOR WORK","UTILITY WORK PERFORMED\n(PROTECTION TYPE)","ANTICIPATED START DATE",null,"WORKING DAYS TO PERFORM","SPECS FOR CONTRACT DOCS","COORDINATION OF A SHARED UTILITY SPACE","PROVIDER OR PARTICIPANT","IMPORTED?","NARRATIVE"]
[null,null,"STATION","OFFSET",null,"STATION","OFFSET",null,null,null,null,null,null,null,"PROJECT STAGE","HIGHWAY CONTRACT WORK COMPLETED"]
[null,null,null,"DIST","LOC",null,"DIST","LOC"]
[]
[]
["X"]
[]
[null,"1.     Who will be completing the OWNER's utility work?"]
[]
[]
[]
[]
[null,"2.     Is it anticipated that the OWNER's utility work will require any roadway, lane, and/or shoulder closure(s)? Preference for closures will be given to those OWNERs that indicate a need in this worksheet. Select all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3.     Is it anticipated that the OWNER's utility work will impact pedestrian (including curb ramps) and/or bicycle facilities? Preference for closures will be given to those OWNERs that indicate a need for a closure in this worksheet. Select one of the following options."]
[]
[]
[null,"                   How will the OWNER accommodate pedestrian (including curb ramps) and/or bicycle facilities impacted by the utility work? Select all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"                   How will the OWNER restore pedestrian and/or bicycle facilities impacted by the utility work? Select all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"4.     What format will protections be shown in addition to the above table?"]
[]
[]
[]
[]
[]
[]
[]
[null,"END OF ATTACHMENT 5P"]

{"sheet":"A-5R","index":7,"n_rows":75,"n_cols":33,"rows_kept":75,"cut":false,"hidden":true,"merged":[[5,1,5,22],[8,1,8,21],[13,16,14,17],[15,16,16,16],[15,17,16,17],[15,9,15,10],[14,2,14,4],[14,5,14,7],[15,3,15,4],[15,5,16,5],[15,2,16,2],[15,6,15,7],[46,2,47,15],[57,2,58,15],[14,11,14,13],[15,11,16,11],[13,14,14,15],[15,14,16,14],[15,15,16,15],[74,1,74,32],[13,2,13,7],[13,8,13,13],[15,8,16,8],[15,12,15,13],[13,32,16,32],[13,30,16,30],[13,1,16,1],[14,8,14,10],[13,29,16,29],[13,28,16,28],[13,25,13,27],[13,22,16,22],[13,23,16,23],[13,24,16,24],[14,26,14,27],[13,31,16,31],[15,25,16,25],[15,27,16,27],[15,26,16,26],[13,18,14,19],[15,18,16,18],[15,19,16,19],[15,20,16,20],[15,21,16,21],[13,20,14,21]]}
[]
[null,"RELOCATION, RECONSTRUCTION, REARRANGEMENT AND/OR NEW UTILITY FACILITY INSTALLATION REQUIRED"]
[null,"Attachment 5R"]
[null,{"$f":"IF('Main Form'!$P$5 = \"\",\"\",'Main Form'!$P$5 & \" - \" &'Main Form'!$P$6)","v":""}]
[null,"The Utility Facility Owner's (OWNER) has utility facilities to be relocated, reconstructed, rearranged, and/or the installation of new utility facilities."]
[null,"• Fill in the following table for the relocation, reconstruction, rearrangement, and/or the installation of new utility facilities, including the COORDINATION OF A SHARED UTILITY SPACE column.\n• All utility facilities to be relocated, reconstructed, rearranged, and/or the installation of new utility facilities must be identified in the Anticipated Conflicts table, and will be imported over via the button below.\n• Show the relocation, reconstruction, rearrangement, and/or the installation of new utility facilities on the marked up copy of the project plan or other approved format."]
[null,"• Answer all questions displayed after the table."]
[null,"Job Aid (See §2.8)"]
[null,"NOTE: If portions of the OWNER's utility work is independent of utility work by another utility owner(s), list the anticipated start date(s) and location for those portions of the OWNER's utility work. If the OWNER's utility work consists of multiple utility facilities or locations, make sure to list the anticipated start date(s) and location(s) associated with each utility facility or location. Make sure to distinguish between total duration and 'per location' duration."]
[]
[]
[null,"Import Identified Conflicts"]
[]
[null,"ALIGNMENT","EXISTING",null,null,null,null,null,"PROPOSED",null,null,null,null,null,"OH/UG",null,"FACILITY SIZE",null,"FACILITY COMPONENT",null,"FACILITY MATERIAL",null,"CONFLICT / REASON FOR WORK","UTILITY WORK PERFORMED","DISCONTINUED OR REMOVED AT TIME OF RELOCATION OR RECONSTRUCTION","ANTICIPATED START DATE",null,null,"WORKING DAYS TO PERFORM","COORDINATION OF A SHARED UTILITY SPACE","PROVIDER OR PARTICIPANT","IMPORTED?","NARRATIVE"]
[null,null,"START",null,null,"END",null,null,"START",null,null,"END",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRIOR TO CONST.","DURING CONSTRUCTION"]
[null,null,"STATION","OFFSET",null,"STATION","OFFSET",null,"STATION","OFFSET",null,"STATION","OFFSET",null,"EX","PR","EX","PR","EX","PR","EX","PR",null,null,null,"CALENDAR DATE","PROJECT STAGE","HIGHWAY CONTRACT WORK COMPLETED"]
[null,null,null,"DIST","LOC",null,"DIST","LOC",null,"DIST","LOC",null,"DIST","LOC"]
[]
[]
["X"]
[]
[null,"1.     Who will be completing the utility work?"]
[]
[]
[]
[]
[null,"2.     Is it anticipated that the OWNER's utility work will require any roadway, lane, and/or shoulder closure(s)? Preference for closures will be given to those OWNERs that indicate a need in this worksheet. Select all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3.     Is it anticipated that the OWNER's utility work will impact pedestrian (including curb ramps) and/or bicycle facilities? Preference for closures will be given to those OWNERs that indicate a need for a closure in this worksheet. Select one of the following options."]
[]
[]
[null,"                   How will the OWNER accommodate pedestrian (including curb ramps) and/or bicycle facilities impacted by the utility work? Select all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"                   How will the OWNER restore pedestrian and/or bicycle facilities impacted by the utility work? Select all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"4.     What format will relocations, reconstructions, rearrangements, and/or new installations be shown in addition to the above table?"]
[]
[]
[]
[]
[]
[]
[]
[null,"END OF ATTACHMENT 5R"]

{"sheet":"A-5T","index":8,"n_rows":83,"n_cols":24,"rows_kept":83,"cut":false,"hidden":true,"merged":[[5,1,5,14],[54,2,55,15],[65,2,66,15],[25,1,26,12],[13,13,15,13],[9,1,9,12],[82,1,82,23],[13,23,15,23],[13,12,15,12],[13,14,15,14],[13,15,15,15],[13,2,13,4],[14,2,15,2],[13,1,15,1],[14,3,14,4],[13,5,13,7],[13,16,13,18],[13,19,15,19],[13,20,15,20],[13,21,15,21],[13,22,15,22],[14,5,15,5],[14,17,14,18],[14,6,14,7],[13,10,15,10],[13,11,15,11],[13,8,15,8],[13,9,15,9]]}
[]
[null,"TEMPORARY UTILITY FACILITIES REQUIRED"]
[null,"Attachment 5T"]
[null,{"$f":"IF('Main Form'!$P$5 = \"\",\"\",'Main Form'!$P$5 & \" - \" &'Main Form'!$P$6)","v":""}]
[null,"The Utility Facility Owner (OWNER) has installation and/or removal of temporary facilities, including temporary services."]
[null,"• Fill in the following table for the installation and/or removal of temporary utility facilities, including the COORDINATION OF A SHARED UTILITY SPACE column.\n• All temporary utility facilities to be installed and/or removed must be identified in the Anticipated Conflicts table, and will be imported over via the button below."]
[null,"• Show temporary utility facilities on the marked up copy of the project plan or other approved format."]
[null,"• Answer all questions displayed after the table."]
[null,"Job Aid (See §2.9)"]
[null,"NOTE: If portions of the OWNER's utility work is independent of utility work by another utility owner(s), list the anticipated start date(s) and location for those portions of the OWNER's utility work. If the OWNER's utility work consists of multiple utility facilities or locations, make sure to list the anticipated start date(s) and location(s) associated with each utility facility or location. Make sure to distinguish between total duration and 'per location' duration."]
[]
[null,"Import Identified Conflicts"]
[]
[null,"ALIGNMENT","START",null,null,"END",null,null,"OH/UG","FACILITY SIZE","FACILITY COMPONENT","FACILITY MATERIAL","CONFLICT / REASON FOR WORK","INSTALL / REMOVE","UTILITY WORK PERFORMED","TEMPORARY EASEMENTS, PERMISSIONS, ACCESS","ANTICIPATED START DATE",null,null,"WORKING DAYS TO PERFORM","COORDINATION OF A SHARED UTILITY SPACE","PROVIDER OR PARTICIPANT","IMPORTED?","NARRATIVE"]
[null,null,"STATION","OFFSET",null,"STATION","OFFSET",null,null,null,null,null,null,null,null,null,"PRIOR TO CONST.","DURING CONSTRUCTION"]
[null,null,null,"DIST","LOC",null,"DIST","LOC",null,null,null,null,null,null,null,null,"CALENDAR DATE","PROJECT STAGE","HIGHWAY CONTRACT WORK COMPLETED"]
[]
[]
["X"]
[]
[null,"1.     Could any of the following affect the OWNER's utility work or the utility work of another utility owner(s)? Select all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2.     Who will be completing the OWNER's utility work?"]
[]
[]
[]
[]
[null,"3.     Is it anticipated that the OWNER's utility work will require any roadway, lane, and/or shoulder closure(s)? Preference for closures will be given to those OWNERs that indicate a need in this worksheet. Select all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"4.     Is it anticipated that the OWNER's utility work will impact pedestrian (including curb ramps) and/or bicycle facilities? Preference for closures will be given to those OWNERs that indicate a need for a closure in this worksheet. Select one of the following options."]
[]
[]
[null,"                   How will the OWNER accommodate pedestrian (including curb ramps) and/or bicycle facilities impacted by the utility work? Select all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"                   How will the OWNER restore pedestrian and/or bicycle facilities impacted by the utility work? Select all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"5.     What format will temporary utility facilities be shown in addition to the above table?"]
[]
[]
[]
[]
[]
[]
[]
[null,"END OF ATTACHMENT 5T"]

{"sheet":"A-6E","index":9,"n_rows":132,"n_cols":3,"rows_kept":132,"cut":false,"hidden":true,"merged":[[62,2,63,12],[103,2,103,12],[131,1,131,12],[111,3,112,12],[122,3,123,12],[100,2,100,12],[83,2,83,12],[91,2,91,12],[71,2,72,12],[80,2,81,12],[86,2,87,12],[4,1,4,12],[27,2,27,12],[14,2,14,12],[66,2,66,12],[74,2,74,12],[24,2,25,12],[35,2,36,12],[39,2,40,12],[43,2,44,12],[32,2,32,12],[7,2,7,12],[11,2,12,12],[46,2,46,12],[49,2,49,12],[50,2,51,12],[54,2,54,12]]}
[]
[null,"EXISTING SERVICE WORK REQUIRED"]
[null,"Attachment 6E"]
[null,{"$f":"IF('Main Form'!$P$5 = \"\",\"\",'Main Form'!$P$5 & \" - \" &'Main Form'!$P$6)","v":""}]
[null,"The Utility Facility Owner (OWNER) has removals, discontinuances, modifications, and/or relocations of existing services. \n     • Answer the displayed questions below for the existing service work required."]
[null,"Job Aid (See §2.10)"]
[]
[null,"1.","Who will be completing the service work?"]
[]
[]
[]
[]
[]
[]
[null,"2.","What type of service work is required by the OWNER? \nSelect all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3.","Has the OWNER included the service work in Attachment 5R?"]
[]
[]
[]
[]
[null,null,"Fill in the following information.\nSelect all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"4.","Will the OWNER require a property owner, associated with the service(s) work, to incur any costs related to the service work?"]
[]
[]
[null,null,"Identify the property, by address or parcel number, and describe the anticipated arrangements that will be made with the property owner(s) for costs associated with the service work."]
[]
[]
[]
[]
[null,"5.","Does the OWNER have any service-related facilities that have not been previously addressed and are impacted by the proposed revisions to pedestrian (including curb ramps) and/or bicycle facilities? \nSelect all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"6.","When will the OWNER perform removals, discontinuances, modifications, and/or relocations? \nSelect all that apply."]
[]
[]
[]
[]
[]
[]
[]
[null,"7.","What is the method of construction for the OWNER's service work? \nSelect all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"8.","Will the OWNER change any existing overhead service(s) to underground service(s) or vice-versa?"]
[]
[]
[]
[]
[]
[]
[]
[null,"9.","Is it anticipated that the OWNER's utility work will require any roadway, lane, and/or shoulder closure(s)? Preference for closures will be given to those OWNERs that indicate a need in this worksheet. \nSelect all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"10.","Is it anticipated that the OWNER's utility work will impact pedestrian (including curb ramps) and/or bicycle facilities? Preference for closures will be given to those OWNERs that indicate a need for a closure in this worksheet. Select one of the following options."]
[]
[]
[null,null,"How will the OWNER accommodate pedestrian (including curb ramps) and/or bicycle facilities impacted by the utility work? Select all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"How will the OWNER restore pedestrian and/or bicycle facilities impacted by the utility work? Select all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"END OF ATTACHMENT 6E"]

{"sheet":"A-6N","index":10,"n_rows":99,"n_cols":20,"rows_kept":99,"cut":false,"hidden":true,"merged":[[12,18,15,18],[4,1,4,19],[12,1,15,1],[14,2,15,2],[14,5,15,5],[12,8,15,8],[12,10,15,10],[12,11,15,11],[12,15,15,15],[12,16,15,16],[12,12,12,14],[12,17,15,17],[12,19,15,19],[14,3,14,4],[14,6,14,7],[12,9,15,9],[98,1,98,19],[29,2,30,12],[37,2,38,12],[41,2,42,12],[45,2,46,12],[49,2,50,12],[70,2,70,11],[78,3,79,12],[89,3,90,12],[12,2,12,7],[13,13,13,14],[14,12,15,12],[14,13,15,13],[14,14,15,14],[13,2,13,4],[13,5,13,7]]}
[]
[null,"NEW SERVICE WORK REQUIRED"]
[null,"Attachment 6N"]
[null,{"$f":"IF('Main Form'!$P$5 = \"\",\"\",'Main Form'!$P$5 & \" - \" &'Main Form'!$P$6)","v":""}]
[null,"The Utility Facility Owner (OWNER) needs to coordinate the installation of a new service(s). Include any service-related utility facilities that have not been previously addressed and are impacted by the project plan."]
[null,"• Fill in the following table and answer the questions below for the new service work required."]
[null,"• Utility facilities marked as requiring coordination with others will be imported to Attachment 7PR or 7PT."]
[null,"• Billing is not considered coordinating with other utility owners."]
[null,"• Answer all questions displayed after the table."]
[null,"Job Aid (See §2.11)"]
[null,"Add Blank Row In Table"]
[]
[null,"ALIGNMENT","PROPOSED",null,null,null,null,null,"OH/UG","FACILITY SIZE","FACILITY COMPONENT","FACILITY MATERIAL","ANTICIPATED START DATE",null,null,"WORKING DAYS TO PERFORM","COORDINATION OF SHARED UTILITY SPACE","PROVIDER OR PARTICIPANT","IMPORTED?","NARRATIVE"]
[null,null,"START",null,null,"END",null,null,null,null,null,null,"PRIOR TO CONST.","DURING CONSTRUCTION"]
[null,null,"STATION","OFFSET",null,"STATION","OFFSET",null,null,null,null,null,"CALENDAR DATE","PROJECT STAGE","HIGHWAY CONTRACT WORK COMPLETED"]
[null,null,null,"DIST","LOC",null,"DIST","LOC"]
[]
[]
["X"]
[]
[]
[null,"1.     Will the OWNER's service work include any of the following items or substantially similar items? Do not include utility work previously identified in Attachment 5R or Attachment 7PR or 7PT. Select all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2.     Will any of the OWNER's service work identified in the above question require coordination with any of the following? Select all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3.     Who will be completing the OWNER's service work?"]
[]
[]
[]
[null,"4.     Is it anticipated that the OWNER's service work will require any roadway, lane, and/or shoulder closure(s)? Preference for closures will be given to those OWNERs that indicate a need in this worksheet. Select all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"5.     Is it anticipated that the OWNER's service work will impact pedestrian (including curb ramps) and/or bicycle facilities? Preference for closures will be given to those OWNERs that indicate a need for a closure in this worksheet."]
[null,"        Select one of the following options."]
[]
[null,null,"How will the OWNER accommodate pedestrian (including curb ramps) and/or bicycle facilities impacted by the service work? Select all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"How will the OWNER restore pedestrian and/or bicycle facilities impacted by the service work? Select all that apply."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"END OF ATTACHMENT 6N"]

{"sheet":"A-7PR","index":11,"n_rows":23,"n_cols":240,"rows_kept":23,"cut":false,"hidden":true,"merged":[[13,239,16,239],[15,15,16,15],[15,16,15,17],[15,18,16,18],[15,19,15,20],[13,21,14,22],[13,23,14,24],[13,25,14,26],[13,27,14,28],[15,21,16,21],[15,26,16,26],[15,27,16,27],[15,28,16,28],[13,230,16,230],[13,231,16,231],[13,232,16,232],[13,233,16,233],[13,234,16,234],[13,235,16,235],[13,236,16,236],[13,237,16,237],[13,238,16,238],[13,221,16,221],[13,222,16,222],[13,223,16,223],[13,224,16,224],[13,225,16,225],[13,226,16,226],[13,227,16,227],[13,228,16,228],[13,229,16,229],[13,212,16,212],[13,213,16,213],[13,214,16,214],[13,215,16,215],[13,216,16,216],[13,217,16,217],[13,218,16,218],[13,219,16,219],[13,220,16,220],[13,203,16,203],[13,204,16,204],[13,205,16,205],[13,206,16,206],[13,207,16,207],[13,208,16,208],[13,209,16,209],[13,210,16,210],[13,211,16,211],[13,194,16,194],[13,195,16,195],[13,196,16,196],[13,197,16,197],[13,198,16,198],[13,199,16,199],[13,200,16,200],[13,201,16,201],[13,202,16,202],[13,185,16,185],[13,186,16,186],[13,187,16,187],[13,188,16,188],[13,189,16,189],[13,190,16,190],[13,191,16,191],[13,192,16,192],[13,193,16,193],[13,176,16,176],[13,177,16,177],[13,178,16,178],[13,179,16,179],[13,180,16,180],[13,181,16,181],[13,182,16,182],[13,183,16,183],[13,184,16,184],[13,167,16,167],[13,168,16,168],[13,169,16,169],[13,170,16,170],[13,171,16,171],[13,172,16,172],[13,173,16,173],[13,174,16,174],[13,175,16,175],[13,158,16,158],[13,159,16,159],[13,160,16,160],[13,161,16,161],[13,162,16,162],[13,163,16,163],[13,164,16,164],[13,165,16,165],[13,166,16,166],[13,149,16,149],[13,150,16,150],[13,151,16,151],[13,152,16,152],[13,153,16,153],[13,154,16,154],[13,155,16,155],[13,156,16,156],[13,157,16,157],[13,140,16,140],[13,141,16,141],[13,142,16,142],[13,143,16,143],[13,144,16,144],[13,145,16,145],[13,146,16,146],[13,147,16,147],[13,148,16,148],[13,131,16,131],[13,132,16,132],[13,133,16,133],[13,134,16,134],[13,135,16,135],[13,136,16,136],[13,137,16,137],[13,138,16,138],[13,139,16,139],[13,122,16,122],[13,123,16,123],[13,124,16,124],[13,125,16,125],[13,126,16,126],[13,127,16,127],[13,128,16,128],[13,129,16,129],[13,130,16,130],[13,113,16,113],[13,114,16,114],[13,115,16,115],[13,116,16,116],[13,117,16,117],[13,118,16,118],[13,119,16,119],[13,120,16,120],[13,121,16,121],[13,104,16,104],[13,105,16,105],[13,106,16,106],[13,107,16,107],[13,108,16,108],[13,109,16,109],[13,110,16,110],[13,111,16,111],[13,112,16,112],[13,95,16,95],[13,96,16,96],[13,97,16,97],[13,98,16,98],[13,99,16,99],[13,100,16,100],[13,101,16,101],[13,102,16,102],[13,103,16,103],[13,86,16,86],[13,87,16,87],[13,88,16,88],[13,89,16,89],[13,90,16,90],[13,91,16,91],[13,92,16,92],[13,93,16,93],[13,94,16,94],[13,77,16,77],[13,78,16,78],[13,79,16,79],[13,80,16,80],[13,81,16,81],[13,82,16,82],[13,83,16,83],[13,84,16,84],[13,85,16,85],[13,68,16,68],[13,69,16,69],[13,70,16,70],[13,71,16,71],[13,72,16,72],[13,73,16,73],[13,74,16,74],[13,75,16,75],[13,76,16,76],[13,59,16,59],[13,60,16,60],[13,61,16,61],[13,62,16,62],[13,63,16,63],[13,64,16,64],[13,65,16,65],[13,66,16,66],[13,67,16,67],[13,50,16,50],[13,51,16,51],[13,52,16,52],[13,53,16,53],[13,54,16,54],[13,55,16,55],[13,56,16,56],[13,57,16,57],[13,58,16,58],[13,41,16,41],[13,42,16,42],[13,43,16,43],[13,44,16,44],[13,45,16,45],[13,46,16,46],[13,47,16,47],[13,48,16,48],[13,49,16,49],[13,6,16,6],[13,7,16,7],[13,9,13,14],[14,9,14,11],[15,22,16,22],[15,23,16,23],[15,24,16,24],[15,25,16,25],[13,40,16,40],[14,12,14,14],[15,9,16,9],[15,10,15,11],[15,12,16,12],[15,13,15,14],[4,1,4,31],[22,1,22,38],[13,1,16,1],[13,2,16,2],[13,3,16,3],[13,8,16,8],[13,29,13,31],[13,32,16,32],[13,33,16,33],[13,34,16,34],[13,35,16,35],[13,36,16,36],[13,37,16,37],[13,38,16,38],[5,1,5,25],[14,15,14,17],[14,18,14,20],[13,15,13,20],[14,30,14,31],[15,29,16,29],[15,30,16,30],[15,31,16,31],[13,4,16,4],[13,5,16,5]]}
[]
[null,"PROVIDER COORDINATION IN SHARED UTILITY SPACE"]
[null,"Attachment 7PR"]
[null,{"$f":"IF('Main Form'!$P$5 = \"\",\"\",'Main Form'!$P$5 & \" - \" &'Main Form'!$P$6)","v":""}]
[null,"The Utility Facility Owner's (OWNER) proposed utility work is dependent on or affected by the utility work of another utility owner(s) in a shared utility space. Dependent means that the shared utility space is occupied by, or the location is shared with utility facilities of another utility owner(s). Provide details of coordination with other utility owner(s) below and/or on attached sheets. In the CONTACT INFO column, include the contact information of the person/people that were coordinated with at the other utility owner(s). In the NARRATIVE column, include a brief description of the utility work by the other utility owner(s) and how it impacts the OWNER and the OWNER's schedule."]
[null,"• Import utility facilities from the attachment(s) for Question 5.\n• Fill in the rest of the table as the provider in the shared utility space."]
[null,"Job Aid (See §2.12)"]
[]
[null,"Import Identified Coordinated Facilities",null,null,null,"View Gantt Chart"]
[]
[]
[null,"Add Utility 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,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE18=\"\",\"\",\"↓ Stage \"&AE18&\" - \"&AF18&\" Completed \") & IF(AE18=\"\",IF(SUM(AG18:AG20)>=60,\"(CALENDAR WEEKS)\",\"(CALENDAR DAYS)\"),IF(SUM(AG18:AG20)>=60,\"(WORKING WEEKS)\",\"(WORKING DAYS)\"))","v":"(CALENDAR DAYS)"}]
[null,"COORDINATING ENTITY","UTILITY TYPE","COORDINATION BETWEEN PROVIDER AND PARTICIPANT COMPLETED","UTILITY WORK PERFORMED","UTILITY WORK PERFORMED BY","CONCURRENT WORK POSSIBLE","ORDER OF CONSTRUCTION","ALIGNMENT","EXISTING",null,null,null,null,null,"PROPOSED",null,null,null,null,null,"OH/UG",null,"FACILITY SIZE",null,"FACILITY COMPONENT",null,"FACILITY MATERIAL",null,"ANTICIPATED START DATE",null,null,"WORKING DAYS TO PERFORM","STARTING WORKING DAY","UPPER BOUND WD","LOWER BOUND WD","NOTES FOR UCM","CONTACT INFO","NARRATIVE",null,{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(AO14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"00:00:00"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(AP14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-01"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(AQ14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-02"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(AR14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-03"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(AS14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-04"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(AT14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-05"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(AU14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-06"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(AV14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-07"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(AW14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-08"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(AX14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-09"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(AY14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-10"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(AZ14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-11"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BA14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-12"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BB14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-13"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BC14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-14"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BD14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-15"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BE14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-16"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BF14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-17"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BG14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-18"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BH14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-19"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BI14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-20"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BJ14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-21"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BK14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-22"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BL14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-23"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BM14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-24"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BN14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-25"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BO14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-26"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BP14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-27"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BQ14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-28"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BR14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-29"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BS14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-30"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BT14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-01-31"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BU14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-01"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BV14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-02"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BW14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-03"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BX14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-04"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BY14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-05"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(BZ14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-06"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CA14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-07"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CB14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-08"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CC14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-09"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CD14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-10"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CE14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-11"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CF14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-12"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CG14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-13"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CH14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-14"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CI14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-15"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CJ14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-16"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CK14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-17"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CL14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-18"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CM14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-19"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CN14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-20"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CO14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-21"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CP14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-22"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CQ14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-23"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CR14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-24"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CS14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-25"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CT14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-26"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CU14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-27"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CV14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-02-28"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CW14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":60},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CX14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-01"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CY14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-02"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(CZ14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-03"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DA14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-04"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DB14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-05"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DC14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-06"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DD14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-07"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DE14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-08"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DF14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-09"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DG14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-10"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DH14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-11"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DI14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-12"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DJ14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-13"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DK14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-14"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DL14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-15"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DM14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-16"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DN14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-17"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DO14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-18"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DP14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-19"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DQ14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-20"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DR14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-21"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DS14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-22"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DT14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-23"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DU14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-24"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DV14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-25"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DW14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-26"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DX14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-27"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DY14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-28"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(DZ14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-29"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(EA14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-30"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(EB14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-03-31"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(EC14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-01"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(ED14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-02"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(EE14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-03"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(EF14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-04"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(EG14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-05"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(EH14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-06"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(EI14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-07"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(EJ14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-08"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(EK14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-09"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(EL14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-10"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(EM14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-11"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(EN14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-12"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(EO14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-13"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(EP14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-14"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(EQ14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-15"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(ER14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-16"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(ES14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-17"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(ET14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-18"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(EU14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-19"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(EV14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-20"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(EW14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-21"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(EX14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-22"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(EY14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-23"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(EZ14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-24"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FA14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-25"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FB14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-26"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FC14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-27"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FD14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-28"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FE14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-29"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FF14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-04-30"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FG14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-01"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FH14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-02"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FI14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-03"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FJ14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-04"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FK14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-05"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FL14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-06"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FM14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-07"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FN14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-08"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FO14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-09"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FP14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-10"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FQ14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-11"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FR14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-12"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FS14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-13"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FT14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-14"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FU14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-15"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FV14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-16"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FW14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-17"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FX14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-18"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FY14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-19"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(FZ14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-20"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GA14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-21"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GB14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-22"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GC14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-23"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GD14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-24"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GE14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-25"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GF14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-26"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GG14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-27"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GH14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-28"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GI14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-29"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GJ14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-30"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GK14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-05-31"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GL14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-01"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GM14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-02"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GN14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-03"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GO14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-04"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GP14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-05"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GQ14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-06"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GR14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-07"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GS14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-08"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GT14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-09"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GU14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-10"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GV14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-11"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GW14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-12"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GX14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-13"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GY14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-14"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(GZ14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-15"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HA14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-16"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HB14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-17"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HC14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-18"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HD14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-19"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HE14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-20"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HF14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-21"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HG14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-22"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HH14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-23"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HI14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-24"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HJ14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-25"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HK14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-26"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HL14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-27"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HM14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-28"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HN14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-29"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HO14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-06-30"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HP14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-07-01"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HQ14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-07-02"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HR14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-07-03"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HS14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-07-04"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HT14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-07-05"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HU14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-07-06"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HV14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-07-07"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HW14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-07-08"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HX14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-07-09"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HY14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-07-10"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(HZ14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-07-11"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(IA14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-07-12"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(IB14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-07-13"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(IC14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-07-14"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(ID14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-07-15"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(IE14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-07-16"},{"$f":"IF(SUM(INDEX($AG:$AG,ROW()+5):$AG20)>=60,IF(AE18=\"\",AD18-((COLUMN(AO14)-COLUMN(IF14))*7),\"WEEK \"&COLUMN()-40),IF(AE18=\"\",AD18+COLUMN()-41,\"WD \"&COLUMN()-40))","v":"1900-07-17"}]
[null,null,null,null,null,null,null,null,null,"START",null,null,"END",null,null,"START",null,null,"END",null,null,null,null,null,null,null,null,null,null,"PRIOR TO CONST.","DURING CONSTRUCTION"]
[null,null,null,null,null,null,null,null,null,"STATION","OFFSET",null,"STATION","OFFSET",null,"STATION","OFFSET",null,"STATION","OFFSET",null,"EX","PR","EX","PR","EX","PR","EX","PR","CALENDAR DATE","PROJECT STAGE","HIGHWAY CONTRACT WORK COMPLETED"]
[null,null,null,null,null,null,null,null,null,null,"DIST","LOC",null,"DIST","LOC",null,"DIST","LOC",null,"DIST","LOC"]
[null,null,null,null,null,null,null,null,null,null,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":"AG18+AJ18","v":0},{"$f":"IF(AH18-1<0,0,AH18-1)","v":0},null,null,null,null,{"$f":"IF(COUNTIF(INDEX(AO:AO,ROW()+1):AO20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(AP:AP,ROW()+1):AP20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(AQ:AQ,ROW()+1):AQ20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(AR:AR,ROW()+1):AR20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(AS:AS,ROW()+1):AS20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(AT:AT,ROW()+1):AT20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(AU:AU,ROW()+1):AU20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(AV:AV,ROW()+1):AV20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(AW:AW,ROW()+1):AW20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(AX:AX,ROW()+1):AX20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(AY:AY,ROW()+1):AY20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(AZ:AZ,ROW()+1):AZ20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BA:BA,ROW()+1):BA20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BB:BB,ROW()+1):BB20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BC:BC,ROW()+1):BC20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BD:BD,ROW()+1):BD20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BE:BE,ROW()+1):BE20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BF:BF,ROW()+1):BF20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BG:BG,ROW()+1):BG20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BH:BH,ROW()+1):BH20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BI:BI,ROW()+1):BI20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BJ:BJ,ROW()+1):BJ20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BK:BK,ROW()+1):BK20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BL:BL,ROW()+1):BL20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BM:BM,ROW()+1):BM20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BN:BN,ROW()+1):BN20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BO:BO,ROW()+1):BO20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BP:BP,ROW()+1):BP20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BQ:BQ,ROW()+1):BQ20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BR:BR,ROW()+1):BR20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BS:BS,ROW()+1):BS20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BT:BT,ROW()+1):BT20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BU:BU,ROW()+1):BU20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BV:BV,ROW()+1):BV20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BW:BW,ROW()+1):BW20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BX:BX,ROW()+1):BX20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BY:BY,ROW()+1):BY20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(BZ:BZ,ROW()+1):BZ20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CA:CA,ROW()+1):CA20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CB:CB,ROW()+1):CB20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CC:CC,ROW()+1):CC20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CD:CD,ROW()+1):CD20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CE:CE,ROW()+1):CE20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CF:CF,ROW()+1):CF20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CG:CG,ROW()+1):CG20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CH:CH,ROW()+1):CH20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CI:CI,ROW()+1):CI20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CJ:CJ,ROW()+1):CJ20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CK:CK,ROW()+1):CK20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CL:CL,ROW()+1):CL20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CM:CM,ROW()+1):CM20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CN:CN,ROW()+1):CN20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CO:CO,ROW()+1):CO20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CP:CP,ROW()+1):CP20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CQ:CQ,ROW()+1):CQ20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CR:CR,ROW()+1):CR20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CS:CS,ROW()+1):CS20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CT:CT,ROW()+1):CT20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CU:CU,ROW()+1):CU20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CV:CV,ROW()+1):CV20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CW:CW,ROW()+1):CW20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CX:CX,ROW()+1):CX20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CY:CY,ROW()+1):CY20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(CZ:CZ,ROW()+1):CZ20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DA:DA,ROW()+1):DA20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DB:DB,ROW()+1):DB20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DC:DC,ROW()+1):DC20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DD:DD,ROW()+1):DD20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DE:DE,ROW()+1):DE20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DF:DF,ROW()+1):DF20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DG:DG,ROW()+1):DG20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DH:DH,ROW()+1):DH20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DI:DI,ROW()+1):DI20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DJ:DJ,ROW()+1):DJ20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DK:DK,ROW()+1):DK20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DL:DL,ROW()+1):DL20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DM:DM,ROW()+1):DM20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DN:DN,ROW()+1):DN20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DO:DO,ROW()+1):DO20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DP:DP,ROW()+1):DP20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DQ:DQ,ROW()+1):DQ20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DR:DR,ROW()+1):DR20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DS:DS,ROW()+1):DS20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DT:DT,ROW()+1):DT20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DU:DU,ROW()+1):DU20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DV:DV,ROW()+1):DV20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DW:DW,ROW()+1):DW20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DX:DX,ROW()+1):DX20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DY:DY,ROW()+1):DY20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(DZ:DZ,ROW()+1):DZ20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(EA:EA,ROW()+1):EA20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(EB:EB,ROW()+1):EB20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(EC:EC,ROW()+1):EC20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(ED:ED,ROW()+1):ED20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(EE:EE,ROW()+1):EE20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(EF:EF,ROW()+1):EF20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(EG:EG,ROW()+1):EG20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(EH:EH,ROW()+1):EH20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(EI:EI,ROW()+1):EI20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(EJ:EJ,ROW()+1):EJ20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(EK:EK,ROW()+1):EK20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(EL:EL,ROW()+1):EL20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(EM:EM,ROW()+1):EM20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(EN:EN,ROW()+1):EN20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(EO:EO,ROW()+1):EO20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(EP:EP,ROW()+1):EP20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(EQ:EQ,ROW()+1):EQ20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(ER:ER,ROW()+1):ER20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(ES:ES,ROW()+1):ES20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(ET:ET,ROW()+1):ET20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(EU:EU,ROW()+1):EU20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(EV:EV,ROW()+1):EV20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(EW:EW,ROW()+1):EW20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(EX:EX,ROW()+1):EX20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(EY:EY,ROW()+1):EY20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(EZ:EZ,ROW()+1):EZ20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FA:FA,ROW()+1):FA20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FB:FB,ROW()+1):FB20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FC:FC,ROW()+1):FC20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FD:FD,ROW()+1):FD20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FE:FE,ROW()+1):FE20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FF:FF,ROW()+1):FF20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FG:FG,ROW()+1):FG20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FH:FH,ROW()+1):FH20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FI:FI,ROW()+1):FI20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FJ:FJ,ROW()+1):FJ20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FK:FK,ROW()+1):FK20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FL:FL,ROW()+1):FL20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FM:FM,ROW()+1):FM20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FN:FN,ROW()+1):FN20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FO:FO,ROW()+1):FO20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FP:FP,ROW()+1):FP20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FQ:FQ,ROW()+1):FQ20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FR:FR,ROW()+1):FR20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FS:FS,ROW()+1):FS20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FT:FT,ROW()+1):FT20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FU:FU,ROW()+1):FU20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FV:FV,ROW()+1):FV20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FW:FW,ROW()+1):FW20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FX:FX,ROW()+1):FX20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FY:FY,ROW()+1):FY20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(FZ:FZ,ROW()+1):FZ20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GA:GA,ROW()+1):GA20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GB:GB,ROW()+1):GB20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GC:GC,ROW()+1):GC20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GD:GD,ROW()+1):GD20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GE:GE,ROW()+1):GE20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GF:GF,ROW()+1):GF20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GG:GG,ROW()+1):GG20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GH:GH,ROW()+1):GH20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GI:GI,ROW()+1):GI20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GJ:GJ,ROW()+1):GJ20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GK:GK,ROW()+1):GK20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GL:GL,ROW()+1):GL20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GM:GM,ROW()+1):GM20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GN:GN,ROW()+1):GN20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GO:GO,ROW()+1):GO20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GP:GP,ROW()+1):GP20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GQ:GQ,ROW()+1):GQ20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GR:GR,ROW()+1):GR20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GS:GS,ROW()+1):GS20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GT:GT,ROW()+1):GT20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GU:GU,ROW()+1):GU20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GV:GV,ROW()+1):GV20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GW:GW,ROW()+1):GW20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GX:GX,ROW()+1):GX20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GY:GY,ROW()+1):GY20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(GZ:GZ,ROW()+1):GZ20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HA:HA,ROW()+1):HA20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HB:HB,ROW()+1):HB20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HC:HC,ROW()+1):HC20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HD:HD,ROW()+1):HD20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HE:HE,ROW()+1):HE20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HF:HF,ROW()+1):HF20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HG:HG,ROW()+1):HG20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HH:HH,ROW()+1):HH20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HI:HI,ROW()+1):HI20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HJ:HJ,ROW()+1):HJ20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HK:HK,ROW()+1):HK20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HL:HL,ROW()+1):HL20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HM:HM,ROW()+1):HM20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HN:HN,ROW()+1):HN20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HO:HO,ROW()+1):HO20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HP:HP,ROW()+1):HP20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HQ:HQ,ROW()+1):HQ20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HR:HR,ROW()+1):HR20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HS:HS,ROW()+1):HS20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HT:HT,ROW()+1):HT20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HU:HU,ROW()+1):HU20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HV:HV,ROW()+1):HV20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HW:HW,ROW()+1):HW20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HX:HX,ROW()+1):HX20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HY:HY,ROW()+1):HY20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(HZ:HZ,ROW()+1):HZ20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(IA:IA,ROW()+1):IA20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(IB:IB,ROW()+1):IB20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(IC:IC,ROW()+1):IC20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(ID:ID,ROW()+1):ID20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(IE:IE,ROW()+1):IE20,1)>0,1,\"\")","v":""},{"$f":"IF(COUNTIF(INDEX(IF:IF,ROW()+1):IF20,1)>0,1,\"\")","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,{"$f":"IF(IF(LEFT(AO$14,1)=\"W\",IF(LEFT(AO$14,2)=\"WD\",AND(VALUE(RIGHT(AO$14,LEN(AO$14)-3))<=$AI19,VALUE(RIGHT(AO$14,LEN(AO$14)-3))>$AJ19),AND(VALUE(RIGHT(AO$14,LEN(AO$14)-5))-1<($AI19/5),VALUE(RIGHT(AO$14,LEN(AO$14)-5))>($AJ19/5))),AND($AD19<=AO$14,AO$14<WORKDAY($AD19,$AG19))),1,\"\")","v":""},{"$f":"IF(IF(LEFT(AP$14,1)=\"W\",IF(LEFT(AP$14,2)=\"WD\",AND(VALUE(RIGHT(AP$14,LEN(AP$14)-3))<=$AI19,VALUE(RIGHT(AP$14,LEN(AP$14)-3))>$AJ19),AND(VALUE(RIGHT(AP$14,LEN(AP$14)-5))-1<($AI19/5),VALUE(RIGHT(AP$14,LEN(AP$14)-5))>($AJ19/5))),AND($AD19<=AP$14,AP$14<WORKDAY($AD19,$AG19))),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(IF(LEFT(DB$14,1)=\"W\",IF(LEFT(DB$14,2)=\"WD\",AND(VALUE(RIGHT(DB$14,LEN(DB$14)-3))<=$AI19,VALUE(RIGHT(DB$14,LEN(DB$14)-3))>$AJ19),AND(VALUE(RIGHT(DB$14,LEN(DB$14)-5))-1<($AI19/5),VALUE(RIGHT(DB$14,LEN(DB$14)-5))>($AJ19/5))),AND($AD19<=DB$14,DB$14<WORKDAY($AD19,$AG19))),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(IF(LEFT(FN$14,1)=\"W\",IF(LEFT(FN$14,2)=\"WD\",AND(VALUE(RIGHT(FN$14,LEN(FN$14)-3))<=$AI19,VALUE(RIGHT(FN$14,LEN(FN$14)-3))>$AJ19),AND(VALUE(RIGHT(FN$14,LEN(FN$14)-5))-1<($AI19/5),VALUE(RIGHT(FN$14,LEN(FN$14)-5))>($AJ19/5))),AND($AD19<=FN$14,FN$14<WORKDAY($AD19,$AG19))),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(IF(LEFT(HZ$14,1)=\"W\",IF(LEFT(HZ$14,2)=\"WD\",AND(VALUE(RIGHT(HZ$14,LEN(HZ$14)-3))<=$AI19,VALUE(RIGHT(HZ$14,LEN(HZ$14)-3))>$AJ19),AND(VALUE(RIGHT(HZ$14,LEN(HZ$14)-5))-1<($AI19/5),VALUE(RIGHT(HZ$14,LEN(HZ$14)-5))>($AJ19/5))),AND($AD19<=HZ$14,HZ$14<WORKDAY($AD19,$AG19))),1,\"\")","v":""},"","","","","",""]
["X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(IF(LEFT(AO$14,1)=\"W\",IF(LEFT(AO$14,2)=\"WD\",AND(VALUE(RIGHT(AO$14,LEN(AO$14)-3))<=$AI20,VALUE(RIGHT(AO$14,LEN(AO$14)-3))>$AJ20),AND(VALUE(RIGHT(AO$14,LEN(AO$14)-5))-1<($AI20/5),VALUE(RIGHT(AO$14,LEN(AO$14)-5))>($AJ20/5))),AND($AD20<=AO$14,AO$14<WORKDAY($AD20,$AG20))),1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[]
[null,"END OF ATTACHMENT 7PR"]

{"sheet":"A-7PT","index":12,"n_rows":19,"n_cols":23,"rows_kept":19,"cut":false,"hidden":true,"merged":[[18,1,18,22],[11,22,13,22],[12,4,13,4],[12,5,12,6],[12,7,13,7],[12,8,12,9],[12,16,12,17],[11,11,13,11],[11,2,13,2],[4,1,4,22],[11,1,13,1],[11,3,13,3],[11,4,11,6],[11,7,11,9],[11,12,13,12],[11,13,13,13],[11,14,13,14],[11,15,11,17],[11,18,13,18],[11,10,13,10],[11,21,13,21],[11,19,13,19],[11,20,13,20],[5,1,5,12]]}
[]
[null,"PARTICIPANT JOINT USE COORDINATION"]
[null,"Attachment 7PT"]
[null,{"$f":"IF('Main Form'!$P$5 = \"\",\"\",'Main Form'!$P$5 & \" - \" &'Main Form'!$P$6)","v":""}]
[null,"The Utility Facility Owner's (OWNER) proposed utility work is dependent on or affected by the utility work of another utility owner(s) in a shared utility space. Dependent means that the shared utility space is occupied by, or the location is shared with utility facilities of another utility owner(s). Provide details of coordination with other utility owner(s) below and/or on attached sheets. In the CONTACT INFO column, include the contact information of the person/people that were coordinated with at the other utility owner(s). In the NARRATIVE column, include a brief description of the utility work by the other utility owner(s) and how it impacts the OWNER and the OWNER's schedule."]
[null,"• Import utility facilities from the attachment(s) for Question 5.\n• Fill in the rest of the table as the participant in the shared utility space."]
[null,"Job Aid (See §2.13)"]
[]
[]
[null,"Import Identified Coordinated Facilities"]
[]
[null,"COORDINATING ENTITY","COORDINATION BETWEEN PROVIDER AND PARTICIPANT COMPLETED","ALIGNMENT","START",null,null,"END",null,null,"OH/UG","FACILITY SIZE","FACILITY COMPONENT","FACILITY MATERIAL","UTILITY WORK PERFORMED","ANTICIPATED START DATE",null,null,"WORKING DAYS TO PERFORM","UTILITY WORK PERFORMED BY","NOTES FOR UCM","CONTACT INFO","NARRATIVE"]
[null,null,null,null,"STATION","OFFSET",null,"STATION","OFFSET",null,null,null,null,null,null,"PRIOR TO CONST.","DURING CONSTRUCTION"]
[null,null,null,null,null,"DIST","LOC",null,"DIST","LOC",null,null,null,null,null,"CALENDAR DATE","PROJECT STAGE","HIGHWAY CONTRACT WORK COMPLETED"]
[]
[]
["X"]
[]
[null,"END OF ATTACHMENT 7PT"]

{"sheet":"A-8","index":13,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":true,"merged":[[23,1,23,6],[4,1,4,6],[15,1,15,6],[17,1,18,1],[17,2,18,2],[17,3,17,5],[17,6,18,6],[7,1,7,6],[6,1,6,6],[12,1,12,6],[13,1,13,6]]}
[]
[null,"APPROVALS REQUIRED AND SCHEDULE TO OBTAIN APPROVALS"]
[null,"Attachment 8"]
[null,{"$f":"IF('Main Form'!$P$5 = \"\",\"\",'Main Form'!$P$5 & \" - \" &'Main Form'!$P$6)","v":""}]
[null,"Work plan approval and/or start work notice will be issued at least 30 calendar days prior to the Utility Facility Owner's (OWNER) anticipated start date. Identify and select all other approvals required for the OWNER's utility work and provide information about the schedule to obtain those approvals."]
[null,"• Fill in the following table of permits."]
[null,"• The dates below were drawn from the CALENDAR DATE, within the ANTICIPATED START DATE, on an attachment(s) from Question 5. These dates may be useful in completing the table below."]
[]
[null,{"$f":"IF(MIN('A-5A'!N:N)=0,\"5A - NA\",\"5A - \"&TEXT(MIN('A-5A'!N:N),\"mm/dd/yyyy\"))","v":"5A - NA"}]
[null,{"$f":"IF(MIN('A-5D'!P:P)=0,\"5D - NA\",\"5D - \"&TEXT(MIN('A-5D'!P:P),\"mm/dd/yyyy\"))","v":"5D - NA"}]
[null,{"$f":"IF(MIN('A-5R'!Z:Z)=0,\"5R - NA\",\"5R - \"&TEXT(MIN('A-5R'!Z:Z),\"mm/dd/yyyy\"))","v":"5R - NA"}]
[null,{"$f":"IF(MIN('A-5T'!Q:Q)=0,\"5T - NA\",\"5T - \"&TEXT(MIN('A-5T'!Q:Q),\"mm/dd/yyyy\"))","v":"5T - NA"}]
[null,"• The APPROVAL PRECEDES, within the ANTICIPATED SCHEDULE, is used when the APPROVAL DATE is unknown, however it is anticipated that the approval will precede the OWNER's start \n  date shown above. "]
[null,"• Any requests to change the OWNER's \"Anticipated Start Date\" on the attachment(s) for Question 5, due to a delay in an approval for any permit listed below, must be coordinated with the project \n  sponsor."]
[null,"Job Aid (See §2.14)"]
[]
[null,"Add Blank Row In Table"]
[null,"PERMIT","NAME OF APPROVING AUTHORITY","ANTICIPATED SCHEDULE",null,null,"NARRATIVE"]
[null,null,null,"APPROVAL PRECEDES","SUBMITTAL DATE","APPROVAL DATE"]
[]
[]
["X"]
[]
[null,"END OF ATTACHMENT 8"]

{"sheet":"A-9","index":14,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":true,"merged":[[38,1,38,8],[30,1,33,1],[30,2,33,2],[30,3,33,3],[4,1,5,8],[30,8,33,8],[30,4,30,7],[31,4,33,4],[32,6,32,7],[31,5,31,7]]}
[]
[null,"REAL ESTATE PARCELS REQUIRED"]
[null,"Attachment 9"]
[null,{"$f":"IF('Main Form'!$P$5 = \"\",\"\",'Main Form'!$P$5 & \" - \" &'Main Form'!$P$6)","v":""}]
[null,"Real estate parcels need to be acquired to enable the performance of the Utility Facility Owner's (OWNER) utility work. Provide details about the parcels listed below and/or on attached sheets.\nThe following items are required, whether performed by the OWNER or by others, to enable the utility work prior to or during highway construction:"]
[]
[null,"• Within the ITEM drop-down list, include description in the NARRATIVE column if \"Other\" is selected."]
[null,"• Enter either CALENDAR DATE or HIGHWAY CONTRACT WORK COMPLETED, not both."]
[null,"Job Aid (See §2.15)"]
[null,"NOTE: The following is provided to aid in completing the table below as the dropdown list under ITEM requires scrolling in order to view all options."]
[null,"ITEMS:","DESCRIPTIONS:"]
[null,"Real Estate Related Items"]
[null,"Removal of structures","Existing buildings, foundations, sheds or other structures"]
[null,"Removal of concrete/stone","Existing concrete or stone items, such as walls, columns, fencing, or retaining walls"]
[null,"Removal of crops","Existing food crops, such as grains, fruits, or vegetables"]
[null,"Removal of landscape features","Significant landscape features, such as decorative boulders, large berms, gardens, flower beds, and fountains"]
[null,"Removal of private utilities","Private utilities, such as septic tanks and fields, removal of well heads, and/or abandonment of wells"]
[null,"Removal/adjustment of drainage facilities","Field tile or other drainage facilities"]
[null,"Removal of poles/posts","Signs, flagpoles, lighting"]
[null,"Removal of trees","Tree removal and/or grubbing of stumps"]
[null,"Highway Construction Related Items"]
[null,"Grading","Grading, including removal, filling, and excavation"]
[null,"Removal of pavements","Existing private roadways, driveways, or parking improvements"]
[null,"Installation of structures","New structures, such as bridges, box culverts, sign bridges, or retaining walls"]
[null,"Installation of drainage facilities","New drainage facilities, such as the extension of a box culvert, a creek realignment, a temporary bypass channel, and installation of storm sewer"]
[null,"Installation of pavement","New roadway improvements, such as pavement, curb and gutter, and sidewalks"]
[null,"Installation of electrical and ancillary items","New roadway improvements, such as lighting, signals, ITS, and guardrail"]
[null,"Other Related Items"]
[null,"Other","Include real estate and highway construction related items that are not in the dropdown list. Provide description in NARRATIVE column."]
[null,"Add Blank Row In Table"]
[null,"RIGHT OF WAY PLAT OR EXHIBIT ID","PLAT / EXHIBIT APPROVAL OR LATEST REVISION DATE","PARCEL NUMBER","REMOVAL OR INSTALLATION",null,null,null,"NARRATIVE"]
[null,null,null,null,"ITEM","ANTICIPATED START DATE"]
[null,null,null,null,null,"PRIOR TO CONST.","DURING CONSTRUCTION"]
[null,null,null,null,null,"CALENDAR DATE","PROJECT STAGE","HIGHWAY CONTRACT WORK COMPLETED"]
[]
[]
["X"]
[]
[null,"END OF ATTACHMENT 9"]

{"sheet":"A-10","index":15,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":true,"merged":[[10,2,12,2],[11,3,12,3],[10,8,12,8],[4,1,4,12],[17,1,17,12],[9,12,12,12],[9,1,12,1],[9,10,12,10],[9,11,12,11],[9,9,12,9],[11,4,11,5],[11,6,11,7],[10,3,10,7],[9,2,9,8]]}
[]
[null,"EASEMENTS, FEE TITLE, AND/OR LONG-TERM LEASES"]
[null,"Attachment 10"]
[null,{"$f":"IF('Main Form'!$P$5 = \"\",\"\",'Main Form'!$P$5 & \" - \" &'Main Form'!$P$6)","v":""}]
[null,"Identify the easements, fee title, and/or long-term leases the Utility Facility Owner (OWNER) needs to obtain to complete the utility work. Describe the location where the land interests and/or rights are needed, using reference to plat parcel numbers, project stationing, or addresses."]
[null,"• Fill in the following table of easements, fee title, and/or long-term leases to the extent known at time of worksheet submittal."]
[null,"Job Aid (See §2.16)"]
[]
[null,"Add Blank Row In Table"]
[null,"LAND INTEREST REQUIRED","LOCATION",null,null,null,null,null,null,"APPROXIMATE WIDTH","ANTICIPATED ACQUISITION DATE","REASON FOR ACQUISITION","NARRATIVE"]
[null,null,"BY PARCEL NUMBER","BY STATIONING",null,null,null,null,"BY ADDRESS"]
[null,null,null,"ACQUISITION ALIGNMENT","APPROXIMATE START",null,"APPROXIMATE END"]
[null,null,null,null,"STATION","LOC","STATION","LOC"]
[]
[]
["X"]
[]
[null,"END OF ATTACHMENT 10"]