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.
Hiring Native Chinese Speakers — 30-Minute English Conversation Category: English Translation, Language Tutoring, Personal Development, Research, Simplified Chinese Translator, Traditional Chinese (Hong Kong), Traditional Chinese (Taiwan), Translation, Video Conferencing, Zoom Budget: $10 - $30 USD
05 Nov 2025 11:04 GMT
Modern E-Commerce Website Development Category: Graphic Design, HTML, Inventory Management, PHP, Web Design, Web Development, Website Optimization Budget: ₹1500 - ₹12500 INR
3D Mobile Card Game Development Category: 2D Game Art, 3D Animation, Backend Development, Frontend Development, Game Design, Game Development, Game Testing, Mobile App Development, Unity, Unreal Engine Budget: £250 - £750 GBP
05 Nov 2025 11:03 GMT
English-Telugu Business Translation Needed Category: Content Writing, English (US) Translator, English Spelling, English Translation, Proofreading, Technical Writing, Telugu Translator, Translation Budget: ₹750 - ₹1250 INR
05 Nov 2025 11:03 GMT
Vendedor Telecomunicaciones Call Center Category: Call Center, Customer Retention, Customer Service, Lead Generation, Sales, Sales Account Management, Sales Management, Sales Promotion, Telecom, Telecom Sales Budget: €700 - €701 EUR
05 Nov 2025 11:02 GMT
Investor Relations Specialist Needed Category: Business Analysis, Business Development, Fundraising, Market Research, Research Writing, Sales Budget: ₹600 - ₹1500 INR
Writing project Category: Article Writing, Blog Writing, Content Development, Content Writing, Creative Writing, Essay Writing, Non Fiction Writing, Research Writing, Social Impact, Writing Tutoring Budget: ₹600 - ₹1500 INR
05 Nov 2025 11:01 GMT
Dewi138 Editor Konten Media Sosial Category: Content Creation, Content Writing, Copy Editing, Copywriting, Creative Writing, Digital Marketing, Editing, Proofreading, Social Media Management, Social Media Marketing Budget: $15 - $25 USD
05 Nov 2025 11:01 GMT
Building Hoist Calculation Audit & Recommendations Category: Civil Engineering, Construction Engineering, Finite Element Analysis, Mathematics, Report Writing, Risk Assessment, Structural Engineering, Technical Writing Budget: €250 - €750 EUR
05 Nov 2025 11:01 GMT
n8n workflow for Payment Reminder Automation Category: API Integration, Automation, Data Processing, Google Sheets, HTML, JavaScript, N8n, SMTP, Software Architecture Budget: ₹1500 - ₹12500 INR
