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.
Full-Stack CMS Development Category: AngularJS, Bootstrap, Database Design, Full Stack Development, MySQL, Node.js, PHP, Web Development Budget: $25 - $50 USD
16-Jan-2026 23:03 GMT
Transcribe Handwritten Business Notes Category: Data Entry, English (US) Translator, English Spelling, Microsoft Word, Proofreading, Transcription, Typing, Word Budget: $250 - $750 USD
AI Reporting & Schedule Assistant -- 2 Category: AI Development, Automation, Data Analysis, Data Visualization, Microsoft Outlook, Power Automate, Power BI, Python Budget: $750 - $1500 USD
16-Jan-2026 22:54 GMT
Elegant Dove Logo Animation Category: 2D Animation, 3D Animation, Adobe Creative Cloud, Adobe Premiere Pro, After Effects, Animation, Video Production, Video Services Budget: $30 - $250 USD
16-Jan-2026 22:54 GMT
Virtual Wheel of Fortune Webpage Category: API Development, Backend Development, HTML, JavaScript, Node.js, PHP, Prestashop, Web Design, Web Development Budget: $30 - $250 USD
16-Jan-2026 22:53 GMT
General Excel Assistance Needed Category: Data Analysis, Data Management, Data Processing, Excel, Excel Macros, Excel VBA, Visual Basic, Visual Basic For Apps Budget: $10 - $30 AUD
Création de Site Shopify Mono-Produit Category: Conversion Rate Optimization, HTML, Mobile App Development, PHP, Shopify, Shopify Development, Shopify Templates, Web Design Budget: €30 - €250 EUR
16-Jan-2026 22:46 GMT
Custom Excel System for Plastic Business Operations Category: Business Management, Data Analysis, Data Visualization, Excel, Excel Macros, Excel VBA, Inventory Management, Manufacturing, Visual Basic, Visual Basic For Apps Budget: $10 - $30 USD
