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

    • f**king around with the bro
    • Ludenham   44.2 tops day no issues  
    • Then today, I went to visit a man with an r33 hat Peter and Road and Race sorted the alignment. As it is being set up for general track/hillclimbs etc it has a heap of caster (7o), less camber than I am used to (1o front and 2o rear, as the caster looks after that in turns without the braking downsides), 3mm front toe out and 0 toe rear. Will see how that goes and track tyre wear to see if it does need more camber, but adjsustment is also limited with nismo arms and adjustable bushes at only 1 end. It does have a bent inner tie rod on the driver's side front but as it came up within spec I'll just leave that as is. So, that is getting close to my chapter of this story....could of tidy ups then a shakedown in early October before it finds a new home.
    • So, it went to Unigroup for a run in and tune on Friday, everything went (generally) well. In terms of fixes, the engine was good and there were no leaks. It needed plugs (I hadn't checked them because the coil pack cover was on a new engine and I couldn't imagine they weren't new.....but turns out the temporary plugs to just keep it sealed up were in there.....new plugs gapped to 0.8 and it was fine from there. Also, there was a little preload on the clutch slave which caused some slip. I haven't had the box off so I don't know what the clutch looks like; my guess it is brand new and the pedal had not been adjusted....backed that off a bit and it held fine. Last thing will have Dose crying....the idle especially when cold is a bit difficult between the cams, forward plenum, atmo blow off valve and an 80s air management system. It is fine when hot but a little uneven when cold, will see if I can sort or at least improve that one cold morning. Other than that, tuning went fine. It made 245 but was pulled back to 227 which 2 opportunities to improve in future. 1. The factory CAS is not great and was jumping around at high RPM, so Mark took 2 degrees out up top (that is why it stops making power and lost 20kw). Very safe this way and the extra power is available but will require a more modern ECU and better cam (or even better crank) sensor 2. The 2871 in factory housings is very big for a low mount, and the internal wastegate is too small, so it was creeping from mid range all the way to redline....the duty cycle on the boost controller is turned down a little for safety. That is much harder to fix, it would need a large external gate and that would require a whole bunch of other changes, so it will go as it is for now. It feels nice and healthy and safe, so should be good for about a billion laps like this.
    • what sort of caliper are they? If they are a slider and you gave everything a good clean, you might need to regrease the pins. My guess though is they will come good after some abuse as suggested above
×
×
  • Create New...