{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ورقة1","ورقة2","ورقة3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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","index":0,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,3,2,3],[11,0,11,1],[1,0,2,0],[1,1,1,2]]}
[null,null,null,null,null,null,null,null," =Salim_Dariba(F4,$G$2,$H$2,$I$2,$J$2)"]
["م ","الشرائح",null,"النسبة"]
[null,"من","الى"]
[1,1,11000,1.4999999999999999E-2,null,11000,{"$f":"Salim_Dariba(F4,$D$4,$D$5,$D$6,$D$7)","v":165},null,null,null,null,30000,null,{"$f":"Salim_Dariba(L4,$D$4,$D$5,$D$6,$D$7)","v":2840}]
[2,11001,18500,0.1,null,15800,{"$f":"Salim_Dariba(F5,$D$4,$D$5,$D$6,$D$7)","v":645}]
[3,18501,26000,0.15,null,21750,1402.5]
[4,26001,"فيما اعلى",0.2,null,35000,3840,null,null,11000,"<11000",1.4999999999999999E-2,null,165]
[null,null,null,null,null,null,null,null,null,"18500-11000",7500,0.1,null,750]
["مثال ",null,null,null,null,null,null,null,null,"26000-18500",7500,0.15,null,1125]
["الدخل السنوى",11000,null,null,null,null,null,null,null,"30000-26000",4000,0.2,null,800]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K7:K10)+J7","v":30000},null,null,{"$f":"SUM(N7:N10)","v":2840}]
["الدخل السنوى اكثر من 11000"]
[null,18500]
[null,11000,"الاولى تضرب فى 10%",null,null,null,null,null,null,"بعد إذن استاذى الجليل الاستاذ الفاضل سليم "]
[null,7500,"الثانيه تضرب فى 15%",null,null,null,null,null,null,"الشرايح  كما فى الجدول الشريحه الاولى وهى من 1 ج إلى 11000   دى 1.5% اذا كانت أقل  من 11000وانتهت الشريحه دى  أما إذا زاد الدخل السنوى عن 11000 لايدخل فى شريحه 1.5% ويدخل مباشره على شريحه 10% ثم بعد ذلك يدخل الباقى على شريحه 15% واذا انتهى المبلغ ولم يدخل فى الشريحه الاخيره وهى 20% يجمع 10%+15% ويضرب فى 55% وانتهت ضرائبه على هذا أما لو دخل فى الشريحه الاخيرة وهى 20% بالمبلغ الباقى يضرب فى 20% ونجمع 10%+15%+20% ويضرب فى 92.5%"]
[null,null,"يجمع 10%+15% وتضرب فى 55% وانتهت ضرائبه",null,null,null,null,null,null,"أمثلة على ذلك والرجاء منك عملها بالكود كما فى المثال "]
["مثال آخر على أكثر من 11000 ودخل فى الشريحة الاخيرة 20%",null,null,null,null,null,null,null,null,"مثال على الشريحه الثانيه"]
["الدخل السنوى  27000",null,null,null,null,null,null,null,null,"الدخل السنوى 17245"]
[null,11000,"الاولى تضرب فى 10%",null,null,null,null,null,null,11000,"الاولى فى 10%",1100]
[null,7500,"الثانيه تضرب فى 15%",null,null,null,null,null,null,6245,"الثانيه فى 15%",936]
[null,8500,"الثالثة تضرب فى 20% ويجمع الشرايح 10%+15%+20% ويضربوا فى 92.5% وكدة انتهت ضرائبة",null,null,null,null,null,null,null,"المجموع ",1119.8000000000002]
[null,null,null,null,null,null,null,null,null,"مثال آخر على الشريحه الثانيه"]
["المطلوب معادله لحساب هذه الضرائب",null,null,null,null,null,null,null,null,"الدخل السنوى 18991"]
[null,null,null,null,null,null,null,null,null,11000,"الاولى فى 10%",1100]
[null,null,null,null,null,null,null,null,null,7500,"الثانيه فى 15%",1125]
[null,null,null,null,null,null,null,null,null,491,"الثالثة فى 20%",98]
[null,null,null,null,null,null,null,null,null,null,"المجموع ",2148.7750000000001]
[null,null,null,null,null,null,null,null,null,"مثال على الشريحه الثالثة"]
[null,null,null,null,null,null,null,null,null,"الدخل السنوى 24966"]
[null,null,null,null,null,null,null,null,null,11000,"الاولى فى 10%",1100]
[null,null,null,null,null,null,null,null,null,7500,"الثانيه فى 15%",1125]
[null,null,null,null,null,null,null,null,null,6466,"الثالثة فى 20%",1293]
[null,null,null,null,null,null,null,null,null,null,"المجموع ",3254.15]
[null,null,null,null,null,null,null,null,null,"مثال على الشريحه الثالثة "]
[null,null,null,null,null,null,null,null,null,"الدخل السنوى 27000"]
[null,null,null,null,null,null,null,null,null,11000,"الاولى فى 10%",1100]
[null,null,null,null,null,null,null,null,null,7500,"الثانيه فى 15%",1125]
[null,null,null,null,null,null,null,null,null,8500,"الثالثة فى 20%",1700]
[null,null,null,null,null,null,null,null,null,null,"المجموع ",3630.625]
[null,null,null,null,null,null,null,null,null,"مثال اخر"]
[null,null,null,null,null,null,null,null,null,"الدخل السنوى 30000"]
[null,null,null,null,null,null,null,null,null,11000,"الاولى فى 10%"]
[null,null,null,null,null,null,null,null,null,7500,"الثانيه فى 15%"]
[null,null,null,null,null,null,null,null,null,11500,"الثالثة فى 20%"]
[null,null,null,null,null,null,null,null,null,null,"المجموع ",{"$f":"4525*92.5%","v":4185.625}]

{"sheet":"ورقة2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ورقة3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}