Version 4 Rollout

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!

Version 3 is now live

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!

Stat Correction Update

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:

 

OV Change
VO Change
Captain Lorian -0.5 -1.1
Dress Uniform Scotty -0.5 -1.1
H.M.S. Pinafore Data -0.5 -1.1
Ahdar Ru’afo -0.5 -1.0
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
Interfaced Barclay -0.4 -0.7
Captain Braxton -0.3 -0.9
Captain La Forge -0.3 -0.8
Laborer Kirk -0.3 -0.7
The One, Lore -0.3 -0.7
Amelia Earhart -0.3 -0.6
EV Suit Tucker -0.3 -0.7
Kazon Seska -0.3 -0.4
Vice Admiral Janeway -0.3 -0.8
Tuskegee Mayweather -0.3 -0.7
Desperate Riker -0.2 -0.6
Commander Kelby -0.2 -0.5
Delta Flyer Kim -0.2 -0.5
Commander Barclay -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
Keyla Detmer -0.2 -0.6
Vosk -0.2 -0.4
Captain Killy -0.1 -0.2
Roga Danar -0.1 -0.1
Mirror Zefram Cochrane -0.1 -0.1
Professor Scott -0.1 0.0
White Rabbit -0.1 0.0
Navigator Stamets -0.1 -0.2
Ensign Mendon -0.1 0.0
Geordi La Forge -0.1 -0.3
Commander Scott -0.1 -0.3
Commander Tucker -0.1 -0.3
Penk -0.1 -0.3
Age of Sail Data -0.1 -0.2
Captain Proton Paris -0.1 -0.2
Hockey Kim -0.1 -0.2
Delta Flyer Torres -0.1 -0.2
Boomer Mayweather -0.1 -0.2
Injured Torres -0.1 -0.2
Grathon Tolar -0.1 -0.2
Annika Hansen Seven -0.1 -0.2
Irina -0.1 -0.1
EV Suit Archer -0.1 -0.1
The Caretaker -0.1 -0.1
Icheb -0.1 -0.1
Augment Commander O’Brien -0.1 -0.1
Technician Fisher -0.1 0.0
One -0.1 0.0
Klingon Torres -0.1 0.0
Musketeer La Forge -0.1 0.0
Away Team Archer -0.1 0.0
Stranded Craft -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
Etana Jol -0.1 0.0
Grand Proxy Neelix 0.0 -0.2
Determined Janeway 0.0 -0.2
Solar Sails Sisko 0.0 -0.2
Colonel Karr 0.0 -0.1
Duelist Torres 0.0 -0.1
Leah Brahms 0.0 -0.1
Zero One 0.0 -0.1
Automated Unit 3947 0.0 -0.1
Drone Seven of Nine 0.0 -0.1
One Zero 0.0 -0.1
Torpedo Surgeon McCoy 0.0 -0.1
Undercover O’Brien 0.0 -0.1
Maquis Takeover Torres 0.0 -0.1
Chief O’Brien 0.0 -0.1
Tribble Herder Scotty 0.0 -0.1
Augment Riker 0.0 -0.1
Age of Sail Riker 0.0 -0.1
Five of Twelve 0.0 -0.1
Talas 0.0 -0.1
Chief Engineer La Forge 0.0 -0.1
Time Loop Mudd 0.0 -0.1
Loken 0.0 -0.1
Tosk 0.0 -0.1
Mirror Data 0.0 -0.1
Lt. Commander Icheb 0.0 -0.1
The Red Angel 0.0 -0.1
Dr. Soong 0.0 -0.1
Ishara Yar 0.0 -0.1
Lt. JG Palmer 0.0 -0.1
Seven in Silver 0.0 -0.1
Nomad 0.0 -0.1
Subcommander T’Rul 0.0 -0.1
Duelist Barclay 0.0 -0.1
Conflicted Sisko 0.0 -0.1
Doctor La Forge 0.0 -0.1
Graduation Michael Burnham 0.0 -0.1
Gralik Durr 0.0 -0.1
Mirror Jadzia Dax 0.0 -0.1
Niners Rom 0.0 -0.1
Romulan Data 0.0 -0.1
Displaced Gabrielle Burnham 0.0 -0.1
Dahar Master Koloth 0.0 0.1
Quinn 0.0 0.1
Alternate Future T’Pol 0.0 0.1
Bajoran Dukat 0.0 0.1
C.O.P. Founder Picard 0.0 0.1
Captain John Harriman 0.0 0.1
Captive Bashir 0.0 0.1
Cardassian Kira 0.0 0.1
Commander Nevesa 0.0 0.1
Crell Moset 0.0 0.1
Deanna Troi 0.0 0.1
Drafted McCoy 0.0 0.1
EV Suit Chekov 0.0 0.1
Expedition Shran 0.0 0.1
Groom Worf 0.0 0.1
Jazz Musician Odo 0.0 0.1
Katra McCoy 0.0 0.1
Mirror T’Pol 0.0 0.1
Nyota Uhura 0.0 0.1
Revolutionary Damar 0.0 0.1
Rigel VII Vina 0.0 0.1
Riker Q 0.0 0.1
Riley Frazier 0.0 0.1
Suliban Reed 0.0 0.1
Tarquin 0.0 0.1
Trader Odo 0.0 0.1
Usurper Lorca 0.0 0.1
Admiral Ross 0.0 0.1
Desert Philippa Georgiou 0.0 0.1
Duchamps 0.0 0.1
Musketeer Picard 0.0 0.1
Navaar 0.0 0.1
Raffi Musiker 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
Belle Q 0.0 0.1
Kay Eaton 0.0 0.1
Mirror Intendant Kira 0.0 0.1
Zhian’tara Odo 0.0 0.1
Kai Opaka 0.0 0.1
Grebnedlog 0.0 0.1
Seeking Spock 0.0 0.1
Tourist Jadzia Dax 0.0 0.1
Captain Morgan Bateson 0.0 0.1
Captain Pike 0.0 0.1
Mirror Ezri Tigan 0.0 0.1
Mariachi Q 0.0 0.1
Virtuoso Doctor 0.0 0.1
Chancellor Gorkon 0.0 0.1
Orion Vina 0.0 0.1
Writer Jake Sisko 0.0 0.1
Keevan 0.0 0.1
The Viceroy 0.0 0.1
Captain Sulu 0.0 0.1
Kilana 0.0 0.1
Kortar 0.0 0.1
Pining Vina 0.0 0.1
Rogue Kai Winn 0.0 0.1
Celebratory Ash Tyler 0.0 0.1
Christopher Pike 0.0 0.1
High Roller Sisko 0.0 0.1
Satin Dress Lily Sloane 0.0 0.1
Ambassador Soval 0.0 0.1
Dancing Chekov 0.0 0.1
Humbled Archer 0.0 0.1
Vahar’ai Saru 0.0 0.1
Ambassador Spock 0.0 0.1
Benny Russell 0.0 0.1
Fierce Guinan 0.0 0.1
Mother L’Rell 0.0 0.1
Portal 63 0.0 0.1
Rain Robinson 0.0 0.1
Solbor 0.0 0.1
Tyler, Son of None 0.0 0.1
Dancing Uhura 0.0 0.1
Enterprise-E Picard 0.0 0.1
Mirror Shukar 0.0 0.1
Desert Archer 0.0 0.1
Q2 0.0 0.1
Determined Paris 0.0 0.1
Layna 0.0 0.1
Merry Men Troi 0.0 0.1
Borg Queen 0.0 0.1
Advocate Kolos 0.1 0.0
Astrosciences Sulu 0.1 0.0
Captain Spock 0.1 0.0
Lieutenant Tarah 0.1 0.0
Miral Torres 0.1 0.0
Robin Hood 0.1 0.0
Tommy Gun Dixon 0.1 0.0
Tuxedo Nog 0.1 0.0
Data Q 0.1 0.0
Ushaan Shran 0.1 0.0
Chef Riker 0.1 0.0
Mambo Picard 0.1 0.0
Tee Time Doctor 0.1 0.0
Expedition Vash 0.1 0.0
Lwaxana Troi 0.1 0.0
Admiral Nechayev 0.1 0.0
Cadet First Class Locarno 0.1 0.0
First Officer Riker 0.1 0.0
GI Chakotay 0.1 0.0
Romulan Picard 0.1 0.0
UFP President Ra-ghoratreii 0.1 0.0
Pugilist Q 0.1 0.1
Bartender Tuvok 0.1 0.1
Trader Worf 0.1 0.1
Vic Fontaine 0.1 0.1
Betrothed Kamala 0.1 0.1
Relaxed Number One 0.1 0.1
Suus Mahna Sarek 0.1 0.1
Commander Uhura 0.1 0.0
Klingon Dukat 0.1 0.0
Commander Kira Nerys 0.1 0.0
Commander Sela 0.1 0.0
Maid Marian 0.1 0.0
Enemy Lines Sisko 0.1 0.0
Orion Slaver 0.1 0.0
Commander Troi 0.1 0.0

More Error Correction

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!

Version 2.0 Rollout – Continuing Improvements

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.

Thanks checking this out! Here are the things that are coming soon:

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!

Changelog

2020-10-20

  • Mok’bara Crusher added
  • Smoke and Mirrors Collection added – stats updated

2020-10-13

  • D’Nesh added.
  • Filters for Top Base, Top Combined, and Top Voyage Pair added.

2020-10-08

  • EV Suit Spock added
  • Dignitary Sarek added
  • Captain Solok added

2020-10-05

  • Awaiting Amanda Grayson added
  • The Noblest Half Power Ratings posted

2020-09-24

  • Ambassador V’Lar added
  • Dr. Roger Korby added
  • Altan Inigo Soong added