{"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,{"$f":"IF(DEVIS!J4=\"Commande reçue\",DEVIS!B4,\"\")","v":"A"},{"$f":"IF(DEVIS!J4=\"Commande reçue\",DEVIS!C4,\"\")","v":"Entrant site"},{"$f":"IF(DEVIS!J4=\"Commande reçue\",DEVIS!D4,\"\")","v":"PR1321"},{"$f":"IF(DEVIS!J4=\"Commande reçue\",DEVIS!E4,\"\")","v":"2017-07-04"},{"$f":"IF(DEVIS!J4=\"Commande reçue\",DEVIS!F4,\"\")","v":"2000 LP030"},{"$f":"IF(DEVIS!J4=\"Commande reçue\",DEVIS!G4,\"\")","v":4690},{"$f":"IF(DEVIS!J4=\"Commande reçue\",DEVIS!H4,\"\")","v":"2017-08-05"},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",{"$f":"IF(DEVIS!J5=\"Commande reçue\",DEVIS!B5,\"\")","v":""},{"$f":"IF(DEVIS!J5=\"Commande reçue\",DEVIS!C5,\"\")","v":""},{"$f":"IF(DEVIS!J5=\"Commande reçue\",DEVIS!D5,\"\")","v":""},{"$f":"IF(DEVIS!J5=\"Commande reçue\",DEVIS!E5,\"\")","v":""},{"$f":"IF(DEVIS!J5=\"Commande reçue\",DEVIS!F5,\"\")","v":""},{"$f":"IF(DEVIS!J5=\"Commande reçue\",DEVIS!G5,\"\")","v":""},{"$f":"IF(DEVIS!J5=\"Commande reçue\",DEVIS!H5,\"\")","v":""},null,null,null,null,null,{"$f":"IF(M5=\"X\",\"OK\",\"non\")","v":"non"}]
[null,{"$f":"IF(DEVIS!J6=\"Commande reçue\",DEVIS!B6,\"\")","v":""},{"$f":"IF(DEVIS!J6=\"Commande reçue\",DEVIS!C6,\"\")","v":""},{"$f":"IF(DEVIS!J6=\"Commande reçue\",DEVIS!D6,\"\")","v":""},{"$f":"IF(DEVIS!J6=\"Commande reçue\",DEVIS!E6,\"\")","v":""},{"$f":"IF(DEVIS!J6=\"Commande reçue\",DEVIS!F6,\"\")","v":""},{"$f":"IF(DEVIS!J6=\"Commande reçue\",DEVIS!G6,\"\")","v":""},{"$f":"IF(DEVIS!J6=\"Commande reçue\",DEVIS!H6,\"\")","v":""},null,null,null,null,null,"non"]
[null,{"$f":"IF(DEVIS!J7=\"Commande reçue\",DEVIS!B7,\"\")","v":""},{"$f":"IF(DEVIS!J7=\"Commande reçue\",DEVIS!C7,\"\")","v":""},{"$f":"IF(DEVIS!J7=\"Commande reçue\",DEVIS!D7,\"\")","v":""},{"$f":"IF(DEVIS!J7=\"Commande reçue\",DEVIS!E7,\"\")","v":""},{"$f":"IF(DEVIS!J7=\"Commande reçue\",DEVIS!F7,\"\")","v":""},{"$f":"IF(DEVIS!J7=\"Commande reçue\",DEVIS!G7,\"\")","v":""},{"$f":"IF(DEVIS!J7=\"Commande reçue\",DEVIS!H7,\"\")","v":""},null,null,null,null,null,"non"]
[null,{"$f":"IF(DEVIS!J8=\"Commande reçue\",DEVIS!B8,\"\")","v":"E"},{"$f":"IF(DEVIS!J8=\"Commande reçue\",DEVIS!C8,\"\")","v":"Entrant site"},{"$f":"IF(DEVIS!J8=\"Commande reçue\",DEVIS!D8,\"\")","v":"PR1332"},{"$f":"IF(DEVIS!J8=\"Commande reçue\",DEVIS!E8,\"\")","v":"2017-07-12"},{"$f":"IF(DEVIS!J8=\"Commande reçue\",DEVIS!F8,\"\")","v":"1500 LP030"},{"$f":"IF(DEVIS!J8=\"Commande reçue\",DEVIS!G8,\"\")","v":3774},{"$f":"IF(DEVIS!J8=\"Commande reçue\",DEVIS!H8,\"\")","v":"2017-08-20"},null,"X","X",null,null,"non"]
[null,{"$f":"IF(DEVIS!J9=\"Commande reçue\",DEVIS!B9,\"\")","v":""},{"$f":"IF(DEVIS!J9=\"Commande reçue\",DEVIS!C9,\"\")","v":""},{"$f":"IF(DEVIS!J9=\"Commande reçue\",DEVIS!D9,\"\")","v":""},{"$f":"IF(DEVIS!J9=\"Commande reçue\",DEVIS!E9,\"\")","v":""},{"$f":"IF(DEVIS!J9=\"Commande reçue\",DEVIS!F9,\"\")","v":""},{"$f":"IF(DEVIS!J9=\"Commande reçue\",DEVIS!G9,\"\")","v":""},{"$f":"IF(DEVIS!J9=\"Commande reçue\",DEVIS!H9,\"\")","v":""},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,{"$f":"IF(DEVIS!J10=\"Commande reçue\",DEVIS!B10,\"\")","v":""},{"$f":"IF(DEVIS!J10=\"Commande reçue\",DEVIS!C10,\"\")","v":""},{"$f":"IF(DEVIS!J10=\"Commande reçue\",DEVIS!D10,\"\")","v":""},{"$f":"IF(DEVIS!J10=\"Commande reçue\",DEVIS!E10,\"\")","v":""},{"$f":"IF(DEVIS!J10=\"Commande reçue\",DEVIS!F10,\"\")","v":""},{"$f":"IF(DEVIS!J10=\"Commande reçue\",DEVIS!G10,\"\")","v":""},{"$f":"IF(DEVIS!J10=\"Commande reçue\",DEVIS!H10,\"\")","v":""},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,{"$f":"IF(DEVIS!J11=\"Commande reçue\",DEVIS!B11,\"\")","v":""},{"$f":"IF(DEVIS!J11=\"Commande reçue\",DEVIS!C11,\"\")","v":""},{"$f":"IF(DEVIS!J11=\"Commande reçue\",DEVIS!D11,\"\")","v":""},{"$f":"IF(DEVIS!J11=\"Commande reçue\",DEVIS!E11,\"\")","v":""},{"$f":"IF(DEVIS!J11=\"Commande reçue\",DEVIS!F11,\"\")","v":""},{"$f":"IF(DEVIS!J11=\"Commande reçue\",DEVIS!G11,\"\")","v":""},{"$f":"IF(DEVIS!J11=\"Commande reçue\",DEVIS!H11,\"\")","v":""},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,{"$f":"IF(DEVIS!J12=\"Commande reçue\",DEVIS!B12,\"\")","v":""},{"$f":"IF(DEVIS!J12=\"Commande reçue\",DEVIS!C12,\"\")","v":""},{"$f":"IF(DEVIS!J12=\"Commande reçue\",DEVIS!D12,\"\")","v":""},{"$f":"IF(DEVIS!J12=\"Commande reçue\",DEVIS!E12,\"\")","v":""},{"$f":"IF(DEVIS!J12=\"Commande reçue\",DEVIS!F12,\"\")","v":""},{"$f":"IF(DEVIS!J12=\"Commande reçue\",DEVIS!G12,\"\")","v":""},{"$f":"IF(DEVIS!J12=\"Commande reçue\",DEVIS!H12,\"\")","v":""}]
[null,{"$f":"IF(DEVIS!J13=\"Commande reçue\",DEVIS!B13,\"\")","v":""},{"$f":"IF(DEVIS!J13=\"Commande reçue\",DEVIS!C13,\"\")","v":""},{"$f":"IF(DEVIS!J13=\"Commande reçue\",DEVIS!D13,\"\")","v":""},{"$f":"IF(DEVIS!J13=\"Commande reçue\",DEVIS!E13,\"\")","v":""},{"$f":"IF(DEVIS!J13=\"Commande reçue\",DEVIS!F13,\"\")","v":""},{"$f":"IF(DEVIS!J13=\"Commande reçue\",DEVIS!G13,\"\")","v":""},{"$f":"IF(DEVIS!J13=\"Commande reçue\",DEVIS!H13,\"\")","v":""}]
[null,{"$f":"IF(DEVIS!J14=\"Commande reçue\",DEVIS!B14,\"\")","v":""},{"$f":"IF(DEVIS!J14=\"Commande reçue\",DEVIS!C14,\"\")","v":""},{"$f":"IF(DEVIS!J14=\"Commande reçue\",DEVIS!D14,\"\")","v":""},{"$f":"IF(DEVIS!J14=\"Commande reçue\",DEVIS!E14,\"\")","v":""},{"$f":"IF(DEVIS!J14=\"Commande reçue\",DEVIS!F14,\"\")","v":""},{"$f":"IF(DEVIS!J14=\"Commande reçue\",DEVIS!G14,\"\")","v":""},{"$f":"IF(DEVIS!J14=\"Commande reçue\",DEVIS!H14,\"\")","v":""}]
[null,{"$f":"IF(DEVIS!J15=\"Commande reçue\",DEVIS!B15,\"\")","v":""},{"$f":"IF(DEVIS!J15=\"Commande reçue\",DEVIS!C15,\"\")","v":""},{"$f":"IF(DEVIS!J15=\"Commande reçue\",DEVIS!D15,\"\")","v":""},{"$f":"IF(DEVIS!J15=\"Commande reçue\",DEVIS!E15,\"\")","v":""},{"$f":"IF(DEVIS!J15=\"Commande reçue\",DEVIS!F15,\"\")","v":""},{"$f":"IF(DEVIS!J15=\"Commande reçue\",DEVIS!G15,\"\")","v":""},{"$f":"IF(DEVIS!J15=\"Commande reçue\",DEVIS!H15,\"\")","v":""}]
[null,{"$f":"IF(DEVIS!J16=\"Commande reçue\",DEVIS!B16,\"\")","v":""},{"$f":"IF(DEVIS!J16=\"Commande reçue\",DEVIS!C16,\"\")","v":""},{"$f":"IF(DEVIS!J16=\"Commande reçue\",DEVIS!D16,\"\")","v":""},{"$f":"IF(DEVIS!J16=\"Commande reçue\",DEVIS!E16,\"\")","v":""},{"$f":"IF(DEVIS!J16=\"Commande reçue\",DEVIS!F16,\"\")","v":""},{"$f":"IF(DEVIS!J16=\"Commande reçue\",DEVIS!G16,\"\")","v":""},{"$f":"IF(DEVIS!J16=\"Commande reçue\",DEVIS!H16,\"\")","v":""}]
[null,{"$f":"IF(DEVIS!J17=\"Commande reçue\",DEVIS!B17,\"\")","v":""},{"$f":"IF(DEVIS!J17=\"Commande reçue\",DEVIS!C17,\"\")","v":""},{"$f":"IF(DEVIS!J17=\"Commande reçue\",DEVIS!D17,\"\")","v":""},{"$f":"IF(DEVIS!J17=\"Commande reçue\",DEVIS!E17,\"\")","v":""},{"$f":"IF(DEVIS!J17=\"Commande reçue\",DEVIS!F17,\"\")","v":""},{"$f":"IF(DEVIS!J17=\"Commande reçue\",DEVIS!G17,\"\")","v":""},{"$f":"IF(DEVIS!J17=\"Commande reçue\",DEVIS!H17,\"\")","v":""}]
[null,{"$f":"IF(DEVIS!J18=\"Commande reçue\",DEVIS!B18,\"\")","v":""},{"$f":"IF(DEVIS!J18=\"Commande reçue\",DEVIS!C18,\"\")","v":""},{"$f":"IF(DEVIS!J18=\"Commande reçue\",DEVIS!D18,\"\")","v":""},{"$f":"IF(DEVIS!J18=\"Commande reçue\",DEVIS!E18,\"\")","v":""},{"$f":"IF(DEVIS!J18=\"Commande reçue\",DEVIS!F18,\"\")","v":""},{"$f":"IF(DEVIS!J18=\"Commande reçue\",DEVIS!G18,\"\")","v":""},{"$f":"IF(DEVIS!J18=\"Commande reçue\",DEVIS!H18,\"\")","v":""}]
[null,{"$f":"IF(DEVIS!J19=\"Commande reçue\",DEVIS!B19,\"\")","v":""},{"$f":"IF(DEVIS!J19=\"Commande reçue\",DEVIS!C19,\"\")","v":""},{"$f":"IF(DEVIS!J19=\"Commande reçue\",DEVIS!D19,\"\")","v":""},{"$f":"IF(DEVIS!J19=\"Commande reçue\",DEVIS!E19,\"\")","v":""},{"$f":"IF(DEVIS!J19=\"Commande reçue\",DEVIS!F19,\"\")","v":""},{"$f":"IF(DEVIS!J19=\"Commande reçue\",DEVIS!G19,\"\")","v":""},{"$f":"IF(DEVIS!J19=\"Commande reçue\",DEVIS!H19,\"\")","v":""}]
[null,{"$f":"IF(DEVIS!J20=\"Commande reçue\",DEVIS!B20,\"\")","v":""},{"$f":"IF(DEVIS!J20=\"Commande reçue\",DEVIS!C20,\"\")","v":""},{"$f":"IF(DEVIS!J20=\"Commande reçue\",DEVIS!D20,\"\")","v":""},{"$f":"IF(DEVIS!J20=\"Commande reçue\",DEVIS!E20,\"\")","v":""},{"$f":"IF(DEVIS!J20=\"Commande reçue\",DEVIS!F20,\"\")","v":""},{"$f":"IF(DEVIS!J20=\"Commande reçue\",DEVIS!G20,\"\")","v":""},{"$f":"IF(DEVIS!J20=\"Commande reçue\",DEVIS!H20,\"\")","v":""}]
[null,{"$f":"IF(DEVIS!J21=\"Commande reçue\",DEVIS!B21,\"\")","v":""},{"$f":"IF(DEVIS!J21=\"Commande reçue\",DEVIS!C21,\"\")","v":""},{"$f":"IF(DEVIS!J21=\"Commande reçue\",DEVIS!D21,\"\")","v":""},{"$f":"IF(DEVIS!J21=\"Commande reçue\",DEVIS!E21,\"\")","v":""},{"$f":"IF(DEVIS!J21=\"Commande reçue\",DEVIS!F21,\"\")","v":""},{"$f":"IF(DEVIS!J21=\"Commande reçue\",DEVIS!G21,\"\")","v":""},{"$f":"IF(DEVIS!J21=\"Commande reçue\",DEVIS!H21,\"\")","v":""}]
[null,{"$f":"IF(DEVIS!J22=\"Commande reçue\",DEVIS!B22,\"\")","v":""},{"$f":"IF(DEVIS!J22=\"Commande reçue\",DEVIS!C22,\"\")","v":""},{"$f":"IF(DEVIS!J22=\"Commande reçue\",DEVIS!D22,\"\")","v":""},{"$f":"IF(DEVIS!J22=\"Commande reçue\",DEVIS!E22,\"\")","v":""},{"$f":"IF(DEVIS!J22=\"Commande reçue\",DEVIS!F22,\"\")","v":""},{"$f":"IF(DEVIS!J22=\"Commande reçue\",DEVIS!G22,\"\")","v":""},{"$f":"IF(DEVIS!J22=\"Commande reçue\",DEVIS!H22,\"\")","v":""}]
[null,{"$f":"IF(DEVIS!J23=\"Commande reçue\",DEVIS!B23,\"\")","v":""},{"$f":"IF(DEVIS!J23=\"Commande reçue\",DEVIS!C23,\"\")","v":""},{"$f":"IF(DEVIS!J23=\"Commande reçue\",DEVIS!D23,\"\")","v":""},{"$f":"IF(DEVIS!J23=\"Commande reçue\",DEVIS!E23,\"\")","v":""},{"$f":"IF(DEVIS!J23=\"Commande reçue\",DEVIS!F23,\"\")","v":""},{"$f":"IF(DEVIS!J23=\"Commande reçue\",DEVIS!G23,\"\")","v":""},{"$f":"IF(DEVIS!J23=\"Commande reçue\",DEVIS!H23,\"\")","v":""}]
[null,{"$f":"IF(DEVIS!J24=\"Commande reçue\",DEVIS!B24,\"\")","v":""},{"$f":"IF(DEVIS!J24=\"Commande reçue\",DEVIS!C24,\"\")","v":""},{"$f":"IF(DEVIS!J24=\"Commande reçue\",DEVIS!D24,\"\")","v":""},{"$f":"IF(DEVIS!J24=\"Commande reçue\",DEVIS!E24,\"\")","v":""},{"$f":"IF(DEVIS!J24=\"Commande reçue\",DEVIS!F24,\"\")","v":""},{"$f":"IF(DEVIS!J24=\"Commande reçue\",DEVIS!G24,\"\")","v":""},{"$f":"IF(DEVIS!J24=\"Commande reçue\",DEVIS!H24,\"\")","v":""}]
[null,{"$f":"IF(DEVIS!J25=\"Commande reçue\",DEVIS!B25,\"\")","v":""},{"$f":"IF(DEVIS!J25=\"Commande reçue\",DEVIS!C25,\"\")","v":""},{"$f":"IF(DEVIS!J25=\"Commande reçue\",DEVIS!D25,\"\")","v":""},{"$f":"IF(DEVIS!J25=\"Commande reçue\",DEVIS!E25,\"\")","v":""},{"$f":"IF(DEVIS!J25=\"Commande reçue\",DEVIS!F25,\"\")","v":""},{"$f":"IF(DEVIS!J25=\"Commande reçue\",DEVIS!G25,\"\")","v":""},{"$f":"IF(DEVIS!J25=\"Commande reçue\",DEVIS!H25,\"\")","v":""},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"]