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.
Low-Poly 3D Scan Conversion Category: 3D Architecture, 3D CAD, 3D Design, 3D Drafting, 3D Modelling, 3D Rendering, 3D Studio Max, 3D Visualization, 3ds Max Budget: $30 - $250 USD
02-Nov-2025 05:04 GMT
Website Data To Excel Category: Data Analysis, Data Collection, Data Entry, Data Management, Data Processing, PDF, Web Scraping Budget: $15 - $25 USD
Real Estate Photographer Needed Category: Graphic Design, Illustration, Image Processing, Logo Design, Photo Editing, Photo Retouching, Photography, Photoshop, Real Estate, Visual Arts Budget: $17 - $50 USD
02-Nov-2025 05:03 GMT
Minimalist Home 3D Walkthrough -- 2 Category: 3D Animation, 3D Design, 3D Modelling, 3D Rendering, 3D Studio Max, 3D Visualization, 3ds Max, Blender, Interior Design, SketchUp Budget: ₹600 - ₹1500 INR
