The Office Pokémon GO IV Calculator
CC Attribution 2.0 Belgium:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Yang, Shih-Ching (imacat)
As a hardcore OpenOffice and game player/hacker, I always keep detailed gamerecords with Calc spreadsheets, including characters, stats, resources, eventplans, etc., so that I can get the best of it. When it comes to Pokémon GO, Ikeep the Pokémon individual values (IV), maximum combat powers (CP), and otherinformation that calculated from 3rd-party websites on my spreadsheets, inorder to plan which Pokémon to spent precious resources to power up. Thespreadsheet document eventually becomes an application that works completelyoff-line. You can always do everything with OpenOffice, for fun!
 Okay. Okay. So welcome to the open document editor's bedroom. We can start with the first presentation by Imaqat. It's going to be a funny one. So we start on the right note. Okay, thank you. I'm glad to know that there's someone welcoming you, so I don't have to welcome you myself. Okay, and before we begin, anyone still playing Pokemon Go now? Oh, that's cool. Okay, I'll show you a story. Hopefully I can make it sure. And one of my friends, she went to interview for a new job, and the interviewer asked her a question, saying, this position requires a persistent character. Can you show your persistency? And then she turned off her cell phone and said, look, I'm still playing Pokemon Go. Yes, I'm persistent, and you are persistent too. And, okay, some introduction of... Let me introduce myself. I'm from Taiwan and open source office, liberal office community. And I'm a member of the Apache Open-House PMC. Also, I'm a member of the Women's Women's Infos in Taiwan. And besides that, well, I'm a game player for almost three decades. Yeah, that reveals my age. I'm from Amistos to Windows 95, 90, and now I'm playing Linux Steam. And PC game, I play PC game at MAD, M-U-D. Have anyone heard of MAD? MAD? Yeah, wow, that's cool. Okay. Did I know you? Okay, cool. We are mobile games, and my favorite game genre is always RPG, role-playing games. And, well, okay. All in all, it started as a spreadsheet. You know, a spreadsheet is actually a very convenient space to store the information because you don't have to worry about the metadata, the data size, data type, or the precision, anything. So I use a spreadsheet to store all kinds of data information. For example, the journal account, including the account of my this travel. And also the student scores. I use those to record student scores or the attendees list. And this is also true when it comes to games. Since I play a game a lot, I also create a lot of spreadsheet to store game data. For example, the Ultima 7. Anyone heard of this? Anyone heard of this? Wow, that's cool. Okay. It also reviews my age again. And part of the 7th tile, the lost items of the main character, I use it to recall what item is lost and what is replaced, and the crew, how to find it. And to come to a closer age, plants, this is versus zombies. I use it to recall the plants, the calls, and their genre. And also this is a Chinese game, Sanctuary Battle. I used to recall all the heroes I got. And this tree is amazing. It's just amazing. Now it goes for Pokemon Go. In Pokemon Go, every Pokemon has its combat power. I believe many of you have already know. And we often compare Pokemon by their combat power. For example, you see the Charmander is 500, and the Squirtle is 400. It's apparently stronger. And some species are just stronger than the others. For example, the Krabiaba is just stronger than the male Nidoran below. And even within the same species, their CP may still be different. So they are still different from one another. So Pokemon of the same species share the same set of best stats. For example, you can see that for Pikachu, its best attack is 112, and the defense is 101, and stamina is 70. And the slow ball below is much stronger. Its attack is 177, defense 194, and stamina is 190. In addition to these best stats, they are still also individual values. And individual values are added to the best stats. There are three values range from 0 to 15. And also there's Levo. Pokemon has their Levo, and this Levo is indicated by R, the R below the CP. So you can see that. And these two ball peaks, the one above is of level 20, and the one below is of level 25. And the R is longer. So Levo can be advanced by power up, and each power up advanced the level by half. So in order to get the strongest Pokemon, we first choose the strong species that with high best stats. And for Pokemon of that species, we pick the Pokemon with the highest individual values. And then we power up to a maximum to advance its level. So now the question is how do we get lower individual values? Actually individual values are hidden. The Pokemon come in one level to know. If you pick into the individual values, you'll be banned from the game. But we are hackers, you know. We can still calculate it from hints and clues. Actually there are several websites that calculate Pokemon individuals for you. For example, for this GGBARF, you can see that its CP is 472. And it's, well, it's not quite clear. Its HP is 162. And to power it, take 4,000 star dust and three candies. So let's see. If we got GGBARF and 472, 162, and 4,000. And yes, we haven't powered it up yet. And then calculate. We got 8 possible combinations. Okay. Then we thoroughly mean the result. We thoroughly mean the result. By the team leader's appraisal. For me, I'm in a red team. The team leader's, yes? Yeah, red team. Yeah. Okay, team leader. The team leader says overall Magikarp has a strong Pokemon. You should be proud. And then it says its HP is stronger than, strongest feature. And I'm just impressed with your attack. And it's got excellent stats. How exciting. So let's go back to here. Team leader appraisal first choose the team leader and strong Pokemon. My HP is stronger feature. And it got impressed as its attack. And it got excellent stats. How exciting. Well, it limits to one value. It's 25, 14, 8, 14. Okay. With this online calculator, actually I created, actually I actually created, sorry. With this online calculator, I actually created a more advanced spreadsheet to score. Oh, sorry. I actually created a spreadsheet to score all my strongest Pokemon. Yeah. That's crazy thing I did. I always did something like this. Yeah. And you know, I always do things that's useless. I like to hack useless things. Okay. Now back to my slides. And also it also tell you how strong it's possible. It could possibly be, for example, the Jigglystall buff we see, we saw it require one, it can go to 1,800 CP and require 174,000 star dots and 190 candies to power up. So then I have a next question. My Leopold has a following IV, it's level, it's 20, 13, 12, 11. And to go to Pokemon level 39, it takes 200,000 star dots and 220,000 into CP, 2080, 800. But I only got 29 candies. So should I power it up? And Lyper is so hard to catch, so should I power it up and how strong it would be? And to get the answer, I have to be able to calculate the CP myself. And actually for popular game like this, someone already has already hacked it. So I just do the Google and found this CP formula. Yes. And you can see that attack is base attack plus the IV attack and times the CP. And defense is base defense plus IV defense times CP and stamina. And also CP is attack times square root of defense and square root of stamina and divided by 10. OK. First, the first part of the base stats, it can also be found on internet, someone already found it. So also I copied it and put, I copied this table. Secondly, the CP and CP multiplier. CP and 1.5 is actually a list of constants increased with levels. They can be found on internet too. And for high levels, they are calculated at real time using this formula. So for example, my battery base is 167, 151 and 120. That is 14, 159. So I apply this formula, I get a CP of 100 and 1039. And that's exactly what I got. OK. Return to my lab plus problem. The amount of stats and candy to power up can also be found on internet too. So from level 20, I found that I can only got to level 25. And to level 25, apply the film, I found the CP and of level 25. I found that I can get a CP, password CP to 2077. OK. That's where I'm done now. OK. It seems worth it. It's quite strong. So using this formula, I create a more advanced spreadsheet and to tell all the possibilities of my pokemons and how it could be. OK. Then with the ability to calculate the CP, actually, the calculator is just one step away. You know, it's only simply brute force. The pseudocall is quite simple. I look through each possible level and each stamina, each attack, and each defense. And if the calculator CP is a CP I got, and then boom, I got an answer. And the result is 79 times 15 times 15 times 15 to 260,000 times. That's a huge number and you won't stop. But we have ways to refine it. See, if we know the start-up table, if we know the start-up table, actually we can limit the number of possible levels from only four levels. And for newly coped up pokemons, the level will always be the whole number. So it will limit to two levels. And HP is actually the stamina as a whole number. So apply this formula. I can only also limit the IV stamina to one or two values. So the number of runs is reduced to 900 times and it's the last model. Now, third refinement with team leader, Appraisal. For a better team, the first appraisal is total stats. If it amazes me, it gets up more than 36. If it is a strong pokemon, it goes 30 to 36. And if it is a decent pokemon, it goes 23 to 29. But if it's not great in battle, it is less than 23. The second appraisal is its best stats. And HP is its strongest future and as God is impressed as its attack, whatever is listed, they are equally its best stats. And the third appraisal is maximum stats value. If I'm brought away by its stats, it's 15. The maximum is 15. I got a set of stats, it's maximum 13 or 14. If they indicate in battle, it could get the job done, it's between 8 and 12. It won't point to greatness in battle, it's less than 7, than 8. So with this, let's see. The GGBARF we just got here and with the CP of 7472. And HP of 162 and Stardust 4000. And for me, my current level is 30. And it's team-vader, so I got strong pokemon, it's AP, strong future, impressed with its attack and excellent health stats, health setting. Okay, then I got the result. Okay, this is done. Oh, but I see I still have 5 minutes. So let's show a short story. Sorry. One morning in November, when I woke up, I found my... Gwaiirotus gets much stronger than I expected. Then I remember, it's weird. Actually, not only Gwaiirotus, everyone changes power. So I went to the Pokemon fan page and found this. We have made adjustment to a CP and that's terrible. And it's lucky that I haven't published this calculator yet. And I quickly searched the internet and found someone has already found the table. And I immediately applied it. And that's the first story. Second story, the other day when I woke up, when I'm working, I had something I've never seen. So I went to the Pokemon fan page again. Oh, new Pokemon added. Popa, Tokaipi and Pichu hatching from eggs. That's terrifying because this time I already published it. So I spent all my coins to hatch these Pokemon and to get their data. And for those I haven't had, I even asked all my friends if they had already hatched it in order to get their data. Yeah. So the lessons I learned from here. If you are creating some game hiking tool and you don't have commercial support, you have better not publishing. Because it's really a nightmare if the game changes. If the game changes, you have to update it immediately. The second lesson I learned. For strong species like Dragonite, base states take the largest part of the CP. You see, the Terthite is 263 plus 15. Defense 201 plus 15 and Stemline 182 dot 15 dot 11. Actually, Dragonite is just stronger, whatever its IV is. And the second Informa factor is always its level. And for IV, we are calculating, it doesn't really matter. Okay. Thank you very much. Any questions? Yes. Oh, yes, I forgot it. Just, actually you can get from here. I put it on GitHub. That's another topic I'll talk about this afternoon. I put it on GitHub. And also, currently I only put it, I still not put it on, sorry. Yeah, I still not put it on the LibreOffice extension yet. But I check and just it runs smoothly on LibreOffice too. Yeah. Maybe I'll just upload it later. Yes. Any questions? No questions? I hope you enjoy this. Thank you. Your next. I'm just checking. Everybody's got everything. Don't leave. We still have sessions. I'm just checking the sound. Okay.
 Okay.  Okay.  So welcome to the open document editor's bedroom.  We can start with the first presentation by Imaqat.  It's going to be a funny one.  So we start on the right note.  Okay, thank you.  I'm glad to know that there's someone welcoming you,  so I don't have to welcome you myself.  Okay, and before we begin, anyone still playing Pokemon Go now?  Oh, that's cool.  Okay, I'll show you a story.  Hopefully I can make it sure.  And one of my friends, she went to interview for a new job,  and the interviewer asked her a question, saying,  this position requires a persistent character.  Can you show your persistency?  And then she turned off her cell phone and said,  look, I'm still playing Pokemon Go.  Yes, I'm persistent, and you are persistent too.  And, okay, some introduction of...  Let me introduce myself.  I'm from Taiwan and open source office, liberal office community.  And I'm a member of the Apache Open-House PMC.  Also, I'm a member of the Women's Women's Infos in Taiwan.  And besides that, well, I'm a game player for almost three decades.  Yeah, that reveals my age.  I'm from Amistos to Windows 95, 90, and now I'm playing Linux Steam.  And PC game, I play PC game at MAD, M-U-D.  Have anyone heard of MAD?  MAD? Yeah, wow, that's cool.  Okay. Did I know you?  Okay, cool.  We are mobile games, and my favorite game genre is  always RPG, role-playing games.  And, well, okay.  All in all, it started as a spreadsheet.  You know, a spreadsheet is actually a very convenient space  to store the information because you don't have to worry about  the metadata, the data size, data type, or the precision, anything.  So I use a spreadsheet to store all kinds of data information.  For example, the journal account, including the account of my this travel.  And also the student scores.  I use those to record student scores or the attendees list.  And this is also true when it comes to games.  Since I play a game a lot, I also create a lot of spreadsheet to store game data.  For example, the Ultima 7.  Anyone heard of this?  Anyone heard of this?  Wow, that's cool.  Okay. It also reviews my age again.  And part of the 7th tile, the lost items of the main character,  I use it to recall what item is lost and what is replaced,  and the crew, how to find it.  And to come to a closer age, plants, this is versus zombies.  I use it to recall the plants, the calls, and their genre.  And also this is a Chinese game, Sanctuary Battle.  I used to recall all the heroes I got.  And this tree is amazing.  It's just amazing.  Now it goes for Pokemon Go.  In Pokemon Go, every Pokemon has its combat power.  I believe many of you have already know.  And we often compare Pokemon by their combat power.  For example, you see the Charmander is 500,  and the Squirtle is 400.  It's apparently stronger.  And some species are just stronger than the others.  For example, the Krabiaba is just stronger than the male Nidoran below.  And even within the same species, their CP may still be different.  So they are still different from one another.  So Pokemon of the same species share the same set of best stats.  For example, you can see that for Pikachu, its best attack is 112,  and the defense is 101, and stamina is 70.  And the slow ball below is much stronger.  Its attack is 177, defense 194, and stamina is 190.  In addition to these best stats, they are still also individual values.  And individual values are added to the best stats.  There are three values range from 0 to 15.  And also there's Levo.  Pokemon has their Levo, and this Levo is indicated by R, the R below the CP.  So you can see that.  And these two ball peaks, the one above is of level 20,  and the one below is of level 25.  And the R is longer.  So Levo can be advanced by power up, and each power up advanced the level by half.  So in order to get the strongest Pokemon, we first choose the strong species  that with high best stats.  And for Pokemon of that species, we pick the Pokemon with the highest individual values.  And then we power up to a maximum to advance its level.  So now the question is how do we get lower individual values?  Actually individual values are hidden.  The Pokemon come in one level to know.  If you pick into the individual values, you'll be banned from the game.  But we are hackers, you know.  We can still calculate it from hints and clues.  Actually there are several websites that calculate Pokemon individuals for you.  For example, for this GGBARF, you can see that its CP is 472.  And it's, well, it's not quite clear.  Its HP is 162.  And to power it, take 4,000 star dust and three candies.  So let's see.  If we got GGBARF and 472, 162, and 4,000.  And yes, we haven't powered it up yet.  And then calculate.  We got 8 possible combinations.  Okay.  Then we thoroughly mean the result.  We thoroughly mean the result.  By the team leader's appraisal.  For me, I'm in a red team.  The team leader's, yes?  Yeah, red team.  Yeah.  Okay, team leader.  The team leader says overall Magikarp has a strong Pokemon.  You should be proud.  And then it says its HP is stronger than, strongest feature.  And I'm just impressed with your attack.  And it's got excellent stats.  How exciting.  So let's go back to here.  Team leader appraisal first choose the team leader and strong Pokemon.  My HP is stronger feature.  And it got impressed as its attack.  And it got excellent stats.  How exciting.  Well, it limits to one value.  It's 25, 14, 8, 14.  Okay.  With this online calculator, actually I created, actually I actually created, sorry.  With this online calculator, I actually created a more advanced spreadsheet to score.  Oh, sorry.  I actually created a spreadsheet to score all my strongest Pokemon.  Yeah.  That's crazy thing I did.  I always did something like this.  Yeah.  And you know, I always do things that's useless.  I like to hack useless things.  Okay.  Now back to my slides.  And also it also tell you how strong it's possible.  It could possibly be, for example, the Jigglystall buff we see, we saw it require one, it can  go to 1,800 CP and require 174,000 star dots and 190 candies to power up.  So then I have a next question.  My Leopold has a following IV, it's level, it's 20, 13, 12, 11.  And to go to Pokemon level 39, it takes 200,000 star dots and 220,000 into CP, 2080, 800.  But I only got 29 candies.  So should I power it up?  And Lyper is so hard to catch, so should I power it up and how strong it would be?  And to get the answer, I have to be able to calculate the CP myself.  And actually for popular game like this, someone already has already hacked it.  So I just do the Google and found this CP formula.  Yes.  And you can see that attack is base attack plus the IV attack and times the CP.  And defense is base defense plus IV defense times CP and stamina.  And also CP is attack times square root of defense and square root of stamina and divided by 10.  OK.  First, the first part of the base stats, it can also be found on internet, someone already found it.  So also I copied it and put, I copied this table.  Secondly, the CP and CP multiplier.  CP and 1.5 is actually a list of constants increased with levels.  They can be found on internet too.  And for high levels, they are calculated at real time using this formula.  So for example, my battery base is 167, 151 and 120.  That is 14, 159. So I apply this formula, I get a CP of 100 and 1039.  And that's exactly what I got.  OK.  Return to my lab plus problem.  The amount of stats and candy to power up can also be found on internet too.  So from level 20, I found that I can only got to level 25.  And to level 25, apply the film, I found the CP and of level 25.  I found that I can get a CP, password CP to 2077.  OK. That's where I'm done now.  OK. It seems worth it.  It's quite strong.  So using this formula, I create a more advanced spreadsheet  and to tell all the possibilities of my pokemons and how it could be.  OK.  Then with the ability to calculate the CP, actually, the calculator is just one step away.  You know, it's only simply brute force.  The pseudocall is quite simple. I look through each possible level and each stamina,  each attack, and each defense.  And if the calculator CP is a CP I got, and then boom, I got an answer.  And the result is 79 times 15 times 15 times 15 to 260,000 times.  That's a huge number and you won't stop.  But we have ways to refine it.  See, if we know the start-up table, if we know the start-up table,  actually we can limit the number of possible levels from only four levels.  And for newly coped up pokemons, the level will always be the whole number.  So it will limit to two levels.  And HP is actually the stamina as a whole number.  So apply this formula.  I can only also limit the IV stamina to one or two values.  So the number of runs is reduced to 900 times and it's the last model.  Now, third refinement with team leader, Appraisal.  For a better team, the first appraisal is total stats.  If it amazes me, it gets up more than 36.  If it is a strong pokemon, it goes 30 to 36.  And if it is a decent pokemon, it goes 23 to 29.  But if it's not great in battle, it is less than 23.  The second appraisal is its best stats.  And HP is its strongest future and as God is impressed as its attack,  whatever is listed, they are equally its best stats.  And the third appraisal is maximum stats value.  If I'm brought away by its stats, it's 15.  The maximum is 15. I got a set of stats, it's maximum 13 or 14.  If they indicate in battle, it could get the job done, it's between 8 and 12.  It won't point to greatness in battle, it's less than 7, than 8.  So with this, let's see.  The GGBARF we just got here and with the CP of 7472.  And HP of 162 and Stardust 4000.  And for me, my current level is 30.  And it's team-vader, so I got strong pokemon, it's AP, strong future,  impressed with its attack and excellent health stats, health setting.  Okay, then I got the result.  Okay, this is done.  Oh, but I see I still have 5 minutes.  So let's show a short story.  Sorry.  One morning in November, when I woke up, I found my...  Gwaiirotus gets much stronger than I expected.  Then I remember, it's weird.  Actually, not only Gwaiirotus, everyone changes power.  So I went to the Pokemon fan page and found this.  We have made adjustment to a CP and that's terrible.  And it's lucky that I haven't published this calculator yet.  And I quickly searched the internet and found someone has already found the table.  And I immediately applied it.  And that's the first story.  Second story, the other day when I woke up, when I'm working, I had something I've never seen.  So I went to the Pokemon fan page again.  Oh, new Pokemon added.  Popa, Tokaipi and Pichu hatching from eggs.  That's terrifying because this time I already published it.  So I spent all my coins to hatch these Pokemon and to get their data.  And for those I haven't had, I even asked all my friends if they had already hatched it in order to get their data.  Yeah.  So the lessons I learned from here.  If you are creating some game hiking tool and you don't have commercial support,  you have better not publishing.  Because it's really a nightmare if the game changes.  If the game changes, you have to update it immediately.  The second lesson I learned.  For strong species like Dragonite, base states take the largest part of the CP.  You see, the Terthite is 263 plus 15.  Defense 201 plus 15 and Stemline 182 dot 15 dot 11.  Actually, Dragonite is just stronger, whatever its IV is.  And the second Informa factor is always its level.  And for IV, we are calculating, it doesn't really matter.  Okay.  Thank you very much. Any questions?  Yes.  Oh, yes, I forgot it.  Just, actually you can get from here.  I put it on GitHub.  That's another topic I'll talk about this afternoon.  I put it on GitHub.  And also, currently I only put it, I still not put it on, sorry.  Yeah, I still not put it on the LibreOffice extension yet.  But I check and just it runs smoothly on LibreOffice too.  Yeah.  Maybe I'll just upload it later.  Yes.  Any questions?  No questions?  I hope you enjoy this.  Thank you.  Your next.  I'm just checking. Everybody's got everything.  Don't leave.  We still have sessions.  I'm just checking the sound.  Okay.
The_Office_Pokemon_GO_IV_Calculator_Games_Fun_and_Hacks_with_OpenOffice_LibreOffice_0_347.png The_Office_Pokemon_GO_IV_Calculator_Games_Fun_and_Hacks_with_OpenOffice_LibreOffice_348_431.png The_Office_Pokemon_GO_IV_Calculator_Games_Fun_and_Hacks_with_OpenOffice_LibreOffice_432_5951.png The_Office_Pokemon_GO_IV_Calculator_Games_Fun_and_Hacks_with_OpenOffice_LibreOffice_5952_6131.png The_Office_Pokemon_GO_IV_Calculator_Games_Fun_and_Hacks_with_OpenOffice_LibreOffice_6132_6683.png The_Office_Pokemon_GO_IV_Calculator_Games_Fun_and_Hacks_with_OpenOffice_LibreOffice_6684_10079.png The_Office_Pokemon_GO_IV_Calculator_Games_Fun_and_Hacks_with_OpenOffice_LibreOffice_10080_11003.png The_Office_Pokemon_GO_IV_Calculator_Games_Fun_and_Hacks_with_OpenOffice_LibreOffice_11004_11483.png The_Office_Pokemon_GO_IV_Calculator_Games_Fun_and_Hacks_with_OpenOffice_LibreOffice_11484_11543.png The_Office_Pokemon_GO_IV_Calculator_Games_Fun_and_Hacks_with_OpenOffice_LibreOffice_11544_11699.png The_Office_Pokemon_GO_IV_Calculator_Games_Fun_and_Hacks_with_OpenOffice_LibreOffice_11700_11819.png The_Office_Pokemon_GO_IV_Calculator_Games_Fun_and_Hacks_with_OpenOffice_LibreOffice_11820_14819.png The_Office_Pokemon_GO_IV_Calculator_Games_Fun_and_Hacks_with_OpenOffice_LibreOffice_14820_20951.png The_Office_Pokemon_GO_IV_Calculator_Games_Fun_and_Hacks_with_OpenOffice_LibreOffice_20952_22991.png The_Office_Pokemon_GO_IV_Calculator_Games_Fun_and_Hacks_with_OpenOffice_LibreOffice_22992_23555.png The_Office_Pokemon_GO_IV_Calculator_Games_Fun_and_Hacks_with_OpenOffice_LibreOffice_23556_28655.png The_Office_Pokemon_GO_IV_Calculator_Games_Fun_and_Hacks_with_OpenOffice_LibreOffice_28656_29339.png The_Office_Pokemon_GO_IV_Calculator_Games_Fun_and_Hacks_with_OpenOffice_LibreOffice_29340_29447.png The_Office_Pokemon_GO_IV_Calculator_Games_Fun_and_Hacks_with_OpenOffice_LibreOffice_29448_30119.png The_Office_Pokemon_GO_IV_Calculator_Games_Fun_and_Hacks_with_OpenOffice_LibreOffice_30120_30232.png