WinLogosheet

A Windows desktop application for automated hourly logsheet management at electrical power substations. It captures SCADA screen readings via OCR, validates the data, and exports a completed daily logsheet to Excel or print.

Features

• Automated screen capture — registers a Windows Task Scheduler job that screenshots the SCADA display at minute :02 of every hour (08:00–24:00).
• OCR extraction — uses Tesseract OCR to read numeric values (KV, A, MW, MVAR) directly from each screenshot.
• Hourly data grid — color-coded ListView showing all 24 hourly readings across six substation sections.
• Real-time validation — cells are highlighted automatically:
  • Red — missing value in a row that has other data
  • Orange — abnormally high reactive power (|MVAR| > 100)
  • Yellow — suspect reading (voltage out of range, negative current, overload)
• Manual correction — select any hour, view its source image, and edit values in the text boxes.
• Excel export — fills the official Exact_Substation_Log_v4.xlsx template and creates an automatic backup.
• Print preview — generates a formatted logsheet with coordinate-calibrated layout, blocked until all validation issues are resolved.
• Section visibility toggles — show/hide individual substation groups (Yarmja, Qayra, T1, T2, T3, Feeders).

Substation Sections

Group	Columns	Bus Voltage	Measurements
Yarmja	1–4	132 kV	KV, A, MW, MVAR
Qayra	5–8	132 kV	KV, A, MW, MVAR
T1	9–12	33 kV	KV, A, MW, MVAR
T2	13–16	33 kV	KV, A, MW, MVAR
T3	17–20	33 kV	KV, A, MW, MVAR
Feeders (Domez, Summer, Salam 1, Salam 2)	21–24	—	WM (MW)

Requirements

• Windows 10/11
• .NET Framework 4.8
• Tesseract OCR installed
  • Release build expects tessdata at C:\Users\DCS_User\AppData\Local\Programs\Tesseract-OCR\tessdata
  • Debug build expects C:\Program Files\Tesseract-OCR\tessdata
• Microsoft Excel (for the Excel print path via Interop)
• The Excel template file Exact_Substation_Log_v4.xlsx placed next to the executable

Getting Started

1. Clone or download the repository.
2. Open WinLogosheet.sln in Visual Studio 2019 or later.
3. Restore NuGet packages (EPPlus, Tesseract, TaskScheduler, Microsoft.Office.Interop.Excel).
4. Build the solution (Release for production).
5. Copy Exact_Substation_Log_v4.xlsx into the output directory alongside the .exe.
6. Run the application. On first launch, click Start Task to register the hourly screenshot scheduler.

How It Works

1. Every hour at minute :02, a scheduled VBScript (screencap.vbs) captures a fixed screen region and saves it as Screenshots-YYYY-MM-DD\HH.png.
2. The application loads each PNG, runs Tesseract OCR on a pre-processed (grayscale → 2× scale → Otsu binarization) version, and populates the data grid.
3. The operator reviews each hour, corrects any OCR errors, and uses Copy from Previous/Next for unchanged hours.
4. At hour 24, the Print button becomes active. It runs a full validation pass — if any issues remain, it shows a detailed error list (in Arabic) and blocks printing.
5. Export to Excel writes all rows into the day's sheet inside the monthly workbook and saves a backup copy.

Dependencies

Package	Version
EPPlus	8.3.1
Tesseract	5.2.0
TaskScheduler	2.12.2
Microsoft.Office.Interop.Excel	16.0

License

See LICENSE.txt.