{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["Accueil","Bailleurs","Locataires","Biens","Baux","Quittances","Registre","QuittanceImp","Rev_Loyer_Imp","Paramétrages","ModeleFicheSuivi","ZTampon"],"not_rendered":{"images":26,"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Accueil","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Bailleurs","index":1,"n_rows":1,"n_cols":8173,"rows_kept":1}
["Code Bailleur","Civilité","Nom","Prénom","Adresse","CP","Ville","Fixe","Portable","Mail","Date d'inscription","Profession",null,null,"Signature",{"$nulls":8157},true]

{"sheet":"Locataires","index":2,"n_rows":2,"n_cols":8173,"rows_kept":2}
["Code Locataire","Civilité","Nom","Prénom","Fixe","Portable","Mail","Date d'inscription","Profession","N° Allocation",null,"APL /AL",{"$nulls":8160},false]
[{"$nulls":8172},true]

{"sheet":"Biens","index":3,"n_rows":1,"n_cols":9,"rows_kept":1}
["Code Bien","Type","Classe","Adresse","CP","Ville","Surface","Nb pièces","Description"]

{"sheet":"Baux","index":4,"n_rows":1,"n_cols":30,"rows_kept":1}
["Code Bail","Code Bien","Code Locataire","Adresse","CP","Ville","Nom Locataire","Prénom Locataire","Loyer Mensuel","Prov pour charges","Caution","Versement APL","Date d'entrée","Durée du Bail","Fin du Bail","Echéance de Paiement","Date du bail","APL /AL","Civilité Locataire","Code Bailleur","Civilité Bailleur","Nom Bailleur","Prénom Bailleur",{"$nulls":3},"IRL base précédent","Date début révision","Date fin  révision","Notes"]

{"sheet":"Quittances","index":5,"n_rows":1,"n_cols":34,"rows_kept":1}
["Numéro","Bail","Bien","Code Loc.","Civilité","Nom","Prénom","Mois","Année","Loyer vide","Charges","Date émission","Début mois","Fin mois","Date d'échéance","Notes","Date Tr.1","Libellé 1","Débit 1","Crédit 1","Date Tr.2","Libellé 2","Débit 2","Crédit 2","Date Tr.3","Libellé 3","Débit 3","Crédit 3","Date Tr.4","Libellé 4","Débit4","Crédit 4","détail quittance","Code Bailleur"]

{"sheet":"Registre","index":6,"n_rows":1,"n_cols":18,"rows_kept":1}
["Numéro","Code Bail","Date","Nom  Loc.","Prénom Loc.","Mois Loyer","Année","Crédit","Débit","Mode de paiement","Libellé","Type de charges","Montant charges","Paiement charges",{"$nulls":3},"Date de mouvement"]

{"sheet":"QuittanceImp","index":7,"n_rows":54,"n_cols":11,"rows_kept":54,"merged":[[2,2,2,4],[11,2,11,4],[16,2,16,4],[16,6,16,8],[17,2,17,4],[17,6,17,8],[19,6,19,7],[19,8,19,10],[20,6,20,7],[22,2,22,8],[22,9,22,10],[28,2,32,10],[34,2,34,8],[35,3,35,6],[42,2,45,10],[48,8,48,9],[53,2,54,10]]}
[]
[]
[null,null,"Bailleur"]
{"$rows_empty":8}
[null,null,"APPEL DE LOYER N°               "]
[null,null,"Date d'émission","Date d'échéance","Réf. Contrat"]
[]
[null,null,"Références à rappeler avec toute correspondance"]
[]
[null,null,"Lot (Réf.                   )",{"$nulls":3},"Période",null,null,"Début","Fin"]
[]
[]
[{"$nulls":6},"Code",null,"Locataire (s)"]
[]
[]
[null,null,"Référence",{"$nulls":6},"Montant"]
[]
[]
[]
[{"$nulls":8},"TOTAL",null,{"$f":"SUM(K24:K26)","v":{"v":0,"d":"0.00 €"}}]
{"$rows_empty":7}
[null,null,"DETAIL DES PAIEMENTS"]
[null,null,"Date","Mode de paiement / référence",{"$nulls":3},"Remb.","Montant"]
[]
[]
[]
[]
[{"$nulls":7},"TOTAL",{"$f":"SUM(I37:I40)-SUM(H37:H40)","v":{"v":0,"d":"0.00 €"}}]
{"$rows_empty":7}
[{"$nulls":8},"Le propriétaire"]
[]
[]
[]
[]
[null,null,"La présente quittance ne libère l'occupant que pour la période indiquée et annule tout reçu à valoir. Elle n'est pas libératoire des loyers antérieurs impayés et est délivrée sous réserve de toutes instances judiciaires en cours."]

{"sheet":"Rev_Loyer_Imp","index":8,"n_rows":49,"n_cols":11,"rows_kept":49,"merged":[[2,2,2,4],[11,2,11,4],[16,2,16,4],[16,6,16,8],[17,2,17,4],[17,6,17,8],[19,6,19,7],[19,8,19,10],[20,6,20,7],[22,2,22,8],[22,9,22,10],[28,2,47,10],[48,8,48,9],[53,2,54,10]]}
[]
[]
[null,null,"Bailleur"]
{"$rows_empty":8}
[null,null,"AVENANT AU CONTRAT BAIL N°          "]
[null,null,"Date d'émission","Début du bail","Fin du bail"]
[]
[null,null,"Références à rappeler avec toute correspondance"]
[]
[null,null,"Lot (Réf.                   )",{"$nulls":3},"Effectif à partir de",null,null,"Début","Fin"]
[]
[]
[{"$nulls":6},"Code",null,"Locataire (s)"]
[]
[]
[null,null,"Détail du loyer",{"$nulls":6},"Montant"]
[]
[]
[]
[{"$nulls":8},"TOTAL",null,{"$f":"SUM(K24:K26)","v":{"v":0,"d":"0.00 €"}}]
{"$rows_empty":21}
[{"$nulls":8},"Le propriétaire"]

{"sheet":"Paramétrages","index":9,"n_rows":15,"n_cols":25,"rows_kept":15,"merged":[[1,7,1,17],[4,7,4,9],[4,11,4,13],[4,15,4,17],[4,19,4,21],[4,23,4,25],[4,27,4,29],[5,7,5,9],[5,11,5,13],[5,15,5,17],[5,19,5,21],[5,23,5,25],[5,27,5,29],[6,7,6,9],[6,11,6,13],[6,15,6,17],[6,19,6,21],[6,23,6,25],[6,27,6,29],[7,7,7,9],[7,11,7,13],[7,15,7,17],[7,19,7,21],[7,23,7,25],[7,27,7,29],[8,7,8,9],[8,11,8,13],[8,15,8,17],[8,19,8,21],[8,23,8,25],[8,27,8,29],[9,7,9,9],[9,11,9,13],[9,15,9,17],[9,19,9,21],[9,23,9,25],[9,27,9,29],[10,7,10,9],[10,11,10,13],[10,15,10,17],[10,19,10,21],[10,23,10,25],[10,27,10,29],[11,7,11,9],[11,11,11,13],[11,15,11,17],[11,19,11,21],[11,23,11,25],[11,27,11,29],[12,7,12,9],[12,11,12,13],[12,15,12,17],[12,19,12,21],[12,23,12,25],[12,27,12,29],[13,7,13,9],[13,11,13,13],[13,15,13,17],[13,19,13,21],[13,23,13,25],[13,27,13,29],[14,11,14,13],[14,15,14,17],[14,19,14,21],[14,23,14,25],[14,27,14,29],[15,11,15,13],[15,15,15,17],[15,19,15,21],[15,23,15,25],[15,27,15,29],[16,11,16,13],[16,15,16,17],[16,19,16,21],[16,23,16,25],[16,27,16,29],[17,11,17,13],[17,15,17,17],[17,19,17,21],[17,23,17,25],[17,27,17,29],[18,11,18,13],[18,15,18,17],[18,19,18,21],[18,23,18,25],[18,27,18,29],[19,11,19,13],[19,15,19,17],[19,19,19,21],[19,23,19,25],[19,27,19,29],[20,11,20,13],[20,15,20,17],[20,19,20,21],[20,23,20,25],[20,27,20,29],[21,11,21,13],[21,15,21,17],[21,19,21,21],[21,23,21,25],[21,27,21,29],[22,11,22,13],[22,15,22,17],[22,19,22,21],[22,23,22,25],[22,27,22,29],[23,11,23,13],[23,15,23,17],[23,19,23,21],[23,23,23,25],[23,27,23,29]]}
[]
[{"$nulls":7},"Paramétrages"]
[{"$nulls":8},"H",{"$nulls":3},"L",{"$nulls":3},"P",{"$nulls":3},"T",{"$nulls":3},"X"]
[{"$nulls":8},"H",{"$nulls":3},"L",{"$nulls":3},"P",{"$nulls":3},"T",{"$nulls":3},"X"]
[null,null,"Compteurs",null,null,"Codage",null,"Modes de Paiement",{"$nulls":3},"Charges",{"$nulls":3},"Civilités",{"$nulls":3},"Types de biens",{"$nulls":3},"Classe"]
[null,"Locataires",0,null,"Locataires","LOC"]
[null,"Biens",0,null,"Biens","BI",null,"Virement",{"$nulls":3},"Taxes Ordures Ménagères",{"$nulls":3},"M.",{"$nulls":3},"Maison",{"$nulls":3},"T1"]
[null,"Baux",0,null,"Baux","BA",null,"Virement / CAF",{"$nulls":3},"Gestion Compte",{"$nulls":3},"Mme",{"$nulls":3},"Appartement",{"$nulls":3},"T2"]
[null,"Registre",0,null,"Registre","Enr",null,"Chèque",{"$nulls":7},"Mlle",{"$nulls":3},"Garage",{"$nulls":3},"T3"]
[null,"Quittances",0,null,"Quittances","CA",{"$nulls":9},"M. et Mme",{"$nulls":3},"Box",{"$nulls":3},"T4"]
[null,"Bailleurs",0,null,"Bailleurs","PRO",{"$nulls":17},"T5"]
[{"$nulls":23},"F1"]
[{"$nulls":23},"F2"]
[{"$nulls":23},"F3"]
[{"$nulls":23},"F4"]

{"sheet":"ModeleFicheSuivi","index":10,"n_rows":41,"n_cols":29,"rows_kept":41,"hidden":true,"merged":[[1,0,1,1],[1,17,1,18],[1,20,1,22],[2,0,2,1],[2,3,2,4],[2,16,3,16],[2,17,3,18],[5,5,5,6],[5,7,5,11],[5,24,5,26],[21,20,21,22],[22,20,24,22],[25,20,25,22],[25,24,25,26],[26,24,26,26],[27,24,27,26],[28,24,28,26],[29,24,29,26],[30,20,30,27],[31,24,31,26],[32,24,32,26],[33,24,33,26],[34,24,34,26]]}
[]
["Contrat",null,null,"Propriétaire(s)",null,null,"Code Pro:","Locataire(s)",{"$nulls":3},"Code Loc / Bien","Loyer","A.Charges","Total Loyer","Échéance",null,"Année",null,null,"Gestion"]
[{"$nulls":14},{"$f":"M3+N3","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"A4","v":"00:00:00"},null,null,"Nb Mois Loués",null,"Contrat"]
[{"$nulls":14},{"$f":"IF(ISBLANK(M4),\"\",(M4+N4))","v":""},{"$nulls":5},{"$f":"COUNTA(S7:S18)","v":0},null,{"$f":"A3","v":0}]
[]
["Registre",null,null,"Loyer de","Date","Mode de paiement",null,"Libellé",{"$nulls":4},"Crédit","Débit",{"$nulls":6},"Total/mois","Diff./mois","P.charges",null,"F.charges",null,null,"Échéances"]
[{"$nulls":20},{"$f":"IF(ISBLANK(S7),\"\",(SUMIF(D7:D41,S7,M7:M41))-(SUMIF(D7:D41,S7,N7:N41)))","v":""},{"$f":"IF(AB7>TODAY(),\"\",IF(ISBLANK(S7),\"\",(SUMIF(D7:D40,S7,M7:M40))-(SUMIF(D7:D40,S7,N7:N40))-O3))","v":""},{"$f":"IF(ISBLANK(S7),\"\",IF(U7>=O3,N3,0)+IF(Z7=1,N3,0))","v":""},null,null,0,null,{"$f":"IF(ISBLANK(S7),\"\",DATE(YEAR(A4),INDEX({1;2;3;4;5;6;7;8;9;10;11;12},MATCH(S7,{\"janvier\";\"février\";\"mars\";\"avril\";\"mai\";\"juin\";\"juillet\";\"août\";\"septembre\";\"octobre\";\"novembre\";\"décembre\"},0)),MID(P3,1,2)))","v":""}]
[{"$nulls":20},{"$f":"IF(ISBLANK(S8),\"\",(SUMIF(D7:D41,S8,M7:M41))-(SUMIF(D7:D41,S8,N7:N41)))","v":""},{"$f":"IF(AB8>TODAY(),\"\",IF(ISBLANK(S8),\"\",(SUMIF(D7:D40,S8,M7:M40))-(SUMIF(D7:D40,S8,N7:N40))-O3))","v":""},{"$f":"IF(ISBLANK(S8),\"\",IF(U8>=O3,N3,0)+IF(Z8=1,N3,0))","v":""},null,null,0,null,{"$f":"IF(ISBLANK(S8),\"\",DATE(YEAR(A4),INDEX({1;2;3;4;5;6;7;8;9;10;11;12},MATCH(S8,{\"janvier\";\"février\";\"mars\";\"avril\";\"mai\";\"juin\";\"juillet\";\"août\";\"septembre\";\"octobre\";\"novembre\";\"décembre\"},0)),MID(P3,1,2)))","v":""}]
[{"$nulls":20},{"$f":"IF(ISBLANK(S9),\"\",(SUMIF(D7:D41,S9,M7:M41))-(SUMIF(D7:D41,S9,N7:N41)))","v":""},{"$f":"IF(AB9>TODAY(),\"\",IF(ISBLANK(S9),\"\",(SUMIF(D7:D40,S9,M7:M40))-(SUMIF(D7:D40,S9,N7:N40))-O3))","v":""},{"$f":"IF(ISBLANK(S9),\"\",IF(U9>=O3,N3,0)+IF(Z9=1,N3,0))","v":""},null,null,0,null,{"$f":"IF(ISBLANK(S9),\"\",DATE(YEAR(A4),INDEX({1;2;3;4;5;6;7;8;9;10;11;12},MATCH(S9,{\"janvier\";\"février\";\"mars\";\"avril\";\"mai\";\"juin\";\"juillet\";\"août\";\"septembre\";\"octobre\";\"novembre\";\"décembre\"},0)),MID(P3,1,2)))","v":""}]
[{"$nulls":20},{"$f":"IF(ISBLANK(S10),\"\",(SUMIF(D7:D41,S10,M7:M41))-(SUMIF(D7:D41,S10,N7:N41)))","v":""},{"$f":"IF(AB10>TODAY(),\"\",IF(ISBLANK(S10),\"\",(SUMIF(D7:D40,S10,M7:M40))-(SUMIF(D7:D40,S10,N7:N40))-O3))","v":""},{"$f":"IF(ISBLANK(S10),\"\",IF(U10>=O3,N3,0)+IF(Z10=1,N3,0))","v":""},null,null,0,null,{"$f":"IF(ISBLANK(S10),\"\",DATE(YEAR(A4),INDEX({1;2;3;4;5;6;7;8;9;10;11;12},MATCH(S10,{\"janvier\";\"février\";\"mars\";\"avril\";\"mai\";\"juin\";\"juillet\";\"août\";\"septembre\";\"octobre\";\"novembre\";\"décembre\"},0)),MID(P3,1,2)))","v":""}]
[{"$nulls":20},{"$f":"IF(ISBLANK(S11),\"\",(SUMIF(D7:D41,S11,M7:M41))-(SUMIF(D7:D41,S11,N7:N41)))","v":""},{"$f":"IF(AB11>TODAY(),\"\",IF(ISBLANK(S11),\"\",(SUMIF(D7:D40,S11,M7:M40))-(SUMIF(D7:D40,S11,N7:N40))-O3))","v":""},{"$f":"IF(ISBLANK(S11),\"\",IF(U11>=O3,N3,0)+IF(Z11=1,N3,0))","v":""},null,null,0,null,{"$f":"IF(ISBLANK(S11),\"\",DATE(YEAR(A4),INDEX({1;2;3;4;5;6;7;8;9;10;11;12},MATCH(S11,{\"janvier\";\"février\";\"mars\";\"avril\";\"mai\";\"juin\";\"juillet\";\"août\";\"septembre\";\"octobre\";\"novembre\";\"décembre\"},0)),MID(P3,1,2)))","v":""}]
[{"$nulls":20},{"$f":"IF(ISBLANK(S12),\"\",(SUMIF(D7:D41,S12,M7:M41))-(SUMIF(D7:D41,S12,N7:N41)))","v":""},{"$f":"IF(AB12>TODAY(),\"\",IF(ISBLANK(S12),\"\",(SUMIF(D7:D40,S12,M7:M40))-(SUMIF(D7:D40,S12,N7:N40))-O3))","v":""},{"$f":"IF(ISBLANK(S12),\"\",IF(U12>=O3,N3,0)+IF(Z12=1,N3,0))","v":""},null,null,0,null,{"$f":"IF(ISBLANK(S12),\"\",DATE(YEAR(A4),INDEX({1;2;3;4;5;6;7;8;9;10;11;12},MATCH(S12,{\"janvier\";\"février\";\"mars\";\"avril\";\"mai\";\"juin\";\"juillet\";\"août\";\"septembre\";\"octobre\";\"novembre\";\"décembre\"},0)),MID(P3,1,2)))","v":""}]
[{"$nulls":20},{"$f":"IF(ISBLANK(S13),\"\",(SUMIF(D7:D41,S13,M7:M41))-(SUMIF(D7:D41,S13,N7:N41)))","v":""},{"$f":"IF(AB13>TODAY(),\"\",IF(ISBLANK(S13),\"\",(SUMIF(D7:D40,S13,M7:M40))-(SUMIF(D7:D40,S13,N7:N40))-O3))","v":""},{"$f":"IF(ISBLANK(S13),\"\",IF(U13>=O3,N3,0)+IF(Z13=1,N3,0))","v":""},null,null,0,null,{"$f":"IF(ISBLANK(S13),\"\",DATE(YEAR(A4),INDEX({1;2;3;4;5;6;7;8;9;10;11;12},MATCH(S13,{\"janvier\";\"février\";\"mars\";\"avril\";\"mai\";\"juin\";\"juillet\";\"août\";\"septembre\";\"octobre\";\"novembre\";\"décembre\"},0)),MID(P3,1,2)))","v":""}]
[{"$nulls":20},{"$f":"IF(ISBLANK(S14),\"\",(SUMIF(D7:D41,S14,M7:M41))-(SUMIF(D7:D41,S14,N7:N41)))","v":""},{"$f":"IF(AB15>TODAY(),\"\",IF(ISBLANK(S14),\"\",(SUMIF(D7:D40,S14,M7:M40))-(SUMIF(D7:D40,S14,N7:N40))-O3))","v":""},{"$f":"IF(ISBLANK(S14),\"\",IF(U14>=O3,N3,0)+IF(Z14=1,N3,0))","v":""},null,null,0,null,{"$f":"IF(ISBLANK(S14),\"\",DATE(YEAR(A4),INDEX({1;2;3;4;5;6;7;8;9;10;11;12},MATCH(S14,{\"janvier\";\"février\";\"mars\";\"avril\";\"mai\";\"juin\";\"juillet\";\"août\";\"septembre\";\"octobre\";\"novembre\";\"décembre\"},0)),MID(P3,1,2)))","v":""}]
[{"$nulls":20},{"$f":"IF(ISBLANK(S15),\"\",(SUMIF(D7:D41,S15,M7:M41))-(SUMIF(D7:D41,S15,N7:N41)))","v":""},{"$f":"IF(AB15>TODAY(),\"\",IF(ISBLANK(S15),\"\",(SUMIF(D7:D40,S15,M7:M40))-(SUMIF(D7:D40,S15,N7:N40))-O3))","v":""},{"$f":"IF(ISBLANK(S15),\"\",IF(U15>=O3,N3,0)+IF(Z15=1,N3,0))","v":""},null,null,0,null,{"$f":"IF(ISBLANK(S15),\"\",DATE(YEAR(A4),INDEX({1;2;3;4;5;6;7;8;9;10;11;12},MATCH(S15,{\"janvier\";\"février\";\"mars\";\"avril\";\"mai\";\"juin\";\"juillet\";\"août\";\"septembre\";\"octobre\";\"novembre\";\"décembre\"},0)),MID(P3,1,2)))","v":""}]
[{"$nulls":20},{"$f":"IF(ISBLANK(S16),\"\",(SUMIF(D7:D41,S16,M7:M41))-(SUMIF(D7:D41,S16,N7:N41)))","v":""},{"$f":"IF(AB16>TODAY(),\"\",IF(ISBLANK(S16),\"\",(SUMIF(D7:D40,S16,M7:M40))-(SUMIF(D7:D40,S16,N7:N40))-O3))","v":""},{"$f":"IF(ISBLANK(S16),\"\",IF(U16>=O3,N3,0)+IF(Z16=1,N3,0))","v":""},null,null,0,null,{"$f":"IF(ISBLANK(S16),\"\",DATE(YEAR(A4),INDEX({1;2;3;4;5;6;7;8;9;10;11;12},MATCH(S16,{\"janvier\";\"février\";\"mars\";\"avril\";\"mai\";\"juin\";\"juillet\";\"août\";\"septembre\";\"octobre\";\"novembre\";\"décembre\"},0)),MID(P3,1,2)))","v":""}]
[{"$nulls":20},{"$f":"IF(ISBLANK(S17),\"\",(SUMIF(D7:D41,S17,M7:M41))-(SUMIF(D7:D41,S17,N7:N41)))","v":""},{"$f":"IF(AB17>TODAY(),\"\",IF(ISBLANK(S17),\"\",(SUMIF(D7:D40,S17,M7:M40))-(SUMIF(D7:D40,S17,N7:N40))-O3))","v":""},{"$f":"IF(ISBLANK(S17),\"\",IF(U17>=O3,N3,0)+IF(Z17=1,N3,0))","v":""},null,null,0,null,{"$f":"IF(ISBLANK(S17),\"\",DATE(YEAR(A4),INDEX({1;2;3;4;5;6;7;8;9;10;11;12},MATCH(S17,{\"janvier\";\"février\";\"mars\";\"avril\";\"mai\";\"juin\";\"juillet\";\"août\";\"septembre\";\"octobre\";\"novembre\";\"décembre\"},0)),MID(P3,1,2)))","v":""}]
[{"$nulls":20},{"$f":"IF(ISBLANK(S18),\"\",(SUMIF(D7:D41,S18,M7:M41))-(SUMIF(D7:D41,S18,N7:N41)))","v":""},{"$f":"IF(AB18>TODAY(),\"\",IF(ISBLANK(S18),\"\",(SUMIF(D7:D40,S18,M7:M40))-(SUMIF(D7:D40,S18,N7:N40))-O3))","v":""},{"$f":"IF(ISBLANK(S18),\"\",IF(U18>=O3,N3,0)+IF(Z18=1,N3,0))","v":""},null,null,0,null,{"$f":"IF(ISBLANK(S18),\"\",DATE(YEAR(A4),INDEX({1;2;3;4;5;6;7;8;9;10;11;12},MATCH(S18,{\"janvier\";\"février\";\"mars\";\"avril\";\"mai\";\"juin\";\"juillet\";\"août\";\"septembre\";\"octobre\";\"novembre\";\"décembre\"},0)),MID(P3,1,2)))","v":""}]
[]
[{"$nulls":18},"Total Brut",null,{"$f":"SUM(U7:U18)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(V7:V18)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(W7:W18)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":18},"Loyers attendus",null,{"$f":"M3*(12-COUNTBLANK(V7:V18))","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":20},{"$f":"IF(U23>0,\"Le propriétaire doit\",\"Le locataire est redevable de\")","v":"Le locataire est redevable de"}]
[{"$nulls":20},{"$f":"U20-U21-W20","v":{"v":0,"d":"0.00 €"}}]
[]
[]
[{"$nulls":20},{"$f":"\"Charges \"&(TEXT(R3,\"aaaa\"))","v":"Charges 1900"},{"$nulls":3},"Crédit",null,null,"Débits","Registre"]
[]
[]
[]
[]
[{"$nulls":20},{"$f":"\"Calcul charges (Nov. \"&(TEXT((R3),\"aaaa\")-1)&\" à Oct.\"&TEXT((R3),\"aaaa\")& \")\"","v":"Calcul charges (Nov. 1899 à Oct.1900)"}]
[{"$nulls":20},"Charges",{"$nulls":3},"Nb / Mois",null,null,"Proratisation"]
[{"$nulls":18},{"$f":"(TEXT(R3,\"aaaa\"))-1","v":1899},null,{"$f":"INDIRECT(CONCATENATE(MID(CELL(\"nomfichier\",A100),FIND(\"]\",CELL(\"nomfichier\",A100),1)+1,9) & (TEXT(R3,\"aaaa\"))-1,\"!U34\"))","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"COUNTA(INDIRECT(CONCATENATE(MID(CELL(\"nomfichier\",A100),FIND(\"]\",CELL(\"nomfichier\",A100),1)+1,9)&(TEXT(R3,\"aaaa\"))-1,\"!S17:S18\")))","v":1},null,null,{"$f":"U33/12*Y33","v":{"$error":"#VALUE!"}}]
[{"$nulls":18},{"$f":"(TEXT(R3,\"aaaa\"))","v":"1900"},null,{"$f":"SUM(AB27:AB30)","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},{"$f":"COUNTA(S7:S16)","v":0},null,null,{"$f":"U34/12*Y34","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":18},"Total",{"$nulls":8},{"$f":"SUM(AB33:AB34)","v":{"$error":"#VALUE!"}}]
[]
[{"$nulls":20},{"$f":"\"Solde \"&((TEXT(R3,\"aaaa\"))-1)","v":"Solde 1899"},{"$f":"\"Crédit \"&(TEXT(R3,\"aaaa\"))","v":"Crédit 1900"},"Total"]
[{"$nulls":20},{"$f":"INDIRECT(CONCATENATE(MID(CELL(\"nomfichier\",A100),FIND(\"]\",CELL(\"nomfichier\",A100),1)+1,9) & (TEXT(R3,\"aaaa\"))-1,\"!W41\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM(W7:W16)+ SUM(Y27:AA30)","v":{"v":0,"d":"0.00 €"}},{"$f":"V38+U38","v":{"$error":"#VALUE!"}}]
[{"$nulls":18},{"$f":"\"Solde Oct. \"&(TEXT(R3,\"aaaa\"))","v":"Solde Oct. 1900"},{"$nulls":3},{"$f":"W38-AB35","v":{"$error":"#VALUE!"}}]
[]
[{"$nulls":18},{"$f":"\"Solde \"&(TEXT(R3,\"aaaa\"))","v":"Solde 1900"},{"$nulls":3},{"$f":"W39+SUM(W17:W18)","v":{"$error":"#VALUE!"}}]

{"sheet":"ZTampon","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true,"merged":[[50,8,52,9]]}