Spreadsheet: 708549d1607927076-assistance-with-developing-complex-formula-sample-dataset
Sheet: Sheet3

Row Labels | adm_whz | fu_whz_1 | fu_whz_2 | fu_whz_3 | fu_whz_4 | fu_whz_5 | fu_whz_6 | fu_whz_7 | fu_whz_8 | fu_whz_9 | fu_whz_10 | fu_whz_11 | fu_whz_12 | fu_whz_13 | fu_whz_14 | fu_whz_15 | fu_whz_16 | fu_whz_17 | fu_whz_18 | fu_whz_19 | weight_adm | weight_1 | weight_2 | weight_3 | [NAME] | weight_5 | weight_6 | weight_7 | weight_8 | weight_9 | weight_10 | weight_11 | weight_12 | weight_13 | weight_14 | weight_15 | [NAME] | weight_17 | weight_18 | weight_19 | sach_weight_adm | [NAME] | sach_weight_2 | sach_weight_3 | sach_weight_4 | sach_weight_5 | sach_weight_6 | sach_weight_7 | sach_weight_8 | sach_weight_9 | sach_weight_10 | sach_weight_11 | sach_weight_12 | sach_weight_13 | sach_weight_14 | sach_weight_15 | sach_weight_16 | sach_weight_17 | sach_weight_18 | sach_weight_19 | adm | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
00087a41-63e9-4f45-b87b-5cbb6b11bfd7 | -2.38 | -2.08 | -1.51 | -1.11 | -1.94 | -2.69 | -2.38 | -2.41 |  |  |  |  |  |  |  |  |  |  |  |  | 7.9 | 8.1 | 8.5 | 8.8 | 8.2 | 7.7 | 7.9 | 7.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 14
0012ae0d-2243-415f-83aa-1b008069d04b | -2.12 | -1.05 | -1.14 | -0.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.4 | 9.2 | 9.4 | 10.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 14
0022838b-85af-4365-b4cc-f086acef5ba0 | -2.9 | -2.79 | -1.83 | -0.62 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10.8 | 10.9 | 11.8 | 13.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
[NAME] | -2.99 | -1.92 | -2.99 | -1.87 | -1.79 | -1.92 | -1.92 | -1.41 | -1.92 | -1.66 | -0.8 |  |  |  |  |  |  |  |  |  | 8.9 | 9.7 | 9.3 | 9.7 | 9.7 | 9.7 | 9.7 | 10.1 | 9.7 | 9.9 | 10.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 14 | 14 | 14 | 14 | 14 | 14
0025abd5-699f-4e04-bb1c-c0fc69e1d7ac | -2.77 | -2.01 | -1.83 | -2.13 | -2.13 | -1.53 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.6 | 7 | 7.1 | 7.2 | 7.2 | 7.8
00540e3e-35d7-4d15-8f3f-f24b747e0f38 | -3.17 | -4.45 | -3.88 | -3.44 | -2.96 | -2.47 | -2.44 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.6 | 6.8 | 7.1 | 7.5 | 7.8 | 8.1 | 8.2
0083cca3-c90a-4fee-a452-9198c40eaf59 | -3.04 | -2.87 | -2.7 | -2.7 | -2.87 | -2.68 | -2.52 | -2.85 | -2.85 | -2.59 |  |  |  |  |  |  |  |  |  |  | 6.9 | 7 | 7.1 | 7.1 | 7 | 7.2 | 7.3 | 7.1 | 7.1 | 7.3
009b015a-d72d-4ca5-98ff-6ac2d7836160 | -2.06 | -1.31 | -0.41 | -0.5700000000000001 | -0.41 | -1.28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 6.4 | 7 | 6.9 | 7 | 7.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 14 | 14 | 14
00bf4c46-ce6a-49ec-98cf-e29769254f75 | -1.97 | -3.66 | -1.64 | -1.81 | -1.99 | -1.87 | -1.64 | -1.87 | -1.54 | -2.23 | -1.54 | -1.7 | -2.08 | -1.24 | -1.08 |  |  |  |  |  | 6.71 | 5.8 | 6.9 | 6.8 | 6.7 | 6.8 | 6.9 | 6.8 | 7 | 6.6 | 7 | 6.9 | 6.7 | 7.2 | 7.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 |  |  | 14 | 14 | 14 | 14 | 14 | 14 |  |  | 14 |  |  | 14
00cb8501-7a8b-47a0-a084-acffdb8fcd37 | -2.13 | -2.92 | -2.13 | -3.78 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.35 | 8.8 | 9.35 | 8.2
00d0153d-6267-4167-b830-31707c264e01 | -2.28 | -1.84 | -1.7 | -1.29 | -1.63 | -1.33 | -0.56 | -0.81 |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 8.3 | 8.4 | 8.7 | 8.6 | 8.7 | 9.3 | 9.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 14 | 14 | 14 | 14 | 14
01128a5a-ad12-4d1e-ad57-ba6721a1b3c0 | -1.28 | -0.51 | -0.65 | -0.22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.1 | 7.6 | 7.8 | 8.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 14 | 14 | 14
01162d92-6eb8-4227-88c6-c6bb3854317c | -2.44 | -3.35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.6 | 6.11
012af169-ce22-4ddd-95d7-be86a6be235d | -2.04 | -2.04 | -1.85 | -1.95 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11.7 | 11.7 | 12 | 11.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
015cf293-6b0f-44be-8f77-9317fe043b59 | -2.31 | -2.03 | -1.26 | -1.38 | -0.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.7 | 8.9 | 9.5 | 9.4 | 9.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 14
016820c1-ed05-4a34-8bc8-415a34628992 | -4.08 | -2.51 | -2.51 | -1.78 | -1.79 | -2.22 | -2.53 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.8 | 7.8 | 7.8 | 8.2 | 8.4 | 8.1 | 7.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
01b5fbba-8fba-41c3-b778-0f78a6c2da7a | -1.19 | -0.01 | -0.62 | -0.34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.2 | 10.2 | 10.1 | 10.4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 14 | 14 | 14
01e6f8b6-9a10-4d3e-8c00-7d5903bcf696 | -1.83 | -1.67 | -1.19 | -1.78 | -1.65 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 7.1 | 7.4 | 7.4 | 7.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 14 | 14 | 14 | 14
022dc61b-f2bb-4f20-9d79-a77f8bdabe23 | -1.95 | -2.09 | -1.55 | -1.47 | -1.73 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.7 | 8.6 | 9 | 9.1 | 8.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 |  |  | 14 | 14
02908b8c-f771-4d57-8f06-96b8e6e6f242 | -3.88 | -3.48 | -3.48 | -2.79 | -2.25 | -2.65 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.7 | 9 | 9 | 9.5 | 9.9 | 9.6
[NAME] | -4.31 | -4.31 | -3.83 | -3.23 | -3.14 | -3.83 | -3.48 | -3.44 | -3.46 | -3.5 | -3.5 | -3.38 | -3.17 |  |  |  |  |  |  |  | 9.6 | 9.6 | 10 | 10.5 | 10.7 | 10.2 | 10.5 | 10.5 | 10.5 | 10.5 | 10.5 | 10.6 | 10.8
02b93d16-d26c-4771-aee1-87399f386647 | -1.49 | -1.49 | -1.68 | -2.08 | -1.31 | -1.94 | -0.9400000000000001 | -0.86 |  |  |  |  |  |  |  |  |  |  |  |  | 6.1 | 6.1 | 6 | 5.8 | 6.2 | 6.1 | 6.4 | 6.7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 14 | 14 |  |  | 14 | 14 | 14
032b5f85-fa94-49ab-8daa-aa78943022f7 | -2.29 | -2.29 | -2.13 | -1.95 | -1.81 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.2 | 7.2 | 7.3 | 7.41 | 7.7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
035e737e-5e7b-46da-b74a-aec83318f7f3 | -4.24 | -3.24 | -2.84 | -3.04 | -2.77 | -2.91 | -2.91 | -2.15 |  |  |  |  |  |  |  |  |  |  |  |  | 5.1 | 5.6 | 5.8 | 5.7 | 5.9 | 5.8 | 5.8 | 6.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF(V2>=12,35,IF(V2>=10.5,32,IF(V2>=9.5,28,IF(V2>=8.5,25,IF(V2>=7,21,IF(V2>=5,18,IF(V2>=4,14,IF(V2>=3,11,""))))))))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >= | 3 | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.5 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.5 | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10.5 | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 35