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                      |
|------------:|------------:|:------------|:---------------------|:---------------|:------------|------------:|:-----------------|:------------|------------:|:-----------------------------|:-------------|:-------------|:-------------|-------------:|-------------:|-------------:|:-----------------------------------------|-------------:|-------------:|:-------------|-------------:|-------------:|:-------------|:-------------|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|:-------------|:-------------|:--------------------------------|-------------:|-------------:|-------------:|:-------------|-------------:|:-------------|:-------------|:-------------|:-------------|-------------:|:-------------|-------------:|:-------------|-------------:|-------------:|-------------:|:-------------------|:-------------|-------------:|:----------------------------|:-------------|-------------:|:----------------------------------------------|-------------:|-------------:|:-------------|:-------------------------|:-------------|-------------:|-------------:|:-------------|-------------:|-------------:|:-------------------|-------------:|-------------:|:-------------|:-----------------------------|-------------:|:-------------|:------------------|:-------------|-------------:|:-------------|:-------------|-------------:|:-----------------|:-------------|-------------:|-------------:|:-------------|-------------:|:-------------|:-------------|-------------:|:-------------|:-------------|-------------:|:-------------|:-------------|-------------:|-------------:|-------------:|-------------:|:-------------|:-------------|:---------------|:-----------------------------|:---------------|:--------------------------------------------------------------------------------------------------------------------------|:----|:----------------------------------|:-----------------------|:-----------------------|:-----------------------|:-----------------------|:-----------------------|
|           0 |           0 | 901228-07   | Price for base unit: | Montréal       | Radius      |       44349 | Med. Material    | 0           |           0 | ACH Positive Pay Phone Call  |              | salary       |              |            0 |      383.645 |     131589   | Nexia CS                                 |         0    |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |     64453.4  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |           20 |            0 |            0 | Foundation   |            0 |              | NESA         |              | TASK 33      |            0 |              |          315 | x 0 units =  |        49948 |      8677.7  |            1 | 8.3333333333333339 |              |           62 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.5   |         99.8 | 730.33486548205485 |     13.1083  |            1 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | Wilko             |              |      1.02684 |              |              |           72 | Southfield       |              |            0 |           -1 | (8)          |     0.2697   | ---          |              |           89 |              |              |           66 |              | HQP80        |         4.9  |          219 |            5 |        42360 |              | HRM741       | 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 |                        |                        |                        |                        |                        |
|           0 |           0 | 900030-05   | Price for base unit: | Jonquière      | Radius      |       44328 | Pflegepersonal   |             |           0 | Return Items-Paper Report    |              | salary       |              |            0 |      383.645 |      98037.6 | Qflex 24                                 |         0    |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |     88189.6  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |           22 |            0 |            0 | Basic        |            0 |              | KER          |              | TASK 33      |            0 |              |          875 | x 0 units =  |        12415 |      6183.88 |            1 |                    |              |           62 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.2   |         99.2 | 2779.6917394054572 |      8.88333 |            1 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1       |              |              |           72 | Southfield       |              |            0 |           -1 | (8)          |     0.493151 | ---          |              |          137 |              |              |          146 |              | HQP80        |         4    |           48 |          710 |        42360 |              | HRM741       | 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 |                        |                        |                        |                        |                        |
|           0 |           0 | 900618-13   | Price for base unit: | Gatineau       | Radius      |       44328 | Med. Material    |             |           0 | Reversals                    |              | salary       |              |            0 |      383.645 |      91670.8 | MX412S/N                                 |         0    |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |    100822    |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            5 |       496455 |            0 | Basic        |            0 |              | TN           |              | TASK 33      |            0 |              |          875 | x 0 units =  |        15277 |     15206.2  |            1 | 0                  |              |           53 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.19  |         99.8 |                    |     13.1083  |          615 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1.02684 |              |              |           72 | Farmington Hills |              |            0 |           -1 | (8)          |     0.72519  | ---          |              |          113 |              |              |          207 |              | HQP80        |         1.38 |          100 |          240 |        42360 |              | HRM741       | 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 |                        |                        |                        |                        |                        |
|           0 |           0 | 900074-01   | Price for base unit: | Victoriaville  | Radius      |       44342 | Med. Material    |             |           0 | Miscellaneous Items Paid     |              | salary       |              |            0 |     3105.07  |      94828.8 | G-TOUR-GRC12X12                          |         0    |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |     13281.8  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            7 |            0 |            0 | Specialized  |            0 |              | OR           |              | TASK 33      |            0 |              |          875 | x 0 units =  |       135248 |      6609.65 |            1 | 8.3333333333333339 |              |           33 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.3   |         99.2 | 437.6037706461446  |      8.74167 |           46 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1       |              |              |           72 | Southfield       |              |            0 |           -1 | (8)          |     0.2697   | ---          |              |          149 |              |              |          110 |              | HQP80        |         1.53 |          339 |          100 |        42360 |              | HRM741       | 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 |                        |                        |                        |                        |                        |
|           0 |           0 | 960195-02   | Price for base unit: | Québec         | Radius      |       44342 | Medikamente      |             |           0 | ACH Positive Pay Maintenance |              | salary       |              |            0 |      840.6   |      90390   | EON 510                                  |         0    |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |      4328.99 |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            8 |        48715 |            0 | Foundation   |            0 |              | NESA         |              | TASK 33      |            0 |              |          315 | x 0 units =  |         8291 |      1885.58 |            1 |                    |              |           82 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |       11.7   |         99.2 | 1689.4085143541561 |      8.74167 |          432 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1       |              |              |           72 | Dearborn         |              |            0 |           -1 | (8)          |     0.134921 | ---          |              |           17 |              |              |           66 |              | HQP80        |         1.53 |          192 |          100 |        42360 |              | HRM741       | 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    |
|           0 |           0 | 901271-32   | Price for base unit: | Victoriaville  | Radius      |       44335 | Med. Material    |             |           0 | ACH Received Item            |              | salary       |              |            0 |      383.645 |      91670.8 | EON 510                                  |         0    |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |     88189.6  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            3 |       950912 |            0 | Intermediate |            0 |              | GJ           |              | TASK 33      |            0 |              |          875 | x 0 units =  |        17439 |      5474.25 |            1 |                    |              |           97 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.2   |         99.8 | 3586.158578061571  |     10.5     |            1 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1.02684 |              |              |           72 | St. Clair Shores |              |            0 |           -1 | (8)          |     0.41144  | ---          |              |           77 |              |              |           93 |              | HQP80        |         4.9  |           62 |            5 |        42360 |              | HRM741       | 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     |
|           0 |           0 | 901251-06   | Price for base unit: | Trois-Rivières | Radius      |       44349 | Med. Material    |             |           0 | File or Item Update          |              | salary       |              |            0 |      155.532 |     104675   | EON 510                                  |         0    |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |     13281.8  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            6 |            0 |            0 | Foundation   |            0 |              | UP-W         |              | TASK 33      |            0 |              |          875 | x 0 units =  |        14984 |      1885.58 |            1 | 0                  |              |           62 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.2   |         99.8 | 1858.9077231360352 |     10.5     |            0 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | Morrisons         |              |      1.02684 |              |              |           72 | Farmington Hills |              |            0 |           -1 | (8)          |     0.301028 | ---          |              |           41 |              |              |           80 |              | HQP80        |         4.9  |           13 |            5 |        42360 |              | HRM741       | 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     |
|           0 |           0 | 900164-01   | Price for base unit: | Shawinigan     | Radius      |       44342 | Weitere          |             |           0 | ACH Maintenance              |              | salary       |              |            0 |      383.645 |      92763   | 802-VLZ3                                 |         0    |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |     13281.8  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            8 |       496455 |            0 | Foundation   |            0 |              | J&K          |              | TASK 33      |            0 |              |          605 | x 0 units =  |        33180 |      6183.88 |            1 | 8.3333333333333339 |              |           80 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.01  |         99.8 |                    |     13.1083  |            0 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | Morrisons         |              |      1.02684 |              |              |           72 | Southfield       |              |            0 |           -1 | (8)          |     0.416047 | ---          |              |           89 |              |              |          102 |              | HQP80        |         4    |           13 |          100 |        42360 |              | HRM741       | 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   |
|           0 |           0 | 901106-04   | Price for base unit: | Carignan       | Radius      |       44328 | Med. Material    |             |           0 | Return Items (ACH)           |              | salary       |              |            0 |      155.532 |      98037.6 | Included with MX412                      |      3150.43 |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |    141985    |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            1 |            0 |            0 | Foundation   |            0 |              | OR           |              | TASK 33      |            0 |              |          315 | x 0 units =  |            0 |      1845.03 |            1 |                    |              |           74 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.1   |         99.2 | 37.097335535622861 |     13.1083  |         1513 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1       |              |              |           72 | Dearborn         |              |            0 |           -1 | (8)          |     0.41144  | ---          |              |           89 |              |              |           80 |              | HQP80        |         1.53 |          167 |          330 |        42360 |              | HRM741       | WSH            | WSHC00053RC_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 | 4.2530021509759939     | 4.2530021509759939     | 4.2530021509759939     | 4.2530021509759939     | 4.2530021509759939     |
|           0 |           0 | 910216-12   | Price for base unit: | Shawinigan     | Radius      |       44328 | Med. Material    |             |           0 | Block ACH Transactions       |              | salary       |              |            0 |      155.532 |      92763   | 7100                                     |         0    |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |      4328.99 |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            3 |       594897 |            0 | Specialized  |            0 |              | Assam        |              | TASK 33      |            0 |              |          605 | x 0 units =  |            0 |      1175.95 |            1 | 0                  |              |           74 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        1.5   |         99.2 | 1858.9077231360352 |      8.88333 |         1513 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1.02684 |              |              |           72 | Saginaw          |              |            0 |           -1 | (8)          |     0.134921 | ---          |              |           17 |              |              |           76 |              | HQP80        |         4    |           76 |          100 |        42360 |              | HRM741       | WSH            | WSHC00053BIA_L010            | C00053BIA_L010 | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment         | £m  | Blind year reconciliation 2014-15 | -1.1501234644757656    | -1.1501234644757656    | -1.1501234644757656    | -1.1501234644757656    | -1.1501234644757656    |
|           0 |           0 | 960027-02   | Price for base unit: | Gatineau       | Radius      |       44349 | Blutprodukte     |             |           0 | Reversals                    |              | salary       |              |            0 |     3105.07  |      94828.8 | TBD                                      |         0    |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |     88189.6  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            1 |       496455 |            0 | Foundation   |            0 |              | HP           |              | TASK 33      |            0 |              |          315 | x 0 units =  |        34820 |      1297.6  |            1 | 0                  |              |           73 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.05  |         99.2 | 437.6037706461446  |      8.96667 |            0 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1.02684 |              |              |           72 | Saginaw          |              |            0 |           -1 | (8)          |     0.301028 | ---          |              |           53 |              |              |           80 |              | HQP80        |         4.9  |           58 |          100 |        42360 |              | HRM741       | 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     |
|           0 |           0 | 960002      | Price for base unit: | Laval          | Radius      |       44349 | Medikamente      | 0           |           0 | File Processed               |              | salary       |              |            0 |      340.685 |     104675   | Nexia CS                                 |         0    |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |     64453.4  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |           13 |            0 |            0 | Basic        |            0 |              | KTK          |              | TASK 33      |            0 |              |          605 | x 0 units =  |        17439 |      8231.65 |            1 | 8.3333333333333339 |              |           82 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.3   |         99.8 | 1036.2438696054369 |      8.96667 |          432 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1       |              |              |           72 | Ann Arbor        |              |            0 |           -1 | (8)          |     0.41144  | ---          |              |          125 |              |              |          102 |              | HQP80        |         4    |          192 |            5 |        42360 |              | HRM741       | 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     |
|           0 |           0 | 900875-05   | Price for base unit: | Québec         | Radius      |       44321 | Blutprodukte     |             |           0 | ACH Originated Items-Debit   |              | salary       |              |            0 |     3105.07  |      93703   | Control 24CT MicroPlus                   |         0    |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |     32426.5  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |           13 |       131152 |            0 | Basic        |            0 |              | Kolkatta     |              | TASK 33      |            0 |              |          605 | x 0 units =  |      1589304 |      6224.42 |            1 | 0                  |              |           56 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        1     |         99.2 | 3174.6103711393393 |      8.96667 |           54 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | Dylans Craft Beer |              |      1.02684 |              |              |           72 | Livonia          |              |            0 |           -1 | (8)          |     0.41144  | ---          |              |           53 |              |              |           75 |              | HQP80        |         3.86 |           76 |          710 |        42360 |              | HRM741       | 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    |
|           0 |           0 | 910016-99   | Price for base unit: | Longueuil      | Radius      |       44328 | Med. Material    | 0           |           0 | Return Items-Paper Report    |              | salary       |              |            0 |      568.792 |      96293   | Included with MX412                      |         0    |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |     64453.4  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |           17 |            0 |            0 | Intermediate |            0 |              | KER          |              | TASK 33      |            0 |              |          315 | x 0 units =  |        51126 |      3892.8  |            1 | 0                  |              |           93 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.1   |         99.2 | 1036.2438696054369 |     13.1083  |           51 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1       |              |              |           72 | Saginaw          |              |            0 |           -1 | (8)          |     0.416047 | ---          |              |            5 |              |              |           80 |              | HQP80        |         5.09 |          198 |          710 |        42360 |              | HRM741       | SWT            | SWTC00052BIA_L010            | C00052BIA_L010 | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment            | £m  | Blind year reconciliation 2014-15 | 7.8653152905613616E-2  | 7.8653152905613616E-2  | 7.8653152905613616E-2  | 7.8653152905613616E-2  | 7.8653152905613616E-2  |
|           0 |           0 | 900618-61   | Price for base unit: | Jonquière      | Radius      |       44321 | Med. Material    |             |           0 | File or Item Update          |              | salary       |              |            0 |      383.645 |     112032   | Nexia CS                                 |         0    |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |     32426.5  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            1 |       234596 |            0 | Specialized  |            0 |              | UP-E         |              | TASK 33      |            0 |              |          315 | x 0 units =  |         9804 |      2270.8  |            1 |                    |              |           67 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.1   |         99.2 | 1355.780511210862  |     10.5     |          265 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1       |              |              |           72 | Troy             |              |            0 |           -1 | (8)          |     0.41144  | ---          |              |          125 |              |              |           74 |              | HQP80        |         1.38 |          287 |          370 |        42360 |              | HRM741       | 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    |
|           0 |           0 | 900660      | Price for base unit: | Mascouche      | Radius      |       44328 | Med. Material    |             |           0 | ACH Received Item            |              | salary       |              |            0 |     3105.07  |     131589   | EON 510                                  |         0    |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |    127701    |            0 |        44505 |              |              | In this Date Range? (0 for yes) |           13 |            0 |            0 | Foundation   |            0 |              | DL           |              | TASK 33      |            0 |              |          605 | x 0 units =  |         9804 |      6183.88 |            1 | 0                  |              |           68 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.8   |         99.8 | 1355.780511210862  |      8.6     |            0 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1.02684 |              |              |           72 | Troy             |              |            0 |           -1 | (8)          |     0.134921 | ---          |              |          125 |              |              |          110 |              | HQP80        |         4    |          130 |          370 |        42360 |              | HRM741       | 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    |
|           0 |           0 | 901238-02   | Price for base unit: | Dollard        | Radius      |       44321 | Med. Material    |             |           0 | ACH Maintenance              |              | salary       |              |            0 |      840.6   |     109524   | EON 510                                  |         0    |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |     76072.3  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            4 |            0 |            0 | Foundation   |            0 |              | DL           |              | TASK 33      |            0 |              |          315 | x 0 units =  |            0 |      6447.45 |            1 |                    |              |           97 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.8   |         99.8 | 37.097335535622861 |      8.88333 |          432 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1       |              |              |           72 | Saginaw          |              |            0 |           -1 | (8)          |     0.134921 | ---          |              |           53 |              |              |          102 |              | HQP80        |         4    |           82 |          240 |        42360 |              | HRM741       | SRN            | SRNC00052RC_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 | 16.910393031560758     | 16.910393031560758     | 16.910393031560758     | 16.910393031560758     | 16.910393031560758     |
|           0 |           0 | 900875-09   | Price for base unit: | Laval          | Radius      |       44349 | Med. Material    |             |           0 | Return Items (ACH)           |              | salary       |              |            0 |      155.532 |      90390   | 802-VLZ3                                 |         0    |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |     88189.6  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |           22 |            0 |            0 | Foundation   |            0 |              | ROB          |              | TASK 33      |            0 |              |          605 | x 0 units =  |        17439 |     17679.8  |            1 | 0                  |              |           62 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.003 |         99.2 | 437.6037706461446  |      8.74167 |            0 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1.02684 |              |              |           72 | Westland         |              |            0 |           -1 | (8)          |     0.72519  | ---          |              |          125 |              |              |          110 |              | HQP80        |         3.86 |            3 |          240 |        42360 |              | HRM741       | SRN            | SRNC00052BIA_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.94385023774516441   | -0.94385023774516441   | -0.94385023774516441   | -0.94385023774516441   | -0.94385023774516441   |
|           0 |           0 | 910008      | Price for base unit: | Blainville     | Radius      |       44349 | Medikamente      |             |           0 | Miscellaneous Items Paid     |              | salary       |              |            0 |      340.685 |     107072   | MX412S/N                                 |         0    |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |     76072.3  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |           21 |       496455 |            0 | Specialized  |            0 |              | HR           |              | TASK 33      |            0 |              |          605 | x 0 units =  |          414 |      1175.95 |            1 |                    |              |           73 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.05  |         99.8 | 1689.4085143541561 |      8.83333 |            0 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | Morrisons         |              |      1       |              |              |           72 | Taylor           |              |            0 |           -1 | (8)          |     0.493151 | ---          |              |           29 |              |              |          110 |              | HQP80        |         4    |          256 |          330 |        42360 |              | HRM741       | SRN            | SRNC00053RC_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 | 22.961601203177871     | 22.961601203177871     | 22.961601203177871     | 22.961601203177871     | 22.961601203177871     |
|           0 |           0 | 900127-02   | Price for base unit: | Jonquière      | Radius      |       44328 | Weitere          |             |           0 | ACH Received Item            |              | salary       |              |            0 |     3105.07  |      98037.6 | R185B                                    |         0    |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |     53316.5  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            4 |            0 |            0 | Foundation   |            0 |              | PB           |              | TASK 33      |            0 |              |          315 | x 0 units =  |      1589304 |     46044.5  |            1 |                    |              |           33 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.05  |         99.2 | 1858.9077231360352 |      8.83333 |           36 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1       |              |              |           72 | Dearborn         |              |            0 |           -1 | (8)          |     0.2697   | ---          |              |          149 |              |              |           74 |              | HQP80        |         5.09 |          231 |          710 |        42360 |              | HRM741       | SRN            | SRNC00053BIA_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.43037730170856769    | 0.43037730170856769    | 0.43037730170856769    | 0.43037730170856769    | 0.43037730170856769    |
|           0 |           0 | 960048-02   | Price for base unit: | Laval          | Radius      |       44328 | Ärzteschaften    |             |           0 | ACH Originated Items-Debit   |              | salary       |              |            0 |      155.532 |     102331   | G-TOUR-GRC12X12                          |      3150.43 |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |     32426.5  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |           15 |       194883 |            0 | Basic        |            0 |              | Bihar        |              | TASK 33      |            0 |              |          315 | x 0 units =  |        33180 |      3892.8  |            1 |                    |              |           73 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.8   |         99.2 | 1858.9077231360352 |      8.74167 |           54 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | White Hart Tap    |              |      1       |              |              |           72 | Taylor           |              |            0 |           -1 | (8)          |     0.2697   | ---          |              |           41 |              |              |          146 |              | HQP80        |         5.09 |          169 |          710 |        42360 |              | HRM741       | TMS            | TMSC00052BIA_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.7149924543337507     | 2.7149924543337507     | 2.7149924543337507     | 2.7149924543337507     | 2.7149924543337507     |
|           0 |           0 | 901219-02   | Price for base unit: | Dollard        | Radius      |       44349 | Med. Material    |             |           0 | ACH Positive Pay Maintenance |              | salary       |              |            0 |      568.792 |      90390   | SLX124/85/SM58-G4                        |         0    |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |     42646    |            0 |        44505 |              |              | In this Date Range? (0 for yes) |           19 |       131152 |            0 | Intermediate |            0 |              | KTK          |              | TASK 33      |            0 |              |          315 | x 0 units =  |            0 |      5818.93 |            1 | 8.3333333333333339 |              |           74 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        1     |         99.2 | 4014.8908954361118 |      8.83333 |           11 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1.02684 |              |              |           72 | Farmington Hills |              |            0 |           -1 | (8)          |     0.416047 | ---          |              |           17 |              |              |          102 |              | HQP80        |         4    |          167 |          100 |        42360 |              | HRM741       | 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     |
|           0 |           0 | 900821      | Price for base unit: | Lachine        | Radius      |       44349 | Weitere          |             |           0 | Vendor Maintenance           |              | salary       |              |            0 |      383.645 |      93703   | Nexia CS                                 |         0    |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |     42646    |            0 |        44505 |              |              | In this Date Range? (0 for yes) |           13 |        41459 |            0 | Intermediate |            0 |              | UP-E         |              | TASK 33      |            0 |              |          875 | x 0 units =  |            0 |      6609.65 |            1 | 0                  |              |           82 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.01  |         99.2 | 437.6037706461446  |      8.96667 |            0 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | Wilko             |              |      1.02684 |              |              |           72 | Taylor           |              |            0 |           -1 | (8)          |     0.416047 | ---          |              |           89 |              |              |           94 |              | HQP80        |         1.38 |          287 |            5 |        42360 |              | HRM741       | NWT            | NWTC00052RC_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 | 8.9062515277763872     | 8.9062515277763872     | 8.9062515277763872     | 8.9062515277763872     | 8.9062515277763872     |
|           0 |           0 | 900179      | Price for base unit: | Montréal       | Radius      |       44328 | Blutprodukte     |             |           0 | ACH Deposits                 |              | salary       |              |            0 |      568.792 |      94828.8 | Qflex 24                                 |         0    |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |    113987    |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            7 |            0 |            0 | Intermediate |            0 |              | Kolkatta     |              | TASK 33      |            0 |              |          315 | x 0 units =  |        17719 |      6183.88 |            1 | 0                  |              |           97 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        4     |         99.2 | 2037.6056951835287 |      8.83333 |           51 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1.02684 |              |              |           72 | Dearborn         |              |            0 |           -1 | (8)          |     0.2697   | ---          |              |          101 |              |              |          207 |              | HQP80        |         4    |           62 |          330 |        42360 |              | HRM741       | NWT            | NWTC00053BIA_L010            | C00053BIA_L010 | Sewerage: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment         | £m  | Blind year reconciliation 2014-15 | -1.0139792878236147    | -1.0139792878236147    | -1.0139792878236147    | -1.0139792878236147    | -1.0139792878236147    |
|           0 |           0 | 960116-11   | Price for base unit: | Granby         | Radius      |       44349 | Weitere          |             |           0 | ACH Maintenance              |              | salary       |              |            0 |      383.645 |     100040   | 802-VLZ3                                 |         0    |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |     64453.4  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            0 |            0 |            0 | Foundation   |            0 |              | Assam        |              | TASK 33      |            0 |              |          315 | x 0 units =  |        17719 |       364.95 |            1 |                    |              |           97 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        1.6   |         99.2 | 4014.8908954361118 |     13.1083  |           36 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | Wilko             |              |      1       |              |              |           72 | Rochester Hills  |              |            0 |           -1 | (8)          |     0.2697   | ---          |              |          125 |              |              |          207 |              | HQP80        |         5.09 |           76 |          100 |        42360 |              | HRM741       | WSX            | WSXC00052RC_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.96068660308420961    | 0.96068660308420961    | 0.96068660308420961    | 0.96068660308420961    | 0.96068660308420961    |
|           0 |           0 | 901251-03   | Price for base unit: | Trois-Rivières | Radius      |       44349 | Med. Material    |             |           0 | Return Items (ACH)           |              | salary       |              |            0 |      383.645 |     102331   | Qflex 24                                 |         0    |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |    100822    |            0 |        44505 |              |              | In this Date Range? (0 for yes) |           21 |            0 |            0 | Basic        |            0 |              | Mum          |              | TASK 33      |            0 |              |          605 | x 0 units =  |          995 |      1763.92 |            1 | 0                  |              |           62 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0     |         99.8 | 2400.8643641758745 |      8.74167 |            0 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1       |              |              |           72 | St. Clair Shores |              |            0 |           -1 | (8)          |     0.301028 | ---          |              |          125 |              |              |           67 |              | HQP80        |         3.86 |          256 |          100 |        42360 |              | HRM741       | 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  |
|           0 |           0 | 901240-21   | Price for base unit: | Québec         | Radius      |       44342 | Weitere          |             |           0 | ACH Positive Pay Phone Call  |              | salary       |              |            0 |     3105.07  |     102331   | 7100                                     |         0    |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |     42646    |            0 |        44505 |              |              | In this Date Range? (0 for yes) |           17 |            0 |            0 | Intermediate |            0 |              | Kolkatta     |              | TASK 33      |            0 |              |          605 | x 0 units =  |            0 |      2169.43 |            1 |                    |              |           97 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.4   |         99.8 | 1689.4085143541561 |      8.83333 |           11 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1       |              |              |           72 | Saginaw          |              |            0 |           -1 | (8)          |     0.301028 | ---          |              |          149 |              |              |          151 |              | HQP80        |         1.38 |          231 |            5 |        42360 |              | HRM741       | 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      |
|           0 |           0 | 900877      | Price for base unit: | Granby         | Radius      |       44321 | Med. Material    |             |           0 | Return Items-Paper Report    |              | salary       |              |            0 |      340.685 |     107072   | Nexia CS                                 |         0    |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |     64453.4  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |           19 |       131152 |            0 | Basic        |            0 |              | Assam        |              | TASK 33      |            0 |              |          875 | x 0 units =  |        34820 |      1885.58 |            1 |                    |              |           53 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        6.6   |         99.2 | 37.097335535622861 |     10.5     |          265 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1       |              |              |           72 | Pontiac          |              |            0 |           -1 | (8)          |     0.301028 | ---          |              |           77 |              |              |          110 |              | HQP80        |         3.86 |          238 |          710 |        42360 |              | HRM741       | BRL            | BRLC00052BIA_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.18085002859978327   | -0.18085002859978327   | -0.18085002859978327   | -0.18085002859978327   | -0.18085002859978327   |
|           0 |           0 | 901202-32   | Price for base unit: | Shawinigan     | Radius      |       44328 | Med. Material    |             |           0 | ACH Positive Pay Phone Call  |              | salary       |              |            0 |      840.6   |     131589   | G-TOUR-GRC12X12                          |      3150.43 |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |    127701    |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            0 |            0 |            0 | Foundation   |            0 |              | MH           |              | TASK 33      |            0 |              |          315 | x 0 units =  |         9804 |      1763.92 |            1 |                    |              |           68 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.05  |         99.2 | 3174.6103711393393 |     13.1083  |            0 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | Morrisons         |              |      1       |              |              |           72 | Troy             |              |            0 |           -1 | (8)          |     0.416047 | ---          |              |            5 |              |              |           67 |              | HQP80        |         6.25 |           76 |          100 |        42360 |              | HRM741       | 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                      |
|           0 |           0 | 900015-22   | Price for base unit: | Lachine        | Radius      |       44349 | Benutzung Geräte |             |           0 | Vendor Maintenance           |              | salary       |              |            0 |      383.645 |      92763   | 802-VLZ3                                 |         0    |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |    127701    |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            2 |            0 |            0 | Foundation   |            0 |              | Kolkatta     |              | TASK 33      |            0 |              |          875 | x 0 units =  |        72883 |      6447.45 |            1 |                    |              |           74 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.1   |         99.2 | 1355.780511210862  |      8.83333 |           54 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1       |              |              |           72 | Kalamazoo        |              |            0 |           -1 | (8)          |     0.416047 | ---          |              |          113 |              |              |           80 |              | HQP80        |         4    |            0 |          100 |        42360 |              | HRM741       | BRL            | BRLC00053BIA_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                      |
|           0 |           0 | 960143-01   | Price for base unit: | Québec         | Radius      |       44335 | Weitere          |             |           0 | ACH Positive Pay Maintenance |              | salary       |              |            0 |      383.645 |      93703   | EON 510                                  |         0    |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |    127701    |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            7 |            0 |            0 | Intermediate |            0 |              | KTK          |              | TASK 33      |            0 |              |          605 | x 0 units =  |        72883 |     17679.8  |            1 | 0                  |              |           97 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.1   |         99.8 | 4014.8908954361118 |     10.5     |         1513 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1.02684 |              |              |           72 | Pontiac          |              |            0 |           -1 | (8)          |     0.41144  | ---          |              |           41 |              |              |           75 |              | HQP80        |         1.38 |          861 |          240 |        42360 |              | HRM741       | 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     |
|           0 |           0 | 901224-02   | Price for base unit: | Pointe-du-Lac  | Radius      |       44321 | Med. Material    |             |           0 | Block ACH Transactions       |              | salary       |              |            0 |      840.6   |     109524   | EON 510                                  |         0    |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |     53316.5  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |           19 |            0 |            0 | Specialized  |            0 |              | UP-E         |              | TASK 33      |            0 |              |          315 | x 0 units =  |        29661 |     17679.8  |            1 |                    |              |           56 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        1.5   |         99.8 | 1355.780511210862  |      8.83333 |            0 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1       |              |              |           72 | Westland         |              |            0 |           -1 | (8)          |     0.72519  | ---          |              |           77 |              |              |          151 |              | HQP80        |         4    |           58 |          330 |        42360 |              | HRM741       | 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 |
|           0 |           0 | 900301-01   | Price for base unit: | Laval          | Radius      |       44342 | Med. Material    |             |           0 | Block ACH Transactions       |              | salary       |              |            0 |      155.532 |      92763   | 802-VLZ3                                 |         0    |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |     32426.5  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |           14 |            0 |            0 | Foundation   |            0 |              | Bihar        |              | TASK 33      |            0 |              |          315 | x 0 units =  |        33180 |      6609.65 |            1 | 0                  |              |           99 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.4   |         99.8 | 3174.6103711393393 |     13.1083  |          615 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | Morrisons         |              |      1       |              |              |           72 | Rochester Hills  |              |            0 |           -1 | (8)          |     0.301028 | ---          |              |           89 |              |              |           67 |              | HQP80        |         6.25 |           12 |          370 |        42360 |              | HRM741       | 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                      |
|           0 |           0 | 901249-99   | Price for base unit: | Trois-Rivières | Radius      |       44321 | Med. Material    |             |           0 | File or Item Update          |              | salary       |              |            0 |      340.685 |      91670.8 | Qflex 24 + Custom Installation Apparatus |         0    |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |     42646    |            0 |        44505 |              |              | In this Date Range? (0 for yes) |           19 |            0 |            0 | Foundation   |            0 |              | Assam        |              | TASK 33      |            0 |              |          605 | x 0 units =  |        22667 |     46044.5  |            1 | 0                  |              |           99 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0     |         99.8 | 2400.8643641758745 |     13.1083  |            2 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1.02684 |              |              |           72 | St. Clair Shores |              |            0 |           -1 | (8)          |     0.301028 | ---          |              |           89 |              |              |           80 |              | HQP80        |         4.9  |           58 |          710 |        42360 |              | HRM741       | 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                      |
|           0 |           0 | 900364      | Price for base unit: | Dollard        | Radius      |       44321 | Medikamente      |             |           0 | Vendor Maintenance           |              | salary       |              |            0 |      340.685 |     102331   | Qflex 24                                 |         0    |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |     13281.8  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |           19 |        48715 |            0 | Specialized  |            0 |              | UP-E         |              | TASK 33      |            0 |              |          605 | x 0 units =  |        54704 |      5372.88 |            1 | 8.3333333333333339 |              |           82 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0     |         99.2 | 3174.6103711393393 |      8.74167 |           54 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | Morrisons         |              |      1.02684 |              |              |           72 | Troy             |              |            0 |           -1 | (8)          |     0.2697   | ---          |              |          156 |              |              |           94 |              | HQP80        |         1.38 |          470 |          240 |        42360 |              | HRM741       | DVW            | DVWC00052RC_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.87219153514642955    | 0.87219153514642955    | 0.87219153514642955    | 0.87219153514642955    | 0.87219153514642955    |
|           0 |           0 | 960176-99   | Price for base unit: | Repentigny     | Radius      |       44328 | Weitere          |             |           0 | ACH Positive Pay Phone Call  |              | salary       |              |            0 |      155.532 |     131589   | 7100                                     |         0    |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |     64453.4  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |           13 |       234596 |            0 | Foundation   |            0 |              | NESA         |              | TASK 33      |            0 |              |          875 | x 0 units =  |        44929 |      2270.8  |            1 | 0                  |              |           82 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        1     |         99.8 | 1036.2438696054369 |     13.1083  |            1 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | Dylans Craft Beer |              |      1.02684 |              |              |           72 | Rochester Hills  |              |            0 |           -1 | (8)          |     0.2697   | ---          |              |           41 |              |              |           67 |              | HQP80        |         1.53 |          100 |          710 |        42360 |              | HRM741       | 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                      |
|           0 |           0 | 900173-12   | Price for base unit: | Blainville     | Radius      |       44328 | Weitere          | 0           |           0 | Miscellaneous Items Paid     |              | salary       |              |            0 |      568.792 |     112032   | Control 24CT MicroPlus                   |         0    |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |     88189.6  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            1 |            0 |            0 | Basic        |            0 |              | NESA         |              | TASK 33      |            0 |              |          875 | x 0 units =  |        17439 |      6183.88 |            1 |                    |              |           80 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.8   |         99.8 | 2779.6917394054572 |     13.1083  |           51 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1.02684 |              |              |           72 | Saginaw          |              |            0 |           -1 | (8)          |     0.2697   | ---          |              |          101 |              |              |           74 |              | HQP80        |         4    |           48 |          370 |        42360 |              | HRM741       | 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   |
|           0 |           0 | 900874-07   | Price for base unit: | Montréal       | Radius      |       44321 | Weitere          |             |           0 | Vendor Maintenance           |              | salary       |              |            0 |     3105.07  |     131589   | 802-VLZ3                                 |      3150.43 |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |     22643.3  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            1 |        48715 |            0 | Foundation   |            0 |              | Bihar        |              | TASK 33      |            0 |              |          605 | x 0 units =  |        15277 |      1885.58 |            1 | 0                  |              |           53 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.8   |         99.2 | 1355.780511210862  |      8.74167 |           51 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1.02684 |              |              |           72 | Pontiac          |              |            0 |           -1 | (8)          |     0.2697   | ---          |              |           65 |              |              |           76 |              | HQP80        |         5.09 |          130 |          710 |        42360 |              | HRM741       | 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   |
|           0 |           0 | 901236-02   | Price for base unit: | Laval          | Radius      |       44349 | Med. Material    |             |           0 | Reversals                    |              | salary       |              |            0 |      155.532 |      92763   | 802-VLZ3                                 |         0    |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |    141985    |            0 |        44505 |              |              | In this Date Range? (0 for yes) |           21 |            0 |            0 | Specialized  |            0 |              | Assam        |              | TASK 33      |            0 |              |          605 | x 0 units =  |        33401 |     16605.2  |            1 |                    |              |           73 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.1   |         99.2 | 2779.6917394054572 |      8.74167 |            0 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1.02684 |              |              |           72 | Flint            |              |            0 |           -1 | (8)          |     0.134921 | ---          |              |           89 |              |              |           67 |              | HQP80        |         3.86 |          238 |          330 |        42360 |              | HRM741       | 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                      |
|           0 |           0 | 900118-06   | Price for base unit: | Québec         | Radius      |       44335 | Medikamente      |             |           0 | Return Item - NOC            |              | salary       |              |            0 |      840.6   |      98037.6 | 802-VLZ3                                 |         0    |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |     88189.6  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |           19 |       594897 |            0 | Foundation   |            0 |              | UP-W         |              | TASK 33      |            0 |              |          315 | x 0 units =  |         8291 |      1763.92 |            1 |                    |              |           99 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.05  |         99.2 | 2037.6056951835287 |      8.96667 |           36 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | Tesco             |              |      1.02684 |              |              |           72 | Dearborn         |              |            0 |           -1 | (8)          |     0.301028 | ---          |              |           17 |              |              |           75 |              | HQP80        |         1.53 |           41 |          710 |        42360 |              | HRM741       | 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     |
|           0 |           0 | 900962      | Price for base unit: | Ottawa         | Radius      |       44335 | Ärzteschaften    |             |           0 | ACH Positive Pay Phone Call  |              | salary       |              |            0 |      568.792 |     102331   | Qflex 24 + Custom Installation Apparatus |         0    |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |     64453.4  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            0 |       496455 |            0 | Specialized  |            0 |              | Mum          |              | TASK 33      |            0 |              |          315 | x 0 units =  |        44929 |     17679.8  |            1 | 8.3333333333333339 |              |           56 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        4.5   |         99.2 | 3174.6103711393393 |      8.83333 |            0 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1.02684 |              |              |           72 | Livonia          |              |            0 |           -1 | (8)          |     0.134921 | ---          |              |           17 |              |              |           80 |              | HQP80        |         4    |          231 |            5 |        42360 |              | HRM741       | 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    |
|           0 |           0 | 901221-02   | Price for base unit: | Carignan       | Radius      |       44342 | Ärzteschaften    |             |           0 | ACH Positive Pay Phone Call  |              | salary       |              |            0 |      340.685 |     109524   | 802-VLZ3                                 |         0    |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |    100822    |            0 |        44505 |              |              | In this Date Range? (0 for yes) |           20 |       950912 |            0 | Intermediate |            0 |              | RJ           |              | TASK 33      |            0 |              |          315 | x 0 units =  |            0 |      1885.58 |            1 | 0                  |              |           56 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.03  |         99.8 | 3586.158578061571  |     13.1083  |         1513 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | Morrisons         |              |      1.02684 |              |              |           72 | Lansing          |              |            0 |           -1 | (8)          |     0.41144  | ---          |              |           65 |              |              |           67 |              | HQP80        |         4    |           48 |          710 |        42360 |              | HRM741       | 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                      |
|           0 |           0 | 960501      | Price for base unit: | Val-des-Monts  | Radius      |       44328 | Medikamente      |             |           0 | Return Items (ACH)           |              | salary       |              |            0 |      383.645 |      93703   | R185B                                    |         0    |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |    173442    |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            7 |            0 |            0 | Specialized  |            0 |              | Kolkatta     |              | TASK 33      |            0 |              |          605 | x 0 units =  |        17882 |      6609.65 |            1 |                    |              |           80 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.6   |         99.2 | 730.33486548205485 |      8.74167 |           51 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | White Hart Tap    |              |      1.02684 |              |              |           72 | Saginaw          |              |            0 |           -1 | (8)          |     0.416047 | ---          |              |            5 |              |              |           67 |              | HQP80        |         5.09 |           52 |          240 |        42360 |              | HRM741       | SES            | SESC00052RC_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 | 2.062773129023046      | 2.062773129023046      | 2.062773129023046      | 2.062773129023046      | 2.062773129023046      |
|           0 |           0 | 901211-12   | Price for base unit: | Québec         | Radius      |       44342 | Blutprodukte     |             |           0 | Return Item - NOC            |              | salary       |              |            0 |      568.792 |     100040   | Control 24CT MicroPlus                   |         0    |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |      4328.99 |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            3 |       131152 |            0 | Intermediate |            0 |              | PB           |              | TASK 33      |            0 |              |          875 | x 0 units =  |         2457 |      6609.65 |            1 |                    |              |           82 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.1   |         99.8 | 3174.6103711393393 |      8.96667 |          432 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | Tesco             |              |      1       |              |              |           72 | Pontiac          |              |            0 |           -1 | (8)          |     0.134921 | ---          |              |           17 |              |              |          110 |              | HQP80        |         3.86 |           58 |          370 |        42360 |              | HRM741       | 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   |
|           0 |           0 | 901224-12   | Price for base unit: | Victoriaville  | Radius      |       44349 | Weitere          |             |           0 | ACH Maintenance              |              | salary       |              |            0 |     3105.07  |     100040   | TBD                                      |         0    |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |     42646    |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            7 |            0 |            0 | Intermediate |            0 |              | J&K          |              | TASK 33      |            0 |              |          605 | x 0 units =  |            0 |      8677.7  |            1 | 0                  |              |           73 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.5   |         99.2 | 3174.6103711393393 |     10.5     |            0 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | White Hart Tap    |              |      1       |              |              |           72 | Taylor           |              |            0 |           -1 | (8)          |     0.416047 | ---          |              |          137 |              |              |          207 |              | HQP80        |         1.53 |          339 |          240 |        42360 |              | HRM741       | 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                      |
|           0 |           0 | 960135-99   | Price for base unit: | Lévis          | Radius      |       44335 | Med. Material    |             |           0 | ACH Originated Items-Debit   |              | salary       |              |            0 |      340.685 |     107072   | G-TOUR-GRC12X12                          |      3150.43 |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |     76072.3  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            2 |            0 |            0 | Basic        |            0 |              | UP-W         |              | TASK 33      |            0 |              |          315 | x 0 units =  |         2457 |      8677.7  |            1 |                    |              |           33 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.6   |         99.8 | 3174.6103711393393 |      8.96667 |           51 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1       |              |              |           72 | Saginaw          |              |            0 |           -1 | (8)          |     0.72519  | ---          |              |           41 |              |              |           80 |              | HQP80        |         4.9  |            0 |          710 |        42360 |              | HRM741       | 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                      |
|           0 |           0 | 900618-90   | Price for base unit: | St-Georges     | Radius      |       44328 | Med. Material    |             |           0 | Return Items (ACH)           |              | salary       |              |            0 |     3105.07  |     109524   | 802-VLZ3                                 |         0    |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |     88189.6  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |           22 |        48715 |            0 | Intermediate |            0 |              | TN           |              | TASK 33      |            0 |              |          875 | x 0 units =  |        49948 |      1885.58 |            1 |                    |              |           53 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.2   |         99.2 | 37.097335535622861 |      8.96667 |            0 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | M&S               |              |      1.02684 |              |              |           72 | Westland         |              |            0 |           -1 | (8)          |     0.72519  | ---          |              |           29 |              |              |           76 |              | HQP80        |         3.86 |           74 |          330 |        42360 |              | HRM741       | VCE            | VCEC00053RC_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                      |
|           0 |           0 | 960104      | Price for base unit: | Blainville     | Radius      |       44328 | Med. Material    |             |           0 | File Processed               |              | salary       |              |            0 |      840.6   |     104675   | TBD                                      |         0    |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |     53316.5  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            4 |       131152 |            0 | Intermediate |            0 |              | Assam        |              | TASK 33      |            0 |              |          605 | x 0 units =  |        49948 |      6609.65 |            1 | 8.3333333333333339 |              |           80 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0     |         99.8 | 2400.8643641758745 |      8.74167 |            0 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | Tesco             |              |      1       |              |              |           72 | Dearborn         |              |            0 |           -1 | (8)          |     0.416047 | ---          |              |          101 |              |              |           93 |              | HQP80        |         1.53 |           13 |          240 |        42360 |              | HRM741       | VCE            | VCEC00053BIA_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                      |
|           0 |           0 | 900615-14   | Price for base unit: | Les Côteaux    | Radius      |       44335 | Med. Material    |             |           0 | Miscellaneous Items Paid     |              | salary       |              |            0 |      840.6   |      91670.8 | 7100                                     |         0    |            0 |              |      13087.2 |          156 |              | lower        |  6.92807e+07 |        42413 |            0 |    173442    |            0 |        44505 |              |              | In this Date Range? (0 for yes) |           14 |            0 |            0 | Specialized  |            0 |              | TN           |              | TASK 33      |            0 |              |          315 | x 0 units =  |       130678 |      8677.7  |            1 | 8.3333333333333339 |              |           82 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0.02  |         99.8 | 2037.6056951835287 |      8.83333 |           54 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | Wilko             |              |      1.02684 |              |              |           72 | Wyoming          |              |            0 |           -1 | (8)          |     0.301028 | ---          |              |           77 |              |              |           94 |              | HQP80        |         1.53 |          109 |          370 |        42360 |              | HRM741       | VEA            | VEAC00052RC_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.43879036950871142    | 0.43879036950871142    | 0.43879036950871142    | 0.43879036950871142    | 0.43879036950871142    |
|           0 |           0 | 910008-99   | Price for base unit: | Trois-Rivières | Radius      |       44349 | Med. Material    |             |           0 | Block ACH Transactions       |              | salary       |              |            0 |      340.685 |     131589   | G-TOUR-GRC12X12                          |         0    |            0 |              |      13087.2 |          156 |              | higher       |  6.92807e+07 |        42413 |            0 |     53316.5  |            0 |        44505 |              |              | In this Date Range? (0 for yes) |            5 |       194883 |            0 | Foundation   |            0 |              | TN           |              | TASK 33      |            0 |              |          315 | x 0 units =  |            0 |      1175.95 |            1 |                    |              |           53 | Udalguri, Rowta & Bechimari |              |            0 | Actual Mechanical System Outside Air CFM (OA) |            0 |     0.988961 |              | COMPLIANCE / PERFORMANCE |              |       105735 |            0 | #REF!        |        0     |         99.8 | 730.33486548205485 |      8.83333 |            0 | Factor       | Emission Factor1 (lbs/hp-hr) |           92 |              | Wilko             |              |      1.02684 |              |              |           72 | Taylor           |              |            0 |           -1 | (8)          |     0.493151 | ---          |              |          113 |              |              |           67 |              | HQP80        |         5.09 |          231 |          330 |        42360 |              | HRM741       | VEA            | VEAC00052BIA_L010            | C00052BIA_L010 | Water: Annualised adjustment to 2014 price review requirement at 2012-13 prices - Billing Incentive Adjustment            | £m  | Blind year reconciliation 2014-15 | -7.0050554203729382E-2 | -7.0050554203729382E-2 | -7.0050554203729382E-2 | -7.0050554203729382E-2 | -7.0050554203729382E-2 |



label: A
C
B
labeled_data: Foreign_33
Foreign_53
Foreign_3
Foreign_12
F
Foreign_5
Foreign_56
Foreign_12
C
Foreign_97
Foreign_45
Foreign_30
Foreign_26
Foreign_62
Foreign_79
Foreign_58
Foreign_83
Foreign_76
Foreign_83
Foreign_99
Foreign_83
Foreign_25
Foreign_33
Foreign_3
D
Foreign_93
A
C
B
output: {"String-Relationship": [[["A", "C"], "B"]]}
source: $MMTU_HOME/resources/Relationship-finding/ST/table_182466___xlsx_e300300bb86de6aa6e469144dfc7dd9ebe040f68.xlsx___line_899