What is average surface air consumption?

[riguerin]

does the Wisdom give you average depth? that's all you need

(well, that and total dive time) (and gas used, but you do that yourself)

No it does not. You'd need to either do the averaging in a query ... or export the data to another application that does it for you. For example, Diving Log 4.0 ... the demo version of this software allows you to import upto 10 dives from the Wisdom data base. It will calculate avg depth ... and SAC (which is not always correct for steel tanks)

 

[H2Andy]

dang... that would have been the easy way

 

[kidspot]

Sounds like the I.R.I.S. software - it records your depth every 20 seconds, and allows you to export to Excel. So I have Excel calculate the average, and as long as I remember how many psi I used, you get a pretty accurate answer.

Aloha, Tim

 

[riguerin]

dang... that would have been the easy way

Dude it is easy


Here's some simple SQL code for a basic query that averages the DEPTH field, grouped by DIVEID & DIVEDATE


SELECT BODY.DIVEID, HEADER.DIVEDATE, Avg(BODY.DEPTH) AS AvgOfDEPTH
FROM HEADER INNER JOIN BODY ON HEADER.DIVEID = BODY.DIVEID
GROUP BY BODY.DIVEID, HEADER.DIVEDATE;

 

[lamont]

data from wednesday nights dive:

103 fsw max, 57 fsw avg, 56 min runtime, 900 psi of double-130s burned

SAC = .43

my SAC on the trigger at depth was probably lower... at one point i noticed that i was getting a little loopy at 100 fsw on 30/30 and increased my tidal volume to get rid of the CO2...

 

[riguerin]

Sounds like the I.R.I.S. software - it records your depth every 20 seconds, and allows you to export to Excel. So I have Excel calculate the average, and as long as I remember how many psi I used, you get a pretty accurate answer.

Aloha, Tim

That should be possible too. I haven't done it many years, but I'm certain that there is way to import an MS Access DB into MS Excel.

 

[mudchick]

Thanks all for the info. Is this calculation something my dive instructor should have taught me? Where else is this information to be found? (Geez, this what diving has done to me: I'm actually ASKING for math calculations!!)

 

[TSandM]

Female, 5'4", 120 lbs

Cold water, dry suit -- .4 to .45

Warm water, wet suit -- I got down to about .32 on this last trip to Maui.

 

[Divin'Papaw]

Thanks all for the info. Is this calculation something my dive instructor should have taught me? Where else is this information to be found? (Geez, this what diving has done to me: I'm actually ASKING for math calculations!!)

It wasn't covered in my OW or AOW course. Heck, all of the "math" in my nitrox class made the other student's eyes glaze over.

I learned it from an awesome document on gas management sent to me by NWGratefulDiver.

 

[Cave Diver]

data from wednesday nights dive:

103 fsw max, 57 fsw avg, 56 min runtime, 900 psi of double-130s burned

SAC = .43

For all those people calculating SAC using doubles, are you keeping in mind that 900 psi in doubles = 1800 psi in single when plugging numbers into the calculation?

I know I've made that mistake once or twice before by not paying attention.