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

{"sheet":"Project TNA Advanced","index":0,"n_rows":136,"n_cols":5,"rows_kept":136,"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],[25,1,25,2],[35,1,35,2],[39,1,39,2],[44,1,44,2],[52,1,52,2],[61,1,61,2],[69,1,69,2],[77,1,77,2],[84,1,84,2],[90,1,90,2],[102,1,102,2],[110,1,110,2],[117,1,117,2],[135,1,137,4]]}
["ATI-Mirage Training Solutions"]
["MS Project - Advanced - 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"},"Review of Introduction concepts"]
[null,{"$f":"IF(ISBLANK(C17),\" \",1)","v":1},"Save, Open, Save As, with files",null,{"$f":"IF($D$16=\"All\",$B$133,$B$134)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C18),\"\",B17+1)","v":2},"Create and set the Project settings for a new project",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C19),\"\",B18+1)","v":3},"Add, edit the information about tasks",null,"click to select value"]
[null,4,"Create a list of tasks and enter durations",null,"click to select value"]
[null,5,"Create links / relationships between tasks",null,"click to select value"]
[null,6,"Change a tasks predecessors",null,"click to select value"]
[null,7,"Switch between different views in project",null,"click to select value"]
[null,8,"Change task types ( fixed units, fixed duration, fixed work)",null,"click to select value"]
[null,9,"Customise and Print reports",null,"click to select value"]
["B","Linking Tasks"]
[null,{"$f":"IF(ISBLANK(C27),\"\",B25+1)","v":10},"Change lead and lag time",null,{"$f":"IF($D$26=\"All\",$B$133,$B$134)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C28),\"\",B27+1)","v":11},"Create milestone tasks",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C29),\"\",B28+1)","v":12},"Create and apply calendars",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C30),\"\",B29+1)","v":13},"Create a resource pool",null,"click to select value"]
[null,14,"Adjust resource information",null,"click to select value"]
[null,15,"Assign resources to tasks",null,"click to select value"]
[null,16,"Understand Effort driven scheduling",null,"click to select value"]
[null,17,"View and adjust work assignment for a task",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C35),\"\",B34+1)","v":18},"Enter project costs (fixed costs and rates of pay)",null,"click to select value"]
["C","Customising MS Project"]
[null,{"$f":"IF(ISBLANK(C37),\"\",B35+1)","v":19},"Create new tables",null,{"$f":"IF($D$36=\"All\",$B$133,$B$134)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C38),\"\",B37+1)","v":20},"Use and modify custom fields",null,{"$f":"IF($D$36=\"All\",$B$133,$B$134)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C39),\"\",B38+1)","v":21},"Create Custom Filters, Views and Reports",null,{"$f":"IF($D$36=\"All\",$B$133,$B$134)","v":"click to select value"}]
["D","Project Management"]
[null,{"$f":"IF(ISBLANK(C41),\"\",B39+1)","v":22},"Understanding and implementing Resource Levelling",null,{"$f":"IF($D$40=\"All\",$B$133,$B$134)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C42),\"\",B41+1)","v":23},"Enter actual data for a project",null,{"$f":"IF($D$40=\"All\",$B$133,$B$134)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C43),\"\",B42+1)","v":24},"Create baselines and interim plans for tracking progress",null,{"$f":"IF($D$40=\"All\",$B$133,$B$134)","v":"click to select value"}]
[null,25,"View baseline data in a table",null,{"$f":"IF($D$40=\"All\",$B$133,$B$134)","v":"click to select value"}]
["E","Tables"]
[null,{"$f":"IF(ISBLANK(C46),\"\",B44+1)","v":26},"Exploring Tables",null,{"$f":"IF($D$45=\"All\",$B$133,$B$134)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C47),\"\",B46+1)","v":27},"Creating A New Table",null,"click to select value"]
[null,28,"Adding Fields To A Table",null,"click to select value"]
[null,29,"Formatting Table Fields",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C50),\"\",B49+1)","v":30},"Using A Custom Table",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C51),\"\",B50+1)","v":31},"Using A Hyperlink Field",null,"click to select value"]
[null,32,"Change and modify a Table's structure",null,"click to select value"]
["F","Resource Levelling"]
[null,{"$f":"IF(ISBLANK(C54),\"\",B52+1)","v":33},"Understand resource over allocation",null,{"$f":"IF($D$53=\"All\",$B$133,$B$134)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C55),\"\",B54+1)","v":34},"Tracking down over allocations",null,"click to select value"]
[null,35,"Checking resource usage",null,"click to select value"]
[null,36,"Creating an over allocation report",null,"click to select value"]
[null,37,"Changing work effort in a task assignment",null,"click to select value"]
[null,38,"Assigning overtime work",null,"click to select value"]
[null,39,"Assign extra workload to other resources",null,"click to select value"]
[null,40,"Rescheduling tasks to another date",null,"click to select value"]
["G","Templates"]
[null,{"$f":"IF(ISBLANK(C63),\"\",B61+1)","v":41},"Saving a project as a template",null,{"$f":"IF($D$62=\"All\",$B$133,$B$134)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C64),\"\",B63+1)","v":42},"Using a custom template",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C65),\"\",B64+1)","v":43},"Modifying a template",null,"click to select value"]
[null,44,"Work with the global template",null,"click to select value"]
[null,45,"Use Organiser to manage the global template",null,"click to select value"]
[null,46,"Use Organiser to copy items to files and other templates",null,"click to select value"]
[null,47,"Removing items from the global template",null,"click to select value"]
["H","Interacting with other Applications"]
[null,{"$f":"IF(ISBLANK(C71),\"\",B69+1)","v":48},"Copying a Gantt chart image",null,{"$f":"IF($D$70=\"All\",$B$133,$B$134)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C72),\"\",B71+1)","v":49},"Copying table data",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C73),\"\",B72+1)","v":50},"Copying to Microsoft Excel",null,"click to select value"]
[null,51,"Linking to Microsoft Excel",null,"click to select value"]
[null,52,"Exporting to Microsoft Excel",null,"click to select value"]
[null,53,"Exporting to Excel using a map",null,"click to select value"]
[null,54,"Using visual reports",null,"click to select value"]
["I","Predefined Reports"]
[null,{"$f":"IF(ISBLANK(C79),\"\",B77+1)","v":55},"Used a predefined report",null,{"$f":"IF($D$78=\"All\",$B$133,$B$134)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C80),\"\",B79+1)","v":56},"Use report lists",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C81),\"\",B80+1)","v":57},"Modify existing reports",null,"click to select value"]
[null,58,"Creating a custom crosstabulation report",null,"click to select value"]
[null,59,"Adjusting the details of a custom report",null,"click to select value"]
[null,60,"Sharing custom reports via the organiser",null,"click to select value"]
["J","Microsoft Project Files"]
[null,{"$f":"IF(ISBLANK(C86),\"\",B84+1)","v":61},"Used and saved previous version project files to the current version",null,{"$f":"IF($D$85=\"All\",$B$133,$B$134)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C87),\"\",B86+1)","v":62},"Working with multiple files",null,{"$f":"IF($D$85=\"All\",$B$133,$B$134)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C88),\"\",B87+1)","v":63},"Creating a workspace file",null,{"$f":"IF($D$85=\"All\",$B$133,$B$134)","v":"click to select value"}]
[null,64,"Creating New Windows",null,{"$f":"IF($D$85=\"All\",$B$133,$B$134)","v":"click to select value"}]
[null,65,"Hiding files that are open",null,{"$f":"IF($D$85=\"All\",$B$133,$B$134)","v":"click to select value"}]
["K","Linking and Combining Projects"]
[null,{"$f":"IF(ISBLANK(C92),\"\",B90+1)","v":66},"Used linked projects",null,{"$f":"IF($D$91=\"All\",$B$133,$B$134)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C93),\"\",B92+1)","v":67},"Combining projects into a master project",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C94),\"\",B93+1)","v":68},"Viewing a combined project",null,"click to select value"]
[null,69,"Printing from a combined project",null,"click to select value"]
[null,70,"Setting a combined project start date",null,"click to select value"]
[null,71,"Changing data in a combined project",null,"click to select value"]
[null,72,"Used linked subproject files",null,"click to select value"]
[null,73,"Inserted subprojects",null,"click to select value"]
[null,74,"Changed subproject links",null,"click to select value"]
[null,75,"Created a read only subproject",null,"click to select value"]
[null,76,"Inserted task links to tasks in other projects",null,"click to select value"]
["L","Shared Resources"]
[null,{"$f":"IF(ISBLANK(C104),\"\",B102+1)","v":77},"Creating a common resource pool",null,{"$f":"IF($D$103=\"All\",$B$133,$B$134)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C105),\"\",B104+1)","v":78},"Link to an external pool",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C106),\"\",B105+1)","v":79},"Link a new project file to the pool",null,"click to select value"]
[null,80,"Assigning resources from the pool",null,"click to select value"]
[null,81,"Working with shared resources",null,"click to select value"]
[null,82,"Checking for resource links",null,"click to select value"]
[null,83,"Managing shared resources",null,"click to select value"]
["M","Downsizing Larger Projects"]
[null,{"$f":"IF(ISBLANK(C112),\"\",B110+1)","v":84},"Understanding project downsizing",null,{"$f":"IF($D$111=\"All\",$B$133,$B$134)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C113),\"\",B112+1)","v":85},"Creating the resource file",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C114),\"\",B113+1)","v":86},"Create smaller projects from a larger master project",null,"click to select value"]
[null,87,"Linking subprojects to resources",null,"click to select value"]
[null,88,"Creating the downsized master file",null,"click to select value"]
[null,89,"Setting project links",null,"click to select value"]
["N","Macros in Project"]
[null,{"$f":"IF(ISBLANK(C119),\"\",B117+1)","v":90},"Accessing the developer tab",null,{"$f":"IF($D$118=\"All\",$B$133,$B$134)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C120),\"\",B119+1)","v":91},"Recording a macro",null,{"$f":"IF($D$118=\"All\",$B$133,$B$134)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C121),\"\",B120+1)","v":92},"Running a macro",null,{"$f":"IF($D$118=\"All\",$B$133,$B$134)","v":"click to select value"}]
[null,93,"Examining the macro code",null,{"$f":"IF($D$118=\"All\",$B$133,$B$134)","v":"click to select value"}]
[null,94,"Adding a macro to the QAT",null,{"$f":"IF($D$118=\"All\",$B$133,$B$134)","v":"click to select value"}]
[null,95,"Understanding VBA in Microsoft project",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$125,No_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C130/COUNTA($E$17:$E$124))","v":{"v":0,"d":"0.00%"}}]
[null,"Basic Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$125,Basic_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C131/COUNTA($E$17:$E$124))","v":{"v":0,"d":"0.00%"}}]
[null,"Good Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$125,Good_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C132/COUNTA($E$17:$E$124))","v":{"v":0,"d":"0.00%"}}]
[null,"Expert",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$125,Expert))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C133/COUNTA($E$17:$E$124))","v":{"v":0,"d":"0.00%"}}]
[null,"click to select value",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$125,click_to_select_value))","v":95},{"$f":"IF(ISBLANK($E$17),\"\",C134/COUNTA($E$17:$E$124))","v":{"v":1,"d":"100.00%"}}]
[null,{"v":0.8,"d":"80%"}]
[null,{"$f":"IF(C134>0,\"We cannot make an Assessment as you have not completed ALL of the questions, check the Yellow cells\",IF(OR(D130>=60%,(D131+D130)>=60%),\"We suggest that you do the Introduction course\",\"Based on your responses you have NO knowledge of some Advanced  concepts, we suggest that you do the  Advanced Course\"))","v":"We cannot make an Assessment as you have not completed ALL of the questions, check the Yellow cells"}]