The 20 dollar traveller

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC
1	DATUM	CAT							average/day		17,00		432,3529412	1,176470588	0	0	44,41176471	100,2941176	18,52941176	12,58823529	0	0	18,23529412	18,41176471	0	67,94117647	7,470588235	721,4117647
2									total	total excl hotel			H	TS	TIC	BF	L	D	S	E	TOUR	Y	ALC	LNDRY	BIKE	MISC	DIFF	3,61
3	5-12-2018			in	cash out	saldo BHT	CB/hotelbill/correction	out		0	daily average	daily average exl hotel	hotel	transport short distances	transport intercity	breakfast	lunch	diner+alchol during diner	snacks/drinks/smoothies/fruit	espresso/thee	entrance/mats park	massage/yoga/meditation	alcohol/going out	laundry	bike rental	/misc	short	TOTAL	check - if negative, the category is not filled in (well)
4	5-12-2018					1720		0	0	0																		0	0
5	5-12-2018	MISC	towel		30	1690		30	30	30																30			0
6	5-12-2018					1690		0	30	30																			0
7	5-12-2018	H	hotel		2450	-760		2450	2480	30			2450																0
8	5-12-2018	MISC	deposit key		100	-860	-100	0	2480	30																0			0
9	5-12-2018	TS	bus from airport		20	-880		20	2500	50				20															0
10	5-12-2018		ATM cash withdrawel	15000		14120		0	2500	50	2500,00	50																	0
11	6-12-2018	L			30	14090		30	2530	80							30												0
12	6-12-2018	D			160	13930		160	2690	240								160											0
13	6-12-2018	MISC	mask+cookies		45	13885		45	2735	285																45			0
14	6-12-2018	LNDRY			80	13805		80	2815	365														80					0
15	6-12-2018	DIFF			-20	13825		-20	2795	345																	-20		0
16	6-12-18	ALC	winebar		310	13515		310	3105	655	1552,50	327,5											310						0
17	7-12-2018	L			70	13445		70	3175	725							70												0
18	7-12-2018	S	Kombucha		40	13405		40	3215	765									40										0
19	7-12-2018	D			80	13325		80	3295	845	1098,33	281,6666667						80											0
20	8-12-2018	L			130	13195		130	3425	975							130												0
21	8-12-2018	E			50	13145		50	3475	1025										50									0
22	8-12-2018	D			50	13095		50	3525	1075								50											0
23	8-12-2018	MISC	spons		11	13084		11	3536	1086	884,00	271,5														11			0
24	9-12-2018	L			70	13014		70	3606	1156							70												0
25	9-12-2018	D			120	12894		120	3726	1276								120											0
26	9-12-2018	E			65	12829		65	3791	1341										65									0
27	9-12-2018	MISC	Trash hero bottle		220	12609		220	4011	1561	802,20	312,2														220			0
28	10-12-2018	MISC	prints		15	12594		15	4026	1576																15			0
29	10-12-2018	L	offered		0	12594		0	4026	1576							0												0
30	10-12-2018	D			65	12529		65	4091	1641								65											0
31	10-12-2018	S	smoothie		35	12494		35	4126	1676	687,67	279,3333333							35										0
32	11-12-2018	L			30	12464		30	4156	1706							30												0
33	11-12-2018	D			170	12294		170	4326	1876								170											0
34	11-12-2018	MISC	cover for wallet		60	12234		60	4386	1936																60			0
35	11-12-2018	LNDRY			105	12129		105	4491	2041														105					0
36	11-12-2018	DIFF			20	12109		20	4511	2061	644,43	294,4285714															20		0
37	12-12-18	L			55	12054		55	4566	2116							55												0
38	12-12-18	D			130	11924		130	4696	2246	587,00	280,75						130											0
39	13-12-2018	H			2450	9474		2450	7146	2246			2450																0
40	13-12-2018	L	30		30	9444		30	7176	2276							30												0
41	13-12-2018	D	80		80	9364		80	7256	2356								80											0
42	13-12-2018	MISC	lampje fiets		20	9344		20	7276	2376																20			0
43	13-12-2018	S	koekjes		10	9334		10	7286	2386									10										0
44	13-12-2018	MISC	wrist tape		55	9279		55	7341	2441	815,67	271,2222222														55			0
45	14-12-2018	L			70	9209		70	7411	2511							70												0
46	14-12-2018	D			100	9109		100	7511	2611								100											0
47	14-12-2018	S			40	9069		40	7551	2651									40										0
48	14-12-2018	MISC	kapper		150	8919		150	7701	2801	770,10	280,1														150			0
49	15-12-2018	S	water en chips		30	8889		30	7731	2831									30										0
50	15-12-2018	D			140	8749		140	7871	2971								140											0
51	15-12-2018	E			55	8694		55	7926	3026										55									0
52	15-12-2018	E			1920	6774	-1920	0	7926	3026										0									0
53	15-12-2018	DIFF			40	6734		40	7966	3066	724,18	278,7272727															40		0
54	16-12-2018	E			44	6690		44	8010	3110										44									0
55	16-12-2018	D			110	6580		110	8120	3220	676,67	268,3333333						110											0
56	17-12-2018	L			95	6485		95	8215	3315							95												0
57	17-12-2018	D			65	6420		65	8280	3380								65											0
58	17-12-2018	S	smoothie		45	6375		45	8325	3425									45										0
59	17-12-2018	S			10	6365		10	8335	3435	641,15	264,2307692							10										0
60	18-12-2018	MISC	mala		100	6265		100	8435	3535																100			0
61	18-12-2018	MISC	tape for wrist + mask		120	6145		120	8555	3655																120			0
62	18-12-2018	L			35	6110		35	8590	3690							35												0
63	18-12-2018	D			140	5970		140	8730	3830								140											0
64	18-12-2018	S	coconut		25	5945		25	8755	3855	625,36	275,3571429							25										0
65	19-12-2018	LNDRY			128	5817		128	8883	3983														128					0
66	19-12-2018	MISC	printshop		260	5557		260	9143	4243																260			0
67	19-12-2018	L			35	5522		35	9178	4278							35												0
68	19-12-2018	D			75	5447		75	9253	4353								75											0
69	19-12-2018	MISC	toilet		4	5443		4	9257	4357																4			0
70	19-12-2018	DIFF			27	5416		27	9284	4384	618,93	292,2666667															27		0
71	20-12-18	L			70	5346		70	9354	4454							70												0
72	20-12-18	S			40	5306		40	9394	4494									40										0
73	20-12-18	D			120	5186		120	9514	4614								120											0
74	20-12-18	H			2450	2736		2450	11964	4614	747,75	288,375	2450																0
75	21-12-18	L			35	2701		35	11999	4649							35												0
76	21-12-18	D			100	2601		100	12099	4749								100											0
77	21-12-18	MISC			65	2536		65	12164	4814																65			0
78	21-12-18	S			40	2496		40	12204	4854									40										0
79	21-12-18	DIFF			60	2436		60	12264	4914	721,41	289,0588235															60		0
80						2436		0	12264	4914																			0
81					936	1500		936	13200	5850																			-936
82					1500	0		1500	14700	7350																			-1500
83						0		0	14700	7350																			0
84						0		0	14700	7350																			0
85						0		0	14700	7350																			0
86						0		0	14700	7350																			0
87						0		0	14700	7350																			0
88						0		0	14700	7350																			0
89						0		0	14700	7350																			0
90						0		0	14700	7350																			0
91						0		0	14700	7350																			0
92						0		0	14700	7350																			0
93						0		0	14700	7350																			0
94						0		0	14700	7350																			0
95						0		0	14700	7350																			0
96						0		0	14700	7350																			0
97						0		0	14700	7350																			0
98						0		0	14700	7350																			0
99						0		0	14700	7350																			0
100						0		0	14700	7350																			0