|HOC Planning Calculator||Introduction||Using the Calculator|
|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.
|*Feel free to delete the large images if your computer/connection are too slow for them.|
|Stock and Costs||HOC Star Info||EXP Graph|
|In Armory||From Sheets||HOC Star||Pieces to reach||Total Pieces|
|Training Facility Level:||0||13||30||223|
|Name||Level||Stars||Skill 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.|
|Chart of total EXP needed to raise a HOC. Note that Level 60 (2 505 900 EXP) is the primary goal.|
|M2||0||0||1||1||1||For reference, raising a doll to level 95 takes 2 573 400 EXP.|
|AT4||0||0||1||1||1||Important Links and Info|
|QLZ-04||0||0||1||1||1||HOC Infographic and Guide||GFC Website|
Gamepress HOC page
|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!|
Special Thanks to Corsage and Cleista for all the help with the sheet.
|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.
Calc made by eTern (Discord ID eTern#4708)
Please contact in GFC Public Server for any issues regarding the sheet:
Link to Discord server