{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["HR DashBoard","HR Data","PivotTable"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":7},"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":"HR DashBoard","index":0,"n_rows":32,"n_cols":25,"rows_kept":32,"cut":false,"hidden":false,"merged":[[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[29,3,29,4],[30,3,30,4],[25,3,25,4],[26,3,26,4],[35,2,35,3],[22,3,22,4],[23,3,23,4],[24,3,24,4],[27,3,27,4],[28,3,28,4],[21,3,21,4],[9,6,9,7],[10,6,11,7],[10,8,11,8],[9,10,9,11],[10,10,11,11],[20,3,20,4],[18,2,18,4],[16,2,16,4],[0,1,1,24],[6,6,6,8],[3,6,3,8],[3,10,3,12],[6,10,6,12],[3,14,3,16],[6,14,6,16],[4,22,5,24],[4,6,5,8],[3,18,3,20],[6,18,6,20],[4,10,5,12],[3,22,3,24],[6,22,6,24],[4,14,5,16],[4,18,5,20],[17,23,18,23],[17,24,18,24],[9,22,9,23],[10,22,11,23],[10,24,11,24],[7,22,8,24],[7,6,8,8],[10,14,11,15],[10,16,11,16],[9,18,9,19],[10,18,11,19],[10,20,11,20],[7,14,8,16],[7,18,8,20],[9,14,9,15],[7,10,8,12],[10,12,11,12]]}
[null,"HR DASHBOARD"]
[]
[null,null,null,null,"ü"]
[null,"ACCOUNTING",null,null,null,null,"Total Company Salary Spend",null,null,null,"Total Company Bonus Spend",null,null,null,"Total Company Overtime Spend",null,null,null,"Total Company Sickdays",null,null,null,"Total Company Performance Scores"]
[null,"ADMINISTRATION",null,null,null,null,{"$f":"'HR Data'!$D$118","v":6290000},null,null,null,{"$f":"'HR Data'!$E$118","v":949140},null,null,null,{"$f":"'HR Data'!$F$118","v":184080},null,null,null,{"$f":"'HR Data'!$G$118","v":337},null,null,null,{"$f":"'HR Data'!$H$118","v":303}]
[null,"CUSTOMER SUPPORT"]
[null,"FINANCE",null,null,null,null,"Selected Department(s) Salary Spend",null,null,null,"Selected Department(s) Bonus Spend",null,null,null,"Selected Department(s) Overtime Spend",null,null,null,"Selected Department(s) Sickdays",null,null,null,"Selected Department(s) Performance"]
[null,"HUMAN RESOURCES",null,null,null,null,{"$f":"'HR Data'!$D$117","v":0},null,null,null,{"$f":"'HR Data'!$E$117","v":0},null,null,null,{"$f":"'HR Data'!$F$117","v":0},null,null,null,{"$f":"'HR Data'!$G$117","v":0},null,null,null,{"$f":"'HR Data'!$H$117","v":0}]
[null,"IT"]
[null,"MARKETING",null,null,null,null,"Average Salary",null,"Selected",null,"Average Salary",null,"Selected",null,"Average Overtime",null,"Selected",null,"Average Sickdays",null,"Selected",null,"Average Performance",null,"Selected"]
[null,"R&D",null,null,null,null,{"$f":"$G$5/'HR Data'!$C$118","v":62900},null,{"$f":"IF($E$13=0,\"\",IF(($G$8/$E$13)>$G$11,\"é\",\"ê\"))","v":""},null,{"$f":"$K$5/'HR Data'!$C$118","v":9491.4},null,{"$f":"IF($E$13=0,\"\",IF(($K$8/$E$13)>$K$11,\"é\",\"ê\"))","v":""},null,{"$f":"$O$5/'HR Data'!$C$118","v":1840.8},null,{"$f":"IF($E$13=0,\"\",IF(($O$8/$E$13)>$O$11,\"é\",\"ê\"))","v":""},null,{"$f":"$S$5/'HR Data'!$C$118","v":3.37},null,{"$f":"IF($E$13=0,\"\",IF(($S$8/$E$13)>$S$11,\"é\",\"ê\"))","v":""},null,{"$f":"$W$5/'HR Data'!$C$118","v":3.03},null,{"$f":"IF($E$13=0,\"\",IF(($W$8/$E$13)>$W$11,\"é\",\"ê\"))","v":""}]
[null,"SALES"]
[null,null,null,"Selected Employees",{"$f":"'HR Data'!$C$117","v":0},null,"Selected Avg",{"$f":"IF($E$13=0,\"\",($G$8/$E$13))","v":""},{"$f":"IF($E$13=0,\"\",(($G$8/$E$13)-$G$11)/$G$11)","v":""},null,"Selected Avg",{"$f":"IF($E$13=0,\"\",($K$8/$E$13))","v":""},{"$f":"IF($E$13=0,\"\",(($K$8/$E$13)-$K$11)/$K$11)","v":""},null,"Selected Avg",{"$f":"IF($E$13=0,\"\",($O$8/$E$13))","v":""},{"$f":"IF($E$13=0,\"\",(($O$8/$E$13)-$O$11)/$O$11)","v":""},null,"Selected Avg",{"$f":"IF($E$13=0,\"\",($S$8/$E$13))","v":""},{"$f":"IF($E$13=0,\"\",(($S$8/$E$13)-$S$11)/$S$11)","v":""},null,"Selected Avg",{"$f":"IF($E$13=0,\"\",($W$8/$E$13))","v":""},{"$f":"IF($E$13=0,\"\",(($W$8/$E$13)-$W$11)/$W$11)","v":""}]
[]
[]
[]
[null,"Select Criteria: ",null,null,null,null,"Number of Employees by Salary",null,null,null,null,null,null,null,"Payroll Breakdown by Selected Departments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($X$32>0,\"Head Count\",\"\")","v":""},{"$f":"IF(X18=\"\",\"\",IF(C17=\"Overtime\",\"Overtime Avg ($)\",IF(C17=\"Bonus\",\"Bonus   Avg ($)\",IF(C17=\"Salary\",\"Salary   Avg ($)\",\"\"))))","v":""}]
[null,"Select Department: "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'HR Data'!C107","v":""},{"$f":"IF(X20=\"\",\"\",IF($C$17=\"Overtime\",'HR Data'!F107/X20,IF($C$17=\"Bonus\",'HR Data'!E107/X20,IF($C$17=\"Salary\",'HR Data'!D107/X20,\"\"))))","v":""}]
[null,"Employee Name","Dept",{"$f":"IF(C17=\"Performance Score\",\"Performance\",IF(C17=\"Sick Days\",\"Sick Days\",IF(C17=\"Overtime\",\"Overtime ($)\",IF(C17=\"Bonus\",\"Bonus ($)\",IF(C17=\"Salary\",\"Salary ($)\",\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'HR Data'!C108","v":""},{"$f":"IF(X21=\"\",\"\",IF($C$17=\"Overtime\",'HR Data'!F108/X21,IF($C$17=\"Bonus\",'HR Data'!E108/X21,IF($C$17=\"Salary\",'HR Data'!D108/X21,\"\"))))","v":""}]
[1,{"$f":"IF($D$21=\"Performance\",PivotTable!M5,IF($D$21=\"Sick Days\",PivotTable!J5,IF($D$21=\"Overtime ($)\",PivotTable!G5,IF($D$21=\"Bonus ($)\",PivotTable!D5,IF($D$21=\"Salary ($)\",PivotTable!A5,\"\")))))","v":""},{"$f":"IF(B22=\"\",\"\",IF(ISERROR(VLOOKUP(B22,dept,8,FALSE)),0,VLOOKUP(B22,dept,8,FALSE)))","v":""},{"$f":"IF($D$21=\"Performance\",PivotTable!N5,IF($D$21=\"Sick Days\",PivotTable!K5,IF($D$21=\"Overtime ($)\",PivotTable!H5,IF($D$21=\"Bonus ($)\",PivotTable!E5,IF($D$21=\"Salary ($)\",PivotTable!B5,\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'HR Data'!C109","v":""},{"$f":"IF(X22=\"\",\"\",IF($C$17=\"Overtime\",'HR Data'!F109/X22,IF($C$17=\"Bonus\",'HR Data'!E109/X22,IF($C$17=\"Salary\",'HR Data'!D109/X22,\"\"))))","v":""}]
[2,{"$f":"IF($D$21=\"Performance\",PivotTable!M6,IF($D$21=\"Sick Days\",PivotTable!J6,IF($D$21=\"Overtime ($)\",PivotTable!G6,IF($D$21=\"Bonus ($)\",PivotTable!D6,IF($D$21=\"Salary ($)\",PivotTable!A6,\"\")))))","v":""},"",{"$f":"IF($D$21=\"Performance\",PivotTable!N6,IF($D$21=\"Sick Days\",PivotTable!K6,IF($D$21=\"Overtime ($)\",PivotTable!H6,IF($D$21=\"Bonus ($)\",PivotTable!E6,IF($D$21=\"Salary ($)\",PivotTable!B6,\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'HR Data'!C110","v":""},{"$f":"IF(X23=\"\",\"\",IF($C$17=\"Overtime\",'HR Data'!F110/X23,IF($C$17=\"Bonus\",'HR Data'!E110/X23,IF($C$17=\"Salary\",'HR Data'!D110/X23,\"\"))))","v":""}]
[3,{"$f":"IF($D$21=\"Performance\",PivotTable!M7,IF($D$21=\"Sick Days\",PivotTable!J7,IF($D$21=\"Overtime ($)\",PivotTable!G7,IF($D$21=\"Bonus ($)\",PivotTable!D7,IF($D$21=\"Salary ($)\",PivotTable!A7,\"\")))))","v":""},"",{"$f":"IF($D$21=\"Performance\",PivotTable!N7,IF($D$21=\"Sick Days\",PivotTable!K7,IF($D$21=\"Overtime ($)\",PivotTable!H7,IF($D$21=\"Bonus ($)\",PivotTable!E7,IF($D$21=\"Salary ($)\",PivotTable!B7,\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'HR Data'!C111","v":""},{"$f":"IF(X24=\"\",\"\",IF($C$17=\"Overtime\",'HR Data'!F111/X24,IF($C$17=\"Bonus\",'HR Data'!E111/X24,IF($C$17=\"Salary\",'HR Data'!D111/X24,\"\"))))","v":""}]
[4,{"$f":"IF($D$21=\"Performance\",PivotTable!M8,IF($D$21=\"Sick Days\",PivotTable!J8,IF($D$21=\"Overtime ($)\",PivotTable!G8,IF($D$21=\"Bonus ($)\",PivotTable!D8,IF($D$21=\"Salary ($)\",PivotTable!A8,\"\")))))","v":""},"",{"$f":"IF($D$21=\"Performance\",PivotTable!N8,IF($D$21=\"Sick Days\",PivotTable!K8,IF($D$21=\"Overtime ($)\",PivotTable!H8,IF($D$21=\"Bonus ($)\",PivotTable!E8,IF($D$21=\"Salary ($)\",PivotTable!B8,\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'HR Data'!C112","v":""},{"$f":"IF(X25=\"\",\"\",IF($C$17=\"Overtime\",'HR Data'!F112/X25,IF($C$17=\"Bonus\",'HR Data'!E112/X25,IF($C$17=\"Salary\",'HR Data'!D112/X25,\"\"))))","v":""}]
[5,{"$f":"IF($D$21=\"Performance\",PivotTable!M9,IF($D$21=\"Sick Days\",PivotTable!J9,IF($D$21=\"Overtime ($)\",PivotTable!G9,IF($D$21=\"Bonus ($)\",PivotTable!D9,IF($D$21=\"Salary ($)\",PivotTable!A9,\"\")))))","v":""},"",{"$f":"IF($D$21=\"Performance\",PivotTable!N9,IF($D$21=\"Sick Days\",PivotTable!K9,IF($D$21=\"Overtime ($)\",PivotTable!H9,IF($D$21=\"Bonus ($)\",PivotTable!E9,IF($D$21=\"Salary ($)\",PivotTable!B9,\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'HR Data'!C113","v":""},{"$f":"IF(X26=\"\",\"\",IF($C$17=\"Overtime\",'HR Data'!F113/X26,IF($C$17=\"Bonus\",'HR Data'!E113/X26,IF($C$17=\"Salary\",'HR Data'!D113/X26,\"\"))))","v":""}]
[6,{"$f":"IF($D$21=\"Performance\",PivotTable!M10,IF($D$21=\"Sick Days\",PivotTable!J10,IF($D$21=\"Overtime ($)\",PivotTable!G10,IF($D$21=\"Bonus ($)\",PivotTable!D10,IF($D$21=\"Salary ($)\",PivotTable!A10,\"\")))))","v":""},"",{"$f":"IF($D$21=\"Performance\",PivotTable!N10,IF($D$21=\"Sick Days\",PivotTable!K10,IF($D$21=\"Overtime ($)\",PivotTable!H10,IF($D$21=\"Bonus ($)\",PivotTable!E10,IF($D$21=\"Salary ($)\",PivotTable!B10,\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'HR Data'!C114","v":""},{"$f":"IF(X27=\"\",\"\",IF($C$17=\"Overtime\",'HR Data'!F114/X27,IF($C$17=\"Bonus\",'HR Data'!E114/X27,IF($C$17=\"Salary\",'HR Data'!D114/X27,\"\"))))","v":""}]
[7,{"$f":"IF($D$21=\"Performance\",PivotTable!M11,IF($D$21=\"Sick Days\",PivotTable!J11,IF($D$21=\"Overtime ($)\",PivotTable!G11,IF($D$21=\"Bonus ($)\",PivotTable!D11,IF($D$21=\"Salary ($)\",PivotTable!A11,\"\")))))","v":""},"",{"$f":"IF($D$21=\"Performance\",PivotTable!N11,IF($D$21=\"Sick Days\",PivotTable!K11,IF($D$21=\"Overtime ($)\",PivotTable!H11,IF($D$21=\"Bonus ($)\",PivotTable!E11,IF($D$21=\"Salary ($)\",PivotTable!B11,\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'HR Data'!C115","v":""},{"$f":"IF(X28=\"\",\"\",IF($C$17=\"Overtime\",'HR Data'!F115/X28,IF($C$17=\"Bonus\",'HR Data'!E115/X28,IF($C$17=\"Salary\",'HR Data'!D115/X28,\"\"))))","v":""}]
[8,{"$f":"IF($D$21=\"Performance\",PivotTable!M12,IF($D$21=\"Sick Days\",PivotTable!J12,IF($D$21=\"Overtime ($)\",PivotTable!G12,IF($D$21=\"Bonus ($)\",PivotTable!D12,IF($D$21=\"Salary ($)\",PivotTable!A12,\"\")))))","v":""},"",{"$f":"IF($D$21=\"Performance\",PivotTable!N12,IF($D$21=\"Sick Days\",PivotTable!K12,IF($D$21=\"Overtime ($)\",PivotTable!H12,IF($D$21=\"Bonus ($)\",PivotTable!E12,IF($D$21=\"Salary ($)\",PivotTable!B12,\"\")))))","v":""}]
[9,{"$f":"IF($D$21=\"Performance\",PivotTable!M13,IF($D$21=\"Sick Days\",PivotTable!J13,IF($D$21=\"Overtime ($)\",PivotTable!G13,IF($D$21=\"Bonus ($)\",PivotTable!D13,IF($D$21=\"Salary ($)\",PivotTable!A13,\"\")))))","v":""},"",{"$f":"IF($D$21=\"Performance\",PivotTable!N13,IF($D$21=\"Sick Days\",PivotTable!K13,IF($D$21=\"Overtime ($)\",PivotTable!H13,IF($D$21=\"Bonus ($)\",PivotTable!E13,IF($D$21=\"Salary ($)\",PivotTable!B13,\"\")))))","v":""}]
[10,{"$f":"IF($D$21=\"Performance\",PivotTable!M14,IF($D$21=\"Sick Days\",PivotTable!J14,IF($D$21=\"Overtime ($)\",PivotTable!G14,IF($D$21=\"Bonus ($)\",PivotTable!D14,IF($D$21=\"Salary ($)\",PivotTable!A14,\"\")))))","v":""},"",{"$f":"IF($D$21=\"Performance\",PivotTable!N14,IF($D$21=\"Sick Days\",PivotTable!K14,IF($D$21=\"Overtime ($)\",PivotTable!H14,IF($D$21=\"Bonus ($)\",PivotTable!E14,IF($D$21=\"Salary ($)\",PivotTable!B14,\"\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X20:X31)","v":0}]

{"sheet":"HR Data","index":1,"n_rows":118,"n_cols":9,"rows_kept":118,"cut":false,"hidden":false,"merged":[]}
["Department","Full Name","Hire Date","Salary","Bonus","Overtime","Sick Days","Performance Score","Dept"]
["Finance","Fritz Klein","2014-12-05",20000,3130,220,3,4,"Finance"]
["Administration","Porter Le","2015-04-28",29000,1800,810,4,5,"Admin"]
["Human Resources","Oren Chase","2013-12-26",29000,2550,810,1,1,"HR"]
["Finance","Nasim Hanson","2015-02-25",30000,4430,840,5,5,"Finance"]
["Marketing","Bradley Valenzuela","2014-04-18",31000,1860,2220,3,3,"Mrkt'ng"]
["Marketing","Vaughan Dean","2015-02-28",31000,5550,60,5,4,"Mrkt'ng"]
["R&D","Christopher Guerra","2014-02-20",32000,5250,60,1,3,"R&D"]
["Administration","Ishmael Grimes","2013-12-20",32000,4690,1460,1,2,"Admin"]
["Customer Support","Ferdinand Small","2014-01-23",34000,4350,3060,3,3,"CS"]
["Accounting","Asher Benson","2013-11-20",34000,2850,1860,1,5,"Acts"]
["Administration","Marvin Velasquez","2014-10-09",35000,3840,370,6,5,"Admin"]
["Human Resources","Tiger Schultz","2014-12-18",35000,2290,990,2,4,"HR"]
["R&D","Kasimir Mccoy","2014-01-29",36000,3290,60,3,3,"R&D"]
["R&D","Oscar Keller","2014-02-21",36000,5210,700,1,1,"R&D"]
["Administration","Lamar Howard","2014-11-18",38000,5470,2100,5,3,"Admin"]
["IT","Wesley Conner","2014-04-29",38000,5130,3120,5,1,"IT"]
["Accounting","Hu Frost","2014-01-15",39000,2800,1110,3,4,"Acts"]
["R&D","Luke Luna","2015-03-02",39000,4550,2160,1,2,"R&D"]
["Sales","Hayes Gonzales","2015-03-26",39000,27050,60,4,5,"Sales"]
["Marketing","Bevis Whitfield","2015-06-25",40000,3570.0000000000005,1860,1,1,"Mrkt'ng"]
["IT","Connor Baxter","2014-09-06",42000,2950,60,1,3,"IT"]
["Marketing","Tiger Mcintosh","2014-10-25",43000,1830,450,4,3,"Mrkt'ng"]
["Customer Support","Jerry Goodwin","2015-10-05",44000,6650.0000000000009,60,6,5,"CS"]
["Finance","Jasper Battle","2014-07-13",44000,2650,1660,2,2,"Finance"]
["Human Resources","Malcolm Hutchinson","2015-09-09",45000,3100,1700,1,2,"HR"]
["Accounting","Gabriel Ayala","2014-11-04",46000,3570,3840,5,4,"Acts"]
["Sales","Phelan Davidson","2015-04-07",47000,5780,60,3,2,"Sales"]
["Sales","Gavin Bell","2015-08-23",47000,43050,60,4,4,"Sales"]
["Finance","Hasad Faulkner","2014-03-31",48000,2370,940,3,4,"Finance"]
["Sales","Hector Madden","2014-06-02",49000,38050,60,2,5,"Sales"]
["Administration","Hyatt Edwards","2014-12-30",49000,6900,4560,1,2,"Admin"]
["IT","Oscar Emerson","2014-09-20",49000,1950,60,1,5,"IT"]
["Sales","Bernard Wilkinson","2014-06-26",50000,3350,60,6,2,"Sales"]
["Human Resources","Caldwell Shepherd","2014-05-22",51000,3870,530,3,5,"HR"]
["Accounting","Damian Silva","2014-03-14",52000,6810,4860,2,3,"Acts"]
["Finance","Lawrence Hicks","2015-07-03",52000,4890,4380,5,5,"Finance"]
["Accounting","Deacon Whitaker","2015-09-22",52000,7770.0000000000009,2460,5,3,"Acts"]
["Marketing","Brennan Ellison","2014-08-19",52000,7290,540,3,1,"Mrkt'ng"]
["R&D","Linus Christian","2014-03-25",52000,5850,3420.0000000000005,2,5,"R&D"]
["Human Resources","Elmo Abbott","2013-12-20",55000,7680,2100,1,3,"HR"]
["R&D","Kuame Griffith","2014-11-25",56000,2610,3700.0000000000005,6,2,"R&D"]
["Sales","Henry Holcomb","2015-04-20",57000,36050,60,5,5,"Sales"]
["Marketing","Chandler Stevens","2013-11-07",57000,6350,590,2,1,"Mrkt'ng"]
["Administration","Oscar Dickerson","2014-05-10",58000,6450,3840.0000000000005,3,2,"Admin"]
["Administration","Cruz Chase","2014-03-29",58000,2670,4380,1,2,"Admin"]
["Accounting","Ralph Alvarez","2015-07-29",58000,6450,4920,3,5,"Acts"]
["R&D","Felix Boyle","2015-09-07",58000,9150,1680,3,1,"R&D"]
["IT","Brandon Mckenzie","2015-02-28",59000,2150,60,5,3,"IT"]
["Finance","Ciaran Smith","2014-08-19",61000,5040,630,3,3,"Finance"]
["Marketing","Wayne Golden","2014-07-19",61000,6180,3480,6,1,"Mrkt'ng"]
["Finance","Patrick Hawkins","2015-05-24",62000,6270,5280,6,4,"Finance"]
["Human Resources","Adam Curtis","2014-05-19",63000,9900,60,2,4,"HR"]
["IT","Aidan Tyler","2015-01-29",63000,6950,60,6,4,"IT"]
["IT","Clayton Riddle","2014-11-09",63000,6360,650,1,5,"IT"]
["Customer Support","Tad Carson","2015-06-20",63000,8130,1240,3,2,"CS"]
["Sales","Stewart Wilcox","2014-10-28",64000,9450,60,5,5,"Sales"]
["R&D","Barry Mccarthy","2014-06-15",66000,9110,3160,6,5,"R&D"]
["Finance","Jonah Mcintyre","2014-04-01",66000,9110,1300,5,2,"Finance"]
["IT","Chester Baldwin","2015-07-20",67000,8610,4470,1,3,"IT"]
["IT","Dennis Nguyen","2015-03-03",67000,8610,60,3,2,"IT"]
["Accounting","Sean Stark","2015-06-08",67000,4200,3840,4,3,"Acts"]
["Administration","Brennan Walls","2014-04-23",68000,3610,60,4,1,"Admin"]
["Administration","Marvin Moses","2013-11-26",68000,9370,5180,5,1,"Admin"]
["IT","Drake Dominguez","2014-04-18",68000,6810,60,1,3,"IT"]
["Marketing","Emerson Sellers","2014-08-07",69000,4950,60,6,5,"Mrkt'ng"]
["Human Resources","Dustin Harris","2014-05-19",69000,2350,1360,4,2,"HR"]
["Accounting","Clayton Cotton","2015-08-15",70000,3690,1380,1,3,"Acts"]
["Marketing","Ferris Knight","2013-11-12",70000,2370,2040,3,4,"Mrkt'ng"]
["Sales","Rashad Zimmerman","2014-10-24",71000,42050,60,2,3,"Sales"]
["Finance","Noah Rowland","2014-02-02",71000,9090,3410,3,1,"Finance"]
["Human Resources","Graham Gibbs","2015-03-24",72000,9890,5500,3,3,"HR"]
["R&D","Hyatt Rogers","2014-04-04",76000,3930,6540,2,1,"R&D"]
["Accounting","Gareth Wyatt","2014-07-27",76000,3210,2940,4,5,"Acts"]
["IT","Geoffrey Small","2014-08-26",77000,2510,5170.0000000000009,6,1,"IT"]
["Accounting","Melvin Pickett","2013-11-07",78000,9190,2280,4,1,"Acts"]
["Administration","Kasper Riley","2015-06-01",79000,10800,1560,4,1,"Admin"]
["R&D","Simon Pratt","2014-08-11",80000,8650,2340,4,1,"R&D"]
["IT","Rajah Weber","2014-04-11",81000,12600,60,4,4,"IT"]
["R&D","Griffith Nielsen","2014-07-05",81000,6440.0000000000009,60,6,1,"R&D"]
["Sales","Declan Larson","2014-09-02",81000,29050,60,5,5,"Sales"]
["Sales","Sawyer Byers","2014-03-29",84000,53050,60,5,5,"Sales"]
["Customer Support","Hashim Vazquez","2014-03-10",85000,5910,60,3,5,"CS"]
["Sales","Stone Bush","2014-12-28",87000,33050,60,6,2,"Sales"]
["IT","Harding Turner","2014-07-28",89000,2750,60,2,4,"IT"]
["IT","Jesse Barron","2013-11-12",89000,10400,60,1,5,"IT"]
["IT","Kenneth Booker","2015-06-29",89000,10400,60,4,4,"IT"]
["Customer Support","Steel Stuart","2014-06-20",91000,8880,7890,2,4,"CS"]
["Marketing","Darius Sandoval","2015-01-06",91000,14100,7020,4,1,"Mrkt'ng"]
["Marketing","Giacomo Parks","2014-06-03",93000,9060,60,3,3,"Mrkt'ng"]
["Human Resources","Flynn Guthrie","2014-10-22",98000,6690,60,3,1,"HR"]
["Finance","Kenyon Petersen","2014-11-30",100000,5850,7740,3,1,"Finance"]
["R&D","Dexter Hawkins","2014-10-07",109000,16800,60,4,3,"R&D"]
["Administration","Garrison Bray","2015-09-16",114000,7650,5560,3,5,"Admin"]
["R&D","Kermit Duffy","2014-06-28",123000,11760,4820,5,2,"R&D"]
["Administration","Eaton Stevens","2014-08-30",127000,18270,4980,5,2,"Admin"]
["Administration","Judah Suarez","2014-04-22",149000,17000,5860,5,4,"Admin"]
["IT","Judah Robles","2014-03-07",81000,12600,60,4,1,"IT"]
["R&D","Byron Foreman","2014-01-08",81000,6440.0000000000009,60,3,3,"R&D"]
["Sales","Wylie Burris","2014-04-23",81000,29050,60,2,5,"Sales"]
["Sales","Rafael Griffith","2015-06-09",84000,53050,60,2,1,"Sales"]
[]
[null,"No of Employees ",{"$f":"SUBTOTAL(3,B2:B101)","v":100},{"$f":"SUBTOTAL(9,D2:D101)","v":6290000},{"$f":"SUBTOTAL(9,E2:E101)","v":949140},{"$f":"SUBTOTAL(9,F2:F101)","v":184080},{"$f":"SUBTOTAL(9,G2:G101)","v":337},{"$f":"SUBTOTAL(9,H2:H101)","v":303}]
[]
[]
[null,"Departments","No of Employees","Salary","Bonus","Overtime","Sick Days","Performance Score","Inc"]
[null,"Accounting",{"$f":"IF($I107=\"\",\"\",COUNTIF($A$2:$A$101,$B107))","v":""},{"$f":"IF(I107=\"\",\"\",SUMIF($A$2:$A$101,$B107,$D$2:$D$102))","v":""},{"$f":"IF(I107=\"\",\"\",SUMIF($A$2:$A$101,$B107,$E$2:$E$102))","v":""},{"$f":"IF(I107=\"\",\"\",SUMIF($A$2:$A$101,$B107,$F$2:$F$102))","v":""},{"$f":"IF(I107=\"\",\"\",SUMIF($A$2:$A$101,$B107,$G$2:$G$102))","v":""},{"$f":"IF(I107=\"\",\"\",SUMIF($A$2:$A$101,$B107,$H$2:$H$102))","v":""},{"$f":"IF('HR DashBoard'!$E4=\"\",\"\",('HR DashBoard'!$E4))","v":""}]
[null,"Administration","","","","","","",{"$f":"IF('HR DashBoard'!$E5=\"\",\"\",('HR DashBoard'!$E5))","v":""}]
[null,"Customer Support","","","","","","",{"$f":"IF('HR DashBoard'!$E6=\"\",\"\",('HR DashBoard'!$E6))","v":""}]
[null,"Finance","","","","","","",{"$f":"IF('HR DashBoard'!$E7=\"\",\"\",('HR DashBoard'!$E7))","v":""}]
[null,"Human Resources","","","","","","",{"$f":"IF('HR DashBoard'!$E8=\"\",\"\",('HR DashBoard'!$E8))","v":""}]
[null,"IT","","","","","","",{"$f":"IF('HR DashBoard'!$E9=\"\",\"\",('HR DashBoard'!$E9))","v":""}]
[null,"Marketing","","","","","","",{"$f":"IF('HR DashBoard'!$E10=\"\",\"\",('HR DashBoard'!$E10))","v":""}]
[null,"R&D","","","","","","",{"$f":"IF('HR DashBoard'!$E11=\"\",\"\",('HR DashBoard'!$E11))","v":""}]
[null,"Sales","","","","","","",{"$f":"IF('HR DashBoard'!$E12=\"\",\"\",('HR DashBoard'!$E12))","v":""}]
[]
[null,"Selected",{"$f":"SUM(C107:C116)","v":0},{"$f":"SUM(D107:D116)","v":0},{"$f":"SUM(E107:E115)","v":0},{"$f":"SUM(F107:F115)","v":0},{"$f":"SUM(G107:G116)","v":0},{"$f":"SUM(H107:H116)","v":0}]
[null,"Totals",{"$f":"C103","v":100},6290000,949140,184080,337,303]

{"sheet":"PivotTable","index":2,"n_rows":115,"n_cols":17,"rows_kept":115,"cut":false,"hidden":false,"merged":[]}
["Department","(All)",null,"Department","(All)",null,"Department","(All)",null,"Department","(All)",null,"Department","(All)"]
["Hire Date","(All)",null,"Hire Date","(All)",null,"Hire Date","(All)",null,"Hire Date","(All)",null,"Hire Date","(All)"]
[]
["Row Labels","Sum of Salary",null,"Row Labels","Sum of Bonus",null,"Row Labels","Sum of Overtime",null,"Row Labels","Sum of Sick Days",null,"Row Labels","Sum of Performance Score",null,"Row Labels","Count of Full Name"]
["Judah Suarez",149000,null,"Sawyer Byers",53050,null,"Steel Stuart",7890,null,"Wayne Golden",6,null,"Linus Christian",5,null,"<$30,000",4]
["Eaton Stevens",127000,null,"Rafael Griffith",53050,null,"Kenyon Petersen",7740,null,"Stone Bush",6,null,"Wylie Burris",5,null,"$30,000-$40,000",15]
["Kermit Duffy",123000,null,"Gavin Bell",43050,null,"Darius Sandoval",7020,null,"Marvin Velasquez",6,null,"Porter Le",5,null,"$40,000-$50,000",13]
["Garrison Bray",114000,null,"Rashad Zimmerman",42050,null,"Hyatt Rogers",6540,null,"Aidan Tyler",6,null,"Asher Benson",5,null,"$50,000-$60,000",16]
["Dexter Hawkins",109000,null,"Hector Madden",38050,null,"Judah Suarez",5860,null,"Griffith Nielsen",6,null,"Jesse Barron",5,null,"$60,000-$70,000",18]
["Kenyon Petersen",100000,null,"Henry Holcomb",36050,null,"Garrison Bray",5560,null,"Barry Mccarthy",6,null,"Barry Mccarthy",5,null,"$70,000-$80,000",10]
["Flynn Guthrie",98000,null,"Stone Bush",33050,null,"Graham Gibbs",5500,null,"Kuame Griffith",6,null,"Nasim Hanson",5,null,"$80,000-$90,000",14]
["Giacomo Parks",93000,null,"Wylie Burris",29050,null,"Patrick Hawkins",5280,null,"Bernard Wilkinson",6,null,"Caldwell Shepherd",5,null,"$90,000-$100,000",4]
["Darius Sandoval",91000,null,"Declan Larson",29050,null,"Marvin Moses",5180,null,"Patrick Hawkins",6,null,"Sawyer Byers",5,null,">$100,000",6]
["Steel Stuart",91000,null,"Hayes Gonzales",27050,null,"Geoffrey Small",5170.0000000000009,null,"Emerson Sellers",6,null,"Clayton Riddle",5]
["Kenneth Booker",89000,null,"Eaton Stevens",18270,null,"Eaton Stevens",4980,null,"Geoffrey Small",6,null,"Jerry Goodwin",5]
["Jesse Barron",89000,null,"Judah Suarez",17000,null,"Ralph Alvarez",4920,null,"Jerry Goodwin",6,null,"Declan Larson",5]
["Harding Turner",89000,null,"Dexter Hawkins",16800,null,"Damian Silva",4860,null,"Marvin Moses",5,null,"Lawrence Hicks",5]
["Stone Bush",87000,null,"Darius Sandoval",14100,null,"Kermit Duffy",4820,null,"Sawyer Byers",5,null,"Emerson Sellers",5]
["Hashim Vazquez",85000,null,"Rajah Weber",12600,null,"Hyatt Edwards",4560,null,"Nasim Hanson",5,null,"Marvin Velasquez",5]
["Sawyer Byers",84000,null,"Judah Robles",12600,null,"Chester Baldwin",4470,null,"Eaton Stevens",5,null,"Gareth Wyatt",5]
["Rafael Griffith",84000,null,"Kermit Duffy",11760,null,"Lawrence Hicks",4380,null,"Declan Larson",5,null,"Oscar Emerson",5]
["Byron Foreman",81000,null,"Kasper Riley",10800,null,"Cruz Chase",4380,null,"Judah Suarez",5,null,"Garrison Bray",5]
["Judah Robles",81000,null,"Kenneth Booker",10400,null,"Oscar Dickerson",3840.0000000000005,null,"Gabriel Ayala",5,null,"Ralph Alvarez",5]
["Declan Larson",81000,null,"Jesse Barron",10400,null,"Sean Stark",3840,null,"Kermit Duffy",5,null,"Hashim Vazquez",5]
["Wylie Burris",81000,null,"Adam Curtis",9900,null,"Gabriel Ayala",3840,null,"Deacon Whitaker",5,null,"Stewart Wilcox",5]
["Rajah Weber",81000,null,"Graham Gibbs",9890,null,"Kuame Griffith",3700.0000000000005,null,"Brandon Mckenzie",5,null,"Hayes Gonzales",5]
["Griffith Nielsen",81000,null,"Stewart Wilcox",9450,null,"Wayne Golden",3480,null,"Stewart Wilcox",5,null,"Hector Madden",5]
["Simon Pratt",80000,null,"Marvin Moses",9370,null,"Linus Christian",3420.0000000000005,null,"Lamar Howard",5,null,"Henry Holcomb",5]
["Kasper Riley",79000,null,"Melvin Pickett",9190,null,"Noah Rowland",3410,null,"Vaughan Dean",5,null,"Tiger Schultz",4]
["Melvin Pickett",78000,null,"Felix Boyle",9150,null,"Barry Mccarthy",3160,null,"Lawrence Hicks",5,null,"Kenneth Booker",4]
["Geoffrey Small",77000,null,"Barry Mccarthy",9110,null,"Wesley Conner",3120,null,"Wesley Conner",5,null,"Hu Frost",4]
["Hyatt Rogers",76000,null,"Jonah Mcintyre",9110,null,"Ferdinand Small",3060,null,"Jonah Mcintyre",5,null,"Ferris Knight",4]
["Gareth Wyatt",76000,null,"Noah Rowland",9090,null,"Gareth Wyatt",2940,null,"Henry Holcomb",5,null,"Rajah Weber",4]
["Graham Gibbs",72000,null,"Giacomo Parks",9060,null,"Deacon Whitaker",2460,null,"Tiger Mcintosh",4,null,"Fritz Klein",4]
["Rashad Zimmerman",71000,null,"Steel Stuart",8880,null,"Simon Pratt",2340,null,"Rajah Weber",4,null,"Adam Curtis",4]
["Noah Rowland",71000,null,"Simon Pratt",8650,null,"Melvin Pickett",2280,null,"Darius Sandoval",4,null,"Gabriel Ayala",4]
["Ferris Knight",70000,null,"Chester Baldwin",8610,null,"Bradley Valenzuela",2220,null,"Brennan Walls",4,null,"Vaughan Dean",4]
["Clayton Cotton",70000,null,"Dennis Nguyen",8610,null,"Luke Luna",2160,null,"Simon Pratt",4,null,"Gavin Bell",4]
["Emerson Sellers",69000,null,"Tad Carson",8130,null,"Elmo Abbott",2100,null,"Gareth Wyatt",4,null,"Patrick Hawkins",4]
["Dustin Harris",69000,null,"Deacon Whitaker",7770.0000000000009,null,"Lamar Howard",2100,null,"Melvin Pickett",4,null,"Harding Turner",4]
["Brennan Walls",68000,null,"Elmo Abbott",7680,null,"Ferris Knight",2040,null,"Gavin Bell",4,null,"Steel Stuart",4]
["Drake Dominguez",68000,null,"Garrison Bray",7650,null,"Bevis Whitfield",1860,null,"Porter Le",4,null,"Hasad Faulkner",4]
["Marvin Moses",68000,null,"Brennan Ellison",7290,null,"Asher Benson",1860,null,"Hayes Gonzales",4,null,"Aidan Tyler",4]
["Chester Baldwin",67000,null,"Aidan Tyler",6950,null,"Malcolm Hutchinson",1700,null,"Sean Stark",4,null,"Judah Suarez",4]
["Sean Stark",67000,null,"Hyatt Edwards",6900,null,"Felix Boyle",1680,null,"Dustin Harris",4,null,"Damian Silva",3]
["Dennis Nguyen",67000,null,"Damian Silva",6810,null,"Jasper Battle",1660,null,"Dexter Hawkins",4,null,"Bradley Valenzuela",3]
["Barry Mccarthy",66000,null,"Drake Dominguez",6810,null,"Kasper Riley",1560,null,"Kasper Riley",4,null,"Deacon Whitaker",3]
["Jonah Mcintyre",66000,null,"Flynn Guthrie",6690,null,"Ishmael Grimes",1460,null,"Kenneth Booker",4,null,"Byron Foreman",3]
["Stewart Wilcox",64000,null,"Jerry Goodwin",6650.0000000000009,null,"Clayton Cotton",1380,null,"Judah Robles",4,null,"Connor Baxter",3]
["Clayton Riddle",63000,null,"Ralph Alvarez",6450,null,"Dustin Harris",1360,null,"Ralph Alvarez",3,null,"Ferdinand Small",3]
["Tad Carson",63000,null,"Oscar Dickerson",6450,null,"Jonah Mcintyre",1300,null,"Hashim Vazquez",3,null,"Sean Stark",3]
["Adam Curtis",63000,null,"Griffith Nielsen",6440.0000000000009,null,"Tad Carson",1240,null,"Dennis Nguyen",3,null,"Dexter Hawkins",3]
["Aidan Tyler",63000,null,"Byron Foreman",6440.0000000000009,null,"Hu Frost",1110,null,"Ferris Knight",3,null,"Elmo Abbott",3]
["Patrick Hawkins",62000,null,"Clayton Riddle",6360,null,"Tiger Schultz",990,null,"Ferdinand Small",3,null,"Drake Dominguez",3]
["Ciaran Smith",61000,null,"Chandler Stevens",6350,null,"Hasad Faulkner",940,null,"Hu Frost",3,null,"Clayton Cotton",3]
["Wayne Golden",61000,null,"Patrick Hawkins",6270,null,"Nasim Hanson",840,null,"Giacomo Parks",3,null,"Chester Baldwin",3]
["Brandon Mckenzie",59000,null,"Wayne Golden",6180,null,"Oren Chase",810,null,"Flynn Guthrie",3,null,"Giacomo Parks",3]
["Ralph Alvarez",58000,null,"Hashim Vazquez",5910,null,"Porter Le",810,null,"Tad Carson",3,null,"Kasimir Mccoy",3]
["Oscar Dickerson",58000,null,"Kenyon Petersen",5850,null,"Oscar Keller",700,null,"Kasimir Mccoy",3,null,"Rashad Zimmerman",3]
["Cruz Chase",58000,null,"Linus Christian",5850,null,"Clayton Riddle",650,null,"Phelan Davidson",3,null,"Brandon Mckenzie",3]
["Felix Boyle",58000,null,"Phelan Davidson",5780,null,"Ciaran Smith",630,null,"Fritz Klein",3,null,"Graham Gibbs",3]
["Chandler Stevens",57000,null,"Vaughan Dean",5550,null,"Chandler Stevens",590,null,"Byron Foreman",3,null,"Lamar Howard",3]
["Henry Holcomb",57000,null,"Lamar Howard",5470,null,"Brennan Ellison",540,null,"Brennan Ellison",3,null,"Tiger Mcintosh",3]
["Kuame Griffith",56000,null,"Christopher Guerra",5250,null,"Caldwell Shepherd",530,null,"Bradley Valenzuela",3,null,"Christopher Guerra",3]
["Elmo Abbott",55000,null,"Oscar Keller",5210,null,"Tiger Mcintosh",450,null,"Kenyon Petersen",3,null,"Ciaran Smith",3]
["Linus Christian",52000,null,"Wesley Conner",5130,null,"Marvin Velasquez",370,null,"Graham Gibbs",3,null,"Bernard Wilkinson",2]
["Damian Silva",52000,null,"Ciaran Smith",5040,null,"Fritz Klein",220,null,"Felix Boyle",3,null,"Malcolm Hutchinson",2]
["Deacon Whitaker",52000,null,"Emerson Sellers",4950,null,"Flynn Guthrie",60,null,"Caldwell Shepherd",3,null,"Dustin Harris",2]
["Brennan Ellison",52000,null,"Lawrence Hicks",4890,null,"Christopher Guerra",60,null,"Garrison Bray",3,null,"Oscar Dickerson",2]
["Lawrence Hicks",52000,null,"Ishmael Grimes",4690,null,"Dennis Nguyen",60,null,"Hasad Faulkner",3,null,"Tad Carson",2]
["Caldwell Shepherd",51000,null,"Luke Luna",4550,null,"Kasimir Mccoy",60,null,"Noah Rowland",3,null,"Kermit Duffy",2]
["Bernard Wilkinson",50000,null,"Nasim Hanson",4430,null,"Giacomo Parks",60,null,"Oscar Dickerson",3,null,"Jonah Mcintyre",2]
["Hyatt Edwards",49000,null,"Ferdinand Small",4350,null,"Hashim Vazquez",60,null,"Ciaran Smith",3,null,"Eaton Stevens",2]
["Hector Madden",49000,null,"Sean Stark",4200,null,"Phelan Davidson",60,null,"Rashad Zimmerman",2,null,"Ishmael Grimes",2]
["Oscar Emerson",49000,null,"Hyatt Rogers",3930,null,"Rafael Griffith",60,null,"Tiger Schultz",2,null,"Phelan Davidson",2]
["Hasad Faulkner",48000,null,"Caldwell Shepherd",3870,null,"Brandon Mckenzie",60,null,"Hyatt Rogers",2,null,"Stone Bush",2]
["Gavin Bell",47000,null,"Marvin Velasquez",3840,null,"Kenneth Booker",60,null,"Damian Silva",2,null,"Cruz Chase",2]
["Phelan Davidson",47000,null,"Clayton Cotton",3690,null,"Connor Baxter",60,null,"Adam Curtis",2,null,"Jasper Battle",2]
["Gabriel Ayala",46000,null,"Brennan Walls",3610,null,"Jesse Barron",60,null,"Jasper Battle",2,null,"Kuame Griffith",2]
["Malcolm Hutchinson",45000,null,"Bevis Whitfield",3570.0000000000005,null,"Hayes Gonzales",60,null,"Harding Turner",2,null,"Hyatt Edwards",2]
["Jerry Goodwin",44000,null,"Gabriel Ayala",3570,null,"Oscar Emerson",60,null,"Chandler Stevens",2,null,"Luke Luna",2]
["Jasper Battle",44000,null,"Bernard Wilkinson",3350,null,"Vaughan Dean",60,null,"Steel Stuart",2,null,"Dennis Nguyen",2]
["Tiger Mcintosh",43000,null,"Kasimir Mccoy",3290,null,"Declan Larson",60,null,"Hector Madden",2,null,"Bevis Whitfield",1]
["Connor Baxter",42000,null,"Gareth Wyatt",3210,null,"Stone Bush",60,null,"Linus Christian",2,null,"Simon Pratt",1]
["Bevis Whitfield",40000,null,"Fritz Klein",3130,null,"Judah Robles",60,null,"Wylie Burris",2,null,"Wayne Golden",1]
["Hu Frost",39000,null,"Malcolm Hutchinson",3100,null,"Wylie Burris",60,null,"Rafael Griffith",2,null,"Oscar Keller",1]
["Luke Luna",39000,null,"Connor Baxter",2950,null,"Rajah Weber",60,null,"Chester Baldwin",1,null,"Geoffrey Small",1]
["Hayes Gonzales",39000,null,"Asher Benson",2850,null,"Sawyer Byers",60,null,"Clayton Riddle",1,null,"Brennan Walls",1]
["Lamar Howard",38000,null,"Hu Frost",2800,null,"Rashad Zimmerman",60,null,"Elmo Abbott",1,null,"Oren Chase",1]
["Wesley Conner",38000,null,"Harding Turner",2750,null,"Dexter Hawkins",60,null,"Cruz Chase",1,null,"Felix Boyle",1]
["Kasimir Mccoy",36000,null,"Cruz Chase",2670,null,"Drake Dominguez",60,null,"Bevis Whitfield",1,null,"Kenyon Petersen",1]
["Oscar Keller",36000,null,"Jasper Battle",2650,null,"Byron Foreman",60,null,"Luke Luna",1,null,"Chandler Stevens",1]
["Tiger Schultz",35000,null,"Kuame Griffith",2610,null,"Gavin Bell",60,null,"Ishmael Grimes",1,null,"Marvin Moses",1]
["Marvin Velasquez",35000,null,"Oren Chase",2550,null,"Stewart Wilcox",60,null,"Malcolm Hutchinson",1,null,"Rafael Griffith",1]
["Ferdinand Small",34000,null,"Geoffrey Small",2510,null,"Jerry Goodwin",60,null,"Clayton Cotton",1,null,"Melvin Pickett",1]
["Asher Benson",34000,null,"Ferris Knight",2370,null,"Brennan Walls",60,null,"Oren Chase",1,null,"Brennan Ellison",1]
["Ishmael Grimes",32000,null,"Hasad Faulkner",2370,null,"Harding Turner",60,null,"Connor Baxter",1,null,"Noah Rowland",1]
["Christopher Guerra",32000,null,"Dustin Harris",2350,null,"Bernard Wilkinson",60,null,"Jesse Barron",1,null,"Griffith Nielsen",1]
["Vaughan Dean",31000,null,"Tiger Schultz",2290,null,"Aidan Tyler",60,null,"Drake Dominguez",1,null,"Hyatt Rogers",1]
["Bradley Valenzuela",31000,null,"Brandon Mckenzie",2150,null,"Griffith Nielsen",60,null,"Hyatt Edwards",1,null,"Judah Robles",1]
["Nasim Hanson",30000,null,"Oscar Emerson",1950,null,"Emerson Sellers",60,null,"Asher Benson",1,null,"Wesley Conner",1]
["Oren Chase",29000,null,"Bradley Valenzuela",1860,null,"Hector Madden",60,null,"Oscar Emerson",1,null,"Darius Sandoval",1]
["Porter Le",29000,null,"Tiger Mcintosh",1830,null,"Adam Curtis",60,null,"Oscar Keller",1,null,"Flynn Guthrie",1]
["Fritz Klein",20000,null,"Porter Le",1800,null,"Henry Holcomb",60,null,"Christopher Guerra",1,null,"Kasper Riley",1]
[]
[]
["Accounting"]
["Administration"]
["Customer Support"]
["Finance"]
["Human Resources"]
["IT"]
["Marketing"]
["R&D"]
["Sales"]