Need to complete an assigment generating a Report from spreadsheet using simple math formula

The Center for Sleep Medicine Patient Name: Study Date:

Polysomnography Report

Demographic Summary

Name: Age: 56 DOB: Referring LCP: MR#: Sex: Female Interpreting LCP: Bed #: Ht-IN: 59 Testing Tech: Order #: WT-LB: 212 Scoring Tech: BMI: 42.7 Score Set:

Sleep Summary

Time in Bed 514.5 Minutes 83 Percent of SPT in Stage Wake 16.4 Percent Sleep Period Time 505 Minutes Percent of TST in N1 3. Percent Total Sleep Time 422 Minutes Percent of TST in N2 43.2 Percent Sleep Latency 9 Minutes Percent of TST in N3 27.8 Percent Sleep Efficiency 82. Percent Percent of TST in Stage REM 25.9 Percent Wake After Sleep Onset 83 Minutes REM Latency 102 Minutes Sleep Disruption Events Count Index Arousals 87 12.4 Awakenings 21 3. Lights Out: 22:11 Arousals + Awakenings 108 15.4 Lights On: 06:45

Oxygenation Summary Oximetry Statistics Non REM REM Total SaO2, Mean Wake, Percent 96 SaO2, Range, Percent 38 - 98 71 - 98 38 - 99 SaO2, Mean, Percent 94 91 93 SaO2, Minimum, Percent 38 71 38 SaO2 Intervals > 89% 80-89% 70-79% 60-69% 50-59% 40-49% 30-39% < 89% Percent Sleep Time 90.9 6.8 .9 .4 0 .6 .1 8.76.3

EKG Summary EKG Statistics Heart Rate, Wake 76.5 BPM TST Epochs in HR Interval 0 < 29 Heart Rate, Steady Sleep Avg 82 BPM 0 30-59 PAC Events 0 Count 283 60-79 PVC Events 0 Count 558 80-99 2 100-119 NREM REM 0 120-139 Shortest R-R .4 .6 1 140-159 Longest R-R .9 .8 0 > 160

Respiration Summary By Event Classification Central Mixed Obstructive 422 Count Mean Dur Range Dur Count Mean Dur Range Dur Count Mean Dur Range Dur Apneas, NREM 1 19 19-19 0 0 0 0 0 0 Apneas, REM 0 0 0 0 0 0 0 0 0 Apneas, Total 1 19 19-19 0 0 0 0 0 0 Hypopneas, NREM 0 0 0 0 0 0 33 26 16-37 Hypopneas, REM 0 0 0 0 0 0 66 27 17-50 Hypopneas, Total 0 0 0 0 0 0 99 27 16-50

Event Statistics Total With Arousal With Awakening Count Index Count Index Count Index Apneas, Total 1 .1 0 0.0 0 0.0 Hypopneas, Total 99 14.1 21 3.0 5 0.7 Events (Apneas + Hypopneas) 100 14.2 21 3.0 5 0.7 By Body Position N Supine Supine Total N Supine Supine Total Apnea Index, NREM .6 0 .2 1 A+H Index, NREM 9.5 5.1 6.5 Apnea Index, REM 0 0 0 1 A+H Index, REM 0.0 52.8 36.2 Apnea Index, Total .4 0 .1 0 A+H Index, Total 7.0 17.6 14.2 Hypopnea Index, NREM 8.9 5.1 6.3 0 Sleep Time, Minutes 135.5 286.5 422.0

Hypopnea Index, REM 0 52.8 36.2 Hypopnea Index, Total 6.6 17.6 14.1 RERA,NREM 7.0 24.0 31.0 RERA,REM 0 4.0 4.0 RERA, Index 3.1 5.9 5.0 RDI,NREM 13.7 11.9 12.5 RDI,REM 0 56.0 38.4 RDI, Total 19.2

Leg Movement Summary Jerk Counts Non REM (Incl. Wake) REM Total No Arousal Arousal Wake No Arousal Arousal Wake No Arousal Arousal Wake Total Isolated 21 3 0 0 0 0 21 3 0 24 PLMS 117 11 0 50 2 0 167 13 0 180 Total 138 14 0 50 2 0 188 16 0 204 Jerk Statistics PLMS Total Count Index Count Index Jerks 180 25.6 204 29.0 Jerks with Arousal 13 1.8 16 2.3 Jerks, with Wake 0 0 0 0.0 Jerks, Arousal + Wake 13 1.8 16 2.3 Jerks, No Arousal 167 23.7 188 26.7 Jerks, Non REM 128 24.6 152 29.2 Jerks, REM 52 28.5 52 28.5