{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["amaliati (2)","amaliati","setad","مقایسه تیر و مرداد","کارمزد سرپرست","بیمه","Print","Print (3)","Print (2)","Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":3,"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":"amaliati (2)","index":0,"n_rows":9,"n_cols":85,"rows_kept":9,"cut":false,"hidden":true,"merged":[[1,21,1,23],[0,3,0,25],[0,27,0,48],[0,50,0,73],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,1,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,1,11],[1,12,2,12],[1,13,1,16],[1,17,1,20],[1,47,2,47],[1,24,2,24],[1,25,2,25],[1,27,1,28],[1,29,2,29],[1,30,2,30],[1,31,2,31],[1,32,1,34],[1,35,2,35],[1,36,1,39],[1,40,1,43],[1,44,1,46],[1,73,2,73],[1,48,2,48],[1,50,2,50],[1,51,1,52],[1,53,2,53],[1,56,2,56],[1,57,1,59],[1,60,2,60],[1,61,1,64],[1,65,1,68],[1,69,1,71],[1,72,2,72],[1,80,2,80],[1,81,2,81],[1,82,2,82],[1,83,2,83],[1,74,2,74],[1,75,2,75],[1,76,2,76],[1,77,2,77],[1,78,2,78],[1,79,2,79]]}
[null,null,null,"تعداد",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مبلغ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"محاسبه نهایی"]
["کد پرسنلی","کد ملی","شماره بیمه","نام","تعداد پایانه",null,"جمع کل دستگاه","درصد بازرسی","مونیتورینگ","پشتیبانی",null,null,"ورود به نمایندگی","نصب",null,null,null,"فسخ",null,null,null,"بازاریابی",null,null,"تعداد تراکنش","تعداد بازرسی بالای  95 ",null,"تعداد پایانه",null,"هزینه رفت و امد","درصد بازرسی","مونیتورینگ","پشتیبانی",null,null,"ورود به نمایندگی","نصب",null,null,null,"فسخ",null,null,null,"بازاریابی",null,null,"تعداد تراکنش","تعداد بازرسی بین 95 تا96",null,"نام","تعداد پایانه",null,"حقوق ثابت","هزینه رفت و ",null,"مونیتورینگ","پشتیبانی",null,null,"ورود به نمایندگی","نصب",null,null,null,"فسخ",null,null,null,"بازاریابی",null,null,"تعداد تراکنش","تعداد بازرسی بین 95 تا96","تشویق مدیریتی","حق اولاد","حقوق","حقوق ثابت پرسنل ستادی","مبلغ اضافه کاری","کسر حق بیمه سهم کارگر","کسر مالیات","کسر قسط","کسر مساعده","پرداخت نهایی"]
[null,null,null,null,"VIP","معمولی",null,null,null,"روز اول","روز دوم","روز سوم",null,"روز اول","روز دوم","روز سوم","روز چهارم","روز اول","روز دوم","روز سوم","روز چهارم","معمولی ","VIP","VVIP",null,null,null,"VIP","معمولی",null,null,null,"روز اول","روز دوم","روز سوم",null,"روز اول","روز دوم","روز سوم","روز چهارم","روز اول","روز دوم","روز سوم","روز چهارم","معمولی ","VIP","VVIP",null,null,null,null,"VIP","معمولی",null,"امد","درصد بازرسی",null,"روز اول","روز دوم","روز سوم",null,"روز اول","روز دوم","روز سوم","روز چهارم","روز اول","روز دوم","روز سوم","روز چهارم","معمولی ","VIP","VVIP"]
[null,null,null,"بهزاد اسکندری",126,693,{"$f":"SUM(E4:F4)","v":819},"0.9794",0,6,0,5,0,51,0,0,0,0,0,0,0,2,3,3,135855,0,null,18000,8500,3500,1,12000,25000,20000,-15000,20000,45000,35000,25000,-15000,25000,20000,15000,-15000,100000,300000,450000,20,100000,null,"بهزاد اسکندری",{"$f":"E4*AB4","v":2268000},5890500,{"$f":"SUM(AZ4:BA4)","v":8158500},{"$f":"AD4*SUM(E4:F4)","v":2866500},{"$f":"H4","v":"0.9794"},{"$f":"I4*AF4","v":0},150000,0,-75000,0,{"$f":"AK4*N4","v":2295000},0,0,0,{"$f":"R4*AO4","v":0},0,{"$f":"AQ4*T4","v":0},0,{"$f":"V4*AS4","v":200000},900000,1350000,2717100,0,700000,null,{"$f":"SUM(BB4:BC4)*BD4+SUM(BE4:BG4)-BH4+SUM(BI4:BL4)-BM4+SUM(BN4:BP4)-BQ4+SUM(BR4:BX4)","v":19184985},0,0,777650,{"$f":"(BY4-20000000)*10%","v":-81501.5},null,null,{"$f":"BY4-SUM(CB4:CE4)","v":18488836.5},"حق بیمه سهم کارگر واریز شد"]
[null,null,null,"اکبر آهنگر",138,605,{"$f":"SUM(E5:F5)","v":743},0.98760000000000003,0,11,0,10,0,38,0,0,0,0,0,0,0,2,1,0,161647,0,null,18000,8500,3000,1,12000,25000,20000,-15000,20000,45000,35000,25000,-15000,25000,20000,15000,-15000,100000,300000,450000,20,100000,null,"اکبر آهنگر",2484000,5142500,{"$f":"SUM(AZ5:BA5)","v":7626500},2229000,{"$f":"H5","v":0.98760000000000003},0,275000,0,-150000,0,1710000,0,0,0,0,0,0,0,200000,300000,0,3232940,0,2570069,929931,{"$f":"SUM(BB5:BC5)*BD5+SUM(BE5:BG5)-BH5+SUM(BI5:BL5)-BM5+SUM(BN5:BP5)-BQ5+SUM(BR5:BX5)","v":19101231.800000001},0,0,777650,0,3000000,null,{"$f":"BY5-SUM(CB5:CE5)","v":15323581.800000001}]
[null,null,null,"فرشاد پاشایی",145,604,749,"0.9510",0,6,0,15,0,60,0,0,0,15,0,0,0,1,2,2,213062,0,null,18000,8500,3000,1,12000,25000,20000,-15000,20000,45000,35000,25000,-15000,25000,20000,15000,-15000,100000,300000,450000,20,100000,null,"فرشاد پاشایی",2610000,5134000,7744000,2247000,"0.9510",0,150000,0,-225000,0,2700000,0,0,0,375000,0,0,0,100000,600000,900000,4261240,0,null,null,{"$f":"SUM(BB6:BC6)*BD6+SUM(BE6:BG6)-BH6+SUM(BI6:BL6)-BM6+SUM(BN6:BP6)-BQ6+SUM(BR6:BX6)","v":18812681},0,0,777650,0,null,null,18035031]
[null,null,null,"علیرضا چکوری",157,541,698,"0.9517",0,11,2,19,1,27,0,0,0,0,0,0,0,2,3,1,168694,0,null,18000,8500,3500,1,12000,25000,20000,-15000,20000,45000,35000,25000,-15000,25000,20000,15000,-15000,100000,300000,450000,20,100000,null,"علیرضا چکوری",2826000,4598500,7424500,2443000,"0.9517",0,275000,40000,-285000,20000,1215000,0,0,0,0,0,0,0,200000,900000,450000,3373880,0,null,929931,17079710.75,0,0,777650,0,null,null,16302060.75]
[null,null,null,"حسین قاسمی",115,746,861,"0.9347",0,5,0,0,8,23,0,0,0,17,0,0,0,0,0,1,170230,0,null,18000,8500,3000,1,12000,25000,20000,-15000,20000,45000,35000,25000,-15000,25000,20000,15000,-15000,100000,300000,450000,20,100000,null,"حسین قاسمی",2070000,6341000,8411000,2583000,"0.9347",0,125000,0,0,160000,1035000,0,0,0,425000,0,0,0,0,0,450000,3404600,0,null,null,15875691.799999999,0,0,777650,0,2000000,null,13098041.799999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CF4:CF8)","v":81247551.849999994}]

{"sheet":"amaliati","index":1,"n_rows":79,"n_cols":90,"rows_kept":79,"cut":false,"hidden":false,"merged":[[1,8,2,8],[1,21,1,23],[1,6,2,6],[1,89,2,89],[1,84,2,84],[1,85,2,85],[1,86,2,86],[1,87,2,87],[1,88,2,88],[1,12,2,12],[1,24,2,24],[1,9,1,11],[1,13,1,16],[1,17,1,20],[1,81,2,81],[1,82,2,82],[0,50,0,73],[1,50,2,50],[1,51,1,52],[1,56,2,56],[1,57,1,59],[1,65,1,68],[1,53,2,53],[1,61,1,64],[1,69,1,71],[1,72,2,72],[1,73,2,73],[1,40,1,43],[1,44,1,46],[1,60,2,60],[1,77,2,77],[1,78,2,78],[1,47,2,47],[1,48,2,48],[1,79,2,79],[1,80,2,80],[1,76,2,76],[1,74,2,74],[1,75,2,75],[0,0,0,25],[1,0,2,0],[1,27,1,28],[1,4,1,5],[1,35,2,35],[1,7,2,7],[1,29,2,29],[1,31,2,31],[0,27,0,48],[1,25,2,25],[1,30,2,30],[1,36,1,39],[1,32,1,34],[1,1,2,1],[1,2,2,2],[1,3,2,3]]}
["تعداد",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مبلغ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"محاسبه نهایی"]
["نام","کد ملی","کد پرسنلی","شماره بیمه","تعداد پایانه",null,"جمع کل دستگاه","درصد بازرسی","درصد بازرسی","پشتیبانی",null,null,"ورود به نمایندگی","نصب",null,null,null,"فسخ",null,null,null,"بازاریابی",null,null,"تعداد تراکنش","تعداد بازرسی بالای  95 ",null,"تعداد پایانه",null,"هزینه رفت و امد","درصد بازرسی","مونیتورینگ","پشتیبانی",null,null,"ورود به نمایندگی","نصب",null,null,null,"فسخ",null,null,null,"بازاریابی",null,null,"تعداد تراکنش","تعداد بازرسی بین 95 تا96",null,"نام","تعداد پایانه",null,"حقوق ثابت","هزینه رفت و ",null,"مونیتورینگ","پشتیبانی",null,null,"ورود به نمایندگی","نصب",null,null,null,"فسخ",null,null,null,"بازاریابی",null,null,"تعداد تراکنش","تعداد بازرسی بین 95 تا96","تشویق مدیریتی","حق اولاد","حقوق","کسر حق بیمه سهم کارگر","کسر مالیات","کسر قسط","کسر مساعده","پرداخت نهایی","مانده از فیش قبل",null,"مرخصی ساعتی (دقیقه)","روزکارکرد","مرخصی روزانه","مرخصی بدون حقوق","تعداد مانیتورنیگ","مانده از فیش قبل"]
[null,null,null,null,"VIP","معمولی",null,null,null,"روز اول","روز دوم","روز سوم",null,"روز اول","روز دوم","روز سوم","روز چهارم","روز اول","روز دوم","روز سوم","روز چهارم","معمولی ","VIP","VVIP",null,null,null,"VIP","معمولی",null,null,null,"روز اول","روز دوم","روز سوم",null,"روز اول","روز دوم","روز سوم","روز چهارم","روز اول","روز دوم","روز سوم","روز چهارم","معمولی ","VIP","VVIP",null,null,null,null,"VIP","معمولی",null,"امد","درصد بازرسی",null,"روز اول","روز دوم","روز سوم",null,"روز اول","روز دوم","روز سوم","روز چهارم","روز اول","روز دوم","روز سوم","روز چهارم","معمولی ","VIP","VVIP"]
["بهزاد اسکندری",123,78,57,129,686,{"$f":"SUM(E4:F4)","v":815},0.96799999999999997,{"$f":"IF(H4>=0.95,1,H4)","v":1},11,8,6,0,28,0,0,0,18,0,0,0,3,2,0,126491,{"$f":"(H4*G4)-(G4*95/100)","v":14.669999999999959},null,18000,11500,6200,1,12000,25000,20000,-15000,20000,45000,35000,25000,-15000,25000,20000,15000,-15000,100000,300000,450000,20,100000,null,"بهزاد اسکندری",{"$f":"E4*AB4","v":2322000},{"$f":"F4*AC4","v":7889000},{"$f":"SUM(AZ4:BA4)*I4","v":10211000},{"$f":"AD4*SUM(E4:F4)","v":5053000},{"$f":"I4","v":1},{"$f":"CK4*AF4","v":12000},{"$f":"J4*AG4","v":275000},{"$f":"K4*AH4","v":160000},{"$f":"L4*AI4","v":-90000},{"$f":"M4*AJ4","v":0},{"$f":"AK4*N4","v":1260000},{"$f":"AL4*O4","v":0},{"$f":"AM4*P4","v":0},{"$f":"AN4*Q4","v":0},{"$f":"R4*AO4","v":450000},{"$f":"S4*AP4","v":0},{"$f":"AQ4*T4","v":0},{"$f":"AR4*U4","v":0},{"$f":"V4*AS4","v":300000},{"$f":"W4*AT4","v":600000},{"$f":"X4*AU4","v":0},{"$f":"Y4*AV4","v":2529820},{"$f":"Z4*AW4","v":1466999.9999999958},0,0,{"$f":"((BB4+BC4)*BD4)+BE4+BF4+BG4+BH4+BI4+BJ4+BK4+BL4+BM4+BN4+BO4+BP4+BQ4+BR4+BS4+BT4+BU4+BV4+BW4+BX4","v":22227819.999999996},777650,{"$f":"IF((BY4-BX4)>=20000000,(BY4-20000000)*10%,0)","v":222781.99999999965},null,null,{"$f":"BY4-BZ4-CA4-CB4-CC4","v":21227387.999999996},null,"حق بیمه سهم کارگر واریز شد",1,2,3,4,1]
["اکبر آهنگر",null,null,null,129,607,{"$f":"SUM(E5:F5)","v":736},0.95379999999999998,{"$f":"IF(H5>=0.95,1,H5)","v":1},24,2,8,0,25,0,0,0,17,0,0,0,2,0,2,159778,{"$f":"(H5*G5)-(G5*95/100)","v":2.796799999999962},null,18000,11500,6800,1,12000,25000,20000,-15000,20000,45000,35000,25000,-15000,25000,20000,15000,-15000,100000,300000,450000,20,100000,null,"اکبر آهنگر",2322000,6980500,{"$f":"SUM(AZ5:BA5)*I5","v":9302500},5004800,{"$f":"I5","v":1},{"$f":"CK5*AF5","v":0},600000,40000,-120000,0,1125000,0,0,0,425000,0,0,0,200000,0,900000,3195560,279679.99999999622,null,null,{"$f":"((BB5+BC5)*BD5)+BE5+BF5+BG5+BH5+BI5+BJ5+BK5+BL5+BM5+BN5+BO5+BP5+BQ5+BR5+BS5+BT5+BU5+BV5+BW5+BX5","v":20952539.999999996},777650,{"$f":"IF((BY5-BX5)>=20000000,(BY5-20000000)*10%,0)","v":95253.999999999636},3000000,null,{"$f":"BY5-BZ5-CA5-CB5-CC5","v":17079635.999999996}]
["فرشاد پاشایی",null,null,null,148,589,737,0.96340000000000003,1,16,4,9,2,41,0,0,0,22,0,0,0,5,3,3,202361,9.8758000000000266,null,18000,11500,7500,1,12000,25000,20000,-15000,20000,45000,35000,25000,-15000,25000,20000,15000,-15000,100000,300000,450000,20,100000,null,"فرشاد پاشایی",2664000,6773500,9437500,5527500,1,0,400000,80000,-135000,40000,1845000,0,0,0,550000,0,0,0,500000,900000,1350000,4047220,987580.00000000268,null,null,25529800.000000004,777650,552980.00000000035,null,null,24199170.000000004]
["علیرضا چکوری",null,null,null,156,542,698,0.6321,0.6321,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,165054,0,null,18000,11500,1500,1,12000,25000,20000,-15000,20000,45000,35000,25000,-15000,25000,20000,15000,-15000,100000,300000,450000,20,100000,null,"علیرضا چکوری",2808000,6233000,5714816.0999999996,1047000,0.6321,0,0,0,0,0,0,0,0,0,0,0,0,0,100000,0,0,3301080,0,null,null,7675223.9568099994,777650,0,null,null,6897573.9568099994]
["حسین قاسمی",null,null,null,101,747,848,0.88500000000000001,0.88500000000000001,41,0,7,2,29,0,0,0,17,0,0,0,0,0,0,152075,0,null,18000,11500,4200,1,12000,25000,20000,-15000,20000,45000,35000,25000,-15000,25000,20000,15000,-15000,100000,300000,450000,20,100000,null,"حسین قاسمی",1818000,8590500,9211522.5,3561600,0.88500000000000001,0,1025000,0,-105000,40000,1305000,0,0,0,425000,0,0,0,0,0,0,3041500,0,null,null,17035713.412500001,777650,0,2000000,null,14258063.412500001,null,null,null,null,1]
["حامد میرشاه مرادی",null,null,null,168,747,915,0.95189999999999997,1,41,1,1,0,32,0,0,0,6,0,0,0,0,0,2,219271,1.7384999999999309,null,18000,11500,4400,1,12000,25000,20000,-15000,20000,45000,35000,25000,-15000,25000,20000,15000,-15000,100000,300000,450000,20,100000,null,"حامد میرشاه مرادی",3024000,8590500,11614500,4026000,1,0,1025000,20000,-15000,0,1440000,0,0,0,150000,0,0,0,0,0,900000,4385420,173849.99999999307,null,null,23719769.999999993,777650,371976.9999999993,null,null,22570142.999999993]
["پوریا شهرآشوب",null,null,null,85,361,446,0.94840000000000002,0.94840000000000002,16,0,2,0,22,0,0,0,17,0,0,0,0,1,1,93829,0,null,18000,11500,10000,1,12000,25000,20000,-15000,20000,45000,35000,25000,-15000,25000,20000,15000,-15000,100000,300000,450000,20,100000,null,"پوریا شهرآشوب",1530000,4151500,5388334.6000000006,4460000,0.94840000000000002,0,400000,0,-30000,0,990000,0,0,0,425000,0,0,0,0,300000,450000,1876580,0,null,null,13751740.534640001,777650,0,null,null,12974090.534640001]
["بهمن طهماسبی",null,null,null,81,456,537,0.9466,0.9466,64,0,14,0,18,0,0,0,10,0,0,0,1,0,1,104787,0,null,18000,11500,8400,1,12000,25000,20000,-15000,20000,45000,35000,25000,-15000,25000,20000,15000,-15000,100000,300000,450000,20,100000,null,"بهمن طهماسبی",1458000,5244000,6344113.2000000002,4510800,0.9466,0,1600000,0,-210000,0,810000,0,0,0,250000,0,0,0,100000,0,450000,2095740,0,null,null,15371000.83512,777650,0,null,3000000,11593350.83512]
["مهران غریبی ",null,null,null,159,720,879,0.90790000000000004,0.90790000000000004,54,0,6,0,44,0,0,0,20,0,0,0,0,1,3,246153,0,null,18000,11500,4000,1,12000,25000,20000,-15000,20000,45000,35000,25000,-15000,25000,20000,15000,-15000,100000,300000,450000,20,100000,null,"مهران غریبی ",2862000,8280000,10115821.800000001,3516000,0.90790000000000004,0,1350000,0,-90000,0,1980000,0,0,0,500000,0,0,0,0,300000,1350000,4923060,0,null,null,22689391.012220003,777650,268939.10122200026,null,null,21642801.910998002]
["پیمان قبادی هفشجانی",null,null,null,153,677,830,0.63149999999999995,0.63149999999999995,20,0,13,2,46,0,0,0,15,0,0,0,0,0,2,228458,0,null,18000,11500,4300,1,12000,25000,20000,-15000,20000,45000,35000,25000,-15000,25000,20000,15000,-15000,100000,300000,450000,20,100000,null,"پیمان قبادی هفشجانی",2754000,7785500,6655694.2499999991,3569000,0.63149999999999995,0,500000,0,-195000,40000,2070000,0,0,0,375000,0,0,0,0,0,900000,4569160,0,null,null,14716054.418875,777650,0,null,4000000,9938404.4188749995,null,null,null,null,2]
["شایان قدیمی بنه کهل",null,null,null,127,535,662,0.95,1,7,2,14,0,31,0,0,0,14,0,0,0,1,0,0,152348,0,null,18000,11500,7600,1,12000,25000,20000,-15000,20000,45000,35000,25000,-15000,25000,20000,15000,-15000,100000,300000,450000,20,100000,null,"شایان قدیمی بنه کهل",2286000,6152500,8438500,5031200,1,0,175000,40000,-210000,0,1395000,0,0,0,350000,0,0,0,100000,0,0,3046960,0,null,null,18366660,777650,0,null,null,17589010]
["مهدی حسینی",null,null,null,142,769,911,0.86509999999999998,0.86509999999999998,19,2,12,1,26,0,0,0,21,0,0,0,1,2,3,184641,0,null,18000,11500,5500,1,12000,25000,20000,-15000,20000,45000,35000,25000,-15000,25000,20000,15000,-15000,100000,300000,450000,20,100000,null,"مهدی حسینی",2556000,8843500,9861707.4499999993,5010500,0.86509999999999998,0,475000,40000,-180000,20000,1170000,0,0,0,525000,0,0,0,100000,600000,1350000,3692820,0,4000000,1859862,26518628.664995,777650,651862.8664995,3000000,null,22089115.798495501]
["علیرضا ناجی",null,null,null,188,650,838,0.90900000000000003,0.90900000000000003,39,0,7,0,35,0,0,0,0,0,0,0,0,3,0,228555,0,null,18000,11500,4500,1,12000,25000,20000,-15000,20000,45000,35000,25000,-15000,25000,20000,15000,-15000,100000,300000,450000,20,100000,null,"علیرضا ناجی",3384000,7475000,9870831,3771000,0.90900000000000003,0,975000,0,-105000,0,1575000,0,0,0,0,0,0,0,0,900000,0,4571100,0,null,null,20316524.379000001,777650,31652.437900000066,null,5000000,14507221.941100001,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"SUM(CD4:CD16)","v":216565969.8085385}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"SUM(CD4:CD17)","v":433131939.61707699}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF((BY69-BX69)>=20000000,(BY69-20000000)*10%,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"setad","index":2,"n_rows":16,"n_cols":26,"rows_kept":16,"cut":false,"hidden":true,"merged":[[2,25,3,25],[2,23,3,23],[2,10,3,10],[2,11,3,11],[2,17,3,17],[2,18,3,18],[2,19,3,19],[2,20,3,20],[2,21,3,21],[2,22,3,22],[2,16,3,16],[0,1,0,25],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,8,3,8],[2,9,3,9],[2,12,3,12],[2,13,3,13],[2,14,3,14],[2,15,3,15],[2,24,3,24]]}
[null,"محاسبات قانونی"]
[]
["نام","ساعت کارکرد","اضافه کار","کسر کار","مرخصی ساعتی","روز کارکرد","مرخصی استحقاقی","مرخصی استعلاجی","مرخصی بدون حقوق","حقوق پایه قانونی 31 روز","مبلغ توافقی ماهانه","مبلغ ساعتی","مبلغ اضافه کاری","حق مسکن","بن کارگری","حق اولاد","حق ماموریت","کمک هزینه پوشاک","ایاب و ذهاب","جمع حقوق و مزایا مشمول مالیات","جمع حقوق و مزایا مشمول بیمه","بیمه سهم کارگر","مساعده","اقسات","مالیات","خالص قابل پرداخت"]
[]
["محمد جواد مرعشی",0,0,null,null,31,null,null,0,9609287,30000000,0,0,400000,1100000,null,null,null,null,null,null,777650,null,null,0]
["پدیدار",0,0,null,null,31,null,null,0,9609287,50000000,0,0,400000,1100000,null,null,null,null,null,null,777650,null,null,0]
["سحر خاکسار",222,{"$f":"B7-192","v":30},null,null,31,null,null,0,9609287,18000000,{"$f":"K7/192","v":93750},{"$f":"L7*C7","v":2812500},400000,1100000,null,null,null,null,null,null,777650,null,null,0]
["سعید صحرایی",343,151,null,null,31,null,null,0,9609287,14000000,0,{"$f":"L8*C8","v":0},400000,1100000,929931,null,null,null,null,null,777650,null,null,0]
["مهتاش فداکار",281,42,null,null,31,5,null,0,9609287,21000000,{"$f":"K9/192","v":109375},4593750,400000,1100000,null,null,null,null,null,null,777650,null,null,0]
["کبری شاه مرادی",153,20,null,null,21,null,null,0,6509517,12000000,{"$f":"K10/192","v":62500},1250000,270984,770007,null,null,null,null,null,null,526806,null,null,0]
["یوسفی",40,0,null,null,15,null,null,0,4649655,19000000,{"$f":"K11/192","v":98958.333333333328},0,199995,550005,null,null,null,null,null,null,0,null,null,0]
["فرزانه مشهدی",126,0,null,null,31,null,null,0,"ساعتی",{"$f":"L12*B12","v":5328414},42289,0,200012,549984,null,null,null,null,null,null,null,null,null,0]
["میعاد نخعی",245,53,null,null,27,null,null,0,8369379,20000000,{"$f":"K13/192","v":104166.66666666667},5520833.333333334,348408,958068,null,null,null,null,null,null,null,null,null,0]
["نوروزی",254,30,null,null,31,1,null,0,9609287,9609287,42289,1268670,400000,1100000,null,null,null,null,null,null,null,null,null,0]
["محمد آهنگر",0,0,null,null,31,null,null,0,9609287,14000000,null,0,400000,1100000,null,null,null,null,null,null,null,null,null,0]
["مسعود علینژاد",0,0,null,null,31,null,null,0,9609287,30000000,null,0,400000,1100000,null,null,null,null,null,null,null,{"$f":"SUM(5000000+750000)","v":5750000},null,0]

{"sheet":"مقایسه تیر و مرداد","index":3,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":true,"merged":[[0,0,0,2],[0,4,0,6],[0,8,0,10]]}
["تیر",null,null,null,"مرداد",null,null,null,"مرداد ویرایش 2"]
["نام","مبلغ خالص پرداخت ","مبلغ ناخالص",null,"نام","مبلغ خالص پرداخت ","مبلغ ناخالص",null,"نام","مبلغ خالص پرداخت ","مبلغ ناخالص"]
["بهزاداسکندری",17559082,18707480,null,"بهزاداسکندری",17497878.630000003,18083920.700000003,null,"بهزاداسکندری",{"$f":"amaliati!CD4","v":21227387.999999996},{"$f":"amaliati!BY4","v":22227819.999999996},null,{"$f":"K3-C3","v":3520339.9999999963},700000]
["اکبرآهنگر",12475868,18615020,null,"اکبرآهنگر",11823581.800000001,15601231.800000001,null,"اکبرآهنگر",{"$f":"amaliati!CD5","v":17079635.999999996},{"$f":"amaliati!BY5","v":20952539.999999996},null,{"$f":"K4-C4","v":2337519.9999999963},3500000]
["فرشادپاشایی",10898190,16675840,null,"فرشادپاشایی",18035031,18812681,null,"فرشادپاشایی",{"$f":"amaliati!CD6","v":24199170.000000004},{"$f":"amaliati!BY6","v":25529800.000000004},null,8853960.0000000037]
["پدیدار",50000000,53333333,null,"پدیدار",50000000,50000000,null,"پدیدار",50000000,50000000]
[" علیرضا چکوری",13060250,15837900,null," علیرضا چکوری",15039986.449999999,15817636.449999999,null," علیرضا چکوری",{"$f":"amaliati!CD7","v":6897573.9568099994},{"$f":"amaliati!BY7","v":7675223.9568099994},null,-8162676.0431900006]
["حسین قاسمی",8287797.5999999996,12065447.6,null,"حسین قاسمی",13098041.799999999,15875691.799999999,null,"حسین قاسمی",{"$f":"amaliati!CD8","v":14258063.412500001},{"$f":"amaliati!BY8","v":17035713.412500001},null,4970265.8125000019]
["خدیجه احمدی",5332471.2,5733840]
["رقیه قربانی",2550000,2550000,null,"رقیه قربانی",1700000,1700000,null,"رقیه قربانی"]
["حامد میر شاه مرادی ",21122340,22111100,null,"حامد میر شاه مرادی ",21876155.294999998,22948672.549999997,null,"حامد میر شاه مرادی ",{"$f":"amaliati!#REF!","v":{"$error":"#REF!"}},{"$f":"amaliati!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["پوریا شهرآشوب",12453930,13231580,null,"پوریا شهرآشوب",9706786.5,10484436.5,null,"پوریا شهرآشوب",{"$f":"amaliati!#REF!","v":{"$error":"#REF!"}},{"$f":"amaliati!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},3000000]
["سعید صحرائی",10425387.100000001,27447819,null,"سعید صحرائی",null,null,null,"سعید صحرائی"]
["بهمن طهماسبی",7604115.1999999993,10381765.199999999,null,"بهمن طهماسبی",6513591.4000000004,10291241.4,null,"بهمن طهماسبی",{"$f":"amaliati!#REF!","v":{"$error":"#REF!"}},{"$f":"amaliati!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["علیرضا برغمدی",1600000,1600000,null,"علیرضا برغمدی",0,0,null,"علیرضا برغمدی"]
["مسعود علینژاد",25326348,30800000,null,"مسعود علینژاد",24565000,30000000,null,"مسعود علینژاد",null,30000000]
["مهران غریبی",16723305.91,17778840,null,"مهران غریبی",18000906.399999999,18778556.399999999,null,"مهران غریبی",{"$f":"amaliati!#REF!","v":{"$error":"#REF!"}},{"$f":"amaliati!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["پیمان قبادی هفشجانی",12507532.309999999,13285182.399999999,null,"پیمان قبادی هفشجانی",12438266,18215916,null,"پیمان قبادی هفشجانی",{"$f":"amaliati!#REF!","v":{"$error":"#REF!"}},{"$f":"amaliati!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["شایان قدیمی بنه کهل",12271926.710000001,14378076.800000001,null,"شایان قدیمی بنه کهل",13482532.050000001,14260182.050000001,null,"شایان قدیمی بنه کهل",{"$f":"amaliati!#REF!","v":{"$error":"#REF!"}},{"$f":"amaliati!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["محمد آهنگر",28035407.381999999,29792286.079999998,null,"محمد آهنگر",null,null,null,"محمد آهنگر"]
["محمد حسینی",2000000,2000000,null,"محمد حسینی",0,0,null,"محمد حسینی"]
["محمد رضا مرادی",11898772.91,12676423,null,"محمد رضا مرادی",1055000,1055000,null,"محمد رضا مرادی"]
["سید مهدی حسینی مشتقین ",11241335.109999999,16518985.199999999,null,"سید مهدی حسینی مشتقین ",17719106.300000001,21107507,null,"سید مهدی حسینی مشتقین ",{"$f":"amaliati!#REF!","v":{"$error":"#REF!"}},{"$f":"amaliati!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["علیرضا ناجی",16233849.91,17235000,null,"علیرضا ناجی",20164858.080000002,21047231.200000003,null,"علیرضا ناجی",{"$f":"amaliati!#REF!","v":{"$error":"#REF!"}},{"$f":"amaliati!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["طاهره نوروزی",10835636.91,13613287,null,"طاهره نوروزی",8100307,10877957,null,"طاهره نوروزی"]
["امید یل",9520249.9100000001,13797900,null,"امید یل",7008369,17786019,null,"امید یل",{"$f":"amaliati!#REF!","v":{"$error":"#REF!"}},{"$f":"amaliati!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["علیرضا یوسفی",16222349.91,19000000,null,"علیرضا یوسفی",3958320,3958320,null,"علیرضا یوسفی"]

{"sheet":"کارمزد سرپرست","index":4,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":true,"merged":[[30,17,30,23],[19,5,19,6],[31,17,31,23],[1,16,1,26],[2,20,2,21],[12,17,12,23],[13,17,13,23],[18,16,18,26],[19,20,19,21],[31,2,31,9],[1,1,1,11],[2,5,2,6],[18,1,18,11],[12,2,12,9],[30,2,30,9],[13,2,13,9]]}
[]
[null,"کارمزد فصل چهارم بازرسی دفتر تهران"]
[null,null,"تراکنش",null,null,"فسخ",null,"نصب","بازاریابی","ورود به نمایندگی"]
[null,"امید یل",216096,null,null,null,17,21,450000,2]
[null,"پیمان قبادی",240240,null,null,null,29,35,0,0]
[null,"حسین قاسمی",170230,null,null,null,17,23,450000,8]
[null,"علیرضا ناجی",228275,null,null,null,15,37,2650000,0]
[null,"فرشاد پاشایی",213062,null,null,null,15,60,1600000,0]
[null,"محمدرضا مرادی",118493,null,null,null,8,19,0,0]
[null,"مهران غریبی",246231,null,null,null,14,26,400000,4]
[null,"جمع نهایی",{"$f":"SUM(C4:C10)","v":1432627},null,null,null,{"$f":"SUM(G4:G10)","v":115},{"$f":"SUM(H4:H10)","v":221},{"$f":"SUM(I4:I10)","v":5550000},{"$f":"SUM(J4:J10)","v":14}]
[null,"مبلغ",{"$f":"SUM(C4:C10)*20","v":28652540},null,null,null,{"$f":"G11*25000","v":2875000},{"$f":"SUM(H4:H10)*45000","v":9945000},{"$f":"SUM(I4:I10)","v":5550000},{"$f":"J11*20000","v":280000}]
[null,"جمع نهایی",{"$f":"SUM(C12:J12)","v":47302540}]
[null,0.15,{"$f":"C13*30%","v":14190762}]
[]
[]
[]
[]
[null,"کارمزد فصل چهارم بازرسی دفتر'گیلاوند"]
[null,null,"تراکنش",null,null,"فسخ",null,"نصب","بازاریابی","ورود به نمایندگی"]
[null,"اکبر آهنگر",161647,null,null,null,0,38,500000,0]
[null,"بهزاد اسکندری",135855,null,null,null,0,51,2450000,0]
[null,"بهمن طهماسبی",106368,null,null,null,0,24,400000,0]
[null,"پوریا شهرآشوب",93248,null,null,null,0,43,700000,0]
[null,"حامد میرشاه مرادی",228495,null,null,null,0,54,3500000,3]
[null,"سید مهدی حسینی",209599,null,null,null,0,53,2800000,1]
[null,"شایان قدیمی",151986,null,null,null,0,34,950000,1]
[null,"علیرضا چکوری",168694,null,null,null,0,27,1550000,1]
[null,"جمع",{"$f":"SUM(C21:C28)","v":1255892},null,null,null,null,{"$f":"SUM(H21:H28)","v":324},{"$f":"SUM(I21:I28)","v":12850000},{"$f":"SUM(J21:J28)","v":6}]
[null,"مبلغ",{"$f":"C29*20","v":25117840},null,null,null,null,{"$f":"H29*45000","v":14580000},{"$f":"SUM(I21:I28)","v":12850000},{"$f":"J29*20000","v":120000}]
[null,"جمع نهایی",{"$f":"SUM(C30:J30)","v":52667840}]
[null,0.15,{"$f":"C31*30%","v":15800352}]

{"sheet":"بیمه","index":5,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["ردیف","نام و نام خانوادگی","روز کارکرد","هزينه بيمه اي  سهم شركت","حق بيمه اي  سهم پرسنل","جمع کل 30% بیمه",null,null,"دستمزد روزانه ","دستمزد ماهانه","مزایای ماهانه مشمول","مزایای ماهانه  غیر مشمول"]
[1,"اکبر آهنگر",31,2555136.0100000002,777650,{"$f":"SUM(D2:E2)","v":3332786.0100000002},null,null,309977,{"$f":"I2*31","v":9609287},{"$f":"SUM(400000+1100000)","v":1500000},929931]
[2,"فرشاد پاشایی",31,2555136.0100000002,777650,3332786.0100000002,null,null,309977,{"$f":"I3*31","v":9609287},{"$f":"SUM(400000+1100000)","v":1500000}]
[3,"علیرضا چکوری",31,2555136.0100000002,777650,3332786.0100000002,null,null,309977,9609287,1500000,929931]
[4,"حسین قاسمی",31,2555136.0100000002,777650,3332786.0100000002,null,null,309977,9609287,1500000]
[5,"حامد میرشاه مرادی",31,2555136.0100000002,777650,3332786.0100000002,null,null,309977,9609287,1500000]
[6,"پوریا شهرآشوب",31,2555136.0100000002,777650,3332786.0100000002,null,null,309977,9609287,{"$f":"SUM(400000+1100000)","v":1500000}]
[7,"بهمن طهماسبی",31,2555136.0100000002,777650,3332786.0100000002,null,null,309977,9609287,1500000,929931]
[8,"مهران غریبی ",31,2555136.0100000002,777650,3332786.0100000002,null,null,309977,9609287,1500000]
[9,"پیمان قبادی هفشجانی",31,2555136.0100000002,777650,3332786.0100000002,null,null,309977,9609287,1500000]
[10,"شایان قدیمی بنه کهل",31,2555136.0100000002,777650,3332786.0100000002,null,null,309977,9609287,1500000]
[11,"امید یل",31,2555136.0100000002,777650,3332786.0100000002,null,null,309977,9609287,1500000]
[12,"مهدی حسینی",31,2555136.0100000002,777650,3332786.0100000002,null,null,309977,9609287,1500000,929931]
[13,"علیرضا ناجی",31,2555136.0100000002,777650,3332786.0100000002,null,null,309977,9609287,1500000]
[14,"محمد جواد مرعشی",31,6900000,2100000,{"$f":"SUM(D15:E15)","v":9000000},null,null,967742,30000002,1500000]
[15,"سحر خاکسار",31,2555136.0100000002,777650,3332786.0100000002,null,null,309977,9609287,1500000]
[16,"سعید صحرایی",31,2555136.0100000002,777650,3332786.0100000002,null,null,309977,9609287,1500000,929931]
[17,"مهتاش فداکار",31,2555136.0100000002,777650,3332786.0100000002,null,null,309977,9609287,1500000]
[18,"کبری شاه مرادی",21,1730903,526797,2257700,null,null,309977,{"$f":"I19*21","v":6509517},1040991]
[19,"میعاد نخعی",27,2225447,677310,2902757,null,null,309977,{"$f":"I20*27","v":8369379},1306476]
[20,"نوروزی",31,2555136.0100000002,777650,{"$f":"SUM(D21:E21)","v":3332786.0100000002},null,null,309977,9609287,1500000]
[21,"محمد آهنگر",31,2555136.0100000002,777650,3332786.0100000002,null,null,309977,9609287,1500000]
[null,null,{"$f":"SUM(C2:C22)","v":637},{"$f":"SUM(D2:D22)","v":56848798.18},{"$f":"SUM(E2:E22)","v":17301807},{"$f":"SUM(F2:F22)","v":74150605.180000007},null,null,{"$f":"SUM(I2:I22)","v":7167282},{"$f":"SUM(J2:J22)","v":217846064},{"$f":"SUM(K2:K22)","v":30847467},{"$f":"SUM(L2:L22)","v":4649655}]

{"sheet":"Print","index":6,"n_rows":38,"n_cols":18,"rows_kept":38,"cut":false,"hidden":false,"merged":[[15,12,15,14],[19,12,19,13],[13,3,13,5],[14,3,14,5],[13,6,13,7],[14,6,14,7],[13,12,13,13],[14,12,14,13],[13,11,14,11],[18,3,18,5],[15,11,16,11],[15,9,15,10],[16,9,16,10],[15,3,15,8],[16,3,16,8],[17,3,17,5],[12,9,12,10],[13,8,13,10],[14,8,14,10],[9,3,9,7],[8,12,8,14],[8,3,8,11],[10,3,10,7],[11,3,11,8],[11,9,11,10],[9,11,10,11],[9,12,9,13],[11,11,12,11],[10,12,10,13],[11,12,11,13],[12,12,12,13],[12,3,12,8],[2,9,2,10],[2,11,2,12],[6,3,6,17],[7,9,7,10],[7,7,7,8],[7,3,7,5],[25,15,25,17],[25,11,26,11],[14,15,14,16],[20,15,20,16],[15,15,15,16],[16,15,16,16],[17,15,17,16],[18,15,18,16],[22,13,22,17],[19,15,19,16],[21,11,22,11],[21,15,21,16],[16,12,16,13],[17,12,17,13],[18,12,18,13],[17,11,18,11],[8,15,8,17],[10,15,10,16],[11,15,11,16],[12,15,12,16],[13,15,13,16],[9,15,9,16],[42,6,42,11],[23,13,23,14],[23,15,23,17],[24,13,24,14],[24,15,24,17],[25,13,25,14],[38,6,38,11],[39,6,39,11],[29,3,32,11],[23,8,23,9],[24,8,24,9],[23,3,23,4],[24,3,24,4],[25,7,25,10],[26,15,26,17],[27,13,27,14],[20,7,20,10],[20,3,20,6],[26,13,26,14],[40,6,40,11],[41,6,41,11],[28,13,28,14],[19,11,20,11],[26,7,26,10],[25,3,25,6],[26,3,26,6],[27,11,28,11],[19,7,19,10],[19,3,19,6],[23,11,24,11],[35,3,35,17],[37,3,37,17],[34,3,34,17],[36,3,36,12],[36,16,36,17],[36,13,36,15],[27,15,27,17],[28,15,28,17]]}
[]
[]
[null,null,null,null,null,null,null,null,null,"بهزاد اسکندری",null,"انتخاب شخص:"]
[]
[]
[]
[null,null,null,"شرکت پردازش افق درفک "]
[null,null,null,null,null,null,"ماه: 4","سال مالی: 1396",null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CF$200,COLUMN(B4),0)","v":123},null,"کد ملی:",{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CF$200,COLUMN(C4),0)","v":78},"کد پرسنلی:",{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CF$200,COLUMN(D4),0)","v":57},"شماره بیمه:",{"$f":"J3","v":"بهزاد اسکندری"},"نام و نام خانوادگی:"]
[null,null,null,"اطلاعات عملکردی",null,null,null,null,null,null,null,null,"کسورات عملکردی",null,null,"مزایا و درآمد"]
[null,null,null,"تعرفه محاسباتی معمولی",null,null,null,null,"تعداد پایانه معمولی","تعرفه محاسباتی VVIP","تعداد پایانه VVIP","حقوق ماهانه","مبلغ",null,"عنوان","مبلغ (ریال)",null,"عنوان"]
[null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(Z4)+3,0)","v":11500},null,null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(C4)+3,0)","v":686},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(Y4)+3,0)","v":18000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(B4)+3,0)","v":129},null,{"$f":"G19*D19","v":90000},null,"کسورات پشتیبانی",{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CK$200,COLUMN(BB4),0)","v":10211000},null,"حقوق ماهیانه"]
[null,null,null,"تعرفه محاسباتی",null,null,null,null,null,"تعداد کل پایانه",null,"هزینه رفت و آمد",{"$f":"D23*E23","v":0},null,"کسورات نصب",{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CK$200,COLUMN(BC4),0)","v":5053000},null,"هزینه رفت و آمد"]
[null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AA4)+3,0)","v":6200},null,null,null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(D4)+3,0)","v":815},null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(BZ4),0)","v":777650},null,"حق بیمه سهم کارگر",{"$f":"I15","v":"96.80%"},null,"بازرسی"]
[null,null,null,"تعرفه محاسباتی",null,null,"تعداد بازرسی بالای 95",null,"درصد پیشرفت",null,null,"بازرسی",{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CA$200,COLUMN(CA4),0)","v":222781.99999999965},null,"مالیات بر حقوق",{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(BE4),0)","v":12000},null,"مونیتورینگ"]
[null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AW4),0)","v":100000},null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CM$200,COLUMN(Z4),0)","v":14.669999999999959},null,{"$f":"TEXT(VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(H4),0),\"0.00%\")","v":"96.80%"},null,null,null,{"$f":"SUM(M11:N14)","v":1090431.9999999995},null,"جمع کل کسورات",{"$f":"K19*J19+I19*H19-D19*G19","v":345000},null,"پشتیبانی"]
[null,null,null,"تعرفه محاسباتی",null,null,null,null,null,"تعداد",null,"مونیتورینگ","اطلاعات کارکرد",null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(BI4),0)","v":0},null,"ورود به نمایندگی"]
[null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AF4),0)","v":12000},null,null,null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CK$200,COLUMN(CK4),0)","v":1},null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CJ$200,COLUMN(CG6),0)","v":1},null,"مرخصی ساعتی",{"$f":"K23*J23+I23*H23+G23*F23-E23*D23","v":1260000},null,"نصب"]
[null,null,null,"تعداد روز سوم",null,null,"کسر برداشت روز سوم","تعرفه روز دوم","تعداد روز دوم","تعرفه روز اول","تعداد روز اول","پشتیبانی",{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CJ$200,COLUMN(CG6)+ROW(A1),0)","v":2},null,"روزکارکرد",{"$f":"K25*I25+H25*G25+F25*D25","v":900000},null,"بازاریابی"]
[null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(I4)+3,0)","v":6},null,null,{"$f":"-VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AF4)+3,0)","v":15000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AE4)+3,0)","v":20000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(H4)+3,0)","v":8},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AD4)+3,0)","v":25000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(G4)+3,0)","v":11},null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CJ$200,COLUMN(CG7)+ROW(A2),0)","v":3},null,"مرخصی روزانه",{"$f":"H27*D27","v":2529820},null,"تراکنش"]
[null,null,null,"تعرفه محاسباتی",null,null,null,"تعداد",null,null,null,"ورود به نمایندگی",{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CJ$200,COLUMN(CG8)+ROW(A3),0)","v":4},null,"مرخصی بدون حقوق",{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(BW4),0)","v":0},null,"تشویق مدیریتی"]
[null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AJ4)+3,0)","v":25000},null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(M4),0)","v":0},null,null,null,null,null,null,null,{"$f":"K29*J29+I29*H29+G29*F29+E29*D29","v":450000},null,"فسخ"]
[null,null,null,"کسورات","تعداد روز چهارم","تعرفه 3","تعداد روز سوم","تعرفه 2","تعداد روز دوم","تعرفه 1","تعداد روز اول","نصب",null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CM$200,COLUMN(BY4),0)","v":22227819.999999996},null,"مبلغ ناخالص عملکرد"]
[null,null,null,{"$f":"-VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AN4),0)","v":15000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(Q4),0)","v":0},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AM4),0)","v":25000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(P4),0)","v":0},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AL4),0)","v":35000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(O4),0)","v":0},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AK4),0)","v":45000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(N44),0)","v":28},null,null,"حسابداری"]
[null,null,null,"تعرفه محاسباتی",null,"VVIP","تعرفه محاسباتی","VIP","تعرفه محاسباتی",null,"معمولی","بازاریابی",null,{"$f":"P22","v":22227819.999999996},null,"مبلغ ناخالص عملکرد"]
[null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AU4),0)","v":450000},null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(X4),0)","v":0},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AT4),0)","v":300000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(W4),0)","v":2},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AS4),0)","v":100000},null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(V4),0)","v":3},null,null,{"$f":"M15","v":1090431.9999999995},null,"مجموع کسورات"]
[null,null,null,"تعرفه محاسباتی",null,null,null,"تعداد",null,null,null,"تراکنش",null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CF$200,COLUMN(CC4),0)","v":0},null,"کسر مساعده با ارزیابی پرداخت شده طی دوره"]
[null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AV4),0)","v":20},null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(Y4),0)","v":126491},null,null,null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CF$200,COLUMN(CB4),0)","v":0},null,"کسر اقساط وام"]
[null,null,null,"کسورات","تعداد روز چهارم","تعرفه 3","تعداد روز سوم","تعرفه 2","تعداد روز دوم","تعرفه 1","تعداد روز اول","فسخ",null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CL$200,COLUMN(CL4),0)","v":0},null,"مانده از فیش قبل"]
[null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AR4),0)","v":-15000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(U4),0)","v":0},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AQ4),0)","v":15000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(T4),0)","v":0},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AP4),0)","v":20000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(S4),0)","v":0},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AO4),0)","v":25000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(R4),0)","v":18},null,null,{"$f":"N24-N25-N26-N27-N28","v":21137387.999999996},null,"خالص قابل پرداخت "]
[]
[]
[]
[]
[]
[null,null,null,"فرم تسویه حساب"]
[null,null,null,"اینجانب ............................................................. بابت تمامی مدت کارکرد خود تا تاریخ ........................................................ نزد شرکت پردازش افق درفک وفق قانون و مقررات قانون کار تمامی حق السعی و حق سنوات و عیدی و غیره را مستند به ماده 34 قانون کار دریافت نموده و با امضا ذیل این گواهی اعلام میدارم که از کارفرمای خود کمال رضایت را داشته و در آینده هیچگونه ادعائی نسبت به ایشان در خصوص حق و حقوق و مزایا و غیره در ایام کارکرد خود نداشته  و در صورت طرح هرگونه ادعائی از طرف بنده ، وکیل یا قائم مقام قانونی من ادعای مطروحه قابلیت استماع و ترتیب اثر نخواهد داشت."]
[null,null,null,"محل واریز: حساب شخصی ............................................. کارت خرید حقوقی............................................ کارت هدیه..........................................",null,null,null,null,null,null,null,null,null,{"$f":"NumberToAlpha(N29)&\" ریال\"","v":"بيست و يك ميليون  و يك صد و سي و هفت هزار  و سيصد و هشتاد و هشت ریال"},null,null,"خالص قابل پرداخت:"]
[null,null,null,"نام و نام خانوادگی: امضا و اثر انگشت:"]

{"sheet":"Print (3)","index":7,"n_rows":38,"n_cols":18,"rows_kept":38,"cut":false,"hidden":true,"merged":[[2,9,2,10],[2,11,2,12],[6,3,6,17],[7,3,7,5],[7,7,7,8],[7,9,7,10],[8,3,8,11],[8,12,8,14],[8,15,8,17],[9,3,9,7],[9,11,10,11],[9,12,9,13],[9,15,9,16],[10,3,10,7],[10,12,10,13],[10,15,10,16],[11,3,11,8],[11,9,11,10],[11,11,12,11],[11,12,11,13],[11,15,11,16],[12,3,12,8],[12,9,12,10],[12,12,12,13],[12,15,12,16],[13,15,13,16],[14,3,14,5],[14,6,14,7],[14,8,14,9],[14,12,14,13],[13,3,13,5],[13,6,13,7],[13,8,13,9],[13,11,14,11],[13,12,13,13],[14,15,14,16],[15,3,15,8],[15,9,15,10],[15,11,16,11],[15,15,15,16],[16,3,16,8],[16,9,16,10],[16,15,16,16],[19,3,19,6],[19,7,19,10],[19,11,20,11],[19,15,19,16],[20,3,20,6],[20,7,20,10],[20,15,20,16],[17,3,17,5],[17,11,18,11],[17,15,17,16],[18,3,18,5],[18,15,18,16],[21,11,22,11],[21,15,21,16],[22,13,22,17],[24,3,24,4],[24,8,24,9],[24,13,24,14],[24,15,24,17],[23,3,23,4],[23,8,23,9],[23,11,24,11],[23,13,23,14],[23,15,23,17],[25,3,25,6],[25,7,25,10],[25,11,26,11],[25,13,25,14],[25,15,25,17],[26,3,26,6],[26,7,26,10],[26,13,26,14],[26,15,26,17],[27,11,28,11],[27,13,27,14],[27,15,27,17],[28,13,28,14],[28,15,28,17],[39,6,39,11],[40,6,40,11],[41,6,41,11],[42,6,42,11],[29,3,32,11],[34,3,34,17],[35,3,35,17],[36,3,36,17],[37,3,37,17],[38,6,38,11]]}
[]
[]
[null,null,null,null,null,null,null,null,null,"اکبر آهنگر",null,"انتخاب شخص:"]
[]
[]
[]
[null,null,null,"شرکت پردازش افق درفک "]
[null,null,null,null,null,null,"ماه: 4","سال مالی: 1396",null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CF$200,COLUMN(B4),0)","v":0},null,"کد ملی:",{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CF$200,COLUMN(C4),0)","v":0},"کد پرسنلی:",{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CF$200,COLUMN(D4),0)","v":0},"شماره بیمه:",{"$f":"J3","v":"اکبر آهنگر"},"نام و نام خانوادگی:"]
[null,null,null,"اطلاعات عملکردی",null,null,null,null,null,null,null,null,"کسورات عملکردی",null,null,"مزایا و درآمد"]
[null,null,null,"تعرفه محاسباتی معمولی",null,null,null,null,"تعداد پایانه معمولی","تعرفه محاسباتی VVIP","تعداد پایانه VVIP","حقوق ماهانه","مبلغ",null,"عنوان","مبلغ (ریال)",null,"عنوان"]
[null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(Z4)+3,0)","v":11500},null,null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(C4)+3,0)","v":607},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(Y4)+3,0)","v":18000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(B4)+3,0)","v":129},null,{"$f":"G19*D19","v":120000},null,"کسورات پشتیبانی",{"$f":"K11*J11+I11*D11","v":9302500},null,"حقوق ماهیانه"]
[null,null,null,"تعرفه محاسباتی",null,null,null,null,null,"تعداد کل پایانه",null,"هزینه رفت و آمد",{"$f":"D23*E23","v":0},null,"کسورات نصب",{"$f":"J13*D13","v":5004800},null,"هزینه رفت و آمد"]
[null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AA4)+3,0)","v":6800},null,null,null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(D4)+3,0)","v":736},null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(BW4)+3,0)","v":777650},null,"حق بیمه سهم کارگر",{"$f":"D15*G15+I15","v":27976872724.499622},null,"بازرسی"]
[null,null,null,"تعرفه محاسباتی",null,null,"تعداد بازرسی بالای 95",null,"درصد پیشرفت با حقوق ثابت",null,"درصد پیشرفت","بازرسی",{"$f":"IF(N24>2000000,(N24-2000000)*10%,0)","v":2799825758.4499626},null,"مالیات بر حقوق",{"$f":"J17*D17","v":12000},null,"مونیتورینگ"]
[null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AT4)+3,0)","v":100000},null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(BS4)+3,0)","v":279679.99999999622},null,{"$f":"SUM(VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AW44)+3,0),VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AX4)+3,0))*VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(E4)+3,0)","v":8872724.5},null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(E4)+3,0)","v":0.95379999999999998},null,{"$f":"SUM(M11:N14)","v":2800723408.4499626},null,"جمع کل کسورات",{"$f":"K19*J19+I19*H19-G19*D19","v":520000},null,"پشتیبانی"]
[null,null,null,"تعرفه محاسباتی",null,null,null,null,null,"تعداد",null,"مونیتورینگ",null,null,null,{"$f":"H21*D21","v":0},null,"ورود به نمایندگی"]
[null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AC4)+3,0)","v":12000},null,null,null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(F4)+3,0)","v":1},null,null,null,null,null,{"$f":"K23*J23+I23*H23+G23*F23-E23*D23","v":1125000},null,"نصب"]
[null,null,null,"تعداد روز سوم",null,null,"کسر برداشت روز سوم","تعرفه روز دوم","تعداد روز دوم","تعرفه روز اول","تعداد روز اول","پشتیبانی",null,null,null,{"$f":"K25*I25+H25*G25+F25*D25","v":1100000},null,"بازاریابی"]
[null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(I4)+3,0)","v":8},null,null,{"$f":"-VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AF4)+3,0)","v":15000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AE4)+3,0)","v":20000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(H4)+3,0)","v":2},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AD4)+3,0)","v":25000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(G4)+3,0)","v":24},null,null,null,null,{"$f":"H27*D27","v":3195560},null,"تراکنش"]
[null,null,null,"تعرفه محاسباتی",null,null,null,"تعداد",null,null,null,"ورود به نمایندگی",null,null,null,2700000,null,"تشویق مدیریتی"]
[null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AG4)+3,0)","v":20000},null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(J4)+3,0)","v":0},null,null,null,null,null,null,null,{"$f":"K29*J29+I29*H29+G29*F29-E29*D29","v":425000},null,"فسخ"]
[null,null,null,"کسورات","تعداد روز چهارم","تعرفه 3","تعداد روز سوم","تعرفه 2","تعداد روز دوم","تعرفه 1","تعداد روز اول","نصب",null,null,null,{"$f":"N24","v":28000257584.499622},null,"مبلغ ناخالص عملکر"]
[null,null,null,{"$f":"-VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AK4)+3,0)","v":15000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(N4)+3,0)","v":0},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AJ4)+3,0)","v":25000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(M4)+3,0)","v":0},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AL4)+3,0)","v":25000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(L4)+3,0)","v":0},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AH4)+3,0)","v":45000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(K4)+3,0)","v":25},null,null,"حسابداری"]
[null,null,null,"تعرفه محاسباتی",null,"VVIP","تعرفه محاسباتی","VIP","تعرفه محاسباتی",null,"معمولی","بازاریابی",null,{"$f":"SUM(P11:Q21)","v":28000257584.499622},null,"مبلغ ناخالص عملکرد"]
[null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AR4)+3,0)","v":450000},null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(U4)+3,0)","v":2},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AQ4)+3,0)","v":300000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(T4)+3,0)","v":0},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AP4)+3,0)","v":100000},null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(S4)+3,0)","v":2},null,null,{"$f":"SUM(M11:N15)","v":5601446816.8999252},null,"مجموع کسورات"]
[null,null,null,"تعرفه محاسباتی",null,null,null,"تعداد",null,null,null,"تراکنش",null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CF$200,COLUMN(CB4),0)","v":3000000},null,"کسر مساعده با ارزیابی پرداخت شده طی دوره"]
[null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AS4)+3,0)","v":20},null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(V4)+3,0)","v":159778},null,null,null,null,null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CF$200,COLUMN(CA4),0)","v":95253.999999999636},null,"کسر اقساط وام"]
[null,null,null,"کسورات","تعداد روز چهارم","تعرفه 3","تعداد روز سوم","تعرفه 2","تعداد روز دوم","تعرفه 1","تعداد روز اول","فسخ",null,{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CF$200,COLUMN(CD4),0)","v":17079635.999999996},null,"مانده از فیش قبل"]
[null,null,null,{"$f":"-VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AO4)+3,0)","v":15000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(R4)+3,0)","v":0},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AN4)+3,0)","v":15000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(Q4)+3,0)","v":0},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AM4)+3,0)","v":20000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(P4)+3,0)","v":0},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(AL4)+3,0)","v":25000},{"$f":"VLOOKUP($J$3,amaliati!$A$4:$CD$200,COLUMN(O4)+3,0)","v":17},null,null,{"$f":"N24--N25-N26-N27-N28","v":33581529511.399548},null,"خالص قابل پرداخت "]
[]
[]
[]
[]
[]
[null,null,null,"فرم تسویه حساب"]
[null,null,null,"اینجانب ............................................................. بابت تمامی مدت کارکرد خود تا تاریخ ........................................................ نزد شرکت پردازش افق درفک وفق قانون و مقررات قانون کار تمامی حق السعی و حق سنوات و عیدی و غیره را مستند به ماده 34 قانون کار دریافت نموده و با امضا ذیل این گواهی اعلام میدارم که از کارفرمای خود کمال رضایت را داشته و در آینده هیچگونه ادعائی نسبت به ایشان در خصوص حق و حقوق و مزایا و غیره در ایام کارکرد خود نداشته  و در صورت طرح هرگونه ادعائی از طرف بنده ، وکیل یا قائم مقام قانونی من ادعای مطروحه قابلیت استماع و ترتیب اثر نخواهد داشت."]
[null,null,null,"محل واریز: حساب شخصی ............................................. کارت خرید حقوقی............................................ کارت هدیه.........................................."]
[null,null,null,"نام و نام خانوادگی: امضا و اثر انگشت:"]

{"sheet":"Print (2)","index":8,"n_rows":43,"n_cols":18,"rows_kept":43,"cut":false,"hidden":true,"merged":[[42,6,42,11],[42,13,42,14],[42,15,42,17],[8,12,8,14],[40,6,40,11],[40,13,40,14],[40,15,40,17],[41,6,41,11],[41,13,41,14],[41,15,41,17],[38,6,38,11],[38,13,38,14],[38,15,38,17],[39,6,39,11],[39,13,39,14],[39,15,39,17],[32,13,32,14],[32,15,33,17],[33,12,42,12],[33,13,33,14],[34,6,34,11],[34,13,34,14],[34,15,34,17],[35,6,35,11],[35,13,35,14],[35,15,35,17],[36,6,36,11],[36,13,36,14],[36,15,36,17],[37,6,37,11],[37,13,37,14],[37,15,37,17],[30,6,30,7],[30,8,30,9],[30,10,30,11],[30,13,30,14],[30,16,30,17],[31,6,31,7],[31,8,31,9],[31,10,31,11],[31,13,31,14],[31,16,31,17],[28,6,28,7],[28,10,28,11],[28,13,28,14],[28,16,28,17],[29,6,29,7],[29,10,29,11],[29,13,29,14],[29,16,29,17],[26,13,26,14],[26,16,26,17],[27,6,27,7],[27,10,27,11],[27,13,27,14],[27,16,27,17],[26,6,26,7],[26,10,26,11],[23,6,23,7],[23,10,23,11],[24,6,24,7],[24,10,24,11],[25,10,25,11],[21,15,21,16],[11,6,11,7],[11,10,11,11],[12,6,12,7],[13,6,13,7],[14,10,14,11],[17,6,17,7],[17,10,17,11],[18,6,18,7],[18,11,19,11],[18,14,19,14],[19,6,19,7],[20,10,20,11],[8,15,8,17],[9,6,9,7],[9,13,9,14],[9,16,9,17],[10,6,10,7],[8,6,8,11],[2,9,2,10],[2,11,2,12],[6,11,6,12],[7,6,7,7],[7,8,7,9]]}
[]
[]
[null,null,null,null,null,null,null,null,null,"اکبر آهنگر",null,"انتخاب شخص:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"شرکت پردازش افق درفک "]
[null,null,null,null,null,null,"ماه: 4",null,"سال مالی: 1396",null,"659-9854443","کد ملی:",102,"کد پرسنلی:",null,"شماره بیمه:",{"$f":"J3","v":"اکبر آهنگر"},"نام و نام خانوادگی:"]
[null,null,null,null,null,null,"اطلاعات عملکردی",null,null,null,null,null,"کسورات عملکردی",null,null,"مزایا ودرآمد"]
[null,null,null,null,null,null,"تعداد پایانه غیر فعال",null,"مبلغ کل","مبلغ","تعداد تراکنش مشمول پرداخت","عنوان ","مبلغ","عنوان",null,"مبلغ","عنوان"]
[null,null,null,null,null,null,null,null,2709020,20,135451,"شبکه",0,"کسورات کیفیت بازرسی","بازرسی",3500000,"حقوق پایه","حقوق ماهیانه"]
[null,null,null,null,null,null,"درصد فعال",null,"فعال","درصد پیشرفت","عنوان ",null,0,"عدم تحقق هفتگی",null,0,"حق اولاد"]
[null,null,null,null,null,null,null,null,0,"98/.76%","بازرسی دوره سوم ","گزارش آماری بازرسی",0,"تاخیر نصب",null,8136000,"بازرسی دوره سوم "]
[null,null,null,null,null,null,null,null,null,null,"بازرسی دوره چهارم",null,0,"کنترل کیفی نصب","بازاریابی و نصب",null,"بازرسی دوره چهارم","بازرسی"]
[null,null,null,null,null,null,"مبلغ کل فعال ","تعداد مشمول پرداخت","تعرفه محاسباتی","درصد پیشرفت","عنوان ",null,0,"کنترل کیفی پروژه",null,null,"مفقودی"]
[null,null,null,null,null,null,8136000,452,18000,"98/.76%","بازرسی دوره سوم ","درآمد بازرسی",0,"تاخیر پشتیبانی",null,450000,"بازاریابی پوز","بازاریابی ونصب"]
[null,null,null,null,null,null,null,null,null,null,"بازرسی دوره چهارم",null,0,"کنترل کیفی پشتیبانی","پشتیبانی و پروژه",1120000,"نصب"]
[null,null,null,null,null,null,"فعالسازی",null,"هفتگی","کنترل کیفی","عنوان ",null,0,"کنترل کیفی پروژه",null,2709020,"کارمزد تراکنش","شبکه"]
[null,null,null,null,null,null,0,null,0,0,"بازرسی دوره سوم ","کسورات بازرسی",0,"تاخیر",null,null,"پروژه","پروژه"]
[null,null,null,null,null,null,0,null,0,0,"بازرسی دوره چهارم",null,0,"تاخیر متوالی",null,2700000,"تشویقی مدیریتی","تشویقی"]
[null,null,null,null,null,null,"کنترل کیفی","تعرفه محاسباتی","تاخیر","تعداد","عنوان ",null,0,"غیبت","عمومی و انضباطی",5000000,"طرح انگیزشی"]
[null,null,null,null,null,null,null,null,null,1,"بازاریابی","بازاریابی و نصب",0,"مرخصی بدون حقوق",null,"ع مزایا و درآمد",null,"مجمو"]
[null,null,null,null,null,null,null,40000,null,28,"نصب",null,0,"عمومی",null,3500000,"انه ","حقوق ماه"]
[null,null,null,null,null,null,"کنترل کیفی",null,"تاخیر","تعداد","عنوان ",null,777650,"بیمه سهم کارمند","قانونی",8136000,null,"بازرسی"]
[null,null,null,null,null,null,0,null,0,0,"پروژه",null,361502,"مالیات",null,1570000,"صب","بازاریابی و ن"]
[null,null,null,null,null,null,null,null,null,null,null,null,3615020]
[null,null,null,null,null,null,"کنترل کیفی",null,"تاخیر","تعداد","عنوان ",null,null,"مجموع کسورات",null,2709020,"شبکه"]
[null,null,null,null,null,null,0,null,0,0,"کسورات پشتیبانی",null,0,"بازرسی",null,0,"پروژه"]
[null,null,null,null,null,null,"تعداد روز سهم کارمند",null,"تعداد روز سهم کارفرما","تعداد روز بیمه","عنوان ",null,0,"بازاریابی و نصب",null,7700000,"تشویقی"]
[null,null,null,null,null,null,0,null,31,31,"بیمه",null,0,"پشتیبانی و پروژه",null,23615020,"مبلغ ناخالص عملکرد"]
[null,null,null,null,null,null,"قیمت",null,"تعداد تعرفه محاسباتی",null,"عنوان ",null,0,"عمومی و انضباطی",null,2555136,"بیمه سهم کارفرما"]
[null,null,null,null,null,null,0,null,null,null,"غیبت",null,1139152,"قانونی",null,26170156,"مجموع هزینه ای شرکت"]
[null,null,null,null,null,null,"تعرفه محاسباتی","تاخیر متوالی ","قیمت","تعرفه محاسباتی","تعداد","عنوان ",1139152,"مجموع کسورات"]
[null,null,null,null,null,null,0,0,null,0,0,"تاخیر"]
[null,null,null,null,null,null,"فرم تسویه حساب",null,null,null,null,null,null,null,null,"حسابداری"]
[null,null,null,null,null,null,"اینجانب ............................................................. بابت تمامی مدت کارکرد خود تا تاریخ ........................................................ نزد شرکت پردازش افق درفک وفق قانون و مقررات قانون کار تمامی حق السعی و حق سنوات و عیدی و غیره را مستند به ماده 34 قانون کار دریافت نموده و با امضا ذیل این گواهی اعلام میدارم که از کارفرمای خود کمال رضایت را داشته و در آینده هیچگونه ادعائی نسبت به ایشان در خصوص حق و حقوق و مزایا و غیره در ایام کارکرد خود نداشته  و در صورت طرح هرگونه ادعائی از طرف بنده ، وکیل یا قائم مقام قانونی من ادعای مطروحه قابلیت استماع و ترتیب اثر نخواهد داشت.",null,null,null,null,null,null,23615020,null,"مبلغ ناخالص عملکرد"]
[null,null,null,null,null,null,"محل واریز: حساب شخصی ............................................. کارت خرید حقوقی............................................ کارت هدیه..........................................",null,null,null,null,null,null,1139152,null,"مجموع کسورات"]
[null,null,null,null,null,null,"نام و نام خانوادگی: امضا و اثر انگشت:",null,null,null,null,null,null,2000000,null,"کسر مساعده با ارزیابی پرداخت شده طی دوره"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3000000,null,"کسر اقساط وام"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مانده از فیش قبل"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,17475868,null,"خالص قابل پرداخت "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مبلغ تائید شده جهت پرداخت"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مانده انتقالی به فیش بعد"]

{"sheet":"Sheet1","index":9,"n_rows":16,"n_cols":26,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,25],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,8,3,8],[2,20,3,20],[2,9,3,9],[2,10,3,10],[2,11,3,11],[2,12,3,12],[2,13,3,13],[2,14,3,14],[2,15,3,15],[2,16,3,16],[2,17,3,17],[2,18,3,18],[2,25,3,25],[2,19,3,19],[2,21,3,21],[2,22,3,22],[2,23,3,23],[2,24,3,24]]}
[null,"محاسبات قانونی"]
[]
["نام","ساعت کارکرد","اضافه کار","کسر کار","مرخصی ساعتی","روز کارکرد","مرخصی استحقاقی","مرخصی استعلاجی","مرخصی بدون حقوق","حقوق پایه قانونی 31 روز","مبلغ توافقی ماهانه","مبلغ ساعتی","مبلغ اضافه کاری","حق مسکن","بن کارگری","حق اولاد","حق ماموریت","کمک هزینه پوشاک","ایاب و ذهاب","جمع حقوق و مزایا مشمول مالیات","جمع حقوق و مزایا مشمول بیمه","بیمه سهم کارگر","مساعده","اقسات","مالیات","خالص قابل پرداخت"]
[]
["پدیدار",0,0,null,null,31,null,null,0,9609287,50000000,0,0,0,0,null,null,null,null,null,null,0,0,0,0,{"$f":"SUM(K5:U5)-SUM(V5:Y5)","v":50000000}]
["سحر خاکسار",225,{"$f":"B6-192","v":33},null,null,31,null,null,0,9609287,18000000,{"$f":"K6/192","v":93750},{"$f":"L6*C6","v":3093750},null,null,null,null,null,null,null,null,777650,null,null,0,{"$f":"SUM(K6:U6)-SUM(V6:Y6)","v":20409850}]
["سعید صحرایی",253,61,null,null,31,3,null,0,9609287,14000000,0,11429112,null,null,929931,null,null,null,null,null,777650,8500000,3000000,0,14081393]
["مهتاش فداکار",150,0,null,null,31,5,null,0,9609287,21000000,{"$f":"K8/192","v":109375},{"$f":"L8*C8","v":0},null,null,null,null,null,null,null,null,777650,null,null,0,20331725]
["کبری شاه مرادی",218,20,null,null,21,null,null,0,6509517,12000000,{"$f":"K9/192","v":62500},1250000,null,null,null,null,null,null,null,null,777650,null,null,0,12534850]
["فرزانه مشهدی",0,0,null,null,31,null,null,0,"ساعتی",{"$f":"L10*B10","v":0},42289,0,null,null,null,null,null,null,null,null,null,null,null,0,0]
["میعاد نخعی",221,29,null,null,31,null,null,0,8369379,20000000,{"$f":"K11/192","v":104166.66666666667},3020833.3333333335,null,null,null,null,null,null,null,null,777650,null,null,0,22347350]
["نوروزی",172,0,null,null,31,1,null,0,9609287,11109287,42289,0,null,null,null,null,null,null,null,null,777650,null,2000000,0,8373926]
["محمد آهنگر",0,0,null,null,31,null,null,0,9609287,14000000,null,12407696,null,null,null,null,null,null,null,null,777650,null,null,0,25630046]
["میثم همتی",196,4,null,null,20,null,null,null,9609287,16000000,{"$f":"K14/192","v":83333.333333333328},333333.33333333331,null,null,null,null,null,null,null,null,0,null,null,null,16416666.666666668]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z5:Z14)","v":190125806.66666666}]

{"sheet":"Sheet2","index":10,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[28,2,28,9],[29,2,29,9],[1,1,1,11],[2,5,2,6],[10,2,10,9],[11,2,11,9],[16,1,16,11],[17,5,17,6]]}
[]
[null,"کارمزد فصل چهارم بازرسی دفتر تهران"]
[null,null,"تراکنش",null,null,"فسخ",null,"نصب","بازاریابی","ورود به نمایندگی"]
[null,"پیمان قبادی",228458,null,null,null,15,46,{"$f":"SUM(amaliati!BT13)","v":900000},2]
[null,"حسین قاسمی",152075,null,null,null,17,29,0,2]
[null,"علیرضا ناجی",228555,null,null,null,0,35,{"$f":"SUM(amaliati!BS16)","v":900000}]
[null,"فرشاد پاشایی",202361,null,null,null,22,41,{"$f":"SUM(amaliati!BR6:BT6)","v":2750000},2]
[null,"مهران غریبی",246153,null,null,null,20,44,{"$f":"SUM(amaliati!BR12:BT12)","v":1650000}]
[null,"جمع نهایی",null,null,null,null,{"$f":"SUM(G4:G8)","v":74},{"$f":"SUM(H4:H8)","v":195},null,{"$f":"SUM(J4:J8)","v":6}]
[null,"مبلغ",{"$f":"SUM(C4:C8)*20","v":21152040},null,null,null,{"$f":"G9*25000","v":1850000},{"$f":"SUM(H4:H8)*45000","v":8775000},{"$f":"SUM(I4:I8)","v":6200000},{"$f":"J9*20000","v":120000}]
[null,"جمع نهایی",{"$f":"SUM(C10:J10)","v":38097040}]
[null,0.3,{"$f":"C11*30%","v":11429112}]
[]
[]
[]
[]
[null,"کارمزد فصل چهارم بازرسی دفتر'گیلاوند"]
[null,null,"تراکنش",null,null,"فسخ",null,"نصب","بازاریابی","ورود به نمایندگی"]
[null,"اکبر آهنگر",159778,null,null,null,17,25,{"$f":"SUM(amaliati!BR5:BT5)","v":1100000}]
[null,"بهزاد اسکندری",126491,null,null,null,18,28,{"$f":"SUM(amaliati!BR4:BT4)","v":900000}]
[null,"بهمن طهماسبی",104787,null,null,null,10,18,{"$f":"SUM(amaliati!BR11:BT11)","v":550000}]
[null,"پوریا شهرآشوب",93829,null,null,null,17,22,{"$f":"SUM(amaliati!BR10:BT10)","v":750000}]
[null,"حامد میرشاه مرادی",219271,null,null,null,6,32,{"$f":"SUM(amaliati!BR9:BT9)","v":900000}]
[null,"سید مهدی حسینی",184641,null,null,null,21,26,{"$f":"SUM(amaliati!BR15:BT15)","v":2050000},1]
[null,"شایان قدیمی",152348,null,null,null,14,31,{"$f":"SUM(amaliati!BR14:BT14)","v":100000}]
[null,"علیرضا چکوری",165054,null,null,null,0,0,{"$f":"SUM(amaliati!BR7:BT7)","v":100000}]
[null,"جمع",{"$f":"SUM(C19:C26)","v":1206199},null,null,null,{"$f":"SUM(G19:G26)","v":103},{"$f":"SUM(H19:H26)","v":182},null,{"$f":"SUM(J24)","v":1}]
[null,"مبلغ",{"$f":"C27*20","v":24123980},null,null,null,{"$f":"G27*25000","v":2575000},{"$f":"H27*45000","v":8190000},{"$f":"SUM(I19:I27)","v":6450000},{"$f":"J27*20000","v":20000}]
[null,"جمع نهایی",{"$f":"SUM(C28:J28)","v":41358980}]
[null,"30 درصد",{"$f":"C29*30%","v":12407694}]