{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Sending Site List","Print - Complete List","Print - Transport List","Print - Loading Unloading List"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,1,27,3],[24,1,24,3],[16,1,16,3],[17,1,17,3],[1,1,1,3],[9,1,9,3],[10,1,10,3],[12,1,12,3],[20,1,20,3],[13,1,13,3],[14,1,14,3],[15,1,15,3]]}
[]
[null,"Contents"]
[null,"On this page",null,"The rest of the workbook"]
[null,"Purpose",null,"Sending Site List (fill in)"]
[null,"Instructions",null,"Print - Complete List (do not modify)"]
[null,"Minimum data",null,"Print - Transport List (do not modify)"]
[null,"Insert new rows (Sending Site List)",null,"Print - Loading Unloading list (do not modify)"]
[null,"How to pdf"]
[null,"How to print"]
[null,"Purpose "]
[null,"The primary purpose of the Sending Site List is to identify the patient/client/residents who require evacuation and track the location of patient/client/residents as they are moved from sending site to receiving site. \n\nIn addition, information provided on the Sending Site List will assist to:\n▸ Match patient/client/residents to an appropriate receiving site\n▸ Determine the appropriate modes of transportation \n▸Provide the receiving sites with a broad overview of the incoming patient/client/residents \n\nWhen sharing this list, please ensure it is password protected. \n\nNOTE: This version of the Sending Site List contain macros to make the pdf process more straightforward. "]
[]
[null,"Instructions "]
[null,"In the event of an evacuation, it is recommended that the sending site leader (or designate) fills out the Sending Site List because this information facilitates the best patient/client/resident care. \n\nIt is also recommended that the complete list be filled out in advance (i.e. at the start of the hazard season if the site is in a high-risk area) and updated at regular intervals (i.e. bi-weekly or monthly). If the list is filled out in advance, this will significantly decrease the workload on sending site staff if/when the site is placed on an evacuation order. \n\nImportant: Refresh data after filling in or updating the Sending Site List to populate and/or update the Transport, Complete and Loading / Unloading Lists.  \n1. Go to the Data tab \n2. Click Refresh All. \n\nIt is highly recommended that you open this using the Desktop Excel App. \n\n\"Refresh Data\" will update the data from the Sending Site List to the other lists\n\"Export as PDF: Sending Site List\" will print the complete list.\n\"Export as PDF: Transport List\" will print a shorter version of the complete list that does not contain personal medical information and can be shared with transport vendors.\n\"Export as PDF: Loading / Unloading Checklist\" will print the loading/unloading List with the names of the patient/client/residents."]
[null,"Minimum data"]
[null,"In the event time to evacuate is extremely limited, it is recommended that the sending site leader (or designate) fills out the columns with asterisk (*) because this is the minimum information that is required to facilitate patient/client/resident movement. "]
[null,"Unblock or enable macros"]
[null,"1. Ensure the Excel workbook is closed\n2. Right-click on the file and then click \"Properties\"\n3. In the \"General\" tab ensure the \"Unblock\" checkbox under \"Security: This file came from another computer and might be blocked to help protect this computer\" is not checked"]
[null,"Insert new rows"]
[null,"1. Right-click on any row in the table\n2. Hover over \"Insert\" then click \"Table Rows Above\"\n"]
[null,"How to pdf"]
[null,"Using macros",null,"Manually (if macros do not work)"]
[null,"1. Enable macros and tell Excel you trust this document \n2. From the \"Sending site list\" tab, select the button to \"Export as PDF\" of the list you are trying to print (i.e. Sending list site, Loading/unloading checklist, or Transport list)\n3. Once you select a button, the program will save a PDF file; this should pop up automatically",null,"1. Go to the list you want to print or pdf\n2. Click \"File\", then click \"Save as\", then click \"Browse\"\n3. Select a location to save the file\n4. Set \"Save as type\" to \"PDF\"\n5. Ensure \"File name\" is appropriate (for example, if printing Transport List name it \"Transport-list-yyyy-mm-dd\")\n6. Click \"Save\""]
[]
[null,"How to print from excel"]
[null,"To print"]
[null,"1. Go to the list you want to print or pdf\n2. Click \"File\", then \"Print\"\n3. Make sure it is set to letter-sized paper,  landscape orientation,  custom margins and custom scaling of approximately 40%, and then send file to your printer \n"]
[null,"Need support? Contact IIHAR@phsa.ca"]

{"sheet":"Sending Site List","index":1,"n_rows":10,"n_cols":55,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Sending site list: Evacuation of patient/client/residents"]
[null,"Last updated:","yyyy-mm-dd at hh:mm",null,"Sending site:","Sending site name"]
[null,"Next update:","yyyy-mm-dd at hh:mm",null,"Sending site municipality:","Sending site municipality"]
[null,"Updated by:","Name and organization"]
[]
[null,"Sending details - to be filled out by sending site",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Receiving / repatriation - to be filled out by receiving site"]
[null,"Patient/client/resident information",null,null,null,null,null,null,null,null,null,"Physician care",null,"Transport","Mobility",null,null,null,null,null,null,"Infection control",null,"Clinical considerations",null,null,null,null,null,null,null,null,null,null,null,"Behaviour",null,null,"Primary contact / next of kin",null,null,null,"Transport",null,"Patient/client/resident information",null,null,null,null,null,null,null,null,null,"Other"]
[null,"LTC: Long-term Care\nAL: Assisted Living\nIL: Independent Living\nACT: Acute\nAMB: Ambulatory","For example: surgery, neuro, medicine",null,null,"Last Name, First Name","M: Male\nF: Female\n","Date\nyyyy-mm-dd","Personal Health Number","Y: Yes\nN: No","BLND: Blind\nDEAF: Deaf","Last Name, First Name",null,"Wheelchair-adapted: Must be on wheelchair-adapted vehicle\nBus: Can tolerate standard bus transport\nAir: Only by air ambulance\nAmbulance: Only by road ambulance","Amb: Ambulatory (can walk > 10 steps)\nWCB: Wheelchair-bound (between 0-10 steps before wheelchair needed)\nSB: Stretcher-bound (cannot leave stretcher)","None: No aids\nC: Cane\n2WW: 2-wheel walker\n4WW: 4-wheel walker\nW/C: wheelchair","For example: BCEHS, private vehicle, SN Transport, Handi-Dart, BC Transit, etc.","Y: Yes\nN: No","Ind: Independent\n1 PA: 1-person assist\n2 PA: 2-person assist\nLift: ceiling or chair lift","Y: Yes\nN: No","Y: Yes\nN: No","Y: Yes\nN: No","Airborne, Contact, Droplet, \nMRSA, VRE, \nC. Diff, COVID-19 ","Indicate level of resuscitative effort","Y: Yes\nN: No","List all known allergies","Y: Yes\nN: No\nIf yes, how long for Independent Breathing Time (IBT)","Indicate if on any oxygen and how much (L/min)","List all restrictions","IDDM: Insulin dependent\nNIDDM: Not insulin dependent\nN: Not diabetic","Indicate location and stage of wounds/skin conditions and BRADEN score if known ","In pounds (lbs)\n\nBariatric if weight greater than 250 lbs","Such as specialty mattresses, pressure-relieving equipment, CPAP machines, ostomy care, peritoneal dialysis equipment, etc.","Y: Yes\nN: No\nIf yes, please list which equipment (pull from previous column)","Indicate relevant clinical information (example: dialysis, chemotherapy, etc.)","Such as aggression, violence, elopement, dementia, etc. ","Y: Yes\nN: No\nIf yes, indicate what restraints are required","Y: Yes\nN: No","Last Name, First Name",null,null,"Last Name, First Name","In large scale response (example: airport zone, or transport bay)","For example: BCEHS, private vehicle, SN Transport, Handi-Dart, BC Transit, etc.","LTC: Long-term Care\nAL: Assisted Living\nIL: Independent Living\nACT: Acute\nAMB: Ambulatory",null,null,null,null,"Date\nyyyy-mm-dd","Date\nyyyy-mm-dd","Receiving site\nIn transit\nDischarged to (details)\nRepatriated","Such as equipment, personal items, etc.","Indicate if resident went somewhere other than receiving location (for example: home, local transfer, etc.)"]
[null,"Level of care*","Type","Building/floor/wing*","Room number*","Name*","Sex*","Date of birth*","PHN*","Identifies as Indigenous?*","Disability","Sending physician name","Physician phone number","Best method of transportation*","Mobility status*","Mobility aids*","Vendor","Are mobility aids travelling with patient/client/resident?","Mobility assistance requirements","Can do stairs?","Falls risk?","Contact precautions?","Infection control considerations*","Medical directives","Harm reduction or ETOH management","Allergies","Vented","Oxygen","Diet","Diabetic","Wound","Weight","Specialty equipment","Is specialty equipment travelling with patient/client/resident?","Clinical considerations*","Behavioural considerations*","Restraints required?","Able to share room?","Name of primary contact/ next of kin","Phone number ","Email","Companion/partner at residence? (to be kept together)*","Transport offload area","Evacuation vendor* ","Level of care* ","Receiving site*","Receiving \nhealth authority","Receiving municipality","Assigned room #","Date of evacuation*","Date planned for repatriation","Current status","Items to return with patient","Alternate destination ","Comments"]

{"sheet":"Print - Complete List","index":2,"n_rows":10,"n_cols":55,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,"Do not delete this row - cell F1 helps calculate dynamic print area",null,null,null,{"$f":"COUNTIF(SendingSiteList[Name*],\"<>\")+1","v":1},"columns",{"$f":"COLUMNS(SendingSiteList[#Headers])","v":54}]
[null,"Sending site list: Evacuation of patient/client/residents"]
[null,"Last updated:",{"$f":"'Sending Site List'!$C$3","v":"yyyy-mm-dd at hh:mm"}]
[null,"Next update:",{"$f":"'Sending Site List'!$C$4","v":"yyyy-mm-dd at hh:mm"}]
[null,"Updated by:",{"$f":"'Sending Site List'!$C$5","v":"Name and organization"}]
[]
[null,"Sending details - to be filled out by sending site",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Receiving / repatriation - to be filled out by receiving site"]
[null,"Patient/client/resident information",null,null,null,null,null,null,null,null,null,"Physician care",null,"Transport","Mobility",null,null,null,null,null,null,"Infection control",null,"Clinical considerations",null,null,null,null,null,null,null,null,null,null,null,"Behaviour",null,null,"Primary contact / next of kin",null,null,null,"Transport",null,"Patient/client/resident information",null,null,null,null,null,null,null,null,null,"Other"]
[null,"LTC: Long-term Care\nAL: Assisted Living\nIL: Independent Living\nACT: Acute\nAMB: Ambulatory","For example: surgery, neuro, medicine",null,null,"Last Name, First Name","M: Male\nF: Female\n","Date\nyyyy-mm-dd","Personal Health Number","Y: Yes\nN: No","BLND: Blind\nDEAF: Deaf","Last Name, First Name",null,"Wheelchair-adapted: Must be on wheelchair-adapted vehicle\nBus: Can tolerate standard bus transport\nAir: Only by air ambulance\nAmbulance: Only by road ambulance","Amb: Ambulatory (can walk > 10 steps)\nWCB: Wheelchair-bound (between 0-10 steps before wheelchair needed)\nSB: Stretcher-bound (cannot leave stretcher)","None: No aids\nC: Cane\n2WW: 2-wheel walker\n4WW: 4-wheel walker\nW/C: wheelchair","For example: BCEHS, private vehicle, SN Transport, Handi-Dart, BC Transit, etc.","Y: Yes\nN: No","Ind: Independent\n1 PA: 1-person assist\n2 PA: 2-person assist\nLift: ceiling or chair lift","Y: Yes\nN: No","Y: Yes\nN: No","Y: Yes\nN: No","Airborne, Contact, Droplet, \nMRSA, VRE, \nC. Diff, COVID-19 ","Indicate level of resuscitative effort","Y: Yes\nN: No","List all known allergies","Y: Yes\nN: No\nIf yes, how long for Independent Breathing Time (IBT)","Indicate if on any oxygen and how much (L/min)","List all restrictions","IDDM: Insulin dependent\nNIDDM: Not insulin dependent\nN: Not diabetic","Indicate location and stage of wounds/skin conditions and BRADEN score if known ","In pounds (lbs)\n\nBariatric if weight greater than 250 lbs","Such as specialty mattresses, pressure-relieving equipment, CPAP machines, ostomy care, peritoneal dialysis equipment, etc.","Y: Yes\nN: No\nIf yes, please list which equipment (pull from previous column)","Indicate relevant clinical information (example: dialysis, chemotherapy, etc.)","Such as aggression, violence, elopement, dementia, etc. ","Y: Yes\nN: No\nIf yes, indicate what restraints are required","Y: Yes\nN: No","Last Name, First Name",null,null,"Last Name, First Name","In large scale response (example: airport zone, or transport bay)","For example: BCEHS, private vehicle, SN Transport, Handi-Dart, BC Transit, etc.","LTC: Long-term Care\nAL: Assisted Living\nIL: Independent Living\nACT: Acute\nAMB: Ambulatory",null,null,null,null,"Date\nyyyy-mm-dd","Date\nyyyy-mm-dd","Receiving site\nIn transit\nDischarged to (details)\nRepatriated","Such as equipment, personal items, etc.","Indicate if resident went somewhere other than receiving location (for example: home, local transfer, etc.)"]
[null,"Level of care*","Type","Building/floor/wing*","Room number*","Name*","Sex*","Date of birth*","PHN*","Identifies as Indigenous?*","Disability","Sending physician name","Physician phone number","Best method of transportation*","Mobility status*","Mobility aids*","Vendor","Are mobility aids travelling with patient/client/resident?","Mobility assistance requirements","Can do stairs?","Falls risk?","Contact precautions?","Infection control considerations*","Medical directives","Harm reduction or ETOH management","Allergies","Vented","Oxygen","Diet","Diabetic","Wound","Weight","Specialty equipment","Is specialty equipment travelling with patient/client/resident?","Clinical considerations*","Behavioural considerations*","Restraints required?","Able to share room?","Name of primary contact/ next of kin","Phone number ","Email","Companion/partner at residence? (to be kept together)*","Transport offload area","Evacuation vendor* ","Level of care* ","Receiving site*","Receiving \nhealth authority","Receiving municipality","Assigned room #","Date of evacuation*","Date planned for repatriation","Current status","Items to return with patient","Alternate destination ","Comments"]

{"sheet":"Print - Transport List","index":3,"n_rows":7,"n_cols":17,"rows_kept":7,"cut":false,"hidden":false,"merged":[[5,14,5,16]]}
[null,"Do not delete this row - cell F1 helps calculate dynamic print area",null,null,null,{"$f":"COUNTIF(TransportList[Name*],\"<>\")+1","v":1},"columns",{"$f":"COLUMNS(TransportList[#Headers])","v":16}]
[null,null,null,null,"Transport Leader Name"]
[null,null,null,null,"Contact Information"]
[]
[null,null,null,null,"Transport",null,null,"Mobility"]
[null,"Last Name, First Name","Date\nyyyy-mm-dd","BLND: Blind\nDEAF: Deaf","Wheelchair-adapted: Must be on wheelchair-adapted vehicle\nBus: Can tolerate standard bus transport\nAir: Only by air ambulance\nAmbulance: Only by road ambulance",null,null,"Amb: Ambulatory (can walk > 10 steps)\nWCB: Wheelchair-bound (between 0-10 steps before wheelchair needed)\nSB: Stretcher-bound (cannot leave stretcher)","None: No aids\nC: Cane\n2WW: 2-wheel walker\n4WW: 4-wheel walker\nW/C: wheelchair","For example: BCEHS, private vehicle, SN Transport, Handi-Dart, BC Transit, etc.","Y: Yes\nN: No","Ind: Independent\n1 PA: 1-person assist\n2 PA: 2-person assist\nLift: ceiling or chair lift","Y: Yes\nN: No","Y: Yes\nN: No\nIf yes, indicate what alarms are used","Check when completed"]
[null,"Name*","Date of birth*","Disability","Best method of transportation*","Sending site","Receiving site*","Mobility status*","Mobility aids*","Vendor","Are mobility aids travelling with patient/client/resident?","Mobility assistance requirements","Can do stairs?","Falls risk?","Equipment","Luggage","Animals"]

{"sheet":"Print - Loading Unloading List","index":4,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,"Do not delete this row - cell F1 helps calculate dynamic print area",null,null,null,{"$f":"COUNTIF(LoadingUnloading[Name*],\"<>\")+1","v":1},"columns",{"$f":"COLUMNS(LoadingUnloading[#Headers])","v":7}]
[]
[null,"Patient/client/resident information",null,null,null,null,"Sign when completed"]
[null,"Name*","Medical Chart","Medications (PRN & 72-hour supply)","Luggage","Equipment","Sending Initial","Receiving Initial"]