{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Исходные данные","отсортировано"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":3,"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":88,"n_cols":35,"rows_kept":88,"cut":false,"hidden":false,"merged":[[17,8,18,8],[17,9,18,9]]}
["Наименование заемщика","Отрасль","Подразделение","вид связи с банком","Наличие графика","вид валюты кредита","Счет ","№ дог.","Лимит задолж.","Свободный лимит","Задолж. на текущ.дату, в рублях и в рубл. эквиваленте","%","Дата выдачи","Дата погашения","пролонга-ция","Дн. до погаш.","Обеспе-чение","% резер-ва","Катег.качества","Расчетный резерв","Факт.сфор. РВПС","Отклонения","Наименование заемщика"]
["Строй УК Финанс  ООО","строительство",null,null,"без гр.",null,{"$f":"[1]Портфель!C48","v":0},{"$f":"[1]Портфель!E48","v":0},0,0,{"$f":"[1]Портфель!H48","v":357280000},{"$f":"[1]Портфель!I48","v":0},{"$f":"[1]Портфель!K48","v":"00:00:00"},{"$f":"[1]Портфель!L48","v":"00:00:00"},{"$f":"[1]Портфель!M48","v":"00:00:00"},{"$f":"O2-#REF!+1","v":{"$error":"#REF!"}},{"$f":"[1]Портфель!P48","v":0},5,{"$f":"[1]Портфель!Q48","v":0},{"$f":"K2*R2%","v":17864000},200200,{"$f":"T2-U2","v":17663800},"Строй УК Финанс  ООО",null,null,{"$f":"W2*R2%","v":{"$error":"#VALUE!"}},null,null,{"$f":"AA2*R2%","v":0},{"$f":"R2%*J2","v":0},{"$f":"K2*1*L2%/365","v":0}]
[{"$f":"[1]Портфель!B17","v":"ИФК \"Авангард\"ООО"},"оптовая и розничная торговля",null,null,null,null,{"$f":"[1]Портфель!C17","v":45107},{"$f":"[1]Портфель!E17","v":4},18000000,{"$f":"I3-K3","v":1000000},{"$f":"[1]Портфель!H17","v":17000000},{"$f":"[1]Портфель!I17","v":14},{"$f":"[1]Портфель!K17","v":"2011-01-25"},{"$f":"[1]Портфель!L17","v":"2013-01-22"},null,{"$f":"N3-$K$1+1","v":{"$error":"#VALUE!"}},"не об.",0,{"$f":"[1]Портфель!Q17","v":2},{"$f":"K3*R3%","v":0},null,0,{"$f":"[1]Портфель!X17","v":0},null,null,null,null,null,null,0,{"$f":"K3*1*L3%/365","v":6520.5479452054797}]
["Габсалямов А.М. ",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C492","v":45509},75,300000,{"$f":"I4-K4","v":71.599999999976717},{"$f":"[1]Портфель!H492","v":299928.40000000002},25,"2010-02-15","2011-02-14",null,{"$f":"N4-$K$1+1","v":{"$error":"#VALUE!"}},"не об.",1,{"$f":"[1]Портфель!Q492","v":1},2999.2840000000001,0,2999.2840000000001,"Габсалямов А.М. ",null,null,{"$f":"W4*R4%","v":{"$error":"#VALUE!"}},null,null,{"$f":"AA4*R4%","v":0},0.71599999999976716,205.43041095890413,null,null,null,{"$f":"AE4*R4%","v":2.0543041095890415}]
["Конт-Ойл ООО(65,0 млн.)","оптовая торговля топливом",null,null,"без гр.",null,{"$f":"[1]Портфель!C33","v":45205},{"$f":"[1]Портфель!E33","v":117},65000000,{"$f":"I5-K5","v":63500000},{"$f":"[1]Портфель!H33","v":1500000},{"$f":"[1]Портфель!I33","v":18},{"$f":"[1]Портфель!K33","v":"2010-09-10"},{"$f":"[1]Портфель!L33","v":"2011-03-03"},null,{"$f":"N5-$K$1+1","v":{"$error":"#VALUE!"}},{"$f":"[1]Портфель!P33","v":"не об."},1,{"$f":"[1]Портфель!Q33","v":2},15000,650000,-635000,"Конт-Ойл ООО(65,0 млн.)",null,null,{"$error":"#VALUE!"},null,null,0,635000,739.72602739726028]
[{"$f":"[1]Портфель!B19","v":"Уралмаркет ООО(50 млн.руб.)"},"оптовая и розничная торговля","ф.кубань",null,"без гр.",null,45201,{"$f":"[1]Портфель!E19","v":"007/11/юл"},3000000,{"$f":"I6-K6","v":-46998420.219999999},{"$f":"[1]Портфель!H19","v":49998420.219999999},20,{"$f":"[1]Портфель!K19","v":"2011-01-28"},{"$f":"[1]Портфель!L19","v":"2011-02-25"},null,{"$f":"N6-$K$1+1","v":{"$error":"#VALUE!"}},"об.",0,{"$f":"[1]Портфель!Q19","v":1},0,null,0,{"$f":"[1]Портфель!X19","v":0},null,null,0,null,null,0,0,{"$f":"K6*1*L6%/365","v":27396.394641095889}]
[{"$f":"[1]Портфель!B18","v":"Итого по сч 45107 ( свыше 1 года)"},"оптовая торговля топливом","ф.кубань",null,"без гр.",null,{"$f":"[1]Портфель!C18","v":0},{"$f":"[1]Портфель!E18","v":0},4000000,{"$f":"I7-K7","v":-102518500},{"$f":"[1]Портфель!H18","v":106518500},{"$f":"[1]Портфель!I18","v":0},{"$f":"[1]Портфель!K18","v":"00:00:00"},{"$f":"[1]Портфель!L18","v":"00:00:00"},null,{"$f":"N7-#REF!+1","v":{"$error":"#REF!"}},{"$f":"[1]Портфель!P18","v":0},0,{"$f":"[1]Портфель!Q18","v":0},0,null,0,{"$f":"[1]Портфель!X18","v":0},null,null,0,null,null,0,0,{"$f":"K7*1*L7%/365","v":0}]
["Васина Н.Ю.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C165","v":45505},"54*20",0,0,{"$f":"[1]Портфель!H165","v":11400000},21,"2010-03-29","2011-02-22",null,{"$f":"N8-$K$1+1","v":{"$error":"#VALUE!"}},"не об.",0,{"$f":"[1]Портфель!Q165","v":1},0,0,0,"Васина Н.Ю.",null,null,{"$error":"#VALUE!"},null,null,0,0,{"$f":"K8*1*L8%/365","v":6558.9041095890407},null,null,null,{"$f":"AE8*R8%","v":0}]
["Астапенко Н.А.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C150","v":45505},"58*20",0,0,{"$f":"[1]Портфель!H150","v":3900000},21,"2010-03-30","2011-02-23",null,{"$f":"N9-$K$1+1","v":{"$error":"#VALUE!"}},"об.",0,{"$f":"[1]Портфель!Q150","v":1},0,0,0,"Астапенко Н.А.",null,null,{"$error":"#VALUE!"},null,null,0,0,2243.8356164383563,"спец.техника",null,null,{"$f":"AE9*R9%","v":0}]
["Центр ООО (50,0 млн. 18.04.11)","оптовая торговля топливом",null,null,"без гр.",null,{"$f":"[1]Портфель!C43","v":45205},{"$f":"[1]Портфель!E43","v":82},50000000,{"$f":"I10-K10","v":48000000},{"$f":"[1]Портфель!H43","v":2000000},{"$f":"[1]Портфель!I43","v":20},{"$f":"[1]Портфель!K43","v":"2010-10-05"},{"$f":"[1]Портфель!L43","v":"2010-12-03"},null,{"$f":"N10-$K$1+1","v":{"$error":"#VALUE!"}},{"$f":"[1]Портфель!O43","v":0},0,{"$f":"[1]Портфель!Q43","v":3},0,0,0,"Центр ООО (50,0 млн. 18.04.11)",null,null,{"$error":"#VALUE!"},null,null,0,0,1095.8904109589041]
["Геотон ООО","оптовая и розничная торговля",null,null,"без гр.",null,{"$f":"[1]Портфель!C31","v":45204},{"$f":"[1]Портфель!E31","v":148},null,null,{"$f":"[1]Портфель!H31","v":1900000},{"$f":"[1]Портфель!I31","v":16},{"$f":"[1]Портфель!K31","v":"2010-07-23"},{"$f":"[1]Портфель!L31","v":"2010-10-05"},null,{"$f":"N11-$K$1+1","v":{"$error":"#VALUE!"}},{"$f":"[1]Портфель!P31","v":"об."},1,{"$f":"[1]Портфель!Q31","v":2},19000,360000,-341000,"Геотон ООО",null,null,{"$error":"#VALUE!"},null,null,0,0,832.8767123287671]
[{"$f":"[1]Портфель!B27","v":"Уральский капитал ОАО"},"оптовая торговля топливом",null,null,null,null,{"$f":"[1]Портфель!C27","v":45204},{"$f":"[1]Портфель!E27","v":"011/11/юл"},null,null,{"$f":"[1]Портфель!H27","v":10000000},{"$f":"[1]Портфель!I27","v":16},{"$f":"[1]Портфель!K27","v":"2011-02-04"},{"$f":"[1]Портфель!L27","v":"2011-05-05"},{"$f":"[1]Портфель!M27","v":"00:00:00"},{"$f":"O12-#REF!+1","v":{"$error":"#REF!"}},{"$f":"[1]Портфель!P27","v":"об."},1,{"$f":"[1]Портфель!Q27","v":3},{"$f":"K12*R12%","v":100000},208380,-108380,{"$f":"[1]Портфель!X27","v":0},null,null,null,null,null,null,0,{"$f":"K12*1*L12%/365","v":4383.5616438356165}]
[{"$f":"[1]Портфель!B16","v":"ИФК \"Авангард\"ООО"},"оптовая торговля топливом","л",null,null,null,{"$f":"[1]Портфель!C16","v":45107},{"$f":"[1]Портфель!E16","v":65},50000000,{"$f":"I13-K13","v":49582000},{"$f":"[1]Портфель!H16","v":418000},{"$f":"[1]Портфель!I16","v":21},{"$f":"[1]Портфель!K16","v":"2010-06-04"},{"$f":"[1]Портфель!L16","v":"2012-05-29"},null,{"$f":"N13-$K$1+1","v":{"$error":"#VALUE!"}},{"$f":"[1]Портфель!P16","v":"нед.об."},0,{"$f":"[1]Портфель!Q16","v":2},0,null,0,{"$f":"[1]Портфель!X16","v":0},null,null,0,null,null,0,0]
["Сорокин И.С.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C261","v":45506},{"$f":"[1]Портфель!E261","v":"123*20"},null,null,{"$f":"[1]Портфель!H261","v":320000},{"$f":"[1]Портфель!I261","v":27},{"$f":"[1]Портфель!K261","v":"2009-12-02"},{"$f":"[1]Портфель!L261","v":"2011-10-02"},{"$f":"[1]Портфель!M261","v":"00:00:00"},{"$f":"O14-#REF!+1","v":{"$error":"#REF!"}},{"$f":"[1]Портфель!P261","v":"об."},21,{"$f":"[1]Портфель!Q261","v":2},67200,2041200,-1974000,"Сорокин И.С.",null,null,null,null,null,null,0,236.7123287671233]
["Тепломаш ООО","оптовая торговля топливом",null,null,"без гр.",null,{"$f":"[1]Портфель!C76","v":45206},{"$f":"[1]Портфель!E76","v":100},null,null,{"$f":"[1]Портфель!H76","v":24899000},{"$f":"[1]Портфель!I76","v":21},{"$f":"[1]Портфель!K76","v":"2010-07-29"},{"$f":"[1]Портфель!L76","v":"2011-01-25"},{"$f":"[1]Портфель!M76","v":"2011-07-22"},{"$f":"O15-#REF!+1","v":{"$error":"#REF!"}},{"$f":"[1]Портфель!P76","v":"не об."},1,{"$f":"[1]Портфель!Q76","v":2},248990,460000,-211010,"Тепломаш ООО",null,null,{"$f":"W15*R15%","v":{"$error":"#VALUE!"}},null,null,{"$f":"AA15*R15%","v":0},0,14325.452054794521]
["Вектор ООО(40,0 млн.)","оптовая торговля топливом",null,null,"без гр.",null,{"$f":"[1]Портфель!C35","v":45205},{"$f":"[1]Портфель!E35","v":115},40000000,{"$f":"I16-K16","v":30000000},{"$f":"[1]Портфель!H35","v":10000000},{"$f":"[1]Портфель!I35","v":18},{"$f":"[1]Портфель!K35","v":"2010-09-03"},{"$f":"[1]Портфель!L35","v":"2011-03-01"},null,{"$f":"N16-$K$1+1","v":{"$error":"#VALUE!"}},{"$f":"[1]Портфель!P35","v":"об."},1,{"$f":"[1]Портфель!Q35","v":2},100000,400000,-300000,"Вектор ООО(40,0 млн.)",null,null,{"$error":"#VALUE!"},null,null,0,300000,4931.5068493150684]
[{"$f":"[1]Портфель!B59","v":"Техмашстрой ООО( 65,0 млн.)"},"прочие отрасли",null,"СК","без гр.",null,{"$f":"[1]Портфель!C60","v":45206},38,70000000,{"$f":"I17-K17-K58","v":500000},{"$f":"[1]Портфель!H60","v":4500000},21,"2010-03-31","2011-02-28",null,{"$f":"N17-$K$1+1","v":{"$error":"#VALUE!"}},"не об.",0,{"$f":"[1]Портфель!Q60","v":1},0,0,0,{"$f":"[1]Портфель!X59","v":0},null,null,0,null,null,0,0,2589.0410958904108,null,null,null,{"$f":"AE17*R17%","v":0}]
[" Мелада  ООО (4 млн.)","строительство",null,null,"без гр.",null,{"$f":"[1]Портфель!C86","v":45205},82,4000000,{"$f":"I18-K18-K19","v":-51000000},{"$f":"[1]Портфель!H86","v":30000000},{"$f":"[1]Портфель!I86","v":25},{"$f":"[1]Портфель!K86","v":"2010-07-29"},"2010-09-24",{"$f":"[1]Портфель!M86","v":"2011-06-29"},{"$f":"O18-#REF!+1","v":{"$error":"#REF!"}},"не об.",21,{"$f":"[1]Портфель!Q86","v":3},6300000,420000,5880000," Мелада  ООО (4 млн.)",null,null,{"$error":"#VALUE!"},null,null,0,-10710000,20547.945205479453]
[" Мелада  ООО (4 млн.)2 тр.","строительство",null,null,"без гр.",null,{"$f":"[1]Портфель!C40","v":45205},82,null,null,{"$f":"[1]Портфель!H40","v":25000000},{"$f":"[1]Портфель!I31","v":16},"2010-10-05","2010-12-03",{"$f":"[1]Портфель!M86","v":"2011-06-29"},{"$f":"O19-#REF!+1","v":{"$error":"#REF!"}},"не об.",21,3,5250000,420000,4830000," Мелада  ООО (4 млн.)2 тр.",null,null,{"$error":"#VALUE!"},null,null,0,0,10958.904109589041]
[{"$f":"[1]Портфель!B58","v":"УралТоргИмпекс ООО"},"строительство",null,null,"без гр.",null,{"$f":"[1]Портфель!C58","v":45206},30,380000,{"$f":"I20-K20","v":-26620000},{"$f":"[1]Портфель!H58","v":27000000},20,"2010-03-25","2010-09-24",{"$f":"[1]Портфель!M58","v":"00:00:00"},{"$f":"O20-#REF!+1","v":{"$error":"#REF!"}},"не об.",21,{"$f":"[1]Портфель!Q58","v":2},5670000,79800,5590200,{"$f":"[1]Портфель!X58","v":0},null,null,0,null,null,0,-5590200,14794.520547945205]
["Сучков А.Н. ",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C529","v":45509},76,40000,{"$f":"I21-K21","v":-7080.239999999998},{"$f":"[1]Портфель!H529","v":47080.24},25,"2010-03-02","2011-03-01",null,{"$f":"N21-$K$1+1","v":{"$error":"#VALUE!"}},"не об.",0,{"$f":"[1]Портфель!Q529","v":1},0,0,0,"Сучков А.Н. ",null,null,{"$error":"#VALUE!"},null,null,0,0,32.246739726027393,null,null,null,{"$f":"AE21*R21%","v":0}]
["Фахретдинов И.М.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C181","v":45505},"28*20",0,0,{"$f":"[1]Портфель!H181","v":0},21,"2010-03-09","2011-03-01",null,{"$f":"N22-$K$1+1","v":{"$error":"#VALUE!"}},"не об.",0,{"$f":"[1]Портфель!Q181","v":2},0,0,0,"Фахретдинов И.М.",null,null,{"$error":"#VALUE!"},null,null,0,0,0,null,null,null,{"$f":"AE22*R22%","v":0}]
["Инфраструктура ООО( 10,0 млн.)","строительство",null,null,"без гр.",null,{"$f":"[1]Портфель!C32","v":0},{"$f":"[1]Портфель!E32","v":0},10000000,null,{"$f":"[1]Портфель!H32","v":62776000},{"$f":"[1]Портфель!I32","v":0},{"$f":"[1]Портфель!K32","v":"00:00:00"},{"$f":"[1]Портфель!L32","v":"00:00:00"},null,{"$f":"N23-$K$1+1","v":{"$error":"#VALUE!"}},{"$f":"[1]Портфель!P32","v":0},1.5,{"$f":"[1]Портфель!Q32","v":0},941640,150000,791640,"Инфраструктура ООО( 10,0 млн.)",null,null,{"$error":"#VALUE!"},null,null,0,0,0]
["Арсланова З.Ф.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C209","v":45505},"36*20",0,0,{"$f":"[1]Портфель!H209","v":16950000},21,"2010-03-15","2011-03-01",null,{"$f":"N24-$K$1+1","v":{"$error":"#VALUE!"}},"об.",0,{"$f":"[1]Портфель!Q209","v":1},0,0,0,"Арсланова З.Ф.",null,null,{"$error":"#VALUE!"},null,null,0,0,9752.0547945205471,null,null,null,{"$f":"AE24*R24%","v":0}]
["Доброневский Р.Л.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C168","v":45505},"22*20",0,0,{"$f":"[1]Портфель!H168","v":10700000},27,"2010-03-04","2011-03-02",null,{"$f":"N25-$K$1+1","v":{"$error":"#VALUE!"}},"нед.об.",0,{"$f":"[1]Портфель!Q168","v":1},0,0,0,"Доброневский Р.Л.",null,null,{"$error":"#VALUE!"},null,null,0,0,7915.0684931506848,"транспорт",null,null,{"$f":"AE25*R25%","v":0}]
["Фролова Л.Г.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C201","v":45505},"27*20",0,0,{"$f":"[1]Портфель!H201","v":6000000},21,"2010-03-09","2011-03-03",null,{"$f":"N26-$K$1+1","v":{"$error":"#VALUE!"}},"не об.",0,{"$f":"[1]Портфель!Q201","v":1},0,0,0,"Фролова Л.Г.",null,null,{"$error":"#VALUE!"},null,null,0,0,3452.0547945205481,null,null,null,{"$f":"AE26*R26%","v":0}]
["Проектно-технол.институт НХП ООО (1,5 млн. н/в)","оптовая торговля топливом",null,null,"без гр.",null,{"$f":"[1]Портфель!C30","v":45203},{"$f":"[1]Портфель!E30","v":165},1500000,{"$f":"I27-K27","v":-18126000},{"$f":"[1]Портфель!H30","v":19626000},{"$f":"[1]Портфель!I30","v":16},{"$f":"[1]Портфель!K30","v":"2010-12-31"},{"$f":"[1]Портфель!L30","v":"2011-01-28"},null,{"$error":"#VALUE!"},{"$f":"[1]Портфель!P30","v":"не об."},3,{"$f":"[1]Портфель!Q30","v":2},588780,45000,543780,"Проектно-технол.институт НХП ООО (1,5 млн. н/в)",null,null,{"$error":"#VALUE!"},null,null,0,-543780,8603.17808219178]
["Зайнитдинов А.С.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C169","v":45505},"59*20",0,0,{"$f":"[1]Портфель!H169","v":6400000},21,"2010-03-30","2011-03-04",null,{"$error":"#VALUE!"},"нед.об.",0,{"$f":"[1]Портфель!Q169","v":1},0,0,0,"Зайнитдинов А.С.",null,null,{"$error":"#VALUE!"},null,null,0,0,3682.1917808219177,"спец.техника",null,null,{"$f":"AE28*R28%","v":0}]
["Крымгужина Ю.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C515","v":45509},78,15000,{"$f":"I29-K29","v":4719.67},{"$f":"[1]Портфель!H515","v":10280.33},25,"2010-03-05","2011-03-04",null,{"$error":"#VALUE!"},"не об.",15,{"$f":"[1]Портфель!Q515","v":1},1542.0494999999999,2221.5100000000002,-679.46050000000037,"Крымгужина Ю.",null,null,{"$error":"#VALUE!"},null,null,0,707.95050000000003,7.0413219178082187,null,null,null,1.0561982876712328]
[{"$f":"[1]Портфель!B20","v":"Глобус ООО(18 млн.)"},null,"ф.Кубань",null,null,null,{"$f":"[1]Портфель!C20","v":45201},{"$f":"[1]Портфель!E20","v":"012/11/ЮЛ/6"},1000000,{"$f":"I30-K30","v":-16999999.09},{"$f":"[1]Портфель!H20","v":17999999.09},{"$f":"[1]Портфель!I20","v":20},{"$f":"[1]Портфель!K24","v":"00:00:00"},{"$f":"[1]Портфель!L20","v":"2011-03-11"},null,{"$error":"#VALUE!"},{"$f":"[1]Портфель!P20","v":"не об."},0,{"$f":"[1]Портфель!Q516","v":1},null,null,null,{"$f":"[1]Портфель!X20","v":0}]
[{"$f":"[1]Портфель!B23","v":"ЮТЭК ООО (1 млн.)"},"оптовая торговля топливом",null,null,"без гр.",null,{"$f":"[1]Портфель!C23","v":45201},{"$f":"[1]Портфель!E23","v":"046-03"},null,null,{"$f":"[1]Портфель!H23","v":842658.35},{"$f":"[1]Портфель!I23","v":19},{"$f":"[1]Портфель!K23","v":"2011-02-04"},{"$f":"[1]Портфель!L23","v":"2011-03-04"},null,{"$f":"N31-$K$1+1","v":{"$error":"#VALUE!"}},{"$f":"[1]Портфель!P23","v":"об."},1,{"$f":"[1]Портфель!Q23","v":2},{"$f":"K31*R31%","v":8426.5835000000006},117500,{"$f":"T31-U31","v":-109073.41649999999},{"$f":"[1]Портфель!X23","v":0},null,null,null,null,null,null,{"$f":"R31%*J31","v":0},{"$f":"K31*1*L31%/365","v":438.64407260273975}]
["Давыдов Е.С.",null,"ф.Кубань",null,"гр.",null,{"$f":"[1]Портфель!C246","v":45505},"ФЛ-025",0,0,{"$f":"[1]Портфель!H246","v":9376.32},22,"2010-03-10","2011-03-04",null,{"$error":"#VALUE!"},"об.",0,{"$f":"[1]Портфель!Q246","v":1},0,0,0,"Давыдов Е.С.",null,"2011-02-10",{"$error":"#VALUE!"},null,null,0,0,5.651480547945205,"транспорт",null,null,0]
["Итого (  до 30 дней)  ",null,null,null,null,null,null,null,{"$f":"SUM(I1:I32)","v":317235000},{"$f":"SUM(J1:J32)","v":-69683208.280000001},{"$f":"SUM(K1:K32)","v":825295242.95000017},null,null,null,null,null,null,null,null,{"$f":"SUM(T1:T32)","v":37177577.917000003},{"$f":"SUM(U1:U32)","v":5554301.5099999998},{"$f":"SUM(V1:V32)","v":31623276.407000005},"Итого (  до 30 дней)  ",null,null,null,null,null,null,0,0,null,null,null,0]
["в т.ч. В валюте",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T34-U34","v":0},"в т.ч. В валюте",null,null,null,null,null,null,0,0,null,null,null,0]
["в т.ч. В рублях",null,null,null,null,null,null,null,null,null,{"$f":"K33-K34","v":825295242.95000017},null,null,null,null,null,null,null,null,null,null,{"$f":"T35-U35","v":0},"в т.ч. В рублях",null,null,null,null,null,null,0,0,null,null,null,0]
[{"$f":"[1]Портфель!B28","v":"СовБурТех ООО(19758т.р.)"},"оптовая и розничная торговля",null,null,"без гр.",null,{"$f":"[1]Портфель!C28","v":45204},148,4425100,{"$f":"I36-K36","v":-5574900},{"$f":"[1]Портфель!H28","v":10000000},{"$f":"[1]Портфель!I28","v":18},{"$f":"[1]Портфель!K28","v":"2011-01-31"},{"$f":"[1]Портфель!L28","v":"2011-10-18"},"2011-03-10",{"$f":"O36-#REF!+1","v":{"$error":"#REF!"}},{"$f":"[1]Портфель!P28","v":"об."},1,2,{"$f":"K36*R36%","v":100000},19000,{"$f":"T36-U36","v":81000},{"$f":"[1]Портфель!X28","v":0},null,null,{"$f":"W36*R36%","v":0},null,null,{"$f":"AA36*R36%","v":0},-55749,4931.5068493150684]
["Афанасьева А.А.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C146","v":45504},"53*20",0,0,{"$f":"[1]Портфель!H146","v":5000000},21,"2010-03-30","2011-03-11",null,{"$f":"N37-$K$1+1","v":{"$error":"#VALUE!"}},"об.",0,{"$f":"[1]Портфель!Q146","v":1},0,0,0,"Афанасьева А.А.",null,null,{"$f":"W37*R37%","v":{"$error":"#VALUE!"}},null,null,{"$f":"AA37*R37%","v":0},0,2876.7123287671234,null,null,null,{"$f":"AE37*R37%","v":0}]
["Габсалямов А.М.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C172","v":45505},"52*20",0,0,{"$f":"[1]Портфель!H172","v":14050000},21,"2010-03-29","2011-03-15",null,{"$error":"#VALUE!"},"об.",1,{"$f":"[1]Портфель!Q172","v":1},140500,67000,73500,"Габсалямов А.М.",null,null,{"$f":"W38*R38%","v":{"$error":"#VALUE!"}},null,null,{"$f":"AA38*R38%","v":0},0,8083.5616438356165,null,null,null,80.835616438356169]
["Маркелова Е.В.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C185","v":45505},"38*20",0,0,{"$f":"[1]Портфель!H185","v":3000000},21,"2010-03-22","2011-03-16",null,{"$error":"#VALUE!"},"нед.об.",0,{"$f":"[1]Портфель!Q185","v":1},0,0,0,"Маркелова Е.В.",null,null,{"$error":"#VALUE!"},null,null,0,0,1726.027397260274,"транспорт",null,null,0]
["Ахметов Д.В.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C187","v":45505},"51*20",0,0,{"$f":"[1]Портфель!H187","v":445000},21,"2010-03-29","2011-03-18",null,{"$error":"#VALUE!"},"об.",0,{"$f":"[1]Портфель!Q187","v":1},0,null,0,"Ахметов Д.В.",null,null,{"$error":"#VALUE!"},null,null,0,0,256.02739726027397,"спец.техника",null,null,0]
["Насибуллин Т.Т.",null,null,null,"без гр.",null,45503,"620*20",null,null,{"$f":"[1]Портфель!H129","v":2212315608.6900001},21,"2010-12-21","2011-03-18",null,{"$error":"#VALUE!"},"не об.",0,1,0,null,0,"Насибуллин Т.Т.",null,null,{"$error":"#VALUE!"},null,null,0,0,1272839.1173284932,null,null,null,0]
["ООО \"РРТЦ Башкортостан\"","оптовая и розничная торговля",null,null,"без гр.",null,45204,156,null,null,{"$f":"[1]Портфель!H26","v":11750000},21,"2010-12-21","2011-03-18",null,{"$error":"#VALUE!"},"не об.",1,2,117500,95000,22500,"ООО \"РРТЦ Башкортостан\"",null,null,{"$error":"#VALUE!"},null,null,0,0,6760.2739726027394,null,null,null,67.602739726027394]
["Яхин Р.Ф.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C226","v":45505},"42*20",0,0,{"$f":"[1]Портфель!H226","v":600000},25,"2010-03-22","2011-03-21",null,{"$f":"N43-$K$1+1","v":{"$error":"#VALUE!"}},"не об.",0,{"$f":"[1]Портфель!Q226","v":1},0,0,0,"Яхин Р.Ф.",null,null,{"$f":"W43*R43%","v":{"$error":"#VALUE!"}},null,null,{"$f":"AA43*R43%","v":0},0,410.95890410958901,null,null,null,0]
["ООО \"Мерфи\"","строительство",null,null,"без гр.",null,{"$f":"[1]Портфель!C81","v":45206},32,0,0,{"$f":"[1]Портфель!H81","v":9900000},18,"2010-03-25","2011-03-24",null,{"$f":"N44-$K$1+1","v":{"$error":"#VALUE!"}},"не об.",51,4,5049000,1122000,3927000,"ООО \"Мерфи\"",null,null,{"$error":"#VALUE!"},null,null,0,0,4882.1917808219177,"поручительство",null,null,2489.9178082191779]
["Любимова Л.Р.",null,null,null,"гр.",null,{"$f":"[1]Портфель!C227","v":45505},"44*20",0,0,{"$f":"[1]Портфель!H227","v":77000},25,"2010-03-25","2011-03-24",null,{"$error":"#VALUE!"},"не об.",0,{"$f":"[1]Портфель!Q227","v":1},0,0,0,"Любимова Л.Р.",null,"2011-02-10",{"$error":"#VALUE!"},null,null,0,0,52.739726027397261,null,null,null,0]
["Борзенков Д.В.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C206","v":45505},"48*20П",0,0,{"$f":"[1]Портфель!H206","v":2270000},21,"2010-03-26","2011-03-24",null,{"$error":"#VALUE!"},"об.",0,{"$f":"[1]Портфель!Q206","v":1},0,0,0,"Борзенков Д.В.",null,null,{"$error":"#VALUE!"},null,null,0,0,1306.027397260274,"спец.техника",null,null,0]
[{"$f":"[1]Портфель!B82","v":"УХБК ОАО"},"оптовая торговля топливом",null,null,"без гр.",null,{"$f":"[1]Портфель!C82","v":45206},34,15000000,{"$f":"I47-K47","v":-1000000},{"$f":"[1]Портфель!H82","v":16000000},21,"2010-03-25","2010-12-20","2011-03-24",{"$f":"O47-$K$1+1","v":{"$error":"#VALUE!"}},"об.",1,{"$f":"[1]Портфель!Q82","v":2},160000,144500,15500,{"$f":"[1]Портфель!X82","v":0},null,null,0,null,null,0,-10000,9205.4794520547948,"товары в обороте",null,null,{"$f":"AE47*R47%","v":92.054794520547944}]
["Михайлов А.А.",null,null,null,"гр.",null,{"$f":"[1]Портфель!C191","v":45505},"47*20",0,0,{"$f":"[1]Портфель!H191","v":310000},25,"2010-03-26","2011-03-25",null,{"$error":"#VALUE!"},"об.",0,{"$f":"[1]Портфель!Q191","v":1},0,0,0,"Михайлов А.А.",null,"2011-02-10",{"$error":"#VALUE!"},null,null,0,0,212.32876712328766,"транспорт",null,null,0]
["Кривошеин Д.А.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C228","v":45505},"47*20П",0,0,{"$f":"[1]Портфель!H228","v":145460},21,"2010-03-26","2011-03-25",null,{"$error":"#VALUE!"},"не об.",0,{"$f":"[1]Портфель!Q228","v":1},0,0,0,"Кривошеин Д.А.",null,null,{"$error":"#VALUE!"},null,null,0,0,83.689315068493144,null,null,null,0]
["Капитал ООО ","оптовая торговля топливом",null,null,"без гр.",null,{"$f":"[1]Портфель!C34","v":45205},{"$f":"[1]Портфель!E34","v":127},null,null,{"$f":"[1]Портфель!H34","v":36000000},{"$f":"[1]Портфель!I34","v":21},{"$f":"[1]Портфель!K34","v":"2010-09-29"},{"$f":"[1]Портфель!L34","v":"2011-02-25"},null,{"$error":"#VALUE!"},{"$f":"[1]Портфель!P34","v":"не об."},1,2,360000,100000,260000,"Капитал ООО ",null,null,{"$error":"#VALUE!"},null,null,0,0,20712.328767123287]
["Капитал ООО ","оптовая торговля топливом",null,null,"без гр.",null,{"$f":"[1]Портфель!C42","v":45205},{"$f":"[1]Портфель!E42","v":138},null,null,{"$f":"[1]Портфель!H42","v":12000000},{"$f":"[1]Портфель!I42","v":21},{"$f":"[1]Портфель!K42","v":"2010-10-29"},{"$f":"[1]Портфель!L42","v":"2011-01-31"},null,{"$error":"#VALUE!"},{"$f":"[1]Портфель!P42","v":"не об."},1,2,120000,200000,-80000,"Капитал ООО ",null,null,{"$error":"#VALUE!"},null,null,0,0,6904.1095890410961]
["Исламов Д.А.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C144","v":45505},"55*20",0,0,{"$f":"[1]Портфель!H144","v":250000},25,"2010-03-30","2011-03-28",null,{"$f":"N52-$K$1+1","v":{"$error":"#VALUE!"}},"об.",21,{"$f":"[1]Портфель!Q144","v":1},52500,110250,-57750,"Исламов Д.А.",null,null,{"$f":"W52*R52%","v":{"$error":"#VALUE!"}},null,null,{"$f":"AA52*R52%","v":0},0,171.23287671232876,"транспорт",null,null,{"$f":"AE52*R52%","v":35.958904109589035}]
["УралТоргИмпекс ООО","оптовая торговля топливом",null,null,"без гр.",null,{"$f":"[1]Портфель!C55","v":45206},{"$f":"[1]Портфель!E55","v":55},0,0,{"$f":"[1]Портфель!H55","v":2700000},{"$f":"[1]Портфель!I55","v":21},{"$f":"[1]Портфель!K55","v":"2010-05-05"},{"$f":"[1]Портфель!L55","v":"2011-04-25"},null,{"$f":"N53-$K$1+1","v":{"$error":"#VALUE!"}},{"$f":"[1]Портфель!P55","v":"не об."},1,{"$f":"[1]Портфель!Q55","v":2},27000,270000,-243000,"УралТоргИмпекс ООО",null,null,{"$f":"W53*R53%","v":{"$error":"#VALUE!"}},null,null,{"$f":"AA53*R53%","v":0},0,1553.4246575342465]
["Салимгареев Р.Р.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C151","v":45505},"50*20",0,0,{"$f":"[1]Портфель!H151","v":13998.14},21,"2010-03-29","2011-03-28",null,{"$f":"N54-$K$1+1","v":{"$error":"#VALUE!"}},"об.",0,{"$f":"[1]Портфель!Q151","v":1},0,0,0,"Салимгареев Р.Р.",null,null,{"$f":"W54*R54%","v":{"$error":"#VALUE!"}},null,null,{"$f":"AA54*R54%","v":0},0,8.0537243835616437,"спец.техника",null,null,{"$f":"AE54*R54%","v":0}]
[{"$f":"[1]Портфель!B128","v":"Итого по сч.45407"},null,null,null,"без гр.",null,{"$f":"[1]Портфель!C128","v":0},{"$f":"[1]Портфель!E128","v":0},null,null,{"$f":"[1]Портфель!H128","v":24756130.450000003},{"$f":"[1]Портфель!I128","v":0},{"$f":"[1]Портфель!K128","v":"00:00:00"},{"$f":"[1]Портфель!L128","v":"00:00:00"},null,{"$f":"N55-$K$1+1","v":{"$error":"#VALUE!"}},{"$f":"[1]Портфель!P128","v":0},0,1,0,null,0,{"$f":"[1]Портфель!X128","v":0},null,null,null,null,null,null,0,0]
["Аминев Ш.Ф.",null,null,null,"гр.",null,{"$f":"[1]Портфель!C132","v":45503},{"$f":"[1]Портфель!E132","v":"620*20"},null,null,{"$f":"[1]Портфель!H132","v":870000},{"$f":"[1]Портфель!I132","v":21},{"$f":"[1]Портфель!K132","v":"2010-12-21"},{"$f":"[1]Портфель!L132","v":"2011-03-18"},null,{"$f":"N56-#REF!+1","v":{"$error":"#REF!"}},{"$f":"[1]Портфель!P132","v":"не об."},0,{"$f":"[1]Портфель!Q132","v":1},0,null,0,"Аминев Ш.Ф.",null,"2011-02-10",{"$f":"W56*R56%","v":{"$error":"#VALUE!"}},null,null,{"$f":"AA56*R56%","v":0},0,500.54794520547944]
["Саттаров А.Р.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C263","v":45506},"148*20",0,0,{"$f":"[1]Портфель!H263","v":238000},25,"2009-12-29","2010-06-25",{"$f":"[1]Портфель!M263","v":"00:00:00"},{"$f":"O57-#REF!+1","v":{"$error":"#REF!"}},"не об.",1,{"$f":"[1]Портфель!Q263","v":2},2380,60000,-57620,"Саттаров А.Р.",null,null,{"$error":"#VALUE!"},null,null,{"$f":"AA57*R57%","v":0},0,163.01369863013699,null,null,null,{"$f":"AE57*R57%","v":1.6301369863013699}]
[{"$f":"[1]Портфель!B60","v":"Глобус ООО"},"прочие отрасли",null,"СК","без гр.",null,{"$f":"[1]Портфель!C59","v":45206},38,70000000,null,{"$f":"[1]Портфель!H59","v":65000000},21,"2010-03-31","2011-03-30",null,{"$f":"N58-$K$1+1","v":{"$error":"#VALUE!"}},"не об.",0,{"$f":"[1]Портфель!Q59","v":2},0,0,0,{"$f":"[1]Портфель!X60","v":0},null,null,0,null,null,{"$f":"AA58*R58%","v":0},0,37397.260273972606,null,null,null,{"$f":"AE58*R58%","v":0}]
["Гайсин Ш.М. ",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C489","v":45509},84,300000,{"$f":"I59-K59","v":230085.99},{"$f":"[1]Портфель!H489","v":69914.009999999995},25,"2010-04-02","2011-04-01",null,{"$error":"#VALUE!"},"не об.",0,{"$f":"[1]Портфель!Q489","v":1},0,0,0,"Гайсин Ш.М. ",null,null,{"$error":"#VALUE!"},null,null,{"$f":"AA59*R59%","v":0},0,47.886308219178076,null,null,null,{"$f":"AE59*R59%","v":0}]
["Маломожнова Т.В. ",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C519","v":45509},85,20000,{"$f":"I60-K60","v":5760.43},{"$f":"[1]Портфель!H519","v":14239.57},25,"2010-04-02","2011-04-01",null,{"$error":"#VALUE!"},"не об.",0,{"$f":"[1]Портфель!Q519","v":1},0,0,0,"Маломожнова Т.В. ",null,null,{"$error":"#VALUE!"},null,null,0,0,9.7531301369863019,null,null,null,{"$f":"AE60*R60%","v":0}]
["Тоноян Т.А.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C220","v":45505},"65*20",0,0,{"$f":"[1]Портфель!H220","v":26452.22},25,"2010-04-02","2011-04-01",null,{"$error":"#VALUE!"},"об.",0,{"$f":"[1]Портфель!Q220","v":1},0,0,0,"Тоноян Т.А.",null,null,{"$error":"#VALUE!"},null,null,0,0,18.117958904109589,"поручительство",null,null,{"$f":"AE61*R61%","v":0}]
["Моругов Е.А.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C518","v":45509},{"$f":"[2]Портфель!E427","v":{"$error":"#REF!"}},100000,{"$f":"I62-K62","v":85189.94},{"$f":"[1]Портфель!H518","v":14810.06},{"$f":"[2]Портфель!H427","v":{"$error":"#REF!"}},{"$f":"[3]Портфель!J427","v":{"$error":"#REF!"}},{"$f":"[3]Портфель!K427","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"[2]Портфель!N427","v":{"$error":"#REF!"}},0,{"$f":"[2]Портфель!O427","v":{"$error":"#REF!"}},0,null,0,"Моругов Е.А.",null,null,{"$error":"#VALUE!"},null,null,0,0,{"$error":"#REF!"}]
["Павлов К.С.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C182","v":45505},"73*20",0,0,{"$f":"[1]Портфель!H182","v":285050},21,"2010-04-12","2011-04-04",null,{"$error":"#VALUE!"},"об.",0,{"$f":"[1]Портфель!Q182","v":1},0,0,0,"Павлов К.С.",null,null,{"$error":"#VALUE!"},null,null,0,0,164.00136986301371,"транспорт",null,null,{"$f":"AE63*R63%","v":0}]
["Гарипова Е.Н.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C491","v":45509},88,30000,{"$f":"I64-K64","v":-266617.01},{"$f":"[1]Портфель!H491","v":296617.01},25,"2010-04-07","2011-04-06",null,{"$error":"#VALUE!"},"не об.",0,{"$f":"[1]Портфель!Q491","v":1},0,0,0,"Гарипова Е.Н.",null,null,{"$error":"#VALUE!"},null,null,0,0,203.16233561643836,null,null,null,{"$f":"AE64*R64%","v":0}]
["Вильданов Ш.Н.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C487","v":45509},89,20000,{"$f":"I65-K65","v":20000},{"$f":"[1]Портфель!H487","v":0},25,"2010-04-08","2011-04-07",null,{"$error":"#VALUE!"},"не об.",0,{"$f":"[1]Портфель!Q487","v":1},0,0,0,"Вильданов Ш.Н.",null,null,{"$error":"#VALUE!"},null,null,0,0,0,null,null,null,{"$f":"AE65*R65%","v":0}]
["Хамадиев А.В.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C210","v":45505},"72*20",0,0,{"$f":"[1]Портфель!H210","v":1120000},21,"2010-04-12","2011-04-11",null,{"$error":"#VALUE!"},"об.",0,{"$f":"[1]Портфель!Q210","v":1},0,0,0,"Хамадиев А.В.",null,null,{"$error":"#VALUE!"},null,null,0,{"$f":"R66%*J66","v":0},{"$f":"K66*1*L66%/365","v":644.38356164383561},"транспорт",null,null,{"$f":"AE66*R66%","v":0}]
[{"$f":"[1]Портфель!B127","v":"ИП Бондарь И.В.(10млн.)"},null,null,null,"без гр.",null,{"$f":"[1]Портфель!C127","v":45407},{"$f":"[1]Портфель!E127","v":"006-02"},null,null,{"$f":"[1]Портфель!H127","v":9822000},{"$f":"[1]Портфель!I127","v":19},{"$f":"[1]Портфель!K127","v":"2011-01-18"},{"$f":"[1]Портфель!L127","v":"2013-01-16"},null,{"$error":"#VALUE!"},"не об.",0,{"$f":"[1]Портфель!Q127","v":1},0,null,0,{"$f":"[1]Портфель!X127","v":0},null,null,null,null,null,null,0,5112.821917808219]
["Васильев А.В.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C184","v":45505},"76*20",0,0,{"$f":"[1]Портфель!H184","v":14000000},25,"2010-04-14","2011-04-13",null,{"$f":"N68-$K$1+1","v":{"$error":"#VALUE!"}},"об.",0,{"$f":"[1]Портфель!Q184","v":1},{"$f":"K68*R68%","v":0},0,0,"Васильев А.В.",null,null,{"$f":"W68*R68%","v":{"$error":"#VALUE!"}},null,null,{"$f":"AA68*R68%","v":0},0,9589.0410958904104]
[{"$f":"[1]Портфель!B80","v":"Тентур ООО ( 38,0 млн.)"},"оптовая торговля топливом",null,null,"без гр.",null,{"$f":"[1]Портфель!C80","v":45206},{"$f":"[1]Портфель!E80","v":151},null,null,{"$f":"[1]Портфель!H80","v":38000000},{"$f":"[1]Портфель!I80","v":21},{"$f":"[1]Портфель!K80","v":"2010-12-06"},{"$f":"[1]Портфель!L80","v":"2011-12-05"},null,{"$error":"#VALUE!"},{"$f":"[1]Портфель!P80","v":"не об."},1,{"$f":"[1]Портфель!Q80","v":2},380000,400000,-20000,{"$f":"[1]Портфель!X80","v":0},null,null,null,null,null,null,0,21863.013698630137]
["Дианит  ООО(60,0 млн.)","оптовая торговля топливом",null,null,"без гр.",null,{"$f":"[1]Портфель!C70","v":45206},48,60000000,{"$f":"I70-K70","v":25000000},{"$f":"[1]Портфель!H70","v":35000000},21,"2010-04-19","2011-04-18",null,{"$error":"#VALUE!"},"об.",1,{"$f":"[1]Портфель!Q70","v":2},350000,600000,-250000,"Дианит  ООО(60,0 млн.)",null,null,{"$f":"W70*R70%","v":{"$error":"#VALUE!"}},null,null,{"$f":"AA70*R70%","v":0},250000,20136.986301369863,null,null,null,{"$f":"AE70*R70%","v":201.36986301369865}]
["Габсалямова О.С.( 300,0 т.р.)",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C493","v":45509},"90*20",300000,{"$f":"I71-K71","v":150293.04999999999},{"$f":"[1]Портфель!H493","v":149706.95000000001},25,"2010-04-16","2011-04-15",null,{"$error":"#VALUE!"},"не об.",0,{"$f":"[1]Портфель!Q493","v":1},0,0,0,"Габсалямова О.С.( 300,0 т.р.)",null,null,{"$error":"#VALUE!"},null,null,0,0,102.53900684931507,null,null,null,0]
[{"$f":"[1]Портфель!B94","v":"Райпищекомбинат Красноармейский ООО( 30,0 млн.)"},"оптовая и розничная торговля","ф.Кубань",null,"без гр.",null,{"$f":"[1]Портфель!C94","v":45206},"ЮЛ-023",5000000,{"$f":"I72-K72","v":3000000},{"$f":"[1]Портфель!H94","v":2000000},20,"2010-04-29","2011-04-20",null,{"$error":"#VALUE!"},"об.",0,{"$f":"[1]Портфель!Q94","v":1},0,0,0,{"$f":"[1]Портфель!X94","v":0},null,null,0,null,null,0,0,1095.8904109589041,"товары в обороте",null,null,0]
[" ПКФ \"Уют-Сервис\"ООО","оптовая и розничная торговля","ф.Кубань",null,"без гр.",null,45207,"026-03",0,0,{"$f":"[1]Портфель!H110","v":787500},20,"2010-05-27","2011-04-20",null,{"$error":"#VALUE!"},"об.",0,1,0,0,0," ПКФ \"Уют-Сервис\"ООО",null,null,{"$error":"#VALUE!"},null,null,0,0,431.50684931506851,null,null,null,0]
["Мухамадисламова Э.В.( 65,0 т.р.)",null,null,"Инс.","без гр.",null,{"$f":"[1]Портфель!C522","v":45509},91,65000,{"$f":"I74-K74","v":58445.47},{"$f":"[1]Портфель!H522","v":6554.53},25,"2010-04-23","2011-04-22",null,{"$error":"#VALUE!"},"не об.",0,{"$f":"[1]Портфель!Q522","v":1},0,0,0,"Мухамадисламова Э.В.( 65,0 т.р.)",null,null,{"$error":"#VALUE!"},null,null,0,0,4.4894041095890413,null,null,null,0]
["Усова Е.Ю.",null,null,null,"гр.",null,{"$f":"[1]Портфель!C175","v":45505},"79*20",0,0,{"$f":"[1]Портфель!H175","v":6700000},25,"2010-04-23","2011-04-22",null,{"$error":"#VALUE!"},"не об.",0,{"$f":"[1]Портфель!Q175","v":2},0,0,0,"Усова Е.Ю.",null,"2011-02-10",{"$error":"#VALUE!"},null,null,0,0,4589.0410958904113,null,null,null,0]
["Строй УК Финанс  ООО(2,7 млн.)","строительство",null,null,"без гр.",null,{"$f":"[1]Портфель!C52","v":45206},55,2700000,{"$f":"I76-K76","v":-7300000},{"$f":"[1]Портфель!H52","v":10000000},21,"2010-05-05","2011-04-25",null,{"$f":"N76-$K$1+1","v":{"$error":"#VALUE!"}},"не об.",5,2,500000,135000,365000,"Строй УК Финанс  ООО(2,7 млн.)",null,null,{"$error":"#VALUE!"},null,null,0,-365000,5753.4246575342468,null,null,null,287.67123287671234]
["Мистраль  ООО(65,0 млн.)","оптовая торговля топливом",null,null,"без гр.",null,{"$f":"[1]Портфель!C72","v":45206},53,65000000,{"$f":"I77-K77","v":5000000},{"$f":"[1]Портфель!H72","v":60000000},21,"2010-04-29","2011-04-25",null,{"$f":"N77-$K$1+1","v":{"$error":"#VALUE!"}},"не об.",1,{"$f":"[1]Портфель!Q72","v":2},600000,650000,-50000,"Мистраль  ООО(65,0 млн.)",null,null,{"$error":"#VALUE!"},null,null,0,50000,34520.547945205479,null,null,null,345.20547945205482]
["Трофимец С.Н.( 500,0 т.р.)",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C530","v":45509},null,500000,{"$f":"I78-K78","v":496321.65},{"$f":"[1]Портфель!H530","v":3678.35},25,"2010-04-28","2011-04-27",null,{"$f":"N78-$K$1+1","v":{"$error":"#VALUE!"}},"не об.",0,1,0,0,0,"Трофимец С.Н.( 500,0 т.р.)",null,null,{"$error":"#VALUE!"},null,null,0,0,2.519417808219178,null,null,null,{"$f":"AE78*R78%","v":0}]
[{"$f":"[1]Портфель!B161","v":"Зиннатуллин А.М."},null,null,null,"без гр.",null,{"$f":"[1]Портфель!C161","v":45505},"93*20",0,0,{"$f":"[1]Портфель!H161","v":5000000},21,"2010-05-12","2011-04-28",null,{"$f":"N79-$K$1+1","v":{"$error":"#VALUE!"}},"об.",0,{"$f":"[1]Портфель!Q161","v":1},0,0,0,{"$f":"[1]Портфель!X161","v":0},null,null,0,null,null,0,0,2876.7123287671234,null,null,null,{"$f":"AE79*R79%","v":0}]
["Зейтунян И.С.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C133","v":0},{"$f":"[1]Портфель!E133","v":0},0,0,{"$f":"[1]Портфель!H133","v":3600000},{"$f":"[1]Портфель!I133","v":0},{"$f":"[1]Портфель!K133","v":"00:00:00"},{"$f":"[1]Портфель!L133","v":"00:00:00"},null,{"$f":"N80-#REF!+1","v":{"$error":"#REF!"}},{"$f":"[1]Портфель!P133","v":0},0,{"$f":"[1]Портфель!Q133","v":0},0,0,0,"Зейтунян И.С.",null,null,{"$error":"#VALUE!"},null,null,0,0,0]
["Путенихин М.А.( 40,0 т.р.)",null,null,"Инс.","без гр.",null,{"$f":"[1]Портфель!C526","v":45509},93,120000,{"$f":"I81-K81","v":98033.12},{"$f":"[1]Портфель!H526","v":21966.880000000001},25,"2010-04-29","2011-04-28",null,{"$f":"N81-$K$1+1","v":{"$error":"#VALUE!"}},"не об.",0,{"$f":"[1]Портфель!Q526","v":1},0,0,0,"Путенихин М.А.( 40,0 т.р.)",null,null,{"$error":"#VALUE!"},null,null,0,0,15.045808219178083,null,null,null,{"$f":"AE81*R81%","v":0}]
["Хабипов М.Ф.",null,null,"СК","гр.",null,{"$f":"[1]Портфель!C267","v":45506},"68*20",0,0,{"$f":"[1]Портфель!H267","v":37270},25,"2008-05-08","2011-04-29",null,{"$f":"N82-$K$1+1","v":{"$error":"#VALUE!"}},"об.",0,{"$f":"[1]Портфель!Q267","v":2},0,0,0,"Хабипов М.Ф.",null,"2011-02-10",{"$error":"#VALUE!"},null,null,0,0,25.527397260273972,"транспорт",null,null,{"$f":"AE82*R82%","v":0}]
["Шарипов Р.Р.",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C265","v":45506},"90*20",0,0,{"$f":"[1]Портфель!H265","v":213999.45},25,"2009-11-02","2010-11-01","2011-04-30",{"$f":"O83-#REF!+1","v":{"$error":"#REF!"}},"не об.",51,{"$f":"[1]Портфель!Q265","v":1},109139.71950000001,15453000,-15343860.2805,"Шарипов Р.Р.",null,null,{"$error":"#VALUE!"},null,null,0,0,146.57496575342466,null,null,null,{"$f":"AE83*R83%","v":74.753232534246578}]
["Тавабилова Д.Р. (15,0 т.р.)",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C532","v":45509},95,15000,{"$f":"I84-K84","v":-18439.800000000003},{"$f":"[1]Портфель!H532","v":33439.800000000003},25,"2010-04-30","2011-04-30",null,{"$f":"N84-$K$1+1","v":{"$error":"#VALUE!"}},"не об.",0,{"$f":"[1]Портфель!Q532","v":1},0,0,0,"Тавабилова Д.Р. (15,0 т.р.)",null,null,{"$error":"#VALUE!"},null,null,0,0,22.903972602739728,null,null,null,{"$f":"AE84*R84%","v":0}]
["Беленкова А.В.(150 т.р.)",null,null,"Инс.","без гр.",null,{"$f":"[1]Портфель!C486","v":45509},98,150000,{"$f":"I85-K85","v":125092.07},{"$f":"[1]Портфель!H486","v":24907.93},25,"2010-05-05","2011-05-04",null,{"$f":"N85-$K$1+1","v":{"$error":"#VALUE!"}},"не об.",0,{"$f":"[1]Портфель!Q486","v":1},{"$f":"K85*R85%","v":0},0,{"$f":"T85-U85","v":0},"Беленкова А.В.(150 т.р.)",null,null,{"$f":"W85*R85%","v":{"$error":"#VALUE!"}},null,null,{"$f":"AA85*R85%","v":0},{"$f":"R85%*J85","v":0},{"$f":"K85*1*L85%/365","v":17.06022602739726},null,null,null,{"$f":"AE85*R85%","v":0}]
[{"$f":"[1]Портфель!B24","v":"Итого по сч 45201 ( до 30 дней)"},null,"л",null,"без гр.",null,{"$f":"[1]Портфель!C24","v":0},{"$f":"[1]Портфель!E24","v":0},null,null,{"$f":"[1]Портфель!H24","v":71269930.609999985},{"$f":"[1]Портфель!I24","v":0},{"$f":"[1]Портфель!K24","v":"00:00:00"},{"$f":"[1]Портфель!L24","v":"00:00:00"},null,{"$f":"N86-$K$1+1","v":{"$error":"#VALUE!"}},{"$f":"[1]Портфель!P24","v":0},21,{"$f":"[1]Портфель!Q24","v":0},{"$f":"K86*R86%","v":14966685.428099995},2100000,{"$f":"T86-U86","v":12866685.428099995},{"$f":"[1]Портфель!X24","v":0}]
["Уронова А.М. (10,0 т.р.)",null,null,null,"без гр.",null,{"$f":"[1]Портфель!C534","v":45509},94,10000,{"$f":"I87-K87","v":-165814.29999999999},{"$f":"[1]Портфель!H534","v":175814.3},25,"2010-04-30","2011-04-30",null,{"$f":"N87-$K$1+1","v":{"$error":"#VALUE!"}},"не об.",0,{"$f":"[1]Портфель!Q534","v":1},0,0,0,"Уронова А.М. (10,0 т.р.)",null,null,{"$error":"#VALUE!"},null,null,0,0,120.42075342465752,null,null,null,{"$f":"AE87*R87%","v":0}]
["Итого (31-90 дн.) ",null,null,null,null,null,null,null,{"$f":"SUM(I36:I87)","v":223755100},{"$f":"SUM(J36:J87)","v":19943450.609999999},{"$f":"SUM(K36:K87)","v":2686365048.9500003},null,null,null,null,null,null,null,null,{"$f":"SUM(T36:T87)","v":23034705.147599995},{"$f":"SUM(U36:U87)","v":21525750},{"$f":"SUM(V26:V87)","v":33566258.677599996},"Итого (31-90 дн.) ",{"$f":"SUM(X45:X87)","v":0},null,{"$f":"SUM(Z45:Z87)","v":{"$error":"#VALUE!"}},{"$f":"SUM(AA21:AA71)","v":0},{"$f":"SUM(AB21:AB71)","v":0},{"$f":"SUM(AC21:AC71)","v":0},0,0,null,null,null,0]

{"sheet":"отсортировано","index":1,"n_rows":1,"n_cols":22,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Наименование заемщика","Отрасль","Подразделение","вид связи с банком","Наличие графика","вид валюты кредита","Счет ","№ дог.","Лимит задолж.","Свободный лимит","Задолж. на текущ.дату, в рублях и в рубл. эквиваленте","%","Дата выдачи","Дата погашения","пролонга-ция","Дн. до погаш.","Обеспе-чение","% резер-ва","Катег.качества","Расчетный резерв","Факт.сфор. РВПС","Отклонения"]