Architect's Angle
I aim to free up time to focus on the bigger picture.
Welcome to Architect's Angle, a Python-focused process optimization project I developed for an architectural firm.
​
Summary: Developed a program to automate the generation of quantitative and quantitative site surveys, convert completed survey CSV/Excel data into fully formatted comprehensive MS Word reports, ready to be issued as final reports to leadership. This process reduces manual data entry by approximately 20 hours monthly.
​
See the steps I took below.
The Architect's Process: While conducting the site visit, architects at a national firm take manual notes and photographs on a mobile phone to document the project status, including potential financial and environmental considerations. Data and photographs are then manually re-summarized, input into an Excel file after the visit, and again re-analyzed for a third time before being input into a word document for reporting.
Breaking Down the Problem
-
The Architect must wait until after the site visit to manually enter quantitative and qualitative data into usable format – Excel/CSV
-
Notes and data are then manually transferred from MS Excel to MS Word in a risky, and error-prone copy-paste process
-
To prepare the final document, the Excel, Word, and PDF files must be manually reproduced for each client before each site visit.
The Solution: Step 1
Automated Pre-Survey
-
Developed an interactive desktop user-interface tool for the Architect to re-create and access site surveys on mobile (python web browser + email automation).
Automated web-based Microsoft login, survey re-production, and survey emailing, leveraging internally available, easy to modify survey with Microsoft Forms.
Step 2:
Converting Data into Reports
Created a script to automatically produce new project management word documents and populate them with accurate CSV survey quantitative and qualitative data.
