{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["LPA Schedule Tool","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":"LPA Schedule Tool","index":0,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[[28,1,28,2],[28,5,28,6],[12,1,12,2],[13,1,13,2],[0,5,0,6],[8,1,8,2],[9,1,9,2],[11,1,11,2],[10,1,10,2],[3,1,3,2],[2,1,2,2],[1,1,1,2],[5,1,5,2],[4,1,4,2]]}
["LPA Project Design Schedule Tool",null,null,null,null,{"$f":"TODAY()","v":"2024-06-04"}]
["Sponsor",null,null,null,"Environment Complexity Checklist","Yes ","No"]
["County ",null,null,null,"Real Estate > 0.5 acres"]
["Roadway/ Structure ID",null,null,null,"Curb Ramps in Project Limits"]
["Project Limits",null,null,null,"Roadway/ Structure Widening"]
["Project Length",null,null,null,"Project to Impact Public Land"]
["AADT Traffic Count/ Count Year",null,null,null,"Excavation Deeper than 2ft"]
["Program Cycle (Start/ End Year)",null,null,null,"Historical Property in Limits"]
["Project Type","Bridge Replacement ",null,{"$f":"_xlfn.XLOOKUP(B9,Data!A5:A15,Data!B5:B15,,0)","v":2},"Archeological Site in Limits"]
["Design Funding (Estimated Cost)","Yes under $200k",null,{"$f":"_xlfn.XLOOKUP(B10,Data!H5:H9,Data!I5:I9)","v":3},"Project to Impact Floodplain"]
["Real Estate","None",null,{"$f":"_xlfn.XLOOKUP(B11,Data!N4:N11,Data!O4:O11)","v":0},"Hazardous Material Open Site"]
["Railroad ","None within 1000 ft",null,{"$f":"_xlfn.XLOOKUP(B12,Data!Q5:Q9,Data!R5:R9)","v":0},"Endangered Species Mitigation"]
["Utility Timeline",{"$f":"B9","v":"Bridge Replacement "},null,{"$f":"_xlfn.XLOOKUP(B13,Data!A5:A15,Data!C5:C15,,0)","v":2},"Wetland or Waterway Impacts"]
["Environmental Complexity ",{"$f":"Data!L25","v":"Low "},null,{"$f":"_xlfn.XLOOKUP(B14,Data!K5:K8,Data!L5:L8,,0)","v":4},"Public Concerns with Project "]
["Minimum Project Timeline ",{"$f":"SUM(D9,D10,D14,LARGE(D11:D13,1),3)","v":14},"Months",null,"Other Project Concerns"]
[]
["Recommended Schedule","Deadline",null,"Start","Schedule Feasibility  Check (Do not use.)"]
["SMA & Authorization Approved",{"$f":"EDATE($B$25,-($B$15))","v":"2024-12-01"},null,{"$f":"EDATE(B18,-1)","v":"2024-11-01"},"SMA & Authorization Approved",{"$f":"EDATE(NOW(),1)","v":"2024-07-04"}]
["Consultant Selection (DT1515) ",{"$f":"IF($D$10=0,\"N/A\",EDATE($B$18,$D$10/2))","v":"2025-01-01"},null,{"$f":"EDATE(B19,-1)","v":"2024-12-01"},"Consultant Selection (DT1515) ",{"$f":"IF($D$10=0,\"N/A\",EDATE($F$20,-2))","v":"2024-08-04"}]
["Design Contract Authorized",{"$f":"EDATE($B$18,$D$10)","v":"2025-03-01"},null,{"$f":"EDATE(B20,-D10)","v":"2024-12-01"},"Design Contract Authorized",{"$f":"EDATE($F$18,$D$10)","v":"2024-10-04"}]
["Environmental Document Signed",{"$f":"EDATE($B$20,($D$14))","v":"2025-07-01"},null,{"$f":"EDATE(B21,-D14)","v":"2025-03-01"},"Environmental Document Signed",{"$f":"EDATE($F$20,($D$14))","v":"2025-02-04"}]
["Design Study Report Signed",{"$f":"EDATE($B$21,($D$9))","v":"2025-09-01"},null,{"$f":"EDATE(B22,-D9)","v":"2025-07-01"},"Design Study Report Signed",{"$f":"EDATE($F$21,($D$9))","v":"2025-04-04"}]
["Plat Recorded/ Real Estate Start",{"$f":"IF($D$11>0,EDATE($B$24,(-($D$11))),\"N/A\")","v":"N/A"},null,{"$f":"EDATE(B23,-D11)","v":{"$error":"#VALUE!"}},"Plat Recorded/ Real Estate Start",{"$f":"IF($D$11>0,EDATE($F$24,(-($D$11))),\"N/A\")","v":"N/A"}]
["PSE",{"$f":"EDATE($B$22,LARGE(D11:D13,1))","v":"2025-11-01"},null,{"$f":"EDATE(B24,-(LARGE(D11:D13,1)))","v":"2025-09-01"},"Earliest PSE",{"$f":"EDATE($F$22,LARGE($D$11:$D$13,1))","v":"2025-06-04"}]
["Recommended Letting",{"$f":"EDATE(D26,-3)","v":"2026-02-01"},null,{"$f":"EDATE(B25,-3)","v":"2025-11-01"},"Earliest Letting ",{"$f":"EDATE($F$18,$B$15)","v":"2025-09-04"}]
["Construction Year",2026,null,{"$f":"_xlfn.XLOOKUP(B26,Data!T5:T16, Data!U5:U16)","v":"2026-05-01"}]
[]
["User Instructions "]
["Manual Entry for Blue Cells",null,null,null,"Select from List for Orange Cells"]
["Check Box in Gray Cells",null,null,null,"Schedule not feasible"]

{"sheet":"Data","index":1,"n_rows":25,"n_cols":21,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Data "]
[]
[null,null,"Utility Timeline"]
["Project Type","Months","Months",null,"Program","Months",null,"Design Contract Included","Months",null,"Environmental Complexity ","Months",null,"Real Estate","Months",null,"Railroad ","Months",null,"Construction Year ","Base"]
["Bridge Rehabilitation",2,2,null,"STP 205 Bridge",2,null,"None",0,null,"Low ",4,null,"None",0,null,"None within 1000 ft",0,null,2025,"2025-05-01"]
["Bridge Replacement ",2,2,null,"STP 206 Local",2,null,"Yes under $200k",3,null,"Medium ",6,null,"Temporary Interest Only",12,null,"Near Project (in 1000ft)",6,null,2026,"2026-05-01"]
["Resurfacing",2,2,null,"STP 206 Rural ",2,null,"Yes $200k to $1million",5,null,"High",9,null,"Less than 1/2 acre",12,null,"In Project Limits",12,null,2027,"2027-05-01"]
["Pavement Replacement ",2,2,null,"STP 206 Urban",4,null,"Yes over $1million",8,null,"Extreme",12,null,"More than 1/2 acre",15,null,"Signal or Crossing Work",24,null,2028,"2028-05-01"]
["Recondition",4,4,null,"STP 206 Urban in MPO",6,null,null,null,null,null,null,null,"Large Parcels",18,null,null,null,null,2029,"2029-05-01"]
["Reconstruction",6,5,null,"HSIP/ HRRR",2,null,null,null,null,{"$f":"'LPA Schedule Tool'!E3","v":"Real Estate > 0.5 acres"},false,{"$f":"IF(L10=TRUE,2,0)","v":0},"Parklands",18,null,null,null,null,2030,"2030-05-01"]
["Expansion",12,6,null,"TAP ",3,null,null,null,null,{"$f":"'LPA Schedule Tool'!E4","v":"Curb Ramps in Project Limits"},false,{"$f":"IF(L11=TRUE,1,0)","v":0},"Relocation",24,null,null,null,null,2031,"2031-05-01"]
["Major Project",12,9,null,"TEA ",3,null,null,null,null,{"$f":"'LPA Schedule Tool'!E5","v":"Roadway/ Structure Widening"},false,0,null,null,null,null,null,null,2032,"2032-05-01"]
["Signal/ Signage",2,2,null,"CMAQ",3,null,null,null,null,{"$f":"'LPA Schedule Tool'!E6","v":"Project to Impact Public Land"},false,{"$f":"IF(L13=TRUE,1,0)","v":0},null,null,null,null,null,null,2033,"2033-05-01"]
["Trail/ Pedestrian",3,3,null,null,null,null,null,null,null,{"$f":"'LPA Schedule Tool'!E7","v":"Excavation Deeper than 2ft"},false,0,null,null,null,null,null,null,2034,"2034-05-01"]
["Other",3,3,null,null,null,null,null,null,null,{"$f":"'LPA Schedule Tool'!E8","v":"Historical Property in Limits"},false,0,null,null,null,null,null,null,2035,"2035-05-01"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'LPA Schedule Tool'!E9","v":"Archeological Site in Limits"},false,0]
["Preferred PSE ",null,null,null,null,null,null,null,null,null,{"$f":"'LPA Schedule Tool'!E10","v":"Project to Impact Floodplain"},false,0]
["May ",null,null,null,null,null,null,null,null,null,{"$f":"'LPA Schedule Tool'!E11","v":"Hazardous Material Open Site"},false,0]
["August ",null,null,null,null,null,null,null,null,null,{"$f":"'LPA Schedule Tool'!E12","v":"Endangered Species Mitigation"},false,0]
["November",null,null,null,null,null,null,null,null,null,{"$f":"'LPA Schedule Tool'!E13","v":"Wetland or Waterway Impacts"},false,0]
["February ",null,null,null,null,null,null,null,null,null,{"$f":"'LPA Schedule Tool'!E14","v":"Public Concerns with Project "},false,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'LPA Schedule Tool'!E15","v":"Other Project Concerns"},false,{"$f":"IF(L22=TRUE,2,0)","v":0}]
[]
["Start date cell turns red if it is less that todays date up at the top of main page"]
[null,null,null,null,null,null,null,null,null,null,"Complexity Scale",{"$f":"IF(M25>8,K8,IF(M25>4,K7,IF(M25>1,K6,K5)))","v":"Low "},{"$f":"SUM(M10:M22)","v":0}]