1001 Freelance Projects
Latest Projects from Freelance Marketplaces
Today is: 04-Aug-2025 07:48 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
Company Sourcing in Guangshui, Hubei, China
Category: Business Analysis, Inspections, Local Job, Photography, Travel Ready
Budget: $20 - $40 USD
04-Aug-2025
04:04 GMT
Danish Language Image Collection via iPhone
Category: AI Development, AI Research, Content Creation, Data Collection, Freelance, Image Processing, IPhone, Photo Anywhere, Photography, Text Recognition
Budget: ₹750 - ₹1250 INR
04-Aug-2025
04:02 GMT
Diseño Arquitectónico
Category: Building Architecture, Drafting, Gardening, Interior Design, Interiors
Budget: $30 - $250 USD
04-Aug-2025
04:02 GMT
Viral Reels Creation & Social Media Boosting -- 2
Category: Content Creation, Facebook Marketing, Social Media Management, Social Media Marketing, Social Networking, Twitter, Video Editing, Viral Marketing
Budget: ₹600 - ₹1500 INR
04-Aug-2025
04:00 GMT
National Market SEO Optimization
Category: Content Writing, Internet Marketing, Keyword Research, Link Building, Marketing, SEO, SEO Auditing, SEO Writing
Budget: $30 - $250 USD
04-Aug-2025
04:00 GMT
Contract Drafting for Securing Commissions, Salary, and Expenses
Category: Contracts, Legal, Legal Research, Legal Writing, Patents
Budget: $50 - $100 USD
04-Aug-2025
03:58 GMT
Classic Black and Gold Logo Design
Category: Adobe Illustrator, Photoshop, Banner Design, Branding, Graphic Design, Logo Design, YouTube
Budget: ₹600 - ₹1500 INR
04-Aug-2025
03:58 GMT
Design Edgy Gym Clothing
Category: Fashion Design, Graphic Design, Logo Design, Product Development, Sketching, T Shirts, Textile Design, Urban Design
Budget: $30 - $250 AUD
04-Aug-2025
03:56 GMT
E-commerce WordPress Site Development -- 2
Category: HTML, PHP, SEO, Web Design, WordPress
Budget: ₹1500 - ₹12500 INR
04-Aug-2025
03:54 GMT
Urgent Blender 4.4 3D Animator for Music Video (Short)
Category: 3D Animation, 3D Design, 3D Modelling, 3D Rendering, Animation, Blender
Budget: ₹12500 - ₹37500 INR
04-Aug-2025
03:53 GMT
Booking system for a music school
Category: Payment Gateway Integration, Stripe, Web Development
Budget: $30 - $250 USD
04-Aug-2025
03:53 GMT
Product Launch Landing Page with Join Wait list and logo
Category: CSS, Graphic Design, HTML, JavaScript, Logo Design, PHP, Web Design, Web Development
Budget: ₹1500 - ₹12500 INR
04-Aug-2025
03:52 GMT
On-Site GoDaddy Upload Specialist
Category: CSS, GoDaddy, HTML, PHP, Web Development, Web Hosting, Web Design
Budget: $10 - $30 USD
04-Aug-2025
03:51 GMT
Fast-Paced Music Story Reels
Category: A / V Design, A / V Editing, Audio Services, Instagram Marketing, Video Editing, Video Production, Video Services, Videography
Budget: ₹600 - ₹1500 INR
04-Aug-2025
03:48 GMT
RF Notch Filter Design Specialist
Category: Circuit Design, Design Optimization, Electrical Engineering, Electronics, PCB Layout, Product Design, Prototyping, Simulation, Telecommunications Engineering
Budget: ₹12500 - ₹37500 INR
04-Aug-2025
03:48 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