The Board Price Survey Tool computes the min, max, mean, median dollars per square feet for a sample of boards based their lengths, widths and prices, where the board widths are in inches, lengths in feet and prices are in dollars.
INSTRUCTIONS: Enter rows of three numbers separated by commas:
Tile Survey Stats: The tool returns the following for the set of values entered.
If RC is set to SORT, the Price per Area is computed and appended to each board option. This list is then sorted by Price per Area from least to most expensive.
Data Entered for decking boards price survey of L,W,P where L is length in feet, W is width in inches and P is price per board. The first row is 3,6,2,57 for 3 foot long, six inches wide for $2.57 per board, and so forth.
3,6,2.57
4,6,3.46
6,6,5.64
8,6,6.84
10,6,8.7
12,6,10.53
14,6,13.16
16,6,14.37
18,6,22.69
20,6,25.18
22,6,44.4
24,6,48.41