Shadow Fleet Data

[Constance Lafayette]

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.

~~~~~
Rayek edit:

I copied Constance's database and have been editing that one to keep myself up to date with characters.

You are welcome to take a look but as Constance says.. Please don't edit. If something is incorrect please note it in the comments down below or message me directly.

Character database Google Docs Link

[Kirok]

Nice!

[Chris Newberry]

I'm going to sticky this topic.

[Malcolm Adeyemi]

I'm going to reply to this topic.

[James A. Hawke]

I am going to Like this topic....awww crap I can't there is no like button

[James H. Hawk]

I am going to Like this topic....awww crap I can't there is no like button

I went to like that post before realising that there was no like button
I'm glad to see Shadowfleet Data is still around. Might I make a suggestion that you add academy instructor to the other part?

[Constance Lafayette]

I went to like that post before realising that there was no like button

I'm glad to see Shadowfleet Data is still around. Might I make a suggestion that you add academy instructor to the other part?

lol I do that too a lot. We need a like button I think.

Possibly.
I'll look into it.

[Dylan Torngate]

Just a question, how up to date is this list?

[Malcolm Adeyemi]

Just a question, how up to date is this list?

This is updated as of 1-3-17. You can review the last changes made in the Google doc. I just glanced it over and it seems fairly accurate.

[Kirok]

This is updated as of 1-3-17. You can review the last changes made in the Google doc. I just glanced it over and it seems fairly accurate.

I think Constance manages the list.  She may be the only one who can edit it.

[Kinley Garrison]

I think that the list needs to be updated again.

[Constance Lafayette]

I think that the list needs to be updated again.

I update my data every 1-3 weeks. Anything more would be a large burden (it takes about... 30 min to an hour to update everything). It's a personal project of mine.
I am actually waiting for the next ship to launch to update it because any data I update will be null and void as soon as it launches lol

[Kinley Garrison]

I update my data every 1-3 weeks. Anything more would be a large burden (it takes about... 30 min to an hour to update everything). It's a personal project of mine.
I am actually waiting for the next ship to launch to update it because any data I update will be null and void as soon as it launches lol

Sounds great! 

[Constance Lafayette]

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!

[Dylan Torngate]

Kirok likes smaller ship crews but he has the most APCs.

The Athena has as many Lt(JG)'s as the Disco has Lieutenants.

Awesome job as always!