{"text_format":"3","workbook":"xls","n_sheets":20,"sheets":["Raw Height Data","Project","Gmm","Gmb","%AC","Dust Proportion","Densification Report","Summary Report","G1 Report","Varying %AC Report","%AC Optimizer","Mixture Report","Individuals Report","VBModule","Specs","Calculations","Settings","InfoBox1","Chart Setup","Pictures"],"not_rendered":{"charts":14,"images":3,"macros":1,"external_links":1,"defined_names":220,"comments":32},"unopened":[{"sheet":"VBModule","index":13,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Raw Height Data","index":0,"n_rows":503,"n_cols":17,"rows_kept":503,"flags":["formulas_cached_only"]}
["V5.01 23-Apr-2002","Blend 1",null,null,"Blend 2",null,null,"Blend 3",null,null,"Blend 4"]
["Gyration Number","Specimen 1","Specimen 2","Specimen 3","Specimen 1","Specimen 2","Specimen 3","Specimen 1","Specimen 2","Specimen 3","Specimen 1","Specimen 2","Specimen 3"]
["0",{"$nulls":15},1]
[1,{"$nulls":15},0]
[2,{"$nulls":15},false]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[259]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[323]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[387]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[447]
[448]
[449]
[450]
[451]
[452]
[453]
[454]
[455]
[456]
[457]
[458]
[459]
[460]
[461]
[462]
[463]
[464]
[465]
[466]
[467]
[468]
[469]
[470]
[471]
[472]
[473]
[474]
[475]
[476]
[477]
[478]
[479]
[480]
[481]
[482]
[483]
[484]
[485]
[486]
[487]
[488]
[489]
[490]
[491]
[492]
[493]
[494]
[495]
[496]
[497]
[498]
[499]
[500]

{"sheet":"Project","index":1,"n_rows":23,"n_cols":9,"rows_kept":23,"flags":["formulas_cached_only"]}
["Project Worksheet - Varying %AC Analysis",{"$nulls":7},"5.01"]
["Workbook Name:","Pine-Prj.xlt",{"$nulls":5},500]
["Project Name:"]
["Technician:"]
["Date:"]
[]
[{"$nulls":5},"Asphalt Grade:"]
["Design ESAL's (millions):",0.3,{"$nulls":3},"Compaction Temp:",null,"°C"]
["Depth from Surface:",30,"mm",null,null,"Mixture Temp:",null,"°C"]
["Nom. Sieve Size:",null,"mm",null,null,"Design Temperature:",null,"°C"]
["Specimen Diameter:",null,"mm"]
[]
[null,"From Table","Manual Entry",{"$nulls":3},"Blend Identifiers"]
["N Initial:",7,12,null,null,"Blend 1:"]
["N Design:",75,100,null,null,"Blend 2:"]
["N Max:",115,144,null,null,"Blend 3:"]
[{"$nulls":5},"Blend 4:"]
[]
[]
[{"$nulls":5},"Key to Cell Colors"]
[{"$nulls":6},"= Entry Required"]
[{"$nulls":6},"= Entry Optional"]
[{"$nulls":6},"= Calculated"]

{"sheet":"Gmm","index":2,"n_rows":25,"n_cols":13,"rows_kept":25,"flags":["formulas_cached_only"]}
[null,"Max. Theoretical Specific Gravity (Gmm) Worksheet"]
[2]
[]
[null,"Blend 1",null,null,"Blend 2",null,null,"Blend 3",null,null,"Blend 4"]
[null,"Specimen 1","Specimen 2","Specimen 3","Specimen 1","Specimen 2","Specimen 3","Specimen 1","Specimen 2","Specimen 3","Specimen 1","Specimen 2","Specimen 3"]
["Sample + Bowl Wt. in Air:"]
["Bowl Wt. in Air:"]
["Sample + Bowl Wt. in Water:"]
["Bowl Wt. in Water:"]
[]
["Gmm:","","","","","","","","","","","",""]
[]
["User-Supplied Average Gmm:"]
["Dry Sample Weight:"]
["Volumeter Weight:"]
["Wt. of Volumeter + Sample + Water:"]
[]
["Gmm:","","","","","","","","","","","",""]
[]
["Gmm Used in Calculations:",null,{"v":0,"d":"0.000"},null,null,{"v":0,"d":"0.000"},null,null,{"v":0,"d":"0.000"},null,null,{"v":0,"d":"0.000"}]
[]
[]
["Methods:"]
["AASHTO:  T 209-90"]
["      ASTM:  D2041-91"]

{"sheet":"Gmb","index":3,"n_rows":20,"n_cols":13,"rows_kept":20,"flags":["formulas_cached_only"]}
[null,"Bulk Specific Gravity (Gmb) Worksheet"]
[2]
[]
[null,"Blend 1",null,null,"Blend 2",null,null,"Blend 3",null,null,"Blend 4"]
[null,"Specimen 1","Specimen 2","Specimen 3","Specimen 1","Specimen 2","Specimen 3","Specimen 1","Specimen 2","Specimen 3","Specimen 1","Specimen 2","Specimen 3"]
["Specimen Weight in Air:"]
["Specimen Weight in Water:"]
["SSD Weight in Air:"]
["User-Supplied Gmb (calculated elsewhere):"]
["Gmb @ Nmax (from mass):","","","","","","","","","","","",""]
["Gmm (average):",{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
["%Gmm @ Nmax (corrected):",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["%Air Voids @ Nmax (corrected):",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
["Gmb @ Nmax (from Height):",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[]
["Methods:"]
["AASHTO:  T 166-88"]
["          ASTM:  D2726-93"]

{"sheet":"%AC","index":4,"n_rows":7,"n_cols":5,"rows_kept":7,"flags":["formulas_cached_only"]}
["Trial Asphalt Binder Content (%AC) Worksheet"]
[]
[]
[null,"Blend 1","Blend 2","Blend 3","Blend 4"]
["Aggregate Bulk Specific Gravity (Gsb):"]
["Percent Binder by wt. of mix (Pbi):"]
["Percent Aggregate (Ps):","","","",""]

{"sheet":"Dust Proportion","index":5,"n_rows":15,"n_cols":5,"rows_kept":15,"flags":["formulas_cached_only"]}
["Dust Proportion (Fines/Pbe) Worksheet"]
[]
[null,"Inputs"]
[null,"Blend 1","Blend 2","Blend 3","Blend 4"]
["Specific Gravity of Binder(Gb):"]
["Fines (% Passing .075mm Sieve)"]
[]
[null,"Outputs"]
["Absorbed binder: % by wt. of aggregate (Pba)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Absorbed binder: % by total wt. of mixture (Pba')",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Percent AC (Pbi)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Effective Specific Gravity (Gse)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Effective % Binder (Pbe)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
["Dust Proportion (Fines/Pbe)","","","",""]

{"sheet":"Densification Report","index":6,"n_rows":49,"n_cols":11,"rows_kept":49,"flags":["formulas_cached_only"]}
[null,"Project Name:","",{"$nulls":6},"N Initial:",7]
[null,"Workbook Name:","Pine-Prj.xlt",{"$nulls":6},"N Design:",75]
[null,"Technician:","",{"$nulls":6},"N Max:",115]
[null,"Date:","",{"$nulls":6},"Nom. Sieve Size:","19mm"]
[null,"Asphalt Grade:","",{"$nulls":6},"Design Temperature:","°C"]
[null,"Compaction Temp:","°C",{"$nulls":6},"Design ESAL's (millions):",".3"]
[]
["Blend 1"]
[null,"Specimen 1",null,null,"Specimen 2",null,null,"Specimen 3"]
["#Gyr","Ht.","%Gmm","%Gmm","Ht.","%Gmm","%Gmm","Ht.","%Gmm","%Gmm","Avg."]
[null,"(mm)","(Est.)","(Corr)","(mm)","(Est.)","(Corr)","(mm)","(Est.)","(Corr)"]
[7,"","","","","","","","","",""]
[75,"","","","","","","","","",""]
[115,"","","","","","","","","",""]
["Gmb","",null,null,"",null,null,""]
["Gmm",{"v":0,"d":"0.000"}]
[]
[]
["Blend 2"]
[null,"Specimen 1",null,null,"Specimen 2",null,null,"Specimen 3"]
["#Gyr","Ht.","%Gmm","%Gmm","Ht.","%Gmm","%Gmm","Ht.","%Gmm","%Gmm","Avg."]
[null,"(mm)","(Est.)","(Corr)","(mm)","(Est.)","(Corr)","(mm)","(Est.)","(Corr)"]
[7,"","","","","","","","","",""]
[75,"","","","","","","","","",""]
[115,"","","","","","","","","",""]
["Gmb","",null,null,"",null,null,""]
["Gmm",{"v":0,"d":"0.000"}]
[]
[]
["Blend 3"]
[null,"Specimen 1",null,null,"Specimen 2",null,null,"Specimen 3"]
["#Gyr","Ht.","%Gmm","%Gmm","Ht.","%Gmm","%Gmm","Ht.","%Gmm","%Gmm","Avg."]
[null,"(mm)","(Est.)","(Corr)","(mm)","(Est.)","(Corr)","(mm)","(Est.)","(Corr)"]
[7,"","","","","","","","","",""]
[75,"","","","","","","","","",""]
[115,"","","","","","","","","",""]
["Gmb","",null,null,"",null,null,""]
["Gmm",{"v":0,"d":"0.000"}]
[]
[]
["Blend 4"]
[null,"Specimen 1",null,null,"Specimen 2",null,null,"Specimen 3"]
["#Gyr","Ht.","%Gmm","%Gmm","Ht.","%Gmm","%Gmm","Ht.","%Gmm","%Gmm","Avg."]
[null,"(mm)","(Est.)","(Corr)","(mm)","(Est.)","(Corr)","(mm)","(Est.)","(Corr)"]
[7,"","","","","","","","","",""]
[75,"","","","","","","","","",""]
[115,"","","","","","","","","",""]
["Gmb","",null,null,"",null,null,""]
["Gmm",{"v":0,"d":"0.000"}]

{"sheet":"Summary Report","index":7,"n_rows":31,"n_cols":7,"rows_kept":31,"flags":["formulas_cached_only"]}
["Project Name:","",{"$nulls":3},"N Initial:",7]
["Workbook Name:","Pine-Prj.xlt",{"$nulls":3},"N Design:",75]
["Technician:","",{"$nulls":3},"N Max:",115]
["Date:","",{"$nulls":3},"Nom. Sieve Size:","19mm"]
["Asphalt Grade:","",{"$nulls":3},"Design Temperature:","°C"]
["Compaction Temp:","°C",{"$nulls":3},"Design ESAL's (millions):",".3"]
[]
[]
["Blend","%AC","%Gmm @ N = 7   (corrected)","%Gmm @ N = 75   (corrected)","%Gmm @ N = 115   (corrected)","%Air Voids @ NDesign","%VMA @ NDesign"]
["Blend 1","","","","","",""]
["Blend 2","","","","","",""]
["Blend 3","","","","","",""]
["Blend 4","","","","","",""]
[]
[]
["Blend","Estimated %AC @ 4% Va","Estimated %Gmm @ N = 7 (90.5% Max)","Estimated %Gmm @ N = 75 (96% Max)","Estimated %Gmm @ N = 115 (98% Max)","Estimated %VMA  @ NDesign (13 % Min)","Estimated %VFA @ NDesign (65% - 78%)"]
["Blend 1","","","","","",""]
["Blend 2","","","","","",""]
["Blend 3","","","","","",""]
["Blend 4","","","","","",""]
[]
[]
[null,"Blend 1","Blend 2","Blend 3","Blend 4"]
["Ag. Bulk Specific Gravity (Gsb):","","","",""]
["Percent Binder by wt. of mix (Pbi):","","","",""]
["Percent Aggregate (Ps):","","","",""]
["Specific Gravity of Binder (Gb):","","","",""]
["Fines (%Passing 0.075mm Sieve):","","","",""]
["Effective Specific Gravity (Gse):","","","",""]
["Effective % Binder (Pbe):","","","",""]
["Dust Proportion (0.6-1.2%):","","","",""]

{"sheet":"G1 Report","index":8,"n_rows":23,"n_cols":11,"rows_kept":23,"hidden":true,"flags":["formulas_cached_only"]}
[{"$nulls":10},"Gyratory Compaction Report"]
[]
[{"$nulls":5},"Date:",{"$nulls":3},"Machine S/N:"]
[{"$nulls":5},"Time:",{"$nulls":3},"Mode:"]
[{"$nulls":5},"Filename:",{"$nulls":3},"Mold Diameter:"]
[{"$nulls":5},"Specimen ID:","Specimen 2",null,null,"Technician:"]
[]
[null,0,1,2,3,4,5,6,7,8,9]
[0,142.1,139.8,137.9,136.2,134.7,133.5,132.4,131.5,130.6,129.9]
[10,129.3,128.7,128.1,127.7,127.2,126.8,126.4,126.1,125.7,125.4]
[20,125.1,124.8,124.6,124.3,124.1,123.8,123.6,123.4,123.2,{"v":123,"d":"123.0"}]
[30,122.8,122.6,122.4,122.3,122.1,121.9,121.8,121.6,121.5,121.4]
[40,121.2,121.1,{"v":121,"d":"121.0"},120.8,120.7,120.6,120.5,120.4,120.3,120.2]
[50,120.1,{"v":120,"d":"120.0"},119.9,119.8,119.7,119.6,119.5,119.4,119.4,119.3]
[60,119.2,119.1,119.1,{"v":119,"d":"119.0"},118.9,118.8,118.8,118.7,118.6,118.6]
[70,118.5,118.5,118.4,118.3,118.3,118.2,118.1,118.1,{"v":118,"d":"118.0"},{"v":118,"d":"118.0"}]
[80,117.9,117.8,117.8,117.7,117.7,117.6,117.5,117.5,117.4,117.4]
[90,117.3,117.3,117.2,117.2,117.1,117.1,{"v":117,"d":"117.0"},{"v":117,"d":"117.0"},116.9,116.8]
[100,116.8,116.8,116.7,116.7,116.7,116.6,116.6,116.6,116.6,116.5]
[110,116.5,116.5,116.4,116.4,116.4,116.3,116.3,116.3,116.2,116.2]
[120,116.2,116.1,116.1,116.1,{"v":116,"d":"116.0"},115.9,{"v":116,"d":"116.0"},115.9,115.9,115.9]
[130,115.8,115.8,115.8,115.8,115.7,115.7,115.7,115.6,115.6,115.6]
[140,115.5,115.5,115.5,115.4,115.4]

{"sheet":"Varying %AC Report","index":9,"n_rows":80,"n_cols":7,"rows_kept":80,"flags":["formulas_cached_only"]}
[null,"Project Name:","",null,null,"N Initial:",7]
[null,"Workbook Name:","Pine-Prj.xlt",null,null,"N Design:",75]
[null,"Technician:","",null,null,"N Max:",115]
[null,"Date:","",null,null,"Nom. Sieve Size:","19mm"]
[null,"Asphalt Grade:","",null,null,"Design Temperature:","°C"]
[null,"Compaction Temp:","°C",null,null,"Design ESAL's (millions):",".3"]
{"$rows_empty":28}
[null,"Y",null,"X"]
["Blend","%AC","Air Voids @ NMax","Air Voids @ NDesign","%VMA NDesign","%VFA @ NDesign"]
["Blend 1",{"$error":"#N/A"},"","","",""]
["Blend 2",{"$error":"#N/A"},"","","",""]
["Blend 3",{"$error":"#N/A"},"","","",""]
["Blend 4",{"$error":"#N/A"},"","","",""]
[]
[null,"Project Name:","",null,null,"N Initial:",7]
[null,"Workbook Name:","Pine-Prj.xlt",null,null,"N Design:",75]
[null,"Technician:","",null,null,"N Max:",115]
[null,"Date:",""]
[null,"Asphalt Grade:","",null,null,"Design Temperature:","°C"]
[null,"Compaction Temp:","°C",null,null,"Design ESAL's (millions):",".3"]
{"$rows_empty":28}
["Blend","%AC","%Gmm @ NInitial","%Gmm @  Nmax","Unit Wt. (kg/m3) NDesign","Dust/Asph Ratio"]
["Blend 1",{"$error":"#N/A"},"","","",""]
["Blend 2",{"$error":"#N/A"},"","","",""]
["Blend 3",{"$error":"#N/A"},"","","",""]
["Blend 4",{"$error":"#N/A"},"","","",""]

{"sheet":"%AC Optimizer","index":10,"n_rows":19,"n_cols":15,"rows_kept":19,"flags":["formulas_cached_only"]}
[]
[]
[]
[{"$nulls":11},"%Air Voids vs. %Binder"]
[{"$nulls":12},"Min","Max"]
[{"$nulls":11},"Vertical (% Voids)",{"v":2,"d":"2.0"},{"v":8,"d":"8.0"}]
[{"$nulls":11},"Horizontal (%AC)",{"v":4,"d":"4.0"},{"v":6,"d":"6.0"}]
{"$rows_empty":7}
[{"$nulls":11},"Blend","%AC","Air Voids @ Nmax","Air Voids @ NDesign"]
[{"$nulls":11},"Blend 1",{"$error":"#N/A"},"",""]
[{"$nulls":11},"Blend 2",{"$error":"#N/A"},"",""]
[{"$nulls":11},"Blend 3",{"$error":"#N/A"},"",""]
[{"$nulls":11},"Blend 4",{"$error":"#N/A"},"",""]

{"sheet":"Mixture Report","index":11,"n_rows":31,"n_cols":7,"rows_kept":31,"flags":["formulas_cached_only"]}
["Mixture Summary Report for Varying %AC Analysis"]
["Project Name:","",null,"N Initial:",null,null,7]
["Workbook Name:","Pine-Prj.xlt",null,"N Design:",null,null,75]
["Technician:","",null,"N Max:",null,null,115]
["Date:","",null,"Nom. Sieve Size:",null,null,"19 mm"]
["Asphalt Grade:","",null,"Compaction Temperature:",null,null," °C"]
[{"$nulls":3},"Mixture Temperature:",null,null,"°C"]
["Design ESAL's (millions):",".3",null,"Depth from Surface (mm):",null,null,"30 mm"]
["Design Temperature:","°C",null,"Mold Size:",null,null,"150 mm"]
[]
[null,"Results"]
["Property","Blend 1","Blend 2","Blend 3","Blend 4","Criteria"]
[]
["%AC","","","",""]
["%Air Voids (Va)","","","","",{"v":4,"d":"4.0"},"%"]
[]
["%VMA","","","","",{"v":13,"d":"13.0"},"% Min."]
["%VFA","","","","",{"v":65,"d":"65.0"},"% Min."]
[{"$nulls":5},{"v":78,"d":"78.0"},"% Max."]
["Dust/Asphalt Ratio","","","","","0.6 - 1.2","%"]
[]
["Max. Specific Gravity (Gmm)",{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
["Bulk Specific Gravity (Gmb)","","","",""]
[]
["%Gmm @ Nini","","","","",90.5,"% Max."]
["%Gmm @ Ndes","","","","",{"v":96,"d":"96.0"},"% Max."]
["%Gmm @ Nmax","","","","",{"v":98,"d":"98.0"},"% Max."]
[]
["Effective Sp. Gravity of Blend (Gse)","","","","","---"]
["Sp. Gravity of Binder (Gb)","","","","","---"]
["Sp. Gravity of Aggregate (Gsb)","","","","","---"]

{"sheet":"Individuals Report","index":12,"n_rows":1,"n_cols":1,"rows_kept":1,"flags":["formulas_cached_only"]}
["%Gmm Charts for Individual Specimens"]

{"sheet":"Specs","index":14,"n_rows":36,"n_cols":16,"rows_kept":36,"hidden":true,"flags":["formulas_cached_only"]}
["Project Specifications",{"$nulls":11},"Values used in Charts & Reports"]
[{"$nulls":12},"(extracted from tables to left)"]
[]
[null,null,"Table 1",{"$nulls":10},"Design ESAL's:",0.3,"From Project Worksheet"]
[null,null,"Superpave Gyratory",{"$nulls":10},"Values Calculated from Table"]
[null,null," Compaction Effort",{"$nulls":3},"Required Density",{"$nulls":6},"N Initial:",7]
[null,"Range","ESALS x 106","Nini","Ndes","Nmax","Nini","Ndes","Nmax",{"$nulls":4},"N Design:",75]
[null,"< 0.3",{"v":0,"d":"0.0"},6,50,75,91.5,{"v":96,"d":"96.0"},{"v":98,"d":"98.0"},{"$nulls":4},"N Max:",115]
[null,"0.3 to < 3",0.3,7,75,115,90.5,{"v":96,"d":"96.0"},{"v":98,"d":"98.0"}]
[null,"3.0 to < 30",{"v":3,"d":"3.0"},8,100,160,{"v":89,"d":"89.0"},{"v":96,"d":"96.0"},{"v":98,"d":"98.0"}]
[null,">= 30",{"v":30,"d":"30.0"},9,125,205,{"v":89,"d":"89.0"},{"v":96,"d":"96.0"},{"v":98,"d":"98.0"},{"$nulls":4},"Values Used in Equations"]
[{"$nulls":13},"N Initial:",7]
[{"$nulls":13},"N Design:",75]
[{"$nulls":13},"N Max:",115]
[]
[]
[{"$nulls":3},"VFA Limits vs. Nominal Sieve Size and Traffic Level",{"$nulls":9},"Density Limits for Charts"]
[{"$nulls":13},"N Initial:",90.5]
[{"$nulls":3},"9.5mm",null,"25.0mm",null,"37.5mm",null,"All Others",{"$nulls":3},"N Design:",{"v":96,"d":"96.0"}]
[null,"Range","ESALS x 106","Min","Max","Min","Max","Min","Max","Min","Max",null,null,"N Max:",{"v":98,"d":"98.0"}]
[null,"< 0.3",{"v":0,"d":"0.0"},70,80,67,80,64,80,70,80]
[null,"0.3 to < 3",0.3,65,78,65,78,64,78,65,78,null,null,"VFA Min",65]
[null,"3.0 to < 30",{"v":3,"d":"3.0"},73,76,65,75,64,75,65,75,null,null,"VFA Max",78]
[null,">= 30",{"v":30,"d":"30.0"},73,76,65,75,64,75,65,75]
[{"$nulls":13},"VMA Min",{"v":13,"d":"13.0"}]
[]
[{"$nulls":13},"DP Min.",0.6]
[{"$nulls":13},"DP Max.",1.2]
[null,null,"VMA Limit"]
[null,null,"Nominal Sieve","Min VMA",null,"Dust Proportion"]
[null,null,9.5,{"v":15,"d":"15.0"},null,"Min.",0.6,{"$nulls":6},"VA Min.",{"v":4,"d":"4.0"}]
[null,null,12.5,{"v":14,"d":"14.0"},null,"Max.",1.2]
[null,null,{"v":19,"d":"19.0"},{"v":13,"d":"13.0"}]
[null,null,{"v":25,"d":"25.0"},{"v":12,"d":"12.0"}]
[null,null,37.5,{"v":11,"d":"11.0"},null,"Air Voids"]
[null,null,{"v":50,"d":"50.0"},10.5,null,"Min.",{"v":4,"d":"4.0"}]

{"sheet":"Calculations","index":15,"n_rows":56,"n_cols":13,"rows_kept":56,"hidden":true,"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"Blend 1",null,null,"Blend 2",null,null,"Blend 3",null,null,"Blend 4"]
[null,"Specimen 1","Specimen 2","Specimen 3","Specimen 1","Specimen 2","Specimen 3","Specimen 1","Specimen 2","Specimen 3","Specimen 1","Specimen 2","Specimen 3"]
["%Gmm @ N Ini (corrected):","","","","","","","","","","","",""]
["Average:",null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[]
["%Gmm @ N Des (corrected):","","","","","","","","","","","",""]
["Average:",null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[]
["%Gmm @ N Max (corrected):","","","","","","","","","","","",""]
["Average:",null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[]
["VMA (Equation XV):",null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
["AirVoids (Equation XIV):",null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
["Constant:",null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
["Estimated VMA (Equation XVII):",null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
["Estimated VFA (Equation XVIII):",null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
["GmmIni (Equation XIX):",null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
["GmmMax (Equation XX):",null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
["PbEst (Equation XVI):",null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
["Average Gmb (measured):",null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
["AirVoids at Nmax:",null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
["Mold Base Area (150mm Diam):",null,{"v":17671.458676442588,"d":"17671.5"}]
[]
[]
[null,null,"%Binder","%Voids @Ndes","%VMA","%VFA","%Voids @Nmax"]
[null,null,{"v":0,"d":"0.0"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,null,"Percent Lines for Varying Asphalt Content Charts"]
[null,null,"% AC","VMA Chart","VFA Chart",null,"Voids Chart","Nini Chart","Nmax Chart","Dust Chart"]
[null,null,3.5,13,65,78,4,90.5,98,0.6,1.2]
[null,null,{"v":7,"d":"7.0"},13,65,78,4,90.5,98,0.6,1.2]
[]
[null,null,"Ranges added to %Gmm Chart for percent lines.",{"$nulls":5},"=Not plotted when CompacMode = 1 (to Ndes)"]
[null,null,1,90.5,96,98]
[null,null,1000,90.5,96,98,{"$nulls":3},"Sieves"]
[{"$nulls":9},1,9.5]
[null,null,"This table is used for adding the vertical lines to the Gmm chart",{"$nulls":6},2,12.5]
[null,null,7,80,75,80,115,80,null,3,{"v":19,"d":"19.0"}]
[null,null,7,89,75,96,115,98,null,4,{"v":25,"d":"25.0"}]
[{"$nulls":9},5,37.5]
[null,null,"This table is used to calculate density in Kg/Cu. M",{"$nulls":6},3,{"v":19,"d":"19.0"}]
[{"$nulls":3},"Spec 1","Spec 2","Spec 3","Average * 1000",null,null,"Specimen Diameter"]
[null,null,"Blend 1","","","",{"$error":"#DIV/0!"},null,null,1,100]
[null,null,"Blend 2","","","",{"$error":"#DIV/0!"},null,null,2,150]
[null,null,"Blend 3","","","",{"$error":"#DIV/0!"},null,null,{"v":150,"d":"150.0"},2]
[null,null,"Blend 4","","","",{"$error":"#DIV/0!"}]
[{"$nulls":9},"Trial Type:",2]
[null,null,"Raw Height Data"]
[{"$nulls":9},"Entry Mode:",1]
[{"$nulls":9},"Compaction Mode:",2]

{"sheet":"Settings","index":16,"n_rows":26,"n_cols":6,"rows_kept":26,"hidden":true,"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[{"$nulls":3},"The following items have an effect on the project specifications or specification limits:"]
[{"$nulls":3},"Item","Current Value","Affected"]
[{"$nulls":3},"Mold Diameter:","150 mm","Gmb (from height)"]
[{"$nulls":3},"Compaction Effort Entry Mode:","From Table","Nini, Ndes, Nmax"]
[{"$nulls":3},"Compaction Mode:","To Nmax","%Gmm @Nmax"]
[{"$nulls":3},"Trial Type:","Varying % AC Analysis","Report Titles"]
[{"$nulls":3},"Nominal Sieve Size:","19 mm","%VMA Min. Limit"]
[{"$nulls":3},"Design ESALs:",0.3,"VFA limits, Nini, Ndes, Nmax"]
[]
[]
[]
[]
[{"$nulls":3},"The following items are for reference only and have no effect on project specifications:"]
[{"$nulls":3},"Item","Current Value"]
[{"$nulls":3},"Asphalt Grade:",""]
[{"$nulls":3},"Compaction Temp:",""]
[{"$nulls":3},"Mixture Temp:",""]
[{"$nulls":3},"Design Temp:",""]
[]
[{"$nulls":3},"Gmm Method:","Direct Entry"]
[{"$nulls":3},"Gmb Method:","Direct Entry"]
[{"$nulls":3},"Depth From Surface:","30 mm"]

{"sheet":"InfoBox1","index":17,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true,"flags":["formulas_cached_only"]}

{"sheet":"Chart Setup","index":18,"n_rows":42,"n_cols":8,"rows_kept":42,"hidden":true,"flags":["formulas_cached_only"]}
[]
[]
[null,"Set vertical and horizontal scales as desired for charts on Varying %AC Report."]
[null,"Click OK when finished."]
[]
[]
[null,"%Gmm vs. Gyrations",{"$nulls":3},"%Air Voids"]
[null,null,"Min","Max",null,null,"Min","Max"]
[null,"Veritcal",{"v":80,"d":"80.0"},{"v":100,"d":"100.0"},null,"Vertical",{"v":0,"d":"0.0"},{"v":8,"d":"8.0"}]
[null,"Horizontal (Gyr)","Fixed","Fixed",null,"Horizontal (%AC)",3.5,{"v":7,"d":"7.0"}]
[]
[]
[null,"%VMA",{"$nulls":3},"%VFA"]
[null,null,"Min","Max",null,null,"Min","Max"]
[null,"Vertical",{"v":10,"d":"10.0"},{"v":15,"d":"15.0"},null,"Vertical",{"v":50,"d":"50.0"},{"v":100,"d":"100.0"}]
[null,"Horizontal (%AC)",3.5,{"v":7,"d":"7.0"},null,"Horizontal (%AC)",3.5,{"v":7,"d":"7.0"}]
[]
[]
[null,"%Gmm @ Ninitial",{"$nulls":3},"%Gmm @ Ndes (or Nmax)"]
[null,null,"Min","Max",null,null,"Min","Max"]
[null,"Vertical",{"v":82,"d":"82.0"},{"v":92,"d":"92.0"},null,"Vertical",{"v":94,"d":"94.0"},{"v":100,"d":"100.0"}]
[null,"Horizontal (%AC)",3.5,{"v":7,"d":"7.0"},null,"Horizontal (%AC)",3.5,{"v":7,"d":"7.0"}]
[]
[]
[null,"Density",{"$nulls":3},"Dust Proportion"]
[null,null,"Min","Max",null,null,"Min","Max"]
[null,"Vertical",{"v":2300,"d":"2300.0"},{"v":2500,"d":"2500.0"},null,"Vertical",0.4,{"v":2,"d":"2.0"}]
[null,"Horizontal (%AC)",3.5,{"v":7,"d":"7.0"},null,"Horizontal (%AC)",3.5,{"v":7,"d":"7.0"}]
[]
[]
[]
[]
[null,null,"Default Scales"]
[null,"%Gmm",{"v":80,"d":"80.0"},{"v":100,"d":"100.0"}]
[null,"%Air Voids",{"v":0,"d":"0.0"},{"v":8,"d":"8.0"}]
[null,"%VMA",{"v":10,"d":"10.0"},{"v":15,"d":"15.0"}]
[null,"%VFA",{"v":50,"d":"50.0"},{"v":100,"d":"100.0"}]
[null,"%Gmm @ Nini",{"v":82,"d":"82.0"},{"v":92,"d":"92.0"}]
[null,"%Gmm @ Nmax",{"v":94,"d":"94.0"},{"v":100,"d":"100.0"}]
[null,"Density",{"v":2300,"d":"2300.0"},{"v":2500,"d":"2500.0"}]
[null,"Dust Proportion",0.4,{"v":2,"d":"2.0"}]
[null,"%Binder (x-axis)",3.5,{"v":7,"d":"7.0"}]

{"sheet":"Pictures","index":19,"n_rows":43,"n_cols":3,"rows_kept":43,"hidden":true,"flags":["formulas_cached_only"]}
{"$rows_empty":8}
["Revisions:"]
["Rev.","Date","Description"]
["5.00","2000-03-10","1.  Fixed minor bug that forced user to enter a value for Nmax even if they were only compacting to Ndesign."]
[null,null,"2.  Made minor changes to pinemacs.xls.  Nmax box styles were not correct when CompacMode and EntryMode were toggled."]
["5.00a","2000-04-04","1.  Added \"Automatic Calculation\" checkbox to Project worksheet.  When workbook opens the calculation mode is set"]
[null,null,"     based on the state of this box.  The box is linked to 'AutoCalcOn' (Cell H3).  Workbooks will now open and run in either"]
[null,null,"     manual or automatic Calculation mode at the user's preference.  Pinemacs.xls was modified to support this feature."]
[null,null,"2.  Protected Raw Height Data worksheet.  It was left unprotected after last revs."]
[null,null,"3.  Removed temporary formulas from 'Project'!J17 & J18.  They were accidently left there after last revs."]
[null,null,"4.  Removed logo from InfoBox and made the box smaller so it will fit on lower-resolution screens."]
[null,null,"5.  Added 'a' to Cell I2 on Project worksheet so that Comm. Module can read rev. level and behave accordingly."]
[null,null,"6.  Deleted unused logos from this worksheet."]
["5.00a-1","2000-05-19","The most significant change that was made in going from Version 5.00a to 5.00a-1, is that the aggregate "]
[null,null,"templates have now been combined into one template.  Instead of having five separate aggregate templates "]
[null,null,"(one for each nominal sieve size), there is now only ONE \"universal\" template which can be used for "]
[null,null,"designing aggregate blends using any of the five nominal sieve sizes.  When using this template to "]
[null,null,"create a workbook, the designer simply selects the desired sieve size from within the workbook and all "]
[null,null,"charts, limits, etc. are adjusted accordingly."]
[]
[null,null,"The Pine375.xlt, Pine250.xlt, Pine190.xlt, Pine125.xlt, and Pine095.xlt templates have been replaced "]
[null,null,"by the single template named PineAgs.xlt."]
[]
[null,null,"In addition, a minor error in the Blend (weigh-up) worksheets has been corrected. In the previous "]
[null,null,"version the sieve sizes did not line up properly with the weights when in the \"Weight Retained\" mode."]
[]
[null,null,"In the Project Template (Pine-Prj.xlt) one minor bug was fixed.  On the Densification Chart the vertical "]
[null,null,"blue lines representing N-initial, N-design, and N-max were not always re-displayed when switching "]
[null,null,"compaction modes."]
["5.00a-2","2000-07-25","This version corrects two minor errors in the PineAgs.xlt (aggregates)workbook template:"]
[null,null,"1.  Vbe (estimated) is now being calculated correctly for all sieve sizes."]
[null,null,"2.  The Cold Feed Blend weights in the Blend Sheets are now being calculated correctly.  A column for Individual "]
[null,null,"    Weights has been added."]
[null,null,"In this version PINEMACS.XLS was eliminated.  All of the VB code from PINEMACS is now embedded in THIS template"]
[null,null,"(Pine-Prj.xlt).  The Pine toolbar attached to this template is named \"Pine500a.\"  I also detached the Pine500 Toolbar"]
[null,null,"from this workbook.  It will no longer be used."]