Seems like you’ve put a lot of thought into this! Your approach feels very ‘case interview’, haha. Remember real-world data can be messier than case data. So, while your formula is neat, be prepared for some roadblocks and improvisations.