{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"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":"Sheet1","index":0,"n_rows":193,"n_cols":19,"rows_kept":193,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Data by Year/Month"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,2000,157,127,136,176,263,195,284,212,197,232,262,201]
[null,2001,145,147,129,267,271,284,294,196,186,208,248,228]
[null,2002,135,130,159,275,215,244,250,241,211,203,229,300]
[null,2003,187,152,181,222,285,360,228,280,241,241,271,237]
[null,2004,178,130,167,225,261,289,357,252,211,263,343,230]
[null,2005,146,146,150,295,308,291,296,242,294,235,311,298]
[null,2006,171,172,210,270,376,316,270,222,280,250,299,272]
[null,2007,198,203,231,282,337,385,408,259,256,326,281,386]
[null,2008,218,236,238,367,334,371,348,352,278,280,386,410]
[null,2009,202,176,201,335,330,432,410,297,287,241,425,346]
[null,2010,188,180,237,302,427,414,389,370,247,306,514,420]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PART 6. SEASONAL INDEX "]
["X labels","Year","Month","X","Y","X * Y","X * X","X-Xbar","X-Xbar SQD","Y-Ybar","(X-Xb)(Y-Yb)","TREND","Y/TREND",null,null,"Month","sum y/t","ave y/t"]
[{"$f":"MID(TEXT(B21,\"####\"),3,2)&\"-\"&TEXT(C21,\"##\")","v":"00-1"},2000,1,1,157,{"$f":"D21*E21","v":157},{"$f":"D21*D21","v":1},{"$f":"D21-$D$155","v":-65.5},{"$f":"H21*H21","v":4290.25},{"$f":" E21-$D$156","v":-105.07575757575756},{"$f":"H21*J21","v":6882.4621212121201},{"$f":"$H$160+D21*$H$159","v":185.45135566188196},{"$f":"E21/L21","v":0.84658318856533488},null,null,1,{"$f":"$M21+$M33+$M45+$M57+$M69+$M81+$M93+$M105+$M117","v":6.3993789477983913},{"$f":"Q21/9","v":0.71104210531093237}]
[{"$f":"MID(TEXT(B22,\"####\"),3,2)&\"-\"&TEXT(C22,\"##\")","v":"00-2"},2000,2,2,127,{"$f":"D22*E22","v":254},{"$f":"D22*D22","v":4},{"$f":"D22-$D$155","v":-64.5},{"$f":"H22*H22","v":4160.25},{"$f":" E22-$D$156","v":-135.07575757575756},{"$f":"H22*J22","v":8712.3863636363621},{"$f":"$H$160+D22*$H$159","v":186.62119385904037},{"$f":"E22/L22","v":0.68052292118507318},null,null,2,{"$f":"$M22+$M34+$M46+$M58+$M70+$M82+$M94+$M106+$M118","v":5.9242188144505121},{"$f":"Q22/9","v":0.6582465349389458}]
["00-3",2000,3,3,136,408,9,-63.5,4032.25,-126.07575757575756,8005.8106060606051,187.79103205619876,0.72420923678240579,null,null,3,6.5258466610682904,0.72509407345203225]
["00-4",2000,4,4,176,704,16,-62.5,3906.25,-86.075757575757564,5379.734848484848,188.96087025335717,0.93140976628664263,null,null,4,9.7190770802028936,1.0798974533558772]
["00-5",2000,5,5,263,1315,25,-61.5,3782.25,0.9242424242424363,-56.840909090909832,190.13070845051558,1.3832589282569774,null,null,5,10.809323669998713,1.2010359633331904]
["00-6",2000,6,6,195,1170,36,-60.5,3660.25,-67.075757575757564,4058.0833333333326,191.300546647674,1.0193384358652118,null,null,6,11.036169748182211,1.2262410831313568]
["00-7",2000,7,7,284,1988,49,-59.5,3540.25,21.924242424242436,-1304.4924242424249,192.47038484483238,1.4755516815169141,null,null,7,11.088489653856833,1.2320544059840925]
["00-8",2000,8,8,212,1696,64,-58.5,3422.25,-50.075757575757564,2929.4318181818176,193.64022304199079,1.0948138597941395,null,null,8,9.0760691120535224,1.0084521235615025]
["00-9",2000,9,9,197,1773,81,-57.5,3306.25,-65.075757575757564,3741.8560606060601,194.81006123914921,1.0112414048171896,null,null,9,8.5980493526741792,0.95533881696379774]
["00-10",2000,10,10,232,2320,100,-56.5,3192.25,-30.075757575757564,1699.2803030303023,195.97989943630762,1.1837948721644218,null,null,10,8.9267736283690766,0.99186373648545301]
["00-11",2000,11,11,262,2882,121,-55.5,3080.25,-7.57575757575637E-2,4.2045454545447853,197.149737633466,1.3289391258896899,null,null,11,10.431259727885221,1.1590288586539135]
["00-12",2000,12,12,201,2412,144,-54.5,2970.25,-61.075757575757564,3328.6287878787871,198.31957583062442,1.0135156812339332,null,null,12,9.9957396900902786,1.1106377433433643]
["01-1",2001,1,13,145,1885,169,-53.5,2862.25,-117.07575757575756,6263.55303030303,199.48941402778283,0.72685561139502819,null,null,null,"AVE SI",{"$f":"SUM(R21:R32)/12","v":1.0049110748762049}]
["01-2",2001,2,14,147,2058,196,-52.5,2756.25,-115.07575757575756,6041.4772727272721,200.65925222494124,0.73258520785880021]
["01-3",2001,3,15,129,1935,225,-51.5,2652.25,-133.07575757575756,6853.4015151515141,201.82909042209963,0.63915464183192361,null,null,"PART 7. Least Squares Forecast for 2011"]
["01-4",2001,4,16,267,4272,256,-50.5,2550.25,4.9242424242424363,-248.67424242424303,202.99892861925804,1.3152778776521599,null,null,"Month","X","Trend","Seasonalized"]
["01-5",2001,5,17,271,4607,289,-49.5,2450.25,8.9242424242424363,-441.75000000000057,204.16876681641645,1.3273332852310196,null,null,1,133,{"$f":"184.28+1.169*Q37","v":339.75700000000001},{"$f":"R37*R21","v":241.58153257412644}]
["01-6",2001,6,18,284,5112,324,-48.5,2352.25,21.924242424242436,-1063.3257575757582,205.33860501357486,1.3830813742073726,null,null,2,134,{"$f":"184.28+1.169*Q38","v":340.92600000000004},{"$f":"R38*R22","v":224.41335817059507}]
["01-7",2001,7,19,294,5586,361,-47.5,2256.25,31.924242424242436,-1516.4015151515157,206.50844321073328,1.4236706036275002,null,null,3,135,342.09500000000003,248.05105705757299]
["01-8",2001,8,20,196,3920,400,-46.5,2162.25,-66.075757575757564,3072.5227272727266,207.67828140789166,0.94376744005814039,null,null,4,136,343.26400000000001,370.68991942875181]
["01-9",2001,9,21,186,3906,441,-45.5,2070.25,-76.075757575757564,3461.4469696969691,208.84811960505007,0.89059935206379715,null,null,5,137,344.43299999999999,413.67641995874078]
["01-10",2001,10,22,208,4576,484,-44.5,1980.25,-54.075757575757564,2406.3712121212116,210.01795780220849,0.99039149878740862,null,null,6,138,345.60199999999998,423.79137081236314]
["01-11",2001,11,23,248,5704,529,-43.5,1892.25,-14.075757575757564,612.29545454545405,211.1877959993669,1.1743102806979597,null,null,7,139,346.77100000000002,427.24073841750976]
["01-12",2001,12,24,228,5472,576,-42.5,1806.25,-34.075757575757564,1448.2196969696965,212.35763419652528,1.073660482528255,null,null,8,140,347.94,350.88083187198919]
["02-1",2002,1,25,135,3375,625,-41.5,1722.25,-127.07575757575756,5273.643939393939,213.52747239368369,0.63223714722337243,null,null,9,141,349.10900000000004,333.51737905141448]
["02-2",2002,2,26,130,3380,676,-40.5,1640.25,-132.07575757575756,5349.0681818181811,214.69731059084211,0.60550362574287941,null,null,10,142,350.27800000000002,347.42804588865152]
["02-3",2002,3,27,159,4293,729,-39.5,1560.25,-103.07575757575756,4071.4924242424236,215.86714878800052,0.73656413628806117,null,null,11,143,351.447,407.33721528734191]
["02-4",2002,4,28,275,7700,784,-38.5,1482.25,12.924242424242436,-497.58333333333383,217.03698698515893,1.2670651386199192,null,null,12,144,352.61599999999999,391.62863850676371]
["02-5",2002,5,29,215,6235,841,-37.5,1406.25,-47.075757575757564,1765.3409090909086,218.20682518231732,0.98530373566620599]
["02-6",2002,6,30,244,7320,900,-36.5,1332.25,-18.075757575757564,659.76515151515105,219.37666337947573,1.1122422788331459]
["02-7",2002,7,31,250,7750,961,-35.5,1260.25,-12.075757575757564,428.68939393939354,220.54650157663414,1.1335477924737407,null,null,"PART 8. Forecasting using EXCEL TREND"]
["02-8",2002,8,32,241,7712,1024,-34.5,1190.25,-21.075757575757564,727.11363636363592,221.71633977379253,1.0869744658687841]
["02-9",2002,9,33,211,6963,1089,-33.5,1122.25,-51.075757575757564,1711.0378787878783,222.88617797095094,0.94667153396788883,null,null,"Month","X","TREND","Seasonalized"]
["02-10",2002,10,34,203,6902,1156,-32.5,1056.25,-59.075757575757564,1919.9621212121208,224.05601616810935,0.90602342874689423,null,null,1,133,{"$f":"TREND($E$21:$E$152,$D$21:$D$152,Q54)","v":339.86999768679152},{"$f":"R54*R21","v":241.66187868723796}]
["02-11",2002,11,35,229,8015,1225,-31.5,992.25,-33.075757575757564,1041.8863636363633,225.22585436526776,1.0167571598090661,null,null,2,134,{"$f":"TREND($E$21:$E$152,$D$21:$D$152,Q55)","v":341.03983588394999},{"$f":"R55*R22","v":224.48829024675683}]
["02-12",2002,12,36,300,10800,1296,-30.5,930.25,37.924242424242436,-1156.6893939393942,226.39569256242618,1.3251135505472491,null,null,3,135,342.20967408110835,248.1342065541632]
["03-1",2003,1,37,187,6919,1369,-29.5,870.25,-75.075757575757564,2214.734848484848,227.56553075958456,0.82174132161324243,null,null,4,136,343.37951227826676,370.81466084388342]
["03-2",2003,2,38,152,5776,1444,-28.5,812.25,-110.07575757575756,3137.1590909090905,228.73536895674297,0.66452337779359916,null,null,5,137,344.54935047542517,413.81616106407733]
["03-3",2003,3,39,181,7059,1521,-27.5,756.25,-81.075757575757564,2229.583333333333,229.90520715390139,0.78728099393954298,null,null,6,138,345.71918867258358,423.93507237716278]
["03-4",2003,4,40,222,8880,1600,-26.5,702.25,-40.075757575757564,1062.0075757575755,231.07504535105977,0.96072684812298725,null,null,7,139,346.889026869742,427.38615394239991]
["03-5",2003,5,41,285,11685,1681,-25.5,650.25,22.924242424242436,-584.5681818181821,232.24488354821818,1.2271529759699913,null,null,8,140,348.05886506690035,351.0007016011221]
["03-6",2003,6,42,360,15120,1764,-24.5,600.25,97.924242424242436,-2399.1439393939395,233.4147217453766,1.5423191703936763,null,null,9,141,349.22870326405882,333.63173622608713]
["03-7",2003,7,43,228,9804,1849,-23.5,552.25,-34.075757575757564,800.78030303030278,234.58455994253501,0.97193097472336631,null,null,10,142,350.39854146121718,347.54760659277582]
["03-8",2003,8,44,280,12320,1936,-22.5,506.25,17.924242424242436,-403.29545454545485,235.75439813969342,1.1876766762760005,null,null,11,143,351.56837965837559,407.4778978142528]
["03-9",2003,9,45,241,10845,2025,-21.5,462.25,-21.075757575757564,453.12878787878765,236.92423633685183,1.0172028143940215,null,null,12,144,{"$f":"TREND($E$21:$E$152,$D$21:$D$152,Q65)","v":352.738217855534},391.76437827003031]
["03-10",2003,10,46,241,11086,2116,-20.5,420.25,-21.075757575757564,432.05303030303003,238.09407453401022,1.0122049466022083]
["03-11",2003,11,47,271,12737,2209,-19.5,380.25,8.9242424242424363,-174.02272727272751,239.26391273116863,1.1326405094130902]
["03-12",2003,12,48,237,11376,2304,-18.5,342.25,-25.075757575757564,463.9015151515149,240.43375092832704,0.98571851532877908]
["04-1",2004,1,49,178,8722,2401,-17.5,306.25,-84.075757575757564,1471.3257575757573,241.60358912548543,0.73674402207472733]
["04-2",2004,2,50,130,6500,2500,-16.5,272.25,-132.07575757575756,2179.25,242.77342732264384,0.53547870305933898]
["04-3",2004,3,51,167,8517,2601,-15.5,240.25,-95.075757575757564,1473.6742424242423,243.94326551980225,0.68458540818559166]
["04-4",2004,4,52,225,11700,2704,-14.5,210.25,-37.075757575757564,537.59848484848465,245.11310371696067,0.91794358028208134]
["04-5",2004,5,53,261,13833,2809,-13.5,182.25,-1.0757575757575637,14.52272727272711,246.28294191411908,1.0597567089766733]
["04-6",2004,6,54,289,15606,2916,-12.5,156.25,26.924242424242436,-336.55303030303048,247.45278011127746,1.16789958823675]
["04-7",2004,7,55,357,19635,3025,-11.5,132.25,94.924242424242436,-1091.628787878788,248.62261830843588,1.4359111911415616]
["04-8",2004,8,56,252,14112,3136,-10.5,110.25,-10.075757575757564,105.79545454545442,249.79245650559429,1.0088375106489906]
["04-9",2004,9,57,211,12027,3249,-9.5,90.25,-51.075757575757564,485.21969696969688,250.96229470275267,0.84076374998847847]
["04-10",2004,10,58,263,15254,3364,-8.5,72.25,0.9242424242424363,-7.8560606060607086,252.13213289991108,1.0431038558040642]
["04-11",2004,11,59,343,20237,3481,-7.5,56.25,80.924242424242436,-606.93181818181824,253.3019710970695,1.3541150055581554]
["04-12",2004,12,60,230,13800,3600,-6.5,42.25,-32.075757575757564,208.49242424242416,254.47180929422791,0.90383292608285393]
["05-1",2005,1,61,146,8906,3721,-5.5,30.25,-116.07575757575756,638.41666666666663,255.64164749138632,0.57111195078227373]
["05-2",2005,2,62,146,9052,3844,-4.5,20.25,-116.07575757575756,522.34090909090901,256.81148568854474,0.56851039823454608]
["05-3",2005,3,63,150,9450,3969,-3.5,12.25,-112.07575757575756,392.2651515151515,257.98132388570309,0.58143743795367331]
["05-4",2005,4,64,295,18880,4096,-2.5,6.25,32.924242424242436,-82.310606060606091,259.15116208286156,1.1383317660203123]
["05-5",2005,5,65,308,20020,4225,-1.5,2.25,45.924242424242436,-68.886363636363654,260.32100028001992,1.1831546424172201]
[{"$f":"MID(TEXT(B86,\"####\"),3,2)&\"-\"&TEXT(C86,\"##\")","v":"05-6"},2005,6,66,291,{"$f":"D86*E86","v":19206},{"$f":"D86*D86","v":4356},{"$f":"D86-$D$155","v":-0.5},{"$f":"H86*H86","v":0.25},{"$f":" E86-$D$156","v":28.924242424242436},{"$f":"H86*J86","v":-14.462121212121218},{"$f":"$H$160+D86*$H$159","v":261.49083847717833},{"$f":"E86/L86","v":1.1128496955942}]
["05-7",2005,7,67,296,19832,4489,0.5,0.25,33.924242424242436,16.962121212121218,262.66067667433674,1.1269292524019476]
["05-8",2005,8,68,242,16456,4624,1.5,2.25,-20.075757575757564,-30.113636363636346,263.83051487149515,0.9172555347430974]
["05-9",2005,9,69,294,20286,4761,2.5,6.25,31.924242424242436,79.810606060606091,265.00035306865357,1.1094324841289307]
["05-10",2005,10,70,235,16450,4900,3.5,12.25,-27.075757575757564,-94.765151515151473,266.17019126581198,0.8828937563685193]
["05-11",2005,11,71,311,22081,5041,4.5,20.25,48.924242424242436,220.15909090909096,267.34002946297039,1.1633125073889357]
["05-12",2005,12,72,298,21456,5184,5.5,30.25,35.924242424242436,197.5833333333334,268.50986766012875,1.1098288587933718]
["06-1",2006,1,73,171,12483,5329,6.5,42.25,-91.075757575757564,-591.99242424242414,269.67970585728722,0.63408553289691039]
["06-2",2006,2,74,172,12728,5476,7.5,56.25,-90.075757575757564,-675.56818181818176,270.84954405444557,0.63503891284168068]
["06-3",2006,3,75,210,15750,5625,8.5,72.25,-52.075757575757564,-442.64393939393926,272.01938225160399,0.77200381186720279]
["06-4",2006,4,76,270,20520,5776,9.5,90.25,7.9242424242424363,75.280303030303145,273.1892204487624,0.98832596526494154]
["06-5",2006,5,77,376,28952,5929,10.5,110.25,113.92424242424244,1196.2045454545455,274.35905864592081,1.3704668686928752]
["06-6",2006,6,78,316,24648,6084,11.5,132.25,53.924242424242436,620.12878787878799,275.52889684307922,1.1468851493278038]
["06-7",2006,7,79,270,21330,6241,12.5,156.25,7.9242424242424363,99.053030303030454,276.69873504023764,0.97579051079050472]
["06-8",2006,8,80,222,17760,6400,13.5,182.25,-40.075757575757564,-541.02272727272714,277.86857323739605,0.79893885592572955]
["06-9",2006,9,81,280,22680,6561,14.5,210.25,17.924242424242436,259.90151515151535,279.0384114345544,1.0034460795576565]
["06-10",2006,10,82,250,20500,6724,15.5,240.25,-12.075757575757564,-187.17424242424224,280.20824963171287,0.89219357505920471]
["06-11",2006,11,83,299,24817,6889,16.5,272.25,36.924242424242436,609.25000000000023,281.37808782887123,1.062627165843298]
["06-12",2006,12,84,272,22848,7056,17.5,306.25,9.9242424242424363,173.67424242424264,282.54792602602964,0.96266854202618379]
["07-1",2007,1,85,198,16830,7225,18.5,342.25,-64.075757575757564,-1185.401515151515,283.71776422318806,0.69787663998452443]
["07-2",2007,2,86,203,17458,7396,19.5,380.25,-59.075757575757564,-1151.9772727272725,284.88760242034647,0.7125617200445149]
["07-3",2007,3,87,231,20097,7569,20.5,420.25,-31.075757575757564,-637.05303030303003,286.05744061750488,0.80753012227665255]
["07-4",2007,4,88,282,24816,7744,21.5,462.25,19.924242424242436,428.37121212121235,287.22727881466329,0.98180089705881923]
["07-5",2007,5,89,337,29993,7921,22.5,506.25,74.924242424242436,1685.7954545454547,288.39711701182171,1.1685276312460018]
["07-6",2007,6,90,385,34650,8100,23.5,552.25,122.92424242424244,2888.7196969696975,289.56695520898006,1.3295716001922457]
["07-7",2007,7,91,408,37128,8281,24.5,600.25,145.92424242424244,3575.1439393939395,290.73679340613847,1.4033311546848259]
["07-8",2007,8,92,259,23828,8464,25.5,650.25,-3.0757575757575637,-78.431818181817874,291.90663160329689,0.88727001019964069]
["07-9",2007,9,93,256,23808,8649,26.5,702.25,-6.0757575757575637,-161.00757575757544,293.0764698004553,0.87349216460229895]
["07-10",2007,10,94,326,30644,8836,27.5,756.25,63.924242424242436,1757.916666666667,294.24630799761371,1.107915345543244]
["07-11",2007,11,95,281,26695,9025,28.5,812.25,18.924242424242436,539.34090909090946,295.41614619477212,0.95120054749726723]
["07-12",2007,12,96,386,37056,9216,29.5,870.25,123.92424242424244,3655.765151515152,296.58598439193054,1.3014775488848158]
["08-1",2008,1,97,218,21146,9409,30.5,930.25,-44.075757575757564,-1344.3106060606058,297.75582258908895,0.73214353326297787]
["08-2",2008,2,98,236,23128,9604,31.5,992.25,-26.075757575757564,-821.38636363636328,298.92566078624736,0.78949394769007941]
["08-3",2008,3,99,238,23562,9801,32.5,1056.25,-24.075757575757564,-782.46212121212079,300.09549898340572,0.79308087194323629]
["08-4",2008,4,100,367,36700,10000,33.5,1122.25,104.92424242424244,3514.9621212121215,301.26533718056413,1.2181952408950307]
["08-5",2008,5,101,334,33734,10201,34.5,1190.25,71.924242424242436,2481.386363636364,302.43517537772254,1.1043688935417482]
["08-6",2008,6,102,371,37842,10404,35.5,1260.25,108.92424242424244,3866.8106060606065,303.60501357488096,1.2219824555318048]
["08-7",2008,7,103,348,35844,10609,36.5,1332.25,85.924242424242436,3136.234848484849,304.77485177203937,1.1418264924964725]
["08-8",2008,8,104,352,36608,10816,37.5,1406.25,89.924242424242436,3372.1590909090914,305.94468996919778,1.1505347585389993]
["08-9",2008,9,105,278,29190,11025,38.5,1482.25,15.924242424242436,613.08333333333383,307.11452816635619,0.90519976915391775]
["08-10",2008,10,106,280,29680,11236,39.5,1560.25,17.924242424242436,708.00757575757621,308.28436636351455,0.90825234929311027]
["08-11",2008,11,107,386,41302,11449,40.5,1640.25,123.92424242424244,5018.9318181818189,309.45420456067302,1.24735742578776]
["08-12",2008,12,108,410,44280,11664,41.5,1722.25,147.92424242424244,6138.856060606061,310.62404275783138,1.3199235846648358]
["09-1",2009,1,109,202,22018,11881,42.5,1806.25,-60.075757575757564,-2553.2196969696965,311.79388095498979,0.64786390092485646]
["09-2",2009,2,110,176,19360,12100,43.5,1892.25,-86.075757575757564,-3744.295454545454,312.9637191521482,0.56236550510328354]
["09-3",2009,3,111,201,22311,12321,44.5,1980.25,-61.075757575757564,-2717.8712121212116,314.13355734930661,0.63985523131008359]
["09-4",2009,4,112,335,37520,12544,45.5,2070.25,72.924242424242436,3318.0530303030309,315.30339554646503,1.0624687356106584]
["09-5",2009,5,113,330,37290,12769,46.5,2162.25,67.924242424242436,3158.4772727272734,316.47323374362344,1.0427422126552879]
["09-6",2009,6,114,432,49248,12996,47.5,2256.25,169.92424242424244,8071.4015151515159,317.64307194078185,1.3600170699789029]
["09-7",2009,7,115,410,47150,13225,48.5,2352.25,147.92424242424244,7174.325757575758,318.81291013794021,1.2860206941513317]
["09-8",2009,8,116,297,34452,13456,49.5,2450.25,34.924242424242436,1728.7500000000007,319.98274833509868,0.92817503926483491]
["09-9",2009,9,117,287,33579,13689,50.5,2550.25,24.924242424242436,1258.6742424242429,321.15258653225703,0.89365619968679066]
["09-10",2009,10,118,241,28438,13924,51.5,2652.25,-21.075757575757564,-1085.4015151515146,322.32242472941545,0.74769852020788086]
["09-11",2009,11,119,425,50575,14161,52.5,2756.25,162.92424242424244,8553.5227272727279,323.49226292657386,1.3137872175213858]
["09-12",2009,12,120,346,41520,14400,53.5,2862.25,83.924242424242436,4489.94696969697,324.66210112373227,1.0657234053571767]
["10-1",2010,1,121,188,22748,14641,54.5,2970.25,-74.075757575757564,-4037.1287878787871,325.83193932089068,0.57698456569922396]
["10-2",2010,2,122,180,21960,14884,55.5,3080.25,-82.075757575757564,-4555.204545454545,327.00177751804904,0.55045572340983617]
["10-3",2010,3,123,237,29151,15129,56.5,3192.25,-25.075757575757564,-1416.7803030303023,328.17161571520751,0.72218311593916862]
["10-4",2010,4,124,302,37448,15376,57.5,3306.25,39.924242424242436,2295.6439393939399,329.34145391236586,0.91698143799522691]
["10-5",2010,5,125,427,53375,15625,58.5,3422.25,164.92424242424244,9648.068181818182,330.51129210952433,1.2919377043810696]
["10-6",2010,6,126,414,52164,15876,59.5,3540.25,151.92424242424244,9039.4924242424258,331.68113030668269,1.2481867738969736]
["10-7",2010,7,127,389,49403,16129,60.5,3660.25,126.92424242424244,7678.916666666667,332.8509685038411,1.1686912066038075]
["10-8",2010,8,128,370,47360,16384,61.5,3782.25,107.92424242424244,6637.3409090909099,334.02080670099951,1.1077154254381747]
["10-9",2010,9,129,247,31863,16641,62.5,3906.25,-15.075757575757564,-942.2348484848477,335.19064489815793,0.73689407434102705]
[{"$f":"MID(TEXT(B150,\"####\"),3,2)&\"-\"&TEXT(C150,\"##\")","v":"10-10"},2010,10,130,306,{"$f":"D150*E150","v":39780},{"$f":"D150*D150","v":16900},{"$f":"D150-$D$155","v":63.5},{"$f":"H150*H150","v":4032.25},{"$f":" E150-$D$156","v":43.924242424242436},{"$f":"H150*J150","v":2789.1893939393949},{"$f":"$H$160+D150*$H$159","v":336.36048309531634},{"$f":"E150/L150","v":0.90973825814516707}]
["10-11",2010,11,131,514,67334,17161,64.5,4160.25,251.92424242424244,16249.113636363638,337.5303212924747,1.5228261509418939]
["10-12",2010,12,132,420,55440,17424,65.5,4290.25,157.92424242424244,10344.03787878788,338.70015948963317,1.2400348456666588]
[null,"PART 1.","sumX",{"$f":"SUM(D21:D152)","v":8778}]
[null,"COMP.","sumY",{"$f":"SUM(E21:E152)","v":34594},null,"PART 2.","slope:","(X-Xb)(Y-Yb)","div by","X-Xbar SQD"]
[null,"FORM","aveX",{"$f":"AVERAGE(D21:D152)","v":66.5},null,"TRAD.",null,{"$f":"SUM(K21:K152)","v":224203},null,{"$f":"SUM(I21:I152)","v":191653},{"$f":"H155/J155","v":1.169838197158406}]
[null,null,"aveY",{"$f":"AVERAGE(E21:E152)","v":262.07575757575756},null,"FORM"]
[null,null,"sumXY",{"$f":"SUM(F21:F152)","v":2524704},null,null,"intercept:","ybar","-","M * Xbar",{"$f":"D156-K155*D155","v":184.28151746472355}]
[null,null,"sumX2",{"$f":"SUM(G21:G152)","v":775390},null,"PART 5. SLOPE and INTERCEPT"]
[null,null,"n",{"$f":"COUNT(E21:E152)","v":132},null,"Excel slope",null,{"$f":"SLOPE(E21:E152,D21:D152)","v":1.169838197158406}]
[null,"slope numerator",null,{"$f":"( D159*D157-D153*D154)","v":29594796},null,"Excel Intercept",null,{"$f":"INTERCEPT(E21:E152,D21:D152)","v":184.28151746472355}]
[null,"slope denominator",null,{"$f":"(D159*D158-D153*D153)","v":25298196},null,null,null," "]
[" ",null,"slope",{"$f":"D160/D161","v":1.169838197158406}]
[null,null,"intercept",{"$f":"(D154-D162*D153)/D159","v":184.28151746472355}]
[]
[null,"Part 3. LINEST (full)",null,null,null,null,null,null," "]
[null,null,"slope -->",{"$f":"INDEX(LINEST(E21:E152,D21:D152,,TRUE),1,1)","v":1.1698381971584062},{"$f":"INDEX(LINEST(E21:E152,D21:D152,,TRUE),1,2)","v":184.28151746472355},"<-- intercept"]
[null,null," ",{"$f":"INDEX(LINEST(E21:E152,D21:D152,,TRUE),2,1)","v":0.1494524713173804},{"$f":"INDEX(LINEST(E21:E152,D21:D152,,TRUE),2,2)","v":11.454502546235828},null,null,null," "]
[null,null,null,{"$f":"INDEX(LINEST(E21:E152,D21:D152,,TRUE),3,1)","v":0.32033126765452713},{"$f":"INDEX(LINEST(E21:E152,D21:D152,,TRUE),3,2)","v":65.427588224089746}]
[null,null,null,{"$f":"INDEX(LINEST(E21:E152,D21:D152,,TRUE),4,1)","v":61.269649188336544},{"$f":"INDEX(LINEST(E21:E152,D21:D152,,TRUE),4,2)","v":130},"<--d.f"]
[null,null,null,{"$f":"INDEX(LINEST(E21:E152,D21:D152,,TRUE),5,1)","v":262281.23331750627},{"$f":"INDEX(LINEST(E21:E152,D21:D152,,TRUE),5,2)","v":556500.00910673616}]
[null,"PART 4. LINEST Direct"]
[null,null,"slope",{"$f":"INDEX(LINEST(E21:E152,D21:D152,,FALSE),1)","v":1.1698381971584062}]
[null,null,"int",{"$f":"INDEX(LINEST(E21:E152,D21:D152,,FALSE),2)","v":184.28151746472355}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Graph from VBA"]
[null,null,null,"DATA VALUES TO SET:"]
[null,null,null,"ACTUAL Y AND TREND (using VBA)"]
[null,null,null,"TIME"]
[null,null,null,"Y VALUES"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}