Ralph’s Runs Spreadsheet User Requirements
User Requirements
 Calculate total perimeter (Width x Length)
 Calculate total area of material (Perimeter x Height)
 Calculate total cost allowing for separate costs for plywood or boarding.
 Allow only data within allowable range to be input.
 User should not be able to change formulas or labels.
 All digits should display clearly.

( remember these are a joke but you need to transfer to your own project)

Legal requirements

Area per bunny
Nontoxic spray wood preserve
Mesh size not greater than 20 mm2
Mesh underneath to stop foxes

Health and safety
Hutches which weight over 10Kg should have wheels and pull handle for movement

Bunny protection – Ralph must ensure
All data held on bunny must be available to bunny when asked for
Data must not be given to other bunnies

Values given by Ralph

Maximum width 3m
Minimum width 0.5m
Maximum length 10m
Minimum length 2m
Maximum height 1.5m
Minimum height 0.5m
Cost of board £7.12 per m2
Cost of plywood £2.48 per m2

Validation of ranges finished hutch area should not be greater/or smaller than the requirements

Greater than Maximum width 3m X Maximum length 10m X Maximum height 1.5m

Less than Minimum width 0.5m X Minimum length 2m X Minimum height 0.5m


Format £ to 2 decimal places

Protection on all cells which the user does not have to change










Testing for Ralph’s Runs Spreadsheet
Data Range Key
Typical Data Test Extreme (but valid) Data Test Invalid Data Test
Testing Calculations
Num Description Expected Result Actual result Pass? Question
1 Enter following values:
Width 2
Length 6
Height 1.2
Material : Plywood Perimeter: 16
Area:: 19.2
Total materials Cost: 47.62
2 Enter following values:
Width .5
Length 2
Height .5
Material : Plywood
3 Enter following values:
Width 1
Length 6
Height 1
Material : Board
Testing Data Entry Checking (Validation)
Num Description Expected Result Actual result Pass? Question
4 Enter 0.5 and 3 into ‘Width’ box
Enter 2 and 10 into ‘Length’ box
Enter 0.5 & 1.5 into ‘Height’ box All accepted
5 Enter .4 and 3 into ‘Width’ box
Enter 1.9 and 10 into ‘Length’ box
Enter 0.4 & 1.5 into ‘Height’ box All Fail
6 Enter 2.1 and 3 into ‘Width’ box
Enter 10.1 and 10 into ‘Length’ box
Enter 1.6 & 1.5 into ‘Height’ box
Testing Cell Protection
Num Description Expected Result Actual result Pass?
7 Try to change each label cell Blocked
8
9
Testing Number Display
Num Description Expected Result Actual result Pass?
10 Enter following values:
Width 0.5
Length 2
Height 0.5
Material : Plywood £17.80 displayed correctly


11 Format currency to 2 decimal
12 Does the system deal with + £100

Evidence of Testing