{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Trendline"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":1,"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":"Trendline","index":0,"n_rows":42,"n_cols":18,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Instructions"]
[null,"Copy the trendline module over to your workbook"]
[null,"Copy the equation of thetrendline from the graph and paste it into a cell"]
[null,"then just use"]
[null,null,"=TrendlineParse( Equation , month_number )"]
[null,"it will automatically detect the type and display the correct results except for a 'Power' trendline where you have have to use"]
[null,null,"=TrendlineParse( Equation , month_number , \"power\" )"]
[]
[]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
["Data",75.062346859947596,173.33850853296244,52.765024588390474,208.03198577388605,420.38481336874599,395.38825976401279,544.80924339875435,759.13880223946762,899.57089777335307,349.28276279356908,245.91140089203211,523.451694436352,398.9157563659216,1089.4463705004898,776.87375512277288]
["exp",{"$f":"trendlineparse($R13,B$11)","v":128.62003113280548},148.28892442276666,170.96563352372249,197.1101210690301,227.25268831561229,262.00473150024914,302.07114308447808,348.26460942853805,401.52209490097613,462.92384677906796,533.71530642561652,615.33237117710303,709.43051934225537,817.91838906743658,942.99649216518276,null,"y = 111.56e0.1423x"]
["log",-40.39,146.39930221729406,255.66403955028224,333.18860443458811,393.32132864274138,442.45334176757626,483.99386696742584,519.97790665188222,551.71807910056452,580.11063086003549,605.79481811370499,629.24264398487037,650.81255284873498,670.7831691847199,689.37536819302363,null,"y = 269.48ln(x) - 40.39"]
["Power",{"$f":"trendlineparse($R15,B$11,\"Power\")","v":67.424000000000007},124.25760258052284,177.6787378796341,228.9978612817269,278.808530714146,327.44918721013977,375.13793653173769,422.02665577442036,468.22695026251364,513.8241517195338,558.88552576968004,603.46539762803695,647.60851541273951,691.35234679695736,734.72869968208158,null,"y = 67.424x0.8827"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
["Data",75.062346859947596,173.33850853296244,52.765024588390474,208.03198577388605,420.38481336874599,395.38825976401279,544.80924339875435,759.13880223946762,899.57089777335307,349.28276279356908,245.91140089203211,523.451694436352,398.9157563659216,1089.4463705004898,776.87375512277288]
["poly1",{"$f":"trendlineparse($R37,B$11)","v":132.30200000000002},179.23400000000001,226.166,273.09800000000001,320.03000000000003,366.96199999999999,413.89400000000001,460.82600000000002,507.75800000000004,554.69000000000005,601.62200000000007,648.55399999999997,695.48599999999999,742.41800000000001,789.35,null,"y = 46.932x + 85.371"]
["poly2",70.4619,143.89680000000001,213.25430000000003,278.53440000000001,339.7371,396.86240000000004,449.91029999999995,498.88079999999997,543.77390000000003,584.58960000000002,621.32790000000011,653.9888000000002,682.57230000000004,707.07839999999999,727.50710000000015,null,"y = -2.0387x2 + 79.551x - 7.0504"]
["poly3",-40.917100000000005,127.9812,256.08429999999998,349.51160000000004,414.38249999999994,456.81640000000016,482.93269999999995,498.85080000000016,510.69010000000003,524.57000000000016,546.60990000000015,582.92920000000049,639.64730000000054,722.88359999999966,838.75750000000016,null,"y = 1.0199x3 - 26.517x2 + 241.31x - 256.73"]
["poly4",97.698900000000037,68.582400000000064,135.76090000000011,252.03840000000037,379.91250000000014,491.57440000000042,568.90890000000059,603.4944000000005,596.60290000000259,559.20000000000027,511.94490000000224,485.19040000000041,518.98289999999906,663.06240000000116,976.86250000000018,null,"y = 0.4039x4 - 11.905x3 + 109.48x2 - 280.28x + 280"]
["poly5",157.86500000000001,-0.16959999999983211,76.922800000000166,249.39920000000018,425.07500000000016,551.75200000000075,609.64640000000088,603.81680000000267,556.59220000000221,500.00000000000034,468.19400000000894,489.8824000000044,580.75580000000116,735.91520000002163,922.30000000000143,null,"y = -0.0631x5 + 2.9281x4 - 48.47x3 + 340.86x2 - 883.29x + 745.9"]
["poly6",57.506200000000263,200.7176000000004,115.79120000000012,126.31600000000299,287.52500000000373,517.71920000000182,698.80360000001974,745.93520000001308,646.28300000004538,466.90000000001464,331.7072000000976,367.58960000001252,619.60420000018212,935.3000000002562,818.15000000026203,null,"y = -0.0429x6 + 1.9961x5 - 35.117x4 + 290.37x3 - 1145.1x2 + 2013.5x - 1068.1"]