{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Procédure","Page d'entête","Tableau à compléter","Calcul revenus terres","Tableau exemple"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"comments":2,"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":"Procédure","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Page d'entête","index":1,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[[17,1,17,6],[3,0,3,6],[14,0,14,6],[21,0,21,5]]}
[]
[]
[]
["DIOCÈSE DE NAMUR"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["OBITUAIRE DE L' ÉGLISE"]
[]
[]
["de"]
[]
[]
[]
["Coordonnées de la personne qui a établi l'obituaire :"]
[]
["Nom et Prénom :"]
["Fonction :"]
["Tél ou gsm :"]
["Adresse postale :"]
["Adresse e-mail :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"ÉVÊCHÉ DE NAMUR"]

{"sheet":"Tableau à compléter","index":2,"n_rows":217,"n_cols":10,"rows_kept":217,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,1,3,2],[4,3,4,4],[216,6,216,7],[7,6,8,7],[8,4,13,4],[11,5,13,5],[7,4,7,5],[215,6,215,7]]}
[]
[null,"Taux d'intérêts net moyen :",null,1.1000000000000001E-3]
[]
[]
["Etat des fondations de la paroisse de  ",null,null,{"$f":"'Page d''entête'!B18","v":0}]
[]
[1,2,3,4,"5 A","5 B","6 A","6 B",7]
[null,"NOMS DES FONDATEURS",null,"DOTATIONS PRIMITIVES ","DOTATIONS ACTUELLES EN CAPITAL OU EN IMMEUBLES",null,"REVENU ACTUEL\nNET"]
["Num","ou DES PERSONNES",null,"EN CAPITAL :","à ne compléter qu'en cas de changements intervenus (vente, échange ou remembrement de terrains, renforcement de capital,…) "]
[null,"pour qui on doit acquitter","DESIGNATION DES CHARGES","anciennes en BEF : simplement le montant en chiffre",null,"conversion","TERRAINS","CAPITAUX"]
[null,"les fondations","DE CHAQUE FONDATION","nouvelles fondations en euro : encoder le montant",null,"en €",null,"Taux ","OBSERVATIONS"]
[null,"-----------------------------------------------","TELLES QUE LES FONDATEURS ","suivi de la mention euros et à la colonne 5B encoder",null,"(de la colonne 4)",null,"d'intérêt"]
[null,"Date","LES ONTS ETABLIES","seulement le montant en chiffre",null,null,null,"net moyen"]
[null,"DE L'APPROBATION EPISCOPALE",null,"OU EN IMMEUBLES avec indications cadastrales",null,null,null,{"$f":"D2","v":1.1000000000000001E-3}]
[1,null,null,null,null,{"$f":"IF(ISTEXT(D15),\"\",ROUND(D15/40.3399,2))","v":0},null,{"$f":"IF(ISTEXT(F15),0,ROUND(F15*$H$14,2))","v":0},null,{"$f":"IF(G15+H15>=2.6,G15+H15,0)","v":0}]
[{"$f":"A15+1","v":2},null,null,null,null,{"$f":"IF(ISTEXT(D16),\"\",ROUND(D16/40.3399,2))","v":0},null,{"$f":"IF(ISTEXT(F16),0,F16*$H$14)","v":0},null,{"$f":"IF(G16+H16>=2.6,G16+H16,0)","v":0}]
[3,null,null,null,null,0,null,0,null,0]
[4,null,null,null,null,0,null,0,null,0]
[5,null,null,null,null,0,null,0,null,0]
[6,null,null,null,null,0,null,0,null,0]
[7,null,null,null,null,0,null,0,null,0]
[8,null,null,null,null,0,null,0,null,0]
[9,null,null,null,null,0,null,0,null,0]
[10,null,null,null,null,0,null,0,null,0]
[11,null,null,null,null,0,null,0,null,0]
[12,null,null,null,null,0,null,0,null,0]
[13,null,null,null,null,0,null,0,null,0]
[14,null,null,null,null,0,null,0,null,0]
[15,null,null,null,null,0,null,0,null,0]
[16,null,null,null,null,0,null,0,null,0]
[17,null,null,null,null,0,null,0,null,0]
[18,null,null,null,null,0,null,0,null,0]
[19,null,null,null,null,0,null,0,null,0]
[20,null,null,null,null,0,null,0,null,0]
[21,null,null,null,null,0,null,0,null,0]
[22,null,null,null,null,0,null,0,null,0]
[23,null,null,null,null,0,null,0,null,0]
[24,null,null,null,null,0,null,0,null,0]
[25,null,null,null,null,0,null,0,null,0]
[26,null,null,null,null,0,null,0,null,0]
[27,null,null,null,null,0,null,0,null,0]
[28,null,null,null,null,0,null,0,null,0]
[29,null,null,null,null,0,null,0,null,0]
[30,null,null,null,null,0,null,0,null,0]
[31,null,null,null,null,0,null,0,null,0]
[32,null,null,null,null,0,null,0,null,0]
[33,null,null,null,null,0,null,0,null,0]
[34,null,null,null,null,0,null,0,null,0]
[35,null,null,null,null,0,null,0,null,0]
[36,null,null,null,null,0,null,0,null,0]
[37,null,null,null,null,0,null,0,null,0]
[38,null,null,null,null,0,null,0,null,0]
[39,null,null,null,null,0,null,0,null,0]
[40,null,null,null,null,0,null,0,null,0]
[41,null,null,null,null,0,null,0,null,0]
[42,null,null,null,null,0,null,0,null,0]
[43,null,null,null,null,0,null,0,null,0]
[44,null,null,null,null,0,null,0,null,0]
[45,null,null,null,null,0,null,0,null,0]
[46,null,null,null,null,0,null,0,null,0]
[47,null,null,null,null,0,null,0,null,0]
[48,null,null,null,null,0,null,0,null,0]
[49,null,null,null,null,0,null,0,null,0]
[50,null,null,null,null,0,null,0,null,0]
[51,null,null,null,null,0,null,0,null,0]
[52,null,null,null,null,0,null,0,null,0]
[53,null,null,null,null,0,null,0,null,0]
[54,null,null,null,null,0,null,0,null,0]
[55,null,null,null,null,0,null,0,null,0]
[56,null,null,null,null,0,null,0,null,0]
[57,null,null,null,null,0,null,0,null,0]
[58,null,null,null,null,0,null,0,null,0]
[59,null,null,null,null,0,null,0,null,0]
[60,null,null,null,null,0,null,0,null,0]
[61,null,null,null,null,0,null,0,null,0]
[62,null,null,null,null,0,null,0,null,0]
[63,null,null,null,null,0,null,0,null,0]
[64,null,null,null,null,0,null,0,null,0]
[65,null,null,null,null,0,null,0,null,0]
[66,null,null,null,null,{"$f":"IF(ISTEXT(D80),\"\",ROUND(D80/40.3399,2))","v":0},null,{"$f":"IF(ISTEXT(F80),0,F80*$H$14)","v":0},null,{"$f":"IF(G80+H80>=2.6,G80+H80,0)","v":0}]
[67,null,null,null,null,0,null,0,null,0]
[68,null,null,null,null,0,null,0,null,0]
[69,null,null,null,null,0,null,0,null,0]
[70,null,null,null,null,0,null,0,null,0]
[71,null,null,null,null,0,null,0,null,0]
[72,null,null,null,null,0,null,0,null,0]
[73,null,null,null,null,0,null,0,null,0]
[74,null,null,null,null,0,null,0,null,0]
[75,null,null,null,null,0,null,0,null,0]
[76,null,null,null,null,0,null,0,null,0]
[77,null,null,null,null,0,null,0,null,0]
[78,null,null,null,null,0,null,0,null,0]
[79,null,null,null,null,0,null,0,null,0]
[80,null,null,null,null,0,null,0,null,0]
[81,null,null,null,null,0,null,0,null,0]
[82,null,null,null,null,0,null,0,null,0]
[83,null,null,null,null,0,null,0,null,0]
[84,null,null,null,null,0,null,0,null,0]
[85,null,null,null,null,0,null,0,null,0]
[86,null,null,null,null,0,null,0,null,0]
[87,null,null,null,null,0,null,0,null,0]
[88,null,null,null,null,0,null,0,null,0]
[89,null,null,null,null,0,null,0,null,0]
[90,null,null,null,null,0,null,0,null,0]
[91,null,null,null,null,0,null,0,null,0]
[92,null,null,null,null,0,null,0,null,0]
[93,null,null,null,null,0,null,0,null,0]
[94,null,null,null,null,0,null,0,null,0]
[95,null,null,null,null,0,null,0,null,0]
[96,null,null,null,null,0,null,0,null,0]
[97,null,null,null,null,0,null,0,null,0]
[98,null,null,null,null,0,null,0,null,0]
[99,null,null,null,null,0,null,0,null,0]
[100,null,null,null,null,0,null,0,null,0]
[101,null,null,null,null,0,null,0,null,0]
[102,null,null,null,null,0,null,0,null,0]
[103,null,null,null,null,0,null,0,null,0]
[104,null,null,null,null,0,null,0,null,0]
[105,null,null,null,null,0,null,0,null,0]
[106,null,null,null,null,0,null,0,null,0]
[107,null,null,null,null,0,null,0,null,0]
[108,null,null,null,null,0,null,0,null,0]
[109,null,null,null,null,0,null,0,null,0]
[110,null,null,null,null,0,null,0,null,0]
[111,null,null,null,null,0,null,0,null,0]
[112,null,null,null,null,0,null,0,null,0]
[113,null,null,null,null,0,null,0,null,0]
[114,null,null,null,null,0,null,0,null,0]
[115,null,null,null,null,0,null,0,null,0]
[116,null,null,null,null,0,null,0,null,0]
[117,null,null,null,null,0,null,0,null,0]
[118,null,null,null,null,0,null,0,null,0]
[119,null,null,null,null,0,null,0,null,0]
[120,null,null,null,null,0,null,0,null,0]
[121,null,null,null,null,0,null,0,null,0]
[122,null,null,null,null,0,null,0,null,0]
[123,null,null,null,null,0,null,0,null,0]
[124,null,null,null,null,0,null,0,null,0]
[125,null,null,null,null,0,null,0,null,0]
[126,null,null,null,null,0,null,0,null,0]
[127,null,null,null,null,0,null,0,null,0]
[128,null,null,null,null,0,null,0,null,0]
[129,null,null,null,null,0,null,0,null,0]
[130,null,null,null,null,{"$f":"IF(ISTEXT(D144),\"\",ROUND(D144/40.3399,2))","v":0},null,{"$f":"IF(ISTEXT(F144),0,F144*$H$14)","v":0},null,{"$f":"IF(G144+H144>=2.6,G144+H144,0)","v":0}]
[131,null,null,null,null,0,null,0,null,0]
[132,null,null,null,null,0,null,0,null,0]
[133,null,null,null,null,0,null,0,null,0]
[134,null,null,null,null,0,null,0,null,0]
[135,null,null,null,null,0,null,0,null,0]
[136,null,null,null,null,0,null,0,null,0]
[137,null,null,null,null,0,null,0,null,0]
[138,null,null,null,null,0,null,0,null,0]
[139,null,null,null,null,0,null,0,null,0]
[140,null,null,null,null,0,null,0,null,0]
[141,null,null,null,null,0,null,0,null,0]
[142,null,null,null,null,0,null,0,null,0]
[143,null,null,null,null,0,null,0,null,0]
[144,null,null,null,null,0,null,0,null,0]
[145,null,null,null,null,0,null,0,null,0]
[146,null,null,null,null,0,null,0,null,0]
[147,null,null,null,null,0,null,0,null,0]
[148,null,null,null,null,0,null,0,null,0]
[149,null,null,null,null,0,null,0,null,0]
[150,null,null,null,null,0,null,0,null,0]
[151,null,null,null,null,0,null,0,null,0]
[152,null,null,null,null,0,null,0,null,0]
[153,null,null,null,null,0,null,0,null,0]
[154,null,null,null,null,0,null,0,null,0]
[155,null,null,null,null,0,null,0,null,0]
[156,null,null,null,null,0,null,0,null,0]
[157,null,null,null,null,0,null,0,null,0]
[158,null,null,null,null,0,null,0,null,0]
[159,null,null,null,null,0,null,0,null,0]
[160,null,null,null,null,0,null,0,null,0]
[161,null,null,null,null,0,null,0,null,0]
[162,null,null,null,null,0,null,0,null,0]
[163,null,null,null,null,0,null,0,null,0]
[164,null,null,null,null,0,null,0,null,0]
[165,null,null,null,null,0,null,0,null,0]
[166,null,null,null,null,0,null,0,null,0]
[167,null,null,null,null,0,null,0,null,0]
[168,null,null,null,null,0,null,0,null,0]
[169,null,null,null,null,0,null,0,null,0]
[170,null,null,null,null,0,null,0,null,0]
[171,null,null,null,null,0,null,0]
[172,null,null,null,null,0,null,0,null,0]
[173,null,null,null,null,0,null,0,null,0]
[174,null,null,null,null,0,null,0,null,0]
[175,null,null,null,null,0,null,0,null,0]
[176,null,null,null,null,{"$f":"IF(ISTEXT(D190),\"\",D190/40.3399)","v":0},null,{"$f":"IF(ISTEXT(F190),0,F190*$H$14)","v":0},null,{"$f":"IF(G190+H190>=2.6,G190+H190,0)","v":0}]
[177,null,null,null,null,0,null,0,null,0]
[178,null,null,null,null,0,null,0,null,0]
[179,null,null,null,null,0,null,0,null,0]
[180,null,null,null,null,0,null,0,null,0]
[181,null,null,null,null,0,null,0,null,0]
[182,null,null,null,null,0,null,0,null,0]
[183,null,null,null,null,0,null,0,null,0]
[184,null,null,null,null,0,null,0,null,0]
[185,null,null,null,null,0,null,0,null,0]
[186,null,null,null,null,0,null,0,null,0]
[187,null,null,null,null,0,null,0,null,0]
[188,null,null,null,null,0,null,0,null,0]
[189,null,null,null,null,0,null,0,null,0]
[190,null,null,null,null,0,null,0,null,0]
[191,null,null,null,null,0,null,0,null,0]
[192,null,null,null,null,0,null,0,null,0]
[193,null,null,null,null,0,null,0,null,0]
[194,null,null,null,null,{"$f":"IF(ISTEXT(D208),\"\",D208/40.3399)","v":0},null,{"$f":"IF(ISTEXT(F208),0,F208*$H$14)","v":0},null,{"$f":"IF(G208+H208>=2.6,G208+H208,0)","v":0}]
[195,null,null,null,null,0,null,0,null,0]
[196,null,null,null,null,0,null,0,null,0]
[197,null,null,null,null,0,null,0,null,0]
[198,null,null,null,null,0,null,0,null,0]
[199,null,null,null,null,0,null,0,null,0]
[200,null,null,null,null,0,null,0,null,0]
[null,".",null,null,null,{"$f":"SUM(F15:F212)","v":0},{"$f":"SUM(G15:G214)","v":0},{"$f":"SUM(H15:H214)","v":0},null,{"$f":"SUM(J15:J214)","v":0}]
[null,";",null,null,null,null,"Total des revenus",null,"COLLECTIF"]
[null,";",null,null,null,null,{"$f":"G215+H215","v":0},null,{"$f":"G217-J215","v":0}]

{"sheet":"Calcul revenus terres","index":3,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,1,5,9],[9,1,9,2],[37,1,37,10],[7,1,7,2],[8,1,8,2]]}
[]
[]
[null,"Ce tableau peut être utilisé afin de calculer le revenu net des terres comme prévu dans la procédure à suivre"]
[]
[]
[]
[]
[null,"Votre coefficient géographique:",null,3.51]
[null,"le coefficient d'indexation",null,2.0914999999999999]
[null,"Votre pourcentage d'imposition total",null,0.52312499999999995]
[]
[null,null,null,1,2,3,4,5,6,7,8]
[null,null,null,null,null,"(1 x 2)",null,"(1x 4)",null,"(5 x 6)","(3-7)"]
[null,"FONDATION","Renseignements relatifs aux biens immobiliers (dénomination, matrice cadastrale, superficie, RC)","RC","Coeficient","Fermage légal à demander aux locataires","Index","Arrondi \nRC Indexé","Taux Précompte","PI","Revenu NET"]
["Exemple",29,"Champs d'ouge Section  A 736 de 24a45 ",9,{"$f":"IF(D15<=0,0,$D$8)","v":3.51},{"$f":"INT(D15)*E15","v":31.589999999999996},{"$f":"IF(F15<=0,0,$D$9)","v":2.0914999999999999},{"$f":"ROUND(INT(D15)*G15,0)","v":19},{"$f":"IF(H15<=0,0,$D$10)","v":0.52312499999999995},{"$f":"H15*I15","v":9.9393749999999983},{"$f":"ROUND(F15-J15,2)","v":21.65}]
[null,null,null,null,0,0,0,{"$f":"ROUND(INT(D16)*G16,0)","v":0},0,0,{"$f":"ROUND(F16-J16,2)","v":0}]
[null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0]
[]
[]
["!!!!","Attention vous ne devez remplir que le RC dans le tableau ci-dessus après avoir encodé le coefficient géographique, le coefficient d'indexation et le pourcentage d'imposition total "]
[]
[null,"Pour info, dans ce tableau, le Revenu net se calcule sur base du RC arrondi à l'unité inférieure"]

{"sheet":"Tableau exemple","index":4,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[9,6,10,7],[8,6,8,7],[8,4,8,5],[9,4,9,5],[10,4,15,4],[13,5,15,5],[1,1,1,2],[2,1,2,2],[3,1,3,2],[6,3,6,5],[17,0,19,0],[17,1,19,1]]}
[]
[null,"Taux d'intérêts net moyen :",null,3.2000000000000001E-2]
[]
[]
[]
[]
["Etat des fondations de la paroisse de  ",null,null,"NAMUR"]
[]
[1,2,3,4,5,null,6,null,7]
["Num","NOMS DES FONDATEURS",null,"DOTATIONS PRIMITIVES ","DOTATIONS ACTUELLES EN CAPITAL OU EN IMMEUBLES",null,"REVENU ACTUEL\nNET"]
[null,"ou DES PERSONNES",null,"EN CAPITAL :","à ne compléter qu'en cas de changements intervenus (vente, échange ou remembrement de terrains, renforcement de capital,…) "]
[null,"pour qui on doit acquitter","DESIGNATION DES CHARGES","anciennes en BEF : simplement le montant en chiffre",null,"conversion","TERRAINS","CAPITAUX"]
[null,"les fondations","DE CHAQUE FONDATION","nouvelles fondations en euro : encoder le montant",null,"en €",null,"Taux ","OBSERVATIONS"]
[null,null,"TELLES QUE LES FONDATEURS ","suivi de la mention euros et à la colonne 5B encoder",null,null,null,"d'intérêt"]
[null,"Date","LES ONTS ETABLIES","seulement le montant en chiffre",null,null,null,"net moyen"]
[null,"DE L'APPROBATION EPISCOPALE",null,"OU EN IMMEUBLES avec indications cadastrales",null,null,null,{"$f":"D2","v":3.2000000000000001E-2}]
[1,"DEOM Madeleine, 13-02-1886","2 messes hautes le 15 juillet et le 12 août",500,null,{"$f":"IF(ISTEXT(D17),\"\",D17/40.3399)","v":12.394676238661971},null,{"$f":"IF(ISTEXT(F17),0,F17*$H$16)","v":0.39662963963718306}]
[2,"Famille Eugène Dupont-Matagne  de 1815",null,1000,null,{"$f":"IF(ISTEXT(D18),\"\",D18/40.3399)","v":24.789352477323941},null,{"$f":"IF(ISTEXT(F18),0,F18*$H$16)","v":0.79325927927436612},null,null,{"$f":"IF(H18+G18>=1.8,H18+G18,0)","v":0}]
[null,null,"2 messes basses par an","1) BOUGE aux concis sect C0086 D de 16a50ca\nRC : 6 €",null,{"$f":"IF(ISTEXT(D19),\"\",D19/40.3399)","v":""},9.1999999999999993,{"$f":"IF(ISTEXT(F19),0,F19*$H$16)","v":0},null,null,{"$f":"IF(H19+G19>=1.8,H19+G19,0)","v":9.1999999999999993}]
[null,null,null,"2) UOUTERLISSE Terre \nA 0335 de 17a05cc \nRC : 5 €",null,{"$f":"IF(ISTEXT(D20),\"\",D20/40.3399)","v":""},"non loué",{"$f":"IF(ISTEXT(F20),0,F20*$H$16)","v":0},null,null,{"$f":"IF(H20+G20>=1.8,H20+G20,0)","v":{"$error":"#VALUE!"}}]
[3,"M. et Mme GRANDJEAN Maurice, 06-08-1980","des messes au prorata","1 terrain 'Sur le tige'  E346D de 20a15 RC 8 €","Echangé le 14-02-2006 avec le terrain 'Sur la Colline' sect A242c de 18a42ca RC 9 €",{"$f":"IF(ISTEXT(D21),\"\",D21/40.3399)","v":""},15.85]
[4,"MARECHAL Ernest 12/03/1941","2 mb tous les mois pour sa sœur, son frère et son neveu","1 terrain 'Pré sur le champ' de 10a50, F256D,RC 5€","vendu le 15-05-2007 pour la somme de 10.000€",10000,null,{"$f":"IF(ISTEXT(F22),0,F22*$H$16)","v":320},null,null,{"$f":"IF(H22+G22>=1.8,H22+G22,0)","v":320}]
[5,"RENARD MP mars 2018","des messes au prorata","500 euros",null,500,null,{"$f":"IF(ISTEXT(F23),0,F23*$H$16)","v":16}]