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.
Vibrant E-Commerce Video Ads Category: After Effects, Animation, Graphic Design, Motion Graphics, Video Ads, Video Editing, Video Production, Video Services Budget: $10 - $30 AUD
07-Mar-2026 10:59 GMT
Fix Telegram Link Crash Bug Category: Android, Mobile App Development, PHP, Web Development, Web Security, Website Optimization, Website Testing, WordPress Budget: €8 - €30 EUR
Shopify Footwear Personalization Store Setup Category: HTML, Shopify, Shopify Development, Shopify Templates, UI / User Interface, Web Design, Web Development Budget: £250 - £750 GBP
Trading MEMES Category: Animation, Content Creation, Creative Writing, Graphic Design, Social Media Marketing, Video Editing, Video Production, Video Services Budget: €30 - €250 EUR
07-Mar-2026 10:54 GMT
Hiring: Graphic Designer for Instagram Brand -- 2 Category: Branding, Content Creation, Digital Marketing, Graphic Design, Illustration, Instagram Marketing, Logo Design, Photoshop, Social Media Marketing, Visual Arts Budget: ₹1500 - ₹12500 INR
07-Mar-2026 10:52 GMT
Instagram Reel Editor for Quick Tips Category: Content Creation, Content Writing, Editing, Instagram Marketing, Social Media Marketing, Video Editing, Video Production, Video Services Budget: ₹12500 - ₹37500 INR
