{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Сократов Гомер Врубелевич","Петров Петр Петрович","Сидоров Сидор Сидорович","Иванов Иван Иванович","Заполнить","Расчетный лист_аванс","Расчетный лист_зарплата"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"Сократов Гомер Врубелевич","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Петров Петр Петрович","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Сидоров Сидор Сидорович","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Иванов Иван Иванович","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Заполнить","index":4,"n_rows":32,"n_cols":29,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,22,0,23]]}
["№п/п","Дата приема на работу","ФИО","День рождения","Должность","карточка №","Общий фонд","Оклад бух.","Задолженность с прошлого месяца","Отработано дней","аванс 05 - 10 числа","банк","К-во дней отпуска","Отпускные","К доплате 05 - 10 числа следующего месяца","План продаж на месяц","Продажи за месяц","Выполнение плана","бонусы","Премия","штрафы и удержания","Оплатить до 05 - 10 числа следующего месяца","В расчетный листок",null,"Задолженность    +компании / -сотрудника","Л.План","Суп.план","П","С.П."]
[1,null,"Иванов Иван Иванович",null,"Ген. директор",null,10000,5000,null,23,4000,{"$f":"H2-H2*0.13","v":4350},10,5000,{"$f":"G2-I2-K2-L2+N2","v":6650},null,null,null,500,500,100,{"$f":"O2+S2+T2-U2","v":7550},{"$f":"G2+N2+S2+T2","v":16000},{"$f":"I2+U2","v":100}]
[2,null,"Сидоров Сидор Сидорович",null,"Главный бухгалтер",null,10000,5000,1000,23,4000,{"$f":"H3-H3*0.13","v":4350},null,null,{"$f":"G3-I3-K3-L3+N3","v":650},null,null,null,null,null,null,{"$f":"O3+S3+T3-U3","v":650},{"$f":"K3+L3+N3+O3+S3+T3-I3-U3","v":8000},{"$f":"I3+U3","v":1000}]
[3,null,"Петров Петр Петрович",null,"Бухгалтер",null,10000,5000,null,23,4000,4350,null,null,1650,null,null,null,null,null,null,1650,10000,0]
[4,null,"Сократов Гомер Врубелевич",null,null,null,10000,5000,null,null,4000,4350,null,null,1650,null,null,null,null,null,null,1650,10000,0]
[5,null,null,null,"Менеджер",null,10000,5000,null,23,4000,4350,null,null,{"$f":"G6-I6-K6-L6+N6","v":1650},null,null,null,null,null,null,{"$f":"O6+S6+T6-U6","v":1650},{"$f":"I6+K6+L6+O6+S6+T6","v":10000},0]
[6,null,null,null,"Менеджер",null,10000,5000,null,23,4000,4350,null,null,{"$f":"G7-I7-K7-L7+N7","v":1650},null,null,null,null,null,null,{"$f":"O7+S7+T7-U7","v":1650},10000,0]
[7,null,null,null,"Менеджер",null,10000,5000,null,23,4000,4350,null,null,1650,null,null,null,null,null,null,1650,10000,0]
[8,null,null,null,"Менеджер",null,10000,5000,1000,23,4000,4350,null,null,{"$f":"G9-I9-K9-L9+N9","v":650},null,null,null,null,null,null,650,10000,1000]
[9,null,null,null,"Менеджер",null,10000,5000,null,23,4000,4350,null,null,{"$f":"G10-I10-K10-L10+N10","v":1650},null,null,null,null,null,null,{"$f":"O10+S10+T10-U10","v":1650},10000,0]
[10,null,null,null,"Рук.от.продаж",null,10000,5000,null,23,4000,4350,null,null,1650,null,null,null,null,null,null,{"$f":"O11+S11+T11-U11","v":1650},10000,0]
[11,null,null,null,null,null,10000,5000,null,23,4000,4350,null,null,1650,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,10000,5000,null,23,4000,4350,null,null,1650,null,null,null,null,null,null,{"$f":"O13+S13+T13-U13","v":1650},{"$f":"I13+K13+L13+O13+S13+T13","v":10000},0]
[13,null,null,null,"Начальник склада",null,10000,5000,1000,23,4000,4350,null,null,650,null,null,null,null,null,null,{"$f":"O14+S14+T14-U14","v":650},{"$f":"I14+K14+L14+O14+S14+T14","v":10000},1000]
[14,null,null,null,"Кладовщик",null,10000,5000,null,23,4000,4350,null,null,1650,null,null,null,null,null,null,1650,{"$f":"I15+K15+L15+O15+S15+T15","v":10000},0]
[15,null,null,null,"Кладовщик",null,10000,5000,1000,23,4000,4350,null,null,650,null,null,null,null,null,2000,-1350,{"$f":"I16+K16+L16+O16+S16+T16","v":10000},3000]
[16,null,null,null,null,null,10000,5000,null,23,4000,4350,null,null,1650,null,null,null,null,null,null,1650,{"$f":"I17+K17+L17+O17+S17+T17","v":10000},0]
[17,null,null,null,null,null,10000,5000,1000,23,4000,4350,null,null,650,null,null,null,null,null,null,650,10000,1000]
[18,null,null,null,null,null,10000,5000,null,23,4000,4350,null,null,1650,null,null,null,null,null,null,1650,10000,0]
[19,null,null,null,"Водитель",null,10000,5000,null,23,4000,null,null,null,6000,null,null,null,null,null,null,6000,10000,0]
[20,null,null,null,"Уборщица",null,10000,null,null,null,null,null,null,null,{"$f":"G21-I21-K21-L21","v":10000},null,null,null,null,null,null,10000,10000,0]
[]
[null,null,"ИТОГО",null,null,null,{"$f":"SUM(G2:G21)","v":200000},{"$f":"SUM(H2:H21)","v":95000},null,null,{"$f":"SUM(K2:K22)","v":76000},{"$f":"SUM(L2:L22)","v":78300},null,null,{"$f":"SUM(O2:O22)","v":45700},0,0,0,500,500,2100,42950,194000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L23:U23)","v":127100}]
[null,null,"Налоги с ЗП"]
[null,null,"НДФЛ",null,null,null,null,0.13,{"$f":"H23*H26","v":12350}]
[null,null,"ПФР",null,null,null,null,0.22,{"$f":"H23*H27","v":20900}]
[null,null,"ФСС",null,null,null,null,2.9000000000000001E-2,{"$f":"H23*H28","v":2755}]
[null,null,"НС и ПЗ",null,null,null,null,2E-3,{"$f":"H23*H29","v":190}]
[null,null,"ФОМС",null,null,null,null,5.0999999999999997E-2,{"$f":"H23*H30","v":4845}]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I26:I31)","v":41040}]

{"sheet":"Расчетный лист_аванс","index":5,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,0,2,3]]}
["Расчетный листок за ",{"$f":"[1]август_2016!#REF!","v":{"$error":"#REF!"}}]
["ФИО",{"$f":"Заполнить!C2","v":"Иванов Иван Иванович"}]
["Начислено"]
[]
["Оклад",{"$f":"Заполнить!G2","v":10000},"Аванс",{"$f":"Заполнить!K2","v":4000}]
[]
[]
[]
["Всего начислений",{"$f":"SUM(B5:B8)","v":10000},"Всего удержаний"]
[]
["Сумма к выплате",{"$f":"D5","v":4000}]

{"sheet":"Расчетный лист_зарплата","index":6,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"Расчетный листок за ",{"$f":"[1]август_2016!#REF!","v":{"$error":"#REF!"}}]
[1,{"$f":"[1]август_2016!C2","v":"Лось Кирилл Владимирович"}]
[null,"Начислено",null,"Удержано"]
[]
[null,"Оклад",{"$f":"Заполнить!G2","v":10000},"Аванс",{"$f":"Заполнить!K2","v":4000}]
[null,"Премия",{"$f":"Заполнить!T2","v":500},"Оклад на карточку",{"$f":"Заполнить!L2","v":4350}]
[null,"Бонус",{"$f":"Заполнить!S2","v":500},"Штрафы и др. удержания",{"$f":"Заполнить!U2","v":100}]
[null,"Отпускные",{"$f":"Заполнить!N2","v":5000},"Погашение задолженности",{"$f":"Заполнить!I2","v":0}]
[null,"Всего начислений",{"$f":"SUM(C5:C8)","v":16000},"Всего удержаний",{"$f":"SUM(E5:E8)","v":8450}]
[]
[null,"Сумма к выплате",{"$f":"C9-E9","v":7550}]