ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Download your own copy of the spreadsheet in excel format, or copy it to your own google drive and use google sheets.
3
4
I threw this together this evening to get something out there for those of you who want it…
5
6
I have been redesigning my sheet template of the past to address many concerns and concerns I have received.
7
However real life has not been kind over the last six months and I find that there was not time to complete it.
8
So here I am throwing together something new, with a smaller feature set, the includes some of my new changes.
9
Let me know what you think!
10
11
12
Pledge Tab contains only your pledge choices with total piece count and total cost
13
MyPieces Tab contains the breakdown of each piece within each pledge configuration chosen
14
SetData Tab contains the set/piece matrix
15
16
17
18
Pledge Tab:
19
Enter the data for up to 4 different pledge configurations -
20
Only type in the colums below the words "Painted" or "Unpainted"
21
The only exception is in the pledge names. Rename them on this page and it will carry forward to other tabs.
22
each pledge may contain both painted and unpainted pieces. They will be tracked separately.
23
24
The number of cache sets you have "earned" is calculated at the bottom of the page.
25
It also displays the number of caches you have selected - the contents of those sets are included in the totals on the MyPieces tab
26
And it calculates to tell you how many caches you have remaining to choose. A negative number means you have chosen too many
27
28
compare and contrast your pledges with the other tabs.
29
30
31
MyPieces Tab:
32
Do not type on this page it autopopulates based on values entered on the Pledge tab.
33
34
Summary tab of all the pieces included in the choices made on the pledge tab.
35
36
The top of the table contains total number of pieces and a total for each column (painted and unpainted), with a total per pledge.
37
38
39
MyComps Tab:
40
Near the top of the page there are dropdown boxes (you may have to hover to see them).
41
The top row are in black text, the bottom row are in red text.
42
Choose a column from the pledge sheet for a black and red entry in the same column.
43
Those two columns will be compared… price, pieces, number of each piece.
44
The numbers that appear in black are how many more of that piece are in the column you chose in the black dropdown.
45
The numbers that appear in red are how many more of that piece that are in the column you chose in the red dropdown.
46
47
You can choose to do up to four comparisons on the sheet.
48
49
50
51
52
53
54
55
56
57
Perhaps in one column you want to compare the painted pieces for two pledges
58
And the next column choose the unpainted pieces for the same pledge.
59
60
61
MySculpts Tab
62
This tab is probably not terribly useful for this campaign as you can mor easily see all the pieces… but
63
64
This tab will take the sum of each piece in a pledge (both painted and unpainted) and highlight those
65
that equal zero. This draws your attention to the pieces you do not have.
66
67
68
Coverage
69
This tab calculates table coverage as well as liner length of walls (including barricades and free standing walls)
70
Totals are at the bottom of the page.
71
72
73
Lowest Tab
74
A table that lists each piece and the lowest priced set it is contained it. There is a column for painted, and one for unpainted.
75
76
77
78
I can be reached for comments, questions, corrections, and feedback at dfwikia@gmail.com
79
80
Thanks!!!
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100