{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["INPUT","Analysis","Output","Macro","blank"],"not_rendered":{"charts":1,"images":7,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INPUT","index":0,"n_rows":35,"n_cols":36,"rows_kept":35,"cut":false,"hidden":true,"merged":[[6,16,7,16],[6,17,6,20],[7,12,7,14],[8,12,8,14],[9,12,9,14],[10,12,10,14],[11,11,11,15],[31,13,31,15],[31,2,31,12],[28,1,28,15],[14,1,14,15],[29,3,29,4],[29,7,29,8],[29,10,29,12],[29,13,29,15],[13,11,13,15],[12,11,12,15],[12,1,12,10],[15,15,24,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HMA (Dense Graded) with PG 64-22 binder",60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HMA (Dense Graded) with PG 64E-22 binder",70]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stone Matrix Asphalt (SMA)",80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High Performance Thin Overlay (HPTO)",80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ultra-Thin Friction Course(UTFC)",80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Open Graded Mix",80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gap Graded Mix",80]
[null,"M-Bid Price of Milling existing HMA per Square Yard",null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bridge Deck Waterproof Surface Course(BDWSC)",250]
[null,"P-Bid Price of Surface Course Mix (final riding surface), per Ton",null,null,null,null,null,null,null,null,null,null,70]
[null,"D-Thickness of surface course lift (final riding surface)",null,null,null,null,null,null,null,null,null,null,2]
[null,"Is Special Provisions include Minimum value of \"P\" ? ",null,null,null,null,null,null,null,null,null,null,"YES"]
[null,"Select HMA Surface Course Mix",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L12=AI1,AJ1,IF(L12=AI2,AJ2,IF(L12=AI3,AJ3,IF(L12=AI4,AJ4,IF(L12=AI5,AJ5,IF(L12=AI6,AJ6,IF(L12=AI7,AJ7,(IF(L12=AI8,AJ8)))))))))","v":false},null,null,{"$f":"IF(L12=AI1,1,IF(L12=AI2,2,IF(L12=AI3,3,IF(L12=AI4,4,IF(L12=AI5,5,IF(L12=AI6,6,IF(L12=AI7,7,IF(L12=AI8,8))))))))","v":false}]
[null,"Enter Minimum \"P\" value from table in Special Provisions",null,null,null,null,null,null,null,null,null,80]
[null,"COEFFICIENTS FROM PAY ADJUSTMENT EQUATION",null,null,null,null,null,null,null,null,null,{"$f":"IF(M11=\"Yes\",IF(M9<Q12,\"Surface Course Bid Price is less than Minimum value of P.Verify  P value in Special provisions as it will be used for PA analyses.\",\"\"),\"\")","v":"Surface Course Bid Price is less than Minimum value of P.Verify  P value in Special provisions as it will be used for PA analyses."}]
[null,"Sample Pay adjustment equation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(L12,AI1:AJ8,2)","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Please enter above COEFFICIENTS from pay adjustment equation of a project to be analyzed"]
[null,null,"X=",-37.75347,null,null,"Y=",194.87,null,null,"Target IRI,",null,null,60]
[]
[null,null,"IRI interval for Pay adjustment Calculation",null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M11=\"Yes\",ROUND(1267.2*((M8/9)+((M10*Q12)/(150))),0),0)","v":282}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1267.2*((M8/9)+((M10*M9)/(150)))","v":1464.32}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z34>Z33,Z34,Z33)","v":1464.32}]

{"sheet":"Analysis","index":1,"n_rows":183,"n_cols":18,"rows_kept":183,"cut":false,"hidden":true,"merged":[]}
["Unit price of milling",null,null,{"$f":"INPUT!M8","v":2},null,null,null,null,null,null,null,null,"Version","2.01",null,null,null,"Input"]
["Paving price",null,null,{"$f":"INPUT!M9","v":70},null,null,null,null,null,null,null,null,"Last Updated on","2019-04-10"]
["Thickness",null,null,{"$f":"INPUT!M10","v":2}]
["A=",null,null,{"$f":"INPUT!Z35","v":1464.32}]
[null,null,null,{"$f":"(D7*LN(D6))+D8","v":40.294285400484796}]
["Target",null,null,{"$f":"INPUT!N30","v":60}]
[null,null,null,{"$f":"INPUT!D30","v":-37.75347},null,{"$f":"CONCATENATE(\"Target IRI = \",D6,\" Inch/Mile\")","v":"Target IRI = 60 Inch/Mile"}]
[null,null,null,{"$f":"INPUT!H30","v":194.87}]
["interval",null,null,{"$f":"INPUT!N32","v":1},{"$f":"IF(F9=0,1,F9)","v":1},{"$f":"(IF(D9=5,5,(IF(D9=10,5,(IF(D9=17,1,(IF(D9=34,2,(IF(D9=85,1,170-(ROUNDDOWN(170/D9,1))*D9))))))))))","v":0}]
["  +ve side",null,null,{"$f":"ROUNDUP((D6-1)/D9,0)","v":59}]
[" -veside",null,null,{"$f":"ROUNDUP((170-D6)/D9,0)","v":110}]
[1,{"$f":"IF(A12=\"\",\"\",(IF(A12=$D$6,0,(IF(ROUND(($D$4/$D$5)-($D$4/($D$7*LN(A12)+$D$8)),0)<-$D$4,ROUND(-$D$4,0),ROUND(($D$4/$D$5)-($D$4/($D$7*LN(A12)+$D$8)),0))))))","v":29},{"$f":"IF(A12=\"\",\"\",A12)","v":1},{"$f":"IF(C12=\"\",\"\",(IF(C12=$D$6,0,(IF(ROUND(($D$4/$D$5)-($D$4/($D$7*LN(C12)+$D$8)),0)<-$D$4,ROUND(-$D$4,0),ROUND(($D$4/$D$5)-($D$4/($D$7*LN(C12)+$D$8)),0))))))","v":29}]
[2,{"$f":"IF(A13=\"\",\"\",(IF(A13=$D$6,0,(IF(ROUND(($D$4/$D$5)-($D$4/($D$7*LN(A13)+$D$8)),0)<-$D$4,ROUND(-$D$4,0),ROUND(($D$4/$D$5)-($D$4/($D$7*LN(A13)+$D$8)),0))))))","v":28},2,{"$f":"IF(C13=\"\",\"\",(IF(C13=$D$6,0,(IF(ROUND(($D$4/$D$5)-($D$4/($D$7*LN(C13)+$D$8)),0)<-$D$4,ROUND(-$D$4,0),ROUND(($D$4/$D$5)-($D$4/($D$7*LN(C13)+$D$8)),0))))))","v":28}]
[3,27,3,27,null,null,181]
[4,26,4,26,null,null,170]
[5,25,5,25]
[6,25,6,25]
[7,24,7,24]
[8,24,8,24]
[9,23,9,23]
[10,23,10,23]
[11,22,11,22]
[12,22,12,22]
[13,21,13,21]
[14,21,14,21]
[15,21,15,21]
[16,20,16,20]
[17,20,17,20]
[18,19,18,19]
[19,19,19,19]
[20,18,20,18]
[21,18,21,18]
[22,18,22,18]
[23,17,23,17]
[24,17,24,17]
[25,16,25,16]
[26,16,26,16]
[27,16,27,16]
[28,15,28,15]
[29,15,29,15]
[30,14,30,14]
[31,14,31,14]
[32,13,32,13]
[33,13,33,13]
[34,13,34,13]
[35,12,35,12]
[36,12,36,12]
[37,11,37,11]
[38,11,38,11]
[39,10,39,10]
[40,10,40,10]
[41,10,41,10]
[42,9,42,9]
[43,9,43,9]
[44,8,44,8]
[45,8,45,8]
[46,7,46,7]
[47,7,47,7]
[48,6,48,6]
[49,6,49,6]
[50,5,50,5]
[51,5,51,5]
[52,4,52,4]
[53,4,53,4]
[54,3,54,3]
[55,3,55,3]
[56,2,56,2]
[57,2,57,2]
[58,1,58,1]
[59,1,59,1]
[60,0,60,0]
[61,-1,61,-1]
[62,-1,62,-1]
[63,-2,63,-2]
[64,-2,64,-2]
[65,-3,65,-3]
[66,{"$f":"IF(A77=\"\",\"\",(IF(A77=$D$6,0,(IF(ROUND(($D$4/$D$5)-($D$4/($D$7*LN(A77)+$D$8)),0)<-$D$4,ROUND(-$D$4,0),ROUND(($D$4/$D$5)-($D$4/($D$7*LN(A77)+$D$8)),0))))))","v":-4},66,{"$f":"IF(C77=\"\",\"\",(IF(C77=$D$6,0,(IF(ROUND(($D$4/$D$5)-($D$4/($D$7*LN(C77)+$D$8)),0)<-$D$4,ROUND(-$D$4,0),ROUND(($D$4/$D$5)-($D$4/($D$7*LN(C77)+$D$8)),0))))))","v":-4}]
[67,-4,67,-4]
[68,-5,68,-5]
[69,-5,69,-5]
[70,-6,70,-6]
[71,-7,71,-7]
[72,-7,72,-7]
[73,-8,73,-8]
[74,-9,74,-9]
[75,-10,75,-10]
[76,-10,76,-10]
[77,-11,77,-11]
[78,-12,78,-12]
[79,-13,79,-13]
[80,-13,80,-13]
[81,-14,81,-14]
[82,-15,82,-15]
[83,-16,83,-16]
[84,-17,84,-17]
[85,-18,85,-18]
[86,-18,86,-18]
[87,-19,87,-19]
[88,-20,88,-20]
[89,-21,89,-21]
[90,-22,90,-22]
[91,-23,91,-23]
[92,-24,92,-24]
[93,-25,93,-25]
[94,-26,94,-26]
[95,-27,95,-27]
[96,-29,96,-29]
[97,-30,97,-30]
[98,-31,98,-31]
[99,-32,99,-32]
[100,-33,100,-33]
[101,-35,101,-35]
[102,-36,102,-36]
[103,-37,103,-37]
[104,-39,104,-39]
[105,-40,105,-40]
[106,-42,106,-42]
[107,-43,107,-43]
[108,-45,108,-45]
[109,-46,109,-46]
[110,-48,110,-48]
[111,-49,111,-49]
[112,-51,112,-51]
[113,-53,113,-53]
[114,-55,114,-55]
[115,-57,115,-57]
[116,-59,116,-59]
[117,-61,117,-61]
[118,-63,118,-63]
[119,-65,119,-65]
[120,-67,120,-67]
[121,-70,121,-70]
[122,-72,122,-72]
[123,-75,123,-75]
[124,-77,124,-77]
[125,-80,125,-80]
[126,-83,126,-83]
[127,-86,127,-86]
[128,-89,128,-89]
[129,-92,129,-92]
[130,{"$f":"IF(A141=\"\",\"\",(IF(A141=$D$6,0,(IF(ROUND(($D$4/$D$5)-($D$4/($D$7*LN(A141)+$D$8)),0)<-$D$4,ROUND(-$D$4,0),ROUND(($D$4/$D$5)-($D$4/($D$7*LN(A141)+$D$8)),0))))))","v":-96},130,{"$f":"IF(C141=\"\",\"\",(IF(C141=$D$6,0,(IF(ROUND(($D$4/$D$5)-($D$4/($D$7*LN(C141)+$D$8)),0)<-$D$4,ROUND(-$D$4,0),ROUND(($D$4/$D$5)-($D$4/($D$7*LN(C141)+$D$8)),0))))))","v":-96}]
[131,-99,131,-99]
[132,-103,132,-103]
[133,-107,133,-107]
[134,-111,134,-111]
[135,-115,135,-115]
[136,-119,136,-119]
[137,-124,137,-124]
[138,-129,138,-129]
[139,-134,139,-134]
[140,-140,140,-140]
[141,-146,141,-146]
[142,-152,142,-152]
[143,-159,143,-159]
[144,-166,144,-166]
[145,-173,145,-173]
[146,-182,146,-182]
[147,-190,147,-190]
[148,-200,148,-200]
[149,-210,149,-210]
[150,-221,150,-221]
[151,-232,151,-232]
[152,-245,152,-245]
[153,-259,153,-259]
[154,-275,154,-275]
[155,-292,155,-292]
[156,-311,156,-311]
[157,-332,157,-332]
[158,-355,158,-355]
[159,-382,159,-382]
[160,-412,160,-412]
[161,-447,161,-447]
[162,-487,162,-487]
[163,-535,163,-535]
[164,-591,164,-591]
[165,-660,165,-660]
[166,-745,166,-745]
[167,-852,167,-852]
[168,-993,168,-993]
[169,-1185,169,-1185]
[170,-1464,170,-1464]
[null,""]
[null,"",{"$f":"IF(A183=\"\",\"\",A183)","v":""}]

{"sheet":"Output","index":2,"n_rows":198,"n_cols":15,"rows_kept":198,"cut":false,"hidden":true,"merged":[[17,11,18,11],[8,1,8,3],[15,1,15,2],[16,2,16,6],[47,0,47,4],[47,5,47,13],[14,3,14,4],[14,10,14,11],[17,6,18,6],[17,7,17,10],[18,7,18,10],[17,2,18,4],[20,1,20,11],[17,5,18,5],[16,7,16,11],[9,12,11,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INPUT"]
[null,null,"M-Bid Price of Milling existing HMA per Square Yard",null,null,null,null,null,null,null,null,{"$f":"INPUT!M8","v":2},{"$f":"INPUT!L14","v":"Surface Course Bid Price is less than Minimum value of P.Verify  P value in Special provisions as it will be used for PA analyses."}]
[null,null,"P-Bid Price of Surface Course Mix (final riding surface) per Ton",null,null,null,null,null,null,null,null,{"$f":"IF(INPUT!M11=\"YES\",(IF(INPUT!M9<INPUT!Q12,INPUT!Q12,INPUT!M9)),INPUT!M9)","v":false},null,null,{"$f":"INPUT!M11","v":"YES"}]
[null,null,"D-Thickness of surface course lift (final riding surface), Inch",null,null,null,null,null,null,null,null,{"$f":"INPUT!M10","v":2}]
[null,null,"Pay adjustment Factors"]
[]
[null,null,"X=",{"$f":"Analysis!D7","v":-37.75347},null,null,null,null,null,"Y=",{"$f":"Analysis!D8","v":194.87}]
[null,"RESULTS"]
[null,null,"TARGET IRI =",null,null,null,null,{"$f":"Analysis!D6","v":60}]
[null,null,"Pay Adjustment ($) =",null,null,{"$f":"Analysis!D4/Analysis!D5","v":36.340637026966164}," -",{"$f":"Analysis!D4","v":1464.32}]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(D15,\"X\",\"LN(IRI)\",\" + \",K15)","v":"-37.75347XLN(IRI) + 194.87"}]
[]
[null,"PAY ADJUSTMENT "]
["IRI","PA","IRI","PA","IRI","PA","IRI","PA","IRI","PA","IRI","PA","IRI","PA"]
[{"$f":"IF(Analysis!B12=\"\",\"\",Analysis!A12)","v":1},{"$f":"IF(Analysis!B12=\"\",\"\",Analysis!B12)","v":29},{"$f":"IF(Analysis!B37=\"\",\"\",Analysis!A37)","v":26},{"$f":"IF(Analysis!B37=\"\",\"\",Analysis!B37)","v":16},{"$f":"IF(Analysis!B62=\"\",\"\",Analysis!A62)","v":51},{"$f":"IF(Analysis!B62=\"\",\"\",Analysis!B62)","v":5},{"$f":"IF(Analysis!B87=\"\",\"\",Analysis!A87)","v":76},{"$f":"IF(Analysis!B87=\"\",\"\",Analysis!B87)","v":-10},{"$f":"IF(Analysis!B112=\"\",\"\",Analysis!A112)","v":101},{"$f":"IF(Analysis!B112=\"\",\"\",Analysis!B112)","v":-35},{"$f":"IF(Analysis!B137=\"\",\"\",Analysis!A137)","v":126},{"$f":"IF(Analysis!B137=\"\",\"\",Analysis!B137)","v":-83},{"$f":"IF(Analysis!B162=\"\",\"\",Analysis!A162)","v":151},{"$f":"IF(Analysis!B162=\"\",\"\",Analysis!B162)","v":-232}]
[{"$f":"IF(Analysis!B13=\"\",\"\",Analysis!A13)","v":2},{"$f":"IF(Analysis!B13=\"\",\"\",Analysis!B13)","v":28},{"$f":"IF(Analysis!B38=\"\",\"\",Analysis!A38)","v":27},{"$f":"IF(Analysis!B38=\"\",\"\",Analysis!B38)","v":16},{"$f":"IF(Analysis!B63=\"\",\"\",Analysis!A63)","v":52},{"$f":"IF(Analysis!B63=\"\",\"\",Analysis!B63)","v":4},{"$f":"IF(Analysis!B88=\"\",\"\",Analysis!A88)","v":77},{"$f":"IF(Analysis!B88=\"\",\"\",Analysis!B88)","v":-11},{"$f":"IF(Analysis!B113=\"\",\"\",Analysis!A113)","v":102},{"$f":"IF(Analysis!B113=\"\",\"\",Analysis!B113)","v":-36},{"$f":"IF(Analysis!B138=\"\",\"\",Analysis!A138)","v":127},{"$f":"IF(Analysis!B138=\"\",\"\",Analysis!B138)","v":-86},{"$f":"IF(Analysis!B163=\"\",\"\",Analysis!A163)","v":152},{"$f":"IF(Analysis!B163=\"\",\"\",Analysis!B163)","v":-245}]
[{"$f":"IF(Analysis!B14=\"\",\"\",Analysis!A14)","v":3},{"$f":"IF(Analysis!B14=\"\",\"\",Analysis!B14)","v":27},{"$f":"IF(Analysis!B39=\"\",\"\",Analysis!A39)","v":28},{"$f":"IF(Analysis!B39=\"\",\"\",Analysis!B39)","v":15},{"$f":"IF(Analysis!B64=\"\",\"\",Analysis!A64)","v":53},{"$f":"IF(Analysis!B64=\"\",\"\",Analysis!B64)","v":4},{"$f":"IF(Analysis!B89=\"\",\"\",Analysis!A89)","v":78},{"$f":"IF(Analysis!B89=\"\",\"\",Analysis!B89)","v":-12},{"$f":"IF(Analysis!B114=\"\",\"\",Analysis!A114)","v":103},{"$f":"IF(Analysis!B114=\"\",\"\",Analysis!B114)","v":-37},{"$f":"IF(Analysis!B139=\"\",\"\",Analysis!A139)","v":128},{"$f":"IF(Analysis!B139=\"\",\"\",Analysis!B139)","v":-89},{"$f":"IF(Analysis!B164=\"\",\"\",Analysis!A164)","v":153},{"$f":"IF(Analysis!B164=\"\",\"\",Analysis!B164)","v":-259}]
[{"$f":"IF(Analysis!B15=\"\",\"\",Analysis!A15)","v":4},{"$f":"IF(Analysis!B15=\"\",\"\",Analysis!B15)","v":26},{"$f":"IF(Analysis!B40=\"\",\"\",Analysis!A40)","v":29},{"$f":"IF(Analysis!B40=\"\",\"\",Analysis!B40)","v":15},{"$f":"IF(Analysis!B65=\"\",\"\",Analysis!A65)","v":54},{"$f":"IF(Analysis!B65=\"\",\"\",Analysis!B65)","v":3},{"$f":"IF(Analysis!B90=\"\",\"\",Analysis!A90)","v":79},{"$f":"IF(Analysis!B90=\"\",\"\",Analysis!B90)","v":-13},{"$f":"IF(Analysis!B115=\"\",\"\",Analysis!A115)","v":104},{"$f":"IF(Analysis!B115=\"\",\"\",Analysis!B115)","v":-39},{"$f":"IF(Analysis!B140=\"\",\"\",Analysis!A140)","v":129},{"$f":"IF(Analysis!B140=\"\",\"\",Analysis!B140)","v":-92},{"$f":"IF(Analysis!B165=\"\",\"\",Analysis!A165)","v":154},{"$f":"IF(Analysis!B165=\"\",\"\",Analysis!B165)","v":-275}]
[{"$f":"IF(Analysis!B16=\"\",\"\",Analysis!A16)","v":5},{"$f":"IF(Analysis!B16=\"\",\"\",Analysis!B16)","v":25},{"$f":"IF(Analysis!B41=\"\",\"\",Analysis!A41)","v":30},{"$f":"IF(Analysis!B41=\"\",\"\",Analysis!B41)","v":14},{"$f":"IF(Analysis!B66=\"\",\"\",Analysis!A66)","v":55},{"$f":"IF(Analysis!B66=\"\",\"\",Analysis!B66)","v":3},{"$f":"IF(Analysis!B91=\"\",\"\",Analysis!A91)","v":80},{"$f":"IF(Analysis!B91=\"\",\"\",Analysis!B91)","v":-13},{"$f":"IF(Analysis!B116=\"\",\"\",Analysis!A116)","v":105},{"$f":"IF(Analysis!B116=\"\",\"\",Analysis!B116)","v":-40},{"$f":"IF(Analysis!B141=\"\",\"\",Analysis!A141)","v":130},{"$f":"IF(Analysis!B141=\"\",\"\",Analysis!B141)","v":-96},{"$f":"IF(Analysis!B166=\"\",\"\",Analysis!A166)","v":155},{"$f":"IF(Analysis!B166=\"\",\"\",Analysis!B166)","v":-292}]
[{"$f":"IF(Analysis!B17=\"\",\"\",Analysis!A17)","v":6},{"$f":"IF(Analysis!B17=\"\",\"\",Analysis!B17)","v":25},{"$f":"IF(Analysis!B42=\"\",\"\",Analysis!A42)","v":31},{"$f":"IF(Analysis!B42=\"\",\"\",Analysis!B42)","v":14},{"$f":"IF(Analysis!B67=\"\",\"\",Analysis!A67)","v":56},{"$f":"IF(Analysis!B67=\"\",\"\",Analysis!B67)","v":2},{"$f":"IF(Analysis!B92=\"\",\"\",Analysis!A92)","v":81},{"$f":"IF(Analysis!B92=\"\",\"\",Analysis!B92)","v":-14},{"$f":"IF(Analysis!B117=\"\",\"\",Analysis!A117)","v":106},{"$f":"IF(Analysis!B117=\"\",\"\",Analysis!B117)","v":-42},{"$f":"IF(Analysis!B142=\"\",\"\",Analysis!A142)","v":131},{"$f":"IF(Analysis!B142=\"\",\"\",Analysis!B142)","v":-99},{"$f":"IF(Analysis!B167=\"\",\"\",Analysis!A167)","v":156},{"$f":"IF(Analysis!B167=\"\",\"\",Analysis!B167)","v":-311}]
[{"$f":"IF(Analysis!B18=\"\",\"\",Analysis!A18)","v":7},{"$f":"IF(Analysis!B18=\"\",\"\",Analysis!B18)","v":24},{"$f":"IF(Analysis!B43=\"\",\"\",Analysis!A43)","v":32},{"$f":"IF(Analysis!B43=\"\",\"\",Analysis!B43)","v":13},{"$f":"IF(Analysis!B68=\"\",\"\",Analysis!A68)","v":57},{"$f":"IF(Analysis!B68=\"\",\"\",Analysis!B68)","v":2},{"$f":"IF(Analysis!B93=\"\",\"\",Analysis!A93)","v":82},{"$f":"IF(Analysis!B93=\"\",\"\",Analysis!B93)","v":-15},{"$f":"IF(Analysis!B118=\"\",\"\",Analysis!A118)","v":107},{"$f":"IF(Analysis!B118=\"\",\"\",Analysis!B118)","v":-43},{"$f":"IF(Analysis!B143=\"\",\"\",Analysis!A143)","v":132},{"$f":"IF(Analysis!B143=\"\",\"\",Analysis!B143)","v":-103},{"$f":"IF(Analysis!B168=\"\",\"\",Analysis!A168)","v":157},{"$f":"IF(Analysis!B168=\"\",\"\",Analysis!B168)","v":-332}]
[{"$f":"IF(Analysis!B19=\"\",\"\",Analysis!A19)","v":8},{"$f":"IF(Analysis!B19=\"\",\"\",Analysis!B19)","v":24},{"$f":"IF(Analysis!B44=\"\",\"\",Analysis!A44)","v":33},{"$f":"IF(Analysis!B44=\"\",\"\",Analysis!B44)","v":13},{"$f":"IF(Analysis!B69=\"\",\"\",Analysis!A69)","v":58},{"$f":"IF(Analysis!B69=\"\",\"\",Analysis!B69)","v":1},{"$f":"IF(Analysis!B94=\"\",\"\",Analysis!A94)","v":83},{"$f":"IF(Analysis!B94=\"\",\"\",Analysis!B94)","v":-16},{"$f":"IF(Analysis!B119=\"\",\"\",Analysis!A119)","v":108},{"$f":"IF(Analysis!B119=\"\",\"\",Analysis!B119)","v":-45},{"$f":"IF(Analysis!B144=\"\",\"\",Analysis!A144)","v":133},{"$f":"IF(Analysis!B144=\"\",\"\",Analysis!B144)","v":-107},{"$f":"IF(Analysis!B169=\"\",\"\",Analysis!A169)","v":158},{"$f":"IF(Analysis!B169=\"\",\"\",Analysis!B169)","v":-355}]
[{"$f":"IF(Analysis!B20=\"\",\"\",Analysis!A20)","v":9},{"$f":"IF(Analysis!B20=\"\",\"\",Analysis!B20)","v":23},{"$f":"IF(Analysis!B45=\"\",\"\",Analysis!A45)","v":34},{"$f":"IF(Analysis!B45=\"\",\"\",Analysis!B45)","v":13},{"$f":"IF(Analysis!B70=\"\",\"\",Analysis!A70)","v":59},{"$f":"IF(Analysis!B70=\"\",\"\",Analysis!B70)","v":1},{"$f":"IF(Analysis!B95=\"\",\"\",Analysis!A95)","v":84},{"$f":"IF(Analysis!B95=\"\",\"\",Analysis!B95)","v":-17},{"$f":"IF(Analysis!B120=\"\",\"\",Analysis!A120)","v":109},{"$f":"IF(Analysis!B120=\"\",\"\",Analysis!B120)","v":-46},{"$f":"IF(Analysis!B145=\"\",\"\",Analysis!A145)","v":134},{"$f":"IF(Analysis!B145=\"\",\"\",Analysis!B145)","v":-111},{"$f":"IF(Analysis!B170=\"\",\"\",Analysis!A170)","v":159},{"$f":"IF(Analysis!B170=\"\",\"\",Analysis!B170)","v":-382}]
[{"$f":"IF(Analysis!B21=\"\",\"\",Analysis!A21)","v":10},{"$f":"IF(Analysis!B21=\"\",\"\",Analysis!B21)","v":23},{"$f":"IF(Analysis!B46=\"\",\"\",Analysis!A46)","v":35},{"$f":"IF(Analysis!B46=\"\",\"\",Analysis!B46)","v":12},{"$f":"IF(Analysis!B71=\"\",\"\",Analysis!A71)","v":60},{"$f":"IF(Analysis!B71=\"\",\"\",Analysis!B71)","v":0},{"$f":"IF(Analysis!B96=\"\",\"\",Analysis!A96)","v":85},{"$f":"IF(Analysis!B96=\"\",\"\",Analysis!B96)","v":-18},{"$f":"IF(Analysis!B121=\"\",\"\",Analysis!A121)","v":110},{"$f":"IF(Analysis!B121=\"\",\"\",Analysis!B121)","v":-48},{"$f":"IF(Analysis!B146=\"\",\"\",Analysis!A146)","v":135},{"$f":"IF(Analysis!B146=\"\",\"\",Analysis!B146)","v":-115},{"$f":"IF(Analysis!B171=\"\",\"\",Analysis!A171)","v":160},{"$f":"IF(Analysis!B171=\"\",\"\",Analysis!B171)","v":-412}]
[{"$f":"IF(Analysis!B22=\"\",\"\",Analysis!A22)","v":11},{"$f":"IF(Analysis!B22=\"\",\"\",Analysis!B22)","v":22},{"$f":"IF(Analysis!B47=\"\",\"\",Analysis!A47)","v":36},{"$f":"IF(Analysis!B47=\"\",\"\",Analysis!B47)","v":12},{"$f":"IF(Analysis!B72=\"\",\"\",Analysis!A72)","v":61},{"$f":"IF(Analysis!B72=\"\",\"\",Analysis!B72)","v":-1},{"$f":"IF(Analysis!B97=\"\",\"\",Analysis!A97)","v":86},{"$f":"IF(Analysis!B97=\"\",\"\",Analysis!B97)","v":-18},{"$f":"IF(Analysis!B122=\"\",\"\",Analysis!A122)","v":111},{"$f":"IF(Analysis!B122=\"\",\"\",Analysis!B122)","v":-49},{"$f":"IF(Analysis!B147=\"\",\"\",Analysis!A147)","v":136},{"$f":"IF(Analysis!B147=\"\",\"\",Analysis!B147)","v":-119},{"$f":"IF(Analysis!B172=\"\",\"\",Analysis!A172)","v":161},{"$f":"IF(Analysis!B172=\"\",\"\",Analysis!B172)","v":-447}]
[{"$f":"IF(Analysis!B23=\"\",\"\",Analysis!A23)","v":12},{"$f":"IF(Analysis!B23=\"\",\"\",Analysis!B23)","v":22},{"$f":"IF(Analysis!B48=\"\",\"\",Analysis!A48)","v":37},{"$f":"IF(Analysis!B48=\"\",\"\",Analysis!B48)","v":11},{"$f":"IF(Analysis!B73=\"\",\"\",Analysis!A73)","v":62},{"$f":"IF(Analysis!B73=\"\",\"\",Analysis!B73)","v":-1},{"$f":"IF(Analysis!B98=\"\",\"\",Analysis!A98)","v":87},{"$f":"IF(Analysis!B98=\"\",\"\",Analysis!B98)","v":-19},{"$f":"IF(Analysis!B123=\"\",\"\",Analysis!A123)","v":112},{"$f":"IF(Analysis!B123=\"\",\"\",Analysis!B123)","v":-51},{"$f":"IF(Analysis!B148=\"\",\"\",Analysis!A148)","v":137},{"$f":"IF(Analysis!B148=\"\",\"\",Analysis!B148)","v":-124},{"$f":"IF(Analysis!B173=\"\",\"\",Analysis!A173)","v":162},{"$f":"IF(Analysis!B173=\"\",\"\",Analysis!B173)","v":-487}]
[{"$f":"IF(Analysis!B24=\"\",\"\",Analysis!A24)","v":13},{"$f":"IF(Analysis!B24=\"\",\"\",Analysis!B24)","v":21},{"$f":"IF(Analysis!B49=\"\",\"\",Analysis!A49)","v":38},{"$f":"IF(Analysis!B49=\"\",\"\",Analysis!B49)","v":11},{"$f":"IF(Analysis!B74=\"\",\"\",Analysis!A74)","v":63},{"$f":"IF(Analysis!B74=\"\",\"\",Analysis!B74)","v":-2},{"$f":"IF(Analysis!B99=\"\",\"\",Analysis!A99)","v":88},{"$f":"IF(Analysis!B99=\"\",\"\",Analysis!B99)","v":-20},{"$f":"IF(Analysis!B124=\"\",\"\",Analysis!A124)","v":113},{"$f":"IF(Analysis!B124=\"\",\"\",Analysis!B124)","v":-53},{"$f":"IF(Analysis!B149=\"\",\"\",Analysis!A149)","v":138},{"$f":"IF(Analysis!B149=\"\",\"\",Analysis!B149)","v":-129},{"$f":"IF(Analysis!B174=\"\",\"\",Analysis!A174)","v":163},{"$f":"IF(Analysis!B174=\"\",\"\",Analysis!B174)","v":-535}]
[{"$f":"IF(Analysis!B25=\"\",\"\",Analysis!A25)","v":14},{"$f":"IF(Analysis!B25=\"\",\"\",Analysis!B25)","v":21},{"$f":"IF(Analysis!B50=\"\",\"\",Analysis!A50)","v":39},{"$f":"IF(Analysis!B50=\"\",\"\",Analysis!B50)","v":10},{"$f":"IF(Analysis!B75=\"\",\"\",Analysis!A75)","v":64},{"$f":"IF(Analysis!B75=\"\",\"\",Analysis!B75)","v":-2},{"$f":"IF(Analysis!B100=\"\",\"\",Analysis!A100)","v":89},{"$f":"IF(Analysis!B100=\"\",\"\",Analysis!B100)","v":-21},{"$f":"IF(Analysis!B125=\"\",\"\",Analysis!A125)","v":114},{"$f":"IF(Analysis!B125=\"\",\"\",Analysis!B125)","v":-55},{"$f":"IF(Analysis!B150=\"\",\"\",Analysis!A150)","v":139},{"$f":"IF(Analysis!B150=\"\",\"\",Analysis!B150)","v":-134},{"$f":"IF(Analysis!B175=\"\",\"\",Analysis!A175)","v":164},{"$f":"IF(Analysis!B175=\"\",\"\",Analysis!B175)","v":-591}]
[{"$f":"IF(Analysis!B26=\"\",\"\",Analysis!A26)","v":15},{"$f":"IF(Analysis!B26=\"\",\"\",Analysis!B26)","v":21},{"$f":"IF(Analysis!B51=\"\",\"\",Analysis!A51)","v":40},{"$f":"IF(Analysis!B51=\"\",\"\",Analysis!B51)","v":10},{"$f":"IF(Analysis!B76=\"\",\"\",Analysis!A76)","v":65},{"$f":"IF(Analysis!B76=\"\",\"\",Analysis!B76)","v":-3},{"$f":"IF(Analysis!B101=\"\",\"\",Analysis!A101)","v":90},{"$f":"IF(Analysis!B101=\"\",\"\",Analysis!B101)","v":-22},{"$f":"IF(Analysis!B126=\"\",\"\",Analysis!A126)","v":115},{"$f":"IF(Analysis!B126=\"\",\"\",Analysis!B126)","v":-57},{"$f":"IF(Analysis!B151=\"\",\"\",Analysis!A151)","v":140},{"$f":"IF(Analysis!B151=\"\",\"\",Analysis!B151)","v":-140},{"$f":"IF(Analysis!B176=\"\",\"\",Analysis!A176)","v":165},{"$f":"IF(Analysis!B176=\"\",\"\",Analysis!B176)","v":-660}]
[{"$f":"IF(Analysis!B27=\"\",\"\",Analysis!A27)","v":16},{"$f":"IF(Analysis!B27=\"\",\"\",Analysis!B27)","v":20},{"$f":"IF(Analysis!B52=\"\",\"\",Analysis!A52)","v":41},{"$f":"IF(Analysis!B52=\"\",\"\",Analysis!B52)","v":10},{"$f":"IF(Analysis!B77=\"\",\"\",Analysis!A77)","v":66},{"$f":"IF(Analysis!B77=\"\",\"\",Analysis!B77)","v":-4},{"$f":"IF(Analysis!B102=\"\",\"\",Analysis!A102)","v":91},{"$f":"IF(Analysis!B102=\"\",\"\",Analysis!B102)","v":-23},{"$f":"IF(Analysis!B127=\"\",\"\",Analysis!A127)","v":116},{"$f":"IF(Analysis!B127=\"\",\"\",Analysis!B127)","v":-59},{"$f":"IF(Analysis!B152=\"\",\"\",Analysis!A152)","v":141},{"$f":"IF(Analysis!B152=\"\",\"\",Analysis!B152)","v":-146},{"$f":"IF(Analysis!B177=\"\",\"\",Analysis!A177)","v":166},{"$f":"IF(Analysis!B177=\"\",\"\",Analysis!B177)","v":-745}]
[{"$f":"IF(Analysis!B28=\"\",\"\",Analysis!A28)","v":17},{"$f":"IF(Analysis!B28=\"\",\"\",Analysis!B28)","v":20},{"$f":"IF(Analysis!B53=\"\",\"\",Analysis!A53)","v":42},{"$f":"IF(Analysis!B53=\"\",\"\",Analysis!B53)","v":9},{"$f":"IF(Analysis!B78=\"\",\"\",Analysis!A78)","v":67},{"$f":"IF(Analysis!B78=\"\",\"\",Analysis!B78)","v":-4},{"$f":"IF(Analysis!B103=\"\",\"\",Analysis!A103)","v":92},{"$f":"IF(Analysis!B103=\"\",\"\",Analysis!B103)","v":-24},{"$f":"IF(Analysis!B128=\"\",\"\",Analysis!A128)","v":117},{"$f":"IF(Analysis!B128=\"\",\"\",Analysis!B128)","v":-61},{"$f":"IF(Analysis!B153=\"\",\"\",Analysis!A153)","v":142},{"$f":"IF(Analysis!B153=\"\",\"\",Analysis!B153)","v":-152},{"$f":"IF(Analysis!B178=\"\",\"\",Analysis!A178)","v":167},{"$f":"IF(Analysis!B178=\"\",\"\",Analysis!B178)","v":-852}]
[{"$f":"IF(Analysis!B29=\"\",\"\",Analysis!A29)","v":18},{"$f":"IF(Analysis!B29=\"\",\"\",Analysis!B29)","v":19},{"$f":"IF(Analysis!B54=\"\",\"\",Analysis!A54)","v":43},{"$f":"IF(Analysis!B54=\"\",\"\",Analysis!B54)","v":9},{"$f":"IF(Analysis!B79=\"\",\"\",Analysis!A79)","v":68},{"$f":"IF(Analysis!B79=\"\",\"\",Analysis!B79)","v":-5},{"$f":"IF(Analysis!B104=\"\",\"\",Analysis!A104)","v":93},{"$f":"IF(Analysis!B104=\"\",\"\",Analysis!B104)","v":-25},{"$f":"IF(Analysis!B129=\"\",\"\",Analysis!A129)","v":118},{"$f":"IF(Analysis!B129=\"\",\"\",Analysis!B129)","v":-63},{"$f":"IF(Analysis!B154=\"\",\"\",Analysis!A154)","v":143},{"$f":"IF(Analysis!B154=\"\",\"\",Analysis!B154)","v":-159},{"$f":"IF(Analysis!B179=\"\",\"\",Analysis!A179)","v":168},{"$f":"IF(Analysis!B179=\"\",\"\",Analysis!B179)","v":-993}]
[{"$f":"IF(Analysis!B30=\"\",\"\",Analysis!A30)","v":19},{"$f":"IF(Analysis!B30=\"\",\"\",Analysis!B30)","v":19},{"$f":"IF(Analysis!B55=\"\",\"\",Analysis!A55)","v":44},{"$f":"IF(Analysis!B55=\"\",\"\",Analysis!B55)","v":8},{"$f":"IF(Analysis!B80=\"\",\"\",Analysis!A80)","v":69},{"$f":"IF(Analysis!B80=\"\",\"\",Analysis!B80)","v":-5},{"$f":"IF(Analysis!B105=\"\",\"\",Analysis!A105)","v":94},{"$f":"IF(Analysis!B105=\"\",\"\",Analysis!B105)","v":-26},{"$f":"IF(Analysis!B130=\"\",\"\",Analysis!A130)","v":119},{"$f":"IF(Analysis!B130=\"\",\"\",Analysis!B130)","v":-65},{"$f":"IF(Analysis!B155=\"\",\"\",Analysis!A155)","v":144},{"$f":"IF(Analysis!B155=\"\",\"\",Analysis!B155)","v":-166},{"$f":"IF(Analysis!B180=\"\",\"\",Analysis!A180)","v":169},{"$f":"IF(Analysis!B180=\"\",\"\",Analysis!B180)","v":-1185}]
[{"$f":"IF(Analysis!B31=\"\",\"\",Analysis!A31)","v":20},{"$f":"IF(Analysis!B31=\"\",\"\",Analysis!B31)","v":18},{"$f":"IF(Analysis!B56=\"\",\"\",Analysis!A56)","v":45},{"$f":"IF(Analysis!B56=\"\",\"\",Analysis!B56)","v":8},{"$f":"IF(Analysis!B81=\"\",\"\",Analysis!A81)","v":70},{"$f":"IF(Analysis!B81=\"\",\"\",Analysis!B81)","v":-6},{"$f":"IF(Analysis!B106=\"\",\"\",Analysis!A106)","v":95},{"$f":"IF(Analysis!B106=\"\",\"\",Analysis!B106)","v":-27},{"$f":"IF(Analysis!B131=\"\",\"\",Analysis!A131)","v":120},{"$f":"IF(Analysis!B131=\"\",\"\",Analysis!B131)","v":-67},{"$f":"IF(Analysis!B156=\"\",\"\",Analysis!A156)","v":145},{"$f":"IF(Analysis!B156=\"\",\"\",Analysis!B156)","v":-173},{"$f":"IF(Analysis!B181=\"\",\"\",Analysis!A181)","v":170},{"$f":"IF(Analysis!B181=\"\",\"\",Analysis!B181)","v":-1464}]
[{"$f":"IF(Analysis!B32=\"\",\"\",Analysis!A32)","v":21},{"$f":"IF(Analysis!B32=\"\",\"\",Analysis!B32)","v":18},{"$f":"IF(Analysis!B57=\"\",\"\",Analysis!A57)","v":46},{"$f":"IF(Analysis!B57=\"\",\"\",Analysis!B57)","v":7},{"$f":"IF(Analysis!B82=\"\",\"\",Analysis!A82)","v":71},{"$f":"IF(Analysis!B82=\"\",\"\",Analysis!B82)","v":-7},{"$f":"IF(Analysis!B107=\"\",\"\",Analysis!A107)","v":96},{"$f":"IF(Analysis!B107=\"\",\"\",Analysis!B107)","v":-29},{"$f":"IF(Analysis!B132=\"\",\"\",Analysis!A132)","v":121},{"$f":"IF(Analysis!B132=\"\",\"\",Analysis!B132)","v":-70},{"$f":"IF(Analysis!B157=\"\",\"\",Analysis!A157)","v":146},{"$f":"IF(Analysis!B157=\"\",\"\",Analysis!B157)","v":-182}]
[{"$f":"IF(Analysis!B33=\"\",\"\",Analysis!A33)","v":22},{"$f":"IF(Analysis!B33=\"\",\"\",Analysis!B33)","v":18},{"$f":"IF(Analysis!B58=\"\",\"\",Analysis!A58)","v":47},{"$f":"IF(Analysis!B58=\"\",\"\",Analysis!B58)","v":7},{"$f":"IF(Analysis!B83=\"\",\"\",Analysis!A83)","v":72},{"$f":"IF(Analysis!B83=\"\",\"\",Analysis!B83)","v":-7},{"$f":"IF(Analysis!B108=\"\",\"\",Analysis!A108)","v":97},{"$f":"IF(Analysis!B108=\"\",\"\",Analysis!B108)","v":-30},{"$f":"IF(Analysis!B133=\"\",\"\",Analysis!A133)","v":122},{"$f":"IF(Analysis!B133=\"\",\"\",Analysis!B133)","v":-72},{"$f":"IF(Analysis!B158=\"\",\"\",Analysis!A158)","v":147},{"$f":"IF(Analysis!B158=\"\",\"\",Analysis!B158)","v":-190}]
[{"$f":"IF(Analysis!B34=\"\",\"\",Analysis!A34)","v":23},{"$f":"IF(Analysis!B34=\"\",\"\",Analysis!B34)","v":17},{"$f":"IF(Analysis!B59=\"\",\"\",Analysis!A59)","v":48},{"$f":"IF(Analysis!B59=\"\",\"\",Analysis!B59)","v":6},{"$f":"IF(Analysis!B84=\"\",\"\",Analysis!A84)","v":73},{"$f":"IF(Analysis!B84=\"\",\"\",Analysis!B84)","v":-8},{"$f":"IF(Analysis!B109=\"\",\"\",Analysis!A109)","v":98},{"$f":"IF(Analysis!B109=\"\",\"\",Analysis!B109)","v":-31},{"$f":"IF(Analysis!B134=\"\",\"\",Analysis!A134)","v":123},{"$f":"IF(Analysis!B134=\"\",\"\",Analysis!B134)","v":-75},{"$f":"IF(Analysis!B159=\"\",\"\",Analysis!A159)","v":148},{"$f":"IF(Analysis!B159=\"\",\"\",Analysis!B159)","v":-200}]
[{"$f":"IF(Analysis!B35=\"\",\"\",Analysis!A35)","v":24},{"$f":"IF(Analysis!B35=\"\",\"\",Analysis!B35)","v":17},{"$f":"IF(Analysis!B60=\"\",\"\",Analysis!A60)","v":49},{"$f":"IF(Analysis!B60=\"\",\"\",Analysis!B60)","v":6},{"$f":"IF(Analysis!B85=\"\",\"\",Analysis!A85)","v":74},{"$f":"IF(Analysis!B85=\"\",\"\",Analysis!B85)","v":-9},{"$f":"IF(Analysis!B110=\"\",\"\",Analysis!A110)","v":99},{"$f":"IF(Analysis!B110=\"\",\"\",Analysis!B110)","v":-32},{"$f":"IF(Analysis!B135=\"\",\"\",Analysis!A135)","v":124},{"$f":"IF(Analysis!B135=\"\",\"\",Analysis!B135)","v":-77},{"$f":"IF(Analysis!B160=\"\",\"\",Analysis!A160)","v":149},{"$f":"IF(Analysis!B160=\"\",\"\",Analysis!B160)","v":-210}]
[{"$f":"IF(Analysis!B36=\"\",\"\",Analysis!A36)","v":25},{"$f":"IF(Analysis!B36=\"\",\"\",Analysis!B36)","v":16},{"$f":"IF(Analysis!B61=\"\",\"\",Analysis!A61)","v":50},{"$f":"IF(Analysis!B61=\"\",\"\",Analysis!B61)","v":5},{"$f":"IF(Analysis!B86=\"\",\"\",Analysis!A86)","v":75},{"$f":"IF(Analysis!B86=\"\",\"\",Analysis!B86)","v":-10},{"$f":"IF(Analysis!B111=\"\",\"\",Analysis!A111)","v":100},{"$f":"IF(Analysis!B111=\"\",\"\",Analysis!B111)","v":-33},{"$f":"IF(Analysis!B136=\"\",\"\",Analysis!A136)","v":125},{"$f":"IF(Analysis!B136=\"\",\"\",Analysis!B136)","v":-80},{"$f":"IF(Analysis!B161=\"\",\"\",Analysis!A161)","v":150},{"$f":"IF(Analysis!B161=\"\",\"\",Analysis!B161)","v":-221}]
[{"$f":"CONCATENATE(\"Positive Pay Adjustment at IRI= \",A23,\" is $\",B23)","v":"Positive Pay Adjustment at IRI= 1 is $29"},null,null,null,null,{"$f":"CONCATENATE(\"Maximum Negative Pay Adjustment is \",\"-$\",ROUND(Analysis!D4,),\" at IRI = \",170,\" Inch/Mile\")","v":"Maximum Negative Pay Adjustment is -$1464 at IRI = 170 Inch/Mile"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(Analysis!B93=\"\",\"\",Analysis!B93)","v":-15}]
[null,null,{"$f":"IF(Analysis!B94=\"\",\"\",Analysis!B94)","v":-16}]
[null,null,{"$f":"IF(Analysis!B95=\"\",\"\",Analysis!B95)","v":-17}]
[null,null,{"$f":"IF(Analysis!B96=\"\",\"\",Analysis!B96)","v":-18}]
[null,null,{"$f":"IF(Analysis!B97=\"\",\"\",Analysis!B97)","v":-18}]
[null,null,{"$f":"IF(Analysis!B98=\"\",\"\",Analysis!B98)","v":-19}]
[null,null,{"$f":"IF(Analysis!B99=\"\",\"\",Analysis!B99)","v":-20}]
[null,null,{"$f":"IF(Analysis!B100=\"\",\"\",Analysis!B100)","v":-21}]
[null,null,{"$f":"IF(Analysis!B101=\"\",\"\",Analysis!B101)","v":-22}]
[null,null,{"$f":"IF(Analysis!B102=\"\",\"\",Analysis!B102)","v":-23}]
[null,null,{"$f":"IF(Analysis!B103=\"\",\"\",Analysis!B103)","v":-24}]
[null,null,{"$f":"IF(Analysis!B104=\"\",\"\",Analysis!B104)","v":-25}]
[null,null,{"$f":"IF(Analysis!B105=\"\",\"\",Analysis!B105)","v":-26}]
[null,null,{"$f":"IF(Analysis!B106=\"\",\"\",Analysis!B106)","v":-27}]
[null,null,{"$f":"IF(Analysis!B107=\"\",\"\",Analysis!B107)","v":-29}]
[null,null,{"$f":"IF(Analysis!B108=\"\",\"\",Analysis!B108)","v":-30}]
[null,null,{"$f":"IF(Analysis!B109=\"\",\"\",Analysis!B109)","v":-31}]
[null,null,{"$f":"IF(Analysis!B110=\"\",\"\",Analysis!B110)","v":-32}]
[null,null,{"$f":"IF(Analysis!B111=\"\",\"\",Analysis!B111)","v":-33}]
[null,null,{"$f":"IF(Analysis!B112=\"\",\"\",Analysis!B112)","v":-35}]
[null,null,{"$f":"IF(Analysis!B113=\"\",\"\",Analysis!B113)","v":-36}]
[null,null,{"$f":"IF(Analysis!B114=\"\",\"\",Analysis!B114)","v":-37}]
[null,null,{"$f":"IF(Analysis!B115=\"\",\"\",Analysis!B115)","v":-39}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(Analysis!B182=\"\",\"\",Analysis!A182)","v":""},{"$f":"COUNT(B23:B192)","v":25}]
[{"$f":"IF(Analysis!B183=\"\",\"\",Analysis!A183)","v":""},{"$f":"IF(Analysis!B183=\"\",\"\",Analysis!B183)","v":""}]
[{"$f":"IF(Analysis!B184=\"\",\"\",Analysis!A184)","v":""},{"$f":"IF(Analysis!B184=\"\",\"\",Analysis!B184)","v":""}]
[{"$f":"IF(Analysis!B185=\"\",\"\",Analysis!A185)","v":""},{"$f":"IF(Analysis!B185=\"\",\"\",Analysis!B185)","v":""}]
[{"$f":"IF(Analysis!B186=\"\",\"\",Analysis!A186)","v":""},{"$f":"IF(Analysis!B186=\"\",\"\",Analysis!B186)","v":""}]
[{"$f":"IF(Analysis!B187=\"\",\"\",Analysis!A187)","v":""},{"$f":"IF(Analysis!B187=\"\",\"\",Analysis!B187)","v":""}]

{"sheet":"Macro","index":3,"n_rows":102,"n_cols":12,"rows_kept":102,"cut":false,"hidden":false,"merged":[[4,0,4,11],[5,0,5,11],[6,0,6,11],[7,0,7,11],[21,0,21,11],[13,0,19,11]]}
[]
[]
[]
[]
["PAVEMENT DESIGN"]
["PAY ADJUSTMENT ESTIMATOR "]
["Version: 2.01"]
["Information last updated on: 04/10/2019"]
[]
[]
[]
[]
[]
["The RQR is a Microsoft Excel work book containing various macros to automate production of required pay equations and exclusions for ride quality specifications. Make sure macro is enabled when the spreadsheet is opened."]
[]
[]
[]
[]
[]
[]
[]
["How to enable MACRO?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PREVIOUS",null,null,null,null,null,null,null,null,null,null,"NEXT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PREVIOUS",null,null,null,null,null,null,null,null,null,null,"NEXT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PREVIOUS"]

{"sheet":"blank","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}