Showing posts with label Spreadsheets Are Witchcraft. Show all posts
Showing posts with label Spreadsheets Are Witchcraft. Show all posts

Monday, 18 January 2016

From MilesR Week 4 Statistical Update

Happy, happy,  joy, joy, it's statistical story time once again.  So everyone gather round for another thrilling rendition of derring-do with decimal points as we delved into the Analogue Hobbies Painting Challenge VI Week 4 Statistical Update.  Please make sure you are all wearing your Official "AHPC Pocket Protectors" and tin foil hats.  For those reprobates who have misplaced theirs please Professor Douglas as he has loads of extras.  (True but delinquents will need complete a remedial day of dog poop clearing for Curt first.)

So what's the big news for this weeks update?  Participation rates have zoomed up 50% with now 61 of our 88 participants making a submission over week 2's 41.  Productivity also seems to be increasing with the cumulative points soaring to 18,328 in week 4 vs weeks 2's 6,392 - that's a 3x increase and almost surely due to the positive motivational aspects of measurement and analysis.  I'm sure you are all equally inspired by the benefits of progress monitoring and the application of quantitative theory.  For those of you who are, sadly, not so inspired please see me after story time for reprogramming - oops, I mean retraining.

Total projected points has also increased to 69,290 from 58,811 based on arcane and magical estimation techniques.

Perhaps the biggest surprise for me is the relatively limited level of 15mm scaled submissions.  To date only 814 of the 18,328 points earned so far have come in the 15mm scale category.  28mm continues to dominate the points category but 6mm seems to be making a strong bid to be second.  Who will win the duel for second place between 15mm and 6mm?  We will have to wait and see.

So without further ado, here's the detailed stats table of progress through week 4.  Please note this table does include the points earned for the "Nostalgia" bonus round but not the recently posted "Epic Fail".  I have segregated the bonus round participation points so we can keep track of just brush work points.

Behold the stats table - gaze upon it's terrible beauty and fear it's divine wrath.....

KPI's:
Weeks Completed24
Weeks Remaining108
Participants w/ a Submission4161
Total Submissions98231
Total Points6,39218,328
Participation Rate47%69%
Average per Submitter156300
Avg per Submission6579
Submitter % of Target Completed16%34%
Projected Points
Submitters38,35254,984
Remaining Bouns Rounds12,30010,250
Non Submitters @ 25%9,1594,056
Projected Total Points59,81169,290
Figures Painted
28MM
Inf9272,042
Cav / Art34140
Vehicles1940
15MM
Inf30255
Cav / Art434
Vehicles2028
6MM
Inf2081,153
Cav / Art106180
Vehicles97133
Score Distribution
28MM82%67%
15MM3%4%
6MM6%6%
Bonus Round "Bonus"0%11%
Other Scales8%13%
Total100%100%


Friday, 8 January 2016

Your Friday Minion Will Be Slightly Delayed

A rendition of my plans for today...
Greeting to all Challengers!  I have the honour of serving as your designated minion today and for the Fridays throughout this year's edition of Challenge. I beg your patience while I attempt this work, as there is a spreadsheet involved. I am among the enlightened who recognize such things as witchcraft, and use of them may, in fact, bring on the apocalypse.  My first concern is that I have assured several times it's "easy"...the first dark uttering of any shaman of IT, as far as I'm concerned. So I beg your patience and forgiveness of any initial points errors which, for example, might reduce Millsy's score to "0".

And much as I look forward to my minion tasks, I further regret to inform you there will be a slight delay to some postings today as I am en route back from a lovely holiday in Hawaii. I should be able to finalize several of your posts via the wifi at the 24/7 clown show we in Canada recognize as  "Vancouver Airport", but the rest will be attended to through the afternoon and evening back in my cozy home town of Winnipeg, Manitoba, Canada.

It takes a lot to get me to stop painting...but this will do it - sunset over the Pacific Ocean...aloha!
One note - since my ambient temperature is changing from +27 degrees celsius to -23 degrees celsius, any winter-themed entries submitted today will be docked 100% of eligible points...you have been warned...

Thanks folks!