{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Home","Main Page","Entries table","Report","BlankPage","WelcomePage","Settings","DevFrame"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":214,"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":"Home","index":0,"n_rows":68,"n_cols":8,"rows_kept":68,"cut":false,"hidden":false,"merged":[[50,4,50,5],[43,4,43,5],[46,4,46,5],[47,4,47,5],[5,4,5,5],[8,4,9,5]]}
["DevFrame settings",null,"H",null,null,null,null,"H"]
["HiddenStatus","VISIBLE",null,null,null,"ENGINEXCEL"]
["ProtectSheet",true,null,null,null,"Email: alessandro@enginexcel.com"]
["HeadingsVisibility",false,null,null,null,"Website: www.enginexcel.com"]
["GridlineVisibility",false]
[null,null,null,null,"TIME CARD CALCULATOR"]
["Protection settings"]
["DrawingObjects",true,null,null,"Introduction"]
["Contents",true,null,null,"This spreadsheet allows to record entries of employees and automatically calculate the number of hours worked."]
["Scenarios",true]
["UserInterfaceOnly",false]
["AllowFormattingCells",false,null,null,"Features"]
["AllowFormattingColumns",false,null,null,"- Customisable list of employees up to 50 entries"]
["AllowFormattingRows",false,null,null,"- Single button press entry registration"]
["AllowInsertingColumns",false,null,null,"- Registration of a past entry/exit event"]
["AllowInsertingRows",false,null,null,"- Registration of a past workday"]
["AllowInsertingHyperlinks",false,null,null,"- Identification of employees currently in and out"]
["AllowDeletingColumns",false,null,null,"- Cancellation of up to 5 latest entries"]
["AllowDeletingRows",false,null,null,"- Warning for missed entries (if last entry is older than 12 hours)"]
["AllowSorting",false,null,null,"- Cancellation of employees and relative records"]
["AllowFiltering",false,null,null,"- Automated ordering of employees names in alphabetical order"]
["AllowUsingPivotTables",false,null,null,"- Automated timesheet report"]
["EnableSelection",false,null,null,"- Timesheet report start and stop date setting"]
[null,null,null,null,"- Timesheet report frequency setting"]
["Other settings",null,null,null,"- Timesheet automated totals calculation"]
["MarkProtectedCellsStatus",false,null,null,"- Timesheet customised formula"]
["RowColumnDimensionStatus",false,null,null,"- Poke yoke features to avoid errors"]
[]
[null,null,null,null,"Instructions"]
[null,null,null,null,"Operation","How to"]
[null,null,null,null,"Create an employees list","Click on \"Entries table\" sheet\nInsert the names in the spaces provided (one name per row, up to 50 names)"]
[null,null,null,null,"Order the employees list in alphabetical order","Click on \"Entries table\" sheet\nClick on \"Order names\" button"]
[null,null,null,null,"Insert a single entry","Open \"MainPage\" sheet\nClick on the name of the employee who is entering\nThe name will be highlighted in light blue\nClick on Enter/exit"]
[null,null,null,null,"Insert a past entry (in case a past entry or \nexit event was not recorded)","Open \"MainPage\" sheet\nClick on the name of the employee to be recorded The name will be highlighted in light blue\nClick on \"Insert single entry manually\"\nInsert the date and time of the entry in the popup window\nClick on \"Ok\""]
[null,null,null,null,"Insert a past double entry (in case a past entry and exit event were not recorded)","Open \"MainPage\" sheet\nClick on the name of the employee to be recorded. The name will be highlighted in light blue\nClick on \"Insert double entry manually\"\nInsert the date and time of the entry in the popup window\nInsert the date and time of the exit in the popup window\nClick on \"Ok\""]
[null,null,null,null,"Cancel last entry","Go to \"Main page\" sheet\nClick on \"Cancel last entry\""]
[null,null,null,null,"Visualise who is currently in","Open \"MainPage\" sheet\nVisualise the coloured circle on the right side of each name\nIf the circle is green, the person is in. If the circle is red, the person is out."]
[null,null,null,null,"Create a report of the hours worked by each employee","Open \"Report\" sheet\nIn the dark grey band at the top, click on the date next to \"Start date\"\nSelect the end date of the report calculation\nNOTE: Report start date must be earlier in time than report end date\nIn the dark grey band at the top, click on the date next to \"End date\"\nSelect the end date of the report calculation\nNOTE: Report end date must be later in time than report start date\nIn the dark grey band at the top, click on the number next to \"Report frequency\" and insert the number of days that should included in each report column (if Frequency = 1 a report for each day will be created, if Frequency = 7 a report for each week will be created, etc.).\nClick on \"Create report\"\nThe report will show the number of hours worked by each employee in each period, and the totals for each employee and each period"]
[null,null,null,null,"Create a custom report calculation for each employee","Open \"report\" sheet\nGo to \"Custom formula\" column\nInsert the desired formulas in the cells of the column"]
[null,null,null,null,"Delete an employee and all the related records","Open \"Entries table\" sheet\nRight click on the employee name\nClick on \"Remove name\"\nClick on \"Yes\""]
[null,null,null,null,"Change the dimension of a row/column","Right click on a cell\nClick on \"Row/column dimension\"\nClick on \"+\", \"-\" or \"Auto adjust\" to modify the dimension "]
[]
[null,null,null,null,"Terms of use"]
[null,null,null,null,"This spreadsheet is free for personal and commercial use, but it may not be altered or sold without the written permission of the author."]
[]
[null,null,null,null,"Disclaimer"]
[null,null,null,null,"This spreadsheet may be freely distributed, provided that no charge above the cost of distribution is levied, and that the terms of use and disclaimer are always attached to it.\nThis spreadsheet is provided as is without any guarantees or warranty.\n"]
[null,null,null,null,"Although the author has attempted to find and correct any bugs in the spreadsheet, the author is not responsible for any damage or losses of any kind caused by the use or misuse of the spreadsheet.\nThe author is under no obligation to provide support, service, corrections, or upgrades to the spreadsheet.\nFor more information, please send an email to the author (see contacts at the top of the page)."]
[]
[null,null,null,null,"Compatibility"]
[null,null,null,null,"The compatibility of this spreadsheet has been verified on:"]
[null,null,null,null," - Microsoft Excel 2007"]
[null,null,null,null," - Microsoft Excel 2010"]
[null,null,null,null," - Microsoft Excel 2013"]
[null,null,null,null," - Microsoft Excel 365"]
[]
[null,null,null,null,"Version history"]
[null,null,null,null,"1.0   -   31/03/2017","First release"]
[null,null,"H",null,"1.1   -   05/05/2017","Solved compatibility issues with Excel 2013"]
[null,null,"H",null,"1.2   -   08/05/2017","Minor bugs fix"]
[null,null,"H",null,"1.3   -   09/04/2018","Welcome page added"]
[null,null,"H",null,"1.4   -   20/04/2018","Added internet connection verification"]
[null,null,null,null,"1.5   -   28/05/2018","Added Excel 365 compatibility\nAdded Windows 10 x64 compatibility"]
[]
[null,null,null,null,"Copyright"]
[null,null,null,null,"EnginExcel, All rights reserved"]
[]
[null,null,"H"]

{"sheet":"Main Page","index":1,"n_rows":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":false,"merged":[[5,8,5,9],[5,4,5,5]]}
["DevFrame settings",null,"H",null,null,null,null,null,null,null,"H",null,"H"]
["HiddenStatus","VISIBLE",null,null,null,null,null,null,null,null,true]
["ProtectSheet",true]
["HeadingsVisibility",false]
["GridlineVisibility",false]
[null,null,null,null,"NAME",null,null,null,"Last entries:",null,"Row"]
["Protection settings",null,null,null,{"$f":"IF('Entries table'!F7<>\"\",'Entries table'!F7,\"\")","v":"Insert name here"},{"$f":"MOD('Entries table'!E7,2)","v":0}]
["DrawingObjects",true,null,null,{"$f":"IF('Entries table'!F8<>\"\",'Entries table'!F8,\"\")","v":""},{"$f":"MOD('Entries table'!E8,2)","v":0}]
["Contents",true,null,null,{"$f":"IF('Entries table'!F9<>\"\",'Entries table'!F9,\"\")","v":""},{"$f":"MOD('Entries table'!E9,2)","v":0}]
["Scenarios",true,null,null,{"$f":"IF('Entries table'!F10<>\"\",'Entries table'!F10,\"\")","v":""},{"$f":"MOD('Entries table'!E10,2)","v":0}]
["UserInterfaceOnly",true,null,null,{"$f":"IF('Entries table'!F11<>\"\",'Entries table'!F11,\"\")","v":""},{"$f":"MOD('Entries table'!E11,2)","v":0}]
["AllowFormattingCells",true,null,null,{"$f":"IF('Entries table'!F12<>\"\",'Entries table'!F12,\"\")","v":""},{"$f":"MOD('Entries table'!E12,2)","v":0}]
["AllowFormattingColumns",true,null,null,{"$f":"IF('Entries table'!F13<>\"\",'Entries table'!F13,\"\")","v":""},{"$f":"MOD('Entries table'!E13,2)","v":0}]
["AllowFormattingRows",true,null,null,{"$f":"IF('Entries table'!F14<>\"\",'Entries table'!F14,\"\")","v":""},{"$f":"MOD('Entries table'!E14,2)","v":0}]
["AllowInsertingColumns",false,null,null,{"$f":"IF('Entries table'!F15<>\"\",'Entries table'!F15,\"\")","v":""},{"$f":"MOD('Entries table'!E15,2)","v":0}]
["AllowInsertingRows",false,null,null,{"$f":"IF('Entries table'!F16<>\"\",'Entries table'!F16,\"\")","v":""},{"$f":"MOD('Entries table'!E16,2)","v":0}]
["AllowInsertingHyperlinks",false,null,null,{"$f":"IF('Entries table'!F17<>\"\",'Entries table'!F17,\"\")","v":""},{"$f":"MOD('Entries table'!E17,2)","v":0}]
["AllowDeletingColumns",false,null,null,{"$f":"IF('Entries table'!F18<>\"\",'Entries table'!F18,\"\")","v":""},{"$f":"MOD('Entries table'!E18,2)","v":0}]
["AllowDeletingRows",false,null,null,{"$f":"IF('Entries table'!F19<>\"\",'Entries table'!F19,\"\")","v":""},{"$f":"MOD('Entries table'!E19,2)","v":0}]
["AllowSorting",false,null,null,{"$f":"IF('Entries table'!F20<>\"\",'Entries table'!F20,\"\")","v":""},{"$f":"MOD('Entries table'!E20,2)","v":0}]
["AllowFiltering",false,null,null,{"$f":"IF('Entries table'!F21<>\"\",'Entries table'!F21,\"\")","v":""},{"$f":"MOD('Entries table'!E21,2)","v":0}]
["AllowUsingPivotTables",false,null,null,{"$f":"IF('Entries table'!F22<>\"\",'Entries table'!F22,\"\")","v":""},{"$f":"MOD('Entries table'!E22,2)","v":0}]
["EnableSelection",true,null,null,{"$f":"IF('Entries table'!F23<>\"\",'Entries table'!F23,\"\")","v":""},{"$f":"MOD('Entries table'!E23,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F24<>\"\",'Entries table'!F24,\"\")","v":""},{"$f":"MOD('Entries table'!E24,2)","v":0}]
["Other settings",null,null,null,{"$f":"IF('Entries table'!F25<>\"\",'Entries table'!F25,\"\")","v":""},{"$f":"MOD('Entries table'!E25,2)","v":0}]
["MarkProtectedCellsStatus",true,null,null,{"$f":"IF('Entries table'!F26<>\"\",'Entries table'!F26,\"\")","v":""},{"$f":"MOD('Entries table'!E26,2)","v":0}]
["RowColumnDimensionStatus",true,null,null,{"$f":"IF('Entries table'!F27<>\"\",'Entries table'!F27,\"\")","v":""},{"$f":"MOD('Entries table'!E27,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F28<>\"\",'Entries table'!F28,\"\")","v":""},{"$f":"MOD('Entries table'!E28,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F29<>\"\",'Entries table'!F29,\"\")","v":""},{"$f":"MOD('Entries table'!E29,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F30<>\"\",'Entries table'!F30,\"\")","v":""},{"$f":"MOD('Entries table'!E30,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F31<>\"\",'Entries table'!F31,\"\")","v":""},{"$f":"MOD('Entries table'!E31,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F32<>\"\",'Entries table'!F32,\"\")","v":""},{"$f":"MOD('Entries table'!E32,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F33<>\"\",'Entries table'!F33,\"\")","v":""},{"$f":"MOD('Entries table'!E33,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F34<>\"\",'Entries table'!F34,\"\")","v":""},{"$f":"MOD('Entries table'!E34,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F35<>\"\",'Entries table'!F35,\"\")","v":""},{"$f":"MOD('Entries table'!E35,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F36<>\"\",'Entries table'!F36,\"\")","v":""},{"$f":"MOD('Entries table'!E36,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F37<>\"\",'Entries table'!F37,\"\")","v":""},{"$f":"MOD('Entries table'!E37,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F38<>\"\",'Entries table'!F38,\"\")","v":""},{"$f":"MOD('Entries table'!E38,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F39<>\"\",'Entries table'!F39,\"\")","v":""},{"$f":"MOD('Entries table'!E39,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F40<>\"\",'Entries table'!F40,\"\")","v":""},{"$f":"MOD('Entries table'!E40,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F41<>\"\",'Entries table'!F41,\"\")","v":""},{"$f":"MOD('Entries table'!E41,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F42<>\"\",'Entries table'!F42,\"\")","v":""},{"$f":"MOD('Entries table'!E42,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F43<>\"\",'Entries table'!F43,\"\")","v":""},{"$f":"MOD('Entries table'!E43,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F44<>\"\",'Entries table'!F44,\"\")","v":""},{"$f":"MOD('Entries table'!E44,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F45<>\"\",'Entries table'!F45,\"\")","v":""},{"$f":"MOD('Entries table'!E45,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F46<>\"\",'Entries table'!F46,\"\")","v":""},{"$f":"MOD('Entries table'!E46,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F47<>\"\",'Entries table'!F47,\"\")","v":""},{"$f":"MOD('Entries table'!E47,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F48<>\"\",'Entries table'!F48,\"\")","v":""},{"$f":"MOD('Entries table'!E48,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F49<>\"\",'Entries table'!F49,\"\")","v":""},{"$f":"MOD('Entries table'!E49,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F50<>\"\",'Entries table'!F50,\"\")","v":""},{"$f":"MOD('Entries table'!E50,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F51<>\"\",'Entries table'!F51,\"\")","v":""},{"$f":"MOD('Entries table'!E51,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F52<>\"\",'Entries table'!F52,\"\")","v":""},{"$f":"MOD('Entries table'!E52,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F53<>\"\",'Entries table'!F53,\"\")","v":""},{"$f":"MOD('Entries table'!E53,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F54<>\"\",'Entries table'!F54,\"\")","v":""},{"$f":"MOD('Entries table'!E54,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F55<>\"\",'Entries table'!F55,\"\")","v":""},{"$f":"MOD('Entries table'!E55,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F56<>\"\",'Entries table'!F56,\"\")","v":""},{"$f":"MOD('Entries table'!E56,2)","v":0}]
[null,null,null,null,{"$f":"IF('Entries table'!F57<>\"\",'Entries table'!F57,\"\")","v":""},{"$f":"MOD('Entries table'!E57,2)","v":0}]
[]
[null,null,"H"]

{"sheet":"Entries table","index":2,"n_rows":59,"n_cols":667,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["DevFrame settings",null,"H",null,"H",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H"]
["HiddenStatus","VISIBLE"]
["ProtectSheet",true]
["HeadingsVisibility",false]
["GridlineVisibility",false]
[null,null,null,null,{"$f":"MAX(E7:E56)","v":0},"NAME","   ENTRIES  (older -->)"]
["Protection settings",null,null,null,{"$f":"COUNTA(G7:YQ7)","v":0},"Insert name here"]
["DrawingObjects",true,null,null,0]
["Contents",true,null,null,0]
["Scenarios",true,null,null,{"$f":"COUNTA(G10:YQ10)","v":0}]
["UserInterfaceOnly",true,null,null,0]
["AllowFormattingCells",true,null,null,0]
["AllowFormattingColumns",true,null,null,0]
["AllowFormattingRows",true,null,null,0]
["AllowInsertingColumns",false,null,null,0]
["AllowInsertingRows",false,null,null,0]
["AllowInsertingHyperlinks",false,null,null,0]
["AllowDeletingColumns",false,null,null,0]
["AllowDeletingRows",false,null,null,0]
["AllowSorting",false,null,null,0]
["AllowFiltering",false,null,null,0]
["AllowUsingPivotTables",false,null,null,0]
["EnableSelection",false,null,null,0]
[null,null,null,null,0]
["Other settings",null,null,null,0]
["MarkProtectedCellsStatus",true,null,null,0]
["RowColumnDimensionStatus",true,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,{"$f":"COUNTA(G39:YQ39)","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[]
[null,null,"H"]

{"sheet":"Report","index":3,"n_rows":61,"n_cols":1029,"rows_kept":61,"cut":false,"hidden":false,"merged":[[8,4,21,4]]}
["DevFrame settings",null,"H",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H"]
["HiddenStatus","VISIBLE",null,null,null,null,"Start date","2017-05-05"]
["ProtectSheet",true,null,null,null,null,"End date","2017-05-05"]
["HeadingsVisibility",false,null,null,null,null,"Report frequency",1]
["GridlineVisibility",false]
[null,null,null,null,null,null,null,"Start date"]
["Protection settings",null,null,null,null,null,null,"End date"]
["DrawingObjects",true,null,null,null,null,"Custom formula","Total hours"]
["Contents",true,null,null,"NAME          ",{"$f":"IF('Entries table'!F7<>\"\",'Entries table'!F7,\"\")","v":"Insert name here"},null,{"$f":"IF(F9<>\"\",SUM(I9:AMM9),\"\")","v":0}]
["Scenarios",true,null,null,null,{"$f":"IF('Entries table'!F8<>\"\",'Entries table'!F8,\"\")","v":""},null,{"$f":"IF(F10<>\"\",SUM(I10:AMM10),\"\")","v":""}]
["UserInterfaceOnly",true,null,null,null,{"$f":"IF('Entries table'!F9<>\"\",'Entries table'!F9,\"\")","v":""},null,""]
["AllowFormattingCells",true,null,null,null,{"$f":"IF('Entries table'!F10<>\"\",'Entries table'!F10,\"\")","v":""},null,""]
["AllowFormattingColumns",true,null,null,null,{"$f":"IF('Entries table'!F11<>\"\",'Entries table'!F11,\"\")","v":""},null,""]
["AllowFormattingRows",true,null,null,null,{"$f":"IF('Entries table'!F12<>\"\",'Entries table'!F12,\"\")","v":""},null,""]
["AllowInsertingColumns",false,null,null,null,{"$f":"IF('Entries table'!F13<>\"\",'Entries table'!F13,\"\")","v":""},null,""]
["AllowInsertingRows",false,null,null,null,{"$f":"IF('Entries table'!F14<>\"\",'Entries table'!F14,\"\")","v":""},null,""]
["AllowInsertingHyperlinks",false,null,null,null,{"$f":"IF('Entries table'!F15<>\"\",'Entries table'!F15,\"\")","v":""},null,""]
["AllowDeletingColumns",false,null,null,null,{"$f":"IF('Entries table'!F16<>\"\",'Entries table'!F16,\"\")","v":""},null,""]
["AllowDeletingRows",false,null,null,null,{"$f":"IF('Entries table'!F17<>\"\",'Entries table'!F17,\"\")","v":""},null,""]
["AllowSorting",false,null,null,null,{"$f":"IF('Entries table'!F18<>\"\",'Entries table'!F18,\"\")","v":""},null,""]
["AllowFiltering",false,null,null,null,{"$f":"IF('Entries table'!F19<>\"\",'Entries table'!F19,\"\")","v":""},null,""]
["AllowUsingPivotTables",false,null,null,null,{"$f":"IF('Entries table'!F20<>\"\",'Entries table'!F20,\"\")","v":""},null,""]
["EnableSelection",true,null,null,null,{"$f":"IF('Entries table'!F21<>\"\",'Entries table'!F21,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F22<>\"\",'Entries table'!F22,\"\")","v":""},null,""]
["Other settings",null,null,null,null,{"$f":"IF('Entries table'!F23<>\"\",'Entries table'!F23,\"\")","v":""},null,""]
["MarkProtectedCellsStatus",true,null,null,null,{"$f":"IF('Entries table'!F24<>\"\",'Entries table'!F24,\"\")","v":""},null,""]
["RowColumnDimensionStatus",true,null,null,null,{"$f":"IF('Entries table'!F25<>\"\",'Entries table'!F25,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F26<>\"\",'Entries table'!F26,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F27<>\"\",'Entries table'!F27,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F28<>\"\",'Entries table'!F28,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F29<>\"\",'Entries table'!F29,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F30<>\"\",'Entries table'!F30,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F31<>\"\",'Entries table'!F31,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F32<>\"\",'Entries table'!F32,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F33<>\"\",'Entries table'!F33,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F34<>\"\",'Entries table'!F34,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F35<>\"\",'Entries table'!F35,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F36<>\"\",'Entries table'!F36,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F37<>\"\",'Entries table'!F37,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F38<>\"\",'Entries table'!F38,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F39<>\"\",'Entries table'!F39,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F40<>\"\",'Entries table'!F40,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F41<>\"\",'Entries table'!F41,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F42<>\"\",'Entries table'!F42,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F43<>\"\",'Entries table'!F43,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F44<>\"\",'Entries table'!F44,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F45<>\"\",'Entries table'!F45,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F46<>\"\",'Entries table'!F46,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F47<>\"\",'Entries table'!F47,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F48<>\"\",'Entries table'!F48,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F49<>\"\",'Entries table'!F49,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F50<>\"\",'Entries table'!F50,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F51<>\"\",'Entries table'!F51,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F52<>\"\",'Entries table'!F52,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F53<>\"\",'Entries table'!F53,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F54<>\"\",'Entries table'!F54,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F55<>\"\",'Entries table'!F55,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F56<>\"\",'Entries table'!F56,\"\")","v":""},null,""]
[null,null,null,null,null,{"$f":"IF('Entries table'!F57<>\"\",'Entries table'!F57,\"\")","v":""},null,""]
[]
[null,null,"H"]

{"sheet":"BlankPage","index":4,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["DevFrame settings",null,"H"]
["HiddenStatus","VERY HIDDEN"]
["ProtectSheet",false]
["HeadingsVisibility",false]
["GridlineVisibility",false]
[]
["Protection settings"]
["DrawingObjects",true]
["Contents",true]
["Scenarios",true]
["UserInterfaceOnly",false]
["AllowFormattingCells",false]
["AllowFormattingColumns",false]
["AllowFormattingRows",false]
["AllowInsertingColumns",false]
["AllowInsertingRows",false]
["AllowInsertingHyperlinks",false]
["AllowDeletingColumns",false]
["AllowDeletingRows",false]
["AllowSorting",false]
["AllowFiltering",false]
["AllowUsingPivotTables",false]
["EnableSelection",false]
[]
["Other settings"]
["MarkProtectedCellsStatus",false]
["RowColumnDimensionStatus",false]

{"sheet":"WelcomePage","index":5,"n_rows":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":true,"merged":[[2,4,2,9],[9,4,9,9],[19,4,19,9]]}
["DevFrame settings",null,"H"]
["HiddenStatus","VERY HIDDEN"]
["ProtectSheet",false,null,null,"COUNTERS"]
["HeadingsVisibility",false]
["GridlineVisibility",false,null,null,"OpenedTimes",1]
[null,null,null,null,"NotShowAgain",false]
["Protection settings"]
["DrawingObjects",true]
["Contents",true]
["Scenarios",true,null,null,"MESSAGES RELATED TO SPREADSHEET"]
["UserInterfaceOnly",false]
["AllowFormattingCells",false,null,null,"SpreadsheetName"]
["AllowFormattingColumns",false,null,null,"Time card calculator"]
["AllowFormattingRows",false]
["AllowInsertingColumns",false,null,null,"VideoLink"]
["AllowInsertingRows",false,null,null,"https://youtu.be/ifGIaoJHupQ"]
["AllowInsertingHyperlinks",false]
["AllowDeletingColumns",false]
["AllowDeletingRows",false]
["AllowSorting",false,null,null,"MESSAGES VALID FOR ALL SPREADSHEETS"]
["AllowFiltering",false]
["AllowUsingPivotTables",false,null,null,"WelcomeText"]
["EnableSelection",false,null,null,"Thanks for downloading EnginExcel free material."]
[null,null,null,null,{"$f":"\"A quick introductory video on \"  & SpreadsheetName &  \" main functionalities is linked below.\"","v":"A quick introductory video on Time card calculator main functionalities is linked below."}]
["Other settings"]
["MarkProtectedCellsStatus",false,null,null,"ButtonText"]
["RowColumnDimensionStatus",false,null,null,"Introductory video"]
[]
[null,null,null,null,"FreeMaterialText"]
[null,null,null,null,"If you like this spreadsheet please consider subscribing to EnginExcel free material newsletter. You will receive an email when a new free spreadsheet is released."]
[]
[null,null,null,null,"ButtonText2"]
[null,null,null,null,"Open subscription page"]
[]
[null,null,null,null,"FreeMaterialLink"]
[null,null,null,null,"http://enginexcel.com/newsletter"]
[]
[null,null,null,null,"ReminderText1"]
[null,null,null,null,"If you are enjoying this spreadsheet please consider subscribing to EnginExcel newsletter. You will receive an email when a new free spreadsheet is released."]
[]
[null,null,null,null,"ReminderText2"]
[null,null,null,null,"EnginExcel provides consultancy to develop customised spreadsheets for Mechanical Engineers and Project Managers using Microsoft Excel and Visual Basic for Applications (VBA)."]
[]
[null,null,null,null,"ButtonText3"]
[null,null,null,null,"See how I can help you"]
[]
[null,null,null,null,"ServicesLink"]
[null,null,null,null,"http://enginexcel.com/what-i-do"]

{"sheet":"Settings","index":6,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":true,"merged":[[8,4,8,14],[9,6,9,8],[9,9,9,11],[9,12,9,14]]}
["DevFrame settings",null,"H"]
["HiddenStatus","VERY HIDDEN"]
["ProtectSheet",false,null,null,"Max number of entries","Alert time for employees in (hours)"]
["HeadingsVisibility",false,null,null,50,12]
["GridlineVisibility",false]
[]
["Protection settings"]
["DrawingObjects",true]
["Contents",true,null,null,"COLOUR SETS"]
["Scenarios",true,null,null,null,null,"Light",null,null,"Medium",null,null,"Dark"]
["UserInterfaceOnly",false,null,null,"#","Name","R","G","B","R","G","B","R","G","B"]
["AllowFormattingCells",false,null,null,1,"Green",229,245,224,161,217,155,49,163,84]
["AllowFormattingColumns",false,null,null,2,"Blue",222,235,247,158,202,225,49,130,189]
["AllowFormattingRows",false,null,null,3,"Red",254,224,210,252,146,114,222,45,38]
["AllowInsertingColumns",false,null,null,4,"Purple",239,237,245,188,189,220,117,107,177]
["AllowInsertingRows",false,null,null,5,"Grey",240,240,240,189,189,189,99,99,99]
["AllowInsertingHyperlinks",false]
["AllowDeletingColumns",false]
["AllowDeletingRows",false]
["AllowSorting",false]
["AllowFiltering",false]
["AllowUsingPivotTables",false]
["EnableSelection",false]
[]
["Other settings"]
["MarkProtectedCellsStatus",false]
["RowColumnDimensionStatus",false]

{"sheet":"DevFrame","index":7,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["DevFrame settings",null,"H",null,null,null,null,null,"H"]
["HiddenStatus","VERY HIDDEN",null,"HiddenStatuses","TrueFalse"]
["ProtectSheet",false,null,"VISIBLE",true]
["HeadingsVisibility",true,null,"HIDDEN",false]
["GridlineVisibility",true,null,"VERY HIDDEN"]
[]
["Protection settings",null,null,"ProgrammingMode","Password","DevFramePassword"]
["DrawingObjects",true,null,false,"Password","EnginExce1"]
["Contents",true]
["Scenarios",true,null,"AllowAddSheet"]
["UserInterfaceOnly",false,"H",true]
["AllowFormattingCells",false]
["AllowFormattingColumns",false]
["AllowFormattingRows",false]
["AllowInsertingColumns",false,null,null,"DEVELOPMENT FRAME"]
["AllowInsertingRows",false,null,"Features:"]
["AllowInsertingHyperlinks",false,null,"- Define visibility status of each sheet"]
["AllowDeletingColumns",false,null,"- Define which cells to protect"]
["AllowDeletingRows",false,null,"- Protect sheet with password"]
["AllowSorting",false,null,"- Define if to show the headings of each page"]
["AllowFiltering",false,null,"- Define if to show the gridline in each page"]
["AllowUsingPivotTables",false,null,"- Dev frame is protected by separate password"]
["EnableSelection",false,null,"- Define which rows and columns to hide"]
[null,null,null,"      - Rows and columns with \"H\" are hidden"]
["Other settings",null,null,"      - From the last \"H\", all the following rows (or columns) are hidden"]
["MarkProtectedCellsStatus",true]
["RowColumnDimensionStatus",false,null,"Activation:"]
[null,null,null,"- Activate development frame: CTRL + r"]
[null,null,null,"- Protect a selected cell: CTRL + p"]
[null,null,null,"- Unprotect a selected cell: CTRL + o"]
[]
[null,null,null,"Version control"]
[null,null,null,"Version: 1.0"]
[null,null,null,"Release date: 08/01/2017"]
[null,null,null,"Changed features: First issue"]