{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Introduction","Visual corporate structure","Raw_data"],"not_rendered":{"charts":0,"images":1,"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":"Introduction","index":0,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[11,10,16,25],[14,2,14,7],[15,2,15,7],[16,2,16,7],[12,2,12,7],[13,2,13,7],[11,2,11,7]]}
[]
[]
[]
[]
[]
[null,"Overview and information"]
[]
[null,null,"Number of subsidiaries","Number of countries","Number of layers"]
[null,"PetroSA",38,8,2]
[]
[]
[null,null,"Variable Definition",null,null,null,null,null,null,null,"Click the button \"Launch\" to visualise the corporate structure. \n\nEach node in the structure contains the following information:\nCompany Name_Country Incorporation_Industry_(Percentage of shares owned by its direct parent company) [*number of subsidiaries with the same information regarding name, country and industry, but different tax registration number] \n\n"]
[null,"Company Name","Name of the subsidiary"]
[null,"Country Incorporation","Country of incorporations of the subsidiary"]
[null,"Industry","Industry in which the subsidiary operates"]
[null,"Percentage_share","Percentage of shares owned by its direct parent company"]
[null,"Layer No.","Refers to the layer in the corporate structure where the company is located. When layer_number is 1, it means that it is the direct subsidiary. When layer_number is 2, it means that it is owned directly by a direct subsidiary."]

{"sheet":"Visual corporate structure","index":1,"n_rows":40,"n_cols":3,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Company","Layer 1","Layer 2"]
["PetroSA (South Africa)"]
[null,"African Exploration Mining And Finance Corporation_South Africa_Mining(100)"]
[null,null,"Pan African Mineral Development Company (Pty) Ltd_South Africa_Services(50)[*2]"]
[null,"African Exploration Mining And Finance Corporation (Pty) Ltd_South Africa(100)"]
[null,"Berg River Business Park (Pty) Ltd_South Africa_Services(45)"]
[null,"Carbon Stream Africa (Pty) Ltd_South Africa(60)"]
[null,"Cce Solutions (Pty) Ltd_South Africa_Retail_trade(89.2)"]
[null,"Cef Carbon (Pty) Ltd_South Africa_Services(100)"]
[null,"Cotec Development (Pty) Ltd_South Africa(100)"]
[null,"Cotec Patrade (Pty) Ltd_South Africa(100)"]
[null,"Energysystemssa (Pty) Ltd_South Africa_Services(29)"]
[null,"Eta Energy (Pty) Ltd_South Africa_Retail_trade(100)"]
[null,"Gtl.F1 Ag_Germany(50)"]
[null,"I-Gas (Pty) Ltd_South Africa(100)"]
[null,"Klippoortje Koolmyne (Pty) Ltd_South Africa(100)"]
[null,"Oil Pollution Control South Africa_South Africa_Services(100)"]
[null,"S F F Association_South Africa_Services(100)"]
[null,"South African Agency For Promotion of Petroleum Exploration_South Africa_Mining(100)"]
[null,"South African Gas Development Company (Pty) Ltd_South Africa_Trans.&Comm.&Util.(100)"]
[null,"South African Supplier Development Agency_South Africa(100)"]
[null,"The Petroleum Oil And Gas Corporation of South Africa_South Africa_Mining(100)"]
[null,null,"Petrosa Equatorial Guinea (South Africa) (Pty) Ltd_South Africa_Services(100)"]
[null,null,"Gtl.F1 Ag_Germany(50)"]
[null,null,"Petrosa Gryphon Marin Permit (Pty) Ltd_South Africa_Financials(100)"]
[null,null,"Sabre Oil & Gas Holdings Ltd_Virgin Islands (British)(100)"]
[null,null,"Petrosa Sudan (Pty) Ltd_South Africa_Services(100)"]
[null,null,"PetroSA North America Inc_United States of America(100)"]
[null,null,"Petrosa Synfuels International (Pty) Ltd_South Africa_Services(100)"]
[null,null,"Petrosa Egypt_South Africa_Services(100)"]
[null,null,"Petrosa Equatorial Guinea (South Africa)_South Africa_Services(100)"]
[null,null,"PetroSA Nigeria Ltd_Nigeria(100)"]
[null,null,"Petrosa Rehabilitation_South Africa(100)"]
[null,null,"Petrosa Brass (Pty) Ltd_South Africa_Services(100)"]
[null,null,"Petrosa Themis (Pty) Ltd_South Africa_Financials(100)"]
[null,null,"Statoil ASA Joint Venture_Norway(50)"]
[null,null,"Petrosa Iris (Pty) Ltd_South Africa_Financials(100)"]
[null,null,"PetroSA Ghana Ltd_Ghana(100)"]
[null,"The Petroleum Oil And Gas Corporation of South Africa (Pty)_South Africa_Mining(50.01)"]
[null,null,"PetroSA Europe B.V._Netherlands_Services(100)"]

{"sheet":"Raw_data","index":2,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["Information","Layer No.","Parent Identifier","Direct Parent Identifier"]
["African Exploration Mining And Finance Corporation_South Africa_Mining(100)",1,"001",""]
["Pan African Mineral Development Company (Pty) Ltd_South Africa_Services(50)[*2]",2,"001001","001"]
["African Exploration Mining And Finance Corporation (Pty) Ltd_South Africa(100)",1,"002",""]
["Berg River Business Park (Pty) Ltd_South Africa_Services(45)",1,"003",""]
["Carbon Stream Africa (Pty) Ltd_South Africa(60)",1,"004",""]
["Cce Solutions (Pty) Ltd_South Africa_Retail_trade(89.2)",1,"005",""]
["Cef Carbon (Pty) Ltd_South Africa_Services(100)",1,"006",""]
["Cotec Development (Pty) Ltd_South Africa(100)",1,"007",""]
["Cotec Patrade (Pty) Ltd_South Africa(100)",1,"008",""]
["Energysystemssa (Pty) Ltd_South Africa_Services(29)",1,"009",""]
["Eta Energy (Pty) Ltd_South Africa_Retail_trade(100)",1,"010",""]
["Gtl.F1 Ag_Germany(50)",1,"011",""]
["I-Gas (Pty) Ltd_South Africa(100)",1,"012",""]
["Klippoortje Koolmyne (Pty) Ltd_South Africa(100)",1,"013",""]
["Oil Pollution Control South Africa_South Africa_Services(100)",1,"014",""]
["S F F Association_South Africa_Services(100)",1,"015",""]
["South African Agency For Promotion of Petroleum Exploration_South Africa_Mining(100)",1,"016",""]
["South African Gas Development Company (Pty) Ltd_South Africa_Trans.&Comm.&Util.(100)",1,"017",""]
["South African Supplier Development Agency_South Africa(100)",1,"018",""]
["The Petroleum Oil And Gas Corporation of South Africa_South Africa_Mining(100)",1,"019",""]
["Petrosa Equatorial Guinea (South Africa) (Pty) Ltd_South Africa_Services(100)",2,"019001","019"]
["Gtl.F1 Ag_Germany(50)",2,"019002","019"]
["Petrosa Gryphon Marin Permit (Pty) Ltd_South Africa_Financials(100)",2,"019003","019"]
["Sabre Oil & Gas Holdings Ltd_Virgin Islands (British)(100)",2,"019004","019"]
["Petrosa Sudan (Pty) Ltd_South Africa_Services(100)",2,"019005","019"]
["PetroSA North America Inc_United States of America(100)",2,"019006","019"]
["Petrosa Synfuels International (Pty) Ltd_South Africa_Services(100)",2,"019007","019"]
["Petrosa Egypt_South Africa_Services(100)",2,"019008","019"]
["Petrosa Equatorial Guinea (South Africa)_South Africa_Services(100)",2,"019009","019"]
["PetroSA Nigeria Ltd_Nigeria(100)",2,"019010","019"]
["Petrosa Rehabilitation_South Africa(100)",2,"019011","019"]
["Petrosa Brass (Pty) Ltd_South Africa_Services(100)",2,"019012","019"]
["Petrosa Themis (Pty) Ltd_South Africa_Financials(100)",2,"019013","019"]
["Statoil ASA Joint Venture_Norway(50)",2,"019014","019"]
["Petrosa Iris (Pty) Ltd_South Africa_Financials(100)",2,"019015","019"]
["PetroSA Ghana Ltd_Ghana(100)",2,"019016","019"]
["The Petroleum Oil And Gas Corporation of South Africa (Pty)_South Africa_Mining(50.01)",1,"020",""]
["PetroSA Europe B.V._Netherlands_Services(100)",2,"020001","020"]