Character Equipment Assessment Spreadsheet

[Ultima]

Starting toying around with Excel 2000 and put together a spreadsheet for suiting up a sampire. This is the first spreadsheet I've made after reading an online tutorial so any harsh negative feedback and you'll be drawn and quartered. I intended it to be  basic and straight forward. Simple was the main goal.

The spreadsheet can easily be edited to add/replace other desired statistics such as LRC, FC, FCR and SDI. I intended it  to be used for a sampire but can edited to asses any suit you have in mind.

As I learn more Excel I'll post some other spreadsheets. I have a few things in mind when it comes to crafting and imbuing armor.

Updated 9/6/11: Still a work in progress.

This version may only be 2010 Compatible. I'm not 100% sure their may be issues for 2003 & 2007 users.

Added Leather and Wood Armor bonuses under sheets.

[D]

soundsgood, ive been using the same idea as ive been rebuilding my sampire suite, when i get back to my desktop ill have a look.

i think its a great way to see what you need to imbue and at what intensities.

[Outlaw Josey Wales]

Not dissing on your work mate looks good just trying to figure out what info your trying to put in cause i downloaded everthing was blank

[Masscre]

Did you un compress it before you tried to use it?

Are we to enter the data we need rather than a suggested input by you ultima?

[Outlaw Josey Wales]

Yea i did bro

[Ultima]

Did you un compress it before you tried to use it?

Massacre did you get it to open? I might have done something wrong if so what's the best method to attach a .Xls file?

Are we to enter the data we need rather than a suggested input by you ultima?

Yes it's a enter your own right now...nothing fancy as I stated until I learn more. 

[Ultima]

soundsgood, ive been using the same idea as ive been rebuilding my sampire suite, when i get back to my desktop ill have a look.

i think its a great way to see what you need to imbue and at what intensities.

Mine is just a one sheet straight forward for adding up Resists and Mods. There is spreadsheet posted over as stratics that is very elaborate...too elaborate for my taste. You may want to check out:

http://vboards.stratics.com/uo-craftsman/229839-new-imbuing-calculator.html

[UOMaddog]

Oh god, if I can find my old UO spreadsheet, all of your jaws will drop!! I had 200+ templates, suits for every character/template, charts for swingspeed, charts for success/fail rate on spells, etc...it was basically stratics, combined into a workbook of excel worksheets!

[Ultima]

An Corp my own thread! Ahah!  

Cleaned up and added a few other properties.

Added Leather and Wood Armor bonuses under separate worksheets.

Still very simple and straight forward spreadsheet which is what it was meant to be.

Future options will include Tab for Vampire Embrace/Wraith/Protection to be included in the armor calculations.

*This version may only be 2010 Compatible. I'm not 100% sure their may be issues for 2003 & 2007 users.*

[Crome969]

An Corp my own thread! Ahah!  

Cleaned up and added a few other properties.

Added Leather and Wood Armor bonuses under separate worksheets.

Still very simple and straight forward spreadsheet which is what it was meant to be.

Future options will include Tab for Vampire Embrace/Wraith/Protection to be included in the armor calculations.

*This version may only be 2010 Compatible. I'm not 100% sure their may be issues for 2003 & 2007 users.*

I had started 2 Months ago for an own application to make a Charplanner like this, but then i noticed what i wanted to do is sooooo much things, so i got a bit lazy about and delayed it..
But Nice work anyways

[Ultima]

Thanks Crome969,

There are a few other features I may want to put in as I learn more features including the drop down arrows and how to link them with data. The spreadsheet has helped me numerous times when trying to make suits for myself as well as others.

Zolaf's Imbuing Calculator listed above while an impressive spreadsheet is just overkill and contains way too much information as far as I'm concerned.

Simple and to the point has been the goal.

It's saved in 2003/2007 format so I'm thinking it should for older excel program users but there may be issues with the images showing up.

[Crome969]

Thanks Crome969,

There are a few other features I may want to put in as I learn more features including the drop down arrows and how to link them with data. The spreadsheet has helped me numerous times when trying to make suits for myself as well as others.

Zolaf's Imbuing Calculator listed above while an impressive spreadsheet is just overkill and contains way too much information as far as I'm concerned.

Simple and to the point has been the goal.

It's saved in 2003/2007 format so I'm thinking it should for older excel program users but there may be issues with the images showing up.

Zolafs is a little bit unviewable in a short view..

[UOMaddog]

I've migrated my spreadsheet to google docs, I'll have to figure out the best way to share it so that people can view it and see how I did it

[Goliath]

Pull down menus to add/interchange non-crafted gear would be awesome.  I envision a low level edition sort of like the WoW Armory or something that we can use the menus to interchange gear and see that stat changes on the fly.  I too am not exactly sure how to accomplish this but if you need help entering information in some sort of a database or different spreadsheet then I would be willing to help with the task and hopefully take some of the time consuming load off your shoulders.

Let me know if there is something I can help with... In the meantime keep up the good work.  I like what I see and I also like how you are trying to keep it simple for the average users.

[Crome969]

Pull down menus to add/interchange non-crafted gear would be awesome.  I envision a low level edition sort of like the WoW Armory or something that we can use the menus to interchange gear and see that stat changes on the fly.  I too am not exactly sure how to accomplish this but if you need help entering information in some sort of a database or different spreadsheet then I would be willing to help with the task and hopefully take some of the time consuming load off your shoulders.

Let me know if there is something I can help with... In the meantime keep up the good work.  I like what I see and I also like how you are trying to keep it simple for the average users.

i had the Idea for a Character Setup with Tabs. Like you can Choose Imbue\Loot\Artifacts for each part and have a Choosing of it.Then the Charactersetup autocalculate your Propertys in Result.I had like 40% Done then i camed to the point, it wouldnt be very handy for myself if i need to update everytime osi bringing new Staff and i thought about if i really can handle the Update every time.
Since i didnt found an answer the development is delayed.