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

    • Ok i will get those 310mm. I found one but on a different site. This is the description on those...is it ok? Technical parameters: - Axle: front. - Disc type: ventilated. - Number of holes: 5. - Disc diameter: 310mm. - Total height with center: 54mm. - Thickness (new/min.): 30/28mm. - Designed for brake calipers manufacturer: Sumitomo.
    • You Gregged a whole racetrack!?
    • Look for broken wire or bad connector at the motor. Might not be it, but is worth starting there, as it is easy.
    • Hi everyone, I’m having an issue with my R32 GT-R. Sometimes, when the car goes over a bump or experiences some vibration, the 4WD warning light comes on the dashboard. When I check the code from the control unit in the trunk, it shows Code 19 – ETS Motor. However, everything seems to be working fine — if I turn off the engine and restart the car, the light goes away and everything functions normally. Has anyone experienced this before? Where should I start troubleshooting this issue? Thanks in advance!
    • I'm back from the dyno - again! I went looking for someone who knew LS's and had a roller dyno, to see how it shaped up compared to everything else and confirm the powerband really is peaking where Mr Mamo says it should. TLDR: The dyno result I got this time definitely had the shape of how it feels on the road and finally 'makes sense'. Also we had a bit more time to play with timing on the dyno, it turns out the common practice in LS is to lower the timing around peak torque and restore it to max after. So given a car was on the dyno and mostly dialled in already, it was time for tweaking. Luis at APS is definitely knowledgable when it came to this and had overlays ready to go and was happy to share. If you map out your cylinder airmass you start seeing graphs that look a LOT like the engine's torque curve. The good thing also is if you map out your timing curve when you're avoiding knock... this curve very much looks like the inverse of the airmass curve. The result? Well it's another 10.7kw/14hp kw from where I drove it in at. Pretty much everywhere, too. As to how much this car actually makes in Hub Dyno numbers, American Dyno numbers, or Mainline dyno numbers, I say I don't know and it's gone up ~25kw since I started tinkering lol. It IS interesting how the shorter ratio gears I have aren't scaled right on this dyno - 6840RPM is 199KMH, not 175KMH. I have also seen other printouts here with cars with less mods at much higher "kmh" for their RPM due Commodores having 3.45's or longer (!) rear diff ratios maxing out 4th gear which is the 1:1 gear on the T56. Does this matter? No, not really. The real answer is go to the strip and see what it traps, but: I guess I should have gone last Sunday...
×
×
  • Create New...