I cannot share the workflow. I only do this for specific situations, and each would be different, hence for the screenshot, I quickly changed a couple of things where client data was in the screenshot range, took the screenshot, then closed the workflow without saving. To change the whole thing to be sharable, would be effort that I don't see as necessary.
You are not going to execute Excel formulas in Alteryx! That would be ridiculous.
So, you have an excel worksheet that does work, and you want to replicate that in Alteryx... I think you're looking for an automatic solution, where in reality any solution is going to require work. Excel formulas can be terrible to work with and require huge formulas for small things... I wouldn't be preserving that.
I had a play with your sample, and half the time I spent was figuring out the data and structure (middle section having fixed amounts for instance), which you would already know. In order to keep it in your report format, it gets more complicated than it needs to, but still not that bad. There's a few touch-ups still needed on this, but the key was working out the structure.
To go from scratch, I would trim it down to just the data, label each section and then generate the totals. I would also make sure I could transpose/Sum instead of a formula that adds together 6 columns (good practice in rigid back-end data, bad practice in BI-level data that is more likely to just have an extra currency added. This is a carryover from Excel where it's the only option).
