Saturday 23 March 2024

AHPC XIV: The Statistical Round UP

Well it's finally time to do the statistical round up of Challenge XIV.  I know, I know we skipped last year but there is no reprieve for any of you THIS year.  Buckle up, there's a load stats coming down the information super highway towards you AND they aint got no brakes.....

dun, Dun, DAAAAHHHHH.......


Anyway lets first take a gander over our standard statistical table.  I warn you, this table is formatted seductively what with it's columns and decimal places and those "come hither" spelling and grammatical errors.  It really should come with a parental warning and would likely get banned from a Florida public library.


As you will see, good 'ole XIV was a steady performer - pretty much reight down the "average fairway".  If XIV was a person, you'd want them to be your neighbor - their yard would look fine so as not to detract from your property value but not so good as to make your neighbors think you are the one bringing the neighborhoods property values down.


Through 13 weeks of "pigment positioning frenzy" 83 participants made it to the end and put up 77,735 points.  Was that the best challenge in terms of collective productivity?, no - Was it a GREAT challenge in terms of artistic expression and Fun?  Hell Yeah.  Achievement UNLOCKED!


The island/room bonus concept continues to really shape how people approach the challenge with 573 of the 689 total submissions (83%) being associated with one room of the library or another.  Some of those assocaitions were a bit on the tenuous side but lets not quibble

AHPC XIV Stats Summary:
XIVXIIIXIIXIX
Total Points77,73585,42186,64682,61968,878
% of Target112.00%126.34%101.35%121.68%109.00%
Participants8383978468
# of Submissions6897858851,261956
#Planets/Chamber/Island Spots573551626518437
Avg Subs per Participant8991514
Avg Pts per Submitter9371,0298939841,013
Avg Pts per Submission11397986672
Total Points per Week5,9806,5716,6656,3555,298
Figures Painted
28MM
Inf5,5096,9367,3376,7654,785
Cav / Art831683609798454
Vehicles10815721597122
15MM
Inf3,6892,4732,8352,5192,083
Cav / Art289855423527588
Vehicles355143162196144
6MM
Inf3,4654,5211,1002,5192,496
Cav / Art751342192695471
Vehicles50816424830235
Terrain "Cubes"113294178125191
Points Distriution
28mm48.90%52.27%54.33%52.95%44.85%
15mm14.63%11.13%9.99%10.55%11.14%
6mm4.50%3.43%1.43%2.44%3.18%
Terrain2.90%6.88%4.11%3.03%5.54%
Chamber / Island Bonus Pts14.75%16.22%15.72%22.94%25.12%
Other Scales14.33%10.07%14.42%8.10%10.18%
Total100.00%100.00%100.00%100.00%100.00%

We did see a continuation of the trend of fewer but larger submissions per participant and the average points per participant still hovering around the 1K level.


28mm is still the favorite scale but has finally slipped back under 50% of the points, with 15mm staging a very nice come back.  Terrain saw a significant decline but that was likely due to one particular participant not doing a lot of terrain - the less said abut that miscreant the better.

Now some of you prefer to look at data via both gaudy and vulgar charts vs the pristine look of a data table.  For the life of me I don't understand it but it seems to be what the masses want and who am O to say what's cool (data tables) and what's blinding obviously not cool (charts).  Look at me being all non-judgemental and such!

Another way to look at the progress of the past 14 challenges is to convert the total points into equivalent 28mm figures - when that minor bit a of is performed it seems we have collectively painted the equivalent of 181,720 28mm Infantry figures - that's a lot.

Just think of the storage space needed to 182K figures.   It's just under 1,300 square feet of shelf space.  I dont know about you but I dont have that much space in my house!

Economic Value Add
This section tends to be the most popular but does require a little explanation.  As an enterprise, the AHPC does represent a form of economic stimulus for the hobby as we purchase miniatures along with the supplies to paint and base them.  Moreover we will also likely replace those resources consumed in this enterprise with new ones.  Professionally, I live in a world of unit economic analysis and, as a financial services professional, you know you can trust me - when have we ever let you down?

The process used to calculate the Economic Value Add of the Challenge involves the determining the three pillars of miniature valuation:  

Pillar 1: 28mm Equivalent Figures
Convert the total points into equivalent 28mm infantry figures.  This one is pretty easy divide the total score by 5 points per figure: 77,735 divided by 5 equals 15,547 figure equivalents

Pillar 2: Cost per Figure 
Estimate the unit cost of painting a figure.  This step is a bit more complicated and breaks down the total cost of a figure into three components.  I did factor in a standard inflation rate of 10%, which is a real inflation rate (removing the cost of energy which have been impacted by that criminal activities of a certain Mr Putin)

Figure Cost: 
The cost the figure itself which includes postage, taxes and such.  The figure costs have have been increase this year from $3.30 to $3.63  

Consumables:
Paints, glues, basing materials, Xacto blades and other items that are consumed in making the figure.  Bear in mind its not just the cost of the paint on the figure - your paint wastage on your palette has been factored in.  Please note medical costs from xacto blade mishaps are factored into labor costs below.  Consumables are estimated at $3.30 a figure

Labor:
Painting a miniature takes time, your time in fact and time IS money so we need to factor in a Labor cost.  This has always been a hotly debated component as different people paint at different speeds and quality varies and some of you have rather high opinions of your own value - yeah, yeah, yeah - blah, blah, blah. By the way that hourly rate is $15.40 - congrats on almost earning as mush as a Star Bucks Barrista

Pillar 3: Economic Velocity
It just takes one glance at out respective lead mountains to realize we purchase more than we paint.  In fact theres an economic term for that called velocity - after many year of costly research and field experimentation, scientist have determined that for every figure painted, 5 are purchased, hence a base velocity of 5.  This value has been adjusted upward to 5.25x to reflect stress buying induced byd the current global instability.  When in doubt, buy lead - an addage that seems to fit a lot of different occasions.


The formula for total EVA is just to simply multiply the three pillars together - easy, peasy right?

Without further ado - I present to you the EVA calculation for Challenge XII - drum roll please.....

Ecomonic Value Add (EVA)
CHALLENGE XIV
Total Points77,735
Equivalent 28mm Figures
15,547
Previous
EconomicChallenge
Value Add(AHPC XIII)
Cost per Mini$3.63$56,435$3.30
Paints etc$3.30$51,305$3.00
Painting TIme$15.40$239,423$14.00
Sub Total$22.33$347,163$20.30
Velocity5.25$1,822,6045.25

Wow - we've created a rock solid 1.8MM boost to the world economy of miniature manufacturing.  You can take that number to the bank! (1)


(1) Terms and conditions apply, past performance may or may not be indicative of future performance and if you trust me, well you get what you deserve.....

In terms of total EVA created over the challenge - we've just crossed the $20mm threshold.  If only Curt had had the foresight to negotiate a flat rate commission to be paid by the lead moguls of Nottingham.....

Halls of Vallejohalla

Finally it's time to pay homage of our "Heroes of the Painting Wars" - the top performers from Challenges past who our enshrined in the hallowed halls of Vallejohalla, where ones paint pot never dries out and it's paint water magically turns to beer when you drink from the wrong cup.  The first stop in our tour is the hallowed list of the "Top 25 Individual Performances in a Challenge". These are the painting beserkers of our time


RankChallengeChallengerPoints
19NoelW6,268
212ChrisW6,072
313GrahameH5,500
48KentG5,343
59MilesR5,051
610NoelW5,011
72RayR4,940
88NoelW4,880
913ChrisW4,778
102KentG4,724
1113MartinC4,644
1212MikeW4,601
138MilesR4,550
149MartinC4,470
154AndrewS4,180
165DaveD4,138
177MilesR4,125
183ChrisP4,076
107MartinC4,051
2014KentG3,889
218ByronM3,881
225MarkO3,854
238MartinC3,844
2412MartinC3,813
2510MartinC3,789

Challenge XIV saw only one name added to the top 25 - KentG and his massive 3,889 Points - well done Kent, you are now OFFICIALLY famous.


Now lets us gaze upon the lifetime points summary for the top 50 of 970 total challenge participants over the past 12 years.  This is a "body-of-points" look at what people have achieved over the various challenges they have participated in.


RankNameLieftime Points# of ChallengesPts/Challenge
1MilesR39,361133,028
2MartinC36,790103,679
3DaveD25,265131,943
4RayR20,292121,691
5NoelW19,80244,950
6TamsinP18,77692,086
7MikeW17,42272,489
8Millsy17,324111,575
9GrahameH17,09562,849
10KentG16,40744,102
11ByronM15,069101,507
12DavidB14,55591,617
13GregB13,970131,075
14ChrisW13,74234,581
15SanderS13,543101,354
16AlexS13,516131,040
17StuartL12,60862,101
18AlanD11,764101,176
19Curt C11,31112943
20FranL11,29461,882
21KenR10,91811993
22Barks10,73191,192
23AdamC10,68891,188
24KyleC9,34171,334
25EricM8,86042,215
26IanW8,76971,253
27JohnM8,67910868
28FrederickC8,59032,863
29PaulOG8,46010846
30TeemuL8,2789920
31SamuliS8,0079890
32PeterD7,86411715
33LeeH7,6829854
34KerryT7,61632,539
35JamieM7,4588932
36PeteF7,36361,227
37PaulSS7,09751,419
38BrendonW6,8597980
39IainW6,4807926
40SteveM6,2567894
41ScottM6,18961,032
42AaronH6,14661,024
43ChrisP6,10532,035
44MichaelA5,9517850
45KevH5,86122,931
46SylvainR5,6569628
47TimB5,57322,787
48MarkO5,50722,754
49AndrewS5,45422,727
50ClintB5,34741,337

t really is a wonderful chart, save for the creepy guy at the top.  Please note that the tally is subjected to constant challenge and change as there is a certain person who runs this challenge and is a well known quantification anarchist.  he has been known to use different spellings of  peoples OFFICIAL challenge handles handles in a deliberate attempt to prevent accurate enumeration.  I'm not naming names but until recently there was both a CurtC and just a Curt  in the database.  That infamy has been corrected but other horrors yet may lurk within the inner warrens of the spreadsheet of Doom.  

We have several honorary levels based on total points.

First there is the 10,000 club, for those individuals who have scored at least 10,000 lifetime points.  This tier saw the membership of the 10k club swell to 19.  Congratulations, you will soon be contacted to get your measurements for your rose colored smoking jacket.  \

As we move up the ranks, there were no new entrants in the fabled 20,000 club, which has 2 members DaveD and RayR.  I know it can be VERY difficult to have the concepts of both exclusive / member only and RayR coexisting in the same logical entity but there you have it - the math just doesn't lie  Finally there is the LEGENDARY 30,000 club which also only has two members - the honorable and deserving MartinC who is a role model for us all and some other guy we don't really need (or want) to speak about.  Will next year's challenge see one or more entrants into the 40K club?????

Well there you have it, thats stats round up for Challenge XIV is done.  I shall now step back in bask in the warmth of your adoring admiration of my mathamagical incantations and remember kids - always carry the one!

I look forward to confusing you even more as I answer your questions.

24 comments:

  1. Nice work Miles, I don't know what most of it means, but it looks good anyway! Glad to see I'm still I'm still in both top 10's too!
    Glad to be one of two member of the 20k club as well, nice on DaveD.

    ReplyDelete
  2. The halls of Vallejohalla sound like a magical place. Thanks for the highly entertaining and educational pseudo mathematical analysis. Though I was surprised there were no monthly burn down graphs of points vs goals. ;)

    ReplyDelete
  3. To those of you in the top points, where do you store all those soldiers?!

    ReplyDelete
    Replies
    1. It’s a whole different challenge , called “Storage Wars”

      Delete
    2. My cupboards are chockers. Even my TARDIS is starting to feel crowded...

      Delete
  4. Love it! Thanks for this Miles. And a big congratulations to Kent for gaining entry into Vallejohalla! I can only hope to be a lowly cup-bearer amongst such giants. :)

    ReplyDelete
  5. Finally, entry to the 10K club! I will celebrate the traditional way with a mug of tepid paint water.

    ReplyDelete
    Replies
    1. So I am practicing for winning when I do that... good to know.

      Delete
    2. Surely in your case Barks you should skull!

      Delete
  6. Super round up Miles - I'm already looking forward to the next one!

    ReplyDelete
  7. Maybe a bit picky but where is the Egyptian Heiroglyphs section :) - seriously though - hats off to your work on the numbers, without it we would lack a collective perspective

    ReplyDelete
  8. Love the stats round up, always fun (well as fun as stats can be !) I managed to enter the 10,000 club as well, don't think I've done 11 challenges though I'd guess 7 or 8 😁

    ReplyDelete
    Replies
    1. i like your podcast, you get extra entries!

      Delete
  9. Glorious stats round up, you should consider as a career. You might do ok. Lets both join the 40k club next year and Tamsin needs to return and get herself into the 20k, to separate Ray and Dave

    ReplyDelete
  10. Great round up, and oooo soo close to that illustrious 10k club there... going to have to put some effort into it next year it seems and blast right on over that line there :D

    ReplyDelete
  11. Objects in the mirror are larger than they seem, especially in the case of Kent's per challenge point total. At this rate we'll nearly all be in his dust within 2-3 years :-O

    ReplyDelete
  12. Well done o wizard of math. Fun roundup and charts for the challenged.

    ReplyDelete
  13. I've done 9 challenges... that blows my mind

    ReplyDelete
  14. Oh gosh that's another overwhelming numbers post mate! I still think it's amazing how Noel managed to paint almost 20.000 points in just 4 Challenges, I do miss him

    ReplyDelete
  15. Very nice, who doesn't love an overly complex spreadsheet. It is a thing of joy.

    ReplyDelete