{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["مرتبات","القروض الشهرية","العلاوات السنوية ","Sheet1","حافز اثابة","العلاوات السنوية قديم","الهيئة القومية للتأمينات","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":2,"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":105,"n_cols":25,"rows_kept":105,"cut":false,"hidden":false,"merged":[[2,6,3,14],[5,20,7,20],[5,1,7,1],[5,0,7,0],[5,18,6,18],[5,19,6,19],[5,15,5,17],[5,3,5,14]]}
[]
[]
[" ",null,null,null,null,null,"مرتبـــات شـــهــــــر مارس 2025"]
["الجمعية التعاونية الزراعية"]
["بناحية","راضى"]
["م","الاســــــــــــــم",null,"الاســـــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــتــحـــقـــاقــــــات",null,null,null,null,null,null,null,null,null,null,null,"الاســــــتـــقــطـــاعـــــات",null,null,"جملة الخصومات","الصافى المستحق","التوقيع"]
[null,null,"اسم","حافز الإثابة","العلاوة غلاء معيشة ","العلاوة الاجتماعية","العلاوة المضمومة","المرتب الاساسى","جملة المرتب","علاوة اجتماعية","المنحة","الفرق التأمينى ","الإجمالى العام","18.75% حصة الجمعية","الإجمالى بحصة الجمعية ","29.75% للتأمينات","قرض شهرى","دمغة","جملة الخصومات","الصافى المستحق"]
[null,null,"الجمعية","ق . ج",null,"ق . ج","ق . ج","ق . ج","ق . ج","ق . ج","ق . ج","ق . ج","ق . ج","ق . ج","ق . ج","ق . ج","ق . ج","ق . ج","ق . ج","ق . ج"]
[null,null,"بسنتواى",1484.08,600,199.4,126.5,793.9828,{"$f":"SUM(E9:H9)","v":1719.8827999999999},10,10,152.02000000000001,{"$f":"SUM(I9:L9)+D9","v":3375.9827999999998},{"$f":"M9*18.75%","v":632.99677499999996},{"$f":"SUM(M9:N9)","v":4008.9795749999998},{"$f":"ROUNDDOWN(M9*29.75%,2)","v":1004.35},null,{"$f":"(M9-50)*7.5/1000","v":24.944870999999999},{"$f":"SUM(P9:R9)","v":1029.2948710000001},{"$f":"O9-S9","v":2979.6847039999998}]
[null,null,"ابوهواش",399.6,600,211.3,126.5,933.74,{"$f":"SUM(E10:H10)","v":1871.54},10,10,null,{"$f":"SUM(I10:L10)+D10","v":2291.14},429.58875,2720.7287499999998,681.61,null,{"$f":"(M10-50)*7.5/1000","v":16.80855},698.41854999999998,2022.3101999999999]
[null,null,"ابوهواش",352,300,115.2,124,607.42999999999995,{"$f":"SUM(E11:H11)","v":1146.6300000000001},10,10,null,1518.63,284.74312500000002,1803.3731250000001,451.79,null,{"$f":"(M11-50)*7.5/1000","v":11.014725},462.80472500000002,1340.5684000000001]
[null,null,"ابوهواش",169,300,106.9,124,565.07000000000005,{"$f":"SUM(E12:H12)","v":1095.97},null,10,null,1274.97,239.05687499999999,1514.026875,379.3,null,{"$f":"(M12-50)*7.5/1000","v":9.1872749999999996},388.48727500000001,1125.5396000000001]
[null,null,"ابوهواش",360,600,220,124,642.92999999999995,{"$f":"SUM(E13:H13)","v":1586.9299999999998},null,10,null,1956.9299999999998,366.92437499999994,2323.8543749999999,582.17999999999995,null,{"$f":"(M13-50)*7.5/1000","v":14.301974999999999},596.48197499999992,1727.3724]
[null,null,"العشرة",357.7,600,141.15,124,990.01,{"$f":"SUM(E14:H14)","v":1855.1599999999999},10,10,106.91,{"$f":"SUM(I14:L14)+D14","v":2339.77},438.70687499999997,2778.4768749999998,{"$f":"ROUNDDOWN(M14*29.75%,2)","v":696.08},null,{"$f":"(M14-50)*7.5/1000","v":17.173275},713.25327500000003,2065.2235999999998,null,null,null,null,{"$f":"W14*6","v":0}]
[null,null,"العشرة",338,600,113.8,124,1021.86,1859.6599999999999,10,10,124.19,2341.85,439.09687499999995,2780.9468749999996,696.7,null,17.188874999999999,713.8888750000001,2067.0579999999995]
[null,null,"بسنتواى",1484.08,600,201.4,126.5,793.9828,1721.8827999999999,4,10,156.02000000000001,3375.9827999999998,632.99677499999996,4008.9795749999998,1004.35,null,24.944870999999999,1029.2948710000001,2979.6847039999998]
[null,null,"برسيق",352,600,140.5,124,822.78,1687.28,null,10,null,2049.2799999999997,384.23999999999995,2433.5199999999995,609.66,null,14.994599999999998,624.65459999999996,1808.8653999999997]
[null,null,"العشرة",971.76,600,148.05000000000001,126.5,1037.78,1912.33,8,10,49.89,2951.98,553.49625000000003,3505.4762500000002,878.21,null,21.764849999999999,899.97485000000006,2605.5014000000001]
[null,null,"النخلة البحرية",340,600,96.9,124,917.8,1738.6999999999998,10,10,null,2098.6999999999998,393.50624999999997,2492.2062499999997,624.36,null,15.365249999999998,639.72524999999996,1852.4809999999998]
[null,null,"النخلة البحرية",420,600,220,124,691.01,1635.01,null,10,284.99,2350,440.625,2790.625,699.12,null,17.25,716.37,2074.2550000000001]
[null,null,"ابوكبارية",380.4,600,242.65,104,348.08,{"$f":"SUM(E21:H21)","v":1294.73},10,10,452.65,2147.7800000000002,402.70875000000001,2550.4887500000004,638.96,250,{"$f":"(M21-50)*7.5/1000","v":15.733350000000002},904.69335000000001,1645.7954000000004]
[null,null,"بريدان",986.74,600,246.95,136,1046.3599999999999,2029.31,6,10,null,3032.05,568.50937500000009,3600.5593750000003,902.03,null,22.365375,924.39537499999994,2676.1640000000002]
[null,null,"ط.برسيق",569,600,318.45,140,1160.4000000000001,2218.8500000000004,6,10,null,2803.8500000000004,525.72187500000007,3329.5718750000005,834.14,null,20.653875000000003,854.79387499999996,2474.7780000000007]
[null,null,"ط.برسيق",340,600,96.9,124,1010.83,1831.73,10,10,null,2191.73,410.94937500000003,2602.6793750000002,652.03,null,16.062975000000002,668.09297500000002,1934.5864000000001]
[null,null,"ط.برسيق",380,600,106.9,124,1003.48,1834.38,10,10,null,2234.38,418.94625000000002,2653.3262500000001,664.72,null,16.382850000000001,681.10284999999999,1972.2234000000001]
[null,null,"بركة غطاس",494,600,317.75,136,1122.21,2175.96,10,10,null,2689.96,504.36750000000001,3194.3274999999999,800.26,null,19.799700000000001,820.05970000000002,2374.2677999999996]
[null,null,"بريدان",95,600,106.9,124,981.44,1812.3400000000001,null,10,227.44,2144.7800000000002,402.14625000000001,2546.9262500000004,638.07000000000005,null,15.710850000000002,653.7808500000001,1893.1454000000003]
[null,null,"بريدان",948.22,600,187.95,126.5,1024.31,1938.76,null,10,null,2896.98,543.18375000000003,3440.1637500000002,861.85,null,21.352349999999998,883.20235000000002,2556.9614000000001]
[null,null,"سحالى",456.6,600,312.85000000000002,124,1155.6400000000001,2192.4899999999998,10,10,null,2669.0899999999997,500.45437499999991,3169.5443749999995,794.05,null,19.643174999999999,813.693175,2355.8511999999996]
[null,null,"سحالى",380,600,106.9,124,925.78,1756.6799999999998,null,10,null,2146.6799999999998,402.50249999999994,2549.1824999999999,638.63,null,15.725099999999999,654.35509999999999,1894.8273999999999]
[null,null,"الجرادات",179.3,600,123.25,124,947.75,1795,10,10,146.21,2140.5100000000002,401.34562500000004,2541.8556250000001,636.79999999999995,null,15.678825000000002,652.47882499999992,1889.3768000000002]
[null,null,"الجرادات",181.5,600,129.9,126.5,947.75,1804.15,8,10,136.86000000000001,2140.5100000000002,401.34562500000004,2541.8556250000001,636.79999999999995,500,15.678825000000002,1152.4788249999999,1389.3768000000002]
[null,null,"الجرادات",0,600,106,124,749,1579,null,10,510,2099,{"$f":"M33*18.75%","v":393.5625},2492.5625,624.45000000000005,null,15.3675,639.8175,1852.7449999999999]
[null,null,"كفرعزاز",140,300,106,124,760,{"$f":"SUM(E34:H34)","v":1290},0,10,null,1440,270,1710,428.4,null,10.425000000000001,438.82499999999999,1271.175]
[null,null,"جواد حسنى",380,600,106.9,124,793.36,{"$f":"SUM(E35:H35)","v":1624.26},4,10,281.74,2300,431.25,2731.25,684.25,null,{"$f":"(M35-50)*7.5/1000","v":16.875},701.125,2030.125]
[null,null,"ديرامس",344.3,600,96.9,124,969.18,1790.08,10,10,184.02,2338.4,438.45000000000005,2776.8500000000004,695.67,null,{"$f":"(M36-50)*7.5/1000","v":17.163},712.83299999999997,2064.0170000000003]
[null,null,"كفر حصام",404.15,600,187.5,126.5,971.52,1885.52,10,10,null,2309.67,433.06312500000001,2742.7331250000002,687.12,null,16.947525000000002,704.06752500000005,2038.6656000000003]
[null,null,null,542,300,354.45,121.15,802.9,1578.5,10,10,null,2140.5,{"$f":"M38*18.75%","v":401.34375},{"$f":"SUM(M38:N38)","v":2541.84375},{"$f":"ROUNDDOWN(M38*29.75%,2)","v":636.79},null,15.678750000000001,{"$f":"SUM(P38:R38)","v":652.46875},{"$f":"O38-S38","v":1889.375}]
[null,null,"كوم القناطر",358,600,141.15,124,868.48,1733.63,10,10,220.19,2331.8200000000002,437.21625000000006,2769.0362500000001,693.71,null,17.11365,710.82365000000004,2058.2125999999998]
[null,null,"معاش",1620.18,600,398.1,144.94999999999999,1489.66,2632.71,10,10,null,4272.8900000000003,801.16687500000012,5074.0568750000002,1271.18,null,31.671675000000004,1302.8516750000001,3771.2052000000003]
[null,null,"قافلة",1200,600,106,124,1156.338,1986.338,null,10,null,{"$f":"SUM(I41:L41)+D41","v":3196.3379999999997},{"$f":"M41*18.75%","v":599.31337499999995},{"$f":"SUM(M41:N41)","v":3795.6513749999995},{"$f":"ROUNDDOWN(M41*29.75%,2)","v":950.91},null,23.597534999999997,{"$f":"SUM(P41:R41)","v":974.50753499999996},{"$f":"O41-S41","v":2821.1438399999997}]
[null,null,"محلة كيل",407.4,600,212.9,124,863.68,1800.58,10,10,null,2227.98,{"$f":"M42*18.75%","v":417.74625000000003},2645.7262500000002,662.82,null,{"$f":"(M42-50)*7.5/1000","v":16.334849999999999},679.15485000000001,1966.5714000000003]
[null,null,"محلة كيل",340,600,96.9,124,799.57,1620.47,10,10,null,1980.47,{"$f":"M43*18.75%","v":371.33812499999999},2351.808125,589.17999999999995,null,{"$f":"(M43-50)*7.5/1000","v":14.478524999999999},603.65852499999994,1748.1496000000002]
[null,null,"بلقطر الشرقية",420,600,220,124,762.77,{"$f":"SUM(E44:H44)","v":1706.77},null,10,280.33,2417.1,453.20624999999995,2870.3062499999996,719.08,null,{"$f":"(M44-50)*7.5/1000","v":17.753250000000001},736.83325000000002,2133.4729999999995]
[null,null,"بلقطر الغربية",402,600,252.55,124,809.93,{"$f":"SUM(E45:H45)","v":1786.48},10,10,null,2208.48,414.09000000000003,2622.57,657.02,null,16.188600000000001,673.20859999999993,1949.3614000000002]
[null,null,"بلقطر الغربية",352,600,140.55000000000001,124,768.27,1632.82,10,10,112.97,2117.79,397.08562499999999,2514.8756250000001,630.04,null,15.508424999999999,645.54842499999995,1869.3272000000002]
[null,null,"روضة خيرى",561.5,600,280.95,124,1031.6600000000001,2036.6100000000001,10,10,null,2618.11,490.895625,3109.0056250000002,778.88,null,19.260825000000001,798.14082499999995,2310.8648000000003]
[null,null,"روضة خيرى",909.7,600,187.45,126.5,1002.26,1916.21,10,10,null,2845.91,533.60812499999997,3379.5181249999996,846.65,null,20.969324999999998,867.619325,2511.8987999999995]
[null,null,"روضة خيرى",255,600,96.9,124,964.28,1785.1799999999998,null,10,62.9,2113.08,396.20249999999999,2509.2824999999998,628.64,null,15.473099999999999,644.11310000000003,1865.1693999999998]
[null,null,"بطورس",348,600,263.25,51,971.52,1885.77,10,10,null,2253.77,422.58187499999997,2676.3518749999998,670.49,null,{"$f":"(M50-50)*7.5/1000","v":16.528275000000001},687.01827500000002,1989.3335999999999]
[null,null,"بطورس",406,600,290.95,122,879.64,1892.5900000000001,6,10,null,2314.59,433.98562500000003,2748.5756250000004,688.59,null,16.984425000000002,705.57442500000002,2043.0012000000004]
[null,null,"الزينى",85,600,96.9,124,999.81,{"$f":"SUM(E52:H52)","v":1820.71},10,10,414.7,2340.41,438.82687499999997,2779.2368749999996,696.27,null,17.178074999999996,713.44807500000002,2065.7887999999994]
[null,null,"الغابة",280,600,187.75,124,619,1530.75,10,10,104.6,1935.35,362.87812499999995,2298.2281249999996,575.76,null,14.140124999999999,589.900125,1708.3279999999995]
[null,null,"ابويوسف",984.6,600,144.9,126.5,1045.1300000000001,1916.5300000000002,8,10,null,2919.13,547.33687499999996,3466.4668750000001,868.44,null,21.518475000000002,889.95847500000002,2576.5084000000002]
[null,null,"زاوية نعيم",384.75,600,188.05,126.5,1022.47,1937.02,10,10,0.12,2341.89,439.104375,2780.9943749999998,696.71,null,17.189174999999999,713.89917500000001,2067.0951999999997]
[null,null,"زاوية نعيم",338,600,139.15,124,987.55,1850.6999999999998,10,10,null,2208.6999999999998,414.13124999999997,2622.8312499999997,657.08,null,16.190249999999999,673.27025000000003,1949.5609999999997]
[null,null,"الصخرة",1113,600,148,126.5,1122.21,1996.71,10,10,null,3129.71,586.82062500000006,3716.5306250000003,931.08,null,23.097825,954.17782499999998,2762.3528000000006]
[null,null,"قنديل",380,600,106,124,1238.75,2068.75,10,10,182.84,2651.59,497.17312500000003,3148.7631250000004,788.84,null,19.511925000000002,808.35192500000005,2340.4112000000005]
[null,null,"المشتركة (خاص)",null,null,106.25,458.75,712.37390000000005,{"$f":"SUM(F59:H59)","v":1277.3739},8,10,null,1295.3739,242.88260625000001,1538.25650625,385.37,null,{"$f":"(M59-50)*7.5/1000","v":9.3403042500000009},394.71030424999998,1143.546202]
[null,null,"المشتركة",{"$f":"H60*2","v":2851.04},600,337.3,312.89999999999998,1425.52,{"$f":"SUM(F60:H60)","v":2075.7200000000003},10,10,null,4946.76,927.51750000000004,{"$f":"SUM(M60:N60)+E60","v":6474.2775000000001},1471.66,250,{"$f":"(M60-50)*7.5/1000","v":36.725700000000003},1758.3857,4715.8918000000003]
[null,null,"المشتركة",{"$f":"H61*2","v":2547.88},600,293.05,294.89999999999998,1273.94,{"$f":"SUM(F61:H61)","v":1861.89},10,10,null,4429.7700000000004,830.58187500000008,{"$f":"SUM(M61:N61)+E61","v":5860.3518750000003},1317.85,250,{"$f":"(M61-50)*7.5/1000","v":32.848275000000001},1600.698275,4259.6536000000006]
[null,null,"المشتركة",{"$f":"H62*2","v":2547.88},600,293.05,294.89999999999998,1273.94,{"$f":"SUM(F62:H62)","v":1861.89},10,10,null,4429.7700000000004,830.58187500000008,{"$f":"SUM(M62:N62)+E62","v":5860.3518750000003},1317.85,null,{"$f":"(M62-50)*7.5/1000","v":32.848275000000001},1350.698275,4509.6536000000006]
[null,null,"دسونس",285,600,106.9,124,1013.28,{"$f":"SUM(E63:H63)","v":1844.1799999999998},null,10,177.11,2316.29,434.30437499999999,2750.5943750000001,689.09,null,{"$f":"(M63-50)*7.5/1000","v":16.997174999999999},706.087175,2044.5072]
[null,null,"راضى",170,300,96.9,124,519.26,1040.1599999999999,10,10,1069.8399999999999,2300,431.25,2731.25,684.25,null,{"$f":"(M64-50)*7/1000","v":15.75},{"$f":"SUM(P64:R64)","v":700},{"$f":"O64-S64","v":2031.25}]
[null,null,"الزينى",1010,600,106,124,1059.67,1889.67,null,10,null,{"$f":"SUM(I65:L65)+D65","v":2909.67},{"$f":"M65*18.75%","v":545.56312500000001},{"$f":"SUM(M65:N65)","v":3455.2331250000002},865.62,null,{"$f":"(M65-50)*7.5/1000","v":21.447525000000002},887.06752500000005,2568.1656000000003]
[null,null,"ط.برسيق",220,600,220,124,732.75,1676.75,null,10,null,1906.75,{"$f":"M66*18.75%","v":357.515625},2264.265625,{"$f":"ROUNDDOWN(M66*29.75%,2)","v":567.25},null,{"$f":"(M66-50)*7.5/1000","v":13.925625},{"$f":"SUM(P66:R66)","v":581.17562499999997},{"$f":"O66-S66","v":1683.0900000000001}]
[null,null,"القروى",448,600,294.25,124,804.36,1822.6100000000001,4,10,null,{"$f":"SUM(I67:L67)+D67","v":2284.61},428.364375,2712.9743750000002,679.67,null,{"$f":"(M67-50)*7.5/1000","v":16.759575000000002},696.429575,2016.5448000000001]
[null,null,"القروى",0,600,220,124,646.37,1590.37,null,10,null,1600.37,300.06937499999998,1900.4393749999999,476.11,null,{"$f":"(M68-50)*7/1000","v":10.852589999999999},486.96259000000003,1413.4767849999998]
[null,null,"سحالى",282.5,600,106,124,1048.1199999999999,1878.12,10,10,null,2180.62,408.86624999999998,2589.4862499999999,648.73,null,{"$f":"(M69-50)*7.5/1000","v":15.979649999999999},664.70965000000001,1924.7765999999999]
[null,null,"بركة غطاس",280,600,220,124,636.01,1580.01,null,10,511,2381.0100000000002,{"$f":"M70*18.75%","v":446.43937500000004},2827.4493750000001,708.35,null,17.482575000000001,725.83257500000002,{"$f":"O70-S70","v":2101.6168000000002}]
[null,null,"المشتركة",{"$f":"H71*2","v":2194.38},600,106.25,458.75,1097.19,{"$f":"SUM(F71:H71)","v":1662.19},null,10,null,3866.57,724.98187500000006,{"$f":"SUM(M71:N71)+E71","v":5191.5518750000001},1150.3,250,28.624275000000001,1428.9242749999999,3762.6276000000003]
[null,null,"كفر حصام",505,600,106,124,1102.53,{"$f":"SUM(E72:H72)","v":1932.53},null,10,null,2447.5299999999997,458.91187499999995,{"$f":"SUM(M72:N72)","v":2906.4418749999995},728.14,null,17.981475,746.12147500000003,2160.3203999999996]
[null,null,"كوم القناطر",1010,600,106,124,1021.85,{"$f":"SUM(E73:H73)","v":1851.85},null,10,null,{"$f":"SUM(I73:L73)+D73","v":2871.85},538.47187499999995,{"$f":"SUM(M73:N73)","v":3410.3218749999996},854.37,null,21.163875000000001,875.53387499999997,2534.7879999999996]
[null,null,"المشتركة",{"$f":"H74*2","v":2442.6},600,106.25,458.75,1221.3,{"$f":"SUM(F74:H74)","v":1786.3},null,10,null,4238.8999999999996,794.79374999999993,{"$f":"SUM(M74:N74)+E74","v":5633.6937499999995},1261.07,null,31.416749999999997,1292.48675,4341.2069999999994]
[null,null,"المشتركة",{"$f":"H75*2","v":2816.32},600,106.25,458.75,1408.16,{"$f":"SUM(F75:H75)","v":1973.16},null,10,null,4799.4800000000005,{"$f":"M75*18.75%","v":899.90250000000015},{"$f":"SUM(M75:N75)+E75","v":6299.3825000000006},1427.84,null,35.621100000000006,1463.4611,4835.9214000000011]
[null,null,"التمويل",{"$f":"H76*2","v":2442.6},600,106.25,458.75,1221.3,{"$f":"SUM(F76:H76)","v":1786.3},null,10,null,4238.8999999999996,{"$f":"M76*18.75%","v":794.79374999999993},{"$f":"SUM(M76:N76)+E76","v":5633.6937499999995},1261.07,250,31.416749999999997,1542.48675,4091.2069999999994]
[null,null,"صندوق التمويل",{"$f":"H77*2","v":1950.46},600,310.45,320.8,975.23,{"$f":"SUM(F77:H77)","v":1606.48},10,10,null,3576.94,670.67624999999998,{"$f":"SUM(M77:N77)+E77","v":4847.61625},1064.1300000000001,250,{"$f":"(M77-50)*7.5/1000","v":26.45205},1340.5820500000002,3507.0342000000001,null,null,{"$f":"H77*7%","v":68.266100000000009},{"$f":"H77+W77","v":1043.4961000000001},{"$f":"W77*7","v":477.86270000000007}]
[null,null,"المشتركة",{"$f":"H78*2","v":2329.2199999999998},600,106.25,458.75,1164.6099999999999,{"$f":"SUM(F78:H78)","v":1729.61},null,10,null,4068.83,762.90562499999999,{"$f":"SUM(M78:N78)+E78","v":5431.7356250000003},1210.47,null,30.141224999999999,1240.6112250000001,4191.1244000000006]
[null,null,"بركة غطاس",310,600,106,124,1156.3399999999999,{"$f":"SUM(E79:H79)","v":1986.34},null,10,null,2306.34,432.43875000000003,{"$f":"SUM(M79:N79)","v":2738.7787500000004},686.13,null,16.922550000000005,703.05255,2035.7262000000005]
[null,null,"التمويل",{"$f":"H80*2","v":2311.34},600,106.25,458.75,1155.67,{"$f":"SUM(F80:H80)","v":1720.67},null,10,null,{"$f":"SUM(I80:L80)+D80","v":4042.01},{"$f":"M80*18.75%","v":757.87687500000004},{"$f":"SUM(M80:N80)+E80","v":5399.8868750000001},{"$f":"ROUNDDOWN(M80*29.75%,2)","v":1202.49},null,29.940075,{"$f":"SUM(P80:R80)","v":1232.430075},{"$f":"O80-S80","v":4167.4567999999999}]
[null,null,"بطورس",280,600,106,124,1107.45,{"$f":"SUM(E81:H81)","v":1937.45},null,10,null,2227.4499999999998,417.64687499999997,{"$f":"SUM(M81:N81)","v":2645.0968749999997},662.66,null,16.330874999999999,678.99087499999996,1966.1059999999998]
[null,null,"الزينى",280,600,106,124,1107.45,1937.45,null,10,null,2227.4499999999998,417.64687499999997,2645.0968749999997,662.66,null,16.330874999999999,678.99087499999996,1966.1059999999998]
[null,null,"المشتركة",{"$f":"H83*2","v":2312.6799999999998},600,106.25,458.75,1156.3399999999999,{"$f":"SUM(F83:H83)","v":1721.34},null,10,null,4044.0199999999995,758.25374999999985,{"$f":"SUM(M83:N83)+E83","v":5402.2737499999994},1203.0899999999999,250,29.955149999999996,1483.0451499999999,3919.2285999999995]
[null,null,"بطورس",350,600,106,124,1144.9000000000001,1974.9,null,10,null,2334.9,437.79375000000005,2772.6937500000004,694.63,null,{"$f":"(M84-50)*7.5/1000","v":17.136749999999999},711.76675,2060.9270000000006]
[null,null,"ديرامس",140,600,106,124,1107.45,{"$f":"SUM(E85:H85)","v":1937.45},null,10,null,2087.4499999999998,391.39687499999997,2478.8468749999997,{"$f":"ROUNDDOWN(M85*29.75%,2)","v":621.01},null,{"$f":"(M85-50)*7.5/1000","v":15.280874999999998},{"$f":"SUM(P85:R85)","v":636.29087500000003},{"$f":"O85-S85","v":1842.5559999999996}]
[null,null,"محلة كيل",140,600,106,124,946.95,1776.95,null,10,null,1926.95,361.30312500000002,2288.2531250000002,{"$f":"ROUNDDOWN(M86*29.75%,2)","v":573.26},null,{"$f":"(M86-50)*7.5/1000","v":14.077125000000001},{"$f":"SUM(P86:R86)","v":587.33712500000001},{"$f":"O86-S86","v":1700.9160000000002}]
[null,null,"قنديل",350,600,106,124,1144.9000000000001,{"$f":"SUM(E87:H87)","v":1974.9},null,10,null,2334.9,437.79375000000005,2772.6937500000004,{"$f":"ROUNDDOWN(M87*29.75%,2)","v":694.63},null,{"$f":"(M87-50)*7.5/1000","v":17.136749999999999},{"$f":"SUM(P87:R87)","v":711.76675},{"$f":"O87-S87","v":2060.9270000000006}]
[null,null,"ابوكبارية",1978,600,106,124,1058.23,1888.23,null,10,null,3876.23,726.79312500000003,4603.0231249999997,1153.17,null,{"$f":"(M88-50)*7.5/1000","v":28.696724999999997},1181.8667250000001,3421.1563999999998]
[null,null,"ابويوسف",null,600,106,124,743.65,1573.65,null,10,null,{"$f":"SUM(I89:L89)+D89","v":1583.65},{"$f":"M89*18.75%","v":296.93437500000005},{"$f":"SUM(M89:N89)","v":1880.5843750000001},{"$f":"ROUNDDOWN(M89*29.75%,2)","v":471.13},null,{"$f":"(M89-50)*7.5/1000","v":11.502375000000001},{"$f":"SUM(P89:R89)","v":482.63237500000002},{"$f":"O89-S89","v":1397.9520000000002}]
[null,null,"دسونس",100,600,106,124,1064.6500000000001,1894.65,null,10,null,2004.65,375.87187500000005,{"$f":"SUM(M90:N90)","v":2380.5218750000004},596.38,null,14.659875,611.03987499999994,1769.4820000000004]
[null,null,"كوم القناطر",175,600,106,124,1144.9000000000001,1974.9,null,10,null,2159.9,404.98125000000005,{"$f":"SUM(M91:N91)","v":2564.8812500000004},642.57000000000005,null,15.824249999999999,658.39425000000006,1906.4870000000003]
[null,null,"المشتركة",{"$f":"H92*2","v":1845.48},600,106.25,458.75,922.74,{"$f":"SUM(F92:H92)","v":1487.74},8,10,null,3351.2200000000003,628.35374999999999,{"$f":"SUM(M92:N92)+E92","v":4579.5737500000005},996.98,null,24.759150000000002,1021.73915,3557.8346000000006]
[null,null,"التمويل",{"$f":"H93*2","v":2070},600,106.25,458.75,1035,{"$f":"SUM(F93:H93)","v":1600},null,10,null,{"$f":"SUM(I93:L93)+D93","v":3680},{"$f":"M93*18.75%","v":690},{"$f":"SUM(M93:N93)+E93","v":4970},{"$f":"ROUNDDOWN(M93*29.75%,2)","v":1094.8},null,27.225000000000001,{"$f":"SUM(P93:R93)","v":1122.0249999999999},{"$f":"O93-S93","v":3847.9750000000004}]
[null,null,null,0,0,472.9,157.25,933.71,{"$f":"SUM(E94:H94)","v":1563.8600000000001},10,10,null,{"$f":"SUM(I94:L94)+D94","v":1583.8600000000001},{"$f":"M94*18.75%","v":296.97375},{"$f":"SUM(M94:N94)","v":1880.8337500000002},{"$f":"ROUNDDOWN(M94*29.75%,2)","v":471.19},null,11.503950000000001,{"$f":"SUM(P94:R94)","v":482.69394999999997},{"$f":"O94-S94","v":1398.1398000000004}]
[null,null,"الجرن",175,600,106,124,1144.9000000000001,{"$f":"SUM(E95:H95)","v":1974.9},null,10,140.1,2300,431.25,{"$f":"SUM(M95:N95)","v":2731.25},684.25,null,16.875,701.125,2030.125]
[null,null,"سحالى",200,600,106,124,995,{"$f":"SUM(E96:H96)","v":1825},null,10,null,{"$f":"SUM(I96:L96)+D96","v":2035},{"$f":"M96*18.75%","v":381.5625},{"$f":"SUM(M96:N96)","v":2416.5625},{"$f":"ROUNDDOWN(M96*29.75%,2)","v":605.41},null,{"$f":"(M96-50)*7.5/1000","v":14.887499999999999},{"$f":"SUM(P96:R96)","v":620.29750000000001},{"$f":"O96-S96","v":1796.2649999999999}]
[null,null,"المشتركة",{"$f":"H97*2","v":2060},600,106.25,124,1030,{"$f":"SUM(E97:H97)","v":1860.25},null,10,null,{"$f":"SUM(I97:L97)+D97","v":3930.25},{"$f":"M97*18.75%","v":736.921875},{"$f":"SUM(M97:N97)","v":4667.171875},{"$f":"ROUNDDOWN(M97*29.75%,2)","v":1169.24},null,{"$f":"(M97-50)*7.5/1000","v":29.101875},{"$f":"SUM(P97:R97)","v":1198.3418750000001},{"$f":"O97-S97","v":3468.83}]
[null,null,"بركة غطاس",null,600,106,124,786.45,1616.45,null,10,675,2301.4499999999998,431.52187499999997,{"$f":"SUM(M98:N98)","v":2732.9718749999997},684.68,null,{"$f":"(M98-50)*7.5/1000","v":16.885874999999999},701.56587500000001,2031.4059999999997]
[null,null,"الاجمالى",{"$f":"SUMIF($C$9:$C$98,$B$5,D9:D98)","v":170},{"$f":"SUMIF($C$9:$C$98,$B$5,E9:E98)","v":300},{"$f":"SUMIF($C$9:$C$98,$B$5,F9:F98)","v":96.9},{"$f":"SUMIF($C$9:$C$98,$B$5,G9:G98)","v":124},519.26,{"$f":"SUMIF($C$9:$C$98,$B$5,I9:I98)","v":1040.1599999999999},10,10,null,{"$f":"SUMIF($C$9:$C$98,$B$5,M9:M98)","v":2300},{"$f":"SUMIF($C$9:$C$98,$B$5,N9:N98)","v":431.25},{"$f":"SUMIF($C$9:$C$98,$B$5,$O$9:$O$98)","v":2731.25},{"$f":"SUMIF($C$9:$C$98,$B$5,P9:P98)","v":684.25},{"$f":"SUMIF($C$9:$C$98,$B$5,Q9:Q98)","v":0},{"$f":"SUMIF($C$9:$C$98,$B$5,R9:R98)","v":15.75},{"$f":"SUMIF($C$9:$C$98,$B$5,S9:S98)","v":700},{"$f":"SUMIF($C$9:$C$98,$B$5,T9:T98)","v":2031.25}]
[]
[null,"صرفت المرتبات بمعرفتى",null,null,null,null,"المختص",null,null,"رئيس الحسابات",null,null,null," ",null,"المدير المالي",null,null,"رئيس مجلس الادارة"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"القروض الشهرية","index":1,"n_rows":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":false,"merged":[[4,1,5,1],[4,0,5,0],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[2,2,2,9]]}
[]
[]
[null,null,"السلف الخاصة بالعاملين على الحساب الجارى "]
[]
["م","الاسم ","أسم الجمعية ","التاريخ المحضر                                                                                                                                                                                                            ","بداية التنفيذ","أخر شهر مستحق عليه","مبلغ السلفة ","تقسيم المبلغ شهرياً ","عدد الشهور","الإجمالى","الملاحظات"]
[]
[1,"محمود نعيم بريك","أبويوسف","2020-07-27","شهر أغسطس 2020","شهر يناير2022",4000,222.25,18,{"$f":"H7*I7","v":4000.5},"أخر شهر يكون 221.75 جنية فقط","خالص"]
[2,"مصطفى على أحمد سليمان","المشتركة","2021-02-06","شهر فبراير 2021","شهر يناير2022",2000,170,12,2040,"أخر شهر يكون 130 جنية فقط ","خالص"]
[3,"أحمد سعد عطية إبراهيم","التمويل","2021-03-13","شهر مارس 2021","شهرفبراير2022",3500,300,12,3600,"أخر شهر يكون 200 جنية فقط","خالص"]
[4,"حاتم رأفت أبوشليل","المشتركة","2020-03-22","شهر مارس 2021","شهرفبراير2022",2000,170,12,{"$f":"H10*I10","v":2040},"أخر شهر يكون 130 جنية فقط "]
[6,"تامر محفوظ محمد محمود","المشتركة ","2021-12-18","شهر أكتوبر 2021","شهرسبتمبر 2022",3000,250,12,{"$f":"H11*I11","v":3000},"أخر شهر يكون 250 جنية فقط ","خالص"]
[8,"حاتم رأفت أبوشليل","المشتركة","2021-09-01","شهر سبتمبر 2022","شهر أغسطس2023",3000,250,12,{"$f":"H12*I12","v":3000},"أخر شهر يكون 250 جنية فقط ","خالص"]
[5,"حاتم رأفت أبوشليل","المشتركة","2021-11-06","شهر نوفمبر 2022","شهرأكتوبر2022",3000,250,12,3000,"أخر شهر يكون 250 جنية فقط ","خالص"]
[7,"مصطفى على أحمد سليمان","المشتركة","2022-03-05","شهر مارس 2022","شهر فبراير 2023",3000,250,12,3000,"أخر شهر يكون 250 جنية فقط ","خالص"]
[9,"أيمن محمد محمد حسن","المشتركة","2022-10-01","شهر أكتوبر 2022","شهر سبتمبر 2023",3000,250,12,3000,"أخر شهر يكون 250 جنية فقط ","خالص"]
[10,"محمد السيد السيد الشرنوبى","المشتركة","2022-11-19","شهر نوفمبر 2022","شهر ديسمبر 2023",3000,250,12,3000,"أخر شهر يكون 250 جنية فقط ","يتم خصم 250 جنيه شهر ديسمبر 2023 بسبب انه عليها 250 قرض قديم لشهر ديسمبر 2022"]
[11,"حاتم رأفت أبوشليل","المشتركة","2021-09-01","شهر مارس 2023","شهر فبراير 2024",3000,250,12,{"$f":"H17*I17","v":3000},"أخر شهر يكون 250 جنية فقط "]
[12,"مصطفى على أحمد سليمان","المشتركة","2022-03-05","شهر مارس 2023","شهر فبراير 2024",3000,250,12,3000,"أخر شهر يكون 250 جنية فقط "]
[13,"أيهاب أحمد جويدة","المشتركة","2023-06-01","شهر يونيو 2023","شهر مايو 2024",3000,250,12,3000,"أخر شهر يكون 250 جنية فقط "]
[14,"أحمد سعد عطية إبراهيم","المشتركة","2023-07-01","شهر يوليو 2023","شهر يونيو 2024",3000,250,12,3000,"أخر شهر يكون 250 جنية فقط "]
[15,"محمود محمد عبدالله قطب نمر","المشتركة","2023-10-01","شهر أكتوبر 2023","شهر سبتمبر 2024",3000,250,12,3000,"أخر شهر يكون 250 جنية فقط "]
[16,"أيمن محمد محمد حسن","المشتركة","2022-10-01","شهر أكتوبر 2022","شهر سبتمبر 2024",3000,250,12,3000,"أخر شهر يكون 250 جنية فقط "]
[17,"محمد السيد السيد الشرنوبى","صندوق التمويل","2023-12-21","شهر يناير 2024","شهر ديسمبر 2024",3000,250,12,3000,"أخر شهر يكون 250 جنية فقط "]
[18,"تامر محفوظ محمد محمود","المشتركة ",null,"شهر يناير 2024","شهر ديسمبر 2024",3000,250,12,3000,"أخر شهر يكون 250 جنية فقط "]
[19,"مصطفى على أحمد سليمان","المشتركة","2024-03-02","شهر مارس 2024","شهر فبراير 2025",3000,250,12,3000,"أخر شهر يكون 250 جنية فقط "]
[20,"محمد على محمد عيسى","ابوكبارية","2024-03-25","شهر ابريل 2024","شهر مارس 2025",3000,250,12,3000,"أخر شهر يكون 250 جنية فقط "]
[21,"حاتم رأفت أبوشليل","المشتركة",44440,"شهر مارس 2023","شهر فبراير 2025",3000,250,12,{"$f":"H27*I27","v":3000},"أخر شهر يكون 250 جنية فقط "]
[22,"أيمن محمد محمد حسن","المشتركة","2024-10-01","شهر أكتوبر 2024","شهر سبتمبر 2025",3000,250,12,3000,"أخر شهر يكون 250 جنية فقط "]
[23,"محمود محمد عبدالله قطب نمر","المشتركة","2024-10-01","شهر أكتوبر 2024","شهر سبتمبر 2025",3000,250,12,3000,"أخر شهر يكون 250 جنية فقط "]
[24,"محمد السيد السيد الشرنوبى","صندوق التمويل","2023-12-21","شهر يناير 2024","شهر ديسمبر 2025",3000,250,12,3000,"أخر شهر يكون 250 جنية فقط "]
[25,"محمد محمود نصر عتمان "," التمويل","2023-12-22","شهر يناير 2025","شهر ديسمبر 2026",3000,250,12,3000,"أخر شهر يكون 250 جنية فقط "]

{"sheet":"العلاوات السنوية ","index":2,"n_rows":108,"n_cols":22,"rows_kept":108,"cut":false,"hidden":false,"merged":[[0,8,0,10],[0,11,0,13],[0,15,0,17],[11,1,13,1],[11,2,13,2],[2,1,3,1],[2,2,3,2],[4,1,7,1],[4,2,7,2],[8,1,10,1],[8,2,10,2],[16,1,18,1],[16,2,18,2],[19,1,22,1],[19,2,22,2],[14,2,15,2],[14,1,15,1],[23,1,25,1],[23,2,25,2],[27,1,28,1],[27,2,28,2],[30,1,31,1],[30,2,31,2],[32,1,34,1],[32,2,34,2],[32,20,34,20],[35,1,36,1],[35,2,36,2],[37,1,39,1],[37,2,39,2],[41,1,43,1],[41,2,43,2],[44,1,45,1],[44,2,45,2],[46,1,48,1],[46,2,48,2],[46,11,46,13],[49,1,51,1],[49,2,51,2],[52,1,54,1],[52,2,54,2],[52,11,52,13],[69,1,70,1],[69,2,70,2],[55,2,56,2],[55,1,56,1],[57,1,59,1],[57,2,59,2],[60,1,62,1],[60,2,62,2],[64,2,67,2],[64,1,67,1],[71,2,73,2],[71,1,73,1],[76,1,86,1],[76,2,86,2],[88,2,89,2],[88,1,89,1]]}
[null,null,null,null,null,null,null,null,2021,null,null,2022,null,null,null,2023]
[null,"م","الجمعية",null,7.0000000000000007E-2,"الأساسى بعد 2021/7/1","علاوة تشجعية","الأساسى بعد العلاوة التشجعية 2021/7/1",0.13,"13% بحد أدنى 75","الأساسى بعد 2021/7/1",0.15,"15% بحد أدنى 100","الأساسى بعد 2022/4/1",null,"علاوة غلاء معيشة 1/11/2022","15% بحد أدنى 125","الأساسى بعد 2022/4/1","15% بحد أدنى 150","الأساسى بعد 2024/3/1","ملاحظات"]
[null,1,"بسنتواى",null,{"$f":"[1]Sheet2!AC7*7%","v":28.918400000000002},{"$f":"SUM(E3:E3)","v":28.918400000000002},0,0,{"$f":"F3*13%","v":3.7593920000000005},75,{"$f":"F3+J3","v":103.91840000000001},{"$f":"K3*15%","v":15.587759999999999},100,{"$f":"K3+M3","v":203.91840000000002},null,null,125,{"$f":"Q3+N3","v":328.91840000000002}]
[null,null,null,null,{"$f":"[1]Sheet2!AC8*7%","v":28.918400000000002},28.918400000000002,0,0,{"$f":"F4*13%","v":3.7593920000000005},75,{"$f":"F4+J4","v":103.91840000000001},{"$f":"K4*15%","v":15.587759999999999},100,{"$f":"K4+M4","v":203.91840000000002},null,null,125,{"$f":"Q4+N4","v":328.91840000000002}]
["محمد",2,"أبوهواش",null,0,0,0,0,0,0,{"$f":"F5+I5","v":0},{"$f":"K5*$L$2","v":0},100,{"$f":"K5+M5","v":100},null,null,125,{"$f":"N5+Q5","v":225}]
[null,null,null,null,0,0,0,0,0,0,{"$f":"F6+J6","v":0},{"$f":"K6*$L$2","v":0},100,{"$f":"K6+M6","v":100}]
[null,null,null,null,0,0,0,0,0,0,0,{"$f":"K7*$L$2","v":0},100,100]
["فاطمة",null,null,null,0,0,0,0,0,0,0,{"$f":"K8*$L$2","v":0},100,100,null,null,125,{"$f":"N8+Q8","v":225}]
[null,3,"العشرة",null,{"$f":"[1]Sheet2!AC13*7%","v":31.090500000000002},31.090500000000002,0,0,{"$f":"F9*13%","v":4.0417650000000007},75,106.09050000000001,{"$f":"K9*15%","v":15.913575},100,206.09050000000002,null,null,125,{"$f":"N9+Q9","v":331.09050000000002}]
[null,null,null,null,{"$f":"[1]Sheet2!AC14*7%","v":33.037900000000008},33.037900000000008,0,0,4.2949270000000013,75,108.03790000000001,16.205684999999999,100,208.03790000000001,null,null,125,{"$f":"N10+Q10","v":333.03790000000004}]
[null,null,null,null,{"$f":"[1]Sheet2!AC15*7%","v":34.011600000000001},34.011600000000001,0,0,4.4215080000000002,75,109.0116,16.351739999999999,100,209.01159999999999,null,null,125,{"$f":"N11+Q11","v":334.01159999999999}]
[null,4,"النخلة البحرية",null,{"$f":"[1]Sheet2!AC16*7%","v":36.551200000000001},36.551200000000001,0,0,4.7516560000000005,75,111.55119999999999,16.732679999999998,100,211.55119999999999,75,{"$f":"N12+O12","v":286.55119999999999},125,{"$f":"P12+Q12","v":411.55119999999999}]
[null,null,null,null,{"$f":"[1]Sheet2!AC17*7%","v":25.697000000000003},25.697000000000003,0,0,3.3406100000000003,75,100.697,15.10455,100,200.697,75,{"$f":"N13+O13","v":275.697},125,{"$f":"P13+Q13","v":400.697}]
[null,null,null,null,{"$f":"[1]Sheet2!AC18*7%","v":10.860500000000002},10.860500000000002,0,0,1.4118650000000004,75,85.860500000000002,12.879075,100,185.8605,75,{"$f":"N14+O14","v":260.8605},125,{"$f":"P14+Q14","v":385.8605}]
[null,5,"ابوكبارية",null,{"$f":"[1]Sheet2!AC19*7%","v":13.104000000000001},13.104000000000001,0,0,null,null,null,null,null,null,null,null,125,{"$f":"F15+Q15","v":138.10400000000001}]
[null,null,null,null,0,0,null,null,null,null,null,null,null,860,0,null,0.15,989]
[null,6,"بريدان",null,{"$f":"[1]Sheet2!AC21*7%","v":34.535900000000005},{"$f":"SUM(E17:E17)","v":34.535900000000005},0,0,4.4896670000000007,75,{"$f":"F17+J17","v":109.5359},{"$f":"K17*15%","v":16.430384999999998},100,{"$f":"K17+M17","v":209.5359},null,null,125,{"$f":"N17+Q17","v":334.53589999999997}]
[null,null,null,null,{"$f":"[1]Sheet2!AC22*7%","v":30.566200000000006},30.566200000000006,0,0,3.9736060000000011,75,{"$f":"F18+J18","v":105.56620000000001},{"$f":"K18*15%","v":15.83493},100,{"$f":"K18+M18","v":205.56620000000001},null,null,125,330.56619999999998]
[null,null,null,null,{"$f":"[1]Sheet2!AC23*7%","v":33.187700000000007},33.187700000000007,0,0,4.314401000000001,75,{"$f":"F19+J19","v":108.18770000000001},{"$f":"K19*15%","v":16.228155000000001},100,{"$f":"K19+M19","v":208.18770000000001},null,null,125,333.18770000000001]
[null,7,"طلمبات برسيق",null,{"$f":"[1]Sheet2!AC24*7%","v":40.752600000000001},40.752600000000001,0,0,5.2978380000000005,0.13,null,{"$f":"K21*15%","v":6.9075657000000001},0.15,{"$f":"K21+L20","v":52.958003699999999},null,null,125,177.95800370000001]
[null,null,null,null,{"$f":"[1]Sheet2!AC25*7%","v":32.363800000000005},32.363800000000005,0,0,4.207294000000001,75,{"$f":"F20+I20","v":46.050438},16.104569999999999,100,{"$f":"K22+M21","v":207.3638},null,null,125,332.36379999999997]
[null,null,null,null,{"$f":"[1]Sheet2!AC26*7%","v":31.914400000000004},31.914400000000004,0,0,4.1488720000000008,75,{"$f":"F21+J21","v":107.3638},16.03716,100,{"$f":"K23+M22","v":206.9144},null,null,125,331.9144]
[null,null,null,null,{"$f":"[1]Sheet2!AC27*7%","v":15.361500000000001},15.361500000000001,0,0,1.9969950000000003,75,{"$f":"F22+J22","v":106.9144},13.554225000000001,100,{"$f":"K24+M23","v":190.36150000000001},null,null,125,315.36149999999998]
[null,8,"بركة غطاس",null,{"$f":"[1]Sheet2!AC28*7%","v":38.955000000000005},38.955000000000005,0,0,5.0641500000000006,0.13,{"$f":"F23+J23","v":90.361500000000007},6.6028725000000001,0.15,{"$f":"K25+L24","v":50.6220225},null,null,125,175.62202250000001]
[null,null,null,null,{"$f":"[1]Sheet2!AC29*7%","v":9.4500000000000011},9.4500000000000011,0,0,1.2285000000000001,75,{"$f":"F24+I24","v":44.019150000000003},12.6675,100,{"$f":"K26+M25","v":184.45},null,null,125,309.45]
[null,null,null,null,0,0,0,0,0,0.13,{"$f":"F25+J25","v":84.45},0,0.15,{"$f":"K27+L26","v":0},null,null,125,125]
[null,9,"الغابة",null,{"$f":"[1]Sheet2!AC32*7%","v":19.855499999999999},19.855499999999999,0,0,2.5812149999999998,75,{"$f":"F26+I26","v":0},{"$f":"K28*$L$2","v":14.228325},100,{"$f":"K28+M27","v":194.85550000000001}]
[null,10,"أبويوسف",null,{"$f":"[1]Sheet2!AC33*7%","v":35.21},35.21,0,0,4.5773000000000001,75,{"$f":"F27+J27","v":94.855500000000006},{"$f":"K29*$L$2","v":16.531500000000001},100,210.21,null,null,0,0,150]
[null,null,null,null,{"$f":"[1]Sheet2!AC34*7%","v":34.461000000000006},34.461000000000006,0,0,4.4799300000000013,75,110.21000000000001,{"$f":"K30*$L$2","v":16.419150000000002},100,209.46100000000001,null,null,125,{"$f":"N29+Q29","v":334.46100000000001},150]
[null,11,"برسيق",null,{"$f":"[1]Sheet2!AC35*7%","v":33.950000000000003},33.950000000000003,0,0,4.4135000000000009,0,109.46100000000001,{"$f":"K31*L2","v":5.0925000000000002},100,133.94999999999999]
[null,12,"القروى",null,{"$f":"[1]Sheet2!AC36*7%","v":19.740000000000002},19.740000000000002,0,0,2.5662000000000003,75,33.950000000000003,{"$f":"K32*$L$2","v":14.211},100,194.74,null,null,125,{"$f":"N31+Q31","v":319.74}]
[null,null,null,null,{"$f":"[1]Sheet2!AC37*7%","v":10.080000000000002},10.080000000000002,0,0,1.3104000000000002,75,94.740000000000009,{"$f":"K33*$L$2","v":12.761999999999999},100,185.07999999999998,null,null,125,310.08]
[null,13,"سحالى",null,{"$f":"[1]Sheet2!AC38*7%","v":40.527900000000002},40.527900000000002,0,0,5.2686270000000004,0.13,85.08,{"$f":"K34*15%","v":6.8694790500000007},0.15,{"$f":"K34+L33","v":52.666006050000007},null,null,125,177.66600605000002,null,null,"فقط نبيل فتحى محمدعبدالقادر في الجمعية",{"$f":"N33-R33","v":-125.00000000000001}]
[null,null,null,null,{"$f":"[1]Sheet2!AC39*7%","v":32.064200000000007},32.064200000000007,0,0,0,0,{"$f":"F33+I33","v":45.796527000000005},4.8096300000000012,100,{"$f":"K35+M34","v":132.0642},null,null,125,257.06420000000003,null,null,null,{"$f":"N34-R34","v":-125.00000000000003}]
[null,null,null,null,{"$f":"[1]Sheet2!AC40*7%","v":39.550000000000004},39.550000000000004,0,0,0,0,{"$f":"F34","v":32.064200000000007},5.9325000000000001,100,139.55000000000001,null,null,125,264.55,null,null,null,{"$f":"N35-R35","v":-125}]
[null,14,"زاوية نعيم",null,{"$f":"[1]Sheet2!AC41*7%","v":33.075000000000003},{"$f":"[1]Sheet2!AC41+E36","v":505.57499999999999},0,0,{"$f":"F36*13%","v":65.72475},75,{"$f":"F35","v":39.550000000000004},87.086250000000007,100,680.57500000000005,null,null,125,805.57500000000005,null,null,"تم خصم 68.0575 من أساسى شهر نوفمبر",{"$f":"N36-R36","v":-125}]
[null,null,null,null,{"$f":"[1]Sheet2!AC42*7%","v":30.94},{"$f":"[1]Sheet2!AC42+E37","v":472.94},0,0,{"$f":"F37*13%","v":61.482199999999999},75,{"$f":"F36+J36","v":580.57500000000005},82.191000000000003,100,647.94000000000005,null,null,125,772.94,null,null,null,{"$f":"N37-R37","v":-125}]
[null,15,"الجرادات",null,{"$f":"[1]Sheet2!AC43*7%","v":28.506800000000002},{"$f":"SUM(E38:E38)","v":28.506800000000002},0,0,{"$f":"F38*13%","v":3.7058840000000002},75,{"$f":"F37+J37","v":547.94000000000005},15.526019999999999,100,203.5068,null,null,125,328.5068]
[null,null,null,null,{"$f":"[1]Sheet2!AC44*7%","v":28.506800000000002},{"$f":"SUM(E39:E39)","v":28.506800000000002},0,0,{"$f":"F39*13%","v":3.7058840000000002},75,{"$f":"F38+J38","v":103.5068},15.526019999999999,100,203.5068,null,null,125,328.5068]
[null,null,null,null,{"$f":"[1]Sheet2!AC45*0%","v":0},{"$f":"SUM(E40:E40)","v":0},0,0,{"$f":"F40*13%","v":0},75,{"$f":"F39+J39","v":103.5068},11.25,100,175,null,null,125,300]
[null,16,"كفرعزاز",null,0,660,0,0,0,0,{"$f":"F40+J40","v":75},99,100,760]
[null,17,"روضة خيرى",null,{"$f":"[1]Sheet2!AC46*7%","v":0},{"$f":"SUM(E42:E42)","v":0},0,0,{"$f":"F42*13%","v":0},75,{"$f":"F41","v":660},11.25,100,175,null,null,125,{"$f":"N42+Q42","v":300}]
[null,null,null,null,{"$f":"[1]Sheet2!AC47*7%","v":33.637100000000004},33.637100000000004,0,0,{"$f":"F43*13%","v":4.3728230000000003},75,{"$f":"F42+J42","v":75},16.295565,100,208.6371,null,null,125,{"$f":"N43+Q43","v":333.63710000000003},null,null,"تم تطبيق على الأساس 2020 بتاريخ 2022/3/1"]
[null,null,null,null,{"$f":"[1]Sheet2!AC48*7%","v":31.839500000000005},31.839500000000005,0,0,4.1391350000000005,75,108.6371,16.025925000000001,100,206.83949999999999,null,null,125,{"$f":"N44+Q44","v":331.83949999999999}]
[null,18,"دسونس",null,{"$f":"[1]Sheet2!AC50*7%","v":46.2},46.2,0,0,6.0060000000000002,75,106.8395,18.18,100,221.2]
[null,null,null,null,{"$f":"[1]Sheet2!AC51*7%","v":37.681699999999999},37.681699999999999,0,0,4.8986210000000003,75,121.2,16.902255,100,212.68170000000001,null,null,125,{"$f":"N46+Q46","v":337.68169999999998}]
[null,19,"ديرأمس",null,{"$f":"[1]Sheet2!AC52*7%","v":0},0,0,0,0,75,112.68170000000001,"على المعــــــــــــــــــــاش",null,null,null,null,null,null,null,null,"تم منحه علاوة تشجعية قبل الطلوع على المعاش"]
[null,null,null,null,{"$f":"[1]Sheet2!AC53*7%","v":32.513600000000004},32.513600000000004,0,0,{"$f":"F48*13%","v":4.2267680000000007},75,75,{"$f":"K49*15%","v":16.127039999999997},100,{"$f":"K49+M48","v":207.5136},null,null,125,{"$f":"N48+Q48","v":332.5136},150]
[null,null,null,null,{"$f":"[1]Sheet2!AC54*7%","v":37.007599999999996},37.007599999999996,null,null,{"$f":"F49*13%","v":4.810988},0,107.5136,{"$f":"K50*15%","v":5.5511399999999993},0,760,null,null,125,{"$f":"N49+Q49","v":885},150]
[null,20,"قافلة",null,{"$f":"[1]Sheet2!AC55*7%","v":29.8172},29.8172,0,0,3.876236,0.13,37.007599999999996,{"$f":"K51*15%","v":5.0540153999999999},0.15,{"$f":"K51+L50","v":38.747451399999996},null,null,{"$f":"N50*15%","v":5.812117709999999},{"$f":"N50+Q50","v":44.559569109999998}]
[null,null,null,null,{"$f":"[1]Sheet2!AC56*7%","v":0},0,0,0,0,0.13,{"$f":"F50+I50","v":33.693435999999998},{"$f":"K52*15%","v":0},0.15,{"$f":"K52+L51","v":0},"متوفى",null,0,0]
[null,null,null,null,0,0,0,0,0,0.13,{"$f":"F51+I51","v":0},{"$f":"K53*15%","v":0},0.15,{"$f":"K53+L52","v":0},null,null,125,{"$f":"N52+Q52","v":125}]
[null,21,"قنديل",null,{"$f":"[1]Sheet2!AC58*7%","v":55.433000000000007},55.433000000000007,0,0,7.206290000000001,0.13,{"$f":"F52+I52","v":0},"على المعــــــــــــــــــــاش",null,null,null,null,null,null,null,null,"معاش 2021/11/28"]
[null,null,null,null,{"$f":"[1]Sheet2!AC59*7%","v":43.400000000000006},43.400000000000006,0,0,{"$f":"F54*13%","v":5.6420000000000012},75,{"$f":"F53+I53","v":62.63929000000001},{"$f":"K55*15%","v":17.760000000000002},100,{"$f":"K55+M54","v":218.4},null,null,125,{"$f":"N54+Q54","v":343.4}]
[null,null,null,null,{"$f":"[1]Sheet2!AC60*7%","v":38.049199999999999},38.049199999999999,0,0,{"$f":"F55*13%","v":4.946396},0,{"$f":"F54+J54","v":118.4},5.7073799999999997,0,795,null,null,125,{"$f":"N55+Q55","v":920}]
[null,22,"كفرحصام",null,{"$f":"[1]Sheet2!AC61*7%","v":26.964000000000002},26.964000000000002,0,0,3.5053200000000002,75,{"$f":"F55+J55","v":38.049199999999999},15.294599999999999,100,{"$f":"K57+M56","v":201.964},null,null,125,{"$f":"N56+Q56","v":326.964}]
[null,null,null,null,0,0,0,0,0,0.13,{"$f":"F56+J56","v":101.964},0,100,100,null,null,125,{"$f":"N57+Q57","v":225}]
[null,23,"كوم القناطر",null,0,{"$f":"E58+[1]Sheet2!AC63","v":428},0,0,0,0,{"$f":"F57+I57","v":0},64.2,100,528,null,null,125,{"$f":"Q58+N58","v":653}]
[null,null,null,null,0,{"$f":"E59+[1]Sheet2!AC64","v":580},0,0,0,0,{"$f":"F58+I58","v":428},87,100,680,null,null,125,{"$f":"Q59+N59","v":805}]
[null,null,null,null,0,{"$f":"SUM(E60:E60)","v":0},0,0,{"$f":"F60*13%","v":0},75,{"$f":"F59+I59","v":580},11.25,100,175,null,null,125,{"$f":"Q60+N60","v":300},null,null,"تم أضافة 140بدل 60 في أساسى مرتب التعيين ليكون 760"]
[null,24,"الزينى",null,{"$f":"[1]Sheet2!AC66*7%","v":30.566200000000006},30.566200000000006,0,0,{"$f":"F61*13%","v":3.9736060000000011},75,{"$f":"F60+J60","v":75},15.83493,100,205.56620000000001,null,null,125,{"$f":"N61+Q61","v":330.56619999999998}]
[null,null,null,null,{"$f":"[1]Sheet2!AC67*7%","v":35.35},35.35,0,0,{"$f":"F62*13%","v":4.5955000000000004},75,{"$f":"F61+J61","v":105.56620000000001},16.552499999999998,100,210.35,null,null,125,{"$f":"N62+Q62","v":335.35}]
[null,null,null,null,0,0,0,0,0,0,{"$f":"F62+J62","v":110.35},0,100,100,null,null,125,{"$f":"N63+Q63","v":225}]
[null,25,"الصخرة",null,{"$f":"[1]Sheet2!AC69*7%","v":35.35},35.35,0,0,{"$f":"F64*13%","v":4.5955000000000004},0.13,{"$f":"F63","v":0},5.9918250000000004,0.15,{"$f":"K65+L64","v":45.937325000000001},null,null,125,{"$f":"N64+Q64","v":170.93732499999999}]
[null,26,"بطورس",null,{"$f":"[1]Sheet2!AC70*7%","v":46.2},46.2,0,0,{"$f":"F65*13%","v":6.0060000000000002},75,{"$f":"F64+I64","v":39.945500000000003},18.18,100,{"$f":"K66+M65","v":221.2},null,null,125,{"$f":"N65+Q65","v":346.2}]
[null,null,null,null,{"$f":"[1]Sheet2!AC71*7%","v":38.955000000000005},38.955000000000005,0,0,{"$f":"F66*13%","v":5.0641500000000006},75,{"$f":"F65+J65","v":121.2},17.093250000000001,100,{"$f":"K67+M66","v":213.95500000000001},null,null,125,338.95500000000004]
[null,null,null,null,0,0,0,0,0,0,{"$f":"F66+J66","v":113.95500000000001},0,100,{"$f":"K68+M67","v":100},null,null,125,225]
[null,null,null,null,null,null,null,null,null,null,{"$f":"F67+J67","v":0},null,null,795,null,null,125,920]
[null,27,"ب .الشرقية",null,{"$f":"[1]Sheet2!AC74*7%","v":46.2},{"$f":"SUM(E69:E69)","v":46.2},0,0,{"$f":"F69*13%","v":6.0060000000000002},75,null,{"$f":"K70*15%","v":18.18},100,{"$f":"K70+M69","v":221.2},null,null,125,346.2,null,null,"تم عمل علاوة 12% بحد أدنى أبتداء من 1/7/2020"]
[null,28,"بلقطر الغربية",null,{"$f":"[1]Sheet2!AC75*7%","v":0},{"$f":"SUM(E70:E70)","v":0},0,0,0,75,{"$f":"F69+J69","v":121.2},{"$f":"K71*15%","v":11.25},100,{"$f":"K71+M70","v":175},null,null,125,300]
[null,null,null,null,{"$f":"[1]Sheet2!AC76*7%","v":17.196899999999999},{"$f":"SUM(E71:E71)","v":17.196899999999999},0,0,2.2355969999999998,75,{"$f":"F70+J70","v":75},{"$f":"K72*15%","v":13.829535},100,{"$f":"K72+M71","v":192.1969},null,null,125,317.19690000000003]
[null,29,"محل كيل",null,{"$f":"[1]Sheet2!AC77*7%","v":20.080200000000001},{"$f":"SUM(E72:E72)","v":20.080200000000001},0,0,2.6104260000000004,75,{"$f":"F71+J71","v":92.196899999999999},{"$f":"K73*15%","v":14.262030000000001},100,{"$f":"K73+M72","v":195.08019999999999},null,null,125,320.08019999999999]
[null,null,null,null,{"$f":"[1]Sheet2!AC78*7%","v":17.5336},{"$f":"SUM(E73:E73)","v":17.5336},0,0,2.2793679999999998,75,{"$f":"F72+J72","v":95.080200000000005},{"$f":"K74*15%","v":13.880040000000001},100,{"$f":"K74+M73","v":192.53360000000001},null,null,125,317.53359999999998]
[null,null,null,null,null,null,null,null,null,null,{"$f":"F73+J73","v":92.533600000000007},null,null,760,null,null,125,885]
[null,30,"راضى",null,{"$f":"[1]Sheet2!AC80*7%","v":29.26},{"$f":"SUM(E75:E75)","v":29.26},null,null,3.8038000000000003,75,null,{"$f":"K76*15%","v":15.638999999999999},100,{"$f":"K76+M75","v":204.26}]
[null,31,"جواد حسنى",null,{"$f":"[1]Sheet2!AC81*7%","v":46.603900000000003},46.603900000000003,0,0,0,0,{"$f":"F75+J75","v":104.26},{"$f":"K77*15%","v":6.9905850000000003},100,{"$f":"K77+M76","v":146.60390000000001},null,null,125,{"$f":"N76+Q76","v":271.60390000000001}]
["محمود عوض",32,"المشتركة ",null,{"$f":"[1]Sheet2!AC82*7%","v":50.714300000000009},50.714300000000009,0,0,{"$f":"F77*13%","v":6.5928590000000016},0.13,{"$f":"F76+J76","v":46.603900000000003},{"$f":"K78*$K$4","v":0},null,{"$f":"K78+L77","v":0},null,0,null,{"$f":"N77*15%","v":0},null,null,null,"محمود عوض"]
["مصطفى",null,null,null,{"$f":"[1]Sheet2!AC83*7%","v":45.321500000000007},45.321500000000007,0,0,{"$f":"F78*13%","v":5.891795000000001},0.13,0,{"$f":"K79*15%","v":7.6819942500000007},0.15,{"$f":"K79+L78","v":58.895289250000012},null,0,{"$f":"N78*15%","v":8.8342933875000007},{"$f":"N78+Q78","v":67.729582637500016},null,null,null,"مصطفى"]
["أيمن محمد",null,null,null,{"$f":"[1]Sheet2!AC84*7%","v":45.321500000000007},45.321500000000007,0,0,5.891795000000001,0.13,{"$f":"F78+I78","v":51.213295000000009},7.6819942500000007,0.15,{"$f":"K80+L79","v":58.895289250000012},null,0,{"$f":"N79*15%","v":8.8342933875000007},{"$f":"N79+Q79","v":67.729582637500016},null,null,null,"ايمن"]
["تامر محفوظ",null,null,null,{"$f":"[1]Sheet2!AC85*7%","v":37.643900000000002},37.643900000000002,0,0,4.893707,0.13,{"$f":"F79+I79","v":51.213295000000009},6.3806410500000004,0.15,{"$f":"K81+L80","v":48.918248050000003},null,0,{"$f":"N80*15%","v":7.3377372075},{"$f":"N80+Q80","v":56.255985257500001},null,null,null,"تامر"]
["حاتم رأفت",null,null,null,{"$f":"[1]Sheet2!AC86*7%","v":43.400000000000006},43.400000000000006,0,0,5.6420000000000012,75,{"$f":"F80+I80","v":42.537607000000001},17.760000000000002,100,{"$f":"K82+M81","v":218.4},null,0,125,{"$f":"N81+Q81","v":343.4},null,null,null,"حاتم"]
["أحمد قطب",null,null,null,{"$f":"[1]Sheet2!AC87*7%","v":43.400000000000006},43.400000000000006,0,0,5.6420000000000012,0.13,{"$f":"F81+J81","v":118.4},7.3563000000000009,0.15,{"$f":"K83+L82","v":56.398300000000006},null,0,{"$f":"N82*15%","v":8.4597449999999998},{"$f":"N82+Q82","v":64.858045000000004},null,null,null,"احمد ابوشليل"]
["إيهاب جويدة",null,null,null,{"$f":"[1]Sheet2!AC88*7%","v":43.400000000000006},43.400000000000006,0,0,5.6420000000000012,0.13,{"$f":"F82+I82","v":49.042000000000009},7.3563000000000009,0.15,56.398300000000006,null,{"$f":"N83+225","v":281.39830000000001},{"$f":"P83*15%","v":42.209744999999998},{"$f":"P83+Q83","v":323.608045},null,null,"تم تعديل الاساسى كرئيس حسابات من 175 إلى 350 واضافة 50 لشهادة الدبلومة في 2022/11/1","إيهاب"]
["أحمد سعد",null,null,null,{"$f":"[1]Sheet2!AC89*7%","v":40.950000000000003},40.950000000000003,0,0,5.3235000000000001,0.13,49.042000000000009,6.9410250000000007,0.15,53.214525000000009,null,0,{"$f":"N84*15%","v":7.982178750000001},{"$f":"N84+Q84","v":61.196703750000012},null,null,null,"احمد سعد"]
["محمود السيد",null,null,null,{"$f":"[1]Sheet2!AC90*7%","v":43.400000000000006},43.400000000000006,0,0,{"$f":"F85*13%","v":5.6420000000000012},0.13,46.273500000000006,7.3563000000000009,0.15,56.398300000000006,null,0,125,{"$f":"N85+Q85","v":181.39830000000001},null,null,null,"محمد ابويوسف"]
["أحمد عطية",null,null,null,0,0,0,0,0,0.13,49.042000000000009,0,0.15,0,null,0,0,{"$f":"N86","v":0},null,null,null,"احمد عطيه"]
["محمود نمر",null,null,null,0,0,0,0,0,0.13,0,0,0.15,0,null,0,125,{"$f":"N87+Q87","v":125},null,null,null,"النمر"]
[null,33,"صندوق التمويل",null,{"$f":"[1]Sheet2!AC93*7%","v":43.400000000000006},43.400000000000006,0,0,{"$f":"F88*13%","v":5.6420000000000012},0,0,6.5100000000000007,100,{"$f":"K89+M88","v":143.4},null,null,125,{"$f":"N88+Q88","v":268.39999999999998}]
[null,34,"التمويل",null,{"$f":"[1]Sheet2!AC94*7%","v":43.400000000000006},43.400000000000006,0,0,{"$f":"F89*13%","v":5.6420000000000012},0.13,{"$f":"F88+J88","v":43.400000000000006},7.3563000000000009,0.15,{"$f":"K90+L89","v":56.398300000000006},null,null,{"$f":"N89*15%","v":8.4597449999999998},{"$f":"N89+Q89","v":64.858045000000004}]
[null,null,null,null,0,0,0,0,{"$f":"F90*13%","v":0},0.13,{"$f":"F89+I89","v":49.042000000000009},0,0.15,{"$f":"K91+L90","v":0},null,null,125,{"$f":"N90+Q90","v":125}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"F90+I90","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,714.16,140,65,65,22.54,{"$f":"SUM(I108:M108)","v":1006.6999999999999}]

{"sheet":"Sheet1","index":3,"n_rows":43,"n_cols":62,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"شهر 5",null,"شهر 6",null,"شهر 7",null,"شهر 8 ",null,"شهر 9",null,"شهر 10",null,"شهر 11",null,"شهر 12",null,"شهر 1",null,"شهر 2",null,"شهر 3",null,"شهر4",null,"شهر 5",null,"شهر 6",null,"شهر 7",null,"شهر 8",null,null,"شهر 9",null,"شهر 11",null,"شهر 12",null,"شهر1 "]
[null,null,null,null,null,null,null,null,null,null,"القروى",19,"بريدان",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,null,null,null,"ط.برسيق",22,"زاوية نعيم",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,"تم عمل محضر  لزاوية نعيم رفع الحد الأدنى ل1400 في تاريخ 27-6-2022 ولم يطبق على شهر 6"]
[null,null,null,null,null,null,null,null,null,null,"راضى ",23,"ابويوسف",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,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,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,"روضة خيرى"]
[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,"زاوية نعيم ",null,"محلة كيل",null,"سحالى ",null,"راضى",null,"الجرن",null,3429.54]
[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,"ط برسيق",null,"راضى",null,"أبوهواش",null,"بركة غطاس",null,"بريدان",null,3308.73,null,null,null,null,400,{"$f":"(BI17-50)*6.5/1000","v":2.2749999999999999}]
[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,"زاوية نعيم",null,"قنديل",null,"سحالى",null,"برسيق",null,3308.73,null,null,null,null,210,{"$f":"(BI18-50)*6/1000","v":0.96}]
[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,"دسونس",null,"روضة خيرة ",null,"ابوكيارية ",null,"زاوية نعبم",null,"العشرة",null,2560.54]
[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,"العشرة",null,"الزينى",null,"بركة غطاس",null,"برسيق",null,"ط.برسيق",null,1700,null,null,null,null,{"$f":"400-2","v":398}]
[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,"ب الغربية",null,null,null,"بلقطر الشرقية ",null,"دسونس",null,null,null,2826.24]
[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,"راضى",null,null,null,"ط.بريق",null,"قنديل",null,null,null,3161.27]
[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,"بسنتواى",null,"بطورس ",null,null,null,"أبويوسف",null,"قافلة",null,null,null,3836.26]
[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,null,"قافلة",null,"الجرادات",null,null,null,"روضة خيرة ",null,"بطورس",null,null,null,3015.27]
[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,"دسونس",null,"كفرعزاز",null,null,null,"برسيق",null,"ديرامس",null,null,null,2186.38]
[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,"جواد حسنى ",null,"قافلة",null,null,null,"القروى",null,"الغابة ",null,null,null,2992.07]
[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,"الصخرة",null,"الوينى",null,null,null,"دسونس",null,"بريدان",null,null,null,3161.26]
[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,"محلة كيل",null,"راضى",null,null,null,"جواد حسنى",null,"العشرة",null,null,null,{"$f":"SUM(BD16:BD27)","v":35486.29}]
[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,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,"الصخرة",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,"الصخرة",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,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,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,"برسيق",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,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,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,"روضة خيرى",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,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,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,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,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,"برسيق",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,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,"كفرعزاز",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,"برسيق",null,null,null,"القروى"]

{"sheet":"حافز اثابة","index":4,"n_rows":86,"n_cols":21,"rows_kept":86,"cut":false,"hidden":false,"merged":[[2,12,2,13],[2,10,2,11],[5,20,7,20],[5,3,5,12],[5,1,7,1],[5,0,7,0],[5,18,6,18],[5,19,6,19],[5,13,5,17]]}
[]
[" "]
[null,null,null,null,null,null,null,null,null,"حــافــز اثــابـة  شــــــــهر","يوليو",null,2020]
["الجمعية التعاونية الزراعية"]
["بناحية","المشتركة"]
["م","الاســــــــــــــم",null,"الاســـــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــتــحـــقـــاقــــــات",null,null,null,null,null,null,null,null,null,"الاســـــــــــــــــــــــــــــتـــقـــطـــــاعــــــــــات",null,null,null,null,"جملة الخصومات","الصافى المستحق","التوقيع"]
[null,null,"اسم","العلاوة الخاصة","العلاوة الاجتماعية","حصة الجمعية 24%","العلاوة المضمومة","المرتب الاساسى","جملة المرتب","حصة الجمعية 26%","علاوة اجتماعية","المنحة","الجملة",0.4,0.35,null,"قرض","دمغة","جملة الخصومات","الصافى المستحق"]
[null,null,"الجمعية","ق . ج","ق . ج","ق . ج","ق . ج","ق . ج","ق . ج","ق . ج","ق . ج","ق . ج","ق . ج","ق . ج","ق . ج","ق . ج","ق . ج","ق . ج","ق . ج","ق . ج"]
[null,"وجيه سعيد التونى","بسنتواى",null,384.7,{"$f":"ROUNDDOWN(E9*24%,2)","v":92.32},null,null,null,null,null,null,{"$f":"SUM(I9:L9)+F9+D9+E9","v":477.02},null,{"$f":"ROUNDDOWN(E9*35%,2)","v":134.63999999999999},null,null,2.77,{"$f":"SUM(N9:R9)","v":137.41},{"$f":"M9-S9","v":339.61}]
[null,"محمد ابراهيم على","ابوهواش",null,399.6,95.9,null,null,null,null,null,null,{"$f":"SUM(I10:L10)+F10+D10+E10","v":495.5},null,{"$f":"ROUNDDOWN(E10*35%,2)","v":139.86000000000001},null,null,1.85,{"$f":"SUM(N10:R10)","v":141.71},{"$f":"M10-S10","v":353.78999999999996}]
[null,"على جلا ل رزق","ابوهواش",null,352,84.48,null,null,null,null,null,null,436.48,null,123.2,null,null,1.6,124.8,311.68]
[null,"عبداللطيف عبدالحميد الصباغ","العشرة",null,357.7,85.84,null,null,null,null,null,null,{"$f":"SUM(I12:L12)+F12+D12+E12","v":443.53999999999996},null,{"$f":"ROUNDDOWN(E12*35%,2)","v":125.19},null,null,1.5,{"$f":"SUM(N12:R12)","v":126.69},{"$f":"M12-S12","v":316.84999999999997}]
[null,"على عبدالحميد الصباغ","العشرة",null,253.5,60.84,null,null,null,null,null,null,{"$f":"SUM(I13:L13)+F13+D13+E13","v":314.34000000000003},null,{"$f":"ROUNDDOWN(E13*35%,2)","v":88.72},null,null,1,{"$f":"SUM(N13:R13)","v":89.72},{"$f":"M13-S13","v":224.62000000000003}]
[null,"مبروك عبدالاه مبروك","العشرة",null,272,65.28,null,null,null,null,null,null,337.28,null,95.2,null,null,1.1000000000000001,96.3,240.97999999999996]
[null,"رئيفة شاكر زويل","بسنتواى",null,384.7,92.32,null,null,null,null,null,null,477.02,null,134.63999999999999,null,null,2.77,137.41,339.61]
[null,"علاء عبدالقادرأحمد","برسيق",null,352,84.48,null,null,null,null,null,null,436.48,null,123.2,null,null,1.6,124.8,311.68]
[null,"محمد على القصاص","النخلة البحرية",null,628.5,150.84,null,null,null,null,null,null,779.34,null,219.97,null,null,3.3,223.27,556.07000000000005]
[null,"على حسين عبدالهادى ","النخلة البحرية",null,340,81.599999999999994,null,null,null,null,null,null,421.6,null,119,null,null,1.5,120.5,301.10000000000002]
[null,"عامرعبدالسلا م عامر","بريدان",null,433.65,104.07,null,null,null,null,null,null,537.72,null,151.77000000000001,null,null,2,153.77000000000001,383.95000000000005]
[null,"محمد على عيسى ","ابوكبارية",null,380.4,91.29,null,null,null,null,null,null,471.69,null,133.13999999999999,null,null,1.4,134.54,337.15]
[null,"ماجد عبدالسلام عامر","بريدان",null,95,22.8,null,null,null,null,null,null,117.8,null,33.25,null,null,0.25,33.5,84.3]
[null,"وليدعبدالكريم ضيف الله","بريدان",null,384.55,92.29,null,null,null,null,null,null,476.84000000000003,null,134.59,null,null,1.75,136.34,340.5]
[null,"سعد حسن ابراهيم","ط.برسيق",null,658,157.91999999999999,null,null,null,null,null,null,815.92,null,230.3,null,null,3.1,233.4,582.52]
[null,"ابراهيم عبدالحميد زكى","ط.برسيق",null,569,136.56,null,null,null,null,null,null,705.56,null,199.15,null,null,2.8,201.95000000000002,503.6099999999999]
[null,"عاد ل محمد محمود","ط.برسيق",null,340,81.599999999999994,null,null,null,null,null,null,421.6,null,119,null,null,1.5,120.5,301.10000000000002]
[null,"ابراهيم جمعة الحميرى","ط.برسيق",null,380,91.2,null,null,null,null,null,null,471.2,null,133,null,null,1.6,134.6,336.6]
[null,"مؤمن محمد عبدالعال","بركة غطاس",null,494,118.56,null,null,null,null,null,null,612.55999999999995,null,172.9,null,null,2.35,175.25,437.30999999999995]
[null,"صباح على عيد شلبى","جواد حسنى",null,380,91.2,null,null,null,null,null,null,471.2,null,133,null,null,1.6,134.6,336.6]
[null,"سامية عبدالمجيد متولى","القروى",null,448,107.52,null,null,null,null,null,null,555.52,null,156.80000000000001,null,1.9,null,158.70000000000002,396.81999999999994]
[null,"نبيل فتحى عبدالقادر","سحالى",null,456.6,109.58,null,null,null,null,null,null,{"$f":"SUM(I30:L30)+F30+D30+E30","v":566.18000000000006},null,{"$f":"ROUNDDOWN(E30*35%,2)","v":159.81},null,null,2.15,{"$f":"SUM(N30:R30)","v":161.96},{"$f":"M30-S30","v":404.22}]
[null,"أمانى جمعة أبوعوف","سحالى",null,380,91.2,null,null,null,null,null,null,471.2,null,133,null,null,1.9,134.9,336.29999999999995]
[null,"أيمن فوزى محمد سلطان","الجرادات",null,179.3,43.03,null,null,null,null,null,null,{"$f":"SUM(I32:L32)+F32+D32+E32","v":222.33},null,{"$f":"ROUNDDOWN(E32*35%,2)","v":62.75},null,null,0.6,{"$f":"SUM(N32:R32)","v":63.35},{"$f":"M32-S32","v":158.98000000000002}]
[null,"سلطان ناجى محمد سلطان","الجرادات",null,181.5,43.56,null,null,null,null,null,null,{"$f":"SUM(I33:L33)+F33+D33+E33","v":225.06},null,{"$f":"ROUNDDOWN(E33*35%,2)","v":63.52},null,null,0.6,{"$f":"SUM(N33:R33)","v":64.12},{"$f":"M33-S33","v":160.94}]
[null,"مد حت السيد عثمان ","الرزقة",null,370.95,89.02,null,null,null,null,null,null,459.96999999999997,null,129.83000000000001,null,null,1.7,131.53,328.43999999999994]
[null,"عاطف عثمان عبدالحليم","ديرامس",null,435.6,104.54,null,null,null,null,null,null,540.14,null,152.46,null,null,2,154.46,385.67999999999995]
[null,"عطية عبدالعزيز عبدالله","كفر حصام",null,384.65,92.31,null,null,null,null,null,null,476.96,null,134.62,null,null,1.75,136.37,340.59]
[null,"أحمد محمد عثمان ","كوم القناطر",null,542,130.08000000000001,null,null,null,null,null,null,{"$f":"SUM(I37:L37)+F37+D37+E37","v":672.08},null,{"$f":"ROUNDDOWN(E37*35%,2)","v":189.7},null,null,2.7,{"$f":"SUM(N37:R37)","v":192.39999999999998},{"$f":"M37-S37","v":479.68000000000006}]
[null,"عيد عبدالعاطى عبدالكريم","كوم القناطر",null,358,85.92,null,null,null,null,null,null,443.92,null,125.3,null,null,1.6,126.89999999999999,317.02000000000004]
[null,"على محمد رجب","قافلة",null,789.85,189.56,null,null,null,null,null,null,{"$f":"SUM(I39:L39)+F39+D39+E39","v":979.41000000000008},null,{"$f":"ROUNDDOWN(E39*35%,2)","v":276.44},null,null,3.9,{"$f":"SUM(N39:R39)","v":280.33999999999997},{"$f":"M39-S39","v":699.07000000000016}]
[null,"صلاح الدين نجيب عبداللطيف","قافلة",null,751.45,180.34,null,null,null,null,null,null,931.79000000000008,null,263,null,null,3.7,266.7,665.09000000000015]
[null,"محمد محمود حامد الحداد","محلة كيل",null,407.4,97.77,null,null,null,null,null,null,{"$f":"SUM(I41:L41)+F41+D41+E41","v":505.16999999999996},null,{"$f":"ROUNDDOWN(E41*35%,2)","v":142.59},null,null,1.9,{"$f":"SUM(N41:R41)","v":144.49},{"$f":"M41-S41","v":360.67999999999995}]
[null,"رمضان نصر حميدة","محلة كيل",null,340,81.599999999999994,null,null,null,null,null,null,421.6,null,119,null,null,1.5,120.5,301.10000000000002]
[null,"أيمن سعيد عبداللطيف","راضى",null,170,40.799999999999997,null,null,null,null,null,null,210.8,null,59.5,null,null,0.3,59.8,151]
[null,"مصطفى رزق ابراهيم","بلقطر الغربية",null,402,96.48,null,null,null,null,null,null,498.48,null,140.69999999999999,null,null,1.8,142.5,355.98]
[null,"عبدالمنعم عبدالهادى ابوسعيفة","بلقطر الغربية",null,352,{"$f":"ROUNDDOWN(E45*24%,2)","v":84.48},null,null,null,null,null,null,{"$f":"SUM(I45:L45)+F45+D45+E45","v":436.48},null,{"$f":"ROUNDDOWN(E45*35%,2)","v":123.2},null,null,1.6,{"$f":"SUM(N45:R45)","v":124.8},{"$f":"M45-S45","v":311.68}]
[null,"أحمد سعد محى الدين","روضة خيرى",null,561.5,134.76,null,null,null,null,null,null,{"$f":"SUM(I46:L46)+F46+D46+E46","v":696.26},null,{"$f":"ROUNDDOWN(E46*35%,2)","v":196.52},null,null,2.7,{"$f":"SUM(N46:R46)","v":199.22},{"$f":"M46-S46","v":497.03999999999996}]
[null,"خالد رمضان سعدالله","روضة خيرى",null,398.7,95.68,null,null,null,null,null,null,{"$f":"SUM(I47:L47)+F47+D47+E47","v":494.38},null,{"$f":"ROUNDDOWN(E47*35%,2)","v":139.54},null,null,1.8,{"$f":"SUM(N47:R47)","v":141.34},{"$f":"M47-S47","v":353.03999999999996}]
[null,"كرم مصطفى عبدالقادر","روضة خيرى",null,255,61.2,null,null,null,null,null,null,316.2,null,89.25,null,null,1,90.25,225.95]
[null,"فرج محمد الرفلة","بطورس",null,348,83.52,null,null,null,null,null,null,{"$f":"SUM(I49:L49)+F49+D49+E49","v":431.52},null,{"$f":"ROUNDDOWN(E49*35%,2)","v":121.8},null,null,1.55,{"$f":"SUM(N49:R49)","v":123.35},{"$f":"M49-S49","v":308.16999999999996}]
[null,"سمير منصور عبدالحافظ","بطورس",null,406,97.44,null,null,null,null,null,null,503.44,null,142.1,null,null,1.85,143.94999999999999,359.49]
[null,"بدرعبدالنبى محمد","الزينى",null,85,20.399999999999999,null,null,null,null,null,null,105.4,null,29.75,null,null,0.2,29.95,75.45]
[null,"هانى الصافى محمد","الغابة",null,280,67.2,null,null,null,null,null,null,347.2,null,98,null,null,1.2,99.2,248]
[null,"محمود نعيم بريك","ابويوسف",null,373.3,89.59,null,null,null,null,null,null,{"$f":"SUM(I53:L53)+F53+D53+E53","v":462.89},null,{"$f":"ROUNDDOWN(E53*35%,2)","v":130.65},null,null,1.7,{"$f":"SUM(N53:R53)","v":132.35},{"$f":"M53-S53","v":330.53999999999996}]
[null,"شريف محمود أحمد","ابويوسف",null,377.3,90.55,null,null,null,null,null,null,467.85,null,132.05000000000001,null,null,1.7,133.75,334.1]
[null,"عبدالله متولى محمد","قنديل",null,479.85,115.16,null,null,null,null,null,null,595.01,null,167.94,null,null,2.2000000000000002,170.14,424.87]
[null,"أحمد فتحى ابراهيم","قنديل",null,380,91.2,null,null,null,null,null,null,471.2,null,133,null,null,1.7,134.69999999999999,336.5]
[null,"هشام عبود علا م","الصخرة",null,363,87.12,null,null,null,null,null,null,450.12,null,127.05,null,null,1.65,128.69999999999999,321.42]
[null,"محمد السيد الشرنوبى","صندوق التمويل",null,1049.7,{"$f":"ROUNDDOWN(E58*24%,2)","v":251.92},null,null,null,null,null,null,{"$f":"SUM(D58:H58)+J58+K58+L58","v":1301.6200000000001},null,{"$f":"ROUNDDOWN(E58*35%,2)","v":367.39},null,null,6.2,{"$f":"SUM(N58:R58)","v":373.59},928.0300000000002]
[null,"محمود أحمد عبدالمنعم ","المشتركة",null,390,{"$f":"ROUNDDOWN(E59*24%,2)","v":93.6},null,null,null,null,null,null,{"$f":"SUM(I59:L59)+F59+D59+E59","v":483.6},null,{"$f":"ROUNDDOWN(E59*35%,2)","v":136.5},null,null,1.7,{"$f":"SUM(N59:R59)","v":138.19999999999999},{"$f":"M59-S59","v":345.40000000000003}]
[null,"مصطفى على سليمان","المشتركة",null,1114.5999999999999,267.5,null,null,null,null,null,null,1382.1,null,390.11,null,null,3,393.11,988.9899999999999]
[null,"أيمن محمد حسن","المشتركة",null,974.7,233.92,null,null,null,null,null,null,{"$f":"SUM(I61:L61)+F61+D61+E61","v":1208.6200000000001},null,{"$f":"ROUNDDOWN(E61*35%,2)","v":341.14},null,null,5.5,{"$f":"SUM(N61:R61)","v":346.64},{"$f":"M61-S61","v":861.98000000000013}]
[null,"سمير محمد عبدالخالق","المشتركة",null,974.7,233.92,null,null,null,null,null,null,{"$f":"SUM(I62:L62)+F62+D62+E62","v":1208.6200000000001},null,{"$f":"ROUNDDOWN(E62*35%,2)","v":341.14},null,null,5.5,{"$f":"SUM(N62:R62)","v":346.64},{"$f":"M62-S62","v":861.98000000000013}]
[null,"تامر محفوظ محمد ","المشتركة",null,974.7,233.92,null,null,null,null,null,null,{"$f":"SUM(I63:L63)+F63+D63+E63","v":1208.6200000000001},null,{"$f":"ROUNDDOWN(E63*35%,2)","v":341.14},null,null,5.5,{"$f":"SUM(N63:R63)","v":346.64},{"$f":"M63-S63","v":861.98000000000013}]
[null,"مبروك السيد القصاص","دسونس",null,418.35,100.4,null,null,null,null,null,null,518.75,null,146.41999999999999,null,null,1.95,148.36999999999998,370.38]
[null,"محمد مبروك فتح الله","دسونس",null,285,68.400000000000006,null,null,null,null,null,null,353.4,null,99.75,null,null,1.2,100.95,252.45]
[null,"رمضان حسن متولى","زاوية نعيم",null,384.75,92.34,null,null,null,null,null,null,477.09000000000003,null,134.66,null,null,1.75,136.41,340.68000000000006]
[null,"عبدالله باشا عبدالله","زاوية نعيم",null,338,81.12,null,null,null,null,null,null,419.12,null,118.3,null,null,1.5,119.8,299.32]
[null,"فاضل حصافى طه","النخلة البحرية",null,420,100.8,null,null,null,null,null,null,520.79999999999995,null,147,null,null,0.8,147.80000000000001,372.99999999999994]
[null,"رمضان بدر عبدالوهاب ","بلقطر الشرقية",null,420,100.8,null,null,null,null,null,null,520.79999999999995,null,147,null,null,2,149,371.79999999999995]
[null,"فاطمة أحمد خليل محمد","ابوهواش",null,220,52.8,null,null,null,null,null,null,272.8,null,77,null,null,0.8,77.8,195]
[null,"عبدالنبى بدر عبدالحميد ","ط.برسيق",null,220,52.8,null,null,null,null,null,null,272.8,null,77,null,null,0.8,77.8,195]
[null,"حاتم رأفت إبراهيم على ","المشتركة",null,390,93.6,null,null,null,null,null,null,483.6,null,136.5,null,null,1.7,138.19999999999999,345.40000000000003]
[null,"أحمد قطب أبوشليل ","المشتركة",null,390,{"$f":"ROUNDDOWN(E73*24%,2)","v":93.6},null,null,null,null,null,null,{"$f":"SUM(I73:L73)+F73+D73+E73","v":483.6},null,136.5,null,null,1.7,{"$f":"SUM(N73:R73)","v":138.19999999999999},345.40000000000003]
[null,"محمد إبراهيم غنيم ","القروى",null,300,72,null,null,null,null,null,null,372,null,105,null,null,1.2,106.2,265.8]
[null,"إيهاب أحمد محمود جويدة ","المشتركة",null,390,93.6,null,null,null,null,null,null,{"$f":"SUM(I75:L75)+F75+D75+E75","v":483.6},null,{"$f":"ROUNDDOWN(E75*35%,2)","v":136.5},null,null,1.7,{"$f":"SUM(N75:R75)","v":138.19999999999999},{"$f":"M75-S75","v":345.40000000000003}]
[null,"محمود السيد محمد جمعة ","المشتركة",null,390,93.6,null,null,null,null,null,null,{"$f":"SUM(I76:L76)+F76+D76+E76","v":483.6},null,{"$f":"ROUNDDOWN(E76*35%,2)","v":136.5},null,null,1.7,{"$f":"SUM(N76:R76)","v":138.19999999999999},{"$f":"M76-S76","v":345.40000000000003}]
[null,"ياسر محمد كامل سعد ","المشتركة",null,390,93.6,null,null,null,null,null,null,483.6,null,136.5,null,null,1.7,138.19999999999999,345.40000000000003]
[null,"أحمد سعد عطية إبراهيم ","التمويل",null,390,93.6,null,null,null,null,null,null,{"$f":"SUM(I78:L78)+F78+D78+E78","v":483.6},null,{"$f":"ROUNDDOWN(E78*35%,2)","v":136.5},null,null,1.7,{"$f":"SUM(N78:R78)","v":138.19999999999999},{"$f":"M78-S78","v":345.40000000000003}]
[null,"محمد محمود نصرعتمان ","التمويل",null,390,93.6,null,null,null,null,null,null,483.6,null,136.5,null,null,1.7,138.19999999999999,345.40000000000003]
[null,null,null,null,null,0,null,null,null,null,null,null,0,null,0,null,null,null,0,0]
[null,null,"الاجمالى",{"$f":"SUMIF($C$9:$C$80,$B$5,D9:D80)","v":0},6378.7,1530.8599999999994,0,0,0,0,0,0,7909.5600000000013,0,2232.5299999999997,0,0,29.699999999999996,2262.23,5647.3299999999981]
[]
[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,null,null,null,null,null,null,"-"]

{"sheet":"العلاوات السنوية قديم","index":5,"n_rows":84,"n_cols":35,"rows_kept":84,"cut":false,"hidden":false,"merged":[[32,13,34,13],[76,5,76,6],[45,1,46,1],[68,15,69,15],[32,1,34,1],[32,0,34,0],[48,1,49,1],[48,0,49,0],[36,1,38,1],[36,0,38,0],[22,1,24,1],[22,0,24,0],[15,1,16,1],[15,0,16,0],[17,1,18,1],[17,0,18,0],[19,1,21,1],[19,0,21,0],[4,1,6,1],[4,0,6,0],[7,1,10,1],[7,0,10,0],[12,1,14,1],[12,0,14,0],[80,0,81,0],[80,1,81,1],[73,1,74,1],[73,0,74,0],[68,1,69,1],[68,0,69,0],[70,1,72,1],[70,0,72,0],[77,1,79,1],[77,0,79,0],[39,1,40,1],[39,0,40,0],[41,1,43,1],[41,0,43,0],[25,0,26,0],[27,0,29,0],[30,1,31,1],[30,0,31,0],[25,1,26,1],[27,1,29,1],[56,1,66,1],[56,0,66,0],[50,0,51,0],[50,1,51,1],[52,1,54,1],[52,0,54,0]]}
[]
[]
[]
["م","الجمعية","أساسى قبل 2021/6/30",7.0000000000000007E-2,"الأساسى بعد 2021/7/1","علاوة تشجعية","الأساسى بعد 2021/7/1",0.13,"13% بحد أدنى 75","الأساسى بعد 2021/7/1",0.15,"15% بحد أدنى 100","الأساسى بعد 2022/4/1","ملاحظات"]
[1,"روضة خيرى",480.53,{"$f":"C5*7%","v":33.637100000000004},{"$f":"SUM(C5:D5)","v":514.1671},0,0,{"$f":"E5*13%","v":66.841723000000002},75,{"$f":"E5+I5","v":589.1671},{"$f":"J5*$K$4","v":88.375064999999992},100,{"$f":"J5+L5","v":689.1671}]
[null,null,454.85,31.839500000000005,486.68950000000001,0,0,63.269635000000001,75,{"$f":"E6+I6","v":561.68949999999995},84.253424999999993,100,{"$f":"J6+L6","v":661.68949999999995},"تم تطبيق على الأساس 2020 بتاريخ 2022/3/1"]
[null,null,421.68,29.517600000000002,451.19760000000002,0,0,58.655688000000005,75,{"$f":"E7+I7","v":526.19759999999997},78.929639999999992,100,{"$f":"J7+L7","v":626.19759999999997}]
[2,"طلمبات برسيق",582.17999999999995,40.752600000000001,622.93259999999998,0,0,80.981238000000005,0.13,{"$f":"E8+H8","v":703.91383799999994},105.58707569999999,0.15,{"$f":"J8+K8","v":809.50091369999996}]
[null,null,462.34,32.363800000000005,494.7038,0,0,64.311493999999996,75,{"$f":"E9+I9","v":569.7038},85.455569999999994,100,{"$f":"J9+L9","v":669.7038}]
[null,null,455.92,31.914400000000004,487.83440000000002,0,0,63.418472000000001,75,562.83439999999996,84.425159999999991,100,662.83439999999996]
[null,null,219.45,15.361500000000001,234.8115,0,0,30.525494999999999,75,309.81150000000002,46.471724999999999,100,409.81150000000002]
[" ق","جواد حسنى",482.67,33.786900000000003,516.45690000000002,0,0,0,0,516.45690000000002,77.468535000000003,100,616.45690000000002,null,null,null,"ديرامس",null,null,null,565.69000000000005,0.05,{"$f":"U12*V12","v":28.284500000000005},{"$f":"U12+W12","v":593.97450000000003}]
[4,"بطورس",428,29.960000000000004,457.96,0,0,{"$f":"E13*13%","v":59.534799999999997},75,532.96,79.944000000000003,100,632.96]
[null,null,347.75,24.342500000000001,372.09249999999997,0,0,{"$f":"E14*13%","v":48.372025000000001},75,447.09249999999997,67.063874999999996,100,547.09249999999997]
[null,null,660,0,660,0,0,0,0,660,99,100,760]
[5,"ديرأمس",528.67999999999995,{"$f":"C16*7%","v":37.007599999999996},565.68759999999997,{"$f":"E16*N16","v":{"$error":"#VALUE!"}},{"$f":"E16+F16","v":{"$error":"#VALUE!"}},{"$f":"E16*13%","v":73.539388000000002},75,{"$f":"H16+I16","v":148.539388},null,null,null,"تم منحه علاوة تشجعية قبل الطلوع على المعاش","علاوة تشجعية"]
[null,null,425.96,29.8172,455.77719999999999,0,0,59.251035999999999,75,{"$f":"E17+I17","v":530.77719999999999},{"$f":"J17*$K$4","v":79.616579999999999},100,{"$f":"J17+L17","v":630.77719999999999}]
[6,"القروى",282,19.740000000000002,301.74,0,0,39.226200000000006,75,{"$f":"E18+I18","v":376.74}]
[null,null,144,10.080000000000002,154.08000000000001,0,0,20.030400000000004,75,{"$f":"E19+I19","v":229.08}]
[7,"قافلة",810.09,56.706300000000006,866.79630000000009,0,0,112.68351900000002,0.13,{"$f":"E20+H20","v":979.47981900000013},{"$f":"J20*$K$4","v":146.92197285},0.15,{"$f":"J20+K20","v":1126.4017918500001}]
[null,null,791.9,55.433000000000007,847.33299999999997,0,0,110.15329,0.13,{"$f":"E21+H21","v":957.48628999999994},143.62294349999999,0.15,{"$f":"J21+K21","v":1101.1092334999998}]
[null,null,620,0,620,0,0,80.600000000000009,0.13,{"$f":"E22+H22","v":700.6},105.09,0.15,{"$f":"J22+K22","v":805.69},null,null,null,null,null,null,2.5,{"$f":"T22*30","v":75}]
[8,"الزينى",452.71,{"$f":"C23*7%","v":31.689700000000002},484.3997,0,0,62.971961,75,{"$f":"E23+I23","v":559.39969999999994},83.909954999999982,100,{"$f":"J23+L23","v":659.39969999999994},null,null,null,null,{"$f":"75/30","v":2.5}]
[null,null,505,{"$f":"C24*7%","v":35.35},540.35,0,0,70.245500000000007,75,{"$f":"E24+I24","v":615.35},92.302499999999995,100,{"$f":"J24+L24","v":715.35}]
[null,null,660,0,660,null,null,0,0,{"$f":"E25","v":660},99,100,{"$f":"J25+L25","v":760}]
[9,"قنديل",543.55999999999995,{"$f":"C26*7%","v":38.049199999999999},581.60919999999999,0,0,{"$f":"E26*13%","v":75.609195999999997},75,{"$f":"E26+I26","v":656.60919999999999},null,null,null,"معاش 2021/11/28",null,null,null,null,null,null,{"$f":"27*T22","v":67.5}]
[null,null,385.2,26.964000000000002,412.16399999999999,0,0,53.581319999999998,75,487.16399999999999,{"$f":"J27*$K$4","v":73.07459999999999},100,{"$f":"J27+L27","v":587.16399999999999}]
[10,"النخلة البحرية",522.16,36.551200000000001,558.71119999999996,0,0,72.632455999999991,75,633.71119999999996,95.056679999999986,100,733.71119999999996]
[null,null,367.1,25.697000000000003,392.79700000000003,0,0,51.063610000000004,75,467.79700000000003,70.169550000000001,100,567.79700000000003]
[null,null,155.15,10.860500000000002,166.01050000000001,0,0,21.581365000000002,75,241.01050000000001,36.151575000000001,100,341.01049999999998]
[11,"أبويوسف",503,35.21,538.21,0,0,69.967300000000009,75,613.21,91.981499999999997,100,713.21]
[null,null,492.3,34.461000000000006,526.76099999999997,0,0,68.478929999999991,75,601.76099999999997,90.264149999999987,100,701.76099999999997]
[12,"سحالى",578.97,40.527900000000002,619.49790000000007,0,0,80.534727000000018,0.13,{"$f":"E33+H33","v":700.03262700000005},105.00489405,0.15,{"$f":"J33+K33","v":805.03752105000001},"فقط نبيل فتحى محمدعبدالقادر في الجمعية"]
[null,null,458.06,32.064200000000007,490.12420000000003,0,0,0,0,{"$f":"E34","v":490.12420000000003},73.518630000000002,100,{"$f":"J34+L34","v":590.12419999999997}]
[null,null,565,39.550000000000004,604.54999999999995,0,0,0,0,{"$f":"E35","v":604.54999999999995},90.68249999999999,100,{"$f":"J35+L35","v":704.55}]
[13,"الصخرة",556.5,38.955000000000005,595.45500000000004,0,0,{"$f":"E36*13%","v":77.409150000000011},0.13,{"$f":"E36+H36","v":672.86415000000011},{"$f":"J36*K4","v":100.92962250000001},0.15,{"$f":"J36+K36","v":773.79377250000016}]
[14,"العشرة",444.15,31.090500000000002,{"$f":"SUM(C37:D37)","v":475.2405},0,0,61.781265000000005,75,{"$f":"E37+I37","v":550.2405},{"$f":"J37*$K$4","v":82.536074999999997},100,{"$f":"J37+L37","v":650.2405}]
[null,null,471.97,33.037900000000008,505.00790000000006,0,0,65.651027000000013,75,580.00790000000006,{"$f":"J38*$K$4","v":87.001185000000007},100,{"$f":"J38+L38","v":680.00790000000006}]
[null,null,485.88,34.011600000000001,519.89160000000004,0,0,67.585908000000003,75,594.89160000000004,{"$f":"J39*$K$4","v":89.233739999999997},100,{"$f":"J39+L39","v":694.89160000000004}]
[15,"محل كيل",474,33.18,507.18,0,0,65.933400000000006,75,582.18000000000006]
[null,null,418,29.26,447.26,0,0,58.143799999999999,75,522.26]
[16,"الجرادات",407.24,28.506800000000002,435.74680000000001,0,0,56.647084,75,510.74680000000001,{"$f":"J42*$K$4","v":76.612020000000001},100,{"$f":"J42+L42","v":610.74680000000001}]
[null,null,407.24,28.506800000000002,435.74680000000001,0,0,56.647084,75,510.74680000000001,{"$f":"J43*$K$4","v":76.612020000000001},100,{"$f":"J43+L43","v":610.74680000000001}]
[null,null,250,{"$f":"C44*0%","v":0},250,null,{"$f":"C44","v":250},32.5,75,325,{"$f":"J44*$K$4","v":48.75},100,{"$f":"J44+L44","v":425}]
[17,"ابوكبارية",187.2,{"$f":"C45*7%","v":13.104000000000001},200.304,0,0,26.03952]
[18,"كفرحصام",428,{"$f":"C46*7%","v":29.960000000000004},457.96,0,0,59.534799999999997,75,{"$f":"E46+I46","v":532.96},{"$f":"J46*$K$4","v":79.944000000000003},100,{"$f":"J46+L46","v":632.96}]
[19,null,580,0,580,null,null,75.400000000000006,0.13,{"$f":"E47+H47","v":655.4},{"$f":"J47*$K$4","v":98.309999999999988},100,{"$f":"J47+L47","v":755.4}]
[19,"برسيق",485,{"$f":"C48*7%","v":33.950000000000003},518.95000000000005,0,0,67.46350000000001,0,{"$f":"E48+I48","v":518.95000000000005},{"$f":"J48*$K$4","v":77.842500000000001},100,{"$f":"J48+L48","v":618.95000000000005}]
[20,"بلقطر الغربية",286.86,20.080200000000001,306.9402,0,0,39.902225999999999,75,{"$f":"E49+I49","v":381.9402},{"$f":"J49*$K$4","v":57.291029999999999},100,{"$f":"J49+L49","v":481.9402}]
[null,null,250.48,17.5336,268.0136,0,0,34.841768000000002,75,{"$f":"E50+I50","v":343.0136},{"$f":"J50*$K$4","v":51.452039999999997},100,{"$f":"J50+L50","v":443.0136}]
[21,"بسنتواى",413.12,28.918400000000002,442.03840000000002,0,0,57.464992000000002,75,{"$f":"E51+I51","v":517.03840000000002}]
[null,null,413.12,28.918400000000002,442.03840000000002,0,0,57.464992000000002,75,{"$f":"E52+I52","v":517.03840000000002}]
[22,"بركة غطاس",556.5,38.955000000000005,595.45500000000004,0,0,77.409150000000011,0.13,{"$f":"E53+H53","v":672.86415000000011},{"$f":"J53*$K$4","v":100.92962250000001},0.15,{"$f":"J53+K53","v":773.79377250000016}]
[null,null,135,9.4500000000000011,144.44999999999999,0,0,18.778499999999998,75,{"$f":"E54+I54","v":219.45},{"$f":"J54*$K$4","v":32.917499999999997},100,{"$f":"J54+L54","v":319.45}]
[null,null,620,0,620,0,0,80.600000000000009,0.13,{"$f":"E55+H55","v":700.6},{"$f":"J55*$K$4","v":105.09},0.15,{"$f":"J55+K55","v":805.69}]
[23,"الغابة",283.64999999999998,{"$f":"C56*7%","v":19.855499999999999},303.50549999999998,0,0,39.455714999999998,75,{"$f":"E56+I56","v":378.50549999999998},null,null,null,null,7.0000000000000007E-2,"*2","جمع","*6",{"$f":"Q57*4","v":559.24680000000001},{"$f":"O57*2","v":93.207800000000006},{"$f":"S56+T56","v":652.45460000000003},null,null,null,7.0000000000000007E-2,null,null,null,null,null,0.13]
[24,"المشتركة ",665.77,46.603900000000003,712.37389999999994,0,0,0,null,0,{"$f":"J57*$K$4","v":0},null,{"$f":"J57+K57","v":0},null,{"$f":"C57*7%","v":46.603900000000003},{"$f":"O57*2","v":93.207800000000006},{"$f":"O57+P57","v":139.8117},{"$f":"Q57*6","v":838.87020000000007},838.87019999999995,139.8117,null,{"$f":"D57","v":46.603900000000003},{"$f":"V57*2","v":93.207800000000006},{"$f":"V57+W57","v":139.8117},{"$f":"X57*6","v":838.87020000000007},null,{"$f":"E57","v":712.37389999999994},{"$f":"AA57*13%","v":92.608606999999992},{"$f":"AB57*2","v":185.21721399999998},{"$f":"AB57+AC57","v":277.82582099999996},{"$f":"AD57*9","v":2500.4323889999996},null,{"$f":"AB57*9","v":833.47746299999994},null,{"$f":"AG57+AH57","v":833.47746299999994}]
[null,null,724.49,50.714300000000009,775.20429999999999,0,0,{"$f":"E58*13%","v":100.77655900000001},0.13,{"$f":"E58+H58","v":875.98085900000001},131.39712885,0.15,{"$f":"J58+K58","v":1007.37798785},null,50.714300000000009,101.42860000000002,152.14290000000003,{"$f":"Q58*6","v":912.8574000000001},912.85739999999998,152.1429,null,50.714300000000009,{"$f":"V58*2","v":101.42860000000002},{"$f":"V58+W58","v":152.14290000000003},{"$f":"X58*6","v":912.8574000000001},null,775.20429999999999,{"$f":"AA58*13%","v":100.77655900000001},{"$f":"AB58*2","v":201.55311800000001},{"$f":"AB58+AC58","v":302.329677},{"$f":"AD58*9","v":2720.9670930000002},null,{"$f":"AB58*9","v":906.98903100000007},{"$f":"AG58*2","v":1813.9780620000001},{"$f":"AG58+AH58","v":2720.9670930000002}]
[null,null,647.45000000000005,45.321500000000007,692.77150000000006,0,0,90.060295000000011,0.13,782.83179500000006,117.42476925,0.15,{"$f":"J59+K59","v":900.25656425000011},null,45.321500000000007,90.643000000000015,135.96450000000002,815.78700000000003,815.78700000000003,135.96449999999999,null,45.321500000000007,90.643000000000015,135.96450000000002,815.78700000000003,null,692.77150000000006,90.060295000000011,180.12059000000002,270.18088500000005,2431.6279650000006,null,810.54265500000008,1621.0853100000002,2431.6279650000001]
[null,null,647.45000000000005,45.321500000000007,692.77150000000006,0,0,90.060295000000011,0.13,782.83179500000006,117.42476925,0.15,{"$f":"J60+K60","v":900.25656425000011},null,45.321500000000007,90.643000000000015,135.96450000000002,815.78700000000003,815.78700000000003,135.96449999999999,null,45.321500000000007,90.643000000000015,135.96450000000002,815.78700000000003,null,692.77150000000006,90.060295000000011,180.12059000000002,270.18088500000005,2431.6279650000006,null,810.54265500000008,1621.0853100000002,2431.6279650000001]
[null,null,537.77,37.643900000000002,575.41390000000001,0,0,74.803807000000006,0.13,650.21770700000002,97.53265605,100,{"$f":"J61+L61","v":750.21770700000002},null,37.643900000000002,75.287800000000004,112.93170000000001,677.5902000000001,677.59019999999998,112.93170000000001,null,37.643900000000002,75.287800000000004,112.93170000000001,677.5902000000001,null,575.41390000000001,74.803807000000006,149.60761400000001,224.41142100000002,2019.7027890000002,null,673.23426300000006,1346.4685260000001,2019.7027890000002]
[null,null,620,43.400000000000006,663.4,0,0,86.242000000000004,0.13,749.64199999999994,112.44629999999999,0.15,{"$f":"J62+K62","v":862.08829999999989},null,43.400000000000006,86.800000000000011,130.20000000000002,781.2,781.2,130.19999999999999,null,43.400000000000006,86.800000000000011,130.20000000000002,781.2,null,663.4,86.242000000000004,172.48400000000001,258.726,2328.5340000000001,null,776.178,1552.356,2328.5340000000001]
[null,null,620,43.400000000000006,663.4,0,0,86.242000000000004,0.13,749.64199999999994,112.44629999999999,0.15,862.08829999999989,null,43.400000000000006,86.800000000000011,130.20000000000002,781.2,781.2,130.19999999999999,null,43.400000000000006,86.800000000000011,130.20000000000002,781.2,null,663.4,86.242000000000004,172.48400000000001,258.726,2328.5340000000001,null,776.178,1552.356,2328.5340000000001]
[null,null,620,43.400000000000006,663.4,0,0,86.242000000000004,0.13,749.64199999999994,112.44629999999999,0.15,862.08829999999989,null,43.400000000000006,86.800000000000011,130.20000000000002,781.2,781.2,130.19999999999999,null,43.400000000000006,86.800000000000011,130.20000000000002,781.2,null,663.4,86.242000000000004,172.48400000000001,258.726,2328.5340000000001,null,776.178,1552.356,2328.5340000000001]
[null,null,585,40.950000000000003,625.95000000000005,0,0,81.373500000000007,0.13,707.32350000000008,106.09852500000001,0.15,813.42202500000008]
[null,null,620,0,620,0,0,80.600000000000009,0.13,700.6,105.09,0.15,805.69,null,null,null,null,null,null,null,null,{"$f":"D66","v":0},0,0,0,null,{"$f":"E66","v":620},80.600000000000009,161.20000000000002,241.8,2176.2000000000003,null,725.40000000000009,null,725.40000000000009]
[null,null,620,0,620,0,0,0,75,{"$f":"E67+I67","v":695},104.25,0.15,799.25]
[25,"صندوق التمويل",501.34,{"$f":"C68*7%","v":35.093800000000002},536.43380000000002,0,0,{"$f":"E68*13%","v":69.736394000000004},0,536.43380000000002,80.465069999999997,100,{"$f":"J68+L68","v":636.43380000000002},null,null,null,null,null,null,null,null,{"$f":"D68","v":35.093800000000002},70.187600000000003,105.2814,631.6884]
[null,"التمويل",620,{"$f":"C69*7%","v":43.400000000000006},{"$f":"SUM(C69:D69)","v":663.4},0,0,86.242000000000004,{"$f":"E69*13%","v":86.242000000000004},749.64199999999994,112.44629999999999,0.15,{"$f":"J69+K69","v":862.08829999999989},null,{"$f":"I69*8","v":689.93600000000004},null,null,{"$f":"I69*3","v":258.726},{"$f":"R69*2","v":517.452},null,null,null,null,null,null,null,{"$f":"E69","v":663.4},{"$f":"AA69*13%","v":86.242000000000004},{"$f":"AB69*2","v":172.48400000000001},{"$f":"AB69+AC69","v":258.726},{"$f":"AD69*8","v":2069.808}]
[null,null,620,0,620,0,0,80.600000000000009,{"$f":"E70*13%","v":80.600000000000009},700.6,105.09,0.15,{"$f":"J70+K70","v":805.69},null,{"$f":"I70*8","v":644.80000000000007},null,null,{"$f":"I70*3","v":241.8},{"$f":"R70*2","v":483.6},null,null,null,null,null,null,null,{"$f":"E70","v":620},{"$f":"AA70*13%","v":80.600000000000009},{"$f":"AB70*2","v":161.20000000000002},{"$f":"AB70+AC70","v":241.8},{"$f":"AD70*8","v":1934.4}]
[27,"بريدان",493.37,{"$f":"C71*7%","v":34.535900000000005},527.90589999999997,0,0,68.627767000000006,75,602.90589999999997,90.435884999999999,100,{"$f":"J71+L71","v":702.90589999999997}]
[null,null,436.66,30.566200000000006,467.22620000000001,0,0,60.739406000000002,75,542.22620000000006,81.333930000000009,100,642.22620000000006]
[null,null,474.11,33.187700000000007,507.29770000000002,0,0,65.948701,75,582.29770000000008,87.344655000000003,100,682.29770000000008]
[28,"دسونس",538.30999999999995,37.681699999999999,575.99169999999992,0,0,74.878920999999991,75,650.99169999999992,97.64875499999998,100,750.99169999999992]
[null,null,464.48,32.513600000000004,496.99360000000001,0,0,64.609168000000011,75,571.99360000000001,85.799040000000005,100,671.99360000000001]
[29,"راضى",149.80000000000001,10.486000000000002,160.286,null,null,20.83718,75,235.286,35.292899999999996,100,335.286]
[30,"ب .الشرقية",245.67,0,245.67,"تم عمل علاوة 12% بحد أدنى أبتداء من 1/7/2020",null,0,null,245.67,36.850499999999997,100,345.66999999999996]
[31,"كوم القناطر",null,0]
[null,null,null,0]
[null,null,505,0,{"$f":"SUM(C80:D80)","v":505},null,null,{"$f":"E80*13%","v":65.650000000000006},75,{"$f":"E80+I80","v":580}]
[32,"زاوية نعيم",472.5,{"$f":"C81*7%","v":33.075000000000003},{"$f":"C81+D81","v":505.57499999999999},null,null,{"$f":"E81*13%","v":65.72475},75,{"$f":"E81+I81","v":580.57500000000005}]
[null,null,442,{"$f":"C82*7%","v":30.94},{"$f":"C82+D82","v":472.94},null,null,{"$f":"E82*13%","v":61.482199999999999},75,{"$f":"E82+I82","v":547.94000000000005}]
[null,"كفرعزاز",660,0,660,null,null,0,0,{"$f":"E83","v":660},{"$f":"J83*$K$4","v":99},100,{"$f":"J83+L83","v":760}]
[null,null,null,null,null,null,null,{"$f":"E84*13%","v":0}]

{"sheet":"الهيئة القومية للتأمينات","index":6,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,0,1,8],[2,0,2,8],[3,0,3,8],[8,6,9,6],[8,7,9,7],[8,8,9,8],[8,1,9,1],[8,0,9,0],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5]]}
[]
["الهيئة القومية للتأمين الاجنماعى"]
["صندوق العاملين بقطاعى الأعمال العام والخاص"]
["العاملين المستمرين بمنشاه محددة"]
[]
[null,null,"منطقة ","البحيرة"]
[null,null,"رقم وأسم المنشاة",598367]
[]
["م","الرقم التأمينى","أسم","مهنة",null,"تاريخ","أجر الأشتراك","29.75% للتأمينات","ملاحظات"]
[]
[1,16831967,"أيهاب أحمد محمود ","محاسب",null,"2020-06-20",1200,{"$f":"ROUNDDOWN(G11*29.75%,2)","v":357}]
[2,19375513,"سمير محمد عبدالخالق","خفير خصوصى",null,"2020-01-01",2015.75,{"$f":"ROUNDDOWN(G12*29.75%,2)","v":599.67999999999995}]
[3,46168704,"محمد السيد محمد ","سائق جرار زراعى",null,"2020-01-01",2105.84,626.48]
[4,52277435,"مصطفى على أحمد ","سائق ",null,"2020-01-01",2193,652.41]
[5,53191641,"أيمن محمد محمد ","خفير خصوصى",null,"2020-01-01",2015.75,599.67999999999995]
[6,55067032,"تامر محفوظ محمد ","فراش - ساعى",null,"2020-01-01",2015.75,599.67999999999995]
[7,62427824,"محمود أحمد عبدالمنعم ","محاسب",null,"2020-01-01",1200,357]
[8,63912271,"محمود السيد محمد جمعة","أمين مخازن",null,"2020-06-20",1200,357]
[9,64766836,"حااتم رأفت إبراهيم على","سائق ",null,"2020-01-01",1200,357]
[10,72645762,"ياسر محمد كامل سعد ","فنى تشغيل ",null,"2020-06-20",1200,357]
[11,78028486,"أحمد محمد قطب محمد ","مهندس زراعى",null,"2020-01-01",1200,357]

{"sheet":"Sheet2","index":7,"n_rows":37,"n_cols":17,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,1,"المشتركة "]
[null,2,"صندوق التمويل",null,null,null,null,null,null,"مصطفى على سليمان",1158.49,{"$f":"K3*15%","v":173.77349999999998},{"$f":"K3+L3","v":1332.2635}]
[null,3,"التمويل ",null,null,null,null,null,null,"أيمن محمد حسن",1035.3,{"$f":"K4*15%","v":155.29499999999999},{"$f":"K4+L4","v":1190.595}]
[null,4,"بسنتواى",null,null,null,null,null,null,"تامر محفوظ محمد ",1035.3,{"$f":"K5*15%","v":155.29499999999999},1190.595]
[null,5,"ابوهواش",null,null,null,null,null,null,"حاتم رأفت ابراهيم على",875.41,150,1025.4099999999999]
[null,6,"العشرة",null,null,null,null,null,null,"أحمد قطب أبوشليل ",991.4,150,1141.4000000000001]
[null,7,"النخلة البحرية ",null,null,null,null,null,null,"أحمد سعد عطية إبراهيم ",991.404,150,1141.404]
[null,8,"ابوكبارية",null,null,null,null,null,null,"محمود السيد محمد جمعة ",938.42,150,1088.42]
[null,9,"بريدان",null,null,null,null,null,null,"أحمد عطية عبدالرحمن محمود",805.69,150,955.69]
[null,10,"ط.برسيق",null,null,null,null,null,null,"محمود محمد عبدالله قطب نمر",930.69,150,1080.69]
[null,11,"البركة ",null,null,null,null,null,null,"محمود أحمد عبدالمنعم",712.37390000000005,150,862.37390000000005]
[null,12,"الغابة "]
[null,13,"ابويوسف",null,null,null,null,null,null,null,null,null,null," ",1489.66,{"$f":"O14*7%","v":104.27620000000002},{"$f":"O14+P14","v":1593.9362000000001}]
[null,14,"برسيق",null,null,null,null,null,null,null,null,null,null,null,1080.69,{"$f":"O15*7%","v":75.648300000000006},{"$f":"O15+P15","v":1156.3383000000001}]
[null,15,"القروى"]
[null,16,"سحالى "]
[null,17,"زاوية نعيم"]
[null,18,"سحالى "]
[null,19,"زاوية نعيم"]
[null,20,"الجرادات "]
[null,21,"كفرعزاز",null,null,null,null,null,null,null,1332.26,{"$f":"K22*7%","v":93.258200000000002},{"$f":"K22+L22","v":1425.5182},{"$f":"L22*5","v":466.291}]
[null,22,"الروضة خيرى ",null,null,null,null,null,null,null,1190.5999999999999,{"$f":"K23*7%","v":83.341999999999999},{"$f":"K23+L23","v":1273.942},{"$f":"L23*5","v":416.71}]
[null,23,"دسونس",null,null,null,null,null,null,null,1190.5999999999999,83.341999999999999,1273.942,416.71]
[null,24,"ديرامس ",null,null,null,null,null,null,null,1025.4100000000001,71.778700000000015,1097.1887000000002,358.89350000000007]
[null,25,"قافلة ",null,null,null,null,null,null,null,1141.4000000000001,79.89800000000001,1221.298,399.49000000000007]
[null,26,"قنديل",null,null,null,null,null,null,null,1316.04,92.122800000000012,1408.1628000000001,460.61400000000003]
[null,27,"كفرحصام",null,null,null,null,null,null,null,1088.42,76.189400000000006,1164.6094000000001,380.947]
[null,28,"كوم القناطر",null,null,null,null,null,null,null,1080.69,75.648300000000006,1156.3383000000001,378.24150000000003]
[null,29,"الزينى ",null,null,null,null,null,null,null,862.37,60.365900000000003,922.73590000000002,{"$f":"L30*5","v":301.8295}]
[null,30,"الصخرة "]
[null,31,"بطورس"]
[null,32,"ب.الشرقية"]
[null,33,"ب.الغربية"]
[null,34,"محلة كيل"]
[null,35,"راضى"]
[null,36,"جواد حسنى "]