Sunday, 25 March 2018

A Statisitcal Reckoning for "The Ocho" DRAFT

Here-Ye, Here-Ye, It is time to call the annual convocation os Mathamagical Statistics to order. All of you are fortunate to be called to witness the quantitative beauty that is the Statistical Wrap Up for Challenge VIII - "The OCHO!"

A word of caution before we delve into the under world of mathamagics - you enter at your own risk, as clearly stated in the terms of use for the Challenge (Thank you Google!).  Your brains are about to be exercised in ways they may not be ready for.  If you sense a Chuthulu like madness descending upon yourself you must act quickly or face doom.  The best defense once beset by mathamagical madness syndrome (MMS) is to quickly rest ones eyes upon one of the graphs spread liberally through out this missive.  Obviously, graphics are meant as mental "safe places" for the quantitatively frail and are now required due to revisions to the ADA regulations.  Those of us who are "Alpha-Quants" will be responsible for shepherding our "New Math" brethren to a safe harbor.  You have been warned.

Are we ready to descend into the Stats dungeon like a proper dungeon party?  Lets us go forward into the statistical night armed with slide rules and hand calculators.  What wonders await us in the mathamagical depths of the OCHO.

Lets find out.


First of all a high level comparison between VIII and VII

The OCHO Summary
VIIIVII
Participants7696
Submissions770919
Total Points78,03883,200
Avg per Participant1,027867
Avg per Submission10191

While total points are down a tad, that's due to 20 less participants making submissions.  If viewed on a relative basis the average points per participant was significant higher at 1,027 vs 867 last year.  That's a major increase in productivity!  We also saw one of the longest standing records for a challenge fall in a dramatic way but more on that later....

First a look at how Challenge 8 compares to it's 7 predecessors - quite favorably if you ask my opinion especially when one takes into account the percentage dip in participants (-21%) was far greater than the actual decline in total points (-6%).  As a group we tried admirably to take up the slack.



28mm remained, by far, the preferred scale of our pigmenting protagonists in this year's winter passion play.  There was a decline in 15mm production from the historic highs of Challenge VII.

The new Terrain category didn't really move the needle that much also as only a total of 2,740 points was awarded for terrain submissions this year.  In the past challenge we did have a terrain themed bonus round that that generated a total of 845 points (excluding the theme round bound points) so really only a 1,900 point increase in total terrain points.  Still I really liked the inclusion of terrain and hope it stays as a permanent category going forward.




One are that did see an material change during Challenge 8 was the concentration of points in the upper end of the point generators.  In part I think it can be due to Kent's amazing productivity but he was not alone.  Maybe the painting world mirrors the real life Trumpian one where tax savings and painting totals accrue more to the upper end - who knows how these crazy economics work?


Percent of Total PointsIVVVIVIIVIII
Top 525%26%20%22%29%
Top 1041%42%33%35%44%
Top 2062%63%56%53%62%


And just because I can (the concept of "should" never entered my mind) lets take a look at the pace of submissions and their size over time.

ooooo  - look at all the pretty dots

And how does this daily look compare to last year - glad you asked 'cause here it is:  The only real difference his there were a lot more "mega days" during 8.  Also the end of challenge rush was a bit more muted than last year.  Still it's a lot of pretty red and blue dots so that's got to mean something.



Lets leave the snowflake world of graphics and look and lean and hard data tables - the kind your grandfather used to memorize while walking uphill to and from school in howling snowstorms during the summer.

AHPC VIII: THE STATS ROUNDUP
KPI's:
Weeks Completed24791113
Weeks Remaining1196520
Participants w/ a Submission526776767676
Total Submissions118238420531633770
Total Points7,18418,71636,56248,55259,55378,038
Participation Rate65%84%100%100%100%100%
Average per Submitter1382794816397841,027
Avg per Submission6179879194101
Submitter % of Target Completed15%41%59%79%97%127%
Projected Points
Submitters46,69660,82767,90179,04581,09778,038
Remaining Bouns Rounds7,5009,0003,500000
Non Submitters (Discounted)6,7691,0900000
Projected Total Points60,96570,91771,40179,04581,09778,038
Figures Painted
28MM
Inf8821,8913,2774,4655,4047,312
Cav / Art47128300432476678
Vehicles205195117136169
15MM
Inf1104041,1601,4132,0892,924
Cav / Art1625184209259598
Vehicles1670143175260342
6MM
Inf8341,4831,7812,2112,3552,479
Cav / Art225256116116133
Vehicles70187316324332342
Score Distribution
28MM72%61%57%58%57%59%
15MM5%7%11%10%11%13%
6MM8%6%4%4%3%3%
Bonus Round "Bonus Points"0%12%16%16%16%12%
Terrain3%4%3%3%2%4%
Other Scales15%10%8%9%10%10%
Total100%100%100%100%100%100%



ChallengeChallenge+/- Var+/- Var
KPI's:VIIIVIIUnitsPercentage
Weeks Completed1313
Weeks Remaining00
Participants w/ a Submission7696-20-21%
Total Submissions770919-149-16%
Total Points78,03883,200-5,162-6%
Participation Rate100%100%0%
Average per Submitter1,02786716018%
Avg per Submission101911112%
Submitter % of Target Completed127%132%-4.77%-4%
Projected Points
SubmittersN/AN/AN/AN/A
Remaining Bouns RoundsN/AN/AN/AN/A
Non Submitters @ 50%N/AN/AN/AN/A
Projected Total PointsN/AN/AN/AN/A
Figures Painted
28MM
Inf7,3127,945-633-8%
Cav / Art678719-41-6%
Vehicles169175-6-3%
15MM
Inf2,9243,679-755-21%
Cav / Art598817-219-27%
Vehicles342467-125-27%
6MM
Inf2,4792,11236717%
Cav / Art133195-62-32%
Vehicles342631-289-46%
Score Distribution
28MM59%60%-0.76%
15MM13%16%-2.95%
6MM3%3%-0.39%
Bonus Round "Bonus Points"12%12%0.11%
Terrain4%1%2.50%
Other Scales10%8%1.49%
Total100%100%


Economic Value Add
One of my favorite parts of this post is estimating the economic impact that Challenge has on the miniatures industry.  I'm using our standard estimating methodology which consists of:

1) Equating the total points produced into an equivalent number of 28mm infantry figures - this is done by dividing the total score by 5, since we award 5 points per figure.

2) I then break down the cost of submitting a figure by estimating unit costs for (i) the cost of the mini and base, (ii) the cost of paints, glue and other supplies and finally (iii) an estimate of the value of labor form painting time.  I've raised the unit charges for both Paints, etc and Painting Time to reflect the inclusion of terrain as a category and the fact that most of our economies are entering a period of sustained rising rates - which will drive some form of cost inflation.

The base value add is then the product of multiplying the unit costs times the equivalent number of 28mm figures - in this case $16.00 times 15,608, which equals $249,722

but we're not done....

3) The last step is to factor in velocity of spending.  It is a scientific fact that when miniature painters replace a figure, we don't simply do so on a one for one basis.  No, the heresy of "paint one / buy one" hasn't infected out happy society.  In fact we are much more likely to replace a painted figure with a number of new and shiny unpainted figures.  In truth, there are likely some scientific studies that have estimated this replacement velocity at 4 - for every one figure painted, one buys 4.  Personally, I find that number very conservative but lets go with the sake of science.

Using the "4" velocity factor and the base EVA of $249,722 , one gets a total economic impact of just under $1MM bucks.  A tidy little sum, indeed.


Ecomonic Value Add (EVA)
Total Points78,038
Equivalent 28mm Inf Minis15,608Economic
Value Add
Cost per Mini$2.50$39,019
Painte etc$2.50$39,019
Painting TIme$11.00$171,684
Sub Total$249,722
Velocity4$998,886


Even more impressive is the the lifetime total of EVA for the Challenge is approaching $4MM dollars.  I think we can get that value past $5MM by the end of Challenge !

EVA TrendlineLifetime
IIIIIIIVVVIVIIVIIITotal
Participants624486172889676471
Total Points2,24530,56542,07959,93565,10564,69083,20078,038425,857
Equivalent 28mm figures4496,1138,41611,98713,02112,93816,64015,60885,172
Economic Value Created (000's)$14.2$193.5$266.4$379.4$500.0$569.3$898.6$998.9$3,820.2


Hall of Heroes:

It's now time to take a trip to the Hall of Heroes, where we can gave upon the visages of our painting champions as they bask in the sun.  Word to the wise - knock before you enter.  Ray's become obsessed with avoiding tan lines and well umm some things just can't be unseen.  I think he's watching to much of "Keeping Up with the Kardassians".  Anyway, through challenge 8 there have been a total of 471 entrants, with many people participating multiple times.

First, I'm very happy to announce that the exclusive "10,000 Club" is welcoming two new members this year as both Martin C and Kent G have amassed more than 10,000 lifetime Challenge posts.  They will soon be joining DaveD, Tamsin, RayR and yours truly in our swanky walnut paneled painting room.  Gentlemen, your club painting jackets should arrive in the mail any day now.  Please remember to wear them at all club functions.  Please don't listen to anything Ray might say about club attire protocols and pants are definitely required.  Oh, one last thing, - any rumors you might hear about club funds being inappropriately diverted to building a "20,000 club annex" are greatly exaggerated....


RankNameLieftime Points# of Challenges
1MilesR19,6097
2DaveD16,7867
3MartinC13,8354
4KentG12,5183
5RayR11,8807
6TamsinP10,3285
7ByronM9,8835
8Millsy9,4576
9IanW8,6926
10AlexS8,5833

Perhaps the most astonishing accomplishment of this year's challenge is the setting of a new individual challenge painting total - KentG managed to paint an astonishing 5,343 points which eclipsed the previous mark held by Ray since Challenge 2.  I'm gobsmacked by Kent's productivity and amazing quality.  Hat's off to Kent!

Challenge 8 was also remarkable as it set 5 of the top 15 lifetime scores - a most productive Challenge if ever there was one.

RankChallengeChallengerPoints
18KentG5,343
22RayR4,940
38NoelW4,880
42KentG4,724
58MilesR4,550
64AndrewS4,180
75DaveD4,138
87MilesR4,125
93ChrisP4,076
107MartinC4,051
118ByronM3,881
125MarkO3,854
138MartinC3,844
143JamesB3,761
157GrahameH3,611

Well there you have - the story of the Challenge in Stats.

I think some thanks are in order:

Curt: Thanks again for organizing this madness and letting it take over your winter months up there in Canadia-Land

Sarah: Thanks for putting up with this silliness

My fellow Minioneers: Thanks for surviving yet another encounter with the spreadsheet of doom.  I'm thinking of redesigning the thing from scratch next year so we can make all sorts of new mistakes together.

My Fellow Challengers: Thanks for a wonderful 3 months and a reminder that this hobby is filled with great people and fellowship.

Now it's time for us all to emerge from the basement and figure out what that round yellow thing in the sky is.


From BenitoM: The year of the Austrians

It's almost incredible how time flies. I still have fresh memories of prepping my models, buying some new brushes and anticipating the Christmas holidays... look like just yesterday. It's been my third challenge this year and so far the one I enjoyed the most.

The group photo is not very good but here is the full output of these three months, 100% pure Napoleonic stuff.



The Challenge this year has been an excellent catalyst to accelerate my Austrian Army project and not just for the amount of models painted, but also because it enticed me to do some research looking for info about less popular units participating in the 1809 battles. That's how I found the Vienna Volunteers, which has been a joy to paint specially because I saved my eyes from so much bright white paint.

I also took the opportunity to paint some of my old 1/72 Airfix British, the scale we are using in the club to play General d'Armee these days, and a few French reinforcements for L'Empereur Grande Armee.

Thanks to Curt for taking up the challenge of organizing The Challenge again. To Adam (aka Sidney Roundwood) the Monday minion-on-duty, to Millsy for the duel accounting and to the rest of participants for your comments to my painting work and of course for your wonderful submissions (I have now a literally bursting folder of photos in my laptop that I have stored as reference for future projects).

I like to conclude the final Challenge post with a photo of a visit to some place of military significance. Here is one from a visit last October to Almeida, Ciudad Rodrigo and Fuentes de Oñoro. This was taken at Fuerte de la Concepción, a XVII century Vauban fortification converted into 4-start hotel (here if you want to know more) with my wife and a another friend.



Hope all participants a wonderful rest of the year and will see you again in December.

Reminder: Submit in your Nominations for Challengers' Choice



Hi All!

Just a quick reminder to all interested participants to email me your nominations for Challengers' Choice. The deadline for nominations is midnight tonight. I'll put up a gallery of all the selections and a poll for voting.

The voting results will be announced on April 8th.

Thanks!

Curt