Thread:ATGreat/@comment-7743566-20140129092507/@comment-7743566-20140130060045

not sure the best free file site is, I have it here: http://www.filedropper.com/evolutionstatcalcv8xls  not sure how long the link is valid for.

As for the guide, basically the first tab is for the known stats, the 2nd to 4th tabs will calculate all the stats based on knowing all the stats for either the 4-7 evolution, 6-11 evolution or 8-15 evolution, (could do more but those are the most common builds so didn't bother with creating pages to calculate from other given stats).

For the stats on the base tab, you don't have to zero out the stats for the other evolutions if you don't want to, just make sure you look at the correct corresponding tab for the accurate calcuted data, the other 2 tabs will have erronious data since the stats could be way out of lineof the true stats.

Now it is still possible for the excel formula to calculate the MAXED stats of each evolution without the base stats or even carryover stats for 2nd to 4th evolution, it'll simply give garbage data for those columns, also the 4-1 value will be incorrect, I usually zero the data entries that are missing so i know from the calculated absurd (or negative value) that that stat is not known.

The best way to learn it (if you wish) is to use a page where the data is already filled and enter the full data for one of the 3 stats build routes.

the formula is configured so you can calculate mirror dragon stats as well depending on if it is rare sr or mr (you must change the parameter on the base tab)

anyways I'll let you go and fill out all those uncommon card pages where i already posted the required stats for the 4-7 route in the comments, assuming no base stats are missing you should be able to do a dozen card pages or so.

also there  is probably something wrong if the PURE MAX base stats for evolution 2-4 doesn't end with a 0 in the 1's position (with a few exceptions like insidious loki)