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.
Translate Business Letters to Spanish Category: Business Writing, Castilian Spanish Translator, Content Writing, English (US) Translator, English Translation, Language Tutoring, Spanish Translator, Translation Budget: €2 - €6 EUR
12 Jul 2025 21:58 GMT
Social Media Management for Restaurant Category: Content Creation, Content Writing, Digital Marketing, Facebook Marketing, Instagram Marketing, Social Media Management, Social Media Marketing, Twitter Budget: $30 - $250 USD
AI-Powered Service Platform Development Category: AI Development, AI Model Development, Graphic Design, HTML, PHP, Recommendation System, Web Development, Web Design Budget: $750 - $1500 CAD
12 Jul 2025 21:50 GMT
Hebrew to English Translator Needed -- 2 Category: English (UK) Translator, English (US) Translator, English Translation, Hebrew Translator, Language Tutoring, Translation Budget: $2 - $8 USD
B2C Facebook Ads Specialist Needed Category: A / B Testing, Advertising, Digital Marketing, Facebook Ads, Facebook Marketing, Google Adwords, Internet Marketing, Lead Generation Budget: ₹1500 - ₹12500 INR
12 Jul 2025 21:48 GMT
Cross-Platform FPS Game Development Category: Android, Game Design, Game Development, Game Testing, Graphics Programming, Mobile App Development, Unity, Unreal Engine Budget: $15 - $25 USD
