The purpose of the website is to analyze the participants' data and render the results after calculation. It provides graphs and tables which can help the researchers to understand the drinking pattern of the participants better and faster. The researcher not only can upload the CSV files for analysis but also can enter input to be rendered in the report such as the participant's information.
The CSV files it intakes are TDS (Typical Drinking Situation) and All Morning surveys generated from RedCap. Chart One displays the total drinking per day during the whole study period. Chart two displays the average drinking of each TDS during the latest 30 days period of the study period. TDS summary information table renders the results based on TDS CSV file while the Past month drinking and Overview of High Risk Situations over past month section are based on the last 30 days entries of All Morning CSV file data.
The web is built using HTML, CSS, and JavaScript but also with JS libraries such as Bootstrap, Chartist, MatchMedia and Moment. Please see javascript/script.js and stylesheets/style.css for detailed explanation.
#####Notes for Calculation
-
Graph one (Time vs. Drinking)
- It starts from the first entry date of the CSV file even though it is not completed until the last date
- Missing date will be inserted while duplicated day will be deleted following the rule below.
- Deleted the uncompleted.
- If there are both data for all entries, get the latest one.
- All date gets pushed one day ahead because the entries in the CSV file captures the drinking the night before.
-
Graph two (TDS vs. Drinking)
- It is the average drinking per TDS on the days that the participant did enter a number for the amtdrink variable.
- The average number for drinking is timed by 2 after the calculation of the raw data in the CSV file because the entry in the CSV file is 1 for 1- 2 drinks in the choices for the participant while 2 for 3 - 4 drinks.
-
Part C (Past Month Drinking)
- All the data are only from the last 30 days counted from the last entry date.
- EMA Compliance is the total of moderate days and heavy drinking days.
- abstinent days are the days while totalDrink variable is 0.
- The average drinking is divided by drinking day which is the EMA compliance.
-
Part D (Overview of high risk situation over past month)
- All the average results are divided by the times that there is an entry besides blank.
- The average number for drinking is timed by 2 after the calculation of the raw data in the CSV file because the entry in the CSV file is 1 for 1- 2 drink in the choices for the participant while 2 for 3 - 4 drinks.
For more information please email caspir@northwell.edu