Exactly what I was looking for, was using similar spreadsheet in SkyrimSE for modded artifacts and stuff and it's a life saver. Could you make an alternate version in Google Docs ?
Many thanks to everyone who have contributed to this list :)
You mean checkmarks that you need to click on to switch from 0 to 1?
IIRC, I had few problem with those, 1) it needs manual clicks, no keyboard input, 2) if you try to group lines together, while folded you have all those checkmarks outside of folded space on top of each other, 3) painful to edit as I had to highlight them with "object selection" tool first. Binary input was simpler and nice and I limited incorrect numerical input with bunch of ole reliable if-thens.
Thx for clarifying. Another idea I have is conditional formatting, for example quest name and description cell getting greyed out and crossed out after selecting it as complete (inputting 1). Visually it's easier to see what's done and what's not. Cheers :)
Hello mate, this is a great list! I've added a checklist for New California and The Frontier and I'd like to upload it. Do I have your permission (I will credit you of course) or would you like to upload it yourself?
Hey there, thanks for contacting me. If you don't mind, I would like to incorporate your additions into my file, so all the data would be inside a single file. If you can send it to me, I'll add it on separate sheets like I did with TTW, check formatting and then re-upload this new version. I haven't played yet the mods you named, but those are on my watchlist.
Okay, I've DMed you. Also, I have a suggestion for calculating percentages. For games with a branching story, like NVs main quest, as well as NC and TF, it might be better to count only one branch of quests since only one can be completed per playthrough, otherwise you could never get 100% completion. I know the formulae would be a little bit complicated but maybe if you introduced completion percentages next to tabs (quests, bobbleheads, dlc etc) it would make the calculation easier, and the final completion score for a game would just be the average of all the values. It also wouldn't skew the result too much since getting a collectible and completing a big quest are very different in difficulty. PS, sorry for the long post.
Amazing, man! I was mentally prepared to receive raw data and spend tedious few hours formatting it in, but you already done that! Thank you! How do you want to be credited in? By your nexus account or do you have steam?
These seems to be nice mods, I should probably play them both later. If anyone wants to implement Fallout 4 checklist in such a way, I would welcome that. I doubt I'll play FO4 any time soon, I have steam version since release and still haven't even started it. Dialogue wheel and voiced protagonist is just a big no-no for me, can't get past that.
In regards to your suggestion about calculation: I thought about it the way you describe, but it's just too frigging complicating to keep track of in game, not to mention nigh-impossible to implement properly and edit afterwards. Too many things can be skipped or become unavailable based on player's choices - how the hell should I account for that inside an excel file?
Like completing Van Gruff questline or getting revenge for Rose of Sharon Cassidy? And it's even possible to do both with a mod. Or running BoS errands with a slave collar on or not even getting this quest if your first visit was with Veronica.
Speaking of smaller things: Do you know that three Fiends leaders that NCR put a bounty on can be talked to and have some amazing voice acting - but you just can't talk to them in unmodified game? Or what happens if you take a photo of Boulder city memorial? Or that NCR doesn't even need a stone quarry in Sloan in the first place? Or that powdergangsters used pre-Great War dynamite to break out of NCRCF? (Most of these tidbits I haven't even put in this checklist.)
So instead of complicated formulas, I suggest using this:
If you decide to empty an input cell (by pressing "delete" button) or put any text string in it (e.g. "failed", "missed", "ignoring"), this will exclude the cell from the calculation.
No prob. man, nexus id is fine. As for FO4, same here, I tried playing it but just can't get into it... And about calculating, deleting is fine, that's what I did but I'll try testing the branching calc. and see if it works. The main quest is usually in blocks (NCR/Legion/House/Yes Man), and side quest are usually binary (Ghost Town Gunfight or Run Goodsprings Run) so it could be done. I'll let you know how it goes. Honestly it's been a while since I've played an unmodded game so I haven't noticed most of the things you mentioned. Also, I might add a list for weapons and armor to the checklist and I'll send that too to you for review.
I don't think checklist for armor and weapons is necessary? I've been using Gear Checklist mod with TTW, works fine. P.S. By Celestia, just checked, that's the guy who made both Intimacy Overhaul and Fuckable Companions. I salute you! And bunch of other mods I haven't tried yet.
Thank you both! We use this checklist in our game, as it helps us keep track of what we've done or yet to do in regards to the vanilla stuff. And FNC and the Frontier being added will certainly make it even more useful, so thank you both! : D
The update looks great! The one criticism I have is that I think one of the columns should perhaps be used to list the bounty target's name, as that would be a field filled for the majority of someguy quests.
mcdog32, any chance you're going to add even more? I think the next biggest quest mod collections following someguy would be the Overseer quest series as well as the Belthan one (Quo Vagis / Coito Ergo Sum). The latter one is pretty mature, even more than the others, but I could provide some info to you via DMs if that would be helpful, assuming barame3526 would be interested as well.
I'm not currently playing FNV, but of course I'm interested, seeing as mcdoge's doing all the work in recent updates, lol. Huge props to this guy! When I'll return to FNV, I think I'll play every added mod.
Sure thing, it just might take me some time to add everything. As for the columns with the bounty target's name, I still haven't started the someguy quest chain but I assume it's already part of a marked quest (right?) which would make it redundant. If I'm wrong I'll correct it.
Well almost all of them, you can just link the profile. Also, as for the credits, the Lolipopz tab has been compiled by MysteryMachineX. You can link Belthan's profile.
There are four different spreadsheets (pages) on the bottom panel, you can switch between them? Or what do you mean? Did you download it? Are you using excel?
This is absolutely phenomenal. I can respect a good Excel sheet. Well done!
My only criticism is that I wish there were more input options than 1 or 0 (complete or incomplete). A WIP option would be nice, or an option for Failure / Missed / Won't do.
About input options, you can write your preferred options yourself, but keep in mind that it will exclude the cell from the final calculation (because text cannot be counted). I probably could've introduced more than 2 supported options, but I didn't want it to get overly complicated for a final user.
28 comments
Many thanks to everyone who have contributed to this list :)
If you prefer Gdocs, consider uploading Excel file onto Gdocs for your personal use? I haven't tried it.
Why didn't you use checkmarks instead of binary values? i found a formula to count text =COUNTIF(A5:A193;TRUE) for GDocs at least.
Kudos!
edit:
works perfectly in Google Docs.
IIRC, I had few problem with those, 1) it needs manual clicks, no keyboard input, 2) if you try to group lines together, while folded you have all those checkmarks outside of folded space on top of each other, 3) painful to edit as I had to highlight them with "object selection" tool first.
Binary input was simpler and nice and I limited incorrect numerical input with bunch of ole reliable if-thens.
If you don't mind, I would like to incorporate your additions into my file, so all the data would be inside a single file.
If you can send it to me, I'll add it on separate sheets like I did with TTW, check formatting and then re-upload this new version.
I haven't played yet the mods you named, but those are on my watchlist.
Also, I have a suggestion for calculating percentages. For games with a branching story, like NVs main quest, as well as NC and TF, it might be better to count only one branch of quests since only one can be completed per playthrough, otherwise you could never get 100% completion. I know the formulae would be a little bit complicated but maybe if you introduced completion percentages next to tabs (quests, bobbleheads, dlc etc) it would make the calculation easier, and the final completion score for a game would just be the average of all the values. It also wouldn't skew the result too much since getting a collectible and completing a big quest are very different in difficulty.
PS, sorry for the long post.
I was mentally prepared to receive raw data and spend tedious few hours formatting it in, but you already done that! Thank you!
How do you want to be credited in? By your nexus account or do you have steam?
These seems to be nice mods, I should probably play them both later.
If anyone wants to implement Fallout 4 checklist in such a way, I would welcome that. I doubt I'll play FO4 any time soon, I have steam version since release and still haven't even started it. Dialogue wheel and voiced protagonist is just a big no-no for me, can't get past that.
In regards to your suggestion about calculation:
I thought about it the way you describe, but it's just too frigging complicating to keep track of in game, not to mention nigh-impossible to implement properly and edit afterwards.
Too many things can be skipped or become unavailable based on player's choices - how the hell should I account for that inside an excel file?
Like completing Van Gruff questline or getting revenge for Rose of Sharon Cassidy? And it's even possible to do both with a mod.
Or running BoS errands with a slave collar on or not even getting this quest if your first visit was with Veronica.
Speaking of smaller things:
Do you know that three Fiends leaders that NCR put a bounty on can be talked to and have some amazing voice acting - but you just can't talk to them in unmodified game?
Or what happens if you take a photo of Boulder city memorial?
Or that NCR doesn't even need a stone quarry in Sloan in the first place?
Or that powdergangsters used pre-Great War dynamite to break out of NCRCF?
(Most of these tidbits I haven't even put in this checklist.)
So instead of complicated formulas, I suggest using this:
And about calculating, deleting is fine, that's what I did but I'll try testing the branching calc. and see if it works. The main quest is usually in blocks (NCR/Legion/House/Yes Man), and side quest are usually binary (Ghost Town Gunfight or Run Goodsprings Run) so it could be done. I'll let you know how it goes.
Honestly it's been a while since I've played an unmodded game so I haven't noticed most of the things you mentioned.
Also, I might add a list for weapons and armor to the checklist and I'll send that too to you for review.
P.S. By Celestia, just checked, that's the guy who made both Intimacy Overhaul and Fuckable Companions. I salute you! And bunch of other mods I haven't tried yet.
mcdog32, any chance you're going to add even more? I think the next biggest quest mod collections following someguy would be the Overseer quest series as well as the Belthan one (Quo Vagis / Coito Ergo Sum). The latter one is pretty mature, even more than the others, but I could provide some info to you via DMs if that would be helpful, assuming barame3526 would be interested as well.
When I'll return to FNV, I think I'll play every added mod.
As for the columns with the bounty target's name, I still haven't started the someguy quest chain but I assume it's already part of a marked quest (right?) which would make it redundant. If I'm wrong I'll correct it.
Quick question, by "th3overseer quests" which ones do you mean? Or should I just put a link to his mods?
Also, as for the credits, the Lolipopz tab has been compiled by MysteryMachineX. You can link Belthan's profile.
Or what do you mean?
Did you download it? Are you using excel?
My only criticism is that I wish there were more input options than 1 or 0 (complete or incomplete). A WIP option would be nice, or an option for Failure / Missed / Won't do.
About input options, you can write your preferred options yourself, but keep in mind that it will exclude the cell from the final calculation (because text cannot be counted).
I probably could've introduced more than 2 supported options, but I didn't want it to get overly complicated for a final user.