Shadowfleet Data! (Big, Beautiful, Data!)

[Constance Lafayette]

So way back when I made and maintained a spreadsheet of every roster on Shadowfleet. It took me about a lot of labor and love to pull all the data from the site (and I'm sure I didn't get everything) but take a gander at this sortable, filterable, color-coded beauty!

~LINK~

I allowed editing on the document but please do not edit something even if it is your profile (I can see and revert changes). I left it open to editing so you guys can sort/filter the data as you need (for example, you can click the arrow under "Rank" to see all people who are a Lt. for example).

I seem to be missing data for:
Craig McGrory
Roselyn Gramrosa
Chris Mc Intyre
Jamie Shen
Elhiu M'Konel
Persephone M'Rai

All from the Phoenix or Star Base (good job Disco! All profiles are in and linked!). Couldn't find an account or post matching those names. If anyone could link me to their profile on the site, I'd be happy to update it.

Also, Kachina Filitov and Derek Black appears on both SB and Phoenix lists. They are both listed on Phoenix for the time being. Please let me know if you want me to change this.

Anyway, enjoy my labor of love! 

[Lennox Ainsley]

This is reallly cool !

[Chris Newberry]

Nice work Constance.

One thing, I'm not a hybrid.... (needs to update bio) and a few of my characters are missing. I think I added myself on your old sheet because I was missing....

[Constance Lafayette]

Nice work Constance.

One thing, I'm not a hybrid.... (needs to update bio) and a few of my characters are missing. I think I added myself on your old sheet because I was missing....

I only had your old profile to work with. If you can shoot over a copy of your new profile I'll amend it.

[Archangel Koris]

Thank you for doing this! I did an SF demographic project a while back, so I know how much work goes in to it!

I've just put an app up for Persephone, so you ahould be able to pull sone missing info on her from it.

The five from the Phoenix haven't transferred over as far as I'm aware, hence why they don't have bios.

[Gabriel Arthur]

Cool list!  Thank you for putting the effort in to doing something like this.

[Constance Lafayette]

Thanks guys! This site is a labor worth loving :-)

I would like to add an alt. column for transparency.

Edit: Updated Persephone.

[Constance Lafayette]

Updated the sheet to reflect the recent roster shift: ~Link~

Edit: Got guidance on unassigned characters.

[Kyle Briggs]

This looks great. Thanks for all the hard work.

[Constance Lafayette]

Updated 6/22/15

I keep having to make conditional formatting styles because we keep adding races

[Laassul]

I apologize in advance if I've created the need for additional conditional formatting (;

[Constance Lafayette]

It's all good. I don't mind. In fact- let's look at some more data from this chart. This time- species, gender, and departmental distributions!

Species
Andorians: 1
Modified Humans: 1
Mugato: 1
Breen: 1
Selay: 1
Vulcans: 1
El-Aurians: 1
Ferengi: 1
Bajorans: 2
Caitians: 2
Klingons: 2
Cardassians: 3
Trills: 3
Hybrids: 10
Humans: 26

Humans: 26
Hybrids: 10
Non-Human, Non-Hybrid: 20
So there are almost twice as many (1.8x) humans and hybrids than full-blown aliens in the fleet!
Also, can you believe we only have 1 full vulcan in the fleet on the roster? Crewman Toreen Paattr, your choice of species was very logical.

Male/Female Ratio
34/22
That's 1.54 guys for every lady!

Departmental Distribution
Flight: 7
Medical: 7
Command: 8
Engineering: 8
Science: 8
Ops: 9
Sec/Tac: 10
Pretty well balanced!

[Kirok]

Updated 6/22/15

I keep having to make conditional formatting styles because we keep adding races

Constance,

Thanks for sharing this!

Kirok

[Constance Lafayette]

So I've recently added alt. character data to the chart! It's pretty kick'en so check it out!

Total # of Alts: 19
Observations: We've got like 64 members on the rosters at the moment (or at least that's what I'm tracking). So we are about 1/3rd alts. That's not too bad.

Department Breakdown (Alts)
Science: 5
Medical: 5
Engineering: 3
Sec/Tac: 2
Flight: 2
Ops: 1
Other: 1
Observations: Weird. Most of our medical and science officers are alts and almost all of our flight and ops people are primes. On the site overall, we have a pretty even distribution.

Male/Female Ratio (Alts)
8/11
Observations: Hmmm. So the m/f ratio is 72% here and and 154% for the site at large. Sounds like the ladies have it here ;-)
*I am counting the 1 Thaan as a male for m/f ratio

Alts Per Ship
Athena: 4
Discovery: 7
Phoenix: 6
SB Columbus: 2
Observations: The Disco is an alt party. Get funky with yo' bad self.

Racial Breakdown (Alts)
Humans: 6
Hybrids: 2
Non-Human, Non-Hybrid: 11

So on the site overall we have WAY more (1. times as many humans and hybrids vs aliens.

For alts though it's flipped around. HALF our resident full-blooded aliens are alts! I guess people get bored of just playing a hu-mon and decide to take a walk on the wild side with their alts :-D

That's all for now!