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

My spreadsheet calculator for suits, templates, ssi

Discussion in 'UHall' started by controlfive, Oct 16, 2009.

  1. controlfive

    controlfive Guest

    Making this was strangley fun, so I ended up developing it enough that some of you might get some use out of it. Some screenshots of each sheet in action:

    [​IMG]
    [​IMG]
    [​IMG]


    The first sheet totals up your mods, shows the difference between your values and the caps, and shows your stat totals after you input your base stats and your suit.

    The second sheet is pretty simple, just a way to organize your template. Totals up the three columns: real skill, skill from items, and both real skill + items together.

    The third sheet calculates your attack speed after you input your weapon speed, stam, and ssi. I made sure that the ticks rounded down to whole numbers and that 1.25 was the minimum attack speed value on this.


    Download Links:
    (New!) http://www.megaupload.com/?d=DI77TUMD
    (Old!) http://www.megaupload.com/?d=TIK2C1OT
     
  2. HeathBar

    HeathBar Guest

    It looks great but may I suggest you put it on Google docs instead of hosting it on your current site? I'm a little weary of downloading things off unknown websites.
     
  3. Lynk

    Lynk Grand Poobah
    Stratics Veteran

    Joined:
    May 13, 2008
    Messages:
    6,032
    Likes Received:
    145
    Unless it's adult rated video clips!
     
  4. controlfive

    controlfive Guest

  5. Lynk

    Lynk Grand Poobah
    Stratics Veteran

    Joined:
    May 13, 2008
    Messages:
    6,032
    Likes Received:
    145
    If only there was a legal way to scan your character data, import it into the spreadsheet, and then have the spreadsheet perform the calculations on what you need on the rest of your gear to hit your desired stats/skills/lmc/lrc/etc.
     
  6. Flutter

    Flutter Always Present
    Stratics Veteran Alumni Stratics Legend

    Joined:
    May 12, 2004
    Messages:
    21,553
    Likes Received:
    3,840
    /sign

    And Lynk your sig is too small. Make it more manly.
     
  7. Lynk

    Lynk Grand Poobah
    Stratics Veteran

    Joined:
    May 13, 2008
    Messages:
    6,032
    Likes Received:
    145
    I'm horrible with Paint. In fact I need to get new screenshots tonight for the new sig.

    If anyone is good with sigs please message me :(
     
  8. popps

    popps Always Present
    Stratics Veteran Stratics Legend

    Joined:
    Feb 27, 2004
    Messages:
    13,445
    Likes Received:
    461


    UOAssist could help, perhaps ?
     
  9. Beer_Cayse

    Beer_Cayse Guest

    looks slick, however I (and some others) have Office 2003. It appears you used Office 2007 - Excel 2003 barf on the conversion (even with the MS conversion pack) due to some cells apparently having more than 3 levels of conditional formatting. <shrug>

    I'm going to work with it and see what - if anything - might have broken in the conversion.
     
  10. controlfive

    controlfive Guest

    My bad, I don't have any experience with compatibility between 03 and 07, but judging by how it looks on google docs (which I guess is 03), it looks to be quite a bit different.

    I don't think I have more than 3 conditional formatting on any cells, but I could be wrong.

    There should be 2 on the bulk of the first sheet (C2:X30). Negative numbers get a light red background with a black border and positives get a light green background with a black border.

    There should be one on the total column cells that give the cell a green/green highlight when the total reaches the cap.

    There's 3 on the Difference column cells. One that makes the text greyed if the difference is equal to the cap*(-1), one that makes the text red if it's any other negative number, and one that makes the text green if it's >0.

    I didn't use any conditional formatting on the stats area or the other two sheets.

    Feel free to reup for the other 03ers if you can make it look presentable :p
     
  11. TheGhostRaider

    TheGhostRaider Journeyman
    Stratics Veteran

    Joined:
    May 25, 2008
    Messages:
    148
    Likes Received:
    2
    just download the ExcelViewer, from Microsoft. it free. No need to convert your document, just save then as 03 document instead. I have made up a spreadsheet to calculated the armor value and skill. this way Ic an build suit on paper. t help me make the pieces that I needs. Nice work on this one. I will give it a try.
     
  12. controlfive

    controlfive Guest

    Bumping once more for an update in case anybody uses this, lol. I just added sheets for two extra suits and a sheet that imports all of the totals from the three suits to compare them side by side. I also added a graph for luck that lets you toggle whether or not you're using a luck statue and adds your luck statue bonus to the graph after you input your account age.

    Screenshot:

    [​IMG]

    Download Link: http://www.megaupload.com/?d=DI77TUMD