Objective Automating all calculation columns (currently N–U) so formulas propagate immediately for every new row. Securing sensitive cells (inputs vs. calculated results) to prevent accidental edits. Building an intuitive dashboard that dynamically summarizes key metrics (sales, commissions, margins, contract counts) with slicers and charts.
1. Automated Formulas Scope: Columns N (Contract End Date) through U (Month Signed) must each be true “calculated columns” within the Table.
Requirements:
New data entered in columns A–M automatically triggers all eight calculation formulas in that same row—no manual copy/paste or VBA maintenance.
Formulas reference:
End Date (N): LiveDate + Years × 12, minus 1 day.
ContractValue (O): (EAC/AQ × Uplift %) × Years.
Processing Fee (P): 12% of ContractValue if Channel = “UD,” else 0.
Gross profit (Q): ContractValue – Processing Fee.
Agents Commission % (R): 0.5 for Channel “Brook Green,” otherwise lookup via Sales Person table.
Cutter Mount Category: 3D CAD, 3D Design, 3D Drafting, 3D Modelling, 3D Printing, 3D Rendering, AutoCAD, CAD / CAM, Fusion 360, Solidworks Budget: $250 - $750 USD
01-Apr-2026 21:46 GMT
Logo Modification Category: Adobe Illustrator, Photoshop, Creative Design, Graphic Design, Illustration, Logo Design, Typography Budget: $30 - $250 USD
01-Apr-2026 21:44 GMT
Pool House & Storage Design Category: Architecture, AutoCAD, Building Architecture, Building Design, Building Engineering, Construction, Graphic Design, Interior Design Budget: $250 - $750 USD
Football Agency Social Media Manager Category: Animation, Content Creation, Graphic Design, Instagram, Social Media Management, Social Media Marketing, TikTok, Video Editing Budget: €30 - €250 EUR
01-Apr-2026 21:41 GMT
Short Video Content Mobile App Creation Category: Android, App Design, Flutter, IOS Development, IPhone, Mobile App Development, PHP, Video Production Budget: ₹37500 - ₹75000 INR
01-Apr-2026 21:40 GMT
QR-Based Restaurant Ordering System Category: API Development, C#, Programming, Database Management, MySQL, Payment Gateway Integration, PHP, Software Architecture, Web Development Budget: $250 - $750 USD
01-Apr-2026 21:38 GMT
Local Theater Ticket Sales Ads Category: Ad Planning & Buying, Advertising, Digital Marketing, Google Ads, Google Adwords, Internet Marketing, Marketing, Social Media Marketing Budget: $25 - $50 USD
