Spreadsheet: 548530d1511195083-excel-if-and-or-function-test
Sheet: Sheet1

Length Listing (m) | Burial Achieved? (Y/N) | Action (Incorrect) | Expected Outcome | Kaper Formula
1 | N |  | Y
2 | N |  | Y
3 | N |  | Y
4 | N |  | Y
5 | N |  | Y
6 | N |  | Y
7 | N |  | Y
8 | N |  | Y
9 | N |  | Y
10 | N |  | Y
11 | N |  | Y
12 | N |  | Y
13 | Y |  | N
14 | Y |  | N
15 | Y |  | N
16 | N |  | N
17 | Y |  | N
18 | Y |  | N
19 | N |  | Y
20 | N |  | Y
21 | Y |  | N
22 | N |  | Y |  |  | KP Start | Schedule 22 Asset | MSBL LAT [m] | Absolute Reqd. [NAME] LAT [m] | Reqd.[NAME] [m] | T1000 or UHD56 ToP (TSS) [m] | T3200 - Depressor Depth, "GPS" [m] | TSS Data Available (Y/N) | Achieved Burial Depth (TSS/DoL) | % RBD | Burial Achieved? (Y/N) | Section <2.0m (Y/N)
23 | N |  | Y |  |  | 96.6150000001271 | T3200 | 37.95 | 39.14 | 1.19 |  | 39.20869025601334
24 | N |  | Y |  |  | 96.6160000001271 | T3200 | 37.98 | 39.17 | 1.19 |  | 39.20532568613989
25 | N |  | Y |  |  | 96.6170000001271 | T3200 | 38 | 39.19 | 1.19 |  | 39.20545819052607
26 | N |  | Y |  |  | 96.6180000001271 | T3200 | 38.015 | 39.205 | 1.19 |  | 39.18434407649173
27 | Y |  | N |  |  | 96.6190000001271 | T3200 | 38.005 | 39.19499999999999 | 1.19 |  | 39.18357801525883
28 | N |  | Y |  |  | 96.6200000001271 | T3200 | 38.015 | 39.205 | 1.19 |  | 39.18441994859267
29 | N |  | Y |  |  | 96.6210000001271 | T3200 | 37.985 | 39.175 | 1.19 |  | 39.17505539017535
30 | N |  | Y |  |  | 96.6220000001271 | T3200 | 37.985 | 39.175 | 1.19 |  | 39.1584339635581
31 | Y |  | N |  |  | 96.6230000001271 | T3200 | 37.975 | 39.165 | 1.19 |  | 39.17768585197635
32 | Y |  | N |  |  | 96.6240000001271 | T3200 | 37.97499999999999 | 39.16499999999999 | 1.19 |  | 39.16585062683495
33 | N |  | Y |  |  | 96.6250000001271 | T3200 | 37.96 | 39.15 | 1.19 |  | 39.15200888953864
34 | N |  | Y |  |  | 96.6260000001271 | T3200 | 37.985 | 39.175 | 1.19 |  | 39.13534152297138
35 | Y |  | N |  |  | 96.6270000001271 | T3200 | 37.995 | 39.185 | 1.19 |  | 39.1349620529928
36 | N |  | N |  |  | 96.6280000001271 | T3200 | 37.97 | 39.16 | 1.19 |  | 39.11209935887322
37 | Y |  | N |  |  | 96.6290000001271 | T3200 | 37.95 | 39.14 | 1.19 |  | 39.1061814164879
38 | Y |  | N |  |  | 96.6300000001272 | T3200 | 37.945 | 39.135 | 1.19 |  | 39.0957177884999
39 | Y |  | N |  |  | 96.6310000001272 | T3200 | 37.925 | 39.11499999999999 | 1.19 |  | 39.07297708105693
40 | N |  | N |  |  | 96.6320000001272 | T3200 | 37.895 | 39.08499999999999 | 1.19 |  | 39.10674055838788
41 | Y |  | N |  |  | 96.6330000001272 | T3200 | 37.915 | 39.105 | 1.19 |  | 39.07065753748764
41 | N |  | Y |  |  | 96.6340000001272 | T3200 | 37.895 | 39.08499999999999 | 1.19 |  | 39.05283819381193
41 | N |  | Y |  |  | 96.6350000001272 | T3200 | 37.87 | 39.06 | 1.19 |  | 39.03061036265832
41 | N |  | Y |  |  | 96.6360000001272 | T3200 | 37.875 | 39.065 | 1.19 |  | 39.02596255363422
41 | N |  | Y |  |  | 96.6370000001272 | T3200 | 37.86 | 39.05 | 1.19 |  | 39.012917580698
41 | N |  | Y |  |  | 96.6380000001272 | T3200 | 37.84 | 39.03 | 1.19 |  | 39.00951703329027
41 | N |  | Y |  |  | 96.6390000001272 | T3200 | 37.815 | 39.005 | 1.19 |  | 39.00944836785723
41 | N |  | Y |  |  | 96.6400000001272 | T3200 | 37.78 | 38.97 | 1.19 |  | 38.98807075735764
41 | N |  | Y |  |  | 96.6410000001272 | T3200 | 37.78 | 38.97 | 1.19 |  | 38.97018131339842
41 | N |  | Y |  |  | 96.6420000001272 | T3200 | 37.785 | 38.97499999999999 | 1.19 |  | 38.95801240417487
41 | N |  | Y