• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Developing an Exchange Rate Calculation System

Extracts from this document...


Developing an Exchange Rate Calculation System I.T. Coursework A fter the system has been designed it is necessary to implement it. The most important stage is to input the design, which is down on paper into the computer, as the end user will use the produced system on the computer. By implementing the system it will be possible to see whether the design of the system is correct, and therefore if any editing to the design is needed. Due to the company changing its specifications for the system, I have had to add two more columns to each year to include the price of the imports and exports and the average price per kilo of molybdenum containment. Task One Create a title Page. Firstly I opened a new workbook and saved it as "Trade Statistics". Next I renamed sheet one as "trade statistics" also. Next I inserted the company name at the top of the screen using Caligula font merged and centred, across cells A1 to J1. Underneath this I typed UK Trade Statistics in cell C, merged and centred this from cell C2 to H2. To show the source of the data, I typed Source: Department of Trade and Industry Library, and merged and centred this over cells C3 to H3 using Arial bold font. ...read more.


Ecah subsection also had a total which was these figures added together, this was done again by using the SUM formula, e.g. =SUM(D61:D69). For the last column, column E, I included the price per kilo of molybdenum in US$, this was worked out by dividing the amount of molybdenum in each import (Mo MT) by the total price of the import Nett �, then multiplying this price by the annual average exchange rate, which was linked from a separate sheet (see Excahnge Rate sheet below). Therefore the formula =C9/D9*'[Exhange Rates.xls]Sheet1'!$B$4 as an example was entered in each cell, relating to the countries, in column E. This was changed accordingly depending on the cell: These cells are then formatted to use US$ in the format menu. Although problems arose because linking the sheets would include the full destinations, therefore if the system was moved to another computer the formulas would not work. If I had furthur time to produce the project, I would pursue this problem, but as time is short I must carry on. Below the prices per kilo from each country, an average price per kilo was calculated for each compound, an example of the formula would be: =AVERAGE(E66:E69) and this would be appropriately changed in each subsection. Exchange Rate Sheet: A new sheet had to be created including average annual exchange rates which were given to me by the end user. ...read more.


I then changed the Import Origins macro to the Imports by type macro. In the table, the compounds and sub total was changed to countries. I included the main markets that the company are interested in. This included: US, Canada, Chile, China, Europe and an Others total. All the formulas within the tables had to be changed. The total of imports from each country for each year were linked from the annual import sheet and added together for a total to produce the cells, e.g. I linked the totals of imports from the United States in 1984 from each compound and added them together to produce the overall total imports from the US, formula ='Annual Imports'!$D$9+'Annual Imports'!$D$17+'Annual Imports'!$D$27+'Annual Imports'!$D$41+'Annual Imports'!$D$51+'Annual Imports'!$D$61. For 1985 the formula would be ='Annual Imports'!$H$9+'Annual Imports'!$H$17+'Annual Imports'!$H$27+'Annual Imports'!$H$41+'Annual Imports'!$H$51+'Annual Imports'!$H$61 etc. But for Others, the formula included all other countries totals not included in the table, e.g. for 1985 formula ='Annual Imports'!$H$12+'Annual Imports'!$H$22+'Annual Imports'!$H$36+'Annual Imports'!$H$46+'Annual Imports'!$H$56+'Annual Imports'!$H$69. Europe was also done in the same way e.g. 1996 formula for Europe =SUM('Annual Imports '!$AZ$20:$AZ$21) +SUM ('Annual Imports'!$AZ$29:$AZ$33) +SUM('Annual Imports'!$AZ$43)+SUM('Annual Imports'!$AZ$52) +SUM('Annual Imports'!$AZ$62:$AZ$65). The total for each year also had to be corrected, adding the totals of all countries in the corresponding year. E.g. for 1990: =SUM(H4:H9). The chart title is then changed to UK Molybdenum Imports by Origin, Source: DTI Library. This ends the Import Origins sheet implementation. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Molecules & Cells section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Molecules & Cells essays

  1. The Origin of the Mitochondrion.

    Another scenario focuses on the possible parasitic nature of the initial interaction, and the selection that guided the host to develop mechanisms to convert any initial detrimental effects of the symbiosis to beneficial or at least neutral effects (Blackstone 1995).

  2. Experimental design

    Finally 5 ml were taken from the 3rd bottle and added to the 4th, so the v/v concentration in the 4th bottle became 12.5%. After the dilutions were prepared, four petri dishes were labeled with the different concentrations and the time of exposure.

  1. Spreadsheet cwk sandwich shop prices

    'Items', 'cost of a pack', 'portions', 'cost of portions' as shown Fig 1 * If so you'll have to make 2 new columns next to the 'Cost of portions' column * In the first column next to the 'Cost of portions' column enter 'Portions wanted' then under it enter 1

  2. Technical documentation - Design specification.

    of days in between the oldest and latest record is more than 7 Validation on Data Entry Rates sheet Cell D14 only accepts values from 5 to 50. If value doesn't fall in that range or isn't a number, the following error message emerges.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work