Jump to content
Grenadyr

Experimental Drink Package Calculator

Recommended Posts

I made a spreadsheet to calculate my break even point for getting the Deluxe Beverage Package on an upcoming cruise.  It turned out to be pretty useful and I thought others might find it interesting.  So...  I made a site on Wix to host an online version of the calculator for anyone that might be interested.

DrinkCalc

DrinkCalc V.2  (Now prettier and hopefully easier to use.)

I'm open to feedback to improve it as needed.  Keep in mind the options for style are limited but I can tweak the math as much as I want.

Edited by Grenadyr
Added V.2 link

Share this post


Link to post
Share on other sites

This looks really good! Two minor comments:

  1. I know you said you're limited in how much control you have over layout, but is it possible to have the calculator panel just be entirely on the main page, instead of being embedded inside a scrolling pane? While it works fine on a desktop computer and a tablet, the current setup makes using the page very hard on a  smartphone -- I wasn't able to scroll the inner pane half the time, and tapping on a control lower down in the pane like "Bottled Water" or "Percent of time on ship in port days" would cause the panel to jump back to the top
  2. I think saying that 50% of a port day is spent on the ship is a little high, although I realize it's pretty variable depending on the hours the ship is in port, how popular the port is, etc.
    • Defaulting to 33% might be a better / more conservative estimate, since a lot of the time people will leave the ship right after breakfast and not be back until shortly before dinner
    • I do realize that if you stay up late enough, you really can spend about 50% of your day on board, but I would argue you're not drinking over that 50% the same amount you would be if you were on board for the "50%" between breakfast and dinner, just because you're likely to be tired out, more inclined to want water for a while, etc.

Really appreciate this! It helps figure out the "magic number" for when to buy a package or not!

Share this post


Link to post
Share on other sites
7 hours ago, JLMoran said:

This looks really good! Two minor comments:

  1. I know you said you're limited in how much control you have over layout, but is it possible to have the calculator panel just be entirely on the main page, instead of being embedded inside a scrolling pane? While it works fine on a desktop computer and a tablet, the current setup makes using the page very hard on a  smartphone -- I wasn't able to scroll the inner pane half the time, and tapping on a control lower down in the pane like "Bottled Water" or "Percent of time on ship in port days" would cause the panel to jump back to the top
  2. I think saying that 50% of a port day is spent on the ship is a little high, although I realize it's pretty variable depending on the hours the ship is in port, how popular the port is, etc.
    • Defaulting to 33% might be a better / more conservative estimate, since a lot of the time people will leave the ship right after breakfast and not be back until shortly before dinner
    • I do realize that if you stay up late enough, you really can spend about 50% of your day on board, but I would argue you're not drinking over that 50% the same amount you would be if you were on board for the "50%" between breakfast and dinner, just because you're likely to be tired out, more inclined to want water for a while, etc.

Really appreciate this! It helps figure out the "magic number" for when to buy a package or not!

The first one I can't do much about due the limitations in the service I'm using.  I'll need to find a more flexible standalone website builder that I can work with.  Maybe changing the input fields to the same style as the cruise length and port stays will make it easier to scroll.  I noticed that scrolling on my phone would routinely screw up the values I entered on the drink sliders.

The second one is done.  I changed the default to 33 and allowed selection of any whole number value between 0 and 100.

Share this post


Link to post
Share on other sites
5 hours ago, Momof4crazytocruise said:

Thanks for this. While I knew deep down I would find no challenge getting my money's worth - now it seems justifiable 😛  Also, I drink too much evidently.

I know how you feel.  I'm not sure if I should be relieved or concerned that I should definitely get my monies worth buying the drink package.

Share this post


Link to post
Share on other sites
On 6/2/2019 at 7:33 AM, Cruzinfun said:

Thank you, this is really helpful and very simple!   

Glad it was helpful.  🙂

On 6/2/2019 at 10:21 AM, janesta said:

Thanks - this is really nice.  One suggestion would be to tell you which package would be your best bet based on selections.  For me, the DBP is a no-brainer 🙂

DBP was a pretty easy choice for me as well.  I may break even but its more about not seeing dollar signs every time I get a drink, and being able to relax instead.

I thought about the the drink package selection and feel it strays too far away from "pure" math and would involve logic and decision making work.  I'm just a geek / mechanic not a real programmer so its probably beyond my ability to do in a useful fashion.  I have made a different version of the calculator via a different service that may be more streamlined, but have yet to deploy it.

Share this post


Link to post
Share on other sites

Thanks for the update, @Grenadyr! This is much better on mobile than the prior version, and I definitely prefer the use of the +/- buttons vs. adjusting a slider.

Now if Royal would just get the Deluxe package on my sailing down / close to $46 / night...

Share this post


Link to post
Share on other sites

That's pretty good...I need to look more into those fresh squeezed OJ, premium coffees and milkshakes...I have been missing out!!!!

 

But for me..I know its worth it...its usually paid for the whole cruise on the first day...(on my 4 day cruises)..may take till end of day 2 to break even on my upcoming 7 day cruise.....:4_joy:

Share this post


Link to post
Share on other sites

This is great - we are coming up on our 4th cruise and this is the first time we've decided to get the drink package.  I always do some rough calculating to try to justify or not justify buying the drink package but this far superior to what i typically do. Thanks for sharing - it certainly make me feel better knowing that I made the right choice on the upcoming cruise.

Share this post


Link to post
Share on other sites

That’s pretty cool and drink package definitely a deal for me and I was conservative! 

It didn’t have champagne (we have a mimosa every morning) so I just added an extra wine. 

I’m assuming fruity, frozen drinks on the pool deck count as cocktails? 

Share this post


Link to post
Share on other sites
1 hour ago, Jill said:

It didn’t have champagne (we have a mimosa every morning) so I just added an extra wine.

Mimosa is probably counted / charged as just a regular mixed drink rather than wine, since the glass isn't filled with the bubbly. Either way...

Share this post


Link to post
Share on other sites

@Grenadyr, just had a thought about this calculator as I was using once again -- Is there a way to modify the program so that items like the Fresh-squeezed OJ (only available at breakfast) and specialty coffees (can argue most often bought in the morning, at least for the first one) are not "depreciated" in the spend-per-port-day calculation?

I'm just thinking that if someone expects to have a fresh OJ with breakfast every day, that would likely happen on port days as well as sea days. Likewise, if someone says they're only have one coffee a day then it's likely with or right after breakfast, and would be as likely to be bought on a port day as a sea day. Maybe the second coffee and higher still gets "depreciated" for port days, though. Same goes for bottled water -- people with the drink packages tend to always grab a bottle or two as they leave the ship to go into port, so they can stay hydrated through the day without having to buy any on land (if it's even available).

I don't know how much flexibility the calcapp site allows for things like that, but thought I'd mention it as it's always good to try and get as close to a real estimate as possible. It'd be especially useful for folks with the Refreshment package, since counting those drinks at full price on the port days helps better track how good the current price is vs. expected consumption.

Share this post


Link to post
Share on other sites
On 9/18/2019 at 6:25 PM, JLMoran said:

@Grenadyr, just had a thought about this calculator as I was using once again -- Is there a way to modify the program so that items like the Fresh-squeezed OJ (only available at breakfast) and specialty coffees (can argue most often bought in the morning, at least for the first one) are not "depreciated" in the spend-per-port-day calculation?

I'm just thinking that if someone expects to have a fresh OJ with breakfast every day, that would likely happen on port days as well as sea days. Likewise, if someone says they're only have one coffee a day then it's likely with or right after breakfast, and would be as likely to be bought on a port day as a sea day. Maybe the second coffee and higher still gets "depreciated" for port days, though. Same goes for bottled water -- people with the drink packages tend to always grab a bottle or two as they leave the ship to go into port, so they can stay hydrated through the day without having to buy any on land (if it's even available).

I don't know how much flexibility the calcapp site allows for things like that, but thought I'd mention it as it's always good to try and get as close to a real estimate as possible. It'd be especially useful for folks with the Refreshment package, since counting those drinks at full price on the port days helps better track how good the current price is vs. expected consumption.

@JLMoran , Good thought.  I'll have to think about that. Ultimately it would be easier if it was a selectable option but I'm at the limit for usable fields with the level of calcapp I subscribe to.  I might be able to rig something in the background calculations.  As it stands it would probably be a blanket removal of the depreciation for coffee, juice, and water.  That would be easily done without needing another field.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...