# Gem Dragon Community Drop Rates **URL:** \ **Category:** Gameplay Chat (General)\ **Created:** [October 9, 2022, 6:23pm UTC](https://community.gemsofwar.com/t/gem-dragon-community-drop-rates/77297 "2022-10-09T18:23:26Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![NerdieBirdie](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/nerdiebirdie/32/103793_2.png) [@NerdieBirdie](https://community.gemsofwar.com/u/NerdieBirdie)\ **Post date:** [October 9, 2022, 10:38pm UTC](https://community.gemsofwar.com/t/gem-dragon-community-drop-rates/77297/21 "2022-10-09T22:38:14Z")
> [@Stratelier](#): > > In spreadsheet formulae? Just add a column or two to extract the day-of-week (=WEEKDAY(…)) and day-of-month (=DAY(…)) and worry about aggregating the rest later. I am not super knowledgeable about spreadsheets and I’m not sure how to do that 😅 If you or anyone else would like to make a copy of my sheet and improve on it, that’d be epic! Here it is: [GoW Gem Dragons Chart - Google Sheets](https://docs.google.com/spreadsheets/d/1NtBUcmrcPNuWvwceb6pIC_Shl662rmFlCvt-YnOXD-U/edit?usp=sharing) ---
**Author:** ![TheIdleOne](https://avatars.discourse-cdn.com/v4/letter/t/c68b51/32.png) [@TheIdleOne](https://community.gemsofwar.com/u/TheIdleOne)\ **Post date:** [October 9, 2022, 11:02pm UTC](https://community.gemsofwar.com/t/gem-dragon-community-drop-rates/77297/22 "2022-10-09T23:02:43Z")
Crafted order: 1. Garnetaerlin (Brown) 2. Topasarth (Yellow) 3. Sapphirax (Blue) 4. Amethialas (Purple) 5. Garnataerlin (Brown dupe) 6. Rubirath (Red) 7. Amethialas (Purple dupe) 8. Sapphirax (Blue dupe) Crafted 7 and 8 on a Saturday (different ones) for what its worth ---
**Author:** ![NerdieBirdie](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/nerdiebirdie/32/103793_2.png) [@NerdieBirdie](https://community.gemsofwar.com/u/NerdieBirdie)\ **Post date:** [October 9, 2022, 11:12pm UTC](https://community.gemsofwar.com/t/gem-dragon-community-drop-rates/77297/23 "2022-10-09T23:12:11Z")
----- Data up to this point ----- ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/8/8/880c27f398bfef2e4e57b8f958af834d3d88cb43.png) ---
**Author:** ![icy](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/icy/32/71999_2.png) [@icy](https://community.gemsofwar.com/u/icy)\ **Post date:** [October 9, 2022, 11:24pm UTC](https://community.gemsofwar.com/t/gem-dragon-community-drop-rates/77297/24 "2022-10-09T23:24:30Z")
So far I collected “blue” and “brown”. Just two eggos opened. Looking at the stats as of now, it looks like the overall distribution is close to equal. But it’ll still wreck us all if the distribution per user is unequal. 🙂 The real question moreso is and will be, how many eggos will everyone each need until one dragon set is completed. ---
**Author:** ![Stratelier](https://avatars.discourse-cdn.com/v4/letter/s/977dab/32.png) [@Stratelier](https://community.gemsofwar.com/u/Stratelier)\ **Post date:** [October 9, 2022, 11:37pm UTC](https://community.gemsofwar.com/t/gem-dragon-community-drop-rates/77297/25 "2022-10-09T23:37:02Z")
> [@NerdieBirdie](#): > > I am not super knowledgeable about spreadsheets and I’m not sure how to do that I can’t edit your spreadsheet directly (because permissions), and in any case you need to be logging raw data IN your spreadsheet (in a designated location, or a separate sheet) before you can build functions to compile the results for you. Right now you’re just tallying up (and graphing) the results manually. For a comparison, take a look at [this example sheet](https://docs.google.com/spreadsheets/d/1rIhLIVIdvQlLpSfY-ilRV8SbcOLW9KRWeBRFleXu6D0/edit?usp=sharing) I mocked up: - Column A contains raw dates. For demonstration purposes I generated these randomly (they in fact reroll with _any_ edit made to the spreadsheet). In a real example you would just type in your raw data here. - Column B extracts the day-of-week from each date (1=Sunday, 2=Monday, etc) so we can use it later. - Column C likewise extracts the day-of-month from each date. - Column D represents a Gem Dragon for that day. Again, for demonstration purposes this is generated randomly; in a real example you would be reporting the actual data (again, as-is). - Column E demonstrates writing a few formulas to make the spreadsheet compile various kinds of data for you (in real time even). - First up is the “# of Wednesdays”, calculated by scanning column B (day of week) for the value 4 (Wednesday). - Second up is the # of dates within the “week 1” of its month (e.g. 1st through 7th day of month), done by scanning column C. - Last but not least is a simple Dragon finder. You should be able to edit the white box in cell E8 - type a Dragon name here and you will see a count of how many times that Dragon appears in column D. (Note that because the names in column D are picked at random, the values – i.e. the “search results” – will change with _every_ edit made.) ---
**Author:** ![Planet13](https://avatars.discourse-cdn.com/v4/letter/p/aeb1de/32.png) [@Planet13](https://community.gemsofwar.com/u/Planet13)\ **Post date:** [October 10, 2022, 12:02am UTC](https://community.gemsofwar.com/t/gem-dragon-community-drop-rates/77297/26 "2022-10-10T00:02:14Z")
Saved 500 crafted Sapphirax. Saved another 500 crafted Sapphirax, what are the odds? Saved up 2500 crafted 5 at once, x3 Sapphirax, Rubirath, Topasarth So my total is x5 Sapphirax, x1 Rubirath, x1 Topasarth ---
**Author:** ![Emos](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/emos/32/5163_2.png) [@Emos](https://community.gemsofwar.com/u/Emos)\ **Post date:** [October 10, 2022, 12:41am UTC](https://community.gemsofwar.com/t/gem-dragon-community-drop-rates/77297/27 "2022-10-10T00:41:49Z")
2 Amethyst 2 Garnet 1 Topaz 1 Emerald 1 Sapphire ---
**Author:** ![sxesic](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/sxesic/32/30287_2.png) [@sxesic](https://community.gemsofwar.com/u/sxesic)\ **Post date:** [October 10, 2022, 12:51am UTC](https://community.gemsofwar.com/t/gem-dragon-community-drop-rates/77297/28 "2022-10-10T00:51:53Z")
2x green 1x brown 1x blue 1x yellow ---
**Author:** ![sylverscale](https://avatars.discourse-cdn.com/v4/letter/s/f17d59/32.png) [@sylverscale](https://community.gemsofwar.com/u/sylverscale)\ **Post date:** [October 10, 2022, 2:11am UTC](https://community.gemsofwar.com/t/gem-dragon-community-drop-rates/77297/29 "2022-10-10T02:11:26Z")
I got these (in order) Green Brown Yellow Green (dupe) Purple Purple (dupe) Purple (2nd dupe) (Two of the purple dragons were crafted on purple day, don’t remember any of the others.) ---
**Author:** ![NerdieBirdie](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/nerdiebirdie/32/103793_2.png) [@NerdieBirdie](https://community.gemsofwar.com/u/NerdieBirdie)\ **Post date:** [October 10, 2022, 3:29am UTC](https://community.gemsofwar.com/t/gem-dragon-community-drop-rates/77297/30 "2022-10-10T03:29:14Z")
----- Data up to this point ----- ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/9/2/926b3cd68cc7387ba46ff9784e6e8313082f9b44.png) ---
**Author:** ![Julli-of-North](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/julli-of-north/32/91083_2.png) [@Julli-of-North](https://community.gemsofwar.com/u/Julli-of-North)\ **Post date:** [October 10, 2022, 6:04am UTC](https://community.gemsofwar.com/t/gem-dragon-community-drop-rates/77297/31 "2022-10-10T06:04:45Z")
![image](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/6/6/660d9e0939089d088e13898bfec4d023aab6ef70.jpeg) ---
**Author:** ![crisp](https://avatars.discourse-cdn.com/v4/letter/c/57b2e6/32.png) [@crisp](https://community.gemsofwar.com/u/crisp)\ **Post date:** [October 10, 2022, 6:11am UTC](https://community.gemsofwar.com/t/gem-dragon-community-drop-rates/77297/32 "2022-10-10T06:11:06Z")
![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/f/1/f1729dc6b7d3ebd59c142246f9239bb17c1fa632.png) Tried crafting on specific days, but the colors never matched 🤷‍♂️ ---
**Author:** ![Pau](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/pau/32/68074_2.png) [@Pau](https://community.gemsofwar.com/u/Pau)\ **Post date:** [October 10, 2022, 6:31am UTC](https://community.gemsofwar.com/t/gem-dragon-community-drop-rates/77297/33 "2022-10-10T06:31:54Z")
Rubirath x 1, Topasarth x 3, Sapphirax x 2 ---
**Author:** ![overthinker](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/overthinker/32/86337_2.png) [@overthinker](https://community.gemsofwar.com/u/overthinker)\ **Post date:** [October 10, 2022, 7:28am UTC](https://community.gemsofwar.com/t/gem-dragon-community-drop-rates/77297/34 "2022-10-10T07:28:28Z")
Screenshot from my guildmate ![Screenshot_20221010_102732](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/9/5/953f067e720366c8123aa97f76163f695ccca624.jpeg) ---
**Author:** ![Garrisundal](https://avatars.discourse-cdn.com/v4/letter/g/ea666f/32.png) [@Garrisundal](https://community.gemsofwar.com/u/Garrisundal)\ **Post date:** [October 10, 2022, 8:54am UTC](https://community.gemsofwar.com/t/gem-dragon-community-drop-rates/77297/35 "2022-10-10T08:54:07Z")
Can’t remember the order - but I do know I got one of each first, before the 2 repeated ones (first 3 were all for the same weapon). ![Screen Shot 2022-10-10 at 9.52.35 PM](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/f/a/fab2507cb1e5d9f8adc216405aa9c71b8d17949a.jpeg) ---
**Author:** ![esslee](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/esslee/32/103072_2.png) [@esslee](https://community.gemsofwar.com/u/esslee)\ **Post date:** [October 10, 2022, 9:55am UTC](https://community.gemsofwar.com/t/gem-dragon-community-drop-rates/77297/36 "2022-10-10T09:55:28Z")
In order :- Rubirath Garnetaerlin Garnetaerlin (dupe) Emeraldrin Rubirath (dupe) Emeraldrin (dupe) 3 dupes from 6 eggs ---
**Author:** ![Bernice](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/bernice/32/76215_2.png) [@Bernice](https://community.gemsofwar.com/u/Bernice)\ **Post date:** [October 10, 2022, 11:31am UTC](https://community.gemsofwar.com/t/gem-dragon-community-drop-rates/77297/37 "2022-10-10T11:31:08Z")
True my favorite color is purple… but 1 would’ve been fine 🤦🏻‍♀️ ![image](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/e/e/ee4e4f8848cbe01279404904efd960b4207ebcb1.jpeg) ---
**Author:** ![fm3209660](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/fm3209660/32/75740_2.png) [@fm3209660](https://community.gemsofwar.com/u/fm3209660)\ **Post date:** [October 10, 2022, 1:13pm UTC](https://community.gemsofwar.com/t/gem-dragon-community-drop-rates/77297/38 "2022-10-10T13:13:27Z")
![Screenshot_2022-10-10-19-18-54-12_639543440735615bbc36855b9e156373](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/6/9/69e9bb33456abd8f1662a26cad444a30757d95c2.jpeg) Opened my 5th egg today for yellow dupe ---
**Author:** ![gow](https://avatars.discourse-cdn.com/v4/letter/g/e9c0ed/32.png) [@gow](https://community.gemsofwar.com/u/gow)\ **Post date:** [October 10, 2022, 2:41pm UTC](https://community.gemsofwar.com/t/gem-dragon-community-drop-rates/77297/39 "2022-10-10T14:41:00Z")
2 eggs only and 2 purple dragons. WTF? ---
**Author:** ![NerdieBirdie](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/nerdiebirdie/32/103793_2.png) [@NerdieBirdie](https://community.gemsofwar.com/u/NerdieBirdie)\ **Post date:** [October 10, 2022, 2:57pm UTC](https://community.gemsofwar.com/t/gem-dragon-community-drop-rates/77297/40 "2022-10-10T14:57:04Z")
Thank you all for the data!! I will update the chart after work! [Previous page](https://community.gemsofwar.com/t/gem-dragon-community-drop-rates/77297.md?page=1) [Next page](https://community.gemsofwar.com/t/gem-dragon-community-drop-rates/77297.md?page=3)