test content
What is the Arc Client?
Install Arc

Track Your Accolade Progress

desilu#4957 desilu Member Posts: 47 Arc User
edited May 2022 in The Academy
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
mfaVMsI.png
Post edited by baddmoonrizin on

Comments

  • desilu#4957 desilu Member Posts: 47 Arc User
    The Alliance Accolade Tracker has been updated to version 1.0.2

    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.
    Track your accolade progress easily. MSExcel or Libre/Open office required.
    Mission Accolade sorting also included.
    https://desilu4957.wordpress.com
    mfaVMsI.png
  • desilu#4957 desilu Member Posts: 47 Arc User
    The Alliance Accolade Tracker has been updated to version 1.0.3

    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.
    Track your accolade progress easily. MSExcel or Libre/Open office required.
    Mission Accolade sorting also included.
    https://desilu4957.wordpress.com
    mfaVMsI.png
  • desilu#4957 desilu Member Posts: 47 Arc User
    The Alliance Accolade Tracker has been updated to version 1.0.4

    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.
    Track your accolade progress easily. MSExcel or Libre/Open office required.
    Mission Accolade sorting also included.
    https://desilu4957.wordpress.com
    mfaVMsI.png
  • desilu#4957 desilu Member Posts: 47 Arc User
    The Alliance Accolade Tracker has been updated to version 1.0.5

    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.
    Track your accolade progress easily. MSExcel or Libre/Open office required.
    Mission Accolade sorting also included.
    https://desilu4957.wordpress.com
    mfaVMsI.png
  • desilu#4957 desilu Member Posts: 47 Arc User
    The Alliance Accolade Tracker has been updated to version 1.1.1

    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.
    Track your accolade progress easily. MSExcel or Libre/Open office required.
    Mission Accolade sorting also included.
    https://desilu4957.wordpress.com
    mfaVMsI.png
  • desilu#4957 desilu Member Posts: 47 Arc User
    The Alliance Accolade Tracker has been updated to version 1.1.2

    Changes:
    1. Added Klingon Recruit accolade to General accolades
    2. Added Age of Discovery accolade to Story accolades
    3. Added J'Ula's Discovery accolade to Story accolades
    4. Added Klingon Civil War accolade to Story accolades
    5. Added New Frontiers accolade to Story accolades
    6. Added color coding and faction dropdown selection for KDFD (Discovery era KDF)
    7. Added Char 9 to accommodate all 9 current in-game factions
    8. Accolade Sorter now shows character data for accolades included in the sorter

    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.
    Track your accolade progress easily. MSExcel or Libre/Open office required.
    Mission Accolade sorting also included.
    https://desilu4957.wordpress.com
    mfaVMsI.png
  • desilu#4957 desilu Member Posts: 47 Arc User
    Started a blog to further detail the completion of accolades. As of this posting, Borg Front, Commendation, Damage, and Delta Quadrant category accolades are completed, and currently working on Events category. This will be a work in progress until all current accolades are posted on it. Hope the blog and the tracker help make accolade chasing easier for all.

    Link to blog - https://accoladeswithdesilu.blogspot.com/p/home.html
    Track your accolade progress easily. MSExcel or Libre/Open office required.
    Mission Accolade sorting also included.
    https://desilu4957.wordpress.com
    mfaVMsI.png
  • desilu#4957 desilu Member Posts: 47 Arc User
    The Alliance Accolade Tracker has been updated to version 1.1.3

    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
    1. Qmendated
    2. Temporal Agent
    3. Through the Looking Glass
    Moved the following events accolades to removed accolades
    1. Defender of Alpha Quadrant
    2. Defender of Alpha Quadrant
    3. Defender of Alpha Quadrant
    4. Defender of Beta Quadrant
    5. Defender of Beta Quadrant
    6. Defender of Beta Quadrant
    7. Defender of Beta Quadrant
    8. Defender of Beta Quadrant
    9. Defender of Orellius
    10. Defender of Psi Velorum
    11. Veteran of Alpha Quadrant
    12. Veteran of Alpha Quadrant
    13. Veteran of Alpha Quadrant
    14. Veteran of Beta Quadrant
    15. Veteran of Beta Quadrant
    16. Veteran of Beta Quadrant
    17. Veteran of Beta Quadrant
    18. Veteran of Beta Quadrant
    19. Veteran of Orellius
    20. Veteran of Psi Velorum
    21. Veteran of the Borg Invasion
    Moved the following story accolades to removed accolades
    1. Disenchanted
    2. Dressed to Kill
    3. Jailbreak
    4. Mythological
    5. Novice Isolinear Chip Programmer
    6. Raider
    7. Vigilance
    Removed above listed accolades from accolade sorter
    Removed 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
    Track your accolade progress easily. MSExcel or Libre/Open office required.
    Mission Accolade sorting also included.
    https://desilu4957.wordpress.com
    mfaVMsI.png
  • desilu#4957 desilu Member Posts: 47 Arc User
    This posting is to inform users of my site/blog that I am in the process of migrating to a new host.

    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.
    Track your accolade progress easily. MSExcel or Libre/Open office required.
    Mission Accolade sorting also included.
    https://desilu4957.wordpress.com
    mfaVMsI.png
  • desilu#4957 desilu Member Posts: 47 Arc User
    The site migration is now complete. Please use the wordpress link above.

    The blogspot and googlesite links no longer exist.
    Track your accolade progress easily. MSExcel or Libre/Open office required.
    Mission Accolade sorting also included.
    https://desilu4957.wordpress.com
    mfaVMsI.png
  • desilu#4957 desilu Member Posts: 47 Arc User
    The Alliance Accolade Tracker has been updated to version 1.1.4

    Changes:

    1. Moved the following general accolades to removed accolades
    • Gamma Recruit
    • Klingon Recruit
    2. Removed same for Accolade Sorter
    3. 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/
    Track your accolade progress easily. MSExcel or Libre/Open office required.
    Mission Accolade sorting also included.
    https://desilu4957.wordpress.com
    mfaVMsI.png
  • desilu#4957 desilu Member Posts: 47 Arc User
    The Alliance Accolade Tracker has been updated to version 1.2.0

    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/
    Track your accolade progress easily. MSExcel or Libre/Open office required.
    Mission Accolade sorting also included.
    https://desilu4957.wordpress.com
    mfaVMsI.png
  • desilu#4957 desilu Member Posts: 47 Arc User
    The Alliance Accolade Tracker has been updated to version 1.2.1

    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/
    Track your accolade progress easily. MSExcel or Libre/Open office required.
    Mission Accolade sorting also included.
    https://desilu4957.wordpress.com
    mfaVMsI.png
  • desilu#4957 desilu Member Posts: 47 Arc User
    Posted what will be the final version of Alliance Accolade Tracker for Open/Libre office users to my site. I am discontinuing support as the copy/paste macro no longer functions and I am not well versed on OO Basic to narrow down or fix the issue. This version will not prompt a macro warning as I removed the macro from the file.

    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.
    Track your accolade progress easily. MSExcel or Libre/Open office required.
    Mission Accolade sorting also included.
    https://desilu4957.wordpress.com
    mfaVMsI.png
  • desilu#4957 desilu Member Posts: 47 Arc User
    The Alliance Accolade Tracker has been updated to version 1.2.2

    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/
    Track your accolade progress easily. MSExcel or Libre/Open office required.
    Mission Accolade sorting also included.
    https://desilu4957.wordpress.com
    mfaVMsI.png
  • desilu#4957 desilu Member Posts: 47 Arc User
    The Alliance Accolade Tracker has been updated to version 1.2.3

    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/
    Track your accolade progress easily. MSExcel or Libre/Open office required.
    Mission Accolade sorting also included.
    https://desilu4957.wordpress.com
    mfaVMsI.png
  • desilu#4957 desilu Member Posts: 47 Arc User
    edited May 2022
    Now that I see where this post was moved to, can I ask why it was moved from the Player Guides section where it was sitting for almost the last 2 years?

    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.
    Track your accolade progress easily. MSExcel or Libre/Open office required.
    Mission Accolade sorting also included.
    https://desilu4957.wordpress.com
    mfaVMsI.png
  • desilu#4957 desilu Member Posts: 47 Arc User
    edited May 2022
    The Alliance Accolade Tracker has been updated to version 1.2.4
    Changes:
    1. Added missions Blue Shift and The Calling to Mission Log
    You can download the file here - https://desilu4957.wordpress.com/
    Track your accolade progress easily. MSExcel or Libre/Open office required.
    Mission Accolade sorting also included.
    https://desilu4957.wordpress.com
    mfaVMsI.png
  • desilu#4957 desilu Member Posts: 47 Arc User
    edited September 2022
    The Alliance Accolade Tracker has been updated to version 1.2.5
    Changes:
    • Commendation accolades that are Romulan specific will now auto-fill upon completion of tier 4 of the commendations.
    • Corrected a summary calculation error for the M.A.C.O accolades summary
    • Added new mission "Eye of the Storm" to Mission Log
    • Added Episode summaries for all episodes. Total missions in the episode/completed missions in the episode/completion %.

    You can download the file here - https://desilu4957.wordpress.com/
    Track your accolade progress easily. MSExcel or Libre/Open office required.
    Mission Accolade sorting also included.
    https://desilu4957.wordpress.com
    mfaVMsI.png
  • timelords1701timelords1701 Member Posts: 556 Arc User
    You mention in your last post "Added new mission "Eye of the Storm" to Mission Log". were there any new accolades associated with that mission or new TFO ?.
    Also of note, under your general accolades section for the mission Viscous Cycle, you have it labelled as Vicious Cycle..
  • desilu#4957 desilu Member Posts: 47 Arc User
    You mention in your last post "Added new mission "Eye of the Storm" to Mission Log". were there any new accolades associated with that mission or new TFO ?.
    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.
    Track your accolade progress easily. MSExcel or Libre/Open office required.
    Mission Accolade sorting also included.
    https://desilu4957.wordpress.com
    mfaVMsI.png
  • desilu#4957 desilu Member Posts: 47 Arc User
    The Alliance Accolade Tracker has been updated to version 1.2.6
    Changes:
    • STF Honor Guard: Made corrections to the accolades in the section
    • STF M.A.C.O.: Made corrections to the accolades in the section
    • STF S.O.T.O.: Made corrections to the accolades in the section
    • Story: Added Relief for the Relief and Terran Gambit accolades (also added to Accolade Sorter)
    • Patrols: Added patrols for Terran Gambit
    • Mission Log: Added The Fujiwhara Effect to Terran Gambit missions
    • Mission Log: Personal notes placed on the mission log will now be copied to your newest file

    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/
    Track your accolade progress easily. MSExcel or Libre/Open office required.
    Mission Accolade sorting also included.
    https://desilu4957.wordpress.com
    mfaVMsI.png
  • desilu#4957 desilu Member Posts: 47 Arc User
    The Alliance Accolade Tracker has been updated to version 1.2.7
    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/
    Track your accolade progress easily. MSExcel or Libre/Open office required.
    Mission Accolade sorting also included.
    https://desilu4957.wordpress.com
    mfaVMsI.png
  • desilu#4957 desilu Member Posts: 47 Arc User
    The Alliance Accolade Tracker has been updated to version 1.2.8
    Changes:

    Mission Log: Added Taken By Surprise to Kings & Queens mission section


    You can download the file here - https://desilu4957.wordpress.com/
    Track your accolade progress easily. MSExcel or Libre/Open office required.
    Mission Accolade sorting also included.
    https://desilu4957.wordpress.com
    mfaVMsI.png
  • desilu#4957 desilu Member Posts: 47 Arc User
    edited December 2023
    Desilu's Accolade Tracker has been updated to version 1.3.0

    Changes:
    1. For those that have been using the XLSM (MS Excel) file version, this is only a cosmetic update
    2. The ODS version of the file has been updated to include all new accolades, patrols, and missions
    3. There is a new Google Sheets version to the file that includes all accolades, patrols, and missions.

    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:
    • When the sheet is open on my Google drive
    • Access the File menu
    • Select Make a Copy
    • Copy it your OWN personal Google drive
    • Open the file from your personal Google drive to use it


    You can download the file here - https://desilu4957.wordpress.com/
    Post edited by desilu#4957 on
    Track your accolade progress easily. MSExcel or Libre/Open office required.
    Mission Accolade sorting also included.
    https://desilu4957.wordpress.com
    mfaVMsI.png
Sign In or Register to comment.