{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["An","Janvier (2)","Janvier","Fevrier"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":32,"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":"An","index":0,"n_rows":53,"n_cols":26,"rows_kept":53,"cut":false,"hidden":false,"merged":[[49,0,49,6],[50,0,50,6],[51,0,51,6],[52,0,52,6],[44,0,44,6],[45,0,45,6],[46,0,46,6],[47,0,47,6],[48,0,48,6],[5,0,5,22],[0,0,0,25],[1,0,1,15],[2,0,2,2],[2,4,2,6],[2,8,2,10],[3,0,3,2],[3,4,3,6],[3,8,3,10],[3,11,3,14],[3,16,3,21],[1,16,2,21],[2,22,3,24],[2,25,3,25],[6,0,6,22],[8,0,8,6],[8,8,8,14],[8,16,8,22],[17,0,17,6],[17,8,17,14],[17,16,17,22],[43,0,43,14],[43,16,43,22],[26,0,26,6],[26,8,26,14],[26,16,26,22],[35,0,35,6],[35,8,35,14],[35,16,35,22]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calendrier Titre"]
["An",null,null,null,"Mois",null,null,null,"premier jour",null,null,null,null,null,null,null,null,null,null,null,null,null,"objectif mensuel",null,null,25000]
[2016,null,null,null,1,null,null,null,1,null,null,"1:di, 2:lu",null,null,null,null,"Productivitée Atelier"]
["Note : Les calendriers mensuels montrent seulement le premier 2 vacances/événements par le jour de la liste au dessous. "]
[{"$f":"IF(Q4=\"\",\"\",Q4)","v":"Productivitée Atelier"}]
[{"$f":"IF(A4,A4&\"\")","v":"2016"}]
[]
[{"$f":"DATE($A$4,$E$4,1)","v":"2016-01-01"},null,null,null,null,null,null,null,{"$f":"DATE(YEAR(A9),MONTH(A9)+1,1)","v":"2016-02-01"},null,null,null,null,null,null,null,{"$f":"DATE(YEAR(I9),MONTH(I9)+1,1)","v":"2016-03-01"},null,null,null,null,null,null,null,"Date","Vacances ou Evénement"]
[{"$f":"INDEX({\"di\";\"lu\";\"ma\";\"me\";\"je\";\"ve\";\"sa\"},1+MOD($I$4+1-2,7))","v":"di"},{"$f":"INDEX({\"di\";\"lu\";\"ma\";\"me\";\"je\";\"ve\";\"sa\"},1+MOD($I$4+2-2,7))","v":"lu"},{"$f":"INDEX({\"di\";\"lu\";\"ma\";\"me\";\"je\";\"ve\";\"sa\"},1+MOD($I$4+3-2,7))","v":"ma"},{"$f":"INDEX({\"di\";\"lu\";\"ma\";\"me\";\"je\";\"ve\";\"sa\"},1+MOD($I$4+4-2,7))","v":"me"},{"$f":"INDEX({\"di\";\"lu\";\"ma\";\"me\";\"je\";\"ve\";\"sa\"},1+MOD($I$4+5-2,7))","v":"je"},{"$f":"INDEX({\"di\";\"lu\";\"ma\";\"me\";\"je\";\"ve\";\"sa\"},1+MOD($I$4+6-2,7))","v":"ve"},{"$f":"INDEX({\"di\";\"lu\";\"ma\";\"me\";\"je\";\"ve\";\"sa\"},1+MOD($I$4+7-2,7))","v":"sa"},null,{"$f":"$A$10","v":"di"},{"$f":"$B$10","v":"lu"},{"$f":"$C$10","v":"ma"},{"$f":"$D$10","v":"me"},{"$f":"$E$10","v":"je"},{"$f":"$F$10","v":"ve"},{"$f":"$G$10","v":"sa"},null,{"$f":"$A$10","v":"di"},{"$f":"$B$10","v":"lu"},{"$f":"$C$10","v":"ma"},{"$f":"$D$10","v":"me"},{"$f":"$E$10","v":"je"},{"$f":"$F$10","v":"ve"},{"$f":"$G$10","v":"sa"}]
[{"$f":"IF(MONTH($A$9)<>MONTH($A$9-(WEEKDAY($A$9,1)-($I$4-1))-IF((WEEKDAY($A$9,1)-($I$4-1))<=0,7,0)+(ROW(A11)-ROW($A$11))*7+(COLUMN(A11)-COLUMN($A$11)+1)),\"\",$A$9-(WEEKDAY($A$9,1)-($I$4-1))-IF((WEEKDAY($A$9,1)-($I$4-1))<=0,7,0)+(ROW(A11)-ROW($A$11))*7+(COLUMN(A11)-COLUMN($A$11)+1))","v":""},"","","","","2016-01-01","2016-01-02",null,{"$f":"IF(MONTH($I$9)<>MONTH($I$9-(WEEKDAY($I$9,1)-($I$4-1))-IF((WEEKDAY($I$9,1)-($I$4-1))<=0,7,0)+(ROW(I11)-ROW($I$11))*7+(COLUMN(I11)-COLUMN($I$11)+1)),\"\",$I$9-(WEEKDAY($I$9,1)-($I$4-1))-IF((WEEKDAY($I$9,1)-($I$4-1))<=0,7,0)+(ROW(I11)-ROW($I$11))*7+(COLUMN(I11)-COLUMN($I$11)+1))","v":""},"2016-02-01","2016-02-02","2016-02-03","2016-02-04","2016-02-05","2016-02-06",null,{"$f":"IF(MONTH($Q$9)<>MONTH($Q$9-(WEEKDAY($Q$9,1)-($I$4-1))-IF((WEEKDAY($Q$9,1)-($I$4-1))<=0,7,0)+(ROW(Q11)-ROW($Q$11))*7+(COLUMN(Q11)-COLUMN($Q$11)+1)),\"\",$Q$9-(WEEKDAY($Q$9,1)-($I$4-1))-IF((WEEKDAY($Q$9,1)-($I$4-1))<=0,7,0)+(ROW(Q11)-ROW($Q$11))*7+(COLUMN(Q11)-COLUMN($Q$11)+1))","v":""},"","2016-03-01","2016-03-02","2016-03-03","2016-03-04","2016-03-05",null,{"$f":"DATE(Année,1,1)","v":"2016-01-01"},"Premier de l'an "]
["2016-01-03","2016-01-04","2016-01-05","2016-01-06","2016-01-07","2016-01-08","2016-01-09",null,"2016-02-07","2016-02-08","2016-02-09","2016-02-10","2016-02-11","2016-02-12","2016-02-13",null,"2016-03-06","2016-03-07","2016-03-08","2016-03-09","2016-03-10","2016-03-11","2016-03-12",null,{"$f":"DATE(Année,3,29.56+0.979*MOD(204-11*MOD(Année,19),30)- WEEKDAY(DATE(Année,3,28.56+0.979*MOD(204-11*MOD(Année,19),30))))","v":"2016-03-27"},"Pâques"]
["2016-01-10","2016-01-11","2016-01-12","2016-01-13","2016-01-14","2016-01-15","2016-01-16",null,"2016-02-14","2016-02-15","2016-02-16","2016-02-17","2016-02-18","2016-02-19","2016-02-20",null,"2016-03-13","2016-03-14","2016-03-15","2016-03-16","2016-03-17","2016-03-18","2016-03-19",null,{"$f":"Y12+1","v":"2016-03-28"},"Lundi de Pâques"]
["2016-01-17","2016-01-18","2016-01-19","2016-01-20","2016-01-21","2016-01-22","2016-01-23",null,"2016-02-21","2016-02-22","2016-02-23","2016-02-24","2016-02-25","2016-02-26","2016-02-27",null,"2016-03-20","2016-03-21","2016-03-22","2016-03-23","2016-03-24","2016-03-25","2016-03-26",null,{"$f":"DATE(Année,5,1)","v":"2016-05-01"},"Fête du travail"]
["2016-01-24","2016-01-25","2016-01-26","2016-01-27","2016-01-28","2016-01-29","2016-01-30",null,"2016-02-28","2016-02-29","","","","","",null,"2016-03-27","2016-03-28","2016-03-29","2016-03-30","2016-03-31","","",null,{"$f":"DATE(Année,5,8)","v":"2016-05-08"},"Victoire 1945"]
["2016-01-31","","","","","","",null,"","","","","","","",null,"","","","","","","",null,{"$f":"Y12+39","v":"2016-05-05"},"Ascension"]
[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":"Y12+50","v":"2016-05-16"},"Pentecôte"]
[{"$f":"DATE(YEAR(Q9),MONTH(Q9)+1,1)","v":"2016-04-01"},null,null,null,null,null,null,null,{"$f":"DATE(YEAR(A18),MONTH(A18)+1,1)","v":"2016-05-01"},null,null,null,null,null,null,null,{"$f":"DATE(YEAR(I18),MONTH(I18)+1,1)","v":"2016-06-01"},null,null,null,null,null,null,null,{"$f":"DATE(Année,7,14)","v":"2016-07-14"},"Fête nat."]
[{"$f":"$A$10","v":"di"},{"$f":"$B$10","v":"lu"},{"$f":"$C$10","v":"ma"},{"$f":"$D$10","v":"me"},{"$f":"$E$10","v":"je"},{"$f":"$F$10","v":"ve"},{"$f":"$G$10","v":"sa"},null,{"$f":"$A$10","v":"di"},{"$f":"$B$10","v":"lu"},{"$f":"$C$10","v":"ma"},{"$f":"$D$10","v":"me"},{"$f":"$E$10","v":"je"},{"$f":"$F$10","v":"ve"},{"$f":"$G$10","v":"sa"},null,{"$f":"$A$10","v":"di"},{"$f":"$B$10","v":"lu"},{"$f":"$C$10","v":"ma"},{"$f":"$D$10","v":"me"},{"$f":"$E$10","v":"je"},{"$f":"$F$10","v":"ve"},{"$f":"$G$10","v":"sa"},null,{"$f":"DATE(Année,8,15)","v":"2016-08-15"},"Assomption"]
[{"$f":"IF(MONTH($A$18)<>MONTH($A$18-(WEEKDAY($A$18,1)-($I$4-1))-IF((WEEKDAY($A$18,1)-($I$4-1))<=0,7,0)+(ROW(A20)-ROW($A$20))*7+(COLUMN(A20)-COLUMN($A$20)+1)),\"\",$A$18-(WEEKDAY($A$18,1)-($I$4-1))-IF((WEEKDAY($A$18,1)-($I$4-1))<=0,7,0)+(ROW(A20)-ROW($A$20))*7+(COLUMN(A20)-COLUMN($A$20)+1))","v":""},"","","","","2016-04-01","2016-04-02",null,{"$f":"IF(MONTH($I$18)<>MONTH($I$18-(WEEKDAY($I$18,1)-($I$4-1))-IF((WEEKDAY($I$18,1)-($I$4-1))<=0,7,0)+(ROW(I20)-ROW($I$20))*7+(COLUMN(I20)-COLUMN($I$20)+1)),\"\",$I$18-(WEEKDAY($I$18,1)-($I$4-1))-IF((WEEKDAY($I$18,1)-($I$4-1))<=0,7,0)+(ROW(I20)-ROW($I$20))*7+(COLUMN(I20)-COLUMN($I$20)+1))","v":"2016-05-01"},{"$f":"IF(MONTH($I$18)<>MONTH($I$18-(WEEKDAY($I$18,1)-($I$4-1))-IF((WEEKDAY($I$18,1)-($I$4-1))<=0,7,0)+(ROW(J20)-ROW($I$20))*7+(COLUMN(J20)-COLUMN($I$20)+1)),\"\",$I$18-(WEEKDAY($I$18,1)-($I$4-1))-IF((WEEKDAY($I$18,1)-($I$4-1))<=0,7,0)+(ROW(J20)-ROW($I$20))*7+(COLUMN(J20)-COLUMN($I$20)+1))","v":"2016-05-02"},"2016-05-03","2016-05-04","2016-05-05","2016-05-06","2016-05-07",null,{"$f":"IF(MONTH($Q$18)<>MONTH($Q$18-(WEEKDAY($Q$18,1)-($I$4-1))-IF((WEEKDAY($Q$18,1)-($I$4-1))<=0,7,0)+(ROW(Q20)-ROW($Q$20))*7+(COLUMN(Q20)-COLUMN($Q$20)+1)),\"\",$Q$18-(WEEKDAY($Q$18,1)-($I$4-1))-IF((WEEKDAY($Q$18,1)-($I$4-1))<=0,7,0)+(ROW(Q20)-ROW($Q$20))*7+(COLUMN(Q20)-COLUMN($Q$20)+1))","v":""},"","","2016-06-01","2016-06-02","2016-06-03","2016-06-04",null,{"$f":"DATE(Année,11,1)","v":"2016-11-01"},"Toussaint"]
["2016-04-03","2016-04-04","2016-04-05","2016-04-06","2016-04-07","2016-04-08","2016-04-09",null,"2016-05-08","2016-05-09","2016-05-10","2016-05-11","2016-05-12","2016-05-13","2016-05-14",null,"2016-06-05","2016-06-06","2016-06-07","2016-06-08","2016-06-09","2016-06-10","2016-06-11",null,{"$f":"DATE(Année,11,11)","v":"2016-11-11"},"Armistice"]
["2016-04-10","2016-04-11","2016-04-12","2016-04-13","2016-04-14","2016-04-15","2016-04-16",null,"2016-05-15","2016-05-16","2016-05-17","2016-05-18","2016-05-19","2016-05-20","2016-05-21",null,"2016-06-12","2016-06-13","2016-06-14","2016-06-15","2016-06-16","2016-06-17","2016-06-18",null,{"$f":"DATE(Année,12,25)","v":"2016-12-25"},"Noël"]
["2016-04-17","2016-04-18","2016-04-19","2016-04-20","2016-04-21","2016-04-22","2016-04-23",null,"2016-05-22","2016-05-23","2016-05-24","2016-05-25","2016-05-26","2016-05-27","2016-05-28",null,"2016-06-19","2016-06-20","2016-06-21","2016-06-22","2016-06-23","2016-06-24","2016-06-25"]
["2016-04-24","2016-04-25","2016-04-26","2016-04-27","2016-04-28","2016-04-29","2016-04-30",null,"2016-05-29","2016-05-30","2016-05-31","","","","",null,"2016-06-26","2016-06-27","2016-06-28","2016-06-29","2016-06-30","",""]
["","","","","","","",null,"","","","","","","",null,"","","","","","",""]
[]
[{"$f":"DATE(YEAR(Q18),MONTH(Q18)+1,1)","v":"2016-07-01"},null,null,null,null,null,null,null,{"$f":"DATE(YEAR(A27),MONTH(A27)+1,1)","v":"2016-08-01"},null,null,null,null,null,null,null,{"$f":"DATE(YEAR(I27),MONTH(I27)+1,1)","v":"2016-09-01"}]
[{"$f":"$A$10","v":"di"},{"$f":"$B$10","v":"lu"},{"$f":"$C$10","v":"ma"},{"$f":"$D$10","v":"me"},{"$f":"$E$10","v":"je"},{"$f":"$F$10","v":"ve"},{"$f":"$G$10","v":"sa"},null,{"$f":"$A$10","v":"di"},{"$f":"$B$10","v":"lu"},{"$f":"$C$10","v":"ma"},{"$f":"$D$10","v":"me"},{"$f":"$E$10","v":"je"},{"$f":"$F$10","v":"ve"},{"$f":"$G$10","v":"sa"},null,{"$f":"$A$10","v":"di"},{"$f":"$B$10","v":"lu"},{"$f":"$C$10","v":"ma"},{"$f":"$D$10","v":"me"},{"$f":"$E$10","v":"je"},{"$f":"$F$10","v":"ve"},{"$f":"$G$10","v":"sa"}]
[{"$f":"IF(MONTH($A$27)<>MONTH($A$27-(WEEKDAY($A$27,1)-($I$4-1))-IF((WEEKDAY($A$27,1)-($I$4-1))<=0,7,0)+(ROW(A29)-ROW($A$29))*7+(COLUMN(A29)-COLUMN($A$29)+1)),\"\",$A$27-(WEEKDAY($A$27,1)-($I$4-1))-IF((WEEKDAY($A$27,1)-($I$4-1))<=0,7,0)+(ROW(A29)-ROW($A$29))*7+(COLUMN(A29)-COLUMN($A$29)+1))","v":""},"","","","","2016-07-01","2016-07-02",null,{"$f":"IF(MONTH($I$27)<>MONTH($I$27-(WEEKDAY($I$27,1)-($I$4-1))-IF((WEEKDAY($I$27,1)-($I$4-1))<=0,7,0)+(ROW(I29)-ROW($I$29))*7+(COLUMN(I29)-COLUMN($I$29)+1)),\"\",$I$27-(WEEKDAY($I$27,1)-($I$4-1))-IF((WEEKDAY($I$27,1)-($I$4-1))<=0,7,0)+(ROW(I29)-ROW($I$29))*7+(COLUMN(I29)-COLUMN($I$29)+1))","v":""},"2016-08-01","2016-08-02","2016-08-03","2016-08-04","2016-08-05","2016-08-06",null,{"$f":"IF(MONTH($Q$27)<>MONTH($Q$27-(WEEKDAY($Q$27,1)-($I$4-1))-IF((WEEKDAY($Q$27,1)-($I$4-1))<=0,7,0)+(ROW(Q29)-ROW($Q$29))*7+(COLUMN(Q29)-COLUMN($Q$29)+1)),\"\",$Q$27-(WEEKDAY($Q$27,1)-($I$4-1))-IF((WEEKDAY($Q$27,1)-($I$4-1))<=0,7,0)+(ROW(Q29)-ROW($Q$29))*7+(COLUMN(Q29)-COLUMN($Q$29)+1))","v":""},"","","","2016-09-01","2016-09-02","2016-09-03"]
["2016-07-03","2016-07-04","2016-07-05","2016-07-06","2016-07-07","2016-07-08","2016-07-09",null,"2016-08-07","2016-08-08","2016-08-09","2016-08-10","2016-08-11","2016-08-12","2016-08-13",null,"2016-09-04","2016-09-05","2016-09-06","2016-09-07","2016-09-08","2016-09-09","2016-09-10"]
["2016-07-10","2016-07-11","2016-07-12","2016-07-13","2016-07-14","2016-07-15","2016-07-16",null,"2016-08-14","2016-08-15","2016-08-16","2016-08-17","2016-08-18","2016-08-19","2016-08-20",null,"2016-09-11","2016-09-12","2016-09-13","2016-09-14","2016-09-15","2016-09-16","2016-09-17"]
["2016-07-17","2016-07-18","2016-07-19","2016-07-20","2016-07-21","2016-07-22","2016-07-23",null,"2016-08-21","2016-08-22","2016-08-23","2016-08-24","2016-08-25","2016-08-26","2016-08-27",null,"2016-09-18","2016-09-19","2016-09-20","2016-09-21","2016-09-22","2016-09-23","2016-09-24"]
["2016-07-24","2016-07-25","2016-07-26","2016-07-27","2016-07-28","2016-07-29","2016-07-30",null,"2016-08-28","2016-08-29","2016-08-30","2016-08-31","","","",null,"2016-09-25","2016-09-26","2016-09-27","2016-09-28","2016-09-29","2016-09-30",""]
["2016-07-31","","","","","","",null,"","","","","","","",null,"","","","","","",""]
[]
[{"$f":"DATE(YEAR(Q27),MONTH(Q27)+1,1)","v":"2016-10-01"},null,null,null,null,null,null,null,{"$f":"DATE(YEAR(A36),MONTH(A36)+1,1)","v":"2016-11-01"},null,null,null,null,null,null,null,{"$f":"DATE(YEAR(I36),MONTH(I36)+1,1)","v":"2016-12-01"},null,null,null,null,null,null,"[42]"]
[{"$f":"$A$10","v":"di"},{"$f":"$B$10","v":"lu"},{"$f":"$C$10","v":"ma"},{"$f":"$D$10","v":"me"},{"$f":"$E$10","v":"je"},{"$f":"$F$10","v":"ve"},{"$f":"$G$10","v":"sa"},null,{"$f":"$A$10","v":"di"},{"$f":"$B$10","v":"lu"},{"$f":"$C$10","v":"ma"},{"$f":"$D$10","v":"me"},{"$f":"$E$10","v":"je"},{"$f":"$F$10","v":"ve"},{"$f":"$G$10","v":"sa"},null,{"$f":"$A$10","v":"di"},{"$f":"$B$10","v":"lu"},{"$f":"$C$10","v":"ma"},{"$f":"$D$10","v":"me"},{"$f":"$E$10","v":"je"},{"$f":"$F$10","v":"ve"},{"$f":"$G$10","v":"sa"}]
[{"$f":"IF(MONTH($A$36)<>MONTH($A$36-(WEEKDAY($A$36,1)-($I$4-1))-IF((WEEKDAY($A$36,1)-($I$4-1))<=0,7,0)+(ROW(A38)-ROW($A$38))*7+(COLUMN(A38)-COLUMN($A$38)+1)),\"\",$A$36-(WEEKDAY($A$36,1)-($I$4-1))-IF((WEEKDAY($A$36,1)-($I$4-1))<=0,7,0)+(ROW(A38)-ROW($A$38))*7+(COLUMN(A38)-COLUMN($A$38)+1))","v":""},"","","","","","2016-10-01",null,{"$f":"IF(MONTH($I$36)<>MONTH($I$36-(WEEKDAY($I$36,1)-($I$4-1))-IF((WEEKDAY($I$36,1)-($I$4-1))<=0,7,0)+(ROW(I38)-ROW($I$38))*7+(COLUMN(I38)-COLUMN($I$38)+1)),\"\",$I$36-(WEEKDAY($I$36,1)-($I$4-1))-IF((WEEKDAY($I$36,1)-($I$4-1))<=0,7,0)+(ROW(I38)-ROW($I$38))*7+(COLUMN(I38)-COLUMN($I$38)+1))","v":""},"","2016-11-01","2016-11-02","2016-11-03","2016-11-04","2016-11-05",null,{"$f":"IF(MONTH($Q$36)<>MONTH($Q$36-(WEEKDAY($Q$36,1)-($I$4-1))-IF((WEEKDAY($Q$36,1)-($I$4-1))<=0,7,0)+(ROW(Q38)-ROW($Q$38))*7+(COLUMN(Q38)-COLUMN($Q$38)+1)),\"\",$Q$36-(WEEKDAY($Q$36,1)-($I$4-1))-IF((WEEKDAY($Q$36,1)-($I$4-1))<=0,7,0)+(ROW(Q38)-ROW($Q$38))*7+(COLUMN(Q38)-COLUMN($Q$38)+1))","v":""},"","","","2016-12-01","2016-12-02","2016-12-03"]
["2016-10-02","2016-10-03","2016-10-04","2016-10-05","2016-10-06","2016-10-07","2016-10-08",null,"2016-11-06","2016-11-07","2016-11-08","2016-11-09","2016-11-10","2016-11-11","2016-11-12",null,"2016-12-04","2016-12-05","2016-12-06","2016-12-07","2016-12-08","2016-12-09","2016-12-10"]
["2016-10-09","2016-10-10","2016-10-11","2016-10-12","2016-10-13","2016-10-14","2016-10-15",null,"2016-11-13","2016-11-14","2016-11-15","2016-11-16","2016-11-17","2016-11-18","2016-11-19",null,"2016-12-11","2016-12-12","2016-12-13","2016-12-14","2016-12-15","2016-12-16","2016-12-17"]
["2016-10-16","2016-10-17","2016-10-18","2016-10-19","2016-10-20","2016-10-21","2016-10-22",null,"2016-11-20","2016-11-21","2016-11-22","2016-11-23","2016-11-24","2016-11-25","2016-11-26",null,"2016-12-18","2016-12-19","2016-12-20","2016-12-21","2016-12-22","2016-12-23","2016-12-24"]
["2016-10-23","2016-10-24","2016-10-25","2016-10-26","2016-10-27","2016-10-28","2016-10-29",null,"2016-11-27","2016-11-28","2016-11-29","2016-11-30","","","",null,"2016-12-25","2016-12-26","2016-12-27","2016-12-28","2016-12-29","2016-12-30","2016-12-31"]
["2016-10-30","2016-10-31","","","","","",null,"","","","","","","",null,"","","","","","",""]
[]
["pierre",null,null,null,null,null,null,null,"ouvrier1"]
["paul",null,null,null,null,null,null,null,"ouvrier2"]
["jacques",null,null,null,null,null,null,null,"ouvrier3"]
[null,null,null,null,null,null,null,null,"ouvrier4"]
[null,null,null,null,null,null,null,null,"ouvrier5"]
[null,null,null,null,null,null,null,null,"ouvrier6"]
[null,null,null,null,null,null,null,null,"ouvrier7"]
[null,null,null,null,null,null,null,null,"ouvrier8"]
[null,null,null,null,null,null,null,null,"ouvrier9"]

{"sheet":"Janvier (2)","index":1,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[4,0,4,1],[36,0,36,2]]}
[{"$f":"DATE(Année,1,1)","v":"2016-01-01"}]
[]
[null,null,null,{"$f":"ouvrier2","v":"paul"}]
[]
["1er jour ouvré",null,{"$f":"WORKDAY(EOMONTH(A1,-1),1,Fer)","v":"2016-01-04"},{"$f":"DATE(Année,1,1)","v":"2016-01-01"},"heures mois","Objectif","Atteint"]
[]
[null,"JOURS OUVRABLES",null,{"$f":"NETWORKDAYS(A1,Fevrier!A1-1,Fer)","v":"1900-01-20"},{"$f":"(D7*7)-D8+E8","v":140},{"$f":"E7*70%*65","v":6370},6940]
["HEURES D'ABSENCES / HEURES SUPP"]
[]
["C.A.","% OBJECTIF","PRIME BRUTE"]
[null,null,null,null,"mise ne forme conditionnelle:"]
[{"$f":"$F$7*B12/100","v":5096},80,130,null,"sélectionner A12:C26"]
[5414.5,85,160,null,"Ruban / Accueil / Mise en forme conditionnelle"]
[5733,90,200,null,"dans la liste qui s'affiche, cliquer sur \"nouvelle régle\""]
[6051.5,95,250,null,"dans la fenêtre choisir \"utiliser une formule..\""]
[6370,100,320,null,"entrer la fomule (voir ci-dessous)"]
[6433.7,101,330,null,"cliquer sur format et formater comme souhaité"]
[6497.4,102,340,null,"fermer par OK /OK"]
[6561.1,103,350,null,"il est ensuite possible de rajouter des régles en cliquant ici"]
[6624.8,104,360]
[6688.5,105,370]
[6752.2,106,380]
[6815.9,107,390]
[6879.6,108,400]
[6943.3,109,410]
[7007,110,420]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"CONCATENATE(\"prime CA  \",ouvrier2)","v":"prime CA  paul"}]
["1 retour = déduction 50%"]
["2 retours = annulation prime"]
["Prime obtenue"]
[null,{"$f":"VLOOKUP(G7,A12:C26,3)","v":400},"formule en B38>","=RECHERCHEV(G7;A12:C26;3)"]
[null,null,"avec inversion du classement en A/B"]

{"sheet":"Janvier","index":2,"n_rows":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":false,"merged":[[4,0,4,1],[36,0,36,2]]}
[{"$f":"DATE(Année,1,1)","v":"2016-01-01"}]
[]
[null,null,null,{"$f":"ouvrier2","v":"paul"}]
[]
["1er jour ouvré",null,{"$f":"WORKDAY(EOMONTH(A1,-1),1,Fer)","v":"2016-01-04"},{"$f":"DATE(Année,1,1)","v":"2016-01-01"},"heures mois","Objectif","Atteint"]
[]
[null,"JOURS OUVRABLES",null,{"$f":"NETWORKDAYS(A1,Fevrier!A1-1,Fer)","v":"1900-01-20"},{"$f":"(D7*7)-D8+E8","v":140},{"$f":"E7*70%*65","v":6370},6940]
["HEURES D'ABSENCES / HEURES SUPP"]
[]
["C.A.","% OBJECTIF","PRIME BRUTE"]
[]
[{"$f":"F7*B12/100","v":7007},110,420]
[{"$f":"F7*B13/100","v":6943.3},109,410]
[{"$f":"F7*B14/100","v":6879.6},108,400]
[{"$f":"F7*B15/100","v":6815.9},107,390,null,null,"Ceci est un fichier pour definir les primes de rendement pour un ouvrier"]
[{"$f":"F7*B16/100","v":6752.2},106,380,null,null,"a savoir que il y a 20 jours ouvrés a 7 h par jour donc 140h par mois l'objectif a atteindre est de"]
[{"$f":"F7*B17/100","v":6688.5},105,370,null,null,"6370 qui correspond a une prime de 100%  de rendement plus son chiffre atteint en G7 est haut plus le pourcentage augmente dans la colonne B"]
[{"$f":"F7*B18/100","v":6624.8},104,360]
[{"$f":"F7*B19/100","v":6561.1},103,350]
[{"$f":"F7*B20/100","v":6497.4},102,340]
[{"$f":"F7*B21/100","v":6433.7},101,330]
[{"$f":"F7*B22/100","v":6370},100,320,null,null,null,null,null,null,1]
[{"$f":"F7*B23/100","v":6051.5},95,250,null,null,null,null,null,null,2]
[{"$f":"F7*B24/100","v":5733},90,200,null,null,null,null,null,null,3]
[{"$f":"F7*B25/100","v":5414.5},85,160,null,null,null,null,null,null,4]
[{"$f":"F7*B26/100","v":5096},80,130,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,12]
[{"$f":"CONCATENATE(\"prime CA  \",ouvrier2)","v":"prime CA  paul"},null,null,null,null,null,null,null,null,13]
["1 retour = déduction 50%",null,null,null,null,null,null,null,null,14]
["2 retours = annulation prime",null,null,null,null,null,null,null,null,15]
["Prime obtenue",null,null,null,null,null,null,null,null,16]
[null,{"$f":"VLOOKUP(ROUNDDOWN(G7/F7,2)*100,B12:C26,2,0)","v":400},"formule en B38>","=RECHERCHEV(ARRONDI.INF(G7/F7;2)*100;B12:C26;2;0)",null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,31]
[null,null,null,null,null,null,null,null,null,32]
[null,null,null,null,null,null,null,null,null,33]
[null,null,null,null,null,null,null,null,null,34]
[null,null,null,null,null,null,null,null,null,35]

{"sheet":"Fevrier","index":3,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[4,0,4,1]]}
[{"$f":"DATE(Année,2,1)","v":"2016-02-01"}]
[]
[null,null,null,{"$f":"ouvrier2","v":"paul"}]
[]
["1er jour ouvré",null,{"$f":"WORKDAY(EOMONTH(A1,-1),1,Fer)","v":"2016-02-01"},{"$f":"DATE(Année,2,1)","v":"2016-02-01"},null,"Objectif","Atteint"]
[]
[null,"JOURS OUVRABLES",null,null,null,{"$f":"(D7*7-D8)*70%*65","v":0}]
[null,"HEURES D'ABSENCES"]
[]
["C.A.","% OBJECTIF","PRIME BRUTE"]
[]
[{"$f":"F7*B12/100","v":0},110,420]
[{"$f":"F7*B13/100","v":0},109,410]
[{"$f":"F7*B14/100","v":0},108,400]
[{"$f":"F7*B15/100","v":0},107,390]
[{"$f":"F7*B16/100","v":0},106,380]
[{"$f":"F7*B17/100","v":0},105,370]
[{"$f":"F7*B18/100","v":0},104,360]
[{"$f":"F7*B19/100","v":0},103,350]
[{"$f":"F7*B20/100","v":0},102,340]
[{"$f":"F7*B21/100","v":0},101,330]
[{"$f":"F7*B22/100","v":0},100,320]
[{"$f":"F7*B23/100","v":0},95,250]
[{"$f":"F7*B24/100","v":0},90,200]
[{"$f":"F7*B25/100","v":0},85,160]
[{"$f":"F7*B26/100","v":0},80,130]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"CONCATENATE(\"prime CA  \",ouvrier2)","v":"prime CA  paul"}]
["1 retour = déduction 50%"]
["2 retours = annulation prime"]