Pop Sugar's Annual Ultimate Reading Challenge discussion

I updated the Google Spreadsheet to include this year - hopefully it all works and calculates correctly!

Michelle wrote: "I updated the Google Spreadsheet to include this year - hopefully it all works and calculates correctly!"

Thank you Michelle! Look great to me.

Thanks for the spreadsheet. I am new to this. Am I able to edit the spreadsheet by adding a column for myself? How does that work?

Shirley wrote: "Thanks for the spreadsheet. I am new to this. Am I able to edit the spreadsheet by adding a column for myself? How does that work?"

Yes, you can create a column for yourself and edit only that column.

Alternately you can create your own copy. If you create your own copy you can edit anything.

I am new to this chat and saw that you created a spreadsheet. Where can I find said spreadsheet? Thank you in advance.

Stacy wrote: "I am new to this chat and saw that you created a spreadsheet. Where can I find said spreadsheet? Thank you in advance."

Hi Stacy! The link is in the group description but I'll drop it here as well: https://docs.google.com/spreadsheets/...

The spreadsheet is editable by everyone so please only edit your column. (alternately, feel free to make a copy for yourself and edit the personal copy however you want to.)

If you want to keep it simple, the spreadsheet format is great.

If you want your books to sort by what you want to read next, automatically rate authors based on book ratings, and so much more, you might enjoy using the free tool I created.

With greater power comes greater complexity, so I created this video explainer: https://youtu.be/Pn6C7sNIe3A

There's a link to the tool in the video info.

Caitlin wrote: "Stacy wrote: "I am new to this chat and saw that you created a spreadsheet. Where can I find said spreadsheet? Thank you in advance."

Hi Stacy! The link is in the group description but I'll drop i..."

Caitlin, I'm sorry but I accidently deleted #27 from spreadsheet and I don't know what it is to replace it

I've added #27 back in as:
27. A book about a social justice issue
I see why you had trouble finding it. The order on the sheet is not the same as the order on the Popsugar post:
https://www.popsugar.com.au/entertain...

Hi--Hoping it is a google issue somewhere, but I opened the google spreadsheet and none of the books for anyone is listed! Yikes-will try again tomorrow.... hoping it is the phase of the moon!

Shirley wrote: "Hi--Hoping it is a google issue somewhere, but I opened the google spreadsheet and none of the books for anyone is listed! Yikes-will try again tomorrow.... hoping it is the phase of the moon!"

I'm glad I'm not the only one! No names or books, just colors.

Molly wrote: "Shirley wrote: "Hi--Hoping it is a google issue somewhere, but I opened the google spreadsheet and none of the books for anyone is listed! Yikes-will try again tomorrow.... hoping it is the phase o..."

I'll take a look and see if edits need to be reversed.

And everything is back on the spreadsheet. Yeah--Molly (i am assuming) did the trick. Thanks! Shirley

I restored from a previous version. Someone anonymous appears to have deleted everything.

I'm not sure if anyone else has the ability to see edit history and restore, but if this happens again (it tends to happen a couple times, presumably from people who don't realize they're on the public copy) feel free to reach out to me to fix it!

Thanks so much for raising the issue this time.

Just in case any one comes here for a link, I've had to move the spreadsheet. New link is here: https://docs.google.com/spreadsheets/...