AGL app now showing Solar export

GLO
Conductor
2 Replies 37227 Views

I have found that the recent app update shows the solar export which is great to see.

 

is there any way I can get an export of both solar export and power import on a spreadsheet?

 

im trying to model what my export would be in winter with a larger system.

 

thanks

15 REPLIES 15
Schander
Stellar
1 Reply 12335 Views

Hi Dimitry,

 

Congrats on getting Solar. I reckon you've been on it for 2 weeks now. 

 

1) I seem to recall another post where someone indicated that the information is updated at a set interval (24 hours or something like that).  However, I couldn't locate the post.  I think that is why it always has yesterday's date.

 

2) I think there is something wrong if you are consuming from the grid while also feeding in the electricity from your panel. If you can post your CSV screenshot showing where that is the case, it would make it easier for the rest of the community to see what is happening.

 

The only thing I can figure is that the inverter needs to be configured correctly to offset your household consumption, then it feeds the excess energy to the grid. 

 

Hypothetically, you can feed some to the grid and receive from the grid in a 30 minute interval where it was sunny the first 5 minutes, you had an appliance kick on and then it was cloudy (drawing electricity from the grid), then the clouds disappeared 5 minutes later and your solar was offsetting the power in the house.  However, there is a netting effect which should take place at the smart meter (it is only receiving or delivering at any given time).  However, if this is happening very often, I would be suspicious of an inverter configuration issue.

 


If I’ve helped in anyway, please mark my post as SOLVED!
This helps our Community know the answer to common questions.
Dimitryp
Conductor
1 Reply 12327 Views

Hi Schnader,

 

  In regards to getting readings for both usage and export at the same time, i've had another look at the data, and it seems to happen a couple of times a day, and almost every morning, just when the solar is firing up.

Looks something like this:

 

Generalusage6/09/2019 04:306/09/2019 04:590.165
Solar6/09/2019 05:006/09/2019 05:290
Generalusage6/09/2019 05:006/09/2019 05:290.169
Solar6/09/2019 05:306/09/2019 05:590
Generalusage6/09/2019 05:306/09/2019 05:590.164
Solar6/09/2019 06:006/09/2019 06:290
Generalusage6/09/2019 06:006/09/2019 06:290.241
Solar6/09/2019 06:306/09/2019 06:590
Generalusage6/09/2019 06:306/09/2019 06:590.197
Solar6/09/2019 07:006/09/2019 07:290.002
Generalusage6/09/2019 07:006/09/2019 07:290.031
Solar6/09/2019 07:306/09/2019 07:590.009
Generalusage6/09/2019 07:306/09/2019 07:590.052
Solar6/09/2019 08:006/09/2019 08:290.186
Generalusage6/09/2019 08:006/09/2019 08:290.14
Solar6/09/2019 08:306/09/2019 08:590.598
Generalusage6/09/2019 08:306/09/2019 08:590
Solar6/09/2019 09:006/09/2019 09:290.852
Generalusage6/09/2019 09:006/09/2019 09:290
Solar6/09/2019 09:306/09/2019 09:591.259
Generalusage6/09/2019 09:306/09/2019 09:590
Solar6/09/2019 10:006/09/2019 10:291.756

 

Maybe something to do with low levels of solar being generated in the morning but high burst usage around that time from things like kettle and toaster being used. 

 

 

Schander
Stellar
1 Reply 12323 Views

Hi Dimitry,

 

Yes, these readings look relatively normal to me.  However, without the readings from your inverter, this gives an incomplete picture.  You need the following information:

1) Solar Power Generated (kWh) for the same time period.

2) Solar Power fed to Retailer (kWH) - Feed-in-Tariff (FiT) - which you have

3) Solar Power Consumed Internally (kWh) - The formula for this is (1) - (2) should give you a value

4) Solar Power Financial Benefit - The formula for this is [(3) x Peak Rate] + [(2) x FiT rate]

 

The answer to the above will confirm or explain what you are seeing and whether your solar panels are doing their job to offset your household consumption.

 

Regards,

 

Schander

 


If I’ve helped in anyway, please mark my post as SOLVED!
This helps our Community know the answer to common questions.
NeilC
Powerhouse
1 Reply 12007 Views

Shander

You mean something like this.

My billing Started 30 October

So two days carried forward.

Peak is GeneralUsage, Exported is Solar to Grid, Solar Gen is Panel Output, Used  is what I consumed in house from the Solar Panels, Meter is Peak Meter (E1) current reading and Solar is Meter B1 current reading.

 

DatePeakExportedSolar GenUsedMeter Solar
Carried Fwd6.11764.65874.4-9.7421446.0325073.271
1-Nov4.94520.38124.70-4.321450.9775093.652
2-Nov5.56021.24126.70-5.461456.5375114.893
3-Nov4.52523.76430.10-6.341461.0625138.657
4-Nov3.70625.99831.60-5.601464.7685164.655
5-Nov3.72729.12334.20-5.081468.4955193.778
6-Nov2.76232.23336.90-4.671471.2575226.011
7-Nov3.15120.09224.50-4.411474.4085246.103
8-Nov3.91826.64331.60-4.961478.3265272.746
9-Nov4.15829.68134.60-4.921482.4845302.427
10-Nov3.13633.60138.90-5.301485.6205336.028
11-Nov4.34627.39635.30-7.901489.9665363.424
12-Nov4.26723.92328.80-4.881494.2335387.347

 

I have two programs that I use to obtain this data. The first AGL2nem converts the MyUsageData_ file into industry standard NEM 12 format and the second MeterRead reads the Nem file.

Meter Read can create a CSV file with up to 31 Columns (with totals) that the user can designate to extract usage between two times in a day (say 00:00 to 04:00 or even 11:00 to 11:30).

 

NMI 20012345678   <-->   Meter #U290000999   <-->   NMI ID=B1   Interval Mins=30 
DATENMITYPED/Total00:00>06:0006:00>12:0012:00>18:0018:00>00:00
20191030B1Solar32.037013.77718.120.14
20191031B1Solar32.621014.50118.0560.064
20191101B1Solar20.381011.8838.4740.024
20191102B1Solar21.24106.63914.5270.075
20191103B1Solar23.76408.93514.7120.117
20191104B1Solar25.99809.03216.9110.055
20191105B1Solar29.123012.58216.4030.138
20191106B1Solar32.233014.4617.5620.211
20191107B1Solar20.09207.88112.1840.027
20191108B1Solar26.643011.43715.030.176
20191109B1Solar29.681011.38318.2380.06
20191110B1Solar33.601014.94218.540.119
20191111B1Solar27.396013.3114.0210.065
20191112B1Solar23.92309.6214.1840.119
Total:B1Solar378.7340160.382216.9621.39

 

NMI 20012345678   <-->   Meter #U290000999   <-->   NMI ID=E1   Interval Mins=30
DATENMITYPED/Total00:00>06:0006:00>12:0012:00>18:0018:00>00:00
20191030E1General2.8631.3530.02701.483
20191031E1General3.2541.4560.04401.754
20191101E1General4.9451.8870.03403.024
20191102E1General5.562.3480.860.0052.347
20191103E1General4.5252.5030.1150.021.887
20191104E1General3.7062.0290.0610.0021.614
20191105E1General3.7271.5990.02202.106
20191106E1General2.7621.5590.03501.168
20191107E1General3.1511.2340.04201.875
20191108E1General3.9181.940.01401.964
20191109E1General4.1581.9190.1530.0012.085
20191110E1General3.1361.1230.10401.909
20191111E1General4.3461.8450.08102.42
20191112E1General4.2671.7990.0740.1382.256
Total:E1General54.31824.5941.6660.16627.892

 

It also produces a text file with the same result for people that don't have a spreadsheet to read the CSV file

 

I have been trying to get someone to do user testing on the programs (Windows Only at the moment) to prove the concept and help with the documentation.

 

The output is shown for up to 10 Meters  individually. You can if you want ignore meters

Plenty of other options as well.

 

Programs are stand alone, so you can run on any drive including a usb stick.

 

If interested PM me (messages are two on the right from your user Icon on the top of your page) and I will send you an email address that you can communicate directly with me.

 

Cheers Neil

Cheers Neil


If this comment solves your issue please solve the post, if you like this comment please take the opportunity to click the Like button below.
Schander
Stellar
1 Reply 12004 Views

Hi NeilC,

 

Thanks for your response.  As I mentioned to the OP, the "value add" is the calculation. Your application does a good job with aggregating the transactional meter reading data into the summarised columns.  But if you could get it to analyse the information using the formula(s) I gave in my previous post, this would give the end-user the information they are after.

 

Regards,

 

Schander

 


If I’ve helped in anyway, please mark my post as SOLVED!
This helps our Community know the answer to common questions.
NeilC
Powerhouse
0 Replies 12000 Views

Schander,

 

My Programs produced the information for me to get the information that I first started with and is just a spreadsheet (ElectUsed.xls).

 

I take the data from MeterRead, put that into ElectUsed and then use that to supply my BillingCalculator that tells me what my next bill will be and how much I have to pay each fortnight.

 

Current Bill
No Discount (Estimate)
Supply $           74.70
Paper Bill $                  -  
Peak $         127.01
Off Peak $                  -  
Discount $                  -  
Total $         201.71
+GST $           20.17
  $          221.88
Solar Feed in $         494.24
Debit / Advance $                  -  
Total Payable-$        272.36
Payment Required Per Fortnight Pay on Time-$           39.00
Credit $          524.09
Cost Per Day-$              3.03

 

So as of Yesterday this is my projected bill due on the 28th January 2020.

As you can see I have a credit and my cost per day is MINUS $3.03 a day.

My same bill same period last year was $360 or ($3.90 a day) we had the solar installed 5 Dec 18 but did not get paid for any power generated in that bill.

 

My programs only convert the data from the AGL supplied MyUsageData_ file into actual easily read data.

 

How the individuals use that data is up to them.

 

If you get your daily usage (total of what used so far in this billing period, DIVIDED by the number of days) , then multiply it by actual number of days in you next bill you will get an fairly accurate figure for that meter).

If you then calculate the dollar amount for each meter add them all together add the cost of your supply charge you will have the dollar amount of your bill.

 

Which I believe is what most users would like to know.

 

I can also tell you other information about how much I have saved in the year since I had the solar installed, the fact that it will take me 2.731 years to recoop the cost of the install.

 

So I am 31 days into my Bill and have produced 851.196Kw back into the grid ($174.24), consumed 115.375 Kw ($47.31) from the grid and used 167.204 Kw power that I generated which is free from the sun and really does not have any value (I lost $33.44 from generation or saved $68.55 from grid charges).

Well that is not quite true as most of that 167.204 kw is used to heat my hot water (a FREE HEAT PUMP system from the Government)

So my daily usage is 3.7 Kw that I pay for, I used 5.4 Kw a day from my panels, the hot water consumes about half of that (2.7 Kw) which is a saving from the 4.5 Kw a day for the old off peak storage heater I had before.

 

But in reality all that matters is that my winter bills dropped from $460 for my winter bill last year to $260 this year (Saved $200 in one three month period), we did not have many sunny days this winter

 

By the way we are an all electric house have a small wood heater and that's all. Being in SA we get charged 40c a KW for usage and get 20c a Kw for supply to the Grid. We also get charged 91c a day for supply charges.

 

Cheers

Neil

 

 

Cheers Neil


If this comment solves your issue please solve the post, if you like this comment please take the opportunity to click the Like button below.