{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Home","To do list","Inputs","ColourSets","BlankPage","DevFrame","WelcomePage"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":192,"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":82,"n_cols":8,"rows_kept":82,"cut":false,"hidden":false,"merged":[[52,4,52,5],[5,4,5,5],[48,4,48,5],[51,4,51,5],[55,4,55,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,"TO DO LIST"]
["Protection settings"]
["DrawingObjects",true,null,null,"Introduction"]
["Contents",true,null,null,"This spreadsheet allows to create a to do list and order it following various parameters."]
["Scenarios",true]
["UserInterfaceOnly",true,null,null,"Features"]
["AllowFormattingCells",false,null,null,"- Add new to dos"]
["AllowFormattingColumns",false,null,null,"- Automatically insert today's date"]
["AllowFormattingRows",false,null,null,"- Automatically order the list depending on:"]
["AllowInsertingColumns",false,null,null,"      - Date of entry"]
["AllowInsertingRows",false,null,null,"      - Project name"]
["AllowInsertingHyperlinks",false,null,null,"      - Due date"]
["AllowDeletingColumns",false,null,null,"      - Importance"]
["AllowDeletingRows",false,null,null,"      - Task responsible"]
["AllowSorting",false,null,null,"- Automatically highlight out-of-date tasks"]
["AllowFiltering",false,null,null,"- Automatically close tasks and record closing date"]
["AllowUsingPivotTables",false,null,null,"- Automatically filter closed tasks"]
["EnableSelection",false,null,null,"- Filter tasks by name"]
[null,null,null,null,"- Select spreadsheet colours"]
["Other settings",null,null,null,"- Modify columns and rows dimensions"]
["MarkProtectedCellsStatus",false]
["RowColumnDimensionStatus",true,null,null,"Instructions"]
[null,null,null,null,"Operation","How to"]
[null,null,null,null,"Insert a new project in the list/modify the name of an existing one","Open \"Inputs\" sheet\nGo to \"Projects\" column\nInsert a new project name after the last one/modify an existing one\nNOTE: do not leave empty spaces between names"]
[null,null,null,null,"Insert a new responsible in the list/modify the name of an existing one","Open \"Inputs\" sheet\nGo to \"Responsible\" column\nInsert a new responsible name after the last one/modify an existing one\nNOTE: do not leave empty spaces between names"]
[null,null,null,null,"Insert a new importance level in the list/modify an existing one","Open \"Inputs\" sheet\nGo to \"Importance\" column\nInsert a new importance level after the last one/modify an existing one\nNOTE: do not leave empty spaces between importance levels"]
[null,null,null,null,"Insert a new task","Open \"To do list\" sheet\nClick on \"New task\"\nSelect Project, importance and Responsible from dropdown lists\nInsert Task name and Due date\nNOTE: a new line will clear active filters"]
[null,null,null,null,"Visualise all the tasks in insertion order","Open \"To do list\" sheet\nClick on the button over the \"#\" column"]
[null,null,null,null,"Visualise all the tasks in project order","Open \"To do list\" sheet\nClick on the button over the \"Project\" column"]
[null,null,null,null,"Visualise all the tasks in due date order","Open \"To do list\" sheet\nClick on the button over the \"Due date\" column"]
[null,null,null,null,"Visualise all the tasks in importance order","Open \"To do list\" sheet\nClick on the button over the \"Importance\" column"]
[null,null,null,null,"Visualise all the tasks in responsible order","Open \"To do list\" sheet\nClick on the button over the \"Responsible\" column"]
[null,null,null,null,"Close a task","Open \"To do list\" sheet\nRight click on the task line and click on \"Close task\""]
[null,null,null,null,"Delete a task","Open \"To do list\" sheet\nRight click on a task\nClick on \"Delete task\"\nClick \"Yes\""]
[null,null,null,null,"Hide closed tasks","Open \"To do list\" sheet\nTick \"Hide closed tasks\""]
[null,null,null,null,"Unhide closed tasks","Open \"To do list\" sheet\nUntick \"Hide closed tasks\""]
[null,null,null,null,"Reopen a task","Open \"To do list\" sheet\nUnhide the closed tasks\nRight click on the task line and click on \"Reopen task\""]
[null,null,null,null,"Filter a column","Open \"To do list\" sheet\nClick on the filtering button at the beginning of the column and select the items you want to visualise"]
[null,null,null,null,"Remove all the filters","Open \"To do list\" sheet\nClick on \"Remove filters\" button"]
[null,null,null,null,"Change the dimension of a row/column","Open \"To do list\" sheet\nRight click on a cell of the row/column\nClick on \"Row/column dimension\"\nClick on \"+\", \"-\" or \"Auto adjust\" to modify the dimension "]
[null,null,null,null,"Change the colour set of the table","Open \"Inputs\" sheet\nGo to \"Colour set\" column\nSelect the colour set from the dropdown list"]
[]
[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 on top of this 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   -   07/01/2017","First release"]
[null,null,"H",null,"1.1   -   20/01/2017","Improved hiding configurability"]
[null,null,"H",null,null,"Improved hiding performance"]
[null,null,"H",null,null,"Added wrap text on tasks"]
[null,null,"H",null,null,"Improved interface"]
[null,null,"H",null,"1.2   -   03/02/2017","Corrected ordering bug"]
[null,null,"H",null,"1.3   -   17/03/2017","Updated graphics and infos"]
[null,null,"H",null,"1.4   -   24/03/2017","Upgraded columns and rows width functionality"]
[null,null,"H",null,"1.5   -   12/01/2018","Improved interface style and automation"]
[null,null,"H",null,null,"Added conditional formatting to Closed column"]
[null,null,"H",null,null,"Added space for title"]
[null,null,"H",null,null,"Added Delete task functionality"]
[null,null,"H",null,"1.6   -   12/01/2018","Added welcome page"]
[null,null,"H",null,"1.7   -   20/04/2018","Added internet connectivity check"]
[null,null,null,null,"1.8   -   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":"To do list","index":1,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,7,3,9]]}
["DevFrame settings",null,"H",null,null,null,null,null,null,null,null,null,null,"H"]
["HiddenStatus","VISIBLE",null,null,null,null,null,"INSERT TITLE HERE",null,null,null,null,null,true]
["ProtectSheet",true,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(E:E)+ROW(TableStart)","v":7}]
["HeadingsVisibility",false]
["GridlineVisibility",false]
[null,null,null,null,"#","DATE","PROJECT","TASK","DUE DATE","IMPORTANCE","RESPONSIBLE","CLOSED"]
["Protection settings",null,null,null,1,"2018-01-11",null,null,null,null,null,"-"]
["DrawingObjects",true]
["Contents",true,"H"]
["Scenarios",true]
["UserInterfaceOnly",true]
["AllowFormattingCells",true]
["AllowFormattingColumns",false]
["AllowFormattingRows",false]
["AllowInsertingColumns",false]
["AllowInsertingRows",false]
["AllowInsertingHyperlinks",false]
["AllowDeletingColumns",false]
["AllowDeletingRows",false]
["AllowSorting",false]
["AllowFiltering",true]
["AllowUsingPivotTables",false]
["EnableSelection",false]
[]
["Other settings"]
["MarkProtectedCellsStatus",true]
["RowColumnDimensionStatus",true]

{"sheet":"Inputs","index":2,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["DevFrame settings",null,"H",null,null,null,null,null,null,null,null,null,"H"]
["HiddenStatus","VISIBLE"]
["ProtectSheet",true]
["HeadingsVisibility",false]
["GridlineVisibility",false]
[null,null,"H",null,{"$f":"COUNTA(E7:E300)","v":2},null,{"$f":"COUNTA(G7:G300)","v":2},null,{"$f":"COUNTA(I7:I300)","v":6}]
["Protection settings",null,null,null,"PROJECT",null,"RESPONSIBLE",null,"IMPORTANCE",null,"COLOUR SET"]
["DrawingObjects",true,null,null,"Insert project here",null,"Insert responsible here",null,1,null,"Green"]
["Contents",true,null,null,null,null,null,null,2]
["Scenarios",true,null,null,null,null,null,null,3]
["UserInterfaceOnly",true,null,null,null,null,null,null,4]
["AllowFormattingCells",true,null,null,null,null,null,null,5]
["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",true]
["RowColumnDimensionStatus",true]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"H"]

{"sheet":"ColourSets","index":3,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":true,"merged":[[4,3,4,13],[5,5,5,7],[5,8,5,10],[5,11,5,13]]}
["DevFrame settings",null,"H",null,null,null,null,null,null,null,null,null,null,null,"H"]
["HiddenStatus","VERY HIDDEN",null,"Selected colour"]
["ProtectSheet",false,null,{"$f":"MATCH(Inputs!K8,ColourSets!E8:E12,0)","v":1}]
["HeadingsVisibility",true]
["GridlineVisibility",true,null,"COLOUR SETS"]
[null,null,null,null,null,"Dark",null,null,"Medium",null,null,"Light"]
["Protection settings",null,null,"#","Name","R","G","B","R","G","B","R","G","B"]
["DrawingObjects",true,null,1,"Green",229,245,224,161,217,155,49,163,84]
["Contents",true,null,2,"Blue",222,235,247,158,202,225,49,130,189]
["Scenarios",true,null,3,"Red",254,224,210,252,146,114,222,45,38]
["UserInterfaceOnly",false,"H",4,"Purple",239,237,245,188,189,220,117,107,177]
["AllowFormattingCells",false,null,5,"Grey",240,240,240,189,189,189,99,99,99]
["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",true]
["RowColumnDimensionStatus",true]

{"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",true]
["GridlineVisibility",true]
[]
["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",true]

{"sheet":"DevFrame","index":5,"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",true,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: 22/12/2016"]
[null,null,null,"Changed features: First issue"]

{"sheet":"WelcomePage","index":6,"n_rows":51,"n_cols":17,"rows_kept":51,"cut":false,"hidden":true,"merged":[[5,4,5,9],[12,4,12,9],[22,4,22,9]]}
["DevFrame settings",null,"H",null,null,null,null,null,null,null,null,null,null,null,null,null,"HL"]
["HiddenStatus","VERY HIDDEN"]
["ProtectSheet",false]
["HeadingsVisibility",false]
["GridlineVisibility",false]
[null,null,null,null,"COUNTERS"]
["Protection settings"]
["DrawingObjects",true,null,null,"OpenedTimes",1]
["Contents",true,null,null,"NotShowAgain",false]
["Scenarios",true]
["UserInterfaceOnly",true]
["AllowFormattingCells",false]
["AllowFormattingColumns",false,null,null,"MESSAGES RELATED TO SPREADSHEET"]
["AllowFormattingRows",false]
["AllowInsertingColumns",false,null,null,"SpreadsheetName"]
["AllowInsertingRows",false,null,null,"To do list"]
["AllowInsertingHyperlinks",false]
["AllowDeletingColumns",false,null,null,"VideoLink"]
["AllowDeletingRows",false,null,null,"https://youtu.be/idj1yFYW4Zo"]
["AllowSorting",false]
["AllowFiltering",false]
["AllowUsingPivotTables",false]
["EnableSelection",false,null,null,"MESSAGES VALID FOR ALL SPREADSHEETS"]
[]
["Other settings",null,null,null,"WelcomeText"]
["MarkProtectedCellsStatus",false,null,null,"Thanks for downloading EnginExcel free material."]
["RowColumnDimensionStatus",false,null,null,{"$f":"\"A quick introductory video on \"  & SpreadsheetName &  \" main functionalities is linked below.\"","v":"A quick introductory video on To do list main functionalities is linked below."}]
[]
[null,null,null,null,"ButtonText"]
[null,null,null,null,"Introductory video"]
["TableStart"]
["TableStartRow",{"$f":"ROW(TableStart)","v":{"$error":"#REF!"}},"HL",null,"FreeMaterialText"]
["TableStartColumn",{"$f":"COLUMN(TableStart)","v":{"$error":"#REF!"}},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"]