Item conversion to Materia data

I wanted to try to make a Item to Materia database.

Since it's user input data the data could get false information but wanted to try this out if anyone else is interested.

I have created a form which you can fill out with item you used to convert to materia and what materia it produced from those data it will make a searchable list/date with filters so you can see the end results.

Only problem with this one is the item names have to be entered correctly, if they are miss spelled they will be considered as another line of item/data so has to be corrected by me or anyone else that may want to help with this project.

Please help add materia data by filling out this form: https://docs.google.com/spreadsheet/...l2OGc6MQ#gid=4

Results will show up here: https://docs.google.com/spreadsheet/ccc?key=0Aj_Bjog66ddldGM0UmFsTU5lYnFGczBiU3lOTll2OGc&hl=en_US#gid=6

Other materia information can be viewed on the first tab/sheet (on the spreadsheet the tab/sheet is on bottom left) - Used data provided by Alderton (from this thread) and other website data I found online to make the information. LINK

If you have a website and want to help with this project you can embed the form by using the code below also :)

HTML Code:

---

<iframe  src="https://docs.google.com/spreadsheet/embeddedform?formkey=dGM0UmFsTU5lYnFGczBiU3lOTll2OGc6MQ"  width="760" height="695" frameborder="0" marginheight="0"  marginwidth="0">Loading...</iframe>

---

Might be fun project for some people while it will help others looking for information :)

ill contribute to this as i do more

You sir deserve a cookie!


...no seriously, this is great stuff!

I'll contribute if my Spirit Bond ever gets maxed out.. A full week and I havent maxed a single piece ~.~`

Updated the form to include the stat+ on the materia name - might be easier for some? I needed something so I can look up the JP materia name to match it to English one to add my data I obtained from various sites lol

Now if there was easier way to find out English item names from JP item names instead of going to JP version ZAM or YG and after getting item changing language every damn time.....

added to my LS site

http://www.abaddon.us/phpBB3/materia_form.php

Starting to get some data :) should start picking up.
Thanks for everyone contributing!

After spiritbonding about ~200 pieces of gear, I think it's safe to say that all materia is 100% random.

It really doesn't matter which piece of gear it is or what slot it's in, the chance of obtaining any certain materia is the same for all gear across the board. The only difference is tiers, which seem to be related to the gear level.

Attribute materia is by far the most common, while Healer's Hand is likely the rarest of all (I've never made a single one).

Cool thanks for adding this

Quote:

---

Originally Posted by MeowyWowie

The only difference is tiers, which seem to be related to the gear level.

---

Somewhat, I've made tier 1s from level 40+ gear. I believe there is just a better chance that you'll get a higher grade materia from better gear. But, collecting this data is the only way to make an truly educated guess.

Quote:

---

Originally Posted by MeowyWowie

After spiritbonding about ~200 pieces of gear, I think it's safe to say that all materia is 100% random.

It really doesn't matter which piece of gear it is or what slot it's in, the chance of obtaining any certain materia is the same for all gear across the board. The only difference is tiers, which seem to be related to the gear level.

Attribute materia is by far the most common, while Healer's Hand is likely the rarest of all (I've never made a single one).

---

Might not be for everything, I noticed Belts are random but looking at some data (still only few in there) like gatherer or crafters tools seems to be focused on materia that benefits those class. Still too early though :p

I would highly suggest adding a column for the rank of the gear converted, as that has been seen to influence the grade of materia.

Nice one op! ( ^.^)b

Quote:

---

Originally Posted by Duuude007

I would highly suggest adding a column for the rank of the gear converted, as that has been seen to influence the grade of materia.

---

you can get that info by cross referencing this list with the gear on say mooglebox.com or yg.com

Quote:

---

Originally Posted by Molly_Millions

Somewhat, I've made tier 1s from level 40+ gear. I believe there is just a better chance that you'll get a higher grade materia from better gear. But, collecting this data is the only way to make an truly educated guess.

---

Not really what I meant, but yea, I only SB on lv41+ gear, and you can get any and every tier from them. However, I'm told that you can not obtain t4 materia from lv40- gear, or t3 materia from lv30- gear and so on. This is something I have not confirmed myself though, and I don't plan on it (have mats for 700~ pieces of lv41+ gear stockpiled).

Quote:

---

Originally Posted by Reinheart

Might not be for everything, I noticed Belts are random but looking at some data (still only few in there) like gatherer or crafters tools seems to be focused on materia that benefits those class. Still too early though :p

---

This is something else I have not tested myself, but apparently crafting materia can only be obtained from crafting tools. So this would be an exception to the rest. Personally, I have never seen any crafting materia come from armor or weapons, even if the armor suits/favors DoH/DoL classes only.

too bad the data doesn't get sorted automatically, i just sorted it out by tier > name so should be easier to view for now until we get more data then I have to apply the sort again since it doesn't do it automatically :(

I've broken down six DoL tools,, ten DoH tools and I *think* 13 DoL and DoH armor. Thus far in those attempts, DoL tools are the only items that give gatherer stats, and DoH tools give crafting stats on a regular basis. The armors themselves gave your standard mainstay materia, such as Mind, Dexterity, etc., with an occasional 'chocobo down' thrown in or something. Granted, this is a small sampling.

Thanks for the poll Reinhart, should help the community get a better idea on what becomes what!

Quote:

---

Originally Posted by GamerEscapeInterview

Yoshida: First of all, it is not random. There is a table we have with each item in it and that item will have a possibility of turning into one of these. That table is currently a secret, but we’re going to be releasing it very soon so players will know what items will turn into what Materia.

---

Link: http://ffxiv.gamerescape.com/2011/10...-is-out-there/

So there is a pattern/table :) so collecting data wouldn't be a bad thing after all :)

Again thanks to everyone contributing info!

I just added some of mine. Some of them are exactly the same item, same type and same tier of materia... They are not mistaken... I do get exactly the same materia. In fact, it's 2 or 3 in row. That made me suspect about day and hour's elemental thing... but it shouldn't be a factor

awwww somehow the result google doc is mess up :(
So hard to read now

just as a thought, people should probably be including the gears condition in the data submitted.

i.e tarred leather belt 19% condition ect

If you want MND or STR materia, electrum rings are your friends.

Quote:

---

Originally Posted by Secret_Reeve

just as a thought, people should probably be including the gears condition in the data submitted.

i.e tarred leather belt 19% condition ect

---

Condition doesn't affect outcome, confirmed by SE already.

Dunno what happened but the row header shows all the results now tried to delete the widget and make another one but it's doing it again.. dunno if its widgets problem or certain data that was submitted from the form causing it.... been trying different stuff and sent error report on the widget to see if they seen similar error. No response yet on that one.

Sorry for bringing up old thread back but since some people still using this one although there might be better ones...

semi-solved the issue where the filter titles on top was being affected with some data from column D "Notes" so I took that part out on the first sheet for easier viewing for now. Trying to figure out which data in the Notes column causes the titles to mess up.

<3 Reinheart
Need to give you some community award or something :D
/offer cookies

Though I'm not sure how necessary this list is anymore now that we've got the official one. I mean unless this is also recording magnitude of materia created from a specific item.