{"text_format":"1","workbook":"xlsx","n_sheets":1,"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":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[3,5,7,5],[8,2,8,4],[0,7,1,7],[0,0,0,2],[0,3,0,5],[1,0,1,2],[1,3,1,5]]}
["مايتم أدخاله",null,null,"أدخل وعاء الشهر",null,null,null,"حساب الضريبة شهرياً وفقاً للماده 8 بعد التعديل"]
[" أدخل وعاء الشهر  بعد خصم كافة الاستقطاعات القانونيه المنصوص عليها بالماده 13 من القانون والماده 13 من اللائحه  و الاعفاء الشخصى 583.33 جنيه",null,null,119416.67]
["الوعاء سنوى","المبلغ الخاضع","الضريبة","نسبة الخصم","الخصم","ضريبة الشهر",null,"أدخل صافى المرتب الشهري"]
["شريحه أولى معفاه 8000",{"$f":"IF((ROUNDDOWN(D2*12,-1))<=8000,(ROUNDDOWN(D2*12,-1)),8000)/12","v":666.66666666666663},{"$f":"B4*0%","v":0},0,0,{"$f":"SUM(C4:C8)-SUM(E4:E8)","v":26072.916666666668},null,16666.669999999998]
["الشريحه الثانيه من 8001 حتى 30000 جنيه ( 10 % )",{"$f":"IF(ROUNDDOWN(D2*12,-1)<=30000,ROUNDDOWN(D2*12,-1)-B4*12,22000)/12","v":1833.3333333333333},{"$f":"IF(B5>0,B5*10%,0)","v":183.33333333333334},{"$f":"IF(B5=0,0%,IF(B6>0,0%,85%))","v":0},{"$f":"C5*MAX(D5:D7)","v":0},null,null,"الضريبة الشهرية"]
["الشريحه الثالثه من 30000 حتى 45000 جنيه ( 15 % )",{"$f":"IF(ROUNDDOWN(D2*12,-1)<=45000,ROUNDDOWN(D2*12,-1)-B4*12-B5*12,15000)/12","v":1250},{"$f":"IF(B6>0,B6*15%,0)","v":187.5},{"$f":"IF(B6=0,0%,IF(B7>0,0%,45%))","v":0},{"$f":"C6*MAX(D6:D8)","v":0},null,null,{"$f":"(IF((ROUND(H4*12-4.9999999999999,-1))<=8000,0,IF((ROUND(H4*12-4.9999999999999,-1))<=30000,(ROUND(H4*12-4.9999999999999,-1)-8000)*10%*15%,IF((ROUND(H4*12-4.9999999999999,-1))<=45000,(((ROUND(H4*12-4.9999999999999,-1)-8000-22000)*15%)+((30000-8000)*10%))*55%,IF((ROUND(H4*12-4.9999999999999,-1))<=200000,(((ROUND(H4*12-4.9999999999999,-1)-8000-22000-15000)*20%)+((30000-8000)*10%)+((45000-30000)*15%))*92.5%,((ROUND(H4*12-4.9999999999999,-1)-8000-22000-15000-155000)*22.5%)+((30000-8000)*10%)+((45000-30000)*15%)+((200000-45000)*20%))))))/12","v":2732.6041666666665}]
["الشريحه الرابعه من 45000 حتى 200000 جنيه ( 20 % )",{"$f":"IF(ROUNDDOWN(D2*12,-1)<=200000,ROUNDDOWN(D2*12,-1)-B4*12-B5*12-B6*12,155000)/12","v":12916.666666666666},{"$f":"IF(B7>0,B7*20%,0)","v":2583.3333333333335},{"$f":"IF(B7=0,0%,IF(B8>0,0%,7.5%))","v":0},0]
["الشريحه الخامسه مازاد عن 200000جنيه ( 22.5 % )",{"$f":"IF(ROUNDDOWN(D2*12,-1)>200000,ROUNDDOWN(D2*12,-1)-B4*12-B5*12-B6*12-B7*12,0)/12","v":102750},{"$f":"IF(B8>0,B8*22.5%,0)","v":23118.75},0,0]
[null,null,"مجمل ضريبة الشهر",null,null,{"$f":"MAX(F4:F8)","v":26072.916666666668}]
[]
[null,{"$f":"1000-583.33","v":416.66999999999996}]