{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":2,"images":0,"macros":1,"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":"Sheet1","index":0,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["2013-01-11"]
["sn 3048"]
[]
[null,"load cell calibration"]
[]
[null,"Load Cell"]
[null,"mass Pb","cnts"]
[null,100,100.1]
[null,200,200.1]
[]
[null,"Load Cell Gain"]
[null,{"$f":"(C9-C8)/(B9-B8)","v":1},"cnts/gram"]
[]
[null,"Mass SOLO in air (g)",77110,{"$f":"CONVERT(C14,\"g\",\"lbm\")","v":169.99845037075909}]
[null,"added weights",2219.5]
[null,null,{"$f":"C14+C15","v":79329.5}]
[]
[null,"Tank H20 Salinity (psu)",32.700000000000003]
[]
[null,"Data"]
[null,"P(psi)","P(dBar)","Temp(degC)","Cnts","H20 Density","SOLOII Vol","Mass"]
[null,0,10,18.27,0,{"$f":"1/Spec_Vol($C$18,D22,C22)","v":1.0234905825391052},{"$f":"( $C$16 - (E22/$B$12)-20 )/F22","v":77489.232781455285},"end"]
[null,29.4,{"$f":"B23*0.6895","v":20.2713},18.27,110,{"$f":"1/Spec_Vol($C$18,D23,C23)","v":1.0235358062894639},{"$f":"( $C$16 - (E23/$B$12)-20 )/F23","v":77378.338416039507}]
[null,0,{"$f":"B24*0.6895","v":0},18.27,0,1.0234465441312743,{"$f":"( $C$16 - (E24/$B$12) )/F24","v":77512.108917556368}]
[null,29.4,{"$f":"B25*0.6895","v":20.2713},18.27,110,1.0235358062894639,77397.878523847263]
[null,0,0,18.27,0,1.0234465441312743,77512.108917556368,{"$f":"E26/B$12+buoy($C$18,D26,C26,E$40,E$41,$G$34)","v":79321.206100775002},{"$f":"E26/B$12+buoy($C$18,D26,C26,E$40,E$41,$L$34)","v":79297.796046116404}]
[null,49.4,{"$f":"B27*0.6895","v":34.061299999999996},18.27,110,1.0235965076023879,77393.288675397198,79436.883454375929,79413.471724160889]
[null,0,{"$f":"B28*0.6895","v":0},18.27,0,1.0234465441312743,77512.108917556368,{"$f":"E28/B$12+buoy($C$18,D28,C28,E$40,E$41,$G$34)","v":79321.206100775002},{"$f":"E28/B$12+buoy($C$18,D28,C28,E$40,E$41,$L$34)","v":79297.796046116404}]
[]
[]
[]
[null,null,null,"Compressibility Calculations",null,"Volume from linear fit",null,null,null,null,"Volume using 0 pressure weight at end"]
[null,null,null,null,null,"slope (cc/db)",{"$f":"SLOPE($G26:$G28,$C26:$C28)","v":-3.4884235821642284},null,{"$f":"G33-0.005","v":-3.4934235821642283},null,"slope (cc/db)",{"$f":"SLOPE($G26:$G28,$C26:$C28)","v":-3.4884235821642284}]
[null,null,null,null,null,"v0 (from intercept)",{"$f":"INTERCEPT(G26:G28,C26:C28)","v":77512.108917556368},null,null,null,"v0 (from last weight)",{"$f":"G22","v":77489.232781455285}]
[null,null,null,null,null,"compressibillity",null,{"$f":"G33/G34","v":-4.5004885441506883E-5},{"$f":"I33/G34","v":-4.5069391491849523E-5},null,"compressibillity",null,{"$f":"L33/L34","v":-4.5018171647184993E-5}]
[]
[null,null,"Depth","Temp","Salinity","Mass","in water wt."]
[null,"target",200,8.48,34.049999999999997,{"$f":"buoy(E38,D38,C38,E$40,E$41,G34)","v":79523.685943463599},null,null,{"$f":"buoy(E38,D38,C38,E$40,E$41,L34)","v":79500.216130961941}]
[null,"weight to add",null,null,null,{"$f":"F38-H28+C15","v":2421.9798426885973},{"$f":"F39*1.1","v":2664.177826957457},null,{"$f":"I38-I28+C15","v":2421.9200848455366}]
[null,null,null,"alpha=",2.2000000000000001E-6]
[null,null,null,"beta=",8.5000000000000006E-5]
[]
[null,"Sensitivity"]
[null,null,{"$f":"C38-100","v":100},{"$f":"D38","v":8.48},{"$f":"E38","v":34.049999999999997},{"$f":"buoy(E44,D44,C44,E$40,E$41,G$34)","v":79505.997120684828},null,{"$f":"(F$38-F44)/((C$38-C44)/100)","v":17.688822778771282},"g/100db"]
[null,null,{"$f":"C38","v":200},{"$f":"D38+1","v":9.48},{"$f":"E38","v":34.049999999999997},{"$f":"buoy(E45,D45,C45,E$40,E$41,G$34)","v":79517.867814771045},null,{"$f":"(F$38-F45)/(D$38-D45)","v":-5.8181286925537279},"g/degree"]
[null,null,{"$f":"C38","v":200},{"$f":"D38","v":8.48},{"$f":"E38-1","v":33.049999999999997},{"$f":"buoy(E46,D46,C46,E$40,E$41,G$34)","v":79463.107791310496},null,{"$f":"F$38-F46/(E38-E46)","v":60.578152153102565},"g/psu"]
[null,null,{"$f":"C38","v":200},{"$f":"D38","v":8.48},{"$f":"E38","v":34.049999999999997},{"$f":"buoy(E47,D47,C47,E$40*1.1,E$41,G$34)","v":79520.182077509831},null,{"$f":"F$38-F47","v":3.5038659537676722},"g/10%alpha"]
[]
[]
[null,"surface",0,11.2,32.85,{"$f":"buoy(E50,D50,C50,E$40,E$41,G34)","v":79399.01182953587},null,null,{"$f":"buoy(E50,D50,C50,E$40,E$41,L34)","v":79375.578812085179}]
[null,"weight to add",null,null,null,{"$f":"F38-F50","v":124.67411392772919},{"$f":"210-F51","v":85.325886072270805},null,{"$f":"(C38-C50)/100*H44+(D38-D50)*H45+(E38-E50)*H46","v":123.89673818501151},{"$f":"210-I51","v":86.103261814988485}]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}