{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Total","Excursion","Shopping","Bonus","Remo Code"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":6,"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":"Total","index":0,"n_rows":74,"n_cols":9,"rows_kept":74,"cut":false,"hidden":false,"merged":[[73,1,73,2]]}
["Numb","Remo Code","Guıde Name","Excursion","Shopping","Bonus","Total Comm","Signature","Remarks "]
[1,{"$f":"IFERROR(VLOOKUP(C2,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&D$1&\"'!\"&\"C2:C1000\"),$C2,INDIRECT(\"'\"&D$1&\"'!\"&\"h2:h1000\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&E$1&\"'!\"&\"C3:C1000\"),$C2,INDIRECT(\"'\"&E$1&\"'!\"&\"E3:E1000\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&F$1&\"'!\"&\"B3:B1000\"),$C2,INDIRECT(\"'\"&F$1&\"'!\"&\"d3:d1000\")))","v":0},{"$f":"SUM(D2:F2)","v":0}]
[2,{"$f":"IFERROR(VLOOKUP(C3,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&D$1&\"'!\"&\"C2:C1000\"),$C3,INDIRECT(\"'\"&D$1&\"'!\"&\"h2:h1000\")))","v":0},0,{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&F$1&\"'!\"&\"B3:B1000\"),$C3,INDIRECT(\"'\"&F$1&\"'!\"&\"d3:d1000\")))","v":0},{"$f":"SUM(D3:F3)","v":0}]
[3,{"$f":"IFERROR(VLOOKUP(C4,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[4,{"$f":"IFERROR(VLOOKUP(C5,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,{"$f":"SUM(D5:F5)","v":0}]
[5,{"$f":"IFERROR(VLOOKUP(C6,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[6,{"$f":"IFERROR(VLOOKUP(C7,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,{"$f":"SUM(D7:F7)","v":0}]
[7,{"$f":"IFERROR(VLOOKUP(C8,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[8,{"$f":"IFERROR(VLOOKUP(C9,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[9,{"$f":"IFERROR(VLOOKUP(C10,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[10,{"$f":"IFERROR(VLOOKUP(C11,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[11,{"$f":"IFERROR(VLOOKUP(C12,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[12,{"$f":"IFERROR(VLOOKUP(C13,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[13,{"$f":"IFERROR(VLOOKUP(C14,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[14,{"$f":"IFERROR(VLOOKUP(C15,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[15,{"$f":"IFERROR(VLOOKUP(C16,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[16,{"$f":"IFERROR(VLOOKUP(C17,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[17,{"$f":"IFERROR(VLOOKUP(C18,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[18,{"$f":"IFERROR(VLOOKUP(C19,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[19,{"$f":"IFERROR(VLOOKUP(C20,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[20,{"$f":"IFERROR(VLOOKUP(C21,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[21,{"$f":"IFERROR(VLOOKUP(C22,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[22,{"$f":"IFERROR(VLOOKUP(C23,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[23,{"$f":"IFERROR(VLOOKUP(C24,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[24,{"$f":"IFERROR(VLOOKUP(C25,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[25,{"$f":"IFERROR(VLOOKUP(C26,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,{"$f":"SUM(D26:F26)","v":0}]
[26,{"$f":"IFERROR(VLOOKUP(C27,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[27,{"$f":"IFERROR(VLOOKUP(C28,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[28,{"$f":"IFERROR(VLOOKUP(C29,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[29,{"$f":"IFERROR(VLOOKUP(C30,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[30,{"$f":"IFERROR(VLOOKUP(C31,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[31,{"$f":"IFERROR(VLOOKUP(C32,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[32,{"$f":"IFERROR(VLOOKUP(C33,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[33,{"$f":"IFERROR(VLOOKUP(C34,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[34,{"$f":"IFERROR(VLOOKUP(C35,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[35,{"$f":"IFERROR(VLOOKUP(C36,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[36,{"$f":"IFERROR(VLOOKUP(C37,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[37,{"$f":"IFERROR(VLOOKUP(C38,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[38,{"$f":"IFERROR(VLOOKUP(C39,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[39,{"$f":"IFERROR(VLOOKUP(C40,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[40,{"$f":"IFERROR(VLOOKUP(C41,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[41,{"$f":"IFERROR(VLOOKUP(C42,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[42,{"$f":"IFERROR(VLOOKUP(C43,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[43,{"$f":"IFERROR(VLOOKUP(C44,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[44,{"$f":"IFERROR(VLOOKUP(C45,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[45,{"$f":"IFERROR(VLOOKUP(C46,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[46,{"$f":"IFERROR(VLOOKUP(C47,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[47,{"$f":"IFERROR(VLOOKUP(C48,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[48,{"$f":"IFERROR(VLOOKUP(C49,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[49,{"$f":"IFERROR(VLOOKUP(C50,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[50,{"$f":"IFERROR(VLOOKUP(C51,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[51,{"$f":"IFERROR(VLOOKUP(C52,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[52,{"$f":"IFERROR(VLOOKUP(C53,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[53,{"$f":"IFERROR(VLOOKUP(C54,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[54,{"$f":"IFERROR(VLOOKUP(C55,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[55,{"$f":"IFERROR(VLOOKUP(C56,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[56,{"$f":"IFERROR(VLOOKUP(C57,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[57,{"$f":"IFERROR(VLOOKUP(C58,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[58,{"$f":"IFERROR(VLOOKUP(C59,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[59,{"$f":"IFERROR(VLOOKUP(C60,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[60,{"$f":"IFERROR(VLOOKUP(C61,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[61,{"$f":"IFERROR(VLOOKUP(C62,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[62,{"$f":"IFERROR(VLOOKUP(C63,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[63,{"$f":"IFERROR(VLOOKUP(C64,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[64,{"$f":"IFERROR(VLOOKUP(C65,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[65,{"$f":"IFERROR(VLOOKUP(C66,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[66,{"$f":"IFERROR(VLOOKUP(C67,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[67,{"$f":"IFERROR(VLOOKUP(C68,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[68,{"$f":"IFERROR(VLOOKUP(C69,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[69,{"$f":"IFERROR(VLOOKUP(C70,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[70,{"$f":"IFERROR(VLOOKUP(C71,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[71,{"$f":"IFERROR(VLOOKUP(C72,'Remo Code'!$B$2:$C$499,2,0),\"\")","v":""},null,0,0,0,0]
[]
[null,"TOTAL",null,{"$f":"SUM(D2:D73)","v":0},{"$f":"SUM($E$2:$E$73)","v":0},{"$f":"SUM($F$2:$F$73)","v":0},{"$f":"SUM($G$2:$G$73)","v":0}]

{"sheet":"Excursion","index":1,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[[30,2,30,3]]}
["Numb","Remo Code","Guıde Name","DEST","Days","Sales","Diger/Sales 5%","Real Comm"]
[1,null,"على محمد عويض الصقور المرى",null,0,0,6846.2899999999991,6846.2899999999991,null,"Comm from 01.09 till 15.09"]
[2,null,"علي عاطف سالم ابراهيم سالم",null,0,0,2145.14,2145.14,null,"Comm from 16.09 till 30.09"]
[3,null,"علي محمد عبدالله احمد شمس",null,0,44192,1767.6800000000003,1767.6800000000003]
[4,null,"عمر محمد محمود ابوزاهر",null,0,58245,2329.8000000000002,2329.8000000000002]
[5,null,"فهد سويد سلطان محمد الخوار",null,0,31420,1256.8,1256.8]
[6,null,"محمد حافظ محمد ابوالكلام كبيرالدين",null,0,13090,523.6,523.6]
[7,null,"محمد حسن حسن ناجى الجدره",null,0,84860,3394.4,3394.4]
[8,null,"محمد حمد محمد صالح الصرامى",null,0,50995,2039.8000000000002,2039.8000000000002]
[9,null,"محمد عبدالعزيز عبدالكريم يحى يعقوب",null,0,47639,1905.56,1905.56]
[10,null,"محمد عبدالله بخيت محمد المهيري",null,0,13255,530.20000000000005,530.20000000000005]
[11,null,"محمد هشام حامد على ابوخطيطه",null,0,43625,1745,1745]
[12,null,"محمد يوسف محمد ابراهيم محمد",null,0,90460,3618.4,3618.4]
[13,null,"محمد يونس محمد زحمت كش",null,0,13255,530.20000000000005,530.20000000000005]
[14,null,"بدر ناصر جابر سهل المرى",null,0,2085,83.4,83.4]
[15,null,"حزام زيد راشد المري",null,0,2854,114.16,114.16]
[16,null,"حسن محمود ابراهيم علي البنا",null,0,30545,1221.8000000000002,1221.8000000000002]
[17,null,"حمد سعيد سويلم سعد الخوار",null,0,4415,176.60000000000002,176.60000000000002]
[18,null,"حمد مبارك مفتاح فرج العبدالله",null,0,61520,2460.8000000000002,2460.8000000000002]
[19,null,"خالد عزيز حسن عبدربه حسن",null,0,47600,1904,1904]
[20,null,"دغش بريك دغش الجربوعى المرى",null,0,52570,2102.8000000000002,2102.8000000000002]
[21,null,"راشد حمد ناصر المري",null,0,47683,1907.3200000000002,1907.3200000000002]
[22,null,"راشد شريف خان عيسى خان",null,0,6170,246.8,246.8]
[23,null,"زياد مصطفى كامل محمد ابوالبها",null,0,2595,103.8,103.8]
[24,null,"سالم محمد راشد طفله الفهيده",null,0,3991.5,159.66,159.66]
[25,null,"شعيب عبدي قرني قلديد",null,0,44480,1779.2,1779.2]
[26,null,"عابدين حافظ عابدين موسى",null,0,4656.5,186.26,186.26]
[27,null,"عبدالرحمن صبرى عثمان محسن اليهرى",null,0,94617,3784.6800000000003,3784.6800000000003]
[28,null,"خالد عزيز حسن عبدربه حسن",null,0,2325,93,93]
[]
[null,null,"TOTAL",null,{"$f":"SUM(E2:E30)","v":0},{"$f":"SUM(F2:F30)","v":899143},{"$f":"SUM(G2:G30)","v":44957.150000000016},{"$f":"SUM(H2:H30)","v":44957.150000000016}]
[]
[null,null,null,null,null,null,null,"kontrol"]

{"sheet":"Shopping","index":2,"n_rows":79,"n_cols":7,"rows_kept":79,"cut":false,"hidden":false,"merged":[[1,0,1,6],[74,5,74,6]]}
[]
["HRG. Shop Commission for October 2021"]
["Serial","Remo Code","Guide Name","Total  Sales","Real Comission","Signature","Remarks "]
[1,null,"احمد حسن احمد سليمان الهيل",0,2162.9300000000003]
[2,null,"احمد عبداللاه احمد يحيى عبدالاله",0,555.52]
[3,null,"احمد محمود احمد عبدالسميع عثمان",51,2.5500000000000003]
[4,null,"جمال عبدالغفار كمال على",879.5,43.975000000000001]
[5,null,"حسن محمد العبود الصالح",1857.1599999999999,73.277999999999992]
[6,null,"خالد مصعب خضر عبدالله تايه",962,29.62]
[7,null,"سيف سعيد احمد عبدالمجيد عبدالرحيم",326.89999999999998,16.344999999999999]
[8,null,"شعيب خالد شعيب جاب الله",2147.88,67.593999999999994]
[9,null,"عادل سعيد فتحي مصطفى عوض  الله",594.59999999999991,29.73]
[10,null,"عامر محمد عمر عجيز",1461.3899999999999,46.469500000000004]
[11,null,"عبدالرحمن خالد محمد سليمان الشيخ",76.19,3.8094999999999999]
[12,null,"عبدالرحمن قارى محمد اقبال",482.08,24.103999999999999]
[13,null,"عبدالله فتحي سيد محمد جمعه",645.20000000000005,32.26]
[14,null,"عدنان محمد رضا كرار سليمان",1947.44,65.931999999999988]
[15,null,"على هصام حامد على الحبابى",197.76,9.8880000000000017]
[16,null,"عمر عبدالباسط ابراهيم محمد",899.47,44.973500000000001]
[17,null,"عمر فؤاد اسماعيل ثابت",349.14,17.456999999999997]
[18,null,"عمر مصطفى محمد عوه",223.69,11.1845]
[19,null,"عمر هشام على بحيرى ابوالخير",3564.57,114.9085]
[20,null,"فادي عدنان احمد عبدالجليل",282.81,10.580500000000001]
[21,null,"مازن محمود السيد عبدالله عبدالوهاب",411.68,20.584000000000003]
[22,null,"محمد احمد محمود شناق",2880.4,96.98]
[23,null,"محمد عبدالله السيد بيومي حسن",1049.52,35.045999999999999]
[24,null,"محمد عقيل عدنان سيد احمد",1494.58,55.268999999999998]
[25,null,"محمد علي عطيت الله ابراهيم عبداللاه",569.71,25.905500000000004]
[26,null,"محمد عمر عبدالرحيم على",401.6,20.080000000000002]
[27,null,"محمد عمر فتحى عبدالتواب عبدالمقصود",338.61,16.930499999999999]
[28,null,"محمود حبيب الله",340.81,11.7005]
[29,null,"محمود عادل عبدالمحسن محمد",3992.51,123.36549999999998]
[30,null,"معتز احمد كامل على خوالده",224.84,11.242000000000001]
[31,null,"مهنا احمد محمد سيف النعيمى",170.07,8.5035000000000007]
[32,null,"مؤمن شريف محمد التاج",143.76999999999998,7.1885000000000012]
[33,null,"ياسين احمد صلاح عبداللطيف",491.39,24.569500000000001]
[34,null,"يوسف محمد سليمان موسى عامر",54.56,2.7280000000000002]
[35,null,"احمد اسامه جميل ابوالعلا",255.39999999999998,12.77]
[36,null,"أحمد اقبال ابواصبع",163.51,8.1754999999999995]
[37,null,"احمد شريف ابراهيم الدسوقى عوض",168.81,8.4405000000000001]
[38,null,"امين بن المنذر بن عثمان",79.31,3.9655000000000005]
[39,null,"براء اشرف سعيد زكي السيد",118.37,5.9185000000000008]
[40,null,"بريك سالم دغش الجربوعى المرى",28.94,1.4470000000000001]
[41,null,"جوين عماد عبدالحليم داود",410.68,20.534000000000002]
[42,null,"حمد ناجى مسعد احمد الطيرى",2,0.1]
[43,null,"محمد عمر عبدالرحيم على",70.070000000000007,3.5034999999999998]
[44,null,"محمد عمر فتحى عبدالتواب عبدالمقصود",22.37,1.1185]
[45,null,"محمود حبيب الله",346.06,17.303000000000001]
[46,null,"محمود عادل عبدالمحسن محمد",25,1.25]
[47,null,"معتز احمد كامل على خوالده",10,0.5]
[48,null,"مهنا احمد محمد سيف النعيمى",34,1.7000000000000002]
[49,null,"مؤمن شريف محمد التاج",0,0]
[50,null,"ياسين احمد صلاح عبداللطيف",19956,798.24000000000024]
[51,null,"يوسف محمد سليمان موسى عامر",23172,926.87999999999988]
[52,null,"احمد اسامه جميل ابوالعلا",13479,539.16]
[53,null,"أحمد اقبال ابواصبع",23308,932.31999999999994]
[54,null,"احمد شريف ابراهيم الدسوقى عوض",20246,809.83999999999992]
[55,null,"امين بن المنذر بن عثمان",10802,432.07999999999993]
[56,null,"براء اشرف سعيد زكي السيد",27911,1116.44]
[57,null,"بريك سالم دغش الجربوعى المرى",17509,700.36]
[58,null,"جوين عماد عبدالحليم داود",25979,1039.1599999999996]
[59,null,"حمد ناجى مسعد احمد الطيرى",15084,603.36]
[60,null,"خالد ناصر محمد ناصر الدهيمى",15218,608.71999999999991]
[61,null,"راشد حمد على البكرى اليافعى",7508,300.32000000000005]
[62,null,"رامي سعد فراج فرج علي",9137,365.48]
[63,null,"زكي واءلئ شحده عطيه ابوعيده",17239,689.56]
[64,null,"زيد محمود احمد خشان",9038,361.52]
[65,null,"سالم محمد سالم البطى الكعبى",647,25.880000000000003]
[66,null,"سلمان محمد اسلام ناصر احمد",1763,70.52]
[67,null,"سيف فهد موسى حسن على",4983,199.32]
[68,null,"عبدالرحمن اشرف فتحى سالم نصار",4983,199.32]
[69,null,"عبدالرحمن جمال على صالح سيد",3228,129.12]
[70,null,"عبدالرحمن محمد محسن البكري",52,2.08]
[71,null,"عبدالرحمن هيثم اديب ابودلو",181,5.4299999999999988]
[null,null,null,{"$f":"SUM(D4:D74)","v":302670.34999999998},{"$f":"SUM(E4:E74)","v":14765.037499999999}]
[]
[]
[null,null,{"$f":"IFERROR(INDEX($F$1:$F$149,MATCH(0,INDEX(COUNTIF(C$1:$H77,$F$1:$F$149),),0)),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX($F$1:$F$149,MATCH(0,INDEX(COUNTIF(C$1:$H78,$F$1:$F$149),),0)),\"\")","v":""}]

{"sheet":"Bonus","index":3,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,2,1],[0,0,0,3],[28,0,28,1]]}
["BONUS For The Guides From 01.10 till 31.10.2021"]
["N","Name,Surname","Comm.","Real Bonus"]
[null,null,"Amount $","Amount $"]
[1,"احمد حسن احمد سليمان الهيل",null,{"$f":"8.8+(1.4/2)+179.6+(118.8/2)","v":248.5}]
[2,"احمد عبداللاه احمد يحيى عبدالاله",null,{"$f":"(1.4/2)+(118.8/2)","v":60.1}]
[3,"احمد محمود احمد عبدالسميع عثمان",166,{"$f":"C6*0.8","v":132.80000000000001}]
[4,"جمال عبدالغفار كمال على",104,83.2]
[5,"حسن محمد العبود الصالح",224,179.20000000000002]
[6,"خالد مصعب خضر عبدالله تايه",129,103.2]
[7,"سيف سعيد احمد عبدالمجيد عبدالرحيم",53,42.400000000000006]
[8,"شعيب خالد شعيب جاب الله",54,43.2]
[9,"عادل سعيد فتحي مصطفى عوض  الله",228,182.4]
[10,"عامر محمد عمر عجيز",153,122.4]
[11,"عبدالرحمن خالد محمد سليمان الشيخ",42,33.6]
[12,"عبدالرحمن قارى محمد اقبال",10,8]
[13,"عبدالله فتحي سيد محمد جمعه",15,12]
[14,"عدنان محمد رضا كرار سليمان",2,1.6]
[15,"على هصام حامد على الحبابى",98,78.400000000000006]
[16,"عمر عبدالباسط ابراهيم محمد",40,{"$f":"C19*0.8","v":32}]
[17,"عمر فؤاد اسماعيل ثابت",44,35.200000000000003]
[18,"عمر مصطفى محمد عوه",72,57.6]
[19,"عمر هشام على بحيرى ابوالخير",36,28.8]
[20,"فادي عدنان احمد عبدالجليل",42,33.6]
[21,"مازن محمود السيد عبدالله عبدالوهاب",6,{"$f":"C24*0.8","v":4.8000000000000007}]
[22,"محمد احمد محمود شناق",2,1.6]
[23,"محمد عبدالله السيد بيومي حسن",6,4.8000000000000007]
[24,"محمد عقيل عدنان سيد احمد",2,1.6]
[25,"محمد علي عطيت الله ابراهيم عبداللاه",15,12]
["Total",null,{"$f":"SUM(C5:C28)","v":1543},{"$f":"SUM(D3:D28)","v":1542.9999999999998}]

{"sheet":"Remo Code","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}