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
  5. Author Wes Locher has teamed up with Stratics for a giveaway of his new book Braving Britannia. This book explores the history and impact of Ultima Online and includes interviews from current and past dev team members as well as many UO and Stratics community members. Click here for more details!
    Dismiss Notice

Looking for an Excel wizard

Discussion in 'UHall' started by DJAd, Dec 7, 2014.

  1. DJAd

    DJAd Stratics Legend
    Stratics Veteran Stratics Legend

    Joined:
    Aug 17, 2007
    Messages:
    9,101
    Likes Received:
    4,589
    I have a basic Excel spreadsheet I use when crafting out my armour.

    I would like to add a column under each item that will tell me intensity of each piece.

    I have no idea on how to add this as I'm on a rookie when it comes to excel.

    If anyone could help me out please let me know.
     
  2. Gidge

    Gidge Lore Keeper
    Stratics Veteran Stratics Legend BoE

    Joined:
    Mar 18, 2004
    Messages:
    758
    Likes Received:
    233
  3. DJAd

    DJAd Stratics Legend
    Stratics Veteran Stratics Legend

    Joined:
    Aug 17, 2007
    Messages:
    9,101
    Likes Received:
    4,589
    Yeah I guess its the intensity formula thing that I need added into mine.
     
  4. Elden of Baja

    Elden of Baja Journeyman
    Stratics Veteran

    Joined:
    Apr 28, 2010
    Messages:
    261
    Likes Received:
    85
    Do you have a column for each Mod. If so, then on your formula for weight, you take The Total Weight for the max Imbue, and divide that by the number that represents the max imbue. That will give you the multiplier for the weight. so Mana Increase = 110 / 8 = 13.75. So on your spread sheet do = (Target cell ) * 13.75 And that will output the weight for the Mana Increase.
     
  5. Scribbles

    Scribbles Long Live The Players
    Stratics Veteran Alumni

    Joined:
    Mar 27, 2013
    Messages:
    3,103
    Likes Received:
    2,580
  6. Maelwyn

    Maelwyn Adventurer
    Stratics Veteran Stratics Legend

    Joined:
    Jun 10, 2008
    Messages:
    37
    Likes Received:
    3
    I can't find that skill in my skill list.