As requested, I have attached the spreadsheet example to this post to include all formulas. An example of what specifically confuses me is the relationship between cells D2, K2 and R2, however this trend can be observed to occur throughout almost all of the metrics.
Any thoughts are...