Create google sheet script/formula

$10-30 USD

Dibatalkan

Disiarkan

hampir 7 tahun yang lalu

$10-30 USD

Dibayar semasa penghantaran

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 Projek: 13966287

Tentang projek

7 cadangan

Projek jarak jauh

Aktif 7 tahun yang lalu

Ingin menjana wang?

Alamat e-mel

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda

Dapatkan bayaran untuk kerja anda

Tuliskan cadangan anda

Ianya percuma untuk mendaftar dan membida pekerjaan

Dianugerahkan kepada:

@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 dalam 2 hari

0.0

(0 ulasan)

0.0

7 pekerja bebas membida secara purata $23 USD untuk pekerjaan ini

@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 dalam 1 hari

5.0

(3 ulasan)

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 dalam 1 hari

0.0

(0 ulasan)

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 dalam 6 hari