Equilibrium Mod (updated to v2.1)

Discussion in 'Fallout Tactics Modding' started by raics, Sep 6, 2014.

  1. Bigwilleh

    Bigwilleh First time out of the vault

    28
    Apr 30, 2019
    Interesting workaround.

    Does it work around perks that add stats? (If so, I'm guessing those perks work by applying a modifier rather than modifying the base)
     
  2. raics

    raics First time out of the vault

    83
    Aug 17, 2014
    No, they modify the base, when you remove a perk the stat stays where it was.
     
  3. JayB33

    JayB33 First time out of the vault

    14
    Jun 7, 2017
    Hey there, I've started a new game with the latest version of this mod. One thing I noticed is Divine Favor grants INT above the racial maximum when its description says it is not supposed to. I'm not sure if it does this for every attribute.

    Oh and I must compliment you on continuing to work on this mod as long as you did / are. Took me a while to realise you'd released something new and overhauled it quite a lot.
     
    Last edited: Sep 22, 2019
  4. raics

    raics First time out of the vault

    83
    Aug 17, 2014
    Yeah, it should be able to go beyond racial maximum, forgot to change the description.

    If I find a few more small fixes there might be a minor patch at some point, but there's something else I'm working on and, sadly enough, these days I can barely find the time to work on that either.
     
  5. JayB33

    JayB33 First time out of the vault

    14
    Jun 7, 2017
    Hope you don't mind, I made a little character planner spreadsheet based on the 'Perks.png' image included in the 'More Information' folder and the original post. I have credited you at the top of the page. https://docs.google.com/spreadsheets/d/1CPN0V6Mw8b2tYRiRlNFNkLmq1plQmJJvlavfD4HK1sQ/edit?usp=sharing

    It currently highlights perks that the selected race can use, and strikes out ones it does not have access to. Eventually I hope to make it also highlight perks based on attribute points too on a scale of how easy or difficult they will be to acquire throughout the course of the game (currently, the attribute boxes at the top of the spreadsheet do nothing). Please test it out.
     
  6. raics

    raics First time out of the vault

    83
    Aug 17, 2014
    Nice, you'll also need to restrict how many of each perk can be taken, as in level 15 character can have, say, at most one L14 perk or two level 12 ones. Might be tricky in excel, but it should be doable.
     
  7. JayB33

    JayB33 First time out of the vault

    14
    Jun 7, 2017
    I hope to incorporate advanced features such as the one you suggest, but at the moment I'm having trouble with "simple" things like getting the values with the less than symbol (<) in the attributes columns to interact with conditional formatting in order to mark red those cells which are under the value specified in the character planner at the top.

    At first, I came up with this basic formula, which works to highlight any value in H5:N95 that is below those entered into the character planner at the top:

    Code:
    =H$2:N$2<H5:N5
    But it doesn't work with the less than symbols, so I bit the bullet and asked for assistance on the Google Sheets community forum, and someone came up with:

    Code:
    =OR(LEFT(H5,1)="<",H$2<VALUE(TRIM(SUBSTITUTE(H5,"< ",""))))
    I thought it was working, but then it... umm... wasn't (it ends up doing exactly the same thing as the first formula) and I couldn't figure out why I didn't realise that it wasn't and marked the answer as correct on the forum, but oh well. I mean, all this to get the less than symbol to function correctly in a spreadsheet.

    I'd also like to make a balance suggestion about the mod itself. The Environmental Armor appears to be a straight upgrade for Metal Armor MK. II as it stands, because it has even more Normal Resistance. My suggestion is that the Environmental Armor is reduced to a much lower Normal Resistance value, e.g. 25%. Perhaps to compensate, it could have a slightly increased Blast Resistance, reflecting its protective qualities in harsh environments. In addition, the Tesla Armor is also a straight upgrade to the Metal Armor MK. II and offers the same amount of normal protection in addition to its energy protection. I think the normal values on this should be reduced slightly too, though not as much as the Environmental Armor. I do think it is fair if the Environmental Armor MK. II has a Normal Resistance closer to Metal Armor MK. II though.
     
    Last edited: Sep 29, 2019
  8. raics

    raics First time out of the vault

    83
    Aug 17, 2014
    You can use this formula for conditional formatting and a hidden helper column to format the whole perk row if needed
     

    Attached Files:

  9. JayB33

    JayB33 First time out of the vault

    14
    Jun 7, 2017
    Haha, I knew you just had to be an Excel expert. :) How do you figure it out? I suppose I've only got several days experience with spreadsheet software. :*(

    That's my excuse and I'm sticking to it.

    Edit: I attempted to import it into Google Sheets and it doesn't work too well in there. Changing the race or setting values below the < ones does nothing. It's fully editable atm.
     
    Last edited: Sep 30, 2019
  10. raics

    raics First time out of the vault

    83
    Aug 17, 2014
    Google sheets are a bit rudimentary, and quirky. If you're using that, it's better to just copy the formula over