{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Title","Sheet1","Method1","Method2","Wrap Up"],"not_rendered":{"charts":0,"images":6,"macros":0,"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":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2100]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: Leks2 / Pixabay"]

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

{"sheet":"Method1","index":2,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Straight-Line Regression with Fill Handle"]
[]
["Year","Sales","Forecast",null,null,"Slope","Y-Intercept"]
[2008,99000,{"$f":"$G$4+$F$4*ROW(1:1)","v":100701.81818181818},null,null,{"$f":"LINEST(B4:B13)","v":4831.818181818182},95870]
[2009,108150,{"$f":"$G$4+$F$4*ROW(2:2)","v":105533.63636363637},null,null,"Use Ctrl+Shift+Enter"]
[2010,110000,110365.45454545454]
[2011,117300,115197.27272727274]
[2012,115200,120029.09090909091]
[2013,122500,124860.90909090909]
[2014,135200,129692.72727272726]
[2015,137700,134524.54545454547]
[2016,134400,139356.36363636365]
[2017,145000,144188.18181818182]
[2018,149020,149020]
[2019,153851.818181818,153851.81818181818]
[2020,158683.636363636,158683.63636363635]
[2021,163515.454545455,163515.45454545453]
[2022,168347.272727273,168347.27272727274]
[2023,173179.090909091,173179.09090909091]

{"sheet":"Method2","index":3,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Interpolation with the Fill Series dialog"]
[]
["Year","Sales","Interpolation"]
[2008,99000,99000,null,"Distance to Bridge",{"$f":"B19-B4","v":74179.090909090999}]
[2009,{"$f":"B4+$F$7","v":103945.27272727274},103945.26666666666,null,"# of Cells",{"$f":"COUNT(A4:A19)","v":16}]
[2010,{"$f":"B5+$F$7","v":108890.54545454547},108890.53333333334,null,"# of Steps",{"$f":"F5-1","v":15}]
[2011,113835.81818181821,113835.80000000002,null,"Each Step",{"$f":"F4/F6","v":4945.2727272727334}]
[2012,118781.09090909094,118781.06666666668]
[2013,123726.36363636368,123726.33333333334]
[2014,128671.63636363641,128671.60000000002]
[2015,133616.90909090915,133616.8666666667]
[2016,138562.18181818188,138562.13333333336]
[2017,143507.45454545462,143507.40000000002]
[2018,148452.72727272735,148452.66666666669]
[2019,153398.00000000009,153397.93333333338]
[2020,158343.27272727282,158343.20000000004]
[2021,163288.54545454556,163288.4666666667]
[2022,168233.81818181829,168233.7333333334]
[2023,173179.090909091,173179.00000000006]

{"sheet":"Wrap Up","index":4,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"A cool trick from Bob Umlas for our 2000th podcast episde"]
[null,"Fast Motion version of Straight Line Regression"]
[null,"All of those steps can be replicated with the fill handle"]
[null,"Fast motion version of interpolation"]
[null,"Select first, last, and blank cells. Go to Home, Fill, Series"]
[null,"The Fill Series dialog will give you the correct steps"]