{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Ballast","G1 Shallow","G1 Deep","G2","Worksheet","Constants"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":6,"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":"Ballast","index":0,"n_rows":88,"n_cols":9,"rows_kept":88,"cut":false,"hidden":false,"merged":[[6,4,6,7],[6,0,6,3],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,20,0],[13,0,13,1],[10,0,10,7],[8,0,8,7],[9,0,9,7],[11,0,11,7],[21,0,21,1],[22,0,22,1],[44,0,44,6],[45,0,45,6],[46,0,46,6],[26,0,26,1],[27,0,27,1],[28,0,28,1],[30,0,30,1],[31,0,31,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[48,0,50,6],[51,0,52,6],[25,0,25,1],[47,0,47,6],[54,0,54,1],[55,0,55,1],[57,0,57,1],[58,0,58,1],[59,0,59,1],[79,0,79,1],[60,0,60,1],[61,0,61,2],[63,0,63,1],[65,0,65,1],[66,0,66,1],[80,0,80,1],[82,0,82,1],[84,0,84,1],[85,0,85,1],[36,3,36,4],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[37,3,37,4],[38,3,38,4],[39,3,39,4],[67,0,67,1],[76,0,76,1],[77,0,77,1],[78,0,78,1]]}
[null,null,null,null,null,null,"Document #:","4095-GBPSH"]
[null,null,null,null,null,null,"Rev:","DRAFT C"]
[null,null,null,null,null,null,"Date:","2012-07-20"]
[null,null,null,null,null,null,"ECO #:",574]
[]
[]
["Ballasting The Slocum Glider (Spreadsheet)",null,null,null,"Reference Ballasting Procedure 4095-GBP"]
[]
["1- Enter tank water temperature and either density, salinity, or conductivity"]
["2- Enter target water temperature and either density, salinity, or conductivity"]
["3- Adjust weight by amount in yellow box to go from neutrally buoyant in tank to neutrally buoyant in target water"]
["4- If you want to change anything, the password to unprotect the sheet is \"glider\""]
[]
["Glider Name:",null,"275"]
["Ballasted by:"]
["Date:",null,"2012-07-31"]
["Glider Type:",null,"G2 Shallow (200m)"]
["Add-ons (check \nbox for each bay)","G1 Shallow Science Bay (10\")"]
[null,"G1 Deep/G2 Science Bay (10\")"]
[null,"G2 Energy Bay (14.85\")"]
[null,"G2 DVL Bay (5.75\")"]
["Base Glider Displacement:",null,{"$f":"IF(C17=\"G1 Shallow (200m)\",42.973,IF(C17=\"G1 Deep (1000m)\",45.413,IF(C17=\"G2 Shallow (200m)\",46.513,IF(C17=\"G2 Deep (1000m)\",46.513,))))","v":46.512999999999998},"Liters"]
["Total Glider Displacement:",null,{"$f":"C22+SUMIF(Constants!F12:F19,\"TRUE\",Constants!E12:E19)","v":56.29954273104903},"Liters"]
[]
[null,null,"Tank Water",null,"Target Water",null,"Weight Change"]
["Temperature and",null,29.8,"oC",24,"oC",{"$f":"C23*53.5*10^-6*(E26-C26)*E32","v":-17.836539875379351},"grams",{"$f":"IF(OR(C26<-5,C26>50),\"Tank water temp out of range.  Allowable value between -5 and 50 degrees c\",IF(OR(E26<-5,E26>50),\"Target water temp out of range, allowable value between -5 and 50 degrees c\",\"\"))","v":""}]
["(Density or",null,0,"g/LoC",0,"g/LoC",null,null,{"$f":"IF(AND(OR(C27=0,ABS(C27-1000)<100),OR(E27=0,ABS(E27-1000)<100)),\"\",\"Either tank or target density out of range.  Allowable values are 0 g/L or between 900 and 1100 g/L\")","v":""}]
["Conductivity or",null,null,"s/m",0,"s/m",null,null,{"$f":"IF(OR(C28<0,C28>10),\"Tank water conductivity out of range\",IF(OR(E28<0,E28>10),\"Target water conductivity out of range\",\"\"))","v":""}]
["Salinity)",null,28.6,"pss",31.5,"pss",null,null,{"$f":"IF(OR(C29<0,C29>100),\"Tank water salinity out of range\",IF(OR(E29<0,E29>100),\"Target water salinity out of range\",\"\"))","v":""}]
[]
["Calculated/given Salinity",null,{"$f":"IF(C28,((0.008+((C26-15)/(1+0.0162*(C26-15)))*0.0005)+(SQRT(C28/(4.2914*(0.6766097+C26*(0.0200564+C26*(0.0001104259+C26*(-0.00000069698+C26*0.0000000010031)))))))*((-0.1692+((C26-15)/(1+0.0162*(C26-15)))*-0.0056)+(SQRT(C28/(4.2914*(0.6766097+C26*(0.0200564+C26*(0.0001104259+C26*(-0.00000069698+C26*0.0000000010031)))))))*((25.3851+((C26-15)/(1+0.0162*(C26-15)))*-0.0066)+(SQRT(C28/(4.2914*(0.6766097+C26*(0.0200564+C26*(0.0001104259+C26*(-0.00000069698+C26*0.0000000010031)))))))*((14.0941+((C26-15)/(1+0.0162*(C26-15)))*-0.0375)+(SQRT(C28/(4.2914*(0.6766097+C26*(0.0200564+C26*(0.0001104259+C26*(-0.00000069698+C26*0.0000000010031)))))))*((-7.0261+((C26-15)/(1+0.0162*(C26-15)))*0.0636)+(SQRT(C28/(4.2914*(0.6766097+C26*(0.0200564+C26*(0.0001104259+C26*(-0.00000069698+C26*0.0000000010031)))))))*((2.7081+((C26-15)/(1+0.0162*(C26-15)))*-0.0144))))))),C29)","v":28.6},"pss",{"$f":"IF(E28,((0.008+((E26-15)/(1+0.0162*(E26-15)))*0.0005)+(SQRT(E28/(4.2914*(0.6766097+E26*(0.0200564+E26*(0.0001104259+E26*(-0.00000069698+E26*0.0000000010031)))))))*((-0.1692+((E26-15)/(1+0.0162*(E26-15)))*-0.0056)+(SQRT(E28/(4.2914*(0.6766097+E26*(0.0200564+E26*(0.0001104259+E26*(-0.00000069698+E26*0.0000000010031)))))))*((25.3851+((E26-15)/(1+0.0162*(E26-15)))*-0.0066)+(SQRT(E28/(4.2914*(0.6766097+E26*(0.0200564+E26*(0.0001104259+E26*(-0.00000069698+E26*0.0000000010031)))))))*((14.0941+((E26-15)/(1+0.0162*(E26-15)))*-0.0375)+(SQRT(E28/(4.2914*(0.6766097+E26*(0.0200564+E26*(0.0001104259+E26*(-0.00000069698+E26*0.0000000010031)))))))*((-7.0261+((E26-15)/(1+0.0162*(E26-15)))*0.0636)+(SQRT(E28/(4.2914*(0.6766097+E26*(0.0200564+E26*(0.0001104259+E26*(-0.00000069698+E26*0.0000000010031)))))))*((2.7081+((E26-15)/(1+0.0162*(E26-15)))*-0.0144))))))),E29)","v":31.5},"pss"]
["Calculated/given Density",null,{"$f":"IF(C27,C27,(999.842594+C26*(6.793952*10^-2+C26*(-9.09529*10^-3+C26*(1.001685*10^-4+C26*(-1.120083*10^-6+C26*6.536332*10^-9)))))+C31*((0.824493+C26*(-4.0899*10^-3+C26*(7.6438*10^-5+C26*(-8.2467*10^-7+C26*5.3875*10^-9))))+(-5.72466*10^-3+C26*(1.0227*10^-4-C26*1.6546*10^-6))*SQRT(C31)+4.8314*10^-4*C31))","v":1017.0058071991768},"g/LoC",{"$f":"IF(E27,E27,(999.842594+E26*(6.793952*10^-2+E26*(-9.09529*10^-3+E26*(1.001685*10^-4+E26*(-1.120083*10^-6+E26*6.536332*10^-9)))))+E31*((0.824493+E26*(-4.0899*10^-3+E26*(7.6438*10^-5+E26*(-8.2467*10^-7+E26*5.3875*10^-9))))+(-5.72466*10^-3+E26*(1.0227*10^-4-E26*1.6546*10^-6))*SQRT(E31)+4.8314*10^-4*E31))","v":1020.9958245326125},"g/LoC",{"$f":"(E32-C32)*C23","v":224.6361513613848},"grams",{"$f":"IF(OR(C32<900,C32>1100),\"Density of tank water out of range\",IF(OR(E32<900,E32>1100),\"Density of target water out of range\",\"\"))","v":""}]
[null,null,null,null,"Total Weight Adjustment:",null,{"$f":"SUM(G26:G32)","v":206.79961148600546},"grams",{"$f":"IF(AND(I26=\"\",I32=\"\",E22=\"\"),\"\",\"One or more parameters above need to be adjusted\")","v":""}]
["Drive Weight Material"]
["Drive Weight (g)",null,{"$f":"IF(C34=\"Lead\",ABS(G33/0.912/2),IF(C34=\"Stainless Steel\",ABS(G33/0.875/2),\"\"))","v":""}]
[]
["Battery Type:",null,null,"weight (kg)"]
["Pitch Configuration",null,{"$f":"IF(C37=\"Lithium\",\"Lithium Pitch Pack\",IF(C37=\"Alkaline\",\"Alkaline Pitch Pack\",\"\"))","v":""}]
["Aft Configuration"]
["Nose Configuration"]
[]
[]
["Calculating H-moment (Roll Method)"]
[]
["1- Place well-ballasted glider in tank with wings."]
["2- Add a known amount of weight (~300 g) on one wing rail"]
["3- Attach a spring scale to the glider on the opposite wing rail"]
["4- Measure the weight change shown on the spring scale"]
["5- Measure the angle of roll that the glider undergoes due to the addition of weight. For this step you can use an inclinometer (less accurate) or have the glider on and measure compass roll before and after weight addition and measure angle difference."]
[]
[]
["6- Remove the added weight, measure weight, and multiply by 0.912 if using Lead weight or by 0.875 if the weight used is stainless steel. This factor accounts for buoyancy provided by water on material."]
[]
[]
["Roll Start",null,0,"radians",{"$f":"IF(ABS(C55<1.25),\"\",\"Error: starting roll too high.  Re-check.\")","v":""}]
["Roll End",null,0,"radians",{"$f":"IF(ABS(C56<1.25),\"\",\"Error: ending roll too high. Re-check.\")","v":""}]
[]
["Weight on Spring",null,0,"grams",{"$f":"IF(C58<0,\"Error: Weight should be positive\",IF(C58>2000,\"Error, weight seems to be too high.\",\"\"))","v":""}]
["Weight added on wing rail",null,0,"grams",{"$f":"IF(C59<0,\"Error: Weight should be positive\",IF(C59>2000,\"Error, weight seems to be too high.\",\"\"))","v":""}]
["Angle of Rotation",null,{"$f":"(C56-C55)/(PI()/180)","v":0},"degrees"]
["Radius of Hull + \nDistance to Weight",null,107,"mm",{"$f":"IF(C61<107,\"Error: distance should be greater than radius of hull\",IF(C61>600,\"Error: distance too high.\",\"\"))","v":""}]
["(radius of hull: 200m=107, 1000m=110)"]
[]
["H-distance",null,{"$f":"((C58+C59)*C61)/(C23*1000*TAN(C60*(PI()/180)))","v":{"$error":"#DIV/0!"}},"mm"]
[]
["Weight of Pitch Battery",null,{"$f":"D38","v":0},"kg",{"$f":"IF(C66<4,\"Error: weight of pitch battery too low. Re-check\",IF(C66>12,\"Error: weight of pitch battery too high.  Re-check.\",\"\"))","v":"Error: weight of pitch battery too low. Re-check"}]
["Total range of \nPitch Battery (+/- in)",null,1,"inches",{"$f":"IF(C67=1,\"\",\"Error: range of pitch battery is usually +/- 1 inch\")","v":""}]
["Pitch Range",null,{"$f":"DEGREES(ATAN((C66*25.4*C67/C22)/C64))","v":{"$error":"#DIV/0!"}},"Degrees"]
[]
["Calculating H-moment (Pitch Battery method)"]
[]
["1- Put battery position (c_battpos) at about .25, ensure front of glider is not touching bottom of tank- adjust as necessary"]
["2- Record m_pitch and m_battpos"]
["3- Put battery position at 0"]
["4- Record m_pitch and m_battpos"]
[]
["Weight of Pitch Battery",null,{"$f":"D38","v":0},"kg",{"$f":"IF(C77<4,\"Error: weight of pitch battery too low. Re-check\",IF(C77>12,\"Error: weight of pitch battery too high.  Re-check.\",\"\"))","v":"Error: weight of pitch battery too low. Re-check"}]
["Pitch_1",null,0,"radians",{"$f":"IF(ABS(C78<1.25),\"\",\"Error: starting pitch too high.  Re-check.\")","v":""}]
["Battery Position_1",null,0,"inches",{"$f":"IF(ABS(C79)>1.1,\"Error, battery position out of range\",\"\")","v":""}]
["Pitch_2",null,0,"radians",{"$f":"IF(ABS(C80<1.25),\"\",\"Error: starting pitch too high.  Re-check.\")","v":""}]
["Battery Position_2",null,0,"inches",{"$f":"IF(ABS(C81)>1.1,\"Error, battery position out of range\",\"\")","v":""}]
[]
["H-Distance",null,{"$f":"ABS(1000*25.4*(C79-C81)*(C77+0.1)/(C23*C32*TAN(C78-C80)))","v":{"$error":"#DIV/0!"}},"mm"]
[]
["Total range of \nPitch Battery (+/- in)",null,1,"inches",{"$f":"IF(C85=1,\"\",\"Error: range of pitch battery is usually +/- 1 inch\")","v":""}]
["Pitch Range",null,{"$f":"DEGREES(ATAN((C85*25.4*C77/C22)/C83))","v":{"$error":"#DIV/0!"}},"Degrees"]
[]
[null,null,null,"Sign:",null,"Date:"]

{"sheet":"G1 Shallow","index":1,"n_rows":75,"n_cols":6,"rows_kept":75,"cut":false,"hidden":false,"merged":[[71,0,71,3],[72,0,72,3],[66,0,66,3],[67,0,67,3],[68,0,68,3],[69,0,69,3],[70,0,70,3]]}
[null,null,null,"Document #:",{"$f":"Ballast!$H$1","v":"4095-GBPSH"}]
[null,null,null,"Rev:",{"$f":"Ballast!$H$2","v":"DRAFT C"}]
[null,null,null,"Date:",{"$f":"Ballast!$H$3","v":"2012-07-20"}]
[null,null,null,"ECO #:",{"$f":"Ballast!$H$4","v":574}]
[]
[]
["Glider:",{"$f":"Ballast!C14","v":"275"}]
["Date:",{"$f":"Ballast!C16","v":"2012-07-31"}]
[]
["Scale readings and setup:"]
[null,"Fwd Scale reading:",0,"grams",{"$f":"IF(C11>5000,\"Error: scale reading too high\",IF(C11<0,\"Error: scale reading should be positive\",\"\"))","v":""}]
[null,"Aft Scale reading:",0,"grams",{"$f":"IF(C12>5000,\"Error: scale reading too high\",IF(C12<0,\"Error: scale reading should be positive\",\"\"))","v":""}]
[null,"Adjustment from ballasting sheet:",{"$f":"Ballast!G33","v":206.79961148600546},"grams"]
[null,{"$f":"IF((C11+C12-C13)>0,\"Total weight to remove:\",\"Total weight to add:\")","v":"Total weight to add:"},{"$f":"ABS(C11+C12-C13)","v":206.79961148600546},"grams"]
[]
[null,"From fwd hull","From center of buoyancy"]
[null,"(inches)","(inches)"]
["Fwd scale position",1,{"$f":"B18-$C$24","v":-21.7},null,{"$f":"IF(B18<-10,\"Error: Check scale position\",IF(B18>30, \"Error, check scale position\",\"\"))","v":""}]
["Aft scale position",47,{"$f":"B19-$C$24","v":24.3},null,{"$f":"IF(B19<20,\"Error: Check scale position\",IF(B19>70, \"Error, check scale position\",\"\"))","v":""}]
[]
[null,"Off from center of buoyancy by this much:",{"$f":"(C11*C18)+(C12*C19)","v":0},"inchgrams"]
[null,null,null,null,null,"Notes:"]
["Coordinate Setup:",null,null,null,null,"Red numbers indicate measured constants that will affect results."]
[null,"Center of Buoyancy:",22.7,null,null,"The reference point everything is measured from is the forward edge of the forward hull."]
[null,null,null,null,null,"Coordinates of forward top and bottom bottles was measured with heavy end of bottle forward"]
["Weight Position","Dist from fwd hull","From CoB",null,null,"Depending on which hole is used to bolt weight to the weight bar, coordinates of sci fwd disc"]
[null,"(inches)","(inches)",null,null,"and sci aft disc will need to be adjusted."]
["Forward top",2,{"$f":"B28-C$24","v":-20.7}]
["Forward bottom",3.5,-19.2]
["Sci fwd bottles",20.125,-2.5749999999999993]
["Sci fwd disc",22,-0.69999999999999929]
["Center",{"$f":"C24","v":22.7},0]
["Sci aft disc",26,3.3000000000000007]
["Sci aft bottles",{"$f":"27+15/16","v":27.9375},5.2375000000000007]
["Aft",46.875,24.175000000000001]
[]
["Weight adjustment section:"]
[]
["Zero if spot unavailable","Position:","Weight adjustment","Center of Mass adjustment","Final"]
["One if spot available",null,"(grams)","(inchgrams)","Weight"]
[1,{"$f":"A28","v":"Forward top"},0,{"$f":"C28*C41","v":0},null,{"$f":"IF(ABS(C41)>5000,\"Error: Weight adjustment too high\",\"\")","v":""}]
[0,"Forward bottom",0,0,null,""]
[0,"Sci fwd bottles",0,0,null,""]
[0,"Sci fwd disc",0,0,null,""]
[0,"Center",0,0,null,""]
[0,"Sci aft disc",0,0,null,""]
[0,"Sci aft bottles",0,0,null,""]
[1,"Aft",0,0,null,""]
[null,null,{"$f":"SUM(C41:C48)","v":0},{"$f":"SUM(D41:D48)","v":0},null,""]
[]
["Weight adjustment calculation:"]
[null,{"$f":"ABS((C11+C12-C13)+C49)","v":206.79961148600546},{"$f":"IF(((C11+C12-C13)+C49)>=0,\"additional grams need to be removed\", \"additional grams need to be added\")","v":"additional grams need to be added"}]
[null,{"$f":"ABS((C21+D49)/(B64-B63))","v":0},{"$f":"CONCATENATE(\"Grams need to move from \",IF((C21+D49)<=0,INDEX(A28:A35,B60,1),INDEX(A28:A35,B61,1)),\" to \",IF((C21+D49)<=0,INDEX(A28:A35,B61,1),INDEX(A28:A35,B60,1)))","v":"Grams need to move from Forward top to Aft"}]
[null,{"$f":"INDEX(C41:C48,IF(A41,1,IF(A42,2,IF(A43,3,IF(A44,4,IF(A45,5,IF(A46,6,IF(A47,7,\"Error\"))))))))+(C21+D49)/(INDEX(C28:C35,IF(A48,8,IF(A47,7,IF(A46,6,IF(A45,5,IF(A44,4,IF(A43,3,IF(A42,2,\"error\"))))))))-INDEX(C28:C35,IF(A41,1,IF(A42,2,IF(A43,3,IF(A44,4,IF(A45,5,IF(A46,6,IF(A47,7,\"Error\")))))))))","v":0},{"$f":"CONCATENATE(\"Change \",INDEX(A28:A35,B60,1),\" to this:\")","v":"Change Forward top to this:"},null,null,"<-- when this change is made, the number below will be affected.  It is necessary "]
[null,{"$f":"INDEX(C41:C48,IF(A48,8,IF(A47,7,IF(A46,6,IF(A45,5,IF(A44,4,IF(A43,3,IF(A42,2,\"error\"))))))))-((C21+D49)/(INDEX(C28:C35,IF(A48,8,IF(A47,7,IF(A46,6,IF(A45,5,IF(A44,4,IF(A43,3,IF(A42,2,\"error\"))))))))-INDEX(C28:C35,IF(A41,1,IF(A42,2,IF(A43,3,IF(A44,4,IF(A45,5,IF(A46,6,IF(A47,7,\"Error\"))))))))))","v":0},{"$f":"CONCATENATE(\"Change \",INDEX(A28:A35,B61,1),\" to this:\")","v":"Change Aft to this:"},null,null,"to record both numbers so they can both be changed to the correct value."]
[]
[]
[]
["Temporary stuff that is needed because excel limits me to 7 nested functions:"]
[null,{"$f":"IF(A41,1,IF(A42,2,IF(A43,3,IF(A44,4,IF(A45,5,IF(A46,6,IF(A47,7,\"Error\")))))))","v":1},"row of first spot"]
[null,{"$f":"IF(A48,8,IF(A47,7,IF(A46,6,IF(A45,5,IF(A44,4,IF(A43,3,IF(A42,2,\"error\")))))))","v":8},"row of second spot"]
[]
[null,{"$f":"INDEX(C28:C35,IF(A41,1,IF(A42,2,IF(A43,3,IF(A44,4,IF(A45,5,IF(A46,6,IF(A47,7,\"Error\"))))))))","v":-20.7},"pos of first spot"]
[null,{"$f":"INDEX(C28:C35,IF(A48,8,IF(A47,7,IF(A46,6,IF(A45,5,IF(A44,4,IF(A43,3,IF(A42,2,\"error\"))))))))","v":24.175000000000001},"pos of second spot"]
[]
["Instructions:"]
["1- Put glider in tank and attach scales, recording the point of attachment in scale setup section."]
["2- Record readings on scales in cells C5 and C6.  If glider is light, temporarily add  an external known weight to the centerpoint of the glider.  If weight is temporarily added, enter the removal of the weight as an adjustment in cell C39.  (If the weight in water of the weight is 500g, removing this weight will be a -500g adjustment, so enter  -500 in cell C39)"]
["3- Looking at cell B46, the necessary weight adjustment to the glider, decide which positions you will be able to add/remove weight from, and enter weight adjustments in cells C35-C42 until no more weight needs to be added or subtracted.  Use judgement to determine where to add/subtract weight from.  If the front of the glider is heavy, you want to remove weight from the front of the glider."]
["4- Only after cell B46 reads zero (no more weight adjustments are needed), determine the exact distribution of weight by putting a \"1\" in each cell, A35-A42, where the corresponding position in cell B35-B42 is available.  For example, if weight needs to be moved forward but the forward bottles are full, enter a \"0\".  If they have room to add weight, enter a \"1\"."]
["5- In doing the weight adjustment calculation, the spreadsheet will select the furthest forward and furthest aft positions that are \"available\" (as indicated in column A), and calculate how much weight needs to be moved between these two positions, which can be seen in cell B47.  If the value shown is greater than the amount that can physically be moved, that's okay, change the weight adjustment cells to reflect the amount of weight you can actually move, and change the 1 to a 0 to reflect that the spot is no longer available.  For example, if the spreadsheet tells you to move 1500g from sci fwd to sci aft, but you only have 500g in sci fwd, reduce the sci fwd weight adjustment by 500g, increase the sci aft weight adjustment by 500g, and change the 1 to a 0 in the cell corresponding to sci fwd availibility."]
["6- Repeat step 5 until no more weight needs to move within the glider (cell B47 will be zero).  As you repeat step 5 and change the weight adjustment numbers, you need to ensure that the TOTAL weight adjustment remains at the appropriate value."]
["7- Remove glider from tank and make weight adjustments.  Put glider back in tank.  Clear weight adjustment cells and scale reading cells.  Repeat step 2 and check ballasting."]
[]
["If you want to change anything, the password to unprotect the sheet is \"glider\""]

{"sheet":"G1 Deep","index":2,"n_rows":75,"n_cols":6,"rows_kept":75,"cut":false,"hidden":false,"merged":[[72,0,72,3],[66,0,66,3],[67,0,67,3],[68,0,68,3],[69,0,69,3],[70,0,70,3],[71,0,71,3]]}
[null,null,null,"Document #:",{"$f":"Ballast!$H$1","v":"4095-GBPSH"}]
[null,null,null,"Rev:",{"$f":"Ballast!$H$2","v":"DRAFT C"}]
[null,null,null,"Date:",{"$f":"Ballast!$H$3","v":"2012-07-20"}]
[null,null,null,"ECO #:",{"$f":"Ballast!$H$4","v":574}]
[]
[]
["Glider:",{"$f":"Ballast!C14","v":"275"}]
["Date:",{"$f":"Ballast!C16","v":"2012-07-31"}]
[]
["Scale readings and setup:"]
[null,"Fwd Scale reading:",0,"grams",{"$f":"IF(C11>5000,\"Error: scale reading too high\",IF(C11<0,\"Error: scale reading should be positive\",\"\"))","v":""}]
[null,"Aft Scale reading:",0,"grams",{"$f":"IF(C12>5000,\"Error: scale reading too high\",IF(C12<0,\"Error: scale reading should be positive\",\"\"))","v":""}]
[null,"Adjustment from ballasting sheet:",{"$f":"Ballast!G33","v":206.79961148600546},"grams"]
[null,{"$f":"IF((C11+C12-C13)>0,\"Total weight to remove:\",\"Total weight to add:\")","v":"Total weight to add:"},{"$f":"ABS(C11+C12-C13)","v":206.79961148600546},"grams"]
[]
[null,"From fwd hull","From center of buoyancy"]
[null,"(inches)","(inches)"]
["Fwd scale position",1,{"$f":"B18-$C$24","v":-22},null,{"$f":"IF(B18<-10,\"Error: Check scale position\",IF(B18>30, \"Error, check scale position\",\"\"))","v":""}]
["Aft scale position",47.5,{"$f":"B19-$C$24","v":24.5},null,{"$f":"IF(B19<20,\"Error: Check scale position\",IF(B19>70, \"Error, check scale position\",\"\"))","v":""}]
[]
[null,"Off from center of buoyancy by this much:",{"$f":"(C11*C18)+(C12*C19)","v":0},"inchgrams"]
[null,null,null,null,null,"Notes:"]
["Coordinate Setup:",null,null,null,null,"Red numbers indicate measured constants that will affect results."]
[null,"Center of Buoyancy:",23,null,null,"The reference point everything is measured from is the forward edge of the forward hull."]
[null,null,null,null,null,"Coordinates of forward top and bottom bottles was measured with heavy end of bottle forward"]
["Weight Position","Dist from fwd hull","From CoB",null,null,"Depending on which hole is used to bolt weight to the weight bar, coordinates of sci fwd disc"]
[null,"(inches)","(inches)",null,null,"and sci aft disc will need to be adjusted."]
["Forward",2,{"$f":"B28-C$24","v":-21}]
["unused",9999,9976]
["Sci fwd bottles",20.375,-2.625]
["Sci fwd disc",22.125,-0.875]
["Center",23,0]
["Sci aft disc",26.5,3.5]
["Sci aft bottles",28.375,5.375]
["Aft",47.5,24.5]
[]
["Weight adjustment section:"]
[]
["Zero if spot unavailable","Position:","Weight adjustment","Center of Mass adjustment","Final"]
["One if spot available",null,"(grams)","(inchgrams)","Weight"]
[0,{"$f":"A28","v":"Forward"},0,{"$f":"C28*C41","v":0},null,{"$f":"IF(ABS(C41)>5000,\"Error: Weight adjustment too high\",\"\")","v":""}]
[0,"unused",0,0,null,""]
[1,"Sci fwd bottles",0,0,null,""]
[1,"Sci fwd disc",0,0,null,""]
[1,"Center",0,0,null,""]
[1,"Sci aft disc",0,0,null,""]
[1,"Sci aft bottles",0,0,null,""]
[1,"Aft",0,0,null,""]
[null,null,{"$f":"SUM(C41:C48)","v":0},{"$f":"SUM(D41:D48)","v":0},null,""]
[]
["Weight adjustment calculation:"]
[null,{"$f":"ABS((C11+C12-C13)+C49)","v":206.79961148600546},{"$f":"IF(((C11+C12-C13)+C49)>=0,\"additional grams need to be removed\", \"additional grams need to be added\")","v":"additional grams need to be added"}]
[null,{"$f":"ABS((C21+D49)/(B64-B63))","v":0},{"$f":"CONCATENATE(\"Grams need to move from \",IF((C21+D49)<=0,INDEX(A28:A35,B60,1),INDEX(A28:A35,B61,1)),\" to \",IF((C21+D49)<=0,INDEX(A28:A35,B61,1),INDEX(A28:A35,B60,1)))","v":"Grams need to move from Sci fwd bottles to Aft"}]
[null,{"$f":"INDEX(C41:C48,IF(A41,1,IF(A42,2,IF(A43,3,IF(A44,4,IF(A45,5,IF(A46,6,IF(A47,7,\"Error\"))))))))+(C21+D49)/(INDEX(C28:C35,IF(A48,8,IF(A47,7,IF(A46,6,IF(A45,5,IF(A44,4,IF(A43,3,IF(A42,2,\"error\"))))))))-INDEX(C28:C35,IF(A41,1,IF(A42,2,IF(A43,3,IF(A44,4,IF(A45,5,IF(A46,6,IF(A47,7,\"Error\")))))))))","v":0},{"$f":"CONCATENATE(\"Change \",INDEX(A28:A35,B60,1),\" to this:\")","v":"Change Sci fwd bottles to this:"},null,null,"<-- when this change is made, the number below will be affected.  It is necessary "]
[null,{"$f":"INDEX(C41:C48,IF(A48,8,IF(A47,7,IF(A46,6,IF(A45,5,IF(A44,4,IF(A43,3,IF(A42,2,\"error\"))))))))-((C21+D49)/(INDEX(C28:C35,IF(A48,8,IF(A47,7,IF(A46,6,IF(A45,5,IF(A44,4,IF(A43,3,IF(A42,2,\"error\"))))))))-INDEX(C28:C35,IF(A41,1,IF(A42,2,IF(A43,3,IF(A44,4,IF(A45,5,IF(A46,6,IF(A47,7,\"Error\"))))))))))","v":0},{"$f":"CONCATENATE(\"Change \",INDEX(A28:A35,B61,1),\" to this:\")","v":"Change Aft to this:"},null,null,"to record both numbers so they can both be changed to the correct value."]
[]
[]
[]
["Temporary stuff that is needed because excel limits me to 7 nested functions:"]
[null,{"$f":"IF(A41,1,IF(A42,2,IF(A43,3,IF(A44,4,IF(A45,5,IF(A46,6,IF(A47,7,\"Error\")))))))","v":3},"row of first spot"]
[null,{"$f":"IF(A48,8,IF(A47,7,IF(A46,6,IF(A45,5,IF(A44,4,IF(A43,3,IF(A42,2,\"error\")))))))","v":8},"row of second spot"]
[]
[null,{"$f":"INDEX(C28:C35,IF(A41,1,IF(A42,2,IF(A43,3,IF(A44,4,IF(A45,5,IF(A46,6,IF(A47,7,\"Error\"))))))))","v":-2.625},"pos of first spot"]
[null,{"$f":"INDEX(C28:C35,IF(A48,8,IF(A47,7,IF(A46,6,IF(A45,5,IF(A44,4,IF(A43,3,IF(A42,2,\"error\"))))))))","v":24.5},"pos of second spot"]
[]
["Instructions:"]
["1- Put glider in tank and attach scales, recording the point of attachment in scale setup section."]
["2- Record readings on scales in cells C5 and C6.  If glider is light, temporarily add  an external known weight to the centerpoint of the glider.  If weight is temporarily added, enter the removal of the weight as an adjustment in cell C39.  (If the weight in water of the weight is 500g, removing this weight will be a -500g adjustment, so enter -500 in cell C39)"]
["3- Looking at cell B46, the necessary weight adjustment to the glider, decide which positions you will be able to add/remove weight from, and enter weight adjustments in cells C35-C42 until no more weight needs to be added or subtracted.  Use judgement to determine where to add/subtract weight from.  If the front of the glider is heavy, you want to remove weight from the front of the glider."]
["4- Only after cell B46 reads zero (no more weight adjustments are needed), determine the exact distribution of weight by putting a \"1\" in each cell, A35-A42, where the corresponding position in cell B35-B42 is available.  For example, if weight needs to be moved forward but the forward bottles are full, enter a \"0\".  If they have room to add weight, enter a \"1\"."]
["5- In doing the weight adjustment calculation, the spreadsheet will select the furthest forward and furthest aft positions that are \"available\" (as indicated in column A), and calculate how much weight needs to be moved between these two positions, which can be seen in cell B47.  If the value shown is greater than the amount that can physically be moved, that's okay, change the weight adjustment cells to reflect the amount of weight you can actually move, and change the 1 to a 0 to reflect that the spot is no longer available.  For example, if the spreadsheet tells you to move 1500g from sci fwd to sci aft, but you only have 500g in sci fwd, reduce the sci fwd weight adjustment by 500g, increase the sci aft weight adjustment by 500g, and change the 1 to a 0 in the cell corresponding to sci fwd availibility."]
["6- Repeat step 5 until no more weight needs to move within the glider (cell B47 will be zero).  As you repeat step 5 and change the weight adjustment numbers, you need to ensure that the TOTAL weight adjustment remains at the appropriate value."]
["7- Remove glider from tank and make weight adjustments.  Put glider back in tank.  Clear weight adjustment cells and scale reading cells.  Repeat step 2 and check ballasting."]
[]
["If you want to change anything, the password to unprotect the sheet is \"glider\""]

{"sheet":"G2","index":3,"n_rows":75,"n_cols":6,"rows_kept":75,"cut":false,"hidden":false,"merged":[[70,0,70,3],[71,0,71,3],[72,0,72,3],[66,0,66,3],[67,0,67,3],[68,0,68,3],[69,0,69,3]]}
[null,null,null,"Document #:",{"$f":"Ballast!$H$1","v":"4095-GBPSH"}]
[null,null,null,"Rev:",{"$f":"Ballast!$H$2","v":"DRAFT C"}]
[null,null,null,"Date:",{"$f":"Ballast!$H$3","v":"2012-07-20"}]
[null,null,null,"ECO #:",{"$f":"Ballast!$H$4","v":574}]
[]
[]
["Glider:",{"$f":"Ballast!C14","v":"275"}]
["Date:",{"$f":"Ballast!C16","v":"2012-07-31"}]
[]
["Scale readings and setup:"]
[null,"Fwd Scale reading:",0,"grams",{"$f":"IF(C11>5000,\"Error: scale reading too high\",IF(C11<0,\"Error: scale reading should be positive\",\"\"))","v":""}]
[null,"Aft Scale reading:",0,"grams",{"$f":"IF(C12>5000,\"Error: scale reading too high\",IF(C12<0,\"Error: scale reading should be positive\",\"\"))","v":""}]
[null,"Adjustment from ballasting sheet:",{"$f":"Ballast!G33","v":206.79961148600546},"grams"]
[null,{"$f":"IF((C11+C12-C13)>0,\"Total weight to remove:\",\"Total weight to add:\")","v":"Total weight to add:"},{"$f":"ABS(C11+C12-C13)","v":206.79961148600546},"grams"]
[]
[null,"From fwd hull","From center of buoyancy"]
[null,"(inches)","(inches)"]
["Fwd scale position",1,{"$f":"B18-$C$24","v":-22},null,{"$f":"IF(B18<-10,\"Error: Check scale position\",IF(B18>30, \"Error, check scale position\",\"\"))","v":""}]
["Aft scale position",49,{"$f":"B19-$C$24","v":26},null,{"$f":"IF(B19<20,\"Error: Check scale position\",IF(B19>70, \"Error, check scale position\",\"\"))","v":""}]
[]
[null,"Off from center of buoyancy by this much:",{"$f":"(C11*C18)+(C12*C19)","v":0},"inchgrams"]
[null,null,null,null,null,"Notes:"]
["Coordinate Setup:",null,null,null,null,"Red numbers indicate measured constants that will affect results."]
[null,"Center of Buoyancy:",23,null,null,"The reference point everything is measured from is the forward edge of the forward hull."]
[null,null,null,null,null,"Coordinates of forward top and bottom bottles was measured with heavy end of bottle forward"]
["Weight Position","Dist from fwd hull","From CoB",null,null,"Depending on which hole is used to bolt weight to the weight bar, coordinates of sci fwd disc"]
[null,"(inches)","(inches)",null,null,"and sci aft disc will need to be adjusted."]
["Forward",2,{"$f":"B28-C$24","v":-21}]
["Nose Weights",2.125,-20.875]
["Sci fwd plates",19.5,-3.5]
["Sci fwd disc(unused)",9999,9976]
["Center",23.75,0.75]
["Sci aft disc(unused)",9999,9976]
["Sci aft plates",30.5,7.5]
["Aft",49.5,26.5]
[]
["Weight adjustment section:"]
[]
["Zero if spot unavailable","Position:","Weight adjustment","Center of Mass adjustment","Final"]
["One if spot available",null,"(grams)","(inchgrams)","Weight"]
[1,{"$f":"A28","v":"Forward"},0,{"$f":"C28*C41","v":0},null,{"$f":"IF(ABS(C41)>5000,\"Error: Weight adjustment too high\",\"\")","v":""}]
[0,"Nose Weights",0,0,null,""]
[1,"Sci fwd plates",0,0,null,""]
[0,"Sci fwd disc(unused)",0,0,null,""]
[1,"Center",0,0,null,""]
[0,"Sci aft disc(unused)",0,0,null,""]
[1,"Sci aft plates",0,0,null,""]
[1,"Aft",0,0,null,""]
[null,null,{"$f":"SUM(C41:C48)","v":0},{"$f":"SUM(D41:D48)","v":0},null,""]
[]
["Weight adjustment calculation:"]
[null,{"$f":"ABS((C11+C12-C13)+C49)","v":206.79961148600546},{"$f":"IF(((C11+C12-C13)+C49)>=0,\"additional grams need to be removed\", \"additional grams need to be added\")","v":"additional grams need to be added"}]
[null,{"$f":"ABS((C21+D49)/(B64-B63))","v":0},{"$f":"CONCATENATE(\"Grams need to move from \",IF((C21+D49)<=0,INDEX(A28:A35,B60,1),INDEX(A28:A35,B61,1)),\" to \",IF((C21+D49)<=0,INDEX(A28:A35,B61,1),INDEX(A28:A35,B60,1)))","v":"Grams need to move from Forward to Aft"}]
[null,{"$f":"INDEX(C41:C48,IF(A41,1,IF(A42,2,IF(A43,3,IF(A44,4,IF(A45,5,IF(A46,6,IF(A47,7,\"Error\"))))))))+(C21+D49)/(INDEX(C28:C35,IF(A48,8,IF(A47,7,IF(A46,6,IF(A45,5,IF(A44,4,IF(A43,3,IF(A42,2,\"error\"))))))))-INDEX(C28:C35,IF(A41,1,IF(A42,2,IF(A43,3,IF(A44,4,IF(A45,5,IF(A46,6,IF(A47,7,\"Error\")))))))))","v":0},{"$f":"CONCATENATE(\"Change \",INDEX(A28:A35,B60,1),\" to this:\")","v":"Change Forward to this:"},null,null,"<-- when this change is made, the number below will be affected.  It is necessary "]
[null,{"$f":"INDEX(C41:C48,IF(A48,8,IF(A47,7,IF(A46,6,IF(A45,5,IF(A44,4,IF(A43,3,IF(A42,2,\"error\"))))))))-((C21+D49)/(INDEX(C28:C35,IF(A48,8,IF(A47,7,IF(A46,6,IF(A45,5,IF(A44,4,IF(A43,3,IF(A42,2,\"error\"))))))))-INDEX(C28:C35,IF(A41,1,IF(A42,2,IF(A43,3,IF(A44,4,IF(A45,5,IF(A46,6,IF(A47,7,\"Error\"))))))))))","v":0},{"$f":"CONCATENATE(\"Change \",INDEX(A28:A35,B61,1),\" to this:\")","v":"Change Aft to this:"},null,null,"to record both numbers so they can both be changed to the correct value."]
[]
[]
[]
["Temporary stuff that is needed because excel limits me to 7 nested functions:"]
[null,{"$f":"IF(A41,1,IF(A42,2,IF(A43,3,IF(A44,4,IF(A45,5,IF(A46,6,IF(A47,7,\"Error\")))))))","v":1},"row of first spot"]
[null,{"$f":"IF(A48,8,IF(A47,7,IF(A46,6,IF(A45,5,IF(A44,4,IF(A43,3,IF(A42,2,\"error\")))))))","v":8},"row of second spot"]
[]
[null,{"$f":"INDEX(C28:C35,IF(A41,1,IF(A42,2,IF(A43,3,IF(A44,4,IF(A45,5,IF(A46,6,IF(A47,7,\"Error\"))))))))","v":-21},"pos of first spot"]
[null,{"$f":"INDEX(C28:C35,IF(A48,8,IF(A47,7,IF(A46,6,IF(A45,5,IF(A44,4,IF(A43,3,IF(A42,2,\"error\"))))))))","v":26.5},"pos of second spot"]
[]
["Instructions:"]
["1- Put glider in tank and attach scales, recording the point of attachment in scale setup section."]
["2- Record readings on scales in cells C5 and C6.  If glider is light, temporarily add  an external known weight to the centerpoint of the glider.  If weight is temporarily added, enter the removal of the weight as an adjustment in cell C39.  (If the weight in water of the weight is 500g, removing this weight will be a -500g adjustment, so enter -500 in cell C39)"]
["3- Looking at cell B46, the necessary weight adjustment to the glider, decide which positions you will be able to add/remove weight from, and enter weight adjustments in cells C35-C42 until no more weight needs to be added or subtracted.  Use judgement to determine where to add/subtract weight from.  If the front of the glider is heavy, you want to remove weight from the front of the glider."]
["4- Only after cell B46 reads zero (no more weight adjustments are needed), determine the exact distribution of weight by putting a \"1\" in each cell, A35-A42, where the corresponding position in cell B35-B42 is available.  For example, if weight needs to be moved forward but the forward bottles are full, enter a \"0\".  If they have room to add weight, enter a \"1\"."]
["5- In doing the weight adjustment calculation, the spreadsheet will select the furthest forward and furthest aft positions that are \"available\" (as indicated in column A), and calculate how much weight needs to be moved between these two positions, which can be seen in cell B47.  If the value shown is greater than the amount that can physically be moved, that's okay, change the weight adjustment cells to reflect the amount of weight you can actually move, and change the 1 to a 0 to reflect that the spot is no longer available.  For example, if the spreadsheet tells you to move 1500g from sci fwd to sci aft, but you only have 500g in sci fwd, reduce the sci fwd weight adjustment by 500g, increase the sci aft weight adjustment by 500g, and change the 1 to a 0 in the cell corresponding to sci fwd availibility."]
["6- Repeat step 5 until no more weight needs to move within the glider (cell B47 will be zero).  As you repeat step 5 and change the weight adjustment numbers, you need to ensure that the TOTAL weight adjustment remains at the appropriate value."]
["7- Remove glider from tank and make weight adjustments.  Put glider back in tank.  Clear weight adjustment cells and scale reading cells.  Repeat step 2 and check ballasting."]
[]
["If you want to change anything, the password to unprotect the sheet is \"glider\""]

{"sheet":"Worksheet","index":4,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[[42,7,42,8],[42,9,42,10],[37,0,37,6],[41,6,41,7],[41,10,41,11],[43,7,43,8],[43,9,43,10],[44,9,44,10],[45,7,45,8],[45,9,45,10]]}
[null,null,null,null,"Document #:",{"$f":"Ballast!$H$1","v":"4095-GBPSH"}]
[null,null,null,null,"Rev:",{"$f":"Ballast!$H$2","v":"DRAFT C"}]
[null,null,null,null,"Date:",{"$f":"Ballast!$H$3","v":"2012-07-20"}]
[null,null,null,null,"ECO #:",{"$f":"Ballast!$H$4","v":574}]
[]
[]
["Glider Ballast Worksheet"]
[]
["Ballasting Technician:",{"$f":"Ballast!$C$15","v":0}]
["Date:",{"$f":"Ballast!$C$16","v":"2012-07-31"}]
["Glider Displacement (L):",{"$f":"Ballast!C23","v":56.29954273104903}]
["H-Moment (mm):",{"$f":"Ballast!C83","v":{"$error":"#DIV/0!"}}]
[]
["TANK WATER:",null,null,null,"TARGET WATER"]
["Temperature (°C):",{"$f":"Ballast!C26","v":29.8},null,null,"Temperature (°C):",{"$f":"Ballast!E26","v":24}]
["Conductivity (S/m):",{"$f":"Ballast!C28","v":0},null,null,"Conductivity (S/m):",{"$f":"Ballast!E28","v":0}]
["Salinity (psu):",{"$f":"Ballast!C31","v":28.6},null,null,"Salinity (psu):",{"$f":"Ballast!E31","v":31.5}]
["Density (g/L°C):",{"$f":"Ballast!C32","v":1017.0058071991768},null,null,"Density (g/L°C):",{"$f":"Ballast!E32","v":1020.9958245326125}]
[]
["Pie Weight Locations"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Pie weights can be removed or shifted around to indicate exact location of placement. The quantity can also be changed to represent stacked pie weights."]
[]
["Final Weight Configuration As Sent to Customer"]
[]
["Forward","Weight (g)","Payload","Weight (g)","Aft","Weight (g)"]
["Port Bottle",null,"Top FWD",null,"Aft Bottle"]
["STBD Bottle"," ","Bottom FWD"]
["Bottom Bottle",null,"Top AFT"]
[null,null,"Bottom AFT"]
[null,null,"Weight Bar"]

{"sheet":"Constants","index":5,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":true,"merged":[[9,3,9,4],[9,2,10,2],[9,5,10,5],[9,1,10,1]]}
[]
[null,"Glider Types","Glider Displacements","Extended Bay Types","Battery Types","Aft Configurations","Nose Configurations","Drive Weight Type"]
[null,"G1 Shallow (200m)",{"$f":"52-E14","v":42.213457268950961},"Extended Science Bay","Alkaline","9 pack aft","0 pack nose","Stainless Steel"]
[null,"G1 Deep (1000m)",{"$f":"55.2-E12","v":46.172531987193494},"Extended Energy Bay","Lithium","10 pack aft","1 pack nose","Lead"]
[null,"G2 Shallow (200m)",{"$f":"56.3-$E$12","v":47.272531987193489},"DVL Science Bay",null,"11 pack aft","2 pack nose"]
[null,"G2 Deep (1000m)",{"$f":"56.3-$E$12","v":47.272531987193489},null,null,"12 pack aft"]
[null,null,null,null,null,"Lithium aft pack"]
[]
[]
[null,null,"length of add'l bay (inches)","Volume of Additional Bay",null,"Installed"]
[null,null,null,"in^3","L"]
[null,"sci (G1 shallow)",10,{"$f":"C12*(8.375/2)^2*PI()","v":550.88318054549143},{"$f":"D12/61.023","v":9.027468012806505},false]
[null,"sci (G1 shallow)",10,{"$f":"C13*(8.375/2)^2*PI()","v":550.88318054549143},9.027468012806505,false]
[null,"sci (G1 deep & G2 shallow)",10,{"$f":"C14*(8.72/2)^2*PI()","v":597.20419707680537},9.7865427310490354,false]
[null,"sci (G1 deep & G2 shallow)",10,597.20419707680537,9.7865427310490354,true]
[null,"en",14.85,886.84823265905595,14.533015955607819,false]
[null,"en",14.85,886.84823265905595,14.533015955607819,false]
[null,"dvl",5.75,343.3924133191631,5.6272620703531961,false]
[null,"dvl",5.75,343.3924133191631,5.6272620703531961,false]