Dive Calculation Spreadsheet

[EFX]

In this major version I added a column to the dive data called EAD (Equivalent Air Depth) which will be of interest to recreational divers. I added a selection box to the %AoM column to select either Surface or Current. Surface will display the controlling tissue compartment's (CTC) percent of the surfacing m-value if offgassing for each dive segment if you could instantly surface. Current will show the percentage of the surfacing m-value at the current point in the dive. This selection also determines the data for the TC's when %AoM is selected under the column TC Data. Fixed a bug in the selection of deco gases when ascending.

dive_102919_v31_0.xls

 

[maadJurguer]

As a fellow Excel ninja...bravo!

 

[EFX]

In this minor update (version 31.1) I added a selection on the SETTINGS sheet to select the density of gases at 0 or 20 degC. I fixed the change HT subroutine which crashed when Cancel or OK was pressed without a selection.

dive_110119_v31_1.xls

 

[rhwestfall]

@EFX ; Quickly tossed in a dive I have in my log.... Why the "zero gas consumption" (yellow highlighter - second column from end)? What did I input wrong? P.S. didn't do anything with GF as it was there as values when I downloaded it....

 

[EFX]

In your image of the spreadsheet above you selected 0.08 ft3/min for SAC rate. This is extremely low. For a dive segment of 0.3 minutes the gas usage is 0.024 ft3. There is another issue. When I added the EAD column the Usage column lost its formatting to tenths. It is displaying whole numbers instead. To fix this click on the first cell below in ft3 (or l if the setting is metric) and select the column all the way down to row 400. Right click and select format, click on Number and set the decimal place to 1, click on OK. Or, download the following revision.

 

[rhwestfall]

oops, obviously my rate is not that... 0.8 was an intended input, and didn't realize it as a fast glance it appeared right....

 

[EFX]

This version sets the formatting of the Gas Usage column to tenths of a ft3 or liter.

dive_110519_v31_1.xls

 

[EFX]

In this major version release (v32.0) I added a column to the %AoM and called it CTC %GF or %MV. Now, current and surface %GF can be displayed side by side for each dive segment. This is now called CTC %GF or %MV. The old %m-value is still available but is now calculated for current and surface values and is called %MV. A selection was added to the deco common section to select either %GF or %MV. TC Data was also changed to display either current or surface GF for the TC data in addition to the pressures. Fixed a problem for incorrect number of TC's when the custom table was selected. Added Mo surfacing values to the selection for the half-time row above the TC data area. To the right of deco common I added an entry to show the total dive segments on the spreadsheet.

dive_010120_v32_0.xls

 

[EFX]

One thing I failed to mention in regards to the new version is I moved the code that calculates %MV (the old %AoM) from the ceiling calculation routine and put it in its own subroutine. The calculations for %GF are also in the new routine. This subroutine is called once after all the other data is calculated for all the profiles. There was one complaint that the calculation was slow. If you were frustrated by the slow speed give this version a try. It should be faster.

 

[EFX]

Well, lightning struck again. I added the capability to create a dive profile of up to 20 depths. To do this set the air surface interval to -1 for each dive profile. This instructs the program to ignore the ascent to surface and the surface interval for the current dive profile and string the next profile's depths and so on. You can create a dive profile of up to 20 segments. This only works for NDL profiles. Once a profile enters deco the deco ascent schedule takes over that will conclude the dive at the surface after the last deco stop is completed.

For those of you who are exploring the use of GF's (current and surface) for NDL dives in place of the standard 3 or 5 minute safety stop this version is for you. This version gives you the ability to add multiple depths in the high off gassing area to analyze the effect of GF's on the dive profile. See the DIVE_HELP sheet for more information. The uploaded spreadsheet has an example of this new capability. Check it out.

dive_011520_v33_0.xls