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

    • MBS206
      Mistakes were made, my R34 Story

      By MBS206 · Posted

      The real question is, on some of those wild roads they call highways, how many times did a farmer in an old ute from the early 2000s blaze past you over double lines?   Tassie is a wild and really cool place, and after doing a work related road trip there January of 24, I understand why Targa Tasmania is ran there, and is so tough to do well at! We had a brand new Camry Hybrid that handled quite nicely, and thankfully weren't in an old car, because cresting some of those hills in a 100kmh zone for it to suddenly be like "surprise f**kers, this is a recommended 30kmh hard right turn" wouldn't be pretty. We weren't racing the Camry around, but we weren't slouching in the bends either. But my lord those old farmers know their old clapped out utes, and those roads, as they were absolutely hammering it!   You're also super lucky to make it up to Mt Wellingtong this time of year. It's often road closed with snow/ice! Also, I hope you hit up Salamander Road in Hobart for some insanely good food (I highly recommend the dimly lit Irish pub for a Guiness Pie, or even the bangers and mash!!!)   How long did the Ferry take to get across? I want to do a road trip of Tas on my own time, but I get horrifically sea sick, and I don't want me on the Ferry, just the car 😛
    • Chi-Town
      C34 RSFour V Build in the US

      By Chi-Town · Posted

      So far so good, about 30km on it so far and nothing out of sorts yet thankfully
    • GTSBoy
      gtr hood match gt/gtt front fenders?

      By GTSBoy · Posted

      Look at @Kinkstaah's thread on the issue.
    • Murray_Calavera
      Battle of the broken skylines

      By Murray_Calavera · Posted

      Hmm not really, I'd say its race car life or modified car life when you make 3 or 4 times the power Nissan designed the car for lol. 
    • Duncan
      R32 gtr transmission strength, billet plate

      By Duncan · Posted

      I'll let others with more breakage chime in, but I can't think of anyone who had a problem with the standard centre plate before they had a problem with the standard gears - the plate generally just gets replaced for safety when the gearset is upgraded. As for the gearsets, its not like they are OK at 600Nm and break at 601. Their longevity is a combination of how much torque you are making and how gentle you are on shifts (or not). 
×
×
  • Create New...