Loot table for ddowiki

[Seikojin]

I know one doesn't exist, but I was thinking of a loot table to help build a online soure for chances.

Random loot, named, everything.

I think if people stuck to a format, it would be easier to add the data to the wiki without tainting the data too much.

Something like:

Quest name: <name>
Difficulty: <C/N/H/E/Ep>
Chest type: <random/named/warded/raid>
Item Name: <full name>
Item lvl: <total + if it is displayed, any min level/caster level if total + is not shown>

This way each time an item is found, it can be put into a database and then the results be tallied into percentages for drop rates.
I know things could become erratic considering random prefixes and suffixes, but having the total item level as a way to filter can help.

Any other ideas/thoughts/comments?

Below is a list of sheets you can copy to make a template on. I recommend only entering data from your pulls.
Cannith Crystal
https://spreadsheets.google.com/ccc?...thkey=CNm7k6MO

[EyeRekon]

Other known variables/factors

• Total loot bonus (gem, event, Horc)
• Party size (6 members = 6 pulls = 6 simultaneous data samples)

I agree that there is demand for this data, but I do not think you could reasonably expect people to sit there filling out forms for the database. If you get 3-5 items per person x 6 people and you're the only one logging that is a lot of entry.

In order to get drop rates you need data on when interesting items doesn't drop as well. Who is going to spend X minutes per quest logging results? How can you trust the results or the people entering them anyway? Duplicated results of people entering data from the same thing you observed.

There are a significant number of data miners and experimenters in our midst that do this already and could probably contribute much of their data.

Estimation is your friend. It is reasonably close without the laborious burden of measuring it.

[Alexandryte]

Unless that information is automatically polled from the game, I dont expect a loot table would work.

Things like WoWhead and other data aggregating repositories work because all the tedious work and calculations are done by a program that they run side by side with the client. Asking a player-base to keep tabs on loot drops without the infrastructure or support to do so is asking quite a lot.

Unlike DDOwiki, you need constant streams on input, not just one bit from here, and a week later, another bit from another player.

Long story short: Unless you are programming something to keep tabs or have an overabundance of help in various areas, I don't see a fully accurate version of an item database existing, player-side.

[Kinerd]

The difficulty I've found is that it without some kind of logging or capture software, I have to manually record everything I find in chests. This gets in the way of playtime for really everything except DT/epic chests, where people are discussing who gets what anyway, so it's not feasible to do while grouping without effectively piking.

Another difficulty with a communal effort is that it's possible (in the sense that it hasn't been empirically ruled out) that particular chests within a particular quest have different loot levels. I know what I call a given chest, but if you call it something different than our database is going to be in trouble. This can be avoided to some degree by doing as you described with random/etc., and most people probably care most about the stuff that drops in epic/warded chests anyway, so it's not as big a deal.

It may be best to focus the research somewhat - it doesn't really affect people if a level 17 chest gives 16 more raw plat on average than a level 16 chest, or has a 10% higher chance of dropping ML: 14 vendor trash. What we could do instead is have people record their data in checklist form:

1. Tome
2. Raid loot or other important named loot
3. Seal/shard
4. Nothing

This would significantly streamline the operation without compromising much on the important information gathered. The pitfall is that importance is a subjective matter, but I think a consensus can be reached pretty easily.

[Seikojin]

Or another way to focus is to work one quest at a time and give a fixed gathering period.

I think those factors do play a big role in the loot tables as well.

Screenshots could be used for speed purposes. Anyone involved would just have to pour through that, or they could set a chat tab to only display loot pulls. But I have noticed some loot (like stuff that goes into bags) doesn't get recorded in the chat stream.

[Seikojin]

I have thought about it, and based on the feedback, I agree that if it is done, it needs specific work and individual effort and contributions to succeed.

So I am making per quest spreadsheets. The naming convention so far I am using is:
ddo_loot_table_0000_<questname>

Inside it has very few columns.
Char Lvl Time Party size Bonus Chest Item Ransack

Char = character name
Lvl = Your level breakdown (1/2/3 - monk/fighter/bard format)
Time = When you went to click on the chest (opening is the trigger)
Party Size = How many players and npcs are in your group.
Bonus = Total of any and all loot bonuses you have
Chest = Type (Standard, Named, Optional, Warded, Raid)
Item = The item pulled. If it is a stack, list it all in one entry. It is per item in the chest, not overall (do not add all the plat and gold together for the entry).
Ransack = If ransacked, which ransack time (qst, 2nd, 3rd, etc.).

I thought about the whole tool thing and I am thinking of making a web entrypoint for the sheets where you select the quest, enter the Char, Lvl, Time, Party Size, and Bonus and just copy/paste the entries, but items not making it to the chat log ruins that.

So I will just make the format and hope people contribute.

[Seikojin]

https://spreadsheets.google.com/ccc?...thkey=CNm7k6MO

That is a spreadsheet template for people to copy. I will be adding them to this topic for each quest. Then siglink this topic for people to particpate in.

[somenewnoob]

I wish you well with this, a lot of work, but would be very useful if done.