Find Jobs
Hire Freelancers

simple program , application , php script or any solution to compare two excel file

$10-30 USD

Selesai
Disiarkan 7 bulan yang lalu

$10-30 USD

Dibayar semasa penghantaran
I need a program, PHP script, or anything that can perform the following tasks according to my requirements below: I have two Excel files. The first file can have any name, and the second file will always be named "NL-DECO-PROHIBIT." I want the program to check the numbers in column AG (with decimal points removed) of the first file and compare them to column A of the "NL-DECO-PROHIBIT" file. If the number being compared has a corresponding value of "Prohibited" in column B of the "NL-DECO-PROHIBIT" file, the program should report which lines in the first file have numbers that are marked as "Prohibited." If the program compares the numbers in column AG to column A of the "NL-DECO-PROHIBIT" file and finds no matching numbers at all, it should provide a list of lines in the first file that cannot be matched with any numbers in column A of the "NL-DECO-PROHIBIT" file. Please note that the first file may have a high number of lines, up to 2000 lines that need to be checked. You can refer to the sample files in the project attachment.
ID Projek: 37350380

Tentang projek

13 cadangan
Projek jarak jauh
Aktif 7 bulan yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
Hello I can create a script to check and compare numbers of file A in file B to return the results as you described above. I have great experience on PHP and have worked multiple times on importing/exporting Excel and performing operations on the data. I can write this script and I can start right now. Let's discuss more on this.
$30 USD dalam 1 hari
5.0 (21 ulasan)
4.7
4.7
13 pekerja bebas membida secara purata $25 USD untuk pekerjaan ini
Avatar Pengguna
Hi there! Hi there! I can really do this. Please let me handle this. I just need a work for medical expenses. My name is Paulo and I am a subject matter expert in Excel, specifically with Ms Excel charts and formatting as well as VB macro development. I have the skills necessary to create the program that you are looking for. I understand that you need a program, PHP script or anything that can perform the following tasks according to your requirements: I believe I can provide the solution you are looking for. With my expertise in Excel, I am confident that I can develop a solution that can check two Excel files for numbers marked as "Prohibited" and provide a list of lines in the first file that cannot be matched with any numbers in column A of the "NL-DECO-PROHIBIT" file. I would be delighted to discuss this project further with you if given the opportunity. Please feel free to contact me if you would like to discuss further or have any other questions regarding my skills or project required.
$20 USD dalam 7 hari
4.8 (82 ulasan)
5.5
5.5
Avatar Pengguna
I understand that you are looking for a program, PHP script or anything that can perform the following tasks according to your requirements: I am confident that my skillset is the best fit for this project. I have experience in developing web,mobile apps and managing Linux systems which will be extremely beneficial for your needs. I am also confident that my solution can check two excel files and compare numbers marked as prohibited in column B of the NL-DECO-PROHIBIT file. This is something that can be achieved with my skillset as i have experience in making applications that can do complex tasks such as comparing two excel files. I believe that my solution can provide the needed information quickly and accurately so please feel free to contact me if you would like to discuss further or need any additional information. Thank you for considering me for this job!
$30 USD dalam 1 hari
4.9 (21 ulasan)
3.9
3.9
Avatar Pengguna
Hello Sir, I checked the files you mentioned. And also understood the requirments somewhat, but couldn't understand which part what you want to compare in second file. So DM me to discuss more. I can easily help you to make python script to implement this.
$30 USD dalam 1 hari
5.0 (4 ulasan)
3.9
3.9
Avatar Pengguna
Hello there! My name is Syed and I am a versatile Full Stack Developer with expertise in multiple domains. I have the skills necessary to help you compare two Excel files. Specifically, I have experience in PHP programming, which is the backbone of many web applications. I understand that you need a program, PHP script, or anything that can perform the following tasks according to your requirements: - Check the numbers in column AG (with decimal points removed) of the first file and compare them to column A of the "NL-DECO-PROHIBIT" file. If the number being compared has a corresponding value of "Prohibited" in column B of the "NL-DECO-PROHIBIT" file, report which lines in the first file have numbers marked as "Prohibited." - If no matching numbers are found in column AG of the first file then provide a list of lines in the first file that cannot be matched with any numbers in column A of the "NL-DECO-PROHIBIT" file.
$30 USD dalam 1 hari
5.0 (5 ulasan)
3.4
3.4
Avatar Pengguna
Hi I can create a python script which will easily take the first file path and output all the data you need as output, I have carefully read and checked 2 excel files and I know what I am going to do, I can finish it in 2-3 hours Contact me now for details Best Regards,
$20 USD dalam 1 hari
5.0 (6 ulasan)
2.8
2.8
Avatar Pengguna
Hello! I'm Muhammad, a certified data analyst, and I understand your project description. With my experience in data analysis and PHP, I believe I can provide the best solution for your project. I have worked with Excel before so I know how to clean it up and make it interactive. Additionally, I have done projects in Google Sheets before so I know how to make sure all the information is displayed properly and error-free. I am confident that my solutions would meet your needs 100% as they are good-looking, error-free and interactive. Please feel free to contact me if you would like more information or would like me to present my solution in more detail.
$30 USD dalam 2 hari
4.8 (7 ulasan)
2.4
2.4
Avatar Pengguna
Greetings Talay, Thank you for considering my proposal for your project. As a seasoned expert in PHP, C Programming, Visual Basic, Excel, and Google Sheets, I assure you of top-notch results. With over 8 years of experience, I am committed to professionalism and delivering high-quality work. Here is a brief overview of my expertise: - PHP: I have extensive experience in developing and maintaining PHP applications, including customizing and integrating third-party solutions. - C Programming: I possess strong proficiency in C programming, enabling me to tackle complex tasks and ensure optimal performance. - Visual Basic: With expertise in Visual Basic, I can create customized solutions that meet your specific requirements and enhance productivity. - Excel: I am highly skilled in Excel and can create advanced formulas, macros, and data analysis tools to streamline processes and provide insightful reports. - Google Sheets: I have a deep understanding of Google Sheets and can develop collaborative spreadsheets and automate tasks to optimize efficiency. Portfolio Highlights: - Developed a robust PHP website for a leading e-commerce company, resulting in a significant increase in sales and customer satisfaction. - Designed and implemented a C program for a multinational corporation, improving the processing speed of their data analysis by 50%. - Created a Visual Basic application for a small business, simplifying their inventory management process and reducing errors. - Built an Excel spreadsheet for a financial institution, enabling them to track and analyze complex investment portfolios accurately. - Developed a Google Sheets template for a nonprofit organization, facilitating efficient collaboration among team members and improving data accuracy. I understand the importance of your project and assure you that my expertise and commitment to professionalism will meet your expectations. I am confident that my skills and experience make me the ideal candidate for your project. Thank you for considering my proposal, and I look forward to the opportunity to work with you. Best regards, Michael
$22 USD dalam 7 hari
5.0 (1 ulasan)
1.6
1.6
Avatar Pengguna
Dear Sir, Are you looking for a reliable and experienced freelancer to convert scanned PDF files into MS Word? I'm Priti and I have the required skills to complete the project. I have been working with data entry, copy typing, Excel, PDF and Word for the past 3 years. I can undertake the project and convert 10 to 20 files everyday, each file taking approximate 15 minutes to complete. I understand the importance of keeping the same formatting in the Word document and I am confident I can do this. I am offering a free demonstration of the solution even before the project is awarded. This will help you to understand my capabilities better and also make sure that I am the right fit for the job. I am looking forward to hearing from you and discussing the project further. Thank you for your time and consideration. Sincerely, Smith
$10 USD dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Dear Client, I'm ready to create a tailored program to fulfill your Excel file comparison requirements. With proficiency in PHP, C Programming, Visual Basic, and Excel, I'll design a robust solution. This program will diligently cross-reference column AG of your first file with column A of "NL-DECO-PROHIBIT." It will provide detailed reports on prohibited matches and highlight unmatchable lines. Handling files with up to 2000 lines is well within my capabilities. Your project's attachment will serve as a valuable reference point to ensure precision. Let's begin the development to streamline your data comparison needs. Best Regards,
$20 USD dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
hi please correct me if i'm wrong you need to compare Column AG in first file with column A in second file however the first file has "." in its value so i need to remove "." first then compare right? i can make it via php code i'll deliver it asap if you're okay Thanks
$30 USD dalam 7 hari
0.0 (0 ulasan)
0.0
0.0

Tentang klien

Bendera THAILAND
Bangkapi, Thailand
5.0
118
Kaedah pembayaran disahkan
Ahli sejak Mac 24, 2013

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.