ScriptUO
Ultima Online Fan Board => UO Reference Information => Topic started by: Ultima on April 23, 2011, 09:56:24 PM
-
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.
-
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.
-
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
-
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?
-
Yea i did bro
-
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. ;)
-
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
-
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!
-
An Corp my own thread! Ahah! :P 8)
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.*
-
An Corp my own thread! Ahah! :P 8)
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
-
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.
-
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..
-
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
-
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.
-
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.
-
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.
Spreadsheet II Class starts in a few weeks and hopefully I'll start getting into some of the tabs. I'd jump ahead but I have other classes I need to stay on top of right now before I get too far ahead of myself.
The tabs is something I will probably incorporate with an optional "Custom Tab". For the high end suits there really aren't that many choices for many of the pieces. Head Piece on a Samurai is going to be M&S, Custom or maybe Folded Steele. Same thing with the belt (Crimson or Tangle). Cloak (Ranger or Shadow Cloak of Rejuvenation). I don't forsee adding useless artifacts only the high end for the best mage and warrior suits. This is ScriptUO after all...spreadsheet is designed to help people who know what they're doing and know UO. ;)
Incorporating what resists you need for the remaining pieces is something I need to wrap my head around and whether or not I'd like to see added in. Adding in the average resist needed per remaining piece could be pretty easy but as far as the added bonus it depends on whether your enhancing on the front end or back up. That could be an option too...
I'll tinker with it more in the coming weeks.
-
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.
Personally I like it and Zolaf has added a "simplified" option to hide all ingredients and prices in the new 9.0 version. I don't know if she is intending on making it on one page for others or not, but I'm sure you could easily modify it by adding one sheet to include everything by linking...
-
This is what I use to track down and build suit. This was before imbuing and still work great for me.
Instruction
1) Enter all the information you required under the LIST
2) Go over SUIT, input the number require for each items.
3)) go to Total Armor to view your suit. ( Page have been lock to prevent overwriting formula).
Enjoy