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.

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

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

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

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#.

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

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

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

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

TBAAB Foundation

TBAAB is a community which works are focused on its district. It always works for benefits of people of the district without a political goal.

Your mail is sent.

Thank you for contacting. I will look up as soon as possible.

Serverless Toggle Switch

Switch Variable

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

• Instagram
• Twitter
• linkedIn

Elements

i = 0;

										while (!deck.isInOrder()) {
											print 'Iteration ' + i;
											deck.shuffle();
											i++;
										}

										print 'It took ' + i + ' iterations to sort the deck.';