{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Chercher","Extraire mois date","Dates en nombres","Ancienneté","Planning","échéances de paiements","Nombres de jours dates","Calcul heures travail"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":3,"defined_names":120,"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":"Chercher","index":0,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[[14,2,14,6],[15,2,15,6],[16,2,16,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[12,2,12,6],[13,2,13,6],[5,2,5,6],[6,2,6,6],[7,2,7,6],[8,2,8,6],[1,1,1,11],[3,2,3,3]]}
[]
[null,"Créer des liens automatiques pour pointer sur les cellules du classeur portant le mot clé tapé"]
[]
[null,"Mot clé :","heure"]
[]
[null,"Liens"]

{"sheet":"Extraire mois date","index":1,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,0,2,5]]}
[]
[]
["Synthèse des ventes / Objectifs Trimestre"]
[]
["Mois","Vendeur","Mois","Réalisé","Objectif","Ecart",null,null,null,"Numéro","Mois"]
["2017-01-17","Galls",null,15300,15000,{"$f":"D6-E6","v":300},null,null,null,1,"Janvier"]
["2017-01-23","Céhef",null,9300,10000,-700,null,null,null,2,"Février"]
["2017-01-06","Céhef",null,23900,25000,-1100,null,null,null,3,"Mars"]
["2017-01-18","Hamalibou",null,23300,21000,2300,null,null,null,4,"Avril"]
["2017-01-22","Houda",null,26500,25500,1000,null,null,null,5,"Mai"]
["2017-01-23","Galls",null,19800,22000,-2200,null,null,null,6,"Juin"]
["2017-01-15","Hamalibou",null,21000,20000,1000,null,null,null,7,"Juillet"]
["2017-01-19","Houda",null,26500,22000,4500,null,null,null,8,"Août"]
["2017-02-02","Galls",null,13500,13000,500,null,null,null,9,"Septembre"]
["2017-02-03","Houda",null,10100,9000,1100,null,null,null,10,"Octobre"]
["2017-02-15","Hamalibou",null,25500,25000,500,null,null,null,11,"Novembre"]
["2017-02-16","Céhef",null,21100,23000,-1900,null,null,null,12,"Décembre"]
["2017-02-21","Céhef",null,29000,23000,6000]
["2017-02-22","Galls",null,31000,21000,10000]
["2017-02-28","Hamalibou",null,22600,20000,2600]
["2017-02-26","Houda",null,19500,22000,-2500]
["2017-03-01","Céhef",null,26500,24000,2500]
["2017-03-03","Houda",null,27200,25000,2200]
["2017-03-07","Galls",null,29500,23500,6000]
["2017-03-12","Galls",null,27400,24000,3400]
["2017-03-15","Hamalibou",null,11300,13000,-1700]
["2017-03-17","Céhef",null,7700,5000,2700]
["2017-03-21","Hamalibou",null,25900,23000,2900]
["2017-03-27","Galls",null,21900,23000,-1100]

{"sheet":"Dates en nombres","index":2,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5]]}
[]
[null,"Liste des salariés"]
[]
[null,"Numéro","Nom","Prénom","Date d'embauche","Code date"]
[]
[null,1,"Galls","Charline","2001-04-01"]
[null,2,"Céhef","Hassan","2001-05-15"]
[null,3,"Rouana","Marie","2002-04-01"]
[null,4,"Hamalibou","Arlette","2000-03-01"]
[null,5,"Houda","Barrack","2000-09-01"]
[null,6,"Tatouille","Laura","2001-09-15"]
[null,7,"Bernard","Sarah","2002-07-15"]
[null,8,"Maurice","Philippe","2004-07-01"]
[null,9,"Audine","Anne","2003-09-01"]

{"sheet":"Ancienneté","index":3,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,9],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9]]}
[]
[null,"Liste des salariés"]
[]
[null,"Numéro","Nom","Prénom","Date d'embauche","Date d'embauche définitive","Ancienneté","Salaire","Prime","TOTAL"]
[null,null,null,null,null,"définitive"]
[null,1,"Galls","Charline","2001-04-01",null,null,1654.28]
[null,2,"Céhef","Hassan","2001-05-15",null,null,1725.36]
[null,3,"Rouana","Marie","2002-04-01",null,null,1421.33]
[null,4,"Hamalibou","Arlette","2000-03-01",null,null,1532.02]
[null,5,"Houda","Barrack","2000-09-01",null,null,1230.25]
[null,6,"Tatouille","Laura","2001-09-15",null,null,1652.52]
[null,7,"Bernard","Sarah","2002-07-15",null,null,1365.98]
[null,8,"Maurice","Philippe","2004-07-01",null,null,1295.74]
[null,9,"Audine","Anne","2003-09-01",null,null,2100.3000000000002]

{"sheet":"Planning","index":4,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,null,"Hochon","Audine","Rouana","Hamalibou","Céhef","Galls","Houda"]
[null,"2017-02-27","07:15:00","07:25:00","07:00:00","07:00:00","07:15:00","07:45:00","07:15:00"]
[null,"2017-02-28","07:45:00","08:15:00","08:20:00","07:10:00","07:10:00","07:00:00","08:25:00"]
[null,"2017-03-01","08:00:00","07:00:00","07:00:00","06:45:00","07:00:00","06:45:00","07:15:00"]
[null,"2017-03-02","07:00:00","07:15:00","07:00:00","07:15:00","07:00:00","07:00:00","07:00:00"]
[null,"2017-03-03","07:00:00","07:00:00","07:15:00","07:00:00","08:20:00","07:45:00","07:00:00"]
[null,"Total Sem."]
[null,"Heures Sup."]
[null,"2017-03-06","07:15:00","07:25:00","07:00:00","07:00:00","07:15:00","07:45:00","07:15:00"]
[null,"2017-03-07","07:45:00","08:15:00","06:15:00","07:10:00","07:10:00","08:00:00","08:25:00"]
[null,"2017-03-08","04:00:00","00:00:00","07:30:00","05:00:00","08:10:00","06:45:00","07:15:00"]
[null,"2017-03-09","08:00:00","10:15:00","07:00:00","07:50:00","07:00:00","07:00:00","08:15:00"]
[null,"2017-03-10","08:00:00","09:05:00","07:15:00","08:00:00","08:20:00","05:30:00","07:00:00"]
[null,"Total Sem."]
[null,"Heures Sup."]
[null,"2017-02-27","00:00:00","07:25:00","07:00:00","07:00:00","07:15:00","07:45:00","07:15:00"]
[null,"2017-02-28","08:45:00","08:15:00","05:15:00","07:00:00","07:10:00","07:00:00","04:50:00"]
[null,"2017-03-01","08:00:00","07:00:00","07:00:00","06:45:00","07:00:00","08:15:00","07:15:00"]
[null,"2017-03-02","08:45:00","06:00:00","08:00:00","07:15:00","07:00:00","07:00:00","07:40:00"]
[null,"2017-03-03","09:30:00","07:00:00","07:45:00","07:00:00","08:20:00","07:45:00","08:00:00"]
[null,"Total Sem."]
[null,"Heures Sup."]
[null,"2017-03-06","07:15:00","07:25:00","07:00:00","07:45:00","07:15:00","07:45:00","07:15:00"]
[null,"2017-03-07","07:45:00","06:30:00","08:20:00","07:10:00","07:10:00","07:00:00","05:50:00"]
[null,"2017-03-08","08:00:00","07:00:00","07:00:00","07:15:00","05:15:00","06:45:00","07:15:00"]
[null,"2017-03-09","08:45:00","07:15:00","08:50:00","07:15:00","07:00:00","06:00:00","07:40:00"]
[null,"2017-03-10","07:00:00","07:00:00","07:15:00","07:45:00","08:20:00","07:45:00","07:00:00"]
[null,"Total Sem."]
[null,"Heures Sup."]

{"sheet":"échéances de paiements","index":5,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,14]]}
["Échéances de paiements"]
[]
["N° de facture","Date de facture","Montant TTC","Échéance","Date d'échéance",null,"Formule à utiliser","Vous devez obtenir",null,"Année","Mois","Jour","N° jour sem","Avec Fct texte Ici","Jour sem"]
[122,"2014-03-05",1200,"15 jours",null,null,"Addition","2014-03-20"]
[123,"2014-03-10",1700,"fin de mois",null,null,"fin.mois()","2014-03-31"]
[124,"2014-03-12",5000,"30 jours fin de mois",null,null,"fin.mois()","2014-04-30"]
[125,"2014-03-15",3700,"40 jours ouvrés",null,null,"serie.jour.ouvre()","2014-05-14"]
[126,"2014-03-15",3700,"40 jours ouvrables",null,null,"serie.jour.ouvre.intl()","2014-05-03"]
[127,"2014-03-16",5250,"60 jours fin de mois",null,null,"fin.mois()","2014-05-31"]
[128,"2014-03-20",2720,"30 jours fin de mois, le 10",null,null,"fin.mois()","2014-05-10"]
[129,"2014-04-12",2420,"3 mois",null,null,"date()","2014-07-12"]
[]
[null,"Jours fériés"]
[null,"2014-01-01"]
[null,"2014-04-21"]
[null,"2014-05-01"]
[null,"2014-05-08"]
[null,"2014-05-29"]
[null,"2014-07-14"]
[null,"2014-08-15"]
[null,"2014-11-01"]
[null,"2014-11-11"]
[null,"2014-12-25"]

{"sheet":"Nombres de jours dates","index":6,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Facture","Date émission","Date Paiement","Différence en jours","Différence en jours ouvrés","Différence en jours ouvrables"]
[null,"Fac001","2016-01-25","2016-03-27"]
[null,"Fac002","2016-10-28","2016-11-15"]
[null,"Fac003","2016-11-29","2017-01-03"]
[null,"Fac004","2017-01-06","2017-01-13"]
[null,"Fac005","2017-01-25","2017-02-15"]
[null,"Fac006","2017-02-12","2017-02-19"]
[null,"Fac007","2017-02-28","2017-03-16"]
[]
[null,"Jours fériés"]
[null,"2016-11-01"]
[null,"2016-11-11"]
[null,"2016-12-25"]
[null,"2017-01-01"]

{"sheet":"Calcul heures travail","index":7,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,9],[2,0,3,1],[2,2,2,4],[2,5,2,7],[15,0,16,1]]}
["Caluls sur les heures de travail"]
[]
["Hamalibou Arlette",null,"Matin",null,null,"Après Midi",null,null,"TOTAL","TOTAL"]
["JOUR",null,"DE","A","Durée","DE","A","Durée","JOUR","JOUR DECIMALES"]
["lundi","2015-03-23",0.33333333333333331,0.5,null,0.58333333333333337,0.70833333333333337]
["mardi",{"$f":"B5+1","v":"2015-03-24"},0.39583333333333331,0.5]
["mercredi","2015-03-25"]
["jeudi","2015-03-26",0.375,0.47916666666666669,null,0.5625,0.69791666666666663]
["vendredi ","2015-03-27",0.29166666666666669,0.45833333333333331,null,0.52083333333333337,0.64583333333333337]
["samedi","2015-03-28",0.35416666666666669,0.48958333333333331,null,0.55208333333333337,0.68055555555555547]
["dimanche","2015-03-29",0.3125,0.46875,null,0.51388888888888895,0.70833333333333337]
[]
[]
[]
[]
["Galls Charline",null,"Nuit",null,"TOTAL","TOTAL"]
["JOUR",null,"DE","A","JOUR","JOUR DECIMALES"]
["lundi","2015-03-23",0.91666666666666663,0.20833333333333334]
["mardi",{"$f":"B18+1","v":"2015-03-24"},0.89583333333333337,0.20833333333333334]
["mercredi","2015-03-25",0.89583333333333337,0.20833333333333334]
["jeudi","2015-03-26",0.89583333333333337,0.20833333333333334]
["vendredi ","2015-03-27",0.89583333333333337,0.20833333333333334]
["samedi","2015-03-28"]
["dimanche","2015-03-29"]