Projects, reports, samples and programming
- Since the very beginning of my survey career, I’ve been deeply engaged with programming and coding.
- Throughout my projects, I’ve developed custom-coded spreadsheets and drawing tools to accelerate workflows and improve efficiency.
- While each solution was initially designed for a specific project, they’ve always been adaptable for broader, universal use.
- My work often includes engineering calculations, quick as-built reporting tools, professional process tracking forms, and even progress payment automation when needed.
- More recently, I’ve been focusing on developing web-based, interactive, and multi-user calculation and visualization tools.
Centerline Editor
An Excel-VBA based data visualization and editing tool designed to manage and modify road & pipeline centerline data efficiently. It features dynamic geometry updates, section-based attributes, and export options for CAD integration.
Key Features
- Imports coordinate data directly into Excel
- Locates points precisely along the centerline
- Calculates deviations and alignment differences
- Highlights out-of-tolerance deviations with color indicators
- Supports multiple parallel offset axes
Survey As-built Report Generator
An Excel VBA-based generator for survey as-built reports that merges template data automatically. Designed to save time on repetitive reporting tasks and maintain consistent document formatting.
Process Tracking Form
A digital form built for monitoring and recording workflow progress across departments. Provides automatic timestamping, task assignment, and report generation in Excel or PDF. It works with VBA codes at backround. Not only a table or spreadsheet!
Material Database Tool
A lightweight database application to manage engineering material properties and test data. Supports custom filtering, bulk import/export, and live chart visualization of property trends.