Analyze Excel table to find and remove paired records

$10-30 USD

Terminado

Publicado

hace más de 8 años

$10-30 USD

Pagado a la entrega

I have a database of invoices. There are cancelled invoices denoted by negative number in 'revenue' field. Remove pairs of records where 'Bill to Customer' value is the same and 'Revenue' values are the same, except that one revenue value is negative, the other is positive. In attached database you will see lines 59 and 60. These are an example pair that must be removed. The positive 'revenue' value is the original order, and the negative value is the cancelled order - same order, but cancelled. You will need to write some code in either Python or in Excel to match the criteria, and remove the records. Please include in your code a function to paste the removed records to a 2nd worksheet so I can review the removed records. Hope this makes sense. Need asap. Going away for 6 hrs but am attached dataset if you want to try your hand at the programming and submit results. I will award the project when I wake up. Link to dataset: [login to view URL] Thank you! Chris

Excel

Python

Visual Basic

ID del proyecto: 8304120

Información sobre el proyecto

28 propuestas

Proyecto remoto

Activo hace 9 años

¿Buscas ganar dinero?

Dirección de email

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

Adjudicado a:

@DenisWe

Hey Chris, I removed the duplicate lines for you. I wrote a script to check if the BtC values match and if the revenue is the negative of the other row. I optimized it so it doesn't take hours to run and you can quickly rerun it. I converted the xlsx to a csv file to precess them. I inserted both csv files into the original excel file so you don't have to do it. (I counted the lines, they match up with the original number, and checked the values. Everything seems right.) Please accept this bid so I can send you the script and the file and you can quickly continue your work. Best Regards, Denis

$24 USD en 0 día

0,0

(0 comentarios)

0,0

28 freelancers están ofertando un promedio de $27 USD por este trabajo

@deepbluetech

Hi Chris, I am an Excel macro expert and would be happy to take on the project. Please confirm and I shall deliver the macro within a day. Regards, Arul

$60 USD en 1 día

5,0

(178 comentarios)

6,6

@DeepSyaal

Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?

$25 USD en 1 día

4,9

(160 comentarios)

6,2

@nagybatonyi

I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files (or the folders containing them, as required by the job) and hosting command buttons and other controls if necessary. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards

$20 USD en 0 día

4,9

(56 comentarios)

5,7

@elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards

$60 USD en 3 días

4,9

(65 comentarios)

5,7

@javed1705

A proposal has not yet been provided

$24 USD en 1 día

4,9

(54 comentarios)

5,6

@paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).

$50 USD en 3 días

4,9

(56 comentarios)

5,5

@cgullapalli

Hi, I am good at excel and excel vba programming. Looking forward to work on this project. I can revome the records based on excel programming. Please see my testimonials on the works handled in excel. Hi, I have completed the programming part. I would like to discuss. I can readily give the output. Note:- i have removed the zero's as well. If it is not the case, i can change the accordingly and submit.

$30 USD en 1 día

5,0

(46 comentarios)

4,7

@catstevens2009

Hi there! Have both the lists ready for you! The paired records moved to a separate tab 'dupes' and the non-paired records in the original tab 'data'. Please message me and I will send it (the file) to you! Thanks! -Steve

$35 USD en 0 día

5,0

(27 comentarios)

4,7

@OniNeko

I am a professional Data Analyst with over a decade of experience. I can have this project easily completed for you within 2 hours. I can also, as requested provide on a separate sheet a copy of all of the removed records, and I offer a 100% accuracy guarantee. I look forward to working with you!

$25 USD en 1 día

5,0

(32 comentarios)

4,3

@rohitagarberg

Hi sir, I will remove the positive negative pairs for same invoice and save them in separate sheet for review using code. Ready to start and finish right away. Thanks

$10 USD en 1 día

5,0

(55 comentarios)

4,4

@SauraLancer

Hi, I'm an expert and experienced Python programmer and I've worked on numerous similar project involving data analysis. I've already written a script to identify such pair of lines where the "Bill To Customer" and "Revenue" have the same value except for the fact that revenue values are inverse of each other. Few more example: Lines 8 & 52, 9 & 47, 11 & 37, 12 & 26, 13 & 19 etc. I also found that there are entries having one positive revenue and 2 negative revenues for example lines 8, 52 and 53. What should I do for such values? Please get in touch with me for discussing further details. Thanks

$20 USD en 0 día

5,0

(5 comentarios)

3,5

@TonmoyRoy111

A proposal has not yet been provided

$25 USD en 2 días

5,0

(23 comentarios)

3,5

@shagoon2u

we can develop the code for excel. Could you please confirm if the database is in excel. We are not able to see the db due to current redirection error. Thanks Shakun rastogi

$35 USD en 1 día

4,8

(3 comentarios)

2,9

@slenders13

Dear Client, I have a lot of experience with VBA and Excel. I have seen the excel sheet and this is no problem for me. If you want a reliable programmer choose me. Send me a message for more information. Kind Regards, Rens Slenders SlenDATA

$30 USD en 1 día

5,0

(2 comentarios)

2,7

@Niklak

Hi I think I can do that in Python using csv module (xlsx for Python to slow). When script will finish its work I will write again. Good luck.

$20 USD en 0 día

4,9

(2 comentarios)

1,4

@MohsanEijaz

I think I am a good fit for this job because I have all the qualities that you are looking for. Experience is the golden factor in this project where you find in me at least 3+ years of working experiences over all the factors in your project.

$20 USD en 1 día

4,6

(2 comentarios)

1,0

@gsanggara

Hello, I am very interested to your project. with my experiences in excel formulas & excel macro I am very confident that i will deliver good result as per your requirement on time. -. in order to do that I need an example file for ref & lean the process. and/or your brief on your needed. I am new to Freelancer & trying to build a solid profile. i appreciate If you would like to talk thru PM before awarding this project as I'm online now. Hope to hear from you soon. Thank & Regards, gsanggara

$25 USD en 1 día