{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Dashboard","Data"],"not_rendered":{"charts":7,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,337]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Previous Month Descriptives"]
[null,null,null,null,null,null,null,null,null,null,"Salary","Bonus","OT"]
[null,null,null,null,null,null,null,null,null,"sum",6290000,949140,184080]
[null,null,null,null,null,null,null,null,null,"average",62900,9491.4,1840.8]
[null,null,null,null,null,null,null,null,null,"max",149000,53050,7890]
[null,null,null,null,null,null,null,null,null,"min",20000,1800,60]
[null,null,null,null,null,null,null,null,null,"median",61500,6355,965]
[null,null,null,null,null,null,null,null,null,"mode",81000,2370,60]

{"sheet":"Data","index":1,"n_rows":127,"n_cols":15,"rows_kept":127,"cut":false,"hidden":false,"merged":[[0,2,0,7]]}
[null,null,"Previous Month Data",null,null,null,null,null,null,null,"sick","OT",null,"bonus","performance"]
["Full Name","Hire Date","Salary","Bonus","Overtime","Department","Sick Days","Performance Score",null,null,"x","y",null,"x","y"]
["Chandler Stevens","2013-11-07",57000,6350,590,"Marketing",2,1,null,null,2,590,null,6350,1]
["Melvin Pickett","2013-11-07",78000,9190,2280,"Accounting",4,1,null,null,4,2280,null,9190,1]
["Ferris Knight","2013-11-12",70000,2370,2040,"Marketing",3,4,null,null,3,2040,null,2370,4]
["Jesse Barron","2013-11-12",89000,10400,60,"IT",1,5,null,null,1,60,null,10400,5]
["Asher Benson","2013-11-20",34000,2850,1860,"Accounting",1,5,null,null,1,1860,null,2850,5]
["Marvin Moses","2013-11-26",68000,9370,5180,"Administration",5,1,null,null,5,5180,null,9370,1]
["Ishmael Grimes","2013-12-20",32000,4690,1460,"Administration",1,2,null,null,1,1460,null,4690,2]
["Elmo Abbott","2013-12-20",55000,7680,2100,"Human Resources",1,3,null,null,1,2100,null,7680,3]
["Oren Chase","2013-12-26",29000,2550,810,"Human Resources",1,1,null,null,1,810,null,2550,1]
["Byron Foreman","2014-01-08",81000,6440.0000000000009,60,"R&D",3,3,null,null,3,60,null,6440.0000000000009,3]
["Hu Frost","2014-01-15",39000,2800,1110,"Accounting",3,4,null,null,3,1110,null,2800,4]
["Ferdinand Small","2014-01-23",34000,4350,3060,"Customer Support",3,3,null,null,3,3060,null,4350,3]
["Kasimir Mccoy","2014-01-29",36000,3290,60,"R&D",3,3,null,null,3,60,null,3290,3]
["Noah Rowland","2014-02-02",71000,9090,3410,"Finance",3,1,null,null,3,3410,null,9090,1]
["Christopher Guerra","2014-02-20",32000,5250,60,"R&D",1,3,null,null,1,60,null,5250,3]
["Oscar Keller","2014-02-21",36000,5210,700,"R&D",1,1,null,null,1,700,null,5210,1]
["Judah Robles","2014-03-07",81000,12600,60,"IT",4,1,null,null,4,60,null,12600,1]
["Hashim Vazquez","2014-03-10",85000,5910,60,"Customer Support",3,5,null,null,3,60,null,5910,5]
["Damian Silva","2014-03-14",52000,6810,4860,"Accounting",2,3,null,null,2,4860,null,6810,3]
["Linus Christian","2014-03-25",52000,5850,3420.0000000000005,"R&D",2,5,null,null,2,3420.0000000000005,null,5850,5]
["Cruz Chase","2014-03-29",58000,2670,4380,"Administration",1,2,null,null,1,4380,null,2670,2]
["Sawyer Byers","2014-03-29",84000,53050,60,"Sales",5,5,null,null,5,60,null,53050,5]
["Hasad Faulkner","2014-03-31",48000,2370,940,"Finance",3,4,null,null,3,940,null,2370,4]
["Jonah Mcintyre","2014-04-01",66000,9110,1300,"Finance",5,2,null,null,5,1300,null,9110,2]
["Hyatt Rogers","2014-04-04",76000,3930,6540,"R&D",2,1,null,null,2,6540,null,3930,1]
["Rajah Weber","2014-04-11",81000,12600,60,"IT",4,4,null,null,4,60,null,12600,4]
["Bradley Valenzuela","2014-04-18",31000,1860,2220,"Marketing",3,3,null,null,3,2220,null,1860,3]
["Drake Dominguez","2014-04-18",68000,6810,60,"IT",1,3,null,null,1,60,null,6810,3]
["Judah Suarez","2014-04-22",149000,17000,5860,"Administration",5,4,null,null,5,5860,null,17000,4]
["Brennan Walls","2014-04-23",68000,3610,60,"Administration",4,1,null,null,4,60,null,3610,1]
["Wylie Burris","2014-04-23",81000,29050,60,"Sales",2,5,null,null,2,60,null,29050,5]
["Wesley Conner","2014-04-29",38000,5130,3120,"IT",5,1,null,null,5,3120,null,5130,1]
["Oscar Dickerson","2014-05-10",58000,6450,3840.0000000000005,"Administration",3,2,null,null,3,3840.0000000000005,null,6450,2]
["Adam Curtis","2014-05-19",63000,9900,60,"Human Resources",2,4,null,null,2,60,null,9900,4]
["Dustin Harris","2014-05-19",69000,2350,1360,"Human Resources",4,2,null,null,4,1360,null,2350,2]
["Caldwell Shepherd","2014-05-22",51000,3870,530,"Human Resources",3,5,null,null,3,530,null,3870,5]
["Hector Madden","2014-06-02",49000,38050,60,"Sales",2,5,null,null,2,60,null,38050,5]
["Giacomo Parks","2014-06-03",93000,9060,60,"Marketing",3,3,null,null,3,60,null,9060,3]
["Barry Mccarthy","2014-06-15",66000,9110,3160,"R&D",6,5,null,null,6,3160,null,9110,5]
["Steel Stuart","2014-06-20",91000,8880,7890,"Customer Support",2,4,null,null,2,7890,null,8880,4]
["Bernard Wilkinson","2014-06-26",50000,3350,60,"Sales",6,2,null,null,6,60,null,3350,2]
["Kermit Duffy","2014-06-28",123000,11760,4820,"R&D",5,2,null,null,5,4820,null,11760,2]
["Griffith Nielsen","2014-07-05",81000,6440.0000000000009,60,"R&D",6,1,null,null,6,60,null,6440.0000000000009,1]
["Jasper Battle","2014-07-13",44000,2650,1660,"Finance",2,2,null,null,2,1660,null,2650,2]
["Wayne Golden","2014-07-19",61000,6180,3480,"Marketing",6,1,null,null,6,3480,null,6180,1]
["Gareth Wyatt","2014-07-27",76000,3210,2940,"Accounting",4,5,null,null,4,2940,null,3210,5]
["Harding Turner","2014-07-28",89000,2750,60,"IT",2,4,null,null,2,60,null,2750,4]
["Emerson Sellers","2014-08-07",69000,4950,60,"Marketing",6,5,null,null,6,60,null,4950,5]
["Simon Pratt","2014-08-11",80000,8650,2340,"R&D",4,1,null,null,4,2340,null,8650,1]
["Brennan Ellison","2014-08-19",52000,7290,540,"Marketing",3,1,null,null,3,540,null,7290,1]
["Ciaran Smith","2014-08-19",61000,5040,630,"Finance",3,3,null,null,3,630,null,5040,3]
["Geoffrey Small","2014-08-26",77000,2510,5170.0000000000009,"IT",6,1,null,null,6,5170.0000000000009,null,2510,1]
["Eaton Stevens","2014-08-30",127000,18270,4980,"Administration",5,2,null,null,5,4980,null,18270,2]
["Declan Larson","2014-09-02",81000,29050,60,"Sales",5,5,null,null,5,60,null,29050,5]
["Connor Baxter","2014-09-06",42000,2950,60,"IT",1,3,null,null,1,60,null,2950,3]
["Oscar Emerson","2014-09-20",49000,1950,60,"IT",1,5,null,null,1,60,null,1950,5]
["Dexter Hawkins","2014-10-07",109000,16800,60,"R&D",4,3,null,null,4,60,null,16800,3]
["Marvin Velasquez","2014-10-09",35000,3840,370,"Administration",6,5,null,null,6,370,null,3840,5]
["Flynn Guthrie","2014-10-22",98000,6690,60,"Human Resources",3,1,null,null,3,60,null,6690,1]
["Rashad Zimmerman","2014-10-24",71000,42050,60,"Sales",2,3,null,null,2,60,null,42050,3]
["Tiger Mcintosh","2014-10-25",43000,1830,450,"Marketing",4,3,null,null,4,450,null,1830,3]
["Stewart Wilcox","2014-10-28",64000,9450,60,"Sales",5,5,null,null,5,60,null,9450,5]
["Gabriel Ayala","2014-11-04",46000,3570,3840,"Accounting",5,4,null,null,5,3840,null,3570,4]
["Clayton Riddle","2014-11-09",63000,6360,650,"IT",1,5,null,null,1,650,null,6360,5]
["Lamar Howard","2014-11-18",38000,5470,2100,"Administration",5,3,null,null,5,2100,null,5470,3]
["Kuame Griffith","2014-11-25",56000,2610,3700.0000000000005,"R&D",6,2,null,null,6,3700.0000000000005,null,2610,2]
["Kenyon Petersen","2014-11-30",100000,5850,7740,"Finance",3,1,null,null,3,7740,null,5850,1]
["Fritz Klein","2014-12-05",20000,3130,220,"Finance",3,4,null,null,3,220,null,3130,4]
["Tiger Schultz","2014-12-18",35000,2290,990,"Human Resources",2,4,null,null,2,990,null,2290,4]
["Stone Bush","2014-12-28",87000,33050,60,"Sales",6,2,null,null,6,60,null,33050,2]
["Hyatt Edwards","2014-12-30",49000,6900,4560,"Administration",1,2,null,null,1,4560,null,6900,2]
["Darius Sandoval","2015-01-06",91000,14100,7020,"Marketing",4,1,null,null,4,7020,null,14100,1]
["Aidan Tyler","2015-01-29",63000,6950,60,"IT",6,4,null,null,6,60,null,6950,4]
["Nasim Hanson","2015-02-25",30000,4430,840,"Finance",5,5,null,null,5,840,null,4430,5]
["Vaughan Dean","2015-02-28",31000,5550,60,"Marketing",5,4,null,null,5,60,null,5550,4]
["Brandon Mckenzie","2015-02-28",59000,2150,60,"IT",5,3,null,null,5,60,null,2150,3]
["Luke Luna","2015-03-02",39000,4550,2160,"R&D",1,2,null,null,1,2160,null,4550,2]
["Dennis Nguyen","2015-03-03",67000,8610,60,"IT",3,2,null,null,3,60,null,8610,2]
["Graham Gibbs","2015-03-24",72000,9890,5500,"Human Resources",3,3,null,null,3,5500,null,9890,3]
["Hayes Gonzales","2015-03-26",39000,27050,60,"Sales",4,5,null,null,4,60,null,27050,5]
["Phelan Davidson","2015-04-07",47000,5780,60,"Sales",3,2,null,null,3,60,null,5780,2]
["Henry Holcomb","2015-04-20",57000,36050,60,"Sales",5,5,null,null,5,60,null,36050,5]
["Porter Le","2015-04-28",29000,1800,810,"Administration",4,5,null,null,4,810,null,1800,5]
["Patrick Hawkins","2015-05-24",62000,6270,5280,"Finance",6,4,null,null,6,5280,null,6270,4]
["Kasper Riley","2015-06-01",79000,10800,1560,"Administration",4,1,null,null,4,1560,null,10800,1]
["Sean Stark","2015-06-08",67000,4200,3840,"Accounting",4,3,null,null,4,3840,null,4200,3]
["Rafael Griffith","2015-06-09",84000,53050,60,"Sales",2,1,null,null,2,60,null,53050,1]
["Tad Carson","2015-06-20",63000,8130,1240,"Customer Support",3,2,null,null,3,1240,null,8130,2]
["Bevis Whitfield","2015-06-25",40000,3570.0000000000005,1860,"Marketing",1,1,null,null,1,1860,null,3570.0000000000005,1]
["Kenneth Booker","2015-06-29",89000,10400,60,"IT",4,4,null,null,4,60,null,10400,4]
["Lawrence Hicks","2015-07-03",52000,4890,4380,"Finance",5,5,null,null,5,4380,null,4890,5]
["Chester Baldwin","2015-07-20",67000,8610,4470,"IT",1,3,null,null,1,4470,null,8610,3]
["Ralph Alvarez","2015-07-29",58000,6450,4920,"Accounting",3,5,null,null,3,4920,null,6450,5]
["Clayton Cotton","2015-08-15",70000,3690,1380,"Accounting",1,3,null,null,1,1380,null,3690,3]
["Gavin Bell","2015-08-23",47000,43050,60,"Sales",4,4,null,null,4,60,null,43050,4]
["Felix Boyle","2015-09-07",58000,9150,1680,"R&D",3,1,null,null,3,1680,null,9150,1]
["Malcolm Hutchinson","2015-09-09",45000,3100,1700,"Human Resources",1,2,null,null,1,1700,null,3100,2]
["Garrison Bray","2015-09-16",114000,7650,5560,"Administration",3,5,null,null,3,5560,null,7650,5]
["Deacon Whitaker","2015-09-22",52000,7770.0000000000009,2460,"Accounting",5,3,null,null,5,2460,null,7770.0000000000009,3]
["Jerry Goodwin","2015-10-05",44000,6650.0000000000009,60,"Customer Support",6,5,null,null,6,60,null,6650.0000000000009,5]
[null,null,"Salary","Bonus","OT"]
[null,"sum",{"$f":"SUM(C3:C102)","v":6290000},{"$f":"SUM(D3:D102)","v":949140},184080,7423220,{"$f":"SUM(G3:G102)","v":337}]
[null,"average",{"$f":"AVERAGE(C3:C102)","v":62900},{"$f":"AVERAGE(D3:D102)","v":9491.4},{"$f":"AVERAGE(E3:E102)","v":1840.8},null,3.37,3.03]
[null,"max",{"$f":"MAX(C3:C102)","v":149000},{"$f":"MAX(D3:D102)","v":53050},7890,null,6,5]
[null,"min",{"$f":"MIN(C3:C102)","v":20000},{"$f":"MIN(D3:D102)","v":1800},60,null,1,1]
[null,"median",{"$f":"MEDIAN(C3:C102)","v":61500},{"$f":"MEDIAN(D3:D102)","v":6355},965,null,3,3]
[null,"mode",{"$f":"_xlfn.MODE.SNGL(C3:C102)","v":81000},{"$f":"_xlfn.MODE.SNGL(D3:D102)","v":2370},60,null,3,5]
[null,null,null,null,null,"SICK Count If"]
[null,null,null,null,null,1,{"$f":"COUNTIF(G3:G102,1)","v":18}]
[null,null,null,null,null,2,{"$f":"COUNTIF(G3:G102,2)","v":13}]
[null,null,null,null,null,3,{"$f":"COUNTIF(G3:G102,3)","v":24}]
[null,null,null,null,null,4,{"$f":"COUNTIF(G3:G102,4)","v":16}]
[null,null,null,null,null,5,{"$f":"COUNTIF(G3:G102,5)","v":17}]
[null,null,null,null,null,6,{"$f":"COUNTIF(G3:G102,6)","v":12}]
[null,null,null,null,null,null,null,"Perf","Bonus","OT"]
[null,"Count",null,null,null,"SICK Count If","AVG","AVG"]
[null,{"$f":"COUNTIF(F$3:F$102,\"Accounting\")","v":10},"Accounting",null,null,"Accounting",{"$f":"SUMIF(F3:F102,\"Accounting\", G3:G102)","v":32},{"$f":"SUMIF($F$3:$F$102,\"Accounting\", H$3:H$102)/$B$119","v":3.6},{"$f":"SUMIF($F$3:$F$102,\"Accounting\", D$3:D$102)/$B$119","v":5054},{"$f":"SUMIF($F$3:$F$102,\"Accounting\", E$3:E$102)/$B$119","v":2949}]
[null,{"$f":"COUNTIF(F$3:F$102,\"Administration\")","v":13},"Administration",null,null,"Administration",{"$f":"SUMIF(F3:F102,\"Administration\", G3:G102)","v":47},{"$f":"SUMIF(F$3:F$102,\"Administration\", H$3:H$102)/B120","v":2.6923076923076925},{"$f":"SUMIF($F$3:$F$102,\"Administration\", D$3:D$102)/$B$120","v":7578.4615384615381},{"$f":"SUMIF($F$3:$F$102,\"Administration\", E$3:E$102)/$B$120","v":3132.3076923076924}]
[null,{"$f":"COUNTIF(F$3:F$102,\"Customer Support\")","v":5},"Customer Support",null,null,"Customer Support",{"$f":"SUMIF(F3:F102,\"Customer Support\", G3:G102)","v":17},{"$f":"SUMIF(F$3:F$102,\"Customer Support\", H$3:H$102)/B121","v":3.8},{"$f":"SUMIF($F$3:$F$102,\"Customer Support\", D$3:D$102)/$B$121","v":6784},{"$f":"SUMIF($F$3:$F$102,\"Customer Support\", E$3:E$102)/$B$121","v":2462}]
[null,{"$f":"COUNTIF(F$3:F$102,\"Finance\")","v":10},"Finance",null,null,"Finance",{"$f":"SUMIF(F3:F102,\"Finance\", G3:G102)","v":38},{"$f":"SUMIF(F$3:F$102,\"Finance\", H$3:H$102)/B122","v":3.1},{"$f":"SUMIF($F$3:$F$102,\"Finance\", D$3:D$102)/$B$122","v":5283},{"$f":"SUMIF($F$3:$F$102,\"Finance\", E$3:E$102)/$B$122","v":2640}]
[null,{"$f":"COUNTIF(F$3:F$102,\"Human Resources\")","v":9},"Human Resources",null,null,"Human Resources",{"$f":"SUMIF(F3:F102,\"Human Resources\", G3:G102)","v":20},{"$f":"SUMIF(F$3:F$102,\"Human Resources\", H$3:H$102)/B123","v":2.7777777777777777},{"$f":"SUMIF($F$3:$F$102,\"Human Resources\", D$3:D$102)/$B$123","v":5368.8888888888887},{"$f":"SUMIF($F$3:$F$102,\"Human Resources\", E$3:E$102)/$B$123","v":1456.6666666666667}]
[null,{"$f":"COUNTIF(F$3:F$102,\"IT\")","v":15},"IT",null,null,"IT",{"$f":"SUMIF(F3:F102,\"IT\", G3:G102)","v":45},{"$f":"SUMIF(F$3:F$102,\"IT\", H$3:H$102)/B124","v":3.2},{"$f":"SUMIF($F$3:$F$102,\"IT\", D$3:D$102)/$B$124","v":6718.666666666667},{"$f":"SUMIF($F$3:$F$102,\"IT\", E$3:E$102)/$B$124","v":938}]
[null,{"$f":"COUNTIF(F$3:F$102,\"Marketing\")","v":11},"Marketing",null,null,"Marketing",{"$f":"SUMIF(F3:F102,\"Marketing\", G3:G102)","v":40},{"$f":"SUMIF(F$3:F$102,\"Marketing\", H$3:H$102)/B125","v":2.4545454545454546},{"$f":"SUMIF($F$3:$F$102,\"Marketing\", D$3:D$102)/$B$125","v":5737.272727272727},{"$f":"SUMIF($F$3:$F$102,\"Marketing\", E$3:E$102)/$B$125","v":1670.909090909091}]
[null,{"$f":"COUNTIF(F$3:F$102,\"R&D\")","v":14},"R&D",null,null,"R&D",{"$f":"SUMIF(F3:F102, \"R&D\", G3:G102)","v":47},{"$f":"SUMIF(F$3:F$102,\"R&D\", H$3:H$102)/B126","v":2.3571428571428572},{"$f":"SUMIF($F$3:$F$102,\"R&D\", D$3:D$102)/$B$126","v":7074.2857142857147},{"$f":"SUMIF($F$3:$F$102,\"R&D\", E$3:E$102)/$B$126","v":2058.5714285714284}]
[null,{"$f":"COUNTIF(F$3:F$102,\"Sales\")","v":13},"Sales",null,null,"Sales",{"$f":"SUMIF(F3:F102,\"Sales\", G3:G102)","v":51},{"$f":"SUMIF(F$3:F$102,\"Sales\", H$3:H$102)/B127","v":3.7692307692307692},{"$f":"SUMIF($F$3:$F$102,\"Sales\", D$3:D$102)/$B$127","v":30929.23076923077},{"$f":"SUMIF($F$3:$F$102,\"Sales\", E$3:E$102)/$B$127","v":60}]