Just A Minute

On Tuesday, 5 April 2016, Dean Bedford dbedford@... [just-a-minute] <just-a-minute@...> wrote:

 

I haven't looked in detail at this but anything that makes updating easier would be a huge help, Mark.

Sounds like it could be easier for the user too?

cheers, Dean

On Sunday, 3 April 2016 4:44 PM, "Mark sirnylon@... [just-a-minute]" <just-a-minute@...> wrote:

 

[Attachment(s) from Mark included below]

Hi Jamophiles

In my inexplicable (yet continuing) mission to convert JAM data to a nice, neat normalised form, please find attached a CSV list of all episodes (including JJAM and TV) and their subjects. 

I don't know why you would want this, but it was a bit of fun for me. I love a challenging bout of data-wrangling with a powerful text editor and complex spreadsheet formulae. 

It would make a jolly neat table in a fully-normalised JamBASE if anyone cared to build one. 

Actually, if Dean were willing, we could maybe build him a shiny online database he could control to save him time manually collating and updating all his webpages after every episode airs. 

I know the pain of manually maintaining a huge collection that requires increasing onerous changes to include all the knock-on effects of every small addition. When a collection is small, it is easy and fun to update; when it's the size of an elephant with nearly a thousand episodes two hundred players, 6664 unique subjects, and over 8000 rounds - it must be a major pain to keep up to date and maintain data integrity.

As usual, total thanks go to Dean for his online JAM data (http://just-a-minute.info/subjects.html) from which this was parsed and processed.

(I'd normally zip the attached text data, but I suspect Yahoo wouldn't let zipped data through.)

Regards

Mark

--

Audio instructions - http://b9fx.com/jamhelp.mp3

Mark