Spreadsheet: 596004d1540906254-if-and-using-vlookup-from-another-tab-using-table-but-if-over-roundup-to-next-cell-med-gas-branch-pipe-sizing-test-autosaved-
Sheet: Medical Vacuum 

MEDICAL VACUUM LINE SIZING |  |  |  |  |  |  |  |  | VACUUM PRESSURE DROP
START | END | RUN (FEET) | FLOW (SCFM) | PIPE SIZE | LOSS PER 100' | LOSS | RUNNING SUB TOTAL
 |  |  |  |  |  |  |  |  | FLOW |  | NOMINAL PIPE SIZE
A | B | 25 |  |  |  |  |  |  | SCFM |  |  | 3/4" | 1" | 1-1/4" | 1-1/2" | 2" | 2-1/2" | 3" | 4" | 6" | 8"
B | C | 16
C | D | 17
D | E | 19
E | F | 16 |  |  |  |  |  |  | System Totals
F | G | 16 |  |  |  |  |  |  | [NAME] | SCFM Per Section |  | Pressure [NAME] (4" HgV/100 FT) |  |  |  | Equivalent (LF) |  | Pressure Drop
G | H | 16 |  |  |  |  |  |  | 8"
H | I | 16 |  |  |  |  |  |  | 6"
I | J | 16 |  |  |  |  |  |  | 4"
J | K | 10 |  |  |  |  |  |  | 3"
K | L | 138 |  |  |  |  |  |  | 2 1/2"
L | M | 15 |  |  |  |  |  |  | 2"
M | N | 15 |  |  |  |  |  |  | 1 1/2"
N | O | 15 |  |  |  |  |  |  | 1 1/4"
O | P | 15 |  |  |  |  |  |  | 1"
P | Q | 25 |  |  |  |  |  |  | 3/4"
 |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  | Total Maximum System Loss Per 100' = |  |  |  |  |  | System Total Pressure Drop
 |  |  |  |  |  |  |  |  | Place your flow rate for the overall zone of pipe you are sizing up top, then place the flow rate for the section you are sizing and the length of that section in the middle. |  |  |  |  |  | LENGTH OF LONGEST RUN |  |  |  | LF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ADD FOR FITTING  LOSS |  |  |  | LF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL EQUIVALENT LENGTH |  |  |  | LF
 |  |  |  |  |  |  |  |  | VACUUM INLET SCFM REQUIREMENTS
 |  |  |  |  |  |  |  |  | CRITICAL CARE: |  |  |  | OBSTETRICS: |  |  |  | OTHER:
 |  |  |  |  |  |  |  |  | OCCUPANCY |  | UNIT | FLOW | OCCUPANCY |  | UNIT | FLOW | OCCUPANCY |  | UNIT | FLOW
 |  |  |  |  |  |  |  |  | ICU / CCU |  | Bed | 1.5 | Delivery Room |  | Room | 1 | Autopsy |  | Station | 0.35
 |  |  |  |  |  |  |  |  | Coronary CCU |  | Room | 2 | Labor Room |  | Bed | 0.1 | Blood Donor |  | Station | 0.1
 |  |  |  |  |  |  |  |  | Decontam |  | Station | 0.5 | LDR |  | Room | 1 | Cardiac Cath |  | Inlet | 0.1
 |  |  |  |  |  |  |  |  | Demonstration |  | Inlet | 0.1 | LDRP |  | Room | 1 | Psych / Secure |  | Bed | 0.1
 |  |  |  |  |  |  |  |  | Dental Treatment |  | Chair | 2 | [NAME] |  | Bed | 0.1 | PACU / Recovery |  | Bed | 0.75
 |  |  |  |  |  |  |  |  | Exam/EEG/ECG/EMG |  | Station | 0.1 | [NAME] |  | Bed | 0.75 | Ph. 2 Recovery |  | Bed | 0.1
 |  |  |  |  |  |  |  |  | EENT |  | Station | 0.1 | Infant Resucitation |  | Station | 0.5 | Patient Room |  | Bed | 0.1
 |  |  |  |  |  |  |  |  | EMERGENCY: |  |  |  | PEDIATRICS: |  |  |  | Respiratory Therapy |  | Station | 0.1
 |  |  |  |  |  |  |  |  | Holding |  | Bed | 0.1 | Peds Critical Care |  | Bed | 1.5 | Central Sterile |  | Station | 0.35
 |  |  |  |  |  |  |  |  | Triage |  | Room | 0.1 | Neonatal ICU |  | Bassinet | 0.75 | Vet Application |  | Room | 3.5
 |  |  |  |  |  |  |  |  | Trauma/Trtmt |  | Room | 3 | Nursery |  | Bassinet | 0.35
 |  |  |  |  |  |  |  |  | Observation |  | Bed | 0.1 | Peds/Adolescent |  | Bed | 0.1
 |  |  |  |  |  |  |  |  | Cardiac Trtmt |  | Room | 0.1 | Peds/Nursery |  | Bed | 0.1
 |  |  |  |  |  |  |  |  | Ortho/Cast Room |  | Room | 3
 |  |  |  |  |  |  |  |  | IMAGING: |  |  |  | SURGICAL SUITE:
 |  |  |  |  |  |  |  |  | MRI/CT/PET |  | Room | 0.1 | [NAME] |  | Station | 0.1
 |  |  |  |  |  |  |  |  | Other Radiology |  | Room | 0.1 | Endo/Cysto |  | Room | 2
 |  |  |  |  |  |  |  |  | Intermediate Care |  | Bed | 0.75 | Induction/Holding |  | Bed | 0.1
 |  |  |  |  |  |  |  |  | Isolation |  | Bed | 0.1 | Major / Minor |  | Room | 3.5
 |  |  |  |  |  |  |  |  | Laboratory |  | Station | 0.35 | [NAME] |  | Room | 3.5
 |  |  |  |  |  |  |  |  | Minor Procedures |  | Room | 0.5 | [NAME] |  | Room | 3.5