Develop an executable program that uses data stored in an Excel file to produce specific variables by summing scores from specific columns and combining them to create summary variables, as shown on the attached. Other (less complicated) variables will be reduced from the collected data as well. The program must be smart enough to indicate when data are missing or incorrect (i.e., out of range), should be useable on a PC or a Mac, and should be useable with different Excel files (i.e., different datasets) as long as the data are stored in the same columns across files. The summary scores should saved in a new Excel file with one row per participant. The input file must be accessible by the program from a hard drive and the output must be stored on a hard drive as well (none of the inputs or outputs can be stored online).
The example scoresheet is from [login to view URL],%20pittsburgh%20psqi.pdf.