{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ورقة1 (3)"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":6,"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":"ورقة1 (3)","index":0,"n_rows":180,"n_cols":21,"rows_kept":180,"cut":false,"hidden":false,"merged":[[15,7,18,7],[14,1,14,6],[11,2,11,5],[9,2,9,5],[2,1,2,6],[23,1,23,6],[10,2,10,5],[12,2,12,5],[3,1,3,3],[3,5,3,6],[7,1,7,3],[7,5,7,6]]}
[]
[null," "]
[]
[null,"تركة المرحوم (ة)/ ",null,null,null,"احمد محمد احمد محمد "]
[]
[]
[]
[]
[]
[null,"م","البيــــــــــــــــــــــــــــــــــــــــــــــــــان    ",null,null,null,"المبلغ"]
[null,null,"اجمالى قيمة التركــــــــــــــــــة",null,null,null,3000]
[null,"-",null,null,null,null,0,null,{"$f":"G11*0.003","v":9},"الأب","نصيب/"]
[null,null,"صافى قيمة التركة بعد العمولة ",null,null,null,{"$f":"G11-G12","v":3000},null,null,"الأم","نصيب/"]
[null,null,null,null,null,null,null,null,null,"الزوج"]
[null,"أنصبة التركة / توزيع أصحـــــــــــــــاب الفروض ",null,null,null,null,null,null,{"$f":"G13/3","v":1000},"الزوجة"]
[null,null,"نصيب/","الزوجة","الربع","اااااااااا",{"$f":"IF(E16=\"الثمن\",$G$13*1/8,IF(E16=\"الثلث\",$G$13*1/3,IF(E16=\"الربع\",$G$13*1/4,IF(E16=\"النصف\",$G$13*1/2,\"\"))))","v":750},"        المطلوب عند اختيار الثلث من خلية E16 يتم احتساب نصيب فى خانةG16 = G13 صافى التركة * الثلث 3/1",{"$f":"G13/3","v":1000},"الجدة لأمه"]
[null,null,null,null,"الثمن",null,{"$f":"IF(E17=\"الثمن\",$G$13*1/8,IF(E17=\"الثلث\",$G$13*1/3,IF(E17=\"الربع\",$G$13*1/4,IF(E17=\"النصف\",$G$13*1/2,\"\"))))","v":375},null,{"$f":"G13/6","v":500},"الجدة لأبيه"]
[null,null,null,null,null,null,"",null,{"$f":"G13/6","v":500},"الأخ لأمه"," "]
[null,null,null,null,null,null,"",null,{"$f":"G13/8","v":375},"الأخت لأمها"]
[null,null,null,null,null,null,"",null,{"$f":"G13/4","v":750},null,null,null,null,null,"`"]
[null,null,null,null,null,null,{"$f":"SUM(G16:G20)","v":1125}]
[null,null,null,null,null,"الرصيد المتبقى",{"$f":"G13-G21","v":1875}]
[]
[null,"أنصبة التركة / قسم يرث بالتعصيب ",null,null,null,null,null,null,null,"النصف"]
[null,2,null,null,null,null,6.19,null,null,"الثمن"]
[null,3,null,null,null,null,6.2,null,null,"الثلث"]
[null,4,null,null,null,null,6.2,null,null,"الربع"]
[null,5,null,null,null,null,3.1]
[null,6,null,null,null,null,3.1]
[null,7,null,null,null,null,3.09,null,null,null,null,null,null,null,null,null,null,null,null,null,"ا"]
[null,8,null,null,null,null,3.1]
[null,9]
[null,10,null,null,null,null,{"$f":"SUM(G24:G31)","v":30.980000000000004}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"حساب رقم 40.501.30431"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"البيان    ","المبلغ"]
[null,null,null,null,null,null,null,null,null,null,null,"اجمالى قيمة التركــــــــــــــــــة_",52811.97]
[null,null,null,null,null,null,null,null,null,null,null,"ناقص عمولة تصفية التركة 03%",{"$f":"M129*3/1000","v":158.43591000000001}]
[null,null,null,null,null,null,null,null,null,null,null,"                    الصافى القابل للتوزيع",{"$f":"M129-M130","v":52653.534090000001}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"تصيب  الاب ( السدس)      ",0]
[null,null,null,null,null,null,null,null,null,null,null,"نصيب الام (السدس) "]
[null,null,null,null,null,null,null,null,null,null,null,"نصيب الزوجه ( الثمن) تهانى عثمان محمد",{"$f":"M131/8","v":6581.6917612500001},null,"تم الصرف بموجب اذن صرف رقم            بتاريخ       /      /2006  "]
[null,null,null,null,null,null,null,null,null,null,null,"اجمالى الانصبة عاليه",{"$f":"M133+M134+M135","v":6581.6917612500001}]
[null,null,null,null,null,null,null,null,null,null,null,"الرصيد المتبقى",{"$f":"M131-M136","v":46071.842328750005}]
[]
[null,null,null,null,null,null,null,null,null,null,1,"االسيد ه/ سهير شحاته موسى ",{"$f":"M140","v":5119.0935920833335},null,"تم الصرف بموجب اذن صرف رقم            بتاريخ       /      /2006  "]
[null,null,null,null,null,null,null,null,null,null,2,"السيده/  وفاء شحاتة موسى",{"$f":"P147","v":5119.0935920833335},null,"تم الصرف بموجب اذن صرف رقم            بتاريخ       /      /2006  "]
[null,null,null,null,null,null,null,null,null,null,3,"السيده/ صفاء شحاتة موسى",{"$f":"M140","v":5119.0935920833335},null,"تم الصرف بموجب اذن صرف رقم            بتاريخ       /      /2006  "]
[null,null,null,null,null,null,null,null,null,null,4,"السيد/ سمير شحاتة موسى",{"$f":"P148","v":10238.187184166667},null,"تم الصرف بموجب اذن صرف رقم            بتاريخ       /      /2006  "]
[null,null,null,null,null,null,null,null,null,null,5,"السيد/ عزت شحاتة موسى",{"$f":"M142","v":10238.187184166667},null,"البيان","عدد"]
[null,null,null,null,null,null,null,null,null,null,6,"السيد/ عماد شحاتة موسى",{"$f":"M143","v":10238.187184166667},null,"ذكور",3]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,"اناث",3]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,"الاجمالى",{"$f":"P144*2+P145","v":9}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,"نصيب الفرد",{"$f":"M137/P146","v":5119.0935920833335}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M139:M147)","v":46071.842328749997},null,"نصيب الذكر",{"$f":"P147*2","v":10238.187184166667}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"نصيب البنت",{"$f":"P147*1","v":5119.0935920833335}]
[]
[]
[]
[]
[]
[null,"بنك القاهرة - فرع الالفى"]
[null,null,null,null,null,"تصفية تركة السيد /"]
[null,"حساب رقم  "]
[]
[null,null,null,null,null,"البيان    ","المبلغ"]
[null,null,null,null,null,"اجمالى قيمة التركــــــــــــــــــة_",100000]
[null,null,null,null,null,"ناقص عمولة تصفية التركة 03%",{"$f":"G160*0.003","v":300}]
[null,null,null,null,null,"                    الصافى القابل للتوزيع",{"$f":"G160-G161","v":99700}]
[]
[null,null,null,null,null,"تصيب  الاب ( السدس)      ",0]
[null,null,null,null,null,"نصيب الام (السدس)",0]
[null,null,null,null,null,"نصيب الزوجه ( الثمن)",0]
[null,null,null,null,null,"اجمالى الانصبة عاليه",{"$f":"G164+G165+G166","v":0}]
[null,null,null,null,null,"الرصيد المتبقى",{"$f":"G162-G167","v":99700}]
[null,null,null,null,null,null,null,null,"البيان",null,"عدد"]
[null,1,null,null,null,"االسيد /",0,null,"ذكور",null,1]
[null,2,null,null,null,"السيد/",0,null,"اناث",null,0]
[null,3,null,null,null,"القاصر",0,null,"الاجمالى",null,{"$f":"K170*2+K171","v":2}]
[null,4,null,null,null,"السيدة /",0,null,"نصيب الفرد",null,{"$f":"G168/K172","v":49850}]
[null,5,null,null,null,null,0,null,"نصيب الذكر",null,{"$f":"K173*2","v":99700}]
[null,6,null,null,null,null,0,null,"نصيب البنت",null,{"$f":"K173*1","v":49850}]
[null,7,null,null,null,null,0]
[null,8,null,null,null,null,0]
[null,9,null,null,null,null,0]
[null,10,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"SUM(G170:G179)","v":0}]