Compare 2 similar spreadsheets and report differences

$30-250 USD

Completed

Posted

almost 10 years ago

$30-250 USD

Paid on delivery

Instructions for Spreadsheet A and Spreadsheet B compare 1 Please open both spreadsheets A and B. You will be comparing data between the two. 2 On spreadsheet A, you will need to match each entry with one on spreadsheet B 3 First criteria is the date. Then it will be the amount in/out. 4 The description is for basic reference only but should be more or less similar. 5 If the transaction on spreadsheet A is matched with a transaction on the spreadsheet B, please put a "y" in the Matched column and move on to the next row. 6 If the transaction on the spreadsheet A is not matched with spreadsheet B: 6a If something similar is there, compare Transaction Ref and use best judgement. If wrong date, or wrong amount, please put "delete" on spreadsheet B and "add to bank" on the spreadsheet A 6b If the transaction on spreadsheet A is totally not showing on spreadsheet B, please put "add to bank" on the spreadsheet A 6c If the transaction is on spreadsheet B but not on spreadsheet A, please put "delete from rp" on the spreadsheet B 6d If not sure about the transaction, please put "not sure" next to the relevant entry on whichever spreadsheet it appears Each spreadsheet has about 2500 entries and there will be about 500 inconsistencies that will need to be reported as above. This should take a competent person about 12 hours. Faster if you can write a formula to help compare. We are looking to pay about $60 or thereabouts. quote pink banana if you have understood this specification. I have attached and example spreadsheet showing some of the data from each spreadsheet.

Data Processing

Project ID: 5976973

About the project

12 proposals

Remote project

Active 10 yrs ago

Looking to make some money?

Email address

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

Awarded to:

@hemi

pink banana Hello, Yes, I understood comparison criteria perfectly. I am able to manage this project perfectly as per criteria given with project description. I did some exercise on sample data and it is (my our put) exactly matching with "Matched?" and "Notes" columns with example file. I am able to deliver this job within 2 days. As far as concern of proficiency, I like to request you visit my profile page on Freelancer to know what earlier employers are saying about services. I look forward for your approval. Regards, Ashok

$60 USD in 2 days

5.0

(19 reviews)

4.7

12 freelancers are bidding on average $71 USD for this job

@avinav606lx

Pink banana, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav

$126 USD in 1 day

5.0

(71 reviews)

5.7

@catstevens2009

Hi there! I have done this type of work before with 100% accuracy. Please feel free to message me with queries (if any) or we could chat and I will provide you with a sample file! Thanks! -Steve

$55 USD in 0 day

5.0

(50 reviews)

5.2

@jiashahood

Hello I am a student and a freelancer. I had done projects of excel, virtual assistance and data entry before as you can check my profile. I can provide you samples of my previous work. I hope you would like to work with me, and I HOPE you would like to give me a chance. Thanks Regards Zia shahid my previous projects. https://www.freelancer.com/projects/Data-Entry-Excel/Edit-upload-csv-file.html

$50 USD in 3 days

4.8

(6 reviews)

3.7

@prakashmondal

hi, I understand the comparison logic but may need your help during the work. I am interested to calculate a result and give an output using an windows application which i will develop myself based on the given logic. I will try to delivery in 12 hours but it should be flexible up to 24 hours after accept the project. Please consider my bid and let me start the work right now. Please see my previous work in https://www.freelancer.com/u/prakashmondal.html. Thanks Prakash

$100 USD in 1 day

5.0

(1 review)

3.0

@Shijidhar

Dear Employer, I read your project in full and I am sure that I can do this with 100% accuracy. The budget 60 $ you mentioned, I felt its low for this project as there are about 2500 entries to match and it will take good time. I can do this with 100 $. Looking forward to hear from you. Thank you Shiji

$111 USD in 3 days

5.0

(2 reviews)

3.1

@arugawade

"pink banana" Hello I understood your requirement as well as the examples you provided. Kindly contact me on PM so that I can start working on it and can send back to you with in 12 hours as per your proposal. Brief about me: I have 6+ years exp in data processing, formatting and entering in word, excel and powerpoint which includes formatting of plain text, tables, flowcharts and all other type. (e.g. TOC, header-footer, columns, subscript & superscript, hyperlinks, all excel formulea) I also have Medical billing experience of around 4 years which includes charge entry, payment posting and other correspondence document maintaining, sending emails, replying to the queries with right solutions, uploading and downloading patient documents from various applications. Thank you Arundhati

$61 USD in 1 day

5.0

(10 reviews)

3.3

@ssviatlana

pink banana Hello! I can help you to compare 2 similar spreadsheets.I have extensive experience in software development and automation using Excel, including VBA Coding, Macros, PivotTables, Charts/Graphs, Formulas, and Analysis. Please contact me to discuss further details.

$60 USD in 1 day

5.0

(1 review)

1.6

@danielpeslari

Hi "PINK BANANA", This task suits me very well as I'm used with doing this kind of job in Excel. I could use some formulas for the some entries. I'm serious, reliable and used with deadlines and high amount of work. I'm only doing a high quality work. For any further question you may contact me at any time. Best regards, Daniel

$64 USD in 1 day

0.0

(0 reviews)

0.0

@talk2agha

"Pink Banana" I am still reading through the instructions just so I am clear on what needs to be done, seems there are a lot of them. ----Edited----- Okay filtering based on the references column is still not clear and honestly I don't see how this can be done without manually checking each one. The first, second and third priority cells (date, amount in, and amount out) can easily be matched with a formula. All in all there, may be a lot of questions along the way.

$61 USD in 1 day

0.0

(0 reviews)

0.0

@bhairavpisal

pink banana I have gone through the requirement and understood it compeletely. Most part of it can be completed by using formula which I have deviced and post that, manual checking will be required. About me, I am Bhairav from India with 9 years of experience in data entry, data cleaning, mining, dashboard creation, analytics and reporting analysis. I have latest software and hardware to ensure that we deliver projects on time and accurately. I have a team of 2 who are dedicated to 1 project at a time to ensure complete attention and commitment. We follow stringent quality check to eliminate any human or machine error. All the best for your project and hoping to hear from you.

$35 USD in 1 day