Skip to content

Utilties / scripts for taking time series wind data and itegrating turbine power curve to show energy output

Notifications You must be signed in to change notification settings

aprsworld/powerCurve

Repository files navigation

energyScenario.php table samplesPerHour year powerCurve

example: 
./energyScenario.php selawik 0.04166666666666666667 2014 2 > selawik.WT14.result
selawik is the table name
0.04166666666666666667 corresponds to 1 sample every 24 hours
2014 is the year we want to analyze
2 is the APRS World WT14 power curve


energyBar.php resultFile maxKWHonYAxis

example:
./energyBar.php selawik.WT14.result 10
selawik.WT14.result is the result file from energyScenario.php
10 means that 10 kWh is the maximum value of the y-axis (daily energy production)



MySQL table format:

mysql> use powerCurve;
Database changed

mysql> describe selawik;
+-------------+----------+------+-----+---------+-------+
| Field       | Type     | Null | Key | Default | Extra |
+-------------+----------+------+-----+---------+-------+
| packet_date | datetime | NO   | PRI | NULL    |       |
| windspeedMS | float    | NO   |     | NULL    |       |
+-------------+----------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql>

CREATE TABLE `selawik` (
	`packet_date` datetime NOT NULL,
	`windspeedMS` float NOT NULL,
	PRIMARY KEY (`packet_date`)
) ENGINE=MyISAM DEFAULT CHARSET=ascii COLLATE=ascii_bin;

Importing Data

./importTM2formattedCSV.php resolute.csv resolute | mysql -uroot -proadtoad powerCurve

Generating HTML index of graph outputs

./htmlIndexOfBars.php examples/resolute/hr3/ "Sample APRS World HR3 @ Resolute, Nunavut from 1995 TM2 Data" > examples/resolute/hr3/index.html

About

Utilties / scripts for taking time series wind data and itegrating turbine power curve to show energy output

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages