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.
