cruzzzinma Posted May 6, 2016 #1 Share Posted May 6, 2016 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. Link to comment Share on other sites More sharing options...
jelayne Posted May 6, 2016 #2 Share Posted May 6, 2016 Thanks for doing this it is such a helpful spreadsheet. Link to comment Share on other sites More sharing options...
Lastdance Posted May 7, 2016 #3 Share Posted May 7, 2016 I second that "thank you[emoji844]" Link to comment Share on other sites More sharing options...
MustBCruzn Posted May 7, 2016 #4 Share Posted May 7, 2016 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)! Link to comment Share on other sites More sharing options...
bEwAbG Posted May 7, 2016 #5 Share Posted May 7, 2016 (edited) 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 Link to comment Share on other sites More sharing options...
cruzzzinma Posted May 7, 2016 Author #6 Share Posted May 7, 2016 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. Link to comment Share on other sites More sharing options...
thebutlerdidit Posted May 7, 2016 #7 Share Posted May 7, 2016 Thank you for taking this on, cruzzzinma! I like to keep this spreadsheet bookmarked for quick reference. Link to comment Share on other sites More sharing options...
wadden Posted May 27, 2016 #8 Share Posted May 27, 2016 Thanks so much, a great help altogether. Best wishes. Link to comment Share on other sites More sharing options...
Rare BecciBoo Posted May 27, 2016 #9 Share Posted May 27, 2016 Thank you thank you thank you:D Link to comment Share on other sites More sharing options...
Lin336 Posted May 27, 2016 #10 Share Posted May 27, 2016 Thank you so much! Link to comment Share on other sites More sharing options...
fantasy51 Posted May 27, 2016 #11 Share Posted May 27, 2016 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.) Link to comment Share on other sites More sharing options...
phyllisrf Posted May 27, 2016 #12 Share Posted May 27, 2016 I am getting a blank page when I click on post number 1 Link to comment Share on other sites More sharing options...
Bradiego Posted May 28, 2016 #13 Share Posted May 28, 2016 This is great and helping me decide on my cabin choice for my December 2017 Reflection cruise, thank you so much!! Link to comment Share on other sites More sharing options...
Swissmiss6253 Posted May 28, 2016 #14 Share Posted May 28, 2016 Thank you, much appreciated Link to comment Share on other sites More sharing options...
rogfam Posted May 28, 2016 #15 Share Posted May 28, 2016 Thank you so much!!! Link to comment Share on other sites More sharing options...
cruise47 Posted May 28, 2016 #16 Share Posted May 28, 2016 Thanks you. Thanks you. Just an Outstanding spread sheet!! Link to comment Share on other sites More sharing options...
Tommy3putts Posted May 28, 2016 #17 Share Posted May 28, 2016 Woohoo! Thank you! Link to comment Share on other sites More sharing options...
Gracie115 Posted May 28, 2016 #18 Share Posted May 28, 2016 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! Link to comment Share on other sites More sharing options...
Kate333 Posted May 28, 2016 #19 Share Posted May 28, 2016 Can anyone tell me how to scroll up easily or find a cabin quickly ?? Thank you Link to comment Share on other sites More sharing options...
gangbuster Posted August 20, 2019 #20 Share Posted August 20, 2019 I am glad to see someone took on this ladies quest to give cruisers some idea of cabin types, location etd. Good Job 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