Find Jobs
Hire Freelancers

Create google sheet script/formula -- 2

$10-30 USD

Zamknięte
Opublikowano prawie 7 lat temu

$10-30 USD

Płatne przy odbiorze
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.
Identyfikator projektu: 13987706

Informację o projekcie

13 ofert
Zdalny projekt
Aktywny 7 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
13 freelancerzy składają oferty o średniej wysokości $31 USD dla tej pracy
Awatar Użytkownika
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further discussion. Thanks and regards Roy
$40 USD w 1 dzień
4,9 (163 opinii)
5,9
5,9
Awatar Użytkownika
With respect to this project I would like to present myself as a candidate for your consideration. I have more than 7 years of IT experience. I have successfully completed few projects for US clients which involved web scraping, web research,internet research and data entry. Key features of my work are as follows: 1) Always within schedule 2) Always within scope 3) High quality data 4) Best tools and techniques used for the completion of tasks Looking forward to hear from you. Regards
$35 USD w 1 dzień
4,9 (26 opinii)
4,4
4,4
Awatar Użytkownika
Hi there! I will be happy to help you with that. We can use a Google script to hardcode the values if this can solve your problem or we can come up with a better solution if I had a look at the sheet. Looking forward to hearing from you! Cheers, Mohamed
$40 USD w 1 dzień
5,0 (12 opinii)
3,7
3,7
Awatar Użytkownika
I have 4+ years experience in data analytics, working on small excel reporting to big DWBI reporting work. I am an expert in developing user-friendly spreadsheets for data analysis and visualization, creating interactive KPI dashboards using pivot tables, slicers, and graphs. Projects range from long-term support of data analysis and visualization needs to short-term specific projects. Skills: - Excel/VBA Automation - Excel Dashboards & Reporting (Data Visualization) - QlikView/QlikSense/Tableau (Data Warehousing and Business Intelligence) - Microsoft Access (SQL) - SAS / R Language - Data Analytics (Executive Decks/Analysis - Key Results and Insights) - Commercial Insights and Analytics Once I receive a project, my biggest priority/focus is to ensure that quality work is delivered always on time. Give me an opportunity, I will deliver you the quality. Warm Regards, Rohit Ahuja |
$55 USD w 1 dzień
5,0 (7 opinii)
3,4
3,4
Awatar Użytkownika
hello my name is Stavroula, I am new here (only one project) I regarding the issue you mention I suggest to insert new lines one line before the last. I can not help more.M u interesting is about pivot tables , I am able to create any kind of pivot table you need Regards Stavroula
$25 USD w 1 dzień
5,0 (1 opinia)
0,8
0,8
Awatar Użytkownika
Hi , Your requirement is detail and doable by me in a short time. High quality guarantee since I have experience working with Google Script on Google Spread sheet. PM me for more detail.
$30 USD w 0 dzień
5,0 (2 opinii)
0,4
0,4
Awatar Użytkownika
best experience in excel and so on.
$30 USD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
sir I am a professional accountant. Although i am new in the virtual world but also i can assure you that i will do the job with the most efficient way. My only mission is to satisfy my client for a good review. Always ready to having a nice interview. Thank you.
$20 USD w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have checked your requirements. We have right skills to work on this assignment. We are a team of professionals including experienced analysts, designers, project managers, developers and QA people having great expertise in web applications development mainly on core PHP, PHP with open sources (Joomla, Wordpress, Codeigniter, Cake PHP), .NET, Asp.NET, Vb.NET, HTML 5 etc. and mobile applications on ios and Android platform. Our award = superb result = happy client. In a good partnership, good results happen. Good cooking makes good eating!BWe consider our client as our partner. I am ready to discuss with you with best Regards
$28 USD w 6 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Hello. I constantly work with the technologies specified in the job description. I need more information, but in any case, working for me is not a problem.
$23 USD w 5 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
I can show some of my previous work with google spreadsheets, i am very confident that my expertise is enough to solve your issue here.
$30 USD w 2 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga CHINA
Shenzhen, China
5,0
11
Zweryfikowana metoda płatności
Członek od wrz 22, 2014

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.