Ok, so, first off, I just bought nine more Kindle ebooks in this (June 2023) $0.99 sale group. (The only ones I already had were Dead Endless, No Time Like the Past, and Revenant.)
Now, after adding these to my spreadsheet, I further tinkered with the data there, primarily putting “N/A”s by all of the individual enovellas in my “Print Copies” column, adding in the print omnibus editions for just the ones that put enovellas in print (I didn’t add listings for the omnibus editions that collected together already in print novels like Odyssey or Twist of Fate), and putting “N/A”s also in the ebooks column for those that have never been released in ebook format (mainly nearly all of the young adult novels but also the first three Shatnerverse novels (The Ashes of Eden, The Return, Avenger), Enterprise: The First Adventure, Probe, Cybersong, and both the 1997 Starfleet Academy computer game and Day of Honor tv episode novelizations. (I may have missed a few but I think that’s just about all of them.)
This tinkering has resulted in new total numbers (so I want to update them here for the record, especially after Koric just deemed my last figure of Star Trek ebooks as “the official count”. Please, no. “Unofficial”, at best. And still not exactly correct, I’m sure.
Initial qualifying info: Star Trek novels in print figures does not include Bantam or Ballantine releases (so none of the Blish or Foster novelizations and none of the pre Pocket Books Bantam novels), nor does it include nonfiction books or children’s books aside from the “Minstrel” Starfleet Academy and Star Trek: Deep Space Nine young adult novels from 1993 to 1998. It does include the three Prometheus novels and the “Autobiography of…” (Kirk, Spock, Picard, Janeway) fiction books. (My base overall list was one I coopted from the internet and whoever made it, this is what was already there.) And, again, it does not include the individual enovellas, but it does include the print omnibus versions of (only) those.
My ebooks figures includes everything starting with Pocket Books (again, no Bantams or Ballantines), including the Prometheus and “Autobiography” books, and also includes the SCE/COE omnibuses (and also the Mere Anarchy omnibus) because those are available also in ebook. (But, again, not ebooks of other omnibuses like Odyssey, Twist of Fate, etc.)
So, my revised tallies:
I now have 431 out of 659 print Star Trek novels/fiction books (from the Pocket Books start onwards), which is 65%.
I now have 190 out of 727 Kindle ebook Star Trek novels/novellas/fiction books, which is 26%.
By my best calculations, I am currently at 199 out of 749 Star Trek novels or novellas that I do not have in either print or Kindle ebook format, which is 27%. (I included in this tally some novels that I know I bough back in 2004 to 2007, some I even have Amazon and other retailer records of having bought back then, but that have somehow disappeared into the void and are currently MIA. If I find those, I’ll make the appropriate updates.)
Just for funsies, here are the ten (make that eleven, since it gets me back to the start of 2017) most recent novels (not including The High Country and Somewhere to Belong because those two just came out) that I need ebooks of still (so that haven’t been in any recent monthly sales): To Lose the Earth (VOY) (2020), The Unsettling Stars (Kelvin) (2020), Architects of Infinity (VOY) (2018), Gamma: Original Sin (DS9) (2017), Rise of the Federation: Patterns of Interference (ENT) (2017), Engima Tales (DS9) (2017), Hearts and Minds (TNG) (2017), Section 31: Control (2017), The Long Mirage (DS9) (2017), Headlong Flight (TNG) (2017). Also The Autobiography of Mr. Spock and Jean-Luc Picard, and the three Prometheus novels (which Amazon would just have to put on sale).
— David Young