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
  3. Greetings Guest, Having Login Issues? Check this thread!
    Dismiss Notice
  4. Hail Guest!,
    Please take a moment to read this post reminding you all of the importance of Account Security.
    Dismiss Notice

Anyone knows of a good Template Builder/Spreadsheet ?

Discussion in 'UO Warrior' started by popps, Apr 14, 2019.

  1. popps

    popps Always Present
    Stratics Veteran Stratics Legend

    Joined:
    Feb 27, 2004
    Messages:
    13,630
    Likes Received:
    489
    "Planning" for a Template in Ultima Online with all of the modifiers, buffs and variables has never been an easy task but now, with the TONS of artifacts, city buffs and all that type of stuff which can affect the planning and the making of a Template, it looks like an almost unsurmountable task....

    Is there, out there, a resource good for the planning of a character that one could use for the planning of a Template ?

    Ideally, I would imagine, what could be very usefull would be a comprehensive database of all in-game items that one could filter by modifier or combination of modifiers, thus being able to put them together and see what "missing pieces" they would need to "fill in" in order to reach the wanted results...

    I often see on the Forums, in posts, people posting spreadsheets with their suits, weapons etc.

    Since often Stratics hosts Resources for Ultima Online, I thought that also one for Templates planning and building could have been hosted but other then something for imbuing, I could not locate any Template Planner/Builder or Spreadsheet that UO players could use to help them out in planning and building their Templates in Ultima Online.

    Anyone knows of any such resource that could be very much helpfull to UO players as available ?
     
  2. Lord GOD(GOD)

    Lord GOD(GOD) Slightly Crazed

    Joined:
    Dec 7, 2014
    Messages:
    1,423
    Likes Received:
    468
    No, everyone just makes their own, it's really not difficult.

    For example, how I do it:
    I have the armour slot down the side; head, neck, chest, legs/kilt, arms, gloves, talisman, apron, back, ring, brace, left hand, right hand, sash, robe, feet, racial, town bonus...

    And the properties that matter across the top; phys/fire/cold/poison/energy, lrc/di, lmc, mr, hci/sdi, dci, casting/stam increase, hp increase, and at the end I write in skill increases and stats as I use another smaller table underneath for calculating base stats to know what I'll have in the suit.

    Under the main table you have totals along the bottom. I put lrc/di, and hci/sdi as column heads because it's rare to be using both on a character (though if that is required it's a simple case of changing the headings), as you know whether you're making a dexxer or caster it isn't hard to tell. When finished I copy the whole thing underneath for a specificcharacter then blank out the one above ready for next time.

    You can search artifacts on various sites including this one and uoguide, and find them via in game vendor search. You could also easily compile your own list spaced out in the same format as your spreadsheet so you can just copy/paste them in as needed. It isn't necessary to list all of them as most of them are not useful. You could also hop on test and catalogue them that way as they all appear in your bank after the give arties command.

    The table for stats has str, int, dex, down the side. The next column blank with a total underneath. You then have a column for stat increase from items. Then a column for the str to hp calculation, so here you would use the str after increase cell, divided by 2, plus 50. That is how hp is worked out. Then you have another column for the derrived stat increases hp, mana, stam. Now whatever value you type in the first column will give you the final result in the last column and you won't go over because you have a total underneath the first column and know what stat scroll your character has eaten. If you have a hard time working out what's remaining you can even do another sum under the total that is your stat cap minus the total. This will show what's remaining. Doing it this way means you can see exactly what base (naked) stats you should set. Stats are extremely easy to adjust and can be macrod to the right levels within 15 minutes.
     
  3. kaio

    kaio Lore Keeper
    Stratics Veteran Stratics Legend

    Joined:
    Dec 2, 2008
    Messages:
    989
    Likes Received:
    328
    Imho it's not complicated, just use notepad and the resist/imbue tools on knuckleheads website.