https://docs.google.com/spreadsheets/d/1SMf8B3eIb9zJjE_O1GaVq_T2eHs0j6HQapu_Zz8zhHE/edit?usp=sharing

Someone asked for this during a run this still has to be checked and highlighted for what would be usable in the run and I can add full editors I just wanted to get this out there for discussion. I don't know much about pokemon stats this is just based on some existing formulas so if there are corrections to make please let me know.

Your IVs aren't the same in all stats, so just based on CPs you can't reliably tell whether the Staryu is good. All you can tell is that the higher the number, the likelier it is the Staryu is good.

Also note the Staryu you get is always level 43 thanks to Lures. If I didn't do a mistake, the CPs go from 952 to 1158.

Edit: Note that I may be completely misunderstanding what you mean.

Right yes I should of been more clear that the iv would be the average iv number as the ivs seem to effect the cp value the same.

Edit: I've added some Starmie stats to the custom tab as well which should be publically editable.

I'm not sure I get that right. How do you get your values, cause that's not what I have at all for Staryu at level 43.

Based on the formula on Serebii: https://www.serebii.net/letsgopikachueevee/cp.shtml

Staryu with all IVs at 31 has the following stats:
HP: 92
ATK: 57
DEF: 65
SPATK: 78
SPDEF: 65
SPD: 91

With the formula I get: (92 + 57 + 65 + 78 + 65 + 91) 43 6 / 100 = 448 43 6 / 100 = 1155
Or is there something I don't understand? Do wild Pokémon have AVs? I realize I made a mistake in my CPs earlier cause I probably had miscalculated it.

Nope I was using the wrong stats formula for calculating the stats. Updating it now. The cp formula was matching correctly but the individual stats were getting calculated to high.

Edit: The point from here would be some stats points that would be desirable and do an odds breakdown on those cp numbers if that desirable stat coming up.