Jump to content

And there go the Crystal Blocks...


Recommended Posts

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

Link to comment
Share on other sites

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.  

Link to comment
Share on other sites

Calculating my "Crystal @nnn" column:

image.png.904e8fd24f0d14ea00ab69a862f5a562.png

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

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites


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 ?

 

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 ?

Link to comment
Share on other sites

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. 

1544971220_ScreenShot2021-07-14at9_30_51PM.thumb.jpg.503f6df9ad5cfc7505a7c999d9a54630.jpg   

I also note the deposit type and if I applied an FCC so I know to be careful with that booking.

2012958437_2022BlockForecast.thumb.jpg.54b11c4686d0b3dd1358424dadb586b3.jpg

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.

1943033359_ScreenShot2021-07-14at9_38_18PM.jpg.b942c326ec59960dd809125557e7b1c8.jpg

 

I may have a problem.  

wow look at this!! is it possible to get a copy of this excel spreadsheet? it looks fantastic.

Link to comment
Share on other sites

  • 2 months later...

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
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...
 Share

×
×
  • Create New...