IronSheik

Welcome to the NEW and IMPROVED drop chart system. The drop chart is still the one you know and love. However, I have now added a form which allows you to submit directly into the chart, streamlining the whole process. Note: While it's encouraged to use the form below, feel free to submit reports as forum posts as some members have offered to insert them into the drop chart on your behalf. Goal is to capture as many reports as possible! Step 1: Use the form linked below to submit your report Link to Form (Google Forms) Step 2: Your submission will take approximately 1-2 minutes to transpose into the chart below Link to Drop Chart (Excel Web View) Difficulty Episode Area # Section ID Monster Item Ultimate 1 Caves Viridia Dal Ral Lie Ultima's Engine Ultimate 1 Caves Pinkal Dal Ral Lie Ultima's Engine Ultimate 2 Spaceship Greenill Gol Dragon Ultima's Engine Ultimate 1 Ruins Yellowboze Dark Falz Ultima Bringer's Ultimate 1 Ruins Oran Dark Falz Ultima Bringer's Ultimate 1 Mines Redria Sinow Blue Tyrfing Ultimate 1 Mines Skyly Sinow Blue Tyrfing Ultimate 1 Mines Viridia Sinow Blue Tyrfing Ultimate 2 Tower Greenill Gi Gue Sword of Ultima Ultimate 4 Desert Bluefull Merissa AA Sword of Ultima Ultimate 2 CCA Skyly Ul Gibbon Sword of Ultima Ultimate 2 Tower Bluefull Gi Gue Sword of Ultima Ultimate 4 Desert Skyly Merissa AA Sword of Ultima Ultimate 4 Desert Yellowboze Merissa AA Sword of Ultima Ultimate 4 Desert Redria Merissa AA Sword of Ultima Ultimate 4 Desert Viridia Merissa AA Sword of Ultima Ultimate 4 Desert Whitill Shambertin Sonic Team Armor Ultimate 4 Desert Bluefull Shambertin Sonic Team Armor Ultimate 4 Desert Yellowboze Shambertin Sonic Team Armor Ultimate 4 Desert Pinkal Shambertin Sonic Team Armor Ultimate 4 Desert Purplenum Shambertin Sonic Team Armor Ultimate 4 Desert Skyly Shambertin Sonic Team Armor Normal 1 Forest Pinkal Gigobooma Sonic Magazine Ultimate 4 Desert Yellowboze Kondrieu Mr. Naka's Business Card Ultimate 4 Desert Bluefull Kondrieu Mr. Naka's Business Card Ultimate 4 Desert Greenill Kondrieu Mr. Naka's Business Card Ultimate 4 Desert Whitill Kondrieu Mr. Naka's Business Card Ultimate 4 Desert Viridia Kondrieu Mr. Naka's Business Card Ultimate 2 Temple Viridia Barba Ray Mr. Naka's Business Card Ultimate 4 Desert Viridia Saint Million Mr. Naka's Business Card Ultimate 4 Desert Oran Kondrieu Mr. Naka's Business Card Ultimate 4 Desert Redria Saint Million Mr. Naka's Business Card Ultimate 1 Mines Whitill Vol Opt ver. 2 Mr. Naka's Business Card Ultimate 1 Mines Oran Vol Opt ver. 2 Mr. Naka's Business Card Ultimate 1 Mines Yellowboze Vol Opt ver. 2 Mr. Naka's Business Card Ultimate 4 Desert Skyly Kondrieu Mr. Naka's Business Card Ultimate 4 Desert Pinkal Saint Million Mr. Naka's Business Card Ultimate 2 Seabed Bluefull Morfos Hand of Justice Ultimate 2 Seabed Whitill Morfos Hand of Justice Ultimate 2 Tower Bluefull Merikle Frozen Booster Ultimate 2 Tower Yellowboze Merikle Frozen Booster Ultimate 2 Tower Whitill Merikle Frozen Booster Ultimate 2 Tower Redria Merikle Frozen Booster Ultimate 2 Tower Greenill Merikle Frozen Booster Ultimate 2 Tower Skyly Merikle Frozen Booster Ultimate 2 Seabed Whitill Olga Flow D-Photon Core Ultimate 2 Seabed Viridia Olga Flow D-Photon Core Ultimate 4 Desert Whitill Goran Detonator Asteron Striker Ultimate 4 Desert Greenill Goran Detonator Asteron Striker Ultimate 4 Desert Viridia Goran Detonator Asteron Striker Ultimate 4 Desert Purplenum Goran Detonator Asteron Striker Ultimate 4 Desert Oran Goran Detonator Asteron Striker Ultimate 4 Desert Pinkal Goran Detonator Asteron Striker Ultimate 4 Desert Bluefull Girtablulu Arrest Booster Ultimate 4 Desert Yellowboze Girtablulu Arrest Booster Ultimate 4 Desert Greenill Girtablulu Arrest Booster Ultimate 4 Desert Purplenum Girtablulu Arrest Booster Ultimate 4 Desert Skyly Girtablulu Arrest Booster Ultimate 4 Desert Viridia Girtablulu Arrest Booster Last updated: 2022-12-18 @ 8:11am ET Link to Event Post

Post Event shop update! LINK TO ORIGINAL POST

Final tally is up with a total of 144 reports. Check out the first post. See you next event! LINK TO ORIGINAL POST EDIT: Congratulations to @Flerbert for the most reports this event at 54!

Oh this is delicious. I look forward to trying this out.

After a slew of happy hours this weekend, we are now at 128 reports! Updated the charts to show the latest and greatest in the original post. LINK TO ORIGINAL POST

Ohhh supply and demand. I might start hunting Girasoles now.

Great work so far guys. We are currently at 86 reports! First post has been updated with the latest info. LINK TO ORIGINAL POST

Halo Rappies only appear during Halloween event and will always drop what's already reported on the main drop table (jack o lanterns) so they won't be added to the event drop chart.

Kondrieu? This has been updated now. Sorry for the delay. There is the tab from last year which shows the reports from then. It was all IDs for Eclairs and it very likely is this year, but we verify to make sure regardless.

Thanks for the verification @sloo. Will update it.

Just over 12 hours into this event and there is already some interesting information...assuming that the Vol Opt v2 report is correct....things may have changed up! Also...I received this little tidbit of info from a very reliable source: "Drop rates are not same for all IDs" LINK TO ORIGINAL POST

Welcome to the NEW and IMPROVED drop chart system. The drop chart is still the one you know and love. However, I have now added a form which allows you to submit directly into the chart, streamlining the whole process. Note: While it's encouraged to use the form below, feel free to submit reports as forum posts as some members have offered to insert them into the drop chart on your behalf. Goal is to capture as many reports as possible! Step 1: Use the form linked below to submit your report Link to Form (Google Forms) Step 2: Your submission will take approximately 1-2 minutes to transpose into the chart below Link to Drop Chart (Excel Web View) Difficulty Episode Area # Section ID Monster Item Very Hard 1 Ruins Greenill Chaos Bringer Vampire Cloak Very Hard 1 Ruins Whitill Chaos Bringer Vampire Cloak Very Hard 1 Ruins Purplenum Chaos Bringer Vampire Cloak Ultimate 1 Ruins Whitill Indi Belra Ultima Reaper Ultimate 1 Ruins Redria Indi Belra Ultima Reaper Ultimate 1 Ruins Pinkal Indi Belra Ultima Reaper Ultimate 1 Ruins Oran Indi Belra Ultima Reaper Ultimate 1 Ruins Bluefull Indi Belra Ultima Reaper Ultimate 1 Ruins Yellowboze Indi Belra Ultima Reaper Ultimate 1 Ruins Viridia Indi Belra Ultima Reaper Ultimate 1 Caves Purplenum Pouilly Slime Heart Container Ultimate 1 Caves Greenill Pouilly Slime Heart Container Ultimate 1 Caves Viridia Pouilly Slime Heart Container Ultimate 1 Caves Skyly Pouilly Slime Heart Container Ultimate 1 Forest Skyly Pal Rappy Heart Container Ultimate 1 Forest Viridia Pal Rappy Heart Container Ultimate 1 Forest Purplenum Pal Rappy Heart Container Ultimate 1 Caves Bluefull Pouilly Slime Heart Container Ultimate 1 Caves Pinkal Mil Lily Heart Container Ultimate 4 Desert Skyly Shambertin Girasole Ultimate 4 Desert Whitill Shambertin Girasole Ultimate 4 Desert Redria Shambertin Girasole Ultimate 4 Desert Yellowboze Shambertin Girasole Very Hard 4 Desert Purplenum Shambertin Girasole Very Hard 4 Desert Skyly Shambertin Girasole Ultimate 2 Tower Whitill Epsilon Chromatic Orb Ultimate 2 Tower Bluefull Epsilon Chromatic Orb Ultimate 2 Tower Greenill Epsilon Chromatic Orb Ultimate 2 Tower Oran Epsilon Chromatic Orb Ultimate 2 Tower Redria Epsilon Chromatic Orb Ultimate 2 Tower Yellowboze Epsilon Chromatic Orb Ultimate 4 Crater Oran Dorphon Eclair Banana Cannon Ultimate 4 Crater Pinkal Dorphon Eclair Banana Cannon Ultimate 4 Crater Bluefull Dorphon Eclair Banana Cannon Ultimate 4 Crater Whitill Dorphon Eclair Banana Cannon Ultimate 4 Crater Redria Dorphon Eclair Banana Cannon Ultimate 4 Crater Skyly Dorphon Eclair Banana Cannon Ultimate 4 Crater Purplenum Dorphon Eclair Banana Cannon Ultimate 4 Crater Viridia Dorphon Eclair Banana Cannon Ultimate 4 Crater Yellowboze Dorphon Eclair Banana Cannon Ultimate 4 Crater Greenill Dorphon Eclair Banana Cannon # of Item Reports Item # Banana Cannon 10 Heart Container 9 Ultima Reaper 7 Chromatic Orb 6 Girasole 6 Vampire Cloak 3 Leader Board Name # of Reports mikan-sakura 12 Scurvy Jim 2 Lordwin 4 Flerbert 54 Omegalo 1 KILL 1 IronSheik 36 Guichy 8 SinowNeo617 3 RigeL7 1 HammerHea 1 DevlinKhodabaks 4 JupiterDeCrank 1 Lobotomy 2 cososo 1 Wavebuster 4 Heather Prime 1 sloo 2 Smoochum 2 tortelini 1 Strafe 1 kuratulas 1 Hawk 1 # of Reports Per Day # Day 1 2022-10-29 24 2022-10-30 12 2022-10-31 5 2022-11-01 2 2022-11-02 2 2022-11-03 1 2022-11-04 34 2022-11-05 18 2022-11-06 0 2022-11-07 6 2022-11-08 5 2022-11-09 4 2022-11-10 0 2022-11-11 10 2022-11-12 11 2022-11-13 1 2022-11-14 1 2022-11-15 1 2022-11-16 2 2022-11-17 0 2022-11-18 4 2022-11-19 0 2022-11-20 Last updated: 2022-11-20 @ 3:05am ET Link to Event Post

If you really want idealism and thinking out of the box, there should be a database log generated each time of what dropped where from what monster. Now this wouldn't apply to every item since it would be ridiculous, but it would be filtered so if something particular does drop for someone that falls within the criteria and one picks it up, it should log the Guild #, item, time of pick up, etc... This should then auto-generate a list of drops. The list would essentially build itself, and since Guild #'s are pretty much tied to forum members, you'd know who got what.

I have a Bomb Chu in my store:

I think this is the correct way forward too. I'll make that adjustment in the next iteration.

Thank you all for the feedback so far. Just to give you guys an idea of how this works: The system uses mostly free resources (with the exception of Excel, since I pay for an Office subscription license for other purposes). These are the tools I'm currently comfortable with using. Maybe one day if I learn to program using Python, I can put together a better system. Google Forms is used with pre-populated lists which guides the user to select the correct information with no typos, etc. The only field that is open for any text today is the Forum Name Once submitted, it sends the data to a google spreadsheet, which publishes the info publicly for retrieval Using Power Query in Excel, the data is retrieved manipulated into a separate table (2022 IMPORT tab) From there, the 2022 Drop Table tab pulls the information from 2022 Import, and manipulates the information into the lists that you see (Drop Table, Drops Per ID Chart, # of reports, Leaderboards, etc. When I make forum posts, I take screenshots of each table and paste it as an image. I also take a text copy of the list and post it in the first post for ease of access (for those who struggle to see the Excel Online spreadsheet) Things I wish the current system would handle better: I would rather use Microsoft Forms, since it would integrate much more seamlessly with Excel, but that requires a more expensive subscription. Current subscription only allows for downloadable excel files One thing I dislike about Google Forms is when you create branch in the form, it creates a new page you have to click next to get to. Microsoft Forms updates the page on the spot as you pick the right branches and would be much more seamless, however see above for why I can't use Microsoft Forms The system today doesn't have a way to inform the user if a report has already been made, or checks if the report is accurate. The duplicate report appears in a different colour, but this is still handled manually where I have to go in and remove the duplicate report Conflicting reports also work the same way. I see them conflicting and I have to verify/remove the incorrect one. @Lobotomy you make great points. To address them: This definitely frees up my time and removes a huge amount of manual labour to transpose the information from the forum into the spreadsheet. The information is designed to make it as easy, error-free and seamless as possible. I've had a few people using them during their runs and found it was much easier to use the form rather than typing things in manually The Excel sheet pulls the data online in 1 minute intervals, which is why it refreshes so fast. Yes it is fantastic that people can see the results right away I wish there was a way to allow users to do a mass input of discoveries, but at this time, the tools are limited to what you see The order of monsters is just like what @Smoochum said. It is sorted by area first (e.g. Forest, Caves, Mines, Ruins), then alphabetical within those areas. Access to the information is always available no matter what. Anyone can go into the Excel and do data exports and run their own numbers, copy/paste things, etc. Ultimately, I think that the drop chart reporting should be a built-in function on the website itself rather than some 3rd party tools. It already gets a ton of engagement, so why not make it into something official and something people can contribute to? Some benefits I see would be: A new, unique table per event/year would open up, can shows previous year's drops for reference. A reward/trusted submitter system if accurate reports are made Score based on rarity of item (example: Zelda Magazine report would be worth 1 point, Master Sword would be worth 5 points, non-event drops from rarer mobs/drop rates worth more points, etc.) An easy to input form, which allows for 1 or bulk submissions. and outputs to a table that looks similar to a drop chart A native chart that updates with live data, showing similar stats that the Excel form does, not requiring signing into a separate system to see This is the true way of doing it, and me only being a mere member with limited ability, this is what I came up with...showing the potential of what could be. This is something the community loves engaging in, so the developers should capitalize on it. Hopefully @Larva, @Soly and the like catch wind of this. Hopefully this clarifies things. @JupiterDeMars also messaged me in private to bring up some concerns, which I am truly grateful for. The only way things get better is with unfiltered, candid feedback, so please keep them coming!

Good day hunters. The latest drop chart had some pivotal changes, the main one being direct user input rather than having a middleman re-enter data that's submitted as posts in the forum. Other additions include: - # of reports per day - Leader Board Understandably, this is a much different way of doing things, and some people were uncomfortable with it. Despite the major change, we had a total of 423 reports to date, which leads me to believe that the community was pretty receptive of it. This is an opportunity for you to sound off and let me know what your thoughts are. Did you enjoy it? Is there anything that could be done better?

Reports have stagnated since the 11th. I guess this is around the time that events start to die down anyways (week 3). With Halloween less than 2 weeks away, it's very likely that it will be ending soon. I updated the original post with all the latest stats anyways. LINK TO ORIGINAL POST

Shop has been updated. TP requirement has been completely removed as I now have all the TPs I needed. Still accepting NYC's as currency in addition to PDs and DTs though. LINK TO ORIGINAL POST

Long overdue, but shop has been updated! LINK TO ORIGINAL POST

When does the event end? Usually that information is in the first post but seems to be missing this time around.

It looks like all Gal Gryphon drops have been reported successfully. Great work! Next Challenge: Report all Barba Ray drops Original post has been updated too with the latest reports. We're at 423 reports so far this event! Great work everyone. LINK TO ORIGINAL POST

50/50

Guys, this is pretty awesome, so far the drop chart is at 406 reports! Great work! Distribution of drops per ID. Green, red and yellow are the least popular: These monsters have 3 or less reports left before they are completely reported on all IDs:

So this is my fate...