1001 Freelance Projects
Latest Projects from Freelance Marketplaces
Today is: 25-Aug-2025 22:56 GMT
View Project
View this project in detail (Note: you will be redirected to external marketplace)
Project title: Van stock management excel sheet
Posted by: External project from PeoplePerHour
Started: 21-May-2025 08:04 GMT
Description: We need a multi-tab Excel or Google Sheets system to manage van stock, material usage, and restocking across 5–10 mobile traders. Each trader must have a separate tab.

The system must include:
Van Stock Tabs:

One van stock tab per trader

Expected quantity vs current stock

"Used This Week" tracking

Automatic "Restock Needed" flags

Cost per item and calculated weekly cost per trader

Supplier link for each material (optional column with URL to Screwfix/Toolstation)

Usage Log:

Combined Usage Log tab (filled from daily WhatsApp messages)

Columns: Date, Trader, Job ID (optional), Materials Used

Weekly Summary:

Weekly Summary tab showing:

Total materials used per trader

Weekly material costs

Items needing restock

Dashboard Tab:

Overview of all low stock items across all traders

Weekly usage report per trader

Visual alerts for shortages and restocking priorities

Total material cost per week per trader

Color-coded formatting for visibility

Monthly Summary:

Monthly usage totals per trader

Total cost of materials per trader

Most used items per trader each month

Archiving & Reset Functionality:

Ability to reset "Used This Week" every Monday (manually or via button)

Archive tab or export system to save each week’s summary for future reference

Option to refill/recover previous week’s data if needed

Structure & Formatting:

Easy-to-duplicate trader tabs for future team expansion

Protected formulas and locked layout to prevent accidental edits

Google Sheets compatible (no Excel-only features or macros)

Please let us know your availability
Project ID: 3433484
Project category:
Project budget:
View this project in detail (Note: you will be redirected to external marketplace)
Last Projects / Browse Projects
  Project Started
Full Branding Package & Logo Variations
Category: Adobe Creative Cloud, Adobe Creative Suite, Adobe Illustrator, Photoshop, Branding, Graphic Design, Illustration, Logo Design, Typography
Budget: $30 - $250 USD
25-Aug-2025
21:54 GMT
Fix Apartment Plumbing and Fans
Category: Electric Repair, Handyman, Plumbing
Budget: $30 - $250 CAD
25-Aug-2025
21:53 GMT
Synthesia AI-Powered Promo Videos Creation
Category: After Effects, Video Editing, Video Production, Video Services
Budget: $50 - $100 USD
25-Aug-2025
21:53 GMT
Vibrant Homepage Slider Image Design
Category: Photoshop, Creative Design, Graphic Design, Photoshop Design, Visual Design
Budget: $10 - $30 AUD
25-Aug-2025
21:53 GMT
Video Looping and Transparency -- 2
Category: After Effects, Final Cut Pro, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services
Budget: $30 - $250 USD
25-Aug-2025
21:48 GMT
Video Looping and Transparency
Category: After Effects, Final Cut Pro, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services
Budget: $30 - $250 USD
25-Aug-2025
21:48 GMT
Startup Co-Founder Developer Opportunity
Category: Django, Flutter, HTML, Mobile App Development, Node.js, Python, Web Development
Budget: ₹12500 - ₹37500 INR
25-Aug-2025
21:47 GMT
Email Campaigns for Service Sales
Category: Analytics, Content Creation, Copywriting, Email Campaign, Email Marketing, Google Adwords, Internet Marketing, Marketing, Marketing Strategy, Visual Design
Budget: $15 - $25 USD
25-Aug-2025
21:45 GMT
Professional Recreation of Approved Logo
Category: Adobe Illustrator, Photoshop, Digital Design, Graphic Design, Illustration, Logo Design, Print Design
Budget: ₹600 - ₹1500 INR
25-Aug-2025
21:45 GMT
WHMCS Hooks Development
Category: API Integration, Automation, HTML, MySQL, PHP, Software Development, Web Development, WHMCS
Budget: $250 - $750 USD
25-Aug-2025
21:45 GMT
Enhance Existing PWA Design
Category: CSS, Frontend Development, HTML, JavaScript, PHP, Web Design, Web Development
Budget: $30 - $250 USD
25-Aug-2025
21:45 GMT
Fix Zapier-JudgeMe Google Reviews
Category: API Integration, Automation, Google APIs, Google Chrome, JavaScript, PHP, Software Architecture, Zapier
Budget: $15 - $25 AUD
25-Aug-2025
21:45 GMT
Diverse Clothing Brand Development
Category: Fashion Design, Graphic Design, Logo Design, Photoshop, Product Design, Product Development
Budget: ₹12500 - ₹37500 INR
25-Aug-2025
21:44 GMT
AI Trading Pitch Deck Funnel - GO HIGH LEVEL OR CLICKFUNNELS
Category: AI (Artificial Intelligence) HW / SW, ClickFunnels, Graphic Design, Logo Design, Photoshop, Visual Design, Web Design
Budget: $30 - $250 USD
25-Aug-2025
21:44 GMT
PES Format Conversion for Patterns
Category: CAD / CAM, Design Optimization, Digital Design, Embroidery, Graphic Design, Illustration, Pattern Design, Vector Design
Budget: ₹1500 - ₹12500 INR
25-Aug-2025
21:44 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