{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["DataFromWebApp_andOthers"],"not_rendered":{"charts":0,"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":"DataFromWebApp_andOthers","index":0,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["YearQtr","Product1","Product2","Product3","GrowthOnlyInQ4","RandomOnlyInQ4","RandomAllButQ4","ConstantAllButQ3",null,"RandomNumbers","RandAt1Digit"]
["2012Q1",230.54103839999999,903.42248619999998,558.08735149999995,{"$f":"IF(ISERROR(FIND(\"Q4\",$A2)),0,ROW()*100)","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A2)),0,ROUND($J2*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A2)),ROUND($J2*1000,0),0)","v":337},{"$f":"IF(ISERROR(FIND(\"Q3\",$A2)),100,0)","v":100},null,{"$f":"RAND()","v":0.33677271533857522},{"$f":"ROUND(J2,1)","v":0.3}]
["2012Q2",254.86754880000001,1008.029886,567.27949539999997,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A3)),0,ROUND($J3*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A3)),ROUND($J3*1000,0),0)","v":733},{"$f":"IF(ISERROR(FIND(\"Q3\",$A3)),100,0)","v":100},null,{"$f":"RAND()","v":0.73280242838540033},{"$f":"ROUND(J3,1)","v":0.7}]
["2012Q3",262.29274989999999,964.54247229999999,567.3527891,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A4)),0,ROUND($J4*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A4)),ROUND($J4*1000,0),0)","v":352},{"$f":"IF(ISERROR(FIND(\"Q3\",$A4)),100,0)","v":0},null,0.35247531523104303,0.4]
["2012Q4",247.39340820000001,893.23644469999999,758.70174970000005,{"$f":"IF(ISERROR(FIND(\"Q4\",$A5)),0,ROW()*100)","v":500},{"$f":"IF(ISERROR(FIND(\"Q4\",$A5)),0,ROUND($J5*1000,0))","v":730},{"$f":"IF(ISERROR(FIND(\"Q4\",$A5)),ROUND($J5*1000,0),0)","v":0},100,null,0.72963753141293497,0.7]
["2013Q1",277.42880200000002,936.28515630000004,561.97066770000004,{"$f":"IF(ISERROR(FIND(\"Q4\",$A6)),0,ROW()*100)","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A6)),0,ROUND($J6*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A6)),ROUND($J6*1000,0),0)","v":571},100,null,0.57117133203566584,0.6]
["2013Q2",296.4416425,1070.5139140000001,566.17454859999998,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A7)),0,ROUND($J7*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A7)),ROUND($J7*1000,0),0)","v":956},100,null,0.95598625094198819,1]
["2013Q3",309.53566410000002,930.79709749999995,574.0001244,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A8)),0,ROUND($J8*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A8)),ROUND($J8*1000,0),0)","v":455},0,null,0.4545946894996058,0.5]
["2013Q4",304.65620100000001,963.49848889999998,764.19328289999999,900,{"$f":"IF(ISERROR(FIND(\"Q4\",$A9)),0,ROUND($J9*1000,0))","v":21},{"$f":"IF(ISERROR(FIND(\"Q4\",$A9)),ROUND($J9*1000,0),0)","v":0},100,null,2.0787860181308848E-2,0]
["2014Q1",329.39961820000002,904.37495550000006,562.04400710000004,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A10)),0,ROUND($J10*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A10)),ROUND($J10*1000,0),0)","v":949},100,null,0.94908207905665765,0.9]
["2014Q2",345.23234589999998,932.10014820000004,565.17060460000005,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A11)),0,ROUND($J11*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A11)),ROUND($J11*1000,0),0)","v":220},100,null,0.2203180565176418,0.2]
["2014Q3",371.89420539999998,998.76947829999995,578.41975009999999,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A12)),0,ROUND($J12*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A12)),ROUND($J12*1000,0),0)","v":990},0,null,0.99019750587324973,1]
["2014Q4",379.89162490000001,1107.1549399999999,763.25984010000002,1300,{"$f":"IF(ISERROR(FIND(\"Q4\",$A13)),0,ROUND($J13*1000,0))","v":23},{"$f":"IF(ISERROR(FIND(\"Q4\",$A13)),ROUND($J13*1000,0),0)","v":0},100,null,2.2654472639309087E-2,0]
["2015Q1",410.12763200000001,1165.8539069999999,574.16403639999999,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A14)),0,ROUND($J14*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A14)),ROUND($J14*1000,0),0)","v":607},100,null,0.60712461254988115,0.6]
["2015Q2",369.72109999999998,890.98930480000001,581.98110499999996,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A15)),0,ROUND($J15*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A15)),ROUND($J15*1000,0),0)","v":278},100,null,0.27817106132822367,0.3]
["2015Q3",389.00696140000002,966.49536660000001,581.29592620000005,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A16)),0,ROUND($J16*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A16)),ROUND($J16*1000,0),0)","v":965},0,null,0.96536595382561174,1]
["2015Q4",421.11005230000001,1019.093796,783.70391570000004,1700,{"$f":"IF(ISERROR(FIND(\"Q4\",$A17)),0,ROUND($J17*1000,0))","v":583},{"$f":"IF(ISERROR(FIND(\"Q4\",$A17)),ROUND($J17*1000,0),0)","v":0},100,null,0.58270757172716514,0.6]
["2016Q1",456.35431069999998,1030.116573,581.54964510000002,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A18)),0,ROUND($J18*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A18)),ROUND($J18*1000,0),0)","v":779},100,null,0.77920891419172111,0.8]
["2016Q2",413.04966450000001,889.60794539999995,580.03973329999997,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A19)),0,ROUND($J19*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A19)),ROUND($J19*1000,0),0)","v":97},100,null,9.653399580963562E-2,0.1]
["2016Q3",442.5053011,951.58407769999997,582.13556270000004,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A20)),0,ROUND($J20*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A20)),ROUND($J20*1000,0),0)","v":512},0,null,0.51205758158455372,0.5]
["2016Q4",429.74823049999998,918.3460996,779.18906879999997,2100,{"$f":"IF(ISERROR(FIND(\"Q4\",$A21)),0,ROUND($J21*1000,0))","v":121},{"$f":"IF(ISERROR(FIND(\"Q4\",$A21)),ROUND($J21*1000,0),0)","v":0},100,null,0.12057047272472476,0.1]
["2017Q1",466.75598889999998,896.43872899999997,585.12473520000003,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A22)),0,ROUND($J22*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A22)),ROUND($J22*1000,0),0)","v":175},100,null,0.17544130969453842,0.2]
["2017Q2",491.84775339999999,1010.093702,587.50961719999998,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A23)),0,ROUND($J23*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A23)),ROUND($J23*1000,0),0)","v":221},100,null,0.22059018278232767,0.2]
["2017Q3",462.3678903,929.29433159999996,577.84963100000004,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A24)),0,ROUND($J24*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A24)),ROUND($J24*1000,0),0)","v":400},0,null,0.39967392977107064,0.4]
["2017Q4",472.17753900000002,875.80362109999999,791.28125609999995,2500,{"$f":"IF(ISERROR(FIND(\"Q4\",$A25)),0,ROUND($J25*1000,0))","v":454},{"$f":"IF(ISERROR(FIND(\"Q4\",$A25)),ROUND($J25*1000,0),0)","v":0},100,null,0.45445574190567262,0.5]
["2018Q1",475.9991852,870.50220030000003,590.35040430000004,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A26)),0,ROUND($J26*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A26)),ROUND($J26*1000,0),0)","v":42},100,null,4.1779239686427938E-2,0]
["2018Q2",503.67948239999998,903.30062439999995,581.58956660000001,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A27)),0,ROUND($J27*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A27)),ROUND($J27*1000,0),0)","v":90},100,null,8.9515630179307526E-2,0.1]
["2018Q3",533.03870029999996,958.06188529999997,581.34893420000003,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A28)),0,ROUND($J28*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A28)),ROUND($J28*1000,0),0)","v":805},0,null,0.80460100005737234,0.8]
["2018Q4",552.75237890000005,963.08536939999999,798.67892380000001,2900,{"$f":"IF(ISERROR(FIND(\"Q4\",$A29)),0,ROUND($J29*1000,0))","v":617},{"$f":"IF(ISERROR(FIND(\"Q4\",$A29)),ROUND($J29*1000,0),0)","v":0},100,null,0.61731846788324685,0.6]
["2019Q1",550.20627400000001,1007.317818,587.54791739999996,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A30)),0,ROUND($J30*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A30)),ROUND($J30*1000,0),0)","v":428},100,null,0.42831742277997853,0.4]
["2019Q2",571.67312319999996,865.68165060000001,597.55018570000004,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A31)),0,ROUND($J31*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A31)),ROUND($J31*1000,0),0)","v":952},100,null,0.95241567286457141,1]
["2019Q3",553.24607949999995,980.56944820000001,592.15961800000002,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A32)),0,ROUND($J32*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A32)),ROUND($J32*1000,0),0)","v":817},0,null,0.8166875001052567,0.8]
["2019Q4",585.48220530000003,909.94359840000004,791.97402680000005,3300,{"$f":"IF(ISERROR(FIND(\"Q4\",$A33)),0,ROUND($J33*1000,0))","v":755},{"$f":"IF(ISERROR(FIND(\"Q4\",$A33)),ROUND($J33*1000,0),0)","v":0},100,null,0.75545204414513367,0.8]
["2020Q1",607.144588,987.63085980000005,585.45639879999999,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A34)),0,ROUND($J34*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A34)),ROUND($J34*1000,0),0)","v":992},100,null,0.9923766656328693,1]
["2020Q2",615.92268920000004,1223.2891549999999,572.74051099999997,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A35)),0,ROUND($J35*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A35)),ROUND($J35*1000,0),0)","v":954},100,null,0.9542235096376851,1]
["2020Q3",525.52104569999995,780.91167480000001,590.25103349999995,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A36)),0,ROUND($J36*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A36)),ROUND($J36*1000,0),0)","v":812},0,null,0.81157851054291419,0.8]
["2020Q4",592.28772059999994,932.30985239999995,798.73624280000001,3700,{"$f":"IF(ISERROR(FIND(\"Q4\",$A37)),0,ROUND($J37*1000,0))","v":35},{"$f":"IF(ISERROR(FIND(\"Q4\",$A37)),ROUND($J37*1000,0),0)","v":0},100,null,3.4886148957098295E-2,0]
["2021Q1",565.69992760000002,820.41706069999998,598.05028519999996,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A38)),0,ROUND($J38*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A38)),ROUND($J38*1000,0),0)","v":942},100,null,0.94244419445167182,0.9]
["2021Q2",584.81021569999996,623.12589400000002,598.16506779999997,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A39)),0,ROUND($J39*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A39)),ROUND($J39*1000,0),0)","v":586},100,null,0.5857869829902641,0.6]
["2021Q3",588.51048160000005,718.58276660000001,590.18103369999994,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A40)),0,ROUND($J40*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A40)),ROUND($J40*1000,0),0)","v":449},0,null,0.44937017751812192,0.4]
["2021Q4",617.34134689999996,655.49444449999999,808.81963080000003,4100,{"$f":"IF(ISERROR(FIND(\"Q4\",$A41)),0,ROUND($J41*1000,0))","v":361},{"$f":"IF(ISERROR(FIND(\"Q4\",$A41)),ROUND($J41*1000,0),0)","v":0},100,null,0.36063230897004217,0.4]
["2022Q1",582.12537680000003,587.47198500000002,591.13403659999994,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A42)),0,ROUND($J42*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A42)),ROUND($J42*1000,0),0)","v":987},100,null,0.9872520235626131,1]
["2022Q2",589.02172289999999,510.49515150000002,592.62139060000004,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A43)),0,ROUND($J43*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A43)),ROUND($J43*1000,0),0)","v":262},100,null,0.26243496013061174,0.3]
["2022Q3",680.94598050000002,753.65566390000004,600.41777019999995,0,{"$f":"IF(ISERROR(FIND(\"Q4\",$A44)),0,ROUND($J44*1000,0))","v":0},{"$f":"IF(ISERROR(FIND(\"Q4\",$A44)),ROUND($J44*1000,0),0)","v":317},0,null,0.31728543058818848,0.3]
[]
["# with Demand",{"$f":"COUNTIF(B2:B44,\">0\")","v":43},{"$f":"COUNTIF(C2:C44,\">0\")","v":43},{"$f":"COUNTIF(D2:D44,\">0\")","v":43},{"$f":"COUNTIF(E2:E44,\">0\")","v":10},{"$f":"COUNTIF(F2:F44,\">0\")","v":10},{"$f":"COUNTIF(G2:G44,\">0\")","v":33},{"$f":"COUNTIF(H2:H44,\">0\")","v":32}]
["# not Missing",{"$f":"COUNT(B2:B44)","v":43},{"$f":"COUNT(C2:C44)","v":43},{"$f":"COUNT(D2:D44)","v":43},{"$f":"COUNT(E2:E44)","v":43},{"$f":"COUNT(F2:F44)","v":43},{"$f":"COUNT(G2:G44)","v":43},{"$f":"COUNT(H2:H44)","v":43}]
["ADI",{"$f":"B47/B46","v":1},{"$f":"C47/C46","v":1},{"$f":"D47/D46","v":1},{"$f":"E47/E46","v":4.3},{"$f":"F47/F46","v":4.3},{"$f":"G47/G46","v":1.303030303030303},{"$f":"H47/H46","v":1.34375}]
["stdDev",{"$f":"STDEV(B2:B44)","v":122.40813067213904},{"$f":"STDEV(C2:C44)","v":140.01558173373357},{"$f":"STDEV(D2:D44)","v":87.543248426374987},{"$f":"STDEV(E2:E44)","v":1131.7672066139651},{"$f":"STDEV(F2:F44)","v":210.35140139983582},{"$f":"STDEV(G2:G44)","v":370.52357675353477},{"$f":"STDEV(H2:H44)","v":44.148144844882665}]
["mean",{"$f":"AVERAGE(B2:B44)","v":458.36641390000005},{"$f":"AVERAGE(C2:C44)","v":911.82069824418568},{"$f":"AVERAGE(D2:D44)","v":628.37794003953491},{"$f":"AVERAGE(E2:E44)","v":534.88372093023258},{"$f":"AVERAGE(F2:F44)","v":86.04651162790698},{"$f":"AVERAGE(G2:G44)","v":442.60465116279067},{"$f":"AVERAGE(H2:H44)","v":74.418604651162795}]
["CV_sq",{"$f":"(B49/B50)^2","v":7.1317310333280023E-2},{"$f":"(C49/C50)^2","v":2.3579459482215681E-2},{"$f":"(D49/D50)^2","v":1.9409013185149211E-2},{"$f":"(E49/E50)^2","v":4.4770861463678084},{"$f":"(F49/F50)^2","v":5.976188430901944},{"$f":"(G49/G50)^2","v":0.70080912596753053},{"$f":"(H49/H50)^2","v":0.35193452380952384}]
["Frequency",{"$f":"IF(B48<1.32,\"Frequent\",\"Infrequent\")","v":"Frequent"},{"$f":"IF(C48<1.32,\"Frequent\",\"Infrequent\")","v":"Frequent"},{"$f":"IF(D48<1.32,\"Frequent\",\"Infrequent\")","v":"Frequent"},{"$f":"IF(E48<1.32,\"Frequent\",\"Infrequent\")","v":"Infrequent"},{"$f":"IF(F48<1.32,\"Frequent\",\"Infrequent\")","v":"Infrequent"},{"$f":"IF(G48<1.32,\"Frequent\",\"Infrequent\")","v":"Frequent"},{"$f":"IF(H48<1.32,\"Frequent\",\"Infrequent\")","v":"Infrequent"}]
["Variability",{"$f":"IF(B51<0.49,\"Low\",\"High\")","v":"Low"},{"$f":"IF(C51<0.49,\"Low\",\"High\")","v":"Low"},{"$f":"IF(D51<0.49,\"Low\",\"High\")","v":"Low"},{"$f":"IF(E51<0.49,\"Low\",\"High\")","v":"High"},{"$f":"IF(F51<0.49,\"Low\",\"High\")","v":"High"},{"$f":"IF(G51<0.49,\"Low\",\"High\")","v":"High"},{"$f":"IF(H51<0.49,\"Low\",\"High\")","v":"Low"}]
["Category",{"$f":"IF(B52=\"Frequent\",IF(B53=\"Low\",\"SMOOTH\",\"ERRATIC\"),IF(B52=\"Infrequent\",IF(B53=\"Low\",\"INTERMITTENT\", \"LUMPY\")))","v":"SMOOTH"},{"$f":"IF(C52=\"Frequent\",IF(C53=\"Low\",\"SMOOTH\",\"ERRATIC\"),IF(C52=\"Infrequent\",IF(C53=\"Low\",\"INTERMITTENT\", \"LUMPY\")))","v":"SMOOTH"},{"$f":"IF(D52=\"Frequent\",IF(D53=\"Low\",\"SMOOTH\",\"ERRATIC\"),IF(D52=\"Infrequent\",IF(D53=\"Low\",\"INTERMITTENT\", \"LUMPY\")))","v":"SMOOTH"},{"$f":"IF(E52=\"Frequent\",IF(E53=\"Low\",\"SMOOTH\",\"ERRATIC\"),IF(E52=\"Infrequent\",IF(E53=\"Low\",\"INTERMITTENT\", \"LUMPY\")))","v":"LUMPY"},{"$f":"IF(F52=\"Frequent\",IF(F53=\"Low\",\"SMOOTH\",\"ERRATIC\"),IF(F52=\"Infrequent\",IF(F53=\"Low\",\"INTERMITTENT\", \"LUMPY\")))","v":"LUMPY"},{"$f":"IF(G52=\"Frequent\",IF(G53=\"Low\",\"SMOOTH\",\"ERRATIC\"),IF(G52=\"Infrequent\",IF(G53=\"Low\",\"INTERMITTENT\", \"LUMPY\")))","v":"ERRATIC"},{"$f":"IF(H52=\"Frequent\",IF(H53=\"Low\",\"SMOOTH\",\"ERRATIC\"),IF(H52=\"Infrequent\",IF(H53=\"Low\",\"INTERMITTENT\", \"LUMPY\")))","v":"INTERMITTENT"}]