{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Data","Direct 60%","Indirect 15%","Payslip"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"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":"Data","index":0,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,6,0,7],[5,3,5,4],[6,3,6,4],[15,1,15,5],[0,0,0,1],[0,3,0,5],[1,3,1,4],[2,3,2,4],[3,3,3,4],[4,3,4,4]]}
["Service Charge (12%)",null,null,"June",null,null,2019]
[null,37065.719999999987]
[null,55114.679999999986]
[null,165461.04]
[null,79536.12000000001]
[null,89773.78]
["Total Service Charge (12%)",{"$f":"SUM(B2:B6)","v":426951.33999999997}]
[]
["Total Service Charge","Amount","Percentage"]
["1- For Fracture, loss and Damage (20% For The Company)",{"$f":"B7*C10","v":85390.267999999996},0.2]
["2- Employees Directly connected to customers",{"$f":"B7*C11","v":256170.80399999997},0.6]
["3- Employees Not Directly connected to customers",{"$f":"B7*C12","v":64042.700999999994},0.15]
["4- Incentive for all staff ",{"$f":"B7*C13","v":21347.566999999999},0.05]
["Total Service Charge (12%)",{"$f":"SUM(B10:B13)","v":426951.33999999997},{"$f":"SUM(C10:C13)","v":1}]
[]
[null,"12% Distribution"]
["Service Charge (12%) Calculation (Details) :","1- 20%  For Fracture, loss and Damage","2- 60% Direct Employees (For Staff)","2- 15% Not Direct Employees (Restaurant Managers & Operation & Other categories of employees)","4- Incentive for all staff  (5%)","Total 12 %"]
[null,{"$f":"B2*20%","v":7413.1439999999975},{"$f":"B2*60%","v":22239.43199999999},{"$f":"B2*15%","v":5559.8579999999974},{"$f":"B2*5%","v":1853.2859999999994},{"$f":"SUM(B18:E18)","v":37065.719999999987}]
[null,{"$f":"B3*20%","v":11022.935999999998},{"$f":"B3*60%","v":33068.80799999999},{"$f":"B3*15%","v":8267.2019999999975},{"$f":"B3*5%","v":2755.7339999999995},{"$f":"SUM(B19:E19)","v":55114.679999999986}]
[null,33092.208000000006,99276.623999999996,24819.155999999999,8273.0520000000015,{"$f":"SUM(B20:E20)","v":165461.03999999998}]
[null,15907.224000000002,47721.672000000006,11930.418000000001,3976.8060000000005,{"$f":"SUM(B21:E21)","v":79536.12000000001}]
[null,17954.756000000001,53864.267999999996,13466.066999999999,4488.6890000000003,{"$f":"SUM(B22:E22)","v":89773.78}]
["Total Service Charge (12%)",{"$f":"SUM(B18:B22)","v":85390.268000000011},{"$f":"SUM(C18:C22)","v":256170.80399999995},{"$f":"SUM(D18:D22)","v":64042.700999999986},{"$f":"SUM(E18:E22)","v":21347.567000000003},{"$f":"SUM(F18:F22)","v":426951.33999999997}]
[]
[]
[]
["Current 12% (3% From Sales)","Sales","Net 2.5% Of Sales",{"$f":"'Direct 60%'!U5","v":"Net Salary"},"Distribution %"]
[null,{"$f":"B2/0.111","v":333925.40540540527},{"$f":"(B28*2.5%)-((B28*2.5%)*10%)","v":7513.3216216216179},{"$f":"'Direct 60%'!U7","v":18044.136939890708},{"$f":"C28/D28","v":0.41638575713819237}]
[null,{"$f":"B3/0.111","v":496528.64864864852},{"$f":"(B29*2.5%)-((B29*2.5%)*10%)","v":11171.894594594592},{"$f":"'Direct 60%'!U8","v":19164.147486338799},{"$f":"C29/D29","v":0.58295807849310799}]
[null,{"$f":"B4/0.111","v":1490640},33539.4,{"$f":"'Direct 60%'!U9","v":39583.131256830602},0.847315483517043]
[null,{"$f":"B5/0.111","v":716541.62162162166},16122.186486486489,{"$f":"'Direct 60%'!U10","v":27004.692622950817},0.59701425643276995]
[null,{"$f":"B6/0.111","v":808772.79279279278},18197.387837837839,{"$f":"'Direct 60%'!U11","v":24478.661147540985},0.74339800400668021]
["Total Service Charge (12%)",{"$f":"SUM(B28:B32)","v":3846408.4684684682},{"$f":"SUM(C28:C32)","v":86544.190540540541},{"$f":"SUM(D28:D32)","v":128274.76945355191}]

{"sheet":"Direct 60%","index":1,"n_rows":106,"n_cols":47,"rows_kept":106,"cut":false,"hidden":false,"merged":[[13,39,13,44],[105,43,105,44],[105,39,105,41],[105,0,105,5],[13,27,13,31],[13,0,13,10],[13,24,13,26],[13,11,13,12],[13,13,13,21],[13,22,13,23],[4,26,5,26],[4,27,4,29],[4,36,4,37],[4,34,4,35],[1,39,3,46],[4,42,5,42],[4,41,5,41],[4,40,5,40],[4,39,5,39],[1,25,1,37],[2,25,3,37],[4,25,5,25],[0,4,0,7],[1,6,1,7],[4,13,5,13],[4,14,5,14],[4,20,4,21],[4,18,5,18],[4,19,5,19],[3,20,3,23],[4,12,5,12],[4,22,4,23],[7,6,7,7],[4,15,5,15],[4,16,5,16],[4,17,5,17],[1,9,4,11],[1,12,1,23],[2,12,2,13],[2,14,2,15],[2,16,2,17],[2,18,2,23],[3,14,3,15],[3,16,3,17],[3,18,3,19]]}
["January",{"$f":"Data!A17","v":"Service Charge (12%) Calculation (Details) :"},"June",2019,"Number Of Staff",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deserved Mohandseen"]
["February",{"$f":"Data!A11","v":"2- Employees Directly connected to customers"},{"$f":"Data!C11","v":0.6},null,"Managers","Staff","Branch Name",null,null,"Employees ( Directly connected to customers) (60%)",null,null,"Service Charge (60% Of 12%) Calculation (Details) :",null,null,null,null,null,null,null,null,null,null,null,"Undeserved Mohandseen","Redistribute Deducted Amounts (From Equal Share Amount) To All Other Staff ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Distribute Other Hold (Add / Deducted) Amounts"]
["March",{"$f":"Data!A18","v":0},{"$f":"Data!C18","v":22239.43199999999},null,{"$f":"COUNTIF($E$16:$F$105,H3)","v":3},{"$f":"COUNTIF($E$16:$F$105,G3)","v":11},"Mohandssen","Mohandseen Managers","Deserved",null,null,null,"Divided into",null,"12% According To Net Salary",null,"12% According To Equal Share",null,"12% Calculation",null,null,null,null,null,"Deserved Maadi","Diff. Amount Of Equal Share ( Distribute For All Other Staff)"]
["April",{"$f":"Data!A19","v":0},{"$f":"Data!C19","v":33068.80799999999},null,{"$f":"COUNTIF($E$16:$F$105,H4)","v":3},{"$f":"COUNTIF($E$16:$F$105,G4)","v":14},"Maadi","Maadi Managers","Undeserved",null,null,null,0.85,0.15,0.3,null,0.7,null,"Equal Share",null,"% Salary",null,null,null,"Undeserved Maadi"]
["May",{"$f":"Data!A20","v":0},{"$f":"Data!C20","v":99276.623999999996},null,{"$f":"COUNTIF($E$16:$F$105,H5)","v":3},{"$f":"COUNTIF($E$16:$F$105,G5)","v":22},"City Stars","City Stars Managers",null,null,null,null,"Staff","Managers","Staff","Managers","Staff","Managers","Staff","Managers","Net Salary",null,"Distribution %",null,"Deserved City Stars","Branches","Deducted Amounts","Number Of Deserved Staff",null,null,{"$f":"O4","v":0.3},{"$f":"Q4","v":0.7},"Net Salary","Equal Share","Net Deducted Amount Summary",null,"Net Salary Without Undeserved Employees",null,null,"Branches","Add (Hold Amounts)","Deducted (Hold Amounts)","Hold Amounts",{"$f":"O4","v":0.3},{"$f":"Q4","v":0.7},"Net Salary","Equal Share"]
["June",{"$f":"Data!A21","v":0},{"$f":"Data!C21","v":47721.672000000006},null,{"$f":"COUNTIF($E$16:$F$105,H6)","v":3},{"$f":"COUNTIF($E$16:$F$105,G6)","v":14},"MOA","MOA Managers",null,{"$f":"Data!A1","v":"Service Charge (12%)"},"12% Amount","60% Directly Employees ",null,null,null,null,null,null,null,null,"Staff","Managers","Staff","Managers","Undeserved City Stars",null,null,"All Staff","Undeserved Staff","Net Staff","Distribute Deducted Amounts According To Net Salary","Distribute Deducted Amounts According To Equal Share","Distribution %","Amount","Amount","Distribution %","Employee Undeserved","Deserved Net Salary",null,null,null,null,null,"Distribute Deducted Amounts According To Net Salary","Distribute Deducted Amounts According To Equal Share","Distribution %","Amount"]
["July",{"$f":"Data!A22","v":0},{"$f":"Data!C22","v":53864.267999999996},null,{"$f":"COUNTIF($E$16:$F$105,H7)","v":3},{"$f":"COUNTIF($E$16:$F$105,G7)","v":14},"Concord","Concord Managers",null,{"$f":"Data!A2","v":0},{"$f":"Data!B2","v":37065.719999999987},{"$f":"Data!C18","v":22239.43199999999},{"$f":"L7*$M$4","v":18903.517199999991},{"$f":"L7*$N$4","v":3335.9147999999982},{"$f":"M7*$O$4","v":5671.0551599999972},1000.7744399999995,{"$f":"M7*$Q$4","v":13232.462039999993},2335.1403599999985,{"$f":"Q7/F3","v":1202.951094545454},{"$f":"R7/E3","v":778.38011999999947},{"$f":"SUMIF($E$16:$G$105,G3,$G$16:$G$105)","v":18044.136939890708},19751.264398907104,{"$f":"O7/U7","v":0.3142879694879076},{"$f":"P7/V7","v":5.0668879712600846E-2},"Deserved MOA",{"$f":"B3","v":0},{"$f":"SUMIF($D$16:$D$105,G3,$P$16:$P$105)","v":0},{"$f":"COUNTIF($D$16:$D$105,G3)","v":14},{"$f":"COUNTIF($R$16:$R$105,Y2)","v":0},{"$f":"AB7-AC7","v":14},{"$f":"AA7*$AE$5","v":0},{"$f":"AA7*$AF$5","v":0},{"$f":"AE7/(U7+V7)","v":0},{"$f":"AF7/AD7","v":0},{"$f":"SUMIF($D$16:$D$105,G3,$S$16:$S$105)","v":0},{"$f":"AI7/AL7","v":0},{"$f":"SUMIF($R$16:$R$105,Y2,$G$16:$G$105)","v":0},{"$f":"U7+V7-AK7","v":37795.401338797812},null,{"$f":"B3","v":0},null,null,{"$f":"AO7-AP7","v":0},{"$f":"AQ7*$AR$5","v":0},{"$f":"AQ7*$AS$5","v":0},{"$f":"AR7/(U7+V7)","v":0},{"$f":"AS7/(E3+F3)","v":0}]
["August",{"$f":"Data!A23","v":"Total Service Charge (12%)"},{"$f":"SUM(C3:C7)","v":256170.80399999995},null,{"$f":"SUM(E3:E7)","v":15},{"$f":"SUM(F3:F7)","v":75},null,null,null,{"$f":"Data!A3","v":0},{"$f":"Data!B3","v":55114.679999999986},{"$f":"Data!C19","v":33068.80799999999},{"$f":"L8*$M$4","v":28108.486799999991},{"$f":"L8*$N$4","v":4960.3211999999985},8432.5460399999974,1488.0963599999995,19675.940759999994,3472.2248399999989,{"$f":"Q8/F4","v":1405.4243399999996},{"$f":"R8/E4","v":1157.4082799999996},19164.147486338799,17922.23,{"$f":"O8/U8","v":0.44001675764659787},{"$f":"P8/V8","v":8.3030759007110141E-2},"Undeserved MOA",{"$f":"B4","v":0},{"$f":"SUMIF($D$16:$D$105,G4,$P$16:$P$105)","v":1198.0666504918031},{"$f":"COUNTIF($D$16:$D$105,G4)","v":17},{"$f":"COUNTIF($R$16:$R$105,Y4)","v":2},{"$f":"AB8-AC8","v":15},{"$f":"AA8*$AE$5","v":359.41999514754093},{"$f":"AA8*$AF$5","v":838.64665534426217},{"$f":"AE8/(U8+V8)","v":9.6914290234989264E-3},{"$f":"AF8/AD8","v":55.909777022950813},{"$f":"SUMIF($D$16:$D$105,G4,$S$16:$S$105)","v":359.41999514754099},{"$f":"AI8/AL8","v":9.9813832420641724E-3},{"$f":"SUMIF($R$16:$R$105,Y4,$G$16:$G$105)","v":1077.3408196721311},{"$f":"U8+V8-AK8","v":36009.036666666667},null,{"$f":"B4","v":0},null,null,{"$f":"AO8-AP8","v":0},{"$f":"AQ8*$AR$5","v":0},{"$f":"AQ8*$AS$5","v":0},{"$f":"AR8/(U8+V8)","v":0},{"$f":"AS8/(E4+F4)","v":0}]
["September",null,null,null,null,null,null,null,null,{"$f":"Data!A4","v":0},{"$f":"Data!B4","v":165461.04},{"$f":"Data!C20","v":99276.623999999996},{"$f":"L9*$M$4","v":84385.130399999995},{"$f":"L9*$N$4","v":14891.493599999998},25315.539119999998,4467.4480799999992,59069.591279999993,10424.045519999998,{"$f":"Q9/F5","v":2684.9814218181814},{"$f":"R9/E5","v":3474.6818399999993},39583.131256830602,17430.926666666666,0.63955372695866397,0.25629435344611623,"Deserved Concord",0,{"$f":"SUMIF($D$16:$D$105,G5,$P$16:$P$105)","v":4665.7054215201188},{"$f":"COUNTIF($D$16:$D$105,G5)","v":25},{"$f":"COUNTIF($R$16:$R$105,Y6)","v":4},21,{"$f":"AA9*$AE$5","v":1399.7116264560357},{"$f":"AA9*$AF$5","v":3265.9937950640829},2.4550289480082262E-2,155.5235140506706,{"$f":"SUMIF($D$16:$D$105,G5,$S$16:$S$105)","v":1399.7116264560359},{"$f":"AI9/AL9","v":2.6024107637046327E-2},{"$f":"SUMIF($R$16:$R$105,Y6,$G$16:$G$105)","v":3228.865901639344},{"$f":"U9+V9-AK9","v":53785.192021857925},null,0,null,null,0,0,0,0,0]
["October",null,null,null,null,null,null,null,null,{"$f":"Data!A5","v":0},{"$f":"Data!B5","v":79536.12000000001},{"$f":"Data!C21","v":47721.672000000006},{"$f":"L10*$M$4","v":40563.421200000004},{"$f":"L10*$N$4","v":7158.2508000000007},12169.026360000002,2147.4752400000002,28394.394840000001,5010.77556,{"$f":"Q10/F6","v":2028.1710600000001},{"$f":"R10/E6","v":1670.2585200000001},27004.692622950817,20131.566666666666,0.4506263607554547,0.10667203777814942,"Undeserved Concord",0,{"$f":"SUMIF($D$16:$D$105,G6,$P$16:$P$105)","v":1396.4456478688526},{"$f":"COUNTIF($D$16:$D$105,G6)","v":17},{"$f":"COUNTIF($R$16:$R$105,Y8)","v":1},16,{"$f":"AA10*$AE$5","v":418.93369436065575},{"$f":"AA10*$AF$5","v":977.51195350819671},8.8877161801622345E-3,61.094497094262294,{"$f":"SUMIF($D$16:$D$105,G6,$S$16:$S$105)","v":418.93369436065575},{"$f":"AI10/AL10","v":8.942338206927641E-3},{"$f":"SUMIF($R$16:$R$105,Y8,$G$16:$G$105)","v":287.92},{"$f":"U10+V10-AK10","v":46848.339289617485},null,0,null,null,0,0,0,0,0]
["November",null,null,null,null,null,null,null,null,{"$f":"Data!A6","v":0},{"$f":"Data!B6","v":89773.78},{"$f":"Data!C22","v":53864.267999999996},{"$f":"L11*$M$4","v":45784.627799999995},{"$f":"L11*$N$4","v":8079.6401999999989},13735.388339999998,2423.8920599999997,32049.239459999993,5655.7481399999988,{"$f":"Q11/F7","v":2289.2313899999995},{"$f":"R11/E7","v":1885.2493799999995},24478.661147540985,22147.183333333334,0.56111681342424202,0.10944471012491429,null,0,{"$f":"SUMIF($D$16:$D$105,G7,$P$16:$P$105)","v":3978.0086449180317},{"$f":"COUNTIF($D$16:$D$105,G7)","v":17},{"$f":"COUNTIF($R$16:$R$105,Y10)","v":3},14,{"$f":"AA11*$AE$5","v":1193.4025934754095},{"$f":"AA11*$AF$5","v":2784.6060514426222},2.5595302492911136E-2,198.90043224590158,{"$f":"SUMIF($D$16:$D$105,G7,$S$16:$S$105)","v":1193.4025934754095},{"$f":"AI11/AL11","v":2.6413778371500832E-2},{"$f":"SUMIF($R$16:$R$105,Y10,$G$16:$G$105)","v":1444.7811475409835},{"$f":"U11+V11-AK11","v":45181.063333333339},null,0,null,null,0,0,0,0,0]
["December",null,null,null,null,null,null,null,null,{"$f":"Data!A7","v":"Total Service Charge (12%)"},{"$f":"SUM(K7:K11)","v":426951.33999999997},{"$f":"SUM(L7:L11)","v":256170.80399999995},{"$f":"SUM(M7:M11)","v":217745.18339999998},{"$f":"SUM(N7:N11)","v":38425.620599999995},{"$f":"SUM(O7:O11)","v":65323.555019999993},11527.686179999999,152421.62837999995,26897.934419999994,{"$f":"(S7*F3)+(S8*F4)+(S9*F5)+(S10*F6)+(S11*F7)","v":152421.62837999995},{"$f":"(T7*E3)+(T8*E4)+(T9*E5)+(T10*E6)+(T11*E7)","v":26897.934419999994},{"$f":"SUM(U7:U11)","v":128274.76945355191},97383.17106557377,null,null,null,"Total ",{"$f":"SUM(AA7:AA11)","v":11238.226364798806},90,10,80,3371.467909439642,7866.7584553591641,null,{"$f":"(AD7*AH7)+(AD8*AH8)+(AD9*AH9)+(AD10*AH10)+(AD11*AH11)","v":7866.7584553591641},{"$f":"SUM(AI7:AI11)","v":3371.467909439642},null,null,null,null,"Total",{"$f":"SUM(AO7:AO11)","v":0},{"$f":"SUM(AP7:AP11)","v":0},{"$f":"SUM(AQ7:AQ11)","v":0},{"$f":"SUM(AR7:AR11)","v":0},0,null,{"$f":"((AU7*(E3+F3))+(AU8*(E4+F4))+(AU9*(E5+F5))+(AU10*(E6+F6))+(AU11*(E7+F7)))","v":0}]
[]
["Employees Data",null,null,null,null,null,null,null,null,null,null,"Service Charge (60% Of 12%) Calculation",null,"Redistribute Deducted Amounts (From Equal Share Amount) To All Other Staff ",null,null,null,null,null,null,null,null,null,null,"Distribute Other Hold (Add / Deducted) Amounts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"El- Ahly ( ACH ) Payroll Data"]
["#","Employee Name","Employee ID","Branch","Division / Department","Job Description / Occupation","Net Salary","Grade","Incentive %","Number Of Work Years","Date Of Joining","12% According To Net Salary Total","12% Equal Share Total","Number Of Days (Sick Leave & Absent (With/Without) Permission)","12% Equal Share Net","Diff. Amount Of Equal Share ( Distribute For All Other Staff)","General Distribution Condition","Distribution Condition","Distribute Deducted Amounts According To Net Salary","Redistribute Deducted Amounts According To Net Salary","Distribute Deducted Amounts According To Equal Share","Total Distribute Deducted Amounts","Total 12%","Tax 10%","Distribute Deducted Amounts According To Net Salary","Distribute Deducted Amounts According To Equal Share","Total Distribute Deducted Amounts","Net 12%","%","Total Package (Net)","Current 12% (Net)","12 % Diff. To Current",null,null,null,null,null,null,null,"Bank Branch Code","Acc. Num. for Transfer","Employee Name","NBOE Amount","Bank NBOE EMP. NUM.","Bank Code"]
[1,"aaaa1",20426,"Mohandssen","Mohandseen Managers","Assistant Manager",4616.9866666666676,8,{"$f":"IF(AND(H16>0,H16<=3),4%,IF(AND(H16>3,H16<=6),8%,IF(AND(H16>6,H16<=9),10%,IF(AND(H16>9,H16<=11),12%,IF(AND(H16>11,H16<=13),16%)))))","v":0.1},{"$f":"DAYS360(K16,TODAY(),1)","v":"1914-01-20"},"2005-04-01",{"$f":"IF(E16=\"Mohandseen Managers\",$X$7*G16,IF(E16=\"Mohandssen\",$W$7*G16,IF(E16=\"Maadi Managers\",$X$8*G16,IF(E16=\"Maadi\",$W$8*G16,IF(E16=\"City Stars Managers\",$X$9*G16,IF(E16=\"City Stars\",$W$9*G16,IF(E16=\"MOA Managers\",$X$10*G16,IF(E16=\"MOA\",$W$10*G16,IF(E16=\"Concord Managers\",$X$11*G16,IF(E16=\"Concord\",$W$11*G16))))))))))","v":233.93754204801533},{"$f":"IF(E16=\"Mohandseen Managers\",$T$7,IF(E16=\"Mohandssen\",$S$7,IF(E16=\"Maadi Managers\",$T$8,IF(E16=\"Maadi\",$S$8,IF(E16=\"City Stars Managers\",$T$9,IF(E16=\"City Stars\",$S$9,IF(E16=\"MOA Managers\",$T$10,IF(E16=\"MOA\",$S$10,IF(E16=\"Concord Managers\",$T$11,IF(E16=\"Concord\",$S$11))))))))))","v":778.38011999999947},null,{"$f":"(M16-(M16/30.5)*N16)","v":778.38011999999947},{"$f":"M16-O16","v":0},"Deserved","Deserved Mohandseen",{"$f":"IF(D16=\"Mohandssen\",$AG$7*G16,IF(D16=\"Maadi\",$AG$8*G16,IF(D16=\"City Stars\",$AG$9*G16,IF(D16=\"MOA\",$AG$10*G16,IF(D16=\"Concord\",$AG$11*G16)))))","v":0},{"$f":"IF(R16=\"Undeserved Mohandseen\",0,IF(R16=\"Deserved Mohandseen\",G16*$AJ$7,IF(R16=\"Undeserved Maadi\",0,IF(R16=\"Deserved Maadi\",G16*$AJ$8,IF(R16=\"Undeserved City Stars\",0,IF(R16=\"Deserved City Stars\",G16*$AJ$9,IF(R16=\"Undeserved MOA\",0,IF(R16=\"Deserved MOA\",G16*$AJ$10,IF(R16=\"Undeserved Concord\",0,IF(R16=\"Deserved Concord\",G16*$AJ$11))))))))))","v":0},{"$f":"IF(R16=\"Undeserved Mohandseen\",0,IF(R16=\"Deserved Mohandseen\",$AH$7,IF(R16=\"Undeserved Maadi\",0,IF(R16=\"Deserved Maadi\",$AH$8,IF(R16=\"Undeserved City Stars\",0,IF(R16=\"Deserved City Stars\",$AH$9,IF(R16=\"Undeserved MOA\",0,IF(R16=\"Deserved MOA\",$AH$10,IF(R16=\"Undeserved Concord\",0,IF(R16=\"Deserved Concord\",$AH$11))))))))))","v":0},{"$f":"T16+U16","v":0},{"$f":"L16+M16-P16+V16","v":1012.3176620480148},{"$f":"W16*10%","v":101.23176620480149},{"$f":"IF(D16=\"Mohandssen\",$AT$7*G16,IF(D16=\"Maadi\",$AT$8*G16,IF(D16=\"City Stars\",$AT$9*G16,IF(D16=\"MOA\",$AT$10*G16,IF(D16=\"Concord\",$AT$11*G16)))))","v":0},{"$f":"IF(D16=\"Mohandssen\",$AU$7,IF(D16=\"Maadi\",$AU$8,IF(D16=\"City Stars\",$AU$9,IF(D16=\"MOA\",$AU$10,IF(D16=\"Concord\",$AU$11)))))","v":0},{"$f":"SUM(Y16:Z16)","v":0},{"$f":"W16-X16+AA16","v":911.08589584321328},{"$f":"IFERROR(AB16/G16,0)","v":0.19733344746715312},{"$f":"G16+AB16","v":5528.0725625098812},{"$f":"IF(E16=\"Mohandseen Managers\",0,IF(E16=\"Mohandssen\",G16*Data!$E$28,IF(E16=\"Maadi Managers\",0,IF(E16=\"Maadi\",G16*Data!$E$29,IF(E16=\"City Stars Managers\",0,IF(E16=\"City Stars\",G16*Data!$E$30,IF(E16=\"MOA Managers\",0,IF(E16=\"MOA\",G16*Data!$E$31,IF(E16=\"Concord Managers\",0,IF(E16=\"Concord\",G16*Data!$E$32))))))))))","v":0},{"$f":"AB16-AE16","v":911.08589584321328},null,null,null,null,null,null,null,18000,null,"حسنين محمد محمود حسن",{"$f":"ROUND(AB16,2)","v":911.09},20426,"NBEGEGCXXXX"]
[2,"aaaa2",22855,"Mohandssen","Mohandseen Managers","Resturant Manager",8867.2416666666668,11,{"$f":"IF(AND(H17>0,H17<=3),4%,IF(AND(H17>3,H17<=6),8%,IF(AND(H17>6,H17<=9),10%,IF(AND(H17>9,H17<=11),12%,IF(AND(H17>11,H17<=13),16%)))))","v":0.12},{"$f":"DAYS360(K17,TODAY(),1)","v":"1901-06-24"},"2018-01-04",449.2932013908956,778.38011999999947,null,778.38011999999947,{"$f":"M17-O17","v":0},"Deserved","Deserved Mohandseen",{"$f":"IF(D17=\"Mohandssen\",$AG$7*G17,IF(D17=\"Maadi\",$AG$8*G17,IF(D17=\"City Stars\",$AG$9*G17,IF(D17=\"MOA\",$AG$10*G17,IF(D17=\"Concord\",$AG$11*G17)))))","v":0},{"$f":"IF(R17=\"Undeserved Mohandseen\",0,IF(R17=\"Deserved Mohandseen\",G17*$AJ$7,IF(R17=\"Undeserved Maadi\",0,IF(R17=\"Deserved Maadi\",G17*$AJ$8,IF(R17=\"Undeserved City Stars\",0,IF(R17=\"Deserved City Stars\",G17*$AJ$9,IF(R17=\"Undeserved MOA\",0,IF(R17=\"Deserved MOA\",G17*$AJ$10,IF(R17=\"Undeserved Concord\",0,IF(R17=\"Deserved Concord\",G17*$AJ$11))))))))))","v":0},{"$f":"IF(R17=\"Undeserved Mohandseen\",0,IF(R17=\"Deserved Mohandseen\",$AH$7,IF(R17=\"Undeserved Maadi\",0,IF(R17=\"Deserved Maadi\",$AH$8,IF(R17=\"Undeserved City Stars\",0,IF(R17=\"Deserved City Stars\",$AH$9,IF(R17=\"Undeserved MOA\",0,IF(R17=\"Deserved MOA\",$AH$10,IF(R17=\"Undeserved Concord\",0,IF(R17=\"Deserved Concord\",$AH$11))))))))))","v":0},{"$f":"T17+U17","v":0},{"$f":"L17+M17-P17+V17","v":1227.6733213908951},{"$f":"W17*10%","v":122.76733213908952},{"$f":"IF(D17=\"Mohandssen\",$AT$7*G17,IF(D17=\"Maadi\",$AT$8*G17,IF(D17=\"City Stars\",$AT$9*G17,IF(D17=\"MOA\",$AT$10*G17,IF(D17=\"Concord\",$AT$11*G17)))))","v":0},{"$f":"IF(D17=\"Mohandssen\",$AU$7,IF(D17=\"Maadi\",$AU$8,IF(D17=\"City Stars\",$AU$9,IF(D17=\"MOA\",$AU$10,IF(D17=\"Concord\",$AU$11)))))","v":0},{"$f":"SUM(Y17:Z17)","v":0},{"$f":"W17-X17+AA17","v":1104.9059892518055},0.12460537682257133,9972.1476559184721,{"$f":"IF(E17=\"Mohandseen Managers\",0,IF(E17=\"Mohandssen\",G17*Data!$E$28,IF(E17=\"Maadi Managers\",0,IF(E17=\"Maadi\",G17*Data!$E$29,IF(E17=\"City Stars Managers\",0,IF(E17=\"City Stars\",G17*Data!$E$30,IF(E17=\"MOA Managers\",0,IF(E17=\"MOA\",G17*Data!$E$31,IF(E17=\"Concord Managers\",0,IF(E17=\"Concord\",G17*Data!$E$32))))))))))","v":0},{"$f":"AB17-AE17","v":1104.9059892518055},null,null,null,null,null,null,null,"18000","1273000923564601016","ايهاب محمد شحاته محمد",{"$f":"ROUND(AB17,2)","v":1104.9100000000001},22855,"NBEGEGCXXXX"]
[3,"aaaa3",22898,"Mohandssen","Mohandseen Managers","Assistant Manager",6267.0360655737704,9,0.1,"1900-10-28","2018-09-03",317.54369656108867,778.38011999999947,null,778.38011999999947,{"$f":"M18-O18","v":0},"Deserved","Deserved Mohandseen",0,0,0,0,1095.9238165610882,109.59238165610883,0,0,0,986.33143490497935,0.15738403682134819,7253.3675004787501,{"$f":"IF(E18=\"Mohandseen Managers\",0,IF(E18=\"Mohandssen\",G18*Data!$E$28,IF(E18=\"Maadi Managers\",0,IF(E18=\"Maadi\",G18*Data!$E$29,IF(E18=\"City Stars Managers\",0,IF(E18=\"City Stars\",G18*Data!$E$30,IF(E18=\"MOA Managers\",0,IF(E18=\"MOA\",G18*Data!$E$31,IF(E18=\"Concord Managers\",0,IF(E18=\"Concord\",G18*Data!$E$32))))))))))","v":0},986.33143490497935,null,null,null,null,null,null,null,"18000",null,"محمد سيد عبد الرحمن بخيت",986.33,22898,"NBEGEGCXXXX"]
[1,"aaaa4",null,"Mohandssen","Mohandssen","Security",1238,2,0.04,"1910-07-11","2008-10-30",389.08850622602961,1202.951094545454,null,1202.951094545454,0,"Deserved","Deserved Mohandseen",0,0,0,0,1592.0396007714835,159.20396007714837,0,0,0,1432.8356406943351,1.1573793543572981,2670.8356406943349,{"$f":"IF(E19=\"Mohandseen Managers\",0,IF(E19=\"Mohandssen\",G19*Data!$E$28,IF(E19=\"Maadi Managers\",0,IF(E19=\"Maadi\",G19*Data!$E$29,IF(E19=\"City Stars Managers\",0,IF(E19=\"City Stars\",G19*Data!$E$30,IF(E19=\"MOA Managers\",0,IF(E19=\"MOA\",G19*Data!$E$31,IF(E19=\"Concord Managers\",0,IF(E19=\"Concord\",G19*Data!$E$32))))))))))","v":515.4855673370821},917.350073357253,null,null,null,null,null,null,null,null,null,"طارق حسن قبيس سليمان",1432.84]
[2,"aaaa5",20270,"Mohandssen","Mohandssen","C.T - Prep",3022.0702732240434,4,0.08,"1914-05-20","2004-12-01",949.80032982135072,1202.951094545454,null,1202.951094545454,0,"Deserved","Deserved Mohandseen",0,0,0,0,2152.7514243668047,215.27514243668048,0,0,0,1937.4762819301243,0.64110894412232222,4959.5465551541674,{"$f":"IF(E20=\"Mohandseen Managers\",0,IF(E20=\"Mohandssen\",G20*Data!$E$28,IF(E20=\"Maadi Managers\",0,IF(E20=\"Maadi\",G20*Data!$E$29,IF(E20=\"City Stars Managers\",0,IF(E20=\"City Stars\",G20*Data!$E$30,IF(E20=\"MOA Managers\",0,IF(E20=\"MOA\",G20*Data!$E$31,IF(E20=\"Concord Managers\",0,IF(E20=\"Concord\",G20*Data!$E$32))))))))))","v":1258.3470188412173},679.12926308890701,null,null,null,null,null,null,null,18000,null,"طه فرجانى على قرنى",1937.48,20270,"NBEGEGCXXXX"]
[3,"aaaa6",22140,"Mohandssen","Mohandssen","Food Server",1611.29,3,0.04,"1904-12-14","2014-06-25",506.40906235617064,1202.951094545454,null,1202.951094545454,0,"Deserved","Deserved Mohandseen",0,0,0,0,1709.3601569016246,170.93601569016246,0,0,0,1538.424141211462,0.95477793644313691,3149.714141211462,{"$f":"IF(E21=\"Mohandseen Managers\",0,IF(E21=\"Mohandssen\",G21*Data!$E$28,IF(E21=\"Maadi Managers\",0,IF(E21=\"Maadi\",G21*Data!$E$29,IF(E21=\"City Stars Managers\",0,IF(E21=\"City Stars\",G21*Data!$E$30,IF(E21=\"MOA Managers\",0,IF(E21=\"MOA\",G21*Data!$E$31,IF(E21=\"Concord Managers\",0,IF(E21=\"Concord\",G21*Data!$E$32))))))))))","v":670.91820661919792},867.50593459226411,null,null,null,null,null,null,null,18000,null,"شيماء سيد صابر فرغلى",1538.42,22140,"NBEGEGCXXXX"]
[4,"aaaa7",22612,"Mohandssen","Mohandssen","Baker",1300.3899999999999,3,0.04,"1903-05-02","2016-02-17",408.69693264238015,1202.951094545454,null,1202.951094545454,0,"Deserved","Deserved Mohandseen",0,0,0,0,1611.648027187834,161.16480271878342,0,0,0,1450.4832244690506,1.1154217000046529,2750.8732244690505,{"$f":"IF(E22=\"Mohandseen Managers\",0,IF(E22=\"Mohandssen\",G22*Data!$E$28,IF(E22=\"Maadi Managers\",0,IF(E22=\"Maadi\",G22*Data!$E$29,IF(E22=\"City Stars Managers\",0,IF(E22=\"City Stars\",G22*Data!$E$30,IF(E22=\"MOA Managers\",0,IF(E22=\"MOA\",G22*Data!$E$31,IF(E22=\"Concord Managers\",0,IF(E22=\"Concord\",G22*Data!$E$32))))))))))","v":541.46387472493393},909.01934974411665,null,null,null,null,null,null,null,"18000",null,"نورهان حامد على عبد الله",1450.48,22612,"NBEGEGCXXXX"]
[5,"aaaa8",22773,"Mohandssen","Mohandssen","Cook",1301.2,3,0.04,"1902-04-02","2017-03-22",408.95150589766541,1202.951094545454,null,1202.951094545454,0,"Deserved","Deserved Mohandseen",0,0,0,0,1611.9026004431194,161.19026004431194,0,0,0,1450.7123403988073,1.1149034279117793,2751.9123403988074,{"$f":"IF(E23=\"Mohandseen Managers\",0,IF(E23=\"Mohandssen\",G23*Data!$E$28,IF(E23=\"Maadi Managers\",0,IF(E23=\"Maadi\",G23*Data!$E$29,IF(E23=\"City Stars Managers\",0,IF(E23=\"City Stars\",G23*Data!$E$30,IF(E23=\"MOA Managers\",0,IF(E23=\"MOA\",G23*Data!$E$31,IF(E23=\"Concord Managers\",0,IF(E23=\"Concord\",G23*Data!$E$32))))))))))","v":541.80114718821596},908.91119321059136,null,null,null,null,null,null,null,18000,null,"حسن ابراهيم حسن ابراهيم",1450.71,22773,"NBEGEGCXXXX"]
[6,null,22814,"Mohandssen","Mohandssen","Dishwaser",1025.92,1,0.04,"1901-11-26","2017-07-29",322.43431365703418,1202.951094545454,null,1202.951094545454,0,"Deserved","Deserved Mohandseen",0,0,0,0,1525.3854082024882,152.53854082024881,0,0,0,1372.8468673822395,1.3381617157110099,2398.7668673822395,{"$f":"IF(E24=\"Mohandseen Managers\",0,IF(E24=\"Mohandssen\",G24*Data!$E$28,IF(E24=\"Maadi Managers\",0,IF(E24=\"Maadi\",G24*Data!$E$29,IF(E24=\"City Stars Managers\",0,IF(E24=\"City Stars\",G24*Data!$E$30,IF(E24=\"MOA Managers\",0,IF(E24=\"MOA\",G24*Data!$E$31,IF(E24=\"Concord Managers\",0,IF(E24=\"Concord\",G24*Data!$E$32))))))))))","v":427.17847596321434},945.66839141902506,null,null,null,null,null,null,null,18000,null,"على محمد سيد احمد قاعود",1372.85,22814,"NBEGEGCXXXX"]
[7,null,20488,"Mohandssen","Mohandssen","Prep",2664.4266666666667,3,0.04,"1913-08-23","2005-09-01",837.3972469161007,1202.951094545454,null,1202.951094545454,0,"Deserved","Deserved Mohandseen",0,0,0,0,2040.3483414615548,204.0348341461555,0,0,0,1836.3135073153994,0.68919649029512264,4500.7401739820662,{"$f":"IF(E25=\"Mohandseen Managers\",0,IF(E25=\"Mohandssen\",G25*Data!$E$28,IF(E25=\"Maadi Managers\",0,IF(E25=\"Maadi\",G25*Data!$E$29,IF(E25=\"City Stars Managers\",0,IF(E25=\"City Stars\",G25*Data!$E$30,IF(E25=\"MOA Managers\",0,IF(E25=\"MOA\",G25*Data!$E$31,IF(E25=\"Concord Managers\",0,IF(E25=\"Concord\",G25*Data!$E$32))))))))))","v":1109.4293149391901},726.88419237620928,null,null,null,null,null,null,null,18000,null,"فتحى فهمى عبد الكريم أدم",1836.31,20488,"NBEGEGCXXXX"]
[8,null,21248,"Mohandssen","Mohandssen","Food Server",2067.83,3,0.04,"1910-06-10","2008-12-01",649.89409194617997,1202.951094545454,null,1202.951094545454,0,"Deserved","Deserved Mohandseen",0,0,0,0,1852.845186491634,185.2845186491634,0,0,0,1667.5606678424706,0.80643025192712681,3735.3906678424705,{"$f":"IF(E26=\"Mohandseen Managers\",0,IF(E26=\"Mohandssen\",G26*Data!$E$28,IF(E26=\"Maadi Managers\",0,IF(E26=\"Maadi\",G26*Data!$E$29,IF(E26=\"City Stars Managers\",0,IF(E26=\"City Stars\",G26*Data!$E$30,IF(E26=\"MOA Managers\",0,IF(E26=\"MOA\",G26*Data!$E$31,IF(E26=\"Concord Managers\",0,IF(E26=\"Concord\",G26*Data!$E$32))))))))))","v":861.0149601830683},806.5457076594023,null,null,null,null,null,null,null,18000,null,"محمد صلاح محمد حيا الله",1667.56,21248,"NBEGEGCXXXX"]
[9,null,22172,"Mohandssen","Mohandssen","Food Server",1611.26,3,0.04,"1904-10-30","2014-08-10",506.39963371708598,1202.951094545454,null,1202.951094545454,0,"Deserved","Deserved Mohandseen",0,0,0,0,1709.3507282625401,170.93507282625401,0,0,0,1538.415655436286,0.95479044687777637,3149.675655436286,{"$f":"IF(E27=\"Mohandseen Managers\",0,IF(E27=\"Mohandssen\",G27*Data!$E$28,IF(E27=\"Maadi Managers\",0,IF(E27=\"Maadi\",G27*Data!$E$29,IF(E27=\"City Stars Managers\",0,IF(E27=\"City Stars\",G27*Data!$E$30,IF(E27=\"MOA Managers\",0,IF(E27=\"MOA\",G27*Data!$E$31,IF(E27=\"Concord Managers\",0,IF(E27=\"Concord\",G27*Data!$E$32))))))))))","v":670.90571504648381},867.50994038980218,null,null,null,null,null,null,null,18000,null,"محمد على محمد على",1538.42,22172,"NBEGEGCXXXX"]
[10,null,22912,"Mohandssen","Mohandssen","Food Server",1056.45,3,0.04,"1900-08-17","2018-11-15",332.02952536549998,1202.951094545454,null,1202.951094545454,0,"Deserved","Deserved Mohandseen",0,0,0,0,1534.9806199109539,153.4980619910954,0,0,0,1381.4825579198584,1.3076648756873097,2437.9325579198585,{"$f":"IF(E28=\"Mohandseen Managers\",0,IF(E28=\"Mohandssen\",G28*Data!$E$28,IF(E28=\"Maadi Managers\",0,IF(E28=\"Maadi\",G28*Data!$E$29,IF(E28=\"City Stars Managers\",0,IF(E28=\"City Stars\",G28*Data!$E$30,IF(E28=\"MOA Managers\",0,IF(E28=\"MOA\",G28*Data!$E$31,IF(E28=\"Concord Managers\",0,IF(E28=\"Concord\",G28*Data!$E$32))))))))))","v":439.89073312864338},941.591824791215,null,null,null,null,null,null,null,null,null,"هدير محمد عبد الفتاح على محمد",1381.48]
[11,null,22922,"Mohandssen","Mohandssen","Cook",1145.3,3,0.04,"1900-03-28","2019-04-07",359.95401145450057,1202.951094545454,null,1202.951094545454,0,"Deserved","Deserved Mohandseen",0,0,0,0,1562.9051059999547,156.29051059999549,0,0,0,1406.6145953999592,1.2281625734741632,2551.9145953999591,{"$f":"IF(E29=\"Mohandseen Managers\",0,IF(E29=\"Mohandssen\",G29*Data!$E$28,IF(E29=\"Maadi Managers\",0,IF(E29=\"Maadi\",G29*Data!$E$29,IF(E29=\"City Stars Managers\",0,IF(E29=\"City Stars\",G29*Data!$E$30,IF(E29=\"MOA Managers\",0,IF(E29=\"MOA\",G29*Data!$E$31,IF(E29=\"Concord Managers\",0,IF(E29=\"Concord\",G29*Data!$E$32))))))))))","v":476.88660765037173},929.72798774958744,null,null,null,null,null,null,null,null,null,"اندرو سعد حليم جرجس",1406.61]
[1,null,20103,"Maadi","Maadi Managers","S R .Assistant Manager",6577.2,9,0.1,"1917-09-01","2001-08-01",546.1099081415648,1157.4082799999996,0,1157.4082799999996,0,"Deserved","Deserved Maadi",63.742466973357139,65.649553859704469,55.909777022950813,121.55933088265527,1825.0775190242198,182.507751902422,0,0,0,1642.5697671217977,0.24973693473237818,8219.7697671217975,{"$f":"IF(E30=\"Mohandseen Managers\",0,IF(E30=\"Mohandssen\",G30*Data!$E$28,IF(E30=\"Maadi Managers\",0,IF(E30=\"Maadi\",G30*Data!$E$29,IF(E30=\"City Stars Managers\",0,IF(E30=\"City Stars\",G30*Data!$E$30,IF(E30=\"MOA Managers\",0,IF(E30=\"MOA\",G30*Data!$E$31,IF(E30=\"Concord Managers\",0,IF(E30=\"Concord\",G30*Data!$E$32))))))))))","v":0},1642.5697671217977,null,null,null,null,null,null,null,18000,null,"أحمد فهمى موسى موسى",1642.57,20103,"NBEGEGCXXXX"]
[2,null,30021,"Maadi","Maadi Managers","S R .Assistant Manager",7026.8666666666668,9,0.1,"1911-04-06","2008-02-01",583.44607277509533,1157.4082799999996,0,1157.4082799999996,0,"Deserved","Deserved Maadi",68.100379557590486,70.137849190886001,55.909777022950813,126.04762621383682,1866.9019789889317,186.69019789889319,0,0,0,1680.2117810900386,0.23911251782539944,8707.0784477567049,{"$f":"IF(E31=\"Mohandseen Managers\",0,IF(E31=\"Mohandssen\",G31*Data!$E$28,IF(E31=\"Maadi Managers\",0,IF(E31=\"Maadi\",G31*Data!$E$29,IF(E31=\"City Stars Managers\",0,IF(E31=\"City Stars\",G31*Data!$E$30,IF(E31=\"MOA Managers\",0,IF(E31=\"MOA\",G31*Data!$E$31,IF(E31=\"Concord Managers\",0,IF(E31=\"Concord\",G31*Data!$E$32))))))))))","v":0},1680.2117810900386,null,null,null,null,null,null,null,"0377","3775000875832201018","عبد الغنى محمد عزت منصور خاطر",1680.21,30021,"NBEGEGCXXXX"]
[3,null,20161,"Maadi","Maadi Managers","Assistant Manager",4318.163333333333,8,0.1,"1916-04-09","2003-01-01",358.54037908333936,1157.4082799999996,0,1157.4082799999996,0,"Deserved","Deserved Maadi",41.849173456875533,43.1012431318293,55.909777022950813,99.011020154780113,1614.959679238119,161.49596792381192,0,0,0,1453.4637113143071,0.33659303715877059,5771.6270446476401,{"$f":"IF(E32=\"Mohandseen Managers\",0,IF(E32=\"Mohandssen\",G32*Data!$E$28,IF(E32=\"Maadi Managers\",0,IF(E32=\"Maadi\",G32*Data!$E$29,IF(E32=\"City Stars Managers\",0,IF(E32=\"City Stars\",G32*Data!$E$30,IF(E32=\"MOA Managers\",0,IF(E32=\"MOA\",G32*Data!$E$31,IF(E32=\"Concord Managers\",0,IF(E32=\"Concord\",G32*Data!$E$32))))))))))","v":0},1453.4637113143071,null,null,null,null,null,null,null,18000,null,"عبد الهادى محمد عبد الهادى عطيه",1453.46,20161,"NBEGEGCXXXX"]
[1,null,20156,"Maadi","Maadi","Security",1461.08,2,0.04,"1916-04-09","2003-01-01",642.8996842622912,1405.4243399999996,0,1405.4243399999996,0,"Deserved","Deserved Maadi",14.15995311765381,14.58359942731512,55.909777022950813,70.493376450265927,2118.8174007125563,211.88174007125565,0,0,0,1906.9356606413007,1.3051548584891319,3368.0156606413007,{"$f":"IF(E33=\"Mohandseen Managers\",0,IF(E33=\"Mohandssen\",G33*Data!$E$28,IF(E33=\"Maadi Managers\",0,IF(E33=\"Maadi\",G33*Data!$E$29,IF(E33=\"City Stars Managers\",0,IF(E33=\"City Stars\",G33*Data!$E$30,IF(E33=\"MOA Managers\",0,IF(E33=\"MOA\",G33*Data!$E$31,IF(E33=\"Concord Managers\",0,IF(E33=\"Concord\",G33*Data!$E$32))))))))))","v":851.74838932471016},1055.1872713165906,null,null,null,null,null,null,null,18000,null,"محمد عوض حسين سعيد محمد",1906.94,20156,"NBEGEGCXXXX"]
[2,null,21286,"Maadi","Maadi","C.T - Food Server",2001.1100000000001,4,0.08,"1910-01-01","2009-05-11",880.52193389418346,1405.4243399999996,0,1405.4243399999996,0,"Deserved","Deserved Maadi",19.393615533213939,19.973845819527039,55.909777022950813,75.883622842477848,2361.8298967366609,236.1829896736661,0,0,0,2125.6469070629946,1.0622339137093886,4126.7569070629943,{"$f":"IF(E34=\"Mohandseen Managers\",0,IF(E34=\"Mohandssen\",G34*Data!$E$28,IF(E34=\"Maadi Managers\",0,IF(E34=\"Maadi\",G34*Data!$E$29,IF(E34=\"City Stars Managers\",0,IF(E34=\"City Stars\",G34*Data!$E$30,IF(E34=\"MOA Managers\",0,IF(E34=\"MOA\",G34*Data!$E$31,IF(E34=\"Concord Managers\",0,IF(E34=\"Concord\",G34*Data!$E$32))))))))))","v":1166.5632404533435},959.08366660965112,null,null,null,null,null,null,null,18000,null,"هشام محمود عليوه عبده الحجار",2125.65,21286,"NBEGEGCXXXX"]
[3,null,21667,"Maadi","Maadi","Food Server",1610,3,0.04,"1907-05-12","2012-01-16",708.42697981102253,1405.4243399999996,0,1405.4243399999996,0,"Deserved","Deserved Maadi",15.603200727833272,16.070027019723316,55.909777022950813,71.979804042674132,2185.8311238536962,218.58311238536965,0,0,0,1967.2480114683267,1.2218931748250477,3577.2480114683267,{"$f":"IF(E35=\"Mohandseen Managers\",0,IF(E35=\"Mohandssen\",G35*Data!$E$28,IF(E35=\"Maadi Managers\",0,IF(E35=\"Maadi\",G35*Data!$E$29,IF(E35=\"City Stars Managers\",0,IF(E35=\"City Stars\",G35*Data!$E$30,IF(E35=\"MOA Managers\",0,IF(E35=\"MOA\",G35*Data!$E$31,IF(E35=\"Concord Managers\",0,IF(E35=\"Concord\",G35*Data!$E$32))))))))))","v":938.56250637390383},1028.6855050944228,null,null,null,null,null,null,null,18000,null,"محمد صابر السيد مصطفى",1967.25,21667,"NBEGEGCXXXX"]
[4,null,22382,"Maadi","Maadi","Prep",1560.655737704918,3,0.04,"1904-04-09","2015-03-04",686.71467750747729,1405.4243399999996,0,1405.4243399999996,0,"Deserved","Deserved Maadi",15.124984312083571,15.577503026959167,55.909777022950813,71.487280049909984,2163.6262975573868,216.36262975573868,0,0,0,1947.2636678016481,1.2477214678140813,3507.9194055065664,{"$f":"IF(E36=\"Mohandseen Managers\",0,IF(E36=\"Mohandssen\",G36*Data!$E$28,IF(E36=\"Maadi Managers\",0,IF(E36=\"Maadi\",G36*Data!$E$29,IF(E36=\"City Stars Managers\",0,IF(E36=\"City Stars\",G36*Data!$E$30,IF(E36=\"MOA Managers\",0,IF(E36=\"MOA\",G36*Data!$E$31,IF(E36=\"Concord Managers\",0,IF(E36=\"Concord\",G36*Data!$E$32))))))))))","v":909.79687004170296},1037.4667977599452,null,null,null,null,null,null,null,18000,null,"محمد صلاح عبد الله محمد سليمان",1947.26,22382,"NBEGEGCXXXX"]
[5,null,22389,"Maadi","Maadi","Baker",1544.24,3,0.04,"1904-04-06","2015-03-07",679.49147782818227,1405.4243399999996,0,1405.4243399999996,0,"Deserved","Deserved Maadi",14.965892355247982,15.413651257725178,55.909777022950813,71.323428280675984,2156.239246108858,215.62392461088581,0,0,0,1940.6153214979722,1.2566798693842747,3484.855321497972,{"$f":"IF(E37=\"Mohandseen Managers\",0,IF(E37=\"Mohandssen\",G37*Data!$E$28,IF(E37=\"Maadi Managers\",0,IF(E37=\"Maadi\",G37*Data!$E$29,IF(E37=\"City Stars Managers\",0,IF(E37=\"City Stars\",G37*Data!$E$30,IF(E37=\"MOA Managers\",0,IF(E37=\"MOA\",G37*Data!$E$31,IF(E37=\"Concord Managers\",0,IF(E37=\"Concord\",G37*Data!$E$32))))))))))","v":900.22718313219707},1040.3881383657751,null,null,null,null,null,null,null,18000,null,"ياسمين احمد عبد الرحمن على العابد",1940.62,22389,"NBEGEGCXXXX"]
[6,null,22753,"Maadi","Maadi","Cook",1236.22,3,0.04,"1902-08-04","2016-11-18",543.95751613787718,1405.4243399999996,0,1405.4243399999996,0,"Deserved","Deserved Maadi",11.980738387429843,12.339185591504572,55.909777022950813,68.24896261445538,2017.6308187523321,201.76308187523321,0,0,0,1815.8677368770989,1.4688872020167112,3052.0877368770989,{"$f":"IF(E38=\"Mohandseen Managers\",0,IF(E38=\"Mohandssen\",G38*Data!$E$28,IF(E38=\"Maadi Managers\",0,IF(E38=\"Maadi\",G38*Data!$E$29,IF(E38=\"City Stars Managers\",0,IF(E38=\"City Stars\",G38*Data!$E$30,IF(E38=\"MOA Managers\",0,IF(E38=\"MOA\",G38*Data!$E$31,IF(E38=\"Concord Managers\",0,IF(E38=\"Concord\",G38*Data!$E$32))))))))))","v":720.66443579474992},1095.2033010823488,null,null,null,null,null,null,null,"18000",null,"محمود احمد محفوظ عبد الغنى",1815.87,22753,"NBEGEGCXXXX"]
[7,null,22837,"Maadi","Maadi","Prep",1301.2,3,0.04,"1901-09-09","2017-10-17",572.54980504975322,1405.4243399999996,0,1405.4243399999996,0,"Deserved","Deserved Maadi",12.610487445376803,12.987775874573902,55.909777022950813,68.897552897524719,2046.8716979472774,204.68716979472777,0,0,0,1842.1845281525498,1.4157581679623037,3143.38452815255,{"$f":"IF(E39=\"Mohandseen Managers\",0,IF(E39=\"Mohandssen\",G39*Data!$E$28,IF(E39=\"Maadi Managers\",0,IF(E39=\"Maadi\",G39*Data!$E$29,IF(E39=\"City Stars Managers\",0,IF(E39=\"City Stars\",G39*Data!$E$30,IF(E39=\"MOA Managers\",0,IF(E39=\"MOA\",G39*Data!$E$31,IF(E39=\"Concord Managers\",0,IF(E39=\"Concord\",G39*Data!$E$32))))))))))","v":758.54505173523216},1083.6394764173176,null,null,null,null,null,null,null,18000,null,"هبه محمد حسين عبد العزيز",1842.18,22837,"NBEGEGCXXXX"]
[8,null,22838,"Maadi","Maadi","Prep",1289.1098360655737,3,0.04,"1901-09-06","2017-10-20",567.22993031591102,1405.4243399999996,0,1405.4243399999996,0,"Deserved","Deserved Maadi",12.493316479723845,12.86709931488501,55.909777022950813,68.77687633783583,2041.4311466537465,204.14311466537467,0,0,0,1837.2880319883718,1.4252377730635155,3126.3978680539458,{"$f":"IF(E40=\"Mohandseen Managers\",0,IF(E40=\"Mohandssen\",G40*Data!$E$28,IF(E40=\"Maadi Managers\",0,IF(E40=\"Maadi\",G40*Data!$E$29,IF(E40=\"City Stars Managers\",0,IF(E40=\"City Stars\",G40*Data!$E$30,IF(E40=\"MOA Managers\",0,IF(E40=\"MOA\",G40*Data!$E$31,IF(E40=\"Concord Managers\",0,IF(E40=\"Concord\",G40*Data!$E$32))))))))))","v":751.4969929993523},1085.7910389890194,null,null,null,null,null,null,null,18000,null,"دينا محمد مصطفى يوسف",1837.29,22838,"NBEGEGCXXXX"]
[9,null,22839,"Maadi","Maadi","Hostess",1179.8444262295081,3,0.04,"1901-08-28","2017-10-29",519.15131895691877,1405.4243399999996,0,1405.4243399999996,0,"Deserved","Deserved Maadi",11.434378515574092,11.776479384210031,55.909777022950813,67.68625640716084,1992.261915364079,199.2261915364079,0,0,0,1793.0357238276711,1.5197221633345093,2972.880150057179,{"$f":"IF(E41=\"Mohandseen Managers\",0,IF(E41=\"Mohandssen\",G41*Data!$E$28,IF(E41=\"Maadi Managers\",0,IF(E41=\"Maadi\",G41*Data!$E$29,IF(E41=\"City Stars Managers\",0,IF(E41=\"City Stars\",G41*Data!$E$30,IF(E41=\"MOA Managers\",0,IF(E41=\"MOA\",G41*Data!$E$31,IF(E41=\"Concord Managers\",0,IF(E41=\"Concord\",G41*Data!$E$32))))))))))","v":687.79983963555753},1105.2358841921136,null,null,null,null,null,null,null,18000,null,"مى عصام يوسف امين محمد",1793.04,22839,"NBEGEGCXXXX"]
[10,null,22857,"Maadi","Maadi","Food Server",1030.8196721311476,3,0.04,"1901-06-02","2018-01-26",453.57792984947667,1405.4243399999996,1,1359.3448534426225,46.079486557377095,"Undeserved","Undeserved Maadi",9.9901156884854512,0,0,0,1812.9227832920992,181.29227832920992,0,0,0,1631.6305049628893,1.5828476590765941,2662.4501770940369,{"$f":"IF(E42=\"Mohandseen Managers\",0,IF(E42=\"Mohandssen\",G42*Data!$E$28,IF(E42=\"Maadi Managers\",0,IF(E42=\"Maadi\",G42*Data!$E$29,IF(E42=\"City Stars Managers\",0,IF(E42=\"City Stars\",G42*Data!$E$30,IF(E42=\"MOA Managers\",0,IF(E42=\"MOA\",G42*Data!$E$31,IF(E42=\"Concord Managers\",0,IF(E42=\"Concord\",G42*Data!$E$32))))))))))","v":600.92465533846939},1030.7058496244199,null,null,null,null,null,null,null,"18000",null,"محمد حسن عباس حسن",1631.63,22857,"NBEGEGCXXXX"]
[11,null,22889,"Maadi","Maadi","Hostess",1056.45,3,0.04,"1900-11-28","2018-08-02",464.85570361574833,1405.4243399999996,0,1405.4243399999996,0,"Deserved","Deserved Maadi",10.238510191875442,10.544832326078696,55.909777022950813,66.454609349029511,1936.7346529647775,193.67346529647776,0,0,0,1743.0611876682997,1.6499230324845469,2799.5111876682995,{"$f":"IF(E43=\"Mohandseen Managers\",0,IF(E43=\"Mohandssen\",G43*Data!$E$28,IF(E43=\"Maadi Managers\",0,IF(E43=\"Maadi\",G43*Data!$E$29,IF(E43=\"City Stars Managers\",0,IF(E43=\"City Stars\",G43*Data!$E$30,IF(E43=\"MOA Managers\",0,IF(E43=\"MOA\",G43*Data!$E$31,IF(E43=\"Concord Managers\",0,IF(E43=\"Concord\",G43*Data!$E$32))))))))))","v":615.86606202404391},1127.1951256442558,null,null,null,null,null,null,null,"18000",null,"مريم حسين حنفى حسن عاشور",1743.06,22889,"NBEGEGCXXXX"]
[12,null,22906,"Maadi","Maadi","Dishwaser",924.39,1,0.04,"1900-10-13","2018-09-18",406.74709060093858,1405.4243399999996,0,1405.4243399999996,0,"Deserved","Deserved Maadi",8.9586600750321725,9.2266908551317002,55.909777022950813,65.136467878082513,1877.3078984790207,187.73078984790209,0,0,0,1689.5771086311186,1.8277751908081206,2613.9671086311187,{"$f":"IF(E44=\"Mohandseen Managers\",0,IF(E44=\"Mohandssen\",G44*Data!$E$28,IF(E44=\"Maadi Managers\",0,IF(E44=\"Maadi\",G44*Data!$E$29,IF(E44=\"City Stars Managers\",0,IF(E44=\"City Stars\",G44*Data!$E$30,IF(E44=\"MOA Managers\",0,IF(E44=\"MOA\",G44*Data!$E$31,IF(E44=\"Concord Managers\",0,IF(E44=\"Concord\",G44*Data!$E$32))))))))))","v":538.88061817824405},1150.6964904528745,null,null,null,null,null,null,null,null,null,"محمد ايمن محمد بسطاوى",1689.58]
[13,null,20490,"Maadi","Maadi","C.T - Cook",2922.5066666666667,4,0.08,"1913-08-23","2005-09-01",1285.9519076672332,1405.4243399999996,0,1405.4243399999996,0,"Deserved","Deserved Maadi",28.323265930702437,29.170659067487492,55.909777022950813,85.080436090438297,2776.4566837576713,277.64566837576712,0,0,0,2498.8110153819043,0.85502320452599057,5421.3176820485714,{"$f":"IF(E45=\"Mohandseen Managers\",0,IF(E45=\"Mohandssen\",G45*Data!$E$28,IF(E45=\"Maadi Managers\",0,IF(E45=\"Maadi\",G45*Data!$E$29,IF(E45=\"City Stars Managers\",0,IF(E45=\"City Stars\",G45*Data!$E$30,IF(E45=\"MOA Managers\",0,IF(E45=\"MOA\",G45*Data!$E$31,IF(E45=\"Concord Managers\",0,IF(E45=\"Concord\",G45*Data!$E$32))))))))))","v":1703.6988707832982},795.11214459860616,null,null,null,null,null,null,null,18000,null,"ابراهيم بدوى محمد محمود",2498.81,20490,"NBEGEGCXXXX"]
[14,null,22914,"Maadi","Maadi","Dishwaser",46.521147540983634,1,0.04,"1900-08-03","2018-11-29",20.470084502982619,1405.4243399999996,{"$f":"30-5","v":25},253.43717606557357,1151.987163934426,"Undeserved","Undeserved Maadi",0.45085639948516448,0,0,0,273.90726056855624,27.390726056855627,0,0,0,246.51653451170063,5.2990209300948026,293.03768205268426,{"$f":"IF(E46=\"Mohandseen Managers\",0,IF(E46=\"Mohandssen\",G46*Data!$E$28,IF(E46=\"Maadi Managers\",0,IF(E46=\"Maadi\",G46*Data!$E$29,IF(E46=\"City Stars Managers\",0,IF(E46=\"City Stars\",G46*Data!$E$30,IF(E46=\"MOA Managers\",0,IF(E46=\"MOA\",G46*Data!$E$31,IF(E46=\"Concord Managers\",0,IF(E46=\"Concord\",G46*Data!$E$32))))))))))","v":27.119878779786195},219.39665573191442,null,null,null,null,null,null,null,null,null,"اسلام تامر حسين عبد العظيم",246.52]
[1,null,20075,"City Stars","City Stars Managers","S R .Assistant Manager",6577.2,9,0.1,"1917-07-03","2001-10-01",1685.6992214857955,3474.6818399999993,0,3474.6818399999993,0,"Deserved","Deserved City Stars",161.47216396839704,171.16576075038108,155.5235140506706,326.68927480105168,5487.0703362868462,548.7070336286846,0,0,0,4938.363302658162,0.75083064262272126,11515.563302658162,{"$f":"IF(E47=\"Mohandseen Managers\",0,IF(E47=\"Mohandssen\",G47*Data!$E$28,IF(E47=\"Maadi Managers\",0,IF(E47=\"Maadi\",G47*Data!$E$29,IF(E47=\"City Stars Managers\",0,IF(E47=\"City Stars\",G47*Data!$E$30,IF(E47=\"MOA Managers\",0,IF(E47=\"MOA\",G47*Data!$E$31,IF(E47=\"Concord Managers\",0,IF(E47=\"Concord\",G47*Data!$E$32))))))))))","v":0},4938.363302658162,null,null,null,null,null,null,null,18000,null,"عمر أحمد اسماعيل حسن",4938.3599999999997,20075,"NBEGEGCXXXX"]
[2,null,20060,"City Stars","City Stars Managers","S R .Assistant Manager",6577.2,9,0.1,"1917-10-18","2001-06-14",{"$f":"IF(E48=\"Mohandseen Managers\",$X$7*G48,IF(E48=\"Mohandssen\",$W$7*G48,IF(E48=\"Maadi Managers\",$X$8*G48,IF(E48=\"Maadi\",$W$8*G48,IF(E48=\"City Stars Managers\",$X$9*G48,IF(E48=\"City Stars\",$W$9*G48,IF(E48=\"MOA Managers\",$X$10*G48,IF(E48=\"MOA\",$W$10*G48,IF(E48=\"Concord Managers\",$X$11*G48,IF(E48=\"Concord\",$W$11*G48))))))))))","v":1685.6992214857955},{"$f":"IF(E48=\"Mohandseen Managers\",$T$7,IF(E48=\"Mohandssen\",$S$7,IF(E48=\"Maadi Managers\",$T$8,IF(E48=\"Maadi\",$S$8,IF(E48=\"City Stars Managers\",$T$9,IF(E48=\"City Stars\",$S$9,IF(E48=\"MOA Managers\",$T$10,IF(E48=\"MOA\",$S$10,IF(E48=\"Concord Managers\",$T$11,IF(E48=\"Concord\",$S$11))))))))))","v":3474.6818399999993},0,{"$f":"(M48-(M48/30.5)*N48)","v":3474.6818399999993},0,"Deserved","Deserved City Stars",161.47216396839704,171.16576075038108,155.5235140506706,326.68927480105168,5487.0703362868462,548.7070336286846,0,0,0,4938.363302658162,{"$f":"IFERROR(AB48/G48,0)","v":0.75083064262272126},{"$f":"G48+AB48","v":11515.563302658162},{"$f":"IF(E48=\"Mohandseen Managers\",0,IF(E48=\"Mohandssen\",G48*Data!$E$28,IF(E48=\"Maadi Managers\",0,IF(E48=\"Maadi\",G48*Data!$E$29,IF(E48=\"City Stars Managers\",0,IF(E48=\"City Stars\",G48*Data!$E$30,IF(E48=\"MOA Managers\",0,IF(E48=\"MOA\",G48*Data!$E$31,IF(E48=\"Concord Managers\",0,IF(E48=\"Concord\",G48*Data!$E$32))))))))))","v":0},4938.363302658162,null,null,null,null,null,null,null,18000,null,"فارس زينهم السيد خليل",4938.3599999999997,20060,"NBEGEGCXXXX"]
[3,null,21716,"City Stars","City Stars Managers","S R .Assistant Manager",4276.5266666666676,9,0.1,"1907-02-03","2012-04-24",1096.0496370284081,3474.6818399999993,0,3474.6818399999993,0,"Deserved","Deserved City Stars",104.98996763595795,111.2927902860323,155.5235140506706,266.8163043367029,4837.5477813651105,483.75477813651105,0,0,0,4353.7930032285994,1.018067544665203,8630.319669895267,{"$f":"IF(E49=\"Mohandseen Managers\",0,IF(E49=\"Mohandssen\",G49*Data!$E$28,IF(E49=\"Maadi Managers\",0,IF(E49=\"Maadi\",G49*Data!$E$29,IF(E49=\"City Stars Managers\",0,IF(E49=\"City Stars\",G49*Data!$E$30,IF(E49=\"MOA Managers\",0,IF(E49=\"MOA\",G49*Data!$E$31,IF(E49=\"Concord Managers\",0,IF(E49=\"Concord\",G49*Data!$E$32))))))))))","v":0},4353.7930032285994,null,null,null,null,null,null,null,18000,null,"وائل محمد السيد ابراهيم دسوقى",4353.79,21716,"NBEGEGCXXXX"]
[1,null,21162,"City Stars","City Stars","Store Keeper",2069.44,3,0.04,"1910-10-08","2008-08-01",1323.5180647173377,2684.9814218181814,0,2684.9814218181814,0,"Deserved","Deserved City Stars",50.805351061661433,53.855329308409154,155.5235140506706,209.37884335907975,4217.8783298945991,421.78783298945996,0,0,0,3796.0904969051389,1.8343563944376928,5865.5304969051394,{"$f":"IF(E50=\"Mohandseen Managers\",0,IF(E50=\"Mohandssen\",G50*Data!$E$28,IF(E50=\"Maadi Managers\",0,IF(E50=\"Maadi\",G50*Data!$E$29,IF(E50=\"City Stars Managers\",0,IF(E50=\"City Stars\",G50*Data!$E$30,IF(E50=\"MOA Managers\",0,IF(E50=\"MOA\",G50*Data!$E$31,IF(E50=\"Concord Managers\",0,IF(E50=\"Concord\",G50*Data!$E$32))))))))))","v":1753.4685542095094},2042.6219426956295,null,null,null,null,null,null,null,18000,null,"صابر سيد عجمى مصطفى",3796.09,21162,"NBEGEGCXXXX"]
[2,null,21554,"City Stars","City Stars","C.T - Cook",2712.8466666666673,4,0.08,"1908-01-24","2011-04-29",1735.0111963340555,2684.9814218181814,0,2684.9814218181814,0,"Deserved","Deserved City Stars",66.601170981742911,70.599413656135681,155.5235140506706,226.12292770680628,4646.1155458590429,464.61155458590429,0,0,0,4181.503991273139,1.5413712992526196,6894.3506579398063,{"$f":"IF(E51=\"Mohandseen Managers\",0,IF(E51=\"Mohandssen\",G51*Data!$E$28,IF(E51=\"Maadi Managers\",0,IF(E51=\"Maadi\",G51*Data!$E$29,IF(E51=\"City Stars Managers\",0,IF(E51=\"City Stars\",G51*Data!$E$30,IF(E51=\"MOA Managers\",0,IF(E51=\"MOA\",G51*Data!$E$31,IF(E51=\"Concord Managers\",0,IF(E51=\"Concord\",G51*Data!$E$32))))))))))","v":2298.6369850742653},1882.8670061988737,null,null,null,null,null,null,null,18000,null,"سيد محمد علام محمد",4181.5,21554,"NBEGEGCXXXX"]
[3,null,30168,"City Stars","City Stars","C.T - Food Server",2387.4,4,0.08,"1910-04-22","2009-01-20",1526.8705677411144,2684.9814218181814,0,2684.9814218181814,0,"Deserved","Deserved City Stars",58.61136110474839,62.129954572684404,155.5235140506706,217.653468623355,4429.5054581826516,442.9505458182652,0,0,0,3986.5549123643864,1.6698311604106502,6373.9549123643865,{"$f":"IF(E52=\"Mohandseen Managers\",0,IF(E52=\"Mohandssen\",G52*Data!$E$28,IF(E52=\"Maadi Managers\",0,IF(E52=\"Maadi\",G52*Data!$E$29,IF(E52=\"City Stars Managers\",0,IF(E52=\"City Stars\",G52*Data!$E$30,IF(E52=\"MOA Managers\",0,IF(E52=\"MOA\",G52*Data!$E$31,IF(E52=\"Concord Managers\",0,IF(E52=\"Concord\",G52*Data!$E$32))))))))))","v":2022.8809853485886},1963.6739270157977,null,null,null,null,null,null,null,18000,null,"عبد العظيم السيد عبد العظيم جربيده",3986.55,30168,"NBEGEGCXXXX"]
[4,null,30277,"City Stars","City Stars","C.T - Cook",2309.62,4,0.08,"1908-01-14","2011-05-09",1477.1260788582695,2684.9814218181814,0,2684.9814218181814,0,"Deserved","Deserved City Stars",56.701839588987589,60.105799480674932,155.5235140506706,215.62931353134553,4377.7368142077967,437.77368142077967,0,0,0,3939.963132787017,1.705892368782318,6249.5831327870164,{"$f":"IF(E53=\"Mohandseen Managers\",0,IF(E53=\"Mohandssen\",G53*Data!$E$28,IF(E53=\"Maadi Managers\",0,IF(E53=\"Maadi\",G53*Data!$E$29,IF(E53=\"City Stars Managers\",0,IF(E53=\"City Stars\",G53*Data!$E$30,IF(E53=\"MOA Managers\",0,IF(E53=\"MOA\",G53*Data!$E$31,IF(E53=\"Concord Managers\",0,IF(E53=\"Concord\",G53*Data!$E$32))))))))))","v":1956.9767870406329},1982.9863457463841,null,null,null,null,null,null,null,18000,null,"ابراهيم قرنى بكرى محمد",3939.96,30277,"NBEGEGCXXXX"]
[5,null,22022,"City Stars","City Stars","Food Server",1634.9899999999998,3,0.04,"1905-07-23","2013-11-14",1045.6639480401459,2684.9814218181814,0,2684.9814218181814,0,"Deserved","Deserved City Stars",40.139477797039689,42.549155745494367,155.5235140506706,198.07266979616497,3928.7180396544923,392.87180396544926,0,0,0,3535.8462356890432,2.1626103130227361,5170.836235689043,{"$f":"IF(E54=\"Mohandseen Managers\",0,IF(E54=\"Mohandssen\",G54*Data!$E$28,IF(E54=\"Maadi Managers\",0,IF(E54=\"Maadi\",G54*Data!$E$29,IF(E54=\"City Stars Managers\",0,IF(E54=\"City Stars\",G54*Data!$E$30,IF(E54=\"MOA Managers\",0,IF(E54=\"MOA\",G54*Data!$E$31,IF(E54=\"Concord Managers\",0,IF(E54=\"Concord\",G54*Data!$E$32))))))))))","v":1385.3523423955301},2150.4938932935129,null,null,null,null,null,null,null,18000,null,"محمود ابراهيم محمد سليمان نويره",3535.85,22022,"NBEGEGCXXXX"]
[6,null,22066,"City Stars","City Stars","Hostess",1611.29,3,0.04,"1905-05-07","2014-02-01",1030.5065247112257,2684.9814218181814,0,2684.9814218181814,0,"Deserved","Deserved City Stars",39.557635936361748,41.932384394496374,155.5235140506706,197.45589844516698,3912.9438449745739,391.29438449745743,0,0,0,3521.6494604771165,2.1856087113288836,5132.9394604771169,{"$f":"IF(E55=\"Mohandseen Managers\",0,IF(E55=\"Mohandssen\",G55*Data!$E$28,IF(E55=\"Maadi Managers\",0,IF(E55=\"Maadi\",G55*Data!$E$29,IF(E55=\"City Stars Managers\",0,IF(E55=\"City Stars\",G55*Data!$E$30,IF(E55=\"MOA Managers\",0,IF(E55=\"MOA\",G55*Data!$E$31,IF(E55=\"Concord Managers\",0,IF(E55=\"Concord\",G55*Data!$E$32))))))))))","v":1365.2709654361761},2156.3784950409404,null,null,null,null,null,null,null,18000,null,"ايمان عبد المحسن حسن حسن ",3521.65,22066,"NBEGEGCXXXX"]
[7,null,22201,"City Stars","City Stars","C.T - Baker",1698.5518032786886,4,0.08,"1904-06-11","2015-01-01",1086.3151362192448,2684.9814218181814,1,2596.949244053651,88.032177764530388,"Undeserved","Undeserved City Stars",41.699938467407542,0,0,0,3683.2643802728958,368.32643802728961,0,0,0,3314.9379422456063,1.9516260474639822,5013.4897455242954,{"$f":"IF(E56=\"Mohandseen Managers\",0,IF(E56=\"Mohandssen\",G56*Data!$E$28,IF(E56=\"Maadi Managers\",0,IF(E56=\"Maadi\",G56*Data!$E$29,IF(E56=\"City Stars Managers\",0,IF(E56=\"City Stars\",G56*Data!$E$30,IF(E56=\"MOA Managers\",0,IF(E56=\"MOA\",G56*Data!$E$31,IF(E56=\"Concord Managers\",0,IF(E56=\"Concord\",G56*Data!$E$32))))))))))","v":1439.2092424738273},1875.728699771779,null,null,null,null,null,null,null,18000,null,"علا عاشور محمد عبد الهادى اسماعيل",3314.94,22201,"NBEGEGCXXXX"]
[8,null,22448,"City Stars","City Stars","Cook",1544.24,3,0.04,"1903-12-31","2015-06-14",987.6244473186473,2684.9814218181814,0,2684.9814218181814,0,"Deserved","Deserved City Stars",37.911539026722231,40.187467977432419,155.5235140506706,195.71098202810302,3868.3168511649319,386.83168511649319,0,0,0,3481.4851660484387,2.2544974654512502,5025.725166048439,{"$f":"IF(E57=\"Mohandseen Managers\",0,IF(E57=\"Mohandssen\",G57*Data!$E$28,IF(E57=\"Maadi Managers\",0,IF(E57=\"Maadi\",G57*Data!$E$29,IF(E57=\"City Stars Managers\",0,IF(E57=\"City Stars\",G57*Data!$E$30,IF(E57=\"MOA Managers\",0,IF(E57=\"MOA\",G57*Data!$E$31,IF(E57=\"Concord Managers\",0,IF(E57=\"Concord\",G57*Data!$E$32))))))))))","v":1308.4584622663585},2173.0267037820804,null,null,null,null,null,null,null,18000,null,"حسن سعيد ابو ضيف على",3481.49,22448,"NBEGEGCXXXX"]
[9,null,40004,"City Stars","City Stars","C.T - Cook",2918.0566666666668,4,0.08,"1912-03-22","2007-02-10",1866.2540166432425,2684.9814218181814,0,2684.9814218181814,0,"Deserved","Deserved City Stars",71.63913588595058,75.939820784333946,155.5235140506706,231.46333483500456,4782.698773296428,478.26987732964284,0,0,0,4304.4288959667856,1.4751012018158609,7222.485562633452,{"$f":"IF(E58=\"Mohandseen Managers\",0,IF(E58=\"Mohandssen\",G58*Data!$E$28,IF(E58=\"Maadi Managers\",0,IF(E58=\"Maadi\",G58*Data!$E$29,IF(E58=\"City Stars Managers\",0,IF(E58=\"City Stars\",G58*Data!$E$30,IF(E58=\"MOA Managers\",0,IF(E58=\"MOA\",G58*Data!$E$31,IF(E58=\"Concord Managers\",0,IF(E58=\"Concord\",G58*Data!$E$32))))))))))","v":2472.5145954467976},1831.914300519988,null,null,null,null,null,null,null,18000,null,"مصطفى محمود محمود احمد شريف",4304.43,40004,"NBEGEGCXXXX"]
[10,null,20127,"City Stars","City Stars","C.T - Prep",3292.6566666666668,4,0.08,"1917-05-04","2001-12-01",2105.8308427619581,2684.9814218181814,0,2684.9814218181814,0,"Deserved","Deserved City Stars",80.835674325189402,85.6884515051715,155.5235140506706,241.21196555584208,5032.0242301359813,503.20242301359815,0,0,0,4528.8218071223828,1.3754309257233164,7821.4784737890495,{"$f":"IF(E59=\"Mohandseen Managers\",0,IF(E59=\"Mohandssen\",G59*Data!$E$28,IF(E59=\"Maadi Managers\",0,IF(E59=\"Maadi\",G59*Data!$E$29,IF(E59=\"City Stars Managers\",0,IF(E59=\"City Stars\",G59*Data!$E$30,IF(E59=\"MOA Managers\",0,IF(E59=\"MOA\",G59*Data!$E$31,IF(E59=\"Concord Managers\",0,IF(E59=\"Concord\",G59*Data!$E$32))))))))))","v":2789.9189755722819},1738.9028315501009,null,null,null,null,null,null,null,18000,null,"مختار صابر أحمد هشهش",4528.82,20127,"NBEGEGCXXXX"]
[11,null,20646,"City Stars","City Stars","C.T - Prep",2986.2266666666669,4,0.08,"1913-01-11","2006-04-15",1909.8523942100148,2684.9814218181814,0,2684.9814218181814,0,"Deserved","Deserved City Stars",73.312729119807784,77.713884201951402,155.5235140506706,233.237398252622,4828.0712142808188,482.80712142808193,0,0,0,4345.2640928527371,1.4551018987795312,7331.4907595194036,{"$f":"IF(E60=\"Mohandseen Managers\",0,IF(E60=\"Mohandssen\",G60*Data!$E$28,IF(E60=\"Maadi Managers\",0,IF(E60=\"Maadi\",G60*Data!$E$29,IF(E60=\"City Stars Managers\",0,IF(E60=\"City Stars\",G60*Data!$E$30,IF(E60=\"MOA Managers\",0,IF(E60=\"MOA\",G60*Data!$E$31,IF(E60=\"Concord Managers\",0,IF(E60=\"Concord\",G60*Data!$E$32))))))))))","v":2530.2760919581547},1814.9880008945825,null,null,null,null,null,null,null,18000,null,"ابراهيم فاروق ابراهيم أحمد",4345.26,20646,"NBEGEGCXXXX"]
[12,null,22770,"City Stars","City Stars","Food Server",1190.9100000000001,3,0.04,"1902-04-15","2017-03-09",761.65092897234251,2684.9814218181814,0,2684.9814218181814,0,"Deserved","Deserved City Stars",29.237185244724767,30.992370026034845,155.5235140506706,186.51588407670545,3633.1482348672293,363.31482348672296,0,0,0,3269.8334113805063,2.745659547220618,4460.7434113805066,{"$f":"IF(E61=\"Mohandseen Managers\",0,IF(E61=\"Mohandssen\",G61*Data!$E$28,IF(E61=\"Maadi Managers\",0,IF(E61=\"Maadi\",G61*Data!$E$29,IF(E61=\"City Stars Managers\",0,IF(E61=\"City Stars\",G61*Data!$E$30,IF(E61=\"MOA Managers\",0,IF(E61=\"MOA\",G61*Data!$E$31,IF(E61=\"Concord Managers\",0,IF(E61=\"Concord\",G61*Data!$E$32))))))))))","v":1009.0764824752818},2260.7569289052244,null,null,null,null,null,null,null,18000,null,"احمد محمد مرسى محمد",3269.83,22770,"NBEGEGCXXXX"]
[13,null,21260,"City Stars","City Stars","C.T - Food Server",2466.6633333333334,4,0.08,"1910-04-22","2009-01-20",1577.5637279856146,2684.9814218181814,0,2684.9814218181814,0,"Deserved","Deserved City Stars",60.557298883237983,64.192712091022145,155.5235140506706,219.71622614169274,4482.2613759454889,448.2261375945489,0,0,0,4034.0352383509398,1.6354219012529503,6500.6985716842737,{"$f":"IF(E62=\"Mohandseen Managers\",0,IF(E62=\"Mohandssen\",G62*Data!$E$28,IF(E62=\"Maadi Managers\",0,IF(E62=\"Maadi\",G62*Data!$E$29,IF(E62=\"City Stars Managers\",0,IF(E62=\"City Stars\",G62*Data!$E$30,IF(E62=\"MOA Managers\",0,IF(E62=\"MOA\",G62*Data!$E$31,IF(E62=\"Concord Managers\",0,IF(E62=\"Concord\",G62*Data!$E$32))))))))))","v":2090.0420349570945},1943.9932033938453,null,null,null,null,null,null,null,18000,null,"محمد فتحى عطية أحمد",4034.04,21260,"NBEGEGCXXXX"]
[14,null,22831,"City Stars","City Stars","Hostess",1146.6477049180328,3,0.04,"1901-09-14","2017-10-12",733.34281318892624,2684.9814218181814,0,2684.9814218181814,0,"Deserved","Deserved City Stars",28.150533087409649,29.840483294559021,155.5235140506706,185.36399734522962,3603.6882323523373,360.36882323523378,0,0,0,3243.3194091171035,2.8285230024935597,4389.9671140351365,{"$f":"IF(E63=\"Mohandseen Managers\",0,IF(E63=\"Mohandssen\",G63*Data!$E$28,IF(E63=\"Maadi Managers\",0,IF(E63=\"Maadi\",G63*Data!$E$29,IF(E63=\"City Stars Managers\",0,IF(E63=\"City Stars\",G63*Data!$E$30,IF(E63=\"MOA Managers\",0,IF(E63=\"MOA\",G63*Data!$E$31,IF(E63=\"Concord Managers\",0,IF(E63=\"Concord\",G63*Data!$E$32))))))))))","v":971.57235451633062},2271.747054600773,null,null,null,null,null,null,null,18000,null,"ايمان صلاح الدين ابو العلا ابراهيم",3243.32,22831,"NBEGEGCXXXX"]
[15,null,22844,"City Stars","City Stars","Food Server",1190.9100000000001,3,0.04,"1901-08-12","2017-11-15",761.65092897234251,2684.9814218181814,0,2684.9814218181814,0,"Deserved","Deserved City Stars",29.237185244724767,30.992370026034845,155.5235140506706,186.51588407670545,3633.1482348672293,363.31482348672296,0,0,0,3269.8334113805063,2.745659547220618,4460.7434113805066,{"$f":"IF(E64=\"Mohandseen Managers\",0,IF(E64=\"Mohandssen\",G64*Data!$E$28,IF(E64=\"Maadi Managers\",0,IF(E64=\"Maadi\",G64*Data!$E$29,IF(E64=\"City Stars Managers\",0,IF(E64=\"City Stars\",G64*Data!$E$30,IF(E64=\"MOA Managers\",0,IF(E64=\"MOA\",G64*Data!$E$31,IF(E64=\"Concord Managers\",0,IF(E64=\"Concord\",G64*Data!$E$32))))))))))","v":1009.0764824752818},2260.7569289052244,null,null,null,null,null,null,null,18000,null,"خلود سعد محمد السيد منصور",3269.83,22844,"NBEGEGCXXXX"]
[16,null,20095,"City Stars","City Stars","Cook",2909.1866666666665,3,0.04,"1917-07-03","2001-10-01",1860.581175085119,2684.9814218181814,0,2684.9814218181814,0,"Deserved","Deserved City Stars",71.421374818262237,75.708986949593339,155.5235140506706,231.23250100026394,4776.795097903565,477.67950979035652,0,0,0,4299.1155881132081,1.4777723400743878,7208.3022547798746,{"$f":"IF(E65=\"Mohandseen Managers\",0,IF(E65=\"Mohandssen\",G65*Data!$E$28,IF(E65=\"Maadi Managers\",0,IF(E65=\"Maadi\",G65*Data!$E$29,IF(E65=\"City Stars Managers\",0,IF(E65=\"City Stars\",G65*Data!$E$30,IF(E65=\"MOA Managers\",0,IF(E65=\"MOA\",G65*Data!$E$31,IF(E65=\"Concord Managers\",0,IF(E65=\"Concord\",G65*Data!$E$32))))))))))","v":2464.9989071080013},1834.1166810052068,null,null,null,null,null,null,null,18000,null,"محمد طه حبيب طه",4299.12,20095,"NBEGEGCXXXX"]
[17,null,22767,"City Stars","City Stars","Host",58.61,3,0.04,"1902-05-17","2017-02-07",37.484243937047296,2684.9814218181814,{"$f":"30-2","v":28},220.08044441132643,2464.900977406855,"Undeserved","Undeserved City Stars",1.4388924664276213,0,0,0,257.56468834837369,25.756468834837371,0,0,0,231.80821951353633,3.9550967328704374,290.41821951353631,{"$f":"IF(E66=\"Mohandseen Managers\",0,IF(E66=\"Mohandssen\",G66*Data!$E$28,IF(E66=\"Maadi Managers\",0,IF(E66=\"Maadi\",G66*Data!$E$29,IF(E66=\"City Stars Managers\",0,IF(E66=\"City Stars\",G66*Data!$E$30,IF(E66=\"MOA Managers\",0,IF(E66=\"MOA\",G66*Data!$E$31,IF(E66=\"Concord Managers\",0,IF(E66=\"Concord\",G66*Data!$E$32))))))))))","v":49.661160488933888},182.14705902460244,null,null,null,null,null,null,null,"18000",null,"ابراهيم مجدى ابراهيم موسى",231.81,22767,"NBEGEGCXXXX"]
[18,null,22163,"City Stars","City Stars","Food Server",412.46,3,0.04,"1900-10-23","2018-09-08",263.79033022137054,2684.9814218181814,{"$f":"30-8","v":22},748.27351099850966,1936.7079108196717,"Undeserved","Undeserved City Stars",10.12601239895473,0,0,0,1012.06384121988,101.20638412198801,0,0,0,910.85745709789205,2.2083534332975128,1323.317457097892,{"$f":"IF(E67=\"Mohandseen Managers\",0,IF(E67=\"Mohandssen\",G67*Data!$E$28,IF(E67=\"Maadi Managers\",0,IF(E67=\"Maadi\",G67*Data!$E$29,IF(E67=\"City Stars Managers\",0,IF(E67=\"City Stars\",G67*Data!$E$30,IF(E67=\"MOA Managers\",0,IF(E67=\"MOA\",G67*Data!$E$31,IF(E67=\"Concord Managers\",0,IF(E67=\"Concord\",G67*Data!$E$32))))))))))","v":349.48374433143954},561.37371276645251,null,null,null,null,null,null,null,null,null,"اسلام عماد الدين محمد شاهين",910.86]
[19,null,22443,"City Stars","City Stars","Food Server",1359.3609836065573,3,0.04,"1903-06-17","2016-01-01",869.38438334776902,2684.9814218181814,0,2684.9814218181814,0,"Deserved","Deserved City Stars",33.372705655470341,35.376156554978216,155.5235140506706,190.89967060564882,3745.2654757715991,374.52654757715993,0,0,0,3370.7389281944393,2.4796496065757609,4730.0999118009968,{"$f":"IF(E68=\"Mohandseen Managers\",0,IF(E68=\"Mohandssen\",G68*Data!$E$28,IF(E68=\"Maadi Managers\",0,IF(E68=\"Maadi\",G68*Data!$E$29,IF(E68=\"City Stars Managers\",0,IF(E68=\"City Stars\",G68*Data!$E$30,IF(E68=\"MOA Managers\",0,IF(E68=\"MOA\",G68*Data!$E$31,IF(E68=\"Concord Managers\",0,IF(E68=\"Concord\",G68*Data!$E$32))))))))))","v":1151.8076090987931},2218.9313190956464,null,null,null,null,null,null,null,18000,null,"محمد حسام الدين عبد الرسول المتولى",3370.74,22443,"NBEGEGCXXXX"]
[20,null,22909,"City Stars","City Stars","Cook",1059.2440983606557,3,0.04,"1900-09-12","2018-10-19",677.44351086552695,2684.9814218181814,2,2508.9170662891202,176.06435552906123,"Undeserved","Undeserved City Stars",26.004749244822825,0,0,0,3186.3605771546472,318.63605771546474,0,0,0,2867.7245194391826,2.7073311278084349,3926.9686177998383,{"$f":"IF(E69=\"Mohandseen Managers\",0,IF(E69=\"Mohandssen\",G69*Data!$E$28,IF(E69=\"Maadi Managers\",0,IF(E69=\"Maadi\",G69*Data!$E$29,IF(E69=\"City Stars Managers\",0,IF(E69=\"City Stars\",G69*Data!$E$30,IF(E69=\"MOA Managers\",0,IF(E69=\"MOA\",G69*Data!$E$31,IF(E69=\"Concord Managers\",0,IF(E69=\"Concord\",G69*Data!$E$32))))))))))","v":897.51392536503329},1970.2105940741494,null,null,null,null,null,null,null,null,null,"محمود محمد احمد عبد الله ابو سريع",2867.72]
[21,null,22155,"City Stars","City Stars","Cook",1543.82,3,0.04,"1901-08-26","2017-11-01",987.35583475332453,2684.9814218181814,0,2684.9814218181814,0,"Deserved","Deserved City Stars",37.901227905140594,40.176537852224861,155.5235140506706,195.70005190289547,3868.0373084744015,386.80373084744019,0,0,0,3481.2335776269611,2.2549478421234088,5025.0535776269608,{"$f":"IF(E70=\"Mohandseen Managers\",0,IF(E70=\"Mohandssen\",G70*Data!$E$28,IF(E70=\"Maadi Managers\",0,IF(E70=\"Maadi\",G70*Data!$E$29,IF(E70=\"City Stars Managers\",0,IF(E70=\"City Stars\",G70*Data!$E$30,IF(E70=\"MOA Managers\",0,IF(E70=\"MOA\",G70*Data!$E$31,IF(E70=\"Concord Managers\",0,IF(E70=\"Concord\",G70*Data!$E$32))))))))))","v":1308.1025897632812},2173.1309878636798,null,null,null,null,null,null,null,18000,null,"محمد كمال حسنى امين اسماعيل",3481.23,22155,"NBEGEGCXXXX"]
[22,null,22862,"City Stars","City Stars","Food Server",1080,3,0.04,"1901-04-19","2018-03-10",690.71802511535714,2684.9814218181814,0,2684.9814218181814,0,"Deserved","Deserved City Stars",26.514312638488843,28.106036248010032,155.5235140506706,183.62955029868064,3559.3289972322191,355.93289972322191,0,0,0,3203.3960975089972,2.9661074976935158,4283.3960975089976,{"$f":"IF(E71=\"Mohandseen Managers\",0,IF(E71=\"Mohandssen\",G71*Data!$E$28,IF(E71=\"Maadi Managers\",0,IF(E71=\"Maadi\",G71*Data!$E$29,IF(E71=\"City Stars Managers\",0,IF(E71=\"City Stars\",G71*Data!$E$30,IF(E71=\"MOA Managers\",0,IF(E71=\"MOA\",G71*Data!$E$31,IF(E71=\"Concord Managers\",0,IF(E71=\"Concord\",G71*Data!$E$32))))))))))","v":915.1007221984064},2288.2953753105908,null,null,null,null,null,null,null,"18000",null,"زينب احمد سيد عباس",3203.4,22862,"NBEGEGCXXXX"]
[1,null,40001,"MOA","MOA Managers","S R .Assistant Manager",6577.2,9,0.1,"1912-03-27","2007-02-05",701.60332687444429,1670.2585200000001,null,1670.2585200000001,0,"Deserved","Deserved MOA",58.456286860163047,58.815546854604477,61.094497094262294,119.91004394886677,2491.771890823311,249.1771890823311,0,0,0,2242.5947017409799,0.34096495495666546,8819.7947017409788,{"$f":"IF(E72=\"Mohandseen Managers\",0,IF(E72=\"Mohandssen\",G72*Data!$E$28,IF(E72=\"Maadi Managers\",0,IF(E72=\"Maadi\",G72*Data!$E$29,IF(E72=\"City Stars Managers\",0,IF(E72=\"City Stars\",G72*Data!$E$30,IF(E72=\"MOA Managers\",0,IF(E72=\"MOA\",G72*Data!$E$31,IF(E72=\"Concord Managers\",0,IF(E72=\"Concord\",G72*Data!$E$32))))))))))","v":0},2242.5947017409799,null,null,null,null,null,null,null,18000,null,"على عبد العال على عبد العال",2242.59,40001,"NBEGEGCXXXX"]
[2,null,20010,"MOA","MOA Managers","Resturant Manager",9426.2833333333328,10,0.12,"1918-09-26","2000-07-01",1005.5208518408735,1670.2585200000001,null,1670.2585200000001,0,"Deserved","Deserved MOA",83.778130900460269,84.293013600991898,61.094497094262294,145.38751069525421,2821.166882536128,282.11668825361284,0,0,0,2539.0501942825153,0.26935856949089326,11965.333527615849,{"$f":"IF(E73=\"Mohandseen Managers\",0,IF(E73=\"Mohandssen\",G73*Data!$E$28,IF(E73=\"Maadi Managers\",0,IF(E73=\"Maadi\",G73*Data!$E$29,IF(E73=\"City Stars Managers\",0,IF(E73=\"City Stars\",G73*Data!$E$30,IF(E73=\"MOA Managers\",0,IF(E73=\"MOA\",G73*Data!$E$31,IF(E73=\"Concord Managers\",0,IF(E73=\"Concord\",G73*Data!$E$32))))))))))","v":0},2539.0501942825153,null,null,null,null,null,null,null,18000,null,"محمد عبد الرازق غريب شعلان",2539.0500000000002,20010,"NBEGEGCXXXX"]
[3,null,22506,"MOA","MOA Managers","S R .Assistant Manager",4128.083333333333,9,0.1,"1903-05-22","2016-01-27",440.35106128468226,1670.2585200000001,null,1670.2585200000001,0,"Deserved","Deserved MOA",36.689233034724715,36.914717313047873,61.094497094262294,98.009214407310168,2208.6187956919925,220.86187956919926,0,0,0,1987.7569161227932,0.48152054007052347,6115.840249456126,{"$f":"IF(E74=\"Mohandseen Managers\",0,IF(E74=\"Mohandssen\",G74*Data!$E$28,IF(E74=\"Maadi Managers\",0,IF(E74=\"Maadi\",G74*Data!$E$29,IF(E74=\"City Stars Managers\",0,IF(E74=\"City Stars\",G74*Data!$E$30,IF(E74=\"MOA Managers\",0,IF(E74=\"MOA\",G74*Data!$E$31,IF(E74=\"Concord Managers\",0,IF(E74=\"Concord\",G74*Data!$E$32))))))))))","v":0},1987.7569161227932,null,null,null,null,null,null,null,18000,null,"محمد حنفى محمد محمد حسن",1987.76,22506,"NBEGEGCXXXX"]
[4,null,20012,"MOA","MOA","C.T - Cook",3508.4631693989072,4,0.08,"1918-09-26","2000-07-01",1581.005989870778,2028.1710600000001,null,2028.1710600000001,0,"Deserved","Deserved MOA",31.182224878169944,31.373864247314291,61.094497094262294,92.468361341576582,3701.6454112123547,370.16454112123552,0,0,0,3331.480870091119,0.9495556057559783,6839.9440394900266,{"$f":"IF(E75=\"Mohandseen Managers\",0,IF(E75=\"Mohandssen\",G75*Data!$E$28,IF(E75=\"Maadi Managers\",0,IF(E75=\"Maadi\",G75*Data!$E$29,IF(E75=\"City Stars Managers\",0,IF(E75=\"City Stars\",G75*Data!$E$30,IF(E75=\"MOA Managers\",0,IF(E75=\"MOA\",G75*Data!$E$31,IF(E75=\"Concord Managers\",0,IF(E75=\"Concord\",G75*Data!$E$32))))))))))","v":2094.6025303004481},1236.8783397906709,null,null,null,null,null,null,null,18000,null,"عادل عبد القادر ابو اليزيد عطية",3331.48,20012,"NBEGEGCXXXX"]
[5,null,20113,"MOA","MOA","C.T - Prep",3491.4733333333334,4,0.08,"1917-05-04","2001-12-01",1573.3499218747165,2028.1710600000001,null,2028.1710600000001,0,"Deserved","Deserved MOA",31.031224037271638,31.221935387135673,61.094497094262294,92.316432481397968,3693.8374143561146,369.38374143561146,0,0,0,3324.4536729205029,0.95216355834132183,6815.9270062538362,{"$f":"IF(E76=\"Mohandseen Managers\",0,IF(E76=\"Mohandssen\",G76*Data!$E$28,IF(E76=\"Maadi Managers\",0,IF(E76=\"Maadi\",G76*Data!$E$29,IF(E76=\"City Stars Managers\",0,IF(E76=\"City Stars\",G76*Data!$E$30,IF(E76=\"MOA Managers\",0,IF(E76=\"MOA\",G76*Data!$E$31,IF(E76=\"Concord Managers\",0,IF(E76=\"Concord\",G76*Data!$E$32))))))))))","v":2084.4593559548448},1239.9943169656581,null,null,null,null,null,null,null,18000,null,"هشام سيد عبد العليم صايم",3324.45,20113,"NBEGEGCXXXX"]
[6,null,21517,"MOA","MOA","Food Server",2208.2200000000003,3,0.04,"1908-05-18","2011-01-04",995.08214234741035,2028.1710600000001,null,2028.1710600000001,0,"Deserved","Deserved MOA",19.626032623357851,19.746650075301758,61.094497094262294,80.841147169564053,3104.0943495169745,310.40943495169745,0,0,0,2793.6849145652768,1.2651297943888185,5001.9049145652771,{"$f":"IF(E77=\"Mohandseen Managers\",0,IF(E77=\"Mohandssen\",G77*Data!$E$28,IF(E77=\"Maadi Managers\",0,IF(E77=\"Maadi\",G77*Data!$E$29,IF(E77=\"City Stars Managers\",0,IF(E77=\"City Stars\",G77*Data!$E$30,IF(E77=\"MOA Managers\",0,IF(E77=\"MOA\",G77*Data!$E$31,IF(E77=\"Concord Managers\",0,IF(E77=\"Concord\",G77*Data!$E$32))))))))))","v":1318.3388213399714},1475.3460932253054,null,null,null,null,null,null,null,18000,null,"نادية عبد العظيم محمد محمد",2793.68,21517,"NBEGEGCXXXX"]
[7,null,22581,"MOA","MOA","Cook",1870.15,3,0.04,"1903-06-15","2016-01-03",842.73888856681367,2028.1710600000001,null,2028.1710600000001,0,"Deserved","Deserved MOA",16.621362414330402,16.72351379768573,61.094497094262294,77.81801089194802,2948.7279594587621,294.87279594587625,0,0,0,2653.8551635128861,1.419060055884761,4524.0051635128857,{"$f":"IF(E78=\"Mohandseen Managers\",0,IF(E78=\"Mohandssen\",G78*Data!$E$28,IF(E78=\"Maadi Managers\",0,IF(E78=\"Maadi\",G78*Data!$E$29,IF(E78=\"City Stars Managers\",0,IF(E78=\"City Stars\",G78*Data!$E$30,IF(E78=\"MOA Managers\",0,IF(E78=\"MOA\",G78*Data!$E$31,IF(E78=\"Concord Managers\",0,IF(E78=\"Concord\",G78*Data!$E$32))))))))))","v":1116.5062116677448},1537.3489518451413,null,null,null,null,null,null,null,18000,null,"سلطان محمد عبد العال سلطان",2653.86,22581,"NBEGEGCXXXX"]
[8,null,22585,"MOA","MOA","Food Server",1377.4550819672131,3,0.04,"1903-06-06","2016-01-12",620.71757069099181,2028.1710600000001,null,2028.1710600000001,0,"Deserved","Deserved MOA",12.242429819446697,12.317669207802055,61.094497094262294,73.41216630206435,2722.3007969930559,272.23007969930558,0,0,0,2450.0707172937505,1.778693729740124,3827.5257992609636,{"$f":"IF(E79=\"Mohandseen Managers\",0,IF(E79=\"Mohandssen\",G79*Data!$E$28,IF(E79=\"Maadi Managers\",0,IF(E79=\"Maadi\",G79*Data!$E$29,IF(E79=\"City Stars Managers\",0,IF(E79=\"City Stars\",G79*Data!$E$30,IF(E79=\"MOA Managers\",0,IF(E79=\"MOA\",G79*Data!$E$31,IF(E79=\"Concord Managers\",0,IF(E79=\"Concord\",G79*Data!$E$32))))))))))","v":822.36032153019596},1627.7103957635545,null,null,null,null,null,null,null,"18000",null,"محمود رمضان محمد عبد الله زيدان",2450.0700000000002,22585,"NBEGEGCXXXX"]
[9,null,20699,"MOA","MOA","C.T - Food Server",2913.5333333333333,4,{"$f":"IF(AND(H80>0,H80<=3),4%,IF(AND(H80>3,H80<=6),8%,IF(AND(H80>6,H80<=9),10%,IF(AND(H80>9,H80<=11),12%,IF(AND(H80>11,H80<=13),16%)))))","v":0.08},{"$f":"DAYS360(K80,TODAY(),1)","v":"1912-12-06"},"2006-05-21",{"$f":"IF(E80=\"Mohandseen Managers\",$X$7*G80,IF(E80=\"Mohandssen\",$W$7*G80,IF(E80=\"Maadi Managers\",$X$8*G80,IF(E80=\"Maadi\",$W$8*G80,IF(E80=\"City Stars Managers\",$X$9*G80,IF(E80=\"City Stars\",$W$9*G80,IF(E80=\"MOA Managers\",$X$10*G80,IF(E80=\"MOA\",$W$10*G80,IF(E80=\"Concord Managers\",$X$11*G80,IF(E80=\"Concord\",$W$11*G80))))))))))","v":1312.9149229397092},{"$f":"IF(E80=\"Mohandseen Managers\",$T$7,IF(E80=\"Mohandssen\",$S$7,IF(E80=\"Maadi Managers\",$T$8,IF(E80=\"Maadi\",$S$8,IF(E80=\"City Stars Managers\",$T$9,IF(E80=\"City Stars\",$S$9,IF(E80=\"MOA Managers\",$T$10,IF(E80=\"MOA\",$S$10,IF(E80=\"Concord Managers\",$T$11,IF(E80=\"Concord\",$S$11))))))))))","v":2028.1710600000001},null,{"$f":"(M80-(M80/30.5)*N80)","v":2028.1710600000001},0,"Deserved","Deserved MOA",{"$f":"IF(D80=\"Mohandssen\",$AG$7*G80,IF(D80=\"Maadi\",$AG$8*G80,IF(D80=\"City Stars\",$AG$9*G80,IF(D80=\"MOA\",$AG$10*G80,IF(D80=\"Concord\",$AG$11*G80)))))","v":25.894657348108677},{"$f":"IF(R80=\"Undeserved Mohandseen\",0,IF(R80=\"Deserved Mohandseen\",G80*$AJ$7,IF(R80=\"Undeserved Maadi\",0,IF(R80=\"Deserved Maadi\",G80*$AJ$8,IF(R80=\"Undeserved City Stars\",0,IF(R80=\"Deserved City Stars\",G80*$AJ$9,IF(R80=\"Undeserved MOA\",0,IF(R80=\"Deserved MOA\",G80*$AJ$10,IF(R80=\"Undeserved Concord\",0,IF(R80=\"Deserved Concord\",G80*$AJ$11))))))))))","v":26.053800443823913},{"$f":"IF(R80=\"Undeserved Mohandseen\",0,IF(R80=\"Deserved Mohandseen\",$AH$7,IF(R80=\"Undeserved Maadi\",0,IF(R80=\"Deserved Maadi\",$AH$8,IF(R80=\"Undeserved City Stars\",0,IF(R80=\"Deserved City Stars\",$AH$9,IF(R80=\"Undeserved MOA\",0,IF(R80=\"Deserved MOA\",$AH$10,IF(R80=\"Undeserved Concord\",0,IF(R80=\"Deserved Concord\",$AH$11))))))))))","v":61.094497094262294},{"$f":"T80+U80","v":87.148297538086211},{"$f":"L80+M80-P80+V80","v":3428.2342804777959},{"$f":"W80*10%","v":342.8234280477796},{"$f":"IF(D80=\"Mohandssen\",$AT$7*G80,IF(D80=\"Maadi\",$AT$8*G80,IF(D80=\"City Stars\",$AT$9*G80,IF(D80=\"MOA\",$AT$10*G80,IF(D80=\"Concord\",$AT$11*G80)))))","v":0},{"$f":"IF(D80=\"Mohandssen\",$AU$7,IF(D80=\"Maadi\",$AU$8,IF(D80=\"City Stars\",$AU$9,IF(D80=\"MOA\",$AU$10,IF(D80=\"Concord\",$AU$11)))))","v":0},{"$f":"SUM(Y80:Z80)","v":0},{"$f":"W80-X80+AA80","v":3085.4108524300163},{"$f":"IFERROR(AB80/G80,0)","v":1.0589928102521622},{"$f":"G80+AB80","v":5998.9441857633501},{"$f":"IF(E80=\"Mohandseen Managers\",0,IF(E80=\"Mohandssen\",G80*Data!$E$28,IF(E80=\"Maadi Managers\",0,IF(E80=\"Maadi\",G80*Data!$E$29,IF(E80=\"City Stars Managers\",0,IF(E80=\"City Stars\",G80*Data!$E$30,IF(E80=\"MOA Managers\",0,IF(E80=\"MOA\",G80*Data!$E$31,IF(E80=\"Concord Managers\",0,IF(E80=\"Concord\",G80*Data!$E$32))))))))))","v":1739.4209365920897},{"$f":"AB80-AE80","v":1345.9899158379267},null,null,null,null,null,null,null,18000,null,"أحمد فهمى محمد على شعبان",{"$f":"ROUND(AB80,2)","v":3085.41},20669,"NBEGEGCXXXX"]
[10,null,22872,"MOA","MOA","Dishwaser",1124.3899999999999,1,0.04,"1901-01-20","2018-06-09",506.67977376982566,2028.1710600000001,null,2028.1710600000001,{"$f":"M81-O81","v":0},"Deserved","Deserved MOA",9.9932591958126142,10.054675656487369,61.094497094262294,71.149172750749671,2606.0000065205754,260.60000065205753,0,0,0,2345.4000058685178,2.0859310433822054,3469.7900058685177,{"$f":"IF(E81=\"Mohandseen Managers\",0,IF(E81=\"Mohandssen\",G81*Data!$E$28,IF(E81=\"Maadi Managers\",0,IF(E81=\"Maadi\",G81*Data!$E$29,IF(E81=\"City Stars Managers\",0,IF(E81=\"City Stars\",G81*Data!$E$30,IF(E81=\"MOA Managers\",0,IF(E81=\"MOA\",G81*Data!$E$31,IF(E81=\"Concord Managers\",0,IF(E81=\"Concord\",G81*Data!$E$32))))))))))","v":671.27685979044213},1674.1231460780757,null,null,null,null,null,null,null,null,null,"منير محمد منير محمد",2345.4]
[11,null,21236,"MOA","MOA","C.T - Food Server",2377.62,4,0.08,"1910-06-26","2008-11-15",1071.4182478593841,2028.1710600000001,null,2028.1710600000001,0,"Deserved","Deserved MOA",21.131611744277333,21.261482167555297,61.094497094262294,82.355979261817595,3181.945287121202,318.19452871212025,0,0,0,2863.7507584090818,1.204461082262549,5241.3707584090816,{"$f":"IF(E82=\"Mohandseen Managers\",0,IF(E82=\"Mohandssen\",G82*Data!$E$28,IF(E82=\"Maadi Managers\",0,IF(E82=\"Maadi\",G82*Data!$E$29,IF(E82=\"City Stars Managers\",0,IF(E82=\"City Stars\",G82*Data!$E$30,IF(E82=\"MOA Managers\",0,IF(E82=\"MOA\",G82*Data!$E$31,IF(E82=\"Concord Managers\",0,IF(E82=\"Concord\",G82*Data!$E$32))))))))))","v":1419.4730363796825},1444.2777220293992,null,null,null,null,null,null,null,18000,null,"عمرو شوقى عبد المقصود حسن الشويخ",2863.75,21236,"NBEGEGCXXXX"]
[12,null,22894,"MOA","MOA","Cook",1344.49,3,0.04,"1900-11-19","2018-08-11",605.86263577210127,2028.1710600000001,null,2028.1710600000001,0,"Deserved","Deserved MOA",11.949445527066322,12.022884295832144,61.094497094262294,73.117381390094437,2707.1510771621961,270.71510771621962,0,0,0,2436.4359694459763,1.8121636973469317,3780.9259694459761,{"$f":"IF(E83=\"Mohandseen Managers\",0,IF(E83=\"Mohandssen\",G83*Data!$E$28,IF(E83=\"Maadi Managers\",0,IF(E83=\"Maadi\",G83*Data!$E$29,IF(E83=\"City Stars Managers\",0,IF(E83=\"City Stars\",G83*Data!$E$30,IF(E83=\"MOA Managers\",0,IF(E83=\"MOA\",G83*Data!$E$31,IF(E83=\"Concord Managers\",0,IF(E83=\"Concord\",G83*Data!$E$32))))))))))","v":802.67969763129486},1633.7562718146814,null,null,null,null,null,null,null,null,null,"عبد الله كرم حسنى ضاحى",2436.44]
[13,null,21559,"MOA","MOA","C.T - Cook",2419.1377049180328,4,0.08,"1917-10-31","2001-06-01",1090.1272201335162,2028.1710600000001,null,2028.1710600000001,0,"Deserved","Deserved MOA",21.500609322040532,21.632747526507771,61.094497094262294,82.727244620770065,3201.0255247542864,320.10255247542864,0,0,0,2880.9229722788577,1.190888375813427,5300.0606771968905,{"$f":"IF(E84=\"Mohandseen Managers\",0,IF(E84=\"Mohandssen\",G84*Data!$E$28,IF(E84=\"Maadi Managers\",0,IF(E84=\"Maadi\",G84*Data!$E$29,IF(E84=\"City Stars Managers\",0,IF(E84=\"City Stars\",G84*Data!$E$30,IF(E84=\"MOA Managers\",0,IF(E84=\"MOA\",G84*Data!$E$31,IF(E84=\"Concord Managers\",0,IF(E84=\"Concord\",G84*Data!$E$32))))))))))","v":1444.2596981101169},1436.6632741687408,null,null,null,null,null,null,null,18000,null,"محمود جمعة محمود احمد",2880.92,21559,"NBEGEGCXXXX"]
[14,null,22854,"MOA","MOA","Food Server",1611.49,3,0.04,"1901-07-13","2017-12-15",726.17987409380771,2028.1710600000001,null,2028.1710600000001,0,"Deserved","Deserved MOA",14.322465747169639,14.410488597081825,61.094497094262294,75.504985691344118,2829.8559197851523,282.98559197851523,0,0,0,2546.8703278066369,1.5804443886134178,4158.3603278066366,{"$f":"IF(E85=\"Mohandseen Managers\",0,IF(E85=\"Mohandssen\",G85*Data!$E$28,IF(E85=\"Maadi Managers\",0,IF(E85=\"Maadi\",G85*Data!$E$29,IF(E85=\"City Stars Managers\",0,IF(E85=\"City Stars\",G85*Data!$E$30,IF(E85=\"MOA Managers\",0,IF(E85=\"MOA\",G85*Data!$E$31,IF(E85=\"Concord Managers\",0,IF(E85=\"Concord\",G85*Data!$E$32))))))))))","v":962.08250409884442},1584.7878237077925,null,null,null,null,null,null,null,null,null,"عبد العزيز محمد عبد العزيز عبد الجواد",2546.87]
[15,null,22917,"MOA","MOA","Cook",1345.3,3,0.04,"1900-05-28","2019-02-06",606.2276431243132,2028.1710600000001,null,2028.1710600000001,0,"Deserved","Deserved MOA",11.956644577172254,12.030127589779756,61.094497094262294,73.124624684042047,2707.5233278083551,270.7523327808355,0,0,0,2436.7709950275198,1.811321634600104,3782.0709950275195,{"$f":"IF(E86=\"Mohandseen Managers\",0,IF(E86=\"Mohandssen\",G86*Data!$E$28,IF(E86=\"Maadi Managers\",0,IF(E86=\"Maadi\",G86*Data!$E$29,IF(E86=\"City Stars Managers\",0,IF(E86=\"City Stars\",G86*Data!$E$30,IF(E86=\"MOA Managers\",0,IF(E86=\"MOA\",G86*Data!$E$31,IF(E86=\"Concord Managers\",0,IF(E86=\"Concord\",G86*Data!$E$32))))))))))","v":803.16327917900537},1633.6077158485145,null,null,null,null,null,null,null,null,null,"يوسف طارق عاشور عيد",2436.77]
[16,null,22921,"MOA","MOA","Dishwaser",1125.05,1,0.04,"1900-04-05","2019-03-29",506.97718716792428,2028.1710600000001,null,2028.1710600000001,0,"Deserved","Deserved MOA",9.999125088491521,10.060577599703942,61.094497094262294,71.155074693966242,2606.3033218618907,260.63033218618909,0,0,0,2345.6729896757015,2.084949993045377,3470.7229896757017,{"$f":"IF(E87=\"Mohandseen Managers\",0,IF(E87=\"Mohandssen\",G87*Data!$E$28,IF(E87=\"Maadi Managers\",0,IF(E87=\"Maadi\",G87*Data!$E$29,IF(E87=\"City Stars Managers\",0,IF(E87=\"City Stars\",G87*Data!$E$30,IF(E87=\"MOA Managers\",0,IF(E87=\"MOA\",G87*Data!$E$31,IF(E87=\"Concord Managers\",0,IF(E87=\"Concord\",G87*Data!$E$32))))))))))","v":671.67088919968785},1674.0021004760138,null,null,null,null,null,null,null,null,null,"يوسف رمضان محمد عبد اللطيف",2345.67]
[17,null,22916,"MOA","MOA","Cook",287.92,3,{"$f":"IF(AND(H88>0,H88<=3),4%,IF(AND(H88>3,H88<=6),8%,IF(AND(H88>6,H88<=9),10%,IF(AND(H88>9,H88<=11),12%,IF(AND(H88>11,H88<=13),16%)))))","v":0.04},{"$f":"DAYS360(K88,TODAY(),1)","v":"1900-07-11"},"2018-12-22",{"$f":"IF(E88=\"Mohandseen Managers\",$X$7*G88,IF(E88=\"Mohandssen\",$W$7*G88,IF(E88=\"Maadi Managers\",$X$8*G88,IF(E88=\"Maadi\",$W$8*G88,IF(E88=\"City Stars Managers\",$X$9*G88,IF(E88=\"City Stars\",$W$9*G88,IF(E88=\"MOA Managers\",$X$10*G88,IF(E88=\"MOA\",$W$10*G88,IF(E88=\"Concord Managers\",$X$11*G88,IF(E88=\"Concord\",$W$11*G88))))))))))","v":129.74434178871053},{"$f":"IF(E88=\"Mohandseen Managers\",$T$7,IF(E88=\"Mohandssen\",$S$7,IF(E88=\"Maadi Managers\",$T$8,IF(E88=\"Maadi\",$S$8,IF(E88=\"City Stars Managers\",$T$9,IF(E88=\"City Stars\",$S$9,IF(E88=\"MOA Managers\",$T$10,IF(E88=\"MOA\",$S$10,IF(E88=\"Concord Managers\",$T$11,IF(E88=\"Concord\",$S$11))))))))))","v":2028.1710600000001},{"$f":"30-9","v":21},{"$f":"(M88-(M88/30.5)*N88)","v":631.72541213114755},{"$f":"M88-O88","v":1396.4456478688526},"Undeserved","Undeserved MOA",{"$f":"IF(D88=\"Mohandssen\",$AG$7*G88,IF(D88=\"Maadi\",$AG$8*G88,IF(D88=\"City Stars\",$AG$9*G88,IF(D88=\"MOA\",$AG$10*G88,IF(D88=\"Concord\",$AG$11*G88)))))","v":2.5589512425923107},{"$f":"IF(R88=\"Undeserved Mohandseen\",0,IF(R88=\"Deserved Mohandseen\",G88*$AJ$7,IF(R88=\"Undeserved Maadi\",0,IF(R88=\"Deserved Maadi\",G88*$AJ$8,IF(R88=\"Undeserved City Stars\",0,IF(R88=\"Deserved City Stars\",G88*$AJ$9,IF(R88=\"Undeserved MOA\",0,IF(R88=\"Deserved MOA\",G88*$AJ$10,IF(R88=\"Undeserved Concord\",0,IF(R88=\"Deserved Concord\",G88*$AJ$11))))))))))","v":0},{"$f":"IF(R88=\"Undeserved Mohandseen\",0,IF(R88=\"Deserved Mohandseen\",$AH$7,IF(R88=\"Undeserved Maadi\",0,IF(R88=\"Deserved Maadi\",$AH$8,IF(R88=\"Undeserved City Stars\",0,IF(R88=\"Deserved City Stars\",$AH$9,IF(R88=\"Undeserved MOA\",0,IF(R88=\"Deserved MOA\",$AH$10,IF(R88=\"Undeserved Concord\",0,IF(R88=\"Deserved Concord\",$AH$11))))))))))","v":0},{"$f":"T88+U88","v":0},{"$f":"L88+M88-P88+V88","v":761.46975391985825},{"$f":"W88*10%","v":76.146975391985833},{"$f":"IF(D88=\"Mohandssen\",$AT$7*G88,IF(D88=\"Maadi\",$AT$8*G88,IF(D88=\"City Stars\",$AT$9*G88,IF(D88=\"MOA\",$AT$10*G88,IF(D88=\"Concord\",$AT$11*G88)))))","v":0},{"$f":"IF(D88=\"Mohandssen\",$AU$7,IF(D88=\"Maadi\",$AU$8,IF(D88=\"City Stars\",$AU$9,IF(D88=\"MOA\",$AU$10,IF(D88=\"Concord\",$AU$11)))))","v":0},{"$f":"SUM(Y88:Z88)","v":0},{"$f":"W88-X88+AA88","v":685.3227785278724},{"$f":"IFERROR(AB88/G88,0)","v":2.3802541627114211},{"$f":"G88+AB88","v":973.24277852787236},{"$f":"IF(E88=\"Mohandseen Managers\",0,IF(E88=\"Mohandssen\",G88*Data!$E$28,IF(E88=\"Maadi Managers\",0,IF(E88=\"Maadi\",G88*Data!$E$29,IF(E88=\"City Stars Managers\",0,IF(E88=\"City Stars\",G88*Data!$E$30,IF(E88=\"MOA Managers\",0,IF(E88=\"MOA\",G88*Data!$E$31,IF(E88=\"Concord Managers\",0,IF(E88=\"Concord\",G88*Data!$E$32))))))))))","v":171.89234471212313},{"$f":"AB88-AE88","v":513.43043381574921},null,null,null,null,null,null,null,null,null,"ابراهيم غريب فاروق السيد محمد",{"$f":"ROUND(AB88,2)","v":685.32}]
[1,null,20112,"Concord","Concord Managers","S R .Assistant Manager",6577.2,9,0.1,"1917-05-04","2001-12-01",719.83974743358624,1885.2493799999995,0,1885.2493799999995,0,"Deserved","Deserved Concord",168.34542355637512,173.72870310503527,198.90043224590158,372.62913535093685,2977.7182627845227,297.77182627845229,0,0,0,2679.9464365060703,0.40746007974610327,9257.146436506071,{"$f":"IF(E89=\"Mohandseen Managers\",0,IF(E89=\"Mohandssen\",G89*Data!$E$28,IF(E89=\"Maadi Managers\",0,IF(E89=\"Maadi\",G89*Data!$E$29,IF(E89=\"City Stars Managers\",0,IF(E89=\"City Stars\",G89*Data!$E$30,IF(E89=\"MOA Managers\",0,IF(E89=\"MOA\",G89*Data!$E$31,IF(E89=\"Concord Managers\",0,IF(E89=\"Concord\",G89*Data!$E$32))))))))))","v":0},2679.9464365060703,null,null,null,null,null,null,null,18000,"1495000499566100013","رفاعى رفعت عبد الغنى عثمان",2679.95,20112,"NBEGEGCXXXX"]
[2,null,30043,"Concord","Concord Managers","Resturant Manager",10210.116666666667,10,0.12,"1911-04-06","2008-02-01",1117.4432589248895,1885.2493799999995,0,1885.2493799999995,0,"Deserved","Deserved Concord",261.33102457124687,269.68775878050019,198.90043224590158,468.58819102640177,3471.2808299512908,347.12808299512909,0,0,0,3124.1527469561615,0.30598599888243144,13334.269413622827,{"$f":"IF(E90=\"Mohandseen Managers\",0,IF(E90=\"Mohandssen\",G90*Data!$E$28,IF(E90=\"Maadi Managers\",0,IF(E90=\"Maadi\",G90*Data!$E$29,IF(E90=\"City Stars Managers\",0,IF(E90=\"City Stars\",G90*Data!$E$30,IF(E90=\"MOA Managers\",0,IF(E90=\"MOA\",G90*Data!$E$31,IF(E90=\"Concord Managers\",0,IF(E90=\"Concord\",G90*Data!$E$32))))))))))","v":0},3124.1527469561615,null,null,null,null,null,null,null,18000,null,"عاطف نفاد عبد الله محمد",3124.15,30043,"NBEGEGCXXXX"]
[3,null,22911,"Concord","Concord Managers","Assistant Manager",5359.8666666666668,9,0.1,"1900-08-27","2018-11-05",586.60905364152393,1885.2493799999995,0,1885.2493799999995,0,"Deserved","Deserved Concord",137.18740865500465,141.57433023412827,198.90043224590158,340.47476248002988,2812.3331961215531,281.2333196121553,0,0,0,2531.0998765093977,0.47223187327596416,7890.9665431760641,{"$f":"IF(E91=\"Mohandseen Managers\",0,IF(E91=\"Mohandssen\",G91*Data!$E$28,IF(E91=\"Maadi Managers\",0,IF(E91=\"Maadi\",G91*Data!$E$29,IF(E91=\"City Stars Managers\",0,IF(E91=\"City Stars\",G91*Data!$E$30,IF(E91=\"MOA Managers\",0,IF(E91=\"MOA\",G91*Data!$E$31,IF(E91=\"Concord Managers\",0,IF(E91=\"Concord\",G91*Data!$E$32))))))))))","v":0},2531.0998765093977,null,null,null,null,null,null,null,"18000",null,"حسن احمد حسن موسى",2531.1,22911,"NBEGEGCXXXX"]
[1,null,20914,"Concord","Concord","C.T - Cook",2943.9233333333332,4,0.08,"1911-07-31","2007-10-05",1651.8848797652727,2289.2313899999995,0,2289.2313899999995,0,"Deserved","Deserved Concord",75.350608232605921,77.760138469356633,198.90043224590158,276.66057071525825,4217.7768404805302,421.77768404805306,0,0,0,3795.9991564324773,1.2894354664237671,6739.9224897658105,{"$f":"IF(E92=\"Mohandseen Managers\",0,IF(E92=\"Mohandssen\",G92*Data!$E$28,IF(E92=\"Maadi Managers\",0,IF(E92=\"Maadi\",G92*Data!$E$29,IF(E92=\"City Stars Managers\",0,IF(E92=\"City Stars\",G92*Data!$E$30,IF(E92=\"MOA Managers\",0,IF(E92=\"MOA\",G92*Data!$E$31,IF(E92=\"Concord Managers\",0,IF(E92=\"Concord\",G92*Data!$E$32))))))))))","v":2188.5067299486927},1607.4924264837846,null,null,null,null,null,null,null,18000,null,"أشرف أبو الحسن محمد أحمد",3796,20914,"NBEGEGCXXXX"]
[2,null,30254,"Concord","Concord","Cook",2705.1033333333335,3,0.04,"1908-08-16","2010-10-04",1517.8789623832952,2289.2313899999995,0,2289.2313899999995,0,"Deserved","Deserved Concord",69.237938091248893,71.451999918674815,198.90043224590158,270.35243216457638,4077.4627845478708,407.7462784547871,0,0,0,3669.7165060930838,1.3565901386735997,6374.8198394264173,{"$f":"IF(E93=\"Mohandseen Managers\",0,IF(E93=\"Mohandssen\",G93*Data!$E$28,IF(E93=\"Maadi Managers\",0,IF(E93=\"Maadi\",G93*Data!$E$29,IF(E93=\"City Stars Managers\",0,IF(E93=\"City Stars\",G93*Data!$E$30,IF(E93=\"MOA Managers\",0,IF(E93=\"MOA\",G93*Data!$E$31,IF(E93=\"Concord Managers\",0,IF(E93=\"Concord\",G93*Data!$E$32))))))))))","v":2010.9684186318175},1658.7480874612663,null,null,null,null,null,null,null,18000,null,"حسام محمد بيومى محمد",3669.72,30254,"NBEGEGCXXXX"]
[3,null,22657,"Concord","Concord","Cook",1600.3899999999999,3,0.04,"1903-01-18","2016-06-01",898.00573703602265,2289.2313899999995,0,2289.2313899999995,0,"Deserved","Deserved Concord",40.96246615663005,42.272346767966212,198.90043224590158,241.1727790138678,3428.4099060498902,342.84099060498903,0,0,0,3085.568915444901,1.9280106195645443,4685.9589154449004,{"$f":"IF(E94=\"Mohandseen Managers\",0,IF(E94=\"Mohandssen\",G94*Data!$E$28,IF(E94=\"Maadi Managers\",0,IF(E94=\"Maadi\",G94*Data!$E$29,IF(E94=\"City Stars Managers\",0,IF(E94=\"City Stars\",G94*Data!$E$30,IF(E94=\"MOA Managers\",0,IF(E94=\"MOA\",G94*Data!$E$31,IF(E94=\"Concord Managers\",0,IF(E94=\"Concord\",G94*Data!$E$32))))))))))","v":1189.7267316322509},1895.8421838126501,null,null,null,null,null,null,null,"18000",null,"فارس عبد العظيم عبد الحميد على سماحه",3085.57,22657,"NBEGEGCXXXX"]
[4,null,22787,"Concord","Concord","Cook",1601.2,3,0.04,"1902-01-11","2017-06-13",898.46024165489632,2289.2313899999995,0,2289.2313899999995,0,"Deserved","Deserved Concord",40.983198351649314,42.293741928447133,198.90043224590158,241.19417417434872,3428.8858058292444,342.88858058292448,0,0,0,3085.9972252463199,1.9273027886874343,4687.1972252463202,{"$f":"IF(E95=\"Mohandseen Managers\",0,IF(E95=\"Mohandssen\",G95*Data!$E$28,IF(E95=\"Maadi Managers\",0,IF(E95=\"Maadi\",G95*Data!$E$29,IF(E95=\"City Stars Managers\",0,IF(E95=\"City Stars\",G95*Data!$E$30,IF(E95=\"MOA Managers\",0,IF(E95=\"MOA\",G95*Data!$E$31,IF(E95=\"Concord Managers\",0,IF(E95=\"Concord\",G95*Data!$E$32))))))))))","v":1190.3288840154964},1895.6683412308234,null,null,null,null,null,null,null,"18000",null,"محمود سعيد عواض محمد",3086,22787,"NBEGEGCXXXX"]
[5,null,22821,"Concord","Concord","Cook",59,3,0.04,"1901-11-10","2017-08-15",33.10589199203028,2289.2313899999995,{"$f":"30-4","v":26},337.75545098360658,1951.4759390163929,"Undeserved","Undeserved Concord",1.5101228470817569,0,0,0,370.86134297563672,37.086134297563675,0,0,0,333.77520867807306,5.6572069267470013,392.77520867807306,{"$f":"IF(E96=\"Mohandseen Managers\",0,IF(E96=\"Mohandssen\",G96*Data!$E$28,IF(E96=\"Maadi Managers\",0,IF(E96=\"Maadi\",G96*Data!$E$29,IF(E96=\"City Stars Managers\",0,IF(E96=\"City Stars\",G96*Data!$E$30,IF(E96=\"MOA Managers\",0,IF(E96=\"MOA\",G96*Data!$E$31,IF(E96=\"Concord Managers\",0,IF(E96=\"Concord\",G96*Data!$E$32))))))))))","v":43.860482236394134},289.91472644167891,null,null,null,null,null,null,null,null,null,"مصطفى حسين مصطفى حسين محمد",333.78]
[6,null,21234,"Concord","Concord","Cook",2440.4700000000003,3,0.04,"1910-03-12","2009-03-01",1369.38874965746,2289.2313899999995,0,2289.2313899999995,0,"Deserved","Deserved Concord",62.464567874874845,64.462033702296637,198.90043224590158,263.36246594819823,3921.9826056056581,392.19826056056581,0,0,0,3529.7843450450923,1.4463543272587214,5970.2543450450921,{"$f":"IF(E97=\"Mohandseen Managers\",0,IF(E97=\"Mohandssen\",G97*Data!$E$28,IF(E97=\"Maadi Managers\",0,IF(E97=\"Maadi\",G97*Data!$E$29,IF(E97=\"City Stars Managers\",0,IF(E97=\"City Stars\",G97*Data!$E$30,IF(E97=\"MOA Managers\",0,IF(E97=\"MOA\",G97*Data!$E$31,IF(E97=\"Concord Managers\",0,IF(E97=\"Concord\",G97*Data!$E$32))))))))))","v":1814.2405268381831},1715.5438182069092,null,null,null,null,null,null,null,18000,null,"عمر مصطفى جاد محمد",3529.78,21234,"NBEGEGCXXXX"]
[7,null,22849,"Concord","Concord","Baker",1601.2,3,0.04,"1901-07-27","2017-12-01",898.46024165489632,2289.2313899999995,0,2289.2313899999995,0,"Deserved","Deserved Concord",40.983198351649314,42.293741928447133,198.90043224590158,241.19417417434872,3428.8858058292444,342.88858058292448,0,0,0,3085.9972252463199,1.9273027886874343,4687.1972252463202,{"$f":"IF(E98=\"Mohandseen Managers\",0,IF(E98=\"Mohandssen\",G98*Data!$E$28,IF(E98=\"Maadi Managers\",0,IF(E98=\"Maadi\",G98*Data!$E$29,IF(E98=\"City Stars Managers\",0,IF(E98=\"City Stars\",G98*Data!$E$30,IF(E98=\"MOA Managers\",0,IF(E98=\"MOA\",G98*Data!$E$31,IF(E98=\"Concord Managers\",0,IF(E98=\"Concord\",G98*Data!$E$32))))))))))","v":1190.3288840154964},1895.6683412308234,null,null,null,null,null,null,null,"18000",null,"بسنت عادل عبد ربه عامر",3086,22849,"NBEGEGCXXXX"]
[8,null,22893,"Concord","Concord","Dishwaser",1224.3899999999999,1,0.04,"1900-11-23","2018-08-07",687.02581518850764,2289.2313899999995,0,2289.2313899999995,0,"Deserved","Deserved Concord",31.338632419295461,32.340766100281904,198.90043224590158,231.2411983461835,3207.4984035346906,320.7498403534691,0,0,0,2886.7485631812215,2.3577034794315717,4111.1385631812209,{"$f":"IF(E99=\"Mohandseen Managers\",0,IF(E99=\"Mohandssen\",G99*Data!$E$28,IF(E99=\"Maadi Managers\",0,IF(E99=\"Maadi\",G99*Data!$E$29,IF(E99=\"City Stars Managers\",0,IF(E99=\"City Stars\",G99*Data!$E$30,IF(E99=\"MOA Managers\",0,IF(E99=\"MOA\",G99*Data!$E$31,IF(E99=\"Concord Managers\",0,IF(E99=\"Concord\",G99*Data!$E$32))))))))))","v":910.20908212573909},1976.5394810554824,null,null,null,null,null,null,null,"18000",null,"احمد محمد احمد مرسى خليل",2886.75,22893,"NBEGEGCXXXX"]
[9,null,22904,"Concord","Concord","Food Server",864.6467213114754,3,0.04,"1900-10-20","2018-09-11",485.16781300001372,2289.2313899999995,10,1538.6637211475406,750.56766885245884,"Undeserved","Undeserved Concord",22.130894381471048,0,0,0,2023.8315341475543,202.38315341475544,0,0,0,1821.4483807327988,2.1065810299610801,2686.0951020442744,{"$f":"IF(E100=\"Mohandseen Managers\",0,IF(E100=\"Mohandssen\",G100*Data!$E$28,IF(E100=\"Maadi Managers\",0,IF(E100=\"Maadi\",G100*Data!$E$29,IF(E100=\"City Stars Managers\",0,IF(E100=\"City Stars\",G100*Data!$E$30,IF(E100=\"MOA Managers\",0,IF(E100=\"MOA\",G100*Data!$E$31,IF(E100=\"Concord Managers\",0,IF(E100=\"Concord\",G100*Data!$E$32))))))))))","v":642.77664679387112},1178.6717339389277,null,null,null,null,null,null,null,null,null,"عبد الرحمن احمد السيد حسنى",1821.45]
[10,null,21553,"Concord","Concord","C.T - Cook",2414.0933333333337,4,0.08,"1908-01-29","2011-04-24",1354.5883585087067,2289.2313899999995,0,2289.2313899999995,0,"Deserved","Deserved Concord",61.789449112786826,63.765326274784357,198.90043224590158,262.66575852068593,3906.485507029392,390.64855070293925,0,0,0,3515.8369563264528,1.4563798788474565,5929.9302896597865,{"$f":"IF(E101=\"Mohandseen Managers\",0,IF(E101=\"Mohandssen\",G101*Data!$E$28,IF(E101=\"Maadi Managers\",0,IF(E101=\"Maadi\",G101*Data!$E$29,IF(E101=\"City Stars Managers\",0,IF(E101=\"City Stars\",G101*Data!$E$30,IF(E101=\"MOA Managers\",0,IF(E101=\"MOA\",G101*Data!$E$31,IF(E101=\"Concord Managers\",0,IF(E101=\"Concord\",G101*Data!$E$32))))))))))","v":1794.6321654858336},1721.2047908406191,null,null,null,null,null,null,null,18000,null,"اشرف محمد احمد سيد",3515.84,21553,"NBEGEGCXXXX"]
[11,null,22360,"Concord","Concord","Food Server",1711.82,3,0.04,"1904-04-23","2015-02-20",960.530983555886,2289.2313899999995,0,2289.2313899999995,0,"Deserved","Deserved Concord",43.814550713415137,45.215634091902551,198.90043224590158,244.11606633780414,3493.8784398936896,349.387843989369,0,0,0,3144.4905959043208,1.8369282961434736,4856.3105959043205,{"$f":"IF(E102=\"Mohandseen Managers\",0,IF(E102=\"Mohandssen\",G102*Data!$E$28,IF(E102=\"Maadi Managers\",0,IF(E102=\"Maadi\",G102*Data!$E$29,IF(E102=\"City Stars Managers\",0,IF(E102=\"City Stars\",G102*Data!$E$30,IF(E102=\"MOA Managers\",0,IF(E102=\"MOA\",G102*Data!$E$31,IF(E102=\"Concord Managers\",0,IF(E102=\"Concord\",G102*Data!$E$32))))))))))","v":1272.5635712187152},1871.9270246856056,null,null,null,null,null,null,null,18000,null,"محمد صلاح خلف الله محمود",3144.49,22360,"NBEGEGCXXXX"]
[12,null,20679,"Concord","Concord","C.T - Food Server",2929.56,4,0.08,"1912-12-31","2006-04-26",1643.8253719351223,2289.2313899999995,0,2289.2313899999995,0,"Deserved","Deserved Concord",74.982974371132741,77.380748566013978,198.90043224590158,276.28118081191553,4209.3379427470372,420.93379427470376,0,0,0,3788.4041484723334,1.2931648945481005,6717.9641484723334,{"$f":"IF(E103=\"Mohandseen Managers\",0,IF(E103=\"Mohandssen\",G103*Data!$E$28,IF(E103=\"Maadi Managers\",0,IF(E103=\"Maadi\",G103*Data!$E$29,IF(E103=\"City Stars Managers\",0,IF(E103=\"City Stars\",G103*Data!$E$30,IF(E103=\"MOA Managers\",0,IF(E103=\"MOA\",G103*Data!$E$31,IF(E103=\"Concord Managers\",0,IF(E103=\"Concord\",G103*Data!$E$32))))))))))","v":2177.8290566178102},1610.5750918545232,null,null,null,null,null,null,null,18000,null,"محمود محمد عزت احمد",3788.4,20679,"NBEGEGCXXXX"]
[13,null,22923,"Concord","Concord","Cook",1861.73,3,0.04,"1900-03-12","2019-04-23",1044.6480050563141,2289.2313899999995,0,2289.2313899999995,0,"Deserved","Deserved Concord",47.651542510127449,49.175323607574242,198.90043224590158,248.07575585347581,3581.9551509097892,358.19551509097892,0,0,0,3223.7596358188102,1.7315935370965769,5085.4896358188107,{"$f":"IF(E104=\"Mohandseen Managers\",0,IF(E104=\"Mohandssen\",G104*Data!$E$28,IF(E104=\"Maadi Managers\",0,IF(E104=\"Maadi\",G104*Data!$E$29,IF(E104=\"City Stars Managers\",0,IF(E104=\"City Stars\",G104*Data!$E$30,IF(E104=\"MOA Managers\",0,IF(E104=\"MOA\",G104*Data!$E$31,IF(E104=\"Concord Managers\",0,IF(E104=\"Concord\",G104*Data!$E$32))))))))))","v":1384.0063659993568},1839.7532698194534,null,null,null,null,null,null,null,null,null,"عمر سعداوى احمد سعد",3223.76]
[14,null,22924,"Concord","Concord","Host",521.13442622950811,3,0.04,"1900-02-16","2019-05-18",292.4172886115723,2289.2313899999995,17,1013.2663529508195,1275.96503704918,"Undeserved","Undeserved Concord",13.338593278813944,0,0,0,1305.683641562392,130.5683641562392,0,0,0,1175.1152774061529,2.254917768354515,1696.249703635661,{"$f":"IF(E105=\"Mohandseen Managers\",0,IF(E105=\"Mohandssen\",G105*Data!$E$28,IF(E105=\"Maadi Managers\",0,IF(E105=\"Maadi\",G105*Data!$E$29,IF(E105=\"City Stars Managers\",0,IF(E105=\"City Stars\",G105*Data!$E$30,IF(E105=\"MOA Managers\",0,IF(E105=\"MOA\",G105*Data!$E$31,IF(E105=\"Concord Managers\",0,IF(E105=\"Concord\",G105*Data!$E$32))))))))))","v":387.41029227818285},787.70498512797008,null,null,null,null,null,null,null,null,null,"عبد الرحمن احمد محمد",1175.1199999999999]
["Total",null,null,null,null,null,{"$f":"SUBTOTAL(9,G16:G105)","v":225657.94051912578},null,null,null,null,{"$f":"SUBTOTAL(9,L16:L105)","v":76851.241199999975},{"$f":"SUBTOTAL(9,M16:M105)","v":179319.5627999999},{"$f":"SUBTOTAL(9,N16:N105)","v":153},{"$f":"SUBTOTAL(9,O16:O105)","v":168081.33643520111},{"$f":"SUBTOTAL(9,P16:P105)","v":11238.226364798806},null,null,{"$f":"SUBTOTAL(9,S16:S105)","v":3371.4679094396406},3371.467909439642,7866.7584553591551,11238.226364798806,256170.80399999997,25617.080399999988,0,0,0,230553.72359999997,null,{"$f":"SUBTOTAL(9,AD16:AD105)","v":456211.66411912563},{"$f":"SUBTOTAL(9,AE16:AE105)","v":86544.190540540585},{"$f":"SUBTOTAL(9,AF16:AF105)","v":144009.53305945938},null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,AQ16:AQ105)","v":230553.73000000007}]

{"sheet":"Indirect 15%","index":2,"n_rows":35,"n_cols":39,"rows_kept":35,"cut":false,"hidden":false,"merged":[[13,33,13,38],[29,33,29,35],[29,37,29,38],[13,23,13,25],[13,26,13,30],[1,24,3,30],[4,24,5,24],[4,11,5,11],[4,12,4,14],[4,19,4,20],[4,21,4,22],[4,25,5,25],[4,26,5,26],[13,11,13,12],[29,0,29,5],[13,0,13,10],[1,4,1,7],[2,6,3,6],[2,7,3,7],[6,4,6,5],[5,6,6,7],[1,11,1,22],[2,11,3,22],[13,13,13,20],[13,21,13,22]]}
["January",{"$f":"Data!A17","v":"Service Charge (12%) Calculation (Details) :"},{"$f":"Data!D1","v":"June"},2019,null,null,null,null,null,"Deserved Mohandseen"]
["February",{"$f":"Data!A12","v":"3- Employees Not Directly connected to customers"},{"$f":"Data!C12","v":0.15},null,"Service Charge (15% Of 12%) Calculation (Details) :",null,null,null,null,"Undeserved Mohandseen",null,"Redistribute Deducted Amounts (From Equal Share Amount) To All Other Staff ",null,null,null,null,null,null,null,null,null,null,null,null,"Distribute Other Hold (Add / Deducted) Amounts"]
["March",{"$f":"Data!A18","v":0},{"$f":"Data!D18","v":5559.8579999999974},"Deserved",0.3,0.7,"Equal Share","Distribution %",null,"Deserved Maadi",null,"Diff. Amount Of Equal Share ( Distribute For All Other Staff)"]
["April",{"$f":"Data!A19","v":0},{"$f":"Data!D19","v":8267.2019999999975},"Undeserved","12% According To Net Salary","12% According To Equal Share",null,null,null,"Undeserved Maadi"]
["May",{"$f":"Data!A20","v":0},{"$f":"Data!D20","v":24819.155999999999},null,{"$f":"C8*E3","v":19212.810299999994},{"$f":"C8*F3","v":44829.890699999989},{"$f":"F5/E7","v":3202.1350499999994},{"$f":"E5/G30","v":{"$error":"#DIV/0!"}},null,"Deserved City Stars",null,"Deducted Amounts","Number Of Deserved Staff",null,null,{"$f":"E3","v":0.3},{"$f":"F3","v":0.7},"Net Salary","Equal Share","Net Deducted Amount Summary",null,"Net Salary Without Undeserved Employees",null,null,"Add (Hold Amounts)","Deducted (Hold Amounts)","Hold Amounts",{"$f":"E3","v":0.3},{"$f":"F3","v":0.7},"Net Salary","Equal Share"]
["June",{"$f":"Data!A21","v":0},{"$f":"Data!D21","v":11930.418000000001},null,"Number Of Staff","Indirect",null,null,null,"Undeserved City Stars",null,null,"All Staff","Undeserved Staff","Net Staff","Distribute Deducted Amounts According To Net Salary","Distribute Deducted Amounts According To Equal Share","Distribution %","Amount","Amount","Distribution %","Employee Undeserved","Deserved Net Salary",null,null,null,null,"Distribute Deducted Amounts According To Net Salary","Distribute Deducted Amounts According To Equal Share","Distribution %","Amount"]
["July",{"$f":"Data!A22","v":0},{"$f":"Data!D22","v":13466.066999999999},null,{"$f":"COUNTIF($B$16:$E$29,F6)","v":14},null,null,null,null,"Deserved MOA",null,{"$f":"P30","v":0},{"$f":"E7","v":14},{"$f":"COUNTIF($Q$16:$Q$116,D4)","v":2},{"$f":"M7-N7","v":12},{"$f":"L7*P5","v":0},{"$f":"L7*Q5","v":0},{"$f":"P7/G30","v":{"$error":"#DIV/0!"}},{"$f":"Q7/O7","v":0},{"$f":"P7","v":0},{"$f":"T7/W7","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF($Q$16:$Q$116,D4,$G$16:$G$116)","v":0},{"$f":"G30-V7","v":0},null,null,null,{"$f":"Y7-Z7","v":0},{"$f":"AA7*AB5","v":0},{"$f":"AA7*AC5","v":0},{"$f":"AB7/G30","v":{"$error":"#DIV/0!"}},{"$f":"AC7/M7","v":0}]
["August",{"$f":"Data!A23","v":"Total Service Charge (12%)"},{"$f":"SUM(C3:C7)","v":64042.700999999986},null,null,null,null,null,null,"Undeserved MOA"]
["September",null,null,null,null,null,null,null,null,"Deserved Concord"]
["October",null,null,null,null,null,null,null,null,"Undeserved Concord"]
["November"]
["December"]
[]
["Employees Data",null,null,null,null,null,null,null,null,null,null,"Service Charge (60% Of 12%) Calculation",null,"Redistribute Deducted Amounts (From Equal Share Amount) To All Other Staff ",null,null,null,null,null,null,null,null,null,"Distribute Other Hold (Add / Deducted) Amounts",null,null,null,null,null,null,null,null,null,"El- Ahly ( ACH ) Payroll Data"]
["#","Employee Name","Employee ID","Branch","Division / Department","Job Description / Occupation","Net Salary","Grade","Incentive %","Number Of Work Years","Date Of Joining","12% According To Net Salary Total","12% Equal Share Total","Number Of Days (Sick Leave & Absent (With/Without) Permission)","12% Equal Share Net","Diff. Amount Of Equal Share ( Distribute For All Other Staff)","Distribution Condition","Distribute Deducted Amounts According To Net Salary","Redistribute Deducted Amounts According To Net Salary","Distribute Deducted Amounts According To Equal Share","Total Distribute Deducted Amounts","Total 12%","Tax 10%","Distribute Deducted Amounts According To Net Salary","Distribute Deducted Amounts According To Equal Share","Total Distribute Deducted Amounts","Net 12%","%","Total Package (Net)","Current 12% (Net)","12 % Diff. To Current",null,null,"Bank Branch Code","Acc. Num. for Transfer","Employee Name","NBOE Amount","Bank NBOE EMP. NUM.","Bank Code"]
[1,"Hemdan Abdel Samie Mahmoud Abd Allah",20016,"Indirect","Head Office","HR Officer",null,7,{"$f":"IF(AND(H16>0,H16<=3),4%,IF(AND(H16>3,H16<=6),8%,IF(AND(H16>6,H16<=9),10%,IF(AND(H16>9,H16<=11),12%,IF(AND(H16>11,H16<=13),16%)))))","v":0.1},{"$f":"DAYS360(K16,TODAY(),1)","v":"1918-09-26"},"2000-07-01",{"$f":"IFERROR(G16*$H$5,0)","v":0},{"$f":"IF(G16>=1,$G$5,0)","v":0},0,{"$f":"(M16-(M16/30.5)*N16)","v":0},{"$f":"M16-O16","v":0},"Deserved",{"$f":"IF(D16=\"Indirect\",G16*$R$7,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Q16=\"Undeserved\",0,G16*$U$7)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Q16=\"Deserved\",$S$7,0)","v":0},{"$f":"S16+T16","v":{"$error":"#DIV/0!"}},{"$f":"L16+M16-P16+U16","v":{"$error":"#DIV/0!"}},{"$f":"V16*10%","v":{"$error":"#DIV/0!"}},{"$f":"IF(D16=\"Indirect\",G16*$AD$7,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(D16=\"Indirect\",$AE$7,0)","v":0},{"$f":"SUM(X16:Y16)","v":{"$error":"#DIV/0!"}},{"$f":"V16-W16+Z16","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(AA16/G16,0)","v":0},{"$f":"G16+AA16","v":{"$error":"#DIV/0!"}},0,{"$f":"AA16-AD16","v":{"$error":"#DIV/0!"}},null,null,18000,null,"حمدان عبد السميع محمود عبد الله",{"$f":"ROUND(AA16,2)","v":{"$error":"#DIV/0!"}},20016,"NBEGEGCXXXX"]
[2,"Hossam Abdo Saif Eldein Mohamed Elmekawy",20135,"Indirect","Head Office","Accountant Manager",null,10,{"$f":"IF(AND(H17>0,H17<=3),4%,IF(AND(H17>3,H17<=6),8%,IF(AND(H17>6,H17<=9),10%,IF(AND(H17>9,H17<=11),12%,IF(AND(H17>11,H17<=13),16%)))))","v":0.12},{"$f":"DAYS360(K17,TODAY(),1)","v":"1917-05-04"},"2001-12-01",{"$f":"IFERROR(G17*$H$5,0)","v":0},{"$f":"IF(G17>=1,$G$5,0)","v":0},0,0,{"$f":"M17-O17","v":0},"Deserved",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$f":"S17+T17","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"V17*10%","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},0,{"$f":"SUM(X17:Y17)","v":{"$error":"#DIV/0!"}},{"$f":"V17-W17+Z17","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},0,{"$f":"AA17-AD17","v":{"$error":"#DIV/0!"}},null,null,"0163","1635000183865400012","حسام عبده سيف الدين محمد المكاوى",{"$f":"ROUND(AA17,2)","v":{"$error":"#DIV/0!"}},20135,"NBEGEGCXXXX"]
[3,"Tamer Gamal Fayed Habib",20257,"Indirect","Head Office","Chief Accountant",null,10,0.12,"1915-02-13","2004-03-02",0,0,0,0,0,"Deserved",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},null,null,"0180","1805010141198000012","تامر جمال فايد حبيب",{"$error":"#DIV/0!"},20257,"NBEGEGCXXXX"]
[4,"Wael Mohamed Sabry Ibrahim Mohamed Hassan",20770,"Indirect","Head Office","OFFICE BOY ",null,4,0.08,"1912-06-29","2006-11-01",0,0,0,0,0,"Deserved",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},null,null,18000,null,"وائل محمد صبرى ابراهيم محمد حسن",{"$error":"#DIV/0!"},20770,"NBEGEGCXXXX"]
[5,"Islam Magdy Abdullah Abd Elsamiea",20975,"Indirect","Head Office","Assistant Purchasing Manager",null,10,0.12,"1911-05-14","2007-12-23",0,0,0,0,0,"Undeserved",{"$error":"#DIV/0!"},0,0,0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},null,null,18000,null,"اسلام مجدى عبد الله عبد السميع",{"$error":"#DIV/0!"},20975,"NBEGEGCXXXX"]
[6,"Salim Abdul Karim Sayed Elaslampolly",20497,"Indirect","Head Office","Purchasing Supervisor",null,9,0.1,"1913-07-31","2005-09-24",0,0,0,0,0,"Deserved",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},null,null,"0180","1805000912326301013","سليم عبد الكريم سيد الاسلامبولى",{"$error":"#DIV/0!"},20497,"NBEGEGCXXXX"]
[7,"Ahmed Wagih Ibahim Abbass",22017,"Indirect","Head Office","Senior Accountant Supervisor",null,9,0.1,"1905-10-04","2013-09-01",0,0,0,0,0,"Deserved",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},null,null,"0176","1765000749334400018","احمد وجيه ابراهيم عباس",{"$error":"#DIV/0!"},22017,"NBEGEGCXXXX"]
[8,"Mohamed Ali Mohamed Ali",22084,"Indirect","Head Office","HR Specialist",null,8,0.1,"1905-04-15","2014-02-23",0,0,0,0,0,"Deserved",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},null,null,18000,null,"محمد على محمد على",{"$error":"#DIV/0!"},22084,"NBEGEGCXXXX"]
[9,"Thabet Mohamed Abd Elnaby Hasnein",20007,"Indirect","Head Office","District Manager",null,11,0.12,"1918-09-26","2000-07-01",0,0,0,0,0,"Deserved",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},null,null,18000,null,"ثابت محمد عبد النبى حسانين",{"$error":"#DIV/0!"},20007,"NBEGEGCXXXX"]
[10,"Alaa Ibrahim Mohamed Mabrouk",21989,"Indirect","ALL RES.","Store Keeper",null,7,0.1,"1905-12-03","2013-07-01",0,0,0,0,0,"Deserved",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},null,null,18000,null,"علاء ابراهيم محمد مبروك",{"$error":"#DIV/0!"},21989,"NBEGEGCXXXX"]
[11,"Ahmed Ezz El Din Mohamed Ahmad",30003,"Indirect","Head Office","Country Manager",null,12,0.16,"1912-05-01","2006-12-30",0,0,0,0,0,"Deserved",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},null,null,"0187","1875000071624800019","احمد عز الدين محمد احمد",{"$error":"#DIV/0!"},30003,"NBEGEGCXXXX"]
[12,"Abdul Rahman El Husseini Elsayed Mohamed",22210,"Indirect","ALL RES.","Maintenance Specialist",null,7,0.1,"1904-09-09","2014-10-01",0,0,0,0,0,"Deserved",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},null,null,18000,null,"عبد الرحمن الحسينى السيد محمد",{"$error":"#DIV/0!"},22210,"NBEGEGCXXXX"]
[13,"Mohamed Husain Abd Elazem Ahmed",22599,"Indirect","ALL RES.","Maintenance Specialist",null,7,0.1,"1903-05-19","2016-01-30",0,0,0,0,0,"Deserved",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},null,null,"18000",null,"محمد حسين عبد العظيم احمد",{"$error":"#DIV/0!"},22599,"NBEGEGCXXXX"]
[14,"Alaa Jamal Elsayed Shahine",21913,"Indirect","Head Office","Admin Assistant",null,4,0.08,"1906-04-02","2013-03-01",0,0,0,0,0,"Undeserved",{"$error":"#DIV/0!"},0,0,0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},null,null,18000,null,"الاء جمال السيد شاهين",{"$error":"#DIV/0!"},21913,"NBEGEGCXXXX"]
["Total",null,null,null,null,null,{"$f":"SUBTOTAL(9,G16:G29)","v":0},null,null,null,null,{"$f":"SUBTOTAL(9,L16:L29)","v":0},{"$f":"SUBTOTAL(9,M16:M29)","v":0},{"$f":"SUBTOTAL(9,N16:N29)","v":0},{"$f":"SUBTOTAL(9,O16:O29)","v":0},{"$f":"SUBTOTAL(9,P16:P29)","v":0},null,{"$f":"SUBTOTAL(9,R16:R29)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUBTOTAL(9,AC16:AC29)","v":{"$error":"#DIV/0!"}},{"$f":"SUBTOTAL(9,AD16:AD29)","v":0},{"$f":"SUBTOTAL(9,AE16:AE29)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,{"$f":"SUBTOTAL(9,AK16:AK29)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AA30+'Direct 60%'!AB106","v":{"$error":"#DIV/0!"}}]

{"sheet":"Payslip","index":3,"n_rows":188,"n_cols":22,"rows_kept":188,"cut":false,"hidden":false,"merged":[[23,12,23,16],[24,10,25,11],[25,12,25,16],[18,9,19,12],[18,13,19,13],[18,14,19,14],[18,15,19,16],[20,9,21,16],[22,9,23,10],[22,11,23,11],[9,16,10,16],[16,9,17,12],[16,13,17,14],[5,9,8,14],[9,9,10,14],[9,15,10,15],[12,9,12,11],[12,12,12,14],[14,9,14,11],[14,12,14,13],[14,15,14,16]]}
["#","Employee Name","Employee ID","Division / Department","Job Description","Service Charge (12%) Amount (Net)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(A2:A188)","v":8},{"$f":"MAX(مرجع)","v":8}]
[{"$f":"IF(B2=0,\"\",1)","v":1},{"$f":"'Direct 60%'!B16","v":"aaaa1"},{"$f":"'Direct 60%'!C16","v":20426},{"$f":"'Direct 60%'!E16","v":"Mohandseen Managers"},{"$f":"'Direct 60%'!F16","v":"Assistant Manager"},{"$f":"'Direct 60%'!AQ16","v":911.09},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V1","v":8}]
[{"$f":"IF(B3=0,\"\",MAX($A$1:A2)+1)","v":2},{"$f":"'Direct 60%'!B17","v":"aaaa2"},{"$f":"'Direct 60%'!C17","v":22855},{"$f":"'Direct 60%'!E17","v":"Mohandseen Managers"},{"$f":"'Direct 60%'!F17","v":"Resturant Manager"},{"$f":"'Direct 60%'!AQ17","v":1104.9100000000001}]
[{"$f":"IF(B4=0,\"\",MAX($A$1:A3)+1)","v":3},{"$f":"'Direct 60%'!B18","v":"aaaa3"},{"$f":"'Direct 60%'!C18","v":22898},{"$f":"'Direct 60%'!E18","v":"Mohandseen Managers"},{"$f":"'Direct 60%'!F18","v":"Assistant Manager"},{"$f":"'Direct 60%'!AQ18","v":986.33},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[{"$f":"IF(B5=0,\"\",MAX($A$1:A4)+1)","v":4},{"$f":"'Direct 60%'!B19","v":"aaaa4"},{"$f":"'Direct 60%'!C19","v":0},{"$f":"'Direct 60%'!E19","v":"Mohandssen"},{"$f":"'Direct 60%'!F19","v":"Security"},{"$f":"'Direct 60%'!AQ19","v":1432.84},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$V$2","v":8}]
[{"$f":"IF(B6=0,\"\",MAX($A$1:A5)+1)","v":5},{"$f":"'Direct 60%'!B20","v":"aaaa5"},{"$f":"'Direct 60%'!C20","v":20270},{"$f":"'Direct 60%'!E20","v":"Mohandssen"},{"$f":"'Direct 60%'!F20","v":"C.T - Prep"},{"$f":"'Direct 60%'!AQ20","v":1937.48}]
[{"$f":"IF(B7=0,\"\",MAX($A$1:A6)+1)","v":6},{"$f":"'Direct 60%'!B21","v":"aaaa6"},{"$f":"'Direct 60%'!C21","v":22140},{"$f":"'Direct 60%'!E21","v":"Mohandssen"},{"$f":"'Direct 60%'!F21","v":"Food Server"},{"$f":"'Direct 60%'!AQ21","v":1538.42},null,{"$f":"$V$4","v":1}]
[{"$f":"IF(B8=0,\"\",MAX($A$1:A7)+1)","v":7},{"$f":"'Direct 60%'!B22","v":"aaaa7"},{"$f":"'Direct 60%'!C22","v":22612},{"$f":"'Direct 60%'!E22","v":"Mohandssen"},{"$f":"'Direct 60%'!F22","v":"Baker"},{"$f":"'Direct 60%'!AQ22","v":1450.48}]
[{"$f":"IF(B9=0,\"\",MAX($A$1:A8)+1)","v":8},{"$f":"'Direct 60%'!B23","v":"aaaa8"},{"$f":"'Direct 60%'!C23","v":22773},{"$f":"'Direct 60%'!E23","v":"Mohandssen"},{"$f":"'Direct 60%'!F23","v":"Cook"},{"$f":"'Direct 60%'!AQ23","v":1450.71}]
[{"$f":"IF(B10=0,\"\",MAX($A$1:A9)+1)","v":""},{"$f":"'Direct 60%'!B24","v":0},{"$f":"'Direct 60%'!C24","v":22814},{"$f":"'Direct 60%'!E24","v":"Mohandssen"},{"$f":"'Direct 60%'!F24","v":"Dishwaser"},{"$f":"'Direct 60%'!AQ24","v":1372.85},null,null,null,"Acknowledgment of receipt for Service charge 12 %",null,null,null,null,null,"June",2019]
[{"$f":"IF(B11=0,\"\",MAX($A$1:A10)+1)","v":""},{"$f":"'Direct 60%'!B25","v":0},{"$f":"'Direct 60%'!C25","v":20488},{"$f":"'Direct 60%'!E25","v":"Mohandssen"},{"$f":"'Direct 60%'!F25","v":"Prep"},{"$f":"'Direct 60%'!AQ25","v":1836.31}]
[{"$f":"IF(B12=0,\"\",MAX($A$1:A11)+1)","v":""},{"$f":"'Direct 60%'!B26","v":0},{"$f":"'Direct 60%'!C26","v":21248},{"$f":"'Direct 60%'!E26","v":"Mohandssen"},{"$f":"'Direct 60%'!F26","v":"Food Server"},{"$f":"'Direct 60%'!AQ26","v":1667.56}]
[{"$f":"IF(B13=0,\"\",MAX($A$1:A12)+1)","v":""},{"$f":"'Direct 60%'!B27","v":0},{"$f":"'Direct 60%'!C27","v":22172},{"$f":"'Direct 60%'!E27","v":"Mohandssen"},{"$f":"'Direct 60%'!F27","v":"Food Server"},{"$f":"'Direct 60%'!AQ27","v":1538.42},null,null,null,"Employee Name :",null,null,{"$f":"IF(ISERROR(VLOOKUP($H$7,بيانات1,2,0)),\"\",VLOOKUP($H$7,بيانات1,2,0))","v":"aaaa1"},null,null,"ID :",{"$f":"VLOOKUP(M13,$B$2:$F$188,2,FALSE)","v":20426}]
[{"$f":"IF(B14=0,\"\",MAX($A$1:A13)+1)","v":""},{"$f":"'Direct 60%'!B28","v":0},{"$f":"'Direct 60%'!C28","v":22912},{"$f":"'Direct 60%'!E28","v":"Mohandssen"},{"$f":"'Direct 60%'!F28","v":"Food Server"},{"$f":"'Direct 60%'!AQ28","v":1381.48}]
[{"$f":"IF(B15=0,\"\",MAX($A$1:A14)+1)","v":""},{"$f":"'Direct 60%'!B29","v":0},{"$f":"'Direct 60%'!C29","v":22922},{"$f":"'Direct 60%'!E29","v":"Mohandssen"},{"$f":"'Direct 60%'!F29","v":"Cook"},{"$f":"'Direct 60%'!AQ29","v":1406.61},null,null,null,"Job Title :",null,null,{"$f":"VLOOKUP(M13,$B$2:$F$188,4,FALSE)","v":"Assistant Manager"},null,"Branch",{"$f":"VLOOKUP(M13,$B$2:$F$188,3,FALSE)","v":"Mohandseen Managers"}]
[{"$f":"IF(B16=0,\"\",MAX($A$1:A15)+1)","v":""},{"$f":"'Direct 60%'!B30","v":0},{"$f":"'Direct 60%'!C30","v":20103},{"$f":"'Direct 60%'!E30","v":"Maadi Managers"},{"$f":"'Direct 60%'!F30","v":"S R .Assistant Manager"},{"$f":"'Direct 60%'!AQ30","v":1642.57}]
[{"$f":"IF(B17=0,\"\",MAX($A$1:A16)+1)","v":""},{"$f":"'Direct 60%'!B31","v":0},{"$f":"'Direct 60%'!C31","v":30021},{"$f":"'Direct 60%'!E31","v":"Maadi Managers"},{"$f":"'Direct 60%'!F31","v":"S R .Assistant Manager"},{"$f":"'Direct 60%'!AQ31","v":1680.21},null,null,null,"Net amount of :",null,null,null,{"$f":"VLOOKUP(M13,$B$2:$F$188,5,FALSE)","v":911.09}]
[{"$f":"IF(B18=0,\"\",MAX($A$1:A17)+1)","v":""},{"$f":"'Direct 60%'!B32","v":0},{"$f":"'Direct 60%'!C32","v":20161},{"$f":"'Direct 60%'!E32","v":"Maadi Managers"},{"$f":"'Direct 60%'!F32","v":"Assistant Manager"},{"$f":"'Direct 60%'!AQ32","v":1453.46}]
[{"$f":"IF(B19=0,\"\",MAX($A$1:A18)+1)","v":""},{"$f":"'Direct 60%'!B33","v":0},{"$f":"'Direct 60%'!C33","v":20156},{"$f":"'Direct 60%'!E33","v":"Maadi"},{"$f":"'Direct 60%'!F33","v":"Security"},{"$f":"'Direct 60%'!AQ33","v":1906.94},null,null,null,"In exchange for :",null,null,null,{"$f":"P10","v":"June"},{"$f":"Q10","v":2019},"Service charge 12%"]
[{"$f":"IF(B20=0,\"\",MAX($A$1:A19)+1)","v":""},{"$f":"'Direct 60%'!B34","v":0},{"$f":"'Direct 60%'!C34","v":21286},{"$f":"'Direct 60%'!E34","v":"Maadi"},{"$f":"'Direct 60%'!F34","v":"C.T - Food Server"},{"$f":"'Direct 60%'!AQ34","v":2125.65}]
[{"$f":"IF(B21=0,\"\",MAX($A$1:A20)+1)","v":""},{"$f":"'Direct 60%'!B35","v":0},{"$f":"'Direct 60%'!C35","v":21667},{"$f":"'Direct 60%'!E35","v":"Maadi"},{"$f":"'Direct 60%'!F35","v":"Food Server"},{"$f":"'Direct 60%'!AQ35","v":1967.25},null,null,null,"From Arabian Food Supplies Co. - Finance Department"]
[{"$f":"IF(B22=0,\"\",MAX($A$1:A21)+1)","v":""},{"$f":"'Direct 60%'!B36","v":0},{"$f":"'Direct 60%'!C36","v":22382},{"$f":"'Direct 60%'!E36","v":"Maadi"},{"$f":"'Direct 60%'!F36","v":"Prep"},{"$f":"'Direct 60%'!AQ36","v":1947.26}]
[{"$f":"IF(B23=0,\"\",MAX($A$1:A22)+1)","v":""},{"$f":"'Direct 60%'!B37","v":0},{"$f":"'Direct 60%'!C37","v":22389},{"$f":"'Direct 60%'!E37","v":"Maadi"},{"$f":"'Direct 60%'!F37","v":"Baker"},{"$f":"'Direct 60%'!AQ37","v":1940.62},null,null,null,"Declared by :",null,"Name :"]
[{"$f":"IF(B24=0,\"\",MAX($A$1:A23)+1)","v":""},{"$f":"'Direct 60%'!B38","v":0},{"$f":"'Direct 60%'!C38","v":22753},{"$f":"'Direct 60%'!E38","v":"Maadi"},{"$f":"'Direct 60%'!F38","v":"Cook"},{"$f":"'Direct 60%'!AQ38","v":1815.87},null,null,null,null,null,null,"…......................................................................................"]
[{"$f":"IF(B25=0,\"\",MAX($A$1:A24)+1)","v":""},{"$f":"'Direct 60%'!B39","v":0},{"$f":"'Direct 60%'!C39","v":22837},{"$f":"'Direct 60%'!E39","v":"Maadi"},{"$f":"'Direct 60%'!F39","v":"Prep"},{"$f":"'Direct 60%'!AQ39","v":1842.18},null,null,null,null,"Signature :"]
[{"$f":"IF(B26=0,\"\",MAX($A$1:A25)+1)","v":""},{"$f":"'Direct 60%'!B40","v":0},{"$f":"'Direct 60%'!C40","v":22838},{"$f":"'Direct 60%'!E40","v":"Maadi"},{"$f":"'Direct 60%'!F40","v":"Prep"},{"$f":"'Direct 60%'!AQ40","v":1837.29},null,null,null,null,null,null,"…......................................................................................"]
[{"$f":"IF(B27=0,\"\",MAX($A$1:A26)+1)","v":""},{"$f":"'Direct 60%'!B41","v":0},{"$f":"'Direct 60%'!C41","v":22839},{"$f":"'Direct 60%'!E41","v":"Maadi"},{"$f":"'Direct 60%'!F41","v":"Hostess"},{"$f":"'Direct 60%'!AQ41","v":1793.04}]
[{"$f":"IF(B28=0,\"\",MAX($A$1:A27)+1)","v":""},{"$f":"'Direct 60%'!B42","v":0},{"$f":"'Direct 60%'!C42","v":22857},{"$f":"'Direct 60%'!E42","v":"Maadi"},{"$f":"'Direct 60%'!F42","v":"Food Server"},{"$f":"'Direct 60%'!AQ42","v":1631.63}]
[{"$f":"IF(B29=0,\"\",MAX($A$1:A28)+1)","v":""},{"$f":"'Direct 60%'!B43","v":0},{"$f":"'Direct 60%'!C43","v":22889},{"$f":"'Direct 60%'!E43","v":"Maadi"},{"$f":"'Direct 60%'!F43","v":"Hostess"},{"$f":"'Direct 60%'!AQ43","v":1743.06}]
[{"$f":"IF(B30=0,\"\",MAX($A$1:A29)+1)","v":""},{"$f":"'Direct 60%'!B44","v":0},{"$f":"'Direct 60%'!C44","v":22906},{"$f":"'Direct 60%'!E44","v":"Maadi"},{"$f":"'Direct 60%'!F44","v":"Dishwaser"},{"$f":"'Direct 60%'!AQ44","v":1689.58}]
[{"$f":"IF(B31=0,\"\",MAX($A$1:A30)+1)","v":""},{"$f":"'Direct 60%'!B45","v":0},{"$f":"'Direct 60%'!C45","v":20490},{"$f":"'Direct 60%'!E45","v":"Maadi"},{"$f":"'Direct 60%'!F45","v":"C.T - Cook"},{"$f":"'Direct 60%'!AQ45","v":2498.81}]
[{"$f":"IF(B32=0,\"\",MAX($A$1:A31)+1)","v":""},{"$f":"'Direct 60%'!B46","v":0},{"$f":"'Direct 60%'!C46","v":22914},{"$f":"'Direct 60%'!E46","v":"Maadi"},{"$f":"'Direct 60%'!F46","v":"Dishwaser"},{"$f":"'Direct 60%'!AQ46","v":246.52}]
[{"$f":"IF(B33=0,\"\",MAX($A$1:A32)+1)","v":""},{"$f":"'Direct 60%'!B47","v":0},{"$f":"'Direct 60%'!C47","v":20075},{"$f":"'Direct 60%'!E47","v":"City Stars Managers"},{"$f":"'Direct 60%'!F47","v":"S R .Assistant Manager"},{"$f":"'Direct 60%'!AQ47","v":4938.3599999999997}]
[{"$f":"IF(B34=0,\"\",MAX($A$1:A33)+1)","v":""},{"$f":"'Direct 60%'!B48","v":0},{"$f":"'Direct 60%'!C48","v":20060},{"$f":"'Direct 60%'!E48","v":"City Stars Managers"},{"$f":"'Direct 60%'!F48","v":"S R .Assistant Manager"},{"$f":"'Direct 60%'!AQ48","v":4938.3599999999997}]
[{"$f":"IF(B35=0,\"\",MAX($A$1:A34)+1)","v":""},{"$f":"'Direct 60%'!B49","v":0},{"$f":"'Direct 60%'!C49","v":21716},{"$f":"'Direct 60%'!E49","v":"City Stars Managers"},{"$f":"'Direct 60%'!F49","v":"S R .Assistant Manager"},{"$f":"'Direct 60%'!AQ49","v":4353.79}]
[{"$f":"IF(B36=0,\"\",MAX($A$1:A35)+1)","v":""},{"$f":"'Direct 60%'!B50","v":0},{"$f":"'Direct 60%'!C50","v":21162},{"$f":"'Direct 60%'!E50","v":"City Stars"},{"$f":"'Direct 60%'!F50","v":"Store Keeper"},{"$f":"'Direct 60%'!AQ50","v":3796.09}]
[{"$f":"IF(B37=0,\"\",MAX($A$1:A36)+1)","v":""},{"$f":"'Direct 60%'!B51","v":0},{"$f":"'Direct 60%'!C51","v":21554},{"$f":"'Direct 60%'!E51","v":"City Stars"},{"$f":"'Direct 60%'!F51","v":"C.T - Cook"},{"$f":"'Direct 60%'!AQ51","v":4181.5}]
[{"$f":"IF(B38=0,\"\",MAX($A$1:A37)+1)","v":""},{"$f":"'Direct 60%'!B52","v":0},{"$f":"'Direct 60%'!C52","v":30168},{"$f":"'Direct 60%'!E52","v":"City Stars"},{"$f":"'Direct 60%'!F52","v":"C.T - Food Server"},{"$f":"'Direct 60%'!AQ52","v":3986.55}]
[{"$f":"IF(B39=0,\"\",MAX($A$1:A38)+1)","v":""},{"$f":"'Direct 60%'!B53","v":0},{"$f":"'Direct 60%'!C53","v":30277},{"$f":"'Direct 60%'!E53","v":"City Stars"},{"$f":"'Direct 60%'!F53","v":"C.T - Cook"},{"$f":"'Direct 60%'!AQ53","v":3939.96}]
[{"$f":"IF(B40=0,\"\",MAX($A$1:A39)+1)","v":""},{"$f":"'Direct 60%'!B54","v":0},{"$f":"'Direct 60%'!C54","v":22022},{"$f":"'Direct 60%'!E54","v":"City Stars"},{"$f":"'Direct 60%'!F54","v":"Food Server"},{"$f":"'Direct 60%'!AQ54","v":3535.85}]
[{"$f":"IF(B41=0,\"\",MAX($A$1:A40)+1)","v":""},{"$f":"'Direct 60%'!B55","v":0},{"$f":"'Direct 60%'!C55","v":22066},{"$f":"'Direct 60%'!E55","v":"City Stars"},{"$f":"'Direct 60%'!F55","v":"Hostess"},{"$f":"'Direct 60%'!AQ55","v":3521.65}]
[{"$f":"IF(B42=0,\"\",MAX($A$1:A41)+1)","v":""},{"$f":"'Direct 60%'!B56","v":0},{"$f":"'Direct 60%'!C56","v":22201},{"$f":"'Direct 60%'!E56","v":"City Stars"},{"$f":"'Direct 60%'!F56","v":"C.T - Baker"},{"$f":"'Direct 60%'!AQ56","v":3314.94}]
[{"$f":"IF(B43=0,\"\",MAX($A$1:A42)+1)","v":""},{"$f":"'Direct 60%'!B57","v":0},{"$f":"'Direct 60%'!C57","v":22448},{"$f":"'Direct 60%'!E57","v":"City Stars"},{"$f":"'Direct 60%'!F57","v":"Cook"},{"$f":"'Direct 60%'!AQ57","v":3481.49}]
[{"$f":"IF(B44=0,\"\",MAX($A$1:A43)+1)","v":""},{"$f":"'Direct 60%'!B58","v":0},{"$f":"'Direct 60%'!C58","v":40004},{"$f":"'Direct 60%'!E58","v":"City Stars"},{"$f":"'Direct 60%'!F58","v":"C.T - Cook"},{"$f":"'Direct 60%'!AQ58","v":4304.43}]
[{"$f":"IF(B45=0,\"\",MAX($A$1:A44)+1)","v":""},{"$f":"'Direct 60%'!B59","v":0},{"$f":"'Direct 60%'!C59","v":20127},{"$f":"'Direct 60%'!E59","v":"City Stars"},{"$f":"'Direct 60%'!F59","v":"C.T - Prep"},{"$f":"'Direct 60%'!AQ59","v":4528.82}]
[{"$f":"IF(B46=0,\"\",MAX($A$1:A45)+1)","v":""},{"$f":"'Direct 60%'!B60","v":0},{"$f":"'Direct 60%'!C60","v":20646},{"$f":"'Direct 60%'!E60","v":"City Stars"},{"$f":"'Direct 60%'!F60","v":"C.T - Prep"},{"$f":"'Direct 60%'!AQ60","v":4345.26}]
[{"$f":"IF(B47=0,\"\",MAX($A$1:A46)+1)","v":""},{"$f":"'Direct 60%'!B61","v":0},{"$f":"'Direct 60%'!C61","v":22770},{"$f":"'Direct 60%'!E61","v":"City Stars"},{"$f":"'Direct 60%'!F61","v":"Food Server"},{"$f":"'Direct 60%'!AQ61","v":3269.83}]
[{"$f":"IF(B48=0,\"\",MAX($A$1:A47)+1)","v":""},{"$f":"'Direct 60%'!B62","v":0},{"$f":"'Direct 60%'!C62","v":21260},{"$f":"'Direct 60%'!E62","v":"City Stars"},{"$f":"'Direct 60%'!F62","v":"C.T - Food Server"},{"$f":"'Direct 60%'!AQ62","v":4034.04}]
[{"$f":"IF(B49=0,\"\",MAX($A$1:A48)+1)","v":""},{"$f":"'Direct 60%'!B63","v":0},{"$f":"'Direct 60%'!C63","v":22831},{"$f":"'Direct 60%'!E63","v":"City Stars"},{"$f":"'Direct 60%'!F63","v":"Hostess"},{"$f":"'Direct 60%'!AQ63","v":3243.32}]
[{"$f":"IF(B50=0,\"\",MAX($A$1:A49)+1)","v":""},{"$f":"'Direct 60%'!B64","v":0},{"$f":"'Direct 60%'!C64","v":22844},{"$f":"'Direct 60%'!E64","v":"City Stars"},{"$f":"'Direct 60%'!F64","v":"Food Server"},{"$f":"'Direct 60%'!AQ64","v":3269.83}]
[{"$f":"IF(B51=0,\"\",MAX($A$1:A50)+1)","v":""},{"$f":"'Direct 60%'!B65","v":0},{"$f":"'Direct 60%'!C65","v":20095},{"$f":"'Direct 60%'!E65","v":"City Stars"},{"$f":"'Direct 60%'!F65","v":"Cook"},{"$f":"'Direct 60%'!AQ65","v":4299.12}]
[{"$f":"IF(B52=0,\"\",MAX($A$1:A51)+1)","v":""},{"$f":"'Direct 60%'!B66","v":0},{"$f":"'Direct 60%'!C66","v":22767},{"$f":"'Direct 60%'!E66","v":"City Stars"},{"$f":"'Direct 60%'!F66","v":"Host"},{"$f":"'Direct 60%'!AQ66","v":231.81}]
[{"$f":"IF(B53=0,\"\",MAX($A$1:A52)+1)","v":""},{"$f":"'Direct 60%'!B67","v":0},{"$f":"'Direct 60%'!C67","v":22163},{"$f":"'Direct 60%'!E67","v":"City Stars"},{"$f":"'Direct 60%'!F67","v":"Food Server"},{"$f":"'Direct 60%'!AQ67","v":910.86}]
[{"$f":"IF(B54=0,\"\",MAX($A$1:A53)+1)","v":""},{"$f":"'Direct 60%'!B68","v":0},{"$f":"'Direct 60%'!C68","v":22443},{"$f":"'Direct 60%'!E68","v":"City Stars"},{"$f":"'Direct 60%'!F68","v":"Food Server"},{"$f":"'Direct 60%'!AQ68","v":3370.74}]
[{"$f":"IF(B55=0,\"\",MAX($A$1:A54)+1)","v":""},{"$f":"'Direct 60%'!B69","v":0},{"$f":"'Direct 60%'!C69","v":22909},{"$f":"'Direct 60%'!E69","v":"City Stars"},{"$f":"'Direct 60%'!F69","v":"Cook"},{"$f":"'Direct 60%'!AQ69","v":2867.72}]
[{"$f":"IF(B56=0,\"\",MAX($A$1:A55)+1)","v":""},{"$f":"'Direct 60%'!B70","v":0},{"$f":"'Direct 60%'!C70","v":22155},{"$f":"'Direct 60%'!E70","v":"City Stars"},{"$f":"'Direct 60%'!F70","v":"Cook"},{"$f":"'Direct 60%'!AQ70","v":3481.23}]
[{"$f":"IF(B57=0,\"\",MAX($A$1:A56)+1)","v":""},{"$f":"'Direct 60%'!B71","v":0},{"$f":"'Direct 60%'!C71","v":22862},{"$f":"'Direct 60%'!E71","v":"City Stars"},{"$f":"'Direct 60%'!F71","v":"Food Server"},{"$f":"'Direct 60%'!AQ71","v":3203.4}]
[{"$f":"IF(B58=0,\"\",MAX($A$1:A57)+1)","v":""},{"$f":"'Direct 60%'!B72","v":0},{"$f":"'Direct 60%'!C72","v":40001},{"$f":"'Direct 60%'!E72","v":"MOA Managers"},{"$f":"'Direct 60%'!F72","v":"S R .Assistant Manager"},{"$f":"'Direct 60%'!AQ72","v":2242.59}]
[{"$f":"IF(B59=0,\"\",MAX($A$1:A58)+1)","v":""},{"$f":"'Direct 60%'!B73","v":0},{"$f":"'Direct 60%'!C73","v":20010},{"$f":"'Direct 60%'!E73","v":"MOA Managers"},{"$f":"'Direct 60%'!F73","v":"Resturant Manager"},{"$f":"'Direct 60%'!AQ73","v":2539.0500000000002}]
[{"$f":"IF(B60=0,\"\",MAX($A$1:A59)+1)","v":""},{"$f":"'Direct 60%'!B74","v":0},{"$f":"'Direct 60%'!C74","v":22506},{"$f":"'Direct 60%'!E74","v":"MOA Managers"},{"$f":"'Direct 60%'!F74","v":"S R .Assistant Manager"},{"$f":"'Direct 60%'!AQ74","v":1987.76}]
[{"$f":"IF(B61=0,\"\",MAX($A$1:A60)+1)","v":""},{"$f":"'Direct 60%'!B75","v":0},{"$f":"'Direct 60%'!C75","v":20012},{"$f":"'Direct 60%'!E75","v":"MOA"},{"$f":"'Direct 60%'!F75","v":"C.T - Cook"},{"$f":"'Direct 60%'!AQ75","v":3331.48}]
[{"$f":"IF(B62=0,\"\",MAX($A$1:A61)+1)","v":""},{"$f":"'Direct 60%'!B76","v":0},{"$f":"'Direct 60%'!C76","v":20113},{"$f":"'Direct 60%'!E76","v":"MOA"},{"$f":"'Direct 60%'!F76","v":"C.T - Prep"},{"$f":"'Direct 60%'!AQ76","v":3324.45}]
[{"$f":"IF(B63=0,\"\",MAX($A$1:A62)+1)","v":""},{"$f":"'Direct 60%'!B77","v":0},{"$f":"'Direct 60%'!C77","v":21517},{"$f":"'Direct 60%'!E77","v":"MOA"},{"$f":"'Direct 60%'!F77","v":"Food Server"},{"$f":"'Direct 60%'!AQ77","v":2793.68}]
[{"$f":"IF(B64=0,\"\",MAX($A$1:A63)+1)","v":""},{"$f":"'Direct 60%'!B78","v":0},{"$f":"'Direct 60%'!C78","v":22581},{"$f":"'Direct 60%'!E78","v":"MOA"},{"$f":"'Direct 60%'!F78","v":"Cook"},{"$f":"'Direct 60%'!AQ78","v":2653.86}]
[{"$f":"IF(B65=0,\"\",MAX($A$1:A64)+1)","v":""},{"$f":"'Direct 60%'!B79","v":0},{"$f":"'Direct 60%'!C79","v":22585},{"$f":"'Direct 60%'!E79","v":"MOA"},{"$f":"'Direct 60%'!F79","v":"Food Server"},{"$f":"'Direct 60%'!AQ79","v":2450.0700000000002}]
[{"$f":"IF(B66=0,\"\",MAX($A$1:A65)+1)","v":""},{"$f":"'Direct 60%'!B80","v":0},{"$f":"'Direct 60%'!C80","v":20699},{"$f":"'Direct 60%'!E80","v":"MOA"},{"$f":"'Direct 60%'!F80","v":"C.T - Food Server"},{"$f":"'Direct 60%'!AQ80","v":3085.41}]
[{"$f":"IF(B67=0,\"\",MAX($A$1:A66)+1)","v":""},{"$f":"'Direct 60%'!B81","v":0},{"$f":"'Direct 60%'!C81","v":22872},{"$f":"'Direct 60%'!E81","v":"MOA"},{"$f":"'Direct 60%'!F81","v":"Dishwaser"},{"$f":"'Direct 60%'!AQ81","v":2345.4}]
[{"$f":"IF(B68=0,\"\",MAX($A$1:A67)+1)","v":""},{"$f":"'Direct 60%'!B82","v":0},{"$f":"'Direct 60%'!C82","v":21236},{"$f":"'Direct 60%'!E82","v":"MOA"},{"$f":"'Direct 60%'!F82","v":"C.T - Food Server"},{"$f":"'Direct 60%'!AQ82","v":2863.75}]
[{"$f":"IF(B69=0,\"\",MAX($A$1:A68)+1)","v":""},{"$f":"'Direct 60%'!B83","v":0},{"$f":"'Direct 60%'!C83","v":22894},{"$f":"'Direct 60%'!E83","v":"MOA"},{"$f":"'Direct 60%'!F83","v":"Cook"},{"$f":"'Direct 60%'!AQ83","v":2436.44}]
[{"$f":"IF(B70=0,\"\",MAX($A$1:A69)+1)","v":""},{"$f":"'Direct 60%'!B84","v":0},{"$f":"'Direct 60%'!C84","v":21559},{"$f":"'Direct 60%'!E84","v":"MOA"},{"$f":"'Direct 60%'!F84","v":"C.T - Cook"},{"$f":"'Direct 60%'!AQ84","v":2880.92}]
[{"$f":"IF(B71=0,\"\",MAX($A$1:A70)+1)","v":""},{"$f":"'Direct 60%'!B85","v":0},{"$f":"'Direct 60%'!C85","v":22854},{"$f":"'Direct 60%'!E85","v":"MOA"},{"$f":"'Direct 60%'!F85","v":"Food Server"},{"$f":"'Direct 60%'!AQ85","v":2546.87}]
[{"$f":"IF(B72=0,\"\",MAX($A$1:A71)+1)","v":""},{"$f":"'Direct 60%'!B86","v":0},{"$f":"'Direct 60%'!C86","v":22917},{"$f":"'Direct 60%'!E86","v":"MOA"},{"$f":"'Direct 60%'!F86","v":"Cook"},{"$f":"'Direct 60%'!AQ86","v":2436.77}]
[{"$f":"IF(B73=0,\"\",MAX($A$1:A72)+1)","v":""},{"$f":"'Direct 60%'!B87","v":0},{"$f":"'Direct 60%'!C87","v":22921},{"$f":"'Direct 60%'!E87","v":"MOA"},{"$f":"'Direct 60%'!F87","v":"Dishwaser"},{"$f":"'Direct 60%'!AQ87","v":2345.67}]
[{"$f":"IF(B74=0,\"\",MAX($A$1:A73)+1)","v":""},{"$f":"'Direct 60%'!B88","v":0},{"$f":"'Direct 60%'!C88","v":22916},{"$f":"'Direct 60%'!E88","v":"MOA"},{"$f":"'Direct 60%'!F88","v":"Cook"},{"$f":"'Direct 60%'!AQ88","v":685.32}]
[{"$f":"IF(B75=0,\"\",MAX($A$1:A74)+1)","v":""},{"$f":"'Direct 60%'!B89","v":0},{"$f":"'Direct 60%'!C89","v":20112},{"$f":"'Direct 60%'!E89","v":"Concord Managers"},{"$f":"'Direct 60%'!F89","v":"S R .Assistant Manager"},{"$f":"'Direct 60%'!AQ89","v":2679.95}]
[{"$f":"IF(B76=0,\"\",MAX($A$1:A75)+1)","v":""},{"$f":"'Direct 60%'!B90","v":0},{"$f":"'Direct 60%'!C90","v":30043},{"$f":"'Direct 60%'!E90","v":"Concord Managers"},{"$f":"'Direct 60%'!F90","v":"Resturant Manager"},{"$f":"'Direct 60%'!AQ90","v":3124.15}]
[{"$f":"IF(B77=0,\"\",MAX($A$1:A76)+1)","v":""},{"$f":"'Direct 60%'!B91","v":0},{"$f":"'Direct 60%'!C91","v":22911},{"$f":"'Direct 60%'!E91","v":"Concord Managers"},{"$f":"'Direct 60%'!F91","v":"Assistant Manager"},{"$f":"'Direct 60%'!AQ91","v":2531.1}]
[{"$f":"IF(B78=0,\"\",MAX($A$1:A77)+1)","v":""},{"$f":"'Direct 60%'!B92","v":0},{"$f":"'Direct 60%'!C92","v":20914},{"$f":"'Direct 60%'!E92","v":"Concord"},{"$f":"'Direct 60%'!F92","v":"C.T - Cook"},{"$f":"'Direct 60%'!AQ92","v":3796}]
[{"$f":"IF(B79=0,\"\",MAX($A$1:A78)+1)","v":""},{"$f":"'Direct 60%'!B93","v":0},{"$f":"'Direct 60%'!C93","v":30254},{"$f":"'Direct 60%'!E93","v":"Concord"},{"$f":"'Direct 60%'!F93","v":"Cook"},{"$f":"'Direct 60%'!AQ93","v":3669.72}]
[{"$f":"IF(B80=0,\"\",MAX($A$1:A79)+1)","v":""},{"$f":"'Direct 60%'!B94","v":0},{"$f":"'Direct 60%'!C94","v":22657},{"$f":"'Direct 60%'!E94","v":"Concord"},{"$f":"'Direct 60%'!F94","v":"Cook"},{"$f":"'Direct 60%'!AQ94","v":3085.57}]
[{"$f":"IF(B81=0,\"\",MAX($A$1:A80)+1)","v":""},{"$f":"'Direct 60%'!B95","v":0},{"$f":"'Direct 60%'!C95","v":22787},{"$f":"'Direct 60%'!E95","v":"Concord"},{"$f":"'Direct 60%'!F95","v":"Cook"},{"$f":"'Direct 60%'!AQ95","v":3086}]
[{"$f":"IF(B82=0,\"\",MAX($A$1:A81)+1)","v":""},{"$f":"'Direct 60%'!B96","v":0},{"$f":"'Direct 60%'!C96","v":22821},{"$f":"'Direct 60%'!E96","v":"Concord"},{"$f":"'Direct 60%'!F96","v":"Cook"},{"$f":"'Direct 60%'!AQ96","v":333.78}]
[{"$f":"IF(B83=0,\"\",MAX($A$1:A82)+1)","v":""},{"$f":"'Direct 60%'!B97","v":0},{"$f":"'Direct 60%'!C97","v":21234},{"$f":"'Direct 60%'!E97","v":"Concord"},{"$f":"'Direct 60%'!F97","v":"Cook"},{"$f":"'Direct 60%'!AQ97","v":3529.78}]
[{"$f":"IF(B84=0,\"\",MAX($A$1:A83)+1)","v":""},{"$f":"'Direct 60%'!B98","v":0},{"$f":"'Direct 60%'!C98","v":22849},{"$f":"'Direct 60%'!E98","v":"Concord"},{"$f":"'Direct 60%'!F98","v":"Baker"},{"$f":"'Direct 60%'!AQ98","v":3086}]
[{"$f":"IF(B85=0,\"\",MAX($A$1:A84)+1)","v":""},{"$f":"'Direct 60%'!B99","v":0},{"$f":"'Direct 60%'!C99","v":22893},{"$f":"'Direct 60%'!E99","v":"Concord"},{"$f":"'Direct 60%'!F99","v":"Dishwaser"},{"$f":"'Direct 60%'!AQ99","v":2886.75}]
[{"$f":"IF(B86=0,\"\",MAX($A$1:A85)+1)","v":""},{"$f":"'Direct 60%'!B100","v":0},{"$f":"'Direct 60%'!C100","v":22904},{"$f":"'Direct 60%'!E100","v":"Concord"},{"$f":"'Direct 60%'!F100","v":"Food Server"},{"$f":"'Direct 60%'!AQ100","v":1821.45}]
[{"$f":"IF(B87=0,\"\",MAX($A$1:A86)+1)","v":""},{"$f":"'Direct 60%'!B101","v":0},{"$f":"'Direct 60%'!C101","v":21553},{"$f":"'Direct 60%'!E101","v":"Concord"},{"$f":"'Direct 60%'!F101","v":"C.T - Cook"},{"$f":"'Direct 60%'!AQ101","v":3515.84}]
[{"$f":"IF(B88=0,\"\",MAX($A$1:A87)+1)","v":""},{"$f":"'Direct 60%'!B102","v":0},{"$f":"'Direct 60%'!C102","v":22360},{"$f":"'Direct 60%'!E102","v":"Concord"},{"$f":"'Direct 60%'!F102","v":"Food Server"},{"$f":"'Direct 60%'!AQ102","v":3144.49}]
[{"$f":"IF(B89=0,\"\",MAX($A$1:A88)+1)","v":""},{"$f":"'Direct 60%'!B103","v":0},{"$f":"'Direct 60%'!C103","v":20679},{"$f":"'Direct 60%'!E103","v":"Concord"},{"$f":"'Direct 60%'!F103","v":"C.T - Food Server"},{"$f":"'Direct 60%'!AQ103","v":3788.4}]
[{"$f":"IF(B90=0,\"\",MAX($A$1:A89)+1)","v":""},{"$f":"'Direct 60%'!B104","v":0},{"$f":"'Direct 60%'!C104","v":22923},{"$f":"'Direct 60%'!E104","v":"Concord"},{"$f":"'Direct 60%'!F104","v":"Cook"},{"$f":"'Direct 60%'!AQ104","v":3223.76}]
[{"$f":"IF(B91=0,\"\",MAX($A$1:A90)+1)","v":""},{"$f":"'Direct 60%'!B105","v":0},{"$f":"'Direct 60%'!C105","v":22924},{"$f":"'Direct 60%'!E105","v":"Concord"},{"$f":"'Direct 60%'!F105","v":"Host"},{"$f":"'Direct 60%'!AQ105","v":1175.1199999999999}]
[{"$f":"IF(B92=0,\"\",MAX($A$1:A91)+1)","v":""},{"$f":"'Direct 60%'!B106","v":0},{"$f":"'Direct 60%'!C106","v":0},{"$f":"'Direct 60%'!E106","v":0},{"$f":"'Direct 60%'!F106","v":0},{"$f":"'Direct 60%'!AQ106","v":230553.73000000007}]
[{"$f":"IF(B93=0,\"\",MAX($A$1:A92)+1)","v":""},{"$f":"'Direct 60%'!B107","v":0},{"$f":"'Direct 60%'!C107","v":0},{"$f":"'Direct 60%'!E107","v":0},{"$f":"'Direct 60%'!F107","v":0},{"$f":"'Direct 60%'!AQ107","v":0}]
[{"$f":"IF(B94=0,\"\",MAX($A$1:A93)+1)","v":""},{"$f":"'Direct 60%'!B108","v":0},{"$f":"'Direct 60%'!C108","v":0},{"$f":"'Direct 60%'!E108","v":0},{"$f":"'Direct 60%'!F108","v":0},{"$f":"'Direct 60%'!AQ108","v":0}]
[{"$f":"IF(B95=0,\"\",MAX($A$1:A94)+1)","v":""},{"$f":"'Direct 60%'!B109","v":0},{"$f":"'Direct 60%'!C109","v":0},{"$f":"'Direct 60%'!E109","v":0},{"$f":"'Direct 60%'!F109","v":0},{"$f":"'Direct 60%'!AQ109","v":0}]
[{"$f":"IF(B96=0,\"\",MAX($A$1:A95)+1)","v":""},{"$f":"'Direct 60%'!B110","v":0},{"$f":"'Direct 60%'!C110","v":0},{"$f":"'Direct 60%'!E110","v":0},{"$f":"'Direct 60%'!F110","v":0},{"$f":"'Direct 60%'!AQ110","v":0}]
[{"$f":"IF(B97=0,\"\",MAX($A$1:A96)+1)","v":""},{"$f":"'Direct 60%'!B111","v":0},{"$f":"'Direct 60%'!C111","v":0},{"$f":"'Direct 60%'!E111","v":0},{"$f":"'Direct 60%'!F111","v":0},{"$f":"'Direct 60%'!AQ111","v":0}]
[{"$f":"IF(B98=0,\"\",MAX($A$1:A97)+1)","v":""},{"$f":"'Direct 60%'!B112","v":0},{"$f":"'Direct 60%'!C112","v":0},{"$f":"'Direct 60%'!E112","v":0},{"$f":"'Direct 60%'!F112","v":0},{"$f":"'Direct 60%'!AQ112","v":0}]
[{"$f":"IF(B99=0,\"\",MAX($A$1:A98)+1)","v":""},{"$f":"'Direct 60%'!B113","v":0},{"$f":"'Direct 60%'!C113","v":0},{"$f":"'Direct 60%'!E113","v":0},{"$f":"'Direct 60%'!F113","v":0},{"$f":"'Direct 60%'!AQ113","v":0}]
[{"$f":"IF(B100=0,\"\",MAX($A$1:A99)+1)","v":""},{"$f":"'Direct 60%'!B114","v":0},{"$f":"'Direct 60%'!C114","v":0},{"$f":"'Direct 60%'!E114","v":0},{"$f":"'Direct 60%'!F114","v":0},{"$f":"'Direct 60%'!AQ114","v":0}]
[{"$f":"IF(B101=0,\"\",MAX($A$1:A100)+1)","v":""},{"$f":"'Direct 60%'!B115","v":0},{"$f":"'Direct 60%'!C115","v":0},{"$f":"'Direct 60%'!E115","v":0},{"$f":"'Direct 60%'!F115","v":0},{"$f":"'Direct 60%'!AQ115","v":0}]
[{"$f":"IF(B102=0,\"\",MAX($A$1:A101)+1)","v":""},{"$f":"'Direct 60%'!B116","v":0},{"$f":"'Direct 60%'!C116","v":0},{"$f":"'Direct 60%'!E116","v":0},{"$f":"'Direct 60%'!F116","v":0},{"$f":"'Direct 60%'!AQ116","v":0}]
[{"$f":"IF(B103=0,\"\",MAX($A$1:A102)+1)","v":""},{"$f":"'Direct 60%'!B117","v":0},{"$f":"'Direct 60%'!C117","v":0},{"$f":"'Direct 60%'!E117","v":0},{"$f":"'Direct 60%'!F117","v":0},{"$f":"'Direct 60%'!AQ117","v":0}]
[{"$f":"IF(B104=0,\"\",MAX($A$1:A103)+1)","v":""},{"$f":"'Direct 60%'!B118","v":0},{"$f":"'Direct 60%'!C118","v":0},{"$f":"'Direct 60%'!E118","v":0},{"$f":"'Direct 60%'!F118","v":0},{"$f":"'Direct 60%'!AQ118","v":0}]
[{"$f":"IF(B105=0,\"\",MAX($A$1:A104)+1)","v":""},{"$f":"'Direct 60%'!B119","v":0},{"$f":"'Direct 60%'!C119","v":0},{"$f":"'Direct 60%'!E119","v":0},{"$f":"'Direct 60%'!F119","v":0},{"$f":"'Direct 60%'!AQ119","v":0}]
[{"$f":"IF(B106=0,\"\",MAX($A$1:A105)+1)","v":""},{"$f":"'Direct 60%'!B120","v":0},{"$f":"'Direct 60%'!C120","v":0},{"$f":"'Direct 60%'!E120","v":0},{"$f":"'Direct 60%'!F120","v":0},{"$f":"'Direct 60%'!AQ120","v":0}]
[{"$f":"IF(B107=0,\"\",MAX($A$1:A106)+1)","v":""},{"$f":"'Direct 60%'!B121","v":0},{"$f":"'Direct 60%'!C121","v":0},{"$f":"'Direct 60%'!E121","v":0},{"$f":"'Direct 60%'!F121","v":0},{"$f":"'Direct 60%'!AQ121","v":0}]
[{"$f":"IF(B108=0,\"\",MAX($A$1:A107)+1)","v":""},{"$f":"'Direct 60%'!B122","v":0},{"$f":"'Direct 60%'!C122","v":0},{"$f":"'Direct 60%'!E122","v":0},{"$f":"'Direct 60%'!F122","v":0},{"$f":"'Direct 60%'!AQ122","v":0}]
[{"$f":"IF(B109=0,\"\",MAX($A$1:A108)+1)","v":""},{"$f":"'Direct 60%'!B123","v":0},{"$f":"'Direct 60%'!C123","v":0},{"$f":"'Direct 60%'!E123","v":0},{"$f":"'Direct 60%'!F123","v":0},{"$f":"'Direct 60%'!AQ123","v":0}]
[{"$f":"IF(B110=0,\"\",MAX($A$1:A109)+1)","v":""},{"$f":"'Direct 60%'!B124","v":0},{"$f":"'Direct 60%'!C124","v":0},{"$f":"'Direct 60%'!E124","v":0},{"$f":"'Direct 60%'!F124","v":0},{"$f":"'Direct 60%'!AQ124","v":0}]
[{"$f":"IF(B111=0,\"\",MAX($A$1:A110)+1)","v":""},{"$f":"'Direct 60%'!B125","v":0},{"$f":"'Direct 60%'!C125","v":0},{"$f":"'Direct 60%'!E125","v":0},{"$f":"'Direct 60%'!F125","v":0},{"$f":"'Direct 60%'!AQ125","v":0}]
[{"$f":"IF(B112=0,\"\",MAX($A$1:A111)+1)","v":""},{"$f":"'Direct 60%'!B126","v":0},{"$f":"'Direct 60%'!C126","v":0},{"$f":"'Direct 60%'!E126","v":0},{"$f":"'Direct 60%'!F126","v":0},{"$f":"'Direct 60%'!AQ126","v":0}]
[{"$f":"IF(B113=0,\"\",MAX($A$1:A112)+1)","v":""},{"$f":"'Direct 60%'!B127","v":0},{"$f":"'Direct 60%'!C127","v":0},{"$f":"'Direct 60%'!E127","v":0},{"$f":"'Direct 60%'!F127","v":0},{"$f":"'Direct 60%'!AQ127","v":0}]
[{"$f":"IF(B114=0,\"\",MAX($A$1:A113)+1)","v":""},{"$f":"'Direct 60%'!B128","v":0},{"$f":"'Direct 60%'!C128","v":0},{"$f":"'Direct 60%'!E128","v":0},{"$f":"'Direct 60%'!F128","v":0},{"$f":"'Direct 60%'!AQ128","v":0}]
[{"$f":"IF(B115=0,\"\",MAX($A$1:A114)+1)","v":""},{"$f":"'Direct 60%'!B129","v":0},{"$f":"'Direct 60%'!C129","v":0},{"$f":"'Direct 60%'!E129","v":0},{"$f":"'Direct 60%'!F129","v":0},{"$f":"'Direct 60%'!AQ129","v":0}]
[{"$f":"IF(B116=0,\"\",MAX($A$1:A115)+1)","v":""},{"$f":"'Direct 60%'!B130","v":0},{"$f":"'Direct 60%'!C130","v":0},{"$f":"'Direct 60%'!E130","v":0},{"$f":"'Direct 60%'!F130","v":0},{"$f":"'Direct 60%'!AQ130","v":0}]
[{"$f":"IF(B117=0,\"\",MAX($A$1:A116)+1)","v":""},{"$f":"'Direct 60%'!B131","v":0},{"$f":"'Direct 60%'!C131","v":0},{"$f":"'Direct 60%'!E131","v":0},{"$f":"'Direct 60%'!F131","v":0},{"$f":"'Direct 60%'!AQ131","v":0}]
[{"$f":"IF(B118=0,\"\",MAX($A$1:A117)+1)","v":""},{"$f":"'Direct 60%'!B132","v":0},{"$f":"'Direct 60%'!C132","v":0},{"$f":"'Direct 60%'!E132","v":0},{"$f":"'Direct 60%'!F132","v":0},{"$f":"'Direct 60%'!AQ132","v":0}]
[{"$f":"IF(B119=0,\"\",MAX($A$1:A118)+1)","v":""},{"$f":"'Direct 60%'!B133","v":0},{"$f":"'Direct 60%'!C133","v":0},{"$f":"'Direct 60%'!E133","v":0},{"$f":"'Direct 60%'!F133","v":0},{"$f":"'Direct 60%'!AQ133","v":0}]
[{"$f":"IF(B120=0,\"\",MAX($A$1:A119)+1)","v":""},{"$f":"'Direct 60%'!B134","v":0},{"$f":"'Direct 60%'!C134","v":0},{"$f":"'Direct 60%'!E134","v":0},{"$f":"'Direct 60%'!F134","v":0},{"$f":"'Direct 60%'!AQ134","v":0}]
[{"$f":"IF(B121=0,\"\",MAX($A$1:A120)+1)","v":""},{"$f":"'Direct 60%'!B135","v":0},{"$f":"'Direct 60%'!C135","v":0},{"$f":"'Direct 60%'!E135","v":0},{"$f":"'Direct 60%'!F135","v":0},{"$f":"'Direct 60%'!AQ135","v":0}]
[{"$f":"IF(B122=0,\"\",MAX($A$1:A121)+1)","v":""},{"$f":"'Direct 60%'!B136","v":0},{"$f":"'Direct 60%'!C136","v":0},{"$f":"'Direct 60%'!E136","v":0},{"$f":"'Direct 60%'!F136","v":0},{"$f":"'Direct 60%'!AQ136","v":0}]
[{"$f":"IF(B123=0,\"\",MAX($A$1:A122)+1)","v":""},{"$f":"'Direct 60%'!B137","v":0},{"$f":"'Direct 60%'!C137","v":0},{"$f":"'Direct 60%'!E137","v":0},{"$f":"'Direct 60%'!F137","v":0},{"$f":"'Direct 60%'!AQ137","v":0}]
[{"$f":"IF(B124=0,\"\",MAX($A$1:A123)+1)","v":""},{"$f":"'Direct 60%'!B138","v":0},{"$f":"'Direct 60%'!C138","v":0},{"$f":"'Direct 60%'!E138","v":0},{"$f":"'Direct 60%'!F138","v":0},{"$f":"'Direct 60%'!AQ138","v":0}]
[{"$f":"IF(B125=0,\"\",MAX($A$1:A124)+1)","v":""},{"$f":"'Direct 60%'!B139","v":0},{"$f":"'Direct 60%'!C139","v":0},{"$f":"'Direct 60%'!E139","v":0},{"$f":"'Direct 60%'!F139","v":0},{"$f":"'Direct 60%'!AQ139","v":0}]
[{"$f":"IF(B126=0,\"\",MAX($A$1:A125)+1)","v":""},{"$f":"'Direct 60%'!B140","v":0},{"$f":"'Direct 60%'!C140","v":0},{"$f":"'Direct 60%'!E140","v":0},{"$f":"'Direct 60%'!F140","v":0},{"$f":"'Direct 60%'!AQ140","v":0}]
[{"$f":"IF(B127=0,\"\",MAX($A$1:A126)+1)","v":""},{"$f":"'Direct 60%'!B141","v":0},{"$f":"'Direct 60%'!C141","v":0},{"$f":"'Direct 60%'!E141","v":0},{"$f":"'Direct 60%'!F141","v":0},{"$f":"'Direct 60%'!AQ141","v":0}]
[{"$f":"IF(B128=0,\"\",MAX($A$1:A127)+1)","v":""},{"$f":"'Direct 60%'!B142","v":0},{"$f":"'Direct 60%'!C142","v":0},{"$f":"'Direct 60%'!E142","v":0},{"$f":"'Direct 60%'!F142","v":0},{"$f":"'Direct 60%'!AQ142","v":0}]
[{"$f":"IF(B129=0,\"\",MAX($A$1:A128)+1)","v":""},{"$f":"'Direct 60%'!B143","v":0},{"$f":"'Direct 60%'!C143","v":0},{"$f":"'Direct 60%'!E143","v":0},{"$f":"'Direct 60%'!F143","v":0},{"$f":"'Direct 60%'!AQ143","v":0}]
[{"$f":"IF(B130=0,\"\",MAX($A$1:A129)+1)","v":""},{"$f":"'Direct 60%'!B144","v":0},{"$f":"'Direct 60%'!C144","v":0},{"$f":"'Direct 60%'!E144","v":0},{"$f":"'Direct 60%'!F144","v":0},{"$f":"'Direct 60%'!AQ144","v":0}]
[{"$f":"IF(B131=0,\"\",MAX($A$1:A130)+1)","v":""},{"$f":"'Direct 60%'!B145","v":0},{"$f":"'Direct 60%'!C145","v":0},{"$f":"'Direct 60%'!E145","v":0},{"$f":"'Direct 60%'!F145","v":0},{"$f":"'Direct 60%'!AQ145","v":0}]
[{"$f":"IF(B132=0,\"\",MAX($A$1:A131)+1)","v":""},{"$f":"'Direct 60%'!B146","v":0},{"$f":"'Direct 60%'!C146","v":0},{"$f":"'Direct 60%'!E146","v":0},{"$f":"'Direct 60%'!F146","v":0},{"$f":"'Direct 60%'!AQ146","v":0}]
[{"$f":"IF(B133=0,\"\",MAX($A$1:A132)+1)","v":""},{"$f":"'Direct 60%'!B147","v":0},{"$f":"'Direct 60%'!C147","v":0},{"$f":"'Direct 60%'!E147","v":0},{"$f":"'Direct 60%'!F147","v":0},{"$f":"'Direct 60%'!AQ147","v":0}]
[{"$f":"IF(B134=0,\"\",MAX($A$1:A133)+1)","v":""},{"$f":"'Direct 60%'!B148","v":0},{"$f":"'Direct 60%'!C148","v":0},{"$f":"'Direct 60%'!E148","v":0},{"$f":"'Direct 60%'!F148","v":0},{"$f":"'Direct 60%'!AQ148","v":0}]
[{"$f":"IF(B135=0,\"\",MAX($A$1:A134)+1)","v":""},{"$f":"'Direct 60%'!B149","v":0},{"$f":"'Direct 60%'!C149","v":0},{"$f":"'Direct 60%'!E149","v":0},{"$f":"'Direct 60%'!F149","v":0},{"$f":"'Direct 60%'!AQ149","v":0}]
[{"$f":"IF(B136=0,\"\",MAX($A$1:A135)+1)","v":""},{"$f":"'Direct 60%'!B150","v":0},{"$f":"'Direct 60%'!C150","v":0},{"$f":"'Direct 60%'!E150","v":0},{"$f":"'Direct 60%'!F150","v":0},{"$f":"'Direct 60%'!AQ150","v":0}]
[{"$f":"IF(B137=0,\"\",MAX($A$1:A136)+1)","v":""},{"$f":"'Direct 60%'!B151","v":0},{"$f":"'Direct 60%'!C151","v":0},{"$f":"'Direct 60%'!E151","v":0},{"$f":"'Direct 60%'!F151","v":0},{"$f":"'Direct 60%'!AQ151","v":0}]
[{"$f":"IF(B138=0,\"\",MAX($A$1:A137)+1)","v":""},{"$f":"'Direct 60%'!B152","v":0},{"$f":"'Direct 60%'!C152","v":0},{"$f":"'Direct 60%'!E152","v":0},{"$f":"'Direct 60%'!F152","v":0},{"$f":"'Direct 60%'!AQ152","v":0}]
[{"$f":"IF(B139=0,\"\",MAX($A$1:A138)+1)","v":""},{"$f":"'Direct 60%'!B153","v":0},{"$f":"'Direct 60%'!C153","v":0},{"$f":"'Direct 60%'!E153","v":0},{"$f":"'Direct 60%'!F153","v":0},{"$f":"'Direct 60%'!AQ153","v":0}]
[{"$f":"IF(B140=0,\"\",MAX($A$1:A139)+1)","v":""},{"$f":"'Direct 60%'!B154","v":0},{"$f":"'Direct 60%'!C154","v":0},{"$f":"'Direct 60%'!E154","v":0},{"$f":"'Direct 60%'!F154","v":0},{"$f":"'Direct 60%'!AQ154","v":0}]
[{"$f":"IF(B141=0,\"\",MAX($A$1:A140)+1)","v":""},{"$f":"'Direct 60%'!B155","v":0},{"$f":"'Direct 60%'!C155","v":0},{"$f":"'Direct 60%'!E155","v":0},{"$f":"'Direct 60%'!F155","v":0},{"$f":"'Direct 60%'!AQ155","v":0}]
[{"$f":"IF(B142=0,\"\",MAX($A$1:A141)+1)","v":""},{"$f":"'Direct 60%'!B156","v":0},{"$f":"'Direct 60%'!C156","v":0},{"$f":"'Direct 60%'!E156","v":0},{"$f":"'Direct 60%'!F156","v":0},{"$f":"'Direct 60%'!AQ156","v":0}]
[{"$f":"IF(B143=0,\"\",MAX($A$1:A142)+1)","v":""},{"$f":"'Direct 60%'!B157","v":0},{"$f":"'Direct 60%'!C157","v":0},{"$f":"'Direct 60%'!E157","v":0},{"$f":"'Direct 60%'!F157","v":0},{"$f":"'Direct 60%'!AQ157","v":0}]
[{"$f":"IF(B144=0,\"\",MAX($A$1:A143)+1)","v":""},{"$f":"'Direct 60%'!B158","v":0},{"$f":"'Direct 60%'!C158","v":0},{"$f":"'Direct 60%'!E158","v":0},{"$f":"'Direct 60%'!F158","v":0},{"$f":"'Direct 60%'!AQ158","v":0}]
[{"$f":"IF(B145=0,\"\",MAX($A$1:A144)+1)","v":""},{"$f":"'Direct 60%'!B159","v":0},{"$f":"'Direct 60%'!C159","v":0},{"$f":"'Direct 60%'!E159","v":0},{"$f":"'Direct 60%'!F159","v":0},{"$f":"'Direct 60%'!AQ159","v":0}]
[{"$f":"IF(B146=0,\"\",MAX($A$1:A145)+1)","v":""},{"$f":"'Direct 60%'!B160","v":0},{"$f":"'Direct 60%'!C160","v":0},{"$f":"'Direct 60%'!E160","v":0},{"$f":"'Direct 60%'!F160","v":0},{"$f":"'Direct 60%'!AQ160","v":0}]
[{"$f":"IF(B147=0,\"\",MAX($A$1:A146)+1)","v":""},{"$f":"'Direct 60%'!B161","v":0},{"$f":"'Direct 60%'!C161","v":0},{"$f":"'Direct 60%'!E161","v":0},{"$f":"'Direct 60%'!F161","v":0},{"$f":"'Direct 60%'!AQ161","v":0}]
[{"$f":"IF(B148=0,\"\",MAX($A$1:A147)+1)","v":""},{"$f":"'Direct 60%'!B162","v":0},{"$f":"'Direct 60%'!C162","v":0},{"$f":"'Direct 60%'!E162","v":0},{"$f":"'Direct 60%'!F162","v":0},{"$f":"'Direct 60%'!AQ162","v":0}]
[{"$f":"IF(B149=0,\"\",MAX($A$1:A148)+1)","v":""},{"$f":"'Direct 60%'!B163","v":0},{"$f":"'Direct 60%'!C163","v":0},{"$f":"'Direct 60%'!E163","v":0},{"$f":"'Direct 60%'!F163","v":0},{"$f":"'Direct 60%'!AQ163","v":0}]
[{"$f":"IF(B150=0,\"\",MAX($A$1:A149)+1)","v":""},{"$f":"'Direct 60%'!B164","v":0},{"$f":"'Direct 60%'!C164","v":0},{"$f":"'Direct 60%'!E164","v":0},{"$f":"'Direct 60%'!F164","v":0},{"$f":"'Direct 60%'!AQ164","v":0}]
[{"$f":"IF(B151=0,\"\",MAX($A$1:A150)+1)","v":""},{"$f":"'Direct 60%'!B165","v":0},{"$f":"'Direct 60%'!C165","v":0},{"$f":"'Direct 60%'!E165","v":0},{"$f":"'Direct 60%'!F165","v":0},{"$f":"'Direct 60%'!AQ165","v":0}]
[{"$f":"IF(B152=0,\"\",MAX($A$1:A151)+1)","v":""},{"$f":"'Direct 60%'!B166","v":0},{"$f":"'Direct 60%'!C166","v":0},{"$f":"'Direct 60%'!E166","v":0},{"$f":"'Direct 60%'!F166","v":0},{"$f":"'Direct 60%'!AQ166","v":0}]
[{"$f":"IF(B153=0,\"\",MAX($A$1:A152)+1)","v":""},{"$f":"'Direct 60%'!B167","v":0},{"$f":"'Direct 60%'!C167","v":0},{"$f":"'Direct 60%'!E167","v":0},{"$f":"'Direct 60%'!F167","v":0},{"$f":"'Direct 60%'!AQ167","v":0}]
[{"$f":"IF(B154=0,\"\",MAX($A$1:A153)+1)","v":""},{"$f":"'Direct 60%'!B168","v":0},{"$f":"'Direct 60%'!C168","v":0},{"$f":"'Direct 60%'!E168","v":0},{"$f":"'Direct 60%'!F168","v":0},{"$f":"'Direct 60%'!AQ168","v":0}]
[{"$f":"IF(B155=0,\"\",MAX($A$1:A154)+1)","v":""},{"$f":"'Direct 60%'!B169","v":0},{"$f":"'Direct 60%'!C169","v":0},{"$f":"'Direct 60%'!E169","v":0},{"$f":"'Direct 60%'!F169","v":0},{"$f":"'Direct 60%'!AQ169","v":0}]
[{"$f":"IF(B156=0,\"\",MAX($A$1:A155)+1)","v":""},{"$f":"'Direct 60%'!B170","v":0},{"$f":"'Direct 60%'!C170","v":0},{"$f":"'Direct 60%'!E170","v":0},{"$f":"'Direct 60%'!F170","v":0},{"$f":"'Direct 60%'!AQ170","v":0}]
[{"$f":"IF(B157=0,\"\",MAX($A$1:A156)+1)","v":""},{"$f":"'Direct 60%'!B171","v":0},{"$f":"'Direct 60%'!C171","v":0},{"$f":"'Direct 60%'!E171","v":0},{"$f":"'Direct 60%'!F171","v":0},{"$f":"'Direct 60%'!AQ171","v":0}]
[{"$f":"IF(B158=0,\"\",MAX($A$1:A157)+1)","v":""},{"$f":"'Direct 60%'!B172","v":0},{"$f":"'Direct 60%'!C172","v":0},{"$f":"'Direct 60%'!E172","v":0},{"$f":"'Direct 60%'!F172","v":0},{"$f":"'Direct 60%'!AQ172","v":0}]
[{"$f":"IF(B159=0,\"\",MAX($A$1:A158)+1)","v":""},{"$f":"'Direct 60%'!B173","v":0},{"$f":"'Direct 60%'!C173","v":0},{"$f":"'Direct 60%'!E173","v":0},{"$f":"'Direct 60%'!F173","v":0},{"$f":"'Direct 60%'!AQ173","v":0}]
[{"$f":"IF(B160=0,\"\",MAX($A$1:A159)+1)","v":""},{"$f":"'Direct 60%'!B174","v":0},{"$f":"'Direct 60%'!C174","v":0},{"$f":"'Direct 60%'!E174","v":0},{"$f":"'Direct 60%'!F174","v":0},{"$f":"'Direct 60%'!AQ174","v":0}]
[{"$f":"IF(B161=0,\"\",MAX($A$1:A160)+1)","v":""},{"$f":"'Direct 60%'!B175","v":0},{"$f":"'Direct 60%'!C175","v":0},{"$f":"'Direct 60%'!E175","v":0},{"$f":"'Direct 60%'!F175","v":0},{"$f":"'Direct 60%'!AQ175","v":0}]
[{"$f":"IF(B162=0,\"\",MAX($A$1:A161)+1)","v":""},{"$f":"'Direct 60%'!B176","v":0},{"$f":"'Direct 60%'!C176","v":0},{"$f":"'Direct 60%'!E176","v":0},{"$f":"'Direct 60%'!F176","v":0},{"$f":"'Direct 60%'!AQ176","v":0}]
[{"$f":"IF(B163=0,\"\",MAX($A$1:A162)+1)","v":""},{"$f":"'Direct 60%'!B177","v":0},{"$f":"'Direct 60%'!C177","v":0},{"$f":"'Direct 60%'!E177","v":0},{"$f":"'Direct 60%'!F177","v":0},{"$f":"'Direct 60%'!AQ177","v":0}]
[{"$f":"IF(B164=0,\"\",MAX($A$1:A163)+1)","v":""},{"$f":"'Direct 60%'!B178","v":0},{"$f":"'Direct 60%'!C178","v":0},{"$f":"'Direct 60%'!E178","v":0},{"$f":"'Direct 60%'!F178","v":0},{"$f":"'Direct 60%'!AQ178","v":0}]
[{"$f":"IF(B165=0,\"\",MAX($A$1:A164)+1)","v":""},{"$f":"'Direct 60%'!B179","v":0},{"$f":"'Direct 60%'!C179","v":0},{"$f":"'Direct 60%'!E179","v":0},{"$f":"'Direct 60%'!F179","v":0},{"$f":"'Direct 60%'!AQ179","v":0}]
[{"$f":"IF(B166=0,\"\",MAX($A$1:A165)+1)","v":""},{"$f":"'Direct 60%'!B180","v":0},{"$f":"'Direct 60%'!C180","v":0},{"$f":"'Direct 60%'!E180","v":0},{"$f":"'Direct 60%'!F180","v":0},{"$f":"'Direct 60%'!AQ180","v":0}]
[{"$f":"IF(B167=0,\"\",MAX($A$1:A166)+1)","v":""},{"$f":"'Direct 60%'!B181","v":0},{"$f":"'Direct 60%'!C181","v":0},{"$f":"'Direct 60%'!E181","v":0},{"$f":"'Direct 60%'!F181","v":0},{"$f":"'Direct 60%'!AQ181","v":0}]
[{"$f":"IF(B168=0,\"\",MAX($A$1:A167)+1)","v":""},{"$f":"'Direct 60%'!B182","v":0},{"$f":"'Direct 60%'!C182","v":0},{"$f":"'Direct 60%'!E182","v":0},{"$f":"'Direct 60%'!F182","v":0},{"$f":"'Direct 60%'!AQ182","v":0}]
[{"$f":"IF(B169=0,\"\",MAX($A$1:A168)+1)","v":""},{"$f":"'Direct 60%'!B183","v":0},{"$f":"'Direct 60%'!C183","v":0},{"$f":"'Direct 60%'!E183","v":0},{"$f":"'Direct 60%'!F183","v":0},{"$f":"'Direct 60%'!AQ183","v":0}]
[{"$f":"IF(B170=0,\"\",MAX($A$1:A169)+1)","v":""},{"$f":"'Direct 60%'!B184","v":0},{"$f":"'Direct 60%'!C184","v":0},{"$f":"'Direct 60%'!E184","v":0},{"$f":"'Direct 60%'!F184","v":0},{"$f":"'Direct 60%'!AQ184","v":0}]
[{"$f":"IF(B171=0,\"\",MAX($A$1:A170)+1)","v":""},{"$f":"'Direct 60%'!B185","v":0},{"$f":"'Direct 60%'!C185","v":0},{"$f":"'Direct 60%'!E185","v":0},{"$f":"'Direct 60%'!F185","v":0},{"$f":"'Direct 60%'!AQ185","v":0}]
[{"$f":"IF(B172=0,\"\",MAX($A$1:A171)+1)","v":""},{"$f":"'Direct 60%'!B186","v":0},{"$f":"'Direct 60%'!C186","v":0},{"$f":"'Direct 60%'!E186","v":0},{"$f":"'Direct 60%'!F186","v":0},{"$f":"'Direct 60%'!AQ186","v":0}]
[{"$f":"IF(B173=0,\"\",MAX($A$1:A172)+1)","v":""},{"$f":"'Direct 60%'!B187","v":0},{"$f":"'Direct 60%'!C187","v":0},{"$f":"'Direct 60%'!E187","v":0},{"$f":"'Direct 60%'!F187","v":0},{"$f":"'Direct 60%'!AQ187","v":0}]
[{"$f":"IF(B174=0,\"\",MAX($A$1:A173)+1)","v":""},{"$f":"'Direct 60%'!B188","v":0},{"$f":"'Direct 60%'!C188","v":0},{"$f":"'Direct 60%'!E188","v":0},{"$f":"'Direct 60%'!F188","v":0},{"$f":"'Direct 60%'!AQ188","v":0}]
[{"$f":"IF(B175=0,\"\",MAX($A$1:A174)+1)","v":""},{"$f":"'Direct 60%'!B189","v":0},{"$f":"'Direct 60%'!C189","v":0},{"$f":"'Direct 60%'!E189","v":0},{"$f":"'Direct 60%'!F189","v":0},{"$f":"'Direct 60%'!AQ189","v":0}]
[{"$f":"IF(B176=0,\"\",MAX($A$1:A175)+1)","v":""},{"$f":"'Direct 60%'!B190","v":0},{"$f":"'Direct 60%'!C190","v":0},{"$f":"'Direct 60%'!E190","v":0},{"$f":"'Direct 60%'!F190","v":0},{"$f":"'Direct 60%'!AQ190","v":0}]
[{"$f":"IF(B177=0,\"\",MAX($A$1:A176)+1)","v":""},{"$f":"'Direct 60%'!B191","v":0},{"$f":"'Direct 60%'!C191","v":0},{"$f":"'Direct 60%'!E191","v":0},{"$f":"'Direct 60%'!F191","v":0},{"$f":"'Direct 60%'!AQ191","v":0}]
[{"$f":"IF(B178=0,\"\",MAX($A$1:A177)+1)","v":""},{"$f":"'Direct 60%'!B192","v":0},{"$f":"'Direct 60%'!C192","v":0},{"$f":"'Direct 60%'!E192","v":0},{"$f":"'Direct 60%'!F192","v":0},{"$f":"'Direct 60%'!AQ192","v":0}]
[{"$f":"IF(B179=0,\"\",MAX($A$1:A178)+1)","v":""},{"$f":"'Direct 60%'!B193","v":0},{"$f":"'Direct 60%'!C193","v":0},{"$f":"'Direct 60%'!E193","v":0},{"$f":"'Direct 60%'!F193","v":0},{"$f":"'Direct 60%'!AQ193","v":0}]
[{"$f":"IF(B180=0,\"\",MAX($A$1:A179)+1)","v":""},{"$f":"'Direct 60%'!B194","v":0},{"$f":"'Direct 60%'!C194","v":0},{"$f":"'Direct 60%'!E194","v":0},{"$f":"'Direct 60%'!F194","v":0},{"$f":"'Direct 60%'!AQ194","v":0}]
[{"$f":"IF(B181=0,\"\",MAX($A$1:A180)+1)","v":""},{"$f":"'Direct 60%'!B195","v":0},{"$f":"'Direct 60%'!C195","v":0},{"$f":"'Direct 60%'!E195","v":0},{"$f":"'Direct 60%'!F195","v":0},{"$f":"'Direct 60%'!AQ195","v":0}]
[{"$f":"IF(B182=0,\"\",MAX($A$1:A181)+1)","v":""},{"$f":"'Direct 60%'!B196","v":0},{"$f":"'Direct 60%'!C196","v":0},{"$f":"'Direct 60%'!E196","v":0},{"$f":"'Direct 60%'!F196","v":0},{"$f":"'Direct 60%'!AQ196","v":0}]
[{"$f":"IF(B183=0,\"\",MAX($A$1:A182)+1)","v":""},{"$f":"'Direct 60%'!B197","v":0},{"$f":"'Direct 60%'!C197","v":0},{"$f":"'Direct 60%'!E197","v":0},{"$f":"'Direct 60%'!F197","v":0},{"$f":"'Direct 60%'!AQ197","v":0}]
[{"$f":"IF(B184=0,\"\",MAX($A$1:A183)+1)","v":""},{"$f":"'Direct 60%'!B198","v":0},{"$f":"'Direct 60%'!C198","v":0},{"$f":"'Direct 60%'!E198","v":0},{"$f":"'Direct 60%'!F198","v":0},{"$f":"'Direct 60%'!AQ198","v":0}]
[{"$f":"IF(B185=0,\"\",MAX($A$1:A184)+1)","v":""},{"$f":"'Direct 60%'!B199","v":0},{"$f":"'Direct 60%'!C199","v":0},{"$f":"'Direct 60%'!E199","v":0},{"$f":"'Direct 60%'!F199","v":0},{"$f":"'Direct 60%'!AQ199","v":0}]
[{"$f":"IF(B186=0,\"\",MAX($A$1:A185)+1)","v":""},{"$f":"'Direct 60%'!B200","v":0},{"$f":"'Direct 60%'!C200","v":0},{"$f":"'Direct 60%'!E200","v":0},{"$f":"'Direct 60%'!F200","v":0},{"$f":"'Direct 60%'!AQ200","v":0}]
[{"$f":"IF(B187=0,\"\",MAX($A$1:A186)+1)","v":""},{"$f":"'Direct 60%'!B201","v":0},{"$f":"'Direct 60%'!C201","v":0},{"$f":"'Direct 60%'!E201","v":0},{"$f":"'Direct 60%'!F201","v":0},{"$f":"'Direct 60%'!AQ201","v":0}]
[{"$f":"IF(B188=0,\"\",MAX($A$1:A187)+1)","v":""},{"$f":"'Direct 60%'!B202","v":0},{"$f":"'Direct 60%'!C202","v":0},{"$f":"'Direct 60%'!E202","v":0},{"$f":"'Direct 60%'!F202","v":0},{"$f":"'Direct 60%'!AQ202","v":0}]