{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Atterberg","RX","Three Point Method Graph","Calculations"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":135,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"Three Point Method Graph","index":2,"reason":"not_a_worksheet"}],"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":"Atterberg","index":0,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[45,3,45,5],[21,3,22,3],[21,4,22,4],[32,4,33,4],[32,6,33,6],[32,7,33,7],[7,7,7,8],[8,3,8,4],[11,7,11,8],[11,3,11,4],[10,7,10,8],[8,7,8,8],[10,3,10,4],[9,7,9,8],[9,3,9,4],[0,0,0,1],[56,2,56,4],[58,2,58,4],[52,1,52,8],[49,1,50,8],[32,5,33,5],[32,2,33,2],[32,3,33,3],[12,3,12,4],[13,3,13,4],[54,2,54,4],[41,2,41,5],[53,2,53,4],[13,7,13,8],[21,7,22,7],[7,3,7,4],[65,1,65,3],[65,6,65,8],[69,1,69,3],[63,2,63,4],[12,7,12,8],[14,3,14,8],[61,2,61,4],[59,2,59,4],[21,8,22,8],[15,3,15,8],[16,3,16,4],[16,7,16,8],[51,1,51,8],[21,2,22,2],[21,5,22,5],[21,6,22,6]]}
["TxDOT Manuals >",null,null,"Tex-104-E","Tex-105-E","Tex-106-E"]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,61]
[null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,"tx104-6.xlsm::45448.631701"]
[null,"LIQUID LIMIT, PLASTIC LIMIT, AND PLASTICITY INDEX"]
[null,"Tex-104-E, Tex-105-E, Tex-106-E"]
[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: 06/05/24 15:09:39"}]
[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,"Liquid Limit - Tex-104-E"]
[null,null,"Dish No.","Mass of Wet Sample + Tare (g)","Mass of Dry Sample + Tare (g)","Tare Mass (g)","Moisture Content (%)","Number of Blows","Liquid Limit (%)"]
[]
[null,1,null,null,null,null,{"$f":"IF($F24=\"\",\"\",(($D24-$E24)/($E24-$F24))*100)","v":""},null,{"$f":"IF($H24=\"\",\"\",$G24*($H24/25)^0.121)","v":""}]
[null,2,null,null,null,null,"",null,""]
[null,3,null,null,null,null,"",null,""]
[null,4,null,null,null,null,"",null,""]
[null,5,null,null,null,null,"",null,""]
[null,6,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,"Liquid Limit",{"$f":"(IF(ISERROR(SUM(DataPoints)),\"\",IF(SUM(DataPoints)=0,\"\",IF(COUNT(I24:I29)<3,AVERAGE(I24:I25),BestFit))))","v":""}]
[]
[null,"Plastic Limit - Tex-105-E"]
[null,null,"Dish No.","Mass of Wet Sample + Tare (g)","Mass of Dry Sample + Tare (g)","Tare Mass (g)","Mass of Water (g)","Plastic Limit (%)"]
[]
[null,1,null,null,null,null,{"$f":"IF($F35=\"\",\"\",$D35-$E35)","v":""},{"$f":"IF($G35=\"\",\"\",100*($G35/($E35-$F35)))","v":""}]
[null,2,null,null,null,null,{"$f":"IF($F36=\"\",\"\",$D36-$E36)","v":""},{"$f":"IF($G36=\"\",\"\",100*($G36/($E36-$F36)))","v":""}]
[null,3,null,null,null,null,{"$f":"IF($F37=\"\",\"\",$D37-$E37)","v":""},{"$f":"IF($G37=\"\",\"\",100*($G37/($E37-$F37)))","v":""}]
[null,null,null,null,null,null,"Plastic Limit",{"$f":"IF(ISERROR(AVERAGE(H35:H37)),\"\",AVERAGE(H35:H37))","v":""}]
[]
[null,"Plasticity Index - Tex-106-E"]
[]
[null,null,{"$f":"IF(CheckBox4BLS=\"Yes\",\"Plasticity Index Calculated from Linear Shrinkage:\",\"Plasticity Index:\")","v":"Plasticity Index:"},null,null,null,{"$f":"IF(ISERROR(IF(CheckBox4BLS=\"Yes\",\"*See Note\",$I30-$H38)),\"\",IF(CheckBox4BLS=\"Yes\",\"*See Note\",$I30-$H38))","v":""}]
[]
[null,null,null,null,null,"Use Bar Linear Shrinkage to Calculate Plasticity Index?"]
[]
[null,null,null,"Test Tx107 Test Number Reference:"]
[null,null,null,null,null,null,null,null,{"$f":"\"*See Test Tx107 Test Nbr (\" & tstnbr & \") - Bar Linear Shrinkage Associated to this Sample for Plasticity Index.\"","v":"*See Test Tx107 Test Nbr () - Bar Linear Shrinkage Associated to this Sample for Plasticity Index."}]
[]
[null,"Remarks:",{"$f":"NOW()","v":"2024-06-05T15:09:39.460"}]
[]
[]
[]
[]
[null,"Sample Method:","Sampled By:",null,null,"Sampled Date:"]
[null,"TX100"]
[]
[null,"TX400"]
[]
[null,"Test Method:"]
[null,"TX104"]
[]
[null,"TX105"]
[]
[null,"TX106"]
[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":79,"n_cols":9,"rows_kept":79,"cut":false,"hidden":true,"merged":[]}
[77]
["Fld_nbr","Value","Desc_1","Desc_2","Desc_3","Desc_4","Desc_5","Desc_6","Desc_7"]
[1,{"$f":"IF(Atterberg!$B$50=\"\",\"\",Atterberg!$B$50)","v":""},{"$f":"Atterberg!$B$49","v":"Remarks:"}]
[2,{"$f":"IF(Atterberg!$D$19=\"\",\"\",Atterberg!$D$19)","v":""},{"$f":"IF(Atterberg!$C$19=\"\",\"\",Atterberg!$C$19)","v":"COURSE\\LIFT:"}]
[3,{"$f":"IF(Atterberg!$C$60=\"\",\"\",Atterberg!$C$60)","v":""},"Tested By ",{"$f":"IF(Atterberg!$B$60=\"\",\"\",Atterberg!$B$60)","v":"TX104"}]
[4,{"$f":"IF(Atterberg!$F$60=\"\",\"\",Atterberg!$F$60)","v":""},"Tested Date ",{"$f":"IF(Atterberg!$B$60=\"\",\"\",Atterberg!$B$60)","v":"TX104"}]
[5,{"$f":"IF(Atterberg!$C$62=\"\",\"\",Atterberg!$C$62)","v":""},"Tested By ",{"$f":"IF(Atterberg!$B$62=\"\",\"\",Atterberg!$B$62)","v":"TX105"}]
[6,{"$f":"IF(Atterberg!$F$62=\"\",\"\",Atterberg!$F$62)","v":""},"Tested Date ",{"$f":"IF(Atterberg!$B$62=\"\",\"\",Atterberg!$B$62)","v":"TX105"}]
[7,{"$f":"IF(Atterberg!$C$64=\"\",\"\",Atterberg!$C$64)","v":""},"Tested By ",{"$f":"IF(Atterberg!$B$64=\"\",\"\",Atterberg!$B$64)","v":"TX106"}]
[8,{"$f":"IF(Atterberg!$F$64=\"\",\"\",Atterberg!$F$64)","v":""},"Tested Date ",{"$f":"IF(Atterberg!$B$64=\"\",\"\",Atterberg!$B$64)","v":"TX106"}]
[9,{"$f":"IF(Atterberg!$C$24=\"\",\"\",Atterberg!$C$24)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$C$22=\"\",\"\",Atterberg!$C$22)","v":"Dish No."},{"$f":"IF(Atterberg!$B$24=\"\",\"\",Atterberg!$B$24)","v":1}]
[10,{"$f":"IF(Atterberg!$D$24=\"\",\"\",Atterberg!$D$24)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$D$22=\"\",\"\",Atterberg!$D$22)","v":"Mass of Wet Sample + Tare (g)"},{"$f":"IF(Atterberg!$B$24=\"\",\"\",Atterberg!$B$24)","v":1}]
[11,{"$f":"IF(Atterberg!$E$24=\"\",\"\",Atterberg!$E$24)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$E$22=\"\",\"\",Atterberg!$E$22)","v":"Mass of Dry Sample + Tare (g)"},{"$f":"IF(Atterberg!$B$24=\"\",\"\",Atterberg!$B$24)","v":1}]
[12,{"$f":"IF(Atterberg!$F$24=\"\",\"\",Atterberg!$F$24)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$F$22=\"\",\"\",Atterberg!$F$22)","v":"Tare Mass (g)"},{"$f":"IF(Atterberg!$B$24=\"\",\"\",Atterberg!$B$24)","v":1}]
[13,{"$f":"IF(Atterberg!$G$24=\"\",\"\",Atterberg!$G$24)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$G$22=\"\",\"\",Atterberg!$G$22)","v":"Moisture Content (%)"},{"$f":"IF(Atterberg!$B$24=\"\",\"\",Atterberg!$B$24)","v":1}]
[14,{"$f":"IF(Atterberg!$H$24=\"\",\"\",Atterberg!$H$24)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$H$22=\"\",\"\",Atterberg!$H$22)","v":"Number of Blows"},{"$f":"IF(Atterberg!$B$24=\"\",\"\",Atterberg!$B$24)","v":1}]
[15,{"$f":"IF(Atterberg!$I$24=\"\",\"\",Atterberg!$I$24)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$I$22=\"\",\"\",Atterberg!$I$22)","v":"Liquid Limit (%)"},{"$f":"IF(Atterberg!$B$24=\"\",\"\",Atterberg!$B$24)","v":1}]
[16,{"$f":"IF(Atterberg!$C$25=\"\",\"\",Atterberg!$C$25)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$C$22=\"\",\"\",Atterberg!$C$22)","v":"Dish No."},{"$f":"IF(Atterberg!$B$25=\"\",\"\",Atterberg!$B$25)","v":2}]
[17,{"$f":"IF(Atterberg!$D$25=\"\",\"\",Atterberg!$D$25)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$D$22=\"\",\"\",Atterberg!$D$22)","v":"Mass of Wet Sample + Tare (g)"},{"$f":"IF(Atterberg!$B$25=\"\",\"\",Atterberg!$B$25)","v":2}]
[18,{"$f":"IF(Atterberg!$E$25=\"\",\"\",Atterberg!$E$25)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$E$22=\"\",\"\",Atterberg!$E$22)","v":"Mass of Dry Sample + Tare (g)"},{"$f":"IF(Atterberg!$B$25=\"\",\"\",Atterberg!$B$25)","v":2}]
[19,{"$f":"IF(Atterberg!$F$25=\"\",\"\",Atterberg!$F$25)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$F$22=\"\",\"\",Atterberg!$F$22)","v":"Tare Mass (g)"},{"$f":"IF(Atterberg!$B$25=\"\",\"\",Atterberg!$B$25)","v":2}]
[20,{"$f":"IF(Atterberg!$G$25=\"\",\"\",Atterberg!$G$25)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$G$22=\"\",\"\",Atterberg!$G$22)","v":"Moisture Content (%)"},{"$f":"IF(Atterberg!$B$25=\"\",\"\",Atterberg!$B$25)","v":2}]
[21,{"$f":"IF(Atterberg!$H$25=\"\",\"\",Atterberg!$H$25)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$H$22=\"\",\"\",Atterberg!$H$22)","v":"Number of Blows"},{"$f":"IF(Atterberg!$B$25=\"\",\"\",Atterberg!$B$25)","v":2}]
[22,{"$f":"IF(Atterberg!$I$25=\"\",\"\",Atterberg!$I$25)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$I$22=\"\",\"\",Atterberg!$I$22)","v":"Liquid Limit (%)"},{"$f":"IF(Atterberg!$B$25=\"\",\"\",Atterberg!$B$25)","v":2}]
[23,{"$f":"IF(Atterberg!$C$26=\"\",\"\",Atterberg!$C$26)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$C$22=\"\",\"\",Atterberg!$C$22)","v":"Dish No."},{"$f":"IF(Atterberg!$B$26=\"\",\"\",Atterberg!$B$26)","v":3}]
[24,{"$f":"IF(Atterberg!$D$26=\"\",\"\",Atterberg!$D$26)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$D$22=\"\",\"\",Atterberg!$D$22)","v":"Mass of Wet Sample + Tare (g)"},{"$f":"IF(Atterberg!$B$26=\"\",\"\",Atterberg!$B$26)","v":3}]
[25,{"$f":"IF(Atterberg!$E$26=\"\",\"\",Atterberg!$E$26)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$E$22=\"\",\"\",Atterberg!$E$22)","v":"Mass of Dry Sample + Tare (g)"},{"$f":"IF(Atterberg!$B$26=\"\",\"\",Atterberg!$B$26)","v":3}]
[26,{"$f":"IF(Atterberg!$F$26=\"\",\"\",Atterberg!$F$26)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$F$22=\"\",\"\",Atterberg!$F$22)","v":"Tare Mass (g)"},{"$f":"IF(Atterberg!$B$26=\"\",\"\",Atterberg!$B$26)","v":3}]
[27,{"$f":"IF(Atterberg!$G$26=\"\",\"\",Atterberg!$G$26)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$G$22=\"\",\"\",Atterberg!$G$22)","v":"Moisture Content (%)"},{"$f":"IF(Atterberg!$B$26=\"\",\"\",Atterberg!$B$26)","v":3}]
[28,{"$f":"IF(Atterberg!$H$26=\"\",\"\",Atterberg!$H$26)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$H$22=\"\",\"\",Atterberg!$H$22)","v":"Number of Blows"},{"$f":"IF(Atterberg!$B$26=\"\",\"\",Atterberg!$B$26)","v":3}]
[29,{"$f":"IF(Atterberg!$I$26=\"\",\"\",Atterberg!$I$26)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$I$22=\"\",\"\",Atterberg!$I$22)","v":"Liquid Limit (%)"},{"$f":"IF(Atterberg!$B$26=\"\",\"\",Atterberg!$B$26)","v":3}]
[30,{"$f":"IF(Atterberg!$C$27=\"\",\"\",Atterberg!$C$27)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$C$22=\"\",\"\",Atterberg!$C$22)","v":"Dish No."},{"$f":"IF(Atterberg!$B$27=\"\",\"\",Atterberg!$B$27)","v":4}]
[31,{"$f":"IF(Atterberg!$D$27=\"\",\"\",Atterberg!$D$27)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$D$22=\"\",\"\",Atterberg!$D$22)","v":"Mass of Wet Sample + Tare (g)"},{"$f":"IF(Atterberg!$B$27=\"\",\"\",Atterberg!$B$27)","v":4}]
[32,{"$f":"IF(Atterberg!$E$27=\"\",\"\",Atterberg!$E$27)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$E$22=\"\",\"\",Atterberg!$E$22)","v":"Mass of Dry Sample + Tare (g)"},{"$f":"IF(Atterberg!$B$27=\"\",\"\",Atterberg!$B$27)","v":4}]
[33,{"$f":"IF(Atterberg!$F$27=\"\",\"\",Atterberg!$F$27)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$F$22=\"\",\"\",Atterberg!$F$22)","v":"Tare Mass (g)"},{"$f":"IF(Atterberg!$B$27=\"\",\"\",Atterberg!$B$27)","v":4}]
[34,{"$f":"IF(Atterberg!$G$27=\"\",\"\",Atterberg!$G$27)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$G$22=\"\",\"\",Atterberg!$G$22)","v":"Moisture Content (%)"},{"$f":"IF(Atterberg!$B$27=\"\",\"\",Atterberg!$B$27)","v":4}]
[35,{"$f":"IF(Atterberg!$H$27=\"\",\"\",Atterberg!$H$27)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$H$22=\"\",\"\",Atterberg!$H$22)","v":"Number of Blows"},{"$f":"IF(Atterberg!$B$27=\"\",\"\",Atterberg!$B$27)","v":4}]
[36,{"$f":"IF(Atterberg!$I$27=\"\",\"\",Atterberg!$I$27)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$I$22=\"\",\"\",Atterberg!$I$22)","v":"Liquid Limit (%)"},{"$f":"IF(Atterberg!$B$27=\"\",\"\",Atterberg!$B$27)","v":4}]
[37,{"$f":"IF(Atterberg!$C$28=\"\",\"\",Atterberg!$C$28)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$C$22=\"\",\"\",Atterberg!$C$22)","v":"Dish No."},{"$f":"IF(Atterberg!$B$28=\"\",\"\",Atterberg!$B$28)","v":5}]
[38,{"$f":"IF(Atterberg!$D$28=\"\",\"\",Atterberg!$D$28)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$D$22=\"\",\"\",Atterberg!$D$22)","v":"Mass of Wet Sample + Tare (g)"},{"$f":"IF(Atterberg!$B$28=\"\",\"\",Atterberg!$B$28)","v":5}]
[39,{"$f":"IF(Atterberg!$E$28=\"\",\"\",Atterberg!$E$28)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$E$22=\"\",\"\",Atterberg!$E$22)","v":"Mass of Dry Sample + Tare (g)"},{"$f":"IF(Atterberg!$B$28=\"\",\"\",Atterberg!$B$28)","v":5}]
[40,{"$f":"IF(Atterberg!$F$28=\"\",\"\",Atterberg!$F$28)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$F$22=\"\",\"\",Atterberg!$F$22)","v":"Tare Mass (g)"},{"$f":"IF(Atterberg!$B$28=\"\",\"\",Atterberg!$B$28)","v":5}]
[41,{"$f":"IF(Atterberg!$G$28=\"\",\"\",Atterberg!$G$28)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$G$22=\"\",\"\",Atterberg!$G$22)","v":"Moisture Content (%)"},{"$f":"IF(Atterberg!$B$28=\"\",\"\",Atterberg!$B$28)","v":5}]
[42,{"$f":"IF(Atterberg!$H$28=\"\",\"\",Atterberg!$H$28)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$H$22=\"\",\"\",Atterberg!$H$22)","v":"Number of Blows"},{"$f":"IF(Atterberg!$B$28=\"\",\"\",Atterberg!$B$28)","v":5}]
[43,{"$f":"IF(Atterberg!$I$28=\"\",\"\",Atterberg!$I$28)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$I$22=\"\",\"\",Atterberg!$I$22)","v":"Liquid Limit (%)"},{"$f":"IF(Atterberg!$B$28=\"\",\"\",Atterberg!$B$28)","v":5}]
[44,{"$f":"IF(Atterberg!$C$29=\"\",\"\",Atterberg!$C$29)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$C$22=\"\",\"\",Atterberg!$C$22)","v":"Dish No."},{"$f":"IF(Atterberg!$B$29=\"\",\"\",Atterberg!$B$29)","v":6}]
[45,{"$f":"IF(Atterberg!$D$29=\"\",\"\",Atterberg!$D$29)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$D$22=\"\",\"\",Atterberg!$D$22)","v":"Mass of Wet Sample + Tare (g)"},{"$f":"IF(Atterberg!$B$29=\"\",\"\",Atterberg!$B$29)","v":6}]
[46,{"$f":"IF(Atterberg!$E$29=\"\",\"\",Atterberg!$E$29)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$E$22=\"\",\"\",Atterberg!$E$22)","v":"Mass of Dry Sample + Tare (g)"},{"$f":"IF(Atterberg!$B$29=\"\",\"\",Atterberg!$B$29)","v":6}]
[47,{"$f":"IF(Atterberg!$F$29=\"\",\"\",Atterberg!$F$29)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$F$22=\"\",\"\",Atterberg!$F$22)","v":"Tare Mass (g)"},{"$f":"IF(Atterberg!$B$29=\"\",\"\",Atterberg!$B$29)","v":6}]
[48,{"$f":"IF(Atterberg!$G$29=\"\",\"\",Atterberg!$G$29)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$G$22=\"\",\"\",Atterberg!$G$22)","v":"Moisture Content (%)"},{"$f":"IF(Atterberg!$B$29=\"\",\"\",Atterberg!$B$29)","v":6}]
[49,{"$f":"IF(Atterberg!$H$29=\"\",\"\",Atterberg!$H$29)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$H$22=\"\",\"\",Atterberg!$H$22)","v":"Number of Blows"},{"$f":"IF(Atterberg!$B$29=\"\",\"\",Atterberg!$B$29)","v":6}]
[50,{"$f":"IF(Atterberg!$I$29=\"\",\"\",Atterberg!$I$29)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$I$22=\"\",\"\",Atterberg!$I$22)","v":"Liquid Limit (%)"},{"$f":"IF(Atterberg!$B$29=\"\",\"\",Atterberg!$B$29)","v":6}]
[51,{"$f":"IF(Atterberg!$I$30=\"\",\"\",Atterberg!$I$30)","v":""},{"$f":"IF(Atterberg!$B$21=\"\",\"\",Atterberg!$B$21)","v":"Liquid Limit - Tex-104-E"},{"$f":"IF(Atterberg!$H$30=\"\",\"\",Atterberg!$H$30)","v":"Liquid Limit"}]
[52,{"$f":"IF(Atterberg!$C$35=\"\",\"\",Atterberg!$C$35)","v":""},{"$f":"IF(Atterberg!$B$32=\"\",\"\",Atterberg!$B$32)","v":"Plastic Limit - Tex-105-E"},{"$f":"IF(Atterberg!$C$33=\"\",\"\",Atterberg!$C$33)","v":"Dish No."},{"$f":"IF(Atterberg!$B$35=\"\",\"\",Atterberg!$B$35)","v":1}]
[53,{"$f":"IF(Atterberg!$D$35=\"\",\"\",Atterberg!$D$35)","v":""},{"$f":"IF(Atterberg!$B$32=\"\",\"\",Atterberg!$B$32)","v":"Plastic Limit - Tex-105-E"},{"$f":"IF(Atterberg!$D$33=\"\",\"\",Atterberg!$D$33)","v":"Mass of Wet Sample + Tare (g)"},{"$f":"IF(Atterberg!$B$35=\"\",\"\",Atterberg!$B$35)","v":1}]
[54,{"$f":"IF(Atterberg!$E$35=\"\",\"\",Atterberg!$E$35)","v":""},{"$f":"IF(Atterberg!$B$32=\"\",\"\",Atterberg!$B$32)","v":"Plastic Limit - Tex-105-E"},{"$f":"IF(Atterberg!$E$33=\"\",\"\",Atterberg!$E$33)","v":"Mass of Dry Sample + Tare (g)"},{"$f":"IF(Atterberg!$B$35=\"\",\"\",Atterberg!$B$35)","v":1}]
[55,{"$f":"IF(Atterberg!$F$35=\"\",\"\",Atterberg!$F$35)","v":""},{"$f":"IF(Atterberg!$B$32=\"\",\"\",Atterberg!$B$32)","v":"Plastic Limit - Tex-105-E"},{"$f":"IF(Atterberg!$F$33=\"\",\"\",Atterberg!$F$33)","v":"Tare Mass (g)"},{"$f":"IF(Atterberg!$B$35=\"\",\"\",Atterberg!$B$35)","v":1}]
[56,{"$f":"IF(Atterberg!$G$35=\"\",\"\",Atterberg!$G$35)","v":""},{"$f":"IF(Atterberg!$B$32=\"\",\"\",Atterberg!$B$32)","v":"Plastic Limit - Tex-105-E"},{"$f":"IF(Atterberg!$G$33=\"\",\"\",Atterberg!$G$33)","v":"Mass of Water (g)"},{"$f":"IF(Atterberg!$B$35=\"\",\"\",Atterberg!$B$35)","v":1}]
[57,{"$f":"IF(Atterberg!$H$35=\"\",\"\",Atterberg!$H$35)","v":""},{"$f":"IF(Atterberg!$B$32=\"\",\"\",Atterberg!$B$32)","v":"Plastic Limit - Tex-105-E"},{"$f":"IF(Atterberg!$H$33=\"\",\"\",Atterberg!$H$33)","v":"Plastic Limit (%)"},{"$f":"IF(Atterberg!$B$35=\"\",\"\",Atterberg!$B$35)","v":1}]
[58,{"$f":"IF(Atterberg!$C$36=\"\",\"\",Atterberg!$C$36)","v":""},{"$f":"IF(Atterberg!$B$32=\"\",\"\",Atterberg!$B$32)","v":"Plastic Limit - Tex-105-E"},{"$f":"IF(Atterberg!$C$33=\"\",\"\",Atterberg!$C$33)","v":"Dish No."},{"$f":"IF(Atterberg!$B$36=\"\",\"\",Atterberg!$B$36)","v":2}]
[59,{"$f":"IF(Atterberg!$D$36=\"\",\"\",Atterberg!$D$36)","v":""},{"$f":"IF(Atterberg!$B$32=\"\",\"\",Atterberg!$B$32)","v":"Plastic Limit - Tex-105-E"},{"$f":"IF(Atterberg!$D$33=\"\",\"\",Atterberg!$D$33)","v":"Mass of Wet Sample + Tare (g)"},{"$f":"IF(Atterberg!$B$36=\"\",\"\",Atterberg!$B$36)","v":2}]
[60,{"$f":"IF(Atterberg!$E$36=\"\",\"\",Atterberg!$E$36)","v":""},{"$f":"IF(Atterberg!$B$32=\"\",\"\",Atterberg!$B$32)","v":"Plastic Limit - Tex-105-E"},{"$f":"IF(Atterberg!$E$33=\"\",\"\",Atterberg!$E$33)","v":"Mass of Dry Sample + Tare (g)"},{"$f":"IF(Atterberg!$B$36=\"\",\"\",Atterberg!$B$36)","v":2}]
[61,{"$f":"IF(Atterberg!$F$36=\"\",\"\",Atterberg!$F$36)","v":""},{"$f":"IF(Atterberg!$B$32=\"\",\"\",Atterberg!$B$32)","v":"Plastic Limit - Tex-105-E"},{"$f":"IF(Atterberg!$F$33=\"\",\"\",Atterberg!$F$33)","v":"Tare Mass (g)"},{"$f":"IF(Atterberg!$B$36=\"\",\"\",Atterberg!$B$36)","v":2}]
[62,{"$f":"IF(Atterberg!$G$36=\"\",\"\",Atterberg!$G$36)","v":""},{"$f":"IF(Atterberg!$B$32=\"\",\"\",Atterberg!$B$32)","v":"Plastic Limit - Tex-105-E"},{"$f":"IF(Atterberg!$G$33=\"\",\"\",Atterberg!$G$33)","v":"Mass of Water (g)"},{"$f":"IF(Atterberg!$B$36=\"\",\"\",Atterberg!$B$36)","v":2}]
[63,{"$f":"IF(Atterberg!$H$36=\"\",\"\",Atterberg!$H$36)","v":""},{"$f":"IF(Atterberg!$B$32=\"\",\"\",Atterberg!$B$32)","v":"Plastic Limit - Tex-105-E"},{"$f":"IF(Atterberg!$H$33=\"\",\"\",Atterberg!$H$33)","v":"Plastic Limit (%)"},{"$f":"IF(Atterberg!$B$36=\"\",\"\",Atterberg!$B$36)","v":2}]
[64,{"$f":"IF(Atterberg!$C$37=\"\",\"\",Atterberg!$C$37)","v":""},{"$f":"IF(Atterberg!$B$32=\"\",\"\",Atterberg!$B$32)","v":"Plastic Limit - Tex-105-E"},{"$f":"IF(Atterberg!$C$33=\"\",\"\",Atterberg!$C$33)","v":"Dish No."},{"$f":"IF(Atterberg!$B$37=\"\",\"\",Atterberg!$B$37)","v":3}]
[65,{"$f":"IF(Atterberg!$D$37=\"\",\"\",Atterberg!$D$37)","v":""},{"$f":"IF(Atterberg!$B$32=\"\",\"\",Atterberg!$B$32)","v":"Plastic Limit - Tex-105-E"},{"$f":"IF(Atterberg!$D$33=\"\",\"\",Atterberg!$D$33)","v":"Mass of Wet Sample + Tare (g)"},{"$f":"IF(Atterberg!$B$37=\"\",\"\",Atterberg!$B$37)","v":3}]
[66,{"$f":"IF(Atterberg!$E$37=\"\",\"\",Atterberg!$E$37)","v":""},{"$f":"IF(Atterberg!$B$32=\"\",\"\",Atterberg!$B$32)","v":"Plastic Limit - Tex-105-E"},{"$f":"IF(Atterberg!$E$33=\"\",\"\",Atterberg!$E$33)","v":"Mass of Dry Sample + Tare (g)"},{"$f":"IF(Atterberg!$B$37=\"\",\"\",Atterberg!$B$37)","v":3}]
[67,{"$f":"IF(Atterberg!$F$37=\"\",\"\",Atterberg!$F$37)","v":""},{"$f":"IF(Atterberg!$B$32=\"\",\"\",Atterberg!$B$32)","v":"Plastic Limit - Tex-105-E"},{"$f":"IF(Atterberg!$F$33=\"\",\"\",Atterberg!$F$33)","v":"Tare Mass (g)"},{"$f":"IF(Atterberg!$B$37=\"\",\"\",Atterberg!$B$37)","v":3}]
[68,{"$f":"IF(Atterberg!$G$37=\"\",\"\",Atterberg!$G$37)","v":""},{"$f":"IF(Atterberg!$B$32=\"\",\"\",Atterberg!$B$32)","v":"Plastic Limit - Tex-105-E"},{"$f":"IF(Atterberg!$G$33=\"\",\"\",Atterberg!$G$33)","v":"Mass of Water (g)"},{"$f":"IF(Atterberg!$B$37=\"\",\"\",Atterberg!$B$37)","v":3}]
[69,{"$f":"IF(Atterberg!$H$37=\"\",\"\",Atterberg!$H$37)","v":""},{"$f":"IF(Atterberg!$B$32=\"\",\"\",Atterberg!$B$32)","v":"Plastic Limit - Tex-105-E"},{"$f":"IF(Atterberg!$H$33=\"\",\"\",Atterberg!$H$33)","v":"Plastic Limit (%)"},{"$f":"IF(Atterberg!$B$37=\"\",\"\",Atterberg!$B$37)","v":3}]
[70,{"$f":"IF(Atterberg!$H$38=\"\",\"\",Atterberg!$H$38)","v":""},{"$f":"IF(Atterberg!$B$32=\"\",\"\",Atterberg!$B$32)","v":"Plastic Limit - Tex-105-E"},{"$f":"IF(Atterberg!$G$38=\"\",\"\",Atterberg!$G$38)","v":"Plastic Limit"}]
[71,{"$f":"IF(Atterberg!$G$42=\"\",\"\",Atterberg!$G$42)","v":""},{"$f":"IF(Atterberg!$B$40=\"\",\"\",Atterberg!$B$40)","v":"Plasticity Index - Tex-106-E"},{"$f":"IF(Atterberg!$C$42=\"\",\"\",Atterberg!$C$42)","v":"Plasticity Index:"}]
[72,{"$f":"IF(Atterberg!$G$44=\"\",\"\",Atterberg!$G$44)","v":""},{"$f":"IF(Atterberg!$B$40=\"\",\"\",Atterberg!$B$40)","v":"Plasticity Index - Tex-106-E"},{"$f":"IF(Atterberg!$F$44=\"\",\"\",Atterberg!$F$44)","v":"Use Bar Linear Shrinkage to Calculate Plasticity Index?"}]
[73,{"$f":"IF(Atterberg!$G$46=\"\",\"\",Atterberg!$G$46)","v":""},{"$f":"IF(Atterberg!$B$40=\"\",\"\",Atterberg!$B$40)","v":"Plasticity Index - Tex-106-E"},{"$f":"IF(Atterberg!$D$46=\"\",\"\",Atterberg!$D$46)","v":"Test Tx107 Test Number Reference:"}]
[74,{"$f":"IF(Atterberg!$C$55=\"\",\"\",Atterberg!$C$55)","v":""},"Sampled By",{"$f":"IF(Atterberg!$B$55=\"\",\"\",Atterberg!$B$55)","v":"TX100"}]
[75,{"$f":"IF(Atterberg!$F$55=\"\",\"\",Atterberg!$F$55)","v":""},"Sampled Date",{"$f":"IF(Atterberg!$B$55=\"\",\"\",Atterberg!$B$55)","v":"TX100"}]
[76,{"$f":"IF(Atterberg!$C$57=\"\",\"\",Atterberg!$C$57)","v":""},"Sampled By",{"$f":"IF(Atterberg!$B$57=\"\",\"\",Atterberg!$B$57)","v":"TX400"}]
[77,{"$f":"IF(Atterberg!$F$57=\"\",\"\",Atterberg!$F$57)","v":""},"Sampled Date",{"$f":"IF(Atterberg!$B$57=\"\",\"\",Atterberg!$B$57)","v":"TX400"}]

{"sheet":"Calculations","index":3,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":true,"merged":[[9,0,9,1],[11,1,12,1],[11,2,12,2],[11,0,12,0]]}
[]
[null,"Raw Data","Best Fit Data"]
["Blows","Moisture Content","Moisture Content"]
[{"$f":"IF(Atterberg!H24=\"\",\"\",Atterberg!H24)","v":""},{"$f":"Atterberg!G24","v":""},{"$f":"IF($B4=\"\",\"\",INDEX((LINEST(INDIRECT(\"$b$4:$b\"&(9-COUNTBLANK($A$4:$A$9))),LN(INDIRECT(\"$A$4:$A\"&(9-COUNTBLANK($A$4:$A$9)))),TRUE,TRUE)),1)*LN($A$4)+INDEX(LINEST(INDIRECT(\"$b4:$b\"&(9-COUNTBLANK($A$4:$A$9))),LN(INDIRECT(\"$A$4:$A\"&(9-COUNTBLANK($A$4:$A$9))))),2))","v":""},{"$f":"COUNTBLANK($A$4:$A$9)","v":6}]
[{"$f":"IF(Atterberg!H25=\"\",\"\",Atterberg!H25)","v":""},{"$f":"Atterberg!G25","v":""},{"$f":"IF($B5=\"\",\"\",INDEX((LINEST(INDIRECT(\"$b$4:$b\"&(9-COUNTBLANK($A$4:$A$9))),LN(INDIRECT(\"$A$4:$A\"&(9-COUNTBLANK($A$4:$A$9)))),TRUE,TRUE)),1)*LN($A$5)+INDEX(LINEST(INDIRECT(\"$b4:$b\"&(9-COUNTBLANK($A$4:$A$9))),LN(INDIRECT(\"$A$4:$A\"&(9-COUNTBLANK($A$4:$A$9))))),2))","v":""}]
[{"$f":"IF(Atterberg!H26=\"\",\"\",Atterberg!H26)","v":""},{"$f":"Atterberg!G26","v":""},{"$f":"IF($B6=\"\",\"\",INDEX((LINEST(INDIRECT(\"$b$4:$b\"&(9-COUNTBLANK($A$4:$A$9))),LN(INDIRECT(\"$A$4:$A\"&(9-COUNTBLANK($A$4:$A$9)))),TRUE,TRUE)),1)*LN($A$6)+INDEX(LINEST(INDIRECT(\"$b4:$b\"&(9-COUNTBLANK($A$4:$A$9))),LN(INDIRECT(\"$A$4:$A\"&(9-COUNTBLANK($A$4:$A$9))))),2))","v":""}]
[{"$f":"IF(Atterberg!H27=\"\",\"\",Atterberg!H27)","v":""},{"$f":"Atterberg!G27","v":""},{"$f":"IF($B7=\"\",\"\",INDEX((LINEST(INDIRECT(\"$b$4:$b\"&(9-COUNTBLANK($A$4:$A$9))),LN(INDIRECT(\"$A$4:$A\"&(9-COUNTBLANK($A$4:$A$9)))),TRUE,TRUE)),1)*LN($A$7)+INDEX(LINEST(INDIRECT(\"$b4:$b\"&(9-COUNTBLANK($A$4:$A$9))),LN(INDIRECT(\"$A$4:$A\"&(9-COUNTBLANK($A$4:$A$9))))),2))","v":""}]
[{"$f":"IF(Atterberg!H28=\"\",\"\",Atterberg!H28)","v":""},{"$f":"Atterberg!G28","v":""},{"$f":"IF($B8=\"\",\"\",INDEX((LINEST(INDIRECT(\"$b$4:$b\"&(9-COUNTBLANK($A$4:$A$9))),LN(INDIRECT(\"$A$4:$A\"&(9-COUNTBLANK($A$4:$A$9)))),TRUE,TRUE)),1)*LN($A$8)+INDEX(LINEST(INDIRECT(\"$b4:$b\"&(9-COUNTBLANK($A$4:$A$9))),LN(INDIRECT(\"$A$4:$A\"&(9-COUNTBLANK($A$4:$A$9))))),2))","v":""}]
[{"$f":"IF(Atterberg!H29=\"\",\"\",Atterberg!H29)","v":""},{"$f":"Atterberg!G29","v":""},{"$f":"IF($B9=\"\",\"\",INDEX((LINEST(INDIRECT(\"$b$4:$b\"&(9-COUNTBLANK($A$4:$A$9))),LN(INDIRECT(\"$A$4:$A\"&(9-COUNTBLANK($A$4:$A$9)))),TRUE,TRUE)),1)*LN($A$9)+INDEX(LINEST(INDIRECT(\"$b4:$b\"&(9-COUNTBLANK($A$4:$A$9))),LN(INDIRECT(\"$A$4:$A\"&(9-COUNTBLANK($A$4:$A$9))))),2))","v":""}]
["Moisture Content @ No. Blows = 25 from Best Fit Equation",null,{"$f":"INDEX((LINEST(INDIRECT(\"$b$4:$b\"&(9-COUNTBLANK($A$4:$A$9))),LN(INDIRECT(\"$A$4:$A\"&(9-COUNTBLANK($A$4:$A$9)))),TRUE,TRUE)),1)*LN(25)+INDEX(LINEST(INDIRECT(\"$b4:$b\"&(9-COUNTBLANK($A$4:$A$9))),LN(INDIRECT(\"$A$4:$A\"&(9-COUNTBLANK($A$4:$A$9))))),2)","v":{"$error":"#VALUE!"}}]
[]
["size","Cumulative Percent Retained","Cumulative Percent Passing"]
["size"]
[{"$f":"IF(ISERROR(INDEX(INDIRECT(\"grade\"&Grade),1,2)),\"\",INDEX(INDIRECT(\"grade\"&Grade),1,2))","v":""},{"$f":"Atterberg!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(B14=\"\",\"\",100-B14)","v":{"$error":"#REF!"}}]
[{"$f":"IF(ISERROR(INDEX(INDIRECT(\"grade\"&Grade),2,2)),\"\",INDEX(INDIRECT(\"grade\"&Grade),2,2))","v":""},{"$f":"Atterberg!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(B15=\"\",\"\",100-B15)","v":{"$error":"#REF!"}}]
[{"$f":"IF(ISERROR(INDEX(INDIRECT(\"grade\"&Grade),3,2)),\"\",INDEX(INDIRECT(\"grade\"&Grade),3,2))","v":""},{"$f":"Atterberg!F62","v":0},{"$f":"IF(B16=\"\",\"\",100-B16)","v":100}]
[{"$f":"IF(ISERROR(INDEX(INDIRECT(\"grade\"&Grade),4,2)),\"\",INDEX(INDIRECT(\"grade\"&Grade),4,2))","v":""},{"$f":"Atterberg!F63","v":0},{"$f":"IF(B17=\"\",\"\",100-B17)","v":100}]
[{"$f":"IF(ISERROR(INDEX(INDIRECT(\"grade\"&Grade),5,2)),\"\",INDEX(INDIRECT(\"grade\"&Grade),5,2))","v":""},{"$f":"Atterberg!E64","v":0},{"$f":"IF(B18=\"\",\"\",100-B18)","v":100}]