+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 15 of 30
Like Tree2Likes

Thread: [SL] Cleric Multi-Role Gear Calculator (BiS) - Revived!

  1. #1
    Rift Chaser
    Join Date
    Dec 2010
    Posts
    332

    Default [SL] Cleric Multi-Role Gear Calculator (BiS) - Revived!

    Bowler Hat has taken a break from the game, and he has contacted me to take over maintenance of the sheets.

    For now, I have updated the gearlist. Spec calculation will be adjusted once the PTS cleric changes are finalized.

    The URLs of the sheet remains unchanged. You can still use them as they are.

    For now, I'll C/P his introduction bit over.

    ---------------------------------------

    TL;DR What's all this wall-of-text nonsense? Show me the BiS lists!

    DPS (Inquisitor) Cleric BETA 0.6.5
    DPS (Shaman) Cleric BETA 0.6.5
    HEAL Cleric BETA 0.6.5
    TANK Cleric BETA 0.6.5

    The above sheets are always built with the most current gearlist data - currently version 2.2.0

    Introduction

    I've been working on another multi-role gear selector for Storm legion. The introduction of Crit Power has made calculators based on static weights less attractive than in 1.0 so I've opted for a fully dynamic solution this time around. Crit Power weights can move quite dramatically with raid buffs, and also to a lesser extent by other stats present on your gear. Ideally you want to recalculate stat weights with every new item of gear you obtain, as well as every buff you will receive in a raid. It is also important to factor in any build talents that effect these stats, such as percentage boosts to wisdom, spellpower or crit chance. This can be quite complex, but if you set everything up correctly the calculator should exactly mirror your ingame character sheet, right down to the last Hit Point. The resulting stat weights can then be used to rank potential upgrades and sort them into a list.

    This dynamic multi-role calculator runs in Google's cloud and you will require a Google Drive account to setup your own unique copy. The solution makes extensive use of Google Apps Script (GAS) to present a User Interface (UI) allowing you to more easily manage all your builds, gear and buffs, as well as quickly sort gearlists by one of three profiles - DPS, HEAL or TANK. Because of this the spreadsheet is not designed to be downloaded and run under Excel or Open Office; the sheet itself should calculate, but you'll need to build your own sorting functions and enter data manually. If you are unable to setup a Google Drive account I have published three static snapshots you can view in a web browser. These will suit the more casual player, or those just looking for a quick reference. The more committed raider will want to take the time to setup their own version, tailored to their builds and gear of choice.

    Functional Overview

    There are two basic components to the solution - the Calculator and the Gearlists. You write data to the Calculator, and read data from the Gearlists. The Calculator stores all your builds as well as three different gear sets - one for each of three profiles; HEAL, DPS and TANK. You can have as many builds as you like, but a profile can only be linked to one build at a time. The build sheets contain the stat weight calculators, and the profile sheets contain all your gear. You can sort and highlight Gearlists from the custom menu functions.

    The menu also launches the configuration UI. You can use the UI to add gear and runes to all your equipment slots, as well as load essences and runes to up to ten planar foci. These foci can then be equipped in any profile just like any other item of gear. The UI can also automatically augment a crafted item for you; when you select a crafted item you will be prompted to select an augment and the augment will be added to the item stats. If an item you want to equip is not in the gearlist, you can select a Custom Item and manually enter the details.

    Future versions of the UI will allow you to configure all your buffs as well as help you setup and manage your builds. The UI can also be used to update the gearlists independently. This mean you don't have to muck around setting up a new version of the calculator every time I add some new drops to the gearlists. You'll see two version numbers on the Update tab, one for the calculator and the other for the gearlists. You can safely synchronise the gearlists at anytime since none of your data is stored on those sheets. The calculator will need to be updated manually, however you can import all your gear data from your old version when done.


    Raid buffs, PA stats and Conquest perks are all stored on a CONFIG sheet alongside some other static inputs. You can enter data directly in the yellow boxes and the majority of buffs are simply toggled on or off via a yes/no drop down selector. You can also quickly disable entire raid buff sections making it quick and easy to examine your stats and weights when self buffed or with no buffs at all.

    Occasionally, due to a Google bug, the custom menu won't appear when you open the spreadsheet. It can also disappear if you refresh the webpage in your browser. You can click the image in the CONFIG page at any time to get it back.

    Caveats and Notes

    Whilst I've made efforts to follow Google Best Practices the solution still runs on Google Servers, there is very little running on the client side. This means there can be a noticeable delay whilst stuff is sent to the Google servers, processed, and then returned to your browser. On top of that all of the usual things that slow your network traffic can clog up the communications to Google as well. Occasionally you'll need to exercise some patience and let things take their time to complete. Future version will have better visual indicators that something is happening in the background, so you don't start button mashing like a scrub.

    This is a BETA version and is still very much a work-in-progress. Most of the ongoing development is in the UI which is designed to be as procedural as possible. This should eliminate the need for documentation and hopefully make things self explanatory for all users regardless of language. You'll notice the UI tabs have a clear workflow and use color coding to help guide you to the next configuration choice. There is currently no error handling and the design approach should also minimise future error handling requirements. There are some extra validators around functions that write something, but that's about it. Stay on the beaten path and you should be fine, if something really weird happens and you can recreate it, please let me know.

    Documentation is a little light at the moment and I will build it up over time. Advanced activities such as configuring a custom build and determining coefficients will be covered at some future time. If you're comfortable with the sheets and have a grasp of these things then yellow boxes are always safe, blue can be manipulated if you know what you're doing, white boxes generally aren't safe, and editing green boxes will cause your monitor to burst into flames.

    Getting Started
    1. Login to Google Drive with a google account
    2. Open the current calculator link below
    3. Select "Make a Copy..." from the File menu
    4. Rename your copy to whatever you like
    5. Click the image on the CONFIG sheet
    6. Select "Configure..." from the Cleric BiS menu
    7. Start entering your gear...
    8. Use the "Sort" menu functions to reorder the gearlists when you are done

    Current Version
    Cleric BETA 0.6.3

    Tips and Tricks

    Sorting Gearlists
    Gearlists are sorted from the Cleric BiS menu. You can quickly sort just the sheet you are on, or take a bit longer and sort all gearlists at once. Gearlists can only be sorted and marked for one profile at a time. Sheets are marked by comparing your currently equipped item EP with the sorted EP values in the following manner;
    • All EP matches are marked with a yellow background
    • The first Wisdom High item that is an upgrade is marked in green
    • If no upgrades are found the top list entry will be marked orange

    Custom Sorting Gearlists
    If you want to sort gearlists by your own criteria you can use the inbuilt spreadsheet sorting functions. If you hover over the column letter you wish to sort a dropdown indicator will appear, click the indicator and then select the sorting option you want. For example to sort by Endurance I would hover over "O" and then select "Sort sheet Z-A". You can restore normal EP sorting from the Cleric BiS menu when you are done.

    You can use the inbuilt Data sort functions to sort sheets according to more complex criteria, just remember to check "Data has header row". You can always "Undo" any unintended change.

    Filtering Gearlists
    The gearlists contain a lot of items you may not be interested in, for example all lists contain cloth as well as chain; this is an artifact of previous list incarnations and a reminder of the old days when equipping some cloth was almost required - that being said there are still some attractive cloth pieces. All lists can be quickly filtered by the "Type" column, just uncheck the types you don't want to display in the drop down box. Filtered out items will not be sorted so you will need to re-sort the sheet if you display them again.

    This feature is especially handy on the Essences sheet. You can quickly display a sorted list of just Air or Death lessers which is very handy when building a resist focus.

    Augmented Items
    Most augmented items have been deliberately excluded from the gearlists since there are just too many variants to manage. Significant or BiS items are included in the gearlist data. The UI will manage augmenting other crafted items automatically for you so you don't have to manually enter them. All augments are included and sort to the bottom of the sheet. You can check which augment is best for the profile and see the relative differences between them. You can also mentally sum the augment EP and the item EP to establish where an augmented item will appear on the gearlist.

    Comparing Custom Items
    Each Profile sheet has a scratch area underneath the Gear Total row. You can use this area to compare items, or to generate an EP value for a missing item in the gearlists. You can copy and paste items from various gearlsist into this area, edit them, or enter your own.

    This is a handy space to store notes, wishlists or upgrade paths for each profile.

    Improving Performance
    Google Drive can sometimes effect the performance of Rift, or sometimes operate quite slowly; particulalry when loading a sheet for the first time. This can be problematic if you are trying to quickly check an item during a raid. There are a couple of things you can do to speed up the response time. the first is to preload all the sheets prior to your raid so they are cached for faster access.

    Alternatively, if you don't need a fully interactive version open during raid, you can publish a read only HTML version that doesn't require you to be logged in to access and will have much faster rendering times. Simply select Publish to the Web from the File menu, accept the defaults and hit Start Publishing. Bookmark the resultant link for fast access. You can also share that link with others if you like.
    Last edited by Finella; 08-31-2013 at 03:50 AM.

  2. #2
    Rift Chaser
    Join Date
    Dec 2010
    Posts
    332

    Default

    p.s. Can a moderator merge the first 11 posts?

    I keep getting the "The requested URL was rejected. Please consult with your administrator." error when I tried to do it in one post.

  3. #3
    Plane Touched Zormus's Avatar
    Join Date
    Feb 2011
    Posts
    208

    Default

    The Bowler Hat lists have been invaluable to me. Thanks for taking over and keeping them updated!
    Roles - A convenient menu for changing roles, equipment, and wardrobe

  4. #4
    Ascendant Hodor's Avatar
    Join Date
    Mar 2011
    Posts
    3,830

    Default

    links don't seem to include new ga equipment.. are you sure they are updated? or are these the wrong links? no ga glove, belt, legs in inq.. didn't check further
    Last edited by Hodor; 07-31-2013 at 10:48 PM.

  5. #5
    Telaran
    Join Date
    May 2011
    Posts
    96

    Default

    Severe lack of relic runes, too...
    Skep

  6. #6
    Plane Touched Arasaadi's Avatar
    Join Date
    Jan 2011
    Posts
    216

    Default

    Quote Originally Posted by Hodor View Post
    links don't seem to include new ga equipment.. are you sure they are updated? or are these the wrong links? no ga glove, belt, legs in inq.. didn't check further
    Not sure what's up with the 'flat' sheets, but the interactive 0.6.3 sheet has that stuff if you synchronise.

  7. #7
    Rift Chaser
    Join Date
    Dec 2010
    Posts
    332

    Default

    The static sheets had some permission issues. Unfortunately I had to republish the sheets, and the old URLs are now invalid.

    Inquisitor calculation has been updated to 61 inquisitor/10 cabalist/5 defiler.
    Last edited by Finella; 08-03-2013 at 02:45 PM.

  8. #8
    Ascendant Hodor's Avatar
    Join Date
    Mar 2011
    Posts
    3,830

    Default

    thanks I can see the GA stuff now.
    has anyone worked up stat weights for 61 druid btw?
    may have been posted in another thread somewhere.

  9. #9
    Rift Chaser
    Join Date
    Dec 2010
    Posts
    332

    Default

    Shaman calculation has been updated to Byona's rotation of applying Vex before Frozen Wrath.

    61 Druid weightings might be done next.

  10. #10
    Soulwalker
    Join Date
    Apr 2013
    Posts
    5

    Default

    Why no tank love? I've added the GA tank stuff to my custom sheet, but it would be nice to have it added to the generic one. Most of the GA tank drops are known and could be added

    Complaining aside, I'm really glad someone is going to take over where Bowler Hat left off! Much respect.

  11. #11
    Ascendant Hodor's Avatar
    Join Date
    Mar 2011
    Posts
    3,830

    Default

    Are there any plans to do a BIS for the relic greaters?
    I'm pretty sure the 103cp is bis for all specs, but curious about the others. (81sp vs base stats+sc proc)

  12. #12
    Rift Disciple
    Join Date
    Aug 2013
    Posts
    126

    Default

    Thanks for taking this on, this spreadsheet is invaluable.
    It's not a huge issue but I wanted to point out that the PA in place on the spreadsheet is still capped at T2. I have been using my own typed in values for T3 and added the 15 PA Crit Power as a consumable.

    Wis 117
    Int 102
    End 117

    Wand 72
    2H Staff/Hammer 144
    Mace/Dagger 72
    Totem 72

    There appears to be an error in the crit calculation on Ring of Flaring Intellect which gives it 153 SC.

  13. #13
    Rift Chaser
    Join Date
    Dec 2010
    Posts
    332

    Default

    I have no desire to update tanking stuff since at this point in time, you simply take whatever has more end/armor due to avoidance being generally useless.

    Ring issues have been fixed.

    The baseline stat calculation will be adjusted at a further date, but for now its still at expert + t2 PAs.

    Greater calculations will come at a much late date. Simply too swamped with work atm. ><

  14. #14
    Rift Chaser
    Join Date
    Dec 2010
    Posts
    332

    Default

    Updated base calculation to use max PAs and a full set of Desolate gear.

    Known issue: ring and trinket runes aren't added correctly by the configuration applet.

  15. #15
    Soulwalker
    Join Date
    Jun 2011
    Posts
    2

    Default

    When I run the script (click on the picture) the spreadsheet says "This app needs authorization to run." It wants me to give the App permission to: "Create new spreadsheets, View and modify existing spreadsheets, Share spreadsheets with others" from my personal Drive. I will not do this. And I'd like to know why it's asking for this permission. Can you please explain?

+ Reply to Thread
Page 1 of 2 1 2 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts