Cancelado

MySQL Excel connection/ coversion

Hi Guys

I need some help in converting EXCEL Vlookups, If, etc... functions to

convert them into Update and Insert Queries

in the Mysql Table.

I need someone who has experience in Advance Excel and mysql. The winner bidder i will send him the excel and more specified requirements

## Deliverables

I have a Big Excel Table for example (A1 to D1) that I update from a txt file (Import), now Colums E1 till Z1 for example contain functions that

are vlookups, if, INdex, match , etc..

and this excel sheet I want to transform it mysql so that It doesn't take me alot of time copying and pasting, refreshing formulas, etc....

so the functions that I want to transform to mySQL are:

I need to update/ insert fields in the same table

Below is some of the excel function in the cell:

=IF(K2="","NULL",VLOOKUP(K2,'Mapping_TAB'!$J$4:$N$100,5))

Mapping_TAB is a sheet that contain small tables that I lookup these values from, so from my side I will import them to separate tables.

=IF(U2="text","t",IF(N2=1,"P",IF(Y2="Ex",Y2,

IFERROR(VLOOKUP(X2,'Mapping_tab'!$A$4:$E$30,4,0),"F"))))

=IF(Z2<>"B",T2/INDEX(Tab!$B$96:$AV$107,MATCH("T",Tab!$B$96:$B$107,0),MATCH(H2,Tab!$B$96:$AS$96,0)),0)

the winning bidder i will forward the excel sheet and the requirents

Habilidades: Engenharia, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software

Ver mais: php and mysql connection, p.c. connection, N2, i need excel help, advance excel+, vlookup table, need excel help, excel advance, Vlookup, mysql index, excel vlookup, excel table, excel function, Excel Formulas, excel ex, advance excel, php import excel file mysql, excel file mysql, txt convert excel, mysql convert text, php tab php mysql, lookup table mysql, insert txt, mysql function update, txt file import excel

Acerca do Empregador:
( 9 comentários ) Saarbr?cken, Germany

ID do Projeto: #3520170

2 freelancers estão ofertando em média $26 para este trabalho

jacobdd1

See private message.

$25.5 USD in 3 dias
(268 Comentários)
7.1
JackWorm

See private message.

$25.5 USD in 3 dias
(9 Comentários)
3.7