Changing the “formula” is not something I want to do often, but sometimes it is necessary to improve the scoring. And there were a few items that needed some evolution.
- The formula needed simplification. This you won’t really notice in the final results, but there is a trade-off between precision and portability. I was able to make some changes that simplified the calculations, to make future features (and error corrections) a little easier to implement.
- Gauntlet traits – the Gauntlet Power Rating considering traits was a popular request. This has been implemented in a limited fashion, but some of the challenges remain. Namely – the traits considered, and the frequency which they occur is not “published,” and can change at any time without notice. That makes it difficult for a formula-based rating system that doesn’t arbitrarily assign bonuses bases on temporary desirability! The good news is, the current trait metric seems to help identify those crew who have the potential for high crits. So a step in the right direction!
- “Bones” McCoy. What do you do with a crew who is excellent at one very specific thing, and worthless for everything else? Changes have been made to the formula to make it a little more accurate for crew like this. You will see his improvement in his Fa score. The changes to the formula aren’t specific to him – meaning the formula will be able to handle any similar crew that pop up in the future.
As always, feedback is welcome. Including just knowing you are using the system, and that you like it!
I liked v2 well enough, but it was fairly limited with what interaction could be had with the data. And man was error correction for a large number of entries a pain in the butt.
So, here we have v3. It will allow for some filtering of the data to hopefully allow you to focus on those items you want to look at at once, instead of searching through a whole list manually for all of the crew. The instructions on the page are pretty straightforward, but if you have any issues – you know how to get a hold of me.
I did remove the columns for Collection count, Arena Bonus, Fusibility, and Cadet Challenges. That data is still considered in the Overall – but I didn’t think it was important enough on its own to clutter up the display with. I will reconsider this as time goes on, and maybe bring it back if people think it was worth having there. There are other tools that provide that kind of information and I am definitely not trying to replace them!
So lots of good news – the stat corrections are done, and for the most part – the changes were very minor. The error had an impact on 578 crew – but less than half of those changed in a way that would even appear on the final Power Ratings. Very few had any movement over .1 point.
Here is the complete list of changes, sorted by the amount of change:
|Dress Uniform Scotty||-0.5||-1.1|
|H.M.S. Pinafore Data||-0.5||-1.1|
|RAF Miles O’Brien||-0.4||-0.9|
|Assimilated La Forge||-0.4||-0.9|
|Mountain Climber Mayweather||-0.4||-0.8|
|Captain Harry Kim||-0.4||-0.8|
|Delta Flyer Paris||-0.4||-0.7|
|Captain La Forge||-0.3||-0.8|
|The One, Lore||-0.3||-0.7|
|EV Suit Tucker||-0.3||-0.7|
|Vice Admiral Janeway||-0.3||-0.8|
|Delta Flyer Kim||-0.2||-0.5|
|Smuggler Kasidy Yates||-0.2||-0.5|
|Mirror ‘Smiley’ O’Brien||-0.2||-0.4|
|Ensign Robin Lefler||-0.2||-0.4|
|Age of Sail La Forge||-0.2||-0.6|
|Mirror Zefram Cochrane||-0.1||-0.1|
|Geordi La Forge||-0.1||-0.3|
|Age of Sail Data||-0.1||-0.2|
|Captain Proton Paris||-0.1||-0.2|
|Delta Flyer Torres||-0.1||-0.2|
|Annika Hansen Seven||-0.1||-0.2|
|EV Suit Archer||-0.1||-0.1|
|Augment Commander O’Brien||-0.1||-0.1|
|Musketeer La Forge||-0.1||0.0|
|Away Team Archer||-0.1||0.0|
|Chief Engineer Torres||-0.1||0.0|
|Cadet Sylvia Tilly||-0.1||0.0|
|Dr. David Marcus||-0.1||0.0|
|Grand Proxy Neelix||0.0||-0.2|
|Solar Sails Sisko||0.0||-0.2|
|Automated Unit 3947||0.0||-0.1|
|Drone Seven of Nine||0.0||-0.1|
|Torpedo Surgeon McCoy||0.0||-0.1|
|Maquis Takeover Torres||0.0||-0.1|
|Tribble Herder Scotty||0.0||-0.1|
|Age of Sail Riker||0.0||-0.1|
|Five of Twelve||0.0||-0.1|
|Chief Engineer La Forge||0.0||-0.1|
|Time Loop Mudd||0.0||-0.1|
|Lt. Commander Icheb||0.0||-0.1|
|The Red Angel||0.0||-0.1|
|Lt. JG Palmer||0.0||-0.1|
|Seven in Silver||0.0||-0.1|
|Doctor La Forge||0.0||-0.1|
|Graduation Michael Burnham||0.0||-0.1|
|Mirror Jadzia Dax||0.0||-0.1|
|Displaced Gabrielle Burnham||0.0||-0.1|
|Dahar Master Koloth||0.0||0.1|
|Alternate Future T’Pol||0.0||0.1|
|C.O.P. Founder Picard||0.0||0.1|
|Captain John Harriman||0.0||0.1|
|EV Suit Chekov||0.0||0.1|
|Jazz Musician Odo||0.0||0.1|
|Rigel VII Vina||0.0||0.1|
|Desert Philippa Georgiou||0.0||0.1|
|Sulu of the Body||0.0||0.1|
|The President of Earth||0.0||0.1|
|Vulcan Wedding T’Pol||0.0||0.1|
|Mirror Intendant Kira||0.0||0.1|
|Tourist Jadzia Dax||0.0||0.1|
|Captain Morgan Bateson||0.0||0.1|
|Mirror Ezri Tigan||0.0||0.1|
|Writer Jake Sisko||0.0||0.1|
|Rogue Kai Winn||0.0||0.1|
|Celebratory Ash Tyler||0.0||0.1|
|High Roller Sisko||0.0||0.1|
|Satin Dress Lily Sloane||0.0||0.1|
|Tyler, Son of None||0.0||0.1|
|Merry Men Troi||0.0||0.1|
|Tommy Gun Dixon||0.1||0.0|
|Tee Time Doctor||0.1||0.0|
|Cadet First Class Locarno||0.1||0.0|
|First Officer Riker||0.1||0.0|
|UFP President Ra-ghoratreii||0.1||0.0|
|Relaxed Number One||0.1||0.1|
|Suus Mahna Sarek||0.1||0.1|
|Commander Kira Nerys||0.1||0.0|
|Enemy Lines Sisko||0.1||0.0|
So a big thanks to cmdrworf (who administers the Do Not Airlock Checklist) for noticing an error on one of the Voyage Pair stats. Perhaps I should be cursing him, because this means I need to error correct 578 of the crew’s Ov and Vo Power Ratings!
Luckily, most all of the crew’s changes will be so minor that they may not be noticeable. A couple of the Vo stats had a 1 point swing, but an initial look shows that no real changes in the top 20.
In the interests of transparency, I’ll be posting all of the changes here once they are done!
Yesterday, v2.0 of the Power Ratings were released. This update included heavy revisions to the Voyage and Gauntlet formulas, and the addition of all crew tiers. Thanks to everyone who provided feedback on v1 and the latest version!
I am in a constant state of error checking, both to verify the stats are correct and to add a little more functionality to the site. During that process, I uncovered a formula error that lead to minor changes in 7 crew. Those changes are listed in the changelog.
Later today, I hope to add the stats for Young Anya – the new Legendary Crew from today’s pack.
First, I wanted to thank everyone for all of the positive feedback (and constructive criticism) about the CAB Power Ratings. I have found all of it (well, most of it!) very helpful.
As of now, all of the Legendary and Super Rare crew has been posted. I’ve also added a decimal place to the rating, to allow for a little finer distinction between the crew at various levels.
I’m working on a bunch of things right now to help refine the list a little bit. I’ve gone “back to formula” on the Voyage Rating, to help refine that a little bit more. This change will also result in a change in the overall score – so I am taking a little extra time before pushing it out. Here’s a preview of some of the swings you might see in the voyage stats —>
Once I’m comfortable that this refinement to the formula will be an improvement, I’ll push it out, then look to add the remaining crew rarities to the site. In the meantime, I’m glad that you’ve added this tool to your chest. I hope it serves you well!
- Adira Tal added
- Mirror McCoy added
- EV Suit Worf added
- added “The Colony” Tilly
- added Mirror Saru
- Laneth added
- The Continuum collection added
- Event page updated with Tick Tock crew ratings
- General Oh added.
- Sahil added.
- Linus added.
- Lt. Booker added.
- Courier Burnham added.
- Event Crew for The Big Sting (rerun) updated
- Carlos Data added
- Maquis Takeover Paris added
- Flustered Jett Reno added
- Repaired table import error
- Maquis Takeover Seska added.
- Cyrano de Barclay added.
- A.G. Robinson added
- A Little Stroll Collection added – stats updated
- Facer Rios added
- Kelis added