Gastos coche Alex.xlsx

	A	B	C	D	E	F	G	I	J	K	L	M	N	O	P
1
2		Precio TM3	52.000,00					Precio coche gasolina	32.000,00
3
4		Precio luz	0,040	€/Kw				Precio gasolina	1,40	€/L			1,40
5		Consumo medio	16,56	Kwh/100km				Consumo medio	7,2	L/100km			10,00
6
7
8		kilometraje	Coste	Cargas Ext.		extras	total	extras	equiv gasolina	total		extras	equiv gasolina	total
9		km	€	km	€
10	jun-21	2.568,00	43,16	320,00	0,00		50.157,17		258,85	32.858,85			359,52	32.959,52
11	jul-21	5.300,00	89,70	628,00	0,00		50.203,71		534,24	33.134,24			742,00	33.342,00
12	ago-21	7.949,00	134,42				50.248,43		801,26	33.401,26			1.112,86	33.712,86
13	sept-21	10.247,00	178,00				50.292,01		1.032,90	33.632,90			1.434,58	34.034,58
14	oct-21	14.119,00	362,52	1.391,21	48,08	120,00	50.644,60	100,00	1.523,20	34.223,20		100,00	2.076,66	34.776,66
15	nov-21	16.270,38	376,77				50.490,78		1.740,05	34.340,05			2.377,85	34.977,85
16	dic-21	18.948,84	394,51				50.508,52		2.010,04	34.610,04			2.752,84	35.352,84
17	ene-22	21.627,29	412,26				50.526,27		2.280,03	34.880,03			3.127,82	35.727,82
18	ene-22	24.305,75	430,00				50.544,01		2.550,02	35.150,02			3.502,81	36.102,81
19	feb-22	26.984,21	447,75				50.561,76		2.820,01	35.420,01			3.877,79	36.477,79
20	mar-22	29.662,67	465,49				50.579,50		3.090,00	35.690,00			4.252,77	36.852,77
21	abr-22	32.341,13	483,24				50.597,25		3.359,99	35.959,99			4.627,76	37.227,76
22	may-22	35.019,58	500,98				50.614,99		3.629,97	36.229,97			5.002,74	37.602,74
23	jun-22	37.698,04	518,73				50.632,73	250,00	4.149,96	36.999,96		250,00	5.627,73	38.477,73
24	jul-22	40.376,50	536,47				50.650,48		4.419,95	37.369,95			6.002,71	38.952,71
25	ago-22	43.054,96	554,22				50.668,22		4.689,94	37.639,94			6.377,69	39.327,69
26	sept-22	45.733,42	571,96				50.685,97		4.959,93	37.909,93			6.752,68	39.702,68
27	oct-22	48.411,87	589,71				50.703,71		5.229,92	38.179,92			7.127,66	40.077,66
28	oct-22	51.090,33	607,45				50.721,46		5.499,91	38.449,91			7.502,65	40.452,65
29	nov-22	53.768,79	625,20				50.739,20		5.769,89	38.719,89			7.877,63	40.827,63
30	dic-22	56.447,25	642,94				50.756,95		6.039,88	38.989,88			8.252,61	41.202,61
31	ene-23	59.125,71	660,68				50.774,69		6.309,87	39.259,87			8.627,60	41.577,60
32	feb-23	61.804,16	678,43				50.792,44		6.579,86	39.529,86			9.002,58	41.952,58
33	mar-23	64.482,62	696,17				50.810,18		6.849,85	39.799,85			9.377,57	42.327,57
34	abr-23	67.161,08	713,92				50.827,93		7.119,84	40.069,84			9.752,55	42.702,55
35	may-23	69.839,54	731,66				50.845,67		7.389,83	40.339,83			10.127,54	43.328,54
36	jun-23	72.518,00	749,41				50.863,42	251,00	7.910,81	41.111,81		251,00	10.753,52	43.954,52
37	jun-23	75.196,45	767,15				50.881,16		8.180,80	41.381,80			11.128,50	44.329,50
38	jul-23	77.874,91	784,90				50.898,91		8.450,79	41.651,79			11.503,49	44.704,49
39	ago-23	80.553,37	802,64				50.916,65		8.720,78	41.921,78			11.878,47	45.079,47
40	sept-23	83.231,83	820,39				50.934,40		8.990,77	42.191,77			12.253,46	45.454,46
41	oct-23	85.910,29	838,13				50.952,14		9.260,76	42.461,76			12.628,44	45.829,44
42	nov-23	88.588,75	855,88				50.969,89		9.530,75	42.731,75			13.003,42	46.204,42
43	dic-23	91.267,20	873,62				50.987,63		9.800,73	43.001,73			13.378,41	46.579,41
44	ene-24	93.945,66	891,37				51.005,38		10.070,72	43.271,72			13.753,39	46.954,39
45	ene-24	96.624,12	909,11				51.023,12		10.340,71	43.541,71			14.128,38	47.329,38
46	feb-24	99.302,58	926,86				51.040,86		10.610,70	43.811,70			14.503,36	47.704,36
47	mar-24	101.981,04	944,60				51.058,61		10.880,69	44.081,69			14.878,34	48.079,34
48	abr-24	104.659,49	962,35				51.076,35		11.150,68	44.351,68			15.253,33	48.706,33
49	may-24	107.337,95	980,09				51.094,10	252,00	11.672,67	45.125,67		252,00	15.880,31	49.333,31
50	jun-24	110.016,41	997,84				51.111,84		11.942,65	45.395,65			16.255,30	49.708,30
51	jul-24	112.694,87	1.015,58				51.129,59		12.212,64	45.665,64			16.630,28	50.083,28
52	ago-24	115.373,33	1.033,33				51.147,33		12.482,63	45.935,63			17.005,27	50.458,27
53	sept-24	118.051,78	1.051,07				51.165,08		12.752,62	46.205,62			17.380,25	50.833,25
54	sept-24	120.730,24	1.068,81				51.182,82		13.022,61	46.475,61			17.755,23	51.208,23
55	oct-24	123.408,70	1.086,56				51.200,57		13.292,60	46.745,60			18.130,22	51.583,22
56	nov-24	126.087,16	1.104,30				51.218,31		13.562,59	47.015,59			18.505,20	51.958,20
57	dic-24	128.765,62	1.122,05				51.236,06		13.832,57	47.285,57			18.880,19	52.333,19
58	ene-25	131.444,07	1.139,79				51.253,80		14.102,56	47.555,56			19.255,17	52.708,17
59	feb-25	134.122,53	1.157,54				51.271,55		14.372,55	47.825,55			19.630,15	53.083,15
60	mar-25	136.800,99	1.175,28				51.289,29		14.642,54	48.095,54			20.005,14	53.458,14
61	abr-25	139.479,45	1.193,03				51.307,04		14.912,53	48.365,53			20.380,12	54.086,12
62	may-25	142.157,91	1.210,77				51.324,78	253,00	15.435,52	49.141,52		253,00	21.008,11	54.714,11
63	may-25	144.836,36	1.228,52				51.342,53		15.705,51	49.411,51			21.383,09	55.089,09
64	jun-25	147.514,82	1.246,26				51.360,27		15.975,49	49.681,49	1.678,78		21.758,08	55.464,08	-4.103,80
65	jul-25	150.193,28	1.264,01				51.378,02		16.245,48	49.951,48			22.133,06	55.839,06
66	ago-25	152.871,74	1.281,75				51.395,76		16.515,47	50.221,47			22.508,04	56.214,04
67	sept-25	155.550,20	1.299,50				51.413,51		16.785,46	50.491,46			22.883,03	56.589,03
68	oct-25	158.228,65	1.317,24				51.431,25		17.055,45	50.761,45			23.258,01	56.964,01
69	nov-25	160.907,11	1.334,99				51.448,99		17.325,44	51.031,44			23.633,00	57.339,00
70	dic-25	163.585,57	1.352,73				51.466,74		17.595,43	51.301,43			24.007,98	57.713,98
71	ene-26	166.264,03	1.370,48				51.484,48		17.865,41	51.571,41			24.382,96	58.088,96
72	ene-26	168.942,49	1.388,22				51.502,23		18.135,40	51.841,40			24.757,95	58.463,95
73	feb-26	171.620,94	1.405,97				51.519,97		18.405,39	52.111,39			25.132,93	58.838,93
74	mar-26	174.299,40	1.423,71				51.537,72		18.675,38	52.381,38			25.507,92	59.467,92
75	abr-26	176.977,86	1.441,46				51.555,46	254,00	19.199,37	53.159,37		254,00	26.136,90	60.096,90
76	may-26	179.656,32	1.459,20				51.573,21		19.469,36	53.429,36			26.511,88	60.471,88
77	jun-26	182.334,78	1.476,94				51.590,95		19.739,35	53.699,35			26.886,87	60.846,87
78	jul-26	185.013,23	1.494,69				51.608,70		20.009,33	53.969,33			27.261,85	61.221,85
79	ago-26	187.691,69	1.512,43				51.626,44		20.279,32	54.239,32			27.636,84	61.596,84
80	sept-26	190.370,15	1.530,18				51.644,19		20.549,31	54.509,31			28.011,82	61.971,82
81	sept-26	193.048,61	1.547,92				51.661,93		20.819,30	54.779,30			28.386,81	62.346,81
82	oct-26	195.727,07	1.565,67				51.679,68		21.089,29	55.049,29			28.761,79	62.721,79
83	nov-26	198.405,52	1.583,41				51.697,42		21.359,28	55.319,28			29.136,77	63.096,77
84	dic-26	201.083,98	1.601,16				51.715,17		21.629,27	55.589,27			29.511,76	63.471,76
85	ene-27	203.762,44	1.618,90				51.732,91		21.899,25	55.859,25			29.886,74	63.846,74
86	feb-27	206.440,90	1.636,65				51.750,66		22.169,24	56.129,24			30.261,73	64.221,73
87	mar-27	209.119,36	1.654,39				51.768,40		22.439,23	56.399,23			30.636,71	64.851,71
88	abr-27	211.797,81	1.672,14				51.786,15	255,00	22.964,22	57.179,22		255,00	31.266,69	65.481,69
89	may-27	214.476,27	1.689,88				51.803,89		23.234,21	57.449,21			31.641,68	65.856,68
90	may-27	217.154,73	1.707,63				51.821,64		23.504,20	57.719,20			32.016,66	66.231,66
91	jun-27	219.833,19	1.725,37				51.839,38		23.774,19	57.989,19			32.391,65	66.606,65
92	jul-27	222.511,65	1.743,12				51.857,12		24.044,17	58.259,17			32.766,63	66.981,63
93	ago-27	225.190,10	1.760,86				51.874,87		24.314,16	58.529,16			33.141,61	67.356,61
94	sept-27	227.868,56	1.778,61				51.892,61		24.584,15	58.799,15			33.516,60	67.731,60
95	oct-27	230.547,02	1.796,35				51.910,36		24.854,14	59.069,14			33.891,58	68.106,58
96	nov-27	233.225,48	1.814,10				51.928,10		25.124,13	59.339,13			34.266,57	68.481,57
97	dic-27	235.903,94	1.831,84				51.945,85		25.394,12	59.609,12			34.641,55	68.856,55
98	dic-27	238.582,39	1.849,59				51.963,59		25.664,11	59.879,11			35.016,54	69.231,54
99	ene-28	241.260,85	1.867,33				51.981,34		25.934,09	60.149,09			35.391,52	69.606,52
100	feb-28	243.939,31	1.885,07				51.999,08		26.204,08	60.419,08			35.766,50	70.237,50