{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["TFA","IFA","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":"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,"         TANGIBLE FIXED ASSETS",null,null,null,null,null,null,null,"2016-05-31"]
[null,null,{"$f":"CONCATENATE(\"                               \",GETSTARTDATE(), \" - \",GETENDDATE())","v":{"$error":"#VALUE!"}}]
[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]",3612084,381502,7359968,933398,535207,143289,{"$f":"SUM(A4:H4)","v":12965448}]
["AdjAcqVal - Other adj to acq val","[ICP Top]",null,400,null,null,null,null,400]
["TransAcqEnt - Merger and transfer between entities acq val","[ICP None]",null,null,null,null,null,null,0]
["AcqAcqVal - Companies acquired / sold, acq val",null,null,null,null,null,null,null,{"$f":"SUM(A7:H7)","v":0}]
["Reclassacq - Reclass between FA categories acq val","[ICP None]",null,null,{"$f":"89677.1+1395+19485.99","v":110558.09000000001},7379.3,{"$f":"-E8-F8","v":-117937.39000000001},null,0]
["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":"#VALUE!"}},{"$f":"DBT(201)","v":{"$error":"#VALUE!"}},{"$f":"( D2K(204,\"4\") +D2K(204,\"6\") +  DBT(704) +  DBT(751))+7867.98-2-1395-89677.1","v":{"$error":"#VALUE!"}},{"$f":"D2K(205,\"4\") + D2K(206,\"6\")+D2K(205,\"6\") + D2K(206,\"4\")-7379.3","v":{"$error":"#VALUE!"}},260098,{"$f":"DBT(209)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
["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":"#VALUE!"}},{"$f":"-(KRT(201)-K2D(\"201\",\"112\"))","v":{"$error":"#VALUE!"}},{"$f":"-(KRT(\"204\")-K2D(\"204\",\"112\"))","v":{"$error":"#VALUE!"}},{"$f":" -(KRT(205) + KRT(206))","v":{"$error":"#VALUE!"}},null,{"$f":"KRT(209)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
["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":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},677367.61,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[" "," ","","","","","","",""]
["AccDeprOB - OB Accumulated Depreciation","[ICP None]",-783297,null,-4116035,-755047,null,-96174,{"$f":"SUM(A18:H18)","v":-5750553}]
["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",null,null,null,null,null,null,null,{"$f":"SUM(A21:H21)","v":0}]
["Reclassdepr - Reclass between FA categories acc depr","[ICP None]",null,null,null,null,null,null,0]
["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":"#VALUE!"}},"няма амортизации",{"$f":"DBT(\"2410-04\")","v":{"$error":"#VALUE!"}},{"$f":"DBT(\"2410-05\") + DBT(\"2410-06\")","v":{"$error":"#VALUE!"}},"няма амортизации",{"$f":"DBT(\"2410-09\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
["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":"#VALUE!"}},null,{"$f":"-(KRT(\"2410-04\"))","v":{"$error":"#VALUE!"}},{"$f":"-(KRT(\"2410-05\")+ KRT(\"2410-06\"))","v":{"$error":"#VALUE!"}},null,{"$f":"-KRT(\"2410-09\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
["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":"#VALUE!"}},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[" "," ","","","","","","",""]
["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":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},677367.61,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["TaxVal - Tax assessed value","[ICP None]"]
[" "," ","","","","","","",""]
["Validation:"," ","","","","","","",""]
["Validation - Reclass between FA tangibles"," "]

{"sheet":"IFA","index":1,"n_rows":54,"n_cols":13,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,2,0,10],[1,2,1,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"2016-05-31"]
[null,null,{"$f":"CONCATENATE(\"                               \",GETSTARTDATE(), \" - \",GETENDDATE())","v":{"$error":"#VALUE!"}}]
[null,null,"63100 - Goodwill","63300 - Brand with indefinite life","63400 - Brand","63500 - Software","63600 - Technology","63700 - Customer relations","63800 - Projects in progress","63200 - Other intangible rights","TOTINTANASS - TOTAL INTANGIBLE FIXED ASSETS"]
["AcqValOB - OB Acquisition Value","[ICP None]",null,null,null,721432,null,null,31200,null,{"$f":"SUM(C4:J4)","v":752632}]
["AdjAcqVal - Other adj to acq val","[ICP Top]",null,null,null,null,null,null,null,null,0]
["TransAcqEnt - Merger and transfer between entities acq val","[ICP None]",null,null,null,null,null,null,null,null,0]
["AcqAcqVal - Companies acquired / sold, acq val",null,null,null,null,null,null,null,null,null,{"$f":"SUM(C7:J7)","v":0}]
["Reclassacq - Reclass between FA categories acq val","[ICP None]",null,null,null,9779,null,null,-9779,null,0]
["ScrapAcqVal - Scrapping acq val","[ICP None]",null,null,null,null,null,null,null,null,0]
["InvextAcqVal - Investments, ext acq val","[ICP None]",null,null,null,{"$f":"D2K(2140,\"4\")-9779","v":{"$error":"#VALUE!"}},null,null,16019,null,{"$error":"#VALUE!"}]
["InvigAcqVal - Investments, ig acq val","[ICP Top]",null,null,null,null,null,null,null,null,0]
["DivextAcqVal - Divestments, ext acq val","[ICP None]",null,null,null,{"$f":"-KRT(\"2140\")","v":{"$error":"#VALUE!"}},null,null,null,null,{"$error":"#VALUE!"}]
["DivigAcqVal - Divestments, ig acq val","[ICP Top]",null,null,null,null,null,null,null,null,0]
["Transmanacq - Translation difference (manual) acq val","[ICP None]",null,null,null,null,null,null,null,null,0]
["Transacq - Translation difference acq val","[ICP None]",null,null,null,null,null,null,null,null,0]
["AcqValCB - CB Acquisition Value","[ICP None]",{"$f":"SUM(C4:C15)","v":0},0,0,{"$error":"#VALUE!"},0,0,37440,0,{"$error":"#VALUE!"}]
[" "," ","","","","","","","","",""]
["AccDeprOB - OB Accumulated Depreciation","[ICP None]",null,null,null,-414592,null,null,null,null,{"$f":"SUM(C18:J18)","v":-414592}]
["AdjAccDepr - Other adj to acc depr","[ICP Top]",null,null,null,null,null,null,null,null,0]
["TransDeprEnt - Merger and transfer between entities acc depr","[ICP None]",null,null,null,null,null,null,null,null,0]
["AcqAccDepr - Companies acquired / sold, acc depr",null,null,null,null,null,null,null,null,null,{"$f":"SUM(C21:J21)","v":0}]
["Reclassdepr - Reclass between FA categories acc depr","[ICP None]",null,null,null,null,null,null,null,null,0]
["ScrapAccDepr - Scrapping acc depr","[ICP None]",null,null,null,null,null,null,null,null,0]
["InvigDepr - Investments, ig acc depr","[ICP Top]",null,null,null,null,null,null,null,null,0]
["DivextDepr - Divestments, ext acc depr","[ICP None]",null,null,null,{"$f":"DBT(\"2420-04\")","v":{"$error":"#VALUE!"}},null,null,null,null,{"$error":"#VALUE!"}]
["DivigDepr - Divestment, ig acc depr","[ICP Top]",null,null,null,null,null,null,null,null,0]
["Depr - Annual depreciation","[ICP None]",null,null,null,{"$f":"-KRT(\"2420-04\")","v":{"$error":"#VALUE!"}},null,null,null,null,{"$error":"#VALUE!"}]
["Transmandepr - Translation difference (manual) acc depr","[ICP None]",null,null,null,null,null,null,null,null,0]
["Transdepr - Translation differences acc depr","[ICP None]",null,null,null,null,null,null,null,null,0]
["AccDeprCB - CB Accumulated Depreciation","[ICP None]",{"$f":"SUM(C18:C29)","v":0},0,0,{"$error":"#VALUE!"},0,0,0,0,{"$error":"#VALUE!"}]
[" "," ","","","","","","","","",""]
["ImpOB - OB Impairment","[ICP None]",null,null,null,null,null,null,null,null,{"$f":"SUM(C32:J32)","v":0}]
["AdjImp - Other adj to impairment","[ICP Top]",null,null,null,null,null,null,null,null,0]
["TransImpEnt - Merger and transfer between entities impairment","[ICP None]",null,null,null,null,null,null,null,null,0]
["AcqImp - Companies acquired / sold, impairment","[ICP None]",null,null,null,null,null,null,null,null,0]
["ReclassImp - Reclass between FA categories impairment","[ICP None]",null,null,null,null,null,null,null,null,0]
["ScrapImp - Scrapping impairment","[ICP None]",null,null,null,null,null,null,null,null,0]
["DivextImp - Divestments, ext impairment","[ICP None]",null,null,null,null,null,null,null,null,0]
["DivigImp - Divestments, ig impairment","[ICP Top]",null,null,null,null,null,null,null,null,0]
["Imp - Current year impairment","[ICP None]",null,null,null,null,null,null,null,null,0]
["DeprImp - Current year impairment as part of MFP projects","[ICP None]",null,null,null,null,null,null,null,null,0]
["Transmanimp - Translation difference (manual) impairment","[ICP None]",null,null,null,null,null,null,null,null,0]
["TransImp - Translation differences impairment","[ICP None]",null,null,null,null,null,null,null,null,0]
["ImpCB - CB Impairment","[ICP None]",{"$f":"SUM(C32:C43)","v":0},0,0,0,0,0,0,0,0]
[" "," ","","","","","","","","",""]
["RevalOB - OB Revaluation","[ICP None]",null,null,null,null,null,null,null,null,{"$f":"SUM(C46:J46)","v":0}]
["TransReval - Translation differences revaluation","[ICP None]",null,null,null,null,null,null,null,null,{"$f":"SUM(C47:J47)","v":0}]
["RevalCB - CB Revaluation","[ICP None]",{"$f":"SUM(C46:C47)","v":0},0,0,0,0,0,0,0,0]
[" "," ","","","","","","","","",""]
["NBV - Net Book Value","[ICP None]",{"$f":"C16+C30+C44+C48","v":0},0,0,{"$error":"#VALUE!"},0,0,37440,0,{"$error":"#VALUE!"}]
["TaxVal - Tax assessed value","[ICP None]"]
[" "," ","","","","","","","","",""]
["Validation:"," ","","","","","","","","",""]
["Validation - Reclass between FA tangibles"," "]

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

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