{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["حساب المبلغ","المبالغ المستحقة "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":27,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,19],[1,12,1,18],[1,0,1,1],[3,8,3,16],[3,17,3,19],[3,3,4,3],[1,4,1,7],[3,0,4,0],[3,1,4,1],[3,2,4,2],[19,0,19,2],[3,5,4,5],[3,7,4,7],[24,0,24,2],[24,4,24,7],[24,8,24,16],[24,17,24,19],[23,0,23,2],[23,4,23,7],[23,8,23,16],[23,17,23,19],[20,18,20,19],[22,0,22,2],[22,4,22,7],[22,8,22,16],[22,17,22,19],[20,0,20,17]]}
["بيان أرب العهد والرسوم المسددة لحساب صندوق الضمان ",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,"2022-07-01",null,null,null,"حتى",null,null,null,"2023-06-30",null,null,null,null,null,null,{"$f":"DATEDIF(E2,M2,\"M\")+1","v":12},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,14900]
["م","إسم الموظف أو المستخدم","الوظيفة","مدة قسط التأمين","نوع الاجر","القيمة التقديرية للعهدة","الحد الأقصى لحصة الموظف","الحد الاقصى لما يتحمله الموظف","تدرج سعر التأمين على ربيب العهدة",null,null,null,null,null,null,null,null,"حصة الموظف والحكومة من سعر التأمين على أرباب العهد"]
[null,null,null,null,"أجر وظيفى",null,"اساسى *.005\nوظيفى 30%*.005",null,"أقل من 10 ألاف","من 1 حتى 10000","ناتج بعد الطرح","النهائى ","من 10 حتى 50","ناتج بعد الطرح","النهائى ","الحد الاقصى بعد الطرح 50000","أكثر من 50 الف","اجمالى سعر التأمين","حصة الموظف","حصة الحكومة"]
[1,null,null,12,null,null,{"$f":"IF($E$5=$AA$1,E6*0.005*D6,IF($E$5=$AA$2,E6*0.3*0.005*D6))","v":0},{"$f":"IF(G6=0,0,IF(AND(G6>0,G6<=1),1,IF(G6>294,294,IF(AND(G6>1,G6<=294),G6))))","v":0},{"$f":"IF(AND(J6<=1,J6>0),1,J6)","v":0},{"$f":"IF(F6>10000,10000*0.0006,F6*0.0006)","v":0},{"$f":"F6-10000","v":-10000},{"$f":"IF(K6>0,K6*1,0)","v":0},{"$f":"IF(L6>50000,40000*0.0012,L6*0.0012)","v":0},{"$f":"L6-40000","v":-40000},{"$f":"IF(N6>0,N6*1,0)","v":0},{"$f":"IF(O6>100000,100000,O6)","v":0},{"$f":"P6*0.0024","v":0},{"$f":"Q6+M6+I6","v":0},{"$f":"R6-T6","v":0},{"$f":"IF(R6>H6,R6-H6,0)","v":0}]
[2,null,null,12,null,null,0,0,{"$f":"IF(AND(J7<=1,J7>0),1,J7)","v":0},0,-10000,{"$f":"IF(K7>0,K7*1,0)","v":0},{"$f":"IF(L7>50000,40000*0.0012,L7*0.0012)","v":0},{"$f":"L7-40000","v":-40000},{"$f":"IF(N7>0,N7*1,0)","v":0},{"$f":"IF(O7>100000,100000,O7)","v":0},{"$f":"O7*0.0024","v":0},{"$f":"Q7+M7+I7","v":0},0,{"$f":"IF(R7>H7,R7-H7,0)","v":0},"للاستفسار والمراجعة "]
[3,null,null,12,null,null,0,0,0,0,-10000,0,0,-40000,0,0,0,0,0,0,"01006993775"]
[4,null,null,12,null,null,0,0,0,0,-10000,0,0,-40000,0,0,0,0,0,0,"عمرو الجزار"]
[5,null,null,12,null,null,0,0,0,0,-10000,0,0,-40000,0,0,0,0,0,0,"عضو إدارة المراجعة"]
[6,null,null,12,null,null,0,0,0,0,-10000,0,0,-40000,0,0,0,{"$f":"Q11+M11+I11","v":0},0,0,"منطقة تأمينات الشرقية"]
[7,null,null,12,null,null,0,0,0,0,-10000,0,0,-40000,0,0,0,0,0,0]
[8,null,null,12,null,null,0,0,0,0,-10000,0,0,-40000,0,0,0,0,0,0]
[9,null,null,12,null,null,0,0,0,0,-10000,0,0,-40000,0,0,0,0,0,0]
[10,null,null,12,null,null,0,0,0,0,-10000,0,0,-40000,0,0,0,0,0,0]
[11,null,null,12,null,null,0,0,0,0,-10000,0,0,-40000,0,0,0,0,0,0]
[12,null,null,12,null,null,0,0,0,0,-10000,0,0,-40000,0,0,0,0,0,0]
[13,null,null,12,null,null,0,0,0,0,-10000,0,0,-40000,0,0,0,0,0,0]
[14,null,null,12,null,null,0,0,0,0,-10000,0,0,-40000,0,0,0,0,0,0]
["الاجمالى العام ",null,null,null,{"$f":"SUM(E6:E19)","v":0},{"$f":"SUM(F6:F19)","v":0},null,{"$f":"SUM(H6:H19)","v":0},0,null,{"$f":"SUM(K6:K19)","v":-140000},0,0,-560000,0,null,0,{"$f":"SUM(R6:R19)","v":0},{"$f":"SUM(S6:S19)","v":0},{"$f":"SUM(T6:T19)","v":0}]
[{"$f":"NoToTxt(S21,\"جنيها فقط لاغير\",\"قرشا\")","v":"صفر"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S20+T20","v":0}]
[]
["المختص",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,"-----------------------"]
[{"$f":"NOW()","v":"2022-05-17T12:28:24.430"},null,null,null,{"$f":"$A$25","v":"2022-05-17T12:28:24.430"},null,null,null,{"$f":"$A$25","v":"2022-05-17T12:28:24.430"},null,null,null,null,null,null,null,null,{"$f":"$A$25","v":"2022-05-17T12:28:24.430"}]

{"sheet":"المبالغ المستحقة ","index":1,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[27,0,27,1],[27,2,27,3],[27,4,27,5],[27,6,27,8],[28,0,28,1],[28,2,28,3],[28,4,28,5],[28,6,28,8],[1,0,1,8],[2,0,2,1],[2,3,2,5],[2,7,2,8],[0,0,0,6],[0,7,0,8],[26,0,26,1],[26,2,26,3],[26,4,26,5],[26,6,26,8],[24,0,24,1],[24,2,24,4],[24,5,24,6],[24,7,24,8],[25,0,25,1],[25,2,25,3],[25,4,25,5],[25,6,25,8],[20,0,20,8],[21,0,21,6],[21,7,21,8],[22,0,22,8],[23,0,23,8],[19,0,19,2],[3,6,3,8],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3]]}
["نموذج رقم (1)",null,null,null,null,null,null,"صفحة رقم 2"]
["بيان أرب العهد والرسوم المسددة لحساب صندوق الضمان "]
["لمدة سنة ",null,"من",{"$f":"'حساب المبلغ'!$E$2","v":"2022-07-01"},null,null,"حتى",{"$f":"'حساب المبلغ'!$M$2","v":"2023-06-30"}]
["م","إسم الموظف أو المستخدم","الوظيفة","جملة ماهية الشهر","القيمة التقديرية للعهدة","قيمة العهدة المشمولة بالضمان حد أقصى مائة ألف جنيها ","قيمة رسم الضمان "]
[null,null,null,null,"نقود أو أوراق دمغة أدوات أومهمات","نقود أو أوراق دمغة 100 % - أدوات مهمات 100 %","المتحصل من الموظف","ما تتحملة الحكومة ","جملة المبالغ المستحقة"]
[1,{"$f":"'حساب المبلغ'!B6","v":0},{"$f":"'حساب المبلغ'!C6","v":0},{"$f":"'حساب المبلغ'!E6","v":0},{"$f":"'حساب المبلغ'!F6","v":0},0,{"$f":"'حساب المبلغ'!S6","v":0},{"$f":"'حساب المبلغ'!T6","v":0},{"$f":"H6+G6","v":0}]
[2,{"$f":"'حساب المبلغ'!B7","v":0},{"$f":"'حساب المبلغ'!C7","v":0},{"$f":"'حساب المبلغ'!E7","v":0},{"$f":"'حساب المبلغ'!F7","v":0},0,{"$f":"'حساب المبلغ'!S7","v":0},{"$f":"'حساب المبلغ'!T7","v":0},{"$f":"H7+G7","v":0}]
[3,{"$f":"'حساب المبلغ'!B8","v":0},{"$f":"'حساب المبلغ'!C8","v":0},{"$f":"'حساب المبلغ'!E8","v":0},{"$f":"'حساب المبلغ'!F8","v":0},0,{"$f":"'حساب المبلغ'!S8","v":0},{"$f":"'حساب المبلغ'!T8","v":0},0]
[4,{"$f":"'حساب المبلغ'!B9","v":0},{"$f":"'حساب المبلغ'!C9","v":0},{"$f":"'حساب المبلغ'!E9","v":0},{"$f":"'حساب المبلغ'!F9","v":0},0,{"$f":"'حساب المبلغ'!S9","v":0},{"$f":"'حساب المبلغ'!T9","v":0},0]
[5,{"$f":"'حساب المبلغ'!B10","v":0},{"$f":"'حساب المبلغ'!C10","v":0},{"$f":"'حساب المبلغ'!E10","v":0},{"$f":"'حساب المبلغ'!F10","v":0},0,{"$f":"'حساب المبلغ'!S10","v":0},{"$f":"'حساب المبلغ'!T10","v":0},0]
[6,{"$f":"'حساب المبلغ'!B11","v":0},{"$f":"'حساب المبلغ'!C11","v":0},{"$f":"'حساب المبلغ'!E11","v":0},{"$f":"'حساب المبلغ'!F11","v":0},0,{"$f":"'حساب المبلغ'!S11","v":0},{"$f":"'حساب المبلغ'!T11","v":0},0]
[7,{"$f":"'حساب المبلغ'!B12","v":0},{"$f":"'حساب المبلغ'!C12","v":0},{"$f":"'حساب المبلغ'!E12","v":0},{"$f":"'حساب المبلغ'!F12","v":0},0,{"$f":"'حساب المبلغ'!S12","v":0},{"$f":"'حساب المبلغ'!T12","v":0},0]
[8,{"$f":"'حساب المبلغ'!B13","v":0},{"$f":"'حساب المبلغ'!C13","v":0},{"$f":"'حساب المبلغ'!E13","v":0},{"$f":"'حساب المبلغ'!F13","v":0},0,{"$f":"'حساب المبلغ'!S13","v":0},{"$f":"'حساب المبلغ'!T13","v":0},0]
[9,{"$f":"'حساب المبلغ'!B14","v":0},{"$f":"'حساب المبلغ'!C14","v":0},{"$f":"'حساب المبلغ'!E14","v":0},{"$f":"'حساب المبلغ'!F14","v":0},0,{"$f":"'حساب المبلغ'!S14","v":0},{"$f":"'حساب المبلغ'!T14","v":0},0]
[10,{"$f":"'حساب المبلغ'!B15","v":0},{"$f":"'حساب المبلغ'!C15","v":0},{"$f":"'حساب المبلغ'!E15","v":0},{"$f":"'حساب المبلغ'!F15","v":0},0,{"$f":"'حساب المبلغ'!S15","v":0},{"$f":"'حساب المبلغ'!T15","v":0},0]
[11,{"$f":"'حساب المبلغ'!B16","v":0},{"$f":"'حساب المبلغ'!C16","v":0},{"$f":"'حساب المبلغ'!E16","v":0},{"$f":"'حساب المبلغ'!F16","v":0},0,{"$f":"'حساب المبلغ'!S16","v":0},{"$f":"'حساب المبلغ'!T16","v":0},0]
[12,{"$f":"'حساب المبلغ'!B17","v":0},{"$f":"'حساب المبلغ'!C17","v":0},{"$f":"'حساب المبلغ'!E17","v":0},{"$f":"'حساب المبلغ'!F17","v":0},0,{"$f":"'حساب المبلغ'!S17","v":0},{"$f":"'حساب المبلغ'!T17","v":0},0]
[13,{"$f":"'حساب المبلغ'!B18","v":0},{"$f":"'حساب المبلغ'!C18","v":0},{"$f":"'حساب المبلغ'!E18","v":0},{"$f":"'حساب المبلغ'!F18","v":0},0,{"$f":"'حساب المبلغ'!S18","v":0},{"$f":"'حساب المبلغ'!T18","v":0},{"$f":"H18+G18","v":0}]
[14,{"$f":"'حساب المبلغ'!B19","v":0},{"$f":"'حساب المبلغ'!C19","v":0},{"$f":"'حساب المبلغ'!E19","v":0},{"$f":"'حساب المبلغ'!F19","v":0},0,{"$f":"'حساب المبلغ'!S19","v":0},{"$f":"'حساب المبلغ'!T19","v":0},0]
["الاجمالى العام ",null,null,{"$f":"'حساب المبلغ'!E20","v":0},{"$f":"'حساب المبلغ'!F20","v":0},{"$f":"SUM(F6:F19)","v":0},0,0,0]
["إقـــــــــــــــــــــــــــــــــــــرار"]
["جملة رسوم الضمان الواردة فى هذا البيان والتى تبلغ بمبلغ قيمته ",null,null,null,null,null,null,{"$f":"$I$20","v":0}]
[{"$f":"NoToTxt(H22,\"جنيها فقط لاغير \",\"قرش\")","v":"صفر"}]
["سددت لصندوق التأمين الحكومى لضمانات أرباب العهد وذلك عن المدة "]
["من ",null,{"$f":"$D$3","v":"2022-07-01"},null,null,"حتى ",null,{"$f":"$H$3","v":"2023-06-30"}]
["المختص",null,"رئيس القسم",null,"المراجعة",null,"يعتمد مدير المكتب"]
[]
["-----------------------------------------------------------------",null,"--------------------------------------------",null,"------------------------------------------------------",null,"--------------------------------------------------------------------------------------------"]
[{"$f":"NOW()","v":"2022-05-17T12:28:24.430"},null,{"$f":"$A$29","v":"2022-05-17T12:28:24.430"},null,{"$f":"$A$29","v":"2022-05-17T12:28:24.430"},null,{"$f":"$A$29","v":"2022-05-17T12:28:24.430"}]