You have probably solved this problem, but TMY files can be easily generated with Meteonorm software. It a database with climate data all over the world. TMY3 files are in csv format and can be easily edited in Excel. I'm now trying to contact developers of EcoDesigner Star to find out what kind of wetaher data is required for EcoDesigner Star. That information can help to customize weather file in Excel.