{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["предлож","альтерн","Определение % уходящих в отпуск"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":37,"n_cols":39,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,_t[план])","v":7003},{"$f":"_xlfn.AGGREGATE(9,7,_t[расчет])","v":385},{"$f":"_xlfn.AGGREGATE(9,7,_t[разница])","v":6618}]
["№№","дата нач","дата кон","план","расчет","разница","прим1","прим2","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31"]
[{"$f":"ROW()-ROW($A$3)","v":1},"2017-01-01",{"$f":"EOMONTH(B4,0)","v":"2017-01-31"},875,{"$f":"schet(B4,C4,$I$4:$AM4)","v":22},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":853},null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[{"$f":"ROW()-ROW($A$3)","v":2},{"$f":"C4+1","v":"2017-02-01"},{"$f":"EOMONTH(B5,0)","v":"2017-02-28"},875,{"$f":"schet(B5,C5,$I$4:$AM5)","v":60},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":815},null,null,null,null,null,null,null,null,null,null,null,null,1]
[3,{"$f":"C5+1","v":"2017-03-01"},{"$f":"EOMONTH(B6,0)","v":"2017-03-31"},729,{"$f":"schet(B6,C6,$I$4:$AM6)","v":44},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":685},null,null,null,null,null,null,null,null,null,null,null,null,1]
[4,"2017-04-01","2017-04-30",729,{"$f":"schet(B7,C7,$I$4:$AM7)","v":34},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":695},null,null,null,null,null,null,null,null,null,null,null,null,1]
[5,"2017-05-01","2017-05-31",438,{"$f":"schet(B8,C8,$I$4:$AM8)","v":36},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":402},null,null,null,null,null,null,null,null,null,null,null,null,1]
[6,"2017-06-01","2017-06-30",292,{"$f":"schet(B9,C9,$I$4:$AM9)","v":34},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":258},null,null,null,null,null,null,null,null,null,null,null,null,1]
[7,"2017-07-01","2017-07-31",292,{"$f":"schet(B10,C10,$I$4:$AM10)","v":36},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":256},null,null,null,null,null,null,null,null,null,null,null,null,1]
[8,"2017-08-01","2017-08-31",292,{"$f":"schet(B11,C11,$I$4:$AM11)","v":35},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":257},null,null,null,null,null,null,null,null,null,null,null,null,1]
[9,"2017-09-01","2017-09-30",438,{"$f":"schet(B12,C12,$I$4:$AM12)","v":34},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":404},null,null,null,null,null,null,null,null,null,null,null,null,1]
[10,"2017-10-01","2017-10-31",730,{"$f":"schet(B13,C13,$I$4:$AM13)","v":15},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":715}]
[11,"2017-11-01","2017-11-30",730,{"$f":"schet(B14,C14,$I$4:$AM14)","v":20},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":710},null,null,null,null,null,null,null,null,null,null,null,null,1]
[12,"2017-12-01","2017-12-31",583,{"$f":"schet(B15,C15,$I$4:$AM15)","v":15},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":568}]
[13,"2018-01-01","2018-01-31",null,{"$f":"schet(B16,C16,$I$4:$AM16)","v":0},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":0}]
[14,"2018-02-01","2018-02-28",null,{"$f":"schet(B17,C17,$I$4:$AM17)","v":0},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":0}]
[15,"2018-03-01","2018-03-31",null,{"$f":"schet(B18,C18,$I$4:$AM18)","v":0},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":0}]
[16,"2018-04-01","2018-04-30",null,{"$f":"schet(B19,C19,$I$4:$AM19)","v":0},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":0}]
[17,"2018-05-01","2018-05-31",null,{"$f":"schet(B20,C20,$I$4:$AM20)","v":0},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":0}]
[18,"2018-06-01","2018-06-30",null,{"$f":"schet(B21,C21,$I$4:$AM21)","v":0},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":0}]
[19,"2018-07-01","2018-07-31",null,{"$f":"schet(B22,C22,$I$4:$AM22)","v":0},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":0}]
[20,"2018-08-01","2018-08-31",null,{"$f":"schet(B23,C23,$I$4:$AM23)","v":0},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":0}]
[21,"2018-09-01","2018-09-30",null,{"$f":"schet(B24,C24,$I$4:$AM24)","v":0},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":0}]
[22,"2018-10-01","2018-10-31",null,{"$f":"schet(B25,C25,$I$4:$AM25)","v":0},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":0}]
[23,"2018-11-01","2018-11-30",null,{"$f":"schet(B26,C26,$I$4:$AM26)","v":0},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":0}]
[24,"2018-12-01","2018-12-31",null,{"$f":"schet(B27,C27,$I$4:$AM27)","v":0},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":0}]
[25,"2019-01-01","2019-01-31",null,{"$f":"schet(B28,C28,$I$4:$AM28)","v":0},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":0}]
[26,"2019-02-01","2019-02-28",null,{"$f":"schet(B29,C29,$I$4:$AM29)","v":0},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":0}]
[27,"2019-03-01","2019-03-31",null,{"$f":"schet(B30,C30,$I$4:$AM30)","v":0},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":0}]
[28,"2019-04-01","2019-04-30",null,{"$f":"schet(B31,C31,$I$4:$AM31)","v":0},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":0}]
[29,"2019-05-01","2019-05-31",null,{"$f":"schet(B32,C32,$I$4:$AM32)","v":0},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":0}]
[30,"2019-06-01","2019-06-30",null,{"$f":"schet(B33,C33,$I$4:$AM33)","v":0},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":0}]
[31,"2019-07-01","2019-07-31",null,{"$f":"schet(B34,C34,$I$4:$AM34)","v":0},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":0}]
[32,"2019-08-01","2019-08-31",null,{"$f":"schet(B35,C35,$I$4:$AM35)","v":0},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":0}]
[33,"2019-09-01","2019-09-30",null,{"$f":"schet(B36,C36,$I$4:$AM36)","v":0},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":0}]
[34,"2019-10-01","2019-10-31",null,{"$f":"schet(B37,C37,$I$4:$AM37)","v":0},{"$f":"_t[[#This Row],[план]]-_t[[#This Row],[расчет]]","v":0}]

{"sheet":"альтерн","index":1,"n_rows":23,"n_cols":79,"rows_kept":23,"cut":false,"hidden":false,"merged":[[6,4,6,8]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"накоп тебл чел в мес"]
[null,null,null,null,"К примеру:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-V$8))","v":55},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-W$8))","v":81},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-X$8))","v":106},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-Y$8))","v":130},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-Z$8))","v":153},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-AA$8))","v":175},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-AB$8))","v":196},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-AC$8))","v":216},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-AD$8))","v":235},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-AE$8))","v":253},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-AF$8))","v":270},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-AG$8))","v":286},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-AH$8))","v":301},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-AI$8))","v":315},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-AJ$8))","v":328},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-AK$8))","v":340},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-AL$8))","v":351},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-AM$8))","v":361},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-AN$8))","v":370},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-AO$8))","v":378},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-AP$8))","v":385},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-AQ$8))","v":391},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-AR$8))","v":396},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-AS$8))","v":400},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-AT$8))","v":403},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-AU$8))","v":405},{"$f":"SUM($AW2:INDEX($V2:$AV2,$U2-AV$8))","v":406}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-V$8))","v":57},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-W$8))","v":84},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-X$8))","v":110},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-Y$8))","v":135},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-Z$8))","v":159},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-AA$8))","v":182},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-AB$8))","v":204},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-AC$8))","v":225},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-AD$8))","v":245},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-AE$8))","v":264},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-AF$8))","v":282},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-AG$8))","v":299},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-AH$8))","v":315},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-AI$8))","v":330},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-AJ$8))","v":344},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-AK$8))","v":357},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-AL$8))","v":369},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-AM$8))","v":380},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-AN$8))","v":390},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-AO$8))","v":399},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-AP$8))","v":407},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-AQ$8))","v":414},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-AR$8))","v":420},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-AS$8))","v":425},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-AT$8))","v":429},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-AU$8))","v":432},{"$f":"SUM($AX3:INDEX($V3:$AX3,$U3-AV$8))","v":434}]
[null,null,null,null,"Кол-во сотрудников",null,100,null,{"$f":"G4*B8","v":36500},{"$f":"I5/I4","v":0.19178082191780821},null,null,null,null,null,null,null,null,null,null,30,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-V$8))","v":59},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-W$8))","v":87},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-X$8))","v":114},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-Y$8))","v":140},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-Z$8))","v":165},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-AA$8))","v":189},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-AB$8))","v":212},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-AC$8))","v":234},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-AD$8))","v":255},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-AE$8))","v":275},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-AF$8))","v":294},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-AG$8))","v":312},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-AH$8))","v":329},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-AI$8))","v":345},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-AJ$8))","v":360},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-AK$8))","v":374},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-AL$8))","v":387},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-AM$8))","v":399},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-AN$8))","v":410},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-AO$8))","v":420},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-AP$8))","v":429},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-AQ$8))","v":437},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-AR$8))","v":444},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-AS$8))","v":450},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-AT$8))","v":455},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-AU$8))","v":459},{"$f":"SUM($AY4:INDEX($V4:$AY4,$U4-AV$8))","v":462}]
[null,null,null,null,"Кол-во отпусков в году",null,{"$f":"G4*2","v":200},"по 35 к.д.",{"$f":"100*35*2","v":7000},null,null,null,null,null,null,null,null,null,null,null,31,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-V$8))","v":61},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-W$8))","v":90},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-X$8))","v":118},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-Y$8))","v":145},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-Z$8))","v":171},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-AA$8))","v":196},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-AB$8))","v":220},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-AC$8))","v":243},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-AD$8))","v":265},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-AE$8))","v":286},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-AF$8))","v":306},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-AG$8))","v":325},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-AH$8))","v":343},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-AI$8))","v":360},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-AJ$8))","v":376},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-AK$8))","v":391},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-AL$8))","v":405},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-AM$8))","v":418},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-AN$8))","v":430},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-AO$8))","v":441},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-AP$8))","v":451},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-AQ$8))","v":460},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-AR$8))","v":468},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-AS$8))","v":475},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-AT$8))","v":481},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-AU$8))","v":486},{"$f":"SUM($AZ5:INDEX($V5:$AZ5,$U5-AV$8))","v":490}]
[]
[null,2017,null,null,"Квота % отсутствия человеко-дней в месяце от состава компании (т.е. - 100 человек * кол-во дней в месяце)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"осн расчет уход в отпуск по кал дням"]
[null,{"$f":"SUM(B9:B20)","v":365},null,null,"Месяц","чел-дни","%","отпуск чел-дни план","отпуск чел-дни расчет",null,"чел-дни в мес","чел в день","округл чел в день","округл чел-дни в мес","разница округл и матем чел в день","позиция разницы в накоп тебл чел в мес","поз не более для корректировки в начале мес","размер корректировки в начал мес",null,"поз точно для корректировки в середине мес",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[1,{"$f":"DAY(DATE($B$7,A9+1,))","v":31},{"$f":"DATE($B$7,A9,1)","v":"2017-01-01"},{"$f":"DATE($B$7,A9,B9)","v":"2017-01-31"},"Январь",{"$f":"B9*$I$4/$B$8","v":3100},{"$f":"30*(1/2.4)","v":12.5},{"$f":"$I$5*G9/100","v":875},{"$f":"SUMPRODUCT(($B9+1-$V$8:$AZ$8)*V9:AZ9)","v":875},{"$f":"SUM((DATE($B$7,$A9,$V$8:$AZ$8)>=$C9)*(DATE($B$7,$A9,$V$8:$AZ$8)+COLUMN($A:$AH)<=$D9)*$V$9:$AZ9)","v":{"$error":"#N/A"}},{"$f":"(1+B9)*B9/2","v":496},{"$f":"H9/K9","v":1.7641129032258065},{"$f":"ROUND(L9,)","v":2},{"$f":"M9*K9","v":992},{"$f":"N9-H9","v":117},{"$f":"MATCH(ABS(O9),INDEX($V$2:$CD$5,$B9-27,))","v":33},{"$f":"MAX(,P9-B9+1)","v":3},{"$f":"IF(P9=0,,INDEX($V$2:$CD$5,$B9-27,$P9))","v":90},{"$f":"IF(O9=0,,O9-R9*SIGN($O9))","v":27},{"$f":"ABS(IF(Q9=0,P9,ABS(S9))-B9-1)","v":5},null,{"$f":"IF(V$8<=$B9,$M9-SIGN($O9)*(V$8<=$Q9)-SIGN($O9)*(V$8=$T9),)","v":1},1,1,2,1,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]
[2,{"$f":"DAY(DATE($B$7,A10+1,))","v":28},{"$f":"DATE($B$7,A10,1)","v":"2017-02-01"},{"$f":"DATE($B$7,A10,B10)","v":"2017-02-28"},"Февраль",{"$f":"B10*$I$4/$B$8","v":2800},{"$f":"30*(1/2.4)","v":12.5},{"$f":"$I$5*G10/100","v":875},{"$f":"SUMPRODUCT(($B10+1-$V$8:$AZ$8)*V10:AZ10)","v":875},{"$f":"SUM((DATE($B$7,$A10,$V$8:$AZ$8)>=$C10)*(DATE($B$7,$A10,$V$8:$AZ$8)+ROW($1:$34)<=$D10)*$V$9:$AZ10)","v":{"$error":"#N/A"}},{"$f":"(1+B10)*B10/2","v":406},{"$f":"H10/K10","v":2.1551724137931036},{"$f":"ROUND(L10,)","v":2},{"$f":"M10*K10","v":812},{"$f":"N10-H10","v":-63},29,2,{"$f":"IF(P10=0,,INDEX($V$2:$CD$5,$B10-27,$P10))","v":55},{"$f":"IF(O10=0,,O10-R10*SIGN($O10))","v":-8},{"$f":"ABS(IF(Q10=0,P10,ABS(S10))-B10-1)","v":21},null,{"$f":"IF(V$8<=$B10,$M10-SIGN($O10)*(V$8<=$Q10)-SIGN($O10)*(V$8=$T10),)","v":3},{"$f":"IF(W$8<=$B10,$M10-SIGN($O10)*(W$8<=$Q10)-SIGN($O10)*(W$8=$T10),)","v":3},2,2,2,2,2,2,2,2,2,{"$f":"IF(AG$8<=$B10,$M10-SIGN($O10)*(AG$8<=$Q10)-SIGN($O10)*(AG$8=$T10),)","v":2},2,2,2,2,2,2,2,2,3,{"$f":"IF(AQ$8<=$B10,$M10-SIGN($O10)*(AQ$8<=$Q10)-SIGN($O10)*(AQ$8=$T10),)","v":2},2,2,2,2,2,2,0,0,0]
[3,31,"2017-03-01","2017-03-31","Март",3100,{"$f":"25*(1/2.4)","v":10.416666666666668},729.16666666666674,716,{"$f":"SUM((DATE($B$7,$A11,$V$8:$AZ$8)>=$C11)*(DATE($B$7,$A11,$V$8:$AZ$8)+ROW($1:$34)<=$D11)*$V$9:$AZ11)","v":{"$error":"#N/A"}},496,1.4700940860215055,1,496,-233.16666666666674,38,8,220,-13.166666666666742,18.833333333333258,null,2,2,2,2,2,2,2,2,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[4,30,"2017-04-01","2017-04-30","Апрель",3000,{"$f":"25*(1/2.4)","v":10.416666666666668},729.16666666666674,741,{"$f":"SUM((DATE($B$7,$A12,$V$8:$AZ$8)>=$C12)*(DATE($B$7,$A12,$V$8:$AZ$8)+ROW($1:$34)<=$D12)*$V$9:$AZ12)","v":{"$error":"#N/A"}},465,1.5681003584229392,2,930,200.83333333333326,36,7,189,11.833333333333258,19.166666666666742,null,1,1,1,1,1,1,1,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,0]
[5,31,"2017-05-01","2017-05-31","Май",3100,{"$f":"15*(1/2.4)","v":6.25},437.5,465,{"$f":"SUM((DATE($B$7,$A13,$V$8:$AZ$8)>=$C13)*(DATE($B$7,$A13,$V$8:$AZ$8)+ROW($1:$34)<=$D13)*$V$9:$AZ13)","v":{"$error":"#N/A"}},496,0.88205645161290325,1,496,58.5,31,1,31,27.5,4.5,null,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[6,30,"2017-06-01","2017-06-30","Июнь",3000,{"$f":"10*(1/2.4)","v":4.166666666666667},291.66666666666669,300,{"$f":"SUM((DATE($B$7,$A14,$V$8:$AZ$8)>=$C14)*(DATE($B$7,$A14,$V$8:$AZ$8)+ROW($1:$34)<=$D14)*$V$9:$AZ14)","v":{"$error":"#N/A"}},465,0.62724014336917566,1,465,173.33333333333331,35,6,165,8.3333333333333144,22.666666666666686,null,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0]
[7,31,"2017-07-01","2017-07-31","Июль",3100,{"$f":"10*(1/2.4)","v":4.166666666666667},291.66666666666669,300,{"$f":"SUM((DATE($B$7,$A15,$V$8:$AZ$8)>=$C15)*(DATE($B$7,$A15,$V$8:$AZ$8)+ROW($1:$34)<=$D15)*$V$9:$AZ15)","v":{"$error":"#N/A"}},496,0.58803763440860224,1,496,204.33333333333331,37,7,196,8.3333333333333144,23.666666666666686,null,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[8,31,"2017-08-01","2017-08-31","Август",3100,{"$f":"10*(1/2.4)","v":4.166666666666667},291.66666666666669,300,{"$f":"SUM((DATE($B$7,$A16,$V$8:$AZ$8)>=$C16)*(DATE($B$7,$A16,$V$8:$AZ$8)+ROW($1:$34)<=$D16)*$V$9:$AZ16)","v":{"$error":"#N/A"}},496,0.58803763440860224,1,496,204.33333333333331,37,7,196,8.3333333333333144,23.666666666666686,null,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[9,30,"2017-09-01","2017-09-30","Сентябрь",3000,{"$f":"15*(1/2.4)","v":6.25},437.5,438,{"$f":"SUM((DATE($B$7,$A17,$V$8:$AZ$8)>=$C17)*(DATE($B$7,$A17,$V$8:$AZ$8)+ROW($1:$34)<=$D17)*$V$9:$AZ17)","v":{"$error":"#N/A"}},465,0.94086021505376349,1,465,27.5,27,0,27,0.5,4,null,1,{"$f":"IF(W$8<=$B17,$M17-SIGN($O17)*(W$8<=$Q17)-SIGN($O17)*(W$8=$T17),)","v":1},1,0,1,1,1,1,1,1,1,1,1,1,1,1,{"$f":"IF(AL$8<=$B17,$M17-SIGN($O17)*(AL$8<=$Q17)-SIGN($O17)*(AL$8=$T17),)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,0]
[10,31,"2017-10-01","2017-10-31","Октябрь",3100,{"$f":"25*(1/2.4)","v":10.416666666666668},729.16666666666674,716,{"$f":"SUM((DATE($B$7,$A18,$V$8:$AZ$8)>=$C18)*(DATE($B$7,$A18,$V$8:$AZ$8)+ROW($1:$34)<=$D18)*$V$9:$AZ18)","v":{"$error":"#N/A"}},496,1.4700940860215055,1,496,-233.16666666666674,38,8,220,-13.166666666666742,18.833333333333258,null,2,2,2,2,2,2,2,2,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[11,30,"2017-11-01","2017-11-30","Ноябрь",3000,{"$f":"25*(1/2.4)","v":10.416666666666668},729.16666666666674,741,{"$f":"SUM((DATE($B$7,$A19,$V$8:$AZ$8)>=$C19)*(DATE($B$7,$A19,$V$8:$AZ$8)+ROW($1:$34)<=$D19)*$V$9:$AZ19)","v":{"$error":"#N/A"}},465,1.5681003584229392,2,930,200.83333333333326,36,7,189,11.833333333333258,19.166666666666742,null,1,1,1,1,1,1,1,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,0]
[12,31,"2017-12-01","2017-12-31","Декабрь",3100,{"$f":"20*(1/2.4)","v":8.3333333333333339},583.33333333333337,557,{"$f":"SUM((DATE($B$7,$A20,$V$8:$AZ$8)>=$C20)*(DATE($B$7,$A20,$V$8:$AZ$8)+ROW($1:$34)<=$D20)*$V$9:$AZ20)","v":{"$error":"#N/A"}},496,1.1760752688172045,1,496,-87.333333333333371,32,2,61,-26.333333333333371,5.6666666666666288,null,2,2,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Итого:",{"$f":"SUM(F9:F20)","v":36500},{"$f":"SUM(G9:G20)","v":100.00000000000001},{"$f":"SUM(H9:H20)","v":7000.0000000000009},{"$f":"SUM(I9:I20)","v":7024},null,null,null,null,{"$f":"SUM(N9:N20)","v":7570},{"$f":"SUM(O9:O20)","v":569.99999999999966},null,null,{"$f":"SUM(R9:R20*SIGN(O9:O20))","v":527},{"$f":"SUM(S9:S20)","v":42.999999999999602}]
[null,null,null,null,null,null,null,null,{"$f":"I21-H21","v":23.999999999999091},null,null,null,null,null,{"$f":"N21-O21","v":7000},null,null,null,{"$f":"R21+S21","v":569.99999999999955}]
[null,null,null,null,{"$f":"1/2.4","v":0.41666666666666669}]

{"sheet":"Определение % уходящих в отпуск","index":2,"n_rows":22,"n_cols":78,"rows_kept":22,"cut":false,"hidden":false,"merged":[[6,4,6,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"накоп тебл чел в мес"]
[null,null,null,null,"К примеру:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-U$8))","v":55},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-V$8))","v":81},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-W$8))","v":106},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-X$8))","v":130},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-Y$8))","v":153},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-Z$8))","v":175},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-AA$8))","v":196},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-AB$8))","v":216},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-AC$8))","v":235},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-AD$8))","v":253},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-AE$8))","v":270},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-AF$8))","v":286},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-AG$8))","v":301},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-AH$8))","v":315},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-AI$8))","v":328},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-AJ$8))","v":340},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-AK$8))","v":351},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-AL$8))","v":361},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-AM$8))","v":370},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-AN$8))","v":378},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-AO$8))","v":385},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-AP$8))","v":391},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-AQ$8))","v":396},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-AR$8))","v":400},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-AS$8))","v":403},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-AT$8))","v":405},{"$f":"SUM($AV2:INDEX($U2:$AU2,$T2-AU$8))","v":406}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-U$8))","v":57},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-V$8))","v":84},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-W$8))","v":110},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-X$8))","v":135},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-Y$8))","v":159},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-Z$8))","v":182},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-AA$8))","v":204},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-AB$8))","v":225},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-AC$8))","v":245},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-AD$8))","v":264},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-AE$8))","v":282},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-AF$8))","v":299},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-AG$8))","v":315},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-AH$8))","v":330},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-AI$8))","v":344},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-AJ$8))","v":357},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-AK$8))","v":369},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-AL$8))","v":380},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-AM$8))","v":390},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-AN$8))","v":399},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-AO$8))","v":407},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-AP$8))","v":414},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-AQ$8))","v":420},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-AR$8))","v":425},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-AS$8))","v":429},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-AT$8))","v":432},{"$f":"SUM($AW3:INDEX($U3:$AW3,$T3-AU$8))","v":434}]
[null,null,null,null,"Кол-во сотрудников",100,null,{"$f":"F4*B8","v":36500},null,null,null,null,null,null,null,null,null,null,null,30,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-U$8))","v":59},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-V$8))","v":87},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-W$8))","v":114},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-X$8))","v":140},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-Y$8))","v":165},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-Z$8))","v":189},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-AA$8))","v":212},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-AB$8))","v":234},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-AC$8))","v":255},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-AD$8))","v":275},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-AE$8))","v":294},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-AF$8))","v":312},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-AG$8))","v":329},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-AH$8))","v":345},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-AI$8))","v":360},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-AJ$8))","v":374},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-AK$8))","v":387},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-AL$8))","v":399},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-AM$8))","v":410},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-AN$8))","v":420},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-AO$8))","v":429},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-AP$8))","v":437},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-AQ$8))","v":444},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-AR$8))","v":450},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-AS$8))","v":455},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-AT$8))","v":459},{"$f":"SUM($AX4:INDEX($U4:$AX4,$T4-AU$8))","v":462}]
[null,null,null,null,"Кол-во отпусков в году",{"$f":"F4*2","v":200},"по 35 к.д.",{"$f":"100*35*2","v":7000},null,null,null,null,null,null,null,null,null,null,null,31,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-U$8))","v":61},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-V$8))","v":90},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-W$8))","v":118},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-X$8))","v":145},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-Y$8))","v":171},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-Z$8))","v":196},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-AA$8))","v":220},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-AB$8))","v":243},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-AC$8))","v":265},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-AD$8))","v":286},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-AE$8))","v":306},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-AF$8))","v":325},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-AG$8))","v":343},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-AH$8))","v":360},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-AI$8))","v":376},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-AJ$8))","v":391},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-AK$8))","v":405},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-AL$8))","v":418},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-AM$8))","v":430},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-AN$8))","v":441},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-AO$8))","v":451},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-AP$8))","v":460},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-AQ$8))","v":468},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-AR$8))","v":475},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-AS$8))","v":481},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-AT$8))","v":486},{"$f":"SUM($AY5:INDEX($U5:$AY5,$T5-AU$8))","v":490}]
[]
[null,2017,null,null,"Квота % отсутствия человеко-дней в месяце от состава компании (т.е. - 100 человек * кол-во дней в месяце)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"осн расчет уход в отпуск по кал дням"]
[null,{"$f":"SUM(B9:B20)","v":365},null,null,"Месяц","%","Человеко-дни","Кол-во сотрудников которых можно отпустить в месяце",null,"чел-дни в мес","чел в день","округл чел в день","округл чел-дни в мес","разница округл и матем чел в день","позиция разницы в накоп тебл чел в мес","поз не более для корректировки в начале мес","размер корректировки в начал мес",null,"поз точно для корректировки в середине мес",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[1,{"$f":"DAY(DATE($B$7,A9+1,))","v":31},{"$f":"DATE($B$7,A9,1)","v":"2017-01-01"},{"$f":"DATE($B$7,A9,B9)","v":"2017-01-31"},"Январь",30,{"$f":"B9*($F$4/100*F9)","v":930},{"$f":"SUMPRODUCT(($B9+1-$U$8:$AY$8)*U9:AY9)","v":930},{"$f":"SUM((DATE($B$7,$A9,$U$8:$AY$8)>=$C9)*(DATE($B$7,$A9,$U$8:$AY$8)+ROW($1:$34)<=$D9)*$U$9:$AY9)","v":871},{"$f":"(1+B9)*B9/2","v":496},{"$f":"G9/J9","v":1.875},{"$f":"ROUND(K9,)","v":2},{"$f":"L9*J9","v":992},{"$f":"M9-G9","v":62},{"$f":"MATCH(ABS(N9),INDEX($U$2:$CC$5,$B9-27,))","v":32},{"$f":"MAX(,O9-B9+1)","v":2},{"$f":"IF(O9=0,,INDEX($U$2:$CC$5,$B9-27,$O9))","v":61},{"$f":"IF(N9=0,,N9-Q9*SIGN($N9))","v":1},{"$f":"ABS(IF(P9=0,O9,ABS(R9))-B9-1)","v":31},null,{"$f":"IF(U$8<=$B9,$L9-SIGN($N9)*(U$8<=$P9)-SIGN($N9)*(U$8=$S9),)","v":1},1,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,1]
[2,{"$f":"DAY(DATE($B$7,A10+1,))","v":28},{"$f":"DATE($B$7,A10,1)","v":"2017-02-01"},{"$f":"DATE($B$7,A10,B10)","v":"2017-02-28"},"Февраль",30,{"$f":"B10*($F$4/100*F10)","v":840},{"$f":"SUMPRODUCT(($B10+1-$U$8:$AY$8)*U10:AY10)","v":840},{"$f":"SUM((DATE($B$7,$A10,$U$8:$AY$8)>=$C10)*(DATE($B$7,$A10,$U$8:$AY$8)+ROW($1:$34)<=$D10)*$U$9:$AY10)","v":{"$error":"#N/A"}},{"$f":"(1+B10)*B10/2","v":406},{"$f":"G10/J10","v":2.0689655172413794},{"$f":"ROUND(K10,)","v":2},{"$f":"L10*J10","v":812},{"$f":"M10-G10","v":-28},28,1,{"$f":"IF(O10=0,,INDEX($U$2:$CC$5,$B10-27,$O10))","v":28},{"$f":"IF(N10=0,,N10-Q10*SIGN($N10))","v":0},{"$f":"ABS(IF(P10=0,O10,ABS(R10))-B10-1)","v":29},null,{"$f":"IF(U$8<=$B10,$L10-SIGN($N10)*(U$8<=$P10)-SIGN($N10)*(U$8=$S10),)","v":3},{"$f":"IF(V$8<=$B10,$L10-SIGN($N10)*(V$8<=$P10)-SIGN($N10)*(V$8=$S10),)","v":2},2,2,2,2,2,2,2,2,2,{"$f":"IF(AF$8<=$B10,$L10-SIGN($N10)*(AF$8<=$P10)-SIGN($N10)*(AF$8=$S10),)","v":2},2,2,2,2,2,2,2,2,2,{"$f":"IF(AP$8<=$B10,$L10-SIGN($N10)*(AP$8<=$P10)-SIGN($N10)*(AP$8=$S10),)","v":2},2,2,2,2,2,2,0,0,0]
[3,31,"2017-03-01","2017-03-31","Март",25,775,775,{"$f":"SUM((DATE($B$7,$A11,$U$8:$AY$8)>=$C11)*(DATE($B$7,$A11,$U$8:$AY$8)+ROW($1:$34)<=$D11)*$U$9:$AY11)","v":{"$error":"#N/A"}},496,1.5625,2,992,217,37,7,196,21,11,null,1,1,1,1,1,1,1,2,2,2,1,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]
[4,30,"2017-04-01","2017-04-30","Апрель",25,750,750,{"$f":"SUM((DATE($B$7,$A12,$U$8:$AY$8)>=$C12)*(DATE($B$7,$A12,$U$8:$AY$8)+ROW($1:$34)<=$D12)*$U$9:$AY12)","v":{"$error":"#N/A"}},465,1.6129032258064515,2,930,180,35,6,165,15,16,null,1,1,1,1,1,1,2,2,2,2,2,2,2,2,2,1,2,2,2,2,2,2,2,2,2,2,2,2,2,2,0]
[5,31,"2017-05-01","2017-05-31","Май",15,465,465,{"$f":"SUM((DATE($B$7,$A13,$U$8:$AY$8)>=$C13)*(DATE($B$7,$A13,$U$8:$AY$8)+ROW($1:$34)<=$D13)*$U$9:$AY13)","v":{"$error":"#N/A"}},496,0.9375,1,496,31,31,1,31,0,32,null,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[6,30,"2017-06-01","2017-06-30","Июнь",10,300,300,{"$f":"SUM((DATE($B$7,$A14,$U$8:$AY$8)>=$C14)*(DATE($B$7,$A14,$U$8:$AY$8)+ROW($1:$34)<=$D14)*$U$9:$AY14)","v":{"$error":"#N/A"}},465,0.64516129032258063,1,465,165,35,6,165,0,31,null,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0]
[7,31,"2017-07-01","2017-07-31","Июль",10,310,310,{"$f":"SUM((DATE($B$7,$A15,$U$8:$AY$8)>=$C15)*(DATE($B$7,$A15,$U$8:$AY$8)+ROW($1:$34)<=$D15)*$U$9:$AY15)","v":{"$error":"#N/A"}},496,0.625,1,496,186,36,6,171,15,17,null,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[8,31,"2017-08-01","2017-08-31","Август",10,310,310,{"$f":"SUM((DATE($B$7,$A16,$U$8:$AY$8)>=$C16)*(DATE($B$7,$A16,$U$8:$AY$8)+ROW($1:$34)<=$D16)*$U$9:$AY16)","v":{"$error":"#N/A"}},496,0.625,1,496,186,36,6,171,15,17,null,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[9,30,"2017-09-01","2017-09-30","Сентябрь",15,450,450,{"$f":"SUM((DATE($B$7,$A17,$U$8:$AY$8)>=$C17)*(DATE($B$7,$A17,$U$8:$AY$8)+ROW($1:$34)<=$D17)*$U$9:$AY17)","v":{"$error":"#N/A"}},465,0.967741935483871,1,465,15,15,0,15,0,16,null,1,{"$f":"IF(V$8<=$B17,$L17-SIGN($N17)*(V$8<=$P17)-SIGN($N17)*(V$8=$S17),)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,0,{"$f":"IF(AK$8<=$B17,$L17-SIGN($N17)*(AK$8<=$P17)-SIGN($N17)*(AK$8=$S17),)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,0]
[10,31,"2017-10-01","2017-10-31","Октябрь",25,775,775,{"$f":"SUM((DATE($B$7,$A18,$U$8:$AY$8)>=$C18)*(DATE($B$7,$A18,$U$8:$AY$8)+ROW($1:$34)<=$D18)*$U$9:$AY18)","v":{"$error":"#N/A"}},496,1.5625,2,992,217,37,7,196,21,11,null,1,1,1,1,1,1,1,2,2,2,1,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]
[11,30,"2017-11-01","2017-11-30","Ноябрь",25,750,750,{"$f":"SUM((DATE($B$7,$A19,$U$8:$AY$8)>=$C19)*(DATE($B$7,$A19,$U$8:$AY$8)+ROW($1:$34)<=$D19)*$U$9:$AY19)","v":{"$error":"#N/A"}},465,1.6129032258064515,2,930,180,35,6,165,15,16,null,1,1,1,1,1,1,2,2,2,2,2,2,2,2,2,1,2,2,2,2,2,2,2,2,2,2,2,2,2,2,0]
[12,31,"2017-12-01","2017-12-31","Декабрь",20,620,620,{"$f":"SUM((DATE($B$7,$A20,$U$8:$AY$8)>=$C20)*(DATE($B$7,$A20,$U$8:$AY$8)+ROW($1:$34)<=$D20)*$U$9:$AY20)","v":{"$error":"#N/A"}},496,1.25,1,496,-124,34,4,118,-6,26,null,2,2,2,2,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,2,1,1,1,1,1]
[null,null,null,null,"Итого:",{"$f":"SUM(F9:F20)","v":240},{"$f":"SUM(G9:G20)","v":7275},{"$f":"SUM(H9:H20)","v":7275},null,null,null,null,{"$f":"SUM(M9:M20)","v":8562},{"$f":"SUM(N9:N20)","v":1287},null,null,{"$f":"SUM(Q9:Q20*SIGN(N9:N20))","v":1190},{"$f":"SUM(R9:R20)","v":97}]
[null,null,null,null,null,null,null,{"$f":"H21-G21","v":0},null,null,null,null,null,{"$f":"M21-N21","v":7275},null,null,null,{"$f":"Q21+R21","v":1287}]