All suggestions are always welcome (except for retarded ones, naturally), though at the moment the Database is a project designed for players wanting to check which weapons will be most efficient damage dealing-wise for their characters and followers, and they have no use of proto ID. As for weapon worth, in a game where money is hardly ever an issue it would mostly be an useless filler anyway.


Hardly my fault OpenOffice's Calc cannot sort properly, I'd say.

The Database was created on Microsoft Excel and that program seems to be the only one which handles it flawlessly.


The point is moot. Most actually agree that the massive AvD/AP does not compensate for the pathetic AvD/AmU.

_________________
Where we're going, we won't need eyes to see.

Quite impressive work there. A+++, would read again, etc.

It's tempting to secretly build a PHP/MySQL version of this so I can deviously steal a glimmer of your glory.

*whistles*

I noticed the Sword of the Derian Ka has a substantial hidden bonus to damage, making this already decent weapon a significantly better one than its description suggests. Added a "Sword of the Derian Ka" section to the README part and included the bonus in the sword's damage calculating formulas in the DATABASE part.

Updated table of contents and download link in the original post.

_________________
Where we're going, we won't need eyes to see.

Noticed an error in the damage calculating formulas of the Fine Revolver.

The problem is now solved, the database updated and reuploaded. Download link can be found in the original post.

_________________
Where we're going, we won't need eyes to see.

Noticed a loophole in minimum and maximum damage calculating formulas which erroneously elevated the damage of the Axe of Lost Time and Grack's Burdensome Staff for characters combining low strength and high magickal aptitude.

Seriously, how specific can an error get?

The problem is now solved, the database updated and reuploaded. Download link can be found in the original post.

_________________
Where we're going, we won't need eyes to see.

Found a weapon I seem to have overlooked when creating the database.

The Bow of Damage has now been added to the DATABASE part.

The database is updated and reuploaded. Download link can be found in the original post.

_________________
Where we're going, we won't need eyes to see.

Im looking at the excel file but some of the numbers seem off...the shotgun doesnt have 30-60 damage ingame....neither does the hand crafted fintlock have an awe inspiring 7-29 damage ingame....

The Shotgun does 1-10 damage while the Hand Crafted Flintlock deals 2-6, and those are the numbers I placed in the database. 30-60 is the damage of the Blade Launcher while 7-29 of Bronwyck's Gun.


Most odd. I have never encountered any mismatches. No matter in what way I sort my data, the database always displays the correct values for me, and I regularly sort in in a variety of ways.

Jojobobo, Question, what programs do you use to open the database?

Also, sorting the database in what way causes it to display incorrect values in your cases?

_________________
Where we're going, we won't need eyes to see.

Just the 2010 version of excel, I don't know maybe it's something wrong with my system than the file itself. It's never bothered me just looking down the list anyway, everything else works correctly like the values adjusting for strength, etc.

_________________
The chemistry must be respected.

Excel does not always sort cells the way I anticipate, especially if I highlight specific cells to be sorted. If you select-all and sort, do you still have the problem?

_________________
My North Star: Jose Gomez
I'm an introvert. Now shut up so I can be happy. Except for you, helpful sales bot. Also, download this.
Away from The House, yet forever near to my heart

Thank you so much for this (:

Great database, are you still considering creating one for arcanum : wip or have you abandoned the idea?

The idea is pretty much abandoned for reasons various, indeed. Thanks for bumping the thread, though. It reminded me of the database and inspired me to experiment with a known problem it was having. That being said...

...in other news, after some trial and error I recently* figured out what was the problem behind sorting errors mentioned by a few members, what, 1,5 years ago? Time flows like crazy, I tell ya.
Fact: the database was created on Microsoft Excel 2003. Now, it turns out Microsoft Excel ≥ 2007 sorts data differently that earlier versions, to the point that something that worked in Excel 2003 may not work properly in Excel ≥ 2007, regardless of compatibility options.** I introduced some changes to the sorting method and now the database appears to work correctly on my Excel 2007, but I'll take my time to thoroughly test it before releasing it. Still, expect an update soon.

* Half an hour ago.

** Which I find baffling, to say the least. What if rather than a non-profit pet project it was an important spreadsheet that my company's money depended on? One would think he doesn't have to worry about such compatibility problems when upgrading software from a leading multinational software corporation.

_________________
Where we're going, we won't need eyes to see.

I was expecting a third asterisk set after that last "soon" and when it wasn't there I was sad.

_________________
There are things in this world that I dislike. One of the things I dislike the most is a serious argument, well constructed, delivered by someone who makes themselves difficult to respect.

I'd hate to make you sad, Philes. I attempted to add a third asterisk set, but instead I ended up with this.

Don't ask me, ask yourself.

_________________
Where we're going, we won't need eyes to see.

The only question I could ask myself regarding that picture probably shouldn't be posted on a public forum.

On the other side, Fronk-en-steen is just a little too happy in the picture to be preparing for murder.

_________________
There are things in this world that I dislike. One of the things I dislike the most is a serious argument, well constructed, delivered by someone who makes themselves difficult to respect.