{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Detailed Scoping","Supporting Tables","Basic Scoping","CPM Project Field Review","Equations"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":85,"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":"Instructions","index":0,"n_rows":90,"n_cols":49,"rows_kept":90,"cut":false,"hidden":false,"merged":[[18,14,18,18],[14,14,14,18],[16,14,16,18],[24,0,24,11],[10,0,10,11],[12,0,12,11],[20,0,20,9],[20,10,20,11]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38]
[]
[]
[]
["MDOT Scoping Checklist",null,null,null,null,null,null,null,null,null,"2026-01-13","Version 1.0"]
[]
["General",null,null,null,null,null,null,null,null,null,null,null,null,"Scoping Checklist Selection"]
[]
["This interactive spreadsheet includes the scoping checklists for Road and Bridge which can be accessed through the selections to the right. To utilize this spreadsheet, first ensure that Macros are enabled, then select the Edit Sheet to input information."]
[]
["Things to note:"]
[null," - Forms will appear as separate worksheets within this file and will generate when users make required selections."]
[null,"    Refer to worksheet instructions below for further information."]
[]
[null," - Cells shaded light blue denote a cell that requires user input"]
[]
[null," - Cells shaded light green denote cells that customize the number of rows in certain tables"]
[]
["If you require assistance accessing this information or require it in an alternative format, contact the Michigan Department of Transportation’s (MDOT) Americans with Disabilities Act (ADA) coordinator ",null,null,null,null,null,null,null,null,null,"Michigan.gov/MDOT-ADA"]
[]
["Scoping Checklist Worksheet Instructions"]
[]
["Note: Full instructions for the information to be placed in these spreadsheets is located in the MDOT Scoping Manual. The following instructions are detailed for the functionality of the spreadsheet."]
[]
[" -","Upon opening file, ensure that macros have been enabled by selecting the \"Enable Content\" button as shown below:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" -","On the Instructions tab of this worksheet, select the applicable Scoping Checklist"]
[]
[]
[]
[]
[]
[" -","On the selected Checklist tab that opens, select the \"Edit Sheet\" button prior to inputting information"]
[]
[]
[]
[]
[]
[" -","For the Road R&R Checklist, select the \"Route Type\" and \"Route Characteristics\" then select the \"Filter Group\" Button from the MDOT Ribbon. "]
[null,"This will filter sections in the checklist based on the specific inputs. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" -","Expandable tables will have a light green cell to the right of the table. Input the number of rows required for the particilar table."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["-","Expandable sections will have a \"+\" sign on the left side of the screen. Selet the \"+\" symbol to expand the section."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["-","Collapsable sections will have a \"-\" sign on the left side of the screen. Selet the \"-\" symbol to collapse the section."]

{"sheet":"Detailed Scoping","index":1,"n_rows":541,"n_cols":13,"rows_kept":541,"cut":false,"hidden":true,"merged":[[539,10,540,11],[512,5,513,6],[514,5,514,6],[515,5,515,6],[0,1,0,11],[2,3,2,5],[2,7,2,8],[2,10,2,11],[3,3,3,5],[3,7,3,8],[3,10,3,11],[10,3,10,4],[10,8,10,9],[12,3,14,11],[16,3,17,11],[19,3,19,4],[19,5,19,6],[19,7,19,8],[19,9,19,10],[5,1,5,11],[7,3,7,4],[7,8,7,9],[8,3,8,4],[8,8,8,9],[9,3,9,4],[9,8,9,9],[20,3,20,4],[20,5,20,6],[20,7,20,8],[20,9,20,10],[22,3,22,4],[22,5,22,6],[22,7,22,8],[22,9,22,10],[26,12,27,12],[28,3,28,4],[28,8,28,11],[29,3,29,4],[29,8,29,11],[23,3,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[25,3,25,5],[36,4,36,5],[36,10,36,11],[37,4,37,5],[37,10,37,11],[38,12,39,12],[40,4,40,5],[40,6,40,8],[40,9,40,11],[32,12,33,12],[34,4,34,5],[34,10,34,11],[35,4,35,5],[35,10,35,11],[44,3,47,11],[70,1,70,11],[72,3,75,11],[77,6,77,11],[78,6,78,11],[79,6,79,11],[41,4,41,5],[41,6,41,8],[41,9,41,11],[42,4,42,5],[42,6,42,8],[42,9,42,11],[49,1,49,11],[51,3,54,11],[56,1,56,11],[58,3,61,11],[63,1,63,11],[65,3,68,11],[86,12,87,12],[87,5,87,6],[87,9,88,11],[89,9,89,11],[90,9,90,11],[91,9,91,11],[80,6,80,11],[81,6,81,11],[82,6,82,11],[83,6,83,11],[84,6,84,11],[86,3,86,11],[98,9,98,11],[100,1,100,11],[102,3,105,11],[107,6,107,11],[108,6,108,11],[109,6,109,11],[93,3,93,11],[93,12,94,12],[94,5,94,6],[94,9,95,11],[96,9,96,11],[97,9,97,11],[116,6,116,11],[117,6,117,11],[119,1,119,11],[120,1,121,2],[120,3,121,4],[120,5,121,5],[120,6,121,6],[120,7,121,11],[110,6,110,11],[111,6,111,11],[112,6,112,11],[113,6,113,11],[114,6,114,11],[115,6,115,11],[125,1,125,11],[126,1,127,2],[126,3,127,4],[126,5,127,5],[126,6,127,6],[126,7,127,11],[120,12,121,12],[122,1,122,2],[122,3,122,4],[122,7,122,11],[123,1,123,2],[123,3,123,4],[123,7,123,11],[131,1,131,11],[133,1,133,2],[133,3,135,3],[133,4,135,4],[133,5,135,11],[133,12,134,12],[126,12,127,12],[128,1,128,2],[128,3,128,4],[128,7,128,11],[129,1,129,2],[129,3,129,4],[129,7,129,11],[144,12,145,12],[145,1,145,2],[145,3,145,4],[145,5,145,6],[145,7,146,11],[136,5,136,11],[137,5,137,11],[138,12,139,12],[139,1,139,2],[139,4,139,5],[139,6,140,11],[147,7,147,11],[148,7,148,11],[149,7,149,11],[152,1,153,2],[152,3,152,11],[153,3,154,11],[141,6,141,11],[142,6,142,11],[143,6,143,11],[163,12,164,12],[165,1,165,2],[165,5,165,6],[165,7,165,11],[154,12,155,12],[156,1,156,2],[156,5,156,11],[157,5,157,11],[158,5,158,11],[159,12,160,12],[160,1,161,2],[160,6,160,7],[160,8,161,11],[166,5,166,6],[166,7,166,11],[167,5,167,6],[167,7,167,11],[169,1,169,11],[171,3,174,11],[162,6,162,7],[162,8,162,11],[163,6,163,7],[163,8,163,11],[182,6,182,11],[183,6,183,11],[184,6,184,11],[185,6,185,11],[186,6,186,11],[187,6,187,11],[176,6,176,11],[177,6,177,11],[178,6,178,11],[179,6,179,11],[180,6,180,11],[181,6,181,11],[192,2,192,3],[192,10,192,11],[193,2,193,3],[193,10,193,11],[194,1,194,11],[196,3,199,11],[189,1,189,11],[189,12,190,12],[190,2,190,3],[190,10,190,11],[191,2,191,3],[191,10,191,11],[207,6,207,11],[208,6,208,11],[209,6,209,11],[210,6,210,11],[211,6,211,11],[212,12,213,12],[201,6,201,11],[202,6,202,11],[203,6,203,11],[204,6,204,11],[205,6,205,11],[206,6,206,11],[216,3,216,5],[216,6,216,11],[218,1,218,11],[220,3,223,11],[225,6,225,11],[226,6,226,11],[213,3,213,5],[213,6,213,11],[214,3,214,5],[214,6,214,11],[215,3,215,5],[215,6,215,11],[233,6,233,11],[234,6,234,11],[235,6,235,11],[236,6,236,11],[238,6,238,11],[239,12,240,12],[240,9,241,9],[240,10,241,11],[227,6,227,11],[228,6,228,11],[229,6,229,11],[230,6,230,11],[231,6,231,11],[232,6,232,11],[242,1,242,2],[242,3,242,4],[242,10,242,11],[243,1,243,2],[243,3,243,4],[243,10,243,11],[240,1,241,2],[240,3,241,4],[240,5,241,5],[240,6,241,6],[240,7,241,7],[240,8,241,8],[256,6,256,11],[257,6,257,11],[258,6,258,11],[259,6,259,11],[260,6,260,11],[262,1,262,11],[245,1,245,11],[247,3,250,11],[252,6,252,11],[253,6,253,11],[254,6,254,11],[255,6,255,11],[262,12,263,12],[263,1,263,3],[263,4,263,5],[263,6,263,8],[263,9,263,11],[264,1,264,3],[264,4,264,5],[264,6,264,8],[264,9,264,11],[274,6,274,11],[275,6,275,11],[276,6,276,11],[277,6,277,11],[278,6,278,11],[279,6,279,11],[265,1,265,3],[265,4,265,5],[265,6,265,8],[265,9,265,11],[267,1,267,11],[269,3,272,11],[288,1,288,11],[290,3,293,11],[295,6,295,11],[296,6,296,11],[297,6,297,11],[298,6,298,11],[280,6,280,11],[281,6,281,11],[282,6,282,11],[283,6,283,11],[284,6,284,11],[285,6,285,11],[316,6,316,11],[317,6,317,11],[318,6,318,11],[319,6,319,11],[320,6,320,11],[321,6,321,11],[299,6,299,11],[300,6,300,11],[302,3,305,11],[308,1,308,11],[310,3,313,11],[315,6,315,11],[324,12,325,12],[326,1,326,2],[326,6,326,8],[326,9,326,11],[327,1,327,2],[327,6,327,8],[327,9,327,11],[323,1,323,11],[324,1,325,2],[324,3,325,3],[324,4,325,4],[324,5,325,5],[324,6,325,8],[324,9,325,11],[341,6,341,11],[342,6,342,11],[343,6,343,11],[344,6,344,11],[345,6,345,11],[347,1,347,11],[330,1,330,11],[332,3,335,11],[337,6,337,11],[338,6,338,11],[339,6,339,11],[340,6,340,11],[350,1,350,3],[350,4,350,5],[350,6,350,8],[350,9,350,11],[352,1,352,11],[354,3,357,11],[347,12,348,12],[348,1,348,3],[348,4,348,5],[348,6,348,8],[348,9,348,11],[349,1,349,3],[349,4,349,5],[349,6,349,8],[349,9,349,11],[365,6,365,11],[366,6,366,11],[367,6,367,11],[368,6,368,11],[369,12,370,12],[370,3,370,5],[370,6,370,11],[373,12,374,12],[359,6,359,11],[360,6,360,11],[361,6,361,11],[362,6,362,11],[363,6,363,11],[364,6,364,11],[375,3,375,5],[375,6,375,11],[376,3,376,5],[376,6,376,11],[378,1,378,11],[380,3,383,11],[371,3,371,5],[371,6,371,11],[372,3,372,5],[372,6,372,11],[374,3,374,5],[374,6,374,11],[392,1,392,11],[394,3,397,11],[399,6,399,11],[400,6,400,11],[401,6,401,11],[402,6,402,11],[385,6,385,11],[386,6,386,11],[387,6,387,11],[388,6,388,11],[389,6,389,11],[390,6,390,11],[418,6,418,11],[419,6,419,11],[420,6,420,11],[421,5,421,11],[423,1,423,11],[425,6,425,11],[403,6,403,11],[404,6,404,11],[406,6,406,11],[408,1,408,11],[410,3,413,11],[415,1,415,11],[432,6,432,11],[433,6,433,11],[434,6,434,11],[435,6,435,11],[437,1,437,11],[439,3,442,11],[426,6,426,11],[427,6,427,11],[428,6,428,11],[429,6,429,11],[430,6,430,11],[431,6,431,11],[450,6,450,11],[451,6,451,11],[452,6,452,11],[453,6,453,11],[454,6,454,11],[507,12,508,12],[455,6,455,11],[444,6,444,11],[445,6,445,11],[446,6,446,11],[447,6,447,11],[448,6,448,11],[449,6,449,11],[468,6,468,11],[469,6,469,11],[470,6,470,11],[471,6,471,11],[472,6,472,11],[474,1,474,11],[456,6,456,11],[457,6,457,11],[458,6,458,11],[460,1,460,11],[462,3,465,11],[467,6,467,11],[486,6,486,11],[487,12,488,12],[488,3,488,5],[488,6,488,8],[488,9,488,11],[489,3,489,5],[489,6,489,8],[489,9,489,11],[476,3,479,11],[481,6,481,11],[482,6,482,11],[483,6,483,11],[484,6,484,11],[485,6,485,11],[502,6,502,11],[503,6,503,11],[504,6,504,11],[505,6,505,11],[490,3,490,5],[490,6,490,8],[490,9,490,11],[492,1,492,11],[494,3,497,11],[499,6,499,11],[536,6,536,11],[537,6,537,11],[528,6,528,11],[529,6,529,11],[530,6,530,11],[531,6,531,11],[532,6,532,11],[533,6,533,11],[517,1,517,11],[519,3,522,11],[524,6,524,11],[525,6,525,11],[526,6,526,11],[527,6,527,11],[514,1,514,2],[515,1,515,2],[515,3,515,4],[514,3,514,4],[514,7,514,8],[515,7,515,8],[514,9,514,11],[515,9,515,11],[535,6,535,11],[31,3,31,4],[31,8,31,11],[30,3,30,4],[30,8,30,11],[512,7,513,8],[512,9,513,11],[512,1,513,2],[512,3,513,4],[512,12,513,12],[507,9,508,11],[509,1,509,2],[509,3,509,4],[509,9,509,11],[510,1,510,2],[510,3,510,4],[510,9,510,11],[507,1,508,2],[507,3,508,4],[507,5,508,5],[507,6,508,6],[507,7,508,7],[507,8,508,8],[500,6,500,11],[501,6,501,11]]}
[null,"Statewide Scoping Package Master Checklist"]
[]
[null,null,"Scoped By:",null,null,null,"Unit:",null,null,"Date:"]
[null,null,"QC By:",null,null,null,"Unit:",null,null,"Date:"]
[]
[null,"Project Information\n(Scoping Manual Section 3.2)"]
[]
[null,null,"Job Number:",null,null,null,null,"Primary Funding Template:"]
[null,null,"Route:",null,null,null,null,"Alternate Funding Template:"]
[null,null,"NHS:","Select",null,null,null,"Roadway Functional Class:","Select"]
[null,null,"Work Type:","Select",null,null,null,"Route Characteristics:","Select"]
[]
[null,null,"Project Objective:"]
[]
[]
[]
[null,null,"Proposed Fix:"]
[]
[]
[null,null,"Cost Data:","Construction Cost",null,"PE Cost",null,"CE Cost",null,"ROW Cost"]
[]
[]
[null,null,"Additional Costs:","EPE",null,"Utilities"]
[]
[]
[null,null,"Programming Cost:",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Number of CS Locations"]
[null,null,"Control Section"]
[null,null,"Location:","Control Section",null,"CS BMP","CS EMP","Length","Comments",null,null,null,2]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Total",{"$f":"SUM(OFFSET($H$30,0,0,ROW($G$32)-ROW($H$30),1))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Number of Programming Lines"]
[null,null,"Programming"]
[null,null,"Location:","CS #","PR #",null,"Major","PR BMP","PR EMP","Length","Route / Comments",null,2]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Total =",{"$f":"SUM(OFFSET($J$36,0,0,ROW($I$38)-ROW($J$36),1))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Number of As Builts"]
[]
[null,null,"As-Builts:","Year","Fix Type",null,"Limits",null,null,"ProjectWise Location",null,null,2]
[]
[]
[]
[null,null,"Project Background/"]
[null,null,"General Info/"]
[null,null,"System Planning"]
[]
[]
[null,"Coordination with Bridge Engineer and/or Ancillary Structures Unit \n(Scoping Manual Section 3.1.5)"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,"Coordination with Operations\n(Scoping Manual Section 3.1.5)"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,"Coordination with Traffic and Safety\n(Scoping Manual Section 3.1.5)"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,"Pavement/Geotech\n(Scoping Manual Section 3.3)"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Comments"]
[null,null,null,null,"Life Cycle Cost Analysis (LCCA) Anticipated?"]
[null,null,null,null,"Proposed Detail 7 Joint Repairs?"]
[null,null,null,null,"Proposed Detail 8 Joint Repairs?"]
[null,null,null,null,"Proposed Concrete Pavement Repair?"]
[null,null,null,null,"Known Settlement?"]
[null,null,null,null,"Poor Soil Conditions?"]
[null,null,null,null,"Slope Stability Issues?"]
[]
[null,null,"Pavement Section:","Existing",null,null,null,null,null,null,null,null,"Number of Existing"]
[null,null,null,"HMA","Concrete","Composite",null,"Agg Base","Subbase","Comments"]
[null,null,null,"(in)","(in)","HMA (in)","Conc (in)","(in)","(in)",null,null,null,3]
[]
[]
[]
[]
[null,null,null,"Proposed",null,null,null,null,null,null,null,null,"Number of Propsed"]
[null,null,null,"HMA","Concrete","Composite",null,"Agg Base","Subbase","Comments"]
[null,null,null,"(in)","(in)","HMA (in)","Conc (in)","(in)","(in)",null,null,null,3]
[]
[]
[]
[]
[null,"Geometrics\n(Scoping Manual Section 3.4)"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Comments"]
[null,null,null,null,"Normal Crown Cross Slope Modifications?"]
[null,null,null,null,"Superelevation Modifications?"]
[null,null,null,null,"Horizontal Curve Modifications?"]
[null,null,null,null,"Vertical Curve Modifications?"]
[null,null,null,null,"Design Exceptions/Variances Anticipated?"]
[null,null,null,null,"National Truck Network Impacts?"]
[null,null,null,null,"Existing Auxiliary Lanes?"]
[null,null,null,null,"Proposed Auxiliary Lanes?"]
[null,null,null,null,"Existing Exit/Entrance Ramps?"]
[null,null,null,null,"Proposed Exit/Entrance Ramps?"]
[]
[null,"Auxiliary Lane Information Table"]
[null,"Lane Type",null,"Location",null,"Existing/ Prop?","Taper Mods?","Proposed Work/Comments",null,null,null,null,"Number of Aux Lanes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[null,"Exit & Entrance Ramp Information Table"]
[null,"Ramp Type",null,"Location",null,"Existing/ Prop?","Taper Mods?","Proposed Work/Comments",null,null,null,null,"Number of Ramps"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[null,"Geometric Design Element Summary"]
[]
[null,"Design Speed:",null,"Posted Speed (mph)","Design Speed (mph)","Comments",null,null,null,null,null,null,"Number of Design Speed"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Number of Lane Width"]
[null,"Lane Width:",null,"# Lanes","Width",null,"Comments"]
[null,null,null,"(Ea)","Ex (Ft)","Pr (Ft)",null,null,null,null,null,null,3]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Number of Shoulder Width"]
[null,"Shoulder Width:",null,"Left",null,"Right",null,"Comments"]
[null,null,null,"Total (Ft)","Paved (Ft)","Total (Ft)","Paved (Ft)",null,null,null,null,null,3]
[]
[]
[]
[]
[]
[null,"Stopping Sight Distance:",null,"Comments"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Number of Cross Slope"]
[]
[null,"Cross Slope:",null,"Existing","Proposed","Comments",null,null,null,null,null,null,2]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Number of Super El"]
[null,"Superelevation & Curve Radius:",null,"Radius","Ex Super","Pr Super","Location",null,"Comments"]
[null,null,null,"(Ft)",null,null,null,null,null,null,null,null,2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Number of Vert Clearance"]
[]
[null,"Vertical Clearance:",null,"Existing","Proposed","Location",null,"Comments",null,null,null,null,2]
[]
[]
[]
[null,"Guardrail or Median Barrier\n(Scoping Manual Section 3.4.4)"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Comments"]
[null,null,null,null,"Existing Guardrail?"]
[null,null,null,null,"Guardrail Replacements?"]
[null,null,null,null,"Guardrail Height Adjustments?"]
[null,null,null,null,"Guardrail Extensions?"]
[null,null,null,null,"Guardrail Relap for MOT?"]
[null,null,null,null,"Existing Median Barrier?"]
[null,null,null,null,"Proposed Median Barrier?"]
[null,null,null,null,"Existing Glare Screen?"]
[null,null,null,null,"Proposed Glare Screen?"]
[null,null,null,null,"Existing Attenuators?"]
[null,null,null,null,"Proposed Attenuators?"]
[]
[null,"Guardrail Information Table",null,null,null,null,null,null,null,null,null,null,"Number of Guardrail Runs"]
[null,"Run #","location",null,"Type","Condition","Replace?","Adjust?","Extend?","Relap?","Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[null,"Safety\n(Scoping Manual Section 3.5)"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Comments"]
[null,null,null,null,"Crash Analysis Included?"]
[null,null,null,null,"Time of Return analysis Required?"]
[null,null,null,null,"Existing Road Safety Audit?"]
[null,null,null,null,"Proposed Road Safety Audit?"]
[null,null,null,null,"Highway Safety Analysis?"]
[null,null,null,null,"Performance Based Practical Design Considered?"]
[null,null,null,null,"Access Management Opportunities?"]
[null,null,null,null,"Existing Shared Drives?"]
[null,null,null,null,"Drive Closures?"]
[null,null,null,null,"Existing Cross-Use Agreements?"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Number of Existing"]
[null,null,"Access","Sta/Address",null,null,"Comment/Treatment (Shared Drive, Cross Use, Close Drive, etc.)"]
[null,null," Management:",null,null,null,null,null,null,null,null,null,3]
[]
[]
[]
[null,"Permanent Traffic Items Section\n(Scoping Manual Section 3.6)"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Comments"]
[null,null,null,null,"Replace Permanent Signing?"]
[null,null,null,null,"Replace Permanent Pavement Markings?"]
[null,null,null,null,"Recessed Pavement Markings?"]
[null,null,null,null,"New Signals?"]
[null,null,null,null,"Modernize Existing Signals?"]
[null,null,null,null,"Underclearance Issues?"]
[null,null,null,null,"Pedestrian Signals?"]
[null,null,null,null,"Pedestrian Push Buttons?"]
[null,null,null,null,"ADA Ramps?"]
[null,null,null,null,"Pedestrian Specific Signals (HAWK, etc)?"]
[null,null,null,null,"Local Participation for signal betterments?"]
[null,null,null,null,"Existing Lighting?"]
[null,null,null,null,"Proposed Lighting?"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Number of Signals"]
[null,"Location",null,"Underclearance\nIssues",null,"Pedestrian Signals","ADA Upgrades","Existing Detection","Proposed Detection","Year Upgraded","Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[]
[null,"Intelligent Transportation Systems\n(Scoping Manual Section 3.7)"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Comments"]
[null,null,null,null,"Permanent Traffic Recorders?"]
[null,null,null,null,"Environmental Sensor Stations?"]
[null,null,null,null,"WIM/PITWS?"]
[null,null,null,null,"CCTV?"]
[null,null,null,null,"DMS?"]
[null,null,null,null,"MVDS?"]
[null,null,null,null,"ESS/RWIS?"]
[null,null,null,null,"RSU?"]
[]
[null,"ITS Devices Information Table",null,null,null,null,null,null,null,null,null,null,"Number of ITS Devices"]
[null,"Location",null,null,"Condition",null,"Proposed Work",null,null,"Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[null,"General Drainage Information\n(Scoping Manual Section 3.8)"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Comments"]
[null,null,null,null,"Curb & Gutter?"]
[null,null,null,null,"Curb & Gutter type consistent with speed?"]
[null,null,null,null,"HMA in Gutter?"]
[null,null,null,null,"Underdrains?"]
[null,null,null,null,"Underdrain Cleaning Required?"]
[null,null,null,null,"Spillways?"]
[null,null,null,null,"Detention/Retenion Basins?"]
[null,null,null,null,"Pump Stations?"]
[null,null,null,null,"County Drains?"]
[null,null,null,null,"Increase in impervious surface?"]
[null,null,null,null,"Post construction BMP's included?"]
[]
[]
[null,"Ditch Information\n(Scoping Manual Section 3.8.1)"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Comments"]
[null,null,null,null,"Existing Ditches?"]
[null,null,null,null,"Evidence of Flooding?"]
[null,null,null,null,"Evidence of Ditch Cleanout Needs?"]
[null,null,null,null,"Evidence of Erosion?"]
[null,null,null,null,"Proposed Ditches?"]
[]
[null,null,"Condition of Existing"]
[null,null,"Ditch System:"]
[]
[]
[]
[]
[null,"Culvert Information\n(Scoping Manual Section 3.8.2)"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Comments"]
[null,null,null,null,"4 inch or Greater Profile Grade Raise?"]
[null,null,null,null,"Existing Culverts?"]
[null,null,null,null,"Culvert Replacements?"]
[null,null,null,null,"Proposed Culverts?"]
[null,null,null,null,"Existing Headwalls in Clear Zone?"]
[null,null,null,null,"Culvert End Section Replacements?"]
[]
[null,"Culvert Information Table"]
[null,"Location",null,"Size","Material Type","Condition","Proposed Work",null,null,"Comments",null,null,"Number of Culverts"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[]
[null,"Storm Sewer Information\n(Scoping Manual Section 3.8.5/6)"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Comments"]
[null,null,null,null,"Existing Storm Sewer?"]
[null,null,null,null,"Existing Storm Sewer Material"]
[null,null,null,null,"Approximate age of existing sewer"]
[null,null,null,null,"Recent video inspection available?"]
[null,null,null,null,"Anticipated Storm Sewer Improvements?"]
[null,null,null,null,"Anticipated Storm Sewer Replacements?"]
[null,null,null,null,"Anticipated Inlet Rehabilitations?"]
[null,null,null,null,"Anticipated Inlet Replacements?"]
[]
[null,"Storm Sewer Information Table",null,null,null,null,null,null,null,null,null,null,"Number of Storm Sewer"]
[null,"Location",null,null,"Condition",null,"Proposed Work",null,null,"Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[null,"Utilities\n(Scoping Manual Section 3.9)"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Comments"]
[null,null,null,null,"Public Utilities?"]
[null,null,null,null,"Private Utilities?"]
[null,null,null,null,"Lead/Copper Rule replacements needed?"]
[null,null,null,null,"Watermain Study Completed?"]
[null,null,null,null,"Municipal Utility betterments?"]
[null,null,null,null,"Funding Source for betterments"]
[null,null,null,null,"Water betterments?"]
[null,null,null,null,"Sewer betterments?"]
[null,null,null,null,"Sanitary betterments?"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Number of Public Utilities"]
[null,null,"Public Utilities:","Utility",null,null,"Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Number of Private Utilities"]
[null,null,"Private Utilities:","Utility",null,null,"Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[null,"Sidewalk\n(Scoping Manual Section 3.10)"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Comments"]
[null,null,null,null,"New sidewalk needs?"]
[null,null,null,null,"Replace existing sidewalk?"]
[null,null,null,null,"Existing Curb Ramps?"]
[null,null,null,null,"Curb Ramp ADA upgrades?"]
[null,null,null,null,"Local participation for betterments?"]
[]
[null,"Railroad\n(Scoping Manual Section 3.11)"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Comments"]
[null,null,null,null,"Railroad with in Project Limits?"]
[null,null,null,null,"Railroad within Project Influence Area?"]
[null,null,null,null,"At Grade Railroad Crossings?"]
[null,null,null,null,"Grade Separated Railroad Crossings?"]
[null,null,null,null,"Railroad Crossing Improvements?"]
[null,null,null,null,"Railroad participation for betterments?"]
[null,null,null,null,"Proposed utility upgrades within RR ROW?"]
[]
[null,"Maintaining Traffic \n(Scoping Manual Section 3.12)"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,"MDOT Safety and Mobility Decision Tree"]
[null,null,null,null,null,"MDOT Work Zone Mobility Website"]
[]
[null,null,null,null,null,null,"Comments"]
[null,null,null,null,"Design Speed 70mph or greater?"]
[null,null,null,null,"Safety & Mobility Decision Tree Completed?"]
[null,null,null,null,"Safety & Mobility Decision Tree Results"]
[]
[null,"Maintaining Traffic - General"]
[]
[null,null,null,null,null,null,"Comments"]
[null,null,null,null,"Constructed under Traffic?"]
[null,null,null,null,"Detour?"]
[null,null,null,null,"Detour Permissions by Affected Agencies?"]
[null,null,null,null,"Detour Upgrades?"]
[null,null,null,null,"TMP Anticipated?"]
[null,null,null,null,"Temporary Widening?"]
[null,null,null,null,"Temporary Crossovers?"]
[null,null,null,null,"Temporary Signals?"]
[null,null,null,null,"Night Work?"]
[null,null,null,null,"Temporary Barrier Wall?"]
[]
[null,"Environmental\n(Scoping Manual Section 3.13)"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Comments"]
[null,null,null,null,"Environmental Scoping Report?"]
[null,null,null,null,"Environmental Permits Required?"]
[null,null,null,null,"Wetland Mitigation?"]
[null,null,null,null,"Stream Crossings?"]
[null,null,null,null,"PACS?"]
[null,null,null,null,"Non-Hazardous Contaminated Material?"]
[null,null,null,null,"Tree Removals?"]
[null,null,null,null,"Tree Replacements?"]
[null,null,null,null,"Recreational Properties?"]
[null,null,null,null,"Non-Motorized Trails?"]
[null,null,null,null,"Snowmobile/ORV Trails?"]
[null,null,null,null,"Parks?"]
[null,null,null,null,"Known Historical features?"]
[null,null,null,null,"Earth Disturbance? (Acreage)"]
[]
[null,"ROW/Real Estate\n(Scoping Manual Section 3.14)"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Comments"]
[null,null,null,null,"Partial Acquisition?"]
[null,null,null,null,"Full Acquisition?"]
[null,null,null,null,"Consents to Grade?"]
[null,null,null,null,"Sidewalk Permits?"]
[null,null,null,null,"Encroachments?"]
[]
[null,"External Engagement\n(Scoping Manual Section 3.15)"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Comments"]
[null,null,null,null,"Proposed Eternal Engagement Level"]
[null,null,null,null,"Complete Streets Policy in place?"]
[null,null,null,null,"Multi Modal opportunities?"]
[null,null,null,null,"Non-motorized opportunities?"]
[null,null,null,null,"Bus/Transit opportunities?"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Number of Agency"]
[null,null,"Agency Engagement:","Agency",null,null,"Contact",null,null,"Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[null,"Bridges and Ancillary Structures\n(Scoping Manual Section 3.16)"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Comments"]
[null,null,null,null,"Underclearance Issues?"]
[null,null,null,null,"Approach Pavement?"]
[null,null,null,null,"Bridge Barrier/Guardrail Design?"]
[null,null,null,null,"Shoulder Width?"]
[null,null,null,null,"Profile Impacts (vertical grade differentials)?"]
[null,null,null,null,"Traffic Control Needs?"]
[]
[null,"Location",null,"Ex Underclearance",null,"Approach Work?","Guardrail Work?","Barrier Work?","Profile Impacts?","Comments",null,null,"Number of Bridges"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[null,"Location",null,"Asset Types",null,"Existing RFA's",null,"Existing Work Recommendations",null,"Comments",null,null,"Num of Ancillary Structures"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[null,"Miscellaneous Items\n(Scoping Manual Section 3.17)"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Comments"]
[null,null,null,null,"Existing corrugations?"]
[null,null,null,null,"Proposed corrugations?"]
[null,null,null,null,"Existing ROW Fencing?"]
[null,null,null,null,"Replace ROW Fencing?"]
[null,null,null,null,"Local participation for lighting betterments?"]
[null,null,null,null,"Maintenance Crossovers?"]
[null,null,null,null,"Cemeteries?"]
[null,null,null,null,"Rest Areas?"]
[null,null,null,null,"Roadside Parks?"]
[null,null,null,null,"Carpool Lots?"]
[null,null,null,null,"Weigh Stations?"]
[null,null,null,null,"Crash Investigation Sites?"]
[null,null,null,null,"Existing Maintenance Agreements?"]
[]
["If you require assistance accessing this information or require it in an alternative format, contact the",null,null,null,null,null,null,null,null,null,"Michigan.gov/MDOT-ADA"]
["Michigan Department of Transportation’s (MDOT) Americans with Disabilities Act (ADA) coordinator"]

{"sheet":"Supporting Tables","index":2,"n_rows":11,"n_cols":24,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,"Crash Analysis","TOR","RSA","Highway Safety Manual Analysis","Performance Based Practical Design","Access Management Opportunities"]
[null,null,null,null,null,null,"Yes","Yes","Yes","Yes","Yes","Yes",null,null,null,"Lane Type",null,"Ramp Type",null,"Stake Holder Engagement",null,"Work Type",null,"Route Characteristic"]
[null,null,null,null,null,null,"No","No","No","No","No","No",null,null,null,"Right Turn",null,"Exit Ramp",null,"I",null,"Select",null,"Select"]
[null,null,null,null,null,null,"N/A","N/A","N/A","N/A","N/A","N/A",null,null,null,"Left Turn",null,"Entrance Ramp",null,"II",null,"Reconstruction",null,"Urban"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Center Left Turn",null,null,null,"III",null,"Rehabilitation",null,"Rural"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indirect Left Turn",null,null,null,"IV"]
[null,null,null,null,null,null,"NHS","Functional Class",null,null,null,null,null,null,null,"Passing Flare",null,null,null,"V"]
[null,null,null,null,null,null,"Select","Select",null,null,null,null,null,null,null,"Indirect/Thru Turn",null,null,null,"NA"]
[null,null,null,null,null,null,"NHS","Freeway",null,null,null,null,null,null,null,"Median Crossover"]
[null,null,null,null,null,null,"Non-NHS","Non-Freeway"]

{"sheet":"Basic Scoping","index":3,"n_rows":154,"n_cols":13,"rows_kept":154,"cut":false,"hidden":true,"merged":[[152,10,153,11],[144,1,144,11],[146,3,150,11],[33,12,34,12],[7,8,7,11],[8,8,8,11],[35,4,35,5],[35,10,35,11],[12,3,13,11],[31,3,31,4],[31,8,31,11],[32,3,32,4],[32,8,32,11],[10,3,10,4],[10,8,10,9],[15,3,16,11],[18,3,18,11],[27,12,28,12],[29,3,29,4],[29,8,29,11],[30,3,30,4],[30,8,30,11],[26,3,26,5],[21,3,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[36,4,36,5],[36,10,36,11],[37,4,37,5],[37,10,37,11],[38,4,38,5],[38,10,38,11],[51,1,51,11],[23,3,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[24,3,24,4],[24,5,24,6],[24,7,24,8],[24,9,24,10],[59,1,59,3],[63,1,63,2],[63,3,63,5],[63,6,63,8],[63,9,63,11],[61,1,61,11],[62,1,62,2],[62,3,62,5],[62,6,62,8],[62,9,62,11],[0,1,0,11],[2,3,2,5],[2,7,2,8],[2,10,2,11],[3,3,3,5],[3,7,3,8],[3,10,3,11],[20,3,20,4],[20,5,20,6],[20,7,20,8],[20,9,20,10],[5,1,5,11],[7,3,7,4],[8,3,8,4],[9,3,9,4],[9,8,9,9],[76,12,77,12],[77,5,77,6],[77,9,78,11],[79,9,79,11],[80,9,80,11],[63,12,64,12],[39,12,40,12],[41,4,41,5],[41,6,41,8],[41,9,41,11],[42,4,42,5],[42,6,42,8],[42,9,42,11],[43,4,43,5],[43,6,43,8],[43,9,43,11],[45,3,48,11],[58,4,58,6],[59,4,59,6],[76,3,76,11],[53,3,56,11],[71,3,74,11],[69,1,69,11],[58,1,58,3],[138,6,138,11],[139,6,139,11],[140,6,140,11],[141,6,141,11],[128,1,128,11],[135,6,135,11],[136,6,136,11],[137,6,137,11],[83,12,84,12],[84,5,84,6],[84,9,85,11],[86,9,86,11],[87,9,87,11],[83,3,83,11],[88,9,88,11],[101,12,102,12],[102,1,102,2],[102,3,102,4],[102,5,102,6],[102,7,103,11],[90,12,91,12],[93,5,93,11],[94,5,94,11],[95,12,96,12],[96,1,96,2],[96,4,96,5],[96,6,97,11],[90,1,90,2],[90,3,92,3],[90,4,92,4],[90,5,92,11],[115,6,115,11],[116,6,116,11],[106,7,106,11],[108,1,108,11],[110,3,113,11],[98,6,98,11],[99,6,99,11],[100,6,100,11],[104,7,104,11],[105,7,105,11],[81,9,81,11],[125,6,125,11],[126,6,126,11],[130,3,133,11],[120,6,120,11],[121,6,121,11],[122,6,122,11],[123,6,123,11],[124,6,124,11],[117,6,117,11],[118,6,118,11],[119,6,119,11]]}
[null,"Basic Project Scoping Checklist"]
[]
[null,null,"Scoped By:",null,null,null,"Unit:",null,null,"Date:"]
[null,null,"QC By:",null,null,null,"Unit:",null,null,"Date:"]
[]
[null,"Project Information"]
[]
[null,null,"Job Number:",null,null,null,null,"Primary Funding Template:"]
[null,null,"Route:",null,null,null,null,"Alternate Funding Template:"]
[null,null,"NHS:","Select",null,null,null,"Roadway Functional Class:","Select"]
[null,null,"Work Type:","Select",null,null,null,"Route Characteristics:","Select"]
[]
[null,null,"Location Description:"]
[]
[]
[null,null,"Project Objective:"]
[]
[]
[null,null,"Proposed Fix:","Select"]
[]
[null,null,"Cost Data:","Construction Cost",null,"PE Cost",null,"CE Cost",null,"ROW Cost"]
[]
[]
[null,null,"Additional Costs:","EPE",null,"Utilities"]
[]
[]
[null,null,"Programming Cost:",{"$f":"D22+F22+H22+J22+D25+F25+H25+J25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Number of CS Locations"]
[null,null,"Control Section"]
[null,null,"Location:","Control Section",null,"CS BMP","CS EMP","Length","Comments",null,null,null,2]
[null,null,null,null,null,null,null,{"$f":"IF(G31-F31<0,\"-\",G31-F31)","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Total =",{"$f":"SUM(OFFSET($H$31,0,0,ROW($G$33)-ROW($H$31),1))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Number of Programming Lines"]
[null,null,"Programming"]
[null,null,"Location:","CS #","PR #",null,"Major","PR BMP","PR EMP","Length","Route / Comments",null,2]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I37-H37<0,\"-\",I37-H37)","v":0}]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Total =",{"$f":"SUM(OFFSET($J$37,0,0,ROW($I$39)-ROW($J$37),1))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Number of As Builts"]
[]
[null,null,"As-Builts:","Year","Fix Type",null,"Limits",null,null,"ProjectWise Location",null,null,2]
[]
[]
[]
[null,null,"Project Background/"]
[null,null,"General Info/"]
[null,null,"Comments"]
[]
[]
[]
[null,"Pavement Management Data"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,"Pavement Type",null,null,"Shoulder Type"]
[null,"Select",null,null,"Select"]
[]
[null,"Pavement Condition Requirements for Proposed Pavement Fix"]
[null,"Min. RSL (yrs)",null,"Max. DI ",null,null,"Max. IRI",null,null,"Max. Avg. RUT"]
[null,{"$f":"IF(B60=\"Flexible\",IF(D19=\"Non-Structural HMA Overlay\",Equations!F3,IF(B60=\"Flexible\",IF(D19=\"Surface Milling with Non Structural HMA Overlay\",Equations!F5,IF(B60=\"Flexible\",IF(D19=\"Single Chip Seal\",Equations!F7,IF(B60=\"Flexible\",IF(D19=\"Double Chip Seal\",Equations!F9,IF(B60=\"Flexible\",IF(D19=\"Paver Placed Surface Seal\",Equations!F11,IF(B60=\"Flexible\",IF(D19=\"Micro-Surface (Single)\",Equations!F13,IF(B60=\"Flexible\",IF(D19=\"Micro-Surface (Double)\",Equations!F15,IF(B60=\"Flexible\",IF(D19=\"Crack Treatment\",Equations!F17,IF(B60=\"Flexible\",IF(D19=\"Overband Crack Filling\",Equations!F19,IF(B60=\"Flexible\",IF(D19=\"Ultra Thin Overlay\",Equations!F21))))))))))))))))))),IF(B60=\"Composite\",IF(D19=\"Non-Structural HMA Overlay\",Equations!F4,IF(B60=\"Composite\",IF(D19=\"Surface Milling with Non Structural HMA Overlay\",Equations!F6,IF(B60=\"Composite\",IF(D19=\"Single Chip Seal\",Equations!F8,IF(B60=\"Composite\",IF(D19=\"Double Chip Seal\",Equations!F10,IF(B60=\"Composite\",IF(D19=\"Paver Placed Surface Seal\",Equations!F12,IF(B60=\"Composite\",IF(D19=\"Micro-Surface (Single)\",Equations!F14,IF(B60=\"Composite\",IF(D19=\"Micro-Surface (Double)\",Equations!F16,IF(B60=\"Composite\",IF(D19=\"Crack Treatment\",Equations!F18,IF(B60=\"Composite\",IF(D19=\"Overband Crack Filling\",Equations!F20,IF(B60=\"Composite\",IF(D19=\"Ultra Thin Overlay\",Equations!F22))))))))))))))))))),IF(B60=\"Rigid\",IF(D19=\"Full Depth Concrete Paventmet Repair\",Equations!F23,IF(B60=\"Rigid\",IF(D19=\"Concrete Joint Resealing\",Equations!F24,IF(B60=\"Rigid\",IF(D19=\"Concrete Crack Sealing\",Equations!F25,IF(B60=\"Rigid\",IF(D19=\"Diamond Grinding\",Equations!F26,IF(B60=\"Rigid\",IF(D19=\"Dowel Bar Retrofit\",Equations!F27,IF(B60=\"Rigid\",IF(D19=\"Concrete Pavement Restoration\",Equations!F28))))))))))),\"\")))","v":""},null,{"$f":"IF(B60=\"Flexible\",IF(D19=\"Non-Structural HMA Overlay\",Equations!H3,IF(B60=\"Flexible\",IF(D19=\"Surface Milling with Non Structural HMA Overlay\",Equations!H5,IF(B60=\"Flexible\",IF(D19=\"Single Chip Seal\",Equations!H7,IF(B60=\"Flexible\",IF(D19=\"Double Chip Seal\",Equations!H9,IF(B60=\"Flexible\",IF(D19=\"Paver Placed Surface Seal\",Equations!H11,IF(B60=\"Flexible\",IF(D19=\"Micro-Surface (Single)\",Equations!H13,IF(B60=\"Flexible\",IF(D19=\"Micro-Surface (Double)\",Equations!H15,IF(B60=\"Flexible\",IF(D19=\"Crack Treatment\",Equations!H17,IF(B60=\"Flexible\",IF(D19=\"Overband Crack Filling\",Equations!H19,IF(B60=\"Flexible\",IF(D19=\"Ultra Thin Overlay\",Equations!H21))))))))))))))))))),IF(B60=\"Composite\",IF(D19=\"Non-Structural HMA Overlay\",Equations!H4,IF(B60=\"Composite\",IF(D19=\"Surface Milling with Non Structural HMA Overlay\",Equations!H6,IF(B60=\"Composite\",IF(D19=\"Single Chip Seal\",Equations!H8,IF(B60=\"Composite\",IF(D19=\"Double Chip Seal\",Equations!H10,IF(B60=\"Composite\",IF(D19=\"Paver Placed Surface Seal\",Equations!H12,IF(B60=\"Composite\",IF(D19=\"Micro-Surface (Single)\",Equations!H14,IF(B60=\"Composite\",IF(D19=\"Micro-Surface (Double)\",Equations!H16,IF(B60=\"Composite\",IF(D19=\"Crack Treatment\",Equations!H18,IF(B60=\"Composite\",IF(D19=\"Overband Crack Filling\",Equations!H20,IF(B60=\"Composite\",IF(D19=\"Ultra Thin Overlay\",Equations!H22))))))))))))))))))),IF(B60=\"Rigid\",IF(D19=\"Full Depth Concrete Paventmet Repair\",Equations!H23,IF(B60=\"Rigid\",IF(D19=\"Concrete Joint Resealing\",Equations!H24,IF(B60=\"Rigid\",IF(D19=\"Concrete Crack Sealing\",Equations!H25,IF(B60=\"Rigid\",IF(D19=\"Diamond Grinding\",Equations!H26,IF(B60=\"Rigid\",IF(D19=\"Dowel Bar Retrofit\",Equations!H27,IF(B60=\"Rigid\",IF(D19=\"Concrete Pavement Restoration\",Equations!H28))))))))))),\"\")))","v":""},null,null,{"$f":"IF(B60=\"Flexible\",IF(D19=\"Non-Structural HMA Overlay\",Equations!J3,IF(B60=\"Flexible\",IF(D19=\"Surface Milling with Non Structural HMA Overlay\",Equations!J5,IF(B60=\"Flexible\",IF(D19=\"Single Chip Seal\",Equations!J7,IF(B60=\"Flexible\",IF(D19=\"Double Chip Seal\",Equations!J9,IF(B60=\"Flexible\",IF(D19=\"Paver Placed Surface Seal\",Equations!J11,IF(B60=\"Flexible\",IF(D19=\"Micro-Surface (Single)\",Equations!J13,IF(B60=\"Flexible\",IF(D19=\"Micro-Surface (Double)\",Equations!J15,IF(B60=\"Flexible\",IF(D19=\"Crack Treatment\",Equations!J17,IF(B60=\"Flexible\",IF(D19=\"Overband Crack Filling\",Equations!J19,IF(B60=\"Flexible\",IF(D19=\"Ultra Thin Overlay\",Equations!J21))))))))))))))))))),IF(B60=\"Composite\",IF(D19=\"Non-Structural HMA Overlay\",Equations!J4,IF(B60=\"Composite\",IF(D19=\"Surface Milling with Non Structural HMA Overlay\",Equations!J6,IF(B60=\"Composite\",IF(D19=\"Single Chip Seal\",Equations!J8,IF(B60=\"Composite\",IF(D19=\"Double Chip Seal\",Equations!J10,IF(B60=\"Composite\",IF(D19=\"Paver Placed Surface Seal\",Equations!J12,IF(B60=\"Composite\",IF(D19=\"Micro-Surface (Single)\",Equations!J14,IF(B60=\"Composite\",IF(D19=\"Micro-Surface (Double)\",Equations!J16,IF(B60=\"Composite\",IF(D19=\"Crack Treatment\",Equations!J18,IF(B60=\"Composite\",IF(D19=\"Overband Crack Filling\",Equations!J20,IF(B60=\"Composite\",IF(D19=\"Ultra Thin Overlay\",Equations!J22))))))))))))))))))),IF(B60=\"Rigid\",IF(D19=\"Full Depth Concrete Paventmet Repair\",Equations!J23,IF(B60=\"Rigid\",IF(D19=\"Concrete Joint Resealing\",Equations!J24,IF(B60=\"Rigid\",IF(D19=\"Concrete Crack Sealing\",Equations!J25,IF(B60=\"Rigid\",IF(D19=\"Diamond Grinding\",Equations!J26,IF(B60=\"Rigid\",IF(D19=\"Dowel Bar Retrofit\",Equations!J27,IF(B60=\"Rigid\",IF(D19=\"Concrete Pavement Restoration\",Equations!J28))))))))))),\"\")))","v":""},null,null,{"$f":"IF(B60=\"Flexible\",IF(D19=\"Non-Structural HMA Overlay\",Equations!L3,IF(B60=\"Flexible\",IF(D19=\"Surface Milling with Non Structural HMA Overlay\",Equations!L5,IF(B60=\"Flexible\",IF(D19=\"Single Chip Seal\",Equations!L7,IF(B60=\"Flexible\",IF(D19=\"Double Chip Seal\",Equations!L9,IF(B60=\"Flexible\",IF(D19=\"Paver Placed Surface Seal\",Equations!L11,IF(B60=\"Flexible\",IF(D19=\"Micro-Surface (Single)\",Equations!L13,IF(B60=\"Flexible\",IF(D19=\"Micro-Surface (Double)\",Equations!L15,IF(B60=\"Flexible\",IF(D19=\"Crack Treatment\",Equations!L17,IF(B60=\"Flexible\",IF(D19=\"Overband Crack Filling\",Equations!L19,IF(B60=\"Flexible\",IF(D19=\"Ultra Thin Overlay\",Equations!L21))))))))))))))))))),IF(B60=\"Composite\",IF(D19=\"Non-Structural HMA Overlay\",Equations!L4,IF(B60=\"Composite\",IF(D19=\"Surface Milling with Non Structural HMA Overlay\",Equations!L6,IF(B60=\"Composite\",IF(D19=\"Single Chip Seal\",Equations!L8,IF(B60=\"Composite\",IF(D19=\"Double Chip Seal\",Equations!L10,IF(B60=\"Composite\",IF(D19=\"Paver Placed Surface Seal\",Equations!L12,IF(B60=\"Composite\",IF(D19=\"Micro-Surface (Single)\",Equations!L14,IF(B60=\"Composite\",IF(D19=\"Micro-Surface (Double)\",Equations!L16,IF(B60=\"Composite\",IF(D19=\"Crack Treatment\",Equations!L18,IF(B60=\"Composite\",IF(D19=\"Overband Crack Filling\",Equations!L20,IF(B60=\"Composite\",IF(D19=\"Ultra Thin Overlay\",Equations!L22))))))))))))))))))),\"\"))","v":""},null,null,"Pavt. Condition Lines"]
[]
[null,"RSL","Yr.","DI","Yr.","IRI","Yr.","RUT","Yr.",null,null,null,2]
[]
[]
[]
[null,"Detailed Pavement Data"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,null,"Pavement Section:","Existing",null,null,null,null,null,null,null,null,"Number of Existing"]
[null,null,null,"HMA","Concrete","Composite",null,"Agg Base","Subbase","Comments"]
[null,null,null,"(in)","(in)","HMA (in)","Conc (in)","(in)","(in)",null,null,null,3]
[]
[]
[]
[]
[null,null,null,"Proposed",null,null,null,null,null,null,null,null,"Number of Propsed"]
[null,null,null,"HMA","Concrete","Composite",null,"Agg Base","Subbase","Comments"]
[null,null,null,"(in)","(in)","HMA (in)","Conc (in)","(in)","(in)",null,null,null,3]
[]
[]
[]
[]
[null,"Design Speed:",null,"Posted Speed (mph)","Design Speed (mph)","Comments",null,null,null,null,null,null,"Number of Design Speed"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Number of Lane Width"]
[null,"Lane Width:",null,"# Lanes","Width",null,"Comments"]
[null,null,null,"(Ea)","Ex (Ft)","Pr (Ft)",null,null,null,null,null,null,3]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Number of Shoulder Width"]
[null,"Shoulder Width:",null,"Left",null,"Right",null,"Comments"]
[null,null,null,"Total (Ft)","Paved (Ft)","Total (Ft)","Paved (Ft)",null,null,null,null,null,3]
[]
[]
[]
[]
[null,"Drainage & Ditch Information"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Comments"]
[null,null,null,null,"Underdrains?"]
[null,null,null,null,"Underdrain Cleaning Required?"]
[null,null,null,null,"Detention/Retenion Basins?"]
[null,null,null,null,"County Drains?"]
[null,null,null,null,"Increase in impervious surface?"]
[null,null,null,null,"Post construction BMP's included?"]
[null,null,null,null,"Existing Ditches?"]
[null,null,null,null,"Evidence of Flooding?"]
[null,null,null,null,"Evidence of Ditch Cleanout Needs?"]
[null,null,null,null,"Evidence of Erosion?"]
[null,null,null,null,"Proposed Ditches?"]
[]
[null,"Railroad"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Comments"]
[null,null,null,null,"Railroad with in Project Limits?"]
[null,null,null,null,"Railroad within Project Influence Area?"]
[null,null,null,null,"At Grade Railroad Crossings?"]
[null,null,null,null,"Grade Separated Railroad Crossings?"]
[null,null,null,null,"Railroad Crossing Improvements?"]
[null,null,null,null,"Railroad participation for betterments?"]
[]
[]
[null,"Miscellaneous/Other Items of Work"]
[]
[null,null,"Comments/Notes:"]
[]
[]
[]
[]
[]
["If you require assistance accessing this information or require it in an alternative format, contact the",null,null,null,null,null,null,null,null,null,"Michigan.gov/MDOT-ADA"]
["Michigan Department of Transportation’s (MDOT) Americans with Disabilities Act (ADA) coordinator"]

{"sheet":"CPM Project Field Review","index":4,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":true,"merged":[[33,12,35,18],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,6,9,6],[8,7,9,7],[8,8,9,8],[8,9,9,9],[8,10,9,10],[10,7,13,7],[10,9,13,9],[14,2,14,9],[15,2,17,9],[19,2,19,3],[19,4,19,5],[2,2,3,9],[4,3,4,4],[4,5,4,6],[5,2,5,9],[6,2,7,9],[19,6,19,7],[19,8,19,9],[20,2,21,3],[20,4,21,5],[20,6,21,7],[20,8,21,9],[23,3,23,5],[23,6,23,7],[23,8,23,9],[32,2,32,3],[32,4,32,5],[32,6,32,7],[32,8,32,9],[24,3,24,5],[24,6,24,7],[24,8,24,9],[25,3,25,5],[25,6,25,7],[25,8,25,9],[26,3,26,5],[26,6,26,7],[26,8,26,9],[29,2,30,9],[31,2,31,9],[33,2,33,3],[33,4,33,5],[33,6,33,7],[33,8,33,9],[51,2,52,3],[51,6,52,7],[51,8,52,9],[52,4,52,5],[35,2,35,3],[35,4,35,5],[35,6,35,7],[35,8,35,9],[49,6,50,7],[49,2,50,3],[42,2,47,9],[49,8,50,9],[50,4,50,5]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Notes"]
[null,null,"SELECT PROPER FUNDING TEMPLATE (CPM, NFRP OR FRP)",null,null,null,null,null,null,null,"Notes for Changes"]
[null,null,null,null,null,null,null,null,null,null,"Added drop down list to change header for CPM, NFRP or FRP",null,"A check with impacted road commission or municipality for coordination with their programs."]
[null,null,"Region:",null,null,"Year of Construction:",null,null,"Job Number:"]
[null,null,"Field Review Date and By:",null,null,null,null,null,null,null,null,null,"Existing pavement structure (flexible, composite, concrete)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Joint repair needs (Det 7/8 for composite pavements)"]
[null,null,"Route:","Physical Reference #:","PRBMP:","PREMP:","PR Length:      (Route-Mi)","Total Length: (Route-Mi)","# of Lanes:","Total Lane Miles:","Made Route 1 column, Added PR # Column, Split PR MP into two columns BMP and EMP, Made Project length calculation, added total length (Route-Mi) column that automatically calculates, added # of lanes column, made total lane mile auto calculate."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Structure cover adjustments/casting replacements"]
[null,null,null,null,null,null,{"$f":"F11-E11","v":0},{"$f":"SUM(G11:G14)","v":0},null,{"$f":"(G11*I11)+(G12*I12)+(G13*I13)+(G14*I14)","v":0}]
[null,null,null,null,null,null,{"$f":"F12-E12","v":0},null,null,null,null,null,"ADA ramps needs"]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,"Bridge underclearance impacts"]
[null,null,"Location Description:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Guardrail height impacts"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"MOT issues/concerns/additional costs"]
[]
[null,null,"Pavement Type:",null,"Pavement Width:",null,"Shoulder Type:",null,"Shoulder Width:",null,null,null,"Shoulder conditions (raveled edges that need special attention)"]
[null,null,null,null,null,null,null,null,null,null,"Added shoulder type drop down list, copied from pavement type table and added N/A - C&G selection"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Driveway treatments (added butt joints?)"]
[null,null,"Prev Fix Yr. & Prev Fix Type:",null,null,null,"ADT Range:              /         Comm ADT Range:",null,null,null,"Prev Fix split cells differently so year can be entered in leading cell and fix type trailing cell"]
[null,null,null,null,null,null,null,null,null,null,"Added additional row to correspond to the 4 route rows above",null,"Approach road treatments (include or exclude?)"]
[null,null,null,null,null,null,null,null,null,null,"ADT/CADT split into two columns"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Pavement sensor impacts (signal pucks/loops, WIM, PTR, ITS, ESS)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Railroad crossings"]
[null,null,"Recommended Treatment:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Frost tubes"]
[]
[null,null,"Pavement Condition Requirements for Recommended Treatment",null,null,null,null,null,null,null,null,null,"Monument boxes (monument preservation)"]
[null,null,"Min. RSL (yrs):",null,"Max. DI:",null,"Max. IRI:",null,"Max. Avg. RUT:"]
[null,null,{"$f":"IF(C21=\"Flexible\",IF(C30=\"Non-Structural HMA Overlay\",Equations!F3,IF(C21=\"Flexible\",IF(C30=\"Surface Milling with Non Structural HMA Overlay\",Equations!F5,IF(C21=\"Flexible\",IF(C30=\"Single Chip Seal\",Equations!F7,IF(C21=\"Flexible\",IF(C30=\"Double Chip Seal\",Equations!F9,IF(C21=\"Flexible\",IF(C30=\"Paver Placed Surface Seal\",Equations!F11,IF(C21=\"Flexible\",IF(C30=\"Micro-Surface (Single)\",Equations!F13,IF(C21=\"Flexible\",IF(C30=\"Micro-Surface (Double)\",Equations!F15,IF(C21=\"Flexible\",IF(C30=\"Crack Treatment\",Equations!F17,IF(C21=\"Flexible\",IF(C30=\"Overband Crack Filling\",Equations!F19,IF(C21=\"Flexible\",IF(C30=\"Ultra Thin Overlay\",Equations!F21))))))))))))))))))),IF(C21=\"Composite\",IF(C30=\"Non-Structural HMA Overlay\",Equations!F4,IF(C21=\"Composite\",IF(C30=\"Surface Milling with Non Structural HMA Overlay\",Equations!F6,IF(C21=\"Composite\",IF(C30=\"Single Chip Seal\",Equations!F8,IF(C21=\"Composite\",IF(C30=\"Double Chip Seal\",Equations!F10,IF(C21=\"Composite\",IF(C30=\"Paver Placed Surface Seal\",Equations!F12,IF(C21=\"Composite\",IF(C30=\"Micro-Surface (Single)\",Equations!F14,IF(C21=\"Composite\",IF(C30=\"Micro-Surface (Double)\",Equations!F16,IF(C21=\"Composite\",IF(C30=\"Crack Treatment\",Equations!F18,IF(C21=\"Composite\",IF(C30=\"Overband Crack Filling\",Equations!F20,IF(C21=\"Composite\",IF(C30=\"Ultra Thin Overlay\",Equations!F22))))))))))))))))))),IF(C21=\"Rigid\",IF(C30=\"Full Depth Concrete Paventmet Repair\",Equations!F23,IF(C21=\"Rigid\",IF(C30=\"Concrete Joint Resealing\",Equations!F24,IF(C21=\"Rigid\",IF(C30=\"Concrete Crack Sealing\",Equations!F25,IF(C21=\"Rigid\",IF(C30=\"Diamond Grinding\",Equations!F26,IF(C21=\"Rigid\",IF(C30=\"Dowel Bar Retrofit\",Equations!F27,IF(C21=\"Rigid\",IF(C30=\"Concrete Pavement Restoration\",Equations!F28))))))))))),\"\")))","v":""},null,{"$f":"IF(C21=\"Flexible\",IF(C30=\"Non-Structural HMA Overlay\",Equations!H3,IF(C21=\"Flexible\",IF(C30=\"Surface Milling with Non Structural HMA Overlay\",Equations!H5,IF(C21=\"Flexible\",IF(C30=\"Single Chip Seal\",Equations!H7,IF(C21=\"Flexible\",IF(C30=\"Double Chip Seal\",Equations!H9,IF(C21=\"Flexible\",IF(C30=\"Paver Placed Surface Seal\",Equations!H11,IF(C21=\"Flexible\",IF(C30=\"Micro-Surface (Single)\",Equations!H13,IF(C21=\"Flexible\",IF(C30=\"Micro-Surface (Double)\",Equations!H15,IF(C21=\"Flexible\",IF(C30=\"Crack Treatment\",Equations!H17,IF(C21=\"Flexible\",IF(C30=\"Overband Crack Filling\",Equations!H19,IF(C21=\"Flexible\",IF(C30=\"Ultra Thin Overlay\",Equations!H21))))))))))))))))))),IF(C21=\"Composite\",IF(C30=\"Non-Structural HMA Overlay\",Equations!H4,IF(C21=\"Composite\",IF(C30=\"Surface Milling with Non Structural HMA Overlay\",Equations!H6,IF(C21=\"Composite\",IF(C30=\"Single Chip Seal\",Equations!H8,IF(C21=\"Composite\",IF(C30=\"Double Chip Seal\",Equations!H10,IF(C21=\"Composite\",IF(C30=\"Paver Placed Surface Seal\",Equations!H12,IF(C21=\"Composite\",IF(C30=\"Micro-Surface (Single)\",Equations!H14,IF(C21=\"Composite\",IF(C30=\"Micro-Surface (Double)\",Equations!H16,IF(C21=\"Composite\",IF(C30=\"Crack Treatment\",Equations!H18,IF(C21=\"Composite\",IF(C30=\"Overband Crack Filling\",Equations!H20,IF(C21=\"Composite\",IF(C30=\"Ultra Thin Overlay\",Equations!H22))))))))))))))))))),IF(C21=\"Rigid\",IF(C30=\"Full Depth Concrete Paventmet Repair\",Equations!H23,IF(C21=\"Rigid\",IF(C30=\"Concrete Joint Resealing\",Equations!H24,IF(C21=\"Rigid\",IF(C30=\"Concrete Crack Sealing\",Equations!H25,IF(C21=\"Rigid\",IF(C30=\"Diamond Grinding\",Equations!H26,IF(C21=\"Rigid\",IF(C30=\"Dowel Bar Retrofit\",Equations!H27,IF(C21=\"Rigid\",IF(C30=\"Concrete Pavement Restoration\",Equations!H28))))))))))),\"\")))","v":""},null,{"$f":"IF(C21=\"Flexible\",IF(C30=\"Non-Structural HMA Overlay\",Equations!J3,IF(C21=\"Flexible\",IF(C30=\"Surface Milling with Non Structural HMA Overlay\",Equations!J5,IF(C21=\"Flexible\",IF(C30=\"Single Chip Seal\",Equations!J7,IF(C21=\"Flexible\",IF(C30=\"Double Chip Seal\",Equations!J9,IF(C21=\"Flexible\",IF(C30=\"Paver Placed Surface Seal\",Equations!J11,IF(C21=\"Flexible\",IF(C30=\"Micro-Surface (Single)\",Equations!J13,IF(C21=\"Flexible\",IF(C30=\"Micro-Surface (Double)\",Equations!J15,IF(C21=\"Flexible\",IF(C30=\"Crack Treatment\",Equations!J17,IF(C21=\"Flexible\",IF(C30=\"Overband Crack Filling\",Equations!J19,IF(C21=\"Flexible\",IF(C30=\"Ultra Thin Overlay\",Equations!J21))))))))))))))))))),IF(C21=\"Composite\",IF(C30=\"Non-Structural HMA Overlay\",Equations!J4,IF(C21=\"Composite\",IF(C30=\"Surface Milling with Non Structural HMA Overlay\",Equations!J6,IF(C21=\"Composite\",IF(C30=\"Single Chip Seal\",Equations!J8,IF(C21=\"Composite\",IF(C30=\"Double Chip Seal\",Equations!J10,IF(C21=\"Composite\",IF(C30=\"Paver Placed Surface Seal\",Equations!J12,IF(C21=\"Composite\",IF(C30=\"Micro-Surface (Single)\",Equations!J14,IF(C21=\"Composite\",IF(C30=\"Micro-Surface (Double)\",Equations!J16,IF(C21=\"Composite\",IF(C30=\"Crack Treatment\",Equations!J18,IF(C21=\"Composite\",IF(C30=\"Overband Crack Filling\",Equations!J20,IF(C21=\"Composite\",IF(C30=\"Ultra Thin Overlay\",Equations!J22))))))))))))))))))),IF(C21=\"Rigid\",IF(C30=\"Full Depth Concrete Paventmet Repair\",Equations!J23,IF(C21=\"Rigid\",IF(C30=\"Concrete Joint Resealing\",Equations!J24,IF(C21=\"Rigid\",IF(C30=\"Concrete Crack Sealing\",Equations!J25,IF(C21=\"Rigid\",IF(C30=\"Diamond Grinding\",Equations!J26,IF(C21=\"Rigid\",IF(C30=\"Dowel Bar Retrofit\",Equations!J27,IF(C21=\"Rigid\",IF(C30=\"Concrete Pavement Restoration\",Equations!J28))))))))))),\"\")))","v":""},null,{"$f":"IF(C21=\"Flexible\",IF(C30=\"Non-Structural HMA Overlay\",Equations!L3,IF(C21=\"Flexible\",IF(C30=\"Surface Milling with Non Structural HMA Overlay\",Equations!L5,IF(C21=\"Flexible\",IF(C30=\"Single Chip Seal\",Equations!L7,IF(C21=\"Flexible\",IF(C30=\"Double Chip Seal\",Equations!L9,IF(C21=\"Flexible\",IF(C30=\"Paver Placed Surface Seal\",Equations!L11,IF(C21=\"Flexible\",IF(C30=\"Micro-Surface (Single)\",Equations!L13,IF(C21=\"Flexible\",IF(C30=\"Micro-Surface (Double)\",Equations!L15,IF(C21=\"Flexible\",IF(C30=\"Crack Treatment\",Equations!L17,IF(C21=\"Flexible\",IF(C30=\"Overband Crack Filling\",Equations!L19,IF(C21=\"Flexible\",IF(C30=\"Ultra Thin Overlay\",Equations!L21))))))))))))))))))),IF(C21=\"Composite\",IF(C30=\"Non-Structural HMA Overlay\",Equations!L4,IF(C21=\"Composite\",IF(C30=\"Surface Milling with Non Structural HMA Overlay\",Equations!L6,IF(C21=\"Composite\",IF(C30=\"Single Chip Seal\",Equations!L8,IF(C21=\"Composite\",IF(C30=\"Double Chip Seal\",Equations!L10,IF(C21=\"Composite\",IF(C30=\"Paver Placed Surface Seal\",Equations!L12,IF(C21=\"Composite\",IF(C30=\"Micro-Surface (Single)\",Equations!L14,IF(C21=\"Composite\",IF(C30=\"Micro-Surface (Double)\",Equations!L16,IF(C21=\"Composite\",IF(C30=\"Crack Treatment\",Equations!L18,IF(C21=\"Composite\",IF(C30=\"Overband Crack Filling\",Equations!L20,IF(C21=\"Composite\",IF(C30=\"Ultra Thin Overlay\",Equations!L22))))))))))))))))))),\"\"))","v":""},null,null,null,"A check with maintenance personnel for potential culvert or drainage structure rehabs that should be done by maintenance prior to the CPM job"]
[null,null,"Pavement Management Data"]
[null,null,"RSL       /         Yr.",null,"DI        /        Yr.",null,"IRI        /          Yr.",null,"RUT      /              Yr."]
[null,null,null,null,null,null,null,null,null,null,"added two additional rows to correspond with route rows above"]
[null,null,null,null,null,null,null,null,null,null,"Split columns to have separate pavement data and year column"]
[]
[]
[]
[null,null,"Field Review Comments or Justification:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Construction Cost:",null,"PE Cost (0%):",null,"CE Cost (10%):",null,"Total Project Cost:",null,"Added highlights to PE and CE since % rates may change depending on proposed fix type."]
[null,null,null,null,null,null,null,null,null,null,"Split PE Cell to add ROW cost"]
[null,null,null,null,"ROW Cost:",null,null,null,{"$f":"C52+E51+G52+E53","v":0}]

{"sheet":"Equations","index":5,"n_rows":38,"n_cols":38,"rows_kept":38,"cut":false,"hidden":true,"merged":[[1,16,11,21],[1,23,11,28],[1,30,11,35],[1,37,11,42],[13,16,23,21],[13,23,23,28],[13,30,23,35],[13,37,23,42],[25,16,31,21],[25,23,31,28],[25,30,31,35],[25,37,31,42],[34,16,62,21],[34,23,62,28],[34,30,62,35],[34,37,56,42]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min. RSL (yrs):",null,null,null,null,null,null,"Max. DI:",null,null,null,null,null,null,"Max. IRI:",null,null,null,null,null,null,"Max. Avg. RUT:"]
[null,null,null,null,null,"Min. RSL (yrs):",null,"Max. DI:",null,"Max. IRI:",null,"Max. Avg. RUT:",null,null,"Column1",null,"IF(A18=\"Flexible\",IF(A25=\"Non-Structural HMA Overlay\",Sheet2!F3,IF(A18=\"Flexible\",IF(A25=\"Surface Milling with Non Structural HMA Overlay\",Sheet2!F5,IF(A18=\"Flexible\",IF(A25=\"Single Chip Seal\",Sheet2!F7,IF(A18=\"Flexible\",IF(A25=\"Double Chip Seal\",Sheet2!F9,IF(A18=\"Flexible\",IF(A25=\"Paver Placed Surface Seal\",Sheet2!F11,IF(A18=\"Flexible\",IF(A25=\"Micro-Surface (Single)\",Sheet2!F13,IF(A18=\"Flexible\",IF(A25=\"Micro-Surface (Double)\",Sheet2!F15,IF(A18=\"Flexible\",IF(A25=\"Crack Treatment\",Sheet2!F17,IF(A18=\"Flexible\",IF(A25=\"Overband Crack Filling\",Sheet2!F19,IF(A18=\"Flexible\",IF(A25=\"Ultra Thin Overlay\",Sheet2!F21))))))))))))))))))),\"\")",null,null,null,null,null,null,"IF(A18=\"Flexible\",IF(A25=\"Non-Structural HMA Overlay\",Sheet2!H3,IF(A18=\"Flexible\",IF(A25=\"Surface Milling with Non Structural HMA Overlay\",Sheet2!H5,IF(A18=\"Flexible\",IF(A25=\"Single Chip Seal\",Sheet2!H7,IF(A18=\"Flexible\",IF(A25=\"Double Chip Seal\",Sheet2!H9,IF(A18=\"Flexible\",IF(A25=\"Paver Placed Surface Seal\",Sheet2!H11,IF(A18=\"Flexible\",IF(A25=\"Micro-Surface (Single)\",Sheet2!H13,IF(A18=\"Flexible\",IF(A25=\"Micro-Surface (Double)\",Sheet2!H15,IF(A18=\"Flexible\",IF(A25=\"Crack Treatment\",Sheet2!H17,IF(A18=\"Flexible\",IF(A25=\"Overband Crack Filling\",Sheet2!H19,IF(A18=\"Flexible\",IF(A25=\"Ultra Thin Overlay\",Sheet2!H21))))))))))))))))))),\"\")",null,null,null,null,null,null,"IF(A18=\"Flexible\",IF(A25=\"Non-Structural HMA Overlay\",Sheet2!J3,IF(A18=\"Flexible\",IF(A25=\"Surface Milling with Non Structural HMA Overlay\",Sheet2!J5,IF(A18=\"Flexible\",IF(A25=\"Single Chip Seal\",Sheet2!J7,IF(A18=\"Flexible\",IF(A25=\"Double Chip Seal\",Sheet2!J9,IF(A18=\"Flexible\",IF(A25=\"Paver Placed Surface Seal\",Sheet2!J11,IF(A18=\"Flexible\",IF(A25=\"Micro-Surface (Single)\",Sheet2!J13,IF(A18=\"Flexible\",IF(A25=\"Micro-Surface (Double)\",Sheet2!J15,IF(A18=\"Flexible\",IF(A25=\"Crack Treatment\",Sheet2!J17,IF(A18=\"Flexible\",IF(A25=\"Overband Crack Filling\",Sheet2!J19,IF(A18=\"Flexible\",IF(A25=\"Ultra Thin Overlay\",Sheet2!J21))))))))))))))))))),\"\")",null,null,null,null,null,null,"IF(A18=\"Flexible\",IF(A25=\"Non-Structural HMA Overlay\",Sheet2!L3,IF(A18=\"Flexible\",IF(A25=\"Surface Milling with Non Structural HMA Overlay\",Sheet2!L5,IF(A18=\"Flexible\",IF(A25=\"Single Chip Seal\",Sheet2!L7,IF(A18=\"Flexible\",IF(A25=\"Double Chip Seal\",Sheet2!L9,IF(A18=\"Flexible\",IF(A25=\"Paver Placed Surface Seal\",Sheet2!L11,IF(A18=\"Flexible\",IF(A25=\"Micro-Surface (Single)\",Sheet2!L13,IF(A18=\"Flexible\",IF(A25=\"Micro-Surface (Double)\",Sheet2!L15,IF(A18=\"Flexible\",IF(A25=\"Crack Treatment\",Sheet2!L17,IF(A18=\"Flexible\",IF(A25=\"Overband Crack Filling\",Sheet2!L19,IF(A18=\"Flexible\",IF(A25=\"Ultra Thin Overlay\",Sheet2!L21))))))))))))))))))),\"\")"]
[null,"Region",null,"Non-Structural HMA Overlay","Flexible",3,null,40,null,163,null,"1/2\"",null,null,"Select"]
[null,null,null,null,"Composite",3,null,25,null,163,null,"1/2\"",null,null,"Non-Structural HMA Overlay"]
[null,"Bay",null,"Surface Milling with Non Structural HMA Overlay","Flexible",3,null,40,null,212,null,"1\"",null,null,"Surface Milling with Non Structural HMA Overlay"]
[null,"Grand",null,null,"Composite",3,null,30,null,212,null,"1\"",null,null,"Single Chip Seal"]
[null,"Metro",null,"Single Chip Seal","Flexible",6,null,25,null,107,null,"1/8\"",null,null,"Double Chip Seal"]
[null,"North",null,null,"Composite","N/A",null,15,null,107,null,"1/8\"",null,null,"Paver Placed Surface Seal"]
[null,"Southwest",null,"Double Chip Seal","Flexible",5,null,30,null,107,null,"1/8\"",null,null,"Micro-Surface (Single)"]
[null,"Superior",null,null,"Composite",5,null,15,null,107,null,"1/8\"",null,null,"Micro-Surface (Double)"]
[null,"University",null,"Paver Placed Surface Seal","Flexible",5,null,30,null,132,null,"1/4\"",null,null,"Crack Treatment"]
[null,null,null,null,"Composite",5,null,15,null,132,null,"1/4\"",null,null,"Overband Crack Filling"]
[null,null,null,"Micro-Surface (Single)","Flexible",10,null,15,null,107,null,"1\"",null,null,"Ultra Thin Overlay"]
[null,"Pavt Type",null,null,"Composite","N/A",null,15,null,107,null,"1\"",null,null,"Full Depth Concrete Paventmet Repair",null,"IF(A18=\"Composite\",IF(A25=\"Non-Structural HMA Overlay\",Sheet2!F4,IF(A18=\"Composite\",IF(A25=\"Surface Milling with Non Structural HMA Overlay\",Sheet2!F6,IF(A18=\"Composite\",IF(A25=\"Single Chip Seal\",Sheet2!F8,IF(A18=\"Composite\",IF(A25=\"Double Chip Seal\",Sheet2!F10,IF(A18=\"Composite\",IF(A25=\"Paver Placed Surface Seal\",Sheet2!F12,IF(A18=\"Composite\",IF(A25=\"Micro-Surface (Single)\",Sheet2!F14,IF(A18=\"Composite\",IF(A25=\"Micro-Surface (Double)\",Sheet2!F16,IF(A18=\"Composite\",IF(A25=\"Crack Treatment\",Sheet2!F18,IF(A18=\"Composite\",IF(A25=\"Overband Crack Filling\",Sheet2!F20,IF(A18=\"Composite\",IF(A25=\"Ultra Thin Overlay\",Sheet2!F22))))))))))))))))))),\"\")",null,null,null,null,null,null,"IF(A18=\"Composite\",IF(A25=\"Non-Structural HMA Overlay\",Sheet2!H4,IF(A18=\"Composite\",IF(A25=\"Surface Milling with Non Structural HMA Overlay\",Sheet2!H6,IF(A18=\"Composite\",IF(A25=\"Single Chip Seal\",Sheet2!H8,IF(A18=\"Composite\",IF(A25=\"Double Chip Seal\",Sheet2!H10,IF(A18=\"Composite\",IF(A25=\"Paver Placed Surface Seal\",Sheet2!H12,IF(A18=\"Composite\",IF(A25=\"Micro-Surface (Single)\",Sheet2!H14,IF(A18=\"Composite\",IF(A25=\"Micro-Surface (Double)\",Sheet2!H16,IF(A18=\"Composite\",IF(A25=\"Crack Treatment\",Sheet2!H18,IF(A18=\"Composite\",IF(A25=\"Overband Crack Filling\",Sheet2!H20,IF(A18=\"Composite\",IF(A25=\"Ultra Thin Overlay\",Sheet2!H22))))))))))))))))))),\"\")",null,null,null,null,null,null,"IF(A18=\"Composite\",IF(A25=\"Non-Structural HMA Overlay\",Sheet2!J4,IF(A18=\"Composite\",IF(A25=\"Surface Milling with Non Structural HMA Overlay\",Sheet2!J6,IF(A18=\"Composite\",IF(A25=\"Single Chip Seal\",Sheet2!J8,IF(A18=\"Composite\",IF(A25=\"Double Chip Seal\",Sheet2!J10,IF(A18=\"Composite\",IF(A25=\"Paver Placed Surface Seal\",Sheet2!J12,IF(A18=\"Composite\",IF(A25=\"Micro-Surface (Single)\",Sheet2!J14,IF(A18=\"Composite\",IF(A25=\"Micro-Surface (Double)\",Sheet2!J16,IF(A18=\"Composite\",IF(A25=\"Crack Treatment\",Sheet2!J18,IF(A18=\"Composite\",IF(A25=\"Overband Crack Filling\",Sheet2!J20,IF(A18=\"Composite\",IF(A25=\"Ultra Thin Overlay\",Sheet2!J22))))))))))))))))))),\"\")",null,null,null,null,null,null,"IF(A18=\"Composite\",IF(A25=\"Non-Structural HMA Overlay\",Sheet2!L4,IF(A18=\"Composite\",IF(A25=\"Surface Milling with Non Structural HMA Overlay\",Sheet2!L6,IF(A18=\"Composite\",IF(A25=\"Single Chip Seal\",Sheet2!L8,IF(A18=\"Composite\",IF(A25=\"Double Chip Seal\",Sheet2!L10,IF(A18=\"Composite\",IF(A25=\"Paver Placed Surface Seal\",Sheet2!L12,IF(A18=\"Composite\",IF(A25=\"Micro-Surface (Single)\",Sheet2!L14,IF(A18=\"Composite\",IF(A25=\"Micro-Surface (Double)\",Sheet2!L16,IF(A18=\"Composite\",IF(A25=\"Crack Treatment\",Sheet2!L18,IF(A18=\"Composite\",IF(A25=\"Overband Crack Filling\",Sheet2!L20,IF(A18=\"Composite\",IF(A25=\"Ultra Thin Overlay\",Sheet2!L22))))))))))))))))))),\"\")"]
[null,"Select",null,"Micro-Surface (Double)","Flexible",5,null,30,null,107,null,"1\"",null,null,"Concrete Joint Resealing"]
[null,"Flexible",null,null,"Composite",5,null,15,null,107,null,"1\"",null,null,"Concrete Crack Sealing"]
[null,"Composite",null,"Crack Treatment","Flexible",10,null,15,null,107,null,"1/8\"",null,null,"Diamond Grinding"]
[null,"Rigid",null,null,"Composite",10,null,15,null,107,null,"1/8\"",null,null,"Dowel Bar Retrofit"]
[null,null,null,"Overband Crack Filling","Flexible",7,null,20,null,107,null,"1/8\"",null,null,"Concrete Pavement Restoration"]
[null,null,null,null,"Composite",7,null,20,null,107,null,"1/8\""]
[null,"Shldr Type",null,"Ultra Thin Overlay","Flexible",7,null,30,null,107,null,"1/8\""]
[null,"Select",null,null,"Composite",7,null,30,null,107,null,"1/8\""]
[null,"Flexible",null,"Full Depth Concrete Paventmet Repair","Rigid",7,null,20,null,107]
[null,"Composite",null,"Concrete Joint Resealing","Rigid",10,null,15,null,107]
[null,"Rigid",null,"Concrete Crack Sealing","Rigid",10,null,15,null,107]
[null,"N/A - C&G",null,"Diamond Grinding","Rigid",12,null,10,null,107,null,null,null,null,null,null,"IF(A18=\"Rigid\",IF(A25=\"Full Depth Concrete Paventmet Repair\",Sheet2!F23,IF(A18=\"Rigid\",IF(A25=\"Concrete Joint Resealing\",Sheet2!F24,IF(A18=\"Rigid\",IF(A25=\"Concrete Crack Sealing\",Sheet2!F25,IF(A18=\"Rigid\",IF(A25=\"Diamond Grinding\",Sheet2!F26,IF(A18=\"Rigid\",IF(A25=\"Dowel Bar Retrofit\",Sheet2!F27,IF(A18=\"Rigid\",IF(A25=\"Concrete Pavement Restoration\",Sheet2!F28))))))))))),\"\")",null,null,null,null,null,null,"IF(A18=\"Rigid\",IF(A25=\"Full Depth Concrete Paventmet Repair\",Sheet2!H23,IF(A18=\"Rigid\",IF(A25=\"Concrete Joint Resealing\",Sheet2!H24,IF(A18=\"Rigid\",IF(A25=\"Concrete Crack Sealing\",Sheet2!H25,IF(A18=\"Rigid\",IF(A25=\"Diamond Grinding\",Sheet2!H26,IF(A18=\"Rigid\",IF(A25=\"Dowel Bar Retrofit\",Sheet2!H27,IF(A18=\"Rigid\",IF(A25=\"Concrete Pavement Restoration\",Sheet2!H28))))))))))),\"\")",null,null,null,null,null,null,"IF(A18=\"Rigid\",IF(A25=\"Full Depth Concrete Paventmet Repair\",Sheet2!J23,IF(A18=\"Rigid\",IF(A25=\"Concrete Joint Resealing\",Sheet2!J24,IF(A18=\"Rigid\",IF(A25=\"Concrete Crack Sealing\",Sheet2!J25,IF(A18=\"Rigid\",IF(A25=\"Diamond Grinding\",Sheet2!J26,IF(A18=\"Rigid\",IF(A25=\"Dowel Bar Retrofit\",Sheet2!J27,IF(A18=\"Rigid\",IF(A25=\"Concrete Pavement Restoration\",Sheet2!J28))))))))))),\"\")"]
[null,null,null,"Dowel Bar Retrofit","Rigid",10,null,15,null,107]
[null,null,null,"Concrete Pavement Restoration","Rigid",3,null,40,null,212]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(All) Min. RSL (yrs):",null,null,null,null,null,null,"(All) Max. DI:",null,null,null,null,null,null,"(All) Max. IRI:",null,null,null,null,null,null,"(Flexable and Composite) Max. Avg. RUT:"]
[null,null,null,"Select",null,null,null,null,null,null,null,null,null,null,null,null,"IF(A18=\"Flexible\",IF(A25=\"Non-Structural HMA Overlay\",Sheet2!F3,IF(A18=\"Flexible\",IF(A25=\"Surface Milling with Non Structural HMA Overlay\",Sheet2!F5,IF(A18=\"Flexible\",IF(A25=\"Single Chip Seal\",Sheet2!F7,IF(A18=\"Flexible\",IF(A25=\"Double Chip Seal\",Sheet2!F9,IF(A18=\"Flexible\",IF(A25=\"Paver Placed Surface Seal\",Sheet2!F11,IF(A18=\"Flexible\",IF(A25=\"Micro-Surface (Single)\",Sheet2!F13,IF(A18=\"Flexible\",IF(A25=\"Micro-Surface (Double)\",Sheet2!F15,IF(A18=\"Flexible\",IF(A25=\"Crack Treatment\",Sheet2!F17,IF(A18=\"Flexible\",IF(A25=\"Overband Crack Filling\",Sheet2!F19,IF(A18=\"Flexible\",IF(A25=\"Ultra Thin Overlay\",Sheet2!F21))))))))))))))))))),IF(A18=\"Composite\",IF(A25=\"Non-Structural HMA Overlay\",Sheet2!F4,IF(A18=\"Composite\",IF(A25=\"Surface Milling with Non Structural HMA Overlay\",Sheet2!F6,IF(A18=\"Composite\",IF(A25=\"Single Chip Seal\",Sheet2!F8,IF(A18=\"Composite\",IF(A25=\"Double Chip Seal\",Sheet2!F10,IF(A18=\"Composite\",IF(A25=\"Paver Placed Surface Seal\",Sheet2!F12,IF(A18=\"Composite\",IF(A25=\"Micro-Surface (Single)\",Sheet2!F14,IF(A18=\"Composite\",IF(A25=\"Micro-Surface (Double)\",Sheet2!F16,IF(A18=\"Composite\",IF(A25=\"Crack Treatment\",Sheet2!F18,IF(A18=\"Composite\",IF(A25=\"Overband Crack Filling\",Sheet2!F20,IF(A18=\"Composite\",IF(A25=\"Ultra Thin Overlay\",Sheet2!F22))))))))))))))))))),IF(A18=\"Rigid\",IF(A25=\"Full Depth Concrete Paventmet Repair\",Sheet2!F23,IF(A18=\"Rigid\",IF(A25=\"Concrete Joint Resealing\",Sheet2!F24,IF(A18=\"Rigid\",IF(A25=\"Concrete Crack Sealing\",Sheet2!F25,IF(A18=\"Rigid\",IF(A25=\"Diamond Grinding\",Sheet2!F26,IF(A18=\"Rigid\",IF(A25=\"Dowel Bar Retrofit\",Sheet2!F27,IF(A18=\"Rigid\",IF(A25=\"Concrete Pavement Restoration\",Sheet2!F28))))))))))),\"\")))",null,null,null,null,null,null,"IF(A18=\"Flexible\",IF(A25=\"Non-Structural HMA Overlay\",Sheet2!H3,IF(A18=\"Flexible\",IF(A25=\"Surface Milling with Non Structural HMA Overlay\",Sheet2!H5,IF(A18=\"Flexible\",IF(A25=\"Single Chip Seal\",Sheet2!H7,IF(A18=\"Flexible\",IF(A25=\"Double Chip Seal\",Sheet2!H9,IF(A18=\"Flexible\",IF(A25=\"Paver Placed Surface Seal\",Sheet2!H11,IF(A18=\"Flexible\",IF(A25=\"Micro-Surface (Single)\",Sheet2!H13,IF(A18=\"Flexible\",IF(A25=\"Micro-Surface (Double)\",Sheet2!H15,IF(A18=\"Flexible\",IF(A25=\"Crack Treatment\",Sheet2!H17,IF(A18=\"Flexible\",IF(A25=\"Overband Crack Filling\",Sheet2!H19,IF(A18=\"Flexible\",IF(A25=\"Ultra Thin Overlay\",Sheet2!H21))))))))))))))))))),IF(A18=\"Composite\",IF(A25=\"Non-Structural HMA Overlay\",Sheet2!H4,IF(A18=\"Composite\",IF(A25=\"Surface Milling with Non Structural HMA Overlay\",Sheet2!H6,IF(A18=\"Composite\",IF(A25=\"Single Chip Seal\",Sheet2!H8,IF(A18=\"Composite\",IF(A25=\"Double Chip Seal\",Sheet2!H10,IF(A18=\"Composite\",IF(A25=\"Paver Placed Surface Seal\",Sheet2!H12,IF(A18=\"Composite\",IF(A25=\"Micro-Surface (Single)\",Sheet2!H14,IF(A18=\"Composite\",IF(A25=\"Micro-Surface (Double)\",Sheet2!H16,IF(A18=\"Composite\",IF(A25=\"Crack Treatment\",Sheet2!H18,IF(A18=\"Composite\",IF(A25=\"Overband Crack Filling\",Sheet2!H20,IF(A18=\"Composite\",IF(A25=\"Ultra Thin Overlay\",Sheet2!H22))))))))))))))))))),IF(A18=\"Rigid\",IF(A25=\"Full Depth Concrete Paventmet Repair\",Sheet2!H23,IF(A18=\"Rigid\",IF(A25=\"Concrete Joint Resealing\",Sheet2!H24,IF(A18=\"Rigid\",IF(A25=\"Concrete Crack Sealing\",Sheet2!H25,IF(A18=\"Rigid\",IF(A25=\"Diamond Grinding\",Sheet2!H26,IF(A18=\"Rigid\",IF(A25=\"Dowel Bar Retrofit\",Sheet2!H27,IF(A18=\"Rigid\",IF(A25=\"Concrete Pavement Restoration\",Sheet2!H28))))))))))),\"\")))",null,null,null,null,null,null,"IF(A18=\"Flexible\",IF(A25=\"Non-Structural HMA Overlay\",Sheet2!J3,IF(A18=\"Flexible\",IF(A25=\"Surface Milling with Non Structural HMA Overlay\",Sheet2!J5,IF(A18=\"Flexible\",IF(A25=\"Single Chip Seal\",Sheet2!J7,IF(A18=\"Flexible\",IF(A25=\"Double Chip Seal\",Sheet2!J9,IF(A18=\"Flexible\",IF(A25=\"Paver Placed Surface Seal\",Sheet2!J11,IF(A18=\"Flexible\",IF(A25=\"Micro-Surface (Single)\",Sheet2!J13,IF(A18=\"Flexible\",IF(A25=\"Micro-Surface (Double)\",Sheet2!J15,IF(A18=\"Flexible\",IF(A25=\"Crack Treatment\",Sheet2!J17,IF(A18=\"Flexible\",IF(A25=\"Overband Crack Filling\",Sheet2!J19,IF(A18=\"Flexible\",IF(A25=\"Ultra Thin Overlay\",Sheet2!J21))))))))))))))))))),IF(A18=\"Composite\",IF(A25=\"Non-Structural HMA Overlay\",Sheet2!J4,IF(A18=\"Composite\",IF(A25=\"Surface Milling with Non Structural HMA Overlay\",Sheet2!J6,IF(A18=\"Composite\",IF(A25=\"Single Chip Seal\",Sheet2!J8,IF(A18=\"Composite\",IF(A25=\"Double Chip Seal\",Sheet2!J10,IF(A18=\"Composite\",IF(A25=\"Paver Placed Surface Seal\",Sheet2!J12,IF(A18=\"Composite\",IF(A25=\"Micro-Surface (Single)\",Sheet2!J14,IF(A18=\"Composite\",IF(A25=\"Micro-Surface (Double)\",Sheet2!J16,IF(A18=\"Composite\",IF(A25=\"Crack Treatment\",Sheet2!J18,IF(A18=\"Composite\",IF(A25=\"Overband Crack Filling\",Sheet2!J20,IF(A18=\"Composite\",IF(A25=\"Ultra Thin Overlay\",Sheet2!J22))))))))))))))))))),IF(A18=\"Rigid\",IF(A25=\"Full Depth Concrete Paventmet Repair\",Sheet2!J23,IF(A18=\"Rigid\",IF(A25=\"Concrete Joint Resealing\",Sheet2!J24,IF(A18=\"Rigid\",IF(A25=\"Concrete Crack Sealing\",Sheet2!J25,IF(A18=\"Rigid\",IF(A25=\"Diamond Grinding\",Sheet2!J26,IF(A18=\"Rigid\",IF(A25=\"Dowel Bar Retrofit\",Sheet2!J27,IF(A18=\"Rigid\",IF(A25=\"Concrete Pavement Restoration\",Sheet2!J28))))))))))),\"\")))",null,null,null,null,null,null,"IF(A18=\"Flexible\",IF(A25=\"Non-Structural HMA Overlay\",Sheet2!L3,IF(A18=\"Flexible\",IF(A25=\"Surface Milling with Non Structural HMA Overlay\",Sheet2!L5,IF(A18=\"Flexible\",IF(A25=\"Single Chip Seal\",Sheet2!L7,IF(A18=\"Flexible\",IF(A25=\"Double Chip Seal\",Sheet2!L9,IF(A18=\"Flexible\",IF(A25=\"Paver Placed Surface Seal\",Sheet2!L11,IF(A18=\"Flexible\",IF(A25=\"Micro-Surface (Single)\",Sheet2!L13,IF(A18=\"Flexible\",IF(A25=\"Micro-Surface (Double)\",Sheet2!L15,IF(A18=\"Flexible\",IF(A25=\"Crack Treatment\",Sheet2!L17,IF(A18=\"Flexible\",IF(A25=\"Overband Crack Filling\",Sheet2!L19,IF(A18=\"Flexible\",IF(A25=\"Ultra Thin Overlay\",Sheet2!L21))))))))))))))))))),IF(A18=\"Composite\",IF(A25=\"Non-Structural HMA Overlay\",Sheet2!L4,IF(A18=\"Composite\",IF(A25=\"Surface Milling with Non Structural HMA Overlay\",Sheet2!L6,IF(A18=\"Composite\",IF(A25=\"Single Chip Seal\",Sheet2!L8,IF(A18=\"Composite\",IF(A25=\"Double Chip Seal\",Sheet2!L10,IF(A18=\"Composite\",IF(A25=\"Paver Placed Surface Seal\",Sheet2!L12,IF(A18=\"Composite\",IF(A25=\"Micro-Surface (Single)\",Sheet2!L14,IF(A18=\"Composite\",IF(A25=\"Micro-Surface (Double)\",Sheet2!L16,IF(A18=\"Composite\",IF(A25=\"Crack Treatment\",Sheet2!L18,IF(A18=\"Composite\",IF(A25=\"Overband Crack Filling\",Sheet2!L20,IF(A18=\"Composite\",IF(A25=\"Ultra Thin Overlay\",Sheet2!L22))))))))))))))))))),\"\"))"]
[null,null,null,"CAPITAL PREVENTIVE MAINTENANCE (CPM)"]
[null,null,null,"NON-FREEWAY RESURFACING PROGRAM (NFRP)"]
[null,null,null,"FREEWAY RESURFACING PROGRAM (FRP)"]