{"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":61,"n_cols":5,"rows_kept":61,"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],[26,1,26,2],[30,1,30,2],[36,1,36,2],[41,1,41,2],[45,1,45,2],[60,1,62,4]]}
["ATI-Mirage Training Solutions"]
["Project - Intermediate - 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$58,$B$59)","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$58,$B$59)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B19),\"\",\"B\")","v":"B"},"Working With Resources"]
[null,{"$f":"IF(ISBLANK(C20),\"\",B18+1)","v":3},"Creating a list of Resources (Resource Pool)",null,{"$f":"IF($D$19=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C21),\"\",B20+1)","v":4},"Adjusting Resource information",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C22),\"\",B21+1)","v":5},"Assigning Resources to Tasks",null,"click to select value"]
[null,6,"Viewing Resources assignment",null,"click to select value"]
[null,7,"Working with Lag and Lead time",null,"click to select value"]
[null,8,"Modifying Task types",null,"click to select value"]
[null,9,"Resolving Resource over-allocation",null,"click to select value"]
[{"$f":"IF(ISBLANK(B27),\"\",\"C\")","v":"C"},"Resource Work Allocation"]
[null,{"$f":"IF(ISBLANK(B27),\"\",B26+1)","v":10},"Adjust and modify work on a task assignment",null,{"$f":"IF($D$27=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C29),\"\",B28+1)","v":11},"View Task and Resource work allocations",null,{"$f":"IF($D$27=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C30),\"\",B29+1)","v":12},"Contouring Resource work ",null,{"$f":"IF($D$27=\"All\",$B$58,$B$59)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B31),\"\",\"D\")","v":"D"},"Working with Costs"]
[null,{"$f":"IF(ISBLANK(B31),\"\",B30+1)","v":13},"Enter Resources costs and rates of Pay",null,{"$f":"IF($D$31=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C33),\"\",B32+1)","v":14},"Enter Task Costs",null,{"$f":"IF($D$31=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C34),\"\",B33+1)","v":15},"Change standard Rates of pay",null,{"$f":"IF($D$31=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,16,"View Cost information",null,{"$f":"IF($D$31=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,17,"Print Cost Information",null,{"$f":"IF($D$31=\"All\",$B$58,$B$59)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B37),\"\",\"E\")","v":"E"},"Project Tracking"]
[null,{"$f":"IF(ISBLANK(C38),\"\",B36+1)","v":18},"Set a Baseline",null,{"$f":"IF($D$37=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C39),\"\",B38+1)","v":19},"View Baseline information",null,{"$f":"IF($D$37=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,20,"Enter task progress data",null,{"$f":"IF($D$37=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,21,"View Slipping Tasks",null,{"$f":"IF($D$37=\"All\",$B$58,$B$59)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B42),\"\",\"F\")","v":"F"},"Reports"]
[null,{"$f":"IF(ISBLANK(C43),\"\",B41+1)","v":22},"View and Print MS Project Reports",null,{"$f":"IF($D$42=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C44),\"\",B43+1)","v":23},"Create a Custom Report",null,{"$f":"IF($D$42=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,24,"Print a Report",null,{"$f":"IF($D$42=\"All\",$B$58,$B$59)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B46),\"\",\"G\")","v":"G"},"Constraints and Deadlines"]
[null,{"$f":"IF(ISBLANK(C47),\"\",B45+1)","v":25},"Add Constraints to Task",null,{"$f":"IF($D$46=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C48),\"\",B47+1)","v":26},"Adjust the Task constraint",null,{"$f":"IF($D$46=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,27,"Create a Deadline",null,{"$f":"IF($D$46=\"All\",$B$58,$B$59)","v":"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$50,No_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C55/COUNTA($E$17:$E$49))","v":{"v":0,"d":"0.00%"}}]
[null,"Basic Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$50,Basic_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C56/COUNTA($E$17:$E$49))","v":{"v":0,"d":"0.00%"}}]
[null,"Good Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$50,Good_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C57/COUNTA($E$17:$E$49))","v":{"v":0,"d":"0.00%"}}]
[null,"Expert",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$50,Expert))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C58/COUNTA($E$17:$E$49))","v":{"v":0,"d":"0.00%"}}]
[null,"click to select value",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$50,click_to_select_value))","v":27},{"$f":"IF(ISBLANK($E$17),\"\",C59/COUNTA($E$17:$E$49))","v":{"v":1,"d":"100.00%"}}]
[null,{"v":0.6,"d":"60%"}]
[null,{"$f":"IF(C59>0,\"We cannot make an Assessment as you have not completed ALL of the questions, check the Yellow cells\",IF(OR(D55>=CriteriaToPass,(D55+D56)>=CriteriaToPass),\"We suggest that you do the Intermediate course\",\"Based on your response you have good knowledge of Intermediate Excel concepts, we suggest that you do the Advanced TNA, to check if you would be comfortable doing the Advanced Course\"))","v":"We cannot make an Assessment as you have not completed ALL of the questions, check the Yellow cells"}]