{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Dashboard","Data"],"not_rendered":{"charts":8,"images":1,"macros":0,"external_links":0,"defined_names":2,"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":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,8,0,20],[2,1,2,6],[4,1,4,11],[4,13,4,23],[15,1,15,11],[15,13,15,23]]}
[null,null,null,null,null,null,null,null,"KPI Dashboard"]
[]
[]
[]
[null,{"$f":"\"  \"&Data!B6","v":"  Indicator 1"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"  \"&Data!B9","v":"  Indicator 2"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"  \"&Data!B12","v":"  Indicator 3"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"  \"&Data!B15","v":"  Indicator 4"}]

{"sheet":"Data","index":1,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[[5,1,7,1],[8,1,10,1],[11,1,13,1],[14,1,16,1],[0,5,0,10]]}
[null,null,null,null,null,"KPI Data"]
[]
[null,"Data"]
[]
[null,"Indicators","Actual / Target","JAN","FEB","MAR","APR","MAI","JUN","JUL","AUG","SEP","OCT","NOV","DEC","TOTAL"]
[null,"Indicator 1","Actual",11588,9189,8001,9736,8686,8560,11611,10576,10386,10710,11636,10253,{"$f":"SUM(D6:O6)","v":120932}]
[null,null,"Target",10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,{"$f":"SUM(D7:O7)","v":120000}]
[null,null,"% Target",{"$f":"D6/D7","v":1.1588000000000001},{"$f":"E6/E7","v":0.91890000000000005},0.80010000000000003,0.97360000000000002,0.86860000000000004,0.85599999999999998,1.1611,1.0576000000000001,1.0386,1.071,1.1636,1.0253000000000001,1.0077666666666667,{"$f":"IF(P8>=1,0,1-P8)","v":0}]
[null,"Indicator 2","Actual",8104,8141,10748,11979,8003,11765,10500,11295,9952,9626,8964,8563,117640]
[null,null,"Target",10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,120000]
[null,null,"% Target",{"$f":"D9/D10","v":0.81040000000000001},{"$f":"E9/E10","v":0.81410000000000005},{"$f":"F9/F10","v":1.0748},{"$f":"G9/G10","v":1.1979},{"$f":"H9/H10","v":0.80030000000000001},{"$f":"I9/I10","v":1.1765000000000001},{"$f":"J9/J10","v":1.05},{"$f":"K9/K10","v":1.1294999999999999},{"$f":"L9/L10","v":0.99519999999999997},{"$f":"M9/M10","v":0.96260000000000001},{"$f":"N9/N10","v":0.89639999999999997},{"$f":"O9/O10","v":0.85629999999999995},{"$f":"P9/P10","v":0.98033333333333328},{"$f":"IF(P11>=1,0,1-P11)","v":1.9666666666666721E-2}]
[null,"Indicator 3","Actual",9764,11245,9696,9374,9533,8531,8781,9892,9882,11964,8883,10023,117568]
[null,null,"Target",10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,120000]
[null,null,"% Target",{"$f":"D12/D13","v":0.97640000000000005},{"$f":"E12/E13","v":1.1245000000000001},{"$f":"F12/F13","v":0.96960000000000002},{"$f":"G12/G13","v":0.93740000000000001},{"$f":"H12/H13","v":0.95330000000000004},{"$f":"I12/I13","v":0.85309999999999997},{"$f":"J12/J13","v":0.87809999999999999},{"$f":"K12/K13","v":0.98919999999999997},{"$f":"L12/L13","v":0.98819999999999997},{"$f":"M12/M13","v":1.1963999999999999},{"$f":"N12/N13","v":0.88829999999999998},{"$f":"O12/O13","v":1.0023},{"$f":"P12/P13","v":0.97973333333333334},{"$f":"IF(P14>=1,0,1-P14)","v":2.0266666666666655E-2}]
[null,"Indicator 4","Actual",8276,8863,8021,9400,8234,9380,10509,11215,8599,10464,11920,8470,113351]
[null,null,"Target",10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,120000]
[null,null,"% Target",{"$f":"D15/D16","v":0.8276},{"$f":"E15/E16","v":0.88629999999999998},{"$f":"F15/F16","v":0.80210000000000004},{"$f":"G15/G16","v":0.94},{"$f":"H15/H16","v":0.82340000000000002},{"$f":"I15/I16","v":0.93799999999999994},{"$f":"J15/J16","v":1.0508999999999999},{"$f":"K15/K16","v":1.1214999999999999},{"$f":"L15/L16","v":0.8599},{"$f":"M15/M16","v":1.0464},{"$f":"N15/N16","v":1.1919999999999999},{"$f":"O15/O16","v":0.84699999999999998},{"$f":"P15/P16","v":0.94459166666666672},{"$f":"IF(P17>=1,0,1-P17)","v":5.5408333333333282E-2}]
[]
[]
[null,null,"Max",{"$f":"(LARGE($D$6:$O$6,1)*1.1)-D6","v":1211.6000000000004},{"$f":"(LARGE($D$6:$O$6,1)*1.1)-E6","v":3610.6000000000004},4798.6000000000004,3063.6000000000004,4113.6000000000004,4239.6000000000004,1188.6000000000004,2223.6000000000004,2413.6000000000004,2089.6000000000004,1163.6000000000004,2546.6000000000004]
[null,null,"Max",{"$f":"(LARGE($D$9:$O$9,1)*1.1)-D9","v":5072.9000000000015},{"$f":"(LARGE($D$9:$O$9,1)*1.1)-E9","v":5035.9000000000015},2428.9000000000015,1197.9000000000015,5173.9000000000015,1411.9000000000015,2676.9000000000015,1881.9000000000015,3224.9000000000015,3550.9000000000015,4212.9000000000015,4613.9000000000015]
[null,null,"Max",{"$f":"(LARGE($D$12:$O$12,1)*1.1)-D12","v":3396.4000000000015},{"$f":"(LARGE($D$12:$O$12,1)*1.1)-E12","v":1915.4000000000015},3464.4000000000015,3786.4000000000015,3627.4000000000015,4629.4000000000015,4379.4000000000015,3268.4000000000015,3278.4000000000015,1196.4000000000015,4277.4000000000015,3137.4000000000015]
[null,null,"Max",{"$f":"(LARGE($D$15:$O$15,1)*1.1)-D15","v":4836.0000000000018},{"$f":"(LARGE($D$15:$O$15,1)*1.1)-E15","v":4249.0000000000018},5091.0000000000018,3712.0000000000018,4878.0000000000018,3732.0000000000018,2603.0000000000018,1897.0000000000018,4513.0000000000018,2648.0000000000018,1192.0000000000018,4642.0000000000018]