Shared the first version of the spreadsheet over the Accolade channel last month. Now sharing it here and letting users know it has been updated to include House Divided accolades and patrols.
There is a version for both Excel users and Libre/Open users. Both versions contain a macro (please allow it to run when opening) that is used to copy data from your older file and paste it into the new file automatically. The file sizes are larger than normal as there are embedded images (maps for accolades that need them). If this becomes an issue they can be removed in a future update (the images will not display in Open office).
The file links, as well, to Fluffy's accolade listing, to allow older game accounts to review historical accolades no longer present in the game.
You can download the file here:
https://sites.google.com/view/wintersongofarda/sto-accolade-tracker
Download the version that suits your office product only. The file will be within a zipped folder. You will need to unzip the folder and open the file from the unzipped folder. Opening the zipped file will be in a Read Only state and not function properly.
If you do not have MSOffice, you can get Libre Office here:
https://www.libreoffice.org/
I will do my best to keep this file updated as accolades are added in the future, and broken accolades are eventually fixed. I hope those that use it enjoy it. If you have any questions or comments about the file feel free to PM me in game, or this Facebook page (where I will post update notices).
https://www.facebook.com/Lotro-Character-Log-1501959543374524/
Track your accolade progress easily. MSExcel or Libre/Open office required.
Mission Accolade sorting also included.
https://desilu4957.wordpress.com
Comments
Changes:
1. Added Happy Starfleet Day accolade
2. Added KDF factions to Sally Ride patrol quest list.
3. Changed protection settings on Full Listing sheet to allow the Find function to work.
4. Fixed a mismatch error on the General Gameplay sheet that would give incorrect data outcomes.
You can download the file here: https://sites.google.com/view/wintersongofarda/sto-accolade-tracker
Remember to unzip the downloaded and use the file in the unzipped folder.
If you had version 1.0.1 previously you will use the Copy from Previous button in your new version to copy your data automatically.
Mission Accolade sorting also included.
https://desilu4957.wordpress.com
Changes:
1. Added Met Madren accolade
2. Added ToS, DSC, Fed, DFed factions to Klingon Empire: Omega Leonis exploration.
Fixes:
1. Fixed a coding error that was not copy/pasting Exploration Star Cluster accolades.
You can download the file here: https://sites.google.com/view/wintersongofarda/sto-accolade-tracker
Remember to unzip the downloaded and use the file in the unzipped folder.
If you had version 1.0.2 previously you will use the Copy from Previous button in your new version to copy your data automatically.
Mission Accolade sorting also included.
https://desilu4957.wordpress.com
Changes:
1. Added Dependable, Vigilant and Reliant accolades to Exploration - Star Clusters.
2. Set Leading by Example accolade to working.
3. Set No One Left Behind, Novice Isolinear Chip Programmer, and The Bones of Orth II to broken.
You can download the file here: https://sites.google.com/view/wintersongofarda/sto-accolade-tracker
Remember to unzip the downloaded and use the file in the unzipped folder.
If you had version 1.0.3 previously you will use the Copy from Previous button in your new version to copy your data automatically.
Mission Accolade sorting also included.
https://desilu4957.wordpress.com
Changes:
1. Added ability to track individual present colors for Mine, Mine, Mine event accolade.
2. Added ability to track individual recipes for Holiday Chef general accolade.
3. Updated details for Winter Event accolades on Events sheet.
You can download the file here: https://sites.google.com/view/wintersongofarda/sto-accolade-tracker
Remember to unzip the downloaded and use the file in the unzipped folder.
If you had version 1.0.4 previously you will use the Copy from Previous button in your new version to copy your data automatically.
Mission Accolade sorting also included.
https://desilu4957.wordpress.com
Changes:
1. Added Gerren system to Patrols listing under Delta quadrant.
2. Redesigned Accolades portion of the file completely; changes are as follows:
- Accolades now contain all relevant information in a single worksheet.
- Headers now contain hidden comments, detailing what that column is for. (hover cursor over cell to see them)
- Some of the accolade have hidden comments giving more details on the items.
- Footers have been added to all Accolade sections to show section progress (completed accolades, earned points)
- Holiday Chef accolade now has hidden comments that reveal the items needed to complete the recipes.
- Placed protected formulas into some accolades that require a string of accolades to be completed for.
- Corrected some accolade information and completed information on some accolades that were incomplete.
3. Added Accolade Sorter. This will allow you to sort accolades as needed for ease of grouping them. The sorter only includes accolades tied to specific maps or events.4. Added Accolade Maps. This puts all of the maps that were in the file previously all in one location to use as needed.
You can download the file here: https://sites.google.com/view/wintersongofarda/sto-accolade-tracker
Remember to unzip the downloaded and use the file in the unzipped folder.
If you had version 1.0.5 previously you will use the Copy from Previous button in your new version to copy your data automatically.
Mission Accolade sorting also included.
https://desilu4957.wordpress.com
Changes:
You can download the file here: https://sites.google.com/view/wintersongofarda/sto-accolade-tracker
Remember to unzip the downloaded file and use the file located in the unzipped folder.
If you had version 1.1.1 previously you will use the Copy from Previous button in your new version to copy your data automatically.
Mission Accolade sorting also included.
https://desilu4957.wordpress.com
Link to blog - https://accoladeswithdesilu.blogspot.com/p/home.html
Mission Accolade sorting also included.
https://desilu4957.wordpress.com
This version will be many times smaller in size than previous versions.
Changes:
Added Removed Accolades section to accolades sheet
Moved the following general accolades to removed accolades
- Qmendated
- Temporal Agent
- Through the Looking Glass
Moved the following events accolades to removed accolades- Defender of Alpha Quadrant
- Defender of Alpha Quadrant
- Defender of Alpha Quadrant
- Defender of Beta Quadrant
- Defender of Beta Quadrant
- Defender of Beta Quadrant
- Defender of Beta Quadrant
- Defender of Beta Quadrant
- Defender of Orellius
- Defender of Psi Velorum
- Veteran of Alpha Quadrant
- Veteran of Alpha Quadrant
- Veteran of Alpha Quadrant
- Veteran of Beta Quadrant
- Veteran of Beta Quadrant
- Veteran of Beta Quadrant
- Veteran of Beta Quadrant
- Veteran of Beta Quadrant
- Veteran of Orellius
- Veteran of Psi Velorum
- Veteran of the Borg Invasion
Moved the following story accolades to removed accolades- Disenchanted
- Dressed to Kill
- Jailbreak
- Mythological
- Novice Isolinear Chip Programmer
- Raider
- Vigilance
Removed above listed accolades from accolade sorterRemoved Accolade Maps sheet
You can download the file here: https://sites.google.com/view/wintersongofarda/sto-accolade-tracker
Remember to unzip the downloaded file and use the file located in the unzipped folder.
If you had version 1.1.2 previously you will use the Copy from Previous button in your new version to copy your data automatically.
Additionally, the blog I started over a month ago is now completed. It contains walkthrough details for all currently active accolades found within Star Trek Online. If you find anything in error on it, please leave a comment on the comment page of the blog.
The blog can be found here: https://accoladeswithdesilu.blogspot.com/p/home.html
Mission Accolade sorting also included.
https://desilu4957.wordpress.com
I am currently in the process of migrating and integrating my download site for the Alliance Accolade Tracker and my blog Desilu's Accolade Walkthroughs to a new home, and away from Google services.
The new site is coming along nicely so far and I am hoping it will be an improvement to users. Some of the information has been improved upon and more usage of images has been incorporated into it. The site is in a live state currently but is far from being completed. You can view and bookmark it here, https://desilu4957.wordpress.com/
I will follow this post up when the migration is completed to let you know that the old site/blog have been closed. It will likely be within the next month or so.
Mission Accolade sorting also included.
https://desilu4957.wordpress.com
The blogspot and googlesite links no longer exist.
Mission Accolade sorting also included.
https://desilu4957.wordpress.com
Changes:
1. Moved the following general accolades to removed accolades
- Gamma Recruit
- Klingon Recruit
2. Removed same for Accolade Sorter3. Added 3 new Klingon Civil War patrols to Patrols
4. Updated link in file to new Accolade Walkthrough site.
Additionally updated the Klingon Civil War accolade on the site listing to include the final 2 missions from the episode.
You can download the file here - https://desilu4957.wordpress.com/
Mission Accolade sorting also included.
https://desilu4957.wordpress.com
Changes:
1. Returned Vigilance KDF story accolade to active status, including added back to Accolade Sorter.
2. Added optional Reputation tracking worksheet, which includes full TFO listing per reputation.
3. Added optional Specialization tracking worksheet.
4. Added optional Mission Log tracking worksheet, which includes personal mission notes section.
You can download the file here - https://desilu4957.wordpress.com/
Mission Accolade sorting also included.
https://desilu4957.wordpress.com
Changes:
1. Total Captains added to Summary Sheet. Enter the number of captains you are tracking with the file (1-9). This number will be used to calculate section completion. (continue reading)
2. Added Met Mirror Leeta to Story Accolades. Also added accolade to Accolade Sorter.
3. Added conditional formatting to accolade section headers. Section headers will turn green once all characters you are recording accolades for complete the accolades for each section. As as example; 4 characters (noted from #1 above) complete all accolades for Kills - Orion, the header for Kills - Orion will turn green to visually cue that you have no more work needed in that section.
4. Added Point of Contact, Type (ground or space), and Enemy information to all patrols.
5. Added section for Terran Gambit to Mission Log sheet. This section will be updated as new missions are added for the story arc.
6. Removed Reputation and Specialization worksheets.
You can download the file here - https://desilu4957.wordpress.com/
Mission Accolade sorting also included.
https://desilu4957.wordpress.com
MS Excel users will get a new version sometime around the first of the year. It will only contain some cosmetic changes and have many typos corrected. *unless something changes in-game before then*
I apologize to Open/Libre office users for this inconvenience, but fixing this issue is above my pay grade.
Mission Accolade sorting also included.
https://desilu4957.wordpress.com
Changes:
1. Increased font size on all sheets to make reading a little easier on the eyes.
2. Corrected various spelling errors throughout the file.
3. Trimmed 1 column from Accolade Sorter and fixed issue that was causing it not to work.
4. Removed update notes history from Summary sheet.
As a reminder, both Excel and Open/Libre office versions were updated, however this is the last version of the tracker for Open/Libre office. Excel updates will continue moving forward as needed.
You can download the file here - https://desilu4957.wordpress.com/
Mission Accolade sorting also included.
https://desilu4957.wordpress.com
Changes:
1. Added Met Admiral Janeway to Story Accolades and to Accolade Sorter.
2. Added Red Shift to Terran Gambit on Mission Log.
You can download the file here - https://desilu4957.wordpress.com/
Mission Accolade sorting also included.
https://desilu4957.wordpress.com
It would of been nice to have been messaged about this move, as you broke the link that I have been using to share with others.
Mission Accolade sorting also included.
https://desilu4957.wordpress.com
Changes:
- Added missions Blue Shift and The Calling to Mission Log
You can download the file here - https://desilu4957.wordpress.com/Mission Accolade sorting also included.
https://desilu4957.wordpress.com
Changes:
You can download the file here - https://desilu4957.wordpress.com/
Mission Accolade sorting also included.
https://desilu4957.wordpress.com
Also of note, under your general accolades section for the mission Viscous Cycle, you have it labelled as Vicious Cycle..
No, there are no new accolades. Thank you for the typo notice, will fix it for next update. The Mission Log is just to track your mission progress if you have lots of alts and don't wish to alt around to figure out who needs to do certain missions.
Mission Accolade sorting also included.
https://desilu4957.wordpress.com
Changes:
Important Note
Office has pushed another security feature regarding macro-embedded files, which this file is and requires in order to function. If the file gives you a blocked because of macro notice when opening, please review this page HERE
The macro is in no way malicious. It is required to perform the copy/paste function when transferring your character information from an older version of the file into the newer file, and to allow office features to function within a password protected environment.
I understand the annoyance Microsoft places on users as the files give me this same warning as well when I download them from my onedrive to do updates to the file as needed.
You can download the file here - https://desilu4957.wordpress.com/
Mission Accolade sorting also included.
https://desilu4957.wordpress.com
Changes:
Story: added accolade Met Kuumaarke (also added to Accolade Sorter)
Story: added accolade First City (also added to Accolade Sorter)
Patrols: Added 2 new patrols and renamed patrol group Mirror Universe
Mission Log: Added Wish Upon a Star and Kings & Queens mission section
You can download the file here - https://desilu4957.wordpress.com/
Mission Accolade sorting also included.
https://desilu4957.wordpress.com
Changes:
Mission Log: Added Taken By Surprise to Kings & Queens mission section
You can download the file here - https://desilu4957.wordpress.com/
Mission Accolade sorting also included.
https://desilu4957.wordpress.com
Changes:
Notes:
The Excel version will stay with its schedule of only being updated if new content is added to the game that requires it, as it contains a built in macro to copy data directly from its previous version into the newly updated version.
The ODS and Google Sheets versions will both receive updates annually since they contain no automation within them. Users will have to manually copy their data into new versions if they choose to update their file.
The ODS versions will require either Open Office or Libre Office to use.
The Google Sheets version you will need to:
You can download the file here - https://desilu4957.wordpress.com/
Mission Accolade sorting also included.
https://desilu4957.wordpress.com