Challenge #142: Life Certainties - Workflows, Death, and Taxes

[NatSnook]

This one gave me a headache! think i started out in the wrong direction and took a very long route around

[kelly_gilbert]

Workflow attached for both the easy way and hard way. My solutions for both are pretty similar to others up-thread!

Spoiler

Easy way workflow:

Spoiler

For the "hard way," I appended the whole tax table to each employee row, then filtered and summarized to pick the appropriate bracket.

After looking through some of the other soutions, I learned about the Dynamic Replace tool. I had never heard of that tool before, so that will be pretty useful in the future!

Hard way workflow:



Hard way macro:

[CamodCPA]

Spoiler

The first weekly challenge I was able to complete in full! Took a few hours, but, Practice makes perfect! 

I have some more detail in my final answer as I don't want to ignore some "taxing" variables.

I know I can clean up the workflow a little, so if anyone has some suggestions, leave a reply!

Cheers,

Cameron

[paul_f]

Enjoyed this one

Spoiler

[AndyLi]

My first weekly challenge, not a very elegant solution but it works. 

[ebarrus]

Took the "easy" route this time around

[Wouter]

My solution (easy path though):

Spoiler

[cadyb]

I took the easy and slightly longer road! Made of the Total Column in Cross Tab to finish it off!

[jasperlch]

Solution attached.