Käynnissä

Excel Manipulation

he 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.

## Deliverables

he 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, 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, excel file data manipulation, check data excel file, large dataset, csv manipulation, create excel csv file, 500 list excel, excel follow form, database available excel, example list excel, excel manipulation, follow excel, send form excel

About the Employer:
( 55 reviews ) United States

Projektin tunnus: #3301300

Myönnetty käyttäjälle:

gribfritz

See private message.

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

10 freelanceria on tarjonnut keskimäärin 88 $ tähän työhön

shikhamehta

See private message.

127.5 $ USD 17 päivässä
(296 arvostelua)
6.9
matfizvw

See private message.

127.5 $ USD 17 päivässä
(55 arvostelua)
5.9
Lotusdeveloper

See private message.

68 $ USD 17 päivässä
(87 arvostelua)
5.2
tannic

See private message.

68 $ USD 17 päivässä
(12 arvostelua)
4.2
FavazFarook

See private message.

42.5 $ USD 17 päivässä
(9 arvostelua)
4.0
akerasi

See private message.

63.75 $ USD 17 päivässä
(4 arvostelua)
2.6
ghikmawan

See private message.

51 $ USD 17 päivässä
(2 arvostelua)
1.7
work4meathome

See private message.

200 $ USD 17 päivässä
(0 arvostelua)
0.0
hallpox

See private message.

80.75 $ USD 17 päivässä
(0 arvostelua)
0.0
makeown5

See private message.

76.5 $ USD 17 päivässä
(0 arvostelua)
0.0
shukla06vw

See private message.

51 $ USD 17 päivässä
(0 arvostelua)
0.0