{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Measuring Pan Wt.","Taring with Pan"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Measuring Pan Wt.","index":0,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Mass of wet soil + Pan, A, in grams"]
["Mass of dry soil + Pan, B, in grams"]
["Mass of Pan, C, in grams"]
["Mass of dry soil, D = B-C, in grams",{"$f":"IF(OR(B3=\"\",B2=\"\"),\"\",ROUND((B2-B3),1))","v":""},{"$f":"IF(OR(C3=\"\",C2=\"\"),\"\",ROUND((C2-C3),1))","v":""},"","",""]
["Mass of water, E = A-B, in grams",{"$f":"IF(OR(B1=\"\",B2=\"\"),\"\",ROUND((B1-B2),1))","v":""},{"$f":"IF(OR(C1=\"\",C2=\"\"),\"\",ROUND((C1-C2),1))","v":""},"","",""]
["Moisture Content, F = 100 x E/D, in %",{"$f":"IF(OR(B4=\"\",B5=\"\"),\"\",ROUND((100*B5/B4),1))","v":""},{"$f":"IF(OR(C4=\"\",C5=\"\"),\"\",ROUND((100*C5/C4),1))","v":""},"","",""]
["Proctor Mold mass, G, in grams"]
["Soil and Mold mass, H, in grams"]
["Soil mass, I = H-G, in grams",{"$f":"IF(OR(B7=\"\",B8=\"\"),\"\",ROUND((B8-B7),1))","v":""},{"$f":"IF(OR(C7=\"\",C8=\"\"),\"\",ROUND((C8-C7),1))","v":""},"","",""]
["Wet Density, J = I x 0.06614, in pcf",{"$f":"IF(B9=\"\",\"\",ROUND((B9*0.06614),1))","v":""},{"$f":"IF(C9=\"\",\"\",ROUND((C9*0.06614),1))","v":""},"","",""]
["Dry Density, L = J/(1 + F/100), in pcf",{"$f":"IF(OR(B6=\"\",B10=\"\"),\"\",ROUND((B10/(1+B6/100)),1))","v":""},{"$f":"IF(OR(C6=\"\",C10=\"\"),\"\",ROUND((C10/(1+C6/100)),1))","v":""},"","",""]
[]
["Mass of wet soil + Pan, A, in grams"]
["Mass of dry soil + Pan, B, in grams"]
["Mass of Pan, C, in grams"]
["Mass of dry soil, D = B-C, in grams",{"$f":"IF(OR(B15=\"\",B14=\"\"),\"\",ROUND((B14-B15),1))","v":""},{"$f":"IF(OR(C15=\"\",C14=\"\"),\"\",ROUND((C14-C15),1))","v":""},{"$f":"IF(OR(D15=\"\",D14=\"\"),\"\",ROUND((D14-D15),1))","v":""},{"$f":"IF(OR(E15=\"\",E14=\"\"),\"\",ROUND((E14-E15),1))","v":""},{"$f":"IF(OR(F15=\"\",F14=\"\"),\"\",ROUND((F14-F15),1))","v":""}]
["Mass of water, E = A-B, in grams",{"$f":"IF(OR(B13=\"\",B14=\"\"),\"\",ROUND((B13-B14),1))","v":""},{"$f":"IF(OR(C13=\"\",C14=\"\"),\"\",ROUND((C13-C14),1))","v":""},"","",""]
["Moisture Content, F = 100 x E/D, in %",{"$f":"IF(OR(B16=\"\",B17=\"\"),\"\",ROUND((100*B17/B16),1))","v":""},{"$f":"IF(OR(C16=\"\",C17=\"\"),\"\",ROUND((100*C17/C16),1))","v":""},{"$f":"IF(OR(D16=\"\",D17=\"\"),\"\",ROUND((100*D17/D16),1))","v":""},{"$f":"IF(OR(E16=\"\",E17=\"\"),\"\",ROUND((100*E17/E16),1))","v":""},{"$f":"IF(OR(F16=\"\",F17=\"\"),\"\",ROUND((100*F17/F16),1))","v":""}]
["Proctor Mold mass, G, in grams"]
["Soil and Mold mass, H, in grams"]
["Soil mass, I = H-G, in grams",{"$f":"IF(OR(B19=\"\",B20=\"\"),\"\",ROUND((B20-B19),1))","v":""},{"$f":"IF(OR(C19=\"\",C20=\"\"),\"\",ROUND((C20-C19),1))","v":""},{"$f":"IF(OR(D19=\"\",D20=\"\"),\"\",ROUND((D20-D19),1))","v":""},{"$f":"IF(OR(E19=\"\",E20=\"\"),\"\",ROUND((E20-E19),1))","v":""},{"$f":"IF(OR(F19=\"\",F20=\"\"),\"\",ROUND((F20-F19),1))","v":""}]
["Wet Density, J = I x 0.06614, in pcf",{"$f":"IF(B21=\"\",\"\",ROUND((B21*0.06614),1))","v":""},{"$f":"IF(C21=\"\",\"\",ROUND((C21*0.06614),1))","v":""},{"$f":"IF(D21=\"\",\"\",ROUND((D21*0.06614),1))","v":""},{"$f":"IF(E21=\"\",\"\",ROUND((E21*0.06614),1))","v":""},{"$f":"IF(F21=\"\",\"\",ROUND((F21*0.06614),1))","v":""}]
["Dry Density, L = J/(1 + F/100), in pcf",{"$f":"IF(OR(B18=\"\",B22=\"\"),\"\",ROUND((B22/(1+B18/100)),1))","v":""},{"$f":"IF(OR(C18=\"\",C22=\"\"),\"\",ROUND((C22/(1+C18/100)),1))","v":""},{"$f":"IF(OR(D18=\"\",D22=\"\"),\"\",ROUND((D22/(1+D18/100)),1))","v":""},{"$f":"IF(OR(E18=\"\",E22=\"\"),\"\",ROUND((E22/(1+E18/100)),1))","v":""},{"$f":"IF(OR(F18=\"\",F22=\"\"),\"\",ROUND((F22/(1+F18/100)),1))","v":""}]
[]
["Mass of wet soil + Pan, A, in grams"]
["Mass of dry soil + Pan, B, in grams"]
["Mass of Pan, C, in grams"]
["Mass of dry soil, D = B-C, in grams",{"$f":"IF(OR(B27=\"\",B26=\"\"),\"\",ROUND((B26-B27),1))","v":""},{"$f":"IF(OR(C27=\"\",C26=\"\"),\"\",ROUND((C26-C27),1))","v":""},{"$f":"IF(OR(D27=\"\",D26=\"\"),\"\",ROUND((D26-D27),1))","v":""},{"$f":"IF(OR(E27=\"\",E26=\"\"),\"\",ROUND((E26-E27),1))","v":""},{"$f":"IF(OR(F27=\"\",F26=\"\"),\"\",ROUND((F26-F27),1))","v":""}]
["Mass of water, E = A-B, in grams",{"$f":"IF(OR(B25=\"\",B26=\"\"),\"\",ROUND((B25-B26),1))","v":""},{"$f":"IF(OR(C25=\"\",C26=\"\"),\"\",ROUND((C25-C26),1))","v":""},"","",""]
["Moisture Content, F = 100 x E/D, in %",{"$f":"IF(OR(B28=\"\",B29=\"\"),\"\",ROUND((100*B29/B28),1))","v":""},{"$f":"IF(OR(C28=\"\",C29=\"\"),\"\",ROUND((100*C29/C28),1))","v":""},{"$f":"IF(OR(D28=\"\",D29=\"\"),\"\",ROUND((100*D29/D28),1))","v":""},{"$f":"IF(OR(E28=\"\",E29=\"\"),\"\",ROUND((100*E29/E28),1))","v":""},{"$f":"IF(OR(F28=\"\",F29=\"\"),\"\",ROUND((100*F29/F28),1))","v":""}]
["Proctor Mold mass, G, in grams"]
["Soil and Mold mass, H, in grams"]
["Soil mass, I = H-G, in grams",{"$f":"IF(OR(B31=\"\",B32=\"\"),\"\",ROUND((B32-B31),1))","v":""},{"$f":"IF(OR(C31=\"\",C32=\"\"),\"\",ROUND((C32-C31),1))","v":""},{"$f":"IF(OR(D31=\"\",D32=\"\"),\"\",ROUND((D32-D31),1))","v":""},{"$f":"IF(OR(E31=\"\",E32=\"\"),\"\",ROUND((E32-E31),1))","v":""},{"$f":"IF(OR(F31=\"\",F32=\"\"),\"\",ROUND((F32-F31),1))","v":""}]
["Wet Density, J = I x 0.06614, in pcf",{"$f":"IF(B33=\"\",\"\",ROUND((B33*0.06614),1))","v":""},{"$f":"IF(C33=\"\",\"\",ROUND((C33*0.06614),1))","v":""},{"$f":"IF(D33=\"\",\"\",ROUND((D33*0.06614),1))","v":""},{"$f":"IF(E33=\"\",\"\",ROUND((E33*0.06614),1))","v":""},{"$f":"IF(F33=\"\",\"\",ROUND((F33*0.06614),1))","v":""}]
["Dry Density, L = J/(1 + F/100), in pcf",{"$f":"IF(OR(B30=\"\",B34=\"\"),\"\",ROUND((B34/(1+B30/100)),1))","v":""},{"$f":"IF(OR(C30=\"\",C34=\"\"),\"\",ROUND((C34/(1+C30/100)),1))","v":""},{"$f":"IF(OR(D30=\"\",D34=\"\"),\"\",ROUND((D34/(1+D30/100)),1))","v":""},{"$f":"IF(OR(E30=\"\",E34=\"\"),\"\",ROUND((E34/(1+E30/100)),1))","v":""},{"$f":"IF(OR(F30=\"\",F34=\"\"),\"\",ROUND((F34/(1+F30/100)),1))","v":""}]

{"sheet":"Taring with Pan","index":1,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,5],[32,0,32,5]]}
["WARNING:  Use this worksheet only when scale with pan is tared."]
[]
["Mass of wet soil, A, in grams"]
["Mass of dry soil, B, in grams"]
["Mass of water, E = A-B, in grams",{"$f":"IF(OR(B3=\"\",B4=\"\"),\"\",ROUND((B3-B4),1))","v":""},{"$f":"IF(OR(C3=\"\",C4=\"\"),\"\",ROUND((C3-C4),1))","v":""},"","",""]
["Moisture Content, F = 100 x E/B, in %",{"$f":"IF(OR(B4=\"\",B5=\"\"),\"\",ROUND((100*B5/B4),1))","v":""},{"$f":"IF(OR(C4=\"\",C5=\"\"),\"\",ROUND((100*C5/C4),1))","v":""},"","",""]
["Proctor Mold mass, G, in grams"]
["Soil and Mold mass, H, in grams"]
["Soil mass, I = H-G, in grams",{"$f":"IF(OR(B7=\"\",B8=\"\"),\"\",ROUND((B8-B7),1))","v":""},{"$f":"IF(OR(C7=\"\",C8=\"\"),\"\",ROUND((C8-C7),1))","v":""},"","",""]
["Wet Density, J = I x 0.06614, in pcf",{"$f":"IF(B9=\"\",\"\",ROUND((B9*0.06614),1))","v":""},{"$f":"IF(C9=\"\",\"\",ROUND((C9*0.06614),1))","v":""},"","",""]
["Dry Density, L = J/(1 + F/100), in pcf",{"$f":"IF(OR(B6=\"\",B10=\"\"),\"\",ROUND((B10/(1+B6/100)),1))","v":""},{"$f":"IF(OR(C6=\"\",C10=\"\"),\"\",ROUND((C10/(1+C6/100)),1))","v":""},"","",""]
[]
["Mass of wet soil, A, in grams"]
["Mass of dry soil, B, in grams"]
["Mass of water, E = A-B, in grams",{"$f":"IF(OR(B13=\"\",B14=\"\"),\"\",ROUND((B13-B14),1))","v":""},{"$f":"IF(OR(C13=\"\",C14=\"\"),\"\",ROUND((C13-C14),1))","v":""},"","",""]
["Moisture Content, F = 100 x E/B, in %",{"$f":"IF(OR(B14=\"\",B15=\"\"),\"\",ROUND((100*B15/B14),1))","v":""},{"$f":"IF(OR(C14=\"\",C15=\"\"),\"\",ROUND((100*C15/C14),1))","v":""},{"$f":"IF(OR(D14=\"\",D15=\"\"),\"\",ROUND((100*D15/D14),1))","v":""},{"$f":"IF(OR(E14=\"\",E15=\"\"),\"\",ROUND((100*E15/E14),1))","v":""},{"$f":"IF(OR(F14=\"\",F15=\"\"),\"\",ROUND((100*F15/F14),1))","v":""}]
["Proctor Mold mass, G, in grams"]
["Soil and Mold mass, H, in grams"]
["Soil mass, I = H-G, in grams",{"$f":"IF(OR(B17=\"\",B18=\"\"),\"\",ROUND((B18-B17),1))","v":""},{"$f":"IF(OR(C17=\"\",C18=\"\"),\"\",ROUND((C18-C17),1))","v":""},{"$f":"IF(OR(D17=\"\",D18=\"\"),\"\",ROUND((D18-D17),1))","v":""},{"$f":"IF(OR(E17=\"\",E18=\"\"),\"\",ROUND((E18-E17),1))","v":""},{"$f":"IF(OR(F17=\"\",F18=\"\"),\"\",ROUND((F18-F17),1))","v":""}]
["Wet Density, J = I x 0.06614, in pcf",{"$f":"IF(B19=\"\",\"\",ROUND((B19*0.06614),1))","v":""},{"$f":"IF(C19=\"\",\"\",ROUND((C19*0.06614),1))","v":""},{"$f":"IF(D19=\"\",\"\",ROUND((D19*0.06614),1))","v":""},{"$f":"IF(E19=\"\",\"\",ROUND((E19*0.06614),1))","v":""},{"$f":"IF(F19=\"\",\"\",ROUND((F19*0.06614),1))","v":""}]
["Dry Density, L = J/(1 + F/100), in pcf",{"$f":"IF(OR(B16=\"\",B20=\"\"),\"\",ROUND((B20/(1+B16/100)),1))","v":""},{"$f":"IF(OR(C16=\"\",C20=\"\"),\"\",ROUND((C20/(1+C16/100)),1))","v":""},{"$f":"IF(OR(D16=\"\",D20=\"\"),\"\",ROUND((D20/(1+D16/100)),1))","v":""},{"$f":"IF(OR(E16=\"\",E20=\"\"),\"\",ROUND((E20/(1+E16/100)),1))","v":""},{"$f":"IF(OR(F16=\"\",F20=\"\"),\"\",ROUND((F20/(1+F16/100)),1))","v":""}]
[]
["Mass of wet soil, A, in grams"]
["Mass of dry soil, B, in grams"]
["Mass of water, E = A-B, in grams",{"$f":"IF(OR(B23=\"\",B24=\"\"),\"\",ROUND((B23-B24),1))","v":""},{"$f":"IF(OR(C23=\"\",C24=\"\"),\"\",ROUND((C23-C24),1))","v":""},"","",""]
["Moisture Content, F = 100 x E/B, in %",{"$f":"IF(OR(B24=\"\",B25=\"\"),\"\",ROUND((100*B25/B24),1))","v":""},{"$f":"IF(OR(C24=\"\",C25=\"\"),\"\",ROUND((100*C25/C24),1))","v":""},{"$f":"IF(OR(D24=\"\",D25=\"\"),\"\",ROUND((100*D25/D24),1))","v":""},{"$f":"IF(OR(E24=\"\",E25=\"\"),\"\",ROUND((100*E25/E24),1))","v":""},{"$f":"IF(OR(F24=\"\",F25=\"\"),\"\",ROUND((100*F25/F24),1))","v":""}]
["Proctor Mold mass, G, in grams"]
["Soil and Mold mass, H, in grams"]
["Soil mass, I = H-G, in grams",{"$f":"IF(OR(B27=\"\",B28=\"\"),\"\",ROUND((B28-B27),1))","v":""},{"$f":"IF(OR(C27=\"\",C28=\"\"),\"\",ROUND((C28-C27),1))","v":""},{"$f":"IF(OR(D27=\"\",D28=\"\"),\"\",ROUND((D28-D27),1))","v":""},{"$f":"IF(OR(E27=\"\",E28=\"\"),\"\",ROUND((E28-E27),1))","v":""},{"$f":"IF(OR(F27=\"\",F28=\"\"),\"\",ROUND((F28-F27),1))","v":""}]
["Wet Density, J = I x 0.06614, in pcf",{"$f":"IF(B29=\"\",\"\",ROUND((B29*0.06614),1))","v":""},{"$f":"IF(C29=\"\",\"\",ROUND((C29*0.06614),1))","v":""},{"$f":"IF(D29=\"\",\"\",ROUND((D29*0.06614),1))","v":""},{"$f":"IF(E29=\"\",\"\",ROUND((E29*0.06614),1))","v":""},{"$f":"IF(F29=\"\",\"\",ROUND((F29*0.06614),1))","v":""}]
["Dry Density, L = J/(1 + F/100), in pcf",{"$f":"IF(OR(B26=\"\",B30=\"\"),\"\",ROUND((B30/(1+B26/100)),1))","v":""},{"$f":"IF(OR(C26=\"\",C30=\"\"),\"\",ROUND((C30/(1+C26/100)),1))","v":""},{"$f":"IF(OR(D26=\"\",D30=\"\"),\"\",ROUND((D30/(1+D26/100)),1))","v":""},{"$f":"IF(OR(E26=\"\",E30=\"\"),\"\",ROUND((E30/(1+E26/100)),1))","v":""},{"$f":"IF(OR(F26=\"\",F30=\"\"),\"\",ROUND((F30/(1+F26/100)),1))","v":""}]
[]
["WARNING:  Use this worksheet only when scale with pan is tared."]