{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","Ranking Report","Data Input","Ranking Calculations","Relative Ranking Calculations","Criteria & Importance"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":0,"defined_names":118,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Station Placement Optimization Tool (SPOT)"]
[]
[null,"What is this tool?"]
[null,"This ranking tool is intended to assist in ranking locations for Environmental Sensor Station (ESS) placement around the state of New Mexico, for the purpose of determining ideal locations to expand the NMDOT Road Weather Information System (RWIS). This tool takes in environmental and topological data about a location and outputs a ranking on a scale from 1 to 10."]
[]
[null,"How do I use it?"]
[null,"If you have not yet input any site data into the tool, use the Launch Data Entry Form button below to open the data entry form. Fill in all available data for your chosen location and follow any instructions that pop up. Once you have submitted data for at least two locations, you can press the Launch Ranking Report button to open the site ranking report for the locations you have entered data for. To clear data for a site, go to the Data Input sheet, highlight the row the site is in, and delete the data in that row."]

{"sheet":"Ranking Report","index":1,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,13]]}
[]
[null,"SPOT Site Ranking Report"]
[]
[null,"Location","Latitude","Longitude","Absolute Ranking","Relative Ranking","Flags",null,"Flag Codes:"]
[null,"NM-150 MM10 (Taos Ski Valley)",36.57,-105.51,56.4,50.625833096321479,"1,2,",null,"1: Power lines are not available nearby"]
[null,"I-40 MM180 (West of Edgewood)",35.11,-106.3,52.716203146168894,26.74417992569046,null,null,"2: Communcation lines are not available nearby"]
[null,"I-40 MM173 (Tijeras Canyon)",35.08,-106.41,50.81035245242564,31.271434343359317,null,null,"3: Site is on or near Tribal Lands"]
[null,"US-64 MM390 (Des Moines)",36.71,-103.8,50.449999999999996,25.543148866105788]
[null,"NM-38 MM18 (Red River)",36.67,-105.33,49.530073260073259,41.202320773232906,"1,2,"]
[null,"I-40/US-285 (Clines Corners)",35.01,-105.67,47.394523809523797,23.96667496104293]
[null,"US-64 MM273 (Palo Flechado Pass)",36.414000000000001,-105.337,47.026136534698175,33.58576389318462]
[null,"I-25 MM331 (Serafina)",35.39,-105.33,46.353373015873004,24.380048700860627,"1,2,"]
[null,"US-60 MM260 (West of Vaughn)",34.61,-105.37,43.3595238095238,28.755337578940964,"1,2,"]
[null,"I-40 MM70 (West of Grants)",35.29,-107.99,43.217669976222588,22.938324645584125,"1,2,"]
[null,"NM-550 MM110",36.25,-107.66,41.68630952380952,19.829426684270423,"1,2,"]
[null,"I-25 MM268 (La Bajada)",35.520000000000003,-106.19,41.160656448814336,22.339887114956259,"1,2,"]
[null,"NM-68 MM16 (Velarde)",36.19,-105.98,36.935543184885297,19.036809580359883]
[null,"I-25 MM257 (San Felipe Pueblo)",35.46,-106.34,29.809737484737493,14.542534151939771,"3,"]
[null,"NM-550 MM27 (San Ysidro)",35.54,-106.83,29.294071956571944,14.949062738734584,"1,2,"]
[null,"US-70 MM255 (South of Ruidoso)",33.270000000000003,-105.7,29.174343711843708,14.593557439235749,"1,2,3,"]
[null,"I-25/I-40 (The Big I)",35.1,-106.63,28.143888888888892,26.620838683108094]
[null,"NM-602 MM25 (South of Gallup)",35.450000000000003,-108.75,27.256281205043578,14.298170898915746,"1,2,3,"]
[null,"I-40 MM320 (West of Tucumcari)",35.119999999999997,-103.93,25.129548229548234,15.045375617421358,"1,2,"]
[null,"US-70 MM435 (South of Clovis)",34.31,-103.2,14.982142857142858,10.036832975950336]

{"sheet":"Data Input","index":2,"n_rows":21,"n_cols":52,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Location","Poor Weather Crashes","Clear Weather Crashes",{"$f":"'Criteria & Importance'!B1","v":"Ratio of Weather to Clear Crashes"},{"$f":"'Criteria & Importance'!C1","v":"Average annual snow (in)"},{"$f":"'Criteria & Importance'!D1","v":"2013 AADT"},{"$f":"'Criteria & Importance'!E1","v":"Average Wind Gust"},{"$f":"'Criteria & Importance'!F1","v":"Local Altitude Range (meters)"},{"$f":"'Criteria & Importance'!G1","v":"Dist Patrol Yard (mi)"},{"$f":"'Criteria & Importance'!H1","v":"Altitude (Meters)"},{"$f":"'Criteria & Importance'!I1","v":"Snow Removal Priority"},{"$f":"'Criteria & Importance'!J1","v":"Average Road Grade 2 Miles"},{"$f":"'Criteria & Importance'!K1","v":"Average Annual Rain (in)"},{"$f":"'Criteria & Importance'!L1","v":"Dist ITS Unit (mi)"},{"$f":"'Criteria & Importance'!M1","v":"Fire Risk (0 Very High, 5 No Risk)"},{"$f":"'Criteria & Importance'!N1","v":"Distance to Power (mi)"},{"$f":"'Criteria & Importance'!O1","v":"Distance to Communication (mi)"},{"$f":"'Criteria & Importance'!P1","v":"Local Environment"},{"$f":"'Criteria & Importance'!Q1","v":"Functional Class"},{"$f":"'Criteria & Importance'!R1","v":"In Tribal Land?"},"T Land BOOL","Latitude","Longitude","Length of AADT Road Segment (mi)",{"$f":"'Criteria & Importance'!S1","v":"Ratio of Crash Rates Per 100M Vehicle Miles"},{"$f":"'Criteria & Importance'!U1","v":"Comment 1"},{"$f":"'Criteria & Importance'!V1","v":"Comment 2"}]
["NM-150 MM10 (Taos Ski Valley)",12,9,1.3333333333333333,62.5,800,0,900,8,2650,4,0,21,12,4,15,15,null,null,"NO",0,36.57,-105.51,7.59,20.053623388942029,"District 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56.4]
["I-40 MM180 (West of Edgewood)",44,73,0.60273972602739723,25.6,28900,0,100,3.5,2100,8,0,19.5,2.5,4,1,1,null,null,"NO",0,35.11,-106.3,3.01,0.63277798156224885,"District 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52.716203146168894]
["I-40 MM173 (Tijeras Canyon)",43,164,0.26219512195121952,20.5,67600,0,900,3,1900,10,0,20,2,1.5,0,0,null,null,"NO",0,35.08,-106.41,5.13,6.9047256524289086E-2,"District 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50.81035245242564]
["US-64 MM390 (Des Moines)",14,17,0.82352941176470584,35.5,3800,0,200,4,1970,4,0,18,15.5,4,0,0,null,null,"NO",0,36.71,-103.8,18.39,1.0762165573103804,"District 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50.449999999999996]
["NM-38 MM18 (Red River)",10,21,0.47619047619047616,85,700,0,600,8.1,2750,4,0,19.7,70,3,7,7,null,null,"NO",0,36.67,-105.33,16.579999999999998,3.7470028192823919,"District 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49.530073260073259]
["I-40/US-285 (Clines Corners)",15,17,0.88235294117647056,31.4,16000,0,20,0.5,2152,10,0,15,0,4,0,0,null,null,"NO",0,35.01,-105.67,0.64,7.8691579371474614,"District 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47.394523809523797]
["US-64 MM273 (Palo Flechado Pass)",23,73,0.31506849315068491,55,1400,0,400,11.5,2780,5,0,24.6,19.5,2,0,0,null,null,"NO",0,36.414000000000001,-105.337,18.89,1.0880049296651879,"District 4/5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47.026136534698175]
["I-25 MM331 (Serafina)",16,30,0.53333333333333333,34.5,8700,0,100,14,1950,7,0,17.5,38,3,15,15,null,null,"NO",0,35.39,-105.33,4.9800000000000004,1.1241804110017635,"District 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46.353373015873004]
["US-60 MM260 (West of Vaughn)",9,8,1.125,21,2500,0,100,8,1880,10,0,15,32,4,7,7,null,null,"NO",0,34.61,-105.37,13.62,3.0173194134331061,"District 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43.3595238095238]
["I-40 MM70 (West of Grants)",52,76,0.68421052631578949,20.5,23100,0,50,7,2060,9,0,11,50,4,6,6,null,null,"NO",0,35.29,-107.99,8.43,0.32087514479938284,"District 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43.217669976222588]
["NM-550 MM110",44,52,0.84615384615384615,26.4,5700,0,200,37,2100,5,0,10.5,65,3,40,40,null,null,"NO",0,36.25,-107.66,20.67,0.65587319404906086,"District 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41.68630952380952]
["I-25 MM268 (La Bajada)",24,95,0.25263157894736843,20.5,33800,0,75,9,1850,8,0,13.5,3,4,7,7,null,null,"NO",0,35.520000000000003,-106.19,3.96,0.17236997992363751,"District 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41.160656448814336]
["NM-68 MM16 (Velarde)",16,57,0.2807017543859649,31.1,5700,0,360,7.5,1770,4,0,12.6,12,1,0,0,null,null,"NO",0,36.19,-105.98,8.8800000000000008,0.50645770930621481,"District 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36.935543184885297]
["I-25 MM257 (San Felipe Pueblo)",23,84,0.27380952380952384,20.5,25000,0,50,22,1670,8,0,13,14,4,0,0,null,null,"YES",1,35.46,-106.34,4.46,0.22426399968018007,"District 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29.809737484737493]
["NM-550 MM27 (San Ysidro)",19,37,0.51351351351351349,20.2,5100,0,150,3.5,1680,3,0,13,100,4,3.5,3.5,null,null,"NO",0,35.54,-106.83,25.95,0.35434819056082906,"District 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29.294071956571944]
["US-70 MM255 (South of Ruidoso)",23,225,0.10222222222222223,23,7300,0,200,25,2200,5,0,20,90,2,7,7,null,null,"YES",1,33.270000000000003,-105.7,11.64,0.10986398766676428,"District 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29.174343711843708]
["I-25/I-40 (The Big I)",260,4879,5.3289608526337365E-2,12.5,180400,0,50,3,1536,22,0,11,0.5,5,0,0,null,null,"NO",0,35.1,-106.63,1.44,1.8733951233552166E-2,"District 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28.143888888888892]
["NM-602 MM25 (South of Gallup)",35,202,0.17326732673267325,26.5,8200,0,100,5,2060,3,0,13,29,4,4,4,null,null,"YES",1,35.450000000000003,-108.75,23.95,8.0571822181552025E-2,"District 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27.256281205043578]
["I-40 MM320 (West of Tucumcari)",8,30,0.26666666666666666,15.4,21000,0,20,13,1370,7,0,17,130,2,10,10,null,null,"NO",0,35.119999999999997,-103.93,10.26,0.11302849829913303,"District 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25.129548229548234]
["US-70 MM435 (South of Clovis)",19,365,5.2054794520547946E-2,10,16800,0,20,4,1300,5,0,19,4,4,1,1,null,null,"NO",0,34.31,-103.2,11.48,2.4648781075224252E-2,"District 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.982142857142858]

{"sheet":"Ranking Calculations","index":3,"n_rows":21,"n_cols":23,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Data Input'!A1","v":"Location"},"Ranking (1 to 100)",{"$f":"'Criteria & Importance'!B1","v":"Ratio of Weather to Clear Crashes"},{"$f":"'Criteria & Importance'!C1","v":"Average annual snow (in)"},{"$f":"'Criteria & Importance'!D1","v":"2013 AADT"},{"$f":"'Criteria & Importance'!E1","v":"Average Wind Gust"},{"$f":"'Criteria & Importance'!F1","v":"Local Altitude Range (meters)"},{"$f":"'Criteria & Importance'!G1","v":"Dist Patrol Yard (mi)"},{"$f":"'Criteria & Importance'!H1","v":"Altitude (Meters)"},{"$f":"'Criteria & Importance'!I1","v":"Snow Removal Priority"},{"$f":"'Criteria & Importance'!J1","v":"Average Road Grade 2 Miles"},{"$f":"'Criteria & Importance'!K1","v":"Average Annual Rain (in)"},{"$f":"'Criteria & Importance'!L1","v":"Dist ITS Unit (mi)"},{"$f":"'Criteria & Importance'!M1","v":"Fire Risk (0 Very High, 5 No Risk)"},{"$f":"'Criteria & Importance'!N1","v":"Distance to Power (mi)"},{"$f":"'Criteria & Importance'!O1","v":"Distance to Communication (mi)"},{"$f":"'Criteria & Importance'!P1","v":"Local Environment"},{"$f":"'Criteria & Importance'!Q1","v":"Functional Class"},{"$f":"'Criteria & Importance'!R1","v":"In Tribal Land?"},{"$f":"'Criteria & Importance'!S1","v":"Ratio of Crash Rates Per 100M Vehicle Miles"},{"$f":"'Criteria & Importance'!T1","v":"Number of Weather Related Crashes"},{"$f":"'Criteria & Importance'!U1","v":"Comment 1"},{"$f":"'Criteria & Importance'!V1","v":"Comment 2"}]
["NM-150 MM10 (Taos Ski Valley)",56.4,{"$f":"IF(1.33333333333333<=Ratio_Max, IF(1.33333333333333<=Ratio_Min, 0, (Ratio_Points*((1.33333333333333-Ratio_Min)/(Ratio_Max-Ratio_Min)))), Ratio_Points)","v":16},{"$f":"IF(62.5<=Snow_Max, IF(62.5<=Snow_Min, 0, (Snow_Points*((62.5-Snow_Min)/(Snow_Max-Snow_Min)))), Snow_Points)","v":15},{"$f":"IF(800<=AADT_Max, IF(800<=AADT_Min, 0, (AADT_Points*((800-AADT_Min)/(AADT_Max-AADT_Min)))), AADT_Points)","v":0},{"$f":"IF(0<=Wind_Max, IF(0<=Wind_Min, 0, (Wind_Points*((0-Wind_Min)/(Wind_Max-Wind_Min)))), Wind_Points)","v":0},{"$f":"IF(900<=Topo_Max, IF(900<=Topo_Min, 0, (Topo_Points*((900-Topo_Min)/(Topo_Max-Topo_Min)))), Topo_Points)","v":9},{"$f":"IF((8-DPatrol_Best)>0, IF(8>=DPatrol_Max, 0, (DPatrol_Points*(1-((8-DPatrol_Best)/(DPatrol_Max-DPatrol_Best))))), (DPatrol_Points*((DPatrol_Best-(DPatrol_Best-8))/DPatrol_Best)))","v":5.6000000000000005},{"$f":"IF(2650<=Alt_Max, IF(2650<=Alt_Min, 0, (Alt_Points*((2650-Alt_Min)/(Alt_Max-Alt_Min)))), Alt_Points)","v":6},{"$f":"IF(4<=SRP_Max, IF(4<=SRP_Min, 0, (SRP_Points*((4-SRP_Min)/(SRP_Max-SRP_Min)))), SRP_Points)","v":0},{"$f":"IF(0<=RGrade_Max, IF(0<=RGrade_Min, 0, (RGrade_Points*((0-RGrade_Min)/(RGrade_Max-RGrade_Min)))), RGrade_Points)","v":0},{"$f":"IF(21<=Rain_Max, IF(21<=Rain_Min, 0, (Rain_Points*((21-Rain_Min)/(Rain_Max-Rain_Min)))), Rain_Points)","v":4},{"$f":"IF((12-DITS_Best)>0, IF(12>=DITS_Max, 0, (DITS_Points*(1-((12-DITS_Best)/(DITS_Max-DITS_Best))))), (DITS_Points*((DITS_Best-(DITS_Best-12))/DITS_Best)))","v":0},{"$f":"IF(4<=Fire_Max, IF(4<=Fire_Min, 0, (Fire_Points*((4-Fire_Min)/(Fire_Max-Fire_Min)))), Fire_Points)","v":0.8},{"$f":"IF(15>=DPower_Max, 1, 0)","v":1},{"$f":"IF(15>=DComm_Max, 1, 0)","v":1},null,null,{"$f":"IF(0 = 1, 1, 0)","v":0},{"$f":"IF(20.053623388942<=Rate_Max, IF(20.053623388942<=Rate_Min, 0, (Rate_Points*((20.053623388942-Rate_Min)/(Rate_Max-Rate_Min)))), Rate_Points)","v":0},{"$f":"IF(12<=WCrashNum_Max, IF(12<=WCrashNum_Min, 0, (WCrashNum_Points*((12-WCrashNum_Min)/(WCrashNum_Max-WCrashNum_Min)))), WCrashNum_Points)","v":0},"District 5"]
["I-40 MM180 (West of Edgewood)",52.716203146168894,{"$f":"IF(0.602739726027397<=Ratio_Max, IF(0.602739726027397<=Ratio_Min, 0, (Ratio_Points*((0.602739726027397-Ratio_Min)/(Ratio_Max-Ratio_Min)))), Ratio_Points)","v":12.375131717597466},{"$f":"IF(25.6<=Snow_Max, IF(25.6<=Snow_Min, 0, (Snow_Points*((25.6-Snow_Min)/(Snow_Max-Snow_Min)))), Snow_Points)","v":10.200000000000001},{"$f":"IF(28900<=AADT_Max, IF(28900<=AADT_Min, 0, (AADT_Points*((28900-AADT_Min)/(AADT_Max-AADT_Min)))), AADT_Points)","v":8.9625000000000004},0,{"$f":"IF(100<=Topo_Max, IF(100<=Topo_Min, 0, (Topo_Points*((100-Topo_Min)/(Topo_Max-Topo_Min)))), Topo_Points)","v":4},{"$f":"IF((3.5-DPatrol_Best)>0, IF(3.5>=DPatrol_Max, 0, (DPatrol_Points*(1-((3.5-DPatrol_Best)/(DPatrol_Max-DPatrol_Best))))), (DPatrol_Points*((DPatrol_Best-(DPatrol_Best-3.5))/DPatrol_Best)))","v":2.4499999999999997},{"$f":"IF(2100<=Alt_Max, IF(2100<=Alt_Min, 0, (Alt_Points*((2100-Alt_Min)/(Alt_Max-Alt_Min)))), Alt_Points)","v":3.5},{"$f":"IF(8<=SRP_Max, IF(8<=SRP_Min, 0, (SRP_Points*((8-SRP_Min)/(SRP_Max-SRP_Min)))), SRP_Points)","v":3.4285714285714284},0,{"$f":"IF(19.5<=Rain_Max, IF(19.5<=Rain_Min, 0, (Rain_Points*((19.5-Rain_Min)/(Rain_Max-Rain_Min)))), Rain_Points)","v":4},{"$f":"IF((2.5-DITS_Best)>0, IF(2.5>=DITS_Max, 0, (DITS_Points*(1-((2.5-DITS_Best)/(DITS_Max-DITS_Best))))), (DITS_Points*((DITS_Best-(DITS_Best-2.5))/DITS_Best)))","v":3},{"$f":"IF(4<=Fire_Max, IF(4<=Fire_Min, 0, (Fire_Points*((4-Fire_Min)/(Fire_Max-Fire_Min)))), Fire_Points)","v":0.8},{"$f":"IF(1>=DPower_Max, 1, 0)","v":0},{"$f":"IF(1>=DComm_Max, 1, 0)","v":0},null,null,0,{"$f":"IF(0.632777981562249<=Rate_Max, IF(0.632777981562249<=Rate_Min, 0, (Rate_Points*((0.632777981562249-Rate_Min)/(Rate_Max-Rate_Min)))), Rate_Points)","v":0},{"$f":"IF(44<=WCrashNum_Max, IF(44<=WCrashNum_Min, 0, (WCrashNum_Points*((44-WCrashNum_Min)/(WCrashNum_Max-WCrashNum_Min)))), WCrashNum_Points)","v":0},"District 3"]
["I-40 MM173 (Tijeras Canyon)",50.81035245242564,{"$f":"IF(0.26219512195122<=Ratio_Max, IF(0.26219512195122<=Ratio_Min, 0, (Ratio_Points*((0.26219512195122-Ratio_Min)/(Ratio_Max-Ratio_Min)))), Ratio_Points)","v":3.9924953095684925},{"$f":"IF(20.5<=Snow_Max, IF(20.5<=Snow_Min, 0, (Snow_Points*((20.5-Snow_Min)/(Snow_Max-Snow_Min)))), Snow_Points)","v":6.375},{"$f":"IF(67600<=AADT_Max, IF(67600<=AADT_Min, 0, (AADT_Points*((67600-AADT_Min)/(AADT_Max-AADT_Min)))), AADT_Points)","v":15},0,{"$f":"IF(900<=Topo_Max, IF(900<=Topo_Min, 0, (Topo_Points*((900-Topo_Min)/(Topo_Max-Topo_Min)))), Topo_Points)","v":9},{"$f":"IF((3-DPatrol_Best)>0, IF(3>=DPatrol_Max, 0, (DPatrol_Points*(1-((3-DPatrol_Best)/(DPatrol_Max-DPatrol_Best))))), (DPatrol_Points*((DPatrol_Best-(DPatrol_Best-3))/DPatrol_Best)))","v":2.1},{"$f":"IF(1900<=Alt_Max, IF(1900<=Alt_Min, 0, (Alt_Points*((1900-Alt_Min)/(Alt_Max-Alt_Min)))), Alt_Points)","v":2.5},{"$f":"IF(10<=SRP_Max, IF(10<=SRP_Min, 0, (SRP_Points*((10-SRP_Min)/(SRP_Max-SRP_Min)))), SRP_Points)","v":5.1428571428571423},0,{"$f":"IF(20<=Rain_Max, IF(20<=Rain_Min, 0, (Rain_Points*((20-Rain_Min)/(Rain_Max-Rain_Min)))), Rain_Points)","v":4},{"$f":"IF((2-DITS_Best)>0, IF(2>=DITS_Max, 0, (DITS_Points*(1-((2-DITS_Best)/(DITS_Max-DITS_Best))))), (DITS_Points*((DITS_Best-(DITS_Best-2))/DITS_Best)))","v":2.4000000000000004},{"$f":"IF(1.5<=Fire_Max, IF(1.5<=Fire_Min, 0, (Fire_Points*((1.5-Fire_Min)/(Fire_Max-Fire_Min)))), Fire_Points)","v":0.3},{"$f":"IF(0>=DPower_Max, 1, 0)","v":0},{"$f":"IF(0>=DComm_Max, 1, 0)","v":0},null,null,0,{"$f":"IF(0.0690472565242891<=Rate_Max, IF(0.0690472565242891<=Rate_Min, 0, (Rate_Points*((0.0690472565242891-Rate_Min)/(Rate_Max-Rate_Min)))), Rate_Points)","v":0},{"$f":"IF(43<=WCrashNum_Max, IF(43<=WCrashNum_Min, 0, (WCrashNum_Points*((43-WCrashNum_Min)/(WCrashNum_Max-WCrashNum_Min)))), WCrashNum_Points)","v":0},"District 3"]
["US-64 MM390 (Des Moines)",50.449999999999996,{"$f":"IF(0.823529411764706<=Ratio_Max, IF(0.823529411764706<=Ratio_Min, 0, (Ratio_Points*((0.823529411764706-Ratio_Min)/(Ratio_Max-Ratio_Min)))), Ratio_Points)","v":16},{"$f":"IF(35.5<=Snow_Max, IF(35.5<=Snow_Min, 0, (Snow_Points*((35.5-Snow_Min)/(Snow_Max-Snow_Min)))), Snow_Points)","v":15},{"$f":"IF(3800<=AADT_Max, IF(3800<=AADT_Min, 0, (AADT_Points*((3800-AADT_Min)/(AADT_Max-AADT_Min)))), AADT_Points)","v":0},0,{"$f":"IF(200<=Topo_Max, IF(200<=Topo_Min, 0, (Topo_Points*((200-Topo_Min)/(Topo_Max-Topo_Min)))), Topo_Points)","v":9},{"$f":"IF((4-DPatrol_Best)>0, IF(4>=DPatrol_Max, 0, (DPatrol_Points*(1-((4-DPatrol_Best)/(DPatrol_Max-DPatrol_Best))))), (DPatrol_Points*((DPatrol_Best-(DPatrol_Best-4))/DPatrol_Best)))","v":2.8000000000000003},{"$f":"IF(1970<=Alt_Max, IF(1970<=Alt_Min, 0, (Alt_Points*((1970-Alt_Min)/(Alt_Max-Alt_Min)))), Alt_Points)","v":2.8499999999999996},{"$f":"IF(4<=SRP_Max, IF(4<=SRP_Min, 0, (SRP_Points*((4-SRP_Min)/(SRP_Max-SRP_Min)))), SRP_Points)","v":0},0,{"$f":"IF(18<=Rain_Max, IF(18<=Rain_Min, 0, (Rain_Points*((18-Rain_Min)/(Rain_Max-Rain_Min)))), Rain_Points)","v":4},{"$f":"IF((15.5-DITS_Best)>0, IF(15.5>=DITS_Max, 0, (DITS_Points*(1-((15.5-DITS_Best)/(DITS_Max-DITS_Best))))), (DITS_Points*((DITS_Best-(DITS_Best-15.5))/DITS_Best)))","v":0},{"$f":"IF(4<=Fire_Max, IF(4<=Fire_Min, 0, (Fire_Points*((4-Fire_Min)/(Fire_Max-Fire_Min)))), Fire_Points)","v":0.8},{"$f":"IF(0>=DPower_Max, 1, 0)","v":0},{"$f":"IF(0>=DComm_Max, 1, 0)","v":0},null,null,0,{"$f":"IF(1.07621655731038<=Rate_Max, IF(1.07621655731038<=Rate_Min, 0, (Rate_Points*((1.07621655731038-Rate_Min)/(Rate_Max-Rate_Min)))), Rate_Points)","v":0},{"$f":"IF(14<=WCrashNum_Max, IF(14<=WCrashNum_Min, 0, (WCrashNum_Points*((14-WCrashNum_Min)/(WCrashNum_Max-WCrashNum_Min)))), WCrashNum_Points)","v":0},"District 4"]
["NM-38 MM18 (Red River)",49.530073260073259,{"$f":"IF(0.476190476190476<=Ratio_Max, IF(0.476190476190476<=Ratio_Min, 0, (Ratio_Points*((0.476190476190476-Ratio_Min)/(Ratio_Max-Ratio_Min)))), Ratio_Points)","v":9.2600732600732538},{"$f":"IF(85<=Snow_Max, IF(85<=Snow_Min, 0, (Snow_Points*((85-Snow_Min)/(Snow_Max-Snow_Min)))), Snow_Points)","v":15},{"$f":"IF(700<=AADT_Max, IF(700<=AADT_Min, 0, (AADT_Points*((700-AADT_Min)/(AADT_Max-AADT_Min)))), AADT_Points)","v":0},0,{"$f":"IF(600<=Topo_Max, IF(600<=Topo_Min, 0, (Topo_Points*((600-Topo_Min)/(Topo_Max-Topo_Min)))), Topo_Points)","v":9},{"$f":"IF((8.1-DPatrol_Best)>0, IF(8.1>=DPatrol_Max, 0, (DPatrol_Points*(1-((8.1-DPatrol_Best)/(DPatrol_Max-DPatrol_Best))))), (DPatrol_Points*((DPatrol_Best-(DPatrol_Best-8.1))/DPatrol_Best)))","v":5.67},{"$f":"IF(2750<=Alt_Max, IF(2750<=Alt_Min, 0, (Alt_Points*((2750-Alt_Min)/(Alt_Max-Alt_Min)))), Alt_Points)","v":6},{"$f":"IF(4<=SRP_Max, IF(4<=SRP_Min, 0, (SRP_Points*((4-SRP_Min)/(SRP_Max-SRP_Min)))), SRP_Points)","v":0},0,{"$f":"IF(19.7<=Rain_Max, IF(19.7<=Rain_Min, 0, (Rain_Points*((19.7-Rain_Min)/(Rain_Max-Rain_Min)))), Rain_Points)","v":4},{"$f":"IF((70-DITS_Best)>0, IF(70>=DITS_Max, 0, (DITS_Points*(1-((70-DITS_Best)/(DITS_Max-DITS_Best))))), (DITS_Points*((DITS_Best-(DITS_Best-70))/DITS_Best)))","v":0},{"$f":"IF(3<=Fire_Max, IF(3<=Fire_Min, 0, (Fire_Points*((3-Fire_Min)/(Fire_Max-Fire_Min)))), Fire_Points)","v":0.6},{"$f":"IF(7>=DPower_Max, 1, 0)","v":1},{"$f":"IF(7>=DComm_Max, 1, 0)","v":1},null,null,0,{"$f":"IF(3.74700281928239<=Rate_Max, IF(3.74700281928239<=Rate_Min, 0, (Rate_Points*((3.74700281928239-Rate_Min)/(Rate_Max-Rate_Min)))), Rate_Points)","v":0},{"$f":"IF(10<=WCrashNum_Max, IF(10<=WCrashNum_Min, 0, (WCrashNum_Points*((10-WCrashNum_Min)/(WCrashNum_Max-WCrashNum_Min)))), WCrashNum_Points)","v":0},"District 4"]
["I-40/US-285 (Clines Corners)",47.394523809523797,{"$f":"IF(0.882352941176471<=Ratio_Max, IF(0.882352941176471<=Ratio_Min, 0, (Ratio_Points*((0.882352941176471-Ratio_Min)/(Ratio_Max-Ratio_Min)))), Ratio_Points)","v":16},{"$f":"IF(31.4<=Snow_Max, IF(31.4<=Snow_Min, 0, (Snow_Points*((31.4-Snow_Min)/(Snow_Max-Snow_Min)))), Snow_Points)","v":14.549999999999999},{"$f":"IF(16000<=AADT_Max, IF(16000<=AADT_Min, 0, (AADT_Points*((16000-AADT_Min)/(AADT_Max-AADT_Min)))), AADT_Points)","v":4.125},0,{"$f":"IF(20<=Topo_Max, IF(20<=Topo_Min, 0, (Topo_Points*((20-Topo_Min)/(Topo_Max-Topo_Min)))), Topo_Points)","v":0},{"$f":"IF((0.5-DPatrol_Best)>0, IF(0.5>=DPatrol_Max, 0, (DPatrol_Points*(1-((0.5-DPatrol_Best)/(DPatrol_Max-DPatrol_Best))))), (DPatrol_Points*((DPatrol_Best-(DPatrol_Best-0.5))/DPatrol_Best)))","v":0.35000000000000003},{"$f":"IF(2152<=Alt_Max, IF(2152<=Alt_Min, 0, (Alt_Points*((2152-Alt_Min)/(Alt_Max-Alt_Min)))), Alt_Points)","v":3.7600000000000002},{"$f":"IF(10<=SRP_Max, IF(10<=SRP_Min, 0, (SRP_Points*((10-SRP_Min)/(SRP_Max-SRP_Min)))), SRP_Points)","v":5.1428571428571423},0,{"$f":"IF(15<=Rain_Max, IF(15<=Rain_Min, 0, (Rain_Points*((15-Rain_Min)/(Rain_Max-Rain_Min)))), Rain_Points)","v":2.6666666666666665},{"$f":"IF((0-DITS_Best)>0, IF(0>=DITS_Max, 0, (DITS_Points*(1-((0-DITS_Best)/(DITS_Max-DITS_Best))))), (DITS_Points*((DITS_Best-(DITS_Best-0))/DITS_Best)))","v":0},{"$f":"IF(4<=Fire_Max, IF(4<=Fire_Min, 0, (Fire_Points*((4-Fire_Min)/(Fire_Max-Fire_Min)))), Fire_Points)","v":0.8},{"$f":"IF(0>=DPower_Max, 1, 0)","v":0},{"$f":"IF(0>=DComm_Max, 1, 0)","v":0},null,null,0,{"$f":"IF(7.86915793714746<=Rate_Max, IF(7.86915793714746<=Rate_Min, 0, (Rate_Points*((7.86915793714746-Rate_Min)/(Rate_Max-Rate_Min)))), Rate_Points)","v":0},{"$f":"IF(15<=WCrashNum_Max, IF(15<=WCrashNum_Min, 0, (WCrashNum_Points*((15-WCrashNum_Min)/(WCrashNum_Max-WCrashNum_Min)))), WCrashNum_Points)","v":0},"District 5"]
["US-64 MM273 (Palo Flechado Pass)",47.026136534698175,{"$f":"IF(0.315068493150685<=Ratio_Max, IF(0.315068493150685<=Ratio_Min, 0, (Ratio_Points*((0.315068493150685-Ratio_Min)/(Ratio_Max-Ratio_Min)))), Ratio_Points)","v":5.2939936775553234},{"$f":"IF(55<=Snow_Max, IF(55<=Snow_Min, 0, (Snow_Points*((55-Snow_Min)/(Snow_Max-Snow_Min)))), Snow_Points)","v":15},{"$f":"IF(1400<=AADT_Max, IF(1400<=AADT_Min, 0, (AADT_Points*((1400-AADT_Min)/(AADT_Max-AADT_Min)))), AADT_Points)","v":0},0,{"$f":"IF(400<=Topo_Max, IF(400<=Topo_Min, 0, (Topo_Points*((400-Topo_Min)/(Topo_Max-Topo_Min)))), Topo_Points)","v":9},{"$f":"IF((11.5-DPatrol_Best)>0, IF(11.5>=DPatrol_Max, 0, (DPatrol_Points*(1-((11.5-DPatrol_Best)/(DPatrol_Max-DPatrol_Best))))), (DPatrol_Points*((DPatrol_Best-(DPatrol_Best-11.5))/DPatrol_Best)))","v":6.4750000000000005},{"$f":"IF(2780<=Alt_Max, IF(2780<=Alt_Min, 0, (Alt_Points*((2780-Alt_Min)/(Alt_Max-Alt_Min)))), Alt_Points)","v":6},{"$f":"IF(5<=SRP_Max, IF(5<=SRP_Min, 0, (SRP_Points*((5-SRP_Min)/(SRP_Max-SRP_Min)))), SRP_Points)","v":0.8571428571428571},0,{"$f":"IF(24.6<=Rain_Max, IF(24.6<=Rain_Min, 0, (Rain_Points*((24.6-Rain_Min)/(Rain_Max-Rain_Min)))), Rain_Points)","v":4},{"$f":"IF((19.5-DITS_Best)>0, IF(19.5>=DITS_Max, 0, (DITS_Points*(1-((19.5-DITS_Best)/(DITS_Max-DITS_Best))))), (DITS_Points*((DITS_Best-(DITS_Best-19.5))/DITS_Best)))","v":0},{"$f":"IF(2<=Fire_Max, IF(2<=Fire_Min, 0, (Fire_Points*((2-Fire_Min)/(Fire_Max-Fire_Min)))), Fire_Points)","v":0.4},{"$f":"IF(0>=DPower_Max, 1, 0)","v":0},{"$f":"IF(0>=DComm_Max, 1, 0)","v":0},null,null,0,{"$f":"IF(1.08800492966519<=Rate_Max, IF(1.08800492966519<=Rate_Min, 0, (Rate_Points*((1.08800492966519-Rate_Min)/(Rate_Max-Rate_Min)))), Rate_Points)","v":0},{"$f":"IF(23<=WCrashNum_Max, IF(23<=WCrashNum_Min, 0, (WCrashNum_Points*((23-WCrashNum_Min)/(WCrashNum_Max-WCrashNum_Min)))), WCrashNum_Points)","v":0},"District 4/5"]
["I-25 MM331 (Serafina)",46.353373015873004,{"$f":"IF(0.533333333333333<=Ratio_Max, IF(0.533333333333333<=Ratio_Min, 0, (Ratio_Points*((0.533333333333333-Ratio_Min)/(Ratio_Max-Ratio_Min)))), Ratio_Points)","v":10.666666666666659},{"$f":"IF(34.5<=Snow_Max, IF(34.5<=Snow_Min, 0, (Snow_Points*((34.5-Snow_Min)/(Snow_Max-Snow_Min)))), Snow_Points)","v":15},{"$f":"IF(8700<=AADT_Max, IF(8700<=AADT_Min, 0, (AADT_Points*((8700-AADT_Min)/(AADT_Max-AADT_Min)))), AADT_Points)","v":1.3875},0,{"$f":"IF(100<=Topo_Max, IF(100<=Topo_Min, 0, (Topo_Points*((100-Topo_Min)/(Topo_Max-Topo_Min)))), Topo_Points)","v":4},{"$f":"IF((14-DPatrol_Best)>0, IF(14>=DPatrol_Max, 0, (DPatrol_Points*(1-((14-DPatrol_Best)/(DPatrol_Max-DPatrol_Best))))), (DPatrol_Points*((DPatrol_Best-(DPatrol_Best-14))/DPatrol_Best)))","v":5.6000000000000005},{"$f":"IF(1950<=Alt_Max, IF(1950<=Alt_Min, 0, (Alt_Points*((1950-Alt_Min)/(Alt_Max-Alt_Min)))), Alt_Points)","v":2.75},{"$f":"IF(7<=SRP_Max, IF(7<=SRP_Min, 0, (SRP_Points*((7-SRP_Min)/(SRP_Max-SRP_Min)))), SRP_Points)","v":2.5714285714285712},0,{"$f":"IF(17.5<=Rain_Max, IF(17.5<=Rain_Min, 0, (Rain_Points*((17.5-Rain_Min)/(Rain_Max-Rain_Min)))), Rain_Points)","v":3.7777777777777777},{"$f":"IF((38-DITS_Best)>0, IF(38>=DITS_Max, 0, (DITS_Points*(1-((38-DITS_Best)/(DITS_Max-DITS_Best))))), (DITS_Points*((DITS_Best-(DITS_Best-38))/DITS_Best)))","v":0},{"$f":"IF(3<=Fire_Max, IF(3<=Fire_Min, 0, (Fire_Points*((3-Fire_Min)/(Fire_Max-Fire_Min)))), Fire_Points)","v":0.6},{"$f":"IF(15>=DPower_Max, 1, 0)","v":1},{"$f":"IF(15>=DComm_Max, 1, 0)","v":1},null,null,0,{"$f":"IF(1.12418041100176<=Rate_Max, IF(1.12418041100176<=Rate_Min, 0, (Rate_Points*((1.12418041100176-Rate_Min)/(Rate_Max-Rate_Min)))), Rate_Points)","v":0},{"$f":"IF(16<=WCrashNum_Max, IF(16<=WCrashNum_Min, 0, (WCrashNum_Points*((16-WCrashNum_Min)/(WCrashNum_Max-WCrashNum_Min)))), WCrashNum_Points)","v":0},"District 4"]
["US-60 MM260 (West of Vaughn)",43.3595238095238,{"$f":"IF(1.125<=Ratio_Max, IF(1.125<=Ratio_Min, 0, (Ratio_Points*((1.125-Ratio_Min)/(Ratio_Max-Ratio_Min)))), Ratio_Points)","v":16},{"$f":"IF(21<=Snow_Max, IF(21<=Snow_Min, 0, (Snow_Points*((21-Snow_Min)/(Snow_Max-Snow_Min)))), Snow_Points)","v":6.75},{"$f":"IF(2500<=AADT_Max, IF(2500<=AADT_Min, 0, (AADT_Points*((2500-AADT_Min)/(AADT_Max-AADT_Min)))), AADT_Points)","v":0},0,{"$f":"IF(100<=Topo_Max, IF(100<=Topo_Min, 0, (Topo_Points*((100-Topo_Min)/(Topo_Max-Topo_Min)))), Topo_Points)","v":4},{"$f":"IF((8-DPatrol_Best)>0, IF(8>=DPatrol_Max, 0, (DPatrol_Points*(1-((8-DPatrol_Best)/(DPatrol_Max-DPatrol_Best))))), (DPatrol_Points*((DPatrol_Best-(DPatrol_Best-8))/DPatrol_Best)))","v":5.6000000000000005},{"$f":"IF(1880<=Alt_Max, IF(1880<=Alt_Min, 0, (Alt_Points*((1880-Alt_Min)/(Alt_Max-Alt_Min)))), Alt_Points)","v":2.4000000000000004},{"$f":"IF(10<=SRP_Max, IF(10<=SRP_Min, 0, (SRP_Points*((10-SRP_Min)/(SRP_Max-SRP_Min)))), SRP_Points)","v":5.1428571428571423},0,{"$f":"IF(15<=Rain_Max, IF(15<=Rain_Min, 0, (Rain_Points*((15-Rain_Min)/(Rain_Max-Rain_Min)))), Rain_Points)","v":2.6666666666666665},{"$f":"IF((32-DITS_Best)>0, IF(32>=DITS_Max, 0, (DITS_Points*(1-((32-DITS_Best)/(DITS_Max-DITS_Best))))), (DITS_Points*((DITS_Best-(DITS_Best-32))/DITS_Best)))","v":0},{"$f":"IF(4<=Fire_Max, IF(4<=Fire_Min, 0, (Fire_Points*((4-Fire_Min)/(Fire_Max-Fire_Min)))), Fire_Points)","v":0.8},{"$f":"IF(7>=DPower_Max, 1, 0)","v":1},{"$f":"IF(7>=DComm_Max, 1, 0)","v":1},null,null,0,{"$f":"IF(3.01731941343311<=Rate_Max, IF(3.01731941343311<=Rate_Min, 0, (Rate_Points*((3.01731941343311-Rate_Min)/(Rate_Max-Rate_Min)))), Rate_Points)","v":0},{"$f":"IF(9<=WCrashNum_Max, IF(9<=WCrashNum_Min, 0, (WCrashNum_Points*((9-WCrashNum_Min)/(WCrashNum_Max-WCrashNum_Min)))), WCrashNum_Points)","v":0},"District 5"]
["I-40 MM70 (West of Grants)",43.217669976222588,{"$f":"IF(0.684210526315789<=Ratio_Max, IF(0.684210526315789<=Ratio_Min, 0, (Ratio_Points*((0.684210526315789-Ratio_Min)/(Ratio_Max-Ratio_Min)))), Ratio_Points)","v":14.380566801619423},{"$f":"IF(20.5<=Snow_Max, IF(20.5<=Snow_Min, 0, (Snow_Points*((20.5-Snow_Min)/(Snow_Max-Snow_Min)))), Snow_Points)","v":6.375},{"$f":"IF(23100<=AADT_Max, IF(23100<=AADT_Min, 0, (AADT_Points*((23100-AADT_Min)/(AADT_Max-AADT_Min)))), AADT_Points)","v":6.7875000000000005},0,{"$f":"IF(50<=Topo_Max, IF(50<=Topo_Min, 0, (Topo_Points*((50-Topo_Min)/(Topo_Max-Topo_Min)))), Topo_Points)","v":1.5},{"$f":"IF((7-DPatrol_Best)>0, IF(7>=DPatrol_Max, 0, (DPatrol_Points*(1-((7-DPatrol_Best)/(DPatrol_Max-DPatrol_Best))))), (DPatrol_Points*((DPatrol_Best-(DPatrol_Best-7))/DPatrol_Best)))","v":4.8999999999999995},{"$f":"IF(2060<=Alt_Max, IF(2060<=Alt_Min, 0, (Alt_Points*((2060-Alt_Min)/(Alt_Max-Alt_Min)))), Alt_Points)","v":3.3000000000000003},{"$f":"IF(9<=SRP_Max, IF(9<=SRP_Min, 0, (SRP_Points*((9-SRP_Min)/(SRP_Max-SRP_Min)))), SRP_Points)","v":4.2857142857142856},0,{"$f":"IF(11<=Rain_Max, IF(11<=Rain_Min, 0, (Rain_Points*((11-Rain_Min)/(Rain_Max-Rain_Min)))), Rain_Points)","v":0.88888888888888884},{"$f":"IF((50-DITS_Best)>0, IF(50>=DITS_Max, 0, (DITS_Points*(1-((50-DITS_Best)/(DITS_Max-DITS_Best))))), (DITS_Points*((DITS_Best-(DITS_Best-50))/DITS_Best)))","v":0},{"$f":"IF(4<=Fire_Max, IF(4<=Fire_Min, 0, (Fire_Points*((4-Fire_Min)/(Fire_Max-Fire_Min)))), Fire_Points)","v":0.8},{"$f":"IF(6>=DPower_Max, 1, 0)","v":1},{"$f":"IF(6>=DComm_Max, 1, 0)","v":1},null,null,0,{"$f":"IF(0.320875144799383<=Rate_Max, IF(0.320875144799383<=Rate_Min, 0, (Rate_Points*((0.320875144799383-Rate_Min)/(Rate_Max-Rate_Min)))), Rate_Points)","v":0},{"$f":"IF(52<=WCrashNum_Max, IF(52<=WCrashNum_Min, 0, (WCrashNum_Points*((52-WCrashNum_Min)/(WCrashNum_Max-WCrashNum_Min)))), WCrashNum_Points)","v":0},"District 6"]
["NM-550 MM110",41.68630952380952,{"$f":"IF(0.846153846153846<=Ratio_Max, IF(0.846153846153846<=Ratio_Min, 0, (Ratio_Points*((0.846153846153846-Ratio_Min)/(Ratio_Max-Ratio_Min)))), Ratio_Points)","v":16},{"$f":"IF(26.4<=Snow_Max, IF(26.4<=Snow_Min, 0, (Snow_Points*((26.4-Snow_Min)/(Snow_Max-Snow_Min)))), Snow_Points)","v":10.799999999999999},{"$f":"IF(5700<=AADT_Max, IF(5700<=AADT_Min, 0, (AADT_Points*((5700-AADT_Min)/(AADT_Max-AADT_Min)))), AADT_Points)","v":0.26250000000000001},0,{"$f":"IF(200<=Topo_Max, IF(200<=Topo_Min, 0, (Topo_Points*((200-Topo_Min)/(Topo_Max-Topo_Min)))), Topo_Points)","v":9},{"$f":"IF((37-DPatrol_Best)>0, IF(37>=DPatrol_Max, 0, (DPatrol_Points*(1-((37-DPatrol_Best)/(DPatrol_Max-DPatrol_Best))))), (DPatrol_Points*((DPatrol_Best-(DPatrol_Best-37))/DPatrol_Best)))","v":0},{"$f":"IF(2100<=Alt_Max, IF(2100<=Alt_Min, 0, (Alt_Points*((2100-Alt_Min)/(Alt_Max-Alt_Min)))), Alt_Points)","v":3.5},{"$f":"IF(5<=SRP_Max, IF(5<=SRP_Min, 0, (SRP_Points*((5-SRP_Min)/(SRP_Max-SRP_Min)))), SRP_Points)","v":0.8571428571428571},0,{"$f":"IF(10.5<=Rain_Max, IF(10.5<=Rain_Min, 0, (Rain_Points*((10.5-Rain_Min)/(Rain_Max-Rain_Min)))), Rain_Points)","v":0.66666666666666663},{"$f":"IF((65-DITS_Best)>0, IF(65>=DITS_Max, 0, (DITS_Points*(1-((65-DITS_Best)/(DITS_Max-DITS_Best))))), (DITS_Points*((DITS_Best-(DITS_Best-65))/DITS_Best)))","v":0},{"$f":"IF(3<=Fire_Max, IF(3<=Fire_Min, 0, (Fire_Points*((3-Fire_Min)/(Fire_Max-Fire_Min)))), Fire_Points)","v":0.6},{"$f":"IF(40>=DPower_Max, 1, 0)","v":1},{"$f":"IF(40>=DComm_Max, 1, 0)","v":1},null,null,0,{"$f":"IF(0.655873194049061<=Rate_Max, IF(0.655873194049061<=Rate_Min, 0, (Rate_Points*((0.655873194049061-Rate_Min)/(Rate_Max-Rate_Min)))), Rate_Points)","v":0},{"$f":"IF(44<=WCrashNum_Max, IF(44<=WCrashNum_Min, 0, (WCrashNum_Points*((44-WCrashNum_Min)/(WCrashNum_Max-WCrashNum_Min)))), WCrashNum_Points)","v":0},"District 5"]
["I-25 MM268 (La Bajada)",41.160656448814336,{"$f":"IF(0.252631578947368<=Ratio_Max, IF(0.252631578947368<=Ratio_Min, 0, (Ratio_Points*((0.252631578947368-Ratio_Min)/(Ratio_Max-Ratio_Min)))), Ratio_Points)","v":3.7570850202429038},{"$f":"IF(20.5<=Snow_Max, IF(20.5<=Snow_Min, 0, (Snow_Points*((20.5-Snow_Min)/(Snow_Max-Snow_Min)))), Snow_Points)","v":6.375},{"$f":"IF(33800<=AADT_Max, IF(33800<=AADT_Min, 0, (AADT_Points*((33800-AADT_Min)/(AADT_Max-AADT_Min)))), AADT_Points)","v":10.799999999999999},0,{"$f":"IF(75<=Topo_Max, IF(75<=Topo_Min, 0, (Topo_Points*((75-Topo_Min)/(Topo_Max-Topo_Min)))), Topo_Points)","v":2.75},{"$f":"IF((9-DPatrol_Best)>0, IF(9>=DPatrol_Max, 0, (DPatrol_Points*(1-((9-DPatrol_Best)/(DPatrol_Max-DPatrol_Best))))), (DPatrol_Points*((DPatrol_Best-(DPatrol_Best-9))/DPatrol_Best)))","v":6.3},{"$f":"IF(1850<=Alt_Max, IF(1850<=Alt_Min, 0, (Alt_Points*((1850-Alt_Min)/(Alt_Max-Alt_Min)))), Alt_Points)","v":2.25},{"$f":"IF(8<=SRP_Max, IF(8<=SRP_Min, 0, (SRP_Points*((8-SRP_Min)/(SRP_Max-SRP_Min)))), SRP_Points)","v":3.4285714285714284},0,{"$f":"IF(13.5<=Rain_Max, IF(13.5<=Rain_Min, 0, (Rain_Points*((13.5-Rain_Min)/(Rain_Max-Rain_Min)))), Rain_Points)","v":2},{"$f":"IF((3-DITS_Best)>0, IF(3>=DITS_Max, 0, (DITS_Points*(1-((3-DITS_Best)/(DITS_Max-DITS_Best))))), (DITS_Points*((DITS_Best-(DITS_Best-3))/DITS_Best)))","v":2.7},{"$f":"IF(4<=Fire_Max, IF(4<=Fire_Min, 0, (Fire_Points*((4-Fire_Min)/(Fire_Max-Fire_Min)))), Fire_Points)","v":0.8},{"$f":"IF(7>=DPower_Max, 1, 0)","v":1},{"$f":"IF(7>=DComm_Max, 1, 0)","v":1},null,null,0,{"$f":"IF(0.172369979923638<=Rate_Max, IF(0.172369979923638<=Rate_Min, 0, (Rate_Points*((0.172369979923638-Rate_Min)/(Rate_Max-Rate_Min)))), Rate_Points)","v":0},{"$f":"IF(24<=WCrashNum_Max, IF(24<=WCrashNum_Min, 0, (WCrashNum_Points*((24-WCrashNum_Min)/(WCrashNum_Max-WCrashNum_Min)))), WCrashNum_Points)","v":0},"District 5"]
["NM-68 MM16 (Velarde)",36.935543184885297,{"$f":"IF(0.280701754385965<=Ratio_Max, IF(0.280701754385965<=Ratio_Min, 0, (Ratio_Points*((0.280701754385965-Ratio_Min)/(Ratio_Max-Ratio_Min)))), Ratio_Points)","v":4.4480431848852922},{"$f":"IF(31.1<=Snow_Max, IF(31.1<=Snow_Min, 0, (Snow_Points*((31.1-Snow_Min)/(Snow_Max-Snow_Min)))), Snow_Points)","v":14.325000000000001},{"$f":"IF(5700<=AADT_Max, IF(5700<=AADT_Min, 0, (AADT_Points*((5700-AADT_Min)/(AADT_Max-AADT_Min)))), AADT_Points)","v":0.26250000000000001},0,{"$f":"IF(360<=Topo_Max, IF(360<=Topo_Min, 0, (Topo_Points*((360-Topo_Min)/(Topo_Max-Topo_Min)))), Topo_Points)","v":9},{"$f":"IF((7.5-DPatrol_Best)>0, IF(7.5>=DPatrol_Max, 0, (DPatrol_Points*(1-((7.5-DPatrol_Best)/(DPatrol_Max-DPatrol_Best))))), (DPatrol_Points*((DPatrol_Best-(DPatrol_Best-7.5))/DPatrol_Best)))","v":5.25},{"$f":"IF(1770<=Alt_Max, IF(1770<=Alt_Min, 0, (Alt_Points*((1770-Alt_Min)/(Alt_Max-Alt_Min)))), Alt_Points)","v":1.85},{"$f":"IF(4<=SRP_Max, IF(4<=SRP_Min, 0, (SRP_Points*((4-SRP_Min)/(SRP_Max-SRP_Min)))), SRP_Points)","v":0},0,{"$f":"IF(12.6<=Rain_Max, IF(12.6<=Rain_Min, 0, (Rain_Points*((12.6-Rain_Min)/(Rain_Max-Rain_Min)))), Rain_Points)","v":1.5999999999999999},{"$f":"IF((12-DITS_Best)>0, IF(12>=DITS_Max, 0, (DITS_Points*(1-((12-DITS_Best)/(DITS_Max-DITS_Best))))), (DITS_Points*((DITS_Best-(DITS_Best-12))/DITS_Best)))","v":0},{"$f":"IF(1<=Fire_Max, IF(1<=Fire_Min, 0, (Fire_Points*((1-Fire_Min)/(Fire_Max-Fire_Min)))), Fire_Points)","v":0.2},{"$f":"IF(0>=DPower_Max, 1, 0)","v":0},{"$f":"IF(0>=DComm_Max, 1, 0)","v":0},null,null,0,{"$f":"IF(0.506457709306215<=Rate_Max, IF(0.506457709306215<=Rate_Min, 0, (Rate_Points*((0.506457709306215-Rate_Min)/(Rate_Max-Rate_Min)))), Rate_Points)","v":0},{"$f":"IF(16<=WCrashNum_Max, IF(16<=WCrashNum_Min, 0, (WCrashNum_Points*((16-WCrashNum_Min)/(WCrashNum_Max-WCrashNum_Min)))), WCrashNum_Points)","v":0},"District 5"]
["I-25 MM257 (San Felipe Pueblo)",29.809737484737493,{"$f":"IF(0.273809523809524<=Ratio_Max, IF(0.273809523809524<=Ratio_Min, 0, (Ratio_Points*((0.273809523809524-Ratio_Min)/(Ratio_Max-Ratio_Min)))), Ratio_Points)","v":4.2783882783882827},{"$f":"IF(20.5<=Snow_Max, IF(20.5<=Snow_Min, 0, (Snow_Points*((20.5-Snow_Min)/(Snow_Max-Snow_Min)))), Snow_Points)","v":6.375},{"$f":"IF(25000<=AADT_Max, IF(25000<=AADT_Min, 0, (AADT_Points*((25000-AADT_Min)/(AADT_Max-AADT_Min)))), AADT_Points)","v":7.5},0,{"$f":"IF(50<=Topo_Max, IF(50<=Topo_Min, 0, (Topo_Points*((50-Topo_Min)/(Topo_Max-Topo_Min)))), Topo_Points)","v":1.5},{"$f":"IF((22-DPatrol_Best)>0, IF(22>=DPatrol_Max, 0, (DPatrol_Points*(1-((22-DPatrol_Best)/(DPatrol_Max-DPatrol_Best))))), (DPatrol_Points*((DPatrol_Best-(DPatrol_Best-22))/DPatrol_Best)))","v":2.8000000000000003},{"$f":"IF(1670<=Alt_Max, IF(1670<=Alt_Min, 0, (Alt_Points*((1670-Alt_Min)/(Alt_Max-Alt_Min)))), Alt_Points)","v":1.35},{"$f":"IF(8<=SRP_Max, IF(8<=SRP_Min, 0, (SRP_Points*((8-SRP_Min)/(SRP_Max-SRP_Min)))), SRP_Points)","v":3.4285714285714284},0,{"$f":"IF(13<=Rain_Max, IF(13<=Rain_Min, 0, (Rain_Points*((13-Rain_Min)/(Rain_Max-Rain_Min)))), Rain_Points)","v":1.7777777777777777},{"$f":"IF((14-DITS_Best)>0, IF(14>=DITS_Max, 0, (DITS_Points*(1-((14-DITS_Best)/(DITS_Max-DITS_Best))))), (DITS_Points*((DITS_Best-(DITS_Best-14))/DITS_Best)))","v":0},{"$f":"IF(4<=Fire_Max, IF(4<=Fire_Min, 0, (Fire_Points*((4-Fire_Min)/(Fire_Max-Fire_Min)))), Fire_Points)","v":0.8},{"$f":"IF(0>=DPower_Max, 1, 0)","v":0},{"$f":"IF(0>=DComm_Max, 1, 0)","v":0},null,null,{"$f":"IF(1 = 1, 1, 0)","v":1},{"$f":"IF(0.22426399968018<=Rate_Max, IF(0.22426399968018<=Rate_Min, 0, (Rate_Points*((0.22426399968018-Rate_Min)/(Rate_Max-Rate_Min)))), Rate_Points)","v":0},{"$f":"IF(23<=WCrashNum_Max, IF(23<=WCrashNum_Min, 0, (WCrashNum_Points*((23-WCrashNum_Min)/(WCrashNum_Max-WCrashNum_Min)))), WCrashNum_Points)","v":0},"District 3"]
["NM-550 MM27 (San Ysidro)",29.294071956571944,{"$f":"IF(0.513513513513513<=Ratio_Max, IF(0.513513513513513<=Ratio_Min, 0, (Ratio_Points*((0.513513513513513-Ratio_Min)/(Ratio_Max-Ratio_Min)))), Ratio_Points)","v":10.178794178794167},{"$f":"IF(20.2<=Snow_Max, IF(20.2<=Snow_Min, 0, (Snow_Points*((20.2-Snow_Min)/(Snow_Max-Snow_Min)))), Snow_Points)","v":6.1499999999999995},{"$f":"IF(5100<=AADT_Max, IF(5100<=AADT_Min, 0, (AADT_Points*((5100-AADT_Min)/(AADT_Max-AADT_Min)))), AADT_Points)","v":3.7499999999999999E-2},0,{"$f":"IF(150<=Topo_Max, IF(150<=Topo_Min, 0, (Topo_Points*((150-Topo_Min)/(Topo_Max-Topo_Min)))), Topo_Points)","v":6.5},{"$f":"IF((3.5-DPatrol_Best)>0, IF(3.5>=DPatrol_Max, 0, (DPatrol_Points*(1-((3.5-DPatrol_Best)/(DPatrol_Max-DPatrol_Best))))), (DPatrol_Points*((DPatrol_Best-(DPatrol_Best-3.5))/DPatrol_Best)))","v":2.4499999999999997},{"$f":"IF(1680<=Alt_Max, IF(1680<=Alt_Min, 0, (Alt_Points*((1680-Alt_Min)/(Alt_Max-Alt_Min)))), Alt_Points)","v":1.4},{"$f":"IF(3<=SRP_Max, IF(3<=SRP_Min, 0, (SRP_Points*((3-SRP_Min)/(SRP_Max-SRP_Min)))), SRP_Points)","v":0},0,{"$f":"IF(13<=Rain_Max, IF(13<=Rain_Min, 0, (Rain_Points*((13-Rain_Min)/(Rain_Max-Rain_Min)))), Rain_Points)","v":1.7777777777777777},{"$f":"IF((100-DITS_Best)>0, IF(100>=DITS_Max, 0, (DITS_Points*(1-((100-DITS_Best)/(DITS_Max-DITS_Best))))), (DITS_Points*((DITS_Best-(DITS_Best-100))/DITS_Best)))","v":0},{"$f":"IF(4<=Fire_Max, IF(4<=Fire_Min, 0, (Fire_Points*((4-Fire_Min)/(Fire_Max-Fire_Min)))), Fire_Points)","v":0.8},{"$f":"IF(3.5>=DPower_Max, 1, 0)","v":1},{"$f":"IF(3.5>=DComm_Max, 1, 0)","v":1},null,null,{"$f":"IF(0 = 1, 1, 0)","v":0},{"$f":"IF(0.354348190560829<=Rate_Max, IF(0.354348190560829<=Rate_Min, 0, (Rate_Points*((0.354348190560829-Rate_Min)/(Rate_Max-Rate_Min)))), Rate_Points)","v":0},{"$f":"IF(19<=WCrashNum_Max, IF(19<=WCrashNum_Min, 0, (WCrashNum_Points*((19-WCrashNum_Min)/(WCrashNum_Max-WCrashNum_Min)))), WCrashNum_Points)","v":0},"District 6"]
["US-70 MM255 (South of Ruidoso)",29.174343711843708,{"$f":"IF(0.102222222222222<=Ratio_Max, IF(0.102222222222222<=Ratio_Min, 0, (Ratio_Points*((0.102222222222222-Ratio_Min)/(Ratio_Max-Ratio_Min)))), Ratio_Points)","v":5.4700854700849247E-2},{"$f":"IF(23<=Snow_Max, IF(23<=Snow_Min, 0, (Snow_Points*((23-Snow_Min)/(Snow_Max-Snow_Min)))), Snow_Points)","v":8.25},{"$f":"IF(7300<=AADT_Max, IF(7300<=AADT_Min, 0, (AADT_Points*((7300-AADT_Min)/(AADT_Max-AADT_Min)))), AADT_Points)","v":0.86250000000000004},0,{"$f":"IF(200<=Topo_Max, IF(200<=Topo_Min, 0, (Topo_Points*((200-Topo_Min)/(Topo_Max-Topo_Min)))), Topo_Points)","v":9},{"$f":"IF((25-DPatrol_Best)>0, IF(25>=DPatrol_Max, 0, (DPatrol_Points*(1-((25-DPatrol_Best)/(DPatrol_Max-DPatrol_Best))))), (DPatrol_Points*((DPatrol_Best-(DPatrol_Best-25))/DPatrol_Best)))","v":1.75},{"$f":"IF(2200<=Alt_Max, IF(2200<=Alt_Min, 0, (Alt_Points*((2200-Alt_Min)/(Alt_Max-Alt_Min)))), Alt_Points)","v":4},{"$f":"IF(5<=SRP_Max, IF(5<=SRP_Min, 0, (SRP_Points*((5-SRP_Min)/(SRP_Max-SRP_Min)))), SRP_Points)","v":0.8571428571428571},0,{"$f":"IF(20<=Rain_Max, IF(20<=Rain_Min, 0, (Rain_Points*((20-Rain_Min)/(Rain_Max-Rain_Min)))), Rain_Points)","v":4},{"$f":"IF((90-DITS_Best)>0, IF(90>=DITS_Max, 0, (DITS_Points*(1-((90-DITS_Best)/(DITS_Max-DITS_Best))))), (DITS_Points*((DITS_Best-(DITS_Best-90))/DITS_Best)))","v":0},{"$f":"IF(2<=Fire_Max, IF(2<=Fire_Min, 0, (Fire_Points*((2-Fire_Min)/(Fire_Max-Fire_Min)))), Fire_Points)","v":0.4},{"$f":"IF(7>=DPower_Max, 1, 0)","v":1},{"$f":"IF(7>=DComm_Max, 1, 0)","v":1},null,null,{"$f":"IF(1 = 1, 1, 0)","v":1},{"$f":"IF(0.109863987666764<=Rate_Max, IF(0.109863987666764<=Rate_Min, 0, (Rate_Points*((0.109863987666764-Rate_Min)/(Rate_Max-Rate_Min)))), Rate_Points)","v":0},{"$f":"IF(23<=WCrashNum_Max, IF(23<=WCrashNum_Min, 0, (WCrashNum_Points*((23-WCrashNum_Min)/(WCrashNum_Max-WCrashNum_Min)))), WCrashNum_Points)","v":0},"District 2"]
["I-25/I-40 (The Big I)",28.143888888888892,{"$f":"IF(0.0532896085263374<=Ratio_Max, IF(0.0532896085263374<=Ratio_Min, 0, (Ratio_Points*((0.0532896085263374-Ratio_Min)/(Ratio_Max-Ratio_Min)))), Ratio_Points)","v":0},{"$f":"IF(12.5<=Snow_Max, IF(12.5<=Snow_Min, 0, (Snow_Points*((12.5-Snow_Min)/(Snow_Max-Snow_Min)))), Snow_Points)","v":0.375},{"$f":"IF(180400<=AADT_Max, IF(180400<=AADT_Min, 0, (AADT_Points*((180400-AADT_Min)/(AADT_Max-AADT_Min)))), AADT_Points)","v":15},0,{"$f":"IF(50<=Topo_Max, IF(50<=Topo_Min, 0, (Topo_Points*((50-Topo_Min)/(Topo_Max-Topo_Min)))), Topo_Points)","v":1.5},{"$f":"IF((3-DPatrol_Best)>0, IF(3>=DPatrol_Max, 0, (DPatrol_Points*(1-((3-DPatrol_Best)/(DPatrol_Max-DPatrol_Best))))), (DPatrol_Points*((DPatrol_Best-(DPatrol_Best-3))/DPatrol_Best)))","v":2.1},{"$f":"IF(1536<=Alt_Max, IF(1536<=Alt_Min, 0, (Alt_Points*((1536-Alt_Min)/(Alt_Max-Alt_Min)))), Alt_Points)","v":0.67999999999999994},{"$f":"IF(22<=SRP_Max, IF(22<=SRP_Min, 0, (SRP_Points*((22-SRP_Min)/(SRP_Max-SRP_Min)))), SRP_Points)","v":6},0,{"$f":"IF(11<=Rain_Max, IF(11<=Rain_Min, 0, (Rain_Points*((11-Rain_Min)/(Rain_Max-Rain_Min)))), Rain_Points)","v":0.88888888888888884},{"$f":"IF((0.5-DITS_Best)>0, IF(0.5>=DITS_Max, 0, (DITS_Points*(1-((0.5-DITS_Best)/(DITS_Max-DITS_Best))))), (DITS_Points*((DITS_Best-(DITS_Best-0.5))/DITS_Best)))","v":0.60000000000000009},{"$f":"IF(5<=Fire_Max, IF(5<=Fire_Min, 0, (Fire_Points*((5-Fire_Min)/(Fire_Max-Fire_Min)))), Fire_Points)","v":1},{"$f":"IF(0>=DPower_Max, 1, 0)","v":0},{"$f":"IF(0>=DComm_Max, 1, 0)","v":0},null,null,{"$f":"IF(0 = 1, 1, 0)","v":0},{"$f":"IF(0.0187339512335522<=Rate_Max, IF(0.0187339512335522<=Rate_Min, 0, (Rate_Points*((0.0187339512335522-Rate_Min)/(Rate_Max-Rate_Min)))), Rate_Points)","v":0},{"$f":"IF(260<=WCrashNum_Max, IF(260<=WCrashNum_Min, 0, (WCrashNum_Points*((260-WCrashNum_Min)/(WCrashNum_Max-WCrashNum_Min)))), WCrashNum_Points)","v":0},"District 3"]
["NM-602 MM25 (South of Gallup)",27.256281205043578,{"$f":"IF(0.173267326732673<=Ratio_Max, IF(0.173267326732673<=Ratio_Min, 0, (Ratio_Points*((0.173267326732673-Ratio_Min)/(Ratio_Max-Ratio_Min)))), Ratio_Points)","v":1.8035034272657968},{"$f":"IF(26.5<=Snow_Max, IF(26.5<=Snow_Min, 0, (Snow_Points*((26.5-Snow_Min)/(Snow_Max-Snow_Min)))), Snow_Points)","v":10.875},{"$f":"IF(8200<=AADT_Max, IF(8200<=AADT_Min, 0, (AADT_Points*((8200-AADT_Min)/(AADT_Max-AADT_Min)))), AADT_Points)","v":1.2},0,{"$f":"IF(100<=Topo_Max, IF(100<=Topo_Min, 0, (Topo_Points*((100-Topo_Min)/(Topo_Max-Topo_Min)))), Topo_Points)","v":4},{"$f":"IF((5-DPatrol_Best)>0, IF(5>=DPatrol_Max, 0, (DPatrol_Points*(1-((5-DPatrol_Best)/(DPatrol_Max-DPatrol_Best))))), (DPatrol_Points*((DPatrol_Best-(DPatrol_Best-5))/DPatrol_Best)))","v":3.5},{"$f":"IF(2060<=Alt_Max, IF(2060<=Alt_Min, 0, (Alt_Points*((2060-Alt_Min)/(Alt_Max-Alt_Min)))), Alt_Points)","v":3.3000000000000003},{"$f":"IF(3<=SRP_Max, IF(3<=SRP_Min, 0, (SRP_Points*((3-SRP_Min)/(SRP_Max-SRP_Min)))), SRP_Points)","v":0},0,{"$f":"IF(13<=Rain_Max, IF(13<=Rain_Min, 0, (Rain_Points*((13-Rain_Min)/(Rain_Max-Rain_Min)))), Rain_Points)","v":1.7777777777777777},{"$f":"IF((29-DITS_Best)>0, IF(29>=DITS_Max, 0, (DITS_Points*(1-((29-DITS_Best)/(DITS_Max-DITS_Best))))), (DITS_Points*((DITS_Best-(DITS_Best-29))/DITS_Best)))","v":0},{"$f":"IF(4<=Fire_Max, IF(4<=Fire_Min, 0, (Fire_Points*((4-Fire_Min)/(Fire_Max-Fire_Min)))), Fire_Points)","v":0.8},{"$f":"IF(4>=DPower_Max, 1, 0)","v":1},{"$f":"IF(4>=DComm_Max, 1, 0)","v":1},null,null,{"$f":"IF(1 = 1, 1, 0)","v":1},{"$f":"IF(0.080571822181552<=Rate_Max, IF(0.080571822181552<=Rate_Min, 0, (Rate_Points*((0.080571822181552-Rate_Min)/(Rate_Max-Rate_Min)))), Rate_Points)","v":0},{"$f":"IF(35<=WCrashNum_Max, IF(35<=WCrashNum_Min, 0, (WCrashNum_Points*((35-WCrashNum_Min)/(WCrashNum_Max-WCrashNum_Min)))), WCrashNum_Points)","v":0},"District 6"]
["I-40 MM320 (West of Tucumcari)",25.129548229548234,{"$f":"IF(0.266666666666667<=Ratio_Max, IF(0.266666666666667<=Ratio_Min, 0, (Ratio_Points*((0.266666666666667-Ratio_Min)/(Ratio_Max-Ratio_Min)))), Ratio_Points)","v":4.1025641025641102},{"$f":"IF(15.4<=Snow_Max, IF(15.4<=Snow_Min, 0, (Snow_Points*((15.4-Snow_Min)/(Snow_Max-Snow_Min)))), Snow_Points)","v":2.5500000000000003},{"$f":"IF(21000<=AADT_Max, IF(21000<=AADT_Min, 0, (AADT_Points*((21000-AADT_Min)/(AADT_Max-AADT_Min)))), AADT_Points)","v":6},0,{"$f":"IF(20<=Topo_Max, IF(20<=Topo_Min, 0, (Topo_Points*((20-Topo_Min)/(Topo_Max-Topo_Min)))), Topo_Points)","v":0},{"$f":"IF((13-DPatrol_Best)>0, IF(13>=DPatrol_Max, 0, (DPatrol_Points*(1-((13-DPatrol_Best)/(DPatrol_Max-DPatrol_Best))))), (DPatrol_Points*((DPatrol_Best-(DPatrol_Best-13))/DPatrol_Best)))","v":5.95},{"$f":"IF(1370<=Alt_Max, IF(1370<=Alt_Min, 0, (Alt_Points*((1370-Alt_Min)/(Alt_Max-Alt_Min)))), Alt_Points)","v":0},{"$f":"IF(7<=SRP_Max, IF(7<=SRP_Min, 0, (SRP_Points*((7-SRP_Min)/(SRP_Max-SRP_Min)))), SRP_Points)","v":2.5714285714285712},0,{"$f":"IF(17<=Rain_Max, IF(17<=Rain_Min, 0, (Rain_Points*((17-Rain_Min)/(Rain_Max-Rain_Min)))), Rain_Points)","v":3.5555555555555554},{"$f":"IF((130-DITS_Best)>0, IF(130>=DITS_Max, 0, (DITS_Points*(1-((130-DITS_Best)/(DITS_Max-DITS_Best))))), (DITS_Points*((DITS_Best-(DITS_Best-130))/DITS_Best)))","v":0},{"$f":"IF(2<=Fire_Max, IF(2<=Fire_Min, 0, (Fire_Points*((2-Fire_Min)/(Fire_Max-Fire_Min)))), Fire_Points)","v":0.4},{"$f":"IF(10>=DPower_Max, 1, 0)","v":1},{"$f":"IF(10>=DComm_Max, 1, 0)","v":1},null,null,{"$f":"IF(0 = 1, 1, 0)","v":0},{"$f":"IF(0.113028498299133<=Rate_Max, IF(0.113028498299133<=Rate_Min, 0, (Rate_Points*((0.113028498299133-Rate_Min)/(Rate_Max-Rate_Min)))), Rate_Points)","v":0},{"$f":"IF(8<=WCrashNum_Max, IF(8<=WCrashNum_Min, 0, (WCrashNum_Points*((8-WCrashNum_Min)/(WCrashNum_Max-WCrashNum_Min)))), WCrashNum_Points)","v":0},"District 4"]
["US-70 MM435 (South of Clovis)",14.982142857142858,{"$f":"IF(0.0520547945205479<=Ratio_Max, IF(0.0520547945205479<=Ratio_Min, 0, (Ratio_Points*((0.0520547945205479-Ratio_Min)/(Ratio_Max-Ratio_Min)))), Ratio_Points)","v":0},{"$f":"IF(10<=Snow_Max, IF(10<=Snow_Min, 0, (Snow_Points*((10-Snow_Min)/(Snow_Max-Snow_Min)))), Snow_Points)","v":0},{"$f":"IF(16800<=AADT_Max, IF(16800<=AADT_Min, 0, (AADT_Points*((16800-AADT_Min)/(AADT_Max-AADT_Min)))), AADT_Points)","v":4.4249999999999998},0,{"$f":"IF(20<=Topo_Max, IF(20<=Topo_Min, 0, (Topo_Points*((20-Topo_Min)/(Topo_Max-Topo_Min)))), Topo_Points)","v":0},{"$f":"IF((4-DPatrol_Best)>0, IF(4>=DPatrol_Max, 0, (DPatrol_Points*(1-((4-DPatrol_Best)/(DPatrol_Max-DPatrol_Best))))), (DPatrol_Points*((DPatrol_Best-(DPatrol_Best-4))/DPatrol_Best)))","v":2.8000000000000003},{"$f":"IF(1300<=Alt_Max, IF(1300<=Alt_Min, 0, (Alt_Points*((1300-Alt_Min)/(Alt_Max-Alt_Min)))), Alt_Points)","v":0},{"$f":"IF(5<=SRP_Max, IF(5<=SRP_Min, 0, (SRP_Points*((5-SRP_Min)/(SRP_Max-SRP_Min)))), SRP_Points)","v":0.8571428571428571},0,{"$f":"IF(19<=Rain_Max, IF(19<=Rain_Min, 0, (Rain_Points*((19-Rain_Min)/(Rain_Max-Rain_Min)))), Rain_Points)","v":4},{"$f":"IF((4-DITS_Best)>0, IF(4>=DITS_Max, 0, (DITS_Points*(1-((4-DITS_Best)/(DITS_Max-DITS_Best))))), (DITS_Points*((DITS_Best-(DITS_Best-4))/DITS_Best)))","v":2.0999999999999996},{"$f":"IF(4<=Fire_Max, IF(4<=Fire_Min, 0, (Fire_Points*((4-Fire_Min)/(Fire_Max-Fire_Min)))), Fire_Points)","v":0.8},{"$f":"IF(1>=DPower_Max, 1, 0)","v":0},{"$f":"IF(1>=DComm_Max, 1, 0)","v":0},null,null,{"$f":"IF(0 = 1, 1, 0)","v":0},{"$f":"IF(0.0246487810752243<=Rate_Max, IF(0.0246487810752243<=Rate_Min, 0, (Rate_Points*((0.0246487810752243-Rate_Min)/(Rate_Max-Rate_Min)))), Rate_Points)","v":0},{"$f":"IF(19<=WCrashNum_Max, IF(19<=WCrashNum_Min, 0, (WCrashNum_Points*((19-WCrashNum_Min)/(WCrashNum_Max-WCrashNum_Min)))), WCrashNum_Points)","v":0},"District 2"]

{"sheet":"Relative Ranking Calculations","index":4,"n_rows":21,"n_cols":52,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Data Input'!A1","v":"Location"},"Ranking (1 to 100)",{"$f":"'Criteria & Importance'!B1","v":"Ratio of Weather to Clear Crashes"},{"$f":"'Criteria & Importance'!C1","v":"Average annual snow (in)"},{"$f":"'Criteria & Importance'!D1","v":"2013 AADT"},{"$f":"'Criteria & Importance'!E1","v":"Average Wind Gust"},{"$f":"'Criteria & Importance'!F1","v":"Local Altitude Range (meters)"},{"$f":"'Criteria & Importance'!G1","v":"Dist Patrol Yard (mi)"},{"$f":"'Criteria & Importance'!H1","v":"Altitude (Meters)"},{"$f":"'Criteria & Importance'!I1","v":"Snow Removal Priority"},{"$f":"'Criteria & Importance'!J1","v":"Average Road Grade 2 Miles"},{"$f":"'Criteria & Importance'!K1","v":"Average Annual Rain (in)"},{"$f":"'Criteria & Importance'!L1","v":"Dist ITS Unit (mi)"},{"$f":"'Criteria & Importance'!M1","v":"Fire Risk (0 Very High, 5 No Risk)"},{"$f":"'Criteria & Importance'!N1","v":"Distance to Power (mi)"},{"$f":"'Criteria & Importance'!O1","v":"Distance to Communication (mi)"},{"$f":"'Criteria & Importance'!P1","v":"Local Environment"},{"$f":"'Criteria & Importance'!Q1","v":"Functional Class"},{"$f":"'Criteria & Importance'!R1","v":"In Tribal Land?"},{"$f":"'Criteria & Importance'!S1","v":"Ratio of Crash Rates Per 100M Vehicle Miles"},{"$f":"'Criteria & Importance'!T1","v":"Number of Weather Related Crashes"},{"$f":"'Criteria & Importance'!U1","v":"Comment 1"},{"$f":"'Criteria & Importance'!V1","v":"Comment 2"}]
["NM-150 MM10 (Taos Ski Valley)",50.625833096321479,{"$f":"IF(1.33333333333333<=Ratio_RelMax, IF(1.33333333333333<=Ratio_RelMin, 0, (Ratio_Points*((1.33333333333333-Ratio_RelMin)/(Ratio_RelMax-Ratio_RelMin)))), Ratio_Points)","v":15.999999999999959},{"$f":"IF(62.5<=Snow_RelMax, IF(62.5<=Snow_RelMin, 0, (Snow_Points*((62.5-Snow_RelMin)/(Snow_RelMax-Snow_RelMin)))), Snow_Points)","v":10.5},{"$f":"IF(800<=AADT_RelMax, IF(800<=AADT_RelMin, 0, (AADT_Points*((800-AADT_RelMin)/(AADT_RelMax-AADT_RelMin)))), AADT_Points)","v":8.3472454090150246E-3},{"$f":"IF(0<=Wind_RelMax, IF(0<=Wind_RelMin, 0, (Wind_Points*((0-Wind_RelMin)/(Wind_RelMax-Wind_RelMin)))), Wind_Points)","v":0},{"$f":"IF(900<=Topo_RelMax, IF(900<=Topo_RelMin, 0, (Topo_Points*((900-Topo_RelMin)/(Topo_RelMax-Topo_RelMin)))), Topo_Points)","v":9},{"$f":"IF((8-DPatrol_RelBest)>0, IF(8>=DPatrol_RelMax, 0, (DPatrol_Points*(1-((8-DPatrol_RelBest)/(DPatrol_RelMax-DPatrol_RelBest))))), (DPatrol_Points*((DPatrol_RelBest-(DPatrol_RelBest-8))/DPatrol_RelBest)))","v":5.6000000000000005},{"$f":"IF(2650<=Alt_RelMax, IF(2650<=Alt_RelMin, 0, (Alt_Points*((2650-Alt_RelMin)/(Alt_RelMax-Alt_RelMin)))), Alt_Points)","v":5.4729729729729728},{"$f":"IF(4<=SRP_RelMax, IF(4<=SRP_RelMin, 0, (SRP_Points*((4-SRP_RelMin)/(SRP_RelMax-SRP_RelMin)))), SRP_Points)","v":0.31578947368421051},{"$f":"IF(0<=RGrade_RelMax, IF(0<=RGrade_RelMin, 0, (RGrade_Points*((0-RGrade_RelMin)/(RGrade_RelMax-RGrade_RelMin)))), RGrade_Points)","v":0},{"$f":"IF(21<=Rain_RelMax, IF(21<=Rain_RelMin, 0, (Rain_Points*((21-Rain_RelMin)/(Rain_RelMax-Rain_RelMin)))), Rain_Points)","v":2.978723404255319},{"$f":"IF((12-DITS_RelBest)>0, IF(12>=DITS_RelMax, 0, (DITS_Points*(1-((12-DITS_RelBest)/(DITS_RelMax-DITS_RelBest))))), (DITS_Points*((DITS_RelBest-(DITS_RelBest-12))/DITS_RelBest)))","v":0},{"$f":"IF(4<=Fire_RelMax, IF(4<=Fire_RelMin, 0, (Fire_Points*((4-Fire_RelMin)/(Fire_RelMax-Fire_RelMin)))), Fire_Points)","v":0.75},{"$f":"IF(15>=DPower_RelMax, 1, 0)","v":1},{"$f":"IF(15>=DComm_RelMax, 1, 0)","v":1},null,null,{"$f":"IF(0 = 1, 1, 0)","v":0},{"$f":"IF(20.053623388942<=Rate_RelMax, IF(20.053623388942<=Rate_RelMin, 0, (Rate_Points*((20.053623388942-Rate_RelMin)/(Rate_RelMax-Rate_RelMin)))), Rate_Points)","v":0},{"$f":"IF(12<=WCrashNum_RelMax, IF(12<=WCrashNum_RelMin, 0, (WCrashNum_Points*((12-WCrashNum_RelMin)/(WCrashNum_RelMax-WCrashNum_RelMin)))), WCrashNum_Points)","v":0},"District 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56.4]
["I-40 MM180 (West of Edgewood)",26.74417992569046,{"$f":"IF(0.602739726027397<=Ratio_RelMax, IF(0.602739726027397<=Ratio_RelMin, 0, (Ratio_Points*((0.602739726027397-Ratio_RelMin)/(Ratio_RelMax-Ratio_RelMin)))), Ratio_Points)","v":6.8766928011404103},{"$f":"IF(25.6<=Snow_RelMax, IF(25.6<=Snow_RelMin, 0, (Snow_Points*((25.6-Snow_RelMin)/(Snow_RelMax-Snow_RelMin)))), Snow_Points)","v":3.12},{"$f":"IF(28900<=AADT_RelMax, IF(28900<=AADT_RelMin, 0, (AADT_Points*((28900-AADT_RelMin)/(AADT_RelMax-AADT_RelMin)))), AADT_Points)","v":2.3539232053422374},0,{"$f":"IF(100<=Topo_RelMax, IF(100<=Topo_RelMin, 0, (Topo_Points*((100-Topo_RelMin)/(Topo_RelMax-Topo_RelMin)))), Topo_Points)","v":0.81818181818181823},{"$f":"IF((3.5-DPatrol_RelBest)>0, IF(3.5>=DPatrol_RelMax, 0, (DPatrol_Points*(1-((3.5-DPatrol_RelBest)/(DPatrol_RelMax-DPatrol_RelBest))))), (DPatrol_Points*((DPatrol_RelBest-(DPatrol_RelBest-3.5))/DPatrol_RelBest)))","v":2.4499999999999997},{"$f":"IF(2100<=Alt_RelMax, IF(2100<=Alt_RelMin, 0, (Alt_Points*((2100-Alt_RelMin)/(Alt_RelMax-Alt_RelMin)))), Alt_Points)","v":3.2432432432432434},{"$f":"IF(8<=SRP_RelMax, IF(8<=SRP_RelMin, 0, (SRP_Points*((8-SRP_RelMin)/(SRP_RelMax-SRP_RelMin)))), SRP_Points)","v":1.5789473684210527},0,{"$f":"IF(19.5<=Rain_RelMax, IF(19.5<=Rain_RelMin, 0, (Rain_Points*((19.5-Rain_RelMin)/(Rain_RelMax-Rain_RelMin)))), Rain_Points)","v":2.5531914893617018},{"$f":"IF((2.5-DITS_RelBest)>0, IF(2.5>=DITS_RelMax, 0, (DITS_Points*(1-((2.5-DITS_RelBest)/(DITS_RelMax-DITS_RelBest))))), (DITS_Points*((DITS_RelBest-(DITS_RelBest-2.5))/DITS_RelBest)))","v":3},{"$f":"IF(4<=Fire_RelMax, IF(4<=Fire_RelMin, 0, (Fire_Points*((4-Fire_RelMin)/(Fire_RelMax-Fire_RelMin)))), Fire_Points)","v":0.75},{"$f":"IF(1>=DPower_RelMax, 1, 0)","v":0},{"$f":"IF(1>=DComm_RelMax, 1, 0)","v":0},null,null,0,{"$f":"IF(0.632777981562249<=Rate_RelMax, IF(0.632777981562249<=Rate_RelMin, 0, (Rate_Points*((0.632777981562249-Rate_RelMin)/(Rate_RelMax-Rate_RelMin)))), Rate_Points)","v":0},{"$f":"IF(44<=WCrashNum_RelMax, IF(44<=WCrashNum_RelMin, 0, (WCrashNum_Points*((44-WCrashNum_RelMin)/(WCrashNum_RelMax-WCrashNum_RelMin)))), WCrashNum_Points)","v":0},"District 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52.716203146168894]
["I-40 MM173 (Tijeras Canyon)",31.271434343359317,{"$f":"IF(0.26219512195122<=Ratio_RelMax, IF(0.26219512195122<=Ratio_RelMin, 0, (Ratio_Points*((0.26219512195122-Ratio_RelMin)/(Ratio_RelMax-Ratio_RelMin)))), Ratio_Points)","v":2.6241329555134532},{"$f":"IF(20.5<=Snow_RelMax, IF(20.5<=Snow_RelMin, 0, (Snow_Points*((20.5-Snow_RelMin)/(Snow_RelMax-Snow_RelMin)))), Snow_Points)","v":2.1},{"$f":"IF(67600<=AADT_RelMax, IF(67600<=AADT_RelMin, 0, (AADT_Points*((67600-AADT_RelMin)/(AADT_RelMax-AADT_RelMin)))), AADT_Points)","v":5.5843071786310521},0,{"$f":"IF(900<=Topo_RelMax, IF(900<=Topo_RelMin, 0, (Topo_Points*((900-Topo_RelMin)/(Topo_RelMax-Topo_RelMin)))), Topo_Points)","v":9},{"$f":"IF((3-DPatrol_RelBest)>0, IF(3>=DPatrol_RelMax, 0, (DPatrol_Points*(1-((3-DPatrol_RelBest)/(DPatrol_RelMax-DPatrol_RelBest))))), (DPatrol_Points*((DPatrol_RelBest-(DPatrol_RelBest-3))/DPatrol_RelBest)))","v":2.1},{"$f":"IF(1900<=Alt_RelMax, IF(1900<=Alt_RelMin, 0, (Alt_Points*((1900-Alt_RelMin)/(Alt_RelMax-Alt_RelMin)))), Alt_Points)","v":2.4324324324324325},{"$f":"IF(10<=SRP_RelMax, IF(10<=SRP_RelMin, 0, (SRP_Points*((10-SRP_RelMin)/(SRP_RelMax-SRP_RelMin)))), SRP_Points)","v":2.2105263157894735},0,{"$f":"IF(20<=Rain_RelMax, IF(20<=Rain_RelMin, 0, (Rain_Points*((20-Rain_RelMin)/(Rain_RelMax-Rain_RelMin)))), Rain_Points)","v":2.6950354609929077},{"$f":"IF((2-DITS_RelBest)>0, IF(2>=DITS_RelMax, 0, (DITS_Points*(1-((2-DITS_RelBest)/(DITS_RelMax-DITS_RelBest))))), (DITS_Points*((DITS_RelBest-(DITS_RelBest-2))/DITS_RelBest)))","v":2.4000000000000004},{"$f":"IF(1.5<=Fire_RelMax, IF(1.5<=Fire_RelMin, 0, (Fire_Points*((1.5-Fire_RelMin)/(Fire_RelMax-Fire_RelMin)))), Fire_Points)","v":0.125},{"$f":"IF(0>=DPower_RelMax, 1, 0)","v":0},{"$f":"IF(0>=DComm_RelMax, 1, 0)","v":0},null,null,0,{"$f":"IF(0.0690472565242891<=Rate_RelMax, IF(0.0690472565242891<=Rate_RelMin, 0, (Rate_Points*((0.0690472565242891-Rate_RelMin)/(Rate_RelMax-Rate_RelMin)))), Rate_Points)","v":0},{"$f":"IF(43<=WCrashNum_RelMax, IF(43<=WCrashNum_RelMin, 0, (WCrashNum_Points*((43-WCrashNum_RelMin)/(WCrashNum_RelMax-WCrashNum_RelMin)))), WCrashNum_Points)","v":0},"District 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50.81035245242564]
["US-64 MM390 (Des Moines)",25.543148866105788,{"$f":"IF(0.823529411764706<=Ratio_RelMax, IF(0.823529411764706<=Ratio_RelMin, 0, (Ratio_Points*((0.823529411764706-Ratio_RelMin)/(Ratio_RelMax-Ratio_RelMin)))), Ratio_Points)","v":9.6338099031487161},{"$f":"IF(35.5<=Snow_RelMax, IF(35.5<=Snow_RelMin, 0, (Snow_Points*((35.5-Snow_RelMin)/(Snow_RelMax-Snow_RelMin)))), Snow_Points)","v":5.1000000000000005},{"$f":"IF(3800<=AADT_RelMax, IF(3800<=AADT_RelMin, 0, (AADT_Points*((3800-AADT_RelMin)/(AADT_RelMax-AADT_RelMin)))), AADT_Points)","v":0.2587646076794658},0,{"$f":"IF(200<=Topo_RelMax, IF(200<=Topo_RelMin, 0, (Topo_Points*((200-Topo_RelMin)/(Topo_RelMax-Topo_RelMin)))), Topo_Points)","v":1.8409090909090911},{"$f":"IF((4-DPatrol_RelBest)>0, IF(4>=DPatrol_RelMax, 0, (DPatrol_Points*(1-((4-DPatrol_RelBest)/(DPatrol_RelMax-DPatrol_RelBest))))), (DPatrol_Points*((DPatrol_RelBest-(DPatrol_RelBest-4))/DPatrol_RelBest)))","v":2.8000000000000003},{"$f":"IF(1970<=Alt_RelMax, IF(1970<=Alt_RelMin, 0, (Alt_Points*((1970-Alt_RelMin)/(Alt_RelMax-Alt_RelMin)))), Alt_Points)","v":2.7162162162162162},{"$f":"IF(4<=SRP_RelMax, IF(4<=SRP_RelMin, 0, (SRP_Points*((4-SRP_RelMin)/(SRP_RelMax-SRP_RelMin)))), SRP_Points)","v":0.31578947368421051},0,{"$f":"IF(18<=Rain_RelMax, IF(18<=Rain_RelMin, 0, (Rain_Points*((18-Rain_RelMin)/(Rain_RelMax-Rain_RelMin)))), Rain_Points)","v":2.1276595744680851},{"$f":"IF((15.5-DITS_RelBest)>0, IF(15.5>=DITS_RelMax, 0, (DITS_Points*(1-((15.5-DITS_RelBest)/(DITS_RelMax-DITS_RelBest))))), (DITS_Points*((DITS_RelBest-(DITS_RelBest-15.5))/DITS_RelBest)))","v":0},{"$f":"IF(4<=Fire_RelMax, IF(4<=Fire_RelMin, 0, (Fire_Points*((4-Fire_RelMin)/(Fire_RelMax-Fire_RelMin)))), Fire_Points)","v":0.75},{"$f":"IF(0>=DPower_RelMax, 1, 0)","v":0},{"$f":"IF(0>=DComm_RelMax, 1, 0)","v":0},null,null,0,{"$f":"IF(1.07621655731038<=Rate_RelMax, IF(1.07621655731038<=Rate_RelMin, 0, (Rate_Points*((1.07621655731038-Rate_RelMin)/(Rate_RelMax-Rate_RelMin)))), Rate_Points)","v":0},{"$f":"IF(14<=WCrashNum_RelMax, IF(14<=WCrashNum_RelMin, 0, (WCrashNum_Points*((14-WCrashNum_RelMin)/(WCrashNum_RelMax-WCrashNum_RelMin)))), WCrashNum_Points)","v":0},"District 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50.449999999999996]
["NM-38 MM18 (Red River)",41.202320773232906,{"$f":"IF(0.476190476190476<=Ratio_RelMax, IF(0.476190476190476<=Ratio_RelMin, 0, (Ratio_Points*((0.476190476190476-Ratio_RelMin)/(Ratio_RelMax-Ratio_RelMin)))), Ratio_Points)","v":5.2964056613379471},{"$f":"IF(85<=Snow_RelMax, IF(85<=Snow_RelMin, 0, (Snow_Points*((85-Snow_RelMin)/(Snow_RelMax-Snow_RelMin)))), Snow_Points)","v":15},{"$f":"IF(700<=AADT_RelMax, IF(700<=AADT_RelMin, 0, (AADT_Points*((700-AADT_RelMin)/(AADT_RelMax-AADT_RelMin)))), AADT_Points)","v":0},0,{"$f":"IF(600<=Topo_RelMax, IF(600<=Topo_RelMin, 0, (Topo_Points*((600-Topo_RelMin)/(Topo_RelMax-Topo_RelMin)))), Topo_Points)","v":5.9318181818181817},{"$f":"IF((8.1-DPatrol_RelBest)>0, IF(8.1>=DPatrol_RelMax, 0, (DPatrol_Points*(1-((8.1-DPatrol_RelBest)/(DPatrol_RelMax-DPatrol_RelBest))))), (DPatrol_Points*((DPatrol_RelBest-(DPatrol_RelBest-8.1))/DPatrol_RelBest)))","v":5.67},{"$f":"IF(2750<=Alt_RelMax, IF(2750<=Alt_RelMin, 0, (Alt_Points*((2750-Alt_RelMin)/(Alt_RelMax-Alt_RelMin)))), Alt_Points)","v":5.8783783783783781},{"$f":"IF(4<=SRP_RelMax, IF(4<=SRP_RelMin, 0, (SRP_Points*((4-SRP_RelMin)/(SRP_RelMax-SRP_RelMin)))), SRP_Points)","v":0.31578947368421051},0,{"$f":"IF(19.7<=Rain_RelMax, IF(19.7<=Rain_RelMin, 0, (Rain_Points*((19.7-Rain_RelMin)/(Rain_RelMax-Rain_RelMin)))), Rain_Points)","v":2.6099290780141837},{"$f":"IF((70-DITS_RelBest)>0, IF(70>=DITS_RelMax, 0, (DITS_Points*(1-((70-DITS_RelBest)/(DITS_RelMax-DITS_RelBest))))), (DITS_Points*((DITS_RelBest-(DITS_RelBest-70))/DITS_RelBest)))","v":0},{"$f":"IF(3<=Fire_RelMax, IF(3<=Fire_RelMin, 0, (Fire_Points*((3-Fire_RelMin)/(Fire_RelMax-Fire_RelMin)))), Fire_Points)","v":0.5},{"$f":"IF(7>=DPower_RelMax, 1, 0)","v":1},{"$f":"IF(7>=DComm_RelMax, 1, 0)","v":1},null,null,0,{"$f":"IF(3.74700281928239<=Rate_RelMax, IF(3.74700281928239<=Rate_RelMin, 0, (Rate_Points*((3.74700281928239-Rate_RelMin)/(Rate_RelMax-Rate_RelMin)))), Rate_Points)","v":0},{"$f":"IF(10<=WCrashNum_RelMax, IF(10<=WCrashNum_RelMin, 0, (WCrashNum_Points*((10-WCrashNum_RelMin)/(WCrashNum_RelMax-WCrashNum_RelMin)))), WCrashNum_Points)","v":0},"District 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49.530073260073259]
["I-40/US-285 (Clines Corners)",23.96667496104293,{"$f":"IF(0.882352941176471<=Ratio_RelMax, IF(0.882352941176471<=Ratio_RelMin, 0, (Ratio_Points*((0.882352941176471-Ratio_RelMin)/(Ratio_RelMax-Ratio_RelMin)))), Ratio_Points)","v":10.368370298939253},{"$f":"IF(31.4<=Snow_RelMax, IF(31.4<=Snow_RelMin, 0, (Snow_Points*((31.4-Snow_RelMin)/(Snow_RelMax-Snow_RelMin)))), Snow_Points)","v":4.28},{"$f":"IF(16000<=AADT_RelMax, IF(16000<=AADT_RelMin, 0, (AADT_Points*((16000-AADT_RelMin)/(AADT_RelMax-AADT_RelMin)))), AADT_Points)","v":1.2771285475792988},0,{"$f":"IF(20<=Topo_RelMax, IF(20<=Topo_RelMin, 0, (Topo_Points*((20-Topo_RelMin)/(Topo_RelMax-Topo_RelMin)))), Topo_Points)","v":0},{"$f":"IF((0.5-DPatrol_RelBest)>0, IF(0.5>=DPatrol_RelMax, 0, (DPatrol_Points*(1-((0.5-DPatrol_RelBest)/(DPatrol_RelMax-DPatrol_RelBest))))), (DPatrol_Points*((DPatrol_RelBest-(DPatrol_RelBest-0.5))/DPatrol_RelBest)))","v":0.35000000000000003},{"$f":"IF(2152<=Alt_RelMax, IF(2152<=Alt_RelMin, 0, (Alt_Points*((2152-Alt_RelMin)/(Alt_RelMax-Alt_RelMin)))), Alt_Points)","v":3.4540540540540539},{"$f":"IF(10<=SRP_RelMax, IF(10<=SRP_RelMin, 0, (SRP_Points*((10-SRP_RelMin)/(SRP_RelMax-SRP_RelMin)))), SRP_Points)","v":2.2105263157894735},0,{"$f":"IF(15<=Rain_RelMax, IF(15<=Rain_RelMin, 0, (Rain_Points*((15-Rain_RelMin)/(Rain_RelMax-Rain_RelMin)))), Rain_Points)","v":1.2765957446808509},{"$f":"IF((0-DITS_RelBest)>0, IF(0>=DITS_RelMax, 0, (DITS_Points*(1-((0-DITS_RelBest)/(DITS_RelMax-DITS_RelBest))))), (DITS_Points*((DITS_RelBest-(DITS_RelBest-0))/DITS_RelBest)))","v":0},{"$f":"IF(4<=Fire_RelMax, IF(4<=Fire_RelMin, 0, (Fire_Points*((4-Fire_RelMin)/(Fire_RelMax-Fire_RelMin)))), Fire_Points)","v":0.75},{"$f":"IF(0>=DPower_RelMax, 1, 0)","v":0},{"$f":"IF(0>=DComm_RelMax, 1, 0)","v":0},null,null,0,{"$f":"IF(7.86915793714746<=Rate_RelMax, IF(7.86915793714746<=Rate_RelMin, 0, (Rate_Points*((7.86915793714746-Rate_RelMin)/(Rate_RelMax-Rate_RelMin)))), Rate_Points)","v":0},{"$f":"IF(15<=WCrashNum_RelMax, IF(15<=WCrashNum_RelMin, 0, (WCrashNum_Points*((15-WCrashNum_RelMin)/(WCrashNum_RelMax-WCrashNum_RelMin)))), WCrashNum_Points)","v":0},"District 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47.394523809523797]
["US-64 MM273 (Palo Flechado Pass)",33.58576389318462,{"$f":"IF(0.315068493150685<=Ratio_RelMax, IF(0.315068493150685<=Ratio_RelMin, 0, (Ratio_Points*((0.315068493150685-Ratio_RelMin)/(Ratio_RelMax-Ratio_RelMin)))), Ratio_Points)","v":3.2843905915894522},{"$f":"IF(55<=Snow_RelMax, IF(55<=Snow_RelMin, 0, (Snow_Points*((55-Snow_RelMin)/(Snow_RelMax-Snow_RelMin)))), Snow_Points)","v":9},{"$f":"IF(1400<=AADT_RelMax, IF(1400<=AADT_RelMin, 0, (AADT_Points*((1400-AADT_RelMin)/(AADT_RelMax-AADT_RelMin)))), AADT_Points)","v":5.8430717863105171E-2},0,{"$f":"IF(400<=Topo_RelMax, IF(400<=Topo_RelMin, 0, (Topo_Points*((400-Topo_RelMin)/(Topo_RelMax-Topo_RelMin)))), Topo_Points)","v":3.8863636363636362},{"$f":"IF((11.5-DPatrol_RelBest)>0, IF(11.5>=DPatrol_RelMax, 0, (DPatrol_Points*(1-((11.5-DPatrol_RelBest)/(DPatrol_RelMax-DPatrol_RelBest))))), (DPatrol_Points*((DPatrol_RelBest-(DPatrol_RelBest-11.5))/DPatrol_RelBest)))","v":6.4750000000000005},{"$f":"IF(2780<=Alt_RelMax, IF(2780<=Alt_RelMin, 0, (Alt_Points*((2780-Alt_RelMin)/(Alt_RelMax-Alt_RelMin)))), Alt_Points)","v":6},{"$f":"IF(5<=SRP_RelMax, IF(5<=SRP_RelMin, 0, (SRP_Points*((5-SRP_RelMin)/(SRP_RelMax-SRP_RelMin)))), SRP_Points)","v":0.63157894736842102},0,{"$f":"IF(24.6<=Rain_RelMax, IF(24.6<=Rain_RelMin, 0, (Rain_Points*((24.6-Rain_RelMin)/(Rain_RelMax-Rain_RelMin)))), Rain_Points)","v":4},{"$f":"IF((19.5-DITS_RelBest)>0, IF(19.5>=DITS_RelMax, 0, (DITS_Points*(1-((19.5-DITS_RelBest)/(DITS_RelMax-DITS_RelBest))))), (DITS_Points*((DITS_RelBest-(DITS_RelBest-19.5))/DITS_RelBest)))","v":0},{"$f":"IF(2<=Fire_RelMax, IF(2<=Fire_RelMin, 0, (Fire_Points*((2-Fire_RelMin)/(Fire_RelMax-Fire_RelMin)))), Fire_Points)","v":0.25},{"$f":"IF(0>=DPower_RelMax, 1, 0)","v":0},{"$f":"IF(0>=DComm_RelMax, 1, 0)","v":0},null,null,0,{"$f":"IF(1.08800492966519<=Rate_RelMax, IF(1.08800492966519<=Rate_RelMin, 0, (Rate_Points*((1.08800492966519-Rate_RelMin)/(Rate_RelMax-Rate_RelMin)))), Rate_Points)","v":0},{"$f":"IF(23<=WCrashNum_RelMax, IF(23<=WCrashNum_RelMin, 0, (WCrashNum_Points*((23-WCrashNum_RelMin)/(WCrashNum_RelMax-WCrashNum_RelMin)))), WCrashNum_Points)","v":0},"District 4/5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47.026136534698175]
["I-25 MM331 (Serafina)",24.380048700860627,{"$f":"IF(0.533333333333333<=Ratio_RelMax, IF(0.533333333333333<=Ratio_RelMin, 0, (Ratio_Points*((0.533333333333333-Ratio_RelMin)/(Ratio_RelMax-Ratio_RelMin)))), Ratio_Points)","v":6.0099786172487484},{"$f":"IF(34.5<=Snow_RelMax, IF(34.5<=Snow_RelMin, 0, (Snow_Points*((34.5-Snow_RelMin)/(Snow_RelMax-Snow_RelMin)))), Snow_Points)","v":4.9000000000000004},{"$f":"IF(8700<=AADT_RelMax, IF(8700<=AADT_RelMin, 0, (AADT_Points*((8700-AADT_RelMin)/(AADT_RelMax-AADT_RelMin)))), AADT_Points)","v":0.667779632721202},0,{"$f":"IF(100<=Topo_RelMax, IF(100<=Topo_RelMin, 0, (Topo_Points*((100-Topo_RelMin)/(Topo_RelMax-Topo_RelMin)))), Topo_Points)","v":0.81818181818181823},{"$f":"IF((14-DPatrol_RelBest)>0, IF(14>=DPatrol_RelMax, 0, (DPatrol_Points*(1-((14-DPatrol_RelBest)/(DPatrol_RelMax-DPatrol_RelBest))))), (DPatrol_Points*((DPatrol_RelBest-(DPatrol_RelBest-14))/DPatrol_RelBest)))","v":5.6000000000000005},{"$f":"IF(1950<=Alt_RelMax, IF(1950<=Alt_RelMin, 0, (Alt_Points*((1950-Alt_RelMin)/(Alt_RelMax-Alt_RelMin)))), Alt_Points)","v":2.6351351351351351},{"$f":"IF(7<=SRP_RelMax, IF(7<=SRP_RelMin, 0, (SRP_Points*((7-SRP_RelMin)/(SRP_RelMax-SRP_RelMin)))), SRP_Points)","v":1.263157894736842},0,{"$f":"IF(17.5<=Rain_RelMax, IF(17.5<=Rain_RelMin, 0, (Rain_Points*((17.5-Rain_RelMin)/(Rain_RelMax-Rain_RelMin)))), Rain_Points)","v":1.9858156028368792},{"$f":"IF((38-DITS_RelBest)>0, IF(38>=DITS_RelMax, 0, (DITS_Points*(1-((38-DITS_RelBest)/(DITS_RelMax-DITS_RelBest))))), (DITS_Points*((DITS_RelBest-(DITS_RelBest-38))/DITS_RelBest)))","v":0},{"$f":"IF(3<=Fire_RelMax, IF(3<=Fire_RelMin, 0, (Fire_Points*((3-Fire_RelMin)/(Fire_RelMax-Fire_RelMin)))), Fire_Points)","v":0.5},{"$f":"IF(15>=DPower_RelMax, 1, 0)","v":1},{"$f":"IF(15>=DComm_RelMax, 1, 0)","v":1},null,null,0,{"$f":"IF(1.12418041100176<=Rate_RelMax, IF(1.12418041100176<=Rate_RelMin, 0, (Rate_Points*((1.12418041100176-Rate_RelMin)/(Rate_RelMax-Rate_RelMin)))), Rate_Points)","v":0},{"$f":"IF(16<=WCrashNum_RelMax, IF(16<=WCrashNum_RelMin, 0, (WCrashNum_Points*((16-WCrashNum_RelMin)/(WCrashNum_RelMax-WCrashNum_RelMin)))), WCrashNum_Points)","v":0},"District 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46.353373015873004]
["US-60 MM260 (West of Vaughn)",28.755337578940964,{"$f":"IF(1.125<=Ratio_RelMax, IF(1.125<=Ratio_RelMin, 0, (Ratio_Points*((1.125-Ratio_RelMin)/(Ratio_RelMax-Ratio_RelMin)))), Ratio_Points)","v":13.398431931575198},{"$f":"IF(21<=Snow_RelMax, IF(21<=Snow_RelMin, 0, (Snow_Points*((21-Snow_RelMin)/(Snow_RelMax-Snow_RelMin)))), Snow_Points)","v":2.2000000000000002},{"$f":"IF(2500<=AADT_RelMax, IF(2500<=AADT_RelMin, 0, (AADT_Points*((2500-AADT_RelMin)/(AADT_RelMax-AADT_RelMin)))), AADT_Points)","v":0.15025041736227046},0,{"$f":"IF(100<=Topo_RelMax, IF(100<=Topo_RelMin, 0, (Topo_Points*((100-Topo_RelMin)/(Topo_RelMax-Topo_RelMin)))), Topo_Points)","v":0.81818181818181823},{"$f":"IF((8-DPatrol_RelBest)>0, IF(8>=DPatrol_RelMax, 0, (DPatrol_Points*(1-((8-DPatrol_RelBest)/(DPatrol_RelMax-DPatrol_RelBest))))), (DPatrol_Points*((DPatrol_RelBest-(DPatrol_RelBest-8))/DPatrol_RelBest)))","v":5.6000000000000005},{"$f":"IF(1880<=Alt_RelMax, IF(1880<=Alt_RelMin, 0, (Alt_Points*((1880-Alt_RelMin)/(Alt_RelMax-Alt_RelMin)))), Alt_Points)","v":2.3513513513513513},{"$f":"IF(10<=SRP_RelMax, IF(10<=SRP_RelMin, 0, (SRP_Points*((10-SRP_RelMin)/(SRP_RelMax-SRP_RelMin)))), SRP_Points)","v":2.2105263157894735},0,{"$f":"IF(15<=Rain_RelMax, IF(15<=Rain_RelMin, 0, (Rain_Points*((15-Rain_RelMin)/(Rain_RelMax-Rain_RelMin)))), Rain_Points)","v":1.2765957446808509},{"$f":"IF((32-DITS_RelBest)>0, IF(32>=DITS_RelMax, 0, (DITS_Points*(1-((32-DITS_RelBest)/(DITS_RelMax-DITS_RelBest))))), (DITS_Points*((DITS_RelBest-(DITS_RelBest-32))/DITS_RelBest)))","v":0},{"$f":"IF(4<=Fire_RelMax, IF(4<=Fire_RelMin, 0, (Fire_Points*((4-Fire_RelMin)/(Fire_RelMax-Fire_RelMin)))), Fire_Points)","v":0.75},{"$f":"IF(7>=DPower_RelMax, 1, 0)","v":1},{"$f":"IF(7>=DComm_RelMax, 1, 0)","v":1},null,null,0,{"$f":"IF(3.01731941343311<=Rate_RelMax, IF(3.01731941343311<=Rate_RelMin, 0, (Rate_Points*((3.01731941343311-Rate_RelMin)/(Rate_RelMax-Rate_RelMin)))), Rate_Points)","v":0},{"$f":"IF(9<=WCrashNum_RelMax, IF(9<=WCrashNum_RelMin, 0, (WCrashNum_Points*((9-WCrashNum_RelMin)/(WCrashNum_RelMax-WCrashNum_RelMin)))), WCrashNum_Points)","v":0},"District 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43.3595238095238]
["I-40 MM70 (West of Grants)",22.938324645584125,{"$f":"IF(0.684210526315789<=Ratio_RelMax, IF(0.684210526315789<=Ratio_RelMin, 0, (Ratio_Points*((0.684210526315789-Ratio_RelMin)/(Ratio_RelMax-Ratio_RelMin)))), Ratio_Points)","v":7.894061597329026},{"$f":"IF(20.5<=Snow_RelMax, IF(20.5<=Snow_RelMin, 0, (Snow_Points*((20.5-Snow_RelMin)/(Snow_RelMax-Snow_RelMin)))), Snow_Points)","v":2.1},{"$f":"IF(23100<=AADT_RelMax, IF(23100<=AADT_RelMin, 0, (AADT_Points*((23100-AADT_RelMin)/(AADT_RelMax-AADT_RelMin)))), AADT_Points)","v":1.8697829716193655},0,{"$f":"IF(50<=Topo_RelMax, IF(50<=Topo_RelMin, 0, (Topo_Points*((50-Topo_RelMin)/(Topo_RelMax-Topo_RelMin)))), Topo_Points)","v":0.30681818181818177},{"$f":"IF((7-DPatrol_RelBest)>0, IF(7>=DPatrol_RelMax, 0, (DPatrol_Points*(1-((7-DPatrol_RelBest)/(DPatrol_RelMax-DPatrol_RelBest))))), (DPatrol_Points*((DPatrol_RelBest-(DPatrol_RelBest-7))/DPatrol_RelBest)))","v":4.8999999999999995},{"$f":"IF(2060<=Alt_RelMax, IF(2060<=Alt_RelMin, 0, (Alt_Points*((2060-Alt_RelMin)/(Alt_RelMax-Alt_RelMin)))), Alt_Points)","v":3.0810810810810807},{"$f":"IF(9<=SRP_RelMax, IF(9<=SRP_RelMin, 0, (SRP_Points*((9-SRP_RelMin)/(SRP_RelMax-SRP_RelMin)))), SRP_Points)","v":1.8947368421052631},0,{"$f":"IF(11<=Rain_RelMax, IF(11<=Rain_RelMin, 0, (Rain_Points*((11-Rain_RelMin)/(Rain_RelMax-Rain_RelMin)))), Rain_Points)","v":0.14184397163120566},{"$f":"IF((50-DITS_RelBest)>0, IF(50>=DITS_RelMax, 0, (DITS_Points*(1-((50-DITS_RelBest)/(DITS_RelMax-DITS_RelBest))))), (DITS_Points*((DITS_RelBest-(DITS_RelBest-50))/DITS_RelBest)))","v":0},{"$f":"IF(4<=Fire_RelMax, IF(4<=Fire_RelMin, 0, (Fire_Points*((4-Fire_RelMin)/(Fire_RelMax-Fire_RelMin)))), Fire_Points)","v":0.75},{"$f":"IF(6>=DPower_RelMax, 1, 0)","v":1},{"$f":"IF(6>=DComm_RelMax, 1, 0)","v":1},null,null,0,{"$f":"IF(0.320875144799383<=Rate_RelMax, IF(0.320875144799383<=Rate_RelMin, 0, (Rate_Points*((0.320875144799383-Rate_RelMin)/(Rate_RelMax-Rate_RelMin)))), Rate_Points)","v":0},{"$f":"IF(52<=WCrashNum_RelMax, IF(52<=WCrashNum_RelMin, 0, (WCrashNum_Points*((52-WCrashNum_RelMin)/(WCrashNum_RelMax-WCrashNum_RelMin)))), WCrashNum_Points)","v":0},"District 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43.217669976222588]
["NM-550 MM110",19.829426684270423,{"$f":"IF(0.846153846153846<=Ratio_RelMax, IF(0.846153846153846<=Ratio_RelMin, 0, (Ratio_Points*((0.846153846153846-Ratio_RelMin)/(Ratio_RelMax-Ratio_RelMin)))), Ratio_Points)","v":9.9163331322989183},{"$f":"IF(26.4<=Snow_RelMax, IF(26.4<=Snow_RelMin, 0, (Snow_Points*((26.4-Snow_RelMin)/(Snow_RelMax-Snow_RelMin)))), Snow_Points)","v":3.28},{"$f":"IF(5700<=AADT_RelMax, IF(5700<=AADT_RelMin, 0, (AADT_Points*((5700-AADT_RelMin)/(AADT_RelMax-AADT_RelMin)))), AADT_Points)","v":0.41736227045075125},0,{"$f":"IF(200<=Topo_RelMax, IF(200<=Topo_RelMin, 0, (Topo_Points*((200-Topo_RelMin)/(Topo_RelMax-Topo_RelMin)))), Topo_Points)","v":1.8409090909090911},{"$f":"IF((37-DPatrol_RelBest)>0, IF(37>=DPatrol_RelMax, 0, (DPatrol_Points*(1-((37-DPatrol_RelBest)/(DPatrol_RelMax-DPatrol_RelBest))))), (DPatrol_Points*((DPatrol_RelBest-(DPatrol_RelBest-37))/DPatrol_RelBest)))","v":0},{"$f":"IF(2100<=Alt_RelMax, IF(2100<=Alt_RelMin, 0, (Alt_Points*((2100-Alt_RelMin)/(Alt_RelMax-Alt_RelMin)))), Alt_Points)","v":3.2432432432432434},{"$f":"IF(5<=SRP_RelMax, IF(5<=SRP_RelMin, 0, (SRP_Points*((5-SRP_RelMin)/(SRP_RelMax-SRP_RelMin)))), SRP_Points)","v":0.63157894736842102},0,{"$f":"IF(10.5<=Rain_RelMax, IF(10.5<=Rain_RelMin, 0, (Rain_Points*((10.5-Rain_RelMin)/(Rain_RelMax-Rain_RelMin)))), Rain_Points)","v":0},{"$f":"IF((65-DITS_RelBest)>0, IF(65>=DITS_RelMax, 0, (DITS_Points*(1-((65-DITS_RelBest)/(DITS_RelMax-DITS_RelBest))))), (DITS_Points*((DITS_RelBest-(DITS_RelBest-65))/DITS_RelBest)))","v":0},{"$f":"IF(3<=Fire_RelMax, IF(3<=Fire_RelMin, 0, (Fire_Points*((3-Fire_RelMin)/(Fire_RelMax-Fire_RelMin)))), Fire_Points)","v":0.5},{"$f":"IF(40>=DPower_RelMax, 1, 0)","v":1},{"$f":"IF(40>=DComm_RelMax, 1, 0)","v":1},null,null,0,{"$f":"IF(0.655873194049061<=Rate_RelMax, IF(0.655873194049061<=Rate_RelMin, 0, (Rate_Points*((0.655873194049061-Rate_RelMin)/(Rate_RelMax-Rate_RelMin)))), Rate_Points)","v":0},{"$f":"IF(44<=WCrashNum_RelMax, IF(44<=WCrashNum_RelMin, 0, (WCrashNum_Points*((44-WCrashNum_RelMin)/(WCrashNum_RelMax-WCrashNum_RelMin)))), WCrashNum_Points)","v":0},"District 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41.68630952380952]
["I-25 MM268 (La Bajada)",22.339887114956259,{"$f":"IF(0.252631578947368<=Ratio_RelMax, IF(0.252631578947368<=Ratio_RelMin, 0, (Ratio_Points*((0.252631578947368-Ratio_RelMin)/(Ratio_RelMax-Ratio_RelMin)))), Ratio_Points)","v":2.5047079566342743},{"$f":"IF(20.5<=Snow_RelMax, IF(20.5<=Snow_RelMin, 0, (Snow_Points*((20.5-Snow_RelMin)/(Snow_RelMax-Snow_RelMin)))), Snow_Points)","v":2.1},{"$f":"IF(33800<=AADT_RelMax, IF(33800<=AADT_RelMin, 0, (AADT_Points*((33800-AADT_RelMin)/(AADT_RelMax-AADT_RelMin)))), AADT_Points)","v":2.7629382303839733},0,{"$f":"IF(75<=Topo_RelMax, IF(75<=Topo_RelMin, 0, (Topo_Points*((75-Topo_RelMin)/(Topo_RelMax-Topo_RelMin)))), Topo_Points)","v":0.5625},{"$f":"IF((9-DPatrol_RelBest)>0, IF(9>=DPatrol_RelMax, 0, (DPatrol_Points*(1-((9-DPatrol_RelBest)/(DPatrol_RelMax-DPatrol_RelBest))))), (DPatrol_Points*((DPatrol_RelBest-(DPatrol_RelBest-9))/DPatrol_RelBest)))","v":6.3},{"$f":"IF(1850<=Alt_RelMax, IF(1850<=Alt_RelMin, 0, (Alt_Points*((1850-Alt_RelMin)/(Alt_RelMax-Alt_RelMin)))), Alt_Points)","v":2.2297297297297298},{"$f":"IF(8<=SRP_RelMax, IF(8<=SRP_RelMin, 0, (SRP_Points*((8-SRP_RelMin)/(SRP_RelMax-SRP_RelMin)))), SRP_Points)","v":1.5789473684210527},0,{"$f":"IF(13.5<=Rain_RelMax, IF(13.5<=Rain_RelMin, 0, (Rain_Points*((13.5-Rain_RelMin)/(Rain_RelMax-Rain_RelMin)))), Rain_Points)","v":0.85106382978723394},{"$f":"IF((3-DITS_RelBest)>0, IF(3>=DITS_RelMax, 0, (DITS_Points*(1-((3-DITS_RelBest)/(DITS_RelMax-DITS_RelBest))))), (DITS_Points*((DITS_RelBest-(DITS_RelBest-3))/DITS_RelBest)))","v":2.7},{"$f":"IF(4<=Fire_RelMax, IF(4<=Fire_RelMin, 0, (Fire_Points*((4-Fire_RelMin)/(Fire_RelMax-Fire_RelMin)))), Fire_Points)","v":0.75},{"$f":"IF(7>=DPower_RelMax, 1, 0)","v":1},{"$f":"IF(7>=DComm_RelMax, 1, 0)","v":1},null,null,0,{"$f":"IF(0.172369979923638<=Rate_RelMax, IF(0.172369979923638<=Rate_RelMin, 0, (Rate_Points*((0.172369979923638-Rate_RelMin)/(Rate_RelMax-Rate_RelMin)))), Rate_Points)","v":0},{"$f":"IF(24<=WCrashNum_RelMax, IF(24<=WCrashNum_RelMin, 0, (WCrashNum_Points*((24-WCrashNum_RelMin)/(WCrashNum_RelMax-WCrashNum_RelMin)))), WCrashNum_Points)","v":0},"District 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41.160656448814336]
["NM-68 MM16 (Velarde)",19.036809580359883,{"$f":"IF(0.280701754385965<=Ratio_RelMax, IF(0.280701754385965<=Ratio_RelMin, 0, (Ratio_Points*((0.280701754385965-Ratio_RelMin)/(Ratio_RelMax-Ratio_RelMin)))), Ratio_Points)","v":2.8552350226957284},{"$f":"IF(31.1<=Snow_RelMax, IF(31.1<=Snow_RelMin, 0, (Snow_Points*((31.1-Snow_RelMin)/(Snow_RelMax-Snow_RelMin)))), Snow_Points)","v":4.2200000000000006},{"$f":"IF(5700<=AADT_RelMax, IF(5700<=AADT_RelMin, 0, (AADT_Points*((5700-AADT_RelMin)/(AADT_RelMax-AADT_RelMin)))), AADT_Points)","v":0.41736227045075125},0,{"$f":"IF(360<=Topo_RelMax, IF(360<=Topo_RelMin, 0, (Topo_Points*((360-Topo_RelMin)/(Topo_RelMax-Topo_RelMin)))), Topo_Points)","v":3.4772727272727271},{"$f":"IF((7.5-DPatrol_RelBest)>0, IF(7.5>=DPatrol_RelMax, 0, (DPatrol_Points*(1-((7.5-DPatrol_RelBest)/(DPatrol_RelMax-DPatrol_RelBest))))), (DPatrol_Points*((DPatrol_RelBest-(DPatrol_RelBest-7.5))/DPatrol_RelBest)))","v":5.25},{"$f":"IF(1770<=Alt_RelMax, IF(1770<=Alt_RelMin, 0, (Alt_Points*((1770-Alt_RelMin)/(Alt_RelMax-Alt_RelMin)))), Alt_Points)","v":1.9054054054054053},{"$f":"IF(4<=SRP_RelMax, IF(4<=SRP_RelMin, 0, (SRP_Points*((4-SRP_RelMin)/(SRP_RelMax-SRP_RelMin)))), SRP_Points)","v":0.31578947368421051},0,{"$f":"IF(12.6<=Rain_RelMax, IF(12.6<=Rain_RelMin, 0, (Rain_Points*((12.6-Rain_RelMin)/(Rain_RelMax-Rain_RelMin)))), Rain_Points)","v":0.59574468085106369},{"$f":"IF((12-DITS_RelBest)>0, IF(12>=DITS_RelMax, 0, (DITS_Points*(1-((12-DITS_RelBest)/(DITS_RelMax-DITS_RelBest))))), (DITS_Points*((DITS_RelBest-(DITS_RelBest-12))/DITS_RelBest)))","v":0},{"$f":"IF(1<=Fire_RelMax, IF(1<=Fire_RelMin, 0, (Fire_Points*((1-Fire_RelMin)/(Fire_RelMax-Fire_RelMin)))), Fire_Points)","v":0},{"$f":"IF(0>=DPower_RelMax, 1, 0)","v":0},{"$f":"IF(0>=DComm_RelMax, 1, 0)","v":0},null,null,0,{"$f":"IF(0.506457709306215<=Rate_RelMax, IF(0.506457709306215<=Rate_RelMin, 0, (Rate_Points*((0.506457709306215-Rate_RelMin)/(Rate_RelMax-Rate_RelMin)))), Rate_Points)","v":0},{"$f":"IF(16<=WCrashNum_RelMax, IF(16<=WCrashNum_RelMin, 0, (WCrashNum_Points*((16-WCrashNum_RelMin)/(WCrashNum_RelMax-WCrashNum_RelMin)))), WCrashNum_Points)","v":0},"District 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36.935543184885297]
["I-25 MM257 (San Felipe Pueblo)",14.542534151939771,{"$f":"IF(0.273809523809524<=Ratio_RelMax, IF(0.273809523809524<=Ratio_RelMin, 0, (Ratio_Points*((0.273809523809524-Ratio_RelMin)/(Ratio_RelMax-Ratio_RelMin)))), Ratio_Points)","v":2.7691681091538562},{"$f":"IF(20.5<=Snow_RelMax, IF(20.5<=Snow_RelMin, 0, (Snow_Points*((20.5-Snow_RelMin)/(Snow_RelMax-Snow_RelMin)))), Snow_Points)","v":2.1},{"$f":"IF(25000<=AADT_RelMax, IF(25000<=AADT_RelMin, 0, (AADT_Points*((25000-AADT_RelMin)/(AADT_RelMax-AADT_RelMin)))), AADT_Points)","v":2.028380634390651},0,{"$f":"IF(50<=Topo_RelMax, IF(50<=Topo_RelMin, 0, (Topo_Points*((50-Topo_RelMin)/(Topo_RelMax-Topo_RelMin)))), Topo_Points)","v":0.30681818181818177},{"$f":"IF((22-DPatrol_RelBest)>0, IF(22>=DPatrol_RelMax, 0, (DPatrol_Points*(1-((22-DPatrol_RelBest)/(DPatrol_RelMax-DPatrol_RelBest))))), (DPatrol_Points*((DPatrol_RelBest-(DPatrol_RelBest-22))/DPatrol_RelBest)))","v":2.8000000000000003},{"$f":"IF(1670<=Alt_RelMax, IF(1670<=Alt_RelMin, 0, (Alt_Points*((1670-Alt_RelMin)/(Alt_RelMax-Alt_RelMin)))), Alt_Points)","v":1.5},{"$f":"IF(8<=SRP_RelMax, IF(8<=SRP_RelMin, 0, (SRP_Points*((8-SRP_RelMin)/(SRP_RelMax-SRP_RelMin)))), SRP_Points)","v":1.5789473684210527},0,{"$f":"IF(13<=Rain_RelMax, IF(13<=Rain_RelMin, 0, (Rain_Points*((13-Rain_RelMin)/(Rain_RelMax-Rain_RelMin)))), Rain_Points)","v":0.70921985815602828},{"$f":"IF((14-DITS_RelBest)>0, IF(14>=DITS_RelMax, 0, (DITS_Points*(1-((14-DITS_RelBest)/(DITS_RelMax-DITS_RelBest))))), (DITS_Points*((DITS_RelBest-(DITS_RelBest-14))/DITS_RelBest)))","v":0},{"$f":"IF(4<=Fire_RelMax, IF(4<=Fire_RelMin, 0, (Fire_Points*((4-Fire_RelMin)/(Fire_RelMax-Fire_RelMin)))), Fire_Points)","v":0.75},{"$f":"IF(0>=DPower_RelMax, 1, 0)","v":0},{"$f":"IF(0>=DComm_RelMax, 1, 0)","v":0},null,null,{"$f":"IF(1 = 1, 1, 0)","v":1},{"$f":"IF(0.22426399968018<=Rate_RelMax, IF(0.22426399968018<=Rate_RelMin, 0, (Rate_Points*((0.22426399968018-Rate_RelMin)/(Rate_RelMax-Rate_RelMin)))), Rate_Points)","v":0},{"$f":"IF(23<=WCrashNum_RelMax, IF(23<=WCrashNum_RelMin, 0, (WCrashNum_Points*((23-WCrashNum_RelMin)/(WCrashNum_RelMax-WCrashNum_RelMin)))), WCrashNum_Points)","v":0},"District 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29.809737484737493]
["NM-550 MM27 (San Ysidro)",14.949062738734584,{"$f":"IF(0.513513513513513<=Ratio_RelMax, IF(0.513513513513513<=Ratio_RelMin, 0, (Ratio_Points*((0.513513513513513-Ratio_RelMin)/(Ratio_RelMax-Ratio_RelMin)))), Ratio_Points)","v":5.7624780874959001},{"$f":"IF(20.2<=Snow_RelMax, IF(20.2<=Snow_RelMin, 0, (Snow_Points*((20.2-Snow_RelMin)/(Snow_RelMax-Snow_RelMin)))), Snow_Points)","v":2.0399999999999996},{"$f":"IF(5100<=AADT_RelMax, IF(5100<=AADT_RelMin, 0, (AADT_Points*((5100-AADT_RelMin)/(AADT_RelMax-AADT_RelMin)))), AADT_Points)","v":0.36727879799666113},0,{"$f":"IF(150<=Topo_RelMax, IF(150<=Topo_RelMin, 0, (Topo_Points*((150-Topo_RelMin)/(Topo_RelMax-Topo_RelMin)))), Topo_Points)","v":1.3295454545454546},{"$f":"IF((3.5-DPatrol_RelBest)>0, IF(3.5>=DPatrol_RelMax, 0, (DPatrol_Points*(1-((3.5-DPatrol_RelBest)/(DPatrol_RelMax-DPatrol_RelBest))))), (DPatrol_Points*((DPatrol_RelBest-(DPatrol_RelBest-3.5))/DPatrol_RelBest)))","v":2.4499999999999997},{"$f":"IF(1680<=Alt_RelMax, IF(1680<=Alt_RelMin, 0, (Alt_Points*((1680-Alt_RelMin)/(Alt_RelMax-Alt_RelMin)))), Alt_Points)","v":1.5405405405405403},{"$f":"IF(3<=SRP_RelMax, IF(3<=SRP_RelMin, 0, (SRP_Points*((3-SRP_RelMin)/(SRP_RelMax-SRP_RelMin)))), SRP_Points)","v":0},0,{"$f":"IF(13<=Rain_RelMax, IF(13<=Rain_RelMin, 0, (Rain_Points*((13-Rain_RelMin)/(Rain_RelMax-Rain_RelMin)))), Rain_Points)","v":0.70921985815602828},{"$f":"IF((100-DITS_RelBest)>0, IF(100>=DITS_RelMax, 0, (DITS_Points*(1-((100-DITS_RelBest)/(DITS_RelMax-DITS_RelBest))))), (DITS_Points*((DITS_RelBest-(DITS_RelBest-100))/DITS_RelBest)))","v":0},{"$f":"IF(4<=Fire_RelMax, IF(4<=Fire_RelMin, 0, (Fire_Points*((4-Fire_RelMin)/(Fire_RelMax-Fire_RelMin)))), Fire_Points)","v":0.75},{"$f":"IF(3.5>=DPower_RelMax, 1, 0)","v":1},{"$f":"IF(3.5>=DComm_RelMax, 1, 0)","v":1},null,null,{"$f":"IF(0 = 1, 1, 0)","v":0},{"$f":"IF(0.354348190560829<=Rate_RelMax, IF(0.354348190560829<=Rate_RelMin, 0, (Rate_Points*((0.354348190560829-Rate_RelMin)/(Rate_RelMax-Rate_RelMin)))), Rate_Points)","v":0},{"$f":"IF(19<=WCrashNum_RelMax, IF(19<=WCrashNum_RelMin, 0, (WCrashNum_Points*((19-WCrashNum_RelMin)/(WCrashNum_RelMax-WCrashNum_RelMin)))), WCrashNum_Points)","v":0},"District 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29.294071956571944]
["US-70 MM255 (South of Ruidoso)",14.593557439235749,{"$f":"IF(0.102222222222222<=Ratio_RelMax, IF(0.102222222222222<=Ratio_RelMin, 0, (Ratio_Points*((0.102222222222222-Ratio_RelMin)/(Ratio_RelMax-Ratio_RelMin)))), Ratio_Points)","v":0.6264670943216889},{"$f":"IF(23<=Snow_RelMax, IF(23<=Snow_RelMin, 0, (Snow_Points*((23-Snow_RelMin)/(Snow_RelMax-Snow_RelMin)))), Snow_Points)","v":2.6},{"$f":"IF(7300<=AADT_RelMax, IF(7300<=AADT_RelMin, 0, (AADT_Points*((7300-AADT_RelMin)/(AADT_RelMax-AADT_RelMin)))), AADT_Points)","v":0.55091819699499167},0,{"$f":"IF(200<=Topo_RelMax, IF(200<=Topo_RelMin, 0, (Topo_Points*((200-Topo_RelMin)/(Topo_RelMax-Topo_RelMin)))), Topo_Points)","v":1.8409090909090911},{"$f":"IF((25-DPatrol_RelBest)>0, IF(25>=DPatrol_RelMax, 0, (DPatrol_Points*(1-((25-DPatrol_RelBest)/(DPatrol_RelMax-DPatrol_RelBest))))), (DPatrol_Points*((DPatrol_RelBest-(DPatrol_RelBest-25))/DPatrol_RelBest)))","v":1.75},{"$f":"IF(2200<=Alt_RelMax, IF(2200<=Alt_RelMin, 0, (Alt_Points*((2200-Alt_RelMin)/(Alt_RelMax-Alt_RelMin)))), Alt_Points)","v":3.6486486486486487},{"$f":"IF(5<=SRP_RelMax, IF(5<=SRP_RelMin, 0, (SRP_Points*((5-SRP_RelMin)/(SRP_RelMax-SRP_RelMin)))), SRP_Points)","v":0.63157894736842102},0,{"$f":"IF(20<=Rain_RelMax, IF(20<=Rain_RelMin, 0, (Rain_Points*((20-Rain_RelMin)/(Rain_RelMax-Rain_RelMin)))), Rain_Points)","v":2.6950354609929077},{"$f":"IF((90-DITS_RelBest)>0, IF(90>=DITS_RelMax, 0, (DITS_Points*(1-((90-DITS_RelBest)/(DITS_RelMax-DITS_RelBest))))), (DITS_Points*((DITS_RelBest-(DITS_RelBest-90))/DITS_RelBest)))","v":0},{"$f":"IF(2<=Fire_RelMax, IF(2<=Fire_RelMin, 0, (Fire_Points*((2-Fire_RelMin)/(Fire_RelMax-Fire_RelMin)))), Fire_Points)","v":0.25},{"$f":"IF(7>=DPower_RelMax, 1, 0)","v":1},{"$f":"IF(7>=DComm_RelMax, 1, 0)","v":1},null,null,{"$f":"IF(1 = 1, 1, 0)","v":1},{"$f":"IF(0.109863987666764<=Rate_RelMax, IF(0.109863987666764<=Rate_RelMin, 0, (Rate_Points*((0.109863987666764-Rate_RelMin)/(Rate_RelMax-Rate_RelMin)))), Rate_Points)","v":0},{"$f":"IF(23<=WCrashNum_RelMax, IF(23<=WCrashNum_RelMin, 0, (WCrashNum_Points*((23-WCrashNum_RelMin)/(WCrashNum_RelMax-WCrashNum_RelMin)))), WCrashNum_Points)","v":0},"District 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29.174343711843708]
["I-25/I-40 (The Big I)",26.620838683108094,{"$f":"IF(0.0532896085263374<=Ratio_RelMax, IF(0.0532896085263374<=Ratio_RelMin, 0, (Ratio_Points*((0.0532896085263374-Ratio_RelMin)/(Ratio_RelMax-Ratio_RelMin)))), Ratio_Points)","v":1.5419772901946698E-2},{"$f":"IF(12.5<=Snow_RelMax, IF(12.5<=Snow_RelMin, 0, (Snow_Points*((12.5-Snow_RelMin)/(Snow_RelMax-Snow_RelMin)))), Snow_Points)","v":0.5},{"$f":"IF(180400<=AADT_RelMax, IF(180400<=AADT_RelMin, 0, (AADT_Points*((180400-AADT_RelMin)/(AADT_RelMax-AADT_RelMin)))), AADT_Points)","v":15},0,{"$f":"IF(50<=Topo_RelMax, IF(50<=Topo_RelMin, 0, (Topo_Points*((50-Topo_RelMin)/(Topo_RelMax-Topo_RelMin)))), Topo_Points)","v":0.30681818181818177},{"$f":"IF((3-DPatrol_RelBest)>0, IF(3>=DPatrol_RelMax, 0, (DPatrol_Points*(1-((3-DPatrol_RelBest)/(DPatrol_RelMax-DPatrol_RelBest))))), (DPatrol_Points*((DPatrol_RelBest-(DPatrol_RelBest-3))/DPatrol_RelBest)))","v":2.1},{"$f":"IF(1536<=Alt_RelMax, IF(1536<=Alt_RelMin, 0, (Alt_Points*((1536-Alt_RelMin)/(Alt_RelMax-Alt_RelMin)))), Alt_Points)","v":0.95675675675675675},{"$f":"IF(22<=SRP_RelMax, IF(22<=SRP_RelMin, 0, (SRP_Points*((22-SRP_RelMin)/(SRP_RelMax-SRP_RelMin)))), SRP_Points)","v":6},0,{"$f":"IF(11<=Rain_RelMax, IF(11<=Rain_RelMin, 0, (Rain_Points*((11-Rain_RelMin)/(Rain_RelMax-Rain_RelMin)))), Rain_Points)","v":0.14184397163120566},{"$f":"IF((0.5-DITS_RelBest)>0, IF(0.5>=DITS_RelMax, 0, (DITS_Points*(1-((0.5-DITS_RelBest)/(DITS_RelMax-DITS_RelBest))))), (DITS_Points*((DITS_RelBest-(DITS_RelBest-0.5))/DITS_RelBest)))","v":0.60000000000000009},{"$f":"IF(5<=Fire_RelMax, IF(5<=Fire_RelMin, 0, (Fire_Points*((5-Fire_RelMin)/(Fire_RelMax-Fire_RelMin)))), Fire_Points)","v":1},{"$f":"IF(0>=DPower_RelMax, 1, 0)","v":0},{"$f":"IF(0>=DComm_RelMax, 1, 0)","v":0},null,null,{"$f":"IF(0 = 1, 1, 0)","v":0},{"$f":"IF(0.0187339512335522<=Rate_RelMax, IF(0.0187339512335522<=Rate_RelMin, 0, (Rate_Points*((0.0187339512335522-Rate_RelMin)/(Rate_RelMax-Rate_RelMin)))), Rate_Points)","v":0},{"$f":"IF(260<=WCrashNum_RelMax, IF(260<=WCrashNum_RelMin, 0, (WCrashNum_Points*((260-WCrashNum_RelMin)/(WCrashNum_RelMax-WCrashNum_RelMin)))), WCrashNum_Points)","v":0},"District 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28.143888888888892]
["NM-602 MM25 (South of Gallup)",14.298170898915746,{"$f":"IF(0.173267326732673<=Ratio_RelMax, IF(0.173267326732673<=Ratio_RelMin, 0, (Ratio_Points*((0.173267326732673-Ratio_RelMin)/(Ratio_RelMax-Ratio_RelMin)))), Ratio_Points)","v":1.5136447358206919},{"$f":"IF(26.5<=Snow_RelMax, IF(26.5<=Snow_RelMin, 0, (Snow_Points*((26.5-Snow_RelMin)/(Snow_RelMax-Snow_RelMin)))), Snow_Points)","v":3.3},{"$f":"IF(8200<=AADT_RelMax, IF(8200<=AADT_RelMin, 0, (AADT_Points*((8200-AADT_RelMin)/(AADT_RelMax-AADT_RelMin)))), AADT_Points)","v":0.62604340567612682},0,{"$f":"IF(100<=Topo_RelMax, IF(100<=Topo_RelMin, 0, (Topo_Points*((100-Topo_RelMin)/(Topo_RelMax-Topo_RelMin)))), Topo_Points)","v":0.81818181818181823},{"$f":"IF((5-DPatrol_RelBest)>0, IF(5>=DPatrol_RelMax, 0, (DPatrol_Points*(1-((5-DPatrol_RelBest)/(DPatrol_RelMax-DPatrol_RelBest))))), (DPatrol_Points*((DPatrol_RelBest-(DPatrol_RelBest-5))/DPatrol_RelBest)))","v":3.5},{"$f":"IF(2060<=Alt_RelMax, IF(2060<=Alt_RelMin, 0, (Alt_Points*((2060-Alt_RelMin)/(Alt_RelMax-Alt_RelMin)))), Alt_Points)","v":3.0810810810810807},{"$f":"IF(3<=SRP_RelMax, IF(3<=SRP_RelMin, 0, (SRP_Points*((3-SRP_RelMin)/(SRP_RelMax-SRP_RelMin)))), SRP_Points)","v":0},0,{"$f":"IF(13<=Rain_RelMax, IF(13<=Rain_RelMin, 0, (Rain_Points*((13-Rain_RelMin)/(Rain_RelMax-Rain_RelMin)))), Rain_Points)","v":0.70921985815602828},{"$f":"IF((29-DITS_RelBest)>0, IF(29>=DITS_RelMax, 0, (DITS_Points*(1-((29-DITS_RelBest)/(DITS_RelMax-DITS_RelBest))))), (DITS_Points*((DITS_RelBest-(DITS_RelBest-29))/DITS_RelBest)))","v":0},{"$f":"IF(4<=Fire_RelMax, IF(4<=Fire_RelMin, 0, (Fire_Points*((4-Fire_RelMin)/(Fire_RelMax-Fire_RelMin)))), Fire_Points)","v":0.75},{"$f":"IF(4>=DPower_RelMax, 1, 0)","v":1},{"$f":"IF(4>=DComm_RelMax, 1, 0)","v":1},null,null,{"$f":"IF(1 = 1, 1, 0)","v":1},{"$f":"IF(0.080571822181552<=Rate_RelMax, IF(0.080571822181552<=Rate_RelMin, 0, (Rate_Points*((0.080571822181552-Rate_RelMin)/(Rate_RelMax-Rate_RelMin)))), Rate_Points)","v":0},{"$f":"IF(35<=WCrashNum_RelMax, IF(35<=WCrashNum_RelMin, 0, (WCrashNum_Points*((35-WCrashNum_RelMin)/(WCrashNum_RelMax-WCrashNum_RelMin)))), WCrashNum_Points)","v":0},"District 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27.256281205043578]
["I-40 MM320 (West of Tucumcari)",15.045375617421358,{"$f":"IF(0.266666666666667<=Ratio_RelMax, IF(0.266666666666667<=Ratio_RelMin, 0, (Ratio_Points*((0.266666666666667-Ratio_RelMin)/(Ratio_RelMax-Ratio_RelMin)))), Ratio_Points)","v":2.6799714896650073},{"$f":"IF(15.4<=Snow_RelMax, IF(15.4<=Snow_RelMin, 0, (Snow_Points*((15.4-Snow_RelMin)/(Snow_RelMax-Snow_RelMin)))), Snow_Points)","v":1.08},{"$f":"IF(21000<=AADT_RelMax, IF(21000<=AADT_RelMin, 0, (AADT_Points*((21000-AADT_RelMin)/(AADT_RelMax-AADT_RelMin)))), AADT_Points)","v":1.6944908180300502},0,{"$f":"IF(20<=Topo_RelMax, IF(20<=Topo_RelMin, 0, (Topo_Points*((20-Topo_RelMin)/(Topo_RelMax-Topo_RelMin)))), Topo_Points)","v":0},{"$f":"IF((13-DPatrol_RelBest)>0, IF(13>=DPatrol_RelMax, 0, (DPatrol_Points*(1-((13-DPatrol_RelBest)/(DPatrol_RelMax-DPatrol_RelBest))))), (DPatrol_Points*((DPatrol_RelBest-(DPatrol_RelBest-13))/DPatrol_RelBest)))","v":5.95},{"$f":"IF(1370<=Alt_RelMax, IF(1370<=Alt_RelMin, 0, (Alt_Points*((1370-Alt_RelMin)/(Alt_RelMax-Alt_RelMin)))), Alt_Points)","v":0.28378378378378377},{"$f":"IF(7<=SRP_RelMax, IF(7<=SRP_RelMin, 0, (SRP_Points*((7-SRP_RelMin)/(SRP_RelMax-SRP_RelMin)))), SRP_Points)","v":1.263157894736842},0,{"$f":"IF(17<=Rain_RelMax, IF(17<=Rain_RelMin, 0, (Rain_Points*((17-Rain_RelMin)/(Rain_RelMax-Rain_RelMin)))), Rain_Points)","v":1.8439716312056735},{"$f":"IF((130-DITS_RelBest)>0, IF(130>=DITS_RelMax, 0, (DITS_Points*(1-((130-DITS_RelBest)/(DITS_RelMax-DITS_RelBest))))), (DITS_Points*((DITS_RelBest-(DITS_RelBest-130))/DITS_RelBest)))","v":0},{"$f":"IF(2<=Fire_RelMax, IF(2<=Fire_RelMin, 0, (Fire_Points*((2-Fire_RelMin)/(Fire_RelMax-Fire_RelMin)))), Fire_Points)","v":0.25},{"$f":"IF(10>=DPower_RelMax, 1, 0)","v":1},{"$f":"IF(10>=DComm_RelMax, 1, 0)","v":1},null,null,{"$f":"IF(0 = 1, 1, 0)","v":0},{"$f":"IF(0.113028498299133<=Rate_RelMax, IF(0.113028498299133<=Rate_RelMin, 0, (Rate_Points*((0.113028498299133-Rate_RelMin)/(Rate_RelMax-Rate_RelMin)))), Rate_Points)","v":0},{"$f":"IF(8<=WCrashNum_RelMax, IF(8<=WCrashNum_RelMin, 0, (WCrashNum_Points*((8-WCrashNum_RelMin)/(WCrashNum_RelMax-WCrashNum_RelMin)))), WCrashNum_Points)","v":0},"District 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25.129548229548234]
["US-70 MM435 (South of Clovis)",10.036832975950336,{"$f":"IF(0.0520547945205479<=Ratio_RelMax, IF(0.0520547945205479<=Ratio_RelMin, 0, (Ratio_Points*((0.0520547945205479-Ratio_RelMin)/(Ratio_RelMax-Ratio_RelMin)))), Ratio_Points)","v":0},{"$f":"IF(10<=Snow_RelMax, IF(10<=Snow_RelMin, 0, (Snow_Points*((10-Snow_RelMin)/(Snow_RelMax-Snow_RelMin)))), Snow_Points)","v":0},{"$f":"IF(16800<=AADT_RelMax, IF(16800<=AADT_RelMin, 0, (AADT_Points*((16800-AADT_RelMin)/(AADT_RelMax-AADT_RelMin)))), AADT_Points)","v":1.343906510851419},0,{"$f":"IF(20<=Topo_RelMax, IF(20<=Topo_RelMin, 0, (Topo_Points*((20-Topo_RelMin)/(Topo_RelMax-Topo_RelMin)))), Topo_Points)","v":0},{"$f":"IF((4-DPatrol_RelBest)>0, IF(4>=DPatrol_RelMax, 0, (DPatrol_Points*(1-((4-DPatrol_RelBest)/(DPatrol_RelMax-DPatrol_RelBest))))), (DPatrol_Points*((DPatrol_RelBest-(DPatrol_RelBest-4))/DPatrol_RelBest)))","v":2.8000000000000003},{"$f":"IF(1300<=Alt_RelMax, IF(1300<=Alt_RelMin, 0, (Alt_Points*((1300-Alt_RelMin)/(Alt_RelMax-Alt_RelMin)))), Alt_Points)","v":0},{"$f":"IF(5<=SRP_RelMax, IF(5<=SRP_RelMin, 0, (SRP_Points*((5-SRP_RelMin)/(SRP_RelMax-SRP_RelMin)))), SRP_Points)","v":0.63157894736842102},0,{"$f":"IF(19<=Rain_RelMax, IF(19<=Rain_RelMin, 0, (Rain_Points*((19-Rain_RelMin)/(Rain_RelMax-Rain_RelMin)))), Rain_Points)","v":2.4113475177304964},{"$f":"IF((4-DITS_RelBest)>0, IF(4>=DITS_RelMax, 0, (DITS_Points*(1-((4-DITS_RelBest)/(DITS_RelMax-DITS_RelBest))))), (DITS_Points*((DITS_RelBest-(DITS_RelBest-4))/DITS_RelBest)))","v":2.0999999999999996},{"$f":"IF(4<=Fire_RelMax, IF(4<=Fire_RelMin, 0, (Fire_Points*((4-Fire_RelMin)/(Fire_RelMax-Fire_RelMin)))), Fire_Points)","v":0.75},{"$f":"IF(1>=DPower_RelMax, 1, 0)","v":0},{"$f":"IF(1>=DComm_RelMax, 1, 0)","v":0},null,null,{"$f":"IF(0 = 1, 1, 0)","v":0},{"$f":"IF(0.0246487810752243<=Rate_RelMax, IF(0.0246487810752243<=Rate_RelMin, 0, (Rate_Points*((0.0246487810752243-Rate_RelMin)/(Rate_RelMax-Rate_RelMin)))), Rate_Points)","v":0},{"$f":"IF(19<=WCrashNum_RelMax, IF(19<=WCrashNum_RelMin, 0, (WCrashNum_Points*((19-WCrashNum_RelMin)/(WCrashNum_RelMax-WCrashNum_RelMin)))), WCrashNum_Points)","v":0},"District 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.982142857142858]

{"sheet":"Criteria & Importance","index":5,"n_rows":10,"n_cols":22,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Criteria","Ratio of Weather to Clear Crashes","Average annual snow (in)","2013 AADT","Average Wind Gust","Local Altitude Range (meters)","Dist Patrol Yard (mi)","Altitude (Meters)","Snow Removal Priority","Average Road Grade 2 Miles","Average Annual Rain (in)","Dist ITS Unit (mi)","Fire Risk (0 Very High, 5 No Risk)","Distance to Power (mi)","Distance to Communication (mi)","Local Environment","Functional Class","In Tribal Land?","Ratio of Crash Rates Per 100M Vehicle Miles","Number of Weather Related Crashes","Comment 1","Comment 2"]
["Sponsor's Importance Factor (1 to 13)",1,2,4,2,10,9,6,4,8,11,12,13,"-","-",6,"-","-","-","-"]
["Final Score (%)",16,15,15,12,9,7,6,6,6,4,3,1,"BOOLEAN","BOOLEAN","FLAG","-","BOOLEAN",0,0]
["Deal Killer",null,null,null,null,null,null,null,null,null,null,null,null,true,true,null,null,true]
["Have Data",null,null,null,false,null,null,null,null,false,null,null,null,false,false,false,null,null,true,true]
["Max Threshold",0.75,32,45000,null,200,10,2600,11,null,18,2.5,5,1.5,1.5,null,null,null,1,40]
["Min Threshold",0.1,12,5000,null,20,30,1400,4,null,9,7.5,0,null,null,null,null,null,0.09,15]
[]
["Max Relative",{"$f":"MAX('Data Input'!D:D)","v":1.3333333333333333},{"$f":"MAX('Data Input'!E:E)","v":85},{"$f":"MAX('Data Input'!F:F)","v":180400},{"$f":"MAX('Data Input'!G:G)","v":0},{"$f":"MAX('Data Input'!H:H)","v":900},10,{"$f":"MAX('Data Input'!J:J)","v":2780},{"$f":"MAX('Data Input'!K:K)","v":22},{"$f":"MAX('Data Input'!L:L)","v":0},{"$f":"MAX('Data Input'!M:M)","v":24.6},2.5,{"$f":"MAX('Data Input'!O:O)","v":5},1.5,1.5,null,null,null,{"$f":"MAX('Data Input'!Y2:Y65536)","v":20.053623388942029},{"$f":"MAX('Data Input'!B2:B65536)","v":260}]
["Min Relative",{"$f":"MIN('Data Input'!D:D)","v":5.2054794520547946E-2},{"$f":"MIN('Data Input'!E:E)","v":10},{"$f":"MIN('Data Input'!F:F)","v":700},{"$f":"MIN('Data Input'!G:G)","v":0},{"$f":"MIN('Data Input'!H:H)","v":20},30,{"$f":"MIN('Data Input'!J:J)","v":1300},{"$f":"MIN('Data Input'!K:K)","v":3},{"$f":"MIN('Data Input'!L:L)","v":0},{"$f":"MIN('Data Input'!M:M)","v":10.5},7.5,{"$f":"MIN('Data Input'!O:O)","v":1},null,null,null,null,null,{"$f":"MIN('Data Input'!Y2:Y65536)","v":1.8733951233552166E-2},{"$f":"MIN('Data Input'!B2:B65536)","v":8}]