Talk:World Event/@comment-27019035-20151014015038/@comment-26243899-20151020055122

@SugarTeddys & DeeDe99 RE Spreadsheets:  I also have some cool spreadsheets. One for battle data, One for my Dragons. I have fallen way behind on my Dragon sheets but here is the gist (work in progress). I have my Main sheet subdivided by habitat with color coding for the habitats. I have other sheets with food requirements and earnings. On the earnings sheet I also have fields for Rarity and Incubation time. In the main sheet I have a VLOOKUP into the Earnings table using Dragon_Type as Search Crireria and Level as Index so It returns the Current Earnings. Similarly for Food I do a Lookup and have it return the amount of food currently required. Within each Habitat there is a Sum for Coins and then there are summaries totalling coins per hr over all habitats. I just updated the Earnings table Culled from here after parsing it in SPSS.

http://dragon-story.wikia.com/wiki/Dragon_Earning_Rates

and have appended the Rarity and Incubation/Evolve times for the dragons I or my SO have and some others I want to acquire. The thing is presently uder construction, but when it is up and running all I need to do is type in the Dragon type and level and it will propagate all of the lookups into the relevant tables. I had it working perfectly awhile back but then I moved a bunch of dragons around and F'd up some of the formulas so I'll need to go back in and fix up some pieces. Drop me a PM if you want a copy once it is finished (offer open to any others as well).