Board Thread:Eureka Moments/@comment-28625361-20160511042215/@comment-26722955-20160512175040

CjustC wrote:

I probably shouldn't admit this out loud but the opportunity to geek out on the game with spreadsheets is no small part of the fun for me, ha ha. It's true. I keep another spreadsheet listing all the collections and what they reward and which combining elements are needed. It took a ridiculous amount of time to put it together but it has been the source of much joy and gratification for my inner nerd on a near-daily basis for the last year. I can easily search for alternative CI's to send if a friend is requesting a CI I don't have. Or I can sort the list by category to see what the various CE requirements are for, say, dinners, and send the collection to a friend that requires the least amount of CE's. Also, numbering the collections in order allowed me to create a formula to calculate how many swipes it would take to get to any CI I might want to send. I could go on about my spreadsheets but I should probably stop there, lol.

OMG C! You are my twin! However, I don't have a spreadsheet of the collections - I have a DATABASE! I use TapForms on my iOS devices to keep track of them. I have 3 linked forms in it. The first one is a list of the collections (in order), their rewards, and if I have completed it on both of each game. The second is the individual collection items with their regular location and quest location. Also whether or not they are giftable. The third form is the combining elements required for each quest. And I can not believe you said that about the swipe requirements as I have been thinking of doing the exact same thing! However, I need to come up with 2 since I play on both an iPhone and an iPad. And you have to take into consideration the CI's that are not giftable. I think I can do this in my database, but I could always make a separate spreadsheet just as easily. You have motivated me to work on this further.