Motor/sp/ort Spreadsheet

We're back: https://boards.4chan.org/sp/catalog#s=motor%2Fsp%2Fort
X Account: https://x.com/SpreadsheetAnon
MSExcel File: https://files.catbox.moe/y7rru2.xlsx
Image: https://files.catbox.moe/28f2d4.png
(Updated June 8, 2025)

>Saturday, June 14 (all times ET)
10:00 AM: WEC, Rd 4/8, '24 Hours of Le Mans', Circuit de la Sarthe, Le Mans, France
4:30 PM: NASCAR Xfinity, Rd 15/33, 'The Chilango 150', Autódromo Hermanos Rodríguez, Mexico City, Mexico
7:00 PM: ARCA, Rd 7/20, 'Berlin ARCA 200', Berlin Raceway, Marne, Michigan, USA

>Sunday, June 15
2:00 PM: Formula 1, Rd 10/24, 'Canadian Grand Prix', Circuit Gilles Villeneuve, Montréal, Quebec, Canada
3:00 PM: NASCAR Cup, Rd 16/36, 'Viva México 250', Autódromo Hermanos Rodríguez, Mexico City, Mexico
4:30 PM: Indy NXT, Rd 6/14, 'World Wide Technology Raceway', World Wide Technology Raceway, Madison, Illinois, USA
8:00 PM: IndyCar, Rd 8/17, 'Bommarito Automotive Group 500', World Wide Technology Raceway, Madison, Illinois, USA

A few notes on the MS Excel file:
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.
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).
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).
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.
5. Columns P and Q are used to help do the highlighting with conditional formatting, shouldn't need to touch these.
6. Column R is used to help build column S, you can ignore it.
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).
8. Row 1 is headers, so you can filter and sort.
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.
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.
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.


We will also keep this IRC channel around as well, in case of emergencies:
Server: irc.rizon.net
Channel: #motor/sp/ort
If you're new to IRC, you can use this web client: https://www.rizon.net/chat