A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | GFL Ranking Automated Template Spreadsheet | 12/11/2020 | xVarz builds prototype of Ranking automated | |||||||||||||||||||||
2 | Changelog: | 19/11/2020 | Version 1.0 of Ranking automated finished | |||||||||||||||||||||
3 | By: Adamasturia and xVarz | 21/11/2020 | Added Planner sheet (W.I.P) to plan out dummy linking, modding and skill levelling | |||||||||||||||||||||
4 | ||||||||||||||||||||||||
5 | warorpeace#7149 xVarz#8404 | 10/01/2021 | Finished 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 Link | 6/1/2021 | Added 14 echelons | |||||||||||||||||||||
8 | READ INFORMATION BELOW REGARDING SHEET | |||||||||||||||||||||||
9 | GFL Ranking Map Preparation Template Spreadsheet | Changelog: | 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 |