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

    • This is how I last did this when I had a master cylinder fail and introduce air. Bleed before first stage, go oh shit through first stage, bleed at end of first stage, go oh shit through second stage, bleed at end of second stage, go oh shit through third stage, bleed at end of third stage, go oh shit through fourth stage, bleed at lunch, go oh shit through fifth stage, bleed at end of fifth stage, go oh shit through sixth stage....you get the idea. It did come good in the end. My Topdon scan tool can bleed the HY51 and V37, but it doesn't have a consult connector and I don't have an R34 to check that on. I think finding a tool in an Australian workshop other than Nissan that can bleed an R34 will be like rocking horse poo. No way will a generic ODB tool do it.
    • Hmm. Perhaps not the same engineers. The OE Nissan engineers did not forsee a future with spacers pushing the tie rod force application further away from the steering arm and creating that torque. The failures are happening since the advent of those things, and some 30 years after they designed the uprights. So latent casting deficiencies, 30+ yrs of wear and tear, + unexpected usage could quite easily = unforeseen failure. Meanwhile, the engineers who are designing the billet CNC or fabricated uprights are also designing, for the same parts makers, the correction tie rod ends. And they are designing and building these with motorsport (or, at the very least, the meth addled antics of drifters) in mind. So I would hope (in fact, I would expect) that their design work included the offset of that steering force. Doesn't mean that it is not totally valid to ask the question of them, before committing $$.
    • The downside of this is when you try to track the car, as soon as you hit ABS you get introduced to a unbled system. I want to avoid this. I do not want to bleed/flush/jack up the car twice just to bleed the f**kin car.
    • But again, the engineers said your cast aluminium would be fine based on the load that would be stretching that section. Same load stretching the bolts in a flex (not the twist), with a much smaller cross sectional area than the original part you've broken. It's why you'd need to be using higher strength bolts, but that's just making up for the strength you lose with less area...
    • I am truly amazed someone on this planet was able to cycle the pump using a scan tool. I've always ghetto cycled them on Nissan 90s shit boxes by slamming the brakes and pulling the handbrake to agitate the rear wheels enough to cause a speed difference
×
×
  • Create New...