Jena and Megan's Spain totals

	A	B	D	E	G	H	I	J	K	M	N	O	P	Q	S	T	U	V	W
1	Date	Time spent walking	Km walked	Total Km walked	Refugio	Mom spent	Meg spent	Meg owes	Mom owes	Cost of food		Other costs		Cost of transportation	Total spent on day	Total spent on trip

2	8/27/2017													$36	$36	$36		Jena
3														$5	$5	$5		Megan
4	8/28/2017	5.5 hours			A&O	37.15€		18.57€	18.57€	34€				35€	106.15€	142.15€
5		5.5 hours			A&O										0	$5
6	8/29/2017	1 hour			Hostel 20	59.60€		29.80€	29.80€	32€				81.20€	172.80€	314.95€
7		1 hour			Hostel 20										0	$5
8	8/30/2017	.5 hours			Munisipal Albergue	26.00€		13.00€	13.00€	32€				64.4	122.40€	437.35€
9		2 hours			Munisipal Albergue							46			46	$51
10	8/31/2017	3 hours	7.8	7.8	Gite-Antton	70€		45.00€	45.00€						70€	507€
11		3 hours	7.8	7.8	Gite-Antton					19.50€					19.50€	70.50€
12	9/1	6 hours	17.3	25.1	Cellegiale refuge	12€		12.00€	12.00€						12€	519€
13		6 hours	17.3	25.1	Cellegiale refuge		12€			40.50€					53€	123€
14	9/2/2017	8.5 hours	21.9	47	Munisipal	16€		8.00€	8.00€	63€					79€	598€
15		8.5 hours	21.9	47	Munisipal					6€					6€	129€
16	9/3	7 hours	16.1	63.1	Refuge Freres Maristes	20€		10.00€	10.00€						20€	618€
17		7 hours	16.1	63.1	Refuge Freres Maristes					14.90€					14.90€	143.90€
18	9/4	3 hours	4.8	67.9	Pamplona plaza hotel	75€		37.50€	37.50€	5					80€	698€
19		3 hours	4.8	67.9	Pamplona plaza hotel					18.00€		14.5			32.50€	176.40€
20	9/5	7.5 hours	21.6	89.5	Usda albergue					27.18€		3.95			31.13€	729.48€
21		7.5 hours	21.6	89.5	Usda albergue	16€		8.00€	8.00€	10.80€		3			30€	206€
22	9/6	9.5 hours	24.1	113.6	El Cantero					3.10€		2			5.10€	734.58€
23		9.5 hours	24.1	113.6	El Contero		12€	6.00€	6.00€	9.60€					22€	228€
24	9/7	0	0	113.6	hostel entre suenos	15				13				4.75	32.75	767.33€
25		5.5 hours	21.5	135.1	Casa de la Abuela		10€	10.00€	15.00€	20.00€					30€	258€
26	9/8	5 hours	13	126.6	el Cantaro	12				13		45			70	837.33€
27		7 hours	27.8	162.9	Albergue de peregrinos		7€	7.00€	12.00€	22€					29€	287€
28	9/9	5.5 hours	18	144.6	duques	35				9					44	881.33€
29		8.5 hours	28.9	191.8	Albergue-el peregrino		10€	10.00€	35.00€	22.88€					33€	320€
30	9/10			144.6	refugio parroouial	6€				37				7	50€	931€
31		5.5 hours	21.3	213.1	monasterio		8€	6.00€	8.00€	18.7		7€			34€	353€
32	9/11			144.6	munisipal	5€				9				6	20€	951€
33		6:15 hours	22.4	235.5	refugio parroouial		3€	3.00€	5.00€	12.5					16€	369€
34	9/12			144.6	munisipal	5€									5€	956€
35		6.5 hours	24.2	259.7	Santuario san juan		10€	10.00€	5.00€	18					28€	397€
36	9/13			144.6	Cotel hotel	60€				15		42			117€	1,073€
37		7.5 hours	26.1	285.8	Cotel Hotel			30.00€	30.00€	42		5			47	444€
38	9/14	4.5 hours	13	157.6	Hostel La Fuente	45€				5					50€	1,123€
39		4.5 hours	13	298.8	Hostel Le Fuente			22.50€	22.50€	9.8					9.8	454€
40	9/15	5 hours	18.5	176.1	Albergue Maralla Leonesa	30				15.4		9.5		78.5	133.4	1,257€
41		5 hours	18.5	317.3	Albergue Maralla Leonesa			15.00€	15.00€	7.3					7.3	461€
42	9/16	0 hours	0	176.1	Casa Peltre					8.4				55	63.4	1,320€
43		0 hours	0	317.3	Casa Peltra		20	10.00€	10.00€	16					36	497€
44	9/17	5.5 hours	17.1	193.2						8.8		27.5			36.3	1,356€
45		5.5 hours	17.1	334.4			20	10.00€	10.00€	62.4		0.5			82.9	580€
46	9/18	6.5 hours	18.1	211.3						29					29	1,385€
47		6.5 hours	18.1	352.5			40	20.00€	20.00€	17.5					57.5	637€
48	9/19	7 hours	20.7	232						25.6		18		23	66.6	1,452€
49		7 hours	20.7	373.2			20	10.00€	10.00€	15					35	672€
50	9/20	3 hours	10.2	242.2	Hotel Rua Villar					50.2				1377.48	1427.68	2,880€
51		3 hours	10.2	383.4	Hotel Rua Villiar		100	50.00€	50.00€	60		32		150	342	1,014€		Megan	Mom
52	9/21	0 hours	0	242.2	Vertices	75				46.5				26.5	148	3,028€		1,007€	-1,007€
53		0 hours	0	383.4	Vertices			37.50€	37.50€								4,042€
54	9/22			242.2													2,021€
55				383.4
56	9/23			242.2
57
58						619.75	272	438.87	472.87	944.56	0	255.95	0	$1,950
59
60
61
62
63
64
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