I didn't "nail it" with this project but I haven't made any improvements in several months so, even though it isn't jump-for-joy something I can be proud of, it's as done as it's likely to be, at least until the improvement bug hits me.
Column A is generated by the Edit->Fill->Series menu...