
Fechado
Publicado
Pago na entrega
I need a fully-tailored Google Sheets workspace that lets my team at Sunrise Steel follow every piece of stock from the day it lands in the yard until the invoice is closed, all without jumping between files. The build has four pillars: • Stock & order control – One master sheet pulls live quantities, adjusts them the moment an order is logged, and flags any SKU that drops below our re-order point. • Automated calculations – Formulas or Apps Script should handle real-time inventory valuation, roll up monthly sales totals, and capture average order-processing time so we see true margins, not guesses. • Interactive dashboards – Clean, manager-friendly views on sales performance, inventory status, and open-order progress, with slicers or drop-downs for quick filtering. • Ongoing upkeep – After launch, I’d like you to tune formulas, archive old data, and add minor enhancements each month so the system stays fast and reliable. Key preferences – Native Google tools only (Sheets, Apps Script, Data Studio/Looker Studio). – Everything lives in my G-Suite drive, no third-party databases. – Clear documentation: tab purposes, key formulas, and a simple “add new product” guide for staff. You’ll deliver the interconnected Sheets, any accompanying scripts, the live dashboards, and the doc. Once I sign off, we move to a light monthly retainer for maintenance and tweaks. If you’ve built similar inventory-order solutions in Sheets and can point to examples, I’m ready to get started.
ID do Projeto: 40175199
30 propostas
Projeto remoto
Ativo há 4 dias
Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
30 freelancers estão ofertando em média ₹21.788 INR for esse trabalho

Hello, I’d be happy to help you with your Inventory Management System requirement. I am a Full Stack .NET Developer with 7+ years of experience, and I already have a production-ready Inventory Management SaaS solution that can be customized and deployed quickly based on your business needs. This approach saves development time, cost, and risk compared to building from scratch. Instead of a basic custom build, I can provide a complete, scalable system with => ✔ Multi-user & role-based access ✔ Product & inventory tracking (stock in / stock out) ✔ Reports & dashboards ✔ Secure authentication The system is already tested and used, and I will customize UI, workflows, and features specifically for your requirements. Technology Stack => Backend => ASP.NET Core / Web API Frontend => Blazor (Web / WASM) Database: => MS SQL Server Architecture => Clean architecture, scalable & secure Hosting: Cloud / VPS / On-prem (as required) Thanks!
₹25.000 INR em 7 dias
4,8
4,8

Hello there, I reviewed your project Custom Google Sheets System -- 2 and understood the requirements at a high level. I focus on delivering clear, stable, and maintainable solutions aligned with the actual scope, I can work with JavaScript, Excel, Inventory Management and follow a clean development process with proper structure and error handling. If this aligns with what you’re looking for, please come to chat to discuss further. Best regards
₹12.500 INR em 7 dias
4,3
4,3

Hi, I can build your custom Google Sheets inventory management system for Sunrise Steel. I have extensive experience creating similar stock tracking and order management systems with Google Sheets and Apps Script. My approach: • Stock & Order Control: Master sheet with live quantity tracking, automated order logging, and SKU alerts for reorder points • Automated Calculations: Apps Script functions for real-time inventory valuation, monthly sales totals, and order-processing metrics • Interactive Dashboards: Clean, manager-friendly views using Google Sheets native features and Looker Studio for advanced visualizations • Documentation: Comprehensive guide with tab purposes, formula explanations, and step-by-step "add new product" workflow Relevant Experience: • Built inventory management systems for multiple clients with automated stock alerts • Created order tracking systems integrated with invoicing workflows • Developed Google Sheets dashboards with real-time KPI monitoring • Expert in Google Apps Script for custom automation and calculations Deliverables: • Interconnected Google Sheets with all four pillars implemented • Apps Script code for automation • Interactive dashboards • Complete documentation • Available for monthly maintenance retainer Bid: ₹25,000 INR Delivery: 7 days Ready to start immediately. Can you share examples of your current workflow? Best regards
₹25.000 INR em 7 dias
3,4
3,4

@SahyadriTech #SahyadriTech Completed Projects: 1. Hotel Booking Management & Tracking System (Excel + VBA Script) 2. Appsheet: ERP system for textile business 3. MNGL Gas Incident Tracker & Dashboard (Google Sheets + Google Data Studio) 4. Daily Expenses Tracker (Google Sheets) 5. Option Scalping Strategy Automation (Excel VBA) 6. Nifty50 Live Option Chain Dashboard (Google Sheets) 7. Binary Trading Sheet (Google Sheets) 8. Customer Data Cleaning & Sorting Tool (Excel VBA & Python) 9. Historical Stock Closing Price Analysis for 2,600 Stocks (Excel & Python) 10. Power Bi dashboard for F1 Car racing insights 11. GOLD Loan tracking in Google sheet and Google Data studio 12. Local Taxi Tracking System (Google Sheets + Google Data Studio) 13. Appsheet Milk Drivers wages and attendance system (Appsheet + Google sheet ) Key Highlights: 1. Pay only if satisfied with the work 2. Expert in Power BI, Excel, VBA Macros, Google Sheets, Google Apps Script, and Python 3. Experience in 3 American MNCs 4. Skilled in Data Analytics, Automation, and Visualization 5. Proficient in Statistical Analysis 6. Offer Long-Term Support for all projects 7. Quick Delivery with multiple revisions I can deliver any project related to Data Analytics, Automation, and Reporting with precision and reliability.
₹25.000 INR em 7 dias
3,0
3,0

Hi — I’ll build Sunrise Steel a single Google Sheets system that tracks stock end-to-end (yard arrival → orders → invoicing) with automated updates, clean dashboards, and a staff-proof workflow. Proposed architecture (4 pillars, one workspace) Core data tabs (source of truth): Products/SKUs (reorder point, unit cost, UOM) Stock Movements (GRN/inbound, adjustments) Orders (order lines, reserve/dispatch logic) Invoices/Payments (status + close date) Automation (Apps Script + formulas): Auto-update on-hand/reserved/available stock when orders are logged Reorder alerts (conditional formatting + optional email) Inventory valuation (FIFO/weighted avg—based on your preference) Monthly sales rollups + average processing time (order → invoice close) Dashboards (Sheets + Looker Studio optional): Inventory health (low stock, aging, valuation) Sales performance (monthly trends, top SKUs/customers) Open orders pipeline (stuck stages, SLA flags) Governance: protected ranges, dropdown validations, error logs, and an archive routine to keep performance fast Scope-lock questions Do you need batch/heat numbers and length/weight handling (steel-specific), or SKU-level only? Valuation method: weighted average vs FIFO? Order flow: do you “reserve” stock at order time, or only reduce stock at dispatch?
₹20.000 INR em 7 dias
3,3
3,3

Hi! ? I can build your Custom Google Sheets system with a connected inventory & order control workflow that tracks stock from arrival to invoicing seamlessly within Google Sheets. I’ll implement real-time formulas or Apps Script to automate inventory valuation, sales roll-ups, average order processing time, and low-stock alerts, plus interactive dashboards with filters and slicers for quick insights. Everything will use native Google tools (Sheets + Apps Script + dashboards) and come with clear documentation so your team can add products or maintain the system easily. I’ll also tune the system after launch for performance and reliability.
₹25.000 INR em 7 dias
2,2
2,2

Dear Hiring Manager, I’d be excited to build a fully tailored Google Sheets workspace for Sunrise Steel that gives your team a single, reliable system to track stock from yard intake through invoicing—without jumping between files or tools. I have solid experience designing end-to-end inventory and order management solutions using native Google tools only, with a strong focus on accuracy, performance, and usability for non-technical teams. Here’s how I would approach your four pillars: • Stock & order control – A central master sheet that updates quantities in real time as orders are logged, with clear re-order alerts and SKU status flags. • Interactive dashboards – Clean, manager-friendly dashboards in Sheets and Looker Studio, with slicers and drop-downs for quick views of sales, inventory health, and open orders. • Ongoing upkeep – Well-structured formulas, archived historical data, and a system designed for easy monthly tuning and enhancements under a light retainer. I’m ready to provide a live demo of similar inventory/order systems I’ve built, or to walk you through a proposed structure before we start. Once you sign off, I’m happy to continue with monthly maintenance to keep everything fast, clean, and reliable. Looking forward to helping Sunrise Steel gain full visibility and control over inventory and orders. Regards M.
₹25.000 INR em 7 dias
1,4
1,4

Hi, this is a great use case for a single, well-architected Google Sheets system instead of scattered files. The setup would revolve around one master inventory sheet that updates stock levels instantly as orders are logged, flags low-SKU thresholds, and feeds all dependent tabs automatically. Native formulas and Apps Script would handle valuation, monthly sales rollups, and order-processing time so margins and performance are always accurate. On top of that, clean Looker Studio dashboards would give managers quick visibility into inventory health, sales trends, and open orders using simple filters and drop-downs. Everything would stay fully inside your G-Suite environment, clearly documented so staff can confidently add products and maintain data. After sign-off, a light monthly upkeep plan would keep things fast, organized, and evolving with your needs.
₹18.000 INR em 5 dias
0,9
0,9

Hi there, I understand your need for a customized Google Sheets workspace for Sunrise Steel to streamline stock and order control seamlessly. Leveraging my expertise in creating dynamic Sheets solutions for inventory management, automated calculations, and interactive dashboards, I am well-equipped to meet your requirements. One key insight: I propose integrating automated email alerts for low-stock items, ensuring proactive inventory management. Let's collaborate to bring your vision to life! Please review my portfolio at [insert portfolio link]. When can we schedule a meeting to discuss further? Looking forward to the opportunity, Zaheer Mahomed
₹23.650 INR em 30 dias
0,0
0,0

Hello, I can build a fully tailored Google Sheets workspace that tracks inventory from arrival through invoicing, all within a single, connected system. Using native Google tools only (Sheets, Apps Script, Looker Studio), I’ll deliver a reliable setup with real-time stock updates, automated calculations, and clear, interactive dashboards for management. I’ll ensure: One master sheet with live inventory control and low-stock alerts Automated valuation, sales rollups, and performance metrics Clean, filterable dashboards for sales, inventory, and open orders Clear documentation so your team can easily add products and maintain accuracy After launch, I’m available for ongoing monthly upkeep, including performance tuning, data archiving, and small enhancements to keep everything running smoothly. If helpful, I can share examples of similar inventory/order systems built in Google Sheets. Ready to get started. Best regards, Bobir
₹14.000 INR em 4 dias
0,0
0,0

Hello, I can build a fully tailored Google Sheets workspace for Sunrise Steel that tracks stock from yard arrival to invoice closure—everything live, interconnected, and managed within your G-Suite environment. My approach covers: 1. Stock & Order Control: A master sheet pulls live quantities, updates them automatically as orders are logged, and flags SKUs below reorder points. 2. Automated Calculations: Real-time inventory valuation, monthly sales roll-ups, and average order-processing times to show true margins. 3. Interactive Dashboards: Manager-friendly dashboards with slicers and drop-downs for quick filtering on sales, inventory, and open orders. 4. Ongoing Upkeep: Post-launch, I’ll tune formulas, archive old data, and implement minor monthly enhancements to maintain speed and reliability. I’ll deliver: interconnected Sheets, any Apps Scripts, live dashboards, and a clear documentation guide including tab purposes, key formulas, and instructions for adding new products. I have experience building similar inventory and order-tracking solutions in Google Sheets and can share examples for reference. I’m ready to start immediately. Best regards, Clinton
₹25.000 INR em 7 dias
0,0
0,0

I’d be excited to build a fully integrated Google Sheets–based inventory and order management workspace for Sunrise Steel that tracks each item from yard entry through invoice closure without requiring your team to switch between files. The system will include a master inventory sheet that updates live quantities as goods are received and orders are logged, with automatic low-stock alerts based on defined reorder points. Using advanced formulas and Google Apps Script, it will calculate real-time inventory valuation, monthly sales totals, gross margins, and average order-processing time so your reporting reflects true business performance. Manager-friendly dashboards will be delivered via Looker Studio, connected directly to your Sheets, showing sales trends, inventory health, and open-order progress with filters for quick analysis. Everything will be built using only native Google tools and stored within your G-Suite Drive, with clear documentation explaining each tab, key formulas, and simple steps for adding new products and daily use by staff. After launch, I can also provide monthly maintenance to archive old data, optimize formulas and scripts, and add small enhancements as your workflow evolves, ensuring the system remains fast, accurate, and scalable. If you want, I can also
₹25.000 INR em 12 dias
0,0
0,0

Hello, I can design and implement a fully customized Google Sheets system as per your requirements. I have hands-on experience in building automated, user-friendly sheets for MIS, tracking, reporting, and workflow management. What I will deliver: Custom Google Sheets structure based on your business process Automated calculations using formulas (IF, QUERY, VLOOKUP/XLOOKUP, ARRAYFORMULA, etc.) Data validation, dropdowns, and error controls Dashboard with charts & summary reports (if required) Google Apps Script automation (email alerts, approvals, auto-updates – optional) User access control & data protection Clear documentation and post-delivery support Why choose me: Strong experience in MIS, reporting, and process automation Practical understanding of business workflows (NBFC, logistics, operations) On-time delivery with clear communication Flexible revisions until you are satisfied
₹25.000 INR em 7 dias
0,0
0,0

I’ve built and managed Google Sheets systems used daily for tracking stock, orders, and sales, and I understand the need for a single, reliable workspace instead of scattered files. For Sunrise Steel, I’ll create one connected Google Sheets system that tracks inventory from receipt to invoice, updates stock automatically as orders are logged, and flags low-stock items. Inventory valuation, monthly sales totals, and order processing time will be calculated automatically using formulas and Apps Script where needed. I’ll also build clean, manager-friendly dashboards for sales performance, inventory status, and open orders, with simple filters for quick views. Everything will use native Google tools and live inside your G-Suite drive. You’ll receive clear documentation explaining each tab, key formulas, and a simple guide for adding new products. After launch, I’m open to a light monthly retainer for ongoing improvements and maintenance.
₹15.000 INR em 7 dias
0,1
0,1

Hi there, I specialize in building fully integrated Google Sheets systems for inventory and order tracking. I can create a single, connected workspace with live stock control, automated calculations, interactive dashboards, and clear documentation, all using native Google tools. I also provide ongoing maintenance and optimization to keep the system accurate, fast, and reliable as your business grows. Looking forward to work with you!
₹25.000 INR em 7 dias
0,0
0,0

As a seasoned pro who's spent countless hours crafting intricate Excel solutions for business needs, I understand the value of a robust, interconnected sheet system. My skills in Sheets and Apps Script make me an ideal candidate to build your custom Google Sheets workspace. Using native Google tools that strictly adhere to your preferences, I guarantee a solution that keeps all your data secure within your G-Suite drive while giving you the flexibility and functionality you require. The pillars of your project- stock & order control, automated calculations, interactive dashboards, and ongoing upkeep- align perfectly with my previous experience. As a creative problem solver, I relish the challenge of building an efficient workflow that will adjust stock levels in real-time, provide live financial insights, simplify filter-friendly dashboard views for managers, and ensure smooth maintenance and enhancements as per evolving needs. My commitment extends beyond delivering the completed project; it continues with my dedication to provide reliable assistance through regular maintenance for seamless day-to-day operations. So if you want a professional who has not only built numerous similar inventory-order solutions but has also focused on creating comprehensible documentation to facilitate staff usage, then I'm your guy. Let's get started on making your work-life significantly easier at Sunrise Steel.
₹25.000 INR em 3 dias
0,0
0,0

You need a fully connected Google Sheets system to track stock, orders, valuations, and dashboards in one workspace using native tools only. I specialize in advanced Google Sheets and Apps Script, building scalable inventory systems with clear documentation and ongoing support. Happy to help Sunrise Steel get this live.
₹30.000 INR em 6 dias
0,0
0,0

Hi, I can build a complete Google Sheets inventory management system for Sunrise Steel with real-time tracking, automated calculations, and interactive dashboards. **What you'll get:** - Master stock & order control sheet with live quantities, auto-adjustments, and re-order alerts - Automated formulas/Apps Script for inventory valuation, monthly sales totals, order-processing metrics - Interactive dashboards (sales performance, inventory status, open orders) with filters - Clear documentation (tab purposes, formulas, "add product" guide) - Monthly maintenance retainer for optimization and enhancements **Technical setup:** - Native Google tools only (Sheets, Apps Script, Looker Studio) - Everything in your G-Suite drive, no external databases - Fast, reliable, manager-friendly interface I've built similar inventory-order systems in Sheets and can share examples. **Timeline:** 4 days for initial build **Budget:** ₹15,000 INR (build) + ₹5,000/month (maintenance retainer) Ready to start immediately! Best regards
₹18.000 INR em 4 dias
0,0
0,0

I specialize in building custom, script-powered ecosystems within Google Workspace. I can deliver a unified "Command Center" for Sunrise Steel that eliminates manual entry and ensures data integrity. The Sunrise Steel Solution I will engineer your four pillars using a robust architecture: Integrated Inventory Engine: A Master SKU sheet using ARRAYFORMULA and custom Apps Script triggers to sync stock levels across "Inbound" and "Orders" tabs instantly. The "Pillar" Calculations: I'll implement rolling inventory valuation (FIFO/Average Cost) and use script-driven timestamps to calculate precise order-processing lead times. Looker Studio Executive Dashboard: A real-time visual layer connected directly to your Sheet, featuring slicers for SKU category, date ranges, and sales rep performance. Admin Documentation: A built-in "Settings & Guide" tab with one-click buttons for archiving data and adding new products. Why Choose This Approach Zero Latency: By optimizing Apps Script for heavy lifting, I ensure the sheet remains fast even as your records grow. Full Ownership: No monthly SaaS fees; you own the code and the data within your G-Suite. Scalability: The architecture is designed to handle thousands of rows before requiring an archive cycle. Feel free to connect so that i can share my sample work.
₹15.000 INR em 3 dias
0,0
0,0

Hello, With my wealth of experience in developing and optimizing scalable solutions, particularly with Google Suite tools like Sheets and Apps Script, I have the exact skill set you need for this project. In addition to my expertise in mobile app development using Ionic and React Native, I have successfully delivered large-scale projects involving real-time inventory tracking, reporting, and data analysis. Examples include a supply chain management system for an e-commerce client which seamlessly handles order control, stock tracking, valuations, and interactive dashboards. My commitment to ongoing upkeep and maintenance aligns perfectly with your project requirements. I understand the importance of the system remaining fast and reliable even after launch. With my detailed documentation skills, I can provide you with a user-friendly guide that explains the purpose of each tab along with key formulas used. This sets up your team for success by facilitating ease of use and future product additions. Lastly, as an AI enthusiast with Python automation skills, I can help further enhance your system efficiency by integrating machine learning models into your inventory management logic. This can enable smarter predictions for reordering and improved forecasts of sales trends. Together, we can create a fully-tailored Sheets workspace that not only meets but exceeds your expectations. Let's get started! Thanks!
₹12.500 INR em 4 dias
0,0
0,0

hisar, India
Método de pagamento verificado
Membro desde out. 13, 2017
₹1500-12500 INR
₹12500-37500 INR
₹1500-12500 INR
₹1500-12500 INR
$30-250 USD
$750-1500 USD
£3000-5000 GBP
₹1500-12500 INR
$5000-10000 USD
€12-18 EUR / hora
₹1500-12500 INR
$10-100 USD
$30-250 USD
₹12500-37500 INR
$10-50 USD
$2-8 CAD / hora
₹600-1500 INR
$5000-75000 USD
$30-250 USD
$10-70 USD
₹1500-12500 INR
$2-8 USD / hora
$30-250 CAD
$30-250 USD