This week we kept on working on the module to create a workbook with all the product from byggvarubedomningen per category and their respective value per component.
Unfortunately, while doing so, as we are re-using parts of a previous module to extract a list of all the component, we realized that some of the data were not process correctly. Indeed some component and some products were kept while they should have been removed and some were removed while they should have been kept. Therefore we decided to rewind our work, re-design the module for the component and process again the data.
The newly designed module will now :
- Select all the component per category and their values for each form
- Convert the values to a single number by removing other kind of characters and making the average of intervals.
- Make sure that the obtained numbers are sharing the same unit : percentage (%)
- Remove product forms for which we know less than 50% of their components
- Remove component that when we add all of their occurrences their values equal 0