It seems there might be an issue with the calculations or the script functioning incorrectly. I need someone to address and resolve this problem. Please refer to the explanation below for an understanding of how the spreadsheet scripts/spreadsheet is supposed to operate.
In our spreadsheet system, we have two distinct buttons that perform separate but complementary actions:
Button 1: "Start"
Functionality: When you click on the "Start" button, it triggers a process that consolidates Product IDs (SKUs) totals from Sheets 1, 2, and 3.
Outcome: The result of this action is the creation of a new Sheet 4 showing the totals of sheets 1,2 and 3 on sheet 4. This sheet displays all the SKUs from Sheets 1, 2, and 3, along with their respective totals. Each SKU is listed with the sum of its occurrences or values across the first three sheets.
- - - - - - - - - - - - - - - - - - -
Button 2: "Calculate Totals"
Functionality: The "Calculate Totals" button is designed to perform a comprehensive summing action.
Outcome: Upon activation, it sums the totals from Sheets 1, 2, 3. The final summed totals are then displayed on Sheet 4 (which are sheets 1,2,3). This means that Sheet 4 will show not only the individual SKU totals from the first three sheets but also the combined total of all these values.
Sheet 3 should display a subtotal at its bottom, reflecting the total quantities and inventory $ values of all SKUs listed on it.
Sheet 4, once generated, is designed to present a consolidated total at its bottom and in each matching cell from sheets 1,2,3. This total combines the figures from Sheets 1, 2, 3, and [login to view URL] basically a carbon copy of sheet 3 but with all the totals from all sheets.
Sheet 4 is generated with a label that 'warns not to edit' (Attached)
For inventory value calculations on Sheet 3, each product's price is located in the cell immediately following its respective product cell.
If any cell is 0 the cell is auto-highlighted in light red
We require assistance to rectify the current issues with the sheet so that it functions correctly. Please ensure to test your work thoroughly before submission. Initially, work on a separate version and only integrate it into the live version once it is confirmed to be functioning correctly.
Top 1% in Freelancer.com
Hi, Greetings!
✅checked your project details:
✅Completed Time: In project deadline
We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly.
My Portfolio Items: https://www.freelancer.com/u/schoudhary1553
I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.
Thank you
Sandeep
Hi Hope you are doing good!
I can perfectly help you with that in quick turnaround.
I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project.
Kind Regards
Arun
Hello,
I am an experienced spreadsheet specialist ready to address and resolve the issues with your spreadsheet system. Upon reviewing the detailed explanation of the "Start" and "Calculate Totals" buttons, I understand the desired functionality and the discrepancies you are facing. I will meticulously analyze the script and calculations to ensure proper consolidation of Product IDs and accurate summing actions across Sheets 1, 2, and 3. Highlighting cells with a value of 0 and incorporating the warning label on Sheet 4 will be prioritized for clarity. Thorough testing on a separate version will precede the integration into the live version to guarantee flawless functionality. With a keen eye for detail and a commitment to delivering reliable results, I am confident in my ability to rectify the current issues and optimize your spreadsheet system.
Regards,
Zafar
Hi there! My name is Basanta and I am a native of Odisha, India. I have experience of over 12+ years in different domains in MNCs like IBM, Accenture, Amazon, and Google.
I understand that you need someone to address an issue with your Google Sheet and resolve it. Specifically, it seems there might be an issue with the calculations or the script functioning incorrectly. I can help with this task - I have extensive knowledge in Excel, Google Apps Scripts, Google Sheets and Google Spreadsheets which will help me address this problem effectively. Moreover, my skills include Excel (advanced formula), VBA/Macro, Ms Access, Python and Power BI which will enable me to carry out your project requirements accurately..
I would be delighted if you could give me this opportunity to help you resolve your issue regarding the calculations on your Google Sheet. Please feel free to contact me should you have any questions or queries about my services or this project in general..
Hello there! My name is Saima and I am an experienced Excel expert with 15 years of experience in the field. As part of my job, I am often asked to fix scripts on Google Sheets.
I can assist you in addressing the issues with the Spreadsheet so that it functions correctly.
I look forward to hearing from you soon!
Thanks !
Dear Scott H.,
Hope this message finds you well.
As a seasoned expert in Microsoft Excel, I bring a comprehensive set of skills and experience.
My proficiency includes:
Data Validation and Cleaning;
PivotTables and PivotCharts;
Advanced Formulas and Functions;
Data Visualization; and
Data Analysis;
My dedication to delivering high-quality results, attention to detail, and commitment to meeting deadlines have consistently earned me the trust of clients. I pride myself on my problem-solving abilities and adaptability to various industries and business needs. You can count on me to provide effective solutions and support for your project titled "Fix script on google sheet".
I am reviewing the attached file and let we discuss...
Regard,
Sajid Hussain
Hey,
I am eager to assist in resolving the issue with your spreadsheet system. With expertise in script development and a keen eye for detail, I will meticulously review the logic behind the 'Start' button's script. By implementing effective debugging techniques, checking data consistency, and verifying button click events, I aim to identify and address any discrepancies affecting the correct consolidation of Product IDs (SKUs) from Sheets 1, 2, and 3 onto Sheet 4.
My commitment to ensuring precise calculations and error-free functionality aligns with your project needs. I look forward to applying my skills to enhance the accuracy and efficiency of your spreadsheet system. Let's collaborate to resolve this issue and optimize the performance of your spreadsheet
Hello,
Hope you are doing well. I have gone through your project requirements for fixing app script in google sheet. With my strong background in google app scripting, I am confident in my ability to deliver high-quality results.
I would appreciate the opportunity to discuss your project further and provide any additional information you may require. Thank you for considering my proposal, and I look forward to the possibility of working with you.
Regards,
Naveen Upadhyay
Hi I understand that you need help resolving an issue with your Google Sheet script and I believe I am the best fit for the job due to my extensive knowledge in Excel, web development and data integration.
I specialize in helping businesses turn data into actionable insights so they can achieve their goals efficiently and effectively. With my skillset of Excel, web development and data integration, I am confident that I can provide the necessary solution for your Google Sheet problem.
Hi there,
I develop Google scripts. You can see some examples of my work in my portfolio. I have read your requirements and will be happy to help you with your project
Hi there! Greetings from Wilfred!
I am thrilled to express my strong interest in this Fix script on google sheet project.
With my years of experience working as a freelancer, I have honed my skills in Google Sheets, Excel, Google Spreadsheets and Google Apps Scripts which you indicated are essential for this project.
I am eager to learn more about this project.
Thank you Scott H. for your time.
Hi there! My name is Sachin and I'm your go-to Excel expert for all your data needs. With over 1.5 years of experience in the industry, I specialize in data cleaning, formatting, analysis, and visualization using Microsoft Excel.
I understand that you need assistance to rectify the current issues with the spreadsheet so that it functions correctly. As part of a separate versioning process before integration into the live version, I would be able to effectively address any issues you may have with the script. My expertise in Excel makes me the perfect person for this job - as an experienced freelancer with a proven track record I know how to effectively use Microsoft's marquee software package to produce high quality results.
I'm available to discuss your requirements further if you are interested in hearing more about my skillset or would like me to take on the project at this stage. Please don't hesitate to contact me if you have any questions or would like more information about my services. Thank you for considering me for this position!
Hello there! My name is Shisir and I am a freelance data management expert. I specialize in creating complex spreadsheets that meet the needs of my clients. I have proficiency in using advanced functions to manipulate and analyze data. Additionally, I have experience in creating automated solutions using macros and VBA programming to save time and increase efficiency.
I understand that you are seeking assistance to resolve issues with your Google Sheet script and I believe I am the perfect fit for this project. Additionally, my dedication to providing high-quality work makes me an ideal choice for this project.
I look forward to hearing more about it and discussing further how we can make this project a success! Please feel free to contact me if you have any questions or would like more information about me or my services.
Hello there! My name is Asad Ur and I am a dedicated data maestro. I have worked in the field of data analysis for over a decade and have the skills necessary to help you with your project.
I understand that you are seeking someone to address an issue with your Google Sheet and resolve any issues it might be facing. Specifically, it appears there may be an issue with the calculations or script functioning incorrectly causing issues with the spreadsheet system. My expertise extends across a spectrum of tools and platforms, which makes me well suited to help you with this project. Plus, I am available 24/7 via freelancer messenger so that we can discuss further if needed.
I would love to be part of your project! Please don't hesitate to contact me if you would like more information or want to setup a time to discuss further. Thank you for your consideration!
Hi sir,
I have 8 year experience of Google script.i can properly understand your query I cand done this work within 3 hours. So let get connected to discuss more about the project. I am familiar to use Google sheets and Google products.
I have been working in spreadsheet and appscripts for last 10years locally with small businesses. Have made entire management systems for them using Google sheets and app scripts. Since I am new in Freelancer and am looking for building a good profile here, I am ready to work at reduced rates.
Hey there!
I have reviewed your project description and I have depth knowledge about your project.I can do it in less time, please come to the description box for further discussion.
Dear Hiring Manager,
I am writing to express my enthusiastic interest in the Shopify Customer Support role you have advertised. As a recent graduate with a keen interest in e-commerce and a strong commitment to customer service excellence, I am eager to contribute my skills to your team.
Why Choose Me:
Excellent Written English Skills: With a focus on detail and effective communication, I can ensure a smooth experience for UK customers.
Quick Learner: As a recent graduate, I bring a fresh perspective and a quick learning ability, adapting swiftly to new challenges.
Shift Availability:
I am available for 8-hour shifts per day and am open to considering 4-hour shifts as needed. My commitment to maintaining high standards of service aligns with your requirements for the role.
Compensation Expectation:
I am comfortable with the starting pay of 2000 INR for 25 hours weekly, and I am excited about the opportunity to contribute to your UK-based Shopify stores.
I appreciate your time and consideration of my application. I am eager to discuss how my passion for customer support and dedication can benefit your team. Please find my resume attached for your reference.
Thank you for considering my application.
Sincerely,
Rahul Chaudhary.
8091742407.
Hello there! My name is Muhammad Saad, and I'm a programmer with extensive experience in .Net Framework (C#, .Net Core), Database Scripting (SQL, Oracle), API Integration (ASMX, WCF, REST), C#.
I understand that you need assistance to rectify the issues with the sheet so that it functions correctly. As part of the job description, you require me to ensure thorough testing of my work before submission to guarantee its accuracy.
Saad
