Jump to content
SAU Community

Recommended Posts

  • Replies 109
  • Created
  • Last Reply

Top Posters In This Topic

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

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.

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

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



  • Similar Content

  • Latest Posts

    • From my youth: GTi-R clutch change is a massive pain. The gearboxes are fragile? But the car is super cool and I want one 😢 
    • Remember this is 1988 tech.
    • Driveline vibration is resolved. I ended up loosening all my engine mount and trans mount bolts, giving it a good shake then retightening everything and it's gone... Let's just say I was surprised that fixed it.  I've been happily driving it around again but unfortunately put zero time into my direct port/constant pressure WMI setup. I'm on vacation next week, so I'll try and finalize it then.  On a different note, I spent all week fuel/ignition mapping 2x 216L V16 engines. Turbo's were burning glycol and we swapped them out for larger units. We also had planned emissions testing on site, so I figured I'd be there the same week to use their instrumentation and massage any emissions issues out if needed. This was a first for me. Fuel management is similar in certain ways to automotive (i.e air density as load variable) but very different in others. It's all PLC based and AFR's are controlled by air and not fuel. They use a control valve between the turbo and air manifold to control pressure which in turn controls AFR's. Due to this, target AFR tables supplied by the OEM are in pressures and not mass which really through me off. They use air pressure vs fuel pressure tables. I also relied on an O2 concentration sensor the emissions team had in the exhaust. Ignition timing was also all over the place and we were losing a fair bit of power. They're now happily sitting at 16-40BTDC depending on load. We were making about 1600kw at 900rpm at 90% load. Engines were running a lot smoother as well.    
    • heh, aint no R32 ever meeting modern targa cage rules unless the driver is veeeery short OP, good luck with the sale, since its already in the land of freedom I'm sure you will find a good buyer.
    • meh, it was a good video, clear about the issue and how he dealt with it. A bit heavy on the RTV and very brave to put an RB in anything without rebuilding it first, but otherwise I thought it was good Dose, I'm not sure that having the pickup forward is a big issue; yes of course the oil could shift under brakes but the sump should never be empty enough for that to be a problem (unless you also have a higher volume oil pump, and that oil can't return from the head to the sump quickly enough)
×
×
  • Create New...