{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Tx4Fresh","Revisions","Correction Factor","RX"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":82,"comments":1,"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":"Tx4Fresh","index":0,"n_rows":55,"n_cols":11,"rows_kept":55,"cut":false,"hidden":false,"merged":[[13,7,13,8],[16,7,16,8],[14,3,14,8],[25,4,25,5],[27,2,27,4],[21,2,21,3],[20,2,20,3],[21,6,21,7],[22,6,22,7],[13,3,13,4],[15,3,15,8],[22,2,22,3],[16,3,16,4],[20,6,20,7],[0,0,0,1],[12,7,12,8],[11,3,11,4],[12,3,12,4],[11,7,11,8],[9,3,9,4],[8,3,8,4],[10,3,10,4],[7,7,7,8],[10,7,10,8],[7,3,7,4],[9,7,9,8],[8,7,8,8],[55,1,55,3],[51,6,51,8],[42,2,42,4],[46,2,46,4],[48,2,48,4],[51,1,51,3],[44,2,44,4],[41,2,41,4],[34,1,35,8],[37,1,37,8],[36,1,36,8],[23,6,23,7],[28,2,28,4],[23,2,23,3],[26,4,26,5],[29,2,29,4],[30,2,30,4],[39,2,39,4],[40,2,40,4]]}
["TxDOT Manuals >",null,null,"Tex-414-A","Tex-415-A","Tex-416-A","Tex-422-A"]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,"tx4fresh.xlsm::45575.387269"]
[null,"HYDRAULIC CEMENT CONCRETE REPORT"]
[null,"Tex-414,15,16, 22-A"]
[null,null,null,null,null,null,null,null,{"$f":"\"File Version: \" & TEXT(MID(sn,SEARCH(\"::\",sn,1)+2,20),\"mm/dd/yy hh:mm:ss\")","v":"File Version: 10/10/24 09:17:40"}]
[null,null,"SAMPLE ID:",null,null,null,"SAMPLED DATE:"]
[null,null,"TEST NUMBER:",null,null,null,"LETTING DATE:"]
[null,null,"SAMPLE STATUS:",null,null,null,"CONTROLLING CSJ:"]
[null,null,"COUNTY:",null,null,null,"SPEC YEAR:"]
[null,null,"SAMPLED BY:",null,null,null,"SPEC ITEM:"]
[null,null,"SAMPLE LOCATION:",null,null,null,"SPECIAL PROVISION:"]
[null,null,"MATERIAL CODE:",null,null,null,"GRADE:"]
[null,null,"MATERIAL NAME:"]
[null,null,"PRODUCER:"]
[null,null,"AREA ENGINEER:",null,null,null,"PROJECT MANAGER:"]
[]
[null,null,"COURSE\\LIFT:",null,"STATION:",null,null,"DIST. FROM CL:"]
[]
[null,null,"SLUMP",null,null,null,"TEMPERATURE"]
[null,null,"Tex-415-A (ASM C 143)",null,null,null,"Tex-422-A (ASTM C 1064)"]
[null,null,{"$f":"\"Slump \" & IF(SpecYear=\"\",\"\",IF(SpecYear=\"1995\",\"(millimeters)\",\"(inches)\"))","v":"Slump "},null,null,null,{"$f":"\"Temperature \" & IF(SpecYear=\"\",\"\",IF(SpecYear=\"1995\",\"(°C)\",\"(°F)\"))","v":"Temperature "}]
[]
[]
[null,null,null,null,"AIR CONTENT"]
[null,null,null,"Test Method:"]
[null,null,{"$f":"IF(AirMethod=\"Tex 414-A (ASTM C 173)\",\"Water Level Reading, %:\",\"Uncorrected Air Content, %:\")","v":"Uncorrected Air Content, %:"}]
[null,null,{"$f":"IF(AirMethod=\"Tex 414-A (ASTM C 173)\",IF(SpecYear>=\"2004\",\"*Calibrated Cups of Water, Cups:\",\"Cups of Alcohol, Cups:\"),\"Aggr. Correction Factor, %:\")","v":"Aggr. Correction Factor, %:"}]
[null,null,{"$f":"IF(AirMethod=\"Tex 414-A (ASTM C 173)\",\"Amount of Isopropyl Alcohol, Pints:\")","v":false}]
[null,null,{"$f":"IF(AirMethod=\"Tex 414-A (ASTM C 173)\",\"Air Content, %\",\"Corrected Air Content, %\")","v":"Corrected Air Content, %"},null,null,{"$f":"IF(AND(Field10=\"\",Field11=\"\",Field12=\"\"),\"\",IF(ISERROR(IF(AirMethod=\"Tex 414-A (ASTM C 173)\",IF(SpecYear>=\"2004\",ROUND(((F28+F29-VLOOKUP(ROUND(F30,0),ctable,4))/25),2)*25,ROUND(F29+F28,2)),ROUND(F28-F29,1))),\"\",IF(AirMethod=\"Tex 414-A (ASTM C 173)\",IF(SpecYear>=\"2004\",ROUND(((F28+F29-VLOOKUP(ROUND(F30,0),ctable,4))/25),2)*25,ROUND(F29+F28,2)),ROUND(F28-F29,1))))","v":""}]
[null,null,{"$f":"IF(AND(AirMethod=\"Tex 414-A (ASTM C 173)\",SpecYear>=\"2004\"),\"* Only necessary if the air content is greater than the 9% range of the meter.\",\"\")","v":""}]
[]
[null,"Remarks:",{"$f":"NOW()","v":"2024-10-10T09:17:40.590"}]
[]
[]
[]
[]
[]
[null,"Sample Method:","Sampled By:",null,null,"Sampled Date:"]
[null,"TX407"]
[null,"Test Method:","Tested By:",null,null,"Tested Date:"]
[null,"TX414"]
[]
[null,"TX415"]
[null,null,null,null,null,"12/"]
[null,"TX416"]
[]
[null,"TX422"]
[]
[null,"Test Stamp Code:",null,null,"Omit Test:","Completed Date:","Reviewed By:"]
[]
[null,"Locked By:","TxDOT:","District:","Area:"]
[]
[null,"Authorized By:",null,null,"Authorized Date:"]

{"sheet":"Revisions","index":1,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Date","Changes","By","Comments"]
["2009-10-12","- updated correction factor table\n- updated formula in F31 to round inputed alcohol amount to whole number to look up in ctable","Jennifer Moore","required due to changes in ASTM C 173"]
["2009-11-06","field 12 fixed validation","shd"]

{"sheet":"Correction Factor","index":2,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":true,"merged":[[0,0,0,2],[0,3,1,3]]}
["70% Isopropyl Alcohol Used",null,null,"Correction Factor"]
["Pints","Ounces","Liters"]
[1,16,0.5,0]
[2,32,0.9,0]
[3,48,1.4,0.25]
[4,64,1.9,0.5]
[5,80,2.4,0.75]

{"sheet":"RX","index":3,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[18]
["Fld_nbr","Value","Desc_1","Desc_2","Desc_3","Desc_4","Desc_5","Desc_6","Desc_7"]
[1,{"$f":"IF(Tx4Fresh!$B$35=\"\",\"\",Tx4Fresh!$B$35)","v":""},{"$f":"Tx4Fresh!$B$34","v":"Remarks:"}]
[2,{"$f":"IF(Tx4Fresh!$D$19=\"\",\"\",Tx4Fresh!$D$19)","v":""},{"$f":"IF(Tx4Fresh!$C$19=\"\",\"\",Tx4Fresh!$C$19)","v":"COURSE\\LIFT:"}]
[3,{"$f":"IF(Tx4Fresh!$C$43=\"\",\"\",Tx4Fresh!$C$43)","v":""},"Tested By",{"$f":"IF(Tx4Fresh!$B$43=\"\",\"\",Tx4Fresh!$B$43)","v":"TX414"}]
[4,{"$f":"IF(Tx4Fresh!$F$43=\"\",\"\",Tx4Fresh!$F$43)","v":""},"Tested Date",{"$f":"IF(Tx4Fresh!$B$43=\"\",\"\",Tx4Fresh!$B$43)","v":"TX414"}]
[5,{"$f":"IF(Tx4Fresh!$C$45=\"\",\"\",Tx4Fresh!$C$45)","v":""},"Tested By",{"$f":"IF(Tx4Fresh!$B$45=\"\",\"\",Tx4Fresh!$B$45)","v":"TX415"}]
[6,{"$f":"IF(Tx4Fresh!$F$45=\"\",\"\",Tx4Fresh!$F$45)","v":""},"Tested Date",{"$f":"IF(Tx4Fresh!$B$45=\"\",\"\",Tx4Fresh!$B$45)","v":"TX415"}]
[7,{"$f":"IF(Tx4Fresh!$C$47=\"\",\"\",Tx4Fresh!$C$47)","v":""},"Tested By",{"$f":"IF(Tx4Fresh!$B$47=\"\",\"\",Tx4Fresh!$B$47)","v":"TX416"}]
[8,{"$f":"IF(Tx4Fresh!$F$47=\"\",\"\",Tx4Fresh!$F$47)","v":""},"Tested Date",{"$f":"IF(Tx4Fresh!$B$47=\"\",\"\",Tx4Fresh!$B$47)","v":"TX416"}]
[9,{"$f":"IF(Tx4Fresh!$C$49=\"\",\"\",Tx4Fresh!$C$49)","v":""},"Tested By",{"$f":"IF(Tx4Fresh!$B$49=\"\",\"\",Tx4Fresh!$B$49)","v":"TX422"}]
[10,{"$f":"IF(Tx4Fresh!$F$49=\"\",\"\",Tx4Fresh!$F$49)","v":""},"Tested Date",{"$f":"IF(Tx4Fresh!$B$49=\"\",\"\",Tx4Fresh!$B$49)","v":"TX422"}]
[11,{"$f":"IF(Tx4Fresh!$C$24=\"\",\"\",Tx4Fresh!$C$24)","v":""},{"$f":"IF(Tx4Fresh!$C$22=\"\",\"\",Tx4Fresh!$C$22)","v":"Tex-415-A (ASM C 143)"},{"$f":"IF(Tx4Fresh!$C$23=\"\",\"\",Tx4Fresh!$C$23)","v":"Slump "}]
[12,{"$f":"IF(Tx4Fresh!$G$24=\"\",\"\",Tx4Fresh!$G$24)","v":""},{"$f":"IF(Tx4Fresh!$G$22=\"\",\"\",Tx4Fresh!$G$22)","v":"Tex-422-A (ASTM C 1064)"},{"$f":"IF(Tx4Fresh!$G$23=\"\",\"\",Tx4Fresh!$G$23)","v":"Temperature "}]
[13,{"$f":"IF(Tx4Fresh!$F$28=\"\",\"\",Tx4Fresh!$F$28)","v":""},{"$f":"IF(Tx4Fresh!$E$27=\"\",\"\",Tx4Fresh!$E$27)","v":""},{"$f":"IF(Tx4Fresh!$C$28=\"\",\"\",Tx4Fresh!$C$28)","v":"Uncorrected Air Content, %:"}]
[14,{"$f":"IF(Tx4Fresh!$F$29=\"\",\"\",Tx4Fresh!$F$29)","v":""},{"$f":"IF(Tx4Fresh!$E$27=\"\",\"\",Tx4Fresh!$E$27)","v":""},{"$f":"IF(Tx4Fresh!$C$29=\"\",\"\",Tx4Fresh!$C$29)","v":"Aggr. Correction Factor, %:"}]
[15,{"$f":"IF(Tx4Fresh!$F$30=\"\",\"\",Tx4Fresh!$F$30)","v":""},{"$f":"IF(Tx4Fresh!$E$27=\"\",\"\",Tx4Fresh!$E$27)","v":""},{"$f":"IF(Tx4Fresh!$C$30=\"\",\"\",Tx4Fresh!$C$30)","v":false}]
[16,{"$f":"IF(Tx4Fresh!$F$31=\"\",\"\",Tx4Fresh!$F$31)","v":""},{"$f":"IF(Tx4Fresh!$E$27=\"\",\"\",Tx4Fresh!$E$27)","v":""},{"$f":"IF(Tx4Fresh!$C$31=\"\",\"\",Tx4Fresh!$C$31)","v":"Corrected Air Content, %"}]
[17,{"$f":"IF(Tx4Fresh!$C$41=\"\",\"\",Tx4Fresh!$C$41)","v":""},"Sampled By",{"$f":"IF(Tx4Fresh!$B$41=\"\",\"\",Tx4Fresh!$B$41)","v":"TX407"}]
[18,{"$f":"IF(Tx4Fresh!$F$41=\"\",\"\",Tx4Fresh!$F$41)","v":""},"Sampled Date",{"$f":"IF(Tx4Fresh!$B$41=\"\",\"\",Tx4Fresh!$B$41)","v":"TX407"}]