1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Greetings Guest!!

    In order to combat SPAM on the forums, all users are required to have a minimum of 2 posts before they can submit links in any post or thread.

    Dismiss Notice

Spreadsheet for imbuing armor

Discussion in 'UO Warrior' started by JJMcClure, Jul 28, 2010.

  1. JJMcClure

    JJMcClure Journeyman
    Stratics Veteran

    Joined:
    Mar 6, 2006
    Messages:
    112
    Likes Received:
    0
    Does anyone have the spreadsheet that people are using to imbu there armor? I tried to make one myself but I dont know how to use Excel.
     
  2. Thunderz

    Thunderz Certifiable
    Stratics Veteran

    Joined:
    Jun 3, 2008
    Messages:
    1,729
    Likes Received:
    64
    Why need a spread sheet? I made my suite without one on good old pen and paper ;)

    If you dont know how to use Excel a spread sheet is useless as you wont know how to use it!


    Thunderz
     
  3. I'm not sure if this is what you are asking for, but there are at least two imbuing calculators available on websites. I've used these and found it just as easy to check the difficulty of each property on whatever I want to imbue BEFORE imbuing anything, write down the difficulty and ingredients for each. Then I start with the most expensive (i.e., relic fragments) and then the most difficult. It's pretty easy to do once you figure out a method that works for you.


    Imbuing calculators
    http://www.knuckleheads.dk/imbuecalc.php
    http://personal.inet.fi/cool/imagess/Imbu/imbu/imbu.html

    Anyone have any others they use?
     
  4. Picus at the office

    Picus at the office Certifiable
    Stratics Veteran

    Joined:
    Nov 24, 2009
    Messages:
    1,686
    Likes Received:
    583
    build 5(or more) lines to show:
    phys:
    fire:
    cold:
    poison:
    energy:

    Then in the lines beside them have your armor piece with its weighting on resist so:
    phys 10
    fire 9
    cold 12
    poison 9
    energy 13

    Add this on the last line (should be the 7th) =sum() inside the () you list the lines you want it to add up so if your using A1-A6 do that. I can't think of how to explain it but that is exactly what I do to add up the pieces for my suits. I also include lines for mana regen, hpi, stam, lmc and anything else I fancy. You can also have the final line to equal(example is for a fire resist on a sampire suit) =95-sum() and this would take the extra fire needed for a sampire suit.

    It is easy to use once you figure out the basic commands.
     
  5. silent

    silent Lore Master
    Stratics Veteran

    Joined:
    May 12, 2008
    Messages:
    1,082
    Likes Received:
    186
    I think the OP is looking for a spreadsheet to calculate imbuing weight.
     
  6. Picus at the office

    Picus at the office Certifiable
    Stratics Veteran

    Joined:
    Nov 24, 2009
    Messages:
    1,686
    Likes Received:
    583
    Still it is very handy to build a sheet for each suit one is building now that you can mod to a specific level. Since imbuing came out and I started making a new calculation for each suit they have become more and more godly....time shall tell though.
     
  7. [JD]

    [JD] Guest

    I made an excel spreadsheet where I could plug in values and see what my stats/resists/skills would be. I don't know how to upload it here to you though. If you pm me with an address I will email it to you
     
  8. [JD]

    [JD] Guest

    Does anyone have a calc which will let you exceed 100% intensity on properties?

    I made some 29 fire resist red dragon armor and I want to add 8 lmc, 18 cold, 8 sta, and some other properties and see how much, intensity wise, I can put on there before I actually waste POF and imbuing ingredients.

    Unfortunately most the calcs I've seen cap out at 15 or 19 fire resist. I don't wanna spend hours farming for special ingredients on test, either.
     
  9. JJMcClure

    JJMcClure Journeyman
    Stratics Veteran

    Joined:
    Mar 6, 2006
    Messages:
    112
    Likes Received:
    0
    @Picus at the office: Thank you for explaining that. With that info i was able to build a basic spreadsheet that totals my resists from all the pieces.

    Im actually looking for a spreadsheet that I can put the properties of my armor/jewels/weapon and it spits out the totals. Like total for all the resists and such. I have made a basic one but its really sloppy.
     
  10. Picus at the office

    Picus at the office Certifiable
    Stratics Veteran

    Joined:
    Nov 24, 2009
    Messages:
    1,686
    Likes Received:
    583
    This is what mine does but it makes do with the =sum(). For each char I make I just keep adding lines when I find a need a new one. I was making a suit for a faction mage so I added in the faction orni to take into account of the lmc/lrc/mana regen and energy resist....you can add as many lines as you want. More often than not you will just need to do this for the suit/jewels as the options on weapons are specific to that class of items and you won't use a slot for FC or HCI.

    I also add a final like which is =70-line(A4 or what ever) where total resist is added up this is to so show how much resist I need to get to 70's. You can also do =70-line/number of armor pieces left, this I found very useful because often I have just had to grind out horned/barbed pieces untill it fell in the right spot leaving 5 spots to imbue....yummy.