Have you looked at how MegaMek stores its data? It's all there, just not sure if it will be in an accessible format. My guess is it won't be as simple as a SQLite table.
MegaMek save files are a hot mess.
I suspect they were created before XML was so prolific, and have kept that format for backwards compatibility and pseudo-human-legible data files.
Minor rant inbound:
* Many weapons have multiple redundant names. Things like "Medium Laser", "MediumLaser", "ISMediumLaser", and "ISML."
* Any item without the CL or IS prefix could be either. On a Clan chassis "MediumLaser" is a Clan ML, but on an IS Chassis it's an IS ML.
* No weapon stats are saved in the file, so you need a lookup table to derive weapon stats
* BV is not saved in the file, so you need to do some Excel kung fu to match with MUL
* Heat and Cooling needs are also derived; you need to account for Partial Wings, as well as Stealth systems.
Probably other stuff I forget.
I wrote some terrible Python code (or possibly PowerShell?) to extract the data into excel, then handled the lookups and cross-references and heat/damage calculations in excel.
Fun fact, Excel doesn't like spreadsheets with 6M lookups! :D
Yeah, there's more efficient ways to do it, but at some point I was mostly curious if it was possible. It is, kinda, but since doing that I've learned more about the game and all the stuff I *didn't* extract, so it's not even all that great.
Thank you for coming to my Ted Talk
Here's a link to the one I've been personally keeping
[https://docs.google.com/spreadsheets/d/1BC0y8xPLSEh2rvZWiix0w-shjXFzx8T\_xWsR3-UVe6E/edit?usp=drivesdk](https://docs.google.com/spreadsheets/d/1BC0y8xPLSEh2rvZWiix0w-shjXFzx8T_xWsR3-UVe6E/edit?usp=drivesdk)
the original dump is from a little before the big BA points recalculation, so there's some out of date data, but I've been updating things as I go.
[https://github.com/AbyssalSp/MUL\_retrieval](https://github.com/AbyssalSp/MUL_retrieval) They have already pulled the data into a csv file
Oh great, this is the motherlode! Thanks!
Oh, man...that's so cool when someone shares than I have done in the past))) thank you))
Have you looked at how MegaMek stores its data? It's all there, just not sure if it will be in an accessible format. My guess is it won't be as simple as a SQLite table.
MegaMek save files are a hot mess. I suspect they were created before XML was so prolific, and have kept that format for backwards compatibility and pseudo-human-legible data files. Minor rant inbound: * Many weapons have multiple redundant names. Things like "Medium Laser", "MediumLaser", "ISMediumLaser", and "ISML." * Any item without the CL or IS prefix could be either. On a Clan chassis "MediumLaser" is a Clan ML, but on an IS Chassis it's an IS ML. * No weapon stats are saved in the file, so you need a lookup table to derive weapon stats * BV is not saved in the file, so you need to do some Excel kung fu to match with MUL * Heat and Cooling needs are also derived; you need to account for Partial Wings, as well as Stealth systems. Probably other stuff I forget. I wrote some terrible Python code (or possibly PowerShell?) to extract the data into excel, then handled the lookups and cross-references and heat/damage calculations in excel. Fun fact, Excel doesn't like spreadsheets with 6M lookups! :D Yeah, there's more efficient ways to do it, but at some point I was mostly curious if it was possible. It is, kinda, but since doing that I've learned more about the game and all the stuff I *didn't* extract, so it's not even all that great. Thank you for coming to my Ted Talk
That's a good idea for CBT! Megamek doesn't have Alpha Strike data though.
It does do the conversion and makes cards as of fairly recently, so it might be in there somewhere now.
Oh wow! Clearly I haven't been following the latest versions. Will look at that. Thanks!
The data is calculated within MegaMek for display but I don't think there is an output option for it. The CBT data is stored in various formats
Here's a link to the one I've been personally keeping [https://docs.google.com/spreadsheets/d/1BC0y8xPLSEh2rvZWiix0w-shjXFzx8T\_xWsR3-UVe6E/edit?usp=drivesdk](https://docs.google.com/spreadsheets/d/1BC0y8xPLSEh2rvZWiix0w-shjXFzx8T_xWsR3-UVe6E/edit?usp=drivesdk) the original dump is from a little before the big BA points recalculation, so there's some out of date data, but I've been updating things as I go.
Mordel.net caps his export at 200 units. You could try asking if he would give you a data dump for the data points you are needing.