I have this scenario here which works because the formulas are set bit by bit, but I was wondering how this could be done using ARRAYFORMULA MAP or something of that nature:

Here is the file for any shot you’d like to give
https://docs.google.com/spreadsheets/d/1gh5w0czg2JuoA3i5wPu8_eOpC4Q4TXIRhmUrg53nKMU/edit?usp=sharing

Appreciate it.