{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["GrafC932","HoltC932","GrafC943","HoltC943","GrafC913","HoltC913"],"not_rendered":{"charts":6,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"GrafC932","index":0,"reason":"not_a_worksheet"},{"sheet":"GrafC943","index":2,"reason":"not_a_worksheet"},{"sheet":"GrafC913","index":4,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"HoltC932","index":1,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["počáteční hodnoty","   alfa =",0.75,"   gama =",0.25]
["      počáteční hodnoty  jsou určeny jako L0=yt , T0=y2-y1"]
[null,null,null,null,null,"L0","T0",{"$f":"(H8+H12+H16+H20+H24+H28+H32+H36+H40+H44+H48+H52+H56)/13","v":0},"S01"]
[null,null,null,null,null,{"$f":"C8","v":6.55},{"$f":"C9-C8","v":0.45000000000000018},{"$f":"(H9+H13+H17+H21+H25+H29+H33+H37+H41+H45+H49+H53+H57)/13","v":0},"S02"]
[null,null,null,null,null,null,null,{"$f":"(H10+H14+H18+H22+H26+H30+H34+H38+H42+H46+H50+H54+H58)/12","v":0},"S03"]
[null,null,null,null,null,null,null,{"$f":"(H11+H15+H19+H23+H27+H31+H35+H39+H43+H47+H51+H55+H59)/13","v":0},"S04"]
[" DATE","NOBS","REVENUE","rezidua","HOLT","Lt","Tt",null,"abs.rezidua","rezidua2"]
["2000Q2",1,6.55,{"$f":"C8-E8","v":0},{"$f":"F4","v":6.55},{"$f":"$C$1*(C8)+(1-$C$1)*(F4+G4)","v":6.6624999999999996},{"$f":"$E$1*(F8-F4)+(1-$E$1)*G4","v":0.36562500000000009},null,{"$f":"ABS(D8)","v":0},{"$f":"D8*D8","v":0}]
["2000Q3",{"$f":"B8+1","v":2},7,-7.0312499999998224E-3,{"$f":"F9","v":7.0070312499999998},{"$f":"$C$1*(C9)+(1-$C$1)*(F8+G8)","v":7.0070312499999998},{"$f":"$E$1*(F9-F8)+(1-$E$1)*G8","v":0.36035156250000011},null,7.0312499999998224E-3,4.9438476562497503E-5]
["2000Q4",3,7.38,3.1542968749995737E-3,7.3768457031250003,{"$f":"$C$1*(C10)+(1-$C$1)*(F9+G9)","v":7.3768457031250003},0.36271728515625024,null,3.1542968749995737E-3,9.9495887756320755E-6]
["2001Q1",4,6.24,-0.374890747070312,6.6148907470703122,{"$f":"$C$1*C11+(1-$C$1)*(F10+G10)","v":6.6148907470703122},8.1549224853515678E-2,null,0.374890747070312,0.14054307223893664]
["2001Q2",5,6.72,5.8900070190430753E-3,6.7141099929809567,6.7141099929809567,8.5966730117797874E-2,null,5.8900070190430753E-3,3.4692182684376692E-5]
["2001Q3",6,6.47,-8.2519180774689005E-2,6.5525191807746888,6.5525191807746888,2.4077344536781425E-2,null,8.2519180774689005E-2,6.8094151957258037E-3]
["2001Q4",7,5.43,-0.2866491313278674,5.7166491313278671,5.7166491313278671,-0.19090950395911935,null,0.2866491313278674,8.2167724491020971E-2]
["2002Q1",8,5.55,6.0650931578134504E-3,5.5439349068421864,5.5439349068421864,{"$f":"$E$1*(F15-F14)+(1-$E$1)*G14","v":-0.1863606840907597},null,6.0650931578134504E-3,3.678535501295553E-5]
["2002Q2",9,5.13,-5.6893555687857145E-2,5.186893555687857,5.186893555687857,-0.22903085085665212,null,5.6893555687857145E-2,3.2368766788073021E-3]
["2002Q3",10,4.4800000000000004,-0.1194656762078008,{"$f":"F17+L17","v":4.5994656762078012},4.5994656762078012,-0.31863010801250302,null,0.1194656762078008,1.4272047791787101E-2]
["2002Q4",11,4.1500000000000004,-3.2708892048824545E-2,4.1827088920488249,4.1827088920488249,-0.34316177704912132,null,3.2708892048824545E-2,1.0698716190616576E-3]
["2003Q1",12,3.75,-2.2386778749925895E-2,3.7723867787499259,3.7723867787499259,-0.35995186111156574,null,2.2386778749925895E-2,5.0116786279813367E-4]
["2003Q2",13,3.49,1.9391270590410237E-2,3.47060872940959,3.47060872940959,-0.34540840816875829,null,1.9391270590410237E-2,3.7602137511050899E-4]
["2003Q3",14,4.26,0.28369991968979225,3.9763000803102075,3.9763000803102075,-0.13263346840141432,null,0.28369991968979225,8.0485644431994574E-2]
["2003Q4",15,4.82,0.24408334702280143,4.5759166529771989,4.5759166529771989,5.0429041865687085E-2,null,0.24408334702280143,5.957668029385331E-2]
["2004Q1",16,4.5,-3.1586423710721512E-2,4.5315864237107215,4.5315864237107215,2.6739224082645979E-2,null,3.1586423710721512E-2,9.9770216283323002E-4]
["2004Q2",17,5.0199999999999996,0.11541858805165806,4.9045814119483415,4.9045814119483415,0.11330316512138949,null,0.11541858805165806,1.3321450467838343E-2]
["2004Q3",18,5.0199999999999996,5.2885573256666873E-4,5.0194711442674329,5.0194711442674329,0.11369980692081497,null,5.2885573256666873E-4,2.7968838586862784E-7]
["2004Q4",19,4.04,-0.2732927377970622,4.3132927377970622,4.3132927377970622,-9.1269746426981435E-2,null,0.2732927377970622,7.4688920532613792E-2]
["2005Q1",20,3.62,-0.15050574784252024,3.7705057478425203,3.7705057478425203,-0.20414905730887156,null,0.15050574784252024,2.2651980133636288E-2]
["2005Q2",21,3.31,-6.4089172633412073E-2,3.3740891726334121,3.3740891726334121,-0.25221593678393073,null,6.4089172633412073E-2,4.1074220488352946E-3]
["2005Q3",22,3.26,3.4531691037629653E-2,3.2254683089623701,3.2254683089623701,-0.22631716850570854,null,3.4531691037629653E-2,1.1924376859183121E-3]
["2005Q4",23,3.61,0.1527122148858342,3.4572877851141657,3.4572877851141657,-0.11178300734133251,null,0.1527122148858342,2.3321020575337199E-2]
["2006Q1",24,3.57,5.6123805556791861E-2,3.513876194443208,3.513876194443208,-6.9690153173738806E-2,null,5.6123805556791861E-2,3.1498815501765812E-3]
["2006Q2",25,4.05,0.15145348968263272,3.8985465103173671,3.8985465103173671,4.3899964088235675E-2,null,0.15145348968263272,2.2938159537047337E-2]
["2006Q3",26,3.9,-1.0611618601400696E-2,3.9106116186014006,3.9106116186014006,3.5941250137185132E-2,null,1.0611618601400696E-2,1.1260644934159327E-4]
["2006Q4",27,3.68,-6.6638217184646464E-2,3.7466382171846466,3.7466382171846466,-1.4037412751299647E-2,null,6.6638217184646464E-2,4.4406519895481113E-3]
["2007Q1",28,3.76,6.8497988916629282E-3,3.7531502011083369,3.7531502011083369,-8.9000635825521764E-3,null,6.8497988916629282E-3,4.6919744856226681E-5]
["2007Q2",29,4.53,0.19643746561855391,4.3335625343814463,4.3335625343814463,0.13842803563136324,null,0.19643746561855391,3.8587677898640552E-2]
["2007Q3",30,4.54,1.7002357496797238E-2,4.5229976425032028,4.5229976425032028,0.15117980375396156,null,1.7002357496797238E-2,2.8908016044889721E-4]
["2007Q4",31,null,null,1.1685443615642912,1.1685443615642912,-0.72522846741925673,null,0,0]
[null,32,null,null,null,null,null,null,0,0]
[null,null,{"$f":"SUM(C8:C39)/30","v":4.7276666666666669},{"$f":"SUM(D8:D39)/30","v":-9.5308976109350855E-3},{"$f":"SUM(E8:E39)","v":143.28447128989239},null,null,null,{"$f":"SUM(I8:I39)/30","v":9.5753711031534239E-2},{"$f":"SUM(J8:J39)/30","v":1.9967185940252978E-2}]
[null,null,"yprum","ME",null,null,null,null,"MAE","MSE"]

{"sheet":"HoltC943","index":3,"n_rows":61,"n_cols":10,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["počáteční hodnoty","   alfa =",0.4,"   gama =",0.1]
["      počáteční hodnoty  jsou určeny jako L0=yt , T0=y2-y1"]
[null,null,null,null,null,"L0","T0",{"$f":"(H8+H12+H16+H20+H24+H28+H32+H36+H40+H44+H48+H52+H56)/13","v":0},"S01"]
[null,null,null,null,null,{"$f":"C8","v":332995},{"$f":"C9-C8","v":33623},{"$f":"(H9+H13+H17+H21+H25+H29+H33+H37+H41+H45+H49+H53+H57)/13","v":0},"S02"]
[null,null,null,null,null,null,null,{"$f":"(H10+H14+H18+H22+H26+H30+H34+H38+H42+H46+H50+H54+H58)/12","v":0},"S03"]
[null,null,null,null,null,null,null,{"$f":"(H11+H15+H19+H23+H27+H31+H35+H39+H43+H47+H51+H55+H59)/13","v":0},"S04"]
["   DATE","NOBS","HDPCR","rezidua","HOLT","Lt","Tt",null,"abs.rezidua","rezidua2"]
["1995Q1",1,332995,{"$f":"C8-E8","v":-20173.799999999988},{"$f":"F8+L8","v":353168.8},{"$f":"$C$1*(C8)+(1-$C$1)*(F4+G4)","v":353168.8},{"$f":"$E$1*(F8-F4)+(1-$E$1)*G4","v":32278.079999999998},null,{"$f":"ABS(D8)","v":20173.799999999988},{"$f":"D8*D8","v":406982206.43999952}]
["1995Q2",{"$f":"B8+1","v":2},366618,-11297.32799999998,{"$f":"F9","v":377915.32799999998},{"$f":"$C$1*(C9)+(1-$C$1)*(F8+G8)","v":377915.32799999998},{"$f":"$E$1*(F9-F8)+(1-$E$1)*G8","v":31524.924799999997},null,11297.32799999998,127629619.93958354]
["1995Q3",3,376688,-19651.351679999963,{"$f":"F10","v":396339.35167999996},{"$f":"$C$1*(C10)+(1-$C$1)*(F9+G9)","v":396339.35167999996},30214.834687999995,null,19651.351679999963,386175622.85103738]
["1995Q4",4,390221,-21799.911820799927,412020.91182079993,412020.91182079993,28761.507233279994,null,21799.911820799927,475236155.39465243]
["1996Q1",5,382859,-34754.051432447974,417613.05143244797,{"$f":"$C$1*(C12)+(1-$C$1)*(F11+G11)","v":417613.05143244797},26444.5704711168,null,34754.051432447974,1207844090.969239]
["1996Q2",6,423953,-12062.773142138845,436015.77314213885,436015.77314213885,25640.38559497421,null,12062.773142138845,145510495.87870628]
["1996Q3",7,432152,-17702.495242267847,449854.49524226785,449854.49524226785,24460.21924548969,null,17702.495242267847,313378337.80251575]
["1996Q4",8,444324,-17994.428692654474,462318.42869265447,462318.42869265447,23260.590665979384,null,17994.428692654474,323799463.97502661]
["1997Q1",9,415593,-41991.611615180329,457584.61161518033,{"$f":"$C$1*(C16)+(1-$C$1)*(F15+G15)","v":457584.61161518033},20461.149891634032,null,41991.611615180329,1763295446.0401475]
["1997Q2",10,455790,-13353.456904088613,{"$f":"F17+L17","v":469143.45690408861},469143.45690408861,19570.919431361457,null,13353.456904088613,178314811.28935182]
["1997Q3",11,461902,-16087.425801270059,477989.42580127006,477989.42580127006,18498.424377943458,null,16087.425801270059,258805268.91136962]
["1997Q4",12,477809,-11207.310107528116,489016.31010752812,489016.31010752812,17751.270370774921,null,11207.310107528116,125603799.84630187]
["1998Q1",13,457925,-29305.548286981822,487230.54828698182,{"$f":"$C$1*(C20)+(1-$C$1)*(F19+G19)","v":487230.54828698182},15797.567151642801,null,29305.548286981822,858815160.4006232]
["1998Q2",14,512225,5518.130736825231,506706.86926317477,506706.86926317477,16165.442534097816,null,5518.130736825231,30449766.828695368]
["1998Q3",15,512408,-6278.5870783635764,518686.58707836358,518686.58707836358,15746.870062206915,null,6278.5870783635764,39420655.700594068]
["1998Q4",16,513925,-12305.07428434235,526230.07428434235,526230.07428434235,14926.531776584103,null,12305.07428434235,151414853.14318341]
["1999Q1",17,481895,-35556.963636555884,517451.96363655588,{"$f":"$C$1*(C24)+(1-$C$1)*(F23+G23)","v":517451.96363655588},12556.067534147045,null,35556.963636555884,1264297663.0513575]
["1999Q2",18,532968,1775.981297578197,531192.0187024218,531192.0187024218,12674.466287318934,null,1775.981297578197,3154109.5693475362]
["1999Q3",19,529465,-8640.8909938444849,538105.89099384448,538105.89099384448,12098.406887729308,null,8640.8909938444849,74664997.167502731]
["1999Q4",20,536469,-8241.1787289442727,544710.17872894427,544710.17872894427,11548.994972466357,null,8241.1787289442727,67917026.842403546]
["2000Q1",21,504479,-31068.104220846435,535547.10422084644,{"$f":"$C$1*(C28)+(1-$C$1)*(F27+G27)","v":535547.10422084644},9477.7880244099379,null,31068.104220846435,965227099.87737608]
["2000Q2",22,558691,8199.6646528461715,550491.33534715383,550491.33534715383,10024.432334599685,null,8199.6646528461715,67234500.41913493]
["2000Q3",23,557780,-1641.4606090520974,559421.4606090521,559421.4606090521,9915.0016273295441,null,1641.4606090520974,2694392.9310696828]
["2000Q4",24,568219,-670.47734182898421,568889.47734182898,568889.47734182898,9870.303137874278,null,670.47734182898421,449539.86590606056]
["2001Q1",25,540124,-23181.468287821976,563305.46828782198,{"$f":"$C$1*(C32)+(1-$C$1)*(F31+G31)","v":563305.46828782198},8324.8719186861508,null,23181.468287821976,537380471.97929597]
["2001Q2",26,598842,16326.995876095141,582515.00412390486,582515.00412390486,9413.3383104258246,null,16326.995876095141,266570794.33802775]
["2001Q3",27,599262,4400.1945394015638,594861.80546059844,594861.80546059844,9706.6846130525992,null,4400.1945394015638,19361711.98457934]
["2001Q4",28,613986,5650.5059558092616,608335.49404419074,608335.49404419074,10083.385010106569,null,5650.5059558092616,31928217.556635939]
["2002Q1",29,576665,-25052.32743257843,601717.32743257843,{"$f":"$C$1*(C36)+(1-$C$1)*(F35+G35)","v":601717.32743257843},8413.2298479346828,null,25052.32743257843,627619109.78912175]
["2002Q2",30,630141,12006.265631692135,618134.73436830787,618134.73436830787,9213.6475567141588,null,12006.265631692135,144150414.41875175]
["2002Q3",31,621004,-3806.6291550132446,624810.62915501324,624810.62915501324,8959.8722797132814,null,3806.6291550132446,14490425.523796849]
["2002Q4",32,636622,1710.8991391641321,634911.10086083587,634911.10086083587,9073.9322223242161,null,1710.8991391641321,2927175.8643925684]
["2003Q1",33,598385,-27360.019849895965,625745.01984989597,{"$f":"$C$1*(C40)+(1-$C$1)*(F39+G39)","v":625745.01984989597},7249.9308989978044,null,{"$f":"ABS(D40)","v":27360.019849895965},{"$f":"D40*D40","v":748570686.1867013}]
["2003Q2",34,660401,16443.629550663754,643957.37044933625,643957.37044933625,8346.1728690420532,null,16443.629550663754,270392952.79946226]
["2003Q3",35,650791,-907.5259910270106,651698.52599102701,651698.52599102701,8285.6711363069244,null,907.5259910270106,823603.42438955768]
["2003Q4",36,667533,4529.2817235996481,663003.71827640035,663003.71827640035,8587.6232512135666,null,4529.2817235996481,20514392.931733798]
["2004Q1",37,650616,-12585.204916568357,663201.20491656836,{"$f":"$C$1*(C44)+(1-$C$1)*(F43+G43)","v":663201.20491656836},7748.6095901090112,null,12585.204916568357,158387382.79201633]
["2004Q2",38,716444,27296.51129599358,689147.48870400642,689147.48870400642,9568.3770098419172,null,27296.51129599358,745099528.9323051]
["2004Q3",39,712711,8397.0805716910399,704313.91942830896,704313.91942830896,10128.182381287979,null,8397.0805716910399,70510962.127471119]
["2004Q4",40,737591,13889.338914241875,723701.66108575813,723701.66108575813,11054.138308904099,null,13889.338914241875,192913735.47467366]
["2005Q1",41,697345,-22446.479636797332,719791.47963679733,{"$f":"$C$1*(C48)+(1-$C$1)*(F47+G47)","v":719791.47963679733},9557.7063331176105,null,22446.479636797332,503844448.08515728]
["2005Q2",42,762115,19659.488418051042,742455.51158194896,742455.51158194896,10868.338894321012,null,19659.488418051042,386495484.85948306]
["2005Q3",43,756632,1984.889714238001,754647.110285762,754647.110285762,11000.664875270215,null,1984.889714238001,3939787.1776878135]
["2005Q4",44,778304,7593.734903380624,770710.26509661938,770710.26509661938,11506.913868828931,null,7593.734903380624,57664809.782821134]
["2006Q1",45,742621,-23757.707379268948,766378.70737926895,{"$f":"$C$1*(C52)+(1-$C$1)*(F51+G51)","v":766378.70737926895},9923.0667102109965,null,23757.707379268948,564428659.91897023]
["2006Q2",46,861462,51096.135546311969,810365.86445368803,810365.86445368803,13329.475746631806,null,51096.135546311969,2610815067.7670856]
["2006Q3",47,820093,-2161.4041201919317,822254.40412019193,822254.40412019193,13185.382138619016,null,2161.4041201919317,4671667.7707826588]
["2006Q4",48,841083,3385.928244713461,837697.07175528654,837697.07175528654,13411.110688266575,null,3385.928244713461,11464510.07834838]
["2007Q1",49,817704,-20042.509466131916,837746.50946613192,{"$f":"$C$1*(C56)+(1-$C$1)*(F55+G55)","v":837746.50946613192},12074.943390524455,null,20042.509466131916,401702185.69998747]
["2007Q2",50,899674,29911.528286006069,869762.47171399393,869762.47171399393,14069.04527625821,null,29911.528286006069,894699524.40454113]
["2007Q3",51,null,null,null,530298.91019415134,null,null,0,0]
["2007Q4",52,null,null,null,318179.34611649078,null,null,0,0]
[null,null,{"$f":"SUM(C8:C59)/50","v":588310.07999999996},{"$f":"SUM(D8:D59)/50","v":-5866.1864171225643},{"$f":"SUM(E8:E59)","v":29708813.320856124},null,null,null,{"$f":"SUM(I8:I59)/50","v":15457.233817054681},{"$f":"SUM(J8:J59)/50","v":370593655.93606699}]
[null,null,"yprum","ME",null,null,null,null,"MAE","MSE"]

{"sheet":"HoltC913","index":5,"n_rows":69,"n_cols":10,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
["počáteční hodnoty","   alfa =",0.4,"   gama =",0.1]
["      počáteční hodnoty  jsou určeny jako L0=yt , T0=y2-y1"]
[null,null,null,null,null,"L0","T0",{"$f":"(H8+H12+H16+H20+H24+H28+H32+H36+H40+H44+H48+H52+H56)/13","v":0},"S01"]
[null,null,null,null,null,{"$f":"C8","v":179342.9},{"$f":"C9-C8","v":536.70000000001164},{"$f":"(H9+H13+H17+H21+H25+H29+H33+H37+H41+H45+H49+H53+H57)/13","v":0},"S02"]
[null,null,null,null,null,null,null,{"$f":"(H10+H14+H18+H22+H26+H30+H34+H38+H42+H46+H50+H54+H58)/12","v":0},"S03"]
[null,null,null,null,null,null,null,{"$f":"(H11+H15+H19+H23+H27+H31+H35+H39+H43+H47+H51+H55+H59)/13","v":0},"S04"]
["QUARTER","NOBS","DEPOSITS","rezidua","HOLT","Lt","Tt",null,"abs.rezidua","rezidua2"]
["1993Q1",1,179342.9,{"$f":"C8-E8","v":-322.01999999998952},{"$f":"F8+L8","v":179664.91999999998},{"$f":"$C$1*(C8)+(1-$C$1)*(F4+G4)","v":179664.91999999998},{"$f":"$E$1*(F8-F4)+(1-$E$1)*G4","v":515.23200000000941},null,{"$f":"ABS(D8)","v":322.01999999998952},{"$f":"D8*D8","v":103696.88039999326}]
["1993Q2",2,179879.6,-180.33119999998598,{"$f":"F9","v":180059.93119999999},{"$f":"$C$1*(C9)+(1-$C$1)*(F8+G8)","v":180059.93119999999},{"$f":"$E$1*(F9-F8)+(1-$E$1)*G8","v":503.20992000000928},null,180.33119999998598,32519.341693434944]
["1993Q3",{"$f":"B9+1","v":3},184157.9,2156.8553280000051,182001.04467199999,182001.04467199999,647.0002752000081,null,2156.8553280000051,4652024.9059220096]
["1993Q4",{"$f":"B10+1","v":4},204782.7,13280.79303167999,191501.90696832002,191501.90696832002,1532.3864773120106,null,13280.79303167999,176379463.55031979]
["1994Q1",{"$f":"B11+1","v":5},215145.3,13266.603932620783,201878.69606737921,201878.69606737921,2416.826739486728,null,13266.603932620783,176002779.90502921]
["1994Q2",6,220120.4,9494.9263158804388,210625.47368411956,210625.47368411956,3049.8218272120903,null,9494.9263158804388,90153625.743998885]
["1994Q3",7,224857.60000000001,6709.3826932010124,218148.21730679899,218148.21730679899,3497.1140067588249,null,6709.3826932010124,45015816.123825274]
["1994Q4",8,244498.9,13712.141211865324,230786.75878813467,230786.75878813467,4411.2567542165107,null,13712.141211865324,188022816.61413544]
["1995Q1",9,257013.4,13089.230674589315,243924.16932541068,243924.16932541068,5283.8721325224606,null,13089.230674589315,171327959.65260985]
["1995Q2",10,268251.59999999998,11426.135125240078,{"$f":"F17+L17","v":256825.4648747599},256825.4648747599,6045.6144742051365,null,11426.135125240078,130556563.9002451]
["1995Q3",11,280707.7,10701.972390621027,270005.72760937898,270005.72760937898,6759.0793002465325,null,10701.972390621027,114532213.04961474]
["1995Q4",12,306236.90000000002,17683.25585422467,288553.64414577535,288553.64414577535,7937.9630238615164,null,17683.25585422467,312697537.60597104]
["1996Q1",13,320848.59999999998,14614.195698217838,306234.40430178214,306234.40430178214,8912.2427370760433,null,14614.195698217838,213574715.90580878]
["1996Q2",14,329595.09999999998,8669.0717766850721,320926.0282233149,320926.0282233149,9490.1808555217158,null,8669.0717766850721,75152805.469317675]
["1996Q3",15,336112.3,3417.654552698019,332694.64544730197,332694.64544730197,9718.0244923682494,null,3417.654552698019,11680362.641577495]
["1996Q4",16,365625.2,13927.518036197813,351697.6819638022,351697.6819638022,10646.525694781449,null,13927.518036197813,193975758.64861539]
["1997Q1",17,414840.1,31497.535404849797,383342.56459515018,383342.56459515018,12746.361388438101,null,31497.535404849797,992094736.57976651]
["1997Q2",18,441183,27056.444409847027,414126.55559015297,414126.55559015297,14550.124349094571,null,27056.444409847027,732051184.10314238]
["1997Q3",19,443649.1,8983.4520364514319,434665.64796354854,434665.64796354854,15149.021151524672,null,8983.4520364514319,80702410.49122338]
["1997Q4",20,473921.5,14464.098530956078,459457.40146904392,459457.40146904392,16113.294386921743,null,14464.098530956078,209210146.31320578]
["1998Q1",21,493387.1,10689.842486420646,482697.25751357933,482697.25751357933,16825.950552683113,null,10689.842486420646,114272732.38448395]
["1998Q2",22,512073.8,7530.3551602425287,504543.44483975746,504543.44483975746,17327.974230032614,null,7530.3551602425287,56706248.839391276]
["1998Q3",23,527451.80000000005,3348.2285581260221,524103.57144187402,524103.57144187402,17551.189467241009,null,3348.2285581260221,11210634.477450661]
["1998Q4",24,549745.5,4854.4434545310214,544891.05654546898,544891.05654546898,17874.819030876402,null,4854.4434545310214,23565621.253239077]
["1999Q1",25,559644.4,-1872.8853458071826,561517.28534580721,561517.28534580721,17749.960007822585,null,1872.8853458071826,3507699.5185392899]
["1999Q2",26,554565.30000000005,-14821.167212177883,569386.46721217793,569386.46721217793,16761.8821936774,null,14821.167212177883,219666997.53133672]
["1999Q3",27,542409.4,-26243.36964351323,568652.76964351325,568652.76964351325,15012.324217443193,null,26243.36964351323,688714450.2460717]
["1999Q4",28,536933.69999999995,-28038.836316573899,564972.53631657385,564972.53631657385,13143.068463004935,null,28038.836316573899,786176341.98762333]
["2000Q1",29,548175,-17964.362867747201,566139.3628677472,566139.3628677472,11945.444271821776,null,17964.362867747201,322718333.24409443]
["2000Q2",30,543395.4,-20813.644283741363,564209.04428374139,564209.04428374139,10557.867986239016,null,20813.644283741363,433207788.37011951]
["2000Q3",31,547678.9,-16252.807361988234,563931.70736198826,563931.70736198826,9474.3474954398025,null,16252.807361988234,264153747.14589894]
["2000Q4",32,549152.9,-14551.892914456897,563704.79291445692,563704.79291445692,8504.2213011426884,null,14551.892914456897,211757587.39382085]
["2001Q1",33,568758.9,{"$f":"C40-E40","v":-2070.0685293597635},570828.96852935979,570828.96852935979,8366.2167325187056,null,{"$f":"ABS(D40)","v":2070.0685293597635},{"$f":"D40*D40","v":4285183.7162456941}]
["2001Q2",34,583195.19999999995,2400.008842872805,580795.19115712715,{"$f":"$C$1*(C41)+(1-$C$1)*(F40+G40)","v":580795.19115712715},{"$f":"$E$1*(F41-F40)+(1-$E$1)*G40","v":8526.2173220435707},null,2400.008842872805,5760042.4458676605]
["2001Q3",35,589675.9,212.69491249753628,589463.20508750249,589463.20508750249,8540.3969828767476,null,212.69491249753628,45239.125802334616]
["2001Q4",36,595970.9,-1219.6212422274984,597190.52124222752,597190.52124222752,8459.0889000615771,null,1219.6212422274984,1487475.9744925464]
["2002Q1",37,596536.5,-5467.8660853734473,602004.36608537345,602004.36608537345,8094.5644943700117,null,5467.8660853734473,29897559.527577147]
["2002Q2",38,594155.30000000005,-9566.1783478460275,603721.47834784607,603721.47834784607,7456.819271180274,null,9566.1783478460275,91511768.182798147]
["2002Q3",39,580665.59999999998,-18307.618571415893,598973.21857141587,598973.21857141587,6236.311366419226,null,18307.618571415893,335168897.75645208]
["2002Q4",40,567335.80000000005,-22724.237962701009,590060.03796270106,590060.03796270106,4721.3621689058218,null,22724.237962701009,516390990.98546171]
["2003Q1",41,560701.5,-20447.940078964108,581149.44007896411,581149.44007896411,3358.1661636415456,null,20447.940078964108,418118253.47290665]
["2003Q2",42,553728.30000000005,-18467.583745563286,572195.88374556333,572195.88374556333,2126.9939139373137,null,18467.583745563286,341051649.39939332]
["2003Q3",43,548450.69999999995,-15523.306595700444,563974.0065957004,563974.0065957004,1092.1068075572889,null,15523.306595700444,240973047.66411689]
["2003Q4",44,558026.19999999995,-4223.9480419545434,562250.1480419545,562250.1480419545,810.51027142697001,null,4223.9480419545434,17841737.061131623]
["2004Q1",45,557442.5,-3370.8949880287983,560813.3949880288,560813.3949880288,585.7839388917032,null,3370.8949880287983,11362933.020317672]
["2004Q2",46,563668.19999999995,1361.4126438476378,562306.78735615232,562306.78735615232,676.54478181488457,null,1361.4126438476378,1853444.3868282151]
["2004Q3",47,569176.80000000005,3716.0807172197383,565460.71928278031,565460.71928278031,924.28349629619538,null,3716.0807172197383,13809255.896892365]
["2004Q4",48,587564.80000000005,12707.87833255413,574856.92166744592,574856.92166744592,1771.4753851331366,null,12707.87833255413,161490171.71499872]
["2005Q1",49,584631.30000000005,4801.7417684525717,{"$f":"F56+L56","v":579829.55823154747},{"$f":"$C$1*(C56)+(1-$C$1)*(F55+G55)","v":579829.55823154747},{"$f":"$E$1*(F56-F55)+(1-$E$1)*G55","v":2091.5915030299789},null,4801.7417684525717,23056724.010902032]
["2005Q2",50,589489.69999999995,4541.1301592534874,584948.56984074647,584948.56984074647,2394.33351364688,null,4541.1301592534874,20621863.123281602]
["2005Q3",51,582149.80000000005,-3115.8620126359165,585265.66201263596,585265.66201263596,2186.6093794711419,null,3115.8620126359165,9708596.0817875434]
["2005Q4",52,599177.5,7035.1371647357009,592142.3628352643,592142.3628352643,2655.6185237868613,null,7035.1371647357009,49493154.92664548]
["2006Q1",53,597108,1386.0111845692154,595721.98881543078,595721.98881543078,2748.0192694248235,null,1386.0111845692154,1921027.0037509596]
["2006Q2",54,604796.4,3795.8351490866626,601000.56485091336,601000.56485091336,3001.0749460305988,null,3795.8351490866626,14408364.479041766]
["2006Q3",55,606284.6,1369.7761218335945,604914.82387816638,604914.82387816638,3092.3933541528413,null,1369.7761218335945,1876286.6239454823]
["2006Q4",56,630641.9,13580.809660608531,617061.09033939149,617061.09033939149,3997.7806648600681,null,13580.809660608531,184438391.037678]
["2007Q1",57,636801.4,9445.517397449119,{"$f":"F64+L64","v":627355.8826025509},{"$f":"$C$1*(C64)+(1-$C$1)*(F63+G63)","v":627355.8826025509},{"$f":"$E$1*(F64-F63)+(1-$E$1)*G63","v":4627.4818246900031},null,9445.517397449119,89217798.905513972]
["2007Q2",58]
["2007Q3",59]
["2007Q4",60]
[null,null,{"$f":"SUM(C8:C67)/57","v":473009.06491228071},{"$f":"SUM(D8:D67)/57","v":1076.5215328131592},{"$f":"SUM(E8:E67)","v":26900154.972629655},{"$f":"SUM(F8:F67)","v":26900154.972629655},{"$f":"SUM(G8:G67)","v":411195.94618034118},null,{"$f":"SUM(I8:I67)/57","v":10394.64235203339},{"$f":"SUM(J8:J67)/57","v":169111704.84811091}]
[null,null,"yprum","ME",null,null,null,null,"MAE","MSE"]