{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dashboard","Microsoft","Apple","Google","Amazon","Control"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":11,"defined_names":472,"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":"Dashboard","index":0,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Revenue"]
["Cost Of Services"]
["Gross Profit"]
["Admin Expenses"]
["Selling & Marketing"]
["Depreciation"]
["Impairment loss"]
["Operating expenses"]
["Operating income"]
["Finance Cost"]
["Net income"]
[]
[]
["Monthly "]
["Quarterly"]
["Yearly",null,null,"Microsoft","Apple","Google","Amazon"]

{"sheet":"Microsoft","index":1,"n_rows":14,"n_cols":39,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,2013,2013,2013,2013,2014,2014,2014,2014,2013,2013,2013,2013,2013,2013,2013,2013,2013,2013,2013,2013,2014,2014,2014,2014,2014,2014,2014,2014,2014,2014,2014,2014]
[null,null,null,null,null,null,null,"Q1","Q2","Q3","Q4","Q1","Q2","Q3","Q4","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,2009,2010,2011,2012,2013,2014,{"$f":"H2&CHAR(10)&H1","v":"Q1\n2013"},{"$f":"I2&CHAR(10)&I1","v":"Q2\n2013"},"Q3\n2013","Q4\n2013","Q1\n2014","Q2\n2014","Q3\n2014","Q4\n2014","Jan\n2013","Feb\n2013","Mar\n2013","Apr\n2013","May\n2013","Jun\n2013","Jul\n2013","Aug\n2013","Sep\n2013","Oct\n2013","Nov\n2013","Dec\n2013","Jan\n2014","Feb\n2014","Mar\n2014","Apr\n2014","May\n2014","Jun\n2014","Jul\n2014","Aug\n2014","Sep\n2014","Oct\n2014","Nov\n2014","Dec\n2014"]
["Revenue",602,{"$f":"B4*RANDBETWEEN(9,10)/7.5","v":722.4},{"$f":"C4*RANDBETWEEN(9,10)/7.5","v":963.2},1284.2666666666667,1541.12,2054.8266666666664,{"$f":"AVERAGE(B4:C4)/4","v":165.55},{"$f":"AVERAGE(C4:D4)/4","v":210.7},280.93333333333334,353.17333333333329,449.49333333333328,{"$f":"AVERAGE(B4:E4)/4","v":223.24166666666667},{"$f":"AVERAGE(E4:G4)/4","v":406.68444444444441},{"$f":"AVERAGE(B4:G4)/4","v":298.6588888888889},{"$f":"AVERAGE(B4:C4)/12","v":55.183333333333337},{"$f":"AVERAGE(C4:D4)/12","v":70.233333333333334},93.644444444444446,117.72444444444443,149.83111111111108,{"$f":"AVERAGE(H4:I4)/4","v":47.03125},{"$f":"AVERAGE(I4:J4)/4","v":61.454166666666666},{"$f":"AVERAGE(J4:K4)/4","v":79.263333333333321},100.33333333333331,{"$f":"AVERAGE(L4:M4)/4","v":84.091874999999987},{"$f":"AVERAGE(M4:N4)/4","v":78.740763888888893},{"$f":"AVERAGE(N4:O4)/4","v":88.167916666666656},{"$f":"P4*RANDBETWEEN(9,10)/10","v":49.665000000000006},{"$f":"Q4*RANDBETWEEN(9,10)/10","v":70.233333333333334},93.644444444444446,105.952,134.84799999999998,42.328125,55.308749999999996,71.336999999999989,100.33333333333331,84.091874999999987,70.866687499999998,88.167916666666656]
["Cost Of Services",{"$f":"B4*30%","v":180.6},{"$f":"C4*30%","v":216.72},288.95999999999998,385.28,462.33599999999996,616.44799999999987,49.664999999999999,63.209999999999994,84.28,105.95199999999998,134.84799999999998,66.972499999999997,122.00533333333331,89.597666666666669,16.555,21.07,28.093333333333334,35.31733333333333,44.949333333333321,14.109375,18.436249999999998,23.778999999999996,30.099999999999994,25.227562499999994,23.622229166666667,26.450374999999998,14.899500000000002,21.07,28.093333333333334,31.785599999999999,40.454399999999993,12.698437499999999,16.592624999999998,21.401099999999996,30.099999999999994,25.227562499999994,21.26000625,26.450374999999998]
["Gross Profit",{"$f":"B4-B5","v":421.4},{"$f":"C4-C5","v":505.67999999999995},674.24,898.98666666666668,1078.7839999999999,1438.3786666666665,115.88500000000002,147.49,196.65333333333334,247.22133333333329,314.64533333333327,156.26916666666668,284.67911111111107,209.06122222222223,38.628333333333337,49.163333333333334,65.551111111111112,82.407111111111107,104.88177777777776,32.921875,43.017916666666665,55.484333333333325,70.23333333333332,58.864312499999997,55.118534722222222,61.717541666666662,34.765500000000003,49.163333333333334,65.551111111111112,74.166399999999996,94.393599999999992,29.629687500000003,38.716124999999998,49.93589999999999,70.23333333333332,58.864312499999997,49.606681249999994,61.717541666666662]
["Admin Expenses",{"$f":"B$4*11%","v":66.22},{"$f":"C$4*11%","v":79.463999999999999},105.95200000000001,141.26933333333332,169.5232,226.03093333333331,18.2105,23.177,30.902666666666669,38.849066666666666,49.444266666666664,24.556583333333336,44.735288888888888,32.852477777777779,6.0701666666666672,7.7256666666666671,10.300888888888888,12.949688888888888,16.481422222222218,5.1734375000000004,6.7599583333333335,8.718966666666665,11.036666666666665,9.2501062499999982,8.661484027777778,9.6984708333333316,5.4631500000000006,7.7256666666666671,10.300888888888888,11.654719999999999,14.833279999999998,4.6560937500000001,6.0839624999999993,7.8470699999999987,11.036666666666665,9.2501062499999982,7.7953356249999999,9.6984708333333316]
["Selling & Marketing",{"$f":"B$4*7%","v":42.14},{"$f":"C$4*5%","v":36.119999999999997},48.160000000000004,64.213333333333338,77.055999999999997,102.74133333333333,{"$f":"H$4*7%","v":11.588500000000002},10.535,14.046666666666667,17.658666666666665,22.474666666666664,11.162083333333335,{"$f":"N$4*7%","v":28.467911111111111},14.932944444444445,2.7591666666666672,3.5116666666666667,4.6822222222222223,{"$f":"S$4*5%","v":5.886222222222222},7.4915555555555544,2.3515625,3.0727083333333334,3.9631666666666661,5.0166666666666657,4.2045937499999999,3.9370381944444448,4.4083958333333326,2.4832500000000004,3.5116666666666667,4.6822222222222223,5.2976000000000001,6.7423999999999999,2.1164062500000003,2.7654375,3.5668499999999996,5.0166666666666657,4.2045937499999999,3.5433343750000001,4.4083958333333326]
["Depreciation",{"$f":"B$4*3%","v":18.059999999999999},36.119999999999997,48.160000000000004,64.213333333333338,77.055999999999997,102.74133333333333,{"$f":"H$4*3%","v":4.9664999999999999},10.535,14.046666666666667,17.658666666666665,22.474666666666664,11.162083333333335,{"$f":"N$4*3%","v":12.200533333333333},14.932944444444445,2.7591666666666672,3.5116666666666667,4.6822222222222223,5.886222222222222,7.4915555555555544,2.3515625,3.0727083333333334,3.9631666666666661,5.0166666666666657,4.2045937499999999,3.9370381944444448,4.4083958333333326,2.4832500000000004,3.5116666666666667,4.6822222222222223,5.2976000000000001,6.7423999999999999,2.1164062500000003,2.7654375,3.5668499999999996,5.0166666666666657,4.2045937499999999,3.5433343750000001,4.4083958333333326]
["Impairment loss",{"$f":"B$4*1%","v":6.0200000000000005},36.119999999999997,48.160000000000004,64.213333333333338,77.055999999999997,102.74133333333333,{"$f":"H$4*1%","v":1.6555000000000002},10.535,14.046666666666667,17.658666666666665,22.474666666666664,11.162083333333335,{"$f":"N$4*1%","v":4.0668444444444445},14.932944444444445,2.7591666666666672,3.5116666666666667,4.6822222222222223,5.886222222222222,7.4915555555555544,2.3515625,3.0727083333333334,3.9631666666666661,5.0166666666666657,4.2045937499999999,3.9370381944444448,4.4083958333333326,2.4832500000000004,3.5116666666666667,4.6822222222222223,5.2976000000000001,6.7423999999999999,2.1164062500000003,2.7654375,3.5668499999999996,5.0166666666666657,4.2045937499999999,3.5433343750000001,4.4083958333333326]
["Operating expenses",{"$f":"SUM(B7:B10)","v":132.44},187.82400000000001,250.43200000000002,333.90933333333339,400.69119999999998,534.25493333333327,36.421000000000006,54.781999999999996,73.042666666666662,91.825066666666658,116.86826666666666,58.042833333333341,89.470577777777763,77.651311111111113,14.347666666666669,18.260666666666665,24.347555555555555,30.608355555555555,38.956088888888878,12.228125,15.978083333333332,20.608466666666665,26.086666666666662,21.863887500000001,20.47259861111111,22.923658333333332,12.9129,18.260666666666665,24.347555555555555,27.547519999999999,35.060479999999998,11.005312500000002,14.380275000000001,18.547619999999995,26.086666666666662,21.863887500000001,18.425338750000002,22.923658333333332]
["Operating income",{"$f":"B6-B11","v":288.95999999999998},{"$f":"C6-C11","v":317.85599999999994},423.80799999999999,565.07733333333329,678.0927999999999,904.12373333333323,79.464000000000013,92.708000000000013,123.61066666666667,155.39626666666663,197.7770666666666,98.226333333333343,195.20853333333332,131.40991111111111,24.280666666666669,30.902666666666669,41.203555555555553,51.798755555555552,65.925688888888885,20.693750000000001,27.039833333333334,34.87586666666666,44.146666666666661,37.000424999999993,34.645936111111112,38.793883333333326,21.852600000000002,30.902666666666669,41.203555555555553,46.618879999999997,59.333119999999994,18.624375000000001,24.335849999999997,31.388279999999995,44.146666666666661,37.000424999999993,31.181342499999992,38.793883333333326]
["Finance Cost",{"$f":"B4*12.5%","v":75.25},{"$f":"C4*12.5%","v":90.3},120.4,160.53333333333333,192.64,256.8533333333333,20.693750000000001,26.337499999999999,35.116666666666667,44.146666666666661,56.18666666666666,27.905208333333334,50.835555555555551,37.332361111111112,6.8979166666666671,8.7791666666666668,11.705555555555556,14.715555555555554,18.728888888888886,5.87890625,7.6817708333333332,9.9079166666666652,12.541666666666664,10.511484374999998,9.8425954861111116,11.020989583333332,6.2081250000000008,8.7791666666666668,11.705555555555556,13.244,16.855999999999998,5.291015625,6.9135937499999995,8.9171249999999986,12.541666666666664,10.511484374999998,8.8583359374999997,11.020989583333332]
["Net income",{"$f":"B12-B13","v":213.70999999999998},{"$f":"C12-C13","v":227.55599999999993},303.40800000000002,404.54399999999998,485.45279999999991,647.27039999999988,58.770250000000011,66.370500000000021,88.494,111.24959999999997,141.59039999999993,70.321125000000009,144.37297777777778,94.077550000000002,17.382750000000001,22.1235,29.497999999999998,37.083199999999998,47.196799999999996,14.814843750000001,19.358062500000003,24.967949999999995,31.604999999999997,26.488940624999994,24.803340625000001,27.772893749999994,15.644475000000002,22.1235,29.497999999999998,33.374879999999997,42.477119999999999,13.333359375000001,17.422256249999997,22.471154999999996,31.604999999999997,26.488940624999994,22.323006562499991,27.772893749999994]

{"sheet":"Apple","index":2,"n_rows":14,"n_cols":39,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,2013,2013,2013,2013,2014,2014,2014,2014,2013,2013,2013,2013,2013,2013,2013,2013,2013,2013,2013,2013,2014,2014,2014,2014,2014,2014,2014,2014,2014,2014,2014,2014]
[null,null,null,null,null,null,null,"Q1","Q2","Q3","Q4","Q1","Q2","Q3","Q4","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,2009,2010,2011,2012,2013,2014,{"$f":"H2&CHAR(10)&H1","v":"Q1\n2013"},{"$f":"I2&CHAR(10)&I1","v":"Q2\n2013"},"Q3\n2013","Q4\n2013","Q1\n2014","Q2\n2014","Q3\n2014","Q4\n2014","Jan\n2013","Feb\n2013","Mar\n2013","Apr\n2013","May\n2013","Jun\n2013","Jul\n2013","Aug\n2013","Sep\n2013","Oct\n2013","Nov\n2013","Dec\n2013","Jan\n2014","Feb\n2014","Mar\n2014","Apr\n2014","May\n2014","Jun\n2014","Jul\n2014","Aug\n2014","Sep\n2014","Oct\n2014","Nov\n2014","Dec\n2014"]
["Revenue",300,{"$f":"B4*RANDBETWEEN(9,10)/8.5","v":352.94117647058823},{"$f":"C4*RANDBETWEEN(9,10)/8.5","v":415.2249134948097},439.64990840626911,517.23518636031656,608.51198395331357,{"$f":"AVERAGE(B4:C4)/4","v":81.617647058823536},{"$f":"AVERAGE(C4:D4)/4","v":96.020761245674748},106.85935273763485,119.61063684582321,140.71839628920378,{"$f":"AVERAGE(B4:E4)/4","v":94.238499898229193},{"$f":"AVERAGE(E4:G4)/4","v":130.44975655999158},{"$f":"AVERAGE(B4:G4)/4","v":109.73179869522072},{"$f":"AVERAGE(B4:C4)/12","v":27.205882352941178},{"$f":"AVERAGE(C4:D4)/12","v":32.006920415224918},35.619784245878286,39.870212281941072,46.906132096401258,{"$f":"AVERAGE(H4:I4)/4","v":22.204801038062286},{"$f":"AVERAGE(I4:J4)/4","v":25.3600142479137},{"$f":"AVERAGE(J4:K4)/4","v":28.308748697932259},32.541129141878372,{"$f":"AVERAGE(L4:M4)/4","v":29.36961202342912},{"$f":"AVERAGE(M4:N4)/4","v":28.086032057277599},{"$f":"AVERAGE(N4:O4)/4","v":30.022694406901536},{"$f":"P4*RANDBETWEEN(9,10)/10","v":27.205882352941178},{"$f":"Q4*RANDBETWEEN(9,10)/10","v":32.006920415224918},35.619784245878286,39.870212281941072,42.215518886761132,19.984320934256054,22.824012823122331,28.308748697932259,32.541129141878372,26.432650821086206,25.277428851549839,30.022694406901536]
["Cost Of Services",{"$f":"B4*30%","v":90},{"$f":"C4*30%","v":105.88235294117646},124.5674740484429,131.89497252188073,155.17055590809497,182.55359518599406,24.485294117647062,28.806228373702425,32.057805821290451,35.883191053746962,42.215518886761132,28.271549969468758,39.134926967997473,32.919539608566211,8.1617647058823533,9.6020761245674748,10.685935273763485,11.961063684582321,14.071839628920378,6.6614403114186853,7.6080042743741094,8.4926246093796767,9.7623387425635109,8.8108836070287353,8.4258096171832797,9.0068083220704604,8.1617647058823533,9.6020761245674748,10.685935273763485,11.961063684582321,12.66465566602834,5.9952962802768157,6.8472038469366989,8.4926246093796767,9.7623387425635109,7.9297952463258614,7.5832286554649517,9.0068083220704604]
["Gross Profit",{"$f":"B4-B5","v":210},{"$f":"C4-C5","v":247.05882352941177},290.65743944636677,307.75493588438837,362.06463045222159,425.95838876731955,57.132352941176478,67.214532871972324,74.801546916344392,83.727445792076253,98.50287740244265,65.966949928760442,91.314829591994112,76.812259086654507,19.044117647058826,22.404844290657444,24.933848972114802,27.909148597358751,32.834292467480878,15.5433607266436,17.75200997353959,19.816124088552584,22.778790399314861,20.558728416400385,19.660222440094319,21.015886084831074,19.044117647058826,22.404844290657444,24.933848972114802,27.909148597358751,29.550863220732793,13.989024653979239,15.976808976185632,19.816124088552584,22.778790399314861,18.502855574760346,17.694200196084886,21.015886084831074]
["Admin Expenses",{"$f":"B$4*11%","v":33},{"$f":"C$4*11%","v":38.823529411764703},45.674740484429066,48.3614899246896,56.895870499634825,66.936318234864487,8.9779411764705888,10.562283737024222,11.754528801139834,13.157170053040552,15.479023591812416,10.366234988805211,14.349473221599075,12.07049785647428,2.9926470588235294,3.5207612456747412,3.9181762670466114,4.3857233510135183,5.1596745306041383,2.4425281141868513,2.7896015672705068,3.1139623567725487,3.5795242056066208,3.2306573225772031,3.0894635263005359,3.3024963847591691,2.9926470588235294,3.5207612456747412,3.9181762670466114,4.3857233510135183,4.6437070775437244,2.1982753027681659,2.5106414105434562,3.1139623567725487,3.5795242056066208,2.9075915903194827,2.7805171736704821,3.3024963847591691]
["Selling & Marketing",{"$f":"B$4*7%","v":21.000000000000004},{"$f":"C$4*5%","v":17.647058823529413},20.761245674740486,21.982495420313455,25.861759318015828,30.425599197665679,{"$f":"H$4*7%","v":5.7132352941176476},4.8010380622837374,5.3429676368817427,5.9805318422911604,7.0359198144601898,4.7119249949114597,{"$f":"N$4*7%","v":9.1314829591994116},5.4865899347610361,1.3602941176470589,1.6003460207612461,1.7809892122939144,{"$f":"S$4*5%","v":1.9935106140970538},2.3453066048200628,1.1102400519031144,1.2680007123956851,1.415437434896613,1.6270564570939188,1.4684806011714562,1.4043016028638799,1.5011347203450769,1.3602941176470589,1.6003460207612461,1.7809892122939144,1.9935106140970538,2.1107759443380565,0.99921604671280273,1.1412006411561166,1.415437434896613,1.6270564570939188,1.3216325410543104,1.263871442577492,1.5011347203450769]
["Depreciation",{"$f":"B$4*3%","v":9},17.647058823529413,20.761245674740486,21.982495420313455,25.861759318015828,30.425599197665679,{"$f":"H$4*3%","v":2.4485294117647061},4.8010380622837374,5.3429676368817427,5.9805318422911604,7.0359198144601898,4.7119249949114597,{"$f":"N$4*3%","v":3.9134926967997474},5.4865899347610361,1.3602941176470589,1.6003460207612461,1.7809892122939144,1.9935106140970538,2.3453066048200628,1.1102400519031144,1.2680007123956851,1.415437434896613,1.6270564570939188,1.4684806011714562,1.4043016028638799,1.5011347203450769,1.3602941176470589,1.6003460207612461,1.7809892122939144,1.9935106140970538,2.1107759443380565,0.99921604671280273,1.1412006411561166,1.415437434896613,1.6270564570939188,1.3216325410543104,1.263871442577492,1.5011347203450769]
["Impairment loss",{"$f":"B$4*1%","v":3},17.647058823529413,20.761245674740486,21.982495420313455,25.861759318015828,30.425599197665679,{"$f":"H$4*1%","v":0.81617647058823539},4.8010380622837374,5.3429676368817427,5.9805318422911604,7.0359198144601898,4.7119249949114597,{"$f":"N$4*1%","v":1.3044975655999158},5.4865899347610361,1.3602941176470589,1.6003460207612461,1.7809892122939144,1.9935106140970538,2.3453066048200628,1.1102400519031144,1.2680007123956851,1.415437434896613,1.6270564570939188,1.4684806011714562,1.4043016028638799,1.5011347203450769,1.3602941176470589,1.6003460207612461,1.7809892122939144,1.9935106140970538,2.1107759443380565,0.99921604671280273,1.1412006411561166,1.415437434896613,1.6270564570939188,1.3216325410543104,1.263871442577492,1.5011347203450769]
["Operating expenses",{"$f":"SUM(B7:B10)","v":66},91.764705882352956,107.9584775086505,114.30897618562997,134.48114845368229,158.21311582786151,17.955882352941178,24.965397923875436,27.78343171178506,31.098765579914033,36.586783035192987,24.50200997353959,28.69894644319815,28.530267660757385,7.0735294117647065,8.3217993079584787,9.2611439039283532,10.366255193304681,12.195594345064327,5.7732482698961949,6.5936037044575624,7.3602746614623875,8.460693576888378,7.6360991260915716,7.3023683348921757,7.8059005457943993,7.0735294117647065,8.3217993079584787,9.2611439039283532,10.366255193304681,10.976034910557894,5.1959234429065742,5.9342433340118053,7.3602746614623875,8.460693576888378,6.8724892134824138,6.572131501402958,7.8059005457943993]
["Operating income",{"$f":"B6-B11","v":144},{"$f":"C6-C11","v":155.29411764705881},182.69896193771626,193.4459596987584,227.5834819985393,267.745272939458,39.176470588235304,42.249134948096888,47.018115204559336,52.628680212162223,61.916094367249663,41.464939955220856,62.615883148795959,48.281991425897118,11.97058823529412,14.083044982698965,15.672705068186449,17.54289340405407,20.63869812241655,9.7701124567474054,11.158406269082027,12.455849427090197,14.318096822426483,12.922629290308812,12.357854105202144,13.209985539036674,11.97058823529412,14.083044982698965,15.672705068186449,17.54289340405407,18.574828310174901,8.7931012110726652,10.042565642173827,12.455849427090197,14.318096822426483,11.630366361277932,11.122068694681928,13.209985539036674]
["Finance Cost",{"$f":"B4*12.5%","v":37.5},{"$f":"C4*12.5%","v":44.117647058823529},51.903114186851212,54.956238550783638,64.65439829503957,76.063997994164197,10.202205882352942,12.002595155709344,13.357419092204356,14.951329605727901,17.589799536150473,11.779812487278649,16.306219569998948,13.71647483690259,3.4007352941176472,4.0008650519031148,4.4524730307347857,4.983776535242634,5.8632665120501573,2.7756001297577857,3.1700017809892125,3.5385935872415324,4.0676411427347965,3.67120150292864,3.5107540071596999,3.752836800862692,3.4007352941176472,4.0008650519031148,4.4524730307347857,4.983776535242634,5.2769398608451414,2.4980401167820068,2.8530016028902914,3.5385935872415324,4.0676411427347965,3.3040813526357757,3.1596786064437299,3.752836800862692]
["Net income",{"$f":"B12-B13","v":106.5},{"$f":"C12-C13","v":111.17647058823528},130.79584775086505,138.48972114797476,162.92908370349971,191.68127494529381,28.974264705882362,30.246539792387544,33.660696112354984,37.677350606434324,44.32629483109919,29.685127467942209,46.309663578797014,34.565516588994527,8.5698529411764728,10.082179930795849,11.220232037451662,12.559116868811437,14.775431610366393,6.9945123269896197,7.9884044880928151,8.9172558398486643,10.250455679691687,9.2514277873801731,8.8471000980424428,9.4571487381739825,8.5698529411764728,10.082179930795849,11.220232037451662,12.559116868811437,13.29788844932976,6.2950610942906584,7.1895640392835354,8.9172558398486643,10.250455679691687,8.3262850086421558,7.9623900882381982,9.4571487381739825]

{"sheet":"Google","index":3,"n_rows":14,"n_cols":39,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,2013,2013,2013,2013,2014,2014,2014,2014,2013,2013,2013,2013,2013,2013,2013,2013,2013,2013,2013,2013,2014,2014,2014,2014,2014,2014,2014,2014,2014,2014,2014,2014]
[null,null,null,null,null,null,null,"Q1","Q2","Q3","Q4","Q1","Q2","Q3","Q4","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,2009,2010,2011,2012,2013,2014,{"$f":"H2&CHAR(10)&H1","v":"Q1\n2013"},{"$f":"I2&CHAR(10)&I1","v":"Q2\n2013"},"Q3\n2013","Q4\n2013","Q1\n2014","Q2\n2014","Q3\n2014","Q4\n2014","Jan\n2013","Feb\n2013","Mar\n2013","Apr\n2013","May\n2013","Jun\n2013","Jul\n2013","Aug\n2013","Sep\n2013","Oct\n2013","Nov\n2013","Dec\n2013","Jan\n2014","Feb\n2014","Mar\n2014","Apr\n2014","May\n2014","Jun\n2014","Jul\n2014","Aug\n2014","Sep\n2014","Oct\n2014","Nov\n2014","Dec\n2014"]
["Revenue",1523,{"$f":"B4*RANDBETWEEN(9,10)/7.5","v":2030.6666666666667},{"$f":"C4*RANDBETWEEN(9,10)/7.5","v":2707.5555555555557},3249.0666666666666,3898.8799999999997,5198.5066666666662,{"$f":"AVERAGE(B4:C4)/4","v":444.20833333333337},{"$f":"AVERAGE(C4:D4)/4","v":592.27777777777783},744.57777777777778,893.49333333333334,1137.1733333333332,{"$f":"AVERAGE(B4:E4)/4","v":594.39305555555552},{"$f":"AVERAGE(E4:G4)/4","v":1028.8711111111111},{"$f":"AVERAGE(B4:G4)/4","v":775.31981481481478},{"$f":"AVERAGE(B4:C4)/12","v":148.06944444444446},{"$f":"AVERAGE(C4:D4)/12","v":197.42592592592595},248.1925925925926,297.83111111111111,379.05777777777774,{"$f":"AVERAGE(H4:I4)/4","v":129.56076388888891},{"$f":"AVERAGE(I4:J4)/4","v":167.10694444444445},{"$f":"AVERAGE(J4:K4)/4","v":204.75888888888889},253.83333333333331,{"$f":"AVERAGE(L4:M4)/4","v":216.44579861111109},{"$f":"AVERAGE(M4:N4)/4","v":202.90802083333332},{"$f":"AVERAGE(N4:O4)/4","v":225.52386574074075},{"$f":"P4*RANDBETWEEN(9,10)/10","v":148.06944444444446},{"$f":"Q4*RANDBETWEEN(9,10)/10","v":177.68333333333334},223.37333333333336,268.048,379.05777777777774,116.60468750000003,167.10694444444445,204.75888888888889,228.45,194.80121874999998,202.90802083333332,225.52386574074075]
["Cost Of Services",{"$f":"B4*30%","v":456.9},{"$f":"C4*30%","v":609.20000000000005},812.26666666666665,974.71999999999991,1169.6639999999998,1559.5519999999999,133.26250000000002,177.68333333333334,223.37333333333333,268.048,341.15199999999993,178.31791666666666,308.66133333333329,232.59594444444443,44.420833333333334,59.227777777777781,74.457777777777778,89.349333333333334,113.71733333333331,38.868229166666673,50.132083333333334,61.427666666666667,76.149999999999991,64.93373958333332,60.872406249999997,67.657159722222218,44.420833333333334,53.305,67.012,80.414400000000001,113.71733333333331,34.981406250000006,50.132083333333334,61.427666666666667,68.534999999999997,58.440365624999991,60.872406249999997,67.657159722222218]
["Gross Profit",{"$f":"B4-B5","v":1066.0999999999999},{"$f":"C4-C5","v":1421.4666666666667},1895.288888888889,2274.3466666666668,2729.2159999999999,3638.9546666666665,310.94583333333333,414.59444444444449,521.20444444444445,625.44533333333334,796.02133333333325,416.07513888888889,720.20977777777784,542.72387037037038,103.64861111111112,138.19814814814816,173.73481481481483,208.48177777777778,265.34044444444442,90.692534722222234,116.97486111111112,143.33122222222221,177.68333333333334,151.51205902777775,142.03561458333331,157.86670601851853,103.64861111111112,124.37833333333333,156.36133333333336,187.6336,265.34044444444442,81.623281250000019,116.97486111111112,143.33122222222221,159.91499999999999,136.36085312499998,142.03561458333331,157.86670601851853]
["Admin Expenses",{"$f":"B$4*11%","v":167.53},{"$f":"C$4*11%","v":223.37333333333333},297.83111111111111,357.39733333333334,428.87679999999995,571.83573333333334,48.862916666666671,65.150555555555556,81.903555555555556,98.284266666666667,125.08906666666665,65.383236111111103,113.17582222222222,85.285179629629624,16.287638888888889,21.716851851851853,27.301185185185187,32.761422222222222,41.696355555555549,14.251684027777781,18.381763888888891,22.523477777777778,27.921666666666663,23.809037847222221,22.319882291666666,24.807625231481481,16.287638888888889,19.545166666666667,24.57106666666667,29.485279999999999,41.696355555555549,12.826515625000003,18.381763888888891,22.523477777777778,25.1295,21.428134062499996,22.319882291666666,24.807625231481481]
["Selling & Marketing",{"$f":"B$4*7%","v":106.61000000000001},{"$f":"C$4*5%","v":101.53333333333335},135.37777777777779,162.45333333333335,194.94399999999999,259.9253333333333,{"$f":"H$4*7%","v":31.09458333333334},29.613888888888894,37.228888888888889,44.674666666666667,56.858666666666664,29.719652777777778,{"$f":"N$4*7%","v":72.020977777777787},38.76599074074074,7.4034722222222236,9.8712962962962987,12.409629629629631,{"$f":"S$4*5%","v":14.891555555555556},18.952888888888889,6.4780381944444461,8.3553472222222229,10.237944444444445,12.691666666666666,10.822289930555556,10.145401041666666,11.276193287037039,7.4034722222222236,8.8841666666666672,11.168666666666669,13.4024,18.952888888888889,5.8302343750000016,8.3553472222222229,10.237944444444445,11.422499999999999,9.7400609374999991,10.145401041666666,11.276193287037039]
["Depreciation",{"$f":"B$4*3%","v":45.69},101.53333333333335,135.37777777777779,162.45333333333335,194.94399999999999,259.9253333333333,{"$f":"H$4*3%","v":13.32625},29.613888888888894,37.228888888888889,44.674666666666667,56.858666666666664,29.719652777777778,{"$f":"N$4*3%","v":30.86613333333333},38.76599074074074,7.4034722222222236,9.8712962962962987,12.409629629629631,14.891555555555556,18.952888888888889,6.4780381944444461,8.3553472222222229,10.237944444444445,12.691666666666666,10.822289930555556,10.145401041666666,11.276193287037039,7.4034722222222236,8.8841666666666672,11.168666666666669,13.4024,18.952888888888889,5.8302343750000016,8.3553472222222229,10.237944444444445,11.422499999999999,9.7400609374999991,10.145401041666666,11.276193287037039]
["Impairment loss",{"$f":"B$4*1%","v":15.23},101.53333333333335,135.37777777777779,162.45333333333335,194.94399999999999,259.9253333333333,{"$f":"H$4*1%","v":4.4420833333333336},29.613888888888894,37.228888888888889,44.674666666666667,56.858666666666664,29.719652777777778,{"$f":"N$4*1%","v":10.288711111111111},38.76599074074074,7.4034722222222236,9.8712962962962987,12.409629629629631,14.891555555555556,18.952888888888889,6.4780381944444461,8.3553472222222229,10.237944444444445,12.691666666666666,10.822289930555556,10.145401041666666,11.276193287037039,7.4034722222222236,8.8841666666666672,11.168666666666669,13.4024,18.952888888888889,5.8302343750000016,8.3553472222222229,10.237944444444445,11.422499999999999,9.7400609374999991,10.145401041666666,11.276193287037039]
["Operating expenses",{"$f":"SUM(B7:B10)","v":335.06},527.97333333333336,703.96444444444455,844.75733333333346,1013.7087999999999,1351.6117333333334,97.725833333333341,153.99222222222224,193.59022222222222,232.30826666666667,295.66506666666663,154.54219444444445,226.35164444444442,201.58315185185182,38.49805555555556,51.330740740740751,64.530074074074079,77.436088888888889,98.55502222222222,33.685798611111117,43.447805555555554,53.237311111111111,65.996666666666655,56.275907638888889,52.756085416666664,58.636205092592597,38.49805555555556,46.197666666666663,58.077066666666674,69.692480000000003,98.55502222222222,30.317218750000009,43.447805555555554,53.237311111111111,59.396999999999998,50.648316874999992,52.756085416666664,58.636205092592597]
["Operating income",{"$f":"B6-B11","v":731.04},{"$f":"C6-C11","v":893.49333333333334},1191.3244444444445,1429.5893333333333,1715.5072,2287.3429333333333,213.21999999999997,260.60222222222228,327.61422222222222,393.13706666666667,500.35626666666661,261.53294444444441,493.8581333333334,341.14071851851855,65.15055555555557,86.867407407407413,109.20474074074075,131.04568888888889,166.78542222222219,57.006736111111117,73.527055555555563,90.093911111111098,111.68666666666668,95.236151388888857,89.279529166666649,99.230500925925924,65.15055555555557,78.180666666666667,98.284266666666696,117.94112,166.78542222222219,51.30606250000001,73.527055555555563,90.093911111111098,100.518,85.712536249999985,89.279529166666649,99.230500925925924]
["Finance Cost",{"$f":"B4*12.5%","v":190.375},{"$f":"C4*12.5%","v":253.83333333333334},338.44444444444446,406.13333333333333,487.35999999999996,649.81333333333328,55.526041666666671,74.034722222222229,93.072222222222223,111.68666666666667,142.14666666666665,74.29913194444444,128.60888888888888,96.914976851851847,18.508680555555557,24.678240740740744,31.024074074074075,37.228888888888889,47.382222222222218,16.195095486111114,20.888368055555556,25.594861111111111,31.729166666666664,27.055724826388886,25.363502604166666,28.190483217592593,18.508680555555557,22.210416666666667,27.92166666666667,33.506,47.382222222222218,14.575585937500003,20.888368055555556,25.594861111111111,28.556249999999999,24.350152343749997,25.363502604166666,28.190483217592593]
["Net income",{"$f":"B12-B13","v":540.66499999999996},{"$f":"C12-C13","v":639.66},852.88,1023.456,1228.1472000000001,1637.5296000000001,157.69395833333328,186.56750000000005,234.542,281.4504,358.20959999999997,187.23381249999997,365.24924444444451,244.22574166666669,46.641875000000013,62.189166666666665,78.180666666666667,93.816800000000001,119.40319999999997,40.811640625000003,52.638687500000003,64.499049999999983,79.95750000000001,68.180426562499974,63.916026562499979,71.040017708333323,46.641875000000013,55.97025,70.362600000000029,84.435119999999998,119.40319999999997,36.730476562500009,52.638687500000003,64.499049999999983,71.961749999999995,61.362383906249988,63.916026562499979,71.040017708333323]

{"sheet":"Amazon","index":4,"n_rows":14,"n_cols":39,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,2013,2013,2013,2013,2014,2014,2014,2014,2013,2013,2013,2013,2013,2013,2013,2013,2013,2013,2013,2013,2014,2014,2014,2014,2014,2014,2014,2014,2014,2014,2014,2014]
[null,null,null,null,null,null,null,"Q1","Q2","Q3","Q4","Q1","Q2","Q3","Q4","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,2009,2010,2011,2012,2013,2014,{"$f":"H2&CHAR(10)&H1","v":"Q1\n2013"},{"$f":"I2&CHAR(10)&I1","v":"Q2\n2013"},"Q3\n2013","Q4\n2013","Q1\n2014","Q2\n2014","Q3\n2014","Q4\n2014","Jan\n2013","Feb\n2013","Mar\n2013","Apr\n2013","May\n2013","Jun\n2013","Jul\n2013","Aug\n2013","Sep\n2013","Oct\n2013","Nov\n2013","Dec\n2013","Jan\n2014","Feb\n2014","Mar\n2014","Apr\n2014","May\n2014","Jun\n2014","Jul\n2014","Aug\n2014","Sep\n2014","Oct\n2014","Nov\n2014","Dec\n2014"]
["Revenue",3600,{"$f":"B4*RANDBETWEEN(9,10)/7.5","v":4320},{"$f":"C4*RANDBETWEEN(9,10)/7.5","v":5760},7680,10240,13653.333333333334,{"$f":"AVERAGE(B4:C4)/4","v":990},{"$f":"AVERAGE(C4:D4)/4","v":1260},1680,2240,2986.666666666667,{"$f":"AVERAGE(B4:E4)/4","v":1335},{"$f":"AVERAGE(E4:G4)/4","v":2631.1111111111113},{"$f":"AVERAGE(B4:G4)/4","v":1885.5555555555557},{"$f":"AVERAGE(B4:C4)/12","v":330},{"$f":"AVERAGE(C4:D4)/12","v":420},560,746.66666666666663,995.55555555555566,{"$f":"AVERAGE(H4:I4)/4","v":281.25},{"$f":"AVERAGE(I4:J4)/4","v":367.5},{"$f":"AVERAGE(J4:K4)/4","v":490},653.33333333333337,{"$f":"AVERAGE(L4:M4)/4","v":540.20833333333337},{"$f":"AVERAGE(M4:N4)/4","v":495.76388888888891},{"$f":"AVERAGE(N4:O4)/4","v":564.58333333333337},{"$f":"P4*RANDBETWEEN(9,10)/10","v":330},{"$f":"Q4*RANDBETWEEN(9,10)/10","v":378},504,672,995.55555555555566,253.125,367.5,490,588,486.1875,495.76388888888886,508.125]
["Cost Of Services",{"$f":"B4*30%","v":1080},{"$f":"C4*30%","v":1296},1728,2304,3072,4096,297,378,504,672,896.00000000000011,400.5,789.33333333333337,565.66666666666663,99,126,168,223.99999999999997,298.66666666666669,84.375,110.25,147,196,162.0625,148.72916666666666,169.375,99,113.39999999999999,151.19999999999999,201.6,298.66666666666669,75.9375,110.25,147,176.4,145.85624999999999,148.72916666666666,152.4375]
["Gross Profit",{"$f":"B4-B5","v":2520},{"$f":"C4-C5","v":3024},4032,5376,7168,9557.3333333333339,693,882,1176,1568,2090.666666666667,934.5,1841.7777777777778,1319.8888888888891,231,294,392,522.66666666666663,696.88888888888891,196.875,257.25,343,457.33333333333337,378.14583333333337,347.03472222222229,395.20833333333337,231,264.60000000000002,352.8,470.4,696.88888888888891,177.1875,257.25,343,411.6,340.33125000000001,347.03472222222217,355.6875]
["Admin Expenses",{"$f":"B$4*11%","v":396},{"$f":"C$4*11%","v":475.2},633.6,844.8,1126.4000000000001,1501.8666666666668,108.9,138.6,184.8,246.4,328.53333333333336,146.85,289.42222222222227,207.41111111111113,36.299999999999997,46.2,61.6,82.133333333333326,109.51111111111112,30.9375,40.424999999999997,53.9,71.866666666666674,59.422916666666673,54.53402777777778,62.104166666666671,36.299999999999997,41.58,55.44,73.92,109.51111111111112,27.84375,40.424999999999997,53.9,64.680000000000007,53.480625000000003,54.534027777777773,55.893749999999997]
["Selling & Marketing",{"$f":"B$4*7%","v":252.00000000000003},{"$f":"C$4*5%","v":216},288,384,512,682.66666666666674,{"$f":"H$4*7%","v":69.300000000000011},63,84,112,149.33333333333334,66.75,{"$f":"N$4*7%","v":184.17777777777781},94.277777777777786,16.5,21,28,{"$f":"S$4*5%","v":37.333333333333336},49.777777777777786,14.0625,18.375,24.5,32.666666666666671,27.010416666666671,24.788194444444446,28.229166666666671,16.5,18.900000000000002,25.200000000000003,33.6,49.777777777777786,12.65625,18.375,24.5,29.400000000000002,24.309375000000003,24.788194444444443,25.40625]
["Depreciation",{"$f":"B$4*3%","v":108},216,288,384,512,682.66666666666674,{"$f":"H$4*3%","v":29.7},63,84,112,149.33333333333334,66.75,{"$f":"N$4*3%","v":78.933333333333337},94.277777777777786,16.5,21,28,37.333333333333336,49.777777777777786,14.0625,18.375,24.5,32.666666666666671,27.010416666666671,24.788194444444446,28.229166666666671,16.5,18.900000000000002,25.200000000000003,33.6,49.777777777777786,12.65625,18.375,24.5,29.400000000000002,24.309375000000003,24.788194444444443,25.40625]
["Impairment loss",{"$f":"B$4*1%","v":36},216,288,384,512,682.66666666666674,{"$f":"H$4*1%","v":9.9},63,84,112,149.33333333333334,66.75,{"$f":"N$4*1%","v":26.311111111111114},94.277777777777786,16.5,21,28,37.333333333333336,49.777777777777786,14.0625,18.375,24.5,32.666666666666671,27.010416666666671,24.788194444444446,28.229166666666671,16.5,18.900000000000002,25.200000000000003,33.6,49.777777777777786,12.65625,18.375,24.5,29.400000000000002,24.309375000000003,24.788194444444443,25.40625]
["Operating expenses",{"$f":"SUM(B7:B10)","v":792},1123.2,1497.6,1996.8,2662.4,3549.8666666666677,217.8,327.60000000000002,436.8,582.4,776.53333333333342,347.1,578.84444444444455,490.24444444444447,85.8,109.2,145.6,194.13333333333335,258.84444444444443,73.125,95.55,127.4,169.86666666666667,140.45416666666668,128.89861111111111,146.79166666666669,85.8,98.280000000000015,131.04000000000002,174.72,258.84444444444443,65.8125,95.55,127.4,152.88000000000002,126.40875000000001,128.89861111111111,132.11250000000001]
["Operating income",{"$f":"B6-B11","v":1728},{"$f":"C6-C11","v":1900.8},2534.4,3379.2,4505.6000000000004,6007.4666666666662,475.2,554.4,739.2,985.6,1314.1333333333337,587.4,1262.9333333333334,829.64444444444462,145.19999999999999,184.8,246.4,328.5333333333333,438.04444444444448,123.75,161.69999999999999,215.6,287.4666666666667,237.69166666666669,218.13611111111118,248.41666666666669,145.19999999999999,166.32,221.76,295.67999999999995,438.04444444444448,111.375,161.69999999999999,215.6,258.72000000000003,213.92250000000001,218.13611111111106,223.57499999999999]
["Finance Cost",{"$f":"B4*12.5%","v":450},{"$f":"C4*12.5%","v":540},720,960,1280,1706.6666666666667,123.75,157.5,210,280,373.33333333333337,166.875,328.88888888888891,235.69444444444446,41.25,52.5,70,93.333333333333329,124.44444444444446,35.15625,45.9375,61.25,81.666666666666671,67.526041666666671,61.970486111111114,70.572916666666671,41.25,47.25,63,84,124.44444444444446,31.640625,45.9375,61.25,73.5,60.7734375,61.970486111111107,63.515625]
["Net income",{"$f":"B12-B13","v":1278},{"$f":"C12-C13","v":1360.8},1814.4,2419.1999999999998,3225.6000000000004,4300.7999999999993,351.45,396.9,529.20000000000005,705.6,940.8000000000003,420.52499999999998,934.04444444444448,593.95000000000016,103.94999999999999,132.30000000000001,176.4,235.2,313.60000000000002,88.59375,115.76249999999999,154.35,205.8,170.16562500000003,156.16562500000006,177.84375,103.94999999999999,119.07,158.76,211.67999999999995,313.60000000000002,79.734375,115.76249999999999,154.35,185.22000000000003,153.14906250000001,156.16562499999995,160.05937499999999]

{"sheet":"Control","index":5,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
["Jan\n2013","Q1\n2013",2009,null,null,"Depreciation"]
["Feb\n2013","Q2\n2013",2010,null,null,"Amazon"]
["Mar\n2013","Q3\n2013",2011,null,null,"Quarterly",{"$f":"MATCH(TRENDSELECTED,TRENDS,0)","v":2}]
["Apr\n2013","Q4\n2013",2012]
["May\n2013","Q1\n2014",2013]
["Jun\n2013","Q2\n2014",2014,null,null,"Jan\n2013",{"$f":"INDEX(INDIRECT(COMPANYSELECTED),MATCH(ITEMSELECTED,ITEMS,0),MATCH(F7,PERIODS,0))","v":16.5},null,null,"Q1\n2013",{"$f":"INDEX(INDIRECT(COMPANYSELECTED),MATCH(ITEMSELECTED,ITEMS,0),MATCH(J7,PERIODS,0))","v":29.7},null,null,2009,{"$f":"INDEX(INDIRECT(COMPANYSELECTED),MATCH(ITEMSELECTED,ITEMS,0),MATCH(N7,PERIODS,0))","v":108}]
["Jul\n2013","Q3\n2014",null,null,null,"Feb\n2013",21,null,null,"Q2\n2013",63,null,null,2010,216]
["Aug\n2013","Q4\n2014",null,null,null,"Mar\n2013",28,null,null,"Q3\n2013",84,null,null,2011,288]
["Sep\n2013",null,null,null,null,"Apr\n2013",37.333333333333336,null,null,"Q4\n2013",112,null,null,2012,384]
["Oct\n2013",null,null,null,null,"May\n2013",49.777777777777786,null,null,"Q1\n2014",149.33333333333334,null,null,2013,512]
["Nov\n2013",null,null,null,null,"Jun\n2013",14.0625,null,null,"Q2\n2014",66.75,null,null,2014,682.66666666666674]
["Dec\n2013",null,null,null,null,"Jul\n2013",18.375,null,null,"Q3\n2014",78.933333333333337]
["Jan\n2014",null,null,null,null,"Aug\n2013",24.5,null,null,"Q4\n2014",94.277777777777786]
["Feb\n2014",null,null,null,null,"Sep\n2013",32.666666666666671]
["Mar\n2014",null,null,null,null,"Oct\n2013",27.010416666666671]
["Apr\n2014",null,null,null,null,"Nov\n2013",24.788194444444446]
["May\n2014",null,null,null,null,"Dec\n2013",28.229166666666671]
["Jun\n2014",null,null,null,null,"Jan\n2014",16.5]
["Jul\n2014",null,null,null,null,"Feb\n2014",18.900000000000002]
["Aug\n2014",null,null,null,null,"Mar\n2014",25.200000000000003]
["Sep\n2014",null,null,null,null,"Apr\n2014",33.6]
["Oct\n2014",null,null,null,null,"May\n2014",49.777777777777786]
["Nov\n2014",null,null,null,null,"Jun\n2014",12.65625]
["Dec\n2014",null,null,null,null,"Jul\n2014",18.375]
[null,null,null,null,null,"Aug\n2014",24.5]
[null,null,null,null,null,"Sep\n2014",29.400000000000002]
[null,null,null,null,null,"Oct\n2014",24.309375000000003]
[null,null,null,null,null,"Nov\n2014",24.788194444444443]
[null,null,null,null,null,"Dec\n2014",25.40625]