Skip to main content

Duplicate Hour in Impact Profile Exports

Bug Reports2026Impact Profiles & Load Shapes

Load shapes Impact Profile export 8759 unique hours instead of 8760 — one hour appears twice while another is missing entirely, resulting in the output still containing 8,760 rows but with a duplicated hour timestamp rather than a duplicated impact value.

Specifically, hour 1587 is missing and hour 1588 appears twice.

Likely related to daylight saving time handling.

Select the module in CEDARS
Select user type
Posted by cedars team ·
Status: In Progress2 comments

Log in to comment and vote

Comments2

  • Jake Richardson (PG&E)

    Team•

    Sep 15

    •

    Merged request

    •

    1 vote

    Hour of Impact

    When I put in a custom impact profile with hours 1-8760 without duplicates or missing hours, when I download the data from CEDARS after the fact the hours do not go from 1-8760 without duplicates, and instead have a duplicate and a missing hour. My guess is CEDARS has converted these to a date code after upload (for use in the calculations) and then re-converted to hour of impact for download without handling daylight savings time properly to prevent the duplicate / missing hour. Either way, the download from CEDARS should produce the exact same profile I uploaded and not require rework to put back into 1-8760 terms.

    In my example 1683 is missing and 1684 is a duplicate, which aligns with daylight savings on March 12, 2023. Strangely there is not any issues in the data for fall back on Nov 5, 2023.

    • cedars team

      Team•

      Sep 15

      Thanks for the additional information @Jake Richardson (PG&E). I’m merging this with a ticket for the same issue.