Please don't hesitate to make suggestions or request some additional worksheets. If you'd like some auto-calculations or some pivot tables (if you know what those are), I can probably get those in as well. I didn't find a need for all that myself, but it shouldn't take me long to add it if you are interested in something for your own play through and aren't good at Excel other than filling in fields (don't feel bad - most people aren't).
I know it's been a year since you updated this, but maybe add a set of columns for those of us using Sim Settlements and the stats that go along with that? This is absolutely fantastic for people like me who keep files for everything (I have a text file of places that have high level locks or terminals I need to go back to, for instance).
Yeah, this was done before the DLCs, so it doesn't even have that info. I've been meaning to update, but just haven't had the time.
I haven't had a chance to use Sim Settlements (or Transfer Settlements, which I've wanted to try out). If you can take a screenshot or mock up an example of some sort of what you are looking for, I'll try to include it if I get a chance to update this. No promises, but I'm happy to try at that time.
Thank you for this - will be a very useful tool! Also appreciate you leaving your data in - always good to see how someone else approached things. Already see several things I'd not thought of or could have done better.
Glad people are still finding it helpful. I need to update it with the new settlements for Far Harbor and Nuka World. I haven't put a lot of time into building those settlements up though yet beyond the basics.
This is strictly manual. A mod would be required for exporting the data. Unfortunately, the data isn't reliable. Quite often the data the game provides isn't always correct, so it would mess up your spreadsheet.
If you aren't interested in manually tracking your settlement details as you establish them, then this spreadsheet probably isn't for you :)
You might want to take a look a the PyPipboy app I mention on the Desc tab though...
UPDATE: I haven't used the feature before, but that PyPipboy app has an export data feature. So, you could run it on your same machine and theoretically just use that export feature. Maybe worth trying out!
9 comments
Please don't hesitate to make suggestions or request some additional worksheets. If you'd like some auto-calculations or some pivot tables (if you know what those are), I can probably get those in as well. I didn't find a need for all that myself, but it shouldn't take me long to add it if you are interested in something for your own play through and aren't good at Excel other than filling in fields (don't feel bad - most people aren't).
I haven't had a chance to use Sim Settlements (or Transfer Settlements, which I've wanted to try out). If you can take a screenshot or mock up an example of some sort of what you are looking for, I'll try to include it if I get a chance to update this. No promises, but I'm happy to try at that time.
I like the idea of a table. I have no clue as to how to get the data from the game to a table though.
If you aren't interested in manually tracking your settlement details as you establish them, then this spreadsheet probably isn't for you :)
You might want to take a look a the PyPipboy app I mention on the Desc tab though...
UPDATE: I haven't used the feature before, but that PyPipboy app has an export data feature. So, you could run it on your same machine and theoretically just use that export feature. Maybe worth trying out!