I need an experianced programmer that can translate advance excel formulas into sql queries. I have about 16 Excel formulas that need to be translated. An example would be: =IF(J2="";"";IF(AND(J2="MMS";M2<>"[email]";LEFT(M2;3)<>"352")+(AND(J2="national";LEFT(M2;3)<>"35"))+(OR(J2="Terminating";J2="Originating";J2="Call";J2="international";J2="Call";J2="SMS";J2="Intcall";J2="TSMS";J2="DATACl"))+(AND(J2="aSMS";S2<>"Free Crm";S2<>"SFree";S2<>"4-Ticket ";S2<>"S-LA "));VLOOKUP(J2;Cname;2;FALSE);VLOOKUP(J2&S2;'IRPas+'!$Q$3:$V$1500;4;FALSE))) Thus, it should be translated or transformed into: update table where (select, bla. bla bla...), etc... I need someone who knows a bit of advance excel formulas and alot of sql so that he can develop the corresponding sql statement. The output should be an "sql script" with all the update, insert, or select statements, that should run in mysql query. In order for me to choose you as a winning bidder: Before putting your bid type is the solution, the sql query for the above function. Even if you dont have the colum names or the table name just replace them with X Y Z or "Column2", "Column3", etc...
## Deliverables
[login to view URL] requirements notice: As originally posted, this bid request does not have complete details. Should a dispute arise and this project go into arbitration "as is", the contract's vagueness might cause it to be interpreted against you, even though you were acting in good-faith. So for your protection, if you are interested in this project, please work-out and document the requirements onsite.
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).
## Platform
sql query using mysql