{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["ССЫЛКИ","СПРАВОЧНИК","сводная","развернутая","по месяцам","Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"comments":1,"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":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["январь",15,null,"ПРАЗДНИКИ"]
["февраль",19,null,"2015-01-01"]
["март",21,null,"2015-01-02"]
["апрель",22,null,"2015-01-05"]
["май",18,null,"2015-01-06"]
["июнь",21,null,"2015-01-07"]
["июль",23,null,"2015-01-08"]
["август",21,null,"2015-02-23"]
["сентябрь",22,null,"2015-03-09"]
["октябрь",22,null,"2015-01-08"]
["ноябрь",20,null,"2015-01-09"]
["декабрь",23,null,"2015-01-08"]
[null,null,null,"2015-02-23"]
[null,null,null,"2015-03-08"]
[null,null,null,"2015-05-01"]
[null,null,null,"2015-05-09"]
[null,null,null,"2015-06-23"]
[null,null,null,"2015-11-04"]

{"sheet":"СПРАВОЧНИК","index":1,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["№","Итоги","ОТДЕЛЕНИЕ","ДОЛЖНОСТЬ","ФИО","ЗАНЯТОСТЬ","ПО ФАКТУ","ОКЛАД С ОБЪЕМОМ РАБОТ","Доплата за ВУТ","ОКЛАД с ВУТ"]
[1,null,"Приемное","Медицинская сестра","ФИО 1","Осн.",1,1000,0,10000]
[2,null,"Хирургия (с пер.)","Операционная медицинская сестра","ФИО 2","Осн.",1,2000,0,{"$f":"H3+(H3*I3)","v":2000}]
[3,null,"Отдел МТО","Водитель автомобиля","ФИО 3","Осн.",1,3000,0,3000]
[20,null,"Отдел МТО","Гардеробщик","ФИО 4","Осн.",1,4000,0,4000]
[151,null,"Неврология","Младшая медицинская сестра по уходу за больными","ФИО 5","Осн.",1,5000,0,5000]
[16,null,"Отдел МТО","Заведующий складом","ФИО 6","Осн.",1,6000,0,6000]
[98,null,"Лаборат. отд.","Лаборант","ФИО 7","Осн.",1,7000,0,7000]
[136,null,"Хирургия (с пер.)","Медицинская сестра перевязочной","ФИО 8","Осн.",1,8000,0,8000]
[234,null,"Терапия (30 к.)","Медицинская сестра палатная (постовая)","ФИО 9","Осн.",1,9000,0,9000]
[6,null,"ФЭО","Бухгалтер","ФИО 10","Осн.",1,10000,0,10000]
[-222,null,"Терапия (30 к.)","Медицинская сестра палатная (постовая)","ФИО 11","Осн.",1,11000,0,{"$f":"H12+(H12*I12)","v":11000}]
[-450,null,"ФЭО","Бухгалтер","ФИО 12","Осн.",1,12000,0,12000]
[-678,null,"Терапия (30 к.)","Медицинская сестра палатная (постовая)","ФИО 13","Осн.",1,13000,0,13000]
[-906,null,"ФЭО","Бухгалтер","ФИО 14","Осн.",1,14000,0,14000]
[-1134,null,"Терапия (30 к.)","Медицинская сестра палатная (постовая)","ФИО 15","Осн.",1,15000,0,15000]
[-1362,null,"ФЭО","Бухгалтер","ФИО 16","Осн.",1,16000,0,16000]
[-1590,null,"Терапия (30 к.)","Медицинская сестра палатная (постовая)","ФИО 17","Осн.",1,17000,0,17000]
[-1818,null,"ФЭО","Бухгалтер","ФИО 18","Осн.",1,18000,0,18000]
[-2046,null,"Терапия (30 к.)","Медицинская сестра палатная (постовая)","ФИО 19","Осн.",1,19000,0,19000]
[-2274,null,"ФЭО","Бухгалтер","ФИО 20","Осн.",1,20000,0,20000]
[-2502,null,"Терапия (30 к.)","Медицинская сестра палатная (постовая)","ФИО 21","Осн.",1,21000,0,21000]
[-2730,null,"ФЭО","Бухгалтер","ФИО 22","Осн.",1,22000,0,22000]
[-2958,null,"Терапия (30 к.)","Медицинская сестра палатная (постовая)","ФИО 23","Осн.",1,23000,0,23000]
[-3186,null,"ФЭО","Бухгалтер","ФИО 24","Осн.",1,24000,0,24000]
[-3414,null,"Терапия (30 к.)","Медицинская сестра палатная (постовая)","ФИО 25","Осн.",1,25000,0,25000]
[-3642,null,"ФЭО","Бухгалтер","ФИО 26","Осн.",1,26000,0,26000]
[-3870,null,"Терапия (30 к.)","Медицинская сестра палатная (постовая)","ФИО 27","Осн.",1,27000,0,27000]
[-4098,null,"ФЭО","Бухгалтер","ФИО 28","Осн.",1,28000,0,28000]
[-4326,null,"Терапия (30 к.)","Медицинская сестра палатная (постовая)","ФИО 29","Осн.",1,29000,0,29000]
[-4554,null,"ФЭО","Бухгалтер","ФИО 30","Осн.",1,30000,0,30000]
[-4782,null,"Терапия (30 к.)","Медицинская сестра палатная (постовая)","ФИО 31","Осн.",1,31000,0,31000]

{"sheet":"сводная","index":2,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,4,2,5]]}
[null,null,null,null,null,null,null,"Приложение к приказу № от \"____\" ___________ 2015г."]
[]
["№ п/п","СОТРУДНИК","ДОЛЖНОСТЬ","ОТДЕЛЕНИЕ","ПЕРИОД",null,"ОБЪЕМ РАБОТЫ","СУММА"]
[null,2,3,null,4,5,7,10]
[{"$f":"IF(B5=\"\",\"\",SUBTOTAL(3,B5)*(MAX(A$4:A4)+1))","v":1},"ФИО 1",{"$f":"IF(B5=\"\",\"\",INDEX(МАССИВ,MATCH(B5,ФИО,0),3))","v":"Медицинская сестра"},{"$f":"IF(B5=\"\",\"\",INDEX(МАССИВ,MATCH(B5,ФИО,0),2))","v":"Приемное"},"2014-12-12","2015-01-31",1,{"$f":"IF(B5=\"\",\"\",ROUND(((IF(B5=\"\",\"\",INDEX(МАССИВ,MATCH(B5,ФИО,0),9)))*(IF(B5=\"\",\"\",MONTH(F5)-MONTH(E5)+1+(YEAR(F5)-YEAR(E5))*12))*G5/(IF(B5=\"\",\"\",NETWORKDAYS.INTL(EOMONTH(E5,-1)+1,EOMONTH(F5,0),1,ПРАЗДНИКИ)))*(IF(B5=\"\",\"\",NETWORKDAYS.INTL(E5,F5,1,ПРАЗДНИКИ)))),-2))","v":15300}]
[{"$f":"IF(B6=\"\",\"\",SUBTOTAL(3,B6)*(MAX(A$4:A5)+1))","v":2},"ФИО 2","Операционная медицинская сестра","Хирургия (с пер.)","2015-02-01","2015-02-28",0.5,1000]
[{"$f":"IF(B7=\"\",\"\",SUBTOTAL(3,B7)*(MAX(A$4:A6)+1))","v":3},"ФИО 3","Водитель автомобиля","Отдел МТО","2015-03-01","2015-03-31",1,3000]
[{"$f":"IF(B8=\"\",\"\",SUBTOTAL(3,B8)*(MAX(A$4:A7)+1))","v":4},"ФИО 4","Гардеробщик","Отдел МТО","2015-01-01","2015-02-28",1,8000]
[{"$f":"IF(B9=\"\",\"\",SUBTOTAL(3,B9)*(MAX(A$4:A8)+1))","v":5},"ФИО 5","Младшая медицинская сестра по уходу за больными","Неврология","2015-01-01","2015-01-31",1,5000]
[{"$f":"IF(B10=\"\",\"\",SUBTOTAL(3,B10)*(MAX(A$4:A9)+1))","v":6},"ФИО 6","Заведующий складом","Отдел МТО","2015-01-16","2015-01-31",1,4400]
[{"$f":"IF(B11=\"\",\"\",SUBTOTAL(3,B11)*(MAX(A$4:A10)+1))","v":7},"ФИО 7","Лаборант","Лаборат. отд.","2015-01-16","2015-02-28",0.5,6200]
[{"$f":"IF(B12=\"\",\"\",SUBTOTAL(3,B12)*(MAX(A$4:A11)+1))","v":8},"ФИО 8","Медицинская сестра перевязочной","Хирургия (с пер.)","2015-01-16","2015-03-31",1,22300]
[{"$f":"IF(B13=\"\",\"\",SUBTOTAL(3,B13)*(MAX(A$4:A12)+1))","v":9},"ФИО 9","Медицинская сестра палатная (постовая)","Терапия (30 к.)","2015-01-16","2015-02-15",1,11100]
[{"$f":"IF(B14=\"\",\"\",SUBTOTAL(3,B14)*(MAX(A$4:A13)+1))","v":10},"ФИО 10","Бухгалтер","ФЭО","2015-01-16","2015-02-16",1,12900]
[{"$f":"IF(B15=\"\",\"\",SUBTOTAL(3,B15)*(MAX(A$4:A14)+1))","v":""},null,"","",null,null,null,""]
[{"$f":"IF(B16=\"\",\"\",SUBTOTAL(3,B16)*(MAX(A$4:A15)+1))","v":11},"ФИО 9","Медицинская сестра палатная (постовая)","Терапия (30 к.)","2015-01-16","2015-03-14",0.5,9600]
[{"$f":"IF(B17=\"\",\"\",SUBTOTAL(3,B17)*(MAX(A$4:A16)+1))","v":""},null,"","",null,null,null,""]
[{"$f":"IF(B18=\"\",\"\",SUBTOTAL(3,B18)*(MAX(A$4:A17)+1))","v":""},null,"","",null,null,null,""]
[{"$f":"IF(B19=\"\",\"\",SUBTOTAL(3,B19)*(MAX(A$4:A18)+1))","v":""},null,"","",null,null,null,""]
[{"$f":"IF(B20=\"\",\"\",SUBTOTAL(3,B20)*(MAX(A$4:A19)+1))","v":""},null,"","",null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"SUM(H5:H20)","v":98800}]
["СУММА ПРОПИСЬЮ:",null,{"$f":"Пропись(H21)","v":"Девяносто восемь тысяч восемьсот рублей"}]

{"sheet":"развернутая","index":3,"n_rows":28,"n_cols":17,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,4,2,5],[25,0,25,11]]}
[null,null,null,null,null,null,null,null,null,null,null,"Приложение к приказу № от \"____\" ___________ 2015г."]
[]
["№ п/п","СОТРУДНИК","ДОЛЖНОСТЬ","ОТДЕЛЕНИЕ","ПЕРИОД ВРИО",null,"РАСЧЕТНАЯ СУММА ЗА \n1 полный МЕСЯЦ","КОЛ-ВО МЕСЯЦЕВ","ОБЪЕМ РАБОТЫ","ПО ГРАФИКУ","ОТРАБОТАНО","СУММА"]
[null,2,3,null,4,5,6,null,7,8,9,10]
[{"$f":"IF(B5=\"\",\"\",SUBTOTAL(3,B5)*(MAX(A$4:A4)+1))","v":1},"ФИО 1",{"$f":"IF(B5=\"\",\"\",INDEX(МАССИВ,MATCH(B5,ФИО,0),3))","v":"Медицинская сестра"},{"$f":"IF(B5=\"\",\"\",INDEX(МАССИВ,MATCH(B5,ФИО,0),2))","v":"Приемное"},"2015-01-01","2015-01-31",{"$f":"IF(B5=\"\",\"\",INDEX(МАССИВ,MATCH(B5,ФИО,0),9))","v":10000},{"$f":"IF(B5=\"\",\"\",MONTH(F5)-MONTH(E5)+1+(YEAR(F5)-YEAR(E5))*12)","v":1},1,{"$f":"IF(B5=\"\",\"\",NETWORKDAYS.INTL(EOMONTH(E5,-1)+1,EOMONTH(F5,0),1,ПРАЗДНИКИ))","v":15},{"$f":"IF(B5=\"\",\"\",NETWORKDAYS.INTL(E5,F5,1,ПРАЗДНИКИ))","v":15},{"$f":"IF(B5=\"\",\"\",((((G5*H5)*I5)/J5)*K5))","v":10000},null,{"$f":"G5*H5","v":10000},{"$f":"N5*I5","v":10000},{"$f":"O5/J5","v":666.66666666666663},{"$f":"P5*K5","v":10000}]
[{"$f":"IF(B6=\"\",\"\",SUBTOTAL(3,B6)*(MAX(A$4:A5)+1))","v":2},"ФИО 1","Медицинская сестра","Приемное","2015-02-01","2015-02-28",10000,{"$f":"IF(B6=\"\",\"\",MONTH(F6)-MONTH(E6)+1+(YEAR(F6)-YEAR(E6))*12)","v":1},1,19,19,{"$f":"IF(B6=\"\",\"\",((((G6*H6)*I6)/J6)*K6))","v":10000},null,10000,10000,{"$f":"O6/J6","v":526.31578947368416},10000]
[{"$f":"IF(B7=\"\",\"\",SUBTOTAL(3,B7)*(MAX(A$4:A6)+1))","v":3},"ФИО 1","Медицинская сестра","Приемное","2015-03-01","2015-03-31",10000,1,1,21,21,{"$f":"IF(B7=\"\",\"\",((((G7*H7)*I7)/J7)*K7))","v":10000},null,{"$f":"G7*H7","v":10000},{"$f":"N7*I7","v":10000},{"$f":"O7/J7","v":476.1904761904762},{"$f":"P7*K7","v":10000}]
[{"$f":"IF(B8=\"\",\"\",SUBTOTAL(3,B8)*(MAX(A$4:A7)+1))","v":4},"ФИО 1",{"$f":"IF(B8=\"\",\"\",INDEX(МАССИВ,MATCH(B8,ФИО,0),3))","v":"Медицинская сестра"},{"$f":"IF(B8=\"\",\"\",INDEX(МАССИВ,MATCH(B8,ФИО,0),2))","v":"Приемное"},"2015-01-01","2015-03-31",{"$f":"IF(B8=\"\",\"\",INDEX(МАССИВ,MATCH(B8,ФИО,0),9))","v":10000},3,1,{"$f":"IF(B8=\"\",\"\",NETWORKDAYS.INTL(EOMONTH(E8,-1)+1,EOMONTH(F8,0),1,ПРАЗДНИКИ))","v":55},{"$f":"IF(B8=\"\",\"\",NETWORKDAYS.INTL(E8,F8,1,ПРАЗДНИКИ))","v":55},30000.000000000004,null,{"$f":"G8*H8","v":30000},{"$f":"N8*I8","v":30000},{"$f":"O8/J8","v":545.4545454545455},{"$f":"P8*K8","v":30000.000000000004}]
[{"$f":"IF(B9=\"\",\"\",SUBTOTAL(3,B9)*(MAX(A$4:A8)+1))","v":5},"ФИО 5","Младшая медицинская сестра по уходу за больными","Неврология","2015-01-01","2015-01-31",5000,1,1,15,15,{"$f":"IF(B9=\"\",\"\",ROUND((G9*H9*I9/J9*K9),-2))","v":5000}]
[{"$f":"IF(B10=\"\",\"\",SUBTOTAL(3,B10)*(MAX(A$4:A9)+1))","v":6},"ФИО 6","Заведующий складом","Отдел МТО","2015-01-16","2015-01-31",6000,1,1,15,11,{"$f":"IF(B10=\"\",\"\",ROUND((G10*H10*I10/J10*K10),-2))","v":4400}]
[{"$f":"IF(B11=\"\",\"\",SUBTOTAL(3,B11)*(MAX(A$4:A10)+1))","v":7},"ФИО 7","Лаборант","Лаборат. отд.","2015-01-16","2015-02-28",7000,2,1,34,30,12400]
[{"$f":"IF(B12=\"\",\"\",SUBTOTAL(3,B12)*(MAX(A$4:A11)+1))","v":8},"ФИО 8","Медицинская сестра перевязочной","Хирургия (с пер.)","2015-01-16","2015-03-31",8000,3,1,55,51,22300]
[{"$f":"IF(B13=\"\",\"\",SUBTOTAL(3,B13)*(MAX(A$4:A12)+1))","v":9},"ФИО 9","Медицинская сестра палатная (постовая)","Терапия (30 к.)","2015-01-16","2015-02-15",9000,2,1,34,21,11100]
[{"$f":"IF(B14=\"\",\"\",SUBTOTAL(3,B14)*(MAX(A$4:A13)+1))","v":10},"ФИО 10","Бухгалтер","ФЭО","2015-01-16","2015-02-16",10000,2,1,34,22,12900]
[{"$f":"IF(B15=\"\",\"\",SUBTOTAL(3,B15)*(MAX(A$4:A14)+1))","v":11},"ФИО 8","Медицинская сестра перевязочной","Хирургия (с пер.)","2015-01-16","2015-03-14",8000,3,1,55,39,17000]
[{"$f":"IF(B16=\"\",\"\",SUBTOTAL(3,B16)*(MAX(A$4:A15)+1))","v":12},"ФИО 9","Медицинская сестра палатная (постовая)","Терапия (30 к.)","2015-01-16","2015-03-14",9000,3,1,55,39,19100]
[{"$f":"IF(B17=\"\",\"\",SUBTOTAL(3,B17)*(MAX(A$4:A16)+1))","v":""},null,"","",null,null,"","",null,"","",""]
[{"$f":"IF(B18=\"\",\"\",SUBTOTAL(3,B18)*(MAX(A$4:A17)+1))","v":""},null,"","",null,null,"","",null,"","",""]
[{"$f":"IF(B19=\"\",\"\",SUBTOTAL(3,B19)*(MAX(A$4:A18)+1))","v":""},null,{"$f":"IF(B19=\"\",\"\",INDEX(МАССИВ,MATCH(B19,ФИО,0),3))","v":""},"",null,null,"","",null,{"$f":"IF(B19=\"\",\"\",NETWORKDAYS.INTL(EOMONTH(E19,-1)+1,EOMONTH(F19,0),1,ПРАЗДНИКИ))","v":""},{"$f":"IF(B19=\"\",\"\",NETWORKDAYS.INTL(E19,F19,1,ПРАЗДНИКИ))","v":""},{"$f":"IF(B19=\"\",\"\",ROUND((G19*H19*I19/J19*K19),-2))","v":""}]
[{"$f":"IF(B20=\"\",\"\",SUBTOTAL(3,B20)*(MAX(A$4:A19)+1))","v":""},null,"","",null,null,"","",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L5:L20)","v":164200}]
["СУММА ПРОПИСЬЮ:",null,{"$f":"BAHTTEXT(L21)","v":"หนึ่งแสนหกหมื่นสี่พันสองร้อยบาทถ้วน"}]
[]
["ФОРМУЛА (кратко) = (РАСЧЕТНАЯ СУММА * КОЛ-ВО ПОЛНЫХ МЕСЯЦЕВ * ОБЪЕМ РАБОТ) / НОРМУ ДНЕЙ * ФАКТИЧЕСКИ ОТРАБОТАННЫЕ ДНИ"]
[]
["ИТОГОВАЯ ФОРМУЛА В КОЛ. 10  = ЕСЛИ(B5=\"\";\"\";ОКРУГЛ(((ЕСЛИ(B5=\"\";\"\";ИНДЕКС(МАССИВ;ПОИСКПОЗ(B5;ФИО;0);9)))*(ЕСЛИ(B5=\"\";\"\";МЕСЯЦ(F5)-МЕСЯЦ(E5)+1+(ГОД(F5)-ГОД(E5))*12))*G5/(ЕСЛИ(B5=\"\";\"\";ЧИСТРАБДНИ.МЕЖД(КОНМЕСЯЦА(E5;-1)+1;КОНМЕСЯЦА(F5;0);1;ПРАЗДНИКИ)))*(ЕСЛИ(B5=\"\";\"\";ЧИСТРАБДНИ.МЕЖД(E5;F5;1;ПРАЗДНИКИ))));-2))"]
[]
[null,"ПОДПИСИ"]

{"sheet":"по месяцам","index":4,"n_rows":25,"n_cols":17,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,4,2,5]]}
[null,null,null,null,null,null,null,null,null,null,null,"Приложение к приказу № от \"____\" ___________ 2015г."]
[]
["№ п/п","СОТРУДНИК","ДОЛЖНОСТЬ","ОТДЕЛЕНИЕ","ПЕРИОД",null,"РАСЧЕТНАЯ СУММА ЗА \n1 полный МЕСЯЦ","КОЛ-ВО МЕСЯЦЕВ","ОБЪЕМ РАБОТЫ","ПО ГРАФИКУ","ОТРАБОТАНО","СУММА"]
[null,2,3,null,4,5,6,null,7,8,9,10]
[{"$f":"IF(B5=\"\",\"\",SUBTOTAL(3,B5)*(MAX(A$4:A4)+1))","v":1},"ФИО 1",{"$f":"IF(B5=\"\",\"\",INDEX(МАССИВ,MATCH(B5,ФИО,0),3))","v":"Медицинская сестра"},{"$f":"IF(B5=\"\",\"\",INDEX(МАССИВ,MATCH(B5,ФИО,0),2))","v":"Приемное"},"2015-01-01","2015-01-31",{"$f":"IF(B5=\"\",\"\",INDEX(МАССИВ,MATCH(B5,ФИО,0),9))","v":10000},{"$f":"IF(B5=\"\",\"\",MONTH(F5)-MONTH(E5)+1+(YEAR(F5)-YEAR(E5))*12)","v":1},1,{"$f":"IF(B5=\"\",\"\",NETWORKDAYS.INTL(EOMONTH(E5,-1)+1,EOMONTH(F5,0),1,ПРАЗДНИКИ))","v":15},{"$f":"IF(B5=\"\",\"\",NETWORKDAYS.INTL(E5,F5,1,ПРАЗДНИКИ))","v":15},{"$f":"IF(B5=\"\",\"\",((((G5*H5)*I5)/J5)*K5))","v":10000},null,{"$f":"G5*H5","v":10000},{"$f":"N5*I5","v":10000},{"$f":"O5/J5","v":666.66666666666663},{"$f":"P5*K5","v":10000}]
[{"$f":"IF(B6=\"\",\"\",SUBTOTAL(3,B6)*(MAX(A$4:A5)+1))","v":2},"ФИО 1","Медицинская сестра","Приемное","2015-02-01","2015-02-28",10000,{"$f":"IF(B6=\"\",\"\",MONTH(F6)-MONTH(E6)+1+(YEAR(F6)-YEAR(E6))*12)","v":1},1,19,19,{"$f":"IF(B6=\"\",\"\",((((G6*H6)*I6)/J6)*K6))","v":10000},null,10000,10000,{"$f":"O6/J6","v":526.31578947368416},10000]
[{"$f":"IF(B7=\"\",\"\",SUBTOTAL(3,B7)*(MAX(A$4:A6)+1))","v":3},"ФИО 1","Медицинская сестра","Приемное","2015-03-01","2015-03-31",10000,1,1,21,21,{"$f":"IF(B7=\"\",\"\",((((G7*H7)*I7)/J7)*K7))","v":10000},null,{"$f":"G7*H7","v":10000},{"$f":"N7*I7","v":10000},{"$f":"O7/J7","v":476.1904761904762},{"$f":"P7*K7","v":10000}]
[{"$f":"IF(B8=\"\",\"\",SUBTOTAL(3,B8)*(MAX(A$4:A7)+1))","v":4},"ФИО 1","Медицинская сестра","Приемное","2015-01-01","2015-03-31",10000,3,1,55,55,30000.000000000004,null,{"$f":"G8*H8","v":30000},{"$f":"N8*I8","v":30000},{"$f":"O8/J8","v":545.4545454545455},{"$f":"P8*K8","v":30000.000000000004}]
[{"$f":"IF(B9=\"\",\"\",SUBTOTAL(3,B9)*(MAX(A$4:A8)+1))","v":""},null,"","",null,null,"","",1,"","",{"$f":"IF(B9=\"\",\"\",ROUND((G9*H9*I9/J9*K9),-2))","v":""}]
[{"$f":"IF(B10=\"\",\"\",SUBTOTAL(3,B10)*(MAX(A$4:A9)+1))","v":""},null,"","",null,null,"","",null,"","","",null,null,"2015-01-16"]
[{"$f":"IF(B11=\"\",\"\",SUBTOTAL(3,B11)*(MAX(A$4:A10)+1))","v":""},null,"","",null,null,"","",null,"","","",null,null,"2015-03-31"]
[{"$f":"IF(B12=\"\",\"\",SUBTOTAL(3,B12)*(MAX(A$4:A11)+1))","v":""},null,"","",null,null,"","",null,"","","",null,"месяц",{"$f":"MONTH(O10)","v":1}]
[{"$f":"IF(B13=\"\",\"\",SUBTOTAL(3,B13)*(MAX(A$4:A12)+1))","v":""},null,"","",null,null,"","",null,"","","",null,"год",{"$f":"YEAR(O10)","v":2015}]
[{"$f":"IF(B14=\"\",\"\",SUBTOTAL(3,B14)*(MAX(A$4:A13)+1))","v":""},null,"","",null,null,"","",null,"","","",null,null,{"$f":"DAY(O10)","v":16}]
[{"$f":"IF(B15=\"\",\"\",SUBTOTAL(3,B15)*(MAX(A$4:A14)+1))","v":""},null,"","",null,null,"","",null,"","","",null,null,{"$f":"WEEKDAY(O10,3)","v":4}]
[{"$f":"IF(B16=\"\",\"\",SUBTOTAL(3,B16)*(MAX(A$4:A15)+1))","v":""},null,"","",null,null,"","",null,"","",""]
[{"$f":"IF(B17=\"\",\"\",SUBTOTAL(3,B17)*(MAX(A$4:A16)+1))","v":""},null,"","",null,null,"","",null,"","","",null,null,"0002"]
[{"$f":"IF(B18=\"\",\"\",SUBTOTAL(3,B18)*(MAX(A$4:A17)+1))","v":""},null,"","",null,null,"","",null,"","",""]
[{"$f":"IF(B19=\"\",\"\",SUBTOTAL(3,B19)*(MAX(A$4:A18)+1))","v":""},null,"","",null,null,"","",null,"","",""]
[{"$f":"IF(B20=\"\",\"\",SUBTOTAL(3,B20)*(MAX(A$4:A19)+1))","v":""},null,"","",null,null,"","",null,"","","",null,null,{"$f":"ROMAN(O15)","v":"IV"},"римские цифры"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L5:L20)","v":60000}]
["СУММА ПРОПИСЬЮ:",null,null,null,null,null,null,null,null,null,null,null,null,null,1111111111,"через проверку данных (тип данных) устанавливаем ограничение длины"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(P20)","v":"РИМСКИЕ ЦИФРЫ"},"прописные"]
[null,"ПОДПИСИ"]

{"sheet":"Лист1","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист2","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист3","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}