ThirstyEarthv0_Main

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	P	Q	R	S	T	U	V	W	X	Y	Z	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK
1
2						Thirsty								Initialize Game					0	Set to 1 to initialize responses, roster and previous period (be patient!)
3						Earth								Previous Period					8	Increase when each round is complete (see col BK)
4						v.0								Sample Player Info					0	Set to 1 to display random player consumption each round
5														Initialize Responses					0	Set to 1 to initialize responses only (roster is kept)																								https://tinyurl.com/mrwftp39
6			Manuscript											Players per village					10	This is the maximum number of player per village (defaults to 10)
7
8																																																											Round Complete?
9			Number of players											10											1											1											1											1	Check Manually
10	Village	Player		A											B											C											D											E
11				A	A	A	A	A	A	A	A	A	A	A	B	B	B	B	B	B	B	B	B	B	B	C	C	C	C	C	C	C	C	C	C	C	D	D	D	D	D	D	D	D	D	D	D	E	E	E	E	E	E	E	E	E	E	E
12	Total	Ave	1	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot
13			cost first unit	1	1	1	1	1	1	1	1	1	1	1.0	1	1	1	1	1	1	1	1	1	1	1.0	1	1	1	1	1	1	1	1	1	1	1.0	1	1	1	1	1	1	1	1	1	1	1.0	1	1	1	1	1	1	1	1	1	1	1.0
14	29		A	4	3	1	4	1	6	1.5	2	3	3	28.5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
15			avg unit cost											14.8											1.0											1.0											1.0											1.0
16	1005	71.75892857	Bnet	141	106	35	141	35	212	53	71	106	106	1005	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
17														10											10											10											10											1
18			2	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot
19			cost first unit											29.5											1.0											1.0											1.0											1.0
20	24		A	3	3	1	3	1	3	3.5	3	2	1.5	24	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
21			avg unit cost											41.0											1.0											1.0											1.0											1.0
22	216	15.42857143	Bnet	27	27	9	27	9	27	32	27	18	14	216	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
23														10											10											10											10											10
24			3	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot
25			cost first unit											30.7											1.0											1.0											1.0											1.0
26	23		A	1	3	1	5	1	0	3.5	2	2	4	22.5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
27			avg unit cost											41.5											1.0											1.0											1.0											1.0
28	192	13.74107143	Bnet	9	26	9	43	9	0	30	17	17	34	192	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
29														10											10											10											10											10
30			4	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot
31			cost first unit											29.4											1.0											1.0											1.0											1.0
32	31		A	5	3	1	6	1	2	3.75	3	1.5	5	31.25	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
33			avg unit cost											44.6											1.0											1.0											1.0											1.0
34	170	12.13169643	Bnet	27	16	5	33	5	11	20	16	8	27	170	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
35														10											10											10											10											10
36			5	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot
37			cost first unit											37.9											1.0											1.0											1.0											1.0
38	27		A	2	3	1	4	1	3	0.5	3	2	7	26.5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
39			avg unit cost											50.7											1.0											1.0											1.0											1.0
40	-18	-1.302285714	Bnet	-1	-2	-1	-3	-1	-2	0	-2	-1	-5	-18	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
41														10											10											10											10											10
42			6	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot
43			cost first unit											34.9											1.0											1.0											1.0											1.0
44	22		A	4	3	1	2	1	1	0.5	2	2	5	21.5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
45			avg unit cost											45.1											1.0											1.0											1.0											1.0
46	105	7.467257143	Bnet	19	15	5	10	5	5	2	10	10	24	105	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
47														10											10											10											10											10
48			7	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot
49			cost first unit											29.3											1.0											1.0											1.0											1.0
50	28		A	4	3	1	4	1	0	4	3	2	6	28	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
51			avg unit cost											42.8											1.0											1.0											1.0											1.0
52	202	14.44496	Bnet	29	22	7	29	7	0	29	22	14	43	202	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
53														10											10											10											10											10
54			8	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot
55			cost first unit											34.7											1.0											1.0											1.0											1.0
56	14		A	2	3	1	0	1	0	0.25	2	2	3	14.25	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
57			avg unit cost											41.3											1.0											1.0											1.0											1.0
58	124	8.875201286	Bnet	17	26	9	0	9	0	2	17	17	26	124	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
59
60
61															Midstream											Downstream											Downstream											Downstream
62			total year 1-8	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot	1	2	3	4	5	6	7	8	9	10	tot
63	197		Total water use	25	24	8	28	8	15	17.5	20	16.5	34.5	196.5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
64	1996	142.5454006	Total Profit	268	235	78	279	78	252	168	178	189	270	1996	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100