{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Dashboard","Employee","References","Department","RptDashboard","Retrieve Data","Reports","DepartmentRpt","BirthdayRpt"],"not_rendered":{"images":5,"macros":1,"defined_names":3,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Dashboard","index":0,"n_rows":7,"n_cols":8,"rows_kept":7,"merged":[[1,2,1,5],[1,7,5,7],[2,2,2,5],[5,3,5,5],[6,1,6,5]]}
[]
[null,null,"EMPLOYEE DATABASE TEMPLATE",{"$nulls":4},"About Us:\n\nDesignVAT is a Startup committed to helping other Startups effectively manage their data. \n\nWe design Business Spreadsheets (Free & Paid) across all fields - Accounting, Human Resources, Admin & Research (Data Analysis).\n\nThe Employee Database Template is aimed at providing an easy & free alternative for companies that cannot afford a paid solution. \n\nIt enables users store & easily retrieve their employee data. \n\nTo have a custom Data Template designed, or to add other Functionalities to this Template, Contact us at:\n+2348075779414   info@designvat.com"]
[null,null,"For  Small Business"]
[]
[null,"Click To Navigate To A Section"]
[{"$nulls":3},"Contact Us for more Data Templates or Assistance with this Template"]
[null,"Copyright © 2017 DesignVAT\nAll rights reserved. This Template or any portion thereof may not be reproduced or used commercially in any manner whatsoever without the express written permission of DesignVAT. "]

{"sheet":"Employee","index":1,"n_rows":5,"n_cols":16,"rows_kept":5}
[null,"Employee"]
[null,"Details"]
[]
[null,"Employee Name","Job Title","Department","Hire Date","End Date","Phone","Email","Birthday","Hire Month","Hire Year","Duration","Duration Month","Birth Month","Birth Year","ShortBD"]
[{"$nulls":9},{"$f":"IFERROR(IF(B5=\"\",\"\",TEXT(E5,\"mmmm\")),\"\")","v":""},{"$f":"IFERROR(IF(E5=\"\",\"\",YEAR(E5)),\"\")","v":""},{"$f":"IFERROR(M5,\"\")","v":""},{"$f":"IFERROR(IF(OR(B5=\"\",E5=\"\"),\"\", IF(F5<>\"\",\nDATEDIF(E5,F5,\"y\") &\" years, \"&DATEDIF(E5,F5,\"ym\") &\" months, \" &DATEDIF(E5,F5,\"md\") &\" days\",\nDATEDIF(E5,TODAY(),\"y\") &\" years, \"&DATEDIF(E5,TODAY(),\"ym\") &\" months, \" &DATEDIF(E5,TODAY(),\"md\") &\" days\")),\"\")","v":""},{"$f":"IFERROR(IF(I5=\"\",\"\",TEXT(I5,\"mmmm\")),\"\")","v":""},{"$f":"IFERROR(IF(I5=\"\",\"\",YEAR(I5)),\"\")","v":""},{"$f":"IFERROR(TEXT(I5,\"dd - mmm\"),\"\")","v":"00 - Jan"}]

{"sheet":"References","index":2,"n_rows":4,"n_cols":5,"rows_kept":4}
[null,"References"]
[null,"Details"]
[]
[null,"Employee Name","Reference Name","Phone Number","Address"]

{"sheet":"Department","index":3,"n_rows":11,"n_cols":14,"rows_kept":11}
[null,"Department Transfer"]
[null,"History"]
[]
[null,"Employee Name","Department","Start Date","End Date","Duration","Time Spent In Department",{"$nulls":4},"Departments",null,"Job Title"]
[{"$nulls":5},{"$f":"IFERROR(IF(OR(B5=\"\",D5=\"\"),\"\", IF(E5<>\"\",\nDATEDIF(D5,E5,\"y\") &\" years, \"&DATEDIF(D5,E5,\"ym\") &\" months, \" &DATEDIF(D5,E5,\"md\") &\" days\",\nDATEDIF(D5,TODAY(),\"y\") &\" years, \"&DATEDIF(D5,TODAY(),\"ym\") &\" months, \" &DATEDIF(D5,TODAY(),\"md\") &\" days\")),\"\")","v":""},{"$f":"IFERROR(IF(B5=\"\",\"\",F5),\"\")","v":""},{"$nulls":4},"Accounts",null,"Department"]
[{"$nulls":11},"Admin",null,"Hire Date"]
[{"$nulls":13},"End Date"]
[{"$nulls":13},"Phone"]
[{"$nulls":13},"Email"]
[{"$nulls":13},"Birthday"]
[{"$nulls":13},"Duration"]

{"sheet":"RptDashboard","index":4,"n_rows":2,"n_cols":2,"rows_kept":2}
[null,"Report"]
[null,"Dashboard"]

{"sheet":"Retrieve Data","index":5,"n_rows":10,"n_cols":5,"rows_kept":10}
[null,"Get Employee"]
[null,"Data"]
[null,"."]
[null,"Total Employees",{"$f":"IFERROR(COUNTIFS(tblEmployee[Employee Name],\"<>\"&\"\",tblEmployee[End Date],\"=\"&\"\"),\"\")","v":0}]
[null,"Get Employee Info:"]
[null,"Job Title","Email Address","Phone Number","Hire Date"]
[{"$nulls":3},""]
[null,"."]
[null,"References Info"]
[null,"Reference Name","Phone","Address"]

{"sheet":"Reports","index":6,"n_rows":6,"n_cols":10,"rows_kept":6}
[null,"Employee"]
[null,"Report"]
[null,{"$f":"IFERROR(IF(B6=\"\",\"\",MATCH(B6,tblEmployee[#Headers],0)),\"\")","v":1},{"$f":"IFERROR(IF(C6=\"\",\"\",MATCH(C6,tblEmployee[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(IF(D6=\"\",\"\",MATCH(D6,tblEmployee[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(IF(E6=\"\",\"\",MATCH(E6,tblEmployee[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(IF(F6=\"\",\"\",MATCH(F6,tblEmployee[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(IF(G6=\"\",\"\",MATCH(G6,tblEmployee[#Headers],0)),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(B5>1,B6&\" - Remove Duplicates\",\"\"),\"\")","v":""},{"$f":"IFERROR(IF(C5>1,C6&\" - Remove Duplicates\",\"\"),\"\")","v":""},{"$f":"IFERROR(IF(D5>1,D6&\" - Remove Duplicates\",\"\"),\"\")","v":""},"","",{"$f":"IFERROR(IF(G5>1,G6&\" - Remove Duplicates\",\"\"),\"\")","v":""},null,null,{"$f":"IFERROR(COUNTA(B6:G6),\"\")","v":1}]
[null,{"$f":"COUNTIF($B$6:$G$6,B6)","v":1},{"$f":"COUNTIF($B$6:$G$6,C6)","v":0},0,0,0,0]
[null,"Employee Name"]

{"sheet":"DepartmentRpt","index":7,"n_rows":6,"n_cols":3,"rows_kept":6}
[null,"Department History"]
[null,"Report"]
[null,"."]
[null,"Select Employee"]
[]
[null,"Department Name","Start Date"]

{"sheet":"BirthdayRpt","index":8,"n_rows":7,"n_cols":5,"rows_kept":7}
[null,"Employee"]
[null,"Birthdays"]
[]
[null,"Birth Month","(All)"]
[]
[null,"Employee Name","Job Title","Department","Birthday"]
[null,"(blank)","(blank)","(blank)","00 - Jan"]