motorsportexcel

Motor/sp/ort Spreadsheet

Sep 8th, 2024 (edited)
5,487
0
Never
6
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.17 KB | None | 0 0
  1. We're back: https://boards.4chan.org/sp/catalog#s=motor%2Fsp%2Fort
  2. X Account: https://x.com/SpreadsheetAnon
  3. MSExcel File: https://files.catbox.moe/fxjjb7.zip
  4. Image: https://files.catbox.moe/jzbkcp.png
  5. (Updated April 15, 2026)
  6.  
  7. >Friday, April 17 (all times ET)
  8. 12:35 AM: Supercars, Rd 10/37, 'Christchurch Super440 #1', Euromarque Motorsport Park, Christchurch, New Zealand
  9. 8:45 PM: Supercars, Rd 11/37, 'Christchurch Super440 #2', Euromarque Motorsport Park, Christchurch, New Zealand
  10.  
  11. >Saturday, April 18
  12. 12:10 AM: Supercars, Rd 12/37, 'Christchurch Super440 #3', Euromarque Motorsport Park, Christchurch, New Zealand
  13. 5:30 AM: 24H Series, Rd E2-1/5, 'Michelin 12H Spa-Francorchamps #1', Circuit de Spa-Francorchamps, Stavelot, Belgium
  14. 9:00 AM: EWC, Rd 1/4, '24 Heures Motos', Bugatti Circuit, Le Mans, France (Season Start)
  15. 12:30 PM: ARCA, Rd 3/20, 'Tide 150', Kansas Speedway, Kansas City, Kansas, USA
  16. 3:00 PM: AMA Supercross, Rd 14/17, 'Cleveland', Huntington Bank Field, Cleveland, Ohio, USA
  17. 4:00 PM: IMSA, Rd 3/11, 'Acura Grand Prix of Long Beach', Long Beach Street Circuit, Long Beach, California, USA
  18. 7:00 PM: NASCAR O'Reilly, Rd 10/33, 'Kansas Lottery 300', Kansas Speedway, Kansas City, Kansas, USA
  19. 11:00 PM: Super Taikyu, Rd 2/7, 'Suzuka International Racing Course (5H)', Suzuka International Racing Course, Suzuka, Japan
  20. 11:05 PM: Supercars, Rd 13/37, 'Christchurch Super440 #4', Euromarque Motorsport Park, Christchurch, New Zealand
  21.  
  22. >Sunday, April 19
  23. 4:30 AM: 24H Series, Rd E2-2/5, 'Michelin 12H Spa-Francorchamps #2', Circuit de Spa-Francorchamps, Stavelot, Belgium
  24. 7:00 AM: WEC, Rd 1/8, '6 Hours of Imola', Imola Circuit, Imola, Italy (Season Start)
  25. 2:00 PM: NASCAR Cup, Rd 9/36, 'AdventHealth 400', Kansas Speedway, Kansas City, Kansas, USA
  26. 5:30 PM: IndyCar, Rd 5/18, 'Acura Grand Prix of Long Beach', Long Beach Street Circuit, Long Beach, California, USA
  27.  
  28. >Thursday, April 23
  29. WRC, Rd 5/14, 'Rally Islas Canarias', Las Palmas, Spain
  30.  
  31. >Saturday, April 25
  32. 9:00 AM: MotoGP, Rd 4-S/22, 'Spanish Grand Prix (Sprint)', Circuito de Jerez – Ángel Nieto, Jerez de la Frontera, Spain
  33. 12:30 PM: ARCA, Rd 4/20, 'Alabama Manufactured Housing 200', Talladega Superspeedway, Lincoln, Alabama, USA
  34. 4:00 PM: NASCAR O'Reilly, Rd 11/33, 'Ag-Pro 300', Talladega Superspeedway, Lincoln, Alabama, USA
  35. 7:00 PM: AMA Supercross, Rd 15/17, 'Philadelphia', Lincoln Financial Field, Philadelphia, Pennsylvania, USA
  36.  
  37. >Sunday, April 26
  38. 1:30 AM: Super Formula, Rd 3/12, 'Autopolis', Autopolis, Hita, Japan
  39. 8:00 AM: MotoGP, Rd 4/22, 'Spanish Grand Prix', Circuito de Jerez – Ángel Nieto, Jerez de la Frontera, Spain
  40. 1:30 PM: GTWC America, Rd 2/7, 'Circuit of the Americas', Circuit of the Americas, Austin, Texas, USA
  41. 3:00 PM: NASCAR Cup, Rd 10/36, 'Jack Link's 500', Talladega Superspeedway, Lincoln, Alabama, USA
  42.  
  43.  
  44. A few notes on the MS Excel file:
  45. 1. Columns A-H are what I screenshot, with A, C, D, and E being auto-generated based on the data in I and K-N.
  46. 2. Column I stores the date and time in Pacific time zone (where I live). Column I is formatted to display the date only, and J the time. J will be a "?" if the time in I is "12:00 AM" (which is the default value in Excel if you input only a date). The date and time are split into separate columns to help see which events only have a date and still need time-of-day info. If the time of the vent actually is 12:00 am (midnight) Pacific, enter the time as "12:00:01" (the 1 second will be hidden).
  47. 3. The "tags" in column K affect bolding/underlining. They'll also add notes to the text lists in column S (P=Postponed, C=Cancelled, D=Delayed, R=Rescheduled).
  48. 4. The rounds info in columns L-N should be oubvious, though M "Subround" is optional. This gets appended in column C (and the column S text output). I use S for sprint races and sometimes numbers when one event has multiple races.
  49. 5. Columns P and Q are used to help do the highlighting with conditional formatting, shouldn't need to touch these.
  50. 6. Column R is used to help build column S, you can ignore it.
  51. 7. Column S is what generates the lists. Just copy paste the rows for the current week. Unfortunately, Excel surrounds the multi-line rows with quotes, so you'll have to remove those (I paste into notepad and do a find/replace-all).
  52. 8. Row 1 is headers, so you can filter and sort.
  53. 9. Cell S1 is used to shift the current highlighting forward/backward one or more weeks. T1 is used to shift by days (setting T1 to 7 is the same as setting S1 to 1). I use that on Sundays when prepping the list for the next weekend, to make the next week green.
  54. 10. When making a screenshot, I filter the date for "After" some day in the current week (usually Mon or Tue), then select cells A1 though H and enough rows to cover 5 weeks, or whatever. Then Ctrl+C copy, paste into MS Paint (easier than taking a screenshot), and save.
  55. 11. When adding new events, I usually just copy paste an existing row to ensure formulas and formatting transfer correctly, then clear out the editable details. It's a pain, but whatever.
  56.  
  57.  
  58. We will also keep this IRC channel around as well, in case of emergencies:
  59. Server: irc.rizon.net
  60. Channel: #motor/sp/ort
  61. If you're new to IRC, you can use this web client: https://www.rizon.net/chat
Comments
  • # text 0.05 KB | 0 0
    1. Hey spreadsheet anon don’t go disappearing on us.
  • NAPAanon
    363 days
    # text 0.36 KB | 0 0
    1. Thank you for your service, spreadsheet anon. You are a pillar of the community. What are we going to do if this doesn't get fixed? I don't care to migrate, but where to and how do we bring as many people along as possible? The paste bins are the only way I know get in touch with anyone at all and I am not sure many people will think to look here. This really sucks.
    • motorsportexcel
      362 days
      # text 0.54 KB | 0 0
      1. Sure, I'll keep this page, the spreadsheet, the png, and the weekly text schedule updated at least until the end of this year... As for how to notify anyone else... idk. I don't know where everyone else went, if they went anywhere at all. Maybe some subreddit or something? If you have any ideas and run into anyone, point them to this pastebin, the URL won't change. Like I mentioned above: I set up an IRC channel on Rizon.net if anyone wants to chat during any races. Use the KiwiIRC link and you can easily join the chat channel from your web browser.
    • motorsportexcel
      361 days
      # text 0.16 KB | 0 0
      1. Also, it seems like some of /sp/ has moved to https://www.soyjak.st/fit/ (since the site doesn't have a /sp/ board) so maybe motor/sp/ort can live there temporarily...
      • NAPAanon
        361 days
        # text 0.69 KB | 0 0
        1. Thank you so much, man. I didn't see anything on the soyjack page, but their filter doesn't work on Brave, Chrome or Edge so WTFE. I couldn't get that browser based IRC client to work either so I dusted off mIRC for the first time in over a decade. I am in the "Xfinity @ Rockingham Speedway on CW Network (4 PM ET) - Vroom!" channel, but I am alone for the moment at least. I am watching Imola and IDK if we will need more channels, but let me know in that chat if there are any.
        2. This suck bigly and I really hope we can get get back to normal soon. In any case we need to organize a backup plan. We have a lot of really smart and capable guys, so it shouldn't be that hard if we just take the time to do it.
        • Pontiacnon
          360 days
          # text 0.24 KB | 0 0
          1. Just letting anon's know a bit of us are on 8chan. https://8chan.se/sports/res/14.html If .se is slow then try .moe. i believe that spot is busier then that soyjack place that none of us want anything to do with. Would be like Dale driving a yoder.
Add Comment
Please, Sign In to add comment