Scribd Logo
Upload

Welcome to Scribd!

  • 9 views

    Updated Spreadsheet (Sba)

    Uploaded by

    Syi
    The document contains patient admission and medical facility tracking data for 15 patients from various Caribbean countries, including details on their dates of admission and discharge, medical costs, assigned units, bed availability and other vital information. Several patients had long-term admissions exceeding 6 months. The majority of patients were assigned to the ICU or NON-ICU units and costs were consistently $250 per day of admission.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Updated Spreadsheet (Sba)

    Uploaded by

    Syi
    9 views14 pages
    The document contains patient admission and medical facility tracking data for 15 patients from various Caribbean countries, including details on their dates of admission and discharge, medical costs, assigned units, bed availability and other vital information. Several patients had long-term admissions exceeding 6 months. The majority of patients were assigned to the ICU or NON-ICU units and costs were consistently $250 per day of admission.

    Original Title

    Updated Spreadsheet (sba)

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains patient admission and medical facility tracking data for 15 patients from various Caribbean countries, including details on their dates of admission and discharge, medical costs, assigned units, bed availability and other vital information. Several patients had long-term admissions exceeding 6 months. The majority of patients were assigned to the ICU or NON-ICU units and costs were consistently $250 per day of admission.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    9 views14 pages

    Updated Spreadsheet (Sba)

    Uploaded by

    Syi
    The document contains patient admission and medical facility tracking data for 15 patients from various Caribbean countries, including details on their dates of admission and discharge, medical costs, assigned units, bed availability and other vital information. Several patients had long-term admissions exceeding 6 months. The majority of patients were assigned to the ICU or NON-ICU units and costs were consistently $250 per day of admission.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 14

    M

    Patient ID Fname Lname DOB Age Country Occupation Gender Blood Type
    HF7400 Jerry Batson 15-Jan-02 22 Trinidad a Fireman Female A
    KJ9809 Izzy James 27-May-11 12 Grenada Doctor Male AB
    GG9495 Harry Dickson 9-Sep-99 24 Guyana Pilot Male O+
    AH1929 Jena Peters 17-Sep-15 8 Barbados Singer Female B
    HW8373 Tom Smith 25-Feb-00 24 Jamaica Baker Female O-
    YG8765 Barry Jones 27-May-03 20 Bahamas Teacher Male AB-
    JH0989 Ben Johnson 9-Mar-99 25 Cuba Driver Male A-
    KQ9870 Perry Brown 27-Oct-01 22 Dominica Safety Officer Female B-
    KJ8765 Faith David 11-Aug-07 16 Haiti Radio woman Female A
    GE9877 John Davis 27-Nov-04 19 Bermuda Mason Male AB
    IU0988 Mark Tuffin 29-Mar-82 41 St. Kitts a Chef Male B-
    RW9877 Tyreke Torsey 17-Dec-02 21 St. Lucia Dentist Male A-
    NV9872 Jay Simeons 20-Sep-89 34 Suriname Lawyer Male AB
    PK9876 May Thompson 22-Sep-82 41 Trinidad a Actor Female O-
    AQ1234 Jake Jack 10-Feb-87 37 Belize Factory worker Male B
    Medical Facility Tracking Table
    Patient Trauma Status Allergies Assigned Medical UnitBed Available#Beds Vacant/Unit Temp. o C
    Mild Yes NON-ICU Yes 6 31/0
    Moderate Yes NON-ICU No 0 32/4
    Severe No ICU Yes 12 34/1
    Morbid Yes NON-ICU Yes 1 32/0
    Moderate Yes NON-ICU No 0 35/1
    Severe No ICU Yes 2 40/2
    Severe No ICU Yes 1 42/0
    Severe No ICU Yes 5 35/1
    Mild Yes NON-ICU Yes 2 32/5
    Severe Yes ICU Yes 15 32/6
    Mild No NON-ICU No 0 50/7
    Mild Yes NON-ICU No 0 37/2
    Moderate Yes NON-ICU No 0 36/2
    Moderate Yes NON-ICU No 0 34/4
    Severe No NON-ICU Yes 3 38/3
    Date Admitted Date Released Total DayTotal Cost to Patient Cost per day
    1-Jan-21 10-Jan-21 9 $2,250 $ 250.00
    9-Mar-21 23-Mar-21 14 $3,500 $ 250.00
    23-Feb-22 29-Mar 34 $8,500 $ 250.00
    20-Jan-22 10-Sep-22 233 $58,250 $ 250.00
    21-May-22 4-Apr-23 318 $79,500 $ 250.00
    13-Jul-22 25-Jul-22 12 $3,000 $ 250.00
    2-Sep-22 22-Sep-22 20 $5,000 $ 250.00
    23-Dec-22 31-Dec-22 8 $2,000 $ 250.00
    25-Jan-23 24-Feb-23 30 $7,500 $ 250.00
    26-Aug-23 5-Sep-23 10 $2,500 $ 250.00
    19-Sep-23 26-Sep-23 7 $1,750 $ 250.00
    20-Apr-23 27-May-23 37 $9,250 $ 250.00
    7-May-23 28-Jun-23 52 $13,000 $ 250.00
    15-Jun-23 29-Jul-23 44 $11,000 $ 250.00
    12-Sep-23 30-Oct-23 48 $12,000 $ 250.00
    Patient ID Fname Lname DOB Age Country
    HF7400 Jerry Batson 15-Jan-02 22 Trinidad and Tobago
    KJ9809 Izzy James 27-May-11 12 Grenada
    GG9495 Harry Dickson 9-Sep-99 24 Guyana
    AH1929 Jena Peters 17-Sep-15 8 Barbados
    HW8373 Tom Smith 25-Feb-00 24 Jamaica
    YG8765 Barry Jones 27-May-03 20 Bahamas
    JH0989 Ben Johnson 9-Mar-99 25 Cuba
    KQ9870 Perry Brown 27-Oct-01 22 Dominica
    KJ8765 Faith David 11-Aug-07 16 Haiti
    GE9877 John Davis 27-Nov-04 19 Bermuda
    IU0988 Mark Tuffin 29-Mar-82 41 St. Kitts and Nevis
    RW9877 Tyreke Torsey 17-Dec-02 21 St. Lucia
    NV9872 Jay Simeons 20-Sep-89 34 Suriname
    PK9876 May Thompson 22-Sep-82 41 Trinidad and Tobago
    AQ1234 Jake Jack 10-Feb-87 37 Belize

    No. of Patients 15
    Max total cost patient $79,500 Gender
    Average toatal cost $14,600 <>Male
    % of ICU patients 33%

    n
    Medical Facility Tracking
    Occupation Gender Blood Type Patient Trauma Status Allergies
    Fireman Female A Mild Yes
    Doctor Male AB Moderate Yes
    Pilot Male O+ Severe No
    Singer Female B Morbid Yes
    Baker Female O- Moderate Yes
    Teacher Male AB- Severe No
    Driver Male A- Severe No
    Safety Officer Female B- Severe No
    Radio woman Female A Mild Yes
    Mason Male AB Severe Yes
    Chef Male B- Mild No
    Dentist Male A- Mild Yes
    Lawyer Male AB Moderate Yes
    Actor Female O- Moderate Yes
    Factory worker Male B Severe No

    Assigned Medical Unit


    <>ICU
    Medical Facility Tracking Table
    Assigned Medical Unit Bed Available #Beds Vacant/Unit Temp. o C /o Fahr.)
    NON-ICU Yes 6 31/0
    NON-ICU No 0 32/4
    ICU Yes 12 34/1
    NON-ICU Yes 1 32/0
    NON-ICU No 0 35/1
    ICU Yes 2 40/2
    ICU Yes 1 42/0
    ICU Yes 5 35/1
    NON-ICU Yes 2 32/5
    ICU Yes 15 32/6
    NON-ICU No 0 50/7
    NON-ICU No 0 37/2
    NON-ICU No 0 36/2
    NON-ICU No 0 34/4
    NON-ICU Yes 3 38/3
    Date Admitted Date Released Total Days Total Cost to Patient Cost per day
    1-Jan-21 10-Jan-21 9 $2,250 $ 250.00
    9-Mar-21 23-Mar-21 14 $3,500 $ 250.00
    23-Feb-22 29-Mar 34 $8,500 $ 250.00
    20-Jan-22 10-Sep-22 233 $58,250 $ 250.00
    21-May-22 4-Apr-23 318 $79,500 $ 250.00
    13-Jul-22 25-Jul-22 12 $3,000 $ 250.00
    2-Sep-22 22-Sep-22 20 $5,000 $ 250.00
    23-Dec-22 31-Dec-22 8 $2,000 $ 250.00
    25-Jan-23 24-Feb-23 30 $7,500 $ 250.00
    26-Aug-23 5-Sep-23 10 $2,500 $ 250.00
    19-Sep-23 26-Sep-23 7 $1,750 $ 250.00
    20-Apr-23 27-May-23 37 $9,250 $ 250.00
    7-May-23 28-Jun-23 52 $13,000 $ 250.00
    15-Jun-23 29-Jul-23 44 $11,000 $ 250.00
    12-Sep-23 30-Oct-23 48 $12,000 $ 250.00

    0 $0 $ 250.00

    0 $0 $ 250.00
    Patient ID Fname Lname DOB Age Country
    HF7400 Jerry Batson 15-Jan-02 22 Trinidad and Tobago
    KJ9809 Izzy James 27-May-11 12 Grenada
    GG9495 Harry Dickson 9-Sep-99 24 Guyana
    AH1929 Jena Peters 17-Sep-15 8 Barbados
    HW8373 Tom Smith 25-Feb-00 24 Jamaica
    YG8765 Barry Jones 27-May-03 20 Bahamas
    JH0989 Ben Johnson 9-Mar-68 56 Cuba
    KQ9870 Perry Brown 27-Oct-25 98 Dominica
    KJ8765 Faith David 11-Aug-07 16 Haiti
    GE9877 John Davis 27-Nov-04 19 Bermuda
    IU0988 Mark Tuffin 29-Mar-82 41 St. Kitts and Nevis
    RW9877 Tyreke Torsey 17-Dec-48 75 St. Lucia
    NV9872 Jay Simeons 20-Sep-60 63 Suriname
    PK9876 May Thompson 22-Sep-82 41 Trinidad and Tobago
    AQ1234 Jake Jack 10-Feb-87 37 Belize

    No. of Patients 15
    Max total cost patient $79,500
    Average toatal cost $14,600
    % of ICU patients 33%

    Patient ID Fname Lname DOB Age Country


    HF7400 Jerry Batson 15-Jan-02 22 Trinidad and Tobago
    AH1929 Jena Peters 17-Sep-15 8 Barbados
    HW8373 Tom Smith 25-Feb-00 23 Jamaica
    KJ8765 Faith David 11-Aug-98 25 Haiti
    PK9876 May Thompson 22-Sep-82 41 Trinidad and Tobago
    Medical Facility Tracking Ta
    Occupation Gender Blood Type Patient Trauma Status Allergies
    Fireman Female A Mild Yes
    Doctor Male AB Moderate Yes
    Pilot Male O+ Severe No
    Singer Female B Morbid Yes
    Baker Female O- Moderate Yes
    Teacher Male AB- Severe No
    Driver Male A- Severe No
    Safety Officer Female B- Severe No
    Radio woman Female A Mild Yes
    Mason Male AB Severe Yes
    Chef Male B- Mild No
    Dentist Male A- Mild Yes
    Lawyer Male AB Moderate Yes
    Actor Female O- Moderate Yes
    Factory worker Male B Severe No

    Gender Assigned Medical Unit


    <>Male <>ICU

    Occupation Gender Blood Type Patient Trauma Status Allergies


    Fireman Female A Mild Yes
    Singer Female B Morbid Yes
    Baker Female O- Moderate Yes
    Radio woman Female A Mild Yes
    Actor Female O- Moderate Yes
    Medical Facility Tracking Table
    Assigned Medical Unit Bed Available #Beds Vacant/Unit Temp. o C /o Fahr.)
    NON-ICU Yes 6 31/0
    NON-ICU No 0 32/4
    ICU Yes 12 34/1
    NON-ICU Yes 1 32/0
    NON-ICU No 0 35/1
    ICU Yes 2 40/2
    ICU Yes 1 42/0
    ICU Yes 5 35/1
    NON-ICU Yes 2 32/5
    ICU Yes 15 32/6
    NON-ICU No 0 50/7
    NON-ICU No 0 37/2
    NON-ICU No 0 36/2
    NON-ICU No 0 34/4
    NON-ICU Yes 3 38/3

    ssigned Medical Unit

    Assigned Medical Unit Bed Available #Beds Vacant/Unit Temp. o C /o Fahr.)


    NON-ICU Yes 6 31/0
    NON-ICU Yes 1 32/0
    NON-ICU No 0 35/1
    NON-ICU Yes 2 32/5
    NON-ICU No 0 34/4
    Date Admitted Date Released Total Days Total Cost to Patient Cost per day
    1-Jan-21 10-Jan-21 9 $2,250 $ 250.00
    9-Mar-21 23-Mar-21 14 $3,500 $ 250.00
    23-Feb-22 29-Mar 34 $8,500 $ 250.00
    20-Jan-22 10-Sep-22 233 $58,250 $ 250.00
    21-May-22 4-Apr-23 318 $79,500 $ 250.00
    13-Jul-22 25-Jul-22 12 $3,000 $ 250.00
    2-Sep-22 22-Sep-22 20 $5,000 $ 250.00
    23-Dec-22 31-Dec-22 8 $2,000 $ 250.00
    25-Jan-23 24-Feb-23 30 $7,500 $ 250.00
    26-Aug-23 5-Sep-23 10 $2,500 $ 250.00
    19-Sep-23 26-Sep-23 7 $1,750 $ 250.00
    20-Apr-23 27-May-23 37 $9,250 $ 250.00
    7-May-23 28-Jun-23 52 $13,000 $ 250.00
    15-Jun-23 29-Jul-23 44 $11,000 $ 250.00
    12-Sep-23 30-Oct-23 48 $12,000 $ 250.00

    Date Admitted Date Released Total Days Total Cost to Patient Cost per day
    1-Jan-21 10-Jan-21 9 $2,250 $ 250.00
    20-Jan-22 10-Sep-22 233 $58,250 $ 250.00
    21-May-22 4-Apr-23 318 $79,500 $ 250.00
    25-Jan-23 24-Feb-23 30 $7,500 $ 250.00
    15-Jun-23 29-Jul-23 44 $11,000 $ 250.00
    Sum of Age Assigned Medical Unit
    Age ICU NON-ICU Total Result
    1-10 8 8
    11-20 39 28 67
    21-30 24 46 70
    31-40 37 37
    41-50 82 82
    51-60 56 56
    61-70 63 63
    71-80 75 75
    91-100 98 98
    Total Result 217 339 556
    Sum of Age Column Labels 0 0
    Row Labels ICU NON-ICU Grand Total Medical Facility Monitoring
    1-10 0 8 8 Age
    11-20 39 12 51
    21-30 24 70 94 91-100

    31-40 0 36 36
    61-70
    41-50 0 82 82
    51-60 55 0 55 41-50
    61-70 0 63 63
    71-80 0 75 75 21-30
    91-100 98 0 98
    1-10
    Grand Total 216 346 562
    0 100 200 300

    0 Grand Total 0 NON-ICU


    edical Facility Monitoring Assigned Units by
    Age

    100 200 300 400 500 600

    0 Grand Total 0 NON-ICU Column Labels ICU

    You might also like