[WIP][Tool] Generate Master Parts Spreadsheet - I'm making one - Help?

[Black-Talon]

Edit: See second post - after no response I decided to make a tool to generate a spreadsheet of parts from the config files - but I could use some guidance/motivation in the development of the tool (C#) - thanks!!

Does anyone have or use a tool to generate a spreadsheet of parts with the config values?

Over the last couple years I've diffed (using Beyond Compare which everyone should have handy) every version released, noted changes, made many versions of my own spreadsheet, made a terrible tool to generate my own spreadsheet from the part.cfg's, and I think quite awhile back there was a tool someone else made that attempted this a bit by viewing the config in a table. Anyway, when 0.24 came out this was shared: http://forum.kerbalspaceprogram.com/threads/86406-Stock-Parts-Costs-and-Balance-Spreadsheet-for-0-24 and at the time I thought, "gosh, I guess we all make these spreadsheets but surprisingly haven't made a tool to create them?"

All was well and good until 0.25 came out and once again I'm looking for a comparison of parts, both to old KSP versions, of mods, etc. In addition the folder/file/name of all the parts was changed (thankfully!) making it much more difficult to do a straight folder to folder compare and see any changes between 0.24 and 0.25.

Point is, anyone have a tool to generate these and save everyone making these sheets all some time? :-) Thanks!

Edited December 1, 2014 by Black-Talon

[Black-Talon]

Ok - I made one in C# - it's barely usable at the moment. For me personally, the homemade tool and some manual work in Excel will put me further ahead at this task than I've ever been. I'd welcome your courteous criticism suggesting a better solution!

I'm ashamed to admit how much harder it was for me to get this far (rusty in development is an understatement!!) - is anyone interested in telling me how I'm terrible at writing code and in turn help me make it useful for others? I'm not talking about testers; I'm looking for someone willing to look at my hacked together code and giving advice on how to organize it and constructively build upon it. EVERYTHING is currently wrong with it but I'm so rusty having someone with more experience giving me direction would help tremendously.

https://www.dropbox.com/s/ubyx5zlqmhsy8yt/KSP_Parts.csv?dl=0

The extremely kludgy output as it is raw from the code - many improvements can/need to be made! Note that I have no idea what version of KSP or mods this was run against, it was just a ton of test data.

-Talon