Hey guys. So I updated the data post-Shran launch. It looks pretty solid.
~Link~Funny Correlations(All meant in a goofy-
"look how this data turned out lol" sort of way)
SF loves it some human Captains! The of the 5 commanding officers, 4 of them are human! (Kirok is the odd duck out). That's matched by the XOs with Tekin Nevir (a Bajoran) as our only non human XO!
Also- sexist much? All the XOs are male! However, ladies rule the skies and kill it on science, being the majority of characters in both flight and science departments.
Rumor has it that the Starbase is now part of the academy because it has 3 of the 4 cadets (none of whom are hybrids or humans btw). However it also holds the highest ranked member on the site (Chris Newberry is a Fleet Admiral).
The Discovery has, by far, the most Lieutenants.
ALSO (edit)
Ok ok ok ok.
So I'm WAY too excited for this aspect but I took some time and now I have everything expressed as a "count" that will update in real time as I edit data. For context as to how much of a cluster#$% it is to make it do this, the formula looks like:
=query(index(if({1,1},upper(B2:B61)&"")),"select Col1,count(Col2) where Col1<>'' group by Col1 order by count(Col2) desc",0)
Anyway, all that aside, the data now populates in real time which allows me to generate ratios in real time AND CHARTS!
Guys!
We have charts!