ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
About (= "corpotalk bullshit" I wrote while pretending to be an AI ghost writer for a fake PC helpline site, I feel gross now):
2
We use many tools to help with farming materials, mostly to know what to farm and where to farm it. However none of them account for the surge of specific materials we get during every event. ("no shit sherlock", amerite?) I made this tool to be able to include event gains when planning farming, because (for example) sometimes waiting for a few weeks to get mats you need from event shop (for "free") could let you use your stamina to farm other things that this near-ish event won't give.
3
4
Now with:
5
events from "Re:Il Siracusano" up to "Ep. 14 - 5th/4.5th Anniversary"
6
20% more rock-cancer!
7
8
Make a copy for personal use:
9
Google Drive: [AqVR] Arknights - Gamepress Operator Planner - Supplement - Event Gains Calculator.xlsx
10
11
Gamepress import/export instructions:
12
Copy-paste your "inventory" data from Gamepress Operator Planner into column A [A3-A92].
13
Open "Data > Text to Columns"; pick Delimiters; tick Comma; press Next and Finish; to separate numbers from text into column B. [slightly different outside of Microsoft Office]
14
Set Multipliers on events [row 2], depending on your needs [but obviously only -1, 0 or 1].
15
Drag-select and copy-paste values from column G [G3-G92] back into Gamepress inventory.
16
OPTIONAL: Drag-select and copy-paste values from column H [H3-H92] into Gamepress inventory to regain original inventory in case you saved new values in GG.
17
18
Penguin-stats.io export:
19
Copy-paste your "inventory" data from Gamepress Operator Planner into column A [A3-A92].
20
Open "Data > Text to Columns"; pick Delimiters; tick Comma; press Next and Finish; to separate numbers from text into column B.
21
Set Multiplier on events, depending on your needs [but obviously only -1, 0 or 1].
22
Open https://penguin-stats.io/planner and click IMPORT/EXPORT.
23
OPTIONAL: make a backup of data under Share Configuration Profile in case you could miss it!
24
Copy data from cell G1-with event gains added / H1-original from GP, and paste under Import from Configuration Profile.
25
Click IMPORT.
26
Enter your preferred values under "Need:", because they will "reset" to 0.
27
28
Moving inventory from Gampress to Krooster:
29
open sheet "Krooster CSV <-> Gamepress"
30
Sort by H (ascending), paste inventory copied from Gamepress into I3, separate it by "," into columns.
31
Sort by A (ascending), copy data from G2-G83
32
Open Krooster Planner; "Export/Import Data"; Import format -> CSV
33
Paste data from G2-G83, click "import data".
34
35
Moving inventory from Krooster to Gamepress:
36
open sheet "Krooster CSV <-> Gampress"
37
Sort by A (ascending), paste inventory exported from Krooster in CSV format into A3, separate it by "," into columns.
38
Sort by H (ascending), copy data from E3-E92.
39
Paste into Gamepress. [EXP cards aren't present in Krooster, you have to add manually]
40
41
Notes:
42
Placeholder +100 added to farmable materials. Change it below the main table if you want.
43
Values that would be "0" have been removed, hopefully it's more readable like this.
44
New items in Intelligence Shop (certs from event reruns) included in separate columns next to reruns.
45
I doubt my skills to make an easy makro to import mats inventory from penguin-stats.io, or combine your old "Need:" with GG inventory import. First move your old inventory data from Penguin to Krooster, than follow instructions above.
46
If GGOP allowed to export "Total Materials Required" list, I could use it to fill in penguins-stats.io's "Need:" field.
47
48
MADE BY:
49
AquariusViaRainbow [~7.58% gay, fr]
50
aquariusviarainbow[at]tutanota.com, do not stalk, pls, UwU
51
[the G-mail is just for sharing stuff via Drive, I don't really use it myself, I'm allergic to Google]
52
aquariusviarainbow(#7862), no spam pls
53
krooster.com/u/AqVR5235 "f2p btw" ;)
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
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