{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Paramètres","Clg","Clg_besoins_apports","Listes","Mode_d'emploi","Informations - Aides"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":3,"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":"Paramètres","index":0,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[6,2,6,9],[2,2,2,9],[7,2,7,7],[15,2,15,8],[17,2,17,5],[27,9,35,9],[23,2,23,7],[25,2,25,8],[9,2,9,5],[15,12,19,13],[22,2,22,9],[14,2,14,9],[10,6,11,7],[10,8,11,8]]}
[]
[]
[null,null,"Paramétrage de l'établissement"]
[]
[null,null,"Nom de l'établissement:",null,null,null,"Ville:"]
[]
[null,null,"Classes et Classement particulier"]
[null,null,"Combien avez-vous de classes spécifiques: Nsa, Ulis, Classe Relais….? \n(Vous pouvez en indiquer au maximum 3. Si vous en avez plus, contactez-nous)"]
[]
[null,null,"Le cas échéant, indiquez leurs noms ci-dessous:"]
[null,null,"Classe spécifique n°1:",null,null,null,"Classé Rep +",null,"non"]
[null,null,"Classe spécifique n°2:"]
[null,null,"Classe spécifique n°3:"]
[]
[null,null,"Options officielles"]
[null,null,"Avez-vous un enseignement de complément: Latin-Grec, Langue régionale….?"]
[]
[null,null,"Le cas échéant, sélectionnez \"oui\":"]
[null,null,"Latin ou Grec"]
[null,null,"Langue régionale"]
[null,null,"Section(s) Sportive(s)"]
[]
[null,null,"Langues"]
[null,null,"Combien de langues vivantes sont enseignées dans l'établissement?"]
[]
[null,null,"  Précisez lesquelles et pour chacune leur cadre officiel (Lv1, Lv2, Bilangue...)?"]
[]
[null,null,null,null,null,"Lv1","Lv2","Bilangue","Autre"]
[null,null,"Langue 1:","Anglais"]
[null,null,"Langue 2:"]
[null,null,"Langue 3:"]
[null,null,"Langue 4:"]
[null,null,"Langue 5:"]
[null,null,"Langue 6:"]
[null,null,"Langue 7:"]
[null,null,"Langue 8:"]

{"sheet":"Clg","index":1,"n_rows":90,"n_cols":31,"rows_kept":90,"cut":false,"hidden":false,"merged":[[3,28,3,30],[18,20,18,21],[18,24,18,25],[18,28,18,29],[35,1,38,1],[39,1,42,1],[47,1,50,1],[3,20,3,22],[89,1,90,2],[89,3,90,3],[43,1,46,1],[43,18,46,18],[3,24,3,26],[5,6,5,7],[5,9,5,10],[8,1,16,1],[18,1,18,2],[6,1,7,2],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[1,1,1,2],[1,3,1,9],[1,12,1,18],[1,10,1,11],[87,1,87,2],[86,1,86,2],[85,1,85,2],[52,1,52,2],[53,1,55,1],[6,13,7,13],[6,14,7,14],[18,3,18,5],[18,9,18,11],[18,6,18,8],[18,12,18,14],[52,3,52,5],[27,1,30,1],[31,1,34,1],[6,17,7,17],[6,15,7,15],[6,16,7,16],[5,3,5,4],[74,12,74,14],[77,12,77,14],[6,12,7,12],[82,1,82,2],[82,3,82,5],[82,6,82,8],[82,9,82,11],[82,12,82,14],[78,9,78,11],[79,9,79,11],[79,1,79,2],[75,12,75,14],[75,6,75,8],[69,3,69,5],[70,3,70,5],[71,3,71,5],[72,3,72,5],[73,3,73,5],[69,6,69,8],[77,6,77,8],[74,9,74,11],[75,9,75,11],[71,6,71,8],[78,12,78,14],[81,6,81,8],[81,9,81,11],[81,12,81,14],[72,12,72,14],[71,12,71,14],[70,12,70,14],[79,12,79,14],[76,9,76,11],[77,9,77,11],[74,3,74,5],[75,3,75,5],[76,3,76,5],[77,3,77,5],[78,3,78,5],[72,6,72,8],[73,6,73,8],[81,3,81,5],[76,6,76,8],[78,6,78,8],[79,6,79,8],[74,6,74,8],[79,3,79,5],[69,9,69,11],[70,9,70,11],[71,9,71,11],[72,9,72,11],[73,9,73,11],[57,1,57,2],[57,3,58,5],[57,6,58,8],[57,9,58,11],[65,3,65,5],[66,3,66,5],[68,3,68,5],[67,3,67,5],[70,6,70,8],[59,6,59,8],[60,6,60,8],[61,6,61,8],[62,6,62,8],[63,6,63,8],[19,1,22,1],[52,12,52,14],[65,9,65,11],[66,9,66,11],[67,9,67,11],[68,9,68,11],[66,6,66,8],[67,6,67,8],[68,6,68,8],[64,6,64,8],[65,6,65,8],[57,12,58,14],[68,12,68,14],[3,3,3,5],[3,6,3,8],[3,9,3,11],[59,3,59,5],[60,3,60,5],[61,3,61,5],[62,3,62,5],[63,3,63,5],[64,3,64,5],[59,9,59,11],[60,9,60,11],[61,9,61,11],[62,9,62,11],[63,9,63,11],[64,9,64,11],[52,6,52,8],[52,9,52,11],[6,9,7,9],[6,10,7,10],[6,11,7,11],[3,12,3,14],[23,18,26,18],[23,1,26,1],[73,12,73,14],[5,18,7,18],[89,4,90,4],[19,18,22,18],[27,18,30,18],[31,18,34,18],[35,18,38,18],[39,18,42,18],[47,18,50,18],[57,18,58,18],[59,12,59,14],[60,12,60,14],[61,12,61,14],[62,12,62,14],[63,12,63,14],[64,12,64,14],[65,12,65,14],[66,12,66,14],[67,12,67,14],[76,12,76,14],[69,12,69,14]]}
[]
[null,"DGH du Collège :",null,{"$f":"Paramètres!D5","v":0},null,null,null,null,null,null,"Ville:",null,{"$f":"Paramètres!H5","v":0}]
[]
[null,null,null,"6ème",null,null,"5ème",null,null,"4ème ",null,null,"3ème ",null,null,{"$f":"Paramètres!D11","v":0},{"$f":"Paramètres!D12","v":0},{"$f":"Paramètres!D13","v":0},"Total de divisions ",null,"Missions particulières en HP (Possible si vote au C.A)",null,null,null,"Missions statutaires \n(Décret 20-08-14)",null,null,null,"IMP \n(Indemnités de Missions particulières)"]
[null,"Effectifs : ",{"$f":"SUM(E5,H5,K5,N5,P5,Q5,R5)","v":0},"Effectif:",null,{"$f":"E5/F6","v":{"$error":"#DIV/0!"}},"Effectif:",null,{"$f":"H5/I6","v":{"$error":"#DIV/0!"}},"Effectif:",null,{"$f":"K5/L6","v":{"$error":"#DIV/0!"}},"Effectif:",null,{"$f":"N5/O6","v":{"$error":"#DIV/0!"}},null,null,null,"Hors classes spéciales",null,"Intitulé","Discipline","Heures",null,"Intitulé","Discipline","Heures",null,"Intitulé","Discipline","Indemnités"]
[null,"h/e :",{"$f":"D90/C5","v":{"$error":"#DIV/0!"}},"Nombre de divisions : ",null,null,"Nombre de divisions : ",null,null,"Nombre de divisions : ",null,null,"Nombre de divisions : ",null,null,null,null,null,{"$f":"SUM(F6,I6,L6,O6)","v":0},null,"Coordination E.P.S\n (1h dès 50h et 2h dès plus de 4 ETP d'E.P.S)","Eps",null,null,"Unss \n(3h pour tout prof d'E.P.S)","Eps",null,null,"Coordination E.P.S","Eps"]
[null,"Disciplines\n (hors langues)",null,"horaire plancher élève","horaire prof","heures prof / discipline","horaire plancher","horaire prof","heures prof / discipline","horaire plancher","horaire prof","heures prof / discipline","horaire plancher","horaire prof","heures prof / disc.","heures prof / disc.","heures prof / disc.","heures prof / disc.",null,null,"Tice site","Eps",null,null,"Heure de Labo S.V.T \n(1h par prof, si mini 8h de cours et pas d'attaché de labo)","Svt",null,null,"Heure de Labo Techno ","Technologie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heure de Labo P-C\n(1h par prof, si mini 8h de cours et pas d'attaché de labo)","Physique-Chimie",null,null,"Coordination Maths","Technologie"]
[null,"HORAIRES\nOFFICIELS","Français",4.5,4.5,{"$f":"E9*$F$6","v":0},4.5,4.5,{"$f":"H9*$I$6","v":0},4.5,4.5,{"$f":"K9*$L$6","v":0},4,4,{"$f":"N9*$O$6","v":0},null,null,null,{"$f":"SUM(F9,I9,L9,O9,P9:R9,)","v":0},null,null,null,null,null,"Heure de chorale","Education musicale",null,null,"Coordination Français","Français"]
[null,null,"Maths",4.5,4.5,{"$f":"E10*$F$6","v":0},3.5,3.5,{"$f":"H10*$I$6","v":0},3.5,3.5,0,3.5,3.5,{"$f":"N10*$O$6","v":0},null,null,null,{"$f":"SUM(F10,I10,L10,O10,P10:R10,)","v":0},null,null,null,null,null,null,null,null,null,"Coordination Anglais","Anglais"]
[null,null,"Hist-Géo",3,3,{"$f":"E11*$F$6","v":0},3,3,0,3,3,0,3.5,3.5,0,null,null,null,0,null,null,null,null,null,null,null,null,null,"Réf culture","Autres (EAO, PPRE…)"]
[null,null,"Svt",null,null,0,1.5,1.5,0,1.5,1.5,0,1.5,1.5,0,null,null,null,0,null,null,null,null,null,null,null,null,null,"Liaison Cm2-6ème","Maths"]
[null,null,"Technologie",null,null,0,1.5,1.5,0,1.5,1.5,0,1.5,1.5,0,null,null,null,0,null,null,null,null,null,null,null,null,null,"Réf décrochage","Autres (EAO, PPRE…)"]
[null,null,"Arts Plastiques",1,1,0,1,1,0,1,1,0,1,1,0,null,null,null,0,null,null,null,null,null,null,null,null,null,"Gestion voyages","Autres (EAO, PPRE…)"]
[null,null,"Education musicale",1,1,0,1,1,0,1,1,0,1,1,0,null,null,null,0,null,null,null,null,null,null,null,null,null,"Gestion FSE ","Autres (EAO, PPRE…)"]
[null,null,"Eps",4,4,0,3,3,{"$f":"H16*$I$6","v":0},3,3,0,3,3,0,null,null,null,0,null,null,null,null,null,null,null,null,null,"Secrétariat AS ","Eps"]
[null,null,"Physique-Chimie",null,null,0,1.5,1.5,{"$f":"H17*$I$6","v":0},1.5,1.5,0,1.5,1.5,0,null,null,null,{"$f":"SUM(F17,I17,L17,O17,P17:R17,)","v":0},null,null,null,null,null,null,null,null,null,"Reste","Autres (EAO, PPRE…)"]
[]
[null,"Langues ",null,"Nombre de groupes en 6ème / Horaires",null,null,"Nombre de groupes en 5ème / Horaires",null,null,"Nombre de groupes en 4ème / Horaires",null,null,"Nombre de groupes en 3ème  / Horaires",null,null,{"$f":"$P$4","v":0},{"$f":"$Q$4","v":0},{"$f":"$R$4","v":0},"Total",null,"Total des missions de complément",null,{"$f":"SUM(W6:W18)","v":0},null,"Total des heures statutaires",null,{"$f":"SUM(AA6:AA18)","v":0},null,"Total des indemnités (IMP)",null,{"$f":"SUM(AE6:AE18)","v":0}]
[null,{"$f":"Listes!D2","v":"Anglais"},{"$f":" \"LV1\" &\" \"&A20","v":"LV1 "},null,4,{"$f":"E20*D20","v":0},null,3,{"$f":"H20*G20","v":0},null,3,{"$f":"K20*J20","v":0},null,3,{"$f":"N20*M20","v":0},null,null,null,{"$f":"SUM(F20:F23,I20:I23,L20:L23,O20:O23,P20:R23)","v":0}]
[null,null,{"$f":" \"LV2\" &\" \"&A21","v":"LV2 "},null,null,null,null,2.5,0,null,2.5,0,null,2.5,0]
[null,null,{"$f":"\"Bilangue\"&\" \"&A20","v":"Bilangue "},null,3,{"$f":"E22*D22","v":0},null,null,0,null,null,0,null,null,0]
[null,null,{"$f":"\"Autres\" &\" \"&A20","v":"Autres "},null,null,0,null,null,0,null,null,0,null,null,0]
[null,{"$f":"Listes!D3","v":0},{"$f":" \"LV1\" &\" \"&A24","v":"LV1 "},null,4,{"$f":"E24*D24","v":0},null,3,0,null,3,0,null,3,0,null,null,null,{"$f":"SUM(F24:F27,I24:I27,L24:L27,O24:O27,P24:R27)","v":0}]
[null,null,{"$f":" \"LV2\" &\" \"&A25","v":"LV2 "},null,null,null,null,2.5,0,null,2.5,0,null,2.5,0]
[null,null,{"$f":"\"Bilangue\"&\" \"&A24","v":"Bilangue "},null,3,0,null,3,0,null,3,0,null,3,0]
[null,null,{"$f":"\"Autres\" &\" \"&A24","v":"Autres "},null,null,0,null,null,0,null,null,0,null,null,0]
[null,{"$f":"Listes!D4","v":0},{"$f":" \"LV1\" &\" \"&A28","v":"LV1 "},null,4,{"$f":"E28*D28","v":0},null,3,0,null,3,0,null,3,0,null,null,null,{"$f":"SUM(F28:F31,I28:I31,L28:L31,O28:O31,P28:R31)","v":0}]
[null,null,{"$f":" \"LV2\" &\" \"&A29","v":"LV2 "},null,null,null,null,2.5,0,null,2.5,0,null,2.5,0]
[null,null,{"$f":"\"Bilangue\"&\" \"&A28","v":"Bilangue "},null,3,{"$f":"E30*D30","v":0},null,2.5,0,null,2.5,0,null,2.5,0]
[null,null,{"$f":"\"Autres\" &\" \"&A28","v":"Autres "},null,null,{"$f":"E31*D31","v":0},null,null,0,null,null,0,null,null,0]
[null,{"$f":"Listes!D5","v":0},{"$f":" \"LV1\" &\" \"&A32","v":"LV1 "},null,4,{"$f":"E32*D32","v":0},null,3,0,null,3,0,null,3,0,null,null,null,{"$f":"SUM(F32:F35,I32:I35,L32:L35,O32:O35,P32:R35)","v":0}]
[null,null,{"$f":" \"LV2\" &\" \"&A33","v":"LV2 "},null,null,null,null,2.5,0,null,2.5,0,null,2.5,0]
[null,null,{"$f":"\"Bilangue\"&\" \"&A32","v":"Bilangue "},null,3,{"$f":"E34*D34","v":0},null,3,0,null,3,0,null,3,0]
[null,null,{"$f":"\"Autres\" &\" \"&A32","v":"Autres "},null,null,{"$f":"E35*D35","v":0},null,null,0,null,null,0,null,null,0]
[null,{"$f":"Listes!D6","v":0},{"$f":" \"LV1\" &\" \"&A36","v":"LV1 "},null,4,{"$f":"E36*D36","v":0},null,3,0,null,3,0,null,3,0,null,null,null,{"$f":"SUM(F36:F39,I36:I39,L36:L39,O36:O39,P36:R39)","v":0}]
[null,null,{"$f":" \"LV2\" &\" \"&A37","v":"LV2 "},null,null,null,null,2.5,0,null,2.5,0,null,2.5,0]
[null,null,{"$f":"\"Bilangue\"&\" \"&A36","v":"Bilangue "},null,3,{"$f":"E38*D38","v":0},null,3,0,null,3,0,null,3,0]
[null,null,{"$f":"\"Autres\" &\" \"&A36","v":"Autres "},null,null,{"$f":"E39*D39","v":0},null,null,0,null,null,0,null,null,0]
[null,{"$f":"Listes!D7","v":0},{"$f":" \"LV1\" &\" \"&A40","v":"LV1 "},null,4,{"$f":"E40*D40","v":0},null,3,0,null,3,0,null,3,0,null,null,null,{"$f":"SUM(F40:F43,I40:I43,L40:L43,O40:O43,P40:R43)","v":0}]
[null,null,{"$f":" \"LV2\" &\" \"&A41","v":"LV2 "},null,null,null,null,2.5,0,null,2.5,0,null,2.5,0]
[null,null,{"$f":"\"Bilangue\"&\" \"&A40","v":"Bilangue "},null,3,{"$f":"E42*D42","v":0},null,3,0,null,3,0,null,3,0]
[null,null,{"$f":"\"Autres\" &\" \"&A40","v":"Autres "},null,null,{"$f":"E43*D43","v":0},null,null,0,null,null,0,null,null,0]
[null,{"$f":"Listes!D8","v":0},{"$f":" \"LV1\" &\" \"&A44","v":"LV1 "},null,4,{"$f":"E44*D44","v":0},null,3,0,null,3,0,null,3,0,null,null,null,{"$f":"SUM(F44:F47,I44:I47,L44:L47,O44:O47,P44:R47)","v":0}]
[null,null,{"$f":" \"LV2\" &\" \"&A45","v":"LV2 "},null,null,null,null,2.5,0,null,2.5,0,null,2.5,0]
[null,null,{"$f":"\"Bilangue\"&\" \"&A44","v":"Bilangue "},null,3,{"$f":"E46*D46","v":0},null,3,0,null,3,0,null,3,0]
[null,null,{"$f":"\"Autres\" &\" \"&A44","v":"Autres "},null,null,{"$f":"E47*D47","v":0},null,null,0,null,null,0,null,null,0]
[null,{"$f":"Listes!D9","v":0},{"$f":" \"LV1\" &\" \"&A48","v":"LV1 "},null,4,{"$f":"E48*D48","v":0},null,3,0,null,3,0,null,3,0,null,null,null,{"$f":"SUM(F48:F51,I48:I51,L48:L51,O48:O51,P48:R51)","v":0}]
[null,null,{"$f":" \"LV2\" &\" \"&A49","v":"LV2 "},null,null,null,null,2.5,0,null,2.5,0,null,2.5,0]
[null,null,{"$f":"\"Bilangue\"&\" \"&A48","v":"Bilangue "},null,3,{"$f":"E50*D50","v":0},null,3,0,null,3,0,null,3,0]
[null,null,{"$f":"\"Autres\" &\" \"&A48","v":"Autres "},null,null,{"$f":"E51*D51","v":0},null,null,0,null,null,0,null,null,0]
[]
[null,"Enseignement de complément",null,"Nombre de groupes en 6ème",null,null,"Nombre de groupes en 5ème",null,null,"Nombre de groupes en 4ème",null,null,"Nombre de groupes en 3ème",null,null,null,null,null,"Total"]
[null,"Options","Latin-Grec",null,null,{"$f":"E54*D54","v":0},null,1,{"$f":"H54*G54","v":0},null,2,{"$f":"K54*J54","v":0},null,2,{"$f":"N54*M54","v":0},null,null,null,{"$f":"SUM(F54,I54,L54,O54,P54:R54)","v":0}]
[null,null,"Langue Régionale",null,null,{"$f":"E55*D55","v":0},null,1,{"$f":"H55*G55","v":0},null,2,{"$f":"K55*J55","v":0},null,2,{"$f":"N55*M55","v":0},null,null,null,{"$f":"SUM(F55,I55,L55,O55,P55:R55)","v":0}]
[null,null,"Sections Sportives Scolaires",null,null,{"$f":"E56*D56","v":0},null,null,{"$f":"H56*G56","v":0},null,null,{"$f":"K56*J56","v":0},null,null,{"$f":"N56*M56","v":0},null,null,null,{"$f":"SUM(F56,I56,L56,O56,P56:R56)","v":0}]
[]
[null,"1/2 groupes, co-intervention",null,"Niveau 6ème",null,null,"Niveau 5ème",null,null,"Niveau 4ème",null,null,"Niveau 3ème",null,null,null,null,null,"Total"]
[null,"Intitulé","Discipline"]
[null,"Marge non définie","Français",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D60:R60)","v":0}]
[null,"? En 3ème","Français",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D61:R61)","v":0}]
[null,"? En 6ème","Anglais",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Marge non définie","Hist-Géo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"1/2 groupe","allemand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Marge non définie","Maths",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Marge non définie","Technologie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Marge non définie","Physique-Chimie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Marge non définie","Svt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Cham ","Education musicale",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Cham ","Eps",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D70:R70)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Sous-total aides, co-intervention, Eao…",null,{"$f":"SUM(D60:F79)","v":0},null,null,{"$f":"SUM(G60:I79)","v":0},null,null,{"$f":"SUM(J60:L79)","v":0},null,null,{"$f":"SUM(M60:O79)","v":0},null,null,null,null,null,{"$f":"SUM(S60:S79)","v":0}]
[]
[null,null,null,"Besoins pour les 6ème",null,null,"Besoins pour les 5ème",null,null,"Besoins pour les 4ème",null,null,"Besoins pour les 3ème"]
[null,"Total des heures\n par niveau de classe",null,{"$f":"SUM(F9:F17,F20:F51,F54:F56,D60:F79)","v":0},null,null,{"$f":"SUM(I9:I17,I20:I51,I54:I56,G60:I79)","v":0},null,null,{"$f":"SUM(L9:L17,L20:L51,L54:L56,J60:L79)","v":0},null,null,{"$f":"SUM(O9:O17,O20:O51,O54:O56,M60:O79)","v":0}]
[]
[]
[null,"Total  des cours + options + aides",null,{"$f":"SUM(D83:S83)","v":0}]
[null,"Total des missions complémentaires",null,{"$f":"W19","v":0}]
[null,"Total statutaire (Coordo…)",null,{"$f":"AA19","v":0}]
[]
[null,"Besoin de DGH",null,{"$f":"SUM(D86:D88)","v":0},"H"]

{"sheet":"Clg_besoins_apports","index":2,"n_rows":44,"n_cols":31,"rows_kept":44,"cut":false,"hidden":false,"merged":[[40,2,40,3],[39,4,39,5],[40,4,40,5],[34,7,34,9],[35,8,35,9],[38,2,38,3],[34,2,34,3],[38,7,38,9],[37,2,37,3],[35,2,35,3],[36,2,36,3],[42,7,42,9],[43,8,43,9],[2,27,5,27],[2,2,2,8],[2,19,2,25],[4,2,5,2],[4,3,5,3],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,26,9],[4,4,5,4],[4,5,5,5],[3,11,4,15],[3,16,5,16],[39,2,39,3],[2,10,2,17],[2,26,5,26],[3,22,4,25],[3,21,5,21],[3,20,5,20],[3,19,5,19],[3,10,5,10],[31,2,31,3],[32,2,32,3],[33,2,33,3],[3,17,5,17],[29,7,29,9],[29,2,29,5],[30,2,30,3]]}
[]
[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,null,{"$f":"IF(Paramètres!$I$11=\"oui\",1.1,1)","v":1}]
[null,null,"Reprise des besoins du collège (TRMD)",null,null,null,null,null,null,null,"Organisation des services  (ORS)",null,null,null,null,null,null,null,null,"Ajustements: suppression/créations, \nbmp, compléments de services, HSA...",null,null,null,null,null,null,"Apports corrigés\n\n(doit être \négal à 0)","Disciplines"]
[null,null,null,null,null,null,null,null,null,null,"Disciplines","Indiquez ci-dessous les postes implantés \npour chaque discipline",null,null,null,null,"Total des Apports initiaux","Ecart Besoins \n-\n Apports",null,"Créations (en nombre de postes)","Suppressions (en nombres de postes)","Création / suppression \n(en heures = +18 ou -18 pour PLC ; +20/-20 en Eps)","Ajustements "]
[null,null,"Disciplines","Total cours obligatoires","Total options officielles ","Total aides + soutien + options locales","Total  Missions complément","Total Statutaire","Total des besoins"]
[null,null,null,null,null,null,null,null,null,null,null,18,15,20,17,"Autre (Temps partiel, Référent Ulis,…)",null,null,null,null,null,null,"CSD  \n(dont segpa)","CSR","BMP","HSA"]
[null,null,"Français",{"$f":"IF(VLOOKUP($C7,Clg!$C$9:$S$17,17,)=\"\",\"\",VLOOKUP($C7,Clg!$C$9:$S$17,17,))","v":0},{"$f":"Clg!$S$54","v":0},{"$f":"Recherchevliste($C7,Clg!$C$60:$S$79,17)","v":0},{"$f":"Recherchevliste($C7,Clg!$V$6:$W$18,2)","v":0},{"$f":"Recherchevliste($C7,Clg!$Z$6:$AA$18,2)","v":0},{"$f":"SUM(D7:H7)","v":0},null,{"$f":"C7","v":"Français"},null,null,null,null,null,{"$f":"((L7*$L$6)+(M7*$M$6)+P7)/$AE$2","v":0},{"$f":"I7-Q7","v":0},null,null,null,null,null,null,null,null,{"$f":"(R7+W7)-(((V7+X7+Y7)/$AE$2)+Z7)","v":0},{"$f":"C7","v":"Français"}]
[null,null,"Maths",{"$f":"IF(VLOOKUP($C8,Clg!$C$9:$S$17,17,)=\"\",\"\",VLOOKUP($C8,Clg!$C$9:$S$17,17,))","v":0},null,{"$f":"Recherchevliste($C8,Clg!$C$60:$S$79,17)","v":0},{"$f":"Recherchevliste($C8,Clg!$V$6:$W$18,2)","v":0},{"$f":"Recherchevliste($C8,Clg!$Z$6:$AA$18,2)","v":0},{"$f":"SUM(D8:H8)","v":0},null,{"$f":"C8","v":"Maths"},null,null,null,null,null,{"$f":"((L8*$L$6)+(M8*$M$6)+P8)/$AE$2","v":0},{"$f":"I8-Q8","v":0},null,null,null,null,null,null,null,null,{"$f":"(R8+W8)-(((V8+X8+Y8)/$AE$2)+Z8)","v":0},{"$f":"C8","v":"Maths"}]
[null,null,"Hist-Géo",{"$f":"IF(VLOOKUP($C9,Clg!$C$9:$S$17,17,)=\"\",\"\",VLOOKUP($C9,Clg!$C$9:$S$17,17,))","v":0},null,{"$f":"Recherchevliste($C9,Clg!$C$60:$S$79,17)","v":0},{"$f":"Recherchevliste($C9,Clg!$V$6:$W$18,2)","v":0},{"$f":"Recherchevliste($C9,Clg!$Z$6:$AA$18,2)","v":0},{"$f":"SUM(D9:H9)","v":0},null,"Hist-Géo",null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,"Hist-Géo"]
[null,null,"Svt",{"$f":"IF(VLOOKUP($C10,Clg!$C$9:$S$17,17,)=\"\",\"\",VLOOKUP($C10,Clg!$C$9:$S$17,17,))","v":0},null,{"$f":"Recherchevliste($C10,Clg!$C$60:$S$79,17)","v":0},{"$f":"Recherchevliste($C10,Clg!$V$6:$W$18,2)","v":0},{"$f":"Recherchevliste($C10,Clg!$Z$6:$AA$18,2)","v":0},0,null,"Svt",null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,"Svt"]
[null,null,"Technologie",{"$f":"IF(VLOOKUP($C11,Clg!$C$9:$S$17,17,)=\"\",\"\",VLOOKUP($C11,Clg!$C$9:$S$17,17,))","v":0},null,{"$f":"Recherchevliste($C11,Clg!$C$60:$S$79,17)","v":0},{"$f":"Recherchevliste($C11,Clg!$V$6:$W$18,2)","v":0},{"$f":"Recherchevliste($C11,Clg!$Z$6:$AA$18,2)","v":0},0,null,"Technologie",null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,{"$f":"(R11+W11)-(((V11+X11+Y11)/$AE$2)+Z11)","v":0},"Technologie"]
[null,null,"Arts Plastiques",{"$f":"IF(VLOOKUP($C12,Clg!$C$9:$S$17,17,)=\"\",\"\",VLOOKUP($C12,Clg!$C$9:$S$17,17,))","v":0},null,{"$f":"Recherchevliste($C12,Clg!$C$60:$S$79,17)","v":0},{"$f":"Recherchevliste($C12,Clg!$V$6:$W$18,2)","v":0},{"$f":"Recherchevliste($C12,Clg!$Z$6:$AA$18,2)","v":0},0,null,"Arts Plastiques",null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,"Arts Plastiques"]
[null,null,"Education musicale",{"$f":"IF(VLOOKUP($C13,Clg!$C$9:$S$17,17,)=\"\",\"\",VLOOKUP($C13,Clg!$C$9:$S$17,17,))","v":0},null,{"$f":"Recherchevliste($C13,Clg!$C$60:$S$79,17)","v":0},{"$f":"Recherchevliste($C13,Clg!$V$6:$W$18,2)","v":0},{"$f":"Recherchevliste($C13,Clg!$Z$6:$AA$18,2)","v":0},0,null,"Education musicale",null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,"Education musicale"]
[null,null,"Eps",{"$f":"IF(VLOOKUP($C14,Clg!$C$9:$S$17,17,)=\"\",\"\",VLOOKUP($C14,Clg!$C$9:$S$17,17,))","v":0},{"$f":"Clg!$S$56","v":0},{"$f":"Recherchevliste($C14,Clg!$C$60:$S$79,17)","v":0},{"$f":"Recherchevliste($C14,Clg!$V$6:$W$18,2)","v":0},{"$f":"Recherchevliste($C14,Clg!$Z$6:$AA$18,2)","v":0},0,null,"Eps",null,null,null,null,null,{"$f":"((N14*$N$6)+(O14*$O$6)+P14)/$AE$2","v":0},0,null,null,null,null,null,null,null,null,0,"Eps"]
[null,null,"Physique-Chimie",{"$f":"IF(VLOOKUP($C15,Clg!$C$9:$S$17,17,)=\"\",\"\",VLOOKUP($C15,Clg!$C$9:$S$17,17,))","v":0},null,{"$f":"Recherchevliste($C15,Clg!$C$60:$S$79,17)","v":0},{"$f":"Recherchevliste($C15,Clg!$V$6:$W$18,2)","v":0},{"$f":"Recherchevliste($C15,Clg!$Z$6:$AA$18,2)","v":0},0,null,"Physique-Chimie",null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,"Physique-Chimie"]
[null,null,{"$f":"Paramètres!$D$29","v":"Anglais"},{"$f":"IF(VLOOKUP($C16,Clg!$B$20:$S$51,18,)=\"\",\"\",VLOOKUP($C16,Clg!$B$20:$S$51,18,))","v":0},null,{"$f":"Recherchevliste($C16,Clg!$C$60:$S$79,17)","v":0},{"$f":"Recherchevliste($C16,Clg!$V$6:$W$18,2)","v":0},{"$f":"Recherchevliste($C16,Clg!$Z$6:$AA$18,2)","v":0},0,null,"Anglais",null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,"Anglais"]
[null,null,{"$f":"Paramètres!$D$30","v":0},{"$f":"IF(VLOOKUP($C17,Clg!$B$20:$S$51,18,)=\"\",\"\",VLOOKUP($C17,Clg!$B$20:$S$51,18,))","v":0},null,{"$f":"Recherchevliste($C17,Clg!$C$60:$S$79,17)","v":0},{"$f":"Recherchevliste($C17,Clg!$V$6:$W$18,2)","v":0},{"$f":"Recherchevliste($C17,Clg!$Z$6:$AA$18,2)","v":0},0,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,0]
[null,null,{"$f":"Paramètres!$D$31","v":0},{"$f":"IF(VLOOKUP($C18,Clg!$B$20:$S$51,18,)=\"\",\"\",VLOOKUP($C18,Clg!$B$20:$S$51,18,))","v":0},null,{"$f":"Recherchevliste($C18,Clg!$C$60:$S$79,17)","v":0},{"$f":"Recherchevliste($C18,Clg!$V$6:$W$18,2)","v":0},{"$f":"Recherchevliste($C18,Clg!$Z$6:$AA$18,2)","v":0},0,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,0]
[null,null,{"$f":"Paramètres!$D$32","v":0},{"$f":"IF(VLOOKUP($C19,Clg!$B$20:$S$51,18,)=\"\",\"\",VLOOKUP($C19,Clg!$B$20:$S$51,18,))","v":0},null,{"$f":"Recherchevliste($C19,Clg!$C$60:$S$79,17)","v":0},{"$f":"Recherchevliste($C19,Clg!$V$6:$W$18,2)","v":0},{"$f":"Recherchevliste($C19,Clg!$Z$6:$AA$18,2)","v":0},{"$f":"SUM(D19:H19)","v":0},null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,0]
[null,null,{"$f":"Paramètres!$D$33","v":0},{"$f":"IF(VLOOKUP($C20,Clg!$B$20:$S$51,18,)=\"\",\"\",VLOOKUP($C20,Clg!$B$20:$S$51,18,))","v":0},null,{"$f":"Recherchevliste($C20,Clg!$C$60:$S$79,17)","v":0},{"$f":"Recherchevliste($C20,Clg!$V$6:$W$18,2)","v":0},{"$f":"Recherchevliste($C20,Clg!$Z$6:$AA$18,2)","v":0},{"$f":"SUM(D20:H20)","v":0},null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,0]
[null,null,{"$f":"Paramètres!$D$34","v":0},{"$f":"IF(VLOOKUP($C21,Clg!$B$20:$S$51,18,)=\"\",\"\",VLOOKUP($C21,Clg!$B$20:$S$51,18,))","v":0},null,{"$f":"Recherchevliste($C21,Clg!$C$60:$S$79,17)","v":0},{"$f":"Recherchevliste($C21,Clg!$V$6:$W$18,2)","v":0},{"$f":"Recherchevliste($C21,Clg!$Z$6:$AA$18,2)","v":0},{"$f":"SUM(D21:H21)","v":0},null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,0]
[null,null,{"$f":"Paramètres!$D$35","v":0},{"$f":"IF(VLOOKUP($C22,Clg!$B$20:$S$51,18,)=\"\",\"\",VLOOKUP($C22,Clg!$B$20:$S$51,18,))","v":0},null,{"$f":"Recherchevliste($C22,Clg!$C$60:$S$79,17)","v":0},{"$f":"Recherchevliste($C22,Clg!$V$6:$W$18,2)","v":0},{"$f":"Recherchevliste($C22,Clg!$Z$6:$AA$18,2)","v":0},{"$f":"SUM(D22:H22)","v":0},null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,0]
[null,null,{"$f":"Paramètres!$D$36","v":0},{"$f":"IF(VLOOKUP($C23,Clg!$B$20:$S$51,18,)=\"\",\"\",VLOOKUP($C23,Clg!$B$20:$S$51,18,))","v":0},null,{"$f":"Recherchevliste($C23,Clg!$C$60:$S$79,17)","v":0},{"$f":"Recherchevliste($C23,Clg!$V$6:$W$18,2)","v":0},{"$f":"Recherchevliste($C23,Clg!$Z$6:$AA$18,2)","v":0},0,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,0]
[null,null,"Référent Ulis (hors secondaire)",null,null,{"$f":"Recherchevliste($C24,Clg!$C$60:$S$79,17)","v":0},{"$f":"Recherchevliste($C24,Clg!$V$6:$W$18,2)","v":0},{"$f":"Recherchevliste($C24,Clg!$Z$6:$AA$18,2)","v":0},{"$f":"SUM(D24:H24)","v":0},null,"Référent Ulis (hors secondaire)",null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,"Référent Ulis (hors secondaire)"]
[null,null,"Professeur d'appui (hors secondaire)",null,null,{"$f":"Recherchevliste($C25,Clg!$C$60:$S$79,17)","v":0},{"$f":"Recherchevliste($C25,Clg!$V$6:$W$18,2)","v":0},{"$f":"Recherchevliste($C25,Clg!$Z$6:$AA$18,2)","v":0},{"$f":"SUM(D25:H25)","v":0},null,"Professeur d'appui (hors secondaire)",null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,"Professeur d'appui (hors secondaire)"]
[null,null,"Autres (EAO, PPRE…)",null,null,{"$f":"Recherchevliste($C26,Clg!$C$60:$S$79,17)","v":0},{"$f":"Recherchevliste($C26,Clg!$V$6:$W$18,2)","v":0},{"$f":"Recherchevliste($C26,Clg!$Z$6:$AA$18,2)","v":0},{"$f":"SUM(D26:H26)","v":0},null,"Autres (EAO, PPRE…)",null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,"Autres (EAO, PPRE…)"]
[null,null,"Total",{"$f":"SUM(D7:D26)","v":0},0,0,0,0,0,null,"Total",{"$f":"SUM(L7:L26)","v":0},{"$f":"SUM(M7:M26)","v":0},0,0,{"$f":"SUM(P7:P26)","v":0},{"$f":"SUM(Q7:Q26)","v":0},0,null,{"$f":"SUM(T7:T26)","v":0},0,0,0,0,0,0,{"$f":"SUM(AA7:AA26)","v":0},"Total"]
[]
[]
[null,null,"Synthèse des besoins",null,null,null,null,"DGH donnée par l'I.A"]
[null,null,"Heures",null,"En Heures","En %",null,"Heures","En Heures","En %"]
[null,null,"Heures postes",null,{"$f":"Q27+V27+X27+Y27-W27","v":0},{"$f":"E32/$E$34","v":{"$error":"#DIV/0!"}},null,"Heures postes",null,{"$f":"I32/I34","v":{"$error":"#DIV/0!"}}]
[null,null,"Hsa",null,{"$f":"Z27","v":0},{"$f":"E33/$E$34","v":{"$error":"#DIV/0!"}},null,"Hsa",null,{"$f":"I33/I34","v":{"$error":"#DIV/0!"}}]
[null,null,"DGH",null,{"$f":"SUM(E32:E33)","v":0},{"$f":"E34/$E$34","v":{"$error":"#DIV/0!"}},null,"DGH Totale",{"$f":"I32+I33","v":0},{"$f":"I34/I34","v":{"$error":"#DIV/0!"}}]
[null,null,"Postes",null,"En nombre","En %",null,"IMP donnée par l'I.A"]
[null,null,"Postes dans le collège",null,{"$f":"SUM($L$27:$O$27)+COUNTA(P7:P26)","v":0},{"$f":"E36/E36","v":{"$error":"#DIV/0!"}},null,"IMP"]
[null,null,"Postes créés",null,{"$f":"T27","v":0},{"$f":"E37/$E$36","v":{"$error":"#DIV/0!"}}]
[null,null,"Postes supprimés",null,{"$f":"U27","v":0},{"$f":"E38/$E$36","v":{"$error":"#DIV/0!"}}]
[null,null,"Postes à cheval (Tzr…)",null,{"$f":"COUNTA(W7:Y26)","v":0},{"$f":"E39/($E$36+$E$39)","v":{"$error":"#DIV/0!"}},null,"Demandes du C.A"]
[null,null,"IMP",null,"En nombre",null,null,"Heures postes ",{"$f":"E32-I32","v":0}]
[null,null,"Missions particulières",null,{"$f":"Clg!AE19","v":0},null,null,"Hsa",{"$f":"E33-I33","v":0}]
[null,null,null,null,null,null,null,"Total  DGH",{"$f":"E34-I34","v":0}]
[null,null,null,null,null,null,null,"IMP"]
[null,null,null,null,null,null,null,"IMP",{"$f":"E41-I36","v":0}]

{"sheet":"Listes","index":3,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[null,"Disciplines",null,"Langues",null,"oui"]
[null,"Français",null,{"$f":"Paramètres!D29","v":"Anglais"},null,"non"]
[null,"Maths",null,{"$f":"Paramètres!D30","v":0}]
[null,"Hist-Géo",null,{"$f":"Paramètres!D31","v":0}]
[null,"Svt",null,{"$f":"Paramètres!D32","v":0}]
[null,"Technologie",null,{"$f":"Paramètres!D33","v":0}]
[null,"Arts Plastiques",null,{"$f":"Paramètres!D34","v":0}]
[null,"Education musicale",null,{"$f":"Paramètres!D35","v":0}]
[null,"Eps",null,{"$f":"Paramètres!D36","v":0}]
[null,"Physique-Chimie"]
[null,"Référent Ulis (hors secondaire)"]
[null,"Professeur d'appui (hors secondaire)"]
[null,"Autres (EAO, PPRE…)"]
[null,{"$f":"D2","v":"Anglais"}]
[null,{"$f":"D3","v":0}]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]

{"sheet":"Mode_d'emploi","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Informations - Aides","index":5,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,2,2,8],[7,2,7,8],[8,2,8,8],[9,2,9,8],[10,2,10,8],[25,6,25,15],[3,2,6,8],[11,2,11,8],[13,2,13,8],[14,2,14,8],[15,2,15,8]]}
[]
[]
[null,null,"DGH Collège"]
[null,null,"Aider à une meilleure compréhension de la DGH et faciliter l'élaboration de propositions alternatives \ncomplètes et précises."]
[]
[]
[]
[null,null,"Cette outil a été réalisée par"]
[null,null,"des militants au Snep-Fsu"]
[]
[]
[]
[]
[null,null,"Pour toutes remarques et/ou pour télécharger la dernière version de ce fichier :"]
[null,null,"s2-35@snepfsu.net"]
[null,null,"Version du 16/12/2022"]