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.
Pharmacy Logo Design Category: Adobe Illustrator, Photoshop, Branding, Graphic Design, Illustration, Logo Design, Visual Design Budget: ₹1500 - ₹12500 INR
15-Oct-2025 04:02 GMT
Simple 1-2 page Tableau Assessment Category: Business Intelligence, Data Analysis, Data Integration, Data Management, Data Mining, Data Modeling, Data Visualization, Market Research, Statistical Analysis, Tableau Budget: $10 - $30 USD
Website Redesign for Cleaning Company Category: Graphic Design, HTML, PHP, User Experience Research, Web Design, Web Development, WordPress Budget: $1500 - $3000 USD
