{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Project  IntroductionTNA"],"not_rendered":{"charts":1,"external_links":2,"defined_names":29},"read":"whole","date_system":"1900"}

{"sheet":"Project  IntroductionTNA","index":0,"n_rows":60,"n_cols":5,"rows_kept":60,"merged":[[0,0,0,4],[1,0,1,4],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[10,1,11,4],[12,1,12,4],[15,1,15,2],[18,1,18,2],[24,1,24,2],[31,1,31,2],[40,1,40,2],[43,1,43,2],[59,1,61,4]]}
["ATI-Mirage Training Solutions"]
["Project - Introduction - Training Needs Analysis (TNA)"]
[]
["Name:"]
["Organisation Name:"]
["Department:"]
["Telephone:"]
["Mobile :"]
["Email:"]
[]
[null,"Please choose one response that most accurately describes your knowledge level for each topic. This is not a test, therefore your responses will address your training needs for the level that you are at."]
[]
[null,"Use the Blue Coloured cells if you know all of a Section, otherwise click the yellow cell to select an option"]
[]
[null,"Section","Question","ALL","Response"]
[{"$f":"IF(ISBLANK(B16),\"\",\"A\")","v":"A"},"Project Management Overview"]
[null,{"$f":"IF(ISBLANK(C17),\" \",1)","v":1},"Familiarity with Project management concepts",null,{"$f":"IF($D$16=\"All\",$B$57,$B$58)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C18),\"\",B17+1)","v":2},"Familiarity with Project management terms",null,{"$f":"IF($D$16=\"All\",$B$57,$B$58)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B19),\"\",\"B\")","v":"B"},"MS Project Environment"]
[null,{"$f":"IF(ISBLANK(C20),\"\",B18+1)","v":3},"Knowledge of the MS Project menus and commands",null,{"$f":"IF($D$19=\"All\",$B$57,$B$58)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C21),\"\",B20+1)","v":4},"File management: Save; Save as; Open files",null,{"$f":"IF($D$19=\"All\",$B$57,$B$58)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C22),\"\",B21+1)","v":5},"Use views in Ms Project",null,{"$f":"IF($D$19=\"All\",$B$57,$B$58)","v":"click to select value"}]
[null,6,"Use tables in MS Project",null,{"$f":"IF($D$19=\"All\",$B$57,$B$58)","v":"click to select value"}]
[]
[{"$f":"IF(ISBLANK(B25),\"\",\"C\")","v":"C"},"MS Project Techniques"]
[null,{"$f":"IF(ISBLANK(C26),\"\",B24+1)","v":1},"Create and define the settings for a new Project",null,{"$f":"IF($D$25=\"All\",$B$57,$B$58)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C27),\"\",B26+1)","v":2},"Set working hours and times in MS Project",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C28),\"\",B27+1)","v":3},"Set the Project Start date and other project settings",null,"click to select value"]
[null,4,"Set options for a project",null,"click to select value"]
[null,5,"Create a custom calendar for a project",null,"click to select value"]
[null,6,"Understand Manual and Automatic Scheduling",null,"click to select value"]
[{"$f":"IF(ISBLANK(B32),\"\",\"D\")","v":"D"},"Working With Tasks"]
[null,{"$f":"IF(ISBLANK(B32),\"\",B31+1)","v":7},"Enter a list of Tasks",null,{"$f":"IF($D$32=\"All\",$B$57,$B$58)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C34),\"\",B33+1)","v":8},"Organise tasks into groups / outlines with Summary Tasks",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C35),\"\",B34+1)","v":9},"Enter task durations and Milestone tasks",null,"click to select value"]
[null,10,"Format task lists",null,"click to select value"]
[null,11,"Insert, move and copy tasks",null,"click to select value"]
[null,12,"Link tasks / work with task relationships",null,"click to select value"]
[null,13,"Modify task relationships",null,"click to select value"]
[null,14,"Format tasks on the Gantt chart",null,"click to select value"]
[{"$f":"IF(ISBLANK(B41),\"\",\"E\")","v":"E"},"Working With Resources"]
[null,{"$f":"IF(ISBLANK(C42),\"\",B40+1)","v":15},"Creating a list of Resources (Resource Pool)",null,{"$f":"IF($D$41=\"All\",$B$57,$B$58)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C43),\"\",B42+1)","v":16},"Assigning Resources to Tasks",null,{"$f":"IF($D$41=\"All\",$B$57,$B$58)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B44),\"\",\"F\")","v":"F"},"Printing and Print Preview"]
[null,{"$f":"IF(ISBLANK(C45),\"\",B43+1)","v":17},"Use page setup to set Printing options",null,{"$f":"IF($D$44=\"All\",$B$57,$B$58)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C46),\"\",B45+1)","v":18},"Preview a print job",null,{"$f":"IF($D$44=\"All\",$B$57,$B$58)","v":"click to select value"}]
[null,19,"Print a Gantt chart",null,"click to select value"]
[null,20,"Print sheet views",null,"click to select value"]
[]
[]
[null,null,"PLEASE ENSURE THAT YOU HAVE ANSWERED ALL QUESTIONS"]
[]
[null,"Responses","Score","Percentage"]
[null,"No Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$49,No_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C54/COUNTA($E$17:$E$48))","v":{"v":0,"d":"0.00%"}}]
[null,"Basic Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$49,Basic_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C55/COUNTA($E$17:$E$48))","v":{"v":0,"d":"0.00%"}}]
[null,"Good Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$49,Good_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C56/COUNTA($E$17:$E$48))","v":{"v":0,"d":"0.00%"}}]
[null,"Expert",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$49,Expert))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C57/COUNTA($E$17:$E$48))","v":{"v":0,"d":"0.00%"}}]
[null,"click to select value",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$49,click_to_select_value))","v":26},{"$f":"IF(ISBLANK($E$17),\"\",C58/COUNTA($E$17:$E$48))","v":{"v":1,"d":"100.00%"}}]
[null,{"v":0.6,"d":"60%"}]
[null,{"$f":"IF(C58>0,\"We cannot make an Assessment as you have not completed ALL of the questions, check the Yellow cells\",IF(OR(D54>=CriteriaToPass,(D54+D55)>=CriteriaToPass),\"We suggest that you do the Introduction course\",\"Based on your response you have good knowledge of Introductory Excel concepts, we suggest that you do the Intermediate TNA, to check if you would be comfortable doing the Intermediate Course\"))","v":"We cannot make an Assessment as you have not completed ALL of the questions, check the Yellow cells"}]