Find Jobs
Hire Freelancers

Create google sheet script/formula -- 2

$10-30 USD

Closed
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.
Project ID: 13987706

About the project

13 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

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
13 freelancers are bidding on average $31 USD for this job
User Avatar
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 in 1 day
4.9 (163 reviews)
5.9
5.9
User Avatar
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 in 1 day
4.9 (26 reviews)
4.4
4.4
User Avatar
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 in 1 day
5.0 (12 reviews)
3.7
3.7
User Avatar
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 in 1 day
5.0 (7 reviews)
3.4
3.4
User Avatar
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 in 1 day
5.0 (1 review)
0.8
0.8
User Avatar
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 in 0 day
5.0 (2 reviews)
0.4
0.4
User Avatar
best experience in excel and so on.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 6 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CHINA
Shenzhen, China
5.0
11
Payment method verified
Member since Sep 22, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.