ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
DATA SHEETS CONTAIN SPOILERS. USE AT YOUR OWN RISK
2
>>>PLEASE CITE THIS SHEET IF YOU WILL USE DATA ELSEWHERE<<<
3
If anyone wants to maintain this, let me know, busy with school/work
4
Introduction
5
This sheet is a WIP and may contain some mistakes. Please make a comment if there is a mistake.
6
To make a contribution, you can do one of the following.
7
1) Make a comment on this spreadsheet (everyone has comment access). Once I update the sheet with your comment I may mark it as resolved. Click the Comments button on the top right to view it again along with any replies (desktop/web only, also limited by the below restriction)
8
Sheets has a limit of 100 people editing at a time, so if you do not need to add a comment, use this link instead.
9
2) Leave a message on reddit here.
10
11
Usage Instructions & List of Tabs (Feel Free to Skip to a Specific Sheet Using the Tabs Below)
12
This sheet is not finished yet. Most sheets are usable without making a copy using ctrl+f though. If you would like to use filters, make a copy for yourself (but remember to recopy every so often to keep up to date). Filters makes it easier to find specific information, such as healer blades, pouch items to buy in Argentum, all unique monsters, etc.
13
You may ignore any sheet with a black line underneath as they are not intended for usage (WIP or Spreadsheet magic)
14
Blades, Affinity, Skills: This sheet includes information on blades and drivers, their element, weapon, favorite pouch items, location of items, field skills, etc. Pouch items take from a variety of sources (GameFAQ, Reddit, sheet linked below, personal findings)
15
Blade Stats: Mostly taken from the /XGG sheet but with the same ordering as the Blades, Affinity, Skills sheet. Split into a second sheet as I felt including it with pouch items was unwieldy. Does not include information such as strength (no impact on blades).
16
Enums: This sheet includes a considerable amount of information referenced by other sheets. The reason for putting information here is to use the Data Validation feature of Google Sheets which allows autocomplete. This ensures the same naming conventions are used in other sheets. Information here include location, shop names, combat/field skills and their descriptions. You will find notes in other sheets over specific column titles referencing the Enum sheet for more details.
17
CBM: Common Blade Management - to make it easier to sort through what common blades are available
18
Item Locations: This sheet includes where items are found, how they are unlocked, and a general description of their effects. Specific values are not provided as later items are almost always better (makes comparison easier).
19
Secret Areas: This sheet includes secret areas and how to get there.
20
Bestiary: Sheet of where all monsters are found. All areas is complete to the best of my knowledge. If I'm missing something let me know. You can use filter->Unique is True for unique monsters.
21
E2L: Addon to Bestiary which shows all locations for a given monster. Provides a different look into the Bestiary. This tab autopopulates from changes in the Bestiary tab.
22
Level V Aux Core: List of what enemies drop rank V and equivalent Legendary Aux Cores. Complete to the best of my knowledge, please let me know if I missed something. As a general rule of thumb, enemies above level 50 can drop level V Aux Cores.
23
Core Chip Locations: List of where core chips are found along with their effects (if any). The order from top to bottom is based on ingame chip strength sort order
24
CCE: Core Chip Effects: List of core chips to their effects. Avoids duplicates
25
CCD: Core Chip Damage: List of core chips to their damage/block/crit values. Avoids duplicates.
26
Salvage Spots: List of salvage spots along with their QTE pattern and notes on drop rates. Includes recommended salvage spots with best rates.
27
Arts: A list of blade type to arts when used by specific drivers. This sheet provides a view that makes it easier to compare the effects to determine who you should put a specific blade on. Standard effect names (defined in Enums) are used to make the comparison easier as well. If you are interested in details or numbers please use the Blade Arts Guide linked below in Other Useful Resources.
28
Accessories: A quick list of accessories, mostly used by myself to make selling them easier. Not intended to be inclusive.
29
Accessory Management: Simple worksheet I made to make it easier to figure what items to keep or sell since the ingame UI is terrible. You should make your own copy if you plan to use.
30
Personal Builds: Sheet for personal use. Some example builds that try to accomplish as many meta op combinations as possible (crit-heal, ether cannon, dodgetank) while maximizing for aux cores, ease of getting 8 elemental orbs, and launch-smash combos.
31
Blade Tier List: Sheet for personal use. Tier list of blades based on personal builds.
32
33
References Used
34
The following sheets were used as references. Anything not listed below is from going through the game myself.
35
Favorite Foods - If you only care about this and don't care about sorting/filtering/etc, use this sheet instead -->
https://docs.google.com/spreadsheets/d/1wxzG9dGB5ivHdc_Pq_G7T5hDXLvysh8NcZBeNeaULKk/edit#gid=0
36
Arts & Blade Stats - This sheet also includes a bunch of other information such as quest guides. Only used unique monsters/arts info
https://docs.google.com/spreadsheets/d/1EG0UpsgjhISr6_isiUpiWMU9qcXj6t8wWB0_LAiH1yE/edit#gid=936948062
37
Backup of above sheet (current one is down)
https://docs.google.com/spreadsheets/d/1mKrSAAi_sj8xpt7t8s1JGMRUh4O-e7MxAb2P_g9AWOM
38
39
Other Useful Resources
40
Blade Arts Guide - provides a more readable version if you don't plan on using filtering.
https://docs.google.com/spreadsheets/d/1-SFdq7dm-3ON4w1wOaHMBr4dEz6NnkFH21QLtDuu1qY/edit?usp=sharing
41
Quests guide
https://docs.google.com/spreadsheets/d/1HKkPoCbW0oO1JzV-hx21ueZMIjmWdboVh3vgSrlEwj4/htmlview?
42
Affinity Monster Location Worksheet
https://docs.google.com/spreadsheets/d/1t-6fkkaPyRKQY9Oel0Jwi67pXyIOqJZgEii3J8Tg3d8
43
Monster All Items Drop List
https://docs.google.com/spreadsheets/d/1FyYYaSARbKdzGAWE1WEGORYjvXMamAYPGeXwzNai9kM/edit#gid=0
44
TODO
45
Integrate Affinity Mapping spreadsheet
46
Convert CC-Math to be more readable/usable
47
Reference All Items Drop List in E2L Sheet
48
49
50
Special thanks to the community for posting info
51
52
53
54
55
56
57
58
59