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

    • Shoota_77
      Shoota's R33 GT-R RB30/26

      By Shoota_77 · Posted

      Ended up spending a WHOLE day yesterday cleaning and rearranging my shed.  Due to the aforementioned disorder, my shed is as cluttered and confused as my brain. Again, because of said disorder,  at any one time there are 5 projects on the go at once and because they're still on the go I don't put everything away so I can "get straight back to it" which rarely happens.. So anyway,  I bought a couple of cheap 2mx2m all steel "pallet racks" to put in my back shed.  The idea is to then take pretty much everything out of the main shed that isn't car related. Most of the garden and building stuff is now booted out to the back shed and onto to the shelves where they belong! There's still more rearranging and reallocating to do and it's still a bit busy in there but it's a massive improvement on how it was previously. I've discovered floor space I forgot I had...  For those that have fully dismantled a car before will understand just how much space it takes up!  Particularly panels, bumpers, engine/trans, etc.  I've got stuff hanging on every available wall to get it up off the floor!  This is not exciting content for a blog but has certainly made the shed feel like a more work ready space now!
    • hypergear
      Hypergear Turbochargers and High flow Services Development thread

      By hypergear · Posted

      Updating results from our ATR43SS-1 turbo in T3 .63, OEM bolt dump pattern. Not a big number but pretty sweet for a stock Rb20det. Car's managed to pull 220rwkws at 20psi, perfect boost control internally gated with EBC and excellent mid top end power band as they usually skydive after 5.5K. Usual bolt on supporting mods and inlet plenum and factory location exhaust manifold. Pump 98 fuel was used (Ron 93).     
    • GTSBoy
      Neil's R33 Gts-t Build

      By GTSBoy · Posted

      Yeah, well, it's not as though anyone is ever going to buy one of those noisy f**kers and put it into a new installation when there are better pumps that are near silent for less money from Ti.
    • Duncan
      Rebuilt Rb25det issues

      By Duncan · Posted

      I'd suggest having the engine builder listen to it, especially if they assembled it, and minimise how much you run it in the meantime. It may have a serious issue like a big end bearing from the description and I assume the rebuild was not cheap
    • Duncan
      Neil's R33 Gts-t Build

      By Duncan · Posted

      Quite right, typing without checking, it is an 023 which was effectively the replacement for 040 (not that I could find either of them on the Bosch motorsport AU site), and it has a mesh inlet at the bottom of the pump rather than a separate filter
×
×
  • Create New...