Google workbook - Emmie Jacob Game Guides

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

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

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)

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+.

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+.

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.

Resources For The Last of Us Part 1 Remake

TLOU1R Grounded Resources Google Sheet

Version 5.0 Released March 9, 2023

The Resource file for TLOU1R combines parts and supplements in with the resources. This file will tell you the location of all parts, supplements, alcohol, rags, full medkits, explosives, binding, blades, full shiv, sugar, melee weapons (including hit counts available), each type of ammo, mollies, smoke bombs, bricks, and bottles. It also has additional worksheets specific to weapon locations, training manuals, and shiv doors. Resources are only valid for ng grounded settings. Not ng+. Also, it has been tested and this file does not accurately represent the 2014 remaster. Only the 2022 remake. Though remaster is pretty close.