1001 Freelance Projects
Latest Projects from Freelance Marketplaces
Today is: 03-Oct-2025 19:46 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
MAKE THE CHATGPT- CODED SOCIAL MEDIA APP WORKI. !! -- 6
Category: Android, API, App Development, ChatGPT, HTML, IPhone, Mobile App Development, PHP
Budget: $30 - $250 USD
03-Oct-2025
16:04 GMT
Machinery Diagnostics Project
Category: Data Analysis, Data Analytics, Data Science, Finite Element Analysis, Machine Learning (ML), Mechanical Engineering, Project Management, Python, Signal Processing, Software Development
Budget: min $50 USD
03-Oct-2025
16:03 GMT
Machinery Diagnostics Project -- 2
Category: Data Analysis, Data Analytics, Data Science, Finite Element Analysis, Machine Learning (ML), Mechanical Engineering, Project Management, Python, Signal Processing, Software Development
Budget: min $50 USD
03-Oct-2025
16:03 GMT
Typesetting & Map Design for Historical Fiction
Category: Adobe Illustrator, Adobe InDesign, ArcGIS, Book Design, EBook Design, Graphic Design, Illustration, Photoshop
Budget: $750 - $1500 CAD
03-Oct-2025
16:03 GMT
3D Video Creation of Washing Machine -- 2
Category: 3D Animation, 3D Modelling, 3D Rendering, Solidworks, Video Services
Budget: $250 - $750 USD
03-Oct-2025
16:03 GMT
MSW Mental Health Research Writing
Category: Academic Writing, Editing, Proofreading, Research, Research Writing, Word Processing
Budget: $25 - $50 USD
03-Oct-2025
16:03 GMT
2D Motion Graphics Explainers Needed
Category: 2D Animation, 2D Animation Explainer Video, 3D Animation, After Effects, Animation, Motion Graphics, Sound Design, Video Production
Budget: $10 - $30 USD
03-Oct-2025
16:02 GMT
Upbeat Country Love Song writing
Category: Audio Engineering, Audio Production, Audio Services, Music, Music Production, Sound Design
Budget: ₹12500 - ₹37500 INR
03-Oct-2025
16:02 GMT
Setup Proxy Server on VPS for Browser App
Category: Cloud Computing, Firewall, Linux, Network Security, System Admin, VPS, Web Security, Windows Server
Budget: ₹1500 - ₹12500 INR
03-Oct-2025
16:01 GMT
Boost Merch One Product Sales
Category: Advertising, Content Creation, Conversion Rate Optimization, Digital Marketing, Facebook Marketing, Google Ads, Internet Marketing, Social Media Marketing
Budget: $250 - $750 USD
03-Oct-2025
16:00 GMT
Modern Custom Kitchen & Closet Designs Website
Category: 3D Design, 3D Modelling, 3D Rendering, Architectural Rendering, AutoCAD, Building Design, Building Information Modeling, Interior Design, SketchUp, Web Design
Budget: $30 - $250 USD
03-Oct-2025
16:00 GMT
Ghost Voiceover Comfort Project
Category: Audio Editing, Audio Production, Audio Services, Commercials, Creative Writing, Script Writing, Sound Design, Voice Acting, Voice Over, Voice Talent
Budget: $10 - $30 USD
03-Oct-2025
16:00 GMT
Subtle Portrait Photo Retouching
Category: Color Grading, Digital Art, Graphic Design, Image Processing, Photo Editing, Photo Retouching, Photoshop, Photoshop Design
Budget: $2 - $8 USD
03-Oct-2025
16:00 GMT
Nova RPG Theme CSS Tweaks
Category: CSS, Frontend Development, HTML, JavaScript, PHP, UI / User Interface, Web Design, Web Development
Budget: £10 - £20 GBP
03-Oct-2025
16:00 GMT
Text File Editing Database
Category: Database Design, Database Development, Database Programming, MySQL, PHP, PostgreSQL, Relational Databases, SQL
Budget: $8 - $15 USD
03-Oct-2025
15:59 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