1001 Freelance Projects
Latest Projects from Freelance Marketplaces
Today is: 04-Aug-2025 05:18 GMT
View Project
View this project in detail (Note: you will be redirected to external marketplace)
Project title: Excel to Google Sheets Conversion for Production Planning Tool
Posted by: External project from PeoplePerHour
Started: 29-May-2025 14:24 GMT
Description: Project Scope: Excel to Google Sheets Conversion for Production Planning Tool
We need to convert a complex, multi-sheet Excel-based production planner (with macros and PowerQueries) into a fully functional Google Sheets solution. This is used for tracking furniture manufacturing orders. The new Google Sheets version should replicate all current functionality and also allow for some additional improvements or enhancements.

Key Requirements:
Convert Excel Macros & PowerQueries to Google Sheets-compatible functions (likely using Google Apps Script).
Maintain and recreate existing functionality, including:
Dynamic data entry
Conditional formatting
Automated data movement between sheets
Custom charts and graphs
Gantt charts
Allow for future enhancements or process improvements.



Sheet Breakdown:

SHEET 1: Active Orders
Tracks all current product orders.
Each row = one product SKU in production.
Includes: client details, production schedule, departments involved, tracking for each production stage, and financial graphs.


SHEET 2: Completed Orders
Orders marked complete move here.
Used for historical tracking, performance metrics, and visual analysis (e.g., lead times, dollar value by week).


SHEET 3: Products
Product master list.
Defines production steps per product and expected build times for each department.


SHEETS 4–15: Work Center Sheets
One sheet per production stage (e.g., Parts, Sanding, Finishing).
Pulls relevant orders from “Active Orders”.
Allows team to input actual build times and completion dates, which update back to Sheet 1.


Sheet 16–17: Gantt Charts
Visual schedules by builder for key departments (Custom Shop, Upper Assembly).


Ideal Provider:
Proficient in Google Sheets and Apps Script
Experience with migrating Excel macros to Google Sheets
Understanding of manufacturing workflows is a plus
Project ID: 3434796
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