{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["T283","Notes","Disclaimer"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":3,"defined_names":28,"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":"T283","index":0,"n_rows":35,"n_cols":35,"rows_kept":35,"cut":false,"hidden":false,"merged":[[7,12,7,14],[5,5,5,9],[6,5,6,9],[7,5,7,9],[30,2,34,5],[33,10,33,14],[32,13,32,14],[31,13,31,14],[6,10,6,11],[6,12,6,14],[6,1,6,3],[7,1,7,3],[16,10,16,12],[7,10,7,11],[0,1,0,14],[5,10,5,11],[5,12,5,14],[2,1,2,14],[1,1,1,14],[5,1,5,3]]}
["v 1.0","OKLAHOMA DEPARTMENT OF TRANSPORTATION"]
[null,"AASHTO T 283"]
[null,"ODOT Materials & Research Division"]
[]
[]
[" Project No. ",null,null,null,"J.P. No.",null,null,null,null,null,"Contract No. "]
[" Contractor ",null,null,null,"Producer",null,null,null,null,null," Plant Location "]
["Sample ID ",null,null,null,"Mix Type",null,null,null,null,null,"Design No. "]
[]
[null,"Specimen Number",null,"1","2","3","4","5","6"]
[null,"Diameter, mm","D",150,150,150,150,150,150,null,null,null,"Average Control",{"$f":"IF(COUNT(AD21:AI21)<>0,ROUND(AVERAGE(AD21:AI21),1),\"\")","v":""}]
[null,"Dry Mass in Air, g","A",null,null,null,null,null,null,null,null,null,"(S1)"]
[null,"Mass in Water, g","C"]
[null,"SSD Mass, g","B",null,null,null,null,null,null,null,null,null,"Pre-Con Average",{"$f":"IF(COUNT(AD22:AI22)<>0,ROUND(AVERAGE(AD22:AI22),1),\"\")","v":""}]
[null,"Volume (B-C), cc","E",{"$f":"IF(AND(D14<>\"\",D13<>\"\"),ROUND(D14-D13,1),\"\")","v":""},"","","","",{"$f":"IF(AND(I14<>\"\",I13<>\"\"),ROUND(I14-I13,1),\"\")","v":""},null,null,null,"(S2)"]
[null,"Bulk Specific Gravity (A/E)","Gmb",{"$f":"IF(AND(D12<>\"\",D15<>\"\"),ROUND(D12/D15,3),\"\")","v":""},"","","","",{"$f":"IF(AND(I12<>\"\",I15<>\"\"),ROUND(I12/I15,3),\"\")","v":""}]
[null,"Maximum Specific Gravity","Gmm",null,{"$f":"IF($D17=\"\",\"\",$D17)","v":""},{"$f":"IF($D17=\"\",\"\",$D17)","v":""},"","","",null,"Tensile Strength Ratio (TSR) =",null,null,{"$f":"IF(AND(N14<>\"\",N11<>\"\"),ROUND(N14/N11,2),\"\")","v":""}]
[null,"% Density (100*(Gmb/Gmm))","%Gmm",{"$f":"IF(AND(D16<>\"\",D17<>\"\"),ROUND(100*(D16/D17),1),\"\")","v":""},"","","","",{"$f":"IF(AND(I16<>\"\",I17<>\"\"),ROUND(100*(I16/I17),1),\"\")","v":""},null,null,null,"(S2/S1)"]
[null,"% Air Voids (100-%Gmm)","%Pa",{"$f":"IF(D18<>\"\",ROUND(100-D18,3),\"\")","v":""},"","","","",{"$f":"IF(I18<>\"\",ROUND(100-I18,3),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(This area is for programming of the spreadsheet only)"]
[null,"Volume of Air Voids (%Pa*E/100), cm3","Va",{"$f":"IF(AND(D15<>\"\",D19<>\"\"),ROUND(D19*D15/100,1),\"\")","v":""},"","","","",{"$f":"IF(AND(I15<>\"\",I19<>\"\"),ROUND(I19*I15/100,1),\"\")","v":""}]
[null,"Control or Pre-conditioned?","(C or P)",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,"C",{"$f":"IF(D21=\"C\",D27,\"\")","v":""},"","","","",""]
[null,"Saturated Mass, g","B'",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,"P",{"$f":"IF(D21=\"P\",D27,\"\")","v":""},"","","","",""]
[null,"Volume of Absorbed Water (B'-A), cm3","J'",{"$f":"IF(AND(D22<>\"\",D12<>\"\"),ROUND(D22-D12,1),\"\")","v":""},{"$f":"IF(AND(E21<>\"\",E22<>\"\",E12<>\"\"),ROUND(E22-E12,1),\"\")","v":""},{"$f":"IF(AND(F21<>\"\",F22<>\"\",F12<>\"\"),ROUND(F22-F12,1),\"\")","v":""},{"$f":"IF(AND(G21<>\"\",G22<>\"\",G12<>\"\"),ROUND(G22-G12,1),\"\")","v":""},{"$f":"IF(AND(H21<>\"\",H22<>\"\",H12<>\"\"),ROUND(H22-H12,1),\"\")","v":""},{"$f":"IF(AND(I21<>\"\",I22<>\"\",I12<>\"\"),ROUND(I22-I12,1),\"\")","v":""}]
[null,"% Saturation (100*J'/Va)","%S'",{"$f":"IF(AND(D23<>\"\",D20<>\"\"),ROUND(100*(D23/D20),1),\"\")","v":""},{"$f":"IF(AND(E23<>\"\",E20<>\"\"),ROUND(100*(E23/E20),1),\"\")","v":""},"","","",{"$f":"IF(AND(I23<>\"\",I20<>\"\"),ROUND(100*(I23/I20),1),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Visual","Broken Aggr."]
[null,"Height (4000*E/(π*D2)), mm","t",{"$f":"IF(D15<>\"\",ROUND(4000*D15/(PI()*D11^2),1),\"\")","v":""},{"$f":"IF(E15<>\"\",ROUND(4000*E15/(PI()*E11^2),1),\"\")","v":""},"","","",{"$f":"IF(I15<>\"\",ROUND(4000*I15/(PI()*I11^2),1),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Y"]
[null,"Load, lbf","P",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,1,"N"]
[null,"Indirect Tensile Strength, psi","(S1 or S2)",{"$f":"IF(AND(D25<>\"\",D26<>\"\"),ROUND((2*D26* 25.4^2/(PI()*150*D25)),1),\"\")","v":""},{"$f":"IF(AND(E25<>\"\",E26<>\"\"),ROUND((2*E26* 25.4^2/(PI()*150*E25)),1),\"\")","v":""},"","","",{"$f":"IF(AND(I25<>\"\",I26<>\"\"),ROUND((2*I26* 25.4^2/(PI()*150*I25)),1),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Visual Moisture Damage (0 to 5)",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,3]
[null,"Cracked/Broken Aggregate? (Y/N)",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,4]
[null,"% Air Voids (averages) ","Total",{"$f":"IF(D18=\"\",\"\",ROUND(AVERAGE(D19:I19),1))","v":""},null,"Pre-Con",{"$f":"IFERROR(AVERAGEIF($D$21:$I$21,\"=P\",$D$19:$I$19),\"\")","v":""},"Control",{"$f":"IFERROR(AVERAGEIF($D$21:$I$21,\"=C\",$D$19:$I$19),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,"or    S = (2 * P * (25.4)2) / (π * D * t) "]
[null,"with D = 150 mm, t in mm and P in lbs:",null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,"S = 2.7381 * P / t",null,null,null,null,null,null,null,"Signature / Cert. ID:",null,null,"/"]
[null,"with D = 100 mm, t in mm and P in lbs:",null,null,null,null,null,null,null,"Name:"]
[null,"S = 4.1072 * P / t"]

{"sheet":"Notes","index":1,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"AASHTO T 283 Tips"]
["No.:","Tip:"]
[1,"1561.3 * Gmm - 50 = Estimated weight of T283 specimen compacted to 95 mm height and 150 mm diameter."]
[2,"Set the average control and pre-conditions specimens to be approximately the same-as the total average % air voids for all specimens."]
[3,"For lab compacted specimens, target % density is 93.0 with a range of 92.5 mm to 93.5 mm."]
[4,"For lab compacted specimens, target % air voids is 7.0 with a range of 6.5 to 7.5."]
[5,"100 mm diameter specimens target heights/thickness is 63.5 mm with a range of 61.0 mm to 66.0 mm."]
[6,"150 mm diameter specimens target heights/thickness is 95 mm with a range of 90 mm to 100 mm."]
[7,"Equation (1) constant is h*π*D2/4*0.93/1000=1561.3 when D=150 mm and and h=95 mm."]
[8,"Equation (1) constant h*π*D2/4*0.93/1000=463.8 when D=100 mm and and h=63.5 mm."]
[9,"Equation (1) when D=100 mm and h=63.5 mm is therefore 463.8 * Gmm - 30."]
[10,"For field cores, blend the cores to make specimens 150 mm diameter and 95 mm height at approximately the same air voids as the cores."]
[11,"For field cores, if they can be cut to 63.5 mm in height and 100 mm diameter, perform T283 on those."]

{"sheet":"Disclaimer","index":2,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["By using this file, you are agreeing to this License Agreement:"]
[]
["The Oklahoma Department of Transportation (ODOT) does not provide technical support with respect to these files. Read the following disclaimer for terms of use pior to using this file."]
[]
[]
["ODOT makes no warranty of any kind, express or implied, with respect to any file. ODOT makes no warranty that any file is marketable or fit for any particular purpose. A description of a file shall not be deemed to create an express warranty that the file conforms to that description. You agree to accept the files in the format provided."]
[]
[]
["You assume all risk and liability for any losses, damages, claims, or expenses resulting from the use or possession of any file."]
[]
[]
["You agree to indemnify, defend, and hold harmless ODOT and its officers, agents, and employees from and against any and all claims, suits, losses, damages, or costs, including reasonable attorney's fees, arising from or by reason of your use or possession of any file. This indemnification shall survive your acceptance of any file."]
[]
[]
["Revisions or additions may occur at any time. You agree to indemnify, defend, and hold harmless ODOT and its officers, agents, and employees from and against any and all claims, suits, losses, damages, or costs, including reasonable attorney's fees, arising from the use of outdated files. This indemnification shall survive your acceptance of any file."]
[]
[]
["The files are copyrighted by ODOT and may not be resold without the express written consent of ODOT. "]