
In Progress
Posted
Paid on delivery
I need a Google Sheets file that mirrors the quoting logic from a current web-based quoter. I will be typing the input values by hand, after which the sheet should run a set of advanced formulas—think nested IFs, LOOKUPs, array calculations, or any other complex functions you deem best—to return one final quoted figure in a clearly labeled cell. The results has to be compared to those of the web based quoter. The structure of the file must stay tidy and easy for non-technical teammates to follow, with protective formatting on any formula cells. Please document the key formulas inline (brief comments are fine) so future tweaks are straightforward. The formula part has to be in a special sheet, so we have the plenty of space to create more modifications. The formula can be changed (change of price year per year or increase because of inflation) easily using cell names instead of column-row naming convention. Once complete, I will test the sheet against several real quotes from the web system; the single output value needs to match every time for the job to be accepted. This is simple, I require ONLY to be 2 to 4 layers only (not the rest) (more simple) tip: The shipping calculator uses the average weight of the pcb (google it) The GUI (formating) has to be user friendly. This is the reference: [login to view URL]
Project ID: 40385886
24 proposals
Remote project
Active 21 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

As an expert in Google Sheets and an advocate for the automation of manual processes, I am confident that I can provide you with a highly functional and user-friendly solution for your quoter calculator project. My proficiency in advanced functions, such as nested IFs and LOOKUPs, aligns precisely with your needs. I fully understand the emphasis on simplicity and would ensure that the formulae in the sheet are designed to be easily adjustable using cell names instead of traditional column-row naming conventions. Moreover, keeping your non-technical teammates in mind, I'll structure the file in a tidy, easy-to-follow manner with clear cell labels and including as much protective formatting as possible. This will promote a streamlined and efficient experience for all users. You can trust me to meticulously document the key formulas inline so even future tweaks processes stay straightforward. Lastly, quality assurance is critical and I truly understand its value. To guarantee utmost accuracy, I will thoroughly test my solution against live quotes from the web system, ensuring that every output value aligns consistently. My commitment is not just to deliver a product but to deliver one that meets your precise requirements and exceeds expectations. Rely on my skills to eliminate manual work and create a robust quoting mechanism
$60 USD in 3 days
5.3
5.3
24 freelancers are bidding on average $24 USD for this job

As an experienced and highly skilled data analyst, I am confident that I possess the abilities necessary to create a Google Sheets calculator that can effectively mirror the quoting logic of your current web-based quoter. My expertise in advanced functions like nested IFs, LOOKUPs, and array calculations make me well-equipped for the task and give me an edge when compared to other candidates. Moreover, a key aspect of my approach is prioritizing simplicity, clarity, and user friendliness in my projects. I understand the importance of maintaining a neat structure while making complex formulas behind the scenes. Thus, I will ensure that your Spreadsheet remains tidy even with the most sophisticated calculations. Additionally, I have exceptional skills in documenting formulas clearly for future modifications, which will be a great advantage in this project. Lastly, I am familiar with web scraping which will allow me to compare and verify the accuracy of the quoted results from your web system. Meeting this requirement is crucial for job acceptance, and I am committed to ensuring consistency between both systems. Choose me to get a reliable, comprehensive Google Sheets Quoter Calculator that doesn't just perform flawlessly but also remains user-friendly even for your non-technical teammates. With my skill set and dedication to quality workmanship, you can trust your project is in good hands!
$29 USD in 1 day
7.7
7.7

Hello Client, I hope you are doing well. I came across your project **Google Sheets Quoter Calculator**, and it immediately caught my interest. Based on your description, I’m confident that I can deliver high-quality results that align perfectly with your expectations. **Why I’m a great fit for this project:** • I have strong experience working with Data Entry, Excel, Google Sheets, Data Analysis, Financial Modeling, Data Management, Documentation, and I’ve completed similar projects in the past. • I always focus on clean, optimized, and fully functional work. • Communication and responsiveness are my top priorities — you’ll always be updated on progress. **What I will deliver:** • A complete and professional solution tailored to your project requirements • Timely delivery within your budget range of **10.00 - 30.00 USD** • Clean, well-structured work with revisions included • A focus on quality, clarity, and long-term reliability If you would like to discuss your project further, I’m available at any time. I would love the opportunity to work with you and help bring your idea to life. Thank you for considering my proposal. I look forward to working with you! Best regards, Nadeem Shaikh
$20 USD in 3 days
6.6
6.6

I can build a clean Google Sheets quoting tool that mirrors your web calculator using structured input, protected logic layers, and named ranges for easy maintenance. It will use optimized IF/XLOOKUP formulas, include shipping weight logic, and output a single verified quote matching your system exactly. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.
$30 USD in 1 day
6.5
6.5

I am a data entry specialist with expert knowledge in Ms Excel, R Programming and Python. I have over 6 years of experience in Data Analysis. Do reach out. Thank you.
$30 USD in 1 day
6.2
6.2

Hey, I can build a clean, user-friendly Google Sheets file that replicates your quoter logic with accurate results. I’ll structure it with a simple input area, a separate formula sheet using named ranges (no messy cell references), and a clearly labeled final output. Formulas will be kept within 2 4 logical layers, fully documented with comments, and protected to avoid accidental changes. I’ll also ensure the results match your web-based quoter through testing. Easy to use, easy to maintain. Suzon
$20 USD in 1 day
6.3
6.3

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.2
5.2

I can build a clean, user-friendly Google Sheets quoter that mirrors the essential 2–4 pricing layers of your web-based calculator, with protected formula cells, named ranges, and a separate logic sheet for easy future updates. I’ll structure it so non-technical teammates can use it confidently, and I’ll calibrate the formulas against your real web quotes until the final output matches consistently. Ready to start right away and deliver a tidy, well-documented sheet that is simple to maintain and easy to expand later.
$15 USD in 1 day
4.9
4.9

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.5
4.5

Hello, As a result of a detailed review of your project requirements, I fully understand the scope and expectations. I have experience recreating web-based pricing logic inside Google Sheets and can build a clean, user-friendly file that matches your quoter outputs exactly. I bring deep expertise in Google Sheets, Excel, data analysis, and financial modeling with over 10 years of experience. One of the key challenges in this type of work is translating complex logic into a simple, maintainable structure, so I would design a clear input sheet, a separate formula engine sheet (using named ranges, LOOKUPs, and controlled IF logic), and a final output cell, ensuring easy updates for pricing changes and full protection of formula areas. I will also implement weight-based shipping logic, keep the calculation limited to 2–4 logical layers as requested, and document key formulas inline for future edits. I have a couple of quick questions. • Do you want the sheet to support multiple quote scenarios (rows) or just one quote at a time? • Should I include a small validation section to compare results directly with your web quoter inputs? I can deliver a fully tested, clean, and easy-to-use sheet that matches your reference results. Best regards, Carlos
$20 USD in 3 days
3.7
3.7

Hi there, I can build a clean Google Sheets file that replicates your web-based quoter using structured formulas (IF, LOOKUP, arrays) with a simple 2–4 layer logic as required. I’ll keep the layout user-friendly, separate the formula logic into a dedicated sheet, use named ranges for easy future updates, and protect formula cells. The final output will match the web quoter consistently. I’ll also add brief comments so it’s easy to maintain. Ready to start. Best regards, Avinash
$20 USD in 1 day
3.0
3.0

You need a clean Google Sheets quoter that matches the web calculator, keeps the logic in a separate formula sheet, and stays simple enough for your team to edit year by year. I’ve built Sheets with layered pricing logic, named ranges, protected formula cells, and validation against live quote tools. I’ll recreate the 2 to 4 layer quoting flow in a user-friendly sheet, use named cells for easy price updates, document the key formulas inline, and compare the output against the web quoter to make sure the final figure matches. Let’s talk.
$30 USD in 1 day
2.9
2.9

Hi there! You are building a Google Sheets quoting replica and the real challenge is matching the web calculator exactly while keeping formulas simple, stable, and easy for non technical users to maintain. I recently built pricing and quoting models in Google Sheets for an e commerce supplier where I replicated external calculators using structured lookup tables, named ranges, and controlled formula layers that eliminated manual errors and kept outputs consistent across test cases. I will recreate your 2 to 4 layer logic using clean named ranges, structured input sections, and optimized IF and lookup formulas inside a dedicated calculation sheet so pricing, inflation adjustments, and weight based rules can be updated easily without breaking the system. Check our work: https://www.freelancer.com/u/ayesha86664 What exact input fields and edge cases does the web calculator use so I can ensure every output matches your reference system exactly? I am ready to start — just say the word. Best Regards, Ayesha
$18 USD in 3 days
2.6
2.6

Hello, I’ve reviewed your requirements, and this is a structured logic-building task that I can handle precisely. I can create a clean, user-friendly Google Sheets file that mirrors the quoting logic from your web-based system, with accurate results and simple usability. What I will do: • Rebuild the quoting logic using nested IFs, LOOKUPs, and structured formulas (limited to 2–4 logical layers as requested. • Separate the calculation logic into a dedicated sheet for clarity and future modifications • Use named ranges instead of cell references to make updates (e.g., pricing changes, inflation) easy • Design a simple, clean input interface where users enter values manually • Ensure the final quoted result appears clearly in one labeled output cell • Apply protected ranges to prevent accidental edits to formulas • Add brief inline notes/comments to explain key formulas Validation: I will test the sheet against sample quotes to ensure it matches the web-based quoter consistently. Deliverables: • Google Sheets file (well-structured + protected) • Clear input/output layout • Documented formulas for easy maintenance Timeline: 1–4 days depending on testing rounds I understand the importance of accuracy here—if the numbers don’t match, the sheet fails—so I will focus on precision and clarity. Ready to start. Best regards, Abdi Ladhif
$25 USD in 7 days
2.8
2.8

Hi there, I’ve carefully reviewed your project Google Sheets Quoter Calculator, and I’m excited about the opportunity to contribute. I have 5+ years of experience working with Data Entry, Excel, focusing on delivering high-quality, reliable, and detail-oriented solutions tailored to client requirements. I always take time to understand the core goal of each project so the final outcome is not just completed, but aligned with expectations and practical use. You can view my portfolio here: https://www.freelancer.pk/u/Musab360 I’m currently focused on building strong, long-term collaborations on Freelancer, with an emphasis on quality, consistency, and client satisfaction. I’d be happy to discuss your project further and get started. Best regards, Musab
$10 USD in 1 day
0.0
0.0

Hello Client, My name is Cindy Viorina and I build clear, testable Google Sheets that mirror web quoting logic. I have read your requirements and I will recreate the JLCPCB-style quoter so the sheet returns the same single quoted figure as the web system. I will place all advanced formulas on a dedicated "Formulas" sheet using named ranges, keep logic to 2-4 nested layers, and document key formulas inline with brief comments. Inputs will be on a tidy GUI sheet with protective formatting on formula cells and user-friendly layout. I will use LOOKUPs, array-friendly functions, and simple nested IFs where appropriate, and include a cell-based price-year/inflation control for easy updates. I will calculate shipping using average PCB weights and expose that factor as an editable named cell. I will protect formula cells and leave clear notes so non-technical teammates can follow and tweak the model. I can communicate in real time in your time zone and provide a simple demo or portion of the sheet within 12 hours of starting. Q1: Do you have any special pricing exceptions or tiers not visible in the reference quoter? Q2: Which sample quotes would you like me to test against first so I can reproduce exact results? Q3: Do you prefer specific named ranges or a particular layout for the GUI sheet? Can you provide 2–3 representative quotes from the web quoter (including all input values) for me to validate and match in the sheet? Best regards, Cindy Viorina
$10 USD in 6 days
0.0
0.0

Hey , I just finished reading the job description and I see you are looking for someone experienced in Documentation, Data Management, Excel, Data Entry, Google Sheets, Financial Modeling and Data Analysis. This is something I can do. Please review my profile to confirm that I have great experience working with these tech stacks. While I have few questions: 1. These are all the requirements? If not, Please share more detailed requirements. 2. Do you currently have anything done for the job or it has to be done from scratch? 3. What is the timeline to get this done? Why Choose Me? Deliver high-quality work with a strong focus on accuracy, efficiency, and client objectives. Maintain a proven record of long-term client satisfaction with consistently positive feedback. Earn 5-star ratings on recent projects, reflecting reliability and clear communication. Work with a structured, detail-oriented approach to ensure timely and accurate delivery. Availability: Full-time freelancer with flexible availability and fast response times (Eastern Time). I will share with you my recent work in the private chat due to privacy concerns! Please start the chat to discuss it further. Regards, Ali
$10 USD in 2 days
0.0
0.0

Queretaro, Mexico
Payment method verified
Member since Nov 27, 2013
$30-250 USD
$250-750 USD
$10-30 USD
$30-250 USD
$30-250 USD
$15-25 USD / hour
₹600-1500 INR
$10-30 USD
₹750-1250 INR / hour
$10-30 USD
$250-750 USD
₹1500-12500 INR
$25-50 USD / hour
$30-250 USD
$25-50 AUD / hour
$14-60 NZD
min £36 GBP / hour
$10-30 USD
$30-250 USD
₹12500-37500 INR
$25-50 CAD / hour
$15-25 USD / hour
$25-50 USD / hour
$10-30 USD
$10-30 USD