User blog comment:Belle pullman/Broadway Cast Formatting/@comment-39097528-20190924125021/@comment-3182821-20190924153240

To be honest, this is why I've sat on the info from that book and not incorporated it before, I can't work out how to make it work accurately enough! This is what I mean about whatever format we use needs to be sufficiently flexible, to be altered and corrected if necessary.

Separate tables would be unnecessarily cluttered. We definitely need to have those certain cast lists as fixed points, but for example, there's a column for "May" with a "started in April" not in it, which just seems contradictory. I think we need a framework based on the info in the book, that we can then easily update with more specific info. I don't think that there are MAJOR discrepancies as you're suggesting with the Cassandra example - after all there's updates for every month through the year, so working on the reasonable supposition that the data is pulled from cast lists, rather than individual actor's movements, it's fair to assume that if they detail one character did change in May, other characters did not change in May.

In the grand scheme of things, we're not being paid for this, we're researching what we can without official input, we can't make it perfect. So we need to make it as usable as possible, and as easy to correct flaws as possible, but striving for perfection is hopeless!