| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
1 | BCB's FFRK Relic Inventory Stats and Dud Relic Finder v1.03 | ||||||||
2 | Due to Google being literal Satan Spawn and Firefox being coded by brain damaged goldfish, this sheet works best with 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 | The support for Japanese game data is limited to say the least. Use the sheet at your own peril. | |||||||
14 | 7 | Do not edit anything except the cells designed for you to edit in yellow, green or on the "User Data" sheet. | |||||||
15 | 8 | Want to share your shinies? "File > Share > Get sharable link" and spread the love. °˖✧◝(⁰▿⁰)◜✧˖° | |||||||
16 | 9 | This sheet contains my own inventory data as an example, so feel free to delete and replace it on your copy. | |||||||
17 | 10 | If you would like a spreadsheet to show your entire inventory, including Soul Breaks, Abilities, Magicite and more, go to the FFRK Soul Break, Ability and Orb Graphical Inventory linked below! | |||||||
18 | To make the Relic 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. | ||||||||
19 | Alternatively just click the "Refresh Relic Data" button at the top. Google will still probably scream at you about it though. Click "Advanced" and then allow the script to run. | ||||||||
20 | Other Sheets by /u/BaconCatBug | ||||||||
21 | BCB's FFRK Soul Breaks and Other Items Tracker | https://docs.google.com/spreadsheets/d/1aJ-y4b2-ulyEJHO2-FuH8mQkmaSrPKN04bwWHOWIFWI | |||||||
22 | Don't forget to check out the FFRK Labyrinth Peeker scripts found with the guide above! | ||||||||