Hello fellow hunters i have been working on a database the last week and its nearing completion so i am going to release it to the public. So far i have made it in excel 2007 and it includes all lvl 70 blue/epic drops for hunters and some basic combat ratings information. Looking to include in later version: loot sorted by dungeons, pet listing (abilities/location to get them) and keep it updated with new released contents.

Would really love any kind of feedback/suggestions so i can improve it even further.

Well here is the link to both versions:
2003 or lower excel: hunter database 2003 (version 2.3)
http://files.filefront.com/Hunter_Database2003v23xls/;7680154;/fileinfo.html

2007 excel: hunter database (version 2.3)
http://files.filefront.com/Hunter_Database2007v23xlsx/;7680072;/fileinfo.html

Google Spreadsheet (version 2.3)
http://spreadsheets.google.com/pub?key=p6pOsc2x646UmquIPpZA6KA

wow, nice work.

Dont have exel on my home PC :(

College PCs have blocked wow-europe :\

can you add at top of colums description like agi/sta ... and so on ? (looking at 2003 version)
from my pov that is missing to be perfect.

---

Q u o t e:
can you add at top of colums description like agi/sta ... and so on ? (looking at 2003 version)
from my pov that is missing to be perfect.

---

It's there, hidden :)

Enlarge line #1 and u'll get it.

For the OP : nice work mate !

working as intended ? ^^


many thanks for this.
now it is perfect. :)

heheh yeah its hidden in 2007 since it has that in the header that scrolls down with u when u scroll down :P didnt know that wouldnt work in 2003 but yeah just unhide line nr1 ;) thanks for the nice replies should have an updated version with dungeon loot list on sunday.

Also i would love to add the rare elite drops with random enchants but i am missing the 'of the bandit' enchant numbers for them and cant find them on the web anywhere :( so if someone finds one of the blue/epix of the bandit would love it if they could pm/post here with exact name/stats/droplocation so i can add them in as well :)

This is a nice database indeed, thank you for the work you must have put into it.

Two of the items with 'of the bandit' linked here.

Felstone Epaulets of the Bandit: +24 Agility, +36 Stamina, +48 Attack Power
http://www.wowhead.com/?item=31160
Dropped from Morcrush, level 68 rare elite in Blade's Edge http://www.wowhead.com/?npc=18690

Crocolisk Scale Wristguards of the Bandit: +15 Agility, +23 Stamina, +31 Attack Power
http://www.wowhead.com/?item=31189
Dropped from Goretooth, 65 rare elite in Nagrand http://www.wowhead.com/?npc=17144

thanks for that graak found all the other random enchanted rare elite drops on wowhead too now.

So new versions are up v2.1 some minor fixes and unhidden first bar for the 2003 version. Added all the random enchant blue/epix and fixed all hyperlinks. Working on adding the dungeondroplist now.

http://hosted.filefront.com/Lieneera/1929202

enjoy :)

This needs a sticky!

hehe yeah a sticky would be lovely :D

Nice work! Reported for Sticky :)

Very nice work mate...thx

WTB Sticky

Good work! Very handy.

If you have a Google account (for gmail and such), you can upload you excel database at spreadsheets.google.com. There’s a function to share files for public. That way people can watch the database online, so no need to download and/or having excel installed on your computer. Also it’s much easier to keep the database updated without having to download new versions every week.

Example of an online spreadsheets: http://spreadsheets.google.com/pub?key=p6UcP0O3j_SR93lQf0_yuXA&gid=1 (Gems & Sockets, all types)

wow amazing job there.thnx so much about this database.keep up the good work m8.

weee thanks for the sticky guys ;) still working hard on it and wondering if i should add leather ap/crit stuff as well seeing as we can equip it :P also uploaded it to google spreadsheats thingy now

http://spreadsheets.google.com/pub?key=p6pOsc2x646UgD5OwgZ_pSQ&gid=0

so u can view it offline too though somehow the headers dont scroll down with ya even though i enabled that and worked fine during editing it online.....

nxt update should be thursday and let me know if i should add leather drops or not :D

---

Q u o t e:
weee thanks for the sticky guys ;) still working hard on it and wondering if i should add leather ap/crit stuff as well seeing as we can equip it :P also uploaded it to google spreadsheats thingy now

http://spreadsheets.google.com/pub?key=p6pOsc2x646UgD5OwgZ_pSQ&gid=0

so u can view it offline too though somehow the headers dont scroll down with ya even though i enabled that and worked fine during editing it online.....

nxt update should be thursday and let me know if i should add leather drops or not :D

---

First, thanks for the upload on google spreadsheets! I also downloaded the original spreadsheet, and I noticed you had applied 10% more RAP talent on every item. Yesterday I respecced to survival, and don’t have that talent anymore. At the moment I’m more interested in how much extra agility I get from an item with Lightning Reflexes. Is it possible to add an extra sheet with INPUT, where you can fill in your AP increasing talents such as Carefull Aim, Combat Experience, Master Marksman and Lightning Reflexes (did I forget any?).

Nice work :D

Hey Lientje,

I have made a quick example how you can inplant the talents into the database. The link to my edited excel sheet can be found here: http://www.wikiupload.com/download_page.php?id=116578

I have deleted all the other sheets and only applied it on "Full Item List" as an example. You can fill in your talents in the pink colored cells at the first sheet (called 'Talents'). They will be calculated through the items.

I have made the fill-in cells by 'Data' -> 'Valideren' (dutch version, it's probably called 'valid' in the default/english version).

Hope you find it usefull. If not, I'll just have to make my own version =).

Yeah figured it out on my own with a test database so i couldnt accidently screw up the real one ;) its implemented now on the talent tab. After filling in ur talents it will automaticly update all AP/crit% on every item.