Shot plotting and display programme

[PeteJ]

I'm using an old KME electronic target with a laptop and can export .txt files with ; separated data, including x y co-ordinates, shot time of day, score value etc.

I'm now in search of a clever spreadsheet or other programme to display the data in various ways, for analysis and printing of graphics of groups of 10 shots, overall group, plus aggregate decimal score and maybe even maximal score on group centering etc.

Does anyone have an ideas about anything on the market that could import the .txt data and render it in some or all of these ways?

Thanks in advance for any responses to my first posting here.

Pete J

[SamEEE]

Want to paste a copy of a output file to pastebin for me and I might be able to do something with it.

http://pastebin.com/

I could come up with something halfway decent which would work with Open Office.

Does it output/add-to the file in realtime?

Welcome to TargetTalk!

[BigAl]

I'm sure with a copy of one of the files some of us may be able to come up with something. Seems like there is plenty of useful data in there to work with. If you post a copy so that those of us who may be interested can work on it. One with data on a full match included would probably be best. Having real data to work with is always better than trying to create some for testing puropses.

Alan

[RossM]

Good idea. Sure there are 356 ways of skinning a cat.

Put a file up here and lets see what happens.

[PeteJ]

Thanks all, an amazing response.

We're just back from the range and put in 50 shots at 50m before the 10 pm curfew, as it was only commissioned tonight. So here it is in body text, pasted straight from the .txt file (and also attached). Apologies, the clock and year need resetting, but hopefully the data's there to work from, although I'm not sure where the seconds appear (if anywhere). The KME also produces an unusual X for 10 and *for inner 10, followed by the decimal, both of which you can ignore, as the proper decimal score is also provided. I'm also not sure what the 7 figure code in the last column is.

BTW, the KME creates the .txt fikle on export, so I don't know what goes on when it's running in the KME programme. Post match analysis is the main goal though, as the KME programme gives you what you need during shooting.

Happy crunching... and thanks again.

1;07.04.2024;22.16;11;*.7;10;7;-1.975;-0.012;2093154;0;0
2;07.04.2024;22.17;11;X.0;10;0;-7.304;-0.479;2136384;0;0
3;07.04.2024;22.17;11;9.4;9;4;-3.842;11.580;2168570;0;0
4;07.04.2024;22.18;11;*.5;10;5;1.245;3.591;2210755;0;0
5;07.04.2024;22.19;11;9.3;9;3;4.177;12.850;2244987;0;0
6;07.04.2024;22.19;11;X.1;10;1;-1.592;6.573;2282850;0;0
7;07.04.2024;22.20;11;*.4;10;4;-2.155;3.903;2326762;0;0
8;07.04.2024;22.21;11;9.2;9;2;2.741;13.689;2359542;0;0
9;07.04.2024;22.21;11;X.3;10;3;-2.083;4.932;2398977;0;0
10;07.04.2024;22.22;11;X.1;10;1;6.070;2.310;2432175;0;0
11;07.04.2024;22.22;11;9.3;9;3;11.015;6.679;2465527;0;0
12;07.04.2024;22.23;11;*.6;10;6;1.628;1.916;2512343;0;0
13;07.04.2024;22.24;11;*.7;10;7;1.077;1.221;2551822;0;0
14;07.04.2024;22.24;11;X.0;10;0;2.490;-7.231;2585141;0;0
15;07.04.2024;22.25;11;9.8;9;8;1.963;-8.596;2616106;0;0
16;07.04.2024;22.26;11;*.3;10;3;-1.233;-5.088;2657983;0;0
17;07.04.2024;22.26;11;X.0;10;0;-0.778;-7.913;2697154;0;0
18;07.04.2024;22.27;11;9.5;9;5;10.967;-3.901;2742694;0;0
19;07.04.2024;22.28;11;9.2;9;2;13.699;1.579;2783284;0;0
20;07.04.2024;22.28;11;*.4;10;4;4.034;0.874;2815063;0;0
21;07.04.2024;22.29;11;9.2;9;2;12.859;6.270;2843784;0;0
22;07.04.2024;22.29;11;*.7;10;7;-0.275;-2.262;2880062;0;0
23;07.04.2024;22.30;11;*.8;10;8;1.269;-0.144;2940991;0;0
24;07.04.2024;22.31;11;9.0;9;0;-6.856;-14.068;2970229;0;0
25;07.04.2024;22.31;11;9.8;9;8;-0.299;-9.182;2998565;0;0
26;07.04.2024;22.32;11;X.2;10;2;-1.688;-5.542;3028738;0;0
27;07.04.2024;22.32;11;*.6;10;6;1.376;2.597;3053686;0;0
28;07.04.2024;22.33;11;X.1;10;1;-1.209;-6.978;3078535;0;0
29;07.04.2024;22.33;11;X.2;10;2;2.896;5.506;3114098;0;0
30;07.04.2024;22.34;11;*.6;10;6;3.004;0.706;3142544;0;0
31;07.04.2024;22.34;11;*.6;10;6;0.359;2.920;3183222;0;0
32;07.04.2024;22.35;11;X.1;10;1;6.535;-1.077;3212020;0;0
33;07.04.2024;22.35;11;X.1;10;1;-5.122;-4.045;3238717;0;0
34;07.04.2024;22.36;11;X.0;10;0;-4.787;-5.481;3262059;0;0
35;07.04.2024;22.36;11;*.3;10;3;2.741;-4.392;3285434;0;0
36;07.04.2024;22.37;11;*.8;10;8;0.012;-1.496;3318291;0;0
37;07.04.2024;22.37;11;X.1;10;1;2.513;6.726;3344734;0;0
38;07.04.2024;22.38;11;*.8;10;8;1.280;0.850;3372520;0;0
39;07.04.2024;22.38;11;X.0;10;0;4.260;6.702;3399723;0;0
40;07.04.2024;22.38;11;X.1;10;1;-5.217;4.188;3425716;0;0
41;07.04.2024;22.39;11;9.9;9;9;-7.192;3.793;3450675;0;0
42;07.04.2024;22.39;11;X.2;10;2;-3.338;4.918;3474369;0;0
43;07.04.2024;22.40;11;*.6;10;6;-2.286;-1.591;3499867;0;0
44;07.04.2024;22.40;11;*.4;10;4;-4.009;0.227;3521548;0;0
45;07.04.2024;22.40;11;*.4;10;4;-0.371;-4.176;3545418;0;0
46;07.04.2024;22.41;11;*.3;10;3;-4.260;-2.728;3571235;0;0
47;07.04.2024;22.41;11;9.6;9;6;6.940;-8.783;3598438;0;0
48;07.04.2024;22.42;11;9.6;9;6;9.669;-5.192;3624838;0;0
49;07.04.2024;22.42;11;9.8;9;8;8.724;-3.434;3663723;0;0
50;07.04.2024;22.43;11;*.5;10;5;-1.807;-3.266;3691168;0;0

[SamEEE]

Scratching my head on the 7 digit number a bit.

Perhaps the first digit is a quadrant number?

[john bickar]

Apologies, the clock and year need resetting... I'm also not sure what the 7 figure code in the last column is.

Probably a UNIX timestamp. First and last are about 2 hours apart...in 1970.

As far as what program/app, maybe D3.js?

[SamEEE]

Managed to interpret the data which was the first challenge.

Turns out Column 8 (X) and 9 (Y) are Cartesian coordinates from the origin. The origin being the centre of the target.

Stumbled upon this by plotting the points in LibreOffice Calc (free version of Excel). This yielded:


Cheap and dirty graph. But quick and offered insight, most important of which was the scale of data: 10 points to a ring.

Haven't used MATLAB for a long time, in fact not since I bombed out of University, but I battled with it enough back then to remember that it makes fairly clean looking graphs.

Bit of google-fu to remember how to code MATLAB yielded the following:


Damn, that's some fine shooting.

Code: Select all

%  MATLAB Program to plot shots from a KME Electronic Scoring Machine.
%  SJM 9/4/14

scatter (x,y,'r+')              % Scatter graph of data.
axis([-25,25,-25,25])           % Setting graph limits

xL = xlim;
yL = ylim;
line([0 0], yL);                %x-axis
line(xL, [0 0]);                %y-axis

hold on

z = 5*exp((0:.1:2*pi)*i);       %plot 'x' ring
plot(real(z), imag(z), 'b');

hold off

hold on 

z = 10*exp((0:.1:2*pi)*i);      %plot 10 ring
plot(real(z), imag(z), 'b');

hold off

hold on     

z = 20*exp((0:.1:2*pi)*i);      %plot 9 ring
plot(real(z), imag(z), 'b');

Hope this helps anyone working on this.

My next mission will be to try make a free program which will scrape the data off the text file and spit a series of graphs (10 shots per graph, each with a sum of shots).
Maybe some 3D heat maps type graphs as a challenge to myself.

Probably could pull some more interesting data from this such as standard deviations to measure shot dispersions etc.

Anyway i'm off to the range to blast some holes in paper. Will follow this thread with interest and keep working on this myself.

[rmca]

Have a look at Softshot from Rika
http://www.shotsoft.de/shotsoft.html
Although it's originally designed for reading paper targets from Rika's Easy Score machine, it can receive data from other types and has all the functionalities you want.
There is also a demo version that allows 20 shoots per shooter.

Hope this helps

[redschietti]

Some how I suspect you all are going to be paralyzed by analyzing, instead of training.

[PeteJ]

Some how I suspect you all are going to be paralyzed by analyzing, instead of training.

Hopefully the original question/specification, which is no more than native operations on Scatt, Sius etc can do, will help:

...analysis and printing of graphics of groups of 10 shots, overall group, plus aggregate decimal score and maybe even maximal score on group centering etc.

[PeteJ]

It looks like targetsoft will only import sius files so I can't see how to import a .txt file from the KME. any thoughts?

However, I seem to have downloaded a Sius .txt file with it (attached), which looks familiar to the KME and gives me hope...

PeteJ

[SamEEE]

Some how I suspect you all are going to be paralyzed by analyzing, instead of training.

I somehow suspect you have failed to see that both training and analysis/evaluation are inextricably linked.

Training without evaluation is blind, or at least it is in my opinion.

Pete: Want post a SUIS txt file? I might be able to do some wizardry.

[PeteJ]

Hi SamEE

The file turned out to be a .log which can't be attached, even after renaming with a .txt extension. Anyway, here it is pasted:

ShotSoft Protokolldatei für SiusData Import erzeugt am 9.04.2014 21:16

Warnung Zeile 1: Kein Matchschuss
1;31.03.2024;22.40;11;X.0;10;0;-6.371;-4.255;2307090;0;0

Warnung Zeile 2: Kein Matchschuss
2;31.03.2024;22.41;11;X.1;10;1;1.683;6.876;2348670;0;0

Warnung Zeile 3: Kein Matchschuss
3;31.03.2024;22.41;11;*.4;10;4;0.024;-4.711;2377402;0;0

Warnung Zeile 4: Kein Matchschuss
4;31.03.2024;22.42;11;X.1;10;1;0.901;6.719;2409006;0;0

Warnung Zeile 5: Kein Matchschuss
5;31.03.2024;22.42;11;*.4;10;4;-3.185;3.161;2439003;0;0

Warnung Zeile 6: Kein Matchschuss
6;31.03.2024;22.43;11;X.2;10;2;-2.547;-5.215;2465579;0;0

Warnung Zeile 7: Kein Matchschuss
7;31.03.2024;22.43;11;9.6;9;6;-10.468;-3.160;2496313;0;0

Warnung Zeile 8: Kein Matchschuss
8;31.03.2024;22.44;11;9.4;9;4;-0.565;12.489;2533691;0;0

FEHLER Zeile 9: Teilnehmer nicht gefunden
9;31.03.2024;22.44;11;X.1;10;1;2.367;-6.333;2558903;0;0

FEHLER Zeile 10: Teilnehmer nicht gefunden
10;31.03.2024;22.45;11;X.3;10;3;-4.674;-2.944;2585094;0;0

FEHLER Zeile 11: Teilnehmer nicht gefunden
11;31.03.2024;22.45;11;X.2;10;2;-4.986;-2.559;2608656;0;0

FEHLER Zeile 12: Teilnehmer nicht gefunden
12;31.03.2024;22.46;11;9.7;9;7;-0.577;9.853;2659179;0;0

FEHLER Zeile 13: Teilnehmer nicht gefunden
13;31.03.2024;22.46;11;X.1;10;1;-3.832;-5.682;2684402;0;0

FEHLER Zeile 14: Teilnehmer nicht gefunden
14;31.03.2024;22.47;11;9.3;9;3;10.909;7.663;2706875;0;0

FEHLER Zeile 15: Teilnehmer nicht gefunden
15;31.03.2024;22.47;11;9.7;9;7;1.285;9.696;2732901;0;0

FEHLER Zeile 16: Teilnehmer nicht gefunden
16;31.03.2024;22.48;11;9.8;9;8;4.636;8.169;2755748;0;0

FEHLER Zeile 17: Teilnehmer nicht gefunden
17;31.03.2024;22.48;11;9.9;9;9;0.985;8.048;2784513;0;0

FEHLER Zeile 18: Teilnehmer nicht gefunden
18;31.03.2024;22.48;11;9.8;9;8;9.334;2.173;2813058;0;0

FEHLER Zeile 19: Teilnehmer nicht gefunden
19;31.03.2024;22.49;11;*.7;10;7;-2.186;0.961;2836543;0;0

FEHLER Zeile 20: Teilnehmer nicht gefunden
20;31.03.2024;22.49;11;X.2;10;2;4.828;2.858;2861447;0;0

FEHLER Zeile 21: Teilnehmer nicht gefunden
21;31.03.2024;22.50;11;9.8;9;8;9.394;0.432;2885779;0;0

[SamEEE]

Interesting... anyone else got any Electronic Scoring machine data they can throw up? Might as well go whole hog with this project.

SJM

[dronning]

Some how I suspect you all are going to be paralyzed by analyzing, instead of training.

I somehow suspect you have failed to see that both training and analysis/evaluation are inextricably linked.

Training without evaluation is blind, or at least it is in my opinion.

You should be focusing on each shot, scratch that, you should be focusing on how you got that 10 or X you just shot and train to repeat it.

"If you shoot an 8 and focus on what you did wrong to try and correct it all you will do is get more 8's. If you want more 10's, focus on what you are doing right and repeat that" - Lanny Bassham, Olympic Gold medalist.

Analysis after the fact is going to be flawed unless you document each shot and what went on during the shot and then the result. This is why the SCATT is so powerful, it is not the result of the shot that is important, it is the trace leading up to it that tells the story and you can see exactly what happened with each shot.


That said and aside, it looks like an interesting project.

[PeteJ]

I'm waiting on some Meyton export data and assured it's csv, so hope it will be helpful.

In the meantime, the Meyton BallisticsManager manual gives a useful indication about how group diameter etc. can be rendered. See pages 37 and 42

http://www.meyton.info/uploads/media/Ba ... ium_en.pdf

[RossM]

I would be interested in anyone who has kept some really good 60 shot macthes (air rifle or 50m) and have their XY plots.

Given the need to keep the group small and maximise the decimal score, it has been discovered that the samllest outside to outside group may not necessarily be the best way to pick ammunition.

One possibility is to total the distances from the centre of the target over the 60 shots. The hypothesis being that the smaller the total means a higher decimal total score. (This can of course be done using the decimal score total but the total distances may give even more discrimination).

Anyone got any 630, 620, 620 600 totals out there???

This worked out by Pythagoras.

Square root of (X squared + Y squared). Then Total that column.

In excel: =sqrt(cell(X)^2+cell(Y)^2)
At bottom =sum(column with the 60 distances above in it)

[PeteJ]

RossM, agreed... on testing it's about score, not outside diameter, as, within limits, a 'petal' group isn't going to score as highly as a stacked one with a single 'flyer'.

I think it's still worth marking diameter when rendering test data, but p42 of the Meyton pdf is a model for me, showing the outer diameter, decimal score and a bar graph to show the inner detail:
http://www.meyton.info/uploads/media/Ba ... ium_en.pdf

In the meantime, here's the recent Dortmund 633.6 by Daniel Brodmeyer in Meyton competitor output format: http://isas14.wsb1861.de/pdf/753.pdf . Not a CSV with coordinates unfortunately, but worth a look.

[RossM]

This may be of interest to all:

http://home.kpn.nl/jhhogema1966/skeetn/ ... gs/sgs.htm

You wull see the Rayleigh distribution - very relevant to the bar graphs - here on wiki. Noter Jeroen is cited along with his article

http://en.wikipedia.org/wiki/Rayleigh_distribution

He has done another on group testing but I cant find it at the moment.