Need an Expert at Google Sheets Formulas -- 3

$8-15 USD / hour

Closed

Posted

about 3 years ago

$8-15 USD / hour

I need an EXPERT at this. Please don't apply if you are anything short of an expert. If you accept the job and then can't complete it, I will issue negative feedback. You must speak fluent English as well. No ridiculous bids. I'm familiar with what this should cost. I need you to make the following changes to a Google Sheet (will provide link upon job acceptance) but I've included a download of the file here. All cells references are in the Calc sheet unless otherwise noted. When computing cell D29, it pulls from the chart located in the Cal SupportSheet1. I need this to be calculated by pulling the cum interest number in column U of Cal SupportSheet1 at the last point when the total payable is positive (in this instance, in row 48… which would be $2,200.38 (U48). Keep in mind that the cell where this happens will change based on the numbers I enter in the spreadsheet. The same for the calculation in G29. It uses a different chart in the Cal SupportSheet1 For cell I25, the current formula is: =I21-I19-I22-$F$2-$F$7 I need the calculation to minus $F$2 and $F$7 ONLY if there is an X in cell I23 Please find out why cell J27, J29 & J31 isn’t calculating Please also speed up the calculations in the spreadsheet. Sometimes when I change a number is takes up to 60 seconds for everything to recalculate. Please have I30 and J30 calculate like the rest of the columns.

Project ID: 29026076

About the project

11 proposals

Remote project

Active 3 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

11 freelancers are bidding on average $12 USD/hour for this job

@schoudhary1553

Hi, Greetings! ✅ I have checked and gone through the project details and I am very skilled in it. ✅Completed Time: In project deadline We have worked on 640 + 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 Digital screencast

$15 USD in 40 days

4.9

(403 reviews)

8.2

@writingapp

Hi. I have written many automation GoogleSheet scripts. Ready to write your project. Will complete within 1 day

$15 USD in 10 days

4.9

(79 reviews)

5.7

@hayteekeys

Hello. From your job description I have learned that the requirements you have asked for are possessed by me very well. I am a graduate of computer science. Also, I have several good records in this field as I have been working in this field for about 6+ long years. I have Great experience in Data visualizations, building dashboards using Excel, i am proficient in VBA, Gscript e.t.c I have great expertise on Data entry and excel and Analysis. also have proficiency in MS office, Google analytics and QuickBooks and 10-Key KPH typing speed with zero errors. Working with me will surely bring you many good as I am very creative and persuasive in nature. Also, I can handle things diplomatically with full professionalism. With full guarantee, I can assure you the deliverables you have asked for in the job description. Regards Atemenu .D

$12 USD in 40 days

4.9

(19 reviews)

4.8

@dheerajjshetty19

Hi, I have come across your post and as am expert in Google sheets would like to offer my services. A bit about myself, my academic qualification is Chartered accountant. For the past seven years I have gained considerable experience using various accounting software including Quickbooks (both online and Pro), Xero, Zoho, Tally, SAP. I am also proficient in the advance use of Microsoft Excel, Google Drive and Google Sheets.

$8 USD in 40 days

5.0

(35 reviews)

4.9

@chnsci

Greetings, I think here you are looking for an Expert at Google Sheets Formula. I have seen the attached file and understood your project description. I am an expert in Accounting, Excel, Statistics, Mathematics, Google Sheets, and I am interested in your project. I am confident that I can do this with 100% accuracy and ready to start now! But I want to know more about your project. So, can we discuss more? Regards.

$12 USD in 40 days

5.0

(6 reviews)

2.8

@erparveenkumar

Hi I tried to download the attached excel sheet but it couldn't as I got an error i.e. HTTP ERROR 401. Could you please share that excel file or Google sheet link with me. I have read your instructions which you want to be done in the Google sheet. This can be done easily using advanced formula where various conditions will be applied while calculating those fields. If you would share a sample file with me, I would calculate one field and share with you as a sample before awarding this project to me. Regards Parveen Kumar

$15 USD in 40 days

5.0

(2 reviews)

1.3

@meniki2010

Hey There, I have read through your project details clearly and understood things that need to be done. I will confirm with you once again when the project is awarded. But let me tell you a bit about myself so that you can trust your project would be in good hands. I am the Vice President in Verzeo, a Indian based company. My speciality is into Google sheets and Excel. And If there are multiple users who would edit your worksheet, its always better to go with Google Sheets. I am also very good in Math (as most of the Indian are :P) . You can also verify my account in Linkedin by clicking Nikhil Chowdary Verzeo. Coming to your project, it is a basic math problem which can be solved by using few formulas. Understanding the sheet would take an hour probably and then creating your desired results would take another 2-3 hours at max. I am also good in english and can easily understand American Accent. I Hope you will award me this project and looking forward to work for you.

$8 USD in 40 days

0.0

(0 reviews)

0.0

@noorazmalmdzin

Dear Sir, This is Mohd Noor Azmal Bin Md Zin from Malaysia, I'm an intermediate analyst. I have 4 Years’ exposure in Ms Excel analysing environment. I have relevant skills that you require. I have confident that I will do your work very well. I hope you would like my work and you will give me a good feedback which is very important for my future carrier. I'm available for chat. Hope to receive any news from you soon. Thank you and regards, Mohd Noor Azmal Bin Md Zin

$12 USD in 40 days