Re-format and standardize customer database - Excel

Terminé Publié le il y a 7 ans Paiement à la livraison
Terminé Paiement à la livraison

This is probably best suited for someone who has good Excel programming skills, as well as some data entry and good accuracy and attention to detail. There are 415 records in the job file.

I have several different lists, each representing a different group, but they all need the same process applied. There will be 14 lists with an average of 300 records on each, with the smallest being around 170 and the largest being around 700 records.

You must have a very good understanding of English to complete this job well. I have these lists every now and then, so I wish to find a freelancer to use more than once.

• This job is a test to find a great freelancer to help on the larger project.

• It will focus on establishing a process and understanding on this 1 list, so that if done right I can have you do the other 13 lists as a separate job. Of course you will be much more efficient and faster on the other lists once you have figured out the best way to do this.

• Please price this job accordingly - that you will invest more time on setting up this first one, but the subsequent jobs will be much faster and simpler for you.

I want these lists to end up showing individual’s names in most cases – not the various other entities that are often used such as Trusts or other entities (Companies, or LLC’s, etc.).

Therefore, I want you to first separate each list into 2 sub-lists, and title them as follows:

1. “Names” (these will be all records with standardized names)

2. “Others” (these will be all of the Trusts , LLC’s, or other entity names)

The final product will be sending me the 2 lists in Excel format:

1. Names

2. Others

I wish to award this today, and need the finished list by Wednesday morning.

Please see the more detailed instructions and sample Excel file attached here. Ask any questions or for clarifications - it is critical that you understand this and do it properly, or it will be a waste of time for both of us. Along with your bid please make sure to outline what your approach will be to make this a fast and efficient process: will you use Excel formulas, programming, convert to another software to better manipulate then convert back to Excel, use some manual data entry or not, etc.?

Thanks,

Bruce

Saisie de Données Traitement de Données Excel

Nº du projet : #12076119

À propos du projet

48 propositions Projet à distance Actif il y a 7 ans

Décerné à:

nagybatonyi

Hi, 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 macr Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(63 Commentaires)
5.7

48 freelances font une offre moyenne de 135 $ pour ce travail

TypingxpertRehan

ok sure i am ready to start immediately can we discuss? thanks............................................

$263 USD en 4 jours
(1436 Commentaires)
9.1
cgullapalli

Hi, I am good at Excel and vba. I have gone through the excel file provided. I have got good understanding of seperation of details. It is purely manual process. No automation is possible. Looking forward to work on Plus

$221 USD en 3 jours
(873 Commentaires)
8.0
Eagles90

Dear Bruce, I am interested in your project and ready to go for it. I will use the mix of formula and visual basic for application code to get the job done. I look forward to hearing from you. Kind Regards, S Plus

$70 USD en 2 jours
(168 Commentaires)
8.1
sandroshubladze

Hello, as you are promising more offers I am offering you that price. However, I have good understanding of English and I love programming in excel I can show my works if it is needed but I love doing such jobs lik Plus

$100 USD en 2 jours
(210 Commentaires)
8.2
jubair7

Experienced TEAM HERE to work for your project. Let's discuss more and finalize the project and cost. We have our own workplace with 9+ working PCs and laptops, with ~15mbps internet connections. We also have a back Plus

$200 USD en 3 jours
(333 Commentaires)
7.8
elqueabandona

Hello Bruce, 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. PS: I think the best approach here is to use formul Plus

$150 USD en 2 jours
(230 Commentaires)
6.9
ZedExcel

Hi. I have read and understand the requirements of your project. My approach would be as follows: 1. The first task will be to separate the list into Names and Others list. This will be achieved by using a search form Plus

$150 USD en 2 jours
(35 Commentaires)
6.9
MohsanEijaz

I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y Plus

$222 USD en 3 jours
(83 Commentaires)
6.3
atifdar

Hi there, MS Excel expert here, I completely understand your requirements, I've read the project description and also instructions written in MS Word document also seen sample spreadsheet I'm 100% confident that i wi Plus

$172 USD en 2 jours
(86 Commentaires)
6.3
szymszteinsl

Hi! I am professional C/C++/C#/Java programmer. I can do this project with highest quality! Best Regards, Szymszteinsl

$250 USD en 4 jours
(4 Commentaires)
6.4
dpune

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Please send me exact numbers of all the list so that I can estimate cost accordingly. I have completed more than 290 proje Plus

$200 USD en 3 jours
(175 Commentaires)
6.4
bdoutsource

Dear Sir, Greetings. I have checked those 2 attached resources. The main goal is to separate the provided raw data base in 2 criteria, Name(Individual and Other(Company, Business,..), also Spouse/Partners Name, Ma Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(189 Commentaires)
6.7
Saidul28

Hello , I am Saidul . I am expert in Data entry work. I have read your project details and I am a hard worker; I feel that I work quickly and concisely with little direction. I have excellent skills in all Microsoft O Plus

$111 USD en 3 jours
(50 Commentaires)
5.8
sonarkaushik

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. Plus

$194 USD en 3 jours
(101 Commentaires)
6.2
citijayamala

expert in excel and excel formula function, have done many projects in excel, have created many excel templates, expert in vlookup macros pivot table and charts, can complete it on time with good quality. experienced M Plus

$100 USD en 3 jours
(65 Commentaires)
5.6
vsprybhanu

Hi, Experienced Excel VBA and VB.Net Programmer. I have read your instructions carefully. I have excellent knowledge and experience of manipulating string, columns and rows. I checked your documents. My Plus

$120 USD en 3 jours
(68 Commentaires)
5.4
sharpzulfiqar

"Dear Client, Update: Thanks for your patience; I have reviewed your excel file along with word document and understood the job. I am ready to start on it. As you explained, for the first time, i need to setup Plus

$111 USD en 2 jours
(4 Commentaires)
5.1
denisaelena

Hi sir, I'll finish this task in max 24 hours. I can't download and preview the attached files, don't know why, it's not downloading, but as I understood from you very good description, I'm pretty sure that I'll manag Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(24 Commentaires)
4.8
nineoneone

Will do this one for a good review! Professional work, in time, with ZERO errors, for sure! We aim to be your one stop solution for ALL IT needs, and provide a 100% SATISFACTION GUARANTEE. We do not charge you, if y Plus

$155 USD en 3 jours
(21 Commentaires)
4.7
humayoonsheikh4u

A proposal has not yet been provided

$100 USD en 3 jours
(12 Commentaires)
4.1