{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["CustCircNew","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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":"CustCircNew","index":0,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[2,1,2,6],[1,1,1,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(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,2,"Асса Аблой Хоспиталити Франция",{"$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,3,"Асса Аблой ЕМЕА ",{"$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,4,"Асса Аблой Полша",{"$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,5,"Асса Аблой Румъния",{"$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,6,"Асса Аблой Хонг Конг",{"$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,7,"Асса Аблой Словения",{"$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,8,"Асса Аблой Хоспиталити Иберика",{"$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,9,"Асса Аблой Чехия и Словакия",{"$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,10,"Асса Аблой Балтик",{"$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,11,"Мауер Холандия",{"$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,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:F33)","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!"}}]
[null,null,"Застраховки","7030-990083",null,{"$f":"KRT(\"7030-990083\")","v":{"$error":"#VALUE!"}}]
[]
["2.","Продажби извън групата - НЕТИРАНИ",null,null,null,{"$f":"F24-F25","v":{"$error":"#VALUE!"}},null,{"$f":"F35/1000","v":{"$error":"#VALUE!"}}]
[]
["II.","НЕТИРАН  СТОКООБОРОТ МАУЕР ЗА ПЕРИОДА",null,null,null,null,{"$f":"G5-F20-F25","v":{"$error":"#VALUE!"}},{"$f":"G37/1000","v":{"$error":"#VALUE!"}}]
[]
["2.1","Продажби Вътрешен пазар  - Sales Domestic Market",null,null,null,{"$f":"K2D(\"70\",\"4110\")  -  F25","v":{"$error":"#VALUE!"}},null,{"$f":"F39/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":"F41/1000","v":{"$error":"#VALUE!"}}]
[]
["2.3","Продажби Външен пазар пазар без Холандия - Sales  Export without NL",null,null,null,{"$f":"K2D(\"70\",\"4112\") + K2D(\"70\",\"4111\") - F41 - F20","v":{"$error":"#VALUE!"}},null,{"$f":"F43/1000","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,"Контролен  сбор 2.1-2.3",null,{"$f":"SUM(H39:H43)","v":{"$error":"#VALUE!"}}]

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

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