egosoft.com

Nova raider removed in error, now back in.
Argon Advanced Eclipse is an abandoned ship and the stats sheets/sites are unclear about this ship, some confusion with the Pirate Advanced Eclipse. For now the stats for this ship are the same as the pirate one, I'll check it when the tools are available or when I go and find that ship.
There shouldn't be any more removed I don't think.

Cool, thanks for the quick update, I am the first one again, and seems I am the only one have 1.2 on hand~~ (except you)

hehe.. and Numo who's helped with some data recently

ianrobo75 wrote:- Reformatted to reduce the number of different cell format combinations to try and reduce the potential for the VBA error 1004, 'Too many different cell formats'.

FYI, I get a VBA error when I try to sort.

Crapgame wrote:FYI, I get a VBA error when I try to sort.

Interesting, this is why I had to reformat. Excel has a number of formats limit of 4000, the document has been reduced to 3300 and works for me. I'm afraid I can't do anything more about this. I assume you get the 'Too many formats...' error. I also assume you have macros enabled (required for the sort buttons to work because they run VBA code).

You could try sorting via the filter drop down buttons, the sort options are at the top of those option lists. Another option is to delete the tabs you don't need/want, save, close excel, and restart. This will reduce the number of formats, eliminating the error.
As an aside, I'm am led to believe that you need to use this filter sort options if looking at the document in Excel 2007.

Also, remember NOT to save the document after this error otherwise the data/formats are messed up.

I get the VBA error (run-time 1004, in Sub CommandButton Selection.Sort) on Excel 2000 (XP), but it's okay in 2003 (XP) and 2007 (Vista).

Carlo the Curious wrote:I get the VBA error (run-time 1004, in Sub CommandButton Selection.Sort) on Excel 2000 (XP), but it's okay in 2007 (Vista).

excel 2007 has a bigger format limit so will be ok.

Have you tried sorting the filter drop down way, i.e. click on the filter arrow and select sort ascending or descending?

You don't get a sort option from auto-filter in 2000 (at least, not the version I have - but it is old and unpatched).

2003 also works okay, btw.

excel 2000 must have a lower number of formats limit then.

Cell styles? It's 4000, apparently, same as 2003 (2007 is 64000). Curious...

Been using this since V1. Kudos for adding the other turret data, must've taken ages!

An idea to improve the results of filtering ships by equipable weapons -
Place dots in the entire column for a ship's weapon, even if it can only equip that weapon in one slot, then hide the dot (format it to white maybe?).

The result is that when using the weapon filters, all of a ship's turret data is kept together instead of rows disappearing.

Example; take the M3 sheet - if you wanted to find ships that can equip Ion Disruptors and used the filter, it would look like the Eclipse, Notus and standard Blastclaw have no turrets. A hidden dot would result in their turret data still being shown.
Alternatively if a ship can only equip a desired weapon in a turret and you used the filter the row with all its statistics would disappear.

I modified an older version of your sheet to do this and the results are pretty good, you should try it out and see what you think.

ye, that's what I do for the main stats, show the same text in the background colour. I take your point for the guns, similarly for the missiles. I see a version 1.3 coming...

Carlo the Curious wrote:I get the VBA error (run-time 1004, in Sub CommandButton Selection.Sort) on Excel 2000 (XP)

Yep, that's my problem. Office 2000

Oh well, no sort for me!

Added the revised filtering, thanks Shadow_180. A fair chance of a few errors here, please message me if you find any filter or data errors.

- great to have all that info in one place - excellent!

Is anyone using this in Openoffice? If so, I may go back to that since my Excel 2000 isn't what it used to be.

Crapgame wrote:Is anyone using this in Openoffice? If so, I may go back to that since my Excel 2000 isn't what it used to be.

The data is there in OpenOffice but the sorting doesn't work and the tab colours are missing.

The M7M turret info is still missing in version 1.3 (they were in pre-1.2 versions).

NeverSnake wrote:The M7M turret info is still missing in version 1.3 (they were in pre-1.2 versions).

Looking back at all versions they have all shown blank turret infos but I'll check the info out when I get chance.

I've just tried opening this in Excel 2007 and I get no tabs at the bottom of the file. I'm stuck looking at what I assume is either the first or the last page.

Edit: Scrub that. Just re-opened it and they're there. Odd.