Finding a (Best) Dive Op in Cozumel

[ColoDale]

Planning a trip in Spring of 2025. It's been a few years since I was there but we've usually gone with Living Underwater. Are they still around? Anyone here dived with them recently? Thanks for any recent info on them!

Living Underwater is still around. I have not dived with them recently - I use a different dive OP but know Jeremy.

 

[jonhall]

Planning a trip in Spring of 2025. It's been a few years since I was there but we've usually gone with Living Underwater. Are they still around? Anyone here dived with them recently? Thanks for any recent info on them!

Check out the link in post #1 of this thread. The info is current, but in 2025 the prices will probably go up and I'll have to change most of the dive ops prices in the spreadsheet.

 

[jonhall]

Just an update on the spreadsheet. After updating the prices and some other info for most of the dive ops listed, I got the bright idea to make another column (just before the prices) with a link to the price page of the dive op, if it has one. So yes, there are now 2 links in different columns for an op - 1 for the home page and 1 for the price page (if there is one.)

Also, for new readers of this thread/the spreadsheet, I have been listing prices in pesos if that is what is provided, but have also converted the price to U.S. dollars - the problem with that is that the conversion rate changes quite often, so what I show may be incorrect since I don't update it for weeks or months.

Cozumel Dive Ops

 

[ReefHound]

Just an update on the spreadsheet. After updating the prices and some other info for most of the dive ops listed, I got the bright idea to make another column (just before the prices) with a link to the price page of the dive op, if it has one. So yes, there are now 2 links in different columns for an op - 1 for the home page and 1 for the price page (if there is one.)

Also, for new readers of this thread/the spreadsheet, I have been listing prices in pesos if that is what is provided, but have also converted the price to U.S. dollars - the problem with that is that the conversion rate changes quite often, so what I show may be incorrect since I don't update it for weeks or months.

Cozumel Dive Ops

Suggestion to have the exchange rate in one cell and have it referenced in a formula, that way you only need to update the one cell to have all the converted prices up to date.

 

[jonhall]

Suggestion to have the exchange rate in one cell and have it referenced in a formula, that way you only need to update the one cell to have all the converted prices up to date.

Interesting! I like it!! Not sure I can do it!!! Haha!

So the cell that I now show both pesos and dollars in would only show the converted US dollar price?

Thinking out loud, would the number of cells increase by more than 1? One for the exchange rate, one in pesos, one in US dollars, and then possibly more for any multiple dive rates I currently show. I do this kind of thing with Numbers (Apple) but haven't tried in a Google doc.

Thanks for the suggestion. I'll explore a little bit but it will be awhile as I'm heading to Coz in a couple of days.

 

[ReefHound]

Interesting! I like it!! Not sure I can do it!!! Haha!

So the cell that I now show both pesos and dollars in would only show the converted US dollar price?

Thinking out loud, would the number of cells increase by more than 1? One for the exchange rate, one in pesos, one in US dollars, and then possibly more for any multiple dive rates I currently show. I do this kind of thing with Numbers (Apple) but haven't tried in a Google doc.

Thanks for the suggestion. I'll explore a little bit but it will be awhile as I'm heading to Coz in a couple of days.

You could also use CONCATENATE function to mix the static US price with the dynamic peso conversion. Although it might be easier from a maintenance perspective to add a column. The cell for the exchange rate would be one for the entire sheet not per row.

 

[rsingler]

The $ in a formula means the reference won't change when you copy the formula down a bunch of rows.