# Electricity use

### From MediaWiki

Jan Steinman (Talk | contribs) (→Current Calculation Method) |
Jan Steinman (Talk | contribs) |
||

Line 7: | Line 7: | ||

;Date: the date of the meter reading. | ;Date: the date of the meter reading. | ||

;Days: the number of days between meter readings. | ;Days: the number of days between meter readings. | ||

- | ;Yellow, White, Pump, Shop: the reading from the appropriate meter. (Plus | + | ;Yellow, White, Pump, Shop: the reading from the appropriate meter. (Plus 200,000 for the White House meter, as of 2015-11-01; see [[#Current Calculation Method]], below.) |

;Yellow $, White $, Pump $, Shop $: the cost of electricity consumed, according to the BC Hydro billing formula, as outlined below. | ;Yellow $, White $, Pump $, Shop $: the cost of electricity consumed, according to the BC Hydro billing formula, as outlined below. | ||

;White-: the total cost from the White House meter, minus one half of the cost from the pump meter, minus the cost from the shop meter. | ;White-: the total cost from the White House meter, minus one half of the cost from the pump meter, minus the cost from the shop meter. |

## Revision as of 23:44, 28 March 2020

Currently (as of 31 May 2012), the co-op is paying for all the electricity on site, and residents of the white house reimburse EcoReality for actual electricity used, based on the BC Hydro calculation method, less the amount used by the garage and one-half of the amount used by the pump house, as recorded by separate meters on the east side of the white house.

In October 2008, EcoReality installed two additional electric meters near the northeast corner of the white house, to measure electricity being used by the pump house and the green building, respectively. At that time, the yellow house began reimbursing the white house for one-half of the electricity used by the pump house, and for all of the electricity used by the green building.

In the table below:

- Date
- the date of the meter reading.
- Days
- the number of days between meter readings.
- Yellow, White, Pump, Shop
- the reading from the appropriate meter. (Plus 200,000 for the White House meter, as of 2015-11-01; see #Current Calculation Method, below.)
- Yellow $, White $, Pump $, Shop $
- the cost of electricity consumed, according to the BC Hydro billing formula, as outlined below.
- White-
- the total cost from the White House meter, minus one half of the cost from the pump meter, minus the cost from the shop meter.

# Records

**Error while executing input SQL:**

SELECT x.`Date`, @Days := DATEDIFF(x.`Date`, x.prev_d) AS Days, FORMAT(Yellow, 0) AS `Yellow`, CONCAT('$', FORMAT(@Yellow_cost := calculate_electric_bill(@Days, Yellow - x.prev_y, x.Daily_rate, x.Step1, x.Break, x.Step2, x.Riders, x.Tax, Legacy_meter_fee), 2)) AS `Yellow $`, FORMAT(White, 0) AS `White`, CONCAT('$', FORMAT(@White_cost := calculate_electric_bill(@Days, IF(x.`Date` = '2015-11-01', (White - 119093) + (84803 - x.prev_w), White - x.prev_w), x.Daily_rate, x.Step1, x.Break, x.Step2, x.Riders, x.Tax, Legacy_meter_fee), 2)) AS `White $`, FORMAT(Pump, 0) AS `Pump`, CONCAT('$', FORMAT(@Pump_cost := calculate_electric_bill(@Days, Pump - x.prev_p, x.Daily_rate, x.Step1, x.Break, x.Step2, x.Riders, x.Tax, 0), 2)) AS `Pump $`, FORMAT(Shop,0) AS `Shop`, CONCAT('$', FORMAT(@Shop_cost := calculate_electric_bill(@Days, Shop - x.prev_s, x.Daily_rate, x.Step1, x.Break, x.Step2, x.Riders, x.Tax, 0), 2)) AS `Shop $`, FORMAT(Trailer,0) AS `Trailer`, CONCAT('$', FORMAT(@Trailer_cost := calculate_electric_bill(@Days, Trailer - x.prev_t, x.Daily_rate, x.Step1, x.Break, x.Step2, x.Riders, x.Tax, 0), 2)) AS `Trailer $`, CONCAT('$', FORMAT(@White_net := @White_cost - (@Pump_cost / 2) - @Shop_cost, 2)) AS `White-` FROM (SELECT e.*, (SELECT MAX(d.`Date`) FROM s_electricity_use d WHERE d.`Date` < e.`Date`) prev_d, (SELECT MAX(y.Yellow) FROM s_electricity_use y WHERE y.Yellow < e.Yellow) prev_y, (SELECT MAX(w.White) FROM s_electricity_use w WHERE w.White < e.White) prev_w, (SELECT MAX(p.Pump) FROM s_electricity_use p WHERE p.Pump < e.Pump) prev_p, (SELECT MAX(s.Shop) FROM s_electricity_use s WHERE s.Shop < e.Shop) prev_s, (SELECT MAX(t.Trailer) FROM s_electricity_use t WHERE t.Trailer < e.Trailer) prev_t FROM s_electricity_use e) x ORDER BY x.`Date` DESC LIMIT 0,12

## Current Calculation Method

- Meters were not read at the beginning of January 2020. Data for 1 January 2020 is interpolated between the previous and next readings. Dollar differences between the two is because of the day rate.
- On 4 December 2018, the Yellow House meter was replaced. The last reading on the old meter was 46,346, and the first reading on the new meter was 0. So the billing for 2019-01-10 should be for $240.21. This is a one-time inaccuracy in the table; future readings should be correct, based on the new meter. (In order to maintain monotonicity, a '2' is prepended to new meter readings.)
- On 4 December 2018, the White House meter was replaced. The last reading on the old meter was 97,083, and the first reading on the new meter was 45,036. So the billing for 2019-01-10 should be for $355.80. This is a one-time inaccuracy in the table; future readings should be correct, based on the new meter. (In order to maintain monotonicity, a '2' is prepended to new meter readings.)
- On 23 October 2015, the White House meter was replaced. The last reading on the old meter was 84,803, and the first reading on the new meter was 19,093. So the billing for 2015-11-01 should be for 1,193 kWh or $165.85 total. This is a one-time inaccuracy in the table; future readings should be correct, based on the new meter. (In order to maintain monotonicity, a '1' is prepended to the new meter reading.)
- As of 6 September 2015, we have been granted the special farm rate, after a year of wrangling. It is a flat rate, eliminating the stepped rate used for households.
- As of 18 November 2014, BC Hydro is extorting a legacy meter fee by cutting off our power. (We had been deducting that fee from our payment since January 2014, including a dispute letter with each payment.) The "legacy meter fee" is included in the historical data above beginning on 2014-12-01.
- All BC Hydro rates went up on 1 April 2014, and the following reflects rates as of that day.

* Daily rate* per day +

*per kWH up to the*

**Step 1 rate***number of kWH per day +*

**Break***per kWH over the*

**Step 2 rate***per day is the basic usage charge.*

**Break**To this is added the * Rate Rider* which is the total of one or more additional costs, plus a

*plus*

**Legacy meter fee,***on the total.*

**Tax**Daily rate | Step 1 rate | Break | Step 2 rate | Rate Rider | Legacy meter fee | Tax |

$0.2272 | $0 | 0 | $0.1132 | 0.00% | $20 | 5.00% |

## Latest Meter Readings

You can also see Electricity use, historical meter photos.

Yellow | White | Pump | Shop | Trailer |