Find Jobs
Hire Freelancers

Compare data in 2 excel spreadsheets

$30-250 USD

Em Andamento
Publicado há quase 10 anos

$30-250 USD

Pago na 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 do Projeto: 5805209

Sobre o projeto

6 propostas
Projeto remoto
Ativo há 10 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos

Sobre o cliente

Bandeira do(a) UNITED STATES
Lords Valley, United States
5,0
13
Método de pagamento verificado
Membro desde ago. 10, 2008

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos 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)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.