Excel Skill Spreedsheet

[Kylar_Stern]

Hey guys,

I used to do all this in a notebook, but it's become a little full of information. I made this at work today just goofing off. Lol, go work! Anyways I hope some of you might like it.

Under the Current Template to the right, it has a block for 7 skills, but it should be pretty easy to figure out how I did that if you want to add more or remove. But there must be a skill in every block for the formulas to work.

Oh yeah the skills aren't really in any type of order, so if you want to rearrange them that's cool too.

Edited: 1/27/2013 ***Modified the spreedsheet!, It's not completly done yet, but there are now new sheets on the bottom where you can add in the effects of your equipped gear! I will now work on getting the bonuses from skills added aswell. Any notes that you have please let me know.

Updated: 1/29/2013 ***Added a couple modifiers, as well as a new tab for gear that adds to skills. At this moment only write in boxes that are filled with the orangeish color.***

Final Release!!!!!!!!!! So I believe that I have this complete! I have combed thoroughly through uoguide.com getting information from every skill! I have put in every formula and I think that this is the Version 1.0. Please please let me know if it works. I used some of my information to test. Thanks in advance!

[attachment deleted by admin]

[Kylar_Stern]

Has anyone had a problem getting this file to open?

[Wolfman]

opens fine!

[Hoffs]

Thanks for posting.

[Kelden]

Now, add items and mods so you can play with that in it

[Tangar]

fun!

thanks for a usefull thing =)

[Kylar_Stern]

Lol, I was thinking about adding in all the properties you can use. Plus the bonuses given from skill points. It's just a little rough draft at the moment.

Glad I could do something useful.

[Kylar_Stern]

Updated...

[Kylar_Stern]

Indepth Mathmatics?! So I am just curious if anyone knows the math for Intelligence to Mana and Dexterity to Stamina? I know Strength to Hit Points is (STR / 2 + 50) "Rounded Down". Also any Racial Bonuses other than Humans getting 60 Extra Stones to carry? I haven't gone through all the skills yet, but I have most of them. This spreedsheet is going to be a monster! I forgot how much I loved programming and even UO.

Updated the download...

I just wanted to say thanks for being my guinea pigs.

[UncleSham]

sorry i cant read excel so i cant comment on your spreadsheet , but humans get "jack of all trades" which is the equivalent of 20 in each skill . not real , it doesnt stack , but if you really have less than 20 it works like 20.

other than joat and the weight thing i dont think humans get any other race bonuses .

[Kylar_Stern]

Version 1.0 Release!