{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["GESTION","Copropriétaires","Tant.Lots.Fds","FdsTravLots","Vérif","AUBERT","CARDON","DUBOIS","FONTAINE","HUBERT","LONGUET","MARTIAL","PONTEL","xxx","CoproLots","Lisez-moi"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":16,"comments":3,"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":"GESTION","index":0,"n_rows":88,"n_cols":46,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
["Syndicat des Copropriétaires",null,null,"Exercice du","1er janvier",2017,null,1,null,{"$f":"($G$4=3)+($G$4=4)+($G$4=5)+($G$4=6)+($G$4=12)+($G$4=13)+($G$4=14)+($G$4=20)+($G$4=21)+($G$4=22)+($G$4=28)+($G$4=29)+($G$4=30)+(($G$4=8)+($G$4=16)+($G$4=24)+($G$4=32))*2","v":1},{"$f":"(G4=3)+(G4=4)+(G4=5)+(G4=6)+((G4=12)+(G4=13)+(G4=14)+(G4=20)+(G4=21)+(G4=22)+(G4=28)+(G4=29)+(G4=30))*2+(G4=36)*3","v":2},80,null,{"$f":"F2+1","v":2018},null,null,null,{"$f":"Tant.Lots.Fds!M36","v":1},null,null,{"$f":"FdsTravLots!D36","v":-4700},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2020-10-06"},null,null,null,null,null,null,3,"1er Appel ","Charges courantes"]
["27 rue de PARIS",162,null,"Au","31 décembre.",2017,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,4,"2e Appel ",{"$f":"$AT$1","v":"Charges courantes"}]
["08200 LETROU",null,null,null,null,null,null,"OPERATION",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,5,"3e Appel ",{"$f":"$AT$1","v":"Charges courantes"}]
[null,null,"Date Avis….:","20/10/17",null,null,20,{"$f":"VLOOKUP($G$4,$AR$1:$AS$20,2,FALSE)","v":"1er Appel Travaux "},null,null,"\"C:\\chemin\\nom classeur.xlms\"",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,6,"4e Appel ",{"$f":"$AT$1","v":"Charges courantes"}]
[null,null,"Exigible le ","01//12/17",null,null,null,{"$f":"VLOOKUP($G$4,$AR$1:$AT$20,3)","v":"Electricité"},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,8,"Répartition ",{"$f":"$AT$1","v":"Charges courantes"}]
[{"$f":"G4","v":20},{"$f":"VLOOKUP($G$4,$AR$1:$AS$20,2,FALSE)","v":"1er Appel Travaux "},":",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,12,"1erAppel Travaux ","Peinture"]
[null,{"$f":"VLOOKUP($G$4,$AR$1:$AT$20,3,FALSE)","v":"Electricité"},"G E S T I O N    G E N E R A L E",null,null,null,"Sauvegarde du 29.09.20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G E S T I O N    G E N E R A L E",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"2e Appel Travaux ",{"$f":"$AT$6","v":"Peinture"}]
[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,"DEB.tableau",null,14,"3e Appel Travaux ",{"$f":"$AT$6","v":"Peinture"}]
[null,null,3,4,5,6,null,8,null,null,null,12,13,14,null,16,null,null,null,20,21,22,null,24,null,null,null,28,29,30,null,32,null,null,null,36,null,null,null,40,41,null,null,16,"Répart.Travaux",{"$f":"$AT$6","v":"Peinture"}]
["Tableau 1","FIN.tableau",null,null,null,null,null,null,null,null,null,null,"Travaux 1",{"$f":"AT6","v":"Peinture"},null,"Travaux 1",{"$f":"AT6","v":"Peinture"},null,null,null,"Travaux 2",{"$f":"AT10","v":"Electricité"},null,"Travaux 2",{"$f":"V10","v":"Electricité"},null,null,null,"Travaux 3",null,null,"Travaux 3",{"$f":"AD10","v":0},null,null,"Charges Locatives",null,"T.V.A.",null,"Avance Trésorerie","Fds Travaux  ",null,null,20,"1er Appel Travaux ","Electricité"]
["CLE","Désignation","Budget 1°Tr","Budget 2°Tr","Budget 3°Tr","Budget 4°Tr","TOT.APPELS","REALISE",null,"TVA",null,"I°Appel Trav.","2eAppelTrav;","3°Appel Trav","TOT.APPELS","REPART TRAV.",null,"T.V.A.",null,"I°Appel Trav.","2°Appel Trav.","3°Appel Trav","TOT.APPELS","REPART TRAV.",null,"T.V.A.",null,"I°Appel Trav.","2°Appel Trav.","3°Appel Trav","TOT.APPELS","REPART TRAV",null,"T.V.A.",null,null,null,null,null,null,"Dates libres",null,null,21,"2e Appel Travaux ",{"$f":"$AT$10","v":"Electricité"}]
[1,"Ch Gén.",3000,3000,3000,3000,{"$f":"SUM(C12:F12)","v":12000},12500,null,null,null,null,10000,null,{"$f":"SUM(L12:N12)","v":10000},null,null,null,null,6000,null,null,{"$f":"SUM(T12:V12)","v":6000},null,null,null,null,10000,null,null,{"$f":"SUM(AB12:AD12)","v":10000},null,null,null,null,null,null,null,null,null,null,null,null,22,"3e Appel Travaux ",{"$f":"$AT$10","v":"Electricité"}]
[2,"Ch.Bât.",1000,1000,1000,1000,{"$f":"SUM(C13:F13)","v":4000},4500,null,null,null,15000,null,null,{"$f":"SUM(L13:N13)","v":15000},null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,{"$f":"SUM(AB13:AD13)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,24,"Répart.Travaux",{"$f":"$AT$10","v":"Electricité"}]
[3,"Ch.Escal.A",500,500,500,500,{"$f":"SUM(C14:F14)","v":2000},1800,null,null,null,null,null,null,{"$f":"SUM(L14:N14)","v":0},null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,{"$f":"SUM(AB14:AD14)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,28,"1er Appel Travaux ","Toiture"]
[4,"Ch Escal B",null,null,null,null,{"$f":"SUM(C15:F15)","v":0},null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,29,"2e Appel Travaux ",{"$f":"$AT$14","v":"Toiture"}]
[5,"WC",null,null,null,null,{"$f":"SUM(C16:F16)","v":0},null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,30,"3e Appel Travaux ",{"$f":"$AT$14","v":"Toiture"}]
[6,"Provision Eau",2000,2000,2000,2000,{"$f":"SUM(C17:F17)","v":8000},null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,32,"Répart.Travaux",{"$f":"$AT$14","v":"Toiture"}]
[7,"EAU Individuelle",null,null,null,null,null,8200,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,36,"Charges locatives",","]
[8,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,40,"Avance Trésorerie",","]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,41,"Appel Fonds travaux ",","]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[10,null,{"$f":"SUM(C10:C22)","v":6500},{"$f":"SUM(D10:D22)","v":6500},{"$f":"SUM(E10:E22)","v":6500},{"$f":"SUM(F10:F22)","v":6500},{"$f":"SUM(G10:G22)","v":26000},{"$f":"SUM(H10:H22)","v":27000},null,0,null,15000,10000,0,25000,0,null,0,null,6000,0,0,6000,0,null,0,null,10000,0,0,10000,0,null,0,null,{"$f":"SUM(AJ12:AJ22)","v":0},null,{"$f":"SUM(AL12:AL22)","v":0}]
[11,"Fonds Travaux",500,500,500,500,null,null,null,null,"Remb,Avance Travaux",-900,null,null,null,null,null,null,"Remb,Avance Travaux",null,null,null,null,null,null,null,"Remb,Avance Travaux",-1800]
[12,"Av.Trésorerie",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,1000]
[]
[99,null,{"$f":"C23+C24","v":7000},{"$f":"D23+D24","v":7000},{"$f":"E23+E24","v":7000},{"$f":"F23+F24","v":7000},{"$f":"G23","v":26000},{"$f":"H23","v":27000},{"$f":"I23","v":0},{"$f":"J23","v":0},{"$f":"K23","v":0},{"$f":"L23+L24","v":14100},{"$f":"M23+M24","v":10000},{"$f":"N23+N24","v":0},null,{"$f":"P23","v":0},null,{"$f":"R23","v":0},null,{"$f":"T23+T24","v":6000},{"$f":"U23","v":0},{"$f":"V23","v":0},null,{"$f":"X23","v":0},null,null,null,{"$f":"AB23+AB24","v":8200},{"$f":"AC23","v":0},{"$f":"AD23","v":0},null,{"$f":"AF23","v":0},null,{"$f":"AH23","v":0},null,{"$f":"AJ23","v":0},null,null,null,{"$f":"AN25","v":1000},{"$f":"AO24","v":0}]
[null,null,1,1,1,1,null,1,null,null,null,1,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,1]
[]
["Base de calculs M3 d' eau.",null,null,null,null,null,"  M3 Eau",760,null,null,null,null,null,null,null,null,null,null,null,760]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PARTIICIPATIONS COPROPRIETAIRES",null,null,null,null,29]
[1,null,null,"PARTICIPATIONS COPROPRIETAIRES",null,null,null,null,null,null,null,12,null,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,null,36,null,null,null,40]
["Tableau 2",null,3,4,5,6,7,8,9,10,11,null,null,null,null,null,null,null,null,null,"Travaux 2",null,null,null,null,null,null,null,"Travaux 3"]
[null,"Copropriétaires","Budget 1°Tr","Budget 2°Tr","Budget 3°Tr","Budget 4°Tr","BUDGET","REALISE",null,null,null,"I°Appel Trav.","2e Appel Trav","3°Appel Trav","TOT.APPELS","REPART TRAV.",null,"T.V.A.",null,"I°Appel Trav.","2°Appel Trav.","3°Appel Trav","TOT.APPELS","REPART TRAV.",null,"T.V.A.",null,"I°Appel Trav.","2°Appel Trav.","3°Appel Trav","TOT.APPELS","REPRTR TRAV",null,"T.V.A",null,"Charges Locatives",null,"T.V.A.",null,"Avance   Trésorerie"]
[{"$f":"Copropriétaires!A6","v":450.00099999999998},{"$f":"Copropriétaires!B6","v":"AUBERT"},528.5,836.61,836.61,528.5,{"$f":"SUM(C35:F35)","v":2730.2200000000003},3488.0699999999997,null,null,null,2070,null,null,{"$f":"L35+M35+N35","v":2070},2340,null,null,null,702,null,null,{"$f":"T35+U35+V35","v":702},null,null,null,null,1170,null,null,{"$f":"AB35+AC35+AD35","v":1170},null,null,null,null,null,null,null,null,0,0]
[{"$f":"Copropriétaires!A7","v":450.00200000000001},{"$f":"Copropriétaires!B7","v":"CARDIN"},356.7,672.92000000000007,672.92000000000007,356.7,{"$f":"SUM(C36:F36)","v":2059.2400000000002},2716.25,null,null,null,0,null,null,{"$f":"L36+M36+N36","v":0},2378,null,null,null,713.4,null,null,{"$f":"T36+U36+V36","v":713.4},null,null,null,null,1189,null,null,{"$f":"AB36+AC36+AD36","v":1189},null,null,null,null,null,null,null,null,0,0]
[{"$f":"Copropriétaires!A8","v":450.00299999999999},{"$f":"Copropriétaires!B8","v":"DUBOIS"},1029.5,1029.5,1029.5,1029.5,4118,4244.7,null,null,null,3450,null,null,3450,3900,null,null,null,1170,null,null,1170,null,null,null,null,1950,null,null,1950,null,null,null,null,null,null,null,null,0,0]
[{"$f":"Copropriétaires!A9","v":450.005},{"$f":"Copropriétaires!B9","v":"FONTAINE"},781,1335.05,1335.05,781,4232.1000000000004,5584.34,null,null,null,2970,null,null,2970,3360,null,null,null,1008,null,null,1008,null,null,null,null,1680,null,null,1680,null,null,null,null,null,null,null,null,0,0]
[{"$f":"Copropriétaires!A10","v":450.00599999999997},{"$f":"Copropriétaires!B10","v":"HUBERT"},1035.5,1235.5,1235.5,1035.5,4542,5200.3900000000003,null,null,null,4095,null,null,4095,4660,null,null,null,1398,null,null,1398,null,null,null,null,2330,null,null,2330,null,null,null,null,null,null,null,null,0,0]
[{"$f":"Copropriétaires!A11","v":450.00700000000001},{"$f":"Copropriétaires!B11","v":"LONGUET"},484.5,943.96,943.96,484.5,2856.92,3894.26,null,null,null,1740,null,null,1740,1980,null,null,null,594,null,null,594,null,null,null,null,990,null,null,990,null,null,null,null,null,null,null,null,0,0]
[{"$f":"Copropriétaires!A12","v":450.00799999999998},{"$f":"Copropriétaires!B12","v":"MARTIAL"},93.3,136.54,136.54,93.3,459.68,572.16999999999996,null,null,null,0,null,null,0,622,null,null,null,186.6,null,null,186.6,null,null,null,null,311,null,null,311,null,null,null,null,null,null,null,null,0,0]
[450.00900000000001,{"$f":"Copropriétaires!B13","v":"PONTEL"},191,309.92,309.92,191,1001.84,1299.81,null,null,null,675,null,null,675,760,null,null,null,228,null,null,228,null,null,null,null,380,null,null,380,null,null,null,null,null,null,null,null,0]
[{"$f":"Copropriétaires!A14","v":450.01100000000002},{"$f":"Copropriétaires!B14","v":"xxx"},0,0,0,0,0,0,null,null,null,0,null,null,0,0,null,null,null,0,null,null,0,null,null,null,null,0,null,null,0,null,null,null,null,null,null,null,null,0]
[{"$f":"Copropriétaires!A15","v":902},{"$f":"Copropriétaires!B15","v":0},null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[{"$f":"Copropriétaires!A16","v":903},{"$f":"Copropriétaires!B16","v":0},null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[{"$f":"Copropriétaires!A17","v":904},{"$f":"Copropriétaires!B17","v":0},null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[{"$f":"Copropriétaires!A18","v":905},{"$f":"Copropriétaires!B18","v":0},null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[{"$f":"Copropriétaires!A19","v":906},{"$f":"Copropriétaires!B19","v":0},null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[{"$f":"Copropriétaires!A20","v":907},{"$f":"Copropriétaires!B20","v":0},null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[{"$f":"Copropriétaires!A21","v":908},{"$f":"Copropriétaires!B21","v":0},null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[{"$f":"Copropriétaires!A22","v":909},{"$f":"Copropriétaires!B22","v":0},null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[{"$f":"Copropriétaires!A23","v":910},{"$f":"Copropriétaires!B23","v":0},null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[{"$f":"Copropriétaires!A24","v":911},{"$f":"Copropriétaires!B24","v":0},null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[{"$f":"Copropriétaires!A25","v":912},{"$f":"Copropriétaires!B25","v":0},null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,"REPARTIS",{"$f":"SUM(C35:C54)","v":4500},6500,6500,4500,22000,26999.99,0,0,0,15000,0,0,{"$f":"SUM(O35:O54)","v":15000},{"$f":"SUM(P35:P54)","v":20000},null,{"$f":"SUM(R35:R54)","v":0},null,{"$f":"SUM(T35:T54)","v":6000},{"$f":"SUM(U35:U54)","v":0},{"$f":"SUM(V35:V54)","v":0},{"$f":"SUM(W35:W54)","v":6000},{"$f":"SUM(X35:X54)","v":0},null,0,null,10000,0,0,10000,0,null,0,null,0,null,0,null,{"$f":"SUM(AN35:AN54)","v":0}]
[null,"A REPARTIR",{"$f":"C23","v":6500},{"$f":"D23","v":6500},6500,6500,26000,{"$f":"H23","v":27000},0,0,0,null,null,null,25000,0,null,0,null,6000,{"$f":"U23","v":0},0,6000,0,null,0,null,10000,0,0,10000,0,null,{"$f":"AH23","v":0},null,{"$f":"AJ23","v":0},null,{"$f":"AL23","v":0},null,{"$f":"AN25","v":1000}]
[]
["Tableau 3"]
["AVANCES TRESORERIE"]
[null,54]
["FinAvTres",null,3,4,5,6,7,8,9,10,11,null,null,null,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,null,33,34,null,null,"RetourDebTres"]
["Code","Copropriétaires","MONTANT","01/01/17."]
[{"$f":"GESTION!$A$35","v":450.00099999999998},{"$f":"GESTION!$B$35","v":"AUBERT"},{"$f":"SUM(D63:AJ63)","v":117},117]
[{"$f":"GESTION!$A$36","v":450.00200000000001},{"$f":"GESTION!$B$36","v":"CARDIN"},{"$f":"SUM(D64:AJ64)","v":118.9},118.9]
[{"$f":"GESTION!$A$37","v":450.00299999999999},{"$f":"GESTION!$B$37","v":"DUBOIS"},195,195]
[{"$f":"GESTION!$A$38","v":450.005},{"$f":"GESTION!$B$38","v":"FONTAINE"},168,168]
[{"$f":"GESTION!$A$39","v":450.00599999999997},{"$f":"GESTION!$B$39","v":"HUBERT"},233,233]
[{"$f":"GESTION!$A$40","v":450.00700000000001},{"$f":"GESTION!$B$40","v":"LONGUET"},99,99]
[{"$f":"GESTION!$A$41","v":450.00799999999998},{"$f":"GESTION!$B$41","v":"MARTIAL"},31.1,31.1]
[{"$f":"GESTION!$A$42","v":450.00900000000001},{"$f":"GESTION!$B$42","v":"PONTEL"},38,38]
[{"$f":"GESTION!$A$43","v":450.01100000000002},{"$f":"GESTION!$B$43","v":"xxx"},0]
[{"$f":"GESTION!$A$44","v":902},{"$f":"GESTION!$B$44","v":0},0]
[{"$f":"GESTION!$A$45","v":903},{"$f":"GESTION!$B$45","v":0},0]
[{"$f":"GESTION!$A$46","v":904},{"$f":"GESTION!$B$46","v":0},0]
[{"$f":"GESTION!$A$47","v":905},{"$f":"GESTION!$B$47","v":0},0]
[{"$f":"GESTION!$A$48","v":906},{"$f":"GESTION!$B$48","v":0},0]
[{"$f":"GESTION!$A$49","v":907},{"$f":"GESTION!$B$49","v":0},0]
[{"$f":"GESTION!$A$50","v":908},{"$f":"GESTION!$B$50","v":0},0]
[{"$f":"GESTION!$A$51","v":909},{"$f":"GESTION!$B$51","v":0},0]
[{"$f":"GESTION!$A$52","v":910},{"$f":"GESTION!$B$52","v":0},0]
[{"$f":"GESTION!$A$53","v":911},{"$f":"GESTION!$B$53","v":0},0]
[{"$f":"GESTION!$A$54","v":912},{"$f":"GESTION!$B$54","v":0},0]
[null,null,{"$f":"SUM(C63:C82)","v":1000},{"$f":"SUM(D63:D82)","v":1000},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AG63:AG82)","v":0},{"$f":"SUM(AH63:AH82)","v":0},{"$f":"SUM(AI63:AI82)","v":0},{"$f":"SUM(AJ63:AJ82)","v":0}]
[]
[]
["Table 4"]
["AVANCE TRAVAUX"]
["Montant :",500]

{"sheet":"Copropriétaires","index":1,"n_rows":32,"n_cols":29,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
["COPROPRIETAIRES"]
[]
["Tableau A"]
["Code","Nom abrégé","Civilité et Nom",null,null,null,"Adresse",null,null,"C.P. Ville"]
[450.00099999999998,"AUBERT","Mr AUBERT J.Paul",null,null,null,"27 rue de Paris",null,null,"08200 LETROU"]
[450.00200000000001,"CARDIN","Mme CARDON Marie",null,null,null,"27 rue de Paris",null,null,"08200 LETROU"]
[450.00299999999999,"DUBOIS","Mr DUBOIS",null,null,null,"5 rue de Rennes",null,null,"77150 Lésigny"]
[450.005,"FONTAINE","Mme FONTAINE",null,null,null,"10 rue de la Paix",null,null,"85340 Olonne sur Mer"]
[450.00599999999997,"HUBERT","Mr HUBERT",null,null,null,"27 rue de Paris",null,null,"08200 LETROU"]
[450.00700000000001,"LONGUET","Mr LONGUET Jean Pierre",null,null,null,"9 allée Verte",null,null,"83270 Saint Cyr sur Mer"]
[450.00799999999998,"MARTIAL","Mr MARTIAL Paul",null,null,null,"27 rue de Paris",null,null,"08200 LETROU"]
[450.00900000000001,"PONTEL","Mr PONTEL Louis",null,null,null,"27 rue de Paris",null,null,"08200 LETROU"]
[450.01100000000002,"xxx","xxx"]
[902]
[903]
[904]
[905]
[906]
[907]
[908]
[909]
[910]
[911]
[912]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6]

{"sheet":"Tant.Lots.Fds","index":2,"n_rows":38,"n_cols":34,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[99,2,3,4,5,6,7,8,9,10,11,12,13,14,15,"Util.Av.Trav.",null,null,null,null,null,"Util.Av.Trav.",null,null,"Utilisation",null,null,null,null,"CONSOMMATIONS EAU"]
["Date de mise à jour 14",null,null,null,null,null,null,null,null,null,null,null,"Prov.eau","Eau Indiv.",null,null,{"$f":"VLOOKUP(1,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$K$1=2)","v":6000},{"$f":"VLOOKUP(2,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$K$1=2)","v":0},{"$f":"VLOOKUP(3,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$K$1=2)","v":0},{"$f":"VLOOKUP(4,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$K$1=2)","v":0},{"$f":"VLOOKUP(5,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$K$1=2)","v":0},{"$f":"GESTION!$L$24*(GESTION!$G$4=12)+GESTION!$T$24*(GESTION!$G$4=20)+GESTION!$AB$24*(GESTION!$G$4=28)","v":0},{"$f":"SUM(Q2:U2)","v":6000},null,{"$f":"GESTION!L1/100","v":0.8}]
[null,null,null,null,null,null,null,"Cle 1","Clé 2","Clé 3","Clé 4","Clé 5",null,null,"Clé 8"]
["N°Lot","Désignation","Bât./Escal;","Etage","N°Cop","Copopriétaires","Locataires","Ch.Géné","Ch.Bât,","Escal.A","Escal.B","WC Com",null,2017,null,{"$f":"IF(GESTION!$J$1=1,GESTION!$D$5,\"\")","v":"01//12/17"},"Ch.Géné","Ch.Bât,","Escal.A","Escal.B","WC Com",{"$f":"IF(GESTION!$J$1=1,GESTION!$D$5,\"\")","v":"01//12/17"},"A FINANCER","FONDS","Utilisation","Reste",null,"LOTS",null,null,1,2015,2016,2017]
[2,"Pavillon",null,"RDC",450.00799999999998,{"$f":"IF(E5<>\"\",VLOOKUP(E5,Copropriétaires!$A$6:$L$25,2),\"\")","v":"MARTIAL"},null,300,null,null,null,null,null,17,null,{"$f":"ROUND($P$3*H5/$H$36,2)","v":0},{"$f":"IF(H5>0,ROUND($Q$2*H5/10000,2),0)","v":180},{"$f":"IF(I5>0,ROUND($R$2*I5/1000,2),0)","v":0},{"$f":"IF(J5>0,ROUND($S$2*J5/1000,2),0)","v":0},{"$f":"IF(K5>0,ROUND($T$2*K5/1000,2),0)","v":0},{"$f":"IF(L5>0,ROUND($U$2*L5/1000,2),0)","v":0},{"$f":"IF($H5>0,ROUND($V$2*$H5/10000,2),0)","v":0},{"$f":"SUM(Q5:V5)*(SUM(Q5:V5)>0)","v":180},{"$f":"VLOOKUP(A5,FdsTravLots!$A$4:$C$35,3,0)","v":141},{"$f":"IF(ROUND(W5*$Y$2,2),-X5,ROUND(W5*$Y$2,2))","v":-141},{"$f":"X5+Y5","v":0},null,{"$f":"A5","v":2},{"$f":"F5","v":"MARTIAL"},null,null,31,16,17]
[11,"Cave N° 1","1,A","SS",450.00599999999997,{"$f":"IF(E6<>\"\",VLOOKUP(E6,Copropriétaires!$A$6:$L$25,2),\"\")","v":"HUBERT"},null,70,8,127,null,null,null,null,null,{"$f":"ROUND($P$3*H6/$H$36,2)","v":0},42,0,0,0,0,{"$f":"IF($H6>0,ROUND($V$2*$H6/10000,2),0)","v":0},{"$f":"SUM(Q6:V6)*(SUM(Q6:V6)>0)","v":42},{"$f":"VLOOKUP(A6,FdsTravLots!$A$4:$C$35,3,0)","v":32.9},{"$f":"IF(ROUND(W6*$Y$2,2),-X6,ROUND(W6*$Y$2,2))","v":-32.9},0,null,11,{"$f":"F6","v":"HUBERT"}]
[12,"Cave N° 2","1,A","SS",450.005,{"$f":"IF(E7<>\"\",VLOOKUP(E7,Copropriétaires!$A$6:$L$25,2),\"\")","v":"FONTAINE"},null,40,5,79,null,null,null,null,null,0,24,0,0,0,0,0,24,{"$f":"VLOOKUP(A7,FdsTravLots!$A$4:$C$35,3,0)","v":18.8},-18.8,0,null,12,"FONTAINE"]
[13,"Cave N° 3","1,A","SS",450.00299999999999,{"$f":"IF(E8<>\"\",VLOOKUP(E8,Copropriétaires!$A$6:$L$25,2),\"\")","v":"DUBOIS"},null,230,27,429,null,null,null,null,null,0,138,0,0,0,0,0,138,{"$f":"VLOOKUP(A8,FdsTravLots!$A$4:$C$35,3,0)","v":108.1},-108.1,0,null,13,"DUBOIS"]
[14,"Cave N° 4","1,A","SS",450.00900000000001,{"$f":"IF(E9<>\"\",VLOOKUP(E9,Copropriétaires!$A$6:$L$25,2),\"\")","v":"PONTEL"},null,30,4,64,null,null,null,null,null,0,18,0,0,0,0,0,18,{"$f":"VLOOKUP(A9,FdsTravLots!$A$4:$C$35,3,0)","v":14.1},-14.1,0,null,14,"PONTEL"]
[15,"Cave N° 5","1,A","SS",450.00700000000001,{"$f":"IF(E10<>\"\",VLOOKUP(E10,Copropriétaires!$A$6:$L$25,2),\"\")","v":"LONGUET"},null,80,9,143,null,null,null,null,null,0,48,0,0,0,0,0,48,{"$f":"VLOOKUP(A10,FdsTravLots!$A$4:$C$35,3,0)","v":37.6},-37.6,0,null,15,"LONGUET"]
[16,"Cave N° 6","1,A","SS",450.00099999999998,{"$f":"IF(E11<>\"\",VLOOKUP(E11,Copropriétaires!$A$6:$L$25,2),\"\")","v":"AUBERT"},null,40,5,79,null,null,null,null,null,0,24,0,0,0,0,0,24,{"$f":"VLOOKUP(A11,FdsTravLots!$A$4:$C$35,3,0)","v":18.8},-18.8,0,null,16,"AUBERT"]
[17,"Cave N° 7","1,A","SS",450.005,{"$f":"IF(E12<>\"\",VLOOKUP(E12,Copropriétaires!$A$6:$L$25,2),\"\")","v":"FONTAINE"},null,40,5,79,null,null,null,null,null,0,24,0,0,0,0,0,24,{"$f":"VLOOKUP(A12,FdsTravLots!$A$4:$C$35,3,0)","v":18.8},-18.8,0,null,17,"FONTAINE"]
[18,"W.C.",1,"RDC",450.00299999999999,{"$f":"IF(E13<>\"\",VLOOKUP(E13,Copropriétaires!$A$6:$L$25,2),\"\")","v":"DUBOIS"},null,30,4,null,null,null,null,null,null,0,18,0,0,0,0,0,18,{"$f":"VLOOKUP(A13,FdsTravLots!$A$4:$C$35,3,0)","v":14.1},-14.1,0,null,18,"DUBOIS"]
[19,"Commerce",1,"RDC",450.00299999999999,{"$f":"IF(E14<>\"\",VLOOKUP(E14,Copropriétaires!$A$6:$L$25,2),\"\")","v":"DUBOIS"},null,910,107,null,null,null,null,null,null,0,546,0,0,0,0,0,546,{"$f":"VLOOKUP(A14,FdsTravLots!$A$4:$C$35,3,0)","v":427.7},-427.7,0,null,19,"DUBOIS"]
[21,"Appartement","1,B","1er",450.005,{"$f":"IF(E15<>\"\",VLOOKUP(E15,Copropriétaires!$A$6:$L$25,2),\"\")","v":"FONTAINE"},"Dupont",760,89,null,124,401,null,107,null,0,456,0,0,0,0,0,456,{"$f":"VLOOKUP(A15,FdsTravLots!$A$4:$C$35,3,0)","v":357.2},-357.2,0,null,21,"FONTAINE",null,null,82,105,107]
[22,"Pièce","1,B","1er",450.00900000000001,{"$f":"IF(E16<>\"\",VLOOKUP(E16,Copropriétaires!$A$6:$L$25,2),\"\")","v":"PONTEL"},"Martial",350,41,null,57,185,null,47,null,0,210,0,0,0,0,0,210,{"$f":"VLOOKUP(A16,FdsTravLots!$A$4:$C$35,3,0)","v":164.5},-164.5,0,null,22,"PONTEL",null,null,44,44,47]
[23,"Appartement","1,B","1er",450.00299999999999,{"$f":"IF(E17<>\"\",VLOOKUP(E17,Copropriétaires!$A$6:$L$25,2),\"\")","v":"DUBOIS"},null,780,92,null,128,414,null,null,null,0,468,0,0,0,0,0,468,{"$f":"VLOOKUP(A17,FdsTravLots!$A$4:$C$35,3,0)","v":366.6},-366.6,0,null,23,"DUBOIS"]
[24,"W.C.","1,B","2e",450.005,{"$f":"IF(E18<>\"\",VLOOKUP(E18,Copropriétaires!$A$6:$L$25,2),\"\")","v":"FONTAINE"},null,30,4,null,5,null,null,null,null,0,18,0,0,0,0,0,18,{"$f":"VLOOKUP(A18,FdsTravLots!$A$4:$C$35,3,0)","v":14.1},-14.1,0,null,24,"FONTAINE"]
[25,"Appartement","1,B","2e",450.00099999999998,{"$f":"IF(E19<>\"\",VLOOKUP(E19,Copropriétaires!$A$6:$L$25,2),\"\")","v":"AUBERT"},null,780,92,null,134,null,null,117,null,0,468,0,0,0,0,0,468,{"$f":"VLOOKUP(A19,FdsTravLots!$A$4:$C$35,3,0)","v":366.6},-366.6,0,null,25,"AUBERT",null,null,61,114,117]
[26,"Pièce","1,B","2e",450.00099999999998,{"$f":"IF(E20<>\"\",VLOOKUP(E20,Copropriétaires!$A$6:$L$25,2),\"\")","v":"AUBERT"},null,350,41,null,60,null,null,null,null,0,210,0,0,0,0,0,210,{"$f":"VLOOKUP(A20,FdsTravLots!$A$4:$C$35,3,0)","v":164.5},-164.5,0,null,26,"AUBERT"]
[27,"Appartement","1,B","2e",450.005,{"$f":"IF(E21<>\"\",VLOOKUP(E21,Copropriétaires!$A$6:$L$25,2),\"\")","v":"FONTAINE"},null,810,95,null,139,null,null,107,null,0,486,0,0,0,0,0,486,{"$f":"VLOOKUP(A21,FdsTravLots!$A$4:$C$35,3,0)","v":380.7},-380.7,0,null,27,"FONTAINE",null,null,39,100,107]
[28,"Appartement","1,B","3e",450.00599999999997,{"$f":"IF(E22<>\"\",VLOOKUP(E22,Copropriétaires!$A$6:$L$25,2),\"\")","v":"HUBERT"},null,2260,265,null,353,null,null,77,null,0,1356,0,0,0,0,0,1356,{"$f":"VLOOKUP(A22,FdsTravLots!$A$4:$C$35,3,0)","v":1062.2},-1062.2,0,null,28,"HUBERT",null,null,71,74,77]
[29,"Commerce",1,"RDC -G",450.00700000000001,{"$f":"IF(E23<>\"\",VLOOKUP(E23,Copropriétaires!$A$6:$L$25,2),\"\")","v":"LONGUET"},null,480,56,null,null,null,null,107,null,0,288,0,0,0,0,0,288,{"$f":"VLOOKUP(A23,FdsTravLots!$A$4:$C$35,3,0)","v":225.6},-225.6,0,null,29,"LONGUET",null,null,103,103,107]
[30,"Commerce",1,"RDC-G",450.00700000000001,{"$f":"IF(E24<>\"\",VLOOKUP(E24,Copropriétaires!$A$6:$L$25,2),\"\")","v":"LONGUET"},"Cantin",430,51,null,null,null,null,67,null,0,258,0,0,0,0,0,258,{"$f":"VLOOKUP(A24,FdsTravLots!$A$4:$C$35,3,0)","v":202.1},-202.1,0,null,30,"LONGUET",null,null,67,67,67]
[41,"Maison","A","RDC",450.00200000000001,{"$f":"IF(E25<>\"\",VLOOKUP(E25,Copropriétaires!$A$6:$L$25,2),\"\")","v":"CARDIN"},null,940,null,null,null,null,null,114,null,0,564,0,0,0,0,0,564,{"$f":"VLOOKUP(A25,FdsTravLots!$A$4:$C$35,3,0)","v":441.8},-441.8,0,null,41,"CARDIN",null,null,117,117,114]
[42,"Remises -Auvent","B","RDC",450.00200000000001,{"$f":"IF(E26<>\"\",VLOOKUP(E26,Copropriétaires!$A$6:$L$25,2),\"\")","v":"CARDIN"},null,100,null,null,null,null,null,null,null,0,60,0,0,0,0,0,60,{"$f":"VLOOKUP(A26,FdsTravLots!$A$4:$C$35,3,0)","v":47},-47,0,null,42,"CARDIN"]
[43,"Remise","C","RDC",450.00200000000001,{"$f":"IF(E27<>\"\",VLOOKUP(E27,Copropriétaires!$A$6:$L$25,2),\"\")","v":"CARDIN"},null,20,null,null,null,null,null,null,null,0,12,0,0,0,0,0,12,{"$f":"VLOOKUP(A27,FdsTravLots!$A$4:$C$35,3,0)","v":9.4},-9.4,0,null,43,"CARDIN"]
[103,"Jardin privatrif",null,null,450.00200000000001,{"$f":"IF(E28<>\"\",VLOOKUP(E28,Copropriétaires!$A$6:$L$25,2),\"\")","v":"CARDIN"},null,129,null,null,null,null,null,null,null,0,77.400000000000006,0,0,0,0,0,77.400000000000006,{"$f":"VLOOKUP(A28,FdsTravLots!$A$4:$C$35,3,0)","v":60.63000000000001},-60.63000000000001,0,null,103,"CARDIN"]
[104,"Cour privative",null,null,450.00799999999998,{"$f":"IF(E29<>\"\",VLOOKUP(E29,Copropriétaires!$A$6:$L$25,2),\"\")","v":"MARTIAL"},null,1,null,null,null,null,null,null,null,0,0.6,0,0,0,0,0,0.6,{"$f":"VLOOKUP(A29,FdsTravLots!$A$4:$C$35,3,0)","v":0.47},-0.47,0,null,104,"MARTIAL"]
[105,"Cour privative",null,null,450.00799999999998,{"$f":"IF(E30<>\"\",VLOOKUP(E30,Copropriétaires!$A$6:$L$25,2),\"\")","v":"MARTIAL"},null,9,null,null,null,null,null,null,null,0,5.4,0,0,0,0,0,5.4,{"$f":"VLOOKUP(A30,FdsTravLots!$A$4:$C$35,3,0)","v":4.2300000000000004},-4.2300000000000004,0,null,105,"MARTIAL"]
[106,"Cour privative",null,null,450.00799999999998,{"$f":"IF(E31<>\"\",VLOOKUP(E31,Copropriétaires!$A$6:$L$25,2),\"\")","v":"MARTIAL"},null,1,null,null,null,null,null,null,null,0,0.6,0,0,0,0,0,0.6,{"$f":"VLOOKUP(A31,FdsTravLots!$A$4:$C$35,3,0)","v":0.47},-0.47,0,null,106,"MARTIAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"VLOOKUP(A32,FdsTravLots!$A$4:$C$35,3,0)","v":0},0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"VLOOKUP(A33,FdsTravLots!$A$4:$C$35,3,0)","v":0},0,0]
[null,null,null,null,null,{"$f":"IF(E34<>\"\",VLOOKUP(E34,Copropriétaires!$A$6:$L$25,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,{"$f":"VLOOKUP(A34,FdsTravLots!$A$4:$C$35,3,0)","v":0},0,null,null,null,""]
[null,null,null,null,null,{"$f":"IF(E35<>\"\",VLOOKUP(E35,Copropriétaires!$A$6:$L$25,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,{"$f":"VLOOKUP(A35,FdsTravLots!$A$4:$C$35,3,0)","v":0},0,null,null,null,""]
[99,null,null,null,null,{"$f":"IF(E36<>\"\",VLOOKUP(E36,Copropriétaires!$A$6:$L$25,2),\"\")","v":""},null,{"$f":"SUM(H5:H35)","v":10000},{"$f":"SUM(I5:I35)","v":1000},1000,1000,1000,1,760,0,0,6000,0,0,0,0,0,6000,4700,-4700,0,null,null,null,{"$f":"SUM(AD5:AD35)","v":0},0,{"$f":"SUM(AF5:AF35)","v":615},{"$f":"SUM(AG5:AG35)","v":740},{"$f":"SUM(AH5:AH35)","v":760}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Util.Av.Trav.","Reste","Fonds","Utilisations","Reste"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A financer","Travaux","Fds Travaux","Fds Travaux"]

{"sheet":"FdsTravLots","index":3,"n_rows":36,"n_cols":26,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,7,null,"Utilisation",5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26]
["N°Lot","Désignation","FONDS TRAV","Utilisation",null,"2007-01-10"]
[{"$f":"Tant.Lots.Fds!A5","v":2},{"$f":"Tant.Lots.Fds!B5","v":"Pavillon"},{"$f":"SUM(E4:Z4)","v":141},-141,96,15,null,15,15]
[{"$f":"Tant.Lots.Fds!A6","v":11},{"$f":"Tant.Lots.Fds!B6","v":"Cave N° 1"},32.9,-32.9,22.4,3.5,null,3.5,3.5]
[{"$f":"Tant.Lots.Fds!A7","v":12},{"$f":"Tant.Lots.Fds!B7","v":"Cave N° 2"},18.8,-18.8,12.8,2,null,2,2]
[{"$f":"Tant.Lots.Fds!A8","v":13},{"$f":"Tant.Lots.Fds!B8","v":"Cave N° 3"},108.1,-108.1,73.599999999999994,11.5,null,11.5,11.5]
[{"$f":"Tant.Lots.Fds!A9","v":14},{"$f":"Tant.Lots.Fds!B9","v":"Cave N° 4"},14.1,-14.1,9.6,1.5,null,1.5,1.5]
[{"$f":"Tant.Lots.Fds!A10","v":15},{"$f":"Tant.Lots.Fds!B10","v":"Cave N° 5"},37.6,-37.6,25.6,4,null,4,4]
[{"$f":"Tant.Lots.Fds!A11","v":16},{"$f":"Tant.Lots.Fds!B11","v":"Cave N° 6"},18.8,-18.8,12.8,2,null,2,2]
[{"$f":"Tant.Lots.Fds!A12","v":17},{"$f":"Tant.Lots.Fds!B12","v":"Cave N° 7"},18.8,-18.8,12.8,2,null,2,2]
[{"$f":"Tant.Lots.Fds!A13","v":18},{"$f":"Tant.Lots.Fds!B13","v":"W.C."},14.1,-14.1,9.6,1.5,null,1.5,1.5]
[{"$f":"Tant.Lots.Fds!A14","v":19},{"$f":"Tant.Lots.Fds!B14","v":"Commerce"},427.7,-427.7,291.2,45.5,null,45.5,45.5]
[{"$f":"Tant.Lots.Fds!A15","v":21},{"$f":"Tant.Lots.Fds!B15","v":"Appartement"},357.2,-357.2,243.2,38,null,38,38]
[{"$f":"Tant.Lots.Fds!A16","v":22},{"$f":"Tant.Lots.Fds!B16","v":"Pièce"},164.5,-164.5,112,17.5,null,17.5,17.5]
[{"$f":"Tant.Lots.Fds!A17","v":23},{"$f":"Tant.Lots.Fds!B17","v":"Appartement"},366.6,-366.6,249.6,39,null,39,39]
[{"$f":"Tant.Lots.Fds!A18","v":24},{"$f":"Tant.Lots.Fds!B18","v":"W.C."},14.1,-14.1,9.6,1.5,null,1.5,1.5]
[{"$f":"Tant.Lots.Fds!A19","v":25},{"$f":"Tant.Lots.Fds!B19","v":"Appartement"},366.6,-366.6,249.6,39,null,39,39]
[{"$f":"Tant.Lots.Fds!A20","v":26},{"$f":"Tant.Lots.Fds!B20","v":"Pièce"},164.5,-164.5,112,17.5,null,17.5,17.5]
[{"$f":"Tant.Lots.Fds!A21","v":27},{"$f":"Tant.Lots.Fds!B21","v":"Appartement"},380.7,-380.7,259.2,40.5,null,40.5,40.5]
[{"$f":"Tant.Lots.Fds!A22","v":28},{"$f":"Tant.Lots.Fds!B22","v":"Appartement"},1062.2,-1062.2,723.2,113,null,113,113]
[{"$f":"Tant.Lots.Fds!A23","v":29},{"$f":"Tant.Lots.Fds!B23","v":"Commerce"},225.6,-225.6,153.6,24,null,24,24]
[{"$f":"Tant.Lots.Fds!A24","v":30},{"$f":"Tant.Lots.Fds!B24","v":"Commerce"},202.1,-202.1,137.6,21.5,null,21.5,21.5]
[{"$f":"Tant.Lots.Fds!A25","v":41},{"$f":"Tant.Lots.Fds!B25","v":"Maison"},441.8,-441.8,300.8,47,null,47,47]
[{"$f":"Tant.Lots.Fds!A26","v":42},{"$f":"Tant.Lots.Fds!B26","v":"Remises -Auvent"},47,-47,32,5,null,5,5]
[{"$f":"Tant.Lots.Fds!A27","v":43},{"$f":"Tant.Lots.Fds!B27","v":"Remise"},9.4,-9.4,6.4,1,null,1,1]
[{"$f":"Tant.Lots.Fds!A28","v":103},{"$f":"Tant.Lots.Fds!B28","v":"Jardin privatrif"},60.63000000000001,-60.63000000000001,41.28,6.45,null,6.45,6.45]
[{"$f":"Tant.Lots.Fds!A29","v":104},{"$f":"Tant.Lots.Fds!B29","v":"Cour privative"},0.47,-0.47,0.32,0.05,null,0.05,0.05]
[{"$f":"Tant.Lots.Fds!A30","v":105},{"$f":"Tant.Lots.Fds!B30","v":"Cour privative"},4.2300000000000004,-4.2300000000000004,2.88,0.45,null,0.45,0.45]
[{"$f":"Tant.Lots.Fds!A31","v":106},{"$f":"Tant.Lots.Fds!B31","v":"Cour privative"},0.47,-0.47,0.32,0.05,null,0.05,0.05]
[{"$f":"Tant.Lots.Fds!A32","v":0},{"$f":"Tant.Lots.Fds!B32","v":0},0,0,0,0,null,0,0]
[{"$f":"Tant.Lots.Fds!A33","v":0},{"$f":"Tant.Lots.Fds!B33","v":0},0,0,0,0,null,0,0]
[{"$f":"Tant.Lots.Fds!A34","v":0},{"$f":"Tant.Lots.Fds!B34","v":0},0,0,0,0,null,0,0]
[{"$f":"Tant.Lots.Fds!A35","v":0},{"$f":"Tant.Lots.Fds!B35","v":0},0,0,0,0,null,0,0]
[null,null,0,0,0,0,null,0,0]
[99,null,{"$f":"SUM(C4:C35)","v":4700},-4700,{"$f":"SUM(E4:E35)","v":3200.0000000000009},{"$f":"SUM(F4:F35)","v":500},0,500,500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Vérif","index":4,"n_rows":71,"n_cols":21,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
[{"$f":"GESTION!A1","v":"Syndicat des Copropriétaires"},null,null,"Exercice du",{"$f":"GESTION!E1","v":"1er janvier"},{"$f":"GESTION!F1","v":2017}]
[{"$f":"GESTION!A2","v":"27 rue de PARIS"},null,null,"Au",{"$f":"GESTION!E2","v":"31 décembre."},{"$f":"GESTION!F2","v":2017}]
[{"$f":"GESTION!A3","v":"08200 LETROU"}]
[]
[]
[null,null,null,null,null,null,null,null,"Opération :",null,null,null,null,null,null,null,null,null,null,"Opération"]
[null,null,null,null,null,null,null,null,{"$f":"GESTION!$G$4","v":20},{"$f":"GESTION!$H$4","v":"1er Appel Travaux "},null,null,null,null,null,null,null,null,null,{"$f":"GESTION!$G$4","v":20},{"$f":"GESTION!$H$4","v":"1er Appel Travaux "}]
[]
[null,"CLE","Designation",null,"Tantièmes",null,"Réparti",null,"Code","Copropriétaires","Appels Ch.Ctes",{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},"Av.Trésorerie","Provisions","Finan,Travaux","SOLDES","Relevés Déb.","Relevés Cred,","Soldes",null,"T.V.A."]
[null,1,"Charges Générales",null,{"$f":"SUM(AUBERT:PONTEL!$E$90)","v":10000},null,{"$f":"SUM(AUBERT:PONTEL!$G$90)","v":6000},null,{"$f":"Copropriétaires!A6","v":450.00099999999998},{"$f":"Copropriétaires!B6","v":"AUBERT"},{"$f":"AUBERT!$G$98","v":702},{"$f":"AUBERT!$G$99","v":0},{"$f":"AUBERT!$G$100","v":0},{"$f":"AUBERT!$G$38","v":0},{"$f":"AUBERT!$G$103","v":-549.90000000000009},{"$f":"K10+L10+M10+N10+O10","v":152.09999999999991},{"$f":"AUBERT!$F$49","v":0},{"$f":"AUBERT!$G$49","v":0},{"$f":"P10+Q10-R10","v":152.09999999999991},null,{"$f":"AUBERT!$L$37","v":0}]
[null,2,"Ch.Bâtiment",null,{"$f":"SUM(AUBERT:PONTEL!$E$91)","v":1000},null,{"$f":"SUM(AUBERT:PONTEL!$G$91)","v":0},null,{"$f":"Copropriétaires!A7","v":450.00200000000001},{"$f":"Copropriétaires!B7","v":"CARDIN"},{"$f":"CARDON!$G$98","v":713.4},{"$f":"CARDON!$G$99","v":0},{"$f":"CARDON!$G$100","v":0},{"$f":"CARDON!$G$38","v":0},{"$f":"CARDON!$G$103","v":-558.83000000000004},{"$f":"K11+L11+M11+N11+O11","v":154.56999999999994},{"$f":"CARDON!$F$49","v":0},{"$f":"CARDON!$G$49","v":0},{"$f":"P11+Q11-R11","v":154.56999999999994},null,{"$f":"CARDON!$L$37","v":0}]
[null,3,"Ch.Escal.A",null,{"$f":"SUM(AUBERT:PONTEL!$E$92)","v":1000},null,{"$f":"SUM(AUBERT:PONTEL!$G$92)","v":0},null,{"$f":"Copropriétaires!A8","v":450.00299999999999},{"$f":"Copropriétaires!B8","v":"DUBOIS"},{"$f":"DUBOIS!$G$98","v":1170},{"$f":"DUBOIS!$G$99","v":0},{"$f":"DUBOIS!$G$100","v":0},{"$f":"DUBOIS!$G$38","v":0},{"$f":"DUBOIS!$G$103","v":-916.5},253.5,{"$f":"DUBOIS!$F$49","v":0},{"$f":"DUBOIS!$G$49","v":0},253.5,null,{"$f":"DUBOIS!$L$37","v":0}]
[null,4,"Ch,Escal.B",null,{"$f":"SUM(AUBERT:PONTEL!$E$93)","v":1000},null,{"$f":"SUM(AUBERT:PONTEL!$G$93)","v":0},null,{"$f":"Copropriétaires!A9","v":450.005},{"$f":"Copropriétaires!B9","v":"FONTAINE"},{"$f":"FONTAINE!$G$98","v":1008},{"$f":"FONTAINE!$G$99","v":0},{"$f":"FONTAINE!$G$100","v":0},{"$f":"FONTAINE!$G$68","v":0},{"$f":"FONTAINE!$G$103","v":-789.6},{"$f":"K13+L13+M13+N13+O13","v":218.39999999999998},{"$f":"FONTAINE!$F$79","v":0},{"$f":"FONTAINE!$G$79","v":0},{"$f":"P13+Q13-R13","v":218.39999999999998},null,{"$f":"FONTAINE!$L$67","v":0}]
[null,5,"WC Commun",null,{"$f":"SUM(AUBERT:PONTEL!$E$94)","v":1000},null,{"$f":"SUM(AUBERT:PONTEL!$G$94)","v":0},null,{"$f":"Copropriétaires!A10","v":450.00599999999997},{"$f":"Copropriétaires!B10","v":"HUBERT"},{"$f":"HUBERT!$G$98","v":1398},{"$f":"HUBERT!$G$99","v":0},{"$f":"HUBERT!$G$100","v":0},{"$f":"HUBERT!$G$38","v":0},{"$f":"HUBERT!$G$103","v":-1095.1000000000001},{"$f":"K14+L14+M14+N14+O14","v":302.89999999999986},{"$f":"HUBERT!$F$49","v":0},{"$f":"HUBERT!$G$49","v":0},{"$f":"P14+Q14-R14","v":302.89999999999986},null,{"$f":"HUBERT!$L$37","v":0}]
[null,6,"Prov.Eau",null,{"$f":"SUM(AUBERT:PONTEL!$E$95)","v":0},null,{"$f":"SUM(AUBERT:PONTEL!$G$95)","v":0},null,{"$f":"Copropriétaires!A11","v":450.00700000000001},{"$f":"Copropriétaires!B11","v":"LONGUET"},{"$f":"LONGUET!$G$98","v":594},{"$f":"LONGUET!$G$99","v":0},{"$f":"LONGUET!$G$100","v":0},{"$f":"LONGUET!$G$38","v":0},{"$f":"LONGUET!$G$103","v":-465.29999999999995},{"$f":"K15+L15+M15+N15+O15","v":128.70000000000005},{"$f":"LONGUET!$F$49","v":0},{"$f":"LONGUET!$G$49","v":0},{"$f":"P15+Q15-R15","v":128.70000000000005},null,{"$f":"LONGUET!$L$37","v":0}]
[null,7,"EAU Individuelle",null,{"$f":"SUM(AUBERT:PONTEL!$E$96)","v":0},null,{"$f":"SUM(AUBERT:PONTEL!$G$96)","v":0},null,{"$f":"Copropriétaires!A12","v":450.00799999999998},{"$f":"Copropriétaires!B12","v":"MARTIAL"},{"$f":"MARTIAL!G98","v":186.6},{"$f":"MARTIAL!G99","v":0},{"$f":"MARTIAL!G100","v":0},{"$f":"MARTIAL!G38","v":0},{"$f":"MARTIAL!G103","v":-146.16999999999999},{"$f":"K16+L16+M16+N16+O16","v":40.430000000000007},{"$f":"MARTIAL!F49","v":0},{"$f":"MARTIAL!G49","v":0},{"$f":"P16+Q16-R16","v":40.430000000000007},null,{"$f":"MARTIAL!$L$37","v":0}]
[null,8,"Eau Commune",null,{"$f":"SUM(AUBERT:PONTEL!$E$97)","v":0},null,{"$f":"SUM(AUBERT:PONTEL!$G$97)","v":0},null,{"$f":"Copropriétaires!A13","v":450.00900000000001},{"$f":"Copropriétaires!B13","v":"PONTEL"},{"$f":"PONTEL!$G$98","v":228},{"$f":"PONTEL!$G$99","v":0},{"$f":"PONTEL!$G$100","v":0},{"$f":"PONTEL!$G$38","v":0},{"$f":"PONTEL!$G$103","v":-178.6},49.400000000000006,{"$f":"PONTEL!$F$49","v":0},{"$f":"PONTEL!$G$49","v":0},49.400000000000006]
[null,null,null,null,null,null,{"$f":"SUM(AUBERT:PONTEL!$G$98)","v":6000},null,450.01100000000002,{"$f":"Copropriétaires!B14","v":"xxx"},{"$f":"xxx!$G$98","v":0},{"$f":"xxx!$G$99","v":0},{"$f":"xxx!$G$100","v":0},{"$f":"xxx!$G$38","v":0},{"$f":"xxx!$G$103","v":0},{"$f":"K18+L18+M18+N18+O18","v":0},{"$f":"xxx!$F$49","v":0},{"$f":"xxx!$G$49","v":0},{"$f":"P18+Q18-R18","v":0}]
[null,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},null,{"$f":"SUM(AUBERT:PONTEL!$E$99)","v":10000},null,{"$f":"SUM(AUBERT:PONTEL!$G$99)","v":0},null,null,null,null,null,null,null,null,0,null,null,0]
[null,12,"Avance Trésorerie",null,null,null,{"$f":"SUM(AUBERT:PONTEL!$G$100)","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"G18+G19+G20","v":6000},null,null,null,{"$f":"SUM(K10:K20)","v":6000},{"$f":"SUM(L10:L20)","v":0},{"$f":"SUM(M10:M20)","v":0},0,-4700.0000000000009,1300,0,0,1300,null,{"$f":"SUM(U10:U20)","v":0}]
[]
[null,null,"Financement travaux",null,null,null,{"$f":"SUM(AUBERT:PONTEL!G103)","v":-4700.0000000000009}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M53-N53=K69-L69,\"\",\"ERREUR\")","v":""}]

{"sheet":"AUBERT","index":5,"n_rows":103,"n_cols":14,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
[{"$f":"GESTION!A1","v":"Syndicat des Copropriétaires"}]
[{"$f":"GESTION!A2","v":"27 rue de PARIS"},null,null,null,null,null,{"$f":"Copropriétaires!$A$6","v":450.00099999999998},{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,3,FALSE)","v":"Mr AUBERT J.Paul"}]
[{"$f":"GESTION!A3","v":"08200 LETROU"},null,null,null,null,null,null,{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,7,FALSE)","v":"27 rue de Paris"}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,10,FALSE)","v":"08200 LETROU"}]
[null,null,null,"Date d'avis:",{"$f":"GESTION!$D$4","v":"20/10/17"}]
[null,null,null,"Exigible",{"$f":"GESTION!$D$5","v":"01//12/17"}]
[]
["Lots 16,  25, 26",null,{"$f":"GESTION!$G$4","v":20},{"$f":"CONCATENATE(GESTION!$H$4,\" \",GESTION!$H$5)","v":"1er Appel Travaux  Electricité"}]
[null,"1170/10000",null,{"$f":"CONCATENATE(\"Exercice du \",GESTION!$E$1,\" \",GESTION!$F$1,\" au \",GESTION!$E$2,\" \",GESTION!$F$2)","v":"Exercice du 1er janvier 2017 au 31 décembre. 2017"},null,null,null,{"$f":"OR(GESTION!$G$4=8,GESTION!$G$4=16,GESTION!$G$4=24,GESTION!$G$4=32,GESTION!$G$4=36)","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"GESTION!$L$1","v":80},"%"]
["LOT","CLE","Designation","A répartir","V/Tantièmes","Tantièmes Gén.","V/Quote part","FONDS","Affectation","Fd Restant","TVA","Q.P. T.V.A"]
[16,null,{"$f":"VLOOKUP(A12,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Cave N° 6"},null,null,null,null,null,"",""]
[16,1,{"$f":"VLOOKUP(B13,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B13,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A13,Tant.Lots.Fds!$A$5:$AB$35,B13+7)","v":40},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B13+7)","v":10000},{"$f":"ROUND(D13*E13/F13,2)","v":24},null,"","",{"$f":"IF(B13<>\"\",VLOOKUP(B13,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K13<>0,ROUND($K13*$E13/$F13,2),0)","v":0}]
[16,2,{"$f":"VLOOKUP(B14,GESTION!$A$12:$B$26,2)","v":"Ch.Bât."},{"$f":"VLOOKUP(B14,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A14,Tant.Lots.Fds!$A$5:$AB$35,B14+7)","v":5},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B14+7)","v":1000},{"$f":"ROUND(D14*E14/F14,2)","v":0},null,"","",{"$f":"IF(B14<>\"\",VLOOKUP(B14,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K14<>0,ROUND($K14*$E14/$F14,2),0)","v":0}]
[16,3,{"$f":"VLOOKUP(B15,GESTION!$A$12:$B$26,2)","v":"Ch.Escal.A"},{"$f":"VLOOKUP(B15,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A15,Tant.Lots.Fds!$A$5:$AB$35,B15+7)","v":79},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B15+7)","v":1000},{"$f":"ROUND(D15*E15/F15,2)","v":0},null,"","",{"$f":"IF(B15<>\"\",VLOOKUP(B15,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K15<>0,ROUND($K15*$E15/$F15,2),0)","v":0}]
[16,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B16,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B16,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A16,Tant.Lots.Fds!$A$5:$AB$35,8)","v":40},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},{"$f":"ROUND(D16*E16/F16,2)","v":0},null,null,null,null,{"$f":"IF(J16<>0,ROUND(J16*D16/E16,2),\"\")","v":""}]
[16,null,null,null,null,null,{"$f":"SUM(G13:G16)","v":24},{"$f":"VLOOKUP(A17,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":18.8},{"$f":"IF(H17>ROUND(G17*$I$10/100,2),ROUND(G17*$I$10/100,2),H17)*-1*(G17>0)","v":-18.8},{"$f":"H17+I17","v":0},null,{"$f":"SUM(L13:L16)","v":0},null,{"$f":"VLOOKUP(A17,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A17,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[25,null,{"$f":"VLOOKUP(A18,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Appartement"},null,null,null,null,null,"",""]
[25,1,{"$f":"VLOOKUP(B19,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B19,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A19,Tant.Lots.Fds!$A$5:$AB$35,B19+7)","v":780},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B19+7)","v":10000},{"$f":"ROUND(D19*E19/F19,2)","v":468},null,"","",{"$f":"IF(B19<>\"\",VLOOKUP(B19,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K19<>0,ROUND($K19*$E19/$F19,2),0)","v":0}]
[25,2,{"$f":"VLOOKUP(B20,GESTION!$A$12:$B$26,2)","v":"Ch.Bât."},{"$f":"VLOOKUP(B20,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A20,Tant.Lots.Fds!$A$5:$AB$35,B20+7)","v":92},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B20+7)","v":1000},0,null,"","",{"$f":"IF(B20<>\"\",VLOOKUP(B20,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[25,4,{"$f":"VLOOKUP(B21,GESTION!$A$12:$B$26,2)","v":"Ch Escal B"},{"$f":"VLOOKUP(B21,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A21,Tant.Lots.Fds!$A$5:$AB$35,B21+7)","v":134},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B21+7)","v":1000},0,null,null,null,{"$f":"IF(B21<>\"\",VLOOKUP(B21,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[25,6,{"$f":"VLOOKUP(B22,GESTION!$A$12:$B$26,2)","v":"Provision Eau"},{"$f":"VLOOKUP(B22,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)","v":0},{"$f":"VLOOKUP(A22,Tant.Lots.Fds!$A$5:$Z$35,13,0)*(GESTION!$J$1=1)","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B22+7)","v":1},0,null,null,null,{"$f":"IF(B22<>\"\",VLOOKUP(B22,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[25,7,{"$f":"VLOOKUP(B23,GESTION!$A$12:$B$26,2)","v":"EAU Individuelle"},{"$f":"VLOOKUP(B23,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"VLOOKUP(A23,Tant.Lots.Fds!$A$5:$Z$35,14,0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B23+7)+(Tant.Lots.Fds!$N$36=0)","v":760},0,null,null,null,{"$f":"IF(B23<>\"\",VLOOKUP(B23,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[25,8,null,null,null,null,null,null,null,null,{"$f":"IF(B24<>\"\",VLOOKUP(B24,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[25,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B25,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B25,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A25,Tant.Lots.Fds!$A$5:$AB$35,8)","v":780},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},0,null,null,null,null,{"$f":"IF(J25<>0,ROUND(J25*D25/E25,2),\"\")","v":""}]
[25,null,null,null,null,null,{"$f":"SUM(G19:G25)","v":468},{"$f":"VLOOKUP(A26,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":366.6},{"$f":"IF(H26>ROUND(G26*$I$10/100,2),ROUND(G26*$I$10/100,2),H26)*-1*(G26>0)","v":-366.6},{"$f":"H26+I26","v":0},null,{"$f":"SUM(L19:L25)","v":0},null,{"$f":"VLOOKUP(A26,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A26,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[26,null,{"$f":"VLOOKUP(A27,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Pièce"}]
[26,1,{"$f":"VLOOKUP(B28,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B28,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A28,Tant.Lots.Fds!$A$5:$AB$35,B28+7)","v":350},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B28+7)","v":10000},{"$f":"ROUND(D28*E28/F28,2)","v":210},null,"","",{"$f":"IF(B28<>\"\",VLOOKUP(B28,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K28<>0,ROUND($K28*$E28/$F28,2),0)","v":0}]
[26,2,{"$f":"VLOOKUP(B29,GESTION!$A$12:$B$26,2)","v":"Ch.Bât."},{"$f":"VLOOKUP(B29,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A29,Tant.Lots.Fds!$A$5:$AB$35,B29+7)","v":41},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B29+7)","v":1000},{"$f":"ROUND(D29*E29/F29,2)","v":0},null,"",null,{"$f":"IF(B29<>\"\",VLOOKUP(B29,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[26,4,{"$f":"VLOOKUP(B30,GESTION!$A$12:$B$26,2)","v":"Ch Escal B"},{"$f":"VLOOKUP(B30,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A30,Tant.Lots.Fds!$A$5:$AB$35,B30+7)","v":60},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B30+7)","v":1000},0,null,null,null,{"$f":"IF(B30<>\"\",VLOOKUP(B30,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[26,6,{"$f":"VLOOKUP(B31,GESTION!$A$12:$B$26,2)","v":"Provision Eau"},{"$f":"VLOOKUP(B31,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)","v":0},{"$f":"VLOOKUP(A31,Tant.Lots.Fds!$A$5:$Z$35,13,0)*(GESTION!$J$1=1)","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B31+7)","v":1},0,null,null,null,{"$f":"IF(B31<>\"\",VLOOKUP(B31,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[26,7,{"$f":"VLOOKUP(B32,GESTION!$A$12:$B$26,2)","v":"EAU Individuelle"},{"$f":"VLOOKUP(B32,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"VLOOKUP(A32,Tant.Lots.Fds!$A$5:$Z$35,14,0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B32+7)+(Tant.Lots.Fds!$N$36=0)","v":760},0,null,null,null,{"$f":"IF(B32<>\"\",VLOOKUP(B32,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[26,8,null,null,null,null,null,null,null,null,{"$f":"IF(B33<>\"\",VLOOKUP(B33,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[26,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B34,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B34,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A34,Tant.Lots.Fds!$A$5:$AB$35,8)","v":350},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},0,null,null,null,null,{"$f":"IF(J34<>0,ROUND(J34*D34/E34,2),\"\")","v":""}]
[26,null,null,null,null,null,{"$f":"SUM(G28:G34)","v":210},{"$f":"VLOOKUP(A35,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":164.5},{"$f":"IF(H35>ROUND(G35*$I$10/100,2),ROUND(G35*$I$10/100,2),H35)*-1*(G35>0)","v":-164.5},{"$f":"H35+I35","v":0},null,{"$f":"SUM(L28:L34)","v":0},null,{"$f":"VLOOKUP(A35,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A35,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[1,12,"Avance Trésorerie",{"$f":"VLOOKUP(B36,GESTION!$A$12:'GESTION'!$AQ$25,GESTION!$G$4,0)*(GESTION!G4=40)","v":0},{"$f":"SUMIF(B12:E35,1,E12:E35)*(GESTION!G4=40)","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)*(GESTION!$G$4=40)","v":0},{"$f":"ROUND(D36*E36/10000,2)","v":0}]
[null,null,null,null,null,"TOTAL",{"$f":"(SUM(G12:G35)/2)+G36","v":702},{"$f":"SUM(H12:H36)","v":549.90000000000009},{"$f":"SUM(I12:I36)","v":-549.90000000000009},{"$f":"SUM(J12:J36)","v":0},null,{"$f":"SUM(L12:L36)/2","v":0},null,{"$f":"SUM(N13:N36)","v":0}]
[null,null,null,null,"Provisions",null,{"$f":"SUM(K38:N38)*-1","v":0},null,null,null,{"$f":"IF(GESTION!$G$4=8,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=16,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=24,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=32,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""}]
[null,null,null,null,"Financement Fond sTravaux",null,{"$f":"I37","v":-549.90000000000009},null,null,null,8,16,24,32]
[null,null,null,"SOLDE en votre faveur…………………..",null,null,{"$f":"IF(AND(H$4<>36,G37+G38+G39<0),G37+G38+G39,0)","v":0},null,null,null,{"$f":"GESTION!$G$4","v":20},{"$f":"GESTION!$H$4","v":"1er Appel Travaux "}]
[null,null,null,"SOLDE dû au syndicat…………….",null,null,{"$f":"IF(AND($G$4<>36,G37+G38+G39>0),G37+G38+G39,0)","v":152.09999999999991}]
[null,null,null,null,null,null,null,null,{"$f":"IF(L37>0,\"Dont T.V.A.\",\"\")","v":""},{"$f":"IF(L37<>0,L37,\"\")","v":""}]
[null,null,null,"RELEVE DE COMPTE",null,null,null,null,{"$f":"IF(M6<>0,#REF!,\"\")","v":""},null,null,"La zône grisée n' est pas destinée"]
[null,null,null,null,null,null,null,null,{"$f":"IF(M6<>0,#REF!,\"\")","v":""},null,null,"a être imprimée et diffusée."]
[null,null,"Dates","Libellés des operations",null,"DEBIT","CREDIT"]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F46:F48)","v":0},{"$f":"SUM(G46:G48)","v":0}]
[null,null,{"$f":"IF(GESTION!$G$4<>36,E6,\"\")","v":"01//12/17"},{"$f":"IF(GESTION!$G$4<>36,D8,\"\")","v":"1er Appel Travaux  Electricité"},null,{"$f":"G41","v":152.09999999999991},{"$f":"IF(G40>0,G40,G40*-1)","v":0}]
[null,null,null,null,null,{"$f":"SUM(F49:F50)","v":152.09999999999991},{"$f":"SUM(G49:G50)","v":0}]
[null,null,null,null,{"$f":"IF(F52<G52,\"Montant à Payer\",\"Montant à votre crédit\")","v":"Montant à Payer"},{"$f":"IF((F51-G51)>0,F51-G51,\"\")","v":152.09999999999991},{"$f":"IF((G51-F51)>0,G51-F51,\"\")","v":""}]
[]
[null,null,"Avance Trésorerie","Av.Travaux","Fds Travaux ",{"$f":"IF($F$52<$G$52,\"Règlement à faire à l'ordre du Syndicat des Copropriétaires.\",\"\")","v":"Règlement à faire à l'ordre du Syndicat des Copropriétaires."}]
[null,null,{"$f":"VLOOKUP($G2,GESTION!$A$63:$C$82,3,FALSE)","v":117},{"$f":"GESTION!$B$88*E99/Tant.Lots.Fds!$H$36","v":58.5},{"$f":"$N$37","v":0}]
[null,null,null,null,null,"Le syndic"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"AUBERT!$C$8","v":20},{"$f":"AUBERT!$D$8","v":"1er Appel Travaux  Electricité"}]
[]
[null,"CLE","Designation",null,"V/Tantièmes",null,"V/Quote part"]
[null,1,"Charges Générales",null,{"$f":"SUMIF($B$12:$G$37,B90,$E$12:$E$37)","v":1170},null,{"$f":"SUMIF($B$12:$B$36,B90,$G$12:$G$36)","v":702}]
[null,2,"Ch.Bâtiment",null,138,null,{"$f":"SUMIF($B$12:$B$36,B91,$G$12:$G$36)","v":0}]
[null,3,"Ch.Escal.A",null,79,null,0]
[null,4,"Ch?Escal.B",null,194,null,0]
[null,5,"WW Commun",null,0,null,0]
[null,6,"Prov.Eau",null,0,null,0]
[null,7,"EAU Individuelle",null,0,null,0]
[null,8,null,null,0,null,0]
[null,null,null,null,null,null,{"$f":"SUM(G90:G97)","v":702}]
[null,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},null,{"$f":"SUMIF($B$12:$G$37,B99,$E$12:$E$37)","v":1170},null,{"$f":"SUMIF($B$12:$B$36,B99,$G$12:$G$36)","v":0}]
[null,12,"Avance de Trésorerie",null,{"$f":"SUMIF($B$12:$G$37,B100,$E$12:$E$37)","v":0},null,{"$f":"SUMIF($B$12:$B$36,B100,$G$12:$G$36)","v":0}]
[null,null,null,null,null,null,{"$f":"G98+G99+G100","v":702},{"$f":"G101+G38+G39-G40-G41","v":0}]
[]
[null,null,"Financement des travaux",null,null,null,{"$f":"G39","v":-549.90000000000009}]

{"sheet":"CARDON","index":6,"n_rows":103,"n_cols":15,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
[{"$f":"GESTION!A1","v":"Syndicat des Copropriétaires"}]
[{"$f":"GESTION!A2","v":"27 rue de PARIS"},null,null,null,null,null,{"$f":"Copropriétaires!$A$7","v":450.00200000000001},{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,3,FALSE)","v":"Mme CARDON Marie"}]
[{"$f":"GESTION!A3","v":"08200 LETROU"},null,null,null,null,null,null,{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,7,FALSE)","v":"27 rue de Paris"}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,10,FALSE)","v":"08200 LETROU"}]
[null,null,null,"Date d'avis:",{"$f":"GESTION!$D$4","v":"20/10/17"}]
[null,null,null,"Exigible",{"$f":"GESTION!$D$5","v":"01//12/17"}]
[]
["Lots ,41, 42, 43, 103",null,{"$f":"GESTION!$G$4","v":20},{"$f":"CONCATENATE(GESTION!$H$4,\" \",GESTION!$H$5)","v":"1er Appel Travaux  Electricité"}]
[null,"1189/10000",null,{"$f":"CONCATENATE(\"Exercice du \",GESTION!$E$1,\" \",GESTION!$F$1,\" au \",GESTION!$E$2,\" \",GESTION!$F$2)","v":"Exercice du 1er janvier 2017 au 31 décembre. 2017"},null,null,{"$f":"OR(GESTION!G4=8,GESTION!G4=16,GESTION!G4=24,GESTION!G4=32,GESTION!G4=36)","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"GESTION!$L$1","v":80},"%"]
["LOT","CLE","Designation","A répartir","V/Tantièmes","Tantièmes Gén.","V/Quote part","FONDS","Affectation","Fd Restant","TVA","Q.P. T.V.A"]
[41,null,{"$f":"VLOOKUP(A12,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Maison"},null,null,null,null,{"$f":"IF(G12<>0,ROUND(G12*D12/E12,2),\"\")","v":""}]
[41,1,{"$f":"VLOOKUP(B13,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B13,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A13,Tant.Lots.Fds!$A$5:$AB$35,B13+7)","v":940},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B13+7)","v":10000},{"$f":"ROUND(D13*E13/F13,2)","v":564},null,"","",{"$f":"IF(B13<>\"\",VLOOKUP(B13,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K13<>0,ROUND($K13*$E13/$F13,2),0)","v":0}]
[41,6,{"$f":"VLOOKUP(B14,GESTION!$A$12:$B$26,2)","v":"Provision Eau"},{"$f":"VLOOKUP(B14,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)","v":0},{"$f":"VLOOKUP(A14,Tant.Lots.Fds!$A$5:$Z$35,13,0)*(GESTION!$J$1=1)","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B14+7)","v":1},{"$f":"ROUND(D14*E14/F14,2)","v":0},null,null,null,{"$f":"IF(B14<>\"\",VLOOKUP(B14,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K14<>0,ROUND($K14*$E14/$F14,2),0)","v":0}]
[41,7,{"$f":"VLOOKUP(B15,GESTION!$A$12:$B$26,2)","v":"EAU Individuelle"},{"$f":"VLOOKUP(B15,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"VLOOKUP(A15,Tant.Lots.Fds!$A$5:$Z$35,14,0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B15+7)+(Tant.Lots.Fds!$N$36=0)","v":760},{"$f":"ROUND(D15*E15/F15,2)","v":0},null,null,null,{"$f":"IF(B15<>\"\",VLOOKUP(B15,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K15<>0,ROUND($K15*$E15/$F15,2),0)","v":0}]
[41,8,null,null,null,null,null,null,null,null,{"$f":"IF(B16<>\"\",VLOOKUP(B16,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K16<>0,ROUND($K16*$E16/$F16,2),0)","v":0}]
[41,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B17,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B17,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A17,Tant.Lots.Fds!$A$5:$AB$35,8)","v":940},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},{"$f":"ROUND(D17*E17/F17,2)","v":0}]
[41,null,null,null,null,null,{"$f":"SUM(G13:G17)","v":564},{"$f":"VLOOKUP(A18,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":441.8},{"$f":"IF(H18>ROUND(G18*$I$10/100,2),ROUND(G18*$I$10/100,2),H18)*-1*(G18>0)","v":-441.8},{"$f":"H18+I18","v":0},null,{"$f":"SUM(L13:L17)","v":0},null,{"$f":"VLOOKUP(A18,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A18,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[42,null,{"$f":"VLOOKUP(A19,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Remises -Auvent"}]
[42,1,{"$f":"VLOOKUP(B20,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B20,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A20,Tant.Lots.Fds!$A$5:$AB$35,B20+7)","v":100},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B20+7)","v":10000},{"$f":"ROUND(D20*E20/F20,2)","v":60},null,"","",{"$f":"IF(B20<>\"\",VLOOKUP(B20,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K20<>0,ROUND($K20*$E20/$F20,2),0)","v":0}]
[42,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B21,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B21,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A21,Tant.Lots.Fds!$A$5:$AB$35,8)","v":100},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},{"$f":"ROUND(D21*E21/F21,2)","v":0}]
[42,null,null,null,null,null,{"$f":"SUM(G20:G21)","v":60},{"$f":"VLOOKUP(A22,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":47},{"$f":"IF(H22>ROUND(G22*$I$10/100,2),ROUND(G22*$I$10/100,2),H22)*-1*(G22>0)","v":-47},{"$f":"H22+I22","v":0},null,{"$f":"SUM(L20:L21)","v":0},null,{"$f":"VLOOKUP(A22,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A22,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[43,null,{"$f":"VLOOKUP(A23,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Remise"}]
[43,1,{"$f":"VLOOKUP(B24,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B24,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A24,Tant.Lots.Fds!$A$5:$AB$35,B24+7)","v":20},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B24+7)","v":10000},{"$f":"ROUND(D24*E24/F24,2)","v":12},null,"","",{"$f":"IF(B24<>\"\",VLOOKUP(B24,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K24<>0,ROUND($K24*$E24/$F24,2),0)","v":0}]
[43,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B25,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B25,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A25,Tant.Lots.Fds!$A$5:$AB$35,8)","v":20},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},{"$f":"ROUND(D25*E25/F25,2)","v":0}]
[43,null,null,null,null,null,{"$f":"SUM(G24:G25)","v":12},{"$f":"VLOOKUP(A26,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":9.4},{"$f":"IF(H26>ROUND(G26*$I$10/100,2),ROUND(G26*$I$10/100,2),H26)*-1*(G26>0)","v":-9.4},{"$f":"H26+I26","v":0},null,{"$f":"SUM(L24:L25)","v":0},null,{"$f":"VLOOKUP(A26,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A26,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[103,null,{"$f":"VLOOKUP(A27,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Jardin privatrif"}]
[103,1,{"$f":"VLOOKUP(B28,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B28,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A28,Tant.Lots.Fds!$A$5:$AB$35,B28+7)","v":129},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B28+7)","v":10000},{"$f":"ROUND(D28*E28/F28,2)","v":77.400000000000006},null,"","",{"$f":"IF(B28<>\"\",VLOOKUP(B28,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K28<>0,ROUND($K28*$E28/$F28,2),0)","v":0}]
[103,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B29,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B29,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A29,Tant.Lots.Fds!$A$5:$AB$35,8)","v":129},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},{"$f":"ROUND(D29*E29/F29,2)","v":0}]
[103,null,null,null,null,null,{"$f":"SUM(G28:G29)","v":77.400000000000006},{"$f":"VLOOKUP(A30,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":60.63000000000001},{"$f":"IF(H30>ROUND(G30*$I$10/100,2),ROUND(G30*$I$10/100,2),H30)*-1*(G30>0)","v":-60.63000000000001},{"$f":"H30+I30","v":0},null,{"$f":"SUM(L28:L29)","v":0},null,{"$f":"VLOOKUP(A30,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A30,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[]
[]
[]
[]
[]
[1,12,"Avance Trésorerie",{"$f":"VLOOKUP(B36,GESTION!$A$12:'GESTION'!$AQ$25,GESTION!$G$4,0)*(GESTION!G4=40)","v":0},{"$f":"SUMIF(B12:E35,1,E12:E35)*(GESTION!G4=40)","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)*(GESTION!$G$4=40)","v":0},{"$f":"ROUND(D36*E36/10000,2)","v":0}]
[null,null,null,null,null,"TOTAL",{"$f":"(SUM(G12:G35)/2)+G36","v":713.40000000000009},{"$f":"SUM(H12:H36)","v":558.83000000000004},{"$f":"SUM(I12:I36)","v":-558.83000000000004},{"$f":"SUM(J12:J36)","v":0},null,{"$f":"SUM(L12:L36)/2","v":0},null,{"$f":"SUM(N13:N36)","v":0}]
[null,null,null,null,"Provisions",null,{"$f":"SUM(K38:N38)*-1","v":0},null,null,null,{"$f":"IF(GESTION!$G$4=8,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=16,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=24,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=32,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""}]
[null,null,null,null,"Financement Fonds Travaux",null,{"$f":"I37","v":-558.83000000000004},null,null,null,8,16,24,32,{"$f":"VLOOKUP($D$2,GESTION!$A$63:'GESTION'!$AN$82,GESTION!$G$4-1)*(GESTION!$J$1<>2)","v":{"$error":"#N/A"}}]
[null,null,null,"SOLDE en votre faveur…………………..",null,null,{"$f":"IF(AND(H$4<>36,G37+G38+G39<0),G37+G38+G39,0)","v":0},null,null,null,{"$f":"GESTION!$G$4","v":20},{"$f":"GESTION!$H$4","v":"1er Appel Travaux "}]
[null,null,null,"SOLDE dû au syndicat…………….",null,null,{"$f":"IF(AND($G$4<>36,G37+G38+G39>0),G37+G38+G39,0)","v":154.57000000000005}]
[null,null,null,null,null,null,null,null,{"$f":"IF(L37>0,\"Dont T.V.A.\",\"\")","v":""},{"$f":"IF(L37<>0,L37,\"\")","v":""}]
[null,null,null,"RELEVE DE COMPTE",null,null,null,null,{"$f":"IF(M6<>0,#REF!,\"\")","v":""},null,null,"La zône grisée n' est pas destinée"]
[null,null,null,null,null,null,null,null,{"$f":"IF(M6<>0,#REF!,\"\")","v":""},null,null,"a être imprimée et diffusée."]
[null,null,"Dates","Libellés des operations",null,"DEBIT","CREDIT"]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F46:F48)","v":0},{"$f":"SUM(G46:G48)","v":0}]
[null,null,{"$f":"IF(GESTION!$G$4<>36,E6,\"\")","v":"01//12/17"},{"$f":"IF(GESTION!$G$4<>36,D8,\"\")","v":"1er Appel Travaux  Electricité"},null,{"$f":"G41","v":154.57000000000005},{"$f":"IF(G40>0,G40,G40*-1)","v":0}]
[null,null,null,null,null,{"$f":"SUM(F49:F50)","v":154.57000000000005},{"$f":"SUM(G49:G50)","v":0}]
[null,null,null,null,{"$f":"IF(F52<G52,\"Montant à Payer\",\"Montant à votre crédit\")","v":"Montant à Payer"},{"$f":"IF((F51-G51)>0,F51-G51,\"\")","v":154.57000000000005},{"$f":"IF((G51-F51)>0,G51-F51,\"\")","v":""}]
[]
[null,null,"Avance Trésorerie","Av.Travaux","Fds Travaux ",{"$f":"IF($F$52<$G$52,\"Règlement à faire à l'ordre du Syndicat des Copropriétaires.\",\"\")","v":"Règlement à faire à l'ordre du Syndicat des Copropriétaires."}]
[null,null,{"$f":"VLOOKUP($G2,GESTION!$A$63:$C$82,3,FALSE)","v":118.9},{"$f":"GESTION!$B$88*E99/Tant.Lots.Fds!$H$36","v":59.45},{"$f":"$N$37","v":0}]
[null,null,null,null,null,"Le syndic"]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF($E$59<$F$59,\"Règlement à faire à l'ordre du Syndicat des Copropriétaires.\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"AUBERT!$C$8","v":20},{"$f":"AUBERT!$D$8","v":"1er Appel Travaux  Electricité"}]
[]
[null,"CLE","Designation",null,"V/Tantièmes",null,"V/Quote part"]
[null,1,"Charges Générales",null,{"$f":"SUMIF($B$12:$G$37,B90,$E$12:$E$37)","v":1189},null,{"$f":"SUMIF($B$12:$B$36,B90,$G$12:$G$36)","v":713.4}]
[null,2,"Ch.Bâtiment",null,{"$f":"SUMIF($B$12:$G$37,B91,$E$12:$E$37)","v":0},null,{"$f":"SUMIF($B$12:$B$36,B91,$G$12:$G$36)","v":0}]
[null,3,"Ch.Escal.A",null,0,null,0]
[null,4,"Ch?Escal.B",null,0,null,0]
[null,5,"WW Commun",null,0,null,0]
[null,6,"Prov.Eau",null,0,null,0]
[null,7,"Cons.Eau",null,0,null,0]
[null,8,null,null,0,null,0]
[null,null,null,null,null,null,{"$f":"SUM(G90:G97)","v":713.4}]
[null,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},null,{"$f":"SUMIF($B$12:$G$37,B99,$E$12:$E$37)","v":1189},null,{"$f":"SUMIF($B$12:$B$36,B99,$G$12:$G$36)","v":0}]
[null,12,"Avance de Trésorerie",null,{"$f":"SUMIF($B$12:$G$37,B100,$E$12:$E$37)","v":0},null,{"$f":"SUMIF($B$12:$B$36,B100,$G$12:$G$36)","v":0}]
[null,null,null,null,null,null,{"$f":"G98+G99+G100","v":713.4},{"$f":"G101+G38+G39-G40-G41","v":0}]
[]
[null,null,"Financement des travaux",null,null,null,{"$f":"G39","v":-558.83000000000004}]

{"sheet":"DUBOIS","index":7,"n_rows":103,"n_cols":14,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
[{"$f":"GESTION!A1","v":"Syndicat des Copropriétaires"}]
[{"$f":"GESTION!A2","v":"27 rue de PARIS"},null,null,null,null,null,{"$f":"Copropriétaires!$A$8","v":450.00299999999999},{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,3,FALSE)","v":"Mr DUBOIS"}]
[{"$f":"GESTION!A3","v":"08200 LETROU"},null,null,null,null,null,null,{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,7,FALSE)","v":"5 rue de Rennes"}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,10,FALSE)","v":"77150 Lésigny"}]
[null,null,null,"Date d'avis:",{"$f":"GESTION!$D$4","v":"20/10/17"}]
[null,null,null,"Exigible",{"$f":"GESTION!$D$5","v":"01//12/17"}]
[]
["Lots 13, 18, 19, 23,",null,{"$f":"GESTION!$G$4","v":20},{"$f":"CONCATENATE(GESTION!$H$4,\" \",GESTION!$H$5)","v":"1er Appel Travaux  Electricité"}]
[null,"1950/10,000",null,{"$f":"CONCATENATE(\"Exercice du \",GESTION!$E$1,\" \",GESTION!$F$1,\" au \",GESTION!$E$2,\" \",GESTION!$F$2)","v":"Exercice du 1er janvier 2017 au 31 décembre. 2017"},null,null,null,{"$f":"OR(GESTION!G4=8,GESTION!G4=16,GESTION!G4=24,GESTION!G4=32,GESTION!G4=36)","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"GESTION!$L$1","v":80},"%"]
["LOT","CLE","Designation","A répartir","V/Tantièmes","Tantièmes Gén.","V/Quote part","FONDS","Affectation","Fd Restant","T.VA.","Q.P. T.V.A"]
[13,null,{"$f":"VLOOKUP(A12,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Cave N° 3"},null,null,null,null,null,{"$f":"IF(H12<>0,ROUND(H12*E12/F12,2),\"\")","v":""}]
[13,1,{"$f":"VLOOKUP(B13,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B13,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A13,Tant.Lots.Fds!$A$5:$AB$35,B13+7)","v":230},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B13+7)","v":10000},{"$f":"ROUND(D13*E13/F13,2)","v":138},null,"","",{"$f":"IF(B13<>\"\",VLOOKUP(B13,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K13<>0,ROUND($K13*$E13/$F13,2),0)","v":0}]
[13,2,{"$f":"VLOOKUP(B14,GESTION!$A$12:$B$26,2)","v":"Ch.Bât."},{"$f":"VLOOKUP(B14,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A14,Tant.Lots.Fds!$A$5:$AB$35,B14+7)","v":27},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B14+7)","v":1000},{"$f":"ROUND(D14*E14/F14,2)","v":0},null,"","",{"$f":"IF(B14<>\"\",VLOOKUP(B14,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K14<>0,ROUND($K14*$E14/$F14,2),0)","v":0}]
[13,3,{"$f":"VLOOKUP(B15,GESTION!$A$12:$B$26,2)","v":"Ch.Escal.A"},{"$f":"VLOOKUP(B15,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A15,Tant.Lots.Fds!$A$5:$AB$35,B15+7)","v":429},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B15+7)","v":1000},{"$f":"ROUND(D15*E15/F15,2)","v":0},null,"","",{"$f":"IF(B15<>\"\",VLOOKUP(B15,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K15<>0,ROUND($K15*$E15/$F15,2),0)","v":0}]
[13,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B16,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B16,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A16,Tant.Lots.Fds!$A$5:$AB$35,8)","v":230},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},{"$f":"ROUND(D16*E16/F16,2)","v":0},null,null,null,null,{"$f":"IF(J16<>0,ROUND(J16*D16/E16,2),\"\")","v":""}]
[13,null,null,null,null,null,{"$f":"SUM(G13:G16)","v":138},{"$f":"VLOOKUP(A17,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":108.1},{"$f":"IF(H17>ROUND(G17*$I$10/100,2),ROUND(G17*$I$10/100,2),H17)*-1*(G17>0)","v":-108.1},{"$f":"H17+I17","v":0},null,{"$f":"SUM(L13:L16)","v":0},null,{"$f":"VLOOKUP(A17,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A17,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[18,null,{"$f":"VLOOKUP(A18,Tant.Lots.Fds!$A$5:$B$35,2)","v":"W.C."}]
[18,1,{"$f":"VLOOKUP(B19,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B19,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A19,Tant.Lots.Fds!$A$5:$AB$35,B19+7)","v":30},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B19+7)","v":10000},{"$f":"ROUND(D19*E19/F19,2)","v":18},null,"","",{"$f":"IF(B19<>\"\",VLOOKUP(B19,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K19<>0,ROUND($K19*$E19/$F19,2),0)","v":0}]
[18,2,{"$f":"VLOOKUP(B20,GESTION!$A$12:$B$26,2)","v":"Ch.Bât."},{"$f":"VLOOKUP(B20,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A20,Tant.Lots.Fds!$A$5:$AB$35,B20+7)","v":4},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B20+7)","v":1000},{"$f":"ROUND(D20*E20/F20,2)","v":0},null,"","",{"$f":"IF(B20<>\"\",VLOOKUP(B20,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K20<>0,ROUND($K20*$E20/$F20,2),0)","v":0}]
[18,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B21,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A21,Tant.Lots.Fds!$A$5:$AB$35,8)","v":30},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},{"$f":"ROUND(D21*E21/F21,2)","v":0}]
[18,null,null,null,null,null,{"$f":"SUM(G19:G21)","v":18},{"$f":"VLOOKUP(A22,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":14.1},{"$f":"IF(H22>ROUND(G22*$I$10/100,2),ROUND(G22*$I$10/100,2),H22)*-1*(G22>0)","v":-14.1},{"$f":"H22+I22","v":0},null,{"$f":"SUM(L19:L21)","v":0},null,{"$f":"VLOOKUP(A22,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A22,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[19,null,{"$f":"VLOOKUP(A23,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Commerce"},null,null,null,null,null,{"$f":"IF(H23<>0,ROUND(H23*E23/F23,2),\"\")","v":""}]
[19,1,{"$f":"VLOOKUP(B24,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B24,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A24,Tant.Lots.Fds!$A$5:$AB$35,B24+7)","v":910},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B24+7)","v":10000},{"$f":"ROUND(D24*E24/F24,2)","v":546},null,"","",{"$f":"IF(B24<>\"\",VLOOKUP(B24,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K24<>0,ROUND($K24*$E24/$F24,2),0)","v":0}]
[19,2,{"$f":"VLOOKUP(B25,GESTION!$A$12:$B$26,2)","v":"Ch.Bât."},{"$f":"VLOOKUP(B25,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A25,Tant.Lots.Fds!$A$5:$AB$35,B25+7)","v":107},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B25+7)","v":1000},{"$f":"ROUND(D25*E25/F25,2)","v":0},null,"","",{"$f":"IF(B25<>\"\",VLOOKUP(B25,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K25<>0,ROUND($K25*$E25/$F25,2),0)","v":0}]
[19,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B26,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B26,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A26,Tant.Lots.Fds!$A$5:$AB$35,8)","v":910},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},{"$f":"ROUND(D26*E26/F26,2)","v":0},null,null,null,null,{"$f":"IF(J26<>0,ROUND(J26*D26/E26,2),\"\")","v":""}]
[19,null,null,null,null,null,{"$f":"SUM(G24:G26)","v":546},{"$f":"VLOOKUP(A27,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":427.7},{"$f":"IF(H27>ROUND(G27*$I$10/100,2),ROUND(G27*$I$10/100,2),H27)*-1*(G27>0)","v":-427.7},{"$f":"H27+I27","v":0},null,{"$f":"SUM(L24:L26)","v":0},null,{"$f":"VLOOKUP(A27,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A27,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[23,null,{"$f":"VLOOKUP(A28,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Appartement"}]
[23,1,{"$f":"VLOOKUP(B29,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B29,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A29,Tant.Lots.Fds!$A$5:$AB$35,B29+7)","v":780},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B29+7)","v":10000},{"$f":"ROUND(D29*E29/F29,2)","v":468},null,"","",{"$f":"IF(B29<>\"\",VLOOKUP(B29,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K29<>0,ROUND($K29*$E29/$F29,2),0)","v":0}]
[23,2,{"$f":"VLOOKUP(B30,GESTION!$A$12:$B$26,2)","v":"Ch.Bât."},{"$f":"VLOOKUP(B30,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A30,Tant.Lots.Fds!$A$5:$AB$35,B30+7)","v":92},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B30+7)","v":1000},{"$f":"ROUND(D30*E30/F30,2)","v":0},null,"","",{"$f":"IF(B30<>\"\",VLOOKUP(B30,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K30<>0,ROUND($K30*$E30/$F30,2),0)","v":0}]
[23,4,{"$f":"VLOOKUP(B31,GESTION!$A$12:$B$26,2)","v":"Ch Escal B"},{"$f":"VLOOKUP(B31,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A31,Tant.Lots.Fds!$A$5:$AB$35,B31+7)","v":128},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B31+7)","v":1000},{"$f":"ROUND(D31*E31/F31,2)","v":0},null,null,null,{"$f":"IF(B31<>\"\",VLOOKUP(B31,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K31<>0,ROUND($K31*$E31/$F31,2),0)","v":0}]
[23,5,{"$f":"VLOOKUP(B32,GESTION!$A$12:$B$26,2)","v":"WC"},{"$f":"VLOOKUP(B32,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A32,Tant.Lots.Fds!$A$5:$AB$35,B32+7)","v":414},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B32+7)","v":1000},{"$f":"ROUND(D32*E32/F32,2)","v":0},null,null,null,{"$f":"IF(B32<>\"\",VLOOKUP(B32,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K32<>0,ROUND($K32*$E32/$F32,2),0)","v":0}]
[]
[23,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B34,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B34,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A34,Tant.Lots.Fds!$A$5:$AB$35,8)","v":780},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},{"$f":"ROUND(D34*E34/F34,2)","v":0},null,null,null,null,{"$f":"IF(J34<>0,ROUND(J34*D34/E34,2),\"\")","v":""}]
[23,null,null,null,null,null,{"$f":"SUM(G29:G34)","v":468},{"$f":"VLOOKUP(A35,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":366.6},{"$f":"IF(H35>ROUND(G35*$I$10/100,2),ROUND(G35*$I$10/100,2),H35)*-1*(G35>0)","v":-366.6},{"$f":"H35+I35","v":0},null,{"$f":"SUM(L29:L34)","v":0},null,{"$f":"VLOOKUP(A35,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A35,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[1,12,"Avance Trésorerie",{"$f":"VLOOKUP(B36,GESTION!$A$12:'GESTION'!$AQ$25,GESTION!$G$4,0)*(GESTION!G4=40)","v":0},{"$f":"SUMIF(B12:E35,1,E12:E35)*(GESTION!G4=40)","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)*(GESTION!$G$4=40)","v":0},{"$f":"ROUND(D36*E36/10000,2)","v":0},null,{"$f":"IF(H36<>0,ROUND(H36*E36/F36,2),\"\")","v":""}]
[null,null,null,null,null,"TOTAL………….",{"$f":"(SUM(G12:G35)/2)+G36","v":1170},{"$f":"SUM(H12:H36)","v":916.5},{"$f":"SUM(I12:I36)","v":-916.5},{"$f":"SUM(J12:J36)","v":0},null,{"$f":"SUM(L12:L36)/2","v":0},null,{"$f":"SUM(N13:N36)","v":0}]
[null,null,null,null,"Provisions",null,{"$f":"SUM(K38:N38)*-1","v":0},null,null,null,{"$f":"IF(GESTION!$G$4=8,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=16,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=24,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=32,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""}]
[null,null,null,null,"Financement Fonds Travaux",null,{"$f":"I37","v":-916.5},null,null,null,8,16,24,32]
[null,null,null,"SOLDE en votre faveur…………………..",null,null,{"$f":"IF(AND(H$4<>36,G37+G38+G39<0),G37+G38+G39,0)","v":0},null,null,null,{"$f":"GESTION!$G$4","v":20},{"$f":"GESTION!$H$4","v":"1er Appel Travaux "}]
[null,null,null,"SOLDE dû au syndicat…………….",null,null,{"$f":"IF(AND($G$4<>36,G37+G38+G39>0),G37+G38+G39,0)","v":253.5}]
[null,null,null,null,null,null,null,null,{"$f":"IF(L37>0,\"Dont T.V.A.\",\"\")","v":""},{"$f":"IF(L37<>0,L37,\"\")","v":""}]
[null,null,null,"RELEVE DE COMPTE",null,null,null,{"$f":"IF(M37<>0,\"Dont TVA\",\"\")","v":""},{"$f":"IF(M12<>0,M37,\"\")","v":""},null,null,"La zône grisée n' est pas destinée"]
[null,null,null,null,null,null,null,{"$f":"IF(N37<>0,\"TVAs/Ch.Loc\",\"\")","v":""},{"$f":"IF(M12<>0,N37,\"\")","v":""},null,null,"a être imprimée et diffusée."]
[null,null,"Dates","Libellés des operations",null,"DEBIT","CREDIT"]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F46:F48)","v":0},{"$f":"SUM(G46:G48)","v":0}]
[null,null,{"$f":"IF(GESTION!$G$4<>36,E6,\"\")","v":"01//12/17"},{"$f":"IF(GESTION!$G$4<>36,D8,\"\")","v":"1er Appel Travaux  Electricité"},null,{"$f":"G41","v":253.5},{"$f":"IF(G40>0,G40,G40*-1)","v":0}]
[null,null,null,null,null,{"$f":"SUM(F49:F50)","v":253.5},{"$f":"SUM(G49:G50)","v":0}]
[null,null,null,null,{"$f":"IF(F52<G52,\"Montant à Payer\",\"Montant à votre crédit\")","v":"Montant à Payer"},{"$f":"IF((F51-G51)>0,F51-G51,\"\")","v":253.5},{"$f":"IF((G51-F51)>0,G51-F51,\"\")","v":""}]
[]
[null,null,"Avance Trésorerie","Av.Travaux","Fds Travaux ",{"$f":"IF($F$52<$G$52,\"Règlement à faire à l'ordre du Syndicat des Copropriétaires.\",\"\")","v":"Règlement à faire à l'ordre du Syndicat des Copropriétaires."}]
[null,null,{"$f":"VLOOKUP($G2,GESTION!$A$63:$C$82,3,FALSE)","v":195},{"$f":"GESTION!$B$88*E99/Tant.Lots.Fds!$H$36","v":97.5},{"$f":"$N$37","v":0}]
[null,null,null,null,null,"Le syndic"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"AUBERT!$C$8","v":20},{"$f":"AUBERT!$D$8","v":"1er Appel Travaux  Electricité"}]
[]
[null,"CLE","Designation",null,"V/Tantièmes",null,"V/Quote part"]
[null,1,"Charges Générales",null,{"$f":"SUMIF($B$12:$G$37,B90,$E$12:$E$37)","v":1950},null,{"$f":"SUMIF($B$12:$B$36,B90,$G$12:$G$36)","v":1170}]
[null,2,"Ch.Bâtiment",null,230,null,{"$f":"SUMIF($B$12:$B$36,B91,$G$12:$G$36)","v":0}]
[null,3,"Ch.Escal.A",null,429,null,0]
[null,4,"Ch?Escal.B",null,128,null,0]
[null,5,"WW Commun",null,414,null,0]
[null,6,"Prov.Eau",null,0,null,0]
[null,7,"Cons,Eau",null,0,null,0]
[null,8,null,null,0,null,0]
[null,null,null,null,null,null,{"$f":"SUM(G90:G97)","v":1170}]
[null,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},null,{"$f":"SUMIF($B$12:$G$37,B99,$E$12:$E$37)","v":1950},null,{"$f":"SUMIF($B$12:$B$36,B99,$G$12:$G$36)","v":0}]
[null,12,"Avance de Trésorerie",null,{"$f":"SUMIF($B$12:$G$37,B100,$E$12:$E$37)","v":0},null,{"$f":"SUMIF($B$12:$B$36,B100,$G$12:$G$36)","v":0}]
[null,null,null,null,null,null,{"$f":"G98+G99+G100","v":1170},{"$f":"G101+G38+G39-G40-G41","v":0}]
[]
[null,null,"Financement des travaux",null,null,null,{"$f":"G39","v":-916.5}]

{"sheet":"FONTAINE","index":8,"n_rows":103,"n_cols":17,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
[{"$f":"GESTION!A1","v":"Syndicat des Copropriétaires"}]
[{"$f":"GESTION!A2","v":"27 rue de PARIS"},null,null,null,null,null,450.005,{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,3,FALSE)","v":"Mme FONTAINE"}]
[{"$f":"GESTION!A3","v":"08200 LETROU"},null,null,null,null,null,null,{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,7,FALSE)","v":"10 rue de la Paix"}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,10,FALSE)","v":"85340 Olonne sur Mer"}]
[null,null,null,"Date d'avis:",{"$f":"GESTION!$D$4","v":"20/10/17"}]
[null,null,null,"Exigible",{"$f":"GESTION!$D$5","v":"01//12/17"}]
[]
["Lots 12, 14, 17 ,21, 22",null,{"$f":"GESTION!$G$4","v":20},{"$f":"CONCATENATE(GESTION!$H$4,\" \",GESTION!$H$5)","v":"1er Appel Travaux  Electricité"}]
["24, 27","2060/10000",null,{"$f":"CONCATENATE(\"Exercice du \",GESTION!$E$1,\" \",GESTION!$F$1,\" au \",GESTION!$E$2,\" \",GESTION!$F$2)","v":"Exercice du 1er janvier 2017 au 31 décembre. 2017"},null,null,{"$f":"OR(GESTION!G4=8,GESTION!G4=16,GESTION!G4=24,GESTION!G4=32,GESTION!G4=36)","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"GESTION!$L$1","v":80},"%"]
["LOT","CLE","Designation","A répartir","V/Tantièmes","Tantièmes Gén.","V/Quote part","FONDS","Affectation","Fd Restant","TVA","Q.P. T.V.A"]
[12,null,{"$f":"VLOOKUP(A12,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Cave N° 2"},null,null,null,"",null,"",""]
[12,1,{"$f":"VLOOKUP(B13,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B13,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A13,Tant.Lots.Fds!$A$5:$AB$35,B13+7)","v":40},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B13+7)","v":10000},{"$f":"ROUND(D13*E13/F13,2)","v":24},null,"","",{"$f":"IF(B13<>\"\",VLOOKUP(B13,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K13<>0,ROUND($K13*$E13/$F13,2),0)","v":0}]
[12,2,{"$f":"VLOOKUP(B14,GESTION!$A$12:$B$26,2)","v":"Ch.Bât."},{"$f":"VLOOKUP(B14,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A14,Tant.Lots.Fds!$A$5:$AB$35,B14+7)","v":5},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B14+7)","v":1000},{"$f":"ROUND(D14*E14/F14,2)","v":0},null,"","",{"$f":"IF(B14<>\"\",VLOOKUP(B14,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K14<>0,ROUND($K14*$E14/$F14,2),0)","v":0}]
[12,3,{"$f":"VLOOKUP(B15,GESTION!$A$12:$B$26,2)","v":"Ch.Escal.A"},{"$f":"VLOOKUP(B15,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A15,Tant.Lots.Fds!$A$5:$AB$35,B15+7)","v":79},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B15+7)","v":1000},{"$f":"ROUND(D15*E15/F15,2)","v":0},null,"","",{"$f":"IF(B15<>\"\",VLOOKUP(B15,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K15<>0,ROUND($K15*$E15/$F15,2),0)","v":0}]
[12,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B16,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B16,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A16,Tant.Lots.Fds!$A$5:$AB$35,8)","v":40},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},{"$f":"ROUND(D16*E16/F16,2)","v":0},null,null,null,null,{"$f":"IF(J16<>0,ROUND(J16*D16/E16,2),\"\")","v":""}]
[12,null,null,null,null,null,{"$f":"SUM(G13:G16)","v":24},{"$f":"VLOOKUP(A17,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":18.8},{"$f":"IF(H17>ROUND(G17*$I$10/100,2),ROUND(G17*$I$10/100,2),H17)*-1*(G17>0)","v":-18.8},{"$f":"H17+I17","v":0},null,{"$f":"SUM(L13:L16)","v":0},null,{"$f":"VLOOKUP(A17,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A17,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[]
[]
[]
[]
[]
[]
[17,null,{"$f":"VLOOKUP(A24,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Cave N° 7"}]
[17,1,{"$f":"VLOOKUP(B25,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B25,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A25,Tant.Lots.Fds!$A$5:$AB$35,B25+7)","v":40},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B25+7)","v":10000},{"$f":"ROUND(D25*E25/F25,2)","v":24},null,"","",{"$f":"IF(B25<>\"\",VLOOKUP(B25,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K25<>0,ROUND($K25*$E25/$F25,2),0)","v":0}]
[17,2,{"$f":"VLOOKUP(B26,GESTION!$A$12:$B$26,2)","v":"Ch.Bât."},{"$f":"VLOOKUP(B26,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A26,Tant.Lots.Fds!$A$5:$AB$35,B26+7)","v":5},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B26+7)","v":1000},{"$f":"ROUND(D26*E26/F26,2)","v":0},null,"","",{"$f":"IF(B26<>\"\",VLOOKUP(B26,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K26<>0,ROUND($K26*$E26/$F26,2),0)","v":0}]
[17,3,{"$f":"VLOOKUP(B27,GESTION!$A$12:$B$26,2)","v":"Ch.Escal.A"},{"$f":"VLOOKUP(B27,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A27,Tant.Lots.Fds!$A$5:$AB$35,B27+7)","v":79},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B27+7)","v":1000},{"$f":"ROUND(D27*E27/F27,2)","v":0},null,"","",{"$f":"IF(B27<>\"\",VLOOKUP(B27,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K27<>0,ROUND($K27*$E27/$F27,2),0)","v":0}]
[17,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B28,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B28,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A28,Tant.Lots.Fds!$A$5:$AB$35,8)","v":40},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},{"$f":"ROUND(D28*E28/F28,2)","v":0},null,null,null,null,{"$f":"IF(J28<>0,ROUND(J28*D28/E28,2),\"\")","v":""}]
[17,null,null,null,null,null,{"$f":"SUM(G25:G28)","v":24},{"$f":"VLOOKUP(A29,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":18.8},{"$f":"IF(H29>ROUND(G29*$I$10/100,2),ROUND(G29*$I$10/100,2),H29)*-1*(G29>0)","v":-18.8},{"$f":"H29+I29","v":0},null,{"$f":"SUM(L25:L28)","v":0},null,{"$f":"VLOOKUP(A29,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A29,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[21,null,{"$f":"VLOOKUP(A30,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Appartement"}]
[21,1,{"$f":"VLOOKUP(B31,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B31,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A31,Tant.Lots.Fds!$A$5:$AB$35,B31+7)","v":760},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B31+7)","v":10000},{"$f":"ROUND(D31*E31/F31,2)","v":456},null,"","",{"$f":"IF(B31<>\"\",VLOOKUP(B31,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K31<>0,ROUND($K31*$E31/$F31,2),0)","v":0}]
[21,2,{"$f":"VLOOKUP(B32,GESTION!$A$12:$B$26,2)","v":"Ch.Bât."},{"$f":"VLOOKUP(B32,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A32,Tant.Lots.Fds!$A$5:$AB$35,B32+7)","v":89},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B32+7)","v":1000},0,null,"","",{"$f":"IF(B32<>\"\",VLOOKUP(B32,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K32<>0,ROUND($K32*$E32/$F32,2),0)","v":0}]
[21,4,{"$f":"VLOOKUP(B33,GESTION!$A$12:$B$26,2)","v":"Ch Escal B"},{"$f":"VLOOKUP(B33,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A33,Tant.Lots.Fds!$A$5:$AB$35,B33+7)","v":124},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B33+7)","v":1000},0,null,null,null,{"$f":"IF(B33<>\"\",VLOOKUP(B33,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[21,5,"Wc Commun",{"$f":"VLOOKUP(B34,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A34,Tant.Lots.Fds!$A$5:$AB$35,B34+7)","v":401},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B34+7)","v":1000},0,null,null,null,{"$f":"IF(B34<>\"\",VLOOKUP(B34,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[21,6,{"$f":"VLOOKUP(B35,GESTION!$A$12:$B$26,2)","v":"Provision Eau"},{"$f":"VLOOKUP(B35,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)","v":0},{"$f":"VLOOKUP(A35,Tant.Lots.Fds!$A$5:$Z$35,13,0)*(GESTION!$J$1=1)","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B35+7)","v":1},0,null,null,null,{"$f":"IF(B35<>\"\",VLOOKUP(B35,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[21,7,{"$f":"VLOOKUP(B36,GESTION!$A$12:$B$26,2)","v":"EAU Individuelle"},{"$f":"VLOOKUP(B36,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"VLOOKUP(A36,Tant.Lots.Fds!$A$5:$Z$35,14,0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B36+7)+(Tant.Lots.Fds!$N$36=0)","v":760},0,null,null,null,{"$f":"IF(B36<>\"\",VLOOKUP(B36,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[21,8,null,null,null,null,null,null,null,null,{"$f":"IF(B37<>\"\",VLOOKUP(B37,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[21,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B38,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B38,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A38,Tant.Lots.Fds!$A$5:$AB$35,8)","v":760},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},0,null,null,null,null,{"$f":"IF(J38<>0,ROUND(J38*D38/E38,2),\"\")","v":""}]
[21,null,null,null,null,null,{"$f":"SUM(G31:G38)","v":456},{"$f":"VLOOKUP(A39,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":357.2},{"$f":"IF(H39>ROUND(G39*$I$10/100,2),ROUND(G39*$I$10/100,2),H39)*-1*(G39>0)","v":-357.2},{"$f":"H39+I39","v":0},null,{"$f":"SUM(L31:L38)","v":0},null,{"$f":"VLOOKUP(A39,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A39,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[24,null,{"$f":"VLOOKUP(A50,Tant.Lots.Fds!$A$5:$B$35,2)","v":"W.C."}]
[24,1,{"$f":"VLOOKUP(B51,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B51,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A51,Tant.Lots.Fds!$A$5:$AB$35,B51+7)","v":30},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B51+7)","v":10000},{"$f":"ROUND(D51*E51/F51,2)","v":18},null,"","",{"$f":"IF(B51<>\"\",VLOOKUP(B51,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K51<>0,ROUND($K51*$E51/$F51,2),0)","v":0}]
[24,2,{"$f":"VLOOKUP(B52,GESTION!$A$12:$B$26,2)","v":"Ch.Bât."},{"$f":"VLOOKUP(B52,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A52,Tant.Lots.Fds!$A$5:$AB$35,B52+7)","v":4},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B52+7)","v":1000},{"$f":"ROUND(D52*E52/F52,2)","v":0},null,"","",{"$f":"IF(B52<>\"\",VLOOKUP(B52,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K52<>0,ROUND($K52*$E52/$F52,2),0)","v":0}]
[24,4,{"$f":"VLOOKUP(B53,GESTION!$A$12:$B$26,2)","v":"Ch Escal B"},{"$f":"VLOOKUP(B53,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A53,Tant.Lots.Fds!$A$5:$AB$35,B53+7)","v":5},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B53+7)","v":1000},{"$f":"ROUND(D53*E53/F53,2)","v":0},null,null,null,{"$f":"IF(B53<>\"\",VLOOKUP(B53,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K53<>0,ROUND($K53*$E53/$F53,2),0)","v":0}]
[24,8,null,null,null,null,null,null,null,null,{"$f":"IF(B54<>\"\",VLOOKUP(B54,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K54<>0,ROUND($K54*$E54/$F54,2),0)","v":0}]
[24,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B55,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B55,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A55,Tant.Lots.Fds!$A$5:$AB$35,8)","v":30},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},{"$f":"ROUND(D55*E55/F55,2)","v":0},null,null,null,null,{"$f":"IF(J55<>0,ROUND(J55*D55/E55,2),\"\")","v":""}]
[24,null,null,null,null,null,{"$f":"SUM(G51:G55)","v":18},{"$f":"VLOOKUP(A56,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":14.1},{"$f":"IF(H56>ROUND(G56*$I$10/100,2),ROUND(G56*$I$10/100,2),H56)*-1*(G56>0)","v":-14.1},{"$f":"H56+I56","v":0},null,{"$f":"SUM(L51:L55)","v":0},null,{"$f":"VLOOKUP(A56,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A56,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[27,null,{"$f":"VLOOKUP(A57,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Appartement"}]
[27,1,{"$f":"VLOOKUP(B58,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B58,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A58,Tant.Lots.Fds!$A$5:$AB$35,B58+7)","v":810},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B58+7)","v":10000},{"$f":"ROUND(D58*E58/F58,2)","v":486},null,"","",{"$f":"IF(B58<>\"\",VLOOKUP(B58,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K58<>0,ROUND($K58*$E58/$F58,2),0)","v":0}]
[27,2,{"$f":"VLOOKUP(B59,GESTION!$A$12:$B$26,2)","v":"Ch.Bât."},{"$f":"VLOOKUP(B59,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A59,Tant.Lots.Fds!$A$5:$AB$35,B59+7)","v":95},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B59+7)","v":1000},{"$f":"ROUND(D59*E59/F59,2)","v":0},null,"","",{"$f":"IF(B59<>\"\",VLOOKUP(B59,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[27,4,{"$f":"VLOOKUP(B60,GESTION!$A$12:$B$26,2)","v":"Ch Escal B"},{"$f":"VLOOKUP(B60,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A60,Tant.Lots.Fds!$A$5:$AB$35,B60+7)","v":139},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B60+7)","v":1000},0,null,null,null,{"$f":"IF(B60<>\"\",VLOOKUP(B60,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[27,6,{"$f":"VLOOKUP(B61,GESTION!$A$12:$B$26,2)","v":"Provision Eau"},{"$f":"VLOOKUP(B61,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)","v":0},{"$f":"VLOOKUP(A61,Tant.Lots.Fds!$A$5:$Z$35,13,0)*(GESTION!$J$1=1)","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B61+7)","v":1},0,null,null,null,{"$f":"IF(B61<>\"\",VLOOKUP(B61,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[27,7,{"$f":"VLOOKUP(B62,GESTION!$A$12:$B$26,2)","v":"EAU Individuelle"},{"$f":"VLOOKUP(B62,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"VLOOKUP(A62,Tant.Lots.Fds!$A$5:$Z$35,14,0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B62+7)+(Tant.Lots.Fds!$N$36=0)","v":760},0,null,null,null,{"$f":"IF(B62<>\"\",VLOOKUP(B62,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[27,8,null,null,null,null,null,null,null,null,{"$f":"IF(B63<>\"\",VLOOKUP(B63,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[27,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B64,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B64,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A64,Tant.Lots.Fds!$A$5:$AB$35,8)","v":810},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},0,null,null,null,null,{"$f":"IF(J64<>0,ROUND(J64*D64/E64,2),\"\")","v":""}]
[27,null,null,null,null,null,{"$f":"SUM(G58:G64)","v":486},{"$f":"VLOOKUP(A65,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":380.7},{"$f":"IF(H65>ROUND(G65*$I$10/100,2),ROUND(G65*$I$10/100,2),H65)*-1*(G65>0)","v":-380.7},{"$f":"H65+I65","v":0},null,{"$f":"SUM(L58:L64)","v":0},null,{"$f":"VLOOKUP(A65,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A65,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[1,12,"Avance Trésorerie",{"$f":"VLOOKUP(B66,GESTION!$A$12:'GESTION'!$AQ$25,GESTION!$G$4,0)*(GESTION!G4=40)","v":0},{"$f":"SUMIF(B12:E65,1,E12:E65)*(GESTION!$G$4=40)","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)*(GESTION!$G$4=40)","v":0},{"$f":"ROUND(D66*E66/10000,2)","v":0}]
[null,null,null,null,null,"TOTAL",{"$f":"(SUM(G12:G65)/2)+G66","v":1008},{"$f":"SUM(H12:H66)","v":789.6},{"$f":"SUM(I12:I66)","v":-789.6},{"$f":"SUM(J12:J66)","v":0},null,{"$f":"SUM(L12:L66)/2","v":0},null,{"$f":"SUM(N12:N65)","v":0}]
[null,null,null,null,"Provisions",null,{"$f":"SUM(K68:N68)*-1","v":0},null,null,null,{"$f":"IF(GESTION!$G$4=8,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=16,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=24,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=32,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""}]
[null,null,null,null,"Financement Fonds Travaux",null,{"$f":"I67","v":-789.6},null,null,null,8,16,24,32]
[null,null,null,"SOLDE en votre faveur…………………..",null,null,{"$f":"IF(AND(H$4<>36,G67+G68+G69<0),G67+G68+G69,0)","v":0},null,null,null,{"$f":"GESTION!$G$4","v":20},{"$f":"GESTION!$H$4","v":"1er Appel Travaux "}]
[null,null,null,"SOLDE dû au syndicat…………….",null,null,{"$f":"IF(AND($G$4<>36,G67+G68+G69>0),G67+G68+G69,0)","v":218.39999999999998}]
[null,null,null,null,null,null,null,null,{"$f":"IF(L67>0,\"Dont T.V.A.\",\"\")","v":""},{"$f":"IF(L67<>0,L67,\"\")","v":""}]
[null,null,null,"RELEVE DE COMPTE",null,null,null,null,null,null,null,"La zône grisée n' est pas destinée"]
[null,null,null,null,null,null,null,null,null,null,null,"a être imprimée et diffusée."]
[null,null,"Dates","Libellés des operations",null,"DEBIT","CREDIT"]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F76:F78)","v":0},{"$f":"SUM(G76:G78)","v":0}]
[null,null,{"$f":"IF(GESTION!$G$4<>36,E36,\"\")","v":"00:00:00"},{"$f":"IF(GESTION!$G$4<>36,D8,\"\")","v":"1er Appel Travaux  Electricité"},null,{"$f":"G71","v":218.39999999999998},{"$f":"IF(G70>0,G70,G70*-1)","v":0}]
[null,null,null,null,null,{"$f":"SUM(F79:F80)","v":218.39999999999998},{"$f":"SUM(G79:G80)","v":0}]
[null,null,null,null,{"$f":"IF(F82<G82,\"Montant à Payer\",\"Montant à votre crédit\")","v":"Montant à Payer"},{"$f":"IF((F81-G81)>0,F81-G81,\"\")","v":218.39999999999998},{"$f":"IF((G81-F81)>0,G81-F81,\"\")","v":""}]
[]
[null,null,"Avance Trésorerie","Av.Travaux","Fds Travaux ",{"$f":"IF($F$52<$G$52,\"Règlement à faire à l'ordre du Syndicat des Copropriétaires.\",\"\")","v":""}]
[null,null,{"$f":"VLOOKUP($G2,GESTION!$A$63:$C$82,3,FALSE)","v":168},{"$f":"GESTION!$B$88*E99/Tant.Lots.Fds!$H$36","v":84},{"$f":"$N$37","v":0}]
[null,null,null,null,null,"Le syndic"]
[null,null,null,null,{"$f":"AUBERT!$C$8","v":20},{"$f":"AUBERT!$D$8","v":"1er Appel Travaux  Electricité"}]
[]
[null,"CLE","Designation",null,"V/Tantièmes",null,"V/Quote part"]
[null,1,"Charges Générales",null,{"$f":"SUMIF($B$12:$G$66,B90,$E$12:$E$66)","v":1680},null,{"$f":"SUMIF($B$12:$B$66,B90,$G$12:$G$66)","v":1008}]
[null,2,"Ch.Bâtiment",null,{"$f":"SUMIF($B$12:$G$66,B91,$E$12:$E$66)","v":198},null,{"$f":"SUMIF($B$12:$B$66,B91,$G$12:$G$66)","v":0}]
[null,3,"Ch.Escal.A",null,{"$f":"SUMIF($B$12:$G$66,B92,$E$12:$E$66)","v":158},null,0]
[null,4,"Ch?Escal.B",null,{"$f":"SUMIF($B$12:$B$66,B93,$E$12:$E$66)","v":268},null,0]
[null,5,"WC Commun",null,{"$f":"SUMIF($B$12:$G$66,B94,$E$12:$E$66)","v":401},null,0]
[null,6,"Prov.Eau",null,{"$f":"SUMIF($B$12:$G$66,B95,$E$12:$E$66)","v":0},null,0]
[null,7,"07/09/2016Eau",null,{"$f":"SUMIF($B$12:$G$66,B96,$E$12:$E$66)","v":0},null,0]
[null,8,null,null,{"$f":"SUMIF($B$12:$G$66,B97,$E$12:$E$66)","v":0},null,0]
[null,null,null,null,null,null,{"$f":"SUM(G90:G97)","v":1008},null,null,null,null,null,null,null,null,null,{"$f":"IF($F$52<$G$52,\"Règlement à faire à l'ordre du Syndicat des Copropriétaires.\",\"\")","v":""}]
[null,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},null,{"$f":"SUMIF($B$12:$G$66,B99,$E$12:$E$37)","v":1680},null,{"$f":"SUMIF($B$12:$B$66,B99,$G$12:$G$66)","v":0}]
[null,12,"Avance de Trésorerie",null,{"$f":"SUMIF($B$12:$G$37,B100,$E$12:$E$37)","v":0},null,{"$f":"SUMIF($B$12:$B$66,B100,$G$12:$G$66)","v":0}]
[null,null,null,null,null,null,{"$f":"G98+G99+G100","v":1008},{"$f":"G101+G68+G69-G70-G71","v":0}]
[]
[null,null,"Financement des travaux",null,null,null,{"$f":"G69","v":-789.6}]

{"sheet":"HUBERT","index":9,"n_rows":103,"n_cols":14,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
[{"$f":"GESTION!A1","v":"Syndicat des Copropriétaires"}]
[{"$f":"GESTION!A2","v":"27 rue de PARIS"},null,null,null,null,null,{"$f":"Copropriétaires!$A$10","v":450.00599999999997},{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,3,FALSE)","v":"Mr HUBERT"}]
[{"$f":"GESTION!A3","v":"08200 LETROU"},null,null,null,null,null,null,{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,7,FALSE)","v":"27 rue de Paris"}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,10,FALSE)","v":"08200 LETROU"}]
[null,null,null,"Date d'avis:",{"$f":"GESTION!$D$4","v":"20/10/17"}]
[null,null,null,"Exigible",{"$f":"GESTION!$D$5","v":"01//12/17"}]
[]
["Lots 11, 28,",null,null,{"$f":"GESTION!$G$4","v":20},{"$f":"CONCATENATE(GESTION!$H$4,\" \",GESTION!$H$5)","v":"1er Appel Travaux  Electricité"}]
[null,null,"2230/10000",null,{"$f":"CONCATENATE(\"Exercice du \",GESTION!$E$1,\" \",GESTION!$F$1,\" au \",GESTION!$E$2,\" \",GESTION!$F$2)","v":"Exercice du 1er janvier 2017 au 31 décembre. 2017"},null,null,{"$f":"OR(GESTION!G4=8,GESTION!G4=16,GESTION!G4=24,GESTION!G4=32,GESTION!G4=36)","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"GESTION!$L$1","v":80},"%"]
["LOT","CLE","Designation","A répartir","V/Tantièmes","Tantièmes Gén.","V/Quote part","FONDS","Affectation","Fd Restant","T.VA.","Q.P.TVA"]
[11,null,{"$f":"VLOOKUP(A12,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Cave N° 1"},null,null,null,null,null,{"$f":"IF(H12<>0,ROUND(H12*E12/F12,2),\"\")","v":""}]
[11,1,{"$f":"VLOOKUP(B13,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B13,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A13,Tant.Lots.Fds!$A$5:$AB$35,B13+7)","v":70},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B13+7)","v":10000},{"$f":"ROUND(D13*E13/F13,2)","v":42},null,"","",{"$f":"IF(B13<>\"\",VLOOKUP(B13,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K13<>0,ROUND($K13*$E13/$F13,2),0)","v":0}]
[11,2,{"$f":"VLOOKUP(B14,GESTION!$A$12:$B$26,2)","v":"Ch.Bât."},{"$f":"VLOOKUP(B14,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A14,Tant.Lots.Fds!$A$5:$AB$35,B14+7)","v":8},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B14+7)","v":1000},{"$f":"ROUND(D14*E14/F14,2)","v":0},null,"","",{"$f":"IF(B14<>\"\",VLOOKUP(B14,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K14<>0,ROUND($K14*$E14/$F14,2),0)","v":0}]
[11,3,{"$f":"VLOOKUP(B15,GESTION!$A$12:$B$26,2)","v":"Ch.Escal.A"},{"$f":"VLOOKUP(B15,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A15,Tant.Lots.Fds!$A$5:$AB$35,B15+7)","v":127},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B15+7)","v":1000},{"$f":"ROUND(D15*E15/F15,2)","v":0},null,"","",{"$f":"IF(B15<>\"\",VLOOKUP(B15,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K15<>0,ROUND($K15*$E15/$F15,2),0)","v":0}]
[11,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B16,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B16,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A16,Tant.Lots.Fds!$A$5:$AB$35,8)","v":70},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},{"$f":"ROUND(D16*E16/F16,2)","v":0},null,null,null,null,{"$f":"IF(J16<>0,ROUND(J16*D16/E16,2),\"\")","v":""}]
[11,null,null,null,null,null,{"$f":"SUM(G13:G16)","v":42},{"$f":"VLOOKUP(A17,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":32.9},{"$f":"IF(H17>ROUND(G17*$I$10/100,2),ROUND(G17*$I$10/100,2),H17)*-1*(G17>0)","v":-32.9},{"$f":"H17+I17","v":0},null,{"$f":"SUM(L13:L16)","v":0},null,{"$f":"VLOOKUP(A17,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A17,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[28,null,{"$f":"VLOOKUP(A18,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Appartement"},null,null,null,null,null,{"$f":"IF(H18<>0,ROUND(H18*E18/F18,2),\"\")","v":""}]
[28,1,{"$f":"VLOOKUP(B19,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B19,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A19,Tant.Lots.Fds!$A$5:$AB$35,B19+7)","v":2260},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B19+7)","v":10000},{"$f":"ROUND(D19*E19/F19,2)","v":1356},null,"","",{"$f":"IF(B19<>\"\",VLOOKUP(B19,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K19<>0,ROUND($K19*$E19/$F19,2),0)","v":0}]
[28,2,{"$f":"VLOOKUP(B20,GESTION!$A$12:$B$26,2)","v":"Ch.Bât."},{"$f":"VLOOKUP(B20,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A20,Tant.Lots.Fds!$A$5:$AB$35,B20+7)","v":265},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B20+7)","v":1000},0,null,"","",{"$f":"IF(B20<>\"\",VLOOKUP(B20,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[28,4,{"$f":"VLOOKUP(B21,GESTION!$A$12:$B$26,2)","v":"Ch Escal B"},{"$f":"VLOOKUP(B21,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A21,Tant.Lots.Fds!$A$5:$AB$35,B21+7)","v":353},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B21+7)","v":1000},0,null,null,null,{"$f":"IF(B21<>\"\",VLOOKUP(B21,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[28,6,{"$f":"VLOOKUP(B22,GESTION!$A$12:$B$26,2)","v":"Provision Eau"},{"$f":"VLOOKUP(B22,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)","v":0},{"$f":"VLOOKUP(A22,Tant.Lots.Fds!$A$5:$AB$35,B22+7)*(GESTION!$J$1=1)","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B22+7)","v":1},0,null,null,null,{"$f":"IF(B22<>\"\",VLOOKUP(B22,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[28,7,{"$f":"VLOOKUP(B23,GESTION!$A$12:$B$26,2)","v":"EAU Individuelle"},{"$f":"VLOOKUP(B23,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"VLOOKUP(A23,Tant.Lots.Fds!$A$5:$Z$35,14,0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B23+7)+(Tant.Lots.Fds!$N$36=0)","v":760},0,null,null,null,{"$f":"IF(B23<>\"\",VLOOKUP(B23,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[28,8,null,null,null,null,null,null,null,null,{"$f":"IF(B24<>\"\",VLOOKUP(B24,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},0]
[28,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B25,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B25,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A25,Tant.Lots.Fds!$A$5:$AB$35,8)","v":2260},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},{"$f":"ROUND(D25*E25/F25,2)","v":0},null,null,null,null,{"$f":"IF(J25<>0,ROUND(J25*D25/E25,2),\"\")","v":""}]
[28,null,null,null,null,null,{"$f":"SUM(G19:G25)","v":1356},{"$f":"VLOOKUP(A26,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":1062.2},{"$f":"IF(H26>ROUND(G26*$I$10/100,2),ROUND(G26*$I$10/100,2),H26)*-1*(G26>0)","v":-1062.2},{"$f":"H26+I26","v":0},null,{"$f":"SUM(L19:L25)","v":0},null,{"$f":"VLOOKUP(A26,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A26,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1,12,"Avance Trésorerie",{"$f":"VLOOKUP(B36,GESTION!$A$12:'GESTION'!$AQ$25,GESTION!$G$4,0)*(GESTION!G4=40)","v":0},{"$f":"SUMIF(B12:E35,1,E12:E35)*(GESTION!G4=40)","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)*(GESTION!$G$4=40)","v":0},{"$f":"ROUND(D36*E36/10000,2)","v":0}]
[null,null,null,null,null,"TOTAL",{"$f":"(SUM(G12:G35)/2)+G36","v":1398},{"$f":"SUM(H12:H36)","v":1095.1000000000001},{"$f":"SUM(I12:I36)","v":-1095.1000000000001},{"$f":"SUM(J12:J36)","v":0},null,{"$f":"SUM(L12:L36)/2","v":0},null,{"$f":"SUM(N13:N36)","v":0}]
[null,null,null,null,"Provisions",null,{"$f":"SUM(K38:N38)*-1","v":0},null,null,null,{"$f":"IF(GESTION!$G$4=8,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=16,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=24,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=32,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""}]
[null,null,null,null,"Financement Fonds Travaux",null,{"$f":"I37","v":-1095.1000000000001},null,null,null,8,16,24,32]
[null,null,null,"SOLDE en votre faveur…………………..",null,null,{"$f":"IF(AND(H$4<>36,G37+G38+G39<0),G37+G38+G39,0)","v":0},null,null,null,{"$f":"GESTION!$G$4","v":20},{"$f":"GESTION!$H$4","v":"1er Appel Travaux "}]
[null,null,null,"SOLDE dû au syndicat…………….",null,null,{"$f":"IF(AND($G$4<>36,G37+G38+G39>0),G37+G38+G39,0)","v":302.89999999999986}]
[null,null,null,null,null,null,null,null,{"$f":"IF(L37>0,\"Dont T.V.A.\",\"\")","v":""},{"$f":"IF(L37<>0,L37,\"\")","v":""}]
[null,null,null,"RELEVE DE COMPTE",null,null,null,null,{"$f":"IF(M6<>0,#REF!,\"\")","v":""},null,null,"La zône grisée n' est pas destinée"]
[null,null,null,null,null,null,null,null,{"$f":"IF(M6<>0,#REF!,\"\")","v":""},null,null,"a être imprimée et diffusée."]
[null,null,"Dates","Libellés des operations",null,"DEBIT","CREDIT"]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F46:F48)","v":0},{"$f":"SUM(G46:G48)","v":0}]
[null,null,{"$f":"IF(GESTION!$G$4<>36,E6,\"\")","v":"01//12/17"},{"$f":"IF(GESTION!$G$4<>36,D8,\"\")","v":20},null,{"$f":"G41","v":302.89999999999986},{"$f":"IF(G40>0,G40,G40*-1)","v":0}]
[null,null,null,null,null,{"$f":"SUM(F49:F50)","v":302.89999999999986},{"$f":"SUM(G49:G50)","v":0}]
[null,null,null,null,{"$f":"IF(F52<G52,\"Montant à Payer\",\"Montant à votre crédit\")","v":"Montant à Payer"},{"$f":"IF((F51-G51)>0,F51-G51,\"\")","v":302.89999999999986},{"$f":"IF((G51-F51)>0,G51-F51,\"\")","v":""}]
[]
[null,null,"Avance Trésorerie","Av.Travaux","Fds Travaux ",{"$f":"IF($F$52<$G$52,\"Règlement à faire à l'ordre du Syndicat des Copropriétaires.\",\"\")","v":"Règlement à faire à l'ordre du Syndicat des Copropriétaires."}]
[null,null,{"$f":"VLOOKUP($G2,GESTION!$A$63:$C$82,3,FALSE)","v":233},{"$f":"GESTION!$B$88*E99/Tant.Lots.Fds!$H$36","v":116.5},{"$f":"$N$37","v":0}]
[null,null,null,null,null,"Le syndic"]
[null,{"$f":"IF(G4<>36,\"\",B6)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"AUBERT!$C$8","v":20},{"$f":"AUBERT!$D$8","v":"1er Appel Travaux  Electricité"}]
[]
[null,"CLE","Designation",null,"V/Tantièmes",null,"V/Quote part"]
[null,1,"Charges Générales",null,{"$f":"SUMIF($B$12:$G$37,B90,$E$12:$E$37)","v":2330},null,{"$f":"SUMIF($B$12:$B$36,B90,$G$12:$G$36)","v":1398}]
[null,2,"Ch.Bâtiment",null,{"$f":"SUMIF($B$12:$G$37,B91,$E$12:$E$37)","v":273},null,{"$f":"SUMIF($B$12:$B$36,B91,$G$12:$G$36)","v":0}]
[null,3,"Ch.Escal.A",null,127,null,0]
[null,4,"Ch.scal.B",null,353,null,0]
[null,5,"WW Commun",null,0,null,0]
[null,6,"Prov.Eau",null,0,null,0]
[null,7,"Cons. Eau",null,0,null,0]
[null,8,"Eau Commune",null,0,null,0]
[null,null,null,null,null,null,{"$f":"SUM(G90:G97)","v":1398}]
[null,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},null,{"$f":"SUMIF($B$12:$G$37,B99,$E$12:$E$37)","v":2330},null,{"$f":"SUMIF($B$12:$B$36,B99,$G$12:$G$36)","v":0}]
[null,12,"Avance de Trésorerie",null,{"$f":"SUMIF($B$12:$G$37,B100,$E$12:$E$37)","v":0},null,{"$f":"SUMIF($B$12:$B$36,B100,$G$12:$G$36)","v":0}]
[null,null,null,null,null,null,{"$f":"G98+G99+G100","v":1398},{"$f":"G101+G38+G39-G40-G41","v":0}]
[]
[null,null,"Financement des travaux",null,null,null,{"$f":"G39","v":-1095.1000000000001}]

{"sheet":"LONGUET","index":10,"n_rows":103,"n_cols":14,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
[{"$f":"GESTION!A1","v":"Syndicat des Copropriétaires"}]
[{"$f":"GESTION!A2","v":"27 rue de PARIS"},null,null,null,null,null,{"$f":"Copropriétaires!$A$11","v":450.00700000000001},{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,3,FALSE)","v":"Mr LONGUET Jean Pierre"}]
[{"$f":"GESTION!A3","v":"08200 LETROU"},null,null,null,null,null,null,{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,7,FALSE)","v":"9 allée Verte"}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,10,FALSE)","v":"83270 Saint Cyr sur Mer"}]
[null,null,null,"Date d'avis:",{"$f":"GESTION!$D$4","v":"20/10/17"}]
[null,null,null,"Exigible",{"$f":"GESTION!$D$5","v":"01//12/17"}]
[]
["Lots 15,29, 30,",null,{"$f":"GESTION!$G$4","v":20},{"$f":"CONCATENATE(GESTION!$H$4,\" \",GESTION!$H$5)","v":"1er Appel Travaux  Electricité"}]
[null,"990/10,000",null,{"$f":"CONCATENATE(\"Exercice du \",GESTION!$E$1,\" \",GESTION!$F$1,\" au \",GESTION!$E$2,\" \",GESTION!$F$2)","v":"Exercice du 1er janvier 2017 au 31 décembre. 2017"},null,null,null,{"$f":"OR(GESTION!G4=8,GESTION!G4=16,GESTION!G4=24,GESTION!G4=32,GESTION!G4=36)","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"GESTION!$L$1","v":80},"%"]
["LOT","CLE","Designation","A répartir","V/Tantièmes","Tantièmes Gén.","V/Quote part","FONDS","Affectation","Fd Restant","T.VA.","Q.P. T.V.A"]
[15,null,{"$f":"VLOOKUP(A12,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Cave N° 5"},null,null,null,null,null,{"$f":"IF(H12<>0,ROUND(H12*E12/F12,2),\"\")","v":""}]
[15,1,{"$f":"VLOOKUP(B13,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B13,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A13,Tant.Lots.Fds!$A$5:$AB$35,B13+7)","v":80},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B13+7)","v":10000},{"$f":"ROUND(D13*E13/F13,2)","v":48},null,"","",{"$f":"IF(B13<>\"\",VLOOKUP(B13,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K13<>0,ROUND($K13*$E13/$F13,2),0)","v":0}]
[15,2,{"$f":"VLOOKUP(B14,GESTION!$A$12:$B$26,2)","v":"Ch.Bât."},{"$f":"VLOOKUP(B14,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A14,Tant.Lots.Fds!$A$5:$AB$35,B14+7)","v":9},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B14+7)","v":1000},{"$f":"ROUND(D14*E14/F14,2)","v":0},null,"","",{"$f":"IF(B14<>\"\",VLOOKUP(B14,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K14<>0,ROUND($K14*$E14/$F14,2),0)","v":0}]
[15,3,{"$f":"VLOOKUP(B15,GESTION!$A$12:$B$26,2)","v":"Ch.Escal.A"},{"$f":"VLOOKUP(B15,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A15,Tant.Lots.Fds!$A$5:$AB$35,B15+7)","v":143},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B15+7)","v":1000},{"$f":"ROUND(D15*E15/F15,2)","v":0},null,"","",{"$f":"IF(B15<>\"\",VLOOKUP(B15,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K15<>0,ROUND($K15*$E15/$F15,2),0)","v":0}]
[15,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B16,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B16,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A16,Tant.Lots.Fds!$A$5:$AB$35,8)","v":80},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},{"$f":"ROUND(D16*E16/F16,2)","v":0},null,null,null,null,{"$f":"IF(J16<>0,ROUND(J16*D16/E16,2),\"\")","v":""}]
[15,null,null,null,null,null,{"$f":"SUM(G13:G16)","v":48},{"$f":"VLOOKUP(A17,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":37.6},{"$f":"IF(H17>ROUND(G17*$I$10/100,2),ROUND(G17*$I$10/100,2),H17)*-1*(G17>0)","v":-37.6},{"$f":"H17+I17","v":0},null,{"$f":"SUM(L13:L16)","v":0},null,{"$f":"VLOOKUP(A17,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A17,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[29,null,{"$f":"VLOOKUP(A18,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Commerce"},null,null,null,null,null,{"$f":"IF(H18<>0,ROUND(H18*E18/F18,2),\"\")","v":""}]
[29,1,{"$f":"VLOOKUP(B19,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B19,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A19,Tant.Lots.Fds!$A$5:$AB$35,B19+7)","v":480},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B19+7)","v":10000},{"$f":"ROUND(D19*E19/F19,2)","v":288},null,"","",{"$f":"IF(B19<>\"\",VLOOKUP(B19,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K19<>0,ROUND($K19*$E19/$F19,2),0)","v":0}]
[29,2,{"$f":"VLOOKUP(B20,GESTION!$A$12:$B$26,2)","v":"Ch.Bât."},{"$f":"VLOOKUP(B20,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A20,Tant.Lots.Fds!$A$5:$AB$35,B20+7)","v":56},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B20+7)","v":1000},0,null,"","",{"$f":"IF(B20<>\"\",VLOOKUP(B20,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K20<>0,ROUND($K20*$E20/$F20,2),0)","v":0}]
[29,6,{"$f":"VLOOKUP(B21,GESTION!$A$12:$B$26,2)","v":"Provision Eau"},{"$f":"VLOOKUP(B21,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)","v":0},{"$f":"VLOOKUP(A21,Tant.Lots.Fds!$A$5:$Z$35,13,0)*(GESTION!$J$1=1)","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B21+7)","v":1},0,null,null,null,{"$f":"IF(B21<>\"\",VLOOKUP(B21,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K21<>0,ROUND($K21*$E21/$F21,2),0)","v":0}]
[29,7,{"$f":"VLOOKUP(B22,GESTION!$A$12:$B$26,2)","v":"EAU Individuelle"},{"$f":"VLOOKUP(B22,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"VLOOKUP(A22,Tant.Lots.Fds!$A$5:$Z$35,14,0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B22+7)+(Tant.Lots.Fds!$N$36=0)","v":760},0,null,null,null,{"$f":"IF(B22<>\"\",VLOOKUP(B22,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K22<>0,ROUND($K22*$E22/$F22,2),0)","v":0}]
[29,8,null,null,null,null,"=",null,null,null,{"$f":"IF(B23<>\"\",VLOOKUP(B23,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K23<>0,ROUND($K23*$E23/$F23,2),0)","v":0}]
[29,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B24,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B24,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A24,Tant.Lots.Fds!$A$5:$AB$35,8)","v":480},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},0,null,null,null,null,{"$f":"IF(J24<>0,ROUND(J24*D24/E24,2),\"\")","v":""}]
[29,null,null,null,null,null,{"$f":"SUM(G19:G24)","v":288},{"$f":"VLOOKUP(A25,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":225.6},{"$f":"IF(H25>ROUND(G25*$I$10/100,2),ROUND(G25*$I$10/100,2),H25)*-1*(G25>0)","v":-225.6},{"$f":"H25+I25","v":0},null,{"$f":"SUM(L19:L24)","v":0},null,{"$f":"VLOOKUP(A25,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A25,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[30,null,{"$f":"VLOOKUP(A26,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Commerce"},null,null,null,{"$f":"IF(D26<>0,ROUND(D26*E26/F26,2),\"\")","v":""}]
[30,1,{"$f":"VLOOKUP(B27,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B27,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A27,Tant.Lots.Fds!$A$5:$AB$35,B27+7)","v":430},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B27+7)","v":10000},{"$f":"ROUND(D27*E27/F27,2)","v":258},null,"","",{"$f":"IF(B27<>\"\",VLOOKUP(B27,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K27<>0,ROUND($K27*$E27/$F27,2),0)","v":0}]
[30,2,{"$f":"VLOOKUP(B28,GESTION!$A$12:$B$26,2)","v":"Ch.Bât."},{"$f":"VLOOKUP(B28,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A28,Tant.Lots.Fds!$A$5:$AB$35,B28+7)","v":51},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B28+7)","v":1000},0,null,"","",{"$f":"IF(B28<>\"\",VLOOKUP(B28,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K28<>0,ROUND($K28*$E28/$F28,2),0)","v":0}]
[30,6,{"$f":"VLOOKUP(B29,GESTION!$A$12:$B$26,2)","v":"Provision Eau"},{"$f":"VLOOKUP(B29,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)","v":0},{"$f":"VLOOKUP(A29,Tant.Lots.Fds!$A$5:$Z$35,13,0)*(GESTION!$J$1=1)","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B29+7)","v":1},0,null,null,null,{"$f":"IF(B29<>\"\",VLOOKUP(B29,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K29<>0,ROUND($K29*$E29/$F29,2),0)","v":0}]
[30,7,{"$f":"VLOOKUP(B30,GESTION!$A$12:$B$26,2)","v":"EAU Individuelle"},{"$f":"VLOOKUP(B30,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"VLOOKUP(A30,Tant.Lots.Fds!$A$5:$Z$35,14,0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B30+7)+(Tant.Lots.Fds!$N$36=0)","v":760},0,null,null,null,{"$f":"IF(B30<>\"\",VLOOKUP(B30,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K30<>0,ROUND($K30*$E30/$F30,2),0)","v":0}]
[30,8,null,null,null,null,null,null,null,null,{"$f":"IF(B31<>\"\",VLOOKUP(B31,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K31<>0,ROUND($K31*$E31/$F31,2),0)","v":0}]
[30,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B32,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B32,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A32,Tant.Lots.Fds!$A$5:$AB$35,8)","v":430},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},0,null,null,null,null,{"$f":"IF(J32<>0,ROUND(J32*D32/E32,2),\"\")","v":""}]
[30,null,null,null,null,null,{"$f":"SUM(G27:G32)","v":258},{"$f":"VLOOKUP(A33,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":202.1},{"$f":"IF(H33>ROUND(G33*$I$10/100,2),ROUND(G33*$I$10/100,2),H33)*-1*(G33>0)","v":-202.1},{"$f":"H33+I33","v":0},null,{"$f":"SUM(L27:L32)","v":0},null,{"$f":"VLOOKUP(A33,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A33,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[]
[]
[1,12,"Avance Trésorerie",{"$f":"VLOOKUP(B36,GESTION!$A$12:'GESTION'!$AQ$25,GESTION!$G$4,0)*(GESTION!G4=40)","v":0},{"$f":"SUMIF(B12:E35,1,E12:E35)*(GESTION!G4=40)","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)*(GESTION!$G$4=40)","v":0},{"$f":"ROUND(D36*E36/10000,2)","v":0},null,{"$f":"IF(H36<>0,ROUND(H36*E36/F36,2),\"\")","v":""}]
[null,null,null,null,null,"TOTAL",{"$f":"(SUM(G12:G35)/2)+G36","v":594},{"$f":"SUM(H12:H36)","v":465.29999999999995},{"$f":"SUM(I12:I36)","v":-465.29999999999995},{"$f":"SUM(J12:J36)","v":0},null,{"$f":"SUM(L12:L36)/2","v":0},null,{"$f":"SUM(N13:N36)","v":0}]
[null,null,null,null,"Provisions",null,{"$f":"SUM(K38:N38)*-1","v":0},null,null,null,{"$f":"IF(GESTION!$G$4=8,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=16,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=24,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=32,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""}]
[null,null,null,null,"Financement Fonds Travaux",null,{"$f":"I37","v":-465.29999999999995},null,null,null,8,16,24,32]
[null,null,null,"SOLDE en votre faveur…………………..",null,null,{"$f":"IF(AND(H$4<>36,G37+G38+G39<0),G37+G38+G39,0)","v":0},null,null,null,{"$f":"GESTION!$G$4","v":20},{"$f":"GESTION!$H$4","v":"1er Appel Travaux "}]
[null,null,null,"SOLDE dû au syndicat…………….",null,null,{"$f":"IF(AND($G$4<>36,G37+G38+G39>0),G37+G38+G39,0)","v":128.70000000000005}]
[null,null,null,null,null,null,null,null,{"$f":"IF(L37>0,\"Dont T.V.A.\",\"\")","v":""},{"$f":"IF(L37<>0,L37,\"\")","v":""}]
[null,null,null,"RELEVE DE COMPTE",null,null,null,{"$f":"IF(M37<>0,\"Dont TVA\",\"\")","v":""},{"$f":"IF(M12<>0,M37,\"\")","v":""},null,null,"La zône grisée n' est pas destinée"]
[null,null,null,null,null,null,null,{"$f":"IF(N37<>0,\"TVAs/Ch.Loc\",\"\")","v":""},{"$f":"IF(M12<>0,N37,\"\")","v":""},null,null,"a être imprimée et diffusée."]
[null,null,"Dates","Libellés des operations",null,"DEBIT","CREDIT"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(M42<>0,\"Dont T.V.A.\",\"\")","v":""},{"$f":"IF(M41<>0,M41,\"\")","v":""}]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F46:F48)","v":0},{"$f":"SUM(G46:G48)","v":0}]
[null,null,{"$f":"IF(GESTION!$G$4<>36,E6,\"\")","v":"01//12/17"},{"$f":"IF(GESTION!$G$4<>36,D8,\"\")","v":"1er Appel Travaux  Electricité"},null,{"$f":"G41","v":128.70000000000005},{"$f":"IF(G40>0,G40,G40*-1)","v":0}]
[null,null,null,null,null,{"$f":"SUM(F49:F50)","v":128.70000000000005},{"$f":"SUM(G49:G50)","v":0}]
[null,null,null,null,{"$f":"IF(F52<G52,\"Montant à Payer\",\"Montant à votre crédit\")","v":"Montant à Payer"},{"$f":"IF((F51-G51)>0,F51-G51,\"\")","v":128.70000000000005},{"$f":"IF((G51-F51)>0,G51-F51,\"\")","v":""}]
[]
[null,null,"Avance Trésorerie","Av.Travaux","Fds Travaux ",{"$f":"IF($F$52<$G$52,\"Règlement à faire à l'ordre du Syndicat des Copropriétaires.\",\"\")","v":"Règlement à faire à l'ordre du Syndicat des Copropriétaires."}]
[null,null,{"$f":"VLOOKUP($G2,GESTION!$A$63:$C$82,3,FALSE)","v":99},{"$f":"GESTION!$B$88*E99/Tant.Lots.Fds!$H$36","v":49.5},{"$f":"$N$37","v":0}]
[null,null,null,null,null,"Le syndic"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"AUBERT!$C$8","v":20},{"$f":"AUBERT!$D$8","v":"1er Appel Travaux  Electricité"}]
[]
[null,"CLE","Designation",null,"V/Tantièmes",null,"V/Quote part"]
[null,1,"Charges Générales",null,{"$f":"SUMIF($B$12:$G$37,B90,$E$12:$E$37)","v":990},null,{"$f":"SUMIF($B$12:$B$36,B90,$G$12:$G$36)","v":594}]
[null,2,"Ch.Bâtiment",null,{"$f":"SUMIF($B$12:$G$37,B91,$E$12:$E$37)","v":116},null,{"$f":"SUMIF($B$12:$B$36,B91,$G$12:$G$36)","v":0}]
[null,3,"Ch.Escal.A",null,143,null,0]
[null,4,"Ch?Escal.B",null,0,null,0]
[null,5,"WW Commun",null,0,null,0]
[null,6,"Prov.Eau",null,0,null,0]
[null,7,"Cons.Eau",null,0,null,0]
[null,8,"Eau Commune",null,0,null,0]
[null,null,null,null,null,null,{"$f":"SUM(G90:G97)","v":594}]
[null,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},null,990,null,{"$f":"SUMIF($B$12:$B$36,B99,$G$12:$G$36)","v":0}]
[null,12,"Avance de Trésorerie",null,0,null,{"$f":"SUMIF($B$12:$B$36,B100,$G$12:$G$36)","v":0}]
[null,null,null,null,null,null,{"$f":"G98+G99+G100","v":594},{"$f":"G101+G38+G39-G40-G41","v":0}]
[]
[null,null,"Financement des travaux",null,null,null,{"$f":"G39","v":-465.29999999999995}]

{"sheet":"MARTIAL","index":11,"n_rows":103,"n_cols":14,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
[{"$f":"GESTION!A1","v":"Syndicat des Copropriétaires"}]
[{"$f":"GESTION!A2","v":"27 rue de PARIS"},null,null,null,null,null,{"$f":"Copropriétaires!$A$12","v":450.00799999999998},{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,3,FALSE)","v":"Mr MARTIAL Paul"}]
[{"$f":"GESTION!A3","v":"08200 LETROU"},null,null,null,null,null,null,{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,7,FALSE)","v":"27 rue de Paris"}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,10,FALSE)","v":"08200 LETROU"}]
[null,null,null,"Date d'avis:",{"$f":"GESTION!$D$4","v":"20/10/17"}]
[null,null,null,"Exigible",{"$f":"GESTION!$D$5","v":"01//12/17"}]
[]
["Lot  2, 104,105,106",null,{"$f":"GESTION!$G$4","v":20},{"$f":"CONCATENATE(GESTION!$H$4,\" \",GESTION!$H$5)","v":"1er Appel Travaux  Electricité"}]
[null,"311/10,000",null,{"$f":"CONCATENATE(\"Exercice du \",GESTION!$E$1,\" \",GESTION!$F$1,\" au \",GESTION!$E$2,\" \",GESTION!$F$2)","v":"Exercice du 1er janvier 2017 au 31 décembre. 2017"},null,null,{"$f":"OR(GESTION!G4=8,GESTION!G4=16,GESTION!G4=24,GESTION!G4=32,GESTION!G4=36)","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"GESTION!$L$1","v":80},"%"]
["LOT","CLE","Designation","A répartir","V/Tantièmes","Tantièmes Gén.","V/Quote part","FONDS","Affectation","Fd Restant","TVA","Q.P. T.V.A"]
[2,null,{"$f":"VLOOKUP(A12,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Pavillon"}]
[2,1,{"$f":"VLOOKUP(B13,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B13,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A13,Tant.Lots.Fds!$A$5:$AB$35,B13+7)","v":300},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B13+7)","v":10000},{"$f":"ROUND(D13*E13/F13,2)","v":180},null,"","",{"$f":"IF(B13<>\"\",VLOOKUP(B13,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K13<>0,ROUND($K13*$E13/$F13,2),0)","v":0}]
[2,6,{"$f":"VLOOKUP(B14,GESTION!$A$12:$B$26,2)","v":"Provision Eau"},{"$f":"VLOOKUP(B14,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)","v":0},{"$f":"VLOOKUP(A14,Tant.Lots.Fds!$A$5:$Z$35,13,0)*(GESTION!$J$1=1)","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B14+7)","v":1},{"$f":"ROUND(D14*E14/F14,2)","v":0},null,null,null,{"$f":"IF(B14<>\"\",VLOOKUP(B14,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K14<>0,ROUND($K14*$E14/$F14,2),0)","v":0}]
[2,7,{"$f":"VLOOKUP(B15,GESTION!$A$12:$B$26,2)","v":"EAU Individuelle"},{"$f":"VLOOKUP(B15,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"VLOOKUP(A15,Tant.Lots.Fds!$A$5:$Z$35,14,0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B15+7)+(Tant.Lots.Fds!$N$36=0)","v":760},{"$f":"ROUND(D15*E15/F15,2)","v":0},null,null,null,{"$f":"IF(B15<>\"\",VLOOKUP(B15,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K15<>0,ROUND($K15*$E15/$F15,2),0)","v":0}]
[2,8,null,null,null,null,null,null,null,null,{"$f":"IF(B16<>\"\",VLOOKUP(B16,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K16<>0,ROUND($K16*$E16/$F16,2),0)","v":0}]
[2,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B17,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B17,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A17,Tant.Lots.Fds!$A$5:$AB$35,8)","v":300},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},{"$f":"ROUND(D17*E17/F17,2)","v":0}]
[2,null,null,null,null,null,{"$f":"SUM(G13:G17)","v":180},{"$f":"VLOOKUP(A18,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":141},{"$f":"IF(H18>ROUND(G18*$I$10/100,2),ROUND(G18*$I$10/100,2),H18)*-1*(G18>0)","v":-141},{"$f":"H18+I18","v":0},null,{"$f":"SUM(L13:L17)","v":0},null,{"$f":"VLOOKUP(A18,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A18,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[104,null,{"$f":"VLOOKUP(A19,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Cour privative"}]
[104,1,{"$f":"VLOOKUP(B20,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B20,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A20,Tant.Lots.Fds!$A$5:$AB$35,B20+7)","v":1},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B20+7)","v":10000},{"$f":"ROUND(D20*E20/F20,2)","v":0.6},null,"","",{"$f":"IF(B20<>\"\",VLOOKUP(B20,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K20<>0,ROUND($K20*$E20/$F20,2),0)","v":0}]
[104,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B21,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B21,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A21,Tant.Lots.Fds!$A$5:$AB$35,8)","v":1},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},{"$f":"ROUND(D21*E21/F21,2)","v":0}]
[104,null,null,null,null,null,{"$f":"SUM(G20:G21)","v":0.6},{"$f":"VLOOKUP(A22,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":0.47},{"$f":"IF(H22>ROUND(G22*$I$10/100,2),ROUND(G22*$I$10/100,2),H22)*-1*(G22>0)","v":-0.47},{"$f":"H22+I22","v":0},null,{"$f":"SUM(L20:L21)","v":0},null,{"$f":"VLOOKUP(A22,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A22,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[105,null,{"$f":"VLOOKUP(A23,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Cour privative"}]
[105,1,{"$f":"VLOOKUP(B24,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B24,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A24,Tant.Lots.Fds!$A$5:$AB$35,B24+7)","v":9},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B24+7)","v":10000},{"$f":"ROUND(D24*E24/F24,2)","v":5.4},null,"","",{"$f":"IF(B24<>\"\",VLOOKUP(B24,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K24<>0,ROUND($K24*$E24/$F24,2),0)","v":0}]
[105,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B25,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B25,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A25,Tant.Lots.Fds!$A$5:$AB$35,8)","v":9},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},{"$f":"ROUND(D25*E25/F25,2)","v":0}]
[105,null,null,null,null,null,{"$f":"SUM(G24:G25)","v":5.4},{"$f":"VLOOKUP(A26,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":4.2300000000000004},{"$f":"IF(H26>ROUND(G26*$I$10/100,2),ROUND(G26*$I$10/100,2),H26)*-1*(G26>0)","v":-4.2300000000000004},{"$f":"H26+I26","v":0},null,{"$f":"SUM(L24:L25)","v":0},null,{"$f":"VLOOKUP(A26,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A26,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[106,null,{"$f":"VLOOKUP(A27,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Cour privative"}]
[106,1,{"$f":"VLOOKUP(B28,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B28,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A28,Tant.Lots.Fds!$A$5:$AB$35,B28+7)","v":1},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B28+7)","v":10000},{"$f":"ROUND(D28*E28/F28,2)","v":0.6},null,"","",{"$f":"IF(B28<>\"\",VLOOKUP(B28,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K28<>0,ROUND($K28*$E28/$F28,2),0)","v":0}]
[106,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B29,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B29,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A29,Tant.Lots.Fds!$A$5:$AB$35,8)","v":1},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},{"$f":"ROUND(D29*E29/F29,2)","v":0}]
[106,null,null,null,null,null,{"$f":"SUM(G28:G29)","v":0.6},{"$f":"VLOOKUP(A30,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":0.47},{"$f":"IF(H30>ROUND(G30*$I$10/100,2),ROUND(G30*$I$10/100,2),H30)*-1*(G30>0)","v":-0.47},{"$f":"H30+I30","v":0},null,{"$f":"SUM(L28:L29)","v":0},null,{"$f":"VLOOKUP(A30,FdsTravLots!$A$4:$D$35,3,0)+VLOOKUP(A30,FdsTravLots!$A$4:$D$35,4,0)","v":0}]
[]
[]
[]
[]
[]
[1,12,"Avance Trésorerie",{"$f":"VLOOKUP(B36,GESTION!$A$12:'GESTION'!$AQ$25,GESTION!$G$4,0)*(GESTION!G4=40)","v":0},{"$f":"SUMIF(B12:E35,1,E12:E35)*(GESTION!G4=40)","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)*(GESTION!$G$4=40)","v":0},{"$f":"ROUND(D36*E36/10000,2)","v":0}]
[null,null,null,null,null,"TOTAL",{"$f":"(SUM(G12:G35)/2)+G36","v":186.60000000000002},{"$f":"SUM(H12:H36)","v":146.16999999999999},{"$f":"SUM(I12:I36)","v":-146.16999999999999},{"$f":"SUM(J12:J36)","v":0},null,{"$f":"SUM(L12:L36)/2","v":0},null,{"$f":"SUM(N13:N36)","v":0}]
[null,null,null,null,"Provisions",null,{"$f":"SUM(K38:N38)*-1","v":0},null,null,null,{"$f":"IF(GESTION!$G$4=8,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=16,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=24,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=32,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""}]
[null,null,null,null,"Financement Fonds Travaux",null,{"$f":"I37","v":-146.16999999999999},null,null,null,8,16,24,32]
[null,null,null,"SOLDE en votre faveur…………………..",null,null,{"$f":"IF(AND(H$4<>36,G37+G38+G39<0),G37+G38+G39,0)","v":0},null,null,null,{"$f":"GESTION!$G$4","v":20},{"$f":"GESTION!$H$4","v":"1er Appel Travaux "}]
[null,null,null,"SOLDE dû au syndicat…………….",null,null,{"$f":"IF(AND($G$4<>36,G37+G38+G39>0),G37+G38+G39,0)","v":40.430000000000035}]
[null,null,null,null,null,null,null,null,{"$f":"IF(L37>0,\"Dont T.V.A.\",\"\")","v":""},{"$f":"IF(L37<>0,L37,\"\")","v":""}]
[null,null,null,"RELEVE DE COMPTE",null,null,null,null,{"$f":"IF(M6<>0,#REF!,\"\")","v":""},null,null,"La zône grisée n' est pas destinée"]
[null,null,null,null,null,null,null,null,{"$f":"IF(M6<>0,#REF!,\"\")","v":""},null,null,"a être imprimée et diffusée."]
[null,null,"Dates","Libellés des operations",null,"DEBIT","CREDIT"]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F46:F48)","v":0},{"$f":"SUM(G46:G48)","v":0}]
[null,null,{"$f":"IF(GESTION!$G$4<>36,E6,\"\")","v":"01//12/17"},{"$f":"IF(GESTION!$G$4<>36,D8,\"\")","v":"1er Appel Travaux  Electricité"},null,{"$f":"G41","v":40.430000000000035},{"$f":"IF(G40>0,G40,G40*-1)","v":0}]
[null,null,null,null,null,{"$f":"SUM(F49:F50)","v":40.430000000000035},{"$f":"SUM(G49:G50)","v":0}]
[null,null,null,null,{"$f":"IF(F52<G52,\"Montant à Payer\",\"Montant à votre crédit\")","v":"Montant à Payer"},{"$f":"IF((F51-G51)>0,F51-G51,\"\")","v":40.430000000000035},{"$f":"IF((G51-F51)>0,G51-F51,\"\")","v":""}]
[]
[null,null,"Avance Trésorerie","Av.Travaux","Fds Travaux ",{"$f":"IF($F$52<$G$52,\"Règlement à faire à l'ordre du Syndicat des Copropriétaires.\",\"\")","v":"Règlement à faire à l'ordre du Syndicat des Copropriétaires."}]
[null,null,{"$f":"VLOOKUP($G2,GESTION!$A$63:$C$82,3,FALSE)","v":31.1},{"$f":"GESTION!$B$88*E99/Tant.Lots.Fds!$H$36","v":15.55},{"$f":"$N$37","v":0}]
[null,null,null,null,null,"Le syndic"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"AUBERT!$C$8","v":20},{"$f":"AUBERT!$D$8","v":"1er Appel Travaux  Electricité"}]
[]
[null,"CLE","Designation",null,"V/Tantièmes",null,"V/Quote part"]
[null,1,"Charges Générales",null,{"$f":"SUMIF($B$12:$G$37,B90,$E$12:$E$37)","v":311},null,{"$f":"SUMIF($B$12:$B$36,B90,$G$12:$G$36)","v":186.6}]
[null,2,"Ch.Bâtiment",null,{"$f":"SUMIF($B$12:$G$37,B91,$E$12:$E$37)","v":0},null,{"$f":"SUMIF($B$12:$B$36,B91,$G$12:$G$36)","v":0}]
[null,3,"Ch.Escal.A",null,0,null,0]
[null,4,"Ch?Escal.B",null,0,null,0]
[null,5,"WW Commun",null,0,null,0]
[null,6,"Prov.Eau",null,0,null,0]
[null,7,"EAU Individuelle",null,0,null,0]
[null,8,"Eau Commune",null,0,null,0]
[null,null,null,null,null,null,{"$f":"SUM(G90:G97)","v":186.6}]
[null,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},null,{"$f":"SUMIF($B$12:$G$37,B99,$E$12:$E$37)","v":311},null,{"$f":"SUMIF($B$12:$B$36,B99,$G$12:$G$36)","v":0}]
[null,12,"Avance de Trésorerie",null,{"$f":"SUMIF($B$12:$G$37,B100,$E$12:$E$37)","v":0},null,{"$f":"SUMIF($B$12:$B$36,B100,$G$12:$G$36)","v":0}]
[null,null,null,null,null,null,{"$f":"G98+G99+G100","v":186.6},{"$f":"G101+G38+G39-G40-G41","v":0}]
[]
[null,null,"Financement des travaux",null,null,null,{"$f":"G39","v":-146.16999999999999}]

{"sheet":"PONTEL","index":12,"n_rows":103,"n_cols":14,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
[{"$f":"GESTION!A1","v":"Syndicat des Copropriétaires"}]
[{"$f":"GESTION!A2","v":"27 rue de PARIS"},null,null,null,null,null,{"$f":"Copropriétaires!$A$13","v":450.00900000000001},{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,3,FALSE)","v":"Mr PONTEL Louis"}]
[{"$f":"GESTION!A3","v":"08200 LETROU"},null,null,null,null,null,null,{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,7,FALSE)","v":"27 rue de Paris"}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,10,FALSE)","v":"08200 LETROU"}]
[null,null,null,"Date d'avis:",{"$f":"GESTION!$D$4","v":"20/10/17"}]
[null,null,null,"Exigible",{"$f":"GESTION!$D$5","v":"01//12/17"}]
[]
["Lot 14, 22,",null,{"$f":"GESTION!$G$4","v":20},{"$f":"CONCATENATE(GESTION!$H$4,\" \",GESTION!$H$5)","v":"1er Appel Travaux  Electricité"}]
[null,"380/10000",null,{"$f":"CONCATENATE(\"Exercice du \",GESTION!$E$1,\" \",GESTION!$F$1,\" au \",GESTION!$E$2,\" \",GESTION!$F$2)","v":"Exercice du 1er janvier 2017 au 31 décembre. 2017"},null,null,{"$f":"OR(GESTION!G4=8,GESTION!G4=16,GESTION!G4=24,GESTION!G4=32,GESTION!G4=36)","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"GESTION!$L$1","v":80},"%"]
["LOT","CLE","Designation","A répartir","V/Tantièmes","Tantièmes Gén.","V/Quote part","FONDS","Affectation","Fd Restant","T.VA.","Q.P.TVA"]
[14,null,{"$f":"VLOOKUP(A12,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Cave N° 4"}]
[14,1,{"$f":"VLOOKUP(B13,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B13,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A13,Tant.Lots.Fds!$A$5:$AB$35,B13+7)","v":30},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B13+7)","v":10000},{"$f":"ROUND(D13*E13/F13,2)","v":18}]
[14,2,{"$f":"VLOOKUP(B14,GESTION!$A$12:$B$26,2)","v":"Ch.Bât."},{"$f":"VLOOKUP(B14,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A14,Tant.Lots.Fds!$A$5:$AB$35,B14+7)","v":4},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B14+7)","v":1000},{"$f":"ROUND(D14*E14/F14,2)","v":0}]
[14,3,{"$f":"VLOOKUP(B15,GESTION!$A$12:$B$26,2)","v":"Ch.Escal.A"},{"$f":"VLOOKUP(B15,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A15,Tant.Lots.Fds!$A$5:$AB$35,B15+7)","v":64},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B15+7)","v":1000},{"$f":"ROUND(D15*E15/F15,2)","v":0}]
[14,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B16,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B16,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A16,Tant.Lots.Fds!$A$5:$AB$35,8)","v":30},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},{"$f":"ROUND(D16*E16/F16,2)","v":0}]
[14,null,null,null,null,null,{"$f":"SUM(G13:G16)","v":18},{"$f":"VLOOKUP(A17,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":14.1},{"$f":"IF(H17>ROUND(G17*$I$10/100,2),ROUND(G17*$I$10/100,2),H17)*-1*(G17>0)","v":-14.1},{"$f":"H17+I17","v":0}]
[22,null,{"$f":"VLOOKUP(A18,Tant.Lots.Fds!$A$5:$B$35,2)","v":"Pièce"}]
[22,1,{"$f":"VLOOKUP(B19,GESTION!$A$12:$B$26,2)","v":"Ch Gén."},{"$f":"VLOOKUP(B19,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":6000},{"$f":"VLOOKUP(A19,Tant.Lots.Fds!$A$5:$AB$35,B19+7)","v":350},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B19+7)","v":10000},{"$f":"ROUND(D19*E19/F19,2)","v":210}]
[22,2,{"$f":"VLOOKUP(B20,GESTION!$A$12:$B$26,2)","v":"Ch.Bât."},{"$f":"VLOOKUP(B20,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A20,Tant.Lots.Fds!$A$5:$AB$35,B20+7)","v":41},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B20+7)","v":1000},0]
[22,4,{"$f":"VLOOKUP(B21,GESTION!$A$12:$B$26,2)","v":"Ch Escal B"},{"$f":"VLOOKUP(B21,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A21,Tant.Lots.Fds!$A$5:$AB$35,B21+7)","v":57},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B21+7)","v":1000},0]
[22,5,{"$f":"VLOOKUP(B22,GESTION!$A$12:$B$26,2)","v":"WC"},{"$f":"VLOOKUP(B22,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)","v":0},{"$f":"VLOOKUP(A22,Tant.Lots.Fds!$A$5:$AB$35,B22+7)","v":185},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B22+7)","v":1000},0]
[22,6,{"$f":"VLOOKUP(B23,GESTION!$A$12:$B$26,2)","v":"Provision Eau"},{"$f":"VLOOKUP(B23,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)","v":0},{"$f":"VLOOKUP(A23,Tant.Lots.Fds!$A$5:$Z$35,13,0)*(GESTION!$J$1=1)","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$AB$36,B23+7)","v":1},0]
[22,7,{"$f":"VLOOKUP(B24,GESTION!$A$12:$B$26,2)","v":"EAU Individuelle"},{"$f":"VLOOKUP(B24,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"VLOOKUP(A24,Tant.Lots.Fds!$A$5:$Z$35,14,0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,B24+7)+(Tant.Lots.Fds!$N$36=0)","v":760},0,null,null,null,{"$f":"IF(B24<>\"\",VLOOKUP(B24,GESTION!$A$12:$AQ$25,GESTION!$G$4+2),0)*((GESTION!$J$1=2)+(GESTION!$K$1=3))","v":0},{"$f":"IF($K24<>0,ROUND($K24*$E24/$F24,2),0)","v":0}]
[22,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},{"$f":"VLOOKUP(B25,GESTION!$A$12:$AQ$27,GESTION!$G$4,0)*(GESTION!$J$1=1)+(VLOOKUP(B25,GESTION!$A$12:$AQ$27,41,0)*(GESTION!$G$4=41))","v":0},{"$f":"VLOOKUP(A25,Tant.Lots.Fds!$A$5:$AB$35,8)","v":350},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)","v":10000},0]
[22,null,null,null,null,null,{"$f":"SUM(G19:G25)","v":210},{"$f":"VLOOKUP(A26,FdsTravLots!$A$4:'FdsTravLots'!$C$35,3,0)*(GESTION!$K$1=2)","v":164.5},{"$f":"IF(H26>ROUND(G26*$I$10/100,2),ROUND(G26*$I$10/100,2),H26)*-1*(G26>0)","v":-164.5},{"$f":"H26+I26","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1,12,"Avance Trésorerie",{"$f":"VLOOKUP(B36,GESTION!$A$12:'GESTION'!$AQ$25,GESTION!$G$4,0)*(GESTION!G4=40)","v":0},{"$f":"SUMIF(B12:E35,1,E12:E35)*(GESTION!G4=40)","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)*(GESTION!$G$4=40)","v":0},{"$f":"ROUND(D36*E36/10000,2)","v":0}]
[null,null,null,null,null,"TOTAL",{"$f":"(SUM(G12:G35)/2)+G36","v":228},{"$f":"SUM(H12:H36)","v":178.6},{"$f":"SUM(I12:I36)","v":-178.6},{"$f":"SUM(J12:J36)","v":0},{"$f":"SUM(K12:K36)","v":0},{"$f":"SUM(L12:L36)","v":0},null,{"$f":"SUM(N13:N36)","v":0}]
[null,null,null,null,"Provisions",null,{"$f":"SUM(K38:N38)*-1","v":0},null,null,null,{"$f":"IF(GESTION!$G$4=8,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=16,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=24,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=32,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""}]
[null,null,null,null,"Financement Fonds Travaux",null,{"$f":"I37","v":-178.6},null,null,null,8,16,24,32]
[null,null,null,"SOLDE en votre faveur…………………..",null,null,{"$f":"IF(AND(H$4<>36,G37+G38+G39<0),G37+G38+G39,0)","v":0},null,null,null,{"$f":"GESTION!$G$4","v":20},{"$f":"GESTION!$H$4","v":"1er Appel Travaux "}]
[null,null,null,"SOLDE dû au syndicat…………….",null,null,{"$f":"IF(AND($G$4<>36,G37+G38+G39>0),G37+G38+G39,0)","v":49.400000000000006}]
[null,null,null,null,null,null,null,null,{"$f":"IF(L37>0,\"Dont T.V.A.\",\"\")","v":""},{"$f":"IF(L37<>0,L37,\"\")","v":""}]
[null,null,null,"RELEVE DE COMPTE",null,null,null,null,{"$f":"IF(M6<>0,#REF!,\"\")","v":""},null,null,"La zône grisée n' est pas destinée"]
[null,null,null,null,null,null,null,null,{"$f":"IF(M6<>0,#REF!,\"\")","v":""},null,null,"a être imprimée et diffusée."]
[null,null,"Dates","Libellés des operations",null,"DEBIT","CREDIT"]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F46:F48)","v":0},{"$f":"SUM(G46:G48)","v":0}]
[null,null,{"$f":"IF(GESTION!$G$4<>36,E6,\"\")","v":"01//12/17"},{"$f":"IF(GESTION!$G$4<>36,D8,\"\")","v":"1er Appel Travaux  Electricité"},null,{"$f":"G41","v":49.400000000000006},{"$f":"IF(G40>0,G40,G40*-1)","v":0}]
[null,null,null,null,null,{"$f":"SUM(F49:F50)","v":49.400000000000006},{"$f":"SUM(G49:G50)","v":0}]
[null,null,null,null,{"$f":"IF(F52<G52,\"Montant à Payer\",\"Montant à votre crédit\")","v":"Montant à Payer"},{"$f":"IF((F51-G51)>0,F51-G51,\"\")","v":49.400000000000006},{"$f":"IF((G51-F51)>0,G51-F51,\"\")","v":""}]
[]
[null,null,"Avance Trésorerie","Av.Travaux","Fds Travaux ",{"$f":"IF($F$52<$G$52,\"Règlement à faire à l'ordre du Syndicat des Copropriétaires.\",\"\")","v":"Règlement à faire à l'ordre du Syndicat des Copropriétaires."}]
[null,null,{"$f":"VLOOKUP($G2,GESTION!$A$63:$C$82,3,FALSE)","v":38},{"$f":"GESTION!$B$88*E99/Tant.Lots.Fds!$H$36","v":19},{"$f":"$N$37","v":0}]
[null,null,null,null,null,"Le syndic"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"AUBERT!$C$8","v":20},{"$f":"AUBERT!$D$8","v":"1er Appel Travaux  Electricité"}]
[]
[null,"CLE","Designation",null,"V/Tantièmes",null,"V/Quote part"]
[null,1,"Charges Générales",null,{"$f":"SUMIF($B$12:$G$37,B90,$E$12:$E$37)","v":380},null,{"$f":"SUMIF($B$12:$B$36,B90,$G$12:$G$36)","v":228}]
[null,2,"Ch.Bâtiment",null,{"$f":"SUMIF($B$12:$G$37,B91,$E$12:$E$37)","v":45},null,{"$f":"SUMIF($B$12:$B$36,B91,$G$12:$G$36)","v":0}]
[null,3,"Ch.Escal.A",null,64,null,0]
[null,4,"Ch?Escal.B",null,57,null,0]
[null,5,"WW Commun",null,185,null,0]
[null,6,"Prov.Eau",null,0,null,0]
[null,7,"Cons.Eau",null,0,null,0]
[null,8,"Eau Commune",null,0,null,0]
[null,null,null,null,null,null,{"$f":"SUM(G90:G97)","v":228}]
[null,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},null,{"$f":"SUMIF($B$12:$G$37,B99,$E$12:$E$37)","v":380},null,{"$f":"SUMIF($B$12:$B$36,B99,$G$12:$G$36)","v":0}]
[null,12,"Avance de Trésorerie",null,{"$f":"SUMIF($B$12:$G$37,B100,$E$12:$E$37)","v":0},null,{"$f":"SUMIF($B$12:$B$36,B100,$G$12:$G$36)","v":0}]
[null,null,null,null,null,null,{"$f":"G98+G99+G100","v":228},{"$f":"G101+G38+G39-G40-G41","v":0}]
[]
[null,null,"Financement des travaux",null,null,null,{"$f":"G39","v":-178.6}]

{"sheet":"xxx","index":13,"n_rows":103,"n_cols":14,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
[{"$f":"GESTION!A1","v":"Syndicat des Copropriétaires"}]
[{"$f":"GESTION!A2","v":"27 rue de PARIS"},null,null,null,null,null,450.01100000000002,{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,3,FALSE)","v":"xxx"}]
[{"$f":"GESTION!A3","v":"08200 LETROU"},null,null,null,null,null,null,{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,7,FALSE)","v":0}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP($G$2,Copropriétaires!$A$6:'Copropriétaires'!$L$25,10,FALSE)","v":0}]
[null,null,null,"Date d'avis:",{"$f":"GESTION!$D$4","v":"20/10/17"}]
[null,null,null,"Exigible",{"$f":"GESTION!$D$5","v":"01//12/17"}]
[]
["Lot …",null,{"$f":"GESTION!$G$4","v":20},{"$f":"CONCATENATE(GESTION!$H$4,\" \",GESTION!$H$5)","v":"1er Appel Travaux  Electricité"}]
[null,null,null,{"$f":"CONCATENATE(\"Exercice du \",GESTION!$E$1,\" \",GESTION!$F$1,\" au \",GESTION!$E$2,\" \",GESTION!$F$2)","v":"Exercice du 1er janvier 2017 au 31 décembre. 2017"},null,null,{"$f":"OR(GESTION!G4=8,GESTION!G4=16,GESTION!G4=24,GESTION!G4=32,GESTION!G4=36)","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"GESTION!$L$1","v":80},"%"]
["LOT","CLE","Designation","A répartir","V/Tantièmes","Tantièmes Gén.","V/Quote part","FONDS","Affectation","Fd Restant","T.VA.","Q.P.TVA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1,12,"Avance Trésorerie",{"$f":"VLOOKUP(B36,GESTION!$A$12:'GESTION'!$AQ$25,GESTION!$G$4,0)*(GESTION!G4=40)","v":0},{"$f":"SUMIF(B12:E35,1,E12:E35)*(GESTION!G4=40)","v":0},{"$f":"VLOOKUP(99,Tant.Lots.Fds!$A$36:$O$36,8)*(GESTION!$G$4=40)","v":0},{"$f":"ROUND(D36*E36/10000,2)","v":0}]
[null,null,null,null,null,"TOTAL",{"$f":"(SUM(G12:G35)/2)+G36","v":0},{"$f":"SUM(H12:H36)","v":0},{"$f":"SUM(I12:I36)","v":0},{"$f":"SUM(J12:J36)","v":0},{"$f":"SUM(K12:K36)","v":0},{"$f":"SUM(L12:L36)","v":0},null,{"$f":"SUM(N13:N36)","v":0}]
[null,null,null,null,"Provisions",null,{"$f":"SUM(K38:N38)*-1","v":0},null,null,null,{"$f":"IF(GESTION!$G$4=8,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=16,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=24,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""},{"$f":"IF(GESTION!$G$4=32,VLOOKUP($G$2,GESTION!$A$35:$AF$54,GESTION!$G$4-1,FALSE),\"\")","v":""}]
[null,null,null,null,"Financement Fonds Travaux",null,{"$f":"I37*-1","v":0},null,null,null,8,16,24,32]
[null,null,null,"SOLDE en votre faveur…………………..",null,null,{"$f":"IF(AND(H$4<>36,G37+G38+G39<0),G37+G38+G39,0)","v":0},null,null,null,{"$f":"GESTION!$G$4","v":20},{"$f":"GESTION!$H$4","v":"1er Appel Travaux "}]
[null,null,null,"SOLDE dû au syndicat…………….",null,null,{"$f":"IF(AND($G$4<>36,G37+G38+G39>0),G37+G38+G39,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(L37>0,\"Dont T.V.A.\",\"\")","v":""},{"$f":"IF(L37<>0,L37,\"\")","v":""}]
[null,null,null,"RELEVE DE COMPTE",null,null,null,null,{"$f":"IF(M6<>0,#REF!,\"\")","v":""},null,null,"La zône grisée n' est pas destinée"]
[null,null,null,null,null,null,null,null,{"$f":"IF(M6<>0,#REF!,\"\")","v":""},null,null,"a être imprimée et diffusée."]
[null,null,"Dates","Libellés des operations",null,"DEBIT","CREDIT"]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F46:F48)","v":0},{"$f":"SUM(G46:G48)","v":0}]
[null,null,{"$f":"IF(GESTION!$G$4<>36,E6,\"\")","v":"01//12/17"},{"$f":"IF(GESTION!$G$4<>36,D8,\"\")","v":"1er Appel Travaux  Electricité"},null,{"$f":"G41","v":0},{"$f":"G40","v":0}]
[null,null,null,null,null,{"$f":"SUM(F49:F50)","v":0},{"$f":"SUM(G49:G50)","v":0}]
[null,null,null,null,{"$f":"IF(F52<G52,\"Montant à Payer\",\"Montant à votre crédit\")","v":"Montant à votre crédit"},{"$f":"IF((F51-G51)>0,F51-G51,\"\")","v":""},{"$f":"IF((G51-F51)>0,G51-F51,\"\")","v":""}]
[]
[null,null,"Avance Trésorerie","Av.Travaux","Fds Travaux ",{"$f":"IF($F$52<$G$52,\"Règlement à faire à l'ordre du Syndicat des Copropriétaires.\",\"\")","v":""}]
[null,null,{"$f":"VLOOKUP($G2,GESTION!$A$63:$C$82,3,FALSE)","v":0},{"$f":"GESTION!$B$88*E99/Tant.Lots.Fds!$H$36","v":0},{"$f":"$N$37","v":0}]
[null,null,null,null,null,"Le syndic"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"AUBERT!$C$8","v":20},{"$f":"AUBERT!$D$8","v":"1er Appel Travaux  Electricité"}]
[]
[null,"CLE","Designation",null,"V/Tantièmes",null,"V/Quote part"]
[null,1,"Charges Générales",null,{"$f":"SUMIF($B$12:$G$37,B90,$E$12:$E$37)","v":0},null,{"$f":"SUMIF($B$12:$B$36,B90,$G$12:$G$36)","v":0}]
[null,2,"Ch.Bâtiment",null,{"$f":"SUMIF($B$12:$G$37,B91,$E$12:$E$37)","v":0},null,{"$f":"SUMIF($B$12:$B$36,B91,$G$12:$G$36)","v":0}]
[null,3,"Ch.Escal.A",null,0,null,0]
[null,4,"Ch?Escal.B",null,0,null,0]
[null,5,"WW Commun",null,0,null,0]
[null,6,"Prov.Eau",null,0,null,0]
[null,7,"Cons.Eau",null,0,null,0]
[null,8,"Eau Commune",null,0,null,0]
[null,null,null,null,null,null,{"$f":"SUM(G90:G97)","v":0}]
[null,11,{"$f":"IF(GESTION!$K$1=1,\"Appel Fonds Travaux\",\"Remb,Avance Travaux\")","v":"Remb,Avance Travaux"},null,{"$f":"SUMIF($B$12:$G$37,B99,$E$12:$E$37)","v":0},null,{"$f":"SUMIF($B$12:$B$36,B99,$G$12:$G$36)","v":0}]
[null,12,"Avance de Trésorerie",null,{"$f":"SUMIF($B$12:$G$37,B100,$E$12:$E$37)","v":0},null,{"$f":"SUMIF($B$12:$B$36,B100,$G$12:$G$36)","v":0}]
[null,null,null,null,null,null,{"$f":"G98+G99+G100","v":0},{"$f":"G101+G38+G39-G40-G41","v":0}]
[]
[null,null,"Financement des travaux",null,null,null,{"$f":"G39","v":0}]

{"sheet":"CoproLots","index":14,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"LOTS PAR COPROPRIETAIRES",null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2020-10-06"}]
["Date de mise à jour 27.09.20",null,null,null,null,null,null,null,null,null,null,null,"Prov.eau","Eau Indiv."]
[]
["N°Lot","Désignation","Bât./Escal;","Etage","N°Cop","Copopriétaires","Locataires","Ch.Géné","Ch.Bât,","Escal.A","Escal.B","WC Com",2016]
[16,"Cave N° 6","1,A","SS",450.00099999999998,"AUBERT",null,40,5,79]
[25,"Appartement","1,B","2e",450.00099999999998,"AUBERT",null,780,92,null,134,null,114]
[26,"Pièce","1,B","2e",450.00099999999998,"AUBERT",null,350,41,null,60]
[null,null,null,null,"Total 450.001",null,null,{"$f":"SUBTOTAL(9,H5:H7)","v":1170},138,79,194,0,114]
[41,"Maison","A","RDC",450.00200000000001,"CARDIN",null,940,null,null,null,null,117]
[42,"Remises -Auvent","B","RDC",450.00200000000001,"CARDIN",null,100]
[43,"Remise","C","RDC",450.00200000000001,"CARDIN",null,20]
[103,"Jardin privatrif",null,null,450.00200000000001,"CARDIN",null,129]
[null,null,null,null,"Total 450.002",null,null,{"$f":"SUBTOTAL(9,H9:H12)","v":1189},0,0,0,0,117]
[13,"Cave N° 3","1,A","SS",450.00299999999999,"DUBOIS",null,230,27,429]
[18,"W.C.",1,"RDC",450.00299999999999,"DUBOIS",null,30,4]
[19,"Commerce",1,"RDC",450.00299999999999,"DUBOIS",null,910,107]
[23,"Appartement","1,B","1er",450.00299999999999,"DUBOIS",null,780,92,null,128,414]
[null,null,null,null,"Total 450.003",null,null,{"$f":"SUBTOTAL(9,H14:H17)","v":1950},230,429,128,414,0]
[12,"Cave N° 2","1,A","SS",450.005,"FONTAINE",null,40,5,79]
[17,"Cave N° 7","1,A","SS",450.005,"FONTAINE",null,40,5,79]
[21,"Appartement","1,B","1er",450.005,"FONTAINE","Dupont",760,89,null,124,401,105]
[24,"W.C.","1,B","2e",450.005,"FONTAINE",null,30,4,null,5]
[27,"Appartement","1,B","2e",450.005,"FONTAINE",null,810,95,null,139,null,100]
[null,null,null,null,"Total 450.005",null,null,{"$f":"SUBTOTAL(9,H19:H23)","v":1680},198,158,268,401,205]
[11,"Cave N° 1","1,A","SS",450.00599999999997,"HUBERT",null,70,8,127]
[28,"Appartement","1,B","3e",450.00599999999997,"HUBERT",null,2260,265,null,353,null,74]
[null,null,null,null,"Total 450.006",null,null,{"$f":"SUBTOTAL(9,H25:H26)","v":2330},273,127,353,0,74]
[15,"Cave N° 5","1,A","SS",450.00700000000001,"LONGUET",null,80,9,143]
[29,"Commerce",1,"RDC -G",450.00700000000001,"LONGUET",null,480,56,null,null,null,103]
[30,"Commerce",1,"RDC-G",450.00700000000001,"LONGUET","Cantin",430,51,null,null,null,67]
[null,null,null,null,"Total 450.007",null,null,{"$f":"SUBTOTAL(9,H28:H30)","v":990},116,143,0,0,170]
[2,"Pavillon",null,"RDC",450.00799999999998,"MARTIAL",null,300,null,null,null,null,16]
[104,"Cour privative",null,null,450.00799999999998,"MARTIAL",null,1]
[105,"Cour privative",null,null,450.00799999999998,"MARTIAL",null,9]
[106,"Cour privative",null,null,450.00799999999998,"MARTIAL",null,1]
[null,null,null,null,"Total 450.008",null,null,{"$f":"SUBTOTAL(9,H32:H35)","v":311},0,0,0,0,16]
[14,"Cave N° 4","1,A","SS",450.00900000000001,"PONTEL",null,30,4,64]
[22,"Pièce","1,B","1er",450.00900000000001,"PONTEL","Martial",350,41,null,57,185,44]
[null,null,null,null,"Total 450.009",null,null,{"$f":"SUBTOTAL(9,H37:H38)","v":380},45,64,57,185,44]
[null,null,null,null,"Total général",null,null,{"$f":"SUBTOTAL(9,H5:H38)","v":10000},1000,1000,1000,1000,740]
[]
[]
[null,null,null,null,null,""]
[null,null,null,null,null,""]

{"sheet":"Lisez-moi","index":15,"n_rows":79,"n_cols":1,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["                                                          D O C U M E N T A T I O N "]
[]
[]
["         Cette application sous EXCEL est destinée à la gestion des charges de copropriétés; Appels de charges et répartitionn de charges courantes et"]
["travaux, ainsi que la gestion de la constitution et de l' utilisation du \"Fonds travaux\"."]
[]
[]
["Feuille \"Copropriétaires\":"]
["         Cette feuille contient les coordonnés des copropriétaires, code, nom, prénom et adresse."]
["Le code et un nombre de trois caractère principaux et trois décimales (450,001 à 450,999)"]
[]
["Feuille \"TantLotsFds\""]
["          Cette feuille contient pour chaque LOT les tantièmes par clé de répartition, les consommations d' eau et les calculs de l' utilisation du fonds travaux,"]
["Le copropriétaire du lot et éventuellment le nom du locataire."]
[]
["Feuille\"Fds TravLots\""]
["          Cette feuille enregistre tous les mouvements sur le fonds travaux et donne le montant du fonds restant."]
[]
["Feuille \"Vérif\""]
["        Indique pour chaque opération la répartion par nature de charges et par copropriétaire pour chaque nature d' opération."]
["Les indications de cette feuille permettent les enregistremants en comptabilité."]
[]
["Feuille \"GESTION\""]
["         C'  est la feuille de travail, elle permet d' effectuer toutes les opérations de gestion."]
["Sur cette feuillle sont enregistrés les budgets pour charges courantes et travaux. (Il est possible d' enregistrer les montants de la TVA récupérable)"]
["Permet la réalisation des 4 appels de provisions pour charges courantes et de trois dossiers de travaux avec trois appels de provisions par dossier ainsi que la régularisation des charges."]
[]
["Fonctionnement:"]
["        Pour réaliser une opération il faut cliquer sur le bouton rose \"APPEL\" et répondre aux questions: Numéro d' appel, date d' avis et date d' exigibilité."]
["        Les opérations doivent être réalisées dans l'oredre chronoilogique, il n' est pas possible de rééditrer une opération déjà réalisée;"]
[]
[]
["GESTION DES CONSOMMATIONS D' EAU:"]
["         L' appel de provision d' eau pour le premier trimestre de l' exercice doit être fait sur le dossier de cet exercice."]
["En fin d' exercice il faut donc ouvrir un nouvau dossier, mais à cette date les consommations d' eau de l' exercice en cours ne sont pas conues, les provision s d' eau du 1er trimestre"]
["seront donc calculées sur les consommations de l' exercice N-2."]
["Pour le calcul des provisions du 2e trimestre de l' exercice le logiciel demandera d' entrer les consommations de l' exercice précédent N-1, et calculera les provisions sur ces bases."]
[]
["GESTION DU FONDS TRAVAUX:"]
["           L' abondement da Fonds travaux se fait lors des appels trimestriels de charges courantes,"]
["Le fonds travaux n' est pas remboursable, il ne peut être utilisé que pour le financement de travaux, suivant décision de l' A.G. fixant le montant du financment maximum, "]
["par rapport au montant des travaux. Le montant du financement ne peut pas dépasser le montant du fonds de chaque lot."]
["Il est possible de faire un appel spécifique au fonds travaux (Opération 41) pour capitaliser les intérêts du compte de placement, ou"]
["pour reprende une ancienne \"avance pour travaux\" transformée, sur décision d' A.G., en Fonds trravaux."]
[]
["AVANCE TRAVAUX:"]
["Il est possible de rembourser l' avance travaux pour le financement de travaux,"]
["Le' logiciel demande d' indiquer le montant à rembourser,"]
["Cette opération peut être cumulée avec le financement sur \"Fonds Travaux\"."]
[]
["CHARGES LOCATIVES:"]
["         Il est possible d' éditer des \"avis\" de charges locatives (Opération 36) qui peuvent n' être adressés qu' aux seuls copropriétaires bailleurs,"]
[]
["EXERCICE NOUVEAU:"]
["          Pour ouvrir un nouvel exercice il faut cliquer sur le bouton rouge de la feuille \"GESTION\" (En haut de la colonne \"AV\"),"]
["Un nouveau dossier est ouvert lui donner un nom faisant référence à l' année,"]
[]
["Feuille \"CoproLots\" :"]
["Cette feuille est le résultat du tri de la feuille \"Tant.Lots;Fds\" par Copropriétaire."]
["Elle comporte la date de la mise à jour de cet état,"]
["Pour mettre cet état à jour il faut cliquer sur le bouton Jaune \"ACTUALISER\""]
["Cet état permet l' établissement et le contrôle de l' affectation des lots dans les feuilles individuelles"]
[]
["Exercice Nouveau:"]
["Cette opération doit être réalisée en fin d' exercice,  et avant clôture, pour réakiser le premier appel,"]
[]
["Nouveau dossier:"]
["Il faut créer un nouvel exercice et ensuite mettre à jour les dossiers \" Copropriétaires\" et les affectations de lots dans les feuilles \"copropriétaires\","]
[]
["PROTECTION FEUILLE:"]
["         N' utiliser le bouton vert \"Protection Feuille\"  que si le dossier de l' exercice précédent est définitivement clos;"]
["Cette opération est facultative."]
[]
[]
["A jour au 06/10/20"]
["Jean Braconnier"]