{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["BExRepositorySheet","BalanceSheet","formules_multiple columns","formules_2 columns","VBA"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":12,"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":"BExRepositorySheet","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"BalanceSheet","index":1,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[1,2,3,4,5,6,7,8,9,10]
["Balance Sheet"]
[null,"Assets"]
[null,null,"Property, Plant, Equipment and Intangible Assets"]
[null,null,null,"Intangible Assets"]
[null,null,null,null,"Concessions, Industrial and Similar Rights and Licences in such Rights"]
[null,null,null,null,null,"Concessions, industrial and similar rights and licences in such rights (L0)"]
[null,null,null,null,null,"Established customer bases and brand names"]
[null,null,null,null,null,"Service rights,  purchased for products"]
[null,null,null,null,null,"Acquired brands (only PPA)"]
[null,null,null,null,null,"Other customer-related intangible assets (only PPA)"]
[null,null,null,null,"Goodwill"]
[null,null,null,null,null,"Goodwill, consolidated"]
[null,null,null,null,"Capitalized Vehicle Development Costs"]
[null,null,null,null,null,"Capitalized development costs in progress (before SOP)"]
[null,null,null,null,null,"Capitalized development costs in use (after SOP)"]
[null,null,null,null,null,"Payments on development costs to be capitalized"]
[null,null,null,null,"Other Intangible Assets"]
[null,null,null,null,null,"Other intangible assets (including Software)"]
[null,null,null,null,null,"Other intangible assets (internally generated)"]
[null,null,null,null,null,"Payments on account for intangible assets"]
[null,null,null,"Property, plant and equipment"]
[null,null,null,null,"Property, plant and equipment"]
[null,null,null,null,null,"Land, land rights and buildings incl. buildings on land owned by others"]
[null,null,null,null,null,"Technical Equipment and Machinery (TEM)"]
[null,null,null,null,null,null,"Technical equipment and machinery"]
[null,null,null,null,null,"Operational and Office Equipment"]
[null,null,null,null,null,null,"Other equipment, operational and office equipment"]
[null,null,null,null,null,null,"Spezialized tools and -devices"]
[null,null,null,null,null,"Payments on account and construction in progress"]
[null,null,"Leasing and Rental Assets (LRA)"]
[null,null,null,"Leasing and Rental Assets"]
[null,null,null,null,"Leasing and rental assets (movable)"]
[null,null,null,null,"Advance payments on leasing and rental assets (movable)"]
[null,null,null,null,"Costs of financing operate lease"]
[null,null,null,null,"Buy-back-vehicles/current contracts"]

{"sheet":"formules_multiple columns","index":2,"n_rows":36,"n_cols":21,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[1,2,3,4,5,6,7,8,9,10]
["Balance Sheet",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A$1 < MATCH(\"zzzzz\",$A2:$J2,1),L1,IF(A$1 = MATCH(\"zzzzz\",$A2:$J2,1),A2,\"\"))","v":"Balance Sheet"},{"$f":"IF(B$1 < MATCH(\"zzzzz\",$A2:$J2,1),M1,IF(B$1 = MATCH(\"zzzzz\",$A2:$J2,1),B2,\"\"))","v":""},"","","","","","","",""]
[null,"Assets",null,null,null,null,null,null,null,null,null,{"$f":"IF(A$1 < MATCH(\"zzzzz\",$A3:$J3,1),L2,IF(A$1 = MATCH(\"zzzzz\",$A3:$J3,1),A3,\"\"))","v":"Balance Sheet"},{"$f":"IF(B$1 < MATCH(\"zzzzz\",$A3:$J3,1),M2,IF(B$1 = MATCH(\"zzzzz\",$A3:$J3,1),B3,\"\"))","v":"Assets"},{"$f":"IF(C$1 < MATCH(\"zzzzz\",$A3:$J3,1),N2,IF(C$1 = MATCH(\"zzzzz\",$A3:$J3,1),C3,\"\"))","v":""},{"$f":"IF(D$1 < MATCH(\"zzzzz\",$A3:$J3,1),O2,IF(D$1 = MATCH(\"zzzzz\",$A3:$J3,1),D3,\"\"))","v":""},{"$f":"IF(E$1 < MATCH(\"zzzzz\",$A3:$J3,1),P2,IF(E$1 = MATCH(\"zzzzz\",$A3:$J3,1),E3,\"\"))","v":""},{"$f":"IF(F$1 < MATCH(\"zzzzz\",$A3:$J3,1),Q2,IF(F$1 = MATCH(\"zzzzz\",$A3:$J3,1),F3,\"\"))","v":""},{"$f":"IF(G$1 < MATCH(\"zzzzz\",$A3:$J3,1),R2,IF(G$1 = MATCH(\"zzzzz\",$A3:$J3,1),G3,\"\"))","v":""},{"$f":"IF(H$1 < MATCH(\"zzzzz\",$A3:$J3,1),S2,IF(H$1 = MATCH(\"zzzzz\",$A3:$J3,1),H3,\"\"))","v":""},{"$f":"IF(I$1 < MATCH(\"zzzzz\",$A3:$J3,1),T2,IF(I$1 = MATCH(\"zzzzz\",$A3:$J3,1),I3,\"\"))","v":""},{"$f":"IF(J$1 < MATCH(\"zzzzz\",$A3:$J3,1),U2,IF(J$1 = MATCH(\"zzzzz\",$A3:$J3,1),J3,\"\"))","v":""}]
[null,null,"Property, Plant, Equipment and Intangible Assets",null,null,null,null,null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","","","","","","",""]
[null,null,null,"Intangible Assets",null,null,null,null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Intangible Assets","","","","","",""]
[null,null,null,null,"Concessions, Industrial and Similar Rights and Licences in such Rights",null,null,null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Intangible Assets","Concessions, Industrial and Similar Rights and Licences in such Rights","","","","",""]
[null,null,null,null,null,"Concessions, industrial and similar rights and licences in such rights (L0)",null,null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Intangible Assets","Concessions, Industrial and Similar Rights and Licences in such Rights","Concessions, industrial and similar rights and licences in such rights (L0)","","","",""]
[null,null,null,null,null,"Established customer bases and brand names",null,null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Intangible Assets","Concessions, Industrial and Similar Rights and Licences in such Rights","Established customer bases and brand names","","","",""]
[null,null,null,null,null,"Service rights,  purchased for products",null,null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Intangible Assets","Concessions, Industrial and Similar Rights and Licences in such Rights","Service rights,  purchased for products","","","",""]
[null,null,null,null,null,"Acquired brands (only PPA)",null,null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Intangible Assets","Concessions, Industrial and Similar Rights and Licences in such Rights","Acquired brands (only PPA)","","","",""]
[null,null,null,null,null,"Other customer-related intangible assets (only PPA)",null,null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Intangible Assets","Concessions, Industrial and Similar Rights and Licences in such Rights","Other customer-related intangible assets (only PPA)","","","",""]
[null,null,null,null,"Goodwill",null,null,null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Intangible Assets","Goodwill","","","","",""]
[null,null,null,null,null,"Goodwill, consolidated",null,null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Intangible Assets","Goodwill","Goodwill, consolidated","","","",""]
[null,null,null,null,"Capitalized Vehicle Development Costs",null,null,null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Intangible Assets","Capitalized Vehicle Development Costs","","","","",""]
[null,null,null,null,null,"Capitalized development costs in progress (before SOP)",null,null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Intangible Assets","Capitalized Vehicle Development Costs","Capitalized development costs in progress (before SOP)","","","",""]
[null,null,null,null,null,"Capitalized development costs in use (after SOP)",null,null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Intangible Assets","Capitalized Vehicle Development Costs","Capitalized development costs in use (after SOP)","","","",""]
[null,null,null,null,null,"Payments on development costs to be capitalized",null,null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Intangible Assets","Capitalized Vehicle Development Costs","Payments on development costs to be capitalized","","","",""]
[null,null,null,null,"Other Intangible Assets",null,null,null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Intangible Assets","Other Intangible Assets","","","","",""]
[null,null,null,null,null,"Other intangible assets (including Software)",null,null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Intangible Assets","Other Intangible Assets","Other intangible assets (including Software)","","","",""]
[null,null,null,null,null,"Other intangible assets (internally generated)",null,null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Intangible Assets","Other Intangible Assets","Other intangible assets (internally generated)","","","",""]
[null,null,null,null,null,"Payments on account for intangible assets",null,null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Intangible Assets","Other Intangible Assets","Payments on account for intangible assets","","","",""]
[null,null,null,"Property, plant and equipment (PPE)",null,null,null,null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Property, plant and equipment (PPE)","","","","","",""]
[null,null,null,null,"Property, plant and equipment",null,null,null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Property, plant and equipment (PPE)","Property, plant and equipment","","","","",""]
[null,null,null,null,null,"Land, land rights and buildings incl. buildings on land owned by others",null,null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Property, plant and equipment (PPE)","Property, plant and equipment","Land, land rights and buildings incl. buildings on land owned by others","","","",""]
[null,null,null,null,null,"Technical Equipment and Machinery (TEM)",null,null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Property, plant and equipment (PPE)","Property, plant and equipment","Technical Equipment and Machinery (TEM)","","","",""]
[null,null,null,null,null,null,"Technical equipment and machinery",null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Property, plant and equipment (PPE)","Property, plant and equipment","Technical Equipment and Machinery (TEM)","Technical equipment and machinery","","",""]
[null,null,null,null,null,"Operational and Office Equipment",null,null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Property, plant and equipment (PPE)","Property, plant and equipment","Operational and Office Equipment","","","",""]
[null,null,null,null,null,null,"Other equipment, operational and office equipment",null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Property, plant and equipment (PPE)","Property, plant and equipment","Operational and Office Equipment","Other equipment, operational and office equipment","","",""]
[null,null,null,null,null,null,"Spezialized tools and -devices",null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Property, plant and equipment (PPE)","Property, plant and equipment","Operational and Office Equipment","Spezialized tools and -devices","","",""]
[null,null,null,null,null,"Payments on account and construction in progress",null,null,null,null,null,"Balance Sheet","Assets","Property, Plant, Equipment and Intangible Assets","Property, plant and equipment (PPE)","Property, plant and equipment","Payments on account and construction in progress","","","",""]
[null,null,"Leasing and Rental Assets (LRA)",null,null,null,null,null,null,null,null,"Balance Sheet","Assets","Leasing and Rental Assets (LRA)","","","","","","",""]
[null,null,null,"Leasing and Rental Assets",null,null,null,null,null,null,null,"Balance Sheet","Assets","Leasing and Rental Assets (LRA)","Leasing and Rental Assets","","","","","",""]
[null,null,null,null,"Leasing and rental assets (movable)",null,null,null,null,null,null,"Balance Sheet","Assets","Leasing and Rental Assets (LRA)","Leasing and Rental Assets","Leasing and rental assets (movable)","","","","",""]
[null,null,null,null,"Advance payments on leasing and rental assets (movable)",null,null,null,null,null,null,"Balance Sheet","Assets","Leasing and Rental Assets (LRA)","Leasing and Rental Assets","Advance payments on leasing and rental assets (movable)","","","","",""]
[null,null,null,null,"Costs of financing operate lease",null,null,null,null,null,null,"Balance Sheet","Assets","Leasing and Rental Assets (LRA)","Leasing and Rental Assets","Costs of financing operate lease","","","","",""]
[null,null,null,null,"Buy-back-vehicles/current contracts",null,null,null,null,null,null,"Balance Sheet","Assets","Leasing and Rental Assets (LRA)","Leasing and Rental Assets","Buy-back-vehicles/current contracts","","","","",""]

{"sheet":"formules_2 columns","index":3,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[1,2,3,4,5,6,7,8,9,10]
["Balance Sheet",null,null,null,null,null,null,null,null,null,null,{"$f":"MATCH(\"zzzzz\",A2:J2,1)","v":1},{"$f":"INDEX(A2:J2,L2)","v":"Balance Sheet"},{"$f":"IF( L2 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J2, , L2-1 )) )","v":""},{"$f":"IF(L2=1,\"\",LOOKUP(2,1/($L$2:$L2=L2-1),$M$2:$M2))","v":""}]
[null,"Assets",null,null,null,null,null,null,null,null,null,2,{"$f":"INDEX(A3:J3,L3)","v":"Assets"},{"$f":"IF( L3 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J3, , L3-1 )) )","v":"Balance Sheet"},{"$f":"IF(L3=1,\"\",LOOKUP(2,1/($L$2:$L3=L3-1),$M$2:$M3))","v":"Balance Sheet"}]
[null,null,"Property, Plant, Equipment and Intangible Assets",null,null,null,null,null,null,null,null,3,"Property, Plant, Equipment and Intangible Assets",{"$f":"IF( L4 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J4, , L4-1 )) )","v":"Assets"},{"$f":"IF(L4=1,\"\",LOOKUP(2,1/($L$2:$L4=L4-1),$M$2:$M4))","v":"Assets"}]
[null,null,null,"Intangible Assets",null,null,null,null,null,null,null,4,"Intangible Assets",{"$f":"IF( L5 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J5, , L5-1 )) )","v":"Property, Plant, Equipment and Intangible Assets"},{"$f":"IF(L5=1,\"\",LOOKUP(2,1/($L$2:$L5=L5-1),$M$2:$M5))","v":"Property, Plant, Equipment and Intangible Assets"}]
[null,null,null,null,"Concessions, Industrial and Similar Rights and Licences in such Rights",null,null,null,null,null,null,5,"Concessions, Industrial and Similar Rights and Licences in such Rights",{"$f":"IF( L6 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J6, , L6-1 )) )","v":"Intangible Assets"},{"$f":"IF(L6=1,\"\",LOOKUP(2,1/($L$2:$L6=L6-1),$M$2:$M6))","v":"Intangible Assets"}]
[null,null,null,null,null,"Concessions, industrial and similar rights and licences in such rights (L0)",null,null,null,null,null,6,"Concessions, industrial and similar rights and licences in such rights (L0)",{"$f":"IF( L7 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J7, , L7-1 )) )","v":"Concessions, Industrial and Similar Rights and Licences in such Rights"},{"$f":"IF(L7=1,\"\",LOOKUP(2,1/($L$2:$L7=L7-1),$M$2:$M7))","v":"Concessions, Industrial and Similar Rights and Licences in such Rights"}]
[null,null,null,null,null,"Established customer bases and brand names",null,null,null,null,null,6,"Established customer bases and brand names",{"$f":"IF( L8 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J8, , L8-1 )) )","v":"Concessions, Industrial and Similar Rights and Licences in such Rights"},{"$f":"IF(L8=1,\"\",LOOKUP(2,1/($L$2:$L8=L8-1),$M$2:$M8))","v":"Concessions, Industrial and Similar Rights and Licences in such Rights"}]
[null,null,null,null,null,"Service rights,  purchased for products",null,null,null,null,null,6,"Service rights,  purchased for products",{"$f":"IF( L9 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J9, , L9-1 )) )","v":"Concessions, Industrial and Similar Rights and Licences in such Rights"},{"$f":"IF(L9=1,\"\",LOOKUP(2,1/($L$2:$L9=L9-1),$M$2:$M9))","v":"Concessions, Industrial and Similar Rights and Licences in such Rights"}]
[null,null,null,null,null,"Acquired brands (only PPA)",null,null,null,null,null,6,"Acquired brands (only PPA)",{"$f":"IF( L10 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J10, , L10-1 )) )","v":"Concessions, Industrial and Similar Rights and Licences in such Rights"},{"$f":"IF(L10=1,\"\",LOOKUP(2,1/($L$2:$L10=L10-1),$M$2:$M10))","v":"Concessions, Industrial and Similar Rights and Licences in such Rights"}]
[null,null,null,null,null,"Other customer-related intangible assets (only PPA)",null,null,null,null,null,6,"Other customer-related intangible assets (only PPA)",{"$f":"IF( L11 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J11, , L11-1 )) )","v":"Concessions, Industrial and Similar Rights and Licences in such Rights"},{"$f":"IF(L11=1,\"\",LOOKUP(2,1/($L$2:$L11=L11-1),$M$2:$M11))","v":"Concessions, Industrial and Similar Rights and Licences in such Rights"}]
[null,null,null,null,"Goodwill",null,null,null,null,null,null,5,"Goodwill",{"$f":"IF( L12 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J12, , L12-1 )) )","v":"Intangible Assets"},{"$f":"IF(L12=1,\"\",LOOKUP(2,1/($L$2:$L12=L12-1),$M$2:$M12))","v":"Intangible Assets"}]
[null,null,null,null,null,"Goodwill, consolidated",null,null,null,null,null,6,"Goodwill, consolidated",{"$f":"IF( L13 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J13, , L13-1 )) )","v":"Goodwill"},{"$f":"IF(L13=1,\"\",LOOKUP(2,1/($L$2:$L13=L13-1),$M$2:$M13))","v":"Goodwill"}]
[null,null,null,null,"Capitalized Vehicle Development Costs",null,null,null,null,null,null,5,"Capitalized Vehicle Development Costs",{"$f":"IF( L14 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J14, , L14-1 )) )","v":"Intangible Assets"},{"$f":"IF(L14=1,\"\",LOOKUP(2,1/($L$2:$L14=L14-1),$M$2:$M14))","v":"Intangible Assets"}]
[null,null,null,null,null,"Capitalized development costs in progress (before SOP)",null,null,null,null,null,6,"Capitalized development costs in progress (before SOP)",{"$f":"IF( L15 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J15, , L15-1 )) )","v":"Capitalized Vehicle Development Costs"},{"$f":"IF(L15=1,\"\",LOOKUP(2,1/($L$2:$L15=L15-1),$M$2:$M15))","v":"Capitalized Vehicle Development Costs"}]
[null,null,null,null,null,"Capitalized development costs in use (after SOP)",null,null,null,null,null,6,"Capitalized development costs in use (after SOP)",{"$f":"IF( L16 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J16, , L16-1 )) )","v":"Capitalized Vehicle Development Costs"},{"$f":"IF(L16=1,\"\",LOOKUP(2,1/($L$2:$L16=L16-1),$M$2:$M16))","v":"Capitalized Vehicle Development Costs"}]
[null,null,null,null,null,"Payments on development costs to be capitalized",null,null,null,null,null,6,"Payments on development costs to be capitalized",{"$f":"IF( L17 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J17, , L17-1 )) )","v":"Capitalized Vehicle Development Costs"},{"$f":"IF(L17=1,\"\",LOOKUP(2,1/($L$2:$L17=L17-1),$M$2:$M17))","v":"Capitalized Vehicle Development Costs"}]
[null,null,null,null,"Other Intangible Assets",null,null,null,null,null,null,5,"Other Intangible Assets",{"$f":"IF( L18 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J18, , L18-1 )) )","v":"Intangible Assets"},{"$f":"IF(L18=1,\"\",LOOKUP(2,1/($L$2:$L18=L18-1),$M$2:$M18))","v":"Intangible Assets"}]
[null,null,null,null,null,"Other intangible assets (including Software)",null,null,null,null,null,6,"Other intangible assets (including Software)",{"$f":"IF( L19 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J19, , L19-1 )) )","v":"Other Intangible Assets"},{"$f":"IF(L19=1,\"\",LOOKUP(2,1/($L$2:$L19=L19-1),$M$2:$M19))","v":"Other Intangible Assets"}]
[null,null,null,null,null,"Other intangible assets (internally generated)",null,null,null,null,null,6,"Other intangible assets (internally generated)",{"$f":"IF( L20 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J20, , L20-1 )) )","v":"Other Intangible Assets"},{"$f":"IF(L20=1,\"\",LOOKUP(2,1/($L$2:$L20=L20-1),$M$2:$M20))","v":"Other Intangible Assets"}]
[null,null,null,null,null,"Payments on account for intangible assets",null,null,null,null,null,6,"Payments on account for intangible assets",{"$f":"IF( L21 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J21, , L21-1 )) )","v":"Other Intangible Assets"},{"$f":"IF(L21=1,\"\",LOOKUP(2,1/($L$2:$L21=L21-1),$M$2:$M21))","v":"Other Intangible Assets"}]
[null,null,null,"Property, plant and equipment (PPE)",null,null,null,null,null,null,null,4,"Property, plant and equipment (PPE)",{"$f":"IF( L22 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J22, , L22-1 )) )","v":"Property, Plant, Equipment and Intangible Assets"},{"$f":"IF(L22=1,\"\",LOOKUP(2,1/($L$2:$L22=L22-1),$M$2:$M22))","v":"Property, Plant, Equipment and Intangible Assets"}]
[null,null,null,null,"Property, plant and equipment",null,null,null,null,null,null,5,"Property, plant and equipment",{"$f":"IF( L23 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J23, , L23-1 )) )","v":"Property, plant and equipment (PPE)"},{"$f":"IF(L23=1,\"\",LOOKUP(2,1/($L$2:$L23=L23-1),$M$2:$M23))","v":"Property, plant and equipment (PPE)"}]
[null,null,null,null,null,"Land, land rights and buildings incl. buildings on land owned by others",null,null,null,null,null,6,"Land, land rights and buildings incl. buildings on land owned by others",{"$f":"IF( L24 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J24, , L24-1 )) )","v":"Property, plant and equipment"},{"$f":"IF(L24=1,\"\",LOOKUP(2,1/($L$2:$L24=L24-1),$M$2:$M24))","v":"Property, plant and equipment"}]
[null,null,null,null,null,"Technical Equipment and Machinery",null,null,null,null,null,6,"Technical Equipment and Machinery",{"$f":"IF( L25 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J25, , L25-1 )) )","v":"Property, plant and equipment"},{"$f":"IF(L25=1,\"\",LOOKUP(2,1/($L$2:$L25=L25-1),$M$2:$M25))","v":"Property, plant and equipment"}]
[null,null,null,null,null,null,"Technical equipment and machinery",null,null,null,null,7,"Technical equipment and machinery",{"$f":"IF( L26 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J26, , L26-1 )) )","v":"Technical Equipment and Machinery"},{"$f":"IF(L26=1,\"\",LOOKUP(2,1/($L$2:$L26=L26-1),$M$2:$M26))","v":"Technical Equipment and Machinery"}]
[null,null,null,null,null,"Operational and Office Equipment",null,null,null,null,null,6,"Operational and Office Equipment",{"$f":"IF( L27 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J27, , L27-1 )) )","v":"Property, plant and equipment"},{"$f":"IF(L27=1,\"\",LOOKUP(2,1/($L$2:$L27=L27-1),$M$2:$M27))","v":"Property, plant and equipment"}]
[null,null,null,null,null,null,"Other equipment, operational and office equipment",null,null,null,null,7,"Other equipment, operational and office equipment",{"$f":"IF( L28 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J28, , L28-1 )) )","v":"Operational and Office Equipment"},{"$f":"IF(L28=1,\"\",LOOKUP(2,1/($L$2:$L28=L28-1),$M$2:$M28))","v":"Operational and Office Equipment"}]
[null,null,null,null,null,null,"Spezialized tools and -devices",null,null,null,null,7,"Spezialized tools and -devices",{"$f":"IF( L29 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J29, , L29-1 )) )","v":"Operational and Office Equipment"},{"$f":"IF(L29=1,\"\",LOOKUP(2,1/($L$2:$L29=L29-1),$M$2:$M29))","v":"Operational and Office Equipment"}]
[null,null,null,null,null,"Payments on account and construction in progress",null,null,null,null,null,6,"Payments on account and construction in progress",{"$f":"IF( L30 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J30, , L30-1 )) )","v":"Property, plant and equipment"},{"$f":"IF(L30=1,\"\",LOOKUP(2,1/($L$2:$L30=L30-1),$M$2:$M30))","v":"Property, plant and equipment"}]
[null,null,"Leasing and Rental Assets (LRA)",null,null,null,null,null,null,null,null,3,"Leasing and Rental Assets (LRA)",{"$f":"IF( L31 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J31, , L31-1 )) )","v":"Assets"},{"$f":"IF(L31=1,\"\",LOOKUP(2,1/($L$2:$L31=L31-1),$M$2:$M31))","v":"Assets"}]
[null,null,null,"Leasing and Rental Assets",null,null,null,null,null,null,null,4,"Leasing and Rental Assets",{"$f":"IF( L32 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J32, , L32-1 )) )","v":"Leasing and Rental Assets (LRA)"},{"$f":"IF(L32=1,\"\",LOOKUP(2,1/($L$2:$L32=L32-1),$M$2:$M32))","v":"Leasing and Rental Assets (LRA)"}]
[null,null,null,null,"Leasing and rental assets (movable)",null,null,null,null,null,null,5,"Leasing and rental assets (movable)",{"$f":"IF( L33 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J33, , L33-1 )) )","v":"Leasing and Rental Assets"},{"$f":"IF(L33=1,\"\",LOOKUP(2,1/($L$2:$L33=L33-1),$M$2:$M33))","v":"Leasing and Rental Assets"}]
[null,null,null,null,"Advance payments on leasing and rental assets (movable)",null,null,null,null,null,null,5,"Advance payments on leasing and rental assets (movable)",{"$f":"IF( L34 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J34, , L34-1 )) )","v":"Leasing and Rental Assets"},{"$f":"IF(L34=1,\"\",LOOKUP(2,1/($L$2:$L34=L34-1),$M$2:$M34))","v":"Leasing and Rental Assets"}]
[null,null,null,null,"Costs of financing operate lease",null,null,null,null,null,null,5,"Costs of financing operate lease",{"$f":"IF( L35 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J35, , L35-1 )) )","v":"Leasing and Rental Assets"},{"$f":"IF(L35=1,\"\",LOOKUP(2,1/($L$2:$L35=L35-1),$M$2:$M35))","v":"Leasing and Rental Assets"}]
[null,null,null,null,"Buy-back-vehicles/current contracts",null,null,null,null,null,null,5,"Buy-back-vehicles/current contracts",{"$f":"IF( L36 = 1, \"\", LOOKUP(\"zzzzz\", INDEX($A$2:$J36, , L36-1 )) )","v":"Leasing and Rental Assets"},{"$f":"IF(L36=1,\"\",LOOKUP(2,1/($L$2:$L36=L36-1),$M$2:$M36))","v":"Leasing and Rental Assets"}]

{"sheet":"VBA","index":4,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[1,2,3,4,5,6,7,8,9,10]
["Balance Sheet"]
[null,"Assets",null,null,null,null,null,null,null,null,null,null,null,"Assets","Balance Sheet"]
[null,null,"Property, Plant, Equipment and Intangible Assets",null,null,null,null,null,null,null,null,null,null,"Property, Plant, Equipment and Intangible Assets","Assets"]
[null,null,null,"Intangible Assets",null,null,null,null,null,null,null,null,null,"Intangible Assets","Property, Plant, Equipment and Intangible Assets"]
[null,null,null,null,"Concessions, Industrial and Similar Rights and Licences in such Rights",null,null,null,null,null,null,null,null,"Concessions, Industrial and Similar Rights and Licences in such Rights","Intangible Assets"]
[null,null,null,null,null,"Concessions, industrial and similar rights and licences in such rights (L0)",null,null,null,null,null,null,null,"Concessions, industrial and similar rights and licences in such rights (L0)","Concessions, Industrial and Similar Rights and Licences in such Rights"]
[null,null,null,null,null,"Established customer bases and brand names",null,null,null,null,null,null,null,"Established customer bases and brand names","Concessions, Industrial and Similar Rights and Licences in such Rights"]
[null,null,null,null,null,"Service rights,  purchased for products",null,null,null,null,null,null,null,"Service rights,  purchased for products","Concessions, Industrial and Similar Rights and Licences in such Rights"]
[null,null,null,null,null,"Acquired brands (only PPA)",null,null,null,null,null,null,null,"Acquired brands (only PPA)","Concessions, Industrial and Similar Rights and Licences in such Rights"]
[null,null,null,null,null,"Other customer-related intangible assets (only PPA)",null,null,null,null,null,null,null,"Other customer-related intangible assets (only PPA)","Concessions, Industrial and Similar Rights and Licences in such Rights"]
[null,null,null,null,"Goodwill",null,null,null,null,null,null,null,null,"Goodwill","Intangible Assets"]
[null,null,null,null,null,"Goodwill, consolidated",null,null,null,null,null,null,null,"Goodwill, consolidated","Goodwill"]
[null,null,null,null,"Capitalized Vehicle Development Costs",null,null,null,null,null,null,null,null,"Capitalized Vehicle Development Costs","Intangible Assets"]
[null,null,null,null,null,"Capitalized development costs in progress (before SOP)",null,null,null,null,null,null,null,"Capitalized development costs in progress (before SOP)","Capitalized Vehicle Development Costs"]
[null,null,null,null,null,"Capitalized development costs in use (after SOP)",null,null,null,null,null,null,null,"Capitalized development costs in use (after SOP)","Capitalized Vehicle Development Costs"]
[null,null,null,null,null,"Payments on development costs to be capitalized",null,null,null,null,null,null,null,"Payments on development costs to be capitalized","Capitalized Vehicle Development Costs"]
[null,null,null,null,"Other Intangible Assets",null,null,null,null,null,null,null,null,"Other Intangible Assets","Intangible Assets"]
[null,null,null,null,null,"Other intangible assets (including Software)",null,null,null,null,null,null,null,"Other intangible assets (including Software)","Other Intangible Assets"]
[null,null,null,null,null,"Other intangible assets (internally generated)",null,null,null,null,null,null,null,"Other intangible assets (internally generated)","Other Intangible Assets"]
[null,null,null,null,null,"Payments on account for intangible assets",null,null,null,null,null,null,null,"Payments on account for intangible assets","Other Intangible Assets"]
[null,null,null,"Property, plant and equipment (PPE)",null,null,null,null,null,null,null,null,null,"Property, plant and equipment (PPE)","Property, Plant, Equipment and Intangible Assets"]
[null,null,null,null,"Property, plant and equipment",null,null,null,null,null,null,null,null,"Property, plant and equipment","Property, plant and equipment (PPE)"]
[null,null,null,null,null,"Land, land rights and buildings incl. buildings on land owned by others",null,null,null,null,null,null,null,"Land, land rights and buildings incl. buildings on land owned by others","Property, plant and equipment"]
[null,null,null,null,null,"Technical Equipment and Machinery (TEM)",null,null,null,null,null,null,null,"Technical Equipment and Machinery","Property, plant and equipment"]
[null,null,null,null,null,null,"Technical equipment and machinery",null,null,null,null,null,null,"Technical equipment and machinery","Technical Equipment and Machinery"]
[null,null,null,null,null,"Operational and Office Equipment",null,null,null,null,null,null,null,"Operational and Office Equipment","Property, plant and equipment"]
[null,null,null,null,null,null,"Other equipment, operational and office equipment",null,null,null,null,null,null,"Other equipment, operational and office equipment","Operational and Office Equipment"]
[null,null,null,null,null,null,"Spezialized tools and -devices",null,null,null,null,null,null,"Spezialized tools and -devices","Operational and Office Equipment"]
[null,null,null,null,null,"Payments on account and construction in progress",null,null,null,null,null,null,null,"Payments on account and construction in progress","Property, plant and equipment"]
[null,null,"Leasing and Rental Assets (LRA)",null,null,null,null,null,null,null,null,null,null,"Leasing and Rental Assets (LRA)","Assets"]
[null,null,null,"Leasing and Rental Assets",null,null,null,null,null,null,null,null,null,"Leasing and Rental Assets","Leasing and Rental Assets (LRA)"]
[null,null,null,null,"Leasing and rental assets (movable)",null,null,null,null,null,null,null,null,"Leasing and rental assets (movable)","Leasing and Rental Assets"]
[null,null,null,null,"Advance payments on leasing and rental assets (movable)",null,null,null,null,null,null,null,null,"Advance payments on leasing and rental assets (movable)","Leasing and Rental Assets"]
[null,null,null,null,"Costs of financing operate lease",null,null,null,null,null,null,null,null,"Costs of financing operate lease","Leasing and Rental Assets"]
[null,null,null,null,"Buy-back-vehicles/current contracts",null,null,null,null,null,null,null,null,"Buy-back-vehicles/current contracts","Leasing and Rental Assets"]