{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Accueil","Semestre1","Semestre2","PanPan"],"not_rendered":{"charts":1,"images":5,"macros":1,"external_links":0,"defined_names":0,"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":"Accueil","index":0,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,4,3,6],[11,3,11,4],[11,6,11,7],[11,9,11,10],[19,0,19,1],[11,0,11,1]]}
[]
[null,"PanNote"]
[null,null,null," "]
[null,"Tutoriel",null,null,"La gestion des notes :"]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
["Moyenne semestre 1 :",null,null,"Moyenne semestre 2 :",null,null,"Moyenne Annuelle :",null,null,"Niveau 1 :"]
[]
["Compétence 1 ",{"$f":"IFERROR(PanPan!B16,\"\")","v":12.7},null,"Compétence 1 ",{"$f":"IFERROR(PanPan!D16,\"\")","v":15.392857142857142},null,"Compétence 1 ",{"$f":"IFERROR(AVERAGE(B14,E14),\"\")","v":14.046428571428571},null,"Compétence 1 ",{"$f":"IFERROR(_xlfn.IFS(H14=\"\",\"\",H14>=10,\"Oui\",H14<10,\"Non\"),\"\")","v":"Oui"}]
["Compétence 2 ",{"$f":"IFERROR(PanPan!B28,\"\")","v":13.933333333333335},null,"Compétence 2 ",{"$f":"IFERROR(PanPan!D28,\"\")","v":13},null,"Compétence 2 ",{"$f":"IFERROR(AVERAGE(B15,E15),\"\")","v":13.466666666666669},null,"Compétence 2 ",{"$f":"IFERROR(_xlfn.IFS(H15=\"\",\"\",H15>=10,\"Oui\",H15<10,\"Non\"),\"\")","v":"Oui"}]
["Compétence 3",{"$f":"IFERROR(PanPan!B38,\"\")","v":15.086833329518635},null,"Compétence 3",{"$f":"IFERROR(PanPan!D38,\"\")","v":12.666666666666666},null,"Compétence 3",{"$f":"IFERROR(AVERAGE(B16,E16),\"\")","v":13.876749998092651},null,"Compétence 3",{"$f":"IFERROR(_xlfn.IFS(H16=\"\",\"\",H16>=10,\"Oui\",H16<10,\"Non\"),\"\")","v":"Oui"}]
[]
[]
[]
["Passage en deuxième année :",null,{"$f":"IF(AND(PanPan!H9=\"Accepté\",PanPan!H10=\"Accepté\"),\"Accepté\",\"Refusé\")","v":"Accepté"}]
[]
["Nombre de bloc de compétence inférieur à 8","Nombre de bloc de compétence compris entre 8 et 10","Nombre de bloc de compétence supérieur ou égal à 10","Aucun bloc de compétence  avec : ABI "]
[{"$f":"COUNTIF(H14:H16,\"<8\")","v":0},{"$f":"COUNTIFS(H14:H16,\">=8\",H14:H16,\"<10\")","v":0},{"$f":"COUNTIF(H14:H16,\">=10\")","v":3},{"$f":"IF(AND(PanPan!H5=\"Oui\",PanPan!I5=\"Oui\"),\"Oui\",\"Non\")","v":"Oui"}]

{"sheet":"Semestre1","index":1,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,0,7,0],[10,0,14,0],[17,0,23,0],[1,3,1,5]]}
[null,"Semestre 1"]
[null,"Ressource ","Coefficient","Note",null,null,"Moyenne par ressource"]
["Compétence 1","PPP1",5,13,16.5,15,{"$f":"IFERROR(AVERAGEIF(D3:F3,\"<>\"\"\",D3:F3),\"\")","v":14.833333333333334}]
[null,"Tableur et Reporting",15,11,8,null,{"$f":"IFERROR(AVERAGEIF(D4:F4,\"<>\"\"\",D4:F4),\"\")","v":9.5}]
[null,"Base de données relationnelles 1",20,14,15,null,14.5]
[null,"Bases de la programmation 1",20,12.5,10,8,10.166666666666666]
[null,"SAE - Reporting à partir de données stockées dans un SGBD relationnel",30,14,null,null,14]
[null,"SAE - Ecriture et lecture des fichiers de données",10,14,null,null,14]
[]
[]
["Compétence 2","PPP1",5,13,16.5,15,14.833333333333334]
[null,"Statistique descriptive 1",20,15.75,17,null,16.375]
[null,"Probabilités 1",15,10,16,null,13]
[null,"Mathématiques - Analyse",20,15,15.5,14,14.833333333333334]
[null,"SAE - Préparation et synthèse d'un tableau de données en vue d'une analyse exploratoire simple",40,12.5,null,null,12.5]
[]
[]
["Compétence 3","PPP1",5,13,16.5,15,14.833333333333334]
[null,"Initiation à l'anglais de spécialité",15,10,14,10,11.333333333333334]
[null,"Communication de l'information et recherche documentaire",15,9.5,16.66,null,13.08]
[null,"Découverte des données de l'environnement entrepreunarial et économique",25,19.5,18.5,18,18.666666666666668]
[null,"SAE - Apprendre en situation la production de données en entreprise",15,17.5,null,null,17.5]
[null,"SAE - Présentation en anglais d'un territoire économique et culturel",10,10,14.329999923706055,null,12.164999961853027]
[null,"SAE - Mise en œuvre d'une enquête",15,14.5,null,null,{"$f":"IFERROR(AVERAGEIF(D24:F24,\"<>\"\"\",D24:F24),\"\")","v":14.5}]

{"sheet":"Semestre2","index":2,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[2,0,10,0],[13,0,22,0],[25,0,32,0],[1,3,1,5]]}
[null,"Semestre 2"]
[null,"Ressource","Coefficient","Note",null,null,"Moyenne par ressource"]
["Compétence 1","PPP2",5,14,null,null,{"$f":"IFERROR(AVERAGEIF(D3:F3,\"<>\"\"\",D3:F3),\"\")","v":14}]
[null,"Bases de données relationnelles 2",15,17.5,17,null,{"$f":"IFERROR(AVERAGEIF(D4:F4,\"<>\"\"\",D4:F4),\"\")","v":17.25}]
[null,"Bases de la programmation 2",15,15.75,null,null,{"$f":"IFERROR(AVERAGEIF(D5:F5,\"<>\"\"\",D5:F5),\"\")","v":15.75}]
[null,"Programation statistique",15,15.5,null,null,15.5]
[null,"Reporting et datavisualisation",10,null,null,null,""]
[null,"SAE - Analyse de données, reporting et datavisualisation",20,14,null,null,14]
[null,"SAE - Conception et implémentation d'une base de données",10,null,null,null,""]
[null,"SAE - Datavisualisation",5,null,null,null,""]
[null,"SAE - Portfolio",5,null,null,null,""]
[]
[]
["Compétence 2","PPP2",5,14,null,null,14]
[null,"Statistique descriptive 2",10,12,null,null,12]
[null,"Statistique inférentielle",15,10,null,null,10]
[null,"Probabilités 2",15,14,18,null,16]
[null,"Bases de l'algèbre",15,null,null,null,""]
[null,"SAE - Analyse de données, reporting et datavisualisation",10,null,null,null,""]
[null,"SAE - Estimation par échantillonage",10,null,null,null,""]
[null,"SAE - Régression sur des données réelles",10,13.5,null,null,13.5]
[null,{"$f":"_xlfn.IFS(B19>1,\"Refusé\",AND(B19<=1,B21>=2),\"Accepté\",B21=0,\"Refusé\",Semestre2!G6=\"ABI\",\"Refusé\")","v":"Refusé"},5,null,null,null,""]
[null,"SAE - Portfolio",5,null,null,null,""]
[]
[]
["Compétence 3","PPP2",5,14,null,null,14]
[null,"Approfondissement  de l'anglais de spécialité",15,10,null,null,10]
[null,"Communication et sémiolmogie",15,null,null,null,""]
[null,"Etude des données de l'environnement entrepreneurial et économique",25,16,11,15,14]
[null,"SAE - Analyse de données, reporting et datavisualisation",20,null,null,null,""]
[null,"SAE - Construction et présentation d'indicateurs de performance",10,null,null,null,""]
[null,"SAE - Datavisualisation",5,null,null,null,""]
[null,"SAE - Portfolio",5,null,null,null,""]

{"sheet":"PanPan","index":3,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":true,"merged":[[4,1,4,2],[4,3,4,4],[5,0,13,0],[28,0,35,0],[16,0,25,0]]}
["Semestre","Semestre1"]
["compétence","Compétence 2"]
["ressource","SAE - Préparation et synthèse d'un tableau de données en vue d'une analyse exploratoire simple",null,null,null,null,null,"nombre de bloc d'ABI semestre 1","nombre de bloc d'ABI semestre 2",null,"Aucun blos des 2 semestres avec : ABI"]
["Note",1,null,null,null,null,null,{"$f":"COUNTIF(Semestre1!D3:F24,\"=ABI\")","v":0},{"$f":"COUNTIF(Semestre2!D3:F33,\"=ABI\")","v":0},null,{"$f":"IF(AND(H5=\"Oui\",I5=\"Oui\"),\"Oui\",\"Non\")","v":"Oui"}]
[null,"Semestre 1",null,"Semestre 2",null,null,"Aucun bloc avec : ABI",{"$f":"IF(H4=0,\"Oui\",\"Non\")","v":"Oui"},{"$f":"IF(I4=0,\"Oui\",\"Non\")","v":"Oui"}]
["Cpt 1",{"$f":"IFERROR(IF(Semestre1!G3=\"\",\"\",Semestre1!G3*Semestre1!C3),\"\")","v":74.166666666666671},{"$f":"IF(Semestre1!G3=\"\",\"\",Semestre1!C3)","v":5},{"$f":"IFERROR(IF(Semestre2!G3=\"\",\"\",Semestre2!G3*Semestre2!C3),\"\")","v":70},{"$f":"IF(Semestre2!G3=\"\",\"\",Semestre2!C3)","v":5}]
[null,{"$f":"IFERROR(IF(Semestre1!G4=\"\",\"\",Semestre1!G4*Semestre1!C4),\"\")","v":142.5},{"$f":"IF(Semestre1!G4=\"\",\"\",Semestre1!C4)","v":15},{"$f":"IFERROR(IF(Semestre2!G4=\"\",\"\",Semestre2!G4*Semestre2!C4),\"\")","v":258.75},{"$f":"IF(Semestre2!G4=\"\",\"\",Semestre2!C4)","v":15}]
[null,{"$f":"IFERROR(IF(Semestre1!G5=\"\",\"\",Semestre1!G5*Semestre1!C5),\"\")","v":290},{"$f":"IF(Semestre1!G5=\"\",\"\",Semestre1!C5)","v":20},{"$f":"IFERROR(IF(Semestre2!G5=\"\",\"\",Semestre2!G5*Semestre2!C5),\"\")","v":236.25},{"$f":"IF(Semestre2!G5=\"\",\"\",Semestre2!C5)","v":15}]
[null,{"$f":"IFERROR(IF(Semestre1!G6=\"\",\"\",Semestre1!G6*Semestre1!C6),\"\")","v":203.33333333333331},{"$f":"IF(Semestre1!G6=\"\",\"\",Semestre1!C6)","v":20},{"$f":"IFERROR(IF(Semestre2!G6=\"\",\"\",Semestre2!G6*Semestre2!C6),\"\")","v":232.5},{"$f":"IF(Semestre2!G6=\"\",\"\",Semestre2!C6)","v":15},null,"passage en deuxième année  avec les notes ",{"$f":"IF(AND(Accueil!A23=0, Accueil!C23>=2), \"Accepté\", \"Refusé\")","v":"Accepté"}]
[null,{"$f":"IFERROR(IF(Semestre1!G7=\"\",\"\",Semestre1!G7*Semestre1!C7),\"\")","v":420},{"$f":"IF(Semestre1!G7=\"\",\"\",Semestre1!C7)","v":30},{"$f":"IFERROR(IF(Semestre2!G7=\"\",\"\",Semestre2!G7*Semestre2!C7),\"\")","v":""},{"$f":"IF(Semestre2!G7=\"\",\"\",Semestre2!C7)","v":""},null,"Passage en deuxième année (ABI )",{"$f":"IF(K4=\"Oui\",\"Accepté\",\"Refusé\")","v":"Accepté"}]
[null,{"$f":"IFERROR(IF(Semestre1!G8=\"\",\"\",Semestre1!G8*Semestre1!C8),\"\")","v":140},{"$f":"IF(Semestre1!G8=\"\",\"\",Semestre1!C8)","v":10},{"$f":"IFERROR(IF(Semestre2!G8=\"\",\"\",Semestre2!G8*Semestre2!C8),\"\")","v":280},{"$f":"IF(Semestre2!G8=\"\",\"\",Semestre2!C8)","v":20}]
[null,null,null,{"$f":"IFERROR(IF(Semestre2!G9=\"\",\"\",Semestre2!G9*Semestre2!C9),\"\")","v":""},{"$f":"IF(Semestre2!G9=\"\",\"\",Semestre2!C9)","v":""}]
[null,null,null,{"$f":"IFERROR(IF(Semestre2!G10=\"\",\"\",Semestre2!G10*Semestre2!C10),\"\")","v":""},{"$f":"IF(Semestre2!G10=\"\",\"\",Semestre2!C10)","v":""}]
[null,null,null,{"$f":"IFERROR(IF(Semestre2!G11=\"\",\"\",Semestre2!G11*Semestre2!C11),\"\")","v":""},{"$f":"IF(Semestre2!G11=\"\",\"\",Semestre2!C11)","v":""}]
["total",{"$f":"SUMIF(B6:B11,\"<>0\",B6:B11)","v":1270},{"$f":"SUMIF(C6:C11,\"<>0\",C6:C11)","v":100},{"$f":"SUMIF(D6:D14,\"<>0\",D6:D14)","v":1077.5},{"$f":"SUMIF(E6:E14,\"<>0\",E6:E14)","v":70}]
["moyenne",{"$f":"IFERROR(B15/C15,\"\")","v":12.7},null,{"$f":"IFERROR(D15/E15,\"\")","v":15.392857142857142}]
["Cpt 2",{"$f":"IFERROR(IF(Semestre1!G11=\"\",\"\",Semestre1!G11*Semestre1!C11),\"\")","v":74.166666666666671},{"$f":"IF(Semestre1!G11=\"\",\"\",Semestre1!C11)","v":5},{"$f":"IFERROR(IF(Semestre2!G14=\"\",\"\",Semestre2!G14*Semestre2!C14),\"\")","v":70},{"$f":"IF(Semestre2!G14=\"\",\"\",Semestre2!C14)","v":5}]
[null,{"$f":"IFERROR(IF(Semestre1!G12=\"\",\"\",Semestre1!G12*Semestre1!C12),\"\")","v":327.5},{"$f":"IF(Semestre1!G12=\"\",\"\",Semestre1!C12)","v":20},{"$f":"IFERROR(IF(Semestre2!G15=\"\",\"\",Semestre2!G15*Semestre2!C15),\"\")","v":120},{"$f":"IF(Semestre2!G15=\"\",\"\",Semestre2!C15)","v":10}]
[null,{"$f":"IFERROR(IF(Semestre1!G13=\"\",\"\",Semestre1!G13*Semestre1!C13),\"\")","v":195},{"$f":"IF(Semestre1!G13=\"\",\"\",Semestre1!C13)","v":15},{"$f":"IFERROR(IF(Semestre2!G16=\"\",\"\",Semestre2!G16*Semestre2!C16),\"\")","v":150},{"$f":"IF(Semestre2!G16=\"\",\"\",Semestre2!C16)","v":15}]
[null,{"$f":"IFERROR(IF(Semestre1!G14=\"\",\"\",Semestre1!G14*Semestre1!C14),\"\")","v":296.66666666666669},{"$f":"IF(Semestre1!G14=\"\",\"\",Semestre1!C14)","v":20},{"$f":"IFERROR(IF(Semestre2!G17=\"\",\"\",Semestre2!G17*Semestre2!C17),\"\")","v":240},{"$f":"IF(Semestre2!G17=\"\",\"\",Semestre2!C17)","v":15}]
[null,{"$f":"IFERROR(IF(Semestre1!G15=\"\",\"\",Semestre1!G15*Semestre1!C15),\"\")","v":500},{"$f":"IF(Semestre1!G15=\"\",\"\",Semestre1!C15)","v":40},{"$f":"IFERROR(IF(Semestre2!G18=\"\",\"\",Semestre2!G18*Semestre2!C18),\"\")","v":""},{"$f":"IF(Semestre2!G18=\"\",\"\",Semestre2!C18)","v":""}]
[null,null,null,{"$f":"IFERROR(IF(Semestre2!G19=\"\",\"\",Semestre2!G19*Semestre2!C19),\"\")","v":""},{"$f":"IF(Semestre2!G19=\"\",\"\",Semestre2!C19)","v":""}]
[null,null,null,{"$f":"IFERROR(IF(Semestre2!G20=\"\",\"\",Semestre2!G20*Semestre2!C20),\"\")","v":""},{"$f":"IF(Semestre2!G20=\"\",\"\",Semestre2!C20)","v":""}]
[null,null,null,{"$f":"IFERROR(IF(Semestre2!G21=\"\",\"\",Semestre2!G21*Semestre2!C21),\"\")","v":135},{"$f":"IF(Semestre2!G21=\"\",\"\",Semestre2!C21)","v":10}]
[null,null,null,{"$f":"IFERROR(IF(Semestre2!G22=\"\",\"\",Semestre2!G22*Semestre2!C22),\"\")","v":""},{"$f":"IF(Semestre2!G22=\"\",\"\",Semestre2!C22)","v":""}]
[null,null,null,{"$f":"IFERROR(IF(Semestre2!G23=\"\",\"\",Semestre2!G23*Semestre2!C23),\"\")","v":""},{"$f":"IF(Semestre2!G23=\"\",\"\",Semestre2!C23)","v":""}]
["total",{"$f":"SUMIF(B17:B21,\"<>0\",B17:B21)","v":1393.3333333333335},{"$f":"SUMIF(C17:C21,\"<>0\",C17:C21)","v":100},{"$f":"SUMIF(D17:D26,\"<>0\",D17:D26)","v":715},{"$f":"SUMIF(E17:E26,\"<>0\",E17:E26)","v":55}]
["moyenne",{"$f":"IFERROR(B27/C27,\"\")","v":13.933333333333335},null,{"$f":"IFERROR(D27/E27,\"\")","v":13}]
["Cpt 3",{"$f":"IFERROR(IF(Semestre1!G18=\"\",\"\",Semestre1!G18*Semestre1!C18),\"\")","v":74.166666666666671},{"$f":"IF(Semestre1!G18=\"\",\"\",Semestre1!C18)","v":5},{"$f":"IFERROR(IF(Semestre2!G26=\"\",\"\",Semestre2!G26*Semestre2!C26),\"\")","v":70},{"$f":"IF(Semestre2!G26=\"\",\"\",Semestre2!C26)","v":5}]
[null,{"$f":"IFERROR(IF(Semestre1!G19=\"\",\"\",Semestre1!G19*Semestre1!C19),\"\")","v":170},{"$f":"IF(Semestre1!G19=\"\",\"\",Semestre1!C19)","v":15},{"$f":"IFERROR(IF(Semestre2!G27=\"\",\"\",Semestre2!G27*Semestre2!C27),\"\")","v":150},{"$f":"IF(Semestre2!G27=\"\",\"\",Semestre2!C27)","v":15}]
[null,{"$f":"IFERROR(IF(Semestre1!G20=\"\",\"\",Semestre1!G20*Semestre1!C20),\"\")","v":196.2},{"$f":"IF(Semestre1!G20=\"\",\"\",Semestre1!C20)","v":15},{"$f":"IFERROR(IF(Semestre2!G28=\"\",\"\",Semestre2!G28*Semestre2!C28),\"\")","v":""},{"$f":"IF(Semestre2!G28=\"\",\"\",Semestre2!C28)","v":""}]
[null,{"$f":"IFERROR(IF(Semestre1!G21=\"\",\"\",Semestre1!G21*Semestre1!C21),\"\")","v":466.66666666666669},{"$f":"IF(Semestre1!G21=\"\",\"\",Semestre1!C21)","v":25},{"$f":"IFERROR(IF(Semestre2!G29=\"\",\"\",Semestre2!G29*Semestre2!C29),\"\")","v":350},{"$f":"IF(Semestre2!G29=\"\",\"\",Semestre2!C29)","v":25}]
[null,{"$f":"IFERROR(IF(Semestre1!G22=\"\",\"\",Semestre1!G22*Semestre1!C22),\"\")","v":262.5},{"$f":"IF(Semestre1!G22=\"\",\"\",Semestre1!C22)","v":15},{"$f":"IFERROR(IF(Semestre2!G30=\"\",\"\",Semestre2!G30*Semestre2!C30),\"\")","v":""},{"$f":"IF(Semestre2!G30=\"\",\"\",Semestre2!C30)","v":""}]
[null,{"$f":"IFERROR(IF(Semestre1!G23=\"\",\"\",Semestre1!G23*Semestre1!C23),\"\")","v":121.64999961853027},{"$f":"IF(Semestre1!G23=\"\",\"\",Semestre1!C23)","v":10},{"$f":"IFERROR(IF(Semestre2!G31=\"\",\"\",Semestre2!G31*Semestre2!C31),\"\")","v":""},{"$f":"IF(Semestre2!G31=\"\",\"\",Semestre2!C31)","v":""}]
[null,{"$f":"IFERROR(IF(Semestre1!G24=\"\",\"\",Semestre1!G24*Semestre1!C24),\"\")","v":217.5},{"$f":"IF(Semestre1!G24=\"\",\"\",Semestre1!C24)","v":15},{"$f":"IFERROR(IF(Semestre2!G32=\"\",\"\",Semestre2!G32*Semestre2!C32),\"\")","v":""},{"$f":"IF(Semestre2!G32=\"\",\"\",Semestre2!C32)","v":""}]
[null,null,null,{"$f":"IFERROR(IF(Semestre2!G33=\"\",\"\",Semestre2!G33*Semestre2!C33),\"\")","v":""},{"$f":"IF(Semestre2!G33=\"\",\"\",Semestre2!C33)","v":""}]
["total",{"$f":"SUMIF(B29:B35,\"<>0\",B29:B35)","v":1508.6833329518636},{"$f":"SUMIF(C29:C35,\"<>0\",C29:C35)","v":100},{"$f":"SUMIF(D29:D36,\"<>0\",D29:D36)","v":570},{"$f":"SUMIF(E29:E36,\"<>0\",E29:E36)","v":45}]
["moyenne",{"$f":"IFERROR(B37/C37,\"\")","v":15.086833329518635},null,{"$f":"IFERROR(D37/E37,\"\")","v":12.666666666666666}]