Fig.1 is a pricing table representing a number of products and their varieties. The prices of these products are in pounds sterling. Fig.2 represents the same products and varieties with their prices converted to Euros. The value in each cell of Fig 2 is calculated from the value in the corresponding cell in Fig 1.e.g.
Value (Product1, Variety1) in “Fig 2” = (Value (Product1, Variety1) in “Fig 1”) * conversion rate.
In the example the conversion rate is 1.5
The shaded cells should not contain values.
The value in each cell in the bottom row is equivalent to the sum of the values in the corresponding column.
Fig 1- Prices in Sterling
Variety 1 Variety 2 Variety 3 Variety 4
Product 1 10 12 14 45
Product 2 20 15 24
Product 3 22 60
Product 4 28
Total 80 87 38 45
Fig 2- Prices in Euro
Variety 1 Variety 2 Variety 3 Variety 4
Product 1 15 18 21 67.5
Product 2 30 22.5 36
Product 3 33 90
Product 4 42
Total 120 130.5 57 67.5
Problem:
Part 1:
A Table object is available that represents a pricing table. Describe what properties of the Table object are needed to solve Part2.
Part 2:
Write a test to check the correctness of the values in the Euro table.
Consideration should be given to the variety of possible errors conditions and how these are tested. We are not concerned solely with whether or not the test works, but also with how tidy, structured and robust it is.
The test can be written in a suitable programming/scripting language of the candidate’s choice. A high level language (C#, C++, Java or Delphi) is strongly preferred; commented pseudo-code is also acceptable.
can any one solve this and reply please!!!
Value (Product1, Variety1) in “Fig 2” = (Value (Product1, Variety1) in “Fig 1”) * conversion rate.
In the example the conversion rate is 1.5
The shaded cells should not contain values.
The value in each cell in the bottom row is equivalent to the sum of the values in the corresponding column.
Fig 1- Prices in Sterling
Variety 1 Variety 2 Variety 3 Variety 4
Product 1 10 12 14 45
Product 2 20 15 24
Product 3 22 60
Product 4 28
Total 80 87 38 45
Fig 2- Prices in Euro
Variety 1 Variety 2 Variety 3 Variety 4
Product 1 15 18 21 67.5
Product 2 30 22.5 36
Product 3 33 90
Product 4 42
Total 120 130.5 57 67.5
Problem:
Part 1:
A Table object is available that represents a pricing table. Describe what properties of the Table object are needed to solve Part2.
Part 2:
Write a test to check the correctness of the values in the Euro table.
Consideration should be given to the variety of possible errors conditions and how these are tested. We are not concerned solely with whether or not the test works, but also with how tidy, structured and robust it is.
The test can be written in a suitable programming/scripting language of the candidate’s choice. A high level language (C#, C++, Java or Delphi) is strongly preferred; commented pseudo-code is also acceptable.
can any one solve this and reply please!!!