{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["main","Help"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":0,"defined_names":40,"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":"main","index":0,"n_rows":7,"n_cols":16,"rows_kept":7,"cut":false,"hidden":false,"merged":[[4,0,4,4],[0,12,0,13],[0,2,0,7]]}
[null,0,1,null,null,null,null,null,null,null,"Tykoh Online Resources",null,"Help",null,null,{"$f":"\"v \" & zz_TOC_major_version & \".\" & TEXT(zz_TOC_minor_version,\"00\")","v":"v 2.05"}]
[null,null,null,null,null,null,null,null,null,null,"www.tykoh.com"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(LEN(NOW())>100,ISERROR(macrocheck())),\"You must enable macros. See the help sheet.\",\"\")","v":""},false,"$E$9:$M$16","guest"]
[null,null,null,null,null,null,null,null,null,null,null,"MathComp",null,"guest",3,-0.5]
[null,null,null,null,null,null,null,null,null,null,null,false,false,"UUID25_11_2020_8_36_29_AM_","MathComp","MathComp"]
[null,null,null,null,null,null,null,null,null,null,null,null,2,5,"ModComp","ModComp"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SSkillsComp","SSkillsComp"]

{"sheet":"Help","index":1,"n_rows":353,"n_cols":12,"rows_kept":353,"cut":false,"hidden":false,"merged":[[0,4,0,9],[60,3,61,10],[68,3,68,9],[15,1,16,10],[43,3,45,10],[1,4,1,9],[21,1,22,10],[18,1,20,10],[27,1,29,10],[39,2,40,10],[56,3,56,10],[352,3,353,10],[304,3,305,10],[210,3,213,10],[121,3,122,10],[135,3,136,10],[307,3,308,10],[71,3,81,10],[84,3,86,10],[125,3,125,10],[343,3,344,10],[286,3,287,10],[248,3,251,10],[182,3,183,10],[168,3,169,10],[252,3,253,10],[164,3,165,10],[334,3,336,10],[338,3,339,10],[256,3,257,10],[272,3,273,10]]}
[null,null,null,null,{"$f":"main!K1","v":"Tykoh Online Resources"},null,null,null,null,null,null,{"$f":"main!P1","v":"v 2.05"}]
[null,null,null,null,{"$f":"main!K2","v":"www.tykoh.com"}]
[]
[]
[null,null,"Help Index"]
[null,null,null,{"$f":"B14","v":"Introduction"}]
[null,null,null,{"$f":"B43","v":"How to use this spreadsheet."}]
[null,null,null,{"$f":"zz_help_answers","v":"Where are the answers?"}]
[null,null,null,{"$f":"B333","v":"Saving your work"}]
[null,null,null,{"$f":"zz_help_enable_macros","v":"Enabling macros"}]
[null,null,null,">>> Go to front page"]
[]
[]
[null,"Introduction"]
[]
[null,"You can access a collection of online resources by using this spreadsheet. "]
[]
[]
[null,"To sample the resources available online you can log in using a guest account.  The guest account's username is guest and the password is also guest."]
[]
[]
[null,"Macros must be enabled to use this spreadsheet.  This spreadsheet may not work in corporate settings or elsewhere where firewalls restrict online access. "]
[]
[null,null,null,null,null,null,null,null,null,null,"Back to top"]
[]
[null,"Where are the answers?"]
[]
[null,"A subset of the answers to the accompanying exercises are available online and you can download these.  To download the available answers for the page you are currently on right-mouse-click.  A menu item will appear titled \"Tykoh load answers\" .."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Click on the menu item and the available answers will be downloaded.  Note that not all answers will necessarily be available."]
[]
[null,null,null,null,null,null,null,null,null,null,"Back to top"]
[null,"How to use this spreadsheet."]
[null,null,null,"Obtain a copy of this spreadsheet.  Obviously you have already done this.  The most recent version of this spreadsheet is downloadable from the following location:"]
[null,null,"►"]
[]
[null,null,null,null,"https://www.tykoh.com/downloads/TykohOnlineResources.xlsm"]
[]
[null,null,"►","Enable editing (if necessary)."]
[]
[]
[]
[]
[]
[]
[]
[null,null,"►","Save this spreadsheet somewhere on your laptop or PC."]
[]
[null,null,"►","Start Excel and open this spreadsheet."]
[]
[null,null,"►","Enable macros in this spreadsheet.  A message like the following will appear to remind you if macros need to be enabled."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"*** Click on this link for more information about how to enable macros. ***"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K24","v":"Back to top"}]
[null,null,"►","Click on the \"Begin\" button on the first page."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"A Login screen will appear."]
[]
[null,null,"►","Enter your username and password.  You can use a guest username and password if you wish.  The guest username and password is \"guest\" (without the quotes).  [The guest account is limited is the range of resources available.]"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K24","v":"Back to top"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"After you have pressed the \"Log In\" button a list of resources will appear in the listbox titled \"Resources you have permission to\"."]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K24","v":"Back to top"}]
[]
[null,null,"►","Choose one of the resources that you have permissions to and press the \"Select resource\" button."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"A \"title page\" will appear that lists the various topics within the resource you have selected.  The title page will have a structure like that shown below."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"The chosen resource will contain a set of topics.  Each topic will contain a set of sections and each section will contain a set of items.  "]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K24","v":"Back to top"}]
[]
[null,null,"►","Choose any item by clicking on its hyperlink.  Suppose, for example, the hyperlink you click on is the one shown below:  \"Provisioning a reserve account to fund two future projects\"."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"The topic that the item is part of will be automatically loaded into this spreadsheet  That topic will be shown with a light-yellow background and red borders:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Now that the topic is loaded, clicking on the item's hyperlink will take you directly to the associated tab in this spreadsheet.  [Note that hyperlinking is immediate when you keep within the currently active topic.  When you move between topics there will be a short delay during which the old topic is saved and the new one is loaded.]"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K24","v":"Back to top"}]
[]
[null,null,"►","Read the item that you hyperlinked to and begin solving the problem described there."]
[]
[null,null,null,"In the example we have been considering the hyperlinked item looks like the following:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"You need to design Excel formulae for the sections that have a blue-grey background (e.g in the area labelled \"Formulae go in here\" in the diagram above)..  When the formulae return the correct values the cells in the automatic marking section on the left will turn from blue to yellow. "]
[]
[]
[]
[null,null,null,"In the example above the formula in cell S30 returns the correct value so the \"s\" marker in Cell D30 has turned yellow."]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K24","v":"Back to top"}]
[]
[null,null,"►","Complete the solution to the problem.  When the problem is fully solved all of the blue markers on the left will have turned to yellow."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K24","v":"Back to top"}]
[]
[null,null,"►","Click on the \"Index\" hyperlink to take you back to the table of contents on the front page.  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Now that the question has been fully and correctly answered the associated marker in the table of contents on the front page has changed from \"x\" to \"-\"."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K24","v":"Back to top"}]
[]
[null,"Expanding and contracting topics and sections"]
[]
[null,null,null,"To prevent undue clutter and to let you focus on particular topics and sections you can expand or contact the table of contents on the front page."]
[]
[]
[null,null,null,"Click on a \"[-]\" icon to contract a topic or section and click on a \"[+]\" icon to expand it.  The following snapshot shows a section being contracted and expanded again."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K24","v":"Back to top"}]
[null,"Saving your work"]
[]
[null,null,null,"You don't need to save your work - saving happens automatically when you navigate from topic to topic.  Be sure, however, to log out when you have finished working.  If you don't log out then changes made to the last topic you worked on will not be saved."]
[]
[]
[]
[null,null,null,"There is no point in saving your work to your local PC or laptop because the spreadsheet will be cleared and reset the next time it is opened."]
[]
[]
[null,"Enabling macros"]
[]
[null,null,null,"To use this spreadsheet you must have macros enabled. If macros are not enabled you'll see this message at the top of the first page:"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"If you see that message that means that Excel has disabled macros in this spreadsheet and you will need to enable them."]