{"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":[[22,4,22,6],[16,3,16,6],[17,3,17,6],[18,3,18,6],[14,3,14,6],[15,3,15,6],[2,2,2,7],[3,2,3,7],[4,2,4,7],[13,3,13,6],[12,3,12,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,"Guideway-Guarded Direct Fixation Track"]
[]
[null,null,null,null,null,"Override"]
[null,null,null,null,"Default","Value","Notes"]
[]
[null,null,"Unit Agency Replacement Cost ($):",null,1]
[null,null,"Unit Agency Rehabilitation Cost ($):",null,1,null,"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":[[22,4,22,5],[23,4,23,5],[16,4,16,5],[17,4,17,5],[19,4,19,5],[21,4,21,5],[2,2,2,8],[3,2,3,8],[4,2,4,8],[20,4,20,5],[8,3,8,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":"Guideway-Guarded Direct Fixation Track"}]
[null,null,"Average Annual Unit Agency Cost:",null,null,{"$f":"U69","v":2.8792072943619684E-2}]
[null,null,"Average Annual Unit User Cost:",null,null,{"$f":"F12-F10","v":0}]
[null,null,"Average Annual Unit Total Cost:",null,null,{"$f":"V69","v":2.8792072943619684E-2}]
[]
[]
[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":0},{"$f":"M63","v":"N/A"}]
[null,null,{"$f":"Details!C56","v":"4-Good"},null,{"$f":"D64","v":"0-Do Minimum"},null,{"$f":"F64","v":0},{"$f":"M64","v":"N/A"}]
[null,null,{"$f":"Details!C59","v":"3-Adequate"},null,{"$f":"D65","v":"0-Do Minimum"},null,{"$f":"F65","v":0},{"$f":"M65","v":"N/A"}]
[null,null,{"$f":"Details!C62","v":"2-Marginal"},null,{"$f":"D66","v":"2-Replace"},null,{"$f":"F66","v":1},{"$f":"M66","v":0.1961704518908691}]
[null,null,{"$f":"Details!C65","v":"1-Poor"},null,{"$f":"D67","v":"2-Replace"},null,{"$f":"F67","v":1},{"$f":"M67","v":0.47124722857850454}]
[]
[]
[]
[null,null,"Objective Function"]
[null,null,{"$f":"SUM(Results!D33:E38)","v":12.802995434037971}]
[]
[null,null,"Decision Variables"]
[null,null,"Description"]
[null,null,{"$f":"\"State \"&Details!C53","v":"State 5-Excellent"},0.22056930371167205,0.22056930371167205]
[null,null,{"$f":"\"State \"&Details!C56","v":"State 4-Good"},0.48297922617416988,0.48297922617416988]
[null,null,{"$f":"\"State \"&Details!C59","v":"State 3-Adequate"},0.82953057859574475,0.82953057859574475]
[null,null,{"$f":"\"State \"&Details!C62","v":"State 2-Marginal"},1.2061395361791325,1.2061395361791325]
[null,null,{"$f":"\"State \"&Details!C65","v":"State 1-Poor"},1.2061395361791329,1.2061395361791332]
[null,null,{"$f":"\"State \"&Details!C68","v":"State 0-Failed"},1.7061395361791327,3.2061395361791325]
[]
[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":0},{"$f":"Details!E53+Details!F53","v":0},{"$f":"Results!E$33+Results!N43","v":0.22056930371167205},{"$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":0},{"$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":0}]
[null,null,null,{"$f":"Details!D54","v":"1-Rehab"},{"$f":"IF(H44=MIN(H43:H45),\"Y\",\"\")","v":""},{"$f":"Details!E54","v":1},{"$f":"Details!E54+Details!F54","v":1},{"$f":"Results!E$33+Results!N44","v":1.4513824543683831},{"$f":"Results!M$43-Results!M44","v":-1.230813150656711},null,0,{"$f":"Results!N$43-Results!N44","v":-1.230813150656711},{"$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":1.230813150656711},{"$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":1.230813150656711}]
[null,null,null,{"$f":"Details!D55","v":"2-Replace"},{"$f":"IF(H45=MIN(H43:H45),\"Y\",\"\")","v":""},{"$f":"Details!E55","v":1},{"$f":"Details!E55+Details!F55","v":1},{"$f":"Results!E$33+Results!N45","v":1.2061395361791327},{"$f":"Results!M$43-Results!M45","v":-0.98557023246746067},null,0,{"$f":"Results!N$43-Results!N45","v":-0.98557023246746067},{"$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":0.98557023246746067},{"$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":0.98557023246746067}]
[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":0},{"$f":"Details!E56+Details!F56","v":0},{"$f":"Results!E$34+Results!N46","v":0.48297922617416988},{"$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":0},{"$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":0}]
[null,null,null,{"$f":"Details!D57","v":"1-Rehab"},{"$f":"IF(H47=MIN(H46:H48),\"Y\",\"\")","v":""},{"$f":"Details!E57","v":1},{"$f":"Details!E57+Details!F57","v":1},{"$f":"Results!E$34+Results!N47","v":1.4513824543683831},{"$f":"Results!M$46-Results!M47","v":-0.96840322819421321},null,0,{"$f":"Results!N$46-Results!N47","v":-0.96840322819421321},{"$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":0.96840322819421321},{"$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":0.96840322819421321}]
[null,null,null,{"$f":"Details!D58","v":"2-Replace"},{"$f":"IF(H48=MIN(H46:H48),\"Y\",\"\")","v":""},{"$f":"Details!E58","v":1},{"$f":"Details!E58+Details!F58","v":1},{"$f":"Results!E$34+Results!N48","v":1.2061395361791327},{"$f":"Results!M$46-Results!M48","v":-0.72316031000496284},null,0,{"$f":"Results!N$46-Results!N48","v":-0.72316031000496284},{"$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":0.72316031000496284},{"$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":0.72316031000496284}]
[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":0},{"$f":"Details!E59+Details!F59","v":0},{"$f":"Results!E$35+Results!N49","v":0.82953057859574475},{"$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":0},{"$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":0}]
[null,null,null,{"$f":"Details!D60","v":"1-Rehab"},{"$f":"IF(H50=MIN(H49:H51),\"Y\",\"\")","v":""},{"$f":"Details!E60","v":1},{"$f":"Details!E60+Details!F60","v":1},{"$f":"Results!E$35+Results!N50","v":1.4513824543683831},{"$f":"Results!M$49-Results!M50","v":-0.62185187577263834},null,0,{"$f":"Results!N$49-Results!N50","v":-0.62185187577263834},{"$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":0.62185187577263834},{"$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":0.62185187577263834}]
[null,null,null,{"$f":"Details!D61","v":"2-Replace"},{"$f":"IF(H51=MIN(H49:H51),\"Y\",\"\")","v":""},{"$f":"Details!E61","v":1},{"$f":"Details!E61+Details!F61","v":1},{"$f":"Results!E$35+Results!N51","v":1.2061395361791327},{"$f":"Results!M$49-Results!M51","v":-0.37660895758338797},null,0,{"$f":"Results!N$49-Results!N51","v":-0.37660895758338797},{"$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":0.37660895758338797},{"$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":0.37660895758338797}]
[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":0.05},{"$f":"Details!E62+Details!F62","v":0.05},{"$f":"Results!E$36+Results!N52","v":1.4023099880700018},{"$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":2.7362869375143095E-2},{"$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":0.19617045189086935}]
[null,null,null,{"$f":"Details!D63","v":"1-Rehab"},{"$f":"IF(H53=MIN(H52:H54),\"Y\",\"\")","v":""},{"$f":"Details!E63","v":1},{"$f":"Details!E63+Details!F63","v":1},{"$f":"Results!E$36+Results!N53","v":1.4513824543683831},{"$f":"Results!M$52-Results!M53","v":-0.2178800488141075},null,0.16880758251572625,{"$f":"Results!N$52-Results!N53","v":-4.9072466298381245E-2},{"$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":0.24524291818925059},{"$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":0.24524291818925059}]
[null,null,null,{"$f":"Details!D64","v":"2-Replace"},{"$f":"IF(H54=MIN(H52:H54),\"Y\",\"\")","v":"Y"},{"$f":"Details!E64","v":1},{"$f":"Details!E64+Details!F64","v":1},{"$f":"Results!E$36+Results!N54","v":1.2061395361791327},{"$f":"Results!M$52-Results!M54","v":2.7362869375142845E-2},null,0.16880758251572625,{"$f":"Results!N$52-Results!N54","v":0.1961704518908691},{"$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":2.4980018054066022E-16},{"$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":2.4980018054066022E-16}]
[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":0.1},{"$f":"Details!E65+Details!F65","v":0.1},{"$f":"Results!E$37+Results!N55","v":1.6773867647576373},{"$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":0.13363206354705182},{"$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":0.4712472285785041}]
[null,null,null,{"$f":"Details!D66","v":"1-Rehab"},{"$f":"IF(H56=MIN(H55:H57),\"Y\",\"\")","v":""},{"$f":"Details!E66","v":1},{"$f":"Details!E66+Details!F66","v":1},{"$f":"Results!E$37+Results!N56","v":1.4513824543683831},{"$f":"Results!M$55-Results!M56","v":-0.11161085464219833},null,0.3376151650314525,{"$f":"Results!N$55-Results!N56","v":0.22600431038925417},{"$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":0.24524291818925015},{"$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":0.24524291818924993}]
[null,null,null,{"$f":"Details!D67","v":"2-Replace"},{"$f":"IF(H57=MIN(H55:H57),\"Y\",\"\")","v":"Y"},{"$f":"Details!E67","v":1},{"$f":"Details!E67+Details!F67","v":1},{"$f":"Results!E$37+Results!N57","v":1.2061395361791327},{"$f":"Results!M$55-Results!M57","v":0.13363206354705182},null,0.33761516503145272,{"$f":"Results!N$55-Results!N57","v":0.47124722857850454},{"$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":0},{"$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":-4.163336342344337E-16}]
[null,null,{"$f":"Details!C68","v":"0-Failed"},{"$f":"Details!D68","v":"0-Replace"},"Y",{"$f":"Details!E68","v":1.5},{"$f":"Details!E68+Details!F68","v":3},{"$f":"Results!E$38+Results!N58","v":3.2061395361791329},"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":0},{"$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.4980018054066022E-16}]
[]
[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":0},0,0.22056930371167205,{"$f":"IF($E43=\"Y\",I43,IF($E44=\"Y\",I44,I45))","v":0},null,0,0,{"$f":"IF(F63>0,L63/F63,\"N/A\")","v":"N/A"},{"$f":"IF($E43=\"Y\",Details!G53,IF($E44=\"Y\",Details!G54,Details!G55))","v":0.94116132837155342},{"$f":"IF($E43=\"Y\",Details!H53,IF($E44=\"Y\",Details!H54,Details!H55))","v":5.8838671628446582E-2},{"$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":0.48933927545875544},{"$f":"F63*$T63","v":0},0]
[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":0},0,0.48297922617416988,{"$f":"IF($E46=\"Y\",I46,IF($E47=\"Y\",I47,I48))","v":0},null,0,0,{"$f":"IF(F64>0,L64/F64,\"N/A\")","v":"N/A"},{"$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.90244289743511297},{"$f":"IF($E46=\"Y\",Details!I56,IF($E47=\"Y\",Details!I57,Details!I58))","v":9.7557102564887033E-2},{"$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.29513046397077591},0,0]
[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":0},0,0.82953057859574475,{"$f":"IF($E49=\"Y\",I49,IF($E50=\"Y\",I50,I51))","v":0},null,0,0,{"$f":"IF(F65>0,L65/F65,\"N/A\")","v":"N/A"},{"$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.84581582744524841},{"$f":"IF($E49=\"Y\",Details!J59,IF($E50=\"Y\",Details!J60,Details!J61))","v":0.15418417255475159},{"$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.18673818762684913},0,0]
[null,null,{"$f":"C52","v":"2-Marginal"},{"$f":"IF($E52=\"Y\",D52,IF($E53=\"Y\",D53,D54))","v":"2-Replace"},null,{"$f":"IF($E52=\"Y\",F52,IF($E53=\"Y\",F53,F54))","v":1},1,1.2061395361791327,{"$f":"IF($E52=\"Y\",I52,IF($E53=\"Y\",I53,I54))","v":2.7362869375142845E-2},null,0.16880758251572625,0.1961704518908691,{"$f":"IF(F66>0,L66/F66,\"N/A\")","v":0.1961704518908691},{"$f":"IF($E52=\"Y\",Details!G62,IF($E53=\"Y\",Details!G63,Details!G64))","v":1},{"$f":"IF($E52=\"Y\",Details!H62,IF($E53=\"Y\",Details!H63,Details!H64))","v":0},{"$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":2.8792072943619684E-2},2.8792072943619684E-2,2.8792072943619684E-2]
[null,null,{"$f":"C55","v":"1-Poor"},{"$f":"IF($E55=\"Y\",D55,IF($E56=\"Y\",D56,D57))","v":"2-Replace"},null,{"$f":"IF($E55=\"Y\",F55,IF($E56=\"Y\",F56,F57))","v":1},1,1.2061395361791327,{"$f":"IF($E55=\"Y\",I55,IF($E56=\"Y\",I56,I57))","v":0.13363206354705182},null,0.33761516503145272,0.47124722857850454,{"$f":"IF(F67>0,L67/F67,\"N/A\")","v":0.47124722857850454},{"$f":"IF($E55=\"Y\",Details!G65,IF($E56=\"Y\",Details!G66,Details!G67))","v":1},{"$f":"IF($E55=\"Y\",Details!H65,IF($E56=\"Y\",Details!H66,Details!H67))","v":0},{"$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":1.5},3,3.2061395361791329,{"$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":0},0,0]
[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.0000000000000002},{"$f":"SUM(U63:U68)","v":2.8792072943619684E-2},{"$f":"SUM(V63:V68)","v":2.8792072943619684E-2}]
[]
[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.15418417255475159}]
[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.63273097976541015}]
[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":0.60312032729049014}]
[]
[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":"Guideway-Guarded Direct Fixation Track"}]
[]
[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.94116132837155342},{"$f":"1-G11","v":5.8838671628446582E-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":1},0,0,1,0,0,0,0]
[null,null,null,"2-Replace",{"$f":"IF(Inputs!F28<>\"\",Inputs!F28,Inputs!E28)","v":1},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.90244289743511297},{"$f":"1-H14","v":9.7557102564887033E-2},0,0,0]
[null,null,null,"1-Rehab",{"$f":"E12","v":1},0,0,1,0,0,0,0]
[null,null,null,"2-Replace",{"$f":"E13","v":1},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.84581582744524841},{"$f":"1-I17","v":0.15418417255475159},0,0]
[null,null,null,"1-Rehab",{"$f":"E12","v":1},0,0,1,0,0,0,0]
[null,null,null,"2-Replace",{"$f":"E13","v":1},0,1,0,0,0,0,0]
[null,null,"2-Marginal","0-Do Minimum",{"$f":"E22*0.05","v":0.05},0,0,0,0,{"$f":"VLOOKUP(Inputs!$E$23,Details!$C$73:$G$200,5)","v":0.75916784894423062},{"$f":"(1-J20)/2","v":0.12041607552788469},0.12041607552788469]
[null,null,null,"1-Rehab",{"$f":"E12","v":1},0,0,1,0,0,0,0]
[null,null,null,"2-Replace",{"$f":"E13","v":1},0,1,0,0,0,0,0]
[null,null,"1-Poor","0-Do Minimum",{"$f":"E25*0.1","v":0.1},0,0,0,0,0,{"$f":"J20","v":0.75916784894423062},0.24083215105576938]
[null,null,null,"1-Rehab",{"$f":"E12","v":1},0,0,1,0,0,0,0]
[null,null,null,"2-Replace",{"$f":"E13","v":1},0,1,0,0,0,0,0]
[null,null,"0-Failed","0-Replace",{"$f":"E13*1.5","v":1.5},{"$f":"E13*1.5","v":1.5},1,0,0,0,0,0]
[]
[null,null,"Override Values",null,null,null,null,"Asset:",null,null,null,{"$f":"Inputs!$E$23","v":"Guideway-Guarded Direct Fixation Track"}]
[]
[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,{"$f":"C26","v":"0-Failed"},"0-Replace",null,null,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":"Guideway-Guarded Direct Fixation Track"}]
[]
[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"},0,0,0.94116132837155342,5.8838671628446582E-2,0,0,0,{"$f":"1-SUM(G53:K53)","v":0}]
[null,null,null,{"$f":"IF(D33<>\"\",D33,D12)","v":"1-Rehab"},1,0,0,1,0,0,0,0]
[null,null,null,{"$f":"IF(D34<>\"\",D34,D13)","v":"2-Replace"},1,0,1,0,0,0,0,0]
[null,null,{"$f":"IF(C35<>\"\",C35,C14)","v":"4-Good"},"0-Do Minimum",0,0,0,0.90244289743511297,9.7557102564887033E-2,0,0,0]
[null,null,null,{"$f":"IF(D36<>\"\",D36,D15)","v":"1-Rehab"},1,0,0,1,0,0,0,0]
[null,null,null,{"$f":"IF(D37<>\"\",D37,D16)","v":"2-Replace"},1,0,1,0,0,0,0,0]
[null,null,{"$f":"IF(C38<>\"\",C38,C17)","v":"3-Adequate"},"0-Do Minimum",0,0,0,0,0.84581582744524841,0.15418417255475159,0,0]
[null,null,null,{"$f":"IF(D39<>\"\",D39,D18)","v":"1-Rehab"},1,0,0,1,0,0,0,0]
[null,null,null,{"$f":"IF(D40<>\"\",D40,D19)","v":"2-Replace"},1,0,1,0,0,0,0,0]
[null,null,{"$f":"IF(C41<>\"\",C41,C20)","v":"2-Marginal"},"0-Do Minimum",0.05,0,0,0,0,0.75916784894423062,0.12041607552788469,0.12041607552788469]
[null,null,null,{"$f":"IF(D42<>\"\",D42,D21)","v":"1-Rehab"},1,0,0,1,0,0,0,0]
[null,null,null,{"$f":"IF(D43<>\"\",D43,D22)","v":"2-Replace"},1,0,1,0,0,0,0,0]
[null,null,{"$f":"IF(C44<>\"\",C44,C23)","v":"1-Poor"},"0-Do Minimum",0.1,0,0,0,0,0,0.75916784894423062,0.24083215105576938]
[null,null,null,{"$f":"IF(D45<>\"\",D45,D24)","v":"1-Rehab"},1,0,0,1,0,0,0,0]
[null,null,null,{"$f":"IF(D46<>\"\",D46,D25)","v":"2-Replace"},1,0,1,0,0,0,0,0]
[null,null,{"$f":"IF(C47<>\"\",C47,C26)","v":"0-Failed"},"0-Replace",1.5,1.5,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":0},{"$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.94116132837155342},{"$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":5.8838671628446582E-2},{"$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":0},{"$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":0},{"$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.90244289743511297},{"$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":9.7557102564887033E-2},{"$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":0},{"$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":0},{"$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.84581582744524841},{"$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.15418417255475159},{"$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":0.05},{"$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":0},{"$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.75916784894423062},{"$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.12041607552788469},{"$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":0.12041607552788469}]
[{"$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":0.1},{"$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":0},{"$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.75916784894423062},{"$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":0.24083215105576938}]
[{"$f":"Details!C68","v":"0-Failed"},0,{"$f":"Details!D68","v":"0-Replace"},{"$f":"Details!E68","v":1.5},{"$f":"Details!F68","v":1.5},{"$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":0},{"$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":0},{"$f":"H17+I17","v":0},{"$f":"H17*Results!$D$74^$A17","v":0},{"$f":"I17*Results!$D$74^$A17","v":0},{"$f":"K17+L17","v":0},{"$f":"K17","v":0},{"$f":"L17","v":0},{"$f":"N17+O17","v":0}]
[{"$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.47058066418577671},{"$f":"$B17*G$7+$C17*G$8+$D17*G$9+$E17*G$10+$F17*G$11+$G17*G$12","v":0.48064078453177977},{"$f":"$B17*H$7+$C17*H$8+$D17*H$9+$E17*H$10+$F17*H$11+$G17*H$12","v":4.8778551282443516E-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":0},{"$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":0},{"$f":"H18+I18","v":0},{"$f":"H18*Results!$D$74^$A18","v":0},{"$f":"I18*Results!$D$74^$A18","v":0},{"$f":"K18+L18","v":0},{"$f":"N17+K18","v":0},{"$f":"O17+L18","v":0},{"$f":"N18+O18","v":0}]
[{"$f":"A18+1","v":2},0.44289232301105352,0.46143920339306838,8.8147593027975049E-2,7.5208805679030707E-3,0,0,7.5208805679030709E-4,0,{"$f":"H19+I19","v":7.5208805679030709E-4},{"$f":"H19*Results!$D$74^$A19","v":6.569028358723968E-4},{"$f":"I19*Results!$D$74^$A19","v":0},{"$f":"K19+L19","v":6.569028358723968E-4},{"$f":"N18+K19","v":6.569028358723968E-4},{"$f":"O18+L19","v":0},{"$f":"N19+O19","v":6.569028358723968E-4}]
[3,0.41683312705064623,0.44248172766059835,0.11957330102714106,1.9300574416612759E-2,9.0563492250081651E-4,9.0563492250081651E-4,4.8280891936638894E-3,2.7169047675024496E-3,7.5449939611663391E-3,{"$f":"H20*Results!$D$74^$A20","v":3.9411589582274984E-3},{"$f":"I20*Results!$D$74^$A20","v":2.2178035934268835E-3},6.1589625516543824E-3,4.5980617940998949E-3,2.2178035934268835E-3,6.8158653875267788E-3]
[4,0.39321285448675553,0.42384039985851651,0.14430422583710448,3.308868604175793E-2,3.0116283427261206E-3,2.5422054331394974E-3,1.153781057213951E-2,7.6266162994184927E-3,1.9164426871558005E-2,{"$f":"H21*Results!$D$74^$A21","v":8.8021404429965509E-3},{"$f":"I21*Results!$D$74^$A21","v":5.8183090589499836E-3},1.4620449501946534E-2,1.3400202237096447E-2,8.0361126523768676E-3,2.1436314889473312E-2]
[5,0.37261893789466466,0.40562788052360682,0.16340343954039654,4.7369294263560319E-2,6.2707411282896548E-3,4.7097066494820403E-3,2.0120197600460084E-2,1.4129119948446121E-2,3.4249317548906207E-2,{"$f":"H22*Results!$D$74^$A22","v":1.4345422817608509E-2},{"$f":"I22*Results!$D$74^$A22","v":1.0073867251509086E-2},2.4419290069117597E-2,2.7745625054704955E-2,1.8109979903885954E-2,4.5855604958590909E-2]
[6,0.355404241214822,0.38798040310951226,0.17778109616567936,6.1155469350209789E-2,1.046456956939325E-2,7.2142205903833537E-3,2.9851122620049689E-2,2.1642661771150061E-2,5.1493784391199754E-2,{"$f":"H23*Results!$D$74^$A23","v":1.9891063430063312E-2},{"$f":"I23*Results!$D$74^$A23","v":1.4421419373896755E-2},3.431248280396007E-2,4.7636688484768264E-2,3.2531399277782709E-2,8.0168087762550966E-2]
[7,0.34170694836100923,0.37104167257438747,0.18822030893681826,7.3838297325955579E-2,1.5308466386341625E-2,9.8843064154878219E-3,4.0098442256327353E-2,2.9652919246463467E-2,6.9751361502790821E-2,{"$f":"H24*Results!$D$74^$A24","v":2.4971294565102043E-2},{"$f":"I24*Results!$D$74^$A24","v":1.846634780685975E-2},4.3437642371961793E-2,7.2607983049870303E-2,5.0997747084642456E-2,0.12360573013451276]
[8,0.33148567184872507,0.35494950499497269,0.19539746685258197,8.5076253942073271E-2,2.0513013484806705E-2,1.2578088876840266E-2,5.0344494721689469E-2,3.7734266630520798E-2,8.8078761352210266E-2,{"$f":"H25*Results!$D$74^$A25","v":2.9300954292749801E-2},{"$f":"I25*Results!$D$74^$A25","v":2.1961686733047828E-2},5.1262641025797626E-2,0.1019089373426201,7.2959433817690281E-2,0.1748683711603104]
[9,0.3245595841301232,0.3398258363262644,0.19989811537077257,9.4714353447396732E-2,2.5817368942942898E-2,1.5184741782500196E-2,6.018913448082884E-2,4.5554225347500588E-2,0.10574335982832943,{"$f":"H26*Results!$D$74^$A26","v":3.2738901181057836E-2},{"$f":"I26*Results!$D$74^$A26","v":2.4778480283787669E-2},5.7517381464845502E-2,0.13464783852367795,9.7737914101477946E-2,0.2323857526251559]
[10,0.32064767111812587,0.32577006715208201,0.2022294138257556,0.10272521748450059,3.1004847184110035E-2,1.7622783235425845E-2,6.93418408915496E-2,5.2868349706277531E-2,0.12221019059782713,{"$f":"H27*Results!$D$74^$A27","v":3.5249875732537482E-2},{"$f":"I27*Results!$D$74^$A27","v":2.6875588149516912E-2},6.2125463882054394E-2,0.16989771425621544,0.12461350225099485,0.29451121650721029]
[11,0.31940397132420617,0.31285536632770172,0.20283002284252483,0.10916625722699314,3.59076506908374E-2,1.9836731587736637E-2,7.7608350624076713E-2,5.9510194763209914E-2,0.13711854538728663,{"$f":"H28*Results!$D$74^$A28","v":3.6871168321020928E-2},{"$f":"I28*Results!$D$74^$A28","v":2.8272864843623329E-2},6.5144033164644261E-2,0.20676888257723636,0.15288636709461817,0.35965524967185453]
[12,0.32044739752637608,0.30112740865246157,0.20207810666209569,0.11414869191754501,4.0405306210945936E-2,2.1793089030575648E-2,8.4875197525670631E-2,6.537926709172695E-2,0.15025446461739758,{"$f":"H29*Results!$D$74^$A29","v":3.768560274431744E-2},{"$f":"I29*Results!$D$74^$A29","v":2.9029176475121026E-2},6.6714779219438469E-2,0.24445448532155378,0.18191554356973919,0.42637002889129294]
[13,0.32338578735970697,0.29060499035869947,0.2002979784859765,0.11781526256996638,4.4419746909449123E-2,2.3476234316201487E-2,9.1094178587490915E-2,7.0428702948604455E-2,0.16152288153609537,{"$f":"H30*Results!$D$74^$A30","v":3.7800845523418031E-2},{"$f":"I30*Results!$D$74^$A30","v":2.9225407834573482E-2},6.7026253357991505E-2,0.28225533084497179,0.21114095140431266,0.49339628224928445]
[14,0.32783443152414399,0.28128199966017231,0.19776578125901842,0.12032433753529083,4.7908895267856265E-2,2.4884554753518133E-2,9.6267877067654731E-2,7.4653664260554392E-2,0.17092154132820914,{"$f":"H31*Results!$D$74^$A31","v":3.7334342482972876E-2},{"$f":"I31*Results!$D$74^$A31","v":2.8951978105361889E-2},6.6286320588334766E-2,0.31958967332794463,0.24009292950967454,0.55968260283761917]
[15,0.33342964381271456,0.27313028523461591,0.19471448480645662,0.12183872184537205,5.085987748228514E-2,2.6026986818555666E-2,0.10043680813666123,7.8080960455666995E-2,0.17851776859232821,{"$f":"H32*Results!$D$74^$A32","v":3.6402921334716239E-2},{"$f":"I32*Results!$D$74^$A32","v":2.8300133327009001E-2},6.470305466172524E-2,0.35599259466266087,0.26839306283668352,0.62438565749934438]
[16,0.33983807330778398,0.26610304330789186,0.19133839233235861,0.1225179321057738,5.3282524517746774E-2,2.6920034428444872E-2,0.10366840139946135,8.0760103285334617E-2,0.18442850468479596,{"$f":"H33*Results!$D$74^$A33","v":3.5116074252262826E-2},{"$f":"I33*Results!$D$74^$A33","v":2.7356241104369541E-2},6.2472315356632363E-2,0.39110866891492369,0.29574930394105303,0.68685797285597672]
[17,0.34676248693402817,0.26013842222127592,0.18779728252145403,0.12251302667355672,5.5203508090425159E-2,2.7585273559259833E-2,0.10604782496322021,8.2755820677779507E-2,0.18880364564099972,{"$f":"H34*Results!$D$74^$A34","v":3.3572025547776101E-2},{"$f":"I34*Results!$D$74^$A34","v":2.6198373488425266E-2},5.9770399036201363E-2,0.42468069446269979,0.32194767742947827,0.74662837189217801]
[18,0.3539447163915132,0.25516311558534177,0.18422026464556163,0.12196331954101251,5.6661266364256259E-2,2.8047317472314419E-2,0.10767053764389575,8.414195241694325E-2,0.191812490060839,{"$f":"H35*Results!$D$74^$A35","v":3.1855826939775095E-2},{"$f":"I35*Results!$D$74^$A35","v":2.4894567569022419E-2},5.6750394508797514E-2,0.45653652140247492,0.34684224499850069,0.80337876640097561]
[19,0.36116639692144376,0.25109577828979035,0.18070938981130366,0.12099448001824159,5.7701756001690606E-2,2.8332198957529846E-2,0.10863639607475181,8.4996596872589536E-2,0.19363299294734135,{"$f":"H36*Results!$D$74^$A36","v":3.0038868782934953E-2},{"$f":"I36*Results!$D$74^$A36","v":2.3502267312834085E-2},5.3541136095769035E-2,0.48657539018540985,0.37034451231133481,0.85691990249674466]
[20,0.36824804484728357,0.24785015272525315,0.17734303866660098,0.11971764687050407,5.8374998428442015E-2,2.8466118461916011E-2,0.10904511975848684,8.5398355385748026E-2,0.19444347514423488,{"$f":"H37*Results!$D$74^$A37","v":2.8179331109707086E-2},{"$f":"I37*Results!$D$74^$A37","v":2.2068557840729398E-2},5.0247888950436484E-2,0.5147547212951169,0.39241307015206423,0.90716779144718118]
[21,0.3750469375206128,0.24533783574369949,0.17417909176158625,0.11822927813050077,5.8732351196622415E-2,2.8474505646978093E-2,0.10899291499330885,8.542351694093428E-2,0.19441643193424313,{"$f":"H38*Results!$D$74^$A38","v":2.632321533303519E-2},{"$f":"I38*Results!$D$74^$A38","v":2.0630897256756892E-2},4.6954112589792082E-2,0.54107793662815207,0.4130439674088211,0.95412190403697317]
[22,0.38145417956556105,0.24347065094103384,0.17125788102668341,0.11661152590015976,5.8824418406346612E-2,2.8381344160215136E-2,0.1085700687519307,8.5144032480645407E-2,0.1937141012325761,{"$f":"H39*Results!$D$74^$A39","v":2.4505693861740868E-2},{"$f":"I39*Results!$D$74^$A39","v":1.921812906734217E-2},4.3723822929083042E-2,0.56558363048989291,0.43226209647616326,0.99784572696605611]
[23,0.38739126651301964,0.24216261688839613,0.16860491761249838,0.11493297595930799,5.8699509497157083E-2,2.8208713529620566E-2,0.10785934008422392,8.4626140588861698E-2,0.19248548067308563,{"$f":"H40*Results!$D$74^$A40","v":2.275259163043836E-2},{"$f":"I40*Results!$D$74^$A40","v":1.7851620606754142E-2},4.0604212237192502E-2,0.58833622212033132,0.45011371708291742,1.0384499392032487]
[24,0.39280639252055261,0.24133152115732104,0.16623339115491598,0.11324962984253194,5.8402558272798763E-2,2.7976507051879491E-2,0.10693499579445143,8.3929521155638481E-2,0.19086451695008991,{"$f":"H41*Results!$D$74^$A41","v":2.1081872975114876E-2},{"$f":"I41*Results!$D$74^$A41","v":1.6546421409755142E-2},3.7628294384870017E-2,0.6094180950954462,0.46666013849267257,1.0760782335881187]
[25,0.39767069322936061,0.24090012353870754,0.16414643725040987,0.11160603574747641,5.7974420517424026E-2,2.7702289716621357E-2,0.10586235682809651,8.3106869149864065E-2,0.18896922597796056,{"$f":"H42*Results!$D$74^$A42","v":1.9505052176142647E-2},{"$f":"I42*Results!$D$74^$A42","v":1.5312372287310859E-2},3.4817424463453504E-2,0.62892314727158882,0.48197251077998343,1.1108956580515723]
[26,0.40197456761080291,0.24079702081392695,0.16233917270510462,0.11003649669286947,5.7451476947936987E-2,2.7401265229358877E-2,0.10469774074695098,8.2203795688076634E-2,0.1869015364350276,{"$f":"H43*Results!$D$74^$A43","v":1.8028479085105055E-2},{"$f":"I43*Results!$D$74^$A43","v":1.4155123125919964E-2},3.2183602211025022E-2,0.6469516263566939,0.49612763390590342,1.1430792602625974]
[27,0.40572418325352294,0.2409572107437023,0.16080050134520865,0.10856630151644413,5.6865477269826777E-2,2.7086325871295017E-2,0.10348870321949483,8.125897761388505E-2,0.18474768083337989,{"$f":"H44*Results!$D$74^$A44","v":1.6654475020556458E-2},{"$f":"I44*Results!$D$74^$A44","v":1.3077037113858341E-2},2.97315121344148E-2,0.6636061013772504,0.50920467101976175,1.1728107723970123]
[28,0.40893823713464422,0.24132239541160355,0.15951469642118091,0.10721293783636987,5.624357002130867E-2,2.6768163174892581E-2,0.10227449731257646,8.0304489524677738E-2,0.18257898683725421,{"$f":"H45*Results!$D$74^$A45","v":1.5382310671007251E-2},{"$f":"I45*Results!$D$74^$A45","v":1.2077972892596583E-2},2.7460283563603832E-2,0.67898841204825766,0.52128264391235835,1.200271055960616]
[29,0.41164501765845563,0.24184106438231068,0.15846276862353276,0.10598725687425059,5.5608471290091839E-2,2.6455421171358275E-2,0.10108668345951827,7.9366263514074831E-2,0.1804529469735931,{"$f":"H46*Results!$D$74^$A46","v":1.4209028822011169E-2},{"$f":"I46*Results!$D$74^$A46","v":1.1155945443777812E-2},2.536497426578898E-2,0.6931974408702688,0.53243858935613619,1.2256360302264051]
[30,0.41387979280832193,0.24246839688145611,0.15762363128492485,0.10489456867767889,5.4978733061139103E-2,2.6154877286478889E-2,9.9949835339432386E-2,7.8464631859436668E-2,0.17841446719886905,{"$f":"H47*Results!$D$74^$A47","v":1.3130121728617189E-2},{"$f":"I47*Results!$D$74^$A47","v":1.0307672485970388E-2},2.3437794214587575E-2,0.70632756259888596,0.54274626184210661,1.2490738244409925]
[31,0.41568253287210244,0.24316601984084651,0.1569750763834914,0.10393565323370775,5.4369078820060299E-2,2.5871638849791344E-2,9.8882297636756863E-2,7.7614916549374025E-2,0.1764972141861309,{"$f":"H48*Results!$D$74^$A48","v":1.2140076988937263E-2},{"$f":"I48*Results!$D$74^$A48","v":9.5290166684909704E-3},2.1669093657428234E-2,0.71846763958782323,0.55227527851059754,1.2707429180984207]
[32,0.41709596366855117,0.24390165555628029,0.15649457645749265,0.10310767855795494,5.3790780086734685E-2,2.5609345672985978E-2,9.7896960892100371E-2,7.6828037018957934E-2,0.17472499791105831,{"$f":"H49*Results!$D$74^$A49","v":1.123280769551128E-2},{"$f":"I49*Results!$D$74^$A49","v":8.8153356099455182E-3},2.0048143305456796E-2,0.7297004472833345,0.56109061412054306,1.2907910614038776]
[33,0.41816393689769282,0.24464868917327487,0.15615992850393762,0.10240502132088064,5.3252052820218082E-2,2.5370371283995719E-2,9.7002026548118833E-2,7.6111113851987156E-2,0.173113140400106,{"$f":"H50*Results!$D$74^$A50","v":1.0401983102453853E-2},{"$f":"I50*Results!$D$74^$A50","v":8.1617523712721376E-3},1.856373547372599E-2,0.74010243038578838,0.56925236649181521,1.3093547968776036]
[34,0.41893009761170674,0.24538568248121431,0.15594975640339118,0.10181998911984982,5.2758457173199318E-2,2.5156017210638378E-2,9.6201741978539979E-2,7.546805163191514E-2,0.17166979361045512,{"$f":"H51*Results!$D$74^$A51","v":9.6412755398687083E-3},{"$f":"I51*Results!$D$74^$A51","v":7.5633586801644613E-3},1.7204634220033169E-2,0.74974370592565709,0.57681572517197965,1.3265594310976367]
[35,0.41943682437369684,0.24609585673608797,0.15584388844599387,0.10134344627081329,5.2313287945898276E-2,2.4966696227509511E-2,9.5497090898789522E-2,7.4900088682528537E-2,0.17039717958131806,{"$f":"H52*Results!$D$74^$A52","v":8.9445381966500696E-3},{"$f":"I52*Results!$D$74^$A52","v":7.0153624351068688E-3},1.5959900631756938E-2,0.75868824412230718,0.58383108760708657,1.3425193317293938]
[36,0.419724415023004,0.24676656357789406,0.15582362619462958,0.10096534709776911,5.1917946361490122E-2,2.4802101745212912E-2,9.4886429217713675E-2,7.4406305235638737E-2,0.16929273445335241,{"$f":"H53*Results!$D$74^$A53","v":8.3059269428824734E-3},{"$f":"I53*Results!$D$74^$A53","v":6.5131899310808565E-3},1.4819116873963329E-2,0.76699417106518963,0.59034427753816743,1.3573384486033571]
[37,0.41983048973823656,0.24738875965532109,0.15587192027788305,0.10067518224342087,5.1572286522678465E-2,2.466136156245978E-2,9.4366060216257125E-2,7.398408468737934E-2,0.16835014490363648,{"$f":"H54*Results!$D$74^$A54","v":7.7199777612534087E-3},{"$f":"I54*Results!$D$74^$A54","v":6.0525520209739588E-3},1.3772529782227368E-2,0.77471414882644307,0.59639682955914142,1.3711109783855844]
[38,0.41978958297537833,0.24795649738154477,0.15597346782441179,0.10046234459837182,5.1274932173364672E-2,2.4543175046928444E-2,9.3930746035295443E-2,7.3629525140785329E-2,0.16756027117608077,{"$f":"H55*Results!$D$74^$A55","v":7.1816497325358462E-3},{"$f":"I55*Results!$D$74^$A55","v":5.6294821648213813E-3},1.2811131897357227E-2,0.78189579855897895,0.60202631172396281,1.3839221102829418]
[{"$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.41963289659657593},{"$f":"$B55*G$7+$C55*G$8+$D55*G$9+$E55*G$10+$F55*G$11+$G55*G$12","v":0.24846644136059409},{"$f":"$B55*H$7+$C55*H$8+$D55*H$9+$E55*H$10+$F55*H$11+$G55*H$12","v":0.15611474519409119},{"$f":"$B55*I$7+$C55*I$8+$D55*I$9+$E55*I$10+$F55*I$11+$G55*I$12","v":0.10031642212564207},{"$f":"$B55*J$7+$C55*J$8+$D55*J$9+$E55*J$10+$F55*J$11+$G55*J$12","v":5.1023561237680495E-2},{"$f":"$B55*K$7+$C55*K$8+$D55*K$9+$E55*K$10+$F55*K$11+$G55*K$12","v":2.4445933485416009E-2},9.3574154916348323E-2,7.333780045624802E-2,{"$f":"H56+I56","v":0.16691195537259634},{"$f":"H56*Results!$D$74^$A56","v":6.686341958794779E-3},{"$f":"I56*Results!$D$74^$A56","v":5.240353095303873E-3},{"$f":"K56+L56","v":1.1926695054098652E-2},{"$f":"N55+K56","v":0.78858214051777376},{"$f":"O55+L56","v":0.60726666481926672},{"$f":"N56+O56","v":1.3958488053370406}]
[40,0.41938818787465215,0.24891741746418594,0.15628398848649233,0.10022742521025195,5.0815157093652599E-2,2.4367823870764846E-2,9.3289245552050259E-2,7.3103471612294538E-2,0.16639271716434478,{"$f":"H57*Results!$D$74^$A57","v":6.2298913625971394E-3},{"$f":"I57*Results!$D$74^$A57","v":4.8818776878112487E-3},1.1111769050408388E-2,0.79481203188037086,0.61214854250707795,1.4069605743874489]
[41,0.41907976787421108,0.24930999930965148,0.15647113306388657,0.10018595625043186,5.0646226708634515E-2,2.4306916793184308E-2,9.3068591346323018E-2,7.2920750379552923E-2,0.16598934172587593,{"$f":"H58*Results!$D$74^$A58","v":5.8085570006224697E-3},{"$f":"I58*Results!$D$74^$A58","v":4.5510985927749307E-3},1.03596555933974E-2,0.8006205888809933,0.61669964109985287,1.4173202299808461]
[42,0.41872858781931904,0.24964613498462421,0.15666772205683038,0.10018332908122093,5.051298666222126E-2,2.4261239395783965E-2,9.2904648427918235E-2,7.2783718187351895E-2,0.16568836661527014,{"$f":"H59*Results!$D$74^$A59","v":5.4189953883397755E-3},{"$f":"I59*Results!$D$74^$A59","v":4.2453702788563434E-3},9.6643656671961189E-3,0.80603958426933309,0.62094501137870917,1.4269845956480423]
[43,0.41835239333495894,0.24992881526914568,0.1568667925610828,0.10021164553003269,5.0411518749386347E-2,2.4228834555393361E-2,9.2789971969060622E-2,7.2686503666180083E-2,0.16547647563524071,{"$f":"H60*Results!$D$74^$A60","v":5.0582303498687064E-3},{"$f":"I60*Results!$D$74^$A60","v":3.9623363502330547E-3},9.020566700101762E-3,0.81109781461920183,0.62490734772894219,1.436005162348144]
[44,0.41796592879394195,0.25016178330042332,0.15706274701386713,0.10026383598854506,5.0337897327901407E-2,2.420780757532099E-2,9.2717385790397761E-2,7.2623422725962977E-2,0.16534080851636074,{"$f":"H61*Results!$D$74^$A61","v":4.7236200771061691E-3},{"$f":"I61*Results!$D$74^$A61","v":3.699904335439692E-3},8.4235244125458603E-3,0.81582143469630797,0.62860725206438184,1.4444286867606899]
[45,0.41758117633307751,0.25034928458535433,0.15725121607761217,0.10033367038183028,5.028829088191053E-2,2.4196361740215049E-2,9.2680110435210267E-2,7.2589085220645139E-2,0.16526919565585541,{"$f":"H62*Results!$D$74^$A62","v":4.4128233931990373E-3},{"$f":"I62*Results!$D$74^$A62","v":3.4562195906802347E-3},7.8690429838792729E-3,0.82023425808950701,0.63206347165506205,1.4522977297445689]
[46,0.41720761636081016,0.25049585546449721,0.15742891827679661,0.10041574535460863,5.0259040446590145E-2,2.419282409669711E-2,9.2671854914870233E-2,7.2578472290091331E-2,0.16525032720496158,{"$f":"H63*Results!$D$74^$A63","v":4.1237666533405718E-3},{"$f":"I63*Results!$D$74^$A63","v":3.2296395065710059E-3},7.3534061599115777E-3,0.82435802474284758,0.63529311116163301,1.4596511359044806]
[47,0.41685249851756662,0.25060614754080879,0.15759352063972817,0.10050545290168736,5.0246717602648316E-2,2.4195662797560611E-2,9.268687720338023E-2,7.2586988392681837E-2,0.16527386559606205,{"$f":"H64*Results!$D$74^$A64","v":3.8546122653847496E-3},{"$f":"I64*Results!$D$74^$A64","v":3.0187088421570851E-3},6.8733211075418348E-3,0.82821263700823233,0.63831182000379005,1.4665244570120224]
[48,0.41652111403735465,0.25068478517955151,0.15774350369893142,0.10059893506636633,5.0248164726484572E-2,2.4203497291311431E-2,9.2720018325867834E-2,7.2610491873934285E-2,0.16533051019980211,{"$f":"H65*Results!$D$74^$A65","v":3.6037294585585028E-3},{"$f":"I65*Results!$D$74^$A65","v":2.8221367218336413E-3},6.4258661803921445E-3,0.8318163664667908,0.64113395672562368,1.4729503231924146]
[49,0.41621706227350741,0.25073625293549201,0.15787803340444245,0.1006930287341208,5.0260520091776992E-2,2.421510256066025E-2,9.2766714573748216E-2,7.2645307681980742E-2,0.16541202225572896,{"$f":"H66*Results!$D$74^$A66","v":3.369667655894693E-3},{"$f":"I66*Results!$D$74^$A66","v":2.638775607967487E-3},6.00844326386218E-3,0.83518603412268555,0.64377273233359111,1.4789587664562767]
[50,0.41594250578090003,0.25076480964439635,0.1579968418037703,0.10078520397279747,5.0281230278071978E-2,2.4229408520063722E-2,9.2822992013085304E-2,7.2688225560191166E-2,0.16551121757327647,{"$f":"H67*Results!$D$74^$A67","v":3.1511326012840521E-3},{"$f":"I67*Results!$D$74^$A67","v":2.4676023938111991E-3},5.6187349950952512E-3,0.83833716672396963,0.64624033472740228,1.4845775014513718]
[51,0.41569840978700812,0.25077442590420923,0.15810011773813473,0.10087349882521249,5.0308052166155068E-2,2.4245495579280199E-2,9.2885447053592862E-2,7.2736486737840597E-2,0.16562193379143347,{"$f":"H68*Results!$D$74^$A68","v":2.9469652429660012E-3},{"$f":"I68*Results!$D$74^$A68","v":2.3077016379993024E-3},5.254666880965304E-3,0.84128413196693563,0.64854803636540159,1.4898321683323372]
[52,0.41548476313636312,0.25076874174554681,0.15818840829245923,0.10095645295287804,5.0339046600852859E-2,2.4262587271899758E-2,9.2951216431157654E-2,7.2787761815699278E-2,0.16573897824685693,{"$f":"H69*Results!$D$74^$A69","v":2.7561232710107764E-3},{"$f":"I69*Results!$D$74^$A69","v":2.1582508748943315E-3},4.9143741459051083E-3,0.84404025523794646,0.65070628724029589,1.4947465424782425]
[53,0.41530077886345951,0.2507510414318122,0.15826253131067117,0.10103304206560187,5.037256558967395E-2,2.4280040738781108E-2,9.3017939540838313E-2,7.2840122216343325E-2,0.16585806175718165,{"$f":"H70*Results!$D$74^$A70","v":2.5776651375137628E-3},{"$f":"I70*Results!$D$74^$A70","v":2.0185078768260333E-3},4.5961730143397961E-3,0.84661792037546024,0.65272479511712189,1.499342715492582]
[54,0.41514507344765539,0.25072424251918185,0.15832349894133041,0.10110261465379124,5.0407234688698413E-2,2.4297335749342473E-2,9.3083715651146218E-2,7.2892007248027413E-2,0.16597572289917362,{"$f":"H71*Results!$D$74^$A71","v":2.4107363468579921E-3},{"$f":"I71*Results!$D$74^$A71","v":1.8877997084562239E-3},4.2985360553142163E-3,0.8490286567223182,0.6546125948255781,1.5036412515478963]
[55,0.41501582454224389,0.25069089653098836,0.15837245190403573,0.10116483216959826,5.044193201206372E-2,2.4314062841069781E-2,9.3147058142581923E-2,7.2942188523209342E-2,0.16608924666579128,{"$f":"H72*Results!$D$74^$A72","v":2.2545577828387217E-3},{"$f":"I72*Results!$D$74^$A72","v":1.7655133947500586E-3},4.0200711775887805E-3,0.85128321450515687,0.65637810822032816,1.5076613227254851]
[56,0.41491090756246357,0.25065319884688131,0.1584106039567019,0.10121961347928896,5.0475765093489659E-2,2.4329911061174304E-2,9.3206847550149741E-2,7.298973318352292E-2,0.16619658073367266,{"$f":"H73*Results!$D$74^$A73","v":2.1084158342029786E-3},{"$f":"I73*Results!$D$74^$A73","v":1.6510880179225959E-3},3.7595038521255745E-3,0.85339163033935983,0.65802919623825074,1.5114208265776106]
[57,0.41482801197850933,0.25061300566388767,0.15843919588986158,0.10126708413100079,5.050804663146418E-2,2.4344655705276188E-2,9.3262284855221478E-2,7.303396711582856E-2,0.16629625197105002,{"$f":"H74*Results!$D$74^$A74","v":1.971654085801322E-3},{"$f":"I74*Results!$D$74^$A74","v":1.5440080616697519E-3},3.5156621474710737E-3,0.85536328442516119,0.6595732042999205,1.5149364887250818]
[58,0.41476473850470069,0.25057185614532596,0.15845945826898958,0.1013075307471048,5.0538269966790797E-2,2.4358146367087871E-2,9.3312846169332248E-2,7.3074439101263614E-2,0.16638728527059587,{"$f":"H75*Results!$D$74^$A75","v":1.8436663555517192E-3},{"$f":"I75*Results!$D$74^$A75","v":1.443797830122245E-3},3.2874641856739644E-3,0.85720695078071285,0.66101700213004277,1.5182239529107555]
[59,0.41471867861985195,0.25053099812741886,0.15847258208215492,0.1013413606558094,5.056608497403825E-2,2.4370295540726287E-2,9.3358239682567457E-2,7.3110886622178864E-2,0.16646912630474631,{"$f":"H76*Results!$D$74^$A76","v":1.7238908750248497E-3},{"$f":"I76*Results!$D$74^$A76","v":1.350016782037555E-3},3.0739076570624048E-3,0.85893084165573774,0.66236701891208027,1.521297860567818]
[60,0.41468747801108152,0.25049141599691549,0.15847969642120302,0.10136906671910433,5.059127489810035E-2,2.4381067953594997E-2,9.3398365512315493E-2,7.3143203860784989E-2,0.1665415693731005,{"$f":"H77*Results!$D$74^$A77","v":1.6118054315758848E-3},{"$f":"I77*Results!$D$74^$A77","v":1.2622556360489005E-3},2.8740610676247853E-3,0.86054264708731365,0.66362927454812914,1.5241719216354428]
[61,0.41466888561755383,0.25045385958200334,0.15848185232380646,0.10139119719005804,5.061373453397594E-2,2.4390470752602107E-2,9.3433278883607321E-2,7.3171412257806323E-2,0.16660469114141363,{"$f":"H78*Results!$D$74^$A78","v":1.5069233110075002E-3},{"$f":"I78*Results!$D$74^$A78","v":1.1801331190355328E-3},2.687056430043033E-3,0.8620495703983212,0.66480940766716468,1.5268589780654858]
[62,0.41466078997477079,0.25041887311037514,0.15848001192532934,0.10140833033814711,5.0633450031893519E-2,2.4398544619483785E-2,9.3463156898644761E-2,7.3195633858451348E-2,0.16665879075709611,{"$f":"H79*Results!$D$74^$A79","v":1.4087899006276891E-3},{"$f":"I79*Results!$D$74^$A79","v":1.1032932459327576E-3},2.512083146560447E-3,0.86345836029894885,0.6659127009130974,1.5293710612120464]
[63,0.41466124453573677,0.25038682348068064,0.15847504210836758,0.10142105351301117,5.0650480510492792E-2,2.4405355851710733E-2,9.3488269008531882E-2,7.32160675551322E-2,0.16670433656366407,{"$f":"H80*Results!$D$74^$A80","v":1.3169798324887507E-3},{"$f":"I80*Results!$D$74^$A80","v":1.0314030349138591E-3},2.3483828674026098E-3,0.86477534013143764,0.66694410394801129,1.531719444079449]
[64,0.41466848358316627,0.25035792726576084,0.15846771188951053,0.10142994627118847,5.066494157708288E-2,2.4410989413290691E-2,9.3508951182407499E-2,7.3232968239872076E-2,0.16674191942227956,{"$f":"H81*Results!$D$74^$A81","v":1.2310945650600602E-3},{"$f":"I81*Results!$D$74^$A81","v":9.6415057642400704E-4},2.1952451414840673E-3,0.86600643469649774,0.66790825452443525,1.533914689220933]
[65,0.41468093025624114,0.2503322760177783,0.15845869284337996,0.10143556716355599,5.067699078493984E-2,2.4415542934104473E-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":9.3525583675656984E-2},{"$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":7.3246628802313418E-2},0.16677221247797042,{"$f":"H82*Results!$D$74^$A82","v":1.1507603183074473E-3},{"$f":"I82*Results!$D$74^$A82","v":9.0124338777515284E-4},2.0520037060826001E-3,0.86715719501480515,0.66880949791221045,1.5359666929270155]
[66,0.41469719810441991,0.25030985957693602,0.15844856192998391,0.10143844377015891,5.0686815001949957E-2,2.4419121616551041E-2,9.3538572227058997E-2,7.3257364849653117E-2,0.16679593707671211,{"$f":"H83*Results!$D$74^$A83","v":1.0756262919951948E-3},{"$f":"I83*Results!$D$74^$A83","v":8.4240699679802061E-4},1.9180332887932154E-3,0.86823282130680035,0.6696519049090085,1.5378847262158089]
[67,0.4147160874564681,0.25029058719768921,0.15843780616006864,0.10143906557090671,5.0694619621323045E-2,2.4421833993543987E-2,9.3548332461987238E-2,7.3265501980631961E-2,0.16681383444261921,{"$f":"H84*Results!$D$74^$A84","v":1.0053631099772645E-3},{"$f":"I84*Results!$D$74^$A84","v":7.8738370836513001E-4},1.7927468183423945E-3,0.86923818441677758,0.67043928861737367,1.5396774730341511]
[68,0.41473657776112682,0.25027430640030368,0.15842682860215909,0.10143787925255832,5.070061951223015E-2,2.4423788471621591E-2,9.3555277242566626E-2,7.3271365414864773E-2,0.16682664265743141,{"$f":"H85*Results!$D$74^$A85","v":9.3966144436761828E-4},{"$f":"I85*Results!$D$74^$A85","v":7.3593151648738053E-4},1.6755929608549989E-3,0.87017784586114522,0.67117522013386111,1.5413530659950063]
[69,0.41475781692155578,0.25026081953264595,0.15841595530251212,0.10143528607212665,5.0705031584704158E-2,2.4425090586455013E-2,9.3559806683518543E-2,7.3275271759365046E-2,0.16683507844288359,{"$f":"H86*Results!$D$74^$A86","v":8.7823078289423319E-4},{"$f":"I86*Results!$D$74^$A86","v":6.8782313223132371E-4},1.5660539151255569E-3,0.8710560766440395,0.67186304326609247,1.542919119910132]
[70,0.41477910851283201,0.25024989808870574,0.1584054427538428,0.10143164092220741,5.0708068827662919E-2,2.4425840894748821E-2,9.3562300541999793E-2,7.3277522684246463E-2,0.16683982322624624,{"$f":"H87*Results!$D$74^$A87","v":8.2079831059878928E-4},{"$f":"I87*Results!$D$74^$A87","v":6.4284510401809325E-4},1.4636434146168826E-3,0.87187687495463828,0.6725058883701106,1.5443827633247489]
[71,0.41479989764345448,0.25024129487813968,0.15839548560936487,0.10142725277296612,5.0709935670218663E-2,2.4426133425855874E-2,9.3563112688907976E-2,7.3278400277567629E-2,0.16684151296647559,{"$f":"H88*Results!$D$74^$A88","v":7.6710788351162633E-4},{"$f":"I88*Results!$D$74^$A88","v":6.007970120761783E-4},1.3679048955878045E-3,0.87264398283814992,0.67310668538218676,1.5457506682203368]
[72,0.41481975610035388,0.25023475417669933,0.1583862243946737,0.10142238619706342,5.0710824513355554E-2,2.4426054617853788E-2,9.3562567375938821E-2,7.3278163853561368E-2,0.16684073122950019,{"$f":"H89*Results!$D$74^$A89","v":7.1691907718158534E-4},{"$f":"I89*Results!$D$74^$A89","v":5.6149072306203461E-4},1.2784098002436199E-3,0.87336090191533156,0.67366817610524876,1.5470290780205804]
[73,0.41483836730402668,0.25023002001236483,0.15837775302082527,0.10141726371637963,5.0710913280516377E-2,2.442568266588694E-2,9.3560957025402069E-2,7.3277047997660827E-2,0.1668380050230629,{"$f":"H90*Results!$D$74^$A90","v":6.7000629714120033E-4},{"$f":"I90*Results!$D$74^$A90","v":5.2474969426639158E-4},1.1947559914075919E-3,0.87403090821247276,0.67419292579951517,1.548223834011988]
[74,0.4148555114972311,0.25022684275788737,0.1583701259473885,0.10141206874197044,5.071036384067E-2,2.4425087214852311E-2,9.3558541286887981E-2,7.327526164455693E-2,0.1668338029314449,{"$f":"H91*Results!$D$74^$A91","v":6.2615794169836633E-4},{"$f":"I91*Results!$D$74^$A91","v":4.9040831951486683E-4},1.1165662612132332E-3,0.87465706615417116,0.67468333411903003,1.5493404002732012]
[75,0.41487105149784659,0.25022498420870509,0.15836336488421768,0.10140694891041604,5.0709321165172884E-2,2.4424329333641408E-2,9.3555547125000402E-2,7.3272988000924216E-2,0.1668285351259246,{"$f":"H92*Results!$D$74^$A92","v":5.8517561001210068E-4},{"$f":"I92*Results!$D$74^$A92","v":4.583113109643949E-4},1.0434869209764955E-3,0.8752422417641833,0.67514164542999444,1.5503838871941777]
[76,0.41488491926425786,0.25022422132718936,0.15835746495530426,0.10140201964997735,5.0707913089435445E-2,2.4423461713835443E-2,9.3552169724391149E-2,7.3270385141506328E-2,0.16682255486589748,{"$f":"H93*Results!$D$74^$A93","v":5.4687335036343154E-4},{"$f":"I93*Results!$D$74^$A93","v":4.2831311259590709E-4},9.7518646295933868E-4,0.87578911511454671,0.67556995854259039,1.551359073657137]
[77,0.41489710344990904,0.25022434883113798,0.15835240027753819,0.10139736783827556,5.070625056140942E-2,2.4422529041729465E-2,9.3548574021297834E-2,7.3267587125188396E-2,0.16681616114648623,{"$f":"H94*Results!$D$74^$A94","v":5.1107694498826045E-4},{"$f":"I94*Results!$D$74^$A94","v":4.0027734240051001E-4},9.113542873887704E-4,0.87630019205953502,0.67597023588499094,1.5522704279445261]
[78,0.41490763806215569,0.25022518079746942,0.15834812893183856,0.10139305543924161,5.0704428270674874E-2,2.4421568498619539E-2,9.3544896693917759E-2,7.3264705495858617E-2,0.16680960218977636,{"$f":"H95*Results!$D$74^$A95","v":4.7762322889714255E-4},{"$f":"I95*Results!$D$74^$A95","v":3.7407626113082707E-4},8.5169949002796962E-4,0.87677781528843213,0.67634431214612178,1.5531221274345539]
[79,0.4149165922887017,0.25022655144216682,0.15834459732426603,0.10138912303064082,5.0702525563969994E-2,2.4420610350254314E-2,9.3541248466621027E-2,7.3261831050762949E-2,0.16680307951738399,{"$f":"H96*Results!$D$74^$A96","v":4.4635944085242278E-4},{"$f":"I96*Results!$D$74^$A96","v":3.495902661093109E-4},7.9594970696173373E-4,0.8772241747292846,0.67669390241223104,1.5539180771415158]
[80,0.41492406151208705,0.25022831522553435,0.15834174395081022,0.10138559315447083,5.0700607565002602E-2,2.4419678592094669E-2,9.3537716604731619E-2,7.3259035776284009E-2,0.16679675238101563,{"$f":"H97*Results!$D$74^$A97","v":4.1714260517743736E-4},{"$f":"I97*Results!$D$74^$A97","v":3.2670740900853188E-4},7.4385001418596924E-4,0.87764131733446205,0.67702060982123957,1.5546619271557016]
[81,0.41493015949813067,0.25023034641848907,0.15833950259197455,0.10138247344094656,5.069872642801676E-2,2.4418791622442142E-2,9.3534367497024429E-2,7.3256374867326418E-2,0.16679074236435085,{"$f":"H98*Results!$D$74^$A98","v":3.898389433944924E-4},{"$f":"I98*Results!$D$74^$A98","v":3.0532293679216778E-4},6.9516188018666023E-4,0.87803115627785655,0.67732593275803177,1.5553570890358883]
[82,0.41493501171712333,0.25023253825154279,0.15833780497249575,0.10137975947268353,5.0696922665638286E-2,2.4417962920516047E-2,9.3531249241944156E-2,7.3253888761548147E-2,0.16678513800349232,{"$f":"H99*Results!$D$74^$A99","v":3.6432331487606278E-4},{"$f":"I99*Results!$D$74^$A99","v":2.8533885516843162E-4},6.496621700444944E-4,0.87839547959273256,0.67761127161320023,1.5560067512059328]
[83,0.41493874973606992,0.25023480175383445,0.15833658292795366,0.10137743736918053,5.069522650182607E-2,2.4417201711135102E-2,9.3528394170688589E-2,7.3251605133405312E-2,0.1667799993040939,{"$f":"H100*Results!$D$74^$A100","v":3.4047868578552983E-4},{"$f":"I100*Results!$D$74^$A100","v":2.6666351399112011E-4},6.0714219977664994E-4,0.87873595827851814,0.6778779351271913,1.5566138934057094]
[84,0.41494150660556622,0.25023706437547022,0.1583357701240633,0.10137548608293259,5.0693659210202496E-2,2.4416513601764861E-2,9.3525821255628333E-2,7.3249540805294583E-2,0.16677536206092292,{"$f":"H101*Results!$D$74^$A101","v":3.1819562561006908E-4},{"$f":"I101*Results!$D$74^$A101","v":2.4921121407194647E-4},5.6740683968201555E-4,0.87905415390412822,0.67812714634126325,1.5571813002453916]
[85,0.41494341315515326,0.25023926847283406,0.15833530337647922,0.10137387940765379,5.0692234406559747E-2,2.4415901181319616E-2,9.3523538366036177E-2,7.3247703543958848E-2,0.16677124190999504,{"$f":"H102*Results!$D$74^$A102","v":2.9737183057234777E-4},{"$f":"I102*Results!$D$74^$A102","v":2.3290183486040903E-4},5.302736654327568E-4,0.87935152573470055,0.67836004817612361,1.557711573910824]
[86,0.41494459510545001,0.25024136972369038,0.1583351236193378,0.10137258770634838,5.069095927191139E-2,2.441536457326178E-2,9.3521544344802449E-2,7.3246093719785341E-2,0.16676763806458778,{"$f":"H103*Results!$D$74^$A103","v":2.7791167316717428E-4},{"$f":"I103*Results!$D$74^$A103","v":2.1766048241863217E-4},4.955721555858065E-4,0.8796294374078677,0.67857770865854228,1.55820714606641]
[87,0.41494517090330346,0.2502433355269868,0.15833517656984775,0.10137157937254077,5.0689835689081336E-2,2.4414901938239579E-2,9.3519830889789074E-2,7.324470581471873E-2,0.1667645367045078,{"$f":"H104*Results!$D$74^$A104","v":2.5972577701713974E-4},{"$f":"I104*Results!$D$74^$A104","v":2.0341715707910578E-4},4.6314293409624549E-4,0.87988916318488486,0.67878112581562133,1.5586702890005062]
[88,0.41494525018695394,0.2502451434313902,0.158335413134301,0.10137082204206357,5.0688861281521197E-2,2.4414509923769794E-2,9.3518384231819976E-2,7.3243529771309379E-2,0.16676191400312934,{"$f":"H105*Results!$D$74^$A105","v":2.4273061618683569E-4},{"$f":"I105*Results!$D$74^$A105","v":1.901064401307266E-4},4.3283705631756231E-4,0.88013189380107171,0.67897123225575207,1.5591031260568238]
[89,0.41494493279118994,0.25024677962682301,0.15833578959817507,0.10137028357560875,5.0688030347865828E-2,2.4414184060337137E-2,9.3517186608145453E-2,7.3242552181011417E-2,0.16675973878915687,{"$f":"H106*Results!$D$74^$A106","v":2.2684813804471648E-4},{"$f":"I106*Results!$D$74^$A106","v":1.7766719883827479E-4},4.0451533688299127E-4,0.88035874193911645,0.67914889945459034,1.5595076413937068]
[90,0.4149443082071384,0.25024823752462499,0.15833626763976386,0.10136993283395943,5.0687334689732771E-2,2.4413919104780239E-2,9.3516217535683205E-2,7.3241757314340711E-2,0.16675797485002392,{"$f":"H107*Results!$D$74^$A107","v":2.1200540871905762E-4},{"$f":"I107*Results!$D$74^$A107","v":1.6604230906584635E-4},3.7804771778490395E-4,0.88057074734783547,0.67931494176365614,1.5598856891114916]
[91,0.41494345541722588,0.25024951644444571,0.15833681420319123,0.10136974026862279,5.0686764333511367E-2,2.4413709333002721E-2,9.3515454892572722E-2,7.3241127999008171E-2,0.16675658289158091,{"$f":"H108*Results!$D$74^$A108","v":1.9813428016199493E-4},{"$f":"I108*Results!$D$74^$A108","v":1.5517839474776023E-4},3.5331267490975519E-4,0.88076888162799749,0.67947012015840391,1.5602390017864014]
[92,0.4149424430325615,0.25025062041952861,0.15833740126290091,0.1013696783506402,5.0686308149443506E-2,2.4413548784924931E-2,9.3514875819727505E-2,7.3240646354774785E-2,0.16675552217450229,{"$f":"H109*Results!$D$74^$A109","v":1.8517107781425158E-4},{"$f":"I109*Results!$D$74^$A109","v":1.4502558343199007E-4},3.3019666124624162E-4,0.88095405270581173,0.6796151457418359,1.5605691984476477]
[93,0.41494132966718811,0.25025155712663233,0.15833800550790542,0.10136972185981412,5.0685954373245523E-2,2.4413431465214123E-2,9.3514457456272876E-2,7.3240294395642364E-2,0.16675475185191524,{"$f":"H110*Results!$D$74^$A110","v":1.730563078529063E-4},{"$f":"I110*Results!$D$74^$A110","v":1.3553727711136459E-4},3.0859358496427089E-4,0.88112710901366464,0.67975068301894725,1.560877792032612]
[94,0.41494016449104354,0.25025233694236548,0.15833860797032487,0.10136984805559612,5.0685691036934266E-2,2.4413351503735341E-2,9.3514177524152489E-2,7.3240054511206021E-2,0.1667542320353585,{"$f":"H111*Results!$D$74^$A111","v":1.6173438300481828E-4},{"$f":"I111*Results!$D$74^$A111","v":1.2666993755625739E-4},2.8840432056107565E-4,0.88128884339666946,0.67987735295650353,1.5611661963531729]
[95,0.41493898791083678,0.25025297212411857,0.15833919361913815,0.10137003674954614,5.0685506316474109E-2,2.4413303279885869E-2,9.3514014777907051E-2,7.3239909839657613E-2,0.16675392461756466,{"$f":"H112*Results!$D$74^$A112","v":1.5115336591811182E-4},{"$f":"I112*Results!$D$74^$A112","v":1.1838288536852245E-4},2.6953625128663426E-4,0.88143999676258755,0.67999573584187201,1.5614357326044597]
[96,0.41493783233519699,0.25025347611096382,0.15833975093666519,0.10137027029770397,5.0685388804424657E-2,2.4413281515045043E-2,9.3513949335790464E-2,7.323984454513513E-2,0.16675379388092559,{"$f":"H113*Results!$D$74^$A113","v":1.4126472910220132E-4},{"$f":"I113*Results!$D$74^$A113","v":1.1063811198909617E-4},2.519028410912975E-4,0.8815812614916898,0.68010637395386109,1.5616876354455509]
[97,0.41493672298725193,0.25025386293777713,0.15834027149214683,0.10137053352949833,5.0685327716007464E-2,2.4413281337318009E-2,9.3513962908105347E-2,7.3239844011954019E-2,0.16675380692005937,{"$f":"H114*Results!$D$74^$A114","v":1.3202313047187974E-4},{"$f":"I114*Results!$D$74^$A114","v":1.0340010390996094E-4},2.3542323438184066E-4,0.8817132846221617,0.68020977405777105,1.5619230586799326]
[98,0.41493567873413933,0.25025414675432783,0.15834074952391536,0.10137081362802963,5.0685313036984814E-2,2.4413298322602722E-2,9.3514038938008096E-2,7.3239894967808167E-2,0.16675393390581628,{"$f":"H115*Results!$D$74^$A115","v":1.2338620356167485E-4},{"$f":"I115*Results!$D$74^$A115","v":9.663567836401863E-5},2.2002188192569348E-4,0.88183667082572337,0.6803064097361351,1.5621430805618584]
[99,0.41493471290877748,0.25025434144009218,0.15834118153907156,0.10137109997476182,5.0685335621508662E-2,2.4413328515788021E-2,9.3514162669141976E-2,7.3239985547364064E-2,0.16675414821650603,{"$f":"H116*Results!$D$74^$A116","v":1.1531436151171504E-4},{"$f":"I116*Results!$D$74^$A116","v":9.031382979284731E-5},2.0562819130456235E-4,0.88195198518723505,0.68039672356592795,1.5623487087531629]
[100,0.4149338341044822,0.25025446030499615,0.15834156593730744,0.10137138396989394,5.0685387247702787E-2,2.4413368435617214E-2,9.3514321153381597E-2,7.3240105306851641E-2,0.16675442646023325,{"$f":"H117*Results!$D$74^$A117","v":1.0777061396458037E-4},{"$f":"I117*Results!$D$74^$A117","v":8.4405586421395915E-5},1.9217620038597627E-4,0.88205975580119966,0.68048112915234937,1.5625408849535489]
[]
["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"}]