AlmondFarmer Posted July 15, 2021 Report Share Posted July 15, 2021 3 hours ago, twangster said: Half the fun of cruising is planning the cruise. For me some of the fun is also tracking it all and feeding my spreadsheet. Twangster, what is your hard drive storage capacity? I’m afraid a spreadsheet of your design and expanse would crash my laptop, dependably running on XP since 2007. I have a spreadsheet on this computer, my $/day cost of computer ownership is currently $.17 Vancity Cruiser 1 Quote Link to comment Share on other sites More sharing options...
Vancity Cruiser Posted July 15, 2021 Report Share Posted July 15, 2021 4 hours ago, teddy said: This thread has shown me that I really need to up my cruise game. I’m pulling rookie numbers over here. Everyone I know thinks I am crazy because I go on 3 cruises a year. Then I come on here and see these lists and feel so insignificant lol teddy, JimnKathy and WAAAYTOOO 1 1 1 Quote Link to comment Share on other sites More sharing options...
twangster Posted July 15, 2021 Report Share Posted July 15, 2021 13 minutes ago, AlmondFarmer said: Twangster, what is your hard drive storage capacity? I’m afraid a spreadsheet of your design and expanse would crash my laptop, dependably running on XP since 2007. I have a spreadsheet on this computer, my $/day cost of computer ownership is currently $.17 Most definitely. Apple Numbers doesn't work on Winblows. CruisingOz, Nicci and AlmondFarmer 1 2 Quote Link to comment Share on other sites More sharing options...
AlmondFarmer Posted July 15, 2021 Report Share Posted July 15, 2021 4 hours ago, twangster said: My run rate is 27% on the deluxe drink packages. Do you have a column for $/drink when purchasing beverage package? If so, is the denominator value dependable? Quote Link to comment Share on other sites More sharing options...
dswallow Posted July 15, 2021 Author Report Share Posted July 15, 2021 Calculating my "Crystal @nnn" column: Column M is the current point total, so the above $M30 is the point total at the end of the current sailing, $M29 is the point total at the end of the prior sailing. I'm kinda laughing that our point totals are actually both in column M in our completely different spreadsheets. (Sorry, had to post the formula as an image because cloudflare detects something in there as an SQL attack. Someone has configured some really poorly-created script to look for such things.) Nicci 1 Quote Link to comment Share on other sites More sharing options...
smokeybandit Posted July 15, 2021 Report Share Posted July 15, 2021 You people are cruise-a-holic dorks. And I hope I can be just like you when I grow up teddy, KristiZ, barbeyg and 3 others 2 4 Quote Link to comment Share on other sites More sharing options...
AlmondFarmer Posted July 15, 2021 Report Share Posted July 15, 2021 4 hours ago, twangster said: How much did Pinnacle cost? I'm not saying, but my spreadsheet knows. Twangster, final question- What element would your Pinnacle pin need to be made of (excluding unobtanium and cryptanite) to be in excess of $ spent to reach this acclaimed status? KristiZ 1 Quote Link to comment Share on other sites More sharing options...
dswallow Posted July 15, 2021 Author Report Share Posted July 15, 2021 5 hours ago, twangster said: How much did Pinnacle cost? I'm not saying, but my spreadsheet knows. I most always book Ocean View Balcony. I have Boardwalk View Balcony rooms booked on Oasis. But there were 3 times I did Promenade View Interior and twice just an Ocean View. In total, including as much as I've managed to track, which includes airfare when needed, hotel stays when needed, transportation, parking, drink/internet packages (so far have always purchase the deluxe beverage package and VOOM SURF+STREAM every single time), and the occasional unlimited dining package, plus insurance costs, onboard incidentals, and gratuities... and in reality I have no doubt there's probably well more than $1,000 across all that I've not tracked well. But those would truly be very incidental expenses. But not including any (very occasional) gambling expenses. And I suppose one day I may go back through it all and fine tune it a bit when I can identify some missing items (sometimes it's more difficult to attribute some costs, like if I'm combining a cruise trip with a business trip, how should I attribute airfare, for instance). Anyway based on what I have been tracking I will have spent $74,452.10 to reach Pinnacle Club status when I do reach it this coming January, on my 31st Royal Caribbean sailing with a total of 259 cruise nights since October 2016. Ampurp85, Nicci, AlmondFarmer and 2 others 3 2 Quote Link to comment Share on other sites More sharing options...
dswallow Posted July 15, 2021 Author Report Share Posted July 15, 2021 Cruise Fare alone (no port taxes/fees, or any other expense) comes to $45,065.00. Port taxes/fees total $4,133.31. Drink Packages total $15,196.66. Internet totals $2,676.84. I received a total of $3,293.50 in onboard credit for various reasons -- booking promotions, NextCruise promotions, Shareholder benefits. Statistics are fun. Quote Link to comment Share on other sites More sharing options...
twangster Posted July 15, 2021 Report Share Posted July 15, 2021 1 hour ago, AlmondFarmer said: Do you have a column for $/drink when purchasing beverage package? If so, is the denominator value dependable? I started to track this but after several drinks I could no longer read what I had typed in the spreadsheet. foxrunner, WAAAYTOOO, AlmondFarmer and 3 others 1 4 1 Quote Link to comment Share on other sites More sharing options...
AlmondFarmer Posted July 15, 2021 Report Share Posted July 15, 2021 11 minutes ago, dswallow said: Cruise Fare alone (no port taxes/fees, or any other expense) comes to $45,065.00. The Ultimate family suite on Symphony was in excess of this for Holiday 2022 sailing….7 nights. I booked something else. WAAAYTOOO 1 Quote Link to comment Share on other sites More sharing options...
twangster Posted July 15, 2021 Report Share Posted July 15, 2021 1 hour ago, dswallow said: I'm kinda laughing that our point totals are actually both in column M in our completely different spreadsheets. Column M'ers of the world unite! WAAAYTOOO, dswallow and CruisingOz 2 1 Quote Link to comment Share on other sites More sharing options...
Nicci Posted July 15, 2021 Report Share Posted July 15, 2021 @twangster, thank you from a fellow Numbers user twangster 1 Quote Link to comment Share on other sites More sharing options...
Psycho and Barb Posted July 16, 2021 Report Share Posted July 16, 2021 We are glad they are keeping it. We will get our first one on the Explorer of the Seas this Nov. WAAAYTOOO and CruisingOz 2 Quote Link to comment Share on other sites More sharing options...
Pattycruise Posted July 22, 2021 Report Share Posted July 22, 2021 It will be interesting to see if I receive this or if they offer to ship it to me. I’ll be hitting the 70 point mark on my first night of my upcoming cruise Quote Link to comment Share on other sites More sharing options...
dswallow Posted July 22, 2021 Author Report Share Posted July 22, 2021 40 minutes ago, Pattycruise said: It will be interesting to see if I receive this or if they offer to ship it to me. I’ll be hitting the 70 point mark on my first night of my upcoming cruise You won't get one until your reach 140 points, and then at every additional 70 points. Quote Link to comment Share on other sites More sharing options...
ChrisK2793 Posted July 22, 2021 Report Share Posted July 22, 2021 I meant to ask this earlier …….. if 2 adults and 1 child are in a family ………then 1 of the adults and the child go on the cruise that gets them all to 140 points and behind, do both the adult and the child each get a block? Next question is ……. If the adult who doesn’t come on the cruise where the first block is earned and way surpasses 140 after the cruise they didn’t come on because of the family connection …… will that adult get a block on the next cruise since they weren’t on the cruise where they earned past the 140? Lastly, all 3 of us will be on the cruise where we surpass 210 points for the next block, will all 3 of us get one? Thanks in advance Quote Link to comment Share on other sites More sharing options...
dswallow Posted July 22, 2021 Author Report Share Posted July 22, 2021 1 hour ago, ChrisK2793 said: I meant to ask this earlier …….. if 2 adults and 1 child are in a family ………then 1 of the adults and the child go on the cruise that gets them all to 140 points and behind, do both the adult and the child each get a block? Next question is ……. If the adult who doesn’t come on the cruise where the first block is earned and way surpasses 140 after the cruise they didn’t come on because of the family connection …… will that adult get a block on the next cruise since they weren’t on the cruise where they earned past the 140? Lastly, all 3 of us will be on the cruise where we surpass 210 points for the next block, will all 3 of us get one? Thanks in advance Generally family units share a single block when they're sharing a cabin and hitting the points needed simultaneously. In practice, I'm not sure what people may or may not convince a loyalty ambassador to give them outside that policy. It generally doesn't seem particularly fair when you consider how it works with a solo cruiser and double points, though in practice I'd suspect a family is typically not caring about getting duplicates for each person, either. And I'm not sure about how a child in the mix may alter anything, but I wouldn't expect it would. ChrisK2793 1 Quote Link to comment Share on other sites More sharing options...
Hoppy2cruise Posted July 22, 2021 Report Share Posted July 22, 2021 Crown & Anchor Terms & Conditions state One (1) gift is awarded per relationship. I have 14 points more than my husband, but we are linked so we both show the same number of points. I did wonder if we would receive a second block when his personal total hit the milestone and the answer was no - not even if we were not linked. ChrisK2793 1 Quote Link to comment Share on other sites More sharing options...
ChrisK2793 Posted July 22, 2021 Report Share Posted July 22, 2021 18 minutes ago, Hoppy2cruise said: Crown & Anchor Terms & Conditions state One (1) gift is awarded per relationship. I have 14 points more than my husband, but we are linked so we both show the same number of points. I did wonder if we would receive a second block when his personal total hit the milestone and the answer was no - not even if we were not linked. ‘Thank you Quote Link to comment Share on other sites More sharing options...
J_Keeble Posted July 23, 2021 Report Share Posted July 23, 2021 On 7/15/2021 at 2:28 AM, twangster said: My spreadsheet uses a formula to write the word Block into a cell and then conditional formatting rules makes it appear or disappear. My points column looks at cruise duration and depending on cabin type and date relative to the dates of the double points promo it automatically calculates the bonus multiplier. When they extended the date of the double points promo i just corrected one cell and all my new blocks updated. It also colors my points background to match the CAS color at each level. If I insert or remove a cruise it recalculates the block projection automatically. I also note the deposit type and if I applied an FCC so I know to be careful with that booking. It also calculates the price per night and price per C&A point then applies a color background based on fixed price ranges. The greener it is the better the deal it is. I may have a problem. wow look at this!! is it possible to get a copy of this excel spreadsheet? it looks fantastic. Quote Link to comment Share on other sites More sharing options...
PG Cruiser Posted October 22, 2021 Report Share Posted October 22, 2021 By my projections, I should be getting my first glass block on the Oasis where I get to 140 points. Now for my second block, I'm expecting to get in on the Independence. Now if I skip (cancel) my Independence sailing, I will get to 210 on the Wonder. Do you think the Wonder will have the glass blocks available during the Inaugural? Quote Link to comment Share on other sites More sharing options...
Toby Posted October 23, 2021 Report Share Posted October 23, 2021 On 7/14/2021 at 11:57 AM, dswallow said: I'm told it was announced today that Royal Caribbean will phase out distributing Crystal Blocks to Crown & Anchor members at 70-point milestones and will allow the current inventory to deplete. They claim 60% of them were being left behind in the cabin. Well, I say that would be a cost saving measure to be able to give people a benefit then recycle them for others. Anyway, they're apparently also trying to figure out what to replace it with, like a mention at the top tier event or perhaps a printed certificate. Neither my wife or I remember ever remember getting one and we would have received 2 by now. Hmmmmm Quote Link to comment Share on other sites More sharing options...
barjpoe Posted October 23, 2021 Report Share Posted October 23, 2021 Anyone doing the World Cruise will be able to receive 4 blocks of the same ship WAAAYTOOO and Poolside 2 Quote Link to comment Share on other sites More sharing options...
GKMCruising Posted October 24, 2021 Report Share Posted October 24, 2021 On 10/22/2021 at 3:49 PM, PG Cruiser said: By my projections, I should be getting my first glass block on the Oasis where I get to 140 points. Now for my second block, I'm expecting to get in on the Independence. Now if I skip (cancel) my Independence sailing, I will get to 210 on the Wonder. Do you think the Wonder will have the glass blocks available during the Inaugural? In theory, even if they don't, they should be able to mail it to you once they get them. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.