How to Convert and Reformat NEM12 CSV Data

• How to Open Smart Meter Data in a Spreadsheet — Dealing with Semi-Structured Non-Tabular NEM12
• How to Import NEM12 CSV Smart Meter Data into Solar Design Tools: SolarProof, SolarPlus, Pylon and OpenSolar