Jump to content
SAU Community

Import Monster Dec Deca Wrap Up

R31Nismoid

By R31Nismoid,
in Victoria

 Share

Recommended Posts

  • Replies 109
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

lswal2 Rookie

lswal2

Posted
Posted

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

Sandeep Community Regular

Sandeep

Posted
Posted

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.

ssxRicho Grand Master

ssxRicho

Posted
Posted

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...

Count Grantleyish Grand Master

Count Grantleyish

Posted
Posted

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
 Share
Go to topic listing


  • Similar Content

  • Latest Posts

    • WMDC35
      Tomei gasket

      By WMDC35 · Posted

      Are you sure the gasket is blown? What are the issues? Thermocure is the only flush I've seen do anything with rust, very impressed with that, Prestone, rust will be by the pool having a cigarette.  
    • MBS206
      Tomei gasket

      By MBS206 · Posted

      And since the flush you have a blown head gasket? Have you lifted the head off yet?
    • GTSBoy
      Hr34 fuel pump not turning on

      By GTSBoy · Posted

      The answer is to get a hold of the wiring diagram, work out what voltage is supposed to be where, when, and then work out why it is not there, then. I can't speak to the HR34 stuff, because I have never paid any attention to the NAs. There is a possibility that the turbo diagram will help, but it could also be different - depending on whether there is an FPCM on the NAs.
    • Trinicandian
      Hr34 fuel pump not turning on

      By Trinicandian · Posted

      Hey guys. New here. I am having an issue with my hr34. The fuel pump isn't turning on. I removed it from the tank. Bench test it. Wasn't working. Order new one and installed it today. Still not turning on. Checked the relay. Relay has voltage on the contact side. I jumped it and it tuned the pump on. Which lead me to checked the coil voltage.  Turned on the ignition and had my meter across the coil and there wasn't any dc voltage. Had my meter lead on the positive and I used the frame ground and noticed there was 12 volts. Which lead me to believe the relay isn't getting a negative signal. I traced the wire ( black with pink strip).it goes back to the bottom on the steering and it gets lost into the harness.   I checked at the ecm and I can't seem to find that wire color.   My question if any one knows is. Can I not just run the negative through a ignition relay to turn on the fuel pump relay?. Or anyone ever had this issue and if so how did u go about fixing it.    
    • MBS206
      Dose's Sometimes DIY and Pay Someone Home & Boat Improvement Thread

      By MBS206 · Posted

      So many people don't notice it, as batteries decay slowly over time. Two big reasons people end up noticing and needing to replace batteries: 1) The cold weather. The cold not only makes it harder to turn the engine for a few reasons, but it also increases the batteries internal resistance. So this means you need MORE power to turn a colder engine, AND the battery has a lower limit on how much current it can provide. 2) Something gets modified/altered/added in the wiring, typically an aftermarket accessory, like a dash camera, or an alarm etc, and this adds a small amount extra onto the battery, and pushes it over the edge in its failing days. But if you hadn't have read this thread, and just pushed through, chances are you might have made it through this winter, just. But come next winter, it would have been kapoot. But the fact you changed it out now, means you've instantly noticed how much nicer it is for starting, and will be less worry for you that the engine won't start now.
×
×
  • Create New...