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 |
|
Professional 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. 
|
Read, 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 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. 
|
Automated confined space construction plan generator. Risk assessment, work permits, emergency procedures — regulatory compliant. 
|
|
Agent reads CAD content, identifies components, calculates power, batch replaces text/numbers, modifies line types & blocks. High control rate · high stability · high recognition. 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 | Macau |
| Languages | 粵語 · 普通话 · English |
Don't just use AI. Cultivate it. A complete handbook for training your AI assistant into a domain engineering expert.
| Edition | Price | What's Included |
|---|---|---|
| Free | ¥0 / $0 | Chapter 1 (8-Level Self-Assessment) + 1 skill pack |
| Starter | ¥9.9 / $1.99 | 3 essential chapters + 3 skill packs |
| Complete | ¥49 / $6.99 | Full manual (13 chapters + 8 appendices) + 7 skill packs |
| Professional | ¥199 / $29 | Everything + 1-on-1 consultation + custom skill pack |
Prices are public. Contact via email to purchase — payment details discussed privately.
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 | $3/month | Name in sponsors list, early access to new tools |
| 🛠️ Supporter | $9/month | Priority issue response (48h), monthly dev update |
| 🏢 Company | $29/month | Logo on profile + repos, feature request priority, 30min/month consultation |
Services aligned with the AI Agent Cultivation Field Manual — affordable, practical, and matched to your needs.
| Service | Description | Starting From |
|---|---|---|
| AI Cultivation Review | Assess your AI setup, identify your Level (1-8), suggest next steps | ¥49 / $7 |
| Custom Skill Pack | Build one custom skill pack for your specific workflow | ¥149 / $19 |
| Team Setup Package | Deploy + configure tools + train your team (remote, 2h session) | ¥199 / $29 |
| O&M Manual Generator | Custom O&M manual template + auto-generation pipeline | ¥299 / $49 |
| Full MEP Automation Suite | Complete AI agent + skill packs + workflow automation | ¥499 / $69 |
All services include: source code, documentation, and 30-day email support. Prices are starting points — final quote depends on scope.
If any of the tools or experience above relate to your engineering projects, feel free to reach out. Always happy to connect.
如果上面的工具或經驗，同你手頭做緊的工程項目有啱用嘅地方，歡迎交流。