Completed

Research and ADD 3 Data Elements to Each Row of My Spreadsheet - 887 Rows in Total

NOTE:

I will AUTOMATICALLY DELETE ALL BIDS / PROPOSALS if it's not OBVIOUS that you have read this entire Project Brief, and have Opened the Attached Spreadsheet and Analyzed the Data we are seeking.

PROJECT BRIEF

The attached spreadsheet has 887 rows. In each row there are 3 missing data elements that we want your help capturing. The missing data elements are located in columns "C", "G", and "J".

Missing Data Element Descriptions

Column "C": FIRST NAME or Initials

To complete this data element you will need to analyze the name listed in Column "B". You can do this manually or with an automated script. In either case, what we want you to do is to accurately identify the persons First name or Initials and place ONLY their First Name or Initials in to Column "C". It is likely you'll discover that over the 887 names, 100-200 of them will NOT have obvious First Names or Initials. For these, we will look to you to make a "best judgement" on placing their First Name in this field.

Column "G": Abbreviated Book Title

In Column "F" you'll notice that there is a VERY long book title. We want you to translate this long book title, into an appropriate "abbreviated version".

For example. If the LONG book title reads:

Tribal Leadership: Leveraging Natural Groups to Build a Thriving Organization

The the Ideal ABBREVIATED Version would read:

Tribal Leadership

Column "J": SHORTENED URL for the Review Link

You'll notice that in Column "I" there is a VERY LONG URL LINK. We want you to use [url removed, login to view] URL shortener to CONVERT each LONG LINK into a custom SHORT URL LINK that you will place in Column "J".

It is IMPERATIVE that you are meticulous and careful in creating these three additional data elements for each row.

Skills: Data Entry, Data Mining, Data Processing, Excel, Web Scraping

See more: vbscript add xml data xml file, firefox add store data, add csv data google maps, how to sum multiple rows in excel, how to add two columns in excel, how to sum multiple rows and columns in excel, how to sum multiple columns in excel, how do i add a sum in excel?, how to add numbers in a row in excel, excel sum entire column, formula for total in excel, data entry, data processing, excel, web scraping, data mining, add form data csv file, add mails data base, add post data entry, add commas data

About the Employer:
( 82 reviews ) Raleigh, United States

Project ID: #16112056

Awarded to:

amranreza70

Hi, Sorry for delay response. I was reading your description properly and have got your concern. I ensure you 100% accuracy. It seems so much easy for me. If you want I can do the project with you. Please come on ch More

$80 USD in 3 days
(54 Reviews)
5.3

33 freelancers are bidding on average $114 for this job

FINGERRPRINT

Hi there, we have read full description.. understood very well. Sample for first 3 Rows First Name Larry Nickel - Larry Donald Hsu - Donald Blaster - Blater Book Title - ABBREVIATED Who Says Elephan More

$157 USD in 2 days
(315 Reviews)
8.0
sobujprantor

HI I think i will be able to find the missing details. Can you send the list to me please. It will help me to understand the job properly..................................

$111 USD in 2 days
(288 Reviews)
7.5
ponnarasiBabu

Hi, Read your requirements and went thru the enclosed excel. I have worked out few samples as below, kindly check and let me know if this is what you are looking for Row no 2...Larry, Who Says Elephants Can't Da More

$211 USD in 5 days
(388 Reviews)
7.3
hatemfreelance4

I read the descreption carefully an I belive i identify the 3 missing Data Elements as the name and Book Title - ABBREVIATED very well. My field of expertise includes: Data Entry Leads generation Data Processi More

$166 USD in 4 days
(118 Reviews)
6.2
deepabittu

Hello sir I am really want work this project so award me project. I have 5 member team and do this job easy way

$111 USD in 3 days
(269 Reviews)
6.6
sonarkaushik

I am very able to add those data elements in excel sheet and ready to start Sir, I am well versed in this kind of jobs and can do your project as per requirement. Message me for further discussion. Waiting More

$144 USD in 3 days
(107 Reviews)
6.3
Smasum002

Hi I have read full details of the project but my question is there are many same book tittle, so, these will be same on column g? thanks waiting for you

$250 USD in 10 days
(89 Reviews)
5.5
$100 USD in 3 days
(60 Reviews)
5.3
SarahFerns

Hello, Completion time: 5 Days Sample: Target - bradlist Name - Larry Nickel Parsed First Name or Initials (If Possible) - Larry Accolades Email - nickelpl at [login to view URL] Book Title - LONG VERSION More

$133 USD in 5 days
(46 Reviews)
5.2
Ranitani9

A proposal has not yet been provided

$99 USD in 1 day
(25 Reviews)
4.5
mahisha123

Hi, I’ve gone through your requirement . I am very much interested to work with you on this project. I do have expertise in the specified area. I can start the project right away and can complete as soon as possible. More

$155 USD in 3 days
(27 Reviews)
4.6
bilalsafdar111

Hi, I deeply read your bid and open an attached file. I am pretty sure i can explore your desire requirements within project description. If you give me chance for this task i can start right now and will provide best More

$123 USD in 3 days
(47 Reviews)
4.8
mmunirh

Hi, I have gone through the the descriptions and attachment very carefully. I can separate initial, abbreviate title and shorten the links accurately. I'm highly interested to do this project properly. You can ask m More

$100 USD in 3 days
(10 Reviews)
3.7
shezy007

Hi Sample : Row 1 Column C : Larry Column G: Who Says Elephants Can't Dance? Column J : [login to view URL] I've read the complete Project Description and Understand the requirements you have pos More

$70 USD in 5 days
(13 Reviews)
3.8
TypingNOW

Hello! I am an experienced virtual assistant. I will put the correct FIRST name, BOOK abbrivation and shorten the URL perfectly. Satisfaction my priority else you do not pay. Looking forward!

$45 USD in 2 days
(10 Reviews)
3.5
prasannjeetp

My key skills are relevant to this project. I have huge experience in this area. I can do this project very efficiently.

$30 USD in 1 day
(12 Reviews)
3.4
zajjithvedha

Hi, I have a good experience in data entry, data processing and excel. But I'm a new freelancer so I doesn't have reviews in these relevant skills. But I confirm you I can do this work very well. Also if you want to More

$30 USD in 1 day
(5 Reviews)
2.6
dkdmym

Hello, Thanks for the post. I have read your whole description- and check excel file.I think I fully understand your [login to view URL] you want sample task, I will provide [login to view URL] can discuss more over the message. I hope a posi More

$150 USD in 3 days
(5 Reviews)
2.0
$35 USD in 3 days
(3 Reviews)
1.5
FaseelaPN

I read the description, It looks interesting. I Can do it accurately within 7 days.

$55 USD in 7 days
(2 Reviews)
1.3