Expand the analytical capabilities of the Embassy Database

This project will expand the analytical capabilities on the Embassy Database.

1. Standardize the Embassy Codes so that the years after 1983 are in the same format as those before 1983. Find the conversions in the attached files.

2. Details option. When we are checking the data from the 'COUNTRIES REPORT' we need to figure out the specific relationship between countries in a specific year. For Example: we see that 'Jersey' has a diplomatic mission in 1992, but we know that this should not be. We need the ability to check this relationship so we can determine what we should correct.

3. Create 'Location' Filter

Option to select specific countries

Option to exclude all relationships where the Importing Country is equal to 'Location'

Option to include all relationships where the Importing Country is equal to the 'Location'


4. Expanded filtering and display capabilities:

In filter, create button to automatically select all codes that are "Inside Country", "Outside Country" or "Unreciprocated".

Create a longitudinal display and edit option

Add filter for GENERATE EXCEL

5. Expanded editing capabilities.

Global find and replace codes for certain countries, codes, or years.

6. Clean up

Filter Form (possible matrix format)

Countries Report (hide columns instead of just data). Export to excel.

7. Add COW codes

From Input file (see attached list). This list will change, so we should be able to update it.

8. Final outputs

List of all dyadic relationships, sortable

Kemahiran: Excel, Microsoft Access

Lihat lagi: analytical capabilities excel, cow and cow, form update excel, excel filter list, check data excel files, microsoft project export microsoft access, access clean data, excel list files add, file filter excel, export project access, data input create report, excel find select, excel data filtering, Analytical report, export excel form, project export access, export microsoft project, check excel files, excel create certain format, excel change data format, export data project access, filtering excel, excel list update, create codes access, project update form excel

Tentang Majikan:
( 55 ulasan ) United States

ID Projek: #4053715

Dianugerahkan kepada:


Hi, I can do the job I am looking forward to work with you Best Regards Diego

$260 USD dalam 10 hari
(15 Ulasan)

2 pekerja bebas membida secara purata $280 untuk pekerjaan ini


i love this job

$300 USD dalam 3 hari
(0 Ulasan)