I've spent far, far too long updating this while also adapting it during my own playthrough and here is the excel spreadsheet. This is (to my knowledge) the most complete checklist of missable content in this game.
Doesn't seem like another questlines are added but the order is changed a bit (probably better) and some extra notes and changes here and there at first glance
is the creator of this still active on here ? ive been busy updating this for myself :) added hyperlinks to the quest names type region subregion closest travel point and markers added in checkboxes so u dont need to type "ok" but just check them off etc and when done with the list and starting a NG+ ive added a button that will run a clear checkbox script etc if the creator of this is still active let me know man :) and ill show u what i did and maybe u can put it here aswell so people can endorse u more ! :D (i dont need credits)
here is how it looks so far am still working on it! https://prnt.sc/p40lac and https://prnt.sc/p40lku also added multiple clickable source sites for more information about the quest u wish to look at!
Latest Screenshot of the work so far taken! https://prnt.sc/p4dchs
after a few days no replies so i am just gonna share it with you all!!!
how to use: download open in excel / google sheets click on top of status columm and CTRL SHIFT Down >Insert Checkbox; cause the download will remove the checkboxes and put in false / true for some reason
then if u want the checkbox reset button to work u have to make a script with this function resetCheckBoxesAllSheets() {
var ss = SpreadsheetApp.getActive(); var allsheets = ss.getSheets(); for (var s in allsheets){ var sheet=allsheets[s]
var dataRange = sheet.getRange('B2:B'); var values = dataRange.getValues(); for (var i = 0; i < values.length; i++) { for (var j = 0; j < values[i].length; j++) { if (values[i][j] == true) { values[i][j] = false; // Modified } } } dataRange.setValues(values);
}//end of sheets loop. }// end of function...
Save it go back to the button right click it select the 3 dots and assign script and put in the function; resetCheckBoxesAllSheets
EDIT: I had to open it manually in Google Sheets. Excel won't allow the necessary stuff or I'm stupid. Sorry for the inconvenience. Once again, thanks for your hard work.
Great work, both of you!!
@Erwin1985 I'm considering starting a fresh playthrough because I failed in my previous one. And I've wanted to use your modified checklist. Can you explain step by step how to make the script and get the ''Insert Checkboxes'' in both Excel and Google Sheets? Because I can't find the ''Insert Checkboxes'' in Excel (browser), but it is in Google Sheets and to edit the modified document it requires your permission. Any way you can allow that? Would be greatly appreciated.
This is my google sheet version, wiki links are included for reference. https://www.reddit.com/r/witcher/comments/cqw0hf/witcher_3_all_quests_and_gwent_checklist/ https://docs.google.com/spreadsheets/d/1eEHcUiTUV_RUFdK75AT4zi3kA41o5vN1QMfSRF7zi3Q/edit?usp=sharing
Some quests have bold text are missable quests. Quests with underlined text have cutoff points and other conditions. Google sheet link is read only. To use checkbox, please click "File -> Make a copy" to make your own copy. To reset checkbox, high light entire column A (click on letter A) and use Space bar key.
Is this mod supposed to interact with my game or is it just an excel sheet? I don't really understand how it works. Should something pop up in game for me or should the sheet change as i progress?
Hello! First of all thank you so much for this. This is my 2nd play through and I'm sure not to miss anything. Love it!
A few things I've noticed: 1) When doing the baron main quest, you don't specify that Family Matters should be done before doing the Keira line. It goes Bloody Baron -> Keira -> Pellar, but Family Matter should be before Keira :) 2) Don't play with the gods is like impossible to do (at least on DM) in that order. I was only level 6 and the wraiths are level 15. 3) You need to complete Defenders of the faith to be able to pick-up Last rites. Last Rites is at step 32 and Defenders at step 84
I've been following the guide since the beginning, I'll let you know if I come across anything else! Thanks again.
Another thing i found is a way to have the 3rd deadly crossing spawn, you wrote in your list that you didnt get it to spawn. What you can do if you want a guaranteed spawn is to run straight to it as you enter Velen, right after leaving White Orchard. That worked for me atleast.
I also found a small "event" that is not listed afaik. In the end of "Where the Cat and Wolf Play..." you can help the little girl Millie back to her relatives in Oreton and after a few days has passed you can revisit Oreton and right at the village entrance near the fast travel sign there will be a new exclamation point. Its Mille and she will thank you for helping her and give you a drawing of Geralt and her holding hands. Super cute, i always save it through my whole playthrough and stash it in Corvo Bianco later on :)
I actually found an event that isn't in the checklist and was very surprised since it's incredibly thorough! It's a little witch hunter encounter right next to Hattori and I believe it's triggered after you burn down the witch hunter quarters in Count Reuven's Treasure. If you ever decide to update this, you can add it in so that completionists don't miss it. Thanks anyways for the great guide :)
Thanks for this one. I'm currently replaying the game again. I will look into this! I'm almost through the Baron questline and after that I'm going to novigrad ;-)
Great excel sheet I was actually reading it for my own pleasure but I was hoping that it would've worked like sky complete that auto track missions from game savefiles and then suggest the next mission by calculating lvl and mission braches if that's possible can you reply because I m tring to make your excel work with my save file (altering the mod ) but my game crashed :(
* The Redanian soldiers collecting the "War Tax" from "Event: The Price of Passage" will later threaten Gerarlt outside the house near Novigrad Gate: http://www.tivaprojects.com/witcher3map/v/#5/159.219/177.969/w=159.641,178.703 * During King's Gambit, immediately after the cutscene with Hjaalmar, there are two fist fighting events: 1. Fight a Vildakaar (spelling?) as a wager for Hjaalmar's sword. 2. After this fight, an exclamation mark appears that enables fighting with three Vildakaars, one after the other. * Follow up to "Last Rites" is an event where you can witness the ghosts talking to each other in the Blackbough cemetary at night using Keira's lamp.
Also, Geralt was attacked by three witch hunters wanting to torture him; just outside Polly's house; during "Cabaret". The conversation explicitly mentioned the fact that the witch hunters' headquarters had been burnt earlier. This probably means that this event can trigger only after "Count Reuven's Treasure". This is the first time I've experienced this event, which makes me think that it could be due to having saved Moritz in this playthrough.
82 comments
here is how it looks so far am still working on it! https://prnt.sc/p40lac and https://prnt.sc/p40lku also added multiple clickable source sites for more information about the quest u wish to look at!
Latest Screenshot of the work so far taken! https://prnt.sc/p4dchs
after a few days no replies so i am just gonna share it with you all!!!
https://drive.google.com/open?id=1ghpVSkim8txorbH-TA285XwhIyQMGbcV
how to use:
download open in excel / google sheets
click on top of status columm and CTRL SHIFT Down >Insert Checkbox; cause the download will remove the checkboxes and put in false / true for some reason
then if u want the checkbox reset button to work u have to make a script with this
function resetCheckBoxesAllSheets() {
var ss = SpreadsheetApp.getActive();
var allsheets = ss.getSheets();
for (var s in allsheets){
var sheet=allsheets[s]
var dataRange = sheet.getRange('B2:B');
var values = dataRange.getValues();
for (var i = 0; i < values.length; i++) {
for (var j = 0; j < values[i].length; j++) {
if (values[i][j] == true) {
values[i][j] = false; // Modified
}
}
}
dataRange.setValues(values);
}//end of sheets loop.
}// end of function...
Save it go back to the button right click it select the 3 dots and assign script and put in the function; resetCheckBoxesAllSheets
after that all done happy questing!
Great job on the checkboxes. I'll look into uploading it in this format.
Great work, both of you!!
@Erwin1985
I'm considering starting a fresh playthrough because I failed in my previous one. And I've wanted to use your modified checklist. Can you explain step by step how to make the script and get the ''Insert Checkboxes'' in both Excel and Google Sheets? Because I can't find the ''Insert Checkboxes'' in Excel (browser), but it is in Google Sheets and to edit the modified document it requires your permission. Any way you can allow that? Would be greatly appreciated.
https://www.reddit.com/r/witcher/comments/cqw0hf/witcher_3_all_quests_and_gwent_checklist/
https://docs.google.com/spreadsheets/d/1eEHcUiTUV_RUFdK75AT4zi3kA41o5vN1QMfSRF7zi3Q/edit?usp=sharing
Some quests have bold text are missable quests.
Quests with underlined text have cutoff points and other conditions.
Google sheet link is read only. To use checkbox, please click "File -> Make a copy" to make your own copy.
To reset checkbox, high light entire column A (click on letter A) and use Space bar key.
Could you elaborate a little bit more, thanks.
A few things I've noticed:
1) When doing the baron main quest, you don't specify that Family Matters should be done before doing the Keira line. It goes Bloody Baron -> Keira -> Pellar, but Family Matter should be before Keira :)
2) Don't play with the gods is like impossible to do (at least on DM) in that order. I was only level 6 and the wraiths are level 15.
3) You need to complete Defenders of the faith to be able to pick-up Last rites. Last Rites is at step 32 and Defenders at step 84
I've been following the guide since the beginning, I'll let you know if I come across anything else! Thanks again.
What you can do if you want a guaranteed spawn is to run straight to it as you enter Velen, right after leaving White Orchard. That worked for me atleast.
In the end of "Where the Cat and Wolf Play..." you can help the little girl Millie back to her relatives in Oreton and after a few days has passed you can revisit Oreton and right at the village entrance near the fast travel sign there will be a new exclamation point. Its Mille and she will thank you for helping her and give you a drawing of Geralt and her holding hands.
Super cute, i always save it through my whole playthrough and stash it in Corvo Bianco later on :)
La Cage quest and forgot the quest.
* The Redanian soldiers collecting the "War Tax" from "Event: The Price of Passage" will later threaten Gerarlt outside the house near Novigrad Gate: http://www.tivaprojects.com/witcher3map/v/#5/159.219/177.969/w=159.641,178.703
* During King's Gambit, immediately after the cutscene with Hjaalmar, there are two fist fighting events:
1. Fight a Vildakaar (spelling?) as a wager for Hjaalmar's sword.
2. After this fight, an exclamation mark appears that enables fighting with three Vildakaars, one after the other.
* Follow up to "Last Rites" is an event where you can witness the ghosts talking to each other in the Blackbough cemetary at night using Keira's lamp.
Also, Geralt was attacked by three witch hunters wanting to torture him; just outside Polly's house; during "Cabaret". The conversation explicitly mentioned the fact that the witch hunters' headquarters had been burnt earlier. This probably means that this event can trigger only after "Count Reuven's Treasure". This is the first time I've experienced this event, which makes me think that it could be due to having saved Moritz in this playthrough.