{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Расчет пособия_1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Расчет пособия_1","index":0,"n_rows":74,"n_cols":18,"rows_kept":74,"cut":false,"hidden":false,"merged":[[63,1,63,17],[64,15,64,17],[64,12,64,14],[58,4,58,17],[62,1,62,11],[62,12,62,14],[62,15,62,17],[66,15,66,17],[66,12,66,14],[65,15,65,17],[65,12,65,14],[68,15,68,17],[68,12,68,14],[67,15,67,17],[67,12,67,14],[71,12,71,14],[71,15,71,17],[70,15,70,17],[70,1,70,11],[73,15,73,17],[73,8,73,10],[72,12,72,14],[72,15,72,17],[15,1,15,3],[15,4,15,9],[16,1,16,4],[16,5,16,9],[27,14,27,15],[25,1,25,7],[26,8,26,9],[26,10,26,11],[26,12,26,13],[32,1,32,7],[31,1,31,7],[26,14,26,15],[26,1,26,4],[26,5,26,6],[27,1,27,4],[27,5,27,6],[27,8,27,9],[27,10,27,11],[27,12,27,13],[36,1,36,3],[36,4,36,9],[37,1,37,4],[37,5,37,9],[38,1,38,7],[39,1,39,7],[40,1,40,3],[40,6,40,7],[41,1,41,3],[41,6,41,7],[42,1,42,3],[42,6,42,7],[43,1,43,3],[43,6,43,7],[44,1,44,3],[44,6,44,7],[46,1,46,7],[47,8,47,9],[47,10,47,11],[47,12,47,13],[47,14,47,15],[47,1,47,4],[47,5,47,6],[48,1,48,4],[48,5,48,6],[48,8,48,9],[48,10,48,11],[48,12,48,13],[48,14,48,15],[49,14,49,15],[49,1,49,4],[49,5,49,6],[49,8,49,9],[51,1,51,7],[52,1,52,7],[49,10,49,11],[49,12,49,13],[17,1,17,7],[18,1,18,7],[21,1,21,3],[21,6,21,7],[20,1,20,3],[20,6,20,7],[19,1,19,3],[19,6,19,7],[22,1,22,3],[22,6,22,7],[23,1,23,3],[23,6,23,7],[28,10,28,11],[28,12,28,13],[28,14,28,15],[28,1,28,4],[28,5,28,6],[29,1,29,4],[29,5,29,6],[29,8,29,9],[29,10,29,11],[29,12,29,13],[29,14,29,15],[28,8,28,9],[6,1,6,10],[3,10,4,10],[1,1,1,10],[2,1,2,10],[5,1,5,10],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,5,4,5],[3,6,4,6],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4]],"flags":["formulas_cached_only"]}
[]
[null,"Составляющие среднедневной ставки","Составляющие среднедневной ставки"]
[null,"по сотруднику Иванов Вадим87 ","по сотруднику Иванов Вадим87 "]
[null,"Вид оплаты","Месяц","Сумма","Процент","Ставка","Рабочих дней","Отработано дней","Календарных дней","Больничные","Отпускные"]
[]
[null,"Учреждение : тестовое учреждение","Учреждение : тестовое учреждение"]
[null,"Должность : Бухгалтер ( Штатные сотрудники )","Должность : Бухгалтер ( Штатные сотрудники )"]
[null,"оклад ","Август 2010",6923.08,"V",6923.08,21,21,31,0,0]
[null,"северн","Август 2010",2076.92,"V",2076.92,21,21,31,0,0]
[null,"оклад ","Сентябрь 2010",6923.08,"V",6923.08,22,22,30,0,0]
[null,"северн","Сентябрь 2010",2076.92,"V",2076.92,22,22,30,0,0]
[null,"оклад ","Октябрь 2010",6923.08,"V",6923.08,21,21,31,0,0]
[null,"северн","Октябрь 2010",2076.92,"V",2076.92,21,21,31,0,0]
[]
[]
[null,"БОЛЬНИЧНЫЙ ЛИСТ",null,null,"Иванов Вадим87"]
[null,"c 08.11.2010 по 19.11.2010",null,null,null,"тест"]
[null,"Тип больничного листа: Временная нетрудоспособность  "]
[null,"Примечание: "]
[null,"Месяцы",null,null,"Число кален-дарн. дней","Сумма фактич. заработка","Среднедневная ставка исходя из фактич. заработка"]
[null,"Август 2010 г.  ",null,null,"31.00","9000.00"]
[null,"Сентябрь 2010 г.",null,null,"30.00","9000.00","293.48"]
[null,"Октябрь 2010 г. ",null,null,"31.00","9000.00"]
[null,"Итого:",null,null,"92.00","27000.00"]
[]
[null,"ПРИЧИТАЕТСЯ ПОСОБИЕ"]
[null,"Период",null,null,null,"Дней",null,"%","Средний заработок",null,"Размер дневного пособий, исчисляемого из максимального",null,"Среднее пособие для расчета",null,"Сумма пособия"]
[null,"08.11.2010 - 09.11.2010",null,null,null,"2.00",null,"60.00","293.48",null,"312.72",null,"176.09",null,"352.18"]
[null,"10.11.2010 - 19.11.2010",null,null,null,"10.00",null,"60.00","293.48",null,"312.72",null,"176.09",null,"1760.90"]
[null,"ИТОГО",null,null,null,"12.00",{"$nulls":8},"2113.08"]
[]
[null,"Две тысячи сто тринадцать рублей 08 копеек"]
[null,"Включено в платежную ведомость за ноябрь месяц"]
[]
[]
[]
[null,"БОЛЬНИЧНЫЙ ЛИСТ",null,null,"Иванов Вадим87"]
[null,"c 20.11.2010 по 30.11.2010",null,null,null,"тест"]
[null,"Тип больничного листа: Продолжение больничного       "]
[null,"Примечание: "]
[null,"Месяцы",null,null,"Число кален-дарн. дней","Сумма фактич. заработка","Среднедневная ставка исходя из фактич. заработка"]
[null,"Август 2010 г.  ",null,null,"31.00","9000.00"]
[null,"Сентябрь 2010 г.",null,null,"30.00","9000.00","293.48"]
[null,"Октябрь 2010 г. ",null,null,"31.00","9000.00"]
[null,"Итого:",null,null,"92.00","27000.00"]
[]
[null,"ПРИЧИТАЕТСЯ ПОСОБИЕ"]
[null,"Период",null,null,null,"Дней",null,"%","Средний заработок",null,"Размер дневного пособий, исчисляемого из максимального",null,"Среднее пособие для расчета",null,"Сумма пособия"]
[null,"20.11.2010 - 30.11.2010",null,null,null,"11.00",null,"60.00","293.48",null,"312.72",null,"176.09",null,"1936.99"]
[null,"ИТОГО",null,null,null,"11.00",{"$nulls":8},"1936.99"]
[]
[null,"Одна тысяча девятьсот тридцать шесть рублей 99 копеек"]
[null,"Включено в платежную ведомость за ноябрь месяц"]
[]
[]
[]
[null,"Таб.№",null,"Ранг",null,"Расчетная карточка",{"$nulls":5},"Ноябрь 2010 г.  ",{"$nulls":5},"БАРС"]
[null,"100152",null,"    ",null,"Иванов Вадим87   ( Дети: 0 )"]
[null,"Учреждение: ",null,null,"тестовое учреждение                                              "]
[null,"Больничный: Продолжение больничного        20/11/2010-30/11/2010"]
[null,"Больничный: Временная нетрудоспособность   08/11/2010-19/11/2010"]
[null,"Начисления",{"$nulls":10},"Начислено",null,null,"Удержано"]
[null,"Штатные сотрудники (тест) "]
[null,"Бухгалтер, Контр:1601.00 (Раб.:21д.,Отр.:3д.,Больн.:23д.)"]
[null,"Оклад                         В виде суммы 6923.08( 1.000)",{"$nulls":10},989.01]
[null,"Северные                      30%",{"$nulls":10},296.7]
[null,"Продолжение больничного  11д, 60%, 11.10 (20.11.10)",{"$nulls":10},1936.99]
[null,"Временная нетрудоспособн 10д, 60%, 11.10 (08.11.10)",{"$nulls":10},1760.9]
[null,"Больничные за счет работо 2д, 60%, 11.10 (08.11.10)",{"$nulls":10},352.18]
[null,"Удержания"]
[null,"Подоходный налог               ",{"$nulls":13},642]
[null,"Итого",{"$nulls":10},5335.78,null,null,642]
[null,null,"Сумма к получению",{"$nulls":12},4693.78]
[null,"Взносы в ПФР:",null,null,null,"Страховые",null,null,"[       3780.00]",null,null,"Накопительные",null,null,null,"[       1620.00]"]