In response to your input, attached please find the newest iteration of the Buoyancy Estimator.
Errors in the salt water formulae were corrected.
A minimalist ability to compute for fresh water was added.
European tanks were added to the list. I'm sorry, but at this point, having a separate Metric only version was more than I could tackle. The spreadsheet is still the odd mix of Imperial and metric data common in the US market (Cu Ft for tanks, Millimeters for wetsuit thickness, etc.).
The fourth order polynomial formula for wetsuit compression was changed based upon new data.
That's the good news.
The bad news is that as with any iterative big system, it's a little difficult to take in all at once.
So if you're new to this thread, please start at the beginning and read the various posts.
Once in the spreadsheet, start at sheet #1 and work your way through. There are LOTS of directions buried in the individual sheets.
Especially useful is the multi-window approach to experimenting with the toy, as described in post #2.
The new versions have been added both here, and in post #1.
As always, please comment in the thread with your suggestions or criticisms. We've come a long way.
And most important of all, I depend on your feedback for accuracy. If you find a mistake, as a few others already have with such a big file, just let me know and I'll fix it as soon as I can.
Just for grins, our starting data is with a medium sized guy with lots of neoprene and a large steel tank. A perfect way to reignite the argument about balanced rigs. Have fun looking to see how (with BOTH a BCD failure and a disappearing buddy) he's 15-18# heavy at 80 feet due to wetsuit compression. He maybe can't swim that up. But by jettisoning just a few pounds, he's able to get off the bottom (assuming he can swim up 12# for 20 feet or so), and becomes neutral at the usual safety stop depth. After offgassing for as long as his air allows, he can now slowly ascend with slight positive buoyancy to the surface, arriving with minimal chance of decompression stress, after an otherwise fatal scenario. Without re-igniting the redundant lift wars, let's just say that from a theoretical standpoint, it's nice to know that there's one more rescue option you can put in your bag of tricks. And it's my personal belief that, employed properly, this partial weight jettison provides a safer return to surface than ascending on a lift bag and reel. But of course, your buddy didn't leave you, and even if he did, using a sausage to get you off the bottom, and then releasing it when wetsuit re-expansion sufficiently assists your negative buoyancy ascent remains a fine choice.
EDIT:
Fresh water corrections improved. V24 deleted. New V25 uploaded.
EDIT:
Error found in hood buoyancy calc cell.
New versions loaded below.
Errors in the salt water formulae were corrected.
A minimalist ability to compute for fresh water was added.
European tanks were added to the list. I'm sorry, but at this point, having a separate Metric only version was more than I could tackle. The spreadsheet is still the odd mix of Imperial and metric data common in the US market (Cu Ft for tanks, Millimeters for wetsuit thickness, etc.).
The fourth order polynomial formula for wetsuit compression was changed based upon new data.
That's the good news.
The bad news is that as with any iterative big system, it's a little difficult to take in all at once.
So if you're new to this thread, please start at the beginning and read the various posts.
Once in the spreadsheet, start at sheet #1 and work your way through. There are LOTS of directions buried in the individual sheets.
Especially useful is the multi-window approach to experimenting with the toy, as described in post #2.
The new versions have been added both here, and in post #1.
As always, please comment in the thread with your suggestions or criticisms. We've come a long way.
And most important of all, I depend on your feedback for accuracy. If you find a mistake, as a few others already have with such a big file, just let me know and I'll fix it as soon as I can.
Just for grins, our starting data is with a medium sized guy with lots of neoprene and a large steel tank. A perfect way to reignite the argument about balanced rigs. Have fun looking to see how (with BOTH a BCD failure and a disappearing buddy) he's 15-18# heavy at 80 feet due to wetsuit compression. He maybe can't swim that up. But by jettisoning just a few pounds, he's able to get off the bottom (assuming he can swim up 12# for 20 feet or so), and becomes neutral at the usual safety stop depth. After offgassing for as long as his air allows, he can now slowly ascend with slight positive buoyancy to the surface, arriving with minimal chance of decompression stress, after an otherwise fatal scenario. Without re-igniting the redundant lift wars, let's just say that from a theoretical standpoint, it's nice to know that there's one more rescue option you can put in your bag of tricks. And it's my personal belief that, employed properly, this partial weight jettison provides a safer return to surface than ascending on a lift bag and reel. But of course, your buddy didn't leave you, and even if he did, using a sausage to get you off the bottom, and then releasing it when wetsuit re-expansion sufficiently assists your negative buoyancy ascent remains a fine choice.
EDIT:
Fresh water corrections improved. V24 deleted. New V25 uploaded.
EDIT:
Error found in hood buoyancy calc cell.
New versions loaded below.