1001 Freelance Projects
Latest Projects from Freelance Marketplaces
Today is: 30-Oct-2025 17:28 GMT
View Project
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)
Last Projects / Browse Projects
  Project Started
300k Executive Leads Needed (US-Based)
Category: Data Entry, Data Processing, Excel, Leads, Web Search
Budget: $150 - $300 USD
30-Oct-2025
17:38 GMT
Affordable Luxury Brand Development
Category: Brand Management, Branding, Creative Design, Graphic Design, Logo Design, Marketing Strategy, Photoshop, Slogans
Budget: ₹600 - ₹45000 INR
30-Oct-2025
17:04 GMT
Create Labelled Data and the LLM Image Model
Category: AI Model Development, Data Collection, Image Processing
Budget: $750 - $1500 USD
30-Oct-2025
17:04 GMT
One way video call Course Consultation
Category: Graphic Design, Illustration, Instagram, Photo Editing, Photogrammetry, Smart Phone / Tablet Apps, Video Broadcasting, Video Editing, Video Streaming, YouTube Video Editing
Budget: $10 - $48 USD
30-Oct-2025
17:04 GMT
Image-Led Facebook Growth Management
Category: Photoshop, Canva, Content Creation, Facebook Marketing, Graphic Design, Internet Marketing, Social Media Management, Social Media Marketing
Budget: $2 - $8 USD
30-Oct-2025
17:03 GMT
GOHIGHLEVEL - EXPERTO PARA GESTIONAR PROYECTO GHL - (ONLY SPANISH SPEAKERS)
Category: Automation, Automation Codeless Program, ChatGPT AI Integration, Influencer Marketing, Internet Marketing, N8n, OpenAI, Process Automation, Programming Help, Zapier
Budget: $30 - $250 USD
30-Oct-2025
17:03 GMT
Posts Instagram para Assessoria Acadêmica
Category: Photoshop, Content Creation, Graphic Design, Illustration, Instagram Marketing, Logo Design, Social Media Marketing
Budget: €30 - €250 EUR
30-Oct-2025
17:03 GMT
Resolve Website Frontend Layout Issues
Category: CSS, Frontend Development, HTML, JavaScript, React.js, UI / User Interface, Web Design, Web Development
Budget: $8 - $15 USD
30-Oct-2025
17:03 GMT
Hiring Yoga Trainer for online startup
Category: Content Creation, Motivational Speaking, Nutrition, Public Speaking, Social Media Management, Social Media Marketing, Video Conferencing, Yoga
Budget: ₹750 - ₹1250 INR
30-Oct-2025
17:03 GMT
French Fashion Retail Lead Generation
Category: Data Entry, Email Marketing, Excel, Lead Generation, Market Research, Social Media Marketing, Web Scraping, Web Search
Budget: €250 - €750 EUR
30-Oct-2025
17:03 GMT
Animated Brand Explainer Video
Category: 2D Animation, After Effects, Animation, Blender, Commercials, Video Editing, Video Services, Voice Over
Budget: ₹1500 - ₹12500 INR
30-Oct-2025
17:02 GMT
Extract mobile.de Dealers
Category: Data Analysis, Data Cleansing, Data Collection, Data Entry, Data Management, Data Processing, Excel, JavaScript, PHP, Web Scraping
Budget: $10 - $30 USD
30-Oct-2025
17:02 GMT
Short TikTok Promos for AI Academy
Category: Animation, Caricature & Cartoons, Content Creation, Graphic Design, Illustration, Kinetic Typography, Video Editing, Video Production
Budget: $10 - $30 USD
30-Oct-2025
17:02 GMT
Twitter Hesabı Kurtarma Yardımı
Category: Account Management, Data Protection, Internet Marketing, Link Building, Risk Assessment, Security, Social Media Management, Technical Support
Budget: $50 - $100 USD
30-Oct-2025
17:02 GMT
Text Document Formatting & Data Entry
Category: Copy Editing, Data Entry, Excel, Google Docs, Microsoft Word, PDF, User Story Writing, Word
Budget: ₹100 - ₹400 INR
30-Oct-2025
17:01 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)

Long URL:
www.1001freelanceprojects.com
Mobile version:
m.1001fp.com
Copyright © 2005-2024 1001 Freelance Projects