Spreadsheet: 271335d1381916023-dynamic-range-column-reference-sample-sheet
Sheet: Sheet1

Week | Product A | Product B | Product C | Product D |  |  |  |  |  |  |  |  |  | 1
1 | 175.275 | 0.366 | 0.1536 | 8.8608 |  |  |  |  |  |  |  |  |  | 2
2 | 150.925 | 0.15 | 0.0912 | 7.8912 |  |  |  |  |  |  |  |  |  | 3
3 | 148 | 0.117 | 0.24 | 7.1232 |  |  |  |  |  |  |  |  |  | 4
4 | 166.55 | 0.5746165940977263 | 1.420862699564586 | 14.16985389453314 |  |  |  |  |  |  |  |  |  | 5
5 | 156.3 | 0.5616627963231737 | 1.379313788098694 | 14.3016282535075 |  |  |  |  |  |  |  |  |  | 6
6 | 179.525 | 0.5487089985486213 | 1.337764876632801 | 14.43340261248186 |  |  |  |  |  |  |  |  |  | 7
7 | 186.8165013707467 | 0.5357552007740688 | 1.296215965166908 | 14.1888 |  |  |  |  |  |  |  |  |  | 8
8 | 188.2125866795679 | 0.393 | 0 | 14.69695133043057 |  |  |  |  |  |  |  |  |  | 9
9 | 398.178211175617 | 0.9009 | 0 | 31.14032394775036 |  |  |  |  |  |  |  |  |  | 10
10 | 401.1099903241414 | 0.7812 | 1.26 | 27.15552 |  |  |  |  |  |  |  |  |  | 11
11 | 140.05 | 0.276 | 0.7248 | 10.32 |  |  |  |  |  |  |  |  |  | 12
12 | 144.7 | 0.309 | 0.7871999999999999 | 11.4048 |  |  |  |  |  |  |  |  |  | 13
13 | 111.475 | 0.393 | 1.046922496371553 | 14.2272 |  |  |  |  |  |  |  |  |  | 14
14 | 100.5 | 0.441 | 0.2928 | 15.48759748427673 |  |  |  |  |  |  |  |  |  | 15
15 | 96.275 | 0.4321248185776488 | 0 | 15.61937184325109 |  |  |  |  |  |  |  |  |  | 16
16 | 199.3812691501372 | 0.414 | 0 | 15.75114620222545 |  |  |  |  |  |  |  |  |  | 17
17 | 200.7773544589583 | 0.4062172230285439 | 0 | 15.84 |  |  |  |  |  |  |  |  |  | 18
18 | 202.1734397677795 | 0.3932634252539914 | 0 | 16.01469492017416 |  |  |  |  |  |  |  |  |  | 19
19 | 194.15 | 0.3803096274794389 | 0 | 16.14646927914852 |  |  |  |  |  |  |  |  |  | 20
20 | 204.9656103854218 | 0.3673558297048864 | 0 | 16.27824363812288 |  |  |  |  |  |  |  |  |  | 21
21 | 179.95 | 0.3544020319303339 | 0 | 16.41001799709724 |  |  |  |  |  |  |  |  |  | 22
22 | 154.05 | 0.3414482341557814 | 0 | 0 |  |  |  |  |  |  |  |  |  | 23
23 | 186.1 | 0.3284944363812289 | 0 | 0 |  |  |  |  |  |  |  |  |  | 24
24 | 210.5499516207064 | 0.3155406386066764 | 0 | 0 |  |  |  |  |  |  |  |  |  | 25
25 | 178.05 | 0.3025868408321239 | 0 | 16.93711543299468 |  |  |  |  |  |  |  |  |  | 26
26 | 174.925 | 0.2896330430575714 | 0 | 17.06888979196903 |  |  |  |  |  |  |  |  |  | 27
27 | 168.775 | 0.2766792452830189 | 0 | 17.2006641509434 |  |  |  |  |  |  |  |  |  | 28
28 | 216.134292855991 | 0.2637254475084664 | 0 | 17.33243850991775
29 | 217.5303781648122 | 0.2507716497339139 | 0 | 17.46421286889211
30 | 206.95 | 0.2378178519593614 | 0 | 17.59598722786647
31 | 176.45 | 0.108 | 0 | 17.72776158684083
32 | 151.95 | 0 | 0 | 17.85953594581519
33 | 177.375 | 0 | 0 | 17.99131030478955
34 | 191.7 | 0 | 0 | 18.12308466376391
35 | 189.075 | 0 | 0 | 18.25485902273827
36 | 195.7 | 0 | 0 | 18.38663338171263
37 | 203.225 | 0 | 0 | 18.51840774068699
38 | 222.975 | 0 | 0 | 18.65018209966134
39 | 231.4912312530238 | 0 | 0 | 18.7819564586357
40 | 232.887316561845 | 0 | 0 | 18.91373081761006
41 | 234.2834018706661 | 0 | 0 | 19.04550517658442
42 | 306.3833333333334 | 0 | 0 | 69.0048
43 | 308.1982442348009 | 0 | 0 | 56.96639999999999
44 | 310.0131551362684 | 0 | 0 | 63.36000000000001
45 | 239.8677431059507 | 0 | 0 | 14.6976
46 | 241.2638284147719 | 0 | 0 | 14.64
47 | 242.659913723593 | 0 | 0 | 14.2176
48 | 244.0559990324142 | 0 | 0 | 15.5712
49 | 245.4520843412354 | 0 | 0 | 15.4752
50 | 246.8481696500565 | 0 | 0 | 18.624
51 | 248.2442549588777 | 0 | 0 | 20.36324876632801
52 | 161.75 | 0 | 0 | 16.0416
53 | 205.2 | 0 | 0 | 19.3248