Find Jobs
Hire Freelancers

Do some Excel Work

$10-30 USD

Closed
Posted over 8 years ago

$10-30 USD

Paid on delivery
I am trying to set up a commission tracking process for a cell phone company. I have a regularly updated file in Google Sheets that has a new row added for every phone sold. Each row contains a phone number among other information. Invoices are sent in PDF format with rows that list each phone number and commission amount. There are also labels for the commission type in each row (1st Payment, 2nd Payment, Auto topup, and others). I would like to add 4 columns to the end of the Sheets document. They would be labeled in this order: 1st Payment - Promotion (Which would be anything labeled otherwise) - 2nd Payment - Auto Topup. Each cell in this column would refer to the phone number cell in it's own row and check all PDF files in Google PDF for that phone number. If the column we're working with is the 1st Payment column, it would then check each PDF document containing that phone number for the words "1st Payment." If that row also included those words, it would put the dollar amount that is also contained in that row as the readout for that cell. The "Promotions (or other)" cell would catch any remaining payouts that don't have the words required by the other cells, and populate that cell. Every time I am emailed an invoice in this PDF form, I would like to be able to add it to Google PDF and have the Sheets document reference the similarly named PDFs given to those invoices to keep the fields up to date. Is this something that's possible? This would be the most convenient process all things considered, but if not, please feel free to make other suggestions.
Project ID: 8917550

About the project

30 proposals
Remote project
Active 8 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
30 freelancers are bidding on average $25 USD for this job
User Avatar
i have gone through your full requirement. we can process this as your wish. ready to start the project immediately.
$30 USD in 1 day
4.8 (238 reviews)
7.7
7.7
User Avatar
Hello sir,we have 8 member team and we can start work right now plz give us one chance we will do our best.
$25 USD in 1 day
4.7 (285 reviews)
6.8
6.8
User Avatar
I have read out your project description and got a clear cut instruction about the work. Thank you very much to make the work easy. Before start let me convince you that i am the best for the current project. 1.I am only one current project in my hand and rest you find in ongoing list is obsolete. 2. I have an experience team to execute it within deadline with highest accuracy and in professional way. 3. I am the highest bidder who has scored 5* out all completed project. So i took outstanding care for your project, it is my habit of work. 4. I will communicate time to time and give you update about the project. 5. I am on your budget. Regards harubel
$35 USD in 3 days
5.0 (40 reviews)
5.8
5.8
User Avatar
Yes that is possible please send ma a PDF so that i could give u sample. I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start
$30 USD in 0 day
4.7 (53 reviews)
4.9
4.9
User Avatar
Dear Employer! I've read the entire description. I have sound knowledge of data entry, web search and data mining jobs. I am a professional user of Office (Word, Excel, Power Point) and other programs. I have 6 years of experience of these kind of work. Please give me an opportunity and I will prove that I am a good freelancer.
$25 USD in 1 day
4.7 (43 reviews)
4.7
4.7
User Avatar
We are team of Professional Accountants (ACAs, ACCAs, CPAs, CFAs, MBAs), IT Professionals (Web/Software development), and Professional Writers headed by a qualified chartered accountant (ACA, FCCA-UK) with over 11 years of practical experience. The combination of experience and qualification enables us to complete complex projects efficiently and perfectly with reasonable ease. Our dedicated and highly qualified individuals can handle this task in an efficient manner. Please share some more details for professional solution. We believe in producing high quality work, and do not bid on every project that we come across. We are 100% confident that we can do justice with your project. We will discuss the project in detail before accepting the project to avoid any confusion. Moreover, the price mentioned is provisional and subject to change after our discussion. Thank you. Usman Saeed Team Spectrum
$55 USD in 5 days
5.0 (17 reviews)
4.5
4.5
User Avatar
hello, well i cant understand what you really need and i think this is why you didnt get bids , so if you can make it more clear to me then i see if i can help or not,
$25 USD in 1 day
5.0 (6 reviews)
2.7
2.7
User Avatar
I can work in MS Word with great speed and highest degree of accuracy. I can also assure about the desired level of efficiency and I can work in MS Word with great speed and highest degree of accuracy. I can also assure about the desired level of efficiency and timely completion. I’m fairly experienced in data entry/typing jobs. Efficiency and timely delivery of the work is my strength.
$25 USD in 1 day
5.0 (3 reviews)
1.7
1.7
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I can follow instructions very well and I will get the work done as quickly an efficiently as possible.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 7 years experience on data entry work.
$15 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Sir/Madam. I am new here. I really want this job to make some money for my study. I still study in university. I show you my good work. I will not disappointed you if you hire me. Please consideri my proposal. Thank you.
$25 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
data entry
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
My name is Dilki Sheshani. After carefully reviewing the experience requirements of the job description, I have excellent experience in web research, SEO, data entry; Ms excel, Ms Word, Ms PowerPoint, article writing, forum posting, social bookmarking and more other experience. I have excellent communication skills and English. I also enjoy typing and researching websites. I am available at any time during the week. We have company and working place and we can do online jobs any time because we work as a group. We can give good results quickly for your jobs.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Prophetstown, United States
4.7
2
Payment method verified
Member since Sep 18, 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.