1001 Freelance Projects -- Enhanced “Contracts Book” Spreadsheet

Latest Projects from
Freelance Marketplaces

View this project in detail (Note: you will be redirected to external marketplace)
Project title:
Enhanced “Contracts Book” Spreadsheet
Posted by:
External project from PeoplePerHour
Started:
11-Jul-2025 15:00 GMT
Description:
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. Agents Commission £ (S): Gross profit × Agents Commission %. NET Margin (T): Gross profit – Agents Commission £. Month signed (U): End of month of Date signed. Use native Excel Table features (structured references or cell-based formulas) to ensure bullet-proof propagation without user intervention. 2. Cell Protection & Data Security Scope: Lock down all formula cells (N–U) and any lookup-table ranges on the “Sales Person” sheet. Requirements: Protect the sheet with a password, leaving only columns A–M writable for data entry. Ensure users cannot accidentally overwrite formulas or lookup data. Provide clear instructions or a toggle for administrators to unprotect/reprotect the sheet. 3. Intuitive Dashboard Scope: On a new dedicated sheet (e.g. “Dashboard”), design a user-friendly overview of contract performance. Requirements: PivotTable summaries for: Total Contract Value and Gross Profit by Month signed. Top 5 Sales Agents by Commission £. Channel breakdown (e.g. “Brook Green” vs. others). PivotCharts (bar, line, pie) linked to the PivotTables. Slicers for: Channel, Sales Agent, Date (Month signed). Clean layout: clear titles, legends, and dynamic updating when new data is added. Consistent formatting (corporate color palette, number/date formats). Deliverables & Timeline Workbook: .xlsx (or .xlsm if light VBA is used), fully functional. Documentation: Short user guide (1-page) explaining: How to enter new data. How formulas are maintained. How to refresh/unprotect the dashboard. Timeline: Complete within 2–3 business days of engagement.
Project ID:
3440184
Project category:

Project budget:

View this project in detail (Note: you will be redirected to external marketplace)

Project	Started
Evaluating and Writing Personal Biography Category: Biography Writing, Book Design, Book Marketing, Creative Writing, Ghostwriting, Publishing, Research Writing Budget: ₹1500 - ₹12500 INR	24 Dec 2025 05:04 GMT
Reliable Social Media Video Producer for Short Clips -- 2 Category: Adobe Premiere Pro, After Effects, Audio Editing, Color Grading, Final Cut Pro, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services Budget: $30 - $250 USD	24 Dec 2025 05:04 GMT
Custom HTML Portfolio Website Build Category: CSS, Frontend Development, HTML, HTML5, PHP, Web Development, Web Design Budget: $15 - $25 USD	24 Dec 2025 05:03 GMT
Product Development & WA Marketing Category: Facebook Marketing, Product Design, Product Development, Product Management, Research Writing, Social Media Marketing, Twitter Budget: $15 - $25 USD	24 Dec 2025 05:02 GMT
15-Second Instagram Sales Ad Category: After Effects, Animation, Instagram Marketing, Motion Graphics, Video Ads, Video Editing, Video Post Editing, Video Services Budget: ₹600 - ₹1500 INR	24 Dec 2025 05:02 GMT
Finalize My Concept Logo Category: Adobe Illustrator, Branding, CorelDRAW, Graphic Design, Illustration, Logo Design, Photoshop, Vector Design Budget: $15 - $25 USD	24 Dec 2025 05:02 GMT
Personal Tech Troubleshooting Help Category: Computer Repair, Computer Support, Performance Tuning, System Administration, System Analysis, Technical Documentation, Technical Support, Troubleshooting Budget: ₹12500 - ₹37500 INR	24 Dec 2025 05:01 GMT
Google Updater DLL Attack Analysis Category: C, Programming, C++, Computer Security, Network Security, Penetration Testing, Python, Reverse Engineering, Software Architecture Budget: ₹1500 - ₹2500 INR	24 Dec 2025 04:59 GMT
Short-Term Tech News Writer - 23/12/2025 23:44 EST Category: Article Rewriting, Article Writing, Content Writing, Copywriting, Journalism, Research, SEO, Technical Writing Budget: $15 - $25 USD	24 Dec 2025 04:57 GMT
Desain Website Toko Online Modern Category: Adobe XD, ECommerce, Figma, Graphic Design, HTML, Prototyping, Web Design Budget: $15 - $25 USD	24 Dec 2025 04:57 GMT
High-Speed Router Hardware Design Category: ASIC, Bill Of Materials (BOM) Analysis, Circuit Design, Electrical Engineering, Electronics, FPGA, PCB Design And Layout, PCB Layout Budget: $15 - $25 USD	24 Dec 2025 04:56 GMT
Software Troubleshooting Expert Needed - 23/12/2025 23:45 EST Category: C, Programming, Copy Typing, Data Entry, Data Processing, Excel Budget: $15 - $25 USD	24 Dec 2025 04:56 GMT
Publish My App via Legacy Console Category: Android, Android App Development, App Development, App Store Optimization, IPhone, Mobile App Development, Mobile App Testing, Software Architecture Budget: ₹600 - ₹1500 INR	24 Dec 2025 04:55 GMT
Looking for Cold Emailer to Get Graphic Design Clients. Category: Advertising, Email Handling, Lead Generation, Leads Budget: $10 - $30 USD	24 Dec 2025 04:54 GMT
Real-Time Meeting Minutes Taker Category: Documentation, Editing, Microsoft Word, Proofreading, Time Management, Typing, Word Processing, Writing Budget: $15 - $25 USD	24 Dec 2025 04:54 GMT

Browse All Projects

New!
Проекты на русском (Projects in Russian)