Spreadsheet: 720944d1614378749-dynamic-offset-by-detecting-blank-cells-in-between-values-sample-data
Sheet: Sheet1

Unit |  |  |  |  |  | 56 | 39 |  | 0.6964285714285714 |  |  |  | 39 |  | 0.6964285714285714
 |  |  | Person 1 |  |  | 2 | 2 |  | 1 |  |  |  | 2 |  | 1
 |  |  |  |  | aspirin | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  |  |  | Plavix | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  | Person 2 |  |  | 4 | 4 |  | 1 |  |  |  | 4 |  | 1
 |  |  |  |  | D51/2NS 1,000 mL | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  |  |  | Normal Saline Bolus | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  |  |  | Protonix injectable | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  |  |  | carvedilol | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  | Person 3 |  |  | 1 | 0 |  | 0 |  |  |  | 0 |  | 0
 |  |  |  |  | NSS Bolus | 1 | 0 |  |  |  |  |  | 0 |  | 0
 |  |  | Person 4 |  |  | 8 | 8 |  | 1 |  |  |  | 8 |  | 1
 |  |  |  |  | Tylenol #3 | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  |  |  | Bystolic | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  |  |  | losartan | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  |  |  | morphine injectable | 2 | 2 |  |  |  |  |  | 2 |  | 1
 |  |  |  |  | NIFEdipine extended release | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  |  |  | Percocet 5/325 | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  |  |  | Protonix injectable | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  | Person 5 |  |  | 10 | 9 |  | 0.9 |  |  |  | 8 |  | 0.8
 |  |  |  |  | Lasix injectable | 1 | 1 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  | [NAME] | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  |  |  | [NAME] | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  |  |  | Plavix | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  |  |  | Protonix | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  |  |  | doxycycline monohydrate | 1 | 0 |  |  |  |  |  | 1 |  | 1
 |  |  |  |  | DuoNeb | 1 | 1 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  | DuoNeb | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  |  |  | pantoprazole | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  |  |  | SoluMEDROL injectable | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  | Person 6 |  |  | 12 | 0 |  | 0 |  |  |  | 0 |  | 0
 |  |  |  |  | aspirin | 1 | 0 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  | Plavix | 1 | 0 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  | heparin injectable | 1 | 0 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  | amLODIPine | 1 | 0 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  | DuoNeb | 1 | 0 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  | Ecotrin | 1 | 0 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  | furosemide | 1 | 0 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  | gabapentin | 1 | 0 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  | heparin injectable | 1 | 0 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  | pantoprazole | 1 | 0 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  | magnesium sulfate | 1 | 0 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  | pramipexole | 1 | 0 |  |  |  |  |  | 0 |  | 0
 |  |  | Person 7 |  |  | 2 | 1 |  | 0.5 |  |  |  | 1 |  | 0.5
 |  |  |  |  | Dilaudid injectable | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  |  |  | Lantus | 1 | 0 |  |  |  |  |  | 0 |  | 0
 |  |  | Person 8 |  |  | 1 | 1 |  | 1 |  |  |  | 1 |  | 1
 |  |  |  |  | Lipitor | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  | Person 9 |  |  | 2 | 2 |  | 1 |  |  |  | 2 |  | 1
 |  |  |  |  | Lasix injectable | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  |  |  | morphine injectable | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  | Person 10 |  |  | 2 | 1 |  | 0.5 |  |  |  | 2 |  | 1
 |  |  |  |  | Percocet 5/325 | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  |  |  | [NAME] injectable | 1 | 0 |  |  |  |  |  | 1 |  | 1
 |  |  |  |  | Flexeril | 1 | 1 |  |  |  |  |  | 1 |  | 1
 |  |  |  |  | traMADol | 1 | 1 |  |  |  |  |  | 1 |  | 1