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.
Proyek planing -- 2 Category: Banner Design, Game Design, Graphic Design, HTML, Logo Design, Odd Jobs, PHP, Web Design, Windows Desktop, WordPress Budget: $250 - $750 USD
08-Sep-2025 09:57 GMT
Detail-Oriented Data Entry Specialist Needed Category: Data Analysis, Data Cleansing, Data Entry, Data Management, Data Processing, Database Management, Excel, PDF Budget: $8 - $15 USD
Data entry virtual assistant needed from new delhi india Category: Admin Support, Data Analysis, Data Entry, Data Management, Data Processing, Excel, Google Sheets, Time Management, Virtual Assistant, Web Search Budget: ₹37500 - ₹75000 INR
08-Sep-2025 09:54 GMT
Income Expence Management Mobile Application Category: Android, App Design, Database Management, Flutter, IOS Development, IPhone, Java, Mobile App Development, Mobile Development, React Native Budget: $15 - $25 USD
08-Sep-2025 09:54 GMT
Professional Document Editor Needed Category: Adobe Acrobat, Adobe InDesign, Editing, Graphic Design, Microsoft Word, PDF, Technical Writing, Word Budget: £20 - £250 GBP
