Sep. 27th, 2019

scarfman: (Default)
Those of you who have been following me since this was an active LiveJournal may recall the entries here tagged math, in which I would discuss the formulae and the layout I use in the spreadsheet where I track the chronologies of my crossovers appearing at The Hero of Three Faces (and still, at the time, in occasional prose fanfiction). Sometimes I included screencaps of the grid of Excel cells in which I keep the formulas, a three by three grid or in the latter entries three by four, accompanied by descriptions of what the figure in each cell represented because, as I modestly informed you, the grid itself had no labels because I knew what it meant.
screenshot of spreadsheet from 2013
Well, the grid is now three by five cells most of which track multiple shows with nonoverlapping air chonologies thorough more than fifty years (not including some grid cell's satellite cells which they call on when their own formulas for all the shows they track have got too complex to nest in one *.xls cell formula) (yes I still use *.xls for this, *.xlsm won't save it with all the macros intact, I think it's because they have numerals in their names but I haven't tested that) and I've finally broken down and created a mirror grid just below the working instance of the first grid which shows labels.
screenshot of spreadsheet from 2019
This'll keep me from looking at, say, a figure in station fourteen (where The X-Files is in this screenshot; Doctor Who's station is station zero) and trying to work out from the date in station three whether that season number means Leverage or Sleepy Hollow. Which has happened. While I was making the mirror grid.

March 2025

S M T W T F S
      1
2345678
9101112131415
16171819202122
23242526272829
3031     

Most Popular Tags

Page Summary

Style Credit

Expand Cut Tags

No cut tags
Page generated Jun. 23rd, 2025 03:53 am
Powered by Dreamwidth Studios