Updated S Class Cabin Spreadsheet

[cruzzzinma]

I have updated the amazing librarylady19’s S Class Cabin spreadsheet and it can be found here: S Class Cabins

 

Please help me help you. When posting to the S Class Cabin Information Compilation sticky, PLEASE use the following format:

 

Cabin #:

Ship:

Deck:

Class:

Area:

Bed Near Bath or Balcony:

Quiet?

Balcony View:

Balcony Size:

Wind a Problem:

Soot a Problem:

Problems/Comments:

 

Please keep the colons “:”, don’t add in extra blank lines and do put long comments in the “Comments” section. If you keep the format consistent, it will be easier for me to maintain the spreadsheet.

 

I've posted this in the cabin sticky thread as well.

[jelayne]

Thanks for doing this it is such a helpful spreadsheet.

[Lastdance]

I second that "thank you[emoji844]"

[MustBCruzn]

Thank you!!! The spreadsheet is my go-to reference and I'm so thrilled to have it updated. I know it's a serious pain in the neck, and I really appreciate all your efforts (and Librarylady's efforts before you)!

[bEwAbG]

Using the TRIM function in Excel is a good way to take care of getting rid of those pesky extra spaces without a lot of work. TRIM formula in one column (or row, depending on how you're doing it), then copy and Paste Values. It will remove leading spaces and trailing spaces as well as taking out extra spaces in a string of text (like if someone double-spaces in the middle of a sentence).

Edited May 7, 2016 by bEwAbG

[cruzzzinma]

Using the TRIM function in Excel is a good way to take care of getting rid of those pesky extra spaces without a lot of work. TRIM formula in one column (or row, depending on how you're doing it), then copy and Paste Values. It will remove leading spaces and trailing spaces as well as taking out extra spaces in a string of text (like if someone double-spaces in the middle of a sentence).

 

I trimmed all the data I entered, but i just went back and trimmed the entire spreadsheet. Unfortunately, trimming won't take care of blank lines.

 

If the format is followed, I can copy the message contents, paste it into excel, and use the colons to covert to two columns. Blank lines create a blank row of cells. i had an efficient operation going yesterday - by using the same sheet and pasting message contents, it automatically covered the data into two columns and trimmed the needed info into a third column. Then I just had to go to the main spreadsheet and paste transposed data.

[thebutlerdidit]

Thank you for taking this on, cruzzzinma! I like to keep this spreadsheet bookmarked for quick reference.

[wadden]

Thanks so much, a great help altogether. Best wishes.

[BecciBoo]

Thank you thank you thank you:D

[Lin336]

Thank you so much!

[fantasy51]

Fantastic work! I am so pleased to see that you have added that amazing little feature that keeps the heading in place even as we scroll down and down. (I have seen it before on spreadsheets but have never needed to work out how to do it.)

[phyllisrf]

I am getting a blank page when I click on post number 1

[Bradiego]

This is great and helping me decide on my cabin choice for my December 2017 Reflection cruise, thank you so much!!

[Swissmiss6253]

Thank you, much appreciated

[rogfam]

Thank you so much!!!

[cruise47]

Thanks you. Thanks you. Just an Outstanding spread sheet!!

[Tommy3putts]

Woohoo! Thank you!

[Gracie115]

I have updated the amazing librarylady19’s S Class Cabin spreadsheet and it can be found here: S Class Cabins

 

Please help me help you. When posting to the S Class Cabin Information Compilation sticky, PLEASE use the following format:

 

Cabin #:

Ship:

Deck:

Class:

Area:

Bed Near Bath or Balcony:

Quiet?

Balcony View:

Balcony Size:

Wind a Problem:

Soot a Problem:

Problems/Comments:

 

Please keep the colons “:”, don’t add in extra blank lines and do put long comments in the “Comments” section. If you keep the format consistent, it will be easier for me to maintain the spreadsheet.

 

I've posted this in the cabin sticky thread as well.

 

Thank you so much for updating the spreadsheet...it is so helpful to everyone!

[Kate333]

Can anyone tell me how to scroll up easily or find a cabin quickly ?? Thank you

[gangbuster]

I am glad to see someone took on this ladies quest to give cruisers some idea of cabin types, location etd.

Good Job