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 OralDA save this sheet as a text file.  Then import into OralDA.								
"To print all worksheets at once go to FILE -- PRINT as usual. Select ""entire workbook"" (lower left corner)"								
								
Sort data by seller number then by unit number. For the OralDA program parameter file you can add additional columns for more periods.								
Seller Number	Unit Number	Seller_Unit	Period 1	Period 2	Period 3	Period 4	Period 5	Period 6
NP	06	<< Number of periods.  Calculated automatically do not delete formula						
NT	10	<< Number of Sellers  Calculated automatically do not delete formula						
UN	03	<< Maximum number of units that any one person can sell.  Calculated automatically do not delete formula						
01	01	1_1	2.10 	3.35 	4.75 	6.00 	2.10 	3.35 
01	02	1_2	6.85 	5.60 	9.50 	8.25 	6.85 	5.60 
01	03	1_3	9.85 	8.10 	12.50 	10.75 	9.85 	8.10 
02	01	2_1	2.35 	3.60 	5.00 	6.25 	2.35 	3.60 
02	02	2_2	6.60 	5.35 	9.25 	8.00 	6.60 	5.35 
02	03	2_3	9.10 	7.85 	11.75 	10.50 	9.10 	7.85 
03	01	3_1	2.60 	3.85 	5.25 	6.50 	2.60 	3.85 
03	02	3_2	6.35 	5.10 	9.00 	7.75 	6.35 	5.10 
03	03	3_3	8.85 	7.60 	11.50 	10.25 	8.85 	7.60 
04	01	4_1	2.85 	4.10 	5.50 	6.75 	2.85 	4.10 
04	02	4_2	6.10 	4.85 	8.75 	7.50 	6.10 	4.85 
04	03	4_3	8.60 	7.35 	11.25 	10.00 	8.60 	7.35 
05	01	5_1	3.10 	4.35 	5.75 	7.00 	3.10 	4.35 
05	02	5_2	5.85 	4.60 	8.50 	7.25 	5.85 	4.60 
05	03	5_3	8.35 	7.10 	11.00 	9.75 	8.35 	7.10 
06	01	6_1	3.35 	2.10 	6.00 	4.75 	3.35 	2.10 
06	02	6_2	5.60 	6.85 	8.25 	9.50 	5.60 	6.85 
06	03	6_3	8.10 	9.85 	10.75 	12.50 	8.10 	9.85 
07	01	7_1	3.60 	2.35 	6.25 	5.00 	3.60 	2.35 
07	02	7_2	5.35 	6.60 	8.00 	9.25 	5.35 	6.60 
07	03	7_3	7.85 	9.10 	10.50 	11.75 	7.85 	9.10 
08	01	8_1	3.85 	2.60 	6.50 	5.25 	3.85 	2.60 
08	02	8_2	5.10 	6.35 	7.75 	9.00 	5.10 	6.35 
08	03	8_3	7.60 	8.85 	10.25 	11.50 	7.60 	8.85 
09	01	9_1	4.10 	2.85 	6.75 	5.50 	4.10 	2.85 
09	02	9_2	4.85 	6.10 	7.50 	8.75 	4.85 	6.10 
09	03	9_3	7.35 	8.60 	10.00 	11.25 	7.35 	8.60 
10	01	10_1	4.35 	3.10 	7.00 	5.75 	4.35 	3.10 
10	02	10_2	4.60 	5.85 	7.25 	8.50 	4.60 	5.85 
10	03	10_3	7.10 	8.35 	9.75 	11.00 	7.10 	8.35