Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

PSE Unable to Supply Daily/Hourly Bill Cost #56

Open
PseudoResonance opened this issue Nov 19, 2023 · 3 comments · May be fixed by home-assistant/core#132133
Open

PSE Unable to Supply Daily/Hourly Bill Cost #56

PseudoResonance opened this issue Nov 19, 2023 · 3 comments · May be fixed by home-assistant/core#132133
Labels
enhancement New feature or request

Comments

@PseudoResonance
Copy link

PseudoResonance commented Nov 19, 2023 •
edited
Loading

As mentioned in home-assistant/core#99674, I noticed PSE seems to be unable to provide daily or hourly costs and all values will show 0, including the current bill/forecast. The costs are only provided in the bill view.

Assuming PSE never fixes this, should opower maybe request the data twice, first with the bill aggregate type to calculate the rates for each billing period, then request the desired data and use the previously calculated rates to estimate the provider's daily/hourly cost? Or should other utilities, such as HomeAssistant's integration be responsible for something like that?
@tronikos tronikos added the enhancement New feature or request label Jan 4, 2024
@PseudoResonance
Copy link
Author

PseudoResonance commented Oct 22, 2024 •
edited
Loading

Here's the output of python -m opower -vv --utility pse --start_date 2024-08-21T00:00:00-07:00 --aggregate_type bill for reference. As you can see, the cost is only ever provided for past billing cycles, but not for the current one, or for forecasts. Also, because PSE uses tiered costs (For October 2024, 0.115433 for the first 600kWh, 0.134850 after), the estimates wouldn't be accurate, but they're probably still close enough.

output 
DEBUG:/home/josh/coding/opower/.venv/lib/python3.10/site-packages/opower/opower.py:Fetching: https://pse.opower.com/ei/edge/apis/multi-account-v1/cws/pse/customers?offset=0&batchSize=100&addressFilter=
Level 9:/home/josh/coding/opower/.venv/lib/python3.10/site-packages/opower/opower.py:Fetched: {
  "customers": [
    {
      "id": 0000,
      "uuid": "00000000-0000-0000-0000-000000000000",
      "legacyOpowerId": "LEGACYID",
      "accountNumber": "ACCOUNTNUM",
      "accountName": "ACCOUNTNAME",
      "address": {
        "uuid": "00000000-0000-0000-0000-000000000003",
        "streetNumber": "0",
        "streetName": "STREET",
        "subpremise": null,
        "postalCode": "00000",
        "city": "CITY",
        "country": "US",
        "state": "WA"
      },
      "type": "RESIDENTIAL",
      "utilityAccounts": [
        {
          "id": 0001,
          "uuid": "00000000-0000-0000-0000-000000000001",
          "utilityAccountId": "0000001",
          "utilityAccountId2": null,
          "servicePointId": 001,
          "meterType": "ELEC",
          "preferredUtilityAccountId": "0000001",
          "readResolution": "QUARTER_HOUR"
        },
        {
          "id": 0002,
          "uuid": "00000000-0000-0000-0000-000000000002",
          "utilityAccountId": "0000002",
          "utilityAccountId2": null,
          "servicePointId": 002,
          "meterType": "GAS",
          "preferredUtilityAccountId": "0000002",
          "readResolution": "QUARTER_HOUR"
        }
      ]
    }
  ],
  "offset": 0,
  "batchSize": 100,
  "total": 1
}
DEBUG:/home/josh/coding/opower/.venv/lib/python3.10/site-packages/opower/opower.py:Fetching: https://pse.opower.com/ei/edge/apis/bill-forecast-cws-v1/cws/pse/customers/00000000-0000-0000-0000-000000000000/combined-forecast
Level 9:/home/josh/coding/opower/.venv/lib/python3.10/site-packages/opower/opower.py:Fetched: {
  "isValidUser": true,
  "totalForecast": {
    "meterType": "COMBINED",
    "startDate": "2024-09-28",
    "endDate": "2024-10-27",
    "currentDate": "2024-10-21",
    "daysInPeriod": 30,
    "currentDay": 24,
    "daysLeftInBill": 6,
    "forecastedUsage": 1313,
    "forecastedCost": 0,
    "typicalUsage": 1163,
    "typicalCost": 0,
    "budgetBilling": false,
    "costToDate": 0,
    "usageToDate": 926,
    "currencySymbol": "$"
  },
  "totalMetadata": [
    "NO_FORECASTED_COST",
    "ESTIMATED_PREVIOUS_BILL"
  ],
  "accountForecasts": [
    {
      "unitOfMeasure": "THERM",
      "meterType": "GAS",
      "startDate": "2024-09-28",
      "endDate": "2024-10-27",
      "currentDate": "2024-10-21",
      "daysInPeriod": 30,
      "currentDay": 24,
      "daysLeftInBill": 6,
      "forecastedUsage": 9,
      "typicalUsage": 14,
      "budgetBilling": false,
      "usageToDate": 7,
      "currencySymbol": "$",
      "preferredUtilityAccountId": "0000002",
      "accountUuids": [
        "00000000-0000-0000-0000-000000000002"
      ],
      "isSolar": false
    },
    {
      "unitOfMeasure": "KWH",
      "meterType": "ELEC",
      "startDate": "2024-09-28",
      "endDate": "2024-10-27",
      "currentDate": "2024-10-21",
      "daysInPeriod": 30,
      "currentDay": 24,
      "daysLeftInBill": 6,
      "forecastedUsage": 1196,
      "typicalUsage": 989,
      "budgetBilling": false,
      "usageToDate": 844,
      "currencySymbol": "$",
      "preferredUtilityAccountId": "0000001",
      "accountUuids": [
        "00000000-0000-0000-0000-000000000001"
      ],
      "isSolar": false
    }
  ]
}
DEBUG:/home/josh/coding/opower/.venv/lib/python3.10/site-packages/opower/opower.py:Fetching: https://pse.opower.com/ei/edge/apis/DataBrowser-v1/cws/cost/utilityAccount/00000000-0000-0000-0000-000000000001?aggregateType=bill&startDate=2024-08-21T00%3A00%3A00-07%3A00&endDate=2024-10-22T00%3A00%3A00-07%3A00
Level 9:/home/josh/coding/opower/.venv/lib/python3.10/site-packages/opower/opower.py:Fetched: {
  "servicePointId": "003",
  "utilityAccountUuid": "00000000-0000-0000-0000-000000000001",
  "unit": "KWH",
  "siteTimeZoneId": "America/Los_Angeles",
  "reads": [
    {
      "startTime": "2024-07-30T00:00:00.000-07:00",
      "endTime": "2024-08-29T00:00:00.000-07:00",
      "value": 1124.0,
      "readType": "ACTUAL",
      "providedCost": 153.29,
      "readComponents": null,
      "isPeakPeriod": null,
      "rebateAmount": null,
      "milesDriven": 1888
    },
    {
      "startTime": "2024-08-29T00:00:00.000-07:00",
      "endTime": "2024-09-28T00:00:00.000-07:00",
      "value": 1129.0,
      "readType": "ACTUAL",
      "providedCost": 154.03,
      "readComponents": null,
      "isPeakPeriod": null,
      "rebateAmount": null,
      "milesDriven": 1896
    }
  ],
  "seriesComponents": null,
  "ratePlans": null
}
DEBUG:/home/josh/coding/opower/.venv/lib/python3.10/site-packages/opower/opower.py:Fetching: https://pse.opower.com/ei/edge/apis/DataBrowser-v1/cws/cost/utilityAccount/00000000-0000-0000-0000-000000000002?aggregateType=bill&startDate=2024-08-21T00%3A00%3A00-07%3A00&endDate=2024-10-22T00%3A00%3A00-07%3A00
Level 9:/home/josh/coding/opower/.venv/lib/python3.10/site-packages/opower/opower.py:Fetched: {
  "servicePointId": "004",
  "utilityAccountUuid": "00000000-0000-0000-0000-000000000002",
  "unit": "THERM",
  "siteTimeZoneId": "America/Los_Angeles",
  "reads": [
    {
      "startTime": "2024-07-30T00:00:00.000-07:00",
      "endTime": "2024-08-29T00:00:00.000-07:00",
      "value": 7.78,
      "readType": "ACTUAL",
      "providedCost": 8.71,
      "readComponents": null,
      "isPeakPeriod": null,
      "rebateAmount": null,
      "milesDriven": 98
    },
    {
      "startTime": "2024-08-29T00:00:00.000-07:00",
      "endTime": "2024-09-28T00:00:00.000-07:00",
      "value": 10.148,
      "readType": "ACTUAL",
      "providedCost": 11.37,
      "readComponents": null,
      "isPeakPeriod": null,
      "rebateAmount": null,
      "milesDriven": 128
    }
  ],
  "seriesComponents": null,
  "ratePlans": null
}

Current bill forecast: Forecast(account=Account(customer=Customer(uuid='00000000-0000-0000-0000-000000000000'), uuid='00000000-0000-0000-0000-000000000002', utility_account_id='0000002', id='0000002', meter_type=<MeterType.GAS: 'GAS'>, read_resolution=None), start_date=datetime.date(2024, 9, 28), end_date=datetime.date(2024, 10, 27), current_date=datetime.date(2024, 10, 21), unit_of_measure=<UnitOfMeasure.THERM: 'THERM'>, usage_to_date=7.0, cost_to_date=0.0, forecasted_usage=9.0, forecasted_cost=0.0, typical_usage=14.0, typical_cost=0.0)

Current bill forecast: Forecast(account=Account(customer=Customer(uuid='00000000-0000-0000-0000-000000000000'), uuid='00000000-0000-0000-0000-000000000001', utility_account_id='0000001', id='0000001', meter_type=<MeterType.ELEC: 'ELEC'>, read_resolution=None), start_date=datetime.date(2024, 9, 28), end_date=datetime.date(2024, 10, 27), current_date=datetime.date(2024, 10, 21), unit_of_measure=<UnitOfMeasure.KWH: 'KWH'>, usage_to_date=844.0, cost_to_date=0.0, forecasted_usage=1196.0, forecasted_cost=0.0, typical_usage=989.0, typical_cost=0.0)

Getting historical data: account= Account(customer=Customer(uuid='00000000-0000-0000-0000-000000000000'), uuid='00000000-0000-0000-0000-000000000001', utility_account_id='0000001', id='0000001', meter_type=<MeterType.ELEC: 'ELEC'>, read_resolution=<ReadResolution.QUARTER_HOUR: 'QUARTER_HOUR'>) aggregate_type= bill start_date= 2024-08-21 00:00:00-07:00 end_date= 2024-10-21 17:05:30.521494
start_time	end_time	consumption	provided_cost	start_minus_prev_end	end_minus_prev_end
2024-07-30 00:00:00-07:00	2024-08-29 00:00:00-07:00	1124.0	153.29	None	None
2024-08-29 00:00:00-07:00	2024-09-28 00:00:00-07:00	1129.0	154.03	0:00:00	30 days, 0:00:00


Getting historical data: account= Account(customer=Customer(uuid='00000000-0000-0000-0000-000000000000'), uuid='00000000-0000-0000-0000-000000000002', utility_account_id='0000002', id='0000002', meter_type=<MeterType.GAS: 'GAS'>, read_resolution=<ReadResolution.QUARTER_HOUR: 'QUARTER_HOUR'>) aggregate_type= bill start_date= 2024-08-21 00:00:00-07:00 end_date= 2024-10-21 17:05:30.521494
start_time	end_time	consumption	provided_cost	start_minus_prev_end	end_minus_prev_end
2024-07-30 00:00:00-07:00	2024-08-29 00:00:00-07:00	7.78	8.71	None	None
2024-08-29 00:00:00-07:00	2024-09-28 00:00:00-07:00	10.148	11.37	0:00:00	30 days, 0:00:00

@PseudoResonance PseudoResonance mentioned this issue Oct 22, 2024
Closed
19 tasks
@tronikos
Copy link
Owner

Can you provide the same output with --aggregate_type hour? Just include a single read from the response. I assume providedCost is always 0? How about readType?

@PseudoResonance
Copy link
Author

PseudoResonance commented Oct 22, 2024 •
edited
Loading

providedCost is always 0 when not billing, but readType is ACTUAL.

hour aggregate output 
DEBUG:/home/josh/coding/opower/.venv/lib/python3.10/site-packages/opower/opower.py:Fetching: https://pse.opower.com/ei/edge/apis/multi-account-v1/cws/pse/customers?offset=0&batchSize=100&addressFilter=
Level 9:/home/josh/coding/opower/.venv/lib/python3.10/site-packages/opower/opower.py:Fetched: {
  "customers": [
    {
      "id": 0000,
      "uuid": "00000000-0000-0000-0000-000000000000",
      "legacyOpowerId": "LEGACYID",
      "accountNumber": "ACCOUNTNUM",
      "accountName": "ACCOUNTNAME",
      "address": {
        "uuid": "00000000-0000-0000-0000-000000000003",
        "streetNumber": "0",
        "streetName": "STREET",
        "subpremise": null,
        "postalCode": "00000",
        "city": "CITY",
        "country": "US",
        "state": "WA"
      },
      "type": "RESIDENTIAL",
      "utilityAccounts": [
        {
          "id": 0001,
          "uuid": "00000000-0000-0000-0000-000000000001",
          "utilityAccountId": "0000001",
          "utilityAccountId2": null,
          "servicePointId": 001,
          "meterType": "ELEC",
          "preferredUtilityAccountId": "0000001",
          "readResolution": "QUARTER_HOUR"
        },
        {
          "id": 0002,
          "uuid": "00000000-0000-0000-0000-000000000002",
          "utilityAccountId": "0000002",
          "utilityAccountId2": null,
          "servicePointId": 002,
          "meterType": "GAS",
          "preferredUtilityAccountId": "0000002",
          "readResolution": "QUARTER_HOUR"
        }
      ]
    }
  ],
  "offset": 0,
  "batchSize": 100,
  "total": 1
}
DEBUG:/home/josh/coding/opower/.venv/lib/python3.10/site-packages/opower/opower.py:Fetching: https://pse.opower.com/ei/edge/apis/bill-forecast-cws-v1/cws/pse/customers/00000000-0000-0000-0000-000000000000/combined-forecast
Level 9:/home/josh/coding/opower/.venv/lib/python3.10/site-packages/opower/opower.py:Fetched: {
  "isValidUser": true,
  "totalForecast": {
    "meterType": "COMBINED",
    "startDate": "2024-09-28",
    "endDate": "2024-10-27",
    "currentDate": "2024-10-22",
    "daysInPeriod": 30,
    "currentDay": 25,
    "daysLeftInBill": 5,
    "forecastedUsage": 1313,
    "forecastedCost": 0,
    "typicalUsage": 1163,
    "typicalCost": 0,
    "budgetBilling": false,
    "costToDate": 0,
    "usageToDate": 926,
    "currencySymbol": "$"
  },
  "totalMetadata": [
    "NO_FORECASTED_COST",
    "ESTIMATED_PREVIOUS_BILL"
  ],
  "accountForecasts": [
    {
      "unitOfMeasure": "THERM",
      "meterType": "GAS",
      "startDate": "2024-09-28",
      "endDate": "2024-10-27",
      "currentDate": "2024-10-22",
      "daysInPeriod": 30,
      "currentDay": 25,
      "daysLeftInBill": 5,
      "forecastedUsage": 9,
      "typicalUsage": 14,
      "budgetBilling": false,
      "usageToDate": 7,
      "currencySymbol": "$",
      "preferredUtilityAccountId": "0000002",
      "accountUuids": [
        "00000000-0000-0000-0000-000000000002"
      ],
      "isSolar": false
    },
    {
      "unitOfMeasure": "KWH",
      "meterType": "ELEC",
      "startDate": "2024-09-28",
      "endDate": "2024-10-27",
      "currentDate": "2024-10-22",
      "daysInPeriod": 30,
      "currentDay": 25,
      "daysLeftInBill": 5,
      "forecastedUsage": 1196,
      "typicalUsage": 989,
      "budgetBilling": false,
      "usageToDate": 844,
      "currencySymbol": "$",
      "preferredUtilityAccountId": "0000001",
      "accountUuids": [
        "00000000-0000-0000-0000-000000000001"
      ],
      "isSolar": false
    }
  ]
}
DEBUG:/home/josh/coding/opower/.venv/lib/python3.10/site-packages/opower/opower.py:Fetching: https://pse.opower.com/ei/edge/apis/DataBrowser-v1/cws/cost/utilityAccount/00000000-0000-0000-0000-000000000001?aggregateType=hour&startDate=2024-09-27T00%3A00%3A00-07%3A00&endDate=2024-10-23T00%3A00%3A00-07%3A00
Level 9:/home/josh/coding/opower/.venv/lib/python3.10/site-packages/opower/opower.py:Fetched: {
  "servicePointId": "003",
  "utilityAccountUuid": "00000000-0000-0000-0000-000000000001",
  "unit": "KWH",
  "siteTimeZoneId": "America/Los_Angeles",
  "reads": [
    {
      "startTime": "2024-09-27T00:00:00.000-07:00",
      "endTime": "2024-09-27T01:00:00.000-07:00",
      "value": 1.6758,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 2
    },
    {
      "startTime": "2024-09-27T01:00:00.000-07:00",
      "endTime": "2024-09-27T02:00:00.000-07:00",
      "value": 1.7106,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 2
    },
    {
      "startTime": "2024-09-27T02:00:00.000-07:00",
      "endTime": "2024-09-27T03:00:00.000-07:00",
      "value": 1.8054,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 3
    },
...
    {
      "startTime": "2024-10-20T07:00:00.000-07:00",
      "endTime": "2024-10-20T08:00:00.000-07:00",
      "value": 1.7082,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 2
    },
    {
      "startTime": "2024-10-20T08:00:00.000-07:00",
      "endTime": "2024-10-20T09:00:00.000-07:00",
      "value": 1.803,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 3
    },
    {
      "startTime": "2024-10-20T09:00:00.000-07:00",
      "endTime": "2024-10-20T10:00:00.000-07:00",
      "value": 0.7926,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 1
    }
  ],
  "seriesComponents": [],
  "ratePlans": []
}
DEBUG:/home/josh/coding/opower/.venv/lib/python3.10/site-packages/opower/opower.py:Fetching: https://pse.opower.com/ei/edge/apis/DataBrowser-v1/cws/cost/utilityAccount/00000000-0000-0000-0000-000000000001?aggregateType=hour&startDate=2024-08-31T00%3A00%3A00-07%3A00&endDate=2024-09-26T00%3A00%3A00-07%3A00
Level 9:/home/josh/coding/opower/.venv/lib/python3.10/site-packages/opower/opower.py:Fetched: {
  "servicePointId": "003",
  "utilityAccountUuid": "00000000-0000-0000-0000-000000000001",
  "unit": "KWH",
  "siteTimeZoneId": "America/Los_Angeles",
  "reads": [
    {
      "startTime": "2024-08-31T00:00:00.000-07:00",
      "endTime": "2024-08-31T01:00:00.000-07:00",
      "value": 1.9272,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 3
    },
    {
      "startTime": "2024-08-31T01:00:00.000-07:00",
      "endTime": "2024-08-31T02:00:00.000-07:00",
      "value": 2.025,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 3
    },
    {
      "startTime": "2024-08-31T02:00:00.000-07:00",
      "endTime": "2024-08-31T03:00:00.000-07:00",
      "value": 1.8918,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 3
    },
...
    {
      "startTime": "2024-09-26T21:00:00.000-07:00",
      "endTime": "2024-09-26T22:00:00.000-07:00",
      "value": 1.8444,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 3
    },
    {
      "startTime": "2024-09-26T22:00:00.000-07:00",
      "endTime": "2024-09-26T23:00:00.000-07:00",
      "value": 1.8786,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 3
    },
    {
      "startTime": "2024-09-26T23:00:00.000-07:00",
      "endTime": "2024-09-27T00:00:00.000-07:00",
      "value": 1.7496,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 2
    }
  ],
  "seriesComponents": [],
  "ratePlans": []
}
DEBUG:/home/josh/coding/opower/.venv/lib/python3.10/site-packages/opower/opower.py:Fetching: https://pse.opower.com/ei/edge/apis/DataBrowser-v1/cws/cost/utilityAccount/00000000-0000-0000-0000-000000000001?aggregateType=hour&startDate=2024-08-21T00%3A00%3A00-07%3A00&endDate=2024-08-30T00%3A00%3A00-07%3A00
Level 9:/home/josh/coding/opower/.venv/lib/python3.10/site-packages/opower/opower.py:Fetched: {
  "servicePointId": "003",
  "utilityAccountUuid": "00000000-0000-0000-0000-000000000001",
  "unit": "KWH",
  "siteTimeZoneId": "America/Los_Angeles",
  "reads": [
    {
      "startTime": "2024-08-21T00:00:00.000-07:00",
      "endTime": "2024-08-21T01:00:00.000-07:00",
      "value": 1.875,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 3
    },
    {
      "startTime": "2024-08-21T01:00:00.000-07:00",
      "endTime": "2024-08-21T02:00:00.000-07:00",
      "value": 1.8024,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 3
    },
    {
      "startTime": "2024-08-21T02:00:00.000-07:00",
      "endTime": "2024-08-21T03:00:00.000-07:00",
      "value": 1.6572,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 2
    },
...
    {
      "startTime": "2024-08-30T21:00:00.000-07:00",
      "endTime": "2024-08-30T22:00:00.000-07:00",
      "value": 1.7442,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 2
    },
    {
      "startTime": "2024-08-30T22:00:00.000-07:00",
      "endTime": "2024-08-30T23:00:00.000-07:00",
      "value": 2.5128,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 4
    },
    {
      "startTime": "2024-08-30T23:00:00.000-07:00",
      "endTime": "2024-08-31T00:00:00.000-07:00",
      "value": 2.145,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 3
    }
  ],
  "seriesComponents": [],
  "ratePlans": []
}

Current bill forecast: Forecast(account=Account(customer=Customer(uuid='00000000-0000-0000-0000-000000000000'), uuid='00000000-0000-0000-0000-000000000002', utility_account_id='0000002', id='0000002', meter_type=<MeterType.GAS: 'GAS'>, read_resolution=None), start_date=datetime.date(2024, 9, 28), end_date=datetime.date(2024, 10, 27), current_date=datetime.date(2024, 10, 22), unit_of_measure=<UnitOfMeasure.THERM: 'THERM'>, usage_to_date=7.0, cost_to_date=0.0, forecasted_usage=9.0, forecasted_cost=0.0, typical_usage=14.0, typical_cost=0.0)

Current bill forecast: Forecast(account=Account(customer=Customer(uuid='00000000-0000-0000-0000-000000000000'), uuid='00000000-0000-0000-0000-000000000001', utility_account_id='0000001', id='0000001', meter_type=<MeterType.ELEC: 'ELEC'>, read_resolution=None), start_date=datetime.date(2024, 9, 28), end_date=datetime.date(2024, 10, 27), current_date=datetime.date(2024, 10, 22), unit_of_measure=<UnitOfMeasure.KWH: 'KWH'>, usage_to_date=844.0, cost_to_date=0.0, forecasted_usage=1196.0, forecasted_cost=0.0, typical_usage=989.0, typical_cost=0.0)

Getting historical data: account= Account(customer=Customer(uuid='00000000-0000-0000-0000-000000000000'), uuid='00000000-0000-0000-0000-000000000001', utility_account_id='0000001', id='0000001', meter_type=<MeterType.ELEC: 'ELEC'>, read_resolution=<ReadResolution.QUARTER_HOUR: 'QUARTER_HOUR'>) aggregate_type= hour start_date= 2024-08-21 00:00:00-07:00 end_date= 2024-10-22 02:28:49.890561
start_time	end_time	consumption	provided_cost	start_minus_prev_end	end_minus_prev_end
2024-08-21 00:00:00-07:00	2024-08-21 01:00:00-07:00	1.875	0	None	None
2024-08-21 01:00:00-07:00	2024-08-21 02:00:00-07:00	1.8024	0	0:00:00	1:00:00
2024-08-21 02:00:00-07:00	2024-08-21 03:00:00-07:00	1.6572	0	0:00:00	1:00:00
2024-08-21 03:00:00-07:00	2024-08-21 04:00:00-07:00	1.6812	0	0:00:00	1:00:00
...
2024-10-20 00:00:00-07:00	2024-10-20 01:00:00-07:00	2.2488	0	0:00:00	1:00:00
2024-10-20 01:00:00-07:00	2024-10-20 02:00:00-07:00	1.944	0	0:00:00	1:00:00
2024-10-20 02:00:00-07:00	2024-10-20 03:00:00-07:00	1.8462	0	0:00:00	1:00:00
DEBUG:/home/josh/coding/opower/.venv/lib/python3.10/site-packages/opower/opower.py:Fetching: https://pse.opower.com/ei/edge/apis/DataBrowser-v1/cws/cost/utilityAccount/00000000-0000-0000-0000-000000000002?aggregateType=hour&startDate=2024-09-27T00%3A00%3A00-07%3A00&endDate=2024-10-23T00%3A00%3A00-07%3A00
Level 9:/home/josh/coding/opower/.venv/lib/python3.10/site-packages/opower/opower.py:Fetched: {
  "servicePointId": "004",
  "utilityAccountUuid": "00000000-0000-0000-0000-000000000002",
  "unit": "THERM",
  "siteTimeZoneId": "America/Los_Angeles",
  "reads": [
    {
      "startTime": "2024-09-27T00:00:00.000-07:00",
      "endTime": "2024-09-27T01:00:00.000-07:00",
      "value": 0,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 0
    },
    {
      "startTime": "2024-09-27T01:00:00.000-07:00",
      "endTime": "2024-09-27T02:00:00.000-07:00",
      "value": 0,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 0
    },
    {
      "startTime": "2024-09-27T02:00:00.000-07:00",
      "endTime": "2024-09-27T03:00:00.000-07:00",
      "value": 0.02,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 0
    },
...
    {
      "startTime": "2024-10-19T22:00:00.000-07:00",
      "endTime": "2024-10-19T23:00:00.000-07:00",
      "value": 0.04,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 0
    },
    {
      "startTime": "2024-10-19T23:00:00.000-07:00",
      "endTime": "2024-10-20T00:00:00.000-07:00",
      "value": 0,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 0
    },
    {
      "startTime": "2024-10-20T00:00:00.000-07:00",
      "endTime": "2024-10-20T01:00:00.000-07:00",
      "value": 0.02,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 0
    }
  ],
  "seriesComponents": [],
  "ratePlans": []
}
DEBUG:/home/josh/coding/opower/.venv/lib/python3.10/site-packages/opower/opower.py:Fetching: https://pse.opower.com/ei/edge/apis/DataBrowser-v1/cws/cost/utilityAccount/00000000-0000-0000-0000-000000000002?aggregateType=hour&startDate=2024-08-31T00%3A00%3A00-07%3A00&endDate=2024-09-26T00%3A00%3A00-07%3A00
Level 9:/home/josh/coding/opower/.venv/lib/python3.10/site-packages/opower/opower.py:Fetched: {
  "servicePointId": "004",
  "utilityAccountUuid": "00000000-0000-0000-0000-000000000002",
  "unit": "THERM",
  "siteTimeZoneId": "America/Los_Angeles",
  "reads": [
    {
      "startTime": "2024-08-31T00:00:00.000-07:00",
      "endTime": "2024-08-31T01:00:00.000-07:00",
      "value": 0.02,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 0
    },
    {
      "startTime": "2024-08-31T01:00:00.000-07:00",
      "endTime": "2024-08-31T02:00:00.000-07:00",
      "value": 0,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 0
    },
    {
      "startTime": "2024-08-31T02:00:00.000-07:00",
      "endTime": "2024-08-31T03:00:00.000-07:00",
      "value": 0,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 0
    },
...
    {
      "startTime": "2024-09-26T21:00:00.000-07:00",
      "endTime": "2024-09-26T22:00:00.000-07:00",
      "value": 0,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 0
    },
    {
      "startTime": "2024-09-26T22:00:00.000-07:00",
      "endTime": "2024-09-26T23:00:00.000-07:00",
      "value": 0.02,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 0
    },
    {
      "startTime": "2024-09-26T23:00:00.000-07:00",
      "endTime": "2024-09-27T00:00:00.000-07:00",
      "value": 0,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 0
    }
  ],
  "seriesComponents": [],
  "ratePlans": []
}
DEBUG:/home/josh/coding/opower/.venv/lib/python3.10/site-packages/opower/opower.py:Fetching: https://pse.opower.com/ei/edge/apis/DataBrowser-v1/cws/cost/utilityAccount/00000000-0000-0000-0000-000000000002?aggregateType=hour&startDate=2024-08-21T00%3A00%3A00-07%3A00&endDate=2024-08-30T00%3A00%3A00-07%3A00
Level 9:/home/josh/coding/opower/.venv/lib/python3.10/site-packages/opower/opower.py:Fetched: {
  "servicePointId": "004",
  "utilityAccountUuid": "00000000-0000-0000-0000-000000000002",
  "unit": "THERM",
  "siteTimeZoneId": "America/Los_Angeles",
  "reads": [
    {
      "startTime": "2024-08-21T00:00:00.000-07:00",
      "endTime": "2024-08-21T01:00:00.000-07:00",
      "value": 0,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 0
    },
    {
      "startTime": "2024-08-21T01:00:00.000-07:00",
      "endTime": "2024-08-21T02:00:00.000-07:00",
      "value": 0.02,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 0
    },
    {
      "startTime": "2024-08-21T02:00:00.000-07:00",
      "endTime": "2024-08-21T03:00:00.000-07:00",
      "value": 0,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 0
    },
...
    {
      "startTime": "2024-08-30T21:00:00.000-07:00",
      "endTime": "2024-08-30T22:00:00.000-07:00",
      "value": 0,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 0
    },
    {
      "startTime": "2024-08-30T22:00:00.000-07:00",
      "endTime": "2024-08-30T23:00:00.000-07:00",
      "value": 0,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 0
    },
    {
      "startTime": "2024-08-30T23:00:00.000-07:00",
      "endTime": "2024-08-31T00:00:00.000-07:00",
      "value": 0.04,
      "readType": "ACTUAL",
      "providedCost": 0,
      "readComponents": [],
      "isPeakPeriod": false,
      "rebateAmount": 0,
      "milesDriven": 0
    }
  ],
  "seriesComponents": [],
  "ratePlans": []
}
2024-10-20 03:00:00-07:00	2024-10-20 04:00:00-07:00	1.7334	0	0:00:00	1:00:00
2024-10-20 04:00:00-07:00	2024-10-20 05:00:00-07:00	1.7334	0	0:00:00	1:00:00
2024-10-20 05:00:00-07:00	2024-10-20 06:00:00-07:00	1.6794	0	0:00:00	1:00:00
2024-10-20 06:00:00-07:00	2024-10-20 07:00:00-07:00	1.6686	0	0:00:00	1:00:00
2024-10-20 07:00:00-07:00	2024-10-20 08:00:00-07:00	1.7082	0	0:00:00	1:00:00
2024-10-20 08:00:00-07:00	2024-10-20 09:00:00-07:00	1.803	0	0:00:00	1:00:00
2024-10-20 09:00:00-07:00	2024-10-20 10:00:00-07:00	0.7926	0	0:00:00	1:00:00


Getting historical data: account= Account(customer=Customer(uuid='00000000-0000-0000-0000-000000000000'), uuid='00000000-0000-0000-0000-000000000002', utility_account_id='0000002', id='0000002', meter_type=<MeterType.GAS: 'GAS'>, read_resolution=<ReadResolution.QUARTER_HOUR: 'QUARTER_HOUR'>) aggregate_type= hour start_date= 2024-08-21 00:00:00-07:00 end_date= 2024-10-22 02:28:49.890561
start_time	end_time	consumption	provided_cost	start_minus_prev_end	end_minus_prev_end
2024-08-21 00:00:00-07:00	2024-08-21 01:00:00-07:00	0	0	None	None
2024-08-21 01:00:00-07:00	2024-08-21 02:00:00-07:00	0.02	0	0:00:00	1:00:00
2024-08-21 02:00:00-07:00	2024-08-21 03:00:00-07:00	0	0	0:00:00	1:00:00
2024-08-21 03:00:00-07:00	2024-08-21 04:00:00-07:00	0	0	0:00:00	1:00:00
...
2024-10-19 22:00:00-07:00	2024-10-19 23:00:00-07:00	0.04	0	0:00:00	1:00:00
2024-10-19 23:00:00-07:00	2024-10-20 00:00:00-07:00	0	0	0:00:00	1:00:00
2024-10-20 00:00:00-07:00	2024-10-20 01:00:00-07:00	0.02	0	0:00:00	1:00:00

@PseudoResonance PseudoResonance linked a pull request Dec 3, 2024 that will close this issue
Draft
19 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
2 participants
@PseudoResonance @tronikos