Net metering, am I producing or selling?
-
- Posts: 57
- Joined: Mon Apr 20, 2015 3:37 pm
- Location: New Brunswick
Net metering, am I producing or selling?
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.
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.
- Attachments
-
- Settings - Google Chrome 3172023 11339 PM.jpg (328.97 KiB) Viewed 13213 times
-
- Settings - Google Chrome 3172023 11257 PM.jpg (244.76 KiB) Viewed 13213 times
-
- Channels - Google Chrome 3172023 11403 PM.jpg (239.42 KiB) Viewed 13213 times
-
- Site Admin
- Posts: 4269
- Joined: Fri Jun 04, 2010 9:39 am
Re: Net metering, am I producing or selling?
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
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
Ben
Brultech Research Inc.
E: ben(at)brultech.com
Brultech Research Inc.
E: ben(at)brultech.com
-
- Posts: 57
- Joined: Mon Apr 20, 2015 3:37 pm
- Location: New Brunswick
Re: Net metering, am I producing or selling?
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
Thanks,
Nathan
-
- Posts: 57
- Joined: Mon Apr 20, 2015 3:37 pm
- Location: New Brunswick
Re: Net metering, am I producing or selling?
Actually one other question, is it possible to reorder the channels virtually, without touching the CTS or gem?
-
- Site Admin
- Posts: 4269
- Joined: Fri Jun 04, 2010 9:39 am
Re: Net metering, am I producing or selling?
On the Channels page? Not currently, they go in order of the channel number.
Ben
Brultech Research Inc.
E: ben(at)brultech.com
Brultech Research Inc.
E: ben(at)brultech.com
-
- Posts: 57
- Joined: Mon Apr 20, 2015 3:37 pm
- Location: New Brunswick
Re: Net metering, am I producing or selling?
Okay thanks, I had tried looking through the interface for this and couldn't find it. Thanks for confirming. Nathan
-
- Posts: 57
- Joined: Mon Apr 20, 2015 3:37 pm
- Location: New Brunswick
Re: Net metering, am I producing or selling?
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.ben wrote: ↑Fri Mar 17, 2023 12:17 pmIn 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
Thanks Nathan
-
- Site Admin
- Posts: 4269
- Joined: Fri Jun 04, 2010 9:39 am
Re: Net metering, am I producing or selling?
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):
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 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;
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);
Ben
Brultech Research Inc.
E: ben(at)brultech.com
Brultech Research Inc.
E: ben(at)brultech.com
-
- Posts: 57
- Joined: Mon Apr 20, 2015 3:37 pm
- Location: New Brunswick
Re: Net metering, am I producing or selling?
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!
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!
- Attachments
-
- Chrome Legacy Window 3222023 112503 PM.bmp.jpg (280.76 KiB) Viewed 13184 times
-
- Site Admin
- Posts: 4269
- Joined: Fri Jun 04, 2010 9:39 am
Re: Net metering, am I producing or selling?
You can also just regenerate billing under Settings->Billing. It'll backtrack thru all the hour/day records.nbarnard wrote: ↑Wed Mar 22, 2023 9:33 pmThanks 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
Brultech Research Inc.
E: ben(at)brultech.com
Brultech Research Inc.
E: ben(at)brultech.com