ABCDEFGHIJKLMNOPQRSTUVWX
1
GFL Ranking Automated Template Spreadsheet12/11/2020xVarz builds prototype of Ranking automated
2
Changelog:19/11/2020Version 1.0 of Ranking automated finished
3
By: Adamasturia and xVarz21/11/2020Added Planner sheet (W.I.P) to plan out dummy linking, modding and skill levelling
4
5
warorpeace#7149 xVarz#840410/01/2021Finished Planner sheet, with modding and fairy skill levelling, version 1.1
6
Credits for Corsage and eTern for making the original Spreadsheet
7
Template Spreadsheet Link6/1/2021
Added 14 echelons
8
READ INFORMATION BELOW REGARDING SHEET
9
GFL Ranking Map Preparation Template SpreadsheetChangelog:4/21/2019
Started this changelog PepeLaugh
10
By: Corsage and eTern
Added SL2 column in "Dolls & Fairies" sheet
11
corsage#0001 eTern#4708
Added "Doll List" drop-down list in "Dolls & Fairies" sheet
12
Discord Server Link
Added "Echelon Overview" sheet
13
Twitch: twitch.tv/corsage_ twitch.tv/eTern_gfl
Added basic instructions in "Introduction" sheet
14
Original Template Spreadsheet Link
15
5/6/2019
Added a few instructions to "Introduction" sheet
16
PLEASE READ !!!
PLEASE READ !!!
PLEASE READ !!!
PLEASE READ !!!
Added "SL" feature for fairies in "Echelon Overview" sheet
17
Make your own copy of this spreadsheet and get grinding, you degens
5/21/2019
Fixed bug with Echelon 9 on "Equipment" sheet
18
Click on "File" on the top left options, and "Make a copy..." in the drop-down menu.
6/12/2019
Added my Singularity teams on "Introduction" sheet
19
Please report bugs to me through my Discord server or a Discord DM.
7/7/2019
Fixed text alignment for SL in "Echelon Overview" sheet
20
I think an example of this spreadsheet in use will help you.
DD Rankings - Corsage
Singu Rankings - Corsage
21
Do NOT use only numbers to specify a doll. For instance, enter "HK416" instead of "416" and "Five-seven" instead of "5-7".
22
Do NOT copy-paste cell values. It will also copy special formatting and will likely fuck up the sheet.
23
24
Instructions:
25
Dolls & Fairies:
26
- This is where you input all your dolls and fairies (or at least the ones you think you may use).
27
- Make sure you delete all of my imaginary Px4s and input each column with dolls/fairies from your armory.
28
- When you decide to place a unit in an echelon, put its echelon number on the "#" column.
29
- Don't put more than five of each number (1~10) in the "#" column. It will probably break the sheet LUL
30
- Dolls will be listed in the "Dolls List" drop-down list on the left, to help you track the dolls in each echelon.
31
- Choose your echelon formation with the dolls in the "Dolls List". This must be done manually by you.
32
- Fairies will automatically be set in the echelon formations with their matching echelon number from the "#" column.
33
34
Equipment:
35
- After you create your echelons, its dolls will automatically be listed in their respective echelons in the "Equipment" sheet.
36
- Enter the equipment you will be using on each doll. Note the delimiters [] and () for 4* and optional gear, respectively.
37
- Enter your current 5* equipment count in the "Current 5*" column.
38
- Do note that special equipments will not be listed in the "lacking equipment" table.
39
40
Echelon Overview:
41
- This will automatically be populated if you have correctly populated the previous two sheets.
42
- Do NOT modify this sheet.
43
- This sheet is meant to neatly display your echelons in a digestible form for your convenience.
44
45
46
47
48
49