F/GO Servant Planner
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQ
1
2
3
Fate/Grand Order
4
Servant Planner
5
6
7
WHAT IS THIS
8
9
This is an automated spreadsheet to track your servant progress and show you how much XP, QP and materials you still need. You can also track your inventory, as well as items you can potentially obtain from future events.
10
11
INSTRUCTIONS
12
13
1.
Create your own copy of this spreadsheet (File -> Make a Copy)
14
2.
Go to the Control Panel tab and fill out your servant information
15
3.
Data will magically appear on the other tabs
16
4.
Roll gacha
17
18
Besides Control Panel, the only other places you should modify are:
19
-Priority Filter settings on tabs that have them, where you can filter servant data by the priority tags you've assigned them
20
-Eventory tab, where you can enter your owned items and toggle events on or off
21
-Overview tab's top toolbar, where you can include/exclude data from other tabs (same with Overview-Lite)
22
23
TLDR if there's a drop-down menu you can modify it
24
25
TAB EXPLANATIONS
26
27
OverviewSummary page for materials, XP and QP from all other tabs. Note that the summary data is affected by the priority filters set on those tabs.
28
Overview-LiteSame as Overview but more compact and less garish.
29
LevelingShows amount of XP (and number of 4* XP cards) and grails needed for each servant.
30
AscensionAscension mats needed for each servant.
31
Skill UpSkill up mats needed for each servant.
32
EventoryRecord your current inventory here. Also lists anticipated mats from future NA events, which can be added to your item count automatically.
33
34
FAQS
35
36
>Do I need to re-download this every time a new servant comes out?
37
Nope. Servant data is imported from an external sheet that I maintain. So long as that sheet is up-to-date, you will have the latest servant data. However, you will need to update if new items are introduced.
38
>Why do I see a brown row or column?
39
Brown-colored cells are meant to be hidden, so ya dun goofed and accidentally un-hid them. To undo, either Ctrl+Z or right-click the offending row or column and click "Hide Row/Column".
40
>I'm getting errors in parts of my sheet?
41
Refreshing the page will usually solve the issue. If the errors persist, just trash it and make a fresh copy from the source spreadsheet (link below).
42
43
KNOWN QUIRKS
44
45
-QP totals do not include the cost to feed XP cards, which varies depending on how many XP cards are used at a time.
46
-Angra Mainyu shares ascension levels and QP costs with 2★ servants, so he's labeled as a 2★ in this sheet.
47
-Materials that didn't exist in NA at the time of this planner's creation are stuck with their fan-translated names. (Changing them to the official names would break the sheet)
48
-To avoid formula bloat, you are limited to 64 servant entries. Sumanai.
49
50
RESOURCES
51
52
CirnopediaOfficial Site News
53
FGO WikiaLink to Source Spreadsheet
54
grandorder.wiki
55
56
CHANGELOG
57
58
v1.62/23/2019Added events to end of 2019, added event links
59
v1.5.19/13/2018Added custom multiplier to events with lottery boxes
60
v1.5
8/28/2018Added events up to next summer, rearranged item order
61
v1.4.1
5/15/2018Fixed errors in Rashoumon event items
62
v1.4
5/1/2018Added new items Permafrost and Volatile Gunpowder
63
v1.3
1/6/2018Added inventory column to NA Events tab (now Eventory)
64
v1.2
1/3/2018Switched ServantDB to use imported data instead of static entries
65
v1.1
1/3/2018Fixed inaccurate grail count for 2* servants
66
v1.0
1/2/2018Initial public release, DB updated to #198 (Katsushika Hokusai)
67
68
CREDITS
69
70
Spreadsheet creator
neonBarnacle
71
Main servant data
grandorder.wiki
72
Event data
Cirnopedia, FGO Wikia
73
Material images
FGO Wikia
74
Other images
Riyo, /fgoalter/
75
76
Report any bugs, issues, or feedback to:
77
neon.barnacle@gmail.com
78
79
80
81
Loading...
Main menu