Spreadsheet: 191135d1351930999-calculate-only-when-cell-is-not-blank-without-using-if-sample
Sheet: Data

Progress | Buffer Penetration | Original Chain | Original Buffer | Remaining Days | Remaining Buffer | Project Update Status | Remaining Buffer %
0 | 0 | 185 | 72 | 185 | 72 | 2011-10-12 00:00:00 | 1
0.02162162162162162 | 0.01388888888888884 | 185 | 72 | 181 | 71 | 2011-10-14 00:00:00 | 0.9861111111111112
0.03783783783783778 | 0.04166666666666663 | 185 | 72 | 178 | 69 | 2011-10-21 00:00:00 | 0.9583333333333334
0.03783783783783778 | 0.1111111111111112 | 185 | 72 | 178 | 64 | 2011-10-28 00:00:00 | 0.8888888888888888
0.03783783783783778 | 0.1805555555555556 | 185 | 72 | 178 | 59 | 2011-11-04 00:00:00 | 0.8194444444444444
0.06486486486486487 | 0.1805555555555556 | 185 | 72 | 173 | 59 | 2011-11-11 00:00:00 | 0.8194444444444444
0.06486486486486487 | 0.25 | 185 | 72 | 173 | 54 | 2011-11-18 00:00:00 | 0.75
0.06486486486486487 | 0.3194444444444444 | 185 | 72 | 173 | 49 | 2011-11-25 00:00:00 | 0.6805555555555556
0.07567567567567568 | 0.3611111111111112 | 185 | 72 | 171 | 46 | 2011-12-02 00:00:00 | 0.6388888888888888
0.07567567567567568 | 0.3611111111111112 | 185 | 72 | 171 | 46 | 2011-12-09 00:00:00 | 0.6388888888888888
0.07567567567567568 | 0.3611111111111112 | 185 | 72 | 171 | 46 | 2011-12-16 00:00:00 | 0.6388888888888888
0.172972972972973 | 0.4166666666666666 | 185 | 72 | 153 | 42 | 2012-01-06 00:00:00 | 0.5833333333333334
0.2 | 0.4166666666666666 | 185 | 72 | 148 | 42 | 2012-01-13 00:00:00 | 0.5833333333333334
0.2162162162162162 | 0.4444444444444444 | 185 | 72 | 145 | 40 | 2012-01-20 00:00:00 | 0.5555555555555556
0.2432432432432432 | 0.4444444444444444 | 185 | 72 | 140 | 40 | 2012-01-27 00:00:00 | 0.5555555555555556
0.2702702702702703 | 0.4444444444444444 | 185 | 72 | 135 | 40 | 2012-02-03 00:00:00 | 0.5555555555555556
0.2648648648648648 | 0.5277777777777778 | 185 | 72 | 136 | 34 | 2012-02-10 00:00:00 | 0.4722222222222222
0.2594594594594595 | 0.6111111111111112 | 185 | 72 | 137 | 28 | 2012-02-17 00:00:00 | 0.3888888888888888
0.2756756756756756 | 0.6388888888888888 | 185 | 72 | 134 | 26 | 2012-02-24 00:00:00 | 0.3611111111111112
0.3027027027027027 | 0.6388888888888888 | 185 | 72 | 129 | 26 | 2012-03-02 00:00:00 | 0.3611111111111112
0.3405405405405405 | 0.6111111111111112 | 185 | 72 | 122 | 28 | 2012-03-09 00:00:00 | 0.3888888888888888
0.3945945945945946 | 0.5416666666666667 | 185 | 72 | 112 | 33 | 2012-03-16 00:00:00 | 0.4583333333333333
0.4108108108108108 | 0.5694444444444444 | 185 | 72 | 109 | 31 | 2012-03-23 00:00:00 | 0.4305555555555556
0.4108108108108108 | 0.6388888888888888 | 185 | 72 | 109 | 26 | 2012-03-30 00:00:00 | 0.3611111111111112
0.4108108108108108 | 0.6944444444444444 | 185 | 72 | 109 | 22 | 2012-04-06 00:00:00 | 0.3055555555555556
0.4702702702702702 | 0.5972222222222222 | 185 | 72 | 98 | 29 | 2012-04-13 00:00:00 | 0.4027777777777778
0.4810810810810811 | 0.6388888888888888 | 185 | 72 | 96 | 26 | 2012-04-20 00:00:00 | 0.3611111111111112
0.5135135135135135 | 0.625 | 185 | 72 | 90 | 27 | 2012-04-27 00:00:00 | 0.375
0.5405405405405406 | 0.625 | 185 | 72 | 85 | 27 | 2012-05-04 00:00:00 | 0.375
0.5459459459459459 | 0.6666666666666667 | 185 | 72 | 84 | 24 | 2012-05-11 00:00:00 | 0.3333333333333333
0.5783783783783784 | 0.6527777777777778 | 185 | 72 | 78 | 25 | 2012-05-18 00:00:00 | 0.3472222222222222
0.6108108108108108 | 0.6527777777777778 | 185 | 72 | 72 | 25 | 2012-05-25 00:00:00 | 0.3472222222222222
0.6270270270270271 | 0.6805555555555556 | 185 | 72 | 69 | 23 | 2012-06-01 00:00:00 | 0.3194444444444444
0.605 | 0.6805555555555556 | 200 | 72 | 79 | 23 | 2012-06-08 00:00:00 | 0.3194444444444444
0.6033333333333333 | 0.7295081967213115 | 300 | 122 | 119 | 33 | 2012-06-16 00:00:00 | 0.2704918032786885
0.6742857142857143 | 0.7295081967213115 | 350 | 122 | 114 | 33 | 2012-06-22 00:00:00 | 0.2704918032786885
0.6966666666666667 | 0.7295081967213115 | 300 | 122 | 91 | 33 | 2012-06-29 00:00:00 | 0.2704918032786885
0.6966666666666667 | 0.7704918032786885 | 300 | 122 | 91 | 28 | 2012-07-06 00:00:00 | 0.2295081967213115
0.7166666666666667 | 0.7622950819672132 | 300 | 122 | 85 | 29 | 2012-07-13 00:00:00 | 0.2377049180327868
0.7333333333333334 | 0.7622950819672132 | 300 | 122 | 80 | 29 | 2012-07-20 00:00:00 | 0.2377049180327868
0.7033333333333334 | 0.7622950819672132 | 300 | 122 | 89 | 29 | 2012-08-10 00:00:00 | 0.2377049180327868
0.7033333333333334 | 0.7622950819672132 | 300 | 122 | 89 | 29 | 2012-08-17 00:00:00 | 0.2377049180327868
0.8133333333333334 | 0.7704918032786885 | 300 | 122 | 56 | 28 | 2012-08-24 00:00:00 | 0.2295081967213115
0.8233333333333334 | 0.7786885245901639 | 300 | 122 | 53 | 27 | 2012-08-31 00:00:00 | 0.2213114754098361
0.8366666666666667 | 0.7868852459016393 | 300 | 122 | 49 | 26 | 2012-09-07 00:00:00 | 0.2131147540983607
0.85 | 0.7950819672131147 | 300 | 122 | 45 | 25 | 2012-09-14 00:00:00 | 0.2049180327868853
0.85 | 0.8360655737704918 | 300 | 122 | 45 | 20 | 2012-09-21 00:00:00 | 0.1639344262295082
0.85 | 0.8770491803278688 | 300 | 122 | 45 | 15 | 2012-09-28 00:00:00 | 0.1229508196721312
0.85 | 0.9180327868852459 | 300 | 122 | 45 | 10 | 2012-10-05 00:00:00 | 0.08196721311475408
0.85 | 0.9590163934426229 | 300 | 122 | 45 | 5 | 2012-10-12 00:00:00 | 0.04098360655737709
0.85 | 0.9672131147540983 | 300 | 122 | 45 | 4 | 2012-10-19 00:00:00 | 0.03278688524590168
0.9 | 0.9426229508196722 | 300 | 122 | 30 | 7 | 2012-10-26 00:00:00 | 0.05737704918032782
 |  | 300 | 122
 |  | 300 | 122
 |  | 300 | 122
 |  | 300 | 122
 |  | 300 | 122