An update for the TCG Pocket spreadsheet that calculates the best pack to pull

LATEST UPDATE

  • Date : 03/02/2025 (dd/mm/yyyy)
  • Info : New version 4.1.2 released, full changelogs in the spreadsheet

LASTEST RELEASE

  • Date : 03/02/2025 (dd/mm/yyyy)
  • Version : 4.1.2

Hey everyone !

I have been working with u/maxwell1755 to update their spreadsheet to provide better calculations, add new extensions, and localize the sheet in various language.

I am making this new thread with maxwell's blessing -as they haven't been able to work on the sheet hemselves lately- with an in-development version that integrates some requested features, as well as the main element I worked on, being a dynamic localization system. I will keep updating this thread with new versions and informations regarding development.

I also understand that plenty of people already made their own updates and translation, but you can consider this thread to host the current "all in one" development version of the official work, made by maxwell and I.

The spreadsheet as it stand now features :

  • A dynamic localization in English, French, German, Spanish, Italian, Japanese and Romaji.
  • Sheets for all extensions with their own dedicated collection calculations.
  • A revised and fixed Mew Regex.
  • A home page featuring : The language selector, The ability to set the collection system to a two card base rather than one for those who want to have a complete "play ready" collection, and A new calculation that shows the best extension to pull from to immediately point the user in the best direction.

Do note that some cards or words may be ill translated as I am French/English speaking and did not manage to find all the proper resources for every word and cards. Don't hesitate to suggest the needed corrections in the comments !

The spreadsheet now also comes in two version, manual or automated, depending on your preference and use plateform of choice. TL;DR in the automated version you only need to fill the number of cards for the first column to validate owning the card, depending on the minimum requuired chosen (1 or 2 if the home page option is ticked)

Here are the links for the current version

Manual : https://docs.google.com/spreadsheets/d/1yVBaWYOSH5gVi2qSxpoGm_E5P9PmH7zd4YSnJGtnuZ8/copy?usp=sharing

Automated : https://docs.google.com/spreadsheets/d/1mz0by9mqnXFRHxTkV3O7Q38Y5_6I7234M-3Mj1taG00/copy?usp=sharing

4.1.2 Changelog

Fixes

  • Free mission, shop, Wonder Pick, Promo pack, Team Galactic Grunts are now properly written in spanish
  • Wonder Pick is now properly written in Italian
  • Mythical Slab, Budding Expeditioner, Giant Cape are now filled in Italian

To re-import data from an old version, just copy and paste the "# of cards" columns in the new sheets. You also need to copy and paste the "A" columns if you use the manual version.

Don't hesitate to share your feedback, I look forward to see what you think of these version, and what could be made to improve them ! Also rest assured, we have made with maxwell a TODO list from request in the previous thread and I will be working actively to incorporate them as soon as possible, I just had to finalize my first big work, which was localization and automation :)