Create google sheet script/formula

$10-30 USD

Cancelled

Posted

about 7 years ago

$10-30 USD

Paid on delivery

We need a solution to process our sales data from different countries. Our Google Spreadsheets are being populated by mailparser ([login to view URL]), which populates different cells based on the country the sale was made, but we need to run some formulas based on the amount sold to determine profit, costs,etc. But the new entries skip any line which has any formula. We need a solution for this issue, so we would have the other fields such as profit, costs and margin automatically populated based on the new entries sent by mail parser. Additionally, we would like to create a pivot tables for each country and a single one showing total numbers. Feel free to ask more in case of any doubts.

Excel

JavaScript

Project ID: 13966287

About the project

7 proposals

Remote project

Active 7 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

Awarded to:

@sandeepsogani

I think Some macros along with scripting (maybe python) can fix your issue. The issue is arising due to multiple definitions to the cells which are misleading the data as and where to store it. Allow me to look into the matter and fix the issue for you. - :)

$25 USD in 2 days

0.0

(0 reviews)

0.0

7 freelancers are bidding on average $23 USD for this job

@rakshitdadhich

Greetings! I am an expert in Microsoft excel/ Data entry. I would love to have the opportunity to discuss your project with you. I feel I am best fit to complete your project. I have 10 years of experience of particular field. I have recently complete similar project. Thank you for your time and consideration

$15 USD in 1 day

5.0

(3 reviews)

1.5

@Ashoksamriya

Turning Dreams Into Reality !! ♦ COMING is a beginning ♦ KEEPING together is progress ♦ WORKING together is success. *Our solution will always give you a great success. Your success is our SUCCESS. *I bid only when I am completely sure that I can do the job. i am new here so at low cost..

$20 USD in 1 day

0.0

(0 reviews)

0.0

@techcrunch2

Hello Sir, We have gone through the details you have provided and we have already worked on a similar project before and can deliver as u have mentioned and would be pleased to work on this with you to deliver the results that you have expected and we have already worked on a similar project before and can deliver as u have mentioned We are sure you will not be disappointed if you give us this opportunity. Our team is experienced, creative & efficient enough to get your job done well. We have an impeccable record and all our clients enjoy working with us, we are sure that you will too, our prices are cheapest in market. can u provide your email or sky-pe etc for further discussion about the project I am ready to discuss with you with best Regards

$26 USD in 6 days