HOC Planning Spreadsheet - Shared
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJ
1
2
3
HOC Planning CalculatorIntroductionUsing the Calculator
4
5
The primary goal of this sheet is to allow easy visualization and organization of data, combat report, and battery requirements to raise HOCs. Enter the appropriate data in each of the dark blue filled cells, and the sheet will take care of the rest.

Each HOC has its own page, and the information will also be summarized on the frontpage (this page!).

Detailed instructions for use are in the box on the right.

Recommended HOC Skill Levels are preset for BGM-71, AGS-30, and 2B14. Adjust as desired.
1) Input the number of Special Combat Reports, Batteries, and each type of Data currently in your armory in the dark blue cells in the Stock and Costs table. Enter your current HOC feed station level in the box directly under that table.
2) For each HOC page in the tabs at the bottom of the page, enter relevant info into each dark blue cell. Current Level denotes the current level (or skill level) you have attained, and the desired/goal level denotes to which level you plan to raise the HOC's level or skill level.
3) Once the info is entered, it will display the Battery, Special Combat Report, and Data requirements for the goal you entered. This is displayed for each individual HOC on its respective page, and is summed into the Stock and Costs box in the From Sheets column.
3a) On the frontpage, Cost displays the total number of a given resource you need to reach the goals you
defined. It is the total from all the individual HOC pages.
3b) Batteries get more Cost rows, because they get spent in several ways. Feed Cost is the number
spent to increase a HOC's level. Reports is batteries spent creating Special Combat Reports. Skill Cost
is batteries spent increasing the skill level of the HOCs.
3c) The Need rows indicate how many more of a resource you need outside of what's already inside your
armory. It is a simple subtraction of the amount in your armory from the total cost. The number will be
green if you have a sufficient amount, and orange if you are lacking.
4) The HOC Stats table summarizes the info from the other pages so it can all be seen at one time. Please do not type in that table.

If the sheet is not working, first make sure you didn't accidentally type into a non-dark-blue filled cell, then check that your inputs make sense. For example, you cannot have a HOC at level 25 and set level 19 as the goal.
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
*Feel free to delete the large images if your computer/connection are too slow for them.
23
Stock and CostsHOC Star InfoEXP Graph
24
25
In ArmoryFrom SheetsHOC StarPieces to reachTotal Pieces
26
0
Cost0155
27
Need021015
28
0
Feed Cost031530
29
Reports042050
30
Skill Cost207053080
31
Need20706585
32
0
Cost72007893
33
Need7200810103
34
0
Cost3000915118
35
Need30001020138
36
0
Cost01125163
37
Need01230193
38
Training Facility Level:01330223
39
HOC Stats1430253
40
1530283
41
NameLevelStarsSkill Levels"Stars" 6-15 are "Red Stars" or "Iterations". Beyond 5 stars, Data Patches are used to increase rarity. Visit the HOC guide link below for more info.
42
123
43
BGM-7100111
44
45
AGS-3000111
46
47
2B1400111
48
Chart of total EXP needed to raise a HOC. Note that Level 60 (2 505 900 EXP) is the primary goal.
49
M200111For reference, raising a doll to level 95 takes 2 573 400 EXP.
50
51
AT400111Important Links and Info
52
53
QLZ-0400111HOC Infographic and GuideGFC Website
54
Gamepress HOC page
55
Please do not type in the "HOC Stats" boxes. They're here for a visual summary of the other pages. Enter data on each respective HOC page!
56
57
58
Special Thanks to Corsage and Cleista for all the help with the sheet.
59
As of Jan. 2020, M2, AT4, and QLZ-04 are not on the EN server. Please wait for them patiently.
Battery, Special Combat Report, and Data sprites from EN GFWiki.
60
61
Calc made by eTern (Discord ID eTern#4708)
62
Please contact in GFC Public Server for any issues regarding the sheet:
Link to Discord server
63
64
65
Loading...