{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Total","Excursion","Sheet1","Shopping","Bonus"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":5,"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":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,null,"من عمود H","من عمود D","من عمود C"]
["Numb","Guıde Name","Excursion","Shopping","Bonus","Total Comm"]
[1,"Ahmed Omar",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&C$2&\"'!\"&\"B2:B1000\"),$B3,INDIRECT(\"'\"&C$2&\"'!\"&\"H2:H1000\")))","v":3498.6480000000001},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&D$2&\"'!\"&\"B2:B1000\"),$B3,INDIRECT(\"'\"&D$2&\"'!\"&\"D2:D1000\")))","v":669.3900000000001},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&E$2&\"'!\"&\"B2:B1000\"),$B3,INDIRECT(\"'\"&E$2&\"'!\"&\"C2:C1000\")))","v":1147.9993993993994},{"$f":"SUM(C3:E3)","v":5316.0373993993999}]
[2,"Mohamed Said",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&C$2&\"'!\"&\"B2:B1000\"),$B4,INDIRECT(\"'\"&C$2&\"'!\"&\"H2:H1000\")))","v":1225.7915446036366},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&D$2&\"'!\"&\"B2:B1000\"),$B4,INDIRECT(\"'\"&D$2&\"'!\"&\"D2:D1000\")))","v":302.08},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&E$2&\"'!\"&\"B2:B1000\"),$B4,INDIRECT(\"'\"&E$2&\"'!\"&\"C2:C1000\")))","v":532.20180180180182},{"$f":"SUM(C4:E4)","v":2060.0733464054383}]
[3,"Israa Abdel Latif",1074.2415446036366,151.96,321.58318318318322,1547.78472778682]
[4,"Asmaa Reda",676.45165503308431,37.64,182.23423423423424,896.32588926731853]
[5,"Shawky Said",834.41154460363657,39.480000000000004,325.00300300300302,1198.8945476066397]
[6,"Selim Fathy",585.86080746205027,6.1000000000000005,222.57897897897899,814.53978644102926]
[7,"Naser Abdalla",823.1633032948431,300.8,315.20480480480484,1439.168108099648]
[8,"Fawzy Metwaly",704.92987290172312,197.50000000000003,38.193393393393393,940.62326629511654]
[9,"Amar Sherif",596.15486786647648,48.3,202.21141141141143,846.66627927788784]
[10,"Dina Hany",174.01667673716014,142.78,203.07387387387388,519.8705506110341]
[11,"Waleed  Moustafa",899.56154460363655,53.660000000000004,324.07927927927932,1277.3008238829159]
[12,"Wael Murad",881.4915446036365,98.68,131.43183183183186,1111.6033764354684]
[13,"Khaleed Medhat",979.05154460363644,85.6,212.9645645645646,1277.6161091682011]
[14,"Osama El Sayed",657.21659981836046,49.46,43.698498498498502,750.37509831685895]
[15,"Ziad Habib",820.23154460363662,13.26,53.121921921921924,886.61346652555858]
[16,"Farida Farouk",202.22667673716012,9.2800000000000011,132.92012012012012,344.42679685728024]
[17,"Mikail  Ibrahim",172.79667673716011,39.480000000000004,111.44144144144146,323.71811817860157]
[18,"Bishoy Mounir",834.41154460363657,326.27999999999997,165.58558558558559,1326.2771301892221]
[19,"Samy Ahmed ",685.2415446036365,157.95999999999998,221.88228228228229,1065.0838268859188]
[20,"Samir Ezat",763.70154460363642,225.18000000000004,148.69549549549549,763.70154460363642]
[]
[null,null,{"$f":"SUM(C3:C22)","v":17089.600582624382},{"$f":"SUM(D3:D22)","v":2954.8700000000003},5036.1051051051045,{"$f":"SUM($F$3:$F$23)","v":24706.700192233988}]

{"sheet":"Excursion","index":1,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Numb","Guıde Name","Sales","DDDD","EEEE","GGGGG","Total Comm","Real Comm"]
[1,"Ahmed Omar",0,0,0,0,3498.6480000000001,3498.6480000000001]
[2,"Mohamed Said",38827.5,1941.3750000000002,449.2415446036365,776.55,1225.7915446036366,1225.7915446036366,null,"Comm from 01.05  till 15.05"]
[3,"Israa Abdel Latif",31250,1562.5,449.2415446036365,625,1074.2415446036366,1074.2415446036366,null,"Comm from 16.05 till 31.05"]
[4,"Asmaa Reda",17833,891.65000000000009,319.79165503308434,356.66,676.45165503308431,676.45165503308431]
[5,"Shawky Said",19258.5,962.92499999999995,449.2415446036365,385.17,834.41154460363657,834.41154460363657]
[6,"Selim Fathy",15530.5,776.52499999999998,275.25080746205032,310.61,585.86080746205027,585.86080746205027]
[7,"Naser Abdalla",24089.833333333332,1204.4916666666668,341.36663662817637,481.79666666666662,823.1633032948431,823.1633032948431]
[8,"Fawzy Metwaly",15550.833333333332,777.54166666666663,393.91320623505646,311.01666666666665,704.92987290172312,704.92987290172312]
[9,"Amar Sherif",12878.5,643.92500000000007,338.58486786647643,257.57,596.15486786647648,596.15486786647648]
[10,"Dina Hany",3168,158.4,110.65667673716013,63.36,174.01667673716014,174.01667673716014]
[11,"Waleed  Moustafa",22516,1125.8,449.2415446036365,450.32,899.56154460363655,899.56154460363655]
[12,"Wael Murad",21612.5,1080.625,449.2415446036365,432.25,881.4915446036365,881.4915446036365]
[13,"Khaleed Medhat",26490.5,1324.5250000000001,449.2415446036365,529.80999999999995,979.05154460363644,979.05154460363644]
[14,"Osama El Sayed",13635,681.75,384.51659981836042,272.7,657.21659981836046,657.21659981836046]
[15,"Ziad Habib",18549.5,927.47500000000002,449.2415446036365,370.99,820.23154460363662,820.23154460363662]
[16,"Farida Farouk",4578.5,228.92500000000001,110.65667673716013,91.57,202.22667673716012,202.22667673716012]
[17,"Mikail  Ibrahim",3107,155.35000000000002,110.65667673716013,62.14,172.79667673716011,172.79667673716011]
[18,"Bishoy Mounir",19258.5,962.92499999999995,449.2415446036365,385.17,834.41154460363657,834.41154460363657]
[19,"Samy Ahmed ",11800,590,449.2415446036365,236,685.2415446036365,685.2415446036365]
[20,"Samir Ezat",15723,786.15,449.2415446036365,314.45999999999998,763.70154460363642,763.70154460363642]
[]
[null,"TOTAL",{"$f":"SUM(C2:C22)","v":335657.16666666669},16782.85833333333,6877.8092492910509,6713.1433333333325,17089.600582624382,17089.600582624382]
[]
[null,null,null,null,null,null,null,"kontrol"]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Shopping","index":3,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
["HRG. Shop Commission for May.2019"]
["Serial","Guide Name","Total  Sales","Real Comission","Signature","Remarks "]
[1,"Ahmed Omar",0,669.3900000000001]
[2,"Mohamed Said",7552,302.08]
[3,"Israa Abdel Latif",3799,151.96]
[4,"Asmaa Reda",941,37.64]
[5,"Shawky Said",987,39.480000000000004]
[6,"Selim Fathy",152.5,6.1000000000000005]
[7,"Naser Abdalla",7520,300.8]
[8,"Fawzy Metwaly",4937.5,197.50000000000003]
[9,"Amar Sherif",1207.5,48.3]
[10,"Dina Hany",3569.5,142.78]
[11,"Waleed  Moustafa",1341.5,53.660000000000004]
[12,"Wael Murad",2467,98.68]
[13,"Khaleed Medhat",2140,85.6]
[14,"Osama El Sayed",1236.5,49.46]
[15,"Ziad Habib",331.5,13.26]
[16,"Farida Farouk",232,9.2800000000000011]
[17,"Mikail  Ibrahim",987,39.480000000000004]
[18,"Bishoy Mounir",8157,326.27999999999997]
[19,"Samy Ahmed ",3949,157.95999999999998]
[20,"Samir Ezat",5629.5,225.18000000000004]
[]
[null,"Total",{"$f":"SUM(C4:C23)","v":57137},{"$f":"SUM(D4:D23)","v":2954.8700000000003}]

{"sheet":"Bonus","index":4,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["BONUS For The Guides From 01.05 till 31.05.2019"]
["N","Name,Surname","Real Bonus"]
[null,null,"Amount $"]
[6,"Ahmed Omar",1147.9993993993994]
[8,"Mohamed Said",532.20180180180182]
[9,"Israa Abdel Latif",321.58318318318322]
[10,"Asmaa Reda",182.23423423423424]
[11,"Shawky Said",325.00300300300302]
[12,"Selim Fathy",222.57897897897899]
[13,"Naser Abdalla",315.20480480480484]
[16,"Fawzy Metwaly",38.193393393393393]
[17,"Amar Sherif",202.21141141141143]
[18,"Dina Hany",203.07387387387388]
[19,"Waleed  Moustafa",324.07927927927932]
[20,"Wael Murad",131.43183183183186]
[21,"Khaleed Medhat",212.9645645645646]
[22,"Osama El Sayed",43.698498498498502]
[23,"Ziad Habib",53.121921921921924]
[25,"Farida Farouk",132.92012012012012]
[26,"Mikail  Ibrahim",111.44144144144146]
[27,"Bishoy Mounir",165.58558558558559]
[28,"Samy Ahmed ",221.88228228228229]
[29,"Samir Ezat",148.69549549549549]
["Total",null,{"$f":"SUM(C4:C23)","v":5036.1051051051045}]