ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
DateBeg. Bal.End. Bal.Change% ChangeORANGE = YOUR INPUT. USE THIS TABLE TO LOG YOUR RP BALANCES EACH DAY. (THE FIRST THREE ROWS HAVE BEEN FILLED WITH DUMMY DATA. DELETE THESE AND INPUT YOUR OWN DATA.)
2
January 1, 2024100,000N/AN/A
3
January 2, 2024200,000100,00050.00%INSTRUCTIONS
4
January 3, 2024175,000-25,000-14.29%1Enter Date (Column B) and Beg. Bal. (Column C).
5
2To extend the formula in Columns D, E and F, highlight the last cell with a formula.
6
3Grab the bottom right corner (blue square) and drag down to fill as many cells as you want.
7
8
STATISTICS
9
Your greatest gain was 100,000 on January 2, 2024.
10
Your greatest loss was -25,000 on January 3, 2024.
11
12
START HERE
13
Hello! You can use this template to track your RP and cards in SuperStar JYP Nation. The "All Groups" tab will only show the proper scores if you have all R grade cards and all cards in the group have a matching theme. Please make a copy of the template in your own Google Drive to edit and follow the instructions on each tab.
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
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