{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["ToC","Settings","Manual","Check","Change Log","Styles"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":"ToC","index":0,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
["Table of Content"]
["Explanation",null,"Worksheet","Link","Remarks"]
["Update this sheet using the 'Update Toc' button",null,"Settings",{"$f":"HYPERLINK(\"#'\"&C4&\"'!A1\",C4)","v":"Settings"},"Model settings"]
["located on the developer tab of the ribbon",null,"Manual",{"$f":"HYPERLINK(\"#'\"&C5&\"'!A1\",C5)","v":"Manual"},"Model manual (or reference to location of documentation)"]
[null,null,"Check",{"$f":"HYPERLINK(\"#'\"&C6&\"'!A1\",C6)","v":"Check"},"Checks and controls"]
[null,null,"Change Log",{"$f":"HYPERLINK(\"#'\"&C7&\"'!A1\",C7)","v":"Change Log"},"Log of changes"]
[null,null,"Styles",{"$f":"HYPERLINK(\"#'\"&C8&\"'!A1\",C8)","v":"Styles"},"List of Styles"]

{"sheet":"Settings","index":1,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["ToC                                  "]
["Model Settings"]
["Explanation"]
[{"$f":"\"Column '\"&tblSettings[[#Headers],[Setting name]]&\"' contains both the name of the setting and the rangename that points to the value of the setting\"","v":"Column 'Setting name' contains both the name of the setting and the rangename that points to the value of the setting"}]
[{"$f":"\"Column '\"&tblSettings[[#Headers],[Setting Value]]&\"' contains the associated values for each setting.\"","v":"Column 'Setting Value' contains the associated values for each setting."}]
["Adding a setting:"]
["- Add the new setting name immediately below the table in column A"]
["- Do not use spaces in column A"]
["- Add the value next to the setting name"]
["- Select both the settingname and the setting value and choose:"]
["   Formulas tab, Define Names group, Create from selection and ONLY check the box \"Left Column\""]
[]
["Setting name","Setting Value","Comments"]
["DocumentVersion","1.0","Current version number"]
["DocumentOwner","Pieterse, Jan Karel","The ful name of the owner of this file"]
["DeveloperMode",true,"Set to true to display development tools on Developer tab"]
["RibbonPointer",null,"DO NOT CHANGE!!! Written from modRibbonX"]

{"sheet":"Manual","index":2,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["ToC"]
["Manual"]
["Explanation"]
["This sheet contains the manual for this model"]
["or it contains reference(s) to the documentation"]
["You may combine this sheet with the Table of Content"]
["sheet so that the TOC included the manual"]

{"sheet":"Check","index":3,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["ToC"]
["Check sheet"]
["Explanation"]
["This sheet contains checks which verify the integrity of the model"]
["The sheet should contain calculations which ensure all results are within the expected bounds."]
["Only if all checks are \"Valid\" or True, or OK will cell \"AllChecksOK\" turn green."]
["Possibly this sheet can be integrated in the ToC sheet, in which case you should have a \"correctness\" formula next to each worksheet on the ToC."]
["An example of a check is whether a balance sheet actually balances."]
[]
["AllChecksOK",{"$f":"AND(Table4[Check formula])","v":false}]
[]
["Description of check","Check formula"]
["Example 1",false]
["Example 2",{"$f":"TRUE","v":true}]

{"sheet":"Change Log","index":4,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["ToC"]
["Change Log"]
["Explanation"]
["Each change is to be logged on this worksheet"]
["Object modified must be fully defined."]
["Either the name of the range or its address"]
["or the name and location of the object which was changed, such as a chart"]
["If an object was deleted or something was inserted, old and new value can be omitted"]
["Date","Time","User","Name of worksheet","Object modified","Action","Old value or formula","New value or formula","Approved?","Approver name"]
["2018-01-29","16:14:00","JKP"]

{"sheet":"Styles","index":5,"n_rows":78,"n_cols":3,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
["ToC"]
["List of Styles"]
["This sheet contains a list of all styles in the file."]
["Use the Update button to refresh the list"]
["How to add a style:"]
["- Select one of the cells which has a formatting close to the formatting you like"]
["- Modify the formatting of that cell"]
["- Click the drop-down arrow of the Styles list and select \"New Cell Style...\""]
["- Enter the correct style name and check the appropriate formatting boxes to include in the style"]
["- Press OK."]
["- Click the Update button to update this list"]
["Note there is no Calc_Txt style defined."]
["This is because formatting a formula cell as text makes the formula hard to edit (formula turns into text)"]
["Style name","Style Example","Custom?"]
["Calc_DateLong","2018-03-14","Yes"]
["Calc_DateShort","2018-03-14","Yes"]
["Calc_DateTime","2018-03-14","Yes"]
["Calc_General","The quick brown fox jumps over the lazy dog","Yes"]
["Calc_Num2DP",705.5474853515625,"Yes"]
["Calc_Time","11:09:36","Yes"]
["Input_DateLong","2018-03-14","Yes"]
["Input_DateShort","2018-03-14","Yes"]
["Input_DateTime","2018-03-14","Yes"]
["Input_General","The quick brown fox jumps over the lazy dog","Yes"]
["Input_Num2DP",533.42401123046875,"Yes"]
["Input_Time","11:09:36","Yes"]
["Input_Txt","The quick brown fox jumps over the lazy dog","Yes"]
["Link2TOC_txt","The quick brown fox jumps over the lazy dog","Yes"]
[]
["20% - Accent1","The quick brown fox jumps over the lazy dog","No"]
["20% - Accent2","The quick brown fox jumps over the lazy dog","No"]
["20% - Accent3","The quick brown fox jumps over the lazy dog","No"]
["20% - Accent4","The quick brown fox jumps over the lazy dog","No"]
["20% - Accent5","The quick brown fox jumps over the lazy dog","No"]
["20% - Accent6","The quick brown fox jumps over the lazy dog","No"]
["40% - Accent1","The quick brown fox jumps over the lazy dog","No"]
["40% - Accent2","The quick brown fox jumps over the lazy dog","No"]
["40% - Accent3","The quick brown fox jumps over the lazy dog","No"]
["40% - Accent4","The quick brown fox jumps over the lazy dog","No"]
["40% - Accent5","The quick brown fox jumps over the lazy dog","No"]
["40% - Accent6","The quick brown fox jumps over the lazy dog","No"]
["60% - Accent1","The quick brown fox jumps over the lazy dog","No"]
["60% - Accent2","The quick brown fox jumps over the lazy dog","No"]
["60% - Accent3","The quick brown fox jumps over the lazy dog","No"]
["60% - Accent4","The quick brown fox jumps over the lazy dog","No"]
["60% - Accent5","The quick brown fox jumps over the lazy dog","No"]
["60% - Accent6","The quick brown fox jumps over the lazy dog","No"]
["Accent1","The quick brown fox jumps over the lazy dog","No"]
["Accent2","The quick brown fox jumps over the lazy dog","No"]
["Accent3","The quick brown fox jumps over the lazy dog","No"]
["Accent4","The quick brown fox jumps over the lazy dog","No"]
["Accent5","The quick brown fox jumps over the lazy dog","No"]
["Accent6","The quick brown fox jumps over the lazy dog","No"]
["Bad","The quick brown fox jumps over the lazy dog","No"]
["Calculation","The quick brown fox jumps over the lazy dog","No"]
["Check Cell","The quick brown fox jumps over the lazy dog","No"]
["Comma","The quick brown fox jumps over the lazy dog","No"]
["Comma [0]","The quick brown fox jumps over the lazy dog","No"]
["Currency","The quick brown fox jumps over the lazy dog","No"]
["Currency [0]","The quick brown fox jumps over the lazy dog","No"]
["Explanatory Text","The quick brown fox jumps over the lazy dog","No"]
["Followed Hyperlink","The quick brown fox jumps over the lazy dog","No"]
["Good","The quick brown fox jumps over the lazy dog","No"]
["Heading 1","The quick brown fox jumps over the lazy dog","No"]
["Heading 2","The quick brown fox jumps over the lazy dog","No"]
["Heading 3","The quick brown fox jumps over the lazy dog","No"]
["Heading 4","The quick brown fox jumps over the lazy dog","No"]
["Hyperlink","The quick brown fox jumps over the lazy dog","No"]
["Input","The quick brown fox jumps over the lazy dog","No"]
["Linked Cell","The quick brown fox jumps over the lazy dog","No"]
["Neutral","The quick brown fox jumps over the lazy dog","No"]
["Normal","The quick brown fox jumps over the lazy dog","No"]
["Note","The quick brown fox jumps over the lazy dog","No"]
["Output","The quick brown fox jumps over the lazy dog","No"]
["Percent","The quick brown fox jumps over the lazy dog","No"]
["Title","The quick brown fox jumps over the lazy dog","No"]
["Total","The quick brown fox jumps over the lazy dog","No"]
["Warning Text","The quick brown fox jumps over the lazy dog","No"]