{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["MAIN_PAGE","Base_model2021","models","Base2021_with_suppl","Cybersec_2021","options_by_area","options_sorted","Space_sys_2021","Base_1819","Base1819_with_suppl","opt_sens_commun","opt_sens_commun_4_space","opt_netw_and_sec","opt_data_anal","opt_netw_and_sec_4_cyber","opt_netw_and_sec_4_space"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":14,"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":"MAIN_PAGE","index":0,"n_rows":21,"n_cols":17,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,11],[2,1,2,11],[7,2,7,6],[7,8,7,11],[8,2,8,6],[8,8,8,11],[9,2,9,6],[9,8,9,11],[10,2,10,6],[10,8,10,11],[11,2,11,6],[11,8,11,11],[20,1,20,13],[12,8,12,11],[13,2,13,4],[13,8,13,11],[18,2,18,13]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"pds-2021-LM-v15"]
[null,"Master's Degree \"ICT and Internet Engineering\" - Piano di studi 2020/21"]
[null,"MAIN PAGE WITH SUMMARY"]
[null,"Total CFU",{"$f":"IF(P19<>\"\",INDIRECT(P19&\"!c4\"),\"-\")","v":"-"},null,"Missing CFU",{"$f":"IF(P19<>\"\",INDIRECT(P19&\"!f4\"),\"-\")","v":"-"},null,"Model",{"$f":"P19","v":""}]
[null,"Excess CFU",{"$f":"IF(P19<>\"\",INDIRECT(P19&\"!c5\"),\"-\")","v":"-"},null,"Status",{"$f":"IF(P19<>\"\",INDIRECT(P19&\"!f5\"),\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Locked"]
[]
[null,"Surname Name:",null,null,null,null,null,null,{"$f":"IF(C8=\"\",\"ERROR - Insert Surname Name\",\"OK\")","v":"ERROR - Insert Surname Name"}]
[null,"Matricola (Student's ID):",null,null,null,null,null,null,{"$f":"IF(C9=\"\",\"ERROR - Insert Student's ID\",\"OK\")","v":"ERROR - Insert Student's ID"}]
[null,"Fiscal Code:",null,null,null,null,null,null,{"$f":"Q10","v":"ERROR - Insert Fiscal Code"},null,null,null,null,null,null,{"$f":"IF(AND(UPPER(MID(C10,16,1))=CHAR(MOD((CODE(MID(UPPER(C10),2,1))-65)+(CODE(MID(UPPER(C10),4,1))-65)+(CODE(MID(UPPER(C10),6,1))-65)+(CODE(MID(UPPER(C10),8,1))-48)+(CODE(MID(UPPER(C10),10,1))-48)+(CODE(MID(UPPER(C10),12,1))-65)+(CODE(MID(UPPER(C10),14,1))-48)+(FIND(MID(UPPER(C10),1,1),\"BAKPLCQDREVOSFTGUHMINJWZYX\")-1)+(FIND(MID(UPPER(C10),3,1),\"BAKPLCQDREVOSFTGUHMINJWZYX\")-1)+(FIND(MID(UPPER(C10),5,1),\"BAKPLCQDREVOSFTGUHMINJWZYX\")-1)+(FIND(MID(UPPER(C10),7,1),\"10AAA2A3A4AAA5A6A7A8A9\")-1)+(FIND(MID(UPPER(C10),9,1),\"BAKPLCQDREVOSFTGUHMINJWZYX\")-1)+(FIND(MID(UPPER(C10),11,1),\"10AAA2A3A4AAA5A6A7A8A9\")-1)+(FIND(MID(UPPER(C10),13,1),\"10AAA2A3A4AAA5A6A7A8A9\")-1)+(FIND(MID(UPPER(C10),15,1),\"10AAA2A3A4AAA5A6A7A8A9\")-1),26)+65),LEN(C10)=16),\"OK\",\"ERROR - Wrong Fiscal Code\")","v":{"$error":"#VALUE!"}},{"$f":"IF(C10=\"\",\"ERROR - Insert Fiscal Code\",IF(ISERROR(P10),\"ERROR - Wrong Fiscal Code\",P10))","v":"ERROR - Insert Fiscal Code"}]
[null,"E-mail address:",null,null,null,null,null,null,{"$f":"Q11","v":"ERROR - Insert e-mail address"},null,null,null,null,null,null,{"$f":"ISNUMBER(MATCH(\"*@*.?*\",C11,0))","v":false},{"$f":"IF(C11=\"\",\"ERROR - Insert e-mail address\",IF(P11,\"OK\",\"ERROR - Wrong e-mail\"))","v":"ERROR - Insert e-mail address"}]
[null,"Phone:",null,null,null,null,null,null,{"$f":"IF(C12=\"\",\"ERROR - Insert Phone\",\"OK\")","v":"ERROR - Insert Phone"}]
[null,"Course Year (I or II):","-",null,null,null,null,null,{"$f":"IF(C13=\"-\",\"ERROR - Insert Course Year\",\"OK\")","v":"ERROR - Insert Course Year"}]
[null,"Regular year/Supplem. Year (fuori corso)","-",null,null,null,null,null,{"$f":"IF(C14=\"-\",\"ERROR - Select Reg. or Supplem. Year\",\"OK\")","v":"ERROR - Select Reg. or Supplem. Year"}]
[]
[]
[null,"Please insert your personal data above, then select the model of your study plan from the dropdown menu."]
[]
[null,"Selected model","-",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C19<>\"-\",LEFT(MID(C19,4,20),FIND(\" \",MID(C19,4,20))-1),\"\")","v":""}]
[]
[null,"Fill out the worksheet corresponding to the chosen model.\n\nFor each exam selected as \"To take\" or \"Taken\" you need to select the \"Actual year\" in which you plan to take the exam (or in which you have taken the exam).\nFor each exam selected as \"NO\", the \"Actual year\" needs to be canceled by selecting \"-\".\n\nPlease deliver you plan when it has no errors, you will find the message \"THE STUDY PLAN IS FORMALLY CORRECT\" in the heading of the MAIN_PAGE.\n\nSave the excel workbook using your surname as filename: your_surname.xlsm and send the file as e-mail attachment to: ingegneriainternet@gmail.com with subject: \"study plan submission 2021\""]

{"sheet":"Base_model2021","index":1,"n_rows":121,"n_cols":14,"rows_kept":121,"cut":false,"hidden":false,"merged":[[116,3,116,4],[120,3,120,6],[7,2,7,6],[8,2,8,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[13,2,13,4],[13,8,13,11],[1,1,1,11],[2,1,2,11],[8,8,8,11],[9,8,9,11],[10,8,10,11],[11,8,11,11],[12,8,12,11],[7,8,7,11]]}
[]
[null,"Master's Degree \"ICT and Internet Engineering\" - Piano di studi 2020/21"]
[null,"Generic Model"]
[null,"Total CFU",{"$f":"D113","v":78},null,"Missing CFU",{"$f":"MAX(0,120-C4)","v":42}]
[null,"Excess CFU",{"$f":"D114","v":0},null,"Status",{"$f":"D121","v":"THE STUDY PLAN HAS SOME FORMAL ERRORS (1)"}]
[]
[]
[null,"Surname Name:",{"$f":"IF(MAIN_PAGE!C8=0,\"\",MAIN_PAGE!C8)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I8","v":"ERROR - Insert Surname Name"}]
[null,"Matricola (Student's ID):",{"$f":"IF(MAIN_PAGE!C9=0,\"\",MAIN_PAGE!C9)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I9","v":"ERROR - Insert Student's ID"}]
[null,"Fiscal Code:",{"$f":"IF(MAIN_PAGE!C10=0,\"\",MAIN_PAGE!C10)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I10","v":"ERROR - Insert Fiscal Code"}]
[null,"E-mail address:",{"$f":"IF(MAIN_PAGE!C11=0,\"\",MAIN_PAGE!C11)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I11","v":"ERROR - Insert e-mail address"}]
[null,"Phone:",{"$f":"IF(MAIN_PAGE!C12=0,\"\",MAIN_PAGE!C12)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I12","v":"ERROR - Insert Phone"}]
[null,"Course Year (I or II):",{"$f":"IF(MAIN_PAGE!C13=0,\"\",MAIN_PAGE!C13)","v":"-"},null,null,null,null,null,{"$f":"MAIN_PAGE!I13","v":"ERROR - Insert Course Year"}]
[null,"Regular year/Supplem. Year (fuori corso)",{"$f":"IF(MAIN_PAGE!C14=0,\"\",MAIN_PAGE!C14)","v":"-"},null,null,null,null,null,{"$f":"MAIN_PAGE!I14","v":"ERROR - Select Reg. or Supplem. Year"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"Mandatory subjects","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
["i1","Internet Technology and Protocols  (ex Networking and Internet Protocols) (9 CFU)","(1)",9,"To Take",1,1,1,"-",{"$f":"IF(I19<>\"X\",IF(E19=\"Taken\",D19,\"\"),\"\")","v":""},{"$f":"IF(I19<>\"X\",IF(E19=\"To Take\",D19,\"\"),\"\")","v":9},{"$f":"IF(I19=\"X\",IF(E19=\"Taken\",D19,\"\"),\"\")","v":""},{"$f":"IF(I19=\"X\",IF(E19=\"To Take\",D19,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(E19=\"NO\",G19<>\"-\"),AND(E19<>\"NO\",G19=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A19,2,LEN(A19)-1))+1","v":"i2"},"Internet Technology and Protocols  (ex Networking and Internet Protocols) (6 CFU)",{"$f":"C19","v":"(1)"},6,"NO",1,"-",1,"-","","","","","OK"]
["i3","Service-oriented Software Engineering",null,9,"To Take",1,1,1,"-","",9,"","","OK"]
["i4","Wireless Electromagnetic Technologies",null,9,"To Take",1,1,1,"-","",9,"","","OK"]
["i5","Digital Communications",null,6,"To Take",1,1,1,"-",{"$f":"IF(I23<>\"X\",IF(E23=\"Taken\",D23,\"\"),\"\")","v":""},{"$f":"IF(I23<>\"X\",IF(E23=\"To Take\",D23,\"\"),\"\")","v":6},{"$f":"IF(I23=\"X\",IF(E23=\"Taken\",D23,\"\"),\"\")","v":""},{"$f":"IF(I23=\"X\",IF(E23=\"To Take\",D23,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(E23=\"NO\",G23<>\"-\"),AND(E23<>\"NO\",G23=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
["i6","Mobile Wireless Networks",null,9,"To Take",1,1,2,"-","",9,"","","OK"]
["i7","Network Infrastructures",null,6,"To Take",1,1,2,"-","",6,"","","OK"]
["i8","Fundamentals of Radar and Localization",null,9,"To Take",1,1,2,"-","",9,"","","OK"]
["i9","Formative activities",null,3,"To Take",2,2,"-","-","",3,"","","OK"]
["i10","Prova finale",null,18,"To Take",2,2,"-","-","",18,"","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J19:J28)","v":0},{"$f":"SUM(K19:K28)","v":78},{"$f":"SUM(L19:L28)","v":0},{"$f":"SUM(M19:M28)","v":0}]
[null,"Total CFU mandatory subjects",null,{"$f":"SUM(J29:K29)","v":78},null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[null,"Total CFU mandatory subject (excess)",null,{"$f":"SUM(L29:M29)","v":0}]
[]
[{"$f":"C19","v":"(1)"},{"$f":"\"Choose one between \"&A19&\" and \"&A20","v":"Choose one between i1 and i2"},null,{"$f":"IF(_xlfn.XOR(OR(E19=\"To Take\",E19=\"Taken\"),OR(E20=\"To Take\",E20=\"Taken\")),\"OK\",\"ERROR\")","v":"OK"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"AREA “SENSING AND COMMUNICATIONS”","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A28,2,LEN(A28)-1))+1","v":"i11"},"Satellite Navigation and Surveillance Systems (9 CFU)",{"$f":"\"(\"&VALUE(MID(C20,2,LEN(C20)-2))+1&\")\"","v":"(2)"},9,"NO",2,"-",1,"-",{"$f":"IF(I37<>\"X\",IF(E37=\"Taken\",D37,\"\"),\"\")","v":""},{"$f":"IF(I37<>\"X\",IF(E37=\"To Take\",D37,\"\"),\"\")","v":""},{"$f":"IF(I37=\"X\",IF(E37=\"Taken\",D37,\"\"),\"\")","v":""},{"$f":"IF(I37=\"X\",IF(E37=\"To Take\",D37,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(E37=\"NO\",G37<>\"-\"),AND(E37<>\"NO\",G37=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A37,2,LEN(A37)-1))+1","v":"i12"},"Satellite Navigation and Surveillance Systems (6 CFU)",{"$f":"C37","v":"(2)"},6,"NO",2,"-",1,"-","","","","","OK"]
[{"$f":"\"i\"&VALUE(MID(A38,2,LEN(A38)-1))+1","v":"i13"},"Internet Via Satellite",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i14","Radar Systems and Applications ",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i15","Satellite Earth Observation (9 CFU)",{"$f":"\"(\"&VALUE(MID(C37,2,LEN(C37)-2))+1&\")\"","v":"(3)"},9,"NO","1 o 2","-",2,"-","","","","","OK"]
["i16","Satellite Earth Observation (6 CFU)",{"$f":"C41","v":"(3)"},6,"NO","1 o 2","-",2,"-","","","","","OK"]
["i17","Radiowave Propagation",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i18","Microwaves",null,6,"NO",2,"-",2,"-","","","","","OK"]
["i19","Optical Communications",null,6,"NO",2,"-",1,"-","","","","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J37:J45)","v":0},{"$f":"SUM(K37:K45)","v":0},{"$f":"SUM(L37:L45)","v":0},{"$f":"SUM(M37:M45)","v":0}]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[{"$f":"C37","v":"(2)"},{"$f":"\"Choose at most one between \"&A37&\" and \"&A38","v":"Choose at most one between i11 and i12"},null,{"$f":"IF(AND(OR(E37=\"To Take\",E37=\"Taken\"),OR(E38=\"To Take\",E38=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"C41","v":"(3)"},{"$f":"\"Choose at most one between \"&A41&\" and \"&A42","v":"Choose at most one between i15 and i16"},null,{"$f":"IF(AND(OR(E41=\"To Take\",E41=\"Taken\"),OR(E42=\"To Take\",E42=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"AREA “NETWORKS & SECURITY”","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A45,2,LEN(A45)-1))+1","v":"i20"},"Network Security (9 CFU)",{"$f":"\"(\"&VALUE(MID(C41,2,LEN(C41)-2))+1&\")\"","v":"(4)"},9,"NO",2,"-",1,"-",{"$f":"IF(I53<>\"X\",IF(E53=\"Taken\",D53,\"\"),\"\")","v":""},{"$f":"IF(I53<>\"X\",IF(E53=\"To Take\",D53,\"\"),\"\")","v":""},{"$f":"IF(I53=\"X\",IF(E53=\"Taken\",D53,\"\"),\"\")","v":""},{"$f":"IF(I53=\"X\",IF(E53=\"To Take\",D53,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(E53=\"NO\",G53<>\"-\"),AND(E53<>\"NO\",G53=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A53,2,LEN(A53)-1))+1","v":"i21"},"Network Security (6 CFU)",{"$f":"C53","v":"(4)"},6,"NO",2,"-",1,"-","","","","","OK"]
["i22","Enterprise Networks",{"$f":"\"(\"&VALUE(MID(C53,2,LEN(C53)-2))+1&\")\"","v":"(5)"},6,"NO",2,"-",1,"-","","","","",{"$f":"IF(OR(AND(E55=\"NO\",G55<>\"-\"),AND(E55<>\"NO\",G55=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
["i23","Networks and Systems Defence",{"$f":"C55","v":"(5)"},6,"NO",2,"-",1,"-","","","","","OK"]
["i24","Cloud Computing and Networking",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i25","Hardware, Electromagnetic and Localizion Security",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i26","Multimedia Processing and Communication",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i27","Internet Services Performance (9 CFU)",{"$f":"\"(\"&VALUE(MID(C55,2,LEN(C55)-2))+1&\")\"","v":"(6)"},9,"NO",2,"-",1,"-","","","","","OK"]
["i28","Internet Services Performance (6 CFU)",{"$f":"C60","v":"(6)"},6,"NO",2,"-",1,"-","","","","","OK"]
["i29","Internet of Things: Principles and Applications ",null,6,"NO",2,"-",2,"-","","","","","OK"]
["i30","Internet-based Distributed Simulation",null,6,"NO",2,"-",2,"-","","","","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J53:J63)","v":0},{"$f":"SUM(K53:K63)","v":0},0,0]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[{"$f":"C53","v":"(4)"},{"$f":"\"Choose at most one between \"&A53&\" and \"&A54","v":"Choose at most one between i20 and i21"},null,{"$f":"IF(AND(OR(E53=\"To Take\",E53=\"Taken\"),OR(E54=\"To Take\",E54=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"C55","v":"(5)"},{"$f":"\"Choose at most one between \"&A55&\" and \"&A56","v":"Choose at most one between i22 and i23"},null,{"$f":"IF(AND(OR(E55=\"To Take\",E55=\"Taken\"),OR(E56=\"To Take\",E56=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"C60","v":"(6)"},{"$f":"\"Choose at most one between \"&A60&\" and \"&A61","v":"Choose at most one between i27 and i28"},null,{"$f":"IF(AND(OR(E60=\"To Take\",E60=\"Taken\"),OR(E61=\"To Take\",E61=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"AREA “DATA ANALYTICS & METHODOLOGIES”","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A63,2,LEN(A63)-1))+1","v":"i31"},"Information Theory and Data Mining",null,6,"NO",2,"-",1,"-",{"$f":"IF(I72<>\"X\",IF(E72=\"Taken\",D72,\"\"),\"\")","v":""},{"$f":"IF(I72<>\"X\",IF(E72=\"To Take\",D72,\"\"),\"\")","v":""},{"$f":"IF(I72=\"X\",IF(E72=\"Taken\",D72,\"\"),\"\")","v":""},{"$f":"IF(I72=\"X\",IF(E72=\"To Take\",D72,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(E72=\"NO\",G72<>\"-\"),AND(E72<>\"NO\",G72=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A72,2,LEN(A72)-1))+1","v":"i32"},"Operations Research Methods for Network Optimization (9 CFU, taught in Italian)",{"$f":"\"(\"&VALUE(MID(C60,2,LEN(C60)-2))+1&\")\"","v":"(7)"},9,"NO",2,"-",1,"-","","","","","OK"]
["i33","Operations Research Methods for Network Optimization (6 CFU, taught in Italian)",{"$f":"C73","v":"(7)"},6,"NO",2,"-",1,"-","","","","","OK"]
["i34","Optimization Methods for Big Data (taught in Italian)",null,6,"NO",2,"-",2,"-","","","","","OK"]
["i35","Web Mining and Retrieval",{"$f":"\"(\"&VALUE(MID(C73,2,LEN(C73)-2))+1&\")\"","v":"(8)"},9,"NO",2,"-",2,"-","","","","","OK"]
["i36","Web Mining and Retrieval",{"$f":"C76","v":"(8)"},6,"NO",2,"-",2,"-","","","","","OK"]
["i37","Pattern Recognition (9 CFU, taught in Italian)",{"$f":"\"(\"&VALUE(MID(C76,2,LEN(C76)-2))+1&\")\"","v":"(9)"},9,"NO",2,"-",2,"-","","","","","OK"]
["i38","Pattern Recognition (6 CFU, taught in Italian)",{"$f":"C78","v":"(9)"},6,"NO",2,"-",2,"-","","","","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J72:J79)","v":0},{"$f":"SUM(K72:K79)","v":0},{"$f":"SUM(L72:L79)","v":0},{"$f":"SUM(M72:M79)","v":0}]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[{"$f":"C73","v":"(7)"},{"$f":"\"Choose at most one between \"&A73&\" and \"&A74","v":"Choose at most one between i32 and i33"},null,{"$f":"IF(AND(OR(E73=\"To Take\",E73=\"Taken\"),OR(E74=\"To Take\",E74=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"C76","v":"(8)"},{"$f":"\"Choose at most one between \"&A76&\" and \"&A77","v":"Choose at most one between i35 and i36"},null,{"$f":"IF(AND(OR(E76=\"To Take\",E76=\"Taken\"),OR(E77=\"To Take\",E77=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"C78","v":"(9)"},{"$f":"\"Choose at most one between \"&A78&\" and \"&A79","v":"Choose at most one between i37 and i38"},null,{"$f":"IF(AND(OR(E78=\"To Take\",E78=\"Taken\"),OR(E79=\"To Take\",E79=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"Open choice subjects",null,"CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A79,2,LEN(A79)-1))+1","v":"i39"},null,null,null,"NO",null,"-",null,"-",{"$f":"IF(I88<>\"X\",IF(E88=\"Taken\",D88,\"\"),\"\")","v":""},{"$f":"IF(I88<>\"X\",IF(E88=\"To Take\",D88,\"\"),\"\")","v":""},{"$f":"IF(I88=\"X\",IF(E88=\"Taken\",D88,\"\"),\"\")","v":""},{"$f":"IF(I88=\"X\",IF(E88=\"To Take\",D88,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(B88<>\"\",OR(D88=\"\",E88=\"NO\",G88=\"-\")),AND(B88=\"\",OR(D88<>\"\",E88<>\"NO\",G88<>\"-\"))),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A88,2,LEN(A88)-1))+1","v":"i40"},null,null,null,"NO",null,"-",null,"-","","","","","OK"]
["i41",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
["i42",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
["i43",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
["i44",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J88:J93)","v":0},{"$f":"SUM(K88:K93)","v":0},0,0]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[]
[null,"CFU AREA “SENSING AND COMMUNICATIONS”",null,{"$f":"SUM(J46:K46)","v":0}]
[null,"CFU AREA “SENSING AND COMM.” excess",null,{"$f":"SUM(L46:M46)","v":0}]
[]
[null,"CFU AREA “NETWORKS & SECURITY”",null,{"$f":"SUM(J64:K64)","v":0}]
[null,"CFU AREA “NETWORKS & SECURITY” excess",null,{"$f":"SUM(L64:M64)","v":0}]
[]
[null,"CFU AREA “DATA ANALYTICS & METHODOLOGIES”",null,{"$f":"SUM(J80:K80)","v":0}]
[null,"CFU AREA “DATA ANALYTICS...” excess",null,{"$f":"SUM(L80:M80)","v":0}]
[]
[null,"Total CFU open choice",null,{"$f":"SUM(J94:K94)","v":0}]
[null,"Total CFU open choice excess",null,{"$f":"SUM(L94:M94)","v":0}]
[]
[null,"Total CFU non mandatory subjects",null,{"$f":"SUM(J109:K109)","v":0},null,null,null,null,null,{"$f":"J46+J64+J80+J94","v":0},{"$f":"K46+K64+K80+K94","v":0},{"$f":"L46+L64+L80+L94","v":0},{"$f":"M46+M64+M80+M94","v":0}]
[null,"Total CFU non mandatory subjects excess",null,{"$f":"SUM(L109:M109)","v":0}]
[]
[]
[null,"Overall total",null,{"$f":"D30+D109","v":78}]
[null,"Overall total excess",null,{"$f":"D31+D110","v":0}]
[]
[null,"Totale generale crediti >= 120",null,{"$f":" IF(D113>=120,\"OK\", \"ERROR: total CFU < 120\")","v":"ERROR: total CFU < 120"}]
[null,"Totale generale crediti <= 123",null,{"$f":" IF(D113<=183,\"OK\", \"ERROR: numero crediti > 123\")","v":"OK"}]
[]
[]
[null,"Controllo totale numero errori",null,{"$f":"COUNTIF(N19:N28,E120)+COUNTIF(N88:N93,E120)+COUNTIF(D116:E117,E120)+COUNTIF(N53:N63,E120)+COUNTIF(N72:N79,E120)+COUNTIF(N37:N45,E120)+COUNTIF(D33:D33,E120)+COUNTIF(D48:D49,E120)+COUNTIF(D66:D68,E120)+COUNTIF(D82:D84,E120)","v":1},{"$f":"\"*\" & \"ERROR\" & \"*\"","v":"*ERROR*"}]
[null,"Risultato analisi del piano",null,{"$f":"IF(D120=0,\"THE STUDY PLAN IS FORMALLY CORRECT\",\"THE STUDY PLAN HAS SOME FORMAL ERRORS (\"&D120&\")\")","v":"THE STUDY PLAN HAS SOME FORMAL ERRORS (1)"}]

{"sheet":"models","index":2,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["THE LIST MUST BE SORTED !!!!"]
["-"]
["1) Base_model2021 - Generic model"]
["2) Base2021_with_suppl - Generic model with Supplementary Subjects"]
["3) Cybersec_2021 - Track \"Cybersecurity\""]
["4) Space_sys_2021 - Track \"Space Integrated Systems\""]
["5) Base_1819 - Generic model 2018/2019"]
["6) Base_1819_with_suppl - Generic 2018/2019 with Suppl. Subjects"]

{"sheet":"Base2021_with_suppl","index":3,"n_rows":136,"n_cols":14,"rows_kept":136,"cut":false,"hidden":false,"merged":[[135,3,135,6],[7,8,7,11],[8,8,8,11],[9,8,9,11],[10,8,10,11],[11,8,11,11],[12,8,12,11],[13,8,13,11],[10,2,10,6],[11,2,11,6],[13,2,13,4],[7,2,7,6],[8,2,8,6],[9,2,9,6],[1,1,1,11],[2,1,2,11],[131,3,131,4]]}
[]
[null,"Master's Degree \"ICT and Internet Engineering\" - Piano di studi 2020/21"]
[null,"Generic Model with Supplementary Subjects"]
[null,"Total CFU",{"$f":"D128","v":78},null,"Missing CFU",{"$f":"MAX(0,120-C4)","v":42}]
[null,"Excess CFU",{"$f":"D129","v":0},null,"Status",{"$f":"D136","v":"THE STUDY PLAN HAS SOME FORMAL ERRORS (1)"}]
[]
[]
[null,"Surname Name:",{"$f":"IF(MAIN_PAGE!C8=0,\"\",MAIN_PAGE!C8)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I8","v":"ERROR - Insert Surname Name"}]
[null,"Matricola (Student's ID):",{"$f":"IF(MAIN_PAGE!C9=0,\"\",MAIN_PAGE!C9)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I9","v":"ERROR - Insert Student's ID"}]
[null,"Fiscal Code:",{"$f":"IF(MAIN_PAGE!C10=0,\"\",MAIN_PAGE!C10)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I10","v":"ERROR - Insert Fiscal Code"}]
[null,"E-mail address:",{"$f":"IF(MAIN_PAGE!C11=0,\"\",MAIN_PAGE!C11)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I11","v":"ERROR - Insert e-mail address"}]
[null,"Phone:",{"$f":"IF(MAIN_PAGE!C12=0,\"\",MAIN_PAGE!C12)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I12","v":"ERROR - Insert Phone"}]
[null,"Course Year (I or II):",{"$f":"IF(MAIN_PAGE!C13=0,\"\",MAIN_PAGE!C13)","v":"-"},null,null,null,null,null,{"$f":"MAIN_PAGE!I13","v":"ERROR - Insert Course Year"}]
[null,"Regular year/Supplem. Year (fuori corso)",{"$f":"IF(MAIN_PAGE!C14=0,\"\",MAIN_PAGE!C14)","v":"-"},null,null,null,null,null,{"$f":"MAIN_PAGE!I14","v":"ERROR - Select Reg. or Supplem. Year"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"Mandatory subjects","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
["i1","Internet Technology and Protocols  (ex Networking and Internet Protocols) (9 CFU)","(1)",9,"To Take",1,1,1,"-",{"$f":"IF(I19<>\"X\",IF(E19=\"Taken\",D19,\"\"),\"\")","v":""},{"$f":"IF(I19<>\"X\",IF(E19=\"To Take\",D19,\"\"),\"\")","v":9},{"$f":"IF(I19=\"X\",IF(E19=\"Taken\",D19,\"\"),\"\")","v":""},{"$f":"IF(I19=\"X\",IF(E19=\"To Take\",D19,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(E19=\"NO\",G19<>\"-\"),AND(E19<>\"NO\",G19=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A19,2,LEN(A19)-1))+1","v":"i2"},"Internet Technology and Protocols  (ex Networking and Internet Protocols) (6 CFU)",{"$f":"C19","v":"(1)"},6,"NO",1,"-",1,"-","","","","","OK"]
["i3","Service-oriented Software Engineering",null,9,"To Take",1,1,1,"-","",9,"","","OK"]
["i4","Wireless Electromagnetic Technologies",null,9,"To Take",1,1,1,"-","",9,"","","OK"]
["i5","Digital Communications",null,6,"To Take",1,1,1,"-","",6,"","","OK"]
["i6","Mobile Wireless Networks",null,9,"To Take",1,1,2,"-","",9,"","","OK"]
["i7","Network Infrastructures",null,6,"To Take",1,1,2,"-","",6,"","","OK"]
["i8","Fundamentals of Radar and Localization",null,9,"To Take",1,1,2,"-","",9,"","","OK"]
["i9","Formative activities",null,3,"To Take",2,2,"-","-","",3,"","","OK"]
["i10","Prova finale",null,18,"To Take",2,2,"-","-","",18,"","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J19:J28)","v":0},{"$f":"SUM(K19:K28)","v":78},{"$f":"SUM(L19:L28)","v":0},{"$f":"SUM(M19:M28)","v":0}]
[null,"Total CFU mandatory subjects",null,{"$f":"SUM(J29:K29)","v":78},null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[null,"Total CFU mandatory subject (excess)",null,{"$f":"SUM(L29:M29)","v":0}]
[]
[{"$f":"C19","v":"(1)"},{"$f":"\"Choose one between \"&A19&\" and \"&A20","v":"Choose one between i1 and i2"},null,{"$f":"IF(_xlfn.XOR(OR(E19=\"To Take\",E19=\"Taken\"),OR(E20=\"To Take\",E20=\"Taken\")),\"OK\",\"ERROR\")","v":"OK"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"Supplementary subjects (*)","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A28,2,LEN(A28)-1))+1","v":"i11"},"Electromagnetic Fields",null,6,"NO",1,"-",1,"-",{"$f":"IF(I37<>\"X\",IF(E37=\"Taken\",D37,\"\"),\"\")","v":""},{"$f":"IF(I37<>\"X\",IF(E37=\"To Take\",D37,\"\"),\"\")","v":""},{"$f":"IF(I37=\"X\",IF(E37=\"Taken\",D37,\"\"),\"\")","v":""},{"$f":"IF(I37=\"X\",IF(E37=\"To Take\",D37,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(E37=\"NO\",G37<>\"-\"),AND(E37<>\"NO\",G37=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A37,2,LEN(A37)-1))+1","v":"i12"},"Fundamentals of Telecommunications",{"$f":"\"(\"&VALUE(MID(C19,2,LEN(C19)-2))+1&\")\"","v":"(2)"},9,"NO",1,"-",2,"-",{"$f":"IF(I38<>\"X\",IF(E38=\"Taken\",D38,\"\"),\"\")","v":""},{"$f":"IF(I38<>\"X\",IF(E38=\"To Take\",D38,\"\"),\"\")","v":""},{"$f":"IF(I38=\"X\",IF(E38=\"Taken\",D38,\"\"),\"\")","v":""},{"$f":"IF(I38=\"X\",IF(E38=\"To Take\",D38,\"\"),\"\")","v":""},"OK"]
[{"$f":"\"i\"&VALUE(MID(A38,2,LEN(A38)-1))+1","v":"i13"},"Fundamentals of Telecommunications",{"$f":"C38","v":"(2)"},6,"NO",1,"-",2,"-",{"$f":"IF(I39<>\"X\",IF(E39=\"Taken\",D39,\"\"),\"\")","v":""},{"$f":"IF(I39<>\"X\",IF(E39=\"To Take\",D39,\"\"),\"\")","v":""},{"$f":"IF(I39=\"X\",IF(E39=\"Taken\",D39,\"\"),\"\")","v":""},{"$f":"IF(I39=\"X\",IF(E39=\"To Take\",D39,\"\"),\"\")","v":""},"OK"]
[{"$f":"\"i\"&VALUE(MID(A39,2,LEN(A39)-1))+1","v":"i14"},"Networking and Internet",null,9,"NO",1,"-",2,"-",{"$f":"IF(I40<>\"X\",IF(E40=\"Taken\",D40,\"\"),\"\")","v":""},{"$f":"IF(I40<>\"X\",IF(E40=\"To Take\",D40,\"\"),\"\")","v":""},{"$f":"IF(I40=\"X\",IF(E40=\"Taken\",D40,\"\"),\"\")","v":""},{"$f":"IF(I40=\"X\",IF(E40=\"To Take\",D40,\"\"),\"\")","v":""},"OK"]
[{"$f":"\"i\"&VALUE(MID(A40,2,LEN(A40)-1))+1","v":"i15"},"Digital Signal Processing",null,6,"NO",1,"-",2,"-",{"$f":"IF(I41<>\"X\",IF(E41=\"Taken\",D41,\"\"),\"\")","v":""},{"$f":"IF(I41<>\"X\",IF(E41=\"To Take\",D41,\"\"),\"\")","v":""},{"$f":"IF(I41=\"X\",IF(E41=\"Taken\",D41,\"\"),\"\")","v":""},{"$f":"IF(I41=\"X\",IF(E41=\"To Take\",D41,\"\"),\"\")","v":""},"OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J37:J41)","v":0},{"$f":"SUM(K37:K41)","v":0},{"$f":"SUM(L37:L41)","v":0},{"$f":"SUM(M37:M41)","v":0}]
[null,"Total CFU supplementary subjects",null,{"$f":"SUM(J42:K42)","v":0},null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[null,"Total CFU supplementary subject (excess)",null,{"$f":"SUM(L42:M42)","v":0}]
[]
["(*)","SUPPLEMENTARY SUBJECTS: for credit recovery need only (students coming from other Courses, missing know-how in one or more areas)"]
[{"$f":"C38","v":"(2)"},{"$f":"\"Choose at most one between \"&A37&\" and \"&A38","v":"Choose at most one between i11 and i12"},null,{"$f":"IF(AND(OR(E38=\"To Take\",E38=\"Taken\"),OR(E39=\"To Take\",E39=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"AREA “SENSING AND COMMUNICATIONS”","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A41,2,LEN(A41)-1))+1","v":"i16"},"Satellite Navigation and Surveillance Systems (9 CFU)",{"$f":"\"(\"&VALUE(MID(C38,2,LEN(C38)-2))+1&\")\"","v":"(3)"},9,"NO",2,"-",1,"-",{"$f":"IF(I52<>\"X\",IF(E52=\"Taken\",D52,\"\"),\"\")","v":""},{"$f":"IF(I52<>\"X\",IF(E52=\"To Take\",D52,\"\"),\"\")","v":""},{"$f":"IF(I52=\"X\",IF(E52=\"Taken\",D52,\"\"),\"\")","v":""},{"$f":"IF(I52=\"X\",IF(E52=\"To Take\",D52,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(E52=\"NO\",G52<>\"-\"),AND(E52<>\"NO\",G52=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A52,2,LEN(A52)-1))+1","v":"i17"},"Satellite Navigation and Surveillance Systems (6 CFU)",{"$f":"C52","v":"(3)"},6,"NO",2,"-",1,"-","","","","","OK"]
[{"$f":"\"i\"&VALUE(MID(A53,2,LEN(A53)-1))+1","v":"i18"},"Internet Via Satellite",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i19","Radar Systems and Applications ",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i20","Satellite Earth Observation (9 CFU)",{"$f":"\"(\"&VALUE(MID(C52,2,LEN(C52)-2))+1&\")\"","v":"(4)"},9,"NO","1 o 2","-",2,"-","","","","","OK"]
["i21","Satellite Earth Observation (6 CFU)",{"$f":"C56","v":"(4)"},6,"NO","1 o 2","-",2,"-","","","","","OK"]
["i22","Radiowave Propagation",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i23","Microwaves",null,6,"NO",2,"-",2,"-","","","","","OK"]
["i24","Optical Communications",null,6,"NO",2,"-",1,"-","","","","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J52:J60)","v":0},{"$f":"SUM(K52:K60)","v":0},{"$f":"SUM(L52:L60)","v":0},{"$f":"SUM(M52:M60)","v":0}]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[{"$f":"C52","v":"(3)"},{"$f":"\"Choose at most one between \"&A52&\" and \"&A53","v":"Choose at most one between i16 and i17"},null,{"$f":"IF(AND(OR(E52=\"To Take\",E52=\"Taken\"),OR(E53=\"To Take\",E53=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"C56","v":"(4)"},{"$f":"\"Choose at most one between \"&A56&\" and \"&A57","v":"Choose at most one between i20 and i21"},null,{"$f":"IF(AND(OR(E56=\"To Take\",E56=\"Taken\"),OR(E57=\"To Take\",E57=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"AREA “NETWORKS & SECURITY”","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A60,2,LEN(A60)-1))+1","v":"i25"},"Network Security (9 CFU)",{"$f":"\"(\"&VALUE(MID(C56,2,LEN(C56)-2))+1&\")\"","v":"(5)"},9,"NO",2,"-",1,"-",{"$f":"IF(I68<>\"X\",IF(E68=\"Taken\",D68,\"\"),\"\")","v":""},{"$f":"IF(I68<>\"X\",IF(E68=\"To Take\",D68,\"\"),\"\")","v":""},{"$f":"IF(I68=\"X\",IF(E68=\"Taken\",D68,\"\"),\"\")","v":""},{"$f":"IF(I68=\"X\",IF(E68=\"To Take\",D68,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(E68=\"NO\",G68<>\"-\"),AND(E68<>\"NO\",G68=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A68,2,LEN(A68)-1))+1","v":"i26"},"Network Security (6 CFU)",{"$f":"C68","v":"(5)"},6,"NO",2,"-",1,"-","","","","","OK"]
[{"$f":"\"i\"&VALUE(MID(A69,2,LEN(A69)-1))+1","v":"i27"},"Enterprise Networks",{"$f":"\"(\"&VALUE(MID(C68,2,LEN(C68)-2))+1&\")\"","v":"(6)"},6,"NO",2,"-",1,"-","","","","","OK"]
["i28","Networks and Systems Defence",{"$f":"C70","v":"(6)"},6,"NO",2,"-",1,"-","","","","","OK"]
[{"$f":"\"i\"&VALUE(MID(A71,2,LEN(A71)-1))+1","v":"i29"},"Cloud Computing and Networking",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i30","Hardware, Electromagnetic and Localizion Security",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i31","Multimedia Processing and Communication",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i32","Internet Services Performance (9 CFU)",{"$f":"\"(\"&VALUE(MID(C70,2,LEN(C70)-2))+1&\")\"","v":"(7)"},9,"NO",2,"-",1,"-","","","","","OK"]
["i33","Internet Services Performance (6 CFU)",{"$f":"C75","v":"(7)"},6,"NO",2,"-",1,"-","","","","","OK"]
["i34","Internet of Things: Principles and Applications ",null,6,"NO",2,"-",2,"-","","","","","OK"]
["i35","Internet-based Distributed Simulation",null,6,"NO",2,"-",2,"-","","","","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J68:J78)","v":0},{"$f":"SUM(K68:K78)","v":0},0,0]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[{"$f":"C68","v":"(5)"},{"$f":"\"Choose at most one between \"&A68&\" and \"&A69","v":"Choose at most one between i25 and i26"},null,{"$f":"IF(AND(OR(E68=\"To Take\",E68=\"Taken\"),OR(E69=\"To Take\",E69=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"C70","v":"(6)"},{"$f":"\"Choose at most one between \"&A70&\" and \"&A71","v":"Choose at most one between i27 and i28"},null,{"$f":"IF(AND(OR(E70=\"To Take\",E70=\"Taken\"),OR(E71=\"To Take\",E71=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"C75","v":"(7)"},{"$f":"\"Choose at most one between \"&A75&\" and \"&A76","v":"Choose at most one between i32 and i33"},null,{"$f":"IF(AND(OR(E75=\"To Take\",E75=\"Taken\"),OR(E76=\"To Take\",E76=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"AREA “DATA ANALYTICS & METHODOLOGIES”","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A78,2,LEN(A78)-1))+1","v":"i36"},"Information Theory and Data Mining",null,6,"NO",2,"-",1,"-",{"$f":"IF(I87<>\"X\",IF(E87=\"Taken\",D87,\"\"),\"\")","v":""},{"$f":"IF(I87<>\"X\",IF(E87=\"To Take\",D87,\"\"),\"\")","v":""},{"$f":"IF(I87=\"X\",IF(E87=\"Taken\",D87,\"\"),\"\")","v":""},{"$f":"IF(I87=\"X\",IF(E87=\"To Take\",D87,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(E87=\"NO\",G87<>\"-\"),AND(E87<>\"NO\",G87=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A87,2,LEN(A87)-1))+1","v":"i37"},"Operations Research Methods for Network Optimization (taught in Italian)",{"$f":"\"(\"&VALUE(MID(C75,2,LEN(C75)-2))+1&\")\"","v":"(8)"},9,"NO",2,"-",1,"-","","","","","OK"]
["i38","Operations Research Methods for Network Optimization (taught in Italian)",{"$f":"C88","v":"(8)"},6,"NO",2,"-",1,"-","","","","","OK"]
["i39","Optimization Methods for Big Data (taught in Italian)",null,6,"NO",2,"-",2,"-","","","","","OK"]
["i40","Web Mining and Retrieval",{"$f":"\"(\"&VALUE(MID(C88,2,LEN(C88)-2))+1&\")\"","v":"(9)"},9,"NO",2,"-",2,"-","","","","","OK"]
["i41","Web Mining and Retrieval",{"$f":"C91","v":"(9)"},6,"NO",2,"-",2,"-","","","","","OK"]
["i42","Pattern Recognition (taught in Italian)",{"$f":"\"(\"&VALUE(MID(C91,2,LEN(C91)-2))+1&\")\"","v":"(10)"},9,"NO",2,"-",2,"-","","","","","OK"]
["i43","Pattern Recognition (taught in Italian)",{"$f":"C93","v":"(10)"},6,"NO",2,"-",2,"-","","","","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J87:J94)","v":0},{"$f":"SUM(K87:K94)","v":0},{"$f":"SUM(L87:L94)","v":0},{"$f":"SUM(M87:M94)","v":0}]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[{"$f":"C88","v":"(8)"},{"$f":"\"Choose at most one between \"&A88&\" and \"&A89","v":"Choose at most one between i37 and i38"},null,{"$f":"IF(AND(OR(E88=\"To Take\",E88=\"Taken\"),OR(E89=\"To Take\",E89=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"C91","v":"(9)"},{"$f":"\"Choose at most one between \"&A91&\" and \"&A92","v":"Choose at most one between i40 and i41"},null,{"$f":"IF(AND(OR(E91=\"To Take\",E91=\"Taken\"),OR(E92=\"To Take\",E92=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"C93","v":"(10)"},{"$f":"\"Choose at most one between \"&A93&\" and \"&A94","v":"Choose at most one between i42 and i43"},null,{"$f":"IF(AND(OR(E93=\"To Take\",E93=\"Taken\"),OR(E94=\"To Take\",E94=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"Open choice subjects",null,"CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A94,2,LEN(A94)-1))+1","v":"i44"},null,null,null,"NO",null,"-",null,"-",{"$f":"IF(I103<>\"X\",IF(E103=\"Taken\",D103,\"\"),\"\")","v":""},{"$f":"IF(I103<>\"X\",IF(E103=\"To Take\",D103,\"\"),\"\")","v":""},{"$f":"IF(I103=\"X\",IF(E103=\"Taken\",D103,\"\"),\"\")","v":""},{"$f":"IF(I103=\"X\",IF(E103=\"To Take\",D103,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(B103<>\"\",OR(D103=\"\",E103=\"NO\",G103=\"-\")),AND(B103=\"\",OR(D103<>\"\",E103<>\"NO\",G103<>\"-\"))),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A103,2,LEN(A103)-1))+1","v":"i45"},null,null,null,"NO",null,"-",null,"-","","","","","OK"]
["i46",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
["i47",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
["i48",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
["i49",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J103:J108)","v":0},{"$f":"SUM(K103:K108)","v":0},0,0]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[]
[null,"CFU AREA “SENSING AND COMMUNICATIONS”",null,{"$f":"SUM(J61:K61)","v":0}]
[null,"CFU AREA “SENSING AND COMM.” excess",null,{"$f":"SUM(L61:M61)","v":0}]
[]
[null,"CFU AREA “NETWORKS & SECURITY”",null,{"$f":"SUM(J79:K79)","v":0}]
[null,"CFU AREA “NETWORKS & SECURITY” excess",null,{"$f":"SUM(L79:M79)","v":0}]
[]
[null,"CFU AREA “DATA ANALYTICS & METHODOLOGIES”",null,{"$f":"SUM(J95:K95)","v":0}]
[null,"CFU AREA “DATA ANALYTICS...” excess",null,{"$f":"SUM(L95:M95)","v":0}]
[]
[null,"Total CFU open choice",null,{"$f":"SUM(J109:K109)","v":0}]
[null,"Total CFU open choice excess",null,{"$f":"SUM(L109:M109)","v":0}]
[]
[null,"Total CFU non mandatory subjects",null,{"$f":"SUM(J124:K124)","v":0},null,null,null,null,null,{"$f":"J61+J79+J95+J109","v":0},{"$f":"K61+K79+K95+K109","v":0},{"$f":"L61+L79+L95+L109","v":0},{"$f":"M61+M79+M95+M109","v":0}]
[null,"Total CFU non mandatory subjects excess",null,{"$f":"SUM(L124:M124)","v":0}]
[]
[]
[null,"Overall total",null,{"$f":"D30+D124+D43","v":78}]
[null,"Overall total excess",null,{"$f":"D31+D125+D44","v":0}]
[]
[null,"Totale generale crediti >= 120",null,{"$f":" IF(D128>=120,\"OK\", \"ERROR: total CFU < 120\")","v":"ERROR: total CFU < 120"}]
[null,"Totale generale crediti <= 123",null,{"$f":" IF(D128<=183,\"OK\", \"ERROR: numero crediti > 123\")","v":"OK"}]
[]
[]
[null,"Controllo totale numero errori",null,{"$f":"COUNTIF(N19:N28,E135)+COUNTIF(N103:N108,E135)+COUNTIF(D131:E132,E135)+COUNTIF(N68:N78,E135)+COUNTIF(N87:N94,E135)+COUNTIF(N52:N60,E135)+COUNTIF(D33,E135)+COUNTIF(D63:D64,E135)+COUNTIF(D81:D83,E135)+COUNTIF(D97:D99,E135)+COUNTIF(N37:N41,E135)+COUNTIF(D47,E135)","v":1},{"$f":"\"*\" & \"ERROR\" & \"*\"","v":"*ERROR*"}]
[null,"Risultato analisi del piano",null,{"$f":"IF(D135=0,\"THE STUDY PLAN IS FORMALLY CORRECT\",\"THE STUDY PLAN HAS SOME FORMAL ERRORS (\"&D135&\")\")","v":"THE STUDY PLAN HAS SOME FORMAL ERRORS (1)"}]

{"sheet":"Cybersec_2021","index":4,"n_rows":112,"n_cols":14,"rows_kept":112,"cut":false,"hidden":false,"merged":[[111,3,111,6],[7,8,7,11],[8,8,8,11],[9,8,9,11],[10,8,10,11],[11,8,11,11],[12,8,12,11],[13,8,13,11],[10,2,10,6],[11,2,11,6],[13,2,13,4],[7,2,7,6],[8,2,8,6],[9,2,9,6],[1,1,1,11],[2,1,2,11],[107,3,107,4]]}
[]
[null,"Master's Degree \"ICT and Internet Engineering\" - Piano di studi 2020/21"]
[null,"Cybersecurity Track"]
[null,"Total CFU",{"$f":"D104","v":114},null,"Missing CFU",{"$f":"MAX(0,120-C4)","v":6}]
[null,"Excess CFU",{"$f":"D105","v":0},null,"Status",{"$f":"D112","v":"THE STUDY PLAN HAS SOME FORMAL ERRORS (1)"}]
[]
[]
[null,"Surname Name:",{"$f":"IF(MAIN_PAGE!C8=0,\"\",MAIN_PAGE!C8)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I8","v":"ERROR - Insert Surname Name"}]
[null,"Matricola (Student's ID):",{"$f":"IF(MAIN_PAGE!C9=0,\"\",MAIN_PAGE!C9)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I9","v":"ERROR - Insert Student's ID"}]
[null,"Fiscal Code:",{"$f":"IF(MAIN_PAGE!C10=0,\"\",MAIN_PAGE!C10)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I10","v":"ERROR - Insert Fiscal Code"}]
[null,"E-mail address:",{"$f":"IF(MAIN_PAGE!C11=0,\"\",MAIN_PAGE!C11)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I11","v":"ERROR - Insert e-mail address"}]
[null,"Phone:",{"$f":"IF(MAIN_PAGE!C12=0,\"\",MAIN_PAGE!C12)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I12","v":"ERROR - Insert Phone"}]
[null,"Course Year (I or II):",{"$f":"IF(MAIN_PAGE!C13=0,\"\",MAIN_PAGE!C13)","v":"-"},null,null,null,null,null,{"$f":"MAIN_PAGE!I13","v":"ERROR - Insert Course Year"}]
[null,"Regular year/Supplem. Year (fuori corso)",{"$f":"IF(MAIN_PAGE!C14=0,\"\",MAIN_PAGE!C14)","v":"-"},null,null,null,null,null,{"$f":"MAIN_PAGE!I14","v":"ERROR - Select Reg. or Supplem. Year"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"Mandatory subjects","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
["i1","Internet Technology and Protocols  (ex Networking and Internet Protocols) (9 CFU)","(1)",9,"To Take",1,1,1,"-",{"$f":"IF(I19<>\"X\",IF(E19=\"Taken\",D19,\"\"),\"\")","v":""},{"$f":"IF(I19<>\"X\",IF(E19=\"To Take\",D19,\"\"),\"\")","v":9},{"$f":"IF(I19=\"X\",IF(E19=\"Taken\",D19,\"\"),\"\")","v":""},{"$f":"IF(I19=\"X\",IF(E19=\"To Take\",D19,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(E19=\"NO\",G19<>\"-\"),AND(E19<>\"NO\",G19=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A19,2,LEN(A19)-1))+1","v":"i2"},"Internet Technology and Protocols  (ex Networking and Internet Protocols) (6 CFU)",{"$f":"C19","v":"(1)"},6,"NO",1,"-",1,"-","","","","","OK"]
["i3","Service-oriented Software Engineering",null,9,"To Take",1,1,1,"-","",9,"","","OK"]
["i4","Wireless Electromagnetic Technologies",null,9,"To Take",1,1,1,"-","",9,"","","OK"]
["i5","Digital Communications",null,6,"To Take",1,1,1,"-","",6,"","","OK"]
["i6","Mobile Wireless Networks",null,9,"To Take",1,1,2,"-","",9,"","","OK"]
["i7","Network Infrastructures",null,6,"To Take",1,1,2,"-","",6,"","","OK"]
["i8","Fundamentals of Radar and Localization",null,9,"To Take",1,1,2,"-","",9,"","","OK"]
["i9","Formative activities",null,3,"To Take",2,2,"-","-","",3,"","","OK"]
["i10","Prova finale",null,18,"To Take",2,2,"-","-","",18,"","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J19:J28)","v":0},{"$f":"SUM(K19:K28)","v":78},{"$f":"SUM(L19:L28)","v":0},{"$f":"SUM(M19:M28)","v":0}]
[null,"Total CFU mandatory subjects",null,{"$f":"SUM(J29:K29)","v":78},null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[null,"Total CFU mandatory subject (excess)",null,{"$f":"SUM(L29:M29)","v":0}]
[]
[{"$f":"C19","v":"(1)"},{"$f":"\"Choose one between \"&A19&\" and \"&A20","v":"Choose one between i1 and i2"},null,{"$f":"IF(_xlfn.XOR(OR(E19=\"To Take\",E19=\"Taken\"),OR(E20=\"To Take\",E20=\"Taken\")),\"OK\",\"ERROR\")","v":"OK"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"Cybersecurity Track suggested subjects ","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A28,2,LEN(A28)-1))+1","v":"i11"},"Network Security (9 CFU)",{"$f":"\"(\"&VALUE(MID(C19,2,LEN(C19)-2))+1&\")\"","v":"(2)"},9,"To Take",2,2,1,"-",{"$f":"IF(I37<>\"X\",IF(E37=\"Taken\",D37,\"\"),\"\")","v":""},{"$f":"IF(I37<>\"X\",IF(E37=\"To Take\",D37,\"\"),\"\")","v":9},{"$f":"IF(I37=\"X\",IF(E37=\"Taken\",D37,\"\"),\"\")","v":""},{"$f":"IF(I37=\"X\",IF(E37=\"To Take\",D37,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(E37=\"NO\",G37<>\"-\"),AND(E37<>\"NO\",G37=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A37,2,LEN(A37)-1))+1","v":"i12"},"Network Security (6 CFU)",{"$f":"C37","v":"(2)"},6,"NO",2,"-",1,"-","","","","","OK"]
["i13","Networks and Systems Defence (9 CFU)",{"$f":"\"(\"&VALUE(MID(C37,2,LEN(C37)-2))+1&\")\"","v":"(3)"},9,"To Take",2,2,1,"-","",9,"","",{"$f":"IF(OR(AND(E39=\"NO\",G39<>\"-\"),AND(E39<>\"NO\",G39=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
["i14","Networks and Systems Defence (6 CFU)",{"$f":"C39","v":"(3)"},6,"NO",2,"-",1,"-","","","","","OK"]
["i15","Hardware, Electromagnetic and Localizion Security",null,6,"To Take",2,2,1,"-","",6,"","","OK"]
["i16","Sistemi operativi avanzati (taught in italian)",null,6,"To Take",2,2,2,"-","",6,"","","OK"]
["i17","Malware analysis (taught in italian)",null,6,"To Take",2,2,2,"-","",6,"","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J37:J43)","v":0},{"$f":"SUM(K37:K43)","v":36},{"$f":"SUM(L37:L43)","v":0},{"$f":"SUM(M37:M43)","v":0}]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[{"$f":"C37","v":"(2)"},{"$f":"\"Choose at most one between \"&A37&\" and \"&A38","v":"Choose at most one between i11 and i12"},null,{"$f":"IF(AND(OR(E37=\"To Take\",E37=\"Taken\"),OR(E38=\"To Take\",E38=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"C39","v":"(3)"},{"$f":"\"Choose at most one between \"&A39&\" and \"&A40","v":"Choose at most one between i13 and i14"},null,{"$f":"IF(AND(OR(E39=\"To Take\",E39=\"Taken\"),OR(E40=\"To Take\",E40=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"Subjects from Networking Area","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A42,2,LEN(A42)-1))+1","v":"i17"},"-",null,{"$f":"LOOKUP(B51,opt_netw_and_sec_4_cyber!$A$2:$A$9, opt_netw_and_sec_4_cyber!$D$2:$D$9)","v":"-"},"NO",{"$f":"LOOKUP(B51,opt_netw_and_sec_4_cyber!$A$2:$A$9, opt_netw_and_sec_4_cyber!$B$2:$B$9)","v":"-"},"-",{"$f":"LOOKUP(B51,opt_netw_and_sec_4_cyber!$A$2:$A$9, opt_netw_and_sec_4_cyber!$C$2:$C$9)","v":"-"},"-",{"$f":"IF(I51<>\"X\",IF(E51=\"Taken\",D51,\"\"),\"\")","v":""},{"$f":"IF(I51<>\"X\",IF(E51=\"To Take\",D51,\"\"),\"\")","v":""},{"$f":"IF(I51=\"X\",IF(E51=\"Taken\",D51,\"\"),\"\")","v":""},{"$f":"IF(I51=\"X\",IF(E51=\"To Take\",D51,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(B51<>\"-\",OR(E51=\"NO\",G51=\"-\")),AND(B51=\"-\",OR(E51<>\"NO\",G51<>\"-\"))),\"ERRORE\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A51,2,LEN(A51)-1))+1","v":"i18"},"-",null,{"$f":"LOOKUP(B52,opt_netw_and_sec_4_cyber!$A$2:$A$9, opt_netw_and_sec_4_cyber!$D$2:$D$9)","v":"-"},"NO",{"$f":"LOOKUP(B52,opt_netw_and_sec_4_cyber!$A$2:$A$9, opt_netw_and_sec_4_cyber!$B$2:$B$9)","v":"-"},"-",{"$f":"LOOKUP(B52,opt_netw_and_sec_4_cyber!$A$2:$A$9, opt_netw_and_sec_4_cyber!$C$2:$C$9)","v":"-"},"-",{"$f":"IF(I52<>\"X\",IF(E52=\"Taken\",D52,\"\"),\"\")","v":""},{"$f":"IF(I52<>\"X\",IF(E52=\"To Take\",D52,\"\"),\"\")","v":""},{"$f":"IF(I52=\"X\",IF(E52=\"Taken\",D52,\"\"),\"\")","v":""},{"$f":"IF(I52=\"X\",IF(E52=\"To Take\",D52,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(B52<>\"-\",OR(E52=\"NO\",G52=\"-\")),AND(B52=\"-\",OR(E52<>\"NO\",G52<>\"-\"))),\"ERRORE\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A52,2,LEN(A52)-1))+1","v":"i19"},"-",null,{"$f":"LOOKUP(B53,opt_netw_and_sec_4_cyber!$A$2:$A$9, opt_netw_and_sec_4_cyber!$D$2:$D$9)","v":"-"},"NO",{"$f":"LOOKUP(B53,opt_netw_and_sec_4_cyber!$A$2:$A$9, opt_netw_and_sec_4_cyber!$B$2:$B$9)","v":"-"},"-",{"$f":"LOOKUP(B53,opt_netw_and_sec_4_cyber!$A$2:$A$9, opt_netw_and_sec_4_cyber!$C$2:$C$9)","v":"-"},"-",{"$f":"IF(I53<>\"X\",IF(E53=\"Taken\",D53,\"\"),\"\")","v":""},{"$f":"IF(I53<>\"X\",IF(E53=\"To Take\",D53,\"\"),\"\")","v":""},{"$f":"IF(I53=\"X\",IF(E53=\"Taken\",D53,\"\"),\"\")","v":""},{"$f":"IF(I53=\"X\",IF(E53=\"To Take\",D53,\"\"),\"\")","v":""},"OK"]
["i20","-",null,{"$f":"LOOKUP(B54,opt_netw_and_sec_4_cyber!$A$2:$A$9, opt_netw_and_sec_4_cyber!$D$2:$D$9)","v":"-"},"NO",{"$f":"LOOKUP(B54,opt_netw_and_sec_4_cyber!$A$2:$A$9, opt_netw_and_sec_4_cyber!$B$2:$B$9)","v":"-"},"-",{"$f":"LOOKUP(B54,opt_netw_and_sec_4_cyber!$A$2:$A$9, opt_netw_and_sec_4_cyber!$C$2:$C$9)","v":"-"},"-",{"$f":"IF(I54<>\"X\",IF(E54=\"Taken\",D54,\"\"),\"\")","v":""},{"$f":"IF(I54<>\"X\",IF(E54=\"To Take\",D54,\"\"),\"\")","v":""},{"$f":"IF(I54=\"X\",IF(E54=\"Taken\",D54,\"\"),\"\")","v":""},{"$f":"IF(I54=\"X\",IF(E54=\"To Take\",D54,\"\"),\"\")","v":""},"OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J51:J54)","v":0},{"$f":"SUM(K51:K54)","v":0},{"$f":"SUM(L51:L54)","v":0},{"$f":"SUM(M51:M54)","v":0}]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"Subjects from Sensing and Communications Area","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A54,2,LEN(A54)-1))+1","v":"i21"},"-",null,{"$f":"LOOKUP(B59,opt_sens_commun!$A$2:$A$11, opt_sens_commun!$D$2:$D$11)","v":"-"},"NO",{"$f":"LOOKUP(B59,opt_sens_commun!$A$2:$A$11, opt_sens_commun!$B$2:$B$11)","v":"-"},"-",{"$f":"LOOKUP(B59,opt_sens_commun!$A$2:$A$11, opt_sens_commun!$C$2:$C$11)","v":"-"},"-",{"$f":"IF(I59<>\"X\",IF(E59=\"Taken\",D59,\"\"),\"\")","v":""},{"$f":"IF(I59<>\"X\",IF(E59=\"To Take\",D59,\"\"),\"\")","v":""},{"$f":"IF(I59=\"X\",IF(E59=\"Taken\",D59,\"\"),\"\")","v":""},{"$f":"IF(I59=\"X\",IF(E59=\"To Take\",D59,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(B59<>\"-\",OR(E59=\"NO\",G59=\"-\")),AND(B59=\"-\",OR(E59<>\"NO\",G59<>\"-\"))),\"ERRORE\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A59,2,LEN(A59)-1))+1","v":"i22"},"-",null,{"$f":"LOOKUP(B60,opt_sens_commun!$A$2:$A$11, opt_sens_commun!$D$2:$D$11)","v":"-"},"NO",{"$f":"LOOKUP(B60,opt_sens_commun!$A$2:$A$11, opt_sens_commun!$B$2:$B$11)","v":"-"},"-",{"$f":"LOOKUP(B60,opt_sens_commun!$A$2:$A$11, opt_sens_commun!$C$2:$C$11)","v":"-"},"-",{"$f":"IF(I60<>\"X\",IF(E60=\"Taken\",D60,\"\"),\"\")","v":""},{"$f":"IF(I60<>\"X\",IF(E60=\"To Take\",D60,\"\"),\"\")","v":""},{"$f":"IF(I60=\"X\",IF(E60=\"Taken\",D60,\"\"),\"\")","v":""},{"$f":"IF(I60=\"X\",IF(E60=\"To Take\",D60,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(B60<>\"-\",OR(E60=\"NO\",G60=\"-\")),AND(B60=\"-\",OR(E60<>\"NO\",G60<>\"-\"))),\"ERRORE\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A60,2,LEN(A60)-1))+1","v":"i23"},"-",null,{"$f":"LOOKUP(B61,opt_sens_commun!$A$2:$A$11, opt_sens_commun!$D$2:$D$11)","v":"-"},"NO",{"$f":"LOOKUP(B61,opt_sens_commun!$A$2:$A$11, opt_sens_commun!$B$2:$B$11)","v":"-"},"-",{"$f":"LOOKUP(B61,opt_sens_commun!$A$2:$A$11, opt_sens_commun!$C$2:$C$11)","v":"-"},"-",{"$f":"IF(I61<>\"X\",IF(E61=\"Taken\",D61,\"\"),\"\")","v":""},{"$f":"IF(I61<>\"X\",IF(E61=\"To Take\",D61,\"\"),\"\")","v":""},{"$f":"IF(I61=\"X\",IF(E61=\"Taken\",D61,\"\"),\"\")","v":""},{"$f":"IF(I61=\"X\",IF(E61=\"To Take\",D61,\"\"),\"\")","v":""},"OK"]
["i24","-",null,{"$f":"LOOKUP(B62,opt_sens_commun!$A$2:$A$11, opt_sens_commun!$D$2:$D$11)","v":"-"},"NO",{"$f":"LOOKUP(B62,opt_sens_commun!$A$2:$A$11, opt_sens_commun!$B$2:$B$11)","v":"-"},"-",{"$f":"LOOKUP(B62,opt_sens_commun!$A$2:$A$11, opt_sens_commun!$C$2:$C$11)","v":"-"},"-",{"$f":"IF(I62<>\"X\",IF(E62=\"Taken\",D62,\"\"),\"\")","v":""},{"$f":"IF(I62<>\"X\",IF(E62=\"To Take\",D62,\"\"),\"\")","v":""},{"$f":"IF(I62=\"X\",IF(E62=\"Taken\",D62,\"\"),\"\")","v":""},{"$f":"IF(I62=\"X\",IF(E62=\"To Take\",D62,\"\"),\"\")","v":""},"OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J59:J62)","v":0},{"$f":"SUM(K59:K62)","v":0},{"$f":"SUM(L59:L62)","v":0},{"$f":"SUM(M59:M62)","v":0}]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"Subjects from Data Analysis Area","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A62,2,LEN(A62)-1))+1","v":"i25"},"-",null,{"$f":"LOOKUP(B67,opt_data_anal!$A$2:$A$10, opt_data_anal!$D$2:$D$10)","v":"-"},"NO",{"$f":"LOOKUP(B67,opt_data_anal!$A$2:$A$10, opt_data_anal!$B$2:$B$10)","v":"-"},"-",{"$f":"LOOKUP(B67,opt_data_anal!$A$2:$A$10, opt_data_anal!$C$2:$C$10)","v":"-"},"-",{"$f":"IF(I67<>\"X\",IF(E67=\"Taken\",D67,\"\"),\"\")","v":""},{"$f":"IF(I67<>\"X\",IF(E67=\"To Take\",D67,\"\"),\"\")","v":""},{"$f":"IF(I67=\"X\",IF(E67=\"Taken\",D67,\"\"),\"\")","v":""},{"$f":"IF(I67=\"X\",IF(E67=\"To Take\",D67,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(B67<>\"-\",OR(E67=\"NO\",G67=\"-\")),AND(B67=\"-\",OR(E67<>\"NO\",G67<>\"-\"))),\"ERRORE\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A67,2,LEN(A67)-1))+1","v":"i26"},"-",null,{"$f":"LOOKUP(B68,opt_data_anal!$A$2:$A$10, opt_data_anal!$D$2:$D$10)","v":"-"},"NO",{"$f":"LOOKUP(B68,opt_data_anal!$A$2:$A$10, opt_data_anal!$B$2:$B$10)","v":"-"},"-",{"$f":"LOOKUP(B68,opt_data_anal!$A$2:$A$10, opt_data_anal!$C$2:$C$10)","v":"-"},"-",{"$f":"IF(I68<>\"X\",IF(E68=\"Taken\",D68,\"\"),\"\")","v":""},{"$f":"IF(I68<>\"X\",IF(E68=\"To Take\",D68,\"\"),\"\")","v":""},{"$f":"IF(I68=\"X\",IF(E68=\"Taken\",D68,\"\"),\"\")","v":""},{"$f":"IF(I68=\"X\",IF(E68=\"To Take\",D68,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(B68<>\"-\",OR(E68=\"NO\",G68=\"-\")),AND(B68=\"-\",OR(E68<>\"NO\",G68<>\"-\"))),\"ERRORE\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A68,2,LEN(A68)-1))+1","v":"i27"},"-",null,{"$f":"LOOKUP(B69,opt_data_anal!$A$2:$A$10, opt_data_anal!$D$2:$D$10)","v":"-"},"NO",{"$f":"LOOKUP(B69,opt_data_anal!$A$2:$A$10, opt_data_anal!$B$2:$B$10)","v":"-"},"-",{"$f":"LOOKUP(B69,opt_data_anal!$A$2:$A$10, opt_data_anal!$C$2:$C$10)","v":"-"},"-",{"$f":"IF(I69<>\"X\",IF(E69=\"Taken\",D69,\"\"),\"\")","v":""},{"$f":"IF(I69<>\"X\",IF(E69=\"To Take\",D69,\"\"),\"\")","v":""},{"$f":"IF(I69=\"X\",IF(E69=\"Taken\",D69,\"\"),\"\")","v":""},{"$f":"IF(I69=\"X\",IF(E69=\"To Take\",D69,\"\"),\"\")","v":""},"OK"]
["i28","-",null,{"$f":"LOOKUP(B70,opt_data_anal!$A$2:$A$10, opt_data_anal!$D$2:$D$10)","v":"-"},"NO",{"$f":"LOOKUP(B70,opt_data_anal!$A$2:$A$10, opt_data_anal!$B$2:$B$10)","v":"-"},"-",{"$f":"LOOKUP(B70,opt_data_anal!$A$2:$A$10, opt_data_anal!$C$2:$C$10)","v":"-"},"-",{"$f":"IF(I70<>\"X\",IF(E70=\"Taken\",D70,\"\"),\"\")","v":""},{"$f":"IF(I70<>\"X\",IF(E70=\"To Take\",D70,\"\"),\"\")","v":""},{"$f":"IF(I70=\"X\",IF(E70=\"Taken\",D70,\"\"),\"\")","v":""},{"$f":"IF(I70=\"X\",IF(E70=\"To Take\",D70,\"\"),\"\")","v":""},"OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J67:J70)","v":0},{"$f":"SUM(K67:K70)","v":0},{"$f":"SUM(L67:L70)","v":0},{"$f":"SUM(M67:M70)","v":0}]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"Open choice subjects",null,"CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
["i37",null,null,null,"NO",null,"-",null,"-",{"$f":"IF(I76<>\"X\",IF(E76=\"Taken\",D76,\"\"),\"\")","v":""},{"$f":"IF(I76<>\"X\",IF(E76=\"To Take\",D76,\"\"),\"\")","v":""},{"$f":"IF(I76=\"X\",IF(E76=\"Taken\",D76,\"\"),\"\")","v":""},{"$f":"IF(I76=\"X\",IF(E76=\"To Take\",D76,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(B76<>\"\",OR(D76=\"\",E76=\"NO\",G76=\"-\")),AND(B76=\"\",OR(D76<>\"\",E76<>\"NO\",G76<>\"-\"))),\"ERROR\",\"OK\")","v":"OK"}]
["i38",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
["i39",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
["i40",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
["i41",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
["i42",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J76:J81)","v":0},{"$f":"SUM(K76:K81)","v":0},0,0]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[]
[null,"CFU Cybersecurity track",null,{"$f":"SUM(J44:K44)","v":36}]
[null,"CFU Cybersecurity track excess",null,{"$f":"SUM(L44:M44)","v":0}]
[]
[null,"CFU Area “Networks”",null,{"$f":"SUM(J55:K55)","v":0}]
[null,"CFU Area “Networks” excess",null,{"$f":"SUM(L55:M55)","v":0}]
[]
[null,"CFU Area \"Sensing and communications\"",null,{"$f":"SUM(J63:K63)","v":0}]
[null,"CFU Area \"Sensing and communications\" excess",null,{"$f":"SUM(L63:M63)","v":0}]
[]
[null,"CFU Area \"Data Analytics\"",null,{"$f":"SUM(J71:K71)","v":0}]
[null,"CFU Area \"Data Analytics\" excess",null,{"$f":"SUM(L71:M71)","v":0}]
[]
[null,"Total CFU open choice",null,{"$f":"SUM(J82:K82)","v":0}]
[null,"Total CFU open choice excess",null,{"$f":"SUM(L82:M82)","v":0}]
[]
[null,"Total CFU non mandatory subjects",null,{"$f":"SUM(J100:K100)","v":36},null,null,null,null,null,{"$f":"J44+J55+J63+J71+J82","v":0},{"$f":"K44+K55+K63+K71+K82","v":36},{"$f":"L44+L55+L63+L71+L82","v":0},{"$f":"M44+M55+M63+M71+M82","v":0}]
[null,"Total CFU non mandatory subjects excess",null,{"$f":"SUM(L100:M100)","v":0}]
[]
[]
[null,"Overall total",null,{"$f":"D30+D100","v":114}]
[null,"Overall total excess",null,{"$f":"D31+D101","v":0}]
[]
[null,"Totale generale crediti >= 120",null,{"$f":" IF(D104>=120,\"OK\", \"ERROR: total CFU < 120\")","v":"ERROR: total CFU < 120"}]
[null,"Totale generale crediti <= 123",null,{"$f":" IF(D104<=183,\"OK\", \"ERROR: numero crediti > 123\")","v":"OK"}]
[]
[]
[null,"Controllo totale numero errori",null,{"$f":"COUNTIF(N19:N28,E111)+COUNTIF(N76:N81,E111)+COUNTIF(D107:E108,E111)+COUNTIF(N37:N43,E111)+COUNTIF(D33:D33,E111)+COUNTIF(D46:D47,E111)","v":1},{"$f":"\"*\" & \"ERROR\" & \"*\"","v":"*ERROR*"}]
[null,"Risultato analisi del piano",null,{"$f":"IF(D111=0,\"THE STUDY PLAN IS FORMALLY CORRECT\",\"THE STUDY PLAN HAS SOME FORMAL ERRORS (\"&D111&\")\")","v":"THE STUDY PLAN HAS SOME FORMAL ERRORS (1)"}]

{"sheet":"options_by_area","index":5,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[null,"anno","semestre","CFU"]
["-","-","-","-"]
["Satellite Navigation and Surveillance Systems (9 CFU)",2,1,9]
["Satellite Navigation and Surveillance Systems (6 CFU)",2,1,6]
["Internet Via Satellite",2,1,6]
["Radar Systems and Applications ",2,1,6]
["Satellite Earth Observation","1 or 2",2,9]
["Satellite Earth Observation","1 or 2",2,6]
["Radiowave Propagation",2,1,6]
["Microwaves",2,2,6]
["Optical Communications",2,1,6]
["Network Security (9 CFU)",2,1,9]
["Network Security (6 CFU)",2,1,6]
["Networks and Systems Defence",2,1,6]
["Cloud Computing and Networking",2,1,6]
["Hardware, Electromagnetic and Localization Security",2,1,6]
["Multimedia Processing and Communication",2,1,6]
["Internet Services Performance (9 CFU)",2,1,9]
["Internet Services Performance (6 CFU)",2,1,6]
["Internet of Things: Principles and Applications ",2,2,6]
["Internet-based Distributed Simulation",2,2,6]
["Information Theory and Data Mining",2,1,6]
["Operations Research Methods for Network Optimiz. (9 CFU, taught in Italian) ",2,1,9]
["Operations Research Methods for Network Optimiz. (6 CFU, taught in Italian)",2,1,6]
["Optimization Methods for Big Data (taught in Italian)",2,2,6]
["Web Mining and Retrieval",2,2,9]
["Web Mining and Retrieval",2,2,6]
["Pattern Recognition (9 CFU, taught in Italian)",2,2,9]
["Pattern Recognition (6 CFU, taught in Italian)",2,2,6]

{"sheet":"options_sorted","index":6,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[null,"anno","semestre","CFU"]
["-","-","-","-"]
["Cloud Computing and Networking",2,1,6]
["Hardware, Electromagnetic and Localization Security",2,1,6]
["Information Theory and Data Mining",2,1,6]
["Internet of Things: Principles and Applications ",2,2,6]
["Internet Services Performance (6 CFU)",2,1,6]
["Internet Services Performance (9 CFU)",2,1,9]
["Internet Via Satellite",2,1,6]
["Internet-based Distributed Simulation",2,2,6]
["Microwaves",2,2,6]
["Multimedia Processing and Communication",2,1,6]
["Network Security (6 CFU)",2,1,6]
["Network Security (9 CFU)",2,1,9]
["Networks and Systems Defence",2,1,6]
["Operations Research Methods for Network Optimiz. (6 CFU, taught in Italian)",2,1,6]
["Operations Research Methods for Network Optimiz. (9 CFU, taught in Italian) ",2,1,9]
["Optical Communications",2,1,6]
["Optimization Methods for Big Data (taught in Italian)",2,2,6]
["Pattern Recognition (6 CFU, taught in Italian)",2,2,6]
["Pattern Recognition (9 CFU, taught in Italian)",2,2,9]
["Radar Systems and Applications ",2,1,6]
["Radiowave Propagation",2,1,6]
["Satellite Earth Observation","1 or 2",2,9]
["Satellite Earth Observation","1 or 2",2,6]
["Satellite Navigation and Surveillance Systems (6 CFU)",2,1,6]
["Satellite Navigation and Surveillance Systems (9 CFU)",2,1,9]
["Web Mining and Retrieval",2,2,9]
["Web Mining and Retrieval",2,2,6]

{"sheet":"Space_sys_2021","index":7,"n_rows":112,"n_cols":14,"rows_kept":112,"cut":false,"hidden":false,"merged":[[107,3,107,4],[111,3,111,6],[12,8,12,11],[13,2,13,4],[13,8,13,11],[1,1,1,11],[2,1,2,11],[10,2,10,6],[10,8,10,11],[11,2,11,6],[11,8,11,11],[7,2,7,6],[7,8,7,11],[8,2,8,6],[8,8,8,11],[9,2,9,6],[9,8,9,11]]}
[]
[null,"Master's Degree \"ICT and Internet Engineering\" - Piano di studi 2020/21"]
[null,"Space Integrated Systems Track"]
[null,"Total CFU",{"$f":"D104","v":114},null,"Missing CFU",{"$f":"MAX(0,120-C4)","v":6}]
[null,"Excess CFU",{"$f":"D105","v":0},null,"Status",{"$f":"D112","v":"THE STUDY PLAN HAS SOME FORMAL ERRORS (1)"}]
[]
[]
[null,"Surname Name:",{"$f":"IF(MAIN_PAGE!C8=0,\"\",MAIN_PAGE!C8)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I8","v":"ERROR - Insert Surname Name"}]
[null,"Matricola (Student's ID):",{"$f":"IF(MAIN_PAGE!C9=0,\"\",MAIN_PAGE!C9)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I9","v":"ERROR - Insert Student's ID"}]
[null,"Fiscal Code:",{"$f":"IF(MAIN_PAGE!C10=0,\"\",MAIN_PAGE!C10)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I10","v":"ERROR - Insert Fiscal Code"}]
[null,"E-mail address:",{"$f":"IF(MAIN_PAGE!C11=0,\"\",MAIN_PAGE!C11)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I11","v":"ERROR - Insert e-mail address"}]
[null,"Phone:",{"$f":"IF(MAIN_PAGE!C12=0,\"\",MAIN_PAGE!C12)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I12","v":"ERROR - Insert Phone"}]
[null,"Course Year (I or II):",{"$f":"IF(MAIN_PAGE!C13=0,\"\",MAIN_PAGE!C13)","v":"-"},null,null,null,null,null,{"$f":"MAIN_PAGE!I13","v":"ERROR - Insert Course Year"}]
[null,"Regular year/Supplem. Year (fuori corso)",{"$f":"IF(MAIN_PAGE!C14=0,\"\",MAIN_PAGE!C14)","v":"-"},null,null,null,null,null,{"$f":"MAIN_PAGE!I14","v":"ERROR - Select Reg. or Supplem. Year"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"Mandatory subjects","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
["i1","Internet Technology and Protocols  (ex Networking and Internet Protocols) (9 CFU)","(1)",9,"To Take",1,1,1,"-",{"$f":"IF(I19<>\"X\",IF(E19=\"Taken\",D19,\"\"),\"\")","v":""},{"$f":"IF(I19<>\"X\",IF(E19=\"To Take\",D19,\"\"),\"\")","v":9},{"$f":"IF(I19=\"X\",IF(E19=\"Taken\",D19,\"\"),\"\")","v":""},{"$f":"IF(I19=\"X\",IF(E19=\"To Take\",D19,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(E19=\"NO\",G19<>\"-\"),AND(E19<>\"NO\",G19=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A19,2,LEN(A19)-1))+1","v":"i2"},"Internet Technology and Protocols  (ex Networking and Internet Protocols) (6 CFU)",{"$f":"C19","v":"(1)"},6,"NO",1,"-",1,"-","","","","","OK"]
["i3","Service-oriented Software Engineering",null,9,"To Take",1,1,1,"-","",9,"","","OK"]
["i4","Wireless Electromagnetic Technologies",null,9,"To Take",1,1,1,"-","",9,"","","OK"]
["i5","Digital Communications",null,6,"To Take",1,1,1,"-","",6,"","","OK"]
["i6","Mobile Wireless Networks",null,9,"To Take",1,1,2,"-","",9,"","","OK"]
["i7","Network Infrastructures",null,6,"To Take",1,1,2,"-","",6,"","","OK"]
["i8","Fundamentals of Radar and Localization",null,9,"To Take",1,1,2,"-","",9,"","","OK"]
["i9","Formative activities",null,3,"To Take",2,2,"-","-","",3,"","","OK"]
["i10","Prova finale",null,18,"To Take",2,2,"-","-","",18,"","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J19:J28)","v":0},{"$f":"SUM(K19:K28)","v":78},{"$f":"SUM(L19:L28)","v":0},{"$f":"SUM(M19:M28)","v":0}]
[null,"Total CFU mandatory subjects",null,{"$f":"SUM(J29:K29)","v":78},null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[null,"Total CFU mandatory subject (excess)",null,{"$f":"SUM(L29:M29)","v":0}]
[]
[{"$f":"C19","v":"(1)"},{"$f":"\"Choose one between \"&A19&\" and \"&A20","v":"Choose one between i1 and i2"},null,{"$f":"IF(_xlfn.XOR(OR(E19=\"To Take\",E19=\"Taken\"),OR(E20=\"To Take\",E20=\"Taken\")),\"OK\",\"ERROR\")","v":"OK"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"Space Integrated Systems Track suggested subjects ","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A28,2,LEN(A28)-1))+1","v":"i11"},"Satellite Earth Observation (9 CFU)",{"$f":"\"(\"&VALUE(MID(C19,2,LEN(C19)-2))+1&\")\"","v":"(2)"},9,"To Take","1 or 2",2,2,"-",{"$f":"IF(I37<>\"X\",IF(E37=\"Taken\",D37,\"\"),\"\")","v":""},{"$f":"IF(I37<>\"X\",IF(E37=\"To Take\",D37,\"\"),\"\")","v":9},{"$f":"IF(I37=\"X\",IF(E37=\"Taken\",D37,\"\"),\"\")","v":""},{"$f":"IF(I37=\"X\",IF(E37=\"To Take\",D37,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(E37=\"NO\",G37<>\"-\"),AND(E37<>\"NO\",G37=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A37,2,LEN(A37)-1))+1","v":"i12"},"Satellite Earth Observation (6 CFU)",{"$f":"C37","v":"(2)"},6,"NO","1 or 2","-",2,"-","","","","","OK"]
["i13","Satellite Navigation and Surveillance Systems (9 CFU)",{"$f":"\"(\"&VALUE(MID(C37,2,LEN(C37)-2))+1&\")\"","v":"(3)"},9,"To Take",2,2,1,"-","",9,"","","OK"]
["i14","Satellite Navigation and Surveillance Systems (6 CFU)",{"$f":"C39","v":"(3)"},6,"NO",2,"-",1,"-","","","","","OK"]
["i15","Internet Via Satellite",null,6,"To Take",2,2,1,"-","",6,"","","OK"]
["i16","Radar Systems and Applications ",null,6,"To Take",2,2,1,"-","",6,"","","OK"]
["i17","Multimedia Processing and Communication",null,6,"To Take",2,2,1,"-","",6,"","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J37:J43)","v":0},{"$f":"SUM(K37:K43)","v":36},{"$f":"SUM(L37:L43)","v":0},{"$f":"SUM(M37:M43)","v":0}]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[{"$f":"C37","v":"(2)"},{"$f":"\"Choose at most one between \"&A37&\" and \"&A38","v":"Choose at most one between i11 and i12"},null,{"$f":"IF(AND(OR(E37=\"To Take\",E37=\"Taken\"),OR(E38=\"To Take\",E38=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"C39","v":"(3)"},{"$f":"\"Choose at most one between \"&A39&\" and \"&A40","v":"Choose at most one between i13 and i14"},null,{"$f":"IF(AND(OR(E39=\"To Take\",E39=\"Taken\"),OR(E40=\"To Take\",E40=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"Subjects from Networking Area","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A42,2,LEN(A42)-1))+1","v":"i17"},"-",null,{"$f":"LOOKUP(B51,opt_netw_and_sec_4_space!$A$2:$A$11, opt_netw_and_sec_4_space!$D$2:$D$11)","v":"-"},"NO",{"$f":"LOOKUP(B51,opt_netw_and_sec_4_space!$A$2:$A$11, opt_netw_and_sec_4_space!$B$2:$B$11)","v":"-"},"-",{"$f":"LOOKUP(B51,opt_netw_and_sec_4_space!$A$2:$A$11, opt_netw_and_sec_4_space!$C$2:$C$11)","v":"-"},"-",{"$f":"IF(I51<>\"X\",IF(E51=\"Taken\",D51,\"\"),\"\")","v":""},{"$f":"IF(I51<>\"X\",IF(E51=\"To Take\",D51,\"\"),\"\")","v":""},{"$f":"IF(I51=\"X\",IF(E51=\"Taken\",D51,\"\"),\"\")","v":""},{"$f":"IF(I51=\"X\",IF(E51=\"To Take\",D51,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(B51<>\"-\",OR(E51=\"NO\",G51=\"-\")),AND(B51=\"-\",OR(E51<>\"NO\",G51<>\"-\"))),\"ERRORE\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A51,2,LEN(A51)-1))+1","v":"i18"},"-",null,{"$f":"LOOKUP(B52,opt_netw_and_sec_4_space!$A$2:$A$11, opt_netw_and_sec_4_space!$D$2:$D$11)","v":"-"},"NO",{"$f":"LOOKUP(B52,opt_netw_and_sec_4_space!$A$2:$A$11, opt_netw_and_sec_4_space!$B$2:$B$11)","v":"-"},"-",{"$f":"LOOKUP(B52,opt_netw_and_sec_4_space!$A$2:$A$11, opt_netw_and_sec_4_space!$C$2:$C$11)","v":"-"},"-",{"$f":"IF(I52<>\"X\",IF(E52=\"Taken\",D52,\"\"),\"\")","v":""},{"$f":"IF(I52<>\"X\",IF(E52=\"To Take\",D52,\"\"),\"\")","v":""},{"$f":"IF(I52=\"X\",IF(E52=\"Taken\",D52,\"\"),\"\")","v":""},{"$f":"IF(I52=\"X\",IF(E52=\"To Take\",D52,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(B52<>\"-\",OR(E52=\"NO\",G52=\"-\")),AND(B52=\"-\",OR(E52<>\"NO\",G52<>\"-\"))),\"ERRORE\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A52,2,LEN(A52)-1))+1","v":"i19"},"-",null,{"$f":"LOOKUP(B53,opt_netw_and_sec_4_space!$A$2:$A$11, opt_netw_and_sec_4_space!$D$2:$D$11)","v":"-"},"NO",{"$f":"LOOKUP(B53,opt_netw_and_sec_4_space!$A$2:$A$11, opt_netw_and_sec_4_space!$B$2:$B$11)","v":"-"},"-",{"$f":"LOOKUP(B53,opt_netw_and_sec_4_space!$A$2:$A$11, opt_netw_and_sec_4_space!$C$2:$C$11)","v":"-"},"-",{"$f":"IF(I53<>\"X\",IF(E53=\"Taken\",D53,\"\"),\"\")","v":""},{"$f":"IF(I53<>\"X\",IF(E53=\"To Take\",D53,\"\"),\"\")","v":""},{"$f":"IF(I53=\"X\",IF(E53=\"Taken\",D53,\"\"),\"\")","v":""},{"$f":"IF(I53=\"X\",IF(E53=\"To Take\",D53,\"\"),\"\")","v":""},"OK"]
["i20","-",null,{"$f":"LOOKUP(B54,opt_netw_and_sec_4_space!$A$2:$A$11, opt_netw_and_sec_4_space!$D$2:$D$11)","v":"-"},"NO",{"$f":"LOOKUP(B54,opt_netw_and_sec_4_space!$A$2:$A$11, opt_netw_and_sec_4_space!$B$2:$B$11)","v":"-"},"-",{"$f":"LOOKUP(B54,opt_netw_and_sec_4_space!$A$2:$A$11, opt_netw_and_sec_4_space!$C$2:$C$11)","v":"-"},"-",{"$f":"IF(I54<>\"X\",IF(E54=\"Taken\",D54,\"\"),\"\")","v":""},{"$f":"IF(I54<>\"X\",IF(E54=\"To Take\",D54,\"\"),\"\")","v":""},{"$f":"IF(I54=\"X\",IF(E54=\"Taken\",D54,\"\"),\"\")","v":""},{"$f":"IF(I54=\"X\",IF(E54=\"To Take\",D54,\"\"),\"\")","v":""},"OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J51:J54)","v":0},{"$f":"SUM(K51:K54)","v":0},{"$f":"SUM(L51:L54)","v":0},{"$f":"SUM(M51:M54)","v":0}]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"Subjects from Sensing and Communications Area","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A54,2,LEN(A54)-1))+1","v":"i21"},"-",null,{"$f":"LOOKUP(B59,opt_sens_commun_4_space!$A$2:$A$5, opt_sens_commun_4_space!$D$2:$D$5)","v":"-"},"NO",{"$f":"LOOKUP(B59,opt_sens_commun_4_space!$A$2:$A$5, opt_sens_commun_4_space!$B$2:$B$5)","v":"-"},"-",{"$f":"LOOKUP(B59,opt_sens_commun_4_space!$A$2:$A$5, opt_sens_commun_4_space!$C$2:$C$5)","v":"-"},"-",{"$f":"IF(I59<>\"X\",IF(E59=\"Taken\",D59,\"\"),\"\")","v":""},{"$f":"IF(I59<>\"X\",IF(E59=\"To Take\",D59,\"\"),\"\")","v":""},{"$f":"IF(I59=\"X\",IF(E59=\"Taken\",D59,\"\"),\"\")","v":""},{"$f":"IF(I59=\"X\",IF(E59=\"To Take\",D59,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(B59<>\"-\",OR(E59=\"NO\",G59=\"-\")),AND(B59=\"-\",OR(E59<>\"NO\",G59<>\"-\"))),\"ERRORE\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A59,2,LEN(A59)-1))+1","v":"i22"},"-",null,{"$f":"LOOKUP(B60,opt_sens_commun_4_space!$A$2:$A$5, opt_sens_commun_4_space!$D$2:$D$5)","v":"-"},"NO",{"$f":"LOOKUP(B60,opt_sens_commun_4_space!$A$2:$A$5, opt_sens_commun_4_space!$B$2:$B$5)","v":"-"},"-",{"$f":"LOOKUP(B60,opt_sens_commun_4_space!$A$2:$A$5, opt_sens_commun_4_space!$C$2:$C$5)","v":"-"},"-",{"$f":"IF(I60<>\"X\",IF(E60=\"Taken\",D60,\"\"),\"\")","v":""},{"$f":"IF(I60<>\"X\",IF(E60=\"To Take\",D60,\"\"),\"\")","v":""},{"$f":"IF(I60=\"X\",IF(E60=\"Taken\",D60,\"\"),\"\")","v":""},{"$f":"IF(I60=\"X\",IF(E60=\"To Take\",D60,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(B60<>\"-\",OR(E60=\"NO\",G60=\"-\")),AND(B60=\"-\",OR(E60<>\"NO\",G60<>\"-\"))),\"ERRORE\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A60,2,LEN(A60)-1))+1","v":"i23"},"-",null,{"$f":"LOOKUP(B61,opt_sens_commun_4_space!$A$2:$A$5, opt_sens_commun_4_space!$D$2:$D$5)","v":"-"},"NO",{"$f":"LOOKUP(B61,opt_sens_commun_4_space!$A$2:$A$5, opt_sens_commun_4_space!$B$2:$B$5)","v":"-"},"-",{"$f":"LOOKUP(B61,opt_sens_commun_4_space!$A$2:$A$5, opt_sens_commun_4_space!$C$2:$C$5)","v":"-"},"-",{"$f":"IF(I61<>\"X\",IF(E61=\"Taken\",D61,\"\"),\"\")","v":""},{"$f":"IF(I61<>\"X\",IF(E61=\"To Take\",D61,\"\"),\"\")","v":""},{"$f":"IF(I61=\"X\",IF(E61=\"Taken\",D61,\"\"),\"\")","v":""},{"$f":"IF(I61=\"X\",IF(E61=\"To Take\",D61,\"\"),\"\")","v":""},"OK"]
["i24","-",null,{"$f":"LOOKUP(B62,opt_sens_commun_4_space!$A$2:$A$5, opt_sens_commun_4_space!$D$2:$D$5)","v":"-"},"NO",{"$f":"LOOKUP(B62,opt_sens_commun_4_space!$A$2:$A$5, opt_sens_commun_4_space!$B$2:$B$5)","v":"-"},"-",{"$f":"LOOKUP(B62,opt_sens_commun_4_space!$A$2:$A$5, opt_sens_commun_4_space!$C$2:$C$5)","v":"-"},"-",{"$f":"IF(I62<>\"X\",IF(E62=\"Taken\",D62,\"\"),\"\")","v":""},{"$f":"IF(I62<>\"X\",IF(E62=\"To Take\",D62,\"\"),\"\")","v":""},{"$f":"IF(I62=\"X\",IF(E62=\"Taken\",D62,\"\"),\"\")","v":""},{"$f":"IF(I62=\"X\",IF(E62=\"To Take\",D62,\"\"),\"\")","v":""},"OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J59:J62)","v":0},{"$f":"SUM(K59:K62)","v":0},{"$f":"SUM(L59:L62)","v":0},{"$f":"SUM(M59:M62)","v":0}]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"Subjects from Data Analysis Area","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A62,2,LEN(A62)-1))+1","v":"i25"},"-",null,{"$f":"LOOKUP(B67,opt_data_anal!$A$2:$A$10, opt_data_anal!$D$2:$D$10)","v":"-"},"NO",{"$f":"LOOKUP(B67,opt_data_anal!$A$2:$A$10, opt_data_anal!$B$2:$B$10)","v":"-"},"-",{"$f":"LOOKUP(B67,opt_data_anal!$A$2:$A$10, opt_data_anal!$C$2:$C$10)","v":"-"},"-",{"$f":"IF(I67<>\"X\",IF(E67=\"Taken\",D67,\"\"),\"\")","v":""},{"$f":"IF(I67<>\"X\",IF(E67=\"To Take\",D67,\"\"),\"\")","v":""},{"$f":"IF(I67=\"X\",IF(E67=\"Taken\",D67,\"\"),\"\")","v":""},{"$f":"IF(I67=\"X\",IF(E67=\"To Take\",D67,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(B67<>\"-\",OR(E67=\"NO\",G67=\"-\")),AND(B67=\"-\",OR(E67<>\"NO\",G67<>\"-\"))),\"ERRORE\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A67,2,LEN(A67)-1))+1","v":"i26"},"-",null,{"$f":"LOOKUP(B68,opt_data_anal!$A$2:$A$10, opt_data_anal!$D$2:$D$10)","v":"-"},"NO",{"$f":"LOOKUP(B68,opt_data_anal!$A$2:$A$10, opt_data_anal!$B$2:$B$10)","v":"-"},"-",{"$f":"LOOKUP(B68,opt_data_anal!$A$2:$A$10, opt_data_anal!$C$2:$C$10)","v":"-"},"-",{"$f":"IF(I68<>\"X\",IF(E68=\"Taken\",D68,\"\"),\"\")","v":""},{"$f":"IF(I68<>\"X\",IF(E68=\"To Take\",D68,\"\"),\"\")","v":""},{"$f":"IF(I68=\"X\",IF(E68=\"Taken\",D68,\"\"),\"\")","v":""},{"$f":"IF(I68=\"X\",IF(E68=\"To Take\",D68,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(B68<>\"-\",OR(E68=\"NO\",G68=\"-\")),AND(B68=\"-\",OR(E68<>\"NO\",G68<>\"-\"))),\"ERRORE\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A68,2,LEN(A68)-1))+1","v":"i27"},"-",null,{"$f":"LOOKUP(B69,opt_data_anal!$A$2:$A$10, opt_data_anal!$D$2:$D$10)","v":"-"},"NO",{"$f":"LOOKUP(B69,opt_data_anal!$A$2:$A$10, opt_data_anal!$B$2:$B$10)","v":"-"},"-",{"$f":"LOOKUP(B69,opt_data_anal!$A$2:$A$10, opt_data_anal!$C$2:$C$10)","v":"-"},"-",{"$f":"IF(I69<>\"X\",IF(E69=\"Taken\",D69,\"\"),\"\")","v":""},{"$f":"IF(I69<>\"X\",IF(E69=\"To Take\",D69,\"\"),\"\")","v":""},{"$f":"IF(I69=\"X\",IF(E69=\"Taken\",D69,\"\"),\"\")","v":""},{"$f":"IF(I69=\"X\",IF(E69=\"To Take\",D69,\"\"),\"\")","v":""},"OK"]
["i28","-",null,{"$f":"LOOKUP(B70,opt_data_anal!$A$2:$A$10, opt_data_anal!$D$2:$D$10)","v":"-"},"NO",{"$f":"LOOKUP(B70,opt_data_anal!$A$2:$A$10, opt_data_anal!$B$2:$B$10)","v":"-"},"-",{"$f":"LOOKUP(B70,opt_data_anal!$A$2:$A$10, opt_data_anal!$C$2:$C$10)","v":"-"},"-",{"$f":"IF(I70<>\"X\",IF(E70=\"Taken\",D70,\"\"),\"\")","v":""},{"$f":"IF(I70<>\"X\",IF(E70=\"To Take\",D70,\"\"),\"\")","v":""},{"$f":"IF(I70=\"X\",IF(E70=\"Taken\",D70,\"\"),\"\")","v":""},{"$f":"IF(I70=\"X\",IF(E70=\"To Take\",D70,\"\"),\"\")","v":""},"OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J67:J70)","v":0},{"$f":"SUM(K67:K70)","v":0},{"$f":"SUM(L67:L70)","v":0},{"$f":"SUM(M67:M70)","v":0}]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"Open choice subjects",null,"CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
["i37",null,null,null,"NO",null,"-",null,"-",{"$f":"IF(I76<>\"X\",IF(E76=\"Taken\",D76,\"\"),\"\")","v":""},{"$f":"IF(I76<>\"X\",IF(E76=\"To Take\",D76,\"\"),\"\")","v":""},{"$f":"IF(I76=\"X\",IF(E76=\"Taken\",D76,\"\"),\"\")","v":""},{"$f":"IF(I76=\"X\",IF(E76=\"To Take\",D76,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(B76<>\"\",OR(D76=\"\",E76=\"NO\",G76=\"-\")),AND(B76=\"\",OR(D76<>\"\",E76<>\"NO\",G76<>\"-\"))),\"ERROR\",\"OK\")","v":"OK"}]
["i38",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
["i39",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
["i40",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
["i41",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
["i42",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J76:J81)","v":0},{"$f":"SUM(K76:K81)","v":0},0,0]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[]
[null,"CFU Cybersecurity track",null,{"$f":"SUM(J44:K44)","v":36}]
[null,"CFU Cybersecurity track excess",null,{"$f":"SUM(L44:M44)","v":0}]
[]
[null,"CFU Area “Networks”",null,{"$f":"SUM(J55:K55)","v":0}]
[null,"CFU Area “Networks” excess",null,{"$f":"SUM(L55:M55)","v":0}]
[]
[null,"CFU Area \"Sensing and communications\"",null,{"$f":"SUM(J63:K63)","v":0}]
[null,"CFU Area \"Sensing and communications\" excess",null,{"$f":"SUM(L63:M63)","v":0}]
[]
[null,"CFU Area \"Data Analytics\"",null,{"$f":"SUM(J71:K71)","v":0}]
[null,"CFU Area \"Data Analytics\" excess",null,{"$f":"SUM(L71:M71)","v":0}]
[]
[null,"Total CFU open choice",null,{"$f":"SUM(J82:K82)","v":0}]
[null,"Total CFU open choice excess",null,{"$f":"SUM(L82:M82)","v":0}]
[]
[null,"Total CFU non mandatory subjects",null,{"$f":"SUM(J100:K100)","v":36},null,null,null,null,null,{"$f":"J44+J55+J63+J71+J82","v":0},{"$f":"K44+K55+K63+K71+K82","v":36},{"$f":"L44+L55+L63+L71+L82","v":0},{"$f":"M44+M55+M63+M71+M82","v":0}]
[null,"Total CFU non mandatory subjects excess",null,{"$f":"SUM(L100:M100)","v":0}]
[]
[]
[null,"Overall total",null,{"$f":"D30+D100","v":114}]
[null,"Overall total excess",null,{"$f":"D31+D101","v":0}]
[]
[null,"Totale generale crediti >= 120",null,{"$f":" IF(D104>=120,\"OK\", \"ERROR: total CFU < 120\")","v":"ERROR: total CFU < 120"}]
[null,"Totale generale crediti <= 123",null,{"$f":" IF(D104<=183,\"OK\", \"ERROR: numero crediti > 123\")","v":"OK"}]
[]
[]
[null,"Controllo totale numero errori",null,{"$f":"COUNTIF(N19:N28,E111)+COUNTIF(N76:N81,E111)+COUNTIF(D107:E108,E111)+COUNTIF(N37:N43,E111)+COUNTIF(D33:D33,E111)+COUNTIF(D46:D47,E111)","v":1},{"$f":"\"*\" & \"ERROR\" & \"*\"","v":"*ERROR*"}]
[null,"Risultato analisi del piano",null,{"$f":"IF(D111=0,\"THE STUDY PLAN IS FORMALLY CORRECT\",\"THE STUDY PLAN HAS SOME FORMAL ERRORS (\"&D111&\")\")","v":"THE STUDY PLAN HAS SOME FORMAL ERRORS (1)"}]

{"sheet":"Base_1819","index":8,"n_rows":122,"n_cols":14,"rows_kept":122,"cut":false,"hidden":false,"merged":[[1,1,1,11],[2,1,2,11],[7,2,7,6],[7,8,7,11],[8,2,8,6],[8,8,8,11],[9,2,9,6],[9,8,9,11],[10,2,10,6],[10,8,10,11],[11,2,11,6],[11,8,11,11],[12,8,12,11],[13,2,13,4],[13,8,13,11],[117,3,117,4],[121,3,121,6]]}
[]
[null,"Master's Degree \"ICT and Internet Engineering\" - Piano di studi 2020/21"]
[null,"Generic Model"]
[null,"Total CFU",{"$f":"D114","v":78},null,"Missing CFU",{"$f":"MAX(0,120-C4)","v":42}]
[null,"Excess CFU",{"$f":"D115","v":0},null,"Status",{"$f":"D122","v":"THE STUDY PLAN HAS SOME FORMAL ERRORS (1)"}]
[]
[]
[null,"Surname Name:",{"$f":"IF(MAIN_PAGE!C8=0,\"\",MAIN_PAGE!C8)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I8","v":"ERROR - Insert Surname Name"}]
[null,"Matricola (Student's ID):",{"$f":"IF(MAIN_PAGE!C9=0,\"\",MAIN_PAGE!C9)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I9","v":"ERROR - Insert Student's ID"}]
[null,"Fiscal Code:",{"$f":"IF(MAIN_PAGE!C10=0,\"\",MAIN_PAGE!C10)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I10","v":"ERROR - Insert Fiscal Code"}]
[null,"E-mail address:",{"$f":"IF(MAIN_PAGE!C11=0,\"\",MAIN_PAGE!C11)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I11","v":"ERROR - Insert e-mail address"}]
[null,"Phone:",{"$f":"IF(MAIN_PAGE!C12=0,\"\",MAIN_PAGE!C12)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I12","v":"ERROR - Insert Phone"}]
[null,"Course Year (I or II):",{"$f":"IF(MAIN_PAGE!C13=0,\"\",MAIN_PAGE!C13)","v":"-"},null,null,null,null,null,{"$f":"MAIN_PAGE!I13","v":"ERROR - Insert Course Year"}]
[null,"Regular year/Supplem. Year (fuori corso)",{"$f":"IF(MAIN_PAGE!C14=0,\"\",MAIN_PAGE!C14)","v":"-"},null,null,null,null,null,{"$f":"MAIN_PAGE!I14","v":"ERROR - Select Reg. or Supplem. Year"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"Mandatory subjects","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
["i1","Internet Technology and Protocols  (ex Networking and Internet Protocols) (9 CFU)","(1)",9,"To Take",1,1,1,"-",{"$f":"IF(I19<>\"X\",IF(E19=\"Taken\",D19,\"\"),\"\")","v":""},{"$f":"IF(I19<>\"X\",IF(E19=\"To Take\",D19,\"\"),\"\")","v":9},{"$f":"IF(I19=\"X\",IF(E19=\"Taken\",D19,\"\"),\"\")","v":""},{"$f":"IF(I19=\"X\",IF(E19=\"To Take\",D19,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(E19=\"NO\",G19<>\"-\"),AND(E19<>\"NO\",G19=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A19,2,LEN(A19)-1))+1","v":"i2"},"Internet Technology and Protocols  (ex Networking and Internet Protocols) (6 CFU)",{"$f":"C19","v":"(1)"},6,"NO",1,"-",1,"-","","","","","OK"]
["i3","Service-oriented Software Engineering",null,9,"To Take",1,1,1,"-","",9,"","","OK"]
["i4","Wireless Electromagnetic Technologies",null,9,"To Take",1,1,1,"-","",9,"","","OK"]
["i5","Digital Communications",null,6,"To Take",1,1,1,"-","",6,"","","OK"]
["i6","Mobile Wireless Networks",null,9,"To Take",1,1,2,"-","",9,"","","OK"]
["i7","Network Infrastructures",null,6,"To Take",1,1,2,"-","",6,"","","OK"]
["i8","Fundamentals of Radar and Localization",null,9,"To Take",1,1,2,"-","",9,"","","OK"]
["i9","Formative activities",null,3,"To Take",2,2,"-","-","",3,"","","OK"]
["i10","Prova finale",null,18,"To Take",2,2,"-","-","",18,"","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J19:J28)","v":0},{"$f":"SUM(K19:K28)","v":78},{"$f":"SUM(L19:L28)","v":0},{"$f":"SUM(M19:M28)","v":0}]
[null,"Total CFU mandatory subjects",null,{"$f":"SUM(J29:K29)","v":78},null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[null,"Total CFU mandatory subject (excess)",null,{"$f":"SUM(L29:M29)","v":0}]
[]
[{"$f":"C19","v":"(1)"},{"$f":"\"Choose one between \"&A19&\" and \"&A20","v":"Choose one between i1 and i2"},null,{"$f":"IF(_xlfn.XOR(OR(E19=\"To Take\",E19=\"Taken\"),OR(E20=\"To Take\",E20=\"Taken\")),\"OK\",\"ERROR\")","v":"OK"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"AREA “SENSING AND COMMUNICATIONS”","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A28,2,LEN(A28)-1))+1","v":"i11"},"Satellite Navigation and Surveillance Systems (9 CFU)",{"$f":"\"(\"&VALUE(MID(C20,2,LEN(C20)-2))+1&\")\"","v":"(2)"},9,"NO",2,"-",1,"-",{"$f":"IF(I37<>\"X\",IF(E37=\"Taken\",D37,\"\"),\"\")","v":""},{"$f":"IF(I37<>\"X\",IF(E37=\"To Take\",D37,\"\"),\"\")","v":""},{"$f":"IF(I37=\"X\",IF(E37=\"Taken\",D37,\"\"),\"\")","v":""},{"$f":"IF(I37=\"X\",IF(E37=\"To Take\",D37,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(E37=\"NO\",G37<>\"-\"),AND(E37<>\"NO\",G37=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A37,2,LEN(A37)-1))+1","v":"i12"},"Satellite Navigation and Surveillance Systems (6 CFU)",{"$f":"C37","v":"(2)"},6,"NO",2,"-",1,"-","","","","","OK"]
[{"$f":"\"i\"&VALUE(MID(A38,2,LEN(A38)-1))+1","v":"i13"},"Internet Via Satellite",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i14","Radar Systems and Applications ",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i15","Satellite Earth Observation (9 CFU)",{"$f":"\"(\"&VALUE(MID(C37,2,LEN(C37)-2))+1&\")\"","v":"(3)"},9,"NO","1 o 2","-",2,"-","","","","","OK"]
["i16","Satellite Earth Observation (6 CFU)",{"$f":"C41","v":"(3)"},6,"NO","1 o 2","-",2,"-","","","","","OK"]
["i17","Radiowave Propagation",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i18","Microwaves",null,6,"NO",2,"-",2,"-","","","","","OK"]
["i19","Optical Communications",null,6,"NO",2,"-",1,"-","","","","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J37:J45)","v":0},{"$f":"SUM(K37:K45)","v":0},{"$f":"SUM(L37:L45)","v":0},{"$f":"SUM(M37:M45)","v":0}]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[{"$f":"C37","v":"(2)"},{"$f":"\"Choose at most one between \"&A37&\" and \"&A38","v":"Choose at most one between i11 and i12"},null,{"$f":"IF(AND(OR(E37=\"To Take\",E37=\"Taken\"),OR(E38=\"To Take\",E38=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"C41","v":"(3)"},{"$f":"\"Choose at most one between \"&A41&\" and \"&A42","v":"Choose at most one between i15 and i16"},null,{"$f":"IF(AND(OR(E41=\"To Take\",E41=\"Taken\"),OR(E42=\"To Take\",E42=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"AREA “NETWORKS & SECURITY”","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A45,2,LEN(A45)-1))+1","v":"i20"},"Network Security (9 CFU)",{"$f":"\"(\"&VALUE(MID(C41,2,LEN(C41)-2))+1&\")\"","v":"(4)"},9,"NO",2,"-",1,"-",{"$f":"IF(I53<>\"X\",IF(E53=\"Taken\",D53,\"\"),\"\")","v":""},{"$f":"IF(I53<>\"X\",IF(E53=\"To Take\",D53,\"\"),\"\")","v":""},{"$f":"IF(I53=\"X\",IF(E53=\"Taken\",D53,\"\"),\"\")","v":""},{"$f":"IF(I53=\"X\",IF(E53=\"To Take\",D53,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(E53=\"NO\",G53<>\"-\"),AND(E53<>\"NO\",G53=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A53,2,LEN(A53)-1))+1","v":"i21"},"Network Security (6 CFU)",{"$f":"C53","v":"(4)"},6,"NO",2,"-",1,"-","","","","","OK"]
["i22","Enterprise Networks",{"$f":"\"(\"&VALUE(MID(C53,2,LEN(C53)-2))+1&\")\"","v":"(5)"},6,"NO",2,"-",1,"-","","","","","OK"]
["i23","Networks and Systems Defence",{"$f":"C55","v":"(5)"},6,"NO",2,"-",1,"-","","","","","OK"]
["i24","Cloud Computing and Networking",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i25","Hardware, Electromagnetic and Localizion Security",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i26","Multimedia Processing and Communication",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i27","ICT Infrastructures and Applications",null,6,"NO",2,"-",1,"-",{"$f":"IF(I60<>\"X\",IF(E60=\"Taken\",D60,\"\"),\"\")","v":""},{"$f":"IF(I60<>\"X\",IF(E60=\"To Take\",D60,\"\"),\"\")","v":""},{"$f":"IF(I60=\"X\",IF(E60=\"Taken\",D60,\"\"),\"\")","v":""},{"$f":"IF(I60=\"X\",IF(E60=\"To Take\",D60,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(E60=\"NO\",G60<>\"-\"),AND(E60<>\"NO\",G60=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
["i28","Internet Services Performance (9 CFU)",{"$f":"\"(\"&VALUE(MID(C55,2,LEN(C55)-2))+1&\")\"","v":"(6)"},9,"NO",2,"-",1,"-","","","","","OK"]
["i29","Internet Services Performance (6 CFU)",{"$f":"C61","v":"(6)"},6,"NO",2,"-",1,"-","","","","","OK"]
["i30","Internet of Things: Principles and Applications ",null,6,"NO",2,"-",2,"-","","","","","OK"]
["i31","Internet-based Distributed Simulation",null,6,"NO",2,"-",2,"-","","","","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J53:J64)","v":0},{"$f":"SUM(K53:K64)","v":0},0,0]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[{"$f":"C53","v":"(4)"},{"$f":"\"Choose at most one between \"&A53&\" and \"&A54","v":"Choose at most one between i20 and i21"},null,{"$f":"IF(AND(OR(E53=\"To Take\",E53=\"Taken\"),OR(E54=\"To Take\",E54=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"C55","v":"(5)"},{"$f":"\"Choose at most one between \"&A55&\" and \"&A56","v":"Choose at most one between i22 and i23"},null,{"$f":"IF(AND(OR(E55=\"To Take\",E55=\"Taken\"),OR(E56=\"To Take\",E56=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"C61","v":"(6)"},{"$f":"\"Choose at most one between \"&A61&\" and \"&A62","v":"Choose at most one between i28 and i29"},null,{"$f":"IF(AND(OR(E61=\"To Take\",E61=\"Taken\"),OR(E62=\"To Take\",E62=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"AREA “DATA ANALYTICS & METHODOLOGIES”","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A64,2,LEN(A64)-1))+1","v":"i32"},"Information Theory and Data Mining",null,6,"NO",2,"-",1,"-",{"$f":"IF(I73<>\"X\",IF(E73=\"Taken\",D73,\"\"),\"\")","v":""},{"$f":"IF(I73<>\"X\",IF(E73=\"To Take\",D73,\"\"),\"\")","v":""},{"$f":"IF(I73=\"X\",IF(E73=\"Taken\",D73,\"\"),\"\")","v":""},{"$f":"IF(I73=\"X\",IF(E73=\"To Take\",D73,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(E73=\"NO\",G73<>\"-\"),AND(E73<>\"NO\",G73=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A73,2,LEN(A73)-1))+1","v":"i33"},"Operations Research Methods for Network Optimization (9 CFU, taught in Italian)",{"$f":"\"(\"&VALUE(MID(C61,2,LEN(C61)-2))+1&\")\"","v":"(7)"},9,"NO",2,"-",1,"-","","","","","OK"]
["i34","Operations Research Methods for Network Optimization (6 CFU, taught in Italian)",{"$f":"C74","v":"(7)"},6,"NO",2,"-",1,"-","","","","","OK"]
["i35","Optimization Methods for Big Data (taught in Italian)",null,6,"NO",2,"-",2,"-","","","","","OK"]
["i36","Web Mining and Retrieval",{"$f":"\"(\"&VALUE(MID(C74,2,LEN(C74)-2))+1&\")\"","v":"(8)"},9,"NO",2,"-",2,"-","","","","","OK"]
["i37","Web Mining and Retrieval",{"$f":"C77","v":"(8)"},6,"NO",2,"-",2,"-","","","","","OK"]
["i38","Pattern Recognition (9 CFU, taught in Italian)",{"$f":"\"(\"&VALUE(MID(C77,2,LEN(C77)-2))+1&\")\"","v":"(9)"},9,"NO",2,"-",2,"-","","","","","OK"]
["i39","Pattern Recognition (6 CFU, taught in Italian)",{"$f":"C79","v":"(9)"},6,"NO",2,"-",2,"-","","","","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J73:J80)","v":0},{"$f":"SUM(K73:K80)","v":0},{"$f":"SUM(L73:L80)","v":0},{"$f":"SUM(M73:M80)","v":0}]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[{"$f":"C74","v":"(7)"},{"$f":"\"Choose at most one between \"&A74&\" and \"&A75","v":"Choose at most one between i33 and i34"},null,{"$f":"IF(AND(OR(E74=\"To Take\",E74=\"Taken\"),OR(E75=\"To Take\",E75=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"C77","v":"(8)"},{"$f":"\"Choose at most one between \"&A77&\" and \"&A78","v":"Choose at most one between i36 and i37"},null,{"$f":"IF(AND(OR(E77=\"To Take\",E77=\"Taken\"),OR(E78=\"To Take\",E78=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"C79","v":"(9)"},{"$f":"\"Choose at most one between \"&A79&\" and \"&A80","v":"Choose at most one between i38 and i39"},null,{"$f":"IF(AND(OR(E79=\"To Take\",E79=\"Taken\"),OR(E80=\"To Take\",E80=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"Open choice subjects",null,"CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A80,2,LEN(A80)-1))+1","v":"i40"},null,null,null,"NO",null,"-",null,"-",{"$f":"IF(I89<>\"X\",IF(E89=\"Taken\",D89,\"\"),\"\")","v":""},{"$f":"IF(I89<>\"X\",IF(E89=\"To Take\",D89,\"\"),\"\")","v":""},{"$f":"IF(I89=\"X\",IF(E89=\"Taken\",D89,\"\"),\"\")","v":""},{"$f":"IF(I89=\"X\",IF(E89=\"To Take\",D89,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(B89<>\"\",OR(D89=\"\",E89=\"NO\",G89=\"-\")),AND(B89=\"\",OR(D89<>\"\",E89<>\"NO\",G89<>\"-\"))),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A89,2,LEN(A89)-1))+1","v":"i41"},null,null,null,"NO",null,"-",null,"-","","","","","OK"]
["i42",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
["i43",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
["i44",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
["i45",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J89:J94)","v":0},{"$f":"SUM(K89:K94)","v":0},0,0]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[]
[null,"CFU AREA “SENSING AND COMMUNICATIONS”",null,{"$f":"SUM(J46:K46)","v":0}]
[null,"CFU AREA “SENSING AND COMM.” excess",null,{"$f":"SUM(L46:M46)","v":0}]
[]
[null,"CFU AREA “NETWORKS & SECURITY”",null,{"$f":"SUM(J65:K65)","v":0}]
[null,"CFU AREA “NETWORKS & SECURITY” excess",null,{"$f":"SUM(L65:M65)","v":0}]
[]
[null,"CFU AREA “DATA ANALYTICS & METHODOLOGIES”",null,{"$f":"SUM(J81:K81)","v":0}]
[null,"CFU AREA “DATA ANALYTICS...” excess",null,{"$f":"SUM(L81:M81)","v":0}]
[]
[null,"Total CFU open choice",null,{"$f":"SUM(J95:K95)","v":0}]
[null,"Total CFU open choice excess",null,{"$f":"SUM(L95:M95)","v":0}]
[]
[null,"Total CFU non mandatory subjects",null,{"$f":"SUM(J110:K110)","v":0},null,null,null,null,null,{"$f":"J46+J65+J81+J95","v":0},{"$f":"K46+K65+K81+K95","v":0},{"$f":"L46+L65+L81+L95","v":0},{"$f":"M46+M65+M81+M95","v":0}]
[null,"Total CFU non mandatory subjects excess",null,{"$f":"SUM(L110:M110)","v":0}]
[]
[]
[null,"Overall total",null,{"$f":"D30+D110","v":78}]
[null,"Overall total excess",null,{"$f":"D31+D111","v":0}]
[]
[null,"Totale generale crediti >= 120",null,{"$f":" IF(D114>=120,\"OK\", \"ERROR: total CFU < 120\")","v":"ERROR: total CFU < 120"}]
[null,"Totale generale crediti <= 123",null,{"$f":" IF(D114<=183,\"OK\", \"ERROR: numero crediti > 123\")","v":"OK"}]
[]
[]
[null,"Controllo totale numero errori",null,{"$f":"COUNTIF(N19:N28,E121)+COUNTIF(N89:N94,E121)+COUNTIF(D117:E118,E121)+COUNTIF(N53:N64,E121)+COUNTIF(N73:N80,E121)+COUNTIF(N37:N45,E121)+COUNTIF(D33:D33,E121)+COUNTIF(D48:D49,E121)+COUNTIF(D67:D69,E121)+COUNTIF(D83:D85,E121)","v":1},{"$f":"\"*\" & \"ERROR\" & \"*\"","v":"*ERROR*"}]
[null,"Risultato analisi del piano",null,{"$f":"IF(D121=0,\"THE STUDY PLAN IS FORMALLY CORRECT\",\"THE STUDY PLAN HAS SOME FORMAL ERRORS (\"&D121&\")\")","v":"THE STUDY PLAN HAS SOME FORMAL ERRORS (1)"}]

{"sheet":"Base1819_with_suppl","index":9,"n_rows":137,"n_cols":14,"rows_kept":137,"cut":false,"hidden":false,"merged":[[1,1,1,11],[2,1,2,11],[7,2,7,6],[7,8,7,11],[8,2,8,6],[8,8,8,11],[9,2,9,6],[9,8,9,11],[10,2,10,6],[10,8,10,11],[11,2,11,6],[11,8,11,11],[12,8,12,11],[13,2,13,4],[13,8,13,11],[132,3,132,4],[136,3,136,6]]}
[]
[null,"Master's Degree \"ICT and Internet Engineering\" - Piano di studi 2020/21"]
[null,"Generic Model with Supplementary Subjects"]
[null,"Total CFU",{"$f":"D129","v":78},null,"Missing CFU",{"$f":"MAX(0,120-C4)","v":42}]
[null,"Excess CFU",{"$f":"D130","v":0},null,"Status",{"$f":"D137","v":"THE STUDY PLAN HAS SOME FORMAL ERRORS (1)"}]
[]
[]
[null,"Surname Name:",{"$f":"IF(MAIN_PAGE!C8=0,\"\",MAIN_PAGE!C8)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I8","v":"ERROR - Insert Surname Name"}]
[null,"Matricola (Student's ID):",{"$f":"IF(MAIN_PAGE!C9=0,\"\",MAIN_PAGE!C9)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I9","v":"ERROR - Insert Student's ID"}]
[null,"Fiscal Code:",{"$f":"IF(MAIN_PAGE!C10=0,\"\",MAIN_PAGE!C10)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I10","v":"ERROR - Insert Fiscal Code"}]
[null,"E-mail address:",{"$f":"IF(MAIN_PAGE!C11=0,\"\",MAIN_PAGE!C11)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I11","v":"ERROR - Insert e-mail address"}]
[null,"Phone:",{"$f":"IF(MAIN_PAGE!C12=0,\"\",MAIN_PAGE!C12)","v":""},null,null,null,null,null,{"$f":"MAIN_PAGE!I12","v":"ERROR - Insert Phone"}]
[null,"Course Year (I or II):",{"$f":"IF(MAIN_PAGE!C13=0,\"\",MAIN_PAGE!C13)","v":"-"},null,null,null,null,null,{"$f":"MAIN_PAGE!I13","v":"ERROR - Insert Course Year"}]
[null,"Regular year/Supplem. Year (fuori corso)",{"$f":"IF(MAIN_PAGE!C14=0,\"\",MAIN_PAGE!C14)","v":"-"},null,null,null,null,null,{"$f":"MAIN_PAGE!I14","v":"ERROR - Select Reg. or Supplem. Year"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"Mandatory subjects","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
["i1","Internet Technology and Protocols  (ex Networking and Internet Protocols) (9 CFU)","(1)",9,"To Take",1,1,1,"-",{"$f":"IF(I19<>\"X\",IF(E19=\"Taken\",D19,\"\"),\"\")","v":""},{"$f":"IF(I19<>\"X\",IF(E19=\"To Take\",D19,\"\"),\"\")","v":9},{"$f":"IF(I19=\"X\",IF(E19=\"Taken\",D19,\"\"),\"\")","v":""},{"$f":"IF(I19=\"X\",IF(E19=\"To Take\",D19,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(E19=\"NO\",G19<>\"-\"),AND(E19<>\"NO\",G19=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A19,2,LEN(A19)-1))+1","v":"i2"},"Internet Technology and Protocols  (ex Networking and Internet Protocols) (6 CFU)",{"$f":"C19","v":"(1)"},6,"NO",1,"-",1,"-","","","","","OK"]
["i3","Service-oriented Software Engineering",null,9,"To Take",1,1,1,"-","",9,"","","OK"]
["i4","Wireless Electromagnetic Technologies",null,9,"To Take",1,1,1,"-","",9,"","","OK"]
["i5","Digital Communications",null,6,"To Take",1,1,1,"-","",6,"","","OK"]
["i6","Mobile Wireless Networks",null,9,"To Take",1,1,2,"-","",9,"","","OK"]
["i7","Network Infrastructures",null,6,"To Take",1,1,2,"-","",6,"","","OK"]
["i8","Fundamentals of Radar and Localization",null,9,"To Take",1,1,2,"-","",9,"","","OK"]
["i9","Formative activities",null,3,"To Take",2,2,"-","-","",3,"","","OK"]
["i10","Prova finale",null,18,"To Take",2,2,"-","-","",18,"","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J19:J28)","v":0},{"$f":"SUM(K19:K28)","v":78},{"$f":"SUM(L19:L28)","v":0},{"$f":"SUM(M19:M28)","v":0}]
[null,"Total CFU mandatory subjects",null,{"$f":"SUM(J29:K29)","v":78},null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[null,"Total CFU mandatory subject (excess)",null,{"$f":"SUM(L29:M29)","v":0}]
[]
[{"$f":"C19","v":"(1)"},{"$f":"\"Choose one between \"&A19&\" and \"&A20","v":"Choose one between i1 and i2"},null,{"$f":"IF(_xlfn.XOR(OR(E19=\"To Take\",E19=\"Taken\"),OR(E20=\"To Take\",E20=\"Taken\")),\"OK\",\"ERROR\")","v":"OK"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"Supplementary subjects (*)","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A28,2,LEN(A28)-1))+1","v":"i11"},"Electromagnetic Fields",null,6,"NO",1,"-",1,"-",{"$f":"IF(I37<>\"X\",IF(E37=\"Taken\",D37,\"\"),\"\")","v":""},{"$f":"IF(I37<>\"X\",IF(E37=\"To Take\",D37,\"\"),\"\")","v":""},{"$f":"IF(I37=\"X\",IF(E37=\"Taken\",D37,\"\"),\"\")","v":""},{"$f":"IF(I37=\"X\",IF(E37=\"To Take\",D37,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(E37=\"NO\",G37<>\"-\"),AND(E37<>\"NO\",G37=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A37,2,LEN(A37)-1))+1","v":"i12"},"Fundamentals of Telecommunications",{"$f":"\"(\"&VALUE(MID(C19,2,LEN(C19)-2))+1&\")\"","v":"(2)"},9,"NO",1,"-",2,"-",{"$f":"IF(I38<>\"X\",IF(E38=\"Taken\",D38,\"\"),\"\")","v":""},{"$f":"IF(I38<>\"X\",IF(E38=\"To Take\",D38,\"\"),\"\")","v":""},{"$f":"IF(I38=\"X\",IF(E38=\"Taken\",D38,\"\"),\"\")","v":""},{"$f":"IF(I38=\"X\",IF(E38=\"To Take\",D38,\"\"),\"\")","v":""},"OK"]
[{"$f":"\"i\"&VALUE(MID(A38,2,LEN(A38)-1))+1","v":"i13"},"Fundamentals of Telecommunications",{"$f":"C38","v":"(2)"},6,"NO",1,"-",2,"-",{"$f":"IF(I39<>\"X\",IF(E39=\"Taken\",D39,\"\"),\"\")","v":""},{"$f":"IF(I39<>\"X\",IF(E39=\"To Take\",D39,\"\"),\"\")","v":""},{"$f":"IF(I39=\"X\",IF(E39=\"Taken\",D39,\"\"),\"\")","v":""},{"$f":"IF(I39=\"X\",IF(E39=\"To Take\",D39,\"\"),\"\")","v":""},"OK"]
[{"$f":"\"i\"&VALUE(MID(A39,2,LEN(A39)-1))+1","v":"i14"},"Networking and Internet",null,9,"NO",1,"-",2,"-",{"$f":"IF(I40<>\"X\",IF(E40=\"Taken\",D40,\"\"),\"\")","v":""},{"$f":"IF(I40<>\"X\",IF(E40=\"To Take\",D40,\"\"),\"\")","v":""},{"$f":"IF(I40=\"X\",IF(E40=\"Taken\",D40,\"\"),\"\")","v":""},{"$f":"IF(I40=\"X\",IF(E40=\"To Take\",D40,\"\"),\"\")","v":""},"OK"]
[{"$f":"\"i\"&VALUE(MID(A40,2,LEN(A40)-1))+1","v":"i15"},"Digital Signal Processing",null,6,"NO",1,"-",2,"-",{"$f":"IF(I41<>\"X\",IF(E41=\"Taken\",D41,\"\"),\"\")","v":""},{"$f":"IF(I41<>\"X\",IF(E41=\"To Take\",D41,\"\"),\"\")","v":""},{"$f":"IF(I41=\"X\",IF(E41=\"Taken\",D41,\"\"),\"\")","v":""},{"$f":"IF(I41=\"X\",IF(E41=\"To Take\",D41,\"\"),\"\")","v":""},"OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J37:J41)","v":0},{"$f":"SUM(K37:K41)","v":0},{"$f":"SUM(L37:L41)","v":0},{"$f":"SUM(M37:M41)","v":0}]
[null,"Total CFU supplementary subjects",null,{"$f":"SUM(J42:K42)","v":0},null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[null,"Total CFU supplementary subject (excess)",null,{"$f":"SUM(L42:M42)","v":0}]
[]
["(*)","SUPPLEMENTARY SUBJECTS: for credit recovery need only (students coming from other Courses, missing know-how in one or more areas)"]
[{"$f":"C38","v":"(2)"},{"$f":"\"Choose at most one between \"&A37&\" and \"&A38","v":"Choose at most one between i11 and i12"},null,{"$f":"IF(AND(OR(E38=\"To Take\",E38=\"Taken\"),OR(E39=\"To Take\",E39=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"AREA “SENSING AND COMMUNICATIONS”","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A41,2,LEN(A41)-1))+1","v":"i16"},"Satellite Navigation and Surveillance Systems (9 CFU)",{"$f":"\"(\"&VALUE(MID(C38,2,LEN(C38)-2))+1&\")\"","v":"(3)"},9,"NO",2,"-",1,"-",{"$f":"IF(I52<>\"X\",IF(E52=\"Taken\",D52,\"\"),\"\")","v":""},{"$f":"IF(I52<>\"X\",IF(E52=\"To Take\",D52,\"\"),\"\")","v":""},{"$f":"IF(I52=\"X\",IF(E52=\"Taken\",D52,\"\"),\"\")","v":""},{"$f":"IF(I52=\"X\",IF(E52=\"To Take\",D52,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(E52=\"NO\",G52<>\"-\"),AND(E52<>\"NO\",G52=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A52,2,LEN(A52)-1))+1","v":"i17"},"Satellite Navigation and Surveillance Systems (6 CFU)",{"$f":"C52","v":"(3)"},6,"NO",2,"-",1,"-","","","","","OK"]
[{"$f":"\"i\"&VALUE(MID(A53,2,LEN(A53)-1))+1","v":"i18"},"Internet Via Satellite",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i19","Radar Systems and Applications ",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i20","Satellite Earth Observation (9 CFU)",{"$f":"\"(\"&VALUE(MID(C52,2,LEN(C52)-2))+1&\")\"","v":"(4)"},9,"NO","1 o 2","-",2,"-","","","","","OK"]
["i21","Satellite Earth Observation (6 CFU)",{"$f":"C56","v":"(4)"},6,"NO","1 o 2","-",2,"-","","","","","OK"]
["i22","Radiowave Propagation",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i23","Microwaves",null,6,"NO",2,"-",2,"-","","","","","OK"]
["i24","Optical Communications",null,6,"NO",2,"-",1,"-","","","","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J52:J60)","v":0},{"$f":"SUM(K52:K60)","v":0},{"$f":"SUM(L52:L60)","v":0},{"$f":"SUM(M52:M60)","v":0}]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[{"$f":"C52","v":"(3)"},{"$f":"\"Choose at most one between \"&A52&\" and \"&A53","v":"Choose at most one between i16 and i17"},null,{"$f":"IF(AND(OR(E52=\"To Take\",E52=\"Taken\"),OR(E53=\"To Take\",E53=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"C56","v":"(4)"},{"$f":"\"Choose at most one between \"&A56&\" and \"&A57","v":"Choose at most one between i20 and i21"},null,{"$f":"IF(AND(OR(E56=\"To Take\",E56=\"Taken\"),OR(E57=\"To Take\",E57=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"AREA “NETWORKS & SECURITY”","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A60,2,LEN(A60)-1))+1","v":"i25"},"Network Security (9 CFU)",{"$f":"\"(\"&VALUE(MID(C56,2,LEN(C56)-2))+1&\")\"","v":"(5)"},9,"NO",2,"-",1,"-",{"$f":"IF(I68<>\"X\",IF(E68=\"Taken\",D68,\"\"),\"\")","v":""},{"$f":"IF(I68<>\"X\",IF(E68=\"To Take\",D68,\"\"),\"\")","v":""},{"$f":"IF(I68=\"X\",IF(E68=\"Taken\",D68,\"\"),\"\")","v":""},{"$f":"IF(I68=\"X\",IF(E68=\"To Take\",D68,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(E68=\"NO\",G68<>\"-\"),AND(E68<>\"NO\",G68=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A68,2,LEN(A68)-1))+1","v":"i26"},"Network Security (6 CFU)",{"$f":"C68","v":"(5)"},6,"NO",2,"-",1,"-","","","","","OK"]
[{"$f":"\"i\"&VALUE(MID(A69,2,LEN(A69)-1))+1","v":"i27"},"Enterprise Networks",{"$f":"\"(\"&VALUE(MID(C68,2,LEN(C68)-2))+1&\")\"","v":"(6)"},6,"NO",2,"-",1,"-","","","","","OK"]
["i28","Networks and Systems Defence",{"$f":"C70","v":"(6)"},6,"NO",2,"-",1,"-","","","","","OK"]
["i29","Cloud Computing and Networking",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i30","Hardware, Electromagnetic and Localizion Security",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i31","Multimedia Processing and Communication",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i32","ICT Infrastructures and Applications",null,6,"NO",2,"-",1,"-","","","","","OK"]
["i33","Internet Services Performance (9 CFU)",{"$f":"\"(\"&VALUE(MID(C70,2,LEN(C70)-2))+1&\")\"","v":"(7)"},9,"NO",2,"-",1,"-","","","","","OK"]
["i34","Internet Services Performance (6 CFU)",{"$f":"C76","v":"(7)"},6,"NO",2,"-",1,"-","","","","","OK"]
["i35","Internet of Things: Principles and Applications ",null,6,"NO",2,"-",2,"-","","","","","OK"]
["i36","Internet-based Distributed Simulation",null,6,"NO",2,"-",2,"-","","","","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J68:J79)","v":0},{"$f":"SUM(K68:K79)","v":0},0,0]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[{"$f":"C68","v":"(5)"},{"$f":"\"Choose at most one between \"&A68&\" and \"&A69","v":"Choose at most one between i25 and i26"},null,{"$f":"IF(AND(OR(E68=\"To Take\",E68=\"Taken\"),OR(E69=\"To Take\",E69=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"C70","v":"(6)"},{"$f":"\"Choose at most one between \"&A70&\" and \"&A71","v":"Choose at most one between i27 and i28"},null,{"$f":"IF(AND(OR(E70=\"To Take\",E70=\"Taken\"),OR(E71=\"To Take\",E71=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"C76","v":"(7)"},{"$f":"\"Choose at most one between \"&A76&\" and \"&A77","v":"Choose at most one between i33 and i34"},null,{"$f":"IF(AND(OR(E76=\"To Take\",E76=\"Taken\"),OR(E77=\"To Take\",E77=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"AREA “DATA ANALYTICS & METHODOLOGIES”","Note","CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A79,2,LEN(A79)-1))+1","v":"i37"},"Information Theory and Data Mining",null,6,"NO",2,"-",1,"-",{"$f":"IF(I88<>\"X\",IF(E88=\"Taken\",D88,\"\"),\"\")","v":""},{"$f":"IF(I88<>\"X\",IF(E88=\"To Take\",D88,\"\"),\"\")","v":""},{"$f":"IF(I88=\"X\",IF(E88=\"Taken\",D88,\"\"),\"\")","v":""},{"$f":"IF(I88=\"X\",IF(E88=\"To Take\",D88,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(E88=\"NO\",G88<>\"-\"),AND(E88<>\"NO\",G88=\"-\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A88,2,LEN(A88)-1))+1","v":"i38"},"Operations Research Methods for Network Optimization (taught in Italian)",{"$f":"\"(\"&VALUE(MID(C76,2,LEN(C76)-2))+1&\")\"","v":"(8)"},9,"NO",2,"-",1,"-","","","","","OK"]
["i39","Operations Research Methods for Network Optimization (taught in Italian)",{"$f":"C89","v":"(8)"},6,"NO",2,"-",1,"-","","","","","OK"]
["i40","Optimization Methods for Big Data (taught in Italian)",null,6,"NO",2,"-",2,"-","","","","","OK"]
["i41","Web Mining and Retrieval",{"$f":"\"(\"&VALUE(MID(C89,2,LEN(C89)-2))+1&\")\"","v":"(9)"},9,"NO",2,"-",2,"-","","","","","OK"]
["i42","Web Mining and Retrieval",{"$f":"C92","v":"(9)"},6,"NO",2,"-",2,"-","","","","","OK"]
["i43","Pattern Recognition (taught in Italian)",{"$f":"\"(\"&VALUE(MID(C92,2,LEN(C92)-2))+1&\")\"","v":"(10)"},9,"NO",2,"-",2,"-","","","","","OK"]
["i44","Pattern Recognition (taught in Italian)",{"$f":"C94","v":"(10)"},6,"NO",2,"-",2,"-","","","","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J88:J95)","v":0},{"$f":"SUM(K88:K95)","v":0},{"$f":"SUM(L88:L95)","v":0},{"$f":"SUM(M88:M95)","v":0}]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[{"$f":"C89","v":"(8)"},{"$f":"\"Choose at most one between \"&A89&\" and \"&A90","v":"Choose at most one between i38 and i39"},null,{"$f":"IF(AND(OR(E89=\"To Take\",E89=\"Taken\"),OR(E90=\"To Take\",E90=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"C92","v":"(9)"},{"$f":"\"Choose at most one between \"&A92&\" and \"&A93","v":"Choose at most one between i41 and i42"},null,{"$f":"IF(AND(OR(E92=\"To Take\",E92=\"Taken\"),OR(E93=\"To Take\",E93=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"C94","v":"(10)"},{"$f":"\"Choose at most one between \"&A94&\" and \"&A95","v":"Choose at most one between i43 and i44"},null,{"$f":"IF(AND(OR(E94=\"To Take\",E94=\"Taken\"),OR(E95=\"To Take\",E95=\"Taken\")),\"ERROR\",\"OK\")","v":"OK"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excess","Excess"]
[null,"Open choice subjects",null,"CFU","Select","Program Year","Actual year","Semester","Excess","CFU\ntaken","CFU to\ntake","CFU\ntaken","CFU to\ntake","Check"]
[{"$f":"\"i\"&VALUE(MID(A95,2,LEN(A95)-1))+1","v":"i45"},null,null,null,"NO",null,"-",null,"-",{"$f":"IF(I104<>\"X\",IF(E104=\"Taken\",D104,\"\"),\"\")","v":""},{"$f":"IF(I104<>\"X\",IF(E104=\"To Take\",D104,\"\"),\"\")","v":""},{"$f":"IF(I104=\"X\",IF(E104=\"Taken\",D104,\"\"),\"\")","v":""},{"$f":"IF(I104=\"X\",IF(E104=\"To Take\",D104,\"\"),\"\")","v":""},{"$f":"IF(OR(AND(B104<>\"\",OR(D104=\"\",E104=\"NO\",G104=\"-\")),AND(B104=\"\",OR(D104<>\"\",E104<>\"NO\",G104<>\"-\"))),\"ERROR\",\"OK\")","v":"OK"}]
[{"$f":"\"i\"&VALUE(MID(A104,2,LEN(A104)-1))+1","v":"i46"},null,null,null,"NO",null,"-",null,"-","","","","","OK"]
["i47",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
["i48",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
["i49",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
["i50",null,null,null,"NO",null,"-",null,"-","","","","","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J104:J109)","v":0},{"$f":"SUM(K104:K109)","v":0},0,0]
[null,null,null,null,null,null,null,null,null,"Tot taken","Tot to take","Tot taken","Tot to take"]
[]
[null,"CFU AREA “SENSING AND COMMUNICATIONS”",null,{"$f":"SUM(J61:K61)","v":0}]
[null,"CFU AREA “SENSING AND COMM.” excess",null,{"$f":"SUM(L61:M61)","v":0}]
[]
[null,"CFU AREA “NETWORKS & SECURITY”",null,{"$f":"SUM(J80:K80)","v":0}]
[null,"CFU AREA “NETWORKS & SECURITY” excess",null,{"$f":"SUM(L80:M80)","v":0}]
[]
[null,"CFU AREA “DATA ANALYTICS & METHODOLOGIES”",null,{"$f":"SUM(J96:K96)","v":0}]
[null,"CFU AREA “DATA ANALYTICS...” excess",null,{"$f":"SUM(L96:M96)","v":0}]
[]
[null,"Total CFU open choice",null,{"$f":"SUM(J110:K110)","v":0}]
[null,"Total CFU open choice excess",null,{"$f":"SUM(L110:M110)","v":0}]
[]
[null,"Total CFU non mandatory subjects",null,{"$f":"SUM(J125:K125)","v":0},null,null,null,null,null,{"$f":"J61+J80+J96+J110","v":0},{"$f":"K61+K80+K96+K110","v":0},{"$f":"L61+L80+L96+L110","v":0},{"$f":"M61+M80+M96+M110","v":0}]
[null,"Total CFU non mandatory subjects excess",null,{"$f":"SUM(L125:M125)","v":0}]
[]
[]
[null,"Overall total",null,{"$f":"D30+D125+D43","v":78}]
[null,"Overall total excess",null,{"$f":"D31+D126+D44","v":0}]
[]
[null,"Totale generale crediti >= 120",null,{"$f":" IF(D129>=120,\"OK\", \"ERROR: total CFU < 120\")","v":"ERROR: total CFU < 120"}]
[null,"Totale generale crediti <= 123",null,{"$f":" IF(D129<=183,\"OK\", \"ERROR: numero crediti > 123\")","v":"OK"}]
[]
[]
[null,"Controllo totale numero errori",null,{"$f":"COUNTIF(N19:N28,E136)+COUNTIF(N104:N109,E136)+COUNTIF(D132:E133,E136)+COUNTIF(N68:N79,E136)+COUNTIF(N88:N95,E136)+COUNTIF(N52:N60,E136)+COUNTIF(D33,E136)+COUNTIF(D63:D64,E136)+COUNTIF(D82:D84,E136)+COUNTIF(D98:D100,E136)+COUNTIF(N37:N41,E136)+COUNTIF(D47,E136)","v":1},{"$f":"\"*\" & \"ERROR\" & \"*\"","v":"*ERROR*"}]
[null,"Risultato analisi del piano",null,{"$f":"IF(D136=0,\"THE STUDY PLAN IS FORMALLY CORRECT\",\"THE STUDY PLAN HAS SOME FORMAL ERRORS (\"&D136&\")\")","v":"THE STUDY PLAN HAS SOME FORMAL ERRORS (1)"}]

{"sheet":"opt_sens_commun","index":10,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["THE LIST NEEDS TO BE SORTED!!!!","anno","semestre","CFU"]
["-","-","-","-"]
["Internet Via Satellite",2,1,6]
["Microwaves",2,2,6]
["Optical Communications",2,1,6]
["Radar Systems and Applications ",2,1,6]
["Radiowave Propagation",2,1,6]
["Satellite Earth Observation (6 CFU)","1 or 2",2,6]
["Satellite Earth Observation (9 CFU)","1 or 2",2,9]
["Satellite Navigation and Surveillance Systems (6 CFU)",2,1,6]
["Satellite Navigation and Surveillance Systems (9 CFU)",2,1,9]

{"sheet":"opt_sens_commun_4_space","index":11,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["THE LIST NEEDS TO BE SORTED!!!!","anno","semestre","CFU"]
["-","-","-","-"]
["Microwaves",2,2,6]
["Optical Communications",2,1,6]
["Radiowave Propagation",2,1,6]

{"sheet":"opt_netw_and_sec","index":12,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["THE LIST NEEDS TO BE SORTED!!!!","anno","semestre","CFU"]
["-","-","-","-"]
["Cloud Computing and Networking",2,1,6]
["Hardware, Electromagnetic and Localization Security",2,1,6]
["Internet of Things: Principles and Applications ",2,2,6]
["Internet Services Performance (6 CFU)",2,1,6]
["Internet Services Performance (9 CFU)",2,1,9]
["Internet-based Distributed Simulation",2,2,6]
["Multimedia Processing and Communication",2,1,6]
["Network Security (6 CFU)",2,1,6]
["Network Security (9 CFU)",2,1,9]
["Networks and Systems Defence",2,1,6]

{"sheet":"opt_data_anal","index":13,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["THE LIST NEEDS TO BE SORTED!!!!","anno","semestre","CFU"]
["-","-","-","-"]
["Information Theory and Data Mining",2,1,6]
["Operations Research Methods for Network Optimiz. (6 CFU, taught in Italian)",2,1,6]
["Operations Research Methods for Network Optimiz. (9 CFU, taught in Italian) ",2,1,9]
["Optimization Methods for Big Data (taught in Italian)",2,2,6]
["Pattern Recognition (6 CFU, taught in Italian)",2,2,6]
["Pattern Recognition (9 CFU, taught in Italian)",2,2,9]
["Web Mining and Retrieval (6 CFU)",2,2,6]
["Web Mining and Retrieval (9 CFU)",2,2,9]

{"sheet":"opt_netw_and_sec_4_cyber","index":14,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["THE LIST NEEDS TO BE SORTED!!!!","anno","semestre","CFU"]
["-","-","-","-"]
["Cloud Computing and Networking",2,1,6]
["Hardware, Electromagnetic and Localization Security",2,1,6]
["Internet of Things: Principles and Applications ",2,2,6]
["Internet Services Performance (6 CFU)",2,1,6]
["Internet Services Performance (9 CFU)",2,1,9]
["Internet-based Distributed Simulation",2,2,6]
["Multimedia Processing and Communication",2,1,6]

{"sheet":"opt_netw_and_sec_4_space","index":15,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["THE LIST NEEDS TO BE SORTED!!!!","anno","semestre","CFU"]
["-","-","-","-"]
["Cloud Computing and Networking",2,1,6]
["Hardware, Electromagnetic and Localization Security",2,1,6]
["Internet of Things: Principles and Applications ",2,2,6]
["Internet Services Performance (6 CFU)",2,1,6]
["Internet Services Performance (9 CFU)",2,1,9]
["Internet-based Distributed Simulation",2,2,6]
["Network Security (6 CFU)",2,1,6]
["Network Security (9 CFU)",2,1,9]
["Networks and Systems Defence",2,1,6]