{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Inputs","Results","Details","Graph Data","Graph_Condition","Graph_Cost"],"not_rendered":{"charts":4,"images":6,"macros":1,"external_links":0,"defined_names":52,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Graph_Condition","index":4,"reason":"not_a_worksheet"},{"sheet":"Graph_Cost","index":5,"reason":"not_a_worksheet"}],"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":"Inputs","index":0,"n_rows":160,"n_cols":7,"rows_kept":160,"cut":false,"hidden":false,"merged":[[2,2,2,7],[3,2,3,7],[4,2,4,7],[13,3,13,6],[12,3,12,6],[22,4,22,6],[16,3,16,6],[17,3,17,6],[18,3,18,6],[14,3,14,6],[15,3,15,6]]}
[]
[]
[null,null,"TCRP E-09"]
[null,null,"TRANSIT STATE OF GOOD REPAIR"]
[null,null,"CONDITION-BASED MODEL - INPUTS"]
[]
[null,null,"INSTRUCTIONS"]
[]
[null,null,"Note: this model is used to predict the average annual cost and prioritization values for "]
[null,null,"  transit assets based on asset condition for guideway, facilities, systems and stations."]
[null,null,"  Default deterioration rates have been derived from the FTA TERM model."]
[null,null,"  To use this model please follow these instructions, and see the TCRP E-09 report for more information."]
[null,null,null,"1.  Open the spreadsheet with macros enabled and the Solver installed."]
[null,null,null,"2.  Select an asset type from the dropdown or select \"User-Specified\" if developing a new model."]
[null,null,null,"3.  Enter the asset replacement cost."]
[null,null,null,"4.  Enter the rehabilitation cost (set greater than or equal to replacement cost if rehabilitation is infeasible)."]
[null,null,null,"5.  If desired enter the discount rate (7% by default)."]
[null,null,null,"6.  If desired click the \"Click to Edit Details\" button to edit additional model details."]
[null,null,null,"7.  To view results click the \"Click for Results\" button."]
[]
[null,null,"SUMMARY INPUTS"]
[]
[null,null,"Asset:",null,"User-Specified"]
[]
[null,null,null,null,null,"Override"]
[null,null,null,null,"Default","Value","Notes"]
[]
[null,null,"Unit Agency Replacement Cost ($):",null,1,1700]
[null,null,"Unit Agency Rehabilitation Cost ($):",null,1,629,"Set to greater than or equal to replacement if infeasible"]
[null,null,"Discount Rate %:",null,7.0000000000000007E-2]
[]
[null,null,"Asset List"]
[null,null,"User-Specified"]
[null,null,"Guideway-At Grade Ballasted or Expressway"]
[null,null,"Guideway-Grade Crossing"]
[null,null,"Guideway-Elevated Structure "]
[null,null,"Guideway-Steel Viaduct"]
[null,null,"Guideway-Bridge"]
[null,null,"Guideway-Foot Walk"]
[null,null,"Guideway-Elevated Fill"]
[null,null,"Guideway-Tunnel"]
[null,null,"Guideway-Retained Cut"]
[null,null,"Guideway-Tangent Direct Fixation Track"]
[null,null,"Guideway-Curved Direct Fixation Track"]
[null,null,"Guideway-Guarded Direct Fixation Track"]
[null,null,"Guideway-Direct Fixation Tangent Platform Track"]
[null,null,"Guideway-Direct Fixation Curved Platform Track"]
[null,null,"Guideway-Guarded Curved Direct Fixation Track"]
[null,null,"Guideway-Tangent Ballasted Track"]
[null,null,"Guideway-Curved Ballasted Track"]
[null,null,"Guideway-Guarded Ballasted Track"]
[null,null,"Guideway-Ballasted Tangent Platform Track"]
[null,null,"Guideway-Ballasted Curved Platform Track"]
[null,null,"Guideway-Guarded Platform Ballasted Track"]
[null,null,"Guideway-Tangent Embedded Track"]
[null,null,"Guideway-Curved Embedded Track"]
[null,null,"Guideway-At-Grade Crossing"]
[null,null,"Guideway-Special Trackwork"]
[null,null,"Guideway-Direct Fixation Diamond Crossover"]
[null,null,"Guideway-Direct Fixation or Ballasted Turnout"]
[null,null,"Guideway-Turntable"]
[null,null,"Guideway-Yard Track"]
[null,null,"Guideway-Wood Tie"]
[null,null,"Guideway-Concrete Tie"]
[null,null,"Guideway-Retaining Wall"]
[null,null,"Guideway-At Grade Bus"]
[null,null,"Guideway-Bus Turnaround"]
[null,null,"Guideway-Elevated-Bus"]
[null,null,"Guideway-Subway Bus"]
[null,null,"Facilities-Administrative Building"]
[null,null,"Facilities-Maintenance Building"]
[null,null,"Facilities-Passenger Building"]
[null,null,"Facilities-Building Utilities"]
[null,null,"Facilities-Access and Parking"]
[null,null,"Facilities-Building Utilities-Elevators and Conveying Systems"]
[null,null,"Facilities-Building Utilities-Generator"]
[null,null,"Facilities-Storage Yard"]
[null,null,"Facilities-Storage Yard-Bus"]
[null,null,"Facilities-Bus Turnaround Facility"]
[null,null,"Facilities-Maintenance Equipment"]
[null,null,"Facilities-Pollution Treatment"]
[null,null,"Facilities-Bus Washer"]
[null,null,"Facilities-Train Washer"]
[null,null,"Facilities-Vehicle Paintbooth"]
[null,null,"Facilities-Fuel Island"]
[null,null,"Facilities-Dynamoneter"]
[null,null,"Facilities-Portable Lift"]
[null,null,"Facilities-Fixed Lift"]
[null,null,"Facilities-Wheel Truing Machine"]
[null,null,"Facilities-Brake Lathe"]
[null,null,"Facilities-Major Rail Shop"]
[null,null,"Facilities-Major Bus Shop"]
[null,null,"Facilities-Train Control Center"]
[null,null,"Systems-Train Control, Elec., Comm., Revenue Collect. & Util."]
[null,null,"Systems-Train Control"]
[null,null,"Systems-Train Control"]
[null,null,"Systems-Signals & Train Stops"]
[null,null,"Systems-Train Control Cable"]
[null,null,"Systems-Signal Bridge"]
[null,null,"Systems-Centralized Train Control"]
[null,null,"Systems-Gates, Flashers, Crossings"]
[null,null,"Systems-Roadway Traffic Signals"]
[null,null,"Systems-Interlocking"]
[null,null,"Systems-Electrification"]
[null,null,"Systems-Electrification Catenary/Pole"]
[null,null,"Systems-Electrification Substation"]
[null,null,"Systems-High Tension Towers"]
[null,null,"Systems-Electrification Substation Building Components"]
[null,null,"Systems-Electrification Breaker House"]
[null,null,"Systems-Electrification Contact Rail/Protection Boards"]
[null,null,"Systems-Heaters"]
[null,null,"Systems-Power Cable"]
[null,null,"Systems-Electrical Systems"]
[null,null,"Systems-Trolley Wire"]
[null,null,"Systems-Communications Cable"]
[null,null,"Systems-Communciations"]
[null,null,"Systems-MIS/IT/Network System"]
[null,null,"Systems-Emergency Location System"]
[null,null,"Systems-SCADA RTU"]
[null,null,"Systems-Communications Hut or Room"]
[null,null,"Systems-Bus On-Board Video System"]
[null,null,"Systems-Central Revenue Collection"]
[null,null,"Systems-Coin/Bill Counter"]
[null,null,"Systems-Revenue Collection System-Rail"]
[null,null,"Systems-Turnstile"]
[null,null,"Systems-In Station Revenue Collection Equipment"]
[null,null,"Systems-Parking Meter"]
[null,null,"Systems-Change Machine"]
[null,null,"Systems-Passenger Counter-Rail"]
[null,null,"Systems-System Utilities"]
[null,null,"Systems-Lighting"]
[null,null,"Systems-Guideway Drainage"]
[null,null,"Systems-Pump Room"]
[null,null,"Systems-Deep Utility Well"]
[null,null,"Systems-Sump Pump/Discharge Pipes"]
[null,null,"Systems-Subway Ventilation"]
[null,null,"Systems-Fan Plant"]
[null,null,"Systems-Compressed Air Pipes"]
[null,null,"Systems-Air Conditioning/HVAC-Subway"]
[null,null,"Systems-Emergency Exit"]
[null,null,"Systems-Tunnel Handrail"]
[null,null,"Systems-ITS, APC, AVL, CAD, GPL"]
[null,null,"Station-Building-Rail"]
[null,null,"Stations-Building-Subway"]
[null,null,"Stations-Shelter-Rail"]
[null,null,"Stations-Token Booth"]
[null,null,"Stations-Elevator/Escalator"]
[null,null,"Stations-Parking Garage/Lot"]
[null,null,"Stations-Parking Equipment"]
[null,null,"Stations-Pedestrian Walkway/Elevated"]
[null,null,"Stations-Pedestrian Walkway/Subway"]
[null,null,"Stations-At-Grade Rail Platform"]
[null,null,"Stations-Elevated Rail Platform"]
[null,null,"Stations-Subway Rail Platform"]
[null,null,"Stations-Building/Ground Access-Bus"]
[null,null,"Stations-Bus Shelter"]
[null,null,"Stations-Station Canopy"]
[null,null,"Stations-Bus Station Platform"]
[null,null,"Stations-Signage & Graphics"]
[null,null,"Stations-Ferry Terminal Building/Dock"]

{"sheet":"Results","index":1,"n_rows":214,"n_cols":22,"rows_kept":214,"cut":false,"hidden":false,"merged":[[2,2,2,8],[3,2,3,8],[4,2,4,8],[20,4,20,5],[8,3,8,5],[22,4,22,5],[23,4,23,5],[16,4,16,5],[17,4,17,5],[19,4,19,5],[21,4,21,5]]}
[]
[]
[null,null,"TCRP E-09"]
[null,null,"TRANSIT STATE OF GOOD REPAIR"]
[null,null,"CONDITION-BASED MODEL - RESULTS"]
[]
[null,null,"SUMMARY RESULTS"]
[]
[null,null,"Asset:",{"$f":"Inputs!E23","v":"User-Specified"}]
[null,null,"Average Annual Unit Agency Cost:",null,null,{"$f":"U69","v":93.193548387096726}]
[null,null,"Average Annual Unit User Cost:",null,null,{"$f":"F12-F10","v":16.387096774193537}]
[null,null,"Average Annual Unit Total Cost:",null,null,{"$f":"V69","v":109.58064516129026}]
[]
[]
[null,null,"RESULTS BY CONDITION STATE"]
[]
[null,null,null,null,"Recommended",null,"Unit Agency","Prioritization"]
[null,null,"Condition State",null,"Action",null,"Cost","Index"]
[]
[null,null,{"$f":"Details!C53","v":"5-Excellent"},null,{"$f":"D63","v":"0-Do Minimum"},null,{"$f":"F63","v":69},{"$f":"M63","v":0}]
[null,null,{"$f":"Details!C56","v":"4-Good"},null,{"$f":"D64","v":"0-Do Minimum"},null,{"$f":"F64","v":69},{"$f":"M64","v":0}]
[null,null,{"$f":"Details!C59","v":"3-Adequate"},null,{"$f":"D65","v":"0-Do Minimum"},null,{"$f":"F65","v":88},{"$f":"M65","v":0}]
[null,null,{"$f":"Details!C62","v":"2-Marginal"},null,{"$f":"D66","v":"1-Rehab"},null,{"$f":"F66","v":629},{"$f":"M66","v":3.4402979632757805E-2}]
[null,null,{"$f":"Details!C65","v":"1-Poor"},null,{"$f":"D67","v":"1-Rehab"},null,{"$f":"F67","v":629},{"$f":"M67","v":0.18573975134477952}]
[]
[]
[]
[null,null,"Objective Function"]
[null,null,{"$f":"SUM(Results!D33:E38)","v":23174.89548668791}]
[]
[null,null,"Decision Variables"]
[null,null,"Description"]
[null,null,{"$f":"\"State \"&Details!C53","v":"State 5-Excellent"},1155.8268906979354,1239.6074201725964]
[null,null,{"$f":"\"State \"&Details!C56","v":"State 4-Good"},1297.3845376751897,1498.4578084144064]
[null,null,{"$f":"\"State \"&Details!C59","v":"State 3-Adequate"},1637.1228904206512,1969.8987401948168]
[null,null,{"$f":"\"State \"&Details!C62","v":"State 2-Marginal"},1841.5089137151981,2257.4278583312989]
[null,null,{"$f":"\"State \"&Details!C65","v":"State 1-Poor"},1841.5089137151979,2313.4278583312989]
[null,null,{"$f":"\"State \"&Details!C68","v":"State 0-Failed"},2780.2120473811774,3342.511607638146]
[]
[null,null,"Results by State and Action"]
[null,null,null,null,"Optimal","Agency","Total",null,"Benefit",null,null,null,"Constraints",0]
[null,null,"State","Action","Action?","Cost","Cost","LT Cost","Agency",null,"User","Total","Agency","Total"]
[null,null,{"$f":"Details!C53","v":"5-Excellent"},{"$f":"Details!D53","v":"0-Do Minimum"},{"$f":"IF(H43=MIN(H43:H45),\"Y\",\"\")","v":"Y"},{"$f":"Details!E53","v":69},{"$f":"Details!E53+Details!F53","v":69},{"$f":"Results!E$33+Results!N43","v":1239.6074201726046},{"$f":"Results!M$43-Results!M43","v":0},null,{"$f":"L43-I43","v":0},{"$f":"Results!N$43-Results!N43","v":0},{"$f":"Details!$E53-D33+Results!$D$74*(Details!$G53*$D$33+Details!$H53*$D$34+Details!$I53*$D$35+Details!$J53*$D$36+Details!$K53*$D$37+Details!$L53*$D$38)","v":6.5938365878537297E-12},{"$f":"Results!$G43-E33+Results!$D$74*(Details!$G53*$E$33+Details!$H53*$E$34+Details!$I53*$E$35+Details!$J53*$E$36+Details!$K53*$E$37+Details!$L53*$E$38)","v":8.1854523159563541E-12}]
[null,null,null,{"$f":"Details!D54","v":"1-Rehab"},{"$f":"IF(H44=MIN(H43:H45),\"Y\",\"\")","v":""},{"$f":"Details!E54","v":629},{"$f":"Details!E54+Details!F54","v":829},{"$f":"Results!E$33+Results!N44","v":1987.5116076379406},{"$f":"Results!M$43-Results!M44","v":-553.38515668330615},null,-194.51903078202986,{"$f":"Results!N$43-Results!N44","v":-747.90418746533601},{"$f":"Details!$E54-D33+Results!$D$74*(Details!$G54*$D$33+Details!$H54*$D$34+Details!$I54*$D$35+Details!$J54*$D$36+Details!$K54*$D$37+Details!$L54*$D$38)","v":553.38515668331274},{"$f":"Results!$G44-E33+Results!$D$74*(Details!$G54*$E$33+Details!$H54*$E$34+Details!$I54*$E$35+Details!$J54*$E$36+Details!$K54*$E$37+Details!$L54*$E$38)","v":747.90418746534419}]
[null,null,null,{"$f":"Details!D55","v":"2-Replace"},{"$f":"IF(H45=MIN(H43:H45),\"Y\",\"\")","v":""},{"$f":"Details!E55","v":1700},{"$f":"Details!E55+Details!F55","v":2100},{"$f":"Results!E$33+Results!N45","v":3258.5116076379409},{"$f":"Results!M$43-Results!M45","v":-1624.3851566833061},null,-394.51903078202986,{"$f":"Results!N$43-Results!N45","v":-2018.904187465336},{"$f":"Details!$E55-D33+Results!$D$74*(Details!$G55*$D$33+Details!$H55*$D$34+Details!$I55*$D$35+Details!$J55*$D$36+Details!$K55*$D$37+Details!$L55*$D$38)","v":1624.3851566833127},{"$f":"Results!$G45-E33+Results!$D$74*(Details!$G55*$E$33+Details!$H55*$E$34+Details!$I55*$E$35+Details!$J55*$E$36+Details!$K55*$E$37+Details!$L55*$E$38)","v":2018.9041874653442}]
[null,null,{"$f":"Details!C56","v":"4-Good"},{"$f":"Details!D56","v":"0-Do Minimum"},{"$f":"IF(H46=MIN(H46:H48),\"Y\",\"\")","v":"Y"},{"$f":"Details!E56","v":69},{"$f":"Details!E56+Details!F56","v":76},{"$f":"Results!E$34+Results!N46","v":1498.4578084144175},{"$f":"Results!M$46-Results!M46","v":0},null,0,{"$f":"Results!N$46-Results!N46","v":0},{"$f":"Details!$E56-D34+Results!$D$74*(Details!$G56*$D$33+Details!$H56*$D$34+Details!$I56*$D$35+Details!$J56*$D$36+Details!$K56*$D$37+Details!$L56*$D$38)","v":9.0949470177292824E-12},{"$f":"Results!$G46-E34+Results!$D$74*(Details!$G56*$E$33+Details!$H56*$E$34+Details!$I56*$E$35+Details!$J56*$E$36+Details!$K56*$E$37+Details!$L56*$E$38)","v":1.1141310096718371E-11}]
[null,null,null,{"$f":"Details!D57","v":"1-Rehab"},{"$f":"IF(H47=MIN(H46:H48),\"Y\",\"\")","v":""},{"$f":"Details!E57","v":629},{"$f":"Details!E57+Details!F57","v":836},{"$f":"Results!E$34+Results!N47","v":2236.4278583312207},{"$f":"Results!M$46-Results!M47","v":-544.1243760399318},null,-193.84567387687161,{"$f":"Results!N$46-Results!N47","v":-737.97004991680342},{"$f":"Details!$E57-D34+Results!$D$74*(Details!$G57*$D$33+Details!$H57*$D$34+Details!$I57*$D$35+Details!$J57*$D$36+Details!$K57*$D$37+Details!$L57*$D$38)","v":544.1243760399409},{"$f":"Results!$G47-E34+Results!$D$74*(Details!$G57*$E$33+Details!$H57*$E$34+Details!$I57*$E$35+Details!$J57*$E$36+Details!$K57*$E$37+Details!$L57*$E$38)","v":737.97004991681456}]
[null,null,null,{"$f":"Details!D58","v":"2-Replace"},{"$f":"IF(H48=MIN(H46:H48),\"Y\",\"\")","v":""},{"$f":"Details!E58","v":1700},{"$f":"Details!E58+Details!F58","v":2107},{"$f":"Results!E$34+Results!N48","v":3265.5116076379409},{"$f":"Results!M$46-Results!M48","v":-1482.8275097060493},null,-284.22628951747379,{"$f":"Results!N$46-Results!N48","v":-1767.0537992235231},{"$f":"Details!$E58-D34+Results!$D$74*(Details!$G58*$D$33+Details!$H58*$D$34+Details!$I58*$D$35+Details!$J58*$D$36+Details!$K58*$D$37+Details!$L58*$D$38)","v":1482.8275097060584},{"$f":"Results!$G48-E34+Results!$D$74*(Details!$G58*$E$33+Details!$H58*$E$34+Details!$I58*$E$35+Details!$J58*$E$36+Details!$K58*$E$37+Details!$L58*$E$38)","v":1767.0537992235343}]
[null,null,{"$f":"Details!C59","v":"3-Adequate"},{"$f":"Details!D59","v":"0-Do Minimum"},{"$f":"IF(H49=MIN(H49:H51),\"Y\",\"\")","v":"Y"},{"$f":"Details!E59","v":88},{"$f":"Details!E59+Details!F59","v":102},{"$f":"Results!E$35+Results!N49","v":1969.8987401948273},{"$f":"Results!M$49-Results!M49","v":0},null,0,{"$f":"Results!N$49-Results!N49","v":0},{"$f":"Details!$E59-D35+Results!$D$74*(Details!$G59*$D$33+Details!$H59*$D$34+Details!$I59*$D$35+Details!$J59*$D$36+Details!$K59*$D$37+Details!$L59*$D$38)","v":8.6401996668428183E-12},{"$f":"Results!$G49-E35+Results!$D$74*(Details!$G59*$E$33+Details!$H59*$E$34+Details!$I59*$E$35+Details!$J59*$E$36+Details!$K59*$E$37+Details!$L59*$E$38)","v":1.0459189070388675E-11}]
[null,null,null,{"$f":"Details!D60","v":"1-Rehab"},{"$f":"IF(H50=MIN(H49:H51),\"Y\",\"\")","v":""},{"$f":"Details!E60","v":629},{"$f":"Details!E60+Details!F60","v":843},{"$f":"Results!E$35+Results!N50","v":2243.4278583312207},{"$f":"Results!M$49-Results!M50","v":-204.38602329447076},null,-69.143094841922903,{"$f":"Results!N$49-Results!N50","v":-273.52911813639366},{"$f":"Details!$E60-D35+Results!$D$74*(Details!$G60*$D$33+Details!$H60*$D$34+Details!$I60*$D$35+Details!$J60*$D$36+Details!$K60*$D$37+Details!$L60*$D$38)","v":204.3860232944794},{"$f":"Results!$G50-E35+Results!$D$74*(Details!$G60*$E$33+Details!$H60*$E$34+Details!$I60*$E$35+Details!$J60*$E$36+Details!$K60*$E$37+Details!$L60*$E$38)","v":273.52911813640412}]
[null,null,null,{"$f":"Details!D61","v":"2-Replace"},{"$f":"IF(H51=MIN(H49:H51),\"Y\",\"\")","v":""},{"$f":"Details!E61","v":1700},{"$f":"Details!E61+Details!F61","v":2114},{"$f":"Results!E$35+Results!N51","v":3272.5116076379409},{"$f":"Results!M$49-Results!M51","v":-1143.0891569605883},null,-159.52371048252508,{"$f":"Results!N$49-Results!N51","v":-1302.6128674431134},{"$f":"Details!$E61-D35+Results!$D$74*(Details!$G61*$D$33+Details!$H61*$D$34+Details!$I61*$D$35+Details!$J61*$D$36+Details!$K61*$D$37+Details!$L61*$D$38)","v":1143.0891569605969},{"$f":"Results!$G51-E35+Results!$D$74*(Details!$G61*$E$33+Details!$H61*$E$34+Details!$I61*$E$35+Details!$J61*$E$36+Details!$K61*$E$37+Details!$L61*$E$38)","v":1302.6128674431238}]
[null,null,{"$f":"Details!C62","v":"2-Marginal"},{"$f":"Details!D62","v":"0-Do Minimum"},{"$f":"IF(H52=MIN(H52:H54),\"Y\",\"\")","v":""},{"$f":"Details!E62","v":88},{"$f":"Details!E62+Details!F62","v":116},{"$f":"Results!E$36+Results!N52","v":2279.0673325202256},{"$f":"Results!M$52-Results!M52","v":0},null,0,{"$f":"Results!N$52-Results!N52","v":0},{"$f":"Details!$E62-D36+Results!$D$74*(Details!$G62*$D$33+Details!$H62*$D$34+Details!$I62*$D$35+Details!$J62*$D$36+Details!$K62*$D$37+Details!$L62*$D$38)","v":11.392086657228901},{"$f":"Results!$G52-E36+Results!$D$74*(Details!$G62*$E$33+Details!$H62*$E$34+Details!$I62*$E$35+Details!$J62*$E$36+Details!$K62*$E$37+Details!$L62*$E$38)","v":21.63947418892667}]
[null,null,null,{"$f":"Details!D63","v":"1-Rehab"},{"$f":"IF(H53=MIN(H52:H54),\"Y\",\"\")","v":"Y"},{"$f":"Details!E63","v":629},{"$f":"Details!E63+Details!F63","v":857},{"$f":"Results!E$36+Results!N53","v":2257.4278583312207},{"$f":"Results!M$52-Results!M53","v":11.392086657296431},null,10.247387531708227,{"$f":"Results!N$52-Results!N53","v":21.639474189004659},{"$f":"Details!$E63-D36+Results!$D$74*(Details!$G63*$D$33+Details!$H63*$D$34+Details!$I63*$D$35+Details!$J63*$D$36+Details!$K63*$D$37+Details!$L63*$D$38)","v":-6.7529981606639922E-11},{"$f":"Results!$G53-E36+Results!$D$74*(Details!$G63*$E$33+Details!$H63*$E$34+Details!$I63*$E$35+Details!$J63*$E$36+Details!$K63*$E$37+Details!$L63*$E$38)","v":-7.7989170677028596E-11}]
[null,null,null,{"$f":"Details!D64","v":"2-Replace"},{"$f":"IF(H54=MIN(H52:H54),\"Y\",\"\")","v":""},{"$f":"Details!E64","v":1700},{"$f":"Details!E64+Details!F64","v":2128},{"$f":"Results!E$36+Results!N54","v":3286.5116076379409},{"$f":"Results!M$52-Results!M54","v":-927.31104700882111},null,-80.133228108893945,{"$f":"Results!N$52-Results!N54","v":-1007.4442751177151},{"$f":"Details!$E64-D36+Results!$D$74*(Details!$G64*$D$33+Details!$H64*$D$34+Details!$I64*$D$35+Details!$J64*$D$36+Details!$K64*$D$37+Details!$L64*$D$38)","v":938.70313366605001},{"$f":"Results!$G54-E36+Results!$D$74*(Details!$G64*$E$33+Details!$H64*$E$34+Details!$I64*$E$35+Details!$J64*$E$36+Details!$K64*$E$37+Details!$L64*$E$38)","v":1029.0837493066417}]
[null,null,{"$f":"Details!C65","v":"1-Poor"},{"$f":"Details!D65","v":"0-Do Minimum"},{"$f":"IF(H55=MIN(H55:H57),\"Y\",\"\")","v":""},{"$f":"Details!E65","v":88},{"$f":"Details!E65+Details!F65","v":172},{"$f":"Results!E$37+Results!N55","v":2430.2581619270873},{"$f":"Results!M$55-Results!M55","v":0},null,0,{"$f":"Results!N$55-Results!N55","v":0},{"$f":"Details!$E65-D37+Results!$D$74*(Details!$G65*$D$33+Details!$H65*$D$34+Details!$I65*$D$35+Details!$J65*$D$36+Details!$K65*$D$37+Details!$L65*$D$38)","v":55.256719071527186},{"$f":"Results!$G55-E37+Results!$D$74*(Details!$G65*$E$33+Details!$H65*$E$34+Details!$I65*$E$35+Details!$J65*$E$36+Details!$K65*$E$37+Details!$L65*$E$38)","v":116.83030359578834}]
[null,null,null,{"$f":"Details!D66","v":"1-Rehab"},{"$f":"IF(H56=MIN(H55:H57),\"Y\",\"\")","v":"Y"},{"$f":"Details!E66","v":629},{"$f":"Details!E66+Details!F66","v":913},{"$f":"Results!E$37+Results!N56","v":2313.4278583312207},{"$f":"Results!M$55-Results!M56","v":55.256719071594489},null,61.573584524271837,{"$f":"Results!N$55-Results!N56","v":116.83030359586633},{"$f":"Details!$E66-D37+Results!$D$74*(Details!$G66*$D$33+Details!$H66*$D$34+Details!$I66*$D$35+Details!$J66*$D$36+Details!$K66*$D$37+Details!$L66*$D$38)","v":-6.730260793119669E-11},{"$f":"Results!$G56-E37+Results!$D$74*(Details!$G66*$E$33+Details!$H66*$E$34+Details!$I66*$E$35+Details!$J66*$E$36+Details!$K66*$E$37+Details!$L66*$E$38)","v":-7.7989170677028596E-11}]
[null,null,null,{"$f":"Details!D67","v":"2-Replace"},{"$f":"IF(H57=MIN(H55:H57),\"Y\",\"\")","v":""},{"$f":"Details!E67","v":1700},{"$f":"Details!E67+Details!F67","v":2184},{"$f":"Results!E$37+Results!N57","v":3342.5116076379409},{"$f":"Results!M$55-Results!M57","v":-883.44641459452305},null,-28.807031116330336,{"$f":"Results!N$55-Results!N57","v":-912.25344571085338},{"$f":"Details!$E67-D37+Results!$D$74*(Details!$G67*$D$33+Details!$H67*$D$34+Details!$I67*$D$35+Details!$J67*$D$36+Details!$K67*$D$37+Details!$L67*$D$38)","v":938.70313366605023},{"$f":"Results!$G57-E37+Results!$D$74*(Details!$G67*$E$33+Details!$H67*$E$34+Details!$I67*$E$35+Details!$J67*$E$36+Details!$K67*$E$37+Details!$L67*$E$38)","v":1029.0837493066417}]
[null,null,{"$f":"Details!C68","v":"0-Failed"},{"$f":"Details!D68","v":"0-Replace"},"Y",{"$f":"Details!E68","v":1700},{"$f":"Details!E68+Details!F68","v":2184},{"$f":"Results!E$38+Results!N58","v":3342.5116076379409},"N/A",null,"N/A","N/A",{"$f":"Details!$E68-D38+Results!$D$74*(Details!$G68*$D$33+Details!$H68*$D$34+Details!$I68*$D$35+Details!$J68*$D$36+Details!$K68*$D$37+Details!$L68*$D$38)","v":7.071321306284517E-11},{"$f":"Results!$G58-E38+Results!$D$74*(Details!$G68*$E$33+Details!$H68*$E$34+Details!$I68*$E$35+Details!$J68*$E$36+Details!$K68*$E$37+Details!$L68*$E$38)","v":-2.0531842892523855E-10}]
[]
[null,null,"Results by State"]
[null,null,null,null,null,"Cost",null,null,"Benefit",null,null,null,null,"TP",null,null,null,null,null,"SS","Steady State Cost"]
[null,null,"State","Opt. Action",null,"Agency","Total","LT","Agency",null,"User","Total","PI",5,4,3,2,1,0,"Distrib","Agency","Total"]
[null,null,{"$f":"C43","v":"5-Excellent"},{"$f":"IF($E43=\"Y\",D43,IF($E44=\"Y\",D44,D45))","v":"0-Do Minimum"},null,{"$f":"IF($E43=\"Y\",F43,IF($E44=\"Y\",F44,F45))","v":69},69,1239.6074201726046,{"$f":"IF($E43=\"Y\",I43,IF($E44=\"Y\",I44,I45))","v":0},null,0,0,{"$f":"IF(F63>0,L63/F63,\"N/A\")","v":0},{"$f":"IF($E43=\"Y\",Details!G53,IF($E44=\"Y\",Details!G54,Details!G55))","v":0.95},{"$f":"IF($E43=\"Y\",Details!H53,IF($E44=\"Y\",Details!H54,Details!H55))","v":0.05},{"$f":"IF($E43=\"Y\",Details!I53,IF($E44=\"Y\",Details!I54,Details!I55))","v":0},{"$f":"IF($E43=\"Y\",Details!J53,IF($E44=\"Y\",Details!J54,Details!J55))","v":0},{"$f":"IF($E43=\"Y\",Details!K53,IF($E44=\"Y\",Details!K54,Details!K55))","v":0},{"$f":"IF($E43=\"Y\",Details!L53,IF($E44=\"Y\",Details!L54,Details!L55))","v":0},{"$f":"1/(2-N63+(1-N67)*(D75*(D79*(D82*D84+D83)+D80*D84+D81)+D76*(D82*D84+D83)+D77*D84+D78)+(1-N66)*(D79*(D82*D84+D83)+D80*D84+D81)+(1-N65)*(D82*D84+D83)+(1-N64)*D84)","v":3.5813645955650194E-16},{"$f":"F63*$T63","v":2.4711415709398634E-14},2.4711415709398634E-14]
[null,null,{"$f":"C46","v":"4-Good"},{"$f":"IF($E46=\"Y\",D46,IF($E47=\"Y\",D47,D48))","v":"0-Do Minimum"},null,{"$f":"IF($E46=\"Y\",F46,IF($E47=\"Y\",F47,F48))","v":69},76,1498.4578084144175,{"$f":"IF($E46=\"Y\",I46,IF($E47=\"Y\",I47,I48))","v":0},null,0,0,{"$f":"IF(F64>0,L64/F64,\"N/A\")","v":0},{"$f":"IF($E46=\"Y\",Details!G56,IF($E47=\"Y\",Details!G57,Details!G58))","v":0},{"$f":"IF($E46=\"Y\",Details!H56,IF($E47=\"Y\",Details!H57,Details!H58))","v":0.95},{"$f":"IF($E46=\"Y\",Details!I56,IF($E47=\"Y\",Details!I57,Details!I58))","v":0.05},{"$f":"IF($E46=\"Y\",Details!J56,IF($E47=\"Y\",Details!J57,Details!J58))","v":0},{"$f":"IF($E46=\"Y\",Details!K56,IF($E47=\"Y\",Details!K57,Details!K58))","v":0},{"$f":"IF($E46=\"Y\",Details!L56,IF($E47=\"Y\",Details!L57,Details!L58))","v":0},{"$f":"D84*T63","v":0.64516129032258041},44.51612903225805,49.032258064516114]
[null,null,{"$f":"C49","v":"3-Adequate"},{"$f":"IF($E49=\"Y\",D49,IF($E50=\"Y\",D50,D51))","v":"0-Do Minimum"},null,{"$f":"IF($E49=\"Y\",F49,IF($E50=\"Y\",F50,F51))","v":88},102,1969.8987401948273,{"$f":"IF($E49=\"Y\",I49,IF($E50=\"Y\",I50,I51))","v":0},null,0,0,{"$f":"IF(F65>0,L65/F65,\"N/A\")","v":0},{"$f":"IF($E49=\"Y\",Details!G59,IF($E50=\"Y\",Details!G60,Details!G61))","v":0},{"$f":"IF($E49=\"Y\",Details!H59,IF($E50=\"Y\",Details!H60,Details!H61))","v":0},{"$f":"IF($E49=\"Y\",Details!I59,IF($E50=\"Y\",Details!I60,Details!I61))","v":0.9},{"$f":"IF($E49=\"Y\",Details!J59,IF($E50=\"Y\",Details!J60,Details!J61))","v":0.1},{"$f":"IF($E49=\"Y\",Details!K59,IF($E50=\"Y\",Details!K60,Details!K61))","v":0},{"$f":"IF($E49=\"Y\",Details!L59,IF($E50=\"Y\",Details!L60,Details!L61))","v":0},{"$f":"D82*T64+D83*T63","v":0.32258064516129026},28.387096774193544,32.903225806451609]
[null,null,{"$f":"C52","v":"2-Marginal"},{"$f":"IF($E52=\"Y\",D52,IF($E53=\"Y\",D53,D54))","v":"1-Rehab"},null,{"$f":"IF($E52=\"Y\",F52,IF($E53=\"Y\",F53,F54))","v":629},857,2257.4278583312207,{"$f":"IF($E52=\"Y\",I52,IF($E53=\"Y\",I53,I54))","v":11.392086657296431},null,10.247387531708227,21.639474189004659,{"$f":"IF(F66>0,L66/F66,\"N/A\")","v":3.4402979632757805E-2},{"$f":"IF($E52=\"Y\",Details!G62,IF($E53=\"Y\",Details!G63,Details!G64))","v":0},{"$f":"IF($E52=\"Y\",Details!H62,IF($E53=\"Y\",Details!H63,Details!H64))","v":1},{"$f":"IF($E52=\"Y\",Details!I62,IF($E53=\"Y\",Details!I63,Details!I64))","v":0},{"$f":"IF($E52=\"Y\",Details!J62,IF($E53=\"Y\",Details!J63,Details!J64))","v":0},{"$f":"IF($E52=\"Y\",Details!K62,IF($E53=\"Y\",Details!K63,Details!K64))","v":0},{"$f":"IF($E52=\"Y\",Details!L62,IF($E53=\"Y\",Details!L63,Details!L64))","v":0},{"$f":"D79*T65+D80*T64+D81*T63","v":3.2258064516129024E-2},20.290322580645157,27.645161290322573]
[null,null,{"$f":"C55","v":"1-Poor"},{"$f":"IF($E55=\"Y\",D55,IF($E56=\"Y\",D56,D57))","v":"1-Rehab"},null,{"$f":"IF($E55=\"Y\",F55,IF($E56=\"Y\",F56,F57))","v":629},913,2313.4278583312207,{"$f":"IF($E55=\"Y\",I55,IF($E56=\"Y\",I56,I57))","v":55.256719071594489},null,61.573584524271837,116.83030359586633,{"$f":"IF(F67>0,L67/F67,\"N/A\")","v":0.18573975134477952},{"$f":"IF($E55=\"Y\",Details!G65,IF($E56=\"Y\",Details!G66,Details!G67))","v":0},{"$f":"IF($E55=\"Y\",Details!H65,IF($E56=\"Y\",Details!H66,Details!H67))","v":1},{"$f":"IF($E55=\"Y\",Details!I65,IF($E56=\"Y\",Details!I66,Details!I67))","v":0},{"$f":"IF($E55=\"Y\",Details!J65,IF($E56=\"Y\",Details!J66,Details!J67))","v":0},{"$f":"IF($E55=\"Y\",Details!K65,IF($E56=\"Y\",Details!K66,Details!K67))","v":0},{"$f":"IF($E55=\"Y\",Details!L65,IF($E56=\"Y\",Details!L66,Details!L67))","v":0},{"$f":"D75*T66+D76*T65+D77*T64+D78*T63","v":0},0,0]
[null,null,{"$f":"C58","v":"0-Failed"},{"$f":"D58","v":"0-Replace"},null,{"$f":"F58","v":1700},2184,3342.5116076379409,{"$f":"I58","v":"N/A"},null,"N/A","N/A","N/A",{"$f":"Details!G68","v":1},{"$f":"Details!H68","v":0},{"$f":"Details!I68","v":0},{"$f":"Details!J68","v":0},{"$f":"Details!K68","v":0},{"$f":"Details!L68","v":0},{"$f":"1-T67-T66-T65-T64-T63","v":-2.5069552168954978E-17},-4.2618238687223461E-14,-5.4751901936997673E-14]
[null,null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T63:T68)","v":1},{"$f":"SUM(U63:U68)","v":93.193548387096726},{"$f":"SUM(V63:V68)","v":109.58064516129026}]
[]
[null,null,"Misc. Parameters"]
[null,null,"Description","Value"]
[null,null,"Disc. Rate",{"$f":"IF(Inputs!$F$30<>\"\",Inputs!$F$30,Inputs!$E$30)","v":7.0000000000000007E-2}]
[null,null,"Disc. Factor",{"$f":"1/(1+D73)","v":0.93457943925233644}]
[null,null,"c1",{"$f":"R66/(1-R67)","v":0}]
[null,null,"c2",{"$f":"R65/(1-R67)","v":0}]
[null,null,"c3",{"$f":"R64/(1-R67)","v":0}]
[null,null,"c4",{"$f":"R63/(1-R67)","v":0}]
[null,null,"c5",{"$f":"(Q67*D76+Q65)/(1-Q66-Q67*D75)","v":0.1}]
[null,null,"c6",{"$f":"(Q67*D77+Q64)/(1-Q66-Q67*D75)","v":0}]
[null,null,"c7",{"$f":"(Q67*D78+Q63)/(1-Q66-Q67*D75)","v":0}]
[null,null,"c8",{"$f":"(P67*D75*D80+P67*D77+P66*D80+P64)/(1-P65-P67*D75*D79-P67*D76-P66*D79)","v":0.50000000000000011}]
[null,null,"c9",{"$f":"(P67*D75*D81+P67*D78+P66*D81+P63)/(1-P65-P67*D75*D79-P67*D76-P66*D79)","v":0}]
[null,null,"c10",{"$f":"(O67*D75*D79*D83+O67*D75*D81+O67*D76*D83+O67*D78+O66*D79*D83+O66*D81+O65*D83+O63)/(1-O64-O67*D75*D79*D82-O67*D75*D80-O67*D76*D82-O67*D77-O66*D79*D82-O66*D80-O65*D82)","v":1801439850948198.5}]
[]
[null,null,"Asset List"]
[null,null,"User-Specified"]
[null,null,"Guideway-At Grade Ballasted or Expressway"]
[null,null,"Guideway-Grade Crossing"]
[null,null,"Guideway-Elevated Structure "]
[null,null,"Guideway-Steel Viaduct"]
[null,null,"Guideway-Bridge"]
[null,null,"Guideway-Foot Walk"]
[null,null,"Guideway-Elevated Fill"]
[null,null,"Guideway-Tunnel"]
[null,null,"Guideway-Retained Cut"]
[null,null,"Guideway-Tangent Direct Fixation Track"]
[null,null,"Guideway-Curved Direct Fixation Track"]
[null,null,"Guideway-Guarded Direct Fixation Track"]
[null,null,"Guideway-Direct Fixation Tangent Platform Track"]
[null,null,"Guideway-Direct Fixation Curved Platform Track"]
[null,null,"Guideway-Guarded Curved Direct Fixation Track"]
[null,null,"Guideway-Tangent Ballasted Track"]
[null,null,"Guideway-Curved Ballasted Track"]
[null,null,"Guideway-Guarded Ballasted Track"]
[null,null,"Guideway-Ballasted Tangent Platform Track"]
[null,null,"Guideway-Ballasted Curved Platform Track"]
[null,null,"Guideway-Guarded Platform Ballasted Track"]
[null,null,"Guideway-Tangent Embedded Track"]
[null,null,"Guideway-Curved Embedded Track"]
[null,null,"Guideway-At-Grade Crossing"]
[null,null,"Guideway-Special Trackwork"]
[null,null,"Guideway-Direct Fixation Diamond Crossover"]
[null,null,"Guideway-Direct Fixation or Ballasted Turnout"]
[null,null,"Guideway-Turntable"]
[null,null,"Guideway-Yard Track"]
[null,null,"Guideway-Wood Tie"]
[null,null,"Guideway-Concrete Tie"]
[null,null,"Guideway-Retaining Wall"]
[null,null,"Guideway-At Grade Bus"]
[null,null,"Guideway-Bus Turnaround"]
[null,null,"Guideway-Elevated-Bus"]
[null,null,"Guideway-Subway Bus"]
[null,null,"Facilities-Administrative Building"]
[null,null,"Facilities-Maintenance Building"]
[null,null,"Facilities-Passenger Building"]
[null,null,"Facilities-Building Utilities"]
[null,null,"Facilities-Access and Parking"]
[null,null,"Facilities-Building Utilities-Elevators and Conveying Systems"]
[null,null,"Facilities-Building Utilities-Generator"]
[null,null,"Facilities-Storage Yard"]
[null,null,"Facilities-Storage Yard-Bus"]
[null,null,"Facilities-Bus Turnaround Facility"]
[null,null,"Facilities-Maintenance Equipment"]
[null,null,"Facilities-Pollution Treatment"]
[null,null,"Facilities-Bus Washer"]
[null,null,"Facilities-Train Washer"]
[null,null,"Facilities-Vehicle Paintbooth"]
[null,null,"Facilities-Fuel Island"]
[null,null,"Facilities-Dynamoneter"]
[null,null,"Facilities-Portable Lift"]
[null,null,"Facilities-Fixed Lift"]
[null,null,"Facilities-Wheel Truing Machine"]
[null,null,"Facilities-Brake Lathe"]
[null,null,"Facilities-Major Rail Shop"]
[null,null,"Facilities-Major Bus Shop"]
[null,null,"Facilities-Train Control Center"]
[null,null,"Systems-Train Control, Elec., Comm., Revenue Collect. & Util."]
[null,null,"Systems-Train Control"]
[null,null,"Systems-Train Control"]
[null,null,"Systems-Signals & Train Stops"]
[null,null,"Systems-Train Control Cable"]
[null,null,"Systems-Signal Bridge"]
[null,null,"Systems-Centralized Train Control"]
[null,null,"Systems-Gates, Flashers, Crossings"]
[null,null,"Systems-Roadway Traffic Signals"]
[null,null,"Systems-Interlocking"]
[null,null,"Systems-Electrification"]
[null,null,"Systems-Electrification Catenary/Pole"]
[null,null,"Systems-Electrification Substation"]
[null,null,"Systems-High Tension Towers"]
[null,null,"Systems-Electrification Substation Building Components"]
[null,null,"Systems-Electrification Breaker House"]
[null,null,"Systems-Electrification Contact Rail/Protection Boards"]
[null,null,"Systems-Heaters"]
[null,null,"Systems-Power Cable"]
[null,null,"Systems-Electrical Systems"]
[null,null,"Systems-Trolley Wire"]
[null,null,"Systems-Communications Cable"]
[null,null,"Systems-Communciations"]
[null,null,"Systems-MIS/IT/Network System"]
[null,null,"Systems-Emergency Location System"]
[null,null,"Systems-SCADA RTU"]
[null,null,"Systems-Communications Hut or Room"]
[null,null,"Systems-Bus On-Board Video System"]
[null,null,"Systems-Central Revenue Collection"]
[null,null,"Systems-Coin/Bill Counter"]
[null,null,"Systems-Revenue Collection System-Rail"]
[null,null,"Systems-Turnstile"]
[null,null,"Systems-In Station Revenue Collection Equipment"]
[null,null,"Systems-Parking Meter"]
[null,null,"Systems-Change Machine"]
[null,null,"Systems-Passenger Counter-Rail"]
[null,null,"Systems-System Utilities"]
[null,null,"Systems-Lighting"]
[null,null,"Systems-Guideway Drainage"]
[null,null,"Systems-Pump Room"]
[null,null,"Systems-Deep Utility Well"]
[null,null,"Systems-Sump Pump/Discharge Pipes"]
[null,null,"Systems-Subway Ventilation"]
[null,null,"Systems-Fan Plant"]
[null,null,"Systems-Compressed Air Pipes"]
[null,null,"Systems-Air Conditioning/HVAC-Subway"]
[null,null,"Systems-Emergency Exit"]
[null,null,"Systems-Tunnel Handrail"]
[null,null,"Systems-ITS, APC, AVL, CAD, GPL"]
[null,null,"Station-Building-Rail"]
[null,null,"Stations-Building-Subway"]
[null,null,"Stations-Shelter-Rail"]
[null,null,"Stations-Token Booth"]
[null,null,"Stations-Elevator/Escalator"]
[null,null,"Stations-Parking Garage/Lot"]
[null,null,"Stations-Parking Equipment"]
[null,null,"Stations-Pedestrian Walkway/Elevated"]
[null,null,"Stations-Pedestrian Walkway/Subway"]
[null,null,"Stations-At-Grade Rail Platform"]
[null,null,"Stations-Elevated Rail Platform"]
[null,null,"Stations-Subway Rail Platform"]
[null,null,"Stations-Building/Ground Access-Bus"]
[null,null,"Stations-Bus Shelter"]
[null,null,"Stations-Station Canopy"]
[null,null,"Stations-Bus Station Platform"]
[null,null,"Stations-Signage & Graphics"]
[null,null,"Stations-Ferry Terminal Building/Dock"]

{"sheet":"Details","index":2,"n_rows":200,"n_cols":12,"rows_kept":200,"cut":false,"hidden":false,"merged":[[2,2,2,12],[3,2,3,12],[4,2,4,12],[29,4,29,5],[50,4,50,5],[50,6,50,11],[29,6,29,11],[8,4,8,5],[8,6,8,11]]}
[]
[]
[null,null,"TCRP E-09"]
[null,null,"TRANSIT STATE OF GOOD REPAIR"]
[null,null,"CONDITION-BASED MODEL - DETAILED INPUTS"]
[]
[null,null,"Defaults Based on Summary Inputs",null,null,null,null,"Asset:",null,null,null,{"$f":"Inputs!$E$23","v":"User-Specified"}]
[]
[null,null,null,null,"Unit Cost",null,"Probability of Transition to State"]
[null,null,"State","Action","Agency","User",{"$f":"C11","v":"5-Excellent"},{"$f":"C14","v":"4-Good"},{"$f":"C17","v":"3-Adequate"},{"$f":"C20","v":"2-Marginal"},{"$f":"C23","v":"1-Poor"},{"$f":"C26","v":"0-Failed"}]
[null,null,"5-Excellent","0-Do Minimum",0,0,{"$f":"VLOOKUP(Inputs!$E$23,Details!$C$73:$G$200,2)","v":0.95},{"$f":"1-G11","v":5.0000000000000044E-2},0,0,0,{"$f":"1-SUM(G11:K11)","v":0}]
[null,null,null,"1-Rehab",{"$f":"IF(Inputs!F29<>\"\",Inputs!F29,Inputs!E29)","v":629},0,0,1,0,0,0,0]
[null,null,null,"2-Replace",{"$f":"IF(Inputs!F28<>\"\",Inputs!F28,Inputs!E28)","v":1700},0,1,0,0,0,0,0]
[null,null,"4-Good","0-Do Minimum",0,0,0,{"$f":"VLOOKUP(Inputs!$E$23,Details!$C$73:$G$200,3)","v":0.92},{"$f":"1-H14","v":7.999999999999996E-2},0,0,0]
[null,null,null,"1-Rehab",{"$f":"E12","v":629},0,0,1,0,0,0,0]
[null,null,null,"2-Replace",{"$f":"E13","v":1700},0,1,0,0,0,0,0]
[null,null,"3-Adequate","0-Do Minimum",0,0,0,0,{"$f":"VLOOKUP(Inputs!$E$23,Details!$C$73:$G$200,4)","v":0.9},{"$f":"1-I17","v":9.9999999999999978E-2},0,0]
[null,null,null,"1-Rehab",{"$f":"E12","v":629},0,0,1,0,0,0,0]
[null,null,null,"2-Replace",{"$f":"E13","v":1700},0,1,0,0,0,0,0]
[null,null,"2-Marginal","0-Do Minimum",{"$f":"E22*0.05","v":85},0,0,0,0,{"$f":"VLOOKUP(Inputs!$E$23,Details!$C$73:$G$200,5)","v":0.85},{"$f":"(1-J20)/2","v":7.5000000000000011E-2},7.4999999999999956E-2]
[null,null,null,"1-Rehab",{"$f":"E12","v":629},0,0,1,0,0,0,0]
[null,null,null,"2-Replace",{"$f":"E13","v":1700},0,1,0,0,0,0,0]
[null,null,"1-Poor","0-Do Minimum",{"$f":"E25*0.1","v":170},0,0,0,0,0,{"$f":"J20","v":0.85},0.15000000000000002]
[null,null,null,"1-Rehab",{"$f":"E12","v":629},0,0,1,0,0,0,0]
[null,null,null,"2-Replace",{"$f":"E13","v":1700},0,1,0,0,0,0,0]
[null,null,"0-Failed","0-Replace",{"$f":"E13*1.5","v":2550},{"$f":"E13*1.5","v":2550},1,0,0,0,0,0]
[]
[null,null,"Override Values",null,null,null,null,"Asset:",null,null,null,{"$f":"Inputs!$E$23","v":"User-Specified"}]
[]
[null,null,null,null,"Unit Cost",null,"Probability of Transition to State"]
[null,null,"State","Action","Agency","User",{"$f":"IF(C32<>\"\",C32,G10)","v":"5-Excellent"},{"$f":"IF(C35<>\"\",C35,H10)","v":"4-Good"},{"$f":"IF(C38<>\"\",C38,I10)","v":"3-Adequate"},{"$f":"IF(C41<>\"\",C41,J10)","v":"2-Marginal"},{"$f":"IF(C44<>\"\",C44,K10)","v":"1-Poor"},{"$f":"L10","v":"0-Failed"}]
[null,null,null,"0-Do Minimum",69,0,0.95,0.05,0,0,0]
[null,null,null,"1-Rehab",629,200,1,0,0,0,0]
[null,null,null,"2-Replace",1700,400,1,0,0,0,0]
[null,null,null,"0-Do Minimum",69,7,0,0.95,0.05,0,0]
[null,null,null,"1-Rehab",629,207,0,1,0,0,0]
[null,null,null,"2-Replace",1700,407,1,0,0,0,0]
[null,null,null,"0-Do Minimum",88,14,0,0,0.9,0.1,0]
[null,null,null,"1-Rehab",629,214,0,1,0,0,0]
[null,null,null,"2-Replace",1700,414,1,0,0,0,0]
[null,null,null,"0-Do Minimum",88,28,0,0,0,0.9,0.05]
[null,null,null,"1-Rehab",629,228,0,1,0,0,0]
[null,null,null,"2-Replace",1700,428,1,0,0,0,0]
[null,null,null,"0-Do Minimum",88,84,0,0,0,0,0.9]
[null,null,null,"1-Rehab",629,284,0,1,0,0,0]
[null,null,null,"2-Replace",1700,484,1,0,0,0,0]
[null,null,{"$f":"C26","v":"0-Failed"},"0-Replace",1700,484,1,0,0,0,0,{"$f":"1-SUM(G47:K47)","v":0}]
[]
[null,null,"Resulting Values",null,null,null,null,"Asset:",null,null,null,{"$f":"Inputs!$E$23","v":"User-Specified"}]
[]
[null,null,null,null,"Unit Cost",null,"Probability of Transition to State"]
[null,null,"State","Action","Agency","User",{"$f":"G31","v":"5-Excellent"},"4-Good","3-Adequate","2-Marginal","1-Poor","0-Failed"]
[null,null,{"$f":"IF(C32<>\"\",C32,C11)","v":"5-Excellent"},{"$f":"IF(D32<>\"\",D32,D11)","v":"0-Do Minimum"},69,0,0.95,0.05,0,0,0,{"$f":"1-SUM(G53:K53)","v":0}]
[null,null,null,{"$f":"IF(D33<>\"\",D33,D12)","v":"1-Rehab"},629,200,1,0,0,0,0,0]
[null,null,null,{"$f":"IF(D34<>\"\",D34,D13)","v":"2-Replace"},1700,400,1,0,0,0,0,0]
[null,null,{"$f":"IF(C35<>\"\",C35,C14)","v":"4-Good"},"0-Do Minimum",69,7,0,0.95,0.05,0,0,0]
[null,null,null,{"$f":"IF(D36<>\"\",D36,D15)","v":"1-Rehab"},629,207,0,1,0,0,0,0]
[null,null,null,{"$f":"IF(D37<>\"\",D37,D16)","v":"2-Replace"},1700,407,1,0,0,0,0,0]
[null,null,{"$f":"IF(C38<>\"\",C38,C17)","v":"3-Adequate"},"0-Do Minimum",88,14,0,0,0.9,0.1,0,0]
[null,null,null,{"$f":"IF(D39<>\"\",D39,D18)","v":"1-Rehab"},629,214,0,1,0,0,0,0]
[null,null,null,{"$f":"IF(D40<>\"\",D40,D19)","v":"2-Replace"},1700,414,1,0,0,0,0,0]
[null,null,{"$f":"IF(C41<>\"\",C41,C20)","v":"2-Marginal"},"0-Do Minimum",88,28,0,0,0,0.9,0.05,4.9999999999999933E-2]
[null,null,null,{"$f":"IF(D42<>\"\",D42,D21)","v":"1-Rehab"},629,228,0,1,0,0,0,0]
[null,null,null,{"$f":"IF(D43<>\"\",D43,D22)","v":"2-Replace"},1700,428,1,0,0,0,0,0]
[null,null,{"$f":"IF(C44<>\"\",C44,C23)","v":"1-Poor"},"0-Do Minimum",88,84,0,0,0,0,0.9,9.9999999999999978E-2]
[null,null,null,{"$f":"IF(D45<>\"\",D45,D24)","v":"1-Rehab"},629,284,0,1,0,0,0,0]
[null,null,null,{"$f":"IF(D46<>\"\",D46,D25)","v":"2-Replace"},1700,484,1,0,0,0,0,0]
[null,null,{"$f":"IF(C47<>\"\",C47,C26)","v":"0-Failed"},"0-Replace",1700,484,1,0,0,0,0,0]
[]
[]
[null,null,"Model Lookup"]
[null,null,"Asset",5,4,3,2]
[null,null,"Facilities-Access and Parking",0.98083418824956659,0.9587049163986352,0.9287843724251954,0.88480844768298816]
[null,null,"Facilities-Administrative Building",0.98609476829826004,0.9643442431102105,0.9353949326528469,0.8933936869387592]
[null,null,"Facilities-Brake Lathe",0.95022123612706344,0.91681049183018981,0.86819483072294579,0.79392501942722826]
[null,null,"Facilities-Building Utilities",0.95819325844533121,0.93087546260315879,0.89113963047514388,0.83027009236782912]
[null,null,"Facilities-Building Utilities-Elevators and Conveying Systems",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Facilities-Building Utilities-Generator",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Facilities-Bus Turnaround Facility",0.94724061828060568,0.91332061985317803,0.86360621871184939,0.78727209411611476]
[null,null,"Facilities-Bus Washer",0.98083418824956659,0.9587049163986352,0.9287843724251954,0.88480844768298816]
[null,null,"Facilities-Dynamoneter",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Facilities-Fixed Lift",0.98083418824956659,0.9587049163986352,0.9287843724251954,0.88480844768298816]
[null,null,"Facilities-Fuel Island",0.98083418824956659,0.9587049163986352,0.9287843724251954,0.88480844768298816]
[null,null,"Facilities-Maintenance Building",0.96289236584314497,0.93655595474090059,0.89880162128710006,0.8414075748410651]
[null,null,"Facilities-Maintenance Equipment",0.89401569386215252,0.82933985904581298,0.73356998673104012,0.58653038368850308]
[null,null,"Facilities-Major Bus Shop",0.98083418824956659,0.9587049163986352,0.9287843724251954,0.88480844768298816]
[null,null,"Facilities-Major Rail Shop",0.98083418824956659,0.9587049163986352,0.9287843724251954,0.88480844768298816]
[null,null,"Facilities-Passenger Building",0.98609476829826004,0.9643442431102105,0.9353949326528469,0.8933936869387592]
[null,null,"Facilities-Pollution Treatment",0.98084956591502181,0.958719616609504,0.92880457142663009,0.88485906393406577]
[null,null,"Facilities-Portable Lift",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Facilities-Storage Yard",0.98083418824956659,0.9587049163986352,0.9287843724251954,0.88480844768298816]
[null,null,"Facilities-Storage Yard-Bus",0.98083418824956659,0.9587049163986352,0.9287843724251954,0.88480844768298816]
[null,null,"Facilities-Train Control Center",0.98084956591502181,0.958719616609504,0.92880457142663009,0.88485906393406577]
[null,null,"Facilities-Train Washer",0.94724061828060568,0.91332061985317803,0.86360621871184939,0.78727209411611476]
[null,null,"Facilities-Vehicle Paintbooth",0.98083418824956659,0.9587049163986352,0.9287843724251954,0.88480844768298816]
[null,null,"Facilities-Wheel Truing Machine",0.95022123612706344,0.91681049183018981,0.86819483072294579,0.79392501942722826]
[null,null,"Guideway-At Grade Ballasted or Expressway",0.98444276540573339,0.96247400327043964,0.93313834640197002,0.89031348821717704]
[null,null,"Guideway-At Grade Bus",0.98084956591502181,0.958719616609504,0.92880457142663009,0.88485906393406577]
[null,null,"Guideway-At-Grade Crossing",0.93562092141222875,0.89356012355513692,0.83194893026670713,0.73763676407274614]
[null,null,"Guideway-Ballasted Curved Platform Track",0.93790041347976605,0.89731671660303958,0.83787591908999759,0.7468709209439115]
[null,null,"Guideway-Ballasted Tangent Platform Track",0.94742376786478544,0.91275303297737442,0.86212859042803913,0.7846068221162954]
[null,null,"Guideway-Bridge",0.98444276540573339,0.96247400327043964,0.93313834640197002,0.89031348821717704]
[null,null,"Guideway-Bus Turnaround",0.98083418824956659,0.9587049163986352,0.9287843724251954,0.88480844768298816]
[null,null,"Guideway-Concrete Tie",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Guideway-Curved Ballasted Track",0.94644170305880382,0.91079214758994453,0.8587962672008409,0.77930730999456577]
[null,null,"Guideway-Curved Direct Fixation Track",0.93562092141222875,0.89356012355513692,0.83194893026670713,0.73763676407274614]
[null,null,"Guideway-Curved Embedded Track",0.93562092141222875,0.89356012355513692,0.83194893026670713,0.73763676407274614]
[null,null,"Guideway-Direct Fixation Curved Platform Track",0.92519209207131214,0.88009857968868077,0.81316927803464611,0.70998392575593683]
[null,null,"Guideway-Direct Fixation Diamond Crossover",0.94339088306586227,0.90615509246571024,0.85171160494772902,0.7683798247274034]
[null,null,"Guideway-Direct Fixation or Ballasted Turnout",0.95818670134314965,0.92899216743251556,0.88692494138518763,0.82294632649346589]
[null,null,"Guideway-Direct Fixation Tangent Platform Track",0.94603645035423034,0.91154067500869806,0.8609157598241034,0.78315094204745062]
[null,null,"Guideway-Elevated Fill",0.9927532157208121,0.97071383821779955,0.94230212986087547,0.90198265133535771]
[null,null,"Guideway-Elevated Structure ",0.98481410146275206,0.96429045566787619,0.94102712917019427,0.60163387025564496]
[null,null,"Guideway-Elevated-Bus",0.98084956591502181,0.958719616609504,0.92880457142663009,0.88485906393406577]
[null,null,"Guideway-Foot Walk",0.99145850017781534,0.96943696459410733,0.94103847956178777,0.90053204233597106]
[null,null,"Guideway-Grade Crossing",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Guideway-Guarded Ballasted Track",0.95022123612706344,0.91681049183018981,0.86819483072294579,0.79392501942722826]
[null,null,"Guideway-Guarded Curved Direct Fixation Track",0.93195664044450321,0.89098512895387683,0.8301700173984019,0.73634155219735997]
[null,null,"Guideway-Guarded Direct Fixation Track",0.94116132837155342,0.90244289743511297,0.84581582744524841,0.75916784894423062]
[null,null,"Guideway-Guarded Platform Ballasted Track",0.97219428567879984,0.94866829578129952,0.91587258406825933,0.86687234736222052]
[null,null,"Guideway-Retained Cut",0.9927532157208121,0.97071383821779955,0.94230212986087547,0.90198265133535771]
[null,null,"Guideway-Retaining Wall",0.9507136617539198,0.92752159251741695,0.89084130410257933,0.83338825921242587]
[null,null,"Guideway-Special Trackwork",0.94685810482318544,0.91151669149182157,0.8599670574718451,0.78114503326632634]
[null,null,"Guideway-Steel Viaduct",0.98481410146275206,0.96429045566787619,0.94102712917019427,0.60163387025564496]
[null,null,"Guideway-Subway Bus",0.98084956591502181,0.958719616609504,0.92880457142663009,0.88485906393406577]
[null,null,"Guideway-Tangent Ballasted Track",0.95579873690300721,0.92538707672105813,0.88140887073448515,0.81441437877400424]
[null,null,"Guideway-Tangent Direct Fixation Track",0.9604416321669339,0.93234487598181115,0.89201285347518666,0.83080493765534102]
[null,null,"Guideway-Tangent Embedded Track",0.9604416321669339,0.93234487598181115,0.89201285347518666,0.83080493765534102]
[null,null,"Guideway-Tunnel",0.9927532157208121,0.97071383821779955,0.94230212986087547,0.90198265133535771]
[null,null,"Guideway-Turntable",0.95022123612706344,0.91681049183018981,0.86819483072294579,0.79392501942722826]
[null,null,"Guideway-Wood Tie",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Guideway-Yard Track",0.9503627212966208,0.91693721680613582,0.86832765497862896,0.7941034206446661]
[null,null,"Station-Building-Rail",0.9484020150802126,0.91841373336737731,0.87371758980666847,0.80458741095163944]
[null,null,"Stations-At-Grade Rail Platform",0.97102414700244832,0.94863166450009273,0.91684928021171019,0.86900688311518581]
[null,null,"Stations-Building/Ground Access-Bus",0.95819325844533121,0.93087546260315879,0.89113963047514388,0.83027009236782912]
[null,null,"Stations-Building-Subway",0.9927532157208121,0.97071383821779955,0.94230212986087547,0.90198265133535771]
[null,null,"Stations-Bus Shelter",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Stations-Bus Station Platform",0.97102414700244832,0.94863166450009273,0.91684928021171019,0.86900688311518581]
[null,null,"Stations-Elevated Rail Platform",0.97647312522699337,0.95463387519873999,0.92429482813473629,0.87913336222372507]
[null,null,"Stations-Elevator/Escalator",0.98084956591502181,0.958719616609504,0.92880457142663009,0.88485906393406577]
[null,null,"Stations-Ferry Terminal Building/Dock",0.97047686394545296,0.94786463931152609,0.91575828090617228,0.86735646437661806]
[null,null,"Stations-Parking Equipment",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Stations-Parking Garage/Lot",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Stations-Pedestrian Walkway/Elevated",0.98925974892847823,0.96727748509524458,0.93864079380986876,0.89739199292791583]
[null,null,"Stations-Pedestrian Walkway/Subway",0.98925974892847823,0.96727748509524458,0.93864079380986876,0.89739199292791583]
[null,null,"Stations-Shelter-Rail",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Stations-Signage & Graphics",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Stations-Station Canopy",0.97047686394545296,0.94786463931152609,0.91575828090617228,0.86735646437661806]
[null,null,"Stations-Subway Rail Platform",0.98480113001343017,0.96279516396877152,0.93346420423858067,0.89075844259663206]
[null,null,"Stations-Token Booth",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Systems-Air Conditioning/HVAC-Subway",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Systems-Bus On-Board Video System",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Systems-Central Revenue Collection",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Systems-Centralized Train Control",0.98084956591502181,0.958719616609504,0.92880457142663009,0.88485906393406577]
[null,null,"Systems-Change Machine",0.8708375057154264,0.78630321152668459,0.66259331295397528,0.47516523099353081]
[null,null,"Systems-Coin/Bill Counter",0.74544066468862014,0.5,0.25,0.25]
[null,null,"Systems-Communciations",0.89401569386215252,0.82933985904581298,0.73356998673104012,0.58653038368850308]
[null,null,"Systems-Communications Cable",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Systems-Communications Hut or Room",0.95328532684960499,0.92210362363830489,0.876759791393254,0.80739383816145249]
[null,null,"Systems-Compressed Air Pipes",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Systems-Deep Utility Well",0.97123168085626499,0.94747068428483128,0.91419448392380254,0.86426496999691438]
[null,null,"Systems-Electrical Systems",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Systems-Electrification",0.94984315332330937,0.91688695050873004,0.86877620318265814,0.79506616507162808]
[null,null,"Systems-Electrification Breaker House",0.9484020150802126,0.91841373336737731,0.87371758980666847,0.80458741095163944]
[null,null,"Systems-Electrification Catenary/Pole",0.95328532684960499,0.92210362363830489,0.876759791393254,0.80739383816145249]
[null,null,"Systems-Electrification Contact Rail/Protection Boards",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Systems-Electrification Substation",0.95328532684960499,0.92210362363830489,0.876759791393254,0.80739383816145249]
[null,null,"Systems-Electrification Substation Building Components",0.95819325844533121,0.93087546260315879,0.89113963047514388,0.83027009236782912]
[null,null,"Systems-Emergency Exit",0.98084956591502181,0.958719616609504,0.92880457142663009,0.88485906393406577]
[null,null,"Systems-Emergency Location System",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Systems-Fan Plant",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Systems-Gates, Flashers, Crossings",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Systems-Guideway Drainage",0.95819325844533121,0.93087546260315879,0.89113963047514388,0.83027009236782912]
[null,null,"Systems-Heaters",0.89401569386215252,0.82933985904581298,0.73356998673104012,0.58653038368850308]
[null,null,"Systems-High Tension Towers",0.98083418824956659,0.9587049163986352,0.9287843724251954,0.88480844768298816]
[null,null,"Systems-In Station Revenue Collection Equipment",0.89401569386215252,0.82933985904581298,0.73356998673104012,0.58653038368850308]
[null,null,"Systems-Interlocking",0.95298881870903118,0.9252627546408051,0.88410861420242759,0.82057010744847714]
[null,null,"Systems-ITS, APC, AVL, CAD, GPL",0.89401569386215252,0.82933985904581298,0.73356998673104012,0.58653038368850308]
[null,null,"Systems-Lighting",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Systems-MIS/IT/Network System",0.8708375057154264,0.78630321152668459,0.66259331295397528,0.47516523099353081]
[null,null,"Systems-Parking Meter",0.8708375057154264,0.78630321152668459,0.66259331295397528,0.47516523099353081]
[null,null,"Systems-Passenger Counter-Rail",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Systems-Power Cable",0.92394529533268588,0.87658432238321538,0.80666879512613177,0.69920778373721015]
[null,null,"Systems-Pump Room",0.98084956591502181,0.958719616609504,0.92880457142663009,0.88485906393406577]
[null,null,"Systems-Revenue Collection System-Rail",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Systems-Roadway Traffic Signals",0.8787107491795495,0.79919233153334313,0.68286594698243452,0.5064034760540711]
[null,null,"Systems-SCADA RTU",0.74544066468862014,0.5,0.25,0.25]
[null,null,"Systems-Signal Bridge",0.9993530250839272,0.97689222389350316,0.95338543645321683,0.79499231495113376]
[null,null,"Systems-Signals & Train Stops",0.94752685535943182,0.91379631807107342,0.86435780969437614,0.78845275372689094]
[null,null,"Systems-Subway Ventilation",0.95819325844533121,0.93087546260315879,0.89113963047514388,0.83027009236782912]
[null,null,"Systems-Sump Pump/Discharge Pipes",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Systems-System Utilities",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"Systems-Train Control",0.94724061828060568,0.91332061985317803,0.86360621871184939,0.78727209411611476]
[null,null,"Systems-Train Control",0.94768497079920933,0.91491954130836817,0.8667079902076642,0.7925357087652195]
[null,null,"Systems-Train Control Cable",0.94565751174438206,0.91069934277488551,0.85943837785089772,0.78074546775560705]
[null,null,"Systems-Train Control, Elec., Comm., Revenue Collect. & Util.",0.94320587359825725,0.90670561989966925,0.85314470681606203,0.77093880052950847]
[null,null,"Systems-Trolley Wire",0.97123168085626499,0.94747068428483128,0.91419448392380254,0.86426496999691438]
[null,null,"Systems-Tunnel Handrail",0.95819325844533121,0.93087546260315879,0.89113963047514388,0.83027009236782912]
[null,null,"Systems-Turnstile",0.90246828843803673,0.83823360714964701,0.74432225538143459,0.60140479612026387]
[null,null,"User Specified",0.95,0.92,0.9,0.85]

{"sheet":"Graph Data","index":3,"n_rows":139,"n_cols":16,"rows_kept":139,"cut":false,"hidden":false,"merged":[]}
["Transit Asset Rehabilitation/Replacement Condition-Based Model"]
["Graph Data"]
[]
["Model Parameters"]
[null,"Init.",null,"Cost",null,"Probability of Transition to State"]
["State","Quantity","Policy","Agency","User",{"$f":"A7","v":"5-Excellent"},{"$f":"A8","v":"4-Good"},{"$f":"A9","v":"3-Adequate"},{"$f":"A10","v":"2-Marginal"},{"$f":"A11","v":"1-Poor"},{"$f":"A12","v":"0-Failed"}]
[{"$f":"Details!C53","v":"5-Excellent"},1,"0-Do Minimum",{"$f":"IF(OR($C7=Details!$D53,AND($C7=\"Optimal\",Results!$E43=\"Y\")),Details!E53,IF(OR($C7=Details!$D54,AND($C7=\"Optimal\",Results!$E44=\"Y\")),Details!E54,Details!E55))","v":69},{"$f":"IF(OR($C7=Details!$D53,AND($C7=\"Optimal\",Results!$E43=\"Y\")),Details!F53,IF(OR($C7=Details!$D54,AND($C7=\"Optimal\",Results!$E44=\"Y\")),Details!F54,Details!F55))","v":0},{"$f":"IF(OR($C7=Details!$D53,AND($C7=\"Optimal\",Results!$E43=\"Y\")),Details!G53,IF(OR($C7=Details!$D54,AND($C7=\"Optimal\",Results!$E44=\"Y\")),Details!G54,Details!G55))","v":0.95},{"$f":"IF(OR($C7=Details!$D53,AND($C7=\"Optimal\",Results!$E43=\"Y\")),Details!H53,IF(OR($C7=Details!$D54,AND($C7=\"Optimal\",Results!$E44=\"Y\")),Details!H54,Details!H55))","v":0.05},{"$f":"IF(OR($C7=Details!$D53,AND($C7=\"Optimal\",Results!$E43=\"Y\")),Details!I53,IF(OR($C7=Details!$D54,AND($C7=\"Optimal\",Results!$E44=\"Y\")),Details!I54,Details!I55))","v":0},{"$f":"IF(OR($C7=Details!$D53,AND($C7=\"Optimal\",Results!$E43=\"Y\")),Details!J53,IF(OR($C7=Details!$D54,AND($C7=\"Optimal\",Results!$E44=\"Y\")),Details!J54,Details!J55))","v":0},{"$f":"IF(OR($C7=Details!$D53,AND($C7=\"Optimal\",Results!$E43=\"Y\")),Details!K53,IF(OR($C7=Details!$D54,AND($C7=\"Optimal\",Results!$E44=\"Y\")),Details!K54,Details!K55))","v":0},{"$f":"IF(OR($C7=Details!$D53,AND($C7=\"Optimal\",Results!$E43=\"Y\")),Details!L53,IF(OR($C7=Details!$D54,AND($C7=\"Optimal\",Results!$E44=\"Y\")),Details!L54,Details!L55))","v":0}]
[{"$f":"Details!C56","v":"4-Good"},1,"0-Do Minimum",{"$f":"IF(OR($C8=Details!$D56,AND($C8=\"Optimal\",Results!$E46=\"Y\")),Details!E56,IF(OR($C8=Details!$D57,AND($C8=\"Optimal\",Results!$E47=\"Y\")),Details!E57,Details!E58))","v":69},{"$f":"IF(OR($C8=Details!$D56,AND($C8=\"Optimal\",Results!$E46=\"Y\")),Details!F56,IF(OR($C8=Details!$D57,AND($C8=\"Optimal\",Results!$E47=\"Y\")),Details!F57,Details!F58))","v":7},{"$f":"IF(OR($C8=Details!$D56,AND($C8=\"Optimal\",Results!$E46=\"Y\")),Details!G56,IF(OR($C8=Details!$D57,AND($C8=\"Optimal\",Results!$E47=\"Y\")),Details!G57,Details!G58))","v":0},{"$f":"IF(OR($C8=Details!$D56,AND($C8=\"Optimal\",Results!$E46=\"Y\")),Details!H56,IF(OR($C8=Details!$D57,AND($C8=\"Optimal\",Results!$E47=\"Y\")),Details!H57,Details!H58))","v":0.95},{"$f":"IF(OR($C8=Details!$D56,AND($C8=\"Optimal\",Results!$E46=\"Y\")),Details!I56,IF(OR($C8=Details!$D57,AND($C8=\"Optimal\",Results!$E47=\"Y\")),Details!I57,Details!I58))","v":0.05},{"$f":"IF(OR($C8=Details!$D56,AND($C8=\"Optimal\",Results!$E46=\"Y\")),Details!J56,IF(OR($C8=Details!$D57,AND($C8=\"Optimal\",Results!$E47=\"Y\")),Details!J57,Details!J58))","v":0},{"$f":"IF(OR($C8=Details!$D56,AND($C8=\"Optimal\",Results!$E46=\"Y\")),Details!K56,IF(OR($C8=Details!$D57,AND($C8=\"Optimal\",Results!$E47=\"Y\")),Details!K57,Details!K58))","v":0},{"$f":"IF(OR($C8=Details!$D56,AND($C8=\"Optimal\",Results!$E46=\"Y\")),Details!L56,IF(OR($C8=Details!$D57,AND($C8=\"Optimal\",Results!$E47=\"Y\")),Details!L57,Details!L58))","v":0}]
[{"$f":"Details!C59","v":"3-Adequate"},0,"0-Do Minimum",{"$f":"IF(OR($C9=Details!$D59,AND($C9=\"Optimal\",Results!$E49=\"Y\")),Details!E59,IF(OR($C9=Details!$D60,AND($C9=\"Optimal\",Results!$E50=\"Y\")),Details!E60,Details!E61))","v":88},{"$f":"IF(OR($C9=Details!$D59,AND($C9=\"Optimal\",Results!$E49=\"Y\")),Details!F59,IF(OR($C9=Details!$D60,AND($C9=\"Optimal\",Results!$E50=\"Y\")),Details!F60,Details!F61))","v":14},{"$f":"IF(OR($C9=Details!$D59,AND($C9=\"Optimal\",Results!$E49=\"Y\")),Details!G59,IF(OR($C9=Details!$D60,AND($C9=\"Optimal\",Results!$E50=\"Y\")),Details!G60,Details!G61))","v":0},{"$f":"IF(OR($C9=Details!$D59,AND($C9=\"Optimal\",Results!$E49=\"Y\")),Details!H59,IF(OR($C9=Details!$D60,AND($C9=\"Optimal\",Results!$E50=\"Y\")),Details!H60,Details!H61))","v":0},{"$f":"IF(OR($C9=Details!$D59,AND($C9=\"Optimal\",Results!$E49=\"Y\")),Details!I59,IF(OR($C9=Details!$D60,AND($C9=\"Optimal\",Results!$E50=\"Y\")),Details!I60,Details!I61))","v":0.9},{"$f":"IF(OR($C9=Details!$D59,AND($C9=\"Optimal\",Results!$E49=\"Y\")),Details!J59,IF(OR($C9=Details!$D60,AND($C9=\"Optimal\",Results!$E50=\"Y\")),Details!J60,Details!J61))","v":0.1},{"$f":"IF(OR($C9=Details!$D59,AND($C9=\"Optimal\",Results!$E49=\"Y\")),Details!K59,IF(OR($C9=Details!$D60,AND($C9=\"Optimal\",Results!$E50=\"Y\")),Details!K60,Details!K61))","v":0},{"$f":"IF(OR($C9=Details!$D59,AND($C9=\"Optimal\",Results!$E49=\"Y\")),Details!L59,IF(OR($C9=Details!$D60,AND($C9=\"Optimal\",Results!$E50=\"Y\")),Details!L60,Details!L61))","v":0}]
[{"$f":"Details!C62","v":"2-Marginal"},0,"0-Do Minimum",{"$f":"IF(OR($C10=Details!$D62,AND($C10=\"Optimal\",Results!$E52=\"Y\")),Details!E62,IF(OR($C10=Details!$D63,AND($C10=\"Optimal\",Results!$E53=\"Y\")),Details!E63,Details!E64))","v":88},{"$f":"IF(OR($C10=Details!$D62,AND($C10=\"Optimal\",Results!$E52=\"Y\")),Details!F62,IF(OR($C10=Details!$D63,AND($C10=\"Optimal\",Results!$E53=\"Y\")),Details!F63,Details!F64))","v":28},{"$f":"IF(OR($C10=Details!$D62,AND($C10=\"Optimal\",Results!$E52=\"Y\")),Details!G62,IF(OR($C10=Details!$D63,AND($C10=\"Optimal\",Results!$E53=\"Y\")),Details!G63,Details!G64))","v":0},{"$f":"IF(OR($C10=Details!$D62,AND($C10=\"Optimal\",Results!$E52=\"Y\")),Details!H62,IF(OR($C10=Details!$D63,AND($C10=\"Optimal\",Results!$E53=\"Y\")),Details!H63,Details!H64))","v":0},{"$f":"IF(OR($C10=Details!$D62,AND($C10=\"Optimal\",Results!$E52=\"Y\")),Details!I62,IF(OR($C10=Details!$D63,AND($C10=\"Optimal\",Results!$E53=\"Y\")),Details!I63,Details!I64))","v":0},{"$f":"IF(OR($C10=Details!$D62,AND($C10=\"Optimal\",Results!$E52=\"Y\")),Details!J62,IF(OR($C10=Details!$D63,AND($C10=\"Optimal\",Results!$E53=\"Y\")),Details!J63,Details!J64))","v":0.9},{"$f":"IF(OR($C10=Details!$D62,AND($C10=\"Optimal\",Results!$E52=\"Y\")),Details!K62,IF(OR($C10=Details!$D63,AND($C10=\"Optimal\",Results!$E53=\"Y\")),Details!K63,Details!K64))","v":0.05},{"$f":"IF(OR($C10=Details!$D62,AND($C10=\"Optimal\",Results!$E52=\"Y\")),Details!L62,IF(OR($C10=Details!$D63,AND($C10=\"Optimal\",Results!$E53=\"Y\")),Details!L63,Details!L64))","v":4.9999999999999933E-2}]
[{"$f":"Details!C65","v":"1-Poor"},0,"0-Do Minimum",{"$f":"IF(OR($C11=Details!$D65,AND($C11=\"Optimal\",Results!$E55=\"Y\")),Details!E65,IF(OR($C11=Details!$D66,AND($C11=\"Optimal\",Results!$E56=\"Y\")),Details!E66,Details!E67))","v":88},{"$f":"IF(OR($C11=Details!$D65,AND($C11=\"Optimal\",Results!$E55=\"Y\")),Details!F65,IF(OR($C11=Details!$D66,AND($C11=\"Optimal\",Results!$E56=\"Y\")),Details!F66,Details!F67))","v":84},{"$f":"IF(OR($C11=Details!$D65,AND($C11=\"Optimal\",Results!$E55=\"Y\")),Details!G65,IF(OR($C11=Details!$D66,AND($C11=\"Optimal\",Results!$E56=\"Y\")),Details!G66,Details!G67))","v":0},{"$f":"IF(OR($C11=Details!$D65,AND($C11=\"Optimal\",Results!$E55=\"Y\")),Details!H65,IF(OR($C11=Details!$D66,AND($C11=\"Optimal\",Results!$E56=\"Y\")),Details!H66,Details!H67))","v":0},{"$f":"IF(OR($C11=Details!$D65,AND($C11=\"Optimal\",Results!$E55=\"Y\")),Details!I65,IF(OR($C11=Details!$D66,AND($C11=\"Optimal\",Results!$E56=\"Y\")),Details!I66,Details!I67))","v":0},{"$f":"IF(OR($C11=Details!$D65,AND($C11=\"Optimal\",Results!$E55=\"Y\")),Details!J65,IF(OR($C11=Details!$D66,AND($C11=\"Optimal\",Results!$E56=\"Y\")),Details!J66,Details!J67))","v":0},{"$f":"IF(OR($C11=Details!$D65,AND($C11=\"Optimal\",Results!$E55=\"Y\")),Details!K65,IF(OR($C11=Details!$D66,AND($C11=\"Optimal\",Results!$E56=\"Y\")),Details!K66,Details!K67))","v":0.9},{"$f":"IF(OR($C11=Details!$D65,AND($C11=\"Optimal\",Results!$E55=\"Y\")),Details!L65,IF(OR($C11=Details!$D66,AND($C11=\"Optimal\",Results!$E56=\"Y\")),Details!L66,Details!L67))","v":9.9999999999999978E-2}]
[{"$f":"Details!C68","v":"0-Failed"},0,{"$f":"Details!D68","v":"0-Replace"},{"$f":"Details!E68","v":1700},{"$f":"Details!F68","v":484},{"$f":"Details!G68","v":1},{"$f":"Details!H68","v":0},{"$f":"Details!I68","v":0},{"$f":"Details!J68","v":0},{"$f":"Details!K68","v":0},{"$f":"Details!L68","v":0}]
[]
["Predicted Conditions and Costs"]
[null,"Percent of Quantity by State",null,null,null,null,null,"Cost",null,null,"Disc. Cost",null,null,"Cum. Disc Cost"]
["Period",{"$f":"F6","v":"5-Excellent"},"4-Good","3-Adequate","2-Marginal","1-Poor","0-Failed","Agency","User","Total","Agency","User","Total","Agency","User","Total"]
[0,{"$f":"B7/(SUM($B$7:$B$12))","v":0.5},{"$f":"B8/SUM($B$7:$B$12)","v":0.5},{"$f":"B9/SUM($B$7:$B$12)","v":0},{"$f":"B10/SUM($B$7:$B$12)","v":0},{"$f":"B11/SUM($B$7:$B$12)","v":0},{"$f":"B12/SUM($B$7:$B$12)","v":0},{"$f":"($B17*D$7+$C17*D$8+$D17*D$9+$E17*D$10+$F17*D$11+$G17*D$12)*SUM($B$7:$B$12)","v":138},{"$f":"($B17*E$7+$C17*E$8+$D17*E$9+$E17*E$10+$F17*E$11+$G17*E$12)*SUM($B$7:$B$12)","v":7},{"$f":"H17+I17","v":145},{"$f":"H17*Results!$D$74^$A17","v":138},{"$f":"I17*Results!$D$74^$A17","v":7},{"$f":"K17+L17","v":145},{"$f":"K17","v":138},{"$f":"L17","v":7},{"$f":"N17+O17","v":145}]
[{"$f":"A17+1","v":1},{"$f":"$B17*F$7+$C17*F$8+$D17*F$9+$E17*F$10+$F17*F$11+$G17*F$12","v":0.47499999999999998},{"$f":"$B17*G$7+$C17*G$8+$D17*G$9+$E17*G$10+$F17*G$11+$G17*G$12","v":0.5},{"$f":"$B17*H$7+$C17*H$8+$D17*H$9+$E17*H$10+$F17*H$11+$G17*H$12","v":2.5000000000000001E-2},{"$f":"$B17*I$7+$C17*I$8+$D17*I$9+$E17*I$10+$F17*I$11+$G17*I$12","v":0},{"$f":"$B17*J$7+$C17*J$8+$D17*J$9+$E17*J$10+$F17*J$11+$G17*J$12","v":0},{"$f":"$B17*K$7+$C17*K$8+$D17*K$9+$E17*K$10+$F17*K$11+$G17*K$12","v":0},{"$f":"($B18*D$7+$C18*D$8+$D18*D$9+$E18*D$10+$F18*D$11+$G18*D$12)*SUM($B$7:$B$12)","v":138.95000000000002},{"$f":"($B18*E$7+$C18*E$8+$D18*E$9+$E18*E$10+$F18*E$11+$G18*E$12)*SUM($B$7:$B$12)","v":7.7},{"$f":"H18+I18","v":146.65},{"$f":"H18*Results!$D$74^$A18","v":129.85981308411218},{"$f":"I18*Results!$D$74^$A18","v":7.1962616822429908},{"$f":"K18+L18","v":137.05607476635515},{"$f":"N17+K18","v":267.85981308411215},{"$f":"O17+L18","v":14.196261682242991},{"$f":"N18+O18","v":282.05607476635515}]
[{"$f":"A18+1","v":2},0.45124999999999998,0.49874999999999997,4.7500000000000001E-2,2.5000000000000005E-3,0,0,139.89999999999998,8.4525000000000006,{"$f":"H19+I19","v":148.35249999999996},{"$f":"H19*Results!$D$74^$A19","v":122.19407808542229},{"$f":"I19*Results!$D$74^$A19","v":7.3827408507293217},{"$f":"K19+L19","v":129.57681893615162},{"$f":"N18+K19","v":390.05389116953444},{"$f":"O18+L19","v":21.579002532972311},{"$f":"N19+O19","v":411.63289370250675}]
[3,0.42868749999999994,0.49637499999999996,6.7687500000000012E-2,7.000000000000001E-3,1.2500000000000003E-4,1.2499999999999987E-4,141.25062499999999,9.3785000000000007,150.62912499999999,{"$f":"H20*Results!$D$74^$A20","v":115.30258529700589},{"$f":"I20*Results!$D$74^$A20","v":7.6556496384208561},122.95823493542674,505.35647646654036,29.234652171393165,534.59112863793348]
[4,0.40737812499999992,0.49299062499999996,8.5737500000000022E-2,1.3068750000000002E-2,4.6250000000000007E-4,3.6249999999999954E-4,142.95468749999998,10.46296875,153.41765624999996,{"$f":"H21*Results!$D$74^$A21","v":109.0594466335002},{"$f":"I21*Results!$D$74^$A21","v":7.9821487631778805},117.04159539667808,614.41592310004057,37.216800934571047,651.63272403461167]
[5,0.38737171874999987,0.48870999999999992,0.10181328125000001,2.0335625000000003E-2,1.0696875000000003E-3,6.9968749999999925E-4,144.96468718749998,11.688511875,156.65319906249997,{"$f":"H22*Results!$D$74^$A22","v":103.35781847786072},{"$f":"I22*Results!$D$74^$A22","v":8.3337474256057398},111.69156590346645,717.77374157790132,45.550548360176791,763.3242899380781]
[6,0.36870282031249985,0.48364308593749994,0.11606745312500001,2.8483390625000007E-2,1.9795000000000004E-3,1.1237499999999989E-3,147.23382556249999,13.036307765624997,160.27013332812498,{"$f":"H23*Results!$D$74^$A23","v":98.108114746328752},{"$f":"I23*Results!$D$74^$A23","v":8.6866423069030336},106.79475705323179,815.88185632423006,54.237190667079823,870.11904699130992]
[7,0.35139142929687484,0.47789607265624989,0.12864286210937501,3.7241796875000011E-2,3.2057195312500007E-3,1.6221195312499984E-3,149.71678829453123,14.486858368749996,164.20364666328123,{"$f":"H24*Results!$D$74^$A24","v":93.2360912662093},{"$f":"I24*Results!$D$74^$A24","v":9.0216873098576897},102.25777857606698,909.11794759043937,63.258877976937512,972.37682556737684]
[8,0.33544397736328108,0.47157084048828113,0.13967337953125,4.6381903398437507E-2,4.7472374218750016E-3,2.1826617968749981E-3,152.3703385547656,16.020585490273433,168.39092404503901,{"$f":"H25*Results!$D$74^$A25","v":88.680924304530905},{"$f":"I25*Results!$D$74^$A25","v":9.3241266158016902},98.005050920332593,997.79887189497026,72.583004592739201,1070.3818764877094]
[9,0.320854440291992,0.46476449733203112,0.14928458360253907,5.5711051011718755E-2,6.5916088496093773E-3,2.7938189121093724E-3,155.15375254292772,17.618297153832025,172.77204969675975,{"$f":"H26*Results!$D$74^$A26","v":84.393361296649488},{"$f":"I26*Results!$D$74^$A26","v":9.5831863088435014},93.976547605492982,1082.1922331916198,82.166190901582695,1164.3584240932025]
[10,0.30760553718950179,0.45756899448002913,0.15759435010888673,6.5068404270800795E-2,8.7180005152343778E-3,3.4447134355468719E-3,158.02912391276089,19.261545057102829,177.29066896986373,{"$f":"H27*Results!$D$74^$A27","v":80.333993277721646},{"$f":"I27*Results!$D$74^$A27","v":9.7915927951992003},90.125586072920839,1162.5262264693415,91.957783696781888,1254.4840101661234]
[11,0.29566997376557352,0.45007082161550271,0.16471336482199953,7.4320998854609382E-2,1.109962067725098E-2,4.1252202650634727E-3,160.96155991008365,20.932891143850757,181.8944510539344,{"$f":"H28*Results!$D$74^$A28","v":76.471677608589744},{"$f":"I28*Results!$D$74^$A28","v":9.9450657900090089},86.416743398598754,1238.9979040779313,101.9028494867909,1340.9007535647222]
[12,0.28501169534235832,0.4423507792230062,0.17074556942057473,8.3360235451348394E-2,1.3705708552256352E-2,4.8260120104555619E-3,163.91928868822478,22.616098701073742,186.53538738929853,{"$f":"H29*Results!$D$74^$A29","v":72.782124527806417},{"$f":"I29*Results!$D$74^$A29","v":10.041818294645605},82.823942822452025,1311.7800286057377,111.94466778143651,1423.7246963871742]
[13,0.27558712258569595,0.43448382502897381,0.17578855143966757,9.2098768848271034E-2,1.6503149469598136E-2,5.5385826277930487E-3,166.87369438264724,24.296261140815663,191.1699555234629,{"$f":"H30*Results!$D$74^$A30","v":69.246650456615811},{"$f":"I30*Results!$D$74^$A30","v":10.082084590054308},79.328735046670118,1381.0266790623534,122.02675237149082,1503.0534314338443]
[14,0.26734634908420418,0.42653898990680994,0.17993388754714951,0.10046774710741069,1.9457772965051877E-2,6.2552533893733588E-3,169.79929404568111,25.95987968707265,195.75917373275377,{"$f":"H31*Results!$D$74^$A31","v":65.851093743485563},{"$f":"I31*Results!$D$74^$A31","v":10.067688917382215},75.918782660867777,1446.877772805839,132.09444128887304,1578.9722140947119]
[15,0.26023428501936735,0.41857935786567962,0.18326744828777505,0.10841436115138457,2.2535383023917225E-2,6.9691646518757148E-3,172.67366840801546,27.594899517688543,200.26856792570399,{"$f":"H32*Results!$D$74^$A32","v":62.584883811529899},{"$f":"I32*Results!$D$74^$A32","v":10.001661492617087},72.586545304146981,1509.4626566173688,142.09610278149012,1651.5587593988589]
[16,0.25419173542027468,0.41066210422336397,0.18586967135228155,0.11589966986502363,2.5702562779094731E-2,7.6742563599609438E-3,175.47735659805571,29.19071247276241,204.66806907081812,{"$f":"H33*Results!$D$74^$A33","v":59.440251809652615},{"$f":"I33*Results!$D$74^$A33","v":9.8879042488573141},69.328156058509933,1568.9029084270214,151.98400703034744,1720.8869154573688]
[17,0.24915640500922187,0.40283858578320952,0.1878158094282216,0.12289667001374943,2.8927289994436441E-2,8.3652397711606458E-3,178.19372337210945,30.738133203273932,208.93185657538339,{"$f":"H34*Results!$D$74^$A34","v":56.41156936105584},{"$f":"I34*Results!$D$74^$A34","v":9.7309057828310763},66.142475143886912,1625.3144777880773,161.71491281317853,1787.0293906012557]
[18,0.24506382452992143,0.39515447674451015,0.18917615777455993,0.12938858395519665,3.2179394495680268E-2,9.0375625001311074E-3,180.80880605199422,32.229354569003029,213.03816062099725,{"$f":"H35*Results!$D$74^$A35","v":53.49480146397535},{"$f":"I35*Results!$D$74^$A35","v":9.5355030633026399},63.030304527277991,1678.8092792520526,171.25041587648116,1850.0596951285338]
[19,0.24184819580355646,0.38764994413378073,0.19001626583432946,0.13536734133713299,3.5430884243872078E-2,9.6873686473278493E-3,183.31114720136611,33.657887179697468,216.96903438106358,{"$f":"H36*Results!$D$74^$A36","v":50.687059734954396},{"$f":"I36*Results!$D$74^$A36","v":9.3066862767250598},59.993746011679455,1729.496338987007,180.55710215320622,1910.0534411402132]
[20,0.23944315466070648,0.38035985671726952,0.19039713645758555,0.14083223378685264,3.8656162886341522E-2,1.0311455491243848E-2,185.69161807140702,35.018487187347333,220.71010525875437,{"$f":"H37*Results!$D$74^$A37","v":47.986242772906806},{"$f":"I37*Results!$D$74^$A37","v":9.0494425390045432},57.035685311911351,1777.4825817599137,189.60654469221075,1967.0891264521244]
[21,0.23778245241891499,0.37331402161444138,0.19037541564769048,0.14578872405392596,4.1832158287050003E-2,1.0907227977976774E-2,187.94323698772951,36.307075762663281,224.25031275039279,{"$f":"H38*Results!$D$74^$A38","v":45.390751297177289},{"$f":"I38*Results!$D$74^$A38","v":8.7686339380140499},54.159385235191337,1822.873333057091,198.37517863022481,2021.2485116873158]
[22,0.236800557775946,0.36653744315466508,0.1900035751636435,0.15024739321330241,4.4938378661041306E-2,1.1472652031401288E-2,190.06098611387443,37.520653110143648,227.58163922401809,{"$f":"H39*Results!$D$74^$A39","v":42.899266752876244},{"$f":"I39*Results!$D$74^$A39","v":8.4689053730879635},51.368172125964207,1865.7725998099672,206.84408400331279,2072.6166838132799]
[23,0.23643318191854998,0.3600505988857291,0.18933008980501242,0.1542230114083365,4.7956910455602297E-2,1.2006207526769241E-2,192.04162939574138,38.657209380261207,230.69883877600259,{"$f":"H40*Results!$D$74^$A40","v":40.510583193567946},{"$f":"I40*Results!$D$74^$A40","v":8.1546178375894058},48.665201031157352,1906.2831830035352,214.99870184090219,2121.2818848444376]
[24,0.23661773034939171,0.35386972803737016,0.18839961076879763,0.15773371924800408,5.0872369980458895E-2,1.2506841615977043E-2,193.88353395121294,39.715634412920615,233.59916836413356,{"$f":"H41*Results!$D$74^$A41","v":38.223483382209373},{"$f":"I41*Results!$D$74^$A41","v":7.8298030836294066},46.053286465838781,1944.5066663857447,222.82850492453159,2167.3351713102761]
[25,0.23729368544789914,0.34800712815297125,0.18725313609378638,0.16080030840008344,5.367181894481321E-2,1.2973922960446083E-2,195.58649670764501,40.695627883612715,236.28212459125774,{"$f":"H42*Results!$D$74^$A42","v":36.036651152839852},{"$f":"I42*Results!$D$74^$A42","v":7.498135966306771},43.534787119146621,1980.5433175385845,230.32664089083835,2210.8699584294227]
[26,0.23840292413595027,0.34247145601771761,0.18592817889205632,0.16344559116945373,5.6344652470336064E-2,1.3407197314485482E-2,197.15157769606174,41.597611114153437,238.74918881021517,{"$f":"H43*Results!$D$74^$A43","v":33.948613119356381},{"$f":"I43*Results!$D$74^$A43","v":7.1629211538997675},41.111534273256147,2014.4919306579409,237.48956204473811,2251.9814927026791]
[27,0.23988997524363823,0.33726802942362921,0.18445893380373657,0.16569384994171399,5.8882466781775146E-2,1.3806744805506281E-2,198.58094107559597,42.422641546239717,241.00358262183568,{"$f":"H44*Results!$D$74^$A44","v":31.957703786156799},{"$f":"I44*Results!$D$74^$A44","v":6.8270912858900044},38.784795072046805,2046.4496344440977,244.3166533306281,2290.7662877747257]
[28,0.24170222128696259,0.33239912671462962,0.18287644189454438,0.16757035832791625,6.1278912600683334E-2,1.4172939175263202E-2,199.87770467698795,43.17233065198495,243.05003532897291,{"$f":"H45*Results!$D$74^$A45","v":30.062048998907116},{"$f":"I45*Results!$D$74^$A45","v":6.4932140458305625},36.555263044737679,2076.5116834430046,250.80986737645867,2327.3215508194635]
[29,0.24379004939787763,0.32786428144324625,0.18120875404082143,0.16910096668457908,6.3529539257010811E-2,1.4506409176464133E-2,201.04579861295753,43.848765865679972,244.89456447863751,{"$f":"H46*Results!$D$74^$A46","v":28.259563468414342},{"$f":"I46*Results!$D$74^$A46","v":6.1635059799402327},34.423069448354575,2104.771246911419,256.97337335639889,2361.7446202678179]
[30,0.24610695610444788,0.3236605698409778,0.17948109270890161,0.1703117454202033,6.5631633665538688E-2,1.4808002259930023E-2,202.08983330008812,44.454436960577084,246.5442702606652,{"$f":"H47*Results!$D$74^$A47","v":26.547958806884232},{"$f":"I47*Results!$D$74^$A47","v":5.8398512282414634},32.387810035125696,2131.3192057183032,262.81322458464035,2394.1324303029437]
[31,0.24860961055915548,0.31978288915415132,0.17771601193006034,0.17122868014907314,6.7584057569994985E-2,1.5078750637564021E-2,203.0149770664006,44.992167159469034,248.00714422586964,{"$f":"H48*Results!$D$74^$A48","v":24.924759136839477},{"$f":"I48*Results!$D$74^$A48","v":5.5238236395110869},30.448582776350563,2156.2439648551426,268.33704822415143,2424.5810130792943]
[32,0.2512578806687617,0.31622422522440147,0.17593355519476189,0.17187741332717185,6.938708582044914E-2,1.5319839764453141E-2,203.8268433766566,45.465049154742672,249.29189253139927,{"$f":"H49*Results!$D$74^$A49","v":23.38732187362347},{"$f":"I49*Results!$D$74^$A49","v":5.2167110129708032},28.604032886594275,2179.6312867287661,273.55375923712222,2453.1850459658881]
[33,0.25401482639977674,0.31297590799661945,0.17415141093650577,0.17228302751393085,7.1042247904762823E-2,1.5532579248403493E-2,204.53138758978963,45.876386119409695,250.40777370919932,{"$f":"H50*Results!$D$74^$A50","v":21.932861748770243},{"$f":"I50*Results!$D$74^$A50","v":4.9195404487660426},26.852402197536286,2201.5641484775365,278.47329968588826,2480.0374481634249]
[34,0.25684666432819137,0.31002785391677729,0.17238506524268615,0.17246986585618834,7.2552174489983093E-2,1.5718376166172811E-2,205.13481306643217,46.229637712749081,251.36445077918125,{"$f":"H51*Results!$D$74^$A51","v":20.558476540207742},{"$f":"I51*Results!$D$74^$A51","v":4.6331039971848558},25.191580537392596,2222.1226250177442,283.1064036830731,2505.2290287008173]
[35,0.2597227072779546,0.30736879443734799,0.1706479514142564,0.17246138579483813,7.3920450333794199E-2,1.5878710741807713E-2,205.64348636640639,46.528371020380277,252.17185738678666,{"$f":"H52*Results!$D$74^$A52","v":19.261173313080732},{"$f":"I52*Results!$D$74^$A52","v":4.3579839752476985},23.619157288328431,2241.3837983308249,287.46438765832079,2528.8481859891458]
[36,0.26261528265586453,0.30498649007937834,0.16895159599469817,0.17228004235677996,7.5151474590156683E-2,1.6015114323121315E-2,206.0638612138037,46.776216316870283,252.84007753067399,{"$f":"H53*Results!$D$74^$A53","v":18.03789425865137},{"$f":"I53*Results!$D$74^$A53","v":4.094577471146545},22.132471729797913,2259.4216925894762,291.55896512946731,2550.9806577189433]
[37,0.2654996328461926,0.30286792970820264,0.1673057608991973,0.17194719772057179,7.6250329248980009E-2,1.6129149576854653E-2,206.40241085871219,46.976827497668332,253.37923835638051,{"$f":"H54*Results!$D$74^$A54","v":16.885541454700224},{"$f":"I54*Results!$D$74^$A54","v":3.843119684610496},20.72866113931072,2276.3072340441763,295.4020848140778,2571.7093188582539]
[38,0.26835380078073756,0.30099951486510212,0.16571858129468769,0.17148305403843436,7.7222656210110596E-2,1.6222392810926578E-2,206.66556842788515,47.133846994790517,253.79941542267568,{"$f":"H55*Results!$D$74^$A55","v":15.801000065162761},{"$f":"I55*Results!$D$74^$A55","v":3.6037058572528364},19.404705922415598,2292.1082341093393,299.00579067133066,2591.1140247806698]
[{"$f":"A55+1","v":39},{"$f":"$B55*F$7+$C55*F$8+$D55*F$9+$E55*F$10+$F55*F$11+$G55*F$12","v":0.27115850355262727},{"$f":"$B55*G$7+$C55*G$8+$D55*G$9+$E55*G$10+$F55*G$11+$G55*G$12","v":0.29936722916088387},{"$f":"$B55*H$7+$C55*H$8+$D55*H$9+$E55*H$10+$F55*H$11+$G55*H$12","v":0.16419669890847405},{"$f":"$B55*I$7+$C55*I$8+$D55*I$9+$E55*I$10+$F55*I$11+$G55*I$12","v":0.17090660676405969},{"$f":"$B55*J$7+$C55*J$8+$D55*J$9+$E55*J$10+$F55*J$11+$G55*J$12","v":7.8074543291021259E-2},{"$f":"$B55*K$7+$C55*K$8+$D55*K$9+$E55*K$10+$F55*K$11+$G55*K$12","v":1.6296418322932764E-2},206.85967483002162,47.250874965967476,{"$f":"H56+I56","v":254.1105497959891},{"$f":"H56*Results!$D$74^$A56","v":14.781159654982583},{"$f":"I56*Results!$D$74^$A56","v":3.3763116338816879},{"$f":"K56+L56","v":18.157471288864272},{"$f":"N55+K56","v":2306.889393764322},{"$f":"O55+L56","v":302.38210230521236},{"$f":"N56+O56","v":2609.2714960695344}]
[40,0.27389699669792866,0.29795679288047106,0.16274539047567085,0.17023561597850112,7.8812419300122116E-2,1.6352784667305095E-2,206.99093376341222,47.331442528813291,254.3223762922255,{"$f":"H57*Results!$D$74^$A57","v":13.822933423436371},{"$f":"I57*Results!$D$74^$A57","v":3.160811766078607},16.983745189514977,2320.7123271877585,305.54291407129097,2626.2552412590494]
[41,0.27655493153033733,0.29675380307134391,0.16136869107212731,0.16948659342821812,7.9442958169034975E-2,1.6393022728937254E-2,207.06537336322964,47.378988799007729,254.44436216223738,{"$f":"H58*Results!$D$74^$A58","v":12.923275260069913},{"$f":"I58*Results!$D$74^$A58","v":2.9569971253439706},15.880272385413884,2333.6356024478287,308.49991119663491,2642.1355136444636]
[42,0.27912020768275775,0.29574385949429355,0.16006951211848178,0.16867480319260905,7.9972992023542383E-2,1.6418625488314388E-2,207.08881402159747,47.396841483667153,254.48565550526462,{"$f":"H59*Results!$D$74^$A59","v":12.079194605967212},{"$f":"I59*Results!$D$74^$A59","v":2.764590036860644},14.843784642827856,2345.7147970537958,311.26450123349554,2656.9792982872914]
[43,0.28158282278693425,0.29491267690371675,0.15884975388134828,0.16781427408519631,8.040943298081861E-2,1.643103936198468E-2,207.06684191479366,47.388200777279479,254.45504269207314,{"$f":"H60*Results!$D$74^$A60","v":11.287769162966354},{"$f":"I60*Results!$D$74^$A60","v":2.5832579783215288},13.871027141287883,2357.0025662167623,313.84775921181705,2670.8503254285793]
[44,0.28393472100957223,0.29424618419787762,0.1577104123383993,0.16691782206481151,8.0759203386996561E-2,1.6431657002341664E-2,207.00478777766622,47.356126307157062,254.36091408482329,{"$f":"H61*Results!$D$74^$A61","v":10.546155537799391},{"$f":"I61*Results!$D$74^$A61","v":2.4126257129828326},12.958781250782224,2367.5487217545615,316.26038492479989,2683.8091066793613]
[45,0.28616964196143529,0.29373061103846232,0.15665168031445326,0.16599708109217029,8.1029174151537486E-2,1.6421811441940218E-2,206.907710474819,47.303526877761129,254.21123735258013,{"$f":"H62*Results!$D$74^$A62","v":9.8515979397199498},{"$f":"I62*Results!$D$74^$A62","v":2.2522859436268017},12.103883883346752,2377.4003196942813,318.51267086842671,2695.9129905627078]
[46,0.28828297130530373,0.29335256258461095,0.15567304283493105,0.1650625410143986,8.1226110790992262E-2,1.6402771469762253E-2,206.78038493069656,47.233152767985509,254.01353769868206,{"$f":"H63*Results!$D$74^$A63","v":9.2014350713649762},{"$f":"I63*Results!$D$74^$A63","v":2.1018085857425217},11.303243657107497,2386.6017547656461,320.61447945416921,2707.2162342198153]
[47,0.29027159420980081,0.29309908302064558,0.15477336668066852,0.16412359119645184,8.135662676261296E-2,1.6375738129819142E-2,206.62729399577975,47.147590342132965,253.77488433791271,{"$f":"H64*Results!$D$74^$A64","v":8.5931053654092313},{"$f":"I64*Results!$D$74^$A64","v":1.9607487650850914},10.553854130494322,2395.1948601310555,322.57522821925431,2717.7700883503098]
[48,0.29213375262912988,0.29295770858010334,0.15395098416363392,0.16318856874487353,8.142714364617426E-2,1.6341842236083877E-2,206.45262384318335,47.049258743502584,253.50188258668592,{"$f":"H65*Results!$D$74^$A65","v":8.0241507257425759},{"$f":"I65*Results!$D$74^$A65","v":1.8286536478174764},9.852804373560053,2403.2190108567979,324.40388186707179,2727.6228927238699]
[49,0.29386890723375725,0.29291651078255465,0.1532037711762757,0.16226481028674958,8.1443857718800514E-2,1.630214280186109E-2,206.26026250858013,46.94040844890948,253.20067095748959,{"$f":"H66*Results!$D$74^$A66","v":7.4922189328907782},{"$f":"I66*Results!$D$74^$A66","v":1.7050682114976758},9.1972871443884543,2410.7112297896888,326.10895007856948,2736.8201798682585]
[50,0.29547760467393047,0.29296413060511478,0.15252921959777588,0.16135870637570218,8.1412712461257947E-2,1.6257626286217519E-2,206.05380120616132,46.823121472798547,252.87692267895989,{"$f":"H67*Results!$D$74^$A67","v":6.9950648704332385},{"$f":"I67*Results!$D$74^$A67","v":1.5895400629406478},8.5846049333738854,2417.7062946601222,327.69849014151015,2745.4047848016326]
[51,0.29696135072645147,0.29308980430855558,0.15192450416825404,0.16047575769790956,8.1339376533917263E-2,1.6209206564910893E-2,205.83653807394222,46.699313020645668,252.53585109458788,{"$f":"H68*Results!$D$74^$A68","v":6.5305507232620066},{"$f":"I68*Results!$D$74^$A68","v":1.4816234050402746},8.0121741283022807,2424.2368453833842,329.18011354655044,2753.4169589299345]
[52,0.29832248975503978,0.29328338162945033,0.15138654396685641,0.159620632344944,8.122922676542102E-2,1.615772553828719E-2,205.61148402282709,46.57073440285388,252.18221842568096,{"$f":"H69*Results!$D$74^$A69","v":6.0966452905119484},{"$f":"I69*Results!$D$74^$A69","v":1.3808822494628772},7.477527539974826,2430.333490673896,330.56099579601334,2760.8944864699092]
[53,0.299564090805575,0.29353533703572976,0.15091205865164331,0.15879722350713524,8.1087335706126112E-2,1.6103954293789288E-2,205.38137038520688,46.438977032163017,251.8203474173699,{"$f":"H70*Results!$D$74^$A70","v":5.6914225465542723},{"$f":"I70*Results!$D$74^$A70","v":1.2868929661149333},6.9783155126692051,2436.0249132204503,331.84788876212826,2767.8728019825785]
[54,0.30068984055908554,0.29383677472422204,0.15049761963826547,0.15800870702158604,8.091846331087027E-2,1.6048594745969362E-2,205.1486580802393,46.305477339543906,251.4541354197832,{"$f":"H71*Results!$D$74^$A71","v":5.3130595731336756},{"$f":"I71*Results!$D$74^$A71","v":1.1992462537637538},6.5123058268974292,2441.337972793584,333.04713501589202,2774.3851078094758]
[55,0.30170394327710059,0.29417942801596519,0.15013969641065003,0.15725759828325397,8.0727052330862553E-2,1.5992281682166317E-2,204.91554803416747,46.171522455505837,251.08707048967329,{"$f":"H72*Results!$D$74^$A72","v":4.9598339749808469},{"$f":"I72*Results!$D$74^$A72","v":1.1175486094067646},6.0773825843876113,2446.2978067685649,334.16468362529878,2780.4624903938638]
[56,0.30261102779541188,0.29455565377902193,0.14983469817038331,0.15654580809599358,8.0517227011938988E-2,1.5935585147248941E-2,204.68399261490188,46.038256515595407,250.72224913049729,{"$f":"H73*Results!$D$74^$A73","v":4.630120880388592},{"$f":"I73*Results!$D$74^$A73","v":1.0414233671442721},5.6715442475328643,2450.9279276489533,335.20610699244304,2786.1340346413963]
[57,0.30341606155289025,0.29495842247984144,0.14957901104229607,0.15587469710343255,8.0292794715544777E-2,1.5879013105993565E-2,204.45570786047921,45.906687460507584,250.36239532098679,{"$f":"H74*Results!$D$74^$A74","v":4.3223896175641041},{"$f":"I74*Results!$D$74^$A74","v":0.97051137056767689},5.2929009881317812,2455.2503172665174,336.17661836301073,2791.4269356295281]
[58,0.30412427158123928,0.29538130443349386,0.14936903106205854,0.15524512849731892,8.0057250099161925E-2,1.5823014326726094E-2,204.23218630080481,45.777694212586475,250.00988051339129,{"$f":"H75*Results!$D$74^$A75","v":4.035200147258128},{"$f":"I75*Results!$D$74^$A75","v":0.90447133614726716},4.9396714834053954,2459.2855174137753,337.08108969915799,2796.3666071129333]
[59,0.30474107232890341,0.29581845279088115,0.14920119317752739,0.15465751875379288,7.9813781514111684E-2,1.5767981434782127E-2,204.01471019118551,45.652034121495369,249.66674431268089,{"$f":"H76*Results!$D$74^$A76","v":3.767199322365713},{"$f":"I76*Results!$D$74^$A76","v":0.84297995887624078},4.6101792812419538,2463.0527167361411,337.92406965803423,2800.9767863941752]
[60,0.30527200014724037,0.29626458376778225,0.14907199649931874,0.15411188619616634,7.956527930039016E-2,1.57142540891008E-2,203.8043649944899,45.530350582430309,249.33471557692022,{"$f":"H77*Results!$D$74^$A77","v":3.5171170359900774},{"$f":"I77*Results!$D$74^$A77","v":0.7857318055596888},4.3028488415497659,2466.569833772131,338.70980146359392,2805.279635235725]
[61,0.30572265422897915,0.29671495458675518,0.14897802603777599,0.15360789722648158,7.9314345680159465E-2,1.566212223984732E-2,203.60205296626964,45.413180740394267,249.01523370666391,{"$f":"H78*Results!$D$74^$A78","v":3.2837623109220151},{"$f":"I78*Results!$D$74^$A78","v":0.73243903566680468},4.0162013465888196,2469.8535960830532,339.44224049926072,2809.2958365823138]
[62,0.3060986437573775,0.29716533956886637,0.14891597116333616,0.15314491010761103,7.9063305973467599E-2,1.5611829429340012E-2,203.40850671379471,45.300963203707447,248.70946991750216,{"$f":"H79*Results!$D$74^$A79","v":3.0660193756445722},{"$f":"I79*Results!$D$74^$A79","v":0.68283098461245129},3.7488503602570233,2472.9196154586975,340.12507148387317,2813.0446869425705]
[63,0.30640554099884865,0.29761200477829192,0.14888264102544585,0.15272201621318354,7.881422088150139E-2,1.55635761027273E-2,203.22430261566123,45.194045699079112,248.41834831474034,{"$f":"H80*Results!$D$74^$A80","v":2.862843764836327},{"$f":"I80*Results!$D$74^$A80","v":0.63665363970778299},3.4994974045441101,2475.7824592235338,340.76172512358096,2816.5441843471149]
[64,0.30664884005163351,0.29805168158931972,0.14887497716181589,0.1523380786944098,7.8568899604010423E-2,1.5517522898809304E-2,203.04987400340474,45.092692609189427,248.14256661259418,{"$f":"H81*Results!$D$74^$A81","v":2.6732584759088915},{"$f":"I81*Results!$D$74^$A81","v":0.59366903481579392},3.2669275107246856,2478.4557176994426,341.35539415839673,2819.8111118578395]
[65,0.30683392094786111,0.29848153951243539,0.14889006352510029,0.1519917685411504,7.832891357832987E-2,1.547379389512152E-2,{"$f":"($B82*D$7+$C82*D$8+$D82*D$9+$E82*D$10+$F82*D$11+$G82*D$12)*SUM($B$7:$B$12)","v":202.88552402038025},{"$f":"($B82*E$7+$C82*E$8+$D82*E$9+$E82*E$10+$F82*E$11+$G82*E$12)*SUM($B$7:$B$12)","v":44.997092341818373},247.88261636219863,{"$f":"H82*Results!$D$74^$A82","v":2.4963502073543831},{"$f":"I82*Results!$D$74^$A82","v":0.55365458595537353},3.0500047933097565,2480.9520679067969,341.90904874435211,2822.8611166511491]
[66,0.3069660187955896,0.29889915858420668,0.14892513414821201,0.1516815980395454,7.8095610647554409E-2,1.5432479784890495E-2,202.73143808605445,44.907364487106513,247.63880257316097,{"$f":"H83*Results!$D$74^$A83","v":2.3312656995663921},{"$f":"I83*Results!$D$74^$A83","v":0.51640238669978056},2.8476680862661725,2483.2833336063632,342.42545113105189,2825.708784737415]
[67,0.30705019764070057,0.29930250159477578,0.14897757866260114,0.15140595165041207,7.7870129484776229E-2,1.5393640966732699E-2,202.58769590579786,44.823566726542431,247.41126263234028,{"$f":"H84*Results!$D$74^$A84","v":2.1772081942961727},{"$f":"I84*Results!$D$74^$A84","v":0.48171847919129485},2.6589266734874677,2485.4605418006595,342.90716961024316,2828.3677114109028]
[68,0.30709132872539824,0.299689886397072,0.14904494587607983,0.15116311435163096,7.7653414118819208E-2,1.5357310530998215E-2,202.45428297728409,44.745701463748475,247.19998444103257,{"$f":"H85*Results!$D$74^$A85","v":2.0334340249733005},{"$f":"I85*Results!$D$74^$A85","v":0.44942211391938197},2.4828561388926826,2487.4939758256328,343.35659172416251,2830.8505675497954]
[69,0.30709407282012652,0.30005995851348832,0.14912494560832545,0.15095129750407585,7.7446228424518843E-2,1.5323497129463457E-2,202.33110155471257,44.67372215308999,247.00482370780256,{"$f":"H86*Results!$D$74^$A86","v":1.8992493467127933},{"$f":"I86*Results!$D$74^$A86","v":0.41934500905952693},2.3185943557723201,2489.3932251723454,343.77593673322207,2833.1691619055673]
[70,0.30706286630858365,0.30041166422882021,0.14921544897316733,0.15076866231450081,7.7249170457270755E-2,1.5292187717655665E-2,202.21798104130022,44.607539307576381,246.82552034887661,{"$f":"H87*Results!$D$74^$A87","v":1.7740070119042155},{"$f":"I87*Results!$D$74^$A87","v":0.39133061811783876},2.1653376300220541,2491.1672321842498,344.16726735133989,2835.3344995355897]
[71,0.30700191071081012,0.3007442243328084,0.1493144872872916,0.15061334098036747,7.706268652726872E-2,1.5263350161452104E-2,202.11468778886382,44.547026172470844,246.66171396133467,{"$f":"H88*Results!$D$74^$A88","v":1.6571035947878325},{"$f":"I88*Results!$D$74^$A88","v":0.36523341284638888},2.0223370076342215,2492.8243357790375,344.5325007641863,2837.3568365432238]
[72,0.3069151653367217,0.30105710865170848,0.14942024977520288,0.15048345561105986,7.6887084923560223E-2,1.5236935701745235E-2,202.02093429086602,44.492024055496458,246.5129583463625,{"$f":"H89*Results!$D$74^$A89","v":1.5479765663251297},{"$f":"I89*Results!$D$74^$A89","v":0.34091818686038228},1.888894753185512,2494.3723123453624,344.87341895104669,2839.2457312964088]
[73,0.30680634277163082,0.30135001148595914,0.14953108023026801,0.15037713502747416,7.6722549211757196E-2,1.5212881272909002E-2,201.93638776206987,44.442347308540604,246.37873507061047,{"$f":"H90*Results!$D$74^$A90","v":1.4461016189242277},{"$f":"I90*Results!$D$74^$A90","v":0.31825938407592425},1.764361003000152,2495.8184139642867,345.19167833512262,2841.0100922994093]
[74,0.30667890690595828,0.30162282805024271,0.14964547278153917,0.15029252954775355,7.6569151041955177E-2,1.5191111672549416E-2,201.86067810396338,44.397787959336995,246.25846606330038,{"$f":"H91*Results!$D$74^$A91","v":1.350990139145408},{"$f":"I91*Results!$D$74^$A91","v":0.29714045497281688},1.6481305941182249,2497.169404103432,345.48881879009542,2842.6582228935276]
[75,0.3065360732332098,0.30187563199302847,0.14976206690589738,0.15022782387113209,7.6426862415147345E-2,1.5171541581583185E-2,201.79340526042682,44.358119994768195,246.15152525519503,{"$f":"H92*Results!$D$74^$A92","v":1.2621868253510982},{"$f":"I92*Results!$D$74^$A92","v":0.2774532427483607},1.5396400680994589,2498.431590928783,345.7662720328438,2844.1978629616269]
[76,0.30638081115313248,0.30210865405503756,0.14987964181495905,0.15018124817460862,7.6295567367189218E-2,1.5154077435071328E-2,201.73414597275919,44.323103300204295,246.05724927296347,{"$f":"H93*Results!$D$74^$A93","v":1.1792674463440551},{"$f":"I93*Results!$D$74^$A93","v":0.25909740064497411},1.4383648469890291,2499.610858375127,346.02536943348878,2845.6362278086158]
[77,0.30621584803054713,0.30232226190994232,0.14999711033621504,0.15015108753864365,7.6175073039200736E-2,1.5138619145449343E-2,201.68245994718978,44.292487261697943,245.97494720888773,{"$f":"H94*Results!$D$74^$A94","v":1.101836736325454},{"$f":"I94*Results!$D$74^$A94","v":0.24197984108754433},1.3438165774129982,2500.7126951114524,346.2673492745763,2846.9800443860286]
[78,0.30604367477446909,0.3025169412159725,0.15011351239809068,0.15013568981840078,7.606512011221285E-2,1.5125061680852245E-2,201.6378954514305,44.26601403991733,245.90390949134783,{"$f":"H95*Results!$D$74^$A95","v":1.0295264209725565},{"$f":"I95*Results!$D$74^$A95","v":0.22601421673841279},1.2555406377109692,2501.742221532425,346.49336349131471,2848.2355850237395]
[79,0.30586655271659791,0.30269327789389733,0.15022800821908022,0.15013347207636976,7.596539259191161E-2,1.5113296502141313E-2,201.59999435970445,44.243421526439462,245.84341588614393,{"$f":"H96*Results!$D$74^$A96","v":0.96199336905749777},{"$f":"I96*Results!$D$74^$A96","v":0.2111204331529373},1.173113802210435,2502.7042149014824,346.70448392446764,2849.4086988259501]
[80,0.30568652158290932,0.30285194163503237,0.15033987129186707,0.1501429256906408,7.5875526936538942E-2,1.5103212863009637E-2,201.56829666806095,44.224445994470486,245.79274266253145,{"$f":"H97*Results!$D$74^$A97","v":0.89891786378116667},{"$f":"I97*Results!$D$74^$A97","v":0.19722419238240324},1.09614205616357,2503.6031327652636,346.90170811685005,2850.5048408821135]
[81,0.30550540836677348,0.30299367063242622,0.15044848124443197,0.15016262025076343,7.579512052741709E-2,1.5094698978185921E-2,201.54234450370149,44.208824457230854,245.75116896093235,{"$f":"H98*Results!$D$74^$A98","v":0.84000198785832658},{"$f":"I98*Results!$D$74^$A98","v":0.18425656661085285},1.0242585544691793,2504.4431347531217,347.08596468346087,2851.5290994365828]
[82,0.30532483692662071,0.30311925751914354,0.15055331665161006,0.15019120635013031,7.5723739487213546E-2,1.508764306527987E-2,201.52168565352292,44.196296748163178,245.7179824016861,{"$f":"H99*Results!$D$74^$A99","v":0.78496811634350061},{"$f":"I99*Results!$D$74^$A99","v":0.17215360071675517},0.95712171706025573,2505.2281028694651,347.25811828417761,2852.4862211536429]
[83,0.30514623814556951,0.30322953648951739,0.15065394786240621,0.15022741738027828,7.5660925855998706E-2,1.5081934266227857E-2,201.50587663818493,44.186607337812546,245.69248397599748,{"$f":"H100*Results!$D$74^$A100","v":0.73355751121547552},{"$f":"I100*Results!$D$74^$A100","v":0.16085594250921695},0.8944134537246925,2505.9616603806808,347.41897422668683,2853.3806346073675]
[84,0.30497086050451888,0.30332537157231998,0.15075002990064146,0.15027007042849108,7.5606204139412755E-2,1.5077463454613773E-2,201.49448535875456,44.179506902713413,245.67399226146796,{"$f":"H101*Results!$D$74^$A101","v":0.68552901182730253},{"$f":"I101*Results!$D$74^$A101","v":0.15030849929272633},0.83583751112002891,2506.6471893925082,347.56928272597958,2854.2164721184877]
[85,0.30479978093390669,0.30340764601892989,0.15084129548919331,0.15031806637570613,7.5559087246896028E-2,1.5074123935365818E-2,201.48709334341123,44.174753661914622,245.66184700532585,{"$f":"H102*Results!$D$74^$A102","v":0.64065781546596068},{"$f":"I102*Results!$D$74^$A102","v":0.14046011935639763},0.78111793482235825,2507.2878472079742,347.709742845336,2854.99759005331]
[86,0.30463391582257721,0.30347725276467868,0.15092754824122048,0.15037038928705485,7.5519081840991736E-2,1.5071812043474898E-2,201.48329762184699,44.17211449690506,245.65541211875205,{"$f":"H103*Results!$D$74^$A103","v":0.59873434244073409},{"$f":"I103*Results!$D$74^$A103","v":0.13126329695654912},0.72999763939728324,2507.886581550415,347.84100614229254,2855.7275876927074]
[87,0.30447403207492324,0.30353508591757361,0.15100865605533237,0.1504261051824714,7.5485693121245298E-2,1.5070427648451904E-2,201.48271225489367,44.17136587068439,245.65407812557805,{"$f":"H104*Results!$D$74^$A104","v":0.55956318032260999},{"$f":"I104*Results!$D$74^$A104","v":0.12267389935929068},0.68223707968190062,2508.4461447307376,347.96368004165186,2856.4098247723896]
[88,0.30432075811962894,0.30358203322544108,0.15108454474567781,0.15048436026975751,7.5458429068244348E-2,1.5069874571248087E-2,201.48496954659078,44.172294561574773,245.65726410816555,{"$f":"H105*Results!$D$74^$A105","v":0.52296210218085826},{"$f":"I105*Results!$D$74^$A105","v":0.11465091452755519},0.63761301670841342,2508.9691068329184,348.0783309561794,2857.0474377890978]
[89,0.30417459478489556,0.30361896947015049,0.15115519193238211,0.15054437871734955,7.5436804174907793E-2,1.5070060920312298E-2,201.48972096539472,44.1746982271072,245.66441919250192,{"$f":"H106*Results!$D$74^$A106","v":0.48876115390075353},{"$f":"I106*Results!$D$74^$A106","v":0.1071562180703335},0.59591737197108707,2509.4578679868191,348.18548717424972,2857.6433551610689]
[90,0.30403592596596307,0.3036467507358877,0.15122062121265145,0.15060546003885283,7.5420342693284501E-2,1.5070899353358244E-2,201.49663780055627,44.178385812955007,245.67502361351129,{"$f":"H107*Results!$D$74^$A107","v":0.45680180591267711},{"$f":"I107*Results!$D$74^$A107","v":0.10015435811708183},0.55695616402975889,2509.9146697927317,348.28564153236681,2858.2003113250985]
[91,0.30390502902102318,0.30366620949739148,0.1512808966281807,0.1506669761562327,7.5408581425898694E-2,1.5072307271271079E-2,201.50541157887781,44.183177821442953,245.68858940032078,{"$f":"H108*Results!$D$74^$A108","v":0.42693616491297681},{"$f":"I108*Results!$D$74^$A108","v":9.3612356834253105E-2},0.52054852174722988,2510.3416059576448,348.37925388920104,2858.720859846846]
[92,0.30378208484124308,0.30367815047357305,0.1513361174402322,0.1507283682034275,7.5401072091120458E-2,1.5074206950401493E-2,201.51575426613101,44.188906453645345,245.70466071977637,{"$f":"H109*Results!$D$74^$A109","v":0.39902624140724735},{"$f":"I109*Results!$D$74^$A109","v":8.7499527361062895E-2},0.48652576876831022,2510.740632199052,348.46675341656209,2859.2073856156139]
[93,0.30366718754958244,0.30368334719195655,0.15138641321988763,0.15078914312710798,7.5397383292179793E-2,1.507652561928341E-2,201.52739827639087,44.195415638514845,245.72281391490571,{"$f":"H110*Results!$D$74^$A110","v":0.37294326915409942},{"$f":"I110*Results!$D$74^$A110","v":8.1787305005777286E-2},0.45473057415987672,2511.1135754682059,348.54854072156786,2859.6621161897738]
[94,0.30356035379138674,0.30368253920983784,0.15143193925749671,0.15084887013638593,7.5397102119317216E-2,1.5079195485573366E-2,201.54009631144163,44.202560961865558,245.7426572733072,{"$f":"H111*Results!$D$74^$A111","v":0.34856707282961352},{"$f":"I111*Results!$D$74^$A111","v":7.6449091610240147E-2},0.42501616443985368,2511.4621425410355,348.6249898131781,2860.0871323542137]
[95,0.30346153158739075,0.30367642993891525,0.15147287229223894,0.15090717704849702,7.5399835414204794E-2,1.5082153718751008E-2,201.55362105125323,44.210209507380718,245.76383055863394,{"$f":"H112*Results!$D$74^$A112","v":0.32578548046766231},{"$f":"I112*Results!$D$74^$A112","v":7.1460112057602179E-2},0.39724559252526448,2511.7879280215034,348.6964499252357,2860.4843779467392]
[96,0.30337060872677218,0.30366568502133906,0.15150940655996081,0.1509637465728712,7.5405210725209171E-2,1.5085342393845319E-2,201.56776471532868,44.218239621135844,245.78600433646452,{"$f":"H113*Results!$D$74^$A113","v":0.30449377745774647},{"$f":"I113*Results!$D$74^$A113","v":6.6797281965133237E-2},0.37129105942287971,2512.0924217989609,348.76324720720083,2860.8556690061619]
[97,0.30328742068427883,0.30365093120661069,0.15154175015503171,0.15101831257158019,7.5412876981331811E-2,1.5088708401164466E-2,201.58233851350002,44.22654061043287,245.80887912393288,{"$f":"H114*Results!$D$74^$A114","v":0.28459419909887818},{"$f":"I114*Results!$D$74^$A114","v":6.2439085669686409E-2},0.3470332847685646,2512.37701599806,348.8256862928705,2861.2027022909306]
[98,0.3032117580512293,0.30363275568049408,0.15157012169985906,0.15107065632992533,7.5422504911777641E-2,1.509220332671218E-2,201.59717200351415,44.235012387034821,245.83218439054897,{"$f":"H115*Results!$D$74^$A115","v":0.2659954589147106},{"$f":"I115*Results!$D$74^$A115","v":5.8365463677149843E-2},0.32436092259186045,2512.6430114569748,348.88405175654765,2861.5270632135225]
[99,0.30314337347538001,0.30361170579903085,0.15159474731389785,0.15112060286691872,7.5433787237096137E-2,1.509578330767402E-2,201.61211237151301,44.24356506418362,245.85567743569663,{"$f":"H116*Results!$D$74^$A116","v":0.24861231013108193},{"$f":"I116*Results!$D$74^$A116","v":5.4557708808549266E-2},0.30317001893963119,2512.891623767106,348.93860946535619,2861.830233232462]
[100,0.30308198810928499,0.3035882891828483,0.1516158578724596,0.15116801731161664,7.5446438656732465E-2,1.5099408867055538E-2,201.62702365028554,44.252118516080088,245.87914216636563,{"$f":"H117*Results!$D$74^$A117","v":0.23236513790226529},{"$f":"I117*Results!$D$74^$A117","v":5.0998370333984619E-2},0.28336350823624989,2513.1239889050084,348.98960783569015,2862.1135967406985]
[]
["Labels"]
["Optimal"]
[{"$f":"Details!D53","v":"0-Do Minimum"}]
[{"$f":"Details!D54","v":"1-Rehab"}]
[{"$f":"Details!D55","v":"2-Replace"}]
["Optimal"]
[{"$f":"Details!D56","v":"0-Do Minimum"}]
[{"$f":"Details!D57","v":"1-Rehab"}]
[{"$f":"Details!D58","v":"2-Replace"}]
["Optimal"]
[{"$f":"Details!D59","v":"0-Do Minimum"}]
[{"$f":"Details!D60","v":"1-Rehab"}]
[{"$f":"Details!D61","v":"2-Replace"}]
["Optimal"]
[{"$f":"Details!D62","v":"0-Do Minimum"}]
[{"$f":"Details!D63","v":"1-Rehab"}]
[{"$f":"Details!D64","v":"2-Replace"}]
["Optimal"]
[{"$f":"Details!D65","v":"0-Do Minimum"}]
[{"$f":"Details!D66","v":"1-Rehab"}]
[{"$f":"Details!D67","v":"2-Replace"}]