Setup (ONLY REQUIRED FOR FIRST TIME/SIGNIFICANT UPDATE)

1. Install python 3. (tested on versions 3.9, 3.10 and 3.11 on mac/windows)
2. To download the latest version of this script, select the release on the right sidebar and download the latest release.
3. Extract the folder to a convenient location.
4. Recommended: to install all required packages, witin the extracted folder, right click on setup.py and select "launch with python launcher".

---

• Alternatively, required packages can also be installed inidivudally:

1. pandas (install command: pip install pandas)
2. msoffcypto (install command: pip install msoffcrypto-tool)
3. streamlit (install command: pip install streamlit)
4. plotly (install command: pip install plotly)
5. tkinter (install command: pip install tk)
6. PySimpleGUI (install command: pip install pysimplegui)

---

• to run the script:

1. Right click on the asp_analytics.gui.py file and launch with python launcher
   OR enter python3 asp_analytics_gui.py in terminal (mac) or cmd (windows)

---

This script has two main options

• Process Epic exported file
  • First select either the exported report are DDD or DOT.
  • Then click on "Process Epic Export File"

• To select the Epic output file using Browse, enter the file password
  • then click Import and Process
  • once finished, click Save As to enter the desired output name and then click Export

---

• Launch dashboard visualization app

• To launch visualization page, select Launch Analytics Dashboard.
• 
• Click Browse file to open file explorer and choose the output processed file.
• Then select either DDD or DOT.
• Select location, department or both for later summarization table and graphs.
• 
• (Optional: Check "Combine Data For All Imported Hospitals/Departments" For HHS-wide data (medications can be selected at the next step).)
• 
• Select grouper of interested.
• Then select level of data, list of departments will automatically filter based on locations selected.
• 
• Location or department data summary tables will display.
• 
• Location or department line graphs will also display.
• to stop the web program, use "control + c" in terminal to stop the program