AracTakip
Fleet vehicle maintenance scheduler (km, date, threshold) — fires a reminder email when service is due.
L lavescar ▸ arac-teklif-takip
SMB OFFICE AUTOMATION
Excel plus Gmail.
No boring repetition.
Only notifications.
Two small Python tools for vehicle maintenance and proposal follow-up tracking. Read the rule from Excel, fire a Gmail SMTP notification when the threshold trips.
two tools, one logic
TeklifTakip
Tracking customer proposals in Excel — automatic follow-up email for pending replies and approaching deadlines.
flow
- 1 Open the workbook Pure-Python openpyxl reader — no Excel install required. Formulas are evaluated locally.
- 2 Evaluate rules CALC: D8 B13 E13 <=15 — plate cell, label cell, value cell, threshold. Rules are processed in order.
- 3 Send email Gmail SMTP (587/SSL) with an app password. No third-party SMTP relay involved.
- 4 Reset with SET After firing, SET: C22 50 updates the counter so the same notification does not repeat.
features
- GUI wizard Tkinter setup wizard — no need to hand-write the config file.
- PyInstaller .exe Single-file Windows .exe — target machine does not need Python installed.
- CALC + SET rules Excel formulas (TODAY, NOW, cell arithmetic) resolve through a local evaluator.
- Multiple recipients EMAILRECIPIENTS line accepts a comma-separated list — add as many recipients as you need.
- Log file EmailGonderici.log — every triggered rule and sent mail is recorded.
- Cron / Task Scheduler Wire it up via cron on Linux or Task Scheduler on Windows.
install
Two ways — run from source or download the .exe.
From source
git clone https://github.com/Lavescar-dev/arac-teklif-takip
cd arac-teklif-takip
pip install -r requirements.txt
python EmailGonderici.py --setupPrebuilt .exe (Windows)
Grab the latest AracTakip.exe and TeklifTakip.exe from the GitHub Releases page, double-click, the wizard opens.
↓ Download