RegGuheert
Well-known member
Well, the Grid-Tied Solar & Battery Calculator is taking shape. I don't have the output calculations completed, yet, but I think the page for user input is in pretty good shape now. Unfortunately, it is VERY slow, so please be patient as you make entries in the form. All of the YELLOW cells should be accessible to you.
Here are my current thoughts on how I would like to structure it. Please give me your thoughts on these ideas and also let me know if you can provide a one-year hourly dataset of either PV production or your home's consumption or both that can be used in the spreadsheet.
(Please note that Google Sheets are limited to 2 million TOTAL cells, so that severely constrains the number of year-long hourly datasets I will be able to include given the number of calculations I need to make on each entry. I will try to optimize the flow to allow for the most entries possible.)
Assumptions:
- TVM is zero. (I don't think it is reasonable to try to estimate all of these things: future TVM, future electricity costs, future PV costs, future battery costs, so I will leave them all out and leave them up to your imagination.)
The user entry fields I intend to provide are:
- Dataset to use for home consumption (select from a list)
- Dataset to use for photovoltaic production (select from a list)
- Total Annual Consumption (kWh)
- Local electricity rates (sorry, no base rates, graduated rates or time-of-use metering for now)
- Monthly electricity connection fee
- Total Solar Installed (kWp(DC))
- Installed cost for solar per kWp(DC)
- Solar equipment lifetime (years)
- Number of Enphase AC Batteries (-)
- Installed cost per Enphase AC Battery (US$)
- Enphase AC Battery lifetime (years)
- Number of Tesla Powerwall 2 Batteries (-)
- installed cost per Tesla Powerall 2 Battery (US$)
- Tesla Powerwall 2 Battery lifetime (years)
- Initial charge contained in batteries (%)
- Capacity of other batteries installed (kWh)
- Power capability of other batteries installed (kW)
- One way energy efficiency of other batteries (kW)
- Installed cost per kWh of other batteries installed (US$/kWh)
- Other battery lifetime (years)
The results provided will include:
- Total installed cost for photovoltaics (US$)
- Total installed cost for batteries (US$)
- Total installed cost for both photovoltaics and batteries (US$)
- Total usable battery capacity (kWh)
- Total available battery power capability (kW)
- Total annual electricity consumed from the grid (kWh)
- Cost of all electricity consumed in the absence of net metering (sum of grid costs, photovoltaics and batteries) (US$)
- Overall per-kWh cost of electricity consumed from the grid. (US$/kWh)
- Total annual kWh NOT consumed from the grid due to photovoltaics (kWh)
- Total per-kWh cost of electricity NOT consumed from the grid due to photovoltaics (US$/kWh)
- Marginal per-kWh cost of electricity NOT consumed from the grid due to photovoltaics (US$/kWh)
- Total annual kWh NOT consumed from the grid due to batteries (kWh)
- Total per-kWh cost of annual electricity NOT consumed from the grid due to batteries (US$/kWh)
- Marginal per-kWh cost of annual electricity NOT consumed from the grid due to batteries (US$/kWh)
- Total annual electricity put onto the grid
- NET annual electricity consumed from the grid (kWh)
- Cost of NET electricity consumed in the presence of net metering (sum of grid costs, photovoltaics and batteries)
- Overall per-kWh cost of NET electricity consumed from the grid.
- Total annual NET kWh NOT consumed from the grid due to photovoltaics (kWh)
- Total per-kWh cost of NET electricity NOT consumed from the grid due to photovoltaics (US$/kWh)
- Marginal per-kWh cost of NET electricity NOT consumed from the grid due to photovoltaics
- Total annual NET kWh NOT consumed from the grid due to batteries (kWh)
- Total per-kWh cost of NET electricity NOT consumed from the grid due to batteries (US$/kWh)
- Marginal per-kWh cost of NET electricity NOT consumed from the grid due to photovoltaics
Here are my current thoughts on how I would like to structure it. Please give me your thoughts on these ideas and also let me know if you can provide a one-year hourly dataset of either PV production or your home's consumption or both that can be used in the spreadsheet.
(Please note that Google Sheets are limited to 2 million TOTAL cells, so that severely constrains the number of year-long hourly datasets I will be able to include given the number of calculations I need to make on each entry. I will try to optimize the flow to allow for the most entries possible.)
Assumptions:
- TVM is zero. (I don't think it is reasonable to try to estimate all of these things: future TVM, future electricity costs, future PV costs, future battery costs, so I will leave them all out and leave them up to your imagination.)
The user entry fields I intend to provide are:
- Dataset to use for home consumption (select from a list)
- Dataset to use for photovoltaic production (select from a list)
- Total Annual Consumption (kWh)
- Local electricity rates (sorry, no base rates, graduated rates or time-of-use metering for now)
- Monthly electricity connection fee
- Total Solar Installed (kWp(DC))
- Installed cost for solar per kWp(DC)
- Solar equipment lifetime (years)
- Number of Enphase AC Batteries (-)
- Installed cost per Enphase AC Battery (US$)
- Enphase AC Battery lifetime (years)
- Number of Tesla Powerwall 2 Batteries (-)
- installed cost per Tesla Powerall 2 Battery (US$)
- Tesla Powerwall 2 Battery lifetime (years)
- Initial charge contained in batteries (%)
- Capacity of other batteries installed (kWh)
- Power capability of other batteries installed (kW)
- One way energy efficiency of other batteries (kW)
- Installed cost per kWh of other batteries installed (US$/kWh)
- Other battery lifetime (years)
The results provided will include:
- Total installed cost for photovoltaics (US$)
- Total installed cost for batteries (US$)
- Total installed cost for both photovoltaics and batteries (US$)
- Total usable battery capacity (kWh)
- Total available battery power capability (kW)
- Total annual electricity consumed from the grid (kWh)
- Cost of all electricity consumed in the absence of net metering (sum of grid costs, photovoltaics and batteries) (US$)
- Overall per-kWh cost of electricity consumed from the grid. (US$/kWh)
- Total annual kWh NOT consumed from the grid due to photovoltaics (kWh)
- Total per-kWh cost of electricity NOT consumed from the grid due to photovoltaics (US$/kWh)
- Marginal per-kWh cost of electricity NOT consumed from the grid due to photovoltaics (US$/kWh)
- Total annual kWh NOT consumed from the grid due to batteries (kWh)
- Total per-kWh cost of annual electricity NOT consumed from the grid due to batteries (US$/kWh)
- Marginal per-kWh cost of annual electricity NOT consumed from the grid due to batteries (US$/kWh)
- Total annual electricity put onto the grid
- NET annual electricity consumed from the grid (kWh)
- Cost of NET electricity consumed in the presence of net metering (sum of grid costs, photovoltaics and batteries)
- Overall per-kWh cost of NET electricity consumed from the grid.
- Total annual NET kWh NOT consumed from the grid due to photovoltaics (kWh)
- Total per-kWh cost of NET electricity NOT consumed from the grid due to photovoltaics (US$/kWh)
- Marginal per-kWh cost of NET electricity NOT consumed from the grid due to photovoltaics
- Total annual NET kWh NOT consumed from the grid due to batteries (kWh)
- Total per-kWh cost of NET electricity NOT consumed from the grid due to batteries (US$/kWh)
- Marginal per-kWh cost of NET electricity NOT consumed from the grid due to photovoltaics