manufacturing | Six Sigma based analysis of manufacturing data

I have a concept below, under the heading 0: BEFORE Requirements Change. This concept shows how FSMs of different products can be created, and how an FSM can run. Only one product's FSM can run on a station/computer at any given time, but one station can allow for multiple products (at different times). For context, this is a manufacturing environment, and there are many products which go through a scanning process. Some products have commonalities in their process, like Product A and B (set up batch for product -> scan a part -> apply business logic -> repeat for multiple parts until batch complete, label printed -> set up next batch...). But other products have different processes, like Product C. Products' processes can also require/include/exclude varying components (different devices, databases, business logic); this is all shown under 0: BEFORE Requirements Change.

Now, say the requirements change (which has happened multiple times in the past), and a new step is needed in-between existing steps for multiple products' FSMs (for example, need to trigger a camera and process the image). Furthermore, this additional step might be just a trial phase, and will need to be disabled. I'll now have to go and change every single FSMCreator, as shown under heading 1: AFTER Requirements Change. When there are many products (ALOT more than 3), big process changes like this have been error-prone and difficult to manage.

Is there a better/cleaner way of organizing the architecture or creating the FSMs, so that this duplication is avoided?

The problem stems from how different FSMs can share some common steps, or have some common components, but are not 100% the same. Essentially, there are many different mixing-and-matching variations of components (devices, databases, business logic), states, and transitions. Ultimately, it is the product's process that defines the FSM, so each product needs to know how to create its FSM. This is why I have a different FSMCreator class for each product, to handle the different processes per product. But as shown, this leads to duplication.

I wish to add subheader and subtotal/margin rows within a table. Ultimately, I am looking for a structure shown below, which I will export to Excel with openxlsx and writeData.

I suspect the subheaders and subtotals are completely different questions, but I am asking both here in case there is a common method related to each.

Create the Sample Data (long format):

df1 is my dataframe of interest, df2 contains additional information I need.

Example:

Please have a look at the reprex at the end of the post. I had a look at

How to set different text and hoverinfo text

https://community.rstudio.com/t/changing-hovertext-in-plotly/71736

But I must be making some mistake. What I would like is to see only the variables "macro_sector" and "amount" when I hover on a bar and no static text on the bar at all. How can I achieve that? Many thanks

They've asked for a dashboard made from JQuery (which I've never used before). Lots of help from W3schools and here in stack has me accomplished 100% of the functionality I need (even if the design could be improved: functionality first polish later!)

One of the bonus is to have some UI /UX functionality, so I've made the divs dragable, and I added the snip below from https://jqueryui.com/resizable/ to make the divs resizable.