Datoteke za izenjavo - excel letne datoteke za letopise, dnevne padavine in temperature, statistike po mesecih
in letu (min. in max. pad., tem., mesecna in letna povprecja, za padavine tudi vsote)!


KAKO PRESTEZEM NAPPAKO
=IFERROR(SMALL(C339:C369;COUNTIF(C339:C369;"<"&0.1)+1);0)


KONTROLA V sheet1
H4
=IF(C4-D4<0; "MINT > MAXT --> NAPAKA!!!!";"")

L3
=IF(AND(F4>D4;F4<C4);"";"NAPAKA. KER NE VELJA TMIN<TPOV<TMAX")
 



Na sheet1 so dnevni podatki ob B4 do  F4  in navzdol (v tretji vrsti je glava: Date MAX_T MIN_T Padavine pov_dnev_T)
Date	MAX_T	MIN_T	Padavine	pov_dnev_T
1.01.2017	1.4	-2	-1	-0.8
2.01.2017	-1.8	-5.9	-1	-3.8
.
.
.
do enega leta ....

-------------------------------

Na listu
Processed_meteo_data
pa dato, dnevne padavi, dnevna temperaturna povprečja in statistike ... (podatki se začnejo v vrsti 4 in koloni b = datum, C= pad, D = pov. tem.)

	Daily average					Precipitation (mm)					Air_Temperature (°C)					
	Date	Precipitation (mm)	Air_Temperature (°C)		Month	P_MIN_DATE	P_MIN_VALUE	P_MAX_DATE	P_MAX_VALUE	P_SUM_VALUE	AT_MIN_DATE	AT_MIN_VALUE	AT_MAX_DATE	AT_MAX_VALUE	AT_AVG_VALUE	
	1.01.2016	0	-0.8		1	5.01.2016	1	12.01.2016	42	110.9	19.01.2016	-14	27.01.2016	14	-3.0	
	2.01.2016	0	-3.8		2	12.02.2016	0.5	10.02.2016	45	317	4.02.2016	-8.7	22.02.2016	10	-2.2	
	3.01.2016	17	-7		3	14.03.2016	1.9	7.03.2016	38	144.4	16.03.2016	-9	18.03.2016	4	-2.3	
	4.01.2016	4.5	-5.4		4	25.04.2016	0.2	28.04.2016	47.1	88.7	27.04.2016	-6.5	7.04.2016	13.5	2.7	
	5.01.2016	1	-3.9		5	25.05.2016	0.5	13.05.2016	37.3	161.8	16.05.2016	-1.6	22.05.2016	18.3	5.4	
	6.01.2016	2	-3.7		6	6.06.2016	1.5	15.06.2016	35	197.6	1.06.2016	4	25.06.2016	21	10.1	
	7.01.2016	1.3	-4.8		7	16.07.2016	0.6	14.07.2016	37	140	15.07.2016	4.1	24.07.2016	23.8	13.2	
	8.01.2016	0	-1.4		8	12.08.2016	0.8	11.08.2016	56	184.6	12.08.2016	2.5	4.08.2016	23	12.1	
	9.01.2016	5.5	2		9	2.09.2016	1.9	17.09.2016	26	118.9	21.09.2016	2	1.09.2016	18.5	10.0	
	10.01.2016	23	0.5		10	14.10.2016	0.3	26.10.2016	37	166.2	12.10.2016	-4	16.10.2016	14	3.2	
	11.01.2016	4	1.5		11	9.11.2016	0.2	6.11.2016	88	296.4	29.11.2016	-12	1.11.2016	14.2	0.1	
	12.01.2016	42	-3.2		12	1.12.2016	0	1.12.2016	0	0	16.12.2016	-8	11.12.2016	12.8	1.1	
	13.01.2016	0	-3.9													
	14.01.2016	0	-5.2		Precipitation (mm)				Air_Temperature (°C)							
	15.01.2016	3	-7.8		P_YEARLY	P_DATE	P_VALUE		AT_YEARLY	AT_DATE	AT_VALUE					
	16.01.2016	2.6	-9.8		MIN	1.12.2016	0		MIN	19.01.2016	-14					
	17.01.2016	0	-10.9		MAX	6.11.2016	88		MAX	24.07.2016	23.8					
	18.01.2016	0	-11.5		SUM	2016	1926.5		AVG	2016	4.2					
	19.01.2016	0	-10.1													
	20.01.2016	0	-6.5													
	21.01.2016	0	-8.1		Legend											
	22.01.2016	0	-6.9													
	23.01.2016	0	-2.9		Daily											
	24.01.2016	0	-0.7		Monthly											
	25.01.2016	0	4.4		Yearly											
	26.01.2016	0	7.6													
	27.01.2016	0	5.9													
.
.
.
.




----------------------------



Ukazi enaki za vsa leta.


od C4 do c369 (če so padavine na listu sheet1 -1, potem 0 drugače višina padavin na listu Processed_meteo_data, KOLONA C)
=IF(Sheet1!E4=-1;0;Sheet1!E4)


od d4 do d369  (prepis povprečnih temperatur iz sheet1 na  Processed_meteo_data, kolona D) 
=Sheet1!F4

-----

G19
=INDEX(G4:G15;MATCH(MIN(H4:H15);H4:H15;0))

H19
=MIN(H4:H15)

G20
=INDEX(I4:I15;MATCH(MAX(J4:J15);J4:J15;0))

H20
=MAX(J4:J15)

G21
=YEAR(B4)

H21
=SUM(K4:K15)

----

K19
=INDEX(L4:L15;MATCH(MIN(M4:M15);M4:M15;0))

L19
=MIN(M4:M15)

K20
=INDEX(N4:N15;MATCH(MAX(O4:O15);O4:O15;0))

L20
=MAX(O4:O15)

K21
=YEAR(B4)

L21
=AVERAGE(P4:P15)



-----------------sledijo ukazi za navadno in prestopno leto -----------------------



NAVADNA NEPRESTOPNO LETO 2017, 2018




---- KOLONA G na Processed_meteo_data, datumi MINIMALNIH DNEVNIH PADAVIN po mesecih iz kolne H

=INDEX(B4:B34;MATCH(H4;C4:C34;0))
=INDEX(B35:B62;MATCH(H5;C35:C62;0))
=INDEX(B63:B93;MATCH(H6;C63:C93;0))
=INDEX(B94:B123;MATCH(H7;C94:C123;0))
=INDEX(B124:B154;MATCH(H8;C124:C154;0))
=INDEX(B155:B184;MATCH(H9;C155:C184;0))
=INDEX(B185:B215;MATCH(H10;C185:C215;0))
=INDEX(B216:B246;MATCH(H11;C216:C246;0))
=INDEX(B247:B276;MATCH(H12;C247:C276;0))
=INDEX(B277:B307;MATCH(H13;C277:C307;0))
=INDEX(B308:B337;MATCH(H14;C308:C337;0))
=INDEX(B338:B368;MATCH(H15;C338:C368;0))



---- KOLONA H na Processed_meteo_data, iskanje MINIMALNIH PADAVIN, ki so >= 0.1 mm po mesecih (zapletena procedura)
-- zato filtriram vse pod "<"&0.1     !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

=IFERROR(SMALL(C4:C34;COUNTIF(C4:C34;"<"&0.1)+1);0)
=IFERROR(SMALL(C35:C62;COUNTIF(C35:C62;"<"&0.1)+1);0)
=IFERROR(SMALL(C63:C93;COUNTIF(C63:C93;"<"&0.1)+1);0)
=IFERROR(SMALL(C94:C123;COUNTIF(C94:C123;"<"&0.1)+1);0)
=IFERROR(SMALL(C124:C154;COUNTIF(C124:C154;"<"&0.1)+1);0)
=IFERROR(SMALL(C155:C184;COUNTIF(C155:C184;"<"&0.1)+1);0)
=IFERROR(SMALL(C185:C215;COUNTIF(C185:C215;"<"&0.1)+1);0)
=IFERROR(SMALL(C216:C246;COUNTIF(C216:C246;"<"&0.1)+1);0)
=IFERROR(SMALL(C247:C276;COUNTIF(C247:C276;"<"&0.1)+1);0)
=IFERROR(SMALL(C277:C307;COUNTIF(C277:C307;"<"&0.1)+1);0)
=IFERROR(SMALL(C308:C337;COUNTIF(C308:C337;"<"&0.1)+1);0)
=IFERROR(SMALL(C338:C368;COUNTIF(C338:C368;"<"&0.1)+1);0)



---- KOLONA I na Processed_meteo_data, datumi MAXIMALNI DNEVNIH PADAVIN po mesecih

=INDEX(B4:B34;MATCH(MAX(C4:c34);c4:c34;0))
=INDEX(B35:b62;MATCH(MAX(c35:C62);c35:C62;0))
=INDEX(B63:b93;MATCH(MAX(c63:C93);c63:C93;0))
=INDEX(B94:b123;MATCH(MAX(c94:C123);c94:C123;0))
=INDEX(B124:b154;MATCH(MAX(c124:C154);c124:C154;0))
=INDEX(B155:b184;MATCH(MAX(c155:C184);c155:C184;0))
=INDEX(B185:b215;MATCH(MAX(c185:C215);c185:C215;0))
=INDEX(B216:b246;MATCH(MAX(c216:C246);c216:C246;0))
=INDEX(b247:b276;MATCH(MAX(c247:C276);c247:C276;0))
=INDEX(b277:b307;MATCH(MAX(c277:C307);c277:C307;0))
=INDEX(b308:b337;MATCH(MAX(c308:C337);c308:C337;0))
=INDEX(b338:b368;MATCH(MAX(c338:C368);c338:C368;0))


---- KOLONA J na Processed_meteo_data, maks mes. dnevne padavine

=MAX(C4:C34)
=MAX(C35:C62)
=MAX(C63:C93)
=MAX(C94:C123)
=MAX(C124:C154)
=MAX(C155:C184)
=MAX(C185:C215)
=MAX(C216:C246)
=MAX(C247:C276)
=MAX(C277:C307)
=MAX(C308:C337)
=MAX(C338:C368)




--- KOLONA K na Processed_meteo_data, VSOTA MESEČNIH PADAVIN

=SUM(C4:C34)
=SUM(C35:C62)
=SUM(C63:C93)
=SUM(C94:C123)
=SUM(C124:C154)
=SUM(C155:C184)
=SUM(C185:C215)
=SUM(C216:C246)
=SUM(C247:C276)
=SUM(C277:C307)
=SUM(C308:C337)
=SUM(C338:C368)



---- KOLONA L na Processed_meteo_data, datumi min mes. minimalne temperature iz lista Sheet1
----- !D z  !B  ---- :D  z :B

=INDEX(Sheet1!B4:B34;MATCH(MIN(Sheet1!D4:D34);Sheet1!D4:D34;0))
=INDEX(Sheet1!B35:b62;MATCH(MIN(Sheet1!D35:D62);Sheet1!D35:D62;0))
=INDEX(Sheet1!B63:b93;MATCH(MIN(Sheet1!D63:D93);Sheet1!D63:D93;0))
=INDEX(Sheet1!B94:b123;MATCH(MIN(Sheet1!D94:D123);Sheet1!D94:D123;0))
=INDEX(Sheet1!B124:b154;MATCH(MIN(Sheet1!D124:D154);Sheet1!D124:D154;0))
=INDEX(Sheet1!B155:b184;MATCH(MIN(Sheet1!D155:D184);Sheet1!D155:D184;0))
=INDEX(Sheet1!B185:b215;MATCH(MIN(Sheet1!D185:D215);Sheet1!D185:D215;0))
=INDEX(Sheet1!B216:b246;MATCH(MIN(Sheet1!D216:D246);Sheet1!D216:D246;0))
=INDEX(Sheet1!b247:b276;MATCH(MIN(Sheet1!D247:D276);Sheet1!D247:D276;0))
=INDEX(Sheet1!b277:b307;MATCH(MIN(Sheet1!D277:D307);Sheet1!D277:D307;0))
=INDEX(Sheet1!b308:b337;MATCH(MIN(Sheet1!D308:D337);Sheet1!D308:D337;0))
=INDEX(Sheet1!b338:b368;MATCH(MIN(Sheet1!D338:D368);Sheet1!D338:D368;0))




---- KOLONA M na Processed_meteo_data, minimalne dnevne temperature po mesecih iz Sheet1

=MIN(Sheet1!D4:D34)
=MIN(Sheet1!D35:D62)
=MIN(Sheet1!D63:D93)
=MIN(Sheet1!D94:D123)
=MIN(Sheet1!D124:D154)
=MIN(Sheet1!D155:D184)
=MIN(Sheet1!D185:D215)
=MIN(Sheet1!D216:D246)
=MIN(Sheet1!D247:D276)
=MIN(Sheet1!D277:D307)
=MIN(Sheet1!D308:D337)
=MIN(Sheet1!D338:D368)




---- KOLONA N na Processed_meteo_data, datumi maksimalne mes. maks. temperature iz lista Sheet1

=INDEX(Sheet1!B4:B34;MATCH(MAX(Sheet1!C4:c34);Sheet1!c4:c34;0))
=INDEX(Sheet1!B35:b62;MATCH(MAX(Sheet1!c35:C62);Sheet1!c35:C62;0))
=INDEX(Sheet1!B63:b93;MATCH(MAX(Sheet1!c63:C93);Sheet1!c63:C93;0))
=INDEX(Sheet1!B94:b123;MATCH(MAX(Sheet1!c94:C123);Sheet1!c94:C123;0))
=INDEX(Sheet1!B124:b154;MATCH(MAX(Sheet1!c124:C154);Sheet1!c124:C154;0))
=INDEX(Sheet1!B155:b184;MATCH(MAX(Sheet1!c155:C184);Sheet1!c155:C184;0))
=INDEX(Sheet1!B185:b215;MATCH(MAX(Sheet1!c185:C215);Sheet1!c185:C215;0))
=INDEX(Sheet1!B216:b246;MATCH(MAX(Sheet1!c216:C246);Sheet1!c216:C246;0))
=INDEX(Sheet1!b247:b276;MATCH(MAX(Sheet1!c247:C276);Sheet1!c247:C276;0))
=INDEX(Sheet1!b277:b307;MATCH(MAX(Sheet1!c277:C307);Sheet1!c277:C307;0))
=INDEX(Sheet1!b308:b337;MATCH(MAX(Sheet1!c308:C337);Sheet1!c308:C337;0))
=INDEX(Sheet1!b338:b368;MATCH(MAX(Sheet1!c338:C368);Sheet1!c338:C368;0))



---- KOLONA O na Processed_meteo_data,MAKSIMALNE mesečne temperature iz lista Sheet1

=MAX(Sheet1!c4:C34)
=MAX(Sheet1!c35:C62)
=MAX(Sheet1!c63:C93)
=MAX(Sheet1!c94:C123)
=MAX(Sheet1!c124:C154)
=MAX(Sheet1!c155:C184)
=MAX(Sheet1!c185:C215)
=MAX(Sheet1!c216:C246)
=MAX(Sheet1!c247:C276)
=MAX(Sheet1!c277:C307)
=MAX(Sheet1!c308:C337)
=MAX(Sheet1!c338:C368)



---- KOLONA P na Processed_meteo_data, povrečna mesečna temperatura iz kolne D


=ROUND(P4; 1)

posebno lepljenje 

vrednosti in šetvilske oblike

=average(D4:D34)
=average(D35:D62)
=average(D63:D93)
=average(D94:D123)
=average(D124:D154)
=average(D155:D184)
=average(D185:D215)
=average(D216:D246)
=average(D247:D276)
=average(D277:D307)
=average(D308:D337)
=average(D338:D368)







===================================================================================================================




PRESTOPNO LETO 2016 2020 2024 ... 2012




---- KOLONA G na Processed_meteo_data, datumi MINIMALNIH DNEVNIH PADAVIN po mesecih iz kolne H

=INDEX(B4:B34;MATCH(H4;C4:C34;0))
=INDEX(B35:B63;MATCH(H5;C35:C63;0))
=INDEX(B64:B94;MATCH(H6;C64:C94;0))
=INDEX(B95:B124;MATCH(H7;C95:C124;0))
=INDEX(B125:B155;MATCH(H8;C125:C155;0))
=INDEX(B156:B185;MATCH(H9;C156:C185;0))
=INDEX(B186:B216;MATCH(H10;C186:C216;0))
=INDEX(B217:B247;MATCH(H11;C217:C247;0))
=INDEX(B248:B277;MATCH(H12;C248:C277;0))
=INDEX(B278:B308;MATCH(H13;C278:C308;0))
=INDEX(B309:B338;MATCH(H14;C309:C338;0))
=INDEX(B339:B369;MATCH(H15;C339:C369;0))



---- KOLONA H na Processed_meteo_data, iskanje MINIMALNIH PADAVIN, ki so >= 0.1 mm po mesecih (zapletena procedura)
-- zato filtriram vse pod "<"&0.1     !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

=IFERROR(SMALL(C4:C34;COUNTIF(C4:C34;"<"&0.1)+1);0)
=IFERROR(SMALL(C35:C63;COUNTIF(C35:C63;"<"&0.1)+1);0)
=IFERROR(SMALL(C64:C94;COUNTIF(C64:C94;"<"&0.1)+1);0)
=IFERROR(SMALL(C95:C124;COUNTIF(C95:C124;"<"&0.1)+1);0)
=IFERROR(SMALL(C125:C155;COUNTIF(C125:C155;"<"&0.1)+1);0)
=IFERROR(SMALL(C156:C185;COUNTIF(C156:C185;"<"&0.1)+1);0)
=IFERROR(SMALL(C186:C216;COUNTIF(C186:C216;"<"&0.1)+1);0)
=IFERROR(SMALL(C217:C247;COUNTIF(C217:C247;"<"&0.1)+1);0)
=IFERROR(SMALL(C248:C277;COUNTIF(C248:C277;"<"&0.1)+1);0)
=IFERROR(SMALL(C278:C308;COUNTIF(C278:C308;"<"&0.1)+1);0)
=IFERROR(SMALL(C309:C338;COUNTIF(C309:C338;"<"&0.1)+1);0)
=IFERROR(SMALL(C339:C369;COUNTIF(C339:C369;"<"&0.1)+1);0)



---- KOLONA I na Processed_meteo_data, datumi MAXIMALNI DNEVNIH PADAVIN po mesecih

=INDEX(B4:B34;MATCH(MAX(C4:c34);c4:c34;0))
=INDEX(B35:b63;MATCH(MAX(c35:C63);c35:C63;0))
=INDEX(B64:b94;MATCH(MAX(c64:C94);c64:C94;0))
=INDEX(B95:b124;MATCH(MAX(c95:C124);c95:C124;0))
=INDEX(B125:b155;MATCH(MAX(c125:C155);c125:C155;0))
=INDEX(B156:b185;MATCH(MAX(c156:C185);c156:C185;0))
=INDEX(B186:b216;MATCH(MAX(c186:C216);c186:C216;0))
=INDEX(B217:b247;MATCH(MAX(c217:C247);c217:C247;0))
=INDEX(b248:b277;MATCH(MAX(c248:C277);c248:C277;0))
=INDEX(b278:b308;MATCH(MAX(c278:C308);c278:C308;0))
=INDEX(b309:b338;MATCH(MAX(c309:C338);c309:C338;0))
=INDEX(b339:b369;MATCH(MAX(c339:C369);c339:C369;0))


---- KOLONA J na Processed_meteo_data, maks mes. dnevne padavine

=MAX(C4:C34)
=MAX(C35:C63)
=MAX(C64:C94)
=MAX(C95:C124)
=MAX(C125:C155)
=MAX(C156:C185)
=MAX(C186:C216)
=MAX(C217:C247)
=MAX(C248:C277)
=MAX(C278:C308)
=MAX(C309:C338)
=MAX(C339:C369)


--- KOLONA K na Processed_meteo_data, VSOTA MESEČNIH PADAVIN

=SUM(C4:C34)
=SUM(C35:C63)
=SUM(C64:C94)
=SUM(C95:C124)
=SUM(C125:C155)
=SUM(C156:C185)
=SUM(C186:C216)
=SUM(C217:C247)
=SUM(C248:C277)
=SUM(C278:C308)
=SUM(C309:C338)
=SUM(C339:C369)



---- KOLONA L na Processed_meteo_data, datumi min mes. minimalne temperature iz lista Sheet1
----- !D z  !B  ---- :D  z :B

=INDEX(Sheet1!B4:B34;MATCH(MIN(Sheet1!D4:D34);Sheet1!D4:D34;0))
=INDEX(Sheet1!B35:b63;MATCH(MIN(Sheet1!D35:D63);Sheet1!D35:D63;0))
=INDEX(Sheet1!B64:b94;MATCH(MIN(Sheet1!D64:D94);Sheet1!D64:D94;0))
=INDEX(Sheet1!B95:b124;MATCH(MIN(Sheet1!D95:D124);Sheet1!D95:D124;0))
=INDEX(Sheet1!B125:b155;MATCH(MIN(Sheet1!D125:D155);Sheet1!D125:D155;0))
=INDEX(Sheet1!B156:b185;MATCH(MIN(Sheet1!D156:D185);Sheet1!D156:D185;0))
=INDEX(Sheet1!B186:b216;MATCH(MIN(Sheet1!D186:D216);Sheet1!D186:D216;0))
=INDEX(Sheet1!B217:b247;MATCH(MIN(Sheet1!D217:D247);Sheet1!D217:D247;0))
=INDEX(Sheet1!b248:b277;MATCH(MIN(Sheet1!D248:D277);Sheet1!D248:D277;0))
=INDEX(Sheet1!b278:b308;MATCH(MIN(Sheet1!D278:D308);Sheet1!D278:D308;0))
=INDEX(Sheet1!b309:b338;MATCH(MIN(Sheet1!D309:D338);Sheet1!D309:D338;0))
=INDEX(Sheet1!b339:b369;MATCH(MIN(Sheet1!D339:D369);Sheet1!D339:D369;0))




---- KOLONA M na Processed_meteo_data, minimalne dnevne temperature po mesecih iz Sheet1

=MIN(Sheet1!D4:D34)
=MIN(Sheet1!D35:D63)
=MIN(Sheet1!D64:D94)
=MIN(Sheet1!D95:D124)
=MIN(Sheet1!D125:D155)
=MIN(Sheet1!D156:D185)
=MIN(Sheet1!D186:D216)
=MIN(Sheet1!D217:D247)
=MIN(Sheet1!D248:D277)
=MIN(Sheet1!D278:D308)
=MIN(Sheet1!D309:D338)
=MIN(Sheet1!D339:D369)




---- KOLONA N na Processed_meteo_data, datumi maksimalne mes. maks. temperature iz lista Sheet1

=INDEX(Sheet1!B4:B34;MATCH(MAX(Sheet1!C4:c34);Sheet1!c4:c34;0))
=INDEX(Sheet1!B35:b63;MATCH(MAX(Sheet1!c35:C63);Sheet1!c35:C63;0))
=INDEX(Sheet1!B64:b94;MATCH(MAX(Sheet1!c64:C94);Sheet1!c64:C94;0))
=INDEX(Sheet1!B95:b124;MATCH(MAX(Sheet1!c95:C124);Sheet1!c95:C124;0))
=INDEX(Sheet1!B125:b155;MATCH(MAX(Sheet1!c125:C155);Sheet1!c125:C155;0))
=INDEX(Sheet1!B156:b185;MATCH(MAX(Sheet1!c156:C185);Sheet1!c156:C185;0))
=INDEX(Sheet1!B186:b216;MATCH(MAX(Sheet1!c186:C216);Sheet1!c186:C216;0))
=INDEX(Sheet1!B217:b247;MATCH(MAX(Sheet1!c217:C247);Sheet1!c217:C247;0))
=INDEX(Sheet1!b248:b277;MATCH(MAX(Sheet1!c248:C277);Sheet1!c248:C277;0))
=INDEX(Sheet1!b278:b308;MATCH(MAX(Sheet1!c278:C308);Sheet1!c278:C308;0))
=INDEX(Sheet1!b309:b338;MATCH(MAX(Sheet1!c309:C338);Sheet1!c309:C338;0))
=INDEX(Sheet1!b339:b369;MATCH(MAX(Sheet1!c339:C369);Sheet1!c339:C369;0))



---- KOLONA O na Processed_meteo_data,MAKSIMALNE mesečne temperature iz lista Sheet1

=MAX(Sheet1!c4:C34)
=MAX(Sheet1!c35:C63)
=MAX(Sheet1!c64:C94)
=MAX(Sheet1!c95:C124)
=MAX(Sheet1!c125:C155)
=MAX(Sheet1!c156:C185)
=MAX(Sheet1!c186:C216)
=MAX(Sheet1!c217:C247)
=MAX(Sheet1!c248:C277)
=MAX(Sheet1!c278:C308)
=MAX(Sheet1!c309:C338)
=MAX(Sheet1!c339:C369)



---- KOLONA P na Processed_meteo_data, povrečna mesečna temperatura iz kolne D


=ROUND(P4; 1)

posebno lepljenje 

vrednosti in šetvilske oblike

=average(D4:D34)
=average(D35:D63)
=average(D64:D94)
=average(D95:D124)
=average(D125:D155)
=average(D156:D185)
=average(D186:D216)
=average(D217:D247)
=average(D248:D277)
=average(D278:D308)
=average(D309:D338)
=average(D339:D369)