Import and tally nominee and winner records for 4 award programs

In your bid details (or message), please propose the milestone structure in terms of dollars.

Milestone 1: Convert the entire history of category, nominee, and winner information into a spreedsheet file for the following award ceremonies:

Game Choice Awards since 2000

[login to view URL]

[login to view URL]

G.A.N.G. Awards since 2003

[login to view URL]

see Awards tab

AIAS Awards since 1998

[login to view URL]

[login to view URL]

Spike/VGX Awards since 2003

[login to view URL]

Submit a sample showing how you would enter one category into the spreadsheet before doing the rest of the work.

Milestone 2: Tally the cumulative number of nominations and wins for each game.

Milestone 3: Using website resources including but not limited to those listed below, fill in any missing developer and publisher information for each nominee.

[login to view URL]

[login to view URL]

[login to view URL]

Milestone 4: Tally the cumulative number of nominations and wins for each developer and for each publisher.

Milestone 5: Where possible, add names of specific recipients of the award by adding and using a column marked "official" and another column marked "unofficial." If there is no official name identified as a recipient or nominee for an award, see if there is any correlating category and person information at

[login to view URL]

However, for this milestone, if you disagree with several credits for nominations, use only the credits for winners (which should be more accurate) and do not supply unofficial names for nominees.

The attached file is a template. Remove the data in the template or make your own file. Start a new spreadsheet for each award group.

Milestone 6: Tally game, developer, publisher, and individual nominations and wins across all award groups, including the one attached, but see me first.

In your response/bid, it must be absolutely clear that you read the project, looked at the file(s), and have something intelligent, clear, or informative to say about what you saw, or you will not be considered. Please do not reply with long boiler plate messages or credentials, or we will suspect an automated reply and it will count against you. Asking any kind of question showing your insight into the project outcome is considered a major plus.

Clarification on Milestone 5: Unofficial names can be derived by searching for a game at http://www.mobygames.com/ and reviewing the credits document for the game if available. When assigning unofficial attributions, use the following guidelines: For any category, disregard "Senior" credits. For any Game of the Year genre category, producers other than executive producers should get the attribution unless there is a creative director. If too many producers are equally tiered and there is no creative director, a lead designer can be substituted.

The following comments should be read after viewing the attached template:

1. For the work of this project, AWARDED AS and CATEGORY will always be identical.
2. The TITLE and NOMINEE only differ for performance and song categories.
3. Unofficial names should be included when you are confident. When not confident, you can always ask me, and after about 10-20 queries you will probably feel as if you have grasped the intended attribution process.

Estimated amount of data

Game Choice Awards since 2000
average 14 categories x 5 nominees x 13 years = 910 rows of data

G.A.N.G. Awards since 2003
average 21 categories x 5 nominees x 12 years = 1260 rows of data

AIAS Awards since 1998
average 24 categories x 5 nominees x 17 years = 2040 rows of data

Spike/VGX Awards since 2003
average 24 categories x 5 nominees x 11 years = 1320 rows of data

Estimated total = 5530 rows of data

Xử lí dữ liệu Web Scraping

ID dự án: #6345119

Về dự án