{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["LOS Target Setting","LOS and Grade Scales","Program Performance","Critical Safety","Safety-Mobility","Stewardship","Ride-Comfort","Aesthetics"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":325,"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":"LOS Target Setting","index":0,"n_rows":57,"n_cols":12,"rows_kept":57,"cut":false,"hidden":false,"merged":[[41,5,44,7],[48,5,51,7],[52,2,53,2],[52,3,52,4],[53,3,53,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[50,2,50,3],[51,2,51,3],[54,1,56,2],[48,1,50,1],[41,1,44,1],[31,1,37,1],[17,1,27,1],[45,2,47,2],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[30,3,30,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[48,2,48,3],[49,2,49,3],[0,2,0,7],[4,5,5,5],[4,6,5,6],[8,9,9,9],[3,5,3,7],[4,7,5,7],[1,1,1,7],[2,1,2,7],[1,9,2,10],[6,1,13,1],[6,2,6,3],[7,2,7,3],[8,2,8,3],[25,3,25,4],[26,3,26,4],[7,10,9,10],[7,8,7,9],[8,8,9,8],[17,5,20,7],[6,5,9,7],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[31,5,34,7],[35,3,35,4],[36,3,36,4],[37,3,37,4],[31,2,31,3],[38,3,38,4],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,40,2],[39,3,39,4],[40,3,40,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[3,1,5,1],[3,2,5,4],[10,2,16,2],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[9,2,9,3],[21,2,30,2],[24,3,24,4]]}
[null,"DIRECTIONS","Note: The EXCEL Solver Add-in must be installed. "]
[null,"To solve for ATTAINABLE LOS TARGETS:  Use the button on the right to reset the input table below.  Enter the available budget for each goal,  the baseline and maximum acceptable deficiency rates for each feature. Use the solve goal buttons to find attainable targets. Repeat for all five goals."]
[null,"To solve for COST TO ACHIEVE DESIRED LOS TARGETS: Use the button on the right to reset the input table below. Enter the baseline deficiency rates.  Set the maximum acceptable deficiency rates to desired targets.  Use the solve goal buttons to find costs. Repeat for all five goals."]
[null,"Goal",null,null,null,"Deficiency Rate"]
[null,null,null,null,null,"Baseline","Maximum Acceptable","Target"]
[]
[null,"Critical Safety","Available Budget for Critical Safety",null,0]
[null,null,"Baseline LOS Grade",null,{"$f":"'Critical Safety'!$H$5","v":"C"},null,null,null,"LOS Grade",null,"Target Budget Allocation"]
[null,null,"Estimated Cost",null,{"$f":"MROUND('Critical Safety'!$H$3,1000)","v":43218000},null,null,null,"Baseline","Target"]
[null,null,"Target LOS Grade",null,{"$f":"'Critical Safety'!$H$7","v":"C"}]
[null,null,"Features","Emergency repair of regulator / warning signs",null,3,5,{"$f":"'Critical Safety'!D24","v":5},{"$f":"IF(F11<='LOS and Grade Scales'!$D$6,\"A\",IF(F11<='LOS and Grade Scales'!$F$6, \"B\", IF(F11<='LOS and Grade Scales'!$H$6,\"C\",IF(F11<='LOS and Grade Scales'!$J$6,\"D\",\"F\"))))","v":"B"},{"$f":"IF(H11<='LOS and Grade Scales'!$D$6,\"A\",IF(H11<='LOS and Grade Scales'!$F$6, \"B\", IF(H11<='LOS and Grade Scales'!$H$6,\"C\",IF(H11<='LOS and Grade Scales'!$J$6,\"D\",\"F\"))))","v":"B"},{"$f":"MROUND('Critical Safety'!F24,1000)","v":818000}]
[null,null,null,"Hazardous debris",null,7,9,{"$f":"'Critical Safety'!D25","v":9},{"$f":"IF(F12<='LOS and Grade Scales'!$D$6,\"A\",IF(F12<='LOS and Grade Scales'!$F$6, \"B\", IF(F12<='LOS and Grade Scales'!$H$6,\"C\",IF(F12<='LOS and Grade Scales'!$J$6,\"D\",\"F\"))))","v":"C"},{"$f":"IF(H12<='LOS and Grade Scales'!$D$6,\"A\",IF(H12<='LOS and Grade Scales'!$F$6, \"B\", IF(H12<='LOS and Grade Scales'!$H$6,\"C\",IF(H12<='LOS and Grade Scales'!$J$6,\"D\",\"F\"))))","v":"C"},{"$f":"MROUND('Critical Safety'!F25,1000)","v":16208000}]
[null,null,null,"Protective barriers",null,5,5,{"$f":"'Critical Safety'!D26","v":5},{"$f":"IF(F13<='LOS and Grade Scales'!$D$6,\"A\",IF(F13<='LOS and Grade Scales'!$F$6, \"B\", IF(F13<='LOS and Grade Scales'!$H$6,\"C\",IF(F13<='LOS and Grade Scales'!$J$6,\"D\",\"F\"))))","v":"B"},{"$f":"IF(H13<='LOS and Grade Scales'!$D$6,\"A\",IF(H13<='LOS and Grade Scales'!$F$6, \"B\", IF(H13<='LOS and Grade Scales'!$H$6,\"C\",IF(H13<='LOS and Grade Scales'!$J$6,\"D\",\"F\"))))","v":"B"},{"$f":"MROUND('Critical Safety'!F26,1000)","v":8486000}]
[null,null,null,"Centerline markings",null,6,6,{"$f":"'Critical Safety'!D27","v":6},{"$f":"IF(F14<='LOS and Grade Scales'!$D$6,\"A\",IF(F14<='LOS and Grade Scales'!$F$6, \"B\", IF(F14<='LOS and Grade Scales'!$H$6,\"C\",IF(F14<='LOS and Grade Scales'!$J$6,\"D\",\"F\"))))","v":"C"},{"$f":"IF(H14<='LOS and Grade Scales'!$D$6,\"A\",IF(H14<='LOS and Grade Scales'!$F$6, \"B\", IF(H14<='LOS and Grade Scales'!$H$6,\"C\",IF(H14<='LOS and Grade Scales'!$J$6,\"D\",\"F\"))))","v":"C"},{"$f":"MROUND('Critical Safety'!F27,1000)","v":2130000}]
[null,"Priority Weight:",null,"Edgeline markings",null,7,8,{"$f":"'Critical Safety'!D28","v":8},{"$f":"IF(F15<='LOS and Grade Scales'!$D$6,\"A\",IF(F15<='LOS and Grade Scales'!$F$6, \"B\", IF(F15<='LOS and Grade Scales'!$H$6,\"C\",IF(F15<='LOS and Grade Scales'!$J$6,\"D\",\"F\"))))","v":"C"},{"$f":"IF(H15<='LOS and Grade Scales'!$D$6,\"A\",IF(H15<='LOS and Grade Scales'!$F$6, \"B\", IF(H15<='LOS and Grade Scales'!$H$6,\"C\",IF(H15<='LOS and Grade Scales'!$J$6,\"D\",\"F\"))))","v":"C"},{"$f":"MROUND('Critical Safety'!F28,1000)","v":5631000}]
[null,0.51,null,"Unpaved shoulder drop-off / buildup",null,37,25,{"$f":"'Critical Safety'!D29","v":25},{"$f":"IF(F16<='LOS and Grade Scales'!$D$6,\"A\",IF(F16<='LOS and Grade Scales'!$F$6, \"B\", IF(F16<='LOS and Grade Scales'!$H$6,\"C\",IF(F16<='LOS and Grade Scales'!$J$6,\"D\",\"F\"))))","v":"F"},{"$f":"IF(H16<='LOS and Grade Scales'!$D$6,\"A\",IF(H16<='LOS and Grade Scales'!$F$6, \"B\", IF(H16<='LOS and Grade Scales'!$H$6,\"C\",IF(H16<='LOS and Grade Scales'!$J$6,\"D\",\"F\"))))","v":"F"},{"$f":"MROUND('Critical Safety'!F29,1000)","v":2640000}]
[null,null,null,"Paved shoulder drop off / build up",null,3,5,{"$f":"'Critical Safety'!D30","v":5},{"$f":"IF(F17<='LOS and Grade Scales'!$D$6,\"A\",IF(F17<='LOS and Grade Scales'!$F$6, \"B\", IF(F17<='LOS and Grade Scales'!$H$6,\"C\",IF(F17<='LOS and Grade Scales'!$J$6,\"D\",\"F\"))))","v":"B"},{"$f":"IF(H17<='LOS and Grade Scales'!$D$6,\"A\",IF(H17<='LOS and Grade Scales'!$F$6, \"B\", IF(H17<='LOS and Grade Scales'!$H$6,\"C\",IF(H17<='LOS and Grade Scales'!$J$6,\"D\",\"F\"))))","v":"B"},{"$f":"MROUND('Critical Safety'!F30,1000)","v":7305000}]
[null,"Safety / Mobility","Available Budget for Safety / Mobility",null,0]
[null,null,"Baseline LOS Grade",null,{"$f":"'Safety-Mobility'!$H$5","v":"B"},null,null,null,null,null,null," "]
[null,null,"Estimated Cost",null,{"$f":"MROUND('Safety-Mobility'!$H$3,1000)","v":31184000}]
[null,null,"Target LOS Grade",null,{"$f":"'Safety-Mobility'!$H$7","v":"B"}]
[null,null,"Features","Woody vegetation control for vision",null,1,5,{"$f":"'Safety-Mobility'!D27","v":5},{"$f":"IF(F22<='LOS and Grade Scales'!$D$7,\"A\",IF(F22<='LOS and Grade Scales'!$F$7, \"B\", IF(F22<='LOS and Grade Scales'!$H$7,\"C\",IF(F22<='LOS and Grade Scales'!$J$7,\"D\",\"F\"))))","v":"A"},{"$f":"IF(H22<='LOS and Grade Scales'!$D$7,\"A\",IF(H22<='LOS and Grade Scales'!$F$7, \"B\", IF(H22<='LOS and Grade Scales'!$H$7,\"C\",IF(H22<='LOS and Grade Scales'!$J$7,\"D\",\"F\"))))","v":"B"},{"$f":"MROUND('Safety-Mobility'!F27,1000)","v":2964000}]
[null,null,null,"Mowing for vision",null,1,5,{"$f":"'Safety-Mobility'!D28","v":5},{"$f":"IF(F23<='LOS and Grade Scales'!$D$7,\"A\",IF(F23<='LOS and Grade Scales'!$F$7, \"B\", IF(F23<='LOS and Grade Scales'!$H$7,\"C\",IF(F23<='LOS and Grade Scales'!$J$7,\"D\",\"F\"))))","v":"A"},{"$f":"IF(H23<='LOS and Grade Scales'!$D$7,\"A\",IF(H23<='LOS and Grade Scales'!$F$7, \"B\", IF(H23<='LOS and Grade Scales'!$H$7,\"C\",IF(H23<='LOS and Grade Scales'!$J$7,\"D\",\"F\"))))","v":"B"},{"$f":"MROUND('Safety-Mobility'!F28,1000)","v":3132000}]
[null,null,null,"Special pavement markings",null,10,5,{"$f":"'Safety-Mobility'!D29","v":5},{"$f":"IF(F24<='LOS and Grade Scales'!$D$7,\"A\",IF(F24<='LOS and Grade Scales'!$F$7, \"B\", IF(F24<='LOS and Grade Scales'!$H$7,\"C\",IF(F24<='LOS and Grade Scales'!$J$7,\"D\",\"F\"))))","v":"C"},{"$f":"IF(H24<='LOS and Grade Scales'!$D$7,\"A\",IF(H24<='LOS and Grade Scales'!$F$7, \"B\", IF(H24<='LOS and Grade Scales'!$H$7,\"C\",IF(H24<='LOS and Grade Scales'!$J$7,\"D\",\"F\"))))","v":"B"},{"$f":"MROUND('Safety-Mobility'!F29,1000)","v":4562000}]
[null,null,null,"Woody vegetation (clear zone)",null,2,5,{"$f":"'Safety-Mobility'!D30","v":5},{"$f":"IF(F25<='LOS and Grade Scales'!$D$7,\"A\",IF(F25<='LOS and Grade Scales'!$F$7, \"B\", IF(F25<='LOS and Grade Scales'!$H$7,\"C\",IF(F25<='LOS and Grade Scales'!$J$7,\"D\",\"F\"))))","v":"A"},{"$f":"IF(H25<='LOS and Grade Scales'!$D$7,\"A\",IF(H25<='LOS and Grade Scales'!$F$7, \"B\", IF(H25<='LOS and Grade Scales'!$H$7,\"C\",IF(H25<='LOS and Grade Scales'!$J$7,\"D\",\"F\"))))","v":"B"},{"$f":"MROUND('Safety-Mobility'!F30,1000)","v":4184000}]
[null,null,null,"Culverts",null,22,15,{"$f":"'Safety-Mobility'!D31","v":15},{"$f":"IF(F26<='LOS and Grade Scales'!$D$7,\"A\",IF(F26<='LOS and Grade Scales'!$F$7, \"B\", IF(F26<='LOS and Grade Scales'!$H$7,\"C\",IF(F26<='LOS and Grade Scales'!$J$7,\"D\",\"F\"))))","v":"D"},{"$f":"IF(H26<='LOS and Grade Scales'!$D$7,\"A\",IF(H26<='LOS and Grade Scales'!$F$7, \"B\", IF(H26<='LOS and Grade Scales'!$H$7,\"C\",IF(H26<='LOS and Grade Scales'!$J$7,\"D\",\"F\"))))","v":"C"},{"$f":"MROUND('Safety-Mobility'!F31,1000)","v":1393000}]
[null,null,null,"Storm sewer",null,17,15,{"$f":"'Safety-Mobility'!D32","v":15},{"$f":"IF(F27<='LOS and Grade Scales'!$D$7,\"A\",IF(F27<='LOS and Grade Scales'!$F$7, \"B\", IF(F27<='LOS and Grade Scales'!$H$7,\"C\",IF(F27<='LOS and Grade Scales'!$J$7,\"D\",\"F\"))))","v":"C"},{"$f":"IF(H27<='LOS and Grade Scales'!$D$7,\"A\",IF(H27<='LOS and Grade Scales'!$F$7, \"B\", IF(H27<='LOS and Grade Scales'!$H$7,\"C\",IF(H27<='LOS and Grade Scales'!$J$7,\"D\",\"F\"))))","v":"C"},{"$f":"MROUND('Safety-Mobility'!F32,1000)","v":1238000}]
[null,null,null,"Cross slope on unpaved shoulders",null,27,15,{"$f":"'Safety-Mobility'!D33","v":15},{"$f":"IF(F28<='LOS and Grade Scales'!$D$7,\"A\",IF(F28<='LOS and Grade Scales'!$F$7, \"B\", IF(F28<='LOS and Grade Scales'!$H$7,\"C\",IF(F28<='LOS and Grade Scales'!$J$7,\"D\",\"F\"))))","v":"D"},{"$f":"IF(H28<='LOS and Grade Scales'!$D$7,\"A\",IF(H28<='LOS and Grade Scales'!$F$7, \"B\", IF(H28<='LOS and Grade Scales'!$H$7,\"C\",IF(H28<='LOS and Grade Scales'!$J$7,\"D\",\"F\"))))","v":"C"},{"$f":"MROUND('Safety-Mobility'!F33,1000)","v":8792000}]
[null,"Priority Weight:",null,"Delineators",null,25,15,{"$f":"'Safety-Mobility'!D34","v":15},{"$f":"IF(F29<='LOS and Grade Scales'!$D$7,\"A\",IF(F29<='LOS and Grade Scales'!$F$7, \"B\", IF(F29<='LOS and Grade Scales'!$H$7,\"C\",IF(F29<='LOS and Grade Scales'!$J$7,\"D\",\"F\"))))","v":"D"},{"$f":"IF(H29<='LOS and Grade Scales'!$D$7,\"A\",IF(H29<='LOS and Grade Scales'!$F$7, \"B\", IF(H29<='LOS and Grade Scales'!$H$7,\"C\",IF(H29<='LOS and Grade Scales'!$J$7,\"D\",\"F\"))))","v":"C"},{"$f":"MROUND('Safety-Mobility'!F34,1000)","v":1823000}," "]
[null,0.28000000000000003,null,"Routine replacement of regulatory / warning signs",null,15,10,{"$f":"'Safety-Mobility'!D35","v":10},{"$f":"IF(F30<='LOS and Grade Scales'!$D$7,\"A\",IF(F30<='LOS and Grade Scales'!$F$7, \"B\", IF(F30<='LOS and Grade Scales'!$H$7,\"C\",IF(F30<='LOS and Grade Scales'!$J$7,\"D\",\"F\"))))","v":"C"},{"$f":"IF(H30<='LOS and Grade Scales'!$D$7,\"A\",IF(H30<='LOS and Grade Scales'!$F$7, \"B\", IF(H30<='LOS and Grade Scales'!$H$7,\"C\",IF(H30<='LOS and Grade Scales'!$J$7,\"D\",\"F\"))))","v":"C"},{"$f":"MROUND('Safety-Mobility'!F35,1000)","v":3392000}]
[null,null,null,"Fences",null,1,5,{"$f":"'Safety-Mobility'!D36","v":4.666666666666667},{"$f":"IF(F31<='LOS and Grade Scales'!$D$7,\"A\",IF(F31<='LOS and Grade Scales'!$F$7, \"B\", IF(F31<='LOS and Grade Scales'!$H$7,\"C\",IF(F31<='LOS and Grade Scales'!$J$7,\"D\",\"F\"))))","v":"A"},{"$f":"IF(H31<='LOS and Grade Scales'!$D$7,\"A\",IF(H31<='LOS and Grade Scales'!$F$7, \"B\", IF(H31<='LOS and Grade Scales'!$H$7,\"C\",IF(H31<='LOS and Grade Scales'!$J$7,\"D\",\"F\"))))","v":"B"},{"$f":"MROUND('Safety-Mobility'!F36,1000)","v":{"$error":"#NUM!"}}]
[null,"Stewardship","Available Budget for Stewardship",null,0]
[null,null,"Baseline LOS Grade",null,{"$f":"Stewardship!$H$5","v":"B"}]
[null,null,"Estimated Cost",null,{"$f":"MROUND(Stewardship!$H$3,1000)","v":13996000}]
[null,null,"Target LOS Grade",null,{"$f":"Stewardship!$H$7","v":"A"}]
[null,null,"Features","Ditches",null,3,5,{"$f":"Stewardship!D23","v":5},{"$f":"IF(F36<='LOS and Grade Scales'!$D$8,\"A\",IF(F36<='LOS and Grade Scales'!$F$8, \"B\", IF(F36<='LOS and Grade Scales'!$H$8,\"C\",IF(F36<='LOS and Grade Scales'!$J$8,\"D\",\"F\"))))","v":"A"},{"$f":"IF(H36<='LOS and Grade Scales'!$D$8,\"A\",IF(H36<='LOS and Grade Scales'!$F$8, \"B\", IF(H36<='LOS and Grade Scales'!$H$8,\"C\",IF(H36<='LOS and Grade Scales'!$J$8,\"D\",\"F\"))))","v":"A"},{"$f":"MROUND(Stewardship!F23,1000)","v":4377000}]
[null,null,null,"Curb and gutter",null,4,5,{"$f":"Stewardship!D24","v":0},{"$f":"IF(F37<='LOS and Grade Scales'!$D$8,\"A\",IF(F37<='LOS and Grade Scales'!$F$8, \"B\", IF(F37<='LOS and Grade Scales'!$H$8,\"C\",IF(F37<='LOS and Grade Scales'!$J$8,\"D\",\"F\"))))","v":"A"},{"$f":"IF(H37<='LOS and Grade Scales'!$D$8,\"A\",IF(H37<='LOS and Grade Scales'!$F$8, \"B\", IF(H37<='LOS and Grade Scales'!$H$8,\"C\",IF(H37<='LOS and Grade Scales'!$J$8,\"D\",\"F\"))))","v":"A"},{"$f":"MROUND(Stewardship!F24,1000)","v":259000}]
[null,null,null,"Flumes",null,39,25,{"$f":"Stewardship!D25","v":0},{"$f":"IF(F38<='LOS and Grade Scales'!$D$8,\"A\",IF(F38<='LOS and Grade Scales'!$F$8, \"B\", IF(F38<='LOS and Grade Scales'!$H$8,\"C\",IF(F38<='LOS and Grade Scales'!$J$8,\"D\",\"F\"))))","v":"D"},{"$f":"IF(H38<='LOS and Grade Scales'!$D$8,\"A\",IF(H38<='LOS and Grade Scales'!$F$8, \"B\", IF(H38<='LOS and Grade Scales'!$H$8,\"C\",IF(H38<='LOS and Grade Scales'!$J$8,\"D\",\"F\"))))","v":"A"},{"$f":"MROUND(Stewardship!F25,1000)","v":224000}]
[null,"Priority Weight:",null,"Cracking on paved shoulders",null,60,35,{"$f":"Stewardship!D26","v":35},{"$f":"IF(F39<='LOS and Grade Scales'!$D$8,\"A\",IF(F39<='LOS and Grade Scales'!$F$8, \"B\", IF(F39<='LOS and Grade Scales'!$H$8,\"C\",IF(F39<='LOS and Grade Scales'!$J$8,\"D\",\"F\"))))","v":"F"},{"$f":"IF(H39<='LOS and Grade Scales'!$D$8,\"A\",IF(H39<='LOS and Grade Scales'!$F$8, \"B\", IF(H39<='LOS and Grade Scales'!$H$8,\"C\",IF(H39<='LOS and Grade Scales'!$J$8,\"D\",\"F\"))))","v":"D"},{"$f":"MROUND(Stewardship!F26,1000)","v":6017000}]
[null,0.13,null,"Erosion on unpaved shoulders",null,2,5,{"$f":"Stewardship!D27","v":5},{"$f":"IF(F40<='LOS and Grade Scales'!$D$8,\"A\",IF(F40<='LOS and Grade Scales'!$F$8, \"B\", IF(F40<='LOS and Grade Scales'!$H$8,\"C\",IF(F40<='LOS and Grade Scales'!$J$8,\"D\",\"F\"))))","v":"A"},{"$f":"IF(H40<='LOS and Grade Scales'!$D$8,\"A\",IF(H40<='LOS and Grade Scales'!$F$8, \"B\", IF(H40<='LOS and Grade Scales'!$H$8,\"C\",IF(H40<='LOS and Grade Scales'!$J$8,\"D\",\"F\"))))","v":"A"},{"$f":"MROUND(Stewardship!F27,1000)","v":2842000}]
[null,null,null,"Drains",null,33,25,{"$f":"Stewardship!D28","v":6},{"$f":"IF(F41<='LOS and Grade Scales'!$D$8,\"A\",IF(F41<='LOS and Grade Scales'!$F$8, \"B\", IF(F41<='LOS and Grade Scales'!$H$8,\"C\",IF(F41<='LOS and Grade Scales'!$J$8,\"D\",\"F\"))))","v":"D"},{"$f":"IF(H41<='LOS and Grade Scales'!$D$8,\"A\",IF(H41<='LOS and Grade Scales'!$F$8, \"B\", IF(H41<='LOS and Grade Scales'!$H$8,\"C\",IF(H41<='LOS and Grade Scales'!$J$8,\"D\",\"F\"))))","v":"A"},{"$f":"MROUND(Stewardship!F28,1000)","v":278000}]
[null,"Ride / Comfort","Available Budget for Ride / Comfort",null,0]
[null,null,"Baseline LOS Grade",null,{"$f":"'Ride-Comfort'!$H$5","v":"B"}]
[null,null,"Estimated Cost",null,{"$f":"MROUND('Ride-Comfort'!$H$3,1000)","v":7455000}]
[null,null,"Target LOS Grade",null,{"$f":"'Ride-Comfort'!$H$7","v":"A"}]
[null,"Priority Weight:","Features","Potholes / raveling on paved shoulders",null,6,5,{"$f":"'Ride-Comfort'!D20","v":4},{"$f":"IF(F46<='LOS and Grade Scales'!$D$9,\"A\",IF(F46<='LOS and Grade Scales'!$F$9, \"B\", IF(F46<='LOS and Grade Scales'!$H$9,\"C\",IF(F46<='LOS and Grade Scales'!$J$9,\"D\",\"F\"))))","v":"A"},{"$f":"IF(H46<='LOS and Grade Scales'!$D$9,\"A\",IF(H46<='LOS and Grade Scales'!$F$9, \"B\", IF(H46<='LOS and Grade Scales'!$H$9,\"C\",IF(H46<='LOS and Grade Scales'!$J$9,\"D\",\"F\"))))","v":"A"},{"$f":"MROUND('Ride-Comfort'!F20,1000)","v":2114000}]
[null,0.05,null,"Emergency repair of “other” signs",null,4,5,{"$f":"'Ride-Comfort'!D21","v":5},{"$f":"IF(F47<='LOS and Grade Scales'!$D$9,\"A\",IF(F47<='LOS and Grade Scales'!$F$9, \"B\", IF(F47<='LOS and Grade Scales'!$H$9,\"C\",IF(F47<='LOS and Grade Scales'!$J$9,\"D\",\"F\"))))","v":"A"},{"$f":"IF(H47<='LOS and Grade Scales'!$D$9,\"A\",IF(H47<='LOS and Grade Scales'!$F$9, \"B\", IF(H47<='LOS and Grade Scales'!$H$9,\"C\",IF(H47<='LOS and Grade Scales'!$J$9,\"D\",\"F\"))))","v":"A"},{"$f":"MROUND('Ride-Comfort'!F21,1000)","v":843000}]
[null,null,null,"Routine replacement of “other” signs",null,39,20,{"$f":"'Ride-Comfort'!D22","v":19},{"$f":"IF(F48<='LOS and Grade Scales'!$D$9,\"A\",IF(F48<='LOS and Grade Scales'!$F$9, \"B\", IF(F48<='LOS and Grade Scales'!$H$9,\"C\",IF(F48<='LOS and Grade Scales'!$J$9,\"D\",\"F\"))))","v":"D"},{"$f":"IF(H48<='LOS and Grade Scales'!$D$9,\"A\",IF(H48<='LOS and Grade Scales'!$F$9, \"B\", IF(H48<='LOS and Grade Scales'!$H$9,\"C\",IF(H48<='LOS and Grade Scales'!$J$9,\"D\",\"F\"))))","v":"C"},{"$f":"MROUND('Ride-Comfort'!F22,1000)","v":4497000}]
[null,"Aesthetics","Available Budget for Aesthetics",null,0]
[null,null,"Baseline LOS Grade",null,{"$f":"Aesthetics!$H$5","v":"C"}]
[null,null,"Estimated Cost",null,{"$f":"MROUND(Aesthetics!$H$3,1000)","v":22857000}]
[null,"Priority Weight:","Target LOS Grade",null,{"$f":"Aesthetics!$H$7","v":"A"}]
[null,0.03,"Features","Mowing",null,38,40,{"$f":"Aesthetics!D19","v":0},{"$f":"IF(F53<='LOS and Grade Scales'!$D$10,\"A\",IF(F53<='LOS and Grade Scales'!$E$10, \"B\", IF(F53<='LOS and Grade Scales'!$H$10,\"C\",IF(F53<='LOS and Grade Scales'!$J$10,\"D\",\"F\"))))","v":"C"},{"$f":"IF(H53<='LOS and Grade Scales'!$D$10,\"A\",IF(H53<='LOS and Grade Scales'!$E$10, \"B\", IF(H53<='LOS and Grade Scales'!$H$10,\"C\",IF(H53<='LOS and Grade Scales'!$J$10,\"D\",\"F\"))))","v":"A"},{"$f":"MROUND(Aesthetics!F19,1000)","v":3410000}]
[null,null,null,"Litter",null,63,45,{"$f":"Aesthetics!D20","v":43},{"$f":"IF(F54<='LOS and Grade Scales'!$D$10,\"A\",IF(F54<='LOS and Grade Scales'!$E$10, \"B\", IF(F54<='LOS and Grade Scales'!$H$10,\"C\",IF(F54<='LOS and Grade Scales'!$J$10,\"D\",\"F\"))))","v":"D"},{"$f":"IF(H54<='LOS and Grade Scales'!$D$10,\"A\",IF(H54<='LOS and Grade Scales'!$E$10, \"B\", IF(H54<='LOS and Grade Scales'!$H$10,\"C\",IF(H54<='LOS and Grade Scales'!$J$10,\"D\",\"F\"))))","v":"C"},{"$f":"MROUND(Aesthetics!F20,1000)","v":19447000}]
[null,"PROGRAM",null,"Total Available Budget",0]
[null,null,null,"Total Estimated Cost",{"$f":"SUM(E9,E20,E34,E44,E51)","v":118710000}]
[null,null,null,"Targeted Program LOS",{"$f":"'Program Performance'!$H$11","v":"B"}]

{"sheet":"LOS and Grade Scales","index":1,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[11,2,11,3],[3,6,3,7],[3,8,3,9],[3,10,3,11],[2,2,2,11],[3,2,3,3],[3,4,3,5]]}
[]
[]
[null,null,"Percent of Feature Inventory in Deficient Condition"]
[null,"Level of Service","A",null,"B",null,"C",null,"D",null,"F"]
[null,"Maintenance Goal",">","<=",">","<=",">","<=",">","<=",">","<="]
[null,"Critical Safety",0,2.5,2.5,5.5,5.5,9.5,9.5,15,15,100]
[null,"Safety/Mobility",0,4.5,4.5,9.5,9.5,18.5,18.5,30,30,100]
[null,"Stewardship",0,6.5,6.5,15.5,15.5,29.5,29.5,50,50,100]
[null,"Ride/Comfort",0,7.5,7.5,18.5,18.5,35.5,35.5,60,60,100]
[null,"Aesthetics",0,10.5,10.5,25.5,25.5,47.5,47.5,80,80,100]
[]
[null,null,"Numeric Equivalent "]
[null,"Letter Grade",">","<="]
[null,"A",3,4]
[null,"B",2,3]
[null,"C",1,2]
[null,"D",0,1]
[null,"F",0,0]

{"sheet":"Program Performance","index":2,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[10,2,10,5],[3,6,3,7]]}
[]
[]
[]
[null,null,null,null,null,null,"Interpolation"]
[null,null," Goal","Priority Weight","Composite Deficiency Rate (% of inventory)","Goal LOS Grade","Grade Point","Weighted Grade Point"]
[null,null,"Critical Safety",{"$f":"'LOS Target Setting'!$B$16","v":0.51},{"$f":"'Critical Safety'!C7","v":6.8599999999999994},{"$f":"IF(E6<='LOS and Grade Scales'!D6,\"A\",IF(E6<='LOS and Grade Scales'!F6, \"B\", IF(E6<='LOS and Grade Scales'!H6,\"C\",IF(E6<='LOS and Grade Scales'!J6,\"D\",\"F\"))))","v":"C"},{"$f":"IF(F6='LOS and Grade Scales'!B14,'LOS and Grade Scales'!C14+(('LOS and Grade Scales'!D6-E6)/('LOS and Grade Scales'!D6-'LOS and Grade Scales'!C6)),IF(F6='LOS and Grade Scales'!B15,'LOS and Grade Scales'!C15+(('LOS and Grade Scales'!F6-E6)/('LOS and Grade Scales'!F6-'LOS and Grade Scales'!E6)), IF(F6='LOS and Grade Scales'!B16, 'LOS and Grade Scales'!C16+(('LOS and Grade Scales'!H6-E6)/('LOS and Grade Scales'!H6-'LOS and Grade Scales'!G6)),IF(F6='LOS and Grade Scales'!B17, 'LOS and Grade Scales'!C17+(('LOS and Grade Scales'!J6-E6)/('LOS and Grade Scales'!J6-'LOS and Grade Scales'!I6)),0))))","v":1.6600000000000001},{"$f":"D6*G6","v":0.84660000000000013}]
[null,null,"Safety/Mobility",{"$f":"'LOS Target Setting'!$B$30","v":0.28000000000000003},{"$f":"'Safety-Mobility'!C7","v":7.2966666666666669},{"$f":"IF(E7<='LOS and Grade Scales'!D7,\"A\",IF(E7<='LOS and Grade Scales'!F7, \"B\", IF(E7<='LOS and Grade Scales'!H7,\"C\",IF(E7<='LOS and Grade Scales'!J7,\"D\",\"F\"))))","v":"B"},{"$f":"IF(F7='LOS and Grade Scales'!B14,'LOS and Grade Scales'!C14+(('LOS and Grade Scales'!D7-E7)/('LOS and Grade Scales'!D7-'LOS and Grade Scales'!C7)),IF(F7='LOS and Grade Scales'!B15,'LOS and Grade Scales'!C15+(('LOS and Grade Scales'!F7-E7)/('LOS and Grade Scales'!F7-'LOS and Grade Scales'!E7)), IF(F7='LOS and Grade Scales'!B16, 'LOS and Grade Scales'!C16+(('LOS and Grade Scales'!H7-E7)/('LOS and Grade Scales'!H7-'LOS and Grade Scales'!G7)),IF(F7='LOS and Grade Scales'!B17,'LOS and Grade Scales'!C17+(('LOS and Grade Scales'!J7-E7)/('LOS and Grade Scales'!J7-'LOS and Grade Scales'!I7)),0))))","v":2.4406666666666665},{"$f":"D7*G7","v":0.6833866666666667}]
[null,null,"Stewardship",{"$f":"'LOS Target Setting'!$B$40","v":0.13},{"$f":"Stewardship!C7","v":5.5360000000000005},{"$f":"IF(E8<='LOS and Grade Scales'!D8,\"A\",IF(E8<='LOS and Grade Scales'!F8, \"B\", IF(E8<='LOS and Grade Scales'!H8,\"C\",IF(E8<='LOS and Grade Scales'!J8,\"D\",\"F\"))))","v":"A"},{"$f":"IF(F8='LOS and Grade Scales'!B14,'LOS and Grade Scales'!C14+(('LOS and Grade Scales'!D8-E8)/('LOS and Grade Scales'!D8-'LOS and Grade Scales'!C8)),IF(F8='LOS and Grade Scales'!B15,'LOS and Grade Scales'!C15+(('LOS and Grade Scales'!F8-E8)/('LOS and Grade Scales'!F8-'LOS and Grade Scales'!E8)), IF(F8='LOS and Grade Scales'!B16,'LOS and Grade Scales'!C16+(('LOS and Grade Scales'!H8-E8)/('LOS and Grade Scales'!H8-'LOS and Grade Scales'!G8)),IF(F8='LOS and Grade Scales'!B17, 'LOS and Grade Scales'!C17+(('LOS and Grade Scales'!J8-E8)/('LOS and Grade Scales'!J8-'LOS and Grade Scales'!I8)),0))))","v":3.148307692307692},{"$f":"D8*G8","v":0.40927999999999998}]
[null,null,"Ride/Comfort",{"$f":"'LOS Target Setting'!$B$47","v":0.05},{"$f":"'Ride-Comfort'!C7","v":5.3900000000000006},{"$f":"IF(E9<='LOS and Grade Scales'!D9,\"A\",IF(E9<='LOS and Grade Scales'!F9, \"B\", IF(E9<='LOS and Grade Scales'!H9,\"C\",IF(E9<='LOS and Grade Scales'!J9,\"D\",\"F\"))))","v":"A"},{"$f":"IF(F9='LOS and Grade Scales'!B14,'LOS and Grade Scales'!C14+(('LOS and Grade Scales'!D9-E9)/('LOS and Grade Scales'!D9-'LOS and Grade Scales'!C9)),IF(F9='LOS and Grade Scales'!B15,'LOS and Grade Scales'!C15+(('LOS and Grade Scales'!F9-E9)/('LOS and Grade Scales'!F9-'LOS and Grade Scales'!E9)), IF(F9='LOS and Grade Scales'!B16, 'LOS and Grade Scales'!C16+(('LOS and Grade Scales'!H9-E9)/('LOS and Grade Scales'!H9-'LOS and Grade Scales'!G9)),IF(F9='LOS and Grade Scales'!B17, 'LOS and Grade Scales'!C17+(('LOS and Grade Scales'!J9-E9)/('LOS and Grade Scales'!J9-'LOS and Grade Scales'!I9)),0))))","v":3.2813333333333334},{"$f":"D9*G9","v":0.16406666666666669}]
[null,null,"Aesthetics",{"$f":"'LOS Target Setting'!$B$53","v":0.03},{"$f":"Aesthetics!C7","v":7.3100000000000005},{"$f":"IF(E10<='LOS and Grade Scales'!D10,\"A\",IF(E10<='LOS and Grade Scales'!F10, \"B\", IF(E10<='LOS and Grade Scales'!H10,\"C\",IF(E10<='LOS and Grade Scales'!J10,\"D\",\"F\"))))","v":"A"},{"$f":"IF(F10='LOS and Grade Scales'!B14,'LOS and Grade Scales'!C14+(('LOS and Grade Scales'!D10-E10)/('LOS and Grade Scales'!D10-'LOS and Grade Scales'!C10)),IF(F10='LOS and Grade Scales'!B15,'LOS and Grade Scales'!C15+(('LOS and Grade Scales'!F10-E10)/('LOS and Grade Scales'!F10-'LOS and Grade Scales'!E10)), IF(F10='LOS and Grade Scales'!B16,'LOS and Grade Scales'!C16+(('LOS and Grade Scales'!H10-E10)/('LOS and Grade Scales'!H10-'LOS and Grade Scales'!G10)),IF(F10='LOS and Grade Scales'!B17, 'LOS and Grade Scales'!C17+(('LOS and Grade Scales'!J10-E10)/('LOS and Grade Scales'!J10-'LOS and Grade Scales'!I10)),0))))","v":3.303809523809524},{"$f":"D10*G10","v":9.911428571428571E-2}]
[null,null,"Program-level Score  ",null,null,null,{"$f":"SUM(H6:H10)","v":2.2024476190476192},{"$f":"IF(G11<=0,\"F\",IF(G11<=1, \"D\", IF(G11<=2,\"C\",IF(G11<=3,\"B\",\"A\"))))","v":"B"}]
[null,null,null,null," "]

{"sheet":"Critical Safety","index":3,"n_rows":31,"n_cols":16,"rows_kept":31,"cut":false,"hidden":false,"merged":[[21,0,22,0],[21,5,22,5],[21,6,22,6],[9,0,10,0],[9,1,10,1],[9,2,10,2],[9,4,10,4],[9,5,10,5],[21,1,22,1],[21,2,22,2],[21,4,22,4],[20,6,20,8],[20,1,20,5],[21,8,22,8],[21,3,22,3],[21,7,22,7],[2,2,2,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[9,8,10,8],[9,6,10,6],[8,1,8,5],[9,7,10,7],[8,6,8,8]]}
["LOS Target Setting for CRITICAL SAFETY"]
[]
["Budget = ",null,0,null,null,"Estimated Cost =",null,{"$f":"F31","v":43217550.434600003}]
[]
["Baseline composite deficiency rate =",null,{"$f":"G31","v":5.79},null,null,"Baseline LOS Grade =",null,{"$f":"IF(C5<='LOS and Grade Scales'!D6,\"A\",IF(C5<='LOS and Grade Scales'!F6, \"B\", IF(C5<='LOS and Grade Scales'!H6,\"C\",IF(C5<='LOS and Grade Scales'!J6,\"D\",\"F\"))))","v":"C"}]
["Target composite rate reduction =",null,{"$f":"I31","v":-1.0699999999999998}]
["Target composite deficiency rate =",null,{"$f":"H31","v":6.8599999999999994},null,null,"Target LOS Grade =",null,{"$f":"IF(C7<='LOS and Grade Scales'!D6,\"A\",IF(C7<='LOS and Grade Scales'!F6, \"B\", IF(C7<='LOS and Grade Scales'!H6,\"C\",IF(C7<='LOS and Grade Scales'!J6,\"D\",\"F\"))))","v":"C"}]
[]
[null,"FEATURE INPUTS",null,null,null,null,"MAINTENANCE OF STEADY STATE"]
["FEATURE","Utility Weight","Inventory",null,"Unit Cost","Cycle Time (Years)","Percent New Deficient Inventory Per Year"," Cost to Mitigate  Deficiency in 1% of Inventory","Cost to Maintain Baseline"]
[null,null,null,"Inventory Unit"]
["Emergency repair of regulator / warning signs",0.42,159004,"ea",171.48,20,{"$f":"(100)/F12","v":5},{"$f":"(C12/100)*E12","v":272660.05919999996},{"$f":"G12*H12","v":1363300.2959999999}]
["Hazardous debris",0.24,117740,"CL",1120.5,7,14.285714285714286,1319276.7000000002,18846810.000000004]
["Protective barriers",0.13,3704457,"LF",34.36,15,6.666666666666667,1272851.4251999999,8485676.1679999996]
["Centerline markings",0.09,56799150,"LF",0.15,4,25,85198.724999999991,2129968.125]
["Edgeline markings",7.0000000000000007E-2,156417624,"LF",0.15,4,25,234626.43599999999,5865660.8999999994]
["Unpaved shoulder drop-off / buildup",0.03,21619,"mi",330,4,25,71342.7,1783567.5,null,null,null,null,null,null," "]
["Paved shoulder drop off / build up",0.02,21591,"mi",7250,15,6.666666666666667,1565347.5,10435650]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I12:I18)","v":48910632.989}]
[]
[null,"TARGET CALCULATIONS",null,null,null,null,"WEIGHTED DEFICIENCY RATES"]
["FEATURE","Maximum Acceptable Deficiency Rate","Baseline Deficiency Rate","Target         Deficiency Rate","Target Rate Reduction","Target Budget Allocation","Weighted Baseline  Deficiency Rate","Weighted Target  Deficiency Rate","Weighted Rate Reduction"]
[]
["Emergency repair of regulator / warning signs",{"$f":"'LOS Target Setting'!G11","v":5},{"$f":"'LOS Target Setting'!F11","v":3},5,{"$f":"C24-D24","v":-2},{"$f":"I12+E24*H12","v":817980.17759999994},{"$f":"C24*B12","v":1.26},{"$f":"D24*B12","v":2.1},{"$f":"E24*B12","v":-0.84}]
["Hazardous debris",{"$f":"'LOS Target Setting'!G12","v":9},{"$f":"'LOS Target Setting'!F12","v":7},9,{"$f":"C25-D25","v":-2},16208256.600000003,1.68,2.16,-0.48]
["Protective barriers",{"$f":"'LOS Target Setting'!G13","v":5},{"$f":"'LOS Target Setting'!F13","v":5},5,0,8485676.1679999996,0.65,0.65,0]
["Centerline markings",{"$f":"'LOS Target Setting'!G14","v":6},{"$f":"'LOS Target Setting'!F14","v":6},6,0,2129968.125,0.54,0.54,0]
["Edgeline markings",{"$f":"'LOS Target Setting'!G15","v":8},{"$f":"'LOS Target Setting'!F15","v":7},8,-1,5631034.4639999997,0.49000000000000005,0.56000000000000005,-7.0000000000000007E-2]
["Unpaved shoulder drop-off / buildup",{"$f":"'LOS Target Setting'!G16","v":25},{"$f":"'LOS Target Setting'!F16","v":37},25,12,2639679.9,1.1099999999999999,0.75,0.36]
["Paved shoulder drop off / build up",{"$f":"'LOS Target Setting'!G17","v":5},{"$f":"'LOS Target Setting'!F17","v":3},5,-2,7304955,0.06,0.1,-0.04]
[null,null,null,null,"Total",{"$f":"SUM(F24:F30)","v":43217550.434600003},{"$f":"SUM($G$24:$G$30)","v":5.79},{"$f":"SUM($H$24:$H$30)","v":6.8599999999999994},{"$f":"SUM($I$24:$I$30)","v":-1.0699999999999998}]

{"sheet":"Safety-Mobility","index":4,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[8,6,8,8],[2,2,2,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[8,1,8,5],[24,0,25,0],[24,1,25,1],[24,2,25,2],[24,3,25,3],[24,4,25,4],[9,0,10,0],[9,1,10,1],[9,2,10,2],[9,4,10,4],[9,5,10,5],[9,6,10,6],[23,1,23,5],[23,6,23,8],[24,5,25,5],[24,6,25,6],[24,7,25,7],[24,8,25,8],[9,7,10,7],[9,8,10,8]]}
["LOS Target Setting for CRITICAL SAFETY"]
[]
["Budget = ",null,0,null,null,"Estimated Cost =",null,{"$f":"F37","v":31183945.876666673}]
[]
["Baseline composite deficiency rate =",null,{"$f":"G37","v":7.3},null,null,"Baseline LOS Grade =",null,{"$f":"IF(C5<='LOS and Grade Scales'!D7,\"A\",IF(C5<='LOS and Grade Scales'!F7, \"B\", IF(C5<='LOS and Grade Scales'!H7,\"C\",IF(C5<='LOS and Grade Scales'!J7,\"D\",\"F\"))))","v":"B"}]
["Target composite rate reduction =",null,{"$f":"I37","v":3.333333333333556E-3}]
["Target composite deficiency rate =",null,{"$f":"H37","v":7.2966666666666669},null,null,"Target LOS Grade =",null,{"$f":"IF(C7<='LOS and Grade Scales'!D7,\"A\",IF(C7<='LOS and Grade Scales'!F7, \"B\", IF(C7<='LOS and Grade Scales'!H7,\"C\",IF(C7<='LOS and Grade Scales'!J7,\"D\",\"F\"))))","v":"B"}]
[]
[null,"FEATURE INPUTS",null,null,null,null,"MAINTENANCE OF STEADY STATE"]
["FEATURE","Utility Weight","Inventory",null,"Unit Cost","Cycle Time (Years)","Percent New Deficient Inventory Per Year"," Cost to Mitigate  Deficiency in 1% of Inventory","Cost to Maintain Baseline"]
[null,null,null,"Inventory Unit"]
["Woody vegetation control for vision",0.31,39117,"intersect",258.35000000000002,3,{"$f":"(100)/F12","v":33.333333333333336},{"$f":"(C12/100)*E12","v":101058.76950000001},{"$f":"G12*H12","v":3368625.6500000004}]
["Mowing for vision",0.2,39117,"intersect",83.41,1,100,32627.489699999998,3262748.9699999997]
["Special pavement markings",0.14000000000000001,48910,"ea",169.6,2,50,82951.360000000001,4147568]
["Woody vegetation (clear zone)",0.1,29625,"LM",1033.4000000000001,6,16.666666666666668,306144.75,5102412.5]
["Culverts",0.08,36266,"ea",226,10,10,81961.16,819611.60000000009]
["Storm sewer",0.06,48926,"ea",115,5,20,56264.9,1125298,null,null,null,null,null,null," "]
["Cross slope on unpaved shoulders",0.05,21619,"mi",2000,12,8.3333333333333339,432380,3603166.666666667]
["Delineators",0.03,155793,"ea",52,8,{"$f":"(100)/F19","v":12.5},{"$f":"(C19/100)*E19","v":81012.36},{"$f":"G19*H19","v":1012654.5}]
["Routine replacement of regulatory / warning signs",0.02,159004,"ea",121.9,8,12.5,193825.87600000002,2422823.4500000002]
["Fences",0.01,14169357,"LF",6.28,30,3.3333333333333335,889835.61960000009,2966118.7320000003]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I12:I21)","v":27831028.068666667}]
[]
[null,"TARGET CALCULATIONS",null,null,null,null,"WEIGHTED DEFICIENCY RATES"]
["FEATURE","Maximum Acceptable Deficiency Rate","Baseline Deficiency Rate","Target         Deficiency Rate","Target Rate Reduction","Target Budget Allocation","Weighted Baseline Deficiency  Rate","Weighted Target  Deficiency Rate","Weighted Rate Reduction"]
[]
["Woody vegetation control for vision",{"$f":"'LOS Target Setting'!G22","v":5},{"$f":"'LOS Target Setting'!F22","v":1},5,{"$f":"C27-D27","v":-4},{"$f":"I12+E27*H12","v":2964390.5720000002},{"$f":"C27*B12","v":0.31},{"$f":"D27*B12","v":1.55},{"$f":"E27*B12","v":-1.24}]
["Mowing for vision",{"$f":"'LOS Target Setting'!G23","v":5},{"$f":"'LOS Target Setting'!F23","v":1},5,-4,3132239.0111999996,{"$f":"C28*B13","v":0.2},1,-0.8]
["Special pavement markings",{"$f":"'LOS Target Setting'!G24","v":5},{"$f":"'LOS Target Setting'!F24","v":10},5,5,4562324.8,1.4000000000000001,0.70000000000000007,0.70000000000000007]
["Woody vegetation (clear zone)",{"$f":"'LOS Target Setting'!G25","v":5},{"$f":"'LOS Target Setting'!F25","v":2},5,-3,4183978.25,0.2,0.5,-0.30000000000000004]
["Culverts",{"$f":"'LOS Target Setting'!G26","v":15},{"$f":"'LOS Target Setting'!F26","v":22},15,7,1393339.7200000002,1.76,1.2,0.56000000000000005]
["Storm sewer",{"$f":"'LOS Target Setting'!G27","v":15},{"$f":"'LOS Target Setting'!F27","v":17},15,2,1237827.8,1.02,0.89999999999999991,0.12]
["Cross slope on unpaved shoulders",{"$f":"'LOS Target Setting'!G28","v":15},{"$f":"'LOS Target Setting'!F28","v":27},15,12,8791726.6666666679,1.35,0.75,0.60000000000000009]
["Delineators",{"$f":"'LOS Target Setting'!G29","v":15},{"$f":"'LOS Target Setting'!F29","v":25},15,{"$f":"C34-D34","v":10},{"$f":"I19+E34*H19","v":1822778.1},{"$f":"C34*B19","v":0.75},{"$f":"D34*B19","v":0.44999999999999996},{"$f":"E34*B19","v":0.3}]
["Routine replacement of regulatory / warning signs",{"$f":"'LOS Target Setting'!G30","v":10},{"$f":"'LOS Target Setting'!F30","v":15},10,5,3391952.83,0.3,0.2,0.1]
["Fences",{"$f":"'LOS Target Setting'!G31","v":5},{"$f":"'LOS Target Setting'!F31","v":1},4.666666666666667,-3.666666666666667,-296611.87320000026,0.01,4.6666666666666669E-2,-3.6666666666666674E-2]
[null,null,null,null,"Total",{"$f":"SUM(F27:F36)","v":31183945.876666673},{"$f":"SUM($G$27:$G$36)","v":7.3},{"$f":"SUM($H$27:$H$36)","v":7.2966666666666669},{"$f":"SUM($I$27:$I$36)","v":3.333333333333556E-3}]

{"sheet":"Stewardship","index":5,"n_rows":29,"n_cols":16,"rows_kept":29,"cut":false,"hidden":false,"merged":[[8,6,8,8],[2,2,2,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[8,1,8,5],[20,0,21,0],[20,1,21,1],[20,2,21,2],[20,3,21,3],[20,4,21,4],[9,0,10,0],[9,1,10,1],[9,2,10,2],[9,4,10,4],[9,5,10,5],[9,6,10,6],[19,1,19,5],[19,6,19,8],[20,5,21,5],[20,6,21,6],[20,7,21,7],[20,8,21,8],[9,7,10,7],[9,8,10,8]]}
["LOS Target Setting for CRITICAL SAFETY"]
[]
["Budget = ",null,0,null,null,"Estimated Cost =",null,{"$f":"F29","v":13995777.883092858}]
[]
["Baseline composite deficiency rate =",null,{"$f":"G29","v":13.142000000000001},null,null,"Baseline LOS Grade =",null,{"$f":"IF(C5<='LOS and Grade Scales'!D8,\"A\",IF(C5<='LOS and Grade Scales'!F8, \"B\", IF(C5<='LOS and Grade Scales'!H8,\"C\",IF(C5<='LOS and Grade Scales'!J8,\"D\",\"F\"))))","v":"B"}]
["Target composite rate reduction =",null,{"$f":"I29","v":7.6059999999999999}]
["Target composite deficiency rate =",null,{"$f":"H29","v":5.5360000000000005},null,null,"Target LOS Grade =",null,{"$f":"IF(C7<='LOS and Grade Scales'!D8,\"A\",IF(C7<='LOS and Grade Scales'!F8, \"B\", IF(C7<='LOS and Grade Scales'!H8,\"C\",IF(C7<='LOS and Grade Scales'!J8,\"D\",\"F\"))))","v":"A"}]
[]
[null,"FEATURE INPUTS",null,null,null,null,"MAINTENANCE OF STEADY STATE"]
["FEATURE","Utility Weight","Inventory",null,"Unit Cost","Cycle Time (Years)","Percent New Deficient Inventory Per Year"," Cost to Mitigate  Deficiency in 1% of Inventory","Cost to Maintain Baseline"]
[null,null,null,"Inventory Unit"]
["Ditches",0.46,18236.48,"mi",8000,20,{"$f":"(100)/F12","v":5},{"$f":"(C12/100)*E12","v":1458918.3999999999},{"$f":"G12*H12","v":7294592}]
["Curb and gutter",0.25,3396.91,"mi",141,2,50,4789.6430999999993,239482.15499999997]
["Flumes",0.128,11631,"ea",37.35,8,12.5,4344.1785,54302.231249999997]
["Cracking on paved shoulders",0.08,21591,"mi",880,15,6.666666666666667,190000.8,1266672]
["Erosion on unpaved shoulders",5.6000000000000001E-2,216190,"mi",116.47,7,14.285714285714286,251796.49300000002,3597092.7571428576]
["Drains",2.5999999999999999E-2,33424,"ea",16.010000000000002,4,25,5351.1824000000006,133779.56000000003,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I12:I17)","v":12585920.703392858}]
[]
[null,"TARGET CALCULATIONS",null,null,null,null,"WEIGHTED DEFICIENCY RATES"]
["FEATURE","Maximum Acceptable Deficiency Rate","Baseline Deficiency Rate","Target         Deficiency Rate","Target Rate Reduction","Target Budget Allocation","Weighted Baseline  Deficiency Rate","Weighted Target  Deficiency Rate","Weighted Rate Reduction"]
[]
["Ditches",{"$f":"'LOS Target Setting'!G36","v":5},{"$f":"'LOS Target Setting'!F36","v":3},5,{"$f":"C23-D23","v":-2},{"$f":"I12+E23*H12","v":4376755.2},{"$f":"C23*B12","v":1.3800000000000001},{"$f":"D23*B12","v":2.3000000000000003},{"$f":"E23*B12","v":-0.92}]
["Curb and gutter",{"$f":"'LOS Target Setting'!G37","v":5},{"$f":"'LOS Target Setting'!F37","v":4},0,4,258640.72739999997,{"$f":"C24*B13","v":1},{"$f":"D24*B13","v":0},{"$f":"E24*B13","v":1}]
["Flumes",{"$f":"'LOS Target Setting'!G38","v":25},{"$f":"'LOS Target Setting'!F38","v":39},0,39,223725.19274999999,{"$f":"C25*B14","v":4.992},{"$f":"D25*B14","v":0},{"$f":"E25*B14","v":4.992}]
["Cracking on paved shoulders",{"$f":"'LOS Target Setting'!G39","v":35},{"$f":"'LOS Target Setting'!F39","v":60},35,25,6016692,{"$f":"C26*B15","v":4.8},{"$f":"D26*B15","v":2.8000000000000003},{"$f":"E26*B15","v":2}]
["Erosion on unpaved shoulders",{"$f":"'LOS Target Setting'!G40","v":5},{"$f":"'LOS Target Setting'!F40","v":2},5,-3,2841703.2781428574,{"$f":"C27*B16","v":0.112},{"$f":"D27*B16","v":0.28000000000000003},{"$f":"E27*B16","v":-0.16800000000000001}]
["Drains",{"$f":"'LOS Target Setting'!G41","v":25},{"$f":"'LOS Target Setting'!F41","v":33},6,27,278261.48480000003,{"$f":"C28*B17","v":0.85799999999999998},{"$f":"D28*B17","v":0.156},{"$f":"E28*B17","v":0.70199999999999996}]
[null,null,null,null,"Total",{"$f":"SUM(F23:F28)","v":13995777.883092858},{"$f":"SUM($G$23:$G$28)","v":13.142000000000001},{"$f":"SUM($H$23:$H$28)","v":5.5360000000000005},{"$f":"SUM($I$23:$I$28)","v":7.6059999999999999}]

{"sheet":"Ride-Comfort","index":6,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[[8,6,8,8],[2,2,2,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[8,1,8,5],[17,0,18,0],[17,1,18,1],[17,2,18,2],[17,3,18,3],[17,4,18,4],[9,0,10,0],[9,1,10,1],[9,2,10,2],[9,4,10,4],[9,5,10,5],[9,6,10,6],[16,1,16,5],[16,6,16,8],[17,5,18,5],[17,6,18,6],[17,7,18,7],[17,8,18,8],[9,7,10,7],[9,8,10,8]]}
["LOS Target Setting for CRITICAL SAFETY"]
[]
["Budget = ",null,0,null,null,"Estimated Cost =",null,{"$f":"F23","v":7454967.324000001}]
[]
["Baseline composite deficiency rate =",null,{"$f":"G23","v":8.26},null,null,"Baseline LOS Grade =",null,{"$f":"IF(C5<='LOS and Grade Scales'!D9,\"A\",IF(C5<='LOS and Grade Scales'!F9, \"B\", IF(C5<='LOS and Grade Scales'!H9,\"C\",IF(C5<='LOS and Grade Scales'!J9,\"D\",\"F\"))))","v":"B"}]
["Target composite rate reduction =",null,{"$f":"I23","v":2.87}]
["Target composite deficiency rate =",null,{"$f":"H23","v":5.3900000000000006},null,null,"Target LOS Grade =",null,{"$f":"IF(C7<='LOS and Grade Scales'!D9,\"A\",IF(C7<='LOS and Grade Scales'!E9, \"B\", IF(C7<='LOS and Grade Scales'!H9,\"C\",IF(C7<='LOS and Grade Scales'!J9,\"D\",\"F\"))))","v":"A"}]
[]
[null,"FEATURE INPUTS",null,null,null,null,"MAINTENANCE OF STEADY STATE"]
["FEATURE","Utility Weight","Inventory",null,"Unit Cost","Cycle Time (Years)","Percent New Deficient Inventory Per Year"," Cost to Mitigate  Deficiency in 1% of Inventory","Cost to Maintain Baseline"]
[null,null,null,"Inventory Unit"]
["Potholes / raveling on paved shoulders",0.73,21591,null,1130,15,{"$f":"(100)/F12","v":6.666666666666667},{"$f":"(C12/100)*E12","v":243978.3},{"$f":"G12*H12","v":1626522}]
["Emergency repair of “other” signs",0.19,122970,null,171.48,20,{"$f":"(100)/F13","v":5},{"$f":"(C13/100)*E13","v":210868.95600000001},{"$f":"G13*H13","v":1054344.78}]
["Routine replacement of “other” signs",0.08,122970,null,121.9,10,{"$f":"(100)/F14","v":10},{"$f":"(C14/100)*E14","v":149900.43000000002},{"$f":"G14*H14","v":1499004.3000000003}]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I12:I14)","v":4179871.0800000005}]
[]
[null,"TARGET CALCULATIONS",null,null,null,null,"WEIGHTED DEFICIENCY RATES"]
["FEATURE","Maximum Acceptable Deficiency Rate","Baseline Deficiency Rate","Target         Deficiency Rate","Target Rate Reduction","Target Budget Allocation","Weighted Baseline  Deficiency Rate","Weighted Target  Deficiency Rate","Weighted Rate Reduction"]
[]
["Potholes / raveling on paved shoulders",{"$f":"'LOS Target Setting'!G46","v":5},{"$f":"'LOS Target Setting'!F46","v":6},4,{"$f":"C20-D20","v":2},{"$f":"I12+E20*H12","v":2114478.6},{"$f":"C20*B12","v":4.38},{"$f":"D20*B12","v":2.92},{"$f":"E20*B12","v":1.46}]
["Emergency repair of “other” signs",{"$f":"'LOS Target Setting'!G47","v":5},{"$f":"'LOS Target Setting'!F47","v":4},5,{"$f":"C21-D21","v":-1},{"$f":"I13+E21*H13","v":843475.82400000002},{"$f":"C21*B13","v":0.76},{"$f":"D21*B13","v":0.95},{"$f":"E21*B13","v":-0.19}]
["Routine replacement of “other” signs",{"$f":"'LOS Target Setting'!G48","v":20},{"$f":"'LOS Target Setting'!F48","v":39},19,{"$f":"C22-D22","v":20},{"$f":"I14+E22*H14","v":4497012.9000000004},{"$f":"C22*B14","v":3.12},{"$f":"D22*B14","v":1.52},{"$f":"E22*B14","v":1.6}]
[null,null,null,null,"Total",{"$f":"SUM(F20:F22)","v":7454967.324000001},{"$f":"SUM($G$20:$G$22)","v":8.26},{"$f":"SUM($H$20:$H$22)","v":5.3900000000000006},{"$f":"SUM($I$20:$I$22)","v":2.87}]

{"sheet":"Aesthetics","index":7,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[8,6,8,8],[2,2,2,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[8,1,8,5],[16,0,17,0],[16,1,17,1],[16,2,17,2],[16,3,17,3],[16,4,17,4],[9,0,10,0],[9,1,10,1],[9,2,10,2],[9,4,10,4],[9,5,10,5],[9,6,10,6],[15,1,15,5],[15,6,15,8],[16,5,17,5],[16,6,17,6],[16,7,17,7],[16,8,17,8],[9,7,10,7],[9,8,10,8]]}
["LOS Target Setting for CRITICAL SAFETY"]
[]
["Budget = ",null,0,null,null,"Estimated Cost =",null,{"$f":"F21","v":22856925.824999996}]
[]
["Baseline composite deficiency rate =",null,{"$f":"G21","v":42.25},null,null,"Baseline LOS Grade =",null,{"$f":"IF(C5<='LOS and Grade Scales'!D10,\"A\",IF(C5<='LOS and Grade Scales'!E10, \"B\", IF(C5<='LOS and Grade Scales'!H10,\"C\",IF(C5<='LOS and Grade Scales'!J10,\"D\",\"F\"))))","v":"C"}]
["Target composite rate reduction =",null,{"$f":"I21","v":34.94}]
["Target composite deficiency rate =",null,{"$f":"H21","v":7.3100000000000005},null,null,"Target LOS Grade =",null,{"$f":"IF(C7<='LOS and Grade Scales'!D10,\"A\",IF(C7<='LOS and Grade Scales'!E10, \"B\", IF(C7<='LOS and Grade Scales'!H10,\"C\",IF(C7<='LOS and Grade Scales'!J10,\"D\",\"F\"))))","v":"A"}]
[]
[null,"FEATURE INPUTS",null,null,null,null,"MAINTENANCE OF STEADY STATE"]
["FEATURE","Utility Weight","Inventory",null,"Unit Cost","Cycle Time (Years)","Percent New Deficient Inventory Per Year"," Cost to Mitigate  Deficiency in 1% of Inventory","Cost to Maintain Baseline"]
[null,null,null,"Inventory Unit"]
["Mowing",0.83,29625,null,83.41,1,{"$f":"(100)/F12","v":100},{"$f":"(C12/100)*E12","v":24710.212499999998},{"$f":"G12*H12","v":2471021.25}]
["Litter",0.17,29625,null,547.03,1,{"$f":"(100)/F13","v":100},{"$f":"(C13/100)*E13","v":162057.63749999998},{"$f":"G13*H13","v":16205763.749999998}]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I12:I13)","v":18676785}]
[]
[null,"TARGET CALCULATIONS",null,null,null,null,"WEIGHTED DEFICIENCY RATES"]
["FEATURE","Maximum Acceptable Deficiency Rate","Baseline Deficiency Rate","Target         Deficiency Rate","Target Rate Reduction","Target Budget Allocation","Weighted Baseline  Deficiency Rate","Weighted Target  Deficiency Rate","Weighted Rate Reduction"]
[]
["Mowing",{"$f":"'LOS Target Setting'!G53","v":40},{"$f":"'LOS Target Setting'!F53","v":38},0,{"$f":"C19-D19","v":38},{"$f":"I12+E19*H12","v":3410009.3250000002},{"$f":"C19*B12","v":31.54},{"$f":"D19*B12","v":0},{"$f":"E19*B12","v":31.54}]
["Litter",{"$f":"'LOS Target Setting'!G54","v":45},{"$f":"'LOS Target Setting'!F54","v":63},43,{"$f":"C20-D20","v":20},{"$f":"I13+E20*H13","v":19446916.499999996},{"$f":"C20*B13","v":10.71},{"$f":"D20*B13","v":7.3100000000000005},{"$f":"E20*B13","v":3.4000000000000004}]
[null,null,null,null,"Total",{"$f":"SUM(F19:F20)","v":22856925.824999996},{"$f":"SUM($G$19:$G$20)","v":42.25},{"$f":"SUM($H$19:$H$20)","v":7.3100000000000005},{"$f":"SUM($I$19:$I$20)","v":34.94}]