1. Objective and Scope
1.1. Objective of this Operation
The objective of this procedure is to identify and categorize the blocking controls obtained during the month.
1.2. Scope
The scope of this procedure is worldwide, applicable to all BFC reporting companies from PF1, WP1 and PI1 systems.
2. Definitions
Deadline proposal: Every Month, on D+6.
See Finance Glossary:
3. Tasks description
WHAT and HOW - Main content of the operation
The content should be mainly organized in 2 levels of Headings to ensure a proper link with the Table of Contents.
Select the level of heading in the "Paragraph" option.
3.1. I request for Blocking Controls Extraction
On D+4, send an email requesting the blocking controls report.
Recipients:
Note: Blocking controls from EMEA should be extracted manually
3.2. I perform the Blocking Controls Analysis
3.2.1. I prepare a new sheet to copy new information
Access the Blocking Controls Analysis folder in Google Drive, create a new file for the current month, and use the previous month’s file as a template to ensure formulas are copied.
3.2.2. I update the reference data
Update the GAR List: The GAR List must be updated quarterly or whenever there is a change or a new entity.
3.2.3. I adjust the sheet to gather information
Rename the second tab to the month being analyzed, update the date in column B (Month), and clear columns G and H.
3.2.4. I compile the Blocking Controls received
From the files received from APAC, NAM/LAM, and Treasury, copy and paste the BFC codes and corresponding blocking control codes into columns G and H.
3.2.5. I extract manually the EMEA Blocking Controls
Manually extract the EMEA blocking controls by accessing the "Monthly Upload Robot - Blocking Control Extraction - 2024."
Extract the blocking controls for the countries listed in the "Instructions" document.
For each country, find the files for the month being analyzed, and copy and paste the blocking controls and BFC codes.
3.2.6. I do a sanity check
Some BFC codes may not be found. Verify the correct codes in the GAR list if needed.
3.2.7. I remove the Solvay companies
Filter out the ECO companies and delete it from the file to ensure the analysis is performed only for SCO companies.
3.2.8. I ensure data to be analysed is considered
In the "Analyses by Control" tab:
- Clear data from columns I, J, K, L, M, and N starting from row 4 (previous month’s data).
- Copy data from columns B, C, D, E, F, and G from row 4, then paste as values only into columns I, J, K, L, M, and N starting from row 4.
Ensure the values in column O are divided by the last value in column N.
3.2.9. I ensure consistency
In the "Pivot Table" tab, verify that the total in column B matches the total in column N from the "Analyses by Control" tab.
3.3. I update the Dashboard
3.3.1. I access the Dashboard and feeding file
Access the Dashboard and open the file "Dashboard 05_2022 onwards" to find the "Feeding Data" sheet.
3.3.2. I copy information to the feeding file
Copy the columns B, C, D, E, F, G, H, I, J and L from the tab "07.2024" of the file "Blocking Controls Analysis" and paste it as values only into the file "Production BFC - Blocking Control 2020 DataStudio V3.0" in their respective columns.
3.3.3. I verify all information is being correctly considered in all charts
Verify that the current month information is displayed correctly in all charts in the Data Studio dashboard. If not, check the file configuration, data source, and chart parameters.
On page 2, update the "Topic Prioritization" title with the month being analyzed.
End of document.