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.
Elegant Logo & Packaging Design for SIMPLYBASIC Category: Adobe Illustrator, Photoshop, Branding, Corporate Identity, Covers & Packaging, Graphic Design, Logo Design, Packaging Design Budget: ₹1500 - ₹12500 INR
14-Feb-2026 11:02 GMT
Social Media Brand Awareness Campaign Category: Brand Management, Content Strategy, Digital Marketing, Facebook Marketing, Internet Marketing, Social Media Management, Social Media Marketing, Twitter Budget: ₹600 - ₹1500 INR
14-Feb-2026 11:00 GMT
Android CANopen Control App Category: Android, Android App Development, Android SDK, Automation, CAN Bus, Java, Mobile App Development, PHP Budget: ₹12500 - ₹37500 INR
Inventory & Billing Web App Category: API Development, Database Management, Inventory Management, Laravel, PHP, Python, Software Architecture, Web Development Budget: ₹600 - ₹1500 INR
14-Feb-2026 10:52 GMT
Intuitive UI/UX Design Overhaul Category: Figma, Graphic Design, Logo Design, UI / User Interface, User Experience Research, User Interface / IA, User Story Writing, UX / User Experience Budget: $15 - $25 USD
Green Screen Background Replacement Category: Adobe Premiere Pro, After Effects, Animation, DaVinci Resolve, Photoshop, Video Editing, Video Production, Video Services Budget: ₹600 - ₹1500 INR
14-Feb-2026 10:44 GMT
Multi-Branch Eyewear Android App Category: Android, Android App Development, API Development, App Design, Kotlin, Mobile App Development Budget: ₹75000 - ₹150000 INR
14-Feb-2026 10:44 GMT
3D File Cleanup for Sculptures Category: 3D Animation, 3D CAD, 3D Design, 3D Graphic Design, 3D Modelling, 3D Printing, 3D Rendering, 3ds Max Budget: $250 - $750 USD
14-Feb-2026 10:41 GMT
Self-Driven Operations Virtual Assistant Category: Airtable, Call Center, ClickUp, Customer Support, Data Entry, Documentation, Google Sheets, Home Organization, Project Management, Virtual Assistant Budget: $250 - $750 USD
