{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Кредиторы","Векселя"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Кредиторы","index":0,"n_rows":35,"n_cols":23,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,0,1,17],[2,0,2,17],[4,0,8,0],[4,1,8,1],[4,2,8,2],[4,3,4,5],[4,6,4,7],[4,8,5,10],[6,4,6,5],[6,6,8,6],[6,7,8,7],[6,9,7,12],[4,11,5,11],[4,12,5,12],[4,13,4,17],[5,3,5,5],[5,6,5,7],[5,13,5,17],[6,13,8,13],[7,4,8,4],[7,5,8,5],[7,14,8,14],[7,15,8,15],[10,21,10,22],[34,21,34,22],[7,16,8,16],[7,17,8,17],[7,21,7,22],[8,21,8,22],[9,21,9,22]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Приложение №11"]
["СТРУКТУРА, ИЗМЕНЕНИЕ КРЕДИТОРСКОЙ ЗАДОЛЖЕННОСТИ"]
[{"$f":"'[1]#REF'!A2:G2","v":{"$error":"#REF!"}}]
[]
["№","Наименование","Норма-      тив","За предшествующий год",null,null,"Изм-е за предшест.",null,"За планируемый ",null,null,{"$f":"Векселя!F5","v":"2013 год"},null,"Изменение за планируемый"]
[null,null,null,{"$f":"Векселя!D5","v":"2012 год"},null,null,"год: (+) прир. (-) сниж.",null,null,null,null,null,null,"год: (+) прирост (-) -снижение"]
[null,null,null,"нали-",{"$f":"\"31.12.2012\"","v":"31.12.2012"},null,"план        (гр 5-гр 4)","факт         (гр 6-гр 4)","нали-","Плановое наличие              на конец квартала",null,null,null,"Год (гр 9-    гр 6)",{"$f":"Векселя!G6","v":"I кв."},{"$f":"Векселя!H6","v":"II кв."},{"$f":"Векселя!I6","v":"III кв."},{"$f":"Векселя!J6","v":"IV кв."}]
[null,null,null,"чие на","план","факт ",null,null,"чие на",null,null,null,null,null,"гр10-  гр6","гр11-гр10","гр12-гр11","гр13-гр12",null,{"$f":"L5","v":"2013 год"},"отклонение","Источник "]
[null,null,null,null,null,null,null,null,{"$f":"\"31.12.2013 г.\"","v":"31.12.2013 г."},"2003-04-01","2003-07-01","2003-10-01","2003-12-31",null,null,null,null,null,null,"источник","гр.14-гр.19","информации"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,null,{"$f":"R10+1","v":19},{"$f":"T10+1","v":20},{"$f":"U10+1","v":21},{"$f":"V10+1","v":22}]
["I","Кредиторская задолженность, всего",{"$f":"C13+C20+C21+C22+C23+C24+C25+C26","v":0},null,{"$f":"E13+E20+E21+E22+E23+E24+E25+E26","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Приложения №2 и №3"]
[null,"в том числе:"]
["1.1.","Поставщики и подрядчики",{"$f":"C14+C19","v":0},{"$f":"D14+D19","v":0},0,0,0,0,0,0,52,0,0,0,0,52,-52,0]
["1.1.1"," в т.ч. АК\"АЛРОСА\" всего",{"$f":"SUM(C16:C18)","v":0},{"$f":"SUM(D16:D18)","v":0},{"$f":"SUM(E16:E18)","v":0},0,0,0,0,0,52,0,0,0,0,52,-52,0]
[null,"из них по подразделениям"]
[null,"не определено ",null,0,0,0,{"$f":"E16-D16","v":0},{"$f":"F16-D16","v":0},{"$f":"M16","v":0},0,0,0,0,{"$f":"I16-F16","v":0},{"$f":"J16-F16","v":0},{"$f":"K16-J16","v":0},0,0]
[null,"не определено ",null,0,0,0,{"$f":"E17-D17","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"не определено ",0,0,0,0,{"$f":"E18-D18","v":0},0,0,0,52,0,0,0,0,52,-52,0]
["1.1.2","другие поставщики и подрядчики",null,null,null,null,{"$f":"E19-D19","v":0},{"$f":"F19-D19","v":0},{"$f":"M19","v":0},null,null,null,null,{"$f":"I19-F19","v":0},{"$f":"J19-F19","v":0},{"$f":"K19-J19","v":0},{"$f":"L19-K19","v":0},{"$f":"M19-L19","v":0}]
["1.2.","Векселя к уплате",0,null,null,null,0,0,-111111111,{"$f":"Векселя!G31+Векселя!G32","v":0},{"$f":"Векселя!H31+Векселя!H32","v":0},{"$f":"Векселя!I31+Векселя!I32","v":0},{"$f":"Векселя!J31+Векселя!J32","v":-111111111},-111111111,0,0,0,-111111111]
["1.3.","Задолженность перед персоналом  организации",0,null,null,null,0,0,0,null,null,null,null,0,0,0,0,0]
["1.4.","Задолженность перед гос. внебюджетными фондами",0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["1.5.","Задолженность по налогам и сборам",0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["1.6."," Прочие кредиторы",0,null,null,null,0,0,0,null,null,null,null,{"$f":"I24-F24","v":0},{"$f":"J24-F24","v":0},0,0,0]
["1.7.","Задолженность перед дочерними и зависимыми обществами",0,0,null,0,{"$f":"E25-D25","v":0},{"$f":"F25-D25","v":0},{"$f":"M25","v":0},null,null,null,null,{"$f":"I25-F25","v":0},{"$f":"J25-F25","v":0},0,0,0]
["1.8.","Авансы полученные",0,0,0,null,0,0,0,null,null,null,null,0,0,0,0,0]
[null," в т.ч. АК\"АЛРОСА\" всего",{"$f":"SUM(C29:C31)","v":0},{"$f":"SUM(D29:D31)","v":0},{"$f":"SUM(E29:E31)","v":0},0,{"$f":"SUM(G29:G31)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"из них по подразделениям"]
[null,"не определено ",0,0,0,0,{"$f":"E29-D29","v":0},{"$f":"F29-D29","v":0},{"$f":"M29","v":0},0,0,0,0,{"$f":"I29-F29","v":0},{"$f":"J29-F29","v":0},{"$f":"K29-J29","v":0},0,0]
[null,"не определено ",0,0,0,0,{"$f":"E30-D30","v":0},{"$f":"F30-D30","v":0},{"$f":"M30","v":0},0,0,0,0,{"$f":"I30-F30","v":0},{"$f":"J30-F30","v":0},0,0,0]
[null,"не определено ",0,0,0,0,{"$f":"E31-D31","v":0},{"$f":"F31-D31","v":0},{"$f":"M31","v":0},0,0,0,0,{"$f":"I31-F31","v":0},{"$f":"J31-F31","v":0},0,0,0]
[]
[]
[null,"кроме того"]
["II","Задолженность учредителям по выплате доходов",0,0,0,0,{"$f":"E35-D35","v":0},{"$f":"F35-D35","v":0},{"$f":"M35","v":0},0,0,0,0,{"$f":"I35-F35","v":0},{"$f":"J35-F35","v":0},{"$f":"K35-J35","v":0},{"$f":"L35-K35","v":0},{"$f":"M35-L35","v":0},null,null,{"$f":"N35-T35","v":0},"Приложения №2 и №3"]

{"sheet":"Векселя","index":1,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,0,1,9],[2,0,2,9],[4,1,6,1],[4,3,4,4],[4,6,4,9],[5,5,6,5],[5,6,6,6],[5,7,6,7],[5,8,6,8],[5,9,6,9]]}
[null,null,null,null,null,null,null,null,null,{"$f":"\"Приложение №15\"","v":"Приложение №15"}]
[{"$f":"\"План движения вексельной задолженности\"","v":"План движения вексельной задолженности"}]
[{"$f":"\"ЗАО ''Гостиницы АЛРОСА'' на \"&YEAR(TODAY()+360)&\" год\"","v":"ЗАО ''Гостиницы АЛРОСА'' на 2013 год"}]
[null,null,null,null,null,null,null,null,null,"тыс.руб."]
["№",{"$f":"\"Наименование\"","v":"Наименование"},{"$f":"\"2011 год\"","v":"2011 год"},{"$f":"\"2012 год\"","v":"2012 год"},null,{"$f":"\"2013 год\"","v":"2013 год"},{"$f":"\"в т.ч. по квартально\"","v":"в т.ч. по квартально"}]
["п/п",null,{"$f":"\"отчет\"","v":"отчет"},{"$f":"\"план\"","v":"план"},{"$f":"\"ожид\"","v":"ожид"},{"$f":"\"план\"","v":"план"},{"$f":"\"I кв.\"","v":"I кв."},{"$f":"\"II кв.\"","v":"II кв."},{"$f":"\"III кв.\"","v":"III кв."},{"$f":"\"IV кв.\"","v":"IV кв."}]
[]
[{"$f":"1","v":1},{"$f":"A8+1","v":2},{"$f":"B8+1","v":3},4,5,6,7,8,9,10]
[{"$f":"1","v":1},{"$f":"\"Остаток на начало периода всего\"","v":"Остаток на начало периода всего"},{"$f":"C11+C13","v":13},{"$f":"D11+D13","v":5},0,0,{"$f":"G11+G13","v":0},0,0,0]
[" ",{"$f":"\"кроме того проценты всего\"","v":"кроме того проценты всего"},{"$f":"C12+C14","v":0},0,0,0,{"$f":"G12+G14","v":0},{"$f":"H12+H14","v":0},{"$f":"I12+I14","v":0},0]
[null,{"$f":"\"долгосрочные\"","v":"долгосрочные"},7,null,0,{"$f":"G11","v":0},{"$f":"E29","v":0},{"$f":"G29","v":0},0,0]
[null,{"$f":"\"кроме того проценты\"","v":"кроме того проценты"},null,null,0,{"$f":"G12","v":0},{"$f":"E30","v":0},0,0,0]
[null,{"$f":"\"краткосрочные\"","v":"краткосрочные"},6,5,0,{"$f":"G13","v":0},{"$f":"E31","v":0},0,0,0]
[null,{"$f":"\"кроме того проценты\"","v":"кроме того проценты"},null,null,0,{"$f":"G14","v":0},{"$f":"E32","v":0},{"$f":"G32","v":0},0,0]
[{"$f":"A9+1","v":2},{"$f":"\"Эмиссия векселей, всего\"","v":"Эмиссия векселей, всего"},{"$f":"C17+C19","v":0},{"$f":"D17+D19","v":0},{"$f":"E17+E19","v":0},0,{"$f":"G17+G19","v":0},0,0,0]
[null,{"$f":"\"кроме того проценты начисленные всего\"","v":"кроме того проценты начисленные всего"},{"$f":"C18+C20","v":0},{"$f":"D18+D20","v":0},{"$f":"E18+E20","v":0},{"$f":"F18+F20","v":0},{"$f":"G18+G20","v":0},{"$f":"H18+H20","v":0},{"$f":"I18+I20","v":0},{"$f":"J18+J20","v":0}]
[null,{"$f":"\"долгосрочные\"","v":"долгосрочные"},0,0,0,{"$f":"SUM(G17:J17)","v":0}]
[null,{"$f":"\"кроме того проценты начисленные\"","v":"кроме того проценты начисленные"},0,0,0,{"$f":"SUM(G18:J18)","v":0}]
[null,{"$f":"\"краткосрочные\"","v":"краткосрочные"},0,0,0,0]
[null,{"$f":"\"кроме того проценты начисленные\"","v":"кроме того проценты начисленные"},0,0,0,0]
[{"$f":"A15+1","v":3},"\"Погашено векселей, всего\"",{"$f":"C23+C25","v":0},{"$f":"D23+D25","v":0},{"$f":"E23+E25","v":0},0,{"$f":"G23+G25","v":0},0,0,0]
[" ","\"кроме того проценты уплаченные всего\"",{"$f":"C24+C26","v":0},{"$f":"D24+D26","v":8888},{"$f":"E24+E26","v":0},{"$f":"F24+F26","v":111111111},{"$f":"G24+G26","v":0},{"$f":"H24+H26","v":0},{"$f":"I24+I26","v":0},{"$f":"J24+J26","v":111111111}]
[null,"\"долгосрочные\"",null,null,null,0]
[null,{"$f":"\"кроме того проценты уплаченные\"","v":"кроме того проценты уплаченные"},null,null,null,0]
[null,{"$f":"\"краткосрочные\"","v":"краткосрочные"},null,null,null,0]
[null,{"$f":"\"кроме того проценты уплаченные\"","v":"кроме того проценты уплаченные"},null,8888,null,111111111,null,null,null,111111111]
[{"$f":"A21+1","v":4},{"$f":"\"Остаток на конец периода\"","v":"Остаток на конец периода"},{"$f":"C29+C31","v":13},{"$f":"D29+D31","v":5},{"$f":"E29+E31","v":0},0,0,0,0,0]
[null,{"$f":"\"кроме того проценты всего\"","v":"кроме того проценты всего"},{"$f":"C30+C32","v":0},{"$f":"D30+D32","v":-8888},0,-111111111,{"$f":"G30+G32","v":0},0,0,-111111111]
[null,{"$f":"\"долгосрочные\"","v":"долгосрочные"},{"$f":"C11+C17-C23-C33","v":7},0,0,0,0,0,0,0]
[null,{"$f":"\"кроме того проценты\"","v":"кроме того проценты"},{"$f":"C12+C18-C24","v":0},0,0,0,0,0,0,0]
[null,{"$f":"\"краткосрочные\"","v":"краткосрочные"},{"$f":"C13+C19-C25+C33","v":6},5,0,0,0,0,0,0]
[null,{"$f":"\"кроме того проценты\"","v":"кроме того проценты"},{"$f":"C14+C20-C26","v":0},-8888,0,-111111111,0,0,0,-111111111]
[null,{"$f":"\"Корректировка (перенос из долгосрочных в краткосрочные)\"","v":"Корректировка (перенос из долгосрочных в краткосрочные)"},null,null,null,{"$f":"G33+H33+I33+J33","v":0}]