ABCDE
1
DOffTrekker 3.12
2
http://bit.ly/DOFFS
3
http://bit.ly/DOFFTREKKER3
4
brought to you by
@Z3R0B4NG

with a little too much help from:
@azkar / @Deltabrainwave / @LucasPurcell / @xeoffres
5
6
READ ME... or ELSE
7
Hi, take a look around first, but then come back and read this.
(if you are new to googledocs, look at the bottom, there are multiple Tabs to choose from)

*for SETUP instructions scroll down to the big green box
*if you want to know what is new in the latest version, scroll all the way down to the latest Patchnotes
8
What the hell am i looking at?
9
The DOffTrekker is a personalized Progress and Tracking Sheet for Star Trek Onlines Duty Officer System.
It loads the information from the bit.ly/DOFFS "Viewscreens"/"Editor Sheet" and filters the Mission Info so you only see what you need to see for your Characters.
It lets you start a Timer when you start a mission and it tells you when the duration and cooldowns are over so you can take the next Step
10
FED / KDF Character Sheets
11
12
The Character Sheets are made up of multiple areas.
13
14
On the LEFT are the Colonial Chain, Consular Authority Chain,
Asylums / Prisoner Exchanges and all other Chains
from"Ghosts of the Jem'Hadar" to "Extreme Bartending".
15
16
In the CENTER are Dilithum and Custom-Tracking Boxes.
In the Custom Box you can select from a list of missions,
what you want to track.
17
18
To the RIGHT is the DOff Checklist,
here you can mark which Special DOffs you already unlocked.
19
20
21
Mission Tracking
22
23
[Step]
24
You may notice that the Colonial Chain
25
has only 7 steps but we have listed "/ 8".
26
The last option is the unlocked repeatable of that Chain, for example in this case it would be the Support mission.
Step 5 of the Consular Authority chains are the Officer Exchanges.
27
You enter the Step you are looking for NEXT.
So if you have completed Hromi Cluster Step 6, you enter Step 7 in the DOffTrekker as soon as the timers are finished.
28
[Status]
29
This displays the SECTOR Status that is shared on bit.ly/DOFFS for the exact Mission and Step that you are looking for.
30
When the status lights up blue and shows you !!! (or Sector Acronyms like BU, SIR, AZe...) you are good to fly there and start the mission.
31
If it displays a dash you still have a chance to get the mission from your Department Heads.
So it depends on your playstyle if you go there and try your luck or if you only go for the positives and unkowns, personally i have 10 Characters so most of the time i only hunt for confirmed missions to save time or check Sectors that haven't been checked yet.
32
[Time Started]
33
After you started the mission you select the [Time Started] cell and click on the Timestamp button.
34
*see #4 "Timestamp Button !" for more information about the Timestamp Button.
35
[Complete] [Cooldown]
36
One or two timers will appear, the Completion timer and/or the Cooldown timer
37
The Completion timer is visible inside the Game UI, the Cooldown on the other hand is NOT.
38
Having a proper cooldown timer takes away a lot of the guesswork and reduces confusion in mission sharing.
39
40
Asylums / Prisoners
41
Asylums and Prisoner Exchanges require Refugees and Prisoners to be started.
42
In the white cells you can enter the number how many Pudo's you have ready to go home to Tellar.
43
I know this is not an exact science, you can send Pudo to the Caitians after all, if they like Bacon...
44
but i guess you will know best where you want to send your Pudo.
45
This only helps you to see if you can start this mission, there is no math or anything hooked up to it,
46
so feel free to ignore this one if it is too much hassle for you to keep it up to date.
47
48
49
50
Custom Tracking
51
52
There are a few pre-defined missions
53
but this is really a complete custom box,
54
55
You can use the drop down menu to select
56
whatever mission you want to track!
57
58
These missions are all in the data sheet,
59
we can add new missions to this list
60
without the need for you to update anything.
61
If you miss a mission that is tracked on bit.ly/DOFFS already, just shoot me a mail ( @Z3R0B4NG ) or make a note on the Editor Talk Page.
62
If one of these starts to give you an error, the mission has either been removed from the list or a typo might have been fixed.
63
*note: It takes a second for google to load the information, you will have to open the dropdown a 2nd time before you can see the complete list and the scroll bar.
64
*i made the conditional formatting a bit more user friendly in this version, you can now color code the missions however you like, without column 2 defaulting back to orange.
65
If you have multiple chars and want to use the same custom missions for all your characters, best setup your custom cells before you copy the templates.
66
You can also type in the name of these into the overview page (white cells).
67
68
DOff Checklist
69
70
In the DOff Checklist you can mark which and how many special DOff's you've found.
71
72
This is in particular helpful if you have multiple characters to track.
73
74
The information in this list comes primarily from
75
http://www.stowiki.org/Duty_officer/Special
76
If you want any details on the DOffs in the List I suggest you follow the Link.
77
78
New DOffs are added to new Versions of the DOffTrekker as soon as i have the Info.
79
There is also a copy&paste ready template on bit.ly/DOFFS that is kept up to date.
80
The only automated thing here is some conditional formatting.
81
If you mark the checkboxes they will light up green.
82
83
*note: if you don't care for the LockBox DOffs, i have added those to the right,
84
so that you can HIDE / DELETE that column.
85
86
87
88
89
90
91
92
Account Overview
93
94
If you have multiple Characters the Account Overview will give you an Overview
95
of all the missions that are currently running on all of your Characters
96
and it also will tell you if something is available for the taking.
97
98
In the top left corner it tells you when the next Sector Reset and / Shipboard Reset happens.
99
It also tells you from which bit.ly/DOFFS Viewscreen it currently collects it's Data.
The Viewscreen is randomly chosen on opening of the DOffTrekker.

In case of "Pinapple":
Refresh your Browser ( F5 ) and the Sheet will randomly pick another Viewscreen as Data Source.
If the Editor Sheet is unreachable (has been known to happen) then no Viewscreen will have data,
then only GOD ( or @Z3R0B4NG ) can help you.
100