Required stack
필요 기술
Excel VBAVisual BasicData ManagementData ProtectionAutomationUser Interface Design
Project brief
프로젝트 내용
We need an Excel VBA quotation system (offline) for a windows & doors company.
The system must include:
A protected Admin Pricing Sheet where only admin can control all prices (designs, materials, colors, glass, screens, key lock, installation rates, delivery rate).
A Customer Database where users can add customers, but cannot edit or delete them without admin approval. Customers must be searchable and auto-filled into quotations.
A Quotation system where:
- Quotation number is automatic
- Date is automatic
- Expiry date is +15 days
- User selects customer, adds salesperson name and remarks
Each quotation must support multiple line items.
Each line includes:
Design, Material, Color, Glass, optional Screen, optional Key Lock, Width, Height, Quantity.
The system must automatically calculate:
Price per m² (based on selections)
Line total (including quantity and key lock)
Subtotal (all lines)
Project-level calculations:
Installation (optional, based on highest rate per material and total m²)
Delivery (0 if ≤30 km, otherwise full km × rate)
VAT 7%
Final Total
System must be protected:
Users cannot change pricing or formulas
Saved quotations cannot be edited without admin password
Final quotation must be clean and ready for PDF export.
The system must include:
A protected Admin Pricing Sheet where only admin can control all prices (designs, materials, colors, glass, screens, key lock, installation rates, delivery rate).
A Customer Database where users can add customers, but cannot edit or delete them without admin approval. Customers must be searchable and auto-filled into quotations.
A Quotation system where:
- Quotation number is automatic
- Date is automatic
- Expiry date is +15 days
- User selects customer, adds salesperson name and remarks
Each quotation must support multiple line items.
Each line includes:
Design, Material, Color, Glass, optional Screen, optional Key Lock, Width, Height, Quantity.
The system must automatically calculate:
Price per m² (based on selections)
Line total (including quantity and key lock)
Subtotal (all lines)
Project-level calculations:
Installation (optional, based on highest rate per material and total m²)
Delivery (0 if ≤30 km, otherwise full km × rate)
VAT 7%
Final Total
System must be protected:
Users cannot change pricing or formulas
Saved quotations cannot be edited without admin password
Final quotation must be clean and ready for PDF export.