týden	   pořadí	hodnota					
	1	186					
	2	191					
	3	196					
	4	206					
	5	215					
	6	225					
	7	235					
	8	248					
	9	255					
	10	266					
	11	278					
	12	295					
	13	313					
	14	331					
	15	350					
	16	368					
	17	390					
	18	406					
	19	423					
	20	438					
	21						
	22						
	23						
	24						
	25						
	26						
	27						
	28						
	29						
	30						
	31						
	32						
	33						
	34						
	35						
	36						
	37						
	38						
	39						
	40						
	41						
	42						
	43						
	44						
	45						
	46						
	47						
	48						
	49						
	50						
	51						
	52						
	53						
	54						
	55						
	56						
	57						
	58						
	59						
	60						
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
							
##### Sheet/List 2 #####
	   alfa =	0.7					
						    vyrovnání	 predikce
pozorování	k	 yk	          αk	      k.αk	 yk.αk	 yvk	hodnota
1	19	186	0.00114			191.000	
2	18	191	0.00163			191.000	
3	17	196	0.00233			191.000	
4	16	206	0.00332			201.500	
5	15	215	0.00475			210.950	
6	14	225	0.00678			220.785	
7	13	235	0.00969			230.736	
8	12	248	0.01384			242.821	
9	11	255	0.01977			251.346	
10	10	266	0.02825			261.604	
11	9	278	0.04035			273.081	
12	8	295	0.05765			288.424	
13	7	313	0.08235			305.627	
14	6	331	0.11765			323.388	
15	5	350	0.16807			342.016	
16	4	368	0.24010			360.205	
17	3	390	0.34300			381.061	
18	2	406	0.49000			398.518	
19	1	423	0.70000			415.656	
20	0	438	1.00000			431.297	
210	190	5815	3.33067	0.00000	0.00000	5712.02	0
	     Σk	        Σyk	            Σαk	     Σk.αk	     Σyk.αk	 Σyvk	
							
parametr 	       a =						
							
							
							
							
							
##### Sheet/List 3 #####
	   alfa =	0.7		          αk								
								    vyrovnání	 predikce			
pozorování	k	 y20-k	          αk	 y20-k.αk	 k.y20-k.αk	      k.αk	      k2.αk	 yvk	hodnota	    St[1]	    St[2]	
1	19	186	0.00114	0.2120	4.0284	0.0217	0.4115	191.000	438.359	431.106	423.853	0
2	18	191	0.00163	0.3110	5.5985	0.0293	0.5276	191.000	102.210	263.032	423.853	1
3	17	196	0.00233	0.4560	7.7512	0.0395	0.6723	191.000	8.366	216.110	423.853	2
4	16	206	0.00332	0.6846	10.9536	0.0532	0.8508	167.587	144.587	209.033	273.479	3
5	15	215	0.00475	1.0207	15.3109	0.0712	1.0682	184.510	195.129	213.210	231.291	4
6	14	225	0.00678	1.5260	21.3640	0.0950	1.3293	201.433	218.515	221.463	224.411	5
7	13	235	0.00969	2.2769	29.5996	0.1260	1.6374	218.357	232.897	230.939	228.981	6
8	12	248	0.01384	3.4326	41.1917	0.1661	1.9931	235.280	247.052	242.882	238.711	7
9	11	255	0.01977	5.0422	55.4640	0.2175	2.3926	252.203	255.160	251.364	247.569	8
10	10	266	0.02825	7.5138	75.1384	0.2825	2.8248	269.126	265.822	261.609	257.397	9
11	9	278	0.04035	11.2183	100.9647	0.3632	3.2686	286.050	277.789	273.083	268.377	10
12	8	295	0.05765	17.0062	136.0493	0.4612	3.6895	302.973	294.439	288.425	282.411	11
13	7	313	0.08235	25.7769	180.4383	0.5765	4.0354	319.896	312.593	305.627	298.662	12
14	6	331	0.11765	38.9418	233.6509	0.7059	4.2354	336.819	330.806	323.388	315.970	13
15	5	350	0.16807	58.8245	294.1225	0.8404	4.2018	353.743	349.830	342.016	334.203	14
16	4	368	0.24010	88.3568	353.4272	0.9604	3.8416	370.666	368.006	360.205	352.404	15
17	3	390	0.34300	133.7700	401.3100	1.0290	3.0870	387.589	389.659	381.061	372.464	16
18	2	406	0.49000	198.9400	397.8800	0.9800	1.9600	404.512	406.335	398.518	390.702	17
19	1	423	0.70000	296.1000	296.1000	0.7000	0.7000	421.436	423.142	415.656	408.170	18
20	0	438	1.00000	438.0000	0.0000	0.0000	0.0000	438.359	438.235	431.297	424.359	19
210	190	5815	3.33067	1329.41036	2660.34320	7.71838	42.72677		454.424			1
			            Σαk	     Σαkyn-k	     Σk.αkyn-k	     Σk.αk	      Σk2.αk		426.093			2
									433.820			3
									435.537			4
									436.292			5
		  čitatel	   jmenovatel									
parametr 	       a =	36267.87533	82.73557	438.3589								
parametr 	       b =	1400.15537	82.73557	16.9233