Skip to content

Python CLI application for generating security system quotes using a JSON-backed product database and Excel export automation. Public version sanitized to protect proprietary pricing and business data.

Notifications You must be signed in to change notification settings

jamesbilis/Security-Systems-Quote-Generator--Sanitized-

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

3 Commits
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

πŸ” Security Systems Quote Generator (Sanitized)

Overview

This project is a Python-based command-line quote generator designed to automate and standardize the creation of security system quotes across multiple system types, including:

  • Video Surveillance
  • Head End / Network Infrastructure
  • Access Control
  • Video Intercom
  • Intrusion / PIDS

The application demonstrates real-world business automation using Python, JSON-backed data storage, structured CLI workflows, and Excel-based quote generation.


⚠️ Data Sanitization & Privacy Notice

This repository contains a sanitized version of an internal quoting tool originally developed for professional use.

To protect Electronic Security Group (ESG) business privacy and vendor confidentiality:

  • All product prices have been replaced with placeholder values
  • Labor rates, tax rates, and markups are non-production defaults
  • Vendor discount pricing has been removed
  • Internal Excel pricing templates are not included
  • Company-specific procedures and workflows are excluded

This repository focuses strictly on software architecture, automation logic, and engineering practices.
The original production version is not publicly available.


✨ Features

  • Interactive CLI-based menu system
  • Modular product categories:
    • Cameras
    • Head End
    • Access Control
    • Intercom
    • Intrusion
  • JSON-backed product database with persistence
  • Dynamic table rendering with auto-sized columns
  • Add, update, and remove quote items
  • Camera-specific accessory handling
  • Labor, tax, and miscellaneous cost calculations (sanitized)
  • Automated Excel export using openpyxl
  • Defensive file handling and error checking

πŸ—‚οΈ Project Structure

security-quote-generator/
β”œβ”€β”€ src/
β”‚   β”œβ”€β”€ quote_generator.py
β”‚   └── product_database.example.json
β”‚
β”œβ”€β”€ .gitignore
β”œβ”€β”€ README.md
└── LICENSE

About

Python CLI application for generating security system quotes using a JSON-backed product database and Excel export automation. Public version sanitized to protect proprietary pricing and business data.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages