<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">Speaking for everyone on the judge evaluation/ranking committee, we would love a technique to sift through all the contest results and move appropriate data to the master results list, without a manual transfer of data by the "stuckee", usually Don Ramsey. The problem is complicated by the way judges are identified. A judge's identification is consistent within a particular contest, usually his contestant number, but the numbers change for every contest. The only common thing is the judge's name.<DIV><BR class="khtml-block-placeholder"></DIV><DIV>If you have a piece of software that would enable extraction of data from the contest results and insertion into the master judge list, please let us know and, better yet, volunteer to work with us and implement it yourself.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Ron Van Putte</DIV><DIV><BR><DIV><DIV>On Oct 25, 2007, at 12:31 PM, J N Hiller wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"> <DIV class="Section1"><P class="MsoNormal"><SPAN class="EmailStyle18"><FONT size="2" color="navy" face="Arial"><SPAN style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial">Ron, that is a lot of work. You guys did some serious head scratching to generate usable data for evaluation. <SPAN style="mso-spacerun: yes"> </SPAN>What is not readily apparent is the ongoing effort required to continuously add data and update the information. <SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN><O:P></O:P></SPAN></FONT></SPAN></P><P class="MsoNormal"><SPAN class="EmailStyle18"><FONT size="2" color="navy" face="Arial"><SPAN style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial">The last few years I worked I was heavily involved in information gathering and processing building management tools. XL is a powerful and easy to use tool that was often too small for the data extracted from the ERP system. The answer to any question always brings another and it became easier to import massive amounts of raw data into a database tool where complex queries could be used to extract information having multiple relationships. XL pivot tables were often employed by individual managers to slice and dice general query data to mix and match specific relationships to accommodate most of the ‘what If’ questions’. I had Microsoft Access on my PC and found it semi-user friendly and with the help of our in-house programmer was ably to acquire basic user skills. Most programmers would prefer other more powerful database tools but Access had many built in tools for reports and user friendly queries such as individual judge performance and the ability to present supporting detail with no more than a mouse click. If the scoring program for a given contest retains the data it can most likely be imported into a database program to be consolidated and queried. Redundant manual data entry is probably not necessary if the program data files can be momentarily linked for data transfer. I would be happy to help if I can but </SPAN></FONT></SPAN><SPAN class="EmailStyle18"><FONT size="2" color="black" face="Arial"><SPAN style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial;color:windowtext">I </SPAN></FONT></SPAN><SPAN class="EmailStyle18"><FONT size="2" color="navy" face="Arial"><SPAN style="font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial">am a rank amateur compared to others.</SPAN></FONT></SPAN><SPAN class="EmailStyle18"><FONT size="2" color="navy" face="Arial"><SPAN style="font-size: 10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:navy;mso-color-alt: windowtext"><O:P></O:P></SPAN></FONT></SPAN></P><P class="MsoNormal"><SPAN class="EmailStyle18"><FONT size="2" color="navy" face="Arial"><SPAN style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial">Jim Hiller<O:P></O:P></SPAN></FONT></SPAN></P><P class="MsoNormal"><SPAN class="EmailStyle18"><FONT size="2" color="navy" face="Arial"><SPAN style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial"> <O:P></O:P></SPAN></FONT></SPAN></P><P class="MsoNormal"><SPAN class="EmailStyle18"><FONT size="2" color="navy" face="Arial"><SPAN style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial"> <O:P></O:P></SPAN></FONT></SPAN></P><P class="MsoNormal"><SPAN class="EmailStyle18"><FONT size="2" color="navy" face="Arial"><SPAN style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial"> <O:P></O:P></SPAN></FONT></SPAN></P><P class="MsoNormal" style="margin-left:.5in"><FONT size="2" color="black" face="Tahoma"><SPAN style="font-size:10.0pt;font-family:Tahoma;color:black">-----Original Message-----<BR> <B><SPAN style="font-weight:bold">From:</SPAN></B> nsrca-discussion-bounces@lists.nsrca.org [<A href="mailto:nsrca-discussion-bounces@lists.nsrca.org">mailto:nsrca-discussion-bounces@lists.nsrca.org</A>]<B><SPAN style="font-weight: bold">On Behalf Of </SPAN></B><A href="mailto:vicenterc@comcast.net">vicenterc@comcast.net</A><BR> <B><SPAN style="font-weight:bold">Sent:</SPAN></B> Thursday, October 25, 2007 5:28 AM<BR> <B><SPAN style="font-weight:bold">To:</SPAN></B> NSRCA Mailing List; NSRCA Mailing List<BR> <B><SPAN style="font-weight:bold">Subject:</SPAN></B> Re: [NSRCA-discussion] Judge Evaluation/Ranking</SPAN></FONT></P><P class="MsoNormal" style="margin-left:.5in"><FONT size="3" face="Times New Roman"><SPAN style="font-size:12.0pt"> <O:P></O:P></SPAN></FONT></P><P class="MsoNormal" style="margin-left:.5in"><FONT size="3" color="black" face="Times New Roman"><SPAN style="font-size:12.0pt;color:black">Ron,</SPAN></FONT><FONT color="black"><SPAN style="color:black;mso-color-alt:windowtext"><O:P></O:P></SPAN></FONT></P><P class="MsoNormal" style="margin-left:.5in"><FONT size="3" color="black" face="Times New Roman"><SPAN style="font-size:12.0pt;color:black"> </SPAN></FONT><FONT color="black"><SPAN style="color:black;mso-color-alt:windowtext"><O:P></O:P></SPAN></FONT></P><P class="MsoNormal" style="margin-left:.5in"><FONT size="3" color="black" face="Times New Roman"><SPAN style="font-size:12.0pt;color:black">This is a lot of work. Looks nice. Thanks to the evaluation/ranking committee.</SPAN></FONT><FONT color="black"><SPAN style="color:black;mso-color-alt:windowtext"><O:P></O:P></SPAN></FONT></P><P class="MsoNormal" style="margin-left:.5in"><FONT size="3" color="black" face="Times New Roman"><SPAN style="font-size:12.0pt;color:black"> </SPAN></FONT><FONT color="black"><SPAN style="color:black;mso-color-alt:windowtext"><O:P></O:P></SPAN></FONT></P><P class="MsoNormal" style="margin-left:.5in"><FONT size="3" color="black" face="Times New Roman"><SPAN style="font-size:12.0pt;color:black">Now, I have a question. How we can use this results to improve our judging? For example, I noticed that I did well in one set but not so well in the other. Just wondering if there is a way to know in which maneuvers I was having more problems.</SPAN></FONT><FONT color="black"><SPAN style="color:black;mso-color-alt:windowtext"><O:P></O:P></SPAN></FONT></P><P class="MsoNormal" style="margin-left:.5in"><FONT size="3" color="black" face="Times New Roman"><SPAN style="font-size:12.0pt;color:black"> </SPAN></FONT><FONT color="black"><SPAN style="color:black;mso-color-alt:windowtext"><O:P></O:P></SPAN></FONT></P><P class="MsoNormal" style="margin-left:.5in"><FONT size="3" color="black" face="Times New Roman"><SPAN style="font-size:12.0pt;color:black">Best regards,</SPAN></FONT><FONT color="black"><SPAN style="color:black;mso-color-alt:windowtext"><O:P></O:P></SPAN></FONT></P><P class="MsoNormal" style="margin-left:.5in"><FONT size="3" color="black" face="Times New Roman"><SPAN style="font-size:12.0pt;color:black"> </SPAN></FONT><FONT color="black"><SPAN style="color:black;mso-color-alt:windowtext"><O:P></O:P></SPAN></FONT></P><P class="MsoNormal" style="margin-left:.5in"><FONT size="3" color="black" face="Times New Roman"><SPAN style="font-size:12.0pt;color:black"> <DIV id="signature">--<BR> Vicente "Vince" Bortone</DIV> </SPAN></FONT><FONT color="black"><SPAN style="color:black;mso-color-alt:windowtext"><O:P></O:P></SPAN></FONT></P><P class="MsoNormal" style="margin-left:.5in"><FONT size="3" color="black" face="Times New Roman"><SPAN style="font-size:12.0pt;color:black"> </SPAN></FONT><FONT color="black"><SPAN style="color:black;mso-color-alt:windowtext"><O:P></O:P></SPAN></FONT></P> <DIV style="border:none;border-left:solid #1010FF 1.5pt;padding:0in 0in 0in 4.0pt"><P class="MsoNormal" style="margin-right:.5in;mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;margin-left:40.2pt;border:none;mso-border-left-alt:solid #1010FF 1.5pt; padding:0in;mso-padding-alt:0in 0in 0in 4.0pt"><FONT size="3" color="black" face="Times New Roman"><SPAN style="font-size:12.0pt;color:black">-------------- Original message -------------- <BR> From: Ron Van Putte <<A href="mailto:vanputte@cox.net">vanputte@cox.net</A>> <BR> The NSRCA judge evaluation/ranking committee (Tony Stillman, Matt Kebabjian and Ron Van Putte, with Don Ramsey acting as an advisor and doing most of the tabulation work), have posted the latest methodology and scores of the NSRCA Judge Evaluation program on </SPAN></FONT><FONT color="black"><SPAN style="color:black;mso-color-alt:windowtext"><O:P></O:P></SPAN></FONT></P><P class="MsoNormal" style="margin-right:.5in;mso-margin-top-alt:auto;margin-left: 40.2pt;border:none;mso-border-left-alt:solid #1010FF 1.5pt;padding:0in; mso-padding-alt:0in 0in 0in 4.0pt"><FONT size="3" color="black" face="Times New Roman"><SPAN style="font-size:12.0pt;color:black"><A href="http://www.nsrca.org/competition/judging/judging.htm"><FONT color="#0000e3"><SPAN style="color:#0000E3">http://www.nsrca.org/competition/judging/judging.htm</SPAN></FONT></A> Scroll down to the bottom left of the page.</SPAN></FONT><FONT color="black"><SPAN style="color:black;mso-color-alt:windowtext"><O:P></O:P></SPAN></FONT></P><P class="MsoNormal" style="margin-right:.5in;mso-margin-top-alt:auto;margin-left: 40.2pt;border:none;mso-border-left-alt:solid #1010FF 1.5pt;padding:0in; mso-padding-alt:0in 0in 0in 4.0pt"><FONT size="3" color="black" face="Times New Roman"><SPAN style="font-size:12.0pt;color:black"> </SPAN></FONT><FONT color="black"><SPAN style="color:black;mso-color-alt:windowtext"><O:P></O:P></SPAN></FONT></P><P class="MsoNormal" style="margin-right:.5in;mso-margin-top-alt:auto;margin-left: 40.2pt;border:none;mso-border-left-alt:solid #1010FF 1.5pt;padding:0in; mso-padding-alt:0in 0in 0in 4.0pt"><FONT size="3" color="black" face="Times New Roman"><SPAN style="font-size:12.0pt;color:black">Please understand that this is a work-in-progress and, since results from each competition are manually entered into the final listing, errors will occur. As errors are discovered, they will be fixed.</SPAN></FONT><FONT color="black"><SPAN style="color:black;mso-color-alt:windowtext"><O:P></O:P></SPAN></FONT></P><P class="MsoNormal" style="margin-right:.5in;mso-margin-top-alt:auto;margin-left: 40.2pt;border:none;mso-border-left-alt:solid #1010FF 1.5pt;padding:0in; mso-padding-alt:0in 0in 0in 4.0pt"><FONT size="3" color="black" face="Times New Roman"><SPAN style="font-size:12.0pt;color:black"> </SPAN></FONT><FONT color="black"><SPAN style="color:black;mso-color-alt:windowtext"><O:P></O:P></SPAN></FONT></P><P class="MsoNormal" style="margin-right:.5in;mso-margin-top-alt:auto;margin-left: 40.2pt;border:none;mso-border-left-alt:solid #1010FF 1.5pt;padding:0in; mso-padding-alt:0in 0in 0in 4.0pt"><FONT size="3" color="black" face="Times New Roman"><SPAN style="font-size:12.0pt;color:black">Ron Van Putte</SPAN></FONT><FONT color="black"><SPAN style="color:black;mso-color-alt:windowtext"><O:P></O:P></SPAN></FONT></P><P class="MsoNormal" style="margin-right:.5in;mso-margin-top-alt:auto;margin-left: 40.2pt;border:none;mso-border-left-alt:solid #1010FF 1.5pt;padding:0in; mso-padding-alt:0in 0in 0in 4.0pt"><FONT size="3" color="black" face="Times New Roman"><SPAN style="font-size:12.0pt;color:black"> </SPAN></FONT><FONT color="black"><SPAN style="color:black;mso-color-alt:windowtext"><O:P></O:P></SPAN></FONT></P> </DIV> </DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">_______________________________________________</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">NSRCA-discussion mailing list</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="mailto:NSRCA-discussion@lists.nsrca.org">NSRCA-discussion@lists.nsrca.org</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="http://lists.nsrca.org/mailman/listinfo/nsrca-discussion">http://lists.nsrca.org/mailman/listinfo/nsrca-discussion</A></DIV> </BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>