Find Jobs
Hire Freelancers

Compare Excel data in diffrerent files and show differences

$10-30 AUD

Complété
Publié il y a presque 10 ans

$10-30 AUD

Payé lors de la livraison
RULES: Do NOT ask us what our budget is. Bid exactly what you will charge us. Your feedback MUST be greater than 5. Your completion rate MUST be better than 65%. DO NOT waste our time if you do not meet the above criteria. If you do, we will flame you as a result. BRIEF: I have numerous Excel files that contain about 60,000 rows of customer data each. Here are the columns: State txtRentalOrderId txtCreationDate txtCustomerName txtContactName txtTerm txtFromDate txtSalesperson txtToDate txtStatus txtAssetList txtOrderTotal Each file: a) is saved in the format of: "Orders - June 7 [login to view URL]" (where the date part changes with each save and depends on the date the file is saved; right now I am trying to generate a new file 3 times a week). b) contains details of client orders. The Unique ID for each order can be generated by merging column "State" & "txtRentalOrderid" using the concatenate function. c) is a representation/snapshot of all orders at a given point in time. Each older file (i.e "Orders - June 1 [login to view URL]" contains data that is a subset of the file after it, i.e. "Orders - June 7 [login to view URL]". Each newer file contains all data from the previous file PLUS all data that has been generated since. SOLUTIONS I AM SEEKING: 1) Determine which order ("txtRentalOrderId") has changed the sales exec ("txtSalesperson") associated with it over time. For example, a particular client has had an open order in the system with Mike. Mike quits the company and assigns all his orders to Jack. I now need to track which orders changed hands and who they were assigned to. This is particularly important as Mike and Jack were good friends at work. So by assigning all his likely bookings to Jack, Mike is giving Jack an unfair advantage over the rest of the team. 2) Determine which order ("txtRentalOrderId") had its client ID changed ("txtCustomerName"). For example, "txtCustomerName" was "Lenovo" to start with. Then, the sales exec who was dealing with Lenovo was told by its rep that they will not proceed with their booking due to a change in requirements. Now, if the sales exec closes the quote as LOST, it will affect their conversion (one of the KPIs). So instead of marking the booking as LOST, the sales exec just changes the "txtCustomerName" to a different client (i.e. HP) when a new quote request comes through from HP (instead of creating a totally new quote in the name of HP). That way, the sales exec can keep on changing the "txtCustomerName" until some client agrees to the quote and the quote is closed as WON. Such behaviour manipulates the conversion rate of the sales exec in question and makes it seem that they are winning a lot more quotes. 3) Determine which order ("txtRentalOrderId") had its start date changed ("txtFromDate"). Sales execs should only be allowed to change the start date of a quote once. For example, a client initially indicates that they want to start their event on July 20. So the entry in the "txtFromDate" column becomes "July 20". However, closer to the date, the client decides to change the start date to August 20. The sales exec then changes the "txtFromDate" to August 20. However, closer to the date, the client once again is undecided and changes the date to October 20. At this point, the sales exec should close the quote as LOST and move on. However, what I am seeing is that the sales exec keeps on pushing the date forward endlessly. This protects their conversion rate as the quote is not marked as LOST by August 20. START DATE The project needs to be started and completed within 1 week. DEADLINE 1 week MILESTONE RELEASES Milestones will be released within 24 hours of successful UAT completion. Good luck!
N° de projet : 6043236

Concernant le projet

10 propositions
Projet à distance
Actif à il y a 10 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
Décerné à :
Avatar de l'utilisateur
I can create a template for you which will show you the compared data with differences in 3 tabs for 3 solutions.
$30 AUD en 1 jour
4,9 (93 commentaires)
5,5
5,5
10 freelances proposent en moyenne $60 AUD pour ce travail
Avatar de l'utilisateur
Hi, I am interested in your project. You can count on me for a fast and 100% accurate job done. Please provide the files to be organized. Thanks & Regards, Peter
$150 AUD en 6 jours
5,0 (51 commentaires)
6,1
6,1
Avatar de l'utilisateur
Please send me sample excel files. I have large experience of writing vba code. I will cover all the 3 points until no change in the excel file format. You can check my Excel ratings
$30 AUD en 1 jour
4,7 (32 commentaires)
4,7
4,7
Avatar de l'utilisateur
Hi there, I've been working with Excel since before 2K and I've been using all possible versions of it. I have years of experience working with macros and writing code / debugging Excel VBA code. You may check my portfolio images to see few pieces of my kind of work. I am also used to work with large amount of data for processing. (This is what I do on daily basis). I would need some sample files to start working on an application that should meet your requirements. Best Regards, Jon
$150 AUD en 7 jours
5,0 (19 commentaires)
4,4
4,4
Avatar de l'utilisateur
A proposal has not yet been provided
$100 AUD en 7 jours
4,8 (11 commentaires)
3,1
3,1
Avatar de l'utilisateur
Dear Sir, please check my profile. My maximum project is same for your project and Recently finished similar project. I know some beater knowledge how to Find companies, Email, address, Person name, What you want So I can do the work acquired perfect in time. Please see first my work sample and if you like my sample then award me. Waiting for your reply. Thanks
$25 AUD en 1 jour
4,5 (7 commentaires)
2,6
2,6
Avatar de l'utilisateur
Hello Sir i am ready to discuss with you about the project i am really interested and want to do work with you kindly response me so we can discuss thanks. Regards Rashid
$30 AUD en 0 jour
3,9 (3 commentaires)
1,7
1,7
Avatar de l'utilisateur
Already done work on this same project with fast and satisfied result and i have best skill on excel
$25 AUD en 1 jour
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
A proposal has not yet been provided
$30 AUD en 6 jours
0,0 (0 commentaires)
0,0
0,0

À propos du client

Drapeau de AUSTRALIA
Sydney, Australia
4,8
34
Méthode de paiement vérifiée
Membre depuis nov. 24, 2011

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.