MEP Engineering Project Manager
Replaced $630 MS Project licenses and hours of manual paperwork with Python scripts that run in 5 seconds.
Each tool was born from a real construction jobsite problem โ not a tutorial.
| Your Problem | Tool | Time Saved |
|---|---|---|
| Need a Gantt chart? | GanttChart Pro | 2-4h โ 5s |
| Batch-fill Excel templates? | Excel Template Filler | 2-4h โ 5min |
| Generate material submittals? | Material Submittal Generator | 8-12h โ 5min |
| Read VBA macros without Excel? | VBA Macro Reader | Manual โ Automated |
| Automate daily construction logs? | Daily Construction Log | 1h/day โ 30s |
| OCR scanned engineering docs? | OCR Skill | Manual โ Automated |
| Generate electrical test reports? | Electrical Test Report Gen | 2-4h โ 5min |
| Need confined space safety plans? | Confined Space Planner | 4-8h โ 15min |
| Convert SLD to arrangement drawings? | SLD to Arrangement | 2-3h โ 30s |
๐ GanttChart ProProfessional Gantt charts in Excel โ no MS Project required. Dual calendar modes, WBS grouping, milestone markers, dependency arrows. 
|
Dual-engine batch template filling. Preserves images, print settings, and formatting โ things openpyxl alone can't do. 
|
|
One-click batch generation of material submittal sheets + automatic BQ page merging. Battle-tested in MEP construction. 
|
๐ง VBA Macro ReaderRead, modify & execute VBA macros from .xlsm/.xlam files. Dual-mode: oletools (cross-platform read) + win32com (full control). 
|
|
Automated daily construction record generation. Copy-yesterday strategy, weather/tide extraction, auto photo embedding, PDF merging. 
|
๐ OCR SkillOCR toolkit for engineering documents. Trilingual (Chinese + Portuguese + English). Auto text-layer detection, large PDF handling, keyword location. 
|
|
Automated current & illumination test report generation. Three-phase power calculations, 300+ photo auto-embedding, Word + PDF output. 
|
โ๏ธ Confined Space PlannerAutomated confined space construction plan generator. Risk assessment, work permits, emergency procedures โ regulatory compliant. 
|
๐ SLD to ArrangementAuto-generate electrical panel arrangement drawings from single-line diagrams. DXF parsing, BOM extraction, 18mm modular layout, 4-view output. 
|
|
| Stage | What I Automate |
|---|---|
| Material Submittal | Batch submittal sheet generation, auto-numbering, BQ page merging, revision tracking |
| Construction Docs | Progress schedules, daily site records, safety inspection forms, method statements |
| Handover & O&M | O&M manuals (multi-section standard structure), system operation guides, material schedules |
| Testing & Commissioning | Earth resistance tests, insulation tests, CCTV system tests, network cable tests |
HV Power Distribution ยท ELV/Extra-Low Voltage ยท CCTV ยท Lighting & Emergency Lighting ยท Lightning Protection & Earthing ยท Network Cabling ยท Drainage ยท HVAC
Beyond the open-source tools above, I also build:
- Excel Automation โ Custom VBA macros, batch data processing, template filling, auto-formatting
- Word Document Generation โ python-docx full-auto generation, professional layout, mixed image/table formatting
- Python Standalone Scripts โ Scheduled tasks, data extraction, PDF merge/split, file format conversion
- Numbering System Design โ Project-specific submittal numbering rules (EL/ELV/RFI)
- BQ Data Processing โ Bill of quantities auto-matching, quantity takeoff, settlement assistance
Years of hands-on experience in public works and large-scale infrastructure projects, familiar with rigorous document approval workflows and compliance standards.
| Location | China |
| Languages | ็ฒต่ช ยท ๆฎ้่ฏ ยท English |
If these tools saved you time, consider becoming a sponsor. Your support helps me maintain existing tools and build new ones.
Sponsor Tiers:
| Tier | Price | Benefits |
|---|---|---|
| โ Coffee | $5/month | Name in sponsors list, early access to new tools |
| ๐ ๏ธ Supporter | $15/month | Priority issue response (48h), monthly dev update |
| ๐ข Company | $50/month | Logo on profile + repos, feature request priority, 1h/month consultation |
| Service | Description | Starting From |
|---|---|---|
| Custom Tool Development | Build a custom automation tool for your specific workflow | $500 |
| Workflow Audit | Analyze your current document processes, identify automation opportunities | $200 |
| Implementation Package | Deploy + configure tools + train your team (remote) | $800 |
| O&M Manual Generator | Custom O&M manual template + auto-generation pipeline | $1,200 |
| Full MEP Automation Suite | Complete document automation: submittals + daily logs + handover + BQ | $3,000+ |
All services include: source code, documentation, 30-day support, and remote training session.
"Python for MEP Engineers: Automate Construction Documents"
A hands-on course teaching construction engineers how to use Python to automate their daily document workflows โ from material submittals to Gantt charts to OCR.
Planned curriculum:
- Python basics for engineers (no CS background needed)
- Excel automation with openpyxl (batch processing, template filling)
- Gantt chart generation (replace MS Project)
- Material submittal automation
- Daily construction record automation
- OCR for scanned engineering documents
- VBA macro reading & execution
- Building your own automation toolkit
Follow on GitHub to get notified when the course launches.
If any of the tools or experience above relate to your engineering projects, feel free to reach out. Always happy to connect.
ๅฆๆไธ้ข็ๅทฅๅ ทๆ็ถ้ฉ๏ผๅไฝ ๆ้ ญๅ็ท็ๅทฅ็จ้ ็ฎๆๅฑ็จๅ ๅฐๆน๏ผๆญก่ฟไบคๆตใ