Spreadsheet: 130670d1322508925-calculating-one-date-which-is-less-than-24-hours-ventdays
Sheet: Sheet3

 | [NAME] of Days Study
 | 2011
Bed # | Medical Record # | [NAME] | Diagnosis | Intubation Date | Extubation Date | Total Intubated Vent Days | Weaning Protocol Used Y or N | NIV (Bipap or High Flow used | Re-intubation or Trached Date | Re-extubation or Trached Date | Outcome Planned/ Accidental/DNR
 | 312824 | Espindola | SOB/ Pneumonia | 2011-09-13 00:00:00 | 2011-09-18 00:00:00 | 15 |  |  | 2011-09-20 00:00:00 | 2011-09-30 00:00:00 | P
 | 261817 | Espindola | SOB/ ASP. Pneumonia/COPD/sepsis | 2011-09-14 00:00:00 | 2011-10-09 00:00:00 | 25 |  |  |  |  | P
 | 535762 | SICU |  | 2011-09-14 00:00:00 | 2011-10-09 00:00:00 | 25 |  |  |  |  | P
 | 1092644 | Dr. V | MVA | 2011-09-18 00:00:00 | 2011-09-24 00:00:00 | 6 |  |  |  |  | Exp
 | 566371 | Dr. [NAME] | [NAME] CA/ sepsis | 2011-09-17 00:00:00 | 2011-09-22 00:00:00 | 5 |  |  |  |  | Exp
 | 502796 | Dr. [NAME] | Resp Failure | 2011-09-21 00:00:00 | 2011-09-28 00:00:00 | 7 |  |  |  |  | P
 | 389036 | Dr. [NAME] | SOB | 2011-09-14 00:00:00 | 2011-09-22 00:00:00 | 8 |  |  |  |  | P
 | 554195 | Dr. [NAME] | cardiac arrest | 2011-09-21 00:00:00 | 2011-09-24 00:00:00 | 3 |  |  |  |  | P
 | 98168 |  |  | 2011-09-19 00:00:00 | 2011-09-21 00:00:00 | 2 |  |  |  |  | P
 | 984990 | Dr. Matalka | Resp Failure | 2011-09-18 00:00:00 | 2011-09-19 00:00:00 | 1 |  |  |  |  | P
 | 1021812 | Dr. Matalka | chest pain | 2011-09-11 00:00:00 | 2011-09-11 00:00:00 | 0 |  |  |  |  | P
 | 628557 | Dr. [NAME] | Resp Failure | 2011-09-17 00:00:00 | 2011-09-20 00:00:00 | 3 |  |  |  |  | P
C31401 | 1128882 | Dr. Refaie | Stroke code | 2011-09-18 00:00:00 | 2011-10-17 00:00:00 | 29 |  |  |  |  | EXP
 | 391252 | Med Service | CVA | 2011-09-22 00:00:00 | 2011-09-24 00:00:00 | 2 |  |  |  |  | p
 | 872882 | Dr. [NAME] | CPR | 2011-09-22 00:00:00 | 2011-09-25 00:00:00 | 3 |  |  |  |  | EXP
 | 329740 | Trama Service | CVA | 2011-09-23 00:00:00 | 2011-10-04 00:00:00 | 11
 | 884327 | Med Service | Resp Failure | 2011-09-23 00:00:00 | 2011-10-03 00:00:00 | 10
 | 1154817 | Med Service | CVA | 2011-09-24 00:00:00 | 2011-09-27 00:00:00 | 3 |  |  |  |  | P
 | 902694 | Med Service | Resp Failure | 2011-09-24 00:00:00 | 2011-09-26 00:00:00 | 2 |  |  |  |  | P
 | 570936 | Med Service | CVA | 2011-09-24 00:00:00 | 2011-09-25 00:00:00 | 1 |  |  |  |  | EXP
 | 985148 | Med Service | Resp Failure | 2011-09-23 00:00:00 | 2011-09-26 00:00:00 | 3 |  |  |  |  | P
 | 471839 | Med Service | Resp Failure | 2011-09-24 00:00:00 | 2011-09-26 00:00:00 | 2 |  |  |  |  | P
 | 670057 | Med Service | POST OP | 2011-09-25 00:00:00 | 2011-09-26 00:00:00 | 1 |  |  |  |  | P
 | 1155243 | Trama Service | POST OP | 2011-09-24 00:00:00 | 2011-09-29 00:00:00 | 5 |  |  |  |  | P
C30101 | 401130 | Med Service | Resp Failure | 2011-09-25 00:00:00 | 2011-10-11 00:00:00 | 16 |  |  | 2011-10-01 00:00:00 | 2011-10-01 00:00:00
 | 899621 | Dr. [NAME] | Resp Failure | 2011-09-26 00:00:00 | 2011-09-27 00:00:00 | 1 |  |  |  |  | P
 | 141236 | Dr. [NAME] | Post CPR | 2011-09-26 00:00:00 | 2011-09-28 00:00:00 | 2 |  |  |  |  | EXP
 | 1155329 | Trama Service | POST OP | 2011-09-26 00:00:00 | 2011-09-29 00:00:00 | 3 |  |  |  |  | P
CBS 27 | 1155467 | Trama Service | MVA | 2011-09-26 00:00:00 | TRACH | #N/A
 | 295076 | Med Service | Resp Failure | 2011-09-27 00:00:00 | 2011-09-28 00:00:00 | 1 |  |  |  |  | EXP
 | 923134 | SICU | post op | 2011-09-29 00:00:00 | 2011-09-30 00:00:00 | 1 |  |  |  |  | p
 | 1155893 |  | Resp. Failure | 2011-09-29 00:00:00 | 2011-09-29 00:00:00 | 0 |  |  |  |  | DNR-A
 | 899621 | Med Service | Resp. Failure | 2011-10-03 00:00:00 | 2011-10-06 00:00:00 | 3 |  |  |  |  | p
 | 1116665 | Med Service | Resp. Failure | 2011-10-03 00:00:00 | 2011-10-04 00:00:00 | 1
C22001 | 358019 | Trama Service | Shooting | 2011-10-03 00:00:00 | Transfer ccu | #N/A
 | 162050 | Med Service | Resp. Failure | 2011-10-01 00:00:00 | 2011-10-03 00:00:00 | 2 |  |  |  |  | p
CBN 3 | 351143 | Med Service | Resp. Failure | 2011-10-01 00:00:00 |  | -40817
CBS 28 | 912507 | Med Service | Resp. Failure | 2011-10-02 00:00:00 |  | -40818
R6N | 519543 | Med Service | Resp Failure | 2011-10-01 00:00:00 |  | -40817
Bed 18 | 1051460 | Surgery | Post op | 2011-09-30 00:00:00 | 2011-10-04 00:00:00 | 4 |  |  |  |  | DNR-A
Bed 16 | 1156347 | Med Service | Resp. Failure | 2011-10-05 00:00:00 | 2011-10-07 00:00:00 | 2 |  |  |  |  | DNR-A
 | 1156660 | Med Service | Resp. Failure | 2011-10-05 00:00:00 | 2011-10-06 00:00:00 | 1 |  |  |  |  | P
 | 902694 | Med Service | Resp. failure | 2011-10-05 00:00:00 | 2011-10-10 00:00:00 | 5
Bed 18 | 276698 | Med Service | Resp. failure | 2011-10-06 00:00:00 | 2011-10-08 00:00:00 | 2 |  |  |  |  | EXP
C32301 | 933185 | Dr. [NAME] | Protection | 2011-10-08 00:00:00 | 2011-10-09 00:00:00 | 1 |  |  |  |  | P
Bed 11 | 1157000 | Med Service | GUNSHOT | 2011-10-09 00:00:00 | 2011-10-10 00:00:00 | 1
BED 3 | 141267 | Med Service | Resp Failure | 2011-10-10 00:00:00 | 2011-10-12 00:00:00 | 2
Bed 4 | 584920 |  | Resp Failure | 2011-10-09 00:00:00 | 2011-10-11 00:00:00 | 2
CBN 6 | 66177 |  |  | 2011-10-04 00:00:00 |  | -40820
CBN 7 | 871908 |  | Unresponsive | 2011-10-12 00:00:00 |  | -40828
CBS22 | 263199 | Med Service | Resp Failure | 2011-10-14 00:00:00 |  | -40830
CBN02 | 1157839 | trauma | Unresponsive | 2011-10-14 00:00:00 |  | -40830
[NAME] | 793407 | Med Service | Resp Failure | 2011-10-16 00:00:00 |  | -40832
CB311 | 770236 | Med Service | Resp Failure | 2011-10-16 00:00:00 |  | -40832
CB305 | 355275 | Med Service | Resp Failure | 2011-10-17 00:00:00 |  | -40833
CB313 | 723229 |  | RESP FAILURE | 2011-10-21 00:00:00 | 2011-10-21 00:00:00 | 1 |  |  |  |  | PT EXP
CB318 | 1052615 | Med Service | POST OP | 2011-10-21 00:00:00 |  | -40837
[NAME] | 933185 | Med Service | Resp Failure | 2011-10-21 00:00:00 |  | -40837
CB312 | 375489 | Med Service | Resp Failure | 2011-10-22 00:00:00 |  | -40838
[NAME] | 621232 | Med Service | CVA | 2011-10-26 00:00:00 |  | -40842
[NAME] | 142978 | Med Service | RESP FAILURE | 2011-10-27 00:00:00 |  | -40843
CB320 | 971131 | Med Service | RESP FAILURE | 2011-10-27 00:00:00 |  | -40843
CB303 | 468034 | Med Service | Unresponsive | 2011-10-29 00:00:00 |  | -40845
CB313 | 589593 | Med Service | Resp Failure | 2011-10-29 00:00:00 |  | -40845
CB317 | 700952 | Med Service | POST OP | 2011-10-31 00:00:00 |  | -40847
CB322 | 449307 | Med Service | ICB | 2011-11-09 00:00:00 |  | -40856
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0