{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tex-417-A","RX"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":77,"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":"Tex-417-A","index":0,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,0,0,1],[51,1,51,3],[47,6,47,8],[37,1,38,8],[45,2,45,4],[12,7,12,8],[9,7,9,8],[9,3,9,4],[7,7,7,8],[10,7,10,8],[11,3,11,4],[12,3,12,4],[11,7,11,8],[39,1,39,8],[13,3,13,4],[15,3,15,8],[7,3,7,4],[8,3,8,4],[8,7,8,8],[10,3,10,4],[47,1,47,3],[31,1,31,3],[32,1,32,3],[23,6,23,7],[24,6,24,7],[30,6,30,7],[13,7,13,8],[16,7,16,8],[31,6,31,7],[14,3,14,8],[44,2,44,4],[23,1,23,3],[42,2,42,4],[43,2,43,4],[24,1,24,3],[32,6,32,7],[16,3,16,4],[40,1,40,8],[25,1,25,3],[26,1,26,3],[27,1,27,3]]}
["TxDOT Manuals >",null,null,"Tex-417-A"]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,"tx417.xlsm::45575.627222"]
[null,"UNIT WEIGHT,YIELD AND AIR CONTENT OF CONCRETE"]
[null,"Tex-417-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 15:03:12"}]
[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,"Unit Weight",null,null,null,"Relative Yield"]
[]
[null,"Date bucket calibrated:",null,null,null,null,"Volume of concrete:",null,null,{"$f":"IF(Field2=\"1995\",\"m³\",\"yd³\")","v":"yd³"}]
[null,"Mass of bucket:",null,null,null,{"$f":"IF(Field2=\"1995\",\"kg\",\"lbs\")","v":"lbs"},"Relative yield:",null,{"$f":"IF(ISERROR(Yield/Volume_of_Concrete),\"\",Yield/Volume_of_Concrete)","v":""}]
[null,"Volume of bucket:",null,null,null,{"$f":"IF(Field2=\"1995\",\"m³\",\"ft³\")","v":"ft³"}]
[null,"Mass of bucket (fill with) concrete:",null,null,null,{"$f":"IF(Field2=\"1995\",\"kg\",\"lbs\")","v":"lbs"}]
[null,"Density (Unit weight ) of concrete:",null,null,{"$f":"IF(ISERROR((E27-E25)/E26),\"\",(E27-E25)/E26)","v":""},{"$f":"IF(Field2=\"1995\",\"kg/m³\",\"lb/ft³\")","v":"lb/ft³"}]
[]
[null,"Yield",null,null,null,"Air Content"]
[null,null,null,null,null,null,"Total absolute volume:",null,null,{"$f":"IF(Field2=\"1995\",\"m³\",\"ft³\")","v":"ft³"}]
[null,"Total mass of all materials batched:",null,null,null,{"$f":"IF(Field2=\"1995\",\"kg\",\"lbs\")","v":"lbs"},"Theoretical density:",null,{"$f":"IF(ISERROR(E32/I31),\"\",E32/I31)","v":""},{"$f":"IF(Field2=\"1995\",\"kg/m³\",\"lb/ft³\")","v":"lb/ft³"}]
[null,"Yield:",null,null,{"$f":"IF(Field2=\"1995\",IF(ISERROR(E32/E28),\"\",E32/E28),IF(ISERROR(E32/(E28*27)),\"\",E32/(E28*27)))","v":""},{"$f":"IF(Field2=\"1995\",\"m³\",\"yd³\")","v":"yd³"},"Air concent:",null,{"$f":"IF(ISERROR((Theoretical_density-Density__unit_weight__of_concrete)/Theoretical_density)*100,\"\",((Theoretical_density-Density__unit_weight__of_concrete)/Theoretical_density)*100)","v":""},"%"]
[]
[]
[]
[null,"Remarks:",{"$f":"NOW()","v":"2024-10-10T15:03:12.500"}]
[]
[]
[]
[]
[]
[null,"Sample Method:","Sampled By:",null,null,"Sampled Date:"]
[null,"TX407"," ",null,null," "]
[null,"Test Method:","Tested By:",null,null,"Tested Date:"]
[null,"TX417"," ",null,null," "]
[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":"RX","index":1,"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('Tex-417-A'!$B$38=\"\",\"\",'Tex-417-A'!$B$38)","v":""},{"$f":"'Tex-417-A'!$B$37","v":"Remarks:"}]
[2,{"$f":"IF('Tex-417-A'!$D$19=\"\",\"\",'Tex-417-A'!$D$19)","v":""},{"$f":"IF('Tex-417-A'!$C$19=\"\",\"\",'Tex-417-A'!$C$19)","v":"COURSE\\LIFT:"}]
[3,{"$f":"IF('Tex-417-A'!$C$46=\"\",\"\",'Tex-417-A'!$C$46)","v":" "},"Tested By ",{"$f":"IF('Tex-417-A'!$B$46=\"\",\"\",'Tex-417-A'!$B$46)","v":"TX417"}]
[4,{"$f":"IF('Tex-417-A'!$F$46=\"\",\"\",'Tex-417-A'!$F$46)","v":" "},"Tested Date ",{"$f":"IF('Tex-417-A'!$B$46=\"\",\"\",'Tex-417-A'!$B$46)","v":"TX417"}]
[5,{"$f":"IF('Tex-417-A'!$E$24=\"\",\"\",'Tex-417-A'!$E$24)","v":""},{"$f":"IF('Tex-417-A'!$B$22=\"\",\"\",'Tex-417-A'!$B$22)","v":"Unit Weight"},{"$f":"IF('Tex-417-A'!$B$24=\"\",\"\",'Tex-417-A'!$B$24)","v":"Date bucket calibrated:"}]
[6,{"$f":"IF('Tex-417-A'!$E$25=\"\",\"\",'Tex-417-A'!$E$25)","v":""},{"$f":"IF('Tex-417-A'!$B$22=\"\",\"\",'Tex-417-A'!$B$22)","v":"Unit Weight"},{"$f":"IF('Tex-417-A'!$B$25=\"\",\"\",'Tex-417-A'!$B$25)","v":"Mass of bucket:"}]
[7,{"$f":"IF('Tex-417-A'!$E$26=\"\",\"\",'Tex-417-A'!$E$26)","v":""},{"$f":"IF('Tex-417-A'!$B$22=\"\",\"\",'Tex-417-A'!$B$22)","v":"Unit Weight"},{"$f":"IF('Tex-417-A'!$B$26=\"\",\"\",'Tex-417-A'!$B$26)","v":"Volume of bucket:"}]
[8,{"$f":"IF('Tex-417-A'!$E$27=\"\",\"\",'Tex-417-A'!$E$27)","v":""},{"$f":"IF('Tex-417-A'!$B$22=\"\",\"\",'Tex-417-A'!$B$22)","v":"Unit Weight"},{"$f":"IF('Tex-417-A'!$B$27=\"\",\"\",'Tex-417-A'!$B$27)","v":"Mass of bucket (fill with) concrete:"}]
[9,{"$f":"IF('Tex-417-A'!$E$28=\"\",\"\",'Tex-417-A'!$E$28)","v":""},{"$f":"IF('Tex-417-A'!$B$22=\"\",\"\",'Tex-417-A'!$B$22)","v":"Unit Weight"},{"$f":"IF('Tex-417-A'!$B$28=\"\",\"\",'Tex-417-A'!$B$28)","v":"Density (Unit weight ) of concrete:"}]
[10,{"$f":"IF('Tex-417-A'!$I$24=\"\",\"\",'Tex-417-A'!$I$24)","v":""},{"$f":"IF('Tex-417-A'!$F$22=\"\",\"\",'Tex-417-A'!$F$22)","v":"Relative Yield"},{"$f":"IF('Tex-417-A'!$G$24=\"\",\"\",'Tex-417-A'!$G$24)","v":"Volume of concrete:"}]
[11,{"$f":"IF('Tex-417-A'!$I$25=\"\",\"\",'Tex-417-A'!$I$25)","v":""},{"$f":"IF('Tex-417-A'!$F$22=\"\",\"\",'Tex-417-A'!$F$22)","v":"Relative Yield"},{"$f":"IF('Tex-417-A'!$G$25=\"\",\"\",'Tex-417-A'!$G$25)","v":"Relative yield:"}]
[12,{"$f":"IF('Tex-417-A'!$E$32=\"\",\"\",'Tex-417-A'!$E$32)","v":""},{"$f":"IF('Tex-417-A'!$B$30=\"\",\"\",'Tex-417-A'!$B$30)","v":"Yield"},{"$f":"IF('Tex-417-A'!$B$32=\"\",\"\",'Tex-417-A'!$B$32)","v":"Total mass of all materials batched:"}]
[13,{"$f":"IF('Tex-417-A'!$E$33=\"\",\"\",'Tex-417-A'!$E$33)","v":""},{"$f":"IF('Tex-417-A'!$B$30=\"\",\"\",'Tex-417-A'!$B$30)","v":"Yield"},{"$f":"IF('Tex-417-A'!$B$33=\"\",\"\",'Tex-417-A'!$B$33)","v":"Yield:"}]
[14,{"$f":"IF('Tex-417-A'!$I$31=\"\",\"\",'Tex-417-A'!$I$31)","v":""},{"$f":"IF('Tex-417-A'!$F$30=\"\",\"\",'Tex-417-A'!$F$30)","v":"Air Content"},{"$f":"IF('Tex-417-A'!$G$31=\"\",\"\",'Tex-417-A'!$G$31)","v":"Total absolute volume:"}]
[15,{"$f":"IF('Tex-417-A'!$I$32=\"\",\"\",'Tex-417-A'!$I$32)","v":""},{"$f":"IF('Tex-417-A'!$F$30=\"\",\"\",'Tex-417-A'!$F$30)","v":"Air Content"},{"$f":"IF('Tex-417-A'!$G$32=\"\",\"\",'Tex-417-A'!$G$32)","v":"Theoretical density:"}]
[16,{"$f":"IF('Tex-417-A'!$I$33=\"\",\"\",'Tex-417-A'!$I$33)","v":""},{"$f":"IF('Tex-417-A'!$F$30=\"\",\"\",'Tex-417-A'!$F$30)","v":"Air Content"},{"$f":"IF('Tex-417-A'!$G$33=\"\",\"\",'Tex-417-A'!$G$33)","v":"Air concent:"}]
[17,{"$f":"IF('Tex-417-A'!$C$44=\"\",\"\",'Tex-417-A'!$C$44)","v":" "},"Sampled By ",{"$f":"IF('Tex-417-A'!$B$44=\"\",\"\",'Tex-417-A'!$B$44)","v":"TX407"}]
[18,{"$f":"IF('Tex-417-A'!$F$44=\"\",\"\",'Tex-417-A'!$F$44)","v":" "},"Sampled Date ",{"$f":"IF('Tex-417-A'!$B$44=\"\",\"\",'Tex-417-A'!$B$44)","v":"TX407"}]