{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Fonctionnement_fichier","PERSONNELS","MATERIELS","FOURNISSEURS","SUIVI DES CHANTIERS","TEMPLATE CHANTIER"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":59,"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":"Fonctionnement_fichier","index":0,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":true,"merged":[[7,0,7,9],[10,0,10,9],[3,0,3,11],[5,0,5,1],[2,0,2,1],[8,0,8,1]]}
["⚠ Le fichier n'est pas protégé. Nous vous invitons à faire attention aux formules pré-enregistrées."]
[]
["✔ A QUI EST DESTINE CET OUTIL ?"]
["L'objectif du fichier est d'aider les petites et moyennes collectivités à suivre les formations sécurité de leurs agents et notamment les recyclages des formations."]
[]
["✔ LES ONGLETS"]
[]
["Le fichier est constitué de trois onglets (feuilles) :\n- L'onglet \"Suivi de formations\" : Regroupe la synthèse de la situation de la collectivité et permet de visualiser simplement les recyclages à prévoir \n- L'onglet \"Liste de formations\" : Liste toutes les formations que les agents doivent suivre au sein de la collectivité\n- L'onglet \"Liste personnel services\" : Liste tous les agents et les services présents au sein de la collectivité\n\n"]
["✔LE FONCTIONNEMENT"]
[]
["Le fichier utilise plusieurs fonctions d'Excel :"]
["- les listes déroulantes : elles sont utilisées pour définir les listes des agents, des services et des formations"]
[null,"📽 Lien utile :","https://support.microsoft.com/fr-fr/office/cr%C3%A9er-une-liste-d%C3%A9roulante-7693307a-59ef-400a-b769-c5402dce407b"]
["- les segments : qui permettent de créer des filtres automatiques"]
[null,"📽 Lien utile :","https://support.microsoft.com/fr-fr/office/utiliser-des-segments-pour-filtrer-les-donn%C3%A9es-249f966b-a9d5-4b0f-b31a-12651785d29d"]
["- les tableaux : qui permettent de faire référence aux données ans des cellules bien définies"]
[null,"📽 Lien utile :","https://support.microsoft.com/fr-fr/office/cr%C3%A9er-et-mettre-en-forme-des-tableaux-e81aa349-b006-4f8a-9806-5af9df0ac664"]

{"sheet":"PERSONNELS","index":1,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,2,4,3]]}
[]
[]
[null,null,"PERSONNELS"]
[]
[]
[]
[]
[null,null,"NOM / PRENOM ","TARIF JOUR ","TARIF 1/2 J","TARIF HEURE"]
[null,null,"Chauffeur A",300,150,37.5]
[null,null,"Chauffeur B",270,135,33.75]
[null,null,"Chauffeur C",300,150,37.5]
[null,null,"Chauffeur D",270,135,33.75]
[null,null,"Chauffeur E",270,135,33.75]
[null,null,"Chauffeur F",200,100,25]
[null,null,"Chauffeur G",300,150,37.5]
[null,null,"Chauffeur H",300,150,37.5]
[null,null,"Chauffeur I",300,150,37.5]
[null,null,"Chauffeur J",300,150,37.5]
[null,null,"Chauffeur K",350,175,43.75]
[null,null,"Chauffeur L",250,125,31.25]
[null,null,"Chauffeur M",300,150,37.5]
[null,null,"Chauffeur N",250,125,31.25]
[null,null,"Chauffeur O",300,150,37.5]
[null,null,"Chauffeur P",200,100,25]
[null,null,"Chauffeur Q",270,135,33.75]
[null,null,"Autres"]

{"sheet":"MATERIELS","index":2,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,3,4,5],[8,2,28,2],[29,2,40,2],[41,2,46,2]]}
[]
[]
[null,null,null,"MATERIELS "]
[]
[]
[]
[]
[null,null,null,"MATERIELS","Modèle","TARIF jour","TARIF 1/2 J","TARIF heure"]
[null,null,"CAMIONS sans chauffeur","BT-414-LZ","6/4 grue",360,{"$f":"SUM(F9/2)","v":180},{"$f":"SUM(F9/8)","v":45}]
[null,null,null,"BH-496-WB","6/4 grue",360,180,45]
[null,null,null,"CE-689-DB","6/4 grue",360,180,45]
[null,null,null,"DD-569-EZ","8/4 grue",410,205,51.25]
[null,null,null,"FG-076-XP","8/4 grue",410,205,51.25]
[null,null,null,"GG-961-TZ","8/4 bibenne",340,170,42.5]
[null,null,null,"Tracteur + benne",null,290,145,36.25]
[null,null,null,"Tracteur + balayeuse ",null,30,15]
[null,null,null,"6/4 + 5 tonnes + remorque",null,430,215,{"$f":"SUM(F17/8)","v":53.75}]
[null,null,null,"6/4 + mécalac + remorque",null,490,245,61.25]
[null,null,null,"6/4 + 15T chenille + remorque",null,480,240,60]
[null,null,null,"6/4 +  15T pneu + remorque",null,500,250,62.5]
[null,null,null,"6/4 + 20T pneu + remorque",null,500,250,62.5]
[null,null,null,"6/4 + 5 tonnes ",null,280,140,35]
[null,null,null,"6/4 + mécalac ",null,340,170,42.5]
[null,null,null,"6/4 + 15T chenille ",null,310,155,38.75]
[null,null,null,"6/4 + 15T pneu",null,355,177.5,44.375]
[null,null,null,"6/4 + 20T pneu ",null,355,177.5,44.375]
[null,null,null,"Fourgon + petit matériels ",null,100]
[null,null,null,"Porte char pour transfert",null,150]
[null,null,null,"Porte engins pour transfert",null,70]
[null,null,"ENGINS sans chauffeur","2,8 T Chenille","Coltrax",120,{"$f":"SUM(F30/2)","v":60},{"$f":"SUM(F30/8)","v":15}]
[null,null,null,"5T chenille","Kubota",200,{"$f":"SUM(F31/2)","v":100},25]
[null,null,null,"Mécalac","12 MTX",320,160,40]
[null,null,null,"15T Chenille","Kobelco",300,150,37.5]
[null,null,null,"15T Pneu","Doosan",450,225,56.25]
[null,null,null,"15T Pneu","Hyundai",350,175,43.75]
[null,null,null,"21T Pneu","Hyundai",350,175,43.75]
[null,null,null,"TILT","Steelweest",35,17.5]
[null,null,null,"BRH 20T",null,250,125]
[null,null,null,"BRH Mécalac",null,150,75]
[null,null,null,"BRH 5 minipelle",null,100,50]
[null,null,null,"Pince de tri",null,200,100]
[null,null,"MATERIELS","BW 100 Cylindre","Bomag",80,{"$f":"SUM(F42/2)","v":40}]
[null,null,null,"AR 65",null,30,{"$f":"SUM(F43/2)","v":15}]
[null,null,null,"Dumper 3T","Twaithes",100,50]
[null,null,null,"Grosse plaque vibrante",null,80,40]
[null,null,null,"Grosse scie à sol",null,80,40]
[null,null,null,"Autres"]

{"sheet":"FOURNISSEURS","index":3,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,2,4,2]]}
[]
[]
[null,null,"FOURNISSEURS"]
[]
[]
[]
[]
[null,null,"Nom ENTREPRISE"]
[null,null,"FOURNISSEURS 1"]
[null,null,"FOURNISSEURS 2"]
[null,null,"FOURNISSEURS 3"]
[null,null,"FOURNISSEURS 4"]
[null,null,"FOURNISSEURS 5"]
[null,null,"FOURNISSEURS 6"]
[null,null,"FOURNISSEURS 7"]
[null,null,"FOURNISSEURS 8"]
[null,null,"FOURNISSEURS 9"]
[null,null,"FOURNISSEURS 10"]
[null,null,"FOURNISSEURS 11"]
[null,null,"FOURNISSEURS 12"]
[null,null,"FOURNISSEURS 13"]
[null,null,"FOURNISSEURS 14"]
[null,null,"FOURNISSEURS 15"]
[null,null,"FOURNISSEURS 16"]
[null,null,"FOURNISSEURS 17"]
[null,null,"FOURNISSEURS 18"]
[null,null,"FOURNISSEURS 19"]
[null,null,"FOURNISSEURS 20"]
[null,null,"FOURNISSEURS 21"]

{"sheet":"SUIVI DES CHANTIERS","index":4,"n_rows":74,"n_cols":12,"rows_kept":74,"cut":false,"hidden":false,"merged":[[2,2,4,6],[1,8,3,8],[1,9,3,9],[11,13,11,14]]}
[]
[null,null,null,null,null,null,null,null,"DATE DU JOUR :",{"$f":"TODAY()","v":"2024-01-10"}]
[null,null,"SUIVI DES CHANTIERS"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"DATE ","MOIS","CLIENTS","LIEUX DU CHANTIER","Nom, Prénom","TARIF PERSONNELS","MATERIELS","TARIF MATERIELS ","FOURNISSEURS","PRIX FOURNITURES "]
[null,null,"2024-01-10",{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1},null,"St Pierre de Chandieu ","GIBOULET Cyril ",null,"BT-414-LZ"]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1},null,null,null,null,"BRH Mécalac"]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]
[null,null,null,{"$f":"MONTH(Suivi_formation[[#This Row],[DATE ]])","v":1}]

{"sheet":"TEMPLATE CHANTIER","index":5,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":false,"merged":[[2,1,4,3],[5,1,5,3],[8,10,9,12],[11,10,12,10],[11,11,12,12]]}
[]
[]
[null,"Nom du chantier "]
[]
[]
[null,"Lieux : "]
[]
[]
[null,"DATE ","MOIS","Nom, Prénom","PRIX PERSONNELS","MATERIELS","PRIX MATERIELS","FOURNISSEURS","PRIX FOURNITURES ",null,"PHOTO DU CHANTIER"]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1},null,null,null,null,null,null,null,"TOTAL"]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]
[null,null,{"$f":"MONTH(Suivi_formation20[[#This Row],[DATE ]])","v":1}]