Jump to content

Invention Set Designer Tool Spreadsheet - for the creative types


Recommended Posts

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!

 

 

Capture.thumb.PNG.e4e4ce79112b3db8e1d7593b42389904.PNG

 

This is what the sheet looks like. With the exception of the three 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 left 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 two 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.

 

Edited by Vanden
  • Like 2
  • Thanks 2
  • Thumbs Up 1
Link to comment
Share on other sites

Posted (edited)

Additions to the tool, Couldn't Sleep Edition:

 

Capture.PNG.7e748fec386a218efcb50d9f886b7e0f.PNG

 

It's now possible to ignore PvP Set Bonuses in the Set Bonus Rank total

 

Capture.PNG.5d7f33136390d30a1e3a0d2bb6c43911.PNG

 

The second and third set bonuses in a tier can also be optionally ignored in the total, for example if you want to count a damage resistance and mez resistance pair as one bonus, as they often are in game.

 

Capture.thumb.PNG.fe7134083fad18efc45866ec5098a493.PNG

 

Putting too many aspects into one enhancement will still show errors, but it will also now show what the values of those enhancements would be if that were possible in-game.

 

Capture.PNG.beb75b060ed330d66499f8812c13ce3f.PNG

 

It's now possible to choose "None" from the drop down menus for enhancement aspects

 

Capture.PNG.b611077bbb690585440c3fd5dedbd451.PNG

 

Using Superior IOs now increases the Effective Total IO count

Edited by Vanden
  • Like 2
Link to comment
Share on other sites

I have mixed emotions on this......

 

 

First impressions...holy cow what a cool tool and a tremendous amount of work....well done... 

 

 

Second emotion....what level  nerd do you need to be to do this......🤓......jealous I am  of the skill.....

 

 

 

Either way well done and I will give it a try..

Edited by mrstyle
Typo
Link to comment
Share on other sites

More additions to the tool:

 

Capture.PNG.213d10e73a73ed481e3ff5c631d9d37f.PNG

 

Fields have been added to allow you to set the level range of your set.

 

Capture.thumb.PNG.76dd7caa3afe1b4006b4d3db614fc48b.PNG

 

Detected errors now display in a less harsh shade of red.

 

Capture.PNG.6a9359458c8a76ea6a84e7e7208de18a.PNG

 

The cells where you select the rank of the set bonuses now change color to match the selected rank.

Link to comment
Share on other sites

Posted (edited)

Update:

 

Capture.thumb.PNG.4771d2d83c06bcedf2735a728851c6ae.PNG

 

It's now possible to have two separate proc effects in a set, in case you want to make another set like Steadfast Protection.

 

Capture.thumb.PNG.fc4c2d64ff4bb2f6d555988be2f2531f.PNG

 

Proc aspects no longer increase the Effective Total IO count.

 

Edited by Vanden
Link to comment
Share on other sites

Posted (edited)

Update:

 

Capture.thumb.PNG.79830f899ca8a6e3eee2f32fbc75e924.PNG

 

It's now possible to use either Proc option in sets that you only give one proc, rather than only using the second proc option when you want to use both.

 

This one took me ALL DAY

Edited by Vanden
Link to comment
Share on other sites

Posted (edited)

Update:

 

Capture.PNG.83efea227bf4dc2d2b27cee1f11aa525.PNG

 

There is now a field to set the Type of your set, either Craftable or Attuned-Only (like ATOs, or Overwhelming Force).

 

Capture.thumb.PNG.8efe7119017d487867439f1120ad43bf.PNG

 

Choosing "Attuned-Only" as your set type automatically marks every enhancement as Unique, regardless of whether you have checkboxes in the "Unique?" column marked.

 

Capture.PNG.f930260489e9510837130612bc1bc912.PNG

 

Similarly, marking enhancements as Superior is now done by selecting "Very Rare" for the set's Rarity.

 

Capture.thumb.PNG.464860a3af85e6e43bd563e45e8115b9.PNG

 

The "Superior?" column has been replaced with the "Unslot?" column.* Marking checkboxes in this column makes the tool temporarily ignore an enhancement's contribution to the final slotted values, allowing you to quickly see what totals the set would give if the marked enhancements were not slotted.

 

Capture.PNG.466b36302b1d77737eec275af46d5221.PNG

 

Lastly, the colors of several aspects have been updated to more closely match their enhancement colors in-game.

 

*Hot tip: Removing the "Superior?" column means it's no longer possible to use the tool to try out certain frankenslotting setups, specifically mixing +5 purples with normal IOs. Buuuut... if you click on a box in the booster column and type in 11.25 as the value instead of using the drop down menu, the numbers for that enhancement will be identical to a +5 purple with the same aspects.

Edited by Vanden
Link to comment
Share on other sites

  • Vanden changed the title to Invention Set Designer Tool Spreadsheet - for the creative types

Well it's been over 24 hours since I made a major change to the sheet, which could possibly mean it's finally complete! In celebration, I've edited the first post to reflect all the changes and additions I've made since the initial posting.

Link to comment
Share on other sites

Update:

 

Capture.PNG.c80d48f130d281fc320c1003c81c6efa.PNG

 

The cells that change color to indicate ED caps now also repeat the name of the aspect in each column.

 

Capture.thumb.PNG.a14cd2a9b4536ad22e5d28117e42c98e.PNG

 

This is to enable the sheet to become more compact; once all the set bonuses and enhancement aspects have been set, the rows where that's done can be hidden so the sheet only shows the final design of the set without all the now-extraneous fields where that information was input.

Link to comment
Share on other sites

I've created a collection of all the currently-existing IO sets in the game, entered into the IO Set Designer Tool. This is handy for comparing the balance of any potential new sets designed with the tool to sets that already exist in the game.

 

Here's the folder where they can all be viewed.

 

The OP has also been edited to add a link to the folder.

 

You might notice some of the sets seem to be formatted a bit differently than others. I did a fairly significant aesthetic overhaul to the tool partway through creating the folders, so a lot of them are based on an older version of the tool. I'll update them to use the current version at some point. Probably.

Edited by Vanden
Link to comment
Share on other sites

Update:

 

Capture.thumb.PNG.4e01f93f03c108896f071f8d141ddf48.PNG

 

The checkboxes to ignore the 2nd and 3rd set bonuses in a tier in the Rank Totals have been removed.

 

Capture.thumb.PNG.2eeaf04ce1b9bdb7ec525c4f4b62ad25.PNG

 

They're no longer necessary. I've rewritten the cells where the set bonuses are displayed so that all the set bonuses that come in groups (Typed and Positional Defenses, Damage and Mez Resistance, and the All Control Types boosts in the Dominator and Controller ATOs) are displayed with only one entry in the selector. This means it's no longer necessary to manually set each bonus individually.

 

As a bonus, this means that the code in the cells to display set bonuses no longer looks like this:

 

Image

 

 

Edited by Vanden
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...