{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["DFV","F&E Log#","124001","F&E Blend Calc ","Blend Calc Org"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":1,"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":"DFV","index":0,"n_rows":27,"n_cols":23,"rows_kept":27,"cut":false,"hidden":false,"merged":[[18,3,18,4],[2,5,2,7],[3,5,3,7],[4,5,4,6],[5,5,5,6],[6,5,6,6],[7,5,7,6],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[22,14,22,17],[26,5,26,12],[8,5,8,6],[9,5,9,6],[10,5,10,6],[12,5,12,12]]}
[]
[]
[null,null,null,null,null,"Table I"]
[null,null,null,null,null,"Dynamic Friction Value Categories"]
[null,null,null,null,null,"Category",null,"DFV",null,null,null,null,null,null,null,null,null,null,null,null,null,20,"LDFV VI"]
[null,null,null,null,null,"HDFV I ",null,50,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"SDFV V"]
[null,null,null,null,null,"HDFV II",null,45,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"SDFV IV"]
[null,null,null,null,null,"HDFV III",null,40,null,null,null,null,null,null,null,null,null,null,null,null,null,40,"HDFV III"]
[null,null,null,null,null,"SDFV IV",null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,45,"HDFV II"]
[null,null,null,null,null,"SDFV V",null,25,null,null,null,null,null,null,null,null,null,null,null,null,null,50,"HDFV I "]
[null,null,null,null,null,"LDFV VI",null,20]
[]
[null,null,null,null,null," AGGREGATE, PERCENT PASSING "]
[null,null,null,"Sieve",null,null,null,"#7","#8","#89","#10","Sand","RAP2","Combo"]
[null,null,null,"19 mm",null,null,null,91,100,100,100,100,100,{"$f":"AshRound(SUMPRODUCT(F15:M15,F$23:M$23)/$N$23,1)","v":97.3}]
[null,null,null,"12.5 mm",null,null,null,88,100,100,100,100,94,{"$f":"AshRound(SUMPRODUCT(F16:M16,F$23:M$23)/$N$23,1)","v":94.9}]
[null,null,null,"9.5 mm",null,null,null,63,89,98,100,100,86,{"$f":"AshRound(SUMPRODUCT(F17:M17,F$23:M$23)/$N$23,1)","v":83.2}]
[null,null,null,"4.75 mm",null,null,null,15,23,61,95,98,75,{"$f":"AshRound(SUMPRODUCT(F18:M18,F$23:M$23)/$N$23,1)","v":51.6}]
[null,null,null,"2.36 mm",null,null,null,4,5,15,63,96,65,{"$f":"AshRound(SUMPRODUCT(F19:M19,F$23:M$23)/$N$23,1)","v":34.200000000000003}]
[]
[null,null,null,"+ 9.5","mm",{"$f":"100-F17","v":100},100,37,11,2,0,0,14]
[null,null,null,"DFV",null,0,0,45,25,25,25,25,30]
[null,null,null,null,"% AGG",0,0,30,20,0,25,0,25,{"$f":"SUM(F23:M23)","v":100},"Your AGG Percentages do not = 100%"]
[]
[null,null,null,"% Coarse of Agg",null,{"$f":"AshRound((F23*F21)/$N$23,1)","v":0},0,11.1,2.2000000000000002,0,0,0,{"$f":"IF(M21<15,0,AshRound((M23*M21)/$N$23,1))","v":0},{"$f":"SUM(F25:M25)","v":13.3},"% Coarse Agg"]
[null,null,null,"DFV Contribution",null,{"$f":"AshRound((F25/$N$25)*F22,1)","v":0},0,37.6,4.0999999999999996,0,0,0,0,{"$f":"AshRound(SUM(F26:M26),1)","v":41.7},"Total DFV"]
[null,null,null,null,null,{"$f":"IF(N26>=20,\"Your Agg. Combo falls into \"&VLOOKUP(N26,V5:W10,2)&\" category.\",\" \")","v":"Your Agg. Combo falls into HDFV III category."}]

{"sheet":"F&E Log#","index":1,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[4,6,4,8],[12,3,12,4],[39,1,39,2],[39,3,39,4],[0,1,0,2],[1,1,1,2],[2,1,2,2],[4,1,4,4],[13,7,13,8],[15,6,15,8],[20,1,20,8],[30,1,30,8],[38,5,38,6],[43,1,43,2],[43,3,43,4],[40,1,40,2],[40,3,40,4],[41,1,41,2],[41,3,41,4],[42,1,42,2],[42,3,42,4]]}
[null,"Log Number:",null,null,null,"Quarry Name:          "]
[null,"Tested By:",null,null,null,"Plant Number : "]
[null,"Material Size:",null,null,null,"Charge Number:   ",null,"Date Started:"]
[]
[null,"GRADATION (ASTM C136)"]
[null,"STARTING Weight (gram)",5230]
[null,"SIEVES","WEIGHT. RETAINED","WEIGHT PASSING","% PASS"]
[null,"1\"",0,{"$f":"C6-C8","v":5230},{"$f":"AshRound(D8/$C$6,$H$47)*100","v":100}]
[null,"3/4\"",0,{"$f":"D8-C9","v":5230},{"$f":"AshRound(D9/$C$6,$H$47)*100","v":100}]
[null,"1/2\"",420,{"$f":"D9-C10","v":4810},{"$f":"AshRound(D10/$C$6,$H$47)*100","v":92}]
[null," 3/8\"   ",2720,2090,{"$f":"AshRound(D11/$C$6,$H$47)*100","v":40}]
[null,"# 4    ",1840,250,{"$f":"AshRound(D12/$C$6,$H$47)*100","v":4.8}]
[null,"Split Sample Weight (gram)",456.5]
[null,"# 8",200.6,{"$f":"C13-C14","v":255.9},{"$f":"AshRound((D14/$C$13)*($D$12/$C$6),$H$47)*100","v":2.7}]
[null,"# 16",16.100000000000001,{"$f":"D14-C15","v":239.8},2.5]
[null,"# 30",13.5,{"$f":"D15-C16","v":226.3},2.4]
[null,"# 50",17.8,208.5,2.1999999999999997]
[null,"# 100",21.1,187.4,2]
[null,"# 200",34.1,153.30000000000001,1.6]
[]
[null,"FLAT & ELONGATED PARTICLES - Method B, ASTM D 4791 (5:1)"]
[]
[null," SIZE FRACTION","SAMPLE Grading  [a][b]  ","No. of PARTICLES","MASS TESTED","MASS of F&E     ","% F & E           ","WEIGHTED % F&E  (c)","MDSHA SPECIFICATION[1]"]
[null,"1\" x 3/4\"",{"$f":"AshRound(C9/($C$6-$D$12),$H$47)","v":0},null,null,null,{"$f":"IF(AND(F24<>\"\",F24<>\"Not Tested\"),AshRound((F24/E24),$H$47)*100,\"-\")","v":"-"},{"$f":"IF(AND(G24>0,G24<>\"-\"),AshRound(G24*C24,$H$48),\"-\")","v":"-"}," -"]
[null,"3/4\" x 1/2\"",{"$f":"AshRound(C10/($C$6-$D$12),$H$47)","v":8.4000000000000005E-2},"-","-","Not Tested",{"$f":"IF(AND(F25<>\"\",F25<>\"Not Tested\"),AshRound((F25/E25),$H$47)*100,\"-\")","v":"-"},{"$f":"IF(AND(G25>0,G25<>\"-\"),AshRound(G25*C25,$H$48),\"-\")","v":"-"}," -"]
[null,"1/2\" x 3/8\"",{"$f":"AshRound(C11/($C$6-$D$12),$H$47)","v":0.54600000000000004},102,198.6,0,{"$f":"IF(AND(F26<>\"\",F26<>\"Not Tested\"),AshRound((F26/E26),$H$47)*100,\"-\")","v":0},{"$f":"IF(AND(G26>0,G26<>\"-\"),AshRound(G26*C26,$H$48),\"-\")","v":"-"}," -"]
[null,"3/8\" x #4",{"$f":"AshRound(C12/($C$6-$D$12),$H$47)","v":0.36899999999999999},105,75.900000000000006,4.2,{"$f":"IF(AND(F27<>\"\",F27<>\"Not Tested\"),AshRound((F27/E27),$H$47)*100,\"-\")","v":5.5},{"$f":"IF(AND(G27>0,G27<>\"-\"),AshRound(G27*C27,$H$48),\"-\")","v":2}]
[null,null,null,null,null,null,"F&E (5:1)",{"$f":"SUM(H24:H27)","v":2},"5% max on the blend"]
[]
[]
[null,"FLAT & ELONGATED PARTICLES - Method B, ASTM D 4791 ( B @ 3:1)"]
[]
[null," SIZE FRACTION","SAMPLE Grading  [a][b]  ","No. of PARTICLES","MASS TESTED","MASS of F&E      ","% F & E           ","WEIGHTED % F&E  (c)","MDSHA SPECIFICATION[1]"]
[null,"1\" x 3/4\"",{"$f":"AshRound(C9/($C$6-$D$12),$H$47)","v":0},null,null,null,{"$f":"IF(AND(F34<>\"\",F34<>\"Not Tested\"),AshRound((F34/E34),$H$47)*100,\"-\")","v":"-"},{"$f":"IF(AND(G34>0,G34<>\"-\"),AshRound(G34*C34,$H$48),\"-\")","v":"-"}," -"]
[null,"3/4\" x 1/2\"",{"$f":"AshRound(C10/($C$6-$D$12),$H$47)","v":8.4000000000000005E-2},"-","-","Not Tested",{"$f":"IF(AND(F35<>\"\",F35<>\"Not Tested\"),AshRound((F35/E35),$H$47)*100,\"-\")","v":"-"},{"$f":"IF(AND(G35>0,G35<>\"-\"),AshRound(G35*C35,$H$48),\"-\")","v":"-"}," -"]
[null,"1/2\" x 3/8\"",{"$f":"AshRound(C11/($C$6-$D$12),$H$47)","v":0.54600000000000004},102,198.6,48.3,{"$f":"IF(AND(F36<>\"\",F36<>\"Not Tested\"),AshRound((F36/E36),$H$47)*100,\"-\")","v":24.3},{"$f":"IF(AND(G36>0,G36<>\"-\"),AshRound(G36*C36,$H$48),\"-\")","v":13.3}," -"]
[null,"3/8\" x #4",{"$f":"AshRound(C12/($C$6-$D$12),$H$47)","v":0.36899999999999999},105,75.900000000000006,27.8,{"$f":"IF(AND(F37<>\"\",F37<>\"Not Tested\"),AshRound((F37/E37),$H$47)*100,\"-\")","v":36.6},{"$f":"IF(AND(G37>0,G37<>\"-\"),AshRound(G37*C37,$H$48),\"-\")","v":13.5}]
[null,null,null,null,null,null,"F&E (3:1)",{"$f":"SUM(H34:H37)","v":26.8},"20 % max on the blend"]
[]
[null,"Nominal Maximum Size in.(mm) ",null,"Minimum Mass of  Test Sample. "]
[null,"1”       (25.0mm)",null,"22 lb     (10 kg)"]
[null,"3/4”     (19.0mm)",null,"11 lb     (  5 kg)"]
[null,"1/2”    (12.5mm)",null,"  4 lb      ( 2 kg)"]
[null,"3/8”     (9.5mm)",null,"  2 lb      ( 1 kg)"]
[null,"Note: [1] Maryland Department of Transportation - SHA State Highway Administration - Standard Specifications for Construction and Materials.."]
[null,"Note: [a] Percentage Retained based upon Coarse Aggregate weight."]
[null,{"$f":"\"Note: [b] Calculations rounded in Accordance with AASHTO E29 using  \"&H47&\" digits.\"","v":"Note: [b] Calculations rounded in Accordance with AASHTO E29 using  3 digits."},null,null,null,null,null,3]
[null,{"$f":"\"Note: [c] Calculations rounded in Accordance with AASHTO E29 using  \"&H48&\" digits.\"","v":"Note: [c] Calculations rounded in Accordance with AASHTO E29 using  1 digits."},null,null,null,null,null,1]

{"sheet":"124001","index":2,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":true,"merged":[[4,5,4,7],[12,2,12,3],[39,0,39,1],[39,2,39,3],[0,0,0,1],[1,0,1,1],[2,0,2,1],[4,0,4,3],[13,6,13,7],[15,5,15,7],[20,0,20,7],[30,0,30,7],[38,4,38,5],[43,0,43,1],[43,2,43,3],[40,0,40,1],[40,2,40,3],[41,0,41,1],[41,2,41,3],[42,0,42,1],[42,2,42,3]]}
["Log Number:",null,124001,null,"Quarry Name:          ","Vulcan - Havre de Grace"]
["Tested By:",null,"AW",null,"Plant Number : ",151]
["Material Size:",null,"HP-7",null,"Charge Number:   ",null,"Date Started:","2012-09-14"]
[]
["GRADATION (ASTM C136)"]
["STARTING Weight (gram)",5230]
["SIEVES","WEIGHT. RETAINED","WEIGHT PASSING","% PASS"]
["1\"",0,{"$f":"B6-B8","v":5230},{"$f":"(C8/$B$6)*100","v":100}]
["3/4\"",0,{"$f":"C8-B9","v":5230},{"$f":"(C9/$B$6)*100","v":100}]
["1/2\"",420,{"$f":"C9-B10","v":4810},91.969407265774379]
[" 3/8\"   ",2720,2090,39.961759082217974]
["# 4    ",1840,250,4.7801147227533463]
["Split Sample Weight (gram)",456.5]
["# 8",200.6,{"$f":"B13-B14","v":255.9},{"$f":"(C14/$B$13)*$D$12","v":2.6795867635324893}]
["# 16",16.100000000000001,{"$f":"C14-B15","v":239.8},{"$f":"(C15/$B$13)*$D$12","v":2.5110000230366976}]
["# 30",13.5,{"$f":"C15-B16","v":226.3},2.3696384704470588]
["# 50",17.8,208.5,2.1832506455510901]
["# 100",21.1,187.4,1.9623077744665436]
["# 200",34.1,153.30000000000001,1.6052389638512334]
[]
["FLAT & ELONGATED PARTICLES - Method B, ASTM D 4791 (5:1)"]
[]
[" SIZE FRACTION","SAMPLE Grading  [a]  ","No. of PARTICLES","MASS TESTED","MASS of F&E     ","% F & E           ","WEIGHTED % F&E  ","MDSHA SPECIFICATION[1]"]
["1\" x 3/4\"",{"$f":"B9/($B$6-$C$12)","v":0},null,null,null,null,0," -"]
["3/4\" x 1/2\"",{"$f":"B10/($B$6-$C$12)","v":8.4337349397590355E-2},"-","-","Not Tested","-",0," -"]
["1/2\" x 3/8\"",0.54618473895582331,102,198.6,0,{"$f":"(E26/D26)*100","v":0},{"$f":"F26*B26","v":0}," -"]
["3/8\" x #4",{"$f":"B12/($B$6-$C$12)","v":0.36947791164658633},105,75.900000000000006,4.2,{"$f":"(E27/D27)*100","v":5.5335968379446641},{"$f":"F27*B27","v":2.0445418035779479}]
[null,null,null,null,null,"F&E (5:1)",{"$f":"SUM(G24:G27)","v":2.0445418035779479},"5% max on the blend"]
[]
[]
["FLAT & ELONGATED PARTICLES - Method B, ASTM D 4791 ( B @ 3:1)"]
[]
[" SIZE FRACTION","SAMPLE Grading  [a]  ","No. of PARTICLES","MASS TESTED","MASS of F&E      ","% F & E           ","WEIGHTED % F&E  (E)***","MDSHA SPECIFICATION[1]"]
["1\" x 3/4\"",{"$f":"B9/($B$6-$C$12)","v":0},null,null,null,null,0," -"]
["3/4\" x 1/2\"",{"$f":"B10/($B$6-$C$12)","v":8.4337349397590355E-2},"-","-","Not Tested","-",0," -"]
["1/2\" x 3/8\"",0.54618473895582331,102,198.6,48.3,{"$f":"(E36/D36)*100","v":24.320241691842899},{"$f":"F36*B36","v":13.283344859801744}," -"]
["3/8\" x #4",0.36947791164658633,105,75.900000000000006,27.8,{"$f":"(E37/D37)*100","v":36.627140974967062},{"$f":"F37*B37","v":13.532919557015942}]
[null,null,null,null,null,"F&E (3:1)",{"$f":"SUM(G34:G37)","v":26.816264416817688},"20 % max on the blend"]
[]
["Nominal Maximum Size in.(mm) ",null,"Minimum Mass of  Test Sample. "]
["1”       (25.0mm)",null,"22 lb     (10 kg)"]
["3/4”     (19.0mm)",null,"11 lb     (  5 kg)"]
["1/2”    (12.5mm)",null,"  4 lb      ( 2 kg)"]
["3/8”     (9.5mm)",null,"  2 lb      ( 1 kg)"]
["Note: [1] Maryland Department of Transportation - SHA State Highway Administration - Standard Specifications for Construction and Materials.."]
["Note: [a] Percentage Retained based upon Coarse Aggregate weight."]

{"sheet":"F&E Blend Calc ","index":3,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,3,3,10],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3]]}
[]
[null,null,null,"Blend F&E Calibration"]
[]
[]
[]
[null,null,null,null,0.09,0.18,0.27,0.15,0.11,0.1,0.1,{"$f":"SUM(E6:K6)","v":1}]
[null,null,null,"Sieve","ACE #5","ACE #7","ACE #8","ACE #89","ACE C#89","Acme 10's","RAP","Blend"]
[null,null,null,"50 mm",100,100,100,100,100,100,100,{"$f":"AshRound(E8*E$6+F8*F$6+G8*G$6+H8*H$6+I8*I$6+J8*J$6+K8*K$6,1)","v":100}]
[null,null,null,"37.5 mm",100,100,100,100,100,100,100,{"$f":"AshRound(E9*E$6+F9*F$6+G9*G$6+H9*H$6+I9*I$6+J9*J$6+K9*K$6,1)","v":100}]
[null,null,null,"25 mm",100,100,100,100,100,100,100,100]
[null,null,null,"19 mm",89.6,100,100,100,100,100,100,99.1]
[null,null,null,"12.5 mm",35.9,94,100,100,100,100,100,93.2]
[null,null,null,"9.5 mm",12.6,50,95,100,100,100,94,81.2]
[null,null,null,"4.75 mm",3.5,9,20,92,87,91,69,46.7]
[null,null,null,"2.36 mm",2.9,4,5,26,51,65,50,23.3]
[null,null,null,"1.18 mm",2.4,3,2.7,5.7,29,44,38,13.7]
[null,null,null,"600 µm",2,2.5,2.1,3.1,17,32,31,9.8000000000000007]
[null,null,null,"300 µm",1.5,2.2999999999999998,1.8,2.5,9.9,24,21.4,7]
[null,null,null,"150 µm",1.3,1.6,1.7,2.2000000000000002,6.1,19,14.5,5.2]
[null,null,null,"75 µm",1.2,1.4,1.6,2,4.5,14.4,11,4.0999999999999996]
[]
[null,false,null,"C.A. Cont",{"$f":"AshRound(IF(AND($B$23,$B$22),E33/$L$33,IF($B$23,E32/$L$32,IF($B$22,E31/$L$31,E30/$L$30))),3)","v":0.16300000000000001},{"$f":"AshRound(IF(AND($B$23,$B$22),F33/$L$33,IF($B$23,F32/$L$32,IF($B$22,F31/$L$31,F30/$L$30))),3)","v":0.308},0.40500000000000003,2.3E-2,2.5999999999999999E-2,1.7000000000000001E-2,5.8000000000000003E-2]
[null,false]
[null,null,null,"F&E",5,19,17.899999999999999,0.5,0.5,2,3.2]
[]
[]
[null,null,null,null,null,"F&E",{"$f":"AshRound(SUMPRODUCT(E22:K22,E24:K24),1)","v":14.2}]
[]
[]
[null,null,"No 10% Rule",null,{"$f":"AshRound((100-E14)*E6,1)","v":8.6999999999999993},{"$f":"AshRound((100-F14)*F6,1)","v":16.399999999999999},21.6,1.2,1.4,0.9,3.1,{"$f":"SUM(E30:K30)","v":53.300000000000004}]
[null,null,"10% C.F. Rule",null,{"$f":"IF(E6>=0.1,AshRound((100-E14)*E6,1),0)","v":0},{"$f":"IF(F6>=0.1,AshRound((100-F14)*F6,1),0)","v":16.399999999999999},21.6,1.2,1.4,0.9,3.1,{"$f":"SUM(E31:K31)","v":44.6}]
[null,null,"10% C.A. Rule",null,{"$f":"IF((100-E14)>=10,AshRound((100-E14)*E6,1),0)","v":8.6999999999999993},{"$f":"IF((100-F14)>=10,AshRound((100-F14)*F6,1),0)","v":16.399999999999999},21.6,0,1.4,0,3.1,{"$f":"SUM(E32:K32)","v":51.2}]
[null,null,"Both 10% Rules",null,{"$f":"IF(AND(E6>=0.1,(100-E14)>=10),AshRound((100-E14)*E6,1),0)","v":0},16.399999999999999,21.6,{"$f":"IF(AND(H6>=0.1,(100-H14)>=10),AshRound((100-H14)*H6,1),0)","v":0},{"$f":"IF(AND(I6>=0.1,(100-I14)>=10),AshRound((100-I14)*I6,1),0)","v":1.4},0,3.1,{"$f":"SUM(E33:K33)","v":42.5}]

{"sheet":"Blend Calc Org","index":4,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":true,"merged":[[36,2,36,3],[32,2,32,3],[37,2,37,3],[1,3,3,10],[29,2,29,3],[30,2,30,3],[31,2,31,3],[34,2,34,3],[35,2,35,3]]}
[]
[null,null,null,"Blend F&E Calibration"]
[]
[]
[]
[null,null,null,null,0.1,0.09,0.27,0.15,0.18,0.1,0.11,{"$f":"SUM(E6:K6)","v":1}]
[null,null,null,"Sieve","10's","HDG #5","HDG 8","HE #6","HDG #7","RAP","C HE#6","Blend"]
[null,null,null,"50 mm",100,100,100,100,100,100,100,{"$f":"AshRound(E8*E$6+F8*F$6+G8*G$6+H8*H$6+I8*I$6+J8*J$6+K8*K$6,1)","v":100}]
[null,null,null,"37.5 mm",100,100,100,100,100,100,100,{"$f":"AshRound(E9*E$6+F9*F$6+G9*G$6+H9*H$6+I9*I$6+J9*J$6+K9*K$6,1)","v":100}]
[null,null,null,"25 mm",100,100,100,100,100,100,100,100]
[null,null,null,"19 mm",100,89.6,100,100,100,100,100,99.1]
[null,null,null,"12.5 mm",100,35.9,100,100,94,100,100,93.2]
[null,null,null,"9.5 mm",100,12.6,95,100,50,94,100,81.2]
[null,null,null,"4.75 mm",91,3.5,20,92,9,69,87,46.7]
[null,null,null,"2.36 mm",65,2.9,5,26,4,50,51,23.3]
[null,null,null,"1.18 mm",44,2.4,2.7,5.7,3,38,29,13.7]
[null,null,null,"600 µm",32,2,2.1,3.1,2.5,31,17,9.8000000000000007]
[null,null,null,"300 µm",24,1.5,1.8,2.5,2.2999999999999998,21.4,9.9,7]
[null,null,null,"150 µm",19,1.3,1.6,2.2000000000000002,1.6,14.5,6.1,5.2]
[null,null,null,"75 µm",14.4,1.2,1.8,2,1.4,11,4.5,4.2]
[]
[null,false,null,"C.A. Cont",{"$f":"AshRound(IF(AND($B$23,$B$22),E33/$L$33,IF($B$23,E32/$L$32,IF($B$22,E31/$L$31,E30/$L$30))),3)","v":0},{"$f":"AshRound(IF(AND($B$23,$B$22),F33/$L$33,IF($B$23,F32/$L$32,IF($B$22,F31/$L$31,F30/$L$30))),3)","v":0.17},0.42199999999999999,0,0.32,6.0999999999999999E-2,2.7E-2]
[null,true]
[null,null,null,"F&E",2,5,17.899999999999999,0.5,19,3.2,0.5]
[null,null,null,null,{"$f":"E8-E14","v":9},{"$f":"F8-F14","v":96.5},{"$f":"G8-G14","v":80},8,91,31,13]
[null,null,null,null,{"$f":"E25*E6","v":0.9},{"$f":"F25*F6","v":8.6850000000000005},{"$f":"G25*G6","v":21.6},1.2,16.38,3.1,1.43]
[null,null,null,null,null,"F&E",{"$f":"AshRound(SUMPRODUCT(E22:K22,E24:K24),1)","v":14.7}]
[]
[]
[null,null,"No 10% Rule",null,{"$f":"AshRound((100-E14)*E6,1)","v":0.9},{"$f":"AshRound((100-F14)*F6,1)","v":8.6999999999999993},21.6,1.2,16.399999999999999,3.1,1.4,{"$f":"SUM(E30:K30)","v":53.300000000000004},null,14.2]
[null,null,"10% C.F. Rule",null,{"$f":"IF(E6>=0.1,AshRound((100-E14)*E6,1),0)","v":0.9},{"$f":"IF(F6>=0.1,AshRound((100-F14)*F6,1),0)","v":0},21.6,1.2,16.399999999999999,3.1,1.4,{"$f":"SUM(E31:K31)","v":44.599999999999994},null,15.9]
[null,null,"10% Cont. Rule",null,{"$f":"IF((100-E14)>=10,AshRound((100-E14)*E6,1),0)","v":0},{"$f":"IF((100-F14)>=10,AshRound((100-F14)*F6,1),0)","v":8.6999999999999993},21.6,0,16.399999999999999,3.1,1.4,{"$f":"SUM(E32:K32)","v":51.2},null,14.7]
[null,null,"Both 10% Rules",null,{"$f":"IF(AND(E6>=0.1,(100-E14)>=10),AshRound((100-E14)*E6,1),0)","v":0},0,21.6,{"$f":"IF(AND(H6>=0.1,(100-H14)>=10),AshRound((100-H14)*H6,1),0)","v":0},{"$f":"IF(AND(I6>=0.1,(100-I14)>=10),AshRound((100-I14)*I6,1),0)","v":16.399999999999999},3.1,1.4,{"$f":"SUM(E33:K33)","v":42.5},null,16.7]
[]
[null,null,"No 10% Rule",null,{"$f":"E30/$L$30","v":1.6885553470919322E-2},{"$f":"F30/$L$30","v":0.16322701688555344},0.40525328330206378,2.2514071294559096E-2,0.30769230769230765,5.8161350844277669E-2,2.6266416510318944E-2]
[null,null,"10% C.F. Rule",null,{"$f":"E31/$L$31","v":2.017937219730942E-2},{"$f":"F31/$L$31","v":0},0.48430493273542613,2.6905829596412557E-2,0.36771300448430494,6.9506726457399109E-2,3.1390134529147982E-2]
[null,null,"10% Cont. Rule",null,{"$f":"E32/$L$32","v":0},{"$f":"F32/$L$32","v":0.16992187499999997},0.421875,0,0.32031249999999994,6.0546875E-2,2.7343749999999997E-2]
[null,null,{"$f":"C33","v":"Both 10% Rules"},null,{"$f":"E33/$L$32","v":0},0,0.421875,0,0.32031249999999994,6.0546875E-2,2.7343749999999997E-2]