{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Survey","engine","Results"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Survey","index":0,"n_rows":56,"n_cols":6,"rows_kept":56,"cut":false,"hidden":false,"merged":[[34,0,34,5],[47,0,47,5],[0,0,0,5],[4,0,4,5],[17,0,17,5],[2,0,2,5],[1,0,1,5]]}
["Automation within your hospital"]
["Self assessment"]
["How? Mark your level for each subcategory by ticking the Box, in the results section tab the results will appear."]
["Subcategory","Level 1","Level 2","Level 3","Level 4","Level 5"]
["Part 1 Automation"]
["General Statement","No automation is employed.","Machines spot a few problems and do a few basic repetitive tasks.","Machines spot various problems and do some repetitive tasks.","Machines spot most problems and do most repetitive tasks.","Machines spot almost all problems and do all repetitive tasks."]
["Mark your level by ticking the box"]
["Repackaging of oral solids  (applicable in case not provided by manufacturer or 3rd party) ","No repackaging. 0% of beeds are suplied","Manual repackaging.  Repackaging into unit dose (patient-specific and/or patient non-specific). 25% of beds are suplied","Semi-automated repackaging.  Repackaging into unit dose (patient-specific and/or patient non-specific). 26-50% of beds are suplied","Stand-alone packagers. 51-75% of beds are suplied","Fully automated repackaging (incl. deblistering and wrapping). More than 75% of beds are suplied"]
["Mark your level by ticking the box"]
["Preparation (sterile products)","Manually (incl. some very limited semi-automation e.g. usage of a TPN compounder).","Semi-automated technology (without gravimetric/volumetric).","Semi-automated technology with additional control (gravimetric/volumetric).","Automated robotics with some manual control requirements.","Everything is automated with robotics."]
["Mark your level by ticking the box"]
["Inpatient Dispensing (non-sterile products) ","Non-sterile doses are dispensed in <10% of wards that are supported with automation and almost all doses are dispensed using manual preparation by technicians and visual checks by pharmacists. Data on actual or potential dispensing errors must be collected and evaluated manually.","Non-sterile doses are dispensed in 11–25% of wards using some form of automation  (e.g., robots, carousels). Those that are not dispensed from automation require manual picking and human checking. Some data on actual or potential dispensing errors are captured through automation, but much must be collected and evaluated manually.","Non-sterile doses are dispensed in 26–50% of wards using some form of automation (e.g., robots, carousels). Those that are not dispensed from automation require manual picking and human checking. Much of the data on actual or potential dispensing errors are captured through automation, but some must be collected and evaluated manually. ","Non-sterile doses are dispensed in 51-75% of  wards from automated devices (e.g., robots, carousels). Those that are not dispensed from automation are largely dispensed and checked using barcode verification. The majority of data on actual or potential dispensing errors are captured through automation, but some must still be collected and evaluated manually. Scanning of packs is performed in order to trace and trace each item and ensure that the right medicine gets to the right patient.","Non-sterile doses dispensed in >75% of wards from automated devices (e.g., robots, carousels). Those that are not dispensed from automation are dispensed and checked using barcode verification. Virtually all data on dispensing errors are captured through automation or barcode systems, and reports are generated automatically and provided to managers."]
["Mark your level by ticking the box"]
["Medication Management on the Ward","Manual tracking of controlled drugs meets regulatory requirements.  No visibility into ward stock inventory levels for non-controlled drugs.  Replenishment is paper based ordering.  Wards stock medications are stored in open shelves, carts, manual cabinets, etc.","All ward stock locations  replenish their medications via electronic ordering with no perpetual inventory level visibility.  Re-order quantities are based on human decisions.  Most medications stored in open shelves, carts, manual cabinets, etc.","All ward stock locations replenish their medications via electronic ordering systems with accurate real time perpetual inventory level visibility.  Re-order quantities are based on electronic par level re-order points.  Most medications stored in open shelves, carts, manual cabinets, etc. ","Automated storage technology deployed in some ward locations (e.g. intensive care unit, etc.).  Other limited remaining ward stock locations not using ADC’s replenish their medications via electronic ordering systems with accurate real time perpetual inventory level visibility.  Re-order quantities are based on electronic par level re-order points.   ","Automated storage technology deployed in all ward locations to manage all ward stock maintained on the ward. Perpetual real time inventory visibility 100% accurate with closed secured management."]
["Mark your level by ticking the box"]
["Outpatient Dispensing (non-sterile) - if applicable original pack dispensing ","Inability to transfer information.  (e.g., (1) Manual paper based prescriptions, (2) Lack of technology to dispense prescriptions; virtually all dispensing done manually, with <10% dispensed by automation; (3) Inability to have image of final dispensed product during verification or to verify using technology (barcoding); (4) If applicable, adherence packaging dispensing is fully manual and requires human checking).","Limited ability to transfer information  (e.g., (1) Limited e-prescriptions, (2) Ability to use technology to dispense 11–25% of prescriptions; (3) Ability to have image of final dispensed product during verification or to verify using technology (barcoding) for 11–25% of prescriptions; (4) If applicable, adherence packaging dispensing is semi-automated and requires human checking).","Moderate ability to transfer information.  (e.g., (1) Mostly e-prescriptions,  (2) Ability to utilize technology to dispense 26–50% of prescriptions; (3) Ability to have image of final dispensed product during verification or to verify using technology (barcoding) for 26–50% of prescriptions; (4) if applicable, adherence packaging dispensing is semi-automated and requires human checking).","Significant ability to transfer information.  (e.g., (1) Ability to utilize technology to dispense 51–75% of prescriptions; (2) Ability to utilize digital imaging of final dispensed product to automate verification or to verify using technology (barcoding) for 51–75% of prescriptions; (3) If applicable, adherence packaging dispensing is largely automated and does not require human checking).","Complete ability to transfer information.  (e.g., (1) Ability to utilize technology to dispense >75% of prescriptions; (2) Ability to utilize digital imaging of final dispensed product to automate verification or to verify using technology (bar-coding) for >75% of prescriptions; (3) if applicable, adherence packaging dispensing is fully automated and does not require human checking).  Filled prescriptions available to patients 24 hours a day utilizing Kiosk storage systems to accurately identify patients, capture charging, and provide optional virtual pharmacist consultation capabilities."]
["Mark your level by ticking the box"]
["Part 2 Governance of Data and Interoperability"]
["Master data set up ","Master data not organised without a proper infraestrcuture. Working with pharmacy","Master data with some aditional information. Meta system in the pharmacy data on different hospitals and you know what medication is needed. Medication list for each different hospitals. Pharmacy + suppliers","This could be intrasystem (we talk about one hospital) and here is important to have in mind the close-loop medication mangement. Each hospital has different systems for the different wards. Pharmacy +suppliers+ institutional clients GDP","Microsystem done within one system/platform. The data of the different nurses working in the station and you need to have the data of the patients and the data of the medicines dispensed. Monitoring of the drugs administered. Close loop medication aministration. Pharmacy +suppliers+ institutional clients & department+ GDP+ Good Pharmacy Practice (GPP)","The different components of the system should be interlinking with each other and you have some sort of mutual recognition. Recognition of the patient that has got the medicine. Documentation of the administration of the medication (e.g nurses giving the medicine to the patient, thus compelte documentation). All systems connect to each other. Biderectional connectivity between all different systems. Pharmacy +suppliers+ GDP+ institutional clients & department+ Good Pharmacy Practice (GPP)+ GMP"]
["Mark your level by ticking the box"]
["IT Infrastructure ","A few stand alone information systems related to medication use process exist.  There are no interface capabilities between systems.  Systems data accesibility (change this all levels, change visibility by access) is very limited.","Electronic health records (EHRs), pharmacy IT systems, and some medication automation solutions exists.  Systems are minimally integrated within the hospital.  There is some data across wards or business units. ","Electronic health records (EHRs) and pharmacy IT systems are integrated with custom interfaces to some medication automation solutions.   Hospital network standards of interfacing/interoperability are in place. Data can be accessed across hospital.","EHRs with pharmacy systems are seamlessly coupled to many automation solutions using  international standards of interfacing/interoperability.  Relevant data can be accessed across the healthcare system.","All IT systems and platforms are completely integrated within a cloud based infrastructure.  All relevant date can be accessed across the country healthcare ecosystem."]
["Mark your level by ticking the box"]
["Data Intelligence ","Ad hoc descriptive reports are generated separately within each system.","Routine descriptive reports across the individual facility for logistics or clinical data review are scheduled to generate at defined intervals for review.","Routine descriptive reports across the entire health care system for logistics or clinical data review are scheduled to generate at defined intervals for review.","Routine predictive reports across the entire health care system for logistics or clinical data review are scheduled to generate at defined intervals for review. ","Routine prescriptive reports across the entire health care system for logistics or clinical data review are scheduled to generate at defined intervals for review. "]
["Mark your level by ticking the box"]
["Financial Management","Stakeholders create budgets and reports within their own proprietary systems.  Financial status is not provided in a comprehensive view.","Most budgets and financial reports remain unstandardized, with only a limited number sharing identical formats and reporting on comparable values.","Most budgets and reports are produced using the same methods enabling financial information to be aggregated and trends to be visible across the individual hospital.","Most budgets and financial reports are specific views of completely integrated financial information that allows for accurate financial projections covering several years across the healthcare system.","All budgeting is derived from actionable advice based on prior performance, and all financial reporting is automated using tools that make it easy to modify and extend financial management at any time across the healthcare system."]
["Mark your level by ticking the box"]
["Procurement","Stakeholders order, receive, and deploy capital-intensive business products and services in isolation from each other.  Information is only shared when procurement problems arise.","Most procurement activities occur in isolation.  In limited cases the procurement of capital intensive products and services are subject to additional data collection so that earlier warnings of procurement problems are visible.","Most procurement activities for capital intensive products and services are structured to enable market wide comparative cost analyses.  Capabilities to forecast procurement problems is limited.","Almost all procurement activities are highly structured to enable near complete market-wide cost transparency allowing for accurate prediction of critical procurement issues.","Stakeholders have complete cost information for all capital-intensive procurement.  Granular information is available real time and easy to manage.  End-to-end procurement management capabilities are  complemented by actionable advice from the procurement system."]
["Mark your level by ticking the box"]
["Order review (incl. clinical decision support)","Patient-level medication orders are not reviewed.","Patient-level medication orders are reviewed during limited pharmacy operational hours with our without aid of clinical decision support systems. Retrospective review of orders already administered does not occur.","Patient-level medication orders are reviewed during limited pharmacy operational hours with aid of clinical decision support systems. Retrospective review of orders already administered does occur.","All patient-level medication orders are reviewed prior to administration with the aid of clinical decision support systems.","All patient-level medication orders are digitally reviewed with the help of clinical decision support prior to administration automatically based on algorithms and machine learning.  Human intervention is automatically targeted to high risk scenarios."]
["Mark your level by ticking the box"]
["CPOE (incl. clinical decision support)","Structured patient level electronic data about medication and other medical products do not exist.","Limited prescription data is captured electronically in a structured manner.  No clinical decision support is offered.","Most prescription data is captured electronically in a structured manner. Limited clinical decision is offered.","All prescription data is captured electronically in a structured manner.  Full clinical decision support is offered. CPOE links to patient data, lab data, etc.","All prescription data is captured electronically in a structured manner.  Full clinical decision support is offered. CPOE links to patient data, lab data, etc.  Automated alternative therapies are offered when drug interactions and contraindications are identified."]
["Mark your level by ticking the box"]
["Medication Administration records","Medication administration records are maintained on manual paper based systems.  New orders, change orders, and discontinued orders are transcribed manually onto the record.  Medication administration transactions are documented on the manual record.","Medication administration records are maintained on an electric medication record (e-MAR) on some wards.  New orders, change orders, and discontinued orders are reflected real time on the e-MAR.  Medication administration transactions are documented electronically on the e-MAR.","Medication administration records are maintained on a electric medication record (e-MAR) on most wards.  New orders, change orders, and discontinued orders are reflected real time on the e-MAR.  Medication administration transactions are documented electronically on the e-MAR.","Medication administration records are maintained on and electric medication record (e-MAR) on all wards.  New orders, change orders, and discontinued orders are reflected real time on the e-MAR.  Medication administration transactions are documented electronically with bar-code scan verification on the e-MAR on most wards for most medications.","A closed loop system for medication administration is fully implemented for all types of wards, incl. specialized wards and all of medicines. The administration is captured electronically in real time for all patients with bar-code scan. The data electronically captured data is linked to the order. The system automatically updates stock management information in the pharmacy."]
["Mark your level by ticking the box"]
["Part 3 Project management"]
["Overview Summary.This in the intro   ","Level 1: Initial Process\nThere are not established practices or standards, and individual project managers are not held to specific accountability by any process standards. Documentation is loose and ad hoc. Metrics are informally collected on an ad hoc basis. ","Level 2: Structured Process and Standards\nDocumentation exists on these basic processes but it is not standardized. Functional management is involved in the project management of larger, more visible projects, and these are typically executed in a systematic fashion. There are basic metrics to track project cost, schedule, and technical performance, although data may be collected/correlated manually. Information available for managing the project is often a mix between summary level data, and detailed level data.","Level 3: Organizational Standards and Institutionalized Process\nProcesses involve the different hospitals' stakeholders (e.g. pharmacy, IT departement, nurses) as active and integral members of the project team. Management has institutionalized the processes and standards with formal documentation existing on all processes and standards. Nearly all projects use these processes with minimal exception. Some project management tools and applications are used. Structured electronic data is collected regarding major projects.","Level 4: Managed Process\nProjects are managed with consideration to how the project performed in the past and what is expected for the future. Management uses efficiency and effectiveness metrics to make decisions regarding the project and understands the impacts on other projects. All projects, changes, and issues are evaluated based upon metrics from cost estimates, baseline estimates, and earned value.  Project management tools and applications are used in every project. Structured electronic data is collected regarding all projects.","Level 5: Optimizing Process\nManagement and the organization are not only focused on effectively managing projects but also on continuous improvement. Project management processes and standards are integrated with other corporate processes and systems. Project information is integrated with other corporate systems to optimized business decisions."]
["Overview Summary.This in the intro   "]
["Governance ","Project roles not formally appointed.  Delivery activities, documentation, planning, escalation structure, and communication plan do not exist.  Little engagement with vendor.","Project manager is appointed to each project, but the project manager has not recevied any specific training. No other stakeholders are identified formally.  Basic planning is performed without assigned accountability or communication plan.  Escalation route may exist informally.","Project manager is identified as part-time role and has received some training. Project plan exists but it is not always updated.  Project team members are allocated to project tasks. As needed steering board meetings exist.","Full time, trained, dedicated project manager and key stakeholder are assigned regarding major projects. Project plan and status is updated real-time.  Resource allocation is maintained. Regular Steering Board meetings.","Full time, trained, dedicated project manager and key stakeholder are assigned to all projects already at the planning phase. All stakeholders are engaged and have an opportunity to contribute. Project Management Professional (PMP) or country specific required standards are adopted to deliver the project.  "]
["Mark your level by ticking the box"]
["Outcomes","No business case to measure against KPIs.","Business case exists however not considered during planning and not re-visited or measured after implementation.  No KPIs are measured.","Business case is considered during planning.  Some ROI and success measurement performed. Some KPIs requiring minimal effort are measured.","Business case KPIs agreed during deployment and measurement is planned.  Business case re-visited when changes arise and effect on outcomes evaluated.  All ROI and success is measured and promoted internally.  Case studies are created. All of the KPIs are measured.","Business case KPIs agreed during formation of project and measurement is planned and resourced at the onset. Case studies created and independently verified, reporting on success of the delivery. (e.g. professional journals).  All KPIs measured, scrutinized, and actions taken for continuous improvement."]
["Mark your level by ticking the box"]
["Project Deployment Budget ","No assigned budget for delivery.  Spending not monitored.","Budget is agreed as part of business case, but not monitored during delivery.","A budget is agreed at the onset or as part of the business case and some attempt to keep track of costs against plan are made.  Limited focus by the steering board on budget.","Budget agreed and actual costs are captured to a good degree of accuracy.  Steering board takes an active interest in the costs and remediation plans are requested in real time.","Actual costs vs budget are reviewed at scheduled intervals. Contingency budget assigned and managed as per PMP recommendations/standards.  "]
["Mark your level by ticking the box"]
["Supporting Systems","No project planning or project management tool in use.","Planning performed on Excel.\nNo other collaborative tools in place.","MS Project or equivalent is used for planning.  The communications plan is clear.   No collaboration functionality is present and/or leveraged.","Project management tool is employed for planning and collaborative working.   Enhanced functionality and integration is not present or is not being used.  \n\n","Adaptive project management tool or purpose built project management tool is employed.  Continuous delivery in making data-driven decisions on project plan allocations and revisions is automated.                                    \nThe deployment is wide-spread and all project deployment business activity must take place through the tool.  Full adoption across all departments. Integrated with other systems."]
["Mark your level by ticking the box"]
["Training of Users for each dedicated automated system ","Staff self trained by using the live system.  No training offered by the vendor.  No training plan identified.  No assessments performed.","Training dates are identified, but detailed plans of who, how and when are not made.  Identification of expert(s) from the pharmacy are trained and carry out training.   Vendor shares written training information.","Formal training plan is defined with trainees identified and informed. Training of staff is provided by the vendor. Support by vendor in working time.  After initial deployment new hires are trained on the job with no training script.  No follow-up compliance or refresher training exists. Online e-learning resources made available.  ","Trainee assessments completed and trainee certificates issued.  Support (24/7) by vendor.  After initial deployment new hires are trained on the job with a training script.\n","Refresher training and compliance training defined as standard to maintain skill and knowledge levels.\n\n"]
["Mark your level by ticking the box"]
["Part 4 Workforce Allocation"]
["Documentation","All documentation fully paper based","All documentation fully electronically,               no interfaces to equipment","All documentation fully electronically with unidirectional interfaces from process equipment to integrate relevent operational parameters","All documentation fully electronically with bidirectional interfaces to process equipment to exchange all opertional parameters and settings","All documentation runs fully electronically with bidirectional interfaces to equipment incl. Monotoring-, QC-Modules to exchange all opertional parameters and settings. Base for electronic release automatically requested by QA."]
["Mark your level by ticking the box"]
["Core competencies of pharmaceutical staff","Staff is focusing only on manufacturing activities and logistics within the pharmacy.","Staff is joining planning meetings with physicians and care unit and cares for the drug stock on the ward","Staff is joining tumour boards and integrated into therapy decisions and cares for the drug supply of the patients","Staff fully covers manufacturing and clinical aspects and is fully accepted partner for physicians. Patients are trained by pharmacists in handling drugs  before they are leaving the hospital. ","Pharmacists are working on the ward covering all pharmaceutical aspects, fully automated, validated manufacturing process is mainly supervised by technical stuff with the required input from the pharmacist, available systems for clinical decisions. Patients are trained by pharmacists in handling drugs with using digital tools before they are leaving the hospital. "]
["Mark your level by ticking the box"]
["Planning and time recording","Planning and record of time stamp fully paper based without transparent visualization.","Planning of staff is visualized on a clipboard using flexible elements which can be easily moved. Situation is discussed during an huddle and/or send to employees by photo onto the smartphone.  Presence time is recorded manually.","Planning of staff is done by an intelligent table calculation program and send to employees by email.  Project specific automated recording of presence time in correlation to specific task (dispensing, Clinical Services e.g.) for some of staff.","Planning of Staff is done by a professional Software package covering competencies and absences. Results are displayed on a central flat screen located in the department and send to the individual smartphones. Project specific automated recording of presence time in correlation to specific task (dispensing, Clinical Services e.g.) for all staff.","Fully automated system that proposes required human capacity in correlation to the demand using interfaces to ERP-software. Results are communicated to the staff by App with individual time dependend activity table. Project specific automated recording of presence time in correlation to specific task (dispensing, Clinical Services e.g.) for all staff. Intelligent evaluation of planned and invested working time for optimization of staff deployment over all working shifts. "]
["Mark your level by ticking the box"]
["Staff education (tools and processes)","Staff education processes are fully paper based, unautomated and not linked. ","Staff education processes are minimally linked and automated using a spreadsheet software.  Staff training is created and deployed manually as non interactive front presentation. Compliance is also tracked using  spreadsheet rules administetered by a pharmacist.  Staff members do not have access to their compliance data.","Staff education processes are moderately automated by a spreadsheet manager.  Job description is broken down in education modules linked to the staff. Compliance is also tracked using  spreadsheet rules administetered by a pharmacist.  Staff members do not have access to their compliance data.  Training incorporates learning guides and validation of knowledge.","Staff education processes are mostly automated. Job description is broken down in education modules linked to the staff.  Compliance is tracked electronically and stored in the cloud.  Department leaders have access to dashboards showing the current status of required training.  Staff members have access to their compliance data and receive automated reminders of training that has not yet been completed.  All areas of a specific training department are covered to ensure a through and hands-on approach to gain knowledge about the entire process for medication management.  Education focuses on needs in the domains to which the trainee will be working.","Staff education processes are fully automated.  Education modules are created and deployed digitally on an annual basis.  Administration and staff are automatically notified of completion and non-compliance, and dashboards show the current status across the department.  The excution status of electronic sessions can be checked, new modules proposed and directly initiated from the dashboard. All users are given the base knowledge of all systems involved in patient care.  Each trainee receives advanced training in the core area of their job. The training also entails detailed review of the individual’s specific role.  If the users signs any activity in a software module, e.g. electronic batch record, the system checks that the necessary training has been performed."]
["Mark your level by ticking the box"]

{"sheet":"engine","index":1,"n_rows":187,"n_cols":14,"rows_kept":187,"cut":false,"hidden":true,"merged":[]}
[true,true,false,false,false,null,{"$f":"IF(A1=TRUE, 1,0)","v":1},{"$f":"IF(B1=TRUE, 2,0)","v":2},{"$f":"IF(C1=TRUE, 3,0)","v":0},{"$f":"IF(D1=TRUE, 4,0)","v":0},{"$f":"IF(E1=TRUE, 5,0)","v":0},{"$f":"SUM(G1:K1)","v":3},null,{"$f":"CELL(\"address\", INDEX(L1:L6, MATCH(MIN(L1:L6),L1:L6, 0)))","v":"$L$2"}]
[true,false,false,false,false,null,1,0,0,0,0,{"$f":"SUM(G2:K2)","v":1},null,{"$f":"CELL(\"address\", INDEX(L1:L6, MATCH(MAX(L1:L6),L1:L6, 0)))","v":"$L$4"}]
[true,false,false,false,false,null,1,0,0,0,0,1,null,{"$f":"CELL(\"address\", INDEX(L7:L14, MATCH(MIN(L7:L14),L7:L14, 0)))","v":"$L$8"}]
[false,false,false,false,true,null,0,0,0,0,5,5,null,{"$f":"CELL(\"address\", INDEX(L7:L14, MATCH(MAX(L7:L14),L7:L14, 0)))","v":"$L$7"}]
[true,false,false,false,false,null,1,0,0,0,0,1,null,{"$f":"CELL(\"address\", INDEX(L15:L20, MATCH(MIN(L15:L20),L15:L20, 0)))","v":"$L$15"}]
[true,false,false,false,false,null,1,0,0,0,0,1,{"$f":"AVERAGE(L1:L6)","v":2},{"$f":"CELL(\"address\", INDEX(L15:L20, MATCH(MAX(L15:L20),L15:L20, 0)))","v":"$L$17"}]
[false,false,false,false,true,null,0,0,0,0,5,5,null,{"$f":"CELL(\"address\", INDEX(L21:L24, MATCH(MIN(L21:L24),L21:L24, 0)))","v":"$L$21"}]
[true,false,false,false,false,null,1,0,0,0,0,1,null,{"$f":"CELL(\"address\", INDEX(L21:L24, MATCH(MAX(L21:L24),L21:L24, 0)))","v":"$L$23"}]
[true,false,false,false,false,null,1,0,0,0,0,1]
[true,false,false,false,false,null,1,0,0,0,0,1]
[true,false,false,false,false,null,1,0,0,0,0,1]
[true,false,false,null,null,null,1,0,0,0,0,{"$f":"SUM(G12:K12)","v":1}]
[true,null,null,null,null,null,1,0,0,0,0,1]
[true,false,false,false,false,null,1,0,0,0,0,1,{"$f":"AVERAGE(L7:L14)","v":1.5}]
[true,false,false,false,false,null,1,0,0,0,0,1]
[true,false,false,null,false,null,1,0,0,0,0,1]
[false,false,false,false,true,null,0,0,0,0,5,5]
[true,false,null,false,null,null,{"$f":"IF(A18=TRUE, 1,0)","v":1},{"$f":"IF(B18=TRUE, 2,0)","v":0},{"$f":"IF(C18=TRUE, 3,0)","v":0},{"$f":"IF(D18=TRUE, 4,0)","v":0},{"$f":"IF(E18=TRUE, 5,0)","v":0},{"$f":"SUM(G18:K18)","v":1}]
[true,false,false,false,false,null,1,0,0,0,0,1]
[true,false,false,null,false,null,1,0,0,0,0,1,{"$f":"AVERAGE(L15:L20)","v":1.6666666666666667}]
[true,false,false,false,false,null,1,0,0,0,0,1]
[true,false,false,null,false,null,1,0,0,0,0,1]
[false,false,false,null,true,null,0,0,0,0,5,5]
[true,null,false,false,null,null,1,0,0,0,0,1,{"$f":"AVERAGE(L21:L24)","v":2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,false]

{"sheet":"Results","index":2,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,0,1,4],[10,3,10,5],[14,1,14,2],[13,0,13,4],[38,0,38,4],[3,0,4,4],[3,6,4,6],[5,6,6,6],[15,0,15,4],[22,0,22,4],[31,0,31,4]]}
[]
["Find below the results of your assesment and the next level you can work on"]
[]
["Summary",null,null,null,null,null,"Legend"]
[]
[null,"Level","Level of development","Best Scoring Area","Lowest Scoring Area",null,"Level 1 to 2 = starting \nLevel 2 to 3 =  progress\nLevel 3 to 4 = advanced\nLevel 4 and higher = master"]
["1. Automation ",{"$f":"engine!M6","v":2},{"$f":"_xlfn.IFS(B7<1, \"error\", B7<=2, \"starting\", B7<=3, \"in progress\", B7<=4, \"advanced\", B7>4, \"master\")","v":"starting"},{"$f":"CONCATENATE(\n    IF(engine!N2=\"$L$1\", A17, \"\"),\n    IF(engine!N2=\"$L$2\", A18, \"\"),\n    IF(engine!N2=\"$L$3\", A19, \"\"),\n    IF(engine!N2=\"$L$4\", A20, \"\"),\n    IF(engine!N2=\"$L$5\", A21, \"\"),\n    IF(engine!N2=\"$L$6\", A22, \"\")\n)","v":"Inpatient Dispensing (non-sterile products) "},{"$f":"CONCATENATE(\n    IF(engine!N1=\"$L$1\", A17, \"\"),\n    IF(engine!N1=\"$L$2\", A18, \"\"),\n    IF(engine!N1=\"$L$3\", A19, \"\"),\n    IF(engine!N1=\"$L$4\", A20, \"\"),\n    IF(engine!N1=\"$L$5\", A21, \"\"),\n    IF(engine!N1=\"$L$6\", A22, \"\")\n)","v":"Repackaging of oral solids  (applicable in case not provided by manufacturer or 3rd party) "}]
["2. Governance of Data and Interoperability",{"$f":"engine!M14","v":1.5},{"$f":"_xlfn.IFS(B8<1, \"error\", B8<=2, \"starting\", B8<=3, \"in progress\", B8<=4, \"advanced\", B8>4, \"mastered\")","v":"starting"},{"$f":"CONCATENATE(\n    IF(engine!N4=\"$L$7\",A24, \"\"),\n    IF(engine!N4=\"$L$8\",A25, \"\"),\n    IF(engine!N4=\"$L$9\",A26, \"\"),\n    IF(engine!N4=\"$L$10\",A27, \"\"),\n    IF(engine!N4=\"$L$11\",A28, \"\"), IF(engine!N4=\"$L$12\",A29, \"\"), IF(engine!N4=\"$L$13\",A30, \"\"), IF(engine!N4=\"$L$14\",A31, \"\"),\n)","v":"Master data set up "},{"$f":"CONCATENATE(\n    IF(engine!N3=\"$L$7\",A24, \"\"),\n    IF(engine!N3=\"$L$8\",A25, \"\"),\n    IF(engine!N3=\"$L$9\",A26, \"\"),\n    IF(engine!N3=\"$L$10\",A27, \"\"),\n    IF(engine!N3=\"$L$11\",A28, \"\"), IF(engine!N3=\"$L$12\",A29, \"\"), IF(engine!N3=\"$L$13\",A30, \"\"), IF(engine!N3=\"$L$14\",A31, \"\"),\n)","v":"IT Infrastructure "}]
["3. Project Management",{"$f":"engine!M20","v":1.6666666666666667},{"$f":"_xlfn.IFS(B9<1, \"error\", B9<=2, \"starting\", B9<=3, \"in progress\", B9<=4, \"advanced\", B9>4, \"mastered\")","v":"starting"},{"$f":"CONCATENATE(\n    IF(engine!N6=\"$L$15\",A33, \"\"),\n    IF(engine!N6=\"$L$16\",A34, \"\"),\n    IF(engine!N6=\"$L$17\",A35, \"\"),\n    IF(engine!N6=\"$L$18\",A36, \"\"),\n    IF(engine!N6=\"$L$19\", A37, \"\"),    IF(engine!N6=\"$L$20\", A38, \"\"),\n)","v":"Outcomes"},{"$f":"CONCATENATE(\n    IF(engine!N5=\"$L$15\",A33, \"\"),\n    IF(engine!N5=\"$L$16\",A34, \"\"),\n    IF(engine!N5=\"$L$17\",A35, \"\"),\n    IF(engine!N5=\"$L$18\",A36, \"\"),\n    IF(engine!N5=\"$L$19\", A37, \"\"),    IF(engine!N5=\"$L$20\", A38, \"\"),\n)","v":"Overview Summary.This in the intro   "}]
["4. Workforce Allocation",{"$f":"engine!M24","v":2},{"$f":"_xlfn.IFS(B10<1,\"error\",B10<=2,\"starting\",B10<=3,\"in progress\",B10<=4,\"advanced\",B10>4,\"mastered\")","v":"starting"},{"$f":"CONCATENATE(\n    IF(engine!N8=\"$L$21\",A40, \"\"),\n    IF(engine!N8=\"$L$22\",A41, \"\"),\n    IF(engine!N8=\"$L$23\",A42, \"\"),\n    IF(engine!N8=\"$L$24\", A43, \"\"),\n)","v":"Planning and time recording"},{"$f":"CONCATENATE(\n    IF(engine!N7=\"$L$21\",A40, \"\"),\n    IF(engine!N7=\"$L$22\",A41, \"\"),\n    IF(engine!N7=\"$L$23\",A42, \"\"),\n    IF(engine!N7=\"$L$24\", A43, \"\"),\n)","v":"Documentation"}]
["Total score",{"$f":"AVERAGE(B7:B10)","v":1.7916666666666667},{"$f":"_xlfn.IFS(B11<1, \"error\", B11>=2, \"starting\", B11<=3, \"in progress\", B11<=4, \"advanced\", B11>4, \"mastered\")","v":"in progress"}]
[]
[]
["Full overview "]
[null,"Level at the moment",null,"Current level description","Next level you can work towards"]
["Part 1 Automation"]
["General Statement",{"$f":"IF(engine!G1=1,\"level 1\",\"\") & IF(engine!H1=2,\"level 2\",\"\") & IF(engine!I1=3,\"level 3\",\"\") & IF(engine!J1=4,\"level 4\",\"\") & IF(engine!K1=5,\"level 5\",\"\")","v":"level 1level 2"},{"$f":"_xlfn.IFS(B17=\"level 1\", \"starting\",B17=\"level 2\", \"in progress\", B17=\"level 3\", \"advanced\", B17=\"level 4\", \" far advanced\", B17=\"level 5\", \"mastered\")","v":{"$error":"#N/A"}},{"$f":"CONCATENATE(\n  IF(B17=\"level 5\", Survey!F6, \"\"),\n  IF(B17=\"level 4\", Survey!E6, \"\"),\n  IF(B17=\"level 3\", Survey!D6, \"\"),\n  IF(B17=\"level 2\", Survey!C6, \"\"),\n  IF(B17=\"level 1\", Survey!B6, \"\")\n)","v":""},{"$f":"CONCATENATE(\n  IF(B17=\"level 5\", Survey!F6, \"\"),\n  IF(B17=\"level 4\", Survey!F6, \"\"),\n  IF(B17=\"level 3\", Survey!E6, \"\"),\n  IF(B17=\"level 2\", Survey!D6, \"\"),\n  IF(B17=\"level 1\", Survey!C6, \"\")\n)","v":""}]
["Repackaging of oral solids  (applicable in case not provided by manufacturer or 3rd party) ",{"$f":"IF(engine!G2=1,\"level 1\",\"\") & IF(engine!H2=2,\"level 2\",\"\") & IF(engine!I2=3,\"level 3\",\"\") & IF(engine!J2=4,\"level 4\",\"\") & IF(engine!K2=5,\"level 5\",\"\")","v":"level 1"},{"$f":"_xlfn.IFS(B18=\"level 1\", \"starting\",B18=\"level 2\", \"in progress\", B18=\"level 3\", \"advanced\", B18=\"level 4\", \" far advanced\", B18=\"level 5\", \"mastered\")","v":"starting"},{"$f":"CONCATENATE(\n  IF(B18=\"level 5\", Survey!F8, \"\"),\n  IF(B18=\"level 4\", Survey!E8, \"\"),\n  IF(B18=\"level 3\", Survey!D8, \"\"),\n  IF(B18=\"level 2\", Survey!C8, \"\"),\n  IF(B18=\"level 1\", Survey!B8, \"\")\n)","v":"No repackaging. 0% of beeds are suplied"},{"$f":"CONCATENATE(\n  IF(B18=\"level 5\", Survey!F8, \"\"),\n  IF(B18=\"level 4\", Survey!F8, \"\"),\n  IF(B18=\"level 3\", Survey!E8, \"\"),\n  IF(B18=\"level 2\", Survey!D8, \"\"),\n  IF(B18=\"level 1\", Survey!C8, \"\")\n)","v":"Manual repackaging.  Repackaging into unit dose (patient-specific and/or patient non-specific). 25% of beds are suplied"}]
["Preparation (sterile products)",{"$f":"IF(engine!G3=1,\"level 1\",\"\") & IF(engine!H3=2,\"level 2\",\"\") & IF(engine!I3=3,\"level 3\",\"\") & IF(engine!J3=4,\"level 4\",\"\") & IF(engine!K3=5,\"level 5\",\"\")","v":"level 1"},{"$f":"_xlfn.IFS(B19=\"level 1\", \"starting\",B19=\"level 2\", \"in progress\", B19=\"level 3\", \"advanced\", B19=\"level 4\", \" far advanced\", B19=\"level 5\", \"mastered\")","v":"starting"},{"$f":"CONCATENATE(\n  IF(B19=\"level 5\", Survey!F10, \"\"),\n  IF(B19=\"level 4\", Survey!E10, \"\"),\n  IF(B19=\"level 3\", Survey!D10, \"\"),\n  IF(B19=\"level 2\", Survey!C10, \"\"),\n  IF(B19=\"level 1\", Survey!B10, \"\")\n)","v":"Manually (incl. some very limited semi-automation e.g. usage of a TPN compounder)."},{"$f":"CONCATENATE(\n  IF(B19=\"level 5\", Survey!F10, \"\"),\n  IF(B19=\"level 4\", Survey!F10, \"\"),\n  IF(B19=\"level 3\", Survey!E10, \"\"),\n  IF(B19=\"level 2\", Survey!D10, \"\"),\n  IF(B19=\"level 1\", Survey!C10, \"\")\n)","v":"Semi-automated technology (without gravimetric/volumetric)."}]
["Inpatient Dispensing (non-sterile products) ",{"$f":"IF(engine!G4=1,\"level 1\",\"\") & IF(engine!H4=2,\"level 2\",\"\") & IF(engine!I4=3,\"level 3\",\"\") & IF(engine!J4=4,\"level 4\",\"\") & IF(engine!K4=5,\"level 5\",\"\")","v":"level 5"},{"$f":"_xlfn.IFS(B20=\"level 1\", \"starting\",B20=\"level 2\", \"in progress\", B20=\"level 3\", \"advanced\", B20=\"level 4\", \" far advanced\", B20=\"level 5\", \"mastered\")","v":"mastered"},{"$f":"CONCATENATE(\n  IF(B20=\"level 5\", Survey!F12, \"\"),\n  IF(B20=\"level 4\", Survey!E12, \"\"),\n  IF(B20=\"level 3\", Survey!D12, \"\"),\n  IF(B20=\"level 2\", Survey!C12, \"\"),\n  IF(B20=\"level 1\", Survey!B12, \"\")\n)","v":"Non-sterile doses dispensed in >75% of wards from automated devices (e.g., robots, carousels). Those that are not dispensed from automation are dispensed and checked using barcode verification. Virtually all data on dispensing errors are captured through automation or barcode systems, and reports are generated automatically and provided to managers."},{"$f":"CONCATENATE(\n  IF(B20=\"level 5\", Survey!F12, \"\"),\n  IF(B20=\"level 4\", Survey!F12, \"\"),\n  IF(B20=\"level 3\", Survey!E12, \"\"),\n  IF(B20=\"level 2\", Survey!D12, \"\"),\n  IF(B20=\"level 1\", Survey!C12, \"\")\n)","v":"Non-sterile doses dispensed in >75% of wards from automated devices (e.g., robots, carousels). Those that are not dispensed from automation are dispensed and checked using barcode verification. Virtually all data on dispensing errors are captured through automation or barcode systems, and reports are generated automatically and provided to managers."}]
["Medication Management on the Ward",{"$f":"IF(engine!G5=1,\"level 1\",\"\") & IF(engine!H5=2,\"level 2\",\"\") & IF(engine!I5=3,\"level 3\",\"\") & IF(engine!J5=4,\"level 4\",\"\") & IF(engine!K5=5,\"level 5\",\"\")","v":"level 1"},{"$f":"_xlfn.IFS(B21=\"level 1\", \"starting\",B21=\"level 2\", \"in progress\", B21=\"level 3\", \"advanced\", B21=\"level 4\", \" far advanced\", B21=\"level 5\", \"mastered\")","v":"starting"},{"$f":"CONCATENATE(\n  IF(B21=\"level 5\", Survey!F14, \"\"),\n  IF(B21=\"level 4\", Survey!E14, \"\"),\n  IF(B21=\"level 3\", Survey!D14, \"\"),\n  IF(B21=\"level 2\", Survey!C14, \"\"),\n  IF(B21=\"level 1\", Survey!B14, \"\")\n)","v":"Manual tracking of controlled drugs meets regulatory requirements.  No visibility into ward stock inventory levels for non-controlled drugs.  Replenishment is paper based ordering.  Wards stock medications are stored in open shelves, carts, manual cabinets, etc."},{"$f":"CONCATENATE(\n  IF(B21=\"level 5\", Survey!F14, \"\"),\n  IF(B21=\"level 4\", Survey!F14, \"\"),\n  IF(B21=\"level 3\", Survey!E14, \"\"),\n  IF(B21=\"level 2\", Survey!D14, \"\"),\n  IF(B21=\"level 1\", Survey!C14, \"\")\n)","v":"All ward stock locations  replenish their medications via electronic ordering with no perpetual inventory level visibility.  Re-order quantities are based on human decisions.  Most medications stored in open shelves, carts, manual cabinets, etc."}]
["Outpatient Dispensing (non-sterile) - if applicable original pack dispensing ",{"$f":"IF(engine!G6=1,\"level 1\",\"\") & IF(engine!H6=2,\"level 2\",\"\") & IF(engine!I6=3,\"level 3\",\"\") & IF(engine!J6=4,\"level 4\",\"\") & IF(engine!K6=5,\"level 5\",\"\")","v":"level 1"},{"$f":"_xlfn.IFS(B22=\"level 1\", \"starting\",B22=\"level 2\", \"in progress\", B22=\"level 3\", \"advanced\", B22=\"level 4\", \" far advanced\", B22=\"level 5\", \"mastered\")","v":"starting"},{"$f":"CONCATENATE(\n  IF(B22=\"level 5\", Survey!F16, \"\"),\n  IF(B22=\"level 4\", Survey!E16, \"\"),\n  IF(B22=\"level 3\", Survey!D16, \"\"),\n  IF(B22=\"level 2\", Survey!C16, \"\"),\n  IF(B22=\"level 1\", Survey!B16, \"\")\n)","v":"Inability to transfer information.  (e.g., (1) Manual paper based prescriptions, (2) Lack of technology to dispense prescriptions; virtually all dispensing done manually, with <10% dispensed by automation; (3) Inability to have image of final dispensed product during verification or to verify using technology (barcoding); (4) If applicable, adherence packaging dispensing is fully manual and requires human checking)."},{"$f":"CONCATENATE(\n  IF(B22=\"level 5\", Survey!F16, \"\"),\n  IF(B22=\"level 4\", Survey!F16, \"\"),\n  IF(B22=\"level 3\", Survey!E16, \"\"),\n  IF(B22=\"level 2\", Survey!D16, \"\"),\n  IF(B22=\"level 1\", Survey!C16, \"\")\n)","v":"Limited ability to transfer information  (e.g., (1) Limited e-prescriptions, (2) Ability to use technology to dispense 11–25% of prescriptions; (3) Ability to have image of final dispensed product during verification or to verify using technology (barcoding) for 11–25% of prescriptions; (4) If applicable, adherence packaging dispensing is semi-automated and requires human checking)."}]
["Part 2 Governance of Data and Interoperability"]
["Master data set up ",{"$f":"IF(engine!G7=1,\"level 1\",\"\") & IF(engine!H7=2,\"level 2\",\"\") & IF(engine!I7=3,\"level 3\",\"\") & IF(engine!J7=4,\"level 4\",\"\") & IF(engine!K7=5,\"level 5\",\"\")","v":"level 5"},{"$f":"_xlfn.IFS(B24=\"level 1\", \"starting\",B24=\"level 2\", \"in progress\", B24=\"level 3\", \"advanced\", B24=\"level 4\", \" far advanced\", B24=\"level 5\", \"mastered\")","v":"mastered"},{"$f":"CONCATENATE(\n  IF(B24=\"level 5\", Survey!F19, \"\"),\n  IF(B24=\"level 4\", Survey!E19, \"\"),\n  IF(B24=\"level 3\", Survey!D19, \"\"),\n  IF(B24=\"level 2\", Survey!C19, \"\"),\n  IF(B24=\"level 1\", Survey!B19, \"\")\n)","v":"The different components of the system should be interlinking with each other and you have some sort of mutual recognition. Recognition of the patient that has got the medicine. Documentation of the administration of the medication (e.g nurses giving the medicine to the patient, thus compelte documentation). All systems connect to each other. Biderectional connectivity between all different systems. Pharmacy +suppliers+ GDP+ institutional clients & department+ Good Pharmacy Practice (GPP)+ GMP"},{"$f":"CONCATENATE(\n  IF(B24=\"level 5\", Survey!F19, \"\"),\n  IF(B24=\"level 4\", Survey!F19, \"\"),\n  IF(B24=\"level 3\", Survey!E19, \"\"),\n  IF(B24=\"level 2\", Survey!D19, \"\"),\n  IF(B24=\"level 1\", Survey!C19, \"\")\n)","v":"The different components of the system should be interlinking with each other and you have some sort of mutual recognition. Recognition of the patient that has got the medicine. Documentation of the administration of the medication (e.g nurses giving the medicine to the patient, thus compelte documentation). All systems connect to each other. Biderectional connectivity between all different systems. Pharmacy +suppliers+ GDP+ institutional clients & department+ Good Pharmacy Practice (GPP)+ GMP"}]
["IT Infrastructure ",{"$f":"IF(engine!G8=1,\"level 1\",\"\") & IF(engine!H8=2,\"level 2\",\"\") & IF(engine!I8=3,\"level 3\",\"\") & IF(engine!J8=4,\"level 4\",\"\") & IF(engine!K8=5,\"level 5\",\"\")","v":"level 1"},{"$f":"_xlfn.IFS(B25=\"level 1\", \"starting\",B25=\"level 2\", \"in progress\", B25=\"level 3\", \"advanced\", B25=\"level 4\", \" far advanced\", B25=\"level 5\", \"mastered\")","v":"starting"},{"$f":"CONCATENATE(\n  IF(B25=\"level 5\", Survey!F21, \"\"),\n  IF(B25=\"level 4\", Survey!E21, \"\"),\n  IF(B25=\"level 3\", Survey!D21, \"\"),\n  IF(B25=\"level 2\", Survey!C21, \"\"),\n  IF(B25=\"level 1\", Survey!B21, \"\")\n)","v":"A few stand alone information systems related to medication use process exist.  There are no interface capabilities between systems.  Systems data accesibility (change this all levels, change visibility by access) is very limited."},{"$f":"CONCATENATE(\n  IF(B25=\"level 5\", Survey!F21, \"\"),\n  IF(B25=\"level 4\", Survey!F21, \"\"),\n  IF(B25=\"level 3\", Survey!E21, \"\"),\n  IF(B25=\"level 2\", Survey!D21, \"\"),\n  IF(B25=\"level 1\", Survey!C21, \"\")\n)","v":"Electronic health records (EHRs), pharmacy IT systems, and some medication automation solutions exists.  Systems are minimally integrated within the hospital.  There is some data across wards or business units. "}]
["Data Intelligence ",{"$f":"IF(engine!G9=1,\"level 1\",\"\") & IF(engine!H9=2,\"level 2\",\"\") & IF(engine!I9=3,\"level 3\",\"\") & IF(engine!J9=4,\"level 4\",\"\") & IF(engine!K9=5,\"level 5\",\"\")","v":"level 1"},{"$f":"_xlfn.IFS(B26=\"level 1\", \"starting\",B26=\"level 2\", \"in progress\", B26=\"level 3\", \"advanced\", B26=\"level 4\", \" far advanced\", B26=\"level 5\", \"mastered\")","v":"starting"},{"$f":"CONCATENATE(\n  IF(B26=\"level 5\", Survey!F23, \"\"),\n  IF(B26=\"level 4\", Survey!E23, \"\"),\n  IF(B26=\"level 3\", Survey!D23, \"\"),\n  IF(B26=\"level 2\", Survey!C23, \"\"),\n  IF(B26=\"level 1\", Survey!B23, \"\")\n)","v":"Ad hoc descriptive reports are generated separately within each system."},{"$f":"CONCATENATE(\n  IF(B26=\"level 5\", Survey!F23, \"\"),\n  IF(B26=\"level 4\", Survey!F23, \"\"),\n  IF(B26=\"level 3\", Survey!E23, \"\"),\n  IF(B26=\"level 2\", Survey!D23, \"\"),\n  IF(B26=\"level 1\", Survey!C23, \"\")\n)","v":"Routine descriptive reports across the individual facility for logistics or clinical data review are scheduled to generate at defined intervals for review."}]
["Financial Management",{"$f":"IF(engine!G10=1,\"level 1\",\"\") & IF(engine!H10=2,\"level 2\",\"\") & IF(engine!I10=3,\"level 3\",\"\") & IF(engine!J10=4,\"level 4\",\"\") & IF(engine!K10=5,\"level 5\",\"\")","v":"level 1"},{"$f":"_xlfn.IFS(B27=\"level 1\", \"starting\",B27=\"level 2\", \"in progress\", B27=\"level 3\", \"advanced\", B27=\"level 4\", \" far advanced\", B27=\"level 5\", \"mastered\")","v":"starting"},{"$f":"CONCATENATE(\n  IF(B27=\"level 5\", Survey!F25, \"\"),\n  IF(B27=\"level 4\", Survey!E25, \"\"),\n  IF(B27=\"level 3\", Survey!D25, \"\"),\n  IF(B27=\"level 2\", Survey!C25, \"\"),\n  IF(B27=\"level 1\", Survey!B25, \"\")\n)","v":"Stakeholders create budgets and reports within their own proprietary systems.  Financial status is not provided in a comprehensive view."},{"$f":"CONCATENATE(\n  IF(B27=\"level 5\", Survey!F25, \"\"),\n  IF(B27=\"level 4\", Survey!F25, \"\"),\n  IF(B27=\"level 3\", Survey!E25, \"\"),\n  IF(B27=\"level 2\", Survey!D25, \"\"),\n  IF(B27=\"level 1\", Survey!C25, \"\")\n)","v":"Most budgets and financial reports remain unstandardized, with only a limited number sharing identical formats and reporting on comparable values."}]
["Procurement",{"$f":"IF(engine!G11=1,\"level 1\",\"\") & IF(engine!H11=2,\"level 2\",\"\") & IF(engine!I11=3,\"level 3\",\"\") & IF(engine!J11=4,\"level 4\",\"\") & IF(engine!K11=5,\"level 5\",\"\")","v":"level 1"},{"$f":"_xlfn.IFS(B28=\"level 1\", \"starting\",B28=\"level 2\", \"in progress\", B28=\"level 3\", \"advanced\", B28=\"level 4\", \" far advanced\", B28=\"level 5\", \"mastered\")","v":"starting"},{"$f":"CONCATENATE(\n  IF(B28=\"level 5\", Survey!F27, \"\"),\n  IF(B28=\"level 4\", Survey!E27, \"\"),\n  IF(B28=\"level 3\", Survey!D27, \"\"),\n  IF(B28=\"level 2\", Survey!C27, \"\"),\n  IF(B28=\"level 1\", Survey!B27, \"\")\n)","v":"Stakeholders order, receive, and deploy capital-intensive business products and services in isolation from each other.  Information is only shared when procurement problems arise."},{"$f":"CONCATENATE(\n  IF(B28=\"level 5\", Survey!F27, \"\"),\n  IF(B28=\"level 4\", Survey!F27, \"\"),\n  IF(B28=\"level 3\", Survey!E27, \"\"),\n  IF(B28=\"level 2\", Survey!D27, \"\"),\n  IF(B28=\"level 1\", Survey!C27, \"\")\n)","v":"Most procurement activities occur in isolation.  In limited cases the procurement of capital intensive products and services are subject to additional data collection so that earlier warnings of procurement problems are visible."}]
["Order review (incl. clinical decision support)",{"$f":"IF(engine!G12=1,\"level 1\",\"\") & IF(engine!H12=2,\"level 2\",\"\") & IF(engine!I12=3,\"level 3\",\"\") & IF(engine!J12=4,\"level 4\",\"\") & IF(engine!K12=5,\"level 5\",\"\")","v":"level 1"},{"$f":"_xlfn.IFS(B29=\"level 1\", \"starting\",B29=\"level 2\", \"in progress\", B29=\"level 3\", \"advanced\", B29=\"level 4\", \" far advanced\", B29=\"level 5\", \"mastered\")","v":"starting"},{"$f":"CONCATENATE(\n  IF(B29=\"level 5\", Survey!F29, \"\"),\n  IF(B29=\"level 4\", Survey!E29, \"\"),\n  IF(B29=\"level 3\", Survey!D29, \"\"),\n  IF(B29=\"level 2\", Survey!C29, \"\"),\n  IF(B29=\"level 1\", Survey!B29, \"\")\n)","v":"Patient-level medication orders are not reviewed."},{"$f":"CONCATENATE(\n  IF(B29=\"level 5\", Survey!F29, \"\"),\n  IF(B29=\"level 4\", Survey!F29, \"\"),\n  IF(B29=\"level 3\", Survey!E29, \"\"),\n  IF(B29=\"level 2\", Survey!D29, \"\"),\n  IF(B29=\"level 1\", Survey!C29, \"\")\n)","v":"Patient-level medication orders are reviewed during limited pharmacy operational hours with our without aid of clinical decision support systems. Retrospective review of orders already administered does not occur."}]
["CPOE (incl. clinical decision support)",{"$f":"IF(engine!G13=1,\"level 1\",\"\") & IF(engine!H13=2,\"level 2\",\"\") & IF(engine!I13=3,\"level 3\",\"\") & IF(engine!J13=4,\"level 4\",\"\") & IF(engine!K13=5,\"level 5\",\"\")","v":"level 1"},{"$f":"_xlfn.IFS(B30=\"level 1\", \"starting\",B30=\"level 2\", \"in progress\", B30=\"level 3\", \"advanced\", B30=\"level 4\", \" far advanced\", B30=\"level 5\", \"mastered\")","v":"starting"},{"$f":"CONCATENATE(\n  IF(B30=\"level 5\", Survey!F31, \"\"),\n  IF(B30=\"level 4\", Survey!E31, \"\"),\n  IF(B30=\"level 3\", Survey!D31, \"\"),\n  IF(B30=\"level 2\", Survey!C31, \"\"),\n  IF(B30=\"level 1\", Survey!B31, \"\"),  IF(B30=\"level 1\", Survey!B32, \"\"),  IF(B30=\"level 1\", Survey!B33, \"\"),  IF(B30=\"level 1\", Survey!B34, \"\")\n)","v":"Structured patient level electronic data about medication and other medical products do not exist.Medication administration records are maintained on manual paper based systems.  New orders, change orders, and discontinued orders are transcribed manually onto the record.  Medication administration transactions are documented on the manual record."},{"$f":"CONCATENATE(\n  IF(B30=\"level 5\", Survey!F31, \"\"),\n  IF(B30=\"level 4\", Survey!F31, \"\"),\n  IF(B30=\"level 3\", Survey!E31, \"\"),\n  IF(B30=\"level 2\", Survey!D31, \"\"),\n  IF(B30=\"level 1\", Survey!C31, \"\")\n)","v":"Limited prescription data is captured electronically in a structured manner.  No clinical decision support is offered."}]
["Medication Administration records",{"$f":"IF(engine!G14=1,\"level 1\",\"\") & IF(engine!H14=2,\"level 2\",\"\") & IF(engine!I14=3,\"level 3\",\"\") & IF(engine!J14=4,\"level 4\",\"\") & IF(engine!K14=5,\"level 5\",\"\")","v":"level 1"},{"$f":"_xlfn.IFS(B31=\"level 1\", \"starting\",B31=\"level 2\", \"in progress\", B31=\"level 3\", \"advanced\", B31=\"level 4\", \" far advanced\", B31=\"level 5\", \"mastered\")","v":"starting"},{"$f":"CONCATENATE(\n  IF(B31=\"level 5\", Survey!F33, \"\"),\n  IF(B31=\"level 4\", Survey!E33, \"\"),\n  IF(B31=\"level 3\", Survey!D33, \"\"),\n  IF(B31=\"level 2\", Survey!C33, \"\"),\n  IF(B31=\"level 1\", Survey!B33, \"\")\n)","v":"Medication administration records are maintained on manual paper based systems.  New orders, change orders, and discontinued orders are transcribed manually onto the record.  Medication administration transactions are documented on the manual record."},{"$f":"CONCATENATE(\n  IF(B31=\"level 5\", Survey!F33, \"\"),\n  IF(B31=\"level 4\", Survey!F33, \"\"),\n  IF(B31=\"level 3\", Survey!E33, \"\"),\n  IF(B31=\"level 2\", Survey!D33, \"\"),\n  IF(B31=\"level 1\", Survey!C33, \"\")\n)","v":"Medication administration records are maintained on an electric medication record (e-MAR) on some wards.  New orders, change orders, and discontinued orders are reflected real time on the e-MAR.  Medication administration transactions are documented electronically on the e-MAR."}]
["Part 3 Project management"]
["Overview Summary.This in the intro   ",{"$f":"IF(engine!G15=1,\"level 1\",\"\") & IF(engine!H15=2,\"level 2\",\"\") & IF(engine!I15=3,\"level 3\",\"\") & IF(engine!J15=4,\"level 4\",\"\") & IF(engine!K15=5,\"level 5\",\"\")","v":"level 1"},{"$f":"_xlfn.IFS(B33=\"level 1\", \"starting\",B33=\"level 2\", \"in progress\", B33=\"level 3\", \"advanced\", B33=\"level 4\", \" far advanced\", B33=\"level 5\", \"mastered\")","v":"starting"},{"$f":"CONCATENATE(\n  IF(B33=\"level 5\", Survey!F36, \"\"),\n  IF(B33=\"level 4\", Survey!E36, \"\"),\n  IF(B33=\"level 3\", Survey!D36, \"\"),\n  IF(B33=\"level 2\", Survey!C36, \"\"),\n  IF(B33=\"level 1\", Survey!B36, \"\")\n)","v":"Level 1: Initial Process\nThere are not established practices or standards, and individual project managers are not held to specific accountability by any process standards. Documentation is loose and ad hoc. Metrics are informally collected on an ad hoc basis. "},{"$f":"CONCATENATE(\n  IF(B33=\"level 5\", Survey!F36, \"\"),\n  IF(B33=\"level 4\", Survey!F36, \"\"),\n  IF(B33=\"level 3\", Survey!E36, \"\"),\n  IF(B33=\"level 2\", Survey!D36, \"\"),\n  IF(B33=\"level 1\", Survey!C36, \"\")\n)","v":"Level 2: Structured Process and Standards\nDocumentation exists on these basic processes but it is not standardized. Functional management is involved in the project management of larger, more visible projects, and these are typically executed in a systematic fashion. There are basic metrics to track project cost, schedule, and technical performance, although data may be collected/correlated manually. Information available for managing the project is often a mix between summary level data, and detailed level data."}]
["Governance ",{"$f":"IF(engine!G16=1,\"level 1\",\"\") & IF(engine!H16=2,\"level 2\",\"\") & IF(engine!I16=3,\"level 3\",\"\") & IF(engine!J16=4,\"level 4\",\"\") & IF(engine!K16=5,\"level 5\",\"\")","v":"level 1"},{"$f":"_xlfn.IFS(B34=\"level 1\", \"starting\",B34=\"level 2\", \"in progress\", B34=\"level 3\", \"advanced\", B34=\"level 4\", \" far advanced\", B34=\"level 5\", \"mastered\")","v":"starting"},{"$f":"CONCATENATE(\n  IF(B34=\"level 5\", Survey!F38, \"\"),\n  IF(B34=\"level 4\", Survey!E38, \"\"),\n  IF(B34=\"level 3\", Survey!D38, \"\"),\n  IF(B34=\"level 2\", Survey!C38, \"\"),\n  IF(B34=\"level 1\", Survey!B38, \"\")\n)","v":"Project roles not formally appointed.  Delivery activities, documentation, planning, escalation structure, and communication plan do not exist.  Little engagement with vendor."},{"$f":"CONCATENATE(\n  IF(B33=\"level 5\", Survey!F38, \"\"),\n  IF(B33=\"level 4\", Survey!F38, \"\"),\n  IF(B33=\"level 3\", Survey!E38, \"\"),\n  IF(B33=\"level 2\", Survey!D38, \"\"),\n  IF(B33=\"level 1\", Survey!C38, \"\")\n)","v":"Project manager is appointed to each project, but the project manager has not recevied any specific training. No other stakeholders are identified formally.  Basic planning is performed without assigned accountability or communication plan.  Escalation route may exist informally."}]
["Outcomes",{"$f":"IF(engine!G17=1,\"level 1\",\"\") & IF(engine!H17=2,\"level 2\",\"\") & IF(engine!I17=3,\"level 3\",\"\") & IF(engine!J17=4,\"level 4\",\"\") & IF(engine!K17=5,\"level 5\",\"\")","v":"level 5"},{"$f":"_xlfn.IFS(B35=\"level 1\", \"starting\",B35=\"level 2\", \"in progress\", B35=\"level 3\", \"advanced\", B35=\"level 4\", \" far advanced\", B35=\"level 5\", \"mastered\")","v":"mastered"},{"$f":"CONCATENATE(\n  IF(B35=\"level 5\", Survey!F40, \"\"),\n  IF(B35=\"level 4\", Survey!E40, \"\"),\n  IF(B35=\"level 3\", Survey!D40, \"\"),\n  IF(B35=\"level 2\", Survey!C40, \"\"),\n  IF(B35=\"level 1\", Survey!B40, \"\")\n)","v":"Business case KPIs agreed during formation of project and measurement is planned and resourced at the onset. Case studies created and independently verified, reporting on success of the delivery. (e.g. professional journals).  All KPIs measured, scrutinized, and actions taken for continuous improvement."},{"$f":"CONCATENATE(\n  IF(B34=\"level 5\", Survey!F40, \"\"),\n  IF(B34=\"level 4\", Survey!F40, \"\"),\n  IF(B34=\"level 3\", Survey!E40, \"\"),\n  IF(B34=\"level 2\", Survey!D40, \"\"),\n  IF(B34=\"level 1\", Survey!C40, \"\")\n)","v":"Business case exists however not considered during planning and not re-visited or measured after implementation.  No KPIs are measured."}]
["Project Deployment Budget ",{"$f":"IF(engine!G18=1,\"level 1\",\"\") & IF(engine!H18=2,\"level 2\",\"\") & IF(engine!I18=3,\"level 3\",\"\") & IF(engine!J18=4,\"level 4\",\"\") & IF(engine!K18=5,\"level 5\",\"\")","v":"level 1"},{"$f":"_xlfn.IFS(B36=\"level 1\", \"starting\",B36=\"level 2\", \"in progress\", B36=\"level 3\", \"advanced\", B36=\"level 4\", \" far advanced\", B36=\"level 5\", \"mastered\")","v":"starting"},{"$f":"CONCATENATE(\n  IF(B36=\"level 5\", Survey!F42, \"\"),\n  IF(B36=\"level 4\", Survey!E342, \"\"),\n  IF(B36=\"level 3\", Survey!D42, \"\"),\n  IF(B36=\"level 2\", Survey!C42, \"\"),\n  IF(B36=\"level 1\", Survey!B42, \"\")\n)","v":"No assigned budget for delivery.  Spending not monitored."},{"$f":"CONCATENATE(\n  IF(B35=\"level 5\", Survey!F42, \"\"),\n  IF(B35=\"level 4\", Survey!F42, \"\"),\n  IF(B35=\"level 3\", Survey!E42, \"\"),\n  IF(B35=\"level 2\", Survey!D42, \"\"),\n  IF(B35=\"level 1\", Survey!C42, \"\")\n)","v":"Actual costs vs budget are reviewed at scheduled intervals. Contingency budget assigned and managed as per PMP recommendations/standards.  "}]
["Supporting Systems",{"$f":"IF(engine!G19=1,\"level 1\",\"\") & IF(engine!H19=2,\"level 2\",\"\") & IF(engine!I19=3,\"level 3\",\"\") & IF(engine!J19=4,\"level 4\",\"\") & IF(engine!K19=5,\"level 5\",\"\")","v":"level 1"},{"$f":"_xlfn.IFS(B37=\"level 1\", \"starting\",B37=\"level 2\", \"in progress\", B37=\"level 3\", \"advanced\", B37=\"level 4\", \" far advanced\", B37=\"level 5\", \"mastered\")","v":"starting"},{"$f":"CONCATENATE(\n  IF(B37=\"level 5\", Survey!F44, \"\"),\n  IF(B37=\"level 4\", Survey!E44, \"\"),\n  IF(B37=\"level 3\", Survey!D44, \"\"),\n  IF(B37=\"level 2\", Survey!C44, \"\"),\n  IF(B37=\"level 1\", Survey!B44, \"\")\n)","v":"No project planning or project management tool in use."},{"$f":"CONCATENATE(\n  IF(B36=\"level 5\", Survey!F44, \"\"),\n  IF(B36=\"level 4\", Survey!F44, \"\"),\n  IF(B36=\"level 3\", Survey!E44, \"\"),\n  IF(B36=\"level 2\", Survey!D44, \"\"),\n  IF(B36=\"level 1\", Survey!C44, \"\")\n)","v":"Planning performed on Excel.\nNo other collaborative tools in place."}]
["Training of Users for each dedicated automated system ",{"$f":"IF(engine!G20=1,\"level 1\",\"\") & IF(engine!H20=2,\"level 2\",\"\") & IF(engine!I20=3,\"level 3\",\"\") & IF(engine!J20=4,\"level 4\",\"\") & IF(engine!K20=5,\"level 5\",\"\")","v":"level 1"},{"$f":"_xlfn.IFS(B38=\"level 1\", \"starting\",B38=\"level 2\", \"in progress\", B38=\"level 3\", \"advanced\", B38=\"level 4\", \" far advanced\", B38=\"level 5\", \"mastered\")","v":"starting"},{"$f":"CONCATENATE(\n  IF(B38=\"level 5\", Survey!F46, \"\"),\n  IF(B38=\"level 4\", Survey!E46, \"\"),\n  IF(B38=\"level 3\", Survey!D46, \"\"),\n  IF(B38=\"level 2\", Survey!C46, \"\"),\n  IF(B38=\"level 1\", Survey!B46, \"\")\n)","v":"Staff self trained by using the live system.  No training offered by the vendor.  No training plan identified.  No assessments performed."},{"$f":"CONCATENATE(\n  IF(B37=\"level 5\", Survey!F46, \"\"),\n  IF(B37=\"level 4\", Survey!F46, \"\"),\n  IF(B37=\"level 3\", Survey!E46, \"\"),\n  IF(B37=\"level 2\", Survey!D46, \"\"),\n  IF(B37=\"level 1\", Survey!C46, \"\")\n)","v":"Training dates are identified, but detailed plans of who, how and when are not made.  Identification of expert(s) from the pharmacy are trained and carry out training.   Vendor shares written training information."}]
["Part 4 Workforce Allocation"]
["Documentation",{"$f":"IF(engine!G21=1,\"level 1\",\"\") & IF(engine!H21=2,\"level 2\",\"\") & IF(engine!I21=3,\"level 3\",\"\") & IF(engine!J21=4,\"level 4\",\"\") & IF(engine!K21=5,\"level 5\",\"\")","v":"level 1"},{"$f":"_xlfn.IFS(B40=\"level 1\", \"starting\",B40=\"level 2\", \"in progress\", B40=\"level 3\", \"advanced\", B40=\"level 4\", \" far advanced\", B40=\"level 5\", \"mastered\")","v":"starting"},{"$f":"CONCATENATE(\n  IF(B40=\"level 5\", Survey!F49, \"\"),\n  IF(B40=\"level 4\", Survey!E49, \"\"),\n  IF(B40=\"level 3\", Survey!D49, \"\"),\n  IF(B40=\"level 2\", Survey!C49, \"\"),\n  IF(B40=\"level 1\", Survey!B49, \"\")\n)","v":"All documentation fully paper based"},{"$f":"CONCATENATE(\n  IF(B40=\"level 5\", Survey!F49, \"\"),\n  IF(B40=\"level 4\", Survey!F49, \"\"),\n  IF(B40=\"level 3\", Survey!E49, \"\"),\n  IF(B40=\"level 2\", Survey!D49, \"\"),\n  IF(B40=\"level 1\", Survey!C49, \"\")\n)","v":"All documentation fully electronically,               no interfaces to equipment"}]
["Core competencies of pharmaceutical staff",{"$f":"IF(engine!G22=1,\"level 1\",\"\") & IF(engine!H22=2,\"level 2\",\"\") & IF(engine!I22=3,\"level 3\",\"\") & IF(engine!J22=4,\"level 4\",\"\") & IF(engine!K22=5,\"level 5\",\"\")","v":"level 1"},{"$f":"_xlfn.IFS(B41=\"level 1\", \"starting\",B41=\"level 2\", \"in progress\", B41=\"level 3\", \"advanced\", B41=\"level 4\", \" far advanced\", B41=\"level 5\", \"mastered\")","v":"starting"},{"$f":"CONCATENATE(\n  IF(B41=\"level 5\", Survey!F51, \"\"),\n  IF(B41=\"level 4\", Survey!E51, \"\"),\n  IF(B41=\"level 3\", Survey!D51, \"\"),\n  IF(B41=\"level 2\", Survey!C51, \"\"),\n  IF(B41=\"level 1\", Survey!B51, \"\")\n)","v":"Staff is focusing only on manufacturing activities and logistics within the pharmacy."},{"$f":"CONCATENATE(\n  IF(B41=\"level 5\", Survey!F51, \"\"),\n  IF(B41=\"level 4\", Survey!F51, \"\"),\n  IF(B41=\"level 3\", Survey!E51, \"\"),\n  IF(B41=\"level 2\", Survey!D51, \"\"),\n  IF(B41=\"level 1\", Survey!C51, \"\")\n)","v":"Staff is joining planning meetings with physicians and care unit and cares for the drug stock on the ward"}]
["Planning and time recording",{"$f":"IF(engine!G23=1,\"level 1\",\"\") & IF(engine!H23=2,\"level 2\",\"\") & IF(engine!I23=3,\"level 3\",\"\") & IF(engine!J23=4,\"level 4\",\"\") & IF(engine!K23=5,\"level 5\",\"\")","v":"level 5"},{"$f":"_xlfn.IFS(B42=\"level 1\", \"starting\",B42=\"level 2\", \"in progress\", B42=\"level 3\", \"advanced\", B42=\"level 4\", \" far advanced\", B42=\"level 5\", \"mastered\")","v":"mastered"},{"$f":"CONCATENATE(\n  IF(B42=\"level 5\", Survey!F53, \"\"),\n  IF(B42=\"level 4\", Survey!E53, \"\"),\n  IF(B42=\"level 3\", Survey!D53, \"\"),\n  IF(B42=\"level 2\", Survey!C53, \"\"),\n  IF(B42=\"level 1\", Survey!B53, \"\")\n)","v":"Fully automated system that proposes required human capacity in correlation to the demand using interfaces to ERP-software. Results are communicated to the staff by App with individual time dependend activity table. Project specific automated recording of presence time in correlation to specific task (dispensing, Clinical Services e.g.) for all staff. Intelligent evaluation of planned and invested working time for optimization of staff deployment over all working shifts. "},{"$f":"CONCATENATE(\n  IF(B42=\"level 5\", Survey!F53, \"\"),\n  IF(B42=\"level 4\", Survey!F53, \"\"),\n  IF(B42=\"level 3\", Survey!E53, \"\"),\n  IF(B42=\"level 2\", Survey!D53, \"\"),\n  IF(B42=\"level 1\", Survey!C53, \"\")\n)","v":"Fully automated system that proposes required human capacity in correlation to the demand using interfaces to ERP-software. Results are communicated to the staff by App with individual time dependend activity table. Project specific automated recording of presence time in correlation to specific task (dispensing, Clinical Services e.g.) for all staff. Intelligent evaluation of planned and invested working time for optimization of staff deployment over all working shifts. "}]
["Staff education (tools and processes)",{"$f":"IF(engine!G24=1,\"level 1\",\"\") & IF(engine!H24=2,\"level 2\",\"\") & IF(engine!I24=3,\"level 3\",\"\") & IF(engine!J24=4,\"level 4\",\"\") & IF(engine!K24=5,\"level 5\",\"\")","v":"level 1"},{"$f":"_xlfn.IFS(B43=\"level 1\", \"starting\",B43=\"level 2\", \"in progress\", B43=\"level 3\", \"advanced\", B43=\"level 4\", \" far advanced\", B43=\"level 5\", \"mastered\")","v":"starting"},{"$f":"CONCATENATE(\n  IF(B43=\"level 5\", Survey!F55, \"\"),\n  IF(B43=\"level 4\", Survey!E55, \"\"),\n  IF(B43=\"level 3\", Survey!D55, \"\"),\n  IF(B43=\"level 2\", Survey!C55, \"\"),\n  IF(B43=\"level 1\", Survey!B55, \"\")\n)","v":"Staff education processes are fully paper based, unautomated and not linked. "},{"$f":"CONCATENATE(\n  IF(B43=\"level 5\", Survey!F55, \"\"),\n  IF(B43=\"level 4\", Survey!F55, \"\"),\n  IF(B43=\"level 3\", Survey!E55, \"\"),\n  IF(B43=\"level 2\", Survey!D55, \"\"),\n  IF(B43=\"level 1\", Survey!C55, \"\")\n)","v":"Staff education processes are minimally linked and automated using a spreadsheet software.  Staff training is created and deployed manually as non interactive front presentation. Compliance is also tracked using  spreadsheet rules administetered by a pharmacist.  Staff members do not have access to their compliance data."}]