JLGet in touch
← Selected workCase study / 05 of 05

05 / CLIENT WORKFLOW AUTOMATION

OT comment generator in Excel

After a customer approves a site's design, the OT request still needs a comment listing the authorized technologies and bands. I built an Excel tool that reads two design files and prepares these comments in a batch, removing a manual step from the request process.

ExcelVBAFormulasTelecom operations
Reported workflow resultUnder one minuteTo prepare the batch comments after design approval.

My contribution: an Excel and VBA workflow that reads two approved design sources and generates site-specific OT request comments in a batch. Decision it supports: submitting approved sites for OT creation without waiting for manual comment preparation.

Excel comment tool with two source file paths, an Extract Technologies button, blanked site ID and name columns, and generated OT comments
Screenshot supplied after removing confidential site identifiers. It shows the workbook with generated OT comments. View larger