bcgov / bcgov/WALLY

Update Excel Export to Include Low 7Q2 Data - WALLY (High #2)

Open
#652 2 comments 0 reactions 1 assignee Claimed by @Christopher-walsh22 View on GitHub
Ready User Story
Dominant language
Python
Stars
5
Forks
2
Avg merge
3h 3m
Merged PRs (30d)
8

Description

**As a** WALLY user **I want** the Low 7Q2 data exported into the Excel **so that** I am able to further analyze EFN (Environmental Flow Needs) risk or make further adjustments as necessary.

**Acceptance Criteria**
- [ ] Given a WALLY user selects Low 7Q2 data data to export, when they export the data, then they are given all data and summary information in a format compatible with Excel.
- [ ] Export should have this data in the Summary tab

Data comes from here:
![image.png](https://images.zenhubusercontent.com/624f2ed04f19a502bdf062d9/299a08c0-2c62-4ca3-96ea-6ba3e6bf9098)

Should export into Excel here:
![image.png](https://images.zenhubusercontent.com/624f2ed04f19a502bdf062d9/e4a6a0d4-688c-4686-9d50-4394fd9305f4)

**Additional Context**
- Low 7Q2 means rolling average 7 day flow every 2 years
- Data to be included in the Excel export that is not currently being exported and is manually added into Excel to evaluate EFN risk
- Export function: This function allows users to export to Excel (or as a shapefile). However, the current output from WALLY into Excel only contains partial information that is found in the online staging environment.
- Low 7Q2 is not calculated and is pulled directly from a spreadsheet.

- There are multiple tickets that pertain to updating the Excel export function.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.