motorsportexcel

Motor/sp/ort Spreadsheet

Sep 8th, 2024 (edited)
6,997
0
Never
6
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.94 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/6ctt8j.zip
  4. Image: https://files.catbox.moe/unvigk.png
  5. (Updated November 10, 2026)
  6.  
  7.  
  8. >Saturday, November 14
  9. 7:15 AM: Asian LMS, Rd 1/6, '4 Hours of Le Castellet #1', Circuit Paul Ricard, Le Castellet, France (Season Start)
  10. 10:30 PM: Super Taikyu, Rd 7/7, 'S-Tai FINAL Grand Thanksgiving Festival', Fuji Speedway, Oyama, Japan (Season Final)
  11.  
  12. >Sunday, November 15
  13. 7:15 AM: Asian LMS, Rd 2/6, '4 Hours of Le Castellet #2', Circuit Paul Ricard, Le Castellet, France
  14.  
  15. >Friday, November 20
  16. 8:10 PM: Macau GP, 'Macau Motorcycle Grand Prix - 58th Edition- Race', Guia Circuit (Macau Street Circuit), Macao, China
  17. 10:25 PM: Macau GP, 'Macau Roadsport Challenge - Race', Guia Circuit (Macau Street Circuit), Macao, China
  18. 11:40 PM: Macau GP, 'Macau Formula 4 Race - FIA F4 World Cup- Qualification Race', Guia Circuit (Macau Street Circuit), Macao, China
  19.  
  20. >Saturday, November 21
  21. 12:25 AM: Super Formula, Rd 11/12, 'Suzuka International Racing Course #1', Suzuka International Racing Course, Suzuka, Japan
  22. 1:20 AM: Macau GP, 'Macau Guia Race - Kumho FIA TCR World Tour Event of Macau - Race 1', Guia Circuit (Macau Street Circuit), Macao, China
  23. 2:35 AM: Macau GP, 'Macau GT Cup - FIA GT World Cup - Qualification Race', Guia Circuit (Macau Street Circuit), Macao, China
  24. 4:15 AM: Macau GP, 'Macau Grand Prix - FIA FR World Cup - Qualifying Race', Guia Circuit (Macau Street Circuit), Macao, China
  25. 10:00 AM: MotoGP, Rd 21-S/22, 'Portuguese Grand Prix (Sprint)', Algarve International Circuit, Portimão, Portugal
  26. 7:00 PM: Macau GP, 'Greater Bay Area GT Cup', Guia Circuit (Macau Street Circuit), Macao, China
  27. 8:15 PM: Macau GP, 'Macau Formula 4 Race - FIA F4 World Cup - Main Race', Guia Circuit (Macau Street Circuit), Macao, China
  28. 10:00 PM: Macau GP, 'Macau Guia Race -Kumho FIA TCR World Tour Event of Macau - Race 2', Guia Circuit (Macau Street Circuit), Macao, China
  29. 11:00 PM: Formula 1, Rd 21/24, 'Las Vegas Grand Prix', Las Vegas Street Circuit, Las Vegas, Nevada, USA
  30. 11:35 PM: Macau GP, 'Macau GT Cup - FIA GT World Cup', Guia Circuit (Macau Street Circuit), Macao, China
  31. 11:50 PM: Super Formula, Rd 12/12, 'Suzuka International Racing Course #2', Suzuka International Racing Course, Suzuka, Japan (Season Final)
  32.  
  33. >Sunday, November 22
  34. 2:30 AM: Macau GP, 'Macau Grand Prix - FIA FR World Cup', Guia Circuit (Macau Street Circuit), Macao, China
  35. 8:00 AM: MotoGP, Rd 21/22, 'Portuguese Grand Prix', Algarve International Circuit, Portimão, Portugal
  36.  
  37.  
  38. A few notes on the MS Excel file:
  39. 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.
  40. 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).
  41. 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).
  42. 4. The rounds info in columns L-N should be obvious, 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.
  43. 5. Columns P and Q are used to help do the highlighting with conditional formatting, shouldn't need to touch these.
  44. 6. Column R is used to help build column S, you can ignore it.
  45. 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).
  46. 8. Row 1 is headers, so you can filter and sort.
  47. 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.
  48. 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.
  49. 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.
  50.  
  51.  
  52. We will also keep this IRC channel around as well, in case of emergencies:
  53. Server: irc.rizon.net
  54. Channel: #motor/sp/ort
  55. 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
    1 year
    # 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.
    • # 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.
    • # 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
        1 year
        # 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
          1 year
          # 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