Net metering, am I producing or selling?

[nbarnard]

Hi guys, I have question about how DB site is showing the consumption/production on the top toolbar (beside the meter image). I have recently installed a grid-tied inverter system so current is going both ways, however this doesn't appear to be shown on this blue bar. Is it possible to have this show if I am net producing of consuming? I also have a green bar which is showing the output of my inverter (it is only one way), but mains are flowing in both directions, depending on sun out or not. I would like to see blue top bar showing positive if I am purchasing power, and credit if I am selling power to grid.

See attached for settings for CTs. Also it is public IP if you can check it out. At a glance I don't know if I have bought or sold the 0.999kWh of electricity.

[ben]

In DashBox Settings under Energy Monitors when the NET option is selected, it'll create a new channel for each selected channel that will do NET Metering. These channels are at the bottom of the channel list.

What you likely want is:

Main L1 - Net, Hide
Main L2 - Net, Hide
GridInverter - Net, Hide

Main L1 Gen - Main
Main L2 Gen - Main
GridInverter Gen - Inverter

[nbarnard]

Thanks Ben! You're the best! Excellent support, this is exactly what I was looking for! I didn't understand how those checkboxes worked

Thanks,
Nathan

[nbarnard]

Actually one other question, is it possible to reorder the channels virtually, without touching the CTS or gem?

[ben]

Actually one other question, is it possible to reorder the channels virtually, without touching the CTS or gem?

On the Channels page? Not currently, they go in order of the channel number.

[nbarnard]

Actually one other question, is it possible to reorder the channels virtually, without touching the CTS or gem?

On the Channels page? Not currently, they go in order of the channel number.

Okay thanks, I had tried looking through the interface for this and couldn't find it. Thanks for confirming. Nathan

[nbarnard]

In DashBox Settings under Energy Monitors when the NET option is selected, it'll create a new channel for each selected channel that will do NET Metering. These channels are at the bottom of the channel list.

What you likely want is:

Main L1 - Net, Hide
Main L2 - Net, Hide
GridInverter - Net, Hide

Main L1 Gen - Main
Main L2 Gen - Main
GridInverter Gen - Inverter

Is it possible to go back and repopulate the data after having changed channel types to net and creating the gen channels? My monthly consumption now shows empty prior to making the change.

Thanks Nathan

[ben]

Is it possible to go back and repopulate the data after having changed channel types to net and creating the gen channels? My monthly consumption now shows empty prior to making the change.

Thanks Nathan

You can do this directly to the database.

- Set a password for the backup user under Settings->System->Backup Settings
- Download DBeaver https://dbeaver.io/

Go to Database->New Connection, select PostgreSQL

Should look like (where password is your password):

conn.png (20.26 KiB) Viewed 13194 times

Go to the DashBox, Channels section. Click on Main L1, write down the c1=#### number. Click Main L1 Gen, write down that number too. Repeat for all 4 channels

Back in DBeaver, these should backfill:

Code: Select all

insert into hourdata (channel_id, date, wattsecond, watt, kwh seconds, cost, totalcost, amps, peakwatt, minwatt)
select '4444', date, wattsecond, watt, kwh seconds, cost, totalcost, amps, peakwatt, minwatt  from hourdata where channel_id = 5555 and date < (select min(date) from hourdata where channel_id = 4444);

Code: Select all

insert into daydata(channel_id, date, num_rec, kwh, totalcost, min_watt, max_watt, avg_watt)
select '4444', date, num_rec, kwh, totalcost, min_watt, max_watt, avg_watt from daydatawhere channel_id = 5555 and date < (select min(date) from daydata where channel_id = 4444);

Replace all 4444s with Main L1 Gen number
Replace 5555s with Main L1 number

Minutedata is a bit more of a pain, in the left navigator expand Databases, brultech_dash, public, Tables. You'll have a bunch of tables labelled "minutedataXXXX-YY-ZZ", this has to be done for each table.

For all but the day you started logging the Gens

Code: Select all

insert into "minutedata2015-03-06" (channel_id, date, watt, kwh, totalcost, amps, peakwatt, minwatt)
select '4444', date, watt, kwh, totalcost, amps, peakwatt, minwatt from "minutedata2015-03-06" where channel_id = 5555;

Day you started logging:

Code: Select all

insert into "minutedata2015-03-06" (channel_id, date, watt, kwh, totalcost, amps, peakwatt, minwatt)
select '4444', date, watt, kwh, totalcost, amps, peakwatt, minwatt from "minutedata2015-03-06" where channel_id = 5555 and date < (select min(date) from "minutedata2015-03-06" where channel_id = 4444);

[nbarnard]

Thanks Ben, very cool how that is setup, and how I can access the DB! I've updated the channel numbers in hourdata and daydata. However I am trying to fix the missing $ data for before Mar 6th, when viewing monthly period. See attached pic. Also the totalcost column is always nul or empty. Please advise.

UPDATE this seems to fix it:
insert into rate_3_day (channel_id, rateday_id, totalcost , "date" ,ref_id )
select 2209, rateday_id, totalcost , "date" ,ref_id from rate_3_day where channel_id = 2161 and date < (select min(date) from rate_3_day rd where channel_id = 2209);

ALSO UPDATED rate_3_hour, let me know if I should do anything else please. Love the DB/app design Ben!

[ben]

Thanks Ben, very cool how that is setup, and how I can access the DB! I've updated the channel numbers in hourdata and daydata. However I am trying to fix the missing $ data for before Mar 6th, when viewing monthly period. See attached pic. Also the totalcost column is always nul or empty. Please advise.

UPDATE this seems to fix it:
insert into rate_3_day (channel_id, rateday_id, totalcost , "date" ,ref_id )
select 2209, rateday_id, totalcost , "date" ,ref_id from rate_3_day where channel_id = 2161 and date < (select min(date) from rate_3_day rd where channel_id = 2209);

ALSO UPDATED rate_3_hour, let me know if I should do anything else please. Love the DB/app design Ben!

You can also just regenerate billing under Settings->Billing. It'll backtrack thru all the hour/day records.