Tag all SOEs & highlight the 55 strategically important SOEs on the org chart

[ashanib]

1.Let's tag all the SOEs (527) as well as SOEs have been identified by MoF as being of strategic importance (55). I have shared the excel spreadsheet with you

2.I have also included a column indicated which sector (as per the MoF report the 55 SOEs were grouped into 16 sectors). Is there a way to select the sector and get a summary of all the strategically important SOEs on our org chart?
Department of Public Enterprises - Performance Report 2017: http://www.treasury.gov.lk/documents/63940/182153/PED+PR+-+2017++%28E%29.pdf/b85cb9f4-1ebf-4214-a211-23bc6e5521e7

Advocata report notes:

• 527 SOEs
• Only 10.4% report financials
• 55 of the 527 are recognised as strategically important SOEs by the Treasury

Remarks made by Hon. Mangala Samaraweera, published 5 July 2018
"During 2017, your 55 public ventures alone have recorded a total turnover of nearly Rs. 1800 billion which was almost 13.22 percent of the GDP. Out of the 55 SOBs 39 recorded a net profit amounted to Rs. 136 billion while 16 made net losses amounted to Rs. 87 billion in 2017.
The total asset base of SOBs grew by 13.6 percent in 2017 over 2016 and it accounted for almost 56.8 percent of the GDP. "
http://treasury.gov.lk/article/-/article-viewer-portlet/render/view/remarks-made-by-hon-mangala-samaraweera-minister-of-finance-and-media-at-the-conference-for-the-heads-of-the-state-owned-enterprises-soes-at-the-hilto