Stash Tracker

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1			J	F	M	A	M	J	J	A	S	O	N	D	Total Stash Used	Total New In	Total New Used	Net Added	Net Out

2	2020	stash (e)	0	200	0	0	0	0	0	0	0	0	0	0	600	1600	1525	75	525
3		new purchase (g)	1600	0	0	0	0	0	0	0	0	0	0	0
4		new used (f)	0	375	1150	0	0	0	0	0	0	0	0	0
5		sold/donated (h)	0	0	400	0	0	0	0	0	0	0	0	0
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	20xx	stash (e)	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
15		new purchase (g)	0	0	0	0	0	0	0	0	0	0	0	0
16		new used (f)	0	0	0	0	0	0	0	0	0	0	0	0
17		sold/donated (h)	0	0	0	0	0	0	0	0	0	0	0	0
18
19
20
21	• Then click on the little arrow on the "20xx" 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 (all four rows of stuff for columns C-N) 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