You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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