Welcome to ScubaBoard, an online scuba diving forum community where you can join over 205,000 divers diving from around the world. If the topic is related to scuba diving, this is the place to find divers talking about it. To gain full access to ScubaBoard (and make this large box go away) you must register for a free account. As a registered member you will be able to:

  • Participate in over 500 dive topic forums and browse from over 5,500,000 posts.
  • Communicate privately with other divers from around the world.
  • Post your own photos or view from well over 100,000 user submitted images.
  • Gain access to our free classifieds marketplace to buy, sell and trade gear, travel and services.
  • Use the calendar to organize your events and enroll in other members' events.
  • Find a dive buddy or communicate directly with scuba equipment manufacturers.

All this and much more is available to you absolutely free when you register for an account, so sign up today!

NEW for 2014 Access SBlogbook for members. It allows you to directly upload data from your dive computer, validate your logs digitally, link your dives to photos, videos, dive centers (9,000 on file), fishes (14,000 on file) and much more.

If you have any problems with the registration process or your account login, please contact the ScubaBoard Support Team.
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Excel Formula's For Dive Table Training

 

  1. #1
    Registered


    Has not set a "status"
     

    DawgPaddle's Avatar
    Join Date
    Feb 2002
    Location
    Lansdale Pennsylvania
    Posts
    126
    Photos
    8

    I See Excel Formula's For Dive Table Training

    Howdy,

    This evening a few of my friends will attend their first scuba class. Acting as an unofficial assistant, I've provided each of them with Dive Tables, and a few questions to ensure they understand the flow of the table. I've made a naui styled dive table in excel, but would also like to add some functionality to it so they can check their answers.

    I've seen a couple of dive tables tutor's on the net, but I'd like to finish making this one so I can give it to them. I'm not interested in making any money off of it. I just don't want to spend forever, figuring the rest of the formula's up. For example, calcuate SIT time to update your dive group.

    If anyone would like to help out, I'd be much appreciative.

    Thanks,
    Be Particular!

    DawgPaddle

  2. #2
    ScubaBoard Contributor


    Has not set a "status"
     

    Join Date
    Jul 2003
    Posts
    724
    Well dude, I'm only a computer programmer hack of a variety (I can "officially" program in C++, V/Basic (who can't), and good Ole Perl........)

    Anyhow, it's been way too long, but in VB I'd do some sort of 2 Dim Array of the SI/PG thing........I'm sure there's a way of getting that into Excel (I looked once but never really figured it out) but I don't know how. I've nevr taken any Excel classes to see how it integrates with VB code.

    If you can figure that out, to me, that's the easiest way to go. I've done that in VB and it works great, is easily changed (to confrom with other "schedules") as well.

  3. #3
    Registered


    Has not set a "status"
     

    ShoalDiverSA's Avatar
    Join Date
    Jul 2003
    Location
    Kwazulu Natal, South Africa
    Posts
    794
    Dives
    50 - 99
    Photos
    41
    How about posting your excel file so that interested parties can see what they can do to spruce it up? There's not much to go on here...

    Cheers,

    Andrew

  4. #4
    Registered


    Has not set a "status"
     

    alpenadiver's Avatar
    Join Date
    Jul 2003
    Location
    Alpena, Michigan
    Posts
    232
    Dives
    100 - 199
    Photos
    11
    DeepScuba, excel uses Visual Basic for Applications if that helps, a VLOOKUP table may be the way to go ?

  5. #5
    Registered


    Has not set a "status"
     

    DawgPaddle's Avatar
    Join Date
    Feb 2002
    Location
    Lansdale Pennsylvania
    Posts
    126
    Photos
    8

    I See Spreadsheet

    Hi Gang, here is the basic table. The "in the works" version is at home. Please feel free to change any and everything you'd like. I put the disclaimer on using it for training only because I don't want to be liable should someone attempt to use this for real dives. Also, is there any problems with me even putting a table together based on NAUI numbers? If so, I'll scrub the project completely.

    So, without further ado, here's the table and thanks in advance.
    Attached Files Attached Files
    Be Particular!

    DawgPaddle

  6. #6
    New User


    Has not set a "status"
     

    jimandi's Avatar
    Join Date
    Jun 2009
    Location
    Houston
    Posts
    4
    Dives
    100 - 199
    I am looking for a dive planer for my laptop. I was thinking of building one in Excel. I am hoping that I am not the first to think of this.

  7. #7
    Registered


    Has not set a "status"
     

    Join Date
    Jun 2009
    Location
    Puget Sound
    Posts
    19
    Dives
    100 - 199

    Excel Dive Planner Based on Navy and NOAA kinda Naui

    I was looking for the same thing and couldn't find an Excel Dive Planner. I've been looking for free no-copyright dive information and of course the US government is the best place to go.

    The attached excel workbook is was prepared using NOAA, Navy based information. It even has some Nitrox 32 and 36 MOD and PO2 information (from NOAA) as well decompression stop information (Navy Based). It is really a bad idea to use this planner for Decompression Dive Planning, since I left out a couple of stop times, (which I mention in the heading). You may safely use air tables to plan Nitrox dives, you have to stay within the Nitrox Maximum Operating Depth or risk death from complication from Oxygen Toxicity. Use the NOAA nitrox 32% and 36% tables instead to plan Nitrox dives. In fact, use the NOAA AIR Tables that are on their website.

    The curious thing is that I noticed that (according to NOAA tables) you do change dive groups, even diving in 10 feet of water! If you dive in 25 feet of water for 55 minutes, you end with a dive group C. Does any dive agency warn of diving shallow (above 40 fsw) and allowing us to think there is no penalty?

    I was certified by NASDS a long time ago. They only had Navy tables then. So this table is for those who want to fiddle with making one that is based on Navy, not a private organization's. I also added Meter conversions, since if you travel, you'll run into computers having that unit of measure.

    Disclaimer
    This excel dive planner is for reference only to show how Excel could be used to populate an Excel spreadsheet using NOAA and NAVY tables as a resource. THAT IS ALL. Never dive without proper training. Do not use these tables to plan a dive. Remember that NOAA and Navy divers have to meet strict physical and fitness requirements that recreational divers may not be able to. Therefore using these dive tables, OR ANY OTHER, is no gaurantee that a diver will not get Decompression Sickness. NEVER DIVE USING NITROX without proper training from legitimate certifcation agency.
    Attached Files Attached Files

  8. #8
    Registered


    Has not set a "status"
     

    cfelliot's Avatar
    Join Date
    Jan 2005
    Location
    Portland, Maine
    Posts
    577
    Dives
    200 - 499
    See my post: Excel Dive Computer

    All in VBA using Excel as the UI

  9. #9
    Frequent Poster


    hasn't set a status.
     

    Join Date
    Apr 2006
    Location
    Maine
    Posts
    127
    Dives
    I just don't log dives
    What about just buying a download of v-planner or I-deco?

  10. #10
    ScubaBoard Veteran


    VOTE DEMOCRAT it's easier than
    working
     

    Join Date
    Jun 2003
    Dives
    100 - 199
    Photos
    7
    seems like a lot of work when you can use tables any 'ol place for a recreational dive.

    And if you are doing a tech dive, V-planner. It's got a really good track record with an awful lot of dives planned with it.

    However if you're doing it -just because-, then good luck to you and enjoy.

Page 1 of 2 12 LastLast

Similar Threads

  1. Dive Table Question
    By olstykke in forum New Divers and Those Considering Diving
    Replies: 17
    Last Post: March 10th, 2005, 10:21 AM
  2. Need PADI Dive Table & Log
    By Dragracer in forum Old Unclassified Classified Ads
    Replies: 1
    Last Post: February 29th, 2004, 11:07 PM
  3. Dive table vs computers
    By HPT3 in forum New Divers and Those Considering Diving
    Replies: 10
    Last Post: October 24th, 2003, 02:47 PM
  4. Dive Table
    By animian2002 in forum New Divers and Those Considering Diving
    Replies: 7
    Last Post: September 13th, 2002, 11:04 AM
  5. Dive Table Problems
    By Mr. Nice Guy in forum New Divers and Those Considering Diving
    Replies: 4
    Last Post: May 9th, 2002, 03:41 PM

Posting Permissions

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