Spiral Knights - Gathering data on Grinchlin Assault!

Gathering data on Grinchlin Assault!

53 replies [Last post]

Sat, 12/14/2013 - 07:26

Krakob

I'm interested in seeing if Advanced actually is better than Elite for gathering 3* and 4* mats so I made a sheet and now I need people to help me fill it!
https://docs.google.com/spreadsheet/ccc?key=0AokNm7S1ec-qdEZ0Ym93RUVLc3E...
This sheet intends to cover all difficulties in Stratum 6. Runs must go to the top of the mountain.

To submit data, go here:
https://docs.google.com/forms/d/1CmjmOuCypZHiEyPfOTqMXBdfE1cSUiOT0KbV0Mw...
And follow the instructions.

Edit: the patch of Dec 18 brought us changes to the drop chances. Thus, all existing data was obsoleted and the collection had to restart. The old data is still available if it interests you but keep in mind that this does not reflect the current drop rates. The sheet is available here.

Sat, 12/14/2013 - 07:44

Skepticraven

Ooh yay

Someone else is hosting a drop rate analysis. :D
One of these days theyll update arcade redux phase 2 and ill get back to doing the orb/fire crystal one.

Expect some data from me!

Sat, 12/14/2013 - 09:20

Skepticraven

First of the data.

2 people on normal
3 on elite
2 on elite

Read the captions I put on them for the snowball count if its not visible. (Also, caption lists which people I imaged specifically for data - Didn't DC and I got their snowball count)
Random question: Is there a screen resolution to show more than 5 mats on the report? It would make taking image datapoints much better.

Sat, 12/14/2013 - 10:26

Krakob

Added your data. Are you sure Zeke got no giftwraps in the 3-man run, though?

As for the resolution, just try bigger and bigger until you hit it. Oooor, do the maths. Check the height of an item on the list in pixels, and add that to your current resolution. Then choose a resolution that big or if there is none, the one that's just a tad bigger.

Sat, 12/14/2013 - 10:38

Skepticraven

@Krakob

Yes, he got no giftwraps that run. He was disappointed at the horrible run he got.
Also - be sure to add in the 0's or the "average" function won't calculate correctly (with those 0 datapoints included).

Sat, 12/14/2013 - 10:46

Krakob

Alright, thanks! Keep the data coming!

Sat, 12/14/2013 - 11:28

Dimbreath

We could do some runs

We could do some runs together to make the data gathering easier, though. I'm going to try to get some data.

Sat, 12/14/2013 - 12:06

Skepticraven

More data

3 advanced

Hehe, better slow down on my data. Let other people contribute.

Sat, 12/14/2013 - 18:57

Qwote

http://i.imgur.com/x7qjYzP.png
http://i.imgur.com/3tUyK6T.png

Sat, 12/14/2013 - 18:58

Ardent-Light

Graveyard it quickly!

Graveyard it quickly! Before the Grinchlins exploit our tacticts!

Sat, 12/14/2013 - 19:37

#10

Calmingbreeze

I got 5 stockings, 2 ribbons,

I got 5 stockings, 2 ribbons, 6 coals, 4 treats, and 12 snowballs on my normal mode run tonight.

http://i43.tinypic.com/27wt4kw.png

Please only use my data, because 2 of the party members were dead for the last room (sad) and the other's info is cut off

Sat, 12/14/2013 - 20:32

#11

Xxpapaya

The papaya giggles

@Ardent-Light
Its too late >:) They've already seen the thread!

Sat, 12/14/2013 - 20:37

#12

Bitsbee

Playing on Elite, I've gotten only Lumps of Coal & Spoiled Treats in the first arena Prize Boxes. Can you get the other Materials there or are they exclusive to the other rooms?

Sat, 12/14/2013 - 21:26

#13

Poopsie

@Bitsbee

Assuming you do tier 3 one, you get random mats on any treasure boxes, further rooms only give more boxes, and a chance to get trinket if you defeat last boss.

Sun, 12/15/2013 - 13:30

#14

Krakob

Added all data to the sheet. Big thanks to Qwote, although I can't see the Snowball count on the second row in the first pic.

Looking at the data now, it appears that Elite and Advanced have about as many 3* and 4* mats. We only have data on one run with three people, though. It might not be accurate.

I encourage Advanced runs to gather more 3* and 4* mats to get us data so we can know what's the most effective. No matter, bear in mind that Elite runs are harder so once you have your 5* mats, I suggest you run on Advanced to save yourself a spark or eightythree.

Sun, 12/15/2013 - 13:35

#15

Bitsbee

Oh, I almost forgot to mention that I did Elite Solo, too. No Party Members. Does Party Size affect the drops?

Sun, 12/15/2013 - 13:43

#16

Krakob

No, it shouldn't. Loot is individual.

Sun, 12/15/2013 - 14:04

#17

Gkku

Advanced data comin' through

http://puu.sh/5NNeN.jpg
http://puu.sh/5NNgm.jpg
http://puu.sh/5NNhx.jpg
http://puu.sh/5NNiy.jpg

If it wasn't obvious, all 4 were on advanced.

Sun, 12/15/2013 - 14:22

#18

Skepticraven

More data

Three
More
Elites
(8 total more datapoints - Public runs are fun!)

I guess I should do more advanced runs for more of those datapoints?
But I'm doing these for the trinkets... hrm... We'll see what I end up doing.

Sun, 12/15/2013 - 14:38

#19

Cheshireccat

Ring found!

5 Full Runs on Advanced

http://i.imgur.com/aZaOl6s.png
http://i.imgur.com/uo9Zrh8.png
http://i.imgur.com/069zFHh.png
http://i.imgur.com/Wu3FxDE.png
http://i.imgur.com/e8gIro7.png

Sun, 12/15/2013 - 15:04

#20

Skepticraven

Gasp.

Looking at these advanced runs... are rings more common on advanced?! Its probably a statistical anomaly...

Sun, 12/15/2013 - 16:32

#21

Calmingbreeze

I am trying to help more with this, but my weapons are not maxed out due to the radiant crystals thing. As a result, I stick to advanced or normal and most people seem to leave in the middle of those.

Sun, 12/15/2013 - 21:18

#22

Cheshireccat

When will you update the spreadsheet?

Three more Advanced runs:
http://i.imgur.com/AyaI3Wj.png
http://i.imgur.com/Lga4iIL.png
http://i.imgur.com/b3DZtE0.png

Thanks for organizing this data collection!

Mon, 12/16/2013 - 12:21

#23

Dimbreath

So, is anyone up to do a

Nevermind.

Mon, 12/16/2013 - 12:42

#24

Krakob

I swear to Oden that I'm going to choke on a spreadsheet some day. You guys make a fevery boy really tired, thanks! ❤
To make my life easier, I shall attempt trying to set up a forms document so that you people can enter all the data so that things update quicker and I don't have to spend half an hour updating the sheet every day just 'cause Qwote and Cheshire are really helpful. I bet there will be trolls, though. Pesky trolls. Good thing deleting stuff is quick!

@Cheshirecat
As I mentioned earlier in this post, I'm currently sick. I have required a lot of rest today and I might as well tomorrow. Sorry!

Mon, 12/16/2013 - 13:34

#25

Skayeth

Lolz

These rings are by far one of the most useless I have ever seen, but are they bound? If they aren't, the AH auction house is going dooonwwwnnn.

Mon, 12/16/2013 - 13:38

#26

Krakob

Made the sheet, updating the main post. Bad news, though. I can't automate it entirely so I will have to copy paste sent data into the existing sheets.

@Annilaton
Please don't go off topic.

Mon, 12/16/2013 - 17:05

#27

Bitsbee

Can we confirm this?

You cannot get any Materials other than Lump of Coals & Spoiled Treats in the 1st Arena's Prize Boxes. I've completed the Arena at least 30 times with nothing else, other than the occasional Grinchlin Snowballs, dropping. This was done on Elite, Solo.

After Partying up with 3 other people & completing the 3rd Arena, I got Razor Wire, Bottomless Stockings, & an Indestructible Giftwrap.

Mon, 12/16/2013 - 20:54

#28

Cheshireccat

3 Advanced Runs

http://i.imgur.com/dzUkI8Z.png
http://i.imgur.com/szTRpMy.png
http://i.imgur.com/9vxK0rn.png

Mon, 12/16/2013 - 20:57

#29

Cheshireccat

@Krakob

I'm sorry to hear that--I hope you feel better!

Just read the updated thread after I posted. Filling info now.

If you're a fan of data mining, we should chat some time about my UV spreadsheet. :)
IG: Cheshireccat

Mon, 12/16/2013 - 21:02

#30

Cheshireccat

Google Form

Um.... I think you're missing the Razor Ribbons from the Google form... :)

Also, could you change the order to reflect the way they appear in the list?
Giftwrap > Ring > Stocking > Ribbon > Coal > Treat > Snowball
It would make entering all my runs easier. :)

Anyway, I'll stop being helpful after another eight runs or so. Just need to craft the one weapon I don't already have. :P

--Cheshireccat

Tue, 12/17/2013 - 02:25

#31

Krakob

@Bitsbee
Sounds very possible.

@Cheshireccat
Patched it up, thanks! You should be able to submit more easily and correctly now.

Tue, 12/17/2013 - 02:53

#32

Xtweeterx

Haaaaaaaaa.... Now I wish I

Haaaaaaaaa.... Now I wish I didn't delete screenshots of me and guys beating the summit.

Tue, 12/17/2013 - 03:10

#33

Enfeebler

I´ve found a Golden Ring on

I´ve found a Golden Ring on Elite difficulty, but since it was before you made this thread I didn´t take a screenshot. :| Iĺl try to edit this post with some data so it won´t be that empty.

Tue, 12/17/2013 - 04:22

#34

Krakob

That's okay but if you want to submit data, please do it through the form linked to at the bottom of the original post. It's fast enough and means we both do some of the work :3

Tue, 12/17/2013 - 09:24

#35

Calmingbreeze

Well I am glad I did not waste time trying elite :D

Tue, 12/17/2013 - 13:32

#36

Tristicus

What about the solstice rings?

I've done the mission at least 10 times on elite, got to the end, and have yet to find a single Solstice trinket

Meanwhile one of my guildmates found the Silver Solstace trinket after his 3rd run.

Do I just have the worst luck in existance? Can the trinkets be found at lower difficulties?

Tue, 12/17/2013 - 14:20

#37

Thunder-The-Bright

gods ain't gonna help you, son.

don't worry tristicus, the worst luck is when you upgrade to an RSS and get slime low construct low UVs. #truestory
apparently trinkets can be found on advanced too.

Tue, 12/17/2013 - 14:59

#38

Flowchart

not just you. I've been farming it for the last couple days and have all the materials I need now, haven't gotten a trinket yet and only once has someone in my party got it.

Tue, 12/17/2013 - 15:32

#39

Krakob

I'm guessing the Ring drop chances are 0.5%, or 1 in 200. Since there are two rings, that'd make it 1 in 100 for either ring, though. I might be wrong, though. Those are just guesses, never heard anything that backs up any statement regarding their drop rates.

Tue, 12/17/2013 - 22:18

#40

Cheshireccat

2 Advanced Runs

I added my 3 runs from before as well as my 2 from tonight via the form.

http://i.imgur.com/GAxCgEH.png
http://i.imgur.com/OfhCuNA.png

Krakob, please verify that I did not double-enter parts of any runs?

Wed, 12/18/2013 - 08:03

#41

Bitsbee

Does anyone know where you can get a lot of Razor Ribbons & Bottomless Stockings?

I've tried farming the 2nd Arena Solo on Advanced, but I only get like 1 Ribbon/Stocking. Even with a 3-4 Player Party & finishing the 3rd Arena on Advanced/Elite, I get at the most 2, costing usually a spark or two.

I just need those two Materials & a lot of them. I've got around 100 Treats, 80 Coals, & 14 Giftwraps, but just 23 Stockings/Ribbons out of the 75 I need.

Wed, 12/18/2013 - 08:11

#42

Krakob

@Cheshireccat

Checked it, you had submitted one run twice but I fixed it. You can check yourself if you go to the "Submissions" sheet. I should add that it was a bit annoying for me to verify as you've entered yourself as the runner everywhere. Runner refers to the player, not the one who submits the player's data. If you submit the correct name, it will be a lot easier for me to verify if it's needed. Additionally, you could write something like "Run # start" for the first submission of one run and then "Run # end" for the last submission of that run.

Thanks a ton for the help, no matter!

Wed, 12/18/2013 - 12:38

#43

Skepticraven

Whelp

Guess they're upping the droprate of mats.
All this data is useless in about 90 minutes from this post.

Wed, 12/18/2013 - 13:41

#44

Krakob

Hallelujah bless my butt

At least the sheet can still be used. Submissions are locked until after the update. I've preserved the old data in a copy of the sheet and I will put it in the original post.

Wed, 12/18/2013 - 15:00

#45

Skepticraven

Wow.

First run makes it look like double the mats, if not more.

Wed, 12/18/2013 - 15:05

#46

Bitsbee

Welp...

Time to test the 1st Arena again.

Wed, 12/18/2013 - 15:37

#47

Krakob

Judging by one elite run, the mission has become a lot easier and the drop rates have increased. I honestly don't care that much but I liked it before because it would really be a challenge. Now it will mostly be a grind anyone could do but that's okay too because hey, us veterans have other ways of proving that we were here before others!

Wed, 12/18/2013 - 16:39

#48

Qwote

http://i.imgur.com/8af4VVy.png elite

note: first run is the same as this

Wed, 12/18/2013 - 17:53

#49

Gkku

Just added a lot from advanced runs.

Wed, 12/18/2013 - 18:19

#50

Bitsbee

10 Solo Advanced Runs on 1st Arena.

Still the same Materials drop, but in much bigger quantities. I assume it's the same on the rest of them.

Search

Gathering data on Grinchlin Assault!