Spreadsheet: 149836d1334158649-excel-2007-need-cell-value-to-determine-result-of-column-rows-to-another-sheet-excel-help-examples
Sheet: RAW DATA

[NAME] | Indicator | Apr 2011 | May 2011 | Jun 2011 | Jul 2011 | Aug 2011 | Sep 2011 | Oct 2011 | Nov 2011 | Dec 2011 | Jan 2012 | Feb 2012 | Mar 2012 | Total
DOE, [NAME] | Core SCIP/SIP-Inf-1a - numerator | 0 | 1 | 0 | 1 | 1 | 0 | 4 | 0 | 3 | 3 | 0 | 0 | 13
DOE, [NAME] | Core SCIP/SIP-Inf-1a - denominator | 0 | 2 | 0 | 1 | 1 | 0 | 5 | 0 | 4 | 3 | 0 | 0 | 16
DOE, [NAME] | Core SCIP/SIP-Inf-1a - Antibiotic within 1 hr of incision-Overall |  | 50 |  | 100 | 100 |  | 80 |  | 75 | 100 |  |  | 81.25
DOE, [NAME] | Core SCIP/SIP-Inf-2a - numerator | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
DOE, [NAME] | Core SCIP/SIP-Inf-2a - denominator | 2 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4
DOE, [NAME] | Core SCIP/SIP-Inf-2a - Antibiotic selection-Overall | 0 |  |  |  | 50 |  |  |  |  |  |  |  | 25
DOE, [NAME] | Core SCIP/SIP-Inf-3a - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core SCIP/SIP-Inf-3a - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core SCIP/SIP-Inf-3a - Antibiotic disc. within 24 hrs-Overall
DOE, [NAME] | Core SCIP-Inf-6 - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core SCIP-Inf-6 - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core SCIP-Inf-6 - Appropriate hair removal
DOE, [NAME] | Core SCIP-Inf-9 - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core SCIP-Inf-9 - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core SCIP-Inf-9 - Urinary catheter removed POD 1 or POD 2
DOE, [NAME] | Core SCIP-Inf-10 - numerator | 0 | 4 | 0 | 1 | 2 | 0 | 6 | 0 | 4 | 5 | 0 | 0 | 22
DOE, [NAME] | Core SCIP-Inf-10 - denominator | 0 | 4 | 0 | 1 | 2 | 0 | 6 | 0 | 4 | 5 | 0 | 0 | 22
DOE, [NAME] | Core SCIP-Inf-10 - Surgery patients w/perioperative temperature mgmt |  | 100 |  | 100 | 100 |  | 100 |  | 100 | 100 |  |  | 100
DOE, [NAME] | Core SCIP-CARD-2 - numerator | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 2 | 0 | 0 | 7
DOE, [NAME] | Core SCIP-CARD-2 - denominator | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 2 | 0 | 0 | 7
DOE, [NAME] | Core SCIP-CARD-2 - Beta blocker prior to admission and periop |  | 100 |  |  |  |  | 100 |  |  | 100 |  |  | 100
DOE, [NAME] | Core SCIP-VTE-1 - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core SCIP-VTE-1 - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core SCIP-VTE-1 - VTE prophylaxis ordered
DOE, [NAME] | Core SCIP-VTE-2 - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core SCIP-VTE-2 - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core SCIP-VTE-2 - VTE prophylaxis timing
DOE, [NAME] | Core SCIP ALL measures All-or-None Bundle - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core SCIP ALL measures All-or-None Bundle - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core SCIP ALL measures All-or-None Bundle
DOE, [NAME] | Core OP-1 - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core OP-1 - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core OP-1 - Mean Time to Fibrinolysis
DOE, [NAME] | Core OP-2 - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core OP-2 - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core OP-2 - Fibrinolytic Therapy Received Within 30 Minutes
DOE, [NAME] | Core OP-3b - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core OP-3b - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core OP-3b - Mean Time to Txfer to Fac for Acute Coronary Intervention
DOE, [NAME] | Core OP-3c - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core OP-3c - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core OP-3c - Mean Time to Transfer w/ Reason for No Fibrinolytics
DOE, [NAME] | Core OP-4a - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core OP-4a - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core OP-4a - Aspirin at [NAME]
DOE, [NAME] | Core OP-4b - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core OP-4b - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core OP-4b - Aspirin at [NAME]
DOE, [NAME] | Core OP-4c - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core OP-4c - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core OP-4c - Aspirin at Arrival - Chest Pain
DOE, [NAME] | Core OP-5a - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core OP-5a - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core OP-5a - Mean Time to ECG
DOE, [NAME] | Core OP-5b - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core OP-5b - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core OP-5b - Mean Time to ECG - AMI
DOE, [NAME] | Core OP-5c - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core OP-5c - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core OP-5c - Mean Time to ECG - Chest Pain
DOE, [NAME] | Core OP-6 - numerator | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 3
DOE, [NAME] | Core OP-6 - denominator | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 3
DOE, [NAME] | Core OP-6 - Timing of Antibiotic Prophylaxis | 100 |  |  |  |  |  |  |  |  |  | 100 |  | 100
DOE, [NAME] | Core OP-7 - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core OP-7 - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core OP-7 - Antibiotic Selection
DOE, [NAME] | Core HOP Surgery All-or-None Bundle - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core HOP Surgery All-or-None Bundle - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core HOP Surgery All-or-None Bundle
DOE, [NAME] | FMC PC 1 Attributing Procedure / Focus Provider OFI | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | FMC PC 1 Attributing Procedure / Focus Provider Denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | FMC PC 1 Attributing / Focus Provider Rate
DOE, [NAME] | FMC PC 2 Attributing Procedure / Focus Provider OFI | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | FMC PC 2 Attributing Procedure / Focus Provider Denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | FMC PC 2 Attributing Procedure / Focus Provider Rate
DOE, [NAME] | Core PC-3 - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core PC-3 - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core PC-3 - Antenatal Steroids
DOE, [NAME] | Core PC-4 - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core PC-4 - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core PC-4 - Health Care-Assoc Bloodstream Infections in Newborns
DOE, [NAME] | Core PC-5 - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core PC-5 - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOE, [NAME] | Core PC-5 - Exclusive Breast Milk Feeding
JECKLE,[NAME] | Core SCIP/SIP-Inf-1a - numerator | 1 | 0 | 0 | 2 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 7
JECKLE,[NAME] | Core SCIP/SIP-Inf-1a - denominator | 1 | 0 | 0 | 2 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 7
JECKLE,[NAME] | Core SCIP/SIP-Inf-1a - Antibiotic within 1 hr of incision-Overall | 100 |  |  | 100 |  | 100 |  |  |  |  |  |  | 100
JECKLE,[NAME] | Core SCIP/SIP-Inf-2a - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core SCIP/SIP-Inf-2a - denominator | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2
JECKLE,[NAME] | Core SCIP/SIP-Inf-2a - Antibiotic selection-Overall | 0 |  |  | 0 |  |  |  |  |  |  |  |  | 0
JECKLE,[NAME] | Core SCIP/SIP-Inf-3a - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core SCIP/SIP-Inf-3a - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core SCIP/SIP-Inf-3a - Antibiotic disc. within 24 hrs-Overall
JECKLE,[NAME] | Core SCIP-Inf-6 - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core SCIP-Inf-6 - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core SCIP-Inf-6 - Appropriate hair removal
JECKLE,[NAME] | Core SCIP-Inf-9 - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core SCIP-Inf-9 - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core SCIP-Inf-9 - Urinary catheter removed POD 1 or POD 2
JECKLE,[NAME] | Core SCIP-Inf-10 - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core SCIP-Inf-10 - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core SCIP-Inf-10 - Surgery patients w/perioperative temperature mgmt
JECKLE,[NAME] | Core SCIP-CARD-2 - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core SCIP-CARD-2 - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core SCIP-CARD-2 - Beta blocker prior to admission and periop
JECKLE,[NAME] | Core SCIP-VTE-1 - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core SCIP-VTE-1 - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core SCIP-VTE-1 - VTE prophylaxis ordered
JECKLE,[NAME] | Core SCIP-VTE-2 - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core SCIP-VTE-2 - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core SCIP-VTE-2 - VTE prophylaxis timing
JECKLE,[NAME] | Core SCIP ALL measures All-or-None Bundle - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core SCIP ALL measures All-or-None Bundle - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core SCIP ALL measures All-or-None Bundle
JECKLE,[NAME] | Core OP-1 - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core OP-1 - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core OP-1 - Mean Time to Fibrinolysis
JECKLE,[NAME] | Core OP-2 - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core OP-2 - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core OP-2 - Fibrinolytic Therapy Received Within 30 Minutes
JECKLE,[NAME] | Core OP-3b - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core OP-3b - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core OP-3b - Mean Time to Txfer to Fac for Acute Coronary Intervention
JECKLE,[NAME] | Core OP-3c - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core OP-3c - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core OP-3c - Mean Time to Transfer w/ Reason for No Fibrinolytics
JECKLE,[NAME] | Core OP-4a - numerator | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 3
JECKLE,[NAME] | Core OP-4a - denominator | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 3
JECKLE,[NAME] | Core OP-4a - Aspirin at [NAME] |  | 100 | 100 |  |  |  |  |  |  | 100 |  |  | 100
JECKLE,[NAME] | Core OP-4b - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1
JECKLE,[NAME] | Core OP-4b - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1
JECKLE,[NAME] | Core OP-4b - Aspirin at [NAME] |  |  |  |  |  |  |  |  |  | 100 |  |  | 100
JECKLE,[NAME] | Core OP-4c - numerator | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2
JECKLE,[NAME] | Core OP-4c - denominator | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2
JECKLE,[NAME] | Core OP-4c - Aspirin at Arrival - Chest Pain |  | 100 | 100 |  |  |  |  |  |  |  |  |  | 100
JECKLE,[NAME] | Core OP-5a - numerator | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
JECKLE,[NAME] | Core OP-5a - denominator | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 3
JECKLE,[NAME] | Core OP-5a - Mean Time to ECG |  | 1 | 0 |  |  |  |  |  |  | 0 |  |  | 0.333
JECKLE,[NAME] | Core OP-5b - numerator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JECKLE,[NAME] | Core OP-5b - denominator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1
JECKLE,[NAME] | Core OP-5b - Mean Time to ECG - AMI |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
JECKLE,[NAME] | Core OP-5c - numerator | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
This data repeats for over 400 physicians…it is a rolling 12 month report.  So every month C column gets deleted and an addition month is added on to the end.
I need an individual sheet for each measure.  I have provided SCIP 1 and 2 as an example.  Each sheet will have its own compliance restrictions.