Thread:AndalayBay/@comment-26224165-20170203205831

Hi Lori,

I downloaded a copy of your Collections List file and used Excel's Conditional Formatting to find the differences between your spreadsheet and mine.For each difference identified, I used the game's Collection data to identify which spreadsheet contained the error.

I corrected/updated both spreadsheets and used a yellow cell fill color to hilight changes to your spreadsheet.

Two things of note:

I did not do any verification on the last 2 columns in your spreadsheet (Reward Type, Sort), and

in the Rewards column, the only difference I found was that you use, "(The) average weight" instead of the game's. "The average weight". I flagged these entries using a bold, red font, but I didn't change them, figuring that this change was intentional.

What is the best way to get this file to you? I removed the Conditional Formatting from the file, so it only contains clean text.

~Donald 