🏠 Interactive Screen Enclosure Spreadsheet
With Built-in Formulas & Auto-Calculations
💡 Features: Auto-calculating formulas for Linear Ft, Sq Ft, and Totals | Dropdown menus for consistency | Add/delete rows | Export to CSV | Click "Show Formulas" for Excel formula examples
Rows: 1
| # | Date | Customer Name | Phone | Address | Project Type | Description | Overall Length (ft) | Overall Width (ft) | Overall Height (ft) | Slab Status | Opening 1 W×H | Opening 2 W×H | Opening 3 W×H | Opening 4 W×H | Additional Openings | Roof Pitch | Total Linear Ft | Total Sq Ft | Screen Type | Frame Material | Special Features | Materials Cost | Labor Cost | Total Quote | Competitor Price | Lead Status | Follow-up Date | Notes |
|---|
📐 Excel Formula Reference
Copy these formulas into your Excel version:
Column R - Total Linear Ft:
=IF(AND(I2<>0,J2<>0),(I2+J2)*2,0)
Calculates perimeter: (Length + Width) × 2
Column S - Total Sq Ft:
=IF(AND(I2<>0,J2<>0),I2*J2,0)
Calculates area: Length × Width
Column Z - Total Quote:
=W2+X2
Adds Materials Cost + Labor Cost
Dropdown Options:
Project Type: New Patio Enclosure, Existing Conversion, 3-Season Room, Screen Repair, Addition
Slab Status: Existing Slab, No Slab, New Slab Needed, Existing Deck
Screen Type: Standard Fiberglass, Pet Resistant, Solar Screen, Privacy Screen, Clear Vinyl
Frame Material: Aluminum, Vinyl, Wood, Composite
Lead Status: New Lead, Contacted, Appointment Set, Quote Sent, Negotiating, Sold, Lost