Hogwarts Legacy: Google Workbook

This post is just a link to the Google Workbook for Hogwarts Legacy. Completed lists of field guide items, Merlin Trials, Landing Platforms, Astronomy Tables, Daedalian keys, Demiguise Locations, etc.

Hogwarts Legacy Google Workbook

The google workbook contains:

  • Version Info – This sheet details the contact information, version information, publish dates, etc for this workbook.
  • Field Guide Pages – All Field Guide pages in the game.
  • Collection Chests – All collection chest locations.
  • Conjurations – All conjurations.
  • Wand Handles – All wand handles.
  • Merlin Trials – All trials, locations, and spells to use.
  • Traits – All Traits, how to get them, and what they need for upgrades.
  • Spells – All the spells in the game and where you get them from.
  • Challenges – All of the challenges in the game and their rewards
  • Landing Platforms – All Landing Platform locations
  • Astronomy Tables – All Astronomy Table locations
  • Butterfly Locations – All 15 Butterfly locations
  • Daedalian Keys – List of all Keys and where they are.
  • Demiguise Statues – All Demiguise Statue locations.
  • Talents – All the Talents in the game
  • Quests List – List of all quests in the game
  • Finishing Touches – List of all enemies for the Finishing Touches trophy
  • Trophies – List of all trophies

Avatar: Frontiers of Pandora Google Workbook

Avatar: Frontiers of Pandora Resource Workbook

Version 1.0 Released December 8, 2023, recipe adding ongoing.
Version 2.0 Released December 15, 2023, crafting resources sheet added.
Version 3.0 Released December 23, 2023, Aeolian Wind Flute & Kite Locations added.
Version 4.0 Released December 29, 2023, Memory Paintings, Sarentu Totems, and Budding Watcher Locations added.
Version 5.0 Released January 3, 2024, Audio Logs & Notes added.
Version 6.0 Released January 7, 2024, Designs sheet & list of all Na’vi Camps and their Community Contributions lists added.
Version 7.0 Released January 9, 2024, List of Body & Face paint mural locations.
Version 8.0 Released February 4, 2024, List of all Field Labs, locations, and any notes found there.

July 16, 2024 – added Sky Breaker DLC information.

The Resource file currently contains:

  • Cooking Sheet – ingredients that I’ve encountered and what buffs they produce as well as a grid table showing the dishes made from each of the ingredients I’ve tried.
  • Crafting Resources – this lists out the basic crafting resources, their fine/superior/exquisite numbers, their bonuses, etc.
  • SB Crafting Resources – this lists out the basic crafting resources, their fine/superior/exquisite numbers, their bonuses, etc specific to the Sky Breaker DLC
  • Skills List – basic list of all of the skills and how much they cost in table format. This sheet also includes the locations of the Ancestor Skills as I come across them and the Bellsprig & Tarysu Sapling locations (touching the Bellsprig will increase your base health, Tarysu Saplings give you a skill point).
  • Aeolian Wind Flutes – this is a list of all 13 locations of the wind flutes and a link to the map.
  • Kite Locations – this is a list of the 9 kite locations from The Wind Will Carry Us side quest and a link to the map.
  • Memory Paintings & Sarentu Totems – This is a list of the 13 Memory Painting locations and the 12 Sarentu Totem locations, along with a link to the map.
  • Budding Watchers – This is a list of the 9 Budding Watcher locations and a link to the map.
  • Audio Logs & Notes – list of the audio logs and notes I’ve found so far.
  • Designs – these are all of the weapon/outfit designs I’ve found so far. DLC Information added to this as well.
  • Body & Face Paint Locations – list of the mural locations. Link to website post with map here too.
  • Na’vi Camp List – these are all of the camps and what they want for their Community Contribution list. I haven’t redone all of them, but I have redone some and they’re remaining the same so far. Will update if that changes.
  • Field Lab List – these are all of the field labs in the game, their locations, and any notes found there.
  • Trophy List – basic list of all of the trophies in table format along with any notes i found useful.

Resources for Lies of P

Lies of P Resource File Google Sheet

Version 1.0 Released November 17, 2023

The google sheets includes one worksheet per chapter, currently up to chapter 9. There’s a very good chance that’s as far as the file will go as the game is increasingly getting beyond my skill set.

Each chapter sheet contains locations of all blue drops – ergo, moonstones, consumables, throwables, etc, along with butterfly information and loot chests and collectibles.

The headers for each chapter are specific to each chapter, so if you want to combine chapters in your own copy be aware that you’ll need to make the headers match.

AC Mirage – Google Workbook

This post is a link to the Google Workbook I made for AC Mirage. It includes worksheets for all collectibles, skills, weapons, outfits, codex entries, etc. If you cannot access it, please let me know.

Assassin’s Creed Mirage Extra Stuff Google Sheet

The Google sheet holds:

  • All skills from the skill page, how many points they cost, and their description.
  • All tools and their possible upgrades.
  • One sheet per district and all notes associated with collectables – gear, enigmas, tale of Baghdad, general info for Dervis’ collectibles, general info for mysterious shard locations, all historical site locations, etc.
  • Worksheet of all outfits in the game and where to get them from.
  • Worksheet of all weapons in the game and where to get them from.
  • Worksheet of all dyes & talisman in the game and where to get them from.
  • Worksheet of all codex entries from the Historical Markers and where they were on the map.
  • Trophy list, including notes of anything not-obvious I encountered while getting them.

Under the Waves – All Crafting Blueprints Map

This map shows all the locations of all of the Crafting Blueprints (consumables, upgrades, decorations, and photo filters) for the Surfrider: Building A Better World trophy. Plus the google sheet contains the related coordinates and content for each blueprint, all collectible coordinates, and the trophy list.

Under the Waves – Crafting coordinates and contents

read more

Under the Waves – All Collectibles Map

This map shows all the locations of the Collectibles, Stickers, and Music Tapes. Plus the google sheet contains the related coordinates and content for each collectible. The sticker numbers match the sticker number. The google sheet also contains all crafting coordinates, and the trophy list

Under the Waves – Collectibles coordinates and contents

read more

Resources for Callisto Protocol

Callisto Protocol Resources File Google Sheet

Version 1.0 released April 30, 2023 (Maximum Security only)
Release for Max Difficulty and 1.0 for Hardcore released May 9 & 18, 2023
Release for Final Transmission June 30, 2023
Release for Audio files both pre and post update 1.23, as well as FT data files.

The file includes four worksheets:

  • One for main game maximum security resources
  • One for main game hardcore difficulty resources
  • One for dlc maximum security resources
  • One of main & dlc audio/data files (both pre/post update 1.23)
read more

Resources for Resident Evil Village

Resident Evil 8/Village Resources Google Sheet

Version 2.0 Released January 14, 2022

The Resources for RE8 are the same regardless of difficulty, so this file is useful for all of them. This file will tell you the location of all barrels, crates, cabinets, metal scrap, ammo, crystals, etc. Resources are only confirmed for ng, not ng+.

read more

Resources For Resident Evil 4 Remake & Separate Ways DLC

Resident Evil 4 Remake Resources Google Sheet

Version 3.0 Released April 4, 2023
Version 4.0 Released April 28, 2023
Version 5.0 Released September 23, 2023 – addition of Separate Ways DLC Resources
Version 6.0 Released September 26, 2023 – Separate Ways sheet updated to v2.0, minor additions and description cleaning.

The Resources for RE4R are the same regardless of difficulty, so this file is useful for all of them. This file will tell you the location of all barrels, crates, cabinets, briefcases, lockers, crafting resources, knives, grenades, ammo, treasure, dlc treasure, locked drawers, keys, weapons (found in the game, not bought from the Merchant), spinels (found in the game, not gotten from fulfilling requests), and mission required items. Resources are only confirmed for ng, not ng+.

read more

Resources For The Last of Us Part 2

TLOU2 Grounded Resources Google Sheet

TLOU2 Grounded Encounter Counts

Version 5.0 Released August 15, 2021

The Resource file for TLOU2 has separate sheets for resources versus parts and supplements. Ellie and Abby are separated, but individual days are not. This file will tell you the location of all parts, supplements, alcohol, rags, full medkit, molotovs, cannisters, explosives, binding, blades, melee, pistol, Revolver, Rifle, shotgun, arrows, SMG, health, Trap Mines, Smoke bombs and Bricks/bottles Resources are only valid for ng grounded settings. Not ng+

July 29. 2024 – added an Encounter Counts google workbook, an old Excel file I had from 2021 that had counts of enemies/types/weapons per encounter for part 2.

read more