Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
small test
#1
Not Solved
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!!!


Attached Files
.doc   small test.doc (Size: 47.5 KB / Downloads: 159)
Reply
#2
Not Solved
can any one solve this and reply please!!!
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  VB Script to separate upper & small Letters from a string and store in excel pradeep537 1 2,192 08-05-2016, 12:26 AM
Last Post: Ankur
  How to check a small text into a string? Adam Nguyen 3 6,952 05-15-2012, 10:24 PM
Last Post: joncfrazier

Forum Jump:


Users browsing this thread: 1 Guest(s)