I gang

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.

Færdigheder: Excel, Visual Basic for Apps

Se mere: web apps examples, web app examples, uses php web development, types development web, types data entry fields, sites create web pages, new spreadsheet app, match list, need producer name, finding match, excel special, create apps web content, app vba, uses excel, excel uses, visual basic web, data entry apps, data entry activities, visual content, visual basic apps, visual basic app, vba excel, race parts, producer name, names column

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

Projekt-ID: #5991233

Tildelt til:

mcanyas

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 Mere

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

5 freelancere byder i gennemsnit $116 for dette job

rahulraut89

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 Mere

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

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 Mere

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

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 Mere

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

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 Mere

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