Shadow Fleet Data

James H. Hawk · February 02, 2017, 09:25:12 PM

Nice work!

I will however, point out that the Tempest recently had a round of promotions and got a new player, Jada in the Sec/Tac Department.

Sevoc · February 02, 2017, 11:58:26 PM

Quote from: Constance Lafayette on February 02, 2017, 09:08:13 PM
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:
Code Select Expand
=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!

It seems I have spotted an error in the data. I am a Lt, j.g. now

Constance Lafayette · February 03, 2017, 01:07:36 AM

All data was based on what was presented on the roster page of each ship. I can make spot updates but would prefer to do big updates (so I'm not updating all the time). Once the roster pages have been updated please let me know and I'll make all changes necessary :-)

Sevoc · February 03, 2017, 01:14:00 AM

That is agreeable

Malcolm Adeyemi · February 03, 2017, 01:14:28 AM

Quote from: Sevoc on February 03, 2017, 01:14:00 AM
That is agreeable

Channeling your character there I see...

D'Vid · February 03, 2017, 04:57:53 AM

Quote from: Constance Lafayette on November 29, 2016, 07:15:45 PM
Since I was reminded today that not everyone knows this exists: ~Link~

I created and maintain a database of all characters listed on all ships, based on roster information and update it every few weeks.

It's open to edit but PLEASE do not edit it (and dear god don't sort it). I only leave it as open so you can click those little arrows next to each column to be able to filter data.

That is awesome. It is good to see that so crew people can see the general stuff about other crew members. LOL