A | B | C | D | E | F | G | H | I | |
---|---|---|---|---|---|---|---|---|---|
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 | 2 | Make a copy of this sheet to your drive by clicking "File > Make a Copy" | |||||||
10 | 3 | Delete 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 | 4 | Open the export .txt in Notepad. | |||||||
12 | 5 | Ctrl+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 | 6 | Configure the correct settings in the yellow dropdowns on the "User Data" sheet. | |||||||
14 | 7 | The support for Japanese game data is limited to say the least. Use the sheet at your own peril. | |||||||
15 | 8 | Do not edit anything except the cells designed for you to edit in yellow, green or on the "User Data" sheet. | |||||||
16 | 9 | Want to share your shinies? "File > Share > Get sharable link" and spread the love. °˖✧◝(⁰▿⁰)◜✧˖° | |||||||
17 | 10 | This 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! |