{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["mokhtar","Feuil2","Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"mokhtar","index":0,"n_rows":46,"n_cols":17,"rows_kept":46,"cut":false,"hidden":false,"merged":[[24,8,24,13],[26,8,26,13],[28,8,28,13]]}
["n°","Nom ","Prénom","CIN","Adresse","Ville","Lien de parenté avec le défunt","parts dans l'héritage","QP dans les biens à partager","n° du bien","Nom du bien","Valeur du bien ","Nom du bien","Valeur du bien ","Différence","Soulte à verser ","Soultes à encaisser"]
[1,"a","Mohammed",null,null,null,null,21,{"$f":"Tvaleurs *H2/Tparts","v":109821.42857142857},1,{"$f":"VLOOKUP(J2,Biens,2,FALSE)","v":"TF 777 77"},{"$f":"VLOOKUP(J2,Biens,6,FALSE)","v":110000},{"$f":"IF(ISNUMBER(L2),K2, \"\")","v":"TF 777 77"},{"$f":"IF(ISNUMBER(L2),L2, 0)","v":110000},{"$f":"I2-N2","v":-178.57142857143481},{"$f":"MAX(0, - O2)","v":178.57142857143481},{"$f":"MAX(0, O2)","v":0}]
[2,"b","Abdellah",null,null,null,null,23,120280.61224489796,2,"TF 6666  66",120000,{"$f":"IF(ISNUMBER(L3),K3, \"\")","v":"TF 6666  66"},{"$f":"IF(ISNUMBER(L3),L3, 0)","v":120000},{"$f":"I3-N3","v":280.61224489795859},{"$f":"MAX(0, - O3)","v":0},{"$f":"MAX(0, O3)","v":280.61224489795859}]
[3,"B","Abdelkrim",null,null,null,null,25,130739.79591836735,3,"TF 8765 65",130000,"TF 8765 65",130000,739.79591836735199,0,739.79591836735199]
[4,"a","Aberrazzaq",null,null,null,null,27,141198.97959183675,4,"TF  32123 33",140000,"TF  32123 33",140000,1198.9795918367454,0,1198.9795918367454]
[5,"b","Adil",null,null,null,null,29,151658.16326530612,5,"TF 432111",150000,"TF 432111",150000,1658.1632653061242,0,1658.1632653061242]
[6,"c","Bachir",null,null,null,null,31,162117.3469387755,6,55,160000,55,160000,2117.3469387755031,0,2117.3469387755031]
[7,"a","françois",null,null,null,null,32,167346.93877551021,7,{"$f":"VLOOKUP(J8,Biens,2,FALSE)","v":56},{"$f":"VLOOKUP(J8,Biens,6,FALSE)","v":170000},{"$f":"IF(ISNUMBER(L8),K8, \"\")","v":56},{"$f":"IF(ISNUMBER(L8),L8, 0)","v":170000},-2653.0612244897929,2653.0612244897929,0]
[8,"b","Grégoire",null,null,null,null,34,177806.12244897959,8,57,180000,57,180000,-2193.8775510204141,2193.8775510204141,0]
[9,"c","Henri",null,null,null,null,36,188265.30612244899,9,58,190000,58,190000,-1734.6938775510062,1734.6938775510062,0]
[10,"a","Irène",null,null,null,null,38,198724.48979591837,10,59,200000,59,200000,-1275.5102040816273,1275.5102040816273,0]
[11,"b","Jacques",null,null,null,null,40,209183.67346938775,11,60,210000,60,210000,-816.32653061224846,816.32653061224846,0]
[12,"c","Karène",null,null,null,null,42,219642.85714285713,12,61,220000,61,220000,-357.14285714286962,357.14285714286962,0]
[13,"a","Laurent",null,null,null,null,44,230102.04081632654,13,62,230000,62,230000,102.04081632653833,0,102.04081632653833]
[14,"b","Mariane",null,null,null,null,46,240561.22448979592,14,63,240000,63,240000,561.22448979591718,0,561.22448979591718]
[15,"c","Nelly",null,null,null,null,48,251020.4081632653,15,64,250000,64,250000,1020.408163265296,0,1020.408163265296]
[16,"a","Oscar",null,null,null,null,50,261479.5918367347,16,65,260000,65,260000,1479.591836734704,0,1479.591836734704]
[17,"b","Paul",null,null,null,null,52,271938.77551020408,17,66,270000,66,270000,1938.7755102040828,0,1938.7755102040828]
[18,"c","Robert",null,null,null,null,54,282397.95918367349,18,67,280000,67,280000,2397.9591836734908,0,2397.9591836734908]
[19,"a","Suzane",null,null,null,null,55,287627.55102040817,19,68,290000,68,290000,-2372.4489795918344,2372.4489795918344,0]
[20,"b","Thierry",null,null,null,null,57,298086.73469387757,20,69,300000,69,300000,-1913.2653061224264,1913.2653061224264,0]
[null,null,null,null,null,null,"totaux",{"$f":"SUM(H2:H21)","v":784},{"$f":"SUM(I2:I21)","v":4099999.9999999995},null,null," ",null,{"$f":"SUM(N2:N21)","v":4100000},{"$f":"SUM(O2:O21)","v":5.8207660913467407E-11},{"$f":"SUM(P2:P21)","v":13494.897959183654},13494.897959183712]
[null,null,null,null,null,null,null,"Valeur de la part ",{"$f":"I22/Tparts","v":5229.5918367346931}]
[]
["n°","Désignation","Description","Date acquisition","Valeur acquisition","Valeur actuelle"," ",null,"En cas de besoin, posez vos questions sur "]
[1,"TF 777 77","appartement 15",null,null,110000]
[2,"TF 6666  66","magasin daoura",null,null,120000,null,null,"le forum www.maroc-compta.net "]
[3,"TF 8765 65","terrain tit mellil",null,null,130000,null,null," "]
[4,"TF  32123 33","appartement 17",null,null,140000,null,null," "]
[5,"TF 432111","maison berrechid",null,null,150000]
[6,55,"AAA",null,null,160000]
[7,56,null,null,null,170000,null,5]
[8,57,null,null,null,180000]
[9,58,null,null,null,190000]
[10,59,null,null,null,200000]
[11,60,null,null,null,210000]
[12,61,null,null,null,220000]
[13,62,null,null,null,230000]
[14,63,null,null,null,240000]
[15,64,null,null,null,250000]
[16,65,null,null,null,260000]
[17,66,null,null,null,270000]
[18,67,null,null,null,280000]
[19,68,null,null,null,290000]
[20,69,null,null,null,300000]
[null,null,null,null,"Valeur total des biens à affecter",{"$f":"+SUM(F26:F45)","v":4100000}]

{"sheet":"Feuil2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}