Create google sheet script/formula

$10-30 USD

キャンセル

投稿日:

約7年前

$10-30 USD

完了時にお支払い

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

プロジェクト ID: 13966287

プロジェクトについて

7個の提案

リモートプロジェクト

アクティブ 7年前

お金を稼ぎたいですか？

メールアドレス

Freelancerで入札する利点

予算と期間を設定してください

仕事で報酬を得る

提案をご説明ください

登録して仕事に入札するのは無料です

アワード者:

@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 2日以内

0.0

(0 レビュー)

0.0

この仕事に7人のフリーランサーが、平均$23 USDで入札しています

@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 1日以内

5.0

(3 レビュー)

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 1日以内

0.0

(0 レビュー)

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 6日以内