Electricity use

From MediaWiki

(Difference between revisions)
Jump to: navigation, search
(Current Calculation Method)
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 10,000 for the White House meter, as of 2015-11-01; see [[#Current Calculation Method]], below.)
+
;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 + Step 1 rate per kWH up to the Break number of kWH per day + Step 2 rate per kWH over the Break per day is the basic usage charge.

To this is added the Rate Rider which is the total of one or more additional costs, plus a Legacy meter fee, plus Tax on the total.

Daily rateStep 1 rateBreakStep 2 rateRate RiderLegacy meter feeTax
$0.2272$00$0.11320.00%$205.00%

Latest Meter Readings

You can also see Electricity use, historical meter photos.

YellowWhitePumpShopTrailer

Share your opinion


blog comments powered by Disqus
Environmental jobs, green volunteering, good work! Powered by the wind! This server and other
EcoReality operations
are 100% wind powered.
Powered by Mac OS X Powered by Mac MediaWiki Powered by MariaDB Powered by Valentina Studio Pro