You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('') and can be up to 35 characters long.
Tim
cc82270ee8

5 years ago  

elecparse.py  5 years ago  
plan_agl_flexy.csv  5 years ago  
plan_simply_energy.csv  5 years ago  
plan_tango_vic_home_standing.csv  5 years ago  
plan_tango_vic_home_standing_shoulders.csv  5 years ago  
readme.md  5 years ago  
usage_example.csv  5 years ago 
readme.md
Electricity Cost Calculation
I was sick of all the different constraints and calculating my bill
My current provider (AGL) allows me to download a CSV of all my data usage for the last 12 months at 30 minute incrementals. So using the data for the past 12 months we can calculate our quartly costs and cross check those totals to see if we would actually benefit from moving electricity companies.
Current Issues:
 Does not calculate discounts
 Does not do "summer/winter" rates
 You would need to create two rate plans, for that
First 11kWh is hard coded Fixed
How To:
Before we make a calculation we need to do two things:
 You need to create a matrix of the rates of the other companies you are trying to compare. See and of the provided
plan_
files for examples.  Format your data to the "Quarter" you want to check.
Create your "Plan":
 Columns are Days of Week, Starting from Monday > Sunday
 Rows are 1 hour periods, 0:00>0:59 first row, 23:00>23:59 last row
Format your data:
I used the following two commands to create quartly csv's and then ran it against each plan I was comparing.
head n 1 mydata.csv > mydata_2017_q1.csv
egrep 0[13]\/2017 mydata.csv >> mydata_2017_q1.csv
Help
usage: elecparse.py [h] datacsv DATA_CSV [ratescsv RATES_CSV]
[firstkwhrate FIRST_KWH_RATE]
[nextkwhrate NEXT_KWH_RATE] [firstkwh FIRST_KWH]
supplycharge SUPPLY_CHARGE [debug]
Electriciy CSV parser
optional arguments:
h, help show this help message and exit
datacsv DATA_CSV, c DATA_CSV
CSV Data File
ratescsv RATES_CSV, r RATES_CSV
Rates CSV Files
firstkwhrate FIRST_KWH_RATE, f FIRST_KWH_RATE
Starting rate for X kWh
nextkwhrate NEXT_KWH_RATE, n NEXT_KWH_RATE
Rate for after kWh
firstkwh FIRST_KWH, k FIRST_KWH
The X kWh variable
supplycharge SUPPLY_CHARGE, s SUPPLY_CHARGE
Daily Supply Cost (Cents)
debug Turn on Debugging
Usage Examples
Calculate the quarter cost of the rate "plan_plannyplan.csv"
./elecparse.py datacsv MyUsageData_2018_Q2.csv ratescsv plan_plannyplan.csv supplycharge 135.3
Do another calculation with short usage flags
./elecparse.py c MyUsageData_2018_Q2.csv r plan_simply_energy.csv s 124.289
Check a "First X kWh = 29.7c  Everything else = 33.33c"
./elecparse.py c MyUsageData_2018_Q2.csv f 29.7 n 33.33 s 135.3 k 11