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.
Hindi Menu & Packaging Photos Category: AI Model Development, Computer Vision, Data Collection, Hindi Translator, Image Processing, Image Recognition, IPhone, Menu Design, Photo Editing, Photography Budget: ₹600 - ₹1500 INR
29 Aug 2025 16:03 GMT
Accounting System Setup for Small Business Category: Accounting, Bookkeeping, Financial Analysis, Financial Consulting, Financial Planning, Financial Software Development, Intuit QuickBooks, Xero Budget: £20 - £250 GBP
29 Aug 2025 16:02 GMT
University Assignment Website Development Category: Content Management System (CMS), Graphic Design, HTML, PHP, Squarespace, Web Design, Web Development, Wix, WordPress Budget: €8 - €30 EUR
29 Aug 2025 16:02 GMT
Classic Site Plan Rendering Category: Adobe Illustrator, Architectural Rendering, AutoCAD, Illustration Budget: $30 - $250 USD
29 Aug 2025 16:01 GMT
Religious Mobile App development in Hindi Category: Android, Documentation, Flutter, IOS Development, IPhone, Mobile App Development, PhoneGap, React Native Budget: ₹75000 - ₹150000 INR
Career Advice Self-Help Book Writing Category: Book Writing, Content Writing, Creative Design, Creative Writing, Editing, Non Fiction Writing, Photo Editing, Proofreading, Research, Writing Tutoring Budget: ₹12500 - ₹37500 INR
29 Aug 2025 15:58 GMT
Excel Expert Needed for Data Tasks Category: Charts, Data Analysis, Data Processing, Data Visualization, Excel, Statistical Analysis, Statistics, Visual Basic Budget: ₹12500 - ₹37500 INR
