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.
Email CEO & Company Lookup Category: Data Analysis, Data Collection, Data Entry, Data Management, Excel, Research, Web Scraping, Web Search Budget: $30 - $250 USD
27-Nov-2025 16:57 GMT
Business PDF-to-Word Conversion Category: Adobe Acrobat, Adobe Creative Cloud, Adobe InDesign, Data Entry, Document Checking, Graphic Design, Microsoft Word, PDF, Word Budget: $15 - $25 USD
27-Nov-2025 16:56 GMT
Minimalist Canva Presentation Category: Business Strategy, Canva, Courses, Design, Digital Design, Marketing, Presentations Budget: £20 - £250 GBP
27-Nov-2025 16:56 GMT
Build SEO-Optimized WordPress Blog Category: HTML, PHP, SEO, SEO Auditing, SEO Writing, Web Development, WordPress, WordPress Design Budget: $30 - $250 USD
