Find Jobs
Hire Freelancers

Compare data in 2 excel spreadsheets - Repost - open to bidding

£20-250 GBP

Cerrado
Publicado hace casi 10 años

£20-250 GBP

Pagado a la entrega
I need to compare data from 2 excel worksheets and output results in the 3rd excel worksheet. Originally, the source file will have 2 worksheets that contain datasets, structured as follows: worksheet A (there will be a different name for worksheet A and B, your code should grab it and use it in report). each row is a set of one Source String and several Parameter Strings for this source string. first column will contain an alphanumeric source string in the first column and other columns will contain parameters for this source string, also alphanumeric strings. All strings will have 9 characters. YOU have to remove last character from the right when you do the comparison (for example, it will be "167593FY3" - but you will only be grabbing "167593FY" portion for comparison). If any source string in worksheet A has less than 9 char in length or contains special characters - entry is invalid and should be skipped and move to the next row. If a Parameter string has less than 9 char in length or contains special characters - it is simply disregarded. This is a structure for the worksheet A. SourceString1, ParameterString1, ParameterString2, ParameterString3 (etc) SourceString2, ParameterString1, ParameterString2, ParameterString3 - i do not know how many parameters will be there for each individual source string or how many rows there will be. For missing parameter NULL will be explicitly listed. Some SourceStrings will have 2 or 3 parameter strings, some - up to 10. Worksheet B will be nearly identical to worksheet A with the following differences: 1. All strings, source and parameter, will have 8 characters. 2. The Parameter Strings might be different or, even if they are the same - they might be listed in the different order than in worksheet A. 3. There can be a lot more than 10 parameters in Worksheet A for each Source String. The order of Source Strings (row sequence) should be the same in both worksheets, however I would like to have a validation (if worksheet A row 1 has Source String that is different from worksheet B, row 1 - your code should find the right row in Worksheet B with identical source string and perform proper comparison, if it doesnt - it should log it in the "results" worksheet). I am attaching sample excel file with couple of rows in each. This is what I need done: 1. For each row in Worksheet A - grab the string from the first column (Source String). 2. Remove last character from the right. 3. Grab all the parameter strings from the same row, remove last char. from the right and place those strings into an array or hash table. 4. Find the matching source string in the Worksheet B. 5. From that row grab all the parameter strings and place them into array or hash table. 6. Compare two arrays. 7. Report results as following (it should go into the same row number that the original Source String was taken from in Worksheet A: a) log: "Source String ('string value') from Worksheet A was not found found in worksheet B." if Source String was found in both worksheets the following items need to be reported in the following format: Create a new spreadsheet called "Results". Following columns: 1. Source String 2. Total comps found in Worksheet A. 3. Total comps found in Worksheet B. Comps from Worksheet A not found in Worksheet B. Params in Worksheet B not found in Worksheet A. Columns 2 and 3 should have numbers, Column 3 should have a list of comma-delimited parameter strings that were found in worksheet A and not found in the Worksheet B for the given Source String. Column 4 should have a list of comma-delimited parameter strings, found in worksheet B and not found in Worksheet A. Save file with the name "Van_Min_Comp_" and current system date/time. I am attaching the excel sample file, the results worksheet is filled by random numbers/strings that dont reflect actual comparison values in corresponding worksheets its example only.
ID del proyecto: 5805408

Información sobre el proyecto

11 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
11 freelancers están ofertando un promedio de £137 GBP por este trabajo
Avatar del usuario
Hi Sir, I am ready to work for you.I have 9 years of experience in C/C++ , java, Iphone, android and, MySQL. please see some of my works also check my reviews you will get better idea about my skill.I deliver quality work within time frame. Please visit my profile once. Thanks with regards, Amit
£150 GBP en 4 días
4,9 (116 comentarios)
6,9
6,9
Avatar del usuario
Hi, I am Java expert and interested in this project. Please communicate to discuss further. Thank you
£100 GBP en 3 días
4,7 (230 comentarios)
6,8
6,8
Avatar del usuario
Hello , We have a team of Skilled Java-J2EE professionals with experience up to 8 yrs. You will be able to directly communicate with our technical expert, who has done this type of work previously. Our Expertise is J2EE: 1) Frameworks: Struts, Spring , Hibernate , Lucerne, Quartz, Ant, , Cruise Control, jUnit, DbUnit, Mybatis 2) Web Technology: JSP, JSTL, JSF, JQuery, Ajax, Java Script, DWR, FCK Editor, Extjs 3) Application Servers: JBoss, Web logic, Web Sphere, Apache Tomcat, Sun ONE 4) Payment Gateway: PayPal Integration, can integrate any other payment gateways too 5) Tools: Maven, Ant, xDoclet, iReport 3.6 Jasper Report (with iReport), ceWolf API (charts), Maxmind GEOIP API, Atlas Device, Flow Player integration, Google Analytics, adMob Analytics, Google Adword, YouTube API, Document Viewer Integration, Display Tag Libraries, Fusion Charts API, ammap API. More details will be provided on request. By doing this work, we are interested in developing long term relationship by displaying our quality. Thanks for reading our proposal. Regards.
£123 GBP en 5 días
5,0 (11 comentarios)
6,4
6,4
Avatar del usuario
Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready ! Ready !
£250 GBP en 3 días
4,2 (18 comentarios)
4,9
4,9
Avatar del usuario
Hello, This is a easy job for me , but it takes some time to do it proffesional. I can do it also in one day if you are in hurry. I have a lot of experience with excel data. My first project on freelancer for upformkartich included excel processing, you can check the reviews. Regards Mike.
£166 GBP en 3 días
5,0 (13 comentarios)
4,1
4,1
Avatar del usuario
Hi, I'll be happy to help you with this project. Need to see the file Please feel free to message me if you need to discuss any questions you might have prior to award
£183 GBP en 1 día
4,8 (2 comentarios)
3,3
3,3
Avatar del usuario
hi buddy, i have 2 years of experience in teaching and development of java.i have created projects like paint app, hotel management system, sales monitoring system, etc. i am ready to fulfill your requirement. so, for any details feel free to contact me on chat. Thanks & Regards!
£70 GBP en 5 días
5,0 (3 comentarios)
2,7
2,7
Avatar del usuario
hi i am interest in this task . i have 4 years experience in J2ee. part of my work is to analyse datas output into an excel file as well as reading data from excel and update into database with certain business logic comparation. with these experience i believe i can finish this task perfect.
£80 GBP en 3 días
4,5 (2 comentarios)
2,1
2,1
Avatar del usuario
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
£150 GBP en 10 días
3,4 (1 comentario)
2,4
2,4
Avatar del usuario
Hi Sir. This is interesting task. I can help you. Ready to start now, please send the file ))..................................................................................................
£94 GBP en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, First of all there are no attachments in your post; however, reading carefully your explanation and the specifications, everything is clear to me. Second, the required skills selected is "Java" only. Does this mean that you want a clear "Java" based solution? My proposal is for a VBA (in Excel) solution. If this is acceptable, I can create this VBA program fast and efficiently. A few words about me: I'm developing VBA programs for more than 15 years and I'm a trainer for Excel and VBA (all levels) for 12+ years. As you can guess, I have created a plethora of VBA programs of any kind and difficulty level, for both training purposes and business. Looking forward to hear from you, Kind regards, chriskerpini
£140 GBP en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
Maidstone, United Kingdom
0,0
0
Miembro desde jul 18, 2011

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.