{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["EXCEL2.RU (2)","Лист2","Лист3","СводИдиагр","Данные"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":1},"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":"EXCEL2.RU (2)","index":0,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[[0,0,0,6]]}
["EXCEL2.RU - профессиональные приемы для всех >>>"]
["Хорошая новость! Большинство задач, которые Вы хотите решить с помощью MS EXCEL – уже давно решены! \nНа нашем сайте Вы найдете решения множества из наиболее часто встречающихся задач. Сайт содержит более 500 качественно оформленных статей с файлами примеров."]
["Миссия нашего сайта - превратить Вашу работу в MS EXCEL в приятное времяпрепровождение и ускорить решение Ваших задач. Мы постоянно работаем над содержанием и оформлением нашего сайта и благодарим активных пользователей за поддержку и неоценимую помощь в нашей работе."]

{"sheet":"Лист2","index":1,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Филиал",{"$f":"\"Кп в риске  \"&G1","v":"Кп в риске  Филиал"}]
[]
[null,null,null,null,null,4]
[]
[null,null,null,null,null,null,null,null,2]
[]
[]
[null,null,null,null,null,null,null,null,null,"в KGS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"КП в риске"]
[null,null,"2016-01-01","2016-01-02","2016-01-03","2016-01-04","2016-01-05","2016-01-06","2016-01-07","2016-01-08"]
[null,"КП",{"$f":"SUMIFS(Лист3!$C:$C,Лист3!$B:$B,C23,Лист3!$A:$A,$G$1)","v":3775000},{"$f":"SUMIFS(Лист3!$C:$C,Лист3!$B:$B,D23,Лист3!$A:$A,$G$1)","v":3774950},{"$f":"SUMIFS(Лист3!$C:$C,Лист3!$B:$B,E23,Лист3!$A:$A,$G$1)","v":3774900},{"$f":"SUMIFS(Лист3!$C:$C,Лист3!$B:$B,F23,Лист3!$A:$A,$G$1)","v":3774850},{"$f":"SUMIFS(Лист3!$C:$C,Лист3!$B:$B,G23,Лист3!$A:$A,$G$1)","v":3774800},{"$f":"SUMIFS(Лист3!$C:$C,Лист3!$B:$B,H23,Лист3!$A:$A,$G$1)","v":3774750},{"$f":"SUMIFS(Лист3!$C:$C,Лист3!$B:$B,I23,Лист3!$A:$A,$G$1)","v":3774700},{"$f":"SUMIFS(Лист3!$C:$C,Лист3!$B:$B,J23,Лист3!$A:$A,$G$1)","v":3774650}]
[null,"Пар 0",{"$f":"SUMIFS(Лист3!$D:$D,Лист3!$B:$B,C23,Лист3!$A:$A,$G$1)","v":639000},{"$f":"SUMIFS(Лист3!$D:$D,Лист3!$B:$B,D23,Лист3!$A:$A,$G$1)","v":638950},{"$f":"SUMIFS(Лист3!$D:$D,Лист3!$B:$B,E23,Лист3!$A:$A,$G$1)","v":638900},{"$f":"SUMIFS(Лист3!$D:$D,Лист3!$B:$B,F23,Лист3!$A:$A,$G$1)","v":638850},{"$f":"SUMIFS(Лист3!$D:$D,Лист3!$B:$B,G23,Лист3!$A:$A,$G$1)","v":638800},{"$f":"SUMIFS(Лист3!$D:$D,Лист3!$B:$B,H23,Лист3!$A:$A,$G$1)","v":638750},{"$f":"SUMIFS(Лист3!$D:$D,Лист3!$B:$B,I23,Лист3!$A:$A,$G$1)","v":638700},{"$f":"SUMIFS(Лист3!$D:$D,Лист3!$B:$B,J23,Лист3!$A:$A,$G$1)","v":638650}]
[null,"Пар 30",{"$f":"SUMIFS(Лист3!$E:$E,Лист3!$B:$B,C23,Лист3!$A:$A,$G$1)","v":329000},{"$f":"SUMIFS(Лист3!$E:$E,Лист3!$B:$B,D23,Лист3!$A:$A,$G$1)","v":328950},{"$f":"SUMIFS(Лист3!$E:$E,Лист3!$B:$B,E23,Лист3!$A:$A,$G$1)","v":328900},{"$f":"SUMIFS(Лист3!$E:$E,Лист3!$B:$B,F23,Лист3!$A:$A,$G$1)","v":328850},{"$f":"SUMIFS(Лист3!$E:$E,Лист3!$B:$B,G23,Лист3!$A:$A,$G$1)","v":328800},{"$f":"SUMIFS(Лист3!$E:$E,Лист3!$B:$B,H23,Лист3!$A:$A,$G$1)","v":328750},{"$f":"SUMIFS(Лист3!$E:$E,Лист3!$B:$B,I23,Лист3!$A:$A,$G$1)","v":328700},{"$f":"SUMIFS(Лист3!$E:$E,Лист3!$B:$B,J23,Лист3!$A:$A,$G$1)","v":328650}]

{"sheet":"Лист3","index":2,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[5,5,5,7],[5,8,5,10]]}
[]
[null,null,null,null,null,"в USD"]
[null,null,null,null,null,"в KGS"]
[null,null,null,null,null,"номинал",null,null,74.252499999999998]
[]
[null,null,null,null,null,"Номинал",null,null,"USD"]
["Участок","дата","КП","Пар 0","Пар 30","КП (₽)","Пар 0 (₽)","Пар 30 (₽)","КП ($)","Пар 0 ($)","Пар 30 ($)"]
["Банк","2016-01-01",7550000,1278000,658000,{"$f":"C8/2","v":3775000},{"$f":"D8-258","v":1277742},{"$f":"E8-266","v":657734},{"$f":"C8/$I$4","v":101680.0781118481},{"$f":"D8/$I$4","v":17211.541698932695},8861.6544897478198]
["Филиал","2016-01-01",{"$f":"C8/2","v":3775000},{"$f":"D8/2","v":639000},329000,{"$f":"C9/2","v":1887500},{"$f":"D9-258","v":638742},{"$f":"E9-266","v":328734},{"$f":"C9/$I$4","v":50840.039055924048},{"$f":"D9/$I$4","v":8605.7708494663475},{"$f":"E9/$I$4","v":4430.8272448739099}]
["Банк","2016-01-02",{"$f":"C8-100","v":7549900},{"$f":"D8-100","v":1277900},657900,3774950,1277642,657634,101678.73135584661,17210.194942931215,8860.3077337463383]
["Филиал","2016-01-02",{"$f":"C10/2","v":3774950},{"$f":"D10/2","v":638950},{"$f":"E10/2","v":328950},1887475,638692,328684,50839.365677923306,8605.0974714656077,4430.1538668731691]
["Банк","2016-01-03",{"$f":"C10-100","v":7549800},1277800,657800,3774900,1277542,657534,101677.38459984513,17208.848186929732,8858.9609777448568]
["Филиал","2016-01-03",{"$f":"C12/2","v":3774900},{"$f":"D12/2","v":638900},{"$f":"E12/2","v":328900},1887450,638642,328634,50838.692299922564,8604.424093464866,4429.4804888724284]
["Банк","2016-01-04",{"$f":"C12-100","v":7549700},1277700,657700,3774850,1277442,657434,101676.03784384365,17207.501430928252,8857.6142217433753]
["Филиал","2016-01-04",{"$f":"C14/2","v":3774850},{"$f":"D14/2","v":638850},{"$f":"E14/2","v":328850},1887425,638592,328584,50838.018921921823,8603.7507154641262,4428.8071108716877]
["Банк","2016-01-05",{"$f":"C14-100","v":7549600},1277600,657600,3774800,1277342,657334,101674.69108784216,17206.154674926769,8856.2674657418938]
["Филиал","2016-01-05",{"$f":"C16/2","v":3774800},{"$f":"D16/2","v":638800},{"$f":"E16/2","v":328800},1887400,638542,328534,50837.345543921081,8603.0773374633845,4428.1337328709469]
["Банк","2016-01-06",{"$f":"C16-100","v":7549500},1277500,657500,3774750,1277242,657234,101673.34433184068,17204.807918925289,8854.9207097404123]
["Филиал","2016-01-06",{"$f":"C18/2","v":3774750},{"$f":"D18/2","v":638750},{"$f":"E18/2","v":328750},1887375,638492,328484,50836.672165920339,8602.4039594626447,4427.4603548702062]
["Банк","2016-01-07",{"$f":"C18-100","v":7549400},1277400,657400,3774700,1277142,657134,101671.9975758392,17203.461162923806,8853.5739537389309]
["Филиал","2016-01-07",{"$f":"C20/2","v":3774700},{"$f":"D20/2","v":638700},{"$f":"E20/2","v":328700},1887350,638442,328434,50835.998787919598,8601.7305814619031,4426.7869768694654]
["Банк","2016-01-08",{"$f":"C20-100","v":7549300},1277300,657300,3774650,1277042,657034,101670.65081983771,17202.114406922326,8852.2271977374494]
["Филиал","2016-01-08",{"$f":"C22/2","v":3774650},{"$f":"D22/2","v":638650},{"$f":"E22/2","v":328650},1887325,638392,328384,50835.325409918856,8601.0572034611632,4426.1135988687247]

{"sheet":"СводИдиагр","index":3,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Участок","Филиал",null,{"$f":"\"КП в риске \"&B1&\" (\"&F1&\")\"&H1","v":"КП в риске Филиал (USD)$"},"Курс валюты","USD",{"$f":"VLOOKUP(F1,Данные!F2:H3,3,)","v":74.252499999999998},{"$f":"VLOOKUP(F1,Данные!F2:H3,2,)","v":"$"}]
[]
["дата","Сумма  КП.","Сумма  Пар 0.","Сумма  Пар 30."]
["2016-01-01",50840.039055924048,8605.7708494663475,4430.8272448739099]
["2016-01-02",50839.365677923306,8605.0974714656077,4430.1538668731691]
["2016-01-05",50837.345543921081,8603.0773374633845,4428.1337328709469]
["Общий итог",50838.916759256143,8604.6485527984478,4429.7049482060092]

{"sheet":"Данные","index":4,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[[5,5,5,7],[5,8,5,10]]}
[]
[null,null,null,null,null,"USD","$",74.252499999999998]
[null,null,null,null,null,"KGS","₽",0.95]
[null,null,null,null,null,"номинал",null,null,{"$f":"СводИдиагр!G1","v":74.252499999999998}]
[]
[]
["Участок","дата","КП","Пар 0","Пар 30","Дол"]
["Банк","2016-01-01",7550000,1278000,658000,{"$f":"СводИдиагр!$G$1","v":74.252499999999998}]
["Филиал","2016-01-01",{"$f":"C8/2","v":3775000},{"$f":"D8/2","v":639000},329000,{"$f":"СводИдиагр!$G$1","v":74.252499999999998}]
["Банк","2016-01-02",{"$f":"C8-100","v":7549900},{"$f":"D8-100","v":1277900},657900,{"$f":"СводИдиагр!$G$1","v":74.252499999999998}]
["Филиал","2016-01-02",{"$f":"C10/2","v":3774950},{"$f":"D10/2","v":638950},328950,{"$f":"СводИдиагр!$G$1","v":74.252499999999998}]
["Банк","2016-01-03",{"$f":"C10-100","v":7549800},1277800,657800,{"$f":"СводИдиагр!$G$1","v":74.252499999999998}]
["Филиал","2016-01-03",{"$f":"C12/2","v":3774900},{"$f":"D12/2","v":638900},328900,{"$f":"СводИдиагр!$G$1","v":74.252499999999998}]
["Банк","2016-01-04",{"$f":"C12-100","v":7549700},1277700,657700,{"$f":"СводИдиагр!$G$1","v":74.252499999999998}]
["Филиал","2016-01-04",{"$f":"C14/2","v":3774850},{"$f":"D14/2","v":638850},328850,{"$f":"СводИдиагр!$G$1","v":74.252499999999998}]
["Банк","2016-01-05",{"$f":"C14-100","v":7549600},1277600,657600,{"$f":"СводИдиагр!$G$1","v":74.252499999999998}]
["Филиал","2016-01-05",{"$f":"C16/2","v":3774800},{"$f":"D16/2","v":638800},328800,{"$f":"СводИдиагр!$G$1","v":74.252499999999998}]
["Банк","2016-01-06",{"$f":"C16-100","v":7549500},1277500,657500,{"$f":"СводИдиагр!$G$1","v":74.252499999999998}]
["Филиал","2016-01-06",{"$f":"C18/2","v":3774750},{"$f":"D18/2","v":638750},328750,{"$f":"СводИдиагр!$G$1","v":74.252499999999998}]
["Банк","2016-01-07",{"$f":"C18-100","v":7549400},1277400,657400,{"$f":"СводИдиагр!$G$1","v":74.252499999999998}]
["Филиал","2016-01-07",{"$f":"C20/2","v":3774700},{"$f":"D20/2","v":638700},328700,{"$f":"СводИдиагр!$G$1","v":74.252499999999998}]
["Банк","2016-01-08",{"$f":"C20-100","v":7549300},1277300,657300,{"$f":"СводИдиагр!$G$1","v":74.252499999999998}]
["Филиал","2016-01-08",{"$f":"C22/2","v":3774650},{"$f":"D22/2","v":638650},328650,{"$f":"СводИдиагр!$G$1","v":74.252499999999998}]