{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["DEVIS","PROJETS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"DEVIS","index":0,"n_rows":24,"n_cols":48,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Sociétés","Origine de la demande","N° Projet","Date du devis","Description","Montant\npotentiel"," Date livraison \nJANVAN","Date livraison \nCHINE","Statut","Remarques",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Facturé"]
[null,"A","Entrant site","PR1321","2017-07-04","2000 LP030",4690,"2017-08-05",null,"Commande reçue"]
[null,"B","Entrant site","PR1322","2017-07-05","50/100 Mobile Brackets",482,null,null,"Annulé"]
[null,"C","Entrant site","PR1326","2017-07-07","2800 LP030",6080,"2017-11-15",null,"Pas de nouvelle"]
[null,"D","Entrant site","PR1329","2017-07-11","1000 ou 2000 LP030 / Ballons 35cm",10000,null,null,"Pas de nouvelle"]
[null,"E","Entrant site","PR1332","2017-07-12","1500 LP030",3774,"2017-08-20",null,"Commande reçue"]
[null,"F","Entrant site","PR1333","2017-07-12","40 Enceintes BT",678,null,null,"Annulé",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bon de commande","Reception logo","OK BAT","Virement effectué","OK éléments"]
[null,"G","Entrant site","PR1334","2017-07-17","100 LP030",432,null,null,"Pas de nouvelle","En attente d'une réponse de son C.A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pas de nouvelle","Annulé","Commande à venir","Commande reçue"]
[null,"H","Entrant site","PR1338","2017-07-20","100 Enceintes BT",1434,null,null,"Pas de nouvelle","Son supérieur en congé pas d'urgence"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entrant site","Payintech","Client existant","Conact Alexandre","Contact Valentin","Autre"]

{"sheet":"PROJETS","index":1,"n_rows":25,"n_cols":41,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,9,1,12],[4,0,5,0]]}
[null,"La partie que je veux automatisée va donc de B4 à L25",null,null,null,null,null,null,null," ",null,"  "]
[null,null,null,null,null,null,null,null,null,"ELEMENTS DE COMMANDE"]
[null,"Sociétés","Origine de la demande","N° Projet","Date du devis","Description","Montant"," Date livraison \nFR","Date livraison \nCH","Devis signé","Logo reçu","Ok BAT","Virement OK","OK éléments","Statut","Règlement","Remarques",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Facturé"]
[null,null,null,null,null,null,null,null,null,"X","X","X","X",{"$f":"IF(M4=\"X\",\"OK\",\"non\")","v":"OK"},"Livré","Réglé 100%"]
["Mon but est d'optimiser le tableau afin qu'il masque/supprime automatiquement les lignes vide. Afin d'évité les trous comme ci contre",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M5=\"X\",\"OK\",\"non\")","v":"non"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"non",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bon de commande","Reception logo","OK BAT","Virement effectué","OK éléments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"non",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fabrication en cours","Livré"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Réglé 100%","Réglé 50%","Réglé 30%","Non réglé"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M25=\"X\",\"OK\",\"non\")","v":"non"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entrant site","Payintech","Client existant","Conact Alexandre","Contact Valentin","Autre"]