{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Entreesav","Suivisav","BOSE","Alpines"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":75,"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":"Entreesav","index":0,"n_rows":64,"n_cols":14,"rows_kept":64,"cut":false,"hidden":false,"merged":[[63,0,63,11],[18,11,19,11],[29,0,31,1],[18,0,19,0],[18,1,19,1],[18,2,19,2],[18,3,19,3],[58,3,61,10],[29,2,31,11],[18,4,18,10],[33,0,45,1],[33,2,45,11],[17,0,17,2],[1,3,1,11],[5,8,5,11],[3,6,3,9],[3,3,3,5],[15,8,15,10],[6,8,6,10],[12,8,12,10],[13,8,13,10],[14,8,14,10],[7,11,10,11],[7,8,10,10],[11,8,11,10]]}
[]
[null,null,null,"Prise en charge du Matériel en SAV"]
[]
[null,null,null,"Date d'entrée :",null,null,{"$f":"TODAY()","v":"2019-01-08"},null,null,null,"  N° de dépôt :",2]
[]
[null,null,null,null,null,null,null,null,"Identité client :"]
[null,null,null,null,null,null,null,null,"Société :"]
[null,null,null,null,null,null,null,null,"Adresse :"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"SAUVEGARDER"]
[]
[null,null,null,null,null,null,null,null,"CP - Ville"]
[null,null,null,null,null,null,null,null,"Nom :"]
[null,null,null,null,null,null,null,null,"Téléphone :"]
[null,null,null,null,null,null,null,null,"Télécopie :"]
[null,null,null,null,null,null,null,null,"E-mail : "]
[]
["Identification du matériel :"]
["Marque :","Modèle :","N° de série :","N° :","ACCESSOIRES :",null,null,null,null,null,null,"Problème :"]
[null,null,null,null,"AT","BT","CH","PI","CC","MC","Autre :"]
[]
[]
[]
[]
[]
[]
[]
["Accessoires : AT = Antennes, BT = Batterie, CH = chargeur, MC = Micro "]
[]
["Informations supplémentaires :"]
[]
[]
[]
["INFO CLIENT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Conditions de prise en charge :"]
[]
[]
[]
["Condition de retour :"]
["Date :",null,null,"Nom signataire pour accord retour :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["MERCI DE RENDRE TOUS LES DOCUMENTS JOINTS AVEC CETTE PRISE EN CHARGE"]

{"sheet":"Suivisav","index":1,"n_rows":5,"n_cols":12,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["N° Dépôt SAV","Client","Date d'entrée","Marque","Modèle","N/S","Accessoires","Réparation usine départ","Réparation usine retour","Mode retour client","Date retour client","Accord retour"]
[1,"ROGER","2019-01-07","BOSE","KKJ15","0152396855","antenne, batterie,"]
[1,"ROGER","2019-01-07","BOSE","KKJ15","0152396855","antenne, batterie, "]
[1,"ROGER","2019-01-07","BOSE","KKJ15","0152396855","antenne, batterie, "]
[1,"ROGER","2019-01-07","BOSE","KKJ15","0152396855","antenne, batterie, "]

{"sheet":"BOSE","index":2,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["N° Dépôt SAV","EXPEDITEUR","DATE EXPEDITION","DATE RETOUR","N° TNT","REFERENCE APPEL","MARQUE","MODELE","N° Série","ACCESSOIRES"]
[1,{"$f":"IF(A2=\"\",\"\",VLOOKUP(A2, SAV,2,FALSE))","v":"ROGER"},null,null,null,null,{"$f":"IF($A2=\"\",\"\",INDEX(SAV,MATCH(BOSE!$I2,Suivisav!$F:$F,0),5))","v":"KKJ15"},{"$f":"IF($A2=\"\",\"\",INDEX(SAV,MATCH(BOSE!$I2,Suivisav!$F:$F,0),5))","v":"KKJ15"},"0152396855"]

{"sheet":"Alpines","index":3,"n_rows":56,"n_cols":9,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["N° Dépôt SAV","N° DOSSIER","CLIENT","DATE EXPEDITION","DATE RETOUR","Marque","Modèle","N° SERIE","ACCESSOIRES"]
[1,{"$f":"IF(A2=\"\",\"\",VLOOKUP(A2, SAV,2,FALSE))","v":"ROGER"},null,null,null,{"$f":"IF($A2=\"\",\"\",INDEX(SAV,MATCH(BOSE!$I2,Suivisav!$F:$F,0),5))","v":"KKJ15"},{"$f":"IF($A2=\"\",\"\",INDEX(SAV,MATCH(BOSE!$I2,Suivisav!$F:$F,0),5))","v":"KKJ15"},"0152396855"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Vu NT",null,null,null,null,null,null,"Vu NT"]