Peruttu

Excel File Manipulation

Take the attached file with many worksheets and turn it into one sheet with data on each pair of countries by year

## Deliverables

The database is attached. I want you to do the following:

Create a list of data that measures the total number of treaties signed/ratified between two countries for each year. For example, take the countries of Algeria and Argentina in 1964 for worksheet Chapter I-5a in the attached data. They would not receive a score on this worksheet for the years up to 1966. From 1966 to the end of the time horizon, they would be scored as a 2. This is because they both have signed the treaty by 1966 and Argentina had not signed the treaty previously even though Algeria had signed it in 1964-5. The score between Algeria and Albania would be 2 from 1964 ot the end of the time horizon.

Add this score up with the score for Algeria and Argentina for all of the other treaties in the worksheet for every year available. Do this for all possible pairs of countries for this data for all possible years.

This should create a dataset that is quite large. If it is in list form (what I require), then it should stretch out probably to 500,000,000 rows. I need the file to be saved as a csv format.

If this is not clear, please let me know.

Also, I would like you to send me the excel commands that you have used to create this dataset so that I can follow your steps to check for accuracy.

Taidot: kaikki käy, tekniikka, tietojärjestelmäarkkitehtuuri, Ohjelmistojen testaus

Näytä lisää: what to take if you want to be engineering, create excel worksheet, number manipulation, please worksheet attached, Excel Time sheet, 2011 excel add, excel check check, excel add form, add form excel, excel check, send form data excel, csv data manipulation, excel list example, format list excel, create check file, excel file data manipulation, send receive file, check data excel file, large dataset, turn excel, check file format, csv manipulation, create excel csv file, excel sheet add, 500 list excel

About the Employer:
( 55 reviews ) United States

Projektin tunnus: #3295288

14 freelanceria on tarjonnut keskimäärin 39 $ tähän työhön

gribfritz

See private message.

42.5 $ USD 5 päivässä
(496 arvostelua)
7.6
vnb400sl

See private message.

42.5 $ USD 5 päivässä
(141 arvostelua)
6.0
girlteam2009

See private message.

34 $ USD 5 päivässä
(149 arvostelua)
5.7
webspiderinc

See private message.

68 $ USD 5 päivässä
(47 arvostelua)
5.3
dpune

See private message.

42.5 $ USD 5 päivässä
(44 arvostelua)
4.9
ieinfotech

See private message.

77.35 $ USD 5 päivässä
(14 arvostelua)
3.4
sadaffarooqi

See private message.

34 $ USD 5 päivässä
(14 arvostelua)
2.8
DanielCarrero

See private message.

41.65 $ USD 5 päivässä
(5 arvostelua)
2.5
waterworldvw

See private message.

14.45 $ USD 5 päivässä
(7 arvostelua)
2.3
younisdataexpert

See private message.

11.05 $ USD 5 päivässä
(0 arvostelua)
0.0
trywith

See private message.

25.5 $ USD 5 päivässä
(0 arvostelua)
0.0
preethu2020

See private message.

42.5 $ USD 5 päivässä
(0 arvostelua)
0.0
todsnewlife

See private message.

34 $ USD 5 päivässä
(0 arvostelua)
0.0
ruchidvw

See private message.

42.5 $ USD 5 päivässä
(0 arvostelua)
0.0