Spreadsheet: 274879d1383247142-two-way-lookup-with-multiple-if-and-variables-my-mind-is-blown-on-this-one-00-wcr-summary_test_jc-solution-combined
Sheet: WCR Summary

WASHROOM CONDITION REPORT
Summary Chart
 |  |  |  |  |  |  |  | 2013-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | Pricing "Category" Vert. |  |  |  | Total Cost
Rank | School | WR No. | Sex | Area | Arch | [NAME] | Elec | Estimated Cost | No. |  |  | Arch | [NAME] | Elec
1 | Central Public School |  |  |  |  |  |  | 16150 | 1
2 | Central Public School | [NAME] | G | 190 |  |  |  | 16720 | 2
3 | Central Public School | W3 | BF | 40 | 0.53 | 0.5 | 0.6 | 5920 | 3
4 | Central Public School | W4 | S | 10 | 0.63 | 0.6 | 0.5 | 1480 | 4
5 | Central Public School | W5 | B-KG | 28 | 0.75 | 0.7 | 0.9 | 3080 | 5
6 | Central Public School | W6 | G-KG | 28 | 0.75 | 0.7 | 0.9 | 3080 | 6
7 | Central Public School | W7 | B | 230 | 0.48 | 0.83 | 0.8 | 34040 | 7
8 | Central Public School | W8 | G | 291 | 0.82 | 0.77 | 0.4 | 25899 | 8
9 | Central Public School | W9 | S | 28 | 0.5 | 0.56 | 0.5 | 4144 | 9
10 | Central Public School | W10 | S | 336 | 0.48 | 0.6 | 0.5 | 50064 | 10
11 | Central Public School | W11 | G | 308 | 0.84 | 0.8 | 0.9 | 25564 | 11
12 | Central Public School | W12 | B | 294 | 0.84 | 0.8 | 0.9 | 24402 | 12
13 | Marlborough Public School | W1 | G | 288 | 0.4 | 0.27 | 0.2 | 45504 | 13
14 | Marlborough Public School | W1 | S | 64 | 0.5 | 0.47 | 0.2 | 9728 | 14
15 | Marlborough Public School | [NAME] | B | 288 | 0.34 | 0.2 | 0.3 | 45504 | 15
16 | Marlborough Public School | [NAME] | S | 64 | 0.45 | 0.47 | 0.3 | 11776 | 16
17 | Marlborough Public School | W3 | S | 64 | 0.67 | 0.53 | 0.6 | 9152 | 17
18 | Marlborough Public School | W4 | S | 64 | 0.67 | 0.43 | 0.6 | 9344 | 18
19 | Marlborough Public School | W5 | G | 288 | 0.36 | 0.27 | 0.5 | 43776 | 19
20 | Marlborough Public School | W6 | B | 288 | 0.48 | 0.23 | 0.3 | 45504 | 20
21 | Marlborough Public School | W7 | KG | 24 | 0.43 | 0.4 | 0.5 | 4464 | 21
22 | Marlborough Public School | W8 | G | 176 | 0.42 | 0.47 | 0.4 | 29392 | 22
23 | Marlborough Public School | W9 | S | 15 | 0.45 | 0.48 | 0.5 | 2790 | 23
24 | Marlborough Public School | W10 | B | 88 | 0.48 | 0.52 | 0.4 | 15488 | 24
25 | Marlborough Public School | W11 | G | 88 | 0.38 | 0.64 | 0.4 | 15488 | 25
26 | Queen Victoria Public School | W3 | B | 336 | 0.48 | 0.46 | 0.4 | 52080 | 26
27 | Queen Victoria Public School | W4 | G | 336 | 0.52 | 0.32 | 0.3 | 40590 | 27
28 | Queen Victoria Public School | W5 |  | 140 | 0.6 | 0.35 | 0.6 | 18760 | 28
29 | Queen Victoria Public School | W6 | S | 80 | 0.58 | 0.4 | 0.3 | 10960 | 29
30 | Queen Victoria Public School | W7 | B | 364 | 0.42 | 0.44 | 0.25 | 54600 | 30
31 | Queen Victoria Public School | W8 | S | 40 | 0.62 | 0.3 | 0.5 | 6040 | 31
32 | Queen Victoria Public School | W9 | G | 364 | 0.6 | 0.44 | 0.4 | 39676 | 32
33 | Queen Victoria Public School | W10 | B | 392 | 0.48 | 0.4 | 0.3 | 58800 | 33
34 | Queen Victoria Public School | W11 | S | 48 | 0.63 | 0.45 | 0.5 | 7248 | 34
35 | Queen Victoria Public School | W12 | S | 48 | 0.6 | 0.45 | 0.4 | 7392 | 35
36 | Queen Victoria Public School | W13 | G | 392 | 0.47 | 0.28 | 0.2 | 59976 | 36
37 | Queen Victoria Public School | W14 | S | 35 | 0.53 | 0.35 | 0.2 | 5495 | 37
38 | Southwood Public School | W1 | S | 32 | 0.78 | 0.72 | 0.5 | 3616 | 38
39 | Southwood Public School | [NAME] | G-BF | 210 | 0.73 | 0.63 | 0.6 | 24990 | 39
40 | Southwood Public School | W3 | S | 32 | 0.63 | 0.6 | 0.6 | 4736 | 40
41 | Southwood Public School | W4 | B-BF | 144 | 0.67 | 0.6 | 0.5 | 18864 | 41
42 | Southwood Public School | W5 | B | 234 | 0.91 | 0.83 | 0.9 | 18954 | 42
43 | Southwood Public School | W6 | G | 320 | 0.93 | 0.73 | 0.9 | 27520 | 43
44 | Southwood Public School | W7 | S | 19 | 0.75 | 0.75 | 0.7 | 2033 | 44
45 | Southwood Public School | W8 | S | 25 | 0.75 | 0.65 | 0.7 | 2750 | 45
46 | Southwood Public School | W9 | S | 336 | 0.65 | 0.75 | 0.7 | 37296 | 46
47 | Southwood Public School | W10 | B | 212 | 0.88 | 0.89 | 1 | 16536 | 47
48 | Southwood Public School | W11 | G | 267 | 0.92 | 0.83 | 0.9 | 22161 | 48
49 | Southwood Public School | W12 | B | 38 | 0.89 | 0.8 | 0.9 | 4066 | 49
50 | Southwood Public School | W13 | G | 60 | 0.91 | 0.7 | 0.9 | 6300 | 50