Multi-dependent dropdown lists

mathetes My understanding of the formula in column H, found on the Relative intensity chart sheet, is that it filters the large table 1 for each variable (intent, reps, percentage, and volume) until the outcome "sets" is the only possible answer. I have attached the chart (you can ignore the colors), but it is basically a combination of two charts: Relative intensity chart and the prilepin chart. The prilepin chart specifically outputs the two variables "volume" and "sets", whereas the relative intensity chart deals with "intent", "reps" and "percentages". This was the only way I could see to get the exact combinations to output, very similar actually, to the formula present in your initial example. 

It should be noted before I continue that this speadsheet is more or less a home for these formulae and dropdownlists, rather than an actual example of a programming template, or team dashboard for programming. Both of those vary by coach, organization, team, and/or program, which I think speaks to the need for this to be something easily duplicated and manipulated into their individual templates. For example, one coach may have a completely vertical format for their programs, sticking with columns D-H for 90 rows, while another coach may alternate left/right for their exercise programming using D-H and O-S alternatingly, with 50 rows instead. 

My idea is that for a team-based template, a coach would create his program with the intent, reps, and % as permanent factors for that microcycle (day/week of training), with the variables left open being volume choice (Low, Optimal, or High in most cases), and the calculated total sets based on aforementioned factors, for the individualization/personalization aspect of training. Most sport strength coaches tend to execute their programs based on some form of the high-low model combined with their preference other miscellaneous models. The high-low model basically says that game day volume is maximal or "high". To prepare for this volume you must incorporate other "high" days throughout the week/s leading to competition, but obviously someone cannot just operate on "high" volume day in and day out. So there must be an alternation of "medium" days, "low" days, followed by "high" days, generally in that pattern. This changes depending on the frequency of games/week but generally for volume management's sake, we try to limit game day intensities to 3-ish days per week in season if we can help it. Again, all dependent on the demands of sport, practice, and the athlete's training age, etc. Because this varies from starters, to bench players, to the injured, from seniors to freshmen, I would like this to be variable per athlete ideally, so someone accumulating a ton of gametime during a week can take on LOW volume and by association low sets, while someone who hasn't played in weeks or all season can take on HIGH volume and by association high sets, to replicate the high, gamespeed stress levels on their body and CNS, of their starting teammates, so they are less likely to be injured playing at that speed randomly throughout the season. I hope this makes sense... Otherwise some coaches perform readiness questionnaires rather than looking at physical data to determine High, Low, Optimal for volume, but that is generally private sector training like personal trainers which would be less likely to use something like this since they already make everything personalized. My hope is this will bring more individualization to the collegiate and professional strength training world, rather than everyone blindly operating on the same program because they lack a practical means of adjusting volume on the fly on a daily basis. 

If any other questions let me know I hope this was helpful!