1001 Freelance Projects -- Enhanced “Contracts Book” Spreadsheet

Latest Projects from Freelance Marketplaces

Today is: 21-Jan-2026 21:01 GMT

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
Casual Letter Pad Design Category: Adobe Illustrator, Adobe InDesign, Photoshop, Branding, Cover Letter, Graphic Design, Illustration, Print Design Budget: ₹100 - ₹400 INR	21-Jan-2026 17:04 GMT
CutE by 42NET – Audacity-based Multi-Platform Audio Editor with Database-Backed Workflow \| C++ -- 2 Category: Audio Editing, C, Programming, C++, Database Management, Microsoft SQL Server, Objective C, Software Development Budget: $250 - $750 USD	21-Jan-2026 17:03 GMT
Cross-Country Large Package Delivery Category: Courier, Delivery, Freight, Logistics, Logistics Company, Shipping, Supply Chain Budget: $250 - $750 CAD	21-Jan-2026 17:03 GMT
Service Brochure Design Category: Brochure Design, Creative Design, Graphic Design, Print Design Budget: £250 - £750 GBP	21-Jan-2026 17:02 GMT
Mixed-Media Panoramic Illustration for smooth Horizontal Scroll (3 Panels) Category: 2D Drawing, Photoshop, Caricature & Cartoons, Digital Art, Graphic Design, Illustration, Procreate Budget: €30 - €250 EUR	21-Jan-2026 17:02 GMT
Engaging Promotional Videos Needed - 21/01/2026 11:49 EST Category: A / V Editing, Animation, Motion Graphics, Sound Design, Video Editing, Video Services Budget: ₹100 - ₹400 INR	21-Jan-2026 17:01 GMT
"The Last Supper" Themed Wedding Cartoon Category: 2D Animation, 2D Drawing, AI Art Creation, AI Design, Caricature & Cartoons, Illustration Budget: $240 - $2000 HKD	21-Jan-2026 17:00 GMT
Back Deck Safety & Code Inspection Category: Construction, Structural Engineering Budget: $30 - $250 USD	21-Jan-2026 16:58 GMT
30-Second Live-Action Brand Ad Category: After Effects, Animation, Video Editing, Video Services, Videography Budget: $750 - $1500 USD	21-Jan-2026 16:57 GMT
Edmonton Office Internet Troubleshooting Category: Cisco, Computer Security, Network Administration, Network Engineering, Network Security, Technical Support, Technical Writing, Troubleshooting Budget: $250 - $750 CAD	21-Jan-2026 16:56 GMT
Modern Restaurant Menu Redesign Category: Adobe Illustrator, Adobe InDesign, Branding, Brochure Design, Graphic Design, Illustration, Menu Design, Print Design Budget: $30 - $250 AUD	21-Jan-2026 16:55 GMT
Shopify Designer & Developer Needed (Hourly) Category: Conversion Rate Optimization, CSS, HTML, Payment Gateway Integration, SEO, Shopify, Shopify Development, Shopify Templates, Web Design, Web Development Budget: $2 - $8 USD	21-Jan-2026 16:55 GMT
WhatsApp CRM Lead-Gen Campaign -- 2 Category: A / B Testing, API Integration, Conversion Rate Optimization, Facebook Ads, Instagram Ads, Lead Generation, Social Media Marketing, Visual Design Budget: ₹600 - ₹1500 INR	21-Jan-2026 16:53 GMT
Working on Artificial Intelegence AI Software Daily to Generate Content Category: AI Content Creation, AI Writing, Web Crawling, Web Search Budget: $2 - $8 USD	21-Jan-2026 16:51 GMT
Custom CRM Development for Service Businesses Category: API Development, Backend Development, CRM, Database Design, Frontend Development, MySQL, Node.js, PHP, Python, Software Architecture Budget: $10 - $1000 USD	21-Jan-2026 16:51 GMT

Browse All Projects

Projects by Skills ...
Projects for 'android' Projects for 'ajax' Projects for 'asp' Projects for 'aspnet' Projects for 'cms' Projects for 'cpp' Projects for 'csharp' Projects for 'css' Projects for 'delphi' Projects for 'design' Projects for 'drupal'	Projects for 'excel' Projects for 'facebook' Projects for 'flash' Projects for 'html' Projects for 'java' Projects for 'javascript' Projects for 'joomla' Projects for 'iphone' Projects for 'mysql' Projects for 'photoshop' Projects for 'php' Projects for 'python'	Projects for 'ruby' Projects for 'seo' Projects for 'sql' Projects for 'sysadm' Projects for 'translate' Projects for 'typing' Projects for 'twitter' Projects for 'vbnet' Projects for 'xml' Projects for 'wordpress' Projects for 'writing'
Read RSS feeds ... New!
RSS feed for 'android' RSS feed for 'ajax' RSS feed for 'asp' RSS feed for 'aspnet' RSS feed for 'cms' RSS feed for 'cpp' RSS feed for 'csharp' RSS feed for 'css' RSS feed for 'delphi' RSS feed for 'design' RSS feed for 'drupal'	RSS feed for 'excel' RSS feed for 'facebook' RSS feed for 'flash' RSS feed for 'html' RSS feed for 'java' RSS feed for 'javascript' RSS feed for 'joomla' RSS feed for 'iphone' RSS feed for 'mysql' RSS feed for 'photoshop' RSS feed for 'php' RSS feed for 'python'	RSS feed for 'ruby' RSS feed for 'seo' RSS feed for 'sql' RSS feed for 'sysadm' RSS feed for 'translate' RSS feed for 'typing' RSS feed for 'twitter' RSS feed for 'vbnet' RSS feed for 'xml' RSS feed for 'wordpress' RSS feed for 'writing'

New!
Проекты на русском (Projects in Russian)	Short URL: 1001fp.com	Mobile version: m.1001freelanceprojects.com