{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["TFA ","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"TFA ","index":0,"n_rows":55,"n_cols":11,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,2,0,8],[1,2,1,8],[7,10,14,10],[21,10,28,10],[24,3,26,3],[24,6,26,6]]}
[null,null,"2016            TANGIBLE FIXED ASSETS",null,null,null,null,null,null,null,"2016-05-31"]
[null,null,"September"]
[null,null,"64300 - Buildings","64400 - Land and land improvements","64200 - Machinery","64250 - Equipment","64100 - Construction in progress","64500 - Other tangible assets","TOTTANASS - TOTAL TANGIBLE FIXED ASSETS"]
["AcqValOB - OB Acquisition Value","[ICP None]",null,null,null,null,null,null,{"$f":"SUM(A4:H4)","v":0}]
["AdjAcqVal - Other adj to acq val","[ICP Top]",null,null,null,null,null,null,0]
["TransAcqEnt - Merger and transfer between entities acq val","[ICP None]",null,null,null,null,null,null,0]
["AcqAcqVal - Companies acquired / sold, acq val","[ICP None]",{"$f":" ESLDToDate(203,K1)","v":{"$error":"#NAME?"}},{"$f":" ESLDToDate(201,K1)","v":{"$error":"#NAME?"}},{"$f":" ESLDToDate(204,K1)+ESLDToDate(704,K1)+ ESLDToDate(751,K1)","v":{"$error":"#NAME?"}},{"$f":" ESLDToDate(205,K1) +  ESLDToDate(206,K1)","v":{"$error":"#NAME?"}},{"$f":"ESLDToDate(\"4020-000011/01\",K1) + ESLDToDate(\"4020-000069/01\",K1)+ESLDToDate(\"4020-000074/01\",K1)+ESLDToDate(\"4020-000100/01\",K1)+ESLDToDate(\"4021-000015/01\",K1)+ESLDToDate(\"4021-000015/01\",K1)+ESLDToDate(\"2070-01\",K1)+ESLDToDate(\"2070-03\",K1)+ESLDToDate(\"2070-020007/01\",K1)","v":{"$error":"#NAME?"}},{"$f":"ESLDToDate(\"209\",K1)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,"Сумите касаят КС на гр. 20 към момента на  придобиване - в случая 31.05.2016 г."]
["Reclassacq - Reclass between FA categories acq val","[ICP None]",null,null,null,null,null,null,0,null,"Сумите касаят оборотите на с/ките от гр.20  след периода на придобиване - т.е. след 31.05.2016 г. Следователно при приключване на септември това ще са обороти 01.06-30.09.2016 г., за октомври 01-06.31.10.2016 г. и т.н."]
["ScrapAcqVal - Scrapping acq val","[ICP None]",null,null,null,null,null,null,0]
["InvextAcqVal - Investments, ext acq val","[ICP None]",{"$f":"DBT(203)","v":{"$error":"#NAME?"}},{"$f":"DBT(201)","v":{"$error":"#NAME?"}},{"$f":" DBT(204) +  DBT(704) +  DBT(751) - KRT(204)","v":{"$error":"#NAME?"}},{"$f":"DBT(205) + DBT(206)","v":{"$error":"#NAME?"}},{"$f":"DBT(\"4020-000011/01\")+DBT(\"4020-000069/01\")+DBT(\"4020-000074/01\")+DBT(\"4020-000100/01\")+DBT(\"4021-000015/01\")+DBT(\"2070-01\")+DBT(\"2070-03\")+DBT(\"2070-020007/01\")+\n(KRT(\"4020-000011/01\")+KRT(\"4020-000069/01\")+KRT(\"4020-000074/01\")+KRT(\"4020-000100/01\")+KRT(\"4021-000015/01\")+KRT(\"2070-01\")+KRT(\"2070-03\")+KRT(\"2070-020007/01\"))","v":{"$error":"#NAME?"}},{"$f":"DBT(209)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
["InvigAcqVal - Investments, ig acq val","[ICP Top]",null,null,null,null,null,null,0]
["DivextAcqVal - Divestments, ext acq val","[ICP None]",{"$f":"KRT(203)","v":{"$error":"#NAME?"}},{"$f":"KRT(201)","v":{"$error":"#NAME?"}},null,{"$f":" KRT(205) + KRT(206)","v":{"$error":"#NAME?"}},null,{"$f":"KRT(209)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
["DivigAcqVal - Divestments, ig acq val","[ICP Top]",null,null,null,null,null,null,0]
["Transmanacq - Translation difference (manual) acq val","[ICP None]",null,null,null,null,null,null,0]
["Transacq - Translation difference acq val","[ICP None]",null,null,null,null,null,null,0]
["AcqValCB - CB Acquisition Value","[ICP None]",{"$f":"SUM(C4:C15)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[" "," ","","","","","","",""]
["AccDeprOB - OB Accumulated Depreciation","[ICP None]",null,null,null,null,null,null,{"$f":"SUM(A18:H18)","v":0}]
["AdjAccDepr - Other adj to acc depr","[ICP Top]",null,null,null,null,null,null,0]
["TransDeprEnt - Merger and transfer between entities acc depr","[ICP None]",null,null,null,null,null,null,0]
["AcqAccDepr - Companies acquired / sold, acc depr","[ICP None]",{"$f":" ESLDToDate(\"2410-03\",K1)","v":{"$error":"#NAME?"}},null,{"$f":" ESLDToDate(\"2410-04\",K1)","v":{"$error":"#NAME?"}},{"$f":" ESLDToDate(\"2410-05\",K1) +  ESLDToDate(\"2410-06\",K1)","v":{"$error":"#NAME?"}},null,{"$f":"ESLDToDate(\"2410-09\",K1)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,"Сумите касаят КС на с/ка 241 към момента на  придобиване - в случая 31.05.2016 г."]
["Reclassdepr - Reclass between FA categories acc depr","[ICP None]",null,null,null,null,null,null,0,null,"Сумите касаят оборотите на с/ка 241 след периода на придобиване - т.е. след 31.05.2016 г. Следователно при приключване на септември това ще са обороти 01.06-30.09.2016 г., за октомври 01-06.31.10.2016 г. и т.н."]
["ScrapAccDepr - Scrapping acc depr","[ICP None]",null,null,null,null,null,null,0]
["InvigDepr - Investments, ig acc depr","[ICP Top]",null,null,null,null,null,null,0]
["DivextDepr - Divestments, ext acc depr","[ICP None]",{"$f":"DBT(\"2410-03\")","v":{"$error":"#NAME?"}},"няма амортизации",{"$f":"DBT(\"2410-04\")","v":{"$error":"#NAME?"}},{"$f":"DBT(\"2410-05\") + DBT(\"2410-06\")","v":{"$error":"#NAME?"}},"няма амортизации",{"$f":"DBT(\"2410-09\")","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
["DivigDepr - Divestment, ig acc depr","[ICP Top]",null,null,null,null,null,null,0]
["Depr - Annual depreciation","[ICP None]",{"$f":"KRT(\"2410-03\")","v":{"$error":"#NAME?"}},null,"КО с/ка  2410-04 - 40000",{"$f":"KRT(\"2410-05\")+ KRT(\"2410-06\")","v":{"$error":"#NAME?"}},null,{"$f":"KRT(\"2410-09\")","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
["Transmandepr - Translation difference (manual) acc depr","[ICP None]",null,null,null,null,null,null,0]
["Transdepr - Translation differences acc depr","[ICP None]",null,null,null,null,null,null,0]
["AccDeprCB - CB Accumulated Depreciation","[ICP None]",{"$f":"SUM(C18:C29)","v":{"$error":"#NAME?"}},0,{"$error":"#NAME?"},{"$error":"#NAME?"},0,{"$error":"#NAME?"},{"$error":"#NAME?"}]
[" "," ","","","","","","",""]
["ImpOB - OB Impairment","[ICP None]",null,null,null,null,null,null,{"$f":"SUM(A32:H32)","v":0}]
["AdjImp - Other adj to impairment","[ICP Top]",null,null,null,null,null,null,0]
["TransImpEnt - Merger and transfer between entities impairment","[ICP None]",null,null,null,null,null,null,0]
["AcqImp - Companies acquired / sold, impairment","[ICP None]",null,null,null,null,null,null,0]
["ReclassImp - Reclass between FA categories impairment","[ICP None]",null,null,null,null,null,null,0]
["ScrapImp - Scrapping impairment","[ICP None]",null,null,null,null,null,null,0]
["DivextImp - Divestments, ext impairment","[ICP None]",null,null,null,null,null,null,0]
["DivigImp - Divestments, ig impairment","[ICP Top]",null,null,null,null,null,null,0]
["Imp - Current year impairment","[ICP None]",null,null,null,null,null,null,0]
["DeprImp - Current year impairment as part of MFP projects","[ICP None]",null,null,null,null,null,null,0]
["Transmanimp - Translation difference (manual) impairment","[ICP None]",null,null,null,null,null,null,0]
["TransImp - Translation differences impairment","[ICP None]",null,null,null,null,null,null,0]
["ImpCB - CB Impairment","[ICP None]",{"$f":"SUM(C32:C43)","v":0},0,0,0,0,0,0]
[" "," ","","","","","","",""]
["RevalOB - OB Revaluation","[ICP None]",null,null,null,null,null,null,{"$f":"SUM(A46:H46)","v":0}]
["AdjReval - Other adj to revaluation","[ICP None]",null,null,null,null,null,null,{"$f":"SUM(A47:H47)","v":0}]
["TransReval - Translation differences revaluation","[ICP None]",null,null,null,null,null,null,{"$f":"SUM(A48:H48)","v":0}]
["RevalCB - CB Revaluation","[ICP None]",{"$f":"SUM(C46:C48)","v":0},0,0,0,0,0,0]
[" "," ","","","","","","",""]
["NBV - Net Book Value","[ICP None]",{"$f":"C16+C30+C44+C49","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["TaxVal - Tax assessed value","[ICP None]"]
[" "," ","","","","","","",""]
["Validation:"," ","","","","","","",""]
["Validation - Reclass between FA tangibles"," "]

{"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":[]}