Hello everyone!
The other day I was wondering what key and BPM combinations were missing or sparse in my collection, so I built a tool that can pull this out of the Engine Database file (and Traktor, and Rekordbox).
It visually presents the data as follows:
Go have a play if this interests you: KeyBpmMap Everything’s done in the browser, so nothing’s uploaded to the server.
Cheers, Sam
That looks like a interesting tool. Will try it out 
Really nice! Very straight forward and insightful, and looks good visually. May I suggest an option to export all the data to pdf?
Edit: rating doesn’t seem to work. It shows an average of 0.0 in my collection.
I would also like to have it in excel sheet 
I have added a pdf export option for the plots. Or were you talking about the entire page?
I have just tried the average rating for Engine, Traktor, and Rekordbox, and none of them were 0.0. What are you using?
If you want to convert your collection to an excel sheet then there’s probably better tools. However, I could do a simple export as CSV of the track list, which you can then open in Excel, if that helps?
Not the track list, but the results of the key vs bpm analysis, you showed here.
Thanks for your reply. Indeed I meant the whole page. Regarding the missing average rating, I press Load library file and import the m.db file from Engine 5.0.0. Interestingly enough, Engine itself reports 10068 tracks and the tool mentions 10048. Maybe it’s some missing files that are still in the library. 95 tracks in the collection are rated.
Edit: a friend of mine just tried it as well and has the same result. We both use Windows.
On Mac you can export pretty much any page to a PDF using the Print… dialog - does that not work on Windows? Or are you after a slightly tidier version that doesn’t show buttons etc in the PDF?
As for the weird library issue, do you have a GitHub account? If so, could you please open an issue on Issues · samsta/KeyBpmMap · GitHub and attach your db to it? Or email it to exams-than-7r@icloud.com if you don’t want to share it publicly. I can then have a look at what might be going wrong
Not sure what you mean, sorry. Do you mean a table where the columns are keys and rows are BPM or something?
Yes, you made already such matrix in one of your posts above, but only in colour. Looks good, though.
Ok, the heat map is now downloadable as a CSV which should open in Excel
I am traveling now till end of the week, I will dive in to that at Sunday afternoon, when I’m back at home. This is very interesting program, you made there 
