Toruk's fleet info sheet

Thisnthat · May 21, 2018, 12:33pm

Fixed the link

Virgo · May 21, 2018, 9:15pm

I’ve updated my ship fleet on the OTG SC Fleet.xlsx file with respect to the ship entries listed.

The spreadsheet does not include the new concept ships (Vulcan, Hercules - C2/M2/A2) entries. Are forum members permitted to add these new entries or is it restricted to admin?

JonC · May 22, 2018, 12:58am

Can you add StellarRaptor, err, me to the spreadsheet and I’ll add what I have?

Simdor · May 22, 2018, 12:35pm

I believe you should be able to edit it yourself.
Toruk will know…

Toruk · May 30, 2018, 6:45pm

No, if you can edit it please do. If not please let me know.

Toruk

Toruk · May 30, 2018, 6:46pm

All you have to do is click on the link and edit it. If not please let me know.

Toruk

JonC · May 31, 2018, 12:48am

@Toruk I was able to add. Thankee.

Verdier · June 15, 2018, 10:17pm

Updated my fleet. How did you want to mark having more than one ship?

KuruptU4Fun · June 16, 2018, 3:21am

Updated, going to get back my Cutlass soon.

Toruk · June 27, 2018, 1:04pm

I saw a player denote the number of owned ships in parenthesis. That was a good idea so I think we’ll make that the convention and denote the number of ship os the type indicated as Y(x) where x is the number of ships of that type. IE: Y(2) if I owned 2 Freelancers.

Simdor · June 27, 2018, 2:03pm

could we just add a quantity column?

Toruk · July 3, 2018, 5:28pm

There would then have to be a column for EACH person making it harder to find your ship.

Simdor · July 4, 2018, 4:17am

No i mean instead of putting a Y just put the number of ships you have which in most cases would mean instead of the Y we would see a 1.
That would make it WAY easier to get ship totals as well.

Simdor · July 4, 2018, 4:36am

OK I updated the sheet a bit.
Instead of putting a Y for each ship you put the number of ships of that type that you own

Added in some total column/row info as well and updated the existing formulas to use the new info.

EDIT: Oh and a bit of conditional formatting to easily see what the most popular ships are as well as who the big whales are.
Not that we didn’t already have a good idea, but this gives nice at a glance info.

Neph · July 19, 2018, 11:52pm

Added RSI Apollo Triage $225 (Warbond)

macallen · July 20, 2018, 5:18pm

The variant is $250 warbond, I have that one.

Simdor · July 20, 2018, 6:39pm

The variant has heavier armor and twice the missiles.
I like.

macallen · July 20, 2018, 6:44pm

LOL, didn’t notice, bought it because it was prettier.

macallen · July 21, 2018, 3:47pm

Can you add the Apollo Medivac $250 to the sheet?

Neph · July 21, 2018, 7:01pm

Done. But, like the Triage, just on the first page, not on the $ spent page.