{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["READ ME - Instructions","Mix Design Data Entry","One-Point Verification","3.0% Va Regression","Convert to .txt File","Text Template","Agg_Properties","INTERNAL_SYS_VAR"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":0,"defined_names":8,"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 ME - Instructions","index":0,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,1,2,2],[0,3,0,29],[1,3,1,29],[2,3,2,29]]}
[null,{"$error":"#VALUE!"},null,"HMA & SMA Mix Design Report"]
[null,null,null,"Wisconsin Department of Transportation"]
[null,null,null,{"$f":"\"DT2490        \" & TEXT(INTERNAL_SYS_VAR!$B$4,\"M/YYYY\")","v":"DT2490        3/2026"}]

{"sheet":"Mix Design Data Entry","index":1,"n_rows":82,"n_cols":16,"rows_kept":82,"cut":false,"hidden":false,"merged":[[71,5,71,6],[73,2,75,15],[48,1,48,2],[49,1,49,2],[50,1,50,2],[48,3,48,4],[49,3,49,4],[50,3,50,4],[53,3,53,4],[54,3,54,4],[55,3,55,4],[53,5,53,6],[54,5,54,6],[55,5,55,6],[53,1,53,2],[54,1,54,2],[55,1,55,2],[62,1,62,6],[67,1,67,6],[70,1,70,6],[63,5,63,6],[64,5,64,6],[65,5,65,6],[66,5,66,6],[68,5,68,6],[69,5,69,6],[13,3,13,4],[45,1,45,15],[47,1,47,6],[48,5,48,6],[49,5,49,6],[50,5,50,6],[52,1,52,6],[57,1,57,6],[61,1,61,6],[58,4,58,6],[59,4,59,6],[54,8,54,12],[54,13,54,15],[15,1,15,15],[58,8,58,9],[59,8,59,9],[60,8,60,9],[61,8,61,9],[57,8,57,9],[20,1,20,2],[58,1,58,3],[23,1,23,2],[71,1,71,4],[0,3,0,15],[43,1,43,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[48,10,48,12],[47,8,47,12],[48,8,49,9],[50,8,50,9],[51,8,51,9],[62,8,62,9],[56,8,56,15],[68,1,68,4],[69,1,69,4],[64,8,64,15],[63,1,63,4],[64,1,64,4],[65,1,65,4],[66,1,66,4],[47,14,47,15],[53,8,53,15],[17,14,17,15],[8,8,8,9],[9,8,9,9],[6,5,9,5],[11,14,11,15],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[77,1,77,15],[78,1,78,15],[79,1,79,15],[80,1,80,15],[81,1,81,15],[0,1,2,2],[1,3,1,15],[2,3,2,15],[4,8,4,9],[5,8,5,9],[3,14,3,15],[4,14,4,15],[5,14,5,15],[10,14,10,15],[6,8,6,9],[10,5,13,5],[7,14,7,15],[4,3,4,4],[5,3,5,4],[12,3,12,4],[7,8,7,9],[22,1,22,2],[59,1,59,3],[25,14,36,14]]}
[null,{"$error":"#VALUE!"},null,"HMA & SMA Mix Design Report"]
[null,null,null,"Wisconsin Department of Transportation"]
[null,null,null,{"$f":"\"DT2490        \" & TEXT(INTERNAL_SYS_VAR!$B$4,\"M/YYYY\")","v":"DT2490        3/2026"}]
[]
[null,null,"WisDOT Project ID:",null,null,null,null,"Design Lab or Company:",null,null,"       ",null,null,"WisDOT Mix Design ID:"]
[null,null,"Mix Design ID:",null,null,null,null,"Mix Designer:",null,null,null,null,null,"WisDOT Design Verification Date:"]
[null,null,"Mix Type:",null,null,"Resultant Mixture1",null,"Designer HTCP Cert ID #:"]
[null,null,"Mix NMAS:",null,null,null,null,"HMA Producer:"]
[null,null,"Mix PG:",null,null,null,null,"Plant # / Location:"]
[null,null,"Mix Binder Designation:",null,null,null,null,"Design Date:"]
[null,null,"Virgin Binder PG:",null,null,"Primary AC Source / Type",null,null,null,null,null,null,null,"Design Amended Date:"]
[null,null,"Virgin Binder Designation:",null,null,null,null,null,null,null,"      ",null,null,"Last JMF Change Date:"]
[null,null,"Virgin Binder Gb:"]
[null,null,"Virgin Binder Source:"]
[]
[null,"AGGREGATE COMPONENT GRADATION DATA"]
[]
[null,null,null,"Agg 1","Agg 2","Agg 3","Agg 4","Agg 5","Agg 6","Agg 7","Agg 8","RAM 1\n(RAP)","RAM 2\n(RAS)","RAM 3\n(FRAP)","JMF BLEND"]
[null,null,"Blend Percentages (0.1%):",null,null,null,null,null,null,null,null,null,null,null,"Total Percentage:",{"$f":"IF(AND(D19=\"\",E19=\"\",F19=\"\",G19=\"\",H19=\"\",I19=\"\",J19=\"\",K19=\"\",L19=\"\",M19=\"\",N19=\"\"),\"\",SUM(D19:N19))","v":""}]
[null,null,"Material Description:"]
[null,"Source Name from 225 Report or RAM Plant ID:",null,null,null,null,null,null,null,null,null,null,null,null,"Gse:",{"$f":"IFERROR(ROUND((100-$J$71)/((100/$L$71)-($J$71/$D$13)),3),\"\")","v":""}]
[null,null,"P / Q / MF / Dust / RAM:",null,null,null,null,null,null,null,null,null,null,null,"Sand Equivalency:"]
[null,"WisDOT Agg Source ID:\n(225-xxxx-xxxx)",null,null,null,null,null,null,null,null,null,null,null,null,"Clay Lumps (T112):"]
[null,null,null,null,null,null,null,null,null,null,"RAM Extracted % Binder :",null,null,null,"PI (T89/T90):"]
[null,"Sieve","mm"]
[null,"1 1/2\"",37.5,null,null,null,null,null,null,null,null,null,null,null,"Blend Combined Gradation",{"$f":"IF($P$19=\"\",\"\",(D26*$D$19/100)+(E26*$E$19/100)+(F26*$F$19/100)+(G26*$G$19/100)+(H26*$H$19/100)+(I26*$I$19/100)+(J26*$J$19/100)+(K26*$K$19/100)+(L26*$L$19/100)+(M26*$M$19/100)+(N26*$N$19/100))","v":""}]
[null,"1\"",25,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"3/4\"",19,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"1/2\"",12.5,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"3/8\"",9.5,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"#4",4.75,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"#8",2.36,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"#16",1.18,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"#30",0.6,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"#50",0.3,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"#100",0.15,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"#200",7.4999999999999997E-2,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,"Gsb:",null,null,null,null,null,null,null,null,null,null,null,null,"Blend Gsb:",{"$f":"IF($P$19=\"\",\"\",IFERROR(Agg_Properties!D29,0))","v":""}]
[null,"CAA 1F (%):",null,null,null,null,null,null,null,null,null,null,null,null,"Blend CAA 1F:",{"$f":"IF($P$19=\"\",\"\",IFERROR(Agg_Properties!O18,0))","v":""}]
[null,"CAA 2F (%):",null,null,null,null,null,null,null,null,null,null,null,null,"Blend CAA 2F:",{"$f":"IF($P$19=\"\",\"\",IFERROR(Agg_Properties!O22,0))","v":""}]
[null,"FAA:",null,null,null,null,null,null,null,null,null,null,null,null,"Blend FAA:"]
[null,"Moisture Abs. (%):",null,null,null,null,null,null,null,null,null,null,null,null,"Blend Moisture Abs:",{"$f":"IF($P$19=\"\",\"\",Agg_Properties!O27)","v":""}]
[null,"Thin/Elong. (%):",null,null,null,null,null,null,null,null,null,null,null,null,"Blend Thin/Elong.:",{"$f":"IF($P$19=\"\",\"\",IFERROR(Agg_Properties!O26,0))","v":""}]
[]
[null,{"$f":"_xlfn.SWITCH($D$7,0,INTERNAL_SYS_VAR!$T$3,INTERNAL_SYS_VAR!$D$3,INTERNAL_SYS_VAR!$T$4,INTERNAL_SYS_VAR!$D$4,INTERNAL_SYS_VAR!$T$4,INTERNAL_SYS_VAR!$D$5,INTERNAL_SYS_VAR!$T$4,INTERNAL_SYS_VAR!$D$6,INTERNAL_SYS_VAR!$T$5,INTERNAL_SYS_VAR!$D$7,INTERNAL_SYS_VAR!$T$7,INTERNAL_SYS_VAR!$D$8,INTERNAL_SYS_VAR!$T$6)","v":"JMF PROPERTIES AT OPTIMUM % ASPHALT CONTENT AT 4.0% AIR VOIDS FOR HMA / 4.5% AIR VOIDS FOR SMA / 2.0% AIR VOIDS FOR INTERLAYER / 1.0% AIR VOIDS FOR POLYMER-MODIFIED HMA OVERLAY"}]
[]
[null,"Laboratory Mixing and Compaction Temperatures",null,null,null,null,null,null,"SMA Draindown",null,null,null,null,null,"AC Volumetrics"]
[null,"Mixture Type",null,"Recommended Mixing Temp. (°F)",null,"Compaction Temperature (°F)",null,null,"Temperature2 (°C)",null,"Draindown (%)",null,null,null,"Pbr:",{"$f":"IFERROR((($L$19*$L$24)+($M$19*$M$24)+($N$19*$N$24))/$J$71,\"\")","v":""}]
[null,"HMA / SMA",null,null,null,null,null,null,null,null,"Test 1","Test 2","Average",null,"Pbe:",{"$f":"IFERROR($J$71-(($P$51*(100-$J$71))/100),\"\")","v":""}]
[null,"WMA",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(K51=\"\",L51=\"\"),\"\",AVERAGE(K51:L51))","v":""},null,"Pba:",{"$f":"IFERROR(100*($P$21-$P$39)/($P$21*$P$39)*($D$13),\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(I51=\"\",\"\",I51+15)","v":""},null,null,null,{"$f":"IF(AND(K52=\"\",L52=\"\"),\"\",AVERAGE(K52:L52))","v":""},null,"Dust/Binder (DP):",{"$f":"IFERROR($P$37/$P$50,\"\")","v":""}]
[null,{"$f":"_xlfn.SWITCH($D$7,0,INTERNAL_SYS_VAR!$U$3,INTERNAL_SYS_VAR!$D$3,INTERNAL_SYS_VAR!$U$4,INTERNAL_SYS_VAR!$D$4,INTERNAL_SYS_VAR!$U$4,INTERNAL_SYS_VAR!$D$5,INTERNAL_SYS_VAR!$U$4,INTERNAL_SYS_VAR!$D$6,INTERNAL_SYS_VAR!$U$5,INTERNAL_SYS_VAR!$D$7,INTERNAL_SYS_VAR!$U$7,INTERNAL_SYS_VAR!$D$8,INTERNAL_SYS_VAR!$U$6)","v":"Gyratory Compaction Effort (% Gmm at Optimum AC at Design Va)"}]
[null,"Nx",null,"Number of Gyrations (N)",null,"%Gmm @ Optimum AC",null,null,"Gmm Dryback Correction Factor (if needed)"]
[null,"Nini",null,{"$f":"IFERROR(_xlfn.SWITCH($D$7,INTERNAL_SYS_VAR!$L$3,INTERNAL_SYS_VAR!$L$4,INTERNAL_SYS_VAR!$M$3,INTERNAL_SYS_VAR!$M$4,INTERNAL_SYS_VAR!$N$3,INTERNAL_SYS_VAR!$N$4,INTERNAL_SYS_VAR!$O$3,INTERNAL_SYS_VAR!$O$4,INTERNAL_SYS_VAR!$P$3,INTERNAL_SYS_VAR!$P$4,INTERNAL_SYS_VAR!$Q$3,INTERNAL_SYS_VAR!$Q$4),\"\")","v":""},null,null,null,null,"Gmm Dryback Correction Factor:"]
[null,{"$f":"IF($D$7=INTERNAL_SYS_VAR!$D$8,\"Ndes\",\"Nmax\")","v":"Nmax"},null,{"$f":"IFERROR(_xlfn.SWITCH($D$7,INTERNAL_SYS_VAR!$L$3,INTERNAL_SYS_VAR!$L$6,INTERNAL_SYS_VAR!$M$3,INTERNAL_SYS_VAR!$M$6,INTERNAL_SYS_VAR!$N$3,INTERNAL_SYS_VAR!$N$6,INTERNAL_SYS_VAR!$O$3,INTERNAL_SYS_VAR!$O$6,INTERNAL_SYS_VAR!$P$3,INTERNAL_SYS_VAR!$P$6,INTERNAL_SYS_VAR!$Q$3,INTERNAL_SYS_VAR!$Q$5),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"Alternative AC Sources"]
[null,"Additive3",null,null,null,null,null,null,"Alternative AC Source",null,"Alt. AC PG","Gb","TSR4","# of Gyr. (N)","Additive5","Amt. Additive"]
[null,"Type",null,null,"Amount (%)"]
[]
[]
[null,{"$f":"_xlfn.SWITCH($D$7,0,INTERNAL_SYS_VAR!$V$3,INTERNAL_SYS_VAR!$D$3,INTERNAL_SYS_VAR!$V$4,INTERNAL_SYS_VAR!$D$4,INTERNAL_SYS_VAR!$V$4,INTERNAL_SYS_VAR!$D$5,INTERNAL_SYS_VAR!$V$4,INTERNAL_SYS_VAR!$D$6,INTERNAL_SYS_VAR!$V$5,INTERNAL_SYS_VAR!$D$7,INTERNAL_SYS_VAR!$V$7,INTERNAL_SYS_VAR!$D$8,INTERNAL_SYS_VAR!$V$6)","v":"Performance (at Optimum AC at Production Va)"}]
[null,"TSR (WTM T283)"]
[null,"Average Number of Gyrations to achieve Target Va:"]
[null,"Wet Strength (PSI):",null,null,null,null,null,null,"Trial Binder (AC%) Data"]
[null,"Dry Strength (PSI):",null,null,null,null,null,null,"Trial","Total %AC","% Added AC","Gmm","Gmb","% Air Voids","% VMA","% VFB/VFA"]
[null,"TSR:",null,null,null,{"$f":"IF(OR($F$65=\"\",$F$66=\"\"),\"\",$F$65/$F$66)","v":""},null,null,"Trial 1",null,{"$f":"IFERROR(IF(J67=\"\",\"\",J67*(1-(((($L$19*$L$24)+($M$19*$M$24)+($N$19*$N$24))/J67)/100))),\"\")","v":""},null,null,{"$f":"IF(OR(L67=\"\",M67=\"\"),\"\",ROUND((1-(M67/L67))*100,1))","v":""},{"$f":"IF(OR(J67=\"\",M67=\"\",$P$39=\"\"),\"\",ROUND(100-((M67*(100-J67))/$P$39),1))","v":""},{"$f":"IF(OR(N67=\"\",O67=\"\"),\"\",ROUND(100*((O67-N67)/O67),1))","v":""}]
[null,"Hamburg Wheel Tracking Test (WTM T324)",null,null,null,null,null,null,"Trial 2",null,"",null,null,{"$f":"IF(OR(L68=\"\",M68=\"\"),\"\",ROUND((1-(M68/L68))*100,1))","v":""},{"$f":"IF(OR(J68=\"\",M68=\"\",$P$39=\"\"),\"\",ROUND(100-((M68*(100-J68))/$P$39),1))","v":""},{"$f":"IF(OR(N68=\"\",O68=\"\"),\"\",ROUND(100*((O68-N68)/O68),1))","v":""}]
[null,"Final Rut Depth (mm):",null,null,null,null,null,null,"Trial 3",null,"",null,null,"",{"$f":"IF(OR(J69=\"\",M69=\"\",$P$39=\"\"),\"\",ROUND(100-((M69*(100-J69))/$P$39),1))","v":""},""]
[null,"Number of Passes to Test Completion:",null,null,null,null,null,null,"Trial 4",null,"",null,null,"",{"$f":"IF(OR(J70=\"\",M70=\"\",$P$39=\"\"),\"\",ROUND(100-((M70*(100-J70))/$P$39),1))","v":""},""]
[null,"IDEAL-CT (WTM D8225)",null,null,null,null,null,null,{"$f":"_xlfn.SWITCH($D$7,0,INTERNAL_SYS_VAR!$R$3,INTERNAL_SYS_VAR!$L$3,INTERNAL_SYS_VAR!$R$3,INTERNAL_SYS_VAR!$M$3,INTERNAL_SYS_VAR!$R$3,INTERNAL_SYS_VAR!$N$3,INTERNAL_SYS_VAR!$R$3,INTERNAL_SYS_VAR!$O$3,INTERNAL_SYS_VAR!$R$4,INTERNAL_SYS_VAR!$P$3,INTERNAL_SYS_VAR!$R$6,INTERNAL_SYS_VAR!$Q$3,INTERNAL_SYS_VAR!$R$5)","v":"OPT. @ 4.0% Va"},null,"",null,null,"",{"$f":"IF(OR(J71=\"\",M71=\"\",$P$39=\"\"),\"\",ROUND(100-((M71*(100-J71))/$P$39),1))","v":""},""]
[null,"CT-Index:",null,null,null,null,null,null,"OPT. @ 3.0% Va",{"$f":"IFERROR('3.0% Va Regression'!D33,\"\")","v":""},"",{"$f":"IF(COUNT(L67:L71)<3,\"\",IFERROR('3.0% Va Regression'!D34,\"\"))","v":""},{"$f":"IF(COUNT(M67:M71)<3,\"\",IFERROR('3.0% Va Regression'!D35,\"\"))","v":""},{"$f":"IFERROR(IF(J72=\"\",\"\",IF(J72>1,3,0)),\"\")","v":""},{"$f":"IFERROR('3.0% Va Regression'!D37,\"\")","v":""},{"$f":"IFERROR('3.0% Va Regression'!D38,\"\")","v":""}]
[]
[null,"Comments:"]
[]
[]
[]
[null,"1 For the Mix PG and Mix Binder Designation, report the mixture's resultant PG (typically the bid item / virgin binder grade). The Virgin Binder PG may differ from the Mix PG when a softer binder is used for mixtures that exceed the maximum binder replacement (Pbr) limits in the standard spec. For example, a 58-28 S mix may utilize a 52-34 S virgin binder to achieve the required resultant properties."]
[null,"2 Use the anticipated plant production temperature. The second value is calculated automatically by adding 15° to the plant temperature."]
[null,"3 Additive used in initial design. Additional addtives may be added in the comments section or under Alternative AC Sources."]
[null,"4 TSR values are required when a change in source is from a modified AC to an unmodified AC or per WTP H-001."]
[null,"5 Additives for Alternative AC Sources can be submitted using the Request for JMF Change Form."]

{"sheet":"One-Point Verification","index":2,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":false,"merged":[[24,10,24,13],[31,1,34,13],[6,10,6,13],[7,10,7,13],[8,10,8,13],[9,10,9,13],[12,1,12,13],[22,1,22,13],[6,3,6,6],[7,3,7,6],[8,3,8,6],[9,3,9,6],[10,3,10,6],[11,1,11,13],[10,10,10,13],[20,1,20,2],[23,1,23,13],[5,1,5,13],[0,3,0,13],[4,1,4,13],[19,1,19,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[0,1,2,2],[1,3,1,13],[2,3,2,13]]}
[null,{"$error":"#VALUE!"},null,"HMA & SMA Mix Design Report"]
[null,null,null,"Wisconsin Department of Transportation"]
[null,null,null,{"$f":"\"DT2490        \" & TEXT(INTERNAL_SYS_VAR!$B$4,\"M/YYYY\")","v":"DT2490        3/2026"}]
[]
[null,"Mix Design One-Point Verification"]
[null,"Instructions: Fill out cells that are light blue. Dark blue cells are calculated automatically."]
[null,null,"Mix Design ID:",{"$f":"IF('Mix Design Data Entry'!$D$6=\"\",\"\",'Mix Design Data Entry'!$D$6)","v":""},null,null,null,null,null,"Design Lab/Company:",{"$f":"IF('Mix Design Data Entry'!$I$5=\"\",\"\",'Mix Design Data Entry'!$I$5)","v":""}]
[null,null,"Mix Type:",{"$f":"IF('Mix Design Data Entry'!$D$7=\"\",\"\",'Mix Design Data Entry'!$D$7)","v":""},null,null,null,null,null,"Mix Designer:",{"$f":"IF('Mix Design Data Entry'!$I$6=\"\",\"\",'Mix Design Data Entry'!$I$6)","v":""}]
[null,null,"NMAS:",{"$f":"IF('Mix Design Data Entry'!$D$8=\"\",\"\",'Mix Design Data Entry'!$D$8)","v":""},null,null,null,null,null,"Mix Designer HTCP Cert ID #:",{"$f":"IF('Mix Design Data Entry'!$I$7=\"\",\"\",'Mix Design Data Entry'!$I$7)","v":""}]
[null,null,"WisDOT Mix Design ID:",{"$f":"IF('Mix Design Data Entry'!$O$5=\"\",\"\",'Mix Design Data Entry'!$O$5)","v":""},null,null,null,null,null,"Producer:",{"$f":"IF('Mix Design Data Entry'!$I$8=\"\",\"\",'Mix Design Data Entry'!$I$8)","v":""}]
[null,null,"Report Date:",null,null,null,null,null,null,"Plant ID/Location:",{"$f":"IF('Mix Design Data Entry'!$I$9=\"\",\"\",'Mix Design Data Entry'!$I$9)","v":""}]
[]
[null,"Aggregate Properties"]
[null,null,null,{"$f":"'Mix Design Data Entry'!D18","v":"Agg 1"},{"$f":"'Mix Design Data Entry'!E18","v":"Agg 2"},{"$f":"'Mix Design Data Entry'!F18","v":"Agg 3"},{"$f":"'Mix Design Data Entry'!G18","v":"Agg 4"},{"$f":"'Mix Design Data Entry'!H18","v":"Agg 5"},{"$f":"'Mix Design Data Entry'!I18","v":"Agg 6"},{"$f":"'Mix Design Data Entry'!J18","v":"Agg 7"},{"$f":"'Mix Design Data Entry'!K18","v":"Agg 8"},{"$f":"'Mix Design Data Entry'!L18","v":"RAM 1\n(RAP)"},{"$f":"'Mix Design Data Entry'!M18","v":"RAM 2\n(RAS)"},{"$f":"'Mix Design Data Entry'!N18","v":"RAM 3\n(FRAP)"}]
[null,"Material Description:",null,{"$f":"IF('Mix Design Data Entry'!D20=\"\",\"\",'Mix Design Data Entry'!D20)","v":""},{"$f":"IF('Mix Design Data Entry'!E20=\"\",\"\",'Mix Design Data Entry'!E20)","v":""},{"$f":"IF('Mix Design Data Entry'!F20=\"\",\"\",'Mix Design Data Entry'!F20)","v":""},{"$f":"IF('Mix Design Data Entry'!G20=\"\",\"\",'Mix Design Data Entry'!G20)","v":""},{"$f":"IF('Mix Design Data Entry'!H20=\"\",\"\",'Mix Design Data Entry'!H20)","v":""},{"$f":"IF('Mix Design Data Entry'!I20=\"\",\"\",'Mix Design Data Entry'!I20)","v":""},{"$f":"IF('Mix Design Data Entry'!J20=\"\",\"\",'Mix Design Data Entry'!J20)","v":""},{"$f":"IF('Mix Design Data Entry'!K20=\"\",\"\",'Mix Design Data Entry'!K20)","v":""},{"$f":"IF('Mix Design Data Entry'!L20=\"\",\"\",'Mix Design Data Entry'!L20)","v":""},{"$f":"IF('Mix Design Data Entry'!M20=\"\",\"\",'Mix Design Data Entry'!M20)","v":""},{"$f":"IF('Mix Design Data Entry'!N20=\"\",\"\",'Mix Design Data Entry'!N20)","v":""}]
[null,"Source ID/Name:",null,{"$f":"IF('Mix Design Data Entry'!D21=\"\",\"\",'Mix Design Data Entry'!D21)","v":""},{"$f":"IF('Mix Design Data Entry'!E21=\"\",\"\",'Mix Design Data Entry'!E21)","v":""},{"$f":"IF('Mix Design Data Entry'!F21=\"\",\"\",'Mix Design Data Entry'!F21)","v":""},{"$f":"IF('Mix Design Data Entry'!G21=\"\",\"\",'Mix Design Data Entry'!G21)","v":""},{"$f":"IF('Mix Design Data Entry'!H21=\"\",\"\",'Mix Design Data Entry'!H21)","v":""},{"$f":"IF('Mix Design Data Entry'!I21=\"\",\"\",'Mix Design Data Entry'!I21)","v":""},{"$f":"IF('Mix Design Data Entry'!J21=\"\",\"\",'Mix Design Data Entry'!J21)","v":""},{"$f":"IF('Mix Design Data Entry'!K21=\"\",\"\",'Mix Design Data Entry'!K21)","v":""},{"$f":"IF('Mix Design Data Entry'!L21=\"\",\"\",'Mix Design Data Entry'!L21)","v":""},{"$f":"IF('Mix Design Data Entry'!M21=\"\",\"\",'Mix Design Data Entry'!M21)","v":""},{"$f":"IF('Mix Design Data Entry'!N21=\"\",\"\",'Mix Design Data Entry'!N21)","v":""}]
[null,"WisDOT Agg. Test ID:",null,{"$f":"IF('Mix Design Data Entry'!D23=\"\",\"\",'Mix Design Data Entry'!D23)","v":""},{"$f":"IF('Mix Design Data Entry'!E23=\"\",\"\",'Mix Design Data Entry'!E23)","v":""},{"$f":"IF('Mix Design Data Entry'!F23=\"\",\"\",'Mix Design Data Entry'!F23)","v":""},{"$f":"IF('Mix Design Data Entry'!G23=\"\",\"\",'Mix Design Data Entry'!G23)","v":""},{"$f":"IF('Mix Design Data Entry'!H23=\"\",\"\",'Mix Design Data Entry'!H23)","v":""},{"$f":"IF('Mix Design Data Entry'!I23=\"\",\"\",'Mix Design Data Entry'!I23)","v":""},{"$f":"IF('Mix Design Data Entry'!J23=\"\",\"\",'Mix Design Data Entry'!J23)","v":""},{"$f":"IF('Mix Design Data Entry'!K23=\"\",\"\",'Mix Design Data Entry'!K23)","v":""}]
[null,"Original Component Gsb:",null,{"$f":"IF('Mix Design Data Entry'!D39=\"\",\"\",'Mix Design Data Entry'!D39)","v":""},{"$f":"IF('Mix Design Data Entry'!E39=\"\",\"\",'Mix Design Data Entry'!E39)","v":""},{"$f":"IF('Mix Design Data Entry'!F39=\"\",\"\",'Mix Design Data Entry'!F39)","v":""},{"$f":"IF('Mix Design Data Entry'!G39=\"\",\"\",'Mix Design Data Entry'!G39)","v":""},{"$f":"IF('Mix Design Data Entry'!H39=\"\",\"\",'Mix Design Data Entry'!H39)","v":""},{"$f":"IF('Mix Design Data Entry'!I39=\"\",\"\",'Mix Design Data Entry'!I39)","v":""},{"$f":"IF('Mix Design Data Entry'!J39=\"\",\"\",'Mix Design Data Entry'!J39)","v":""},{"$f":"IF('Mix Design Data Entry'!K39=\"\",\"\",'Mix Design Data Entry'!K39)","v":""},{"$f":"IF('Mix Design Data Entry'!L39=\"\",\"\",'Mix Design Data Entry'!L39)","v":""},{"$f":"IF('Mix Design Data Entry'!M39=\"\",\"\",'Mix Design Data Entry'!M39)","v":""},{"$f":"IF('Mix Design Data Entry'!N39=\"\",\"\",'Mix Design Data Entry'!N39)","v":""}]
[null,"Current Gsb:"]
[null,"Difference in Gsb:",null,{"$f":"IF(D19=\"\",\"\",D18-D19)","v":""},{"$f":"IF(E19=\"\",\"\",E18-E19)","v":""},"","","","","","","","",""]
[null,"Current FAA:"]
[]
[null,"Volumetric Properties"]
[null,"Instructions: Fill out cells that are light blue. Dark blue cells are calculated automatically. Select the type of material used for the one-point verification. Selecting \"Plant-Produced\" will result in an air void target range of  2.5 - 3.5%, while selecting \"Lab-Batched\" will result in an air void target range of  3.5 - 4.5%."]
[null,null,null,"Total %AC","% Added AC","Gmm","Gmb","% Air Voids","% VMA","TSR","Material Used for Verification"]
[null,{"$f":"_xlfn.SWITCH('Mix Design Data Entry'!$I$71,INTERNAL_SYS_VAR!$R$3,\"4.0% Va\",INTERNAL_SYS_VAR!$R$4,\"4.5% Va\",INTERNAL_SYS_VAR!$R$5,\"2.0% Va\",INTERNAL_SYS_VAR!$R$6,\"1.0% Va\")","v":"4.0% Va"},"Design:",{"$f":"IF('Mix Design Data Entry'!J71=\"\",\"\",'Mix Design Data Entry'!J71)","v":""},{"$f":"IF('Mix Design Data Entry'!K71=\"\",\"\",'Mix Design Data Entry'!K71)","v":""},{"$f":"IF('Mix Design Data Entry'!L71=\"\",\"\",'Mix Design Data Entry'!L71)","v":""},{"$f":"IF('Mix Design Data Entry'!M71=\"\",\"\",'Mix Design Data Entry'!M71)","v":""},{"$f":"IF('Mix Design Data Entry'!N71=\"\",\"\",'Mix Design Data Entry'!N71)","v":""},{"$f":"IF('Mix Design Data Entry'!O71=\"\",\"\",'Mix Design Data Entry'!O71)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$67=\"\",\"\",'Mix Design Data Entry'!$F$67)","v":""}]
[null,"3.0% Av","Design:",{"$f":"IF('Mix Design Data Entry'!J72=\"\",\"\",'Mix Design Data Entry'!J72)","v":""},{"$f":"IF('Mix Design Data Entry'!K72=\"\",\"\",'Mix Design Data Entry'!K72)","v":""},{"$f":"IF('Mix Design Data Entry'!L72=\"\",\"\",'Mix Design Data Entry'!L72)","v":""},{"$f":"IF('Mix Design Data Entry'!M72=\"\",\"\",'Mix Design Data Entry'!M72)","v":""},{"$f":"IF('Mix Design Data Entry'!N72=\"\",\"\",'Mix Design Data Entry'!N72)","v":""},{"$f":"IF('Mix Design Data Entry'!O72=\"\",\"\",'Mix Design Data Entry'!O72)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$67=\"\",\"\",'Mix Design Data Entry'!$F$67)","v":""}]
[null,null,"One Point:"]
[null,null,"Verification Check:",null,null,null,null,{"$f":"IF(INTERNAL_SYS_VAR!$W$3=1,\"2.5 - 3.5\",\"3.5 - 4.5\")","v":"2.5 - 3.5"}]
[]
[null,"Comments:"]

{"sheet":"3.0% Va Regression","index":3,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[21,3,21,4],[22,3,22,4],[34,3,34,7],[36,3,36,7],[37,3,37,7],[28,3,28,7],[9,4,9,8],[10,4,10,8],[8,4,8,8],[12,1,12,8],[20,3,20,4],[0,3,0,8],[4,1,4,8],[6,4,6,8],[7,4,7,8],[0,1,2,2],[1,3,1,8],[2,3,2,8],[46,3,46,7],[47,3,47,7],[48,3,48,7],[26,1,26,8],[30,1,30,8],[32,3,32,7],[33,3,33,7],[39,1,39,8],[41,3,41,7],[42,3,42,7],[43,3,43,7],[44,3,44,7],[45,3,45,7],[35,3,35,7]]}
[null,{"$error":"#VALUE!"},null,"HMA & SMA Mix Design Report"]
[null,null,null,"Wisconsin Department of Transportation"]
[null,null,null,{"$f":"\"DT2490        \" & TEXT(INTERNAL_SYS_VAR!$B$4,\"M/YYYY\")","v":"DT2490        3/2026"}]
[]
[null,"3.0% Air Void Regression Calculator"]
[]
[null,null,null,"Project:",{"$f":"IF('Mix Design Data Entry'!$D$5=\"\",\"\",'Mix Design Data Entry'!$D$5)","v":""}]
[null,null,null,"HMA Producer:",{"$f":"IF('Mix Design Data Entry'!$I$8=\"\",\"\",'Mix Design Data Entry'!$I$8)","v":""}]
[null,null,null,"Mix Type:",{"$f":"_xlfn.CONCAT('Mix Design Data Entry'!$D$8,\"-\",'Mix Design Data Entry'!$D$7,\"-\",'Mix Design Data Entry'!$D$11,\"-\",'Mix Design Data Entry'!$D$12)","v":"---"}]
[null,null,null,"Contractor Mix Design ID:",{"$f":"IF('Mix Design Data Entry'!$D$6=\"\",\"\",'Mix Design Data Entry'!$D$6)","v":""}]
[null,null,null,"WisDOT Mix Design 250#:",{"$f":"IF('Mix Design Data Entry'!$O$5=\"\",\"\",'Mix Design Data Entry'!$O$5)","v":""}]
[]
[null,"Step 1: Contractor's Mix Design Information"]
[]
[null,null,"Point","Total Pb","Gmm","Gmb","Va","VMA"]
[null,null,1,{"$f":"IF('Mix Design Data Entry'!J67=\"\",\"\",'Mix Design Data Entry'!J67)","v":""},{"$f":"IF('Mix Design Data Entry'!L67=\"\",\"\",'Mix Design Data Entry'!L67)","v":""},{"$f":"IF('Mix Design Data Entry'!M67=\"\",\"\",'Mix Design Data Entry'!M67)","v":""},{"$f":"IF('Mix Design Data Entry'!N67=\"\",\"\",'Mix Design Data Entry'!N67)","v":""},{"$f":"IF('Mix Design Data Entry'!O67=\"\",\"\",'Mix Design Data Entry'!O67)","v":""}]
[null,null,2,{"$f":"IF('Mix Design Data Entry'!J68=\"\",\"\",'Mix Design Data Entry'!J68)","v":""},{"$f":"IF('Mix Design Data Entry'!L68=\"\",\"\",'Mix Design Data Entry'!L68)","v":""},{"$f":"IF('Mix Design Data Entry'!M68=\"\",\"\",'Mix Design Data Entry'!M68)","v":""},{"$f":"IF('Mix Design Data Entry'!N68=\"\",\"\",'Mix Design Data Entry'!N68)","v":""},{"$f":"IF('Mix Design Data Entry'!O68=\"\",\"\",'Mix Design Data Entry'!O68)","v":""}]
[null,null,3,{"$f":"IF('Mix Design Data Entry'!J69=\"\",\"\",'Mix Design Data Entry'!J69)","v":""},{"$f":"IF('Mix Design Data Entry'!L69=\"\",\"\",'Mix Design Data Entry'!L69)","v":""},{"$f":"IF('Mix Design Data Entry'!M69=\"\",\"\",'Mix Design Data Entry'!M69)","v":""},{"$f":"IF('Mix Design Data Entry'!N69=\"\",\"\",'Mix Design Data Entry'!N69)","v":""},{"$f":"IF('Mix Design Data Entry'!O69=\"\",\"\",'Mix Design Data Entry'!O69)","v":""}]
[null,null,4,{"$f":"IF('Mix Design Data Entry'!J70=\"\",\"\",'Mix Design Data Entry'!J70)","v":""},{"$f":"IF('Mix Design Data Entry'!L70=\"\",\"\",'Mix Design Data Entry'!L70)","v":""},{"$f":"IF('Mix Design Data Entry'!M70=\"\",\"\",'Mix Design Data Entry'!M70)","v":""},{"$f":"IF('Mix Design Data Entry'!N70=\"\",\"\",'Mix Design Data Entry'!N70)","v":""},{"$f":"IF('Mix Design Data Entry'!O70=\"\",\"\",'Mix Design Data Entry'!O70)","v":""}]
[]
[null,null,"Gsb:",{"$f":"'Mix Design Data Entry'!P39","v":""}]
[null,null,"Gse:",{"$f":"IF('Mix Design Data Entry'!P21=\"\",\"\",'Mix Design Data Entry'!P21)","v":""}]
[null,null,"Gb:",{"$f":"IF('Mix Design Data Entry'!D13=\"\",\"\",'Mix Design Data Entry'!D13)","v":""}]
[]
[]
[]
[null,"Step 2: Regressed Target Air Voids"]
[]
[null,null,"Target Va:",3]
[]
[null,{"$f":"\"Step 3: Volumetric Data at the Regressed \" & TEXT(D29,\"0.0\") & \"% Air Void Target\"","v":"Step 3: Volumetric Data at the Regressed 3.0% Air Void Target"}]
[]
[null,null,"Total Pb:",{"$f":"IF(OR(D22=\"\",D23=\"\",D34=\"\"),\"\",ROUND(100*((D23/D34)*((D22-D34)/(D22-D23))),1))","v":""}]
[null,null,"Gmm:",{"$f":"IF(AND(E16=\"\",E17=\"\",E18=\"\",E19=\"\",G16=\"\",G17=\"\",G18=\"\",G19=\"\"),\"\",IFERROR(ROUND((3-INTERCEPT(G16:G19,E16:E19))/((SLOPE(G16:G19,E16:E19))),3),0))","v":""}]
[null,null,"Gmb:",{"$f":"IF(D34=\"\",\"\",ROUND(D34*0.97,3))","v":""}]
[null,null,"Va:",{"$f":"IFERROR(ROUND(100*((D34-D35)/D34),1),\"\")","v":""}]
[null,null,"VMA:",{"$f":"IF(OR(D21=\"\",D33=\"\",D35=\"\"),\"\",IFERROR(ROUND((100-((D35)*(100-D33))/D21),1),0))","v":""}]
[null,null,"VFB:",{"$f":"IF(D37=\"\",\"\",IFERROR(ROUND(100*((D37-D29)/D37),1),0))","v":""}]
[]
[null,{"$f":"IF('Mix Design Data Entry'!$D$7=\"\",\"Air Void Summary @ 4.0% Va for HMA or 4.5% Va for SMA\",IF('Mix Design Data Entry'!$D$7<>\"SMA\",\"4.0% Air Void Summary\",\"4.5% Air Void Summary\"))","v":"Air Void Summary @ 4.0% Va for HMA or 4.5% Va for SMA"}]
[]
[null,null,"Total Pb %:",{"$f":"IF('Mix Design Data Entry'!J71=\"\",\"\",'Mix Design Data Entry'!J71)","v":""}]
[null,null,"Added Pb %:",{"$f":"IF('Mix Design Data Entry'!K71=\"\",\"\",'Mix Design Data Entry'!K71)","v":""}]
[null,null,"Gmm:",{"$f":"IF('Mix Design Data Entry'!L71=\"\",\"\",'Mix Design Data Entry'!L71)","v":""}]
[null,null,"Gmb:",{"$f":"IF('Mix Design Data Entry'!M71=\"\",\"\",'Mix Design Data Entry'!M71)","v":""}]
[null,null,"VMA %:",{"$f":"IF('Mix Design Data Entry'!O71=\"\",\"\",'Mix Design Data Entry'!O71)","v":""}]
[null,null,"VFB/VFA %:",{"$f":"IF('Mix Design Data Entry'!P71=\"\",\"\",'Mix Design Data Entry'!P71)","v":""}]
[null,null,"Pbr %:",{"$f":"IF('Mix Design Data Entry'!P49=\"\",\"\",'Mix Design Data Entry'!P49)","v":""}]
[null,null,"DP %:",{"$f":"IF('Mix Design Data Entry'!P52=\"\",\"\",'Mix Design Data Entry'!P52)","v":""}]

{"sheet":"Convert to .txt File","index":4,"n_rows":23,"n_cols":46,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["SampleCard",{"$f":"IF('Mix Design Data Entry'!$D$5=\"\",\"\",'Mix Design Data Entry'!$D$5)","v":""},"DR",{"$f":"IF('Mix Design Data Entry'!$I$10=\"\",\"\",'Mix Design Data Entry'!$I$10)","v":""},{"$f":"IF('Mix Design Data Entry'!$I$6=\"\",\"\",'Mix Design Data Entry'!$I$6)","v":""},{"$f":"IF('Mix Design Data Entry'!$I$7=\"\",\"\",'Mix Design Data Entry'!$I$7)","v":""},"Y",{"$f":"_xlfn.CONCAT($D$2,\" \",$C$2)","v":" "},{"$f":"IF('Mix Design Data Entry'!$I$8=\"\",\"\",'Mix Design Data Entry'!$I$8)","v":""},{"$f":"IF('Mix Design Data Entry'!$I$9=\"\",\"\",'Mix Design Data Entry'!$I$9)","v":""},{"$f":"IF('Mix Design Data Entry'!$C$74=\"\",\"\",'Mix Design Data Entry'!$C$74)","v":""}]
["MixDesign",{"$f":"IF('Mix Design Data Entry'!$D$6=\"\",\"\",'Mix Design Data Entry'!$D$6)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$7=\"\",\"\",'Mix Design Data Entry'!$D$7)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$8=\"\",\"\",'Mix Design Data Entry'!$D$8)","v":""},{"$f":"IF('Mix Design Data Entry'!$J$71=\"\",\"\",'Mix Design Data Entry'!$J$71)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$71=\"\",\"\",'Mix Design Data Entry'!$K$71)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$11=\"\",\"\",'Mix Design Data Entry'!$D$11)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$12=\"\",\"\",'Mix Design Data Entry'!$D$12)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$13=\"\",\"\",'Mix Design Data Entry'!$D$13)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$14=\"\",\"\",'Mix Design Data Entry'!$D$14)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$24=\"\",\"\",'Mix Design Data Entry'!$L$24)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$24=\"\",\"\",'Mix Design Data Entry'!$M$24)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$24=\"\",\"\",'Mix Design Data Entry'!$N$24)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$55=\"\",\"\",'Mix Design Data Entry'!$F$55)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$56=\"\",\"\",'Mix Design Data Entry'!$F$56)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$71=\"\",\"\",'Mix Design Data Entry'!$L$71)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$71=\"\",\"\",'Mix Design Data Entry'!$M$71)","v":""},{"$f":"IF('Mix Design Data Entry'!$P$42=\"\",\"\",'Mix Design Data Entry'!$P$42)","v":""},{"$f":"IF('Mix Design Data Entry'!$P$22=\"\",\"\",'Mix Design Data Entry'!$P$22)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$55=\"\",\"\",'Mix Design Data Entry'!$N$55)","v":""},{"$f":"IF('Mix Design Data Entry'!$P$40=\"\",\"\",'Mix Design Data Entry'!$P$40)","v":""},{"$f":"IF('Mix Design Data Entry'!$P$41=\"\",\"\",'Mix Design Data Entry'!$P$41)","v":""},{"$f":"IF('Mix Design Data Entry'!$P$44=\"\",\"\",'Mix Design Data Entry'!$P$44)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$64=\"\",\"\",'Mix Design Data Entry'!$F$64)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$67=\"\",\"\",'Mix Design Data Entry'!$F$67)","v":""},{"$f":"IF('Mix Design Data Entry'!$P$43=\"\",\"\",'Mix Design Data Entry'!$P$43)","v":""},{"$f":"IF('Mix Design Data Entry'!$P$52=\"\",\"\",'Mix Design Data Entry'!$P$52)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$50=\"\",\"\",'Mix Design Data Entry'!$D$50)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$50=\"\",\"\",'Mix Design Data Entry'!$F$50)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$51=\"\",\"\",'Mix Design Data Entry'!$D$51)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$51=\"\",\"\",'Mix Design Data Entry'!$F$51)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$51=\"\",\"\",'Mix Design Data Entry'!$M$51)","v":""},{"$f":"IF('Mix Design Data Entry'!$P$49=\"\",\"\",'Mix Design Data Entry'!$P$49)","v":""},{"$f":"IF('Mix Design Data Entry'!$P$50=\"\",\"\",'Mix Design Data Entry'!$P$50)","v":""},{"$f":"IF('Mix Design Data Entry'!$P$51=\"\",\"\",'Mix Design Data Entry'!$P$51)","v":""},{"$f":"IF('Mix Design Data Entry'!$B$60=\"\",\"\",'Mix Design Data Entry'!$B$60)","v":""},{"$f":"IF('Mix Design Data Entry'!$E$60=\"\",\"\",'Mix Design Data Entry'!$E$60)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$65=\"\",\"\",'Mix Design Data Entry'!$F$65)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$66=\"\",\"\",'Mix Design Data Entry'!$F$66)","v":""},{"$f":"IF('Mix Design Data Entry'!$P$23=\"\",\"\",'Mix Design Data Entry'!$P$23)","v":""},{"$f":"IF('Mix Design Data Entry'!$P$24=\"\",\"\",'Mix Design Data Entry'!$P$24)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$69=\"\",\"\",'Mix Design Data Entry'!$F$69)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$70=\"\",\"\",'Mix Design Data Entry'!$F$70)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$72=\"\",\"\",'Mix Design Data Entry'!$F$72)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$9=\"\",\"\",'Mix Design Data Entry'!$D$9)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$10=\"\",\"\",'Mix Design Data Entry'!$D$10)","v":""}]
[{"$f":"IF($B$3=\"\",\"\",\"AggtSample\")","v":""},{"$f":"IF('Mix Design Data Entry'!$D$20=\"\",\"\",'Mix Design Data Entry'!$D$20)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$23=\"\",\"\",'Mix Design Data Entry'!$D$23)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$22=\"\",\"\",'Mix Design Data Entry'!$D$22)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$27=\"\",\"\",'Mix Design Data Entry'!$D$27)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$28=\"\",\"\",'Mix Design Data Entry'!$D$28)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$29=\"\",\"\",'Mix Design Data Entry'!$D$29)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$30=\"\",\"\",'Mix Design Data Entry'!$D$30)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$31=\"\",\"\",'Mix Design Data Entry'!$D$31)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$32=\"\",\"\",'Mix Design Data Entry'!$D$32)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$33=\"\",\"\",'Mix Design Data Entry'!$D$33)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$34=\"\",\"\",'Mix Design Data Entry'!$D$34)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$35=\"\",\"\",'Mix Design Data Entry'!$D$35)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$36=\"\",\"\",'Mix Design Data Entry'!$D$36)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$37=\"\",\"\",'Mix Design Data Entry'!$D$37)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$19=\"\",\"\",'Mix Design Data Entry'!$D$19)","v":""},{"$f":"IF('Mix Design Data Entry'!$D$39=\"\",\"\",'Mix Design Data Entry'!$D$39)","v":""},null,{"$f":"IF('Mix Design Data Entry'!$D$21=\"\",\"\",'Mix Design Data Entry'!$D$21)","v":""},null,"  "]
[{"$f":"IF($B$4=\"\",\"\",\"AggtSample\")","v":""},{"$f":"IF('Mix Design Data Entry'!$E$20=\"\",\"\",'Mix Design Data Entry'!$E$20)","v":""},{"$f":"IF('Mix Design Data Entry'!$E$23=\"\",\"\",'Mix Design Data Entry'!$E$23)","v":""},{"$f":"IF('Mix Design Data Entry'!$E$22=\"\",\"\",'Mix Design Data Entry'!$E$22)","v":""},{"$f":"IF('Mix Design Data Entry'!$E$27=\"\",\"\",'Mix Design Data Entry'!$E$27)","v":""},{"$f":"IF('Mix Design Data Entry'!$E$28=\"\",\"\",'Mix Design Data Entry'!$E$28)","v":""},{"$f":"IF('Mix Design Data Entry'!$E$29=\"\",\"\",'Mix Design Data Entry'!$E$29)","v":""},{"$f":"IF('Mix Design Data Entry'!$E$30=\"\",\"\",'Mix Design Data Entry'!$E$30)","v":""},{"$f":"IF('Mix Design Data Entry'!$E$31=\"\",\"\",'Mix Design Data Entry'!$E$31)","v":""},{"$f":"IF('Mix Design Data Entry'!$E$32=\"\",\"\",'Mix Design Data Entry'!$E$32)","v":""},{"$f":"IF('Mix Design Data Entry'!$E$33=\"\",\"\",'Mix Design Data Entry'!$E$33)","v":""},{"$f":"IF('Mix Design Data Entry'!$E$34=\"\",\"\",'Mix Design Data Entry'!$E$34)","v":""},{"$f":"IF('Mix Design Data Entry'!$E$35=\"\",\"\",'Mix Design Data Entry'!$E$35)","v":""},{"$f":"IF('Mix Design Data Entry'!$E$36=\"\",\"\",'Mix Design Data Entry'!$E$36)","v":""},{"$f":"IF('Mix Design Data Entry'!$E$37=\"\",\"\",'Mix Design Data Entry'!$E$37)","v":""},{"$f":"IF('Mix Design Data Entry'!$E$19=\"\",\"\",'Mix Design Data Entry'!$E$19)","v":""},{"$f":"IF('Mix Design Data Entry'!$E$39=\"\",\"\",'Mix Design Data Entry'!$E$39)","v":""},null,{"$f":"IF('Mix Design Data Entry'!$E$21=\"\",\"\",'Mix Design Data Entry'!$E$21)","v":""},"  "]
[{"$f":"IF($B$5=\"\",\"\",\"AggtSample\")","v":""},{"$f":"IF('Mix Design Data Entry'!$F$20=\"\",\"\",'Mix Design Data Entry'!$F$20)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$23=\"\",\"\",'Mix Design Data Entry'!$F$23)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$22=\"\",\"\",'Mix Design Data Entry'!$F$22)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$27=\"\",\"\",'Mix Design Data Entry'!$F$27)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$28=\"\",\"\",'Mix Design Data Entry'!$F$28)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$29=\"\",\"\",'Mix Design Data Entry'!$F$29)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$30=\"\",\"\",'Mix Design Data Entry'!$F$30)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$31=\"\",\"\",'Mix Design Data Entry'!$F$31)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$32=\"\",\"\",'Mix Design Data Entry'!$F$32)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$33=\"\",\"\",'Mix Design Data Entry'!$F$33)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$34=\"\",\"\",'Mix Design Data Entry'!$F$34)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$35=\"\",\"\",'Mix Design Data Entry'!$F$35)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$36=\"\",\"\",'Mix Design Data Entry'!$F$36)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$37=\"\",\"\",'Mix Design Data Entry'!$F$37)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$19=\"\",\"\",'Mix Design Data Entry'!$F$19)","v":""},{"$f":"IF('Mix Design Data Entry'!$F$39=\"\",\"\",'Mix Design Data Entry'!$F$39)","v":""},null,{"$f":"IF('Mix Design Data Entry'!$F$21=\"\",\"\",'Mix Design Data Entry'!$F$21)","v":""},"  "]
[{"$f":"IF($B$6=\"\",\"\",\"AggtSample\")","v":""},{"$f":"IF('Mix Design Data Entry'!$G$20=\"\",\"\",'Mix Design Data Entry'!$G$20)","v":""},{"$f":"IF('Mix Design Data Entry'!$G$23=\"\",\"\",'Mix Design Data Entry'!$G$23)","v":""},{"$f":"IF('Mix Design Data Entry'!$G$22=\"\",\"\",'Mix Design Data Entry'!$G$22)","v":""},{"$f":"IF('Mix Design Data Entry'!$G$27=\"\",\"\",'Mix Design Data Entry'!$G$27)","v":""},{"$f":"IF('Mix Design Data Entry'!$G$28=\"\",\"\",'Mix Design Data Entry'!$G$28)","v":""},{"$f":"IF('Mix Design Data Entry'!$G$29=\"\",\"\",'Mix Design Data Entry'!$G$29)","v":""},{"$f":"IF('Mix Design Data Entry'!$G$30=\"\",\"\",'Mix Design Data Entry'!$G$30)","v":""},{"$f":"IF('Mix Design Data Entry'!$G$31=\"\",\"\",'Mix Design Data Entry'!$G$31)","v":""},{"$f":"IF('Mix Design Data Entry'!$G$32=\"\",\"\",'Mix Design Data Entry'!$G$32)","v":""},{"$f":"IF('Mix Design Data Entry'!$G$33=\"\",\"\",'Mix Design Data Entry'!$G$33)","v":""},{"$f":"IF('Mix Design Data Entry'!$G$34=\"\",\"\",'Mix Design Data Entry'!$G$34)","v":""},{"$f":"IF('Mix Design Data Entry'!$G$35=\"\",\"\",'Mix Design Data Entry'!$G$35)","v":""},{"$f":"IF('Mix Design Data Entry'!$G$36=\"\",\"\",'Mix Design Data Entry'!$G$36)","v":""},{"$f":"IF('Mix Design Data Entry'!$G$37=\"\",\"\",'Mix Design Data Entry'!$G$37)","v":""},{"$f":"IF('Mix Design Data Entry'!$G$19=\"\",\"\",'Mix Design Data Entry'!$G$19)","v":""},{"$f":"IF('Mix Design Data Entry'!$G$39=\"\",\"\",'Mix Design Data Entry'!$G$39)","v":""},null,{"$f":"IF('Mix Design Data Entry'!$G$21=\"\",\"\",'Mix Design Data Entry'!$G$21)","v":""}]
[{"$f":"IF($B$7=\"\",\"\",\"AggtSample\")","v":""},{"$f":"IF('Mix Design Data Entry'!$H$20=\"\",\"\",'Mix Design Data Entry'!$H$20)","v":""},{"$f":"IF('Mix Design Data Entry'!$H$23=\"\",\"\",'Mix Design Data Entry'!$H$23)","v":""},{"$f":"IF('Mix Design Data Entry'!$H$22=\"\",\"\",'Mix Design Data Entry'!$H$22)","v":""},{"$f":"IF('Mix Design Data Entry'!$H$27=\"\",\"\",'Mix Design Data Entry'!$H$27)","v":""},{"$f":"IF('Mix Design Data Entry'!$H$28=\"\",\"\",'Mix Design Data Entry'!$H$28)","v":""},{"$f":"IF('Mix Design Data Entry'!$H$29=\"\",\"\",'Mix Design Data Entry'!$H$29)","v":""},{"$f":"IF('Mix Design Data Entry'!$H$30=\"\",\"\",'Mix Design Data Entry'!$H$30)","v":""},{"$f":"IF('Mix Design Data Entry'!$H$31=\"\",\"\",'Mix Design Data Entry'!$H$31)","v":""},{"$f":"IF('Mix Design Data Entry'!$H$32=\"\",\"\",'Mix Design Data Entry'!$H$32)","v":""},{"$f":"IF('Mix Design Data Entry'!$H$33=\"\",\"\",'Mix Design Data Entry'!$H$33)","v":""},{"$f":"IF('Mix Design Data Entry'!$H$34=\"\",\"\",'Mix Design Data Entry'!$H$34)","v":""},{"$f":"IF('Mix Design Data Entry'!$H$35=\"\",\"\",'Mix Design Data Entry'!$H$35)","v":""},{"$f":"IF('Mix Design Data Entry'!$H$36=\"\",\"\",'Mix Design Data Entry'!$H$36)","v":""},{"$f":"IF('Mix Design Data Entry'!$H$37=\"\",\"\",'Mix Design Data Entry'!$H$37)","v":""},{"$f":"IF('Mix Design Data Entry'!$H$19=\"\",\"\",'Mix Design Data Entry'!$H$19)","v":""},{"$f":"IF('Mix Design Data Entry'!$H$39=\"\",\"\",'Mix Design Data Entry'!$H$39)","v":""},null,{"$f":"IF('Mix Design Data Entry'!$H$21=\"\",\"\",'Mix Design Data Entry'!$H$21)","v":""}]
[{"$f":"IF($B$8=\"\",\"\",\"AggtSample\")","v":""},{"$f":"IF('Mix Design Data Entry'!$I$20=\"\",\"\",'Mix Design Data Entry'!$I$20)","v":""},{"$f":"IF('Mix Design Data Entry'!$I$23=\"\",\"\",'Mix Design Data Entry'!$I$23)","v":""},{"$f":"IF('Mix Design Data Entry'!$I$22=\"\",\"\",'Mix Design Data Entry'!$I$22)","v":""},{"$f":"IF('Mix Design Data Entry'!$I$27=\"\",\"\",'Mix Design Data Entry'!$I$27)","v":""},{"$f":"IF('Mix Design Data Entry'!$I$28=\"\",\"\",'Mix Design Data Entry'!$I$28)","v":""},{"$f":"IF('Mix Design Data Entry'!$I$29=\"\",\"\",'Mix Design Data Entry'!$I$29)","v":""},{"$f":"IF('Mix Design Data Entry'!$I$30=\"\",\"\",'Mix Design Data Entry'!$I$30)","v":""},{"$f":"IF('Mix Design Data Entry'!$I$31=\"\",\"\",'Mix Design Data Entry'!$I$31)","v":""},{"$f":"IF('Mix Design Data Entry'!$I$32=\"\",\"\",'Mix Design Data Entry'!$I$32)","v":""},{"$f":"IF('Mix Design Data Entry'!$I$33=\"\",\"\",'Mix Design Data Entry'!$I$33)","v":""},{"$f":"IF('Mix Design Data Entry'!$I$34=\"\",\"\",'Mix Design Data Entry'!$I$34)","v":""},{"$f":"IF('Mix Design Data Entry'!$I$35=\"\",\"\",'Mix Design Data Entry'!$I$35)","v":""},{"$f":"IF('Mix Design Data Entry'!$I$36=\"\",\"\",'Mix Design Data Entry'!$I$36)","v":""},{"$f":"IF('Mix Design Data Entry'!$I$37=\"\",\"\",'Mix Design Data Entry'!$I$37)","v":""},{"$f":"IF('Mix Design Data Entry'!$I$19=\"\",\"\",'Mix Design Data Entry'!$I$19)","v":""},{"$f":"IF('Mix Design Data Entry'!$I$39=\"\",\"\",'Mix Design Data Entry'!$I$39)","v":""},null,{"$f":"IF('Mix Design Data Entry'!$I$21=\"\",\"\",'Mix Design Data Entry'!$I$21)","v":""},"  "]
[{"$f":"IF($B$9=\"\",\"\",\"AggtSample\")","v":""},{"$f":"IF('Mix Design Data Entry'!$J$20=\"\",\"\",'Mix Design Data Entry'!$J$20)","v":""},{"$f":"IF('Mix Design Data Entry'!$J$23=\"\",\"\",'Mix Design Data Entry'!$J$23)","v":""},{"$f":"IF('Mix Design Data Entry'!$J$22=\"\",\"\",'Mix Design Data Entry'!$J$22)","v":""},{"$f":"IF('Mix Design Data Entry'!$J$27=\"\",\"\",'Mix Design Data Entry'!$J$27)","v":""},{"$f":"IF('Mix Design Data Entry'!$J$28=\"\",\"\",'Mix Design Data Entry'!$J$28)","v":""},{"$f":"IF('Mix Design Data Entry'!$J$29=\"\",\"\",'Mix Design Data Entry'!$J$29)","v":""},{"$f":"IF('Mix Design Data Entry'!$J$30=\"\",\"\",'Mix Design Data Entry'!$J$30)","v":""},{"$f":"IF('Mix Design Data Entry'!$J$31=\"\",\"\",'Mix Design Data Entry'!$J$31)","v":""},{"$f":"IF('Mix Design Data Entry'!$J$32=\"\",\"\",'Mix Design Data Entry'!$J$32)","v":""},{"$f":"IF('Mix Design Data Entry'!$J$33=\"\",\"\",'Mix Design Data Entry'!$J$33)","v":""},{"$f":"IF('Mix Design Data Entry'!$J$34=\"\",\"\",'Mix Design Data Entry'!$J$34)","v":""},{"$f":"IF('Mix Design Data Entry'!$J$35=\"\",\"\",'Mix Design Data Entry'!$J$35)","v":""},{"$f":"IF('Mix Design Data Entry'!$J$36=\"\",\"\",'Mix Design Data Entry'!$J$36)","v":""},{"$f":"IF('Mix Design Data Entry'!$J$37=\"\",\"\",'Mix Design Data Entry'!$J$37)","v":""},{"$f":"IF('Mix Design Data Entry'!$J$19=\"\",\"\",'Mix Design Data Entry'!$J$19)","v":""},{"$f":"IF('Mix Design Data Entry'!$J$39=\"\",\"\",'Mix Design Data Entry'!$J$39)","v":""},null,{"$f":"IF('Mix Design Data Entry'!$J$21=\"\",\"\",'Mix Design Data Entry'!$J$21)","v":""}]
[{"$f":"IF($B$10=\"\",\"\",\"AggtSample\")","v":""},{"$f":"IF('Mix Design Data Entry'!$K$20=\"\",\"\",'Mix Design Data Entry'!$K$20)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$23=\"\",\"\",'Mix Design Data Entry'!$K$23)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$22=\"\",\"\",'Mix Design Data Entry'!$K$22)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$27=\"\",\"\",'Mix Design Data Entry'!$K$27)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$28=\"\",\"\",'Mix Design Data Entry'!$K$28)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$29=\"\",\"\",'Mix Design Data Entry'!$K$29)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$30=\"\",\"\",'Mix Design Data Entry'!$K$30)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$31=\"\",\"\",'Mix Design Data Entry'!$K$31)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$32=\"\",\"\",'Mix Design Data Entry'!$K$32)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$33=\"\",\"\",'Mix Design Data Entry'!$K$33)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$34=\"\",\"\",'Mix Design Data Entry'!$K$34)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$35=\"\",\"\",'Mix Design Data Entry'!$K$35)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$36=\"\",\"\",'Mix Design Data Entry'!$K$36)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$37=\"\",\"\",'Mix Design Data Entry'!$K$37)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$19=\"\",\"\",'Mix Design Data Entry'!$K$19)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$39=\"\",\"\",'Mix Design Data Entry'!$K$39)","v":""},null,{"$f":"IF('Mix Design Data Entry'!$K$21=\"\",\"\",'Mix Design Data Entry'!$K$21)","v":""}]
[{"$f":"IF($B$11=\"\",\"\",\"AggtSample\")","v":""},{"$f":"IF('Mix Design Data Entry'!$L$20=\"\",\"\",'Mix Design Data Entry'!$L$20)","v":""},null,{"$f":"IF('Mix Design Data Entry'!$L$22=\"\",\"\",'Mix Design Data Entry'!$L$22)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$27=\"\",\"\",'Mix Design Data Entry'!$L$27)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$28=\"\",\"\",'Mix Design Data Entry'!$L$28)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$29=\"\",\"\",'Mix Design Data Entry'!$L$29)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$30=\"\",\"\",'Mix Design Data Entry'!$L$30)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$31=\"\",\"\",'Mix Design Data Entry'!$L$31)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$32=\"\",\"\",'Mix Design Data Entry'!$L$32)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$33=\"\",\"\",'Mix Design Data Entry'!$L$33)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$34=\"\",\"\",'Mix Design Data Entry'!$L$34)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$35=\"\",\"\",'Mix Design Data Entry'!$L$35)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$36=\"\",\"\",'Mix Design Data Entry'!$L$36)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$37=\"\",\"\",'Mix Design Data Entry'!$L$37)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$19=\"\",\"\",'Mix Design Data Entry'!$L$19)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$39=\"\",\"\",'Mix Design Data Entry'!$L$39)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$24=\"\",\"\",'Mix Design Data Entry'!$L$24)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$21=\"\",\"\",'Mix Design Data Entry'!$L$21)","v":""}]
[{"$f":"IF($B$12=\"\",\"\",\"AggtSample\")","v":""},{"$f":"IF('Mix Design Data Entry'!$M$20=\"\",\"\",'Mix Design Data Entry'!$M$20)","v":""},null,{"$f":"IF('Mix Design Data Entry'!$M$22=\"\",\"\",'Mix Design Data Entry'!$M$22)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$27=\"\",\"\",'Mix Design Data Entry'!$M$27)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$28=\"\",\"\",'Mix Design Data Entry'!$M$28)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$29=\"\",\"\",'Mix Design Data Entry'!$M$29)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$30=\"\",\"\",'Mix Design Data Entry'!$M$30)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$31=\"\",\"\",'Mix Design Data Entry'!$M$31)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$32=\"\",\"\",'Mix Design Data Entry'!$M$32)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$33=\"\",\"\",'Mix Design Data Entry'!$M$33)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$34=\"\",\"\",'Mix Design Data Entry'!$M$34)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$35=\"\",\"\",'Mix Design Data Entry'!$M$35)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$36=\"\",\"\",'Mix Design Data Entry'!$M$36)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$37=\"\",\"\",'Mix Design Data Entry'!$M$37)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$19=\"\",\"\",'Mix Design Data Entry'!$M$19)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$39=\"\",\"\",'Mix Design Data Entry'!$M$39)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$24=\"\",\"\",'Mix Design Data Entry'!$M$24)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$21=\"\",\"\",'Mix Design Data Entry'!$M$21)","v":""}]
[{"$f":"IF($B$13=\"\",\"\",\"AggtSample\")","v":""},{"$f":"IF('Mix Design Data Entry'!$N$20=\"\",\"\",'Mix Design Data Entry'!$N$20)","v":""},null,{"$f":"IF('Mix Design Data Entry'!$N$22=\"\",\"\",'Mix Design Data Entry'!$N$22)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$27=\"\",\"\",'Mix Design Data Entry'!$N$27)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$28=\"\",\"\",'Mix Design Data Entry'!$N$28)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$29=\"\",\"\",'Mix Design Data Entry'!$N$29)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$30=\"\",\"\",'Mix Design Data Entry'!$N$30)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$31=\"\",\"\",'Mix Design Data Entry'!$N$31)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$32=\"\",\"\",'Mix Design Data Entry'!$N$32)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$33=\"\",\"\",'Mix Design Data Entry'!$N$33)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$34=\"\",\"\",'Mix Design Data Entry'!$N$34)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$35=\"\",\"\",'Mix Design Data Entry'!$N$35)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$36=\"\",\"\",'Mix Design Data Entry'!$N$36)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$37=\"\",\"\",'Mix Design Data Entry'!$N$37)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$19=\"\",\"\",'Mix Design Data Entry'!$N$19)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$39=\"\",\"\",'Mix Design Data Entry'!$N$39)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$24=\"\",\"\",'Mix Design Data Entry'!$N$24)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$21=\"\",\"\",'Mix Design Data Entry'!$N$21)","v":""}]
["Volumetric",{"$f":"IF('Mix Design Data Entry'!$J$67=\"\",\"\",'Mix Design Data Entry'!$J$67)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$67=\"\",\"\",'Mix Design Data Entry'!$K$67)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$67=\"\",\"\",'Mix Design Data Entry'!$L$67)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$67=\"\",\"\",'Mix Design Data Entry'!$M$67)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$67=\"\",\"\",'Mix Design Data Entry'!$N$67)","v":""},{"$f":"IF('Mix Design Data Entry'!$O$67=\"\",\"\",'Mix Design Data Entry'!$O$67)","v":""},{"$f":"IF('Mix Design Data Entry'!$P$67=\"\",\"\",'Mix Design Data Entry'!$P$67)","v":""}]
["Volumetric",{"$f":"IF('Mix Design Data Entry'!$J$68=\"\",\"\",'Mix Design Data Entry'!$J$68)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$68=\"\",\"\",'Mix Design Data Entry'!$K$68)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$68=\"\",\"\",'Mix Design Data Entry'!$L$68)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$68=\"\",\"\",'Mix Design Data Entry'!$M$68)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$68=\"\",\"\",'Mix Design Data Entry'!$N$68)","v":""},{"$f":"IF('Mix Design Data Entry'!$O$68=\"\",\"\",'Mix Design Data Entry'!$O$68)","v":""},{"$f":"IF('Mix Design Data Entry'!$P$68=\"\",\"\",'Mix Design Data Entry'!$P$68)","v":""}]
["Volumetric",{"$f":"IF('Mix Design Data Entry'!$J$69=\"\",\"\",'Mix Design Data Entry'!$J$69)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$69=\"\",\"\",'Mix Design Data Entry'!$K$69)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$69=\"\",\"\",'Mix Design Data Entry'!$L$69)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$69=\"\",\"\",'Mix Design Data Entry'!$M$69)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$69=\"\",\"\",'Mix Design Data Entry'!$N$69)","v":""},{"$f":"IF('Mix Design Data Entry'!$O$69=\"\",\"\",'Mix Design Data Entry'!$O$69)","v":""},{"$f":"IF('Mix Design Data Entry'!$P$69=\"\",\"\",'Mix Design Data Entry'!$P$69)","v":""}]
["Volumetric",{"$f":"IF('Mix Design Data Entry'!$J$70=\"\",\"\",'Mix Design Data Entry'!$J$70)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$70=\"\",\"\",'Mix Design Data Entry'!$K$70)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$70=\"\",\"\",'Mix Design Data Entry'!$L$70)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$70=\"\",\"\",'Mix Design Data Entry'!$M$70)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$70=\"\",\"\",'Mix Design Data Entry'!$N$70)","v":""},{"$f":"IF('Mix Design Data Entry'!$O$70=\"\",\"\",'Mix Design Data Entry'!$O$70)","v":""},{"$f":"IF('Mix Design Data Entry'!$P$70=\"\",\"\",'Mix Design Data Entry'!$P$70)","v":""}]
["Volumeopt3",{"$f":"IF('Mix Design Data Entry'!$J$72=\"\",\"\",'Mix Design Data Entry'!$J$72)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$72=\"\",\"\",'Mix Design Data Entry'!$K$72)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$72=\"\",\"\",'Mix Design Data Entry'!$L$72)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$72=\"\",\"\",'Mix Design Data Entry'!$M$72)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$72=\"\",\"\",'Mix Design Data Entry'!$N$72)","v":""},{"$f":"IF('Mix Design Data Entry'!$O$72=\"\",\"\",'Mix Design Data Entry'!$O$72)","v":""},{"$f":"IF('Mix Design Data Entry'!$P$72=\"\",\"\",'Mix Design Data Entry'!$P$72)","v":""}]
[{"$f":"IF($B$19=\"\",\"\",\"ACSource\")","v":""},{"$f":"IF('Mix Design Data Entry'!$I$59=\"\",\"\",'Mix Design Data Entry'!$I$59)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$59=\"\",\"\",'Mix Design Data Entry'!$K$59)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$59=\"\",\"\",'Mix Design Data Entry'!$L$59)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$59=\"\",\"\",'Mix Design Data Entry'!$M$59)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$59=\"\",\"\",'Mix Design Data Entry'!$N$59)","v":""},{"$f":"IF('Mix Design Data Entry'!$O$59=\"\",\"\",'Mix Design Data Entry'!$O$59)","v":""},{"$f":"IF('Mix Design Data Entry'!$P$59=\"\",\"\",'Mix Design Data Entry'!$P$59)","v":""}]
[{"$f":"IF($B$20=\"\",\"\",\"ACSource\")","v":""},{"$f":"IF('Mix Design Data Entry'!$I$60=\"\",\"\",'Mix Design Data Entry'!$I$60)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$60=\"\",\"\",'Mix Design Data Entry'!$K$60)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$60=\"\",\"\",'Mix Design Data Entry'!$L$60)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$60=\"\",\"\",'Mix Design Data Entry'!$M$60)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$60=\"\",\"\",'Mix Design Data Entry'!$N$60)","v":""},{"$f":"IF('Mix Design Data Entry'!$O$60=\"\",\"\",'Mix Design Data Entry'!$O$60)","v":""},{"$f":"IF('Mix Design Data Entry'!$P$60=\"\",\"\",'Mix Design Data Entry'!$P$60)","v":""}]
[{"$f":"IF($B$21=\"\",\"\",\"ACSource\")","v":""},{"$f":"IF('Mix Design Data Entry'!$I$61=\"\",\"\",'Mix Design Data Entry'!$I$61)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$61=\"\",\"\",'Mix Design Data Entry'!$K$61)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$61=\"\",\"\",'Mix Design Data Entry'!$L$61)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$61=\"\",\"\",'Mix Design Data Entry'!$M$61)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$61=\"\",\"\",'Mix Design Data Entry'!$N$61)","v":""},{"$f":"IF('Mix Design Data Entry'!$O$61=\"\",\"\",'Mix Design Data Entry'!$O$61)","v":""},{"$f":"IF('Mix Design Data Entry'!$P$61=\"\",\"\",'Mix Design Data Entry'!$P$61)","v":""}]
[{"$f":"IF($B$22=\"\",\"\",\"ACSource\")","v":""},{"$f":"IF('Mix Design Data Entry'!$I$62=\"\",\"\",'Mix Design Data Entry'!$I$62)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$62=\"\",\"\",'Mix Design Data Entry'!$K$62)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$62=\"\",\"\",'Mix Design Data Entry'!$L$62)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$62=\"\",\"\",'Mix Design Data Entry'!$M$62)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$62=\"\",\"\",'Mix Design Data Entry'!$N$62)","v":""},{"$f":"IF('Mix Design Data Entry'!$O$62=\"\",\"\",'Mix Design Data Entry'!$O$62)","v":""},{"$f":"IF('Mix Design Data Entry'!$P$62=\"\",\"\",'Mix Design Data Entry'!$P$62)","v":""},"    ","   ",null,"  "," ",null,"   ","  ",null,"  "]
[{"$f":"IF($B$23=\"\",\"\",\"ACSource\")","v":""},{"$f":"IF('Mix Design Data Entry'!$I$63=\"\",\"\",'Mix Design Data Entry'!$I$63)","v":""},{"$f":"IF('Mix Design Data Entry'!$K$63=\"\",\"\",'Mix Design Data Entry'!$K$63)","v":""},{"$f":"IF('Mix Design Data Entry'!$L$63=\"\",\"\",'Mix Design Data Entry'!$L$63)","v":""},{"$f":"IF('Mix Design Data Entry'!$M$63=\"\",\"\",'Mix Design Data Entry'!$M$63)","v":""},{"$f":"IF('Mix Design Data Entry'!$N$63=\"\",\"\",'Mix Design Data Entry'!$N$63)","v":""},{"$f":"IF('Mix Design Data Entry'!$O$63=\"\",\"\",'Mix Design Data Entry'!$O$63)","v":""},{"$f":"IF('Mix Design Data Entry'!$P$63=\"\",\"\",'Mix Design Data Entry'!$P$63)","v":""}]

{"sheet":"Text Template","index":5,"n_rows":23,"n_cols":46,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["SampleCard","Project ID","Testing Report Type","Mix Design Date","Certified Mix Designer Name","Certified Mix Designer ID","Satisfactory_YN","ML_Material (Mix Type and Mix NMAS)","MFG Name","Plant No / Location","Comments"]
["MixDesign","Design ID","Mix Type","Mix Nmas","Pct AC Total","Pct AC Added","Virgin AC PG","Virgin Binder Designation","AC SP Gravity","AC Source","RAM 1 (RAP) % AC","RAM 2 (RAS) % AC","RAM 3 (FRAP) % AC","Pct Gmm @ Nini","Pct Gmm @ Nmax","Gmm @ 4% Va","Gmb @ 4% Va","Blend FAA","Sand Equiv Pct","Gmm Dryback CF","Blend CAA 1F","Blend CAA 2F","Blend Thin Elong","TSR - Gyrations","TSR","Moisture Absorption","Dust Proportion","HMA/SMA Mix Temp","HMA/SMA Compaction Temp","WMA Mix Temp","WMA Compaction Temp","SMA Draindown Avg @ Plant Temp","PBR","Pbe","Pba","Additive Amount","Additive Amount Amount","TSR - Wet Strength","TSR - Dry Strength","Clay Lumps","Plasticity Index","Hamburg Final Rut Depth","Hamburg Passes to Test Completion","IDEAL-CT CT-Index","Mix PG","Mix Binder Designation"]
["AggtSample","Material 1 Description","Material 1 Agg Source ID","Material 1 P / Q / MF / Dust","Material 1 Sieve_Wt_25","Material 1 Sieve_Wt_19","Material 1 Sieve_Wt_125","Material 1 Sieve_Wt_95","Material 1 Sieve_Wt_475","Material 1 Sieve_Wt_236","Material 1 Sieve_Wt_118","Material 1 Sieve_Wt_060","Material 1 Sieve_Wt_030","Material 1 Sieve_Wt_0150","Material 1 Sieve_Wt_0075","Material 1 Blend_Pct","Material 1 Gsb","<BLANK>","Material 1 Source Name",null,"  "]
["AggtSample","Material 2 Description","Material 2 Agg Source ID","Material 2 P / Q / MF / Dust","Material 2 Sieve_Wt_25","Material 2 Sieve_Wt_19","Material 2 Sieve_Wt_125","Material 2 Sieve_Wt_95","Material 2 Sieve_Wt_475","Material 2 Sieve_Wt_236","Material 2 Sieve_Wt_118","Material 2 Sieve_Wt_060","Material 2 Sieve_Wt_030","Material 2 Sieve_Wt_0150","Material 2 Sieve_Wt_0075","Material 2 Blend_Pct","Material 2 Gsb","<BLANK>","Material 2 Source Name","  "]
["AggtSample","Material 3 Description","Material 3 Agg Source ID","Material 3 P / Q / MF / Dust","Material 3 Sieve_Wt_25","Material 3 Sieve_Wt_19","Material 3 Sieve_Wt_125","Material 3 Sieve_Wt_95","Material 3 Sieve_Wt_475","Material 3 Sieve_Wt_236","Material 3 Sieve_Wt_118","Material 3 Sieve_Wt_060","Material 3 Sieve_Wt_030","Material 3 Sieve_Wt_0150","Material 3 Sieve_Wt_0075","Material 3 Blend_Pct","Material 3 Gsb","<BLANK>","Material 3 Source Name","  "]
["AggtSample","Material 4 Description","Material 4 Agg Source ID","Material 4 P / Q / MF / Dust","Material 4 Sieve_Wt_25","Material 4 Sieve_Wt_19","Material 4 Sieve_Wt_125","Material 4 Sieve_Wt_95","Material 4 Sieve_Wt_475","Material 4 Sieve_Wt_236","Material 4 Sieve_Wt_118","Material 4 Sieve_Wt_060","Material 4 Sieve_Wt_030","Material 4 Sieve_Wt_0150","Material 4 Sieve_Wt_0075","Material 4 Blend_Pct","Material 4 Gsb","<BLANK>","Material 4 Source Name"]
["AggtSample","Material 5 Description","Material 5 Agg Source ID","Material 5 P / Q / MF / Dust","Material 5 Sieve_Wt_25","Material 5 Sieve_Wt_19","Material 5 Sieve_Wt_125","Material 5 Sieve_Wt_95","Material 5 Sieve_Wt_475","Material 5 Sieve_Wt_236","Material 5 Sieve_Wt_118","Material 5 Sieve_Wt_060","Material 5 Sieve_Wt_030","Material 5 Sieve_Wt_0150","Material 5 Sieve_Wt_0075","Material 5 Blend_Pct","Material 5 Gsb","<BLANK>","Material 5 Source Name"]
["AggtSample","Material 6 Description","Material 6 Agg Source ID","Material 6 P / Q / MF / Dust","Material 6 Sieve_Wt_25","Material 6 Sieve_Wt_19","Material 6 Sieve_Wt_125","Material 6 Sieve_Wt_95","Material 6 Sieve_Wt_475","Material 6 Sieve_Wt_236","Material 6 Sieve_Wt_118","Material 6 Sieve_Wt_060","Material 6 Sieve_Wt_030","Material 6 Sieve_Wt_0150","Material 6 Sieve_Wt_0075","Material 6 Blend_Pct","Material 6 Gsb","<BLANK>","Material 6 Source Name","  "]
["AggtSample","Material 7 Description","Material 7 Agg Source ID","Material 7 P / Q / MF / Dust","Material 7 Sieve_Wt_25","Material 7 Sieve_Wt_19","Material 7 Sieve_Wt_125","Material 7 Sieve_Wt_95","Material 7 Sieve_Wt_475","Material 7 Sieve_Wt_236","Material 7 Sieve_Wt_118","Material 7 Sieve_Wt_060","Material 7 Sieve_Wt_030","Material 7 Sieve_Wt_0150","Material 7 Sieve_Wt_0075","Material 7 Blend_Pct","Material 7 Gsb","<BLANK>","Material 7 Source Name"]
["AggtSample","Material 8 Description","Material 8 Agg Source ID","Material 8 P / Q / MF / Dust","Material 8 Sieve_Wt_25","Material 8 Sieve_Wt_19","Material 8 Sieve_Wt_125","Material 8 Sieve_Wt_95","Material 8 Sieve_Wt_475","Material 8 Sieve_Wt_236","Material 8 Sieve_Wt_118","Material 8 Sieve_Wt_060","Material 8 Sieve_Wt_030","Material 8 Sieve_Wt_0150","Material 8 Sieve_Wt_0075","Material 8 Blend_Pct","Material 8 Gsb","<BLANK>","Material 8 Source Name"]
["AggtSample","RAM 1 (RAP) Description","<BLANK>","RAM 1 TYPE","RAM 1 Sieve_Wt_25","RAM 1 Sieve_Wt_19","RAM 1 Sieve_Wt_125","RAM 1 Sieve_Wt_95","RAM 1 Sieve_Wt_475","RAM 1 Sieve_Wt_236","RAM 1 Sieve_Wt_118","RAM 1 Sieve_Wt_060","RAM 1 Sieve_Wt_030","RAM 1 Sieve_Wt_0150","RAM 1 Sieve_Wt_0075","RAM 1 Blend_Pct","RAM 1 Gsb","RAM 1 (RAP) % AC","RAM 1 Plant ID"]
["AggtSample","RAM 2 (RAS) Description","<BLANK>","RAM 2 TYPE","RAM 2 Sieve_Wt_25","RAM 2 Sieve_Wt_19","RAM 2 Sieve_Wt_125","RAM 2 Sieve_Wt_95","RAM 2 Sieve_Wt_475","RAM 2 Sieve_Wt_236","RAM 2 Sieve_Wt_118","RAM 2 Sieve_Wt_060","RAM 2 Sieve_Wt_030","RAM 2 Sieve_Wt_0150","RAM 2 Sieve_Wt_0075","RAM 2 Blend_Pct","RAM 2 Gsb","RAM 2 (RAS) % AC","RAM 2 Plant ID"]
["AggtSample","RAM 3 (FRAP) Description","<BLANK>","RAM 3 TYPE","RAM 3 Sieve_Wt_25","RAM 3 Sieve_Wt_19","RAM 3 Sieve_Wt_125","RAM 3 Sieve_Wt_95","RAM 3 Sieve_Wt_475","RAM 3 Sieve_Wt_236","RAM 3 Sieve_Wt_118","RAM 3 Sieve_Wt_060","RAM 3 Sieve_Wt_030","RAM 3 Sieve_Wt_0150","RAM 3 Sieve_Wt_0075","RAM 3 Blend_Pct","RAM 3 Gsb","RAM 3 (FRAP) % AC","RAM 3 Plant ID"]
["Volumetric","Trial 1 Total %AC","Trial 1 %Added AC","Trial 1 Gmm","Trial 1 Gmb","Trial 1 Va","Trial 1 VMA","Trial 1 VFB"]
["Volumetric","Trial 2 Total %AC","Trial 2 %Added AC","Trial 2 Gmm","Trial 2 Gmb","Trial 2 Va","Trial 2 VMA","Trial 2 VFB"]
["Volumetric","Trial 3 Total %AC","Trial 3 %Added AC","Trial 3 Gmm","Trial 3 Gmb","Trial 3 Va","Trial 3 VMA","Trial 3 VFB"]
["Volumetric","Trial 4 Total %AC","Trial 4 %Added AC","Trial 4 Gmm","Trial 4 Gmb","Trial 4 Va","Trial 4 VMA","Trial 4 VFB"]
["Volumeopt3","Opt 3 Va Total %AC","Opt 3 Va %Added AC","Opt 3 Va Gmm","Opt 3 Va Gmb","Opt 3 Va Va","Opt 3 Va VMA","Opt 3 Va VFB"]
["ACSource","Alt AC Source 1","Alt AC Source 1 AC Type","Alt AC Source 1 Gb","Alt AC Source 1 TSR","Alt AC Source 1 # Gyr","Alt AC Source 1 Additive Amount","Alt AC Source 1 Additive Amount"]
["ACSource","Alt AC Source 2","Alt AC Source 2 AC Type","Alt AC Source 2 Gb","Alt AC Source 2 TSR","Alt AC Source 2 # Gyr","Alt AC Source 2 Additive Amount","Alt AC Source 2 Additive Amount"]
["ACSource","Alt AC Source 3","Alt AC Source 3 AC Type","Alt AC Source 3 Gb","Alt AC Source 3 TSR","Alt AC Source 3 # Gyr","Alt AC Source 3 Additive Amount","Alt AC Source 3 Additive Amount"]
["ACSource","Alt AC Source 4","Alt AC Source 4 AC Type","Alt AC Source 4 Gb","Alt AC Source 4 TSR","Alt AC Source 4 # Gyr","Alt AC Source 4 Additive Amount","Alt AC Source 4 Additive Amount","    ","   ",null,"  "," ",null,"   ","  ",null,"  "]
["ACSource","Alt AC Source 5","Alt AC Source 5 AC Type","Alt AC Source 5 Gb","Alt AC Source 5 TSR","Alt AC Source 5 # Gyr","Alt AC Source 5 Additive Amount","Alt AC Source 5 Additive Amount"]

{"sheet":"Agg_Properties","index":6,"n_rows":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":true,"merged":[[27,14,28,14],[27,1,28,1],[28,3,28,13],[14,1,21,1],[22,1,25,1]]}
[]
[null,null,null,{"$f":"'Mix Design Data Entry'!D18","v":"Agg 1"},{"$f":"'Mix Design Data Entry'!E18","v":"Agg 2"},{"$f":"'Mix Design Data Entry'!F18","v":"Agg 3"},{"$f":"'Mix Design Data Entry'!G18","v":"Agg 4"},{"$f":"'Mix Design Data Entry'!H18","v":"Agg 5"},{"$f":"'Mix Design Data Entry'!I18","v":"Agg 6"},{"$f":"'Mix Design Data Entry'!J18","v":"Agg 7"},{"$f":"'Mix Design Data Entry'!K18","v":"Agg 8"},{"$f":"'Mix Design Data Entry'!L18","v":"RAM 1\n(RAP)"},{"$f":"'Mix Design Data Entry'!M18","v":"RAM 2\n(RAS)"},{"$f":"'Mix Design Data Entry'!N18","v":"RAM 3\n(FRAP)"}]
[null,null,"Material Description:",{"$f":"IF('Mix Design Data Entry'!D20=\"\",\"\",'Mix Design Data Entry'!D20)","v":""},{"$f":"IF('Mix Design Data Entry'!E20=\"\",\"\",'Mix Design Data Entry'!E20)","v":""},{"$f":"IF('Mix Design Data Entry'!F20=\"\",\"\",'Mix Design Data Entry'!F20)","v":""},{"$f":"IF('Mix Design Data Entry'!G20=\"\",\"\",'Mix Design Data Entry'!G20)","v":""},{"$f":"IF('Mix Design Data Entry'!H20=\"\",\"\",'Mix Design Data Entry'!H20)","v":""},{"$f":"IF('Mix Design Data Entry'!I20=\"\",\"\",'Mix Design Data Entry'!I20)","v":""},{"$f":"IF('Mix Design Data Entry'!J20=\"\",\"\",'Mix Design Data Entry'!J20)","v":""},{"$f":"IF('Mix Design Data Entry'!K20=\"\",\"\",'Mix Design Data Entry'!K20)","v":""},{"$f":"IF('Mix Design Data Entry'!L20=\"\",\"\",'Mix Design Data Entry'!L20)","v":""},{"$f":"IF('Mix Design Data Entry'!M20=\"\",\"\",'Mix Design Data Entry'!M20)","v":""},{"$f":"IF('Mix Design Data Entry'!N20=\"\",\"\",'Mix Design Data Entry'!N20)","v":""}]
[null,null,"WisDOT Agg Source ID:\n(225-xxxx-xxxx)",{"$f":"IF('Mix Design Data Entry'!D23=\"\",\"\",'Mix Design Data Entry'!D23)","v":""},{"$f":"IF('Mix Design Data Entry'!E23=\"\",\"\",'Mix Design Data Entry'!E23)","v":""},{"$f":"IF('Mix Design Data Entry'!F23=\"\",\"\",'Mix Design Data Entry'!F23)","v":""},{"$f":"IF('Mix Design Data Entry'!G23=\"\",\"\",'Mix Design Data Entry'!G23)","v":""},{"$f":"IF('Mix Design Data Entry'!H23=\"\",\"\",'Mix Design Data Entry'!H23)","v":""},{"$f":"IF('Mix Design Data Entry'!I23=\"\",\"\",'Mix Design Data Entry'!I23)","v":""},{"$f":"IF('Mix Design Data Entry'!J23=\"\",\"\",'Mix Design Data Entry'!J23)","v":""},{"$f":"IF('Mix Design Data Entry'!K23=\"\",\"\",'Mix Design Data Entry'!K23)","v":""},{"$f":"IF('Mix Design Data Entry'!L23=\"\",\"\",'Mix Design Data Entry'!L23)","v":""},{"$f":"IF('Mix Design Data Entry'!M23=\"\",\"\",'Mix Design Data Entry'!M23)","v":""},{"$f":"IF('Mix Design Data Entry'!N23=\"\",\"\",'Mix Design Data Entry'!N23)","v":""}]
[null,null,"Blend Percentages (0.1%):",{"$f":"IF('Mix Design Data Entry'!D19=\"\",0,'Mix Design Data Entry'!D19)","v":0},{"$f":"IF('Mix Design Data Entry'!E19=\"\",0,'Mix Design Data Entry'!E19)","v":0},{"$f":"IF('Mix Design Data Entry'!F19=\"\",0,'Mix Design Data Entry'!F19)","v":0},{"$f":"IF('Mix Design Data Entry'!G19=\"\",0,'Mix Design Data Entry'!G19)","v":0},{"$f":"IF('Mix Design Data Entry'!H19=\"\",0,'Mix Design Data Entry'!H19)","v":0},{"$f":"IF('Mix Design Data Entry'!I19=\"\",0,'Mix Design Data Entry'!I19)","v":0},{"$f":"IF('Mix Design Data Entry'!J19=\"\",0,'Mix Design Data Entry'!J19)","v":0},{"$f":"IF('Mix Design Data Entry'!K19=\"\",0,'Mix Design Data Entry'!K19)","v":0},{"$f":"IF('Mix Design Data Entry'!L19=\"\",0,'Mix Design Data Entry'!L19)","v":0},{"$f":"IF('Mix Design Data Entry'!M19=\"\",0,'Mix Design Data Entry'!M19)","v":0},{"$f":"IF('Mix Design Data Entry'!N19=\"\",0,'Mix Design Data Entry'!N19)","v":0}]
[null,null,"Percent Passing #4 (4.75-mm):",{"$f":"IF('Mix Design Data Entry'!D31=\"\",0,'Mix Design Data Entry'!D31)","v":0},{"$f":"IF('Mix Design Data Entry'!E31=\"\",0,'Mix Design Data Entry'!E31)","v":0},{"$f":"IF('Mix Design Data Entry'!F31=\"\",0,'Mix Design Data Entry'!F31)","v":0},{"$f":"IF('Mix Design Data Entry'!G31=\"\",0,'Mix Design Data Entry'!G31)","v":0},{"$f":"IF('Mix Design Data Entry'!H31=\"\",0,'Mix Design Data Entry'!H31)","v":0},{"$f":"IF('Mix Design Data Entry'!I31=\"\",0,'Mix Design Data Entry'!I31)","v":0},{"$f":"IF('Mix Design Data Entry'!J31=\"\",0,'Mix Design Data Entry'!J31)","v":0},{"$f":"IF('Mix Design Data Entry'!K31=\"\",0,'Mix Design Data Entry'!K31)","v":0},{"$f":"IF('Mix Design Data Entry'!L31=\"\",0,'Mix Design Data Entry'!L31)","v":0},{"$f":"IF('Mix Design Data Entry'!M31=\"\",0,'Mix Design Data Entry'!M31)","v":0},{"$f":"IF('Mix Design Data Entry'!N31=\"\",0,'Mix Design Data Entry'!N31)","v":0}]
[null,null,"CAA 1F:",{"$f":"IF('Mix Design Data Entry'!D40=\"\",0,'Mix Design Data Entry'!D40)","v":0},{"$f":"IF('Mix Design Data Entry'!E40=\"\",0,'Mix Design Data Entry'!E40)","v":0},{"$f":"IF('Mix Design Data Entry'!F40=\"\",0,'Mix Design Data Entry'!F40)","v":0},{"$f":"IF('Mix Design Data Entry'!G40=\"\",0,'Mix Design Data Entry'!G40)","v":0},{"$f":"IF('Mix Design Data Entry'!H40=\"\",0,'Mix Design Data Entry'!H40)","v":0},{"$f":"IF('Mix Design Data Entry'!I40=\"\",0,'Mix Design Data Entry'!I40)","v":0},{"$f":"IF('Mix Design Data Entry'!J40=\"\",0,'Mix Design Data Entry'!J40)","v":0},{"$f":"IF('Mix Design Data Entry'!K40=\"\",0,'Mix Design Data Entry'!K40)","v":0},{"$f":"IF('Mix Design Data Entry'!L40=\"\",0,'Mix Design Data Entry'!L40)","v":0},{"$f":"IF('Mix Design Data Entry'!M40=\"\",0,'Mix Design Data Entry'!M40)","v":0},{"$f":"IF('Mix Design Data Entry'!N40=\"\",0,'Mix Design Data Entry'!N40)","v":0}]
[null,null,"CAA 2F:",{"$f":"IF('Mix Design Data Entry'!D41=\"\",0,'Mix Design Data Entry'!D41)","v":0},{"$f":"IF('Mix Design Data Entry'!E41=\"\",0,'Mix Design Data Entry'!E41)","v":0},{"$f":"IF('Mix Design Data Entry'!F41=\"\",0,'Mix Design Data Entry'!F41)","v":0},{"$f":"IF('Mix Design Data Entry'!G41=\"\",0,'Mix Design Data Entry'!G41)","v":0},{"$f":"IF('Mix Design Data Entry'!H41=\"\",0,'Mix Design Data Entry'!H41)","v":0},{"$f":"IF('Mix Design Data Entry'!I41=\"\",0,'Mix Design Data Entry'!I41)","v":0},{"$f":"IF('Mix Design Data Entry'!J41=\"\",0,'Mix Design Data Entry'!J41)","v":0},{"$f":"IF('Mix Design Data Entry'!K41=\"\",0,'Mix Design Data Entry'!K41)","v":0},{"$f":"IF('Mix Design Data Entry'!L41=\"\",0,'Mix Design Data Entry'!L41)","v":0},{"$f":"IF('Mix Design Data Entry'!M41=\"\",0,'Mix Design Data Entry'!M41)","v":0},{"$f":"IF('Mix Design Data Entry'!N41=\"\",0,'Mix Design Data Entry'!N41)","v":0}]
[null,null,"FAA:",{"$f":"IF('Mix Design Data Entry'!D42=\"\",0,'Mix Design Data Entry'!D42)","v":0},{"$f":"IF('Mix Design Data Entry'!E42=\"\",0,'Mix Design Data Entry'!E42)","v":0},{"$f":"IF('Mix Design Data Entry'!F42=\"\",0,'Mix Design Data Entry'!F42)","v":0},{"$f":"IF('Mix Design Data Entry'!G42=\"\",0,'Mix Design Data Entry'!G42)","v":0},{"$f":"IF('Mix Design Data Entry'!H42=\"\",0,'Mix Design Data Entry'!H42)","v":0},{"$f":"IF('Mix Design Data Entry'!I42=\"\",0,'Mix Design Data Entry'!I42)","v":0},{"$f":"IF('Mix Design Data Entry'!J42=\"\",0,'Mix Design Data Entry'!J42)","v":0},{"$f":"IF('Mix Design Data Entry'!K42=\"\",0,'Mix Design Data Entry'!K42)","v":0},{"$f":"IF('Mix Design Data Entry'!L42=\"\",0,'Mix Design Data Entry'!L42)","v":0},{"$f":"IF('Mix Design Data Entry'!M42=\"\",0,'Mix Design Data Entry'!M42)","v":0},{"$f":"IF('Mix Design Data Entry'!N42=\"\",0,'Mix Design Data Entry'!N42)","v":0}]
[null,null,"Moisture Abs:",{"$f":"IF('Mix Design Data Entry'!D43=\"\",0,'Mix Design Data Entry'!D43)","v":0},{"$f":"IF('Mix Design Data Entry'!E43=\"\",0,'Mix Design Data Entry'!E43)","v":0},{"$f":"IF('Mix Design Data Entry'!F43=\"\",0,'Mix Design Data Entry'!F43)","v":0},{"$f":"IF('Mix Design Data Entry'!G43=\"\",0,'Mix Design Data Entry'!G43)","v":0},{"$f":"IF('Mix Design Data Entry'!H43=\"\",0,'Mix Design Data Entry'!H43)","v":0},{"$f":"IF('Mix Design Data Entry'!I43=\"\",0,'Mix Design Data Entry'!I43)","v":0},{"$f":"IF('Mix Design Data Entry'!J43=\"\",0,'Mix Design Data Entry'!J43)","v":0},{"$f":"IF('Mix Design Data Entry'!K43=\"\",0,'Mix Design Data Entry'!K43)","v":0},{"$f":"IF('Mix Design Data Entry'!L43=\"\",0,'Mix Design Data Entry'!L43)","v":0},{"$f":"IF('Mix Design Data Entry'!M43=\"\",0,'Mix Design Data Entry'!M43)","v":0},{"$f":"IF('Mix Design Data Entry'!N43=\"\",0,'Mix Design Data Entry'!N43)","v":0}]
[null,null,"Thin/Elong:",{"$f":"IF('Mix Design Data Entry'!D44=\"\",0,'Mix Design Data Entry'!D44)","v":0},{"$f":"IF('Mix Design Data Entry'!E44=\"\",0,'Mix Design Data Entry'!E44)","v":0},{"$f":"IF('Mix Design Data Entry'!F44=\"\",0,'Mix Design Data Entry'!F44)","v":0},{"$f":"IF('Mix Design Data Entry'!G44=\"\",0,'Mix Design Data Entry'!G44)","v":0},{"$f":"IF('Mix Design Data Entry'!H44=\"\",0,'Mix Design Data Entry'!H44)","v":0},{"$f":"IF('Mix Design Data Entry'!I44=\"\",0,'Mix Design Data Entry'!I44)","v":0},{"$f":"IF('Mix Design Data Entry'!J44=\"\",0,'Mix Design Data Entry'!J44)","v":0},{"$f":"IF('Mix Design Data Entry'!K44=\"\",0,'Mix Design Data Entry'!K44)","v":0},{"$f":"IF('Mix Design Data Entry'!L44=\"\",0,'Mix Design Data Entry'!L44)","v":0},{"$f":"IF('Mix Design Data Entry'!M44=\"\",0,'Mix Design Data Entry'!M44)","v":0},{"$f":"IF('Mix Design Data Entry'!N44=\"\",0,'Mix Design Data Entry'!N44)","v":0}]
[null,null,"Gsb:",{"$f":"IF('Mix Design Data Entry'!D39=\"\",0,'Mix Design Data Entry'!D39)","v":0},{"$f":"IF('Mix Design Data Entry'!E39=\"\",0,'Mix Design Data Entry'!E39)","v":0},{"$f":"IF('Mix Design Data Entry'!F39=\"\",0,'Mix Design Data Entry'!F39)","v":0},{"$f":"IF('Mix Design Data Entry'!G39=\"\",0,'Mix Design Data Entry'!G39)","v":0},{"$f":"IF('Mix Design Data Entry'!H39=\"\",0,'Mix Design Data Entry'!H39)","v":0},{"$f":"IF('Mix Design Data Entry'!I39=\"\",0,'Mix Design Data Entry'!I39)","v":0},{"$f":"IF('Mix Design Data Entry'!J39=\"\",0,'Mix Design Data Entry'!J39)","v":0},{"$f":"IF('Mix Design Data Entry'!K39=\"\",0,'Mix Design Data Entry'!K39)","v":0},{"$f":"IF('Mix Design Data Entry'!L39=\"\",0,'Mix Design Data Entry'!L39)","v":0},{"$f":"IF('Mix Design Data Entry'!M39=\"\",0,'Mix Design Data Entry'!M39)","v":0},{"$f":"IF('Mix Design Data Entry'!N39=\"\",0,'Mix Design Data Entry'!N39)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum"]
[null,"Coarse Aggregate Angularity","% Retained #4 (4.75-mm):",{"$f":"IF(D7<>0,(100-D6),0)","v":0},{"$f":"IF(E7<>0,(100-E6),0)","v":0},0,0,0,0,0,0,0,0,{"$f":"IF(N7<>0,(100-N6),0)","v":0},{"$f":"SUM(D15:N15)","v":0}]
[null,null,"Blend Component % Retained #4:",{"$f":"D15*(D5/100)","v":0},{"$f":"E15*(E5/100)","v":0},{"$f":"F15*(F5/100)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(D16:N16)","v":0}]
[null,null,"Percentage of Total Blend Retained on #4:",{"$f":"(D16/$O$16)*100","v":{"$error":"#DIV/0!"}},{"$f":"(E16/$O$16)*100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(D17:N17)","v":{"$error":"#DIV/0!"}}]
[null,null,"Blend Component CAA 1F:",{"$f":"IF(D7<>0,D17*(D7/100),0)","v":0},{"$f":"IF(E7<>0,E17*(E7/100),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"% Retained #4 (4.75-mm):",{"$f":"IF(D8<>0,(100-D6),0)","v":0},{"$f":"IF(E8<>0,(100-E6),0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(D19:N19)","v":0}]
[null,null,"Blend Component % Retained #4:",{"$f":"D19*(D5/100)","v":0},{"$f":"E19*(E5/100)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Percentage of Total Blend Retained on #4:",{"$f":"(D20/$O$20)*100","v":{"$error":"#DIV/0!"}},{"$f":"(E20/$O$20)*100","v":{"$error":"#DIV/0!"}},{"$f":"(F20/$O$20)*100","v":{"$error":"#DIV/0!"}},{"$f":"(G20/$O$20)*100","v":{"$error":"#DIV/0!"}},{"$f":"(H20/$O$20)*100","v":{"$error":"#DIV/0!"}},{"$f":"(I20/$O$20)*100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Blend Component CAA 2F:",{"$f":"IF(D8<>0,D21*(D8/100),0)","v":0},{"$f":"IF(E8<>0,E21*(E8/100),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Thin\n&\nElongated","% Retained #4 (4.75-mm):",{"$f":"IF(D11<>0,(100-D6),0)","v":0},{"$f":"IF(E11<>0,(100-E6),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Blend Component % Retained #4:",{"$f":"D23*(D5/100)","v":0},{"$f":"E23*(E5/100)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Percentage of Total Blend Retained on #4:",{"$f":"(D24/$O$24)*100","v":{"$error":"#DIV/0!"}},{"$f":"(E24/$O$24)*100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"(N24/$O$24)*100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,"Blend Component Thin/Elon:",{"$f":"IF(D11<>0,D24*(D11/100),0)","v":0},{"$f":"IF(E11<>0,E24*(E11/100),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Moisture Abs","Component Moisture Absorption (%):",{"$f":"IF(D10<>0,D10*(D5/100),0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Gsb","Component Gsb:",{"$f":"IF(D5>0,(D5/D12),0)","v":0},0,0,0,0,0,0,0,0,0,0,"--"]
[null,null,"Blend Gsb:",{"$f":"100/SUM(D28:N28)","v":{"$error":"#DIV/0!"}}]

{"sheet":"INTERNAL_SYS_VAR","index":7,"n_rows":11,"n_cols":23,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,10,1,16]]}
[]
[null,"Worksheet Version","NMAS","MixType","Allowed Virgin PG Grades","Binder Designation","Allowed Resultant PG Grades","Aggregate Type","RAM Type","Additive Types","Gyratory Compaction",null,null,null,null,null,null,"Trial Binder Data Trial Dropdown","DYNAMIC NMAS LIST","JMF OPTIMUM AC TITLE BLOCK MESSAGES","GYRATORY COMPACTION EFFORT TITLE BLOCK MESSAGES","PERFORMANCE TITLE BLOCK MESSAGES","One Point Verification Type"]
[null,"2.0.1","1 - 37.5 mm","LT","52-22","S","58-28","P","RAP","Warm Mix Additive","Level","LT","MT","HT","SMA","Polymer-Modified HMA Overlay","Interlayer","OPT. @ 4.0% Va",{"$f":"_xlfn.SWITCH('Mix Design Data Entry'!$D$7,0,\"ENTER A MIX TYPE\",$L$3,$C$3:$C$8,$M$3,$C$3:$C$8,$N$3,$C$3:$C$8,$O$3,$C$6:$C$7,$P$3,$C$9,$Q$3,$C$10)","v":"ENTER A MIX TYPE"},"JMF PROPERTIES AT OPTIMUM % ASPHALT CONTENT AT 4.0% AIR VOIDS FOR HMA / 4.5% AIR VOIDS FOR SMA / 2.0% AIR VOIDS FOR INTERLAYER / 1.0% AIR VOIDS FOR POLYMER-MODIFIED HMA OVERLAY","Gyratory Compaction Effort (% Gmm at Optimum AC at Design Va)","Performance (at Optimum AC at Production Va)",1]
[null,"2026-03-02","2 - 25.0 mm","MT","52-28","H","58-34","Q","FRAP","Liquid Anti-Strip","Nini",6,7,8,7,6,"N/A","OPT. @ 4.5% Va",null,"JMF PROPERTIES AT OPTIMUM % ASPHALT CONTENT AT 4.0% AIR VOIDS FOR HMA","Gyratory Compaction Effort (% Gmm at Optimum AC at 4.0% Va)","Performance (at Optimum AC at 3.0% Va)"]
[null,null,"3 - 19.0 mm","HT","52-34","V","64-28","MF","RAS","Cellulose Fibers","Ndes",40,75,100,65,50,50,"OPT. @ 2.0% Va",null,"JMF PROPERTIES AT OPTIMUM % ASPHALT CONTENT AT 4.5% AIR VOIDS FOR SMA","Gyratory Compaction Effort (% Gmm at Optimum AC at 4.5% Va)","Performance (at Optimum AC at 4.5% Va)"]
[null,null,"4 - 12.5 mm","SMA","58-22","E","64-34","Dust",null,"Hydrated Lime Anti-Strip","Nmax",60,115,160,100,75,"N/A","OPT. @ 1.0% Va",null,"JMF PROPERTIES AT OPTIMUM % ASPHALT CONTENT AT 2.0% AIR VOIDS FOR INTERLAYER","Gyratory Compaction Effort (% Gmm at Optimum AC at 2.0% Va)","Performance (at Optimum AC at 2.0% Va)"]
[null,null,"5 - 9.5 mm","Polymer-Modified HMA Overlay","58-28",null,"70-28",null,null,null,null,null,null,null,null,null,null,null,null,"JMF PROPERTIES AT OPTIMUM % ASPHALT CONTENT AT 1.0% AIR VOIDS FOR POLYMER-MODIFIED HMA OVERLAY","Gyratory Compaction Effort (% Gmm at Optimum AC at 1.0% Va)","Performance (at Optimum AC at 1.0% Va)"]
[null,null,"6 - 4.75 mm","Interlayer","58-34",null,"70-34"]
[null,null,"PMA Overlay - 9.5 mm",null,"64-22"]
[null,null,"Interlayer - 4.75 mm",null,"64-28"]
[null,null,null,null,"64-34"]