Spreadsheet: 868023d1714732623-expand-table-when-dynamic-range-expands-yoy-growth
Sheet: Transpose Accumulate LY

 |  | GP P1 | GP P2 | GP P3 | GP P4 | GP P5 | GP P6 | GP P7 | GP P8 | GP P9 | GP P10 | GP P11 | GP P12 | GP P13 |  |  | Company 1 | Company 2 | Company 3 | Company 4 | Company 5 | Company 6 | Company 7 | Company 8 | Company 9 | Company 10 | Company 11 | Company 12 | Company 13 | Company 14 | Company 15 | Company 16 | Company 17 | Company 18 | Company 19 | Company 20 | Company 21 | Company 22 | Company 23
 | Company 1 | 370.3 | 111.87 | 10.22 | 54.96000000000001 | 1367.94 | 63.99 | 15.04 | 58.98 | 79.5 | 42.72000000000001 | 21.13 | 126.95 | 26.25 |  | GP P1 | 370.3 | 0 | 2435.380000000001 | 170.47 | 0 | 0 | 0 | 28.35594332999999 | 29.03972869 | 0 | 1056.19 | 158.35 | 0 | 5584.33 | 43.96545354 | 0 | 422.51 | 233.96 | 53.06 | 97.20000000000002 | 0 | 0 | 0
 | Company 2 | 0 | 0 | 0 | 0 | 0 | 0 | 33.15000000000001 | 0 | 0 | 0 | 0 | 0 | 15.49 |  | GP P2 | 111.87 | 0 | 431.44 | 132.41 | 0 | 0 | 0 | 41.65755636 | 363.29423683 | 49.36 | 2035.29 | 222.4 | 0 | 10557.42 | 19.51371639 | 46.14999999999999 | 744.89 | 48.3 | 34.5 | 323.86 | 0.88421025 | 0 | 0
 | Company 3 | 2435.380000000001 | 431.44 | 75.08000000000001 | 131.05 | 33.78 | 103.1 | 171.5599999999999 | 343.91 | 1015.83 | 1147.16 | 49.48999999999999 | 66.97 | 799.84 |  | GP P3 | 10.22 | 0 | 75.08000000000001 | 0 | 0 | 0 | 0 | 36.50560599999999 | 6.7669758 | 315.3 | 1927.12 | 204.62 | 12.94 | 10864.38 | 144.0221022 | 66.72999999999999 | 726.0499999999998 | 0 | 0 | 197.4 | 0 | 0 | 47.61
 | Company 4 | 170.47 | 132.41 | 0 | 53.78 | 76.53 | 99.34 | 183.89 | 51.98 | 108.58 | 222.63 | 75.15 | 308.92 | 202.97 |  | GP P4 | 54.96000000000001 | 0 | 131.05 | 53.78 | 0 | 85.81 | 0 | 42.37601858 | 374.1053240099999 | 630.36 | 1393.78 | 300.18 | 0 | 10250.06 | 40.50702913 | 9.87 | 591.3599999999999 | 0 | 20.59 | 258.88 | 0 | 0 | 131.56
 | Company 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | GP P5 | 1367.94 | 0 | 33.78 | 76.53 | 0 | 0 | 0 | 52.41064413000002 | 80.38845999 | 80.96 | 2230.41 | 154.23 | 0 | 7408.150000000001 | 40.84027129 | 0 | 985.8699999999999 | 41.89 | 0 | 227.27 | 0 | 0 | 0
 | Company 6 | 0 | 0 | 0 | 85.81 | 0 | 0 | 150.76 | 0 | 0 | 0 | 0 | 0 | 0 |  | GP P6 | 63.99 | 0 | 103.1 | 99.34 | 0 | 0 | 0 | 69.00490653 | 5.99871453 | 53.71 | 1012.66 | 859.3100000000001 | 92.52 | 11924.83000000001 | 21.36960012 | 12.66 | 1227.22 | 46.45 | 76.11 | 137.97 | 0 | 0 | 0
 | Company 7 | 0 | 0 | 0 | 0 | 0 | 0 | 395.3299999999999 | 0 | 454.36 | 0 | 179.2 | 3511.16 | 772.6899999999999 |  | GP P7 | 15.04 | 33.15000000000001 | 171.5599999999999 | 183.89 | 0 | 150.76 | 395.3299999999999 | 32.048676 | 24.3024292 | 283.7 | 1887.71 | 308.01 | 119.81 | 11281.11 | 36.6409758 | 0 | 709.0699999999999 | 77.69 | 0 | 192.1 | 0 | 0 | 747.5600000000001
 | Company 8 | 28.35594332999999 | 41.65755636 | 36.50560599999999 | 42.37601858 | 52.41064413000002 | 69.00490653 | 32.048676 | 51.33710826 | 57.88145033999999 | 56.60082219999999 | 35.06784665999999 | 60.99449379999999 | 35.03772629999999 |  | GP P8 | 58.98 | 0 | 343.91 | 51.98 | 0 | 0 | 0 | 51.33710826 | 42.67773820000001 | 0 | 2207.44 | 401.1799999999999 | 0 | 11592.28 | 116.88894216 | 0 | 1013.66 | 0 | 72.78999999999999 | 112.15 | 0 | 0 | 62.16
 | Company 9 | 29.03972869 | 363.29423683 | 6.7669758 | 374.1053240099999 | 80.38845999 | 5.99871453 | 24.3024292 | 42.67773820000001 | 19.93988066 | 5.219839299999999 | 118.13938844 | 108.63110308 | 6.762521649999999 |  | GP P9 | 79.5 | 0 | 1015.83 | 108.58 | 0 | 0 | 454.36 | 57.88145033999999 | 19.93988066 | 430.67 | 965.5 | 235.62 | 187.1 | 10148.5 | 87.66331712 | 0 | 1360.45 | 0 | 1278.32 | 76.2 | 0 | 0 | 257.42
 | Company 10 | 0 | 49.36 | 315.3 | 630.36 | 80.96 | 53.71 | 283.7 | 0 | 430.67 | 0 | 25.66 | 91.6 | 358.0300000000001 |  | GP P10 | 42.72000000000001 | 0 | 1147.16 | 222.63 | 0 | 0 | 0 | 56.60082219999999 | 5.219839299999999 | 0 | 679.3600000000001 | 94.33 | 2223.97 | 6127.35 | 53.59507009999999 | 0 | 756.8 | 0 | 95.03999999999999 | 80.32000000000001 | 0 | 0 | 624.9200000000001
 | Company 11 | 1056.19 | 2035.29 | 1927.12 | 1393.78 | 2230.41 | 1012.66 | 1887.71 | 2207.44 | 965.5 | 679.3600000000001 | 796.8 | 942.32 | 1734.46 |  | GP P11 | 21.13 | 0 | 49.48999999999999 | 75.15 | 0 | 0 | 179.2 | 35.06784665999999 | 118.13938844 | 25.66 | 796.8 | 155.89 | 1340.24 | 7254.637212440003 | 22.85857662 | 0 | 763.0500000000002 | 0 | 0 | 50.53999999999999 | 0 | 0 | 95.54
 | Company 12 | 158.35 | 222.4 | 204.62 | 300.18 | 154.23 | 859.3100000000001 | 308.01 | 401.1799999999999 | 235.62 | 94.33 | 155.89 | 433.0699999999999 | 494.9999999999999 |  | GP P12 | 126.95 | 0 | 66.97 | 308.92 | 0 | 0 | 3511.16 | 60.99449379999999 | 108.63110308 | 91.6 | 942.32 | 433.0699999999999 | 33.8 | 7976.639999999999 | 68.61835663999999 | 0 | 1069.72 | 89.22 | 107.17 | 71.28999999999999 | 0 | 22.41 | 0
 | Company 13 | 0 | 0 | 12.94 | 0 | 0 | 92.52 | 119.81 | 0 | 187.1 | 2223.97 | 1340.24 | 33.8 | 313.12 |  | GP P13 | 26.25 | 15.49 | 799.84 | 202.97 | 0 | 0 | 772.6899999999999 | 35.03772629999999 | 6.762521649999999 | 358.0300000000001 | 1734.46 | 494.9999999999999 | 313.12 | 11451.8 | 292.2374081 | 0 | 1575.14 | 95.86 | 0 | 144.2 | 0 | 23.53 | 46.33
 | Company 14 | 5584.33 | 10557.42 | 10864.38 | 10250.06 | 7408.150000000001 | 11924.83000000001 | 11281.11 | 11592.28 | 10148.5 | 6127.35 | 7254.637212440003 | 7976.639999999999 | 11451.8
 | Company 15 | 43.96545354 | 19.51371639 | 144.0221022 | 40.50702913 | 40.84027129 | 21.36960012 | 36.6409758 | 116.88894216 | 87.66331712 | 53.59507009999999 | 22.85857662 | 68.61835663999999 | 292.2374081
 | Company 16 | 0 | 46.14999999999999 | 66.72999999999999 | 9.87 | 0 | 12.66 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Company 17 | 422.51 | 744.89 | 726.0499999999998 | 591.3599999999999 | 985.8699999999999 | 1227.22 | 709.0699999999999 | 1013.66 | 1360.45 | 756.8 | 763.0500000000002 | 1069.72 | 1575.14
 | Company 18 | 233.96 | 48.3 | 0 | 0 | 41.89 | 46.45 | 77.69 | 0 | 0 | 0 | 0 | 89.22 | 95.86
 | Company 19 | 53.06 | 34.5 | 0 | 20.59 | 0 | 76.11 | 0 | 72.78999999999999 | 1278.32 | 95.03999999999999 | 0 | 107.17 | 0
 | Company 20 | 97.20000000000002 | 323.86 | 197.4 | 258.88 | 227.27 | 137.97 | 192.1 | 112.15 | 76.2 | 80.32000000000001 | 50.53999999999999 | 71.28999999999999 | 144.2
 | Company 21 | 0 | 0.88421025 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Company 22 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22.41 | 23.53
 | Company 23 | 0 | 0 | 47.61 | 131.56 | 0 | 0 | 747.5600000000001 | 62.16 | 257.42 | 624.9200000000001 | 95.54 | 0 | 46.33