Spreadsheet: 117070d1312425014-summing-specific-non-zero-rows-in-a-table-sample
Sheet: Investments

 |  |  | Fixed
RAND |  | Case | Length ([NAME]) | Investment | Success | Pot. Payout | Act. Payout
 |  | 1 | 8 | 4313 | Strong | 17252 | 12076.4
 |  |  | 11 | 1341 | Moderate | 5364 | 2032.956
 |  |  | 11 | 4588 | Moderate | 18352 | 7198.572
 |  |  | 8 | 3828 | Strong | 15312 | 8597.688
 |  |  | 11 | 1260 | Moderate | 5040 | 2358.72
 |  |  | 8 | 5234 | Strong | 20936 | 15424.598
 |  |  | 12 | 3757 | Strong | 15028 | 11237.187
 |  |  | 11 | 1019 | Poor | 4076 | 950.7270000000001
 |  |  | 7 | 5227 | Poor | 20908 | 5692.203
 |  |  | 12 | 1006 | Fail | 4024 | 0
 |  |  | 9 | 4028 | Fail | 16112 | 0
 |  |  | 9 | 4124 | Strong | 16496 | 9126.412
 |  |  | 11 | 5086 | Moderate | 20344 | 8407.158
 |  |  | 8 | 3728 | Strong | 14912 | 10725.456
 |  |  | 11 | 5204 | Strong | 20816 | 11833.896
 |  |  | 8 | 2723 | Poor | 10892 | 2750.23
 |  |  | 8 | 2808 | Fail | 11232 | 0
 |  |  | 9 | 2995 | Moderate | 11980 | 3405.315
 |  |  | 8 | 2527 | Strong | 10108 | 7356.097
 |  |  | 7 | 4094 | Moderate | 16376 | 5223.944
 |  |  | 9 | 5835 | Fail | 23340 | 0
 |  |  | 11 | 4277 | Strong | 17108 | 11385.374
 |  |  | 6 | 5081 | Moderate | 20324 | 9562.442
 |  |  | 12 | 2059 | Poor | 8236 | 2248.428
 |  |  | 6 | 2254 | Fail | 9016 | 0
 |  |  | 10 | 2759 | Moderate | 11036 | 3501.171
 |  |  | 6 | 5016 | Moderate | 20064 | 5572.776
 |  |  | 8 | 4697 | Moderate | 18788 | 7928.536
 |  |  | 7 | 2870 | Moderate | 11480 | 5197.57
 |  |  | 9 | 4480 | Strong | 17920 | 13184.64
 |  |  | 11 | 2519 | Strong | 10076 | 6962.516
 |  |  | 7 | 5509 | Moderate | 22036 | 7707.091
 |  |  | 7 | 1535 | Fail | 6140 | 0
 |  |  | 11 | 5380 | Moderate | 21520 | 8344.38
 |  |  | 10 | 2448 | Fail | 9792 | 0
 |  |  | 11 | 4579 | Strong | 18316 | 9167.158
 |  |  | 9 | 2722 | Strong | 10888 | 7284.072
 |  |  | 11 | 3550 | Moderate | 14200 | 5683.55
 |  |  | 8 | 3680 | Fail | 14720 | 0
 |  |  | 11 | 5129 | Strong | 20516 | 13181.53
 |  |  | 10 | 1112 | Strong | 4448 | 3189.216
 |  |  | 8 | 3338 | Fail | 13352 | 0
 |  |  | 10 | 5476 | Strong | 21904 | 12173.148
 |  |  | 6 | 4186 | Fail | 16744 | 0
 |  |  | 11 | 5594 | Strong | 22376 | 12586.5
 |  |  | 7 | 2131 | Fail | 8524 | 0
 |  |  | 10 | 2686 | Fail | 10744 | 0
 |  |  | 8 | 1399 | Fail | 5596 | 0
 |  |  | 9 | 1087 | Fail | 4348 | 0
 |  |  | 11 | 3417 | Moderate | 13668 | 4178.991
 |  |  | 6 | 5790 | Strong | 23160 | 14081.28
 |  |  | 11 | 2582 | Strong | 10328 | 6514.386
 |  |  | 6 | 1670 | Moderate | 6680 | 2192.71
 |  |  | 9 | 5150 | Strong | 20600 | 13590.85
 |  |  | 8 | 5371 | Fail | 21484 | 0
 |  |  | 6 | 1720 | Fail | 6880 | 0
 |  |  | 9 | 3212 | Strong | 12848 | 9205.592
 |  |  | 11 | 2458 | Strong | 9832 | 5198.67
 |  |  | 6 | 2429 | Fail | 9716 | 0
 |  |  | 8 | 4107 | Fail | 16428 | 0
 |  |  | 8 | 2566 | Strong | 10264 | 5855.612
 |  |  | 12 | 3726 | Moderate | 14904 | 5719.41
 |  |  | 6 | 4380 | Moderate | 17520 | 5987.46
 |  |  | 9 | 1718 | Strong | 6872 | 4044.172
 |  |  | 9 | 2505 | Fail | 10020 | 0
 |  |  | 12 | 3193 | Strong | 12772 | 6539.264
 |  |  | 8 | 3181 | Strong | 12724 | 8874.99
 |  |  | 7 | 5911 | Moderate | 23644 | 9587.642
 |  |  | 10 | 4473 | Strong | 17892 | 12224.709
 |  |  | 11 | 5064 | Strong | 20256 | 10264.728
 |  |  | 7 | 2291 | Strong | 9164 | 6417.091
 |  |  | 7 | 2882 | Moderate | 11528 | 3227.84
 |  |  | 12 | 5073 | Fail | 20292 | 0
 |  |  | 8 | 1334 | Moderate | 5336 | 1938.302
 |  |  | 12 | 2123 | Fail | 8492 | 0
 |  |  | 7 | 3031 | Moderate | 12124 | 5555.823
 |  |  | 11 | 1036 | Poor | 4144 | 847.448
 |  |  | 9 | 4137 | Moderate | 16548 | 7070.133000000001
 |  |  | 9 | 1290 | Fail | 5160 | 0
 |  |  | 12 | 1218 | Fail | 4872 | 0
 |  |  | 8 | 3722 | Strong | 14888 | 10883.128
 |  |  | 11 | 1729 | Moderate | 6916 | 2562.378
 |  |  | 8 | 1743 | Moderate | 6972 | 2495.976
 |  |  | 7 | 2709 | Fail | 10836 | 0
 |  |  | 11 | 2145 | Fail | 8580 | 0
 |  |  | 8 | 5254 | Poor | 21016 | 5227.73
 |  |  | 7 | 1196 | Fail | 4784 | 0
 |  |  | 9 | 1737 | Strong | 6948 | 3805.767
 |  |  | 8 | 2228 | Strong | 8912 | 5746.012000000001
 |  |  | 8 | 3870 | Strong | 15480 | 9868.5
 |  |  | 7 | 5230 | Moderate | 20920 | 7787.47
 |  |  | 9 | 2126 | Fail | 8504 | 0
 |  |  | 10 | 1345 | Strong | 5380 | 3139.23
 |  |  | 11 | 1996 | Strong | 7984 | 5049.879999999999
 |  |  | 8 | 5694 | Strong | 22776 | 16119.714
 |  |  | 8 | 1568 | Fail | 6272 | 0
 |  |  | 10 | 4970 | Moderate | 19880 | 8140.86
 |  |  | 6 | 4422 | Moderate | 17688 | 8596.368
 |  |  | 6 | 2402 | Fail | 9608 | 0
 |  |  | 9 | 3595 | Moderate | 14380 | 6657.940000000001
 |  |  | 8 | 3099 | Moderate | 12396 | 4642.302
 |  |  | 12 | 5643 | Fail | 22572 | 0
 |  |  | 9 | 5166 | Moderate | 20664 | 8172.612
 |  |  | 9 | 4367 | Strong | 17468 | 11742.863
 |  |  | 6 | 5228 | Strong | 20912 | 14037.18
 |  |  | 9 | 4914 | Strong | 19656 | 13803.426
 |  |  | 6 | 2659 | Fail | 10636 | 0
 |  |  | 7 | 3335 | Poor | 13340 | 2698.015
 |  |  | 12 | 5476 | Fail | 21904 | 0
 |  |  | 7 | 3498 | Strong | 13992 | 9105.294
 |  |  | 6 | 2595 | Strong | 10380 | 7707.150000000001
 |  |  | 8 | 2387 | Fail | 9548 | 0
 |  |  | 6 | 5278 | Fail | 21112 | 0
 |  |  | 10 | 1462 | Strong | 5848 | 4155.004
 |  |  | 12 | 4991 | Fail | 19964 | 0
 |  |  | 9 | 2361 | Moderate | 9444 | 4150.638
 |  |  | 7 | 4494 | Moderate | 17976 | 6691.566000000001
 |  |  | 10 | 3069 | Moderate | 12276 | 5631.615
 |  |  | 6 | 4847 | Fail | 19388 | 0
 |  |  | 8 | 4243 | Poor | 16972 | 4344.832
 |  |  | 11 | 3651 | Fail | 14604 | 0
 |  |  | 11 | 1798 | Strong | 7192 | 3901.66
 |  |  | 11 | 4042 | Strong | 16168 | 9070.248000000001
 |  |  | 6 | 4229 | Poor | 16916 | 4482.74
 |  |  | 11 | 1860 | Strong | 7440 | 3746.04
 |  |  | 7 | 1071 | Strong | 4284 | 3163.734
 |  |  | 10 | 2777 | Poor | 11108 | 2685.359
 |  |  | 10 | 2771 | Moderate | 11084 | 4203.607
 |  |  | 8 | 5867 | Fail | 23468 | 0
 |  |  | 11 | 1444 | Strong | 5776 | 3716.856
 |  |  | 7 | 2270 | Fail | 9080 | 0
 |  |  | 6 | 5188 | Moderate | 20752 | 6127.028
 |  |  | 7 | 1007 | Fail | 4028 | 0
 |  |  | 12 | 3990 | Strong | 15960 | 11247.81
 |  |  | 10 | 4492 | Fail | 17968 | 0
 |  |  | 10 | 1768 | Moderate | 7072 | 2457.52
 |  |  | 11 | 2593 | Fail | 10372 | 0
 |  |  | 7 | 1224 | Fail | 4896 | 0
 |  |  | 6 | 1971 | Fail | 7884 | 0
 |  |  | 6 | 3251 | Strong | 13004 | 7278.989
 |  |  | 11 | 4946 | Fail | 19784 | 0
 |  |  | 11 | 1209 | Fail | 4836 | 0
 |  |  | 7 | 5737 | Moderate | 22948 | 9402.943
 |  |  | 11 | 1084 | Poor | 4336 | 972.3480000000001
 |  |  | 8 | 1539 | Fail | 6156 | 0
 |  |  | 12 | 2191 | Fail | 8764 | 0
 |  |  | 8 | 2422 | Strong | 9688 | 6110.706
 |  |  | 7 | 5575 | Strong | 22300 | 14372.35
 |  |  | 9 | 2644 | Fail | 10576 | 0
 |  |  | 6 | 5182 | Fail | 20728 | 0
 |  |  | 8 | 2607 | Poor | 10428 | 2155.989
 |  |  | 11 | 1048 | Moderate | 4192 | 1816.184
 |  |  | 10 | 1116 | Strong | 4464 | 3278.808
 |  |  | 12 | 1650 | Poor | 6600 | 1755.6
 |  |  | 11 | 2356 | Fail | 9424 | 0
 |  |  | 12 | 1728 | Moderate | 6912 | 2721.6
 |  |  | 10 | 5067 | Poor | 20268 | 5528.097
 |  |  | 7 | 4531 | Moderate | 18124 | 7906.595
 |  |  | 12 | 1569 | Strong | 6276 | 3235.278
 |  |  | 6 | 4337 | Moderate | 17348 | 5828.928000000001
 |  |  | 7 | 4994 | Strong | 19976 | 13743.488
 |  |  | 6 | 1049 | Fail | 4196 | 0
 |  |  | 12 | 2980 | Strong | 11920 | 7256.3
 |  |  | 7 | 2442 | Fail | 9768 | 0
 |  |  | 6 | 4306 | Fail | 17224 | 0
 |  |  | 10 | 5617 | Moderate | 22468 | 6841.505999999999
 |  |  | 10 | 3796 | Fail | 15184 | 0
 |  |  | 10 | 5793 | Fail | 23172 | 0
 |  |  | 6 | 1168 | Strong | 4672 | 2783.344
 |  |  | 9 | 5316 | Strong | 21264 | 12630.816
 |  |  | 7 | 2517 | Strong | 10068 | 5172.435
 |  |  | 8 | 2553 | Strong | 10212 | 7127.976
 |  |  | 8 | 2003 | Strong | 8012 | 5506.247
 |  |  | 6 | 3674 | Fail | 14696 | 0
 |  |  | 12 | 5317 | Moderate | 21268 | 7651.163
 |  |  | 9 | 5284 | Fail | 21136 | 0
 |  |  | 8 | 3871 | Moderate | 15484 | 6317.472
 |  |  | 7 | 3458 | Moderate | 13832 | 6563.284
 |  |  | 11 | 2397 | Fail | 9588 | 0
 |  |  | 8 | 2734 | Moderate | 10936 | 4735.288
 |  |  | 8 | 3695 | Strong | 14780 | 9001.02
 |  |  | 11 | 5844 | Strong | 23376 | 14855.448
 |  |  | 9 | 5491 | Strong | 21964 | 13161.927
 |  |  | 6 | 5564 | Poor | 22256 | 5897.84
 |  |  | 11 | 4764 | Fail | 19056 | 0
 |  |  | 7 | 2829 | Fail | 11316 | 0
 |  |  | 8 | 1416 | Strong | 5664 | 3463.536
 |  |  | 12 | 4934 | Moderate | 19736 | 9221.646
 |  |  | 7 | 5581 | Strong | 22324 | 12618.641
 |  |  | 12 | 4530 | Strong | 18120 | 13032.81
 |  |  | 9 | 3753 | Poor | 15012 | 3644.163
 |  |  | 6 | 4793 | Fail | 19172 | 0
 |  |  | 8 | 5950 | Fail | 23800 | 0
 |  |  | 7 | 2335 | Strong | 9340 | 6750.485
 |  |  | 12 | 3068 | Moderate | 12272 | 4666.428
 |  |  | 11 | 3326 | Moderate | 13304 | 4240.65
 |  |  | 10 | 4121 | Moderate | 16484 | 6816.134
 |  |  | 7 | 2155 | Moderate | 8620 | 4025.54
 |  |  | 7 | 3610 | Fail | 14440 | 0
 |  |  | 11 | 3218 | Strong | 12872 | 7166.486
 |  |  | 12 | 1569 | Poor | 6276 | 1638.036
 |  |  | 11 | 1727 | Fail | 6908 | 0
 |  |  | 7 | 2395 | Moderate | 9580 | 3834.395
 |  |  | 11 | 2399 | Fail | 9596 | 0
 |  |  | 7 | 1291 | Moderate | 5164 | 2545.852
 |  |  | 12 | 2667 | Strong | 10668 | 6710.172
 |  |  | 8 | 4213 | Fail | 16852 | 0
 |  |  | 9 | 4955 | Fail | 19820 | 0
 |  |  | 12 | 5490 | Strong | 21960 | 14658.3
 |  |  | 12 | 5640 | Moderate | 22560 | 9441.359999999999
 |  |  | 8 | 3364 | Strong | 13456 | 9405.743999999999
 |  |  | 6 | 4406 | Poor | 17624 | 4538.18
 |  |  | 8 | 5201 | Fail | 20804 | 0
 |  |  | 6 | 5597 | Fail | 22388 | 0
 |  |  | 6 | 2658 | Fail | 10632 | 0
 |  |  | 9 | 5962 | Moderate | 23848 | 7863.878
 |  |  | 8 | 1686 | Poor | 6744 | 1534.26
 |  |  | 7 | 3407 | Fail | 13628 | 0