Event Gains Calculator [2023.11] - for Gamepress Operator Planner & krooster.com/penguin-stats.io

#Arknights #mArknights #gaming

About:

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.
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.
preview
.

Now with:

• krooster.com/penguin-stats.io inventory conversion
• added events from "Trials for Navigator #3" / "Ideal City Rerun" up to "Zwillingstürme im Herbst"
• NEW™ materials debuting in Ep. 13
• NEW™ made a "changelog", kek
• 20% more rock-cancer!
  .

Make a copy for personal use:

Skiff (OpenSource Mail): [AqVR] Arknights - Gamepress Operator Planner - Supplement - Event Gains Calculator.xlsx
Google Drive: [AqVR] Arknights - Gamepress Operator Planner - Supplement - Event Gains Calculator.xlsx
.

Gamepress import/export instructions:

• Copy-paste your "inventory" data from Gamepress Operator Planner into column A [A3-A92].
• 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]
• Set Multipliers on events [row 2], depending on your needs [but obviously only -1, 0 or 1].
• Drag-select and copy-paste values from column G [G3-G92] back into Gamepress inventory.
• 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.
  .

Penguin-stats.io export:

• Copy-paste your "inventory" data from Gamepress Operator Planner into column A [A3-A92].
• Open "Data > Text to Columns"; pick Delimiters; tick Comma; press Next and Finish; to separate numbers from text into column B.
• Set Multiplier on events, depending on your needs [but obviously only -1, 0 or 1].
• Open https://penguin-stats.io/planner and click IMPORT/EXPORT.
• OPTIONAL: make a backup of data under Share Configuration Profile in case you could miss it!
• Copy data from cell G1-with event gains added / H1-original from GP, and paste under Import from Configuration Profile.
• Click IMPORT.
• Enter your preferred values under "Need:", because they will "reset" to 0.
  .

Moving inventory from Gampress to Krooster:

• open sheet "Krooster CSV <-> Gampress"
• Sort by H (ascending), paste inventory copied from Gamepress into I3, separate it by "," into columns.
• Sort by A (ascending), copy data from G2-G83
• Open Krooster Planner; "Export/Import Data"; Import format -> CSV
• Paste data from G2-G83, click "import data".
  .

Moving inventory from Krooster to Gamepress:

• open sheet "Krooster CSV <-> Gampress"
• Sort by A (ascending), paste inventory exported from Krooster in CSV format into A3, separate it by "," into columns.
• Sort by H (ascending), copy data from E3-E92.
• Paste into Gamepress. [EXP cards aren't present in Krooster, you have to add manually]
  .

Notes:

• Placeholder +100 added to farmable materials. Change it below the main table if you want.
• Values that would be "0" removed, hopefully it's more readable like this.
• New items in Intelligence Shop (certs from event reruns) included in separate columns.
• 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 inventory data from Penguin to Krooster, than follow instructions above.

If GGOP allowed to export "Total Materials Required" list, I could use it to fill in penguins-stats.io's "Need:" field.
.

MADE BY:

AquariusViaRainbow [~7.58% gay, fr]

• aquariusviarainbow@tutanota.com, do not stalk, pls, UwU
• [the G-mail is just for show, I don't really use it myself, I'm alergic to Google]
• u/AquariusViaRainbow, don't message me there, I'm out, fuck spez
• aquariusviarainbow(#7862), no spam pls
• krooster.com/u/AqVR5235 "f2p btw"
  .

CHANGELOG:

2022.12.24:

• first version
• events from "Lingering Echoes" up to "Nearl Light Rerun" [probably]

2023.02.10:

• added events up to "Where Vernal Winds Will Never Blow"
• NEW™ included update of items order on GP.GG, now it mirrors in-game inventory order

2023.04.30:

• added events from "Invitation to Wine" to "Stultifera Navis Rerun" [Lone Trail NOT included]
• included materials reshuffle and update
• NEW™ inventory export to penguin-stats.io

2023.08.19:

• added event from "Lone Trail" up to "So Long Adele"
• added "both-ways" converter from Gamepress' CSV format to Krooster.com CSV format, which than can be exported to penguin-stats.io with a "needed" value

2023.11.17:

• added events from "Trials for Navigator #3" / "Ideal City Rerun" up to "Zwillingstürme im Herbst"
• NEW™ materials debuting in Ep. 13
• NEW™ made a "changelog", kek

2023.11.19

• "quickfix", Stultifera Navis was originally supposed to happen before Lone Trail, so it was hidden before LT as if already concluded; moved ahead