2013: DMITRE

This programming project involved the creation of an access database that can view historical data of power generation sites. 10 different remote power generation sites can be compared in terms of period generation, load duration, fuel efficiency, phase loading and daily maximum and minimum. These Access forms were created using SQL statements and the data for each site is parsed and imported using custom Visual Basic programs. During the parsing phase of the data importation, extra values are derived such as power generation to ensure that he database runs quickly.

An example of some of the SQL statements created are:

If GraphResolutionCbo = "Minute(s)" Then
    
SQLString = "SELECT (Format([PC Time],'" & DateFormat1 & "')),Avg([Total Power]) AS [AvgOfTotal Power], Avg([Total Fuel Flow])" & _
 "AS [AvgOfTotal Fuel Flow], Avg([INVFF]) As [AvgOf INVFF] " & _
 "FROM " & SiteNameFuelPower & " GROUP BY (Int([PC Time]*1440)),(Format([PC Time],'" & DateFormat1 & "'));"
      
ElseIf GraphResolutionCbo = "Hour(s)" Then
    
SQLString = "SELECT (Format([PC Time],'" & DateFormat2 & "')),Avg([Total Power]) AS [AvgOfTotal Power], Avg([Total Fuel Flow])" & _
 "AS [AvgOfTotal Fuel Flow], Avg([INVFF]) As [AvgOf INVFF] " & _
 "FROM " & SiteNameFuelPower & " GROUP BY (Int([PC Time]*24)),(Format([PC Time],'" & DateFormat2 & "'));"

An example of some Access forms created are:

Period Generation Example (Reduced to 75% original height)
Period Generation Example (Reduced to 75% original height)
Fuel Efficiency Example (Reduced to 75% original height)
Fuel Efficiency Example (Reduced to 75% original height)
Maximum and Minimum Daily Power Output (Reduced to 75% original height)
Maximum and Minimum Daily Power Output Example(Reduced to 75% original height)
Specific Fuel Efficiency Example (Reduced to 75% original height)
Specific Fuel Efficiency Example (Reduced to 75% original height)
Load Curve Example (Reduced to 75% original height)
Load Curve Example (Reduced to 75% original height)