ABCDEFGHI
1
BCB's FFRK Soul Breaks and Other Items Tracker v1.03
2
Due to Google being literal Satan Spawn and Firefox being coded by brain damaged goldfish, this sheet works best with Chromium or Google Chrome
I cannot guarantee it works in anything else
3
YELLOW CELLS ARE EDITABLE SORTING OPTIONS, DESPITE THE TAB ITSELF BEING PROTECTED
4
GREEN CELLS ARE EDITABLE FILTER OPTIONS, DESPITE THE TAB ITSELF BEING PROTECTED
5
Your Copied Version: 1.03
Current Master Version:
1.03
6
This sheet was created by /u/BaconCatBug. BaconCatBug#0294 on Discord.
Special thanks to:
/u/vexnon for making the original mitmproxy scripts.
/u/Gitpush1337 for an expanded drop database csv file.
/u/csdx for informing me of the =Query() formula.
/u/cinaeth for troubleshooting an annoying bypass list issue.
/u/Eiim for help with the database update script.
/u/ericwars for saving this project entirely when Google decided to just corrupt my master sheet and not let me restore a backup.
And most importantly, /u/enlir and /u/MysteriousMisterP. These folks literally made the game playable and are sorely missed.
If you have any questions or issues with the sheet feel free to message me on Discord or Reddit.
7
1
Use FFRK Drop Tracker to export your inventory.
8
Release and Support Thread
https://redd.it/qsfwpk
9
2Make a copy of this sheet to your drive by clicking "File > Make a Copy"
10
3Delete the example data from the "User Data" sheet by selecting the data columns and pressing Delete, or use the script in the top bar.
11
4Open the export .txt in Notepad.
12
5Ctrl+A to select all the data, Ctrl+C to copy it, then click the appropriate top left cell on the "Raw User Data" sheet, then Ctrl+V to paste the data.
13
6Configure the correct settings in the yellow dropdowns on the "User Data" sheet.
14
7The support for Japanese game data is limited to say the least. Use the sheet at your own peril.
15
8Do not edit anything except the cells designed for you to edit in yellow, green or on the "User Data" sheet.
16
9Want to share your shinies? "File > Share > Get sharable link" and spread the love. °˖✧◝(⁰▿⁰)◜✧˖°
17
10This sheet contains my own inventory data as an example, so feel free to delete and replace it on your copy.
18
11
If you would like a spreadsheet to show your relic stats, including synergy, go to the FFRK Relic Inventory Stats and Dud Relic Finder linked below!
19
To make Enlir's data refresh automatically, you need to go to Tools > Script Editor, click the Clock Icon, click "Add Trigger", and set it to a weekly trigger at Monday Midnight. There is no way for the triggers to copy over automatically sadly. Google will scream at you that the app is "unauthorised", but ignore it.
20
Alternatively just click the "Refresh Database" button at the top. Google will still probably scream at you about it though. Click "Advanced" and then allow the script to run.
21
Other Tools by /u/BaconCatBug
22
BCB's FFRK Relic Inventory Stats and Dud Relic Finder
https://docs.google.com/spreadsheets/d/14Ixd6C4EQqmUb7bhZTkQnjkJU-nr7TkRGJDNN2RaWtk/
23
Don't forget to check out the FFRK Labyrinth Peeker scripts found with the guide above!