{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["الضريبة_كود","الضريبة_معادلات","الشرائح"],"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":"الضريبة_كود","index":0,"n_rows":13,"n_cols":18,"rows_kept":13,"cut":false,"hidden":false,"merged":[[4,4,12,11],[1,12,2,12],[8,14,8,16],[9,14,9,16],[10,14,10,16],[11,14,11,16],[2,14,2,16],[3,14,3,16],[4,14,4,16],[5,14,5,16],[6,14,6,16],[7,14,7,16]]}
[]
[null,null,null,"من 1  الى  50000   ","من 50001  الى  80000   ","من 80001  الى  110000   ","من 110001  الى  140000","من 140001  الى  170000","من  170001 الى  200000","من  200001  الى  230000","من 230001  الى  260000","اكثر من :    260000 ","مجموع الضريبة "]
[null,null,"المستحق",0,4,6,8,10,12,14.000000000000002,16,18,null,null,"الشريحة ",null,null,"النسبة"]
[null,null,"مثال ( كود ) ","النتيجة ",null,null,null,null,null,null,null,null,null,null,"من 1  الى  50000   ",null,null,"معفاة 0"]
[null,null,50000,{"$f":"how_to_pay(C5,$D$3,$E$3,$F$3,$G$3,$H$3,$I$3,$J$3,$K$3,$L$3)","v":0},null,null,null,null,null,null,null,null,0,null,"من 50001  الى  80000   ",null,null,0.04]
[null,null,80000,{"$f":"how_to_pay(C6,$D$3,$E$3,$F$3,$G$3,$H$3,$I$3,$J$3,$K$3,$L$3)","v":1200},null,null,null,null,null,null,null,null,1200,null,"من 80001  الى  110000   ",null,null,0.06]
[null,null,110000,3000,null,null,null,null,null,null,null,null,3000,null,"من 110001  الى  140000",null,null,0.08]
[null,null,140000,5400,null,null,null,null,null,null,null,null,5400,null,"من 140001  الى  170000",null,null,0.1]
[null,null,170000,8400,null,null,null,null,null,null,null,null,8400,null,"من  170001 الى  200000",null,null,0.12]
[null,null,200000,{"$f":"how_to_pay(C10,$D$3,$E$3,$F$3,$G$3,$H$3,$I$3,$J$3,$K$3,$L$3)","v":12000},null,null,null,null,null,null,null,null,12000,null,"من  200001  الى  230000",null,null,0.14000000000000001]
[null,null,230000,16200,null,null,null,null,null,null,null,null,16200,null,"من 230001  الى  260000",null,null,0.16]
[null,null,260000,21000,null,null,null,null,null,null,null,null,21000,null,"اكثر من :    260000 ",null,null,0.18]
[null,null,290000,26400,null,null,null,null,null,null,null,null,26400]

{"sheet":"الضريبة_معادلات","index":1,"n_rows":12,"n_cols":18,"rows_kept":12,"cut":false,"hidden":false,"merged":[[8,14,8,16],[9,14,9,16],[10,14,10,16],[11,14,11,16],[2,14,2,16],[3,14,3,16],[4,14,4,16],[5,14,5,16],[6,14,6,16],[7,14,7,16]]}
[]
[null,null,"مثال ( معادلات ) ","من 1  الى  50000   ","من 50001  الى  80000   ","من 80001  الى  110000   ","من 110001  الى  140000","من 140001  الى  170000","من  170001 الى  200000","من  200001  الى  230000","من 230001  الى  260000","اكثر من :    260000 "]
[null,null,"المستحق",0,0.04,0.06,0.08,0.1,0.12,0.14000000000000001,0.16,0.18,"الإجمالى",null,"الشريحة ",null,null,"النسبة"]
[null,null,50000,{"$f":"IF($C4>=500,500*D$3,$C4*D$3)","v":0},{"$f":"IF($C4<=50000,\"\",IF(AND($C4>=50001,$C4<=80000),($C4-50000)*E$3,(80000-50000)*E$3))","v":""},{"$f":"IF($C4<=80000,\"\",IF(AND($C4>=80001,$C4<=110000),($C4-80000)*F$3,(110000-80000)*F$3))","v":""},{"$f":"IF($C4<=110000,\"\",IF(AND($C4>=110001,$C4<=140000),($C4-110000)*G$3,(140000-110000)*G$3))","v":""},{"$f":"IF($C4<=140000,\"\",IF(AND($C4>=140001,$C4<=170000),($C4-140000)*H$3,(170000-140000)*H$3))","v":""},{"$f":"IF($C4<=170000,\"\",IF(AND($C4>=170001,$C4<=200000),($C4-170000)*I$3,(200000-170000)*I$3))","v":""},{"$f":"IF($C4<=200000,\"\",IF(AND($C4>=200001,$C4<=230000),($C4-200000)*J$3,(230000-200000)*J$3))","v":""},{"$f":"IF($C4<=230000,\"\",IF(AND($C4>=230001,$C4<=260000),($C4-230000)*K$3,(260000-230000)*K$3))","v":""},{"$f":"IF($C4<=260000,\"\",IF($C4>=260001,($C4-260000)*L$3))","v":""},{"$f":"SUM(D4:L4)","v":0},null,"من 1  الى  50000   ",null,null,"معفاة 0"]
[null,null,80000,{"$f":"IF($C5>=500,500*D$3,$C5*D$3)","v":0},{"$f":"IF($C5<=50000,\"\",IF(AND($C5>=50001,$C5<=80000),($C5-50000)*E$3,(80000-50000)*E$3))","v":1200},{"$f":"IF($C5<=80000,\"\",IF(AND($C5>=80001,$C5<=110000),($C5-80000)*F$3,(110000-80000)*F$3))","v":""},{"$f":"IF($C5<=110000,\"\",IF(AND($C5>=110001,$C5<=140000),($C5-110000)*G$3,(140000-110000)*G$3))","v":""},{"$f":"IF($C5<=140000,\"\",IF(AND($C5>=140001,$C5<=170000),($C5-140000)*H$3,(170000-140000)*H$3))","v":""},{"$f":"IF($C5<=170000,\"\",IF(AND($C5>=170001,$C5<=200000),($C5-170000)*I$3,(200000-170000)*I$3))","v":""},{"$f":"IF($C5<=200000,\"\",IF(AND($C5>=200001,$C5<=230000),($C5-200000)*J$3,(230000-200000)*J$3))","v":""},{"$f":"IF($C5<=230000,\"\",IF(AND($C5>=230001,$C5<=260000),($C5-230000)*K$3,(260000-230000)*K$3))","v":""},"",{"$f":"SUM(D5:L5)","v":1200},null,"من 50001  الى  80000   ",null,null,0.04]
[null,null,110000,0,{"$f":"IF($C6<=50000,\"\",IF(AND($C6>=50001,$C6<=80000),($C6-50000)*E$3,(80000-50000)*E$3))","v":1200},1800,"","","","","","",3000,null,"من 80001  الى  110000   ",null,null,0.06]
[null,null,140000,0,1200,1800,2400,"","","","","",5400,null,"من 110001  الى  140000",null,null,0.08]
[null,null,170000,0,1200,1800,2400,3000,"","","","",8400,null,"من 140001  الى  170000",null,null,0.1]
[null,null,200000,0,1200,1800,2400,3000,3600,"","","",12000,null,"من  170001 الى  200000",null,null,0.12]
[null,null,230000,0,1200,1800,2400,3000,3600,4200,"","",16200,null,"من  200001  الى  230000",null,null,0.14000000000000001]
[null,null,260000,0,1200,1800,2400,3000,3600,4200,4800,"",21000,null,"من 230001  الى  260000",null,null,0.16]
[null,null,290000,0,1200,1800,2400,3000,3600,4200,4800,5400,26400,null,"اكثر من :    260000 ",null,null,0.18]

{"sheet":"الشرائح","index":2,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[6,2,6,4],[2,2,2,4],[2,7,2,8],[3,2,3,4],[4,2,4,4],[5,2,5,4],[7,2,7,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[11,2,11,4]]}
[]
[]
[null,null,null,null,null,"النسبة","قيمة الشريحة ","مبلغ الضريبة",null,"الضريبة تراكمي"]
[null,0,50000,null,null,"معفاة",null,0]
[null,1,"من 50001  الى  80000   ",null,null,0.04,{"$f":"80000-50001","v":29999},{"$f":"G5*F5","v":1199.96},1200,1200,null,30000,null,30000,30000]
[null,2,"من 80001  الى  110000   ",null,null,0.06,{"$f":"110000-80001","v":29999},1799.9399999999998,1800,{"$f":"J5+I6","v":3000},null,30000,null,30000,{"$f":"O5+N6","v":60000}]
[null,3,"من 110001  الى  140000",null,null,0.08,{"$f":"140000-110001","v":29999},2399.92,2400,5400,null,30000,null,30000,90000]
[null,4,"من 140001  الى  170000",null,null,0.1,{"$f":"170000-140001","v":29999},2999.9,3000,8400,null,30000,null,30000,120000]
[null,5,"من  170001 الى  200000",null,null,0.12,{"$f":"200000-170001","v":29999},3599.8799999999997,3600,12000,null,30000,null,30000,150000]
[null,6,"من  200001  الى  230000",null,null,0.14000000000000001,{"$f":"230000-200001","v":29999},4199.8600000000006,4200,16200,null,30000,null,30000,180000]
[null,7,"من 230001  الى  260000",null,null,0.16,{"$f":"260000-230001","v":29999},4799.84,4800,21000,null,30000,null,30000,210000]
[null,8,"اكثر من :    260000 ",null,null,0.18]