Find Jobs
Hire Freelancers

Compare 2 similar spreadsheets and report differences

$30-250 USD

Abgeschlossen
Veröffentlicht vor fast 10 Jahren

$30-250 USD

Bezahlt bei Lieferung
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.
Projekt-ID: 5976973

Über das Projekt

12 Vorschläge
Remote Projekt
Aktiv vor 10 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
Vergeben an:
Avatar des Nutzers
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 Tagen
5,0 (19 Bewertungen)
4,7
4,7
12 Freelancer bieten im Durchschnitt $71 USD für diesen Auftrag
Avatar des Nutzers
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 Tag
5,0 (71 Bewertungen)
5,7
5,7
Avatar des Nutzers
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 Tag
5,0 (50 Bewertungen)
5,2
5,2
Avatar des Nutzers
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 Tagen
4,8 (6 Bewertungen)
3,7
3,7
Avatar des Nutzers
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 Tag
5,0 (1 Bewertung)
3,0
3,0
Avatar des Nutzers
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 Tagen
5,0 (2 Bewertungen)
3,1
3,1
Avatar des Nutzers
"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 Tag
5,0 (10 Bewertungen)
3,3
3,3
Avatar des Nutzers
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 Tag
5,0 (1 Bewertung)
1,6
1,6
Avatar des Nutzers
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 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
"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 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tag
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von UNITED KINGDOM
nottingham, United Kingdom
5,0
23
Zahlungsmethode verifiziert
Mitglied seit März 23, 2006

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.