Visual Basic for Excel App to Create Spreadsheet of list of names & data by finding a match in FaceBook

Our running club uses FaceBook to manage our activities. We have about 700 members on our club page ([url removed, login to view]) and the members come and go regularly as the organization continues to grow. We also participate in running races in our local area frequently. The results of these races are usually posted on a web site and we can download them into Excel. This project is to build an application, in any system you choose (but Visual Basic for Apps (VBA) in Excel seems logical). Simpler the better. It should do the following:

1. INPUT1: Read the latest list of FaceBook members (builds a list) from the FaceBook page.

2. INPUT2: Read in race results from an Excel file which contains the results of a running race (unless it is easier to read it directly from the web).

3. Normalize the lists so that a comparison can be made.

4. Scrub the Race Results spreadsheet to remove non-members.

5. OUTPUT: Produce a new spreadsheet with only the data for the matching members.

In other words, we need an automated way to scrub a race results spreadsheet to remove any non-members.

The two difficult parts of this project will be:

1. Reading the list of names from FaceBook.

2. Normalizing the Race Results spreadsheet. Race Results arrive in many forms with various types of data in varying columns. They will always have a name field but sometimes there will be First Name and Last Name fields. Sometimes the Full Name will be in one field and if so, it could be last name first or first name first. If varies depending upon the producer of the data.

Output of the system should be an Excel spreadsheet with all the data for each entry intact and in separate cells aligned in proper columns with column headers. If possible, just leave it in the format in which it arrived.

Here is an examples of race results pages:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

I am also attaching several Excel Results files that have been downloaded from these sites. If it is less costly and easier, we can manually download the results data in Excel format as Input.

SPECIAL NOTE: Our FaceBook Group page is an Open page, but we will NOT add non-locals and non-runners to the group, so unless you are selected to do the project, please do not request to join the group. That said, there is nothing special about this FaceBook group page. All FaceBook group pages are the same and build their member lists in the same way. You could just create your own very simply for development and testing purposes.

Need to add another step:

2a. INPUT3: Read in a normalization file (text or Excel) which maps weird FaceBook names to proper names. This file is maintained manually and grows as weird names that need normalization are found. Compare each name from the FaceBook list generated against this normalization file.

Evner: Excel, Visual Basic for Apps

Se mere: WP web development, web apps examples, web app examples, visual basic for applications, uses of php in web development, types of development web, types of data entry fields, spreadsheet to web application, sites to create web pages, new spreadsheet app, match list, in need of a producer, i need a producer name, finding match, excel special, create your page, create apps from any web content, app vba, 3 types of data entry, uses for excel, excel uses, visual basic web, i need a producer, data entry apps, data entry activities

Om arbejdsgiveren:
( 11 bedømmelser ) Sewalls Point, United States

Projekt ID: #5991233

Tildelt til:


Hello, I have done something like this in the past, so I can reuse code. Solution for the problem with matching fields in scrub process can be easily solved creating a filter creation template, so you say to the pro Flere

$100 USD in 3 dage
(2 bedømmelser)

5 freelancers are bidding on average $116 for this job


Hi, We are a team of MBA professionals with specialization in Finance and Marketing. We have prior experience of doing such projects. We can finish off your task in the desired time with the expected quality. Also Flere

$140 USD in 7 dage
(7 bedømmelser)

Dear sir, I am very much interest to your job that is “Visual Basic for Excel App to Create Spreadsheet of list of names & data by finding a match in FaceBook ”. I have a lot of experiences in internet research, da Flere

$111 USD in 10 dage
(1 bedømmelse)

I'm new here but not new in this job. I have done it before and now have much interest with that. I think I'm reliable and comfortable for this [url removed, login to view] know this type of cover letter is just one of the complement and Flere

$111 USD in 15 dage
(0 bedømmelser)

Dear sirs, I am very experienced in Excel as I've worked for major investment banks and technology companies. So you're definitely having the best quality you can have. I'm a seasoned financier with experience f Flere

$120 USD in 6 dage
(0 bedømmelser)