<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Comic Sans MS";
panose-1:3 15 7 2 3 3 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
span.EmailStyle17
{font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body bgcolor=white lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Earl – </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Concur – score analysis helps –
and so does a coach, even one who isn’t a pilot. </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I’ve done a similar thing to Gordon’s
sheet – screen shot at <a
href="http://www.angelfire.com/nj3/rixplanes/scoring_analysis__coaching_aids.htm">http://www.angelfire.com/nj3/rixplanes/scoring_analysis__coaching_aids.htm</a></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>And I’ll be happy to send the actual
Excel sheet to anyone who wants it – it’s set up for Advanced, but
the Masters one will be available soon. (be forewarned -It has a macro in it that
computes cell fill color based on score – that might alert some computer protection
systems) </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>It’s an Excel sheet intended to show
score trends over the course of a season, and to highlight the high-K maneuvers…
</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> Once
the user enters the scores for each judge and round, there’s a macro
that colors the cells to show scores – e.g, 10 = green, 8= light blue, 5
= RED, 0 = really ugly purple (like a bruise) </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> Higher
K maneuvers are set to display in bold, italic or both, </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> The
sheet computes each raw round score is computed, and there’s a place for
the pilot to enter normalized score and placement in class for the round.</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> There’s
also a trend analysis part at the bottom tha compares mean score for each
maneuver across the contests flown- colored of course to show improvement (or
plateau or .. area for improvement. </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Use is pretty easy – </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> Enter
the scores for each round – takes about 30 min after the contest</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> Run
to macro to set the cell colors based on scores. </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> Make
up the practice plan for the coming week to eliminate the purple, red, orange,
yellow areas and get scores into the blue / green zone. </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>The sheet really does highlight areas for
improvement over a single contest, and does so even more as the season progresses.
</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>The other example at the link above is a ‘coaching
page for non-pilot coaches’ – like my wife. </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Color diagrams (powerpoint of course) , correct
geometries, arrows showing entry / exit – even names! And a set for each flight
direction. </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Wife goes to the field w/ me, marks on the
drawings what / where the errors are, and we use them as a basis for
post-flight discussions. </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Sportsman, Intermediate, Advanced diagrams
in pdf format are available on the Dq1 website, <a
href="http://ocmrc.us/NSRCAD1/home.htm">http://ocmrc.us/NSRCAD1/home.htm</a> or
I can provide powerpoint files to any who want them. </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>(Masters is about done—maybe next
week for the ppts.) </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Sorry, guys, the coach isn’t
available for anything except coaching … and good natured banter at D1
contests… </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Hope this helps. </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>-Rick </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> discussion-request@nsrca.org
[mailto:discussion-request@nsrca.org] <b><span style='font-weight:bold'>On
Behalf Of </span></b>Gordon Anderson<br>
<b><span style='font-weight:bold'>Sent:</span></b> </span></font><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>Friday, January
14, 2005</span></font><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'> </span></font><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>8:43 PM</span></font><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'><br>
<b><span style='font-weight:bold'>To:</span></b> discussion@nsrca.org<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: Pattern Help</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 color=blue
face="Comic Sans MS"><span style='font-size:12.0pt;font-family:"Comic Sans MS";
color:blue'>Earl,</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 color=blue
face="Comic Sans MS"><span style='font-size:12.0pt;font-family:"Comic Sans MS";
color:blue'>Regarding the calculation of statistics from the scoring of a
contest; I have attached a final score sheet from my scoring program used in
most of the D8 pattern contests last season. This program is a series of excel
spreadsheets and macros. I will give this to anyone interested but you will
need Microsoft Excel to use this program. </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 color=blue
face="Comic Sans MS"><span style='font-size:12.0pt;font-family:"Comic Sans MS";
color:blue'>I calculate a number of statistics and plot score distribution data
that I find very useful in focusing my practice. </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 color=blue
face="Comic Sans MS"><span style='font-size:12.0pt;font-family:"Comic Sans MS";
color:blue'>--Gordon </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<div class=MsoNormal align=center style='margin-left:.5in;text-align:center'><font
size=3 face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center>
</span></font></div>
<p class=MsoNormal style='margin-right:0in;margin-bottom:12.0pt;margin-left:
5in'><b><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:
Tahoma;font-weight:bold'>From:</span></font></b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'> discussion-request@nsrca.org
[mailto:discussion-request@nsrca.org] <b><span style='font-weight:bold'>On
Behalf Of </span></b>Earl Haury<br>
<b><span style='font-weight:bold'>Sent:</span></b> Friday, January 14, 2005
10:35 AM<br>
<b><span style='font-weight:bold'>To:</span></b> Discussion List, NSRCA<br>
<b><span style='font-weight:bold'>Subject:</span></b> Pattern Help</span></font></p>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Several have mentioned the lack of
help in the form of coaches, competent observers, etc. which could help them
improve their flying skills. This is probably more common than not,
and makes it difficult for each of us to improve (even the FAI guys). I've
found a couple of ways around this that some might find useful. </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>The first is score analysis. Simply
input raw scores (each maneuver / each judge) into a spreadsheet. Even a 4
round contest with 2 judges / flight will yield 8 scores / maneuver. Average
each maneuver's score set and calculate the standard deviation. This provides a
feel for how well any given maneuver was flown and a feel for consistency - the
lower the std dev the better. This info lets one see what needs improvement the
most and, over several contests, note progress.</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Of course score analysis doesn't
indicate just what the problem is. There have been many good suggestions
regarding seeking that input from fellow competitors, interested observers,
etc. Another method exists that can provide valuable info.</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>That method is a datalogger. I've
recently been using the latest USB Datalogger to look at in flight
parameters. <a href="http://www.eagletreesystems.com/Plane/plane.html">http://www.eagletreesystems.com/Plane/plane.html</a>
This newest version provides a useable graphics display of flight parameters (even
more useful if the data are evaluated in a spreadsheet) - your choice as to
just what to look at. I typically log altitude, airspeed, and aileron inputs. </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>The altitude inputs allow
observation of entry / exit altitudes, altitude changes in level flight,
diameter (height) of loops, cross over points, altitude loss / gain during spin
entry, altitude loss / gain during rolls, etc. All basic stuff that's important
to get right for good scores. Speed data provide clues as to where too
much / little power is used and whether a prop works well or not. The aileron
inputs can be superimposed on the altitude data to determine roll position on
vertical lines. While not all pattern parameters lend them selves to analysis
with this technology, a good deal can be learned with it.</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>While recently evaluating
engine / prop combinations (very top secret), I noted something that looks
useful regarding snaps. During both up and downline snaps the speed signal
drops to zero for a period of time roughly equivalent to snap duration. It
appears that possibly airflow separation from the wing includes the pitot tube.
Upline snaps also show a marked decline in ascent rate during the snap. </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Recent snap discussions have made me
curious, so I've decided to do some snap analysis with a G-force
sensor connected to the logger. I've ordered the sensor and plan to
take a good look at "real" snaps and barrel rolls. What to bet
that the G loads spike quickly then drop dramatically during
snaps, but increase throughout the barrel rolls? I'll present this work as
a K-Factor article when finished, if anyone wants data sooner,
a datalogger costs the same as a couple of servos.</span></font> </p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Earl</span></font></p>
</div>
</div>
</body>
</html>