alextenczar / full-stack-development-project-comp805 Goto Github PK

This web app imports cell data from a XLSM Spreadsheet and populates various data models within a Django PostGreSQL database. The web app is then able to display the models and sort them by any attribute. The web app can then calculate all scores and rank projects according to NHSEE's formulas and provided data. Our database can be locally and remotely accessed.

  This will install all the necessary dependencies.

   The web server should now be accessible at: 127.0.0.1:8000 from your web browser.

In order to import the spreadsheet: Click "Import File" in the Navbar

1. Click "Choose File" and locate the spreadsheet file. (XLSM Format)
2. Click "Import"
3. Navigate back to one of the pages used to display the models. They should now be imported and display.

Each Navbar link will display a table for each model. Clicking the headers of each column will sort by that column's object name.

Import provided spreadsheet

Display Imported Data

Modify Data if necessary

Calculate all ranking and scoring values using provided data

Sort data by value according to user's choice

Display data remotely on a server (accessible to anyone with URL)

Display top 5 projects by score and category

Able to create the scoring page using ModelForm, having problems with saving objects.

https://www.python.org

https://www.djangoproject.com

https://openpyxl.readthedocs.io/en/stable/

https://kryogenix.org/code/browser/sorttable/

https://pipenv.kennethreitz.org/en/latest/

https://www.postgresql.org

https://nhsee.org