{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["READ","AFT_calculation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"READ","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,29,9]]}
[]
[null,"02FEB2006 - Revisions - this spread sheet originated with the Bemidji District.  This is first \nmodification by the Bituminous Office.  This revision adds the Surface Area Adjustment.  The\nversion immediately preceding this one, was check for accuracy and application of AASHTO\nrounding.  It has been confirmed to be working properly.  \n\nThe Surface Area sieve size factors were developed using a minus #4 specific gravity of 2.650.\nIf the actual minus #4 specific gravity is higher than 2.700, or lower than 2.580, then the Surface \nArea is Adjusted (really it is a correction).  The adjusted surface area is adjusted by multiplying\nthe Surface Area by 2.650/(actual minus #4 SpGr).  The composite Aggregate Specific Gravity\nis used to calculate the Percent Effective AC.  "]

{"sheet":"AFT_calculation","index":1,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[35,0,35,10],[30,0,30,10],[27,0,27,10],[28,0,28,10],[36,0,36,10],[13,7,13,8],[18,5,18,7],[31,0,31,10],[29,0,29,10],[32,0,32,10],[33,0,33,10],[34,0,34,10],[20,5,20,7],[0,0,0,10],[19,4,19,7],[17,5,17,7],[14,7,14,8],[37,0,37,10],[1,0,1,10],[24,0,24,10],[25,0,25,10],[26,0,26,10]]}
["ADJUSTED  ASPHALT FILM THICKNESS (AFT)  CALCULATION"]
["and Fines /Effective AC"]
[]
[null,null,null,null,null,null,null,"%Passing","Multiplication"]
["(Mix)Gsb=",2.61]
["%AC(Pb)=",5.9,null,null,null,null,"#4  =",72,0.02,{"$f":"H6*I6","v":1.44}]
["Gmm=",2.452,null,null,null,null,"#8  =",57,0.04,{"$f":"H7*I7","v":2.2800000000000002}]
["AC SpG=",1.032,null,null,null,null,"#16 =",42,0.08,3.36]
["Gsb (-4)",2.65,null,"Gse=",{"$f":"mndot_rounding_3((100-B6)/((100/B7)-(B6/B8)))","v":2.6840000000000002},null,"#30 =",28,0.14000000000000001,3.9200000000000004]
["%Stone(Ps)=",{"$f":"100-B6","v":94.1},null,null,null,null,"#50 =",17,0.3,5.0999999999999996]
[null,null,null,"Pba=",{"$f":"(100*((E9-B5)/(B5*E9))*B8)","v":1.0901553694091894},null,"#100 =",7,0.6,4.2]
[null,null,null,null,null,null,"#200 =",5.3,1.6,8.48]
[null,null,null,"Pbe=",{"$f":"mndot_rounding_1(B6-((E11*B10)/100))","v":4.9000000000000004}]
[null,null,null,null,null,null,null,"Surface area (SA)   =",null,{"$f":"mndot_rounding_1(2+J6+J7+J8+J9+J10+J11+J12)","v":30.8},"SF/lb"]
[null,null,null,null,null,null,null,"Adj. Surface area (SA)   =",null,{"$f":"IF(B9<2.58,mndot_rounding_1(J14*2.65/B9),(IF(B9>2.7,mndot_rounding_1(J14*2.65/B9),J14)))","v":30.8},"SF/lb"]
[]
[]
[null,null,null,null,null,"Fines/Effective AC(F/Pbe) =",null,null,{"$f":"mndot_rounding_1(H12/E13)","v":1.1000000000000001},"ratio"]
[]
[null,null,null,null,"Asphalt Film Thickness (AFT) =",null,null,null,{"$f":"mndot_rounding_1((E13/(B10*J15))*4870)","v":8.1999999999999993},"microns"]
[null,null,null,null,null,"Adjusted AFT = ",null,null,{"$f":"mndot_rounding_1(I20+0.06*(J15-28))","v":8.4},"microns"]
[]
[]
[]
["Guideline notes based on Bituminous Office Consultation"]
["* Use Combined Mix Aggregate for Gsb"]
["* %AC Must be Tenth ex.(5.4)"]
["* Gmm Must be to Thousandth ex.(2.497)"]
["* AC SpG Must be to Thousandth ex.(1.030)"]
["* % Stone will Calculate to Tenth ex.(94.6)"]
["* Gse Calculates to Thousandth ex.(2.718)"]
["* Pba is a mid-step calculation.(not rounded)"]
["* Pbe Calculates to Tenth ex.(4.5)"]
["* % Passing Sieves must be entered to Whole Number ex.(66)"]
["* % Passing #200 sieve must be entered to Tenth ex.(3.6)"]
["* Surface Area (SA) Calculates to Tenth ex.(27.8)"]
["* Asphalt Film Thickness (AFT) is Calculated to Tenth ex.(8.3)"]
["*Fines to Effective % AC is calculated to the tenth ex.(0.9)"]