Check my math?

[badgers]

I have made a little excel spreedsheet with some Visual Basic Macro code in it.
coulds some people please check my math?

The point of the sheet is that you enter the depth you really want to dive and then click on calculate.
It gives you the O2%(based on 1.4) and the EAD, and then the bottom time based on PADI tables.

thank you for your time and have a good day
PS it is .zip so the upload would take it.

 

[wedivebc]

I have made a little excel spreedsheet with some Visual Basic Macro code in it.
coulds some people please check my math?

The point of the sheet is that you enter the depth you really want to dive and then click on calculate.
It gives you the O2%(based on 1.4) and the EAD, and then the bottom time based on PADI tables.

thank you for your time and have a good day
PS it is .zip so the upload would take it.

I got a runtime error 1004 when I tried to run it.

 

[badgers]

I got a runtime error 1004 when I tried to run it.

which version of excel are you using?

 

[madisonbadger]

[ur

 

[wedivebc]

which version of excel are you using?

Exel 2000 build 9.0.2720
The problem is I didn't realize the table only went to 140ft. Works great now.

 

[badgers]

I would never go that deep. It gets way to dark and when it is light enough the colors are all washed out blue.

thanks for checking my math. I trying to make an open source dive planner for linux. I am new to linux, but very good with VB. So I prototype in the language I know and then port that.
thank you and have a good day

 

[wedivebc]

I would never go that deep. It gets way to dark and when it is light enough the colors are all washed out blue.

thanks for checking my math. I trying to make an open source dive planner for linux. I am new to linux, but very good with VB. So I prototype in the language I know and then port that.
thank you and have a good day

I don't know if you have looked here yet http://www.decompression.org/maiken/VPM/VPM_Program_Site_Map.htm
but there is some source code in basic and C you might find useful.

 

[rab]

I have made a little excel spreedsheet with some Visual Basic Macro code in it. ...

No VB involved in my Nitrox EAD spreadsheet. It's posted as an attachment to this post.

-Rob

 

[badgers]

thanks for the links, It does not seem that Eric Maiken has released his source code under the GPL.
thank you rab for your spredsheet.
I really appreciate your help on checking my calcs.
If anyone has a better idea for the logic I have used, please let me know. I think this will become the core of a program that will let a diver enter two depths and the desired bottom time, then calc the PADI pressure groups and the required surface interval.

thank you

 

[badgers]

thank you everybody.
attached is a stand alone VB program. If you would please try it out I would appreciate it.
the way it works is as follows:
enter 1 depth at the left and click calc = max padi time
enter 1 depth and bottom time and click calc=ending padi presure group.
if your bottom time exceeds padi tables your entered time is erased and the padi max time is entered, then the presure group is calculated based on the program substituted max time.

enter 2 depths and two bottom times and click calc the program will calc the presure groups and calc min surface interval.

NITROX.
if you click the check box for nitrox :
you enter the O2 level like 0.40 or 0.36 or 0.32 and then use as described above.
I veiw this as a homework checker/study aid for padi and basic nitrox problem solving.
any feedback is appreciated.
thank you for your time and have a good day.
it is expecting a P3 or better processor, also you need to have the VB runtime dll file. I can make an installer if someone needs it.