{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Dataset","Program","Program Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":39,"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":"Dataset","index":0,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Segment ID","Road Name","Length","Existing PSI","ADT","ADTT"]
["222-1","Chalk Bluff Road/\"78\" Rd",6.1,0.3,168,72]
[3,"Albin/LaGrange Rd",10.7,0.9,108,22]
[6,"Black hills Rd",10.1,0.1,114,36]
["19-1","Old Highway Birns West",6.5,0.3,198,26]
[222,"Chalk Bluff Road/\"78\" Rd",5.5,1,168,72]
["21-2","Old Yellowstone Rd",2.7,0.2,36,6]
["21-1","Old Yellowstone Rd",1.9,0.9,36,6]
[21,"Old Yellowstone Rd",1.2,0,36,6]
[10,"Chalk Bluff Road/\"78\" Rd",7.7,1.4,350,40]
["18-1","Moffet Rd",4.5,1.3,26,1]
[15,"Hillslade Rd West",3.8,2.2000000000000002,372,62]
["14-1","Hillslade N Rd/Midway",5.0999999999999996,2.8,372,62]
[13,"Gillaspie Rd",4.8,2.8,37,7]
[18,"Moffet Rd",3.5,3.1,26,1]
[2,"A-118-1",2,3.2,34,7]
[11,"Chalk Hill/Bliss Rd",2,3.2,34,7]
[7,"Bristol Ridge/Hirsig Rd",1.6,2.9,31,1]
[8,"Bruegman Rd",1.3,2.9,24,4]
[1,"CR 140-1",4.3,2.4,328,40]
[5,"Bear Creek/marsh Rd",2.7,2.1,15,1]
[9,"Carpenter Rd/Berger Rd",2.5,3.1,518,243]
[14,"Hillslade N Rd/Midway",8.1,3.5,372,62]
["21-3","Old Yellowstone Rd",4.9000000000000004,3.6,36,6]

{"sheet":"Program","index":1,"n_rows":30,"n_cols":19,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[1,{"$f":"A1+1","v":2},{"$f":"B1+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19]
["Segment ID","Road Name","Length","Existing PSI"," \nRut Depth","Road Width","Treatment Type","Estimated Cost","Expected PSI \nwith Treatment","Expected PSI \nwithout Treatment",null,"ADT","ADTT","Identify Project","PSI","Cost after Treatment","ADT on Selected Segments","ADTT on Selected Segments"]
["222-1","Chalk Bluff Road/\"78\" Rd",6.1,0.3,0.3,25,"5-R",7320000,4.3,0,null,168,72,0,{"$f":"IF(N3=0, J3,I3)","v":0},{"$f":"IF(N3=0, 0,H3*O3*C3)","v":0},{"$f":"IF(P3=0, N3,L3)","v":0},{"$f":"IF(Q3=0, N3,M3)","v":0}]
[3,"Albin/LaGrange Rd",10.7,0.9,0.29499999999999998,25,"5-R",12840000,4.3,0.18939834756960572,null,108,22,0,{"$f":"IF(N4=0, J4,I4)","v":0.18939834756960572},0,{"$f":"IF(P4=0, N4,L4)","v":0},{"$f":"IF(Q4=0, N4,M4)","v":0}]
[6,"Black hills Rd",10.1,0.1,0.32200000000000001,22,"5-R",12120000,4.3,0,null,114,36,0,0,0,0,0]
["19-1","Old Highway Birns West",6.5,0.3,0.35899999999999999,22,"5-R",7800000,4.3,0,null,198,26,0,0,0,0,0]
[222,"Chalk Bluff Road/\"78\" Rd",5.5,1,0.29599999999999999,23,"5-R",6600000,4.3,0.40653451203200142,null,168,72,0,0.40653451203200142,0,0,0]
["21-2","Old Yellowstone Rd",2.7,0.2,0.31900000000000001,20,"5-R",3240000,4.3,0,null,36,6,0,0,0,0,0]
["21-1","Old Yellowstone Rd",1.9,0.9,0.24099999999999999,21,"5-R",2280000,4.3,0.18939834756960572,null,36,6,0,0.18939834756960572,0,0,0]
[21,"Old Yellowstone Rd",1.2,0,0.32800000000000001,21,"5-R",1440000,4.3,0,null,36,6,0,0,0,0,0]
[10,"Chalk Bluff Road/\"78\" Rd",7.7,1.4,0.377,24,"4-R",5005000,4.0999999999999996,1.1198883042140881,null,350,40,0,1.1198883042140881,0,0,0]
["18-1","Moffet Rd",4.5,1.3,0.308,23,"4-R",2925000,4.0999999999999996,0.96154259485674753,null,26,1,0,0.96154259485674753,0,0,0]
[15,"Hillslade Rd West",3.8,2.2000000000000002,0.157,24,"3-R",1330000,4,2.093865763518123,null,372,62,0,2.093865763518123,0,0,0]
["14-1","Hillslade N Rd/Midway",5.0999999999999996,2.8,0.27500000000000002,24,"3-R",1784999.9999999998,4,2.6812880610500063,null,372,62,0,2.6812880610500063,0,0,0]
[13,"Gillaspie Rd",4.8,2.8,0.27200000000000002,22,"3-R",1680000,4,2.6812880610500063,null,37,7,0,2.6812880610500063,0,0,0]
[18,"Moffet Rd",3.5,3.1,0.22800000000000001,23,"3-R",1225000,4,2.9790395728930039,null,26,1,0,2.9790395728930039,0,0,0]
[2,"A-118-1",2,3.2,0.27700000000000002,22,"3-R",700000,4,3.0812344568169525,null,34,7,0,3.0812344568169525,0,0,0]
[11,"Chalk Hill/Bliss Rd",2,3.2,0.26400000000000001,23,"3-R",700000,4,3.0812344568169525,null,34,7,0,3.0812344568169525,0,0,0]
[7,"Bristol Ridge/Hirsig Rd",1.6,2.9,0.20799999999999999,22,"3-R",560000,4,2.7792826313267511,null,31,1,0,2.7792826313267511,0,0,0]
[8,"Bruegman Rd",1.3,2.9,0.26,24,"3-R",455000,4,2.7792826313267511,null,24,4,0,2.7792826313267511,0,0,0]
[1,"CR 140-1",4.3,2.4,0.219,26,"1-R",258000,3.9,2.2931090715991549,null,328,40,0,2.2931090715991549,0,0,0]
[5,"Bear Creek/marsh Rd",2.7,2.1,0.26,26,"1-R",162000,3.9,1.9906593801839718,null,15,1,0,1.9906593801839718,0,0,0]
[9,"Carpenter Rd/Berger Rd",2.5,3.1,0.193,27,"GM",0,3.1,2.9790395728930039,null,518,243,0,2.9790395728930039,0,0,0]
[14,"Hillslade N Rd/Midway",8.1,3.5,0.216,26,"GM",0,3.5,3.3976602205524689,null,372,62,0,3.3976602205524689,0,0,0]
["21-3","Old Yellowstone Rd",4.9000000000000004,3.6,0.154,34,"GM",0,3.6,3.5059244591405361,null,36,6,0,3.5059244591405361,0,0,0]
["Average",null,null,{"$f":"SUMPRODUCT(C3:C25,D3:D25)/C27","v":1.7069565217391309},null,null,null,null,{"$f":"SUMPRODUCT(C3:C25,I3:I25)/C27","v":4.0547826086956515},{"$f":"SUMPRODUCT(C3:C25,J3:J25)/C27","v":1.4518667071181734},null,null,null,null,{"$f":"SUMPRODUCT(C3:C25,O3:O25)/C27","v":1.4518667071181734},null,{"$f":"SUMPRODUCT(C3:C25,Q3:Q25)/C27","v":0},{"$f":"SUMPRODUCT(C3:C25,R3:R25)/C27","v":0}]
["Total",null,{"$f":"SUM(C3:C25)","v":103.49999999999999},null,{"$f":"SUMPRODUCT(C3:C25,E3:E25)/C27","v":0.27717681159420299},null,null,{"$f":"SUM(H3:H25)","v":70425000},null,null,null,null,null,null,null,{"$f":"SUM(P3:P26)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O26/#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Program Data","index":2,"n_rows":27,"n_cols":20,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[1,{"$f":"A1+1","v":2},{"$f":"B1+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Segment ID","Road Name","Length","Existing PSI"," \nRut Depth","Road Width","Treatment Type","Estimated Cost","Estimated Risk","Expected PSI \nwith Treatment","Expected PSI \nwithout Treatment",null,"ADT","ADTT","Identify Project","PSI","Cost after Treatment","ADT on Selected Segments","ADTT on Selected Segments"]
["222-1","Chalk Bluff Road/\"78\" Rd",6.1,0.3,0.3,25,"5-R",7320000,0.05,4.3,0,null,168,72,0,{"$f":"IF(O3=0, K3,J3)","v":0},{"$f":"IF(O3=0, 0,H3*P3*C3)","v":0},{"$f":"IF(Q3=0, O3,M3)","v":0},{"$f":"IF(R3=0, O3,N3)","v":0}]
[3,"Albin/LaGrange Rd",10.7,0.9,0.29499999999999998,25,"5-R",12840000,0.05,4.3,0.18939834756960572,null,108,22,0,{"$f":"IF(O4=0, K4,J4)","v":0.18939834756960572},{"$f":"IF(O4=0, 0,H4*P4*C4)","v":0},{"$f":"IF(Q4=0, O4,M4)","v":0},{"$f":"IF(R4=0, O4,N4)","v":0}]
[6,"Black hills Rd",10.1,0.1,0.32200000000000001,22,"5-R",12120000,0.05,4.3,0,null,114,36,0,0,0,0,0]
["19-1","Old Highway Birns West",6.5,0.3,0.35899999999999999,22,"5-R",7800000,0.05,4.3,0,null,198,26,0,0,0,0,0]
[222,"Chalk Bluff Road/\"78\" Rd",5.5,1,0.29599999999999999,23,"5-R",6600000,0.05,4.3,0.40653451203200142,null,168,72,0,0.40653451203200142,0,0,0]
["21-2","Old Yellowstone Rd",2.7,0.2,0.31900000000000001,20,"5-R",3240000,0.05,4.3,0,null,36,6,0,0,0,0,0]
["21-1","Old Yellowstone Rd",1.9,0.9,0.24099999999999999,21,"5-R",2280000,0.05,4.3,0.18939834756960572,null,36,6,0,0.18939834756960572,0,0,0]
[21,"Old Yellowstone Rd",1.2,0,0.32800000000000001,21,"5-R",1440000,0.05,4.3,0,null,36,6,1,4.3,7430400,36,6]
[10,"Chalk Bluff Road/\"78\" Rd",7.7,1.4,0.377,24,"4-R",5005000,1,4.0999999999999996,1.1198883042140881,null,350,40,0,1.1198883042140881,0,0,0]
["18-1","Moffet Rd",4.5,1.3,0.308,23,"4-R",2925000,1,4.0999999999999996,0.96154259485674753,null,26,1,0,0.96154259485674753,0,0,0]
[15,"Hillslade Rd West",3.8,2.2000000000000002,0.157,24,"3-R",1330000,0.53800000000000003,4,2.093865763518123,null,372,62,0,2.093865763518123,0,0,0]
["14-1","Hillslade N Rd/Midway",5.0999999999999996,2.8,0.27500000000000002,24,"3-R",1784999.9999999998,0.53800000000000003,4,2.6812880610500063,null,372,62,0,2.6812880610500063,0,0,0]
[13,"Gillaspie Rd",4.8,2.8,0.27200000000000002,22,"3-R",1680000,0.53800000000000003,4,2.6812880610500063,null,37,7,0,2.6812880610500063,0,0,0]
[18,"Moffet Rd",3.5,3.1,0.22800000000000001,23,"3-R",1225000,0.53800000000000003,4,2.9790395728930039,null,26,1,0,2.9790395728930039,0,0,0]
[2,"A-118-1",2,3.2,0.27700000000000002,22,"3-R",700000,0.53800000000000003,4,3.0812344568169525,null,34,7,1,4,5600000,34,7]
[11,"Chalk Hill/Bliss Rd",2,3.2,0.26400000000000001,23,"3-R",700000,0.53800000000000003,4,3.0812344568169525,null,34,7,0,3.0812344568169525,0,0,0]
[7,"Bristol Ridge/Hirsig Rd",1.6,2.9,0.20799999999999999,22,"3-R",560000,0.53800000000000003,4,2.7792826313267511,null,31,1,0,2.7792826313267511,0,0,0]
[8,"Bruegman Rd",1.3,2.9,0.26,24,"3-R",455000,0.53800000000000003,4,2.7792826313267511,null,24,4,0,2.7792826313267511,0,0,0]
[1,"CR 140-1",4.3,2.4,0.219,26,"1-R",258000,9.1999999999999998E-2,3.9,2.2931090715991549,null,328,40,0,2.2931090715991549,0,0,0]
[5,"Bear Creek/marsh Rd",2.7,2.1,0.26,26,"1-R",162000,9.1999999999999998E-2,3.9,1.9906593801839718,null,15,1,1,3.9,1705860,15,1]
[9,"Carpenter Rd/Berger Rd",2.5,3.1,0.193,27,"GM",0,0.05,3.1,2.9790395728930039,null,518,243,0,2.9790395728930039,0,0,0]
[14,"Hillslade N Rd/Midway",8.1,3.5,0.216,26,"GM",0,0.05,3.5,3.3976602205524689,null,372,62,0,3.3976602205524689,0,0,0]
["21-3","Old Yellowstone Rd",4.9000000000000004,3.6,0.154,34,"GM",0,0.05,3.6,3.5059244591405361,null,36,6,0,3.5059244591405361,0,0,0]
["Average",null,null,{"$f":"SUMPRODUCT(C3:C25,D3:D25)/C27","v":1.7069565217391309},null,null,null,null,{"$f":"SUMPRODUCT(C3:C25,I3:I25)/C27","v":0.27845217391304361},{"$f":"SUMPRODUCT(C3:C25,J3:J25)/C27","v":4.0547826086956515},{"$f":"SUMPRODUCT(C3:C25,K3:K25)/C27","v":1.4518667071181734},null,null,null,null,{"$f":"SUMPRODUCT(C3:C25,P3:P25)/C27","v":1.5692845888560418},null,{"$f":"SUMPRODUCT(C3:C25,R3:R25)/C27","v":1.4657004830917875},{"$f":"SUMPRODUCT(C3:C25,S3:S25)/C27","v":0.23091787439613529}]
["Total",null,{"$f":"SUM(C3:C25)","v":103.49999999999999},null,{"$f":"SUMPRODUCT(C3:C25,E3:E25)/C27","v":0.27717681159420299},null,null,{"$f":"SUM(H3:H25)","v":70425000},null,null,null,null,null,null,null,null,{"$f":"SUM(Q3:Q26)","v":14736260}]