Intro
This website exists because I need online triggers for some of my projects. If other ideas will appear in my head, I can make them work in here, in future. In the meantime, enjoy the emptiness.
Work
Professional
from-tkgm-to-kmz: The intention of the tool is
to provide direct conversion of parselsorgu coordinates to .kmz files to be read over
Google Earth software.
autoDataCollector: A desktop project that
uses cronjob and imports datas to company DB after getting them from private APIs.
ALEN Market App: A C# desktop app that
vizualizes datas which are gathered by autoDataCollector in according to Energy Trading Team needs.
Daily Price Analyzer: A C# desktop app that
summarizes the market prices on daily basis and sends the report as pdf.
EnerjiREST: An application written in JS to
publish datas from company database to HTTP. The data which is gathered from powerplants are
going public over this REST API.
Power Plant Monitoring Web App: A React Web app that gets
its input data from EnerjiRest.
DSI AGI Converter: A desktop application written in .NET
framework which acquires and converts JSON output of SGS's of DSI (Stream Gauging Station) to Excel format.
Fun
TBAAB BlackBox: A twitter bot that tweets randomly quotes
from TBAAB Community when it is triggered.
Serverless Toggle Switch: A serverless trigger that uses
AWS Lambda and AWS DynamoDB.
Close
from-tkgm-to-kmz
The intention of the tool is to provide direct conversion of parselsorgu coordinates to .kmz files to be read over Google Earth software.
Usage
- Download the repo from terminal via
git clone https://gitlab.com/yildirimhan/from-tkgm-to-kmz.git
or directly from GitHub.
Install Repository
- Install the dependencies
pip3 install -r requirements.txt
Download coordinate data
- Please perform the request via Parsel Sorgu and save the coordinates to data.txt by dragging mouse over them.
- Run from the terminal
python3 main.py
#python
Back
Close
auto Data Collector
It is decided that company needs to store daily datas from Energy Exchange
Istanbul (EPIAS) and datas from its own powerplants in order to make
further/deeper analysis regarding the market. SQLServer 2012 is selected as
base since it is widely known and lots of examples for it can be found on
internet.
Figure 1 Snapshot of one of the databases and its tables.
Since the datas provided by EXIST over public APIs are published in certain
hours at the day, an app, Auto Data Collector which runs on company’s
server are doing the trick. Auto Data Collector uses Cron jobs to trigger
certain functions at certain times (Fig 2. Timeline). The app which is
written in C# with Visual Studio 2017 collects the data both from public
APIs and powerplants (Reservoir Level, Generator Output, Energy Production
etc.) and writes them to Enerji database. (Fig 1). It also shows a log file
so that user can manage the cronjobs and see if there is an error while
triggering the functions.
Figure 2 Auto Data Collector uses CronJobs with C#.
#dotnet #csharp #cron #sqlserver #mssql #restsharp
Back
Close
ALEN Market Analysis
The datas gathered over APIs are demonstrated as Trading and Analysis Teams
of company needs. It uses company’s database for its inputs.
Figure 3 alenAPP is written in C#.
Figure 4 Charts and tables are being created with queries to company's dB.
The app also has save/load function which saves the most common queries to
save time.
Figure 5 Another interface with tables and charts.
Figure 6 The job which Auto Data Collector is doing is also can be done in
alenApp by manually.
#dotnet #csharp #sqlserver #mssql #restsharp
Back
Close
Daily Market Report
The datas regarding the daily electricity prices gathered over APIs are
demonstrated as Trading and Analysis Teams of company needs. This is a
daily report that summarize the market prices. It is used by both managers
and juniors in a daily basis to give them a quick view on daily market.
This app is also written is C# and gets the input datas from company’s
SQLServer database.
Figure 7 Daily Market Prices Report application written in C#.
Back
Close
EnerjiREST API
EnerjiREST is an application written in JS to publish datas from company
database to HTTP. The data which is gathered from powerplants are going
public over this REST API.
Figure 8 EnerjiREST is an REST API written in JS.
With this API members of company can access the related powerplant data.
Figure 9 Response of REST API.
#dotnet #csharp #cron #sqlserver #mssql #restsharp
Back
Close
React Web Apps
All the apps which is written in C# transformed into JS and published with
ReactJS. Figure 10 shows a homepage that has links to web application
version of alenApp and Daily Price Report App along with Power Plant
Monitoring Web App.
Figure 10 Web Application Homepage with different web app links
Power Plant Monitoring Web App gets its input data from RESP API that has
written before. The percentage of reservoir level in the photo for Karakuz
HESPP changes according to the actual reservoir level. (Figure 11).
The tables also gets input by querying the company dB.
Figure 11 Power Plant Monitoring Web Application
#js #react #mssql #sqlserver #frontend
Back
Close
DSI AGI Converter
In Hydroelectric Power Plants, stream that flows through the river HEPP is connected to
is crucial factor to decide the plant's output. To measure stream, Stream Gauging Stations
(Akım Gozlem Istasyonu - AGI) are commissioned both by state and private sector owners of HEPPs.
By this app, one can connect AGI's of DSI and provide the data which AGI has measured.
Figure 12 Snapshot of GUI.
Since the AGI datas shared to HEPP owners in JSON format, this app deserializes JSON to
MS Excel or Notebook formats.
Figure 13 Snapshot of get request page.
After collecting the data as more compatible format, more accurate forecasts can be made in stream flow.
Figure 14 Map that shows last acquired values.
#dotnet #csharp
Back
Close
TBAAB BlackBox
TBAAB BlackBox is a Twitter bot that tweets randomly quotes
from TBAAB Community when it is triggered.
The bot is based on serverless structure as it is using AWS Lambda and AWS S3 technologies.
It takes Whatsapp chat logs as its input. It randomly selects an entry among the logs then make the selected
entry anonymously tweetable by clearing the metadatas, signatures, name etc. After that it uses Tweepy to connect
twitter APIs and tweet the randomly selected quote.
You can give it a try!
Link to TBAAB Twitter Bot. .
#python #aws #cloud
Back
Close
Your mail is sent.
Thank you for contacting. I will look up as soon as possible.
Back
Close
Serverless Toggle Switch
Switch Variable
Close
Back
About
I am an electrical and electronics engineer who has great interest towards
software development. I am a data analysis and algorithm engineer working
in energy industry.
I love spending time on fixing little details and solving problems.
I am a realistic person who is very eager to learn new things,
I think every information I gain broadens my horizon.
I like to define myself as "a simple man with simple goals".
I think that success is having fun. And when I'm having fun doing my job,
I'm happy. If I can make a little money on the side doing it,
I'm really happy.
Contact
Elements
Text
This is bold and this is strong. This is italic and this is emphasized.
This is superscript text and this is subscript text.
This is underlined and this is code: for (;;) { ... }
. Finally, this is a link.
Heading Level 2
Heading Level 3
Heading Level 4
Heading Level 5
Heading Level 6
Blockquote
Fringilla nisl. Donec accumsan interdum nisi, quis tincidunt felis sagittis eget tempus euismod. Vestibulum ante ipsum primis in faucibus vestibulum. Blandit adipiscing eu felis iaculis volutpat ac adipiscing accumsan faucibus. Vestibulum ante ipsum primis in faucibus lorem ipsum dolor sit amet nullam adipiscing eu felis.
Preformatted
i = 0;
while (!deck.isInOrder()) {
print 'Iteration ' + i;
deck.shuffle();
i++;
}
print 'It took ' + i + ' iterations to sort the deck.';
Lists
Unordered
- Dolor pulvinar etiam.
- Sagittis adipiscing.
- Felis enim feugiat.
Alternate
- Dolor pulvinar etiam.
- Sagittis adipiscing.
- Felis enim feugiat.
Ordered
- Dolor pulvinar etiam.
- Etiam vel felis viverra.
- Felis enim feugiat.
- Dolor pulvinar etiam.
- Etiam vel felis lorem.
- Felis enim et feugiat.
Icons
Actions
Table
Default
Name |
Description |
Price |
Item One |
Ante turpis integer aliquet porttitor. |
29.99 |
Item Two |
Vis ac commodo adipiscing arcu aliquet. |
19.99 |
Item Three |
Morbi faucibus arcu accumsan lorem. |
29.99 |
Item Four |
Vitae integer tempus condimentum. |
19.99 |
Item Five |
Ante turpis integer aliquet porttitor. |
29.99 |
|
100.00 |
Alternate
Name |
Description |
Price |
Item One |
Ante turpis integer aliquet porttitor. |
29.99 |
Item Two |
Vis ac commodo adipiscing arcu aliquet. |
19.99 |
Item Three |
Morbi faucibus arcu accumsan lorem. |
29.99 |
Item Four |
Vitae integer tempus condimentum. |
19.99 |
Item Five |
Ante turpis integer aliquet porttitor. |
29.99 |
|
100.00 |