ABCD
1
VersionDateNotesLinks
2
Remember you need to download or copy the document before using it!
Toolbar -> File -> Make a copy/Download
This way you'll be able to change cell values in your own copy.
Please DO NOT use cell comments to mark your progress by writing something like Y/N/Done/Yes/No, those are for feedback.		Link to main google sheet
(If you're using web view or need a link to the main document use this)
3
Comments are open to everyone feel free to make suggestions or suggest fixes. Check the feedback and todo page first.Link to web view
(Page loads much faster but CAN'T be copied or edited! Useful if you just want to use it as a refrence)
4
1.111/10/2024Added perks gained from quests.
Minor formatting changes and corrections
5
1.0 (finally)11/07/2024Added Anniversary Edition (CC) Quests. Added the percentages to track quests progession.
Added Aniversary Edition (CC) Spells, Enchanting Effects, Alchemy ingrediants and Locations
Alchemy Tab has been reorganized and list ingrediants effect duration and value multipliers if they have one. Also lists if the ingrediant is growable and how many are harvested this way
Redid the formulas a bit so thay should be fine if you delete any Aniversary Edition content. I probably made some mistakes let me know if you see any.
6
09/07/2021Added some quest items that can be pickpocketed back after completion.
7
09/05/2021Unique horses added to Followers tab
Fjola's Wedding Band added to Vanilla uniques
Filters for sorting added
8
08/30/2021Minor fixes to books tab. Added notes to a couple books with two versions
Added notes to quest books that can be pickpocketed back
Changed name of the book "The "Madmen" of the Reach to contain quotes
Smithing perks notes fixed
Fixed a lot of misprints on the Enchantments tab
9
8/25/2021Added perk trees for Werewolf and Vampire Lord
Bone hawk ring and amulet are removed from unique gear - craftable
Enchanted ring added again to vanilla Uniques since its optional to turn it in for a quest.
Layout of Perks tab changed to be more convenient.
Conditional formatting fixed across the whole spreadsheet.
Y/N changed to checkboxes on every tab except Quest because it needs to be redone anyway.
Books type column fixed, skill books and spell tomes style changed for better sorting
About 25 empty descriptions filled in in Books tab.
Multiple link errors fixed and all of them are verified plus consistent now on all tabs except quests
10
8/22/2021Removed Enchanted ring from vanilla Uniques - quest item
Removed Chrysamere from vanilla Uniques - CC content
Removed Tandil's Staff from vanilla Uniques - quest item
Zephyr and Talor Dreth's robes are moved to Dawnguard Uniques
Mutually exclusive items are now marked
Added following list of vanilla uniques:
https://pastebin.com/PZKAsnFa
Added following Dawnguard uniques:
Akaviri Sword
Staff of Ruunvald
Vampire Royal Armor
Bone Hawk Ring
Bone Hawk Amulet
Added following Dragonborn uniques:
Ancient Nordic Pickaxe
Unique Gear tab added to Dashboard
11
8/21/2021Added 5 paragons to Collectables tab
Added following list of misc collectables :
https://pastebin.com/WPE38dbh
Collectables tab added to Dashboard
12
8/18/2021Fixed some minor formatting issues
Fixed spell location column
Added missing tome ids for DLC spells
13
8/15/2021Civil war locations are separated from the main list
All fast travel markers verified
Location added:
The Chill
Skuldafn
Minor style and error fixes
Formulas for locations tab replaced.
Locations and Merchants tabs added to dashboard.
Added "List" column to the Books tab with link to an explanation
14
8/13/2021Removed duplicate book:
Diary of Faire Agarwen
Removed unobtainable books:
Gallus's Journal
The Secrets of Ragnvald
Tolfdir's Book
Unsent Afflicted Letter
Added 3 Elder Scrolls as quest books
Following list of books moved to quest books:
https://pastebin.com/RwnZMCNK
Fixed links to DG spell tomes
Fixed style on books tab
Removed Jarrin root from alchemy ingridients due to it being unique quest item.
Added following spells:
Summon Unbound Dremora
Arniel Convection
Summon Arniel's Shade
Added prototype of the Dashboard tab with optional tracking.
Requires testing and fixing other tabs to be fully complete
15
8/2/2021Fixed incorrect spell levels
Added missing spell Vision of the Tenth eye
Added missing location East Empire company Warehouse
Added 7 missing unique items. Theres probably more I didn't catch
Added missing book Children of the All Maker
Removed duplicate book The "Madmen" of the Reach
Added a hidden quest Archery Practice given by Angi in outside Falkreath
16
0.53/28/2021Added missing Dragonborn and Dawngaurd books
Marked some book which must be turned in for quests
17
3/17/2021Added numbering to spell levels to make sorting easier
Marked spells that all races start with as already collected
Added missing location quest for Lair's retreat
Fixed a few typos and some cleanup on quest tab
Moved a couple quests to the correct location
18
1/30/2021Fixed some typos, errors in book count formulas, and 1 missing book, slight formatting changes
19
0.49/21/2020Finished adding all missing DLC spells and spell tomes
20
5/31/2020Finished adding links to Quest tab
21
5/20/2020Corrected two locations which are not on the map
Added Hunter's rest and Raven Rock Mine to locations
22
5/8/2020Added missing Nightingale armor pieces to Unique Gear
23
5/2/2020Added missing unique item Staff of Jerik Gaudurson
Added some items to gather to the lists in quest tab
Fixed conditional formatting on quests tab
24
4/28/2020Added links to: spells tab, followers tab, shouts tab, alchemy ingrediants tab, merchants tab
Removed two duplicate Unique items
25
0.34/26/2020Added spell tomes and links to Books sheet
Fixed error in read books formula
More edits for consistancy
Added formula and conditional formatting for total thieves guild jobs.
26
4/24/2020Added two missing Inns to the list of locations
Fixed some slight errors in formulas
27
0.24/13/2020Made a few modifications for consistancy
Added Merchants tab
28
0.19/26/2018First Releaselink to original version (mostly here for crediting the original work)