To make data entry easier I set up this spreadsheet so that all the values can be entered here.								
The values on each subject's sheet are automatically updated (up to 6 trading periods.  For more than 6 periods you will have to update worksheets)								
To use this INPUT worksheet to create a parameter file used for profit calculations in HandDA save this sheet as a text file.  Then import into HandDA.								
"To print all worksheets at once go to FILE -- PRINT as usual. Select ""entire workbook"" (lower left corner)"								
								
Sort data by buyer number then by unit number. For the HandDA program parameter file you can add additional columns for more periods.								
Buyer Number	Unit Number	Buyer_Unit	Period 1	Period 2	Period 3	Period 4	Period 5	Period 6
NP	06	<< Number of periods.  Calculated automatically.						
NT	10	<< Number of Buyers.  Calculated automatically.						
UN	03	<< Maximum number of units that any one person can buy.  Calculated automatically.						
01	01	1_1	9.85 	8.60 	12.50 	11.25 	9.85 	8.60 
01	02	1_2	5.10 	6.35 	7.75 	9.00 	5.10 	6.35 
01	03	1_3	2.60 	3.85 	5.25 	6.50 	2.60 	3.85 
02	01	2_1	9.60 	8.35 	12.25 	11.00 	9.60 	8.35 
02	02	2_2	5.35 	6.60 	8.00 	9.25 	5.35 	6.60 
02	03	2_3	2.85 	4.10 	5.50 	6.75 	2.85 	4.10 
03	01	3_1	9.35 	8.10 	12.00 	10.75 	9.35 	8.10 
03	02	3_2	5.60 	6.85 	8.25 	9.50 	5.60 	6.85 
03	03	3_3	3.10 	4.35 	5.75 	7.00 	3.10 	4.35 
04	01	4_1	9.10 	7.85 	11.75 	10.50 	9.10 	7.85 
04	02	4_2	5.85 	7.10 	8.50 	9.75 	5.85 	7.10 
04	03	4_3	3.35 	4.60 	6.00 	7.25 	3.35 	4.60 
05	01	5_1	8.85 	7.60 	11.50 	10.25 	8.85 	7.60 
05	02	5_2	6.10 	7.35 	8.75 	10.00 	6.10 	7.35 
05	03	5_3	3.60 	4.85 	6.25 	7.50 	3.60 	4.85 
06	01	6_1	8.60 	9.85 	11.25 	12.50 	8.60 	9.85 
06	02	6_2	6.35 	5.10 	9.00 	7.75 	6.35 	5.10 
06	03	6_3	3.85 	2.60 	6.50 	5.25 	3.85 	2.60 
07	01	7_1	8.35 	9.60 	11.00 	12.25 	8.35 	9.60 
07	02	7_2	6.60 	5.35 	9.25 	8.00 	6.60 	5.35 
07	03	7_3	4.10 	2.85 	6.75 	5.50 	4.10 	2.85 
08	01	8_1	8.10 	9.35 	10.75 	12.00 	8.10 	9.35 
08	02	8_2	6.85 	5.60 	9.50 	8.25 	6.85 	5.60 
08	03	8_3	4.35 	3.10 	7.00 	5.75 	4.35 	3.10 
09	01	9_1	7.85 	9.10 	10.50 	11.75 	7.85 	9.10 
09	02	9_2	7.10 	5.85 	9.75 	8.50 	7.10 	5.85 
09	03	9_3	4.60 	3.35 	7.25 	6.00 	4.60 	3.35 
10	01	10_1	7.60 	8.85 	10.25 	11.50 	7.60 	8.85 
10	02	10_2	7.35 	6.10 	10.00 	8.75 	7.35 	6.10 
10	03	10_3	4.85 	3.60 	7.50 	6.25 	4.85 	3.60