Automating Statutory Planning Reports for Meander Valley Council
Meander Valley Council engaged C9 to design and implement an electronic forms (eForms) solution that automated the creation of complex statutory planning reports. The solution replaced highly manual document assembly with a rules-driven system that generated consistent, compliant Word reports by combining static planning scheme content with dynamic user-entered data, significantly reducing preparation time while improving accuracy and auditability.
By integrating a custom VSTO plugin directly into Microsoft Word and connecting it to a secure static content database, the council successfully streamlined complex statutory assessments while maintaining full professional control and editorial flexibility over final documents.
Key Functionality
- Tokenised Word Templates: Clear separation of static planning text and dynamic assessment content.
- Rule-Based Content Inclusion: Automated integration of applicable zones, codes, standards, and structured tables.
- Dynamic Table & Media Handling: Automated generation of compliance and performance criteria tables, alongside support for photographs and maps.
- Representations & Recommendations: Dynamic management of public representations and formal planning recommendations.
- Security & Post-Generation Controls: Password-protected documents generated post-completion to protect report integrity.
- Fully Editable Outputs: Generated Word documents remain fully editable for professional review, refinement, and expert judgment.
Core Technologies & Architecture
- Document Templates: Custom tokenised Microsoft Word templates supplied by council design partners.
- Content Database: A secure Microsoft Access database for centralised static content management.
- Integration Layer: A custom VSTO (Visual Studio Tools for Office) Word plugin integrated directly into Microsoft Word, allowing planners to generate reports within their familiar environment.
- Rules Engine: Rule-driven logic seamlessly combining template structures, database rules, and dynamic user inputs.
Project Outcomes & Impact
The eForms and VSTO plugin solution successfully transformed Meander Valley Council's statutory planning workflow, drastically reducing document preparation time and eliminating manual assembly errors. By automating structured report generation while preserving planner oversight, the system enhanced compliance, improved assessment consistency, and ensured statutory timeframes could be met with greater operational efficiency.