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.
VFX Artist for Indie Horror Short Film Category: 3D Animation, 3D Modelling, 3D Rendering, After Effects, Animation, Maya, VFX Art, Video Editing, Video Production, Visual Effects Budget: ₹12000 - ₹20000 INR
13-Jul-2025 10:03 GMT
Advanced Tutorial Video Creation Category: Audio Engineering, Audio Mastering, Audio Production, Video Editing, Video Production, Video Services, Voice Over, Voice Talent Budget: ₹600 - ₹1500 INR
Shopify Store for Home Linen Brand Category: ECommerce, HTML, Shopify, Shopify Development, Web Design, Web Development, Website Optimization Budget: ₹12500 - ₹37500 INR
13-Jul-2025 09:57 GMT
Remote PA Needed from Philippines Category: Admin Support, Customer Service, Data Entry, Email Handling, Project Management, Recruitment, Time Management, Virtual Assistant Budget: $10 - $20 NZD
13-Jul-2025 09:57 GMT
High-Detail AutoCAD 3D Designs Category: 3D Drafting, 3D Modelling, 3D Rendering, 3D Visualization, AutoCAD, CAD / CAM, Mechanical Design, Product Design, Solidworks Budget: ₹600 - ₹1500 INR
13-Jul-2025 09:54 GMT
Creative Video Editor for YouTube & TikTok Category: Adobe Premiere Pro, After Effects, Animation, Final Cut Pro, Video Editing, Video Post Editing, Video Production, Video Services Budget: $10 - $30 USD
13-Jul-2025 09:51 GMT
Increase Adsense Revenue Category: Content Marketing, Content Strategy, Digital Marketing, Facebook Marketing, Instagram Marketing, Internet Marketing, SEO, Social Media Management, Social Media Marketing, Twitter Marketing Budget: ₹12500 - ₹37500 INR
13-Jul-2025 09:50 GMT
CAT Quant Teacher for beginners Students Category: Education & Tutoring, Geometry, Instructional Design, Mathematics, Matlab And Mathematica, Statistics, Teaching / Lecturing Budget: ₹100 - ₹400 INR
13-Jul-2025 09:50 GMT
Google AdSense Approval for my site Category: Content Strategy, Content Writing, Google Adsense, Internet Marketing, Link Building, SEO, Website Optimization Budget: ₹3000 - ₹4000 INR
Unreal Engine Game Developer Needed Category: 3D Modelling, Android, Animation, Game Art, Game Design, Game Development, Unity 3D, Unreal Engine Budget: $10 - $30 USD
