Portal 
Forum
Calendar
Roster
Search
Help 
Officers
Forum Statistics
09-07-2015, 08:54 AM
So let me give a little instruction to all. Hope this helps!!!!
First and foremost: You must have Microsoft Office 2007 or greater (or) you can get the free Open Office as mentioned above.
The excel file already has an "Autofilter" turned on. All this really means is that you can click on the HEADING column [v] (drop down arrow) and uncheck/deselect values in the list.
Why? Well, here is a scenario:
You are an "escort" style player. You know that there isn't a snowballs chance in *$#^ that you would fly a ship with a turn rate less than say... "19". Well, give yourself a little wiggle room, and let it keep all values above "15".
Also, definitely select "Faction" and unselect everything except for "Federation" & "Cross-Faction" (as if you aren't klingon or romulan, you wont be looking at their ships will you?).
Now you can choose some more filters.... I recommended you keep turn speed a little less that the 19 you "know" you wont do without because lets face it... All ships are not created equal. As mentioned above, Cryptic has done a lot of balancing which means you are going to have to have a little give and take.
As a note, (example), you might **really** need(want) 5 tactical console slots instead of 2 or 4 etc, but perhaps the only ships with 5 tactical console slots are a max turn speed of 17. Would you as an escort player give up the -2 turn rate for an extra console? Yes, yes, yes, you would. (Especially since you can get consoles with turn enhancements).
If you happen to be a cruiser player, you might choose to start your filtering by unselecting hull plating sizes less than 30,000, or crew sizes less than ~700. ANY heading can be filtered and/or sorted.
By doing the above for the things that are most important to you, you will (by process of elimination), be left with a small (tough) choice of ships to choose from, and, you can see exactly what is different between them!
One more note of advice to consider... some ships have U4 (universal Commander BOFF slots) which might be a big benefit for you if you like to change-up your play style from time to time. Also, the sheet gives you the "total" number of skill positions for your BOFFS as well as the BOFF maximum values being sorted (displayed) left to right so you can easily see what skills the ship favors, and what skill concentration it favors too.
Good luck! Hope this helps x2.
Ver'
First and foremost: You must have Microsoft Office 2007 or greater (or) you can get the free Open Office as mentioned above.
The excel file already has an "Autofilter" turned on. All this really means is that you can click on the HEADING column [v] (drop down arrow) and uncheck/deselect values in the list.
Why? Well, here is a scenario:
You are an "escort" style player. You know that there isn't a snowballs chance in *$#^ that you would fly a ship with a turn rate less than say... "19". Well, give yourself a little wiggle room, and let it keep all values above "15".
Also, definitely select "Faction" and unselect everything except for "Federation" & "Cross-Faction" (as if you aren't klingon or romulan, you wont be looking at their ships will you?).
Now you can choose some more filters.... I recommended you keep turn speed a little less that the 19 you "know" you wont do without because lets face it... All ships are not created equal. As mentioned above, Cryptic has done a lot of balancing which means you are going to have to have a little give and take.
As a note, (example), you might **really** need(want) 5 tactical console slots instead of 2 or 4 etc, but perhaps the only ships with 5 tactical console slots are a max turn speed of 17. Would you as an escort player give up the -2 turn rate for an extra console? Yes, yes, yes, you would. (Especially since you can get consoles with turn enhancements).
If you happen to be a cruiser player, you might choose to start your filtering by unselecting hull plating sizes less than 30,000, or crew sizes less than ~700. ANY heading can be filtered and/or sorted.
By doing the above for the things that are most important to you, you will (by process of elimination), be left with a small (tough) choice of ships to choose from, and, you can see exactly what is different between them!
One more note of advice to consider... some ships have U4 (universal Commander BOFF slots) which might be a big benefit for you if you like to change-up your play style from time to time. Also, the sheet gives you the "total" number of skill positions for your BOFFS as well as the BOFF maximum values being sorted (displayed) left to right so you can easily see what skills the ship favors, and what skill concentration it favors too.
Good luck! Hope this helps x2.
Ver'
