Jump to content

Vanden

Members
  • Posts

    3460
  • Joined

  • Last visited

  • Days Won

    11

Posts posted by Vanden

  1. I've dabbled in designing new enhancement sets, but editing the Mids database to get accurate enhancement value sums and ED calculations (as I did in the past) is a major hassle. To that end, I looked into writing a spreadsheet that could do that for me, which blossomed into a massive sheet that allows for designing nearly every aspect of a new IO set. To use it, you'll need a Google account. Then, click the link below, and on the page that opens, click on File in the upper left of the screen, then click Make a Copy. This will let you create an editable copy of the sheet.

     

    Click here to see the IO Set Designer tool

    Click here to view the collection of already-existing IO sets


    What can this sheet do? I'm glad you asked!

     

     

    image.thumb.png.1150778875d8e77a6bcad8077262a12d.png

     

    This is what the sheet looks like. With the exception of the tan-colored cells, it's used entirely with checkboxes and drop-down menus.

     

    Capture.thumb.PNG.6f9945865a27d85ced96d24fea6db05b.PNG

     

    The very top of the sheet lets you set basic info about the set. You can type the name in the large tan cell, and choose the category with the drop-down menu below that. To the right of those cells, drop down menus let you designate the IO set as Craftable through recipes, or only available as Attuned (like Overwhelming Force, or ATOs), and set the intended Rarity of the set. Choosing Attuned-Only for the Type automatically marks every enhancement as Unique, and choosing Very Rare for the Rarity automatically marks every enhancement as Superior. Lastly, you can set the intended level range of the set.

     

    Capture.thumb.PNG.6a226994fa2316692577a9b403679f9a.PNG

     

    The next section is for more detailed info about the set. You can choose up to 6 enhancement aspects for your set to affect, and mark enhancements as containing a proc. Two columns on the right let you adjust the level of the enhancements or apply boosters, to see the enhancement strengths at various settings. The column on the far right lets you mark individual enhancements as Unique.

     

    Capture.PNG.d56a452481bccaa1df47187fd6e04226.PNG

     

    After choosing your set's aspects, you can begin marking checkboxes to create the set's enhancements. The colored cells directly below this section will show the total enhancement values your set would give when slotted into a power, before and after ED. Directly under the ED totals, cells will change color to indicate when you hit the various ED soft caps, similar to Mids. Below that, the sheet will automatically show you the names of your enhancements.

     

    Capture.PNG.42bd68ff0e69e0e34837eee24a403e68.PNG

     

    The cells directly to the right of the enhancement names will automatically fill up with the individual values of the enhancements you've made. The numbers here reflect the level you set for each enhancement, as well as any Boosters you've applied and whether the set is marked as Very Rare (Purple). What are those grey boxes in the middle? More on those later...

     

    Capture.thumb.PNG.65d26b965013be2a4ef2dbf506543877.PNG

     

    Finally, the column farthest to the right in this section is the Unslot column. Clicking the checkbox here will cause the tool to ignore that enhancement in the totals, allowing you to see what enhancement values the set will give to a power if you don't slot certain IOs in the set.

     

    Capture.thumb.PNG.9c458c5385247f385748b8ad57d8c269.PNG

     

    Lastly for this section, there are six tan cells where you can type in Proc effects for your set to have. The names you type will show up in the list of IOs when you have checkboxes in the Proc column checked.

     

    Capture.thumb.PNG.aa61c3a88ebdbfb872eff2376b7a4f87.PNG

     

    The bottom half of the sheet is dedicated to Set bonuses!

     

    Capture.thumb.PNG.9527a00b486e005c26a0f2519395c772.PNG

     

    This massive and marvelous section at the very bottom of the sheet lets you set up to 3 normal and 3 PvP-only set bonuses for each set bonus tier. Drop down menus contain a full list of set bonuses, and let you set the rank of the set bonus, from Tiny to Ultimate.

     

    Capture.thumb.PNG.0dd4ba0ad93ac61e087ac6f93995eb1b.PNG

     

    The set bonuses you choose and the ranks you set will then show up in the list of set bonuses above, showing you the numbers they give.

     

    Capture.PNG.6c26f0bb13767818b2de6ec4a6bde56b.PNG

     

    Back up in the top half of the sheet, these boxes will fill up with some analysis of the set you've built. Effective Total IOs tells you how many common, single-asect IOs it would take to give an equivalent amount of enhancement value to your custom set in a power. Total Enhancement Aspects is effectively a count of how many checkboxes you marked for aspects in the first section. Total Set Bonus Ranks sums up the value of the set bonuses you applied based on their rank; a Tiny bonus is worth 1, Small is worth 2, etc. The last box sums Total Set Bonus Ranks and Total Enhancement Aspects together. This analysis method has been used on the sets available in game, and found that low-to-mid 30s is where most of them fall.

     

    Capture.PNG.cdd9b6bf2b22d97d58ff07548d7c1954.PNG

     

    Suppose you designed a PvP set, and you have a whole suite of PvP-only bonuses inflating your Set Bonus Rank total. A checkbox directly below the analysis boxes makes them ignore any PvP-only set bonuses, allowing you to get some idea of how your set is balanced for PvE play.

     

    Capture.thumb.PNG.713abc3bd78eb4c6878d3e4ca1f92abf.PNG

     

    Lastly, the tool has a number of checks for various errors or illegal setups that aren't allowed for actual sets in-game, but generally will still show you the info for what you put in, in case you're curious what an IO with 30 boosters will do, or what a purple IO at level 15 will do, or what a five-aspect IO is worth, or something. Go nuts if you want!

     

    I hope someone finds this useful. I do like contributing to the community, after all.

     

    The following is just the original version of this post, preserved for posterity.

    Spoiler

    Capture.thumb.PNG.7b8737da0e2e296a43645daf213bfb1c.PNG

     

    Here we have the main sheet. There's space at the top for you to write the name and category of the set you're designing.

     

    Capture2.thumb.PNG.2ad355b128187e38cf9a540cd3d68bc4.PNG

     

    You can have up to 6 enhancement aspects per set, plus a proc. Click the checkboxes and the cells below this section will automatically fill out with info on the set. Drop down menus in the first 6 columns have a list of every enhancement type in the game, except Intangibility because lol Intangibility IOs 😛

     

    Capture3.PNG.719bac86a64743c26dba4548aa5588f2.PNG

     

    You can optionally mark each enhancement as Superior (purple), set them to any level from 1-50, or apply up to 5 Enhancement boosters from the dropdown menus.

     

    Capture4.thumb.PNG.9fb40b301bd3b5038e0ea735bb555ce3.PNG

     

    As you mark checkboxes, these cells will automatically fill up with detailed info about the enhancements. The numbers in this section reflect whether you marked IOs as Superior, applied any boosters, or changed the level of the enhancement. It also has error checking that looks out for duplicated enhancements, or enhancements with more than 4 aspects. IOs can't have more than 4 aspects, that would be illegal! You can also optionally write in a Proc in the tan cell at the bottom of this section.

     

    But what about set bonuses?

     

    Capture5.thumb.PNG.49ee6dab89a90e088eae31286a8bb62e.PNG

     

    Scroll down to this marvelous section to assign your set's set bonuses. Each tier of set bonuses can have up to 3 normal bonuses and 3 PvP-only bonuses.

     

    Capture6.thumb.PNG.f91770ffa886b22de6cc5f345a702e05.PNG

     

    The set bonuses you choose in the selector are automatically listed in the chart above.

     

    Capture7.PNG.e956a54c13feb3d2b352b839f2eeacaa.PNG

     

    These boxes near the top are of particular interest if you care about balance. Effective Total IOs tells you how many single-aspect Common IOs you would have to slot to get an equal amount of enhancement value that the set you've designed gives. Total Enh Aspect is a count of how many aspects your set affects across all its enhancements. Total Set Bonus Ranks adds up the value of all the set bonuses you chose. (A Tiny bonus is worth 1, a Small bonus is worth 2, etc.) The last box simply adds together the values in the previous two boxes. Aim for the low 30s in this box for a balanced set!

     

    I hope someone out there finds this helpful. If you find any bugs, let me know, although I'll probably just start crying if you do.

     

    • Like 3
    • Thanks 2
    • Thumbs Up 1
  2. 51 minutes ago, Supertanker said:

    I'm  team "slot your attacks early" to counteract the enemies' rising health. Especially now that we can use SOs so early, they make a big difference. (And I also throw in some useful IOs, here's an example of my Tank at level 15:)

     

    But you slotted Jab, bro. You slotted Jab.

    • Haha 1
  3. Imagine my surprise coming back to CoH after about a year off to find that the Minotaurs and Cyclopes in Sister Solaris's arc have a bunch of new powers, including Rage. The finale of this arc requires you to clear out 4 groups of 8 of those guys, and a fifth spawn at the end that includes 6 of them. I can only assume that not a single person remembered this arc when the new mobs were introduced for testing, because asking players to fight 8 elite bosses with Rage simultaneously in what is supposed to be a soloable arc is absolutely insane (I admit I would've been one of the everybody who didn't think to check). I even tried the mission set to the lowest difficulty with Bosses turned off, which downgrades them to Lieutenants, and 8 of those guys with Rage running were still able to kill my Scrapper and all the NPC allies the game gives you to help clear the mission. On my normal difficulty settings, even Barrier Core Epiphany couldn't keep me alive against them. This level of difficulty is way out of line.

  4. This is stretching the definition of "typo," but there's an issue with the popup message that every character gets the first time a Tip drops for them. The popup explains the basics of the alignment system, how doing tips will fill up the bars, etc. The issue is that since exploration badge tip missions were added, the first tip a character gets is most likely going to be one of those exploration badge missions, which don't interact with the alignment system at all. The text in the window was written when Alignment and Morality missions were the only kinds of tips you could get, and hasn't been updated since. It basically needs to be rewritten without the assumption that those are the only kinds of tips.

  5. 1 hour ago, golstat2003 said:

    Once you stop making alts or are Tier 4'd up the EMPS are pretty much useless. The only value left was converting them into Reward Merits and then those into converters to convert uncommons into rares and sell them on the AH. Doing this has netting me billions over the last year.

     

    But if you stop making alts, isn't inf just as useless?

    • Thumbs Up 5
  6. 2 hours ago, TheZag said:

    Put Manticore in charge of the TF against council since he has a thing against them.  Put Penelope as the clockwork task force because the clockwork king and Penelope have a dialogue going.  Put Synapse on the Crey TF because he was experimented on by them and would like to dismantle the organization.  That leaves Citadel with sending you to stop Clamor from blowing up the power plant.  It seems like a very Citadel thing for him to do.  Except give him back his original name,  thats a very Bastion thing of him to do.

     

    I think Manticore going after Crey makes the most sense, since he's the most Batman-y, Vigilante-type character, so he'd have the least problem with openly going against "legitimate" business.

  7. On 7/19/2022 at 12:25 PM, Stormwalker said:

    I know you can just switch to Redside and get Invader for the same effect, but... I can't very well have Kitten America running around robbing banks, can I?  It just wouldn't do.  So I'll have to do it the hard way.

     

    You don't have to actually rob any banks, just break a few objects to get the mission time limit above 15 minutes, then make it back to Lord Schweinzer before it falls under 15 minutes again, and he'll let you abandon the mission.

  8. 6out4c.jpg

     

    Cold Domination ➡️ Ice Affinity

    Dark Miasma ➡️ Darkness Affinity

    Electrical Affinity ✔️

    Empathy ➡️ Life Affinity

    Force Field ✔️

    Kinetics ➡️ Kinetic Affinity

    Nature Affinity ✔️

    Pain Domination ➡️ Pain Affinity

    Poison ➡️ Poison Affinity

    Radiation Emission ➡️ Radiation Affinity

    Sonic Resonance ➡️ Sonic Affinity

    Storm Summoning ➡️ Weather Affinity

    Thermal Radiation ➡️ Fire Affinity

    Time Manipulation ➡️ Time Affinity

    Traps ➡️ Gadget Affinity

    Trick Arrow ✔️

     

    I will not be taking questions at this time

    • Thumbs Up 1
    • Thumbs Down 8
  9. On 8/2/2022 at 10:50 PM, kingsmidgens said:

    It's a slippery slope, and why?  What does it accomplish?  It seems it's specifically targeting a few powers and will have far-reaching implications, perhaps a "slight" bump in difficulty but again, why?

     

    To be clear, this isn't a change intended to nerf the effectiveness of S/L/E defense. The goal is to add more potential flexibility to future game design. Suppose a dev wants to add an attack that targets an exotic defense type, like Negative Energy. They want this attack to be difficult to avoid. But they don't want the attack's damage to be as difficult to resist when it lands, so the attack should do Negative Energy and Smashing damage. Under the current rules, this attack has to check against Negative Energy AND Smashing Defense, so the attempt to target an exotic defense type is nullified. The only way to make it so Negative Energy defense is the only defense type that can avoid this attack is to make the damage of the attack 100% Negative Energy, which means it's more punishing to actually get hit by this attack than the dev actually wants.

     

    Now, yes, the powers system is flexible enough that it's technically possible to make an attack that does Negative Energy and Smashing damage, but only checks Negative Energy defense. It could be any arbitrary combination of damage dealt and defense types checked. But then this attack would be breaking the rules. The rules on HC Live are that attacks check against the defense of every damage type they do. If the devs are allowed to just disregard that, suddenly there are no rules, and players will just have to guess (or find the exact power info for every attack) what defense they need to protect against certain attacks. This is no bueno. Players have to be able to understand what the game expects of them.

     

    This change does have the side effect of slightly devaluing S/L/E defense in existing content. But given that those defense types have been proven to be massively, disproportionately effective against the majority of content, and even then this change only impacts a fraction of enemies, it's ultimately a very minor side effect.

     

    • Thanks 4
    • Thumbs Up 8
    • Thumbs Down 1
×
×
  • Create New...