Stash Tracker
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
JFMAMJJASOND
Total Stash Used
Total New In
Total New Used
Net AddedNet Out
2
2020stash (e)020000000000006001600152575525
3
new purchase (g)
160000000000000
4
new used (f)03751150000000000
5
sold/donated (h)
00400000000000
6
7
8
9
10
11
TO ADD A NEW YEAR:
12
• Insert 6 rows above the previous year's block, then copy&paste these cells into the fresh rows. Rename the year from "20xx" to the new year.
13
14
20xxstash (e)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
15
new purchase (g)
#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
16
new used (f)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
17
sold/donated (h)
#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
18
19
20
21
• Then click on the little arrow on the "blank year" sheet below and choose "duplicate."
22
• Rename the new sheet to the new year.
23
• The less-than-fun part: go through all the cells with errors (#REF!) and change the year in ' ' from 20xx to the new year. This will update the formulas so they work properly!
24
• You're all set! Enter your new projects and purchases in the new year, and they should pop right up in the new year rows on this summary page.
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