UPDATE:
I found the macro excel tool on the WUFI website; its a simple input HOY data and hit convert to .wac tool. LB is going to be perfect for this and I am thrilled that additional interoporability with the software used to validate PHIUS builds is going to mean More time in the bug which is my preferred modus operandi.
the tool to convert HOY into different weather data file types can be found here:
https://wufi.de/en/wp-content/uploads/sites/11/CreateClimateFile.zip