ABCDEFGHIJKLMNOPQRSTUVWXY
1
2
Boost Tracker
3
4
5
StykasSheets.com
6
Join Discord
7
Help
8
9
Purpose
10

This sheet tracks all boosts and payouts and generates formatted strings for importing paid boost data into the Banking Ledger.
11
12
Create New
13

1. To create your own copy of this Styka Sheet click File -> Create New
14
15
Tabs
16

1. Tracker: active tracker blocks for boost runs

2. Boost Roster: roster source for toon dropdowns and total rollups
17
18
Create Trackers
19

1. Go to 📋 Boost Tracker -> ➕ Create New Tracker for one block

2. Use 📋 Boost Tracker -> ➕➕ Create 5 New Trackers to bulk add blocks
20
21
Delete Rightmost Tracker
22

1. Open 📋 Boost Tracker -> 🗑️ Delete Rightmost Tracker
23
24
Fill a Tracker Block
25

1. Enter the Date in row 2 of the block, BoostID will auto generate

2. Enter in the other details: Boost Type, Logs, Gold Pot, and cuts

3. Select each boost toon that participated in the boost from the dropdowns

-- Note: dropdown populates from the toons in Boost Roster

4. Set a cut for each booster

5. Once a booster has been paid out, check the box
26
27
Gold Pot Cut Math
28

1. The sheet sets aside gold into 4 % piles

-- Guild, Ad, Leader, Booster

-- Note: they must equal 100%

2. Guild, Ad, and Leader are easy

-- Guild gets the Guild pile, plus any rounding gound

-- Advertiser gets the Ad pile

-- Note: the advertiser's account toon needs to be added to the Boost Roster

-- Leader gets the Leader pile

-- Note: the leader toon can also be a boost toon, both will send payouts to their account toon

3. Booster pile is split by weights (cuts)

-- Each booster gets a cut of the Booster pile

-- Cut value of 1 = an even cut, any value lower or above that will decrease or increase appropriately

-- Note: this means adjusting booster cuts only affects the booster pile
29
30
Ledger Import String
31

1. Once a boost has been full paid, Open 📋 Boost Tracker -> 🔗 Generate Banking Ledger Import String

2. Select the Boost ID and generate the string

3. Copy the output and import it in the Ledger sheet, 🏦 Ledger -> 🔗 Import Boost Tracker String
32
33
Recalculate Roster Totals
34

1. Open 📋 Boost Tracker -> 🧮 Refresh Booster Roster Gold Totals

-- Note: Being a leader or advertiser does not tick up the Count on the Boost Roster, or on the Ledger Dashboard.

This is why it makes sense to add a leader or advertiser as a booster if they help in the carry. The Ledger

Dashboard does keep track of leader and advertiser payouts.
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
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