{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Sheet1"],"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":"Sheet1","index":0,"n_rows":56,"n_cols":9,"rows_kept":56,"cut":false,"hidden":false,"merged":[[55,3,55,4],[55,5,55,6],[53,3,53,4],[53,5,53,6],[54,1,54,2],[54,3,54,4],[54,5,54,6],[51,3,51,4],[51,5,51,6],[52,1,52,2],[52,3,52,4],[52,5,52,6],[49,3,49,4],[49,5,49,6],[50,1,50,2],[50,3,50,4],[50,5,50,6],[47,3,47,4],[47,5,47,6],[48,1,48,2],[48,3,48,4],[48,5,48,6],[45,5,45,6],[46,1,46,2],[46,3,46,4],[46,5,46,6],[34,0,34,2],[34,3,34,4],[45,1,45,2],[45,3,45,4],[28,0,28,2],[32,0,32,2],[32,3,32,4],[33,0,33,2],[33,3,33,4],[21,0,21,1],[22,0,22,1],[26,0,26,2],[27,0,27,2],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1]],"flags":["formulas_cached_only"]}
["Предприятие  Общество с ограниченной ответственностью \"Ромашка\""]
["Сотрудник: Иванова Мария Ивановна, таб. №: 0000000017"]
["Документ: Больничный лист №1111111-И01 от 08.01.11"]
["Причина нетрудоспособности: (05) Отпуск по беременности и родам"]
["Начало: 08.01.11 Окончание: 27.05.11"]
[" "]
[]
[]
["1. Начисления за расчетный период. Иванова Мария Ивановна, Основное подразделение, Бухгалтер"]
["Месяц",null,"Заработок","Дней расчетного периода","Отработано дней","Норма дней"]
["Декабрь 2010 г.",null,24212,"31","31","31"]
["Ноябрь 2010 г.",null,24212,"30","30","30"]
["Октябрь 2010 г.",null,24212,"31","31","31"]
["Сентябрь 2010 г.",null,2201.09,"2","2","30"]
["Август 2010 г.",null,24212,"31","31","31"]
["Июль 2010 г.",null,22011,"31","31","31"]
["Июнь 2010 г.",null,22011,"30","30","30"]
["Май 2010 г.",null,9066.32,"17","17","31"]
["Апрель 2010 г.",null,19140,"30","30","30"]
["Март 2010 г.",null,17400,"31","31","31"]
["Февраль 2010 г.",null,17400,"28","28","28"]
["Январь 2010 г.",null,17400,"31","31","31"]
["ИТОГО:",null,223477.41,"323","323","365"]
[]
[]
["2. Премии, начисленные в расчетном периоде"]
["Вид премии",null,null,"Начислено премии","Учтено премий"]
["Прочие премии пропорц.",null,null,9685,9685]
["ИТОГО:",null,null,9685,9685]
[]
[]
["3. Расчет среднего заработка"]
["Всего заработка (включая премии)",null,null,233162.41,233162.41]
["Всего дней в расчетном периоде",null,null,323,323]
["Средний заработок составил:",null,null,"233 162.41 / 323 = 721.87"]
[]
["4. Расчет суммы к начислению"]
["Процент оплаты пособия = 100"]
["№ п/п","Начало периода болезни","Окончание периода болезни","Дневное пособие с учетом процента оплаты","Размер дневного пособия для доходов, облагаемых налогом на прибыль","Дней всего","Дней оплачиваемых за счет ФСС","Пособие за счет ФСС","Всего начислено"]
["1","08.01.11","31.01.11","721.87","721.87","24","24","17324.88","17324.88"]
["2","01.02.11","28.02.11","721.87","721.87","28","28","20212.36","20212.36"]
["3","01.03.11","31.03.11","721.87","721.87","31","31","22377.97","22377.97"]
["4","01.04.11","30.04.11","721.87","721.87","30","30","21656.1","21656.1"]
["5","01.05.11","27.05.11","721.87","721.87","27","27","19490.49","19490.49"]
[]
["Период","Сумма к начислению",null,"Фактически начислено в ЖР",null,"Расхождение"]
["с 08.01.11 по 31.01.11\n ",17324.88,17324.88,17324.88,17324.88]
[null,null,null,17324.88,17324.88,0,0]
["с 01.02.11 по 28.02.11\n ",20212.36,20212.36,20212.36,20212.36]
[null,null,null,20212.36,20212.36,0,0]
["с 01.03.11 по 31.03.11\n ",22377.97,22377.97,22377.97,22377.97]
[null,null,null,22377.97,22377.97,0,0]
["с 01.04.11 по 30.04.11\n ",21656.1,21656.1,21656.1,21656.1]
[null,null,null,21656.1,21656.1,0,0]
["с 01.05.11 по 27.05.11\n ",19490.49,19490.49,19490.49,19490.49]
[null,null,null,19490.49,19490.49,0,0]