Find Jobs
Hire Freelancers

Compare 2 similar spreadsheets and report differences

$30-250 USD

Đã hoàn thành
Đã đăng vào gần 10 năm trước

$30-250 USD

Thanh toán khi bàn giao
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.
Mã dự án: 5976973

Về dự án

12 đề xuất
Dự án từ xa
Hoạt động 10 năm trước

Bạn muốn kiếm tiền?

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
Đã trao cho:
Avatar người dùng
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 trong 2 ngày
5,0 (19 nhận xét)
4,7
4,7
12 freelancer chào giá trung bình $71 USD cho công việc này
Avatar người dùng
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 trong 1 ngày
5,0 (71 nhận xét)
5,7
5,7
Avatar người dùng
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 trong 0 ngày
5,0 (50 nhận xét)
5,2
5,2
Avatar người dùng
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 trong 3 ngày
4,8 (6 nhận xét)
3,7
3,7
Avatar người dùng
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 trong 1 ngày
5,0 (1 nhận xét)
3,0
3,0
Avatar người dùng
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 trong 3 ngày
5,0 (2 nhận xét)
3,1
3,1
Avatar người dùng
"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 trong 1 ngày
5,0 (10 nhận xét)
3,3
3,3
Avatar người dùng
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 trong 1 ngày
5,0 (1 nhận xét)
1,6
1,6
Avatar người dùng
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 trong 1 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
"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 trong 1 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
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 trong 1 ngày
0,0 (0 nhận xét)
0,0
0,0

Về khách hàng

Cờ của UNITED KINGDOM
nottingham, United Kingdom
5,0
23
Phương thức thanh toán đã xác thực
Thành viên từ thg 3 23, 2006

Xác thực khách hàng

Cảm ơn bạn! Chúng tôi đã gửi email chứa đường link để bạn lấy tín dụng miễn phí.
Đã xảy ra lỗi trong khi gửi email của bạn. Hãy thử lại.
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.