Google Sheets script needed.

$30-250 USD

Κλειστή

Αναρτήθηκε

3 μήνες πριν

$30-250 USD

Πληρωμή κατά την παράδοση

I'm searching for a skilled Google Sheets programmer to two write a simple script. This must be an actual script, nothing else will be accepted. I have a Google sheets with two sheets. Sheet 1 - I have six cells with data which changes monthly (G10-G16). These six cells are run through about 5 formulas, and result in calculations into other cells (H45-H48). Sheet 2 - I want to be able to enter data each month into columns (B2-B8, C2-C8, etc). This data (six cells) would basically be transferred to the six cells in Sheet 1 (G10-G16) where the formulas are located and then the resulting calculation cells would come back to Sheet 2 and be displayed in the same column under where the data was entered (B12-B15, C12-C15, etc). I'd like the results to update live when I change numbers in each of the columns. This must be done in a script format so that as I change number, the calculations update (or a button is pressed to update the calculations). This should take a programmer about 1 hour to script. - **Custom Formulas**: Crafting formulas tailored to manipulate numerical data, ensuring calculations are streamlined and precise. - **Macro Development**: Building powerful, automated macros to process dates and numbers, enhancing efficiency and reliability. **Data Types**: - Our primary focus will be on enhancing the handling and manipulation of numerical data and dates, ensuring a seamless workflow. **Timeline**: The project needs completion within a month, demanding a dedicated and efficient approach. **Ideal Skills and Experience**: - Proficient in Google Sheets programming - Robust experience in developing custom formulas and macros - A knack for handling numerical data and date functions - Ability to deliver under tight deadlines This project offers the exciting opportunity to transform our data processing capabilities. If you're driven by challenges and have expertise in Google Sheets, your skills are precisely what we need.

Data Processing

Excel

Software Architecture

Google Sheets

Ταυτότητα εργασίας: 37778449

Σχετικά με την εργασία

67 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 1 μήνας πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

67 freelancers δίνουν μια μέση προσφορά $109 USD για αυτή τη δουλειά

@schoudhary1553

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

$180 USD σε 5 ημέρες

4,9

(649 αξιολογήσεις)

8,6

@AccountantArman

"""""""""""""""""""ADVANCE GOOGLE SHEET & EXCEL EXPERT/GOOGLE SHEET SCRIPT"""""""""""""""""""""""" ""Sir, EXCEL & GOOGLE SHEET are my specialty and I can perform any complex task in THESE. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD in EXCEL Advanced Level Expert. This is my field and I can complete this project with added quality. About me I am a Chartered Accountant with more than 7 years of experience including 4 years from the worlds leading Accountancy and auditing firm ""PWC"" and 1 year working at managerial level in Multination company and 2 years as freelancer. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working as a freelancer from the last 2 years and I have 330+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar "

$99 USD σε 1 ημέρα

4,9

(281 αξιολογήσεις)

7,4

@akritisood94

Building off my extensive experience with complex Excel VBA projects and automation, I have developed a robust command over Google Sheets as well, both in terms of automation and custom formulas. Your project's requirement of transferring data from Sheet 2 to Sheet 1, performing necessary calculations (with live update on demand), and then displaying the resulting values in Sheet 2 again is a perfect match for my expertise. I can confidently say, this task could be easily completed well within an hour. Further, I have a deep-rooted understanding of numerical data manipulation tailored specifically for tasks like yours. Working under tight deadlines has been my forte; however, I never let it compromise the quality of my work. Your project timeline complements perfectly with my approach to deliverables - dedicated and efficient. I am very excited for this project to incorporate your requirements into a seamless workflow. Let us work together to optimize your data management onto another level. Contact me so we can start the journey towards an excellent project!

$140 USD σε 3 ημέρες

4,9

(441 αξιολογήσεις)

7,6

@MartinDudumi

Hello, I am a proficient Google Sheets expert with extensive experience in spreadsheet management and data analysis. I am excited about the opportunity to assist you with your Google Sheets projects and help streamline your workflows. Key Skills and Experience: Proficiency in Google Sheets, including advanced formulas, functions, and data manipulation techniques. Experience in creating custom spreadsheets for various purposes, such as project tracking, budgeting, and data visualization. Strong organizational skills and attention to detail to ensure accuracy and efficiency in spreadsheet management. Ability to collaborate with team members and stakeholders to understand project requirements and deliver solutions that meet their needs. Familiarity with Google Workspace tools and integration capabilities to enhance productivity and collaboration. I am committed to delivering high-quality results and providing reliable support for your Google Sheets projects. Thank you for considering my bid, and I look forward to the opportunity to work with you. Best regards, Martin Dudumi

$120 USD σε 1 ημέρα

5,0

(55 αξιολογήσεις)

6,2

@kmpal

Hi, I am interested to work on this task, I am an expert developer with vast experience. Kindly discuss/share details. Thanks and regards. Khalid

$250 USD σε 10 ημέρες

4,9

(35 αξιολογήσεις)

5,7

@sonarkaushik

Dear Client, I am writing to express my interest in collaborating with you on your project posted in Freelancer. Based on the project details provided, I assure you that I have the skills and expertise required to deliver high-quality work within the specified timeframe. I am confident in my ability to deliver exceptional results for your project. I am committed to maintaining open lines of communication, delivering on time, and ensuring your complete satisfaction. Waiting to hear from you. With thanks regards

$99 USD σε 2 ημέρες

4,7

(62 αξιολογήσεις)

5,9

@Sidrairfan078

Hello sir, I hope you are good. I have read your job description, its doable job as per my experience and knowledge. I want to ask you few questions about job description. I am full stack developer having a good experience in Google Sheets, Excel, Data Processing and Software Architecture. Lets start chat, I assure you that you will get quality work in given time and cost. You can check my portolio as well: https://www.freelancer.com/u/Sidrairfan078 Thanks! Sidra

$155 USD σε 8 ημέρες

5,0

(3 αξιολογήσεις)

5,2

@mobimubasir

Hello. I read your requirement i will do that. Please come on chat we will discuss more about this. I will waiting your reply.

$70 USD σε 1 ημέρα

5,0

(37 αξιολογήσεις)

5,0

@vinzin

With an extensive background as a software developer and data scientist, I am confident in my ability to complete this Google Sheets project successfully. My proficiency in Python, specifically working with data using Pandas and Excel, lends itself perfectly to the task you have described. Over the years, I have honed my skills at manipulating numerical data and crafting custom formulas- both of which are essential to creating the script you require. In line with your timeline, I am committed to a quick turnaround without compromising quality. I understand that reliability and efficiency are essential in delivering projects on time, and I can assure you that those qualities underpin my work ethic. Having worked on similar tasks previously, transforming clients' data processing capabilities, I am poised to leverage this experience to bring about similar positive impact for you. Lastly, it's of note that this project aligns perfectly with my passion for creative problem-solving within tight deadlines. By choosing me, you're picking not just a skilled programmer but also a collaborator who will actively contribute ideas on how best to enhance your google sheet's functionality. Together we can optimize your workflow significantly. Let's get started!

$80 USD σε 2 ημέρες

5,0

(12 αξιολογήσεις)

4,8

@GdevDataSceince

Hi there, I am a Data Scientist a professional responsible for extracting actionable insights and knowledge from large volumes of data GOOGLE SHEET Development. I can write clean Google Sheets, Google Excel Sheets, Power BI, Outlook, and Google VBA macros. Google Excel: 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 high-quality 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 customers 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

$140 USD σε 7 ημέρες

5,0

(13 αξιολογήσεις)

4,8

@IMBASANTAKUMAR

Drawing from my 12+ years of experience in the domains of MNCs like IBM, Accenture, Amazon, and Google, I am well-versed with the programming complexities of Google Sheets. As your project demands, I bring to the table strong Excel and Google Sheets skills that are accompanied by over a decade's experience in crafting custom formulas and developing automation macros. These proficiencies lend themselves naturally to handling numerical data and date functions, which is the prime focus of your project. Moreover, I understand that deadlines play a pivotal role in projects, and I have a reputation for delivering high-quality work even under tight timelines - something I'm confident about managing to complete within a month for you. Additionally, having extensively worked with entities like Amazon and Google, I have gained a holistic understanding of effective data management and processing - insights which will greatly assist with providing you the solutions you require. More than just completing the task at hand, I see true value in transforming how we process data. Your project offers us both an exciting opportunity to refine our data handling capabilities together. As someone who thrives on challenges and understands exactly what's expected with this project, I assure you my dedication,and expertise; resulting in an elevated user-experience beyond the completion of this crucial script.

$30 USD σε 1 ημέρα

4,9

(74 αξιολογήσεις)

4,6

@ACCASpogmai

"""""""""""""""""""""""""""TOP GOOGLE SHEETS EXPERT"""""""""""""""""""""""""""" Greetings! I clearly understand what is required of the project. I am an GOOGLE SHEETS Advanced Level Expert. I have extensive experience in GOOGLE SHEETS, Excel, particularly in creating DASHBOARD, VLOOKUP, PIVOT FUNCTION, AUTOMATION, CODING and CUSTOM FORMATTING. I am also an expert of FINANCIAL CALCULATIONS and ANALYSIS. This is my field and I can complete this project with in 24 hours with added quality. Please Text me to discuss further. About me I am a Chartered Accountant with many years of experience from one of the worlds big four Accountancy and auditing firm """"""""EARNST & YOUNG FORD RHODES GLOBAL"""""""". I have also worked in PWC Audit Firm. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. It is my Sixth month here and I have 115+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards, Spogmai Kakar"""

$45 USD σε 1 ημέρα

5,0

(30 αξιολογήσεις)

4,3

@dmytrosemeniuta

Hi Kamran , It seems like that you want a Google Sheets script. I've read your job description and understood what you want. I have rich experience in Google Sheets Script. So I can done this project perfectly. Also I can start working immediately and satisfy you on time. Please share me your details on chat or call. Hoping for a positive reply from you. Kind Regards! Dmytro

$140 USD σε 7 ημέρες

5,0

(1 αξιολόγηση)

4,4

@zubairmbafinance

Hello With Excel expertise and Finance background I am right choice for this job. I read your job requirements and I am confident that I can do this Job with professional look. I can assure you the spreadsheet format will be simple and professional, Contact with me

$50 USD σε 1 ημέρα

4,9

(23 αξιολογήσεις)

4,1

@tukabwanausi

To efficiently develop the script that automates the data transfer and calculation updates between Sheet 1 and Sheet 2 in your Google Sheets, I'll need access to the specific sheet in question. With the necessary access, I can craft a Google Apps Script that seamlessly transfers the monthly data you input on Sheet 2 (B2-B8, C2-C8, etc.) to the corresponding cells in Sheet 1 (G10-G16), processes the calculations, and then displays the results back on Sheet 2 under the respective columns (B12-B15, C12-C15, etc.). This script will ensure that the results update live as you modify the input data or can incorporate a button to refresh the calculations, as per your preference. I can have this script ready for you in about 30 minutes once I have access to the sheet. Could you please provide me with the necessary permissions to access and edit your Google Sheet? This will enable me to start scripting the solution right away. You can award the project once you are happy with my deliverables. Looking forward to working with you

$100 USD σε 1 ημέρα

4,9

(13 αξιολογήσεις)

4,3

@shujoyshaha

I saw your job description I can do this project perfectly. Lets discuss it in more over the chat. Thanks

$50 USD σε 3 ημέρες

5,0

(27 αξιολογήσεις)

4,0

@jayprakashyadav

Hi, I hope this message finds you well. With over 15 years of full stack development expertise, I'm eager to bring your project to life. My experience ensures precision, efficiency, and a keen understanding of your needs. I'm committed to delivering top-notch quality and unwavering support, ensuring your project's success within your timeline. If you'd like to review my past work, I'm ready to share my portfolio. Let's discuss your project further. I'm here to help. Best regards

$140 USD σε 7 ημέρες

4,9

(4 αξιολογήσεις)

3,8

@Sunitav36

Hi, I am interested in this project and i am ready to do it for you. To proceed further, I am ready to discuss your project and start immediately. Thanks

$140 USD σε 3 ημέρες

4,6

(24 αξιολογήσεις)

3,9

@ajamshad162

As a seasoned Google Sheets programmer with over 50 successful projects under my belt, I have the precise skills you require to complete the task at hand. I specialize in crafting tailor-made formulas that ensure numerical data is handled efficiently and accurately. Additionally, my expertise in creating powerful macros will play a vital role in streamlining your data processing and enhancing your workflow. With this project, we're diving into an exciting phase where we can transform your data handling capabilities for the better. Your described timeline for completion fit well within my efficient work practices, ensuring that we won't be compromising on quality for speed. Choosing me for this project means selecting experience, expertise, and a promise of dedicated craftsmanship. Let's leverage the full potential of Google Sheets to make your data handling smooth and seamless. Looking forward to helping you tackle this challenge head-on!

$90 USD σε 2 ημέρες

4,4

(13 αξιολογήσεις)

3,7

@omarshheriif

Hello Boss, I have a lot to say actually :D firstly money isn't my priority I'm seeking more for a review I have been working on similar projects for other companies, let's have a chat, shall we

$30 USD σε 2 ημέρες