Spreadsheet: 83158d1283204936-applying-formula-repeatedly-to-blocks-of-cells-forum-1-
Sheet: Sheet1

Input | Output | Row -1 | Build Indirect | Average of indirect |  | Working area to build formula
3.186 | 12.30259499999999 | 1 | A2:A201 | 12.30259499999999 |  | 1 | 2 | 201
5.323 | 203.617 | 2 | A202:A401 | 9.783505000000002 |  | 2 | 202 | 401
3.287 | 501.5 | 3 | A402:A601 | 5.957924999999998 |  | 3 | 402 | 601
2.442 |  | 4 | A602:A801 | 13.7104 |  | 4 | 602 | 801
3.15 |  |  |  |  |  | 5 | 802 | 1001
5.266 |  |  |  |  |  | 6
3.754 |  |  |  |  |  | x | 200(x-1)+2 | X times 200 +1
2.598
3.153
3.097
4.452
2.524
5.191
7.956
7.71
2.391
3.361
7.704
25.743
25.302
22.009
10.364
55.033
269.414
269.637
3.765
5.317
3.916
2.93
4.708
3.11
2.814
2.692
3.317
5.036
5.575
3.939
3.658
2.99
6.053
2.633
2.622
2.597
2.281
2.7
4.34
2.954
4.551
2.542
4.521
5.785
4.26
3.173
9.309
9.877
2.995
4.589
2.91
2.539
3.901
5.02
3.256
3.274
5.881
2.471
3.956
2.732
4.451
6.101
3.156
4.249
6.116
3.072
5.739
2.494
4.962
5.489
4.833
2.96
6.812
2.63
5.829
304.162
2.755
4.981
2.777
4.484
3.5
6.408
3.148
3.544
3.98
6.203
2.631
5.156
5.866
6.328
5.469
3.229
2.731
4.736
2.608
4.237
3.532
3.243
2.636
2.703
3.814
8.355
13.598
5.755
2.498
3.835
5.682
3.136
4.726
2.727
5.099
3.411
3.491
2.866
4.451
5.943
130.135
130.356
5.623
5.29
6.168
21.618
21.809
6.273
3.161
5.273
2.993
5.445
6.263
7.831
5.398
7.184
2.691
4.663
5.34
6.523
3.529
5.292
2.49
3.998
3.185
6
8.093
2.745
3.852
2.591
2.603
2.688
2.931
5.798
8.597
9.016
3.101
5.04
3.259
3.864
10.848
21.476
20.076
2.788
5.293
5.903
8.639
2.649
4.435
2.626
3.99
2.576
4.437
2.728
4.536
2.653
4.114
3.071
5.168
15.24
18.404
2.644
4.066
3.21
4.062
6.756
2.638
4.222
8.519
297.403
2.906
2.798
3.047
4.544
2.764
4.533
5.185
6.234
3.222
3.359
4.357
4.779
4.047
4.859
6.788
7.9
13.657
32.193
32.039
32.509
17.039
22.818
6.162
52.079
55.166
67.527
43.11
42.856
46.544
9.938
30.426
29.579
47.755
48.2
5.537
5.516
6.122
6.201
5.468
7.455
2.669
3.881
4.026
5.956
3.062
5.026
6.776
6.6
7.01
9.892
2.561
3.085
5.68
5.326
8.126
4.426
7.246
5.523
6.583
3.599
3.113
5.009
2.875
4.42
2.509
4.078
3.326
5.489
3.672
6.289
5.825
136.363
136.617
83.649
74.685
6.656
6.981
6.606
2.84
4.195
8.847
2.917
4.566
3.486
3.515
2.845
4.727
3.501
5.007
3.778
4.538
3.58
3.732
5.619
3.438
2.993
4.902
5.11
8.355
8.507
4.902
6.357
3.517
3.982
4.78
14.519
15.304
3.565
7.538
3.186
6.248
3.339
5.064
5.862
2.763
4.584
2.85
4.787
3.585
5.983
3.499
6.389
3.438
4.77
3.825
2.82
4.618
2.855
6.119
3.673
7.179
7.681
8.379
7.805
3.266
4.681
2.802
5.227
3.329
5.568
2.643
4.919
5.24
2.845
5.165
3.134
2.974
5.805
2.89
5.088
2.972
5.244
2.923
4.877
2.729
4.445
2.637
4.316
2.699
5.298
6.004
9.581
8.208
17.192
4.671
5.352
6.27
2.96
4.995
3.246
5.488
3.459
5.156
2.629
4.032
2.645
4.996
2.711
4.867
4.16
6.369
5.457
9.005
3.727
5.765
3.152
5.309
5.513
6.187
2.492
3.687
2.738
4.466
2.435
2.63
3.942
5.258
12.587
5.808
2.487
2.775
5.129
2.926
3.671
10.495
11.21
5.724
6.821
4.635
6.568
3.539
3.529
2.517
4.957
5.248
2.708
4.262
3.447
4.807
2.205
3.037
2.547
3.228
4.945
3.211
4.414
2.642
4.475
2.983
4.765
3.245
5.634
9.579
2.629
4.43
2.731
4.348
2.488
2.764
3.208
2.315
4.618
7.187
7.181
3.136
5.074
3.789
5.312
2.959
5.346
5.602
6.386
6.405
6.847
8.13
9.364
3.833
7.412
3.661
2.838
5.415
4.223
6.445
5.587
3.241
3.339
5.039
3.398
2.659
5.906
6.805
2.889
5.109
8.563
2.958
2.999
4.071
4.33
4.337
7.392
6.327
5.729
9.163
2.536
2.833
5.331
2.934
2.651
4.942
3.766
2.72
4.291
3.318
35.398
37.47
2.459
3.867
2.995
4.524
5.085
4.442
9.479
3.591
2.799
4.567
90.449
93.427
2.846
4.4
8.27
7.63
7.48
10.923
8.368
8.391
2.844
4.55
2.953
3.119
4.654
4.039
3.319
5.084
3.873
5.853
8.686
8.976
2.897
3.864
2.583
4.711
3.352
4.308
2.8
2.876
5.186
4.373
2.848
4.538
2.69
4.139
4.352
3.114
2.562
4.644
3.208
2.67
4.067
3.199
3.112
4.184
4.793
4.126
7.573
12.526
12.136
2.93
4.166
2.915
3.619
4.749
2.545
2.638
4.122
3.122
3.397
6.061
3.853
5.116
3.053
4.804
3.591
8.339
2.873
3.411
6.429
2.936
4.435
4.729
5.965
2.572
3.317
5.471
7.548
8.162
2.933
5.119
2.841
4.216
11.95
11.626
12.213
2.489
2.356
2.978
2.565
2.708
2.651
3.301
2.781
2.631
2.514
7.21
18.898
19.148
3.699
2.462
3.198
5.478
2.692
6.039
6.039
6.696
2.805
2.696
3.181
3.394
3.778
2.99
4.235
4.642
2.716
5.635
2.787
2.868
3.779
2.776
7.916
7.428
4.525
3.155
3.734
2.687
4.349
4.511
3.143
2.59
2.861
3.194
3.81
4.129
4.528
4.29
2.707
3.362
2.464
2.833
2.949
3.282
2.722
3.052
3.168
4.613
3.126
6.433
2.859
4.71
3.008
3.076
5.002
4.942
2.537
3.011
2.667
2.786
2.612
3.31
3.505
2.975
3.732
3.024
3.659
3.436
3.635
3.907
3.246
3.131
4.976
2.84
3.336
9.123
12.795
2.823
4.258
5.025
58.794
58.958
5.58
10.311
10.349
5.654
9.939
4.101
8.509
10.157
3.12
3.225
12.838
2.792
4.363
2.472
4.397
2.85
4.396
4.12
4.426
4.799
6.656
2.724
2.617
3.458
6.7
8.638
5.38
3.48
2.587
3.913
3.207
206.41
207.838
2.415
7.468
33.208
33.772
403.412
2.875
4.082
2.767
4.811
2.901
3.716
8.724
80.063
13.711
23.363
8.535
2.764
2.287
2.829
4.73
3.317
7.148
3.099
2.453
2.947
4.135
2.549
6.63
3.119
2.599
2.819
2.613
5.017
6.668
6.488
3.775
2.772
4.974
3.178
2.639
8.193
3.532
6.596
10.073
8.591
31.382
31.379
398.077
250.499
4.655
6.335
4.554
6.222
15.266
15.53
37.936
9.479
6.806
3.261
3.688
3.806
4.083
3.098
5.443
3.342
2.53
4.187
2.57
3.727
2.791
4.689
2.961
3.714
3.155
44.526
5.792
5.548
5.376
7.002
3.176
2.931
3.26
3.867
2.523
3.565
6.6
2.703
3.073
2.618
4.749
5.355
2.621
2.602
3.005
8.639
2.753
3.167
3.546
24.542
28.147
10.933
11.398
11.323
5.68
4.779
7.885
2.805
4.973
6.32
2.999
6.146
3.183
4.593
3.974
5.719
2.5
4.574
3.133
4.271
2.867
9.642
5.95
11.749
30.336
2.544
2.861
2.802
3.241
5.86
6.74
2.933
2.728
3.308
2.598
4.481
3.281
3.766
2.77
2.431
3.892
3.024
5.235
5.812
9.005
8.942
9.264
8.935
5.006
9.348
11.058
3.656
3.12
6.389
41.806
2.878
7.203
7.472
7.414
8.896
9.385
9.604
14.179
2.709
4.082
9.534
3.947
4.315
7.098
7.16
6.996
3.34
2.308
2.661
3.477
10.124
20.144
2.763
78.835
2.72
67.524
7.5
6.551
3.666
4.621
6.929
2.767
4.068
3.842
2.613
5.9
6.253
4.262
5.754
2.319
3.612
3.993
5.444
2.544
3.885
3.887
6.813
9.191
4.545
118.514
591.237
482.368
2.48
3.381
3.527
2.796
2.663
2.933
4.058
2.58
2.785
2.785
3.461
5.303
8.33
3.676
2.661
2.803
3.605
2.883
3.022
2.546
3.756
3.438
7.66
2.545
2.986
2.688
2.657
4.311
4.572
3.834
2.843
22.668
14.472
16.412
86.572
87.727
4.806
4.33
3.107
5.443
2.352
3.794
3.737
5.011
5.94
3.494
4.396
4.996
5.02
6.63
5.017
4.011
5.688
2.966
4.94
3.643
7.13
3.281
15.15
8.839
18.042
18.389
2.702
4.834
5.279
5.573
413.533
3.498
2.946
2.994
2.866
4.397
2.526
3.274
3.399
2.837
3.638
2.75
6.619
5.648
2.733