AJR 2015 Malifaux - Google Drive


1	Introduction
2	Over the course of 2010, I used a Google Spreadsheet to track both my hobby and gaming accomplishments... initially as an attempt to use the Lone Pilgrim Painting Progress scheme to evaluate what I'd actually done. This quickly then expanded into tracking games I'd played and how I'd done. Not so much as a W/L/D ratio to brag about (I'd have nothing to brag about), but because it's an easy, easy thing to track.
3
4	It didn't take long for me to identify other, more nuanced ways to track what I'd done. This Spreadsheet represents an attempt at that. Also, since it's been so successful for me, I figure I might as well share it
5
6	If you end up getting some use out of this, or if you have any questions, stop by my blog, Warpstone Pile (http://warpstonepile.blogspot.com), and let me know. I'll be happy to help with what I can and will be even happier to know that this is helping someone else out.
7
8	As a note, there are several regions in this sucker that are calculated. In the interests of not breaking stuff, or forcing anyone to have to parse out some long formulae: try to leave any cell that's colored in grey alone. Those are the calculated fields. I've hidden them where they only provide data for charting, but there are some spots where they provide human-useful information. Anyway: leave them alone, 'kay?
9
10	(Leave these cells alone, dude!)
11
12	I've left my Dec. 2010 accomplishments in here, as an example of how to fill out the spreadsheet. If you want, you can check out how I'm using this spreadsheet to track
13	my hobby data.
14
15	Tab Listing
16	- Introduction	You're lookin' at it!
17	- Hobby	For tracking assembly and conversion progress.
18	- Gaming	For tracking games, opponents, and outcome.
19	- Charts	The interesting part of the sheet. Here, your hobby status is displayed in chart form, for easy posting to your blog or whatever.
20	- Calculations	We run some numbers here to drive the charts. You probably should leave this tab alone.
21	- AxM Crosswalk	Maps army progress against months. You probably should leave this tab alone.
22
23	Happy hobbying!
24	Rushputin,
25	Warpstone Pile
26
27	(You won't hurt my feelings-- much-- if you decide to delete this tab.)


1	Year	Month	Flat Month	Flat Month + Year	Model	Game	Army	Type	Quantity	Assembly Value	Painting Value	Assembly Points	Painting Points	Model Subtotal	Running Subtotal	Lone Pilgrim Painting Progress Values
2	2015	August	August	August+2015	Perdita	Malifaux	Guild	Infantry	1	1	1	1	1	2	2	Value	Value
3			August	August+2015	Brutal Effigy	Malifaux	Guild	Infantry	1	1	1	1	1	2	4
4			August	August+2015	Santana Ortega	Malifaux	Guild	Infantry	1	1	1	1	1	2	6
5			August	August+2015	Nino Ortega	Malifaux	Guild	Infantry	1	1	1	1	1	2	8
6			August	August+2015	Mr. Tannen	Malifaux	Neverborn	Infantry	1	1	1	1	1	2	10
7			August	August+2015	Mr. Graves	Malifaux	Neverborn	Infantry Large base	1	2	2	2	2	4	14	Infantry	1
8			August	August+2015	Illuminated	Malifaux	Neverborn	Infantry	2	1	1	2	2	4	18	Infantry large base (40mm / 50mm)	2
9		June	July	July+2015	Seamus	Malifaux	Resurectionists	Infantry	1	1	1	1	1	2	20	Cavalry	2
10			July	July+2015	Rotten Belle	Malifaux	Resurectionists	Infantry	3	1	1	3	3	6	26	Monster / Dreadnought	5
11			July	July+2015	Madame Sybelle	Malifaux	Resurectionists	Infantry	1	1	1	1	1	2	28	Vehicle	10
12			July	July+2015	Copycat Killer	Malifaux	Resurectionists	Infantry	1	1	1	1	1	2	30	Superheavy	20
13		May	June	June+2015	Sonnia Criid	Malifaux	Guild	Infantry	1	1	1	1	1	2	32	Terrain / Display Board	10
14			June	June+2015	Sammael Hopkins	Malifaux	Guild	Infantry	1	1	0	1	0	1	33	Gaming Table / Board	20
15			June	June+2015	Witchling Stalker	Malifaux	Guild	Infantry	3	1	1	3	3	6	39	(These are really just guidelines. )
16			June	June+2015	Burning Totem	Malifaux	Guild	Infantry	1	1	0	1	0	1	40
17																Conversion Complexity
18																Complexity	Level
19																No Assembly	0
20																Simple Assembly	1
21																Complicated Assembly / Minor Conversion	2
22																Significant Conversion	3
23																Scratch-build	4
24																You should seek therapy	5
25																(Again, just guidelines. )
26
27																Hobby Emphasis Weight
28																Painting	1
29																Assembly / Conversion	1
30																(Change this if you want one or the other to count
31																more towards the subtotal.)
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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256


1		System	Army	Master	Strategy	Scheme 1	Scheme 2	Opponent	Opponent's Army	Master	Points	W/L/D	Strategy Points	Scheme 1 A/H/F	Scheme 2 A/H/F	Type	Flat Date	Sort Key	Charting Name	Charting Name

2	August 2015	M2E	Guild	Perdita	Extraction	Protect Territory	Plant Explosives	Jon	Ten Thunders	Shen Long	6	W	3	A	H	Vassal	August	201508	M2E - Guild	Guild - Perdita
3	July 2015	M2E	Guild	Perdita	Reckoning	Assassinate	Make Them Suffer	Elle	Arcanists	Rasputina	4	L	1	F	A	Fun Game	July	201508	M2E - Guild	Guild - Perdita
4	June 2015	M2E	Neverborn	Pandora	Headhunter	Spring the Trap	Bodyguard	Jon	Ten Thunders	Misaki	6	W	3	A	F	Vassal	June	201506	M2E - Neverborn	Neverborn - Pandora
5	August 2015	M2E	Guild	Perdita	Squatter's Rights	Bodyguard	Make Them Suffer	Jon	Ten Thunders	Shen Long	8	W	4	A	H	Fun Game	August	201508	M2E - Guild	Guild - Perdita
6	September 2015	M2E	Guild	The Judge	Guard the Stash	Line in the Sand	Take Prisoner	Jon	Ten Thunders	Kang	4	L	0	H	A	Nythera Campaign	September	201509	M2E - Guild	Guild - The Judge
7	September 2015	M2E	Guild	Ryle	Interference	Deliver the Message	Bodyguard	Jon	Ten Thunders	Kang	6	D	2	A	H	Nythera Campaign	September	201509	M2E - Guild	Guild - Ryle
8	September 2015	M2E	Guild	Ryle	Interference	Plant Explosive	Bodyguard	Tokkun	Ten Thunders	Yamaziko	7	L	3	A	H	Nythera Campaign	Loading...	201509	M2E - Guild	Guild - Ryle
9	September 2015	M2E	Guild	Ryle	Extraction	Breakthrough	Murder Protege	tawg	Outcasts	Hannah	6	L	3	A	F	Nythera Campaign	Loading...	201509	M2E - Guild	Guild - Ryle
10	October 2015	M2E	Guild	Ryle	Collect the Bounty	Protect Territory	Frame for Murder	Jon	Ten Thunders	Kang	7	W	1	A	A	Nythera Campaign	Loading...	201510	M2E - Guild	Guild - Ryle
11	11/1/2015	M2E	Neverborn		Reckoning	Protect Territory	Frame for Murder	Jon	Ten Thunders	Jacob Lynch	5	W	1	A	H	Playtest	Loading...	201511	M2E - Neverborn	Neverborn -
12	11/1/2015	M2E	Guild	Perdita	Headhunter	Cursed Object	Protect Territory	Jon	Outcasts		8	L	4	A	H	Playtest	Loading...	201511	M2E - Guild	Guild - Perdita
13	11/1/2015	M2E	Guild		Turf War	Bodyguard	Vendetta	Jon	Arcanists	Collette	9	W	4	A	H	Playtest	Loading...	201511	M2E - Guild	Guild -
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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189


1	Hobby								Gaming
2	Army	Assembly	Painting	Total	Month	Assembly	Painting	Total		Count				%			Overall			Count				%				Count				%					Count			%			Overall Strategies			Count				%				Count				%				Count				%
3	Guild	Infantry	1	1	August+2015	9	9	18	Army	W	L	D	Total	W	L	D	Games by Army	Games	Month	W	L	D	Total	W	L	D	Master	W	L	D	Total	W	L	D	Scheme	Total	A	H	F	A	H	F	Strategy	Total	Opponent	W	L	D	Total	W	L	D	Army	W	L	D	Total	W	L	D	Master	W	L	D	Total	W	L	D
4	Guild	Infantry	3	1	July+2015	6	6	12																											Assassinate	1	0	0	1	0%	0%	100%	Collect the Bounty	1	Elle		1		1	0%	100%	0%	Arcanists	1	1		2	50%	50%	0%	Collette	1			1	100%	0%	0%
5	Neverborn	Infantry	1	1	June+2015	6	4	10	M2E - Guild	4	5	1	10	40%	50%	10%	M2E - Guild	10	June	1			1	100%	0%	0%	Guild -	1			1	100%	0%	0%	Bodyguard	5	2	2	1	40%	40%	20%	Extraction	2	Jon	6	2	1	9	67%	22%	11%	Outcasts		2		2	0%	100%	0%	Hannah		1		1	0%	100%	0%
6	Neverborn	Infantry	2	1					M2E - Neverborn	2			2	100%	0%	0%	M2E - Neverborn	2	August	2			2	100%	0%	0%	Guild - Perdita	2	2		4	50%	50%	0%	Breakthrough	1	1	0	0	100%	0%	0%	Guard the Stash	1	tawg		1		1	0%	100%	0%	Ten Thunders	5	2	1	8	63%	25%	13%	Jacob Lynch	1			1	100%	0%	0%
7	Neverborn	Infantry Large base	1	2		0	0	0											July		1		1	0%	100%	0%	Guild - Ryle	1	2	1	4	25%	50%	25%	Make Them Suffer	2	1	1	0	50%	50%	0%	Headhunter	2	Tokkun		1		1	0%	100%	0%									Kang	1	1	1	3	33%	33%	33%
8	Resurectionists	Infantry	1	1															September		1	1	2	0%	50%	50%	Guild - The Judge		1		1	0%	100%	0%	Protect Territory	4	3	1	0	75%	25%	0%	Interference	2																	Misaki	1			1	100%	0%	0%
9	Resurectionists	Infantry	3	1															Loading...				1	0%	0%	0%	Neverborn -	1			1	100%	0%	0%	Frame for Murder	2	1	1	0	50%	50%	0%	Reckoning	2																	Rasputina		1		1	0%	100%	0%
10																			Loading...				1	0%	0%	0%	Neverborn - Pandora	1			1	100%	0%	0%	Deliver the Message	1	1	0	0	100%	0%	0%	Squatter's Rights	1																	Shen Long	2			2	100%	0%	0%
11																			Loading...				1	0%	0%	0%									Plant Explosives	1	0	1	0	0%	100%	0%	Turf War	1																	Yamaziko		1		1	0%	100%	0%
12																																			Murder Protege	1	0	0	1	0%	0%	100%																					1		1	0%	100%	0%
13																																			Spring the Trap	1	1	0	0	100%	0%	0%																					1		1	0%	100%	0%
14																																			Line in the Sand	1	0	1	0	0%	100%	0%																					1		1	0%	100%	0%
15																																			Cursed Object	1	1	0	0	100%	0%	0%																					1		1	0%	100%	0%
16																																			Outflank	0	0	0	0																								1		1	0%	100%	0%
17																																			Power Ritual	0	0	0	0																								1		1	0%	100%	0%
18																																			Distract	0	0	0	0																								1		1	0%	100%	0%
19																																			Vendetta	1	0	1	0	0%	100%	0%																					1		1	0%	100%	0%
20																																			Plant Evidence	0	0	0	0																								1		1	0%	100%	0%
21																																																															1		1	0%	100%	0%
22																																																															1		1	0%	100%	0%
23																																																															1		1	0%	100%	0%
24																																																															1		1	0%	100%	0%
25																																																															1		1	0%	100%	0%
26																																																															1		1	0%	100%	0%
27																																																															1		1	0%	100%	0%
28																																																															1		1	0%	100%	0%
29																																																															1		1	0%	100%	0%
30																																																															1		1	0%	100%	0%
31																																																															1		1	0%	100%	0%
32																																																															1		1	0%	100%	0%
33																																																															1		1	0%	100%	0%
34																																																															1		1	0%	100%	0%
35																																																															1		1	0%	100%	0%
36																																																															1		1	0%	100%	0%
37																																																															1		1	0%	100%	0%
38																																																															1		1	0%	100%	0%
39																																																															1		1	0%	100%	0%
40																																																															1		1	0%	100%	0%
41																																																															1		1	0%	100%	0%
42																																																															1		1	0%	100%	0%
43																																																															1		1	0%	100%	0%
44																																																															1		1	0%	100%	0%
45																																																															1		1	0%	100%	0%
46																																																															1		1	0%	100%	0%
47																																																															1		1	0%	100%	0%
48																																																															1		1	0%	100%	0%
49																																																															1		1	0%	100%	0%
50																																																															1		1	0%	100%	0%
51																																																															1		1	0%	100%	0%
52																																																															1		1	0%	100%	0%
53																																																															1		1	0%	100%	0%
54																																																															1		1	0%	100%	0%
55																																																															1		1	0%	100%	0%
56																																																															1		1	0%	100%	0%
57																																																															1		1	0%	100%	0%
58																																																															1		1	0%	100%	0%
59																																																															1		1	0%	100%	0%
60																																																															1		1	0%	100%	0%
61																																																															1		1	0%	100%	0%
62																																																															1		1	0%	100%	0%
63																																																															1		1	0%	100%	0%
64																																																															1		1	0%	100%	0%
65																																																															1		1	0%	100%	0%
66																																																															1		1	0%	100%	0%
67																																																															1		1	0%	100%	0%
68																																																															1		1	0%	100%	0%
69																																																															1		1	0%	100%	0%
70																																																															1		1	0%	100%	0%
71																																																															1		1	0%	100%	0%
72																																																															1		1	0%	100%	0%
73																																																															1		1	0%	100%	0%
74																																																															1		1	0%	100%	0%
75																																																															1		1	0%	100%	0%
76																																																															1		1	0%	100%	0%
77																																																															1		1	0%	100%	0%
78																																																															1		1	0%	100%	0%
79																																																															1		1	0%	100%	0%
80																																																															1		1	0%	100%	0%
81																																																															1		1	0%	100%	0%
82																																																															1		1	0%	100%	0%
83																																																															1		1	0%	100%	0%
84																																																															1		1	0%	100%	0%
85																																																															1		1	0%	100%	0%
86																																																															1		1	0%	100%	0%
87																																																															1		1	0%	100%	0%
88																																																															1		1	0%	100%	0%
89																																																															1		1	0%	100%	0%
90																																																															1		1	0%	100%	0%
91																																																															1		1	0%	100%	0%
92																																																															1		1	0%	100%	0%
93																																																															1		1	0%	100%	0%
94																																																															1		1	0%	100%	0%
95																																																															1		1	0%	100%	0%
96																																																															1		1	0%	100%	0%
97																																																															1		1	0%	100%	0%
98																																																															1		1	0%	100%	0%
99																																																															1		1	0%	100%	0%
100																																																															1		1	0%	100%	0%
101																																																															1		1	0%	100%	0%
102																																																															1		1	0%	100%	0%
103																																																															1		1	0%	100%	0%
104																																																															1		1	0%	100%	0%
105																																																															1		1	0%	100%	0%
106																																																															1		1	0%	100%	0%
107																																																															1		1	0%	100%	0%
108																																																															1		1	0%	100%	0%
109																																																															1		1	0%	100%	0%
110																																																															1		1	0%	100%	0%
111																																																															1		1	0%	100%	0%
112																																																															1		1	0%	100%	0%
113																																																															1		1	0%	100%	0%
114																																																															1		1	0%	100%	0%
115																																																															1		1	0%	100%	0%
116																																																															1		1	0%	100%	0%
117																																																															1		1	0%	100%	0%
118																																																															1		1	0%	100%	0%
119																																																															1		1	0%	100%	0%
120																																																															1		1	0%	100%	0%
121																																																															1		1	0%	100%	0%
122																																																															1		1	0%	100%	0%
123																																																															1		1	0%	100%	0%
124																																																															1		1	0%	100%	0%
125																																																															1		1	0%	100%	0%
126																																																															1		1	0%	100%	0%
127																																																															1		1	0%	100%	0%
128																																																															1		1	0%	100%	0%
129																																																															1		1	0%	100%	0%
130																																																															1		1	0%	100%	0%
131																																																															1		1	0%	100%	0%
132																																																															1		1	0%	100%	0%
133																																																															1		1	0%	100%	0%
134																																																															1		1	0%	100%	0%
135																																																															1		1	0%	100%	0%
136																																																															1		1	0%	100%	0%
137																																																															1		1	0%	100%	0%
138																																																															1		1	0%	100%	0%
139																																																															1		1	0%	100%	0%
140																																																															1		1	0%	100%	0%
141																																																															1		1	0%	100%	0%
142																																																															1		1	0%	100%	0%
143																																																															1		1	0%	100%	0%
144																																																															1		1	0%	100%	0%
145																																																															1		1	0%	100%	0%
146																																																															1		1	0%	100%	0%
147																																																															1		1	0%	100%	0%
148																																																															1		1	0%	100%	0%
149																																																															1		1	0%	100%	0%
150																																																															1		1	0%	100%	0%


1	Sorry that these charts don't automagically work; I'm pretty sure that, if this was Excel, I could throw in maximal range and everything would work out fine. With Google Spreadsheet, though, the charts come out looking funny. I've included notes about how to update them.
2
3	Painting Points by Army		Hobby Points by Month
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25	Calculations	Increase C for additional armies (C1 becomes C2, etc)	Calculations	Increase I for additional months (I1 becomes I2, etc)
26
27	Hobby: Army x Month
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50	AxM Crosswalk	Increase second letter & number (A1:B2 becomes A1:C2 for another month or A1:B3 for another army)
51
52	Performance by Army		Games by Army
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76	Calculations	Increase N for additional armies (N1 becomes N2, etc)	Calculations	No changes should be needed! Yay!
77
78	Performance by Master
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107	Strategies			Schemes
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138	Performance vs Faction
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165	Performce Vs Master
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214