offline
Last seen: Jul 21, 2014 6:36 AM EDT
Hire Me!
Rate: $5.00 USD/hour
Follow Invite to Project
 

CloudLogics

Website Development Services

Username: CloudLogics

  • Has not made a deposit.
  • Has verified their email address.
  • Has completed their profile.
  • Has not verified their secure phone number.
  • Verified
  • Payment is not verified.

Location: Lahore, Pakistan

Member since: April 2012

Reputation:

0.0/5

(0 reviews)

0
[see more]

No user has recommended this freelancer.

My skills:

My projects:

    CloudLogics has not completed any projects.
    CloudLogics has not completed any projects.
  • $40 USD In Progress

    Our project analyzes data regarding embassies for all countries since 1945.The goal of this project will be to compile the data longitudinally (over years) for each country. The end result will be an excel workbook with approximately 340 sheets.While the file system may seem cumbersome, the compile should be relatively straightforward. The file system for our project will consist of 67 access files (one for each year from 1945 to present), each containing approximately 340 tables (one for each country over these years). Each table records dyadic data on embassies.Input (please see .mdb files and "EmbCountryBirthDeath.xlsx" in attached "Inputs" folder for example)1.The input Access (.mdb) files are of the following format: a. Each .mdb file represents one year b. Each .mdb file has around 340 tables (each representing one country) c. Each table has the following format: i. First column - Lists of all ~340 countries ii. Second column - Diplomatic Mission Code iii. Third Column - Focus iv. Fourth Column - Location v. Fifth through Ninth Columns - Leave and Entrance Dates d.The output will only concern itself with the first two columns (Country and Embassy).2.There will also be a file which lists all countries and their birth and death years.Output (please see ‘Output.xlsx’ for example)1.The program should combine data for each year for a given country in a longitudinal spreadsheet (1945-2012). The name of the worksheet should be the country in question. The first column should have a list of all countries that the country in question has diplomatic relations with (i.e. any country that has a value in the "Embassy" column). a.The first row should have the years 1945 to 2012. b.Each subsequent row should copy the data for each country dyad for each year i. Remember: the name of the table in the input Access files becomes the name of the file of the output Excel file.2.Code changes across years should be highlighted a.e.g. Embassy code in 2005 is 1, but in 2006 is 2 i. Both cells should be highlighted3.The Access files will be continually updated. When the code is run, only data found in the ‘Input’ folder should be found in the output a.e.g. If “Afghanistan, Pre Colonial” has no embassies in any of the .mdb files in the ‘Input’ folder, it should not have a tab in the ‘Output.xlsx’ file.4.Years that are not found in the ‘Input’ folder should be grey in the ‘output’ file to indicate they are missing.5.Data points that have an embassy attributed to a country for years either before they are “born” or after they are “dead” should be highlighted for that year. a.This pertains to both countries in the dyad. b.The country list and Birth/Death years will be continually updated

    [more]
  • $25 USD Jan 7, 2014

    Take my Data Base and make it functional. It will eventually be put up on a Web Interface. But for today I just need it to function so I can add data. One hour of work for the expert at Access and Excel.

    [more]
  • $100 USD May 2, 2012

    We require an access database to manage our computer repair and support business.The data base will store client information, job information, staff information etc.The database will provide us with a number of different reports which will help us to run the business in a more efficient manner.A ticketing system will be required to manage jobs in progress including status updates.This database needs to be available online for access by staff. And secure acess is important.

    [more]
    CloudLogics does not have any open projects.
    CloudLogics does not have any work in progress.
[see more]

Portfolio

[see more]