{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Макрос1","Лист1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"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":"Макрос1","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
[{"$f":"RETURN(IFERROR(0*ARGUMENT(\"код\",2)*ARGUMENT(\"дата\")+SUBSTITUTE(_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"http://www.cbr.ru/scripts/XML_daily_eng.asp?date_req=\"&TEXT(IFERROR(IF(ISNUMBER(дата)*(дата>0),дата,DATEVALUE(дата)),TODAY()),\"ДД.ММ.ГГГГ\")),\"//Valute[CharCode=\"\"\"&UPPER(код)&\"\"\"]/Value\"),\",\",MID(1/2,2,1))/_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"http://www.cbr.ru/scripts/XML_daily_eng.asp?date_req=\"&TEXT(IFERROR(IF(ISNUMBER(дата)*(дата>0),дата,DATEVALUE(дата)),TODAY()),\"ДД.ММ.ГГГГ\")),\"//Valute[CharCode=\"\"\"&UPPER(код)&\"\"\"]/Nominal\"),\"\"))","v":true}]

{"sheet":"Лист1","index":1,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["usd","2015-01-12",{"$f":"SUBSTITUTE(_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"http://www.cbr.ru/scripts/XML_daily_eng.asp?date_req=\"&TEXT(IF(ISNUMBER(B1),B1,IFERROR(DATEVALUE(B1),TODAY())),\"ДД.ММ.ГГГГ\")),\"//Valute[CharCode=\"\"\"&UPPER(A1)&\"\"\"]/Value\"),\",\",MID(1/2,2,1))/_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"http://www.cbr.ru/scripts/XML_daily_eng.asp?date_req=\"&TEXT(IF(ISNUMBER(B1),B1,IFERROR(DATEVALUE(B1),TODAY())),\"ДД.ММ.ГГГГ\")),\"//Valute[CharCode=\"\"\"&UPPER(A1)&\"\"\"]/Nominal\")","v":56.2376},{"$f":"КУРСЦБР(A1)","v":64.842500000000001},{"$f":"КУРСЦБР(A1,B1)","v":56.2376}]
["eur","1 янв 2015",{"$f":"SUBSTITUTE(_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"http://www.cbr.ru/scripts/XML_daily_eng.asp?date_req=\"&TEXT(IF(ISNUMBER(B2),B2,IFERROR(DATEVALUE(B2),TODAY())),\"ДД.ММ.ГГГГ\")),\"//Valute[CharCode=\"\"\"&UPPER(A2)&\"\"\"]/Value\"),\",\",MID(1/2,2,1))/_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"http://www.cbr.ru/scripts/XML_daily_eng.asp?date_req=\"&TEXT(IF(ISNUMBER(B2),B2,IFERROR(DATEVALUE(B2),TODAY())),\"ДД.ММ.ГГГГ\")),\"//Valute[CharCode=\"\"\"&UPPER(A2)&\"\"\"]/Nominal\")","v":68.368099999999998},{"$f":"КУРСЦБР(A2)","v":76.773499999999999},{"$f":"КУРСЦБР(A2,B2)","v":68.368099999999998}]
["cad","20 дек 2014",{"$f":"SUBSTITUTE(_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"http://www.cbr.ru/scripts/XML_daily_eng.asp?date_req=\"&TEXT(IF(ISNUMBER(B3),B3,IFERROR(DATEVALUE(B3),TODAY())),\"ДД.ММ.ГГГГ\")),\"//Valute[CharCode=\"\"\"&UPPER(A3)&\"\"\"]/Value\"),\",\",MID(1/2,2,1))/_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"http://www.cbr.ru/scripts/XML_daily_eng.asp?date_req=\"&TEXT(IF(ISNUMBER(B3),B3,IFERROR(DATEVALUE(B3),TODAY())),\"ДД.ММ.ГГГГ\")),\"//Valute[CharCode=\"\"\"&UPPER(A3)&\"\"\"]/Nominal\")","v":52.375700000000002},{"$f":"КУРСЦБР(A3)","v":54.161799999999999},{"$f":"КУРСЦБР(A3,B3)","v":52.375700000000002}]
["aud",null,{"$f":"SUBSTITUTE(_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"http://www.cbr.ru/scripts/XML_daily_eng.asp?date_req=\"&TEXT(IF(ISNUMBER(B4),B4,IFERROR(DATEVALUE(B4),TODAY())),\"ДД.ММ.ГГГГ\")),\"//Valute[CharCode=\"\"\"&UPPER(A4)&\"\"\"]/Value\"),\",\",MID(1/2,2,1))/_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"http://www.cbr.ru/scripts/XML_daily_eng.asp?date_req=\"&TEXT(IF(ISNUMBER(B4),B4,IFERROR(DATEVALUE(B4),TODAY())),\"ДД.ММ.ГГГГ\")),\"//Valute[CharCode=\"\"\"&UPPER(A4)&\"\"\"]/Nominal\")","v":53.008699999999997},{"$f":"КУРСЦБР(A4)","v":53.008699999999997},{"$f":"КУРСЦБР(A4,B4)","v":53.008699999999997}]
["gbp",null,{"$f":"SUBSTITUTE(_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"http://www.cbr.ru/scripts/XML_daily_eng.asp?date_req=\"&TEXT(IF(ISNUMBER(B5),B5,IFERROR(DATEVALUE(B5),TODAY())),\"ДД.ММ.ГГГГ\")),\"//Valute[CharCode=\"\"\"&UPPER(A5)&\"\"\"]/Value\"),\",\",MID(1/2,2,1))/_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"http://www.cbr.ru/scripts/XML_daily_eng.asp?date_req=\"&TEXT(IF(ISNUMBER(B5),B5,IFERROR(DATEVALUE(B5),TODAY())),\"ДД.ММ.ГГГГ\")),\"//Valute[CharCode=\"\"\"&UPPER(A5)&\"\"\"]/Nominal\")","v":98.145600000000002},{"$f":"КУРСЦБР(A5)","v":98.145600000000002},{"$f":"КУРСЦБР(A5,B5)","v":98.145600000000002}]