This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

Save Scholarship Filters to Sharepoint

Completed by Jack Stockley - 4/30

PR - #32

As a user, so that other users can access my created scholarship filters, I want them to be saved to SharePoint.

Acceptance Criteria

• The current scholarships.xlsx file is moved from being saved locally to being saved on SharePoint.

Technical Details

• The current file paths that are local in scholarship_management.py need to be changed to SharePoint.

View Submitted Recommendations

Completed by Evan Lemker - 5/2

PR - #34

Screenshots

Create custom python row calculations

Completed by Brandon Egger - 5/2

User Story

As a user, So that I can create custom metrics as new columns, I’d like to be able to write python code to perform custom row calculations

Acceptance Criteria

• New modify tab which includes button “add column”
• Text editor view to modify the row
• Creates new column in data table based on lambda function
• Preview changes before saving to sharepoint

Notes

• We should use the following to accomplish this: https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.apply.html
• Using the text editor component for streamlit, allow the user to write a python function, this function will be passed on the back end to the df apply to create a new column. This gives the user full flexibility to perform normal python calculations on a per row basis and use it to add useful metrics.

Dynamic Scholarships

Completed by Austin Beschen- 5/2

PR - #33

As a user, so that I can have the column names and data be whatever I want but still work, I want scholarships to be dynamic in their creation.

Acceptance Criteria

• Scholarships should have dynamic fields that can be added/removed by the user rather than the current static version.

Technical Details

• The way the dynamic fields should be added/removed should most likely be through a multiselect of all the columns.
• They should have sliders as they do now, which most likely will require finding the max and min values of those columns in the dataset.
• Certain fields are still necessary and can be static (Name, Total Amount, Value).

Screenshots

Package as Executable

Completed by Brandon Egger - 5/7

PR - #31

As a user I would like a simple application which I can use to run the streamlit web interface

Acceptance Criteria

• Simple Flet UI for starting/stopping server
• Package tool to bundle and distribute
• Automated build process in CI/CD with artifacts
• Move sharepoint URL configuration to TKinter app

Technical Details

• Add poethepoet to simplify build, test, run and related commands
• added black auto formatter for auto linting code
• refactored code to support new structure where flet app deploys streamlit app
• refactored test code to work with new structure
• added ability to run application "headless", aka without the flet app
• Added pyoxidizer build instructions for packaging executable and macos app bundle.
• Added flet desktop application front end for interfacing with the streamlit server
• Can stop/start server
• can set sharepoint_url
• Added config manager and config structure to .app_data

Screenshots