{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["00 Cover","01 Introduction","02 Data Entry Instructions","03 Data Entry","04 Feedback Report Instructions","05 Feedback Report","06 Lists"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":7,"comments":1,"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":"00 Cover","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,"Neonatal Bloodstream Infection Prevention Assessment"]
[null,null,null,null,"(Neo BSI Prevention)"]
[null,null,null,null,"An assessment to target prevention "]
[null,null,null,null,"of bloodstream infections in neonatal care units"]
[]
[]
[null,null,null,null,"Intended for use in global healthcare settings"]
[]
[]
[null,null,null,null,"Version 1.0 - July 2025"]

{"sheet":"01 Introduction","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"02 Data Entry Instructions","index":2,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,0,3,0],[5,0,10,0],[12,0,13,0],[0,0,0,1],[15,0,17,0]]}
["Data Entry Instructions"]
[]
["Data Entry Overview","• One assessment from one respondent is entered into a row. There are 106 columns to enter for each row. "]
[null,"• The spreadsheet allows a maximum of 1,000 rows of responses to be entered."]
[]
["Importing Data","• To import data from another Excel workbook into the [03 Data Entry] sheet:"]
[null,"1. Ensure column order is identical in both files."]
[null,"2. In the other Excel file, select (click and drag the mouse to highlight) the cells you would like to copy. Do not highlight entire rows at a time.\nResponse options in both Excel files must match in spelling and formatting in order for summary features in the report to work."]
[null,"3. Right click and select Copy."]
[null,"4. On the [03 Data Entry sheet] in this workbook, click in the top left cell where you would like to paste. Right click and select Paste Value (icon with '123'). This will ensure the drop-down lists are still available after pasting the data."]
[null,"• These instructions are also available in the notes of cell A4 on the [03 Data Entry] sheet."]
[]
["Drop-down Lists","• The drop-down lists are stored on sheet [06 Lists]. This sheet is hidden to prevent accidental changes, but can be unhidden if response options need to be edited (for example, if using another language)."]
[null,"• To unhide the [06 Lists] sheet, right click on a tab below and and select \"unhide.\""]
[]
["Filters","• Data on the Feedback Report can be filtered to look at assessment results by role, primary shift worked, or other variables of interest. Filters are set on the Data Entry sheet."]
[null,"• For example, you may wish to only view results from assessments that checked \"nurse\" for Role in column E on sheet [03 Data Entry]. When this filter is applied, only the subset of responses that are \"nurse\" in column E will appear on the Feedback Report."]
[null,"• To set a filter, click the drop-down menu on a column header (in row 3) on sheet [03 Data Entry]and use the Excel menu to include or exclude responses."]
[]
["Column A (Survey Number)","• Each completed assessment must have an unique survey number assigned to be included in the Feedback Report. The survey number can be any value (letters or numbers).\n• Survey Number is assigned during data entry.\n• Survey Number is left blank/not assigned for any rows without responses."]
[]
["Column B (Date)","• Date format is (dd/mm/yyyy)."]
[]
["Column F (Role, other)","• If \"other\" is entered in column E for role, type in response here."]
[]
["Columns G and H (Number of Years)","• Only whole numbers can be entered in these columns.\n• If number of years is less than 1 (for example, 8 months), input as 0; this will be shown as \"Less than 1 Year\" on the Feedback Report. "]

{"sheet":"03 Data Entry","index":3,"n_rows":1002,"n_cols":102,"rows_kept":1002,"cut":false,"hidden":false,"merged":[[0,67,0,82],[0,83,0,98],[0,0,0,12],[1,34,1,38],[0,13,0,15],[0,28,0,56],[0,58,0,61],[0,62,0,66]]}
["Respondent Information",null,null,null,null,null,null,null,null,null,null,null,null,"1. Leadership and Coordination",null,null,"2A. Central Lines (CVCs, PICCs)",null,null,null,null,null,null,null,null,null,null,null,"2B. Central Line Practices",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,"3. Umbilical Catheters ",null,null,null,"4A. Peripheral IVs",null,null,null,null,"4B. Peripheral IV Practices",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5. Medication Preparation Practices"]
[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,"7. Do healthcare personnel use the following maximum sterile barrier precautions when inserting a central line?"]
["Survey Number\n (Required for every row of data)","Date\n(dd/mm/yyyy)","Hospital Name\n(text)","Unit or Ward Name\n(text)","What is your role?\n(choose from drop down)","Role, Other:\n(text)","Number of years in role\n(numbers only)","Number of years on this unit\n(numbers only)","Do you insert or assist with insertion of central lines (for example, PICC or umbilical catheter)?","Do you maintain or assist with maintenance of central lines?","Do you insert or assist with insertion of peripheral IVs?","Do you maintain or assist with maintenance of peripheral IVs?","\nPrimary shift worked ","1. Is unit leadership (medical or nursing) involved in prevention activities for bloodstream infections?","2. Is there a dedicated person(s) in the unit that focuses on prevention activities for bloodstream infections?","3. Does the unit review each case when a bloodstream infection occurs to identify potential gaps in practice?","1. Does the unit have a protocol for central line use?","2. Does the unit have ready-to-use central line insertion kits?","3. Does the unit have ready-to-use dressing change kits?","4. Are antiseptic-containing connectors used on the unit?","5. Does the unit document when a central line is inserted?","6. Did you receive training from your hospital on inserting central lines?\n(choose all that apply)","7. Did you receive training from your hospital on maintaining central lines?\n(choose all that apply)","8. Did your training on central lines include aseptic technique for insertion? ","9. Did your training on inserting central lines include maximum\nsterile barrier precautions?","10. Did your training include use of aseptic technique while accessing or manipulating the catheter?","11. Did your training include assessing the insertion site for any signs of infection?","12. Did your training include management of IV tubing? \n","1. Do physicians provide a written order for central lines?","2. Are central lines preferred over peripheral lines if long-term venous access is needed ?  ","3. Are central lines inserted by personnel trained on insertion? ","4. Do healthcare personnel perform hand hygiene before putting on sterile gloves for insertion? ","5. Is skin prepared with antiseptic before insertion?","6. Is antiseptic allowed to air dry before skin puncture? ","7A. Surgical Cap","7B. Mask","7C. Sterile gown","7D. Sterile gloves","7E. Sterile drape to cover patient","8. Do at least two healthcare personnel insert a central line? ","9. Do healthcare personnel stop central line insertion (non-emergent) if proper procedures are not followed?","10. Are central lines with the minimum number of lumens used?     ","11. Are central lines secured to the skin without sutures?","12. Are central line insertion sites covered with a sterile dressing? \n","13. Are central lines assessed daily to ensure they are still needed?","14. Are central lines maintained and accessed only by trained healthcare personnel? ","15. Is hand hygiene performed before manipulating a central line? ","16. Are central lines accessed with only sterile devices ?      ","17. Are access ports or hubs cleaned immediately prior to use with an antiseptic? ","18. Is skin prepared with antiseptic during dressing changes? \n","19. Are dressings changed using aseptic technique? \n","20. Are dressings immediately replaced when wet, soiled, or dislodged?","21.Is IV tubing used for continuous infusions changed every 4 days?\n","22. Is IV tubing used for blood, blood products, or fat emulsions changed every 24 hours?","23. Are insertion sites routinely monitored for signs of infection ?","24. Are central lines that are no longer needed promptly removed ? ","25. Are central lines removed immediately if there are any signs of catheter-related bloodstream infection or thrombosis?","26. Is removal of a central line performed using aseptic technique?","1. Does the unit have a policy for the length of time an umbilical venous catheter can remain in place?\n          ","2. Does the unit have a policy for the length of time an umbilical arterial catheter can remain in place?\n","3. Does the unit avoid using topical antibiotic ointment or creams on umbilical catheter sites?                   ","4. Are umbilical lines secured to the skin without sutures?   \n","1. Did you receive training from your hospital on inserting peripheral IVs? \n(choose all that apply)","2. Did you receive training from your hospital on maintaining peripheral IVs?\n(choose all that apply)                    ","3. Did your training on peripheral IVs include precautions during insertion? ","4. Did your training on peripheral IVs include precautions when accessing an IV?\n","5. Did your training on peripheral IVs include assessing the site for any signs of infection?                                  ","1. Is hand hygiene performed before putting on gloves for inserting a peripheral IV?  ","2. Are clean, single-use gloves worn to insert a peripheral IV?","3. Is skin antisepsis performed prior to inserting a peripheral IV? ","4. Are peripheral IVs secured on neonates? \n","5.  Does the unit document  when a peripheral IV is inserted?","6. Is hand hygiene performed before accessing a peripheral IV?\n","7. Is skin antisepsis performed prior to accessing a peripheral IV?                        ","8. Are ports or caps disinfected each time a peripheral IV is accessed?   ","9. Are peripheral IVs flushed with sterile saline after infusion? ","10. Are pre-filled syringes used for saline flushes?   \n","11. Is IV tubing used for continuous infusions changed every 4 days?","12. Is IV tubing used for blood, blood products, or fat emulsions changed every 24 hours?                        ","13. Are peripheral IVs assessed daily to ensure they are still needed?","14. Are peripheral IVs removed immediately when no longer needed?                                 ","15. Are peripheral IVs checked regularly  for signs of infection? \n","16. Are peripheral IVs removed promptly when there is sign of infection?","1. Does a pharmacist review medication prescribed for neonates?","2. Is medicine prepared in a designated area?\n","3. Is the medication preparation area cleaned and disinfected regularly?","4. Are supplies accessible where medicines are prepared? ","5. Is hand hygiene performed before preparing medication?","6. Is the rubber diaphragm (vial) or neck (ampoule) disinfected before accessing?                                    ","7. Is the disinfectant allowed to air dry before accessing the vial or ampoule?                                                        ","8. Is a single-dose vial used for only one patient? ","9. Is a single-dose vial discarded after one use? (even if there is medication left over)","10. Is a new, sterile needle and syringe used to access a single-dose vial? ","11. Is a new, sterile needle and syringe used to access a multi-dose vial?                              ","12. Are multi-dose vials stored away from the neonate's bedside? ","13. Are multi-dose vials discarded within their expiration date? ","14. Are IV solutions kept free from needle punctures/spikes?","15. Is a sterile diluent, such as water or saline in 10mL vials, used to reconstitute a medication? ","16. Are IV solutions used only for infusion? (In other words, they are NOT used to dilute or reconstitute medicine)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A1002<>\"\",IF(CH1002=\"always\", 1, IF(CH1002=\"often\", 0.75, IF(CH1002=\"sometimes\", 0.5, IF(CH1002=\"rarely\", 0.25, 0))))+IF(CI1002=\"always\", 1, IF(CI1002=\"often\", 0.75, IF(CI1002=\"sometimes\", 0.5, IF(CI1002=\"rarely\", 0.25, 0))))+IF(CJ1002=\"always\", 1, IF(CJ1002=\"often\", 0.75, IF(CJ1002=\"sometimes\", 0.5, IF(CJ1002=\"rarely\", 0.25, 0))))+IF(CK1002=\"always\", 1, IF(CK1002=\"often\", 0.75, IF(CK1002=\"sometimes\", 0.5, IF(CK1002=\"rarely\", 0.25, 0))))+IF(#REF!=\"always\", 1, IF(#REF!=\"often\", 0.75, IF(#REF!=\"sometimes\", 0.5, IF(#REF!=\"rarely\", 0.25, 0))))+IF(CL1002=\"always\", 1, IF(CL1002=\"often\", 0.75, IF(CL1002=\"sometimes\", 0.5, IF(CL1002=\"rarely\", 0.25, 0))))+IF(CN1002=\"always\", 1, IF(CN1002=\"often\", 0.75, IF(CN1002=\"sometimes\", 0.5, IF(CN1002=\"rarely\", 0.25, 0))))+IF(CO1002=\"always\", 1, IF(CO1002=\"often\", 0.75, IF(CO1002=\"sometimes\", 0.5, IF(CO1002=\"rarely\", 0.25, 0))))+IF(#REF!=\"always\", 1, IF(#REF!=\"often\", 0.75, IF(#REF!=\"sometimes\", 0.5, IF(#REF!=\"rarely\", 0.25, 0))))+IF(CP1002=\"always\", 1, IF(CP1002=\"often\", 0.75, IF(CP1002=\"sometimes\", 0.5, IF(CP1002=\"rarely\", 0.25, 0))))+IF(CS1002=\"always\", 1, IF(CS1002=\"often\", 0.75, IF(CS1002=\"sometimes\", 0.5, IF(CS1002=\"rarely\", 0.25, 0))))+IF(CT1002=\"always\", 1, IF(CT1002=\"often\", 0.75, IF(CT1002=\"sometimes\", 0.5, IF(CT1002=\"rarely\", 0.25, 0))))+IF(#REF!=\"always\", 1, IF(#REF!=\"often\", 0.75, IF(#REF!=\"sometimes\", 0.5, IF(#REF!=\"rarely\", 0.25, 0))))+IF(CU1002=\"always\", 1, IF(CU1002=\"often\", 0.75, IF(CU1002=\"sometimes\", 0.5, IF(CU1002=\"rarely\", 0.25, 0))))+IF(#REF!=\"always\", 1, IF(#REF!=\"often\", 0.75, IF(#REF!=\"sometimes\", 0.5, IF(#REF!=\"rarely\", 0.25, 0))))+IF(#REF!=\"always\", 1, IF(#REF!=\"often\", 0.75, IF(#REF!=\"sometimes\", 0.5, IF(#REF!=\"rarely\", 0.25, 0))))+IF(#REF!=\"always\", 1, IF(#REF!=\"often\", 0.75, IF(#REF!=\"sometimes\", 0.5, IF(#REF!=\"rarely\", 0.25, 0))))+IF(#REF!=\"always\", 1, IF(#REF!=\"often\", 0.75, IF(#REF!=\"sometimes\", 0.5, IF(#REF!=\"rarely\", 0.25, 0))))+IF(#REF!=\"always\", 1, IF(#REF!=\"often\", 0.75, IF(#REF!=\"sometimes\", 0.5, IF(#REF!=\"rarely\", 0.25, 0))))+IF(#REF!=\"always\", 1, IF(#REF!=\"often\", 0.75, IF(#REF!=\"sometimes\", 0.5, IF(#REF!=\"rarely\", 0.25, 0))))+IF(#REF!=\"always\", 1, IF(#REF!=\"often\", 0.75, IF(#REF!=\"sometimes\", 0.5, IF(#REF!=\"rarely\", 0.25, 0)))), \" \")","v":" "},{"$f":"IF(A1002<>\"\",(IF(#REF!=\"yes\", 1, IF(#REF!=\"Clinical staff not responsible for cleaning/disinfection of supplies\",1, 0)) + IF(#REF!=\"yes\", 1, 0)+ IF(#REF!=\"yes\", 1, 0)+  IF(#REF!=\"yes\", 1, IF(#REF!=\"No parenteral nutrition on unit\", 1, 0))), \" \")","v":" "}]

{"sheet":"04 Feedback Report Instructions","index":4,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[[23,0,24,0],[1,0,1,1],[3,0,4,0],[20,0,21,0],[10,0,13,0],[15,0,16,0]]}
[]
["Feedback Report Instructions"]
[]
["Feedback Report Overview","• Responses entered into the Data Entry sheet are aggregated in the Feedback Report. "]
[null,"• You can customize the Feedback Report as needed using the instructions below and the instruction boxes to the right of the Feedback Report."]
[]
["Summary Section","• The first section of the Feedback Report is the summary of the assessment. After reviewing assessment results on the full report, you will type the summary statements (Overall Strengths and Opportunities for Improvement) in manually. The Summary section will print as Page 1 when saving as a PDF."]
[]
["Number of Assessments","• Current view shows the number of assessments currently being analyzed on the Feedback Report. If a data filter is applied on the Data Entry sheet, this number will be less than the total number of assessments. "]
[]
["Overall Strengths and Opportunities for Improvement","• While this section comes first on the Feedback Report sheet, you will complete this section last. "]
[null,"• Using the Opportunities for Improvement by Assessment Section and the red and green highlights on the response tallies (Rows 63-176), identify questions or themes to highlight as overall strengths or opportunities for improvement. Type or copy and paste text into the Overall Strengths and Overall Opportunities for Improvement boxes."]
[null,"• Review the Respondent Information for context when interpreting the data. "]
[null,"• When presenting findings to leadership or staff, these boxes provide an overall summary of the assessment and can help focus next steps."]
[]
["Opportunities for Improvement by Assessment Section","• Complete this section after you have reviewed the response tallies (Rows 63-174)."]
[null," • As you review the response tallies, identify questions where responses are highlighted in red. You can copy and paste the question into the relevant box under Opportunities for Improvement by Assessment Section, or you may wish to rephrase the question as a statement."]
[]
["Respondent Information","• Questions from the \"Respondent Information\" section on the assessment are aggregated in tables in this section. If a data filter is applied, only the current number of assessments being analyzed will be reflected in the Respondent Information tables."]
[]
["Percentage Cutoffs","• This section sets the percentages that categorizes a question as a \"Strength\" or \"Opportunity for Improvement.\""]
[null,"• You can adjust these percentages to increase or decrease the threshold for categorizing questions as \"Strengths\" or \"Opportunities for Improvement.\""]
[]
["Saving as PDF","• You can save the Feedback Report as a PDF to be printed or shared electronically. "]
[null,"• The first page of the PDF is the summary and may be most useful for sharing with leadership and staff. For those who would like to look at assessment results question by question, the full report can be shared."]

{"sheet":"05 Feedback Report","index":5,"n_rows":174,"n_cols":12,"rows_kept":174,"cut":false,"hidden":false,"merged":[[51,2,51,3],[50,7,51,8],[49,7,49,11],[50,9,51,9],[81,1,81,6],[73,1,73,5],[74,1,74,5],[67,1,67,7],[68,1,68,7],[69,1,69,7],[70,1,70,7],[71,1,71,7],[50,11,51,11],[60,1,60,11],[56,1,56,3],[57,1,57,3],[55,6,55,11],[56,6,56,10],[57,6,57,10],[55,1,55,4],[50,10,51,10],[62,1,62,7],[53,1,53,11],[66,1,66,5],[47,2,47,3],[49,2,49,3],[50,2,50,3],[25,1,25,11],[45,7,45,9],[46,10,47,10],[47,7,47,9],[39,2,39,3],[41,2,41,3],[42,2,42,3],[46,7,46,9],[35,2,35,3],[37,2,37,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[38,2,38,3],[46,2,46,3],[43,2,43,3],[45,2,45,3],[29,2,29,3],[34,2,34,3],[23,6,23,11],[13,1,13,5],[13,6,13,11],[14,6,14,11],[15,6,15,11],[23,1,23,5],[22,1,22,5],[20,6,20,11],[21,6,21,11],[17,1,17,5],[16,1,16,5],[15,1,15,5],[22,6,22,11],[5,5,5,11],[6,5,6,11],[8,5,8,11],[9,5,9,11],[11,1,11,5],[14,1,14,5],[7,1,9,4],[21,1,21,5],[11,6,11,11],[18,6,18,11],[10,1,10,11],[17,6,17,11],[19,6,19,11],[12,6,12,11],[20,1,20,5],[19,1,19,5],[18,1,18,5],[16,6,16,11],[6,1,6,2],[88,1,88,4],[105,1,105,4],[162,1,162,4],[96,2,96,4],[133,1,133,6],[134,1,134,6],[135,1,135,6],[130,1,130,5],[129,1,129,5],[122,1,122,7],[103,1,103,4],[107,1,107,4],[98,1,98,4],[153,1,153,4],[100,1,100,4],[104,1,104,4],[143,1,143,4],[106,1,106,4],[112,1,112,4],[108,1,108,4],[114,1,114,4],[92,2,92,3],[93,2,93,3],[94,2,94,3],[95,2,95,3],[111,1,111,4],[113,1,113,4],[149,1,149,4],[144,1,144,4],[160,1,160,4],[118,1,118,4],[121,1,121,5],[109,1,109,4],[157,1,157,4],[159,1,159,4],[131,1,131,11],[117,1,117,4],[116,1,116,4],[147,1,147,4],[148,1,148,4],[145,1,145,4],[150,1,150,4],[151,1,151,4],[152,1,152,4],[154,1,154,4],[146,1,146,4],[137,1,137,11],[156,1,156,11],[0,1,0,11],[1,1,1,11],[4,1,4,4],[61,1,61,5],[59,1,59,10],[99,1,99,4],[86,1,86,4],[158,1,158,4],[97,1,97,4],[132,1,132,4],[141,1,141,4],[138,1,138,2],[4,5,4,11],[7,5,7,11],[12,1,12,5],[139,1,139,4],[140,1,140,4],[87,1,87,4],[85,1,85,4],[110,1,110,4],[89,1,89,4],[90,1,90,4],[115,1,115,4],[2,1,2,11],[167,1,167,4],[168,1,168,4],[166,1,166,4],[165,1,165,4],[163,1,163,4],[164,1,164,4],[186,1,186,11],[175,9,175,10],[175,5,175,6],[172,1,172,4],[170,1,170,4],[173,1,173,4],[181,5,181,6],[177,9,177,10],[171,1,171,4],[184,9,184,10],[176,1,176,4],[185,5,185,6],[185,1,185,4],[183,1,183,4],[180,5,180,6],[177,1,177,4],[177,5,177,6],[178,1,178,4],[202,2,202,11],[203,2,203,11],[204,2,204,11],[205,2,205,11],[206,2,206,11],[201,2,201,11],[194,2,194,11],[188,2,188,11],[189,2,189,11],[190,2,190,11],[193,2,193,11],[195,2,195,11],[196,2,196,11],[197,2,197,11],[200,2,200,11],[198,2,198,11],[199,2,199,11],[191,2,191,11],[192,2,192,11],[58,6,58,10],[84,1,84,4],[76,1,76,4],[63,1,63,7],[64,1,64,7],[77,1,77,6],[78,1,78,6],[79,1,79,6],[80,1,80,6],[75,1,75,11],[82,1,82,11],[65,1,65,11],[83,1,83,11],[91,1,91,11],[142,1,142,4],[169,1,169,4],[187,1,187,11],[175,1,175,4],[176,5,176,6],[181,9,181,10],[161,1,161,4],[123,1,123,7],[124,1,124,7],[125,1,125,7],[102,1,102,11],[120,1,120,11],[127,1,127,11],[183,5,183,6],[182,5,182,6],[182,1,182,4],[180,1,180,4],[178,5,178,6],[179,9,179,10],[184,5,184,6],[184,1,184,4],[179,1,179,4],[179,5,179,6]]}
[null,"Neo BSI Prevention Assessment: Feedback Report"]
[null,"Unit Name"]
[null,"Summary"]
[]
[null,"Number of Assessments",null,null,null,"Overall Strengths 1"]
[null,"Current View",{"$f":"SUBTOTAL(3,'03 Data Entry'!$A4:$A1001)","v":0},"Total",{"$f":"COUNTA('03 Data Entry'!$A4:$A1001)","v":0}]
[]
[null,"Note: Results are for quality improvement and should not be used as a method to compare to other units. Responses are self-reported and results may not represent awareness and perceptions among all personnel. ",null,null,null,"Overall Opportunities for Improvement 2"]
[]
[]
[null,"Opportunities for Improvement by Assessment Section 2"]
[null,"1. Leadership and Coordination",null,null,null,null,"4. Peripheral Vs"]
[]
[]
[null,"2A and 2B. Central Lines"]
[]
[]
[" "]
[null,null,null,null,null,null,"5. Medication Preparation"]
[]
[]
[null,"3. Umbilical Catheters"]
[]
[]
[]
[null,"Respondent Information"]
[]
[null,null,null,null,"#      Respondents","% Respondents",null,null,null,"# Respondents","% \nRespondents"]
[null,null,"Role",null,null,null,null,null,"Primary Shift "]
[null,null,"Nurse",null,{"$f":"SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!E3, ROW('03 Data Entry'!E4:E1001)-ROW('03 Data Entry'!$E$3),,1)),--(ISNUMBER(MATCH('03 Data Entry'!E4:E1001,{\"Nurse\"},0))))","v":0},{"$f":"IFERROR(E30/$C$6, \" \")","v":" "},null,null,"Day",{"$f":"SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!M3, ROW('03 Data Entry'!M4:M1001)-ROW('03 Data Entry'!$M$3),,1)),--(ISNUMBER(MATCH('03 Data Entry'!M4:M1001,{\"Day\"},0))))","v":0},{"$f":"IFERROR(J30/$C$6, \" \")","v":" "}]
[null,null,"Nurse Technician",null,{"$f":"SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!E3, ROW('03 Data Entry'!E4:E1001)-ROW('03 Data Entry'!$E$3),,1)),--(ISNUMBER(MATCH('03 Data Entry'!E4:E1001,{\"Nurse Technician\"},0))))","v":0}," ",null,null,"Night",{"$f":"SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!M3, ROW('03 Data Entry'!M4:M1001)-ROW('03 Data Entry'!$M$3),,1)),--(ISNUMBER(MATCH('03 Data Entry'!M4:M1001,{\"Night\"},0))))","v":0},{"$f":"IFERROR(J31/$C$6, \" \")","v":" "}]
[null,null,"Physician",null,{"$f":"SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!E3, ROW('03 Data Entry'!E4:E1001)-ROW('03 Data Entry'!$E$3),,1)),--(ISNUMBER(MATCH('03 Data Entry'!E4:E1001,{\"Physician\"},0))))","v":0}," ",null,null,"Both",{"$f":"SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!M3, ROW('03 Data Entry'!M4:M1001)-ROW('03 Data Entry'!$M$3),,1)),--(ISNUMBER(MATCH('03 Data Entry'!M4:M1001,{\"Both\"},0))))","v":0},{"$f":"IFERROR(J32/$C$6, \" \")","v":" "}]
[null,null,"IPC Professional",null,{"$f":"SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!E3,ROW('03 Data Entry'!E4:E1001)-ROW('03 Data Entry'!$E$3),,1)),--(ISNUMBER(MATCH('03 Data Entry'!E4:E1001,{\"IPC Professional\"},0))))","v":0}," ",null,null,"Years of Experience"]
[null,null,"Pharmacist",null,{"$f":"SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!E3,ROW('03 Data Entry'!E4:E1001)-ROW('03 Data Entry'!$E$3),,1)),--(ISNUMBER(MATCH('03 Data Entry'!E4:E1001,{\"Pharmacist\"},0))))","v":0}," ",null,null,"Less than 1",{"$f":"SUMPRODUCT(SUBTOTAL(2,OFFSET('03 Data Entry'!G3,ROW('03 Data Entry'!G4:G1001)-ROW('03 Data Entry'!$G$3),0)),('03 Data Entry'!G4:G1001<1)+0)","v":0},{"$f":"IFERROR(J34/$C$6, \" \")","v":" "}]
[null,null,"Other",null,{"$f":"SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!E3,ROW('03 Data Entry'!E4:E1001)-ROW('03 Data Entry'!$E$3),,1)),--(ISNUMBER(MATCH('03 Data Entry'!E4:E1001,{\"Other\"},0))))","v":0}," ",null,null,"1 to 5 years",{"$f":"SUMPRODUCT(SUBTOTAL(2,OFFSET('03 Data Entry'!G3,ROW('03 Data Entry'!G4:G1001)-ROW('03 Data Entry'!$G$3),0)),('03 Data Entry'!G4:G1001>=1)*('03 Data Entry'!G4:G1001<=5.5)+0)","v":0},{"$f":"IFERROR(J35/$C$6, \" \")","v":" "}]
[null,null,"Missing",null,{"$f":"$C$6-SUM(E30:E35)","v":0},"--",null,null,"6 to 10 years",{"$f":"SUMPRODUCT(SUBTOTAL(2,OFFSET('03 Data Entry'!G3,ROW('03 Data Entry'!G4:G1001)-ROW('03 Data Entry'!$G$3),0)),('03 Data Entry'!G4:G1001>5.5)*('03 Data Entry'!G4:G1001<=10)+0)","v":0},{"$f":"IFERROR(J36/$C$6, \" \")","v":" "}]
[null,null,"Insert or assist with insertion of central lines",null,null,null,null,null,"Over 10 years",{"$f":"SUMPRODUCT(SUBTOTAL(2,OFFSET('03 Data Entry'!G3,ROW('03 Data Entry'!G4:G1001)-ROW('03 Data Entry'!$G$3),0)),('03 Data Entry'!G4:G1001>10)+0)","v":0},{"$f":"IFERROR(J37/$C$6, \" \")","v":" "}]
[null,null,"Yes",null,{"$f":"SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!I3, ROW('03 Data Entry'!I4:I1001)-ROW('03 Data Entry'!$I$3),,1)),--(ISNUMBER(MATCH('03 Data Entry'!I4:I1001,{\"Yes\"},0))))","v":0},{"$f":"IFERROR(E38/$C$6, \"\")","v":""},null,null,"Missing",{"$f":"$C$6-SUM(J34:J37)","v":0},"--"]
[null,null,"No",null,{"$f":"SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!I3, ROW('03 Data Entry'!I4:I1001)-ROW('03 Data Entry'!$I$3),,1)),--(ISNUMBER(MATCH('03 Data Entry'!I4:I1001,{\"No\"},0))))","v":0},{"$f":"IFERROR(E39/$C$6, \"\")","v":""},null,null,"Years of Experience in This Unit"]
[null,null,"Missing",null,{"$f":"$C$6-SUM(E38:E39)","v":0},"--",null,null,"Less than 1",{"$f":"SUMPRODUCT(SUBTOTAL(2,OFFSET('03 Data Entry'!H3,ROW('03 Data Entry'!H4:H1001)-ROW('03 Data Entry'!$H$3),0)),('03 Data Entry'!H4:H1001<1)+0)","v":0},{"$f":"IFERROR(J40/$C$6, \" \")","v":" "}]
[null,null,"Maintain or assist with maintenance of central lines",null,null,null,null,null,"1 to 5 years",{"$f":"SUMPRODUCT(SUBTOTAL(2,OFFSET('03 Data Entry'!H3,ROW('03 Data Entry'!H4:H1001)-ROW('03 Data Entry'!$H$3),0)),('03 Data Entry'!H4:H1001>=1)*('03 Data Entry'!H4:H1001<=5.5)+0)","v":0},{"$f":"IFERROR(J41/$C$6, \" \")","v":" "}]
[null,null,"Yes",null,{"$f":"SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!J3,ROW('03 Data Entry'!J4:J1001)-ROW('03 Data Entry'!$J$3),,1)),--(ISNUMBER(MATCH('03 Data Entry'!J4:J1001,{\"Yes\"},0))))","v":0},{"$f":"IFERROR(E42/$C$6, \"\")","v":""},null,null,"6 to 10 years",{"$f":"SUMPRODUCT(SUBTOTAL(2,OFFSET('03 Data Entry'!H3,ROW('03 Data Entry'!H4:H1001)-ROW('03 Data Entry'!$H$3),0)),('03 Data Entry'!H4:H1001>5.5)*('03 Data Entry'!H4:H1001<=10)+0)","v":0},{"$f":"IFERROR(J42/$C$6, \" \")","v":" "}]
[null,null,"No",null,{"$f":"SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!J3,ROW('03 Data Entry'!J4:J1001)-ROW('03 Data Entry'!$J$3),,1)),--(ISNUMBER(MATCH('03 Data Entry'!J4:J1001,{\"No\"},0))))","v":0},{"$f":"IFERROR(E43/$C$6, \"\")","v":""},null,null,"Over 10 years",{"$f":"SUMPRODUCT(SUBTOTAL(2,OFFSET('03 Data Entry'!H3,ROW('03 Data Entry'!H4:H1001)-ROW('03 Data Entry'!$H$3),0)),('03 Data Entry'!H4:H1001>10)+0)","v":0},{"$f":"IFERROR(J43/$C$6, \" \")","v":" "}]
[null,null,"Missing",null,{"$f":"$C$6-SUM(E42:E43)","v":0},"--",null,null,"Missing",{"$f":"$C$6-SUM(J40:J43)","v":0},"--"]
[null,null,"Insert or assist with insertion of peripheral IVs"]
[null,null,"Yes",null,{"$f":"SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!K3,ROW('03 Data Entry'!K4:K1001)-ROW('03 Data Entry'!$K$3),,1)),--(ISNUMBER(MATCH('03 Data Entry'!K4:K1001,{\"Yes\"},0))))","v":0},{"$f":"IFERROR(E46/$C$6, \"\")","v":""}]
[null,null,"No",null,{"$f":"SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!K3,ROW('03 Data Entry'!K4:K1001)-ROW('03 Data Entry'!$K$3),,1)),--(ISNUMBER(MATCH('03 Data Entry'!K4:K1001,{\"No\"},0))))","v":0},{"$f":"IFERROR(E47/$C$6, \"\")","v":""},null,null,null,null,{"$f":"IF(E6=C6, \"No\", \"Yes\")","v":"No"}]
[null,null,"Missing",null,{"$f":"$C$6-SUM(E46:E47)","v":0},"--",null,"Filter Applied?"]
[null,null,"Maintain or assist with maintenance of peripheral IVs"]
[null,null,"Yes",null,{"$f":"SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!L3,ROW('03 Data Entry'!L4:L1001)-ROW('03 Data Entry'!$L$3),,1)),--(ISNUMBER(MATCH('03 Data Entry'!L4:L1001,{\"Yes\"},0))))","v":0},{"$f":"IFERROR(E50/$C$6, \"\")","v":""},null,"Current View"]
[null,null,"No",null,{"$f":"SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!L3,ROW('03 Data Entry'!L4:L1001)-ROW('03 Data Entry'!$L$3),,1)),--(ISNUMBER(MATCH('03 Data Entry'!L4:L1001,{\"No\"},0))))","v":0},{"$f":"IFERROR(E51/$C$6, \"\")","v":""},null,"# of assessments:",null,{"$f":"C6","v":0},"% of assessments:",{"$f":"IFERROR(C6/E6, \"0\")","v":"0"}]
[null,null,"Missing",null,{"$f":"$C$6-SUM(E50:E51)","v":0},"--"]
[]
[null,"Percentage Cutoffs"]
[]
[null,"Strengths",null,null,null,null,"Opportunities for Improvement"]
[null,"Yes  ≥",null,null,0.75,null,"Do Not Know ≥",null,null,null,null,0.33]
[null,"Sum of (Often + Always) ≥",null,null,0.75,null,"Sum of (No + Do Not Know) ≥",null,null,null,null,0.495]
[null,null,null,null,null,null,"Sum of (Never + Rarely + Sometimes + Do Not Know) ≥",null,null,null,null,0.495]
[]
[null,"1. Leadership and Coordination"]
[null,null,null,null,null,null,null,null,"Yes","  No","Do Not Know","# Responses"]
[null,"1. Is unit leadership (medical or nursing) involved in prevention activities for bloodstream infections?",null,null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!N4,ROW('03 Data Entry'!N4:N1001)-ROW('03 Data Entry'!N4),0)),('03 Data Entry'!N4:N1001=\"Yes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!N4:N1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!N4,ROW('03 Data Entry'!N4:N1001)-ROW('03 Data Entry'!N4),0)),('03 Data Entry'!N4:N1001=\"No\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!N4:N1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!N4,ROW('03 Data Entry'!N4:N1001)-ROW('03 Data Entry'!N4),0)),('03 Data Entry'!N4:N1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!N4:N1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!N4:N1001)","v":0}]
[null,"2. Is there a dedicated person(s) in the unit that focuses on prevention activities for bloodstream infections?",null,null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!O4,ROW('03 Data Entry'!O4:O1001)-ROW('03 Data Entry'!O4),0)),('03 Data Entry'!O4:O1001=\"Yes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!O4:O1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!O4,ROW('03 Data Entry'!O4:O1001)-ROW('03 Data Entry'!O4),0)),('03 Data Entry'!O4:O1001=\"No\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!O4:O1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!O4,ROW('03 Data Entry'!O4:O1001)-ROW('03 Data Entry'!O4),0)),('03 Data Entry'!O4:O1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!O4:O1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!O4:O1001)","v":0}]
[null,"3. Does the unit review each case when a bloodstream infection occurs to identify potential gaps in practice?",null,null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!P4,ROW('03 Data Entry'!P4:P1001)-ROW('03 Data Entry'!P4),0)),('03 Data Entry'!P4:P1001=\"Yes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!P4:P1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!P4,ROW('03 Data Entry'!P4:P1001)-ROW('03 Data Entry'!P4),0)),('03 Data Entry'!P4:P1001=\"No\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!P4:P1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!P4,ROW('03 Data Entry'!P4:P1001)-ROW('03 Data Entry'!P4),0)),('03 Data Entry'!P4:P1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!P4:P1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!P4:P1001)","v":0}]
[null,"2A. Central Lines (CVC, PICC)"]
[null,null,null,null,null,null,null,null,"Yes","  No","Do Not Know","# Responses"]
[null,"1. Does the unit have a protocol for central line use? (for example, protocol for insertion, maintenance, and removal)",null,null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!Q4,ROW('03 Data Entry'!Q4:Q1001)-ROW('03 Data Entry'!Q4),0)),('03 Data Entry'!Q4:Q1001=\"Yes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!Q4:Q1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!Q4,ROW('03 Data Entry'!Q4:Q1001)-ROW('03 Data Entry'!Q4),0)),('03 Data Entry'!Q4:Q1001=\"No\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!Q4:Q1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!Q4,ROW('03 Data Entry'!Q4:Q1001)-ROW('03 Data Entry'!Q4),0)),('03 Data Entry'!Q4:Q1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!Q4:Q1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!Q4:Q1001)","v":0}]
[null,"2. Does the unit have ready-to-use central line insertion kits?",null,null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!R4,ROW('03 Data Entry'!R4:R1001)-ROW('03 Data Entry'!R4),0)),('03 Data Entry'!R4:R1001=\"Yes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!R4:R1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!R4,ROW('03 Data Entry'!R4:R1001)-ROW('03 Data Entry'!R4),0)),('03 Data Entry'!R4:R1001=\"No\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!R4:R1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!R4,ROW('03 Data Entry'!R4:R1001)-ROW('03 Data Entry'!R4),0)),('03 Data Entry'!R4:R1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!R4:R1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!R4:R1001)","v":0}]
[null,"3. Does the unit have ready-to-use dressing change kits?",null,null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!S4,ROW('03 Data Entry'!S4:S1001)-ROW('03 Data Entry'!S4),0)),('03 Data Entry'!S4:S1001=\"Yes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!S4:S1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!S4,ROW('03 Data Entry'!S4:S1001)-ROW('03 Data Entry'!S4),0)),('03 Data Entry'!S4:S1001=\"No\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!S4:S1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!S4,ROW('03 Data Entry'!S4:S1001)-ROW('03 Data Entry'!S4),0)),('03 Data Entry'!S4:S1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!S4:S1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!S4:S1001)","v":0}]
[null,"4. Are antiseptic-containing connectors used on the unit?",null,null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!T4,ROW('03 Data Entry'!T4:T1001)-ROW('03 Data Entry'!T4),0)),('03 Data Entry'!T4:T1001=\"Yes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!T4:T1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!T4,ROW('03 Data Entry'!T4:T1001)-ROW('03 Data Entry'!T4),0)),('03 Data Entry'!T4:T1001=\"No\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!T4:T1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!T4,ROW('03 Data Entry'!T4:T1001)-ROW('03 Data Entry'!T4),0)),('03 Data Entry'!T4:T1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!T4:T1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!T4:T1001)","v":0}]
[null,"5. Does the unit document when a central line is inserted? (for example, in the medical record)",null,null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!U4,ROW('03 Data Entry'!U4:U1001)-ROW('03 Data Entry'!U4),0)),('03 Data Entry'!U4:U1001=\"Yes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!U4:U1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!U4,ROW('03 Data Entry'!U4:U1001)-ROW('03 Data Entry'!U4),0)),('03 Data Entry'!U4:U1001=\"No\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!U4:U1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!U4,ROW('03 Data Entry'!U4:U1001)-ROW('03 Data Entry'!U4),0)),('03 Data Entry'!U4:U1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!U4:U1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!U4:U1001)","v":0}]
[null,null,null,null,null,null,"During hire/ orientation","At least\n annually        ","New devices or protocols ","Never trained","Do not perform this procedure","# Responses"]
[null,"6. Did you receive training from your hospital on inserting central lines?*",null,null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!V4,ROW('03 Data Entry'!V4:V1001)-ROW('03 Data Entry'!V4),0)),(('03 Data Entry'!V4:V1001=\"A, B and C\")+('03 Data Entry'!V4:V1001=\"A and B\")+('03 Data Entry'!V4:V1001=\"A and C\")+('03 Data Entry'!V4:V1001=\"A. During hire or orientation\"))+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!V4:V1001)-'06 Lists'!L15), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!V4,ROW('03 Data Entry'!V4:V1001)-ROW('03 Data Entry'!V4),0)),(('03 Data Entry'!V4:V1001=\"A, B and C\")+('03 Data Entry'!V4:V1001=\"A and B\")+('03 Data Entry'!V4:V1001=\"B and C\")+('03 Data Entry'!V4:V1001=\"B. At least annually\"))+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!V4:V1001)-'06 Lists'!L15), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!V4,ROW('03 Data Entry'!V4:V1001)-ROW('03 Data Entry'!V4),0)),(('03 Data Entry'!V4:V1001=\"A, B and C\")+('03 Data Entry'!V4:V1001=\"A and C\")+('03 Data Entry'!V4:V1001=\"B and C\")+('03 Data Entry'!V4:V1001=\"C. When there are new devices or protocols\"))+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!V4:V1001)-'06 Lists'!L15), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!V4,ROW('03 Data Entry'!V4:V1001)-ROW('03 Data Entry'!V4),0)),('03 Data Entry'!V4:V1001=\"Never trained\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!V4:V1001)-'06 Lists'!L15), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!V4,ROW('03 Data Entry'!V4:V1001)-ROW('03 Data Entry'!V4),0)),('03 Data Entry'!V4:V1001=\"Do not perform this procedure\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!V4:V1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!V4:V1001)","v":0}]
[null,"7. Did you receive training from your hospital on maintaining central lines?*\n(Maintaining can mean performing a dressing change, accessing the line to administer medication, etc.)",null,null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!W4,ROW('03 Data Entry'!W4:W1001)-ROW('03 Data Entry'!W4),0)),(('03 Data Entry'!W4:W1001=\"A, B and C\")+('03 Data Entry'!W4:W1001=\"A and B\")+('03 Data Entry'!W4:W1001=\"A and C\")+('03 Data Entry'!W4:W1001=\"A. During hire or orientation\"))+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!W4:W1001)-'06 Lists'!L16), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!W4,ROW('03 Data Entry'!W4:W1001)-ROW('03 Data Entry'!W4),0)),(('03 Data Entry'!W4:W1001=\"A, B and C\")+('03 Data Entry'!W4:W1001=\"A and B\")+('03 Data Entry'!W4:W1001=\"B and C\")+('03 Data Entry'!W4:W1001=\"B. At least annually\"))+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!W4:W1001)-'06 Lists'!L16), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!W4,ROW('03 Data Entry'!W4:W1001)-ROW('03 Data Entry'!W4),0)),(('03 Data Entry'!W4:W1001=\"A, B and C\")+('03 Data Entry'!W4:W1001=\"A and C\")+('03 Data Entry'!W4:W1001=\"B and C\")+('03 Data Entry'!W4:W1001=\"C. When there are new devices or protocols\"))+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!W4:W1001)-'06 Lists'!L16), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!W4,ROW('03 Data Entry'!W4:W1001)-ROW('03 Data Entry'!W4),0)),('03 Data Entry'!W4:W1001=\"Never trained\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!W4:W1001)-'06 Lists'!L16), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!W4,ROW('03 Data Entry'!W4:W1001)-ROW('03 Data Entry'!W4),0)),('03 Data Entry'!W4:W1001=\"Do not perform this procedure\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!W4:W1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!W4:W1001)","v":0}]
[null,"*Percentages calculated by removing respondents that \"do not perform this procedure\" from the denominator. Red highlighting will appear when no responses are entered."]
[null,null,null,null,null,null,null,"Yes","No","Do Not Know","Did not receive training ","# Responses"]
[null,"8. Did your training on central lines include aseptic technique\nfor insertion?",null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!X4,ROW('03 Data Entry'!X4:X1001)-ROW('03 Data Entry'!X4),0)),('03 Data Entry'!X4:X1001=\"Yes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!X4:X1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!X4,ROW('03 Data Entry'!X4:X1001)-ROW('03 Data Entry'!X4),0)),('03 Data Entry'!X4:X1001=\"No\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!X4:X1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!X4,ROW('03 Data Entry'!X4:X1001)-ROW('03 Data Entry'!X4),0)),('03 Data Entry'!X4:X1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!X4:X1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!X4,ROW('03 Data Entry'!X4:X1001)-ROW('03 Data Entry'!X4),0)),('03 Data Entry'!X4:X1001=\"Did not receive training\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!X4:X1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!X4:X1001)","v":0}]
[null,"9. Did your training on inserting central lines include maximum\nsterile barrier precautions?\n(use of sterile gown, sterile gloves, mask, and cap, and sterile drape to cover patient)",null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!Y4,ROW('03 Data Entry'!Y4:Y1001)-ROW('03 Data Entry'!Y4),0)),('03 Data Entry'!Y4:Y1001=\"Yes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!Y4:Y1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!Y4,ROW('03 Data Entry'!Y4:Y1001)-ROW('03 Data Entry'!Y4),0)),('03 Data Entry'!Y4:Y1001=\"No\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!Y4:Y1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!Y4,ROW('03 Data Entry'!Y4:Y1001)-ROW('03 Data Entry'!Y4),0)),('03 Data Entry'!Y4:Y1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!Y4:Y1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!Y4,ROW('03 Data Entry'!Y4:Y1001)-ROW('03 Data Entry'!Y4),0)),('03 Data Entry'!Y4:Y1001=\"Did not receive training\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!Y4:Y1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!Y4:Y1001)","v":0}]
[null,"10. Did your training include use of aseptic technique while accessing or manipulating the catheter?",null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!Z4,ROW('03 Data Entry'!Z4:Z1001)-ROW('03 Data Entry'!Z4),0)),('03 Data Entry'!Z4:Z1001=\"Yes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!Z4:Z1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!Z4,ROW('03 Data Entry'!Z4:Z1001)-ROW('03 Data Entry'!Z4),0)),('03 Data Entry'!Z4:Z1001=\"No\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!Z4:Z1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!Z4,ROW('03 Data Entry'!Z4:Z1001)-ROW('03 Data Entry'!Z4),0)),('03 Data Entry'!Z4:Z1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!Z4:Z1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!Z4,ROW('03 Data Entry'!Z4:Z1001)-ROW('03 Data Entry'!Z4),0)),('03 Data Entry'!Z4:Z1001=\"Did not receive training\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!Z4:Z1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!Z4:Z1001)","v":0}]
[null,"11. Did your training include assessing the insertion site for any signs of infection?",null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AA4,ROW('03 Data Entry'!AA4:AA1001)-ROW('03 Data Entry'!AA4),0)),('03 Data Entry'!AA4:AA1001=\"Yes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AA4:AA1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AA4,ROW('03 Data Entry'!AA4:AA1001)-ROW('03 Data Entry'!AA4),0)),('03 Data Entry'!AA4:AA1001=\"No\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AA4:AA1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AA4,ROW('03 Data Entry'!AA4:AA1001)-ROW('03 Data Entry'!AA4),0)),('03 Data Entry'!AA4:AA1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AA4:AA1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AA4,ROW('03 Data Entry'!AA4:AA1001)-ROW('03 Data Entry'!AA4),0)),('03 Data Entry'!AA4:AA1001=\"Did not receive training\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AA4:AA1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AA4:AA1001)","v":0}]
[null,"12. Did your training include management of IV tubing? \n(for example, when to change IV tubing sets)",null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AB4,ROW('03 Data Entry'!AB4:AB1001)-ROW('03 Data Entry'!AB4),0)),('03 Data Entry'!AB4:AB1001=\"Yes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AB4:AB1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AB4,ROW('03 Data Entry'!AB4:AB1001)-ROW('03 Data Entry'!AB4),0)),('03 Data Entry'!AB4:AB1001=\"No\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AB4:AB1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AB4,ROW('03 Data Entry'!AB4:AB1001)-ROW('03 Data Entry'!AB4),0)),('03 Data Entry'!AB4:AB1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AB4:AB1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AB4,ROW('03 Data Entry'!AB4:AB1001)-ROW('03 Data Entry'!AB4),0)),('03 Data Entry'!AB4:AB1001=\"Did not receive training\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AB4:AB1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AB4:AB1001)","v":0}]
[]
[null,"2B. Central Line Practices"]
[null,null,null,null,null,"Always","Often","Sometimes","Rarely","Never","Do Not Know","# Responses"]
[null,"1. Do physicians provide a written order for central lines? ",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AC4,ROW('03 Data Entry'!AC4:AC1001)-ROW('03 Data Entry'!AC4),0)),('03 Data Entry'!AC4:AC1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AC4:AC1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AC4,ROW('03 Data Entry'!AC4:AC1001)-ROW('03 Data Entry'!AC4),0)),('03 Data Entry'!AC4:AC1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AC4:AC1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AC4,ROW('03 Data Entry'!AC4:AC1001)-ROW('03 Data Entry'!AC4),0)),('03 Data Entry'!AC4:AC1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AC4:AC1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AC4,ROW('03 Data Entry'!AC4:AC1001)-ROW('03 Data Entry'!AC4),0)),('03 Data Entry'!AC4:AC1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AC4:AC1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AC4,ROW('03 Data Entry'!AC4:AC1001)-ROW('03 Data Entry'!AC4),0)),('03 Data Entry'!AC4:AC1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AC4:AC1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AC4,ROW('03 Data Entry'!AC4:AC1001)-ROW('03 Data Entry'!AC4),0)),('03 Data Entry'!AC4:AC1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AC4:AC1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AC4:AC1001)","v":0}]
[null,"2. Are central lines preferred over peripheral lines if long-term venous access is needed? (for example, more than one week)",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AD4,ROW('03 Data Entry'!AD4:AD1001)-ROW('03 Data Entry'!AD4),0)),('03 Data Entry'!AD4:AD1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AD4:AD1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AD4,ROW('03 Data Entry'!AD4:AD1001)-ROW('03 Data Entry'!AD4),0)),('03 Data Entry'!AD4:AD1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AD4:AD1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AD4,ROW('03 Data Entry'!AD4:AD1001)-ROW('03 Data Entry'!AD4),0)),('03 Data Entry'!AD4:AD1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AD4:AD1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AD4,ROW('03 Data Entry'!AD4:AD1001)-ROW('03 Data Entry'!AD4),0)),('03 Data Entry'!AD4:AD1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AD4:AD1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AD4,ROW('03 Data Entry'!AD4:AD1001)-ROW('03 Data Entry'!AD4),0)),('03 Data Entry'!AD4:AD1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AD4:AD1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AD4,ROW('03 Data Entry'!AD4:AD1001)-ROW('03 Data Entry'!AD4),0)),('03 Data Entry'!AD4:AD1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AD4:AD1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AD4:AD1001)","v":0}]
[null,"3. Are central lines inserted by personnel trained on insertion?  ",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AE4,ROW('03 Data Entry'!AE4:AE1001)-ROW('03 Data Entry'!AE4),0)),('03 Data Entry'!AE4:AE1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AE4:AE1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AE4,ROW('03 Data Entry'!AE4:AE1001)-ROW('03 Data Entry'!AE4),0)),('03 Data Entry'!AE4:AE1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AE4:AE1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AE4,ROW('03 Data Entry'!AE4:AE1001)-ROW('03 Data Entry'!AE4),0)),('03 Data Entry'!AE4:AE1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AE4:AE1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AE4,ROW('03 Data Entry'!AE4:AE1001)-ROW('03 Data Entry'!AE4),0)),('03 Data Entry'!AE4:AE1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AE4:AE1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AE4,ROW('03 Data Entry'!AE4:AE1001)-ROW('03 Data Entry'!AE4),0)),('03 Data Entry'!AE4:AE1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AE4:AE1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AE4,ROW('03 Data Entry'!AE4:AE1001)-ROW('03 Data Entry'!AE4),0)),('03 Data Entry'!AE4:AE1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AE4:AE1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AE4:AE1001)","v":0}]
[null,"4. Do personnel perform hand hygiene before putting on sterile gloves for insertion?  ",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AF4,ROW('03 Data Entry'!AF4:AF1001)-ROW('03 Data Entry'!AF4),0)),('03 Data Entry'!AF4:AF1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AF4:AF1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AF4,ROW('03 Data Entry'!AF4:AF1001)-ROW('03 Data Entry'!AF4),0)),('03 Data Entry'!AF4:AF1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AF4:AF1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AF4,ROW('03 Data Entry'!AF4:AF1001)-ROW('03 Data Entry'!AF4),0)),('03 Data Entry'!AF4:AF1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AF4:AF1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AF4,ROW('03 Data Entry'!AF4:AF1001)-ROW('03 Data Entry'!AF4),0)),('03 Data Entry'!AF4:AF1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AF4:AF1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AF4,ROW('03 Data Entry'!AF4:AF1001)-ROW('03 Data Entry'!AF4),0)),('03 Data Entry'!AF4:AF1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AF4:AF1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AF4,ROW('03 Data Entry'!AF4:AF1001)-ROW('03 Data Entry'!AF4),0)),('03 Data Entry'!AF4:AF1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AF4:AF1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AF4:AF1001)","v":0}]
[null,"5. Is skin prepared with antiseptic before insertion? \n(chlorhexidine, povidone-iodine)",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AG4,ROW('03 Data Entry'!AG4:AG1001)-ROW('03 Data Entry'!AG4),0)),('03 Data Entry'!AG4:AG1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AG4:AG1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AG4,ROW('03 Data Entry'!AG4:AG1001)-ROW('03 Data Entry'!AG4),0)),('03 Data Entry'!AG4:AG1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AG4:AG1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AG4,ROW('03 Data Entry'!AG4:AG1001)-ROW('03 Data Entry'!AG4),0)),('03 Data Entry'!AG4:AG1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AG4:AG1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AG4,ROW('03 Data Entry'!AG4:AG1001)-ROW('03 Data Entry'!AG4),0)),('03 Data Entry'!AG4:AG1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AG4:AG1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AG4,ROW('03 Data Entry'!AG4:AG1001)-ROW('03 Data Entry'!AG4),0)),('03 Data Entry'!AG4:AG1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AG4:AG1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AG4,ROW('03 Data Entry'!AG4:AG1001)-ROW('03 Data Entry'!AG4),0)),('03 Data Entry'!AG4:AG1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AG4:AG1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AG4:AG1001)","v":0}]
[null,"6. Is antiseptic allowed to air dry before skin puncture? ",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AH4,ROW('03 Data Entry'!AH4:AH1001)-ROW('03 Data Entry'!AH4),0)),('03 Data Entry'!AH4:AH1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AH4:AH1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AH4,ROW('03 Data Entry'!AH4:AH1001)-ROW('03 Data Entry'!AH4),0)),('03 Data Entry'!AH4:AH1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AH4:AH1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AH4,ROW('03 Data Entry'!AH4:AH1001)-ROW('03 Data Entry'!AH4),0)),('03 Data Entry'!AH4:AH1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AH4:AH1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AH4,ROW('03 Data Entry'!AH4:AH1001)-ROW('03 Data Entry'!AH4),0)),('03 Data Entry'!AH4:AH1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AH4:AH1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AH4,ROW('03 Data Entry'!AH4:AH1001)-ROW('03 Data Entry'!AH4),0)),('03 Data Entry'!AH4:AH1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AH4:AH1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AH4,ROW('03 Data Entry'!AH4:AH1001)-ROW('03 Data Entry'!AH4),0)),('03 Data Entry'!AH4:AH1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AH4:AH1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AH4:AH1001)","v":0}]
[null,"7. Do healthcare personnel use the following maximum sterile barrier precautions when inserting a central line? "]
[null,null,"A. Surgical cap",null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AI4,ROW('03 Data Entry'!AI4:AI1001)-ROW('03 Data Entry'!AI4),0)),('03 Data Entry'!AI4:AI1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AI4:AI1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AI4,ROW('03 Data Entry'!AI4:AI1001)-ROW('03 Data Entry'!AI4),0)),('03 Data Entry'!AI4:AI1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AI4:AI1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AI4,ROW('03 Data Entry'!AI4:AI1001)-ROW('03 Data Entry'!AI4),0)),('03 Data Entry'!AI4:AI1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AI4:AI1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AI4,ROW('03 Data Entry'!AI4:AI1001)-ROW('03 Data Entry'!AI4),0)),('03 Data Entry'!AI4:AI1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AI4:AI1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AI4,ROW('03 Data Entry'!AI4:AI1001)-ROW('03 Data Entry'!AI4),0)),('03 Data Entry'!AI4:AI1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AI4:AI1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AI4,ROW('03 Data Entry'!AI4:AI1001)-ROW('03 Data Entry'!AI4),0)),('03 Data Entry'!AI4:AI1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AI4:AI1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AI4:AI1001)","v":0}]
[null,null,"B. Mask",null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AJ4,ROW('03 Data Entry'!AJ4:AJ1001)-ROW('03 Data Entry'!AJ4),0)),('03 Data Entry'!AJ4:AJ1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AJ4:AJ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AJ4,ROW('03 Data Entry'!AJ4:AJ1001)-ROW('03 Data Entry'!AJ4),0)),('03 Data Entry'!AJ4:AJ1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AJ4:AJ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AJ4,ROW('03 Data Entry'!AJ4:AJ1001)-ROW('03 Data Entry'!AJ4),0)),('03 Data Entry'!AJ4:AJ1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AJ4:AJ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AJ4,ROW('03 Data Entry'!AJ4:AJ1001)-ROW('03 Data Entry'!AJ4),0)),('03 Data Entry'!AJ4:AJ1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AJ4:AJ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AJ4,ROW('03 Data Entry'!AJ4:AJ1001)-ROW('03 Data Entry'!AJ4),0)),('03 Data Entry'!AJ4:AJ1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AJ4:AJ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AJ4,ROW('03 Data Entry'!AJ4:AJ1001)-ROW('03 Data Entry'!AJ4),0)),('03 Data Entry'!AJ4:AJ1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AJ4:AJ1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AJ4:AJ1001)","v":0}]
[null,null,"C. Sterile gown",null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AK4,ROW('03 Data Entry'!AK4:AK1001)-ROW('03 Data Entry'!AK4),0)),('03 Data Entry'!AK4:AK1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AK4:AK1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AK4,ROW('03 Data Entry'!AK4:AK1001)-ROW('03 Data Entry'!AK4),0)),('03 Data Entry'!AK4:AK1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AK4:AK1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AK4,ROW('03 Data Entry'!AK4:AK1001)-ROW('03 Data Entry'!AK4),0)),('03 Data Entry'!AK4:AK1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AK4:AK1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AK4,ROW('03 Data Entry'!AK4:AK1001)-ROW('03 Data Entry'!AK4),0)),('03 Data Entry'!AK4:AK1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AK4:AK1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AK4,ROW('03 Data Entry'!AK4:AK1001)-ROW('03 Data Entry'!AK4),0)),('03 Data Entry'!AK4:AK1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AK4:AK1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AK4,ROW('03 Data Entry'!AK4:AK1001)-ROW('03 Data Entry'!AK4),0)),('03 Data Entry'!AK4:AK1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AK4:AK1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AK4:AK1001)","v":0}]
[null,null,"D. Sterile gloves",null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AL4,ROW('03 Data Entry'!AL4:AL1001)-ROW('03 Data Entry'!AL4),0)),('03 Data Entry'!AL4:AL1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AL4:AL1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AL4,ROW('03 Data Entry'!AL4:AL1001)-ROW('03 Data Entry'!AL4),0)),('03 Data Entry'!AL4:AL1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AL4:AL1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AL4,ROW('03 Data Entry'!AL4:AL1001)-ROW('03 Data Entry'!AL4),0)),('03 Data Entry'!AL4:AL1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AL4:AL1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AL4,ROW('03 Data Entry'!AL4:AL1001)-ROW('03 Data Entry'!AL4),0)),('03 Data Entry'!AL4:AL1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AL4:AL1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AL4,ROW('03 Data Entry'!AL4:AL1001)-ROW('03 Data Entry'!AL4),0)),('03 Data Entry'!AL4:AL1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AL4:AL1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AL4,ROW('03 Data Entry'!AL4:AL1001)-ROW('03 Data Entry'!AL4),0)),('03 Data Entry'!AL4:AL1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AL4:AL1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AL4:AL1001)","v":0}]
[null,null,"E. Sterile drape to cover patient",null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AM4,ROW('03 Data Entry'!AM4:AM1001)-ROW('03 Data Entry'!AM4),0)),('03 Data Entry'!AM4:AM1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AM4:AM1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AM4,ROW('03 Data Entry'!AM4:AM1001)-ROW('03 Data Entry'!AM4),0)),('03 Data Entry'!AM4:AM1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AM4:AM1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AM4,ROW('03 Data Entry'!AM4:AM1001)-ROW('03 Data Entry'!AM4),0)),('03 Data Entry'!AM4:AM1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AM4:AM1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AM4,ROW('03 Data Entry'!AM4:AM1001)-ROW('03 Data Entry'!AM4),0)),('03 Data Entry'!AM4:AM1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AM4:AM1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AM4,ROW('03 Data Entry'!AM4:AM1001)-ROW('03 Data Entry'!AM4),0)),('03 Data Entry'!AM4:AM1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AM4:AM1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AM4,ROW('03 Data Entry'!AM4:AM1001)-ROW('03 Data Entry'!AM4),0)),('03 Data Entry'!AM4:AM1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AM4:AM1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AM4:AM1001)","v":0}]
[null,"8. Do at least two healthcare personnel insert a central line? (one who performs insertion and one who observes/assists with supplies)",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AN4,ROW('03 Data Entry'!AN4:AN1001)-ROW('03 Data Entry'!AN4),0)),('03 Data Entry'!AN4:AN1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AN4:AN1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AN4,ROW('03 Data Entry'!AN4:AN1001)-ROW('03 Data Entry'!AN4),0)),('03 Data Entry'!AN4:AN1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AN4:AN1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AN4,ROW('03 Data Entry'!AN4:AN1001)-ROW('03 Data Entry'!AN4),0)),('03 Data Entry'!AN4:AN1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AN4:AN1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AN4,ROW('03 Data Entry'!AN4:AN1001)-ROW('03 Data Entry'!AN4),0)),('03 Data Entry'!AN4:AN1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AN4:AN1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AN4,ROW('03 Data Entry'!AN4:AN1001)-ROW('03 Data Entry'!AN4),0)),('03 Data Entry'!AN4:AN1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AN4:AN1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AN4,ROW('03 Data Entry'!AN4:AN1001)-ROW('03 Data Entry'!AN4),0)),('03 Data Entry'!AN4:AN1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AN4:AN1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AN4:AN1001)","v":0}]
[null,"9. Do healthcare personnel stop central line insertion (non-emergent) if proper procedures are not followed?",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AO4,ROW('03 Data Entry'!AO4:AO1001)-ROW('03 Data Entry'!AO4),0)),('03 Data Entry'!AO4:AO1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AO4:AO1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AO4,ROW('03 Data Entry'!AO4:AO1001)-ROW('03 Data Entry'!AO4),0)),('03 Data Entry'!AO4:AO1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AO4:AO1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AO4,ROW('03 Data Entry'!AO4:AO1001)-ROW('03 Data Entry'!AO4),0)),('03 Data Entry'!AO4:AO1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AO4:AO1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AO4,ROW('03 Data Entry'!AO4:AO1001)-ROW('03 Data Entry'!AO4),0)),('03 Data Entry'!AO4:AO1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AO4:AO1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AO4,ROW('03 Data Entry'!AO4:AO1001)-ROW('03 Data Entry'!AO4),0)),('03 Data Entry'!AO4:AO1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AO4:AO1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AO4,ROW('03 Data Entry'!AO4:AO1001)-ROW('03 Data Entry'!AO4),0)),('03 Data Entry'!AO4:AO1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AO4:AO1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AO4:AO1001)","v":0}]
[null,"10. Are central lines with the minimum number of lumens used?",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AP4,ROW('03 Data Entry'!AP4:AP1001)-ROW('03 Data Entry'!AP4),0)),('03 Data Entry'!AP4:AP1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AP4:AP1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AP4,ROW('03 Data Entry'!AP4:AP1001)-ROW('03 Data Entry'!AP4),0)),('03 Data Entry'!AP4:AP1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AP4:AP1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AP4,ROW('03 Data Entry'!AP4:AP1001)-ROW('03 Data Entry'!AP4),0)),('03 Data Entry'!AP4:AP1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AP4:AP1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AP4,ROW('03 Data Entry'!AP4:AP1001)-ROW('03 Data Entry'!AP4),0)),('03 Data Entry'!AP4:AP1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AP4:AP1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AP4,ROW('03 Data Entry'!AP4:AP1001)-ROW('03 Data Entry'!AP4),0)),('03 Data Entry'!AP4:AP1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AP4:AP1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AP4,ROW('03 Data Entry'!AP4:AP1001)-ROW('03 Data Entry'!AP4),0)),('03 Data Entry'!AP4:AP1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AP4:AP1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AP4:AP1001)","v":0}]
[null,"11. Are central lines secured to the skin without sutures?   \n(for example, a securement device without sutures)",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AQ4,ROW('03 Data Entry'!AQ4:AQ1001)-ROW('03 Data Entry'!AQ4),0)),('03 Data Entry'!AQ4:AQ1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AQ4:AQ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AQ4,ROW('03 Data Entry'!AQ4:AQ1001)-ROW('03 Data Entry'!AQ4),0)),('03 Data Entry'!AQ4:AQ1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AQ4:AQ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AQ4,ROW('03 Data Entry'!AQ4:AQ1001)-ROW('03 Data Entry'!AQ4),0)),('03 Data Entry'!AQ4:AQ1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AQ4:AQ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AQ4,ROW('03 Data Entry'!AQ4:AQ1001)-ROW('03 Data Entry'!AQ4),0)),('03 Data Entry'!AQ4:AQ1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AQ4:AQ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AQ4,ROW('03 Data Entry'!AQ4:AQ1001)-ROW('03 Data Entry'!AQ4),0)),('03 Data Entry'!AQ4:AQ1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AQ4:AQ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AQ4,ROW('03 Data Entry'!AQ4:AQ1001)-ROW('03 Data Entry'!AQ4),0)),('03 Data Entry'!AQ4:AQ1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AQ4:AQ1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AQ4:AQ1001)","v":0}]
[]
[null,"2B. Central Line Practices, continued"]
[null,null,null,null,null,"Always","Often","Sometimes","Rarely","Never","Do Not Know","# Responses"]
[null,"12. Are central line insertion sites covered with a sterile dressing? (sterile gauze or sterile, transparent dressing)",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AR4,ROW('03 Data Entry'!AR4:AR1001)-ROW('03 Data Entry'!AR4),0)),('03 Data Entry'!AR4:AR1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AR4:AR1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AR4,ROW('03 Data Entry'!AR4:AR1001)-ROW('03 Data Entry'!AR4),0)),('03 Data Entry'!AR4:AR1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AR4:AR1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AR4,ROW('03 Data Entry'!AR4:AR1001)-ROW('03 Data Entry'!AR4),0)),('03 Data Entry'!AR4:AR1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AR4:AR1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AR4,ROW('03 Data Entry'!AR4:AR1001)-ROW('03 Data Entry'!AR4),0)),('03 Data Entry'!AR4:AR1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AR4:AR1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AR4,ROW('03 Data Entry'!AR4:AR1001)-ROW('03 Data Entry'!AR4),0)),('03 Data Entry'!AR4:AR1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AR4:AR1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AR4,ROW('03 Data Entry'!AR4:AR1001)-ROW('03 Data Entry'!AR4),0)),('03 Data Entry'!AR4:AR1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AR4:AR1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AR4:AR1001)","v":0}]
[null,"13. Are central lines assessed daily (for example, during patient rounds) to ensure they are still needed?",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AS4,ROW('03 Data Entry'!AS4:AS1001)-ROW('03 Data Entry'!AS4),0)),('03 Data Entry'!AS4:AS1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AS4:AS1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AS4,ROW('03 Data Entry'!AS4:AS1001)-ROW('03 Data Entry'!AS4),0)),('03 Data Entry'!AS4:AS1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AS4:AS1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AS4,ROW('03 Data Entry'!AS4:AS1001)-ROW('03 Data Entry'!AS4),0)),('03 Data Entry'!AS4:AS1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AS4:AS1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AS4,ROW('03 Data Entry'!AS4:AS1001)-ROW('03 Data Entry'!AS4),0)),('03 Data Entry'!AS4:AS1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AS4:AS1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AS4,ROW('03 Data Entry'!AS4:AS1001)-ROW('03 Data Entry'!AS4),0)),('03 Data Entry'!AS4:AS1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AS4:AS1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AS4,ROW('03 Data Entry'!AS4:AS1001)-ROW('03 Data Entry'!AS4),0)),('03 Data Entry'!AS4:AS1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AS4:AS1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AS4:AS1001)","v":0}]
[null,"14. Are central lines maintained and accessed only by trained healthcare personnel? ",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AT4,ROW('03 Data Entry'!AT4:AT1001)-ROW('03 Data Entry'!AT4),0)),('03 Data Entry'!AT4:AT1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AT4:AT1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AT4,ROW('03 Data Entry'!AT4:AT1001)-ROW('03 Data Entry'!AT4),0)),('03 Data Entry'!AT4:AT1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AT4:AT1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AT4,ROW('03 Data Entry'!AT4:AT1001)-ROW('03 Data Entry'!AT4),0)),('03 Data Entry'!AT4:AT1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AT4:AT1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AT4,ROW('03 Data Entry'!AT4:AT1001)-ROW('03 Data Entry'!AT4),0)),('03 Data Entry'!AT4:AT1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AT4:AT1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AT4,ROW('03 Data Entry'!AT4:AT1001)-ROW('03 Data Entry'!AT4),0)),('03 Data Entry'!AT4:AT1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AT4:AT1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AT4,ROW('03 Data Entry'!AT4:AT1001)-ROW('03 Data Entry'!AT4),0)),('03 Data Entry'!AT4:AT1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AT4:AT1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AT4:AT1001)","v":0}]
[null,"15. Is hand hygiene performed before manipulating a central line? (for example, accessing or performing a dressing change)",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AU4,ROW('03 Data Entry'!AU4:AU1001)-ROW('03 Data Entry'!AU4),0)),('03 Data Entry'!AU4:AU1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AU4:AU1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AU4,ROW('03 Data Entry'!AU4:AU1001)-ROW('03 Data Entry'!AU4),0)),('03 Data Entry'!AU4:AU1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AU4:AU1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AU4,ROW('03 Data Entry'!AU4:AU1001)-ROW('03 Data Entry'!AU4),0)),('03 Data Entry'!AU4:AU1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AU4:AU1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AU4,ROW('03 Data Entry'!AU4:AU1001)-ROW('03 Data Entry'!AU4),0)),('03 Data Entry'!AU4:AU1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AU4:AU1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AU4,ROW('03 Data Entry'!AU4:AU1001)-ROW('03 Data Entry'!AU4),0)),('03 Data Entry'!AU4:AU1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AU4:AU1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AU4,ROW('03 Data Entry'!AU4:AU1001)-ROW('03 Data Entry'!AU4),0)),('03 Data Entry'!AU4:AU1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AU4:AU1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AU4:AU1001)","v":0}]
[null,"16. Are central lines accessed with only sterile devices? (for example, syringes and tubing) ",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AV4,ROW('03 Data Entry'!AV4:AV1001)-ROW('03 Data Entry'!AV4),0)),('03 Data Entry'!AV4:AV1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AV4:AV1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AV4,ROW('03 Data Entry'!AV4:AV1001)-ROW('03 Data Entry'!AV4),0)),('03 Data Entry'!AV4:AV1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AV4:AV1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AV4,ROW('03 Data Entry'!AV4:AV1001)-ROW('03 Data Entry'!AV4),0)),('03 Data Entry'!AV4:AV1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AV4:AV1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AV4,ROW('03 Data Entry'!AV4:AV1001)-ROW('03 Data Entry'!AV4),0)),('03 Data Entry'!AV4:AV1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AV4:AV1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AV4,ROW('03 Data Entry'!AV4:AV1001)-ROW('03 Data Entry'!AV4),0)),('03 Data Entry'!AV4:AV1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AV4:AV1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AV4,ROW('03 Data Entry'!AV4:AV1001)-ROW('03 Data Entry'!AV4),0)),('03 Data Entry'!AV4:AV1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AV4:AV1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AV4:AV1001)","v":0}]
[null,"17. Are access ports or hubs cleaned immediately prior to use with an antiseptic? (chlorhexidine, povidone iodine, or 70% alcohol)",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AW4,ROW('03 Data Entry'!AW4:AW1001)-ROW('03 Data Entry'!AW4),0)),('03 Data Entry'!AW4:AW1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AW4:AW1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AW4,ROW('03 Data Entry'!AW4:AW1001)-ROW('03 Data Entry'!AW4),0)),('03 Data Entry'!AW4:AW1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AW4:AW1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AW4,ROW('03 Data Entry'!AW4:AW1001)-ROW('03 Data Entry'!AW4),0)),('03 Data Entry'!AW4:AW1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AW4:AW1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AW4,ROW('03 Data Entry'!AW4:AW1001)-ROW('03 Data Entry'!AW4),0)),('03 Data Entry'!AW4:AW1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AW4:AW1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AW4,ROW('03 Data Entry'!AW4:AW1001)-ROW('03 Data Entry'!AW4),0)),('03 Data Entry'!AW4:AW1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AW4:AW1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AW4,ROW('03 Data Entry'!AW4:AW1001)-ROW('03 Data Entry'!AW4),0)),('03 Data Entry'!AW4:AW1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AW4:AW1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AW4:AW1001)","v":0}]
[null,"18. Is skin prepared with antiseptic during dressing changes? \n(chlorhexidine, povidone iodine, or 70% alcohol)",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AX4,ROW('03 Data Entry'!AX4:AX1001)-ROW('03 Data Entry'!AX4),0)),('03 Data Entry'!AX4:AX1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AX4:AX1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AX4,ROW('03 Data Entry'!AX4:AX1001)-ROW('03 Data Entry'!AX4),0)),('03 Data Entry'!AX4:AX1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AX4:AX1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AX4,ROW('03 Data Entry'!AX4:AX1001)-ROW('03 Data Entry'!AX4),0)),('03 Data Entry'!AX4:AX1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AX4:AX1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AX4,ROW('03 Data Entry'!AX4:AX1001)-ROW('03 Data Entry'!AX4),0)),('03 Data Entry'!AX4:AX1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AX4:AX1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AX4,ROW('03 Data Entry'!AX4:AX1001)-ROW('03 Data Entry'!AX4),0)),('03 Data Entry'!AX4:AX1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AX4:AX1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AX4,ROW('03 Data Entry'!AX4:AX1001)-ROW('03 Data Entry'!AX4),0)),('03 Data Entry'!AX4:AX1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AX4:AX1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AX4:AX1001)","v":0}]
[null,"19. Are dressings changed using aseptic technique? \n(for example, using clean or sterile gloves)",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AY4,ROW('03 Data Entry'!AY4:AY1001)-ROW('03 Data Entry'!AY4),0)),('03 Data Entry'!AY4:AY1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AY4:AY1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AY4,ROW('03 Data Entry'!AY4:AY1001)-ROW('03 Data Entry'!AY4),0)),('03 Data Entry'!AY4:AY1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AY4:AY1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AY4,ROW('03 Data Entry'!AY4:AY1001)-ROW('03 Data Entry'!AY4),0)),('03 Data Entry'!AY4:AY1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AY4:AY1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AY4,ROW('03 Data Entry'!AY4:AY1001)-ROW('03 Data Entry'!AY4),0)),('03 Data Entry'!AY4:AY1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AY4:AY1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AY4,ROW('03 Data Entry'!AY4:AY1001)-ROW('03 Data Entry'!AY4),0)),('03 Data Entry'!AY4:AY1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AY4:AY1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AY4,ROW('03 Data Entry'!AY4:AY1001)-ROW('03 Data Entry'!AY4),0)),('03 Data Entry'!AY4:AY1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AY4:AY1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AY4:AY1001)","v":0}]
[null,"20. Are dressings immediately replaced when wet, soiled, or dislodged?",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AZ4,ROW('03 Data Entry'!AZ4:AZ1001)-ROW('03 Data Entry'!AZ4),0)),('03 Data Entry'!AZ4:AZ1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AZ4:AZ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AZ4,ROW('03 Data Entry'!AZ4:AZ1001)-ROW('03 Data Entry'!AZ4),0)),('03 Data Entry'!AZ4:AZ1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AZ4:AZ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AZ4,ROW('03 Data Entry'!AZ4:AZ1001)-ROW('03 Data Entry'!AZ4),0)),('03 Data Entry'!AZ4:AZ1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AZ4:AZ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AZ4,ROW('03 Data Entry'!AZ4:AZ1001)-ROW('03 Data Entry'!AZ4),0)),('03 Data Entry'!AZ4:AZ1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AZ4:AZ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AZ4,ROW('03 Data Entry'!AZ4:AZ1001)-ROW('03 Data Entry'!AZ4),0)),('03 Data Entry'!AZ4:AZ1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AZ4:AZ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!AZ4,ROW('03 Data Entry'!AZ4:AZ1001)-ROW('03 Data Entry'!AZ4),0)),('03 Data Entry'!AZ4:AZ1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!AZ4:AZ1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!AZ4:AZ1001)","v":0}]
[null,"21. Is IV tubing used for continuous infusions changed every 4 days?",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BA4,ROW('03 Data Entry'!BA4:BA1001)-ROW('03 Data Entry'!BA4),0)),('03 Data Entry'!BA4:BA1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BA4:BA1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BA4,ROW('03 Data Entry'!BA4:BA1001)-ROW('03 Data Entry'!BA4),0)),('03 Data Entry'!BA4:BA1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BA4:BA1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BA4,ROW('03 Data Entry'!BA4:BA1001)-ROW('03 Data Entry'!BA4),0)),('03 Data Entry'!BA4:BA1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BA4:BA1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BA4,ROW('03 Data Entry'!BA4:BA1001)-ROW('03 Data Entry'!BA4),0)),('03 Data Entry'!BA4:BA1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BA4:BA1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BA4,ROW('03 Data Entry'!BA4:BA1001)-ROW('03 Data Entry'!BA4),0)),('03 Data Entry'!BA4:BA1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BA4:BA1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BA4,ROW('03 Data Entry'!BA4:BA1001)-ROW('03 Data Entry'!BA4),0)),('03 Data Entry'!BA4:BA1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BA4:BA1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BA4:BA1001)","v":0}]
[null,"22. Is IV tubing used for blood, blood products, or fat emulsions changed every 24 hours?",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BB4,ROW('03 Data Entry'!BB4:BB1001)-ROW('03 Data Entry'!BB4),0)),('03 Data Entry'!BB4:BB1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BB4:BB1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BB4,ROW('03 Data Entry'!BB4:BB1001)-ROW('03 Data Entry'!BB4),0)),('03 Data Entry'!BB4:BB1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BB4:BB1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BB4,ROW('03 Data Entry'!BB4:BB1001)-ROW('03 Data Entry'!BB4),0)),('03 Data Entry'!BB4:BB1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BB4:BB1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BB4,ROW('03 Data Entry'!BB4:BB1001)-ROW('03 Data Entry'!BB4),0)),('03 Data Entry'!BB4:BB1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BB4:BB1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BB4,ROW('03 Data Entry'!BB4:BB1001)-ROW('03 Data Entry'!BB4),0)),('03 Data Entry'!BB4:BB1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BB4:BB1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BB4,ROW('03 Data Entry'!BB4:BB1001)-ROW('03 Data Entry'!BB4),0)),('03 Data Entry'!BB4:BB1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BB4:BB1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BB4:BB1001)","v":0}]
[null,"23. Are insertion sites routinely monitored for signs of infection? (for example, induration, erythema)",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BC4,ROW('03 Data Entry'!BC4:BC1001)-ROW('03 Data Entry'!BC4),0)),('03 Data Entry'!BC4:BC1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BC4:BC1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BC4,ROW('03 Data Entry'!BC4:BC1001)-ROW('03 Data Entry'!BC4),0)),('03 Data Entry'!BC4:BC1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BC4:BC1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BC4,ROW('03 Data Entry'!BC4:BC1001)-ROW('03 Data Entry'!BC4),0)),('03 Data Entry'!BC4:BC1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BC4:BC1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BC4,ROW('03 Data Entry'!BC4:BC1001)-ROW('03 Data Entry'!BC4),0)),('03 Data Entry'!BC4:BC1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BC4:BC1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BC4,ROW('03 Data Entry'!BC4:BC1001)-ROW('03 Data Entry'!BC4),0)),('03 Data Entry'!BC4:BC1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BC4:BC1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BC4,ROW('03 Data Entry'!BC4:BC1001)-ROW('03 Data Entry'!BC4),0)),('03 Data Entry'!BC4:BC1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BC4:BC1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BC4:BC1001)","v":0}]
[null,"24. Are central lines that are no longer needed promptly removed? (within 24 hours)",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BD4,ROW('03 Data Entry'!BD4:BD1001)-ROW('03 Data Entry'!BD4),0)),('03 Data Entry'!BD4:BD1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BD4:BD1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BD4,ROW('03 Data Entry'!BD4:BD1001)-ROW('03 Data Entry'!BD4),0)),('03 Data Entry'!BD4:BD1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BD4:BD1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BD4,ROW('03 Data Entry'!BD4:BD1001)-ROW('03 Data Entry'!BD4),0)),('03 Data Entry'!BD4:BD1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BD4:BD1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BD4,ROW('03 Data Entry'!BD4:BD1001)-ROW('03 Data Entry'!BD4),0)),('03 Data Entry'!BD4:BD1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BD4:BD1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BD4,ROW('03 Data Entry'!BD4:BD1001)-ROW('03 Data Entry'!BD4),0)),('03 Data Entry'!BD4:BD1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BD4:BD1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BD4,ROW('03 Data Entry'!BD4:BD1001)-ROW('03 Data Entry'!BD4),0)),('03 Data Entry'!BD4:BD1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BD4:BD1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BD4:BD1001)","v":0}]
[null,"25. Are central lines removed immediately if there are any signs of catheter-related bloodstream infection or thrombosis?",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BE4,ROW('03 Data Entry'!BE4:BE1001)-ROW('03 Data Entry'!BE4),0)),('03 Data Entry'!BE4:BE1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BE4:BE1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BE4,ROW('03 Data Entry'!BE4:BE1001)-ROW('03 Data Entry'!BE4),0)),('03 Data Entry'!BE4:BE1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BE4:BE1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BE4,ROW('03 Data Entry'!BE4:BE1001)-ROW('03 Data Entry'!BE4),0)),('03 Data Entry'!BE4:BE1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BE4:BE1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BE4,ROW('03 Data Entry'!BE4:BE1001)-ROW('03 Data Entry'!BE4),0)),('03 Data Entry'!BE4:BE1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BE4:BE1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BE4,ROW('03 Data Entry'!BE4:BE1001)-ROW('03 Data Entry'!BE4),0)),('03 Data Entry'!BE4:BE1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BE4:BE1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BE4,ROW('03 Data Entry'!BE4:BE1001)-ROW('03 Data Entry'!BE4),0)),('03 Data Entry'!BE4:BE1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BE4:BE1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BE4:BE1001)","v":0}]
[null,"26. Is removal of a central line performed using aseptic technique?",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BF4,ROW('03 Data Entry'!BF4:BF1001)-ROW('03 Data Entry'!BF4),0)),('03 Data Entry'!BF4:BF1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BF4:BF1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BF4,ROW('03 Data Entry'!BF4:BF1001)-ROW('03 Data Entry'!BF4),0)),('03 Data Entry'!BF4:BF1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BF4:BF1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BF4,ROW('03 Data Entry'!BF4:BF1001)-ROW('03 Data Entry'!BF4),0)),('03 Data Entry'!BF4:BF1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BF4:BF1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BF4,ROW('03 Data Entry'!BF4:BF1001)-ROW('03 Data Entry'!BF4),0)),('03 Data Entry'!BF4:BF1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BF4:BF1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BF4,ROW('03 Data Entry'!BF4:BF1001)-ROW('03 Data Entry'!BF4),0)),('03 Data Entry'!BF4:BF1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BF4:BF1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BF4,ROW('03 Data Entry'!BF4:BF1001)-ROW('03 Data Entry'!BF4),0)),('03 Data Entry'!BF4:BF1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BF4:BF1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BF4:BF1001)","v":0}]
[]
[null,"3. Umbilical Catheters "]
[null,null,null,null,null,null,null,null,"Yes","  No","Do Not Know","# Responses"]
[null,"1. Does the unit have a policy for the length of time an umbilical venous catheter can remain in place? \n(for example, no more than 7 days)  ",null,null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BG4,ROW('03 Data Entry'!BG4:BG1001)-ROW('03 Data Entry'!BG4),0)),('03 Data Entry'!BG4:BG1001=\"Yes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BG4:BG1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BG4,ROW('03 Data Entry'!BG4:BG1001)-ROW('03 Data Entry'!BG4),0)),('03 Data Entry'!BG4:BG1001=\"No\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BG4:BG1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BG4,ROW('03 Data Entry'!BG4:BG1001)-ROW('03 Data Entry'!BG4),0)),('03 Data Entry'!BG4:BG1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BG4:BG1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BG4:BG1001)","v":0}]
[null,"2. Does the unit have a policy for the length of time an umbilical arterial catheter can remain in place? \n(for example, no more than 7 days) ",null,null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BH4,ROW('03 Data Entry'!BH4:BH1001)-ROW('03 Data Entry'!BH4),0)),('03 Data Entry'!BH4:BH1001=\"Yes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BH4:BH1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BH4,ROW('03 Data Entry'!BH4:BH1001)-ROW('03 Data Entry'!BH4),0)),('03 Data Entry'!BH4:BH1001=\"No\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BH4:BH1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BH4,ROW('03 Data Entry'!BH4:BH1001)-ROW('03 Data Entry'!BH4),0)),('03 Data Entry'!BH4:BH1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BH4:BH1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BH4:BH1001)","v":0}]
[null,"3. Does the unit avoid using topical antibiotic ointment or creams on umbilical catheter sites?",null,null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BI4,ROW('03 Data Entry'!BI4:BI1001)-ROW('03 Data Entry'!BI4),0)),('03 Data Entry'!BI4:BI1001=\"Yes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BI4:BI1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BI4,ROW('03 Data Entry'!BI4:BI1001)-ROW('03 Data Entry'!BI4),0)),('03 Data Entry'!BI4:BI1001=\"No\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BI4:BI1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BI4,ROW('03 Data Entry'!BI4:BI1001)-ROW('03 Data Entry'!BI4),0)),('03 Data Entry'!BI4:BI1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BI4:BI1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BI4:BI1001)","v":0}]
[null,"4. Are umbilical lines secured to the skin without sutures? (for example, a securement device without sutures)",null,null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BJ4,ROW('03 Data Entry'!BJ4:BJ1001)-ROW('03 Data Entry'!BJ4),0)),('03 Data Entry'!BJ4:BJ1001=\"Yes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BJ4:BJ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BJ4,ROW('03 Data Entry'!BJ4:BJ1001)-ROW('03 Data Entry'!BJ4),0)),('03 Data Entry'!BJ4:BJ1001=\"No\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BJ4:BJ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BJ4,ROW('03 Data Entry'!BJ4:BJ1001)-ROW('03 Data Entry'!BJ4),0)),('03 Data Entry'!BJ4:BJ1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BJ4:BJ1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BJ4:BJ1001)","v":0}]
[]
[null,"4A. Peripheral IVs"]
[null,null,null,null,null,null,"During hire/ orientation","At least\n annually        ","New devices or protocols ","Never trained","Do not perform this procedure","# Responses"]
[null,"1. Did you receive training from your hospital on inserting peripheral IVs? (Check all that apply)*",null,null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BK4,ROW('03 Data Entry'!BK4:BK1001)-ROW('03 Data Entry'!BK4),0)),(('03 Data Entry'!BK4:BK1001=\"A, B and C\")+('03 Data Entry'!BK4:BK1001=\"A and B\")+('03 Data Entry'!BK4:BK1001=\"A and C\")+('03 Data Entry'!BK4:BK1001=\"A. During Hire or Orientation\"))+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BK4:BK1001)-'06 Lists'!L18), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BK4,ROW('03 Data Entry'!BK4:BK1001)-ROW('03 Data Entry'!BK4),0)),(('03 Data Entry'!BK4:BK1001=\"A, B and C\")+('03 Data Entry'!BK4:BK1001=\"A and B\")+('03 Data Entry'!BK4:BK1001=\"B and C\")+('03 Data Entry'!BK4:BK1001=\"B. At least annually\"))+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BK4:BK1001)-'06 Lists'!L18), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BK4,ROW('03 Data Entry'!BK4:BK1001)-ROW('03 Data Entry'!BK4),0)),(('03 Data Entry'!BK4:BK1001=\"A, B and C\")+('03 Data Entry'!BK4:BK1001=\"A and C\")+('03 Data Entry'!BK4:BK1001=\"B and C\")+('03 Data Entry'!BK4:BK1001=\"C. When there are new devices or protocols\"))+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BK4:BK1001)-'06 Lists'!L18), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BK4,ROW('03 Data Entry'!BK4:BK1001)-ROW('03 Data Entry'!BK4),0)),('03 Data Entry'!BK4:BK1001=\"Never trained\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BK4:BK1001)-'06 Lists'!L18), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BK4,ROW('03 Data Entry'!BK4:BK1001)-ROW('03 Data Entry'!BK4),0)),('03 Data Entry'!BK4:BK1001=\"Do not perform this procedure\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BK4:BK1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BK4:BK1001)","v":0}]
[null,"2. Did you receive training from your hospital on maintaining peripheral IVs? (Check all that apply)*",null,null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BL4,ROW('03 Data Entry'!BL4:BL1001)-ROW('03 Data Entry'!BL4),0)),(('03 Data Entry'!BL4:BL1001=\"A, B and C\")+('03 Data Entry'!BL4:BL1001=\"A and B\")+('03 Data Entry'!BL4:BL1001=\"A and C\")+('03 Data Entry'!BL4:BL1001=\"A. During hire or orientation\"))+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BL4:BL1001)-'06 Lists'!L19), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BL4,ROW('03 Data Entry'!BL4:BL1001)-ROW('03 Data Entry'!BL4),0)),(('03 Data Entry'!BL4:BL1001=\"A, B and C\")+('03 Data Entry'!BL4:BL1001=\"A and B\")+('03 Data Entry'!BL4:BL1001=\"B and C\")+('03 Data Entry'!BL4:BL1001=\"B. At least annually\"))+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BL4:BL1001)-'06 Lists'!L19), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BL4,ROW('03 Data Entry'!BL4:BL1001)-ROW('03 Data Entry'!BL4),0)),(('03 Data Entry'!BL4:BL1001=\"A, B and C\")+('03 Data Entry'!BL4:BL1001=\"A and C\")+('03 Data Entry'!BL4:BL1001=\"B and C\")+('03 Data Entry'!BL4:BL1001=\"C. When there are new devices or protocols\"))+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BL4:BL1001)-'06 Lists'!L19), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BL4,ROW('03 Data Entry'!BL4:BL1001)-ROW('03 Data Entry'!BL4),0)),('03 Data Entry'!BL4:BL1001=\"Never trained\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BL4:BL1001)-'06 Lists'!L19), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BL4,ROW('03 Data Entry'!BL4:BL1001)-ROW('03 Data Entry'!BL4),0)),('03 Data Entry'!BL4:BL1001=\"Do not perform this procedure\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BL4:BL1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BL4:BL1001)","v":0}]
[null,"*Percentages calculated by removing respondents that \"do not perform this procedure\" from the denominator. Red highlighting will appear when no responses are entered."]
[null,null,null,null,null,null,null,"Yes","No","Do Not Know","Did not receive training","# Responses"]
[null,"3. Did your training on peripheral IVs include precautions during insertion?\n(for example, hand hygiene, use of clean gloves, skin antisepsis)",null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BM4,ROW('03 Data Entry'!BM4:BM1001)-ROW('03 Data Entry'!BM4),0)),('03 Data Entry'!BM4:BM1001=\"Yes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BM4:BM1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BM4,ROW('03 Data Entry'!BM4:BM1001)-ROW('03 Data Entry'!BM4),0)),('03 Data Entry'!BM4:BM1001=\"No\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BM4:BM1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BM4,ROW('03 Data Entry'!BM4:BM1001)-ROW('03 Data Entry'!BM4),0)),('03 Data Entry'!BM4:BM1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BM4:BM1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BM4,ROW('03 Data Entry'!BM4:BM1001)-ROW('03 Data Entry'!BM4),0)),('03 Data Entry'!BM4:BM1001=\"Did not receive training\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BM4:BM1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BM4:BM1001)","v":0}]
[null,"4. Did your training on peripheral IVs include precautions when accessing an IV?\n(hand hygiene, use of clean gloves)",null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BN4,ROW('03 Data Entry'!BN4:BN1001)-ROW('03 Data Entry'!BN4),0)),('03 Data Entry'!BN4:BN1001=\"Yes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BN4:BN1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BN4,ROW('03 Data Entry'!BN4:BN1001)-ROW('03 Data Entry'!BN4),0)),('03 Data Entry'!BN4:BN1001=\"No\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BN4:BN1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BN4,ROW('03 Data Entry'!BN4:BN1001)-ROW('03 Data Entry'!BN4),0)),('03 Data Entry'!BN4:BN1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BN4:BN1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BN4,ROW('03 Data Entry'!BN4:BN1001)-ROW('03 Data Entry'!BN4),0)),('03 Data Entry'!BN4:BN1001=\"Did not receive training\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BN4:BN1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BN4:BN1001)","v":0}]
[null,"5. Did your training on peripheral IVs include assessing the site for any signs of infection?",null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BO4,ROW('03 Data Entry'!BO4:BO1001)-ROW('03 Data Entry'!BO4),0)),('03 Data Entry'!BO4:BO1001=\"Yes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BO4:BO1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BO4,ROW('03 Data Entry'!BO4:BO1001)-ROW('03 Data Entry'!BO4),0)),('03 Data Entry'!BO4:BO1001=\"No\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BO4:BO1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BO4,ROW('03 Data Entry'!BO4:BO1001)-ROW('03 Data Entry'!BO4),0)),('03 Data Entry'!BO4:BO1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BO4:BO1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BO4,ROW('03 Data Entry'!BO4:BO1001)-ROW('03 Data Entry'!BO4),0)),('03 Data Entry'!BO4:BO1001=\"Did not receive training\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BO4:BO1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BO4:BO1001)","v":0}]
[]
[null,"4B. Peripheral IVs: Practices"]
[null,null,null,null,null,"Always","Often","Sometimes","Rarely","Never","Do Not Know","# Responses"]
[null,"1. Is hand hygiene performed before putting on gloves for inserting a peripheral IV? ",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BP4,ROW('03 Data Entry'!BP4:BP1001)-ROW('03 Data Entry'!BP4),0)),('03 Data Entry'!BP4:BP1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BP4:BP1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BP4,ROW('03 Data Entry'!BP4:BP1001)-ROW('03 Data Entry'!BP4),0)),('03 Data Entry'!BP4:BP1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BP4:BP1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BP4,ROW('03 Data Entry'!BP4:BP1001)-ROW('03 Data Entry'!BP4),0)),('03 Data Entry'!BP4:BP1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BP4:BP1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BP4,ROW('03 Data Entry'!BP4:BP1001)-ROW('03 Data Entry'!BP4),0)),('03 Data Entry'!BP4:BP1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BP4:BP1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BP4,ROW('03 Data Entry'!BP4:BP1001)-ROW('03 Data Entry'!BP4),0)),('03 Data Entry'!BP4:BP1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BP4:BP1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BP4,ROW('03 Data Entry'!BP4:BP1001)-ROW('03 Data Entry'!BP4),0)),('03 Data Entry'!BP4:BP1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BP4:BP1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BP4:BP1001)","v":0}]
[null,"2. Are clean, single-use gloves worn to insert a peripheral IV?",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BQ4,ROW('03 Data Entry'!BQ4:BQ1001)-ROW('03 Data Entry'!BQ4),0)),('03 Data Entry'!BQ4:BQ1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BQ4:BQ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BQ4,ROW('03 Data Entry'!BQ4:BQ1001)-ROW('03 Data Entry'!BQ4),0)),('03 Data Entry'!BQ4:BQ1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BQ4:BQ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BQ4,ROW('03 Data Entry'!BQ4:BQ1001)-ROW('03 Data Entry'!BQ4),0)),('03 Data Entry'!BQ4:BQ1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BQ4:BQ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BQ4,ROW('03 Data Entry'!BQ4:BQ1001)-ROW('03 Data Entry'!BQ4),0)),('03 Data Entry'!BQ4:BQ1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BQ4:BQ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BQ4,ROW('03 Data Entry'!BQ4:BQ1001)-ROW('03 Data Entry'!BQ4),0)),('03 Data Entry'!BQ4:BQ1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BQ4:BQ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BQ4,ROW('03 Data Entry'!BQ4:BQ1001)-ROW('03 Data Entry'!BQ4),0)),('03 Data Entry'!BQ4:BQ1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BQ4:BQ1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BQ4:BQ1001)","v":0}]
[null,"3. Is skin antisepsis performed prior to inserting a peripheral IV? ",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BR4,ROW('03 Data Entry'!BR4:BR1001)-ROW('03 Data Entry'!BR4),0)),('03 Data Entry'!BR4:BR1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BR4:BR1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BR4,ROW('03 Data Entry'!BR4:BR1001)-ROW('03 Data Entry'!BR4),0)),('03 Data Entry'!BR4:BR1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BR4:BR1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BR4,ROW('03 Data Entry'!BR4:BR1001)-ROW('03 Data Entry'!BR4),0)),('03 Data Entry'!BR4:BR1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BR4:BR1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BR4,ROW('03 Data Entry'!BR4:BR1001)-ROW('03 Data Entry'!BR4),0)),('03 Data Entry'!BR4:BR1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BR4:BR1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BR4,ROW('03 Data Entry'!BR4:BR1001)-ROW('03 Data Entry'!BR4),0)),('03 Data Entry'!BR4:BR1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BR4:BR1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BR4,ROW('03 Data Entry'!BR4:BR1001)-ROW('03 Data Entry'!BR4),0)),('03 Data Entry'!BR4:BR1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BR4:BR1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BR4:BR1001)","v":0}]
[null,"4. Are peripheral IVs secured on neonates? \n(for example, steristrips, splint if needed) ",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BS4,ROW('03 Data Entry'!BS4:BS1001)-ROW('03 Data Entry'!BS4),0)),('03 Data Entry'!BS4:BS1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BS4:BS1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BS4,ROW('03 Data Entry'!BS4:BS1001)-ROW('03 Data Entry'!BS4),0)),('03 Data Entry'!BS4:BS1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BS4:BS1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BS4,ROW('03 Data Entry'!BS4:BS1001)-ROW('03 Data Entry'!BS4),0)),('03 Data Entry'!BS4:BS1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BS4:BS1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BS4,ROW('03 Data Entry'!BS4:BS1001)-ROW('03 Data Entry'!BS4),0)),('03 Data Entry'!BS4:BS1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BS4:BS1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BS4,ROW('03 Data Entry'!BS4:BS1001)-ROW('03 Data Entry'!BS4),0)),('03 Data Entry'!BS4:BS1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BS4:BS1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BS4,ROW('03 Data Entry'!BS4:BS1001)-ROW('03 Data Entry'!BS4),0)),('03 Data Entry'!BS4:BS1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BS4:BS1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BS4:BS1001)","v":0}]
[null,"5. Does the unit document when a peripheral IV is inserted?\n(for example, in the medical record)",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BT4,ROW('03 Data Entry'!BT4:BT1001)-ROW('03 Data Entry'!BT4),0)),('03 Data Entry'!BT4:BT1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BT4:BT1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BT4,ROW('03 Data Entry'!BT4:BT1001)-ROW('03 Data Entry'!BT4),0)),('03 Data Entry'!BT4:BT1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BT4:BT1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BT4,ROW('03 Data Entry'!BT4:BT1001)-ROW('03 Data Entry'!BT4),0)),('03 Data Entry'!BT4:BT1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BT4:BT1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BT4,ROW('03 Data Entry'!BT4:BT1001)-ROW('03 Data Entry'!BT4),0)),('03 Data Entry'!BT4:BT1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BT4:BT1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BT4,ROW('03 Data Entry'!BT4:BT1001)-ROW('03 Data Entry'!BT4),0)),('03 Data Entry'!BT4:BT1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BT4:BT1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BT4,ROW('03 Data Entry'!BT4:BT1001)-ROW('03 Data Entry'!BT4),0)),('03 Data Entry'!BT4:BT1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BT4:BT1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BT4:BT1001)","v":0}]
[null,"6. Is hand hygiene performed before accessing a peripheral IV?\n(medication administration, dressing changes)",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BU4,ROW('03 Data Entry'!BU4:BU1001)-ROW('03 Data Entry'!BU4),0)),('03 Data Entry'!BU4:BU1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BU4:BU1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BU4,ROW('03 Data Entry'!BU4:BU1001)-ROW('03 Data Entry'!BU4),0)),('03 Data Entry'!BU4:BU1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BU4:BU1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BU4,ROW('03 Data Entry'!BU4:BU1001)-ROW('03 Data Entry'!BU4),0)),('03 Data Entry'!BU4:BU1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BU4:BU1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BU4,ROW('03 Data Entry'!BU4:BU1001)-ROW('03 Data Entry'!BU4),0)),('03 Data Entry'!BU4:BU1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BU4:BU1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BU4,ROW('03 Data Entry'!BU4:BU1001)-ROW('03 Data Entry'!BU4),0)),('03 Data Entry'!BU4:BU1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BU4:BU1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BU4,ROW('03 Data Entry'!BU4:BU1001)-ROW('03 Data Entry'!BU4),0)),('03 Data Entry'!BU4:BU1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BU4:BU1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BU4:BU1001)","v":0}]
[null,"7. Is skin antisepsis performed prior to accessing a peripheral IV?",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BV4,ROW('03 Data Entry'!BV4:BV1001)-ROW('03 Data Entry'!BV4),0)),('03 Data Entry'!BV4:BV1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BV4:BV1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BV4,ROW('03 Data Entry'!BV4:BV1001)-ROW('03 Data Entry'!BV4),0)),('03 Data Entry'!BV4:BV1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BV4:BV1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BV4,ROW('03 Data Entry'!BV4:BV1001)-ROW('03 Data Entry'!BV4),0)),('03 Data Entry'!BV4:BV1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BV4:BV1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BV4,ROW('03 Data Entry'!BV4:BV1001)-ROW('03 Data Entry'!BV4),0)),('03 Data Entry'!BV4:BV1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BV4:BV1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BV4,ROW('03 Data Entry'!BV4:BV1001)-ROW('03 Data Entry'!BV4),0)),('03 Data Entry'!BV4:BV1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BV4:BV1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BV4,ROW('03 Data Entry'!BV4:BV1001)-ROW('03 Data Entry'!BV4),0)),('03 Data Entry'!BV4:BV1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BV4:BV1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BV4:BV1001)","v":0}]
[null,"8. Are ports or caps disinfected each time a peripheral IV is accessed?  ",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BW4,ROW('03 Data Entry'!BW4:BW1001)-ROW('03 Data Entry'!BW4),0)),('03 Data Entry'!BW4:BW1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BW4:BW1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BW4,ROW('03 Data Entry'!BW4:BW1001)-ROW('03 Data Entry'!BW4),0)),('03 Data Entry'!BW4:BW1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BW4:BW1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BW4,ROW('03 Data Entry'!BW4:BW1001)-ROW('03 Data Entry'!BW4),0)),('03 Data Entry'!BW4:BW1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BW4:BW1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BW4,ROW('03 Data Entry'!BW4:BW1001)-ROW('03 Data Entry'!BW4),0)),('03 Data Entry'!BW4:BW1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BW4:BW1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BW4,ROW('03 Data Entry'!BW4:BW1001)-ROW('03 Data Entry'!BW4),0)),('03 Data Entry'!BW4:BW1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BW4:BW1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BW4,ROW('03 Data Entry'!BW4:BW1001)-ROW('03 Data Entry'!BW4),0)),('03 Data Entry'!BW4:BW1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BW4:BW1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BW4:BW1001)","v":0}]
[null,"9. Are peripheral IVs flushed with sterile saline after infusion? ",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BX4,ROW('03 Data Entry'!BX4:BX1001)-ROW('03 Data Entry'!BX4),0)),('03 Data Entry'!BX4:BX1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BX4:BX1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BX4,ROW('03 Data Entry'!BX4:BX1001)-ROW('03 Data Entry'!BX4),0)),('03 Data Entry'!BX4:BX1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BX4:BX1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BX4,ROW('03 Data Entry'!BX4:BX1001)-ROW('03 Data Entry'!BX4),0)),('03 Data Entry'!BX4:BX1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BX4:BX1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BX4,ROW('03 Data Entry'!BX4:BX1001)-ROW('03 Data Entry'!BX4),0)),('03 Data Entry'!BX4:BX1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BX4:BX1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BX4,ROW('03 Data Entry'!BX4:BX1001)-ROW('03 Data Entry'!BX4),0)),('03 Data Entry'!BX4:BX1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BX4:BX1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BX4,ROW('03 Data Entry'!BX4:BX1001)-ROW('03 Data Entry'!BX4),0)),('03 Data Entry'!BX4:BX1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BX4:BX1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BX4:BX1001)","v":0}]
[null,"10. Are pre-filled syringes used for saline flushes?   \n(pre-filled with saline from manufacturer)",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BY4,ROW('03 Data Entry'!BY4:BY1001)-ROW('03 Data Entry'!BY4),0)),('03 Data Entry'!BY4:BY1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BY4:BY1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BY4,ROW('03 Data Entry'!BY4:BY1001)-ROW('03 Data Entry'!BY4),0)),('03 Data Entry'!BY4:BY1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BY4:BY1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BY4,ROW('03 Data Entry'!BY4:BY1001)-ROW('03 Data Entry'!BY4),0)),('03 Data Entry'!BY4:BY1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BY4:BY1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BY4,ROW('03 Data Entry'!BY4:BY1001)-ROW('03 Data Entry'!BY4),0)),('03 Data Entry'!BY4:BY1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BY4:BY1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BY4,ROW('03 Data Entry'!BY4:BY1001)-ROW('03 Data Entry'!BY4),0)),('03 Data Entry'!BY4:BY1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BY4:BY1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BY4,ROW('03 Data Entry'!BY4:BY1001)-ROW('03 Data Entry'!BY4),0)),('03 Data Entry'!BY4:BY1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BY4:BY1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BY4:BY1001)","v":0}]
[null,"11. Is IV tubing used for continuous infusions changed every 4 days?",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BZ4,ROW('03 Data Entry'!BZ4:BZ1001)-ROW('03 Data Entry'!BZ4),0)),('03 Data Entry'!BZ4:BZ1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BZ4:BZ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BZ4,ROW('03 Data Entry'!BZ4:BZ1001)-ROW('03 Data Entry'!BZ4),0)),('03 Data Entry'!BZ4:BZ1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BZ4:BZ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BZ4,ROW('03 Data Entry'!BZ4:BZ1001)-ROW('03 Data Entry'!BZ4),0)),('03 Data Entry'!BZ4:BZ1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BZ4:BZ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BZ4,ROW('03 Data Entry'!BZ4:BZ1001)-ROW('03 Data Entry'!BZ4),0)),('03 Data Entry'!BZ4:BZ1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BZ4:BZ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BZ4,ROW('03 Data Entry'!BZ4:BZ1001)-ROW('03 Data Entry'!BZ4),0)),('03 Data Entry'!BZ4:BZ1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BZ4:BZ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BZ4,ROW('03 Data Entry'!BZ4:BZ1001)-ROW('03 Data Entry'!BZ4),0)),('03 Data Entry'!BZ4:BZ1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!BZ4:BZ1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!BZ4:BZ1001)","v":0}]
[null,"12. Is IV tubing used for blood, blood products, or fat emulsions changed every 24 hours?",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CA4,ROW('03 Data Entry'!CA4:CA1001)-ROW('03 Data Entry'!CA4),0)),('03 Data Entry'!CA4:CA1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CA4:CA1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CA4,ROW('03 Data Entry'!CA4:CA1001)-ROW('03 Data Entry'!CA4),0)),('03 Data Entry'!CA4:CA1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CA4:CA1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CA4,ROW('03 Data Entry'!CA4:CA1001)-ROW('03 Data Entry'!CA4),0)),('03 Data Entry'!CA4:CA1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CA4:CA1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CA4,ROW('03 Data Entry'!CA4:CA1001)-ROW('03 Data Entry'!CA4),0)),('03 Data Entry'!CA4:CA1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CA4:CA1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CA4,ROW('03 Data Entry'!CA4:CA1001)-ROW('03 Data Entry'!CA4),0)),('03 Data Entry'!CA4:CA1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CA4:CA1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CA4,ROW('03 Data Entry'!CA4:CA1001)-ROW('03 Data Entry'!CA4),0)),('03 Data Entry'!CA4:CA1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CA4:CA1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!CA4:CA1001)","v":0}]
[null,"13. Are peripheral IVs assessed daily (for example, during patient rounds) to ensure they are still needed?",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CB4,ROW('03 Data Entry'!CB4:CB1001)-ROW('03 Data Entry'!CB4),0)),('03 Data Entry'!CB4:CB1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CB4:CB1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CB4,ROW('03 Data Entry'!CB4:CB1001)-ROW('03 Data Entry'!CB4),0)),('03 Data Entry'!CB4:CB1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CB4:CB1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CB4,ROW('03 Data Entry'!CB4:CB1001)-ROW('03 Data Entry'!CB4),0)),('03 Data Entry'!CB4:CB1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CB4:CB1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CB4,ROW('03 Data Entry'!CB4:CB1001)-ROW('03 Data Entry'!CB4),0)),('03 Data Entry'!CB4:CB1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CB4:CB1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CB4,ROW('03 Data Entry'!CB4:CB1001)-ROW('03 Data Entry'!CB4),0)),('03 Data Entry'!CB4:CB1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CB4:CB1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CB4,ROW('03 Data Entry'!CB4:CB1001)-ROW('03 Data Entry'!CB4),0)),('03 Data Entry'!CB4:CB1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CB4:CB1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!CB4:CB1001)","v":0}]
[null,"14. Are peripheral IVs removed immediately when no longer needed?",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CC4,ROW('03 Data Entry'!CC4:CC1001)-ROW('03 Data Entry'!CC4),0)),('03 Data Entry'!CC4:CC1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CC4:CC1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CC4,ROW('03 Data Entry'!CC4:CC1001)-ROW('03 Data Entry'!CC4),0)),('03 Data Entry'!CC4:CC1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CC4:CC1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CC4,ROW('03 Data Entry'!CC4:CC1001)-ROW('03 Data Entry'!CC4),0)),('03 Data Entry'!CC4:CC1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CC4:CC1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CC4,ROW('03 Data Entry'!CC4:CC1001)-ROW('03 Data Entry'!CC4),0)),('03 Data Entry'!CC4:CC1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CC4:CC1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CC4,ROW('03 Data Entry'!CC4:CC1001)-ROW('03 Data Entry'!CC4),0)),('03 Data Entry'!CC4:CC1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CC4:CC1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CC4,ROW('03 Data Entry'!CC4:CC1001)-ROW('03 Data Entry'!CC4),0)),('03 Data Entry'!CC4:CC1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CC4:CC1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!CC4:CC1001)","v":0}]
[null,"15. Are peripheral IVs checked regularly (for example, every day) for signs of infection? (swelling, redness, induration)",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CD4,ROW('03 Data Entry'!CD4:CD1001)-ROW('03 Data Entry'!CD4),0)),('03 Data Entry'!CD4:CD1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CD4:CD1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CD4,ROW('03 Data Entry'!CD4:CD1001)-ROW('03 Data Entry'!CD4),0)),('03 Data Entry'!CD4:CD1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CD4:CD1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CD4,ROW('03 Data Entry'!CD4:CD1001)-ROW('03 Data Entry'!CD4),0)),('03 Data Entry'!CD4:CD1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CD4:CD1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CD4,ROW('03 Data Entry'!CD4:CD1001)-ROW('03 Data Entry'!CD4),0)),('03 Data Entry'!CD4:CD1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CD4:CD1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CD4,ROW('03 Data Entry'!CD4:CD1001)-ROW('03 Data Entry'!CD4),0)),('03 Data Entry'!CD4:CD1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CD4:CD1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CD4,ROW('03 Data Entry'!CD4:CD1001)-ROW('03 Data Entry'!CD4),0)),('03 Data Entry'!CD4:CD1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CD4:CD1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!CD4:CD1001)","v":0}]
[null,"16. Are peripheral IVs removed promptly when there is sign of infection?",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CE4,ROW('03 Data Entry'!CE4:CE1001)-ROW('03 Data Entry'!CE4),0)),('03 Data Entry'!CE4:CE1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CE4:CE1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CE4,ROW('03 Data Entry'!CE4:CE1001)-ROW('03 Data Entry'!CE4),0)),('03 Data Entry'!CE4:CE1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CE4:CE1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CE4,ROW('03 Data Entry'!CE4:CE1001)-ROW('03 Data Entry'!CE4),0)),('03 Data Entry'!CE4:CE1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CE4:CE1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CE4,ROW('03 Data Entry'!CE4:CE1001)-ROW('03 Data Entry'!CE4),0)),('03 Data Entry'!CE4:CE1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CE4:CE1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CE4,ROW('03 Data Entry'!CE4:CE1001)-ROW('03 Data Entry'!CE4),0)),('03 Data Entry'!CE4:CE1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CE4:CE1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CE4,ROW('03 Data Entry'!CE4:CE1001)-ROW('03 Data Entry'!CE4),0)),('03 Data Entry'!CE4:CE1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CE4:CE1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!CE4:CE1001)","v":0}]
[]
[null,"5. Medication Preparation: Practices"]
[null,null,null,null,null,"Always","Often","Sometimes","Rarely","Never","Do Not Know","# Responses"]
[null,"1. Does a pharmacist review medication prescribed for neonates?",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CF4,ROW('03 Data Entry'!CF4:CF1001)-ROW('03 Data Entry'!CF4),0)),('03 Data Entry'!CF4:CF1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CF4:CF1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CF4,ROW('03 Data Entry'!CF4:CF1001)-ROW('03 Data Entry'!CF4),0)),('03 Data Entry'!CF4:CF1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CF4:CF1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CF4,ROW('03 Data Entry'!CF4:CF1001)-ROW('03 Data Entry'!CF4),0)),('03 Data Entry'!CF4:CF1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CF4:CF1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CF4,ROW('03 Data Entry'!CF4:CF1001)-ROW('03 Data Entry'!CF4),0)),('03 Data Entry'!CF4:CF1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CF4:CF1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CF4,ROW('03 Data Entry'!CF4:CF1001)-ROW('03 Data Entry'!CF4),0)),('03 Data Entry'!CF4:CF1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CF4:CF1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CF4,ROW('03 Data Entry'!CF4:CF1001)-ROW('03 Data Entry'!CF4),0)),('03 Data Entry'!CF4:CF1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CF4:CF1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!CF4:CF1001)","v":0}]
[null,"2. Is medicine prepared in a designated area? (for example, away from potential sources of contamination such as sinks)",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CG4,ROW('03 Data Entry'!CG4:CG1001)-ROW('03 Data Entry'!CG4),0)),('03 Data Entry'!CG4:CG1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CG4:CG1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CG4,ROW('03 Data Entry'!CG4:CG1001)-ROW('03 Data Entry'!CG4),0)),('03 Data Entry'!CG4:CG1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CG4:CG1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CG4,ROW('03 Data Entry'!CG4:CG1001)-ROW('03 Data Entry'!CG4),0)),('03 Data Entry'!CG4:CG1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CG4:CG1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CG4,ROW('03 Data Entry'!CG4:CG1001)-ROW('03 Data Entry'!CG4),0)),('03 Data Entry'!CG4:CG1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CG4:CG1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CG4,ROW('03 Data Entry'!CG4:CG1001)-ROW('03 Data Entry'!CG4),0)),('03 Data Entry'!CG4:CG1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CG4:CG1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CG4,ROW('03 Data Entry'!CG4:CG1001)-ROW('03 Data Entry'!CG4),0)),('03 Data Entry'!CG4:CG1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CG4:CG1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!CG4:CG1001)","v":0}]
[null,"3. Is the medication preparation area cleaned and disinfected regularly? (for example, once a day)",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CH4,ROW('03 Data Entry'!CH4:CH1001)-ROW('03 Data Entry'!CH4),0)),('03 Data Entry'!CH4:CH1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CH4:CH1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CH4,ROW('03 Data Entry'!CH4:CH1001)-ROW('03 Data Entry'!CH4),0)),('03 Data Entry'!CH4:CH1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CH4:CH1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CH4,ROW('03 Data Entry'!CH4:CH1001)-ROW('03 Data Entry'!CH4),0)),('03 Data Entry'!CH4:CH1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CH4:CH1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CH4,ROW('03 Data Entry'!CH4:CH1001)-ROW('03 Data Entry'!CH4),0)),('03 Data Entry'!CH4:CH1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CH4:CH1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CH4,ROW('03 Data Entry'!CH4:CH1001)-ROW('03 Data Entry'!CH4),0)),('03 Data Entry'!CH4:CH1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CH4:CH1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CH4,ROW('03 Data Entry'!CH4:CH1001)-ROW('03 Data Entry'!CH4),0)),('03 Data Entry'!CH4:CH1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CH4:CH1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!CH4:CH1001)","v":0}]
[null,"4. Are supplies accessible where medicines are prepared? (such as alcohol-based hand rub, needles and syringes in sterile packaging, etc.)",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CI4,ROW('03 Data Entry'!CI4:CI1001)-ROW('03 Data Entry'!CI4),0)),('03 Data Entry'!CI4:CI1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CI4:CI1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CI4,ROW('03 Data Entry'!CI4:CI1001)-ROW('03 Data Entry'!CI4),0)),('03 Data Entry'!CI4:CI1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CI4:CI1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CI4,ROW('03 Data Entry'!CI4:CI1001)-ROW('03 Data Entry'!CI4),0)),('03 Data Entry'!CI4:CI1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CI4:CI1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CI4,ROW('03 Data Entry'!CI4:CI1001)-ROW('03 Data Entry'!CI4),0)),('03 Data Entry'!CI4:CI1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CI4:CI1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CI4,ROW('03 Data Entry'!CI4:CI1001)-ROW('03 Data Entry'!CI4),0)),('03 Data Entry'!CI4:CI1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CI4:CI1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CI4,ROW('03 Data Entry'!CI4:CI1001)-ROW('03 Data Entry'!CI4),0)),('03 Data Entry'!CI4:CI1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CI4:CI1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!CI4:CI1001)","v":0}]
[null,"5. Is hand hygiene performed before preparing medication?",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CJ4,ROW('03 Data Entry'!CJ4:CJ1001)-ROW('03 Data Entry'!CJ4),0)),('03 Data Entry'!CJ4:CJ1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CJ4:CJ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CJ4,ROW('03 Data Entry'!CJ4:CJ1001)-ROW('03 Data Entry'!CJ4),0)),('03 Data Entry'!CJ4:CJ1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CJ4:CJ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CJ4,ROW('03 Data Entry'!CJ4:CJ1001)-ROW('03 Data Entry'!CJ4),0)),('03 Data Entry'!CJ4:CJ1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CJ4:CJ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CJ4,ROW('03 Data Entry'!CJ4:CJ1001)-ROW('03 Data Entry'!CJ4),0)),('03 Data Entry'!CJ4:CJ1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CJ4:CJ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CJ4,ROW('03 Data Entry'!CJ4:CJ1001)-ROW('03 Data Entry'!CJ4),0)),('03 Data Entry'!CJ4:CJ1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CJ4:CJ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CJ4,ROW('03 Data Entry'!CJ4:CJ1001)-ROW('03 Data Entry'!CJ4),0)),('03 Data Entry'!CJ4:CJ1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CJ4:CJ1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!CJ4:CJ1001)","v":0}]
[null,"6. Is the rubber diaphragm (vial) or neck (ampoule) disinfected before accessing?",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CK4,ROW('03 Data Entry'!CK4:CK1001)-ROW('03 Data Entry'!CK4),0)),('03 Data Entry'!CK4:CK1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CK4:CK1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CK4,ROW('03 Data Entry'!CK4:CK1001)-ROW('03 Data Entry'!CK4),0)),('03 Data Entry'!CK4:CK1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CK4:CK1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CK4,ROW('03 Data Entry'!CK4:CK1001)-ROW('03 Data Entry'!CK4),0)),('03 Data Entry'!CK4:CK1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CK4:CK1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CK4,ROW('03 Data Entry'!CK4:CK1001)-ROW('03 Data Entry'!CK4),0)),('03 Data Entry'!CK4:CK1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CK4:CK1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CK4,ROW('03 Data Entry'!CK4:CK1001)-ROW('03 Data Entry'!CK4),0)),('03 Data Entry'!CK4:CK1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CK4:CK1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CK4,ROW('03 Data Entry'!CK4:CK1001)-ROW('03 Data Entry'!CK4),0)),('03 Data Entry'!CK4:CK1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CK4:CK1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!CK4:CK1001)","v":0}]
[null,"7. Is the disinfectant allowed to air dry before accessing the vial or ampoule? ",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CL4,ROW('03 Data Entry'!CL4:CL1001)-ROW('03 Data Entry'!CL4),0)),('03 Data Entry'!CL4:CL1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CL4:CL1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CL4,ROW('03 Data Entry'!CL4:CL1001)-ROW('03 Data Entry'!CL4),0)),('03 Data Entry'!CL4:CL1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CL4:CL1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CL4,ROW('03 Data Entry'!CL4:CL1001)-ROW('03 Data Entry'!CL4),0)),('03 Data Entry'!CL4:CL1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CL4:CL1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CL4,ROW('03 Data Entry'!CL4:CL1001)-ROW('03 Data Entry'!CL4),0)),('03 Data Entry'!CL4:CL1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CL4:CL1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CL4,ROW('03 Data Entry'!CL4:CL1001)-ROW('03 Data Entry'!CL4),0)),('03 Data Entry'!CL4:CL1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CL4:CL1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CL4,ROW('03 Data Entry'!CL4:CL1001)-ROW('03 Data Entry'!CL4),0)),('03 Data Entry'!CL4:CL1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CL4:CL1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!CL4:CL1001)","v":0}]
[null,"8. Is a single-dose vial used for only one patient? ",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CM4,ROW('03 Data Entry'!CM4:CM1001)-ROW('03 Data Entry'!CM4),0)),('03 Data Entry'!CM4:CM1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CM4:CM1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CM4,ROW('03 Data Entry'!CM4:CM1001)-ROW('03 Data Entry'!CM4),0)),('03 Data Entry'!CM4:CM1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CM4:CM1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CM4,ROW('03 Data Entry'!CM4:CM1001)-ROW('03 Data Entry'!CM4),0)),('03 Data Entry'!CM4:CM1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CM4:CM1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CM4,ROW('03 Data Entry'!CM4:CM1001)-ROW('03 Data Entry'!CM4),0)),('03 Data Entry'!CM4:CM1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CM4:CM1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CM4,ROW('03 Data Entry'!CM4:CM1001)-ROW('03 Data Entry'!CM4),0)),('03 Data Entry'!CM4:CM1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CM4:CM1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CM4,ROW('03 Data Entry'!CM4:CM1001)-ROW('03 Data Entry'!CM4),0)),('03 Data Entry'!CM4:CM1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CM4:CM1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!CM4:CM1001)","v":0}]
[null,"9. Is a single-dose vial discarded after one use? (even if there is medication left over)",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CN4,ROW('03 Data Entry'!CN4:CN1001)-ROW('03 Data Entry'!CN4),0)),('03 Data Entry'!CN4:CN1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CN4:CN1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CN4,ROW('03 Data Entry'!CN4:CN1001)-ROW('03 Data Entry'!CN4),0)),('03 Data Entry'!CN4:CN1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CN4:CN1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CN4,ROW('03 Data Entry'!CN4:CN1001)-ROW('03 Data Entry'!CN4),0)),('03 Data Entry'!CN4:CN1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CN4:CN1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CN4,ROW('03 Data Entry'!CN4:CN1001)-ROW('03 Data Entry'!CN4),0)),('03 Data Entry'!CN4:CN1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CN4:CN1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CN4,ROW('03 Data Entry'!CN4:CN1001)-ROW('03 Data Entry'!CN4),0)),('03 Data Entry'!CN4:CN1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CN4:CN1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CN4,ROW('03 Data Entry'!CN4:CN1001)-ROW('03 Data Entry'!CN4),0)),('03 Data Entry'!CN4:CN1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CN4:CN1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!CN4:CN1001)","v":0}]
[null,"10. Is a new, sterile needle and syringe used to access a single-dose vial? ",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CO4,ROW('03 Data Entry'!CO4:CO1001)-ROW('03 Data Entry'!CO4),0)),('03 Data Entry'!CO4:CO1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CO4:CO1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CO4,ROW('03 Data Entry'!CO4:CO1001)-ROW('03 Data Entry'!CO4),0)),('03 Data Entry'!CO4:CO1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CO4:CO1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CO4,ROW('03 Data Entry'!CO4:CO1001)-ROW('03 Data Entry'!CO4),0)),('03 Data Entry'!CO4:CO1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CO4:CO1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CO4,ROW('03 Data Entry'!CO4:CO1001)-ROW('03 Data Entry'!CO4),0)),('03 Data Entry'!CO4:CO1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CO4:CO1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CO4,ROW('03 Data Entry'!CO4:CO1001)-ROW('03 Data Entry'!CO4),0)),('03 Data Entry'!CO4:CO1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CO4:CO1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CO4,ROW('03 Data Entry'!CO4:CO1001)-ROW('03 Data Entry'!CO4),0)),('03 Data Entry'!CO4:CO1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CO4:CO1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!CO4:CO1001)","v":0}]
[null,"11. Is a new, sterile needle and syringe used to access a multi-dose vial? ",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CP4,ROW('03 Data Entry'!CP4:CP1001)-ROW('03 Data Entry'!CP4),0)),('03 Data Entry'!CP4:CP1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CP4:CP1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CP4,ROW('03 Data Entry'!CP4:CP1001)-ROW('03 Data Entry'!CP4),0)),('03 Data Entry'!CP4:CP1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CP4:CP1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CP4,ROW('03 Data Entry'!CP4:CP1001)-ROW('03 Data Entry'!CP4),0)),('03 Data Entry'!CP4:CP1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CP4:CP1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CP4,ROW('03 Data Entry'!CP4:CP1001)-ROW('03 Data Entry'!CP4),0)),('03 Data Entry'!CP4:CP1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CP4:CP1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CP4,ROW('03 Data Entry'!CP4:CP1001)-ROW('03 Data Entry'!CP4),0)),('03 Data Entry'!CP4:CP1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CP4:CP1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CP4,ROW('03 Data Entry'!CP4:CP1001)-ROW('03 Data Entry'!CP4),0)),('03 Data Entry'!CP4:CP1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CP4:CP1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!CP4:CP1001)","v":0}]
[null,"12. Are multi-dose vials stored away from the neonate's bedside? (for example, stored in the medication preparation area)",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CQ4,ROW('03 Data Entry'!CQ4:CQ1001)-ROW('03 Data Entry'!CQ4),0)),('03 Data Entry'!CQ4:CQ1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CQ4:CQ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CQ4,ROW('03 Data Entry'!CQ4:CQ1001)-ROW('03 Data Entry'!CQ4),0)),('03 Data Entry'!CQ4:CQ1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CQ4:CQ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CQ4,ROW('03 Data Entry'!CQ4:CQ1001)-ROW('03 Data Entry'!CQ4),0)),('03 Data Entry'!CQ4:CQ1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CQ4:CQ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CQ4,ROW('03 Data Entry'!CQ4:CQ1001)-ROW('03 Data Entry'!CQ4),0)),('03 Data Entry'!CQ4:CQ1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CQ4:CQ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CQ4,ROW('03 Data Entry'!CQ4:CQ1001)-ROW('03 Data Entry'!CQ4),0)),('03 Data Entry'!CQ4:CQ1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CQ4:CQ1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CQ4,ROW('03 Data Entry'!CQ4:CQ1001)-ROW('03 Data Entry'!CQ4),0)),('03 Data Entry'!CQ4:CQ1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CQ4:CQ1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!CQ4:CQ1001)","v":0}]
[null,"13. Are multi-dose vials discarded within their expiration date? (28 days, unless the manufacturer specifies a different expiration date)",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CR4,ROW('03 Data Entry'!CR4:CR1001)-ROW('03 Data Entry'!CR4),0)),('03 Data Entry'!CR4:CR1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CR4:CR1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CR4,ROW('03 Data Entry'!CR4:CR1001)-ROW('03 Data Entry'!CR4),0)),('03 Data Entry'!CR4:CR1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CR4:CR1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CR4,ROW('03 Data Entry'!CR4:CR1001)-ROW('03 Data Entry'!CR4),0)),('03 Data Entry'!CR4:CR1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CR4:CR1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CR4,ROW('03 Data Entry'!CR4:CR1001)-ROW('03 Data Entry'!CR4),0)),('03 Data Entry'!CR4:CR1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CR4:CR1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CR4,ROW('03 Data Entry'!CR4:CR1001)-ROW('03 Data Entry'!CR4),0)),('03 Data Entry'!CR4:CR1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CR4:CR1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CR4,ROW('03 Data Entry'!CR4:CR1001)-ROW('03 Data Entry'!CR4),0)),('03 Data Entry'!CR4:CR1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CR4:CR1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!CR4:CR1001)","v":0}]
[null,"14. Are IV solutions (for example, infusion bags) kept free from needle punctures/spikes?",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CS4,ROW('03 Data Entry'!CS4:CS1001)-ROW('03 Data Entry'!CS4),0)),('03 Data Entry'!CS4:CS1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CS4:CS1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CS4,ROW('03 Data Entry'!CS4:CS1001)-ROW('03 Data Entry'!CS4),0)),('03 Data Entry'!CS4:CS1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CS4:CS1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CS4,ROW('03 Data Entry'!CS4:CS1001)-ROW('03 Data Entry'!CS4),0)),('03 Data Entry'!CS4:CS1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CS4:CS1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CS4,ROW('03 Data Entry'!CS4:CS1001)-ROW('03 Data Entry'!CS4),0)),('03 Data Entry'!CS4:CS1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CS4:CS1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CS4,ROW('03 Data Entry'!CS4:CS1001)-ROW('03 Data Entry'!CS4),0)),('03 Data Entry'!CS4:CS1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CS4:CS1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CS4,ROW('03 Data Entry'!CS4:CS1001)-ROW('03 Data Entry'!CS4),0)),('03 Data Entry'!CS4:CS1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CS4:CS1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!CS4:CS1001)","v":0}]
[null,"15. Is a sterile diluent, such as water or saline in 10mL vials, used to reconstitute a medication? (for example, preparing antibiotic for injection)",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CT4,ROW('03 Data Entry'!CT4:CT1001)-ROW('03 Data Entry'!CT4),0)),('03 Data Entry'!CT4:CT1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CT4:CT1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CT4,ROW('03 Data Entry'!CT4:CT1001)-ROW('03 Data Entry'!CT4),0)),('03 Data Entry'!CT4:CT1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CT4:CT1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CT4,ROW('03 Data Entry'!CT4:CT1001)-ROW('03 Data Entry'!CT4),0)),('03 Data Entry'!CT4:CT1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CT4:CT1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CT4,ROW('03 Data Entry'!CT4:CT1001)-ROW('03 Data Entry'!CT4),0)),('03 Data Entry'!CT4:CT1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CT4:CT1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CT4,ROW('03 Data Entry'!CT4:CT1001)-ROW('03 Data Entry'!CT4),0)),('03 Data Entry'!CT4:CT1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CT4:CT1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CT4,ROW('03 Data Entry'!CT4:CT1001)-ROW('03 Data Entry'!CT4),0)),('03 Data Entry'!CT4:CT1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CT4:CT1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!CT4:CT1001)","v":0}]
[null,"16. Are IV solutions (for example, infusion bags) used only for infusion? (In other words, they are NOT used to dilute or reconstitute medicine.)",null,null,null,{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CU4,ROW('03 Data Entry'!CU4:CU1001)-ROW('03 Data Entry'!CU4),0)),('03 Data Entry'!CU4:CU1001=\"Always\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CU4:CU1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CU4,ROW('03 Data Entry'!CU4:CU1001)-ROW('03 Data Entry'!CU4),0)),('03 Data Entry'!CU4:CU1001=\"Often\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CU4:CU1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CU4,ROW('03 Data Entry'!CU4:CU1001)-ROW('03 Data Entry'!CU4),0)),('03 Data Entry'!CU4:CU1001=\"Sometimes\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CU4:CU1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CU4,ROW('03 Data Entry'!CU4:CU1001)-ROW('03 Data Entry'!CU4),0)),('03 Data Entry'!CU4:CU1001=\"Rarely\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CU4:CU1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CU4,ROW('03 Data Entry'!CU4:CU1001)-ROW('03 Data Entry'!CU4),0)),('03 Data Entry'!CU4:CU1001=\"Never\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CU4:CU1001)), 0)","v":0},{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!CU4,ROW('03 Data Entry'!CU4:CU1001)-ROW('03 Data Entry'!CU4),0)),('03 Data Entry'!CU4:CU1001=\"Do Not Know\")+0))/(_xlfn.AGGREGATE(3,5,'03 Data Entry'!CU4:CU1001)), 0)","v":0},{"$f":"SUBTOTAL(3,'03 Data Entry'!CU4:CU1001)","v":0}]

{"sheet":"06 Lists","index":6,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Respondent Role",null,"Shift",null,"Training",null,"Likert Scale"]
[]
["Physician",null,"Day",null,"A. During hire or orientation",null,"Never"]
["Nurse",null,"Night",null,"B. At least annually",null,"Rarely"]
["Nurse Technician",null,"Both",null,"C. When there are new devices or protocols",null,"Sometimes"]
["IPC Professional",null,null,null,"A and B",null,"Often",null,null,null,"Section 2A, question 6",{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!V4,ROW('03 Data Entry'!V4:V1001)-ROW('03 Data Entry'!V4),0)),('03 Data Entry'!V4:V1001=\"Do not perform this procedure\")+0)), 0)","v":0}]
["Pharmacist",null,null,null,"A and C",null,"Always",null,null,null,"Section 2A, question 7",{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!W4,ROW('03 Data Entry'!W4:W1001)-ROW('03 Data Entry'!W4),0)),('03 Data Entry'!W4:W1001=\"Do not perform this procedure\")+0)), 0)","v":0}]
["Other",null,null,null,"B and C",null,"Do Not Know"]
[null,null,null,null,"A, B and C",null,null,null,null,null,"Section 4A, question 2",{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BK4,ROW('03 Data Entry'!BK4:BK1001)-ROW('03 Data Entry'!BK4),0)),('03 Data Entry'!BK4:BK1001=\"Do not perform this procedure\")+0)), 0)","v":0}]
[null,null,null,null,"Never trained",null,null,null,null,null,"Section 4A, question 3",{"$f":"IFERROR((SUMPRODUCT(SUBTOTAL(3,OFFSET('03 Data Entry'!BL4,ROW('03 Data Entry'!BL4:BL1001)-ROW('03 Data Entry'!BL4),0)),('03 Data Entry'!BL4:BL1001=\"Do not perform this procedure\")+0)), 0)","v":0}]
[null,null,null,null,"Do not perform this procedure"]
[]
[]
[]
[]
["Yes/No",null,"Yes/No/DNK",null,"Yes/No/DNK/No Training"]
[]
["Yes",null,"Yes",null,"Yes"]
["No",null,"No",null,"No"]
[null,null,"Do Not Know",null,"Do Not Know"]
[null,null,null,null,"Did not receive training"]