▶
Currencies 0
No currencies defined. Click "Add Currency" to begin.
▶
Sources (Income) 0
No sources defined. Add currencies first, then add income sources.
▶
Sinks (Spending) 0
No sinks defined. Add items players will purchase sequentially.
▶
Player Assumptions
Player behavior is deterministic: they always attempt to buy the next item in purchase order. If they can't afford it, they keep earning until they can.
▶
Google Sheets Import / Export
▶
Google Sheets Setup Guide
1. Sheet Structure
Create a Google Sheet with three tabs (worksheets):
- Currencies - columns:
Name,Type,StartingBalance - Sources - columns:
SourceName,LinkedCurrency,Amount,Frequency - Sinks - columns:
ItemName,CurrencyUsed,Cost,PurchaseOrder
2. Column Details
- Type (Currencies): one of
Soft,Hard,Event, orCustom - Frequency (Sources): one of
Per Match,Per Session,Per Day,Per Week, orPer N Days(e.g.Per 30 Daysfor monthly rewards) - LinkedCurrency / CurrencyUsed: must match a currency
Nameexactly - PurchaseOrder (Sinks): integer starting from 1; items are bought sequentially in this order
3. Exporting from Google Sheets
- Open the tab you want to export (e.g., "Currencies").
- Go to File → Download → Comma-separated values (.csv).
- Open the downloaded
.csvfile in a text editor. - Select all text, copy it, and paste it into the Import text area above.
- Alternatively, select your data range in Sheets, copy (Ctrl+C), and paste directly - Google Sheets copies as tab-separated values, which this tool also accepts.
4. Importing into this Tool
- Select the correct Import Type (Currencies, Sources, or Sinks).
- Paste CSV or tab-separated data into the text area (include the header row).
- Click Import Data. Existing data of that type will be replaced.
5. Exporting from this Tool
- Click any Export button to download a
.csvfile. - Open Google Sheets → File → Import → Upload → select the CSV.
- Choose "Replace current sheet" or "Insert new sheet".
- Export All downloads all data sets combined into one CSV with section headers.
6. Example Data
Currencies tab:
Name,Type,StartingBalance
Gold,Soft,100
Gems,Hard,0
Event Tokens,Event,0
Sources tab:
SourceName,LinkedCurrency,Amount,Frequency
Match Reward,Gold,50,Per Match
Session Bonus,Gold,100,Per Session
Daily Login,Gold,200,Per Day
Weekly Chest,Gems,30,Per Week
Sinks tab:
ItemName,CurrencyUsed,Cost,PurchaseOrder
Sword,Gold,500,1
Shield,Gold,800,2
Skin Pack,Gems,50,3