| 1.1 Portfolio
38 Energy Quotation Service | | |
|---|
| 11.38 Energy Quotation Service: | | 1. Energy quotations are a Bespoke Application Service specified and controlled by its Owner. The first part is the transformation of supplier tariff files into standard tariff information. The second part is the extract and calculation of standard tariff information into customer quotations. | | 2. The transformation of supplier files to tariff information involves manually specified business rules. Eliza has been taught to understand more than 40 tariff fields. Business rules associate each supplier file column with one or more tariff fields. For each row in a supplier file, the columns are processed according to the specified business rules. | | 3. Customer quotation documents are generated from a template provided by and managed by the Owner. The template document contains placeholders where applicable information is inserted by Eliza. It is expected that the Owner will continually improve the customer quotation document template. Many different customer quotation document templates may coexist at the same time for different purposes. Eliza has access to more than 200 fields that can be identified by a unique placeholder in any template document. | | 4. Each physical supplier file is assigned a unique identity that is associated with each tariff created. In the event of the file needing to be reprocessed, the unique identity will ensure that duplicate tariff information is not created. It is expected that from time to time, the business rules shall be improved and the supplier file must be reprocessed as if it was the original time. |
| Glossary of Terms: | | "Supplier" means an Energy Provider billing company who has a wholesale contract with a regional energy distribution company. | | "EAQ" means an Estimated Annual Consumption measured in KWH as an integer number of up to 6 digits. | | "EAC" means an Estimated Annual Cost to the customer, including applicable taxes, measured in Pounds with two decimal places. | | "Unit" means a KWH. | | "Rate" means a the unit cost for a meter dial measured in pence per KWH with 4 decimal places. Those suppliers that work with pounds-per-unit have the rate transformed to pence-per-unit. | | "Rate" means a the standing charge cost for a day measured in pence per day with 4 decimal places. Those suppliers that work with pounds-per-day have the rate transformed to pence-per day. Those suppliers that work with pounds-per-month and pounds-per-quarter, have that rate transformed to pence-per-day because price calculations use a "per-day" charge method. | | "Cost" means a Units multiplied by Rate to derive the cost for the specified meter dial. | | "Cost" means a number of days multiplied by standing charge Rate to derive the cost a period such as one year. | | Peter Drucker said that Knowledge Engineers know more about their job than their managers so tell a Knowledge Engineer what you want not what you want them to do. |
| What is a quote? | | 1. Customer quotations have evolved from a simplistic set of fields to a two-level structure of quote header with many quote details. | | 2. For a given set of customer requirements, many potential prices may be available for both electricity and gas. | | 3. The quote header identifies the customer with one or two meters and one to four estimated annual consumptions. The customer data is encrypted to ensure that it cannot be stolen and is replicated to ensure that it cannot be lost. | | 4. The quote detail (option) represents each potential price for an electric or gas service. The electric and gas prices may be offered by different suppliers. |
| Rates and Units | | 1. Up to three different tariffs may be involved in the determination of an annual price from the renewal date. | | 2. Some tariffs only last for six months and so a year from the renewal date will involve at least two different tariffs and potentially three different rates. | | 3. This means the customers estimated annual consumption is pro-rata divided up into two or three parts based on the number of days on a specific rate. This ignores the fact that winter consumption may be greater than the summer and that a wide variation exists for monthly consumption. | | 4. The two or three tariffs have unique energy rates and standing charge rates that apply for a number of days of the year. This makes the presentation of the facts to the customer rather more complex than the customer may have hoped. | | 5. To simplify presentation and to provide a degree of comparison, all rates are shown as pence-per-unit and pence-per-day, regardless of how the supplier presents their rates. FIT overheads are shown included in the energy rates as they apply to the customer. | | 6. CCL and VAT are shown as they apply, so the customer can manage their monthly direct debit and cash flow in a realistic way. |
| What VAT is to be paid? | | 0. TO DO: The Owner has committed to provide details of how VAT would be managed for a customer. For price comparison purposes, the current service assumes a normal low VAT rate that is five percent. | | 1. VAT paid on energy cannot be reclaimed like any other business-to-business VAT transaction - treat VAT on energy as a different type of tax. | | 2. VAT at 5% is eligible if the energy used is less than 33 KWH per day or 1000 KWH per month. A charity or non profit organisation is charged at the 5% rate. Where 60% of the energy is used is in a domesstic setting then the VAT rate is 5%. | | 3. All other companies must be charged VAT at 20%. | | 4. A company with a discount to 5% is likely to be exempt from paying the Climate Change Levy (CCL). CCL rates change each April with current rates at 0.583 pence per KWH for electricity and 0.203 pence per KWH for gas. | | 5. A company with reasonable Environmental Management System (ISO 14001 EMS) with Climate Change Agreement (CCA) can earn discounts on CCL of up to 90% on electricity and up t 65% on gas. Expect a CCA to be in the order of 200 pages with continual improvements and auditable consumptions - this is a significant application service. A CCA umbrella agreement (24 pages) exists for the data center sector. Having started in 2014 and having achieved all the energy reductions needed until 2024, its hard to do any better. |
| Office Broker Procedure: | | 1. Any office broker has the right to add a new office broker and be given a one-time-pass-phrase for the new office broker that will expire within the hour. | | 2. When the new office broker signs in with their one-time-pass-phrase that will be shown their permanent pass phrase that must be used for all subsequent authentication. | | 3. When an office broker forgets their permanent pass phrase, they may request any other office broker to get them a one-time-pass-phrase that will expire within the hour. | | 4. An office broker has the right to view their own data, has the right to correct their own data and has the right to erase their own data. It must be noted that when the office broker withdraws their consent to have their data processed by erasing their data, they will no longer be able to sign in. | | 5. An office broker may view all quotations. |
| Remote Broker Procedure: | | 1. Any office broker has the right to add a new remote broker and be given a one-time-pass-phrase for the new remote broker that will expire within the hour. | | 2. When the new remote broker signs in with their one-time-pass-phrase that will be shown their permanent pass phrase that must be used for all subsequent authentication. | | 3. When a remote broker forgets their permanent pass phrase, they may request an office broker to get them a one-time-pass-phrase that will expire within the hour. | | 4. A remote broker has the right to view their own data, has the right to correct their own data and has the right to erase their own data. It must be noted that when the remote broker withdraws their consent to have their data processed by erasing their data, they will no longer be able to sign in. | | 5. A remote broker may view only the quotations that they authored, but this may have to be extended to view emails, documents and all other correspondance stored by the business. |
| Customer Procedure: | | 1. Any office broker has the right to add a new customer and the right to request a one-time-access-code for the customer. | | 2. When the customer signs in with their one-time-access-code that will be shown their quotations and associated personal information. A bepoke "Subject Access Request" web site is provided for this purpose. | | 3. When a customer forgets their one-time-access-code, they may request an office broker to get them a new one-time-access-code. | | 4. A customer has the right to view their own data, has the right to correct their own data and has the right to erase their own data. It must be noted that when the customer withdraws their consent to have their data processed by erasing their data, they will no longer be able to sign in and their quotations will lapse. | | 5. A customer may view only their own quotations, but this may have to be extended to view emails, services, documents, letters and contracts. | | 6. Many other methods exist to match the legal rights of people, but none are as effective or self-satisfying as this procedure. |
| Supplier Tariff Files: | | 1. The inital critical step is to transform each supplier file to an International standard CSV file that is free of macros, malware and vulnerabilities. No propriatory data suh as XLS or PDF is permitted in any data center. Where thousands separators have been used, these must be purged to make the CSV usable. Where symbols such as the pound symbol have been used, these must be purged because only International standard ASCII character codes are permitted in a data center. | | 2. A set of business rules are manually specified for each unique supplier tariff file to associate each column with a standard tariff field. Business rules for a specific supplier file are stored in a file in the "5251_business_rule" folder. Business rules include the name of the specified supplier file that stored in the "5252_supplier_file" folder. These file are stored on servers that cannot be accessed from the Internet and cannot be hacked. Data access rights to these files is limited to Eliza and no person. | | 3. Supplier tariff files may not include critical information such as the supplier name and availability dates that must be manually specified in the business rules. No one supplier has adopted an International standard way of presenting tariff information, but Ofgem are trying to come to an arrangement with a Standard Tariff Format (STF). |
| Business Rule and File Index: | | 71 = dual_ele = 20170908_dual_ele.csv | | 72 = corona_ele = 20170908_corona_ele.csv | | 73 = gazprom_ele = 20170913_gazprom_ele.csv | | 74 = gazprom_gas = 20170913_gazprom_gas.csv | | 75 = sse_ele = 20170913_sse_ele.csv | | 76 = sse_gas = 20170913_sse_gas.csv | | 77. 20170913_opus_1_acq.csv | | 78. 20170913_opus_1_with_sc.csv | | 79. 20170913_opus_1_no_sc.csv | | 80. 20170913_opus_1_ret.csv | | 81. 20170913_opus_2_acq.csv | | 82. 20170913_opus_2_with_sc.csv | | 83. 20170913_opus_2_no_sc.csv | | 84. 20170913_opus_3_acq.csv | | 85. 20170913_opus_3_with_sc.csv | | 86. 20170913_opus_3_no_sc.csv | | 87. 20170913_utilita_all_10.csv | | 88. 20170913_utilita_jupiter_20.csv | | 89. 20170913_utilita_saturn_33.csv | | 90. 20170913_utilita_venus_13.csv |
| Document Control: | | 1. Document Title: Energy Quotation Service. | | 2. Reference: 161138. | | 3. Keywords: Energy Quotation Service. DMKO Energy Consoltants. | | 4. Description: Energy Quotation Service. | | 5. Privacy: ITIL public shared with all approved people. | | 6. Issued: 14 Sep 2017. | | 7. Edition: 1.1. |
| Data Dictionary: | | 1. By law, a Data Protection Impact Assessment (DPIA) must be managed by the Data Protection Officer for each and every Bespoke Application Service. The DPIA must include a catalogue of each and every field that is processes - the Data Dictionary is the central repository of all such information. WOP means Pseudonymised And Replicated Encrypted Data (PARED) in compliance with GDPR article 32 as Privacy by Design Default (PbDD). K means unique placeholder as 4 digits - data is stored in placeholders that are only accessed by the "K" Owner. Some lines in some files have no rates and must not be imported. | | K1712.08.LIST as .upload id. as internal transformation from WOP-K1712 | | K1713.08.LIST as Fuel type from WOP-K1713 | | K1723.08.LIST as .meter. type as internal meter code from WOP-K1723 | | K1724.02.LIST as MPAN Profile meter profile to be 2 digits (MPAN 1-2) from WOP-K1724 | | K1725.03.TEXT as MPAN MTC as meter timeswitch code to be 3 digits (MPAN 3-4-5) | | K1726.03.TEXT as MPAN LLFC as line loss factor code to be 3 digits (MPAN 6-7-8) | | K1727.02.LIST as MPAN DNO as distributor to be 2 digits (MPAN 9-10) from WOP-K1727 | | K1728.08.DATE as Start date that must not be after contract renewal date | | K1729.08.DATE as End that must be after contract renewal date | | K1730.02.LIST as MPR LDZ as distributor to be 2 alpha from WOP-K1730 | | K1731.08.LIST as Renewable type from WOP-K1731 | | K1732.08.LIST as FIT type from WOP-K1732 | | K1733.08.TEXT as CCL is pending | | K1734.08.TEXT as Duration in months | | K1735.08.LIST as Product type from WOP-K1735 | | K1736.08.LIST as Uplift type from WOP-K1736 | | K1737.08.LIST as Payment type from WOP-K1737 | | K1738.08.LIST as Gas LDZ Exit from WOP-K1738 | | K1740.08.TEXT as Rate Count must be greater than zero | | K1741.08.DEC4 as Rate 1 day | | K1742.08.DEC4 as Rate 2 night | | K1743.08.DEC4 as Rate 3 | | K1744.08.DEC4 as Rate 4 wend | | K1749.08.LIST as Rate Units from WOP-K1749 | | K1750.08.DEC4 as SC Rate | | K1751.08.LIST as SC Units from WOP-K1751 | | K1752.08.DEC4 as KVA Rate | | K1753.08.LIST as KVA Units from WOP-K1753 | | K1754.08.DEC4 as Comm1 Rate | | K1755.08.LIST as Comm1 Units from WOP-K1755 | | K1756.08.DEC4 as Comm2 Rate | | K1757.08.LIST as Comm2 Units from WOP-K1757 | | K1758.08.TINT as Min Annual Units shown with commas | | K1759.08.TINT as Max Annual Units shown with commas | | K1761.08.LIST as Supplier identity from LUP-K1645 | | K1762.32.TEXT as Tariff Code | | K1763.64.TEXT as Tariff Name | | K1764.64.TEXT as Comment as internal |
| Ask Eliza: | | Hi my name is Eliza, what is your name ______________ | | My Email is eliza@computer-management.co.uk, what is your email ___________________ | | What is your electric meter point admin number prefix ________ (MPAN 2+3+3) | | What is your electric meter point admin number suffix _____________ (2+4+4+3) | | What is your electric annual day consumption ______ KWH | | What is your electric annual night consumption ______ KWH (depending on profile) | | What is your electric annual offpeak consumption ______ KWH (depending on profile) | | What is your gas local distribution zone ______ (LDZ 2 alpha) | | What is your gas annual consumption ______ KWH | | What is your contract renewal date ____________ | | Great: you can have a special rate with an annual cost of only £876. |
| 71. Dual Energy: | | Column, Placeholder, Transformation, Heading and comment | | +,13,IONE, Prelude ignore 1 row as csv with 13 cols | | A,K0000,NONE, ProductType as Fuel as WOP-K1713 | | B,K1727,NUMB, Dist ID as DNO as 2 digits | | C,K0000,NONE, Region, not-used | | D,K1763,TEXT, Meter Type, Tariff-Name | | E,K1724,NUMB, Profile, Profile as 2 digits | | F,K1762,TEXT, Product, Tariff-Code | | F,K1734,CHAR, Product, Duration derived | | F,K1735,CHAR, Product, Fixed/Variable derived | | G,K1750,DEC6, StandingCharge as SC pounds to pence | | H,K1741,DEC6, Day/All/STOD OtherDayUnits as Rate-1 pounds to pence | | I,K1742,DEC6, NightUnitPrice as Rate-2 pounds to pence | | J,K1743,DEC6, Eve+Wkend/Control/STOD WinterPeak as Rate-3 pounds to pence | | K,K1758,NUMB, MinAQ as Min Annual Consumption | | L,K1759,NUMB, MaxAQ as Min Annual Consumption | | +,K1751,"123", SC Units pence-per-day as WOP-K1751 | | +,K1712,"1709071", Transformation Id | | +,K1761,"123461", Supplier Id | | +,K1740,CTRT, rate count | | +,K1713,"125", electric |
| 72. Corona Energy: | | Column, Placeholder, Transformation, Heading and comment | | +,28,IONE, Prelude ignore 1 row + csv with 29 cols | | A,K0000,NONE, DATE_INSERTED, not-used | | B,K0000,NONE, ONSALEFROM, not-used | | C,K0000,NONE, SUPPLIER, "123467" | | D,K0000,NONE, PARTNERID, not-used | | E,K1762,TEXT, SUPPLIERTARIFFCODE, tariff-code | | F,K1763,TEXT, TARIFFNAME, tariff-name | | G,K1734,NUMB, FIXEDRATEPERIOD, 12 to 60 as months | | H,K1758,NUMB, MIN_CONSUMPTION, 0 | | I,K1759,NUMB, MAX_CONSUMPTION, 100000 | | J,K0000,NONE, FUELTYPE, ELECTRIC as WOP-K1713 | | K,K1735,CHAR, PRODUCTTYPE, VARIABLE as WOP-K1735 | | L,K1724,NUMB, PROFILECLASS, profile as 1 to 5 (1-2) | | M,K0000,NONE, AMR, not-used - is this correct 47 | | N,K1731,CHAR, Renewable Energy, NO or YES as WOP-K1731 | | O,K1736,CHAR, ISUPLIFTALLOWED, YES as WOP-K1736 | | P,K1732,CHAR, ISFITSINCLUDED, YES as WOP-K1732 | | Q,K0000,NONE, TARIFFID, not-used | | R,K1727,GSOD, DNO_EXITZONE, GSP to DNO (9-10) | | S,K1725,NUMB, MTC, 3 digit meter timeswitch code (3-4-5) | | T,K1726,NUMB, LLFC,3 digit line loss factor code (6-7-8) | | U,K1728,DMY2, FIRST_SSD, start as 11/08/2017 | | V,K1729,DMY2, LAST_SSD, end as 11/08/2017 | | W,K0000,NONE, STARTDATE, not used | | X,K1737,CHAR, PAYMENTTYPE, payment as WOP-K1737 | | Y,K0000,NONE, CURRENCY, not-used | | Z,K1741,DEC4, Rate1_A_PER_kWh, pence four decimal or zero | | AA,K1742,DEC4, Rate2_A_PER_kWh, pence four decimal or zero | | AB,K1742,DEC4, Rate3_A_PER_kWh, pence four decimal or zero | | AC,K1750,DEC4, DYLY_STDG_CHRG, pence per day | | +,K1751,"123", SC Units pence-per-day as WOP-K1751 | | +,K1712,"1709072", Transformation Id | | +,K1740,CTRT, rate count | | +,K1713,"125", electric, | | C,K1761,"123467", supplier |
| 73, Gazprom Electric: | | Column, Placeholder, Transformation, Heading and comment | | +,11,ITWO, Prelude, ignore 2 rows + csv with 11 cols | | A,K0000,NONE, BLANK, not-used | | B,K1724,NUMB, Profile Class, profile | | C,K1763,TEXT, Meter, tariff name | | D,K1734,YRMT, Contract Duration, year to month | | E,K1728,BEFD, Date, before or after | | E,K1729,AFTD, Date, before or after | | F,K1727,NUMB, DNO, DNO | | G,K1750,DEC4, Standing Charge(p/day), pence | | H,K1741,DEC4, Unit Rate(p/kWh), pence | | I,K1741,DEC4, Day(p/kWh), pence | | J,K1742,DEC4, Night(p/kWh), pence | | K,K1743,DEC4, Evening + Weekend(p/kWh), pence | | +,K1751,"123", SC Units, pence-per-day as WOP-K1751 | | +,K1758,"0", min annual consumption, "0" | | +,K1759,"1000000", max annual consumption, | | +,K1712,"1709073", Transformation Id, | | +,K1713,"125", electric, | | +,K1761,"123462", Supplier Id as gazprom, | | +,K1740,CTRT, rates, rate count 41 to 49 |
| 74. Gazprom Gas: | | Column, Placeholder, Transformation, Heading and comment | | +,9,ITWO, Prelude, ignore 2 rows + csv with 9 cols | | A, K0000,NONE, BLANK not-used | | B, K1763,TEXT, Matrix as high/low | | C, K1763,TADD, Band 1 to 7 appended to tariff-name | | D, K1758,NUMB, Min 2000 | | E, K1759,NUMB, Max 24999 | | F, K1734,NUMB, Contract Duration in months | | G, K1730,TEXT, LDZ as 2 alpha EA EM NO NT NW SC SE SO SW WN WM WS | | H, K1750,DEC6, Standing Charge(pounds/day) +++ not pence | | I, K1741,DEC4, Unit Rate(pence/kWh) | | +, K1751,"123", SC Units as pence-per-day as WOP-K1751 | | +, K1713,"127", Fuel as Gas as WOP-K1713 | | +, K1712,"1709074", Transformation Id | | +, K1761,"123462". Supplier Id | | +, K1740,"1", rate count |
| 75. SSE Electric: | | Column, Placeholder, Transformation, Heading and comment | | +,45,IONE, Prelude ignore 1 row in csv with 45 cols | | A, K1763,TEXT, TENDERID as tariff code 1 | | B, K1763,TADD, SSE Ref as tariff code 2 | | C, K1728,DMY2, Contract_Start as 01/10/2017 | | D, K1727,NUMB, Distributor as DNO and name | | E, K1724,NUMB, Metering_System as profile no | | F, K1764,TEXT, PROFILECODE as tariff name 1 | | G, K1764,TADD, SSE_Structure as tarif name 2 | | H, K1734,NUMB, Period as months duration | | I, K0000,NONE, AMR Monthly Charge, SC not used | | J, K0000,NONE, Non AMR Monthly Charge, SC not used | | K, K1750,AMR6, AMR Quarterly as SC Charge when AMR pounds per quarter | | L, K1750,DEC6, Non AMR Quarterly as SC Charge | | ...only 3 of 32 rates ever exist for any tariff - 45 means assign them in number order | | M, K1741,DEC4, All Units pence per unit | | N, K1741,DEC4, Day Units | | O, K1743,DEC4, Evening and Weekend Units | | P, K1742,DEC4, Night Units | | Q, K1745,DEC4, Week Day Units | | R, K1745,DEC4, All Year 00_00 - 07_00, night | | S, K1745,DEC4, Non Week Day Units | | T, K1745,DEC4, Off Peak Units | | U, K1745,DEC4, All Year 00_30 - 07_30, night | | V, K1745,DEC4, All Year 23_30 - 06_30, night | | W, K1745,DEC4, Apr-Oct All Other Times | | X, K1745,DEC4, Dec and Jan 06_30 - 16_00 Week Days | | Y, K1745,DEC4, Dec and Jan 07_00 - 16_00 and 19_00 - 20_00 Week Days | | Z, K1745,DEC4, Dec and Jan 07_30 - 16_00 and 19_00 - 20_00 Week Days | | AA, K1745,DEC4, Dec and Jan 07_30 - 20_00 Week Days | | AB, K1745,DEC4, Dec and Jan 16_00 - 19_00 Week Days | | AC, K1745,DEC4, Dec to Feb 08_30 - 16_00 and 19_00 - 20_00 Week Days | | AD, K1745,DEC4, Mar - Oct 06_30 - 20_00 Week Days | | AE, K1745,DEC4, Mar - Oct All Other Times | | AF, K1745,DEC4, Mar - Oct All Times | | AG, K1745,DEC4, Nov - Feb 06_30 - 20_00 Week Days | | AH, K1745,DEC4, Nov - Feb 07_30 - 16_00 and 19_00 - 20_00 Week Days | | AI, K1745,DEC4, Nov and Feb 06_30 - 16_00 Week Days | | AJ, K1745,DEC4, Nov and Feb 07_00 - 16_00 and 19_00 - 20_00 Week Days | | AK, K1745,DEC4, Nov and Feb 07_30 - 16_00 and 19_00 - 20_00 Week Days | | AL, K1745,DEC4, Nov - Feb All Other Times | | AM, K1745,DEC4, Nov and Feb 07_30 - 20_00 Week Days | | AN, K1745,DEC4, Nov and Feb 16_00 - 19_00 Week Days | | AO, K1745,DEC4, Nov - Feb All Times | | AP, K1745,DEC4, All Other Times | | AQ, K1745,DEC4, Nov - Mar All Other Times | | AR, K1745,DEC4, Weekdays Nov - Mar 0800-2000 exc peak | | AS, K1747,FITA, FiTs added to all prior rates | | +, K1713,"125", Fuel as WOP-K1713 | | +, K1712,"1709075", Transformation Id | | +, K1761,"123458", Supplier Id | | +, K1740,CTRT, rate count | | +, K1729,"20181001", end date 01/10/2018 | | +, K1758,"0", min annual consumption | | +, K1759,"1000000", max annual consumption |
| 76. SSE Gas: | | Column, Placeholder, Transformation, Heading and comment | | +,11,IONE, Prelude ignore 1 row in csv with 11 cols | | A,K1763,TEXT, MatrixID tariff code not unique | | B,K1728,DMY2, ProposedStartDate as DD/MM/YYYY | | C,K1734,NUMB, TERM, months duration | | D,K1729,DMY2, ProposedEndDate,DD/MM/YYYY | | E,K1763,TADD, BillingFreqLive, "Q" only | | F,K1763,TADD, StandingChargeLive, "10" only | | G,K1763,DEC4, UnitRateLive as pence per unit | | H,K1758,MIN2, Consumption Band, min - max = first | | H,K1759,MAX2, Consumption Band, min - max = last | | I,K1737,PAY2, PAYMENTMETHOD, "DD" only as WOP-K1737 | | J,K1738,LDZ3, ExitZone, code within LDZ by WOP-K1738 | | K,K1730,LDZ2, LDZ, LDZ by WOP-k1730 | | +,K1713,"127", Fuel as WOP-K1713 | | +,K1712,"1709076", Transformation Id, | | +,K1761,"123458", Supplier Id | | +,K1740,CTRT, rates, rate count |
| 77. Opus Ele 1 year Acqisition: | | Column, Placeholder, Transformation, Heading and comment | | +,7,ITWO, Prelude ignore 2 rows in csv with 7 cols remove extra commas | | A,K1762,OPUS,Tariff Code ,join prices+ 27=DNO as leading 2 digits+duration as last 2 | | B,K1740,WHAT,Line Description, decode by name | | C,K1745,DEC4,Price (p) ,pence | | D,K1763,TEXT,Tariff Type,desc | | E,K0000,NONE,,blank | | F,K1764,TEXT,CAT,note | | G,K1764,TADD,Catering Tariff,note | | +,K1713,"125", Fuel as WOP-K1713 | | +,K1712,"1709077", Transformation Id, | | +,K1761,"123465", Supplier Id | | +,K1728,"20170901", start | | +,K1729,"20180901", end | | +,K1734,"12", 1 year=12months | | +,K1759,"1000000", max units | | +,K1751,"123", sc pence per day | | +,K1740,CTRT, rates, rate count |
| 78 Opus Gas: | | Column, Placeholder, Transformation, Heading and comment | | +,6,IONE, Prelude, ignore 1 row1 + csv with 6 cols | | A,K1762,OPUS, Tariff Code, join when same tariff code | | B,K1740,WHAT, Line Description as SC or other rate | | C,K1745,DEC4, Price (p) ,pence | | D,K1763,TEXT, Tariff Type,, with 2 digit months | | D,K1734,NUMB, tariff 2 digit months | | E,K1730,LDZ2, LDZ, 2 alpha to number | | F,K1759,NUMB, AQ Band as numeric suffix = max kwh | | +,K1751,"123", SC Units as pence-per-day as WOP-K1751 | | +,K1713,"127", Fuel as Gas as WOP-K1713 | | +,K1712,=17090??=, Transformation Id | | +,K1761,"123465", Supplier Id opus | | +,K1728,"20170901", start | | +,K1729,"20180901", end | +,K1740,CTRT, rate count| 80. Opus Ele 1 year 80 Retention: | | Column, Placeholder, Transformation, Heading and comment | | +,7,ITWO, Prelude ignore 2 rows in csv with 7 cols remove extra commas | | A,K1762,OPUS,Tariff Code ,join prices+ 27=DNO as leading 2 digits | | B,K1740,WHAT,Line Description, decode by name | | C,K1745,DEC4,Price (p) ,pence | | D,K1763,TEXT,Tariff Type,desc | | E,K0000,NONE,,blank | | F,K1764,TEXT,CAT,note | | G,K1764,TADD,Catering Tariff,note | | +,K1713,"125", Fuel as WOP-K1713 | | +,K1712,"1709080", Transformation Id = retention | | +,K1761,"123465", Supplier Id | | +,K1728,"20170901", start | | +,K1729,"20180901", end | | +,K1734,"12", 1 year=12months | | +,K1759,"1000000", max units | | +,K1751,"123", sc pence per day | | +,K1740,CTRT, rates, rate count |
| 87. Utilita Gas and Electric: | | Column, Placeholder, Transformation, Heading and comment | | +,11,IONE, Prelude, ignore 1 row1 + csv with 11 cols | | A,K1713,FUEL, FUEL, according to K1713 | | B,K0000,NONE, REGION, ignore | | C,K1727,NUMB, DNO AREA, | | D,K1727,GSPN, GSP AREA, as dno when dno is missing | | E,K1724,NUMB, PROFILE CLASS, | | F,K1763,TEXT, TARIFF_NAME, | | F,K1734,YMTH, duration = nr year to months | | G,K1750,DEC4, STANDING CHARGE, | | H,K1741,DEC4, UNIT RATE, | | I,K1742,DEC4, NIGHT RATE, | | J,K1743,DEC4, EVENING/WEEKEND RATE, | | K,K1752,FITA, UPLIFT, adjust each rate | | +,K1751,"123", SC Units as pence-per-day as WOP-K1751 | | +,K1712,"1709087", Transformation Id | | +,K1761,"123457", Supplier Id utilita | | +,K1728,"20170901", start | | +,K1729,"20180901", end | | +,K1740,CTRT, rate count |
|
|
|