{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["MC Forecasting","MC + Macros"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"MC Forecasting","index":0,"n_rows":110,"n_cols":16,"rows_kept":110,"cut":false,"hidden":false,"merged":[]}
[]
["Time","2014 Q1","2014 Q2","2014 Q3","2014 Q4","2015 Q1","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3"]
["Sales",400,410,440,420,430,450,480,490,520,490,480,500,550,520,540]
[]
["Growth"]
["Average Growth Rate"]
["Std Dev of Growth"]
[]
["Scenario One - Model based only on past information",null,null,null,null,null,"Trail Runs",null,null,null,null,null,"MC Chart"]
[null,null,null,null,null,null,null,null,null,"Average",null,null,"Sigma","Values","Count","Percentage"]
["Latest Period Data",null,null,null,null,null,1,null,null,"Std Dev",null,null,-3]
["Randomized Growth",null,null,null,null,null,2,null,null,null,null,null,-2.5]
["Monte Carlo Prediction",null,null,null,null,null,3,null,null,null,null,null,-2]
[null,null,null,null,null,null,4,null,null,null,null,null,-1.5]
[null,null,null,null,null,null,5,null,null,null,null,null,-1]
[null,null,null,null,null,null,6,null,null,null,null,null,-0.5]
[null,null,null,null,null,null,7,null,null,null,null,null,0]
[null,null,null,null,null,null,8,null,null,null,null,null,0.5]
[null,null,null,null,null,null,9,null,null,null,null,null,1]
[null,null,null,null,null,null,10,null,null,null,null,null,1.5]
[null,null,null,null,null,null,11,null,null,null,null,null,2]
[null,null,null,null,null,null,12,null,null,null,null,null,2.5]
[null,null,null,null,null,null,13,null,null,null,null,null,3]
[null,null,null,null,null,null,14]
[null,null,null,null,null,null,15]
[null,null,null,null,null,null,16]
[null,null,null,null,null,null,17]
[null,null,null,null,null,null,18]
[null,null,null,null,null,null,19]
[null,null,null,null,null,null,20]
[null,null,null,null,null,null,21]
[null,null,null,null,null,null,22]
[null,null,null,null,null,null,23]
[null,null,null,null,null,null,24]
[null,null,null,null,null,null,25]
[null,null,null,null,null,null,26]
[null,null,null,null,null,null,27]
[null,null,null,null,null,null,28]
[null,null,null,null,null,null,29]
[null,null,null,null,null,null,30]
[null,null,null,null,null,null,31]
[null,null,null,null,null,null,32]
[null,null,null,null,null,null,33]
[null,null,null,null,null,null,34]
[null,null,null,null,null,null,35]
[null,null,null,null,null,null,36]
[null,null,null,null,null,null,37]
[null,null,null,null,null,null,38]
[null,null,null,null,null,null,39]
[null,null,null,null,null,null,40]
[null,null,null,null,null,null,41]
[null,null,null,null,null,null,42]
[null,null,null,null,null,null,43]
[null,null,null,null,null,null,44]
[null,null,null,null,null,null,45]
[null,null,null,null,null,null,46]
[null,null,null,null,null,null,47]
[null,null,null,null,null,null,48]
[null,null,null,null,null,null,49]
[null,null,null,null,null,null,50]
[null,null,null,null,null,null,51]
[null,null,null,null,null,null,52]
[null,null,null,null,null,null,53]
[null,null,null,null,null,null,54]
[null,null,null,null,null,null,55]
[null,null,null,null,null,null,56]
[null,null,null,null,null,null,57]
[null,null,null,null,null,null,58]
[null,null,null,null,null,null,59]
[null,null,null,null,null,null,60]
[null,null,null,null,null,null,61]
[null,null,null,null,null,null,62]
[null,null,null,null,null,null,63]
[null,null,null,null,null,null,64]
[null,null,null,null,null,null,65]
[null,null,null,null,null,null,66]
[null,null,null,null,null,null,67]
[null,null,null,null,null,null,68]
[null,null,null,null,null,null,69]
[null,null,null,null,null,null,70]
[null,null,null,null,null,null,71]
[null,null,null,null,null,null,72]
[null,null,null,null,null,null,73]
[null,null,null,null,null,null,74]
[null,null,null,null,null,null,75]
[null,null,null,null,null,null,76]
[null,null,null,null,null,null,77]
[null,null,null,null,null,null,78]
[null,null,null,null,null,null,79]
[null,null,null,null,null,null,80]
[null,null,null,null,null,null,81]
[null,null,null,null,null,null,82]
[null,null,null,null,null,null,83]
[null,null,null,null,null,null,84]
[null,null,null,null,null,null,85]
[null,null,null,null,null,null,86]
[null,null,null,null,null,null,87]
[null,null,null,null,null,null,88]
[null,null,null,null,null,null,89]
[null,null,null,null,null,null,90]
[null,null,null,null,null,null,91]
[null,null,null,null,null,null,92]
[null,null,null,null,null,null,93]
[null,null,null,null,null,null,94]
[null,null,null,null,null,null,95]
[null,null,null,null,null,null,96]
[null,null,null,null,null,null,97]
[null,null,null,null,null,null,98]
[null,null,null,null,null,null,99]
[null,null,null,null,null,null,100]

{"sheet":"MC + Macros","index":1,"n_rows":110,"n_cols":16,"rows_kept":110,"cut":false,"hidden":false,"merged":[]}
[]
["Time","2014 Q1","2014 Q2","2014 Q3","2014 Q4","2015 Q1","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3"]
["Sales",400,410,440,420,430,450,480,490,520,490,480,500,550,520,540]
[]
["Growth",null,{"$f":"(C3-B3)/B3","v":2.5000000000000001E-2},{"$f":"(D3-C3)/C3","v":7.3170731707317069E-2},-4.5454545454545456E-2,2.3809523809523808E-2,4.6511627906976744E-2,6.6666666666666666E-2,2.0833333333333332E-2,6.1224489795918366E-2,-5.7692307692307696E-2,-2.0408163265306121E-2,4.1666666666666664E-2,0.1,-5.4545454545454543E-2,3.8461538461538464E-2]
["Average Growth Rate",null,{"$f":"AVERAGE(C5:P5)","v":2.2803150527880518E-2}]
["Std Dev of Growth",null,{"$f":"_xlfn.STDEV.P(C5:P5)","v":4.7852406067978713E-2}]
[]
["Scenario One - Model based only on past information",null,null,null,null,null,"Trail Runs",null,null,null,null,null,"MC Chart"]
[null,null,null,null,null,null,null,{"$f":"C13","v":607.69014435078088},null,"Average",{"$f":"AVERAGE(H11:H110)","v":583.74653027950694},null,"Sigma","Values","Count","Percentage"]
["Latest Period Data",null,{"$f":"Latest_Period","v":540},null,null,null,1,569.58405206014106,null,"Std Dev",{"$f":"_xlfn.STDEV.S(H11:H110)","v":28.534927644385199},null,-3,{"$f":"$K$10+(M11*$K$11)","v":498.14174734635134},{"$f":"FREQUENCY(H11:H110,N11:N23)","v":0},{"$f":"O11/$O$24","v":0}]
["Randomized Growth",null,{"$f":"C6+(C7*_xlfn.NORM.S.INV(RAND()))","v":6.9234961595100841E-2},null,null,null,2,560.60143449218879,null,null,null,null,-2.5,{"$f":"$K$10+(M12*$K$11)","v":512.40921116854395},0,{"$f":"O12/$O$24","v":0}]
["Monte Carlo Prediction",null,{"$f":"C11*(1+C12)*(1+E18)","v":607.69014435078088},null,null,null,3,589.82232430299416,null,null,null,null,-2,526.6766749907365,2,0.02]
[null,null,null,null,null,null,4,555.08599514200046,null,null,null,null,-1.5,540.94413881292917,4,0.04]
["Other Factors",null,"Mean","Sigma","Random Rate",null,5,555.67811013495225,null,null,null,null,-1,555.21160263512172,13,0.13]
["Market Growth",null,0.1,0.05,{"$f":"C16+(D16*_xlfn.NORM.S.INV(RAND()))","v":0.12804206030581491},null,6,570.64634044519778,null,null,null,null,-0.5,569.47906645731439,10,0.1]
["Loss due to Competiton",null,-0.2,7.0000000000000007E-2,{"$f":"C17+(D17*_xlfn.NORM.S.INV(RAND()))","v":-0.26741236224524867},null,7,580.26381899595697,null,null,null,null,0,583.74653027950694,18,0.18]
["New Technology",null,0.05,0.02,{"$f":"C18+(D18*_xlfn.NORM.S.INV(RAND()))","v":5.2483466767019572E-2},null,8,571.55389385789226,null,null,null,null,0.5,598.0139941016995,19,0.19]
[null,null,null,null,null,null,9,601.3585040953044,null,null,null,null,1,612.28145792389216,19,0.19]
[null,null,null,null,null,null,10,544.58275889597894,null,null,null,null,1.5,626.54892174608472,9,0.09]
[null,null,null,null,null,null,11,636.79619205869403,null,null,null,null,2,640.81638556827738,4,0.04]
[null,null,null,null,null,null,12,570.10149092766153,null,null,null,null,2.5,655.08384939046994,1,0.01]
[null,null,null,null,null,null,13,524.98348297789414,null,null,null,null,3,669.35131321266249,1,0.01]
[null,null,null,null,null,null,14,588.09318026490178,null,null,null,null,null,"Total",{"$f":"SUM(O11:O23)","v":100}]
[null,null,null,null,null,null,15,614.47390166590355]
[null,null,null,null,null,null,16,559.17596805627738]
[null,null,null,null,null,null,17,537.65554202256317]
[null,null,null,null,null,null,18,596.95435820422063]
[null,null,null,null,null,null,19,601.9602087789732]
[null,null,null,null,null,null,20,571.86703995262872]
[null,null,null,null,null,null,21,570.48312178763456]
[null,null,null,null,null,null,22,550.10744460448279]
[null,null,null,null,null,null,23,544.30905033106035]
[null,null,null,null,null,null,24,544.6722922790716]
[null,null,null,null,null,null,25,588.68679051767845]
[null,null,null,null,null,null,26,573.4942846181965]
[null,null,null,null,null,null,27,612.65765748066815]
[null,null,null,null,null,null,28,591.58056092247432]
[null,null,null,null,null,null,29,583.15814047289086]
[null,null,null,null,null,null,30,613.79828384312862]
[null,null,null,null,null,null,31,583.90950207266042]
[null,null,null,null,null,null,32,574.98749677808439]
[null,null,null,null,null,null,33,656.98091097978693]
[null,null,null,null,null,null,34,608.45154490584343]
[null,null,null,null,null,null,35,562.89426578437588]
[null,null,null,null,null,null,36,602.31873532473901]
[null,null,null,null,null,null,37,546.44428681573788]
[null,null,null,null,null,null,38,537.54419383187485]
[null,null,null,null,null,null,39,616.66562395542587]
[null,null,null,null,null,null,40,612.04154555232628]
[null,null,null,null,null,null,41,546.33894521892933]
[null,null,null,null,null,null,42,602.88700391543227]
[null,null,null,null,null,null,43,594.93316528994649]
[null,null,null,null,null,null,44,584.32040363214469]
[null,null,null,null,null,null,45,598.95344214435374]
[null,null,null,null,null,null,46,603.26646466540728]
[null,null,null,null,null,null,47,632.70952334451817]
[null,null,null,null,null,null,48,608.40241579638905]
[null,null,null,null,null,null,49,533.82721705406129]
[null,null,null,null,null,null,50,588.7493245052425]
[null,null,null,null,null,null,51,591.04185297313211]
[null,null,null,null,null,null,52,599.48948776230839]
[null,null,null,null,null,null,53,606.65378596739936]
[null,null,null,null,null,null,54,605.36795654072182]
[null,null,null,null,null,null,55,624.88825727071367]
[null,null,null,null,null,null,56,615.6807763716813]
[null,null,null,null,null,null,57,539.3272665333767]
[null,null,null,null,null,null,58,590.67513999053222]
[null,null,null,null,null,null,59,607.48271171527256]
[null,null,null,null,null,null,60,612.03160524748284]
[null,null,null,null,null,null,61,569.4340949090697]
[null,null,null,null,null,null,62,589.38229042114949]
[null,null,null,null,null,null,63,541.94758358699437]
[null,null,null,null,null,null,64,549.21379142594503]
[null,null,null,null,null,null,65,611.50110152461968]
[null,null,null,null,null,null,66,591.0314417151485]
[null,null,null,null,null,null,67,621.38993272202231]
[null,null,null,null,null,null,68,646.09228040339951]
[null,null,null,null,null,null,69,578.50688478589245]
[null,null,null,null,null,null,70,580.62819597013618]
[null,null,null,null,null,null,71,560.72405465123393]
[null,null,null,null,null,null,72,577.98386974570099]
[null,null,null,null,null,null,73,630.23273015308393]
[null,null,null,null,null,null,74,585.69234596338504]
[null,null,null,null,null,null,75,551.16259122018107]
[null,null,null,null,null,null,76,600.61298720379307]
[null,null,null,null,null,null,77,584.30320238231275]
[null,null,null,null,null,null,78,572.74123729626456]
[null,null,null,null,null,null,79,609.52272276539838]
[null,null,null,null,null,null,80,618.38831115303663]
[null,null,null,null,null,null,81,609.60705552809372]
[null,null,null,null,null,null,82,569.47364562135556]
[null,null,null,null,null,null,83,542.30481829135533]
[null,null,null,null,null,null,84,561.18325371641504]
[null,null,null,null,null,null,85,582.35297863183894]
[null,null,null,null,null,null,86,560.02300515587137]
[null,null,null,null,null,null,87,586.68808692798825]
[null,null,null,null,null,null,88,575.26083914049912]
[null,null,null,null,null,null,89,547.69428420973986]
[null,null,null,null,null,null,90,575.11293415049897]
[null,null,null,null,null,null,91,572.7364570735615]
[null,null,null,null,null,null,92,634.76271158266729]
[null,null,null,null,null,null,93,564.77743425728954]
[null,null,null,null,null,null,94,615.14404093695111]
[null,null,null,null,null,null,95,589.20815499311334]
[null,null,null,null,null,null,96,593.68179071550571]
[null,null,null,null,null,null,97,588.10767123169671]
[null,null,null,null,null,null,98,519.09386325455182]
[null,null,null,null,null,null,99,610.42551423260011]
[null,null,null,null,null,null,100,543.07176217083759]