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

    • Even more fun, leave all the ADAS stuff plugged in, but in different locations, hopefully avoid any codes!   And honestly, all these new cars with their weird electronics. Pull all the electronics out Duncan, and just shove an aftermarket ECU and if needed a trans controller in, along with a PDM. Make it run basic but race car styled!
    • To follow up a question from earlier too since I had the front bar off again (fking!) This is what is between the bumper and the drivers side wheel And this is the navigator side, only one thing but its a biggy! So basically....no putting coolers in the wheel arches without a lot of moving other stuff. Assuming I move to properly race prepping this car I'll take that job on and see how the computers respond to removing a whole bunch of ADAS modules
    • So I prepped the car for another track day on Wednesday (will be interesting to see coolant temps post flushing out and the larger reservoir, with a forecast of 3-14 being 20o cooler than last time I took it out). Couple of things to mention; since I am just driving the car and not taking a support vehicle, I took the rear seats out and just loaded the back up Team Trackday style. Look at all that space! To cover off removing the rear seat....it is weird (note the hybrid is probably different because it wouldn't have folding rear seats) Basically, you remove the lower seat base, very similar to a r series but it is a clip that pulls forward to release the base rather than it being bolted down. Easy Then, you need to remove the side section of the rear seat on each side. There is a 14mm head nut at the bottom of the side piece, the it slides upwards off a hook at the top to release; you also need to unhook the seatbelt from the loop at the top. Then the centre piece is weird. You need to release/fold the seats forward with the tab in the boot on each side From there, there are 2,x12mm headed bolts holding the rear of each seat to the folding bracket, under the trim between the rear seat and the boot (4x christmas tree clips there, they suck). The seat is out but you can see where the bolts attach to the bracket
    • As discussed in the previous post, the bushes in the 110 needed replacing. I took this opportunity to replace the castor bushes, the front lower control arm, lower the car and get the alignment dialled in with new tyres. I took it down to Alignment Motorsports on the GC to get this work done and also get more out of the Shockworks as I felt like I wasn't getting the full use out of them.  To cut a very long story short, it ended up being the case the passenger side castor arm wouldn't accept the brand new bush as the sleeve had worn badly enough to the point you could push the new bush in by hand and completely through. Trying a pair of TRD bushes didn't fix the issue either (I had originally gone with Hardrace bushes). We needed to urgently source another castor arm, and thankfully this was sourced and the guys at the shop worked on my car until 7pm on a Saturday to get everything done. The car rides a lot nicer now with the suspension dialled in properly. Lowered the car a little as well to suit the lower profile front tyres, and just bring the car down generally. Eternally thankful for the guys down at the shop to get the car sorted, we both pulled big favours from our contacts to get it done on the Saturday.  Also plugged in the new Stedi foglights into the S15, and even from a quick test in the garage I'm keen to see how they look out on the road. I had some concerns about the length of the LED body and whether it'd fit in the foglight housing but it's fine.  I've got a small window coming up next month where I'll likely get a little paint work done on the 110 to remove the rear wing, add a boot wing and roof wing, get the side skirt fixed up and colour match the little panel on the tail lights so that I can install some badges that I've kept in storage. I'm also tempted to put in a new pair of headlights on the 110.  Until then, here's some more pictures from Easter this year. 
    • I would put a fuel pressure gauge between the filter and the fuel rail, see if it's maintaining good fuel pressure at idle going up to the point when it stalls. Do you see any strange behavior in commanded fuel leading up to the point when it stalls? You might have to start going through the service manual and doing a long list of sensor tests if it's not the fuel system for whatever reason.
×
×
  • Create New...