Re: **2024 Pool** Race 22, United States GP

On 11/5/2024 4:16 AM, Mark wrote:

On Mon, 4 Nov 2024 13:20:28 -0000 (UTC), Mark <mpconmy@gmail.com>
wrote:

>
I used to update it a few times during the season - fully automated and
taken straight from the F1 web page - but they've made the data _so_
horrible (and change it even mid-season) it's become semi-manual and
long-winded.

The "Classification" page at
http://www.forix.com/gp.php?l=0&r=20240021&c=2
is a lot cleaner, if you have access.  (The table of results is easy to find and copy out.)

It is one of the reasons I'm a bit slower with results the last couple
of years. For a decade, that was fully automated. A Python script would
parse the F1 website, compile the full set of results and inject them
into the SQL table. Another script would then build the results post.

I still have occasion to write scripts to do things like take text output from an Excel file and turn it into an HTML table - the former being a lot easier than the latter for adding and removing entries without screwing up the layout.
They're in Python, of course.  It wasn't the NBA star of the same name who coined the marketing slogan that used to be used on Python.org:
https://groups.google.com/g/comp.lang.python/c/yVEsK9m74SE/m/3L0yPGHjxgsJ
--
Mark Jackson - https://mark-jackson.online/
   If you can't write comedy about Caltech,
   you can't write comedy.  - J. Kent Clark