Welcome Guest ( Log In · Register · Change Skins )
Global PokedeX Plus
Lab · Shelter · Main · Dex · PC · Shop · Stats · Help · Rules · Users Online · IRC Chat
GPX+ GPXPlus Forums Member Options
X   Site Message
(Message will auto close in 2 seconds)

 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!

5 Pages V   1 2 3 > »   
Reply to this topicStart new topic
GPX shiny ratio spreadsheet
fatcom4
post Jun 19 2011, 08:17 PM
Post #1


Pokémon Trainer
Group Icon

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!


--------------------
Go to the top of the page
+Quote Post

Zaltys
post Jun 20 2011, 05:55 AM
Post #2


βακα…_〆(゜▽゜*)
Group Icon

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


--------------------
Go to the top of the page
+Quote Post

fatcom4
post Jun 20 2011, 06:11 AM
Post #3


Pokémon Trainer
Group Icon

Group: Newbies
Posts: 0
Joined: 1-June 11
From: Somewhere in, New Jersey
Member No.: 142 265

Active Squad



QUOTE(Zaltys @ Jun 20 2011, 06:55 AM) *
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.


--------------------
Go to the top of the page
+Quote Post

Zaltys
post Jun 20 2011, 06:24 AM
Post #4


βακα…_〆(゜▽゜*)
Group Icon

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(noes.gifD), but the new formula seems more accurate.


--------------------
Go to the top of the page
+Quote Post

Radoka Kaname
post Jun 20 2011, 06:38 AM
Post #5


where doing it man where MAKING THIS HAPEN
Group Icon

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)
Go to the top of the page
+Quote Post

Dazmi
post Jun 20 2011, 07:13 AM
Post #6


Veteran
Group Icon

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


--------------------
Go to the top of the page
+Quote Post

Akane Kurashiki
post Jun 20 2011, 08:45 AM
Post #7


My little shadow familiar can't be this cute
Group Icon

Group: +Donors
Posts: 541
Joined: 2-April 09
From: mobage hell (Spain)
Member No.: 7 553

Favs <3



Just added my stats cat.gif


--------------------
I get so many things I don't deserve

Go to the top of the page
+Quote Post

intu
post Jun 20 2011, 08:53 AM
Post #8


boom shakalakalaka
Group Icon

Group: +Donors
Posts: 298
Joined: 27-March 09
Member No.: 5 708

Active Squad



added my stats. ;;


--------------------
** (click to show)



{ }

*~*~intu needs avatars~*~*
Go to the top of the page
+Quote Post

Esc
post Jun 20 2011, 09:10 AM
Post #9


Account Upgraded | Title Enabled
Group Icon

Group: +Donors
Posts: 561
Joined: 19-September 10
Member No.: 114 649

Active Squad



added my stats to oh.gif

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. magic.gif


--------------------



Thnx Moonlit

Proud Member of the KotRt & Shiny Lovers Redux! & Blue Moons!

Go to the top of the page
+Quote Post

Superbob
post Jun 20 2011, 09:32 AM
Post #10


Pokémon Trainer
Group Icon

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
Go to the top of the page
+Quote Post

Seraphic
post Jun 20 2011, 09:51 AM
Post #11


Pokémon Trainer
Group Icon

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 pinch.gif


--------------------




Credit (click to show)
Go to the top of the page
+Quote Post

Giraffe A Laugh
post Jun 20 2011, 10:16 AM
Post #12


That one laughing Giraffe
Group Icon

Group: +Donors
Posts: 556
Joined: 4-October 09
From: London, ON
Member No.: 66 646

Active Squad



Added my stats c:


--------------------
Go to the top of the page
+Quote Post

Ninja Squirrel T...
post Jun 20 2011, 10:24 AM
Post #13


Ashlie's Minnions
Group Icon

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


--------------------
Go to the top of the page
+Quote Post

unexistence
post Jun 20 2011, 10:25 AM
Post #14


Fan of Smash Bros, Pokémon, A:TLA, A:LOK, Zelda, things
Group Icon

Group: Members
Posts: 194
Joined: 7-June 09
From: South Clock Town
Member No.: 31 681

Favorites ♥



Added stats cat.gif
Wow, 2nd worst shiny luck XD

This post has been edited by Razz Haru: Jun 20 2011, 10:26 AM


--------------------

GPXing sporadically.


Go to the top of the page
+Quote Post

Slix
post Jun 20 2011, 10:26 AM
Post #15


Poliwag Awesome Dude
Group Icon

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!
Go to the top of the page
+Quote Post

PokeNOM NOM NOM
post Jun 20 2011, 10:33 AM
Post #16


Spriter / Writer
Group Icon

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!


--------------------

Check out my GPX+ profile
to find out what I've contributed so far!



'Counterbalanced'
Go to the top of the page
+Quote Post

SmugleafForever
post Jun 20 2011, 11:47 AM
Post #17


The Nerd with a Minccino Obsession(The Dragon)
Group Icon

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.


--------------------
Clickables
Of course, the GPX.
Dragoncave.
Vdex.

Spriter here! I work at Husky Center.

I love Warriors, Pokemon, and Fruits Basket!

Clawflame on DragonCave, SmugleafForever on Gpxplus, Starberry on Warriorcats Forums, MagicalMinccino on Iscribble. StarberryMoonduskZor on DeviantArt.

Go to the top of the page
+Quote Post

Kazz
post Jun 20 2011, 11:51 AM
Post #18


Elite Four
Group Icon

Group: +Donors
Posts: 993
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.


--------------------
Go to the top of the page
+Quote Post

Running On Ice
post Jun 20 2011, 11:55 AM
Post #19


There’s a lot of tension in this town
Group Icon

Group: +Donors
Posts: 2 004
Joined: 30-April 09
From: Louisiana
Member No.: 17 626

Active Squad



QUOTE(SmugleafForever @ Jun 20 2011, 11:47 AM) *
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


--------------------
FRIEND CODE: 4527-8945-5766; NAME: Laura
FRIEND SAFARI: NORMAL; PM me so we can trade codes




Clubs and Shinies (click to show)

"Don't take advice from people like me. Do your own thing always"- Chrissie Hynde, from ironically a thing titled "Chrissie Hynde's Advice To Chick Rockers"
Go to the top of the page
+Quote Post

Zakariah
post Jun 20 2011, 12:15 PM
Post #20


Pokémon Trainer
Group Icon

Group: Members
Posts: 38
Joined: 1-September 10
Member No.: 112 377

Active Squad



Sounds cool, adding.


--------------------










Go to the top of the page
+Quote Post


5 Pages V   1 2 3 > » 
Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 28th March 2024 - 11:09 AM
All content and images ©2007-2015 GPX.Plus and Shiny New Software, LLC. Powered By IPB 2.3.1 © 2024 IPS, Inc.
Optimal viewing in the latest version of Safari, Chrome, or Firefox, 1024x768+.