ABCDEF
1
Star Trek Online Duty Officer Finder
2
by @daBelgrave
3
4
The latest available version (V2.0.2) comes from:
5
http://bit.ly/STODoffs
6
7
8
Introduction
9
When I first started doing the special Tau Dewa Aid assignments available on the Suliban Cell Ship, I had a hard time finding Duty Officers with the optimal traits. This spreadsheet started out as my attempt to alleviate that difficulty. By filtering a list of all the Duty Officers available in the game, I can determine if a needed Duty Officer even exists, and learn specific names to search on the Exchange if necessary. I hope you also find this spreadsheet useful in your doffing.
10
11
You can find a simple non-spreadsheet version at:
12
http://thephoenixdivision.com/doffs.html
13
14
Search through the Active Duty Effects at:
15
http://thephoenixdivision.com/doffs2.html
16
17
To submit Duty Officers for eventual inclusion, use this Google form:
18
http://goo.gl/forms/3oOQfUc0YI
19
20
How to Use
21
1.The first thing you need to do if you want to use this spreadsheet is to make your own copy of it. To do this, select File -> Make a copy. This requires you to have a free Google Drive account. Keep in mind, your copy will not be updated when I make updates to this spreadsheet, but it can tell if you have the latest version and provides the link to get it.
22
2.Go to the 'Search' tab, and select the criteria you want your duty officers to have. Do this slowly or you might crash the spreadsheet.
23
3.The 'Search' tab contains a number of notes explaining how the filter works. I recommend you read those.
24
4.I might come back later and write a real #4.
25
5.Because this list originally came from STOWiki, there might be duplicates, mistakes, or missing information. I'm trying to update the list as I have time, but it's very long.
26
6.This list will only help you find Duty Officers based on certain criteria. It will not make you good at PvP, heat your coffee, or clean up pet urine. Use it for what it's made to do, and have fun!
27
28
Change Log
29
V2.1* IN PROGRESS *
30
Everything should be updated through Season 12.
31
- There will be a 'Where to Find' sheet added before this version is finished.
32
33
34
35
V2.0.2- Corrected filter to properly search for Active Duty Effects.
36
- I am still adding new Duty Officers and Active Duty Effects as I have time to go through the exchange.
37
38
V2.0.1Removed Common, Uncommon, and Rare Duty Officers. This greatly reduces the size of the spreadsheet from over 50,000 to closer to 15,000, plus pretty much everyone just wants the Very Rare Duty Officers.
39
The old version with the Common, Uncommon, and Rare Duty Officers is still available, but probably won't be updated:
40
https://docs.google.com/spreadsheets/d/1xOKxWx2Udxb6yCy2sO_E4uc5htA76vXro845hhDfliI/edit?usp=sharing
41
42
V2.0Big changes to make it even better!
43
- Greatly optimized the primary search formula. It seems to work much faster now, without the crashes!
44
- Added Species to the filter.
45
- Added R&D Specialties to the filter.
46
- EXPERIMENTAL - Added Active Duty Effects to the filter. Most Duty Officers listed still need this info added.
47
- Added list of Active Duty effects. Because they vary based on Duty Officer quality, be sure to check ingame for the actual strength of the effect.
48
- The existence of a filter criterion does not mean the information has already been added.
49
- Many of the newer Duty Officers still need added, which will be an ongoing project without version updates. Please contact me if you wish to contribute.
50
51
V1.0.1Added Intro sheet to provide instructions how to make your own useable copy of this.
52
53
V1.0Initial Duty Officer Finder spreadsheet.
54
- Contains a complete list (as far as I can tell) of every Duty Officer listed on STOWiki as of early April, 2014.
55
- Allows filtering the list to find the Duty Officers that meet desired criteria.
56