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
Affiliate Partners for Web Hosting Campaigns Category: Affiliate Marketing, Conversion Rate Optimization, Digital Marketing, Google Adwords, Influencer Marketing, Internet Marketing, Sales, Search Engine Marketing (SEM), Web Development, Web Design Budget: $30 - $250 USD
23-Jan-2026 11:04 GMT
Websites Translation Review Category: Czech Translator, Danish Translator, Finnish Translator, French Translator, German Translator, Italian Translator, Norwegian Translator, Polish Translator, Proofreading, Swedish Translator Budget: €250 - €750 EUR
Site e-commerce panier intégrée Category: CMS, HTML, PHP, Prestashop, SEO, Shopify, Web Development, Web Design, WooCommerce Budget: $10 - $30 USD
23-Jan-2026 11:00 GMT
CNC-Ready Folding Doorstep CAD Category: 3D CAD, 3D Design, 3D Drafting, AutoCAD, CAD / CAM, CNC Machine Retrofitting, CNC Programming, Mechanical Engineering, Product Design, Solidworks Budget: ₹600 - ₹700 INR
23-Jan-2026 11:00 GMT
Poster Promosi Acara Menarik Category: Adobe Illustrator, Photoshop, Graphic Design, Illustration, Logo Design, Poster Design, Visual Design Budget: $250 - $750 USD
23-Jan-2026 10:59 GMT
Amazon Listing Optimization Expert Category: Amazon, Amazon Listings Optimization, Amazon Product Launch, ECommerce, Google Ads, Google Adwords, Internet Marketing, Keyword Research, Product Descriptions, SEO Budget: ₹1500 - ₹12500 INR
23-Jan-2026 10:58 GMT
AI-Generated Video for Bausano's Anniversary Category: After Effects, AI Animation, AI Content Creation, AI Design, AI Rendering, AI Generated Video, Animation, Digital Art, Video Production, Video Services Budget: €8 - €10000 EUR
Lead-Focused Wellness Ad Creatives Category: Adobe Illustrator, Photoshop, Banner Design, Graphic Design, Illustration, Lead Generation, Social Media Marketing Budget: ₹600 - ₹1500 INR
23-Jan-2026 10:56 GMT
Bulk PrestaShop CSV Product Upload Category: AI Content Creation, AI Writing, Data Entry, Data Management, Data Processing, ECommerce, Excel, PHP, Prestashop, SEO Budget: €250 - €750 EUR
23-Jan-2026 10:55 GMT
Business Consultation App MVP Build Category: AngularJS, Flutter, JavaScript, Mobile App Development, Next.js, Node.js, Video Conferencing, WebRTC Budget: $30 - $250 USD
23-Jan-2026 10:54 GMT
Phonk Channel Setup & Management Category: Content Creation, Content Strategy, Digital Marketing, Music Management, SEO, Social Media Management, Video Editing, YouTube Budget: $10 - $30000 USD
