{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Menu principal","Tableau de suivi","Suivi des documents","Dossiers clôturés","Liste notaires","Sources"],"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":"Menu principal","index":0,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8"]

{"sheet":"Tableau de suivi","index":1,"n_rows":5,"n_cols":23,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,16,0,17],[0,5,0,6],[0,3,0,4],[0,20,0,21]]}
[null,"N°","Nom/Désignation","Personne en charge",null,"Type d'acte",null,"Nom contact","Notaire ","Personne de contact","Email","Téléphone","Date échéance","Date passage de l'acte","Échéance (Jours)","Priorité","Date rappel client",null,"Publication de l'acte","Commentaires","Facturation",null,"Clôturé"]
[null,{"$f":"ROW((A1))","v":1},null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP('Tableau de suivi'!$I2,'Liste notaires'!$B$7:$K$41,3,FALSE)=0,\" \",VLOOKUP('Tableau de suivi'!$I2,'Liste notaires'!$B$7:$K$41,3,FALSE)),\" \")","v":" "},{"$f":"IFERROR(IF(VLOOKUP('Tableau de suivi'!$I2,'Liste notaires'!$B$7:$K$41,3,FALSE)=0,\" \",VLOOKUP('Tableau de suivi'!$I2,'Liste notaires'!$B$7:$K$41,4,FALSE)),\" \")","v":" "},{"$f":"IFERROR(IF(VLOOKUP('Tableau de suivi'!$I2,'Liste notaires'!$B$7:$K$41,3,FALSE)=0,\" \",VLOOKUP('Tableau de suivi'!$I2,'Liste notaires'!$B$7:$K$41,6,FALSE)),\" \")","v":" "},null,null,{"$f":"IF($N2= \"\", \"\", $N2-TODAY())","v":""},{"$f":"IF($O2 = \"\", \" \", IF($O2<5,\"Urgent\",IF(AND($O2<15,$O2>5),\"Normal\",\"Non-urgent\")))","v":" "},null,{"$f":"IF($Q2=\"\",\"\", IF((TODAY()-$Q2)>=14, \"Attention !\", IF((TODAY()-$Q2)>=7, \"A vérifier\", \" \")))","v":""},null,null,null,{"$f":"IF($U2=\"\", \"\", IF((($U2+30)<=TODAY()), \"Rappel\", \"\"))","v":""}]
[null,{"$f":"ROW((A2))","v":2}]
[null,3]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP('Tableau de suivi'!$I5,'Liste notaires'!$B$7:$K$41,3,FALSE)=0,\" \",VLOOKUP('Tableau de suivi'!$I5,'Liste notaires'!$B$7:$K$41,3,FALSE)),\" \")","v":" "},{"$f":"IFERROR(IF(VLOOKUP('Tableau de suivi'!$I5,'Liste notaires'!$B$7:$K$41,3,FALSE)=0,\" \",VLOOKUP('Tableau de suivi'!$I5,'Liste notaires'!$B$7:$K$41,4,FALSE)),\" \")","v":" "},{"$f":"IFERROR(IF(VLOOKUP('Tableau de suivi'!$I5,'Liste notaires'!$B$7:$K$41,3,FALSE)=0,\" \",VLOOKUP('Tableau de suivi'!$I5,'Liste notaires'!$B$7:$K$41,6,FALSE)),\" \")","v":" "},null,null,"",{"$f":"IF($O5 = \"\", \" \", IF($O5<5,\"Urgent\",IF(AND($O5<15,$O5>5),\"Normal\",\"Non-urgent\")))","v":" "},null,{"$f":"IF($Q5=\"\",\"\", IF((TODAY()-$Q5)>=14, \"Attention !\", IF((TODAY()-$Q5)>=7, \"A vérifier\", \" \")))","v":""},null,null,null,{"$f":"IF($U5=\"\", \"\", IF((($U5+30)<=TODAY()), \"Rappel\", \"\"))","v":""}]

{"sheet":"Suivi des documents","index":2,"n_rows":6,"n_cols":75,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,65,0,71],[0,74,0,82],[0,1,0,10],[0,13,0,21],[0,24,0,29],[0,32,0,42],[0,45,0,52],[0,55,0,62]]}
[null,"DEMANDE EN AUTORISATION ETABLISSEMENT",null,null,null,null,null,null,null,null,null,null,null,"CONSTITUTION",null,null,null,null,null,null,null,null,null,null,"Demande inscription TVA ",null,null,null,null,null,null,null,"Dissolution",null,null,null,null,null,null,null,null,null,null,null,null,"Fusion",null,null,null,null,null,null,null,null,null,"Scission",null,null,null,null,null,null,null,null,null,"Changements statutaires",null,null,null,null,null,null,null,null,"Autres : "]
["NOM","Formulaire de demande ","Déclaration sur l'honneur","Diplôme(s)","Certificat relevé carrière prof. ","Autres preuves de qualifications prof.","Extrait de casier judiciaire ","Attestation de non-faillite","(Projet de) Statuts","Contrat de bail ","Carte ID ",null,"NOM","Déclaration BE AFC ","Déclaration BE notaire ","Copie ID(s) ","Certificat blocage de fonds ","Contrat de bail ","Certificat d'évaluation ","Mandat acceptation gérance","Copie ID gérant","Procuration ",null,"NOM","Formulaire de demande ","Copie statuts ","Contrat de bail","ID gérant","Copie autorisation établissement ","Relevé d'identité bancaire ",null,"NOM","Déclaration BE notaire ","Copie ID ","Attestation AED","Attestation ACD ","Attestation CCSS","Copie des statuts ","Extrait RCSL","Comptes annuels","Situation arrêtée ","Registre des actionnaires ","Organigramme signé",null,"NOM","Déclaration BE notaire ","Copie ID ","Copie des statuts ","Extrait RCSL","Comptes annuels","Situation arrêtée ","Registre des actionnaires ","Organigramme signé",null,"NOM","Déclaration BE notaire ","Copie ID ","Copie des statuts ","Extrait RCSL","Comptes annuels","Situation arrêtée ","Registre des actionnaires ","Organigramme signé",null,"NOM","Extrait RCSL","ID ","Statuts ","Déclaration BE notaire ","Autorisation établissement (si nécessaire)","Registre actionnaires / Organigramme (si nécessaire)","Contrat de bail (si nécessaire)",null,"NOM"]
[]
[]
[]
[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,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," "]

{"sheet":"Dossiers clôturés","index":3,"n_rows":2,"n_cols":22,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,2,1,3],[1,4,1,5],[1,15,1,16],[1,19,1,20],[0,0,0,21]]}
["DOSSIERS CLÔTURES"]
["N°","Nom/Désignation","Personne en charge",null,"Type d'acte",null,"Nom contact","Notaire ","Personne de contact","Email","Téléphone","Date échéance","Date passage de l'acte","Échéance (Jours)","Priorité","Date rappel client",null,"Publication de l'acte","Commentaires","Facturation",null,"Clôturé"]

{"sheet":"Liste notaires","index":4,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[[3,8,3,11],[3,2,4,2],[3,1,4,1],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7]]}
[]
[null,"Liste notaire "]
[]
[null,"Notaire","Lieu","Personnes de contact","Adresse e-mail","Adresse postale","Téléphone","Fax","Emoluments"]
[null,null,null,null,null,null,null,null,"Constitution","Transfert de siège","Augmentation de capital","Diverses modifications statutaires"]
[null,"Chambres des notaires du GDL","Centre",null,"info@notariat.lu","53, boulevard Joseph II L-1840 Luxembourg","44 70 21","45 51 40"]
[null,"ARRENSDORFF Roger","Centre"," ","notarr@pt.lu","43, boulevard du Prince Henri L-1724 Luxembourg","26 27 30-1","26 27 30 30"]
[null,"BADEN Joëlle","Centre",null,"secretariat@enb.lu","17, rue des Bains L-1212 Luxembourg","22 79 27-1","22 78 22"]
[null,"BETTINGEN Paul","Centre",null,"bettingen@pbettingen.lu","71, rue du Golf L-1638 SENNINGERBERG","34 02 02-1","34 63 64"]
[null,"DECKER Martine","Centre",null,"notaire@martine-decker.lu","272, route de Thionville L-5884 HOWALD-HESPERANGE","40 70 30-1","40 70 59"]
[null,"DELOSCH Edouard","Centre",null,"secretariat@notaire-delosch.lu","7, rue Nicolas Bové L-1253 LUXEMBOURG-MERL","27 18 07","27 18 07 90"]
[null,"DELVAUX Cosita","Centre",null,"contact@notaire-delvaux.lu","39, Boulevard Joseph II L-1840 Luxembourg","45 41 49 - 1","45 41 49 - 454"]
[null,"GRETHEN Léonie","Centre",{"$f":"\"Rachida Martinot (rachida-martinot@notaire-grethen.lu)\"","v":"Rachida Martinot (rachida-martinot@notaire-grethen.lu)"},"leonie@notaire-grethen.lu","10, avenue Guillaume L-1650 Luxembourg","22 92 15-1","22 92 15-402"]
[null,"HELLINCKX Henri","Centre",null,"nothelli@pt.lu","101, rue Cents L-1319 Luxembourg","24 52 62-1","24 52 62-24"]
[null,"LECUIT Marc","Centre",null,"lecuitm@pt.lu","7, rue Wenzel L-7593 BERINGEN/MERSCH","32 02 02-1","32 72 71"]
[null,"MOLITOR  Frank","Centre",null,"info@notairemolitor.lu","101, rue de Bonnevoie L-1261 Luxembourg","49 36 36","48 85 15"]
[null,"REINARD Elisabeth","Centre","Lionel Gobert (L.Gobert@notaire-reinard.lu)","e.reinard@notaire-reinard.lu","2, Place de l’Hôtel de Ville L-9087 ETTELBRUCK","81 21 45","81 77 06"]
[null,"REUTER Karine","Centre",null,"notaire@notaire-reuter.lu","488, route de Longwy L-1940 Luxembourg","28 66 68 -1","28 66 68 68"]
[null,"SCHAEFFER Martine","Centre",null,"secretariat@notaireschaeffer.lu","74, avenue Victor Hugo L-1750 Luxembourg","22 44 75","46 02 61"]
[null,"SCHLESSER Emile","Centre",null,"info@notaireschlesser.lu","35, rue Notre Dame L-2240 Luxembourg","45 30 35-1","45 31 35"]
[null,"SCHWACHTGEN Joëlle","Centre",null,"notairejschwachtgen@pt.lu","4, rue Alexis Heck L-9242 DIEKIRCH","80 35 16 – 1","80 81 47"]
[null,"SECKLER Jean","Centre",null,"secklernot@sl.lu","3, route de Luxembourg L-6130 JUNGLINSTER","78 90 52-1","78 00 37"]
[null,"THOLL Urbain","Centre",null,"urbain.tholl@notairetholl.lu","7, rue Emile Laux L-7544 MERSCH","32 87 17-1","32 86 41"]
[null,"WERSANDT Carlo","Centre",null,"info@notaire-wersandt.lu","12, rue Jean Engling L-1466 Luxembourg","43 16 44-1","43 16 44 44"]
[null,"HAMES Mireille","Ouest",null,"contact@notairehames.lu","21, rue Schwiedelbrouch L-8806 RAMBROUCH","23 64 13 1","23 64 13 40"]
[null,"KOLBACH Danielle","Ouest",null,"info@notaire-kolbach.lu","66, Grand-Rue L-8510 REDANGE-SUR-ATTERT","26 88 86-1","26 88 86 88"]
[null,"MINES Camille ","Ouest",null,"secretariat@notaire-mines.lu","3, route d'Olm L-8331 CAPELLEN","30 00 27-1","30 71 45"]
[null,"DOERNER Christine","Sud",null,"notdoern@pt.lu","10, rue de la Gare L-3236 BETTEMBOURG","51 32 15-1","51 28 63"]
[null,"GOEDERT Carlo","Sud",null,"notaire@cgoedert.lu","61-63, avenue Grande-Duchesse Charlotte L-34541 DUDELANGE","51 64 62","51 19 51"]
[null,"HOLTZ Anja","Sud",null,"notholtz@pt.lu","12-14, rue Marie-Muller-Tesch L-4250 ESCH-SUR-ALZETTE","26 54 83-1","26 54 83-83"]
[null,"KESSELER Jacques","Sud",null,"notaire@kesseler.lu","13, route de Luxembourg L-4761 PETANGE","288 455 - 1","288 455 - 55"]
[null,"MEYERS Jean-Paul","Sud",null,"notaire@enm.lu","7, rue Xavier Brasseur L-4040 ESCH/ALZETTE","54-15-71-1","54 33 51"]
[null,"MOUTRIER Blanche","Sud",null,"blanche.moutrier@notaire-moutrier.lu","32A, rue Zénon Bernard L-4031 ESCH/ALZETTE","53 04 41","54 59 62"]
[null,"SCHUMAN Robert","Sud",null,"schumanr@pt.lu","54, rue JF Kennedy L-4599 DIFFERDANGE","58 98 98-1","58 94 94"]
[null,"WAGNER Jean-Joseph","Sud",null,"nowagner@pt.lu","37, rue des Alliés L-4412 BELVAUX","59 13 96-1","59 09 04"]
[null,"WEBER Alex","Sud",null,"notweber@pt.lu","101, avenue de Luxembourg L-4940 BASCHARAGE","50 72 99","50 11 94"]
[null,"BECK Henri","Est",null,"notaireh.beck@cmdnet.lu","9, Rabatt L-6475 ECHTERNACH","72 00 55 ","72 01 70"]
[null,"CASTEL Jacques","Est",null,"notaire@jcastel.lu","Résidence Prost, 33, route de Trèves L-6793 GREVENMACHER","75 83 53","75 06 04"]
[null,"LOESCH Marc","Est","Kathy KLINGELE (Khadigea.Klingele@notaireloesch.lu)","secretariat@notaireloesch.lu","Résidence du Midi, 13, avenue François Clement L-5612 MONDORF ","23 66 82 04","23 66 89 48"]
[null,"SERRES Patrick","Est",null,"secretariat@notaireserres.lu","16, route de Mondorf, L-5552 REMICH","23 61 95-1","23 69 89 62"]

{"sheet":"Sources","index":5,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"N°","Personne en charge2",null,"N°","Type d'actes",null,"Date du jour : ",{"$f":"TODAY()","v":"2018-01-19"},null,"Publication de l'acte",null,"Clôturé"]
[null,{"$f":"ROW(A1)","v":1},"DEVILLET N.",null,{"$f":"ROW(D1)","v":1},"Autorisation d'établissement",null,null,null,null,"OUI"]
[null,2,"DIFFERDANGE O.",null,2,"Changement(s) statutaire(s):",null,null,null,null,"NON"]
[null,3,"MERTZ Y.",null,3,"Clôture annuelle "]
[null,4,"XHONNEUX D.",null,4,"Constitution "]
[null,5,"BOURDIN C.",null,5,"Demande inscription TVA ",null,null,null,null,"Facturation "]
[null,6,"BRADFER F.",null,6,"Dissolution"]
[null,7,"HOUSSA M.",null,7,"Etablissement déclaration d'impôt"]
[null,8,"LAMBERTY C.",null,8,"Etablissement déclaration fiscale"]
[null,9,"LAVAL J.",null,9,"Etablissement déclaration TVA "]
[null,10,"LIMET S.",null,10,"Fusion"]
[null,11,"PONCELET J.",null,11,"Publication RCSL"]
[null,12,"RAKIB R.",null,12,"Scission "]
[null,13,"SERVAIS L.",null,13,"Secrétariat social"]
[null,14,"WALTENER S.",null,14,"Tenue AG annuel"]
[null,{"$f":"ROW(A15)","v":15},"Autre :",null,15,"Tenue de la comptabilité"]
[null,null,null,null,16,"Autre(s):"]