{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["Шаблон","Расчет"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"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":"Шаблон","index":0,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,4,45,5],[44,1,44,3],[42,1,42,3],[42,4,42,5],[43,4,43,5],[44,4,44,5],[24,5,24,6],[25,5,25,6],[36,3,36,4],[39,3,39,4],[29,1,29,3],[31,1,31,3],[33,1,33,3],[30,1,30,3],[32,1,32,3],[26,5,26,6],[21,5,21,6],[22,5,22,6],[4,2,4,6],[23,5,23,6],[16,5,16,6],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[1,2,1,5],[0,1,0,5],[14,5,14,6],[15,5,15,6],[6,2,6,4],[3,4,3,6],[5,3,5,4],[8,5,8,6],[12,5,12,6],[13,5,13,6],[27,1,27,3],[28,1,28,3],[7,2,7,4],[9,1,9,3]],"flags":["formulas_cached_only"]}
[null,"Расчет пособия по листку нетрудоспособности"]
[null,null," ООО \"Рога и Копыта\""]
[]
[null,"Регистр. номер","-",null,"Код подчиненности - "]
[null,"ФИО"]
[null,"№ листка нетрудоспособности"]
[null,"ИНН сотруд."]
[null,"СНИЛС сотруд."]
[null,null,"Период  с",null,"по"]
[null,"Кол-во календар. дней нетрудоспособности",null,null,null,"дней"]
[null,"Страховой стаж",null,"лет",null,"мес."]
[null,"Коэффициент зависит от страхового стажа"]
[null,null,"2010 год","2011 год",null,"Примечание"]
[]
["1.","январь",null,null,null,"МРОТ 2011 года"]
["2.","февраль",null,null,null,"4611 руб."]
["3.","март"]
["4.","апрель"]
["5.","май"]
["6.","июнь"]
["7.","июль"]
["8.","август"]
["9.","сентябрь"]
["10.","октябрь"]
["11.","ноябрь"]
["12.","декабрь"]
[null,"ИТОГО:"]
[null,"Средний заработок для исчисления пособия"]
[null,"Средний дневной заработок"]
[null,"Итого начислено пособия"]
[null,"Сумма пособия за счет средств работодат."]
[null,"Сумма пособия за счет средств ФСС"]
[]
[]
[]
[null,"Расчет произвел"]
[null,"Гл. бухгалтер",null,"Иванова Т.С."]
[]
[null,"Расчет проверил"]
[null,"Директор",null,"Сидоров  Л.Д."]
[]
[]
[null,"Коэффициент  страхового стажа",null,null,"8 лет и более",null,1]
[{"$nulls":4},"от 5 до 8 лет",null,0.8]
[null,"менее полугода пособие не более МРОТ за 1 месяц",null,null,"от полугода до 5 лет",null,0.6]
[{"$nulls":4},"по уходу до1,5 лет",null,0.4]

{"sheet":"Расчет","index":1,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[27,1,27,3],[28,1,28,3],[7,2,7,4],[9,1,9,3],[1,2,1,5],[0,1,0,5],[14,5,14,6],[15,5,15,6],[6,2,6,4],[3,4,3,6],[5,3,5,4],[8,5,8,6],[12,5,12,6],[13,5,13,6],[21,5,21,6],[22,5,22,6],[4,2,4,6],[23,5,23,6],[16,5,16,6],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[24,5,24,6],[25,5,25,6],[36,3,36,4],[39,3,39,4],[29,1,29,3],[31,1,31,3],[33,1,33,3],[30,1,30,3],[32,1,32,3],[26,5,26,6],[45,4,45,5],[46,4,46,5],[44,1,44,3],[42,1,42,3],[42,4,42,5],[43,4,43,5],[44,4,44,5]],"flags":["formulas_cached_only"]}
[null,"Расчет пособия по листку нетрудоспособности"]
[null,null," ООО  \"Рога и Копыта\""]
[]
[null,"Регистр. номер","№",null,"Код подчиненности - №"]
[null,"ФИО","Петрова Мария Ибрагимовна"]
[null,"№ листка нетрудоспособности",null,26067836803]
[null,"ИНН сотруд.","№"]
[null,"СНИЛС сотруд.","№"]
[null,null,"Период  с","13.08.2012г","по","2012-08-17"]
[null,"Кол-во календар. дней нетрудоспособности",null,null,5,"дней"]
[null,"Страховой стаж",15,"лет",10,"мес."]
[null,"Коэффициент страхового стажа",null,1]
[null,null,"2010 год","2011 год",null,"Примечание"]
[]
["1.","январь",4611,15000]
["2.","февраль",4611,15000]
["3.","март",4611,15000,null,"МРОТ 2011 год"]
["4.","апрель",4611,15000,null,"с 01.06.11"]
["5.","май",4611,15000,null,"4611 руб."]
["6.","июнь",4611,15000]
["7.","июль",4611,15000]
["8.","август",4611,15000]
["9.","сентябрь",4611,15000]
["10.","октябрь",4611,15000]
["11.","ноябрь",4611,15000]
["12.","декабрь",4611,15000]
[null,"ИТОГО:",55332,180000]
[null,"Средний заработок для исчисления пособия",null,null,235332]
[null,"Средний дневной заработок",null,null,322.37]
[null,"Итого начислено пособия:",null,null,1611.85]
[null,"Сумма пособия за счет средств работодат.",null,null,967.11]
[null,"Сумма пособия за счет средств ФСС",null,null,644.7399999999999]
[]
[]
[]
[null,"Расчет произвел"]
[null,"Гл. бухгалтер",null,"Иванова Т.С."]
[]
[null,"Расчет проверил"]
[null,"Директор",null,"Сидоров Л.Д."]