{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["CRAM","FRAIS","CONGES"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":19,"comments":2,"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":"CRAM","index":0,"n_rows":54,"n_cols":34,"rows_kept":54,"cut":false,"hidden":false,"merged":[[2,11,2,17],[50,0,50,1],[52,0,52,1],[0,0,0,33],[2,21,2,29],[7,0,7,1],[30,0,30,1],[8,0,8,1],[5,23,5,25],[2,2,2,6],[4,2,4,6]]}
["COMPTE RENDU MENSUEL D'ACTIVITE"]
[]
[null,"Nom :",null,null,null,null,null,null,null,null,"Activité :","CGI",null,null,null,null,null,null,null,null,null,"2016-10-01"]
[]
[null,"Prénom :",null,null,null,null,null,null,null,null,null,"Nb jours ouvrés :",{"$f":"NBJoursOuvres(MOISANNEE,DATE(YEAR(MOISANNEE),MONTH(MOISANNEE)+1,1)-1)","v":21},null,null,null,null,"Repas site :",0,null,null,null,"TR :",{"$f":"ROUNDDOWN(SUM(C11:C14),0)-S5","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Nb jours travaillés :",{"$f":"ROUND(SUM(C11:C14),0)","v":0}]
[]
[" Identification  des  Affaires et activités",null,"Total","WE","WE",null,null,null,null,null,"WE","WE",null,null,null,null,null,"WE","WE",null,null,null,null,null,"WE","WE",null,null,null,null,null,"WE","WE"]
[" L i b e l l é",null,"Jours",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[]
["Client","JOURS",{"$f":"MASOMME(D11:AH11)","v":" "}]
[null,"NUITS"," "]
[null,null," "]
[null,null," "]
[null,null," "]
["Formation","Donnée en interne"," "]
[null,"Reçue en interne"," "]
[null,"Reçue en externe"," "]
["Absences","RTT"," "]
[null,"Retour école"," "]
[null,"Congés payés"," "]
[null,"Congés sans solde"," "]
[null,"Congés anticipés"," "]
[null,"Journées exceptionnelles"," "]
[null,"Absence autorisée"," "]
[null,"Maladie"," "]
["Autres",null," "]
[null,null,{"$f":"MASOMME(D28:AH28)","v":" "}]
[]
[null,"              T o t a l ",{"$f":"MASOMME(D30:AH30)","v":" "},{"$f":"MASOMME(D11:D28)","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
["TRAVAUX EXCEPTIONNELS"]
["(en heure)","Heures supplémentaires Jour Semaine",{"$f":"SUM(D32:AH32)","v":0}]
["(en heure)","Heures supplémentaires Nuit Semaine",{"$f":"SUM(D33:AH33)","v":0}]
["(en heure)","Heures supplémentaires Jour Samedi",0]
["(en heure)","Heures supplémentaires Soir Samedi",0]
["(en heure)","Heures supplémentaires Jour Dimanche ou JF",0]
["(en heure)","Heures supplémentaires Soir Dimanche ou JF",0]
[null,null,{"$f":"MASOMME(D38:AH38)","v":" "}]
[null,null," "]
["(en jour)","Astreinte",{"$f":"SUM(D40:AH40)","v":0}]
["(en heure)","Inter. Astreinte Jour Semaine",0]
["(en heure)","Inter. Astreinte Nuit Semaine",0]
["(en heure)","Inter. Astreinte Jour Samedi",0]
["(en heure)","Inter. Astreinte Soir Samedi",0]
["(en heure)","Inter. Astreinte Jour Dimanche ou JF",0]
["(en heure)","Inter. Astreinte Soir Dimanche ou JF",0]
[null,null," "]
[null,null,{"$f":"MASOMME(D48:AH48)","v":" "}]
[null,"Total Heures Supplémentaires",{"$f":"+C32+C33+C34+C35+C36+C37","v":0},{"$f":"IF(SUM(D32:D37)=0,0,MASOMME(D32:D37))","v":0},{"$f":"IF(SUM(E32:E37)=0,0,MASOMME(E32:E37))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Interventions Astreintes",{"$f":"+C41+C42+C43+C44+C45+C46","v":0},{"$f":"IF(SUM(D41:D46)=0,0,MASOMME(D41:D46))","v":0},{"$f":"IF(SUM(E41:E46)=0,0,MASOMME(E41:E46))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"              T o t a l   G é n é r a l ",{"$f":"MASOMME(D52:AH52)","v":" "},{"$f":"MONTOTAL(D30,D49,D40,D50,D50,D9)","v":" "},{"$f":"MONTOTAL(E30,E49,E40,E50,E50,E9)","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,"    Commentaires"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Visa collaborateur",null,null,null,null,null,null,null,null,"Visa C.P. ou Client"]

{"sheet":"FRAIS","index":1,"n_rows":36,"n_cols":18,"rows_kept":36,"cut":false,"hidden":false,"merged":[[2,22,2,30],[0,0,0,17],[28,0,28,2],[8,3,8,16],[4,11,4,14]]}
[]
[]
[null,"Nom :",{"$f":"+NOM","v":0},null,null,null,null,null,null,null,null,"Activité :",{"$f":"RECOPIE([0]!ACTIVITE)","v":"CGI"}]
[]
[null,"Prénom :",{"$f":"+PRENOM","v":0},null,null,null,null,null,null,null,null,{"$f":"+CRAM!V3","v":"2016-10-01"}]
[]
[]
[]
[null,null,null,"Détail des frais",null,null,null,null,null,null,null,null,null,null,null,null,null,"Cumul par affaire et activité"]
["Code d'imputation affaires et activités","Client","'R' : refacturation client\n'N' sinon","Trajets/Transports     (kilomètres)","Indemnités kilom.    (euro)","Taxi","Location de voiture","Essence","Péage","Parking","Train","Avion","Hôtel","Restaurant","Fournitures","Documentation\n(revues, livres …)","Divers"]
[null,null,null,null,{"$f":"+D11*0.3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MASOMME(E11:Q11)","v":" "}]
[null,null,null,null,{"$f":"+D12*0.3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MASOMME(E12:Q12)","v":" "}]
[null,null,null,null,0,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,0,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,0,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,0,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,0,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,0,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,0,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,0,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," "]
["Total",null,null,{"$f":"MASOMME(D11:D28)","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[]
["Visa du collaborateur",null,null,null,null,null,"Observations :"]
[]
[]
[]
[]
["Visa de la direction"]

{"sheet":"CONGES","index":2,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,7],[5,5,5,6]]}
["DEMANDE DE CONGES"]
[]
[]
["Nom :",{"$f":"+NOM","v":0},null,null,"Activité :",{"$f":"+ACTIVITE","v":"CGI"}]
[]
["Prénom :",{"$f":"+PRENOM","v":0},null,null,null,{"$f":"+CRAM!V3","v":"2016-10-01"}]
[]
[]
[]
[]
[]
[]
[]
["Nature","Périodes",null,null,null,null,null,"Totaux"]
["des congés","Date de début (incluse)","Date de fin\n(incluse)","Nb jours ouvrés","Date de début (incluse)","Date de fin\n(incluse)","Nb jours ouvrés"]
[null,"CP","CP",null,{"$f":"RECOPIE(E17)","v":""},{"$f":"RECOPIE(F17)","v":""}]
["Congés payés"]
[null,{"$f":"RECOPIE(B19)","v":""},{"$f":"RECOPIE(C19)","v":""},null,{"$f":"RECOPIE(E19)","v":""},{"$f":"RECOPIE(F19)","v":""}]
["Congés sans solde",null,null,{"$f":"NBJoursOuvres(B19,C19)","v":" "},null,null,{"$f":"NBJoursOuvres(E19,F19)","v":" "},{"$f":"MASOMME(D19,G19)","v":" "}]
[null,{"$f":"RECOPIE(B21)","v":""},{"$f":"RECOPIE(C21)","v":""},null,{"$f":"RECOPIE(E21)","v":""},{"$f":"RECOPIE(F21)","v":""}]
["Congés par anticipation",null,null,{"$f":"NBJoursOuvres(B21,C21)","v":" "},null,null,{"$f":"NBJoursOuvres(E21,F21)","v":" "},{"$f":"MASOMME(D21,G21)","v":" "}]
[null,{"$f":"RECOPIE(B23)","v":""},{"$f":"RECOPIE(C23)","v":""},null,{"$f":"RECOPIE(E23)","v":""},{"$f":"RECOPIE(F23)","v":""}]
["Compte de temps disponible",null,null,{"$f":"NBJoursOuvres(B23,C23)","v":" "},null,null,{"$f":"NBJoursOuvres(E23,F23)","v":" "},{"$f":"MASOMME(D23,G23)","v":" "}]
[null,{"$f":"RECOPIE(B25)","v":""},{"$f":"RECOPIE(C25)","v":""},null,{"$f":"RECOPIE(E25)","v":""},{"$f":"RECOPIE(F25)","v":""}]
["Journées exceptionnelles",null,null,{"$f":"NBJoursOuvres(B25,C25)","v":" "},null,null,{"$f":"NBJoursOuvres(E25,F25)","v":" "},{"$f":"MASOMME(D25,G25)","v":" "}]
["TOTAUX"]
[]
["Visa du collaborateur",null,"Observations :"]
[]
[]
["Visa du client"]
[]
[]
["Visa de la direction"]