TCG卡牌店模拟器

TCG卡牌店模拟器

评价数不足
Wallet Size, Shopping List, & Max Customers Calculator (v0.61.5)
由 GwenBD94 和其他 1 人合作完成
Pre-programmed google sheet to calculate data on your shop! Make a copy, fill in the requested data, and be more informed!
3
   
奖励
收藏
已收藏
取消收藏
Link & Credits
You can find the referenced google sheet at this link.[docs.google.com]

Data used in the calculations of the sheet were made available on the TCG Card Shop Simulator official discord, primarily from the "Nerds and Numbers" and "Code Discussion" threads of the tcg-sim-chat channel. credit to theWatchingShadow on discord for consolidating the majority of the info used.
Shop Details
On the Shop Details tab you'll input the various data about your shop highlighted in green, and the useful information will be calculated and displayed to you based on your shop's inputs.

Details on this sheet include Wallet info, Max Customers info, customer spawn rates, and electricity costs.

Decoration Inputs
The Decoration Inputs tab is where you'll put in how many of each decoration type you've purchased and placed in your shop. These numbers will be used in calculations in the Shop Details tab.


Target Item List
The calculations on the Target Item List tab take into account information in the Shop Details tab, as well as the player input highlighted green on this tab itself, as well as the data in your savefile JSON. You can use this to have some degree of control over what items your customers are looking for when they look for specific items.

Changelog
Version
Date
Comments
1.0
Sep 23, 2025
Initial Release
1.1
Sep 24, 2025
Updated for game version v0.61 to include new 'Collector' Wallet calculations
1.1.1
Sep 28, 2024
  • Fixed inaccuracies with Collector Wallet Calculations
  • Modified Target List layout to allow copy+pasting from player files
  • Modified wallet layout and write-up description
1.1.2
Oct 6, 2025
Fixed an issue with Morning Rush calculation
1.2
Oct 9, 2025
Reformatted Decorations tab & calculations
Contact Info
If you notice any issues with the worksheet, you can find me in the TGC Card Shop Simulator Discord server, under GwenBD94. This is the best way to contact me.
7 条留言
The Watching Shadow  [作者] 10 月 19 日 下午 8:31 
You should see the rest on the Discord. :happyfaye:
Pizza Mafia 10 月 19 日 下午 7:09 
this is beautiful. i havent seen such beautiful charts since i played reccetear. thats the measure of a good shopping sim: making the players use spreadsheets
The Watching Shadow  [作者] 10 月 9 日 上午 6:04 
It's a list of items that is re-rolled at the start of each week. The Visible Day # input and the "calendar" determines where you are in the current week and when the next one starts.

The list size scales based on store level and maxes out at 12 items. Up to ~2/3 is from a random selection of items you have stocked on your shelves and the rest randomly selected from what you can unlock, regardless if you have or not. These selections are what are re-rolled at the start of each week.

Customers that spawn with a shopping list will have their list made of 1-4 items randomly selected from the main target list. The text above their heads asking for items if you don't have them and bad reviews if you have something unlocked, but don't carry something they want are due to this.

You can use the instructions to find the item IDs for your current list and use the sheet to do some "market research" and know what the "hot items" of the week are as it will tell you the name for each item ID.
Crimson Alpha 10 月 9 日 上午 1:35 
Could you explain what the "Target Item List" is?
GwenBD94  [作者] 10 月 6 日 上午 10:32 
Updated for an issue with morning rush calculation & small formatting issue on target list
GwenBD94  [作者] 9 月 28 日 下午 5:25 
Updated google sheet to fix discrepancies in new wallet values.
tr1skele 9 月 26 日 下午 4:32 
Finally made the document public for others to use Gwen? Well congrats and I hope lots of people get some good use from it :)