X3TC Stats and Resources Compendium V3.3.1 (28/09/2011) - links live again
Moderator: Moderators for English X Forum
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.
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.
Re: X3TC Stats and Resouces Compendium V1.2.1 (22/01/2009)
FYI, I get a VBA error when I try to sort.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'.
Re: X3TC Stats and Resouces Compendium V1.2.1 (22/01/2009)
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).Crapgame wrote:FYI, I get a VBA error when I try to sort.
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.
- Carlo the Curious
- Posts: 16999
- Joined: Mon, 5. Mar 07, 22:03
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).
Last edited by Carlo the Curious on Thu, 22. Jan 09, 16:57, edited 1 time in total.
excel 2007 has a bigger format limit so will be ok.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).
Have you tried sorting the filter drop down way, i.e. click on the filter arrow and select sort ascending or descending?
- Carlo the Curious
- Posts: 16999
- Joined: Mon, 5. Mar 07, 22:03
- Carlo the Curious
- Posts: 16999
- Joined: Mon, 5. Mar 07, 22:03
- Shadow_180
- Posts: 91
- Joined: Wed, 11. Aug 04, 13:26
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.
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.
- BugMeister
- Posts: 13647
- Joined: Thu, 15. Jul 04, 04:41
-
- Posts: 5159
- Joined: Thu, 9. Oct 03, 20:44
- mad_axeman
- Posts: 2928
- Joined: Sat, 6. Mar 04, 16:44