Info Optimal Buoyancy Computer

Please register or login

Welcome to ScubaBoard, the world's largest scuba diving community. Registration is not required to read the forums, but we encourage you to join. Joining has its benefits and enables you to participate in the discussions.

Benefits of registering include

  • Ability to post and comment on topics and discussions.
  • A Free photo gallery to share your dive photos with the world.
  • You can make this box go away

Joining is quick and easy. Log in or Register now!

The Optimal Buoyancy Computer
A tool to help nail buoyancy and improve safety, before you splash
1) How much lead should I carry with my new wetsuit?
2) How big a wing should I buy?
3) Will my BCD support my lead, both at the surface and when my wetsuit is compressed at depth?
4) Will my BCD support my rig without the help of my wetsuit/drysuit, if I doff it at the surface in an emergency, or underwater due to an entanglement?
5) How do I balance my rig?
6) How might partial weight ditching help me deal with an emergency? Will it really result in a runaway ascent?
7) How does the neutral buoyancy check change with thick neoprene?

I’m excited to announce the release of the Optimal Buoyancy Computer.
Designed to answer a variety of buoyancy questions, it provides accuracy directly proportional to the precision of your data input. Starting with as little as your height, weight and suit thickness, you can get ballpark weight requirements quickly. With additional information, you can compare equipment configurations, and plan for self-rescue after hypothetical equipment failures.

This tool is an Excel spreadsheet, and is a revision of a tool originally released in Buoyancy, Balanced Rigs, Failures and Ditching – a comprehensive tool , which was itself a revision of a toy spreadsheet first introduced in this thread: Advice on lift capacity for BP&W in April, 2018. After months of user suggestions, this new tool uses a simpler, modified data input system, and produces both simple and complex analyses of buoyancy. It works in both metric and Imperial units, salt and fresh water, and with both U.S. and European tanks.

Included is a 50-page user’s manual to lead you through the more complex parts of the tool, and a Quick Start section to get you going with minimal familiarity with spreadsheets. Additionally, the manual discusses the theory behind the more complex buoyancy calculations, whether you need help with Excel or not. If you are not facile with Microsoft Excel, the manual will take you through it all, step by step.
Here's the Table of Contents:
2019-08-30_3_1.jpg
Download the .xlsx file for current versions of Excel. Use the .xls file for Excel 97-2003. Other spreadsheet programs may or may not recognize the internal links, but trial versions of Excel are available for free. You will see a generic Excel warning about possible viruses - don't worry, there are none! Click "Enable Editing", and save a copy. After saving, you will be able to edit the data fields for your use.

Many thanks to @stepfen , @johndiver999 , @kmarks , @Akimbo and the many others who have made suggestions and comments along the way.

NOTE: If you are using Excel 2003 and download the .xls file, extensive protective formatting is not functional. Thus, when you are diving a wetsuit (for example), you may be able to see drysuit "data" on the same page. The data for the "other" suit is NOT accurate under those conditions and should be ignored. With current versions of Excel, this information is blanked out for safety.

As each new version is uploaded, the count of downloads returns to zero. We are currently at over 2000 downloads of the tool, counting repeat customers! Thank you for your interest!

WARNING: These spreadsheets are experimental tools using formulas created by amateur divers for educational use only. Numerous assumptions regarding buoyancy have been made based upon only partially tested equipment configurations. The information herein is for your personal educational use and should not be relied upon to determine the adequacy of a given equipment configuration. Consultation with a dive professional regarding equipment, weighting and performing a neutral buoyancy check should all be strongly considered before diving a new equipment configuration. Note specifically that the practice of ditching weight at depth is a controversial one, and the theoretical data in this spreadsheet should not be considered a recommendation of that practice.


Selected for the ScubaBoard Knowledge Base.

This thread was selected for the ScubaBoard Knowledge Base on 22 November 2021. Special rules discouraging off-topic and counterproductive replies apply after this date.
 

Attachments

“Included is a 50-page user’s manual to lead you through the more complex parts of the tool, and a Quick Start section to get you going with minimal familiarity with spreadsheets. Additionally, the manual discusses the theory behind the more complex buoyancy calculations, whether you need help with Excel or not.“
————————
@rsingler
[​
There are two versions (138kb & 400kb) of your great V57 calculator. Why two versions? Difference?

Wow, 13 new versions still since my April download. Looking forward to seeing the refinements. Thanks for your ScubaBoard gift!!

Best regards & happy diving!
 
There are two versions (138kb & 400kb) of your great V57 calculator. Why two versions? Difference?

The 138kb version is for the "current" Excel version(s) that support xlsx files and the other is for the older versions (xls files) in case anyone is still using them.
 
With profound thanks (AGAIN!) to @stepfen, post #1 now has a revised version of the tool (v. 58) after his latest tank research.
@stepfen has obtained data on an additional 40 metric tanks from Luxfer, ECS, Polaris and MES that are more commonly seen on the European side of the pond. The spreadsheet has been updated to include this info, and the manual revised slightly regarding the tank info provided. No changes have been made to any computational formulas, so current users who do not see or use these tank brands shouldn't feel compelled to download this "latest" version.

Thanks again to the great ScubaBoard community for all your contributions!
 
Looks awesome!

I’m one of those that rules of thumb and even the detail in this doesn’t work for me.

But handy play around with to see what changes in equipment can result in changes in buoyancy!!

_R
 
Hey @_Ralph , send me a PM with some of your data, and let's see if we can figure out why it's not accurate for you. If we can, and maybe fix a formula, that'll doubtless help others.
 
First, thanks for doing this. It is an amazing spreadsheet.

Just as a curiosity, could the 'Personal Buoyancy' be calculated from body weight and BMI (or fat/lean mass numbers) reported by some of the newer smart scales?
 
First, thanks for doing this. It is an amazing spreadsheet.

Just as a curiosity, could the 'Personal Buoyancy' be calculated from body weight and BMI (or fat/lean mass numbers) reported by some of the newer smart scales?
I think that's possible, but I'm not sure we have the right index. BMI alone as an index of "floatability" gets us astray, as we found out in the Air Force when huge muscular "sinkers" of heavy weight yet lean body mass, came back with high BMI numbers that obviously didn't mean "obese". Perhaps some sort of fat/lean index could be coupled with height and weight. After all, that's all that's going into your personal measurement of Personal Buoyancy in a swimming pool. It would be nice to automate that. I have some ideas, but have been hesitant to ask users to quantify their "fluffiness" so I could pin it down. :) For all readers of this thread, I would welcome a short confidential PM with your height, weight, self assessed "fluffiness" and your measured personal buoyancy. Perhaps if I graph that all out, something will become obvious.

From some feedback, the Personal Buoyancy discussion isn't very intelligible in either the manual or the red comments in the "Diver and Dive" tab, so I'm working on making that more understandable, especially regarding what happens with the switch from salt to fresh water. Any suggestions you have on making that section better would be welcome.

Thanks!
 
I think that's possible, but I'm not sure we have the right index. BMI alone as an index of "floatability" gets us astray, as we found out in the Air Force when huge muscular "sinkers" of heavy weight yet lean body mass, came back with high BMI numbers that obviously didn't mean "obese".

Well, I would definitely matter how the BMI was calculated. I think in your example BMI was figured from a height/weight table. That method assumes some typical dense body mass based on your height, and then any excess weight is considered all fat. If you're not typical, that method is totally inaccurate as you point out. I'm surprised anyone ever thought they were a good idea.

The most accurate measure of BMI is hydrostatic weighing, but that's not really practical for most people. If a person can do that, they can certainly do the float test already described in the manual/spreadsheet.

However, these new digital electronic bathroom scales measure BMI and fat percentages using conductivity and impedance. They are not super accurate, but when you average your daily readings over a period of time, it's pretty good. They are much better than using the lookup tables, and would not have misread your Air Force guy.

Cheers :)
 
From some feedback, the Personal Buoyancy discussion isn't very intelligible in either the manual or the red comments in the "Diver and Dive" tab, so I'm working on making that more understandable, especially regarding what happens with the switch from salt to fresh water. Any suggestions you have on making that section better would be welcome.

Thanks!

I was thinking about this too. Maybe the 'personal buoyancy input' should have it's own drop down box where we could tell if the test was done it salt or fresh water. Then you could calculate the missing information either way.

The other drop down box would be for choosing where you will be diving, fresh or salt. That tells you which calculation to run (like it does now, I think).

Hope I'm describing that OK.
 
Back
Top Bottom