File information

Last updated

Original upload

Created by

Maiq the Lazy and mcdoge32

Uploaded by

barame3526

Virus scan

Safe to use

Tags for this mod

28 comments

  1. bubaknh
    bubaknh
    • supporter
    • 12 kudos
    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 :) 
    1. barame3526
      barame3526
      • member
      • 5 kudos
      Thank you for your kind words.
      If you prefer Gdocs, consider uploading Excel file onto Gdocs for your personal use? I haven't tried it.
    2. bubaknh
      bubaknh
      • supporter
      • 12 kudos
      LOL, it' such a simple solution...why didn't I think of it...brain freeze hehe

      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.
    3. barame3526
      barame3526
      • member
      • 5 kudos
      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.
    4. bubaknh
      bubaknh
      • supporter
      • 12 kudos
      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 :)
  2. mcdoge32
    mcdoge32
    • member
    • 1 kudos
    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?
    1. barame3526
      barame3526
      • member
      • 5 kudos
      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.
    2. mcdoge32
      mcdoge32
      • member
      • 1 kudos
      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.
    3. barame3526
      barame3526
      • member
      • 5 kudos
      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.
    4. kylemarshiku
      kylemarshiku
      • premium
      • 154 kudos
      This is awesome!
    5. mcdoge32
      mcdoge32
      • member
      • 1 kudos
      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.
    6. mcdoge32
      mcdoge32
      • member
      • 1 kudos
      PS: Thank you to MysteryMachineX for making Star the wandering courier mod, without it my playthrough wouldn't even be possible :D
    7. barame3526
      barame3526
      • member
      • 5 kudos
      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.
    8. kylemarshiku
      kylemarshiku
      • premium
      • 154 kudos
      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
    9. mcdoge32
      mcdoge32
      • member
      • 1 kudos
      I've sent you a DM with an update :)
    10. barame3526
      barame3526
      • member
      • 5 kudos
      Thank you once again, mate! Mod updated: added support for someguy2000's mods.
    11. kylemarshiku
      kylemarshiku
      • premium
      • 154 kudos
      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.
    12. barame3526
      barame3526
      • member
      • 5 kudos
      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.
    13. mcdoge32
      mcdoge32
      • member
      • 1 kudos
      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. 
    14. kylemarshiku
      kylemarshiku
      • premium
      • 154 kudos
      Perhaps redundant, just more explanatory is all, so the reader knows which target is associated with which quest. That was all.
    15. mcdoge32
      mcdoge32
      • member
      • 1 kudos
      DMed you both th3overseer's quests update so let me know if I screwed anything up.
    16. barame3526
      barame3526
      • member
      • 5 kudos
      Hey, man, great, thank you!
      Quick question, by "th3overseer quests" which ones do you mean? Or should I just put a link to his mods?
    17. mcdoge32
      mcdoge32
      • member
      • 1 kudos
      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.
    18. barame3526
      barame3526
      • member
      • 5 kudos
      It's done, my friend. I put it as v1.4
  3. demi765
    demi765
    • supporter
    • 0 kudos
    i cant figure out how to access the list
    1. barame3526
      barame3526
      • member
      • 5 kudos
      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?
  4. kylemarshiku
    kylemarshiku
    • premium
    • 154 kudos
    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.
    1. barame3526
      barame3526
      • member
      • 5 kudos
      Thank you.

      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.