Hello. I have created an excel-based imbue calculator. I was intending this to be a gift to UO, but because of access issues I have decided to post the following instead: Functions: 1997-2003 OR 2007 versions available. Drop down menu's for +skill, weapon speed, and armor type. Calculates intensities of Jewelry, Armor, Weapons, and Shields. Default Artifacts have been preloaded for easy use. Totals imbued properties (allows for non-imbued items to be added in). Tabulates necessary imbuing ingredients (assuming 100% success rate). All pages show the total mods for the suit for easy use. Runic kits for armor is now available by denoting "Text ##" instead of "##" under the crafted column. This should only be done for those resist that take up 1 of your 5 imbued mods. Upon errors, highlights cells in RED. For those who wish to accept the file download via icq or through email, contact me at ICQ: 275-149-026 or email: minermika@yahoo.com. Note that I would prefer you download it at the link provided! Please send this to your friends! I want everyone to be able to use it. Consider it a holiday gift. If errors are found, please let me know and I will post that it has been updated on this site. -Zolaf from Catskills P.S. The mana/life leech equations are based on only 25 weapons. Currently seems to be working. Let me know if you find a problem.
Zolaf really spent a lot of time on this. I am impressed! Thanks! I am still testing it out, but so far, I couldn't ask for a better calculator. It is smart enough to know how other properties affect each other (SSI and Leeches) and tells you a summary of the ingredients you will need to make the items. I'm sure it is a work in progress, but it is a terrific start. It would be nice to see the imbuing success chances and maybe give an optimal order of imbuing so you can use the least expensive stuff last, but that is pretty easy to figure out on your own. Also, the calculator assumes the item is exceptional.
Version History: Zolafs Imbuing Calculator Version 1: 12/5/2010 First version for beta testing. Zolafs Imbuing Calculator Version 2: 12/7/2010 Modifications: a) Added gems to all (Jewelry, Weapons, and Armor) Tabs. b) Removed "Balanced" and "Velocity" mods from melee weapons. c) Fixed a few spelling errors. Zolafs Imbuing Calculator Version 3: 12/9/2010 Modifications: a) Added 5 Armor slots to cover and entire imbued suit. b) Added a Armor Total Tab to show the total mods and ingredients required for a 100% success rate. Zolafs Imbuing Calculator Version 4: 12/11/2010 Modifications: a) Converted the Jewelry Tab into two Tabs: Ring and Bracelet to imbue two jewelry sets on one excel sheet. b) Changed all mod abbreviations into spelled out words to avoid confusion. Armor Tab Modifications: c) Changed the "Armor #" Tabs to read "Helmet", "Gorget", etc to avoid confusion when trying to determine which piece of the suit you were working on. d) Added a "Crafted" column to destinguish between imbued and non-imbued to aid in determining the intensity rating. e) Added color tones to the resistances for clarity. Total Materials Tab Modifications: f) Added all the major ingredients used and alphabetized them. g) Added a "Misc" column to include non-imbued items in the total mod calculation. Zolafs Imbuing Calculator Version 5: 12/12/2010 Modifications: a) Added a Version Number to the Instructions Tab for clarity. b) Resized all the tabs to maintain the same horizontal spacing. c) Altered some conditional formatting equations so they will correctly transfer when saved as a 1997-2003 file. Zolafs Imbuing Calculator Version 6: 1/1/2011 First version widely available. Functions as follows: a) 1997-2003 OR 2007 versions available b) Drop down menu's for +skill, weapon speed, and armor type. c) Calculates intensities of Jewelry, Armor, Weapons, and Shields d) Totals imbued properties (allows for non-imbued items to be added in) e) Tabulates necessary imbuing ingredients (assuming 100% success rate) f) Upon entering an impossible combination (such as adding too many mods or over the maximum intensity) the cells are highlighted in RED. Modifications from version 5.0: g) Added a Shield Tab. h) Corrected the armor major ingredient for resistances from magical Residue to Enchanted Essence. i) Added a non-imbued tab to total all non-imbued items for clarity rather than a single column on the totals page. j) Corrected some word spacing issues. k) Added imbuing major ingredients needed for the Shield Tab to the Totals Tab. Zolafs Imbuing Calculator Version 6.1: 1/29/2011 Modifications for the Weapons tab: a) Corrected an error using Enchanted Essence for all minor slayers (only for Blood and Dragon Slayers) b) Corrected the Velocity Intensity equation modified to exclude 1-10 imbued values (not allowed in game) c) Added "Tourmaline" to the Velocity gem ingredients list Modifications for the Armor Tab: a) Added maximum resists for different types of gargish armor (instead of just "gargish armor") b) Added maximum intensity differences between "exceptional" and "non-exceptional" Zolafs Imbuing Calculator Version 6.2: 2/6/2011 a) Added required powder of fortification based on the item's durability. b) Added a "Price" tab to aid in determining the imbued price for both a minimum and maximum. c) Added a % Profit and gold total (minimum and maximum) to the "Totals" tab. d) Centered the "crafted" resistances on the armor tabs. e) Updated the Instructions tab to be more self-explanitory. Zolafs Imbuing Calculator Version 6.2.1: 2/6/2011 a) Fixed an glitch when you select "leather" for human leather it gave you gargish resists. Zolafs Imbuing Calculator Version 6.3: 2/13/2011 a) Added the update history for versions 1 through 5. b) Fixed the highlighted color being incorrect for the energy resist on the Gorget Tab. c) Added a price system to the non-imbued items so you can include them in the base price before profit. d) Made it so you can adjust how many of each ingredient you have to adjust the base price before profit. e) Added a "name" row for the imbued non-imbued items for user clarity. f) Adjusted the note on the Armor Tabs to better reflect what you currently need to enter. g) Rordered the "min" and "max" columns on the Price Tab to be universal. h) Added the pof calculation to include the weapon and shield tabs. Also fixed a rounding error that was estimating the required powder of fortification incorrectly. i) Corrected the note on the weapons tab to say "life/mana leech" rather than "mana/stam" leech. j) Removed "Use Best Weapon Skill" from all ranged weapons. k) Added "Ranged (Gargoyle)" and "Melee (Gargoyle)" to the weapons tab and the necessary modifications. This is in its Beta Stage. If you should find an error please let me know. The initial assumption is the maximum intensities are the same as for non-gargoyle weapons. The mods not available have already been removed. l) "Choose Armor" type will now display as non-gray when a armor type is selected. m) Modified all tabs to not display ingredients if over the maximum allowed intensity. n) Added the mysticism skill to group 4 list for jewelry. o) Renumbered the skill group numbing to match the imbue gump. p) Added a flat rate profit option on the Totals Tab. Zolafs Imbuing Calculator Version 7.0: 4/17/2011 Note: Modified the Images in posts #2 and #3 to reflect Version 7.0. a) Added drop down spells to adjust your total resists. This enables the imbuer / imbuee to imbue a suit of armor to offset these resist differences if used. b) Added an "Artifact" Tab in order to make entering the Non-Imbue items easier. You can copy and paste the mods from this tab and paste them onto the "Non-Imbued" Tab. c) Reworded tabs as necessary to make the bottom shorter. This was necssary to see all tabs at once on the same view at the bottom (and it was annoying me…). d) Fixed an error doubling the Faery Dust amount when needed for a ring. e) Corrected some misspellings throughout (thanks Kilroy!). f) Fixed a slight error in the armor resistance intensity calculation. g) Corrected an error when Velocity of 1-10 is used. h) Added a method to you show your current total resists on each page. This makes suit building easier. Some of this required reformatting the setup for each page by removing "(Select from List)". This was added to the instructions page to avoid confusion for newer users. i) Fixed the gem and main ingredient for the dex increase on the ring and brace tabs. j) Fixed the gem and main ingredient for the intel increase on the ring and brace tabs. k) Fixed the cold resist for bandana/skullcap to 20 instead of 23. l) Made it possible to use runic kits by designating "Runic ##" or "R ##". m) Fixed the Main Ingredient for the "Mage Armor" mod on the armor tabs. n) Added more hats, gargish necklaces and earrings to armor tab drop down menus. Zolafs Imbuing Calculator Version 8.0: Modifications in Progress 3/31/2012 a) Fixed issue with max Hit/Defense Chance Increase for Ranged weapons to 25. Also fixed ingredient to include Fungi. Adjusted all amounts and prices on affected tabs. b) Instead of adding more and more artifacts, a "User Favorites" section was created on teh "Artifacts" tab. It was placed at the top, for easy access. c) Changed the "totals" tab to reflect ("Need"-"Have") rather than doing nothing when you input a value. d) Changed the armor titles if gargoyle or human is selected from the drop down menu located on th e"How To" Tab. This required adding a few more error catches. e) Added enhancing armor and shields that occur AFTER imbuing. f) Added some error trapping on misc. tabs. g) Added a crafted option to jewelry so it doesnt assume its always imbued. h) Added a cell on the "Totals" tab to reflect a maximum durability for each piece. Type "0" if you do not want to use Powder of Fortification on your suit. Zolafs Imbuing Calculator Version 8.1: Future a) [In Progress] Fix mana and life leech maximum % equations. b) You suggestions!
Zolafs Imbuing Calculator Download Location Current Version 8.0 Please download by following these steps: 1. Select the version you want and click on the follow links: 2007 Excel: http://chat.stratics.com/zolaf/Zolafs_Imbuing_Calculator_Current.xlsx *Note: The 2007 file will be a zipped folder. Right click and save target as to save the zipped folder. Then open excel 2007 and open the zipped folder. This will then allow you to override your old version (dont ask me why its this way...it just works...2007 excel is weird). 1997-2003 Excel: http://chat.stratics.com/zolaf/Zolafs_Imbuing_Calculator_Current.xls 2. Save the file to the desired location. I would reccomend a "Ultima Online" folder or just the file on your desktop for easy access. 3. If you would like to donate, please send $1 to minermika@yahoo.com on paypal (Zolaf Faloz). It would be greatly appreciated! Please Respond if you are using this calculator and like it. Let me know if you find any errors so I can continue to make it better! Special thanks goes to chat.stratics.com for allowing me to make the downlaod go through their site. TRUST ME it helps alot! Thank you! Zolaf
Gonna try this out in OpenOffice to see if it works okay. Looks awesome! edit: Works fantastic so far. No bugs yet.
Hi Zolaf, great job on the spreadsheet. I was wondering if you might be able to add craftable items, like Pendant of the Magi, Stitchers Mittens, etc? If you would like some help with that, I'd be glad to give it a shot.
I am working on this error right now, I believe I got it sorted out with the code developers... I found a slight error I need your help with guys. Ranged wep: 4.5s 45ssi I want to imbue mana leech on it. My imbue calculator uses the equation from http://www.uoguide.com/Hit_Mana_Leech of: Max Mana Imbueable = 2500 * (Base Speed) / (2 * (100 + SSI)) My weapon = 2500 * (4.5) / (2 * (100 + 45)) = 38.79 (or 38 when rounded down) However, in game it is giving me 37. Do any of you know if this equation has been changed recently? Thanks!
You are most welcome! I am working on the finishing touches for version 8.0. Next up: 1. Added enhancing option after item is imbued. 2. Made a resist tab for less flipping when getting armor resists figured out (due to multiple requests). 3. Fixed a few things with hci/dci on ranged weapons 4. A few more things...you will have to wait and see! Side note: Still have not quite fixed the mana leech issue. It seems to be only off in 1 mana leech (+ or -). Still looking into it...I am hoping to get that fixed before I release 8.1. Also...to save on space in this page (and to avoid many many pages of flipping...) I have removed most of my responses that have been addressed. I ask for those who have had their errors/suggestions fixed to please remove your own posts in order to keep the size down. This will help people find the graphics and also the downloadable post (#8 for download). Thanks!
There're some note about price calculation: 1. I can fail with imbuing and lose ingredients. I want an ability to input imbue chances. Would be even better if I've must just enter the imbuing order and let the program to calculate imbuing chances for me. Sometimes I need to imbue 3-4 mod that require relic (HCI/DCI/FC/FCR on a ring or SSI/Slayer/HCI on a weapon). Sometimes I imbue reforged (1 FC and 15 DCI on a shield with 5 HCI and 25 DI) or shame loot item (1 FC and 3 FCR on a 4 MR ring). 2. I must craft several (sometimes hundreds of armor pieces) to get the proper resists distribution. I want an ability to input chances. Would be even better if the program calculated them. This is important for woodland armor. It takes 15 barks to craft an exceptional chest and 8 barks for other items. So price of an item may be few millions. 3. Sometimes I don't want to PoF to max durability. I want an ability to input what durability I need.
Most awesome thing ever made in the history of uo... its unbelievable. Now some people just want it to do things for them cause their lazy... don't waste your time fixing that stuff... But would u consider a youtube tutorial?
I spoke with CorwinXX and will be doing some brainstorming to see if these features will be added or not. (gotta love scope creep!)
At long last. Version 8.0 is available at the same link! As always, please let me know if you find any problems. There is still a slight error in the mana leech (1 or 2 off) but I am working long hours on construction and pushed this release back far enough. I will look into it when i am back home . -Zolaf
