wichitastatecruiser Posted May 16, 2014 #1 Share Posted May 16, 2014 Version 1.2: Full fleet wide wine by glass, buckets of beer added, formatting changes, corrections to formulas. Version 1.3 being worked on will include wine by the bottle to be uploaded by Monday. NCL Drink Spreadsheet Version 1.2.xls Link to comment Share on other sites More sharing options...
phoenix1181 Posted May 16, 2014 #2 Share Posted May 16, 2014 Two things. Your formula seems to only go to 7 days & there's no regular drinks like rum & coke or vodka & tonic. BUT.......... It's a great idea & adjustments are easy to make. Link to comment Share on other sites More sharing options...
LrgPizza Posted May 16, 2014 #3 Share Posted May 16, 2014 Version 1.2: Full fleet wide wine by glass, buckets of beer added, formatting changes, corrections to formulas. Version 1.3 being worked on will include wine by the bottle to be uploaded by Monday. If I knew how to upload spreadsheets, I'd take about 6 seconds to edit that column R for you so that this worked for cruises over 7 days in length, but I don't so I can't. Sorry! I wish I could help. Link to comment Share on other sites More sharing options...
wichitastatecruiser Posted May 16, 2014 Author #4 Share Posted May 16, 2014 Yup I caught that my formula only captured 7 days after I uploaded. I originally had the spreadsheet for 7 days only and added the extra days so that the sheet can be used for all cruises. I already have it fixed so that will be functional on the next version. If someone has the call prices let me know so I can add those on. The NCL wine list is a 18 page document so the next update will probably take me a day or two... Link to comment Share on other sites More sharing options...
wichitastatecruiser Posted May 16, 2014 Author #5 Share Posted May 16, 2014 Correctly prices out to 15 day cruises NCL Drink Spreadsheet Version 1.21.xls Link to comment Share on other sites More sharing options...
JuneauMe Posted May 16, 2014 #6 Share Posted May 16, 2014 Version 1.2: Full fleet wide wine by glass, buckets of beer added, formatting changes, corrections to formulas. Version 1.3 being worked on will include wine by the bottle to be uploaded by Monday. Thank you for doing this. It's really helpful :D Link to comment Share on other sites More sharing options...
jazzydiver Posted May 16, 2014 #7 Share Posted May 16, 2014 Yes, thanks for all your work on this. I already knew the UBP won't be worth it for me, but the spreadsheet is great for getting an idea of how much to budget! :) Link to comment Share on other sites More sharing options...
NH Cruisers Posted May 16, 2014 #8 Share Posted May 16, 2014 I would have to drink roughly 10 beers a day for the UBP to work in my favor. I don't think I could do it, maybe one or two days. Not all of them. I will continue to purchase drinks individually. Link to comment Share on other sites More sharing options...
Single Cruiser Posted May 16, 2014 #9 Share Posted May 16, 2014 Does anyone have the prices of the standard spirits, I normally drink Grey Goose on the package which is one of the more pricier spirits. Also the classic cocktails like black/White Russians. Link to comment Share on other sites More sharing options...
youngestof9 Posted May 16, 2014 #10 Share Posted May 16, 2014 (edited) Two things. Your formula seems to only go to 7 days & there's no regular drinks like rum & coke or vodka & tonic. BUT.......... It's a great idea & adjustments are easy to make. Rum and (diet) coke is my drink of choice and it was roughly $6.50 (I can't remember if that's before or after gratuity), so pick one of the drinks on the list that's around that price. and witchitastatecruiser- THANK YOU for this spreadsheet - I'm totally a numbers geek and am having fun with this :) Edited May 16, 2014 by youngestof9 Link to comment Share on other sites More sharing options...
Demonyte Posted May 16, 2014 #11 Share Posted May 16, 2014 OP, why wouldn't you put this to Google Drive (Google Spreadsheet) and share the link pointing there, that way it would be accessible to anyone with a browser (no need to download files and having compatible program) and you wouldn't need to worry about versions etc, just update the spreadsheet there and that's it, the link stays the same. Link to comment Share on other sites More sharing options...
Demonyte Posted May 16, 2014 #12 Share Posted May 16, 2014 Rum and (diet) coke is my drink of choice and it was roughly $6.50 (I can't remember if that's before or after gratuity), so pick one of the drinks on the list that's around that price. Well liquors are $5.75 before gratuity, can't remember what the price of next group was as I too drink basic rums (usually Bacardi Oakheart to be exact), Premium spirits were above those two. Link to comment Share on other sites More sharing options...
cruiseladyrae Posted May 16, 2014 #13 Share Posted May 16, 2014 Are there any "bottle" beer for $5.25? Link to comment Share on other sites More sharing options...
phoenix1181 Posted May 17, 2014 #14 Share Posted May 17, 2014 I just checked my receipts. Grey Goose was $6.75 last week on the dawn. Link to comment Share on other sites More sharing options...
Single Cruiser Posted May 17, 2014 #15 Share Posted May 17, 2014 I just checked my receipts. Grey Goose was $6.75 last week on the dawn. Thanks. I think the classic cocktails like Black Russian were about $7 (with house spirits) Link to comment Share on other sites More sharing options...
wichitastatecruiser Posted May 17, 2014 Author #16 Share Posted May 17, 2014 OP, why wouldn't you put this to Google Drive (Google Spreadsheet) and share the link pointing there, that way it would be accessible to anyone with a browser (no need to download files and having compatible program) and you wouldn't need to worry about versions etc, just update the spreadsheet there and that's it, the link stays the same. Don't know how to use Google drive. Also working in spurts, would I be able to work off-line and not make changes to the the on-line version? I'm almost done with version 1.3. Been doing LOTS of tests and added NEW features. version 1.3 should be close to final when I upload it. Number geeks and spendthrifts are going to LOVE it! Link to comment Share on other sites More sharing options...
Rare aubreyc1988 Posted May 17, 2014 #17 Share Posted May 17, 2014 Ack, I'm trying to figure out how to enter stuff in whenever I download the file but its not letting me! :confused: Link to comment Share on other sites More sharing options...
medicalma'am Posted May 18, 2014 #18 Share Posted May 18, 2014 I just opened it with excel and it worked wonderfully. I entered even the things that I would not usually order because of the cost and it is not worth it for me. I may print it out for my next cruise with my sisters as a guide. Thank you for doing this!!! Link to comment Share on other sites More sharing options...
wichitastatecruiser Posted May 18, 2014 Author #19 Share Posted May 18, 2014 I just uploaded what I believe to be the "final" version of the spreadsheet. Its SUPER fancy! It has its own thread! Link to comment Share on other sites More sharing options...
AweighToSea Posted May 18, 2014 #20 Share Posted May 18, 2014 Don't know how to use Google drive. Also working in spurts, would I be able to work off-line and not make changes to the the on-line version? I'm almost done with version 1.3. Been doing LOTS of tests and added NEW features. version 1.3 should be close to final when I upload it. Number geeks and spendthrifts are going to LOVE it! I agree here is better. The are a few folks, i.e. me, who does not use googley services. Also before moving away from them I tried their docs but do not like the immediate automatic saves. Good for collaboration but not for what you are wanting to do and make edits over a long period of time and then release when ready. The simple start is growing into the definitive tool for those wanting to get the biggest big for their buck. Well done! Link to comment Share on other sites More sharing options...
AweighToSea Posted May 18, 2014 #21 Share Posted May 18, 2014 Ack, I'm trying to figure out how to enter stuff in whenever I download the file but its not letting me! :confused: Your spreadsheet program is not letting you edit? Editing might be disabled because your program is suspicious of the source. My Excel did block editing with a warning about downloaded files, they can contain code (hidden) that can be a security risk so had to acknowledge that warning in order to allow editing. Link to comment Share on other sites More sharing options...
medicalma'am Posted May 19, 2014 #22 Share Posted May 19, 2014 This is so much fun to play with!!! Link to comment Share on other sites More sharing options...
Planmaam Posted May 19, 2014 #23 Share Posted May 19, 2014 This is very cool! No way is the drink package a deal for me, either. Easy to figure out with the spreadsheet, as if I hadn't already determined that! Link to comment Share on other sites More sharing options...
fer10 Posted August 8, 2014 #24 Share Posted August 8, 2014 Thanks this is extremely helpful Link to comment Share on other sites More sharing options...
GrabMyWrist Posted August 8, 2014 #25 Share Posted August 8, 2014 (edited) V1.3 is even better. http://boards.cruisecritic.com/showthread.php?t=2043438 Edited August 8, 2014 by GrabMyWrist Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now