{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["data","Template","Sheet13"],"not_rendered":{"charts":0,"images":1,"macros":1,"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":"data","index":0,"n_rows":89,"n_cols":7,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
["Full name","Hired date","Salary","Bonus","Overtime","Department","Sick Day"]
["NAZRY BIN ABDUL KARIM","2016-11-09",9711,485.55,492,"IT",3]
["SHASHIMALA AP VADIVELU","2008-08-07",7589,1214.24,364,"Marketing",2]
["AHMAD SHAH IDRIS","2017-05-23",8846,530.76,843,"IT",1]
["NUR MAIDAZAH BT MAIDIN","2002-03-03",8857,1239.98,564,"Account",3]
["WAN ZAKA BT MAMAT","2007-11-17",1920,192,804,"Logistic",9]
["NUR ANI BT MD SURANI","2017-04-13",6842,273.68,244,"Sales",6]
["NORANI BT JAMALUDIN","2011-06-13",3670,403.7,888,"R &D",8]
["SITI AISYAH NOOR BT MOHD HANAH","2015-02-19",1691,536.28,619,"HR",5]
["ILHAMI B ABD. AZIZ","2009-08-11",7065,1413,807,"Operation",7]
["ADRAIN PAUL","2000-01-22",2796,251.64,540,"Logistic",6]
["ALAN B BAHARIN","2003-09-05",6725,739.75,926,"Operation",0]
["HAMIYA SAADIAH BT MD. SEDIT","2013-08-12",1691,236.74,755,"Operation",0]
["MAI BT ATTAN","2005-09-23",7235,1302.3,460,"Logistic",0]
["SYUKRI BIN IDRIS","2009-06-16",3118,436.52000000000004,863,"R &D",2]
["SUREEN SOFIA BT ZAKARIA","2016-07-08",4004,600.6,596,"Operation",7]
["RESY BT MOHD FAUZIE","2002-06-06",6012,120.24000000000001,266,"Sales",3]
["MOHD ANNUAR B ISMAIL","2016-08-20",3021,302.10000000000002,158,"Operation",0]
["HIDAYAH BINTI AHMAD","2011-04-22",8595,1031.3999999999999,314,"Marketing",4]
["KAMAL ARIF BIN YEOP KAMARUDDIN","2014-01-12",4813,385.04,937,"Account",7]
["ZAHARIAH BINTI RAZALI​​","2009-02-17",3603,324.27,790,"Sales",8]
["JOHARI BIN MOHAMAD HAZIZI","2003-07-03",6682,1069.1200000000001,630,"Operation",8]
["ZULKIFLIY BIN ZAINAL ABIDIN","2001-05-02",8439,590.73,466,"Marketing",4]
["RATUL ADAWIYAH BINTI AHMAD MOKRI","2012-09-02",3345,602.1,226,"Account",2]
["ASMAH BINTI ABD WAHAB","2009-10-11",3579,501.06000000000006,888,"Logistic",10]
["MASZLIFAH BINTI ABDUL RAHMAN","2006-09-28",6808,748.88,762,"Logistic",2]
["SURYA BINTI HAMID","2000-05-27",4328,476.08,459,"Marketing",6]
["LINDA BINTI MOHAMMED NOOR","2015-12-05",5758,575.80000000000007,506,"R &D",8]
["SYKIN BINTI ISMAIL","2015-10-25",3340,567.80000000000007,263,"Account",3]
["FADZLY BIN ABDUL JALIL","2012-11-04",9342,1774.98,955,"Sales",7]
["ADA BINTI OTHMAN","2004-09-02",8710,1654.9,636,"Account",5]
["SHAHIDAUL AZIDI BIN ABU ZAID","2017-01-07",8318,249.54,653,"Sales",5]
["ZAZRI BIN SABTU","2003-04-08",1691,640.20000000000005,532,"R &D",2]
["RAHIDA BT. RAHIM","2017-09-11",2300,134.1,340,"Operation",4]
["SHARIF BIN MANON","2011-11-18",2400,415.5,241,"Operation",8]
["ZAWATI BINTI MOHD ZABERI","2011-03-10",2300,133.13999999999999,109,"Operation",10]
["ALIA BINTI ABDUL MANAN","2004-05-15",7964,1114.96,931,"R &D",3]
["SUMATHRA RAMAN NAIR","2016-09-07",7151,357.55,972,"Sales",6]
["ROSLI BIN MOHAMED","2001-08-06",1691,643.31999999999994,236,"Marketing",7]
["ADIL BIN ANDY","2003-12-10",7022,210.66,803,"R &D",3]
["MAHATHIR BIN HAMID","2009-09-14",8723,1133.99,387,"Operation",8]
["MOHAMAD KHAIRAL BIN OTHMAN","2013-10-24",9892,395.68,920,"Sales",0]
["ASRAF BIN A. WAHAP","2000-02-10",4418,530.16,546,"R &D",4]
["IZWA BIN CHE ABDUL LATIFF","2007-05-21",1453,87.179999999999993,789,"Logistic",4]
["FIKIR SYAWAN BIN KAMAR NOOR","2012-03-17",1691,581.91000000000008,917,"R &D",5]
["RIZAL MOLAIZI BIN MOHD","2000-10-24",1865,298.40000000000003,178,"HR",1]
["SYAZAL BIN MOHAMMED NAZARI","2016-12-12",8188,491.28,829,"Operation",5]
["AHUDDIN HELMI BIN MUHAMAD","2010-11-18",9142,639.94000000000005,547,"Account",4]
["MAINOR BIN SARIF","2017-08-28",2660,53.2,288,"HR",5]
["RINA BINTI ABU BAKAR","2012-01-18",2939,205.73000000000002,933,"IT",6]
["HASIMAH BINTI HUSSIN","2010-12-02",1691,755.65000000000009,521,"IT",5]
["ZAINUDIN BIN ABDULLAH","2008-12-04",1194,155.22,500,"Marketing",7]
["ANNIE A/P PETER","2004-03-10",6604,792.48,228,"Sales",4]
["JAZZAN BIN AHMAD","2011-06-05",9439,188.78,710,"Marketing",6]
["ASRUL NAJIB BIN HASIM","2009-11-12",2300,313.3,336,"Sales",3]
["HENECA BINTI HASMI","2001-07-02",2378,95.12,398,"Operation",9]
["THAVAKUMAR A/L SELVA","2004-02-14",5449,817.35,445,"Marketing",1]
["IZZATI BINTI KAMALRUL BADRI","2016-10-14",4230,846,550,"Logistic",2]
["SANRANG","2007-10-17",4782,191.28,178,"IT",4]
["ABDUL RASHID","2007-10-14",8945,1073.3999999999999,768,"Sales",4]
["NUR ZAHIDAH","2005-06-25",2389,215.01,558,"R &D",5]
["ALLIAS B IBRAHIM ","2007-02-08",2491,224.19,622,"Marketing",4]
["ZAKI B NOR RASHID","2013-04-17",5447,653.64,817,"HR",1]
["ZAMANI B HUSSEIN","2003-01-03",2300,720.94,140,"Sales",6]
["HALIZA BT MOHD MOKHTAR","2016-11-26",9211,368.44,902,"Operation",10]
["FARAH  BT JAMALUDIN","2016-12-18",9938,1192.56,591,"Marketing",3]
["MIDAH BT ABDUL HAMID","2006-09-28",6009,1141.71,818,"Logistic",6]
["ANAM B KASIM","2000-05-27",9463,662.41000000000008,781,"Account",5]
["Liza Bt Abdilah","2005-04-04",3474,104.22,458,"Account",7]
["Hafizi Bin Abdullah Alias Ramlan","2012-03-21",3467,520.04999999999995,854,"R &D",2]
["Cilah Bt Azizan","2016-10-09",8245,494.7,270,"Operation",1]
["Mayani Bt Mohd Noor","2017-07-20",5199,259.95,550,"Logistic",7]
["Adirah Bt Minai Rajab","2009-03-17",8757,1050.8399999999999,946,"Account",4]
["Shahrul Iqmar Bin Abdul Azian","2002-05-25",1900,985.72,902,"HR",9]
["Nur Hidayah Binti Abd Rahim","2011-04-17",5533,940.61,339,"Marketing",8]
["Nor Hafni binti Anuar","2011-06-22",6767,1082.72,158,"Account",4]
["Masuwan Bin Darwin","2010-05-23",1062,42.480000000000004,819,"Account",2]
["Jullie Binti Samsuddin","2010-08-27",2572,51.44,647,"Operation",9]
["Nor Fazlina Binti Zainol Abdullah","2001-12-23",8247,1649.4,923,"Sales",1]
["Liza Yanty Binti Ghazalin","2011-05-08",6038,120.76,741,"Account",0]
["Zaleha Binti Hamid","2011-03-21",6461,1098.3700000000001,715,"Account",3]
["Zubaidah Binti Adan","2013-09-23",8407,252.20999999999998,523,"Sales",5]
["Zalifah Binti Mohd Sara","2009-02-27",9895,1187.3999999999999,194,"Operation",5]
["Lisa Chapi","2016-06-14",4764,952.80000000000007,355,"Operation",2]
["Aida Binti Mukmud","2013-07-10",8423,1516.1399999999999,497,"Marketing",5]
["Hira Devi A/P Krishnasami","2006-12-28",2300,1125.4000000000001,241,"Account",7]
["Thila A/P Gopal","2000-12-02",8724,1221.3600000000001,454,"Marketing",7]
["Azman Bin Yahaya","2010-08-05",8671,1040.52,672,"IT",8]
["Annah Binti Othman","2006-08-01",3833,421.63,340,"IT",1]

{"sheet":"Template","index":1,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"EMPLOYEE REPORT"]
[]
[null,null,null,"Name"]
[]
[null,null,null,"Hired Date"]
[]
[null,null,null,"Salary"]

{"sheet":"Sheet13","index":2,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,null,"Count Colored Cells Using GET.CELL Function"]
[null,null,null,null,null,null,null,null,"Create a Name Range"]
[]
[null,null,"Lemon",{"$f":"GetColor","v":6},null,null,{"$f":"COUNTIF(D4:D8,GetColor)","v":3}]
[null,null,"Orange",{"$f":"GetColor","v":44}]
[null,null,"Lemon",{"$f":"GetColor","v":6}]
[null,null,"Apple",{"$f":"GetColor","v":3}]
[null,null,"Lemon",{"$f":"GetColor","v":6}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"in cell D4, type =GetColor"]
[]
[]
[null,null,null,null,null,null,null,null,"in cell G3, type =COUNTIF(D4:D8,GetColor)"]