{"text_format":"1","workbook":"xlsx","n_sheets":2,"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":25,"n_cols":17,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,11,2,11],[8,13,8,15],[9,13,9,15],[10,13,10,15],[11,13,11,15],[2,13,2,15],[3,13,3,15],[4,13,4,15],[5,13,5,15],[6,13,6,15],[7,13,7,15]]}
[null,"من",1,{"$f":"C2+1","v":50001},{"$f":"D2+1","v":80001},{"$f":"E2+1","v":110001},140001,170001,200001,230001,260001,"النتيجة المطلوبة "]
[null,"الي",50000,{"$f":"D1+30000-1","v":80000},{"$f":"E1+30000-1","v":110000},{"$f":"F1+30000-1","v":140000},170000,200000,230000,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,"مثال ",{"$f":"B6/D3*B6","v":160000000000},{"$f":"B6*D3","v":3200},null,null,null,null,null,null,null,null,null,"من 1  الى  50000   ",null,null,"معفاة 0"]
[null,50000,{"$f":"IF($B5>=C$1,IF($B5<=C$2,$B5*C$3,IF(C$2=\"\",$B5*C$3,0)),0)","v":0},{"$f":"IF($B5>=D$1,IF($B5<=D$2,$B5*D$3,IF(D$2=\"\",$B5*D$3,0)),0)","v":0},0,0,0,0,0,0,0,{"$f":"SUMPRODUCT(C5:K5)","v":0},null,"من 50001  الى  80000   ",null,null,0.04]
[null,80000,{"$f":"IF($B6>=C$1,IF($B6<=C$2,$B6*C$3,IF(C$2=\"\",$B6*C$3,0)),0)","v":0},3200,0,0,0,0,0,0,0,{"$f":"SUMPRODUCT(C6:K6)","v":3200},null,"من 80001  الى  110000   ",null,null,0.06]
[null,110000,0,0,6600,0,0,0,0,0,0,6600,null,"من 110001  الى  140000",null,null,0.08]
[null,140000,0,0,0,11200,0,0,0,0,0,11200,null,"من 140001  الى  170000",null,null,0.1]
[null,170000,0,0,0,0,17000,0,0,0,0,17000,null,"من  170001 الى  200000",null,null,0.12]
[null,200000,0,0,0,0,0,24000,0,0,0,24000,null,"من  200001  الى  230000",null,null,0.14000000000000001]
[null,230000,0,0,0,0,0,0,32200.000000000004,0,0,32200.000000000004,null,"من 230001  الى  260000",null,null,0.16]
[null,260000,0,0,0,0,0,0,0,41600,0,41600,null,"اكثر من :    260000 ",null,null,0.18]
[null,290000,0,0,0,0,0,0,0,0,52200,52200]
[]
[]
[null,"مثال "]
[null,52000,0,2080,0,0,0,0,0,0,0,2080]
[null,{"$f":"B17+30000","v":82000},0,0,4920,0,0,0,0,0,0,4920]
[null,{"$f":"B18+30000","v":112000},0,0,0,8960,0,0,0,0,0,8960]
[null,142000,0,0,0,0,14200,0,0,0,0,14200]
[null,172000,0,0,0,0,0,20640,0,0,0,20640]
[null,202000,{"$f":"IF($B22>=C$1,IF($B22<=C$2,$B22*C$3,IF(C$2=\"\",$B22*C$3,0)),0)","v":0},0,0,0,0,0,28280.000000000004,0,0,28280.000000000004]
[null,232000,0,0,0,0,0,0,0,37120,0,37120]
[null,262000,0,0,0,0,0,0,0,0,47160,47160]
[null,292000,0,0,0,0,0,0,0,0,52560,52560]

{"sheet":"الشرائح","index":1,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[7,2,7,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[11,2,11,4],[6,2,6,4],[2,2,2,4],[2,7,2,8],[3,2,3,4],[4,2,4,4],[5,2,5,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]