{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["TR 448A",".45 Power Chart","Limits","VB Module 1","VB Module 2","Sheet1"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":25,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"VB Module 1","index":3,"reason":"part_missing"},{"sheet":"VB Module 2","index":4,"reason":"part_missing"}],"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":"TR 448A","index":0,"n_rows":71,"n_cols":27,"rows_kept":71,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,4,0,12],[0,13,0,16],[0,17,0,20],[1,0,6,3],[1,13,1,16],[1,17,1,20],[3,6,3,7],[3,8,3,9],[2,13,2,16],[2,17,2,20],[6,13,6,18],[6,19,6,20],[2,6,2,7],[4,6,4,9],[4,13,4,18],[5,13,5,18],[5,19,5,20],[4,19,4,20],[3,19,3,20],[3,15,3,18],[5,7,5,8],[2,8,2,10],[1,6,1,10],[14,14,14,17],[8,0,8,1],[8,2,8,4],[8,5,8,6],[8,7,8,12],[8,14,8,20],[10,0,10,3],[10,4,10,11],[10,12,10,14],[10,15,10,20],[17,0,17,4],[17,5,17,7],[17,8,17,10],[17,11,17,13],[17,14,17,16],[17,17,17,20],[12,0,12,4],[12,5,12,6],[12,7,12,10],[12,11,12,12],[12,13,12,15],[12,16,12,17],[16,0,16,4],[16,5,16,7],[16,8,16,10],[16,11,16,13],[16,14,16,16],[16,17,16,20],[12,19,12,20],[14,0,14,1],[14,2,14,3],[14,4,14,6],[14,7,14,11],[14,12,14,13],[19,0,19,4],[19,5,19,7],[19,8,19,10],[19,11,19,13],[19,14,19,16],[19,17,19,20],[18,0,18,4],[18,5,18,7],[18,8,18,10],[18,11,18,13],[18,14,18,16],[18,17,18,20],[21,0,21,4],[21,5,21,7],[21,8,21,10],[21,11,21,13],[21,14,21,16],[21,17,21,20],[20,0,20,4],[20,5,20,7],[20,8,20,10],[20,11,20,13],[20,14,20,16],[20,17,20,20],[29,2,31,2],[40,3,40,5],[40,0,40,2],[22,0,22,4],[22,5,22,7],[22,8,22,10],[22,11,22,13],[22,14,22,16],[22,17,22,20],[40,14,40,16],[33,0,33,4],[33,6,33,10],[33,11,33,13],[33,14,34,16],[33,17,34,17],[26,11,26,13],[25,11,25,13],[26,14,26,16],[25,14,25,16],[24,0,24,4],[24,5,24,7],[24,8,24,10],[24,11,24,13],[24,14,24,16],[64,0,64,20],[66,0,66,2],[70,0,70,2],[70,18,70,20],[68,18,68,20],[66,18,66,20],[66,15,66,16],[68,15,68,16],[70,15,70,16],[66,12,66,14],[38,0,39,2],[34,0,34,4],[35,0,35,4],[34,6,34,10],[34,11,34,13],[41,0,42,2],[41,3,42,5],[38,14,39,16],[57,0,57,20],[47,1,47,3],[50,1,50,3],[51,1,51,3],[49,0,49,20],[50,7,50,9],[51,4,51,6],[51,7,51,9],[51,10,51,11],[50,12,50,15],[50,16,50,19],[51,12,51,15],[51,16,51,19],[55,1,55,3],[26,17,26,20],[25,17,25,20],[26,0,26,4],[25,0,25,4],[26,5,26,7],[25,5,25,7],[26,8,26,10],[25,8,25,10],[28,0,28,20],[55,16,55,19],[54,16,54,19],[53,16,53,19],[52,16,52,19],[55,12,55,15],[54,12,54,15],[53,12,53,15],[55,4,55,6],[54,4,54,6],[52,4,52,6],[55,7,55,9],[54,7,54,9],[53,7,53,9],[52,7,52,9],[55,10,55,11],[54,10,54,11],[53,10,53,11],[52,10,52,11],[24,17,24,20],[23,0,23,4],[23,5,23,7],[23,8,23,10],[23,11,23,13],[23,14,23,16],[23,17,23,20],[43,14,43,16],[41,14,42,16],[38,6,39,7],[38,8,39,9],[38,10,39,11],[38,12,39,13],[38,17,39,20],[40,17,40,20],[41,17,42,20],[40,6,40,7],[40,8,40,9],[40,10,40,11],[40,12,40,13],[41,12,42,13],[41,6,42,7],[43,6,43,7],[41,8,42,9],[43,17,43,20],[46,18,46,19],[47,18,47,19],[46,15,46,17],[47,15,47,17],[46,12,46,14],[47,12,47,14],[46,10,46,11],[47,10,47,11],[45,0,45,20],[46,1,46,3],[58,17,61,19],[62,17,62,19],[61,15,61,16],[62,15,62,16],[58,1,61,2],[62,1,62,2],[58,3,61,6],[58,7,60,12],[61,7,61,9],[61,10,61,12],[58,13,60,16],[61,13,61,14],[62,3,62,6],[62,7,62,9],[62,10,62,12],[62,13,62,14],[6,7,6,8],[68,12,68,14],[70,12,70,14],[68,0,68,2],[70,3,70,11],[68,3,68,11],[66,3,66,11],[43,8,43,9],[41,10,42,11],[43,12,43,13],[43,10,43,11],[46,4,46,9],[47,4,47,9],[54,1,54,3],[53,1,53,3],[52,1,52,3],[53,4,53,6],[50,4,50,6],[52,12,52,15],[43,0,43,2],[43,3,43,5],[32,0,32,1],[37,0,37,20],[38,3,39,5]]}
["TR-448A   (2-15)",null,null,null,"JOB MIX FORMULA REPORT",null,null,null,null,null,null,null,null,"SUPPLIER CODE",null,null,null,"MATERIAL CLASS",null,null,null,null,null,null,"PG 46-40",null,100]
[null,null,null,null,null,null,"PennDOT JMF No.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SP4.75","L","PG 52-28",null,150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Design ESAL'S",null,null,null,null,null,null,null,null,"SR4.75","M","PG 58-28"]
[null,null,null,null,null,null,"Year",null,"No.",null,null,null,null,null,null,"Aggregate SRL",null,null,null,null,null,null,"SP9.5","G","PG 64-22",null,"PTM 702"]
[null,null,null,null,null,null,"Supplier JMF No.",null,null,null,null,null,null,"Mixture Final PG Binder Grade",null,null,null,null,null,null,null,null,"SR9.5","H","PG 64-28",null,"PTM 757"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Asphalt Mix Type",null,null,null,null,null,null,null,null,"SP12.5","E","PG 76-22"]
[null,null,null,null,null,null,null,"No.",null,null,null,null,null,"Original Approval Date",null,null,null,null,null,null,null,null,"SR12.5",null,"PG 58S-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SP19W",null,"PG 64S-22"]
["DATE",null,null,null,null,"SPEC",null,null,null,null,null,null,null,"PO",null,null,null,null,null,null,null,null,"SP19B",null,"PG 64E-22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SP19W / SP19B"]
["SUPPLIER NAME",null,null,null,null,null,null,null,null,null,null,null,"LOCATION",null,null,null,null,null,null,null,null,null,"SR19W"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SR19B",null,"HMA"]
["BITUMINOUS PLANT TYPE",null,null,null,null,null,null,"TONS PER HOUR",null,null,null,null,null,"ECMS NO.",null,null,null,null,null,"Mix Time",null,null,"SR19W / SR19B",null,"WMA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dry","Wet",null,"SP25B",null,"COLD"]
["SR & SEC",null,null,null,"CONTRACTOR",null,null,null,null,null,null,null,"LOCATION",null,null,null,null,null,null,null,null,null,"SP25BC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SP25B / SP25BC"]
["Material Supplier Code",null,null,null,null,"Material Code",null,null,"Material Class",null,null,"% In Mix",null,null,"Bulk Sp. Gr.",null,null,"% Absorption",null,null,null,null,"SR25B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SR25BC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SR25B / SR25BC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SP37.5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SR37.5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SMA95"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SMA125"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ATPBC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WM9.5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WR9.5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WM12.5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WR12.5"]
["JOB MIX FORMULA AND DESIGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WM19W"]
[null,null,"AC %",7.4999999999999997E-2,0.15,0.3,0.6,1.18,2.36,4.75,9.5,12.5,19,25,37.5,50,"F/A ratio","Pbe %",null,null,null,null,"WM19B"]
[null,null,null,"mm","mm","mm","mm","mm","mm","mm","mm","mm","mm","mm","mm","mm",null,null,null,null,null,null,"WM19W / WM19B"]
[null,null,null,"#200","#100","#50","#30","#16","#8","#4",0.375,0.5,0.75,1,1.5,2,null,null,null,null,null,null,"WR19W"]
["Design",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WR19B"]
["% Virgin AC",null,null,null,null,null,"Virgin AC PG Binder Grade",null,null,null,null,null,null,null,"Asphalt Film Thickness (micron)",null,null,{"$f":"Sheet1!F12","v":{"$error":"#DIV/0!"}},null,null,null,null,"WR19W / WR19B"]
["% Reclaimed AC from RAP",null,null,null,null,null,"Reclaimed Binder Ratio",null,null,null,null,{"$f":"ROUND((F35+F36)/C33,2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,"WM25B"]
["% Reclaimed AC from RAS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WM25BC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WM25B / WM25BC"]
["MIX CHARACTERISTICS (Gyratory)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WR25B"]
["Design       ESALS",null,null,"Mold Diameter (mm)",null,null,"Gyrations @ Nini",null,"Gyrations @ Ndes",null,"Gyrations @ Nmax",null,"%VMA   @ Ndes",null,"Max. Sp. Gr. (Gmm)",null,null,"Ndes Bulk Sp. Gr. (Gmb)",null,null,null,null,"WR25BC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WR25B / WR25BC"]
[{"$f":"IF(ISBLANK(R3),\"\",R3)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WM37.5"]
["Combine Agg. Gsb",null,null,"Mass of Specimen",null,null,"% Voids                @ Nini",null,"%Voids                 @ Ndes",null,"%Voids   @ Nmax",null,"%VFA   @ Ndes",null,"Max. Density (Lbs./Cu. Ft.)",null,null,"Ndes Bulk Density (Lbs./Cu. Ft.)",null,null,null,null,"WR37.5"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(O41),\"\",O41*62.245)","v":""},null,null,{"$f":"IF(ISBLANK(R41),\" \",R41*62.245)","v":" "}]
[]
["ASPHALT CONTENT TEST METHOD"]
[null,"AC Test Method",null,null,"Oven Model / Series",null,null,null,null,null,"Set Temp.",null,"Sample Size",null,null,"Asphalt C/F",null,null,"200 C/F",null,null,null,null,null,"<0.3"]
[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 to <3"]
[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 to <10"]
["TSR DATA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10 to <30"]
[null,"AC Supplier",null,null,"Dry PSI Strength",null,null,"Wet PSI Strength",null,null,"TSR Value",null,"Date TSR's were done",null,null,null,"Date of Boil Test",null,null,null,null,null,null,null,"3 to <30"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H52),\" \",(H52/E52)*100)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,"> 30"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H53),\" \",(H53/E53)*100)","v":" "}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H54),\" \",(H54/E54)*100)","v":" "}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H55),\" \",(H55/E55)*100)","v":" "}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H56),\" \",(H56/E56)*100)","v":" "}]
[]
["Combined Aggregate Consensus Properties"]
[null,"AASHTO T176 Sand Equivalent",null,"AASHTO T304 Uncompacted Void Content (Fine Aggregate Angularity)",null,null,null,"ASTM D5821 Coarse Aggregate Angularity",null,null,null,null,null,"ASTM D4791 Flat & Elongated",null,null,null,"Total % Reclaimed Agg. From RAP and / or RAS"]
[]
[]
[null,null,null,null,null,null,null,"1-Face Crush",null,null,"2-Face Crush",null,null,"5:1",null,"3:1 SMA only"]
[]
[]
["GRADATION CHART IS PART OF THIS JOB MIX FORMULA"]
[]
["Designed by:",null,null,null,null,null,null,null,null,null,null,null,"Cert. ID. No.",null,null,null,null,"Date"]
[]
["Submitted by:",null,null,null,null,null,null,null,null,null,null,null,"Cert. ID. No.",null,null,null,null,"Date"]
[]
["Reviewed by:",null,null,null,null,null,null,null,null,null,null,null,"Cert. ID. No.",null,null,null,null,"Date"]

{"sheet":".45 Power Chart","index":1,"n_rows":106,"n_cols":12,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"H33","v":""},{"$f":"I33","v":""}]
[null,null,null,null,null,null,null,{"$f":"H34","v":""},{"$f":"I34","v":""}]
[null,null,null,null,null,null,null,{"$f":"H35","v":""}]
[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,null,""]
[null,null,null,null,null,null,null,"",{"$f":"I41","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"I42","v":""},false,1,0]
[null,null,null,null,null,null,null,"",{"$f":"I43","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"I44","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"I45","v":""}]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[null,{"$f":"IF(ISBLANK(L34),\"\",L34)","v":""}]
[null,{"$f":"IF(ISBLANK(M34),\"\",M34)","v":""}]
[null,{"$f":"IF(ISBLANK(N34),\"\",N34)","v":""}]
[null,{"$f":"IF(ISBLANK(O34),\"\",O34)","v":""}]
[null,{"$f":"IF(ISBLANK(P34),\"\",P34)","v":""}]
[null,{"$f":"IF(ISBLANK(Q34),\"\",Q34)","v":""}]
[]
[null,null,null,null,null,null,null,{"$f":"IF(SeeSpecs,\"Min/Max\",\"\")","v":""},{"$f":"IF(SeeSpecs,\"Restricted\",\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(SeeSpecs,\"Limits\",\"\")","v":""},{"$f":"IF(SeeSpecs,\"Zone\",\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(SeeSpecs,CHOOSE(SieveIndex,Limits!C5&\" - \"&Limits!D5,Limits!C24&\" - \"&Limits!D24,Limits!C43&\" - \"&Limits!D43,Limits!C62&\" - \"&Limits!D62,Limits!C81&\" - \"&Limits!D81),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(SeeSpecs,CHOOSE(SieveIndex,Limits!C6&\" - \"&Limits!D6,Limits!C25&\" - \"&Limits!D25,Limits!C44&\" - \"&Limits!D44,Limits!C63&\" - \"&Limits!D63,Limits!C82&\" - \"&Limits!D82),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(SeeSpecs,CHOOSE(SieveIndex,Limits!C7&\" - \"&Limits!D7,Limits!C26&\" - \"&Limits!D26,Limits!C45&\" - \"&Limits!D45,Limits!C64&\" - \"&Limits!D64,Limits!C83&\" - \"&Limits!D83),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(SeeSpecs,CHOOSE(SieveIndex,Limits!C8&\" - \"&Limits!D8,Limits!C27&\" - \"&Limits!D27,Limits!C46&\" - \"&Limits!D46,Limits!C65&\" - \"&Limits!D65,Limits!C84&\" - \"&Limits!D84),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(SeeSpecs,CHOOSE(SieveIndex,Limits!C9&\" - \"&Limits!D9,Limits!C28&\" - \"&Limits!D28,Limits!C47&\" - \"&Limits!D47,Limits!C66&\" - \"&Limits!D66,Limits!C85&\" - \"&Limits!D85),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(SeeSpecs,CHOOSE(SieveIndex,Limits!C10&\" - \"&Limits!D10,Limits!C29&\" - \"&Limits!D29,Limits!C48&\" - \"&Limits!D48,Limits!C67&\" - \"&Limits!D67,Limits!C86&\" - \"&Limits!D86),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(SeeSpecs,CHOOSE(SieveIndex,Limits!C11&\" - \"&Limits!D11,Limits!C30&\" - \"&Limits!D30,Limits!C49&\" - \"&Limits!D49,Limits!C68&\" - \"&Limits!D68,Limits!C87&\" - \"&Limits!D87),\"\")","v":""},{"$f":"IF(SeeSpecs,CHOOSE(SieveIndex,Limits!E11&\" - \"&Limits!F11,Limits!E30&\" - \"&Limits!F30,Limits!E49&\" - \"&Limits!F49,Limits!E68&\" - \"&Limits!F68,Limits!E87&\" - \"&Limits!F87),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(SeeSpecs,CHOOSE(SieveIndex,Limits!C12&\" - \"&Limits!D12,Limits!C31&\" - \"&Limits!D31,Limits!C50&\" - \"&Limits!D50,Limits!C69&\" - \"&Limits!D69,Limits!C88&\" - \"&Limits!D88),\"\")","v":""},{"$f":"IF(SeeSpecs,CHOOSE(SieveIndex,Limits!E12&\" - \"&Limits!F12,Limits!E31&\" - \"&Limits!F31,Limits!E50&\" - \"&Limits!F50,Limits!E69&\" - \"&Limits!F69,Limits!E88&\" - \"&Limits!F88),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(SeeSpecs,CHOOSE(SieveIndex,Limits!C13&\" - \"&Limits!D13,Limits!C32&\" - \"&Limits!D32,Limits!C51&\" - \"&Limits!D51,Limits!C70&\" - \"&Limits!D70,Limits!C89&\" - \"&Limits!D89),\"\")","v":""},{"$f":"IF(SeeSpecs,CHOOSE(SieveIndex,Limits!E13&\" - \"&Limits!F13,Limits!E32&\" - \"&Limits!F32,Limits!E51&\" - \"&Limits!F51,Limits!E70&\" - \"&Limits!F70,Limits!E89&\" - \"&Limits!F89),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(SeeSpecs,CHOOSE(SieveIndex,Limits!C14&\" - \"&Limits!D14,Limits!C33&\" - \"&Limits!D33,Limits!C52&\" - \"&Limits!D52,Limits!C71&\" - \"&Limits!D71,Limits!C90&\" - \"&Limits!D90),\"\")","v":""},{"$f":"IF(SeeSpecs,CHOOSE(SieveIndex,Limits!E14&\" - \"&Limits!F14,Limits!E33&\" - \"&Limits!F33,Limits!E52&\" - \"&Limits!F52,Limits!E71&\" - \"&Limits!F71,Limits!E90&\" - \"&Limits!F90),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(SeeSpecs,CHOOSE(SieveIndex,Limits!C15&\" - \"&Limits!D15,Limits!C34&\" - \"&Limits!D34,Limits!C53&\" - \"&Limits!D53,Limits!C72&\" - \"&Limits!D72,Limits!C91&\" - \"&Limits!D91),\"\")","v":""},{"$f":"IF(SeeSpecs,CHOOSE(SieveIndex,Limits!E15&\" - \"&Limits!F15,Limits!E34&\" - \"&Limits!F34,Limits!E53&\" - \"&Limits!F53,Limits!E72&\" - \"&Limits!F72,Limits!E91&\" - \"&Limits!F91),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(SeeSpecs,CHOOSE(SieveIndex,Limits!C16&\" - \"&Limits!D16,Limits!C35&\" - \"&Limits!D35,Limits!C54&\" - \"&Limits!D54,Limits!C73&\" - \"&Limits!D73,Limits!C92&\" - \"&Limits!D92),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(SeeSpecs,CHOOSE(SieveIndex,Limits!C17&\" - \"&Limits!D17,Limits!C36&\" - \"&Limits!D36,Limits!C55&\" - \"&Limits!D55,Limits!C74&\" - \"&Limits!D74,Limits!C93&\" - \"&Limits!D93),\"\")","v":""}]
[]
[null,"Sieve"]
[null,"Size","Blend 1"]
[null,50,{"$f":"IF(ISBLANK('TR 448A'!P33),NA(),'TR 448A'!P33)","v":{"$error":"#N/A"}},null,null,50]
[null,37.5,{"$f":"IF(ISBLANK('TR 448A'!O33),NA(),'TR 448A'!O33)","v":{"$error":"#N/A"}},null,null,37.5]
[null,25,{"$f":"IF(ISBLANK('TR 448A'!N33),NA(),'TR 448A'!N33)","v":{"$error":"#N/A"}},null,null,25]
[null,19,{"$f":"IF(ISBLANK('TR 448A'!M33),NA(),'TR 448A'!M33)","v":{"$error":"#N/A"}},null,null,19]
[null,12.5,{"$f":"'TR 448A'!L33","v":0},null,null,12.5]
[null,9.5,{"$f":"'TR 448A'!K33","v":0},null,null,9.5]
[null,4.75,{"$f":"'TR 448A'!J33","v":0},null,null,4.75]
[null,2.36,{"$f":"'TR 448A'!I33","v":0},null,null,2.36]
[null,1.18,{"$f":"'TR 448A'!H33","v":0},null,null,1.18]
[null,0.6,{"$f":"'TR 448A'!G33","v":0},null,null,0.6]
[null,0.3,{"$f":"'TR 448A'!F33","v":0},null,null,0.3]
[null,0.15,{"$f":"'TR 448A'!E33","v":0},null,null,0.15]
[null,7.4999999999999997E-2,{"$f":"'TR 448A'!D33","v":0},null,null,7.4999999999999997E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sand Eq.",{"$f":"IF(ISBLANK($J68),0,C$24)+IF(ISBLANK($K68),0,C$25)+IF(ISBLANK($L68),0,C$26)+IF(ISBLANK($M68),0,C$27)+IF(ISBLANK($N68),0,C$28)+IF(ISBLANK($O68),0,C$29)+IF(ISBLANK($P68),0,C$30)+IF(ISBLANK($Q68),0,C$31)","v":0},{"$f":"IF(ISBLANK($J68),0,D$24)+IF(ISBLANK($K68),0,D$25)+IF(ISBLANK($L68),0,D$26)+IF(ISBLANK($M68),0,D$27)+IF(ISBLANK($N68),0,D$28)+IF(ISBLANK($O68),0,D$29)+IF(ISBLANK($P68),0,D$30)+IF(ISBLANK($Q68),0,D$31)","v":0},{"$f":"IF(ISBLANK($J68),0,E$24)+IF(ISBLANK($K68),0,E$25)+IF(ISBLANK($L68),0,E$26)+IF(ISBLANK($M68),0,E$27)+IF(ISBLANK($N68),0,E$28)+IF(ISBLANK($O68),0,E$29)+IF(ISBLANK($P68),0,E$30)+IF(ISBLANK($Q68),0,E$31)","v":0},{"$f":"IF(ISBLANK($J68),0,F$24)+IF(ISBLANK($K68),0,F$25)+IF(ISBLANK($L68),0,F$26)+IF(ISBLANK($M68),0,F$27)+IF(ISBLANK($N68),0,F$28)+IF(ISBLANK($O68),0,F$29)+IF(ISBLANK($P68),0,F$30)+IF(ISBLANK($Q68),0,F$31)","v":0},{"$f":"IF(ISBLANK($J68),0,G$24)+IF(ISBLANK($K68),0,G$25)+IF(ISBLANK($L68),0,G$26)+IF(ISBLANK($M68),0,G$27)+IF(ISBLANK($N68),0,G$28)+IF(ISBLANK($O68),0,G$29)+IF(ISBLANK($P68),0,G$30)+IF(ISBLANK($Q68),0,G$31)","v":0}]
[null,"F & E",{"$f":"IF(ISBLANK($J69),0,C$24)+IF(ISBLANK($K69),0,C$25)+IF(ISBLANK($L69),0,C$26)+IF(ISBLANK($M69),0,C$27)+IF(ISBLANK($N69),0,C$28)+IF(ISBLANK($O69),0,C$29)+IF(ISBLANK($P69),0,C$30)+IF(ISBLANK($Q69),0,C$31)","v":0},0,0,0,0]
[null,"%Fine",0,0,0,0,0]
[null,"%Coarse (1)",0,0,0,0,0]
[null,"%Coarse (2)",0,0,0,0,0]
[null,"Insol. Res.",0,0,0,0,0]
[]
[null,null,null,null,null,null,{"$f":"Title","v":0}]

{"sheet":"Limits","index":2,"n_rows":93,"n_cols":13,"rows_kept":93,"cut":false,"hidden":true,"merged":[]}
["37.5 mm Nominal Size",null,null,null,null,null,null,null,null,null,null,"Index","Sieve"]
[null,null,null,null,"Restricted Zone",null,null,null,null,null,null,1,37.5]
[null,null,"Control Points",null,"Minimum","Maximum","Maximum","Optional","Optional",null,null,2,25]
["Size",".45 Power","Minimum","Maximum","Boundary","Boundary","Density Line","Limit #1","Limit #2",null,null,3,19]
[50,5.8150000000000004,null,100,null,null,100,0,0,null,null,4,12.5]
[37.5,5.109,90,100,null,null,null,null,null,null,null,5,9.5]
[25,{"$f":"POWER(A7,0.45)","v":4.2566996126039234}]
[19,{"$f":"POWER(A8,0.45)","v":3.7621761023862978},null,null,null,null,null,null,null,null,null,2]
[12.5,3.116086507375345]
[9.5,2.754074108566122]
[4.75,2.0161002539629291,null,null,34.700000000000003,34.700000000000003]
[2.36,1.4716698795820382,15,41,23.3,27.3]
[1.18,1.0773254099250416,null,null,15.5,21.5]
[0.6,0.79463568224020453,null,null,11.7,15.7]
[0.3,0.58170736792793831,null,null,10,10]
[0.15,0.42583471830473674]
[7.4999999999999997E-2,0.31172925995349998,0,6,null,null,5.4,0,0]
[]
[]
["25.0 mm Nominal Size"]
[null,null,null,null,"Restricted Zone"]
[null,null,"Control Points",null,"Minimum","Maximum","Maximum","Optional","Optional"]
["Size",".45 Power","Minimum","Maximum","Boundary","Boundary","Density Line","Limit #1","Limit #2"]
[50,5.8150000000000004]
[37.5,5.109,null,100,null,null,100,0,0]
[25,{"$f":"POWER(A26,0.45)","v":4.2566996126039234},90,100]
[19,{"$f":"POWER(A27,0.45)","v":3.7621761023862978}]
[12.5,3.116086507375345]
[9.5,2.754074108566122]
[4.75,2.0161002539629291,null,null,39.5,39.5]
[2.36,1.4716698795820382,19,45,26.8,30.8]
[1.18,1.0773254099250416,null,null,18.100000000000001,24.1]
[0.6,0.79463568224020453,null,null,13.6,17.600000000000001]
[0.3,0.58170736792793831,null,null,11.4,11.4]
[0.15,0.42583471830473674]
[7.4999999999999997E-2,0.31172925995349998,1,7,null,null,6.1,0,0]
[]
[]
["19.0 mm Nominal Size"]
[null,null,null,null,"Restricted Zone"]
[null,null,"Control Points",null,"Minimum","Maximum","Maximum","Optional","Optional"]
["Size",".45 Power","Minimum","Maximum","Boundary","Boundary","Density Line","Limit #1","Limit #2"]
[50,5.8150000000000004]
[37.5,5.109]
[25,{"$f":"POWER(A45,0.45)","v":4.2566996126039234},null,100,null,null,100,0,0]
[19,{"$f":"POWER(A46,0.45)","v":3.7621761023862978},90,100]
[12.5,3.116086507375345]
[9.5,2.754074108566122]
[4.75,2.0161002539629291]
[2.36,1.4716698795820382,23,49,34.6,34.6]
[1.18,1.0773254099250416,null,null,22.3,28.3]
[0.6,0.79463568224020453,null,null,16.7,20.7]
[0.3,0.58170736792793831,null,null,13.7,13.7]
[0.15,0.42583471830473674]
[7.4999999999999997E-2,0.31172925995349998,2,8,null,null,7.3,0,0]
[]
[]
["12.5 mm Nominal Size"]
[null,null,null,null,"Restricted Zone"]
[null,null,"Control Points",null,"Minimum","Maximum","Maximum","Optional","Optional"]
["Size",".45 Power","Minimum","Maximum","Boundary","Boundary","Density Line","Limit #1","Limit #2"]
[50,5.8150000000000004]
[37.5,5.109]
[25,{"$f":"POWER(A64,0.45)","v":4.2566996126039234}]
[19,{"$f":"POWER(A65,0.45)","v":3.7621761023862978},null,100,null,null,100,0,0]
[12.5,3.116086507375345,90,100]
[9.5,2.754074108566122]
[4.75,2.0161002539629291]
[2.36,1.4716698795820382,28,58,39.1,39.1]
[1.18,1.0773254099250416,null,null,25.6,31.6]
[0.6,0.79463568224020453,null,null,19.100000000000001,23.1]
[0.3,0.58170736792793831,null,null,15.5,15.5]
[0.15,0.42583471830473674]
[7.4999999999999997E-2,0.31172925995349998,2,10,null,null,8.3000000000000007,0,0]
[]
[]
["9.5 mm Nominal Size"]
[null,null,null,null,"Restricted Zone"]
[null,null,"Control Points",null,"Minimum","Maximum","Maximum","Optional","Optional"]
["Size",".45 Power","Minimum","Maximum","Boundary","Boundary","Density Line","Limit #1","Limit #2"]
[50,5.8150000000000004]
[37.5,5.109]
[25,{"$f":"POWER(A83,0.45)","v":4.2566996126039234}]
[19,{"$f":"POWER(A84,0.45)","v":3.7621761023862978}]
[12.5,3.116086507375345,null,100,null,null,100,0,0]
[9.5,2.754074108566122,90,100]
[4.75,2.0161002539629291]
[2.36,1.4716698795820382,32,67,47.2,47.2]
[1.18,1.0773254099250416,null,null,31.6,37.6]
[0.6,0.79463568224020453,null,null,23.5,27.5]
[0.3,0.58170736792793831,null,null,18.7,18.7]
[0.15,0.42583471830473674]
[7.4999999999999997E-2,0.31172925995349998,2,10,null,null,10,0,0]

{"sheet":"Sheet1","index":5,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":true,"merged":[[7,3,7,4],[9,3,9,4],[11,3,11,4],[1,3,1,6],[1,0,2,0],[3,0,4,0],[1,1,2,1],[3,1,4,1],[3,3,3,4],[5,3,5,4]]}
[]
["Sieve Size","JMF %Passing",null,"Asphalt Film Thickness"]
[]
["Max Size Agg",100,null,"Surface Area of Agg.",null,{"$f":"(2*B4+2*B6+4*B7+8*B8+14*B9+30*B10+60*B11+160*B12)/100","v":2},"Sq.ft/lb"]
[]
[4,{"$f":"'TR 448A'!J33","v":0},null,"Total Volume of AC",null,{"$f":"((B16*1000)*(B14/100)/B15)","v":0},"ml"]
[8,{"$f":"'TR 448A'!I33","v":0}]
[16,{"$f":"'TR 448A'!H33","v":0},null,"Volume of abs. AC",null,{"$f":"B24/B15","v":{"$error":"#DIV/0!"}},"ml"]
[30,{"$f":"'TR 448A'!G33","v":0}]
[50,{"$f":"'TR 448A'!F33","v":0},null," Vol. of Effective AC",null,{"$f":"F6-F8","v":{"$error":"#DIV/0!"}},"ml"]
[100,{"$f":"'TR 448A'!E33","v":0}]
[200,{"$f":"'TR 448A'!D33","v":0},null,"Film Thickness",null,{"$f":"F10/(C23*(B16*1000)*(100-B14)/100)*(1000)","v":{"$error":"#DIV/0!"}},"microns"]
[]
["AC",{"$f":"'TR 448A'!C33","v":0}]
["Gb",1.0249999999999999]
["Gmb",{"$f":"'TR 448A'!R41","v":0}]
["Gsb",{"$f":"'TR 448A'!A44","v":0}]
["Gse",{"$f":"F24","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[{"$f":"(B18-B17)","v":{"$error":"#DIV/0!"}},{"$f":"(A23/A24)*B15","v":{"$error":"#DIV/0!"}},{"$f":"F4/4.8686","v":0.41079571129277415},null,"Max",{"$f":"'TR 448A'!O41","v":0}]
[{"$f":"B17*B18","v":{"$error":"#DIV/0!"}},{"$f":"B23*(B16*1000)*(100-B14)/100","v":{"$error":"#DIV/0!"}},null,null,"Gse",{"$f":"ROUND((100-B14)/((100/F23)-(B14/1.025)),3)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"AC",{"$f":"B14","v":0}]