{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["INSTRUCTIONS","CYCLE 1 DATA HERE","CYCLE 2 DATA HERE","CYCLE 3 DATA HERE","CYCLE 4 DATA HERE","Cycle 1 Diagnosis","Cycle 2 Diagnosis","Cycle 3 Diagnosis","Cycle 4 Diagnosis"],"not_rendered":{"macros":1,"defined_names":4,"comments":4},"read":"whole","date_system":"1900"}

{"sheet":"INSTRUCTIONS","index":0,"n_rows":16,"n_cols":2,"rows_kept":16,"merged":[[1,1,10,18],[11,1,14,18],[15,1,32,18]]}
[]
[null,"Carolina Premenstrual Assessment Scoring System (C-PASS)"]
{"$rows_empty":9}
[null,"For details, please read the publication: Eisenlohr-Moul, T., Schmalenberger, K., Dawson, D., Surana, P., Johnson, J., Girdler, S., & Rubinow, D.  (2017). Toward the Reliable Diagnosis of DSM-5 Premenstrual Dysphoric Disorder: The Carolina Premenstrual Assessment Scoring System (C-PASS). American Journal of Psychiatry."]
[]
[]
[]
[null,"\nSTEP 1: Enter dates and DRSP rating data into the relevant \"Cycle Data\" Sheets at right. Note that C-PASS perimenstrual frames (or \"Cycles\") include days -7 to -1 (premenstrual week) and days 4 to 10 (postmenstrual week) where day 1 is the onset of menses (there is no zero on this timeline). This onset-offset framing was selected for the C-PASS due to the importance of documenting the offset of symptoms.\n\nSTEP 2: If any cells are highlighted in red, check for daily external stressors listed on that DRSP daily rating day. Always delete days in which clear external stressors (i.e., those that are not caused by symptoms) are present.\n\nSTEP 3: Examine each \"Cycle Diagnosis\" sheet to determine cycle-level diagnosis-- that is, whether each cycle meets C-PASS criteria for MRMD (at least 1 cyclical emotional symptom) and DSM-5 PMDD (at least 1 cyclical emotional symptom + 5 symptoms total). \n\nSTEP 4: Make a person-level diagnosis by counting the number of cycles meeting criteria for MRMD and DSM-5 PMDD. If at least two cycles meet criteria for eitherMRMD or PMDD, person-level criteria for MRMD is met. If at least two cycles meet criteria for DSM-5 PMDD, person-level criteria for DSM-5 PMDD is met.\n\nPlease Tory Eisenlohr-Moul, Ph.D. with questions or comments: t.eisenlohr.moul@gmail.com."]

{"sheet":"CYCLE 1 DATA HERE","index":1,"n_rows":23,"n_cols":26,"rows_kept":23,"merged":[[1,0,2,1],[20,0,20,1]]}
["ID"]
["Cycle #1",null,"DRSP     1 ","DRSP     2","DRSP     3","DRSP     4","DRSP     5","DRSP     6","DRSP     7","DRSP     8","DRSP     9","DRSP 10","DRSP 11","DRSP 12","DRSP 13","DRSP 14","DRSP 15","DRSP 16","DRSP 17","DRSP 18","DRSP 19","DRSP 20","DRSP 21","DRSP 22","DRSP 23","DRSP 24"]
[null,null,"Depressed, Blue","Hopelessness","Worthless-ness or Guilt","Anxiety","Mood Swings","Rejection Sensitivity","Anger or Irritability","Interpersonal Conflict","Less Interest","Difficulty Concentrating","Lethargy","Appetite, Overeating","Food Cravings","Hypersomnia","Insomnia","Overwhelmed","Out of Control","Breast Tenderness","Swelling, Bloating","Headache","Joint, Muscle Pain","Work Interference","Hobby Interference","Relationship Interference"]
[-7,{"$f":"B11-7","v":-7}]
[-6,{"$f":"B11-6","v":-6}]
[-5,{"$f":"B11-5","v":-5}]
[-4,{"$f":"B11-4","v":-4}]
[-3,{"$f":"B11-3","v":-3}]
[-2,{"$f":"B11-2","v":-2}]
[-1,{"$f":"B11-1","v":-1}]
[1]
[2,{"$f":"B11+1","v":"1900-01-01"}]
[3,{"$f":"B11+2","v":"1900-01-02"}]
[4,{"$f":"B11+3","v":"1900-01-03"}]
[5,{"$f":"B11+4","v":"1900-01-04"}]
[6,{"$f":"B11+5","v":"1900-01-05"}]
[7,{"$f":"B11+6","v":"1900-01-06"}]
[8,{"$f":"B11+7","v":"1900-01-07"}]
[9,{"$f":"B11+8","v":"1900-01-08"}]
[10,{"$f":"B11+9","v":"1900-01-09"}]
["Criteria Met:",null,{"$f":"'Cycle 1 Diagnosis'!T7","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 1 Diagnosis'!T8","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 1 Diagnosis'!T9","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 1 Diagnosis'!T10","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 1 Diagnosis'!T11","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 1 Diagnosis'!T12","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 1 Diagnosis'!T13","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 1 Diagnosis'!T14","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 1 Diagnosis'!T15","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 1 Diagnosis'!T16","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 1 Diagnosis'!T17","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 1 Diagnosis'!T18","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 1 Diagnosis'!T19","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 1 Diagnosis'!T20","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 1 Diagnosis'!T21","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 1 Diagnosis'!T22","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 1 Diagnosis'!T23","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 1 Diagnosis'!T24","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 1 Diagnosis'!T25","v":{"$error":"#DIV/0!"}},null,{"$f":"'Cycle 1 Diagnosis'!T27","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"*Double-check for daily stressor comments if ratings appear in RED; this may indicate a failure of symptoms to \"clear out\" due to a stressor rather than the persistence of MRMD symptoms. Data from external stressor days should be deleted. "]

{"sheet":"CYCLE 2 DATA HERE","index":2,"n_rows":23,"n_cols":26,"rows_kept":23,"merged":[[1,0,2,1],[20,0,20,1]]}
["ID",{"$f":"'CYCLE 1 DATA HERE'!B1","v":0}]
["Cycle #2",null,"DRSP     1 ","DRSP     2","DRSP     3","DRSP     4","DRSP     5","DRSP     6","DRSP     7","DRSP     8","DRSP     9","DRSP 10","DRSP 11","DRSP 12","DRSP 13","DRSP 14","DRSP 15","DRSP 16","DRSP 17","DRSP 18","DRSP 19","DRSP 20","DRSP 21","DRSP 22","DRSP 23","DRSP 24"]
[null,null,"Depressed, Blue","Hopelessness","Worthless-ness or Guilt","Anxiety","Mood Swings","Rejection Sensitivity","Anger or Irritability","Interpersonal Conflict","Less Interest","Difficulty Concentrating","Lethargy","Appetite, Overeating","Food Cravings","Hypersomnia","Insomnia","Overwhelmed","Out of Control","Breast Tenderness","Swelling, Bloating","Headache","Joint, Muscle Pain","Work Interference","Hobby Interference","Relationship Interference"]
[-7,{"$f":"B11-7","v":-7}]
[-6,{"$f":"B11-6","v":-6}]
[-5,{"$f":"B11-5","v":-5}]
[-4,{"$f":"B11-4","v":-4}]
[-3,{"$f":"B11-3","v":-3}]
[-2,{"$f":"B11-2","v":-2}]
[-1,{"$f":"B11-1","v":-1}]
[1]
[2,{"$f":"B11+1","v":"1900-01-01"}]
[3,{"$f":"B11+2","v":"1900-01-02"}]
[4,{"$f":"B11+3","v":"1900-01-03"}]
[5,{"$f":"B11+4","v":"1900-01-04"}]
[6,{"$f":"B11+5","v":"1900-01-05"}]
[7,{"$f":"B11+6","v":"1900-01-06"}]
[8,{"$f":"B11+7","v":"1900-01-07"}]
[9,{"$f":"B11+8","v":"1900-01-08"}]
[10,{"$f":"B11+9","v":"1900-01-09"}]
["Criteria Met:",null,{"$f":"'Cycle 2 Diagnosis'!T7","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 2 Diagnosis'!T8","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 2 Diagnosis'!T9","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 2 Diagnosis'!T10","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 2 Diagnosis'!T11","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 2 Diagnosis'!T12","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 2 Diagnosis'!T13","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 2 Diagnosis'!T14","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 2 Diagnosis'!T15","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 2 Diagnosis'!T16","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 2 Diagnosis'!T17","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 2 Diagnosis'!T18","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 2 Diagnosis'!T19","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 2 Diagnosis'!T20","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 2 Diagnosis'!T21","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 2 Diagnosis'!T22","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 2 Diagnosis'!T23","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 2 Diagnosis'!T24","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 2 Diagnosis'!T25","v":{"$error":"#DIV/0!"}},null,{"$f":"'Cycle 2 Diagnosis'!T27","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"*Double-check for daily stressor comments if ratings appear in RED; this may indicate a failure of symptoms to \"clear out\" due to a stressor rather than the persistence of MRMD symptoms. Data from external stressor days should be deleted. "]

{"sheet":"CYCLE 3 DATA HERE","index":3,"n_rows":23,"n_cols":26,"rows_kept":23,"merged":[[1,0,2,1],[20,0,20,1]]}
["ID",{"$f":"'CYCLE 1 DATA HERE'!B1","v":0}]
["Cycle #3",null,"DRSP     1 ","DRSP     2","DRSP     3","DRSP     4","DRSP     5","DRSP     6","DRSP     7","DRSP     8","DRSP     9","DRSP 10","DRSP 11","DRSP 12","DRSP 13","DRSP 14","DRSP 15","DRSP 16","DRSP 17","DRSP 18","DRSP 19","DRSP 20","DRSP 21","DRSP 22","DRSP 23","DRSP 24"]
[null,null,"Depressed, Blue","Hopelessness","Worthless-ness or Guilt","Anxiety","Mood Swings","Rejection Sensitivity","Anger or Irritability","Interpersonal Conflict","Less Interest","Difficulty Concentrating","Lethargy","Appetite, Overeating","Food Cravings","Hypersomnia","Insomnia","Overwhelmed","Out of Control","Breast Tenderness","Swelling, Bloating","Headache","Joint, Muscle Pain","Work Interference","Hobby Interference","Relationship Interference"]
[-7,{"$f":"B11-7","v":-7}]
[-6,{"$f":"B11-6","v":-6}]
[-5,{"$f":"B11-5","v":-5}]
[-4,{"$f":"B11-4","v":-4}]
[-3,{"$f":"B11-3","v":-3}]
[-2,{"$f":"B11-2","v":-2}]
[-1,{"$f":"B11-1","v":-1}]
[1]
[2,{"$f":"B11+1","v":"1900-01-01"}]
[3,{"$f":"B11+2","v":"1900-01-02"}]
[4,{"$f":"B11+3","v":"1900-01-03"}]
[5,{"$f":"B11+4","v":"1900-01-04"}]
[6,{"$f":"B11+5","v":"1900-01-05"}]
[7,{"$f":"B11+6","v":"1900-01-06"}]
[8,{"$f":"B11+7","v":"1900-01-07"}]
[9,{"$f":"B11+8","v":"1900-01-08"}]
[10,{"$f":"B11+9","v":"1900-01-09"}]
["Criteria Met:",null,{"$f":"'Cycle 3 Diagnosis'!T7","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 3 Diagnosis'!T8","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 3 Diagnosis'!T9","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 3 Diagnosis'!T10","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 3 Diagnosis'!T11","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 3 Diagnosis'!T12","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 3 Diagnosis'!T13","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 3 Diagnosis'!T14","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 3 Diagnosis'!T15","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 3 Diagnosis'!T16","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 3 Diagnosis'!T17","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 3 Diagnosis'!T18","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 3 Diagnosis'!T19","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 3 Diagnosis'!T20","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 3 Diagnosis'!T21","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 3 Diagnosis'!T22","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 3 Diagnosis'!T23","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 3 Diagnosis'!T24","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 3 Diagnosis'!T25","v":{"$error":"#DIV/0!"}},null,{"$f":"'Cycle 3 Diagnosis'!T27","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"*Double-check for daily stressor comments if ratings appear in RED; this may indicate a failure of symptoms to \"clear out\" due to a stressor rather than the persistence of MRMD symptoms. Data from external stressor days should be deleted. "]

{"sheet":"CYCLE 4 DATA HERE","index":4,"n_rows":23,"n_cols":26,"rows_kept":23,"merged":[[1,0,2,1],[20,0,20,1]]}
["ID",{"$f":"'CYCLE 1 DATA HERE'!B1","v":0}]
["Cycle #4",null,"DRSP     1 ","DRSP     2","DRSP     3","DRSP     4","DRSP     5","DRSP     6","DRSP     7","DRSP     8","DRSP     9","DRSP 10","DRSP 11","DRSP 12","DRSP 13","DRSP 14","DRSP 15","DRSP 16","DRSP 17","DRSP 18","DRSP 19","DRSP 20","DRSP 21","DRSP 22","DRSP 23","DRSP 24"]
[null,null,"Depressed, Blue","Hopelessness","Worthless-ness or Guilt","Anxiety","Mood Swings","Rejection Sensitivity","Anger or Irritability","Interpersonal Conflict","Less Interest","Difficulty Concentrating","Lethargy","Appetite, Overeating","Food Cravings","Hypersomnia","Insomnia","Overwhelmed","Out of Control","Breast Tenderness","Swelling, Bloating","Headache","Joint, Muscle Pain","Work Interference","Hobby Interference","Relationship Interference"]
[-7,{"$f":"B11-7","v":-7}]
[-6,{"$f":"B11-6","v":-6}]
[-5,{"$f":"B11-5","v":-5}]
[-4,{"$f":"B11-4","v":-4}]
[-3,{"$f":"B11-3","v":-3}]
[-2,{"$f":"B11-2","v":-2}]
[-1,{"$f":"B11-1","v":-1}]
[1]
[2,{"$f":"B11+1","v":"1900-01-01"}]
[3,{"$f":"B11+2","v":"1900-01-02"}]
[4,{"$f":"B11+3","v":"1900-01-03"}]
[5,{"$f":"B11+4","v":"1900-01-04"}]
[6,{"$f":"B11+5","v":"1900-01-05"}]
[7,{"$f":"B11+6","v":"1900-01-06"}]
[8,{"$f":"B11+7","v":"1900-01-07"}]
[9,{"$f":"B11+8","v":"1900-01-08"}]
[10,{"$f":"B11+9","v":"1900-01-09"}]
["Criteria Met:",null,{"$f":"'Cycle 4 Diagnosis'!T7","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 4 Diagnosis'!T8","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 4 Diagnosis'!T9","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 4 Diagnosis'!T10","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 4 Diagnosis'!T11","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 4 Diagnosis'!T12","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 4 Diagnosis'!T13","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 4 Diagnosis'!T14","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 4 Diagnosis'!T15","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 4 Diagnosis'!T16","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 4 Diagnosis'!T17","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 4 Diagnosis'!T18","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 4 Diagnosis'!T19","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 4 Diagnosis'!T20","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 4 Diagnosis'!T21","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 4 Diagnosis'!T22","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 4 Diagnosis'!T23","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 4 Diagnosis'!T24","v":{"$error":"#DIV/0!"}},{"$f":"'Cycle 4 Diagnosis'!T25","v":{"$error":"#DIV/0!"}},null,{"$f":"'Cycle 4 Diagnosis'!T27","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"*Double-check for daily stressor comments if ratings appear in RED; this may indicate a failure of symptoms to \"clear out\" due to a stressor rather than the persistence of MRMD symptoms. Data from external stressor days should be deleted. "]

{"sheet":"Cycle 1 Diagnosis","index":5,"n_rows":56,"n_cols":23,"rows_kept":56,"merged":[[0,1,0,22],[2,1,3,2],[2,3,2,6],[2,7,2,18],[2,19,2,22],[3,3,3,4],[3,5,3,6],[3,7,3,16],[3,17,3,18],[3,20,5,20],[4,1,4,2],[4,4,5,4],[4,6,5,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[4,13,4,14],[4,16,5,16],[4,18,5,18],[4,19,5,19],[4,21,5,21],[4,22,5,22],[5,1,5,2],[5,7,5,8],[5,9,5,10],[5,11,5,12],[5,13,5,14],[6,1,13,1],[6,20,8,20],[6,21,8,21],[6,22,13,22],[10,20,11,20],[10,21,11,21],[12,20,13,20],[12,21,13,21],[14,1,26,1],[14,22,26,22],[17,20,18,20],[17,21,18,21],[19,20,20,20],[19,21,20,21],[21,20,22,20],[21,21,22,21],[23,20,26,20],[23,21,26,21],[27,1,29,1],[27,20,29,21],[27,22,29,22],[30,1,30,22],[31,1,31,2],[31,4,31,7],[31,8,31,10],[31,11,31,16],[31,17,31,18],[31,19,31,21],[32,1,32,22],[33,1,33,20],[33,21,33,22],[34,1,35,20],[34,22,35,22],[36,1,36,20],[36,21,36,22],[37,1,37,20],[37,21,37,22],[38,1,38,20],[38,21,38,22]]}
[null,"The Carolina Premenstrual Assessment Scoring System (C-PASS)                                                                                                                                                                    © Tory Eisenlohr-Moul, Ph.D."]
[null,"Please see:  Eisenlohr-Moul, Girdler, Schmalenberger, Dawson, Surana, Johnson, and Rubinow (2017).  American Journal of Psychiatry.",{"$nulls":19},"t.eisenlohr.moul@gmail.com"]
[null,"C-PASS:                                                                                                                 CYCLE #  1 ",null,"CLINICAL SIGNIFICANCE DIMENSIONS",{"$nulls":3},"CYCLICITY                                                                                                                                                                                                                                                                                                                                                                                                                                        DIMENSIONS"]
[{"$nulls":3},"Absolute Severity",null,"Duration",null,"Relative Symptom Change",{"$nulls":9},"Absolute Clearance",null,"DOES DRSP ITEM MEET CRITERIA?","DSM­5 SYMPTOM DOMAIN","DOES DSM-5 SYMPTOM MEET CRITERIA?","DOES A CORE EMOTIONAL SYMPTOM MEET CRITERIA?"]
[null,{"$f":"'CYCLE 1 DATA HERE'!B1","v":0},null,"Pre-menstrual Max","IF >=4, YES   ","# of Severe (>=4) Days","IF >=2,  YES ","Pre-menstrual Mean",null,"Post-menstrual Mean",null,"Raw Cyclical Change",null,"Woman's Scale Range (Constant)",null,"Cyclical Change as\n% of Scale Range","IF\n>=30%, YES","Post-menses Maximum","IF <=3, YES","IF ALL DIMENSIONS IN ROW = YES",null,"YES IF AT LEAST ONE DRSP ITEM IN THIS DOMAIN = YES","YES IF ANY OF FIRST FOUR DOMAINS = YES"]
[null,"INSTRUCTIONS: Start Here and Work Across to the Right by Row. Note: Day -1 = Day before the Onset of Menstrual Period Day 1 = Onset of Menstrual Period.",null,"Identify Highest Item Rating Day -7 to -1",null,"Count Number of Days Day ­7\nto ­1 where Item Rating is\n>=4",null,"Calculate Average Item Rating Day ­7 to - 1",null,"Calculate Average Item Rating Day 4 to 10",null,"Subtract Post-menstrual Mean from Pre­menstrual Mean",null,"Calculate Range: (Max Rating Across ALL DRSP\nResponses - 1)",null,"z",null,"Identify Highest Item Rating Day 4 to 10"]
[null,"Core Emotional Symptoms","DRSP1 - Depressed, Blue",{"$f":"MAX('CYCLE 1 DATA HERE'!C4:C10)","v":0},{"$f":"IF(D7>=4,\"Yes\",\"No\")","v":"No"},{"$f":"COUNTIF('CYCLE 1 DATA HERE'!C4:C10, \">=4\")","v":0},{"$f":"IF(F7>=2,\"Yes\",\"No\")","v":"No"},{"$f":"AVERAGE('CYCLE 1 DATA HERE'!C4:C10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!C14:C20)","v":{"$error":"#DIV/0!"}},"=",{"$f":"H7-J7","v":{"$error":"#DIV/0!"}},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$f":"(L7/N7)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(P7>=30,\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}},{"$f":"MAX('CYCLE 1 DATA HERE'!C14:C20)","v":0},{"$f":"IF(R7<=3,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF((E7=\"No\")+(G7=\"No\")+(Q7=\"No\")+(S7=\"No\"),\"No\",\"Yes\")","v":{"$error":"#DIV/0!"}},"DEPRESSION",{"$f":"IF((T7=\"Yes\")+(T8=\"Yes\")+(T9=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}},{"$f":"IF((V7=\"Yes\")+(V10=\"Yes\")+(V11=\"Yes\")+(V12=\"Yes\")+(V13=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP2 - Hopelessness",{"$f":"MAX('CYCLE 1 DATA HERE'!D4:D10)","v":0},"No",{"$f":"COUNTIF('CYCLE 1 DATA HERE'!D4:D10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!D4:D10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!D14:D20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 1 DATA HERE'!D14:D20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP3 - Worthlessness or Guilt",{"$f":"MAX('CYCLE 1 DATA HERE'!E4:E10)","v":0},"No",{"$f":"COUNTIF('CYCLE 1 DATA HERE'!E4:E10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!E4:E10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!E14:E20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 1 DATA HERE'!E14:E20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP4 - Anxiety",{"$f":"MAX('CYCLE 1 DATA HERE'!F4:F10)","v":0},"No",{"$f":"COUNTIF('CYCLE 1 DATA HERE'!F4:F10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!F4:F10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!F14:F20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 1 DATA HERE'!F14:F20)","v":0},"Yes",{"$error":"#DIV/0!"},"ANXIETY",{"$f":"IF((T10=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP5 - Mood Swings",{"$f":"MAX('CYCLE 1 DATA HERE'!G4:G10)","v":0},"No",{"$f":"COUNTIF('CYCLE 1 DATA HERE'!G4:G10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!G4:G10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!G14:G20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 1 DATA HERE'!G14:G20)","v":0},"Yes",{"$error":"#DIV/0!"},"MOOD LABILITY",{"$f":"IF((T11=\"Yes\")+(T12=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP6 - Rejection Sensitivity",{"$f":"MAX('CYCLE 1 DATA HERE'!H4:H10)","v":0},"No",{"$f":"COUNTIF('CYCLE 1 DATA HERE'!H4:H10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!H4:H10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!H14:H20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 1 DATA HERE'!H14:H20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP7 - Anger or Irritability",{"$f":"MAX('CYCLE 1 DATA HERE'!I4:I10)","v":0},"No",{"$f":"COUNTIF('CYCLE 1 DATA HERE'!I4:I10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!I4:I10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!I14:I20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 1 DATA HERE'!I14:I20)","v":0},"Yes",{"$error":"#DIV/0!"},"ANGER",{"$f":"IF((T13=\"Yes\")+(T14=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP8 - Interpersonal Conflict",{"$f":"MAX('CYCLE 1 DATA HERE'!J4:J10)","v":0},"No",{"$f":"COUNTIF('CYCLE 1 DATA HERE'!J4:J10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!J4:J10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!J14:J20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 1 DATA HERE'!J14:J20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,"Secondary Symptoms","DRSP9 - Less Interest",{"$f":"MAX('CYCLE 1 DATA HERE'!K4:K10)","v":0},"No",{"$f":"COUNTIF('CYCLE 1 DATA HERE'!K4:K10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!K4:K10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!K14:K20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 1 DATA HERE'!K14:K20)","v":0},"Yes",{"$error":"#DIV/0!"},"INTEREST",{"$f":"IF((T15=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP10 - Difficulty Concentrating",{"$f":"MAX('CYCLE 1 DATA HERE'!L4:L10)","v":0},"No",{"$f":"COUNTIF('CYCLE 1 DATA HERE'!L4:L10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!L4:L10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!L14:L20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 1 DATA HERE'!L14:L20)","v":0},"Yes",{"$error":"#DIV/0!"},"CONCENTRATION",{"$f":"IF((T16=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP11 - Lethargy",{"$f":"MAX('CYCLE 1 DATA HERE'!M4:M10)","v":0},"No",{"$f":"COUNTIF('CYCLE 1 DATA HERE'!M4:M10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!M4:M10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!M14:M20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 1 DATA HERE'!M14:M20)","v":0},"Yes",{"$error":"#DIV/0!"},"LETHARGY",{"$f":"IF((T17=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP12 - Appetite, Overeating",{"$f":"MAX('CYCLE 1 DATA HERE'!N4:N10)","v":0},"No",{"$f":"COUNTIF('CYCLE 1 DATA HERE'!N4:N10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!N4:N10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!N14:N20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 1 DATA HERE'!N14:N20)","v":0},"Yes",{"$error":"#DIV/0!"},"APPETITE",{"$f":"IF((T18=\"Yes\")+(T19=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP13 - Food Cravings",{"$f":"MAX('CYCLE 1 DATA HERE'!O4:O10)","v":0},"No",{"$f":"COUNTIF('CYCLE 1 DATA HERE'!O4:O10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!O4:O10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!O14:O20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 1 DATA HERE'!O14:O20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP14 - Hypersomnia",{"$f":"MAX('CYCLE 1 DATA HERE'!P4:P10)","v":0},"No",{"$f":"COUNTIF('CYCLE 1 DATA HERE'!P4:P10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!P4:P10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!P14:P20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 1 DATA HERE'!P14:P20)","v":0},"Yes",{"$error":"#DIV/0!"},"SLEEP",{"$f":"IF((T20=\"Yes\")+(T21=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP15 - Insomnia",{"$f":"MAX('CYCLE 1 DATA HERE'!Q4:Q10)","v":0},"No",{"$f":"COUNTIF('CYCLE 1 DATA HERE'!Q4:Q10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!Q4:Q10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!Q14:Q20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 1 DATA HERE'!Q14:Q20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP16 - Overwhelmed",{"$f":"MAX('CYCLE 1 DATA HERE'!R4:R10)","v":0},"No",{"$f":"COUNTIF('CYCLE 1 DATA HERE'!R4:R10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!R4:R10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!R14:R20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 1 DATA HERE'!R14:R20)","v":0},"Yes",{"$error":"#DIV/0!"},"OVERWHELM",{"$f":"IF((T22=\"Yes\")+(T23=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP17 - Out of Control",{"$f":"MAX('CYCLE 1 DATA HERE'!S4:S10)","v":0},"No",{"$f":"COUNTIF('CYCLE 1 DATA HERE'!S4:S10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!S4:S10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!S14:S20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 1 DATA HERE'!S14:S20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP18 - Breast Tenderness",{"$f":"MAX('CYCLE 1 DATA HERE'!T4:T10)","v":0},"No",{"$f":"COUNTIF('CYCLE 1 DATA HERE'!T4:T10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!T4:T10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!T14:T20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 1 DATA HERE'!T14:T20)","v":0},"Yes",{"$error":"#DIV/0!"},"PHYSICAL",{"$f":"IF((T24=\"Yes\")+(T25=\"Yes\")+(T27=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP19 - Swelling, Bloating",{"$f":"MAX('CYCLE 1 DATA HERE'!U4:U10)","v":0},"No",{"$f":"COUNTIF('CYCLE 1 DATA HERE'!U4:U10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!U4:U10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!U14:U20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 1 DATA HERE'!U14:U20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP20 - Headache",{"$f":"MAX('CYCLE 1 DATA HERE'!V4:V10)","v":0},null,{"$f":"COUNTIF('CYCLE 1 DATA HERE'!V4:V10, \">=4\")","v":0},null,{"$f":"AVERAGE('CYCLE 1 DATA HERE'!V4:V10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!V14:V20)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},null,{"$f":"MAX('CYCLE 1 DATA HERE'!V14:V20)","v":0}]
[null,null,"DRSP21 - Joint, Muscle Pain",{"$f":"MAX('CYCLE 1 DATA HERE'!W4:W10)","v":0},{"$f":"IF(D27>=4,\"Yes\",\"No\")","v":"No"},{"$f":"COUNTIF('CYCLE 1 DATA HERE'!W4:W10, \">=4\")","v":0},{"$f":"IF(F27>=2,\"Yes\",\"No\")","v":"No"},{"$f":"AVERAGE('CYCLE 1 DATA HERE'!W4:W10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!W14:W20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$f":"IF(P27>=30,\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}},{"$f":"MAX('CYCLE 1 DATA HERE'!W14:W20)","v":0},{"$f":"IF(R27<=3,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF((E27=\"No\")+(G27=\"No\")+(Q27=\"No\")+(S27=\"No\"),\"No\",\"Yes\")","v":{"$error":"#DIV/0!"}}]
[null,"Interference","DRSP22 - Work Interference",{"$f":"MAX('CYCLE 1 DATA HERE'!X4:X10)","v":0},null,{"$f":"COUNTIF('CYCLE 1 DATA HERE'!X4:X10, \">=4\")","v":0},null,{"$f":"AVERAGE('CYCLE 1 DATA HERE'!X4:X10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!X14:X20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},null,{"$f":"MAX('CYCLE 1 DATA HERE'!X14:X20)","v":0}]
[null,null,"DRSP23 - Hobby Interference",{"$f":"MAX('CYCLE 1 DATA HERE'!Y4:Y10)","v":0},null,{"$f":"COUNTIF('CYCLE 1 DATA HERE'!Y4:Y10, \">=4\")","v":0},null,{"$f":"AVERAGE('CYCLE 1 DATA HERE'!Y4:Y10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!Y14:Y20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},null,{"$f":"MAX('CYCLE 1 DATA HERE'!Y14:Y20)","v":0}]
[null,null,"DRSP24 ­ Relationship Interference",{"$f":"MAX('CYCLE 1 DATA HERE'!Z4:Z10)","v":0},null,{"$f":"COUNTIF('CYCLE 1 DATA HERE'!Z4:Z10, \">=4\")","v":0},null,{"$f":"AVERAGE('CYCLE 1 DATA HERE'!Z4:Z10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 1 DATA HERE'!Z14:Z20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},null,{"$f":"MAX('CYCLE 1 DATA HERE'!Z14:Z20)","v":0}]
[null,"TOTAL SYMPTOMS MET PER DIMENSION"]
[null,"# of Items Meeting Criteria for: Absolute Severity",null,{"$f":"COUNTIF(E7:E27, \"Yes\")","v":0},"# of Items Meeting Criteria for:  Duration",{"$nulls":3},{"$f":"COUNTIF(G7:G27, \"Yes\")","v":0},null,null,"# of Items Meeting Criteria for:  \nRelative Symptom Change",{"$nulls":5},{"$f":"COUNTIF(Q7:Q27, \"Yes\")","v":0},null,"# of Items Meeting Criteria for:  \nAbsolute Clearance",null,null,{"$f":"COUNTIF(S7:S27, \"Yes\")","v":20}]
[null,"CYCLE-LEVEL SCORING"]
[null,"DSM­5 CRITERION A - CORE EMOTIONAL SYMPTOM: Does a core emotional symptom meet criteria this cycle?",{"$nulls":19},{"$f":"IF((W7=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,"DSM­5 CRITERION B - NUMBER OF SYMPTOMS: Do at least 5 DSM-5 symptoms meet criteria this cycle?",{"$nulls":19}," # of Yes\nAbove:",{"$f":"IF((V36>=5),\"Yes\",\"No\")","v":"No"}]
[{"$nulls":21},{"$f":"COUNTIF(V7:V27, \"Yes\")","v":0}]
[null,"IF A=NO, CYCLE DOES NOT MEET MRMD or PMDD  CRITERIA:",{"$nulls":19},"NO CYCLE DIAGNOSIS"]
[null,"IF A=YES and B=NO, CYCLE MEETS MRMD CRITERIA  :",{"$nulls":19},"MRMD CYCLE DIAGNOSIS"]
[null,"IF A=YES and B=YES, CYCLE MEETS PMDD CRITERIA :",{"$nulls":19},"PMDD CYCLE DIAGNOSIS"]
{"$rows_empty":16}
[{"$nulls":13},"­ "]

{"sheet":"Cycle 2 Diagnosis","index":6,"n_rows":56,"n_cols":23,"rows_kept":56,"merged":[[0,1,0,22],[2,1,3,2],[2,3,2,6],[2,7,2,18],[2,19,2,22],[3,3,3,4],[3,5,3,6],[3,7,3,16],[3,17,3,18],[3,20,5,20],[4,1,4,2],[4,4,5,4],[4,6,5,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[4,13,4,14],[4,16,5,16],[4,18,5,18],[4,19,5,19],[4,21,5,21],[4,22,5,22],[5,1,5,2],[5,7,5,8],[5,9,5,10],[5,11,5,12],[5,13,5,14],[6,1,13,1],[6,20,8,20],[6,21,8,21],[6,22,13,22],[10,20,11,20],[10,21,11,21],[12,20,13,20],[12,21,13,21],[14,1,26,1],[14,22,26,22],[17,20,18,20],[17,21,18,21],[19,20,20,20],[19,21,20,21],[21,20,22,20],[21,21,22,21],[23,20,26,20],[23,21,26,21],[27,1,29,1],[27,20,29,21],[27,22,29,22],[30,1,30,22],[31,1,31,2],[31,4,31,7],[31,8,31,10],[31,11,31,16],[31,17,31,18],[31,19,31,21],[32,1,32,22],[33,1,33,20],[33,21,33,22],[34,1,35,20],[34,22,35,22],[36,1,36,20],[36,21,36,22],[37,1,37,20],[37,21,37,22],[38,1,38,20],[38,21,38,22]]}
[null,"The Carolina Premenstrual Assessment Scoring System (C-PASS)                                                                                                                                                                    © Tory Eisenlohr-Moul, Ph.D."]
[null,"Please see:  Eisenlohr-Moul, Girdler, Schmalenberger, Dawson, Surana, Johnson, and Rubinow (2017).  American Journal of Psychiatry.",{"$nulls":19},"t.eisenlohr.moul@gmail.com"]
[null,"C-PASS:                                                                                                                 CYCLE #  2 ",null,"CLINICAL SIGNIFICANCE DIMENSIONS",{"$nulls":3},"CYCLICITY                                                                                                                                                                                                                                                                                                                                                                                                                                        DIMENSIONS"]
[{"$nulls":3},"Absolute Severity",null,"Duration",null,"Relative Symptom Change",{"$nulls":9},"Absolute Clearance",null,"DOES DRSP ITEM MEET CRITERIA?","DSM­5 SYMPTOM DOMAIN","DOES DSM-5 SYMPTOM MEET CRITERIA?","DOES A CORE EMOTIONAL SYMPTOM MEET CRITERIA?"]
[null,{"$f":"'CYCLE 1 DATA HERE'!B1","v":0},null,"Pre-menstrual Max","IF >=4, YES   ","# of Severe (>=4) Days","IF >=2,  YES ","Pre-menstrual Mean",null,"Post-menstrual Mean",null,"Raw Cyclical Change",null,"Woman's Scale Range (Constant)",null,"Cyclical Change as\n% of Scale Range","IF\n>=30%, YES","Post-menses Maximum","IF <=3, YES","IF ALL DIMENSIONS IN ROW = YES",null,"YES IF AT LEAST ONE DRSP ITEM IN THIS DOMAIN = YES","YES IF ANY OF FIRST FOUR DOMAINS = YES"]
[null,"INSTRUCTIONS: Start Here and Work Across to the Right by Row. Note: Day -1 = Day before the Onset of Menstrual Period Day 1 = Onset of Menstrual Period.",null,"Identify Highest Item Rating Day -7 to -1",null,"Count Number of Days Day ­7\nto ­1 where Item Rating is\n>=4",null,"Calculate Average Item Rating Day ­7 to - 1",null,"Calculate Average Item Rating Day 4 to 10",null,"Subtract Post-menstrual Mean from Pre­menstrual Mean",null,"Calculate Range: (Max Rating Across ALL DRSP\nResponses - 1)",null,"z",null,"Identify Highest Item Rating Day 4 to 10"]
[null,"Core Emotional Symptoms","DRSP1 - Depressed, Blue",{"$f":"MAX('CYCLE 2 DATA HERE'!C4:C10)","v":0},{"$f":"IF(D7>=4,\"Yes\",\"No\")","v":"No"},{"$f":"COUNTIF('CYCLE 2 DATA HERE'!C4:C10, \">=4\")","v":0},{"$f":"IF(F7>=2,\"Yes\",\"No\")","v":"No"},{"$f":"AVERAGE('CYCLE 2 DATA HERE'!C4:C10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!C14:C20)","v":{"$error":"#DIV/0!"}},"=",{"$f":"H7-J7","v":{"$error":"#DIV/0!"}},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$f":"(L7/N7)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(P7>=30,\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}},{"$f":"MAX('CYCLE 2 DATA HERE'!C14:C20)","v":0},{"$f":"IF(R7<=3,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF((E7=\"No\")+(G7=\"No\")+(Q7=\"No\")+(S7=\"No\"),\"No\",\"Yes\")","v":{"$error":"#DIV/0!"}},"DEPRESSION",{"$f":"IF((T7=\"Yes\")+(T8=\"Yes\")+(T9=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}},{"$f":"IF((V7=\"Yes\")+(V10=\"Yes\")+(V11=\"Yes\")+(V12=\"Yes\")+(V13=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP2 - Hopelessness",{"$f":"MAX('CYCLE 2 DATA HERE'!D4:D10)","v":0},"No",{"$f":"COUNTIF('CYCLE 2 DATA HERE'!D4:D10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!D4:D10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!D14:D20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 2 DATA HERE'!D14:D20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP3 - Worthlessness or Guilt",{"$f":"MAX('CYCLE 2 DATA HERE'!E4:E10)","v":0},"No",{"$f":"COUNTIF('CYCLE 2 DATA HERE'!E4:E10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!E4:E10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!E14:E20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 2 DATA HERE'!E14:E20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP4 - Anxiety",{"$f":"MAX('CYCLE 2 DATA HERE'!F4:F10)","v":0},"No",{"$f":"COUNTIF('CYCLE 2 DATA HERE'!F4:F10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!F4:F10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!F14:F20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 2 DATA HERE'!F14:F20)","v":0},"Yes",{"$error":"#DIV/0!"},"ANXIETY",{"$f":"IF((T10=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP5 - Mood Swings",{"$f":"MAX('CYCLE 2 DATA HERE'!G4:G10)","v":0},"No",{"$f":"COUNTIF('CYCLE 2 DATA HERE'!G4:G10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!G4:G10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!G14:G20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 2 DATA HERE'!G14:G20)","v":0},"Yes",{"$error":"#DIV/0!"},"MOOD LABILITY",{"$f":"IF((T11=\"Yes\")+(T12=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP6 - Rejection Sensitivity",{"$f":"MAX('CYCLE 2 DATA HERE'!H4:H10)","v":0},"No",{"$f":"COUNTIF('CYCLE 2 DATA HERE'!H4:H10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!H4:H10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!H14:H20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 2 DATA HERE'!H14:H20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP7 - Anger or Irritability",{"$f":"MAX('CYCLE 2 DATA HERE'!I4:I10)","v":0},"No",{"$f":"COUNTIF('CYCLE 2 DATA HERE'!I4:I10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!I4:I10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!I14:I20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 2 DATA HERE'!I14:I20)","v":0},"Yes",{"$error":"#DIV/0!"},"ANGER",{"$f":"IF((T13=\"Yes\")+(T14=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP8 - Interpersonal Conflict",{"$f":"MAX('CYCLE 2 DATA HERE'!J4:J10)","v":0},"No",{"$f":"COUNTIF('CYCLE 2 DATA HERE'!J4:J10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!J4:J10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!J14:J20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 2 DATA HERE'!J14:J20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,"Secondary Symptoms","DRSP9 - Less Interest",{"$f":"MAX('CYCLE 2 DATA HERE'!K4:K10)","v":0},"No",{"$f":"COUNTIF('CYCLE 2 DATA HERE'!K4:K10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!K4:K10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!K14:K20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 2 DATA HERE'!K14:K20)","v":0},"Yes",{"$error":"#DIV/0!"},"INTEREST",{"$f":"IF((T15=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP10 - Difficulty Concentrating",{"$f":"MAX('CYCLE 2 DATA HERE'!L4:L10)","v":0},"No",{"$f":"COUNTIF('CYCLE 2 DATA HERE'!L4:L10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!L4:L10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!L14:L20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 2 DATA HERE'!L14:L20)","v":0},"Yes",{"$error":"#DIV/0!"},"CONCENTRATION",{"$f":"IF((T16=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP11 - Lethargy",{"$f":"MAX('CYCLE 2 DATA HERE'!M4:M10)","v":0},"No",{"$f":"COUNTIF('CYCLE 2 DATA HERE'!M4:M10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!M4:M10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!M14:M20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 2 DATA HERE'!M14:M20)","v":0},"Yes",{"$error":"#DIV/0!"},"LETHARGY",{"$f":"IF((T17=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP12 - Appetite, Overeating",{"$f":"MAX('CYCLE 2 DATA HERE'!N4:N10)","v":0},"No",{"$f":"COUNTIF('CYCLE 2 DATA HERE'!N4:N10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!N4:N10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!N14:N20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 2 DATA HERE'!N14:N20)","v":0},"Yes",{"$error":"#DIV/0!"},"APPETITE",{"$f":"IF((T18=\"Yes\")+(T19=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP13 - Food Cravings",{"$f":"MAX('CYCLE 2 DATA HERE'!O4:O10)","v":0},"No",{"$f":"COUNTIF('CYCLE 2 DATA HERE'!O4:O10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!O4:O10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!O14:O20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 2 DATA HERE'!O14:O20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP14 - Hypersomnia",{"$f":"MAX('CYCLE 2 DATA HERE'!P4:P10)","v":0},"No",{"$f":"COUNTIF('CYCLE 2 DATA HERE'!P4:P10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!P4:P10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!P14:P20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 2 DATA HERE'!P14:P20)","v":0},"Yes",{"$error":"#DIV/0!"},"SLEEP",{"$f":"IF((T20=\"Yes\")+(T21=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP15 - Insomnia",{"$f":"MAX('CYCLE 2 DATA HERE'!Q4:Q10)","v":0},"No",{"$f":"COUNTIF('CYCLE 2 DATA HERE'!Q4:Q10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!Q4:Q10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!Q14:Q20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 2 DATA HERE'!Q14:Q20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP16 - Overwhelmed",{"$f":"MAX('CYCLE 2 DATA HERE'!R4:R10)","v":0},"No",{"$f":"COUNTIF('CYCLE 2 DATA HERE'!R4:R10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!R4:R10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!R14:R20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 2 DATA HERE'!R14:R20)","v":0},"Yes",{"$error":"#DIV/0!"},"OVERWHELM",{"$f":"IF((T22=\"Yes\")+(T23=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP17 - Out of Control",{"$f":"MAX('CYCLE 2 DATA HERE'!S4:S10)","v":0},"No",{"$f":"COUNTIF('CYCLE 2 DATA HERE'!S4:S10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!S4:S10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!S14:S20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 2 DATA HERE'!S14:S20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP18 - Breast Tenderness",{"$f":"MAX('CYCLE 2 DATA HERE'!T4:T10)","v":0},"No",{"$f":"COUNTIF('CYCLE 2 DATA HERE'!T4:T10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!T4:T10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!T14:T20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 2 DATA HERE'!T14:T20)","v":0},"Yes",{"$error":"#DIV/0!"},"PHYSICAL",{"$f":"IF((T24=\"Yes\")+(T25=\"Yes\")+(T27=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP19 - Swelling, Bloating",{"$f":"MAX('CYCLE 2 DATA HERE'!U4:U10)","v":0},"No",{"$f":"COUNTIF('CYCLE 2 DATA HERE'!U4:U10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!U4:U10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!U14:U20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 2 DATA HERE'!U14:U20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP20 - Headache",{"$f":"MAX('CYCLE 2 DATA HERE'!V4:V10)","v":0},null,{"$f":"COUNTIF('CYCLE 2 DATA HERE'!V4:V10, \">=4\")","v":0},null,{"$f":"AVERAGE('CYCLE 2 DATA HERE'!V4:V10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!V14:V20)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},null,{"$f":"MAX('CYCLE 2 DATA HERE'!V14:V20)","v":0}]
[null,null,"DRSP21 - Joint, Muscle Pain",{"$f":"MAX('CYCLE 2 DATA HERE'!W4:W10)","v":0},{"$f":"IF(D27>=4,\"Yes\",\"No\")","v":"No"},{"$f":"COUNTIF('CYCLE 2 DATA HERE'!W4:W10, \">=4\")","v":0},{"$f":"IF(F27>=2,\"Yes\",\"No\")","v":"No"},{"$f":"AVERAGE('CYCLE 2 DATA HERE'!W4:W10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!W14:W20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$f":"IF(P27>=30,\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}},{"$f":"MAX('CYCLE 2 DATA HERE'!W14:W20)","v":0},{"$f":"IF(R27<=3,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF((E27=\"No\")+(G27=\"No\")+(Q27=\"No\")+(S27=\"No\"),\"No\",\"Yes\")","v":{"$error":"#DIV/0!"}}]
[null,"Interference","DRSP22 - Work Interference",{"$f":"MAX('CYCLE 2 DATA HERE'!X4:X10)","v":0},null,{"$f":"COUNTIF('CYCLE 2 DATA HERE'!X4:X10, \">=4\")","v":0},null,{"$f":"AVERAGE('CYCLE 2 DATA HERE'!X4:X10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!X14:X20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},null,{"$f":"MAX('CYCLE 2 DATA HERE'!X14:X20)","v":0}]
[null,null,"DRSP23 - Hobby Interference",{"$f":"MAX('CYCLE 2 DATA HERE'!Y4:Y10)","v":0},null,{"$f":"COUNTIF('CYCLE 2 DATA HERE'!Y4:Y10, \">=4\")","v":0},null,{"$f":"AVERAGE('CYCLE 2 DATA HERE'!Y4:Y10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!Y14:Y20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},null,{"$f":"MAX('CYCLE 2 DATA HERE'!Y14:Y20)","v":0}]
[null,null,"DRSP24 ­ Relationship Interference",{"$f":"MAX('CYCLE 2 DATA HERE'!Z4:Z10)","v":0},null,{"$f":"COUNTIF('CYCLE 2 DATA HERE'!Z4:Z10, \">=4\")","v":0},null,{"$f":"AVERAGE('CYCLE 2 DATA HERE'!Z4:Z10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 2 DATA HERE'!Z14:Z20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},null,{"$f":"MAX('CYCLE 2 DATA HERE'!Z14:Z20)","v":0}]
[null,"TOTAL SYMPTOMS MET PER DIMENSION"]
[null,"# of Items Meeting Criteria for: Absolute Severity",null,{"$f":"COUNTIF(E7:E27, \"Yes\")","v":0},"# of Items Meeting Criteria for:  Duration",{"$nulls":3},{"$f":"COUNTIF(G7:G27, \"Yes\")","v":0},null,null,"# of Items Meeting Criteria for:  \nRelative Symptom Change",{"$nulls":5},{"$f":"COUNTIF(Q7:Q27, \"Yes\")","v":0},null,"# of Items Meeting Criteria for:  \nAbsolute Clearance",null,null,{"$f":"COUNTIF(S7:S27, \"Yes\")","v":20}]
[null,"CYCLE-LEVEL SCORING"]
[null,"DSM­5 CRITERION A - CORE EMOTIONAL SYMPTOM: Does a core emotional symptom meet criteria this cycle?",{"$nulls":19},{"$f":"IF((W7=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,"DSM­5 CRITERION B - NUMBER OF SYMPTOMS: Do at least 5 DSM-5 symptoms meet criteria this cycle?",{"$nulls":19}," # of Yes\nAbove:",{"$f":"IF((V36>=5),\"Yes\",\"No\")","v":"No"}]
[{"$nulls":21},{"$f":"COUNTIF(V7:V27, \"Yes\")","v":0}]
[null,"IF A=NO, CYCLE DOES NOT MEET MRMD or PMDD  CRITERIA:",{"$nulls":19},"NO CYCLE DIAGNOSIS"]
[null,"IF A=YES and B=NO, CYCLE MEETS MRMD CRITERIA  :",{"$nulls":19},"MRMD CYCLE DIAGNOSIS"]
[null,"IF A=YES and B=YES, CYCLE MEETS PMDD CRITERIA :",{"$nulls":19},"PMDD CYCLE DIAGNOSIS"]
{"$rows_empty":16}
[{"$nulls":13},"­ "]

{"sheet":"Cycle 3 Diagnosis","index":7,"n_rows":56,"n_cols":23,"rows_kept":56,"merged":[[0,1,0,22],[2,1,3,2],[2,3,2,6],[2,7,2,18],[2,19,2,22],[3,3,3,4],[3,5,3,6],[3,7,3,16],[3,17,3,18],[3,20,5,20],[4,1,4,2],[4,4,5,4],[4,6,5,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[4,13,4,14],[4,16,5,16],[4,18,5,18],[4,19,5,19],[4,21,5,21],[4,22,5,22],[5,1,5,2],[5,7,5,8],[5,9,5,10],[5,11,5,12],[5,13,5,14],[6,1,13,1],[6,20,8,20],[6,21,8,21],[6,22,13,22],[10,20,11,20],[10,21,11,21],[12,20,13,20],[12,21,13,21],[14,1,26,1],[14,22,26,22],[17,20,18,20],[17,21,18,21],[19,20,20,20],[19,21,20,21],[21,20,22,20],[21,21,22,21],[23,20,26,20],[23,21,26,21],[27,1,29,1],[27,20,29,21],[27,22,29,22],[30,1,30,22],[31,1,31,2],[31,4,31,7],[31,8,31,10],[31,11,31,16],[31,17,31,18],[31,19,31,21],[32,1,32,22],[33,1,33,20],[33,21,33,22],[34,1,35,20],[34,22,35,22],[36,1,36,20],[36,21,36,22],[37,1,37,20],[37,21,37,22],[38,1,38,20],[38,21,38,22]]}
[null,"The Carolina Premenstrual Assessment Scoring System (C-PASS)                                                                                                                                                                    © Tory Eisenlohr-Moul, Ph.D."]
[null,"Please see:  Eisenlohr-Moul, Girdler, Schmalenberger, Dawson, Surana, Johnson, and Rubinow (2017).  American Journal of Psychiatry.",{"$nulls":19},"t.eisenlohr.moul@gmail.com"]
[null,"C-PASS:                                                                                                                 CYCLE #  3 ",null,"CLINICAL SIGNIFICANCE DIMENSIONS",{"$nulls":3},"CYCLICITY                                                                                                                                                                                                                                                                                                                                                                                                                                        DIMENSIONS"]
[{"$nulls":3},"Absolute Severity",null,"Duration",null,"Relative Symptom Change",{"$nulls":9},"Absolute Clearance",null,"DOES DRSP ITEM MEET CRITERIA?","DSM­5 SYMPTOM DOMAIN","DOES DSM-5 SYMPTOM MEET CRITERIA?","DOES A CORE EMOTIONAL SYMPTOM MEET CRITERIA?"]
[null,{"$f":"'CYCLE 1 DATA HERE'!B1","v":0},null,"Pre-menstrual Max","IF >=4, YES   ","# of Severe (>=4) Days","IF >=2,  YES ","Pre-menstrual Mean",null,"Post-menstrual Mean",null,"Raw Cyclical Change",null,"Woman's Scale Range (Constant)",null,"Cyclical Change as\n% of Scale Range","IF\n>=30%, YES","Post-menses Maximum","IF <=3, YES","IF ALL DIMENSIONS IN ROW = YES",null,"YES IF AT LEAST ONE DRSP ITEM IN THIS DOMAIN = YES","YES IF ANY OF FIRST FOUR DOMAINS = YES"]
[null,"INSTRUCTIONS: Start Here and Work Across to the Right by Row. Note: Day -1 = Day before the Onset of Menstrual Period Day 1 = Onset of Menstrual Period.",null,"Identify Highest Item Rating Day -7 to -1",null,"Count Number of Days Day ­7\nto ­1 where Item Rating is\n>=4",null,"Calculate Average Item Rating Day ­7 to - 1",null,"Calculate Average Item Rating Day 4 to 10",null,"Subtract Post-menstrual Mean from Pre­menstrual Mean",null,"Calculate Range: (Max Rating Across ALL DRSP\nResponses - 1)",null,"z",null,"Identify Highest Item Rating Day 4 to 10"]
[null,"Core Emotional Symptoms","DRSP1 - Depressed, Blue",{"$f":"MAX('CYCLE 3 DATA HERE'!C4:C10)","v":0},{"$f":"IF(D7>=4,\"Yes\",\"No\")","v":"No"},{"$f":"COUNTIF('CYCLE 3 DATA HERE'!C4:C10, \">=4\")","v":0},{"$f":"IF(F7>=2,\"Yes\",\"No\")","v":"No"},{"$f":"AVERAGE('CYCLE 3 DATA HERE'!C4:C10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!C14:C20)","v":{"$error":"#DIV/0!"}},"=",{"$f":"H7-J7","v":{"$error":"#DIV/0!"}},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$f":"(L7/N7)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(P7>=30,\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}},{"$f":"MAX('CYCLE 3 DATA HERE'!C14:C20)","v":0},{"$f":"IF(R7<=3,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF((E7=\"No\")+(G7=\"No\")+(Q7=\"No\")+(S7=\"No\"),\"No\",\"Yes\")","v":{"$error":"#DIV/0!"}},"DEPRESSION",{"$f":"IF((T7=\"Yes\")+(T8=\"Yes\")+(T9=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}},{"$f":"IF((V7=\"Yes\")+(V10=\"Yes\")+(V11=\"Yes\")+(V12=\"Yes\")+(V13=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP2 - Hopelessness",{"$f":"MAX('CYCLE 3 DATA HERE'!D4:D10)","v":0},"No",{"$f":"COUNTIF('CYCLE 3 DATA HERE'!D4:D10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!D4:D10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!D14:D20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 3 DATA HERE'!D14:D20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP3 - Worthlessness or Guilt",{"$f":"MAX('CYCLE 3 DATA HERE'!E4:E10)","v":0},"No",{"$f":"COUNTIF('CYCLE 3 DATA HERE'!E4:E10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!E4:E10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!E14:E20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 3 DATA HERE'!E14:E20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP4 - Anxiety",{"$f":"MAX('CYCLE 3 DATA HERE'!F4:F10)","v":0},"No",{"$f":"COUNTIF('CYCLE 3 DATA HERE'!F4:F10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!F4:F10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!F14:F20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 3 DATA HERE'!F14:F20)","v":0},"Yes",{"$error":"#DIV/0!"},"ANXIETY",{"$f":"IF((T10=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP5 - Mood Swings",{"$f":"MAX('CYCLE 3 DATA HERE'!G4:G10)","v":0},"No",{"$f":"COUNTIF('CYCLE 3 DATA HERE'!G4:G10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!G4:G10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!G14:G20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 3 DATA HERE'!G14:G20)","v":0},"Yes",{"$error":"#DIV/0!"},"MOOD LABILITY",{"$f":"IF((T11=\"Yes\")+(T12=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP6 - Rejection Sensitivity",{"$f":"MAX('CYCLE 3 DATA HERE'!H4:H10)","v":0},"No",{"$f":"COUNTIF('CYCLE 3 DATA HERE'!H4:H10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!H4:H10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!H14:H20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 3 DATA HERE'!H14:H20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP7 - Anger or Irritability",{"$f":"MAX('CYCLE 3 DATA HERE'!I4:I10)","v":0},"No",{"$f":"COUNTIF('CYCLE 3 DATA HERE'!I4:I10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!I4:I10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!I14:I20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 3 DATA HERE'!I14:I20)","v":0},"Yes",{"$error":"#DIV/0!"},"ANGER",{"$f":"IF((T13=\"Yes\")+(T14=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP8 - Interpersonal Conflict",{"$f":"MAX('CYCLE 3 DATA HERE'!J4:J10)","v":0},"No",{"$f":"COUNTIF('CYCLE 3 DATA HERE'!J4:J10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!J4:J10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!J14:J20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 3 DATA HERE'!J14:J20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,"Secondary Symptoms","DRSP9 - Less Interest",{"$f":"MAX('CYCLE 3 DATA HERE'!K4:K10)","v":0},"No",{"$f":"COUNTIF('CYCLE 3 DATA HERE'!K4:K10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!K4:K10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!K14:K20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 3 DATA HERE'!K14:K20)","v":0},"Yes",{"$error":"#DIV/0!"},"INTEREST",{"$f":"IF((T15=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP10 - Difficulty Concentrating",{"$f":"MAX('CYCLE 3 DATA HERE'!L4:L10)","v":0},"No",{"$f":"COUNTIF('CYCLE 3 DATA HERE'!L4:L10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!L4:L10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!L14:L20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 3 DATA HERE'!L14:L20)","v":0},"Yes",{"$error":"#DIV/0!"},"CONCENTRATION",{"$f":"IF((T16=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP11 - Lethargy",{"$f":"MAX('CYCLE 3 DATA HERE'!M4:M10)","v":0},"No",{"$f":"COUNTIF('CYCLE 3 DATA HERE'!M4:M10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!M4:M10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!M14:M20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 3 DATA HERE'!M14:M20)","v":0},"Yes",{"$error":"#DIV/0!"},"LETHARGY",{"$f":"IF((T17=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP12 - Appetite, Overeating",{"$f":"MAX('CYCLE 3 DATA HERE'!N4:N10)","v":0},"No",{"$f":"COUNTIF('CYCLE 3 DATA HERE'!N4:N10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!N4:N10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!N14:N20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 3 DATA HERE'!N14:N20)","v":0},"Yes",{"$error":"#DIV/0!"},"APPETITE",{"$f":"IF((T18=\"Yes\")+(T19=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP13 - Food Cravings",{"$f":"MAX('CYCLE 3 DATA HERE'!O4:O10)","v":0},"No",{"$f":"COUNTIF('CYCLE 3 DATA HERE'!O4:O10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!O4:O10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!O14:O20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 3 DATA HERE'!O14:O20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP14 - Hypersomnia",{"$f":"MAX('CYCLE 3 DATA HERE'!P4:P10)","v":0},"No",{"$f":"COUNTIF('CYCLE 3 DATA HERE'!P4:P10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!P4:P10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!P14:P20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 3 DATA HERE'!P14:P20)","v":0},"Yes",{"$error":"#DIV/0!"},"SLEEP",{"$f":"IF((T20=\"Yes\")+(T21=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP15 - Insomnia",{"$f":"MAX('CYCLE 3 DATA HERE'!Q4:Q10)","v":0},"No",{"$f":"COUNTIF('CYCLE 3 DATA HERE'!Q4:Q10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!Q4:Q10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!Q14:Q20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 3 DATA HERE'!Q14:Q20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP16 - Overwhelmed",{"$f":"MAX('CYCLE 3 DATA HERE'!R4:R10)","v":0},"No",{"$f":"COUNTIF('CYCLE 3 DATA HERE'!R4:R10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!R4:R10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!R14:R20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 3 DATA HERE'!R14:R20)","v":0},"Yes",{"$error":"#DIV/0!"},"OVERWHELM",{"$f":"IF((T22=\"Yes\")+(T23=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP17 - Out of Control",{"$f":"MAX('CYCLE 3 DATA HERE'!S4:S10)","v":0},"No",{"$f":"COUNTIF('CYCLE 3 DATA HERE'!S4:S10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!S4:S10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!S14:S20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 3 DATA HERE'!S14:S20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP18 - Breast Tenderness",{"$f":"MAX('CYCLE 3 DATA HERE'!T4:T10)","v":0},"No",{"$f":"COUNTIF('CYCLE 3 DATA HERE'!T4:T10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!T4:T10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!T14:T20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 3 DATA HERE'!T14:T20)","v":0},"Yes",{"$error":"#DIV/0!"},"PHYSICAL",{"$f":"IF((T24=\"Yes\")+(T25=\"Yes\")+(T27=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP19 - Swelling, Bloating",{"$f":"MAX('CYCLE 3 DATA HERE'!U4:U10)","v":0},"No",{"$f":"COUNTIF('CYCLE 3 DATA HERE'!U4:U10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!U4:U10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!U14:U20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 3 DATA HERE'!U14:U20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP20 - Headache",{"$f":"MAX('CYCLE 3 DATA HERE'!V4:V10)","v":0},null,{"$f":"COUNTIF('CYCLE 3 DATA HERE'!V4:V10, \">=4\")","v":0},null,{"$f":"AVERAGE('CYCLE 3 DATA HERE'!V4:V10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!V14:V20)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},null,{"$f":"MAX('CYCLE 3 DATA HERE'!V14:V20)","v":0}]
[null,null,"DRSP21 - Joint, Muscle Pain",{"$f":"MAX('CYCLE 3 DATA HERE'!W4:W10)","v":0},{"$f":"IF(D27>=4,\"Yes\",\"No\")","v":"No"},{"$f":"COUNTIF('CYCLE 3 DATA HERE'!W4:W10, \">=4\")","v":0},{"$f":"IF(F27>=2,\"Yes\",\"No\")","v":"No"},{"$f":"AVERAGE('CYCLE 3 DATA HERE'!W4:W10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!W14:W20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$f":"IF(P27>=30,\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}},{"$f":"MAX('CYCLE 3 DATA HERE'!W14:W20)","v":0},{"$f":"IF(R27<=3,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF((E27=\"No\")+(G27=\"No\")+(Q27=\"No\")+(S27=\"No\"),\"No\",\"Yes\")","v":{"$error":"#DIV/0!"}}]
[null,"Interference","DRSP22 - Work Interference",{"$f":"MAX('CYCLE 3 DATA HERE'!X4:X10)","v":0},null,{"$f":"COUNTIF('CYCLE 3 DATA HERE'!X4:X10, \">=4\")","v":0},null,{"$f":"AVERAGE('CYCLE 3 DATA HERE'!X4:X10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!X14:X20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},null,{"$f":"MAX('CYCLE 3 DATA HERE'!X14:X20)","v":0}]
[null,null,"DRSP23 - Hobby Interference",{"$f":"MAX('CYCLE 3 DATA HERE'!Y4:Y10)","v":0},null,{"$f":"COUNTIF('CYCLE 3 DATA HERE'!Y4:Y10, \">=4\")","v":0},null,{"$f":"AVERAGE('CYCLE 3 DATA HERE'!Y4:Y10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!Y14:Y20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},null,{"$f":"MAX('CYCLE 3 DATA HERE'!Y14:Y20)","v":0}]
[null,null,"DRSP24 ­ Relationship Interference",{"$f":"MAX('CYCLE 3 DATA HERE'!Z4:Z10)","v":0},null,{"$f":"COUNTIF('CYCLE 3 DATA HERE'!Z4:Z10, \">=4\")","v":0},null,{"$f":"AVERAGE('CYCLE 3 DATA HERE'!Z4:Z10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 3 DATA HERE'!Z14:Z20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},null,{"$f":"MAX('CYCLE 3 DATA HERE'!Z14:Z20)","v":0}]
[null,"TOTAL SYMPTOMS MET PER DIMENSION"]
[null,"# of Items Meeting Criteria for: Absolute Severity",null,{"$f":"COUNTIF(E7:E27, \"Yes\")","v":0},"# of Items Meeting Criteria for:  Duration",{"$nulls":3},{"$f":"COUNTIF(G7:G27, \"Yes\")","v":0},null,null,"# of Items Meeting Criteria for:  \nRelative Symptom Change",{"$nulls":5},{"$f":"COUNTIF(Q7:Q27, \"Yes\")","v":0},null,"# of Items Meeting Criteria for:  \nAbsolute Clearance",null,null,{"$f":"COUNTIF(S7:S27, \"Yes\")","v":20}]
[null,"CYCLE-LEVEL SCORING"]
[null,"DSM­5 CRITERION A - CORE EMOTIONAL SYMPTOM: Does a core emotional symptom meet criteria this cycle?",{"$nulls":19},{"$f":"IF((W7=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,"DSM­5 CRITERION B - NUMBER OF SYMPTOMS: Do at least 5 DSM-5 symptoms meet criteria this cycle?",{"$nulls":19}," # of Yes\nAbove:",{"$f":"IF((V36>=5),\"Yes\",\"No\")","v":"No"}]
[{"$nulls":21},{"$f":"COUNTIF(V7:V27, \"Yes\")","v":0}]
[null,"IF A=NO, CYCLE DOES NOT MEET MRMD or PMDD  CRITERIA:",{"$nulls":19},"NO CYCLE DIAGNOSIS"]
[null,"IF A=YES and B=NO, CYCLE MEETS MRMD CRITERIA  :",{"$nulls":19},"MRMD CYCLE DIAGNOSIS"]
[null,"IF A=YES and B=YES, CYCLE MEETS PMDD CRITERIA :",{"$nulls":19},"PMDD CYCLE DIAGNOSIS"]
{"$rows_empty":16}
[{"$nulls":13},"­ "]

{"sheet":"Cycle 4 Diagnosis","index":8,"n_rows":56,"n_cols":23,"rows_kept":56,"merged":[[0,1,0,22],[2,1,3,2],[2,3,2,6],[2,7,2,18],[2,19,2,22],[3,3,3,4],[3,5,3,6],[3,7,3,16],[3,17,3,18],[3,20,5,20],[4,1,4,2],[4,4,5,4],[4,6,5,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[4,13,4,14],[4,16,5,16],[4,18,5,18],[4,19,5,19],[4,21,5,21],[4,22,5,22],[5,1,5,2],[5,7,5,8],[5,9,5,10],[5,11,5,12],[5,13,5,14],[6,1,13,1],[6,20,8,20],[6,21,8,21],[6,22,13,22],[10,20,11,20],[10,21,11,21],[12,20,13,20],[12,21,13,21],[14,1,26,1],[14,22,26,22],[17,20,18,20],[17,21,18,21],[19,20,20,20],[19,21,20,21],[21,20,22,20],[21,21,22,21],[23,20,26,20],[23,21,26,21],[27,1,29,1],[27,20,29,21],[27,22,29,22],[30,1,30,22],[31,1,31,2],[31,4,31,7],[31,8,31,10],[31,11,31,16],[31,17,31,18],[31,19,31,21],[32,1,32,22],[33,1,33,20],[33,21,33,22],[34,1,35,20],[34,22,35,22],[36,1,36,20],[36,21,36,22],[37,1,37,20],[37,21,37,22],[38,1,38,20],[38,21,38,22]]}
[null,"The Carolina Premenstrual Assessment Scoring System (C-PASS)                                                                                                                                                                       © Tory Eisenlohr-Moul, Ph.D."]
[null,"Please see:  Eisenlohr-Moul, Girdler, Schmalenberger, Dawson, Surana, Johnson, and Rubinow (2017).  American Journal of Psychiatry.",{"$nulls":19},"t.eisenlohr.moul@gmail.com"]
[null,"C-PASS:                                                                                                                 CYCLE #  4 ",null,"CLINICAL SIGNIFICANCE DIMENSIONS",{"$nulls":3},"CYCLICITY                                                                                                                                                                                                                                                                                                                                                                                                                                        DIMENSIONS"]
[{"$nulls":3},"Absolute Severity",null,"Duration",null,"Relative Symptom Change",{"$nulls":9},"Absolute Clearance",null,"DOES DRSP ITEM MEET CRITERIA?","DSM­5 SYMPTOM DOMAIN","DOES DSM-5 SYMPTOM MEET CRITERIA?","DOES A CORE EMOTIONAL SYMPTOM MEET CRITERIA?"]
[null,{"$f":"'CYCLE 1 DATA HERE'!B1","v":0},null,"Pre-menstrual Max","IF >=4, YES   ","# of Severe (>=4) Days","IF >=2,  YES ","Pre-menstrual Mean",null,"Post-menstrual Mean",null,"Raw Cyclical Change",null,"Woman's Scale Range (Constant)",null,"Cyclical Change as\n% of Scale Range","IF\n>=30%, YES","Post-menses Maximum","IF <=3, YES","IF ALL DIMENSIONS IN ROW = YES",null,"YES IF AT LEAST ONE DRSP ITEM IN THIS DOMAIN = YES","YES IF ANY OF FIRST FOUR DOMAINS = YES"]
[null,"INSTRUCTIONS: Start Here and Work Across to the Right by Row. Note: Day -1 = Day before the Onset of Menstrual Period Day 1 = Onset of Menstrual Period.",null,"Identify Highest Item Rating Day -7 to -1",null,"Count Number of Days Day ­7\nto ­1 where Item Rating is\n>=4",null,"Calculate Average Item Rating Day ­7 to - 1",null,"Calculate Average Item Rating Day 4 to 10",null,"Subtract Post-menstrual Mean from Pre­menstrual Mean",null,"Calculate Range: (Max Rating Across ALL DRSP\nResponses - 1)",null,"z",null,"Identify Highest Item Rating Day 4 to 10"]
[null,"Core Emotional Symptoms","DRSP1 - Depressed, Blue",{"$f":"MAX('CYCLE 4 DATA HERE'!C4:C10)","v":0},{"$f":"IF(D7>=4,\"Yes\",\"No\")","v":"No"},{"$f":"COUNTIF('CYCLE 4 DATA HERE'!C4:C10, \">=4\")","v":0},{"$f":"IF(F7>=2,\"Yes\",\"No\")","v":"No"},{"$f":"AVERAGE('CYCLE 4 DATA HERE'!C4:C10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!C14:C20)","v":{"$error":"#DIV/0!"}},"=",{"$f":"H7-J7","v":{"$error":"#DIV/0!"}},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$f":"(L7/N7)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(P7>=30,\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}},{"$f":"MAX('CYCLE 4 DATA HERE'!C14:C20)","v":0},{"$f":"IF(R7<=3,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF((E7=\"No\")+(G7=\"No\")+(Q7=\"No\")+(S7=\"No\"),\"No\",\"Yes\")","v":{"$error":"#DIV/0!"}},"DEPRESSION",{"$f":"IF((T7=\"Yes\")+(T8=\"Yes\")+(T9=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}},{"$f":"IF((V7=\"Yes\")+(V10=\"Yes\")+(V11=\"Yes\")+(V12=\"Yes\")+(V13=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP2 - Hopelessness",{"$f":"MAX('CYCLE 4 DATA HERE'!D4:D10)","v":0},"No",{"$f":"COUNTIF('CYCLE 4 DATA HERE'!D4:D10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!D4:D10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!D14:D20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 4 DATA HERE'!D14:D20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP3 - Worthlessness or Guilt",{"$f":"MAX('CYCLE 4 DATA HERE'!E4:E10)","v":0},"No",{"$f":"COUNTIF('CYCLE 4 DATA HERE'!E4:E10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!E4:E10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!E14:E20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 4 DATA HERE'!E14:E20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP4 - Anxiety",{"$f":"MAX('CYCLE 4 DATA HERE'!F4:F10)","v":0},"No",{"$f":"COUNTIF('CYCLE 4 DATA HERE'!F4:F10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!F4:F10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!F14:F20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 4 DATA HERE'!F14:F20)","v":0},"Yes",{"$error":"#DIV/0!"},"ANXIETY",{"$f":"IF((T10=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP5 - Mood Swings",{"$f":"MAX('CYCLE 4 DATA HERE'!G4:G10)","v":0},"No",{"$f":"COUNTIF('CYCLE 4 DATA HERE'!G4:G10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!G4:G10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!G14:G20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 4 DATA HERE'!G14:G20)","v":0},"Yes",{"$error":"#DIV/0!"},"MOOD LABILITY",{"$f":"IF((T11=\"Yes\")+(T12=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP6 - Rejection Sensitivity",{"$f":"MAX('CYCLE 4 DATA HERE'!H4:H10)","v":0},"No",{"$f":"COUNTIF('CYCLE 4 DATA HERE'!H4:H10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!H4:H10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!H14:H20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 4 DATA HERE'!H14:H20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP7 - Anger or Irritability",{"$f":"MAX('CYCLE 4 DATA HERE'!I4:I10)","v":0},"No",{"$f":"COUNTIF('CYCLE 4 DATA HERE'!I4:I10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!I4:I10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!I14:I20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 4 DATA HERE'!I14:I20)","v":0},"Yes",{"$error":"#DIV/0!"},"ANGER",{"$f":"IF((T13=\"Yes\")+(T14=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP8 - Interpersonal Conflict",{"$f":"MAX('CYCLE 4 DATA HERE'!J4:J10)","v":0},"No",{"$f":"COUNTIF('CYCLE 4 DATA HERE'!J4:J10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!J4:J10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!J14:J20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 4 DATA HERE'!J14:J20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,"Secondary Symptoms","DRSP9 - Less Interest",{"$f":"MAX('CYCLE 4 DATA HERE'!K4:K10)","v":0},"No",{"$f":"COUNTIF('CYCLE 4 DATA HERE'!K4:K10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!K4:K10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!K14:K20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 4 DATA HERE'!K14:K20)","v":0},"Yes",{"$error":"#DIV/0!"},"INTEREST",{"$f":"IF((T15=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP10 - Difficulty Concentrating",{"$f":"MAX('CYCLE 4 DATA HERE'!L4:L10)","v":0},"No",{"$f":"COUNTIF('CYCLE 4 DATA HERE'!L4:L10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!L4:L10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!L14:L20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 4 DATA HERE'!L14:L20)","v":0},"Yes",{"$error":"#DIV/0!"},"CONCENTRATION",{"$f":"IF((T16=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP11 - Lethargy",{"$f":"MAX('CYCLE 4 DATA HERE'!M4:M10)","v":0},"No",{"$f":"COUNTIF('CYCLE 4 DATA HERE'!M4:M10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!M4:M10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!M14:M20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 4 DATA HERE'!M14:M20)","v":0},"Yes",{"$error":"#DIV/0!"},"LETHARGY",{"$f":"IF((T17=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP12 - Appetite, Overeating",{"$f":"MAX('CYCLE 4 DATA HERE'!N4:N10)","v":0},"No",{"$f":"COUNTIF('CYCLE 4 DATA HERE'!N4:N10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!N4:N10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!N14:N20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 4 DATA HERE'!N14:N20)","v":0},"Yes",{"$error":"#DIV/0!"},"APPETITE",{"$f":"IF((T18=\"Yes\")+(T19=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP13 - Food Cravings",{"$f":"MAX('CYCLE 4 DATA HERE'!O4:O10)","v":0},"No",{"$f":"COUNTIF('CYCLE 4 DATA HERE'!O4:O10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!O4:O10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!O14:O20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 4 DATA HERE'!O14:O20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP14 - Hypersomnia",{"$f":"MAX('CYCLE 4 DATA HERE'!P4:P10)","v":0},"No",{"$f":"COUNTIF('CYCLE 4 DATA HERE'!P4:P10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!P4:P10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!P14:P20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 4 DATA HERE'!P14:P20)","v":0},"Yes",{"$error":"#DIV/0!"},"SLEEP",{"$f":"IF((T20=\"Yes\")+(T21=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP15 - Insomnia",{"$f":"MAX('CYCLE 4 DATA HERE'!Q4:Q10)","v":0},"No",{"$f":"COUNTIF('CYCLE 4 DATA HERE'!Q4:Q10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!Q4:Q10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!Q14:Q20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 4 DATA HERE'!Q14:Q20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP16 - Overwhelmed",{"$f":"MAX('CYCLE 4 DATA HERE'!R4:R10)","v":0},"No",{"$f":"COUNTIF('CYCLE 4 DATA HERE'!R4:R10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!R4:R10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!R14:R20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 4 DATA HERE'!R14:R20)","v":0},"Yes",{"$error":"#DIV/0!"},"OVERWHELM",{"$f":"IF((T22=\"Yes\")+(T23=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP17 - Out of Control",{"$f":"MAX('CYCLE 4 DATA HERE'!S4:S10)","v":0},"No",{"$f":"COUNTIF('CYCLE 4 DATA HERE'!S4:S10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!S4:S10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!S14:S20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 4 DATA HERE'!S14:S20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP18 - Breast Tenderness",{"$f":"MAX('CYCLE 4 DATA HERE'!T4:T10)","v":0},"No",{"$f":"COUNTIF('CYCLE 4 DATA HERE'!T4:T10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!T4:T10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!T14:T20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 4 DATA HERE'!T14:T20)","v":0},"Yes",{"$error":"#DIV/0!"},"PHYSICAL",{"$f":"IF((T24=\"Yes\")+(T25=\"Yes\")+(T27=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,"DRSP19 - Swelling, Bloating",{"$f":"MAX('CYCLE 4 DATA HERE'!U4:U10)","v":0},"No",{"$f":"COUNTIF('CYCLE 4 DATA HERE'!U4:U10, \">=4\")","v":0},"No",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!U4:U10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!U14:U20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX('CYCLE 4 DATA HERE'!U14:U20)","v":0},"Yes",{"$error":"#DIV/0!"}]
[null,null,"DRSP20 - Headache",{"$f":"MAX('CYCLE 4 DATA HERE'!V4:V10)","v":0},null,{"$f":"COUNTIF('CYCLE 4 DATA HERE'!V4:V10, \">=4\")","v":0},null,{"$f":"AVERAGE('CYCLE 4 DATA HERE'!V4:V10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!V14:V20)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},null,{"$f":"MAX('CYCLE 4 DATA HERE'!V14:V20)","v":0}]
[null,null,"DRSP21 - Joint, Muscle Pain",{"$f":"MAX('CYCLE 4 DATA HERE'!W4:W10)","v":0},{"$f":"IF(D27>=4,\"Yes\",\"No\")","v":"No"},{"$f":"COUNTIF('CYCLE 4 DATA HERE'!W4:W10, \">=4\")","v":0},{"$f":"IF(F27>=2,\"Yes\",\"No\")","v":"No"},{"$f":"AVERAGE('CYCLE 4 DATA HERE'!W4:W10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!W14:W20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},{"$f":"IF(P27>=30,\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}},{"$f":"MAX('CYCLE 4 DATA HERE'!W14:W20)","v":0},{"$f":"IF(R27<=3,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF((E27=\"No\")+(G27=\"No\")+(Q27=\"No\")+(S27=\"No\"),\"No\",\"Yes\")","v":{"$error":"#DIV/0!"}}]
[null,"Interference","DRSP22 - Work Interference",{"$f":"MAX('CYCLE 4 DATA HERE'!X4:X10)","v":0},null,{"$f":"COUNTIF('CYCLE 4 DATA HERE'!X4:X10, \">=4\")","v":0},null,{"$f":"AVERAGE('CYCLE 4 DATA HERE'!X4:X10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!X14:X20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},null,{"$f":"MAX('CYCLE 4 DATA HERE'!X14:X20)","v":0}]
[null,null,"DRSP23 - Hobby Interference",{"$f":"MAX('CYCLE 4 DATA HERE'!Y4:Y10)","v":0},null,{"$f":"COUNTIF('CYCLE 4 DATA HERE'!Y4:Y10, \">=4\")","v":0},null,{"$f":"AVERAGE('CYCLE 4 DATA HERE'!Y4:Y10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!Y14:Y20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},null,{"$f":"MAX('CYCLE 4 DATA HERE'!Y14:Y20)","v":0}]
[null,null,"DRSP24 ­ Relationship Interference",{"$f":"MAX('CYCLE 4 DATA HERE'!Z4:Z10)","v":0},null,{"$f":"COUNTIF('CYCLE 4 DATA HERE'!Z4:Z10, \">=4\")","v":0},null,{"$f":"AVERAGE('CYCLE 4 DATA HERE'!Z4:Z10)","v":{"$error":"#DIV/0!"}},"-",{"$f":"AVERAGE('CYCLE 4 DATA HERE'!Z14:Z20)","v":{"$error":"#DIV/0!"}},"=",{"$error":"#DIV/0!"},"÷",{"$f":"(MAX('CYCLE 1 DATA HERE'!C4:Z20,'CYCLE 2 DATA HERE'!C4:Z20, 'CYCLE 3 DATA HERE'!C4:Z20, 'CYCLE 4 DATA HERE'!C4:Z20)-1)","v":-1},"=",{"$error":"#DIV/0!"},null,{"$f":"MAX('CYCLE 4 DATA HERE'!Z14:Z20)","v":0}]
[null,"TOTAL SYMPTOMS MET PER DIMENSION"]
[null,"# of Items Meeting Criteria for: Absolute Severity",null,{"$f":"COUNTIF(E7:E27, \"Yes\")","v":0},"# of Items Meeting Criteria for:  Duration",{"$nulls":3},{"$f":"COUNTIF(G7:G27, \"Yes\")","v":0},null,null,"# of Items Meeting Criteria for:  \nRelative Symptom Change",{"$nulls":5},{"$f":"COUNTIF(Q7:Q27, \"Yes\")","v":0},null,"# of Items Meeting Criteria for:  \nAbsolute Clearance",null,null,{"$f":"COUNTIF(S7:S27, \"Yes\")","v":20}]
[null,"CYCLE-LEVEL SCORING"]
[null,"DSM­5 CRITERION A - CORE EMOTIONAL SYMPTOM: Does a core emotional symptom meet criteria this cycle?",{"$nulls":19},{"$f":"IF((W7=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,"DSM­5 CRITERION B - NUMBER OF SYMPTOMS: Do at least 5 DSM-5 symptoms meet criteria this cycle?",{"$nulls":19}," # of Yes\nAbove:",{"$f":"IF((V36>=5),\"Yes\",\"No\")","v":"No"}]
[{"$nulls":21},{"$f":"COUNTIF(V7:V27, \"Yes\")","v":0}]
[null,"IF A=NO, CYCLE DOES NOT MEET MRMD or PMDD  CRITERIA:",{"$nulls":19},"NO CYCLE DIAGNOSIS"]
[null,"IF A=YES and B=NO, CYCLE MEETS MRMD CRITERIA  :",{"$nulls":19},"MRMD CYCLE DIAGNOSIS"]
[null,"IF A=YES and B=YES, CYCLE MEETS PMDD CRITERIA :",{"$nulls":19},"PMDD CYCLE DIAGNOSIS"]
{"$rows_empty":16}
[{"$nulls":13},"­ "]