Noticed some errors: perk 85 has its prereqs copied from the cell above it, should be AG 7 instead. Also, level requirement for Implant GRX (perk 103) is 30, not 20. As others have said, a non-password-protected version would be best.
As of 1.2.4 there seems to be a new error involving SPECIAL and implants. If you set a special to 9 and add an implant to make the stat a 10 you get an error and it refuses to count the implant as using one of the END slots. it does appear to calculate all other effects of the implant however, so this is purely superficial.
I've noticed a small formula mistake with the Strength calculation. It appears that the formula fails to add in the "Spineless" or "Reinforced Spine" modifiers even though the formula does check it when verifying if Strength will be 10 or less.
Thanks for letting me know. These were some of the first equations I wrote in developing the planner, then just made ad hoc additions when I would add more to the planner without doing much accuracy checking.
Looking at it more closely, I was able to identify a significant problem in the strength calculation, which I fixed. I also updated all the hard level caps for the SPECIAL traits. It was possible to get over 10 in all SPECIALs before, again oversight on my part since those equations had been there for a very long time.
With respect to the changes I made: For the strength calculation, you'll notice that for the vlookups they don't have a value to check against, so they always returned an error no matter what, hence why the levels never got added (if it was an error, 0 was added).
Next you'll notice the extra SPECIAL point given by either: The Bear-Slayer, Dead Man's Burden, or Divide Survivor was added after the maximum level check. This applied to all SPECIAL traits. This is also true for the vlookups for Spineless and Reinforced Spine. This means even if you had 10 strength, those values would still be added, allowing up to 13 strength (or 14 since there is currently nothing to stop you from saying you have both traits at once).
I'm glad you enjoy the planner and hopefully those fixes make it more usable, I appreciate you pointing me at some older equations that clearly were lacking. If you find anything else feel free to mention it, or any suggestions for features you might like to see.
Missed changing the bit under starting level but implant + TAG is good(super nit-picky). Confused the hell out of me for a few days before I saw the problem. Much obliged.
Might I suggest uploading a version that is not protected against edits? That would be useful for anyone using uncommon or personal mods that might be easy to integrate, but wwould be tedious for you to have o mess with.
This is very comprehensive; the best I've seen uploaded. Obviously you know your way around Excel. You might want to add a short tutorial on how to use your planner for the benefit of folks who are not so familiar with spreadsheets and how they work. We tend to forget that MEGO moment when we were first exposed to the things.
Also, I would encourage everyone to download this planner manually so you can place it where Excel will be looking for it and not have it stuck wherever NMM decides to put it.
Excellent and most useful mod, even for an experienced FNV player. Thank you and happily endorsed.
I appreciate it. I decided to add some information just to help users get started. My hope is that this information and the general limitations and restrictions on the sheet itself should be a decent guide for people.
Unfortunately given the complexity of New Vegas I'd have to write pages to explain all the interactions. The planner itself is mostly limited to permanent gains and changes, so it is relatively simplified.
18 comments
=IF(C4+(IF(E4="Yes",1,0)+(IF(ISERROR(VLOOKUP(L188,C103:C143,1,FALSE)),0,1))+(IF(ISERROR(VLOOKUP(L191,C103:C143,1,FALSE)),0,2))+COUNTIF($H$41:$H$50,"Strength"))>10,10,
(C4+
((IF(ISERROR(VLOOKUP(L188,C103:C143,1,FALSE)),0,1))+(IF(ISERROR(VLOOKUP(L191,C103:C143,1,FALSE)),0,2))+
IF(E4="Yes",1,0)+COUNTIF($H$41:$H$50,"Strength")))+IF(H54="Strength",1,0)
This seems to fix it (I added extra parentheses to help figure it out).
Thank you for the planner, it's great.
=IF(C4+(IF(E4="Yes",1,0)+(IF(ISERROR(VLOOKUP(L188,C103:C143,1,FALSE)),0,1))+(IF(ISERROR(VLOOKUP(L191,C103:C143,1,FALSE)),0,2))+COUNTIF($H$41:$H$50,"Strength"))>10,10,
(C4+
((IF(ISERROR(VLOOKUP(L188,C103:C143,1,FALSE)),0,1))+(IF(ISERROR(VLOOKUP(L191,C103:C143,1,FALSE)),0,2))+
IF(E4="Yes",1,0)+COUNTIF($H$41:$H$50,"Strength")))+IF(H54="Strength",1,0))
Looking at it more closely, I was able to identify a significant problem in the strength calculation, which I fixed. I also updated all the hard level caps for the SPECIAL traits. It was possible to get over 10 in all SPECIALs before, again oversight on my part since those equations had been there for a very long time.
With respect to the changes I made:
For the strength calculation, you'll notice that for the vlookups they don't have a value to check against, so they always returned an error no matter what, hence why the levels never got added (if it was an error, 0 was added).
Next you'll notice the extra SPECIAL point given by either: The Bear-Slayer, Dead Man's Burden, or Divide Survivor was added after the maximum level check. This applied to all SPECIAL traits. This is also true for the vlookups for Spineless and Reinforced Spine. This means even if you had 10 strength, those values would still be added, allowing up to 13 strength (or 14 since there is currently nothing to stop you from saying you have both traits at once).
I'm glad you enjoy the planner and hopefully those fixes make it more usable, I appreciate you pointing me at some older equations that clearly were lacking. If you find anything else feel free to mention it, or any suggestions for features you might like to see.
This should be fixed now.
Thanks again for letting me know. If you find any other problems feel free to say so. I'm not perfect and the sheet has gotten moderately complex.
I was wondering if you'd be able to make a version for Josh Sawyer's mod? http://fallout.gamepedia.com/JSawyer
Unfortunately I don't use the JSawyer mod myself, so if you find any mistakes feel free to let me know.
Also, I would encourage everyone to download this planner manually so you can place it where Excel will be looking for it and not have it stuck wherever NMM decides to put it.
Excellent and most useful mod, even for an experienced FNV player. Thank you and happily endorsed.
My hope is that this information and the general limitations and restrictions on the sheet itself should be a decent guide for people.
Unfortunately given the complexity of New Vegas I'd have to write pages to explain all the interactions.
The planner itself is mostly limited to permanent gains and changes, so it is relatively simplified.