How can we emulate Excel calculations with a Matrix Field?

As far as the expense report form, we need to have the matrix calculate how the attached excel sheet performs.

Hello, although the sheet you provided on your screenshot may look straight forward, we still need you to better explain to us what you want to happen with your calculations.

Like, how will the calculations be done, how do you compute for each cell/row/column, and so on.

Bottomline, the more detailed your explanations would be, the better we can assist you in figuring out how to achieve them. Hoping to hear from you soon.