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.
Construction Material Quantity Takeoff Category: AutoCAD, Building Architecture, Building Design, Building Engineering, CAD / CAM, Construction, Excel, Google Sheets Budget: $10 - $30 CAD
27 Aug 2025 22:03 GMT
Self-Care Digital Pain Management eBook Category: Book Writing, Content Writing, Creative Writing, Digital Marketing, EBooks, Ghostwriting, Health, Writing Budget: $30 - $250 USD
Experto en Premiere Pro para Teletrabajo Category: Photoshop, Adobe Premiere Pro, After Effects, Animation, Graphic Design, Motion Graphics, Video Editing, Video Production, Video Services Budget: $250 - $750 USD
Lifestyle Blog Writing Category: Article Writing, Blog, Blog Writing, Copywriting, Creative Writing, Editing, Ghostwriting, SEO Writing Budget: $30 - $250 CAD
27 Aug 2025 22:00 GMT
Wordpress Site Tweaks Required Category: CSS, HTML, PHP, Web Development, Web Hosting, WordPress, WordPress Design, WordPress Plugin Budget: $15 - $25 CAD
27 Aug 2025 21:57 GMT
Unity3D Mobile Game Project [sharp]JP25888640 Category: Augmented Reality, C#, Programming, Game Art, Game Design, Game Development, Game Testing, Game UI, Mobile App Development, Unity, Unity 3D Budget: $1000 - $1500 USD
