Jump to content
SAU Community

Import Monster Dec Deca Wrap Up

R31Nismoid

By R31Nismoid,
in Victoria

 Share

Recommended Posts

  • Replies 109
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

lswal2 Rookie

lswal2

Posted
Posted

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

Sandeep Community Regular

Sandeep

Posted
Posted

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.

ssxRicho Grand Master

ssxRicho

Posted
Posted

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...

Count Grantleyish Grand Master

Count Grantleyish

Posted
Posted

Works fine, thanks Ryan :D Wooooootttt

16 / 52 Best position so far :)

For those that can't see...

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

Cheers Simon.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing


  • Similar Content

  • Latest Posts

    • jez NF
      The Evolution Of "night Fury"

      By jez NF · Posted

      Mixing things up - installed some leather recaros to match the leather seat covered rear seats. Interior looks pretty schmick now except for some slight wear on the steering wheel which I will monitor and address if it becomes worse or actually noticeable!  
    • Predator1
      Tomei gasket

      By Predator1 · Posted

      Didnt realise RB's had more then 1 head.
    • MBS206
      Unpeeling the Orange

      By MBS206 · Posted

      I'm normally copping my own abuse from neglecting my daily drivers. "Those suspension bushes will last a bit more", "Don't worry about the oil leak, just keep topping it up". The project cars I'm always doing things slowly on them as I'm wanting them to be done better, and neater, and nicer. Luckily I don't have to deal with 18 year old Matt's "Learning to wire" stuff in the project cars. And there's only one piece of wiring I'm displeased about in the Landcruiser, and it's about to be cut out... However, the box loads of parts that have been going through this place lately for the Landcruiser... Brake pads Brake Rotors Full handbrake overhaul Wheel Bearings Seals Swivel hubs Steering Boxes Half the suspension joints Shocks Air bags (Ones to go in the rear springs for towing) Water pump Timing kit Lower timing case Harmonic Balancer Radiator Lots of other little seals and shits Gas struts for the bonnet New power window switches And god knows what else I've forgotten... Ha ha ha I have my fingers crossed the pinion seals don't start leaking on the diffs, that the transfer case doesn't leak, and the gearbox input shaft doesn't leak, nor the rear main seal. As they're about the only seals I haven't replaced in the driveline! I'm seriously eyeing off buying new caliper rebuild kits front and rear brake calipers... I'll probably recheck all the valve clearances soon too, and hopefully, it should be all good and sweet to haul some long distance trips again!
    • GTSBoy
      Unpeeling the Orange

      By GTSBoy · Posted

      Every time I pull my 3x gauges out of the console and see the crack-addict way that I did the wiring, and I just can't bring myself to tear it all apart and "make it nice", because it is currently working. In fact, the last time I was in there I probably made it worse.
    • Kinkstaah
      Unpeeling the Orange

      By Kinkstaah · Posted

      The best part is when you own the car long enough that you look back and find your OWN ham fisted amateur shit!
×
×
  • Create New...