Combine spreadsheets carefully

Ολοκληρωμένο Αναρτήθηκε Πριν 6 χρόνια Πληρώθηκε κατά την παράδοση
Ολοκληρωμένο Πληρώθηκε κατά την παράδοση

The new mini-project would be to very carefully combine the following source docs to match the column number and order of the master doc.

Sources:

[login to view URL]

2015 Updates All Six Awards Corrections (14-08-2016).xlsx

Master:

[login to view URL]

Lastly, the scope would also be to update 2016 for all awards for which we already have full data (navgtr already done) and create two versions of this master: one with tabs and one without.

You should be able to fill title, nominee, winner, developer, publisher at a minimum, and some names.

If websites do not provide "Official" individual names, you may use the "nominees" file...

[login to view URL]

...to extrapolate names from a similar navgtr nomination where it makes sense to do so, and enter those names in the "Unofficial" column. The 2015 file's rightmost columns also help to indicate which categories are similar or equivalent. For any missing information after this process, write "TBD."

In the future (not part of this scope), we might consider developing an equally full historical record for the four new awards: The Game Awards, IGF, SXSW, and WOA. All but IGF are only a few years old. IGF is about the number of categories and years past as GDC.

Εισαγωγή Δεδομένων Επεξεργασία Δεδομένων Excel Web Scraping Διαδικτυακή Αναζήτηση

Ταυτότητα Εργασίας: #13860617

Σχετικά με την εργασία

46 προτάσεις Απομακρυσμένη εργασία Ενεργό Πριν 6 χρόνια

Ανατέθηκε στον:

Beacon09

Bid Summary Project to be initiated as discussed in chat. Project Requirements A Main master file, and 2 versions of 2016 master. Relevant Skills and Experience Previous projects Proposed Milestones $100 USD - Maste Περισσότερα

$100 USD σε 7 μέρες
(95 Αξιολογήσεις)
6.7

46 freelancers κάνουν προσφορές κατά μέσο όρο $154 για αυτή τη δουλειά

jaylancer43

Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-st Περισσότερα

$210 USD σε 3 μέρες
(774 Αξιολογήσεις)
8.6
sandroshubladze

Hello I am an excel expert with huge experience of web searching. I can provide perfect service for you. On the other hand I am huge fun of gaming. I have played almost every single game in your list. Following fr Περισσότερα

$250 USD σε 5 μέρες
(221 Αξιολογήσεις)
8.3
jubair7

Just finished a similar project. Experienced FREELANCER HERE to work for your project. Let's discuss more and finalize the project and cost. Feel free to ask me questions, if any. I look forward to work with you. Περισσότερα

$150 USD σε 3 μέρες
(347 Αξιολογήσεις)
7.8
saqibmunir55

can combine files can combine files can combine files can combine files can combine files can combine files

$200 USD σε 2 μέρες
(710 Αξιολογήσεις)
7.6
nomannaumi

Hello sir, just saw your project description and you are looking for a freelancer to carefully combine source docs to match the column number and order of the master doc. I have experience working in this field for 4 y Περισσότερα

$30 USD σε 3 μέρες
(77 Αξιολογήσεις)
7.0
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. Περισσότερα

$194 USD σε 2 μέρες
(112 Αξιολογήσεις)
6.3
farooq4161

I have thoroughly studied your project detail, I can do your project within 1 day and with 100% accuracy. I am doing web scraping from last 5 years and your task is easy for me. after complete satisfaction and tes Περισσότερα

$90 USD σε 0 μέρες
(64 Αξιολογήσεις)
6.2
sangwanpankajs

Bid Summary hello sir i little bit understand your project .... u have match up the columns according to master sheet .... Project Requirements i think i am able to finish this task .... Relevant Skills and Experi Περισσότερα

$90 USD σε 2 μέρες
(103 Αξιολογήσεις)
5.5
ianoc

Bid Summary Hi! I would be glad to help you with this and I could definately get this done for you with 100% accuracy and faster than anybody else here. Project Requirements I understand your requirement is to combine Περισσότερα

$120 USD σε 3 μέρες
(33 Αξιολογήσεις)
5.6
satishtl

Bid Summary - Went through the 3 files, winnners, nominee and the master, can get the final template extracted from these files matching the column number and the order. - Have done similar consolidation. Project Re Περισσότερα

$150 USD σε 3 μέρες
(51 Αξιολογήσεις)
6.0
shahiddar

Hello Sir, I am shahid from kashmir. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well.I'm interested in your project. Please send me a message so that we c Περισσότερα

$30 USD σε 5 μέρες
(14 Αξιολογήσεις)
5.1
pilotarif

Bid Summary I have read your job posting & perfectly able to do the project according to your TOS, guidelines, demand in shortest possible of time with 100% accuracy & perfection. Project Requirements After careful re Περισσότερα

$155 USD σε 3 μέρες
(43 Αξιολογήσεις)
5.0
humayoonsheikh4u

Dear I am an excel professional having hands on expertise in data management I will do your project as per your requirements. best regards humayoon

$94 USD σε 3 μέρες
(12 Αξιολογήσεις)
4.2
Kinztech

Bid Summary Hello, I read instructions very carefully and immediately available to start working on this task. I am available to discuss this task on Skype, Email, phone. Project Requirements I fully understand the jo Περισσότερα

$167 USD σε 3 μέρες
(8 Αξιολογήσεις)
3.7
WebScraperGuru

Bid Summary Will complete the project , Please chat Project Requirements Professional Web Scraper Greetings sir, I am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Περισσότερα

$155 USD σε 3 μέρες
(7 Αξιολογήσεις)
2.4
ArkadiuszDoda

I'm an Excel/Access pro, have several years of full-time MS Access/MS Excel based jobs and a US education. My spreadsheets and databases are user-friendly and custom fit the expectations. I'd be happy to look throught Περισσότερα

$55 USD σε 2 μέρες
(1 Κριτική)
0.7
anacr0n

A proposal has not yet been provided

$200 USD σε 10 μέρες
(0 Αξιολογήσεις)
0.0
zaharansadiq

A proposal has not yet been provided

$200 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
Nikulvora

Hi sir I am new at freelancers. But I have good knowledge of excel. I have also knowledge of advance excel like data subtotling, vlookup ; hlookup; Etc.

$188 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
Ashahemamurthy

I will do this project please send me a message so we chat about project

$111 USD σε 2 μέρες
(0 Αξιολογήσεις)
0.0