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

Help me test my suit builder (yet another spreadsheet)

Discussion in 'UO Craftsman' started by Fusilli Zaitsev, Nov 3, 2014.

  1. Fusilli Zaitsev

    Fusilli Zaitsev Journeyman

    Oct 13, 2014
    Likes Received:
    There are a ton of great tools for imbuing/suit building, and in the month that I've spent back in UO (a ten year absence!) I've made extensive use of many of them. The knuckleheads calculators and this forum in particular have proven to be very helpful to me as I try to get a grasp on the numerous changes to the items in the game that have been implemented since I left.

    However, I'm a fairly particular person. Juggling multiple windows and tabs to build a suit (craft/imbue/enhance/tally resists and item properties) was too cumbersome for my tastes. So I made a spreadsheet that crams as much of that stuff into one sheet as possible.

    On the front page you have selections for all weapons, all suit types, all head slot items, and all shields. All item totals are tallied at the right and, should you wish to imbue properties, each equipment slot is weighted at the bottom. After the initial refinement I'm hoping that this post will bring (feedback, criticism, suggestions, bugs), I will implement full artifact support. Zolaf's imbuing tool, which I just found yesterday, does everything else I'd hoped to do with this document in terms of shopping lists, so I'll leave this document be unless something striking comes up.

    Feedback I'm looking for:
    • Factual Errors: is a stat listed on the spreadsheet simply not true?
    • Bugs: doing X breaks Y
    • Usability: this feature is cumbersome, try approaching it from the following angle
    • Spreadsheet wizardy: this document relies on mathematical functions in cells that are easily deleted, breaking major features in the process. There has to be a better way to implement many of these features, but I don't have the know-how.
    • New Features: something that isn't covered for the process of suit building, but ought to be.
    Important information:
    • Make two local copies of this file if you want to help test it. I'm not kidding when I say it breaks easily!
    • Enable Google Scripts and use the custom clear function. The script does nothing but clear certain cells while preserving the mathematical functions underneath.
    • When in doubt, try clearing enhancements before deleting cell content. Most of the sheet can be reset through this function. As a rule of thumb, don't physically edit anything in an enhancement column but instead rely on the selections available at the top of each column.
    Public comments have been enabled to facilitate feedback.

    Lastly, thanks for your help!

    Damascus Ironworks Suit Builder

    • The wrong clear function script was included when I initially posted. That has been fixed.
    • Fixed some enhancements that were not displaying properly in the weapon and shield columns.
    • "Froze" the headers for easier access to enhancements/armor and weapon selections.
    #1 Fusilli Zaitsev, Nov 3, 2014
    Last edited: Nov 3, 2014
  2. OvenBird

    OvenBird Journeyman
    Stratics Veteran

    May 12, 2011
    Likes Received:
    I'll re-iterate that making a local copy is the only way to view the drop down lists, etc.