Import Monster Dec Deca Wrap Up

[BlackTemplar]

Still no pics of my Cressida

Here ya go Chris

https://picasaweb.google.com/114814952165347619692/Cressida?authkey=Gv1sRgCPKykL6E-djQeA

[Timding]

Hey. Did you happen to get any of the 86's on the day. There were 2 black and 1 white.

[BlackTemplar]

sure did, which one was yours? Im assuming the other black one, not Aarons

[Chris_CCRUZE]

Wow I love you !!!!

Here ya go Chris

https://picasaweb.google.com/114814952165347619692/Cressida?authkey=Gv1sRgCPKykL6E-djQeA

[Belsil80]

Results are coming... next couple of days.

[lswal2]

Hey Ryan,

Apologies in advance for the following. I'm just offering up an idea which I think could save you a bit of time and effort (so don’t shoot me!!!!!)

I'm assuming that "data entry" is the reason why the results have taken so long to process. EG: the results are written on paper and need to be typed into spread sheets.

Why not enter the time(s) at the end of each run straight into a spread sheet?

It doesn’t strike me as much more effort than writing it down.

I understand that this means up to 3 laptops are required to work on 3 separate spread sheets, but merging the documents has got to be easier than re-entering the data. (Paper times could still act as a backup).

SAU VIC could then announce the results that night during the after DECA drinks, instead of people pestering you for results a month on.

This might not be the most elegant solution.. But its an idea..

- THIS DEC DECA WAS THE BEST YET BTW!

Cheers

[R31Nismoid]

The spreadsheet calcs broke i believe from the macro side, so nothing to do with the manual entry part as such

[lswal2]

Sorry to hear it that sucks for all.

The spreadsheet calcs broke i believe from the macro side, so nothing to do with the manual entry part as such

[llama_au]

^ also laptop batteries wouldn't last long enough, nowhere to plug them in where people are timing

[Sandeep]

I've fixed the macro but there's a few updates I need to do the results spreadsheet. It now needs to cater for more than 50 drivers (when I wrote the spreadsheet a few years ago we never had more than 50 drivers) and there's a number of rule changes which I need to write into the scoring macro as Ryan/Leon are having to do some manual changes now. My macro skills are pretty average so it takes me a while to figure it out, I'm an engineer not an IT person so I've just figured out how to write basic code myself.

Regarding data entry, I think it's still important to have the pen and paper for the records but you could also have 3 laptops with decent battery and MS Excel (about 3 hours for the morning session, charge during the break). I'd gladly bring my laptop up for DECA's but it's old and only lasts about 30minutes when I unplug it. Then it's just a case of copy/pasting to one master file, run the score macro and then do some quick sanity checks to make sure it's all correct.

[paulR32gtr]

Theoretically if reamed didn't attend DECA and black Galliano didn't exist ... Well ...

[ssxRicho]

I've fixed the macro but there's a few updates I need to do the results spreadsheet. It now needs to cater for more than 50 drivers (when I wrote the spreadsheet a few years ago we never had more than 50 drivers) and there's a number of rule changes which I need to write into the scoring macro as Ryan/Leon are having to do some manual changes now. My macro skills are pretty average so it takes me a while to figure it out, I'm an engineer not an IT person so I've just figured out how to write basic code myself.

Regarding data entry, I think it's still important to have the pen and paper for the records but you could also have 3 laptops with decent battery and MS Excel (about 3 hours for the morning session, charge during the break). I'd gladly bring my laptop up for DECA's but it's old and only lasts about 30minutes when I unplug it. Then it's just a case of copy/pasting to one master file, run the score macro and then do some quick sanity checks to make sure it's all correct.

Or cheapo Andriod tablets...

[AGE]

Or cheapo Andriod tablets...

Thats not a bad idea. Has SAUVIC got some $$$ in the Treasury/slush fund to maybe look towards Android acquisition?

[Belsil80]

RESULTS:

http://www.sau.ferni.net/DECA/128_Dec12/Rnd4Results.xlsm

Hope they work Cos i can't see them. Sorry for the delay guys

[Count Grantleyish]

Can't see them.

[llama_au]

Works for me.

[Odium]

Works fine, thanks Ryan Wooooootttt

16 / 52 Best position so far

For those that can't see...

https://dl.dropbox.c...20Round%204.png

[THENIG]

Shame car is listed as 32gtst @13th place, much more impressive as 1.4l Polo.

[Count Grantleyish]

Works fine, thanks Ryan Wooooootttt

16 / 52 Best position so far

For those that can't see...

https://dl.dropbox.c...20Round%204.png

Cheers Simon.

[Down_Shift]

Thanks for the results guys!