Hello and welcome to our community! Is this your first visit?
Register
Page 4 of 4 FirstFirst ... 234
Results 31 to 36 of 36
  1. #31
    New TDF Member
    Join Date
    Nov 2015
    Location
    North Central Florida
    Posts
    20
    Likes (Given)
    0
    Likes (Received)
    3
    I hate to release a revision so soon after releasing a previous version but I uncovered an inconsistancy in the way the automatic conversion of spreadsheet data works when the units are changed and a calculation is done. The problem I believe has to do with the conversion in connection with the formatting of data in the spreadsheet cells. Until I can come up with a solution you will need to convert and update the spreadsheet manually. Sorry for the inconvenience. Go to Scubaboard.com to get the latest version. The filename is: dive_071019_v27_1.xls

  2. #32
    New TDF Member
    Join Date
    Nov 2015
    Location
    North Central Florida
    Posts
    20
    Likes (Given)
    0
    Likes (Received)
    3
    I posted a new major version release of my Dive Calculation Spreadsheet. You can download it from Scubaboard.com. You don't need to be a member. See the instructions in an earlier post in this thread. Here is what I wrote in Scubaboard.com:

    The beat goes on ..... Fixed incorrect descent to switch depth when first depth was less than the switch depth. Added the ability to use the GFHi% in the %AoM calculations. Changed the highlight color for CTC's and added a color for pure oxygen. Changed the %AoM to select either GFHi% or 100% of the surface m-value. Added a HT multiplier for the Dsat table. Added a button to change the half-time display between nitrogen and helium. This is useful when both inert gases are displayed. In place of automatic unit conversion I added a depth conversion table selectable from the Units drop down box. Added more colors.

    Automatic unit conversion is still disabled in this version. Converting from metric to imperial works but switching from imperial to metric produces inconsistent results. For example, using profile 4 with imperial units selected produces 27.5 minutes of deco. When switching to metric the deco totals 17 minutes. However, manually entering the data with automatic switching turned off produces the same deco (within a minute). If you want to play with it press Alt-F8, select Sheet2 (DIVE) and Edit. If you find a solution let me know and I will incorporate the solution into the next version. In the mean time I will continue to work on it.

  3. #33
    New TDF Member
    Join Date
    Nov 2015
    Location
    North Central Florida
    Posts
    20
    Likes (Given)
    0
    Likes (Received)
    3
    Version 28.1 of my dive tissue compartment Excel spreadsheet is available. See the instructions in an earlier post in this thread to download it. Here is what I posted on Scubaboard.com:

    In this version I fixed the bad data validation for the SS/Deco depth entries. You can now enter 0 which removes the SS/Deco ascent rate from the calculation. The N2 half-time multiplier wasn't being displayed when both gases were selected: fixed. Added GasSw as a new segment descriptor. Fixed a divide by zero error in the CNS calculation when the %O2 was set to 50 for a surface interval. Eliminated the choice to use %GFHi as the maximum surfacing m-value in the %AoM column and the TC %AoM display. Looking at the numbers for the %GFHi choice was confusing so I got rid of it. Nothing has been lost as I added a color to mark those TC's that are above %GFHi but below the (100%) surfacing m-value.

    Let me know if you find bugs and I'll fix them.

  4. #34
    New TDF Member
    Join Date
    Nov 2015
    Location
    North Central Florida
    Posts
    20
    Likes (Given)
    0
    Likes (Received)
    3
    I posted version 29.0 on Scubaboard.com. See a prior post for downloading instructions. This is my post from Scubaboard.com:

    I'm still working out some issues but I couldn't resist posting this major revision since it contains so many fixes. This is version 29.0:

    Fixed bad data entries for the %AoM display using the Dsat table. Initialize data arrays only once at first calculation. This should speed things up. Fixed an overflow problem with the CNS calculation and added overflow and divide by zero protection in this routine. Added a new routine to calculate misc data (ppO2, gas usage, and END). Added formulas to calculate helium percentage when O2 and N2 are entered for the main1 and main2 gases. Eliminated units change when Units is changed from Table to Imperial or Metric. Added corrections to "a" and "Mo" coefficients for water type. Fixed a problem switching to the Main1 gas after being on Main2. Changed the descent and ascent inspired inert gas pressure calculations. Fixed the automatic units conversion so it is enabled by default in this version. Changed the deco ceiling calculation formula. Added a ceiling adjustment factor to the program parameters section. Fixed bad reverse GF profiles. Added a selection to include the descent time with the level time (same as MultiDeco). Made some cosmetic changes to the ss.

  5. #35
    New TDF Member
    Join Date
    Nov 2015
    Location
    North Central Florida
    Posts
    20
    Likes (Given)
    0
    Likes (Received)
    3
    I posted version 30.0 on Scubaboard.com. See a prior post for downloading instructions. This is my post from Scubaboard.com:

    I'm really proud of this major release. A major issue was fixed and I made some enhancements. In this version I removed the sheets: GF, OXT, CALC, PLAN, and RB. The .xls file size had grown to over 1 Mb and I thought that most people are not using those sheets. Those sheets are now in a separate spreadsheet file called dive_tools_081719_v1_0.xls. When I fix the issues in the dive tools spreadsheet I'll release it in this thread. All the functionality for those sheets in the last version is available in the new file. I added a new sheet called SETTINGS where you can change the parameters of the profiles without editing the VB code.

    This version fixes a long standing issue for shaped GF's (gradient factors). Previous versions showed too much deco time. Flat GF's were not effected. I added the Buhlmann ZH-L12, Dcap, and a custom table. The custom table contains the Workman (1965) values. The custom tables can be modified for whatever decompression tables you want to use. You need the surfacing m-values, half-times, and slopes for the tissue compartments. See the DIVE_HELP sheet for information on how to do this. I fixed the ss to show a second descent (when gas switching) to the level time if Include Desc T is selected Yes. Added a choice to show ascent and deco stop time or just the deco stop time on the ss. Added a ceiling adjustment factor for metric units in addition to the ceiling adjustment factor for imperial units.

  6. #36
    New TDF Member
    Join Date
    Nov 2015
    Location
    North Central Florida
    Posts
    20
    Likes (Given)
    0
    Likes (Received)
    3
    I posted version 31.0 of my tissue compartment Excel spreadsheet. This is my post from Scubaboard.com:

    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.

    To get it go to Scubaboard.com
    Go to the Community
    Go to the Advanced forum
    Find the thread "Dive Calculation Spreadsheet"
    Click on the link dive_102919_v31_0.xls


 
Page 4 of 4 FirstFirst ... 234

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •