{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["FinancialPerformance","CustCircMonth","CustCircMonthLast","CustCircYTD","CustCircYTDLast","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":25,"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":"FinancialPerformance","index":0,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,1],[3,0,3,1],[3,2,3,4],[3,5,3,7],[3,8,3,11]]}
[{"$f":"GETENDDATE()","v":{"$error":"#VALUE!"}}]
[]
[]
["Mauer Bulgaria",null,"PERIODIC",null,null,"YTD",null,null,"FULL YEAR "]
[null,"currency:  k BGN",{"$f":"ENDDATE3()","v":{"$error":"#VALUE!"}},{"$f":"GETENDDATE()","v":{"$error":"#VALUE!"}},{"$f":"CONCATENATE(\"Latest FC   \",          GETENDDATE())","v":{"$error":"#VALUE!"}},{"$f":"C5","v":{"$error":"#VALUE!"}},{"$f":"D5","v":{"$error":"#VALUE!"}},{"$f":"E5","v":{"$error":"#VALUE!"}},{"$f":"CONCATENATE(\"LY \",  YEAR(ENDDATE2()))","v":{"$error":"#VALUE!"}},"Latest FC",{"$f":"CONCATENATE(YEAR(GETENDDATE()), \" SPA TG   \",\"   Business Case Stand alone \")","v":{"$error":"#VALUE!"}},{"$f":"CONCATENATE(YEAR(ENDDATE2()),\" SPA TG \",\" Business Case with Synergies \")","v":{"$error":"#VALUE!"}}]
[]
["TOTAL SALES ",null,1070,1034,1086,5885,{"$f":"CustCircYTD!H36","v":{"$error":"#VALUE!"}},6220,11543,12700]
["SALES DOMESTIC",null,{"$f":"CustCircMonthLast!H38","v":{"$error":"#VALUE!"}},{"$f":"CustCircMonth!H38","v":{"$error":"#VALUE!"}},430,{"$f":"CustCircYTDLast!H38","v":{"$error":"#VALUE!"}},{"$f":"CustCircYTD!H38","v":{"$error":"#VALUE!"}},2162,3322,3682]
["SALES NETHERLANDS",null,{"$f":"CustCircMonthLast!H40","v":{"$error":"#VALUE!"}},{"$f":"CustCircMonth!H40","v":{"$error":"#VALUE!"}},248,{"$f":"CustCircYTDLast!H40","v":{"$error":"#VALUE!"}},{"$f":"CustCircYTD!H40","v":{"$error":"#VALUE!"}},1946,2832,3000]
["SALES EXPORT",null,{"$f":"CustCircMonthLast!H42","v":{"$error":"#VALUE!"}},{"$f":"CustCircMonth!H42","v":{"$error":"#VALUE!"}},408,{"$f":"CustCircYTDLast!H42","v":{"$error":"#VALUE!"}},{"$f":"CustCircYTD!H42","v":{"$error":"#VALUE!"}},2112,5389,6018]
["EBIT",null,null,null,null,null,null,null,2530,2300]
["EBIT %",null,null,null,null,null,null,null,0.219,0.18099999999999999]
["OP CASH FLOW ",null,null,null,null,null,null,null,3499]
["OP CASH FLOW / EBIT % ",null,null,null,null,null,null,null,1.383]
["Key Ratios:"]
["Organic growth %",null,null,{"$f":"((D7-C7)/C7)","v":-3.3644859813084113E-2},null,null,{"$f":"(G7-F7)/F7","v":{"$error":"#VALUE!"}},null,1.4999999999999999E-2,0.1]
["Organic growth Domestic %",null,null,{"$f":"((D8-C8)/C8)","v":{"$error":"#VALUE!"}},null,null,{"$f":"(G8-F8)/F8","v":{"$error":"#VALUE!"}},null,"-"]
["Organic growth Netherlands %",null,null,{"$f":"((D9-C9)/C9)","v":{"$error":"#VALUE!"}},null,null,{"$f":"(G9-F9)/F9","v":{"$error":"#VALUE!"}},null,"-"]
["Organic growth Export %",null,null,{"$f":"((D10-C10)/C10)","v":{"$error":"#VALUE!"}},null,null,{"$f":"(G10-F10)/F10","v":{"$error":"#VALUE!"}},null,"-"]
["Days Sales Outstanding (DSO) ",null,null,null,null,null,null,null,17,26]
["Days Payable Outstanding (DPO)",null,null,null,null,null,null,null,41,50]
["Material Through Put Time (MTPT)",null,null,null,null,null,null,null,154,150]
["Total employees - HC ",null,null,null,null,null,null,null,163,159]

{"sheet":"CustCircMonth","index":1,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,1,1,6],[2,1,2,6]]}
[]
[null,"СПРАВКА НЕТИРАН СТОКООБОРОТ (за  текущия месец)"]
[null,{"$f":"CONCATENATE(\" от \",GETSTARTDATE(), \" до  \",GETENDDATE())","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"EUR","BGN","BGN","В ХИЛ. ЛВ."]
["I.","ОБЩ СТОКООБОРОТ МАУЕР ЗА ПЕРИОДА",null,null,null,null,{"$f":"CUSTCIRCALL()","v":{"$error":"#VALUE!"}},{"$f":"G5/1000","v":{"$error":"#VALUE!"}}]
[null,"в т.ч."]
[null,"Вътрегрупови продажби  IG SALES",null,null,{"$f":"SUM(E8:E18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(F8:F18)","v":{"$error":"#VALUE!"}}]
[null,1,"ВАН ЕРП",{"$f":"CUSTHFM(229)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(229)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(229)*1.95583","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(229)*1.95583/1000","v":{"$error":"#VALUE!"}}]
[null,2,"Асса Аблой Полша",{"$f":"CUSTHFM(5718)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5718)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5718)*1.95583","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5718)*1.95583/1000","v":{"$error":"#VALUE!"}}]
[null,3,"Асса Аблой Румъния",{"$f":"CUSTHFM(5413)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5413)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5413)*1.95583","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5413)*1.95583/1000","v":{"$error":"#VALUE!"}}]
[null,4,"Асса Аблой Хонг Конг",{"$f":"CUSTHFM(5566)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5566)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5566)*1.95583","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5566)*1.95583/1000","v":{"$error":"#VALUE!"}}]
[null,5,"Асса Аблой Хоспиталити Иберика",{"$f":"CUSTHFM(5562)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5562)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5562)*1.95583","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5562)*1.95583/1000","v":{"$error":"#VALUE!"}}]
[null,6,"Асса Аблой Чехия и Словакия",{"$f":"CUSTHFM(5414)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5414)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5414)*1.95583","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5414)*1.95583/1000","v":{"$error":"#VALUE!"}}]
[null,7,"Асса Аблой Балтик",{"$f":"CUSTHFM(5470)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5470)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5470)*1.95583","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5470)*1.95583/1000","v":{"$error":"#VALUE!"}}]
[null,8,"Асса Аблой ЕМЕА ",{"$f":"CUSTHFM(5636)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5636)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5636)*1.95583","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5636)*1.95583/1000","v":{"$error":"#VALUE!"}}]
[null,9,"Асса Аблой Зихерхайтстехник",{"$f":"CUSTHFM(5538)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5538)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5538)*1.95583","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5538)*1.95583/1000","v":{"$error":"#VALUE!"}}]
[null,10,"Асса Аблой Словения",{"$f":"CUSTHFM(5419)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5419)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5419)*1.95583","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5419)*1.95583/1000","v":{"$error":"#VALUE!"}}]
[null,11,"Асса Аблой Хоспиталити Франция",{"$f":"CUSTHFM(5640)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5640)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5640)*1.95583","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRC(5640)*1.95583/1000","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"Контролен  сбор в хил.лв.",null,{"$f":"SUM(G8:G18)","v":{"$error":"#VALUE!"}}]
[null,null,"5 % IG в намаление на разходите",null,{"$f":"F20/1.95583","v":{"$error":"#VALUE!"}},{"$f":"KRT(\"7090-05\")","v":{"$error":"#VALUE!"}},{"$f":"KRT(\"7090-05\")","v":{"$error":"#VALUE!"}},{"$f":"-G20/1000","v":{"$error":"#VALUE!"}}]
[]
["1.","Вътрегрупови продажби  - НЕТИРАНИ",null,null,{"$f":"E7-E20","v":{"$error":"#VALUE!"}},{"$f":"F7-F20","v":{"$error":"#VALUE!"}},null,{"$f":"F22/1000","v":{"$error":"#VALUE!"}}]
[]
[null,"Продажби извън групата EXTERNAL SALES",null,null,null,{"$f":"G5-F7","v":{"$error":"#VALUE!"}}]
[null,"***","Нетиране на приходите","Сметка",null,{"$f":"SUM(F26:F32)","v":{"$error":"#VALUE!"}},null,{"$f":"-F25/1000","v":{"$error":"#VALUE!"}}]
[null,null,"Приходи от транспорт","7030-010001",null,{"$f":"KRT(\"7030-010001\")","v":{"$error":"#VALUE!"}}]
[null,null,"Приходи от отпадък","7090-01",null,{"$f":"KRT(\"7090-01\")","v":{"$error":"#VALUE!"}}]
[null,null,"Приходи от активи","7090-02",null,{"$f":"KRT(\"7090-02\")","v":{"$error":"#VALUE!"}}]
[null,null,"Други приходи","7090-03",null,{"$f":"KRT(\"7090-03\")","v":{"$error":"#VALUE!"}}]
[null,null,"Приходи от наем","7090-04",null,{"$f":"KRT(\"7090-04\")","v":{"$error":"#VALUE!"}}]
[null,null,"Приходи от услуги - ИЕ","7030-990005",null,{"$f":"KRT(\"7030-990005\")","v":{"$error":"#VALUE!"}}]
[null,null,"Бонус оборот клиенти","6090-060004",null,{"$f":"DBT(\"6090-060004\")","v":{"$error":"#VALUE!"}}]
[]
["2.","Продажби извън групата - НЕТИРАНИ",null,null,null,{"$f":"F24-F25","v":{"$error":"#VALUE!"}},null,{"$f":"F34/1000","v":{"$error":"#VALUE!"}}]
[]
["II.","НЕТИРАН  СТОКООБОРОТ МАУЕР ЗА ПЕРИОДА",null,null,null,null,{"$f":"G5-F20-F25","v":{"$error":"#VALUE!"}},{"$f":"G36/1000","v":{"$error":"#VALUE!"}}]
[]
["2.1","Продажби Вътрешен пазар  - Sales Domestic Market",null,null,null,{"$f":"K2D(\"70\",\"4110\")  -  F25","v":{"$error":"#VALUE!"}},null,{"$f":"F38/1000","v":{"$error":"#VALUE!"}}]
[]
["2.2","Продажби само Холандия  - Sales  Export only NL",null,null,null,{"$f":"K2D(\"70\",\"4112-000001\")+K2D(\"70\",\"4111-000004\")","v":{"$error":"#VALUE!"}},null,{"$f":"F40/1000","v":{"$error":"#VALUE!"}}]
[]
["2.3","Продажби Външен пазар пазар без Холандия - Sales  Export without NL",null,null,null,{"$f":"K2D(\"70\",\"4112\") + K2D(\"70\",\"4111\") - F40 - F20","v":{"$error":"#VALUE!"}},null,{"$f":"F42/1000","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,"Контролен  сбор 2.1-2.3",null,{"$f":"SUM(H38:H42)","v":{"$error":"#VALUE!"}}]

{"sheet":"CustCircMonthLast","index":2,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,1,1,6],[2,1,2,6]]}
[null,null,null,null,null,null,null,{"$f":"STARTDATE2()","v":{"$error":"#VALUE!"}}]
[null,"СПРАВКА НЕТИРАН СТОКООБОРОТ (за месеца на предходната година)",null,null,null,null,null,{"$f":"ENDDATE3()","v":{"$error":"#VALUE!"}}]
[null,{"$f":"CONCATENATE(\" от \",STARTDATE2(), \" до  \",ENDDATE3())","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"EUR","BGN","BGN","В ХИЛ. ЛВ."]
["I.","ОБЩ СТОКООБОРОТ МАУЕР ЗА ПЕРИОДА",null,null,null,null,{"$f":"CUSTCIRCALLX(STARTDATE2(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$f":"G5/1000","v":{"$error":"#VALUE!"}}]
[null,"в т.ч."]
[null,"Вътрегрупови продажби  IG SALES",null,null,{"$f":"SUM(E8:E18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(F8:F18)","v":{"$error":"#VALUE!"}}]
[null,1,"ВАН ЕРП",{"$f":"CUSTHFM(229)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(229,STARTDATE2(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$f":"E8*1.95583","v":{"$error":"#VALUE!"}},{"$f":"E8*1.95583/1000","v":{"$error":"#VALUE!"}}]
[null,2,"Асса Аблой Полша",{"$f":"CUSTHFM(5718)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5718,STARTDATE2(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$f":"E9*1.95583","v":{"$error":"#VALUE!"}},{"$f":"E9*1.95583/1000","v":{"$error":"#VALUE!"}}]
[null,3,"Асса Аблой Румъния",{"$f":"CUSTHFM(5413)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5413,STARTDATE2(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$f":"E10*1.95583","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,4,"Асса Аблой Хонг Конг",{"$f":"CUSTHFM(5566)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5566,STARTDATE2(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,5,"Асса Аблой Хоспиталити Иберика",{"$f":"CUSTHFM(5562)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5562,STARTDATE2(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,6,"Асса Аблой Чехия и Словакия",{"$f":"CUSTHFM(5414)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5414,STARTDATE2(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,7,"Асса Аблой Балтик",{"$f":"CUSTHFM(5470)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5470,STARTDATE2(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,8,"Асса Аблой ЕМЕА ",{"$f":"CUSTHFM(5636)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5636,STARTDATE2(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,9,"Асса Аблой Зихерхайтстехник",{"$f":"CUSTHFM(5538)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5538,STARTDATE2(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,10,"Асса Аблой Словения",{"$f":"CUSTHFM(5419)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5419,STARTDATE2(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,11,"Асса Аблой Хоспиталити Франция",{"$f":"CUSTHFM(5640)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5640,STARTDATE2(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,"Контролен  сбор в хил.лв.",null,{"$f":"SUM(G8:G18)","v":{"$error":"#VALUE!"}}]
[null,null,"5 % IG в намаление на разходите",null,{"$f":"F20/1.95583","v":{"$error":"#VALUE!"}},{"$f":"KRTX(\"7090-05\",STARTDATE2(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$f":"KRTX(\"7090-05\",STARTDATE2(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$f":"-G20/1000","v":{"$error":"#VALUE!"}}]
[]
["1.","Вътрегрупови продажби  - НЕТИРАНИ",null,null,{"$f":"E7-E20","v":{"$error":"#VALUE!"}},{"$f":"F7-F20","v":{"$error":"#VALUE!"}},null,{"$f":"F22/1000","v":{"$error":"#VALUE!"}}]
[]
[null,"Продажби извън групата EXTERNAL SALES",null,null,null,{"$f":"G5-F7","v":{"$error":"#VALUE!"}}]
[null,"***","Нетиране на приходите","Сметка",null,{"$f":"SUM(F26:F32)","v":{"$error":"#VALUE!"}},null,{"$f":"-F25/1000","v":{"$error":"#VALUE!"}}]
[null,null,"Приходи от транспорт","7030-010001",null,{"$f":"KRTX(\"7030-010001\",STARTDATE2(),ENDDATE3())","v":{"$error":"#VALUE!"}}]
[null,null,"Приходи от отпадък","7090-01",null,{"$f":"KRTX(\"7090-01\",STARTDATE2(),ENDDATE3())","v":{"$error":"#VALUE!"}}]
[null,null,"Приходи от активи","7090-02",null,{"$f":"KRTX(\"7090-02\",STARTDATE2(),ENDDATE3())","v":{"$error":"#VALUE!"}}]
[null,null,"Други приходи","7090-03",null,{"$f":"KRTX(\"7090-03\",STARTDATE2(),ENDDATE3())","v":{"$error":"#VALUE!"}}]
[null,null,"Приходи от наем","7090-04",null,{"$f":"KRTX(\"7090-04\",STARTDATE2(),ENDDATE3())","v":{"$error":"#VALUE!"}}]
[null,null,"Приходи от услуги - ИЕ","7030-990005",null,{"$f":"KRTX(\"7030-990005\",STARTDATE2(),ENDDATE3())","v":{"$error":"#VALUE!"}}]
[null,null,"Бонус оборот клиенти","6090-060004",null,{"$f":"DBTX(\"6090-060004\",STARTDATE2(),ENDDATE3())","v":{"$error":"#VALUE!"}}]
[]
["2.","Продажби извън групата - НЕТИРАНИ",null,null,null,{"$f":"F24-F25","v":{"$error":"#VALUE!"}},null,{"$f":"F34/1000","v":{"$error":"#VALUE!"}}]
[]
["II.","НЕТИРАН  СТОКООБОРОТ МАУЕР ЗА ПЕРИОДА",null,null,null,null,{"$f":"G5-F20-F25","v":{"$error":"#VALUE!"}},{"$f":"G36/1000","v":{"$error":"#VALUE!"}}]
[]
["2.1","Продажби Вътрешен пазар  - Sales Domestic Market",null,null,null,{"$f":"K2DX(\"70\",\"4110\",STARTDATE2(),ENDDATE3())  -  F25","v":{"$error":"#VALUE!"}},null,{"$f":"F38/1000","v":{"$error":"#VALUE!"}}]
[]
["2.2","Продажби само Холандия  - Sales  Export only NL",null,null,null,{"$f":"K2DX(\"70\",\"4112-000001\",STARTDATE2(),ENDDATE3())+K2DX(\"70\",\"4111-000004\",STARTDATE2(),ENDDATE3())","v":{"$error":"#VALUE!"}},null,{"$f":"F40/1000","v":{"$error":"#VALUE!"}}]
[]
["2.3","Продажби Външен пазар пазар без Холандия - Sales  Export without NL",null,null,null,{"$f":"K2DX(\"70\",\"4112\",STARTDATE2(),ENDDATE3()) + K2DX(\"70\",\"4111\",STARTDATE2(),ENDDATE3()) - F40 - F20","v":{"$error":"#VALUE!"}},null,{"$f":"F42/1000","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,"Контролен  сбор 2.1-2.3",null,{"$f":"SUM(H38:H42)","v":{"$error":"#VALUE!"}}]

{"sheet":"CustCircYTD","index":3,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,1,1,6],[2,1,2,6]]}
[null,null,null,null,null,null,null,{"$f":"STARTDATEYTD()","v":{"$error":"#VALUE!"}}]
[null,"СПРАВКА НЕТИРАН СТОКООБОРОТ (към дата за текущата година)",null,null,null,null,null,{"$f":"GETENDDATE()","v":{"$error":"#VALUE!"}}]
[null,{"$f":"CONCATENATE(\" от \",STARTDATEYTD(), \" до  \",GETENDDATE())","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"EUR","BGN","BGN","В ХИЛ. ЛВ."]
["I.","ОБЩ СТОКООБОРОТ МАУЕР ЗА ПЕРИОДА",null,null,null,null,{"$f":"CUSTCIRCALLX(STARTDATEYTD(),GETENDDATE())","v":{"$error":"#VALUE!"}},{"$f":"G5/1000","v":{"$error":"#VALUE!"}}]
[null,"в т.ч."]
[null,"Вътрегрупови продажби  IG SALES",null,null,{"$f":"SUM(E8:E18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(F8:F18)","v":{"$error":"#VALUE!"}}]
[null,1,"ВАН ЕРП",{"$f":"CUSTHFM(229)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(229,STARTDATEYTD(),GETENDDATE())","v":{"$error":"#VALUE!"}},{"$f":"E8*1.95583","v":{"$error":"#VALUE!"}},{"$f":"E8*1.95583/1000","v":{"$error":"#VALUE!"}}]
[null,2,"Асса Аблой Полша",{"$f":"CUSTHFM(5718)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5718,STARTDATEYTD(),GETENDDATE())","v":{"$error":"#VALUE!"}},{"$f":"E9*1.95583","v":{"$error":"#VALUE!"}},{"$f":"E9*1.95583/1000","v":{"$error":"#VALUE!"}}]
[null,3,"Асса Аблой Румъния",{"$f":"CUSTHFM(5413)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5413,STARTDATEYTD(),GETENDDATE())","v":{"$error":"#VALUE!"}},{"$f":"E10*1.95583","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,4,"Асса Аблой Хонг Конг",{"$f":"CUSTHFM(5566)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5566,STARTDATEYTD(),GETENDDATE())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,5,"Асса Аблой Хоспиталити Иберика",{"$f":"CUSTHFM(5562)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5562,STARTDATEYTD(),GETENDDATE())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,6,"Асса Аблой Чехия и Словакия",{"$f":"CUSTHFM(5414)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5414,STARTDATEYTD(),GETENDDATE())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,7,"Асса Аблой Балтик",{"$f":"CUSTHFM(5470)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5470,STARTDATEYTD(),GETENDDATE())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,8,"Асса Аблой ЕМЕА ",{"$f":"CUSTHFM(5636)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5636,STARTDATEYTD(),GETENDDATE())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,9,"Асса Аблой Зихерхайтстехник",{"$f":"CUSTHFM(5538)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5538,STARTDATEYTD(),GETENDDATE())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,10,"Асса Аблой Словения",{"$f":"CUSTHFM(5419)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5419,STARTDATEYTD(),GETENDDATE())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,11,"Асса Аблой Хоспиталити Франция",{"$f":"CUSTHFM(5640)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5640,STARTDATEYTD(),GETENDDATE())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,"Контролен  сбор в хил.лв.",null,{"$f":"SUM(G8:G18)","v":{"$error":"#VALUE!"}}]
[null,null,"5 % IG в намаление на разходите",null,{"$f":"F20/1.95583","v":{"$error":"#VALUE!"}},{"$f":"KRTX(\"7090-05\",STARTDATEYTD(),GETENDDATE())","v":{"$error":"#VALUE!"}},{"$f":"KRTX(\"7090-05\",STARTDATEYTD(),GETENDDATE())","v":{"$error":"#VALUE!"}},{"$f":"-G20/1000","v":{"$error":"#VALUE!"}}]
[]
["1.","Вътрегрупови продажби  - НЕТИРАНИ",null,null,{"$f":"E7-E20","v":{"$error":"#VALUE!"}},{"$f":"F7-F20","v":{"$error":"#VALUE!"}},null,{"$f":"F22/1000","v":{"$error":"#VALUE!"}}]
[]
[null,"Продажби извън групата EXTERNAL SALES",null,null,null,{"$f":"G5-F7","v":{"$error":"#VALUE!"}}]
[null,"***","Нетиране на приходите","Сметка",null,{"$f":"SUM(F26:F32)","v":{"$error":"#VALUE!"}},null,{"$f":"-F25/1000","v":{"$error":"#VALUE!"}}]
[null,null,"Приходи от транспорт","7030-010001",null,{"$f":"KRTX(\"7030-010001\",STARTDATEYTD(),GETENDDATE())","v":{"$error":"#VALUE!"}}]
[null,null,"Приходи от отпадък","7090-01",null,{"$f":"KRTX(\"7090-01\",STARTDATEYTD(),GETENDDATE())","v":{"$error":"#VALUE!"}}]
[null,null,"Приходи от активи","7090-02",null,{"$f":"KRTX(\"7090-02\",STARTDATEYTD(),GETENDDATE())","v":{"$error":"#VALUE!"}}]
[null,null,"Други приходи","7090-03",null,{"$f":"KRTX(\"7090-03\",STARTDATEYTD(),GETENDDATE())","v":{"$error":"#VALUE!"}}]
[null,null,"Приходи от наем","7090-04",null,{"$f":"KRTX(\"7090-04\",STARTDATEYTD(),GETENDDATE())","v":{"$error":"#VALUE!"}}]
[null,null,"Приходи от услуги - ИЕ","7030-990005",null,{"$f":"KRTX(\"7030-990005\",STARTDATEYTD(),GETENDDATE())","v":{"$error":"#VALUE!"}}]
[null,null,"Бонус оборот клиенти","6090-060004",null,{"$f":"DBTX(\"6090-060004\",STARTDATEYTD(),GETENDDATE())","v":{"$error":"#VALUE!"}}]
[]
["2.","Продажби извън групата - НЕТИРАНИ",null,null,null,{"$f":"F24-F25","v":{"$error":"#VALUE!"}},null,{"$f":"F34/1000","v":{"$error":"#VALUE!"}}]
[]
["II.","НЕТИРАН  СТОКООБОРОТ МАУЕР ЗА ПЕРИОДА",null,null,null,null,{"$f":"G5-F20-F25","v":{"$error":"#VALUE!"}},{"$f":"G36/1000","v":{"$error":"#VALUE!"}}]
[]
["2.1","Продажби Вътрешен пазар  - Sales Domestic Market",null,null,null,{"$f":"K2DX(\"70\",\"4110\",STARTDATEYTD(),GETENDDATE())  -  F25","v":{"$error":"#VALUE!"}},null,{"$f":"F38/1000","v":{"$error":"#VALUE!"}}]
[]
["2.2","Продажби само Холандия  - Sales  Export only NL",null,null,null,{"$f":"K2DX(\"70\",\"4112-000001\",STARTDATEYTD(),GETENDDATE())+K2DX(\"70\",\"4111-000004\",STARTDATEYTD(),GETENDDATE())","v":{"$error":"#VALUE!"}},null,{"$f":"F40/1000","v":{"$error":"#VALUE!"}}]
[]
["2.3","Продажби Външен пазар пазар без Холандия - Sales  Export without NL",null,null,null,{"$f":"K2DX(\"70\",\"4112\",STARTDATEYTD(),GETENDDATE()) + K2DX(\"70\",\"4111\",STARTDATEYTD(),GETENDDATE()) - F40 - F20","v":{"$error":"#VALUE!"}},null,{"$f":"F42/1000","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,"Контролен  сбор 2.1-2.3",null,{"$f":"SUM(H38:H42)","v":{"$error":"#VALUE!"}}]

{"sheet":"CustCircYTDLast","index":4,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,1,1,6],[2,1,2,6]]}
[null,null,null,null,null,null,null,{"$f":"STARTDATEYTDLASTYEAR()","v":{"$error":"#VALUE!"}}]
[null,"СПРАВКА НЕТИРАН СТОКООБОРОТ (за към дата за предходната година)",null,null,null,null,null,{"$f":"ENDDATE3()","v":{"$error":"#VALUE!"}}]
[null,{"$f":"CONCATENATE(\" от \",STARTDATEYTDLASTYEAR(), \" до  \",ENDDATE2())","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"EUR","BGN","BGN","В ХИЛ. ЛВ."]
["I.","ОБЩ СТОКООБОРОТ МАУЕР ЗА ПЕРИОДА",null,null,null,null,{"$f":"CUSTCIRCALLX(STARTDATEYTDLASTYEAR(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$f":"G5/1000","v":{"$error":"#VALUE!"}}]
[null,"в т.ч."]
[null,"Вътрегрупови продажби  IG SALES",null,null,{"$f":"SUM(E8:E18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(F8:F18)","v":{"$error":"#VALUE!"}}]
[null,1,"ВАН ЕРП",{"$f":"CUSTHFM(229)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(229,STARTDATEYTDLASTYEAR(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$f":"E8*1.95583","v":{"$error":"#VALUE!"}},{"$f":"E8*1.95583/1000","v":{"$error":"#VALUE!"}}]
[null,2,"Асса Аблой Полша",{"$f":"CUSTHFM(5718)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5718,STARTDATEYTDLASTYEAR(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$f":"E9*1.95583","v":{"$error":"#VALUE!"}},{"$f":"E9*1.95583/1000","v":{"$error":"#VALUE!"}}]
[null,3,"Асса Аблой Румъния",{"$f":"CUSTHFM(5413)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5413,STARTDATEYTDLASTYEAR(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$f":"E10*1.95583","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,4,"Асса Аблой Хонг Конг",{"$f":"CUSTHFM(5566)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5566,STARTDATEYTDLASTYEAR(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,5,"Асса Аблой Хоспиталити Иберика",{"$f":"CUSTHFM(5562)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5562,STARTDATEYTDLASTYEAR(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,6,"Асса Аблой Чехия и Словакия",{"$f":"CUSTHFM(5414)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5414,STARTDATEYTDLASTYEAR(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,7,"Асса Аблой Балтик",{"$f":"CUSTHFM(5470)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5470,STARTDATEYTDLASTYEAR(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,8,"Асса Аблой ЕМЕА ",{"$f":"CUSTHFM(5636)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5636,STARTDATEYTDLASTYEAR(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,9,"Асса Аблой Зихерхайтстехник",{"$f":"CUSTHFM(5538)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5538,STARTDATEYTDLASTYEAR(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,10,"Асса Аблой Словения",{"$f":"CUSTHFM(5419)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5419,STARTDATEYTDLASTYEAR(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,11,"Асса Аблой Хоспиталити Франция",{"$f":"CUSTHFM(5640)","v":{"$error":"#VALUE!"}},{"$f":"CUSTCIRCX(5640,STARTDATEYTDLASTYEAR(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,"Контролен  сбор в хил.лв.",null,{"$f":"SUM(G8:G18)","v":{"$error":"#VALUE!"}}]
[null,null,"5 % IG в намаление на разходите",null,{"$f":"F20/1.95583","v":{"$error":"#VALUE!"}},{"$f":"KRTX(\"7090-05\",STARTDATEYTDLASTYEAR(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$f":"KRTX(\"7090-05\",STARTDATEYTDLASTYEAR(),ENDDATE3())","v":{"$error":"#VALUE!"}},{"$f":"-G20/1000","v":{"$error":"#VALUE!"}}]
[]
["1.","Вътрегрупови продажби  - НЕТИРАНИ",null,null,{"$f":"E7-E20","v":{"$error":"#VALUE!"}},{"$f":"F7-F20","v":{"$error":"#VALUE!"}},null,{"$f":"F22/1000","v":{"$error":"#VALUE!"}}]
[]
[null,"Продажби извън групата EXTERNAL SALES",null,null,null,{"$f":"G5-F7","v":{"$error":"#VALUE!"}}]
[null,"***","Нетиране на приходите","Сметка",null,{"$f":"SUM(F26:F32)","v":{"$error":"#VALUE!"}},null,{"$f":"-F25/1000","v":{"$error":"#VALUE!"}}]
[null,null,"Приходи от транспорт","7030-010001",null,{"$f":"KRTX(\"7030-010001\",STARTDATEYTDLASTYEAR(),ENDDATE3())","v":{"$error":"#VALUE!"}}]
[null,null,"Приходи от отпадък","7090-01",null,{"$f":"KRTX(\"7090-01\",STARTDATEYTDLASTYEAR(),ENDDATE3())","v":{"$error":"#VALUE!"}}]
[null,null,"Приходи от активи","7090-02",null,{"$f":"KRTX(\"7090-02\",STARTDATEYTDLASTYEAR(),ENDDATE3())","v":{"$error":"#VALUE!"}}]
[null,null,"Други приходи","7090-03",null,{"$f":"KRTX(\"7090-03\",STARTDATEYTDLASTYEAR(),ENDDATE3())","v":{"$error":"#VALUE!"}}]
[null,null,"Приходи от наем","7090-04",null,{"$f":"KRTX(\"7090-04\",STARTDATEYTDLASTYEAR(),ENDDATE3())","v":{"$error":"#VALUE!"}}]
[null,null,"Приходи от услуги - ИЕ","7030-990005",null,{"$f":"KRTX(\"7030-990005\",STARTDATEYTDLASTYEAR(),ENDDATE3())","v":{"$error":"#VALUE!"}}]
[null,null,"Бонус оборот клиенти","6090-060004",null,{"$f":"DBTX(\"6090-060004\",STARTDATEYTDLASTYEAR(),ENDDATE3())","v":{"$error":"#VALUE!"}}]
[]
["2.","Продажби извън групата - НЕТИРАНИ",null,null,null,{"$f":"F24-F25","v":{"$error":"#VALUE!"}},null,{"$f":"F34/1000","v":{"$error":"#VALUE!"}}]
[]
["II.","НЕТИРАН  СТОКООБОРОТ МАУЕР ЗА ПЕРИОДА",null,null,null,null,{"$f":"G5-F20-F25","v":{"$error":"#VALUE!"}},{"$f":"G36/1000","v":{"$error":"#VALUE!"}}]
[]
["2.1","Продажби Вътрешен пазар  - Sales Domestic Market",null,null,null,{"$f":"K2DX(\"70\",\"4110\",STARTDATEYTDLASTYEAR(),ENDDATE3())  -  F25","v":{"$error":"#VALUE!"}},null,{"$f":"F38/1000","v":{"$error":"#VALUE!"}}]
[]
["2.2","Продажби само Холандия  - Sales  Export only NL",null,null,null,{"$f":"K2DX(\"70\",\"4112-000001\",STARTDATEYTDLASTYEAR(),ENDDATE3())+K2DX(\"70\",\"4111-000004\",STARTDATEYTDLASTYEAR(),ENDDATE3())","v":{"$error":"#VALUE!"}},null,{"$f":"F40/1000","v":{"$error":"#VALUE!"}}]
[]
["2.3","Продажби Външен пазар пазар без Холандия - Sales  Export without NL",null,null,null,{"$f":"K2DX(\"70\",\"4112\",STARTDATEYTDLASTYEAR(),ENDDATE3()) + K2DX(\"70\",\"4111\",STARTDATEYTDLASTYEAR(),ENDDATE3()) - F40 - F20","v":{"$error":"#VALUE!"}},null,{"$f":"F42/1000","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,"Контролен  сбор 2.1-2.3",null,{"$f":"SUM(H38:H42)","v":{"$error":"#VALUE!"}}]

{"sheet":"Sheet3","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}