{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Interface","Fac 1° Année","Fac 2° Année","Fac 3° Année","Carton"],"not_rendered":{"charts":0,"images":29,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Interface","index":0,"n_rows":25,"n_cols":23,"rows_kept":25,"cut":false,"hidden":false,"merged":[[11,21,15,22],[9,21,10,21],[9,22,10,22],[12,13,12,14],[8,5,8,6],[9,5,9,6],[10,5,10,6],[12,5,12,6],[13,5,13,6],[10,13,10,14],[23,19,24,20],[14,11,14,18],[24,6,24,7],[24,8,24,13],[23,15,24,18],[14,5,14,6],[1,4,5,18],[24,22,24,23],[23,6,23,13],[0,2,0,20],[1,23,4,23],[5,23,6,23],[22,11,22,20],[7,21,7,22],[6,21,6,22],[22,8,22,10],[7,23,8,23],[7,4,7,18],[8,12,8,17],[9,12,9,17],[11,13,11,14],[15,5,16,18]]}
[null,null,{"$f":"Carton!AD9","v":"Calcul la Note du Rattrapage"}]
[null,null,null,null,"Saisir dans les différentes feuilles,                                                                Vos notes et Coefficients                                                                               Afin de déterminer la note que vous devrez avoir                                     Au rattrapage pour valider votre année"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date du jour"]
[null,null,null,null,"Pour la Fac de droit de Clermont-Ferrant",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2016-10-29"}]
[null,null,null,null,"S1",{"$f":"'Fac 1° Année'!G15","v":0},null,null,null,null,null,null,"Et aussi pour d'autres fac"]
[null,null,null,null,"S2",{"$f":"'Fac 1° Année'!G30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MP =",1234]
[null,null,null,null,"A1",{"$f":"'Fac 1° Année'!J20","v":0},null,null,null,null,null,null,"S5",{"$f":"'Fac 3° Année'!G15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"S6",{"$f":"'Fac 3° Année'!G30","v":0}]
[null,null,null,null,"S3",{"$f":"'Fac 2° Année'!G15","v":0},null,null,null,null,null,null,"A3",{"$f":"'Fac 3° Année'!J20","v":0}]
[null,null,null,null,"S4",{"$f":"'Fac 2° Année'!G30","v":0}]
[null,null,null,null,"A2",{"$f":"'Fac 2° Année'!J20","v":0},null,null,null,null,null,"Qui aurraient le même"]
[null,null,null,null,null,"Mode de calcul pour les rattrapages"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Développer par le",null,null,null,null,null,null,null,null,"Version : ",null,null,null,{"$f":"Carton!AD11","v":"2,02"}]
[null,null,null,null,null,null,"Site :",null,{"$f":"Carton!AD14","v":"Mich-Logiciel.fr"},null,null,null,null,null,null,null,null,null,null,null,null,"N° Série :",{"$f":"Carton!AD13","v":"SR-2016-06-0001-AM"}]

{"sheet":"Fac 1° Année","index":1,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,4,29,5],[19,8,20,8],[19,9,20,9],[1,1,2,1],[1,2,1,6],[1,8,2,8],[1,9,2,9],[16,1,17,1],[16,2,16,6],[16,8,17,8],[16,9,17,9],[14,4,14,5]]}
[]
[null,null,"Fac Semèste 1",null,null,null,null,null,"Note de Ratrapage"]
[null,null,"Matière","Note sem ","Coef","Note calcul","Note total"]
[null,1,null,null,30,{"$f":"IF(D4=0,0,IF(D4>$J$2,D4,$J$2))","v":0},{"$f":"F4*E4","v":0}]
[null,2,null,null,null,0,0]
[null,3,null,null,null,0,0]
[null,4,null,null,null,0,0]
[null,5,null,null,null,0,0]
[null,6,null,null,null,0,0]
[null,7,null,null,null,0,0]
[null,8,null,null,null,0,0]
[null,9,null,null,null,0,0]
[null,10,null,null,null,0,0]
[null,null,null,"Total Coef",{"$f":"SUM(E4:E13)","v":30},"Point",{"$f":"SUM(G4:G12)","v":0}]
[null,null,null,null,"Note Semèstre",null,{"$f":"G14/E14","v":0}]
[]
[null,null,"Fac Semèste 2",null,null,null,null,null,"Note de Ratrapage"]
[null,null,"Matière","Note sem ","Coef","Note calcul","Note total"]
[null,1,null,null,30,{"$f":"IF(D19=0,0,IF(D19>$J$17,D19,$J$17))","v":0},{"$f":"F19*E19","v":0}]
[null,2,null,null,null,0,0,null,"Note Année",{"$f":"(G15+G30)/2","v":0}]
[null,3,null,null,null,0,0]
[null,4,null,null,null,0,0]
[null,5,null,null,null,0,0]
[null,6,null,null,null,0,0]
[null,7,null,null,null,0,0]
[null,8,null,null,null,0,0]
[null,9,null,null,null,0,0]
[null,10,null,null,null,{"$f":"IF(D28=0,0,IF(D28>$J$17,D28,$J$17))","v":0},0]
[null,null,null,"Total Coef",{"$f":"SUM(E19:E28)","v":30},"Point",{"$f":"SUM(G19:G27)","v":0}]
[null,null,null,null,"Note Semèstre",null,{"$f":"G29/E29","v":0}]

{"sheet":"Fac 2° Année","index":2,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,4,29,5],[19,8,20,8],[19,9,20,9],[1,1,2,1],[1,2,1,6],[1,8,2,8],[1,9,2,9],[16,1,17,1],[16,2,16,6],[16,8,17,8],[16,9,17,9],[14,4,14,5]]}
[]
[null,null,"Fac Semèste 3",null,null,null,null,null,"Note de Ratrapage"]
[null,null,"Matière","Note sem ","Coef","Note calcul","Note total"]
[null,1,null,null,30,{"$f":"IF(D4=0,0,IF(D4>$J$2,D4,$J$2))","v":0},{"$f":"F4*E4","v":0}]
[null,2,null,null,null,0,0]
[null,3,null,null,null,0,0]
[null,4,null,null,null,0,0]
[null,5,null,null,null,0,0]
[null,6,null,null,null,0,0]
[null,7,null,null,null,0,0]
[null,8,null,null,null,0,0]
[null,9,null,null,null,0,0]
[null,10,null,null,null,0,0]
[null,null,null,"Total Coef",{"$f":"SUM(E4:E13)","v":30},"Point",{"$f":"SUM(G4:G12)","v":0}]
[null,null,null,null,"Note Semèstre",null,{"$f":"G14/E14","v":0}]
[]
[null,null,"Fac Semèste 4",null,null,null,null,null,"Note de Ratrapage"]
[null,null,"Matière","Note sem ","Coef","Note calcul","Note total"]
[null,1,null,null,30,{"$f":"IF(D19=0,0,IF(D19>$J$17,D19,$J$17))","v":0},{"$f":"F19*E19","v":0}]
[null,2,null,null,null,0,0,null,"Note Année",{"$f":"(G15+G30)/2","v":0}]
[null,3,null,null,null,0,0]
[null,4,null,null,null,0,0]
[null,5,null,null,null,0,0]
[null,6,null,null,null,0,0]
[null,7,null,null,null,0,0]
[null,8,null,null,null,0,0]
[null,9,null,null,null,0,0]
[null,10,null,null,null,{"$f":"IF(D28=0,0,IF(D28>$J$17,D28,$J$17))","v":0},0]
[null,null,null,"Total Coef",{"$f":"SUM(E19:E28)","v":30},"Point",{"$f":"SUM(G19:G27)","v":0}]
[null,null,null,null,"Note Semèstre",null,{"$f":"G29/E29","v":0}]

{"sheet":"Fac 3° Année","index":3,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,4,29,5],[19,8,20,8],[19,9,20,9],[1,1,2,1],[1,2,1,6],[1,8,2,8],[1,9,2,9],[16,1,17,1],[16,2,16,6],[16,8,17,8],[16,9,17,9],[14,4,14,5]]}
[]
[null,null,"Fac Semèste 5",null,null,null,null,null,"Note de Ratrapage"]
[null,null,"Matière","Note sem ","Coef","Note calcul","Note total"]
[null,1,null,null,30,{"$f":"IF(D4=0,0,IF(D4>$J$2,D4,$J$2))","v":0},{"$f":"F4*E4","v":0}]
[null,2,null,null,null,0,0]
[null,3,null,null,null,0,0]
[null,4,null,null,null,0,0]
[null,5,null,null,null,0,0]
[null,6,null,null,null,0,0]
[null,7,null,null,null,0,0]
[null,8,null,null,null,0,0]
[null,9,null,null,null,0,0]
[null,10,null,null,null,0,0]
[null,null,null,"Total Coef",{"$f":"SUM(E4:E13)","v":30},"Point",{"$f":"SUM(G4:G12)","v":0}]
[null,null,null,null,"Note Semèstre",null,{"$f":"G14/E14","v":0}]
[]
[null,null,"Fac Semèste 6",null,null,null,null,null,"Note de Ratrapage"]
[null,null,"Matière","Note sem ","Coef","Note calcul","Note total"]
[null,1,null,null,30,{"$f":"IF(D19=0,0,IF(D19>$J$17,D19,$J$17))","v":0},{"$f":"F19*E19","v":0}]
[null,2,null,null,null,0,0,null,"Note Année",{"$f":"(G15+G30)/2","v":0}]
[null,3,null,null,null,0,0]
[null,4,null,null,null,0,0]
[null,5,null,null,null,0,0]
[null,6,null,null,null,0,0]
[null,7,null,null,null,0,0]
[null,8,null,null,null,0,0]
[null,9,null,null,null,0,0]
[null,10,null,null,null,{"$f":"IF(D28=0,0,IF(D28>$J$17,D28,$J$17))","v":0},0]
[null,null,null,"Total Coef",{"$f":"SUM(E19:E28)","v":30},"Point",{"$f":"SUM(G19:G27)","v":0}]
[null,null,null,null,"Note Semèstre",null,{"$f":"G29/E29","v":0}]

{"sheet":"Carton","index":4,"n_rows":16,"n_cols":31,"rows_kept":16,"cut":false,"hidden":true,"merged":[[14,29,14,30],[15,29,15,30],[11,29,11,30],[12,29,12,30],[13,29,13,30]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-07-12",30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calcul la Note du Rattrapage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conf-12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2,02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Michel Archidiacono"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SR-2016-06-0001-AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mich-Logiciel.fr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEN(AD9)","v":28}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RIGHT(AD9,AD15-5)","v":"l la Note du Rattrapage"}]