{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Course planner","Schedule planner","Courses chosen"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":2,"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":"Course planner","index":0,"n_rows":161,"n_cols":15,"rows_kept":161,"cut":false,"hidden":false,"merged":[[2,7,12,14],[24,1,24,5],[15,7,23,14],[24,7,24,13]]}
[]
[null,"Fundamentals (23 EC) ",null,null,{"$f":"SUM(E28:E31)","v":23},{"$f":"IF(E2=23, \"Correct\", \"Insufficient\")","v":"Correct"},null,"Short explanation"]
[null,null,null,null,null,null,null,"> This excel sheet can be used to determine how the years of your master degree will look like. It presents an overview of the courses that can be followed in each quarter and may thus help to plan your studies. \n> First, you have to fill in the course planner by ticking the 'no' boxes into 'yes' for the courses you'd like to follow. If the overview says 'correct' you fulfilled all requirements. After that, click the blue button \"Calculate ECTS\" on the tab courses chosen. The chosen courses are subsequently exported to the Courses Chosen tab and your ECTS are calculated.\n> In the courses chosen tab, you can check whether you miss any courses in the schedule. This is also indicated in the schedule planner tab, if the scheduled credits don't add up to the chosen number of credits.  You can schedule your courses based on course code by making use of the drop down menu in the year overview. The corresponding course name and number of credits will be filled in for you. In the same overview you see the total number of credits you will follow in each quarter. \n> Ending up around 15 ECTS makes the study load doable. "]
[null,"Specialisations (27 EC) (1 specialisation) ",null,null,{"$f":"SUM(E5:E8)","v":0},{"$f":"IF(E4>=27, \"Correct\", \"Insufficient\")","v":"Insufficient"}]
[null,null,null,"Specialisation P - Policy: Infrastructure, Planning and Environment",{"$f":"IF(B34=\"Yes\", SUM(E35:E40), 0)","v":0}]
[null,null,null,"Specialisation D - Design: Transport Systems and Networks",{"$f":"IF(B42=\"Yes\", SUM(E43:E48), 0)","v":0}]
[null,null,null,"Specialisation O - Operations: Traffic, Technology and Control",{"$f":"IF(B51=\"Yes\", SUM(E52:E57), 0)","v":0}]
[null,null,null,"Specialisation E - Engineering: Transport, Logistics and Supply Chains",{"$f":"IF(B59=\"Yes\", SUM(E60:E65), 0)","v":0}]
[]
[null,"Electives (25 EC) ",null,null,{"$f":"SUM(E11:E15)","v":0},{"$f":"IF(E10>=25,\"Correct\",\"Insufficient\")","v":"Insufficient"}]
[null,null,"Electives T&P - Transport and Planning (at least 1 course) ",null,{"$f":"SUMIF(B69:B84, \"Yes\", E69:E84)","v":0},{"$f":"IF(E11>=1,\"Correct\",\"Insufficient\")","v":"Insufficient"}]
[null,null,"Electives T&L - Transport & Logistics (at least 1 course) ",null,{"$f":"SUMIF(B87:B97, \"Yes\",E87:E96)","v":0},{"$f":"IF(E12>=1,\"Correct\",\"Insufficient\")","v":"Insufficient"}]
[null,null,"Electives MME - Multi Machine Engineering (at least 1 course) ",null,{"$f":"SUMIF(B100:B110, \"Yes\",E100:E110)","v":0},{"$f":"IF(E13>=1,\"Correct\",\"Insufficient\")","v":"Insufficient"}]
[null,null,"External Electives (at least 1 course)",null,{"$f":"SUMIF(B114:B135, \"Yes\",E114:E135)","v":0},{"$f":"IF(E14>=1,\"Correct\",\"Insufficient\")","v":"Insufficient"}]
[null,null,"Free electives",null,{"$f":"SUMIF(B138:B140, \"Yes\",E138:E140)","v":0},null,null,"Some Remarks"]
[null,null,null,null,null,null,null,"> This form can be used as an indication. In all cases the study regulations should be followed.\n> For more information about the courses see: studyguide.tudelft.nl\n> In the schedule planner, resits are not considered. \n> Courses that extend over two periods will only show up as counted in the second period in this system, so keep that in mind. Also, the real study load per period varies, so please check it in the respective study guide.\n> Optional courses should be filled in completely to make the system work\n> MSC Thesis can be followed in each quarter, so also Q5, but you have to find your own mentor. In the Schedule planner the ECTS load is not divided into different quarters\nAny questions or comments can be sent to: education@dispuutverkeer.nl"]
[null,"TIL Projects (15 EC)",null,null,{"$f":"SUMIF(B143:B144, \"Yes\", E143:E144)","v":0},{"$f":"IF(E17=15,\"Correct\",\"Insufficient\")","v":"Insufficient"}]
[]
[null,"Thesis (30 EC) ",null,null,{"$f":"IF(B147=\"Yes\", SUM(E147), 0)","v":0},{"$f":"IF(E19=30,\"Correct\",\"Insufficient\")","v":"Insufficient"}]
[]
[null,"Other courses (optional)",null,null,{"$f":"SUMIF(B151:B161, \"Yes\", E151:E161)","v":0}]
[null,"Note: 'other courses' may not count for the curriculum, please check with Stefano Fazi if you are not sure"]
[null,"Total",null,null,{"$f":"SUM(E2,E4,E10,E17,E19,E21)","v":23},{"$f":"IF(COUNTIF(F19,\"Correct\")+COUNTIF(F2:F17,\"Correct\")=9,\"Correct\",\"Insufficient\")","v":"Insufficient"}]
[]
[null,"Use the blue cells with drop-down lists to configure your own curriculum",null,null,null,null,null,"After you've filled in all your courses and whenever you make any changes, click the blue button on the courses chosen tab."]
[]
[null,"Fundamentals (23 EC) ",null,null,"ECTS","Quarter(s)","other option"]
[null,"Yes","CIE4801-18","Transport Modelling ",6,1]
[null,"Yes","ME44206","Quantitative Methods for Logistics ",5,1.2,null,null,null,null,null,null,null,null,{"$f":"E29/2","v":2.5}]
[null,"Yes","SEN1221","Statistical Analysis of Choice Behaviour ",5,2]
[null,"Yes","TIL4030-20","TIL Research and Design Methods ",7,1.2,null,null,null,null,null,null,null,null,{"$f":"E31/2","v":3.5}]
[]
[null,"Specialisations (27 EC) (1 specialisation) "]
[null,"No","Specialisation P - Policy: Infrastructure, Planning and Environment",null,"ECTS","Quarter(s)","other option"]
[null,{"$f":"B34","v":"No"},"AR0228","Infrastructure and Environment Method Module ",5,2,4]
[null,{"$f":"B35","v":"No"},"AR0168","People, Movement and Public Space ",5,4]
[null,"No","CIE5816 ","Urban Regions, Transport and Economics ",4,4]
[null,"No","CIE5817 ","Assessment of Transport Infrastructure and Systems ",4,3]
[null,"No","SEN171A","Advanced Evaluation Methods for Transport Policy Decision-making ",5,1]
[null,"No","TPM004a","Transport Safety",5,4]
[]
[null,"No","Specialisation D - Design: Transport Systems and Networks",null,"ECTS","Quarter(s)","other option"]
[null,{"$f":"B42","v":"No"},"AE4423-20","Airline Planning & Optimisation ",4,2]
[null,{"$f":"B43","v":"No"},"AE4426 ","Airport Operations ",4,3]
[null,"No","CIE4811-18 ","Planning and Operations of Public Transport Systems ",6,1]
[null,"No","CIE5803-18","Railway Traffic Management",6,2]
[null,"No","CIE5826 ","Railway Operations and Control ",4,3]
[null,"No","SEN1721 ","Travel Behaviour Research",5,2]
[]
[]
[null,"No","Specialisation O - Operations: Traffic, Technology and Control",null,"ECTS","Quarter(s)","other option"]
[null,{"$f":"B51","v":"No"},"CIE4825 ","Traffic Flow Modelling and Control Part 1 ",6,2]
[null,{"$f":"B52","v":"No"},"CIE5805-18 ","Intelligent Vehicles for Safe and Efficient Traffic: Design and Assessment ",4,4]
[null,"No","CIE5821 ","Traffic Flow Modelling and Control Part 2 ",4,3]
[null,"No","ME44200","Operations and Maintenance",3,3]
[null,"No","ME44305 ","System Analysis and Simulation ",5,3.4,null,null,null,null,null,null,null,null,{"$f":"E56/2","v":2.5}]
[null,"No","SEN9110 ","Simulation Masterclass ",5,1]
[]
[null,"No","Specialisation E - Engineering: Transport, Logistics and Supply Chains",null,"ECTS","Quarter(s)","other option"]
[null,{"$f":"B59","v":"No"},"CIE5830 ","Freight Transport Systems: Analysis and Modelling ",5,3]
[null,{"$f":"B60","v":"No"},"ME44101","Dynamics and Interaction of Material and Equipment",4,1]
[null,"No","ME44300 ","Multi-Machine Coordination For Logistics ",3,4]
[null,"No","ME44311","Advanced Operations Management ",5,3.4,null,null,null,null,null,null,null,null,{"$f":"E63/2","v":2.5}]
[null,"No","TPM028a","Decision making in multimodal transport systems ",5,2]
[null,"No","SEN9720 ","Logistics and Supply Chain Innovations ",5,1]
[]
[null,"Electives (25EC) "]
[null,null,"Electives T&P - Transport and Planning (at least 1 course) ",null,"ECTS","Quarter(s)","other option"]
[null,"No","CIE4811-18 ","Planning and Operations of Public Transport Systems ",6,1]
[null,"No","CIE4825 ","Traffic Flow Modelling and Control Part 1 ",6,2]
[null,"No","CIE4831-18 ","Empirical Analysis for Transport & Planning ",6,2]
[null,"No","CIE4845 ","Emerging Topics for Transport & Planning ",4,4]
[null,"No","CIE5802-18 ","Advanced Transport Modelling ",4,2]
[null,"No","CIE5803-18 ","Railway Traffic Management ",4,4]
[null,"No","CIE5805-18 ","Intelligent Vehicles for Safe and Efficient Traffic: Design and Assessment",4,4]
[null,"No","CIE5810-19","Traffic Safety",4,2]
[null,"No","CIE5815 ","Resilient Transport Systems: Analysis and Interventions ",4,3]
[null,"No","CIE5816","Urban Regions, Transport and Economics ",4,4]
[null,"No","CIE5817","Assessment of Transport Infrastructure and Systems ",4,3]
[null,"No","CIE5821","Traffic Flow Modelling and Control Part 2 ",4,3]
[null,"No","CIE5822","Active Modes: Traffic and Transport ",4,3]
[null,"No","CIE5825","Advanced Public Transport Operations and Modelling ",4,3]
[null,"No","CIE5826","Railway Operations and Control ",4,3]
[null,"No","CIE5830","Freight Transport Systems: Analysis and Modelling ",5,3]
[]
[null,null,"Electives T&L - Transport & Logistics (at least 1 course) ",null,"ECTS","Quarter(s)","other option"]
[null,"No","TPM023a","Cost-benefit Analysis: Theory and Application",3,1]
[null,"No","SEN115a","Law and Institutions",5,3]
[null,"No","SEN171A ","Advanced Evaluation Methods for Transport Policy Decision-making ",5,1]
[null,"No","SEN1721 ","Travel Behaviour Research ",5,2]
[null,"No","SEN1741 ","Innovations in Transport and Logistics ",5,4]
[null,"No","SEN9110 ","Simulation Masterclass ",5,1]
[null,"No","TPM028a","Decision making in multimodal transport systems ",5,2]
[null,"No","SEN9720 ","Logistics and Supply Chain Innovations ",5,1]
[null,"No","SEN9725 ","Supply Chain Gaming ",5,2]
[null,"No","TPM004A ","Transport Safety ",5,1]
[null,"No","TPM032a","Multi-Criteria Decision Analyiss",5,1]
[]
[null,null,"Electives MME - Multi Machine Engineering (at least 1 course) ",null,"ECTS","Quarter(s)","other option"]
[null,"No","ME44101","Dynamics and Interaction of Material and Equipment",4,1]
[null,"No","ME44105 ","Structural Design with FEM  (no new link)",4,2]
[null,"No","ME44110 ","Integration Project Multi-Machine Systems",5,3.4,null,null,null,null,null,null,null,null,4]
[null,"No","ME44115 ","Discrete Element Method (DEM) simulation ",4,3]
[null,"No","ME44125 ","Reliability and Maintenance of Transport Equipment",3,3]
[null,"No","ME44200 ","Operations and Maintenance",3,3]
[null,"No","ME44300 ","Multi-Machine Coordination for Logistics",3,4]
[null,"No","ME44305 ","System Analysis and Simulation ",5,3.4,null,null,null,null,null,null,null,null,4]
[null,"No","ME44311","Advanced Operations and Production Management ",5,3.4,null,null,null,null,null,null,null,null,4]
[null,"No","ME44312","Machine Learning for Transport and Multi-Machine Systems",3,4]
[null,"No","ME44210","Drive & Energy Systems"]
[]
[null,null,"External Electives (at least 1 course)"]
[null,null,"Electives C&O - Control and Operations",null,"ECTS","Quarter(s)","other option"]
[null,"No","AE4321-15 ","Air Traffic Management  (no updated link yet)",4,2.2999999999999998]
[null,"No","AE4423-20","Airline Planning & Optimisation  (no updated link yet)",3,2]
[null,"No","AE4446","Airport Operations (no updated link yet)",4,3]
[]
[]
[null,null,"Electives U - Urbanism",null,"ECTS","Quarter(s)","other option"]
[null,"No","AR0228","Infrastructure and Environment Method Module ",5,2,4,null,null,null,null,null,null,null,4]
[null,"No","AR0168","People, Movement and Public Space ",5,4]
[null,"No","AR3CS010 ","Workshop Cross Domain City of the Future",3,1.2]
[null,"No","AR3CS021","Seminar Cross Domain City of the Future",6,1.2]
[null,"No","AR8003TU ","Legal and Governance ",5,1]
[]
[null,null,"Electives TIL - other TIL fields",null,"ECTS","Quarter(s)","other option"]
[null,"No","CIE4330 ","Ports and Waterways 1 ",4,1]
[null,"No","CIE5306 ","Ports and Waterways 2",4,4]
[null,"No","CIE4874","Elements of Railway Engineering",4,2]
[null,"No","CME2300 ","Financial Engineering",4,1]
[null,"No","ME41106","Intelligent Vehicles ",4,2]
[null,"No","MT44070 ","Shipping Management ",5,3]
[null,"No","RO47016","Automotive Human Factors",5,4]
[null,"No","WI4062TU","Transport, Routing and Scheduling",3,3]
[null,"No","WM1301TU ","Ethics of Transportation",3,3]
[]
[null,null,"Free electives (optional)",null,"ECTS","Quarter(s)","other option","other option","other option"]
[null,"No","TIL6010","TIL Programming",2,1]
[null,"No","TIL6020","TIL Scientific Assignment",7,1,2,3,4]
[null,"No","TIL6000","TIL Capita Selecta"]
[]
[null,"TIL Projects (15 EC) ",null,null,"ECTS","Quarter(s)","other option","other option","other option"]
[null,"No","TIL4020-20","TIL Research Project",5,1,3]
[null,"No","TIL5050-20","TIL Design Project",10,1.2,2.2999999999999998,3.4,4.0999999999999996,null,null,null,null,null,4]
[]
[null,"Thesis (30 EC)",null,null,"ECTS","Quarter(s)","other option","other option","other option"]
[null,"No","TIL5060","TIL Thesis",30,1.2,2.2999999999999998,3.4,4.5,null,null,null,null,null,4]
[]
[null,"Optional: fill in additional courses yourself "]
[null,null,"Course code ","Course name ","ECTS","Quarter ","other option"]
[null,"No"]
[null,"No"]
[null,"No"]
[null,"No"]
[null,"No"]
[null,"No"]
[null,null,"Fill in here the courses that take 2 quarters as follows in the 'quarter' column: 1+2 or 2+3 or 3+4. "]
[null,"No",null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"No",null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"No",null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"No",null,null,null,null,{"$f":"G160+IF($B161=\"Yes\",IF(F161=\"1+2\",IF($L161=1,1)))","v":0},{"$f":"H160+IF($B161=\"Yes\",IF(F161=\"1+2\",IF($M161=2,1),(IF(F161=\"2+3\",IF($M161=2,1)))))","v":0},{"$f":"I160+IF($B161=\"Yes\",IF(F161=\"2+3\",IF($N161=3,1),(IF(F161=\"3+4\",IF($N161=3,1)))))","v":0},{"$f":"J160+IF($B161=\"Yes\",IF(F161=\"3+4\",IF($O161=4,1)))","v":0},{"$f":"K160+IF($B161=\"Yes\",1)","v":0},1,2,3,4]

{"sheet":"Schedule planner","index":1,"n_rows":135,"n_cols":14,"rows_kept":135,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Year 1","Q1","Name","ECTS","Q2","Name","ECTS","Q3","Name","ECTS","Q4","Name","ECTS"]
[null,null,null,{"$f":"VLOOKUP($C$3,$A$48:$D$136,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR(IF(OR(C3=\"TIL4030-20\",C3=\"ME44206\",C3=\"TIL5050-20\"),\"\",VLOOKUP($C3,$A$48:$D$136,3,FALSE)),\"\")","v":""},null,{"$f":"VLOOKUP($F3,$A$48:$D$136,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP($F3,$A$48:$D$136,3,FALSE),\"\")","v":""},null,{"$f":"VLOOKUP($I3,$A$48:$D$136,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP($I3,$A$48:$D$136,3,FALSE),\"\")","v":""},null,{"$f":"VLOOKUP($L3,$A$48:$D$136,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP($L3,$A$48:$D$136,3,FALSE),\"\")","v":""}]
[null,null,null,{"$f":"VLOOKUP(C4,$A$48:$D$136,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR(IF(OR(C4=\"TIL4030-20\",C4=\"ME44206\",C4=\"TIL5050-20\"),\"\",VLOOKUP($C4,$A$48:$D$136,3,FALSE)),\"\")","v":""},null,{"$error":"#N/A"},{"$f":"IFERROR(VLOOKUP($F4,$A$48:$D$136,3,FALSE),\"\")","v":""},null,{"$f":"VLOOKUP($I4,$A$48:$D$136,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP($I4,$A$48:$D$136,3,FALSE),\"\")","v":""},null,{"$f":"VLOOKUP($L4,$A$48:$D$136,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP($L4,$A$48:$D$136,3,FALSE),\"\")","v":""}]
[null,null,null,{"$f":"VLOOKUP(C5,$A$48:$D$136,2,FALSE)","v":{"$error":"#N/A"}},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},""]
[null,null,null,{"$f":"VLOOKUP(C6,$A$48:$D$136,2,FALSE)","v":{"$error":"#N/A"}},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},""]
[null,null,null,{"$f":"VLOOKUP(C7,$A$48:$D$136,2,FALSE)","v":{"$error":"#N/A"}},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},""]
[null,null,null,{"$f":"VLOOKUP(C8,$A$48:$D$136,2,FALSE)","v":{"$error":"#N/A"}},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},""]
[null,null,null,null,{"$f":"SUM(E3:E8)","v":0},null,null,{"$f":"SUM(H3:H8)","v":0},null,null,{"$f":"SUM(K3:K8)","v":0},null,null,{"$f":"SUM(N3:N8)","v":0}]
[]
[null,"Year 2","Q1","Name","ECTS","Q2","Name","ECTS","Q3","Name","ECTS","Q4","Name","ECTS"]
[null,null,null,{"$f":"VLOOKUP($C12,$A$48:$D$136,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR(IF(OR(C12=\"TIL4030-20\",C12=\"ME44206\",C12=\"TIL5050-20\"),\"\",VLOOKUP($C12,$A$48:$D$136,3,FALSE)),\"\")","v":""},null,{"$f":"VLOOKUP($F12,$A$48:$D$136,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP($F12,$A$48:$D$136,3,FALSE),\"\")","v":""},null,{"$f":"VLOOKUP($I12,$A$48:$D$136,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP($I12,$A$48:$D$136,3,FALSE),\"\")","v":""},null,{"$f":"VLOOKUP($L12,$A$48:$D$136,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP($L12,$A$48:$D$136,3,FALSE),\"\")","v":""}]
[null,null,null,{"$f":"VLOOKUP($C13,$A$48:$D$136,2,FALSE)","v":{"$error":"#N/A"}},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},""]
[null,null,null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},""]
[null,null,null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},""]
[null,null,null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},""]
[null,null,null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},""]
[null,null,null,null,{"$f":"SUM(E12:E17)","v":0},null,null,{"$f":"SUM(H12:H17)","v":0},null,null,{"$f":"SUM(K12:K17)","v":0},null,null,{"$f":"SUM(N12:N17)","v":0}]
[]
[null,"Year 3","Q1","Name","ECTS","Q2","Name","ECTS","Q3","Name","ECTS","Q4","Name","ECTS"]
[null,null,null,{"$f":"VLOOKUP($C21,$A$48:$D$136,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR(IF(OR(C21=\"TIL4030-20\",C21=\"ME44206\",C21=\"TIL5050-20\"),\"\",VLOOKUP($C21,$A$48:$D$136,3,FALSE)),\"\")","v":""},null,{"$f":"VLOOKUP($F21,$A$48:$D$136,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP($F21,$A$48:$D$136,3,FALSE),\"\")","v":""},null,{"$f":"VLOOKUP($I21,$A$48:$D$136,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP($I21,$A$48:$D$136,3,FALSE),\"\")","v":""},null,{"$f":"VLOOKUP($L21,$A$48:$D$136,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP($L21,$A$48:$D$136,3,FALSE),\"\")","v":""}]
[null,null,null,{"$f":"VLOOKUP($C22,$A$48:$D$136,2,FALSE)","v":{"$error":"#N/A"}},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},""]
[null,null,null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},""]
[null,null,null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},""]
[null,null,null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},""]
[null,null,null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},"",null,{"$error":"#N/A"},""]
[null,null,null,null,{"$f":"SUM(E21:E26)","v":0},null,null,{"$f":"SUM(H21:H26)","v":0},null,null,{"$f":"SUM(K21:K26)","v":0},null,null,{"$f":"SUM(N21:N26)","v":0}]
[]
[null,null,"ECTS"]
[null,"Year 1 Quarter 1",{"$f":"E9","v":0}]
[null,"Year 1 Quarter 2",{"$f":"H9","v":0}]
[null,"Year 1 Quarter 3",{"$f":"K9","v":0}]
[null,"Year 1 Quarter 4",{"$f":"N9","v":0}]
[null,"Year 2 Quarter 1",{"$f":"E18","v":0}]
[null,"Year 2 Quarter 2",{"$f":"H18","v":0}]
[null,"Year 2 Quarter 3",{"$f":"K18","v":0}]
[null,"Year 2 Quarter 4",{"$f":"N18","v":0}]
[null,"Year 3 Quarter 1",{"$f":"E27","v":0}]
[null,"Year 3 Quarter 2",{"$f":"H27","v":0}]
[null,"Year 3 Quarter 3",{"$f":"K27","v":0}]
[null,"Year 3 Quarter 4",{"$f":"N27","v":0}]
[null,"Total",{"$f":"SUM(C30:C41)","v":0},{"$f":"IF(C42>='Courses chosen'!G10,\"All good\",\"You miss some courses in your schedule!\")","v":"All good"}]
[]
[]
[]
[]
[null,"Q1"]
["CIE4801-18","Transport Modelling ",6,1]
["SEN171A","Advanced Evaluation Methods for Transport Policy Decision-making ",5,1]
["CIE4811-18 ","Planning and Operations of Public Transport Systems ",6,1]
["SEN9110 ","Simulation Masterclass ",5,1]
["ME44101","Dynamics and Interaction of Material and Equipment",4,1]
["SEN9720 ","Logistics and Supply Chain Innovations ",5,1]
["CIE4811-18 ","Planning and Operations of Public Transport Systems ",6,1]
["TPM023a","Cost-benefit Analysis: Theory and Application",3,1]
["SEN171A ","Advanced Evaluation Methods for Transport Policy Decision-making ",5,1]
["SEN9110 ","Simulation Masterclass ",5,1]
["SEN9720 ","Logistics and Supply Chain Innovations ",5,1]
["TPM004A ","Transport Safety ",5,1]
["TPM032a","Multi-Criteria Decision Analyiss",5,1]
["ME44101","Dynamics and Interaction of Material and Equipment",4,1]
["AR8003TU ","Legal and Governance ",5,1]
["CIE4330 ","Ports and Waterways 1 ",4,1]
["CME2300 ","Financial Engineering",4,1]
["TIL6010","TIL Programming",2,1]
["TIL6020","TIL Scientific Assignment",7,1]
["TIL4020-20","TIL Research Project",5,1]
["ME44206","Quantitative Methods for Logistics ",5,1.2]
["TIL4030-20","TIL Research and Design Methods ",7,1.2]
["AR3CS010 ","Workshop Cross Domain City of the Future",3,1.2]
["AR3CS021","Seminar Cross Domain City of the Future",6,1.2]
["TIL5050-20","TIL Design Project",10,1.2]
["TIL5060","TIL Thesis",30,1.2]
["SEN1221","Statistical Analysis of Choice Behaviour ",5,2]
["AR0228","Infrastructure and Environment Method Module ",5,2]
["AE4423-20","Airline Planning & Optimisation ",4,2]
["CIE5803-18","Railway Traffic Management",6,2]
["SEN1721 ","Travel Behaviour Research",5,2]
["CIE4825 ","Traffic Flow Modelling and Control Part 1 ",6,2]
["TPM028a","Decision making in multimodal transport systems ",5,2]
["CIE4825 ","Traffic Flow Modelling and Control Part 1 ",6,2]
["CIE4831-18 ","Empirical Analysis for Transport & Planning ",6,2]
["CIE5802-18 ","Advanced Transport Modelling ",4,2]
["CIE5810-19","Traffic Safety",4,2]
["SEN1721 ","Travel Behaviour Research ",5,2]
["TPM028a","Decision making in multimodal transport systems ",5,2]
["SEN9725 ","Supply Chain Gaming ",5,2]
["ME44105 ","Structural Design with FEM  (no new link)",4,2]
["AE4423-20","Airline Planning & Optimisation  (no updated link yet)",3,2]
["AR0228","Infrastructure and Environment Method Module ",5,2]
["CIE4874","Elements of Railway Engineering",4,2]
["ME41106","Intelligent Vehicles ",4,2]
["AE4321-15 ","Air Traffic Management  (no updated link yet)",4,2.2999999999999998]
["CIE5817 ","Assessment of Transport Infrastructure and Systems ",4,3]
["AE4426 ","Airport Operations ",4,3]
["CIE5826","Railway Operations and Control ",4,3]
["CIE5821 ","Traffic Flow Modelling and Control Part 2 ",4,3]
["ME44200","Operations and Maintenance",3,3]
["CIE5830 ","Freight Transport Systems: Analysis and Modelling ",5,3]
["CIE5815 ","Resilient Transport Systems: Analysis and Interventions ",4,3]
["CIE5817","Assessment of Transport Infrastructure and Systems ",4,3]
["CIE5821","Traffic Flow Modelling and Control Part 2 ",4,3]
["CIE5822","Active Modes: Traffic and Transport ",4,3]
["CIE5825","Advanced Public Transport Operations and Modelling ",4,3]
["CIE5826","Railway Operations and Control ",4,3]
["CIE5830","Freight Transport Systems: Analysis and Modelling ",5,3]
["SEN115a","Law and Institutions",5,3]
["ME44115 ","Discrete Element Method (DEM) simulation ",4,3]
["ME44125 ","Reliability and Maintenance of Transport Equipment",3,3]
["ME44200 ","Operations and Maintenance",3,3]
["AE4446","Airport Operations (no updated link yet)",4,3]
["MT44070 ","Shipping Management ",5,3]
["WI4062TU","Transport, Routing and Scheduling",3,3]
["WM1301TU ","Ethics of Transportation",3,3]
["TIL4020-20","TIL Research Project",5,3]
["ME44305 ","System Analysis and Simulation ",5,3.4]
["ME44311","Advanced Operations Management ",5,3.4]
["ME44110 ","Integration Project Multi-Machine Systems",5,3.4]
["ME44305 ","System Analysis and Simulation ",5,3.4]
["ME44311","Advanced Operations and Production Management ",5,3.4]
["AR0168","People, Movement and Public Space ",5,4]
["CIE5816 ","Urban Regions, Transport and Economics ",4,4]
["TPM004a","Transport Safety",5,4]
["CIE5805-18 ","Intelligent Vehicles for Safe and Efficient Traffic: Design and Assessment ",4,4]
["ME44300 ","Multi-Machine Coordination For Logistics ",3,4]
["CIE4845 ","Emerging Topics for Transport & Planning ",4,4]
["CIE5803-18 ","Railway Traffic Management ",4,4]
["CIE5805-18 ","Intelligent Vehicles for Safe and Efficient Traffic: Design and Assessment",4,4]
["CIE5816","Urban Regions, Transport and Economics ",4,4]
["SEN1741 ","Innovations in Transport and Logistics ",5,4]
["ME44300 ","Multi-Machine Coordination for Logistics",3,4]
["ME44312","Machine Learning for Transport and Multi-Machine Systems",3,4]
["AR0168","People, Movement and Public Space ",5,4]
["CIE5306 ","Ports and Waterways 2",4,4]
["RO47016","Automotive Human Factors",5,4]

{"sheet":"Courses chosen","index":2,"n_rows":240,"n_cols":7,"rows_kept":240,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Quarter","ECTS"]
["Name","ECTS","Quarter","Check",null,"Q1",0]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B31:G31,2,FALSE),\"\")","v":"TIL4030-20"},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B31:G31,4,FALSE),\"\")","v":7},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B31:G31,5,FALSE),\"\")","v":1.2},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"},null,"Q2",5]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B30:G30,2,FALSE),\"\")","v":"SEN1221"},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B30:G30,4,FALSE),\"\")","v":5},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B30:G30,5,FALSE),\"\")","v":2},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"},null,"Q3",0]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B29:G29,2,FALSE),\"\")","v":"ME44206"},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B29:G29,4,FALSE),\"\")","v":5},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B29:G29,5,FALSE),\"\")","v":1.2},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"},null,"Q4",0]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B135:G135,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B135:G135,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B135:G135,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"},null,"Q1+Q2",12]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B138:G138,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B138:G138,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B138:G138,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"},null,"Q2+Q3",0]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B147:G147,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B147:G147,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B147:G147,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"},null,"Q3+Q4",0]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B144:G144,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B144:G144,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B144:G144,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"},null,null,{"$f":"SUM(G2:G8)","v":17}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B143:G143,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B143:G143,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B143:G143,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B42:G42,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B42:G42,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B42:G42,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B91:G91,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B91:G91,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B91:G91,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B48:G48,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B48:G48,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B48:G48,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B88:G88,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B88:G88,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B88:G88,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B109:G109,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B109:G109,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B109:G109,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B130:G130,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B130:G130,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B130:G130,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B47:G47,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B47:G47,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B47:G47,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B78:G78,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B78:G78,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B78:G78,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B46:G46,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B46:G46,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B46:G46,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B45:G45,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B45:G45,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B45:G45,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B121:G121,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B121:G121,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B121:G121,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B44:G44,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B44:G44,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B44:G44,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B43:G43,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B43:G43,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B43:G43,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B32:G32,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B32:G32,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B32:G32,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B33:G33,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B33:G33,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B33:G33,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B34:G34,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B34:G34,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B34:G34,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B35:G35,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B35:G35,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B35:G35,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B36:G36,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B36:G36,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B36:G36,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B37:G37,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B37:G37,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B37:G37,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B38:G38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B38:G38,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B38:G38,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B39:G39,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B39:G39,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B39:G39,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B40:G40,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B40:G40,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B40:G40,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B41:G41,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B41:G41,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B41:G41,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B49:G49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B49:G49,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B49:G49,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B50:G50,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B50:G50,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B50:G50,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B51:G51,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B51:G51,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B51:G51,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B52:G52,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B52:G52,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B52:G52,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B53:G53,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B53:G53,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B53:G53,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B54:G54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B54:G54,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B54:G54,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B55:G55,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B55:G55,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B55:G55,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B56:G56,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B56:G56,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B56:G56,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B57:G57,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B57:G57,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B57:G57,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B58:G58,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B58:G58,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B58:G58,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B59:G59,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B59:G59,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B59:G59,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B60:G60,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B60:G60,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B60:G60,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B61:G61,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B61:G61,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B61:G61,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B62:G62,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B62:G62,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B62:G62,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B63:G63,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B63:G63,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B63:G63,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B64:G64,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B64:G64,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B64:G64,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B65:G65,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B65:G65,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B65:G65,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B66:G66,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B66:G66,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B66:G66,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B67:G67,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B67:G67,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B67:G67,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B68:G68,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B68:G68,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B68:G68,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B69:G69,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B69:G69,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B69:G69,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B70:G70,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B70:G70,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B70:G70,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B71:G71,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B71:G71,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B71:G71,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B72:G72,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B72:G72,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B72:G72,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B73:G73,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B73:G73,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B73:G73,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B74:G74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B74:G74,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B74:G74,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B75:G75,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B75:G75,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B75:G75,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B76:G76,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B76:G76,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B76:G76,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B77:G77,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B77:G77,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B77:G77,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B79:G79,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B79:G79,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B79:G79,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B80:G80,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B80:G80,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B80:G80,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B81:G81,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B81:G81,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B81:G81,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B82:G82,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B82:G82,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B82:G82,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B83:G83,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B83:G83,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B83:G83,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B84:G84,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B84:G84,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B84:G84,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B85:G85,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B85:G85,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B85:G85,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B86:G86,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B86:G86,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B86:G86,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B87:G87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B87:G87,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B87:G87,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B89:G89,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B89:G89,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B89:G89,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B90:G90,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B90:G90,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B90:G90,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B92:G92,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B92:G92,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B92:G92,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B93:G93,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B93:G93,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B93:G93,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B94:G94,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B94:G94,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B94:G94,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B95:G95,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B95:G95,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B95:G95,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B96:G96,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B96:G96,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B96:G96,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B97:G97,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B97:G97,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B97:G97,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B98:G98,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B98:G98,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B98:G98,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B99:G99,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B99:G99,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B99:G99,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B100:G100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B100:G100,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B100:G100,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B101:G101,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B101:G101,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B101:G101,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B102:G102,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B102:G102,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B102:G102,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B103:G103,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B103:G103,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B103:G103,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B104:G104,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B104:G104,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B104:G104,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B105:G105,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B105:G105,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B105:G105,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B106:G106,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B106:G106,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B106:G106,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B107:G107,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B107:G107,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B107:G107,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B108:G108,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B108:G108,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B108:G108,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B110:G110,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B110:G110,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B110:G110,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B111:G111,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B111:G111,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B111:G111,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B112:G112,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B112:G112,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B112:G112,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B113:G113,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B113:G113,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B113:G113,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B114:G114,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B114:G114,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B114:G114,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B115:G115,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B115:G115,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B115:G115,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B116:G116,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B116:G116,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B116:G116,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B117:G117,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B117:G117,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B117:G117,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B118:G118,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B118:G118,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B118:G118,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B119:G119,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B119:G119,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B119:G119,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B120:G120,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B120:G120,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B120:G120,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B122:G122,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B122:G122,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B122:G122,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B123:G123,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B123:G123,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B123:G123,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B124:G124,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B124:G124,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B124:G124,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B125:G125,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B125:G125,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B125:G125,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B126:G126,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B126:G126,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B126:G126,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B127:G127,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B127:G127,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B127:G127,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B128:G128,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B128:G128,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B128:G128,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B129:G129,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B129:G129,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B129:G129,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B131:G131,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B131:G131,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B131:G131,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B132:G132,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B132:G132,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B132:G132,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B133:G133,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B133:G133,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B133:G133,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B134:G134,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B134:G134,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B134:G134,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B136:G136,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B136:G136,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B136:G136,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B137:G137,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B137:G137,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B137:G137,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B139:G139,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B139:G139,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B139:G139,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B140:G140,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B140:G140,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B140:G140,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B141:G141,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B141:G141,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B141:G141,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B142:G142,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B142:G142,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B142:G142,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B145:G145,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B145:G145,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B145:G145,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B146:G146,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B146:G146,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B146:G146,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B148:G148,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B148:G148,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B148:G148,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B149:G149,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B149:G149,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B149:G149,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B150:G150,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B150:G150,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B150:G150,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B151:G151,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B151:G151,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B151:G151,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B152:G152,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B152:G152,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B152:G152,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B153:G153,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B153:G153,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B153:G153,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B154:G154,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B154:G154,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B154:G154,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B155:G155,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B155:G155,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B155:G155,5,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(IF(Table1[[#This Row],[Quarter]]=3,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$I$3:$I$26,FALSE), IF(OR(Table1[[#This Row],[Quarter]]=1,Table1[[#This Row],[Quarter]]=1.2),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$C$3:$C$26,FALSE),IF(Table1[[#This Row],[Quarter]]=2,MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$F$3:$F$26,FALSE),MATCH(Table1[[#This Row],[Name]],'Schedule planner'!$L$3:$L$26,FALSE)))),\"all good\",\"you need to schedule this course\"),\"you need to schedule this course\")","v":"you need to schedule this course"}]
["Total",{"$f":"SUBTOTAL(109,Table1[ECTS])","v":17},{"$f":"SUBTOTAL(103,Table1[Quarter])","v":127}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B196:G196,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B196:G196,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B196:G196,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B197:G197,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B197:G197,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B197:G197,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B198:G198,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B198:G198,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B198:G198,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B199:G199,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B199:G199,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B199:G199,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B200:G200,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B200:G200,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B200:G200,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B201:G201,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B201:G201,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B201:G201,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B202:G202,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B202:G202,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B202:G202,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B203:G203,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B203:G203,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B203:G203,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B204:G204,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B204:G204,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B204:G204,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B205:G205,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B205:G205,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B205:G205,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B206:G206,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B206:G206,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B206:G206,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B207:G207,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B207:G207,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B207:G207,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B208:G208,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B208:G208,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B208:G208,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B209:G209,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B209:G209,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B209:G209,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B210:G210,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B210:G210,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B210:G210,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B211:G211,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B211:G211,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B211:G211,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B212:G212,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B212:G212,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B212:G212,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B213:G213,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B213:G213,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B213:G213,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B214:G214,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B214:G214,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B214:G214,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B215:G215,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B215:G215,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B215:G215,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B216:G216,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B216:G216,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B216:G216,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B217:G217,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B217:G217,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B217:G217,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B218:G218,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B218:G218,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B218:G218,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B219:G219,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B219:G219,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B219:G219,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B220:G220,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B220:G220,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B220:G220,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B221:G221,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B221:G221,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B221:G221,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B222:G222,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B222:G222,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B222:G222,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B223:G223,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B223:G223,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B223:G223,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B224:G224,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B224:G224,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B224:G224,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B225:G225,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B225:G225,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B225:G225,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B226:G226,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B226:G226,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B226:G226,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B227:G227,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B227:G227,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B227:G227,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B228:G228,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B228:G228,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B228:G228,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B229:G229,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B229:G229,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B229:G229,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B230:G230,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B230:G230,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B230:G230,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B231:G231,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B231:G231,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B231:G231,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B232:G232,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B232:G232,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B232:G232,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B233:G233,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B233:G233,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B233:G233,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B234:G234,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B234:G234,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B234:G234,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B235:G235,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B235:G235,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B235:G235,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B236:G236,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B236:G236,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B236:G236,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B237:G237,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B237:G237,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B237:G237,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B238:G238,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B238:G238,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B238:G238,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B239:G239,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B239:G239,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B239:G239,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B240:G240,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B240:G240,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B240:G240,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B241:G241,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B241:G241,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B241:G241,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B242:G242,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B242:G242,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B242:G242,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B243:G243,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B243:G243,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B243:G243,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B244:G244,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B244:G244,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B244:G244,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B245:G245,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B245:G245,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B245:G245,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B246:G246,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B246:G246,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B246:G246,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B247:G247,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B247:G247,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B247:G247,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B248:G248,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B248:G248,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B248:G248,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B249:G249,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B249:G249,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B249:G249,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B250:G250,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B250:G250,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B250:G250,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B251:G251,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B251:G251,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B251:G251,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B252:G252,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B252:G252,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B252:G252,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B253:G253,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B253:G253,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B253:G253,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B254:G254,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B254:G254,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B254:G254,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B255:G255,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B255:G255,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B255:G255,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B256:G256,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B256:G256,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B256:G256,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B257:G257,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B257:G257,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B257:G257,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B258:G258,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B258:G258,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B258:G258,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B259:G259,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B259:G259,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B259:G259,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B260:G260,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B260:G260,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B260:G260,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B261:G261,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B261:G261,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B261:G261,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B262:G262,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B262:G262,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B262:G262,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B263:G263,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B263:G263,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B263:G263,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B264:G264,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B264:G264,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B264:G264,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B265:G265,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B265:G265,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B265:G265,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B266:G266,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B266:G266,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B266:G266,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B267:G267,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B267:G267,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B267:G267,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B268:G268,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B268:G268,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B268:G268,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B269:G269,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B269:G269,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B269:G269,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B270:G270,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B270:G270,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B270:G270,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B271:G271,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B271:G271,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B271:G271,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B272:G272,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B272:G272,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B272:G272,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B273:G273,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B273:G273,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B273:G273,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B274:G274,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B274:G274,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B274:G274,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B275:G275,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B275:G275,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B275:G275,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B276:G276,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B276:G276,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B276:G276,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B277:G277,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B277:G277,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B277:G277,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B278:G278,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B278:G278,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B278:G278,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B279:G279,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B279:G279,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B279:G279,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B280:G280,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B280:G280,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B280:G280,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B281:G281,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B281:G281,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B281:G281,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B282:G282,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B282:G282,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B282:G282,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B283:G283,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B283:G283,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B283:G283,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B284:G284,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B284:G284,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B284:G284,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B285:G285,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B285:G285,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B285:G285,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B286:G286,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B286:G286,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B286:G286,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B287:G287,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B287:G287,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B287:G287,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B288:G288,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B288:G288,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B288:G288,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B289:G289,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B289:G289,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B289:G289,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B290:G290,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B290:G290,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B290:G290,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B291:G291,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B291:G291,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B291:G291,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B292:G292,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B292:G292,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B292:G292,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B293:G293,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B293:G293,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B293:G293,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B294:G294,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B294:G294,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B294:G294,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B295:G295,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B295:G295,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B295:G295,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B296:G296,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B296:G296,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B296:G296,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B297:G297,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B297:G297,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B297:G297,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B298:G298,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B298:G298,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B298:G298,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B299:G299,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B299:G299,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B299:G299,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B300:G300,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B300:G300,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B300:G300,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B301:G301,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B301:G301,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B301:G301,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B302:G302,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B302:G302,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B302:G302,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B303:G303,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B303:G303,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B303:G303,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B304:G304,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B304:G304,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B304:G304,5,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B305:G305,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"YES\",'Course planner'!$B305:G305,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(\"Yes\", 'Course planner'!B305:G305,5,FALSE),\"\")","v":""}]