Excel Your Data!

$30-250 USD

Dokončeno

Zveřejněno

před 3 měsíci

$30-250 USD

Zaplaceno při doručení

I'm searching for a skilled Google Sheets programmer to two write a simple script. 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 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.

Excel

Software Architecture

Data Processing

Google Sheets

IČ projektu: 37775734

O projektu

31 nabídky

Vzdálený projekt

Aktivní před 3 měsíci

Chcete si vydělat nějaké peníze?

E-mailová adresa

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec

Získejte za svou práci zaplaceno

Načrtněte svůj návrh

Registrace a podávání nabídek je zdarma

Uděleno:

@pixelstudio0077

$0 USD v 1 dni

5,0

(11 recenze)

3,9

31 freelanceři nabízejí v průměru $132 USD za tuto práci

@MimiFL

Hi, i looked at both pictures and in general this is definitely possible. But to be honest it sounds like a better idea to just base the formulas B12-B15, C12-C15 directly on the data above it. Is that a possible solution? If you are interested, feel free to let me know and i will take a look at the formulas. Thanks, Milan

$40 USD v 1 dni

5,0

(803 recenze)

7,5

@daniyal3214

Hello, Google Sheets and Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced Google Sheets and Excel professional with years of experience in all the tools of Google Sheets and Excel including Visual Basic, Automation, Data Analysis, Complex Formulas, Calculations, Analysis, Financial Modeling etc. To make your hiring decision easier, I can share the limited version quickly before you hire and then you can decide if this fulfills your needs or not. Lets discuss more in detail about my previous similar experience and how I am highly suitable for this project.

$90 USD v 1 dni

4,8

(243 recenze)

7,3

@nimiwebjuggler

Hi, I am an Excel Expert with Professional experience working with Excel. I believe I can do great work for you and ensure your quality. I have more than 5 years of experience with excel. Complete a lot of jobs on Freelancer with high satisfaction of the client.

$30 USD v 1 dni

5,0

(149 recenze)

6,8

@rabbiawebjuggler

Hi I am expert in Data entry, Web search and also Alison certified in excel. I am ready to start now Quality is my top priority Ping me back for further discussion Thank you!

$140 USD v 1 dni

5,0

(110 recenze)

6,6

@greetnicole

Dear client from the United Stated, I clearly understand your requirements. I'm currently using this same formular and methods on Excel for my business accounting. Contact me ASAP let's get to it. I look forward to hearing from you soon. Best wishes. Faith

$200 USD v 7 dnech

5,0

(5 recenze)

6,6

@vinzin

As an established full-stack developer with a keen focus on data manipulation, I am confident in my ability to excel at tackling your Google Sheets project. My proficiency in developing custom formulas and powerful macros will ensure that your data handling and calculations are streamlined, precise, and completely automated. Having worked with a wide array of programming languages, including Python, Ruby on Rails, and many more, I bring a diverse skill set to the table to deliver maximum value to this project. Furthermore, my background in Data Science coupled with 5 years of experience in software development underscore my comprehensive understanding of handling and processing numerical data. From Python/Pandas/Numpy for data analysis to different web automation techniques (including captcha/IP/user-agent rotation) for robust web scraping projects - I've got you covered! Delivering quality results on-time is one of my top priorities. With a dedicated approach towards meeting deadlines without compromising on the overall quality, I'm positive about being able to solve your sheets conundrum within the stipulated timeline. Let's team up to transform your data processing capabilities for the better!

$100 USD v 2 dnech

5,0

(12 recenze)

4,8

@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, IN 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 v 1 dni

5,0

(28 recenze)

4,2

@saim2105

With years of experience in data processing and software architecture, I have the proficiency and expertise in Google Sheets that your project requires. My forte lies in developing custom formulas and robust macros, ensuring streamlined and efficient calculations for numerical data, just as you need. In addition to handling complex data structures, I understand the significance of working within tight deadlines without sacrificing accuracy or efficiency. This aligns perfectly with your timeline expectations, making us a great match. This project offers an exciting opportunity to demonstrate my out-of-the-box thinking combined with impeccable execution capabilities. With my experience and proactive approach, I can excel at making your data processing function more effective and less time-consuming. Let's transform your spreadsheets together!

$80 USD v 1 dni

4,8

(9 recenze)

3,6

@ypharck

Hi there I have extensive experience in Google App Script to handle G-Sheet and G-Form Open chat with me to discuss project in more detail Thank you

$300 USD v 7 dnech

5,0

(1 recenze)

3,0

@Morar222

⭐⭐⭐⭐⭐ Top Data Handler Here ⭐⭐⭐⭐⭐ As an expert in Excel and various programming languages, I am ideally suited to create the custom spreadsheet you need for your architectural fee tracking. I have extensive experience in developing complex Excel solutions that streamline processes and provide detailed insights. I guarantee a seamless integration with your existing workflow. With my expert knowledge in Excel, I can create a highly intuitive, user-friendly system that is tailored specifically to your needs. This will allow you to easily see each project's fee details, track subcontractor payments vs. remaining funds, monitor monthly billing and even forecast future cash flow. Additionally, my skills extend to ensuring data accuracy and establishing efficient methods for managing large amounts of information. On top of my Excel prowess, I also bring proficiency in PHP, MySQL, HTML, CSS and Java to bear on projects. This means I can work seamlessly with a wider range of tools and cater to any additional requirements you may have. Hiring me means getting quick turnarounds, personalized support throughout the project, and a comprehensive solution that covers all your needs. Thank you for considering my application!

$99 USD v 1 dni

5,0

(1 recenze)

2,2

@roysiya090

Hhi I am experienced in this and I can start right now but i have few doubts and questions lets have a quick chat and get it started waiting for your replyyy ! r!

$140 USD v 7 dnech

5,0

(1 recenze)

1,3

@syedalihassansh4

Hello Sir, I have read your instructions and I can do it efficiently according to your requirements. Please give me this project and get 100% extra ordinary work with unlimited revisions even after completion of the work. Will wait for your kind response ? Thank You. Regards, SYEDA NIMRA

$40 USD v 1 dni

5,0

(4 recenze)

1,3

@Alinas1work

Hello Kamran S., I’ve carefully checked your requirements and really interested in this job. I can complete your project on time and your will experience great satisfaction with me. I have rich experienced in Software Architecture, Excel, Data Processing and Google Sheets. I’m ready to discuss your project and start immediately. Looking forward to hearing from you. Many thanks. Lina.

$150 USD v 3 dnech

0,0

(0 recenze)

0,0

@vadym35

Hey, Kamran S., I went through your project description and it seems like I am a great fit for this job. I am a good and reliable man who has many years of experience on Data Processing, Excel, Software Architecture, Google Sheets. Lets connect in chat so that We discuss further. Regards

$140 USD v 7 dnech

0,0

(0 recenze)

0,0

@prashant628

Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it, because we already work on similar requirement in past. We have right skills to work on this assignment. We will complete the work as per requirement

$140 USD v 7 dnech

0,0

(0 recenze)

0,0

@bmw008890

Hi I am expert in Data entry. I have good typing skills. I have also work experience. I am ready to start now Quality is my top priority Ping me back for further discussion than you...

$140 USD v 1 dni

0,0

(0 recenze)

0,0

@AmerADLR

Greetings, I hope you are doing fine. My name is Amer Rasool. My expertise is in MS Excel, Google Sheets, Data Extraction, Data Cleansing and Python Scripting. I have read this job. I have understood all the job requirments. I have good knowledge in developing custom formulas and macros in Excel. I believe that I am a suitable person for this job. If you assign me this project I shall start working on it immediately and shall complete it in time. I believe in building a good reputation with clients by delivering them the best of my services I am looking forward to talking to you. Thanks and regards, Amer Rasool.

$130 USD v 15 dnech

0,0

(0 recenze)

0,0

@Triniguy36tt

As a skilled data entry and Google Sheets specialist, I possess a deep understanding of how to manipulate numerical data and apply advanced formulas that improve efficiency. My proficiency in Macros, for instance, allows me to design powerful scripts to automate your recurring monthly tasks, ensuring timely updates as required between Sheet 1 and 2. I will create a script that takes the data you input on Sheet 2 and dynamically update the relevant cells on Sheet 1 while automatically feeding back the calculation results. Punctuality is paramount for this project as you need it completed within a month, which fortunately aligns with my efficient work ethics. Dedicated to delivering top-quality output within tight deadlines, hiring me would guarantee both precision and speed. Your project presents an exciting opportunity for me to utilize my expertise in scripting realistic data handling and I look forward to fostering a successful professional relationship with you. I am confident that my skills and experience align perfectly with your specific needs and I am equipped to handle any challenges that may arise over the course of the project. Let's collaborate on optimizing your data management processes.

$140 USD v 7 dnech