Oceanic OceanLog 2.x Graph Spreadsheet

[ScubaMarc]

For fun I created a spreadsheet that connects to Oceanic's Oceanlog database that displays the oceanlog dive data in graph format. This spreadsheet creates several graphs that are interesting to view. If you like, give it a try.

Very easy to use.
1.Download the spreadsheet and save it to your pc.
2. Open the xls.
3. Go to the setup sheet. Basic instructions from their.

download xls: http://dive.50webs.com/dive.xls

there is very litle testing, if you see any issues, send me a pm.

 

[ScubaMarc]

screenshot

http://dive.50webs.com/pic.html

 

[HappyFunBoater]

Very nice! I just downloaded it and got it to pull in my Aeris data within just a few minutes. Good job.

BTW, it was great to look at your macro to get the Aeris login and password for the database. How did you find this?

 

[ScubaMarc]

thanks, Password found by google.

 

[1island]

Very nice, thank you for posting.

 

[ScubaMarc]

FYI, I added SAC rate.

 

[ScubaMarc]

I found an issue with a calculation, I fix it and uploaded a new xls.

 

[ScubaMarc]

I added a feature to graphs to format the dive time by actual time(10:31 PM) or elapsed time(3:30). go to the setup page to change the format.

Version 7.

Also, is anyone using this. If yes, reply back.

 

[HappyFunBoater]

Yes, I've used the spreadsheet and will definitely download this one. Thanks!

 

[NSDiver]

Very cool - thanks.

-Nick