{"text_format":"2","workbook":"xlsx","n_sheets":23,"sheets":["Instructions","Project Information","AC Surface Pavements","AC Distress Id Manual","PCC Surface Pavements","PCC Distress Id Manual","EUAC and ROI","Treatment Ranking I","Cost Summary Sheet","Weights Assignment","Manual Assignment","Weighting Parameters 2","Weighting Parameters","Weighting Parameters 3","AHP Weights","AC Treatments Data","PCC Treatments Data","Scoring Sheet","Potential Actions","AC Summary Sheet","PCC Summary Sheet","AC Summary 1","PCC Summary 1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Project Information","index":1,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[4,7,4,8],[7,0,7,1],[0,0,1,8]]}
["Project Information "]
[]
["County/City",{"$nulls":6},"Date ",{"$f":"TODAY()","v":"2016-02-24"},{"$nulls":4},"AC"]
["Name",{"$nulls":6},"Estimated Letting date ",{"$nulls":5},"PCC"]
["Project Engineer ",{"$nulls":6},"Location Data ",{"$nulls":5},{"$f":"IF(B9=\"AC\",\"AC Surface Pavements\",IF(B9=\"PCC\",\"PCC Surface Pavements\"))","v":false}]
["Project Number ",{"$nulls":6},"Route"]
["Accounting ID ",{"$nulls":6},"Road Type "]
[{"$nulls":7},"Project Location From"]
["Pavement Surface Type",{"$nulls":6},"Project Location To"]
["Length (miles)"]
["Number of Lanes"]
["Number of Lane Miles",{"$f":"B10*B11","v":0}]
["Surface Area (Sq..)",{"$f":"5280*B12*12","v":0}]
["Total length of cracks (LF)"]
["Total length of joints (LF)*"]
["*Required for rigid pavements only"]

{"sheet":"AC Surface Pavements","index":2,"n_rows":103,"n_cols":86,"rows_kept":103,"cut":false,"hidden":false,"merged":[[22,0,23,4],[24,0,24,1],[71,10,80,10],[38,11,38,15],[41,11,41,15],[45,11,45,15],[47,11,47,15],[49,11,49,15],[51,11,51,15],[53,11,53,15],[54,11,54,15],[55,11,55,15],[64,11,64,15],[65,11,65,15],[56,11,56,15],[57,11,57,15],[85,11,85,15],[86,11,86,15],[87,11,87,15],[88,11,88,15],[69,11,69,15],[71,11,71,15],[72,11,72,15],[77,11,77,15],[81,11,81,15],[78,11,78,15],[79,11,79,15],[80,11,80,15],[84,11,84,15],[70,11,70,15],[82,11,82,15],[97,11,97,15],[89,11,89,15],[90,11,90,15],[91,11,91,15],[92,11,92,15],[93,11,93,15],[94,11,94,15],[95,11,95,15],[96,11,96,15],[20,68,25,68],[83,11,83,15],[28,11,28,15],[29,11,29,15],[32,11,32,15],[34,11,34,15],[36,11,36,15],[58,11,58,15],[20,38,25,38],[73,11,73,15],[74,11,74,15],[75,11,75,15],[76,11,76,15],[31,11,31,15],[39,11,39,15],[43,11,43,15],[44,10,57,10],[29,10,43,10],[66,11,66,15],[30,11,30,15],[33,11,33,15],[35,11,35,15],[37,11,37,15],[42,11,42,15],[48,11,48,15],[44,11,44,15],[40,11,40,15],[46,11,46,15],[52,11,52,15],[50,11,50,15],[67,11,67,15],[68,11,68,15],[59,11,59,15],[60,11,60,15],[61,11,61,15],[62,11,62,15],[63,11,63,15],[19,1,19,4],[21,1,21,4],[20,0,20,4],[19,10,19,23],[9,1,9,4],[12,8,12,9],[12,10,12,20],[12,0,12,4],[18,1,18,4],[15,9,18,9],[10,1,10,4],[3,9,6,9],[0,0,0,4],[6,1,6,4],[7,1,7,4],[8,0,8,4]]}
["Distress Data"]
[null,"Existence ","Severity Level","Extent Level","Class","Highest Class","Check Class Existance","Check Unity ","Potential Localized Treatment","Potential Globalized Treatment","Test 1 (3)","Test 2 (3)","Test 3 (2)","Test 4 (2)","Test 5 (2)","Test 6 (2)","Test 7 (1)","Test 8 (1)","Existance ","Severity Level","Extent Level","Roughness","Friction","Surface Age","Distress Distribution",null,"Number of treatments "]
["Longitudinal Cracking ",null,null,null,{"$f":"IF(B3=S3,MIN(K4:R4),\"-\")","v":"-"},{"$f":"IF(E3>$F$7,\"-\",E3)","v":"-"},{"$f":"IF(E3=\"-\",\"TRUE\")","v":"TRUE"},{"$f":"IF(AND(E3=$J$20,G3=FALSE),\"TRUE\")","v":{"$error":"#DIV/0!"}},{"$nulls":10},"Yes","Low ","Low ","Low","Poor","Old","Localized ",null,{"$f":"IF(B26<>\"-\",1,0)","v":0},null,null,null,{"$f":"IF(B3=$S$3,TRUE)","v":false}]
["Alligator Cracking",null,null,null,{"$f":"IF(B4=S3,1,\"-\")","v":"-"},{"$f":"IF(E4>$F$7,\"-\",E4)","v":"-"},{"$f":"IF(E4=\"-\",\"TRUE\")","v":"TRUE"},{"$f":"IF(AND(E4=$J$20,G4=FALSE),\"TRUE\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(E3=1,Instructions!#REF!,IF(E3=2,Instructions!#REF!,IF(E3=3,Instructions!#REF!,\"-\")))","v":"-"},{"$f":"IF(#REF!=1,\"CIR\",IF(#REF!=2,\"Crack fill/seal, chip seal or micro-surfacing\",IF(#REF!=3,\"Do nothing, Crack fill/seal, chip seal or micro-surfacing\")))","v":{"$error":"#REF!"}},{"$f":"IF(C3=T3,IF(D3=U3,3,IF(C3=T3,IF(D3=U4,3))))","v":false},{"$f":"IF(C3=T4,IF(D3=U3,3,IF(C3=T4,IF(D3=U4,3))))","v":false},{"$f":"IF(C3=T3,IF(D3=U5,2))","v":false},{"$f":"IF(C3=T4,IF(D3=U5,2))","v":false},null,null,{"$f":"IF(C3=U5,1)","v":false},null,"No","Moderate","Moderate","High","Good","New","Non-localized",null,{"$f":"IF(B27<>\"-\",2,0)","v":0},null,null,null,{"$f":"IF(B4=$S$3,TRUE)","v":false}]
["Transverse Cracking ",null,null,null,{"$f":"IF(B5=S3,MIN(K6:R6),\"-\")","v":"-"},"-",{"$f":"IF(E5=\"-\",\"TRUE\")","v":"TRUE"},{"$f":"IF(AND(E5=$J$20,G5=FALSE),\"TRUE\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(E4=1,Instructions!#REF!,\"-\")","v":"-"},{"$nulls":10},"High","High",{"$nulls":5},{"$f":"IF(B28<>\"-\",3,0)","v":0},null,null,null,false]
["Rutting",null,null,null,{"$f":"IF(B6=S3,MIN(K7:R7),\"-\")","v":"-"},"-",{"$f":"IF(E6=\"-\",\"TRUE\")","v":"TRUE"},{"$f":"IF(AND(E6=$J$20,G6=FALSE),\"TRUE\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(E5=1,Instructions!#REF!,IF(E5=2,Instructions!#REF!,\"-\"))","v":"-"},null,{"$f":"IF(C5=T3,IF(D5=U3,3,IF(C5=T3,IF(D5=U4,3))))","v":false},null,{"$f":"IF(C5=T5,IF(D5=U3,2,IF(C5=T5,IF(D5=U4,2))))","v":false},{"$f":"IF(C5=T4,IF(D5=U3,2,IF(C5=T4,IF(D5=U4,2))))","v":false},null,{"$f":"IF(C5=T3,IF(D5=U5,2))","v":false},{"$f":"IF(C5=T5,IF(D5=U5,1))","v":false},{"$f":"IF(C5=T4,IF(D5=U5,1))","v":false},{"$nulls":8},{"$f":"IF(B29<>\"-\",4,0)","v":0},null,null,null,false]
["Roughness ",{"$nulls":4},{"$f":"MIN(E3:E6)","v":0},null,null,{"$f":"IF(E6=1,Instructions!#REF!,IF(E6=3,Instructions!#REF!,\"-\"))","v":"-"},null,{"$f":"IF(C6=T3,IF(D6=U3,3,IF(D6=U4,3,IF(D6=U5,3))))","v":false},{"$nulls":5},{"$f":"IF(C6=T4,IF(D6=U3,1,IF(D6=U4,1,IF(D6=U5,1))))","v":false},{"$f":"IF(C6=T5,IF(D6=U3,1,IF(D6=U4,1,IF(D6=U5,1))))","v":false},{"$nulls":8},{"$f":"IF(B30<>\"-\",5,0)","v":0}]
["Friction",{"$nulls":24},"Number of Treatments",{"$f":"MAX(AA3:AA7)","v":0},{"$f":"IF(AA8=1,\"AC Summary 1\",IF(AA8>1,\"EUAC and ROI\"))","v":false}]
["Distress Distribution"]
["Surface Age"]
["Distress Distribution"]
[]
["Distress Data",{"$nulls":7},"Outputs",null,"Process"]
[null,"Existence ","Severity Level","Extent Level","Class",null,"Check Class Existence","Check Unity ","Potential Localized Treatment","Potential Globalized Treatment","Test 1 (3)","Test 2 (3)","Test 3 (2)","Test 4 (2)","Test 5 (2)","Test 6 (2)","Test 7 (1)","Test 8 (1)","Existence ","Severity Level","Extent Level","Roughness","Friction","Surface Age"]
["Longitudinal Cracking ",null,null,null,{"$f":"F3","v":"-"},null,{"$f":"IF(E15=\"-\",\"TRUE\")","v":"TRUE"},{"$f":"IF(AND(E15=$J$20,G15=FALSE),\"TRUE\")","v":{"$error":"#DIV/0!"}},{"$nulls":10},"Yes","Low ","Low ","Low","Poor","Old"]
["Alligator Cracking",null,null,null,{"$f":"F4","v":"-"},null,{"$f":"IF(E16=\"-\",\"TRUE\")","v":"TRUE"},{"$f":"IF(AND(E16=$J$20,G16=FALSE),\"TRUE\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(E15=1,Instructions!#REF!,IF(E15=2,Instructions!#REF!,IF(E15=3,Instructions!#REF!,\"-\")))","v":"-"},{"$f":"IF(#REF!=1,\"CIR\",IF(#REF!=2,\"Crack fill/seal, chip seal or micro-surfacing\",IF(#REF!=3,\"Do nothing, Crack fill/seal, chip seal or micro-surfacing\")))","v":{"$error":"#REF!"}},{"$f":"IF(C15=T15,IF(D15=U15,3,IF(C15=T15,IF(D15=U16,3))))","v":false},{"$f":"IF(C15=T16,IF(D15=U15,3,IF(C15=T16,IF(D15=U16,3))))","v":false},{"$f":"IF(C15=T15,IF(D15=U17,2))","v":false},{"$f":"IF(C15=T16,IF(D15=U17,2))","v":false},null,null,{"$f":"IF(C15=U17,1)","v":false},null,"No","Moderate","Moderate","High","Good","New"]
["Transverse Cracking ",null,null,null,{"$f":"F5","v":"-"},null,{"$f":"IF(E17=\"-\",\"TRUE\")","v":"TRUE"},{"$f":"IF(AND(E17=$J$20,G17=FALSE),\"TRUE\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(E16=1,Instructions!#REF!,\"-\")","v":"-"},{"$nulls":10},"High","High"]
["Rutting",null,null,null,{"$f":"F6","v":"-"},null,{"$f":"IF(E18=\"-\",\"TRUE\")","v":"TRUE"},{"$f":"IF(AND(E18=$J$20,G18=FALSE),\"TRUE\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(E17=1,Instructions!#REF!,IF(E17=2,Instructions!#REF!,\"-\"))","v":"-"},null,{"$f":"IF(C17=T15,IF(D17=U15,3,IF(C17=T15,IF(D17=U16,3))))","v":false},null,{"$f":"IF(C17=T17,IF(D17=U15,2,IF(C17=T17,IF(D17=U16,2))))","v":false},{"$f":"IF(C17=T16,IF(D17=U15,2,IF(C17=T16,IF(D17=U16,2))))","v":false},null,{"$f":"IF(C17=T15,IF(D17=U17,2))","v":false},{"$f":"IF(C17=T17,IF(D17=U17,1))","v":false},{"$f":"IF(C17=T16,IF(D17=U17,1))","v":false}]
["Roughness ",{"$f":"B7","v":0},{"$nulls":6},{"$f":"IF(E18=1,Instructions!#REF!,IF(E18=3,Instructions!#REF!,\"-\"))","v":"-"},null,{"$f":"IF(C18=T15,IF(D18=U15,3,IF(D18=U16,3,IF(D18=U17,3))))","v":false},{"$nulls":5},{"$f":"IF(C18=T16,IF(D18=U15,1,IF(D18=U16,1,IF(D18=U17,1))))","v":false},{"$f":"IF(C18=T17,IF(D18=U15,1,IF(D18=U16,1,IF(D18=U17,1))))","v":false}]
["Friction",{"$f":"B8","v":0},{"$nulls":6},"Average Classes (Check Class Unity)",{"$f":"AVERAGE(E15:E18)","v":{"$error":"#DIV/0!"}},"Treatment Matching (Class 1)"]
["Pavement Age",{"$nulls":10},"Case 1","Case L-L","Case L-L","Case L","Case T","Case T","Case L, T","Case L, T","Case I-A","Case I-A","Case I-R","Case L+R","Case L+R","Case L+A","Case L+A","Case T+A","Case T+A","Case T+R","Case T+R","Case A+L+T","Case A+L+T","Case All","Case All","Case L+T+R","Case L+T+R","Case A+T+R","Case L+T+R","II","Case 1","Case 2","Case 3a","Case 3b","Case 4","Case 5","Case 6a","Case 6b","Case 7","Case 8","Case 9","Case 10","Case 11","Case 12","Case 13a","Case 13b","Case 14","Case 15","Case 17","Case 18","Case 18","Case 19","Case 20","Case 21","Case 21","Case 22","Case 23","Case 24","Case 25","III","Case 1","Case 2","Case 3","Case 4","Case 5","Case 6","Case 7","Case 8","Case 9","Case 10","Case 11","Case 12","Case 13","Case 14","Case 15","Case 16","Case 17"]
["Surface Age",{"$f":"B10","v":0},{"$nulls":8},"Longitudinal Cracking ",{"$f":"$E$15","v":"-"},{"$f":"$E$15","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,{"$f":"$E$15","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,{"$f":"$E$15","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[{"$f":"IFERROR(IF(OR(G15=H15,G16=H16,G17=H17,G18=H18),\"Warning: you are trying to handle different distress classes at the same time. Please read the instructions again!\",\"\"),\"-\")","v":"-"},{"$nulls":9},"Alligator Cracking",{"$f":"$E$16","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,{"$f":"$E$16","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,{"$f":"$E$16","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[{"$nulls":10},"Transverse Cracking ",{"$f":"$E$17","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,{"$f":"$E$17","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,{"$f":"$E$17","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["Potential Action(s)",{"$nulls":9},"Rutting",{"$f":"$E$18","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,{"$f":"$E$18","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,{"$f":"$E$18","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["Action #1 ",{"$f":"M99","v":"-"},{"$nulls":8},"Case Existence",{"$f":"IF(AND(L23=1,L25=1,L22=\"-\",L24=\"-\"),\"True\")","v":false},{"$f":"IF(AND(M22=1,M23=\"-\",M24=\"-\",M25=\"-\",,B11=Y4),\"True\")","v":false},{"$f":"IF(AND(N22=1,N23=\"-\",N24=\"-\",N25=\"-\",B11=Y3),\"True\")","v":false},{"$f":"IF(AND(O22=1,O23=\"-\",O24=\"-\",O25=\"-\",D3<>\"Low \"),\"True\")","v":false},{"$f":"IF(AND(P22=\"-\",P23=\"-\",P24=1,P25=\"-\",B11=Y4),\"True\")","v":false},{"$f":"IF(AND(Q22=\"-\",Q23=\"-\",Q24=1,Q25=\"-\",B11=Y3),\"True\")","v":false},{"$f":"IF(AND(R22=1,R23=\"-\",R24=1,R25=\"-\",B11=Y3),\"True\")","v":false},{"$f":"IF(AND(S22=1,S23=\"-\",S24=1,S25=\"-\",B11=Y4),\"True\")","v":false},{"$f":"IF(AND(T22=\"-\",T23=1,T24=\"-\",T25=\"-\",B11=Y3),\"TRUE\")","v":false},{"$f":"IF(AND(U22=\"-\",U23=1,U24=\"-\",U25=\"-\",B11=Y4),\"TRUE\")","v":false},{"$f":"IF(AND(V22=\"-\",V23=\"-\",V24=\"-\",V25=1),\"TRUE\")","v":false},{"$f":"IF(AND(W22=1,W25=1,W23=\"-\",W24=\"-\",B11=Y4),\"TRUE\")","v":false},{"$f":"IF(AND(X22=1,X25=1,X23=\"-\",X24=\"-\",B11=Y3),\"TRUE\")","v":false},{"$f":"IF(AND(Y22=1,Y23=1,Y24=\"-\",Y25=\"-\",B11=Y3),\"TRUE\")","v":false},{"$f":"IF(AND(Z22=1,Z23=1,Z24=\"-\",Z25=\"-\",B11=Y4),\"TRUE\")","v":false},{"$f":"IF(AND(AA22=\"-\",AA23=1,AA24=1,AA25=\"-\",B11=Y3),\"TRUE\")","v":false},{"$f":"IF(AND(AB22=\"-\",AB23=1,AB24=1,AB25=\"-\",B11=Y4),\"TRUE\")","v":false},{"$f":"IF(AND(AC22=\"-\",AC25=1,AC23=\"-\",AC24=1,B11=Y4),\"TRUE\")","v":false},{"$f":"IF(AND(AD22=\"-\",AD25=1,AD23=\"-\",AD24=1,B11=Y3),\"TRUE\")","v":false},{"$f":"IF(AND(AE22=1,AE23=1,AE24=1,AE25=\"-\",B11=Y3),\"TRUE\")","v":false},{"$f":"IF(AND(AF22=1,AF23=1,AF24=1,AF25=\"-\",B11=Y4),\"TRUE\")","v":false},{"$f":"IF(AND(AG22=1,AG23=1,AG24=1,AG25=1,B11=Y4),\"TRUE\")","v":false},{"$f":"IF(AND(AH22=1,AH23=1,AH24=1,AH25=1,B11=Y3),\"TRUE\")","v":false},{"$f":"IF(AND(AI22=1,AI23=\"-\",AI24=1,AI25=1,B11=Y4),\"TRUE\")","v":false},{"$f":"IF(AND(AJ22=1,AJ23=\"-\",AJ24=1,AJ25=1,B11=Y3),\"TRUE\")","v":false},{"$f":"IF(AND(AK22=\"-\",AK23=1,AK24=1,AK25=1),\"TRUE\")","v":false},{"$f":"IF(AND(AL22=1,AL23=1,AL24=\"-\",AL25=1),\"TRUE\")","v":false},null,{"$f":"IF(AND(AN22=2,AN24=\"-\"),IF(B19=\"Low\",IF(B20=\"Good\",\"True\")))","v":false},{"$f":"IF(AND(AO22=2,AO24=\"-\"),IF(B19=\"Low\",IF(B20=\"Good\",\"True\")))","v":false},{"$f":"IF(AND(AP22=2,AP24=\"-\"),IF(B19=\"Low\",IF(B20=\"Poor\",\"True\")))","v":false},{"$f":"IF(AND(AQ22=2,AQ24=\"-\"),IF(B19=\"Low\",IF(B20=\"Poor\",\"True\")))","v":false},{"$f":"IF(AND(AR24=2,AR22=\"-\",B17=\"Yes\",C17=\"High\"),IF(B19=\"Low\",IF(B20=\"Good\",\"True\")))","v":false},{"$f":"IF(AND(AS24=2,AS22=\"-\",B17=\"Yes\",C17=\"High\"),IF(B19=\"Low\",IF(B20=\"Good\",\"True\")))","v":false},{"$f":"IF(AND(AT24=2,AT22=\"-\",B17=\"Yes\",C17=\"High\"),IF(B19=\"Low\",IF(B20=\"Poor\",\"True\")))","v":false},{"$f":"IF(AND(AU24=2,AU22=\"-\",B17=\"Yes\",C17=\"High\"),IF(B19=\"Low\",IF(B20=\"Poor\",\"True\")))","v":false},{"$f":"IF(AND(AV24=2,AV22=\"-\",B17=\"Yes\",C17<>\"High\"),IF(B19=\"Low\",IF(B20=\"Good\",\"True\")))","v":false},{"$f":"IF(AND(AW24=2,AW22=\"-\",B17=\"Yes\",C17<>\"High\"),IF(B19=\"Low\",\"True\"))","v":false},{"$f":"IF(AND(AX24=2,AX22=\"-\",B17=\"Yes\",C17<>\"High\"),IF(B19=\"Low\",IF(B20=\"Poor\",\"True\")))","v":false},{"$f":"IF(AND(AY24=2,AY22=2,D17=\"High\",D15=\"High\"),\"True\")","v":false},{"$f":"IF(AND(AZ22=2,AZ24=2,D17<>\"High\"),IF(B19=\"Low\",IF(B20=\"Good\",\"TRUE\")))","v":false},{"$f":"IF(AND(BA22=2,BA24=2,D17<>\"High\"),IF(B19=\"Low\",IF(B20=\"Good\",\"TRUE\")))","v":false},{"$f":"IF(AND(BB22=2,BB24=2,D17<>\"High\"),IF(B19=\"Low\",IF(B20=\"Poor\",\"TRUE\")))","v":false},{"$f":"IF(AND(BB22=2,BB24=2,D17<>\"High\"),IF(B19=\"Low\",IF(B20=\"Poor\",\"TRUE\")))","v":false},{"$f":"IF(AND(BD22=2,BD24=2),IF(B19=\"High\",\"TRUE\"))","v":false},{"$f":"IF(AND(BE22=2,BE24=\"-\"),IF(B19=\"High\",\"TRUE\"))","v":false},{"$f":"IF(AND($BF$22=\"-\",$BF$23=\"-\",$BF$24=2,$BF$25=\"-\",$C$5=\"Moderate\",$B$7=\"Low\",),\"TRUE\")","v":false},{"$f":"IF(AND($BG$22=\"-\",$BG$23=\"-\",$BG$24=2,$BG$25=\"-\",$C$5=\"Moderate\",$B$7=\"High\"),\"TRUE\")","v":false},{"$f":"IF(AND($BH$22=\"-\",$BH$23=\"-\",$BH$24=2,$BH$25=\"-\",$C$5=\"Low \",$B$7=\"High\"),\"TRUE\")","v":false},{"$f":"IF(AND($BI$22=\"-\",$BI$23=\"-\",$BI$24=2,$BI$25=\"-\",$C$5=\"Low \",$B$7=\"Low\",$B$8=\"Good\"),\"TRUE\")","v":false},{"$f":"IF(AND($BJ$22=\"-\",$BJ$23=\"-\",$BJ$24=2,$BJ$25=\"-\",$C$5=\"Moderate\",$B$7=\"Low\",$B$8=\"Good\"),\"TRUE\")","v":false},{"$f":"IF(AND($BK$22=\"-\",$BK$23=\"-\",$BK$24=2,$BK$25=\"-\",$C$5=\"Moderate\",$B$7=\"Low\",$B$8=\"Poor\"),\"TRUE\")","v":false},{"$f":"IF(AND($BL$22=\"-\",$BL$23=\"-\",$BL$24=2,$BL$25=\"-\",$C$5=\"Low \",$B$7=\"Low\",$B$8=\"Poor\"),\"TRUE\")","v":false},{"$f":"IF(AND($BM$22=\"-\",$BM$23=\"-\",$BM$24=2,$BM$25=\"-\",$C$5=\"High\",$B$7=\"Low\",$B$8=\"Good\"),\"TRUE\")","v":false},{"$f":"IF(AND($BN$22=\"-\",$BN$23=\"-\",$BN$24=2,$BN$25=\"-\",$C$5=\"High\",$B$7=\"Low\",$B$8=\"Poor\"),\"TRUE\")","v":false},{"$f":"IF(AND($BO$22=\"-\",$BO$23=\"-\",$BO$24=2,$BO$25=\"-\",$C$5=\"High\",$B$7=\"Low\"),\"TRUE\")","v":false},{"$f":"IF(AND($BP$22=\"-\",$BP$23=\"-\",$BP$24=2,$BP$25=\"-\",$C$5=\"High\",$B$7=\"High\"),\"TRUE\")","v":false},null,{"$f":"IF(AND(BR22=3,BR24=3,BR25=\"-\"),IF(B19=\"Low\",IF(B20=\"Good\",\"TRUE\")))","v":false},{"$f":"IF(AND(BS22=3,BS24=3,BS25=\"-\"),IF(B19=\"Low\",IF(B20=\"Good\",\"TRUE\")))","v":false},{"$f":"IF(AND(BT22=3,BT24=3,BT25=\"-\"),IF(B19=\"Low\",IF(B20=\"Poor\",\"TRUE\")))","v":false},{"$f":"IF(AND(BU22=3,BU24=3,BU25=\"-\"),IF(B19=\"High\",\"TRUE\"))","v":false},{"$f":"IF(AND(BV25=3,BV24=3,BV22=3),\"TRUE\")","v":false},{"$f":"IF(AND(BW25=3,BW24=\"-\",BW22=\"-\"),\"TRUE\")","v":false},{"$f":"IF(AND(BX25=\"-\",BX22=3,BX23=\"-\",BX24=\"-\"),IF(B19=\"High\",\"TRUE\"))","v":false},{"$f":"IF(AND(BY25=\"-\",BY22=3),IF(B19=\"Low\",\"TRUE\"))","v":false},{"$f":"IF(AND(BZ25=\"-\",BZ22=3),IF(B19=\"Low\",IF(B20=\"Poor\",\"TRUE\")))","v":false},{"$f":"IF(AND(CA25=\"-\",CA22=3),IF(B19=\"Low\",IF(B20=\"Good\",\"TRUE\")))","v":false},{"$f":"IF(AND(CB25=\"-\",CB24=3,CB23=\"-\",CB22=\"-\"),IF(B19=\"High\",\"TRUE\"))","v":false},{"$f":"IF(AND(CC25=\"-\",CC24=3),IF(B19=\"Low\",\"TRUE\"))","v":false},{"$f":"IF(AND(CD25=\"-\",CD24=3),IF(B19=\"Low\",IF(B20=\"Poor\",\"TRUE\")))","v":false},{"$f":"IF(AND(CE25=\"-\",CE24=3),IF(B19=\"Low\",IF(B20=\"Good\",\"TRUE\")))","v":false},{"$f":"IF(AND(CF25=3,CF24=\"-\",CF22=3),\"TRUE\")","v":false},{"$f":"IF(AND(CG25=3,CG24=3,CG22=\"-\"),\"TRUE\")","v":false}]
["Action #2",{"$f":"M100","v":"-"}]
["Action #3",{"$f":"M101","v":"-"}]
["Action #4","-",{"$nulls":9},"Potential Global Treatment ",{"$nulls":4},"Number"]
["Action #5","-",{"$nulls":8},"I",{"$f":"IF(L26=\"True\", \"Thick HMA overlay, Milling with overlay,\")","v":false},{"$nulls":4},{"$f":"IF(L30=FALSE,0,1)","v":0},{"$f":"L30","v":false}]
["Number of Treatments",{"$nulls":10},{"$f":"IF(N26=\"True\",\"Patching,\")","v":false},{"$nulls":4},{"$f":"IF(L31=FALSE,0,1)","v":0},{"$f":"L31","v":false}]
[{"$nulls":11},{"$f":"IF(M26=\"True\",\"Whitetopping, CIR, Milling with overlay,\")","v":false},{"$nulls":4},{"$f":"IF(L32=FALSE,0,1)","v":0},{"$f":"L32","v":false}]
[{"$nulls":11},{"$f":"IF(O26=\"True\",\"Whitetopping, CIR, Milling with overlay, Reconstruction,\")","v":false},{"$nulls":4},{"$f":"IF(L33=FALSE,0,1)","v":0},{"$f":"L33","v":false}]
[{"$nulls":11},{"$f":"IF(Q26=\"True\",\"Patching,\")","v":false},{"$nulls":4},{"$f":"IF(L34=FALSE,0,1)","v":0},{"$f":"L34","v":false}]
[{"$nulls":11},{"$f":"IF(P26=\"True\",\"Whitetopping, CIR, Reconstruction,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(R26=\"True\",\"Patching,\")","v":false},{"$nulls":4},{"$f":"IF(L36=FALSE,0,1)","v":0},{"$f":"L36","v":false}]
[{"$nulls":11},{"$f":"IF(S26=\"True\",\"Whitetopping, CIR, Reconstruction,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(T26=\"True\",\"Patching,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(U26=\"True\",\"Thick HMA overlay, Reconstruction,\")","v":false},{"$nulls":4},{"$f":"IF(L39=FALSE,0,1)","v":0},{"$f":"L39","v":false}]
[{"$nulls":11},{"$f":"IF(W26=\"True\",\"Whitetopping, CIR, Milling with overlay, Reconstruction,\")","v":false},{"$nulls":4},{"$f":"IF(L40=FALSE,0,1)","v":0},{"$f":"L40","v":false}]
[{"$nulls":11},{"$f":"IF(X26=\"True\",\"Patching,\")","v":false},{"$nulls":4},{"$f":"IF(L41=FALSE,0,1)","v":0},{"$f":"L41","v":false}]
[{"$nulls":11},{"$f":"IF(V26=\"True\",\"Thick HMA overlay, Milling, Milling with overlay, CIR, Reconstruction,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(Y26=\"True\",\"Patching,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(Z26=\"True\",\"Milling with overlay, Reconstruction,\")","v":false},{"$nulls":4},{"$f":"IF(L44=FALSE,0,1)","v":0},{"$f":"L44","v":false}]
[{"$nulls":10},"II",{"$f":"IF(AA26=\"True\",\"Patching,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(AB26=\"True\",\"Milling with overlay, Reconstruction,\")","v":false},{"$nulls":4},{"$f":"IF(L46=FALSE,0,1)","v":0},{"$f":"L46","v":false}]
[{"$nulls":11},{"$f":"IF(AD26=\"True\",\"Patching,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(AC26=\"True\",\"CIR, Whitetopping, Milling with overlay, Reconstruction,\")","v":false},{"$nulls":4},{"$f":"IF(L48=FALSE,0,1)","v":0},{"$f":"L48","v":false}]
[{"$nulls":11},{"$f":"IF(AE26=\"True\",\"Patching,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(AF26=\"True\",\"Milling with overlay, Reconstruction,\")","v":false},{"$nulls":4},{"$f":"IF(L50=FALSE,0,1)","v":0},{"$f":"L50","v":false}]
[{"$nulls":11},{"$f":"IF(AH26=\"True\",\"Patching,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(AG26=\"True\",\"Milling with overlay, Reconstruction,\")","v":false},{"$nulls":4},{"$f":"IF(L52=FALSE,0,1)","v":0},{"$f":"L52","v":false}]
[{"$nulls":11},{"$f":"IF(AJ26=\"True\",\"Patching,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(AI26=\"True\",\"Milling with overlay, CIR, Whitetopping, Reconstruction,\")","v":false},{"$nulls":4},{"$f":"IF(L54=FALSE,0,1)","v":0},{"$f":"L54","v":false}]
[{"$nulls":11},{"$f":"IF(AK26=\"True\",\"Milling with overlay,\")","v":false},{"$nulls":4},{"$f":"IF(L55=FALSE,0,1)","v":0},{"$f":"L55","v":false}]
[{"$nulls":11},{"$f":"IF(AL26=\"True\",\"Milling with overlay, Reconstruction,\")","v":false},{"$nulls":4},{"$f":"IF(L56=FALSE,0,1)","v":0},{"$f":"L56","v":false}]
[{"$nulls":11},{"$f":"IF(AN26=\"True\",\"Crack fill, Crack seal,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(AO26=\"True\",\"Mircosurfacing, Chip seal, Thin HMA overlay,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(OR(AP26=\"True\",AQ26=\"True\"),\"Microsurfacing, Chip seal, Thin HMA overlay,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(AR26=\"True\",\"Crack fill, Crack seal,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(AS26=\"True\",\"Mircosurfacing, Chip seal,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(OR(AT26=\"True\",AU26=\"True\"),\"Microsurfacing, Chip seal,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(AV26=\"True\",\"Crack fill, Crack seal,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(AW26=\"True\",\"Sand seal, Slurry seal, Microsurfacing, Chip seal,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(AX26=\"True\",\"Sand seal, Slurry seal, Microsurfacing, Chip seal,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(AY26=\"True\",\"Microsurfacing, chip seal,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(AZ26=\"True\",\"Crack fill, Crack seal,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(BA26=\"True\",\"Microsurfacing, Chip seal, Thin HMA overlay,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(BB26=\"True\",\"Microsurfacing, Chip seal, Thin HMA overlay,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(BC26=\"True\",\"Microsurfacing, Chip seal, Thin HMA overlay,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(BD26=\"True\",\"Microsurfacing, Chip seal, Thin HMA overlay,\")","v":false},{"$nulls":4},{"$f":"IF(L71=FALSE,0,1)","v":0},{"$f":"L71","v":false}]
[{"$nulls":10},"III",{"$f":"IF(BF26=\"True\",\"Sand seal, Slurry seal, Microsurfacing, Chip seal, Thin HMA overlay,\")","v":false},{"$nulls":4},{"$f":"IF(L72=FALSE,0,1)","v":0},{"$f":"L72","v":false}]
[{"$nulls":11},{"$f":"IF(BG26=\"True\",\"Sand seal, Slurry seal, Microsurfacing, Chip seal, Thin HMA overlay,\")","v":false},{"$nulls":4},{"$f":"IF(L73=FALSE,0,1)","v":0},{"$f":"L73","v":false}]
[{"$nulls":11},{"$f":"IF(BH26=\"True\",\"Sand seal, Slurry seal, Microsurfacing, Chip seal, Thin HMA overlay,\")","v":false},{"$nulls":4},{"$f":"IF(L74=FALSE,0,1)","v":0},{"$f":"L74","v":false}]
[{"$nulls":11},{"$f":"IF(BI26=\"True\",\"Crack fill, Crack seal,\")","v":false},{"$nulls":4},{"$f":"IF(L75=FALSE,0,1)","v":0},{"$f":"L75","v":false}]
[{"$nulls":11},{"$f":"IF(BJ26=\"True\",\"Crack fill, Crack seal,\")","v":false},{"$nulls":4},{"$f":"IF(L76=FALSE,0,1)","v":0},{"$f":"L76","v":false}]
[{"$nulls":11},{"$f":"IF(BK26=\"True\",\"Sand seal, Slurry seal, Microsurfacing, Chip seal, Thin HMA overlay,\")","v":false},{"$nulls":4},{"$f":"IF(L77=FALSE,0,1)","v":0},{"$f":"L77","v":false}]
[{"$nulls":11},{"$f":"IF(BL26=\"True\",\"Sand seal, Slurry seal, Microsurfacing, Chip seal, Thin HMA overlay,\")","v":false},{"$nulls":4},{"$f":"IF(L78=FALSE,0,1)","v":0},{"$f":"L78","v":false}]
[{"$nulls":11},{"$f":"IF(BM26=\"True\",\"Crack fill, Crack seal,\")","v":false},{"$nulls":4},{"$f":"IF(L79=FALSE,0,1)","v":0},{"$f":"L79","v":false}]
[{"$nulls":11},{"$f":"IF(BN26=\"True\",\"Microsurfacing, Chip seal, Thin HMA overlay,\")","v":false},{"$nulls":4},{"$f":"IF(L80=FALSE,0,1)","v":0},{"$f":"L80","v":false}]
[{"$nulls":11},{"$f":"IF(BO26=\"True\",\"Microsurfacing, Chip seal, Thin HMA overlay,\")","v":false},{"$nulls":4},{"$f":"IF(L81=FALSE,0,1)","v":0},{"$f":"L81","v":false}]
[{"$nulls":11},{"$f":"IF(BP26=\"True\",\"Microsurfacing, Chip seal, Thin HMA overlay,\")","v":false},{"$nulls":4},{"$f":"IF(L82=FALSE,0,1)","v":0},{"$f":"L82","v":false}]
[{"$nulls":11},{"$f":"IF(BE26=\"True\",\"Microsurfacing, Chip seal, Thin HMA overlay,\")","v":false},{"$nulls":4},{"$f":"IF(L83=FALSE,0,1)","v":0},{"$f":"L83","v":false}]
[{"$nulls":11},{"$f":"IF(BR26=\"True\",\"Crack fill, Crack seal, Do Nothing,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(BS26=\"True\",\"Microsurfacing, Chip seal,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(BT26=\"True\",\"Microsurfacing, Chip seal,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(BU26=\"True\",\"Microsurfacing, Chip seal,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":10},"Potential Treatment",{"$f":"IF(BV26=\"True\",\"Microsurfacing, Chip seal, Milling + Chip seal, Do nothing,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":10},{"$f":"FIND(\",\",L98,1)","v":{"$error":"#N/A"}},{"$f":"IF(BW26=\"True\",\"Milling, Microsurfacing, Chip seal, Milling + Chip seal, Do nothing,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":10},{"$f":"FIND(\",\",$L$98,K89+1)","v":{"$error":"#N/A"}},{"$f":"IF(BX26=\"True\",\"Microsurfacing, Chip seal,\")","v":false},{"$nulls":4},{"$f":"IF(L90=FALSE,0,1)","v":0},{"$f":"L90","v":false}]
[{"$nulls":10},{"$f":"FIND(\",\",$L$98,K90+1)","v":{"$error":"#N/A"}},{"$f":"IF(BZ26=\"True\",\"Microsurfacing, Chip seal,\")","v":false},{"$nulls":4},{"$f":"IF(L91=FALSE,0,1)","v":0},{"$f":"L91","v":false}]
[{"$nulls":10},{"$f":"FIND(\",\",$L$98,K91+1)","v":{"$error":"#N/A"}},{"$f":"IF(CA26=\"True\",\"Crack fill, Crack seal, Do Nothing,\")","v":false},{"$nulls":4},{"$f":"IF(L92=FALSE,0,1)","v":0},{"$f":"L92","v":false}]
[{"$nulls":10},{"$f":"FIND(\",\",$L$98,K92+1)","v":{"$error":"#N/A"}},{"$f":"IF(CB26=\"True\",\"Microsurfacing, Chip seal,\")","v":false},{"$nulls":4},{"$f":"IF(L93=FALSE,0,1)","v":0},{"$f":"L93","v":false}]
[{"$nulls":11},{"$f":"IF(CD26=\"True\",\"Microsurfacing, Chip seal,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(CE26=\"True\",\"Crack fill, Crack seal, Do Nothing,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(CF26=\"True\",\"Chip seal, Microsurfacing, Milling + Chip seal, Do Nothing,\")","v":false},{"$nulls":4},{"$f":"IF(L96=FALSE,0,1)","v":0},{"$f":"L96","v":false}]
[{"$nulls":11},{"$f":"IF(CG26=\"True\",\"Chip seal, Micorsurfacing, Milling + Chip seal, Do Nothing,\")","v":false},{"$nulls":4},{"$f":"IF(L97=FALSE,0,1)","v":0},{"$f":"L97","v":false}]
[{"$nulls":11},{"$f":"VLOOKUP(1,Q30:R97,2,FALSE)","v":{"$error":"#N/A"}}]
[{"$nulls":11},{"$f":"LEFT(L98,K89-1)","v":{"$error":"#N/A"}},{"$f":"IFERROR(L99,\"-\")","v":"-"}]
[{"$nulls":11},{"$f":"MID($L$98,K89+2,K90-K89-2)","v":{"$error":"#N/A"}},{"$f":"IFERROR(L100,\"-\")","v":"-"}]
[{"$nulls":11},{"$f":"MID($L$98,K90+2,K91-K90-2)","v":{"$error":"#N/A"}},"-"]
[{"$nulls":11},{"$f":"MID($L$98,K91+2,K92-K91-2)","v":{"$error":"#N/A"}},"-"]
[{"$nulls":11},{"$f":"MID($L$98,K92+2,K93-K92-2)","v":{"$error":"#N/A"}},"-"]

{"sheet":"AC Distress Id Manual","index":3,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,0,3,0],[4,0,6,0],[7,0,9,0],[10,0,12,0]]}
["Distress ","Severity level","Severity level threshold values","Extent level","Extent level threshold values"]
["Alligator cracking","Low ","Few connecting cracks ","Low ","1-9% of the wheel path affected"]
[null,"Moderate","Interconnected cracks forming pattern","Moderate ","10-24% of the wheel path affected"]
[null,"High","Severely interconnected cracks","High","More than 25% of the wheel path affected"]
["Longitudinal cracking","Low ","Mean width < 6 mm (0.25 in)","Low ","Less than 500 m/km (2640 ft/mile)"]
[null,"Moderate","6 mm (0.25 in) ≤ Mean width < 19 mm (0.75 in)","Moderate ","From 500 m/km to 999 m/km (5279 ft/mile)"]
[null,"High","Mean width ≥ 19 mm (0.75 in)","High","Greater than or equal 1000 m/km (5280 ft/mile)"]
["Transverse Cracking","Low ","Mean width < 6 mm (0.25 in)","Low ","Less than 150 m/km (792 ft/mile)"]
[null,"Moderate","6 mm (0.25 in) ≤ Mean width < 19 mm (0.75 in)","Moderate","From 150 m/km (792 ft/mile) to 300 m/km (1584 ft/mile)"]
[null,"High","Mean width ≥ 19 mm (0.75 in)","High","Greater than or equal 300 m/km (1584 ft/mile)"]
["Rutting","Low ","Mean depth < 7 mm (0.27 in)","Low ","1-9% of the wheel path affected"]
[null,"Moderate","7 mm (0.27 in) ≤ mean depth < 12 mm (0.5 in)","Moderate","10-24% of the wheel path affected"]
[null,"High","Mean depth ≥ 12 mm (0.5 in)","High","More than 25% of the wheel path affected"]

{"sheet":"PCC Surface Pavements","index":4,"n_rows":122,"n_cols":99,"rows_kept":122,"cut":false,"hidden":false,"merged":[[107,11,107,15],[109,11,109,15],[110,11,110,15],[111,11,111,15],[112,11,112,15],[22,81,28,81],[83,11,83,15],[55,11,55,15],[39,11,39,15],[49,11,49,15],[51,11,51,15],[52,11,52,15],[56,11,56,15],[80,11,80,15],[81,11,81,15],[42,11,42,15],[50,11,50,15],[40,11,40,15],[46,11,46,15],[31,11,31,15],[44,11,44,15],[32,11,32,15],[96,11,96,15],[95,11,95,15],[113,11,113,15],[108,11,108,15],[53,11,53,15],[54,11,54,15],[59,11,59,15],[57,11,57,15],[64,11,64,15],[61,11,61,15],[22,35,28,35],[76,11,76,15],[66,11,66,15],[68,11,68,15],[74,11,74,15],[43,11,43,15],[45,11,45,15],[48,11,48,15],[47,11,47,15],[72,11,72,15],[70,11,70,15],[71,11,71,15],[73,11,73,15],[75,11,75,15],[86,11,86,15],[84,11,84,15],[0,0,0,4],[7,1,7,4],[8,1,8,4],[9,0,9,4],[10,1,10,4],[116,11,116,15],[30,0,30,1],[102,11,102,15],[103,11,103,15],[105,11,105,15],[106,11,106,15],[91,11,91,15],[92,11,92,15],[93,11,93,15],[94,11,94,15],[58,11,58,15],[60,11,60,15],[62,11,62,15],[63,11,63,15],[65,11,65,15],[67,11,67,15],[114,11,114,15],[69,11,69,15],[101,11,101,15],[11,0,11,4],[12,1,12,4],[15,0,15,4],[22,1,22,4],[41,11,41,15],[26,0,26,4],[27,1,27,4],[28,0,29,4],[30,11,30,15],[36,11,36,15],[35,11,35,15],[34,11,34,15],[33,11,33,15],[13,1,13,4],[24,0,24,4],[25,1,25,4],[31,2,33,4],[31,10,40,10],[23,1,23,4],[34,2,35,4],[38,11,38,15],[37,11,37,15],[104,11,104,15],[98,11,98,15],[79,11,79,15],[78,11,78,15],[77,11,77,15],[88,11,88,15],[89,11,89,15],[90,11,90,15],[100,11,100,15],[97,11,97,15],[99,11,99,15],[85,11,85,15],[87,11,87,15],[82,11,82,15]]}
["Distress Data"]
[null,"Existence ","Severity Level","Extent Level","Class","Highest Class","Check Class Existence","Check Unity ","Test I","Test II","Test III","Number of treatments ",{"$nulls":6},"Existence ","Severity Level","Extent Level","Roughness","Friction","Surface Age","Joint Related","Distress Distribution"]
["Longitudinal Cracking ",null,null,null,{"$f":"IF(B3=$S$18,MIN(I3:K3),\"-\")","v":"-"},{"$f":"IF(E3>$F$8,\"-\",E3)","v":"-"},{"$f":"IF(E3=\"-\",\"TRUE\")","v":"TRUE"},{"$f":"IF(AND(E3=$J$23,G3=FALSE),\"TRUE\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C3=\"High\",D3=\"High\"),1,IF(AND(C3=\"High\",D3=\"Moderate\"),1,IF(AND(C3=\"Moderate\",D3=\"High\"),1,IF(AND(C3=\"Moderate\",D3=\"Moderate\"),1))))","v":false},{"$f":"IF(AND(C3=\"Low \",D3=\"High\"),2,IF(AND(C3=\"High\",D3=\"Low \"),2,IF(AND(C3=\"Moderate\",D3=\"Low \"),2)))","v":false},{"$f":"IF(AND(C3=\"Low \",D3=\"Low \"),3,IF(AND(C3=\"Low \",D3=\"Moderate\"),3))","v":false},{"$f":"IF(B32<>\"-\",1,0)","v":0},null,{"$f":"IF(B3=$S$3,TRUE)","v":false},{"$nulls":4},"Yes","Low ","Low ","Low","Poor","Old","Yes","Localized "]
["Transverse Cracking",null,null,null,{"$f":"IF(B4=$S$18,MIN(I4:K4),\"-\")","v":"-"},{"$f":"IF(E4>$F$8,\"-\",E4)","v":"-"},{"$f":"IF(E4=\"-\",\"TRUE\")","v":"TRUE"},{"$f":"IF(AND(E4=$J$23,G4=FALSE),\"TRUE\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C4=\"High\",D4=\"High\"),1,IF(AND(C4=\"High\",D4=\"Moderate\"),1,IF(AND(C4=\"High\",D4=\"Low \"),1,IF(AND(C4=\"Moderate\",D4=\"High\"),1,IF(AND(C4=\"Moderate\",D4=\"Moderate\"),1,IF(AND(C4=\"Moderate\",D4=\"Low \"),1))))))","v":false},{"$f":"IF(AND(C4=\"Low \",D4=\"High\"),2)","v":false},{"$f":"IF(AND(C4=\"Low \",D4=\"Low \"),3,IF(AND(C4=\"Low \",D4=\"Moderate\"),3))","v":false},{"$f":"IF(B33<>\"-\",2,0)","v":0},null,{"$f":"IF(B4=$S$3,TRUE)","v":false},{"$nulls":4},"No","Moderate","Moderate","High","Good","New","No","Non-localized"]
["D-Cracks ",null,null,null,{"$f":"IF(B5=$S$18,MIN(I5:K5),\"-\")","v":"-"},{"$f":"IF(E5>$F$8,\"-\",E5)","v":"-"},"TRUE",{"$f":"IF(AND(E5=$J$23,G5=FALSE),\"TRUE\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C5=\"High\",D5=\"High\"),1,IF(AND(C5=\"High\",D5=\"Moderate\"),1,IF(AND(C5=\"High\",D5=\"Low \"),1)))","v":false},{"$f":"IF(AND(C5=\"Moderate\",D5=\"High\"),2,IF(AND(C5=\"Moderate\",D5=\"Moderate\"),2,IF(AND(C5=\"Moderate\",D5=\"Low \"),2,IF(AND(C5=\"Low \",D5=\"Low \"),2,IF(AND(C5=\"Low \",D5=\"Moderate\"),2,IF(AND(C5=\"Low \",D5=\"High\"),2))))))","v":false},null,{"$f":"IF(B34<>\"-\",3,0)","v":0},null,false,{"$nulls":5},"High","High"]
["Joint Spalling",null,null,null,{"$f":"IF(B6=$S$18,MIN(I6:K6),\"-\")","v":"-"},{"$f":"IF(E6>$F$8,\"-\",E6)","v":"-"},"TRUE",{"$f":"IF(AND(E6=$J$23,G6=FALSE),\"TRUE\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C6=\"High\",D6=\"High\"),1,IF(AND(C6=\"High\",D6=\"Moderate\"),1,IF(AND(C6=\"High\",D6=\"Low \"),1,IF(AND(C6=\"Moderate\",D6=\"High\"),1,IF(AND(C6=\"Moderate\",D6=\"Moderate\"),1,IF(AND(C6=\"Moderate\",D6=\"Low \"),1))))))","v":false},"-",{"$f":"IF(AND(C6=\"Low \",D6=\"Low \"),3,IF(AND(C6=\"Low \",D6=\"High\"),3,IF(AND(C6=\"Low \",D6=\"Moderate\"),3)))","v":false},{"$f":"IF(B35<>\"-\",4,0)","v":0},null,false]
["Faulting (JPCP)",null,null,null,"-",{"$f":"IF(E7>$F$8,\"-\",E7)","v":"-"},"TRUE",{"$f":"IF(AND(E7=$J$23,G7=FALSE),\"TRUE\")","v":{"$error":"#DIV/0!"}},"-",{"$f":"IF(AND(C7=\"High\",D7=\"High\"),2,IF(AND(C7=\"High\",D7=\"Moderate\"),2,IF(AND(C7=\"High\",D7=\"Low \"),2)))","v":false},{"$f":"IF(AND(C7=\"Low \",D7=\"High\"),3,IF(AND(C7=\"Low \",D7=\"Moderate\"),3,IF(AND(C7=\"Low \",D7=\"Low \"),3,IF(AND(C7=\"Moderate\",D7=\"High\"),3,IF(AND(C7=\"Moderate\",D7=\"Moderate\"),3,IF(AND(C7=\"Moderate\",D7=\"Low \"),3))))))","v":false},{"$f":"IF(B36<>\"-\",5,0)","v":0},null,false]
["Roughness ",{"$nulls":4},{"$f":"MIN(E3:E7)","v":0},{"$nulls":4},"Number of Treatments",{"$f":"MAX(L3:L7)","v":0},{"$f":"IF(L8=1,\"PCC Summary 1\",IF(L8>1,\"EUAC and ROI\"))","v":false}]
["Skid Resistance"]
["Pavement Age"]
["Surface Age"]
["Distress Location and Distribution"]
["Joint Related?"]
["Distress Distribution"]
[]
["Distress Data"]
[null,"Existence ","Severity Level","Extent Level","Class",null,"Check Class Existence","Check Unity ","Test I","Test II","Test III",{"$nulls":7},"Existence ","Severity Level","Extent Level","Roughness","Friction","Surface Age","Joint Related"]
["Longitudinal Cracking ",null,null,null,{"$f":"F3","v":"-"},null,{"$f":"IF(E18=\"-\",\"TRUE\")","v":"TRUE"},{"$f":"IF(AND(E18=$J$23,G18=FALSE),\"TRUE\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C18=\"High\",D18=\"High\"),1,IF(AND(C18=\"High\",D18=\"Moderate\"),1,IF(AND(C18=\"High\",D18=\"Low \"),1,IF(AND(C18=\"Moderate\",D18=\"High\"),1,IF(AND(C18=\"Moderate\",D18=\"Moderate\"),1,IF(AND(C18=\"Moderate\",D18=\"Low \"),1))))))","v":false},{"$f":"IF(AND(C18=\"Low \",D18=\"High\"),2)","v":false},{"$f":"IF(AND(C18=\"Low \",D18=\"Low \"),3,IF(AND(C18=\"Low \",D18=\"Moderate\"),3))","v":false},{"$nulls":7},"Yes","Low ","Low ","Low","Poor","Old","Yes"]
["Transverse Cracking",null,null,null,{"$f":"F4","v":"-"},null,{"$f":"IF(E19=\"-\",\"TRUE\")","v":"TRUE"},{"$f":"IF(AND(E19=$J$23,G19=FALSE),\"TRUE\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C19=\"High\",D19=\"High\"),1,IF(AND(C19=\"High\",D19=\"Moderate\"),1,IF(AND(C19=\"High\",D19=\"Low \"),1,IF(AND(C19=\"Moderate\",D19=\"High\"),1,IF(AND(C19=\"Moderate\",D19=\"Moderate\"),1,IF(AND(C19=\"Moderate\",D19=\"Low \"),1))))))","v":false},{"$f":"IF(AND(C19=\"Low \",D19=\"High\"),2)","v":false},{"$f":"IF(AND(C19=\"Low \",D19=\"Low \"),3,IF(AND(C19=\"Low \",D19=\"Moderate\"),3))","v":false},{"$nulls":7},"No","Moderate","Moderate","High","Good","New","No"]
["D-Cracks ",null,null,null,{"$f":"F5","v":"-"},null,"TRUE",{"$f":"IF(AND(E20=$J$23,G20=FALSE),\"TRUE\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C20=\"High\",D20=\"High\"),1,IF(AND(C20=\"High\",D20=\"Moderate\"),1,IF(AND(C20=\"High\",D20=\"Low \"),1)))","v":false},{"$f":"IF(AND(C20=\"Moderate\",D20=\"High\"),2,IF(AND(C20=\"Moderate\",D20=\"Moderate\"),2,IF(AND(C20=\"Moderate\",D20=\"Low \"),2)))","v":false},{"$f":"IF(AND(C20=\"Low \",D20=\"Low \"),3,IF(AND(C20=\"Low \",D20=\"Moderate\"),3,IF(AND(C20=\"Low \",D20=\"High\"),3)))","v":false},{"$nulls":8},"High","High"]
["Joint Spalling",null,null,null,{"$f":"F6","v":"-"},null,"TRUE",{"$f":"IF(AND(E21=$J$23,G21=FALSE),\"TRUE\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C21=\"High\",D21=\"High\"),1,IF(AND(C21=\"High\",D21=\"Moderate\"),1,IF(AND(C21=\"High\",D21=\"Low \"),1,IF(AND(C21=\"Moderate\",D21=\"High\"),1,IF(AND(C21=\"Moderate\",D21=\"Moderate\"),1,IF(AND(C21=\"Moderate\",D21=\"Low \"),1,IF(AND(C21=\"Low \",D21=\"High\"),1,IF(AND(C21=\"Low \",D21=\"Moderate\"),1))))))))","v":false},"-",{"$f":"IF(AND(C21=\"Low \",D21=\"Low \"),3)","v":false}]
["Faulting (JPCP)",null,null,null,{"$f":"F7","v":"-"},null,"TRUE",{"$f":"IF(AND(E22=$J$23,G22=FALSE),\"TRUE\")","v":{"$error":"#DIV/0!"}},"-",{"$f":"IF(AND(C22=\"High\",D22=\"High\"),2,IF(AND(C22=\"High\",D22=\"Moderate\"),2,IF(AND(C22=\"High\",D22=\"Low \"),2)))","v":false},{"$f":"IF(AND(C22=\"Low \",D22=\"High\"),3,IF(AND(C22=\"Low \",D22=\"Moderate\"),3,IF(AND(C22=\"Low \",D22=\"Low \"),3,IF(AND(C22=\"Moderate\",D22=\"High\"),3,IF(AND(C22=\"Moderate\",D22=\"Moderate\"),3,IF(AND(C22=\"Moderate\",D22=\"Low \"),3))))))","v":false}]
["Roughness ",{"$f":"B8","v":0},{"$nulls":6},"Average Classes (Check Class Unity)",{"$f":"AVERAGE(E18:E22)","v":{"$error":"#DIV/0!"}},null,"Case 2.1","Case 2.1","Case 2.3","Case 2.4","Case 2.5","Case 2.5","Case 3.2","Case 3.2","Case 3.2","Case 3.3","Case 3.3","Case 3.3","Case 3.4","Case 3.5","Case 3.6","Case 2.3","Case 2.3","Case 2.3","Case 2.4","Case 2.4","Case 2.4","Case 2.4","Case 2.5","Case 2.6","II","Case 1.1","Case 1.1","Case 1.2","Case 1.2","Case 1.3","Case 1.4","Case 1.4","Case 1.5","Case 1.5","Case 1.6","Case 1.7","Case 1.7","Case 1.8","Case 1.8","Case 1.9","Case 1.9","Case 1.10","Case 1.10","Case 1.11","Case 1.11","Case 1.12","Case 1.12","Case 1.13","Case 1.14","Case 1.15","Case 1.16","Case 1.17","Case 1.17","Case 1.18","Case 1.18","Case 1.19","Case 1.20","Case 1.21","Case 1.22","Case 1.23","Case 1.24","Case 1.25","Case 1.26","Case 1.27","Case 1.28","Case 1.29","Case 1.29","Case 1.29","Case 1.29","Case 1.29","III","Case 1.1","Case 1.1","Case 1.2","Case 1.3","Case 1.3","Case 1.4","Case 1.5","Case 1.6","Case 1.7","Case 1.1","Case 1.1","Case 1.2","Case 1.3","Case 1.4","Case 1.5","Case 1.6","Case 1.7"]
["Skid Resistance",{"$f":"B9","v":0},{"$nulls":8},"Longitudinal Cracking ",{"$f":"$E$18","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["Pavement Age",{"$nulls":9},"Transverse Cracking",{"$f":"$E$19","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["Surface Age",{"$f":"B11","v":0},{"$nulls":8},"D-Cracks ",{"$f":"$E$20","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["Distress Location",{"$nulls":9},"Joint Spalling",{"$f":"$E$21","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["Joint Related?",{"$f":"B13","v":0},{"$nulls":8},"Faulting (JPCP)",{"$f":"$E$22","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[{"$f":"IFERROR(IF(OR(G18=H18,G19=H19,G20=H20,G21=H21,G22=H22),\"Warning: you are trying to handle different distress classes at the same time. Please read the instructions again!\",\"\"),\"-\")","v":"-"},{"$nulls":9},"Case Existence",{"$f":"IF(AND(L24=1,L25=1,L26=\"-\",L27=\"-\",L28=\"-\",B14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(M24=1,M25=1,M26=\"-\",M27=\"-\",M28=\"-\",B14=Z3),\"TRUE\")","v":false},{"$f":"IF(AND(N24=1,N25=\"-\",N26=\"-\",N27=1,N28=\"-\"),\"TRUE\")","v":false},{"$f":"IF(AND(O24=\"-\",O25=1,O26=\"-\",O27=1,O28=\"-\"),\"TRUE\")","v":false},{"$f":"IF(AND(P24=\"-\",P25=1,P26=1,P27=\"-\",P28=\"-\",B14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(Q24=\"-\",Q25=1,Q26=1,Q27=\"-\",Q28=\"-\",B14=Z3),\"TRUE\")","v":false},{"$f":"IF(AND(R24=1,R25=1,R26=1,R27=1,R28=\"-\",B14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(S24=1,S25=1,S26=1,S27=1,S28=\"-\",B14=Z3),\"TRUE\")","v":false},{"$f":"IF(AND(T24=1,T25=1,T26=1,T27=\"-\",T28=\"-\",B14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(U24=1,U25=1,U26=1,U27=\"-\",U28=\"-\",B14=Z3),\"TRUE\")","v":false},{"$f":"IF(AND(V24=1,V25=\"-\",V26=1,V27=\"-\",V28=\"-\",B14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(W24=1,W25=\"-\",W26=1,W27=\"-\",W28=\"-\",B14=Z3),\"TRUE\")","v":false},{"$f":"IF(AND(X24=1,X25=\"-\",X26=1,X27=1,X28=\"-\"),\"TRUE\")","v":false},{"$f":"IF(AND(Y24=\"-\",Y25=1,Y26=1,Y27=1,Y28=\"-\"),\"TRUE\")","v":false},{"$f":"IF(AND(Z24=\"-\",Z25=\"-\",Z26=1,Z27=1,Z28=\"-\"),\"TRUE\")","v":false},{"$f":"IF(AND(AA24=\"-\",AA25=\"-\",AA26=1,AA27=\"-\",AA28=\"-\",B14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(AB24=\"-\",AB25=\"-\",AB26=1,AB27=\"-\",AB28=\"-\"),\"TRUE\")","v":false},{"$f":"IF(AND(AC24=\"-\",AC25=\"-\",AC26=\"-\",AC27=1,AC28=\"-\"),\"TRUE\")","v":false},{"$f":"IF(AND(AD24=\"-\",AD25=1,AD26=\"-\",AD27=\"-\",AD28=\"-\",B14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(AE24=\"-\",AE25=1,AE26=\"-\",AE27=\"-\",AE28=\"-\",B14=Z3),\"TRUE\")","v":false},{"$f":"IF(AND(AF24=1,AF25=\"-\",AF26=\"-\",AF27=\"-\",AF28=\"-\",B14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(AG24=1,AG25=\"-\",AG26=\"-\",AG27=\"-\",AG28=\"-\",B14=Z3),\"TRUE\")","v":false},{"$f":"IF(AND(AH24=1,AH25=1,AH26=\"-\",AH27=1,AH28=\"-\",B14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(AI24=1,AI25=1,AI26=\"-\",AI27=1,AI28=\"-\",B14=Z3),\"TRUE\")","v":false},null,{"$f":"IF(AND(AK24=2,AK25=\"-\",AK26=\"-\",AK27=\"-\",AK28=\"-\",$B$23=\"Low\",$B$24=\"Good\",B14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(AL24=2,AL25=\"-\",AL26=\"-\",AL27=\"-\",AL28=\"-\",$B$23=\"Low\",$B$24=\"Good\",B14=Z3),\"TRUE\")","v":false},{"$f":"IF(AND(AM24=2,AM25=\"-\",AM26=\"-\",AM27=\"-\",AM28=\"-\",$B$23=\"Low\",$B$24=\"Good\"),\"TRUE\")","v":false},{"$f":"IF(AND(AN24=2,AN25=\"-\",AN26=\"-\",AN27=\"-\",AN28=\"-\",$B$23=\"Low\",$B$24=\"Poor\",B14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(AO24=2,AO25=\"-\",AO26=\"-\",AO27=\"-\",AO28=\"-\",$B$23=\"Low\",$B$24=\"Poor\",B14=Z3),\"TRUE\")","v":false},{"$f":"IF(AND(AP24=2,AP25=\"-\",AP26=\"-\",AP27=\"-\",AP28=\"-\",$B$23=\"High\",B14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(AQ24=2,AQ25=\"-\",AQ26=\"-\",AQ27=\"-\",AQ28=\"-\",$B$23=\"High\",B14=Z3),\"TRUE\")","v":false},{"$f":"IF(AND(AR24=\"-\",AR25=2,AR26=\"-\",AR27=\"-\",AR28=\"-\",$B$23=\"Low\",$B$24=\"Good\",B14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(AS24=\"-\",AS25=2,AS26=\"-\",AS27=\"-\",AS28=\"-\",$B$23=\"Low\",$B$24=\"Good\",B14=Z3),\"TRUE\")","v":false},{"$f":"IF(AND(AT24=\"-\",AT25=2,AT26=\"-\",AT27=\"-\",AT28=\"-\",$B$23=\"Low\",$B$24=\"Good\"),\"TRUE\")","v":false},{"$f":"IF(AND(AU24=\"-\",AU25=2,AU26=\"-\",AU27=\"-\",AU28=\"-\",$B$23=\"Low\",$B$24=\"Poor\",B14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(AV24=\"-\",AV25=2,AV26=\"-\",AV27=\"-\",AV28=\"-\",$B$23=\"Low\",$B$24=\"Poor\",B14=Z3),\"TRUE\")","v":false},{"$f":"IF(AND(AW24=\"-\",AW25=2,AW26=\"-\",AW27=\"-\",AW28=\"-\",$B$23=\"High\",B14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(AX24=\"-\",AX25=2,AX26=\"-\",AX27=\"-\",AX28=\"-\",$B$23=\"High\",B14=Z3),\"TRUE\")","v":false},{"$f":"IF(AND(AY24=2,AY25=2,AY26=\"-\",AY27=\"-\",AY28=\"-\",$B$23=\"Low\",$B$24=\"Good\",B14=Z3),\"TRUE\")","v":false},{"$f":"IF(AND(AZ24=2,AZ25=2,AZ26=\"-\",AZ27=\"-\",AZ28=\"-\",$B$23=\"Low\",$B$24=\"Good\",B14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(BA24=2,BA25=2,BA26=\"-\",BA27=\"-\",BA28=\"-\",$B$23=\"Low\",$B$24=\"Good\",B14=Z3),\"TRUE\")","v":false},{"$f":"IF(AND(BB24=2,BB25=2,BB26=\"-\",BB27=\"-\",BB28=\"-\",$B$23=\"Low\",$B$24=\"Good\",B14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(BC24=2,BC25=2,BC26=\"-\",BC27=\"-\",BC28=\"-\",$B$23=\"Low\",$B$24=\"Poor\",B14=Z3),\"TRUE\")","v":false},{"$f":"IF(AND(BD24=2,BD25=2,BD26=\"-\",BD27=\"-\",BD28=\"-\",$B$23=\"Low\",$B$24=\"Poor\",B14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(BE24=2,BE25=2,BE26=\"-\",BE27=\"-\",BE28=\"-\",$B$23=\"High\",B14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(BF24=2,BF25=2,BF26=\"-\",BF27=\"-\",BF28=\"-\",$B$23=\"High\",B14=Z3),\"TRUE\")","v":false},{"$f":"IF(AND(BG24=2,BG25=\"-\",BG26=2,BG27=\"-\",BG28=\"-\",B14=Z3),\"TRUE\")","v":false},{"$f":"IF(AND(BH24=\"-\",BH25=2,BH26=2,BH27=\"-\",BH28=\"-\",$B$23=\"Low\",$B$24=\"Good\"),\"TRUE\")","v":false},{"$f":"IF(AND(BI24=2,BI25=\"-\",BI26=2,BI27=\"-\",BI28=\"-\",$B$23=\"High\",),\"TRUE\")","v":false},{"$f":"IF(AND(BJ24=\"-\",BJ25=2,BJ26=2,BJ27=\"-\",BJ28=\"-\",$B$23=\"High\",),\"TRUE\")","v":false},{"$f":"IF(AND(BK24=2,BK25=\"-\",BK26=2,BK27=\"-\",BK28=\"-\",B14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(BL24=2,BL25=\"-\",BL26=2,BL27=\"-\",BL28=\"-\",$B$23=\"Low\",$B$24=\"Poor\",B14=Z3),\"TRUE\")","v":false},{"$f":"IF(AND(BM24=\"-\",BM25=2,BM26=2,BM27=\"-\",BM28=\"-\",$B$23=\"Low\",$B$24=\"Poor\",B14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(BN24=\"-\",BN25=2,BN26=2,BN27=\"-\",BN28=\"-\",$B$23=\"Low\",$B$24=\"Poor\",B14=Z3),\"TRUE\")","v":false},{"$f":"IF(AND(BO24=2,BO25=\"-\",BO26=\"-\",BO27=\"-\",BO28=2),\"TRUE\")","v":false},{"$f":"IF(AND(BP24=\"-\",BP25=2,BP26=\"-\",BP27=\"-\",BP28=2),\"TRUE\")","v":false},{"$f":"IF(AND(BQ24=2,BQ25=2,BQ26=2,BQ27=\"-\",BQ28=\"-\"),\"TRUE\")","v":false},{"$f":"IF(AND(BR24=2,BR25=2,BR26=\"-\",BR27=\"-\",BR28=2),\"TRUE\")","v":false},{"$f":"IF(AND(BS24=2,BS25=\"-\",BS26=2,BS27=\"-\",BS28=2),\"TRUE\")","v":false},{"$f":"IF(AND(BT24=\"-\",BT25=2,BT26=2,BT27=\"-\",BT28=2),\"TRUE\")","v":false},{"$f":"IF(AND(BU24=2,BU25=2,BU26=2,BU27=\"-\",BU28=2),\"TRUE\")","v":false},{"$f":"IF(AND(BV24=\"-\",BV25=\"-\",BV26=2,BV27=\"-\",BV28=2),\"TRUE\")","v":false},{"$f":"IF(AND(BW24=\"-\",BW25=\"-\",BW26=\"-\",BW27=\"-\",BW28=2),\"TRUE\")","v":false},{"$f":"IF(AND(BX24=\"-\",BX25=\"-\",BX26=2,BX27=\"-\",BX28=\"-\"),\"TRUE\")","v":false},{"$f":"IF(AND(BY24=\"-\",BY25=2,BY26=\"-\",BY27=\"-\",BY28=2),\"TRUE\")","v":false},{"$f":"IF(AND(BZ24=2,BZ25=\"-\",BZ26=2,BZ27=\"-\",BZ28=\"-\",B8=V4,B14=Z3),\"TRUE\")","v":false},{"$f":"IF(AND(CA24=2,CA25=\"-\",CA26=2,CA27=\"-\",CA28=\"-\",B8=V4,B14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(CB24=\"-\",CB25=2,CB26=2,CB27=\"-\",CB28=\"-\",B14=Z3),\"TRUE\")","v":false},{"$f":"IF(AND(CC24=\"-\",CC25=2,CC26=2,CC27=\"-\",CC28=\"-\",B14=Z4),\"TRUE\")","v":false},null,{"$f":"IF(OR(CE24=3,CE25=3,CE26=3,CE27=3,),IF(AND(CE28=3,$B$28=\"Yes\",$B$23=\"High\",B14=Z4),\"TRUE\"))","v":false},{"$f":"IF(OR(CF24=3,CF25=3,CF26=3,CF27=3,),IF(AND(CF28=3,$B$28=\"Yes\",$B$23=\"High\",B14=Z3),\"TRUE\"))","v":false},{"$f":"IF(OR(CG24=3,CG25=3,CG26=3,CG27=3,CG28=3),IF(AND($B$28=\"Yes\",$B$23=\"Low\",$B$24=\"Good\"),\"TRUE\"))","v":false},{"$f":"IF(OR(CH24=3,CH25=3,CH26=3,CH27=3),IF(AND(CH28=3,$B$28=\"Yes\",$B$23=\"Low\",$B$24=\"Poor\",B14=Z4),\"TRUE\"))","v":false},{"$f":"IF(OR(CI24=3,CI25=3,CI26=3,CI27=3),IF(AND(CI28=3,$B$28=\"Yes\",$B$23=\"Low\",$B$24=\"Poor\",B14=Z3),\"TRUE\"))","v":false},{"$f":"IF(OR(CJ24=3,CJ25=3,CJ26=3,CJ27=3,CJ28=3),IF(AND($B$28=\"No\",$B$23=\"High\"),\"TRUE\"))","v":false},{"$f":"IF(OR(CK24=3,CK25=3,CK26=3,CK27=3,CK28=3),IF(AND($B$28=\"No\",$B$23=\"Low\",$B$24=\"Poor\"),\"TRUE\"))","v":false},{"$f":"IF(OR(CL24=3,CL25=3,CL26=3,CL27=3,CL28=3),IF(AND($B$28=\"No\",$B$23=\"Low\",$B$24=\"Good\"),\"TRUE\"))","v":false},{"$f":"IF(OR(CM24=3,CM25=3,CM26=3,CM27=3,CM28=3),IF(AND($B$28=\"No\",$B$23=\"Low\",$B$24=\"Good\"),\"TRUE\"))","v":false},{"$f":"IF(AND(CN24=\"-\",CN25=\"-\",CN26=\"-\",CN27=\"-\",CN28=3,$B$28=\"Yes\",$B$23=\"High\"),\"TRUE\")","v":false},{"$f":"IF(AND(CO24=\"-\",CO25=\"-\",CO26=\"-\",CO27=\"-\",CO28=3,$B$28=\"Yes\",$B$23=V3,B24=W3),\"TRUE\")","v":false},{"$f":"IF(AND(CP24=3,CP25=3,CP26=\"-\",CP27=3,CP28=\"-\",$B$28=\"Yes\",$B$23=V4,$B$14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(CQ24=3,CQ25=3,CQ26=\"-\",CQ27=3,CQ28=\"-\",$B$28=\"Yes\",$B$23=V4,$B$14=Z3),\"TRUE\")","v":false},{"$f":"IF(AND(CR24=3,CR25=\"-\",CR26=\"-\",CR27=3,CR28=\"-\",$B$28=\"Yes\",$B$23=V4,$B$14=Z3),\"TRUE\")","v":false},{"$f":"IF(AND(CS24=3,CS25=\"-\",CS26=\"-\",CS27=3,CS28=\"-\",$B$28=\"Yes\",$B$23=V4,$B$14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(CT24=\"-\",CT25=3,CT26=\"-\",CT27=3,CT28=\"-\",$B$28=\"Yes\",$B$23=V4,$B$14=Z4),\"TRUE\")","v":false},{"$f":"IF(AND(CU24=\"-\",CU25=3,CU26=\"-\",CU27=3,CU28=\"-\",$B$28=\"Yes\",$B$23=V4,$B$14=Z3),\"TRUE\")","v":false}]
[]
["Potential Action(s)",{"$nulls":10},"Potential Global Treatment ",{"$nulls":4},"Number"]
["Action #1 ",{"$f":"M118","v":"-"},"*Diamond grinding should be used in conjunction with load transfer restoration treatment",{"$nulls":7},"I",{"$f":"IF(AB29=\"True\", \"Full depth repair, Reconstruction,\")","v":false},{"$nulls":4},{"$f":"IF(L32=FALSE,0,1)","v":0},{"$f":"L32","v":false}]
["Action #2",{"$f":"M119","v":"-"},{"$nulls":9},{"$f":"IF(AG29=\"True\", \"Full depth repair,\")","v":false},{"$nulls":4},0,false]
["Action #3","-",{"$nulls":9},{"$f":"IF(AF29=\"True\", \"HMA overlay with crack and seat, HMA overlay with rubblization, Reconstruction,\")","v":false},{"$nulls":4},0,false]
["Action #4","-","**Joints should be repaired before an HMA overlay",{"$nulls":8},{"$f":"IF(AE29=\"True\", \"Full depth repair,\")","v":false},{"$nulls":4},0,false]
["Action #5","-",{"$nulls":9},{"$f":"IF(AD29=\"True\", \"HMA overlay with crack and seat, HMA overlay with rubblization, Reconstruction,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(AC29=\"True\", \"Full depth repair, Reconstruction,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(V29=\"True\", \"HMA overlay with crack and seat, HMA overlay with rubblization, Reconstruction,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(W29=\"True\", \"Full depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L39=FALSE,0,1)","v":0},{"$f":"L39","v":false}]
[{"$nulls":11},{"$f":"IF(L29=\"True\", \"HMA overlay with crack and seat, HMA overlay with rubblization, Reconstruction,\")","v":false},{"$nulls":4},{"$f":"IF(L40=FALSE,0,1)","v":0},{"$f":"L40","v":false}]
[{"$nulls":11},{"$f":"IF(M29=\"True\", \"Full depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L41=FALSE,0,1)","v":0},{"$f":"L41","v":false}]
[{"$nulls":11},{"$f":"IF(N29=\"True\", \"Full depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L42=FALSE,0,1)","v":0},{"$f":"L42","v":false}]
[{"$nulls":11},{"$f":"IF(O29=\"True\", \"Full depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L43=FALSE,0,1)","v":0},{"$f":"L43","v":false}]
[{"$nulls":11},{"$f":"IF(P29=\"True\", \"HMA overlay with crack and seat, HMA overlay with rubblization, Reconstruction,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(Q29=\"True\", \"Full depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L45=FALSE,0,1)","v":0},{"$f":"L45","v":false}]
[{"$nulls":11},{"$f":"IF(S29=\"True\", \"Full depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L46=FALSE,0,1)","v":0},{"$f":"L46","v":false}]
[{"$nulls":11},{"$f":"IF(R29=\"True\", \"HMA overlay with crack and seat, HMA overlay with rubblization, Reconstruction,\")","v":false},{"$nulls":4},{"$f":"IF(L47=FALSE,0,1)","v":0},{"$f":"L47","v":false}]
[{"$nulls":11},{"$f":"IF(AI29=\"True\", \"Full depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L48=FALSE,0,1)","v":0},{"$f":"L48","v":false}]
[{"$nulls":11},{"$f":"IF(AH29=\"True\", \"HMA overlay with crack and seat, HMA overlay with rubblization, Reconstruction,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(T29=\"True\", \"HMA overlay with crack and seat, HMA overlay with rubblization, Reconstruction,\")","v":false},{"$nulls":4},{"$f":"IF(L50=FALSE,0,1)","v":0},{"$f":"L50","v":false}]
[{"$nulls":11},{"$f":"IF(U29=\"True\", \"Full depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L51=FALSE,0,1)","v":0},{"$f":"L51","v":false}]
[{"$nulls":11},{"$f":"IF(X29=\"True\", \"Full depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L52=FALSE,0,1)","v":0},{"$f":"L52","v":false}]
[{"$nulls":11},{"$f":"IF(Y29=\"True\", \"Full depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L53=FALSE,0,1)","v":0},{"$f":"L53","v":false}]
[{"$nulls":11},{"$f":"IF(Z29=\"True\", \"Full depth repair, Reconstruction,\")","v":false},{"$nulls":4},{"$f":"IF(L54=FALSE,0,1)","v":0},{"$f":"L54","v":false}]
[{"$nulls":11},{"$f":"IF(AK29=\"True\", \"Crack sealing,\")","v":false},{"$nulls":4},{"$f":"IF(L55=FALSE,0,1)","v":0},{"$f":"L55","v":false}]
[{"$nulls":11},{"$f":"IF(AL29=\"True\", \"Full depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L56=FALSE,0,1)","v":0},{"$f":"L56","v":false}]
[{"$nulls":10},"II",{"$f":"IF(AM29=\"True\", \" Full depth repair, HMA overlay,\")","v":false},{"$nulls":4},{"$f":"IF(L57=FALSE,0,1)","v":0},{"$f":"L57","v":false}]
[{"$nulls":11},{"$f":"IF(AN29=\"True\", \"HMA overlay,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(AO29=\"True\", \"Full depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L59=FALSE,0,1)","v":0},{"$f":"L59","v":false}]
[{"$nulls":11},{"$f":"IF(AP29=\"True\", \"HMA overlay,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(AQ29=\"True\", \"Full depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L61=FALSE,0,1)","v":0},{"$f":"L61","v":false}]
[{"$nulls":11},{"$f":"IF(AR29=\"True\", \"Crack sealing,\")","v":false},{"$nulls":4},{"$f":"IF(L62=FALSE,0,1)","v":0},{"$f":"L62","v":false}]
[{"$nulls":11},{"$f":"IF(AS29=\"True\", \"Full depth repair,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(AT29=\"True\", \" Full depth repair, HMA overlay,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(AU29=\"True\", \"HMA overlay,\")","v":false},{"$nulls":4},{"$f":"IF(L65=FALSE,0,1)","v":0},{"$f":"L65","v":false}]
[{"$nulls":11},{"$f":"IF(AV29=\"True\", \"Full depth repair,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(AW29=\"True\", \"HMA overlay,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(AX29=\"True\", \"Full depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L68=FALSE,0,1)","v":0},{"$f":"L68","v":false}]
[{"$nulls":11},{"$f":"IF(AY29=\"True\", \"Partial depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L69=FALSE,0,1)","v":0},{"$f":"L69","v":false}]
[{"$nulls":11},{"$f":"IF(AZ29=\"True\", \"Crack sealing,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(BA29=\"True\", \"Full depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L71=FALSE,0,1)","v":0},{"$f":"L71","v":false}]
[{"$nulls":11},{"$f":"IF(BB29=\"True\", \"HMA overlay,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(BC29=\"True\", \"Partial depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L73=FALSE,0,1)","v":0},{"$f":"L73","v":false}]
[{"$nulls":11},{"$f":"IF(BD29=\"True\", \"HMA overlay,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(BE29=\"True\", \"HMA overlay,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(BF29=\"True\", \"Partial depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L76=FALSE,0,1)","v":0},{"$f":"L76","v":false}]
[{"$nulls":11},{"$f":"IF(CC29=\"True\", \"HMA overlay,\")","v":false},{"$nulls":4},{"$f":"IF(L77=FALSE,0,1)","v":0},{"$f":"L77","v":false}]
[{"$nulls":11},{"$f":"IF(CB29=\"True\", \"Partial depth repair,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(CA29=\"True\", \"HMA overlay,\")","v":false},{"$nulls":4},{"$f":"IF(L79=FALSE,0,1)","v":0},{"$f":"L79","v":false}]
[{"$nulls":11},{"$f":"IF(BZ29=\"True\", \"Partial depth repair,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(BG29=\"True\", \"Partial depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L81=FALSE,0,1)","v":0},{"$f":"L81","v":false}]
[{"$nulls":11},{"$f":"IF(BH29=\"True\", \"Full depth repair, Partial depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L82=FALSE,0,1)","v":0},{"$f":"L82","v":false}]
[{"$nulls":11},{"$f":"IF(BI29=\"True\", \"Full depth repair, Partial depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L83=FALSE,0,1)","v":0},{"$f":"L83","v":false}]
[{"$nulls":11},{"$f":"IF(BJ29=\"True\", \"Full depth repair, Partial depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L84=FALSE,0,1)","v":0},{"$f":"L84","v":false}]
[{"$nulls":11},{"$f":"IF(BK29=\"True\", \"HMA overlay,\")","v":false},{"$nulls":4},{"$f":"IF(L85=FALSE,0,1)","v":0},{"$f":"L85","v":false}]
[{"$nulls":11},{"$f":"IF(BL29=\"True\", \"Partial depth repair,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(BM29=\"True\", \"HMA overlay,\")","v":false},{"$nulls":4},{"$f":"IF(L87=FALSE,0,1)","v":0},{"$f":"L87","v":false}]
[{"$nulls":11},{"$f":"IF(BN29=\"True\", \"Partial depth repair,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":10},"III",{"$f":"IF(BO29=\"True\", \"HMA overlay,\")","v":false},{"$nulls":4},{"$f":"IF(L89=FALSE,0,1)","v":0},{"$f":"L89","v":false}]
[{"$nulls":11},{"$f":"IF(AQ29=\"True\", \"HMA overlay,\")","v":false},{"$nulls":4},{"$f":"IF(L90=FALSE,0,1)","v":0},{"$f":"L90","v":false}]
[{"$nulls":11},{"$f":"IF(BQ29=\"True\", \"Full depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L91=FALSE,0,1)","v":0},{"$f":"L91","v":false}]
[{"$nulls":11},{"$f":"IF(BR29=\"True\", \"HMA overlay,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(BS29=\"True\", \"HMA overlay,\")","v":false},{"$nulls":4},{"$f":"IF(L93=FALSE,0,1)","v":0},{"$f":"L93","v":false}]
[{"$nulls":11},{"$f":"IF(BT29=\"True\", \"HMA overlay,\")","v":false},{"$nulls":4},{"$f":"IF(L94=FALSE,0,1)","v":0},{"$f":"L94","v":false}]
[{"$nulls":11},{"$f":"IF(BU29=\"True\", \"HMA overlay,\")","v":false},{"$nulls":4},{"$f":"IF(L95=FALSE,0,1)","v":0},{"$f":"L95","v":false}]
[{"$nulls":11},{"$f":"IF(CE29=\"True\", \"HMA overlay, Diamond grinding,\")","v":false},{"$nulls":4},{"$f":"IF(L96=FALSE,0,1)","v":0},{"$f":"L96","v":false}]
[{"$nulls":11},{"$f":"IF(CF29=\"True\", \"Partial depth repair,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(BX29=\"True\", \"Partial depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L98=FALSE,0,1)","v":0},{"$f":"L98","v":false}]
[{"$nulls":11},{"$f":"IF(CO29=\"True\", \"Diamond grinding,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(BY29=\"True\", \"HMA overlay, Diamond grinding,\")","v":false},{"$nulls":4},{"$f":"IF(L100=FALSE,0,1)","v":0},{"$f":"L100","v":false}]
[{"$nulls":11},{"$f":"IF(BW29=\"True\", \"Diamond grinding,\")","v":false},{"$nulls":4},{"$f":"IF(L101=FALSE,0,1)","v":0},{"$f":"L101","v":false}]
[{"$nulls":10},"Potential Treatment",{"$f":"IF(BV29=\"True\", \"Partial depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L102=FALSE,0,1)","v":0},{"$f":"L102","v":false}]
[{"$nulls":10},{"$f":"FIND(\",\",L117,1)","v":{"$error":"#N/A"}},{"$f":"IF(CN29=\"True\", \"Diamond grinding,\")","v":false},{"$nulls":4},{"$f":"IF(L103=FALSE,0,1)","v":0},{"$f":"L103","v":false}]
[{"$nulls":10},{"$f":"FIND(\",\",$L$117,K103+1)","v":{"$error":"#N/A"}},{"$f":"IF(CG29=\"True\", \"Joint sealing, Do Nothing,\")","v":false},{"$nulls":4},{"$f":"IF(L104=FALSE,0,1)","v":0},{"$f":"L104","v":false}]
[{"$nulls":10},{"$f":"FIND(\",\",$L$117,K104+1)","v":{"$error":"#N/A"}},{"$f":"IF(CH29=\"True\", \"HMA overlay, Diamond grinding,\")","v":false},{"$nulls":4},{"$f":"IF(L105=FALSE,0,1)","v":0},{"$f":"L105","v":false}]
[{"$nulls":10},{"$f":"FIND(\",\",$L$117,K105+1)","v":{"$error":"#N/A"}},{"$f":"IF(CI29=\"True\", \"Partial depth repair,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":10},{"$f":"FIND(\",\",$L$117,K106+1)","v":{"$error":"#N/A"}},{"$f":"IF(CJ29=\"True\", \"HMA overlay, Diamond grinding,\")","v":false},{"$nulls":4},{"$f":"IF(L107=FALSE,0,1)","v":0},{"$f":"L107","v":false}]
[{"$nulls":11},{"$f":"IF(CP29=\"True\", \"HMA overlay, Diamond grinding,\")","v":false},{"$nulls":4},{"$f":"IF(L108=FALSE,0,1)","v":0},{"$f":"L108","v":false}]
[{"$nulls":11},{"$f":"IF(CQ29=\"True\", \"Partial depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L109=FALSE,0,1)","v":0},{"$f":"L109","v":false}]
[{"$nulls":11},{"$f":"IF(CR29=\"True\", \"Partial depth repair,\")","v":false},{"$nulls":4},{"$f":"IF(L110=FALSE,0,1)","v":0},{"$f":"L110","v":false}]
[{"$nulls":11},{"$f":"IF(CS29=\"True\", \"HMA overlay, Diamond grinding,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(CT29=\"True\", \"HMA overlay, Diamond grinding,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(CU29=\"True\", \"Partial depth repair,\")","v":false},{"$nulls":4},0,false]
[{"$nulls":11},{"$f":"IF(CK29=\"True\", \"HMA overlay, Diamond grinding,\")","v":false},{"$nulls":4},{"$f":"IF(L114=FALSE,0,1)","v":0},{"$f":"L114","v":false}]
[{"$nulls":11},{"$f":"IF(CM29=\"True\", \"Crack sealing, Do Nothing,\")","v":false},{"$nulls":4},{"$f":"IF(L115=FALSE,0,1)","v":0},{"$f":"L115","v":false}]
[]
[{"$nulls":11},{"$f":"VLOOKUP(1,Q32:R115,2,FALSE)","v":{"$error":"#N/A"}}]
[{"$nulls":11},{"$f":"LEFT(L117,K103-1)","v":{"$error":"#N/A"}},{"$f":"IFERROR(L118,\"-\")","v":"-"}]
[{"$nulls":11},{"$f":"MID($L$117,K103+2,K104-K103-2)","v":{"$error":"#N/A"}},{"$f":"IFERROR(L119,\"-\")","v":"-"}]
[{"$nulls":11},{"$f":"MID($L$117,K104+2,K105-K104-2)","v":{"$error":"#N/A"}},"-"]
[{"$nulls":11},{"$f":"MID($L$117,K105+2,K106-K105-2)","v":{"$error":"#N/A"}},"-"]
[{"$nulls":11},{"$f":"MID($L$117,K106+2,K107-K106-2)","v":{"$error":"#N/A"}},"-"]

{"sheet":"PCC Distress Id Manual","index":5,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,3,0],[4,0,6,0],[7,0,9,0],[10,0,12,0],[13,0,15,0]]}
["Distress ","Severity level","Severity level threshold values","Extent level","Extent level threshold values"]
["Longitudinal cracking","Low ","Mean width < 3 mm (0.125 in)","Low ","Less than 125 m/km (660 ft/mile)"]
[null,"Moderate","3 mm (0.125 in) ≤ Mean width < 13 mm (0.5 in)","Moderate ","From 125 m/km (660 ft/mile) to 249 m/km (1319 ft/mile)"]
[null,"High","Mean width ≥ 13 mm (0.5 in)","High","Greater than or equal 250 m/km (1320 ft/mile)"]
["Transverse Cracking","Low ","Mean width < 3 mm (0.125 in)","Low ","Less than 75 m/km (396 ft/mile) "]
[null,"Moderate","3 mm (0.125 in) ≤ Mean width < 6 mm (0.25 in)","Moderate ","From 75 m/km (396 ft/mile)  to 149 m/km (791 ft/mile)"]
[null,"High","Mean width ≥ 6 mm (0.25 in)","High","Greater than or equal 150 m/km (792 ft/mile)"]
["D-cracks","Low ","Tight with no loose pieces ","Low ","1-9% of the slab affected"]
[null,"Moderate","Well-defined cracks","Moderate","10-24% of the slab affected"]
[null,"High","Well-developed pattern","High","More than 25% of the slab affected"]
["Joint spalling ","Low ","Spalls < 75 mm (3 in)","Low ","1-9% of the slab affected"]
[null,"Moderate","75 mm (3 in) ≤ spalls < 150 mm (6 in)","Moderate","10-24% of the slab affected"]
[null,"High","Spall ≥ 150 mm (6 in)","High","More than 25% of the slab affected"]
["Faulting","Low ","Fault < 5 mm (0.2 in)","Low ","1-9% of the slab affected"]
[null,"Moderate","5 mm (0.2 in) ≤ fault < 7.5 mm (0.3 in)","Moderate","10-24% of the slab affected"]
[null,"High","Fault > 7.5 mm (0.3 in)","High","More than 25% of the slab affected"]

{"sheet":"EUAC and ROI","index":6,"n_rows":90,"n_cols":41,"rows_kept":90,"cut":false,"hidden":false,"merged":[[48,0,48,8],[57,0,57,8],[6,7,6,8],[7,7,7,8],[8,7,8,8],[9,7,9,8],[10,7,10,8],[11,7,11,8],[12,7,12,8],[4,22,4,24],[15,0,15,8],[23,0,23,8],[31,0,31,8],[39,0,39,8],[12,21,12,25],[6,0,6,1],[19,21,19,24],[20,21,20,25],[21,21,21,25],[22,21,22,25],[25,21,25,25],[32,21,32,24],[33,21,33,25],[34,21,34,25],[35,21,35,25],[51,21,51,25],[36,21,36,26],[58,21,58,24],[59,21,59,25],[60,21,60,25],[38,21,38,25],[45,21,45,24],[46,21,46,25],[47,21,47,25],[48,21,48,25],[49,21,49,26],[75,19,75,24],[64,19,64,23],[71,19,71,22],[72,19,72,23],[73,19,73,23],[74,19,74,23],[61,21,61,25],[0,0,1,9],[89,19,89,24],[88,19,88,24],[24,21,24,26],[37,21,37,26],[50,21,50,26],[63,21,63,26],[76,19,76,24],[77,19,77,23],[84,19,84,22],[85,19,85,23],[86,19,86,23],[87,19,87,23],[23,21,23,26],[62,21,62,26]]}
["EUAC and ROI Calculations"]
[]
["Pavement Surface Type",{"$f":"'Project Information'!B9","v":0},{"$nulls":11},"Surface Type","Treatments ",null,"Number of Treatments"]
["Remaining Service Life",{"$f":"MAX(AO7:AO12)","v":0},{"$nulls":10},"AC","Yes",{"$f":"IF($B$3=\"AC\",\"Crack fill\",\"\")","v":""},{"$f":"IF($H$8=\"Yes\",1,\"None\")","v":"None"},{"$f":"IF($H$9=\"Yes\",1,\"None\")","v":"None"},{"$f":"IF($H$10=\"Yes\",1,\"None\")","v":"None"},{"$f":"IF($H$11=\"Yes\",1,\"None\")","v":"None"},{"$f":"IF($H$12=\"Yes\",1,\"None\")","v":"None"},{"$f":"IF($H$13=\"Yes\",1,\"None\")","v":"None"},{"$f":"IF(B3=\"AC\",\"AC Treatments Data\",\"PCC Treatments Data\")","v":"PCC Treatments Data"},{"$f":"IF(B3=\"AC\",\"AC Surface Pavements\",\"PCC Surface Pavements\")","v":"PCC Surface Pavements"}]
["Discount Rate",0.03,{"$nulls":10},"PCC","No","Crack sealing",{"$f":"IF($H$8=\"Yes\",2,\"\")","v":""},{"$f":"IF($H$9=\"Yes\",2,\"\")","v":""},{"$f":"IF($H$10=\"Yes\",2,\"\")","v":""},{"$f":"IF($H$11=\"Yes\",2,\"\")","v":""},{"$f":"IF($H$12=\"Yes\",2,\"\")","v":""},{"$f":"IF($H$13=\"Yes\",2,\"\")","v":""},"Pavement Service Life","Quantity Entered",null,null,"Scenario Check","Sheet Name",{"$nulls":7},"Remaning Service Life"]
[{"$nulls":14},{"$f":"IF($B$3=\"AC\",\"Slurry seal\",\"Joint sealing\" )","v":"Joint sealing"},{"$f":"IF($H$8=\"Yes\",3,\"\")","v":""},{"$f":"IF($H$9=\"Yes\",3,\"\")","v":""},{"$f":"IF($H$10=\"Yes\",3,\"\")","v":""},{"$f":"IF($H$11=\"Yes\",3,\"\")","v":""},{"$f":"IF($H$12=\"Yes\",3,\"\")","v":""},{"$f":"IF($H$13=\"Yes\",3,\"\")","v":""},{"$f":"IF(B8<>\"-\",G8,\"\")","v":""},{"$f":"IF(B8<>\"-\",\"True\")","v":false},{"$f":"IF(E8>0,\"True\")","v":"True"},{"$f":"IF(W6=X6,\"True\")","v":false},null,{"$f":"IF(AND(Q22=\"True\",Q38=\"True\",Q46 =\"True\",Q55=\"True\",Q64=\"True\"),\"Treatment Ranking I\")","v":false},{"$nulls":6},"Current pavement class ","Pavement Type","Check pavement type","Class ","Check Class","check both","RSL","Current RSL"]
["Potential Action",null,"Unit Cost","Unit","Quantity","Initial Cost","Treatment Service Life","Are you combining this action with other treatments in later service life?",null,"How Many?",{"$nulls":4},{"$f":"IF($B$3=\"AC\",\"Chip seal\",\"Diamond grinding\")","v":"Diamond grinding"},{"$f":"IF($H$8=\"Yes\",4,\"\")","v":""},{"$f":"IF($H$9=\"Yes\",4,\"\")","v":""},{"$f":"IF($H$10=\"Yes\",4,\"\")","v":""},{"$f":"IF($H$11=\"Yes\",4,\"\")","v":""},{"$f":"IF($H$12=\"Yes\",4,\"\")","v":""},{"$f":"IF($H$13=\"Yes\",4,\"\")","v":""},"",false,"True",{"$f":"IF(W7=X7,\"True\")","v":false},null,{"$f":"ADDRESS(6,26)","v":"$Z$6"},{"$nulls":6},{"$f":"IF(B3=\"AC\",'AC Surface Pavements'!F7,'PCC Surface Pavements'!F8)","v":0},"AC",{"$f":"IF($B$3=AI7,TRUE)","v":false},1,{"$f":"IF($AH$7=AK7,TRUE)","v":false},{"$f":"IF(AND(AJ7=TRUE,AL7=TRUE),TRUE)","v":false},2,{"$f":"IF(AM7=TRUE,AN7,0)","v":0}]
["Action #1 ",{"$f":"IF(IF($B$3=\"AC\",'AC Surface Pavements'!B26,'PCC Surface Pavements'!B32)<>\"Do Nothing\",IF($B$3=\"AC\",'AC Surface Pavements'!B26,'PCC Surface Pavements'!B32),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(B8,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(B8,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(B8,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(B8,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(D8=\"Lane mile\",'Project Information'!$B$12,IF(D8=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!D8=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},{"$f":"IFERROR(C8*E8,\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(B8,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(B8,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},null,null,"",{"$nulls":4},{"$f":"IF($B$3=\"AC\",\"Microsurfacing\",\"Diamond grooving\")","v":"Diamond grooving"},{"$nulls":6},"",false,"True",false,{"$nulls":9},"AC",{"$f":"IF($B$3=AI8,TRUE)","v":false},2,{"$f":"IF($AH$7=AK8,TRUE)","v":false},{"$f":"IF(AND(AJ8=TRUE,AL8=TRUE),TRUE)","v":false},8,{"$f":"IF(AM8=TRUE,AN8,0)","v":0}]
["Action #2",{"$f":"IF(IF($B$3=\"AC\",'AC Surface Pavements'!B27,'PCC Surface Pavements'!B33)<>\"Do Nothing\",IF($B$3=\"AC\",'AC Surface Pavements'!B27,'PCC Surface Pavements'!B33),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(B9,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(B9,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(B9,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(B9,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(D9=\"Lane mile\",'Project Information'!$B$12,IF(D9=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!D9=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},"-",{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(B9,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(B9,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},{"$nulls":7},{"$f":"IF($B$3=\"AC\",\"Sand seal\",\"Partial depth repair\")","v":"Partial depth repair"},{"$nulls":6},"",false,"True",false,{"$nulls":9},"AC",false,3,false,false,10,0]
["Action #3",{"$f":"IF(IF($B$3=\"AC\",'AC Surface Pavements'!B28,'PCC Surface Pavements'!B34)<>\"Do Nothing\",IF($B$3=\"AC\",'AC Surface Pavements'!B28,'PCC Surface Pavements'!B34),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(B10,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(B10,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(B10,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(B10,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(D10=\"Lane mile\",'Project Information'!$B$12,IF(D10=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!D10=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},"-",{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(B10,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(B10,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},{"$nulls":7},{"$f":"IF($B$3=\"AC\",\"Milling\",\"Full depth repair\")","v":"Full depth repair"},{"$nulls":6},"",false,"True",false,{"$nulls":9},"PCC",false,1,false,false,4,0]
["Action #4",{"$f":"IF(IF($B$3=\"AC\",'AC Surface Pavements'!B29,'PCC Surface Pavements'!B35)<>\"Do Nothing\",IF($B$3=\"AC\",'AC Surface Pavements'!B29,'PCC Surface Pavements'!B35),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(B11,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(B11,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(B11,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(B11,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(D11=\"Lane mile\",'Project Information'!$B$12,IF(D11=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!D11=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},"-",{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(B11,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(B11,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},{"$nulls":7},{"$f":"IF($B$3=\"AC\",\"Milling with Overlay\",\"HMA overlay\")","v":"HMA overlay"},{"$nulls":6},40,"True",false,false,{"$nulls":9},"PCC",false,2,false,false,16,0]
["Action #5",{"$f":"IF(IF($B$3=\"AC\",'AC Surface Pavements'!B30,'PCC Surface Pavements'!B36)<>\"Do Nothing\",IF($B$3=\"AC\",'AC Surface Pavements'!B30,'PCC Surface Pavements'!B36),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(B12,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(B12,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(B12,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(B12,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(D12=\"Lane mile\",'Project Information'!$B$12,IF(D12=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!D12=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},"-",{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(B12,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(B12,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},{"$nulls":7},{"$f":"IF($B$3=\"AC\",\"Milling + Chip Seal\",\"HMA overlay with crack and seat\")","v":"HMA overlay with crack and seat"},{"$nulls":19},"PCC",false,3,false,false,20,0]
["Action #6 (ROI Calc.)","Planned Reconstruction/Rehab",{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(B13,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(B13,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":575000},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(B13,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(B13,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"Lane mile"},{"$f":"IF(D13=\"Lane mile\",'Project Information'!$B$12,IF(D13=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!D13=\"SY\",'Project Information'!$B$13,\"-\")))","v":0},0,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(B13,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(B13,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":40},{"$nulls":7},{"$f":"IF($B$3=\"AC\",\"CIR\",\"HMA overlay with rubblization\")","v":"HMA overlay with rubblization"},{"$nulls":6},"Scenario #1 "]
[{"$nulls":14},{"$f":"IF($B$3=\"AC\",\"Whitetopping\",\"Slab replacement\")","v":"Slab replacement"},{"$nulls":6},"Treatment Actions","Year (Ordinal)","Treatment","Initial Cost","NPV Cost","Service Life","Index","Service Life"]
[{"$nulls":14},"Thin HMA overlay ",{"$nulls":6},{"$f":"A18","v":"-"},{"$f":"B18","v":0},{"$f":"C18","v":"-"},{"$f":"G18","v":"-"},{"$f":"Y15*1/(1+$B$5)^W15","v":{"$error":"#VALUE!"}},{"$f":"I18","v":""},{"$f":"IF(AA15>0,1)","v":1},{"$f":"AA15","v":""}]
["Scenario #1 ",{"$nulls":13},"Thick HMA overlay",{"$nulls":6},{"$f":"A19","v":"-"},{"$f":"IF(V16<>\"-\",B19,0)","v":0},{"$f":"IF(V16<>\"-\",B19,0)","v":0},{"$f":"IF(V16<>\"-\",G19,0)","v":0},{"$f":"Y16*1/(1+$B$5)^W16","v":0},{"$f":"IF(V16<>\"-\",H19,0)","v":0},{"$f":"IF(W16<>\"-\",H19,0)","v":0},{"$f":"IF(AB16>0,2)","v":false},{"$f":"AB16","v":0}]
["Treatment Actions","Year (Ordinal)","Treatment","Unit Cost ","Unit","Quantity","Initial Cost","Treatment Service Life","Pavement Service Life ",{"$nulls":5},"User defined treatment 1 ","Check quantity entered",{"$nulls":5},"-",{"$f":"IF(V17<>\"-\",B20,0)","v":0},{"$f":"IF(V17<>\"-\",B20,0)","v":0},{"$f":"IF(V17<>\"-\",G20,0)","v":0},{"$f":"Y17*1/(1+$B$5)^W17","v":0},{"$f":"IF(V17<>\"-\",H20,0)","v":0},{"$f":"AA17*1/(1+$B$5)^Y17","v":0},{"$f":"IF(X17<>\"-\",H20,0)","v":0},{"$f":"IF(AC17>0,3)","v":false},0]
[{"$f":"IF(B8<>\"-\",1,\"-\")","v":"-"},{"$f":"IF(B8<>\"\",0,\"-\")","v":0},{"$f":"B8","v":"-"},"-","-",{"$f":"E8","v":"-"},"-",{"$f":"G8","v":0},{"$f":"V6","v":""},{"$nulls":5},"User defined treatment 2 ",{"$f":"IF(A18<>\"-\",IF(F18>0,\"True\"),\"True\")","v":"True"},{"$nulls":5},"-",0,0,0,0,0,{"$f":"AA18*1/(1+$B$5)^Y18","v":0},{"$f":"IF(X18<>\"-\",H21,0)","v":0},{"$f":"IF(AC18>0,4)","v":false},0]
[{"$f":"IF(OR($J$8=1,$J$8=2,$J$8=3,$J$8=4,$J$8=5),A18+1,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C19,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(C19,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C19,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(C19,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(E19=\"Lane mile\",'Project Information'!$B$12,IF(E19=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!E19=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},{"$f":"IFERROR(D19*F19,0)","v":0},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C19,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(C19,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},{"$f":"IF(H19>0,H19+I18,\"\")","v":""},{"$nulls":5},"User defined treatment 3 ",{"$f":"IF(A19<>\"-\",IF(F19>0,\"True\"),\"True\")","v":"True"},{"$nulls":5},"-",{"$f":"IF(V19<>\"-\",B22,0)","v":0},0,0,0,0,0,{"$f":"IF(X19<>\"-\",H22,0)","v":0},{"$f":"IF(AC19>0,5)","v":false},0]
[{"$f":"IF(OR($J$8=2,$J$8=3,$J$8=4,$J$8=5),A19+1,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C20,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(C20,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C20,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(C20,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(E20=\"Lane mile\",'Project Information'!$B$12,IF(E20=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!E20=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},{"$f":"IFERROR(D20*F20,0)","v":0},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C20,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(C20,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},{"$f":"IF(H20>0,H20+I19,\"\")","v":""},{"$nulls":6},"True",{"$nulls":5},"Total Service Life ",{"$nulls":4},{"$f":"MAX(I18:I22)","v":0},{"$f":"TRUNC(MAX(AB15:AB19),1)","v":1},{"$f":"IFERROR(AA20,\"-\")","v":0}]
[{"$f":"IF(OR($J$8=3,$J$8=4,$J$8=5),A20+1,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C21,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(C21,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C21,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(C21,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(E21=\"Lane mile\",'Project Information'!$B$12,IF(E21=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!E21=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},0,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C21,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(C21,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},"",{"$nulls":6},"True",{"$nulls":5},"Last Service Life ",{"$nulls":4},{"$f":"VLOOKUP(AB20,AB15:AC19,2,FALSE)","v":""}]
[{"$f":"IF(OR($J$8=4,$J$8=5),A21+1,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C22,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(C22,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C22,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(C22,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(E22=\"Lane mile\",'Project Information'!$B$12,IF(E22=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!E22=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},0,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C22,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(C22,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},"",{"$nulls":6},"True",{"$f":"IF(AND(P18=\"True\",P19=\"True\",P20=\"True\",P21=\"True\",P22=\"True\"),\"True\")","v":"True"},{"$nulls":4},"Total Initial Cost ",{"$nulls":4},{"$f":"Y15+Y16*(1/(1+$B$5)^W16)+Y17*(1/(1+$B$5)^W17)+Y18*(1/(1+$B$5)^W18)+Y19*(1/(1+$B$5)^W19)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(AA22,\"-\")","v":"-"}]
[{"$nulls":21},"EUAC",{"$nulls":4},{"$f":"-1*PMT($B$5,AA20,AA22)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(AA23,\"-\")","v":"-"}]
["Scenario #2 ",{"$nulls":20},"Annual Savings Compared to Do Nothing Scenario",{"$nulls":5},{"$f":"$Z$88-AB23","v":{"$error":"#VALUE!"}}]
["Treatment Actions","Year (Ordinal)","Treatment","Unit Cost ","Unit","Quantity","Initial Cost","Treatment Service Life","Pavement Service Life ",{"$nulls":12},"ROI",{"$nulls":5},{"$f":"AB24/AB23","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(AB25,\"-\")","v":"-"}]
[{"$f":"IF(B9<>\"-\",1,\"-\")","v":"-"},{"$f":"IF(B9<>\"\",0,\"-\")","v":0},{"$f":"B9","v":"-"},"-","-","-","-",0,{"$f":"V7","v":""},{"$nulls":12},"Scenario #2 "]
[{"$f":"IF(OR($J$9=1,$J$9=2,$J$9=3,$J$9=4,$J$9=5),A26+1,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C27,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(C27,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C27,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(C27,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(E27=\"Lane mile\",'Project Information'!$B$12,IF(E27=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!E27=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},{"$f":"IFERROR(D27*F27,0)","v":0},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C27,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(C27,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},{"$f":"IF(H27>0,H27+I26,\"\")","v":""},{"$nulls":12},"Treatment Actions","Year (Ordinal)","Treatment","Initial Cost","NPV Cost","Service Life","Index","Service Life"]
[{"$f":"IF(OR($J$9=2,$J$9=3,$J$9=4,$J$9=5),A27+1,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C28,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(C28,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C28,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(C28,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(E28=\"Lane mile\",'Project Information'!$B$12,IF(E28=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!E28=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},{"$f":"IFERROR(D28*F28,0)","v":0},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C28,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(C28,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},{"$f":"IF(H28>0,H28+I27,\"\")","v":""},{"$nulls":12},{"$f":"A26","v":"-"},{"$f":"B26","v":0},{"$f":"C26","v":"-"},{"$f":"G26","v":"-"},{"$f":"Y28*1/(1+$B$5)^W28","v":{"$error":"#VALUE!"}},{"$f":"I26","v":""},{"$f":"IF(AA28>0,1)","v":1},{"$f":"AA28","v":""}]
[{"$f":"IF(OR($J$9=3,$J$9=4,$J$9=5),A28+1,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C29,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(C29,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C29,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(C29,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(E29=\"Lane mile\",'Project Information'!$B$12,IF(E29=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!E29=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},0,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C29,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(C29,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},"",{"$nulls":12},{"$f":"A27","v":"-"},{"$f":"IF(V29<>\"-\",B27,0)","v":0},{"$f":"IF(V29<>\"-\",C27,0)","v":0},{"$f":"IF(V29<>\"-\",G27*((1+$B$5)^W29),0)","v":0},{"$f":"Y29*1/(1+$B$5)^W29","v":0},{"$f":"IF(V29<>\"-\",H27,0)","v":0},{"$f":"IF(AA29>0,2)","v":false},{"$f":"AA29","v":0}]
[{"$f":"IF(OR($J$9=4,$J$9=5),A29+1,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C30,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(C30,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C30,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(C30,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(E30=\"Lane mile\",'Project Information'!$B$12,IF(E30=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!E30=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},0,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C30,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(C30,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},"",{"$nulls":12},{"$f":"A28","v":"-"},{"$f":"IF(V30<>\"-\",B28,0)","v":0},{"$f":"IF(V30<>\"-\",C28,0)","v":0},{"$f":"IF(V30<>\"-\",G28*((1+$B$5)^W30),0)","v":0},{"$f":"Y30*1/(1+$B$5)^W30","v":0},{"$f":"IF(V30<>\"-\",H28,0)","v":0},{"$f":"IF(AA30>0,3)","v":false},0]
[{"$nulls":21},{"$f":"A29","v":"-"},{"$f":"IF(V31<>\"-\",B29,0)","v":0},{"$f":"IF(V31<>\"-\",C29,0)","v":0},{"$f":"IF(V31<>\"-\",G29*((1+$B$5)^W31),0)","v":0},{"$f":"Y31*1/(1+$B$5)^W31","v":0},{"$f":"IF(V31<>\"-\",H29,0)","v":0},{"$f":"IF(AA31>0,4)","v":false},0]
["Scenario #3 ",{"$nulls":20},{"$f":"A30","v":"-"},{"$f":"IF(V32<>\"-\",B30,0)","v":0},{"$f":"IF(V32<>\"-\",C30,0)","v":0},{"$f":"IF(V32<>\"-\",G30*((1+$B$5)^W32),0)","v":0},0,{"$f":"IF(V32<>\"-\",H30,0)","v":0},{"$f":"IF(AA32>0,5)","v":false},0]
["Treatment Actions","Year (Ordinal)","Treatment","Unit Cost ","Unit","Quantity","Initial Cost","Treatment Service Life","Pavement Service Life ",{"$nulls":6},"Check quantity entered",{"$nulls":5},"Total Service Life ",null,null,null,{"$f":"MAX(I26:I30)","v":0},{"$f":"TRUNC(MAX(AB28:AB32),1)","v":1},null,{"$f":"IFERROR(Z33,\"-\")","v":0}]
[{"$f":"IF(B10<>\"-\",1,\"-\")","v":"-"},{"$f":"IF(B10<>\"\",0,\"-\")","v":0},{"$f":"B10","v":"-"},"-","-",{"$f":"E10","v":"-"},"-",0,{"$f":"V8","v":""},{"$nulls":6},{"$f":"IF(A34<>\"-\",IF(F34>0,\"True\"),\"True\")","v":"True"},{"$nulls":5},"Last Service Life ",{"$nulls":4},{"$f":"VLOOKUP(AA33,AB28:AC32,2,FALSE)","v":""}]
[{"$f":"IF(OR($J$10=1,$J$10=2,$J$10=3,$J$10=4,$J$10=5),A34+1,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C35,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(C35,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C35,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(C35,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(E35=\"Lane mile\",'Project Information'!$B$12,IF(E35=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!E35=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},{"$f":"IFERROR(D35*F35,0)","v":0},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C35,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(C35,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},{"$f":"IF(H35>0,H35+I34,\"\")","v":""},{"$nulls":6},{"$f":"IF(A35<>\"-\",IF(F35>0,\"True\"),\"True\")","v":"True"},{"$nulls":5},"Total Initial Cost ",{"$nulls":4},{"$f":"Y28+Y29*(1/(1+$B$5)^W29)+Y30*(1/(1+$B$5)^W30)+Y31*(1/(1+$B$5)^W31)+Y32*(1/(1+$B$5)^W32)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(AA35,\"-\")","v":"-"}]
[{"$f":"IF(OR($J$10=2,$J$10=3,$J$10=4,$J$10=5),A35+1,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C36,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(C36,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C36,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(C36,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(E36=\"Lane mile\",'Project Information'!$B$12,IF(E36=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!E36=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},{"$f":"IFERROR(D36*F36,0)","v":0},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C36,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(C36,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},{"$f":"IF(H36>0,H36+I35,\"\")","v":""},{"$nulls":6},"True",{"$nulls":5},"EUAC",{"$nulls":4},{"$f":"-1*PMT($B$5,Z33,AA35)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(AA36,\"-\")","v":"-"}]
[{"$f":"IF(OR($J$10=3,$J$10=4,$J$10=5),A36+1,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C37,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(C37,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C37,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(C37,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(E37=\"Lane mile\",'Project Information'!$B$12,IF(E37=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!E37=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},0,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C37,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(C37,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},"",{"$nulls":6},"True",{"$nulls":5},"Annual Savings Compared to Do Nothing Scenario",{"$nulls":5},{"$f":"$Z$88-AB36","v":{"$error":"#VALUE!"}}]
[{"$f":"IF(OR($J$10=4,$J$10=5),A37+1,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C38,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(C38,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C38,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(C38,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(E38=\"Lane mile\",'Project Information'!$B$12,IF(E38=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!E38=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},0,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C38,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(C38,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},"",{"$nulls":6},"True",{"$f":"IF(AND(P34=\"True\",P35=\"True\",P36=\"True\",P37=\"True\",P38=\"True\"),\"True\")","v":"True"},{"$nulls":4},"ROI",{"$nulls":5},{"$f":"AB37/AB36","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(AB38,\"-\")","v":"-"}]
[{"$nulls":21},"Scenario #3"]
["Scenario #4 ",{"$nulls":20},"Treatment Actions","Year (Ordinal)","Treatment","Initial Cost","NPV Cost","Service Life","Index","Service Life"]
["Treatment Actions","Year (Ordinal)","Treatment","Unit Cost ","Unit","Quantity","Initial Cost","Treatment Service Life","Pavement Service Life ",{"$nulls":6},"Check quantity entered",{"$nulls":5},{"$f":"A34","v":"-"},{"$f":"B34","v":0},{"$f":"C34","v":"-"},{"$f":"G34","v":"-"},{"$f":"Y41*1/(1+$B$5)^W41","v":{"$error":"#VALUE!"}},{"$f":"I34","v":""},{"$f":"IF(AA41>0,1)","v":1},{"$f":"AA41","v":""}]
[{"$f":"IF(B11<>\"-\",1,\"-\")","v":"-"},{"$f":"IF(B11<>\"\",0,\"-\")","v":0},{"$f":"B11","v":"-"},"-","-","-","-",0,{"$f":"V9","v":""},{"$nulls":6},{"$f":"IF(A42<>\"-\",IF(F42>0,\"True\"),\"True\")","v":"True"},{"$nulls":5},{"$f":"A35","v":"-"},{"$f":"IF(V42<>\"-\",A35,0)","v":0},{"$f":"IF(V42<>\"-\",C35,0)","v":0},{"$f":"IF(V42<>\"-\",G35*((1+$B$5)^W42),0)","v":0},{"$f":"Y42*1/(1+$B$5)^W42","v":0},{"$f":"IF(V42<>\"-\",H35,0)","v":0},{"$f":"IF(AA42>0,2)","v":false},{"$f":"AA42","v":0}]
[{"$f":"IF(OR($J$11=1,$J$11=2,$J$11=3,$J$11=4,$J$11=5),A42+1,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C43,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(C43,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C43,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(C43,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(E43=\"Lane mile\",'Project Information'!$B$12,IF(E43=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!E43=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},{"$f":"IFERROR(D43*F43,0)","v":0},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C43,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(C43,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},{"$f":"IF(H43>0,H43+I42,\"\")","v":""},{"$nulls":6},{"$f":"IF(A43<>\"-\",IF(F43>0,\"True\"),\"True\")","v":"True"},{"$nulls":5},{"$f":"A36","v":"-"},{"$f":"IF(V43<>\"-\",A36,0)","v":0},{"$f":"IF(V43<>\"-\",C36,0)","v":0},{"$f":"IF(V43<>\"-\",G36*((1+$B$5)^W43),0)","v":0},0,{"$f":"IF(V43<>\"-\",H36,0)","v":0},{"$f":"IF(AA43>0,3)","v":false},0]
[{"$f":"IF(OR($J$11=2,$J$11=3,$J$11=4,$J$11=5),A43+1,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C44,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(C44,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C44,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(C44,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(E44=\"Lane mile\",'Project Information'!$B$12,IF(E44=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!E44=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},{"$f":"IFERROR(D44*F44,0)","v":0},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C44,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(C44,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},{"$f":"IF(H44>0,H44+I43,\"\")","v":""},{"$nulls":6},"True",{"$nulls":5},{"$f":"A37","v":"-"},{"$f":"IF(V44<>\"-\",A37,0)","v":0},{"$f":"IF(V44<>\"-\",C37,0)","v":0},{"$f":"IF(V44<>\"-\",G37*((1+$B$5)^W44),0)","v":0},0,{"$f":"IF(V44<>\"-\",H37,0)","v":0},{"$f":"IF(AA44>0,4)","v":false},0]
[{"$f":"IF(OR($J$11=3,$J$11=4,$J$11=5),A44+1,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C45,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(C45,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C45,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(C45,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(E45=\"Lane mile\",'Project Information'!$B$12,IF(E45=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!E45=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},0,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C45,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(C45,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},"",{"$nulls":6},"True",{"$nulls":5},{"$f":"A38","v":"-"},{"$f":"IF(V45<>\"-\",A38,0)","v":0},{"$f":"IF(V45<>\"-\",C38,0)","v":0},{"$f":"IF(V45<>\"-\",G38*((1+$B$5)^W45),0)","v":0},0,{"$f":"IF(V45<>\"-\",H38,0)","v":0},{"$f":"IF(AA45>0,5)","v":false},0]
[{"$f":"IF(OR($J$11=4,$J$11=5),A45+1,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C46,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(C46,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C46,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(C46,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(E46=\"Lane mile\",'Project Information'!$B$12,IF(E46=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!E46=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},0,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C46,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(C46,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},"",{"$nulls":6},"True",{"$f":"IF(AND(P42=\"True\",P43=\"True\",P44=\"True\",P45=\"True\",P46=\"True\"),\"True\")","v":"True"},{"$nulls":4},"Total Service Life ",null,null,null,{"$f":"MAX(I34:I38)","v":0},{"$f":"TRUNC(MAX(AB41:AB45),1)","v":1},null,{"$f":"IFERROR(Z46,\"-\")","v":0}]
[{"$nulls":21},"Last Service Life ",{"$nulls":4},{"$f":"VLOOKUP(AA46,AB41:AC45,2,FALSE)","v":""}]
[{"$nulls":21},"Total Initial Cost ",{"$nulls":4},{"$f":"Y41+Y42*(1/(1+$B$5)^W42)+Y43*(1/(1+$B$5)^W43)+Y44*(1/(1+$B$5)^W44)+Y45*(1/(1+$B$5)^W45)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(AA48,\"-\")","v":"-"}]
["Scenario #5",{"$nulls":20},"EUAC",{"$nulls":4},{"$f":"-1*PMT($B$5,Z46,AA48)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(AA49,\"-\")","v":"-"}]
["Treatment Actions","Year (Ordinal)","Treatment","Unit Cost ","Unit","Quantity","Initial Cost","Treatment Service Life","Pavement Service Life ",{"$nulls":6},"Check quantity entered",{"$nulls":5},"Annual Savings Compared to Do Nothing Scenario",{"$nulls":5},{"$f":"$Z$88-AB49","v":{"$error":"#VALUE!"}}]
[{"$f":"IF(B12<>\"-\",1,\"-\")","v":"-"},{"$f":"IF(B12<>\"\",0,\"-\")","v":0},{"$f":"B12","v":"-"},"-","-","-","-",0,{"$f":"V10","v":""},{"$nulls":6},{"$f":"IF(A51<>\"-\",IF(F51>0,\"True\"),\"True\")","v":"True"},{"$nulls":5},"ROI",{"$nulls":5},{"$f":"AB50/AB49","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(AB51,\"-\")","v":"-"}]
[{"$f":"IF(OR($J$12=1,$J$12=2,$J$12=3,$J$12=4,$J$12=5),A51+1,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C52,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(C52,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C52,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(C52,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(E52=\"Lane mile\",'Project Information'!$B$12,IF(E52=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!E52=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},{"$f":"IFERROR(D52*F52,0)","v":0},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C52,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(C52,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},{"$f":"IF(H52>0,H52+I51,\"\")","v":""},{"$nulls":6},{"$f":"IF(A52<>\"-\",IF(F52>0,\"True\"),\"True\")","v":"True"},{"$nulls":5},"Scenario #4"]
[{"$f":"IF(OR($J$12=2,$J$12=3,$J$12=4,$J$12=5),A52+1,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C53,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(C53,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C53,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(C53,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(E53=\"Lane mile\",'Project Information'!$B$12,IF(E53=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!E53=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},{"$f":"IFERROR(D53*F53,0)","v":0},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C53,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(C53,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},{"$f":"IF(H53>0,H53+I52,\"\")","v":""},{"$nulls":6},"True",{"$nulls":5},"Treatment Actions","Year (Ordinal)","Treatment","Initial Cost","NPV Cost","Service Life","Index","Service Life"]
[{"$f":"IF(OR($J$12=3,$J$12=4,$J$12=5),A53+1,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C54,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(C54,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C54,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(C54,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(E54=\"Lane mile\",'Project Information'!$B$12,IF(E54=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!E54=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},0,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C54,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(C54,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},"",{"$nulls":6},"True",{"$nulls":5},{"$f":"A42","v":"-"},{"$f":"B42","v":0},{"$f":"C42","v":"-"},{"$f":"G42","v":"-"},{"$f":"Y54*1/(1+$B$5)^W54","v":{"$error":"#VALUE!"}},{"$f":"I42","v":""},{"$f":"IF(AA54>0,1)","v":1},{"$f":"AA54","v":""}]
[{"$f":"IF(OR($J$12=4,$J$12=5),A54+1,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C55,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(C55,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C55,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(C55,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(E55=\"Lane mile\",'Project Information'!$B$12,IF(E55=\"LF\",'Project Information'!$B$14+'Project Information'!$B$15,IF('EUAC and ROI'!E55=\"SY\",'Project Information'!$B$13,\"-\")))","v":"-"},0,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C55,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(C55,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},"",{"$nulls":6},"True",{"$f":"IF(AND(P51=\"True\",P52=\"True\",P53=\"True\",P54=\"True\",P55=\"True\"),\"True\")","v":"True"},{"$nulls":4},{"$f":"A43","v":"-"},{"$f":"IF(V55<>\"-\",B43,0)","v":0},{"$f":"IF(V55<>\"-\",C43,0)","v":0},{"$f":"IF(V55<>\"-\",G43*((1+$B$5)^W55),0)","v":0},{"$f":"Y55*1/(1+$B$5)^W55","v":0},{"$f":"IF(V55<>\"-\",H43,0)","v":0},{"$f":"IF(AA55>0,2)","v":false},{"$f":"AA55","v":0}]
[{"$nulls":21},{"$f":"A44","v":"-"},{"$f":"IF(V56<>\"-\",B44,0)","v":0},{"$f":"IF(V56<>\"-\",C44,0)","v":0},{"$f":"IF(V56<>\"-\",G44*((1+$B$5)^W56),0)","v":0},0,{"$f":"IF(V56<>\"-\",H44,0)","v":0},{"$f":"IF(AA56>0,3)","v":false},0]
[{"$nulls":21},{"$f":"A45","v":"-"},{"$f":"IF(V57<>\"-\",B45,0)","v":0},{"$f":"IF(V57<>\"-\",C45,0)","v":0},{"$f":"IF(V57<>\"-\",G45*((1+$B$5)^W57),0)","v":0},0,{"$f":"IF(V57<>\"-\",H45,0)","v":0},{"$f":"IF(AA57>0,4)","v":false},0]
["Scenario #6 Do Nothing",{"$nulls":20},{"$f":"A46","v":"-"},{"$f":"IF(V58<>\"-\",B46,0)","v":0},{"$f":"IF(V58<>\"-\",C46,0)","v":0},{"$f":"IF(V58<>\"-\",G46*((1+$B$5)^W58),0)","v":0},0,{"$f":"IF(V58<>\"-\",H46,0)","v":0},{"$f":"IF(AA58>0,5)","v":false},0]
["Treatment Actions","Year (Ordinal)","Treatment","Unit Cost ","Unit","Quantity","Initial Cost","Treatment Service Life","Pavement Service Life ",{"$nulls":6},"Check quantity entered",{"$nulls":5},"Total Service Life ",null,null,null,{"$f":"MAX(I42:I46)","v":0},{"$f":"TRUNC(MAX(AB54:AB58),1)","v":1},null,{"$f":"IFERROR(Z59,\"-\")","v":0}]
[{"$f":"IF(B13<>\"-\",1,\"-\")","v":1},{"$f":"B4","v":0},{"$f":"B13","v":"Planned Reconstruction/Rehab"},575000,"Lane mile",0,0,40,{"$f":"V11","v":40},{"$nulls":6},{"$f":"IF(A60<>\"-\",IF(F60>0,\"True\"),\"True\")","v":false},{"$nulls":5},"Last Service Life ",{"$nulls":4},{"$f":"VLOOKUP(AA59,AB54:AC58,2,FALSE)","v":""}]
[{"$f":"IF(OR($J$13=1,$J$13=2,$J$13=3,$J$13=4,$J$13=5),A60+1,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C61,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(C61,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C61,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(C61,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(E61=\"Lane mile\",'Project Information'!$B$12,IF('EUAC and ROI'!E61=\"SY\",'Project Information'!$B$13,\"-\"))","v":"-"},{"$f":"IFERROR(D61*F61,0)","v":0},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C61,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(C61,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},{"$f":"IF(H61>0,H61+I60,\"\")","v":""},{"$nulls":6},{"$f":"IF(A61<>\"-\",IF(F61>0,\"True\"),\"True\")","v":"True"},{"$nulls":5},"Total Initial Cost ",{"$nulls":4},{"$f":"Y54+Y55*(1/(1+$B$5)^W55)+Y56*(1/(1+$B$5)^W56)+Y57*(1/(1+$B$5)^W57)+Y58*(1/(1+$B$5)^W58)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(AA61,\"-\")","v":"-"}]
[{"$f":"IF(OR($J$13=2,$J$13=3,$J$13=4,$J$13=5),A61+1,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C62,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(C62,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C62,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(C62,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(E62=\"Lane mile\",'Project Information'!$B$12,IF('EUAC and ROI'!E62=\"SY\",'Project Information'!$B$13,\"-\"))","v":"-"},{"$f":"IFERROR(D62*F62,0)","v":0},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C62,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(C62,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},{"$f":"IF(H62>0,H62+I61,\"\")","v":""},{"$nulls":6},"True",{"$nulls":5},"EUAC",{"$nulls":4},{"$f":"-1*PMT($B$5,Z59,AA61)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(AA62,\"-\")","v":"-"}]
[{"$f":"IF(OR($J$13=3,$J$13=4,$J$13=5),A62+1,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C63,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(C63,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C63,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(C63,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(E63=\"Lane mile\",'Project Information'!$B$12,IF('EUAC and ROI'!E63=\"SY\",'Project Information'!$B$13,\"-\"))","v":"-"},0,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C63,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(C63,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},"",{"$nulls":6},"True",{"$nulls":5},"Annual Savings Compared to Do Nothing Scenario",{"$nulls":5},{"$f":"$Z$88-AB62","v":{"$error":"#VALUE!"}}]
[{"$f":"IF(OR($J$13=4,$J$13=5),A63+1,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C64,'AC Treatments Data'!$A$1:$D$31,3,FALSE),VLOOKUP(C64,'PCC Treatments Data'!$A$1:$D$31,3,FALSE)),\"-\")","v":"-"},{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C64,'AC Treatments Data'!$A$1:$D$31,4,FALSE),VLOOKUP(C64,'PCC Treatments Data'!$A$1:$D$31,4,FALSE)),\"-\")","v":"-"},{"$f":"IF(E64=\"Lane mile\",'Project Information'!$B$12,IF('EUAC and ROI'!E64=\"SY\",'Project Information'!$B$13,\"-\"))","v":"-"},0,{"$f":"IFERROR(IF($B$3=\"AC\",VLOOKUP(C64,'AC Treatments Data'!$A$1:$D$31,2,FALSE),VLOOKUP(C64,'PCC Treatments Data'!$A$1:$D$31,2,FALSE)),0)","v":0},"",{"$nulls":6},"True",{"$f":"IF(AND(P60=\"True\",P61=\"True\",P62=\"True\",P63=\"True\",P64=\"True\"),\"True\")","v":false},{"$nulls":4},"ROI",{"$nulls":5},{"$f":"AB63/AB62","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(AB64,\"-\")","v":"-"}]
[{"$nulls":19},"Scenario #5"]
[{"$nulls":19},"Treatment Actions","Year (Ordinal)","Treatment","Initial Cost","NPV Cost","Service Life","Index","Service Life"]
[{"$nulls":19},{"$f":"A51","v":"-"},{"$f":"B51","v":0},{"$f":"C51","v":"-"},{"$f":"G51","v":"-"},{"$f":"W67*1/(1+$B$5)^U67","v":{"$error":"#VALUE!"}},{"$f":"I51","v":""},{"$f":"IF(Y67>0,1)","v":1},{"$f":"Y67","v":""}]
[{"$nulls":19},{"$f":"A52","v":"-"},{"$f":"IF(T68<>\"-\",B52,0)","v":0},{"$f":"IF(T68<>\"-\",C52,0)","v":0},{"$f":"IF(T68<>\"-\",G52*((1+$B$5)^U68),0)","v":0},{"$f":"W68*1/(1+$B$5)^U68","v":0},{"$f":"IF(T68<>\"-\",H52,0)","v":0},{"$f":"IF(Y68>0,2)","v":false},{"$f":"Y68","v":0}]
[{"$nulls":19},"-",{"$f":"IF(T69<>\"-\",B53,0)","v":0},{"$f":"IF(T69<>\"-\",C53,0)","v":0},{"$f":"IF(T69<>\"-\",G53*((1+$B$5)^U69),0)","v":0},0,{"$f":"IF(T69<>\"-\",H53,0)","v":0},{"$f":"IF(Y69>0,3)","v":false},0]
[{"$nulls":19},"-",{"$f":"IF(T70<>\"-\",B54,0)","v":0},{"$f":"IF(T70<>\"-\",C54,0)","v":0},{"$f":"IF(T70<>\"-\",G54*((1+$B$5)^U70),0)","v":0},0,{"$f":"IF(T70<>\"-\",H54,0)","v":0},{"$f":"IF(Y70>0,4)","v":false},0]
[{"$nulls":19},"-",{"$f":"IF(T71<>\"-\",B55,0)","v":0},{"$f":"IF(T71<>\"-\",C55,0)","v":0},{"$f":"IF(T71<>\"-\",G55*((1+$B$5)^U71),0)","v":0},0,{"$f":"IF(T71<>\"-\",H55,0)","v":0},{"$f":"IF(Y71>0,5)","v":false},0]
[{"$nulls":19},"Total Service Life ",null,null,null,{"$f":"MAX(I51:I55)","v":0},{"$f":"TRUNC(MAX(Z67:Z71),1)","v":1},null,{"$f":"IFERROR(X72,\"-\")","v":0}]
[{"$nulls":19},"Last Service Life ",{"$nulls":4},{"$f":"VLOOKUP(Y72,Z67:AA71,2,FALSE)","v":""}]
[{"$nulls":19},"Total Initial Cost ",{"$nulls":4},{"$f":"W67+W68*(1/(1+$B$5)^U68)+W69*(1/(1+$B$5)^U69)+W70*(1/(1+$B$5)^U70)+W71*(1/(1+$B$5)^U71)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(Y74,\"-\")","v":"-"}]
[{"$nulls":19},"EUAC",{"$nulls":4},{"$f":"-1*PMT($B$5,X72,Y74)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(Y75,\"-\")","v":"-"}]
[{"$nulls":19},"Annual Savings Compared to Do Nothing Scenario",{"$nulls":5},{"$f":"$Z$88-Z75","v":{"$error":"#VALUE!"}}]
[{"$nulls":19},"ROI",{"$nulls":5},{"$f":"Z76/Z75","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(Z77,\"-\")","v":"-"}]
[{"$nulls":19},"Scenario #6 Do Nothing"]
[{"$nulls":19},"Treatment Actions","Year (Ordinal)","Treatment","Initial Cost","NPV Cost","Service Life","Index","Service Life"]
[{"$nulls":19},{"$f":"A60","v":1},{"$f":"B60","v":0},{"$f":"C60","v":"Planned Reconstruction/Rehab"},{"$f":"G60","v":0},{"$f":"W80*1/(1+$B$5)^U80","v":0},{"$f":"I60","v":40},{"$f":"IF(Y80>0,1)","v":1},{"$f":"Y80","v":40}]
[{"$nulls":19},{"$f":"A61","v":"-"},{"$f":"IF(T81<>\"-\",B61,0)","v":0},{"$f":"IF(T81<>\"-\",C61,0)","v":0},{"$f":"IF(T81<>\"-\",G61*((1+$B$5)^U81),0)","v":0},{"$f":"W81*1/(1+$B$5)^U81","v":0},{"$f":"IF(T81<>\"-\",H61,0)","v":0},{"$f":"IF(Y81>0,2)","v":false},{"$f":"Y81","v":0}]
[{"$nulls":19},"-",{"$f":"IF(T82<>\"-\",B62,0)","v":0},{"$f":"IF(T82<>\"-\",C62,0)","v":0},{"$f":"IF(T82<>\"-\",G62*((1+$B$5)^U82),0)","v":0},0,{"$f":"IF(T82<>\"-\",H62,0)","v":0},{"$f":"IF(Y82>0,3)","v":false},0]
[{"$nulls":19},"-",{"$f":"IF(T83<>\"-\",B63,0)","v":0},{"$f":"IF(T83<>\"-\",C63,0)","v":0},{"$f":"IF(T83<>\"-\",G63*((1+$B$5)^U83),0)","v":0},0,{"$f":"IF(T83<>\"-\",H63,0)","v":0},{"$f":"IF(Y83>0,4)","v":false},0]
[{"$nulls":19},"-",{"$f":"IF(T84<>\"-\",B64,0)","v":0},{"$f":"IF(T84<>\"-\",C64,0)","v":0},{"$f":"IF(T84<>\"-\",G64*((1+$B$5)^U84),0)","v":0},0,{"$f":"IF(T84<>\"-\",H64,0)","v":0},{"$f":"IF(Y84>0,5)","v":false},0]
[{"$nulls":19},"Total Service Life ",null,null,null,{"$f":"MAX(I60:I64)","v":40},{"$f":"TRUNC(MAX(Z80:Z84),1)","v":1},null,{"$f":"IFERROR(X85,\"-\")","v":40}]
[{"$nulls":19},"Last Service Life ",{"$nulls":4},{"$f":"VLOOKUP(Y85,Z80:AA84,2,FALSE)","v":40}]
[{"$nulls":19},"Total Initial Cost ",{"$nulls":4},{"$f":"W80+W81*(1/(1+$B$5)^U81)+W82*(1/(1+$B$5)^U82)+W83*(1/(1+$B$5)^U83)+W84*(1/(1+$B$5)^U84)","v":0},{"$f":"IFERROR(Y87,\"-\")","v":0}]
[{"$nulls":19},"EUAC",{"$nulls":4},{"$f":"-1*PMT($B$5,X85,Y87)","v":0},{"$f":"IFERROR(Y88,\"-\")","v":0}]
[{"$nulls":19},"Annual Savings Compared to Do Nothing Scenario",{"$nulls":5},{"$f":"$Z$88-Z88","v":0}]
[{"$nulls":19},"ROI"]

{"sheet":"Treatment Ranking I","index":7,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[7,0,9,5],[10,0,10,5],[0,0,0,1]]}
["Potential Action",null,"EUAC ","ROI","EUAC Score","ROI Score","Rank",null,null,"Yes"]
["Action #1 ",{"$f":"'EUAC and ROI'!B8","v":"-"},{"$f":"'EUAC and ROI'!AB23","v":"-"},{"$f":"'EUAC and ROI'!AC25","v":"-"},{"$f":"IFERROR(IF(C2=MIN($C$2:$C$6),10,10*(MIN($C$2:$C$6)/C2)),\"-\")","v":"-"},{"$f":"IFERROR(IF(D2=MAX($D$2:$D$6),10,10*D2/(MAX($D$2:$D$6))),\"-\")","v":"-"},{"$f":"IF(B2<>\"-\",RANK(F2,$F$2:$F$6),\"-\")","v":"-"},null,null,"No",{"$f":"IF(A11=\"Yes\", \"Weights Assignment\",\"Cost Summary Sheet\")","v":"Cost Summary Sheet"}]
["Action #2",{"$f":"'EUAC and ROI'!B9","v":"-"},{"$f":"'EUAC and ROI'!AB36","v":"-"},{"$f":"'EUAC and ROI'!AC38","v":"-"},{"$f":"IFERROR(IF(C3=MIN($C$2:$C$6),10,10*(MIN($C$2:$C$6)/C3)),\"-\")","v":"-"},{"$f":"IFERROR(IF(D3=MAX($D$2:$D$6),10,10*D3/(MAX($D$2:$D$6))),\"-\")","v":"-"},{"$f":"IF(B3<>\"-\",RANK(F3,$F$2:$F$6),\"-\")","v":"-"}]
["Action #3",{"$f":"'EUAC and ROI'!B10","v":"-"},{"$f":"'EUAC and ROI'!AB49","v":"-"},{"$f":"'EUAC and ROI'!AC51","v":"-"},"-","-",{"$f":"IF(B4<>\"-\",RANK(F4,$F$2:$F$6),\"-\")","v":"-"}]
["Action #4",{"$f":"'EUAC and ROI'!B11","v":"-"},{"$f":"'EUAC and ROI'!AB62","v":"-"},{"$f":"'EUAC and ROI'!AC64","v":"-"},"-","-",{"$f":"IF(B5<>\"-\",RANK(F5,$F$2:$F$6),\"-\")","v":"-"}]
["Action #5",{"$f":"'EUAC and ROI'!B12","v":"-"},{"$f":"'EUAC and ROI'!Z75","v":"-"},{"$f":"'EUAC and ROI'!AA77","v":"-"},"-","-",{"$f":"IF(B6<>\"-\",RANK(F6,$F$2:$F$6),\"-\")","v":"-"}]
[]
["Would you like to consider other selection criteria such as user satisfaction and environmental sustainability?"]
[]
["Yes"]

{"sheet":"Cost Summary Sheet","index":8,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
[{"$f":"'Treatment Ranking I'!A1:B1","v":"Potential Action"},null,{"$f":"'Treatment Ranking I'!C1","v":"EUAC "},{"$f":"'Treatment Ranking I'!D1","v":"ROI"},{"$f":"'Treatment Ranking I'!E1","v":"EUAC Score"},{"$f":"'Treatment Ranking I'!F1","v":"ROI Score"},{"$f":"'Treatment Ranking I'!G1","v":"Rank"}]
[{"$f":"'Treatment Ranking I'!A2","v":"Action #1 "},{"$f":"'Treatment Ranking I'!B2","v":"-"},{"$f":"'Treatment Ranking I'!C2","v":"-"},{"$f":"'Treatment Ranking I'!D2","v":"-"},{"$f":"'Treatment Ranking I'!E2","v":"-"},{"$f":"'Treatment Ranking I'!F2","v":"-"},{"$f":"'Treatment Ranking I'!G2","v":"-"}]
[{"$f":"'Treatment Ranking I'!A3","v":"Action #2"},{"$f":"'Treatment Ranking I'!B3","v":"-"},{"$f":"'Treatment Ranking I'!C3","v":"-"},{"$f":"'Treatment Ranking I'!D3","v":"-"},{"$f":"'Treatment Ranking I'!E3","v":"-"},{"$f":"'Treatment Ranking I'!F3","v":"-"},{"$f":"'Treatment Ranking I'!G3","v":"-"}]
[{"$f":"'Treatment Ranking I'!A4","v":"Action #3"},{"$f":"'Treatment Ranking I'!B4","v":"-"},{"$f":"'Treatment Ranking I'!C4","v":"-"},{"$f":"'Treatment Ranking I'!D4","v":"-"},{"$f":"'Treatment Ranking I'!E4","v":"-"},{"$f":"'Treatment Ranking I'!F4","v":"-"},{"$f":"'Treatment Ranking I'!G4","v":"-"}]
[{"$f":"'Treatment Ranking I'!A5","v":"Action #4"},{"$f":"'Treatment Ranking I'!B5","v":"-"},{"$f":"'Treatment Ranking I'!C5","v":"-"},{"$f":"'Treatment Ranking I'!D5","v":"-"},{"$f":"'Treatment Ranking I'!E5","v":"-"},{"$f":"'Treatment Ranking I'!F5","v":"-"},{"$f":"'Treatment Ranking I'!G5","v":"-"}]
[{"$f":"'Treatment Ranking I'!A6","v":"Action #5"},{"$f":"'Treatment Ranking I'!B6","v":"-"},{"$f":"'Treatment Ranking I'!C6","v":"-"},{"$f":"'Treatment Ranking I'!D6","v":"-"},{"$f":"'Treatment Ranking I'!E6","v":"-"},{"$f":"'Treatment Ranking I'!F6","v":"-"},{"$f":"'Treatment Ranking I'!G6","v":"-"}]

{"sheet":"Weights Assignment","index":9,"n_rows":5,"n_cols":17,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,2,5],[3,0,3,5]]}
["Would you like to assign selection parameters weights manually or use AHP to calculate the selection parameters weights?",{"$nulls":11},"Manual Assignment",null,null,"Pavement Type"]
[{"$nulls":12},"AHP ",null,null,{"$f":"'Project Information'!B9","v":0},{"$f":"IF(P2=\"AC\",\"AC Surface Pavements\", \"PCC Surface Pavements\")","v":"PCC Surface Pavements"}]
[{"$nulls":16},"Treatment Ranking I"]
[{"$nulls":12},{"$f":"IF(A4=M1,M1,IF(A4=M2,\"Weighting Parameters\"))","v":false}]
[{"$nulls":12},{"$f":"A4","v":0}]

{"sheet":"Manual Assignment","index":10,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,3,0],[4,0,7,0],[8,0,9,0],[11,0,11,1]]}
["Category ","Selection Criteria","Average Global Weight"]
["Performance","Pavement Structure Improvement"]
[null,"Performance Under Heavy Traffic Loading"]
[null,"Performance Under Average Daily Traffic"]
["User Satisfaction","Facility Downtime"]
[null,"Impact on Roughness"]
[null,"Impact on Friction"]
[null,"Noise"]
["Procurement and Contracts","Availability of Qualified Contractors"]
[null,"Availability of Quality Materials"]
["Environmental Sustainability","Negative Environmental Impact"]
["Sum of Weights",null,{"$f":"SUM(C2:C11)","v":0},{"$f":"IF(C12=100%,\"Scoring Sheet\")","v":false}]

{"sheet":"Weighting Parameters 2","index":11,"n_rows":81,"n_cols":22,"rows_kept":81,"cut":false,"hidden":false,"merged":[[0,0,1,5],[12,0,13,5],[33,0,34,5],[47,19,47,20],[22,0,23,5],[33,16,37,16],[25,16,30,16],[19,16,24,16],[74,8,77,8],[78,8,79,8],[38,19,38,20],[40,16,44,16],[71,8,73,8]]}
["1. High Level Weighing Process"]
[]
["Category",{"$f":"A4","v":"Performance"},{"$f":"A5","v":"Procurement and Contracts"},{"$f":"A6","v":"Environmental Sustainability"},{"$f":"A7","v":"User Satisfaction"},null,"Scale"]
["Performance",{"$nulls":6},"Level of Importance","Yes"]
["Procurement and Contracts",{"$nulls":5},"Equally important (1)",1,"No"]
["Environmental Sustainability",{"$nulls":5},"Equally to moderately (2)",2,{"$f":"IF(AND(B40=I4,C37<>\"\",B9=\"Consistent\",B20=\"Consistent\",B31=\"Consistent\"),\"Weighting Parameters 3\",IF(B40=I5,\"Scoring Sheet\"))","v":false}]
["User Satisfaction",{"$nulls":5},"Moderately important (3)",3,{"$f":"IF(B40=\"Yes\",3,2)","v":2}]
[{"$nulls":6},"Moderately to strongly importance (4)",4]
["Overall Consistency",{"$f":"IFERROR(T32,\"-\")","v":"-"},{"$f":"IF(B9=\"Consistent\",\"\",\"Review pair wise comparison\")","v":"Review pair wise comparison"},null,null,null,"Strongly important (5)",5]
[{"$nulls":6},"Strongly to very strong importance (6)",6]
[{"$nulls":6},"Very strong importance (7)",7]
[{"$nulls":6},"Very strong to extremely important (8)",8]
["1.1 Performance Parameters Weighing Process",{"$nulls":5},"Extremely important (9)",9]
[{"$nulls":6},"R-Equally to moderately (1/2)",{"$f":"1/H6","v":0.5}]
[null,{"$f":"A16","v":"Pavement Structure Improvement"},{"$f":"A17","v":"Performance Under Heavy Traffic Loading"},{"$f":"A18","v":"Performance Under Average Daily Traffic"},null,null,"R-Moderately important (1/3)",0.33333333333333331]
["Pavement Structure Improvement",{"$nulls":5},"R-Moderately to strongly importance (1/4)",0.25]
["Performance Under Heavy Traffic Loading",{"$nulls":5},"R-Strongly important (1/5)",0.2]
["Performance Under Average Daily Traffic",{"$nulls":5},"R-Strongly to very strong importance (1/6)",0.16666666666666666]
[{"$nulls":6},"R-Very strong importance (1/7)",0.14285714285714285]
["Overall Consistency",{"$f":"IFERROR(T39,\"-\")","v":"-"},{"$f":"IF(B20=\"Consistent\",\"\",\"Review pair wise comparison\")","v":"Review pair wise comparison"},null,null,null,"R-Very strong to extremely important (1/8)",0.125,null,{"$f":"I21","v":"Performance"},{"$f":"I22","v":"Procurement and Contracts"},{"$f":"I23","v":"Environmental Sustainability"},{"$f":"I24","v":"User Satisfaction"},null,null,null,"Check Transitivity",null,{"$f":"R21","v":"Performance "},{"$f":"R22","v":"Procurement and Contracts "},{"$f":"R23","v":"Weather Limitations and Sustainability"},{"$f":"R24","v":"User Satisfaction"}]
[{"$nulls":6},"R-Extremely important (1/9)",0.1111111111111111,"Performance",1,{"$f":"VLOOKUP(C4,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D4,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E4,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},"Performance ",null,null,{"$f":"IF(K21>1,IF(L22>1, IF(L21>1,\"True\",\"False\"),\"True\"),\"True\")","v":{"$error":"#N/A"}},{"$f":"IF(L21>1,IF(M23>1,IF(M21>1,\"True\",\"False\"),\"True\"),\"True\")","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Procurement and Contracts",{"$f":"1/K21","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(D5,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E5,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},"Procurement and Contracts ",null,null,null,{"$f":"IF(L22>1,IF(M23>1,IF(M22>1,\"True\",\"False\"),\"True\"),\"True\")","v":{"$error":"#N/A"}}]
["1.2 User Satisfaction Parameters Weighing Process",{"$nulls":7},"Environmental Sustainability",{"$f":"1/L21","v":{"$error":"#N/A"}},{"$f":"1/L22","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(E6,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},"Weather Limitations and Sustainability"]
[{"$nulls":8},"User Satisfaction",{"$f":"1/M21","v":{"$error":"#N/A"}},{"$f":"1/M22","v":{"$error":"#N/A"}},{"$f":"1/M23","v":{"$error":"#N/A"}},1,{"$nulls":4},"User Satisfaction"]
[null,{"$f":"A26","v":"Facility Downtime"},{"$f":"A27","v":"Impact on Roughness"},{"$f":"A28","v":"Impact of Friction"},{"$f":"A29","v":"Noise"},{"$nulls":4},{"$f":"I26","v":"Performance"},{"$f":"I27","v":"Procurement and Contracts"},{"$f":"I28","v":"Environmental Sustainability"},{"$f":"I29","v":"User Satisfaction"}]
["Facility Downtime",{"$nulls":7},"Performance",{"$f":"J21/SUM($J$21:$J$24)","v":{"$error":"#N/A"}},{"$f":"K21/SUM($K$21:$K$24)","v":{"$error":"#N/A"}},{"$f":"L21/SUM($L$21:$L$24)","v":{"$error":"#N/A"}},{"$f":"M21/SUM($M$21:$M$24)","v":{"$error":"#N/A"}},"Column Vector ","Weights",null,"Check Consistency ","Performance",{"$f":"MMULT(J21:M21,$O$27:$O$30)/O27","v":{"$error":"#N/A"}}]
["Impact on Roughness",{"$nulls":7},"Procurement and Contracts",{"$f":"J22/SUM($J$21:$J$24)","v":{"$error":"#N/A"}},{"$f":"K22/SUM($K$21:$K$24)","v":{"$error":"#N/A"}},{"$f":"L22/SUM($L$21:$L$24)","v":{"$error":"#N/A"}},{"$f":"M22/SUM($M$21:$M$24)","v":{"$error":"#N/A"}},{"$f":"SUM(J26:M26)","v":{"$error":"#N/A"}},{"$f":"N27/$O$31","v":{"$error":"#N/A"}},null,null,"Procurement and Contracts",{"$f":"MMULT(J22:M22,$O$27:$O$30)/O28","v":{"$error":"#N/A"}}]
["Impact of Friction",{"$nulls":7},"Environmental Sustainability",{"$f":"J23/SUM($J$21:$J$24)","v":{"$error":"#N/A"}},{"$f":"K23/SUM($K$21:$K$24)","v":{"$error":"#N/A"}},{"$f":"L23/SUM($L$21:$L$24)","v":{"$error":"#N/A"}},{"$f":"M23/SUM($M$21:$M$24)","v":{"$error":"#N/A"}},{"$f":"SUM(J27:M27)","v":{"$error":"#N/A"}},{"$f":"N28/$O$31","v":{"$error":"#N/A"}},null,null,"Weather Limitations and Sustainability",{"$f":"MMULT(J23:M23,$O$27:$O$30)/O29","v":{"$error":"#N/A"}}]
["Noise",{"$nulls":7},"User Satisfaction",{"$f":"J24/SUM($J$21:$J$24)","v":{"$error":"#N/A"}},{"$f":"K24/SUM($K$21:$K$24)","v":{"$error":"#N/A"}},{"$f":"L24/SUM($L$21:$L$24)","v":{"$error":"#N/A"}},{"$f":"M24/SUM($M$21:$M$24)","v":{"$error":"#N/A"}},{"$f":"SUM(J28:M28)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,"User Satisfaction",{"$f":"MMULT(J24:M24,$O$27:$O$30)/O30","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Sum",{"$f":"SUM(J26:J29)","v":{"$error":"#N/A"}},{"$f":"SUM(K26:K29)","v":{"$error":"#N/A"}},{"$f":"SUM(L26:L29)","v":{"$error":"#N/A"}},{"$f":"SUM(M26:M29)","v":{"$error":"#N/A"}},{"$f":"SUM(J29:M29)","v":{"$error":"#N/A"}},{"$f":"N30/$O$31","v":{"$error":"#N/A"}},null,null,"CI",{"$f":"(AVERAGE(S26:S29)-4)/(4-1)","v":{"$error":"#N/A"}}]
["Overall Consistency",{"$f":"IFERROR(T48,\"-\")","v":"-"},{"$f":"IF(B31=\"Consistent\",\"\",\"Review pair wise comparison\")","v":"Review pair wise comparison"},{"$nulls":11},{"$f":"SUM(J30:M30)","v":{"$error":"#N/A"}},null,null,"RI",1.1200000000000001]
[{"$nulls":15},{"$f":"SUM(O27:O30)","v":{"$error":"#N/A"}},null,"CR",{"$f":"S30/S31","v":{"$error":"#N/A"}},{"$f":"IF(S32>0.1,\"Non Consistent\",\"Consistent\")","v":{"$error":"#N/A"}}]
[]
["1.3 Procurement and Contracts Parameters Weighing Process",{"$nulls":8},{"$f":"I35","v":"Structure improvement"},{"$f":"I36","v":"Heavy Traffic Loading"},{"$f":"I37","v":"ADT"},{"$nulls":4},"Check Consistency ","Structure improvement",{"$f":"MMULT(J35:L35,$N$40:$N$42)/N40","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Structure improvement",1,{"$f":"VLOOKUP(C16,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D16,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$nulls":5},"Heavy Traffic Loading",{"$f":"MMULT(J36:L36,$N$40:$N$42)/N41","v":{"$error":"#N/A"}}]
[null,{"$f":"A37","v":"Availability of Qualified Contractors"},{"$f":"A38","v":"Availability of Quality Materials"},{"$nulls":5},"Heavy Traffic Loading",{"$f":"1/K35","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(D17,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$nulls":5},"ADT",{"$f":"MMULT(J37:L37,$N$40:$N$42)/N42","v":{"$error":"#N/A"}}]
["Availability of Qualified Contractors",{"$nulls":7},"ADT",{"$f":"1/L35","v":{"$error":"#N/A"}},{"$f":"1/L36","v":{"$error":"#N/A"}},1,{"$nulls":5},"CI",{"$f":"(AVERAGE(S34:S36)-3)/(3-1)","v":{"$error":"#N/A"}}]
["Availability of Quality Materials",{"$nulls":8},{"$f":"I39","v":"Structure improvement"},{"$f":"I40","v":"Heavy Traffic Loading"},{"$f":"I41","v":"ADT"},{"$nulls":5},"RI",0.9]
[{"$nulls":8},"Structure improvement",{"$f":"J35/SUM($J$35:$J$37)","v":{"$error":"#N/A"}},{"$f":"K35/SUM($K$35:$K$37)","v":{"$error":"#N/A"}},{"$f":"L35/SUM($L$35:$L$37)","v":{"$error":"#N/A"}},"Column Vector ","Weights",null,null,null,"CR",{"$f":"S37/S38","v":{"$error":"#N/A"}},{"$f":"IF(S39>0.1,\"Non Consistent\",\"Consistent\")","v":{"$error":"#N/A"}}]
["Is there another user input?",{"$nulls":7},"Heavy Traffic Loading",{"$f":"J36/SUM($J$35:$J$37)","v":{"$error":"#N/A"}},{"$f":"K36/SUM($K$35:$K$37)","v":{"$error":"#N/A"}},{"$f":"L36/SUM($L$35:$L$37)","v":{"$error":"#N/A"}},{"$f":"SUM(J39:L39)","v":{"$error":"#N/A"}},{"$f":"M40/$N$43","v":{"$error":"#N/A"}}]
[{"$nulls":8},"ADT",{"$f":"J37/SUM($J$35:$J$37)","v":{"$error":"#N/A"}},{"$f":"K37/SUM($K$35:$K$37)","v":{"$error":"#N/A"}},{"$f":"L37/SUM($L$35:$L$37)","v":{"$error":"#N/A"}},{"$f":"SUM(J40:L40)","v":{"$error":"#N/A"}},{"$f":"M41/$N$43","v":{"$error":"#N/A"}},null,null,"Check Consistency "]
[{"$nulls":8},"Sum",{"$f":"SUM(J39:J41)","v":{"$error":"#N/A"}},{"$f":"SUM(K39:K41)","v":{"$error":"#N/A"}},{"$f":"SUM(L39:L41)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"M42/$N$43","v":{"$error":"#N/A"}},null,null,null,"Facility Downtime",{"$f":"MMULT(J47:M47,$O$52:$O$55)/O52","v":{"$error":"#N/A"}}]
[{"$nulls":13},{"$f":"SUM(J42:L42)","v":{"$error":"#N/A"}},null,null,null,"Impact on Roughness",{"$f":"MMULT(J48:M48,O52:O55)/O53","v":{"$error":"#N/A"}}]
[{"$nulls":17},"Impact of Friction",{"$f":"MMULT(J49:M49,O52:O55)/O54","v":{"$error":"#N/A"}}]
[{"$nulls":17},"Noise",{"$f":"MMULT(J50:M50,O52:O55)/O55","v":{"$error":"#N/A"}}]
[{"$nulls":9},{"$f":"I47","v":"Facility Downtime"},{"$f":"I48","v":"Impact on Roughness"},{"$f":"I49","v":"Impact of Friction"},{"$f":"I50","v":"Noise"},{"$nulls":4},"CI",{"$f":"(AVERAGE(S42:S45)-4)/(4-1)","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Facility Downtime",1,{"$f":"VLOOKUP(C26,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D26,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E26,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},"RI",0.9]
[{"$nulls":8},"Impact on Roughness",{"$f":"1/K47","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(D27,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E27,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},"CR",{"$f":"S46/S47","v":{"$error":"#N/A"}},{"$f":"IF(S48>0.1,\"Non Consistent\",\"Consistent\")","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Impact of Friction",{"$f":"1/L47","v":{"$error":"#N/A"}},{"$f":"1/L48","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(E28,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Noise",{"$f":"1/M47","v":{"$error":"#N/A"}},{"$f":"1/M48","v":{"$error":"#N/A"}},{"$f":"1/M49","v":{"$error":"#N/A"}},1]
[{"$nulls":9},{"$f":"I52","v":"Facility Downtime"},{"$f":"I53","v":"Impact on Roughness"},{"$f":"I54","v":"Impact of Friction"},{"$f":"I55","v":"Noise"},null,"Weights"]
[{"$nulls":8},"Facility Downtime",{"$f":"J47/SUM($J$47:$J$50)","v":{"$error":"#N/A"}},{"$f":"K47/SUM($K$47:$K$50)","v":{"$error":"#N/A"}},{"$f":"L47/SUM($L$47:$L$50)","v":{"$error":"#N/A"}},{"$f":"M47/SUM($M$47:$M$50)","v":{"$error":"#N/A"}},"Column Vector ",{"$f":"N53/$N$57","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Impact on Roughness",{"$f":"J48/SUM($J$47:$J$50)","v":{"$error":"#N/A"}},{"$f":"K48/SUM($K$47:$K$50)","v":{"$error":"#N/A"}},{"$f":"L48/SUM($L$47:$L$50)","v":{"$error":"#N/A"}},{"$f":"M48/SUM($M$47:$M$50)","v":{"$error":"#N/A"}},{"$f":"SUM(J52:M52)","v":{"$error":"#N/A"}},{"$f":"N54/$N$57","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Impact of Friction",{"$f":"J49/SUM($J$47:$J$50)","v":{"$error":"#N/A"}},{"$f":"K49/SUM($K$47:$K$50)","v":{"$error":"#N/A"}},{"$f":"L49/SUM($L$47:$L$50)","v":{"$error":"#N/A"}},{"$f":"M49/SUM($M$47:$M$50)","v":{"$error":"#N/A"}},{"$f":"SUM(J53:M53)","v":{"$error":"#N/A"}},{"$f":"N55/$N$57","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Noise",{"$f":"J50/SUM($J$47:$J$50)","v":{"$error":"#N/A"}},{"$f":"K50/SUM($K$47:$K$50)","v":{"$error":"#N/A"}},{"$f":"L50/SUM($L$47:$L$50)","v":{"$error":"#N/A"}},{"$f":"M50/SUM($M$47:$M$50)","v":{"$error":"#N/A"}},{"$f":"SUM(J54:M54)","v":{"$error":"#N/A"}},{"$f":"N56/$N$57","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Sum",{"$f":"SUM(J52:J55)","v":{"$error":"#N/A"}},{"$f":"SUM(K52:K55)","v":{"$error":"#N/A"}},{"$f":"SUM(L52:L55)","v":{"$error":"#N/A"}},{"$f":"SUM(M52:M55)","v":{"$error":"#N/A"}},{"$f":"SUM(J55:M55)","v":{"$error":"#N/A"}},{"$f":"SUM(O52:O55)","v":{"$error":"#N/A"}}]
[{"$nulls":13},{"$f":"SUM(J56:M56)","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[{"$nulls":9},{"$f":"I63","v":"Qualified Contractors"},{"$f":"I64","v":"Quality Materials"}]
[{"$nulls":8},"Qualified Contractors",1,{"$f":"VLOOKUP(C37,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Quality Materials",{"$f":"1/K63","v":{"$error":"#N/A"}},1]
[{"$nulls":9},{"$f":"I66","v":"Qualified Contractors"},{"$f":"I67","v":"Quality Materials"},"Column Vector ","Weights"]
[{"$nulls":8},"Qualified Contractors",{"$f":"J63/SUM($J$63:$J$64)","v":{"$error":"#N/A"}},{"$f":"K63/SUM($K$63:$K$64)","v":{"$error":"#N/A"}},{"$f":"SUM(J66:K66)","v":{"$error":"#N/A"}},{"$f":"L66/$L$68","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Quality Materials",{"$f":"J64/SUM($J$63:$J$64)","v":{"$error":"#N/A"}},{"$f":"K64/SUM($K$63:$K$64)","v":{"$error":"#N/A"}},{"$f":"SUM(J67:K67)","v":{"$error":"#N/A"}},{"$f":"L67/$L$68","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Sum",{"$f":"SUM(J66:J67)","v":{"$error":"#N/A"}},{"$f":"SUM(K66:K67)","v":{"$error":"#N/A"}},{"$f":"SUM(J68:K68)","v":{"$error":"#N/A"}},{"$f":"SUM(M66:M67)","v":{"$error":"#N/A"}}]
[]
[]
[{"$nulls":8},"Category ","Selection Criteria","Average Global Weight"]
[{"$nulls":8},"Performance","Pavement Structure Improvement",{"$f":"$O$27*N40","v":{"$error":"#N/A"}}]
[{"$nulls":9},"Performance Under Heavy Traffic Loading",{"$f":"$O$27*N41","v":{"$error":"#N/A"}}]
[{"$nulls":9},"Performance Under Average Daily Traffic",{"$error":"#N/A"}]
[{"$nulls":8},"User Satisfaction","Facility Downtime",{"$f":"$O$30*O52","v":{"$error":"#N/A"}}]
[{"$nulls":9},"Impact on Roughness",{"$f":"$O$30*O53","v":{"$error":"#N/A"}}]
[{"$nulls":9},"Impact on Friction",{"$error":"#N/A"}]
[{"$nulls":9},"Noise",{"$f":"$O$30*O55","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Procurement and Contracts","Availability of Qualified Contractors",{"$f":"$O$28*M66","v":{"$error":"#N/A"}}]
[{"$nulls":9},"Availability of Quality Materials",{"$f":"$O$28*M67","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Environmental Sustainability","Negative Environmental Impact",{"$f":"O29","v":{"$error":"#N/A"}}]

{"sheet":"Weighting Parameters","index":12,"n_rows":81,"n_cols":22,"rows_kept":81,"cut":false,"hidden":false,"merged":[[74,8,77,8],[78,8,79,8],[33,0,34,5],[33,16,37,16],[38,19,38,20],[40,16,44,16],[47,19,47,20],[0,0,1,5],[12,0,13,5],[22,0,23,5],[71,8,73,8],[19,16,24,16],[25,16,30,16]]}
["1. High Level Weighing Process"]
[]
["Category",{"$f":"A4","v":"Performance"},{"$f":"A5","v":"Procurement and Contracts"},{"$f":"A6","v":"Environmental Sustainability"},{"$f":"A7","v":"User Satisfaction"},null,"Scale"]
["Performance",{"$nulls":6},"Level of Importance","Yes"]
["Procurement and Contracts",{"$nulls":5},"Equally important (1)",1,"No"]
["Environmental Sustainability",{"$nulls":5},"Equally to moderately (2)",2,{"$f":"IF(AND(B40=I4,C37<>\"\",B9=\"Consistent\",B20=\"Consistent\",B31=\"Consistent\"),\"Weighting Parameters 2\",IF(B40=I5,\"Scoring Sheet\"))","v":false}]
["User Satisfaction",{"$nulls":5},"Moderately important (3)",3,{"$f":"IF(B40=\"Yes\",3,2)","v":2}]
[{"$nulls":6},"Moderately to strongly importance (4)",4]
["Overall Consistency",{"$f":"IFERROR(T32,\"-\")","v":"-"},{"$f":"IF(B9=\"Consistent\",\"\",\"Review pair wise comparison\")","v":"Review pair wise comparison"},null,null,null,"Strongly important (5)",5]
[{"$nulls":6},"Strongly to very strong importance (6)",6]
[{"$nulls":6},"Very strong importance (7)",7]
[{"$nulls":6},"Very strong to extremely important (8)",8]
["1.1 Performance Parameters Weighing Process",{"$nulls":5},"Extremely important (9)",9]
[{"$nulls":6},"R-Equally to moderately (1/2)",{"$f":"1/H6","v":0.5}]
[null,{"$f":"A16","v":"Pavement Structure Improvement"},{"$f":"A17","v":"Performance Under Heavy Traffic Loading"},{"$f":"A18","v":"Performance Under Average Daily Traffic"},null,null,"R-Moderately important (1/3)",0.33333333333333331]
["Pavement Structure Improvement",{"$nulls":5},"R-Moderately to strongly importance (1/4)",0.25]
["Performance Under Heavy Traffic Loading",{"$nulls":5},"R-Strongly important (1/5)",0.2]
["Performance Under Average Daily Traffic",{"$nulls":5},"R-Strongly to very strong importance (1/6)",0.16666666666666666]
[{"$nulls":6},"R-Very strong importance (1/7)",0.14285714285714285]
["Overall Consistency",{"$f":"IFERROR(T39,\"-\")","v":"-"},{"$f":"IF(B20=\"Consistent\",\"\",\"Review pair wise comparison\")","v":"Review pair wise comparison"},null,null,null,"R-Very strong to extremely important (1/8)",0.125,null,{"$f":"I21","v":"Performance"},{"$f":"I22","v":"Procurement and Contracts"},{"$f":"I23","v":"Environmental Sustainability"},{"$f":"I24","v":"User Satisfaction"},null,null,null,"Check Transitivity",null,{"$f":"R21","v":"Performance "},{"$f":"R22","v":"Procurement and Contracts "},{"$f":"R23","v":"Weather Limitations and Sustainability"},{"$f":"R24","v":"User Satisfaction"}]
[{"$nulls":6},"R-Extremely important (1/9)",0.1111111111111111,"Performance",1,{"$f":"VLOOKUP(C4,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D4,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E4,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},"Performance ",null,null,{"$f":"IF(K21>1,IF(L22>1, IF(L21>1,\"True\",\"False\"),\"True\"),\"True\")","v":{"$error":"#N/A"}},{"$f":"IF(L21>1,IF(M23>1,IF(M21>1,\"True\",\"False\"),\"True\"),\"True\")","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Procurement and Contracts",{"$f":"1/K21","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(D5,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E5,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},"Procurement and Contracts ",null,null,null,{"$f":"IF(L22>1,IF(M23>1,IF(M22>1,\"True\",\"False\"),\"True\"),\"True\")","v":{"$error":"#N/A"}}]
["1.2 User Satisfaction Parameters Weighing Process",{"$nulls":7},"Environmental Sustainability",{"$f":"1/L21","v":{"$error":"#N/A"}},{"$f":"1/L22","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(E6,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},"Weather Limitations and Sustainability"]
[{"$nulls":8},"User Satisfaction",{"$f":"1/M21","v":{"$error":"#N/A"}},{"$f":"1/M22","v":{"$error":"#N/A"}},{"$f":"1/M23","v":{"$error":"#N/A"}},1,{"$nulls":4},"User Satisfaction"]
[null,{"$f":"A26","v":"Facility Downtime"},{"$f":"A27","v":"Impact on Roughness"},{"$f":"A28","v":"Impact of Friction"},{"$f":"A29","v":"Noise"},{"$nulls":4},{"$f":"I26","v":"Performance"},{"$f":"I27","v":"Procurement and Contracts"},{"$f":"I28","v":"Environmental Sustainability"},{"$f":"I29","v":"User Satisfaction"}]
["Facility Downtime",{"$nulls":7},"Performance",{"$f":"J21/SUM($J$21:$J$24)","v":{"$error":"#N/A"}},{"$f":"K21/SUM($K$21:$K$24)","v":{"$error":"#N/A"}},{"$f":"L21/SUM($L$21:$L$24)","v":{"$error":"#N/A"}},{"$f":"M21/SUM($M$21:$M$24)","v":{"$error":"#N/A"}},"Column Vector ","Weights",null,"Check Consistency ","Performance",{"$f":"MMULT(J21:M21,$O$27:$O$30)/O27","v":{"$error":"#N/A"}}]
["Impact on Roughness",{"$nulls":7},"Procurement and Contracts",{"$f":"J22/SUM($J$21:$J$24)","v":{"$error":"#N/A"}},{"$f":"K22/SUM($K$21:$K$24)","v":{"$error":"#N/A"}},{"$f":"L22/SUM($L$21:$L$24)","v":{"$error":"#N/A"}},{"$f":"M22/SUM($M$21:$M$24)","v":{"$error":"#N/A"}},{"$f":"SUM(J26:M26)","v":{"$error":"#N/A"}},{"$f":"N27/$O$31","v":{"$error":"#N/A"}},null,null,"Procurement and Contracts",{"$f":"MMULT(J22:M22,$O$27:$O$30)/O28","v":{"$error":"#N/A"}}]
["Impact of Friction",{"$nulls":7},"Environmental Sustainability",{"$f":"J23/SUM($J$21:$J$24)","v":{"$error":"#N/A"}},{"$f":"K23/SUM($K$21:$K$24)","v":{"$error":"#N/A"}},{"$f":"L23/SUM($L$21:$L$24)","v":{"$error":"#N/A"}},{"$f":"M23/SUM($M$21:$M$24)","v":{"$error":"#N/A"}},{"$f":"SUM(J27:M27)","v":{"$error":"#N/A"}},{"$f":"N28/$O$31","v":{"$error":"#N/A"}},null,null,"Weather Limitations and Sustainability",{"$f":"MMULT(J23:M23,$O$27:$O$30)/O29","v":{"$error":"#N/A"}}]
["Noise",{"$nulls":7},"User Satisfaction",{"$f":"J24/SUM($J$21:$J$24)","v":{"$error":"#N/A"}},{"$f":"K24/SUM($K$21:$K$24)","v":{"$error":"#N/A"}},{"$f":"L24/SUM($L$21:$L$24)","v":{"$error":"#N/A"}},{"$f":"M24/SUM($M$21:$M$24)","v":{"$error":"#N/A"}},{"$f":"SUM(J28:M28)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,"User Satisfaction",{"$f":"MMULT(J24:M24,$O$27:$O$30)/O30","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Sum",{"$f":"SUM(J26:J29)","v":{"$error":"#N/A"}},{"$f":"SUM(K26:K29)","v":{"$error":"#N/A"}},{"$f":"SUM(L26:L29)","v":{"$error":"#N/A"}},{"$f":"SUM(M26:M29)","v":{"$error":"#N/A"}},{"$f":"SUM(J29:M29)","v":{"$error":"#N/A"}},{"$f":"N30/$O$31","v":{"$error":"#N/A"}},null,null,"CI",{"$f":"(AVERAGE(S26:S29)-4)/(4-1)","v":{"$error":"#N/A"}}]
["Overall Consistency",{"$f":"IFERROR(T48,\"-\")","v":"-"},{"$f":"IF(B31=\"Consistent\",\"\",\"Review pair wise comparison\")","v":"Review pair wise comparison"},{"$nulls":11},{"$f":"SUM(J30:M30)","v":{"$error":"#N/A"}},null,null,"RI",1.1200000000000001]
[{"$nulls":15},{"$f":"SUM(O27:O30)","v":{"$error":"#N/A"}},null,"CR",{"$f":"S30/S31","v":{"$error":"#N/A"}},{"$f":"IF(S32>0.1,\"Non Consistent\",\"Consistent\")","v":{"$error":"#N/A"}}]
[]
["1.3 Procurement and Contracts Parameters Weighing Process",{"$nulls":8},{"$f":"I35","v":"Structure improvement"},{"$f":"I36","v":"Heavy Traffic Loading"},{"$f":"I37","v":"ADT"},{"$nulls":4},"Check Consistency ","Structure improvement",{"$f":"MMULT(J35:L35,$N$40:$N$42)/N40","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Structure improvement",1,{"$f":"VLOOKUP(C16,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D16,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$nulls":5},"Heavy Traffic Loading",{"$f":"MMULT(J36:L36,$N$40:$N$42)/N41","v":{"$error":"#N/A"}}]
[null,{"$f":"A37","v":"Availability of Qualified Contractors"},{"$f":"A38","v":"Availability of Quality Materials"},{"$nulls":5},"Heavy Traffic Loading",{"$f":"1/K35","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(D17,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$nulls":5},"ADT",{"$f":"MMULT(J37:L37,$N$40:$N$42)/N42","v":{"$error":"#N/A"}}]
["Availability of Qualified Contractors",{"$nulls":7},"ADT",{"$f":"1/L35","v":{"$error":"#N/A"}},{"$f":"1/L36","v":{"$error":"#N/A"}},1,{"$nulls":5},"CI",{"$f":"(AVERAGE(S34:S36)-3)/(3-1)","v":{"$error":"#N/A"}}]
["Availability of Quality Materials",{"$nulls":8},{"$f":"I39","v":"Structure improvement"},{"$f":"I40","v":"Heavy Traffic Loading"},{"$f":"I41","v":"ADT"},{"$nulls":5},"RI",0.9]
[{"$nulls":8},"Structure improvement",{"$f":"J35/SUM($J$35:$J$37)","v":{"$error":"#N/A"}},{"$f":"K35/SUM($K$35:$K$37)","v":{"$error":"#N/A"}},{"$f":"L35/SUM($L$35:$L$37)","v":{"$error":"#N/A"}},"Column Vector ","Weights",null,null,null,"CR",{"$f":"S37/S38","v":{"$error":"#N/A"}},{"$f":"IF(S39>0.1,\"Non Consistent\",\"Consistent\")","v":{"$error":"#N/A"}}]
["Is there another user input?",{"$nulls":7},"Heavy Traffic Loading",{"$f":"J36/SUM($J$35:$J$37)","v":{"$error":"#N/A"}},{"$f":"K36/SUM($K$35:$K$37)","v":{"$error":"#N/A"}},{"$f":"L36/SUM($L$35:$L$37)","v":{"$error":"#N/A"}},{"$f":"SUM(J39:L39)","v":{"$error":"#N/A"}},{"$f":"M40/$N$43","v":{"$error":"#N/A"}}]
[{"$nulls":8},"ADT",{"$f":"J37/SUM($J$35:$J$37)","v":{"$error":"#N/A"}},{"$f":"K37/SUM($K$35:$K$37)","v":{"$error":"#N/A"}},{"$f":"L37/SUM($L$35:$L$37)","v":{"$error":"#N/A"}},{"$f":"SUM(J40:L40)","v":{"$error":"#N/A"}},{"$f":"M41/$N$43","v":{"$error":"#N/A"}},null,null,"Check Consistency "]
[{"$nulls":8},"Sum",{"$f":"SUM(J39:J41)","v":{"$error":"#N/A"}},{"$f":"SUM(K39:K41)","v":{"$error":"#N/A"}},{"$f":"SUM(L39:L41)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"M42/$N$43","v":{"$error":"#N/A"}},null,null,null,"Facility Downtime",{"$f":"MMULT(J47:M47,$O$52:$O$55)/O52","v":{"$error":"#N/A"}}]
[{"$nulls":13},{"$f":"SUM(J42:L42)","v":{"$error":"#N/A"}},null,null,null,"Impact on Roughness",{"$f":"MMULT(J48:M48,O52:O55)/O53","v":{"$error":"#N/A"}}]
[{"$nulls":17},"Impact of Friction",{"$f":"MMULT(J49:M49,O52:O55)/O54","v":{"$error":"#N/A"}}]
[{"$nulls":17},"Noise",{"$f":"MMULT(J50:M50,O52:O55)/O55","v":{"$error":"#N/A"}}]
[{"$nulls":9},{"$f":"I47","v":"Facility Downtime"},{"$f":"I48","v":"Impact on Roughness"},{"$f":"I49","v":"Impact of Friction"},{"$f":"I50","v":"Noise"},{"$nulls":4},"CI",{"$f":"(AVERAGE(S42:S45)-4)/(4-1)","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Facility Downtime",1,{"$f":"VLOOKUP(C26,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D26,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E26,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},"RI",0.9]
[{"$nulls":8},"Impact on Roughness",{"$f":"1/K47","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(D27,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E27,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},"CR",{"$f":"S46/S47","v":{"$error":"#N/A"}},{"$f":"IF(S48>0.1,\"Non Consistent\",\"Consistent\")","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Impact of Friction",{"$f":"1/L47","v":{"$error":"#N/A"}},{"$f":"1/L48","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(E28,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Noise",{"$f":"1/M47","v":{"$error":"#N/A"}},{"$f":"1/M48","v":{"$error":"#N/A"}},{"$f":"1/M49","v":{"$error":"#N/A"}},1]
[{"$nulls":9},{"$f":"I52","v":"Facility Downtime"},{"$f":"I53","v":"Impact on Roughness"},{"$f":"I54","v":"Impact of Friction"},{"$f":"I55","v":"Noise"},null,"Weights"]
[{"$nulls":8},"Facility Downtime",{"$f":"J47/SUM($J$47:$J$50)","v":{"$error":"#N/A"}},{"$f":"K47/SUM($K$47:$K$50)","v":{"$error":"#N/A"}},{"$f":"L47/SUM($L$47:$L$50)","v":{"$error":"#N/A"}},{"$f":"M47/SUM($M$47:$M$50)","v":{"$error":"#N/A"}},"Column Vector ",{"$f":"N53/$N$57","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Impact on Roughness",{"$f":"J48/SUM($J$47:$J$50)","v":{"$error":"#N/A"}},{"$f":"K48/SUM($K$47:$K$50)","v":{"$error":"#N/A"}},{"$f":"L48/SUM($L$47:$L$50)","v":{"$error":"#N/A"}},{"$f":"M48/SUM($M$47:$M$50)","v":{"$error":"#N/A"}},{"$f":"SUM(J52:M52)","v":{"$error":"#N/A"}},{"$f":"N54/$N$57","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Impact of Friction",{"$f":"J49/SUM($J$47:$J$50)","v":{"$error":"#N/A"}},{"$f":"K49/SUM($K$47:$K$50)","v":{"$error":"#N/A"}},{"$f":"L49/SUM($L$47:$L$50)","v":{"$error":"#N/A"}},{"$f":"M49/SUM($M$47:$M$50)","v":{"$error":"#N/A"}},{"$f":"SUM(J53:M53)","v":{"$error":"#N/A"}},{"$f":"N55/$N$57","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Noise",{"$f":"J50/SUM($J$47:$J$50)","v":{"$error":"#N/A"}},{"$f":"K50/SUM($K$47:$K$50)","v":{"$error":"#N/A"}},{"$f":"L50/SUM($L$47:$L$50)","v":{"$error":"#N/A"}},{"$f":"M50/SUM($M$47:$M$50)","v":{"$error":"#N/A"}},{"$f":"SUM(J54:M54)","v":{"$error":"#N/A"}},{"$f":"N56/$N$57","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Sum",{"$f":"SUM(J52:J55)","v":{"$error":"#N/A"}},{"$f":"SUM(K52:K55)","v":{"$error":"#N/A"}},{"$f":"SUM(L52:L55)","v":{"$error":"#N/A"}},{"$f":"SUM(M52:M55)","v":{"$error":"#N/A"}},{"$f":"SUM(J55:M55)","v":{"$error":"#N/A"}},{"$f":"SUM(O52:O55)","v":{"$error":"#N/A"}}]
[{"$nulls":13},{"$f":"SUM(J56:M56)","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[{"$nulls":9},{"$f":"I63","v":"Qualified Contractors"},{"$f":"I64","v":"Quality Materials"}]
[{"$nulls":8},"Qualified Contractors",1,{"$f":"VLOOKUP(C37,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Quality Materials",{"$f":"1/K63","v":{"$error":"#N/A"}},1]
[{"$nulls":9},{"$f":"I66","v":"Qualified Contractors"},{"$f":"I67","v":"Quality Materials"},"Column Vector ","Weights"]
[{"$nulls":8},"Qualified Contractors",{"$f":"J63/SUM($J$63:$J$64)","v":{"$error":"#N/A"}},{"$f":"K63/SUM($K$63:$K$64)","v":{"$error":"#N/A"}},{"$f":"SUM(J66:K66)","v":{"$error":"#N/A"}},{"$f":"L66/$L$68","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Quality Materials",{"$f":"J64/SUM($J$63:$J$64)","v":{"$error":"#N/A"}},{"$f":"K64/SUM($K$63:$K$64)","v":{"$error":"#N/A"}},{"$f":"SUM(J67:K67)","v":{"$error":"#N/A"}},{"$f":"L67/$L$68","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Sum",{"$f":"SUM(J66:J67)","v":{"$error":"#N/A"}},{"$f":"SUM(K66:K67)","v":{"$error":"#N/A"}},{"$f":"SUM(J68:K68)","v":{"$error":"#N/A"}},{"$f":"SUM(M66:M67)","v":{"$error":"#N/A"}}]
[]
[]
[{"$nulls":8},"Category ","Selection Criteria","Average Global Weight"]
[{"$nulls":8},"Performance","Pavement Structure Improvement",{"$f":"$O$27*N40","v":{"$error":"#N/A"}}]
[{"$nulls":9},"Performance Under Heavy Traffic Loading",{"$f":"$O$27*N41","v":{"$error":"#N/A"}}]
[{"$nulls":9},"Performance Under Average Daily Traffic",{"$error":"#N/A"}]
[{"$nulls":8},"User Satisfaction","Facility Downtime",{"$f":"$O$30*O52","v":{"$error":"#N/A"}}]
[{"$nulls":9},"Impact on Roughness",{"$f":"$O$30*O53","v":{"$error":"#N/A"}}]
[{"$nulls":9},"Impact on Friction",{"$error":"#N/A"}]
[{"$nulls":9},"Noise",{"$f":"$O$30*O55","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Procurement and Contracts","Availability of Qualified Contractors",{"$f":"$O$28*M66","v":{"$error":"#N/A"}}]
[{"$nulls":9},"Availability of Quality Materials",{"$f":"$O$28*M67","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Environmental Sustainability","Negative Environmental Impact",{"$f":"O29","v":{"$error":"#N/A"}}]

{"sheet":"Weighting Parameters 3","index":13,"n_rows":81,"n_cols":22,"rows_kept":81,"cut":false,"hidden":false,"merged":[[38,19,38,20],[40,16,44,16],[47,19,47,20],[0,0,1,5],[12,0,13,5],[19,16,24,16],[22,0,23,5],[25,16,30,16],[71,8,73,8],[74,8,77,8],[78,8,79,8],[33,0,34,5],[33,16,37,16]]}
["1. High Level Weighing Process"]
[]
["Category",{"$f":"A4","v":"Performance"},{"$f":"A5","v":"Procurement and Contracts"},{"$f":"A6","v":"Environmental Sustainability"},{"$f":"A7","v":"User Satisfaction"},null,"Scale"]
["Performance",{"$nulls":6},"Level of Importance"]
["Procurement and Contracts",{"$nulls":5},"Equally important (1)",1]
["Environmental Sustainability",{"$nulls":5},"Equally to moderately (2)",2]
["User Satisfaction",{"$nulls":5},"Moderately important (3)",3,{"$f":"IF(AND(C37<>\"\",B9=\"Consistent\",B20=\"Consistent\",B31=\"Consistent\"),\"Scoring Sheet\")","v":false}]
[{"$nulls":6},"Moderately to strongly importance (4)",4]
["Overall Consistency",{"$f":"IFERROR(T32,\"-\")","v":"-"},{"$f":"IF(B9=\"Consistent\",\"\",\"Review pair wise comparison\")","v":"Review pair wise comparison"},null,null,null,"Strongly important (5)",5]
[{"$nulls":6},"Strongly to very strong importance (6)",6]
[{"$nulls":6},"Very strong importance (7)",7]
[{"$nulls":6},"Very strong to extremely important (8)",8]
["1.1 Performance Parameters Weighing Process",{"$nulls":5},"Extremely important (9)",9]
[{"$nulls":6},"R-Equally to moderately (1/2)",{"$f":"1/H6","v":0.5}]
[null,{"$f":"A16","v":"Pavement Structure Improvement"},{"$f":"A17","v":"Performance Under Heavy Traffic Loading"},{"$f":"A18","v":"Performance Under Average Daily Traffic"},null,null,"R-Moderately important (1/3)",0.33333333333333331]
["Pavement Structure Improvement",{"$nulls":5},"R-Moderately to strongly importance (1/4)",0.25]
["Performance Under Heavy Traffic Loading",{"$nulls":5},"R-Strongly important (1/5)",0.2]
["Performance Under Average Daily Traffic",{"$nulls":5},"R-Strongly to very strong importance (1/6)",0.16666666666666666]
[{"$nulls":6},"R-Very strong importance (1/7)",0.14285714285714285]
["Overall Consistency",{"$f":"IFERROR(T39,\"-\")","v":"-"},{"$f":"IF(B20=\"Consistent\",\"\",\"Review pair wise comparison\")","v":"Review pair wise comparison"},null,null,null,"R-Very strong to extremely important (1/8)",0.125,null,{"$f":"I21","v":"Performance"},{"$f":"I22","v":"Procurement and Contracts"},{"$f":"I23","v":"Environmental Sustainability"},{"$f":"I24","v":"User Satisfaction"},null,null,null,"Check Transitivity",null,{"$f":"R21","v":"Performance "},{"$f":"R22","v":"Procurement and Contracts "},{"$f":"R23","v":"Weather Limitations and Sustainability"},{"$f":"R24","v":"User Satisfaction"}]
[{"$nulls":6},"R-Extremely important (1/9)",0.1111111111111111,"Performance",1,{"$f":"VLOOKUP(C4,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D4,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E4,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},"Performance ",null,null,{"$f":"IF(K21>1,IF(L22>1, IF(L21>1,\"True\",\"False\"),\"True\"),\"True\")","v":{"$error":"#N/A"}},{"$f":"IF(L21>1,IF(M23>1,IF(M21>1,\"True\",\"False\"),\"True\"),\"True\")","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Procurement and Contracts",{"$f":"1/K21","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(D5,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E5,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},"Procurement and Contracts ",null,null,null,{"$f":"IF(L22>1,IF(M23>1,IF(M22>1,\"True\",\"False\"),\"True\"),\"True\")","v":{"$error":"#N/A"}}]
["1.2 User Satisfaction Parameters Weighing Process",{"$nulls":7},"Environmental Sustainability",{"$f":"1/L21","v":{"$error":"#N/A"}},{"$f":"1/L22","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(E6,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},"Weather Limitations and Sustainability"]
[{"$nulls":8},"User Satisfaction",{"$f":"1/M21","v":{"$error":"#N/A"}},{"$f":"1/M22","v":{"$error":"#N/A"}},{"$f":"1/M23","v":{"$error":"#N/A"}},1,{"$nulls":4},"User Satisfaction"]
[null,{"$f":"A26","v":"Facility Downtime"},{"$f":"A27","v":"Impact on Roughness"},{"$f":"A28","v":"Impact of Friction"},{"$f":"A29","v":"Noise"},{"$nulls":4},{"$f":"I26","v":"Performance"},{"$f":"I27","v":"Procurement and Contracts"},{"$f":"I28","v":"Environmental Sustainability"},{"$f":"I29","v":"User Satisfaction"}]
["Facility Downtime",{"$nulls":7},"Performance",{"$f":"J21/SUM($J$21:$J$24)","v":{"$error":"#N/A"}},{"$f":"K21/SUM($K$21:$K$24)","v":{"$error":"#N/A"}},{"$f":"L21/SUM($L$21:$L$24)","v":{"$error":"#N/A"}},{"$f":"M21/SUM($M$21:$M$24)","v":{"$error":"#N/A"}},"Column Vector ","Weights",null,"Check Consistency ","Performance",{"$f":"MMULT(J21:M21,$O$27:$O$30)/O27","v":{"$error":"#N/A"}}]
["Impact on Roughness",{"$nulls":7},"Procurement and Contracts",{"$f":"J22/SUM($J$21:$J$24)","v":{"$error":"#N/A"}},{"$f":"K22/SUM($K$21:$K$24)","v":{"$error":"#N/A"}},{"$f":"L22/SUM($L$21:$L$24)","v":{"$error":"#N/A"}},{"$f":"M22/SUM($M$21:$M$24)","v":{"$error":"#N/A"}},{"$f":"SUM(J26:M26)","v":{"$error":"#N/A"}},{"$f":"N27/$O$31","v":{"$error":"#N/A"}},null,null,"Procurement and Contracts",{"$f":"MMULT(J22:M22,$O$27:$O$30)/O28","v":{"$error":"#N/A"}}]
["Impact of Friction",{"$nulls":7},"Environmental Sustainability",{"$f":"J23/SUM($J$21:$J$24)","v":{"$error":"#N/A"}},{"$f":"K23/SUM($K$21:$K$24)","v":{"$error":"#N/A"}},{"$f":"L23/SUM($L$21:$L$24)","v":{"$error":"#N/A"}},{"$f":"M23/SUM($M$21:$M$24)","v":{"$error":"#N/A"}},{"$f":"SUM(J27:M27)","v":{"$error":"#N/A"}},{"$f":"N28/$O$31","v":{"$error":"#N/A"}},null,null,"Weather Limitations and Sustainability",{"$f":"MMULT(J23:M23,$O$27:$O$30)/O29","v":{"$error":"#N/A"}}]
["Noise",{"$nulls":7},"User Satisfaction",{"$f":"J24/SUM($J$21:$J$24)","v":{"$error":"#N/A"}},{"$f":"K24/SUM($K$21:$K$24)","v":{"$error":"#N/A"}},{"$f":"L24/SUM($L$21:$L$24)","v":{"$error":"#N/A"}},{"$f":"M24/SUM($M$21:$M$24)","v":{"$error":"#N/A"}},{"$f":"SUM(J28:M28)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,"User Satisfaction",{"$f":"MMULT(J24:M24,$O$27:$O$30)/O30","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Sum",{"$f":"SUM(J26:J29)","v":{"$error":"#N/A"}},{"$f":"SUM(K26:K29)","v":{"$error":"#N/A"}},{"$f":"SUM(L26:L29)","v":{"$error":"#N/A"}},{"$f":"SUM(M26:M29)","v":{"$error":"#N/A"}},{"$f":"SUM(J29:M29)","v":{"$error":"#N/A"}},{"$f":"N30/$O$31","v":{"$error":"#N/A"}},null,null,"CI",{"$f":"(AVERAGE(S26:S29)-4)/(4-1)","v":{"$error":"#N/A"}}]
["Overall Consistency",{"$f":"IFERROR(T48,\"-\")","v":"-"},{"$f":"IF(B31=\"Consistent\",\"\",\"Review pair wise comparison\")","v":"Review pair wise comparison"},{"$nulls":11},{"$f":"SUM(J30:M30)","v":{"$error":"#N/A"}},null,null,"RI",1.1200000000000001]
[{"$nulls":15},{"$f":"SUM(O27:O30)","v":{"$error":"#N/A"}},null,"CR",{"$f":"S30/S31","v":{"$error":"#N/A"}},{"$f":"IF(S32>0.1,\"Non Consistent\",\"Consistent\")","v":{"$error":"#N/A"}}]
[]
["1.3 Procurement and Contracts Parameters Weighing Process",{"$nulls":8},{"$f":"I35","v":"Structure improvement"},{"$f":"I36","v":"Heavy Traffic Loading"},{"$f":"I37","v":"ADT"},{"$nulls":4},"Check Consistency ","Structure improvement",{"$f":"MMULT(J35:L35,$N$40:$N$42)/N40","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Structure improvement",1,{"$f":"VLOOKUP(C16,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D16,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$nulls":5},"Heavy Traffic Loading",{"$f":"MMULT(J36:L36,$N$40:$N$42)/N41","v":{"$error":"#N/A"}}]
[null,{"$f":"A37","v":"Availability of Qualified Contractors"},{"$f":"A38","v":"Availability of Quality Materials"},{"$nulls":5},"Heavy Traffic Loading",{"$f":"1/K35","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(D17,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$nulls":5},"ADT",{"$f":"MMULT(J37:L37,$N$40:$N$42)/N42","v":{"$error":"#N/A"}}]
["Availability of Qualified Contractors",{"$nulls":7},"ADT",{"$f":"1/L35","v":{"$error":"#N/A"}},{"$f":"1/L36","v":{"$error":"#N/A"}},1,{"$nulls":5},"CI",{"$f":"(AVERAGE(S34:S36)-3)/(3-1)","v":{"$error":"#N/A"}}]
["Availability of Quality Materials",{"$nulls":8},{"$f":"I39","v":"Structure improvement"},{"$f":"I40","v":"Heavy Traffic Loading"},{"$f":"I41","v":"ADT"},{"$nulls":5},"RI",0.9]
[{"$nulls":8},"Structure improvement",{"$f":"J35/SUM($J$35:$J$37)","v":{"$error":"#N/A"}},{"$f":"K35/SUM($K$35:$K$37)","v":{"$error":"#N/A"}},{"$f":"L35/SUM($L$35:$L$37)","v":{"$error":"#N/A"}},"Column Vector ","Weights",null,null,null,"CR",{"$f":"S37/S38","v":{"$error":"#N/A"}},{"$f":"IF(S39>0.1,\"Non Consistent\",\"Consistent\")","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Heavy Traffic Loading",{"$f":"J36/SUM($J$35:$J$37)","v":{"$error":"#N/A"}},{"$f":"K36/SUM($K$35:$K$37)","v":{"$error":"#N/A"}},{"$f":"L36/SUM($L$35:$L$37)","v":{"$error":"#N/A"}},{"$f":"SUM(J39:L39)","v":{"$error":"#N/A"}},{"$f":"M40/$N$43","v":{"$error":"#N/A"}}]
[{"$nulls":8},"ADT",{"$f":"J37/SUM($J$35:$J$37)","v":{"$error":"#N/A"}},{"$f":"K37/SUM($K$35:$K$37)","v":{"$error":"#N/A"}},{"$f":"L37/SUM($L$35:$L$37)","v":{"$error":"#N/A"}},{"$f":"SUM(J40:L40)","v":{"$error":"#N/A"}},{"$f":"M41/$N$43","v":{"$error":"#N/A"}},null,null,"Check Consistency "]
[{"$nulls":8},"Sum",{"$f":"SUM(J39:J41)","v":{"$error":"#N/A"}},{"$f":"SUM(K39:K41)","v":{"$error":"#N/A"}},{"$f":"SUM(L39:L41)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"M42/$N$43","v":{"$error":"#N/A"}},null,null,null,"Facility Downtime",{"$f":"MMULT(J47:M47,$O$52:$O$55)/O52","v":{"$error":"#N/A"}}]
[{"$nulls":13},{"$f":"SUM(J42:L42)","v":{"$error":"#N/A"}},null,null,null,"Impact on Roughness",{"$f":"MMULT(J48:M48,O52:O55)/O53","v":{"$error":"#N/A"}}]
[{"$nulls":17},"Impact of Friction",{"$f":"MMULT(J49:M49,O52:O55)/O54","v":{"$error":"#N/A"}}]
[{"$nulls":17},"Noise",{"$f":"MMULT(J50:M50,O52:O55)/O55","v":{"$error":"#N/A"}}]
[{"$nulls":9},{"$f":"I47","v":"Facility Downtime"},{"$f":"I48","v":"Impact on Roughness"},{"$f":"I49","v":"Impact of Friction"},{"$f":"I50","v":"Noise"},{"$nulls":4},"CI",{"$f":"(AVERAGE(S42:S45)-4)/(4-1)","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Facility Downtime",1,{"$f":"VLOOKUP(C26,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D26,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E26,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},"RI",0.9]
[{"$nulls":8},"Impact on Roughness",{"$f":"1/K47","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(D27,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E27,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}},{"$nulls":4},"CR",{"$f":"S46/S47","v":{"$error":"#N/A"}},{"$f":"IF(S48>0.1,\"Non Consistent\",\"Consistent\")","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Impact of Friction",{"$f":"1/L47","v":{"$error":"#N/A"}},{"$f":"1/L48","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(E28,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Noise",{"$f":"1/M47","v":{"$error":"#N/A"}},{"$f":"1/M48","v":{"$error":"#N/A"}},{"$f":"1/M49","v":{"$error":"#N/A"}},1]
[{"$nulls":9},{"$f":"I52","v":"Facility Downtime"},{"$f":"I53","v":"Impact on Roughness"},{"$f":"I54","v":"Impact of Friction"},{"$f":"I55","v":"Noise"},null,"Weights"]
[{"$nulls":8},"Facility Downtime",{"$f":"J47/SUM($J$47:$J$50)","v":{"$error":"#N/A"}},{"$f":"K47/SUM($K$47:$K$50)","v":{"$error":"#N/A"}},{"$f":"L47/SUM($L$47:$L$50)","v":{"$error":"#N/A"}},{"$f":"M47/SUM($M$47:$M$50)","v":{"$error":"#N/A"}},"Column Vector ",{"$f":"N53/$N$57","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Impact on Roughness",{"$f":"J48/SUM($J$47:$J$50)","v":{"$error":"#N/A"}},{"$f":"K48/SUM($K$47:$K$50)","v":{"$error":"#N/A"}},{"$f":"L48/SUM($L$47:$L$50)","v":{"$error":"#N/A"}},{"$f":"M48/SUM($M$47:$M$50)","v":{"$error":"#N/A"}},{"$f":"SUM(J52:M52)","v":{"$error":"#N/A"}},{"$f":"N54/$N$57","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Impact of Friction",{"$f":"J49/SUM($J$47:$J$50)","v":{"$error":"#N/A"}},{"$f":"K49/SUM($K$47:$K$50)","v":{"$error":"#N/A"}},{"$f":"L49/SUM($L$47:$L$50)","v":{"$error":"#N/A"}},{"$f":"M49/SUM($M$47:$M$50)","v":{"$error":"#N/A"}},{"$f":"SUM(J53:M53)","v":{"$error":"#N/A"}},{"$f":"N55/$N$57","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Noise",{"$f":"J50/SUM($J$47:$J$50)","v":{"$error":"#N/A"}},{"$f":"K50/SUM($K$47:$K$50)","v":{"$error":"#N/A"}},{"$f":"L50/SUM($L$47:$L$50)","v":{"$error":"#N/A"}},{"$f":"M50/SUM($M$47:$M$50)","v":{"$error":"#N/A"}},{"$f":"SUM(J54:M54)","v":{"$error":"#N/A"}},{"$f":"N56/$N$57","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Sum",{"$f":"SUM(J52:J55)","v":{"$error":"#N/A"}},{"$f":"SUM(K52:K55)","v":{"$error":"#N/A"}},{"$f":"SUM(L52:L55)","v":{"$error":"#N/A"}},{"$f":"SUM(M52:M55)","v":{"$error":"#N/A"}},{"$f":"SUM(J55:M55)","v":{"$error":"#N/A"}},{"$f":"SUM(O52:O55)","v":{"$error":"#N/A"}}]
[{"$nulls":13},{"$f":"SUM(J56:M56)","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[{"$nulls":9},{"$f":"I63","v":"Qualified Contractors"},{"$f":"I64","v":"Quality Materials"}]
[{"$nulls":8},"Qualified Contractors",1,{"$f":"VLOOKUP(C37,$G$5:$H$21,2,FALSE)","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Quality Materials",{"$f":"1/K63","v":{"$error":"#N/A"}},1]
[{"$nulls":9},{"$f":"I66","v":"Qualified Contractors"},{"$f":"I67","v":"Quality Materials"},"Column Vector ","Weights"]
[{"$nulls":8},"Qualified Contractors",{"$f":"J63/SUM($J$63:$J$64)","v":{"$error":"#N/A"}},{"$f":"K63/SUM($K$63:$K$64)","v":{"$error":"#N/A"}},{"$f":"SUM(J66:K66)","v":{"$error":"#N/A"}},{"$f":"L66/$L$68","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Quality Materials",{"$f":"J64/SUM($J$63:$J$64)","v":{"$error":"#N/A"}},{"$f":"K64/SUM($K$63:$K$64)","v":{"$error":"#N/A"}},{"$f":"SUM(J67:K67)","v":{"$error":"#N/A"}},{"$f":"L67/$L$68","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Sum",{"$f":"SUM(J66:J67)","v":{"$error":"#N/A"}},{"$f":"SUM(K66:K67)","v":{"$error":"#N/A"}},{"$f":"SUM(J68:K68)","v":{"$error":"#N/A"}},{"$f":"SUM(M66:M67)","v":{"$error":"#N/A"}}]
[]
[]
[{"$nulls":8},"Category ","Selection Criteria","Average Global Weight"]
[{"$nulls":8},"Performance","Pavement Structure Improvement",{"$f":"$O$27*N40","v":{"$error":"#N/A"}}]
[{"$nulls":9},"Performance Under Heavy Traffic Loading",{"$f":"$O$27*N41","v":{"$error":"#N/A"}}]
[{"$nulls":9},"Performance Under Average Daily Traffic",{"$error":"#N/A"}]
[{"$nulls":8},"User Satisfaction","Facility Downtime",{"$f":"$O$30*O52","v":{"$error":"#N/A"}}]
[{"$nulls":9},"Impact on Roughness",{"$f":"$O$30*O53","v":{"$error":"#N/A"}}]
[{"$nulls":9},"Impact on Friction",{"$error":"#N/A"}]
[{"$nulls":9},"Noise",{"$f":"$O$30*O55","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Procurement and Contracts","Availability of Qualified Contractors",{"$f":"$O$28*M66","v":{"$error":"#N/A"}}]
[{"$nulls":9},"Availability of Quality Materials",{"$f":"$O$28*M67","v":{"$error":"#N/A"}}]
[{"$nulls":8},"Environmental Sustainability","Negative Environmental Impact",{"$f":"O29","v":{"$error":"#N/A"}}]

{"sheet":"AHP Weights","index":14,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,0,27,1],[20,0,23,0],[17,0,19,0],[24,0,25,0],[1,0,3,0],[4,0,7,0],[8,0,9,0]]}
["Category ","Selection Criteria","Average Global Weight"]
["Performance","Pavement Structure Improvement",{"$f":"IF($B$16=1,C18,IF($B$16=2,AVERAGE(C18:D18),IF($B$16=3,AVERAGE(C18:E18))))","v":{"$error":"#N/A"}}]
[null,"Performance Under Heavy Traffic Loading",{"$f":"IF($B$16=1,C19,IF($B$16=2,AVERAGE(C19:D19),IF($B$16=3,AVERAGE(C19:E19))))","v":{"$error":"#N/A"}}]
[null,"Performance Under Average Daily Traffic",{"$error":"#N/A"}]
["User Satisfaction","Facility Downtime",{"$error":"#N/A"}]
[null,"Impact on Roughness",{"$error":"#N/A"}]
[null,"Impact on Friction",{"$error":"#N/A"}]
[null,"Noise",{"$error":"#N/A"}]
["Procurement and Contracts","Availability of Qualified Contractors",{"$error":"#N/A"}]
[null,"Availability of Quality Materials",{"$error":"#N/A"}]
["Environmental Sustainability","Negative Environmental Impact",{"$error":"#N/A"}]
[]
[]
[]
[]
["Number of Users",{"$f":"MAX(C28:D28)","v":2}]
["Category ","Selection Criteria","User 1 ","User 2 ","User 3 "]
["Performance","Pavement Structure Improvement",{"$f":"'Weighting Parameters'!K72","v":{"$error":"#N/A"}},{"$f":"'Weighting Parameters 2'!K72","v":{"$error":"#N/A"}},{"$f":"'Weighting Parameters 3'!K72","v":{"$error":"#N/A"}}]
[null,"Performance Under Heavy Traffic Loading",{"$f":"'Weighting Parameters'!K73","v":{"$error":"#N/A"}},{"$f":"'Weighting Parameters 2'!K73","v":{"$error":"#N/A"}},{"$f":"'Weighting Parameters 3'!K73","v":{"$error":"#N/A"}}]
[null,"Performance Under Average Daily Traffic",{"$f":"'Weighting Parameters'!K74","v":{"$error":"#N/A"}},{"$f":"'Weighting Parameters 2'!K74","v":{"$error":"#N/A"}},{"$f":"'Weighting Parameters 3'!K74","v":{"$error":"#N/A"}}]
["User Satisfaction","Facility Downtime",{"$f":"'Weighting Parameters'!K75","v":{"$error":"#N/A"}},{"$f":"'Weighting Parameters 2'!K75","v":{"$error":"#N/A"}},{"$f":"'Weighting Parameters 3'!K75","v":{"$error":"#N/A"}}]
[null,"Impact on Roughness",{"$f":"'Weighting Parameters'!K76","v":{"$error":"#N/A"}},{"$f":"'Weighting Parameters 2'!K76","v":{"$error":"#N/A"}},{"$f":"'Weighting Parameters 3'!K76","v":{"$error":"#N/A"}}]
[null,"Impact on Friction",{"$f":"'Weighting Parameters'!K77","v":{"$error":"#N/A"}},{"$f":"'Weighting Parameters 2'!K77","v":{"$error":"#N/A"}},{"$f":"'Weighting Parameters 3'!K77","v":{"$error":"#N/A"}}]
[null,"Noise",{"$f":"'Weighting Parameters'!K78","v":{"$error":"#N/A"}},{"$f":"'Weighting Parameters 2'!K78","v":{"$error":"#N/A"}},{"$f":"'Weighting Parameters 3'!K78","v":{"$error":"#N/A"}}]
["Procurement and Contracts","Availability of Qualified Contractors",{"$f":"'Weighting Parameters'!K79","v":{"$error":"#N/A"}},{"$f":"'Weighting Parameters 2'!K79","v":{"$error":"#N/A"}},{"$f":"'Weighting Parameters 3'!K79","v":{"$error":"#N/A"}}]
[null,"Availability of Quality Materials",{"$f":"'Weighting Parameters'!K80","v":{"$error":"#N/A"}},{"$f":"'Weighting Parameters 2'!K80","v":{"$error":"#N/A"}},{"$f":"'Weighting Parameters 3'!K80","v":{"$error":"#N/A"}}]
["Environmental Sustainability","Negative Environmental Impact",{"$f":"'Weighting Parameters'!K81","v":{"$error":"#N/A"}},{"$f":"'Weighting Parameters 2'!K81","v":{"$error":"#N/A"}},{"$f":"'Weighting Parameters 3'!K81","v":{"$error":"#N/A"}}]
["Number of users",null,{"$f":"IF('Weighting Parameters'!B40=\"Yes\",2,1)","v":1},{"$f":"IF('Weighting Parameters 2'!B40=\"Yes\",3,2)","v":2}]

{"sheet":"AC Treatments Data","index":15,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,0,23,2]]}
["Asphalt Preservation Treatment","Life Expectancy (yrs.)","Cost ","Unit","Remarks"]
["Chip seal",5,11600,"Lane mile","2013 data (single chip seal with fog seal)"]
["Microsurfacing",6,{"$f":"(13100*1.03^2+22000)/2","v":17948.895},"Lane mile","Average price of data provided"]
["Crack sealing",3,null,"LF"]
["Crack fill",2,null,"LF"]
["Sand seal",4,null,"Lane mile"]
["Slurry seal",5,12500,"Lane mile","2013 data "]
["Thin HMA overlay ",8,{"$f":"990*87","v":86130},"Lane mile","2.5\" thickness (990 tons/ lane mile)"]
["Milling + Chip seal",8,{"$f":"C10+C2","v":110441.60000000001},"Lane mile"]
["Milling",4,{"$f":"63360*1.56","v":98841.600000000006},"Lane mile","Minimum cost based on 1\" milling depth"]
["Asphalt Rehabilitation Treatment","Life Expectancy (yrs.)","Cost ","Unit"]
["Cold mix asphalt",16,140000,"Lane mile"]
["Milling with overlay",11,220000,"Lane mile","Milling ≥ 1\" (2013 and 2012 cost data)"]
["Thick HMA overlay",15,160000,"Lane mile"]
["CIR",10,{"$f":"63360*1.94","v":122918.39999999999},"Lane mile","4\" depth "]
["Whitetopping",25,{"$f":"63360*4.75","v":300960},"Lane mile","6\" depth"]
["Patching ",4,83.71,"SY","Minimum cost for 4\" depth "]
["Planned Reconstruction/Rehab",20,600000,"Lane mile"]
["Reconstruction",20,600000,"Lane mile"]
["User Defined Treatment","Life Expectancy (yrs.)","Cost ","Unit"]
["User defined treatment 1 ",null,null,"Lane mile"]
["User defined treatment 2 ",null,null,"Lane mile"]
["User defined treatment 3 ",null,null,"Lane mile"]
["**Green cells indicate data is obtained from city/county engineers in 2014"]

{"sheet":"PCC Treatments Data","index":16,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,0,21,1]]}
["PCC Preservation Treatment","Life Expectancy (yrs.)","Cost ","Unit","Remarks"]
["Crack sealing",6,4.7,"LF"]
["Joint sealing",6,null,"LF"]
["Diamond grinding",15,null,"Lane mile"]
["Diamond grooving",12,null,"Lane mile"]
["Partial depth repair",10,null,"SY"]
["PCC Rehabilitation Treatment","Life Expectancy (yrs.)","Cost ","Unit"]
["HMA overlay",12,null,"Lane mile"]
["Full depth repair",13,67.63,"SY"]
["Unbonded Concrete Overlay",20,248000,"Lane mile"]
["HMA overlay with crack and seat",18,null,"Lane mile"]
["HMA overlay with rubblization",18,520000,"Lane mile","Average cost in 2012 (two projects)"]
["Planned Reconstruction/Rehab",40,575000,"Lane mile","2012 to 2013 data (four projects)"]
["Reconstruction",40,575000,"Lane mile","2013 to 2013 data (four projects)"]
["Slab replacement",null,null,"Lane mile"]
["Thick HMA overlay",15,160000,"Lane mile"]
["Thin HMA overlay ",8,{"$f":"990*87","v":86130},"Lane mile","2.5\" thickness (990 tons/ lane mile)"]
["User Defined Treatment","Life Expectancy (yrs.)","Cost ","Unit"]
["User defined treatment 1 ",null,null,"Lane mile"]
["User defined treatment 2 ",null,null,"Lane mile"]
["User defined treatment 3 ",null,null,"Lane mile"]
["**Yellow cells indicate cost obtained from IADOT projects database"]

{"sheet":"Scoring Sheet","index":17,"n_rows":26,"n_cols":18,"rows_kept":26,"cut":false,"hidden":false,"merged":[[20,0,20,1],[0,0,1,17],[8,0,11,0],[12,0,13,0],[2,3,3,7],[2,8,3,12],[15,0,15,7]]}
[{"$f":"IF(OR('Weighting Parameters'!#REF!<>\"Consistent\",'Weighting Parameters'!#REF!<>\"Consistent\",'Weighting Parameters'!#REF!<>\"Consistent\",'Weighting Parameters'!#REF!<>\"Consistent\"),\"Warning: Your pair wise comparisons need to be revised, Please go back to weighting paramters sheet and check consistency warnings\",\"\")","v":{"$error":"#REF!"}}]
[]
["Pavement Suface Type",{"$f":"'EUAC and ROI'!B3","v":0},null,"Scores",{"$nulls":4},"Weighted Scores"]
[]
["Category ","Selection Criteria","Average Global Weight",{"$f":"'EUAC and ROI'!B8","v":"-"},{"$f":"'EUAC and ROI'!B9","v":"-"},{"$f":"'EUAC and ROI'!B10","v":"-"},{"$f":"'EUAC and ROI'!B11","v":"-"},{"$f":"'EUAC and ROI'!B12","v":"-"},{"$f":"D5","v":"-"},{"$f":"E5","v":"-"},"-","-","-"]
["Performance","Pavement Structure Improvement",{"$f":"IF('Weights Assignment'!$M$5='Weights Assignment'!$M$1,'Manual Assignment'!C2,'AHP Weights'!C2)","v":{"$error":"#N/A"}},{"$nulls":5},{"$f":"IFERROR(D6*$C$6,\"-\")","v":"-"},{"$f":"IFERROR(E6*$C$6,\"-\")","v":"-"},{"$f":"IFERROR(F6*$C$6,\"-\")","v":"-"},{"$f":"IFERROR(G6*$C$6,\"-\")","v":"-"},{"$f":"IFERROR(H6*$C$6,\"-\")","v":"-"},null,null,"Rank","Potential Action "]
[null,"Performance Under Heavy Traffic Loading",{"$f":"IF('Weights Assignment'!$M$5='Weights Assignment'!$M$1,'Manual Assignment'!C3,'AHP Weights'!C3)","v":{"$error":"#N/A"}},{"$nulls":5},{"$f":"IFERROR(D7*$C$7,\"-\")","v":"-"},{"$f":"IFERROR(E7*$C$7,\"-\")","v":"-"},{"$f":"IFERROR(F7*$C$7,\"-\")","v":"-"},{"$f":"IFERROR(G7*$C$7,\"-\")","v":"-"},{"$f":"IFERROR(H7*$C$7,\"-\")","v":"-"},null,null,{"$f":"N18","v":1},{"$f":"I5","v":"-"}]
[null,"Performance Under Average Daily Traffic",{"$f":"IF('Weights Assignment'!$M$5='Weights Assignment'!$M$1,'Manual Assignment'!C4,'AHP Weights'!C4)","v":{"$error":"#N/A"}},{"$nulls":5},{"$f":"IFERROR(D8*$C$8,\"-\")","v":"-"},{"$f":"IFERROR(E8*$C$8,\"-\")","v":"-"},{"$f":"IFERROR(F8*$C$8,\"-\")","v":"-"},{"$f":"IFERROR(G8*$C$8,\"-\")","v":"-"},{"$f":"IFERROR(H8*$C$8,\"-\")","v":"-"},null,null,1,{"$f":"J5","v":"-"}]
["User Satisfaction","Facility Downtime",{"$f":"IF('Weights Assignment'!$M$5='Weights Assignment'!$M$1,'Manual Assignment'!C5,'AHP Weights'!C5)","v":{"$error":"#N/A"}},{"$nulls":5},{"$f":"IFERROR(D9*$C$9,\"-\")","v":"-"},{"$f":"IFERROR(E9*$C$9,\"-\")","v":"-"},{"$f":"IFERROR(F9*$C$9,\"-\")","v":"-"},{"$f":"IFERROR(G9*$C$9,\"-\")","v":"-"},{"$f":"IFERROR(H9*$C$9,\"-\")","v":"-"},null,null,{"$f":"P18","v":1},{"$f":"K5","v":"-"}]
[null,"Impact on Roughness",{"$f":"IF('Weights Assignment'!$M$5='Weights Assignment'!$M$1,'Manual Assignment'!C6,'AHP Weights'!C6)","v":{"$error":"#N/A"}},{"$nulls":5},{"$f":"IFERROR(D10*$C$10,\"-\")","v":"-"},{"$f":"IFERROR(E10*$C$10,\"-\")","v":"-"},{"$f":"IFERROR(F10*$C$10,\"-\")","v":"-"},{"$f":"IFERROR(G10*$C$10,\"-\")","v":"-"},{"$f":"IFERROR(H10*$C$10,\"-\")","v":"-"},null,null,{"$f":"Q18","v":1},{"$f":"L5","v":"-"}]
[null,"Impact on Friction",{"$f":"IF('Weights Assignment'!$M$5='Weights Assignment'!$M$1,'Manual Assignment'!C7,'AHP Weights'!C7)","v":{"$error":"#N/A"}},{"$nulls":5},{"$f":"IFERROR(D11*$C$11,\"-\")","v":"-"},{"$f":"IFERROR(E11*$C$11,\"-\")","v":"-"},{"$f":"IFERROR(F11*$C$11,\"-\")","v":"-"},{"$f":"IFERROR(G11*$C$11,\"-\")","v":"-"},{"$f":"IFERROR(H11*$C$11,\"-\")","v":"-"},null,null,{"$f":"R18","v":1},{"$f":"M5","v":"-"}]
[null,"Noise",{"$f":"IF('Weights Assignment'!$M$5='Weights Assignment'!$M$1,'Manual Assignment'!C8,'AHP Weights'!C8)","v":{"$error":"#N/A"}},{"$nulls":5},{"$f":"IFERROR(D12*$C$12,\"-\")","v":"-"},{"$f":"IFERROR(E12*$C$12,\"-\")","v":"-"},{"$f":"IFERROR(F12*$C$12,\"-\")","v":"-"},{"$f":"IFERROR(G12*$C$12,\"-\")","v":"-"},{"$f":"IFERROR(H12*$C$12,\"-\")","v":"-"}]
["Procurement and Contracts","Availability of Qualified Contractors",{"$f":"IF('Weights Assignment'!$M$5='Weights Assignment'!$M$1,'Manual Assignment'!C9,'AHP Weights'!C9)","v":{"$error":"#N/A"}},{"$nulls":5},{"$f":"IFERROR(D13*$C$13,\"-\")","v":"-"},{"$f":"IFERROR(E13*$C$13,\"-\")","v":"-"},{"$f":"IFERROR(F13*$C$13,\"-\")","v":"-"},{"$f":"IFERROR(G13*$C$13,\"-\")","v":"-"},{"$f":"IFERROR(H13*$C$13,\"-\")","v":"-"}]
[null,"Availability of Quality Materials",{"$f":"IF('Weights Assignment'!$M$5='Weights Assignment'!$M$1,'Manual Assignment'!C10,'AHP Weights'!C10)","v":{"$error":"#N/A"}},{"$nulls":5},{"$f":"IFERROR(D14*$C$14,\"-\")","v":"-"},{"$f":"IFERROR(E14*$C$14,\"-\")","v":"-"},{"$f":"IFERROR(F14*$C$14,\"-\")","v":"-"},{"$f":"IFERROR(G14*$C$14,\"-\")","v":"-"},{"$f":"IFERROR(H14*$C$14,\"-\")","v":"-"}]
["Environmental Sustainability","Negative Environmental Impact",{"$f":"IF('Weights Assignment'!$M$5='Weights Assignment'!$M$1,'Manual Assignment'!C11,'AHP Weights'!C11)","v":{"$error":"#N/A"}},{"$nulls":5},{"$f":"IFERROR(D15*$C$15,\"-\")","v":"-"},{"$f":"IFERROR(E15*$C$15,\"-\")","v":"-"},{"$f":"IFERROR(F15*$C$15,\"-\")","v":"-"},{"$f":"IFERROR(G15*$C$15,\"-\")","v":"-"},{"$f":"IFERROR(H15*$C$15,\"-\")","v":"-"}]
["Total Score",{"$nulls":7},{"$f":"SUM(I6:I15)","v":0},{"$f":"SUM(J6:J15)","v":0},{"$f":"SUM(K6:K15)","v":0},{"$f":"SUM(L6:L15)","v":0},{"$f":"SUM(M6:M15)","v":0}]
[{"$nulls":8},{"$f":"IFERROR(I16,0)","v":0},{"$f":"IFERROR(J16,0)","v":0},0,0,0]
[{"$nulls":13},{"$f":"RANK(I17,$I$17:$M$17)","v":1},{"$f":"RANK(J17,$I$17:$M$17)","v":1},{"$f":"RANK(K17,$I$17:$M$17)","v":1},{"$f":"RANK(L17,$I$17:$M$17)","v":1},{"$f":"RANK(M17,$I$17:$M$17)","v":1}]
[]
[]
["Ranked Potential Actions"]
[1,{"$f":"IFERROR(VLOOKUP(TRUNC(A22,1),$P$7:$Q$11,2,FALSE),\"-\")","v":"-"}]
[2,{"$f":"IFERROR(VLOOKUP(TRUNC(A23,1),$P$7:$Q$11,2,FALSE),\"-\")","v":"-"}]
[3,"-"]
[4,"-"]
[5,"-"]

{"sheet":"Potential Actions","index":18,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Potential Actions"]
["Action","Total Score","Rank",null,null,null,{"$f":"'Project Information'!$B$9","v":0},{"$f":"IF(G2=\"AC\", \"AC Summary Sheet\", \"PCC Summary Sheet\")","v":"PCC Summary Sheet"}]
[{"$f":"'Scoring Sheet'!I5","v":"-"},{"$f":"'Scoring Sheet'!I16","v":0},{"$f":"IF('Treatment Ranking I'!$A$11=\"Yes\",IF(A3<>\"-\",RANK(B3,$B$3:$B$7),\"-\"),\"-\")","v":"-"}]
[{"$f":"'Scoring Sheet'!J5","v":"-"},{"$f":"'Scoring Sheet'!J16","v":0},{"$f":"IF('Treatment Ranking I'!$A$11=\"Yes\",IF(A4<>\"-\",RANK(B4,$B$3:$B$7),\"-\"),\"-\")","v":"-"}]
[{"$f":"'Scoring Sheet'!K5","v":"-"},{"$f":"'Scoring Sheet'!K16","v":0},{"$f":"IF('Treatment Ranking I'!$A$11=\"Yes\",IF(A5<>\"-\",RANK(B5,$B$3:$B$7),\"-\"),\"-\")","v":"-"}]
[{"$f":"'Scoring Sheet'!L5","v":"-"},{"$f":"'Scoring Sheet'!L16","v":0},{"$f":"IF('Treatment Ranking I'!$A$11=\"Yes\",IF(A6<>\"-\",RANK(B6,$B$3:$B$7),\"-\"),\"-\")","v":"-"}]
[{"$f":"'Scoring Sheet'!M5","v":"-"},{"$f":"'Scoring Sheet'!M16","v":0},{"$f":"IF('Treatment Ranking I'!$A$11=\"Yes\",IF(A7<>\"-\",RANK(B7,$B$3:$B$7),\"-\"),\"-\")","v":"-"}]

{"sheet":"AC Summary Sheet","index":19,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[34,2,35,2],[24,2,24,3],[22,2,22,5],[0,1,1,5],[4,4,4,5],[18,2,18,5],[19,2,19,5],[46,0,46,2],[34,0,35,0],[34,1,35,1],[33,0,33,7],[12,1,12,5],[20,1,20,5],[21,2,21,5],[31,1,31,5],[36,0,38,0],[39,0,42,0],[43,0,44,0],[34,3,34,7]]}
[null,{"$f":"'Project Information'!A1:A1","v":"Project Information "}]
[]
[null,{"$f":"'Project Information'!A3","v":"County/City"},{"$f":"'Project Information'!B3","v":0},null,{"$f":"'Project Information'!H3:H4","v":"Date "},{"$f":"'Project Information'!I3","v":"2016-02-24"}]
[null,{"$f":"'Project Information'!A4","v":"Name"},{"$f":"'Project Information'!B4","v":0},null,{"$f":"'Project Information'!H4:H5","v":"Estimated Letting date "},{"$f":"'Project Information'!I4","v":"00:00:00"}]
[null,{"$f":"'Project Information'!A5","v":"Project Engineer "},{"$f":"'Project Information'!B5","v":0},null,{"$f":"'Project Information'!H5:H6","v":"Location Data "},{"$f":"'Project Information'!I5:Q6","v":{"$error":"#VALUE!"}}]
[null,{"$f":"'Project Information'!A6","v":"Project Number "},{"$f":"'Project Information'!B6","v":0},null,{"$f":"'Project Information'!H6:H7","v":"Route"},{"$f":"'Project Information'!I6","v":0}]
[null,{"$f":"'Project Information'!A7","v":"Accounting ID "},{"$f":"'Project Information'!B7","v":0},null,{"$f":"'Project Information'!H7:H8","v":"Road Type "},{"$f":"'Project Information'!I7","v":0}]
[{"$nulls":4},{"$f":"'Project Information'!H8:H9","v":"Project Location From"},{"$f":"'Project Information'!I8","v":0}]
[null,{"$f":"'Project Information'!A9","v":"Pavement Surface Type"},{"$f":"'Project Information'!B9","v":0},null,{"$f":"'Project Information'!H9:H10","v":"Project Location To"},{"$f":"'Project Information'!I9","v":0}]
[null,{"$f":"'Project Information'!A10","v":"Length (miles)"},{"$f":"'Project Information'!B10","v":0}]
[null,{"$f":"'Project Information'!A11","v":"Number of Lanes"},{"$f":"'Project Information'!B11","v":0}]
[]
[null,{"$f":"'AC Surface Pavements'!A1:A1","v":"Distress Data"}]
[null,null,{"$f":"'AC Surface Pavements'!B2","v":"Existence "},{"$f":"'AC Surface Pavements'!C2","v":"Severity Level"},{"$f":"'AC Surface Pavements'!D2","v":"Extent Level"},{"$f":"'AC Surface Pavements'!E2","v":"Class"}]
[null,{"$f":"'AC Surface Pavements'!A3","v":"Longitudinal Cracking "},{"$f":"'AC Surface Pavements'!B3","v":0},{"$f":"'AC Surface Pavements'!C3","v":0},{"$f":"'AC Surface Pavements'!D3","v":0},{"$f":"'AC Surface Pavements'!E3","v":"-"}]
[null,{"$f":"'AC Surface Pavements'!A4","v":"Alligator Cracking"},{"$f":"'AC Surface Pavements'!B4","v":0},{"$f":"'AC Surface Pavements'!C4","v":0},{"$f":"'AC Surface Pavements'!D4","v":0},{"$f":"'AC Surface Pavements'!E4","v":"-"}]
[null,{"$f":"'AC Surface Pavements'!A5","v":"Transverse Cracking "},{"$f":"'AC Surface Pavements'!B5","v":0},{"$f":"'AC Surface Pavements'!C5","v":0},{"$f":"'AC Surface Pavements'!D5","v":0},{"$f":"'AC Surface Pavements'!E5","v":"-"}]
[null,{"$f":"'AC Surface Pavements'!A6","v":"Rutting"},{"$f":"'AC Surface Pavements'!B6","v":0},{"$f":"'AC Surface Pavements'!C6","v":0},{"$f":"'AC Surface Pavements'!D6","v":0},{"$f":"'AC Surface Pavements'!E6","v":"-"}]
[null,{"$f":"'AC Surface Pavements'!A7","v":"Roughness "},{"$f":"'AC Surface Pavements'!B7","v":0}]
[null,{"$f":"'AC Surface Pavements'!A8","v":"Friction"},{"$f":"'AC Surface Pavements'!B8","v":0}]
[null,{"$f":"'AC Surface Pavements'!A9","v":"Distress Distribution"}]
[null,{"$f":"'AC Surface Pavements'!A10","v":"Surface Age"},{"$f":"'AC Surface Pavements'!B10","v":0}]
[null,{"$f":"'AC Surface Pavements'!A11","v":"Distress Distribution"},{"$f":"'AC Surface Pavements'!B11","v":0}]
[]
["Cost Ranking","Non-Cost Ranking",{"$f":"'AC Surface Pavements'!A25","v":"Potential Action(s)"},null,"NPV ","EUAC","ROI","Service Life"]
[{"$f":"'Treatment Ranking I'!G2","v":"-"},{"$f":"'Potential Actions'!C3","v":"-"},{"$f":"'EUAC and ROI'!A8","v":"Action #1 "},{"$f":"'EUAC and ROI'!B8","v":"-"},{"$f":"IFERROR('EUAC and ROI'!AB22,\"-\")","v":"-"},{"$f":"'EUAC and ROI'!AB23","v":"-"},{"$f":"'Cost Summary Sheet'!F2","v":"-"},{"$f":"'EUAC and ROI'!AA20","v":0}]
[{"$f":"'Treatment Ranking I'!G3","v":"-"},{"$f":"'Potential Actions'!C4","v":"-"},{"$f":"'EUAC and ROI'!A9","v":"Action #2"},{"$f":"'EUAC and ROI'!B9","v":"-"},{"$f":"IFERROR('EUAC and ROI'!AB35,\"-\")","v":"-"},{"$f":"'EUAC and ROI'!AB36","v":"-"},{"$f":"'Cost Summary Sheet'!F3","v":"-"},{"$f":"'EUAC and ROI'!Z33","v":0}]
[{"$f":"'Treatment Ranking I'!G4","v":"-"},{"$f":"'Potential Actions'!C5","v":"-"},{"$f":"'EUAC and ROI'!A10","v":"Action #3"},{"$f":"'EUAC and ROI'!B10","v":"-"},{"$f":"IFERROR('EUAC and ROI'!AB48,\"-\")","v":"-"},{"$f":"'EUAC and ROI'!AB49","v":"-"},{"$f":"'Cost Summary Sheet'!F4","v":"-"},{"$f":"'EUAC and ROI'!Z46","v":0}]
[{"$f":"'Treatment Ranking I'!G5","v":"-"},{"$f":"'Potential Actions'!C6","v":"-"},{"$f":"'EUAC and ROI'!A11","v":"Action #4"},{"$f":"'EUAC and ROI'!B11","v":"-"},{"$f":"'EUAC and ROI'!AB61","v":"-"},{"$f":"'EUAC and ROI'!AB62","v":"-"},{"$f":"'Cost Summary Sheet'!F5","v":"-"},{"$f":"'EUAC and ROI'!Z59","v":0}]
[{"$f":"'Treatment Ranking I'!G6","v":"-"},{"$f":"'Potential Actions'!C7","v":"-"},{"$f":"'EUAC and ROI'!A12","v":"Action #5"},{"$f":"'EUAC and ROI'!B12","v":"-"},{"$f":"'EUAC and ROI'!Z74","v":"-"},{"$f":"'EUAC and ROI'!Z75","v":"-"},{"$f":"'Cost Summary Sheet'!F6","v":"-"},{"$f":"'EUAC and ROI'!X72","v":0}]
[]
["Method of Weights Assignment ",{"$f":"'Weights Assignment'!A4:A4","v":0}]
[]
["Scoring Sheet"]
[{"$f":"'Scoring Sheet'!A5","v":"Category "},{"$f":"'Scoring Sheet'!B5","v":"Selection Criteria"},{"$f":"'Scoring Sheet'!C5","v":"Average Global Weight"},{"$f":"'Scoring Sheet'!I3:I3","v":"Weighted Scores"}]
[null,null,null,{"$f":"'Scoring Sheet'!I5","v":"-"},{"$f":"'Scoring Sheet'!J5","v":"-"},{"$f":"'Scoring Sheet'!K5","v":"-"},{"$f":"'Scoring Sheet'!L5","v":"-"},{"$f":"'Scoring Sheet'!M5","v":"-"}]
[{"$f":"'Scoring Sheet'!A6","v":"Performance"},{"$f":"'Scoring Sheet'!B6","v":"Pavement Structure Improvement"},{"$f":"'Scoring Sheet'!C6","v":{"$error":"#N/A"}},{"$f":"'Scoring Sheet'!I6","v":"-"},{"$f":"'Scoring Sheet'!J6","v":"-"},{"$f":"'Scoring Sheet'!K6","v":"-"},{"$f":"'Scoring Sheet'!L6","v":"-"},{"$f":"'Scoring Sheet'!M6","v":"-"}]
[null,{"$f":"'Scoring Sheet'!B7","v":"Performance Under Heavy Traffic Loading"},{"$f":"'Scoring Sheet'!C7","v":{"$error":"#N/A"}},{"$f":"'Scoring Sheet'!I7","v":"-"},{"$f":"'Scoring Sheet'!J7","v":"-"},{"$f":"'Scoring Sheet'!K7","v":"-"},{"$f":"'Scoring Sheet'!L7","v":"-"},{"$f":"'Scoring Sheet'!M7","v":"-"}]
[null,{"$f":"'Scoring Sheet'!B8","v":"Performance Under Average Daily Traffic"},{"$f":"'Scoring Sheet'!C8","v":{"$error":"#N/A"}},{"$f":"'Scoring Sheet'!I8","v":"-"},{"$f":"'Scoring Sheet'!J8","v":"-"},{"$f":"'Scoring Sheet'!K8","v":"-"},{"$f":"'Scoring Sheet'!L8","v":"-"},{"$f":"'Scoring Sheet'!M8","v":"-"}]
[{"$f":"'Scoring Sheet'!A9","v":"User Satisfaction"},{"$f":"'Scoring Sheet'!B9","v":"Facility Downtime"},{"$f":"'Scoring Sheet'!C9","v":{"$error":"#N/A"}},{"$f":"'Scoring Sheet'!I9","v":"-"},{"$f":"'Scoring Sheet'!J9","v":"-"},{"$f":"'Scoring Sheet'!K9","v":"-"},{"$f":"'Scoring Sheet'!L9","v":"-"},{"$f":"'Scoring Sheet'!M9","v":"-"}]
[null,{"$f":"'Scoring Sheet'!B10","v":"Impact on Roughness"},{"$f":"'Scoring Sheet'!C10","v":{"$error":"#N/A"}},{"$f":"'Scoring Sheet'!I10","v":"-"},{"$f":"'Scoring Sheet'!J10","v":"-"},{"$f":"'Scoring Sheet'!K10","v":"-"},{"$f":"'Scoring Sheet'!L10","v":"-"},{"$f":"'Scoring Sheet'!M10","v":"-"}]
[null,{"$f":"'Scoring Sheet'!B11","v":"Impact on Friction"},{"$f":"'Scoring Sheet'!C11","v":{"$error":"#N/A"}},{"$f":"'Scoring Sheet'!I11","v":"-"},{"$f":"'Scoring Sheet'!J11","v":"-"},{"$f":"'Scoring Sheet'!K11","v":"-"},{"$f":"'Scoring Sheet'!L11","v":"-"},{"$f":"'Scoring Sheet'!M11","v":"-"}]
[null,{"$f":"'Scoring Sheet'!B12","v":"Noise"},{"$f":"'Scoring Sheet'!C12","v":{"$error":"#N/A"}},{"$f":"'Scoring Sheet'!I12","v":"-"},{"$f":"'Scoring Sheet'!J12","v":"-"},{"$f":"'Scoring Sheet'!K12","v":"-"},{"$f":"'Scoring Sheet'!L12","v":"-"},{"$f":"'Scoring Sheet'!M12","v":"-"}]
[{"$f":"'Scoring Sheet'!A13","v":"Procurement and Contracts"},{"$f":"'Scoring Sheet'!B13","v":"Availability of Qualified Contractors"},{"$f":"'Scoring Sheet'!C13","v":{"$error":"#N/A"}},{"$f":"'Scoring Sheet'!I13","v":"-"},{"$f":"'Scoring Sheet'!J13","v":"-"},{"$f":"'Scoring Sheet'!K13","v":"-"},{"$f":"'Scoring Sheet'!L13","v":"-"},{"$f":"'Scoring Sheet'!M13","v":"-"}]
[null,{"$f":"'Scoring Sheet'!B14","v":"Availability of Quality Materials"},{"$f":"'Scoring Sheet'!C14","v":{"$error":"#N/A"}},{"$f":"'Scoring Sheet'!I14","v":"-"},{"$f":"'Scoring Sheet'!J14","v":"-"},{"$f":"'Scoring Sheet'!K14","v":"-"},{"$f":"'Scoring Sheet'!L14","v":"-"},{"$f":"'Scoring Sheet'!M14","v":"-"}]
[{"$f":"'Scoring Sheet'!A15","v":"Environmental Sustainability"},{"$f":"'Scoring Sheet'!B15","v":"Negative Environmental Impact"},{"$f":"'Scoring Sheet'!C15","v":{"$error":"#N/A"}},{"$f":"'Scoring Sheet'!I15","v":"-"},{"$f":"'Scoring Sheet'!J15","v":"-"},{"$f":"'Scoring Sheet'!K15","v":"-"},{"$f":"'Scoring Sheet'!L15","v":"-"},{"$f":"'Scoring Sheet'!M15","v":"-"}]
[{"$f":"'Scoring Sheet'!A16","v":"Total Score"},null,null,{"$f":"'Scoring Sheet'!I16","v":0},{"$f":"'Scoring Sheet'!J16","v":0},{"$f":"'Scoring Sheet'!K16","v":0},{"$f":"'Scoring Sheet'!L16","v":0},{"$f":"'Scoring Sheet'!M16","v":0}]

{"sheet":"PCC Summary Sheet","index":20,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,1,1,5],[4,4,4,5],[11,1,11,5],[18,2,18,5],[19,2,19,5],[47,0,47,2],[32,1,32,5],[34,0,34,7],[35,0,36,0],[35,1,36,1],[35,2,36,2],[35,3,35,7],[37,0,39,0],[40,0,43,0],[44,0,45,0],[19,6,23,7],[25,2,25,3],[20,1,20,5],[22,1,22,5],[23,2,23,5],[21,2,21,5]]}
[null,{"$f":"'Project Information'!A1:A1","v":"Project Information "}]
[]
[null,{"$f":"'Project Information'!A3","v":"County/City"},{"$f":"'Project Information'!B3","v":0},null,{"$f":"'Project Information'!H3:H4","v":"Date "},{"$f":"'Project Information'!I3","v":"2016-02-24"}]
[null,{"$f":"'Project Information'!A4","v":"Name"},{"$f":"'Project Information'!B4","v":0},null,{"$f":"'Project Information'!H4:H5","v":"Estimated Letting date "},{"$f":"'Project Information'!I4","v":"00:00:00"}]
[null,{"$f":"'Project Information'!A5","v":"Project Engineer "},{"$f":"'Project Information'!B5","v":0},null,{"$f":"'Project Information'!H5:H6","v":"Location Data "},{"$f":"'Project Information'!I5:Q6","v":{"$error":"#VALUE!"}}]
[null,{"$f":"'Project Information'!A6","v":"Project Number "},{"$f":"'Project Information'!B6","v":0},null,{"$f":"'Project Information'!H6:H7","v":"Route"}]
[null,{"$f":"'Project Information'!A7","v":"Accounting ID "},{"$f":"'Project Information'!B7","v":0},null,{"$f":"'Project Information'!H7:H8","v":"Road Type "}]
[{"$nulls":4},{"$f":"'Project Information'!H8:H9","v":"Project Location From"}]
[null,{"$f":"'Project Information'!A9","v":"Pavement Surface Type"},{"$f":"'Project Information'!B9","v":0},null,{"$f":"'Project Information'!H9:H10","v":"Project Location To"}]
[null,{"$f":"'Project Information'!A10","v":"Length (miles)"},{"$f":"'Project Information'!B10","v":0}]
[null,{"$f":"'Project Information'!A11","v":"Number of Lanes"},{"$f":"'Project Information'!B11","v":0}]
[null,{"$f":"'PCC Surface Pavements'!A1:A1","v":"Distress Data"}]
[null,null,{"$f":"'PCC Surface Pavements'!B2","v":"Existence "},{"$f":"'PCC Surface Pavements'!C2","v":"Severity Level"},{"$f":"'PCC Surface Pavements'!D2","v":"Extent Level"},{"$f":"'PCC Surface Pavements'!E2","v":"Class"}]
[null,{"$f":"'PCC Surface Pavements'!A3","v":"Longitudinal Cracking "},{"$f":"'PCC Surface Pavements'!B3","v":0},{"$f":"'PCC Surface Pavements'!C3","v":0},{"$f":"'PCC Surface Pavements'!D3","v":0},{"$f":"'PCC Surface Pavements'!E3","v":"-"}]
[null,{"$f":"'PCC Surface Pavements'!A4","v":"Transverse Cracking"},{"$f":"'PCC Surface Pavements'!B4","v":0},{"$f":"'PCC Surface Pavements'!C4","v":0},{"$f":"'PCC Surface Pavements'!D4","v":0},{"$f":"'PCC Surface Pavements'!E4","v":"-"}]
[null,{"$f":"'PCC Surface Pavements'!A5","v":"D-Cracks "},{"$f":"'PCC Surface Pavements'!B5","v":0},{"$f":"'PCC Surface Pavements'!C5","v":0},{"$f":"'PCC Surface Pavements'!D5","v":0},{"$f":"'PCC Surface Pavements'!E5","v":"-"}]
[null,{"$f":"'PCC Surface Pavements'!A6","v":"Joint Spalling"},{"$f":"'PCC Surface Pavements'!B6","v":0},{"$f":"'PCC Surface Pavements'!C6","v":0},{"$f":"'PCC Surface Pavements'!D6","v":0},{"$f":"'PCC Surface Pavements'!E6","v":"-"}]
[null,{"$f":"'PCC Surface Pavements'!A7","v":"Faulting (JPCP)"},{"$f":"'PCC Surface Pavements'!B7","v":0},{"$f":"'PCC Surface Pavements'!C7","v":0},{"$f":"'PCC Surface Pavements'!D7","v":0},{"$f":"'PCC Surface Pavements'!E7","v":"-"}]
[null,{"$f":"'PCC Surface Pavements'!A8","v":"Roughness "},{"$f":"'PCC Surface Pavements'!B8","v":0}]
[null,{"$f":"'PCC Surface Pavements'!A9","v":"Skid Resistance"},{"$f":"'PCC Surface Pavements'!B9","v":0},null,null,null,"**Diamond grinding should be used in conjunction with load tranfer restoration treatment"]
[null,{"$f":"'PCC Surface Pavements'!A10","v":"Pavement Age"}]
[null,{"$f":"'PCC Surface Pavements'!A11","v":"Surface Age"},{"$f":"'PCC Surface Pavements'!B11","v":0}]
[null,{"$f":"'PCC Surface Pavements'!A12","v":"Distress Location and Distribution"}]
[null,{"$f":"'PCC Surface Pavements'!A13","v":"Joint Related?"},{"$f":"'PCC Surface Pavements'!B13","v":0}]
[]
["Cost Ranking","Non-Cost Ranking",{"$f":"'AC Surface Pavements'!A25","v":"Potential Action(s)"},null,"NPV ","EUAC","ROI","Service Life"]
[{"$f":"'Treatment Ranking I'!G2","v":"-"},{"$f":"'Potential Actions'!C3","v":"-"},{"$f":"'EUAC and ROI'!A8","v":"Action #1 "},{"$f":"'EUAC and ROI'!B8","v":"-"},{"$f":"IFERROR('EUAC and ROI'!AB22,\"-\")","v":"-"},{"$f":"'EUAC and ROI'!AB23","v":"-"},{"$f":"'EUAC and ROI'!AC25","v":"-"},{"$f":"'EUAC and ROI'!AA20","v":0}]
[{"$f":"'Treatment Ranking I'!G3","v":"-"},{"$f":"'Potential Actions'!C4","v":"-"},{"$f":"'EUAC and ROI'!A9","v":"Action #2"},{"$f":"'EUAC and ROI'!B9","v":"-"},{"$f":"IFERROR('EUAC and ROI'!AB35,\"-\")","v":"-"},{"$f":"'EUAC and ROI'!AB36","v":"-"},{"$f":"'EUAC and ROI'!AC38","v":"-"},{"$f":"'EUAC and ROI'!Z33","v":0}]
[{"$f":"'Treatment Ranking I'!G4","v":"-"},{"$f":"'Potential Actions'!C5","v":"-"},{"$f":"'EUAC and ROI'!A10","v":"Action #3"},{"$f":"'EUAC and ROI'!B10","v":"-"},{"$f":"IFERROR('EUAC and ROI'!AB48,\"-\")","v":"-"},{"$f":"'EUAC and ROI'!AB49","v":"-"},{"$f":"'EUAC and ROI'!AC51","v":"-"},{"$f":"'EUAC and ROI'!Z46","v":0}]
[{"$f":"'Treatment Ranking I'!G5","v":"-"},{"$f":"'Potential Actions'!C6","v":"-"},{"$f":"'EUAC and ROI'!A11","v":"Action #4"},{"$f":"'EUAC and ROI'!B11","v":"-"},{"$f":"'EUAC and ROI'!AB61","v":"-"},{"$f":"'EUAC and ROI'!AB62","v":"-"},{"$f":"'EUAC and ROI'!AC64","v":"-"},{"$f":"'EUAC and ROI'!Z59","v":0}]
[{"$f":"'Treatment Ranking I'!G6","v":"-"},{"$f":"'Potential Actions'!C7","v":"-"},{"$f":"'EUAC and ROI'!A12","v":"Action #5"},{"$f":"'EUAC and ROI'!B12","v":"-"},{"$f":"'EUAC and ROI'!Z74","v":"-"},{"$f":"'EUAC and ROI'!Z75","v":"-"},{"$f":"'EUAC and ROI'!AA77","v":"-"},{"$f":"'EUAC and ROI'!X72","v":0}]
[]
["Method of Weights Assignment ",{"$f":"'Weights Assignment'!A4:A4","v":0}]
[]
["Scoring Sheet"]
[{"$f":"'Scoring Sheet'!A5","v":"Category "},{"$f":"'Scoring Sheet'!B5","v":"Selection Criteria"},{"$f":"'Scoring Sheet'!C5","v":"Average Global Weight"},{"$f":"'Scoring Sheet'!I3:I3","v":"Weighted Scores"}]
[null,null,null,{"$f":"'Scoring Sheet'!I5","v":"-"},{"$f":"'Scoring Sheet'!J5","v":"-"},{"$f":"'Scoring Sheet'!K5","v":"-"},{"$f":"'Scoring Sheet'!L5","v":"-"},{"$f":"'Scoring Sheet'!M5","v":"-"}]
[{"$f":"'Scoring Sheet'!A6","v":"Performance"},{"$f":"'Scoring Sheet'!B6","v":"Pavement Structure Improvement"},{"$f":"'Scoring Sheet'!C6","v":{"$error":"#N/A"}},{"$f":"'Scoring Sheet'!I6","v":"-"},{"$f":"'Scoring Sheet'!J6","v":"-"},{"$f":"'Scoring Sheet'!K6","v":"-"},{"$f":"'Scoring Sheet'!L6","v":"-"},{"$f":"'Scoring Sheet'!M6","v":"-"}]
[null,{"$f":"'Scoring Sheet'!B7","v":"Performance Under Heavy Traffic Loading"},{"$f":"'Scoring Sheet'!C7","v":{"$error":"#N/A"}},{"$f":"'Scoring Sheet'!I7","v":"-"},{"$f":"'Scoring Sheet'!J7","v":"-"},{"$f":"'Scoring Sheet'!K7","v":"-"},{"$f":"'Scoring Sheet'!L7","v":"-"},{"$f":"'Scoring Sheet'!M7","v":"-"}]
[null,{"$f":"'Scoring Sheet'!B8","v":"Performance Under Average Daily Traffic"},{"$f":"'Scoring Sheet'!C8","v":{"$error":"#N/A"}},{"$f":"'Scoring Sheet'!I8","v":"-"},{"$f":"'Scoring Sheet'!J8","v":"-"},{"$f":"'Scoring Sheet'!K8","v":"-"},{"$f":"'Scoring Sheet'!L8","v":"-"},{"$f":"'Scoring Sheet'!M8","v":"-"}]
[{"$f":"'Scoring Sheet'!A9","v":"User Satisfaction"},{"$f":"'Scoring Sheet'!B9","v":"Facility Downtime"},{"$f":"'Scoring Sheet'!C9","v":{"$error":"#N/A"}},{"$f":"'Scoring Sheet'!I9","v":"-"},{"$f":"'Scoring Sheet'!J9","v":"-"},{"$f":"'Scoring Sheet'!K9","v":"-"},{"$f":"'Scoring Sheet'!L9","v":"-"},{"$f":"'Scoring Sheet'!M9","v":"-"}]
[null,{"$f":"'Scoring Sheet'!B10","v":"Impact on Roughness"},{"$f":"'Scoring Sheet'!C10","v":{"$error":"#N/A"}},{"$f":"'Scoring Sheet'!I10","v":"-"},{"$f":"'Scoring Sheet'!J10","v":"-"},{"$f":"'Scoring Sheet'!K10","v":"-"},{"$f":"'Scoring Sheet'!L10","v":"-"},{"$f":"'Scoring Sheet'!M10","v":"-"}]
[null,{"$f":"'Scoring Sheet'!B11","v":"Impact on Friction"},{"$f":"'Scoring Sheet'!C11","v":{"$error":"#N/A"}},{"$f":"'Scoring Sheet'!I11","v":"-"},{"$f":"'Scoring Sheet'!J11","v":"-"},{"$f":"'Scoring Sheet'!K11","v":"-"},{"$f":"'Scoring Sheet'!L11","v":"-"},{"$f":"'Scoring Sheet'!M11","v":"-"}]
[null,{"$f":"'Scoring Sheet'!B12","v":"Noise"},{"$f":"'Scoring Sheet'!C12","v":{"$error":"#N/A"}},{"$f":"'Scoring Sheet'!I12","v":"-"},{"$f":"'Scoring Sheet'!J12","v":"-"},{"$f":"'Scoring Sheet'!K12","v":"-"},{"$f":"'Scoring Sheet'!L12","v":"-"},{"$f":"'Scoring Sheet'!M12","v":"-"}]
[{"$f":"'Scoring Sheet'!A13","v":"Procurement and Contracts"},{"$f":"'Scoring Sheet'!B13","v":"Availability of Qualified Contractors"},{"$f":"'Scoring Sheet'!C13","v":{"$error":"#N/A"}},{"$f":"'Scoring Sheet'!I13","v":"-"},{"$f":"'Scoring Sheet'!J13","v":"-"},{"$f":"'Scoring Sheet'!K13","v":"-"},{"$f":"'Scoring Sheet'!L13","v":"-"},{"$f":"'Scoring Sheet'!M13","v":"-"}]
[null,{"$f":"'Scoring Sheet'!B14","v":"Availability of Quality Materials"},{"$f":"'Scoring Sheet'!C14","v":{"$error":"#N/A"}},{"$f":"'Scoring Sheet'!I14","v":"-"},{"$f":"'Scoring Sheet'!J14","v":"-"},{"$f":"'Scoring Sheet'!K14","v":"-"},{"$f":"'Scoring Sheet'!L14","v":"-"},{"$f":"'Scoring Sheet'!M14","v":"-"}]
[{"$f":"'Scoring Sheet'!A15","v":"Environmental Sustainability"},{"$f":"'Scoring Sheet'!B15","v":"Negative Environmental Impact"},{"$f":"'Scoring Sheet'!C15","v":{"$error":"#N/A"}},{"$f":"'Scoring Sheet'!I15","v":"-"},{"$f":"'Scoring Sheet'!J15","v":"-"},{"$f":"'Scoring Sheet'!K15","v":"-"},{"$f":"'Scoring Sheet'!L15","v":"-"},{"$f":"'Scoring Sheet'!M15","v":"-"}]
[{"$f":"'Scoring Sheet'!A16","v":"Total Score"},null,null,{"$f":"'Scoring Sheet'!I16","v":0},{"$f":"'Scoring Sheet'!J16","v":0},{"$f":"'Scoring Sheet'!K16","v":0},{"$f":"'Scoring Sheet'!L16","v":0},{"$f":"'Scoring Sheet'!M16","v":0}]

{"sheet":"AC Summary 1","index":21,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[23,1,23,2],[21,2,21,5],[22,2,22,5],[0,1,1,5],[4,4,4,5],[12,1,12,5],[18,2,18,5],[19,2,19,5],[20,1,20,5]]}
[null,{"$f":"'Project Information'!A1:A1","v":"Project Information "}]
[]
[null,{"$f":"'Project Information'!A3","v":"County/City"},{"$f":"'Project Information'!B3","v":0},null,{"$f":"'Project Information'!H3:H4","v":"Date "},{"$f":"'Project Information'!I3","v":"2016-02-24"}]
[null,{"$f":"'Project Information'!A4","v":"Name"},{"$f":"'Project Information'!B4","v":0},null,{"$f":"'Project Information'!H4:H5","v":"Estimated Letting date "},{"$f":"'Project Information'!I4","v":"00:00:00"}]
[null,{"$f":"'Project Information'!A5","v":"Project Engineer "},{"$f":"'Project Information'!B5","v":0},null,{"$f":"'Project Information'!H5:H6","v":"Location Data "},{"$f":"'Project Information'!I5:Q6","v":{"$error":"#VALUE!"}}]
[null,{"$f":"'Project Information'!A6","v":"Project Number "},{"$f":"'Project Information'!B6","v":0},null,{"$f":"'Project Information'!H6:H7","v":"Route"},{"$f":"'Project Information'!I6","v":0}]
[null,{"$f":"'Project Information'!A7","v":"Accounting ID "},{"$f":"'Project Information'!B7","v":0},null,{"$f":"'Project Information'!H7:H8","v":"Road Type "},{"$f":"'Project Information'!I7","v":0}]
[{"$nulls":4},{"$f":"'Project Information'!H8:H9","v":"Project Location From"},{"$f":"'Project Information'!I8","v":0}]
[null,{"$f":"'Project Information'!A9","v":"Pavement Surface Type"},{"$f":"'Project Information'!B9","v":0},null,{"$f":"'Project Information'!H9:H10","v":"Project Location To"},{"$f":"'Project Information'!I9","v":0}]
[null,{"$f":"'Project Information'!A10","v":"Length (miles)"},{"$f":"'Project Information'!B10","v":0}]
[null,{"$f":"'Project Information'!A11","v":"Number of Lanes"},{"$f":"'Project Information'!B11","v":0}]
[]
[null,{"$f":"'AC Surface Pavements'!A1:A1","v":"Distress Data"}]
[null,null,{"$f":"'AC Surface Pavements'!B2","v":"Existence "},{"$f":"'AC Surface Pavements'!C2","v":"Severity Level"},{"$f":"'AC Surface Pavements'!D2","v":"Extent Level"},{"$f":"'AC Surface Pavements'!E2","v":"Class"}]
[null,{"$f":"'AC Surface Pavements'!A3","v":"Longitudinal Cracking "},{"$f":"'AC Surface Pavements'!B3","v":0},{"$f":"'AC Surface Pavements'!C3","v":0},{"$f":"'AC Surface Pavements'!D3","v":0},{"$f":"'AC Surface Pavements'!E3","v":"-"}]
[null,{"$f":"'AC Surface Pavements'!A4","v":"Alligator Cracking"},{"$f":"'AC Surface Pavements'!B4","v":0},{"$f":"'AC Surface Pavements'!C4","v":0},{"$f":"'AC Surface Pavements'!D4","v":0},{"$f":"'AC Surface Pavements'!E4","v":"-"}]
[null,{"$f":"'AC Surface Pavements'!A5","v":"Transverse Cracking "},{"$f":"'AC Surface Pavements'!B5","v":0},{"$f":"'AC Surface Pavements'!C5","v":0},{"$f":"'AC Surface Pavements'!D5","v":0},{"$f":"'AC Surface Pavements'!E5","v":"-"}]
[null,{"$f":"'AC Surface Pavements'!A6","v":"Rutting"},{"$f":"'AC Surface Pavements'!B6","v":0},{"$f":"'AC Surface Pavements'!C6","v":0},{"$f":"'AC Surface Pavements'!D6","v":0},{"$f":"'AC Surface Pavements'!E6","v":"-"}]
[null,{"$f":"'AC Surface Pavements'!A7","v":"Roughness "},{"$f":"'AC Surface Pavements'!B7","v":0}]
[null,{"$f":"'AC Surface Pavements'!A8","v":"Friction"},{"$f":"'AC Surface Pavements'!B8","v":0}]
[null,{"$f":"'AC Surface Pavements'!A9","v":"Distress Distribution"}]
[null,{"$f":"'AC Surface Pavements'!A10","v":"Surface Age"},{"$f":"'AC Surface Pavements'!B10","v":0}]
[null,{"$f":"'AC Surface Pavements'!A11","v":"Distress Distribution"},{"$f":"'AC Surface Pavements'!B11","v":0}]
[null,{"$f":"'AC Surface Pavements'!A25","v":"Potential Action(s)"},{"$f":"'AC Surface Pavements'!B25","v":0}]
[null,{"$f":"'AC Surface Pavements'!A26","v":"Action #1 "},{"$f":"'AC Surface Pavements'!B26","v":"-"}]
[null,{"$f":"'AC Surface Pavements'!A27","v":"Action #2"},{"$f":"'AC Surface Pavements'!B27","v":"-"}]
[null,{"$f":"'AC Surface Pavements'!A28","v":"Action #3"},{"$f":"'AC Surface Pavements'!B28","v":"-"}]
[null,{"$f":"'AC Surface Pavements'!A29","v":"Action #4"},{"$f":"'AC Surface Pavements'!B29","v":"-"}]
[null,{"$f":"'AC Surface Pavements'!A30","v":"Action #5"},{"$f":"'AC Surface Pavements'!B30","v":"-"}]

{"sheet":"PCC Summary 1","index":22,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[[19,6,23,7],[20,1,20,5],[21,2,21,5],[22,1,22,5],[23,2,23,5],[24,1,24,2],[0,1,1,5],[4,4,4,5],[11,1,11,5],[18,2,18,5],[19,2,19,5]]}
[null,{"$f":"'Project Information'!A1:A1","v":"Project Information "}]
[]
[null,{"$f":"'Project Information'!A3","v":"County/City"},{"$f":"'Project Information'!B3","v":0},null,{"$f":"'Project Information'!H3:H4","v":"Date "},{"$f":"'Project Information'!I3","v":"2016-02-24"}]
[null,{"$f":"'Project Information'!A4","v":"Name"},{"$f":"'Project Information'!B4","v":0},null,{"$f":"'Project Information'!H4:H5","v":"Estimated Letting date "},{"$f":"'Project Information'!I4","v":"00:00:00"}]
[null,{"$f":"'Project Information'!A5","v":"Project Engineer "},{"$f":"'Project Information'!B5","v":0},null,{"$f":"'Project Information'!H5:H6","v":"Location Data "},{"$f":"'Project Information'!I5:Q6","v":{"$error":"#VALUE!"}}]
[null,{"$f":"'Project Information'!A6","v":"Project Number "},{"$f":"'Project Information'!B6","v":0},null,{"$f":"'Project Information'!H6:H7","v":"Route"},{"$f":"'Project Information'!I6","v":0}]
[null,{"$f":"'Project Information'!A7","v":"Accounting ID "},{"$f":"'Project Information'!B7","v":0},null,{"$f":"'Project Information'!H7:H8","v":"Road Type "},{"$f":"'Project Information'!I7","v":0}]
[{"$nulls":4},{"$f":"'Project Information'!H8:H9","v":"Project Location From"},{"$f":"'Project Information'!I8","v":0}]
[null,{"$f":"'Project Information'!A9","v":"Pavement Surface Type"},{"$f":"'Project Information'!B9","v":0},null,{"$f":"'Project Information'!H9:H10","v":"Project Location To"},{"$f":"'Project Information'!I9","v":0}]
[null,{"$f":"'Project Information'!A10","v":"Length (miles)"},{"$f":"'Project Information'!B10","v":0}]
[null,{"$f":"'Project Information'!A11","v":"Number of Lanes"},{"$f":"'Project Information'!B11","v":0}]
[null,{"$f":"'PCC Surface Pavements'!A1:A1","v":"Distress Data"}]
[null,null,{"$f":"'PCC Surface Pavements'!B2","v":"Existence "},{"$f":"'PCC Surface Pavements'!C2","v":"Severity Level"},{"$f":"'PCC Surface Pavements'!D2","v":"Extent Level"},{"$f":"'PCC Surface Pavements'!E2","v":"Class"}]
[null,{"$f":"'PCC Surface Pavements'!A3","v":"Longitudinal Cracking "},{"$f":"'PCC Surface Pavements'!B3","v":0},{"$f":"'PCC Surface Pavements'!C3","v":0},{"$f":"'PCC Surface Pavements'!D3","v":0},{"$f":"'PCC Surface Pavements'!E3","v":"-"}]
[null,{"$f":"'PCC Surface Pavements'!A4","v":"Transverse Cracking"},{"$f":"'PCC Surface Pavements'!B4","v":0},{"$f":"'PCC Surface Pavements'!C4","v":0},{"$f":"'PCC Surface Pavements'!D4","v":0},{"$f":"'PCC Surface Pavements'!E4","v":"-"}]
[null,{"$f":"'PCC Surface Pavements'!A5","v":"D-Cracks "},{"$f":"'PCC Surface Pavements'!B5","v":0},{"$f":"'PCC Surface Pavements'!C5","v":0},{"$f":"'PCC Surface Pavements'!D5","v":0},{"$f":"'PCC Surface Pavements'!E5","v":"-"}]
[null,{"$f":"'PCC Surface Pavements'!A6","v":"Joint Spalling"},{"$f":"'PCC Surface Pavements'!B6","v":0},{"$f":"'PCC Surface Pavements'!C6","v":0},{"$f":"'PCC Surface Pavements'!D6","v":0},{"$f":"'PCC Surface Pavements'!E6","v":"-"}]
[null,{"$f":"'PCC Surface Pavements'!A7","v":"Faulting (JPCP)"},{"$f":"'PCC Surface Pavements'!B7","v":0},{"$f":"'PCC Surface Pavements'!C7","v":0},{"$f":"'PCC Surface Pavements'!D7","v":0},{"$f":"'PCC Surface Pavements'!E7","v":"-"}]
[null,{"$f":"'PCC Surface Pavements'!A8","v":"Roughness "},{"$f":"'PCC Surface Pavements'!B8","v":0}]
[null,{"$f":"'PCC Surface Pavements'!A9","v":"Skid Resistance"},{"$f":"'PCC Surface Pavements'!B9","v":0},null,null,null,"**Diamond grinding should be used in conjunction with load tranfer restoration treatment"]
[null,{"$f":"'PCC Surface Pavements'!A10","v":"Pavement Age"}]
[null,{"$f":"'PCC Surface Pavements'!A11","v":"Surface Age"},{"$f":"'PCC Surface Pavements'!B11","v":0}]
[null,{"$f":"'PCC Surface Pavements'!A12","v":"Distress Location and Distribution"}]
[null,{"$f":"'PCC Surface Pavements'!A13","v":"Joint Related?"},{"$f":"'PCC Surface Pavements'!B13","v":0}]
[null,{"$f":"'PCC Surface Pavements'!A31","v":"Potential Action(s)"},{"$f":"'PCC Surface Pavements'!B31","v":0}]
[null,{"$f":"'PCC Surface Pavements'!A32","v":"Action #1 "},{"$f":"'PCC Surface Pavements'!B32","v":"-"}]
[null,{"$f":"'PCC Surface Pavements'!A33","v":"Action #2"},{"$f":"'PCC Surface Pavements'!B33","v":"-"}]
[null,{"$f":"'PCC Surface Pavements'!A34","v":"Action #3"},{"$f":"'PCC Surface Pavements'!B34","v":"-"}]
[null,{"$f":"'PCC Surface Pavements'!A35","v":"Action #4"},{"$f":"'PCC Surface Pavements'!B35","v":"-"}]
[null,{"$f":"'PCC Surface Pavements'!A36","v":"Action #5"},{"$f":"'PCC Surface Pavements'!B36","v":"-"}]