READ ME FIRST
DO NOT make any 'click my eggs/Pokémon' threads/posts or any 'what is this egg' threads/posts or you WILL be warned 10% instantly!
GPX shiny ratio spreadsheet |
Jun 19 2011, 08:17 PM
Post
#1
|
|
Pokémon Trainer Group: Newbies Posts: 0 Joined: 1-June 11 From: Somewhere in, New Jersey Member No.: 142 265 Active Squad |
So I made this spreadsheet to find the average amount of eggs you need to hatch to find a shiny (well actually some other people added stuff to it). Click the link in my signature to put in your stats!
-------------------- |
|
Jun 20 2011, 05:55 AM
Post
#2
|
|
βακα…_〆(゜▽゜*) Group: +Donors Posts: 15 Joined: 16-January 10 From: Finland Member No.: 80 122 Active Squad |
That's a great idea.
I added a formula in there, hope you don't mind. It now calculates the User Average automatically, no need to fill that in. Just have to enter the number of eggs and shinies hatched. =ArrayFormula(IF(B2:B999>0,B2:B999/C2:C999,"")) That adds the formula for each new row. Added the IF there so that it won't show the division by zero errors. This post has been edited by Zaltys: Jun 20 2011, 06:01 AM -------------------- |
|
Jun 20 2011, 06:11 AM
Post
#3
|
|
Pokémon Trainer Group: Newbies Posts: 0 Joined: 1-June 11 From: Somewhere in, New Jersey Member No.: 142 265 Active Squad |
That's a great idea. I added a formula in there, hope you don't mind. It now calculates the User Average automatically, no need to fill that in. Just have to enter the number of eggs and shinies hatched. =ArrayFormula(IF(B2:B999>0,B2:B999/C2:C999,"")) That adds the formula for each new row. Added the IF there so that it won't show the division by zero errors. Wait, I already put the average code in there...Maybe someone changed it....Wait, but couldn't you just use the =AVERAGE(B:B) thing? Oh wait, I see what you did, instead of averaging each individual divided one, you just took all the numbers that weren't individually divided yet and divided all of them added together. Or something like that, I guess, I don't know a lot about google spreadsheets and formulas. -------------------- |
|
Jun 20 2011, 06:24 AM
Post
#4
|
|
βακα…_〆(゜▽゜*) Group: +Donors Posts: 15 Joined: 16-January 10 From: Finland Member No.: 80 122 Active Squad |
No, I added the formula to the column D (User Average) and H (Shiny Breeding Ratio). Those columns are now calculated automatically, so users won't have to calculate those themselves.
As for column E (Overall Average)... I think that used to be =AVERAGE(D), but the new formula seems more accurate. -------------------- |
|
Jun 20 2011, 06:38 AM
Post
#5
|
|
where doing it man where MAKING THIS HAPEN Group: Members Posts: 769 Joined: 9-September 09 From: Carpacian Colony Member No.: 62 388 Portal |
this is pretty cool
current average is 1/257.970085470085... can we just say 1/258? -------------------- stuff (click to show ) "This guy has the best advice ever: don't be a homicidal maniac, and remember to eat." --Marik Ishtar I am not Roxy Lalonde, I'm Roxy Lalonde (with 2 spaces) |
|
Jun 20 2011, 07:13 AM
Post
#6
|
|
Veteran Group: +Donors Posts: 1 613 Joined: 29-July 08 From: Winnipeg, Manitoba Member No.: 2 482 Active Squad |
Added mine. Just updated it like...right now.
This post has been edited by Dazmi: Jun 20 2011, 07:13 AM -------------------- |
|
Jun 20 2011, 08:45 AM
Post
#7
|
|
My little shadow familiar can't be this cute Group: +Donors Posts: 541 Joined: 2-April 09 From: mobage hell (Spain) Member No.: 7 553 Favs <3 |
Just added my stats
-------------------- |
|
Jun 20 2011, 08:53 AM
Post
#8
|
|
boom shakalakalaka Group: +Donors Posts: 298 Joined: 27-March 09 Member No.: 5 708 Active Squad |
added my stats. ;;
-------------------- |
|
Jun 20 2011, 09:10 AM
Post
#9
|
|
Account Upgraded | Title Enabled Group: +Donors Posts: 561 Joined: 19-September 10 Member No.: 114 649 Active Squad |
added my stats to
This is a really neat idea ;D hehe, just found out I have to only hatch another 163 eggs I get a shiny xP yay. -------------------- |
|
Jun 20 2011, 09:32 AM
Post
#10
|
|
Pokémon Trainer Group: Members Posts: 27 Joined: 25-August 10 Member No.: 111 547 Active Squad |
About the shinies bred thing, not every shiny bred is adopted. When they added the new thing to the daycare page where it shows the amount of shinies bred I saw my relicanth had several shinies that weren't adopted. Also, added my stats.
This post has been edited by Superbob: Jun 20 2011, 09:33 AM |
|
Jun 20 2011, 09:51 AM
Post
#11
|
|
Pokémon Trainer Group: Members Posts: 29 Joined: 17-July 09 From: United States Member No.: 47 486 Active Squad |
Added my stats. Jeeze my bred shiny ratio is more than 700
-------------------- |
|
Jun 20 2011, 10:16 AM
Post
#12
|
|
That one laughing Giraffe Group: +Donors Posts: 556 Joined: 4-October 09 From: London, ON Member No.: 66 646 Active Squad |
Added my stats c:
-------------------- [align=center]The help page has loads of useful information!
[/align] |
|
Jun 20 2011, 10:24 AM
Post
#13
|
|
Ashlie's Minnions Group: Members Posts: 999 Joined: 10-August 09 From: Squirretopia Member No.: 55 679 the best ever |
Added stats.. not a good shiny ratio I have
-------------------- |
|
Jun 20 2011, 10:25 AM
Post
#14
|
|
Fan of Smash Bros, Pokémon, A:TLA, A:LOK, Zelda, things Group: Members Posts: 194 Joined: 7-June 09 From: South Clock Town Member No.: 31 681 Favorites ♥ |
Added stats
Wow, 2nd worst shiny luck XD This post has been edited by Razz Haru: Jun 20 2011, 10:26 AM -------------------- |
|
Jun 20 2011, 10:26 AM
Post
#15
|
|
Poliwag Awesome Dude Group: +Donors Posts: 138 Joined: 29-April 09 From: Ruling the world with Poliwag~ Member No.: 17 353 Poliwag! |
Added mine. It's so wonderful. I've just hatched too many eggs. XD
-------------------- Looking for a small, close, friendly community where you can hang out, talk about Pokémon and anything, and have fun? Check out Poliwager Forums! |
|
Jun 20 2011, 10:33 AM
Post
#16
|
|
Spriter / Writer Group: Administrators Posts: 2 186 Joined: 6-June 10 From: The Netherlands Member No.: 99 214 Active Squad |
Nice idea. ^^
I added my stats. Seems like my 'shiny breed'-ratio is the worst ever. x3 It'll be fun to keep an eye on this! -------------------- |
|
Jun 20 2011, 11:47 AM
Post
#17
|
|
The Nerd with a Minccino Obsession(The Dragon) Group: Members Posts: 521 Joined: 30-July 09 From: A dragon egg. Member No.: 52 224 Silence. |
I'm not really sure when you say Eggs Hatched. Total, or for a hunt?
Somewhat confusing for me. -------------------- |
|
Jun 20 2011, 11:51 AM
Post
#18
|
|
Elite Four Group: +Donors Posts: 994 Joined: 9-June 09 Member No.: 32 330 Active Squad |
Added mine a moment ago. It's interesting to see but in the end shinies rely completely on luck.
-------------------- |
|
Jun 20 2011, 11:55 AM
Post
#19
|
|
There’s a lot of tension in this town Group: +Donors Posts: 2 004 Joined: 30-April 09 From: Louisiana Member No.: 17 626 Active Squad |
I'm not really sure when you say Eggs Hatched. Total, or for a hunt? Somewhat confusing for me. I believe it's total. I added mine not long after this topic was posted! XD -------------------- |
|
Jun 20 2011, 12:15 PM
Post
#20
|
|
Pokémon Trainer Group: Members Posts: 38 Joined: 1-September 10 Member No.: 112 377 Active Squad |
Sounds cool, adding.
-------------------- |
|
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
Lo-Fi Version | Time is now: 24th September 2024 - 10:32 PM |