Task: String-Relationship (source dataset: Auto-Relate)

You are given a table below, where some of the columns may be derived from other columns using string-based transformations (e.g., string split, concatenation, formatting, substring extraction, and pattern matching, etc.). 

Your task is to identify string transformation relationships between the columns, by determining if any column, henceforce referred to as a TargetColumn, can be derived from other columns, referred to as SourceColumns, using the string-based transformations. Please only return relationships that are semantically meaningful and truly hold, and do not return any relationships that are spurious. 

No explanation is needed, return all the detected relationships in the following JSON format: 
{
  "String-Relationship": [
    [["SourceColumn1", "SourceColumn2", ...], "TargetColumn"],
    ...
  ]
}

Input Table:
|   Foreign_0 |   Foreign_1 | Foreign_2          |   Foreign_3 |   Foreign_4 | Foreign_5   |   Foreign_6 | Foreign_7   |   Foreign_8 |   Foreign_9 | Foreign_10   | Foreign_11   |   Foreign_12 |   Foreign_13 |   Foreign_14 |   Foreign_15 |   Foreign_16 |   Foreign_17 |   Foreign_18 | Foreign_19   | Foreign_20   | Foreign_21   | Foreign_22   |   Foreign_23 | Foreign_24         |   Foreign_25 |   Foreign_26 | Foreign_27   |   Foreign_28 |   Foreign_29 |   Foreign_30 | Foreign_31      | Foreign_32                    |   Foreign_33 |   Foreign_34 |   Foreign_35 | Foreign_36   | Foreign_37              | Foreign_38   | Foreign_39   |   Foreign_40 |   Foreign_41 | Foreign_42   | Foreign_43   |   Foreign_44 |   Foreign_45 |   Foreign_46 |   Foreign_47 | Foreign_48        |   Foreign_49 |   Foreign_50 |   Foreign_51 | Foreign_52   | Foreign_53                                                                                        |   Foreign_54 |   Foreign_55 |   Foreign_56 | Foreign_57     |   Foreign_58 | Foreign_59   |   Foreign_60 |   Foreign_61 |   Foreign_62 |   Foreign_63 |   Foreign_64 |   Foreign_65 |   Foreign_66 |   Foreign_67 |   Foreign_68 |   Foreign_69 |   Foreign_70 | Foreign_71   | Foreign_72   | Foreign_73       | Foreign_74   | Foreign_75         | Foreign_76   | Foreign_77      |   Foreign_78 |   Foreign_79 | Foreign_80   |   Foreign_81 | Foreign_82                  | Foreign_83   | Foreign_84   |   Foreign_85 |   Foreign_86 | Foreign_87   | Foreign_88   | Foreign_89   |   Foreign_90 |   Foreign_91 | Foreign_92   |   Foreign_93 | Foreign_94         | Foreign_95                                   |   Foreign_96 |   Foreign_97 |   Foreign_98 | Foreign_99                            | A              | B                            | C              | D                                                                                                                         | E   | F                                 | G                      | H                      | I                      | J                      | K                      |
|------------:|------------:|:-------------------|------------:|------------:|:------------|------------:|:------------|------------:|------------:|:-------------|:-------------|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|:-------------|:-------------|:-------------|:-------------|-------------:|:-------------------|-------------:|-------------:|:-------------|-------------:|-------------:|-------------:|:----------------|:------------------------------|-------------:|-------------:|-------------:|:-------------|:------------------------|:-------------|:-------------|-------------:|-------------:|:-------------|:-------------|-------------:|-------------:|-------------:|-------------:|:------------------|-------------:|-------------:|-------------:|:-------------|:--------------------------------------------------------------------------------------------------|-------------:|-------------:|-------------:|:---------------|-------------:|:-------------|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|:-------------|:-------------|:-----------------|:-------------|:-------------------|:-------------|:----------------|-------------:|-------------:|:-------------|-------------:|:----------------------------|:-------------|:-------------|-------------:|-------------:|:-------------|:-------------|:-------------|-------------:|-------------:|:-------------|-------------:|:-------------------|:---------------------------------------------|-------------:|-------------:|-------------:|:--------------------------------------|:---------------|:-----------------------------|:---------------|:--------------------------------------------------------------------------------------------------------------------------|:----|:----------------------------------|:-----------------------|:-----------------------|:-----------------------|:-----------------------|:-----------------------|
|         185 |           0 | 36284.881249999999 |           0 |           3 | Airtel      |          67 |             |          22 |          98 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.56772e+07 |              |              |              | Rank         |  1.23835e+06 | 166.17891          |      11691   |     0.06816  |              |  2.88178e+07 |        287.5 |         4284 | Negative Change | PRODUCTIVITY AWARD            |            0 |          110 |           30 | Yes/No       | Library Science         |              | 0            |      250.031 |            0 |              | Revenues     |       660.25 |            0 |         2021 |      12290.9 | TOTAL THIS PERIOD |            0 |      19.6615 |            0 |              | (2) Chrome; Towel Bar Type With Anti-Slip Rubber Inserts; Mounted Left and Right Side on Exterior |      28.2317 |     0.984597 |           18 | Royal Wed Ring |          863 | HQP102       |     0.035111 |          236 |           81 |            0 |         1963 |            7 | 21.05        |      7808.46 |            0 |   -0.5       |      6332.21 | k            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43828 |            1 |              |            0 | Laundry                     | 21003        |              |            0 |         3636 |              |              | 74-SENECA    |      28882.3 |          283 |              |           12 | 29518.668881811675 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | Select company | Select companyC00052RC_L010  | C00052RC_L010  | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year    | £m  | Blind year reconciliation 2014-15 |                        |                        |                        |                        |                        |
|         875 |           0 | 26011.270833333332 |           0 |           3 | Marché      |           0 |             |          22 |          50 | 0            | TPXX-EXP-CPD |         0    |         0.87 |          156 |            0 |         3671 |            0 |  1.24505e+08 |              |              |              | Rank         |  1.23835e+06 | 2130.508923397404  |      10542.8 |     0.13632  |              |  2.88178e+07 |        287.5 |         3600 | Negative Change | TELEPHONE SERVICES            |            0 |          112 |           30 | Yes/No       | Health Services         |              | 0            |      250.031 |            0 |              | Revenues     |       508.25 |            0 |         2021 |      10883.9 | TOTAL THIS PERIOD |            0 |       0.2    |            0 |              | Full Width, Aerodynamic, Chrome Plated Steel; 0.142" Material Thickness bumper                    |     278.428  |     1.7475   |           18 | Royal Wed Ring |           47 | HQP102       |     0.035111 |          236 |           96 |            0 |         1658 |            3 | 21.05        |      7506    |            0 |   -0.0209118 |      6332.21 | s            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43828 |            1 |              |            0 | Social Service              | 21002        |              |            1 |         3636 |              |              | 74-SENECA    |      28882.3 |          355 |              |           11 | 47358.660542197489 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | Select company | Select companyC00052BIA_L010 | C00052BIA_L010 | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment            | £m  | Blind year reconciliation 2014-15 |                        |                        |                        |                        |                        |
|          61 |           2 | 46546.979400605414 |           0 |           3 | Marché      |         106 |             |          22 |         146 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.24505e+08 |              |              |              | Rank         |  1.23835e+06 | 693.85953073076939 |      11534.6 |     0.13632  |              |  2.88178e+07 |        287.5 |         3945 | Negative Change | TRANSPORT AND TRAVELLING      |            0 |          108 |           30 | 0            | Fine Arts               |              | 0            |      250.031 |            0 |              | Revenues     |       470.25 |            0 |         2021 |      12290.9 | TOTAL THIS PERIOD |            0 |      17.6    |            0 |              | Steel, Swept Back bumper                                                                          |     278.428  |     1.7475   |           18 | Royal Wed Ring |           41 | HQP102       |     0.035111 |          236 |           33 |            0 |         1658 |            9 |  1.12307e+06 |      7658.23 |            0 |   -0.0447504 |      2853.65 | t            |              | Life and Annuity |              | Center Code & Name | CA00257      | No Change       |        43856 |            1 |              |            0 | Medical Records             | 21002W       |              |            1 |         3636 |              |              | 74-SENECA    |      23981.2 |          355 |              |            6 | 5555.3665989256151 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2014 | Original Salary rebased with FY16 CAF | Select company | Select companyC00053RC_L010  | C00053RC_L010  | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year | £m  | Blind year reconciliation 2014-15 |                        |                        |                        |                        |                        |
|          61 |           1 | 36284.881249999999 |           0 |           3 | MTN         |           0 |             |          22 |          26 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  0           |              |              |              | Rank         |  1.23835e+06 | 166.17891          |      12156.6 |     0.06816  |              |  2.88178e+07 |        287.5 |         3877 | Negative Change | MAINT. OF VEHICLE & C/ASSET   |            0 |          113 |           30 | Yes/No       | Home Economics          | 0            | 0            |      250.031 |            0 |              | Revenues     |       242.25 |            0 |         2021 |      10912.5 | TOTAL THIS PERIOD |            0 |      44.0564 |            0 |              | Full Width, Aerodynamic, Steel; 0.142" Material Thickness, Gloss Black bumper                     |     278.428  |     1.03341  |           18 | Royal Wed Ring |            8 | HQP102       |     0.035111 |          236 |           33 |            0 |         1105 |            2 |  1.12307e+06 |      7352.28 |            0 |   -0.0209118 |      3728.41 | t            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43828 |            1 |              |            0 | Housekeeping                | 21003        |              |            0 |         3636 |              |              | 74-SENECA    |      23981.2 |          355 |              |           13 | 13197.36871866271  | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | Select company | Select companyC00053BIA_L010 | C00053BIA_L010 | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment         | £m  | Blind year reconciliation 2014-15 |                        |                        |                        |                        |                        |
|          61 |           1 | 16700.635416666668 |           0 |           3 | MTN         |           0 |             |          22 |          62 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.56772e+07 |              |              |              | Rank         |  1.23835e+06 | 1934.2688210738866 |      12375.3 |     0.13632  |              |  2.88178e+07 |        287.5 |         3600 | Negative Change | MAINT. OF VEHICLE & C/ASSET   |            0 |          113 |           30 | 0            | Agriculture             |              | 0            |      250.031 |            0 |              | Revenues     |       375.25 |            0 |         2021 |      10883.9 | TOTAL THIS PERIOD |            0 |       0.2    |            0 |              | (2) Chrome; Towel Bar Type With Anti-Slip Rubber Inserts; Mounted Left and Right Side on Exterior |     278.428  |     0.9845   |           18 | Royal Wed Ring |           12 | HQP102       |     0.035111 |          236 |           69 |            0 |         2035 |            8 |  1.12307e+06 |      2985.44 |            0 |   -0.0209118 |      4301.64 | z            |              | Life and Annuity |              | Center Code & Name | CA00257      | No Change       |        43856 |            1 |              |            0 | All Therapy                 | 034W         |              |            0 |         3636 |              |              | 74-SENECA    |      28882.3 |          283 |              |            2 | 56868.073671850994 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | ANH            | ANHC00052RC_L010             | C00052RC_L010  | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year    | £m  | Blind year reconciliation 2014-15 | 0.52340059358839364    | 0.52340059358839364    | 0.52340059358839364    | 0.52340059358839364    | 0.52340059358839364    |
|          61 |           2 | 26011.270833333332 |           0 |           3 | MTN         |          46 |             |          22 |         110 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  0           |              |              |              | Rank         |  1.23835e+06 | 166.17891          |      11748.7 |     0.353877 |              |  2.88178e+07 |        287.5 |         3320 | Negative Change | MAINT. OF VEHICLE & C/ASSET   |            0 |          113 |           30 | Yes/No       | Teacher Education       |              |              |      250.031 |            0 |              | Revenues     |       660.25 |            0 |         2021 |      10912.5 | TOTAL THIS PERIOD |            0 |       0.2    |            0 |              | (2) Chrome; Towel Bar Type With Anti-Slip Rubber Inserts; Mounted Left and Right Side on Exterior |      28.2317 |     0.984597 |           18 | Royal Wed Ring |           93 | HQP102       |     0.035111 |          236 |           45 |            0 |          330 |            6 |  1.12307e+06 |      7882.66 |            0 |   -0.0705128 |      4207.64 | k            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43828 |            1 |              |            0 | Activities                  | 21003        |              |            0 |         3636 |              |              | 74-SENECA    |      28882.3 |          283 |              |            3 | 13197.36871866271  | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | ANH            | ANHC00052BIA_L010            | C00052BIA_L010 | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment            | £m  | Blind year reconciliation 2014-15 | -1.433943665771908     | -1.433943665771908     | -1.433943665771908     | -1.433943665771908     | -1.433943665771908     |
|         875 |           8 | 69589.593114600968 |           0 |           3 | Marché      |         137 |             |          22 |          86 | 9.18.14      | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  0           |              |              |              | Rank         |  1.23835e+06 |                    |      10627.4 |     0.06816  |              |  2.88178e+07 |        287.5 |         3385 | Negative Change | UTILITY SERVICES              |            0 |          111 |           30 | Yes/No       | Totals                  |              |              |      250.031 |            0 |              | Revenues     |       318.25 |            0 |         2021 |      10912.5 | TOTAL THIS PERIOD |            0 |       0.3    |            0 |              | Cowl tray Lid to keep snow out                                                                    |     278.428  |     0.998067 |           18 | Royal Wed Ring |            6 | HQP102       |     0.035111 |          236 |           57 |            0 |          410 |            5 |  1.12307e+06 |      7956.17 |            0 |   -0.2       |      4388.48 | z            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43856 |            1 |              |            0 | Administrative & Management | 896W         |              |            0 |         3636 |              |              | 74-SENECA    |      26666.6 |          283 |              |            8 | 56868.073671850994 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | ANH            | ANHC00053BIA_L010            | C00053BIA_L010 | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment         | £m  | Blind year reconciliation 2014-15 | -2.0273126081262096    | -2.0273126081262096    | -2.0273126081262096    | -2.0273126081262096    | -2.0273126081262096    |
|         185 |           2 | 57476.524019716235 |           0 |           3 | Airtel      |          48 |             |          22 |          26 | 2.18.15      | TPXX-EXP-CPD |         0    |         0.87 |          156 |            0 |         3671 |            0 |  1.56772e+07 |              |              |              | Rank         |  1.23835e+06 | 2646.6075767559923 |      11238.7 |     0.207965 |              |  2.88178e+07 |        287.5 |         3244 | Negative Change | OFFICE STATIONERY             |            0 |           86 |           30 | Yes/No       | Nursing                 |              | 0            |      250.031 |            0 |              | Revenues     |       603.25 |            0 |         2021 |      12290.9 | TOTAL THIS PERIOD |            0 |      15.031  |            0 |              | Steel, Swept Back bumper                                                                          |     278.428  |     0.984514 |           18 | Royal Wed Ring |           93 | HQP102       |     0.035111 |          236 |           93 |            0 |         1963 |            4 |  1.12307e+06 |      7882.66 |            0 |   -0.5       |      4403.9  | k            |              | Life and Annuity |              | Center Code & Name | CA00257      | No Change       |        43856 |            1 |              |            0 | Laundry                     | 033W         |              |            0 |         3636 |              |              | 74-SENECA    |      28882.3 |          283 |              |            4 | 13197.36871866271  | State Highway 2, Takapau, Central Hawkes Bay |            1 |          101 |         2015 | Original Salary rebased with FY16 CAF | WSH            | WSHC00052RC_L010             | C00052RC_L010  | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year    | £m  | Blind year reconciliation 2014-15 | 4.5076483656259176     | 4.5076483656259176     | 4.5076483656259176     | 4.5076483656259176     | 4.5076483656259176     |
|         875 |           2 | 69589.593114600968 |           0 |           3 | Marché      |          67 |             |          22 |         156 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.24505e+08 |              |              |              | Rank         |  1.23835e+06 |                    |      11414.9 |     0.06816  |              |  2.88178e+07 |        287.5 |         3945 | Negative Change | GRANT AND CONTRIBUTION        |            0 |          108 |           30 | 0            | Library Science         | 0            |              |      250.031 |            0 |              | Revenues     |       641.25 |            0 |         2021 |      12290.9 | TOTAL THIS PERIOD |            0 |      10.6    |            0 |              | Conventional 6-Man Crew Cab                                                                       |      28.2317 |     0.998067 |           18 | Royal Wed Ring |         1087 | HQP102       |     0.035111 |          236 |           81 |            0 |         3115 |            7 | 21.05        |      7582.34 |            0 |   -0.5       |      4207.64 | s            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43856 |            1 |              |            0 | Secretary/Receptionist      | 21002        |              |            0 |         3636 |              |              | 74-SENECA    |      28882.3 |          379 |              |           10 | 13197.36871866271  | State Highway 2, Takapau, Central Hawkes Bay |            1 |          101 |         2015 | Original Salary rebased with FY16 CAF | WSH            | WSHC00052BIA_L010            | C00052BIA_L010 | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment            | £m  | Blind year reconciliation 2014-15 | -0.98886915447701829   | -0.98886915447701829   | -0.98886915447701829   | -0.98886915447701829   | -0.98886915447701829   |
|         185 |           0 | 26011.270833333332 |           0 |           3 | Marché      |          67 |             |          22 |         122 | 0            | TPXX-EXP-CPD |         0    |         0.87 |          156 |            0 |         3671 |            0 |  1.56772e+07 |              |              |              | Rank         |  1.23835e+06 | 2646.6075767559923 |      12223.9 |     0.13632  |              |  2.88178e+07 |        287.5 |         3320 | Negative Change | TELEPHONE SERVICES            |            0 |           90 |           30 | Yes/No       | Optometry               |              | 0            |      250.031 |            0 |              | Revenues     |       109.25 |            0 |         2021 |      12290.9 | TOTAL THIS PERIOD |            0 |       0.8    |            0 |              | Cowl tray Lid to keep snow out                                                                    |      28.2317 |     1.03341  |           18 | Royal Wed Ring |           12 | HQP102       |     0.035111 |          236 |           93 |            0 |          330 |            2 | 21.05        |     24371    |            0 |   -0.0447504 |      2853.65 | z            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43856 |            1 |              |            0 | Administrative & Management | 034W         |              |            0 |         3636 |              |              | 74-SENECA    |      23981.2 |          283 |              |           10 | 77132.810264398562 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | NES            | NESC00052RC_L010             | C00052RC_L010  | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year    | £m  | Blind year reconciliation 2014-15 | 9.7236809696676971     | 9.7236809696676971     | 9.7236809696676971     | 9.7236809696676971     | 9.7236809696676971     |
|         185 |           1 | 36284.881249999999 |           0 |           3 | Marché      |          48 |             |          22 |          50 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  0           |              |              |              | Rank         |  1.23835e+06 | 166.17891          |      11402.3 |     0.13632  |              |  2.88178e+07 |        287.5 |         3320 | Negative Change | OFFICE STATIONERY             |            0 |          108 |           30 | 0            | Teacher Education       |              | 0            |      250.031 |            0 |              | Revenues     |       413.25 |            0 |         2021 |      12290.9 | TOTAL THIS PERIOD |            0 |      30.9992 |            0 |              | Full Width, Aerodynamic, Steel; 0.142" Material Thickness, Gloss Black bumper                     |     278.428  |     1.50743  |           18 | Royal Wed Ring |            2 | HQP102       |     0.035111 |          236 |            9 |            0 |         3115 |            5 | 21.05        |      7582.34 |            0 |   -0.2       |      4431.44 | z            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43828 |            1 |              |            0 | Other Non Reimbursable      | 034W         |              |            0 |         3636 |              |              | 74-SENECA    |      28882.3 |          379 |              |            5 | 5555.3665989256151 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | NES            | NESC00052BIA_L010            | C00052BIA_L010 | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment            | £m  | Blind year reconciliation 2014-15 | -2.7462152315910391    | -2.7462152315910391    | -2.7462152315910391    | -2.7462152315910391    | -2.7462152315910391    |
|          61 |           1 | 81834.207857879257 |           0 |           3 | Marché      |           0 |             |          22 |           2 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  0           |              |              |              | Rank         |  1.23835e+06 | 693.85953073076939 |      11108   |     0.13632  |              |  2.88178e+07 |        287.5 |         3387 | Negative Change | UTILITY SERVICES              |            0 |          111 |           30 | Yes/No       | Technology              |              | 0            |      250.031 |            0 |              | Revenues     |       394.25 |            0 |         2021 |      12290.9 | TOTAL THIS PERIOD |            0 |     151.033  |            0 |              | Cowl tray Lid to keep snow out                                                                    |      28.2317 |     0.984597 |           18 | Royal Wed Ring |         1087 | HQP102       |     0.035111 |          236 |           21 |            0 |          410 |            1 | 21.05        |      8028.91 |            0 |   -0.5       |     11578.6  | s            |              | Life and Annuity |              | Center Code & Name | CA00257      | No Change       |        43828 |            1 |              |            0 | Other Non Reimbursable      | 033W         |              |            0 |         3636 |              |              | 74-SENECA    |      23981.2 |          283 |              |            8 | 110858.37395951642 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2014 | Original Salary rebased with FY16 CAF | NES            | NESC00053RC_L010             | C00053RC_L010  | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year | £m  | Blind year reconciliation 2014-15 | 7.0693821575965332     | 7.0693821575965332     | 7.0693821575965332     | 7.0693821575965332     | 7.0693821575965332     |
|         185 |           0 | 57476.524019716235 |           0 |           3 | Marché      |          48 |             |          22 |          86 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  0           |              |              |              | Rank         |  1.23835e+06 | 1286.9348827972112 |      11691.4 |     0.286251 |              |  2.88178e+07 |        287.5 |         3321 | Negative Change | SEMINAR AND WORKSHOP          |            0 |          112 |           30 | 0            | Nursing                 |              | 0            |      250.031 |            0 |              | Revenues     |       451.25 |            0 |         2021 |      12290.9 | TOTAL THIS PERIOD |            0 |      30.9992 |            0 |              | Conventional 6-Man Crew Cab                                                                       |     278.428  |     0.984597 |           18 | Royal Wed Ring |            8 | HQP102       |     0.035111 |          236 |           96 |            0 |         3115 |            9 |  1.12307e+06 |      7582.34 |            0 |   -0.2       |      4301.64 | k            |              | Life and Annuity |              | Center Code & Name | CA00257      | No Change       |        43828 |            1 |              |            0 | Housekeeping                | 033W         |              |            1 |         3636 |              |              | 74-SENECA    |      28882.3 |          283 |              |            6 | 123047.84184856716 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | SVT            | SVTC00052RC_L010             | C00052RC_L010  | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year    | £m  | Blind year reconciliation 2014-15 | 5.6568253262844381     | 5.6568253262844381     | 5.6568253262844381     | 5.6568253262844381     | 5.6568253262844381     |
|         875 |           0 | 36284.881249999999 |           0 |           3 | MTN         |         106 |             |          22 |          74 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.24505e+08 |              |              |              | Rank         |  1.23835e+06 | 2130.508923397404  |      12673.6 |     0.286251 |              |  2.88178e+07 |        287.5 |         3787 | Negative Change | GRANT AND CONTRIBUTION        |            0 |           88 |           30 | Yes/No       | Business Administration | 0            | 0            |      250.031 |            0 |              | Revenues     |       109.25 |            0 |         2021 |      10912.5 | TOTAL THIS PERIOD |            0 |      19.6615 |            0 |              | Full Width, Aerodynamic, Steel; 0.142" Material Thickness, Gloss Black bumper                     |     278.428  |     1.50743  |           18 | Royal Wed Ring |            8 | HQP102       |     0.035111 |          236 |           96 |            0 |         1963 |            6 |  1.12307e+06 |      7658.23 |            0 |   -0.5       |      6332.21 | s            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43828 |            1 |              |            0 | Maintenance                 | 896W         |              |            0 |         3636 |              |              | 74-SENECA    |      23981.2 |          355 |              |            3 | 38246.526299980542 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | SVT            | SVTC00053RC_L010             | C00053RC_L010  | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year | £m  | Blind year reconciliation 2014-15 | -1.3413233421031709    | -1.3413233421031709    | -1.3413233421031709    | -1.3413233421031709    | -1.3413233421031709    |
|          61 |           1 | 16700.635416666668 |           0 |           3 | MTN         |          93 |             |          22 |         110 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.56772e+07 |              |              |              | Rank         |  1.23835e+06 | 3025.7107597064928 |      10856.9 |     0.353877 |              |  2.88178e+07 |        287.5 |         3349 | Negative Change | OFFICE STATIONERY             |            0 |          108 |           30 | Yes/No       | Business Administration |              |              |      250.031 |            0 |              | Revenues     |       337.25 |            0 |         2021 |      12290.9 | TOTAL THIS PERIOD |            0 |      12.5    |            0 |              | Steel, Swept Back bumper                                                                          |     278.428  |     1.50743  |           18 | Royal Wed Ring |            4 | HQP102       |     0.035111 |          236 |           33 |            0 |          410 |            3 |  1.12307e+06 |      7429.27 |            0 |   -0.5       |      6332.21 | t            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43856 |            1 |              |            0 | Activities                  | 21002        |              |            0 |         3636 |              |              | 74-SENECA    |      28882.3 |          355 |              |            3 | 56868.073671850994 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | SVT            | SVTC00053BIA_L010            | C00053BIA_L010 | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment         | £m  | Blind year reconciliation 2014-15 | -3.598208906293122     | -3.598208906293122     | -3.598208906293122     | -3.598208906293122     | -3.598208906293122     |
|          61 |           1 | 26011.270833333332 |           0 |           3 | MTN         |         106 |             |          22 |          98 | 0            | TPXX-EXP-CPD |         0    |         0.87 |          156 |            0 |         3671 |            0 |  0           |              |              |              | Rank         |  1.23835e+06 | 43.871818653846084 |      11414.9 |     0.353877 |              |  2.88178e+07 |        287.5 |         3349 | Negative Change | TELEPHONE SERVICES            |            0 |           83 |           30 | Yes/No       | Veterinary Science      |              | 0            |      250.031 |            0 |              | Revenues     |       128.25 |            0 |         2021 |      10883.9 | TOTAL THIS PERIOD |            0 |      12.5    |            0 |              | Full Width, Aerodynamic, Heavy Duty, Steel                                                        |      28.2317 |     2.32355  |           18 | Royal Wed Ring |         1087 | HQP102       |     0.035111 |          236 |           33 |            0 |          410 |            2 | 21.05        |      8100.8  |            0 |   -0.666667  |      4207.64 | k            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43856 |            1 |              |            0 | Activities                  | 21003        |              |            0 |         3636 |              |              | 74-SENECA    |      26666.6 |          379 |              |            4 | 77132.810264398562 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | SWT            | SWTC00052RC_L010             | C00052RC_L010  | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year    | £m  | Blind year reconciliation 2014-15 | 1.0890951199088661     | 1.0890951199088661     | 1.0890951199088661     | 1.0890951199088661     | 1.0890951199088661     |
|         185 |           2 | 57476.524019716235 |           0 |           3 | MTN         |          93 |             |          22 |          50 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.56772e+07 |              |              |              | Rank         |  1.23835e+06 | 2646.6075767559923 |      10803.4 |     0.353877 |              |  2.88178e+07 |        287.5 |         3611 | Negative Change | ENTERTAINMENT & HOSPIT.       |            0 |          113 |           30 | 0            | Engineering             |              |              |      250.031 |            0 |              | Revenues     |       470.25 |            0 |         2021 |      10912.5 | TOTAL THIS PERIOD |            0 |      43.8925 |            0 |              | Cowl tray Lid to keep snow out                                                                    |     278.428  |     0.976341 |           18 | Royal Wed Ring |            7 | HQP102       |     0.035111 |          236 |            9 |            0 |          410 |            8 | 21.05        |      7882.66 |            0 |   -0.2       |      3728.41 | t            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43828 |            1 |              |            0 | Administrative & Management | 21002W       |              |            0 |         3636 |              |              | 74-SENECA    |      23981.2 |          355 |              |            8 | 110858.37395951642 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | SWT            | SWTC00053RC_L010             | C00053RC_L010  | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year | £m  | Blind year reconciliation 2014-15 | -2.6394834420369642    | -2.6394834420369642    | -2.6394834420369642    | -2.6394834420369642    | -2.6394834420369642    |
|         875 |           0 | 7748.1020833333332 |           0 |           3 | Marché      |           0 |             |          22 |          86 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.56772e+07 |              |              |              | Rank         |  1.23835e+06 | 984.16286625438249 |      12910.6 |     0.353877 |              |  2.88178e+07 |        287.5 |         4450 | Negative Change | MISCELLANUEOUS                |            0 |           88 |           30 | 0            | Technology              |              | 0            |      250.031 |            0 |              | Revenues     |       318.25 |            0 |         2021 |      10912.5 | TOTAL THIS PERIOD |            0 |      37.6    |            0 |              | Steel, Swept Back bumper                                                                          |     278.428  |     1.03341  |           18 | Royal Wed Ring |           93 | HQP102       |     0.035111 |          236 |           21 |            0 |         3115 |            7 |  1.12307e+06 |      7808.46 |            0 |   -0.0705128 |      4388.48 | s            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43828 |            1 |              |            0 | Laundry                     | 896W         |              |            0 |         3636 |              |              | 74-SENECA    |      23981.2 |          355 |              |           11 | 38246.526299980542 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | SWT            | SWTC00053BIA_L010            | C00053BIA_L010 | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment         | £m  | Blind year reconciliation 2014-15 | 0.29921271869338717    | 0.29921271869338717    | 0.29921271869338717    | 0.29921271869338717    | 0.29921271869338717    |
|          61 |           2 | 57476.524019716235 |           0 |           3 | Marché      |         106 |             |          22 |          74 | 0            | TPXX-EXP-CPD |         0    |         0.87 |          156 |            0 |         3671 |            0 |  0           |              |              |              | Rank         |  1.23835e+06 | 693.85953073076939 |      12939.9 |     0.13632  |              |  2.88178e+07 |        287.5 |         3686 | Negative Change | ENTERTAINMENT & HOSPIT.       |            0 |          112 |           30 | 0            | Nursing                 |              | 0            |      250.031 |            0 |              | Revenues     |        71.25 |            0 |         2021 |      10883.9 | TOTAL THIS PERIOD |            0 |      17.9    |            0 |              | Full Width, Aerodynamic, Heavy Duty, Steel                                                        |     278.428  |     0.984597 |           18 | Royal Wed Ring |            0 | HQP102       |     0.035111 |          236 |           57 |            0 |         1963 |            9 |  1.12307e+06 |      7352.28 |            0 |   -0.2       |      4301.64 | k            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43856 |            1 |              |            0 | Housekeeping                | 033W         |              |            0 |         3636 |              |              | 74-SENECA    |      26666.6 |          355 |              |            7 | 110858.37395951642 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2014 | Original Salary rebased with FY16 CAF | TMS            | TMSC00053RC_L010             | C00053RC_L010  | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year | £m  | Blind year reconciliation 2014-15 | 14.859014924987168     | 14.859014924987168     | 14.859014924987168     | 14.859014924987168     | 14.859014924987168     |
|          61 |           2 | 36284.881249999999 |           0 |           3 | MTN         |          46 |             |          22 |           2 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.24505e+08 |              |              |              | Rank         |  1.23835e+06 | 693.85953073076939 |      12939.9 |     0.286251 |              |  2.88178e+07 |        287.5 |         3244 | Negative Change | MAINT. OF FURNITURE & EQUIPT. |            0 |          112 |           30 | 0            | Business Administration |              | 0            |      250.031 |            0 |              | Revenues     |       375.25 |            0 |         2021 |      10912.5 | TOTAL THIS PERIOD |            0 |      30.7507 |            0 |              | Steel, Swept Back bumper                                                                          |      28.2317 |     2.32355  |           18 | Royal Wed Ring |            1 | HQP102       |     0.035111 |          236 |           96 |            0 |         3115 |            6 | 21.05        |      7354.58 |            0 |   -0.5       |     11578.6  | k            |              | Life and Annuity |              | Center Code & Name | CA00257      | No Change       |        43828 |            1 |              |            0 | Activities                  | 896W         |              |            0 |         3636 |              |              | 74-SENECA    |      28882.3 |          379 |              |           10 | 87916.197518819361 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | TMS            | TMSC00053BIA_L010            | C00053BIA_L010 | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment         | £m  | Blind year reconciliation 2014-15 | -0.12484319449320969   | -0.12484319449320969   | -0.12484319449320969   | -0.12484319449320969   | -0.12484319449320969   |
|         875 |           1 | 69589.593114600968 |           0 |           3 | Airtel      |          46 |             |          22 |         146 | 2.18.15      | TPXX-EXP-CPD |         0    |         0.87 |          156 |            0 |         3671 |            0 |  0           |              |              |              | Rank         |  1.23835e+06 | 1601.8507276844423 |      11531.3 |     0.207965 |              |  2.88178e+07 |        287.5 |         3945 | Negative Change | OFFICE STATIONERY             |            0 |          108 |           30 | 0            | Law                     |              |              |      250.031 |            0 |              | Revenues     |       679.25 |            0 |         2021 |      12290.9 | TOTAL THIS PERIOD |            0 |      13.8    |            0 |              | (2) Safety Yellow                                                                                 |      47.7307 |     0.9845   |           18 | Royal Wed Ring |          863 | HQP102       |     0.035111 |          236 |           69 |            0 |         2035 |            7 |  1.12307e+06 |      7882.66 |            0 |   -0.5       |      6332.21 | z            |              | Life and Annuity |              | Center Code & Name | CA00257      | No Change       |        43856 |            1 |              |            0 | Maintenance                 | 21002W       |              |            0 |         3636 |              |              | 74-SENECA    |      23981.2 |          379 |              |           10 | 99153.014692461904 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | NWT            | NWTC00052BIA_L010            | C00052BIA_L010 | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment            | £m  | Blind year reconciliation 2014-15 | -0.68206417973015276   | -0.68206417973015276   | -0.68206417973015276   | -0.68206417973015276   | -0.68206417973015276   |
|         185 |           1 | 69589.593114600968 |           0 |           3 | Airtel      |          93 |             |          22 |         146 | 0            | TPXX-EXP-CPD |         0    |         0.87 |          156 |            0 |         3671 |            0 |  1.24505e+08 |              |              |              | Rank         |  1.23835e+06 | 984.16286625438249 |      11666.7 |     0.06816  |              |  2.88178e+07 |        287.5 |         3945 | Negative Change | SEMINAR AND WORKSHOP          |            0 |           90 |           30 | Yes/No       | Law                     | 0            |              |      250.031 |            0 |              | Revenues     |       622.25 |            0 |         2021 |      10912.5 | TOTAL THIS PERIOD |            0 |      24.0799 |            0 |              | All Orange; 1 to 3 seat belt                                                                      |      47.7307 |     1.7475   |           18 | Royal Wed Ring |          863 | HQP102       |     0.035111 |          236 |           21 |            0 |         3115 |            8 | 21.05        |      7582.34 |            0 |   -0.666667  |     11578.6  | k            |              | Life and Annuity |              | Center Code & Name | CA00257      | No Change       |        43856 |            1 |              |            0 | Other Non Reimbursable      | 21002W       |              |            0 |         3636 |              |              | 74-SENECA    |      28882.3 |          379 |              |            9 | 110858.37395951642 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | NWT            | NWTC00053RC_L010             | C00053RC_L010  | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year | £m  | Blind year reconciliation 2014-15 | 14.729055676163789     | 14.729055676163789     | 14.729055676163789     | 14.729055676163789     | 14.729055676163789     |
|          61 |           0 | 46546.979400605414 |           0 |           3 | MTN         |         137 |             |          22 |         146 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.56772e+07 |              |              |              | Rank         |  1.23835e+06 | 984.16286625438249 |      10553.8 |     0.207965 |              |  2.88178e+07 |        287.5 |         3686 | Negative Change | OFFICE STATIONERY             |            0 |           88 |           30 | 0            | Totals                  |              | 0            |      250.031 |            0 |              | Revenues     |       299.25 |            0 |         2021 |      12290.9 | TOTAL THIS PERIOD |            0 |       0.1    |            0 |              | All Orange; 1 to 3 seat belt                                                                      |     278.428  |     0.984597 |           18 | Royal Wed Ring |           41 | HQP102       |     0.035111 |          236 |           93 |            0 |         1658 |            9 |  1.12307e+06 |      7808.46 |            0 |   -0.3       |      4388.48 | a            |              | Life and Annuity |              | Center Code & Name | CA00257      | No Change       |        43828 |            1 |              |            0 | Dietary                     | 21002W       |              |            0 |         3636 |              |              | 74-SENECA    |      28882.3 |          283 |              |           13 | 47358.660542197489 | State Highway 2, Takapau, Central Hawkes Bay |            1 |          101 |         2015 | Original Salary rebased with FY16 CAF | WSX            | WSXC00052BIA_L010            | C00052BIA_L010 | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment            | £m  | Blind year reconciliation 2014-15 | 9.7016049229613613E-2  | 9.7016049229613613E-2  | 9.7016049229613613E-2  | 9.7016049229613613E-2  | 9.7016049229613613E-2  |
|          61 |           0 | 69589.593114600968 |           0 |           3 | Marché      |           0 |             |          22 |         146 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.24505e+08 |              |              |              | Rank         |  1.23835e+06 | 1601.8507276844423 |      10710.4 |     0.286251 |              |  2.88178e+07 |        287.5 |         3349 | Negative Change | TELEPHONE SERVICES            |            0 |           88 |           30 | 0            | Physical Training       | 0            | 0            |      250.031 |            0 |              | Revenues     |       242.25 |            0 |         2021 |      10883.9 | TOTAL THIS PERIOD |            0 |       0.3    |            0 |              | Full Width, Aerodynamic, Heavy Duty, Steel                                                        |      47.7307 |     2.32355  |           18 | Royal Wed Ring |         1087 | HQP102       |     0.035111 |          236 |           21 |            0 |          410 |            8 | 21.05        |      7352.28 |            0 |   -0.0705128 |      4207.64 | z            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43856 |            1 |              |            0 | Dietary                     | 033W         |              |            0 |         3636 |              |              | 74-SENECA    |      26666.6 |          379 |              |           13 | 123047.84184856716 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | WSX            | WSXC00053RC_L010             | C00053RC_L010  | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year | £m  | Blind year reconciliation 2014-15 | -1.52102790636062      | -1.52102790636062      | -1.52102790636062      | -1.52102790636062      | -1.52102790636062      |
|         185 |           0 | 57476.524019716235 |           0 |           3 | Marché      |          46 |             |          22 |          38 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  0           |              |              |              | Rank         |  1.23835e+06 | 166.17891          |      12939.9 |     0.353877 |              |  2.88178e+07 |        287.5 |         3387 | Negative Change | MISCELLANUEOUS                |            0 |          113 |           30 | Yes/No       | Veterinary Science      |              |              |      250.031 |            0 |              | Revenues     |       185.25 |            0 |         2021 |      10912.5 | TOTAL THIS PERIOD |            0 |      44.0564 |            0 |              | Steel, Swept Back bumper                                                                          |      47.7307 |     2.22316  |           18 | Royal Wed Ring |           12 | HQP102       |     0.035111 |          236 |           45 |            0 |          410 |            1 | 21.05        |      7506    |            0 |   -0.3       |     11578.6  | z            |              | Life and Annuity |              | Center Code & Name | CA00257      | No Change       |        43828 |            1 |              |            0 | Social Service              | 033W         |              |            0 |         3636 |              |              | 74-SENECA    |      28882.3 |          355 |              |           14 | 21162.351818046038 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | WSX            | WSXC00053BIA_L010            | C00053BIA_L010 | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment         | £m  | Blind year reconciliation 2014-15 | 0.14208211545477389    | 0.14208211545477389    | 0.14208211545477389    | 0.14208211545477389    | 0.14208211545477389    |
|          61 |           1 | 26011.270833333332 |           0 |           3 | Marché      |         120 |             |          22 |         134 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  0           |              |              |              | Rank         |  1.23835e+06 | 3832.3750308448734 |      11105.5 |     0.13632  |              |  2.88178e+07 |        287.5 |         3538 | Negative Change | TRANSPORT AND TRAVELLING      |            0 |          112 |           30 | Yes/No       | Fine Arts               | 0            | 0            |      250.031 |            0 |              | Revenues     |       470.25 |            0 |         2021 |      12290.9 | TOTAL THIS PERIOD |            0 |       0.7    |            0 |              | Steel, Swept Back bumper                                                                          |      47.7307 |     0.9845   |           18 | Royal Wed Ring |           47 | HQP102       |     0.035111 |          236 |           33 |            0 |         2035 |            4 |  1.12307e+06 |      7352.28 |            0 |   -0.3       |      4796.82 | a            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43856 |            1 |              |            0 | Medical Records             | 21002W       |              |            0 |         3636 |              |              | 74-SENECA    |      26666.6 |          379 |              |           12 | 110858.37395951642 | State Highway 2, Takapau, Central Hawkes Bay |            1 |          101 |         2015 | Original Salary rebased with FY16 CAF | YKY            | YKYC00052BIA_L010            | C00052BIA_L010 | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment            | £m  | Blind year reconciliation 2014-15 | -0.1080673034500893    | -0.1080673034500893    | -0.1080673034500893    | -0.1080673034500893    | -0.1080673034500893    |
|         875 |           2 | 7748.1020833333332 |           0 |           3 | Airtel      |          48 |             |          22 |          14 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.24505e+08 |              |              |              | Rank         |  1.23835e+06 | 2282.9636866986202 |      11108   |     0.286251 |              |  2.88178e+07 |        287.5 |         3686 | Negative Change | TELEPHONE SERVICES            |            0 |           88 |           30 | 0            | Physical Training       |              | 0            |      250.031 |            0 |              | Revenues     |       242.25 |            0 |         2021 |      12290.9 | TOTAL THIS PERIOD |            0 |       1.3    |            0 |              | Cowl tray Lid to keep snow out                                                                    |      28.2317 |     0.983174 |           18 | Royal Wed Ring |            0 | HQP102       |     0.035111 |          236 |           96 |            0 |         3115 |            7 | 21.05        |      7882.66 |            0 |   -0.2       |     11578.6  | k            |              | Life and Annuity |              | Center Code & Name | CA00257      | No Change       |        43856 |            1 |              |            0 | Dietary                     | 21002        |              |            0 |         3636 |              |              | 74-SENECA    |      26666.6 |          379 |              |           14 | 77132.810264398562 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | BRL            | BRLC00052RC_L010             | C00052RC_L010  | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year    | £m  | Blind year reconciliation 2014-15 | 0.69131418799755451    | 0.69131418799755451    | 0.69131418799755451    | 0.69131418799755451    | 0.69131418799755451    |
|         185 |           2 | 57476.524019716235 |           0 |           3 | Airtel      |          46 |             |          22 |         122 | 0            | TPXX-EXP-CPD |         0    |         0.87 |          156 |            0 |         3671 |            0 |  1.56772e+07 |              |              |              | Rank         |  1.23835e+06 | 166.17891          |      12726.7 |     0.06816  |              |  2.88178e+07 |        287.5 |         4016 | Negative Change | SEMINAR AND WORKSHOP          |            0 |           92 |           30 | Yes/No       | Fine Arts               |              | 0            |      250.031 |            0 |              | Revenues     |       622.25 |            0 |         2021 |      12290.9 | TOTAL THIS PERIOD |            0 |      37.6    |            0 |              | {Lang Mekra} Right Side; 6" x 10 1/4", With Bright Finish                                         |      47.7307 |     1.7475   |           18 | Royal Wed Ring |           93 | HQP102       |     0.035111 |          236 |           81 |            0 |         1105 |            9 |  1.12307e+06 |      7882.66 |            0 |   -0.0447504 |      4403.9  | k            |              | Life and Annuity |              | Center Code & Name | CA00257      | No Change       |        43856 |            1 |              |            0 | Social Service              | 21003        |              |            1 |         3636 |              |              | 74-SENECA    |      23981.2 |          355 |              |           12 | 38246.526299980542 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | BRL            | BRLC00053RC_L010             | C00053RC_L010  | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year | £m  | Blind year reconciliation 2014-15 | 0                      | 0                      | 0                      | 0                      | 0                      |
|         185 |           1 | 81834.207857879257 |           0 |           3 | Airtel      |         135 |             |          22 |          50 | 2.18.15      | TPXX-EXP-CPD |         0    |         0.87 |          156 |            0 |         3671 |            0 |  1.24505e+08 |              |              |              | Rank         |  1.23835e+06 | 166.17891          |      10781.2 |     0.06816  |              |  2.88178e+07 |        287.5 |         4450 | Negative Change | MISCELLANUEOUS                |            0 |          108 |           30 | 0            | Fine Arts               |              | 0            |      250.031 |            0 |              | Revenues     |       527.25 |            0 |         2021 |      10912.5 | TOTAL THIS PERIOD |            0 |      22.1    |            0 |              | Steel, Swept Back bumper                                                                          |      47.7307 |     0.9845   |           18 | Royal Wed Ring |            1 | HQP102       |     0.035111 |          236 |            9 |            0 |         3115 |            9 | 21.05        |     24371    |            0 |   -0.175     |      4301.64 | t            |              | Life and Annuity |              | Center Code & Name | CA00257      | No Change       |        43828 |            1 |              |            0 | Dietary                     | 033W         |              |            1 |         3636 |              |              | 74-SENECA    |      23981.2 |          355 |              |            7 | 77132.810264398562 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | CAM            | CAMC00052RC_L010             | C00052RC_L010  | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year    | £m  | Blind year reconciliation 2014-15 | 0.3225787199722418     | 0.3225787199722418     | 0.3225787199722418     | 0.3225787199722418     | 0.3225787199722418     |
|          61 |           0 | 36284.881249999999 |           0 |           3 | MTN         |         135 |             |          22 |           2 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.24505e+08 |              |              |              | Rank         |  1.23835e+06 | 984.16286625438249 |      10934.9 |     0.353877 |              |  2.88178e+07 |        287.5 |         3832 | Negative Change | OFFICE STATIONERY             |            0 |           88 |           30 | 0            | Physical Training       |              | 0            |      250.031 |            0 |              | Revenues     |       204.25 |            0 |         2021 |      10883.9 | TOTAL THIS PERIOD |            0 |       0.1    |            0 |              | Steel, Swept Back bumper                                                                          |      47.7307 |     0.976341 |           18 | Royal Wed Ring |           47 | HQP102       |     0.035111 |          236 |           93 |            0 |          410 |            5 |  1.12307e+06 |      7506    |            0 |   -0.5       |      4388.48 | a            |              | Life and Annuity |              | Center Code & Name | CA00257      | No Change       |        43828 |            1 |              |            0 | All Therapy                 | 21002        |              |            1 |         3636 |              |              | 74-SENECA    |      28882.3 |          379 |              |           11 | 87916.197518819361 | State Highway 2, Takapau, Central Hawkes Bay |            5 |          101 |         2015 | Original Salary rebased with FY16 CAF | CAM            | CAMC00052BIA_L010            | C00052BIA_L010 | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment            | £m  | Blind year reconciliation 2014-15 | -2.4334860138071443E-2 | -2.4334860138071443E-2 | -2.4334860138071443E-2 | -2.4334860138071443E-2 | -2.4334860138071443E-2 |
|         875 |           8 | 57476.524019716235 |           0 |           3 | Marché      |           0 |             |          22 |          26 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.24505e+08 |              |              |              | Rank         |  1.23835e+06 | 2282.9636866986202 |      10627.4 |     0.286251 |              |  2.88178e+07 |        287.5 |         3538 | Negative Change | UTILITY SERVICES              |            0 |           83 |           30 | Yes/No       | Physical Training       |              | 0            |      250.031 |            0 |              | Revenues     |       242.25 |            0 |         2021 |      10912.5 | TOTAL THIS PERIOD |            0 |       1.3    |            0 |              | Heated windshield                                                                                 |      47.7307 |     0.984597 |           18 | Royal Wed Ring |            0 | HQP102       |     0.035111 |          236 |           81 |            0 |         3115 |            1 |  1.12307e+06 |      8028.91 |            0 |   -0.0705128 |      4207.64 | z            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43856 |            1 |              |            0 | All Therapy                 | 033W         |              |            0 |         3636 |              |              | 74-SENECA    |      26666.6 |          379 |              |           12 | 13197.36871866271  | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | CAM            | CAMC00053RC_L010             | C00053RC_L010  | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year | £m  | Blind year reconciliation 2014-15 | 0                      | 0                      | 0                      | 0                      | 0                      |
|         185 |           2 | 69589.593114600968 |           0 |           3 | Airtel      |         135 |             |          22 |         134 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  0           |              |              |              | Rank         |  1.23835e+06 | 2646.6075767559923 |      10803.4 |     0.286251 |              |  2.88178e+07 |        287.5 |         3385 | Negative Change | MAINT. OF FURNITURE & EQUIPT. |            0 |           90 |           30 | 0            | Physical Training       |              | 0            |      250.031 |            0 |              | Revenues     |       413.25 |            0 |         2021 |      10883.9 | TOTAL THIS PERIOD |            0 |       0.3    |            0 |              | Full Width, Aerodynamic, Chrome Plated Steel; 0.142" Material Thickness bumper                    |      28.2317 |     0.998067 |           18 | Royal Wed Ring |            3 | HQP102       |     0.035111 |          236 |           21 |            0 |          330 |            7 |  1.12307e+06 |      7352.28 |            0 |   -0.2       |      4796.82 | s            |              | Life and Annuity |              | Center Code & Name | CA00257      | No Change       |        43828 |            1 |              |            0 | Maintenance                 | 21002W       |              |            0 |         3636 |              |              | 74-SENECA    |      28882.3 |          283 |              |            1 | 29518.668881811675 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | CAM            | CAMC00053BIA_L010            | C00053BIA_L010 | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment         | £m  | Blind year reconciliation 2014-15 | 0                      | 0                      | 0                      | 0                      | 0                      |
|         875 |           0 | 7748.1020833333332 |           0 |           3 | Marché      |         137 |             |          22 |           2 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.56772e+07 |              |              |              | Rank         |  1.23835e+06 | 1934.2688210738866 |      11335.5 |     0.353877 |              |  2.88178e+07 |        287.5 |         3945 | Negative Change | TRANSPORT AND TRAVELLING      |            0 |          111 |           30 | 0            | Health Services         | 0            | 0            |      250.031 |            0 |              | Revenues     |       527.25 |            0 |         2021 |      10883.9 | TOTAL THIS PERIOD |            0 |       0.2    |            0 |              | {Lang Mekra} Right Side; 6" x 10 1/4", With Bright Finish                                         |      28.2317 |     0.984514 |           18 | Royal Wed Ring |            7 | HQP102       |     0.035111 |          236 |           93 |            0 |         1963 |            2 |  1.12307e+06 |      8028.91 |            0 |   -0.0209118 |      3728.41 | a            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43856 |            1 |              |            0 | Administrative & Management | 896W         |              |            0 |         3636 |              |              | 74-SENECA    |      26666.6 |          379 |              |            8 | 87916.197518819361 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | DVW            | DVWC00053RC_L010             | C00053RC_L010  | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year | £m  | Blind year reconciliation 2014-15 | 0                      | 0                      | 0                      | 0                      | 0                      |
|          61 |           1 | 46546.979400605414 |           0 |           3 | Marché      |          67 |             |          22 |          26 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  0           |              |              |              | Rank         |  1.23835e+06 | 166.17891          |      11414.9 |     0.286251 |              |  2.88178e+07 |        287.5 |         3600 | Negative Change | GRANT AND CONTRIBUTION        |            0 |           90 |           30 | Yes/No       | Law                     | 0            | 0            |      250.031 |            0 |              | Revenues     |       280.25 |            0 |         2021 |      12290.9 | TOTAL THIS PERIOD |            0 |       0.3    |            0 |              | {Lang Mekra} Right Side; 6" x 10 1/4", With Bright Finish                                         |      28.2317 |     1.7475   |           18 | Royal Wed Ring |            7 | HQP102       |     0.035111 |          236 |            9 |            0 |         1963 |            1 |  1.12307e+06 |      7882.66 |            0 |   -0.175     |      4301.64 | k            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43828 |            1 |              |            0 | Officers                    | 034W         |              |            0 |         3636 |              |              | 74-SENECA    |      26666.6 |          283 |              |            1 | 56868.073671850994 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | PRT            | PRTC00052RC_L010             | C00052RC_L010  | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year    | £m  | Blind year reconciliation 2014-15 | 1.9268429358921144     | 1.9268429358921144     | 1.9268429358921144     | 1.9268429358921144     | 1.9268429358921144     |
|          61 |           0 |                    |           0 |           3 | Airtel      |           0 |             |          22 |          86 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.24505e+08 |              |              |              | Rank         |  1.23835e+06 | 1934.2688210738866 |      12415.5 |     0.06816  |              |  2.88178e+07 |        287.5 |         3320 | Negative Change | ENTERTAINMENT & HOSPIT.       |            0 |           90 |           30 | 0            | Nursing                 | 0            | 0            |      250.031 |            0 |              | Revenues     |       242.25 |            0 |         2021 |      12290.9 | TOTAL THIS PERIOD |            0 |       0.8    |            0 |              | (2) Safety Yellow                                                                                 |      28.2317 |     0.984597 |           18 | Royal Wed Ring |            1 | HQP102       |     0.035111 |          236 |           81 |            0 |          410 |            2 |  1.12307e+06 |      7808.46 |            0 |   -0.175     |     11578.6  | s            |              | Life and Annuity |              | Center Code & Name | CA00257      | No Change       |        43828 |            1 |              |            0 | Other Non Reimbursable      | 21002W       |              |            0 |         3636 |              |              | 74-SENECA    |      23981.2 |          355 |              |            8 | 77132.810264398562 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | PRT            | PRTC00052BIA_L010            | C00052BIA_L010 | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment            | £m  | Blind year reconciliation 2014-15 | -0.12842336284464348   | -0.12842336284464348   | -0.12842336284464348   | -0.12842336284464348   | -0.12842336284464348   |
|          61 |           8 | 26011.270833333332 |           0 |           3 | Marché      |         120 |             |          22 |         122 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.24505e+08 |              |              |              | Rank         |  1.23835e+06 | 2282.9636866986202 |      10542.8 |     0.13632  |              |  2.88178e+07 |        287.5 |         3686 | Negative Change | TRAINING & STAFF DEVT.        |            0 |          112 |           30 | 0            | Physical Training       |              | 0            |      250.031 |            0 |              | Revenues     |       109.25 |            0 |         2021 |      12290.9 | TOTAL THIS PERIOD |            0 |      17.4919 |            0 |              | Heated windshield                                                                                 |     278.428  |     1.7475   |           18 | Royal Wed Ring |            0 | HQP102       |     0.035111 |          236 |           81 |            0 |         2035 |            6 | 21.05        |      7733.63 |            0 |   -0.0447504 |      4301.64 | s            |              | Life and Annuity |              | Center Code & Name | CA00257      | No Change       |        43856 |            1 |              |            0 | Officers                    | 21002W       |              |            1 |         3636 |              |              | 74-SENECA    |      23981.2 |          379 |              |            7 | 38246.526299980542 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | PRT            | PRTC00053RC_L010             | C00053RC_L010  | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year | £m  | Blind year reconciliation 2014-15 | 0                      | 0                      | 0                      | 0                      | 0                      |
|          61 |           1 | 69589.593114600968 |           0 |           3 | Marché      |           0 |             |          22 |          50 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  0           |              |              |              | Rank         |  1.23835e+06 | 3025.7107597064928 |      11691.4 |     0.353877 |              |  2.88178e+07 |        287.5 |         3686 | Negative Change | OFFICE STATIONERY             |            0 |           88 |           30 | 0            | Science                 |              | 0            |      250.031 |            0 |              | Revenues     |       413.25 |            0 |         2021 |      10912.5 | TOTAL THIS PERIOD |            0 |      12.5    |            0 |              | {Lang Mekra} Right Side; 6" x 10 1/4", With Bright Finish                                         |      47.7307 |     0.998067 |           18 | Royal Wed Ring |            7 | HQP102       |     0.035111 |          236 |           69 |            0 |         1963 |            3 |  1.12307e+06 |      7352.28 |            0 |   -0.175     |     11578.6  | a            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43856 |            1 |              |            0 | Housekeeping                | 034W         |              |            0 |         3636 |              |              | 74-SENECA    |      26666.6 |          355 |              |           14 | 13197.36871866271  | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | PRT            | PRTC00053BIA_L010            | C00053BIA_L010 | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment         | £m  | Blind year reconciliation 2014-15 | 0                      | 0                      | 0                      | 0                      | 0                      |
|         185 |           0 |                    |           0 |           3 | Marché      |         120 |             |          22 |         146 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.24505e+08 |              |              |              | Rank         |  1.23835e+06 | 1601.8507276844423 |      12156.6 |     0.353877 |              |  2.88178e+07 |        287.5 |         3867 | Negative Change | SEMINAR AND WORKSHOP          |            0 |           88 |           30 | 0            | Agriculture             |              | 0            |      250.031 |            0 |              | Revenues     |       375.25 |            0 |         2021 |      10912.5 | TOTAL THIS PERIOD |            0 |     231.232  |            0 |              | (2) Chrome; Towel Bar Type With Anti-Slip Rubber Inserts; Mounted Left and Right Side on Exterior |      47.7307 |     0.998067 |           18 | Royal Wed Ring |           47 | HQP102       |     0.035111 |          236 |           45 |            0 |         1658 |            7 |  1.12307e+06 |      7506    |            0 |   -0.0209118 |      3728.41 | s            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43856 |            1 |              |            0 | Officers                    | 033W         |              |            0 |         3636 |              |              | 74-SENECA    |      23981.2 |          283 |              |           12 | 99153.014692461904 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | SBW            | SBWC00052RC_L010             | C00052RC_L010  | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year    | £m  | Blind year reconciliation 2014-15 | -0.41275174940647996   | -0.41275174940647996   | -0.41275174940647996   | -0.41275174940647996   | -0.41275174940647996   |
|         185 |           2 | 26011.270833333332 |           0 |           3 | Airtel      |          93 |             |          22 |         110 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.56772e+07 |              |              |              | Rank         |  1.23835e+06 | 693.85953073076939 |      11643.5 |     0.06816  |              |  2.88178e+07 |        287.5 |         3320 | Negative Change | UTILITY SERVICES              |            0 |           86 |           30 | Yes/No       | Social Service          |              | 0            |      250.031 |            0 |              | Revenues     |       622.25 |            0 |         2021 |      10883.9 | TOTAL THIS PERIOD |            0 |      14.6    |            0 |              | Cowl tray Lid to keep snow out                                                                    |     278.428  |     2.32355  |           18 | Royal Wed Ring |         1087 | HQP102       |     0.035111 |          236 |           69 |            0 |         1963 |            8 | 21.05        |      7506    |            0 |   -0.175     |      4388.48 | k            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43828 |            1 |              |            0 | All Therapy                 | 21003        |              |            0 |         3636 |              |              | 74-SENECA    |      23981.2 |          379 |              |            1 | 5555.3665989256151 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | SBW            | SBWC00052BIA_L010            | C00052BIA_L010 | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment            | £m  | Blind year reconciliation 2014-15 | 1.0427202450565031E-3  | 1.0427202450565031E-3  | 1.0427202450565031E-3  | 1.0427202450565031E-3  | 1.0427202450565031E-3  |
|         875 |           0 | 69589.593114600968 |           0 |           3 | Airtel      |          48 |             |          22 |          74 | 0            | TPXX-EXP-CPD |         0    |         0.87 |          156 |            0 |         3671 |            0 |  0           |              |              |              | Rank         |  1.23835e+06 | 3420.7889609568006 |      13324.4 |     0.286251 |              |  2.88178e+07 |        287.5 |         3686 | Negative Change | SEMINAR AND WORKSHOP          |            0 |          112 |           30 | 0            | Business Administration |              |              |      250.031 |            0 |              | Revenues     |       204.25 |            0 |         2021 |      10883.9 | TOTAL THIS PERIOD |            0 |      13.5    |            0 |              | Heated windshield                                                                                 |      47.7307 |     0.9845   |           18 | Royal Wed Ring |            2 | HQP102       |     0.035111 |          236 |           69 |            0 |          410 |            2 | 21.05        |      7658.23 |            0 |   -0.0447504 |      4278.09 | z            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43828 |            1 |              |            0 | All Therapy                 | 21002        |              |            0 |         3636 |              |              | 74-SENECA    |      28882.3 |          379 |              |            4 | 87916.197518819361 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | SBW            | SBWC00053BIA_L010            | C00053BIA_L010 | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment         | £m  | Blind year reconciliation 2014-15 | 0                      | 0                      | 0                      | 0                      | 0                      |
|         185 |           1 |                    |           0 |           3 | MTN         |          46 |             |          22 |         110 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.24505e+08 |              |              |              | Rank         |  1.23835e+06 | 43.871818653846084 |      13313.7 |     0.207965 |              |  2.88178e+07 |        287.5 |         4450 | Negative Change | ENTERTAINMENT & HOSPIT.       |            0 |           86 |           30 | Yes/No       | Health Services         |              | 0            |      250.031 |            0 |              | Revenues     |        90.25 |            0 |         2021 |      10912.5 | TOTAL THIS PERIOD |            0 |       0.8    |            0 |              | Cowl tray Lid to keep snow out                                                                    |     278.428  |     1.03341  |           18 | Royal Wed Ring |           93 | HQP102       |     0.035111 |          236 |           81 |            0 |          410 |            6 | 21.05        |      7956.17 |            0 |   -0.175     |      4301.64 | z            |              | Life and Annuity |              | Center Code & Name | CA00257      | No Change       |        43856 |            1 |              |            0 | All Therapy                 | 21002W       |              |            0 |         3636 |              |              | 74-SENECA    |      23981.2 |          283 |              |           11 |                    | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | SEW            | SEWC00052BIA_L010            | C00052BIA_L010 | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment            | £m  | Blind year reconciliation 2014-15 | -0.71298201014763318   | -0.71298201014763318   | -0.71298201014763318   | -0.71298201014763318   | -0.71298201014763318   |
|         185 |           0 | 81834.207857879257 |           0 |           3 | Airtel      |         106 |             |          22 |           2 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.56772e+07 |              |              |              | Rank         |  1.23835e+06 | 1601.8507276844423 |      10627.4 |     0.286251 |              |  2.88178e+07 |        287.5 |         3387 | Negative Change | OFFICE STATIONERY             |            0 |           92 |           30 | Yes/No       | Totals                  |              | 0            |      250.031 |            0 |              | Revenues     |       356.25 |            0 |         2021 |      10912.5 | TOTAL THIS PERIOD |            0 |      10.6    |            0 |              | Full Width, Aerodynamic, Chrome Plated Steel; 0.142" Material Thickness bumper                    |     278.428  |     0.984597 |           18 | Royal Wed Ring |            4 | HQP102       |     0.035111 |          236 |           81 |            0 |         1105 |            7 |  1.12307e+06 |      7352.28 |            0 |   -0.0209118 |      6332.21 | z            |              | Life and Annuity |              | Center Code & Name | CA00257      | No Change       |        43828 |            1 |              |            0 | Laundry                     | 21002        |              |            0 |         3636 |              |              | 74-SENECA    |      28882.3 |          355 |              |            3 | 56868.073671850994 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | SEW            | SEWC00053RC_L010             | C00053RC_L010  | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year | £m  | Blind year reconciliation 2014-15 | 0                      | 0                      | 0                      | 0                      | 0                      |
|         875 |           0 | 57476.524019716235 |           0 |           3 | MTN         |         137 |             |          22 |          38 | 0            | TPXX-EXP-CPD |         0    |         0.87 |          156 |            0 |         3671 |            0 |  1.24505e+08 |              |              |              | Rank         |  1.23835e+06 | 984.16286625438249 |      12143.4 |     0.353877 |              |  2.88178e+07 |        287.5 |         3385 | Negative Change | TELEPHONE SERVICES            |            0 |          111 |           30 | 0            | Vocational Training     |              | 0            |      250.031 |            0 |              | Revenues     |       584.25 |            0 |         2021 |      10883.9 | TOTAL THIS PERIOD |            0 |       2.9    |            0 |              | Full Width, Aerodynamic, Steel; 0.142" Material Thickness, Gloss Black bumper                     |      47.7307 |     0.9845   |           18 | Royal Wed Ring |           12 | HQP102       |     0.035111 |          236 |            9 |            0 |         2035 |            8 |  1.12307e+06 |      8028.91 |            0 |   -0.0209118 |      4301.64 | a            |              | Life and Annuity |              | Center Code & Name | CA00257      | No Change       |        43828 |            1 |              |            0 | Medical Records             | 034W         |              |            0 |         3636 |              |              | 74-SENECA    |      26666.6 |          283 |              |           13 | 29518.668881811675 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | SEW            | SEWC00053BIA_L010            | C00053BIA_L010 | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment         | £m  | Blind year reconciliation 2014-15 | 0                      | 0                      | 0                      | 0                      | 0                      |
|         875 |           8 |                    |           0 |           3 | Airtel      |          93 |             |          22 |          98 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.24505e+08 |              |              |              | Rank         |  1.23835e+06 |                    |      13604.1 |     0.13632  |              |  2.88178e+07 |        287.5 |         4450 | Negative Change | UTILITY SERVICES              |            0 |           92 |           30 | 0            | Teacher Education       |              | 0            |      250.031 |            0 |              | Revenues     |       527.25 |            0 |         2021 |      10912.5 | TOTAL THIS PERIOD |            0 |      18.6064 |            0 |              | Cowl tray Lid to keep snow out                                                                    |     278.428  |     0.984597 |           18 | Royal Wed Ring |            8 | HQP102       |     0.035111 |          236 |           57 |            0 |          410 |            6 |  1.12307e+06 |      7733.63 |            0 |   -0.5       |      4403.9  | z            |              | Life and Annuity |              | Center Code & Name | CA00257      | No Change       |        43856 |            1 |              |            0 | Dietary                     | 034W         |              |            1 |         3636 |              |              | 74-SENECA    |      26666.6 |          283 |              |           14 |                    | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | SST            | SSTC00052RC_L010             | C00052RC_L010  | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year    | £m  | Blind year reconciliation 2014-15 | 1.6530697071349734     | 1.6530697071349734     | 1.6530697071349734     | 1.6530697071349734     | 1.6530697071349734     |
|         875 |           1 | 7748.1020833333332 |           0 |           3 | MTN         |          46 |             |          22 |          50 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.24505e+08 |              |              |              | Rank         |  1.23835e+06 | 2282.9636866986202 |      11414.9 |     0.353877 |              |  2.88178e+07 |        287.5 |         3832 | Negative Change | TRANSPORT AND TRAVELLING      |            0 |           86 |           30 | 0            | Home Economics          |              |              |      250.031 |            0 |              | Revenues     |       679.25 |            0 |         2021 |      12290.9 | TOTAL THIS PERIOD |            0 |      13.8    |            0 |              | Cowl tray Lid to keep snow out                                                                    |      47.7307 |     1.50743  |           18 | Royal Wed Ring |           41 | HQP102       |     0.035111 |          236 |           81 |            0 |          410 |            7 |  1.12307e+06 |      7352.28 |            0 |   -0.2       |      4403.9  | z            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43856 |            1 |              |            0 | Activities                  | 034W         |              |            0 |         3636 |              |              | 74-SENECA    |      23981.2 |          379 |              |            9 |                    | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | SST            | SSTC00052BIA_L010            | C00052BIA_L010 | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment            | £m  | Blind year reconciliation 2014-15 | 0.48591652227481685    | 0.48591652227481685    | 0.48591652227481685    | 0.48591652227481685    | 0.48591652227481685    |
|         185 |           1 |                    |           0 |           3 | MTN         |          46 |             |          22 |          98 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.56772e+07 |              |              |              | Rank         |  1.23835e+06 | 3420.7889609568006 |      12156.6 |     0.286251 |              |  2.88178e+07 |        287.5 |         3867 | Negative Change | OFFICE STATIONERY             |            0 |           86 |           30 | Yes/No       | Fine Arts               |              |              |      250.031 |            0 |              | Revenues     |       337.25 |            0 |         2021 |      12290.9 | TOTAL THIS PERIOD |            0 |     151.033  |            0 |              | Full Width, Aerodynamic, Chrome Plated Steel; 0.142" Material Thickness bumper                    |      47.7307 |     2.22316  |           18 | Royal Wed Ring |            1 | HQP102       |     0.035111 |          236 |           21 |            0 |         1658 |            6 |  1.12307e+06 |      7808.46 |            0 |   -0.2       |      4796.82 | k            |              | Life and Annuity |              | Center Code & Name | CA00257      | No Change       |        43856 |            1 |              |            0 | Dietary                     | 033W         |              |            0 |         3636 |              |              | 74-SENECA    |      26666.6 |          283 |              |            7 | 47358.660542197489 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | SST            | SSTC00053RC_L010             | C00053RC_L010  | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year | £m  | Blind year reconciliation 2014-15 | 0                      | 0                      | 0                      | 0                      | 0                      |
|         185 |           8 | 57476.524019716235 |           0 |           3 | Airtel      |           0 |             |          22 |          26 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  1.56772e+07 |              |              |              | Rank         |  1.23835e+06 | 3025.7107597064928 |      13287   |     0.207965 |              |  2.88178e+07 |        287.5 |         3686 | Negative Change | TELEPHONE SERVICES            |            0 |           86 |           30 | 0            | Optometry               | 0            | 0            |      250.031 |            0 |              | Revenues     |       299.25 |            0 |         2021 |      10883.9 | TOTAL THIS PERIOD |            0 |      18.6064 |            0 |              | Cowl tray Lid to keep snow out                                                                    |     278.428  |     0.984597 |           18 | Royal Wed Ring |            8 | HQP102       |     0.035111 |          236 |           33 |            0 |         1963 |            9 |  1.12307e+06 |      7354.58 |            0 |   -0.5       |      4403.9  | k            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43828 |            1 |              |            0 | Secretary/Receptionist      | 034W         |              |            0 |         3636 |              |              | 74-SENECA    |      28882.3 |          379 |              |            4 | 29518.668881811675 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | SST            | SSTC00053BIA_L010            | C00053BIA_L010 | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment         | £m  | Blind year reconciliation 2014-15 | 0                      | 0                      | 0                      | 0                      | 0                      |
|          61 |           1 | 46546.979400605414 |           0 |           3 | Marché      |         120 |             |          22 |         146 | 0            | TPXX-EXP-CPD |         0    |         0.87 |          156 |            0 |         3671 |            0 |  1.56772e+07 |              |              |              | Rank         |  1.23835e+06 | 3025.7107597064928 |      11108   |     0.06816  |              |  2.88178e+07 |        287.5 |         4284 | Negative Change | MAINT. OF VEHICLE & C/ASSET   |            0 |           88 |           30 | 0            | Veterinary Science      | 0            | 0            |      250.031 |            0 |              | Revenues     |       223.25 |            0 |         2021 |      10883.9 | TOTAL THIS PERIOD |            0 |       0.3    |            0 |              | All Orange; 1 to 3 seat belt                                                                      |     278.428  |     2.22316  |           18 | Royal Wed Ring |          863 | HQP102       |     0.035111 |          236 |           33 |            0 |         1963 |            8 |  1.12307e+06 |      7506    |            0 |   -0.0447504 |      4403.9  | s            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43856 |            1 |              |            0 | Officers                    | 033W         |              |            0 |         3636 |              |              | 74-SENECA    |      23981.2 |          283 |              |            5 | 123047.84184856716 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | SES            | SESC00052BIA_L010            | C00052BIA_L010 | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment            | £m  | Blind year reconciliation 2014-15 | -0.21262011184652937   | -0.21262011184652937   | -0.21262011184652937   | -0.21262011184652937   | -0.21262011184652937   |
|         185 |           0 | 36284.881249999999 |           0 |           3 | Airtel      |          46 |             |          22 |         156 | 0            | TPXX-EXP-CPD |       325.32 |         0.87 |          156 |            0 |         3671 |            0 |  0           |              |              |              | Rank         |  1.23835e+06 | 3832.3750308448734 |      13467.8 |     0.353877 |              |  2.88178e+07 |        287.5 |         3629 | Negative Change | CONSULTANCY SERVICES          |            0 |           88 |           30 | 0            | Optometry               |              | 0            |      250.031 |            0 |              | Revenues     |        90.25 |            0 |         2021 |      10883.9 | TOTAL THIS PERIOD |            0 |      24.0799 |            0 |              | (2) Chrome; Towel Bar Type With Anti-Slip Rubber Inserts; Mounted Left and Right Side on Exterior |      28.2317 |     0.984597 |           18 | Royal Wed Ring |         1087 | HQP102       |     0.035111 |          236 |           33 |            0 |         1658 |            8 | 21.05        |      2985.44 |            0 |   -0.666667  |      4388.48 | t            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43856 |            1 |              |            0 | Social Service              | 21002W       |              |            0 |         3636 |              |              | 74-SENECA    |      26666.6 |          283 |              |           11 | 29518.668881811675 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | SES            | SESC00053RC_L010             | C00053RC_L010  | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Revenue Correction Required for year | £m  | Blind year reconciliation 2014-15 | 0                      | 0                      | 0                      | 0                      | 0                      |
|         875 |           0 | 46546.979400605414 |           0 |           3 | Marché      |         135 |             |          22 |          86 | 0            | TPXX-EXP-CPD |         0    |         0.87 |          156 |            0 |         3671 |            0 |  0           |              |              |              | Rank         |  1.23835e+06 | 1286.9348827972112 |      11639.8 |     0.207965 |              |  2.88178e+07 |        287.5 |         3244 | Negative Change | ENTERTAINMENT & HOSPIT.       |            0 |           86 |           30 | 0            | Pharmacy                | 0            | 0            |      250.031 |            0 |              | Revenues     |       147.25 |            0 |         2021 |      12290.9 | TOTAL THIS PERIOD |            0 |       4.8    |            0 |              | {Lang Mekra} Right Side; 6" x 10 1/4", With Bright Finish                                         |      28.2317 |     0.984514 |           18 | Royal Wed Ring |            0 | HQP102       |     0.035111 |          236 |            9 |            0 |         1105 |            3 | 21.05        |      8100.8  |            0 |   -0.3       |      4301.64 | t            |              | Life and Annuity |              | Center Code & Name | CA00257      | Positive Change |        43828 |            1 |              |            0 | Other Non Reimbursable      | 896W         |              |            0 |         3636 |              |              | 74-SENECA    |      23981.2 |          283 |              |            1 | 38246.526299980542 | State Highway 2, Takapau, Central Hawkes Bay |            0 |          101 |         2015 | Original Salary rebased with FY16 CAF | SES            | SESC00053BIA_L010            | C00053BIA_L010 | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment         | £m  | Blind year reconciliation 2014-15 | 0                      | 0                      | 0                      | 0                      | 0                      |



label: A
C
B
labeled_data: Foreign_23
Foreign_8
Foreign_29
Foreign_3
Foreign_13
Foreign_60
Foreign_76
Foreign_56
Foreign_46
Foreign_60
Foreign_23
Foreign_97
A
C
B
output: {"String-Relationship": [[["A", "C"], "B"]]}
source: $MMTU_HOME/resources/Relationship-finding/ST/table_531855___xlsx_cd8542026bee92f774f8efb628357172d67a08ea.xlsx___line_758