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: 7/22/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 9.0: 7/10/2013
a) Complete Redesign of Coding and Resources. To be honest I started from scratch.
b) Fixed Totals on "Resists" tab if a runic crafted resist is entered.
c) Added reforging and Magical Loot properties throughout spreadsheet.
d) Fix mana leech intensity to be correct on weapons.
e) Fixed ring and bracelet lower reagent cost and lower mana cost as they were switched.
f) Added Suit Totals to the "Wep" tab.
g) Added a Default to Armor tabs to all be the same type and quality (initially).
h) Added hci to shields.
i) Fixed an issue with gloves not whiting out on the "Non-Imbued" tab.
j) Fixed crafted resists on shield. It wasn't updating resists.
k) Added str, dex, intel to final suit (from character) on Totals Tab.
l) Fixed Resources total for Velocity on Weapons.
m) Updated enhancing resists to reflect the new values.
n) Added a "simplification" option to hide resources & price information for those who wish to only view the stats and imbuing intensities
.
o) Your suggestions!
Zolafs Imbuing Calculator Version 9.1: Future
a) % Success Chance Increase to modify Ingredient Usage (Hardcoded into 9.0 but not functional yet)
b) Your suggestions!
