Open ◆ SNAIL [Spec] Racing - Presented by ButtKicker: Feel What You've Been Missing

Discussion in 'SNAIL Racing League' started by zer05ive, Dec 13, 2011.

  1. Dragonwhisky

    Dragonwhisky Premium

    Messages:
    5,829
    Location:
    United States
    I have resorted to entering the best laps and gaps in an excel file for each race, then copy/paste the column of numbers in to approriate locations, as a range, in the google sheet. It doesn't usually flake out on the best lap numbers but it freaks out every time on the gaps. The difference here is, instead of it reloading 60+ times, it only does it 6. nmcp's solution of holding the total time value out until after the gaps are entered would probably produce the very same results.

    Sometimes I even get in 2-3 ranges before the page explodes and has to reload. Sometimes the data I entered is retained, sometimes not.
     
  2. nmcp1

    nmcp1

    Messages:
    2,565
    Location:
    United States
    Same here Dragon... Not sure if the forum allows attachments of excel files but here's goes...
     

    Attached Files:

    Dragonwhisky likes this.
  3. fizzer

    fizzer

    Messages:
    357
    Location:
    United States
    Thanks guys, your comments gave me some ideas. One thing I noticed is that some columns aside from the finish position had conditional formatting on for gold silver bronze (including gap, total time, and best lap). I turned that off for those columns and it seems to have reduced the occurance of the error a bit (could be coincidence though).

    Another idea is to delete the formula for total time for the drivers in the race, enter gaps, then refill the formula (similar to importing from another sheet, but I'm trying to avoid that). Not entering total time first didn't seem to be helping me.

    This dang cloud nonsense is just a fad anyway ;)

    ETA: just had another thought. It seems the power rankings haven't been updated in a while. Is there any way there's a wayward power rankings sheet out there somehow referencing the current results sheet and maybe complicating the recalc process? Long shot, but I figured I'd throw it out there.
     
  4. qwietstorm

    qwietstorm

    Messages:
    731
    Location:
    United States
    There's just something in me that can't do that. If I accidentally take some one out, or if they go off/hit the wall and I think I had even the tiniest amount to do with it, it's my natural reaction to stop and wait.
     
  5. Dragonwhisky

    Dragonwhisky Premium

    Messages:
    5,829
    Location:
    United States
    Since the wizard who set all these brooms to sweeping has retired, bitrot has set in. If someone has the experience and time to work out what all those brooms are doing and either keep them working or set up another brigade of brooms, please step up.
     
    Inconspicuous likes this.
  6. fizzer

    fizzer

    Messages:
    357
    Location:
    United States
    Yeah I agree, I like to wait and expect others to do the same if there's a blatant punt.

    However (and this is why I can understand LLOYD's view) - PSA: If you do make an error that you feel needs to be rectified on track PLEASE be aware of all the other cars around you and only slow down if behind you is clear and do it off the racing line. Sometimes this means you may have to continue 2 or 3 turns at race pace before pulling to the side and letting the victim pass.

    I don't recall who specifically I saw, but there has been a couple times in the past weeks and in practice where someone has tried to give a spot back immediately after the incident and it really messed up the pack of cars not involved.
     
    Kgffy likes this.
  7. fizzer

    fizzer

    Messages:
    357
    Location:
    United States
    I'd be happy to after nat finals. Lets talk on Sunday if possible. I need to know who still has the most knowledge and details on the admin rights. If I make Silverstone I wouldn't be able to do ongoing maintenance, but I should be able to right the ship at least.
     
  8. MajorBlixem

    MajorBlixem

    Messages:
    2,289
    Location:
    Canada
    @KTR5 Great Pics of Great Racing!
    Not many divisions can boast of no incidents in any of the 6 races on Lap 1 Turn 1....
     
    ExoSphere64 and KTR5 like this.
  9. Dragonwhisky

    Dragonwhisky Premium

    Messages:
    5,829
    Location:
    United States
    PM me the details of when you can be available and shoot me a PSN FR. We'll make something happen.
     
  10. Handlebar

    Handlebar Premium

    Messages:
    3,968
    Location:
    United States
    I said I was coming back on July 8th. We get home about midnight.
     
    hognhominy and KTR5 like this.
  11. Dragonwhisky

    Dragonwhisky Premium

    Messages:
    5,829
    Location:
    United States
    Welcome back to the internet, and SNAIL, Handlebar!
     
    Michelin and TEX36 like this.
  12. LLOYDZELITE69

    LLOYDZELITE69 Premium

    Messages:
    1,009
    Location:
    Canada
    I'll always wait for someone if I caused something, and needs to be rectified. I'll give the position back.
    I just don't want people to do the for me, it slows me and us down while battling all over again. Just keep going and I'll do my thing. :) it's just my view but if you still want to slow down for me, go right ahead :)
     
  13. USERID_77a23

    USERID_77a23

    Messages:
    1,694
    Location:
    Canada
    I like second from the bottom , looks like driver is checking his mirror
     
    ExoSphere64 and KTR5 like this.
  14. aerolite

    aerolite

    Messages:
    3,004
    Location:
    Canada
    @Dragonwhisky, I input gaps and pole times a couple of hours ago for D6 with no issues. However, I don't see those inputs when I open up the standard results sheet?
     
  15. Silent James

    Silent James

    Messages:
    8
    Location:
    United States
    Hey thanks, I got the quiz done and also the time trial submitted. Just waiting on being assigned to a division. This looks like a lot of fun!
     
  16. Dragonwhisky

    Dragonwhisky Premium

    Messages:
    5,829
    Location:
    United States
    Did you enter the timing data in the results doc or the director's doc?
     
    KTR5 likes this.
  17. aerolite

    aerolite

    Messages:
    3,004
    Location:
    Canada
    In the "SNAIL Directors' Points Tally and Eliminations Votes-New" document.
     
  18. nmcp1

    nmcp1

    Messages:
    2,565
    Location:
    United States
    uh oh.... you're in trouble now.... unleash the Dragon! :D
     
    KTR5 likes this.
  19. CoachMK21

    CoachMK21

    Messages:
    2,857
    Location:
    United States
    After @Dragonwhisky moves the data into the results doc, all data should be enter in the results doc. It's not the end of the world at this point. As long as it's only the best lap times or the gaps, you can copy and paste them in. Don't copy and paste into a document that directly has a formula in it.
     
    Jakedog23 likes this.
  20. aerolite

    aerolite

    Messages:
    3,004
    Location:
    Canada
    uh oh.....uh oh....but that's the one I was given access too :nervous:
     
  21. Dragonwhisky

    Dragonwhisky Premium

    Messages:
    5,829
    Location:
    United States
    That would be why it's not in the main results document, since I copied the sheets from the director's doc to the results doc yesterday evening.

    Once again, excepting for the total time value, timing data should not be entered in the director's doc. It should be entered in the results doc after the scoring has been transfered from the director's doc.

    I know, sometimes it's easier for some to go ahead and enter this data right after racing Sunday night, but it really causes the brooms to freak out when moving the score sheets up to the results doc. Have any of you ever had to weather a broomstorm? It ain't fun and it ain't pretty. Old fat men raging at google docs for being a steaming pile of monkey dung is just plain ugly.

    If you will also be the data entry specialist for your division, we will get you access to the results doc.
     
  22. aerolite

    aerolite

    Messages:
    3,004
    Location:
    Canada
    Ok, I got it....:banghead:.......I was given access to directors file for the immediate scorekeeping back in D8. I saw that the results sheet was view only so I assumed I updated the former. Our data and data BU guys were not there Sunday. I was asked to put in the gaps, I knew we weren't supposed to put anything else right away in directors doc but I thought it was ok after. What do I know:dopey:
    Sorry if I caused any headaches, just trying to help!
    I'd rather not be the data guy as I'm already main replay loader and second BU host.
     
  23. Wolfsatz

    Wolfsatz

    Messages:
    3,933
    Location:
    United States
    I'll pick the Lancia Status one of these days when I win D3... rigghhht!

    How about Happy Pistons?.. is that out of the rule book?

    is this an Exo sandwich?

    [​IMG]
     
  24. hognhominy

    hognhominy

    Messages:
    632
    Location:
    United States
    Hmmm the preliminary idea for RBR/Impreza seems interesting, off to test.
     
  25. singlepaddy

    singlepaddy

    Messages:
    820
    Location:
    Canada
    Hey guys... I bought the GTR for the new combo and after I painted the wheels ( which came out a different color then I selected ) my ps3 froze.
    After I rebooted and tried to take it for a test drive it froze again. I ended up doing this 3 times with the same result.
    Finally got fed up and sold the car. Btw the system would not let me change the wheel color either.
    I tried out some of my other cars after I sold the GTR and everything seems fine now.
    Problem is I don't want to buy another $950,000 car and end up with the same result. I may have to skip that combo this week.

    Anyone got any thoughts on this out there?
     
  26. MajorBlixem

    MajorBlixem

    Messages:
    2,289
    Location:
    Canada
    I may be in trouble too:nervous: ..... First time data collection for me.... I added data to said director's document....

    I will check tonight when I get home and if necessary copy them over to the right spot
     
  27. JLBowler

    JLBowler Premium

    Messages:
    6,718
    Location:
    United States
    Read the post (links included) that you quoted. The "time trial" link will be especially helpful toward answering your question about where to submit it.

    As far as your limited schedule, check out this link.
     
    ERAUfan97 likes this.
  28. CoachMK21

    CoachMK21

    Messages:
    2,857
    Location:
    United States
    @MajorBlixem I noticed you did that and copied the best laps to the results doc shortly after you did it, last night.

    I believe it's not a big deal to put data in the directors doc AFTER @Dragonwhisky has moved the data. I think he just eliminates that when he creates then new sheets for the upcoming week.
     
    MajorBlixem likes this.
  29. MajorBlixem

    MajorBlixem

    Messages:
    2,289
    Location:
    Canada
    @KTR5 much appreciated... I will know for next week!
     
  30. aliengamer25

    aliengamer25

    Messages:
    625
    Location:
    United States
    If we had community feature and able to send credits id give you some
     
    Nail-27 and KTR5 like this.