X3TC Stats and Resources Compendium V3.3.1 (28/09/2011) - links live again
Moderator: Moderators for English X Forum
- 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
-
- Posts: 4708
- Joined: Tue, 20. Apr 04, 17:39
With patch 2.1 getting near I guess (and sincerely hope) you'll update again the spreadsheet, so I'm reporting a few mistakes (mostly typos) found in the derelict ships section:
1) Hilas Joy should be Hila's Joy (missing apostrophe)
2) Duke/s Citidel should be Duke's Citadel
3) Oracoke’s Storm should be Ocracoke’s Storm
4) Thr’s Deprivation should be Tkr’s Deprivation
5) Unknown Sector by Unholy Decent should be Unknown Sector by Unholy Descent
6) The Z coordinate of the Buzzard Hauler in Tkr’s Deprivation is wrong: it says it's 2.0 but it actually is 62.5 (source)
As you see I'm just nitpicking, the only correction that is really needed is the wrong coordinate.
BTW thanks for the spreadsheet, it'b been really useful
1) Hilas Joy should be Hila's Joy (missing apostrophe)
2) Duke/s Citidel should be Duke's Citadel
3) Oracoke’s Storm should be Ocracoke’s Storm
4) Thr’s Deprivation should be Tkr’s Deprivation
5) Unknown Sector by Unholy Decent should be Unknown Sector by Unholy Descent
6) The Z coordinate of the Buzzard Hauler in Tkr’s Deprivation is wrong: it says it's 2.0 but it actually is 62.5 (source)
As you see I'm just nitpicking, the only correction that is really needed is the wrong coordinate.
BTW thanks for the spreadsheet, it'b been really useful
"For the love of the Fish-Queen!"