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

    • Which solenoid? Why was it changed? Again, why was this done? ...well, these wear..but ultimately, why was it changed? Did you reset the idle voltage level after fitment? I'm just a tad confused ~ the flash code doesn't allude to these items being faulty, so in my mind the only reason to change these things, would be some drive-ability issue....and if that's the case, what was the problem? Those questions aside, check if the dropping resistor is OK ...should be 11~14 ohms (TCU doesn't throw a flash code for this) ~ also, these TCU designs have full time power (to keep fault code RAM alive), and I think that'll throw a logic code (as opposed to the 10 hardware codes), if that power is missing (or the ram has gone bad in the TCU, which you can check..but that's another story here perhaps).
    • Question for people who "know stuff" I am looking at doing the new intake like the one in the picture (the pictured is designed for the OEM TB and intake plenum), this design has the filter behind the front bar, but, the filter sits where the OEM duct heads into the front bar, and the standard aperture when the OEM ducting is removed allows the filter to pulled back out of the front bar into the engine bay for servicing, a simple blanking plate is used to seal the aperture behind the filter This will require a 45° silicone hose from the TB, like the alloy pipe that is currently there, to another 45° silicone hose to get a straight run to the aperture in the front bar Question: how will it effect the tune if I move the MAF about 100-150mm forward, the red is around where my MAF is currently, and the green would be where it would end up Like this This is the hole the filter goes through  Ends up like this LOL..Cheers    
    • Despite the level up question, actually I do know what that is....it is a pressure sender wire.  So check out around the oil filter for an oil pressure sender, or maybe fuel pressure near the filter or on the engine. Possibly but less likely coolant pressure sensor because they tend to be combined temp/pressure senders if you have one. Could also be brake pressure (in a brake line somewhere pre ABS) but maybe I'm the only one that has that on a skyline.
    • Pull codes via the self-diagnosis procedure. As far as I can tell this is just a sign of transmission issues but not a code unto itself.
    • Hi All, putting the engine back together and everything is perfect except have this plug left over.. any ideas what it is for and where it goes? Is on cold side under the intake plenum *note not a stock plug, as everything has been modified Cheers
×
×
  • Create New...