johndiver999
Contributor
My first shot at it, there may well be errors; I’ve already given a good reason for skepticism. I really haven’t Checked it much
Spreadsheet for helping pick a pony bottle
- Thread starter wetb4igetinthewater
- Start date
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
- Messages
- 20,962
- Reaction score
- 20,695
- Location
- Philadelphia and Boynton Beach
- # of dives
- 1000 - 2499
Hi @johndiver999
Calculation comes out the same as mine. I've been won over to at the @wetb4igetinthewater method of a single ascent, applies equally to a direct ascent and to safety stop. I chose 1 significant figure, you chose 2.
Calculation comes out the same as mine. I've been won over to at the @wetb4igetinthewater method of a single ascent, applies equally to a direct ascent and to safety stop. I chose 1 significant figure, you chose 2.
IF( [cell] less than 0, "You're Dead",0) should fix it
OP
IF( [cell] less than 0, "You're Dead",0) should fix it
Lol. I’m not an excel expert as I used Google to do the color coding for the ascent. I’ll figure something out
MichaelMc
Working toward Cenotes
I would put the related inputs together and the shallow ones higher, deep ones lower. and split in columns by type of data.
Surface air cons: xx
SS depth: xx SS time: xx SS multiplier: xx
.................. Ascent rate: xx Asc. Mult: xx
Max depth: Xx Bottom delay: Xx Bot mult: xx
Or order them with blank line or under lines in between
Sac
Depth
Time
Mult
Rate
Mult
Depth
Delay
Mult
Surface air cons: xx
SS depth: xx SS time: xx SS multiplier: xx
.................. Ascent rate: xx Asc. Mult: xx
Max depth: Xx Bottom delay: Xx Bot mult: xx
Or order them with blank line or under lines in between
Sac
Depth
Time
Mult
Rate
Mult
Depth
Delay
Mult
OP
Mark Powell posted a link to http://www.hse.gov.uk/research/rrpdf/rr1073.pdf for setting stress multipliers on a thread on FB where I posted this. I haven't read it yet.
It is possible to make this quite complex. Anyone can modify this file or write their own. The purpose of this spreadsheet was to give new divers who are adding a pony to their configuration to have some idea of what is appropriate.
I agree that the stress multiplier will be highest when preparing to ascend, followed by the ascent to the safety stop, and lowest during the safety stop and the ascent from the safety stop to the surface. I don't want to make it that complicated, as I think it is more likely to be discounted by people whom it could help. Those that want a greater precision can modify the file as they wish.
I'll still post a version taking in the ascent preparation time and the safety stop, but not with different stress multipliers.
It is possible to make this quite complex. Anyone can modify this file or write their own. The purpose of this spreadsheet was to give new divers who are adding a pony to their configuration to have some idea of what is appropriate.
I agree that the stress multiplier will be highest when preparing to ascend, followed by the ascent to the safety stop, and lowest during the safety stop and the ascent from the safety stop to the surface. I don't want to make it that complicated, as I think it is more likely to be discounted by people whom it could help. Those that want a greater precision can modify the file as they wish.
I'll still post a version taking in the ascent preparation time and the safety stop, but not with different stress multipliers.
- Messages
- 20,962
- Reaction score
- 20,695
- Location
- Philadelphia and Boynton Beach
- # of dives
- 1000 - 2499
@johndiver999 version of the pony planner works fine, gives you gas requirement, you can choose your pony size.
OP
@johndiver999 and @scubadada,
So I just took a look at @johndiver999's spreadsheet, and I do think it is better than what I wrote. One of the reason I had all those different sized pony bottles was to show how the small ones were inadequate. But I think this one proves that point in a more straightforward and simple manner.
The only change I would make is to add some text to it.
@johndiver999,
Do you mind if I modify/distribute your spreadsheet? If so, how I do I give you credit, as one thing I do not do is steal other people's work. I always give credit and only use if given permission.
So I just took a look at @johndiver999's spreadsheet, and I do think it is better than what I wrote. One of the reason I had all those different sized pony bottles was to show how the small ones were inadequate. But I think this one proves that point in a more straightforward and simple manner.
The only change I would make is to add some text to it.
@johndiver999,
Do you mind if I modify/distribute your spreadsheet? If so, how I do I give you credit, as one thing I do not do is steal other people's work. I always give credit and only use if given permission.
johndiver999
Contributor
Thanks for asking. You can do whatever you want with it. Please don't try to reference me etc., it's not a big deal. Portions of the sheet should be protected and the graph needs better labeling, I think.
OP
Because it is not my original work, I will assign you a symbol and refer to you as "He who must not be named"
Similar threads
