{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["HN Engineering (2024)","HN Aeronautical Eng. (2024)","HN Automotive Eng. (2024)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":1,"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":"HN Engineering (2024)","index":0,"n_rows":95,"n_cols":25,"rows_kept":95,"cut":false,"hidden":false,"merged":[[0,23,3,23],[0,24,3,25]]}
[null,null,null,null,null,null,"Credit","Valid","Credit","Valid","Credit","Valid","Credit","Valid","Credit","Valid","Credit","Valid","Credit","Valid","Credit","Valid",null,"KEY\nCM \nCG1\nCG2\nCM1\nCM2\nSM\nO\nMLN","\n-  Core Mandatory\n-  Core Group 1\n-  Core Group 2\n-  Core Mandatory 1\n-  Core Mandatory 2\n-  Specialist Mandatory\n-  Optional\n-  Meeting Local Needs"]
["HN Engineering (2024)",null,null,null,null,"Level 4 HNC (120 Credits) - ",{"$f":"SUMIF(H5:H52,TRUE,$F5:$F52)","v":0},{"$f":"IF(G2>=120,IF(COUNTIF(G86:G89,FALSE)>0,CHAR(251),CHAR(252)),\"\")","v":""},{"$f":"SUMIF(J5:J52,TRUE,$F5:$F52)","v":0},{"$f":"IF(I2>=120,IF(COUNTIF(I86:I89,FALSE)>0,CHAR(251),CHAR(252)),\"\")","v":""},{"$f":"SUMIF(L5:L52,TRUE,$F5:$F52)","v":0},{"$f":"IF(K2>=120,IF(COUNTIF(K86:K89,FALSE)>0,CHAR(251),CHAR(252)),\"\")","v":""},{"$f":"SUMIF(N5:N52,TRUE,$F5:$F52)","v":0},{"$f":"IF(M2>=120,IF(COUNTIF(M86:M89,FALSE)>0,CHAR(251),CHAR(252)),\"\")","v":""},{"$f":"SUMIF(P5:P52,TRUE,$F5:$F52)","v":0},{"$f":"IF(O2>=120,IF(COUNTIF(O86:O89,FALSE)>0,CHAR(251),CHAR(252)),\"\")","v":""},{"$f":"SUMIF(R5:R52,TRUE,$F5:$F52)","v":0},{"$f":"IF(Q2>=120,IF(COUNTIF(Q86:Q89,FALSE)>0,CHAR(251),CHAR(252)),\"\")","v":""},{"$f":"SUMIF(T5:T52,TRUE,$F5:$F52)","v":0},{"$f":"IF(S2>=120,IF(COUNTIF(S86:S89,FALSE)>0,CHAR(251),CHAR(252)),\"\")","v":""},"n/a","n/a"]
[null,null,null,null,null,"Level 5 HND (240 Credits) - ",{"$f":"SUMIF(H5:H84,TRUE,$F5:$F84)","v":0},{"$f":"IF(G3>=240,IF(SUM(COUNTIF(G86:G88,FALSE)+COUNTIF(G90:G95,FALSE))>0,CHAR(251),CHAR(252)),\"\")","v":""},{"$f":"SUMIF(J5:J84,TRUE,$F5:$F84)","v":0},{"$f":"IF(I3>=240,IF(SUM(COUNTIF(I86:I88,FALSE)+COUNTIF(I90:I95,FALSE))>0,CHAR(251),CHAR(252)),\"\")","v":""},{"$f":"SUMIF(L5:L84,TRUE,$F5:$F84)","v":0},{"$f":"IF(K3>=240,IF(SUM(COUNTIF(K86:K88,FALSE)+COUNTIF(K90:K95,FALSE))>0,CHAR(251),CHAR(252)),\"\")","v":""},{"$f":"SUMIF(N5:N84,TRUE,$F5:$F84)","v":0},{"$f":"IF(M3>=240,IF(SUM(COUNTIF(M86:M88,FALSE)+COUNTIF(M90:M95,FALSE))>0,CHAR(251),CHAR(252)),\"\")","v":""},{"$f":"SUMIF(P5:P84,TRUE,$F5:$F84)","v":0},{"$f":"IF(O3>=240,IF(SUM(COUNTIF(O86:O88,FALSE)+COUNTIF(O90:O95,FALSE))>0,CHAR(251),CHAR(252)),\"\")","v":""},{"$f":"SUMIF(R5:R84,TRUE,$F5:$F84)","v":0},{"$f":"IF(Q3>=240,IF(SUM(COUNTIF(Q86:Q88,FALSE)+COUNTIF(Q90:Q95,FALSE))>0,CHAR(251),CHAR(252)),\"\")","v":""},{"$f":"SUMIF(T5:T84,TRUE,$F5:$F84)","v":0},{"$f":"IF(S3>=240,IF(SUM(COUNTIF(S86:S88,FALSE)+COUNTIF(S90:S95,FALSE))>0,CHAR(251),CHAR(252)),\"\")","v":""},{"$f":"SUMIF(V5:V84,TRUE,$F5:$F84)","v":0},{"$f":"IF(U3>=240,IF(SUM(COUNTIF(U86:U88,FALSE)+COUNTIF(U90:U95,FALSE))>0,CHAR(251),CHAR(252)),\"\")","v":""}]
["Unit No.","Unit Ref.","Unit Title","Level",null,"Credit","General",null,"Electrical & Electronic",null,"Manufacturing",null,"Mechanical",null,"Mechatronics",null,"Operations",null,"Semiconductor Technologies",null,"Embedded Electronic Systems"]
[4002,"A/651/0708","Engineering Mathematics",4,null,15,"CM",false,"CM",false,"CM",false,"CM",false,"CM",false,"CM",false,"CM",false,"CM",false]
[4003,"J/651/0710","Engineering Science I",4,null,15,"CM",false,"CM",false,"CM",false,"CM",false,"CM",false,"CM",false,"CM",false,"CM",false]
[4001,"T/650/9628","Engineering Design",4,null,15,"CG1",false,"CG1",false,"CG1",false,"CG1",false,"CG1",false,"CG1",false,"CG1",false,"CG1",false]
[4004,"L/651/0712","Managing a Professional Engineering Project",4,null,15,"CG1",false,"CG1",false,"CG1",false,"CG1",false,"CG1",false,"CG1",false,"CG1",false,"CG1",false]
[4062,"M/651/0803","Professional Engineering Practice",4,null,15,"CG2",false,"CG2",false,"CG2",false,"CG2",false,"CG2",false,"CG2",false,"CG2",false,"CG2",false]
[4063,"F/650/2943","Engineering Mechanics and Materials",4,null,15,"CG2",false,"CG2",false,"CG2",false,"CG2",false,"CG2",false,"CG2",false,"CG2",false,"CG2",false]
[4005,"R/651/0714","Renewable Energy",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4006,"Y/651/0716","Mechatronics",4,null,15,"O",false,"O",false,"O",false,"O",false,"SM",false,null,null,"O",false,"O",false]
[4007,"D/651/0718","Machining and Processing of Engineering Materials",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4008,"K/651/0720","Mechanical Principles",4,null,15,"O",false,"O",false,"O",false,"SM",false,"O",false,null,null,"O",false,"O",false]
[4009,"J/615/1483","Materials, Properties and Testing",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4010,"M/651/0722","Mechanical Workshop Practices",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4011,"T/651/0724","Fluid Mechanics",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4012,"A/651/0726","Engineering Management",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4013,"D/651/0727","Fundamentals of Thermodynamics and Heat Transfer",4,null,15,"O",false,"O",false,"O",false,"SM",false,"O",false,null,null,"O",false,"O",false]
[4014,"H/651/0729","Production Engineering for Manufacture",4,null,15,"O",false,"O",false,"SM",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4015,"M/651/0731","Automation, Robotics and Programmable Logic Controllers (PLCs)",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4016,"T/651/0733","Instrumentation and Control Systems",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4017,"Y/651/0734","Quality and Process Improvement",4,null,15,"O",false,"O",false,"SM",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4018,"D/651/0736","Maintenance Engineering",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false]
[4019,"F/651/0737","Electrical and Electronic Principles",4,null,15,"O",false,"SM",false,"O",false,"O",false,"O",false,null,null,"O",false,"SM",false]
[4020,"J/651/0739","Digital Principles",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4021,"M/651/0740","Electrical Machines",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4022,"T/651/0742","Electronic Circuits and Devices",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4023,"A/651/0744","Computer Aided Design and Manufacture (CAD/CAM)",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4024,"F/651/0746","Electro, Pneumatic and Hydraulic Systems",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false]
[4025,"H/651/0747","Operations and Plant Management",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false]
[4026,"K/651/0749","Electrical Systems and Fault Finding",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false]
[4027,"Y/651/0898","CAD for Schematics in Maintenance Engineering",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false]
[4028,"T/651/0751","Materials Engineering with Polymers",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4029,"A/651/0753","Polymer Manufacturing Processes",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4030,"F/651/0755","Industry 4.0",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4031,"J/651/0757","Introduction to Professional Engineering Management",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4033,"T/651/0760","Programmable Logic Controllers",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4034,"A/651/0762","Computer Aided Design (CAD) for Engineering",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4035,"D/651/0763","Welding Technology",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4036,"M/651/0895","Welding Inspection",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4037,"F/651/0764","Statistical Process Control",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4038,"H/651/0765","Telecommunication Principles",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4039,"L/651/0768","Semiconductor Manufacture",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"SM",false,"O",false]
[4040,"Y/651/0770","Semiconductor Production Environments",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"SM",false,"O",false]
[4061,"A/650/2923","Programming for Engineers",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false]
[4068,"L/617/3940","Industrial Robots",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4086,"K/617/3945","Mechatronic Systems in Manufacturing",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4089,"K/650/3369","Net Zero Energy Technologies I: Systems and Demand",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
[4090,"M/650/9509","Engineering Science II",4,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,null,null,"O",false,"O",false]
["-","-","Meeting Local Needs (approval must be sought prior to delivery)",4,null,15,"MLN",false,"MLN",false,"MLN",false,"MLN",false,"MLN",false,"MLN",false,"MLN",false,"MLN",false]
["-","-","Meeting Local Needs (approval must be sought prior to delivery)",4,null,15,"MLN",false,"MLN",false,"MLN",false,"MLN",false,"MLN",false,"MLN",false,"MLN",false,"MLN",false]
[5002,"F/651/0809","Professional Engineering Management",5,null,15,"CM",false,"CM",false,"CM",false,"CM",false,"CM",false,"CM",false,"CM",false,"CM",false]
[5001,"J/615/1502","Research Project",5,null,30,"CM1",false,"CM1",false,"CM1",false,"CM1",false,"CM1",false,"CM1",false,"CM1",false,"CM1",false]
[5041,"M/650/2948","Engineering Project",5,null,15,"CM2",false,"CM2",false,"CM2",false,"CM2",false,"CM2",false,"CM2",false,"CM2",false,"CM2",false]
[5003,"K/651/0810","Advanced Mechanical Principles",5,null,15,"O",false,"O",false,"O",false,"SM",false,"O",false,"O",false,"O",false,"O",false]
[5004,"L/651/0858","Computational Modelling in Virtual Engineering",5,null,15,"O",false,"O",false,"O",false,"SM",false,"O",false,"O",false,"O",false,"O",false]
[5005,"M/651/0859","Further Thermodynamics",5,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false]
[5006,"Y/651/0860","Further Engineering Mathematics",5,null,15,"SM",false,"SM",false,"O",false,"SM",false,"SM",false,"SM",false,"O",false,"SM",false]
[5007,"A/651/0861","Commercial Programming Software",5,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"SM",false]
[5008,"D/651/0862","Distributed Control Systems",5,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false]
[5009,"F/651/0863","Further Programmable Logic Controllers (PLCs)",5,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false]
[5010,"H/651/0864","Further Electrical Machines and Drives",5,null,15,"O",false,"SM/O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false]
[5011,"J/651/0865","Industrial Power, Electronics and Storage",5,null,15,"O",false,"SM",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false]
[5012,"K/651/0866","Industrial Systems",5,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false]
[5013,"L/651/0867","Embedded Systems",5,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"SM",false]
[5014,"M/651/0868","Analogue Electronic Systems",5,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false]
[5015,"J/615/1516","Manufacturing Systems Engineering",5,null,15,"O",false,"O",false,"SM",false,"O",false,"O",false,"O",false,"O",false,"O",false]
[5016,"M/651/0877","Lean Manufacturing",5,null,15,"SM",false,"O",false,"SM",false,"O",false,"O",false,"O",false,"O",false,"O",false]
[5017,"D/651/0880","Advanced Manufacturing",5,null,15,"O",false,"O",false,"SM",false,"O",false,"O",false,"O",false,"O",false,"O",false]
[5018,"Y/615/1519","Sustainability",5,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false]
[5019,"H/651/0882","Further Electrical, Electronic and Digital Principles",5,null,15,"O",false,"SM/O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false]
[5020,"K/651/0884","Utilisation of Electrical Power",5,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false]
[5021,"M/651/0886","Further Control Systems Engineering",5,null,15,"O",false,"SM/O",false,"O",false,"O",false,"SM/O",false,"O",false,"O",false,"O",false]
[5022,"K/615/1525","Industrial Services",5,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,"SM",false,"O",false,"O",false]
[5023,"R/651/0887","Thermofluids",5,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,"SM",false,"O",false,"O",false]
[5024,"Y/618/1765","Emerging Semiconductor Technologies",5,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"SM",false,"O",false]
[5025,"D/618/1766","Semiconductor Integrated Electronics",5,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"SM",false,"O",false]
[5042,"M/650/2984","Signals and Systems",5,null,15,"O",false,"O",false,"O",false,"O",false,"SM/O",false,"O",false,"O",false,"O",false]
[5048,"J/650/2990","Sensors and Automation",5,null,15,"O",false,"O",false,"O",false,"O",false,"SM/O",false,"O",false,"O",false,"O",false]
[5051,"H/615/1524","Heating, Ventilation and Air Conditioning (HVAC)",5,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,"SM",false,"O",false,"O",false]
[5054,"Y/650/3372","Net Zero Energy Technologies II: Infrastructure and Pathways",5,null,15,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false,"O",false]
["-","-","Meeting Local Needs (approval must be sought prior to delivery)",5,null,15,"MLN",false,"MLN",false,"MLN",false,"MLN",false,"MLN",false,"MLN",false,"MLN",false,"MLN",false]
["-","-","Meeting Local Needs (approval must be sought prior to delivery)",5,null,15,"MLN",false,"MLN",false,"MLN",false,"MLN",false,"MLN",false,"MLN",false,"MLN",false,"MLN",false]
[]
[null,null,null,null,null,"HNC Core Mandatory Met",{"$f":"IF(AND(H5=TRUE,H6=TRUE),TRUE,FALSE)","v":false},{"$f":"IF(G86=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(J5=TRUE,J6=TRUE),TRUE,FALSE)","v":false},{"$f":"IF(I86=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(L5=TRUE,L6=TRUE),TRUE,FALSE)","v":false},"û",{"$f":"IF(AND(N5=TRUE,N6=TRUE),TRUE,FALSE)","v":false},{"$f":"IF(M86=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(P5=TRUE,P6=TRUE),TRUE,FALSE)","v":false},{"$f":"IF(O86=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(R5=TRUE,R6=TRUE),TRUE,FALSE)","v":false},{"$f":"IF(Q86=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(T5=TRUE,T6=TRUE),TRUE,FALSE)","v":false},"û",{"$f":"IF(AND(V5=TRUE,V6=TRUE),TRUE,FALSE)","v":false},{"$f":"IF(U86=TRUE,CHAR(252),CHAR(251))","v":"û"}]
[null,null,null,null,null,"HNC Core Group Choice Met",{"$f":"IF(AND(SUMIF(H7:H10,TRUE,$F7:$F10)=30,OR(AND(H7=TRUE,H8=TRUE),AND(H9=TRUE,H10=TRUE))),TRUE,FALSE)","v":false},{"$f":"IF(G87=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(SUMIF(J7:J10,TRUE,$F7:$F10)=30,OR(AND(J7=TRUE,J8=TRUE),AND(J9=TRUE,J10=TRUE))),TRUE,FALSE)","v":false},"û",{"$f":"IF(AND(SUMIF(L7:L10,TRUE,$F7:$F10)=30,OR(AND(L7=TRUE,L8=TRUE),AND(L9=TRUE,L10=TRUE))),TRUE,FALSE)","v":false},"û",{"$f":"IF(AND(SUMIF(N7:N10,TRUE,$F7:$F10)=30,OR(AND(N7=TRUE,N8=TRUE),AND(N9=TRUE,N10=TRUE))),TRUE,FALSE)","v":false},{"$f":"IF(M87=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(SUMIF(P7:P10,TRUE,$F7:$F10)=30,OR(AND(P7=TRUE,P8=TRUE),AND(P9=TRUE,P10=TRUE))),TRUE,FALSE)","v":false},{"$f":"IF(O87=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(SUMIF(R7:R10,TRUE,$F7:$F10)=30,OR(AND(R7=TRUE,R8=TRUE),AND(R9=TRUE,R10=TRUE))),TRUE,FALSE)","v":false},{"$f":"IF(Q87=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(SUMIF(T7:T10,TRUE,$F7:$F10)=30,OR(AND(T7=TRUE,T8=TRUE),AND(T9=TRUE,T10=TRUE))),TRUE,FALSE)","v":false},"û",{"$f":"IF(AND(SUMIF(V7:V10,TRUE,$F7:$F10)=30,OR(AND(V7=TRUE,V8=TRUE),AND(V9=TRUE,V10=TRUE))),TRUE,FALSE)","v":false},{"$f":"IF(U87=TRUE,CHAR(252),CHAR(251))","v":"û"}]
[null,null,null,null,null,"HNC Spec. Mandatory Met",null,null,{"$f":"IF(J25=TRUE,TRUE,FALSE)","v":false},"û",{"$f":"IF(AND(L20=TRUE,L23=TRUE),TRUE,FALSE)","v":false},"û",{"$f":"IF(AND(N14=TRUE,N19=TRUE),TRUE,FALSE)","v":false},{"$f":"IF(M88=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(P12=TRUE,TRUE,FALSE)","v":false},{"$f":"IF(O88=TRUE,CHAR(252),CHAR(251))","v":"û"},null,null,{"$f":"IF(AND(T44=TRUE,T45=TRUE),TRUE,FALSE)","v":false},{"$f":"IF(S88=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(V25=TRUE,TRUE,FALSE)","v":false},{"$f":"IF(U88=TRUE,CHAR(252),CHAR(251))","v":"û"}]
[null,null,null,null,null,"HNC Optional Choice Rules",null,null,{"$f":"IF(OR(AND(J20=TRUE,J23=TRUE),AND(J14=TRUE,J19=TRUE),J12=TRUE,AND(J44=TRUE,J45=TRUE)),FALSE,TRUE)","v":true},"ü",{"$f":"IF(OR(L25=TRUE,AND(L14=TRUE,L19=TRUE),L12=TRUE,AND(L44=TRUE,L45=TRUE)),FALSE,TRUE)","v":true},"ü",{"$f":"IF(OR(N25=TRUE,AND(N20=TRUE,N23=TRUE),N12=TRUE,AND(N44=TRUE,N45=TRUE)),FALSE,TRUE)","v":true},{"$f":"IF(M89=TRUE,CHAR(252),CHAR(251))","v":"ü"},{"$f":"IF(OR(P25=TRUE,AND(P20=TRUE,P23=TRUE),AND(P14=TRUE,P19=TRUE),AND(P44=TRUE,P45=TRUE)),FALSE,TRUE)","v":true},{"$f":"IF(O89=TRUE,CHAR(252),CHAR(251))","v":"ü"},null,null,{"$f":"IF(OR(T25=TRUE,AND(T20=TRUE,T23=TRUE),AND(T14=TRUE,T19=TRUE),T12=TRUE),FALSE,TRUE)","v":true},{"$f":"IF(S89=TRUE,CHAR(252),CHAR(251))","v":"ü"},{"$f":"IF(OR(AND(V20=TRUE,V23=TRUE),AND(V14=TRUE,V19=TRUE),V12=TRUE,AND(V44=TRUE,V45=TRUE)),FALSE,TRUE)","v":true},{"$f":"IF(U89=TRUE,CHAR(252),CHAR(251))","v":"ü"}]
[null,null,null,null,null,"HND L4/L5 Credit Thresholds Met",{"$f":"IF(AND(SUMIF(H5:H52,TRUE,$F5:$F52)>=120,SUMIF(H53:H84,TRUE,$F53:$F84)>=120),TRUE,FALSE)","v":false},{"$f":"IF(G90=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(SUMIF(J5:J52,TRUE,$F5:$F52)>=120,SUMIF(J53:J84,TRUE,$F53:$F84)>=120),TRUE,FALSE)","v":false},"û",{"$f":"IF(AND(SUMIF(L5:L52,TRUE,$F5:$F52)>=120,SUMIF(L53:L84,TRUE,$F53:$F84)>=120),TRUE,FALSE)","v":false},"û",{"$f":"IF(AND(SUMIF(N5:N52,TRUE,$F5:$F52)>=120,SUMIF(N53:N84,TRUE,$F53:$F84)>=120),TRUE,FALSE)","v":false},{"$f":"IF(M90=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(SUMIF(P5:P52,TRUE,$F5:$F52)>=120,SUMIF(P53:P84,TRUE,$F53:$F84)>=120),TRUE,FALSE)","v":false},{"$f":"IF(O90=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(SUMIF(R5:R52,TRUE,$F5:$F52)>=120,SUMIF(R53:R84,TRUE,$F53:$F84)>=120),TRUE,FALSE)","v":false},{"$f":"IF(Q90=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(SUMIF(T5:T52,TRUE,$F5:$F52)>=120,SUMIF(T53:T84,TRUE,$F53:$F84)>=120),TRUE,FALSE)","v":false},"û",{"$f":"IF(AND(SUMIF(V5:V52,TRUE,$F5:$F52)>=120,SUMIF(V53:V84,TRUE,$F53:$F84)>=120),TRUE,FALSE)","v":false},{"$f":"IF(U90=TRUE,CHAR(252),CHAR(251))","v":"û"}]
[null,null,null,null,null,"HND Core Mandatory Met",{"$f":"IF(H53=TRUE,TRUE,FALSE)","v":false},"û",{"$f":"IF(J53=TRUE,TRUE,FALSE)","v":false},"û",{"$f":"IF(L53=TRUE,TRUE,FALSE)","v":false},"û",{"$f":"IF(N53=TRUE,TRUE,FALSE)","v":false},{"$f":"IF(M91=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(P53=TRUE,TRUE,FALSE)","v":false},{"$f":"IF(O91=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(R53=TRUE,TRUE,FALSE)","v":false},{"$f":"IF(Q91=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(T53=TRUE,TRUE,FALSE)","v":false},"û",{"$f":"IF(V53=TRUE,TRUE,FALSE)","v":false},{"$f":"IF(U91=TRUE,CHAR(252),CHAR(251))","v":"û"}]
[null,null,null,null,null,"HND Core Group Choice Met",{"$f":"IF(AND(OR(H54=TRUE,H55=TRUE),SUMIF(H54:H55,TRUE,$F54:$F55)<45),TRUE,FALSE)","v":false},"û",{"$f":"IF(AND(OR(J54=TRUE,J55=TRUE),SUMIF(J54:J55,TRUE,$F54:$F55)<45),TRUE,FALSE)","v":false},"û",{"$f":"IF(AND(OR(L54=TRUE,L55=TRUE),SUMIF(L54:L55,TRUE,$F54:$F55)<45),TRUE,FALSE)","v":false},"û",{"$f":"IF(AND(OR(N54=TRUE,N55=TRUE),SUMIF(N54:N55,TRUE,$F54:$F55)<45),TRUE,FALSE)","v":false},{"$f":"IF(M92=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(OR(P54=TRUE,P55=TRUE),SUMIF(P54:P55,TRUE,$F54:$F55)<45),TRUE,FALSE)","v":false},{"$f":"IF(O92=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(OR(R54=TRUE,R55=TRUE),SUMIF(R54:R55,TRUE,$F54:$F55)<45),TRUE,FALSE)","v":false},{"$f":"IF(Q92=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(OR(T54=TRUE,T55=TRUE),SUMIF(T54:T55,TRUE,$F54:$F55)<45),TRUE,FALSE)","v":false},"û",{"$f":"IF(AND(OR(V54=TRUE,V55=TRUE),SUMIF(V54:V55,TRUE,$F54:$F55)<45),TRUE,FALSE)","v":false},{"$f":"IF(U92=TRUE,CHAR(252),CHAR(251))","v":"û"}]
[null,null,null,null,null,"HND Spec. Mandatory Met",{"$f":"IF(AND(H59=TRUE,H69=TRUE),TRUE,FALSE)","v":false},"û",{"$f":"IF(AND(J59=TRUE,J64=TRUE),TRUE,FALSE)","v":false},"û",{"$f":"IF(AND(L68=TRUE,L69=TRUE,L70=TRUE),TRUE,FALSE)","v":false},"û",{"$f":"IF(AND(N56=TRUE,N57=TRUE,N59=TRUE),TRUE,FALSE)","v":false},{"$f":"IF(M93=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(P59=TRUE,TRUE,FALSE)","v":false},{"$f":"IF(O93=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(R59=TRUE,R75=TRUE,R76=TRUE,R81=TRUE),TRUE,FALSE)","v":false},{"$f":"IF(Q93=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(T77=TRUE,T78=TRUE),TRUE,FALSE)","v":false},"û",{"$f":"IF(AND(V59=TRUE,V60=TRUE,V66=TRUE),TRUE,FALSE)","v":false},{"$f":"IF(U93=TRUE,CHAR(252),CHAR(251))","v":"û"}]
[null,null,null,null,null,"HND Specialist Choice Met",null,null,{"$f":"IF(OR(J63=TRUE,J72=TRUE,J74=TRUE),TRUE,FALSE)","v":false},"û",null,null,null,null,{"$f":"IF(OR(P74=TRUE,P79=TRUE,P80=TRUE),TRUE,FALSE)","v":false},{"$f":"IF(O94=TRUE,CHAR(252),CHAR(251))","v":"û"}]
[null,null,null,null,null,"HND Optional Choice Rules",null,null,{"$f":"IF(OR(AND(J20=TRUE,J23=TRUE,J68=TRUE,J69=TRUE,J70=TRUE),AND(J14=TRUE,J19=TRUE,J56=TRUE,J57=TRUE,J59=TRUE),AND(J12=TRUE,J59=TRUE,OR(J74=TRUE,J79=TRUE,J80=TRUE)),AND(IF(SUM(COUNTIF(J24,TRUE)+COUNTIF(J30:J33,TRUE)+COUNTIF(J46,TRUE))>3,TRUE,FALSE),J59=TRUE,J75=TRUE,J76=TRUE,J81=TRUE),AND(J44=TRUE,J45=TRUE,J77=TRUE,J78=TRUE),AND(J25=TRUE,J59=TRUE,J60=TRUE,J66=TRUE)),FALSE,TRUE)","v":true},"ü",{"$f":"IF(OR(AND(L25=TRUE,L59=TRUE,L64=TRUE,OR(L63=TRUE,L72=TRUE,L74=TRUE)),AND(L14=TRUE,L19=TRUE,L56=TRUE,L57=TRUE,L59=TRUE),AND(L12=TRUE,L59=TRUE,OR(L74=TRUE,L79=TRUE,L80=TRUE)),AND(IF(SUM(COUNTIF(L24,TRUE)+COUNTIF(L30:L33,TRUE)+COUNTIF(L46,TRUE))>3,TRUE,FALSE),L59=TRUE,L75=TRUE,L76=TRUE,L81=TRUE),AND(L44=TRUE,L45=TRUE,L77=TRUE,L78=TRUE),AND(L25=TRUE,L59=TRUE,L60=TRUE,L66=TRUE)),FALSE,TRUE)","v":true},"ü",{"$f":"IF(OR(AND(N25=TRUE,N59=TRUE,N64=TRUE,OR(N63=TRUE,N72=TRUE,N74=TRUE)),AND(N20=TRUE,N23=TRUE,N68=TRUE,N69=TRUE,N70=TRUE),AND(N12=TRUE,N59=TRUE,OR(N74=TRUE,N79=TRUE,N80=TRUE)),AND(IF(SUM(COUNTIF(N24,TRUE)+COUNTIF(N30:N33,TRUE)+COUNTIF(N46,TRUE))>3,TRUE,FALSE),N59=TRUE,N75=TRUE,N76=TRUE,N81=TRUE),AND(N44=TRUE,N45=TRUE,N77=TRUE,N78=TRUE),AND(N25=TRUE,N59=TRUE,N60=TRUE,N66=TRUE)),FALSE,TRUE)","v":true},{"$f":"IF(M95=TRUE,CHAR(252),CHAR(251))","v":"ü"},{"$f":"IF(OR(AND(P25=TRUE,P59=TRUE,P64=TRUE,OR(P63=TRUE,P72=TRUE,P74=TRUE)),AND(P20=TRUE,P23=TRUE,P68=TRUE,P69=TRUE,P70=TRUE),AND(P14=TRUE,P19=TRUE,P56=TRUE,P57=TRUE,P59=TRUE),AND(IF(SUM(COUNTIF(P24,TRUE)+COUNTIF(P30:P33,TRUE)+COUNTIF(P46,TRUE))>3,TRUE,FALSE),P59=TRUE,P75=TRUE,P76=TRUE,P81=TRUE),AND(P44=TRUE,P45=TRUE,P77=TRUE,P78=TRUE),AND(P25=TRUE,P59=TRUE,P60=TRUE,P66=TRUE)),FALSE,TRUE)","v":true},{"$f":"IF(O95=TRUE,CHAR(252),CHAR(251))","v":"ü"},null,null,{"$f":"IF(OR(AND(T25=TRUE,T59=TRUE,T64=TRUE,OR(T63=TRUE,T72=TRUE,T74=TRUE)),AND(T20=TRUE,T23=TRUE,T68=TRUE,T69=TRUE,T70=TRUE),AND(T14=TRUE,T19=TRUE,T56=TRUE,T57=TRUE,T59=TRUE),AND(T12=TRUE,T59=TRUE,OR(T74=TRUE,T79=TRUE,T80=TRUE)),AND(IF(SUM(COUNTIF(T24,TRUE)+COUNTIF(T30:T33,TRUE)+COUNTIF(T46,TRUE))>3,TRUE,FALSE),T59=TRUE,T75=TRUE,T76=TRUE,T81=TRUE),AND(T25=TRUE,T59=TRUE,T60=TRUE,T66=TRUE)),FALSE,TRUE)","v":true},{"$f":"IF(S95=TRUE,CHAR(252),CHAR(251))","v":"ü"},{"$f":"IF(OR(AND(V25=TRUE,V59=TRUE,V64=TRUE,OR(V63=TRUE,V72=TRUE,V74=TRUE)),AND(V20=TRUE,V23=TRUE,V68=TRUE,V69=TRUE,V70=TRUE),AND(V14=TRUE,V19=TRUE,V56=TRUE,V57=TRUE,V59=TRUE),AND(V12=TRUE,V59=TRUE,OR(V74=TRUE,V79=TRUE,V80=TRUE)),AND(IF(SUM(COUNTIF(V24,TRUE)+COUNTIF(V30:V33,TRUE)+COUNTIF(V46,TRUE))>3,TRUE,FALSE),V59=TRUE,V75=TRUE,V76=TRUE,V81=TRUE),AND(V44=TRUE,V45=TRUE,V77=TRUE,V78=TRUE)),FALSE,TRUE)","v":true},{"$f":"IF(U95=TRUE,CHAR(252),CHAR(251))","v":"ü"}]

{"sheet":"HN Aeronautical Eng. (2024)","index":1,"n_rows":55,"n_cols":13,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,11,3,11],[0,12,3,13]]}
[null,null,null,null,null,null,"Credit","Valid","Credit","Valid",null,"KEY\nCM \nCG1\nCG2\nCM1\nCM2\nSM\nO\nMLN","\n-  Core Mandatory\n-  Core Group 1\n-  Core Group 2\n-  Core Mandatory 1\n-  Core Mandatory 2\n-  Specialist Mandatory\n-  Optional\n-  Meeting Local Needs"]
["HN Aeronautical Engineering (2024)",null,null,null,null,"Level 4 HNC (120 Credits) - ",{"$f":"SUMIF(H5:H29,TRUE,$F5:$F29)","v":0},{"$f":"IF(G2>=120,IF(COUNTIF(G48:G51,FALSE)>0,CHAR(251),CHAR(252)),\"\")","v":""},{"$f":"SUMIF(J5:J29,TRUE,$F5:$F29)","v":0},{"$f":"IF(I2>=120,IF(COUNTIF(I48:I51,FALSE)>0,CHAR(251),CHAR(252)),\"\")","v":""}]
[null,null,null,null,null,"Level 5 HND (240 Credits) - ",{"$f":"SUMIF(H5:H46,TRUE,$F5:$F46)","v":0},{"$f":"IF(G3>=240,IF(SUM(COUNTIF(G48:G55,FALSE))>0,CHAR(251),CHAR(252)),\"\")","v":""},{"$f":"SUMIF(J5:J46,TRUE,$F5:$F46)","v":0},{"$f":"IF(I3>=240,IF(SUM(COUNTIF(I48:I55,FALSE))>0,CHAR(251),CHAR(252)),\"\")","v":""}]
["Unit No.","Unit Ref.","Unit Title","Level",null,"Credit","Aeronautical",null,"Aeronautical (Aerospace)"]
[4002,"A/651/0708","Engineering Mathematics",4,null,15,"CM",false,"CM",false]
[4003,"J/651/0710","Engineering Science I",4,null,15,"CM",false,"CM",false]
[4001,"T/650/9628","Engineering Design",4,null,15,"CG1",false,"CG1",false]
[4004,"L/651/0712","Managing a Professional Engineering Project",4,null,15,"CG1",false,"CG1",false]
[4062,"M/651/0803","Professional Engineering Practice",4,null,15,"CG2",false,"CG2",false]
[4063,"F/650/2943","Engineering Mechanics and Materials",4,null,15,"CG2",false,"CG2",false]
[4005,"R/651/0714","Renewable Energy",4,null,15,"O",false,"O",false]
[4008,"K/651/0720","Mechanical Principles",4,null,15,"O",false,"O",false]
[4017,"Y/651/0734","Quality and Process Improvement",4,null,15,"O",false,"O",false]
[4023,"A/651/0744","Computer Aided Design and Manufacture (CAD/CAM)",4,null,15,"O",false,"O",false]
[4030,"F/651/0755","Industry 4.0",4,null,15,"O",false,"O",false]
[4033,"T/651/0760","Programmable Logic Controllers",4,null,15,"O",false,"O",false]
[4034,"A/651/0762","Computer Aided Design (CAD) for Engineering",4,null,15,"O",false,"O",false]
[4041,"D/651/0772","Aircraft Aerodynamics",4,null,15,"SM",false,"SM",false]
[4042,"F/651/0773","Aircraft Electrical Power and Distribution Systems",4,null,15,"O",false,"O",false]
[4043,"K/651/0776","Airframe Mechanical Systems",4,null,15,"O",false,"O",false]
[4044,"R/651/0779","Composite Materials for Aerospace Applications",4,null,15,"O",false,"O",false]
[4045,"D/651/0781","Turbine Rotary Wing Mechanical and Flight Systems",4,null,15,"O",false,"O"]
[4061,"A/650/2923","Programming for Engineers",4,null,15,"O",false,"O",false]
[4068,"L/617/3940","Industrial Robots",4,null,15,"O",false,"O",false]
[4088,"J/650/3368","Space Technologies and Manufacturing",4,null,15,null,null,"SM",false]
[4089,"K/650/3369","Net Zero Energy Technologies I: Systems and Demand",4,null,15,"O",false,"O",false]
[4090,"M/650/9509","Engineering Science II",4,null,15,"O",false,"O",false]
["-","-","Meeting Local Needs (approval must be sought prior to delivery)",4,null,15,"MLN",false,"MLN",false]
["-","-","Meeting Local Needs (approval must be sought prior to delivery)",4,null,15,"MLN",false,"MLN",false]
[5002,"F/651/0809","Professional Engineering Management",5,null,15,"CM",false,"CM",false]
[5001,"J/615/1502","Research Project",5,null,30,"CM1",false,"CM1",false]
[5041,"M/650/2948","Engineering Project",5,null,15,"CM2",false,"CM2",false]
[5006,"Y/651/0860","Further Engineering Mathematics",5,null,15,"SM",false,"SM",false]
[5026,"T/651/0888","Aircraft Flight Control Systems",5,null,15,"SM",false,"SM",false]
[5027,"Y/651/0889","Aircraft Propulsion Principles and Technology",5,null,15,"O",false]
[5028,"F/651/0890","Aircraft Structural Integrity",5,null,15,"O",false,"O",false]
[5029,"H/651/0891","Avionic Systems",5,null,15,"O",false,"O",false]
[5030,"J/651/0892","Aircraft Gas Turbine Engine Design and Performance",5,null,15,"O",false,"O",false]
[5031,"K/651/0893","Advanced Composite Materials for Aerospace Applications",5,null,15,"O",false,"O",false]
[5032,"L/651/0894","Advanced Turbine Rotary Wing Aircraft Mechanical and Flight Systems",5,null,15,"O",false,"O",false]
[5048,"J/650/2990","Sensors and Automation",5,null,15,"O",false,"O",false]
[5054,"Y/650/3372","Net Zero Energy Technologies II: Infrastructure and Pathways",5,null,15,"O",false,"O",false]
[5055,"Y/650/9510","Aerospace Propulsion Principles and Technology",5,null,15,null,null,"SM",false]
[5056,"A/650/9511","Conceptual Aircraft Design",5,null,15,"O",false,"O",false]
["-","-","Meeting Local Needs (approval must be sought prior to delivery)",5,null,15,"MLN",false,"MLN",false]
["-","-","Meeting Local Needs (approval must be sought prior to delivery)",5,null,15,"MLN",false,"MLN",false]
[]
[null,null,null,null,null,"HNC Core Mandatory Met",{"$f":"IF(AND(H5=TRUE,H6=TRUE),TRUE,FALSE)","v":false},{"$f":"IF(G48=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(J5=TRUE,J6=TRUE),TRUE,FALSE)","v":false},{"$f":"IF(I48=TRUE,CHAR(252),CHAR(251))","v":"û"}]
[null,null,null,null,null,"HNC Core Group Choice Met",{"$f":"IF(AND(SUMIF(H7:H10,TRUE,$F7:$F10)=30,OR(AND(H7=TRUE,H8=TRUE),AND(H9=TRUE,H10=TRUE))),TRUE,FALSE)","v":false},{"$f":"IF(G49=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(SUMIF(J7:J10,TRUE,$F7:$F10)=30,OR(AND(J7=TRUE,J8=TRUE),AND(J9=TRUE,J10=TRUE))),TRUE,FALSE)","v":false},"û"]
[null,null,null,null,null,"HNC Spec. Mandatory Met",{"$f":"IF(H18=TRUE,TRUE,FALSE)","v":false},{"$f":"IF(G50=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(J18=TRUE,J25=TRUE),TRUE,FALSE)","v":false},"û"]
[null,null,null,null,null,"HNC Optional Choice Rules",{"$f":"IF(AND(H14=TRUE,H17=TRUE),FALSE,TRUE)","v":true},"ü",{"$f":"IF(AND(J14=TRUE,J17=TRUE),FALSE,TRUE)","v":true},"ü"]
[null,null,null,null,null,"HND L4/L5 Credit Thresholds Met",{"$f":"IF(AND(SUMIF(H5:H29,TRUE,$F5:$F29)>=120,SUMIF(H30:H46,TRUE,$F30:$F46)>=120),TRUE,FALSE)","v":false},{"$f":"IF(G52=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(SUMIF(J5:J29,TRUE,$F5:$F29)>=120,SUMIF(J30:J46,TRUE,$F30:$F46)>=120),TRUE,FALSE)","v":false},"û"]
[null,null,null,null,null,"HND Core Mandatory Met",{"$f":"IF(H30=TRUE,TRUE,FALSE)","v":false},"û",{"$f":"IF(J30=TRUE,TRUE,FALSE)","v":false},"û"]
[null,null,null,null,null,"HND Core Group Choice Met",{"$f":"IF(AND(OR(H31=TRUE,H32=TRUE),SUMIF(H31:H32,TRUE,$F31:$F32)<45),TRUE,FALSE)","v":false},"û",{"$f":"IF(AND(OR(J31=TRUE,J32=TRUE),SUMIF(J31:J32,TRUE,$F31:$F32)<45),TRUE,FALSE)","v":false},"û"]
[null,null,null,null,null,"HND Spec. Mandatory Met",{"$f":"IF(AND(H33=TRUE,H34=TRUE),TRUE,FALSE)","v":false},"û",{"$f":"IF(AND(J33=TRUE,J34=TRUE,J43=TRUE),TRUE,FALSE)","v":false},"û"]

{"sheet":"HN Automotive Eng. (2024)","index":2,"n_rows":73,"n_cols":13,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,11,3,11],[0,12,3,13]]}
[null,null,null,null,null,null,"Credit","Valid","Credit","Valid",null,"KEY\nCM \nCM1\nCM2\nCM3\nSM\nO\nMLN","\n-  Core Mandatory\n-  Core Mandatory Choice 1\n-  Core Mandatory Choice 2\n-  Core Mandatory Choice 3\n-  Specialist Mandatory\n-  Optional\n-  Meeting Local Needs"]
["HN Automotive Engineering (2024)",null,null,null,null,"Level 4 HNC (120 Credits) - ",{"$f":"SUMIF(H5:H34,TRUE,$F5:$F34)","v":0},{"$f":"IF(G2>=120,IF(COUNTIF(G65:G69,FALSE)>0,CHAR(251),CHAR(252)),\"\")","v":""},{"$f":"SUMIF(J5:J34,TRUE,$F5:$F34)","v":0},{"$f":"IF(I2>=120,IF(COUNTIF(I65:I68,FALSE)>0,CHAR(251),CHAR(252)),\"\")","v":""}]
[null,null,null,null,null,"Level 5 HND (240 Credits) - ",{"$f":"SUMIF(H5:H63,TRUE,$F5:$F63)","v":0},{"$f":"IF(G3>=240,IF(SUM(COUNTIF(G65:G73,FALSE))>0,CHAR(251),CHAR(252)),\"\")","v":""},{"$f":"SUMIF(J5:J63,TRUE,$F5:$F63)","v":0},{"$f":"IF(I3>=240,IF(SUM(COUNTIF(I65:I73,FALSE))>0,CHAR(251),CHAR(252)),\"\")","v":""}]
["Unit No.","Unit Ref.","Unit Title","Level",null,"Credit","Automotive",null,"Automotive (Motorsports)"]
[4001,"T/650/9628","Engineering Design",4,null,15,"CM1",false,"CM1",false]
[4063,"F/650/2943","Engineering Mechanics and Materials",4,null,15,"CM1",false,"CM1",false]
[4002,"A/651/0708","Engineering Mathematics",4,null,15,"CM",false,"CM",false]
[4003,"J/651/0710","Engineering Science I",4,null,15,"CM",false,"CM",false]
[4004,"L/651/0712","Managing a Professional Engineering Project",4,null,15,"CM2",false,"CM2",false]
[4062,"M/651/0803","Professional Engineering Practice",4,null,15,"CM2",false,"CM2",false]
[4011,"T/651/0724","Fluid Mechanics",4,null,15,"O",false,"O",false]
[4013,"D/651/0727","Fundamentals of Thermodynamics and Heat Transfer",4,null,15,"O",false,"O",false]
[4023,"A/651/0744","Computer Aided Design and Manufacture (CAD/CAM)",4,null,15,"O",false,"O",false]
[4026,"K/651/0749","Electrical Systems and Fault Finding",4,null,15,"O",false]
[4035,"D/651/0763","Welding Technology",4,null,15,"O",false,"O",false]
[4061,"A/650/2923","Programming for Engineers",4,null,15,"O",false,"O",false]
[4089,"K/650/3369","Net Zero Energy Technologies I: Systems and Demand",4,null,15,"O",false,"O",false]
[4091,"M/651/3044","Automotive Fundamentals",4,null,15,"SM",false]
[4092,"R/651/3045","Vehicle Dynamics and Performance",4,null,15,"SM/O",false,"O",false]
[4093,"T/651/3046","Race Car Design and Manufacturing",4,null,15,null,null,"SM",false]
[4094,"Y/651/3047","Motorsport Workshop Practices",4,null,15,null,null,"SM",false]
[4095,"A/651/3048","Automotive Combustion",4,null,15,"O",false,"O",false]
[4096,"D/651/3049","Automotive Workshop Practices",4,null,15,"SM/O",false]
[4097,"J/651/3050","Electric Vehicle Battery Manufacture",4,null,15,"O",false,"O",false]
[4098,"K/651/3051","Hybrid and Electric Vehicle Technologies",4,null,15,"O",false,"O",false]
[4099,"L/651/3052","Industrial Digitalisation Technologies for Engineers",4,null,15,"O",false]
[4100,"F/651/3068","Lean Six Sigma for Engineers (Leading to Green Belt)",4,null,15,"O",false,"O",false]
[4111,"H/651/3069","Powertrain and Hybrid Vehicles",4,null,15,"O",false,"O",false]
[4112,"L/651/3070","Vehicle Repair and Diagnostics",4,null,15,"O",false,"O",false]
[4113,"M/651/3071","Heavy Vehicles I",4,null,15,"O",false]
[4114,"R/651/3072","Motorcycle Engineering",4,null,15,"O",false]
[4115,"T/651/3073","Vehicle Electrical and Electronics",4,null,15,"O",false]
["-","-","Meeting Local Needs (approval must be sought prior to delivery)",4,null,15,"MLN",false,"MLN",false]
["-","-","Meeting Local Needs (approval must be sought prior to delivery)",4,null,15,"MLN",false,"MLN",false]
[5001,"J/615/1502","Research Project",5,null,30,"CM3",false,"CM3",false]
[5041,"M/650/2948","Engineering Project",5,null,15,"CM3",false,"CM3",false]
[5002,"F/651/0809","Professional Engineering Management",5,null,15,"CM",false,"CM",false]
[5004,"L/651/0858","Computational Modelling in Virtual Engineering",5,null,15,"O",false,"O",false]
[5005,"M/651/0859","Further Thermodynamics",5,null,15,"O",false,"O",false]
[5006,"Y/651/0860","Further Engineering Mathematics",5,null,15,"SM",false,"SM",false]
[5015,"J/615/1516","Manufacturing Systems Engineering",5,null,15,"O",false,"O",false]
[5016,"M/651/0877","Lean Manufacturing",5,null,15,"O",false,"O",false]
[5017,"D/651/0880","Advanced Manufacturing",5,null,15,"O",false,"O",false]
[5018,"Y/615/1519","Sustainability",5,null,15,"O",false,"O",false]
[5023,"R/651/0887","Thermofluids",5,null,15,"O",false,"O",false]
[5048,"J/650/2990","Sensors and Automation",5,null,15,"O",false,"O",false]
[5054,"Y/650/3372","Net Zero Energy Technologies II: Infrastructure and Pathways",5,null,15,"O",false,"O",false]
[5058,"Y/651/3074","Automotive Structures and Materials",5,null,15,"SM",false,"O",false]
[5059,"A/651/3075","Automotive Aerodynamics",5,null,15,"SM",false,"SM",false]
[5060,"D/651/3076","Motorsport Workshop Preparation and Inspection",5,null,15,null,null,"SM",false]
[5061,"F/651/3077","Automotive Incident Investigation",5,null,15,"O",false]
[5062,"H/651/3078","Engine and Vehicle Design Performance",5,null,15,"O",false,"O",false]
[5063,"J/651/3079","Further Hybrid and Electric Vehicle Technologies",5,null,15,"O",false,"O",false]
[5064,"M/651/3080","Further Industrial Digitalisation Technologies for Engineers",5,null,15,"O",false]
[5065,"R/651/3081","Hydrogen in Automotive Engineering",5,null,15,"O",false,"O",false]
[5066,"T/651/3082","Lean Six Sigma for Engineers (Leading to Black Belt)",5,null,15,"O",false,"O",false]
[5067,"Y/651/3083","Vehicle Operations",5,null,15,"O",false]
[5068,"A/651/3084","Vehicle Parts Management",5,null,15,"O",false]
[5069,"D/651/3085","Vehicle Systems and Technology",5,null,15,"O",false,"O",false]
[5070,"F/651/3086","Further Motorcycle Engineering",5,null,15,"O",false]
[5071,"H/651/3087","Heavy Vehicles II",5,null,15,"O",false]
["-","-","Meeting Local Needs (approval must be sought prior to delivery)",5,null,15,"MLN",false,"MLN",false]
["-","-","Meeting Local Needs (approval must be sought prior to delivery)",5,null,15,"MLN",false,"MLN",false]
[]
[null,null,null,null,null,"HNC Core Mandatory Met",{"$f":"IF(AND(H7=TRUE,H8=TRUE),TRUE,FALSE)","v":false},{"$f":"IF(G65=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(J7=TRUE,J8=TRUE),TRUE,FALSE)","v":false},{"$f":"IF(I65=TRUE,CHAR(252),CHAR(251))","v":"û"}]
[null,null,null,null,null,"HNC Core Choice 1 Met",{"$f":"IF(AND(SUMIF(H5:H6,TRUE,$F5:$F6)=15,OR(H5=TRUE,H6=TRUE)),TRUE,FALSE)","v":false},{"$f":"IF(G66=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(SUMIF(J5:J6,TRUE,$F5:$F6)=15,OR(J5=TRUE,J6=TRUE)),TRUE,FALSE)","v":false},"û"]
[null,null,null,null,null,"HNC Core Choice 2 Met",{"$f":"IF(AND(SUMIF(H9:H10,TRUE,$F9:$F10)=15,OR(H9=TRUE,H10=TRUE)),TRUE,FALSE)","v":false},{"$f":"IF(G67=TRUE,CHAR(252),CHAR(251))","v":"û"},{"$f":"IF(AND(SUMIF(J9:J10,TRUE,$F9:$F10)=15,OR(J9=TRUE,J10=TRUE)),TRUE,FALSE)","v":false},"û"]
[null,null,null,null,null,"HNC Spec. Mandatory Met",{"$f":"IF(H18=TRUE,TRUE,FALSE)","v":false},"û",{"$f":"IF(AND(J20=TRUE,J21=TRUE),TRUE,FALSE)","v":false},"û"]
[null,null,null,null,null,"HNC Specialist Choice Met",{"$f":"IF(OR(H19=TRUE,H23=TRUE),TRUE,FALSE)","v":false},"û"]
[null,null,null,null,null,"HND L4/L5 Credit Thresholds Met",{"$f":"IF(AND(SUMIF(H5:H34,TRUE,$F5:$F34)>=120,SUMIF(H35:H63,TRUE,$F35:$F63)>=120),TRUE,FALSE)","v":false},"û",{"$f":"IF(AND(SUMIF(J5:J34,TRUE,$F5:$F34)>=120,SUMIF(J35:J63,TRUE,$F35:$F63)>=120),TRUE,FALSE)","v":false},"û"]
[null,null,null,null,null,"HND Core Mandatory Met",{"$f":"IF(H37=TRUE,TRUE,FALSE)","v":false},"û",{"$f":"IF(J37=TRUE,TRUE,FALSE)","v":false},"û"]
[null,null,null,null,null,"HND Core Choice 3 Met",{"$f":"IF(AND(SUMIF(H35:H36,TRUE,$F35:$F36)<45,OR(H35=TRUE,H36=TRUE)),TRUE,FALSE)","v":false},"û",{"$f":"IF(AND(SUMIF(J35:J36,TRUE,$F35:$F36)<45,OR(J35=TRUE,J36=TRUE)),TRUE,FALSE)","v":false},"û"]
[null,null,null,null,null,"HND Spec. Mandatory Met",{"$f":"IF(AND(H40=TRUE,H48=TRUE,H49=TRUE),TRUE,FALSE)","v":false},"û",{"$f":"IF(AND(J40=TRUE,J49=TRUE,J50=TRUE),TRUE,FALSE)","v":false},"û"]