About NeilC

Rank: Superconductor

Learn more about ranks and badges.

NeilC's latest conversations

NeilC Superconductor
19-05-2019

Re: Program to analse smart meter data.

Hi again SC,Adding more to my post.So once I have added the data to the sheet I get a few things.I get my updated Peak Meter reading, updated Solar Output reading.I can also get the generated amount from my Solar inverter and use this to get more Statistics.I used 3.99Kw during the time that I was generating power that day (6th), this is what I used to heat my hotwater and run my household. This means I actually saved 22*$0.2 ($4.40) and 4*$.04 ($1.60) or $6.00 that day, by having solar power o ...
Solved 13 Replies 1 Like
NeilC Superconductor
19-05-2019

Re: Program to analse smart meter data.

Hi SC,Once you have logged into your account.Click on usage.Then click on "GO TO ELECTRICITY & SOLAR USAGE"You will then see details for your weekly use. You can hover over each day and see your usage.At the bottom of the screen you can see a "Download Usage Data" button.Click on that and the below box will pop up.You can then open the file (you will need access to a spreadsheet programme) or save this. This is the complete list of your meter readings for every half hour and generally is not us ...
Solved 13 Replies 1 Like
NeilC Superconductor
Sunday

Re: Discrepancy between solar inverter power generation and the AGL app

Kim,I am fairly new to AGL and in fact have just completed my first billing cycle with AGL and 16 days into my 2nd.Now I was very disappointed that my bill was FOUR cents out from what I calculated.I have a spreadsheet that I fill out daily using the CSV supplied by either my Electricity Supplier or the horrible AGL csv file.AGL do not supply in NEM format but SA Power Networks supplies the data in NEM format but do not always get the correct data. So I have to add offsets into my programme to a ...
4 Replies 0 Likes
NeilC Superconductor
Sunday

Re: Program to analse smart meter data.

Hi,Just to update I have now created a program to automatically convert the AGLUsage.csv file into NEM format. (AGL2nem)This allows you to import the data into my MeterRead program.Which in turn allows you to view your daily usage and current Smart Meter readingsResult reports produced in Report.csv and Report.txt.Below is Report.CSV file. I deleted the report section for Controlled Load as I do not use itThe program does report it see the TXT file under this....Above is the Report.Txt file incl ...
13 Replies 1 Like