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

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...