{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["из 11","январь"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"из 11","index":0,"n_rows":51,"n_cols":25,"rows_kept":51,"cut":false,"hidden":false,"merged":[[11,5,11,6],[12,5,12,6],[3,2,4,2],[0,3,0,4],[1,24,1,25],[5,5,5,6],[6,5,6,6],[7,5,7,6],[25,11,33,24],[21,5,21,6],[22,5,22,6],[4,5,4,6],[3,3,3,6],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[13,5,13,6],[14,5,14,6],[8,5,8,6],[15,5,15,6],[16,5,16,6],[9,5,9,6],[10,5,10,6]]}
[null,null,"ФЕВРАЛЬ",2011]
[]
[]
[null,null,"должность","оклад",null,null,null,null,null,null,null,"-13%",0.3,"ШР","ШР",0.3,"-13%",null,-0.13,0.3,"ШР","ШР",0.3,-0.13]
[null,null,null,"шт.расп.",0.3,"-НДФЛ",null,null,null,null,null,{"$f":"M5*0.87","v":9579.57},{"$f":"N5*1.3","v":11011},{"$f":"CEILING(O5,10)","v":8470},8461.5400000000009,{"$f":"O5*1.3","v":11000.002000000002},{"$f":"P5*0.87","v":9570.0017400000015},null,9500,{"$f":"S5/0.87","v":10919.540229885057},{"$f":"T5/1.3","v":8399.6463306808128},{"$f":"CEILING(U5,10)","v":8400},{"$f":"V5*1.3","v":10920},{"$f":"W5*0.87","v":9500.4},{"$f":"X5","v":9500.4}]
[null,null,"директор",21930,{"$f":"D6*1.3","v":28509},{"$f":"E6*0.87","v":24802.829999999998},null,null,null,null,null,10450.44,12012,9240,9230.77,12000.001,10440.00087,null,{"$f":"S5+500","v":10000},11494.252873563219,8841.7329796640133,8850,11505,10009.35,10009.35]
[null,null,"зам.дир.",16000,20800,18096,null,null,null,null,null,11310,13000,10000,10000,13000,11310,null,10500,12068.965517241379,9283.8196286472139,9290,12077,10506.99,10506.99]
[null,null,"маркетолог",16000,20800,18096,null,null,null,null,null,12180.87,14001,10770,10769.23,13999.999,12179.99913,null,11000,12643.67816091954,9725.9062776304163,9730,12649,11004.63,11004.63]
[null,null,"гл.бух",15000,19500,16965,null,null,null,null,null,13051.74,15002,11540,11538.46,14999.998,13049.99826,null,11500,13218.3908045977,10167.992926613615,10170,13221,11502.27,11502.27]
[null,null,"бух",14500,18850,16399.5,null,null,null,null,null,13922.61,16003,12310,12307.69,15999.997000000001,13919.99739,null,12000,13793.103448275862,10610.079575596817,10620,13806,12011.22,12011.22]
[null,null,"секретарь",13200,17160,14929.2,null,null,null,null,null,14793.48,17004,13080,13076.92,16999.995999999999,14789.996519999999,null,12500,14367.816091954022,11052.166224580016,11060,14378,12508.86,12508.86]
[null,null,"логист",11530,14989,13040.43,null,null,null,null,null,15664.35,18005,13850,13846.15,17999.994999999999,15659.995649999999,null,13000,14942.528735632184,11494.252873563219,11500,14950,13006.5,13006.5]
[null,null,"нач. оптовик",15248,19822.400000000001,17245.488000000001,null,null,null,null,null,16535.22,19006,14620,14615.39,19000.007000000001,16530.006090000003,null,13500,15517.241379310344,11936.339522546417,11940,15522,13504.14,13504.14]
[null,null,"оптовик",12180,15834,13775.58,null,null,null,null,null,17406.09,20007,15390,15384.62,20000.006000000001,17400.005220000003,null,14000,16091.954022988506,12378.42617152962,12380,16094,14001.78,14001.78]
[null,null,"нач. розницы",13480,17524,15245.88,null,null,null,null,null,18276.96,21008,16160,16153.85,21000.005000000001,18270.004349999999,null,14500,16666.666666666668,12820.51282051282,12830,16679,14510.73,14510.73]
[null,null,"розница",8450,10985,9556.9500000000007,null,null,null,null,null,19147.829999999998,22009,16930,16923.080000000002,22000.004000000004,19140.003480000003,null,15000,17241.379310344826,13262.599469496019,13270,17251,15008.37,15008.37]
[null,null,"тех.специалист",11200,14560,12667.2,null,null,null,null,null,20018.7,23010,17700,17692.310000000001,23000.003000000004,20010.002610000003,null,15500,17816.091954022988,13704.686118479221,13710,17823,15506.01,15506.01]
[null,null,"нач. склада",14160,18408,16014.96,null,null,null,null,null,20889.57,24011,18470,18461.54,24000.002,20880.00174,null,16000,18390.80459770115,14146.772767462422,14150,18395,16003.65,16003.65]
[null,null,"склад",12480,16224,14114.88,null,null,null,null,null,21760.44,25012,19240,19230.77,25000.001,21750.00087,null,16500,18965.517241379312,14588.859416445624,14590,18967,16501.29,16501.29]
[null,null,"нач. ИТ",20460,26598,23140.26,null,null,null,null,null,22620,26000,20000,20000,26000,22620,null,17000,19540.22988505747,15030.946065428823,15040,19552,17010.240000000002,17010.240000000002]
[null,null,"ИТ",null,0,0,null,null,null,null,null,23490.87,27001,20770,20769.23,26999.999,23489.99913,null,17500,20114.942528735632,15473.032714412024,15480,20124,17507.88,17507.88]
[null,null,"водитель",6000,7800,6786,null,null,null,null,null,null,null,null,{"$f":"P22/1.3","v":20769.23076923077},27000]
[null,null,"уборщица",5800,7540,6559.8]
[null,null,"дворник",null,777]
[]
[null,null,"ОТПУСКНЫЕ",null,"сумма выплат","дневной заработок","дневной заработок",null,null,null,null,"Расчет отпускных в ситуации, когда все 12 месяцев отработаны полностью. Формула следующая:\nСредний дневной заработок = Сумма учитываемых в расчетном периоде выплат ÷ 29,4 × 12 месяцев.\nРасчет отпускных в ситуации, когда расчетный период отработан частично. В этом случае нужно применять другую формулу:\nСредний дневной заработок = Сумма учитываемых в расчетном периоде выплат ÷ (29,4 × Количество полностью отработанных в расчетном периоде месяцев + Количество календарных дней во всех неполных месяцах).\nПри этом количество календарных дней в каждом неполном месяце определяется определяется следующим образом:\nКоличество дней в каждом неполном месяце = 29,4 : Количество календарных дней в месяце, отработанном не полностью х Количество календарных дней, приходящихся на отработанное в данном месяце время.\nПодсчитав средний дневной заработок, его остается лишь умножить на количество календарных дней отпуска работника. На этом расчет отпускных закончен."]
[null,null,"Луговской",null,{"$f":"SUM(E28:E38)","v":206523},{"$f":"E27/11/29.4","v":638.59925788497219},{"$f":"E27/353/11*12","v":638.23744527427243}]
[null,null,null,"2010-06-01",13092,1,null,28,{"$f":"$G$27*H28","v":17870.648467679628}]
[null,null,null,"2010-07-01",16450,{"$f":"F28+1","v":2},null,null,{"$f":"H28*F27","v":17880.779220779223}]
[null,null,null,"2010-08-01",18040,{"$f":"F29+1","v":3}]
[null,null,null,"2010-09-01",18040,4]
[null,null,null,"2010-10-01",18040,5]
[null,null,null,"2010-11-01",17400,6]
[null,null,null,"2010-12-01",20400,7]
[null,null,null,"2011-01-01",17452,8]
[null,null,null,"2011-02-01",17452,9,null,null,null,null,null,{"$f":"353/12","v":29.416666666666668},"12 праздничных дней, которые не учитываются при оплате"]
[null,null,null,"2011-03-01",29067,10]
[null,null,null,"2011-04-01",21090,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Терентьева",null,{"$f":"T40*R40","v":31314.572719237702}]
[null,null,"Ермушко2",null,{"$f":"SUM(E41:E51)","v":225606.53228779754},{"$f":"E40/353/F41*12","v":697.21307943692261},28,{"$f":"F40*G40","v":19521.966224233835},null,"Андронников2",null,{"$f":"SUM(L41:L51)","v":184169.33333333334},{"$f":"L40/353/M41*12","v":569.15580736543916},28,{"$f":"M40*N40","v":15936.362606232296},null,null,28,{"$f":"SUM(S41:S51)","v":361888.35080000001},{"$f":"S40/353/T41*12","v":1118.3775971156322}]
[null,null,null,"2010-10-01",18040,{"$f":"F42+1","v":11},null,null,null,null,"2010-10-01",16798,{"$f":"M42+1","v":11},null,null,null,null,"2010-11-01",26723,{"$f":"T42+1","v":11}]
[null,null,null,"2010-11-01",18040,{"$f":"F43+1","v":10},null,null,null,null,"2010-11-01",16775,{"$f":"M43+1","v":10},null,null,null,null,"2010-12-01",33286,10]
[null,null,null,"2010-12-01",14903.434782608696,9,null,null,null,null,"2010-12-01",18776,9,null,null,null,null,"2011-01-01",33097,9]
[null,null,null,"2011-01-01",18092,8,null,null,null,null,"2011-01-01",16828,8,null,null,null,null,"2011-02-01",32805,8]
[null,null,null,"2011-02-01",20002,7,null,null,null,null,"2011-02-01",1802,7,null,null,null,null,"2011-03-01",53008,7]
[null,null,null,"2011-03-01",30302,6,null,null,null,null,"2011-03-01",32402,6,null,null,null,null,"2011-04-01",39596,6]
[null,null,null,"2011-04-01",20002,5,null,null,null,null,"2011-04-01",18902,5,null,null,null,null,"2011-05-01",36709,5]
[null,null,null,"2011-05-01",20002,4,null,null,null,null,"2011-05-01",18903,4,null,null,null,null,"2011-06-01",38154.058649999999,4]
[null,null,null,"2011-06-01",28223.097505188827,3,null,null,null,null,"2011-06-01",6283.3333333333339,3,null,null,null,null,"2011-07-01",34246.004150000001,3]
[null,null,null,"2011-07-01",18050,2,null,null,null,null,"2011-07-01",15850,2,null,null,null,null,"2011-08-01",34264.288,2]
[null,null,null,"2011-08-01",19950,1,null,null,null,null,"2011-08-01",20850,1,null,null,null,null,"2011-09-01",null,1]

{"sheet":"январь","index":1,"n_rows":37,"n_cols":21,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,7],[2,1,3,1],[2,2,3,2]]}
[null,null,"январь",null,2013]
[]
[null,null,"Фамилия Имя Отчество"]
[null,null,null,"надбавка","оклад",null,"налоги","начислено","отпускные",null,"премия",null,"вычеты","ИТОГО","аванс","карта","РКО"]
[null,1,"Андронников "]
[null,2,"Бенюх "]
[null,3,"Горбачев"]
[" ",4,"Добрыгин",3000,25000,null,{"$f":"E8*18%","v":4500},{"$f":"E8+D8-G8","v":23500},null,null,3600,null,1400,{"$f":"E8-G8+I8+K8-M8","v":22700},3400,12340,{"$f":"N8-O8-P8","v":6960}]
[null,5,"Ермушко ",2940,24000,null,{"$f":"E9*18%","v":4320},{"$f":"E9+D9-G9","v":22620},null,null,3700,null,1300,22080,3300,12340,6440]
[null,6,"Жилин",2880,23000,null,4140,21740,null,null,3800,null,1200,21460,3200,12340,5920]
[null,7,"Золотарев",2820,22000,null,3960,20860,null,null,3900,null,1100,20840,3100,12340,5400]
[null,8,"Иванов",2760,21000,null,3780,19980,null,null,4000,null,1000,{"$f":"E12-G12+I12+K12-M12","v":20220},3000,12340,{"$f":"N12-O12-P12","v":4880}]
[null,9,"Кожемякин",2700,20000,null,3600,19100,null,null,4100,null,900,{"$f":"E13-G13+I13+K13-M13","v":19600},2900,12340,{"$f":"N13-O13-P13","v":4360}]
[null,10,"Липатов",2640,19000,null,3420,18220,null,null,4200,null,800,{"$f":"E14-G14+I14+K14-M14","v":18980},2800,12340,{"$f":"N14-O14-P14","v":3840}]
[null,11,"Милов",2580,18000,null,3240,17340,null,null,4300,null,700,18360,2700,12340,3320]
[null,12,"Николаев",2520,17000,null,3060,16460,null,null,4400,null,600,17740,2600,12340,2800]
[null,13,"Оленик",2460,16000,null,2880,15580,null,null,4500,null,500,17120,2500,12340,2280]
[null,14,"Полуэктов",2400,15000,null,2700,14700,null,null,4600,null,400,16500,2400,12340,1760]
[null,15,"Ростов",2340,14000,null,2520,13820,null,null,4700,null,300,15880,2300,12340,1240]
[null,16,"Седов",2280,13000,null,2340,12940,null,null,4800,null,200,15260,2200,12340,720]
[null,17,"Титов"]
[null,18,"Ульянов"]
[null,19,"Филинов"]
[null,20,"Хвостов"]
[null,null,"Итого"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"ведомость за \"&TEXT(C1,0)","v":"ведомость за январь"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Добрыгин"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"начислено",{"$f":"OFFSET(H4,$R$30,0)","v":23500},{"$f":"\"(\"&TEXT(OFFSET(D4,$R$30,0),\"# ##0\")&\" + \"&TEXT(OFFSET(E4,$R$30,0)-OFFSET(G4,$R$30,0),\"# ##0\")&\")\"","v":"(3 000 + 20 500)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"премия:",{"$f":"OFFSET(K4,$R$30,0)","v":3600}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"вычеты:",{"$f":"OFFSET(M4,$R$30,0)","v":1400}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ИТОГО:",{"$f":"OFFSET(N4,$R$30,0)","v":22700}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"из них: аванс:",{"$f":"OFFSET(O4,$R$30,0)","v":3400}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"на карту:",{"$f":"OFFSET(P4,$R$30,0)","v":12340}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"на руки:",{"$f":"OFFSET(Q4,$R$30,0)","v":6960}]