INTL
Freelancer
보통
외주
원격 가능
Excel VBA 600 INR
예산
$600~$1,500 INR
예상 기간
1~2개월
난이도
보통
기술 스택
Excel VBA
Visual Basic
Data Management
Data Protection
Automation
User Interface Design
AI 분석 요약
오프라인 Excel VBA 견적 시스템을 구축하는 프로젝트입니다. 관리자 전용 가격 설정 시트, 검색 가능한 고객 데이터베이스, 다양한 품목별 자동 계산 및 프로젝트 레벨 총액 계산 기능이 필요합니다. Excel VBA 개발 능력과 데이터 관리, 보안 구현, 그리고 사용자 친화적인 Excel UI 설계 역량이 요구됩니다.
프로젝트 원문 설명
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.
Freelancer에서 원본 확인
원본 보기