Hi guys! I want to make a spreadsheet to analyse my mons. I was wondering if is possible to enter CP, Stamina, IV and the level would be calculated automatically. Is there any way to do this?
Ps.: I know that when we calculate IV in Gamepress IV Calc it gives the Level. But I already got more than 400 mon IV calculated, and I have IV%, Atk, Def and HP in their name. That being said, I wouldn't like to recalculate them all. I'd like to copy data to a spreadsheet and get their level!
Thanks in advance!
I have not done this, but I have done pretty much all other calculations for Pokémon values and damage...basically what you need to do is get the power up costs table and the cp formula.
You then reposition the elements (I don't know the correct mathematical term in English) to have it calculate CPM, and you then make a list of CPM values and link them to the Level number and have that displayed to you.
Start with the CP formula and "Solve for X", where X is CPM.
https://pokemongo.gamepress.gg/pokemon-stats-advanced
CP = (Attack * Defense^0.5 * Stamina^0.5 * CPM^2) / 10
CPM = ( (CP * 10) / (Attack * Defense^0.5 * Stamina^0.5) )^0.5
Then lookup CPM and try to match the closest value to a level.
The value in all likelihood is not going to match exactly. For a spreadsheet, I don't know how that is going to affect the vlookup function. I think I've only ever used vlookup to find exact values in a table. Don't know if there is option for any fuzziness and finding the closest value.
Alternatively, you could just make a spreadsheet that calculates CP when you input pokemon, IVs, and level. Then you brute force until you find a level that matches.
