ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Introduction
2
Original Sheet Link:
3
https://docs.google.com/spreadsheets/d/1ERxAldWbUf17GTGnRmbU9GucrGUtrtflBhfv8FcAtyk
4
5
Original Sheet by:
6
/u/Pinguino21v
7
8
Updated and Maintained by:
9
/u/throwawaypuntocom
10
Available for feedback
11
12
Notes:
13
It is highly recommended to make a copy of this doc for your personal use. To do so: under File menu select "Make a copy". This should only serve as an original template, and to update the skills to your own doc.
14
15
To update your copy, go to the original skills tab and select all, copy, then go to your skills tab, select all, paste.
16
17
Bear in mind that most data is based on Enlir's, and ability names may chance from JP to GL, so when importing the skills, you may have to go back and reselect certain abilities in your "Orb planning".
18
19
Skills data coming from:
20
Enlir's FFRK Database
21
http://happypluto.com/~misterp/r/ffrk.pdf
22
23
Crystal Tracker by /u/thatrpgmakerfreak
24
https://docs.google.com/spreadsheets/d/1ij-_qiEQm63iXhEZS6UlLVLOkF3Qkp_kzSztnqUDQLk/edit?usp=drivesdk
25
26
Future events
27
https://docs.google.com/spreadsheets/d/1azHSTIrUrIwHEF01QOHfjCia89-NKTqskPrxcntNxA0/edit#gid=0
28
29
Mythril planner
30
https://docs.google.com/spreadsheets/d/1YRvKQZr6SpknY_7r80LgFSwurX_96n-x4S2jhycqd8Q/edit
31
Original Orb planner
32
https://docs.google.com/spreadsheets/d/1diHYPkeDfAQqNRCEPtyEbsEScncpgDxdy2VC9PcPidg/edit
33
34
35
Instructions:
36
37
Plan your orb usage
38
How to add a skill in your plan:
39
- Insert a row anywhere in the "Orb planning" table with a right clic on the row number
40
- Select the skill in the 1st column (A)
41
- Select a level to hone (initial level - goal level) in the 4th column (D)
42
- Check the 5th column (E) to take the skill into account for the total required
43
44
How to calculate the number of orbs you're lacking of:
45
- Change the number of 3*, 4* and 5* orbs you currently have at the bottom of the "Orb planning" table
46
47
48
Edit parameters of the sheet
49
How to add a skill in the available skills list:
50
- Insert a row anywhere in the "Skills" table with a right clic on the row number
51
- Complete A to O columns. Don't forget the "stars" column, it's used in calculation.
52
- D to O columns are orb costs like mentionned in MisterP's PDF. That list is reproduced in "Orb param" tab
53
- P column display a "/!\" if there's not 2 or 3 costs in the row
54
- Update "Skills" named range if it's not
55
56
How to add a school in the available schools list:
57
- Insert a row anywhere in the "Orb param" table with a right clic on the row number
58
- Update "Schools" named range if it's not
59
60
How to add an orb cost in the available orb cost list:
61
- Copy the 15 rows of any existing orb cost and paste it at the end of the table in "Orb param" tab
62
- Change the 5 first value in the 3rd column (white cells) only, others are calculated
63
- Update "OrbCosts" named range
64
65
Warning when inserting data
66
When you insert a new row, be careful, calculation, select lists and cell styles can break if you don't do this from a row having all of this.
67
Add elements somewhere inside the table or by selecting the last empty row. Let the last empty row still.
68
Schools, skills, hones and orb costs are set as "named range" (see data menu, "Schools", "Skills", "Hones" and "OrbCosts").
69
These named ranges are used to create select lists everywhere in the sheet.
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100