{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["PLANS","Annexe1","Annexe2","Annexe3","Annexe4","Annexe5","Copros"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":7,"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":"PLANS","index":0,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Syndicat- des Copropriétaires"]
["Rue"]
["C.P. Ville"]
[null,null,null,null,"Jour","mois","Année N","Jour","mois","Année N+1","Jour","mois","Année N+2"]
[null,null,null,"Date début exercice","1er","janvier",2020,"1er","janvier",2021,"1er","janvier",2022]
[null,null,null,"Date fin exercice",31,"decembre",2020,31,"décembre",2021,31,"décembre",2022]
[]
[null,null,null,{"$f":"IF($G$5<>$G$6,CONCATENATE($G$5-1,\"/\",$G$6-1),$G$6-1)","v":2019},null,"Exercice :",{"$f":"IF($G$5<>$G$6,CONCATENATE($G$5,\"/\",$G$6),$G$6)","v":2020},null,null,{"$f":"IF(J5<>J6,CONCATENATE(J5,\"/\",J6),J6)","v":2021},null,null,{"$f":"IF(M5<>M6,CONCATENATE(M5,\"/\",M6),M6)","v":2022}]
[]
[null,null,null,null,null,null,"Fin Exercice",{"$f":"CONCATENATE(E6,\" \",F6,\" \",G6)","v":"31 decembre 2020"}]
[]
[null,null,null,null,null,null,"Exercice N",{"$f":"CONCATENATE($E$5,\" \",$F$5,\" \",$G$5,\" au \",$E$6,\" \",$F$6,\" \",$G$6)","v":"1er janvier 2020 au 31 decembre 2020"}]
[null,null,null,null,null,null,"Exercice N + 2",{"$f":"CONCATENATE($K$5,\" \",$L$5,\" \",$M$5,\" au \",$K$6,\" \",$L$6,\" \",$M$6)","v":"1er janvier 2022 au 31 décembre 2022"}]
[]
[null,null,null,null,null,"Dernier N°CLES CH.Générales",9,{"$f":"CONCATENATE(\"<=\",G15)","v":"<=9"}]
[null,null,null,null,null,"Premier N°CLES CH.Travaux",11,{"$f":"CONCATENATE(\">=\",G16)","v":">=11"}]

{"sheet":"Annexe1","index":1,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[{"$f":"PLANS!A1","v":"Syndicat- des Copropriétaires"},null,null,null,null,null,null,"Annexe 1"]
[{"$f":"PLANS!A2","v":"Rue"}]
[{"$f":"PLANS!A3","v":"C.P. Ville"},null,null,null,"ETAT FINANCIER apres répartition au ",{"$f":"CONCATENATE(PLANS!E6,\" \",PLANS!F6,\" \",\" \",PLANS!G6)","v":"31 decembre  2020"}]
[]
["I - SITUATION FINANCIERE ET TRESORERIE"]
[null,null,"Exercice Précédent approuvé","Exercice Clos",null,null,"Exercice Précédent approuvé","Exercice Clos"]
[null,"Trésorerie",null,null,"Provisions et Avances"]
[null,null,null,null,102,"Provisions pour travaux"]
[50,"Fonds Placés",null,null,103,"Avances"]
[null,null,null,null,1031,"Avances de trésorerie",2000,2000]
[51,"Banque",4000,5500,1032,"Avances travaux"]
[null,null,null,null,1033,"Autres avances"]
[null,null,null,null,131,"Subvention attente affectation"]
[]
[]
[null,null,null,null,12,"Solde en attente sur travaux ou opérations exceptionnelles",null,500]
[null,"Trésorerie disponible Total 1",{"$f":"SUM(C7:C16)","v":4000},{"$f":"SUM(D7:D16)","v":5500},null,"Total 1",{"$f":"SUM(G7:G16)","v":2000},{"$f":"SUM(H7:H16)","v":2500}]
["II - CREANCES",null,null,null,"DETTES"]
[null,null,"Exercice Précédent approuvé","Exercice Clos",null,null,"Exercice Précédent approuvé","Exercice Clos"]
[45,"Copropriétaires-Sommes Exigiblesrestant à recevoir",1000,1500,45,"Copropriétaires",1500,1000]
[null,null,null,null,null,"Compte de Tiers"]
[459,"Copropriétaires-Créances douteuses",null,null,40,"Fournisseurs",1500,2500]
[null,"Comptes de tiers",null,null,"42à44","Autres dettes"]
[40,"Fournisseurs",null,null,46,"Créditeurs divers",null,400]
["42-44","Autres créances",null,null,47,"Compte d'attente",null,600]
[46,"Débiteurs divers"]
[47,"Compte d'attente",null,null,49,"Dépréciation ctes de tiers"]
[48,"Cte de régularisation",null,null,48,"Compte de régularisation"]
[null,"Total 2",{"$f":"SUM(C20:C28)","v":1000},{"$f":"SUM(D20:D28)","v":1500},null,"Total 2",{"$f":"SUM(G20:G28)","v":3000},{"$f":"SUM(H20:H28)","v":4500}]
[null,"Total général (1)+(2)",{"$f":"C17+C29","v":5000},{"$f":"D17+D29","v":7000},null,"Total général (1)+(2)",{"$f":"G17+G29","v":5000},{"$f":"H17+H29","v":7000}]
[null,null,{"$f":"IF($C$30<>$G$30,\"ERREUR\",\"\")","v":""},{"$f":"IF($D$30<>$H$30,\"ERREUR\",\"\")","v":""},null,null,{"$f":"IF($C$30<>$G$30,\"ERREUR\",\"\")","v":""},{"$f":"IF($D$30<>$H$30,\"ERREUR\",\"\")","v":""}]
[null,null,null,null,null,"Emprunts:Montant restant dû",0,0]
["Le syndic:"]

{"sheet":"Annexe2","index":2,"n_rows":63,"n_cols":12,"rows_kept":63,"cut":false,"hidden":false,"merged":[[6,6,6,11],[7,7,7,9],[46,6,46,9],[46,0,46,3],[6,0,6,5],[7,1,7,3],[7,4,7,5]]}
[{"$f":"PLANS!$A$1","v":"Syndicat- des Copropriétaires"},null,null,null,null,"Annexe N°2 A",{"$f":"PLANS!$A$1","v":"Syndicat- des Copropriétaires"},null,null,null,null,"Annexe N°2 B"]
[{"$f":"PLANS!$A$2","v":"Rue"},null,null,null,null,null,{"$f":"PLANS!$A$2","v":"Rue"}]
[{"$f":"PLANS!$A$3","v":"C.P. Ville"},null,null,null,null,null,{"$f":"PLANS!$A$3","v":"C.P. Ville"}]
[null,null,null,"Compte de gestion générale de l'exercice clos réalisé (N) du ",{"$f":"PLANS!$H$12","v":"1er janvier 2020 au 31 decembre 2020"},null,null,null,"Compte de gestion générale de l'exercice clos réalisé (N) du ",{"$f":"PLANS!$H$12","v":"1er janvier 2020 au 31 decembre 2020"}]
[null,null,null,"            budget prévisionnel de l'exercice  (N+2) du ",{"$f":"PLANS!$H$13","v":"1er janvier 2022 au 31 décembre 2022"},null,null,null,"            budget prévisionnel de l'exercice  (N+2) du ",{"$f":"PLANS!$H$13","v":"1er janvier 2022 au 31 décembre 2022"}]
[]
["CHARGES POUR OPERATIONS COURANTES",null,null,null,null,null,"PRODUITS POUR OPERATIONS COURANTES"]
[null,"Pour approbation des comptes",null,null,"Pour le vote du budget prévisionnel",null,null,"Pour approbation des comptes"]
[null,"Exercice Précédent","Exercice clos","Exercice clos réalisé","Budget prévisionnel","Budget Prévisionnel",null,"Exercice Précédent","Exercice clos","Exercice clos réalisé","Budget prévisionnel","Budget Prévisionnel"]
[null,"approuvé","budget voté","à approuver","en cours voté","à voter",null,"approuvé","budget voté","à approuver","en cours voté","à voter"]
[null,"N-1","N","N","N+1","N+2",null,"N-1","N","N","N+1","N+2"]
[null,{"$f":"PLANS!D8","v":2019},{"$f":"PLANS!G8","v":2020},{"$f":"PLANS!G8","v":2020},{"$f":"PLANS!J8","v":2021},{"$f":"PLANS!M8","v":2022},null,{"$f":"PLANS!$D$8","v":2019},{"$f":"PLANS!$G$8","v":2020},{"$f":"PLANS!$G$8","v":2020},{"$f":"PLANS!$J$8","v":2021},{"$f":"PLANS!$M$8","v":2022}]
["60-Achats matières et fournit.",null,null,null,null,null,"  701,1 Provisions copropriétaires",10513,12104,12114,12145,12696]
["  601 Eau",1200,1250,1200,1300,1350,"  711 Subventions s/Frais fonct.",500,500,500]
["  602 Electricité",2213,2154,1914,2015,2056,"  713 Indemnités d'assurances   ",200]
["  603 Combustible",2300,2400,2200,2050,2100,"  714 produites divers",100,100,150,200,200]
["  604 Autres Prod.entr.Pet.Equip.",450,300,200,200,250,"  716 Produits financiers",300,200,250,300,300]
["  605 Matériel"]
["  606 Fournitures"]
["61-Services extérieurs"]
["  611 Nettoyage des locaux",1250,1300,1400,1450,1500]
["  614,1  Maintenance Chaudière",600,620,650,700,750]
["614,2 Maintenance extincteur",320,340,360,380,400]
["  614,4 Contrat Répartiteurs",1300,1200,1200,1250,1300]
["  615 Entretien et Petites Réparat.",380,450,250,200,230]
["  616 Assurances",300,360,400,410,420]
[" 621 Honoraires syndic",1900,2000,2100,2200,2300]
["  621,2 Débours",50,80,60,70,80]
["  621,3 Frais postaux",130,140,100,110,120]
["  621,4 Fournitures",270,250,200,220,240]
["62-Frais d'administration"]
["  623 Rémunérations de tiers"]
["66-Charges financières"]
["662 Charges financières",50,60,80,90,100]
[]
[]
[]
[]
[]
[]
[]
[]
["Sous-total",{"$f":"SUM(B13:B42)","v":12713},{"$f":"SUM(C13:C42)","v":12904},{"$f":"SUM(D13:D42)","v":12314},{"$f":"SUM(E13:E42)","v":12645},{"$f":"SUM(F13:F42)","v":13196},"Sous-total",{"$f":"SUM(H13:H42)","v":11613},{"$f":"SUM(I13:I42)","v":12904},{"$f":"SUM(J13:J42)","v":13014},{"$f":"SUM(K13:K42)","v":12645},{"$f":"SUM(L13:L42)","v":13196}]
["Solde(Excédent s/opérations courantes affectés aux copropriétaires)",null,null,700,null,null,"Solde(Insuffisances s/opérations ctes affectés aux copropriétaires)",1100]
[null,{"$f":"SUM(B43+B44)","v":12713},{"$f":"SUM(C43+C44)","v":12904},{"$f":"SUM(D43+D44)","v":13014},{"$f":"E43","v":12645},{"$f":"F43","v":13196},"Total I",{"$f":"H43+H44","v":12713},{"$f":"I43","v":12904},{"$f":"J43+J44","v":13014},{"$f":"K43","v":12645},{"$f":"L43","v":13196}]
[null,{"$f":"IF($B$45=$H$45,\"\",\"ERREUR\")","v":""},{"$f":"IF($C$45=$I$45,\"\",\"ERREUR\")","v":""},{"$f":"IF($D$45=$J$45,\"\",\"ERREUR\")","v":""},{"$f":"IF($E$45=$K$45,\"\",\"ERREUR\")","v":""},{"$f":"IF($F$45=$L$45,\"\",\"ERREUR\")","v":""},null,{"$f":"IF($B$45=$H$45,\"\",\"ERREUR\")","v":""},{"$f":"IF($C$45=$I$45,\"\",\"ERREUR\")","v":""},{"$f":"IF($D$45=$J$45,\"\",\"ERREUR\")","v":""},{"$f":"IF($E$45=$K$45,\"\",\"ERREUR\")","v":""},{"$f":"IF($F$45=$L$45,\"\",\"ERREUR\")","v":""}]
["CHARGES POUR TRAVAUX ET AUTRES OPERATIONS EXCEPTIONNELLES",null,null,null,null,null,"PRODUITS POUR TRAVAUX ET AUTRES OPERATIONS EXCEPTIONNELLES"]
[null,null,null,null,null,null,"  702,1 Provisions pour travaux",3000,3200,3400]
["671 Travaux ",4500,4500,4800,null,null,"  703 Avances versées par copro.",1100,1000,1000]
[null,null,null,null,null,null,"  704 Remb.d'.annuités emprunts"]
[null,null,null,null,null,null,"Autres produits"]
[null,null,null,null,null,null,"  711 Subventions sur travaux"]
[null,null,null,null,null,null,"  712 Emprunts à util. s/Travaux"]
[null,null,null,null,null,null,"  712 Indemnités d'assurances",400,300,100]
[null,null,null,null,null,null,"  714 Produits divers"]
["  678 Charges exceptionnelles",null,null,null,null,null,"  716 Produits financiers"]
["68 Dotations dépréc.créances",null,null,null,null,null,"  718 produits exceptionnels"]
["  68 Dot.dépréc.créances",null,null,null,null,null,"78 Reprise. s/créances dout"]
["Solde (Excédent)",null,null,null,null,null,"Solde (Insuffisance)","",null,300]
[null,{"$f":"SUM(B48:B59)","v":4500},{"$f":"SUM(C48:C59)","v":4500},{"$f":"SUM(D48:D59)","v":4800},null,null,"Total II",{"$f":"SUM(H48:H59)","v":4500},{"$f":"SUM(I48:I59)","v":4500},{"$f":"SUM(J48:J59)","v":4800}]
[null,{"$f":"IF($B$60=$H$60,\"\",\"ERREUR\")","v":""},{"$f":"IF($C$60=$I$60,\"\",\"ERREUR\")","v":""},{"$f":"IF(D60<>J60,\"ERREUR\",\"\")","v":""},null,null,null,{"$f":"IF($B$60=$H$60,\"\",\"ERREUR\")","v":""},{"$f":"IF($C$60=$I$60,\"\",\"ERREUR\")","v":""},{"$f":"IF($D$60=$J$60,\"\",\"ERREUR\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K44<>\"\",\"ERREUR\",\"\")","v":""},{"$f":"IF(L44<>\"\",\"ERREUR\",\"\")","v":""}]
["Le syndic:"]

{"sheet":"Annexe3","index":3,"n_rows":65,"n_cols":6,"rows_kept":65,"cut":false,"hidden":false,"merged":[[6,0,6,5],[7,1,7,3],[7,4,7,5]]}
[{"$f":"PLANS!A1","v":"Syndicat- des Copropriétaires"},null,null,null,null,"Annexe N° 3"]
[{"$f":"PLANS!A2","v":"Rue"}]
[{"$f":"PLANS!A3","v":"C.P. Ville"}]
[null,null,null,"Compte de gestion générale de l'exercice clos réalisé (N) du ",{"$f":"PLANS!H12","v":"1er janvier 2020 au 31 decembre 2020"}]
[null,null,null,"            budget prévisionnel de l'exercice  (N+2) du",{"$f":"PLANS!H13","v":"1er janvier 2022 au 31 décembre 2022"}]
[]
["CHARGES POUR OPERATIONS COURANTES"]
[null,"Pour approbation des comptes",null,null,"Pour le vote du budget prévisionnel"]
[null,"Exercice Précédent","Exercice clos","Exercice clos réalisé","Budget prévisionnel","Budget Prévisionnel"]
[null,"approuvé","budget voté","à approuver","en cours voté","à voter"]
[null,"N-1","N","N","N+1","N+2"]
[null,{"$f":"PLANS!$D$8","v":2019},{"$f":"PLANS!$G$8","v":2020},{"$f":"PLANS!$G$8","v":2020},{"$f":"PLANS!$J$8","v":2021},{"$f":"PLANS!$M$8","v":2022}]
["Charges communes gén."]
["Electricité",1913,1804,1614,1665,1706]
["Produits entretien Pet.Equip.",450,300,200,200,250]
["Nettoyage des locaux",1250,1300,1400,1450,1500]
["Entret.Réparat.div.",380,450,250,200,230]
[]
["Maintenance extincteur",320,340,360,380,400]
["Assurance",300,360,400,410,420]
["Honoraires syndic",1900,2000,2100,2200,2300]
["Débours",50,80,60,70,80]
["Frais Postaux",130,140,100,110,120]
["Fournitures",270,250,200,220,240]
["Autres charges financières",50,60,80,90,100]
[]
["Subventions",-500,-500,-500]
["Produits divers",-100,-100,-150,-200,-200]
["Produits financiers",-300,-200,-250,-300,-300]
[null,{"$f":"SUM(B13:B29)","v":6113},6284,5864,6495,6846]
["Charges Répartiteurs"]
["Contrat répartiteurs",1300,1200,1200,1250,1300]
[]
[]
[null,{"$f":"SUM(B31:B34)","v":1300},{"$f":"SUM(C31:C34)","v":1200},1200,1250,1300]
["Eau Cons.Individuelles"]
["Eau Cons.Individuelles",1200,1250,1200,1300,1300]
[]
[null,{"$f":"SUM(B36:B38)","v":1200},{"$f":"SUM(C36:C38)","v":1250},1200,1300,1300]
["Charges Chauffage"]
["Combustible",2300,2400,2200,2050,2100]
["electricité",300,350,300,350,400]
["Maintenance Chaudière",600,620,650,700,750]
["Indemité Assurance",-200]
[null,{"$f":"SUM(B40:B44)","v":3000},{"$f":"SUM(C40:C44)","v":3370},3150,3100,3250]
[]
[]
[]
[]
[]
[null,{"$f":"SUM(B46:B50)","v":0},{"$f":"SUM(C46:C50)","v":0},0,0,0]
[]
[]
[]
[null,{"$f":"SUM(B52:B54)","v":0},0,0,0,0]
[]
[]
[]
[null,{"$f":"SUM(B56:B58)","v":0},{"$f":"SUM(C56:C58)","v":0},0,0,0]
["TOTAL CHARGES NETTES",{"$f":"SUM(B30,B35,B39,B45,B51,B55,B59)","v":11613},{"$f":"SUM(C30,C35,C39,C45,C51,C55,C59)","v":12104},11414,12145,12696]
["Provisions copropriétaires",{"$f":"Annexe2!H13","v":10513},{"$f":"Annexe2!I13","v":12104},12100]
["Solde(Exécédent ou insuffisance s/opérations courantes affecté aux copropriétaires",{"$f":"B61-B60","v":-1100},null,{"$f":"D61-D60","v":686}]
[null,{"$f":"IF(B60=Annexe2!B43-Annexe2!H43+Annexe2!H13,\"\",\"ERREUR\")","v":""},{"$f":"IF(C60=Annexe2!C43-Annexe2!I43+Annexe2!I13,\"\",\"ERREUR\")","v":""},{"$f":"IF(D60=Annexe2!D43-Annexe2!J43+Annexe2!J13,\"\",\"ERREUR\")","v":""},{"$f":"IF(E60=Annexe2!E43-Annexe2!K43+Annexe2!K13,\"\",\"ERREUR\")","v":""},{"$f":"IF(F60=Annexe2!F43-Annexe2!L43+Annexe2!L13,\"\",\"ERREUR\")","v":""}]
[]
["Le syndic:"]

{"sheet":"Annexe4","index":4,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[[6,2,7,2],[6,3,6,5]]}
[{"$f":"PLANS!A1","v":"Syndicat- des Copropriétaires"},null,null,null,null,"Annexe N° 4"]
[{"$f":"PLANS!A2","v":"Rue"}]
[{"$f":"PLANS!A3","v":"C.P. Ville"}]
[null,null,"Compte de gestion pour travaux de l'article 14-2 et opérations exceptionnelles"]
[null,null,null,"Exceptionnelles de l'exercice clos réalisés du ",{"$f":"PLANS!H12","v":"1er janvier 2020 au 31 decembre 2020"}]
[]
[null,null,"Exercice clos,dépenses votés (N)","Exercice clos réalisé à approuver (N)"]
[null,null,null,"DEPENSES","PROVISIONS APPELEES","SOLDE "]
["TRAVAUX DE L'ARTCLE 14-2"]
["TRAVAUX",null,2000,2300]
["Provisions",null,null,null,1200]
["Produite affectés",null,-1000,-800]
[]
[null,"TOTAL",{"$f":"SUM(C10:C13)","v":1000},{"$f":"SUM(D10:D13)","v":1500},1200,{"$f":"E14-D14","v":-300}]
["TRAVAUX "]
["TRAVAUX",null,800,800]
["Provisions",null,null,null,500]
["Produite affectés",null,-500,-300]
[null,"TOTAL",{"$f":"SUM(C15:C18)","v":300},{"$f":"SUM(D15:D18)","v":500},500,{"$f":"E19-D19","v":0}]
["TRAVAUX "]
["TRAVAUX",null,1100,1100]
["Provisions",null,null,null,1100]
["Produite affectés"]
[null,"TOTAL",{"$f":"SUM(C20:C23)","v":1100},{"$f":"SUM(D20:D23)","v":1100},1100,{"$f":"E24-D24","v":0}]
["TRAVAUX "]
["TRAVAUX",null,600,600]
["Provisions",null,null,null,600]
["Produite affectés"]
[null,"TOTAL",{"$f":"SUM(C25:C28)","v":600},{"$f":"SUM(D25:D28)","v":600},600,{"$f":"E29-D29","v":0}]
[null,"TOTAL TRAVAUX ARTICLE-2 ",{"$f":"SUM(C14,C19,C24,C29)","v":3000},{"$f":"SUM(D14,D19,D24,D29)","v":3700},3400,{"$f":"E30-D30","v":-300}]
["OPERATIONS EXCEPTIONNELLES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["TOTAL OPERATIONS EXCEPTIONNELLES",null,{"$f":"SUM(C32:C42)","v":0},{"$f":"SUM(D32:D42)","v":0},{"$f":"SUM(E32:E42)","v":0},{"$f":"E43-D43","v":0}]
["TOTAL TRAVAUX DE L'ARTICLE 14-2 et OPERATIONS EXCEPTIONNELLES",null,{"$f":"C30+C43","v":3000},{"$f":"D30+D43","v":3700},3400,{"$f":"E44-D44","v":-300}]
[null,null,{"$f":"IF(C44=Annexe2!H48,\"\",\"ERREUR\")","v":""},{"$f":"IF(D44=Annexe2!D60-SUM(Annexe2!J49:J58),\"\",\"ERREUR\")","v":""},{"$f":"IF(E44=Annexe2!J48,\"\",\"ERREUR\")","v":""},{"$f":"IF(F44<>Annexe2!D59-Annexe2!J59,\"ERREUR\",\"\")","v":""}]
[null,null,null,null,"Le syndic:"]

{"sheet":"Annexe5","index":5,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[7,5,7,6],[8,5,8,6],[9,5,9,6],[11,5,11,6],[10,5,10,6]]}
[{"$f":"PLANS!A1","v":"Syndicat- des Copropriétaires"},null,null,null,null,null,null,"Annexe N° 5"]
[{"$f":"PLANS!A2","v":"Rue"}]
[{"$f":"PLANS!A3","v":"C.P. Ville"}]
[null,"ETAT DES TRAVAUX DE L'ARTICLE 14-2 ET OPERATIONS EXCEPTIONNNELLES VOTES NON ENCORE CLOTURES"]
[null,null,null,"A LA FIN DE L'EXERCICE DU ",{"$f":"PLANS!H12","v":"1er janvier 2020 au 31 decembre 2020"}]
[]
[]
[null,null,null,null,"APPELS TRAVAUX","SOLDE EN ATTENTE",null,"SUBVENTIONS ET"]
[null,"TRAVAUX VOTES ","TRAVAUX PAYES","TRAVAUX REALISES","EMPRUNTS ET","SUR TRAVAUX",null,"EMPRUNTS  A"]
[null,"(Montant et date)","(Montant et date)","(Montant et date)","SUBVENTIONS RECUS",null,null,"RECEVOIR"]
[null,null,null,null,"(Montant et date)","(Montant et date)",null,"(Montant et date)"]
[null,"A","B","C","D","E=D-C",null,"F"]
["TRAVAUX",null,null,null,500]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["TOTAL",{"$f":"SUM(B13:B32)","v":0},{"$f":"SUM(C13:C32)","v":0},0,500,{"$f":"E33-D33","v":500},null,0]
[null,null,null,null,null,{"$f":"IF(Annexe1!H16=Annexe5!F33,\"\",\"ERREUR\")","v":""}]
[]
[null,null,null,null,"Le syndic:"]

{"sheet":"Copros","index":6,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[29,1,29,5],[9,0,10,0],[9,1,10,5],[9,6,9,7],[28,1,28,5]]}
[{"$f":"PLANS!A1","v":"Syndicat- des Copropriétaires"}]
[{"$f":"PLANS!A2","v":"Rue"}]
[{"$f":"PLANS!A3","v":"C.P. Ville"}]
[]
[]
[null,null,"SITUATION DES COPROPRIETAIRES"]
[]
[null,null,null,null,null,"Au",{"$f":"PLANS!H10","v":"31 decembre 2020"}]
[]
["CODES","NOMS DES COPROPRIETAIRES",null,null,null,null,"SOLDES"]
[null,null,null,null,null,null,"DEBITEURS","CREDITEURS"]
[450.01,null,null,null,null,null,null,null,null,"Vous devez mettre les  noms et les soldes des comptes"]
[450.02,null,null,null,null,null,null,null,null,"copropriétaires"]
[450.03]
[450.04]
[450.05]
[450.06]
[450.07]
[450.08]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTAUX",null,null,null,null,{"$f":"SUM(G12:G28)","v":0},{"$f":"SUM(H12:H28)","v":0}]
[null,"SOLDE GENERAL",null,null,null,null,{"$f":"IF(G29>H29,G29-H29,\"\")","v":""},{"$f":"IF(H29>G29,H29-G29,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(Annexe1!D20=Copros!G29,\"\",\"ERREUR\")","v":"ERREUR"},{"$f":"IF(Annexe1!H20=Copros!H29,\"\",\"ERREUR\")","v":"ERREUR"}]
["Le syndic"]