
Open
Posted
•
Ends in 9 hours
Paid on delivery
I need a Google Sheet that lets me price jobs by square meter and keeps the workflow clear for one admin (me) and one standard user. Admin side – I must be able to adjust or add new square-meter rates at any time. PRICING LOGIC (PER LINE ITEM) All main components are priced per m². Final price per m² = Design + Material + Color + Glass + Screen (if selected) Line m² = Width × Height Unit Price per item = (Line m² × Final price per m²) + Key Lock (if selected) Line Total = Unit Price × Quantity Key Lock is a fixed price per piece and is multiplied by Quantity. PROJECT TOTAL CALCULATION Subtotal = Sum of all line totals INSTALLATION LOGIC (PROJECT LEVEL) Installation is optional (Yes / No). If Yes:System detects all materials used in the [login to view URL] the highest installation price per m² among [login to view URL] it to total project m². Installation = Total m² × Highest Installation Rate DELIVERY LOGIC (PROJECT LEVEL) User inputs distance in km. If distance ≤ 30 km → Delivery = 0If distance > 30 km → Delivery = Total km × Rate – I need full visibility of every quotation and every customer record. – I should also control the user’s access level, deciding when the user can edit an individual quotation. User side – The user will enter new quotation requests through a simple, guided input section. – They can open a read-only history of their previous quotations at any time. – When I grant permission, they may edit their own quotation; otherwise the sheet stays locked for them. Structure ideas I have in mind • One clean data table that stores all quotations. • A protected rate table visible only to admin. • A front-end entry form or neatly laid-out input sheet for the user. • Filters or a lightweight dashboard so I can quickly search and review quotes. You’re free to use Apps Script, protected ranges, or any other native Google Workspace tools as long as the end result is easy for me to maintain. Share the finished file with clear notes on where to update rates and how to toggle user permissions.
Project ID: 40374094
29 proposals
Open for bidding
Remote project
Active 2 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
29 freelancers are bidding on average $31 USD for this job

Hello, With my expertise in JavaScript and my extensive experience in web design and development, I believe I am the ideal candidate to create your Google Sheet Quotation system. I understand the complexities of your project and the importance of maintaining an easy-to-use system for both you and your users. Leveraging on native Google Workspace tools, like Apps Script and protected ranges, I will ensure a streamlined workflow that is highly flexible and maintainable. My team and I have a track record of delivering high-quality web-based solutions that meet specific business needs. We are confident that we can implement your project successfully by developing a data table structure that efficiently tracks all quotations, while maintaining tight control over access permissions for you, as the admin, and individual users. Ultimately, our goal is to provide you with a 'WOW' experience by transforming your vision into a practical, efficient solution that will give you full visibility over every quotation and customer record. Whether it's creating a protected pricing module or crafting a user-friendly front-end entry form or dashboard for quick search, we are ready to turn your dreams into a reality that will elevate your business to new heights. Thanks!
$30 USD in 1 day
7.9
7.9

I can build a Google Sheets pricing system with full admin control, guided user input, and automated m²-based calculations exactly as specified. Includes: • Full pricing logic (Design + Material + Add-ons, Installation, Delivery) • Role-based access using protected ranges + Apps Script (edit control per quote) • Searchable quote database + dashboard view Delivered with clear instructions for updating rates and managing permissions. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.
$100 USD in 1 day
6.3
6.3

With over 12 years of experience as a Full Stack Developer, I can seamlessly navigate the intricacies outlined in your project. My skills in JavaScript and Software Architecture, along with my proficiency in web development tools like React, Node.js, PHP, Laravel, and data manipulation including excel automation make me your ideal candidate. Your vision of a Google Sheet that streamlines the process of pricing jobs by square meter is aligned with my expertise. Understanding that the heart of your request involves secure, adaptable conditional formulas, I plan to combine front-end entry form backed by an intelligently designed backend logic. While I design a clean data table to house all quotations for easy accessibility and overviews, I’ll create a separate rate table to be visible only to you. This attention to security extends further into clear user-permissions that you’d maintain. Not just this, but aided by frameworks like REST and GraphQL I’ll ensure that every piece of information is returned to you with utmost visibility.
$20 USD in 2 days
5.8
5.8

Hi there, I see you need a Google Sheet to streamline your quoting process by calculating job prices based on square meters while allowing you control over user access. It sounds like creating a clear structure with an easy-to-use interface for both you and the user is key. I would approach this by building a robust data table for quotations, a protected rates table for your admin use, and a user-friendly front-end for input. With my 4+ years of experience in Google Sheets and automation, I can ensure that your requirements for visibility, control, and user permissions are met effectively. I'm curious about how often you expect to update the square-meter rates and if there are specific materials or conditions that should be considered for the installation logic. Best regards, Arslan Shahid
$10 USD in 1 day
5.0
5.0

Hello, I’d be happy to build this Google Sheet for you. I have experience creating Google Sheets systems with pricing logic, protected areas, user/admin workflows, and Apps Script automation, and I can turn your process into a clean, reliable quoting tool that is easy to use and easy to maintain. I can build: • a simple user input sheet for creating quotations • an admin-only rate table where you can update pricing anytime • full calculation logic for m² pricing, key lock, installation, delivery, subtotal, and project total • an admin dashboard / searchable quote log • user permission control so you decide when a quotation is editable • protected history view so the user can review past quotations without changing them The final system will be structured, practical, and easy to manage, with clear notes showing: • where to update rates • how to grant or remove edit access • how the formulas and automation work I can deliver a professional solution using Google Sheets + Apps Script + protected ranges with a smooth workflow for both admin and user. I’m ready to start immediately. Best regards.
$50 USD in 7 days
4.9
4.9

Hi there,I am a Data Scientist is a professional responsible for extracting actionable insights and knowledge from large volumes of data GOOGLE SHEET Development. I can write clean Google Sheet,Google Excel Sheet, Power BI, Outlook and Google VBA macros. Google sheet: Advanced Array Formulas, Charts, Pivot Tables, Pivot Charts, Mail Merge, VBA Macros, Excel Macros, Capabilities, Spreadsheets. Email through Outlook and Gmail, Add-in, Customized Macros. My top priority is to provide a high quality of work, I am willing to fully devote my time and energy to improve the service offered, with timely, accurate and professional results, building trust and a long term relationship with customer is my main objective. https://www.freelancer.com/u/GdevDataSceince Let's discuss this further via chat, and I'll start your project right now. Thanks Gdev
$20 USD in 7 days
5.0
5.0

Hi there! You are building a Google Sheets quoting system and the real challenge is combining layered pricing logic with role-based access so the admin controls rates while users only interact with a clean input flow. I recently built a Google Sheets automation tool with Apps Script that handled multi rule pricing, protected admin tables, and user level permissions, reducing quoting errors and improving processing speed through structured validation. I will design a clean quotation engine in Google Sheets with dynamic m² calculations, admin controlled rate tables, automated installation and delivery logic, plus Apps Script based access control for user and admin workflows. Check our work: https://www.freelancer.com/u/ayesha86664 Do you want the quotation history to be stored only inside Sheets or also exported automatically as PDF for clients? I am ready to start — just say the word. Best Regards, Ayesha
$150 USD in 3 days
4.2
4.2

As an experienced Full Stack Developer, I'm well-versed in Google Workspace tools including Google Sheets and Apps Script, which makes me an ideal candidate for your Google Sheet Quotation project. With over 5 years in software engineering, I have successfully designed and implemented numerous robust, intelligent solutions similar to the one you require in various industries. In particular, my expertise in automation and database management aligns perfectly with your needs. I can create a clean data table that efficiently stores all quotations while ensuring full visibility for you as an admin. Furthermore, I'll design a protected rate table that only you can access, making it easy for you to update or adjust square-meter rates as per your requirement. Additionally, my prior work with user access control will enable me to grant read-only or editable permissions to individual users based on your preference. Furthermore, my AI and intelligent system skills come into play when we consider the complexity involved in the pricing logic which accounts for Design, Material, Color, Glass, Screen and more, where various calculations need to be done using square meters. In this regard, I could utilize my knowledge of OpenAI API and Anthropic (Claude) integration which will generate sophisticated pricing structures. It is worth mentioning that my proficiency in React.js will ensure easy navigation and accessibility for both you as the admin and standard users.
$50 USD in 1 day
4.3
4.3

Hi there, I am A.R.M. MASUD, with a strong data science background. As a Google Sheets Specialist with proven expertise in data organization, automation, and advanced formula creation, I offer efficient and customized spreadsheet solutions tailored to meet your project needs. Whether it's streamlining workflows using Google Apps Script, building dynamic dashboards, or creating error-proof data validation systems, I ensure accuracy, clarity, and functionality. My experience spans budgeting tools, CRM trackers, inventory systems, and analytical reports, all optimized for collaboration and performance. I’m committed to delivering user-friendly, scalable Google Sheets tools that save time and enhance decision-making. https://www.freelancer.com.bd/projects/google-sheets/create-google-sheet-google-studio https://www.freelancer.com.bd/projects/data-entry/Dynamic-Google-Sheets-COGS-Calculator/reviews Thank you for considering your Google Sheets development project. I am confident that my expertise and commitment to excellence will add significant value to your business operations. Thanks A.R.M MASUD
$20 USD in 7 days
4.1
4.1

As an experienced web and mobile developer, my skills span across JavaScript, Python, PHP, HTML/CSS, and many more. This makes me the perfect candidate to bring your Google Sheet Quotation project to life. While the details of your project are intricate, I have a knack for building tools to simplify complex workflows and add functionality that helps everyone involved. Not only will I ensure that your Google Sheet has all the features you need - from adjustable square-meter rates for main components to a thorough calculation of project total including installation and delivery - but I will also create different access levels for admin and standard user to ensure maximum visibility and control. In every project I undertake, my intention is always to grow success alongside my clients' needs while ensuring meticulous attention to detail. And, with 24/7 technical support à la me on standby, you can be 100% confident in my ability to deliver a solution-oriented service every step of the way. Trust me as your Google Sheet aficionado.
$20 USD in 2 days
3.9
3.9

As a full-stack engineer with a solid 6+ years of experience, I'm convinced that I'm the ideal candidate to take on your Google Sheet Quotation project. Throughout my career, I've been relentlessly focused on delivering end-to-end web solutions that are both maintainable and high-performing. I excel at developing clean and robust architecture, which are essential characteristics when developing a tool as intricate as your quotation system. Moreover, I have considerable prior experience in automating business processes and workflow optimization- two key aspects that your project requires. Whether it's integrating with native Google Workspace tools or deploying APIs, I have the technical know-how to bring automation and efficiency to your admin workflow while maintaining simplicity for you to update rates and toggle user permissions. Lastly, my familiarity with data pipelines and analytics will certainly come in handy while organizing and filtering through your sizable database of quotations. All in all, I genuinely believe that working together we can build a solution that specifically caters to your unique needs in an efficient manner. Let's not waste any more time; let's get started on revolutionizing the way you quote your projects!
$20 USD in 7 days
3.5
3.5

Hi, I will create a Google Sheet tailored to your pricing requirements with clear workflows for both admin and user roles. The sheet will allow you to adjust square-meter rates dynamically, implement your pricing logic, and manage user permissions effectively. With my experience in creating customized Google Sheets and leveraging Apps Script, I’ll ensure that the pricing structure is robust and intuitive. I’ll design a clean data table for quotations, a protected rate table for your exclusive access, and a user-friendly input form for the user to submit requests. Filters and a dashboard will provide you with quick visibility into all quotations. Could you clarify if you have specific rate structures in mind for the different materials? Also, do you have any preferences for the layout of the user input section? I’m ready to start immediately and deliver a solution that meets all your requirements seamlessly. Thank you.
$21.50 USD in 7 days
3.0
3.0

Hi There, I can build a Google Sheet with per m² pricing logic, admin-protected rate tables, and a guided user entry form so you have full visibility and control over each quotation while letting the right users edit only what you allow. I’ve implemented similar Google Sheets solutions with Apps Script, protected ranges, and dashboards for real-time quoting, rate management, and audit-friendly history tracking. Expect clean data tables, a front-end entry sheet for users, and a secure, easy way to toggle permissions. For your project, I will set up the data model, automate pricing and totals, implement admin protections for the rate table, and create a lightweight dashboard to search and review quotes. Could you share how you’d like to handle rate updates and permission rules for the admin vs user roles? Could you share the current rate update process or preferred permission rules so I can tailor it to your workflow? Best regards, Chibike
$25 USD in 6 days
2.6
2.6

Hi there, I’ve read your brief and can build a clean, maintainable Google Sheet that prices jobs by m², preserves a single-admin workflow, and gives the standard user a simple guided input form. I’ve implemented similar systems using LLMs for guidance, Transformers-based classification for tagging items, chat UI prototypes, and vector-search for quick lookups, more importantly I understand the full pipeline from data design to Apps Script automation and secure sharing. I will create: a protected rate table editable only by you; a single quotations data table; a user entry front-end with read-only history; Apps Script to enforce install/delivery logic, compute line and project totals, and toggle per-quote edit permission. I’ll document where to update rates and how to manage permissions. How many user accounts will need edit rights and roughly how many quotations do you expect per month? Best regards, Cindy Viorina
$10 USD in 3 days
2.5
2.5

Hi, I've reviewed your detailed requirements for a Google Sheet quotation system that balances admin control with user accessibility. I have practical experience designing and deploying workflow solutions using Google Sheets integrated with Apps Script to handle dynamic rate adjustments, conditional pricing logic, and user permission management effectively. I will build a clean, centralized data table for all quotations, set up protected rate tables accessible only by you, and develop a guided input front end for users. Leveraging Apps Script, I’ll implement your pricing formulas and control edit rights at the quotation level to keep your workflow clear and secure. The dashboard and filters will help you quickly review and manage quotes with full visibility. I will deliver this with clear documentation on rate updates and user management, making it straightforward for ongoing maintenance. Let’s plan for an initial working version within a few days, ensuring smooth iteration based on your feedback. Could you clarify how many different installation rate tiers you expect and whether those rates vary frequently? Thanks, Fabian
$15 USD in 1 day
2.3
2.3

As a seasoned Full Stack Developer with over 5 years of experience, I am well-versed in crafting robust and scalable web applications that align perfectly with your project's vision. Utilizing my expertise in JavaScript, which is essential for any Google Workspace automation, I can create an efficient and user-friendly Google Sheet that fulfills all your requirements. With my knowledge of Google Apps Script along with protected ranges and native tools available in Google Workspace, I can design an intuitive UI for both the admin and standard user to ensure maximum functionality without sacrificing ease of use. Additionally, my skills in Data Entry guarantee meticulousness and accuracy while designing the clean data table storing all quotations you envisioned. What sets me apart from others is my ability to provide seamless integrations - ensuring your proposed design’s factors such as rate updates and user permissions toggle are easily manageable. I understand the significance of clear communication and prompt issue resolution when working on such critical projects; hence, you can trust me for uncompromised quality, timely delivery, and 100% client satisfaction.
$50 USD in 7 days
2.0
2.0

Hi there, With over 5 years of experience in Google Sheets, Apps Script, and workflow automation, I can absolutely build a structured quotation system that handles your pricing logic and user control requirements. I will deliver a clean, reliable sheet that allows accurate m²-based pricing, clear separation between admin and user roles, and a smooth workflow for creating and managing quotations. To proceed, I’ll start by designing the data structure including a central quotations table, a protected pricing table, and a user-friendly input sheet. Then I will implement all pricing logic including per line calculations, project subtotal, installation rules based on highest material rate, and delivery calculation based on distance. After that, I will set up user permissions with protected ranges and Apps Script controls to manage edit access, followed by building a simple dashboard with filters for quick quotation tracking and review. The final solution will be easy to maintain, fully documented, and ready for immediate use with clear instructions on updating rates and managing user permissions. Looking forward to working with you.
$20 USD in 3 days
1.7
1.7

Hello, With my expertise in Automation, Data Management and JavaScript, I am well-equipped to create an efficient and intuitive Google Sheet solution tailored perfectly to your needs. My ability to effectively utilize native Google Workspace tools such as Apps Script and protected ranges will ensure that you have a robust system that is easily maintainable in the long term. Throughout my career, I've successfully created bespoke systems for many clients. For instance, I built a sophisticated AI-powered Fitness Coaching App and SAT/ACT prep platform, both demanding projects with a need for complex data management - similar to your own project. Thus, I have the desired level of skill required to design your "clean data table” quotations archiving system and implement the workflow you envision. Being attentive to security needs, I can ensure only authorized personnel are able to access privileged information while your customers effortlessly navigate their read-only history. Additionally, my experience with RAG systems within construction, legal, and energy sectors lend me insight into keeping thorough records. In conclusion, I'm confident that my breadth of experience and skillset make me a perfect fit for your Google Sheet Quotation project. Let's discuss your idea further. Thanks!
$10 USD in 6 days
0.0
0.0

Hello, I reviewed your requirements carefully and I understand the pricing logic and workflow you want to build. The way you structured the calculation, especially selecting the highest installation rate across materials, is clear and I can implement it accurately. I have experience working with Excel and Google Sheets to build structured and automated systems. I can create a clean setup where all line item calculations, project totals, installation, and delivery rules are handled automatically and remain easy to follow. I will organize the file into a main quotation table, a protected rate table that you can update anytime, and a simple input sheet for the user. The goal is to keep everything clear, practical, and easy to use on a daily basis. I can also set up permissions so you control when the user can edit quotations, while keeping a read only history always available. I focus on building systems that are accurate but also simple to maintain. I would be happy to start working on this. Best regards, Samar Amer
$30 USD in 7 days
0.0
0.0

Hi, I can handle your MicroStrategy ONE upgrade end-to-end and ensure a smooth transition with improved performance. With strong experience in data platforms and BI tools, I’ll review your current 19.4 setup, execute a controlled upgrade, and validate performance to meet or exceed existing benchmarks. Post-upgrade, I’ll design five fully responsive dashboards using native MicroStrategy tools—integrating charts, grids, and maps with role-based security and live data connections, all aligned with your brand guidelines. You’ll also receive a clear handover guide for ongoing use and scalability. Available to start immediately—let’s align on timeline and environment details.
$15 USD in 1 day
0.0
0.0

pattaya, Thailand
Payment method verified
Member since Jan 21, 2021
$30-250 USD
$10-30 USD
$10-30 USD
$10-30 USD
$10-30 USD
$15-25 USD / hour
₹1500-12500 INR
₹1500-12500 INR
₹12500-37500 INR
₹100-400 INR / hour
£250-750 GBP
€8-30 EUR
$30-250 USD
₹12500-37500 INR
$2-8 USD / hour
$10-30 USD
₹750-1250 INR / hour
$8-15 USD / hour
₹75000-150000 INR
$30-250 USD
₹1500-12500 INR
₹100-400 INR / hour
₹12500-37500 INR
$30-250 NZD
$250-750 USD