{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Main-Courante","Param","ListPers","Mouvts","WsAr","Stocks"],"not_rendered":{"charts":0,"images":27,"macros":1,"external_links":0,"defined_names":9,"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":"Main-Courante","index":0,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":false,"merged":[[36,0,36,9],[37,0,37,9],[30,0,30,9],[31,0,31,9],[32,0,32,9],[33,0,33,9],[34,0,34,9],[35,0,35,9],[0,0,0,2],[1,0,1,2],[5,0,5,1],[4,0,4,1],[3,6,3,8],[3,2,3,3],[14,7,14,8],[4,4,4,7],[21,1,21,6],[27,1,27,6],[26,1,26,6],[25,1,25,6],[24,1,24,6],[23,1,23,6],[22,1,22,6],[4,8,4,9],[28,1,28,6],[15,7,15,8],[16,7,16,8],[17,7,17,8],[18,7,18,8]]}
[{"$f":"Param!B3","v":"S.S.L.I.A"}]
[{"$f":"Param!B4","v":"Aéroport Béziers Cap-d'Agde"}]
[]
[null,"Date :","2016-06-05",null,null,"Chef de manoeuvre :"]
[{"$f":"\"Semaine \" & WEEKNUM(C4)","v":"Semaine 24"},null,"PRISE DE POSTE","FIN DE POSTE","PRISE EN COMPTE MUNITIONS",null,null,null,"TABLEAU DE BORD",null,null,"mini arm","stock caisse"]
["Matériels",null,"Disp - Ndisp - Sort ","Disp - Ndisp - Util - Net","Munitions","Coffre","Caisse","Déb - Fin",null,null,null,"inf","inf","sup"]
[{"$f":"Param!E2&\" \"&Param!F2","v":"Effaroucheur embarqué "},null,null,null,{"$f":"IF(Stocks!A3=\"\",\"\",Stocks!A3)","v":"Amorce à blanc"},{"$f":"IF(Stocks!D3=\"\",\"\",Stocks!D3)","v":442},{"$f":"IF(Stocks!G3=\"\",\"\",Stocks!G3)","v":50},null,null,null,null,{"$f":"IF(F7=\"\",\"\",IF(F7<Stocks!C3,\"Nok\",\"Ok\"))","v":"Ok"},{"$f":"IF(G7=\"\",\"\",IF(G7<Stocks!F3,\"Nok\",\"Ok\"))","v":"Ok"},{"$f":"IF(G7=\"\",\"\",IF(G7>Stocks!F3,\"Nok\",\"Ok\"))","v":"Ok"}]
[{"$f":"Param!E3&\" \"&Param!F3","v":"Lance fusée capa N°1590612"},null,null,null,{"$f":"IF(Stocks!A4=\"\",\"\",Stocks!A4)","v":"Fusée crépitante"},{"$f":"IF(Stocks!D4=\"\",\"\",Stocks!D4)","v":247},{"$f":"IF(Stocks!G4=\"\",\"\",Stocks!G4)","v":25},null,null,null,null,{"$f":"IF(F8=\"\",\"\",IF(F8<Stocks!C4,\"Nok\",\"Ok\"))","v":"Ok"},{"$f":"IF(G8=\"\",\"\",IF(G8<Stocks!F4,\"Nok\",\"Ok\"))","v":"Ok"},{"$f":"IF(G8=\"\",\"\",IF(G8>Stocks!F4,\"Nok\",\"Ok\"))","v":"Ok"}]
[{"$f":"Param!E4&\" \"&Param!F4","v":"Révolver N°142322704"},null,null,null,{"$f":"IF(Stocks!A5=\"\",\"\",Stocks!A5)","v":"Fusée détonante"},{"$f":"IF(Stocks!D5=\"\",\"\",Stocks!D5)","v":250},{"$f":"IF(Stocks!G5=\"\",\"\",Stocks!G5)","v":25},null,null,null,null,{"$f":"IF(F9=\"\",\"\",IF(F9<Stocks!C5,\"Nok\",\"Ok\"))","v":"Ok"},{"$f":"IF(G9=\"\",\"\",IF(G9<Stocks!F5,\"Nok\",\"Ok\"))","v":"Ok"},{"$f":"IF(G9=\"\",\"\",IF(G9>Stocks!F5,\"Nok\",\"Ok\"))","v":"Ok"}]
[{"$f":"Param!E5&\" \"&Param!F5","v":"Révolver N°R152578533"},null,null,null,{"$f":"IF(Stocks!A6=\"\",\"\",Stocks!A6)","v":"Capa"},{"$f":"IF(Stocks!D6=\"\",\"\",Stocks!D6)","v":46},{"$f":"IF(Stocks!G6=\"\",\"\",Stocks!G6)","v":5},null,null,null,null,{"$f":"IF(F10=\"\",\"\",IF(F10<Stocks!C6,\"Nok\",\"Ok\"))","v":"Ok"},{"$f":"IF(G10=\"\",\"\",IF(G10<Stocks!F6,\"Nok\",\"Ok\"))","v":"Ok"},{"$f":"IF(G10=\"\",\"\",IF(G10>Stocks!F6,\"Nok\",\"Ok\"))","v":"Ok"}]
[{"$f":"Param!E6&\" \"&Param!F6","v":"Fusil cal 12 N°513891"},null,null,null,{"$f":"IF(Stocks!A7=\"\",\"\",Stocks!A7)","v":"Cartouche à plomb"},{"$f":"IF(Stocks!D7=\"\",\"\",Stocks!D7)","v":225},{"$f":"IF(Stocks!G7=\"\",\"\",Stocks!G7)","v":25},null,null,null,null,{"$f":"IF(F11=\"\",\"\",IF(F11<Stocks!C7,\"Nok\",\"Ok\"))","v":"Ok"},{"$f":"IF(G11=\"\",\"\",IF(G11<Stocks!F7,\"Nok\",\"Ok\"))","v":"Ok"},{"$f":"IF(G11=\"\",\"\",IF(G11>Stocks!F7,\"Nok\",\"Ok\"))","v":"Ok"}]
[{"$f":"Param!E7&\" \"&Param!F7","v":"Filet de capture "},null,null,null,{"$f":"IF(Stocks!A8=\"\",\"\",Stocks!A8)","v":"Bale brenneke"},{"$f":"IF(Stocks!D8=\"\",\"\",Stocks!D8)","v":20},{"$f":"IF(Stocks!G8=\"\",\"\",Stocks!G8)","v":0},null,null,null,null,{"$f":"IF(F12=\"\",\"\",IF(F12<Stocks!C8,\"Nok\",\"Ok\"))","v":"Ok"},{"$f":"IF(G12=\"\",\"\",IF(G12<Stocks!F8,\"Nok\",\"Ok\"))","v":"Ok"},{"$f":"IF(G12=\"\",\"\",IF(G12>Stocks!F8,\"Nok\",\"Ok\"))","v":"Ok"}]
[{"$f":"Param!E8&\" \"&Param!F8","v":"Jumelles "},null,null,null,{"$f":"IF(Stocks!A9=\"\",\"\",Stocks!A9)","v":"Bale flèche"},{"$f":"IF(Stocks!D9=\"\",\"\",Stocks!D9)","v":4},{"$f":"IF(Stocks!G9=\"\",\"\",Stocks!G9)","v":0},null,null,null,null,{"$f":"IF(F13=\"\",\"\",IF(F13<Stocks!C9,\"Nok\",\"Ok\"))","v":"Ok"},{"$f":"IF(G13=\"\",\"\",IF(G13<Stocks!F9,\"Nok\",\"Ok\"))","v":"Ok"},{"$f":"IF(G13=\"\",\"\",IF(G13>Stocks!F9,\"Nok\",\"Ok\"))","v":"Ok"}]
[{"$f":"Param!E9&\" \"&Param!F9","v":"Cage "},null,null,null,{"$f":"IF(Stocks!A10=\"\",\"\",Stocks!A10)","v":""},{"$f":"IF(Stocks!D10=\"\",\"\",Stocks!D10)","v":""},{"$f":"IF(Stocks!G10=\"\",\"\",Stocks!G10)","v":""},null,null,null,null,{"$f":"IF(F14=\"\",\"\",IF(F14<Stocks!C10,\"Nok\",\"Ok\"))","v":""},{"$f":"IF(G14=\"\",\"\",IF(G14<Stocks!F11,\"Nok\",\"Ok\"))","v":""},{"$f":"IF(G14=\"\",\"\",IF(G14>Stocks!F10,\"Nok\",\"Ok\"))","v":""}]
[{"$f":"Param!E10&\" \"&Param!F10","v":"Pince à reptile "},null,null,null,null,"Hr Déb","Hr Fin","Agent en service"]
[{"$f":"Param!E11&\" \"&Param!F11","v":"Lunettes de protection "},null,null,null,"1 ."]
[{"$f":"Param!E12&\" \"&Param!F12","v":"Gants anti morsure "},null,null,null,"2 ,"]
[{"$f":"Param!E13&\" \"&Param!F13","v":"Mat récup cadavre animaux "},null,null,null,"3 ,"]
[{"$f":"Param!E14&\" \"&Param!F14","v":" "},null,null,null,"4 ,"]
["Heure début","Evenements",null,null,null,null,null,"Heure fin","Editeur","n°"]
["vide","vide",null,null,null,null,null,"vide","vide",0]
[]
[]
[]
[]
[]
[]
[]
[]
["consignes",null,null,"Observation générale"]

{"sheet":"Param","index":1,"n_rows":15,"n_cols":16,"rows_kept":15,"cut":false,"hidden":true,"merged":[[0,0,0,1]]}
["Titre",null,null,"iD","Matériel","Ref",null,"Coffre",null,"Caisse",null,"Date","Article","Sorties","Entrées","Arm"]
[null,null,null,1,"Effaroucheur embarqué",null,null,"Amorce à blanc",null,"Amorce à blanc",null,{"$f":"TODAY()","v":"2016-06-05"},"Amorce à blanc",null,null,"<>X"]
["Société","S.S.L.I.A",null,2,"Lance fusée capa","N°1590612",null,"Fusée crépitante",null,"Fusée crépitante",null,null,null,{"$f":"DSUM(BDMouv,N1,L1:P2)","v":0},{"$f":"DSUM(BDMouv,O1,L1:P2)","v":0}]
["Activité","Aéroport Béziers Cap-d'Agde",null,3,"Révolver","N°142322704",null,"Fusée détonante",null,"Fusée détonante",null,"Date","Article","Sorties","Entrées","Arm"]
[null,null,null,4,"Révolver","N°R152578533",null,"Capa",null,"Capa",null,{"$f":"L2","v":"2016-06-05"},"Fusée crépitante",null,null,{"$f":"P2","v":"<>X"}]
[null,null,null,5,"Fusil cal 12","N°513891",null,"Cartouche à plomb",null,"Cartouche à plomb",null,null,null,{"$f":"DSUM(BDMouv,N4,L4:P5)","v":0},{"$f":"DSUM(BDMouv,O4,L4:P5)","v":0}]
[null,null,null,6,"Filet de capture",null,null,"Bale brenneke",null,null,null,"Date","Article","Sorties","Entrées","Arm"]
[null,null,null,7,"Jumelles",null,null,"Bale flèche",null,null,null,{"$f":"L5","v":"2016-06-05"},"Fusée détonante",null,null,{"$f":"P5","v":"<>X"}]
[null,null,null,8,"Cage",null,null,null,null,null,null,null,null,{"$f":"DSUM(BDMouv,N7,L7:P8)","v":0},{"$f":"DSUM(BDMouv,O7,L7:P8)","v":0}]
[null,null,null,9,"Pince à reptile",null,null,null,null,null,null,"Date","Article","Sorties","Entrées","Arm"]
[null,null,null,10,"Lunettes de protection",null,null,null,null,null,null,{"$f":"L8","v":"2016-06-05"},"Capa",null,null,{"$f":"P8","v":"<>X"}]
[null,null,null,11,"Gants anti morsure",null,null,null,null,null,null,null,null,{"$f":"DSUM(BDMouv,N10,L10:P11)","v":0},{"$f":"DSUM(BDMouv,O10,L10:P11)","v":0}]
[null,null,null,12,"Mat récup cadavre animaux",null,null,null,null,null,null,"Date","Article","Sorties","Entrées","Arm"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L11","v":"2016-06-05"},"Cartouche à plomb",null,null,{"$f":"P11","v":"<>X"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DSUM(BDMouv,N13,L13:P14)","v":0},{"$f":"DSUM(BDMouv,O13,L13:P14)","v":0}]

{"sheet":"ListPers","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Personnel","Nom","Prénom"]
["AFONSO Julien","AFONSO","Julien"]
["AUDIÉ Anthony","AUDIÉ","Anthony"]
["CUENCA Ludovic","CUENCA","Ludovic"]
["DISTÉFANO Alexis","DISTÉFANO","Alexis"]
["KOSEL Franck","KOSEL","Franck"]
["LEROY France","LEROY","France"]
["LEROY Jean-Sébastien","LEROY","Jean-Sébastien"]
["NAVARRO Christophe","NAVARRO","Christophe"]
["SANTOS Jean-François","SANTOS","Jean-François"]
["SCHWEITZER Jean-Michel","SCHWEITZER","Jean-Michel"]

{"sheet":"Mouvts","index":3,"n_rows":103,"n_cols":9,"rows_kept":103,"cut":false,"hidden":true,"merged":[]}
["ID","Date","Heure","Article","Sorties","Entrées","Arm","Utilisateur","Observation"]
[1,"2015-12-31","00:00:00","Amorce à blanc",null,500,"X","AUDIÉ Anthony","Inventaire (Stock initial)"]
[2,"2015-12-31","00:00:00","Fusée crépitante",null,250,"X","AUDIÉ Anthony","Inventaire (Stock initial)"]
[3,"2015-12-31","00:00:00","Fusée détonante",null,250,"X","AUDIÉ Anthony","Inventaire (Stock initial)"]
[4,"2015-12-31","00:00:00","Capa",null,50,"X","AUDIÉ Anthony","Inventaire (Stock initial)"]
[5,"2015-12-31","00:00:00","Cartouche à plomb",null,250,"X","AUDIÉ Anthony","Inventaire (Stock initial)"]
[6,"2015-12-31","00:00:00","Bale brenneke",null,20,"X","AUDIÉ Anthony","Inventaire (Stock initial)"]
[7,"2015-12-31","00:00:00","Bale flèche",null,4,"X","AUDIÉ Anthony","Inventaire (Stock initial)"]
[8,"2016-05-27","13:45:02","Amorce à blanc",50,null,"X","SANTOS Jean-François","Appro Caisse"]
[9,"2016-05-27","13:45:12","Fusée crépitante",25,null,"X","SANTOS Jean-François","Appro Caisse"]
[10,"2016-05-27","13:45:29","Fusée détonante",25,null,"X","SANTOS Jean-François","Appro Caisse"]
[11,"2016-05-27","13:45:40","Capa",5,null,"X","SANTOS Jean-François","Appro Caisse"]
[12,"2016-05-27","13:45:51","Cartouche à plomb",25,null,"X","SANTOS Jean-François","Appro Caisse"]
[13,"2016-05-27","13:47:21","Amorce à blanc",null,50,null,"SANTOS Jean-François","Stock"]
[14,"2016-05-27","13:47:34","Fusée crépitante",null,25,null,"SANTOS Jean-François","Stock"]
[15,"2016-05-27","13:47:45","Fusée détonante",null,25,null,"SANTOS Jean-François","Stock"]
[16,"2016-05-27","13:47:56","Capa",null,5,null,"SANTOS Jean-François","Stock"]
[17,"2016-05-27","13:48:05","Cartouche à plomb",null,25,null,"SANTOS Jean-François","Stock"]
[19,"31/05/2016","13:48:14","Amorce à blanc",5,null,null,"LEROY France"]
[20,"31/05/2016","13:48:23","Amorce à blanc",null,5,null,"LEROY France","Réintégration pour stock initial caisse"]
[21,"31/05/2016","13:48:32","Capa",1,null,null,"LEROY France"]
[22,"31/05/2016","13:48:41","Capa",null,1,null,"DISTÉFANO Alexis","Réintégration pour stock initial caisse"]
[26,"31/05/2016","13:48:50","Fusée crépitante",5,null,null,"DISTÉFANO Alexis"]
[27,"2016-06-02","10:52:00","Amorce à blanc",2,null,null,"LEROY France","essai sortie caisse"]
[28,"2016-05-31","12:06:00","Amorce à blanc",2,null,null,"KOSEL Franck",""]
[30,"2016-06-02","12:16:00","Fusée crépitante",2,null,null,"KOSEL Franck",""]
[31,"2016-06-02","12:19:00","Amorce à blanc",2,null,null,"LEROY Jean-Sébastien","$$$$$$$$$$$$$ hello"]
[32,"2016-06-02","12:20:00","Fusée crépitante",2,null,null,"LEROY Jean-Sébastien","????????????????"]
[33,"2016-05-02","12:24:00","Amorce à blanc",5,null,"X","DISTÉFANO Alexis","Appro Caisse"]
[34,"2016-05-02","12:24:00","Amorce à blanc",null,5,null,"DISTÉFANO Alexis","Appro Stock"]
[35,"2016-06-02","12:25:00","Fusée crépitante",5,null,"X","AFONSO Julien","Appro Caisse"]
[36,"2016-06-02","12:25:00","Fusée crépitante",null,5,null,"AFONSO Julien","Appro Stock"]
[37,"2016-06-02","12:25:00","Fusée crépitante",null,10,"X","AFONSO Julien","Approvisionnement ou Inventaire ?"]
[38,"2016-06-02","12:26:00","Amorce à blanc",3,null,"X","LEROY Jean-Sébastien","Appro Caisse"]
[39,"2016-06-02","12:26:00","Amorce à blanc",null,3,null,"DISTÉFANO Alexis","Appro Stock"]
[40,"2016-06-02","12:33:00","Fusée crépitante",3,null,null,"DISTÉFANO Alexis",""]
[41,"2016-06-02","12:33:00","Fusée crépitante",5,null,"X","DISTÉFANO Alexis","Appro Caisse"]
[42,"2016-06-02","12:33:00","Fusée crépitante",null,5,null,"DISTÉFANO Alexis","Appro Stock"]
[43,"2016-06-02","12:33:00","Capa",null,5,"X","DISTÉFANO Alexis","Approvisionnement ou Inventaire ?"]
[44,"2016-06-02","12:34:00","Fusée crépitante",2,null,"X","DISTÉFANO Alexis","Appro Caisse oui"]
[45,"2016-06-02","12:34:00","Fusée crépitante",null,2,null,"DISTÉFANO Alexis","Appro Stock"]
[46,"2016-06-02","15:26:00","Bale flèche",2,null,"X","AUDIÉ Anthony","Appro Caisse sortie direct"]
[47,"2016-06-02","15:26:00","Bale flèche",null,2,null,"AUDIÉ Anthony","Appro Stock"]
[48,"2016-06-02","15:28:00","Bale flèche",1,null,"X","AUDIÉ Anthony","Appro Caisse sortie direct"]
[49,"2016-06-02","15:28:00","Bale flèche",null,1,null,"AUDIÉ Anthony","Appro Stock"]
[50,"2016-06-02","15:57:00","Bale flèche",3,null,null,"AUDIÉ Anthony",""]
[51,"2016-06-02","15:57:00","Amorce à blanc",5,null,null,"DISTÉFANO Alexis",""]
[52,"2016-06-02","16:11:00","Fusée crépitante",5,null,null,"DISTÉFANO Alexis",""]
[53,"2016-06-02","16:13:00","Capa",2,null,null,"DISTÉFANO Alexis",""]
[54,"2016-06-02","16:13:00","Amorce à blanc",8,null,null,"DISTÉFANO Alexis",""]
[55,"2016-06-02","16:15:00","Fusée crépitante",8,null,null,"DISTÉFANO Alexis",""]
[56,"2016-06-02","16:15:00","Capa",2,null,null,"DISTÉFANO Alexis",""]
[57,"2016-06-02","16:15:00","Bale flèche",null,3,"X","DISTÉFANO Alexis","Approvisionnement ou Inventaire ?"]
[58,"2016-06-02","16:37:00","Amorce à blanc",14,null,"X","DISTÉFANO Alexis","Appro Caisse"]
[59,"2016-06-02","16:37:00","Amorce à blanc",null,14,null,"DISTÉFANO Alexis","Appro Stock"]
[60,"2016-06-02","16:40:00","Amorce à blanc",null,1,null,"DISTÉFANO Alexis","Retour caisse"]
[61,"2016-06-02","16:41:00","Amorce à blanc",null,2,"X","DISTÉFANO Alexis","Approvisionnement ou Inventaire ? trop perçu caisse"]
[62,"2016-06-02","16:42:00","Amorce à blanc",2,null,null,"DISTÉFANO Alexis",""]
[63,"2016-06-02","16:43:00","Fusée crépitante",13,null,"X","DISTÉFANO Alexis","Appro Caisse"]
[64,"2016-06-02","16:43:00","Fusée crépitante",null,13,null,"DISTÉFANO Alexis","Appro Stock"]
[65,"2016-06-02","16:44:00","Capa",4,null,"X","DISTÉFANO Alexis","Appro Caisse"]
[66,"2016-06-02","16:44:00","Capa",null,4,null,"DISTÉFANO Alexis","Appro Stock"]
[67,"2016-06-02","16:52:00","Amorce à blanc",1,null,"X","DISTÉFANO Alexis","Appro Caisse"]
[68,"2016-06-02","16:52:00","Amorce à blanc",null,1,null,"DISTÉFANO Alexis","Appro Stock"]
[69,"2016-06-02","16:52:00","Fusée détonante",1,null,null,"DISTÉFANO Alexis",""]
[70,"2016-06-02","16:54:00","Amorce à blanc",1,null,null,"CUENCA Ludovic",""]
[71,"2016-06-02","16:55:00","Amorce à blanc",null,1,"X","CUENCA Ludovic","Approvisionnement ou Inventaire ?"]
[72,"2016-06-02","16:55:00","Fusée détonante",1,null,"X","CUENCA Ludovic","Appro Caisse"]
[73,"2016-06-02","16:55:00","Fusée détonante",null,1,null,"CUENCA Ludovic","Appro Stock"]
[74,"2016-06-02","17:20:00","Amorce à blanc",null,10,"X","KOSEL Franck","Approvisionnement ou Inventaire ?"]
[75,"2016-06-02","17:21:00","Fusée crépitante",null,40,"X","KOSEL Franck","Approvisionnement ou Inventaire ?"]
[76,"2016-06-02","17:22:00","Fusée détonante",null,26,"X","KOSEL Franck","Approvisionnement ou Inventaire ?"]
[77,"2016-06-02","17:23:00","Amorce à blanc",5,null,null,"KOSEL Franck","Suite à visite et effarouchement d'oiseaux"]
[78,"2016-06-02","17:24:00","Fusée crépitante",3,null,null,"KOSEL Franck",""]
[79,"2016-06-02","17:26:00","Amorce à blanc",3,null,"X","KOSEL Franck","Appro Caisse"]
[80,"2016-06-02","17:26:00","Amorce à blanc",null,3,null,"KOSEL Franck","Appro Stock"]
[81,"2016-06-02","17:27:00","Fusée crépitante",3,null,"X","KOSEL Franck","Appro Caisse"]
[82,"2016-06-02","17:27:00","Fusée crépitante",null,3,null,"KOSEL Franck","Appro Stock"]
[83,"2016-06-02","17:27:00","Amorce à blanc",null,13,"X","KOSEL Franck","Approvisionnement ou Inventaire ?"]
[84,"2016-06-02","17:27:00","Fusée crépitante",null,3,"X","KOSEL Franck","Approvisionnement ou Inventaire ?"]
[85,"2016-06-02","19:28:00","Amorce à blanc",2,null,"X","SCHWEITZER Jean-Michel","Appro Caisse"]
[86,"2016-06-02","19:28:00","Amorce à blanc",null,2,null,"SCHWEITZER Jean-Michel","Appro Stock"]
[87,"2016-06-02","19:28:00","Amorce à blanc",2,null,null,"SCHWEITZER Jean-Michel",""]
[88,"2016-06-02","19:29:00","Amorce à blanc",null,2,"X","SCHWEITZER Jean-Michel","Approvisionnement ou Inventaire ?"]
[89,"2016-06-03","10:49:00","Amorce à blanc",3,null,null,"KOSEL Franck",""]
[90,"2016-06-03","10:55:00","Fusée crépitante",3,null,null,"KOSEL Franck",""]
[91,"2016-06-03","11:39:00","Amorce à blanc",1,null,null,"CUENCA Ludovic",""]
[92,"2016-06-03","11:40:00","Amorce à blanc",1,null,"X","CUENCA Ludovic","Appro Caisse"]
[93,"2016-06-03","11:40:00","Amorce à blanc",null,1,null,"CUENCA Ludovic","Appro Stock"]
[94,"2016-06-03","11:44:00","Amorce à blanc",1,null,null,"DISTÉFANO Alexis",""]
[95,"2016-06-03","11:44:00","Amorce à blanc",3,null,"X","DISTÉFANO Alexis","Appro Caisse"]
[96,"2016-06-03","11:44:00","Amorce à blanc",null,3,null,"DISTÉFANO Alexis","Appro Stock"]
[97,"2016-06-03","11:53:00","Amorce à blanc",1,null,"X","DISTÉFANO Alexis","Appro Caisse"]
[98,"2016-06-03","11:53:00","Amorce à blanc",null,1,null,"DISTÉFANO Alexis","Appro Stock"]
[99,"2016-06-03","14:59:00","Amorce à blanc",3,null,null,"LEROY Jean-Sébastien",""]
[100,"2016-06-03","15:02:00","Capa",1,null,"X","LEROY Jean-Sébastien","Appro Caisse"]
[101,"2016-06-03","15:02:00","Capa",null,1,null,"LEROY Jean-Sébastien","Appro Stock"]
[102,"2016-06-03","16:12:00","Capa",1,null,null,"NAVARRO Christophe",""]
[103,"2016-06-03","16:12:00","Capa",null,1,"X","NAVARRO Christophe","Trop perçu dans caisse donc retour"]
[104,"2016-06-03","16:13:00","Amorce à blanc",3,null,"X","NAVARRO Christophe","Appro Caisse"]
[105,"2016-06-03","16:13:00","Amorce à blanc",null,3,null,"NAVARRO Christophe","Appro Stock"]
[106,"2016-06-03","16:13:00","Fusée crépitante",3,null,"X","NAVARRO Christophe","Appro Caisse"]
[107,"2016-06-03","16:13:00","Fusée crépitante",null,3,null,"NAVARRO Christophe","Appro Stock"]

{"sheet":"WsAr","index":4,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["ID","Date","Heure","Article","Sorties","Entrées","Arm","Utilisateur","Observation"]
[30,"31/05/2016","17:23:00","Amorce à blanc",1,null,null,"DISTÉFANO Alexis"]
[31,"2016-06-02","07:51:00","",null,null,null,"KOSEL Franck","Appro Stock"]
[31,"2016-06-02","08:01:00","Fusée crépitante",null,5,null,"NAVARRO Christophe","Appro Stock"]
[36,"2016-06-02","08:11:00","Cartouche à plomb",null,2,null,"AUDIÉ Anthony","Retour caisse"]
[35,"2016-06-02","08:10:00","Cartouche à plomb",5,null,null,"AUDIÉ Anthony",""]
[34,"2016-06-02","08:09:00","Capa",null,20,"X","CUENCA Ludovic","Approvisionnement ou Inventaire ?"]
[32,"2016-06-02","08:09:00","Capa",5,null,"X","CUENCA Ludovic","Appro Caisse"]
[33,"2016-06-02","08:09:00","Capa",null,5,null,"CUENCA Ludovic","Appro Stock"]
[31,"2016-06-02","08:01:00","Fusée crépitante",5,null,"X","NAVARRO Christophe","Appro Caisse"]
[30,"2016-06-02","07:53:00","Fusée crépitante",2,null,null,"LEROY France",""]
[29,"31/05/2016","17:22:00","Fusée détonante",5,null,null,"KOSEL Franck"]
[28,"31/05/2016","17:19:00","Amorce à blanc",5,null,null,"KOSEL Franck"]
[27,"31/05/2016","16:55:00","Amorce à blanc",5,null,null,"DISTÉFANO Alexis"]
[29,"2016-06-02","12:08:00","Amorce à blanc",2,null,null,"KOSEL Franck",""]

{"sheet":"Stocks","index":5,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Tableau calcul stock",null,"Armurerie",null,null,null,"Caisse VPA"]
["Article","N° Lot","Stock mini.","Nouv stock.","Alerte com","Stock mini","Nouv stock","Alerte com."]
["Amorce à blanc",null,250,{"$f":"SUMPRODUCT((Mouvts!$D$2:$D$65536=A3)*(Mouvts!$G$2:$G$65536=\"X\"),Mouvts!$F$2:$F$65536)-SUMPRODUCT((Mouvts!$D$2:$D$65536=A3)*(Mouvts!$G$2:$G$65536=\"X\"),Mouvts!$E$2:$E$65536)","v":442},{"$f":"IF(OR(TabStock[[#This Row],[Nouv stock.]]=0,TabStock[[#This Row],[Nouv stock.]]<TabStock[[#This Row],[Stock mini.]]),\"A commander\",\"\")","v":""},50,{"$f":"SUMPRODUCT((Mouvts!$D$2:$D$65536=A3)*(Mouvts!$G$2:$G$65536=\"\"),Mouvts!$F$2:$F$65536)-SUMPRODUCT((Mouvts!$D$2:$D$65536=A3)*(Mouvts!$G$2:$G$65536=\"\"),Mouvts!$E$2:$E$65536)","v":50},{"$f":"IF(TabStock[Stock mini]>0,IF(TabStock[Nouv stock]<TabStock[Stock mini],\"A approvisionner\",\"\"),\"\")","v":""},null,{"$f":"IF(TabStock[Stock mini]>0,IF(TabStock[Nouv stock]<TabStock[Stock mini],\"A commander\",\"\"),\"\")","v":""}]
["Fusée crépitante",null,125,{"$f":"SUMPRODUCT((Mouvts!$D$2:$D$65536=A4)*(Mouvts!$G$2:$G$65536=\"X\"),Mouvts!$F$2:$F$65536)-SUMPRODUCT((Mouvts!$D$2:$D$65536=A4)*(Mouvts!$G$2:$G$65536=\"X\"),Mouvts!$E$2:$E$65536)","v":247},{"$f":"IF(OR(TabStock[[#This Row],[Nouv stock.]]=0,TabStock[[#This Row],[Nouv stock.]]<TabStock[[#This Row],[Stock mini.]]),\"A commander\",\"\")","v":""},25,{"$f":"SUMPRODUCT((Mouvts!$D$2:$D$65536=A4)*(Mouvts!$G$2:$G$65536=\"\"),Mouvts!$F$2:$F$65536)-SUMPRODUCT((Mouvts!$D$2:$D$65536=A4)*(Mouvts!$G$2:$G$65536=\"\"),Mouvts!$E$2:$E$65536)","v":25},{"$f":"IF(TabStock[Stock mini]>0,IF(TabStock[Nouv stock]<TabStock[Stock mini],\"A approvisionner\",\"\"),\"\")","v":""},null,{"$f":"IF(TabStock[Stock mini]>0,IF(TabStock[Nouv stock]<TabStock[Stock mini],\"A commander\",\"\"),\"\")","v":""}]
["Fusée détonante",null,125,{"$f":"SUMPRODUCT((Mouvts!$D$2:$D$65536=A5)*(Mouvts!$G$2:$G$65536=\"X\"),Mouvts!$F$2:$F$65536)-SUMPRODUCT((Mouvts!$D$2:$D$65536=A5)*(Mouvts!$G$2:$G$65536=\"X\"),Mouvts!$E$2:$E$65536)","v":250},{"$f":"IF(OR(TabStock[[#This Row],[Nouv stock.]]=0,TabStock[[#This Row],[Nouv stock.]]<TabStock[[#This Row],[Stock mini.]]),\"A commander\",\"\")","v":""},25,{"$f":"SUMPRODUCT((Mouvts!$D$2:$D$65536=A5)*(Mouvts!$G$2:$G$65536=\"\"),Mouvts!$F$2:$F$65536)-SUMPRODUCT((Mouvts!$D$2:$D$65536=A5)*(Mouvts!$G$2:$G$65536=\"\"),Mouvts!$E$2:$E$65536)","v":25},{"$f":"IF(TabStock[Stock mini]>0,IF(TabStock[Nouv stock]<TabStock[Stock mini],\"A approvisionner\",\"\"),\"\")","v":""},null,{"$f":"IF(TabStock[Stock mini]>0,IF(TabStock[Nouv stock]<TabStock[Stock mini],\"A commander\",\"\"),\"\")","v":""}]
["Capa",null,10,{"$f":"SUMPRODUCT((Mouvts!$D$2:$D$65536=A6)*(Mouvts!$G$2:$G$65536=\"X\"),Mouvts!$F$2:$F$65536)-SUMPRODUCT((Mouvts!$D$2:$D$65536=A6)*(Mouvts!$G$2:$G$65536=\"X\"),Mouvts!$E$2:$E$65536)","v":46},{"$f":"IF(OR(TabStock[[#This Row],[Nouv stock.]]=0,TabStock[[#This Row],[Nouv stock.]]<TabStock[[#This Row],[Stock mini.]]),\"A commander\",\"\")","v":""},5,{"$f":"SUMPRODUCT((Mouvts!$D$2:$D$65536=A6)*(Mouvts!$G$2:$G$65536=\"\"),Mouvts!$F$2:$F$65536)-SUMPRODUCT((Mouvts!$D$2:$D$65536=A6)*(Mouvts!$G$2:$G$65536=\"\"),Mouvts!$E$2:$E$65536)","v":5},{"$f":"IF(TabStock[Stock mini]>0,IF(TabStock[Nouv stock]<TabStock[Stock mini],\"A approvisionner\",\"\"),\"\")","v":""},null,{"$f":"IF(TabStock[Stock mini]>0,IF(TabStock[Nouv stock]<TabStock[Stock mini],\"A commander\",\"\"),\"\")","v":""}]
["Cartouche à plomb",null,125,{"$f":"SUMPRODUCT((Mouvts!$D$2:$D$65536=A7)*(Mouvts!$G$2:$G$65536=\"X\"),Mouvts!$F$2:$F$65536)-SUMPRODUCT((Mouvts!$D$2:$D$65536=A7)*(Mouvts!$G$2:$G$65536=\"X\"),Mouvts!$E$2:$E$65536)","v":225},{"$f":"IF(OR(TabStock[[#This Row],[Nouv stock.]]=0,TabStock[[#This Row],[Nouv stock.]]<TabStock[[#This Row],[Stock mini.]]),\"A commander\",\"\")","v":""},25,{"$f":"SUMPRODUCT((Mouvts!$D$2:$D$65536=A7)*(Mouvts!$G$2:$G$65536=\"\"),Mouvts!$F$2:$F$65536)-SUMPRODUCT((Mouvts!$D$2:$D$65536=A7)*(Mouvts!$G$2:$G$65536=\"\"),Mouvts!$E$2:$E$65536)","v":25},{"$f":"IF(TabStock[Stock mini]>0,IF(TabStock[Nouv stock]<TabStock[Stock mini],\"A approvisionner\",\"\"),\"\")","v":""},null,{"$f":"IF(TabStock[Stock mini]>0,IF(TabStock[Nouv stock]<TabStock[Stock mini],\"A commander\",\"\"),\"\")","v":""}]
["Bale brenneke",null,10,{"$f":"SUMPRODUCT((Mouvts!$D$2:$D$65536=A8)*(Mouvts!$G$2:$G$65536=\"X\"),Mouvts!$F$2:$F$65536)-SUMPRODUCT((Mouvts!$D$2:$D$65536=A8)*(Mouvts!$G$2:$G$65536=\"X\"),Mouvts!$E$2:$E$65536)","v":20},{"$f":"IF(OR(TabStock[[#This Row],[Nouv stock.]]=0,TabStock[[#This Row],[Nouv stock.]]<TabStock[[#This Row],[Stock mini.]]),\"A commander\",\"\")","v":""},0,{"$f":"SUMPRODUCT((Mouvts!$D$2:$D$65536=A8)*(Mouvts!$G$2:$G$65536=\"\"),Mouvts!$F$2:$F$65536)-SUMPRODUCT((Mouvts!$D$2:$D$65536=A8)*(Mouvts!$G$2:$G$65536=\"\"),Mouvts!$E$2:$E$65536)","v":0},{"$f":"IF(TabStock[Stock mini]>0,IF(TabStock[Nouv stock]<TabStock[Stock mini],\"A approvisionner\",\"\"),\"\")","v":""},null,{"$f":"IF(TabStock[Stock mini]>0,IF(TabStock[Nouv stock]<TabStock[Stock mini],\"A commander\",\"\"),\"\")","v":""}]
["Bale flèche",null,2,{"$f":"SUMPRODUCT((Mouvts!$D$2:$D$65536=A9)*(Mouvts!$G$2:$G$65536=\"X\"),Mouvts!$F$2:$F$65536)-SUMPRODUCT((Mouvts!$D$2:$D$65536=A9)*(Mouvts!$G$2:$G$65536=\"X\"),Mouvts!$E$2:$E$65536)","v":4},{"$f":"IF(OR(TabStock[[#This Row],[Nouv stock.]]=0,TabStock[[#This Row],[Nouv stock.]]<TabStock[[#This Row],[Stock mini.]]),\"A commander\",\"\")","v":""},0,{"$f":"SUMPRODUCT((Mouvts!$D$2:$D$65536=A9)*(Mouvts!$G$2:$G$65536=\"\"),Mouvts!$F$2:$F$65536)-SUMPRODUCT((Mouvts!$D$2:$D$65536=A9)*(Mouvts!$G$2:$G$65536=\"\"),Mouvts!$E$2:$E$65536)","v":0},{"$f":"IF(TabStock[Stock mini]>0,IF(TabStock[Nouv stock]<TabStock[Stock mini],\"A approvisionner\",\"\"),\"\")","v":""},null,{"$f":"IF(TabStock[Stock mini]>0,IF(TabStock[Nouv stock]<TabStock[Stock mini],\"A commander\",\"\"),\"\")","v":""}]