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.
Structural Sketch to DWG Conversion Category: 2D Drafting, AutoCAD, Building Architecture, Building Design, Building Engineering, CAD / CAM, Drafting, Engineering Drawing Budget: $250 - $750 USD
15-May-2026 10:02 GMT
Gmail-Ready HTML Signature Conversion Category: CSS, Digital Marketing, Email Marketing, Graphic Design, HTML, HTML5, JavaScript, PSD To HTML, Web Design, Web Development Budget: £20 - £250 GBP
Modern Fast-Food Menu Design Category: Adobe Illustrator, Photoshop, Digital Design, Graphic Design, Illustration, Logo Design, Menu Design, Typography, Visual Design Budget: $10 - $30 AUD
Asisten Layanan & Penjadwalan Category: Customer Service, Data Entry, Data Processing, Documentation, Excel, Microsoft Word, Time Management, Word Budget: $15 - $25 USD
15-May-2026 09:54 GMT
Boost My Site's Authority Category: Analytics, Content Marketing, Digital Marketing, Internet Marketing, Keyword Research, Link Building, Marketing, SEO, Website Audit Budget: ₹1500 - ₹12500 INR
