How To Guides
Step-by-Step How to Guides for energy-aware Homeowners, energy-aware Business Owners, solar designers, solar installers and energy professionals.
How to Work with Smart Meter Data in NEM12 CSV Format
Note: The How To Guides in this section specifically describe working with Australian Electricity Bills & Australian Smart Meter Data (typically in NEM12 CSV Format).
How to Access and Download NEM12 Smart Meter Data
How to Download Your Smart Meter Data
In Australia, Smart Meter Data from your Revenue Meter can be downloaded from a Web Portal or requested from your Electricity Distributor (or Electricity Retailer) typically in NEM12 CSV Format
Read How to Download Your Smart Meter Data ...
How to Choose NEM12 vs NEM13 Meter Data
NEM12 vs NEM13: NEM12 is interval smart meter data, NEM13 is accumulation data. Learn which meter data format to request from your DNSP or retailer.
Read How to Choose NEM12 vs NEM13 Meter Data ...
How to Find a Sample NEM12 File
Where to find a sample NEM12 file: download AEMO example and error files, GitHub parser samples, or a ready-made anonymised NEM12 CSV. Start testing today.
Read How to Find a Sample NEM12 File ...
How to Understand the Technical Details of NEM12 CSV
How to Understand the NEM12 CSV Format
A technical guide to the NEM12 interval meter data format: 100/200/300/400/900 record types, NMIConfiguration string, interval data rows, AEST timezone, quality flags (A/E/S/F/N), method flags, and common non-compliances in Australian DNSP customer portal exports.
Read How to Understand the NEM12 CSV Format ...
How to Avoid NEM12 CSV Data Gotchas
Avoid NEM12 CSV Format gotchas: AEMO record types, Excel and Google Sheets traps, NMI Suffix, E1/B1 registers, quality flags and AEST timezone pitfalls.
Read How to Avoid NEM12 CSV Data Gotchas ...
How to Convert and Reformat NEM12 CSV Data
How to Open NEM12 Data in a Spreadsheet
Why raw NEM12 CSV files do not open cleanly in Excel, Google Sheets or LibreOffice, and two solutions: use NEM12 Smart Meter Data Analyzer for instant browser-based charts, or convert your file to a clean wide or long format CSV for your own pivot table analysis.
Read How to Open NEM12 Data in a Spreadsheet ...
How to Import NEM12 CSV into Solar Design Tools
Import NEM12 CSV smart meter data into solar design tools: convert to clean wide or long format for SolarProof, SolarPlus, Pylon and OpenSolar. See how.
Read How to Import NEM12 CSV into Solar Design Tools ...
How to Analyze, Summarize and Visualize NEM12 Data
How to Analyse NEM12 Data in a Spreadsheet
Learn to analyse NEM12 smart meter data in a spreadsheet: separate E1 and B1 registers, build a pivot table in Excel or Google Sheets, and spot usage patterns.
Read How to Analyse NEM12 Data in a Spreadsheet ...
How to Interpret Your Smart Meter Data
What Meter Register codes E1, B1, E2, Q1 and K1 in your downloaded Smart Meter CSV mean, which one is your solar export, and which to select when uploading to PVOutput, OpenSolar or SolarPlus.
Read How to Interpret Your Smart Meter Data ...
How to Visualize NEM12 Data with Charts
Visualize NEM12 smart meter data with charts: pick a column, line, or stepped area chart and build a daily energy profile in your spreadsheet. Start here.
Read How to Visualize NEM12 Data with Charts ...
How to Extract Solar Export Data from NEM12
B1 is always the solar export register in a NEM12 CSV file. Learn how to extract solar export data from a raw file or a converted table — read the guide.
Read How to Extract Solar Export Data from NEM12 ...
How to Choose an Electricity Retailer and Tariff
How to Interpret Your Electricity Bill
Understanding the NMI, Meter Number and Meter Register Codes (E1, E2 & B1 ...) ... which one is your Hot Water Service ? which one your solar export ? ... And how to use information on your Electricity Bill to access Smart Meter Data ...
Read How to Interpret Your Electricity Bill ...
... Browse All How To Guides about:
How to Work with Smart Meter Data in NEM12 CSV Format
How to Setup an Energy-Efficient All Electric Home
How to Crunch the Numbers for an All-Electric Home
How to Calculate the Heating Load for Your Home
Use a heating load calculator to size your heating system correctly. Local climate data for Ballarat, Bendigo and the Central Highlands. Start here.
Read How to Calculate the Heating Load for Your Home ...
How to Understand Electricity Bills
How to Find My NMI on My Electricity Bill
How to find my NMI: locate your National Metering Identifier on your electricity bill or in your retailer portal, then check the digits are right.
Read How to Find My NMI on My Electricity Bill ...
How to Find My DNSP (Electricity Distributor)
How to find my DNSP: identify your electricity distributor on your bill, or run a DNSP lookup by NMI, suburb, or postcode. Start with your latest bill.
Read How to Find My DNSP (Electricity Distributor) ...
How to Choose Heating, Cooling and Air-Quality Appliances
Split Systems for Heating in Cool Climates
How to compare Home Split-System Air-Conditioners for Cool Climates - Comparison Table
Read Split Systems for Heating in Cool Climates ...
Comparing Ducted Air-Conditioners for Heating
Buyers guide to ducted air conditioner heating in cool climates: cold-zone ZERL stars, R32 refrigerant, inverter compressor, zoning and COP/HSPF compared.
Read Comparing Ducted Air-Conditioners for Heating ...
Ducted vs Split-System Air Conditioning
Cool-climate buyers guide to choosing between ducted and split-system air conditioning in Victoria — HSPF, COP, ZERL ratings, zoning, costs and brands.
Read Ducted vs Split-System Air Conditioning ...
Choose a Home Dehumidifier for Cool Climates
The Dry Mode on Reverse Cycle Air-Conditioners tends to slightly Cool and not Dehumidify very well during the Heating Season when Temperatures are already cool ... so you might consider a Standalone Home Dehumidifier ...
Read Choose a Home Dehumidifier for Cool Climates ...
How to Improve the Building Envelope
Honeycomb Blinds for Cool-Climate Homes
Buying Guide for Honeycomb Cellular Blinds for Cool-Climate Homes. If you live in the Cool Temperate Zone (like South Eastern Australia), your windows could be the weakest point in your thermal envelope
Read Honeycomb Blinds for Cool-Climate Homes ...
How to Get Off Gas Cooking
How to Choose a Portable Induction Cooktop
How To Compare Portable Induction Cooktops: What to look - Heating Capacity, Auto Shutoff, Power Limitations on Double Burner Models, ...
Read How to Choose a Portable Induction Cooktop ...