Free software!

[LineCutter]

No problem - it was partly that I needed to know what the results were & partly that I needed to get to grips with the programming.

I too was being slightly silly. I did float the idea at the Bicton field shoot with a "pure" field archer, who seemed to think that there was potential for tracking thing for NFAS shoots (particularly apposite as the one we'd just done was 31 targets, hardly a traditional number).

As for V2, the reason I wrote FullMonte is that I've got to get my head around a fully revised version of the rota management software that I wrote for work. V1 of that is now up to V1.8 or so & has been extended so far that you can pick the code out of trees in Switzerland in a few days time. It's doing 4 times the work it was designed for & is depended on for many tasks, but it's time it got replaced. That has to come before the FullMonte V2, even if it is probably going to be easier than I'd estimated to get the outdoor rounds capable version working.

Hint:Try "1957 Harvest BBC Panorama" in google

[robbo]

I've pretty much got it sussed that you can now transfer your scores from my score card spreadsheet direct to a .csv file for use with linecutters program. I would appreciate at least one of you testing this for me before i go ahead and add it to all the sheets.

If you wanna test it then please download the following:

demo scorecard

50m.csv

Instructions:
make sure you save both files in the same directory.
Open the demo scorecard file as per normal, then click on the short metric link as this is the one that has the working demo on it. Ignore the error messages for all the other rounds, i deleted the cards to make this demo download smaller (600kb rather than 8mg).

Add some 50m scores to the first scorecard (ignore 30m for now). At the top left of the page you'll see the 'Add score to 50m.csv' button...click it!

There should be a flash of activity as excel opens 50m.csv, writes the info then 'saves it as', and finally closes the csv file.

I have added this to the first 10 cards in this round, so you can repeat the process for each with hopefully the same result each time. You can now open linecutters program and load the 50m.csv file which should now contain your arrow scores (albeit made up ones).

NOTE: For now you will need to enter any missess as a naught, i will work on a way to fix this aswell.

please let me know whether this works or not...

[LineCutter]

I get "Runtime error 1004" ... 50m.csv cannot be found (& yes, I've got it in the same directory).

This gets highlighted in the debugger:
Workbooks.OpenText Filename:= _
"50m.csv"

Is there a conditional option to create or add to a file depending on it's existance?

A quick squint at the "ghost" selection to the right of the main data entry page seems to show the right numbers, so you're barking up the right tree.

[Marcus26]

I would try this but run Macs in my house and business.

[robbo]

thanks for testing it linecutter, i've changed the syntax for opening the file, could you re-download demo.xls and try it again, much appreciated.

[wingate_52]

Brilliant bit of software. It makes me wonder why I keep lists, plus discs of data from years ago that may no longer run as i don't have the BBc Master and no longer use the Amiga computer. Long live excel.

[robbo]

did that mean that clicking the 50m.csv button now works wingate???

[LineCutter]

Originally Posted by Marcus26

I would try this but run Macs in my house and business.

There's always one!
Theoretically, if I spent the money, I could compile the same source code for Macs too. The prototype was written in 30 minutes in REBOL, but the mac version isn't out yet, so that's no use to you. Ho hum, I was hoping someone would test the "X" handling for me.

[LineCutter]

Originally Posted by robbo

thanks for testing it linecutter, i've changed the syntax for opening the file, could you re-download demo.xls and try it again, much appreciated.

It now brings up a file dialog to select the .csv file & works perfectly. I'd consider the concept proved, although the execution could be streamlined a little for regular users

[LineCutter]

My posting total is looking underused & I'm away for a few days... No, that wasn't it.

I've put a web page up, so that the wider community can get at FullMonte. Google hasn't detected it yet, but I feel fame & fortune beating a path to my door.
You can find it here.