{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["non-network","network","frontpage","main","outcome 1","outcome2","outcome 3","outcome 4","outcome 5","outcome 6","outcome 7","outcome 8","outcome 9","lists","Sheet1"],"not_rendered":{"charts":0,"images":58,"macros":1,"external_links":2,"defined_names":7,"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":"non-network","index":0,"n_rows":200,"n_cols":13,"rows_kept":200,"cut":false,"hidden":false,"merged":[[46,5,46,8],[3,2,4,16],[5,2,8,16],[9,2,10,16],[12,2,12,7],[13,2,18,16],[37,2,37,17],[38,2,38,11],[39,2,41,16],[42,5,42,16],[43,2,43,3],[43,5,45,16],[87,12,89,16],[47,5,48,16],[49,5,49,8],[50,5,52,16],[53,5,53,16],[54,5,55,16],[56,5,56,8],[57,5,59,16],[60,5,60,7],[61,5,67,16],[70,12,73,14],[78,2,83,16],[138,2,138,13],[91,12,93,16],[95,12,99,16],[102,2,106,5],[102,12,106,16],[108,2,110,16],[111,2,111,17],[112,2,115,16],[116,2,116,16],[122,2,125,16],[136,2,137,16],[102,7,106,10],[199,1,199,3],[139,2,141,16],[168,2,168,13],[169,2,172,16],[173,2,173,13],[174,2,174,16],[175,2,175,3],[176,2,176,8],[177,2,181,16],[193,2,193,8],[194,2,194,16],[195,2,195,15],[196,2,196,11]]}
[]
[]
[]
[null,null,"Demonstration paperless reporting, Adult Health & Social Care Balanced Scorecard V6.0 April 2019"]
[]
[null,null,"We have attempted to design  a non-paper based reporting tool for adult health and social care data that is both more comprehensive than available at present and easy to use. It does not require any specialist computer knowledge to navigate, is operated using Microsoft Excel O365, 2016, 2013, 2010 and 2007 and is designed to run on any machine supplied by either NHS Highland or The Highland Council. It is designed to be cross platform and to be viewed on a PC, laptop or tablet. This guidance is for the non-intranet distributed (standalone) version of the scorecard."]
[]
[]
[]
[null,null,"Because this approach is in development, it is not the final version that we will release but it is very close to it.  The test parameters that are still to be finalised will be communicated to all users when they are finalised. They will be identified by a new version number. This is version 5.4."]
[]
[]
[null,1,"Easy access to data"]
[null,null,"The scorecard is a complex dataset that needs to give elected members and managers a clear indication of what we are doing, how well we are doing it and how we are placed against others providing similar services to a similar demographic. It's not a \"league table\" but places our performance in some context. We have designed the scorecard around the 9 national H&SC outcomes and propose to extend it through to 4 health Local Development Plan (LDP) indicators based on HEAT targets. It is now clear that a recent review of the National Outcomes, carried out by Sir Harry Burns will result in changes to the indicators and how the data behind them is collected but that is a consideration for the future. At present, there are 9 outcomes with 372 discrete measurements against the data sources that are collected but 178 (65%) data measures are either not completed or not collected. Improving this is a key aim of this project. The main page looks like this."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,2,"Enables more data to be displayed transparently and logically through metrics"]
[null,null,"Metrics"]
[null,null,"The major reason for the new approach is to enable informed governanace and that can only happen when all of the appropriate information is to hand. We have tried to ensure consistency by providing indicators that are always examined in the same way, to the same standards using the same metrics:"]
[]
[]
[null,null,null,null,null,"target"]
[null,null,"METRICS",null,null,"This is the figure that NHS Highland or Scottish Government has identified as a target for performance in a particular outcome. Not all targets are identical in percentage or qualitative terms. Targets may be aspirational."]
[null,null,"target"]
[null,null,"baseline"]
[null,null,"current",null,null,"baseline"]
[null,null,"benchmark",null,null,"The baseline is either the scottish average at the time that data collection started against a particular outcome, a policy derived figure or a locally derived target. It is intended to give perspective to the data."]
[null,null,"trend"]
[null,null,"compare",null,null,"current"]
[null,null,null,null,null,"This is the last available figure submitted from operational teams in response to a regular data request and collated by Planning & Performance. Not all data supplied is of the same quality or frequency and it is hoped that a uniform approach between NHS Highland and The Highland Council will begin to address this issue."]
[]
[]
[null,null,null,null,null,"benchmark"]
[null,null,null,null,null,"This is a nationally derived figure averaged from local measurements and data against which outcomes are formulated over a period of time.  It may also be (usually when no national data exists)  derived from local averages. It shows where shifts occur in the baseline figures, enabling a dynamic comparison to be reached."]
[]
[null,null,null,null,null,"trend"]
[null,null,null,null,null,"This is a pattern of statistical events over time and we have attempted to indicate trend analysis wherever we can identify a series of data submissions. Trends are only indicated where the data collection process is identical. Where trends are not identified, we use this symbol:"]
[]
[]
[null,null,null,null,null,"compare/ state"]
[null,null,null,null,null,"We have identified a \"family\" of LHSCP's that share a similar demographic and geographic space to Highland and who submit like data to ISD and Scottish Government. They are: Moray, Angus, Dumfries & Galloway, Argyll & Bute and Scottish Borders. Data is compared directly with these partnerships to produce a data \"state.\" In many cases, real differences in performance are small and combining the state/ trend can offer a better illustration. Trend and state data combined can provide a useful point of reference for performance at any one time. It is then used to extrapolate data for future trend prediction or retrospective trend analysis within the family of LHSCP's."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"The traffic light icons are used  because they are familiar and understandable. It is important to note that a green \"improving trend\" symbol can be attributed to a decreasing numerical trend but only if a decrease is the desired outcome. The reverse is true of a red one. The traffic lights only indicate a trend from the last point of data collection and should be viewed in conjuction with the quartile graphics - a red light indicating a marginal deterioration in performance from a Q1 placing may not have the same impact on service delivery as one that indicates a statistically significant deterioration from a Q3 or Q4 position. This is where reading the graphs and context statements becomes important. The main pointers on the graphs are as below:"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"the main graph shows the \"spread\" of performance in the period. In this case, it shows how small the differences are between all Health & Social Care Partnerships in Scotland. "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"the traffic light is GREEN, indicating improving performance from the last data point. It only indicates a trend where there is a series of data available to display."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"the context box gives a brief explanation of the data and gives advice as to the best methods of interpretation. The decision on the significance of the data always lies with the approver. It also allows us to present the headlines needed without having to provide an overwhelming amount of secondary data. That data is always available on request."]
[]
[]
[]
[]
[]
[]
[null,null,"links to the original data sources are included wherever possible. Bear in mind that NHS Highland cannot accept responsibility for the content or design of external data. It can sometimes be impenetrable. If you need assistance to interpret it, please contact us. ",null,null,null,null,"If you need to see previous years data (for instance to visualise trends) click on the button to show that year's data. You can only have one graph open at a time. To close any graph, click the red X box ",null,null,null,null,"The outcome definition is the one used by NHS Highland to explain how the indicator is structured and what data is sourced to form that structure. These definitions are formed under instruction by H&WASCC, ISD and Scottish Government"]
[]
[]
[]
[]
[]
[null,null,"In theory, all of the information and data required on any indicator should be available within the one window. The format used allows us to provide this and adapt to any changes in the reporting format that may require a shift in focus without having to alter the whole indicator statement and having to recommend changes to Committee. Changes will, however, always be noted and displayed with the \"new\" icon:"]
[]
[]
[null,3,"Allows layers of data and graphic information to be accessed from one location"]
[null,null,"Clicking on the outcome you want on the \"main page\" tab will open a further series of data measures that we collect against it. It's here that you will find links to the graphs, timelines, comparators and contextual comments around the data. Clicking on \"view data\" from there will take you to the original data sets that you can then examine. In many cases, there is more than one data source. The tabs are named from outcome one to nine."]
[]
[]
[]
[null,null,"Each national indicator tab opens in a new tab. There are 6 data windows with their own information behind most of them. "]
[]
[]
[]
[]
[]
[null,null,"Clicking on the green arrow will take you to the headline graph, as above. Clicking the blue graph will open a further graph showing comparative placings in the data family mentioned above. It also clearly shows the scottish average. Data is only available when the hand icon is displayed. Click on it to view the data."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"The outcome tabs take you to the dashboard and the NI boxes take you directly to the graphs as above. NI1 means national indicator 1, AS1.1 means adult scorecard 1.1 from the traditional scorecard naming conventions in this example.  It's best to just explore!"]
[]
[null,4,"Improves governance"]
[null,null,"This solution allows Members and Directors to make decisions based on the availabilty of the most recent information that the Organisations have to hand. The governance process is illustrated below"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,5,"Allows us to actively manage data"]
[null,null,"The use of an updateable format allows us to give you access to the latest datasets available to us, rather than a paper document which is only accurate on the day it was printed. This means that users always have the most up to date data that we can supply at hand. It also means that Planning & Performance can build a repository of data that is increasingly robust and validated.As part of this process we will build a data bank and have confidence in the data held there in a scientifically measured way. Real time reporting is not possible to demonstrate in a demonstration environment but would represent a future state to be worked towards. We are also considering deploying a visual indicator to show the +/- 5% tolerance applied to all performance graphs which display comparative data and against which we apply a \"no change\" or marginal improvement/ deterioration marker against."]
[]
[]
[]
[null,6,"fulfills H&WASC committee request for unified format for scorecards"]
[null,null,"This approach is our best answer to the request posed by Committee which asked for a unified approach to data presentation. "]
[]
[null,7,"contact us"]
[null,null,"All of the data displayed in this dashboard is collated and collected by Resources & Planning Team, NHS Highland. If you have any questions please contact us using the comments button on the top of each indicator page. Clicking it will open a form. Fill in the details. Click send and the form will be e-mailed to our team. We will treat all data requests as urgent and will reply within 5 working days. For more urgent requests, there is a contact telephone number."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"For The Highland Council's guidelines on web authoring, see here"]
[null,null,"For NHS Highland's guidelines on intranet content, see here"]
[]
[null,null,"To open the Scorecard, click on the arrow"]
[]
[]
[null,"return to top"]

{"sheet":"network","index":1,"n_rows":65,"n_cols":8,"rows_kept":65,"cut":false,"hidden":false,"merged":[[20,4,20,11],[3,3,5,20],[7,3,11,20],[12,3,12,18],[16,4,16,8],[18,4,18,7],[64,3,64,5],[44,3,45,19],[47,3,51,20],[32,4,32,12],[34,4,34,6],[34,7,34,13],[36,4,36,6],[36,7,37,20],[40,4,41,19]]}
[]
[]
[]
[null,null,null,"Accessing the Scorecard from a network"]
[]
[]
[]
[null,null,null,"When you open a new file that has active content (data connections, macros, and so on) the Message Bar appears because active content may contain viruses and other security hazards that could harm your computer or your organisation’s network. However, if you trust the source of the file, or know that the active content is secure (for example, the macro is signed by a trusted publisher and/or originates from within NHS Highland), then you can enable the file’s active content. This makes it a trusted document. When you reopen the file, the Message Bar does not appear. Use the following instructions to make your file a trusted a document."]
[]
[]
[]
[]
[null,null,null,"The following message appears when there are macros in the file. The Scorecard uses macros extensively."]
[]
[]
[]
[null,null,null,1,"Click the file tab"]
[]
[null,null,null,2,"Click Info"]
[]
[null,null,null,3,"In the Security Warning Section, click Enable Content"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,4,"Two options appear: Enable All Content and Advanced Options"]
[]
[null,null,null,"\u0096","Enable All Content",null,null,"Make the file a trusted document to allow active content to run."]
[]
[null,null,null,"\u0096","Advanced Options",null,null,"Select which active content should run for this session only. This enables the content until the program is closed. The message bar re-appears when you reopen the file."]
[]
[]
[]
[null,null,null,null,"Note: If you know that the file is from a trustworthy source you can click Enable Content on the message bar. The file becomes a trusted document and it will not open with the message bar again. "]
[]
[]
[]
[null,null,null,"Trusting the Scorecard"]
[]
[]
[null,null,null,"It’s important to be careful before trusting documents  because other people could tamper with network files and change the active content in them. To lower the possibility of security risks, you should only trust files on a network location that is access controlled, or created by the system administrator as with the NHS Highland Intranet.\nA Security Warning dialog box appears when you try to trust a file from a network location. You can click Don't show this message again in the dialog box, and then the dialog box does not appear again. In addition, you can turn off the feature by clicking No on the Security Warning dialog box. This is not advised under any circumstances."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"return to top"]

{"sheet":"frontpage","index":2,"n_rows":28,"n_cols":21,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,12,27,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"WELCOME"]

{"sheet":"main","index":3,"n_rows":34,"n_cols":27,"rows_kept":34,"cut":false,"hidden":false,"merged":[[32,9,32,12],[32,15,32,17],[32,19,32,24],[31,4,34,6],[30,9,30,11],[30,15,30,17],[30,19,30,20],[30,4,30,6],[31,9,31,11],[31,15,31,17],[31,19,31,20],[1,4,2,21],[3,5,3,21],[8,5,8,24],[10,5,10,24],[12,5,12,24],[6,4,6,28],[6,1,6,2],[29,4,29,7],[29,9,29,12],[29,15,29,17],[29,19,29,21],[14,5,14,24],[16,5,16,24],[18,5,18,24],[20,5,20,24],[22,5,22,24],[24,5,24,24]]}
[]
[null,null,null,null,"Health & Wellbeing Adult Social Care Balanced Scorecard"]
[]
[null,null,null,null,null,"Version 6.0 April 2019"]
[]
[]
[null,"dashboard"]
[]
[null,null,"target",null,null,"people are able to look after and improve their own health and wellbeing and live in good health for longer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"baseline"]
[null,null,"current",null,null,"people, including those with disabilities or long term conditions  or who are frail are able to live, as far as is reasonably practicable, independently at home or in their community",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"benchmark"]
[null,null,"trend",null,null,"people who use health and social care services have positive experiences of those services and have their dignity respected",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"compare"]
[null,null,null,null,null,"health and social care services are centred on helping people to maintain or improve the quality of life of people who use these services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[]
[null,null,null,null,null,"health and social care services contribute to reducing health inequalities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[]
[null,null,null,null,null,"people who provide unpaid care are supported to look after their own health & wellbeing, including to reduce any negative impact of their caring role on their own health & wellbeing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[]
[null,null,null,null,null,"people using health and social care services are safe from harm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[]
[null,null,null,null,null,"people who work in health & social care services feel engaged with the work they do and are supported to continuously improve the information, support care and treatment they provide",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[]
[null,null,null,null,null,"resources are used effectively and efficiently in the provision of health and social care",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[]
[]
[]
[]
[null,null,null,null,"CONTACT",null,null,null,null,"EXPLORE DATA",null,null,null,null,null,"LEARN",null,null,null,"FIND US"]
[null,null,null,null,"NHS Highland home",null,null,null,null,"National picure - ISD",null,null,null,null,null,"factsheets",null,null,null,"facebook"]
[null,null,null,null,"For enquiries about specific data sets please contact us using the comment form on the indicator page",null,null,null,null,"Scottish Government",null,null,null,null,null,"definitions",null,null,null,"twitter"]
[null,null,null,null,null,null,null,null,null,"NHS Benchmarking Network",null,null,null,null,null,"wiki"]
[null,null,null,null,null,null,null,null,null,"search"]

{"sheet":"outcome 1","index":4,"n_rows":31,"n_cols":27,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,4,2,21],[1,22,5,28],[3,4,3,21],[4,4,4,6],[4,8,4,12],[6,17,6,18],[6,20,6,21],[6,23,6,24],[6,26,6,27],[9,1,9,2],[9,5,9,24],[6,5,6,6],[6,8,6,9],[6,11,6,12],[6,14,6,15],[9,28,10,28],[10,4,10,24],[11,5,11,24],[11,28,12,28],[13,5,13,24],[13,28,14,28],[14,1,17,1],[14,2,17,2],[14,5,14,24],[15,28,16,28],[16,5,16,24],[17,5,17,24],[17,28,18,28],[18,1,23,1],[18,2,23,2],[19,5,19,24],[31,1,31,2],[19,28,20,28],[20,5,20,24],[22,5,22,24],[22,28,23,28],[23,5,23,24],[25,5,25,24],[25,28,26,28],[26,5,26,24],[28,5,28,24],[30,5,30,6]]}
[]
[null,null,null,null,"Health & Wellbeing Adult Social Care Balanced Scorecard "]
[]
[null,null,null,null,"V6.0 APRIL 2019"]
[]
[]
[null,null,null,null,null,"outcome 1"]
[]
[]
[null,"legend",null,null,null,"people are able to look after and improve their own health and wellbeing and live in good health for longer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"target","increase/ maintain/ decrease/ %"]
[null,"baseline","first figure collected",null,null,"percentage of adults able to look after their health very well or quite well",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1000000000000001]
[null,"current","latest available NHSH figure",null,null,"target","increase",null,"baseline",0.95,null,"current",0.94,null,"benchmark",0.94,null,"data",null,null,"compare"]
[null,"benchmark","scottish average by NHS board",null,null,"source: biennial National Health  & Care Experience Survey 2015 - 2016. Scottish Government"]
[null,"data","graph data series where available. Click on the red, amber or green arrow icon for the current and previous graphs and supporting evidence.",null,null,"emergency admission rate (per 100,000 population)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,"target","decrease",null,"baseline","10 689",null,"current","10 632",null,"benchmark","12 116",null,"data",null,null,"compare"]
[null,null,null,null,null,"source: Highland data submitted to annual national  indicator produced by ISD."]
[null,null,null,null,null,"enablement. % of people receiving enablement interventions who do not require ongoing care interventions after 6 weeks.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3]
[null,"compare","comparisons are to NHS Moray, Angus, Borders, Argyll & Bute and Dumfries and Galloway where like for like data exists. If not,               displayed",null,null,"target","increase",null,"baseline",0.4,null,"current",0.46700000000000003,null,"benchmark",0.4,null,"data",null,null,"compare"]
[null,null,null,null,null,"source: local indicator. Current position is % of dcember 2016 figure. Only South and MID figures are presently available"]
[null,null,null,null,null,"no. of health screenings provided for people with learning disability: all people with learning disability and epilepsy  offered an annual nurse led review of their condition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4]
[null,null,null,null,null,"target","increase",null,"baseline",0.97,null,"current",null,null,"benchmark",0.97219999999999995,null,"data",null,null,"compare"]
[null,null,null,null,null,"source: local annual indicator"]
[null,null,null,null,null,"visual impairment, self management. % of people who have completed a rehabilitation course and confirmed a positive outcome on their ability to self-manage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.5A"]
[null,null,null,null,null,"target",0.9,null,"baseline",0.89,null,"current",null,null,"benchmark",0.89500000000000002,null,"data",null,null,"compare"]
[null,null,null,null,null,"source: local annual indicator only. Previous indicator split for visual impairment and hearing impairment"]
[null,null,null,null,null,"hearing impairment, self management. % of people who have completed a rehabilitation course and confirmed a positive outcome on their ability to self-manage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.5B"]
[null,null,null,null,null,"target",0.9,null,"baseline",0.81,null,"current",null,null,"benchmark",0.9,null,"data",null,null,"compare"]
[null,null,null,null,null,"source: local annual indicator only. Previous indicator split for visual impairment and hearing impairment"]
[]
[null,null,null,null,null,"return to top"]

{"sheet":"outcome2","index":5,"n_rows":63,"n_cols":27,"rows_kept":63,"cut":false,"hidden":false,"merged":[[62,5,62,9],[60,5,60,24],[49,5,49,24],[38,4,50,4],[28,5,28,24],[31,5,31,24],[34,5,34,24],[37,5,37,24],[40,5,40,24],[43,5,43,24],[46,5,46,24],[50,5,50,24],[44,5,44,24],[47,5,47,24],[52,5,52,24],[55,5,55,24],[58,5,58,24],[54,5,54,24],[57,5,57,24],[32,5,32,24],[35,5,35,24],[38,5,38,24],[41,5,41,24],[25,5,25,24],[25,28,26,28],[26,5,26,24],[29,5,29,24],[17,28,18,28],[18,1,23,1],[18,2,23,2],[19,5,19,24],[19,28,20,28],[20,5,20,24],[22,5,22,24],[22,28,23,28],[23,5,23,24],[9,1,9,2],[9,5,9,24],[11,5,11,24],[11,28,12,28],[13,5,13,24],[13,28,14,28],[14,1,17,1],[14,2,17,2],[14,5,14,24],[15,28,16,28],[16,5,16,24],[17,5,17,24],[9,28,10,28],[10,4,10,24],[1,4,2,21],[1,22,5,28],[3,4,3,21],[4,4,4,6],[4,8,4,12],[6,23,6,24],[6,26,6,27],[6,8,6,9],[6,11,6,12],[6,14,6,15],[6,17,6,18],[6,20,6,21]]}
[]
[null,null,null,null,"Health & Wellbeing Adult Social Care Balanced Scorecard "]
[]
[null,null,null,null,"V6.0 APRIL 2019"]
[]
[]
[null,null,null,null,null,null,null,null,"outcome 2"]
[]
[]
[null,"legend",null,null,null,"people, including those with disabilities or long term conditions  or who are frail are able to live, as far as is reasonably practicable, independently at home or in their community",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"target","increase/ maintain/ decrease"]
[null,"baseline","first figure collected",null,null,"percentage of adults supported at home who agreed that they are supported to live as independently as possible",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.1]
[null,"current","latest available NHSH figure",null,null,"target","increase",null,"baseline",0.84,null,"current",0.85,null,"benchmark",0.84,null,"data",null,null,"compare"]
[null,"benchmark","scottish average by NHS board",null,null,"source: biennial National Health  & Care Experience Survey 2015 - 2016. Scottish Government"]
[null,"data","graph data series where available. Click on the red, amber or green arrow icon for the trend graph and supporting evidence.",null,null,"percentage of adults supported at home who agree that they had a say in in how their help, care or support was provided",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2000000000000002]
[null,null,null,null,null,"target","increase",null,"baseline",0.77,null,"current",0.79,null,"benchmark",0.79,null,"data",null,null,"compare"]
[null,null,null,null,null,"source: biennial National Health  & Care Experience Survey 2015 - 2016. Scottish Government"]
[null,null,null,null,null,"readmission to hospital within 28 days per 100 000 population",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2999999999999998]
[null,"compare","comparisons are to NHS Moray, Angus, Borders, Argyll & Bute and Dumfries and Galloway where like for like data exists. If not,               displayed",null,null,"target","decrease",null,"baseline",89,null,"current",107,null,"benchmark",81.7,null,"data",null,null,"compare"]
[null,null,null,null,null,"source: annual national indicator produced by ISD.  NI-14 update for 2015-16, Highland reduced to 84."]
[null,null,null,null,null,"proportion of last six months of life spent at home or in a community setting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4]
[null,null,null,null,null,"target","increase",null,"baseline",0.9,null,"current",0.9,null,"benchmark",0.87,null,"data",null,null,"compare"]
[]
[null,null,null,null,null,"percentage of people aged 65 years + with intensive needs receiving care at home",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.7]
[null,null,null,null,null,"target","N/A",null,"baseline",1455,null,"current",1585,null,"benchmark",915,null,"data",null,null,"compare"]
[]
[null,null,null,null,null,"percentage of health and social care resource spent on hospital stays where the patient was admitted in an emergency",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.8]
[null,null,null,null,null,"target","decrease",null,"baseline",0.23,null,"current",null,null,"benchmark",0.22,null,"data",null,null,"compare"]
[null,null,null,null,null,"source: Annual ISD NI-20. 2015 - 2016 update pending"]
[null,null,null,null,null,"percentage of people admitted to hospital from home during the year who are discharged to a care home",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.9]
[null,null,null,null,null,"target","N/A",null,"baseline",0.23,null,"current",null,null,"benchmark",0.22,null,"data",null,null,"compare"]
[null,null,null,null,null,"Annual National Indicator under development (ISD)"]
[null,null,null,null,null,"percentage of people who are discharged from hospital within 72 hours of being ready",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.1]
[null,null,null,null,null,"target",null,null,"baseline",null,null,"current",null,null,"benchmark",null,null,"data",null,null,"compare"]
[null,null,null,null,null,"Annual National Indicator under development (ISD)"]
[null,null,null,null,null,"expenditure on end of life care",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.11]
[null,null,null,null,null,"target",null,null,"baseline",null,null,"current",null,null,"benchmark",null,null,"data",null,null,"compare"]
[null,null,null,null,null,"Annual National Indicator under development (ISD)"]
[null,null,null,null,null,"Uptake of SDS option 1 (Direct Payments)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.12A"]
[null,null,null,null,null,"target","increase",null,"baseline",417,null,"current",418,null,"benchmark",null,null,"data",null,null,"compare"]
[null,null,null,null,null,"option 1 (direct payments)  cumulative total for year 418 at December 2016"]
[null,null,null,null,null,"Uptake of SDS option 2 (ISF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.12B"]
[null,null,null,null,null,"target","increase",null,"baseline",145,null,"current",175,null,"benchmark",null,null,"data",null,null,"compare"]
[null,null,null,null,null,"option 2(ISF)  cumulative total for year 175 at December 2016"]
[null,null,null,null,null,"Uptake of SDS option 3 (traditional service)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.12C"]
[null,null,null,null,null,"target","increase",null,"baseline",4541,null,"current",null,null,"benchmark",null,null,"data",null,null,"compare"]
[null,null,null,null,null,"Option 3, number of people recieving a traditional service (excludes some services where data is not available) December 2016 number increased from baseline"]
[null,null,null,null,null,"Uptake of SDS option 4 (mixed 1,2,3,4)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.12D"]
[null,null,null,null,null,"target","increase",null,"baseline",120,null,"current",null,null,"benchmark",null,null,"data",null,null,"compare"]
[null,null,null,null,null,"Option 4, number of people recieving a mix of 1,2,3. December 2016 number increased from baseline"]
[]
[]
[null,null,null,null,null,"Age on admission to long term residential and nursing care",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.13]
[null,null,null,null,null,"target",null,null,"baseline",0.79,null,"current",null,null,"benchmark",0.81,null,"data",null,null,"compare"]
[null,null,null,null,null,"source: annual care home census completed by ISD (all adults) based on mean age at admission of 2016 residents."]
[null,null,null,null,null,"length of stay in long term residential and nursing care",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.14]
[null,null,null,null,null,"target","decrease",null,"baseline","2.5 years",null,"current",null,null,"benchmark","2.3 years",null,"data",null,null,"compare"]
[null,null,null,null,null,"source: annual care home census completed by ISD (all adults) based on mean average length of stay of 2016 residents."]
[null,null,null,null,null,"telecare indicator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.15]
[null,null,null,null,null,"target",null,null,"baseline",2478,null,"current",null,null,"benchmark",2635,null,"data",null,null,"compare"]
[null,null,null,null,null,"indicator under development"]
[]
[null,null,null,null,null,"return to main"]

{"sheet":"outcome 3","index":6,"n_rows":58,"n_cols":27,"rows_kept":58,"cut":false,"hidden":false,"merged":[[53,5,53,24],[56,5,56,24],[47,5,47,24],[50,5,50,24],[20,4,44,4],[32,5,32,24],[34,5,34,24],[35,5,35,24],[38,5,38,24],[41,5,41,24],[44,5,44,24],[25,5,25,24],[25,28,26,28],[26,5,26,24],[28,5,28,24],[29,5,29,24],[31,5,31,24],[19,28,20,28],[20,5,20,24],[22,5,22,24],[22,28,23,28],[23,5,23,24],[9,1,9,2],[9,5,9,24],[11,5,11,24],[11,28,12,28],[13,5,13,24],[13,28,14,28],[14,1,17,1],[14,2,17,2],[14,5,14,24],[15,28,16,28],[16,5,16,24],[17,5,17,24],[17,28,18,28],[18,1,23,1],[18,2,23,2],[19,5,19,24],[9,28,10,28],[10,4,10,24],[1,4,2,21],[1,22,5,28],[3,4,3,21],[4,4,4,6],[4,8,4,12],[6,11,6,12],[6,8,6,9],[6,14,6,15],[6,17,6,18],[6,20,6,21],[6,23,6,24],[6,26,6,27]]}
[]
[null,null,null,null,"Health & Wellbeing Adult Social Care Balanced Scorecard "]
[]
[null,null,null,null,"V6.0 APRIL 2019"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"outcome 3"]
[]
[]
[null,"legend",null,null,null,"people who use health and social care services have positive experiences of those services and have their dignity respected",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"target","increase/ maintain/ decrease"]
[null,"baseline","first figure collected",null,null,"percentage of adults supported at home who agreed that their health and care services seem to be well co-ordinated",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.1]
[null,"current","latest available NHSH figure",null,null,"target","increase",null,"baseline",0.76,null,"current",null,null,"benchmark",0.75,null,"data",null,null,"compare"]
[null,"benchmark","scottish average by NHS board"]
[null,"data","graph data series where available. Click on the red, amber or green arrow icon for the trend graph and supporting evidence.",null,null,"percentage of adults receiving care or support who rate it as excellent or good",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.2]
[null,null,null,null,null,"target","increase",null,"baseline",0.83,null,"current",0.83499999999999996,null,"benchmark",0.81,null,"data",null,null,"compare"]
[]
[null,null,null,null,null,"percentage of people with a positive experience of the care provided by their GP practice",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.3]
[null,"compare","comparisons are to NHS Moray, Angus, Borders, Argyll & Bute and Dumfries and Galloway where like for like data exists. If not,               displayed",null,null,"target","maintain",null,"baseline",0.89,null,"current",0.89,null,"benchmark",0.87,null,"data",null,null,"compare"]
[]
[null,null,null,null,"CARE HOME GRADING STANDARDS","proportion of care services graded \"good\" (4) or better in Care Inspectorate inspections  and proportion graded 5 or above",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.4A"]
[null,null,null,null,null,"target","increase",null,"baseline",0.76800000000000002,null,"current",0.78,null,"benchmark",0.83,null,"data",null,null,"compare"]
[]
[null,null,null,null,null,"care homes with grade 4 or above, independent sector",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.4B"]
[null,null,null,null,null,"target","increase",null,"baseline",0.78600000000000003,null,"current",null,null,"benchmark",null,null,"data",null,null,"compare"]
[]
[null,null,null,null,null,"care homes with grade 4 or above, in-house",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.4C"]
[null,null,null,null,null,"target","increase",null,"baseline",0.82399999999999995,null,"current",null,null,"benchmark",null,null,"data",null,null,"compare"]
[]
[null,null,null,null,null,"care homes with grade 5 or above, independent sector",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.4D"]
[null,null,null,null,null,"target","increase",null,"baseline",0.35699999999999998,null,"current",null,null,"benchmark",null,null,"data",null,null,"compare"]
[]
[null,null,null,null,null,"care homes with grade 5 or above, in-house",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.4E"]
[null,null,null,null,null,"target","increase",null,"baseline",0.29399999999999998,null,"current",null,null,"benchmark",null,null,"data",null,null,"compare"]
[]
[null,null,null,null,null,"care at home with grade 4 or above, independent sector",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.4F"]
[null,null,null,null,null,"target","increase",null,"baseline",0.88200000000000001,null,"current",null,null,"benchmark",null,null,"data",null,null,"compare"]
[]
[null,null,null,null,null,"care at home with grade 4 or above, in-house",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.4G"]
[null,null,null,null,null,"target","N/A",null,"baseline",null,null,"current",null,null,"benchmark",null,null,"data",null,null,"compare"]
[]
[null,null,null,null,null,"care at home with grade 5 or above, independent sector",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.4H"]
[null,null,null,null,null,"target","increase",null,"baseline",0.35299999999999998,null,"current",0.45,null,"benchmark",null,null,"data",null,null,"compare"]
[]
[null,null,null,null,null,"care at home with grade 5 or above, in-house",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.4I"]
[null,null,null,null,null,"target","increase",null,"baseline",null,null,"current",null,null,"benchmark",null,null,"data",null,null,"compare"]
[]
[null,null,null,null,null,"People with a visual Impairment who have undergone an assessment, confirm an understanding of their condition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.5A"]
[null,null,null,null,null,"target",0.9,null,"baseline",0.9,null,"current",0.96,null,"benchmark",null,null,"data",null,null,"compare"]
[]
[null,null,null,null,null,"People with a hearing Impairment who have undergone an assessment, confirm an understanding of their condition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.5B"]
[null,null,null,null,null,"target",0.9,null,"baseline",0.9,null,"current",0.65,null,"benchmark",null,null,"data",null,null,"compare"]
[]
[null,null,null,null,null,"People with a visual Impairment who have undergone an assessment, confirm information on their condition was available and accessible",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.6A"]
[null,null,null,null,null,"target",0.9,null,"baseline",0.9,null,"current",0.96,null,"benchmark",null,null,"data",null,null,"compare"]
[]
[null,null,null,null,null,"People with a hearing Impairment who have undergone an assessment, confirm information on their condition was available and accessible",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.6B"]
[null,null,null,null,null,"target",0.9,null,"baseline",0.9,null,"current",0.56999999999999995,null,"benchmark",null,null,"data",null,null,"compare"]

{"sheet":"outcome 4","index":7,"n_rows":25,"n_cols":27,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,4,2,21],[1,22,5,28],[3,4,3,21],[4,4,4,6],[4,8,4,12],[6,23,6,24],[6,26,6,27],[9,1,9,2],[9,5,9,24],[9,28,10,28],[10,4,10,24],[6,5,6,6],[6,8,6,9],[6,14,6,15],[6,17,6,18],[6,20,6,21],[11,5,11,24],[11,28,12,28],[13,5,13,24],[13,28,14,28],[14,1,17,1],[14,2,17,2],[14,5,14,24],[15,28,16,28],[16,5,16,24],[17,5,17,24],[17,28,18,28],[18,1,23,1],[18,2,23,2],[19,5,19,24],[19,28,20,28],[20,5,20,24],[22,5,22,24],[22,28,23,28],[23,5,23,24],[44,5,44,24],[25,5,25,24],[25,28,26,28],[26,5,26,24],[28,5,28,24],[29,5,29,24],[31,5,31,24],[27,5,27,9],[32,5,32,24],[34,5,34,24],[35,5,35,24],[38,5,38,24],[41,5,41,24]]}
[]
[null,null,null,null,"Health & Wellbeing Adult Social Care Balanced Scorecard "]
[]
[null,null,null,null,"V6.O APRIL 2019"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"outcome 4"]
[]
[]
[null,"legend",null,null,null,"health and social care services are centred on helping people to maintain or improve the quality of life of people who use these services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"target","increase/ maintain/ decrease"]
[null,"baseline","first figure collected",null,null,"Delayed hospital discharges for service users residing within areas covered by Independent Sector Care at Home providers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.0999999999999996]
[null,"current","latest available NHSH figure",null,null,"target","increase",null,"baseline",null,null,"current",null,null,"benchmark",null,null,"data",null,null,"compare"]
[null,"benchmark","scottish average by NHS board"]
[null,"data","graph data series where available. Click on the red, amber or green arrow icon for the trend graph and supporting evidence.",null,null,"People perceive themselves to be socially and geographically connected",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.2]
[null,null,null,null,null,"target","increase",null,"baseline",null,null,"current",null,null,"benchmark",null,null,"data",null,null,"compare"]
[]
[null,null,null,null,null,"Emergency bed day rate (per 100,000 population)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.3]
[null,"compare","comparisons are to NHS Moray, Angus, Borders, Argyll & Bute and Dumfries and Galloway where like for like data exists. If not,               displayed",null,null,"target","increase",null,"baseline",118016,null,"current",105551,null,"benchmark",126429,null,"data",null,null,"compare"]
[]
[null,null,null,null,null,"Falls rate per 1,000 population aged 65+",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.4000000000000004]
[null,null,null,null,null,"target","decrease",null,"baseline",0.193,null,"current",0.151,null,"benchmark",0.16300000000000001,null,"data",null,null,"compare"]
[]
[null,null,null,null,null,"Percentage of adults supported at home who agree that their services and support had an impact on improving or maintaining their quality of life",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5]
[null,null,null,null,null,"target","increase",null,"baseline",0.82,null,"current",86.7,null,"benchmark",0.84299999999999997,null,"data",null,null,"compare"]

{"sheet":"outcome 5","index":8,"n_rows":28,"n_cols":27,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,5,27,9],[1,4,2,21],[1,22,5,28],[3,4,3,21],[4,4,4,6],[4,8,4,12],[6,23,6,24],[6,26,6,27],[11,5,11,24],[11,28,12,28],[13,5,13,24],[13,28,14,28],[25,5,25,24],[25,28,26,28],[26,5,26,24],[9,1,9,2],[9,5,9,24],[9,28,10,28],[10,4,10,24],[6,5,6,6],[6,8,6,9],[6,17,6,18],[6,20,6,21],[14,1,17,1],[14,2,17,2],[14,5,14,24],[15,28,16,28],[16,5,16,24],[17,5,17,24],[17,28,18,28],[18,1,23,1],[18,2,23,2],[19,5,19,24],[19,28,20,28],[20,5,20,24],[22,5,22,24],[22,28,23,28],[23,5,23,24]]}
[]
[null,null,null,null,"Health & Wellbeing Adult Social Care Balanced Scorecard "]
[]
[null,null,null,null,"V6.0 APRIL 2019"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"outcome 5"]
[]
[]
[null,"legend",null,null,null,"health and social care services contribute to reducing health inequalities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"target","increase/ maintain/ decrease"]
[null,"baseline","first figure collected",null,null,"Premature mortality rate (per 1000 population)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.0999999999999996]
[null,"current","latest available NHSH figure",null,null,"target","decrease",null,"baseline",392,null,"current",373,null,"benchmark",441,null,"data",null,null,"compare"]
[null,"benchmark","scottish average by NHS board",null,null,"Annual National Indicator produced by ISD NI-11 - Integration Outcome, baseline 2015"]
[null,"data","graph data series where available. Click on the red, amber or green arrow icon for the trend graph and supporting evidence.",null,null,"People who have dementia will receive an early diagnosis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.2]
[null,null,null,null,null,"target","increase",null,"baseline",2416,null,"current",null,null,"benchmark",null,null,"data",null,null,"compare"]
[null,null,null,null,null,"Local Indicator - monthly - last reported position was 2168 as at March 2017, update for Qtr 1 (June) is 2178"]
[null,null,null,null,null,"The number of people with learning disabilities who are in further education",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.3]
[null,"compare","comparisons are to NHS Moray, Angus, Borders, Argyll & Bute and Dumfries and Galloway where like for like data exists. If not,               displayed",null,null,"target","increase",null,"baseline",9.2999999999999999E-2,null,"current",null,null,"benchmark",7.5999999999999998E-2,null,"data",null,null,"compare"]
[null,null,null,null,null,"National SCLD dataset from e-Say return, baseline 2015 report published 10/8/16"]
[null,null,null,null,null,"Deliver faster access to mental health services and 18 weeks referral to treatment for Psychological Therapies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.4]
[null,null,null,null,null,"target","increase",null,"baseline",0.8,null,"current",0.86,null,"benchmark",null,null,"data",null,null,"compare"]
[null,null,null,null,null,"Local Indicator - monthly - baseline March 2016current position June 2017 86% under target and declining position on March 2017"]
[null,null,null,null,null,"The time taken to access drug or alcohol treatment services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.5]
[null,null,null,null,null,"target","decrease",null,"baseline",0.77,null,"current",0.78800000000000003,null,"benchmark",null,null,"data",null,null,"compare"]
[null,null,null,null,null,"Local Indicator - quarterly - last reported position was 83.6% at December 2016 - March 2017 declining to 78.8%"]
[]
[null,null,null,null,null,"return to main"]

{"sheet":"outcome 6","index":9,"n_rows":25,"n_cols":27,"rows_kept":25,"cut":false,"hidden":false,"merged":[[6,26,6,27],[6,5,6,6],[6,8,6,9],[6,17,6,18],[6,20,6,21],[6,23,6,24],[1,4,2,21],[1,22,5,28],[3,4,3,21],[4,4,4,6],[4,8,4,12],[9,1,9,2],[9,5,9,24],[9,28,10,28],[10,4,10,24],[13,5,13,24],[13,28,14,28],[14,1,17,1],[14,2,17,2],[14,5,14,24],[15,28,16,28],[16,5,16,24],[17,5,17,24],[17,28,18,28],[18,1,23,1],[11,5,11,24],[11,28,12,28],[25,5,25,24],[25,28,26,28],[26,5,26,24],[18,2,23,2],[19,5,19,24],[19,28,20,28],[20,5,20,24],[22,5,22,24],[22,28,23,28],[23,5,23,24]]}
[]
[null,null,null,null,"Health & Wellbeing Adult Social Care Balanced Scorecard "]
[]
[null,null,null,null,"V6.0 APRIL 2019"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"outcome 6"]
[]
[]
[null,"legend",null,null,null,"people who provide unpaid care are supported to look after their own health and wellbeing, including to reduce any negative impact of their caring role on their own health and wellbeing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,"target","increase/ maintain/ decrease"]
[null,"baseline","first figure collected",null,null,"Percentage of carers who feel supported to continue in their caring role",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.1]
[null,"current","latest available NHSH figure",null,null,"target","increase",null,"baseline",0.37,null,"current",0.38,null,"benchmark",0.39,null,"data",null,null,"compare"]
[null,"benchmark","scottish average by NHS board",null,null,"Annual ISD NI-8- Integration Outcome2015/16 baseline - Q45e 2014/15 Health and Care Experience Survey"]
[null,"data","graph data series where available. Click on the red, amber or green arrow icon for the trend graph and supporting evidence.",null,null,"Adult Protection Plans are reviewed in accordance with Adult Support and Protection (ASP) Procedures ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.2]
[null,null,null,null,null,"target","increase",null,"baseline",1,null,"current",91.9,null,"benchmark",null,null,"data",null,null,"compare"]
[]
[null,null,null,null,null,"Reviewing and monitoring of Guardianships. Number of Guardianships reviewed within required timescale.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.3]
[null,"compare","comparisons are to NHS Moray, Angus, Borders, Argyll & Bute and Dumfries and Galloway where like for like data exists. If not,               displayed",null,null,"target","increase",null,"baseline",0.5,null,"current",0.49299999999999999,null,"benchmark",null,null,"data",null,null,"compare"]
[]
[null,null,null,null,null,"Reviewing and monitoring of Guardianships. Number of New Guardianships reviewed within required timescale of 3 months.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.4]
[null,null,null,null,null,"target","increase",null,"baseline",0.56999999999999995,null,"current",0.28299999999999997,null,"benchmark",null,null,"data",null,null,"compare"]
[]
[null,null,null,null,null,"No indicator allocated",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.5]
[null,null,null,null,null,"target",null,null,"baseline",null,null,"current",null,null,"benchmark",null,null,"data",null,null,"compare"]

{"sheet":"outcome 7","index":10,"n_rows":25,"n_cols":27,"rows_kept":25,"cut":false,"hidden":false,"merged":[[6,5,6,6],[6,8,6,9],[6,20,6,21],[6,23,6,24],[6,26,6,27],[1,4,2,21],[1,22,5,28],[3,4,3,21],[4,4,4,6],[4,8,4,12],[9,1,9,2],[9,5,9,24],[9,28,10,28],[10,4,10,24],[13,5,13,24],[13,28,14,28],[14,1,17,1],[14,2,17,2],[14,5,14,24],[15,28,16,28],[16,5,16,24],[17,5,17,24],[17,28,18,28],[18,1,23,1],[11,5,11,24],[11,28,12,28],[25,5,25,24],[25,28,26,28],[26,5,26,24],[18,2,23,2],[19,5,19,24],[19,28,20,28],[20,5,20,24],[22,5,22,24],[22,28,23,28],[23,5,23,24]]}
[]
[null,null,null,null,"Health & Wellbeing Adult Social Care Balanced Scorecard "]
[]
[null,null,null,null,"V6.0 APRIL 2019"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"outcome 7"]
[]
[]
[null,"legend",null,null,null,"People using health and social care services are safe from harm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,"target","increase/ maintain/ decrease"]
[null,"baseline","first figure collected",null,null,"Percentage of adults supported at home who agree they felt safe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.1]
[null,"current","latest available NHSH figure",null,null,"target","increase",null,"baseline",0.86,null,"current",null,null,"benchmark",0.84,null,"data",null,null,"compare"]
[null,"benchmark","scottish average by NHS board",null,null,"Biennial National Health and Care Experience Survey NI-9 (local survey TBD)2015/16 baseline - Q36h 2014/15 Health and Care Experience Survey "]
[null,"data","graph data series where available. Click on the red, amber or green arrow icon for the trend graph and supporting evidence.",null,null,"Adult Protection Plans are reviewed in accordance with Adult Support and Protection (ASP) Procedures",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.2]
[null,null,null,null,null,"target","increase",null,"baseline",1,null,"current",91.9,null,"benchmark",null,null,"data",null,null,"compare"]
[null,null,null,null,null,"Local indicator, baseline is April-September 20152016/17,  91.9% current position though this may be amended once further 9 reviews are completed.  Above target"]
[null,null,null,null,null,"Reviewing and monitoring of Guardianships. Number of Guardianships reviewed within required timescale.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7.3A"]
[null,"compare","comparisons are to NHS Moray, Angus, Borders, Argyll & Bute and Dumfries and Galloway where like for like data exists. If not,               displayed",null,null,"target",null,null,"baseline",0.5,null,"current",0.49299999999999999,null,"benchmark",null,null,"data",null,null,"compare"]
[null,null,null,null,null,"Local Annual indicator - baseline 2015/16 March 2016/17 update 49.3%"]
[null,null,null,null,null,"Reviewing and monitoring of Guardianships. Number of New Guardianships reviewed within required timescale of 3 months.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7.3B"]
[null,null,null,null,null,"target",null,null,"baseline",0.56999999999999995,null,"current",0.28299999999999997,null,"benchmark",null,null,"data",null,null,"compare"]
[null,null,null,null,null,"Local Annual indicator - baseline 2015/16March 2016/17 "]
[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.5]
[null,null,null,null,null,"target",null,null,"baseline",null,null,"current",null,null,"benchmark",null,null,"data",null,null,"compare"]

{"sheet":"outcome 8","index":11,"n_rows":29,"n_cols":27,"rows_kept":29,"cut":false,"hidden":false,"merged":[[6,5,6,6],[6,8,6,9],[6,23,6,24],[6,26,6,27],[1,4,2,21],[1,22,5,28],[3,4,3,21],[4,4,4,6],[4,8,4,12],[9,1,9,2],[9,5,9,24],[9,28,10,28],[10,4,10,24],[11,5,11,24],[11,28,12,28],[13,5,13,24],[13,28,14,28],[14,1,17,1],[14,2,17,2],[14,5,14,24],[15,28,16,28],[16,5,16,24],[17,5,17,24],[17,28,18,28],[18,1,23,1],[25,5,25,24],[25,28,26,28],[26,5,26,24],[28,5,28,24],[18,2,23,2],[19,5,19,24],[19,28,20,28],[20,5,20,24],[22,5,22,24],[22,28,23,28],[23,5,23,24]]}
[]
[null,null,null,null,"Health & Wellbeing Adult Social Care Balanced Scorecard "]
[]
[null,null,null,null,"V6.0 APRIL 2019"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"outcome 8"]
[]
[]
[null,"legend",null,null,null,"People who work in health & social care services feel engaged with the work they do and are supported to continuously improve the information, support care and treatment they provide",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,"target","increase/ maintain/ decrease"]
[null,"baseline","first figure collected",null,null,"Percentage of staff who say they would recommend their workplace as a good place to work",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.1]
[null,"current","latest available NHSH figure",null,null,"target","increase",null,"baseline",null,null,"current",null,null,"benchmark",null,null,"data",null,null,"compare"]
[null,"benchmark","scottish average by NHS board",null,null,"Annual National Indicator produced by ISD under development"]
[null,"data","graph data series where available. Click on the red, amber or green arrow icon for the trend graph and supporting evidence.",null,null,"Workforce is Adult Support and Protection effectively trained",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.1999999999999993]
[null,null,null,null,null,"target","increase",null,"baseline",null,null,"current",null,null,"benchmark",null,null,"data",null,null,"compare"]
[null,null,null,null,null,"Local annual indicator baseline is 1st year 2015/16 (1158 of 1158 people trained reported higher confidence)2016/17 1,411 people trained, 1,205 commented 99% felt more confident"]
[null,null,null,null,null,"Sensory Impairment - Awareness Raising  percentage of staff, across all sectors, impacted positively by taking up training - face to face or through LearnPro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.3000000000000007]
[null,"compare","comparisons are to NHS Moray, Angus, Borders, Argyll & Bute and Dumfries and Galloway where like for like data exists. If not,               displayed",null,null,"target","100 annual",null,"baseline",1,null,"current",1,null,"benchmark",null,null,"data",null,null,"compare"]
[null,null,null,null,null,"Local Annual Indicator -  baseline 2015/16 (184 of 184 people)2016/17 update 104/104 trainees 100%"]
[null,null,null,null,null,"Employee engagement index (from iMatters)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.4]
[null,null,null,null,null,"target","increase",null,"baseline",0.76,null,"current",null,null,"benchmark",null,null,"data",null,null,"compare"]
[null,null,null,null,null,"Baseline 2017 based on three cohorts of staff that have been surveyed in NHSH in 2017, two more cohorts due to be surveyed this year so the response rate and EEI could change."]
[null,null,null,null,null,"Uptake of Knowledge and skills Framework",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.5]
[null,null,null,null,null,"target","increase",null,"baseline",0.40799999999999997,null,"current",null,null,"benchmark",null,null,"data",null,null,"compare"]
[null,null,null,null,null,"Based on 'Reviews at all stages excluding A & B'Baseline March 2016 (3622 of 8876 posts), March 2017 38.94% (3739 of 9601 posts)"]
[null,null,null,null,null,"Sickness absence levels",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.6]
[null,null,null,null,null,"target","decrease",null,"baseline",4.9000000000000002E-2,null,"current",null,null,"benchmark",5.1999999999999998E-2,null,"data",null,null,"compare"]
[null,null,null,null,null,"NHSH Operational Units Annual Average Sickness Trends report baseline March 16 (% NHSH Local) Dec 16 update NHSH Local 4.92%, March 2017 4.86%, June 17 is 4.85%"]

{"sheet":"outcome 9","index":12,"n_rows":25,"n_cols":27,"rows_kept":25,"cut":false,"hidden":false,"merged":[[6,5,6,6],[6,8,6,9],[6,26,6,27],[1,4,2,21],[1,22,5,28],[3,4,3,21],[4,4,4,6],[4,8,4,12],[9,1,9,2],[9,5,9,24],[9,28,10,28],[10,4,10,24],[11,5,11,24],[11,28,12,28],[13,5,13,24],[13,28,14,28],[14,1,17,1],[14,2,17,2],[14,5,14,24],[15,28,16,28],[16,5,16,24],[17,5,17,24],[17,28,18,28],[18,1,23,1],[25,5,25,24],[25,28,26,28],[26,5,26,24],[28,5,28,24],[18,2,23,2],[19,5,19,24],[19,28,20,28],[20,5,20,24],[22,5,22,24],[22,28,23,28],[23,5,23,24]]}
[]
[null,null,null,null,"Health & Wellbeing Adult Social Care Balanced Scorecard "]
[]
[null,null,null,null,"V6.0 APRIL 2019"]
[]
[]
[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,"outcome 9"]
[]
[]
[null,"legend",null,null,null,"resources are used effectively and efficiently in the provision of health and social care",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,"target","increase/ maintain/ decrease"]
[null,"baseline","first figure collected",null,null,"NHSH make payment of the care at home tariff rate within 28 days of receipt of a valid invoice",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.1]
[null,"current","latest available NHSH figure",null,null,"target","increase",null,"baseline",0.83299999999999996,null,"current",0.89300000000000002,null,"benchmark",null,null,"data",null,null,"compare"]
[null,"benchmark","scottish average by NHS board"]
[null,"data","graph data series where available. Click on the red, amber or green arrow icon for the trend graph and supporting evidence.",null,null,"Care at home costs per hour for people aged 65 or over",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.1999999999999993]
[null,null,null,null,null,"target","decrease",null,"baseline",null,null,"current",null,null,"benchmark",null,null,"data",null,null,"compare"]
[]
[null,null,null,null,null,"Self Directed Support  (option 1) spend on people aged 18 or over as a % of total social work spend on adults",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.3000000000000007]
[null,"compare","comparisons are to NHS Moray, Angus, Borders, Argyll & Bute and Dumfries and Galloway where like for like data exists. If not,               displayed",null,null,"target","increase",null,"baseline",null,null,"current",null,null,"benchmark",null,null,"data",null,null,"compare"]
[]
[null,null,null,null,null,"Net Residential costs per Capita per week for Older Persons (over 65)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4]
[null,null,null,null,null,"target","decrease",null,"baseline",null,null,"current",null,null,"benchmark",null,null,"data",null,null,"compare"]
[]
[null,null,null,null,null,"Creation of additional capacity  for Care at home in independent sector throughout NHS North Highland",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.5]
[null,null,null,null,null,"target","increase",null,"baseline",null,null,"current",null,null,"benchmark",null,null,"data",null,null,"compare"]

{"sheet":"lists","index":13,"n_rows":180,"n_cols":12,"rows_kept":180,"cut":false,"hidden":false,"merged":[[113,16,114,24],[4,2,4,4],[41,7,41,12],[55,7,55,14],[20,6,20,13],[21,7,21,12],[30,6,30,11],[31,7,31,12],[40,6,40,10],[44,4,45,4],[47,4,48,4],[59,4,61,4],[62,4,63,4],[74,4,76,4],[77,4,79,4],[86,4,88,4],[92,4,94,4],[95,4,97,4],[125,4,127,4],[137,4,139,4],[149,4,151,4]]}
[]
[]
[]
[]
[null,null,"All Macros in workbook. Tested and working 10.2018. Not included in online copy. ",null,null,null,"userform template"]
[null,null,"Name","code","function",null,"name","as indicator, spelled (e.g. ninepointone)"]
[null,1,"Button1_Click","Sub Button1_Click()","opens comment form userform \"comment\"",null,"backcolour","Window Background &8000000H&"]
[null,null,null,"comment.Show",null,null,"caption","indicator numeric (e.g. indicator 9.1)"]
[null,null,null,"End Sub",null,null,"height",384.75]
[null,2,"Outcome2_Picture11_Click","Sub outcome2_Picture11_Click()\ntwopointfour.Show\nEnd Sub\nSub outcome2_Picture4_Click()\ntwopointeight.Show\nEnd Sub\nSub outcome3_Picture7_Click()\nthreepointfourA.Show\nEnd Sub","opens userform and command buttons for graphs",null,"specialeffect","0-fm SpecialEffectFlat"]
[null,3,"Outcome2_Picure4_Click","Private Sub CommandButton1_Click()\ngraph14.Show\nEnd Sub\n\nPrivate Sub CommandButton2_Click()\ngraph15.Show\nEnd Sub\n\nPrivate Sub CommandButton3_Click()\ngraph16.Show\nEnd Sub\n\nPrivate Sub CommandButton4_Click()\nNI20201718.Show\nEnd Sub\n","opens userform and command buttons for graphs",null,"width",690]
[null,4,"Outcome2_Picture58_Click","Sub outcome2_Picture8_Click()\nNI13.Show\nEnd Sub\nSub Picture13_Click()\nNI14.Show\nEnd Sub\nSub Picture57_Click()\nNI15.Show\nEnd Sub\nSub outcome2_Picture58_Click()\nNI19.Show\nEnd Sub\n","opens comparison graphs NI13, NI14, NI15, NI19. ",null,"all others as default"]
[null,5,"Outcome2_Picture7_Click","Sub outcome2_Picture7_Click()\nspark2.Show\nEnd Sub\nSub Picture8_Click()\nNI3.Show\nEnd Sub\nSub Picture20_Click()\nNI4.Show\nEnd Sub","opens comparison graphs Spark2, NI13, NI14"]
[null,6,"Outcome2_Picture8_Click","Sub outcome2_Picture8_Click()\nNI13.Show\nEnd Sub\nSub Picture13_Click()\nNI14.Show\nEnd Sub\nSub Picture57_Click()\nNI15.Show\nEnd Sub\nSub outcome2_Picture58_Click()\nNI19.Show\nEnd Sub","opens comparison graphs NI13,NI14, NI15, NI19",null,"frame template"]
[null,7,"Outcome2_RightArrow10_Click","Sub Picture1_Click()\ntwopointone.Show\nEnd Sub\nSub outcome2_RightArrow10_Click()\ntwopointtwo.Show\nEnd Sub","opens userform and command buttons for graphs",null,"backcolour","&H80000005&"]
[null,8,"Outcome3_Picture19_Click","Sub Picture6_Click()\nNI19.Show\nEnd Sub\nSub Picture10_Click()\nNI5.Show\nEnd Sub\nSub Picture11_Click()\nNI6.Show\nEnd Sub\nSub outcome3_Picture19_Click()\nNI17.Show\nEnd Sub\nSub outcome4_Picture7_Click()\nNI13.Show\nEnd Sub\nSub outcome4_Picture8_Click()\nNI16.Show\nEnd Sub\nSub Picture38_Click()\nNI8.Show\nEnd Sub\nSub outcome7_Picture1_Click()\nNI11.Show\nEnd Sub","opens comparison graphs NI19, NI15, NI6, NI17, NI13, NI16, NI8, NI11",null,"borderstyle","none"]
[null,9,"Outcome3_Picture7_Click","Sub outcome2_Picture11_Click()\ntwopointfour.Show\nEnd Sub\nSub outcome2_Picture4_Click()\ntwopointeight.Show\nEnd Sub\nSub outcome3_Picture7_Click()\nthreepointfourA.Show\nEnd Sub\n","opens userform and command buttons for graphs",null,"height",354]
[null,10,"Outcome4_Picture7_click","Sub Picture6_Click()","opens comparison graphs NI19, NI5, NI6, NI17, NI13, NI16, NI8, NI11.",null,"specialeffect","0-fm-Special Effect Flat"]
[null,null,null,"NI19.Show",null,null,"width",672]
[null,null,null,"End Sub"]
[null,null,null,"Sub Picture10_Click()",null,null,"graph image template"]
[null,null,null,"NI5.Show",null,null,"name","graph and indicator number, no spaces or seperators"]
[null,null,null,"End Sub",null,null,"backcolour","&H80000005&"]
[null,null,null,"Sub Picture11_Click()",null,null,"borderstyle","none"]
[null,null,null,"NI6.Show",null,null,"height",240]
[null,null,null,"End Sub",null,null,"picture","displays only as bitmap, but is JPEG file "]
[null,null,null,"Sub outcome3_Picture19_Click()",null,null,"picturesizemode","1-fmPictureSizeModeStretch"]
[null,null,null,"NI17.Show",null,null,"specialeffect","0-fm-Special Effect Flat"]
[null,null,null,"End Sub",null,null,"width",462]
[null,null,null,"Sub outcome4_Picture7_Click()"]
[null,null,null,"NI13.Show",null,null,"traffic light image template"]
[null,null,null,"End Sub",null,null,"name","none"]
[null,null,null,"Sub outcome4_Picture8_Click()",null,null,"backcolour","&H80000005&"]
[null,null,null,"NI16.Show",null,null,"borderstyle","none"]
[null,null,null,"End Sub",null,null,"height",78]
[null,null,null,"Sub Picture38_Click()",null,null,"picture","displays only as bitmap, but is JPEG file "]
[null,null,null,"NI8.Show",null,null,"picturesizemode","1-fmPictureSizeModeStretch"]
[null,null,null,"End Sub",null,null,"specialeffect","0-fm-Special Effect Flat"]
[null,null,null,"Sub outcome7_Picture1_Click()",null,null,"width",36]
[null,null,null,"NI11.Show"]
[null,null,null,"End Sub",null,null,"label \"national indicator\" template"]
[null,11,"Outcome4_Picture8_Click","Sub outcome4_Picture8_Click()","opens graph NI16",null,"name"]
[null,null,null,"NI16.Show",null,null,"backcolour","&H80000005&"]
[null,null,null,"End Sub",null,null,"borderstyle","none"]
[null,12,"Outcome5_Picture19_Click","Sub outcome5_Picture19_Click()","opens indicator 5.1 and command buttons for graphs",null,"caption","indicator numeric (e.g. indicator 9.1)"]
[null,null,null,"fivepointone.Show",null,null,"font","tahoma"]
[null,null,null,"End Sub",null,null,"height",36]
[null,13,"Outcome6_Picture19_Click","Sub outcome6_Picture19_Click()","opens indicator 6.1 and command buttons for graphs",null,"left",474]
[null,null,null,"sixpointone.Show",null,null,"specialeffect","0-fm-Special Effect Flat"]
[null,null,null,"End Sub",null,null,"textalign","3-fm-alignright"]
[null,14,"Outcome7_Picture1_Click","Sub outcome7_Picture1_Click()","Opens graph NI11",null,"width",192]
[null,null,null,"NI11.Show"]
[null,null,null,"End Sub",null,null,"radio button template"]
[null,15,"Outcome9_Picture32_2_Click","Sub outcome9_Picture32_2_Click()","Opens Indicator 9.1 ",null,"name","OptionButton1"]
[null,null,null,"ninepointone.Show",null,null,"backcolour","&H80000005&"]
[null,null,null,"End Sub",null,null,"caption","source data is here/ local data is here/ definition is here"]
[null,16,"Outcome9_Picture32_Click","Sub outcome9_Picture32_Click()",null,null,"font","tahoma"]
[null,null,null,"pic54.Show",null,null,"height",18]
[null,null,null,"End Sub",null,null,"specialeffect","2-fm-ButtonSunkenEffect"]
[null,17,"Picture1_Click","Sub Picture1_Click()","Opens Indicator 2.1, command buttons and hyperlinked radio buttons",null,"textalign","2-fm-alignLeft"]
[null,null,null,"twopointone.Show",null,null,"width",114]
[null,null,null,"End Sub",null,null,null,null,null,null,null,"highland"]
[null,18,"Picture10_Click","Sub Picture10_Click()","Opens graph NI5",null,null,null,null,null,null,"moray"]
[null,null,null,"NI5.Show",null,null,null,null,null,null,null,"angus"]
[null,null,null,"End Sub",null,null,null,null,null,null,null,"dumfries & galloway"]
[null,19,"Picture11_Click","Sub Picture11_Click()","Opens graph NI6",null,null,null,null,null,null,"scottish borders"]
[null,null,null,"NI6.Show",null,null,null,null,null,null,null,"argyle & bute"]
[null,null,null,"End Sub"]
[null,20,"Picture12_Click","Sub Picture12_Click()","Opens Indicator 2."]
[null,null,null,"twopointseven.Show"]
[null,null,null,"End Sub"]
[null,21,"Picture13_Click","Sub Picture13_Click()","Opens graph NI14"]
[null,null,null,"NI14.Show"]
[null,null,null,"End Sub",null,null,"Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click"]
[null,22,"Picture15_Click","Sub Picture15_Click()","Shows msg \"there is no current comparison or benchmark for this indicator.It may be a local indicator or data collected differently\"",null,"        Dim xlApp As Excel.Application"]
[null,null,null,"comparison.Show",null,null,"        xlApp = New Excel.Application"]
[null,null,null,"End Sub",null,null,"        Dim wb As Excel.Workbook"]
[null,23,"Picture16_Click","Sub Picture16_Click()","Shows msg \"there is no current comparison or benchmark for this indicator.It may be a local indicator or data collected differently\"",null,"        With xlApp"]
[null,null,null,"comparison.Show",null,null,"            wb = .Workbooks.Open(\"C:\\Users\\Administrator\\Desktop\\Book1.xlsm\",, True)"]
[null,null,null,"End Sub",null,null,"            .Visible = True"]
[null,24,"Picture17_Click","Sub Picture17_Click()","Opens graph 1.1",null,"            .Run(\"Book1.xlsm!Module1.StartProgram\")"]
[null,null,null,"spark1.Show",null,null,"        End With"]
[null,null,null,"End Sub",null,null,"    End Sub"]
[null,25,"Picture19_Click","Sub Picture19_Click()","Opens graph data family comparison"]
[null,null,null,"spark2.Show"]
[null,null,null,"End Sub"]
[null,26,"Picture2_Click","Sub Picture2_Click()","Shows msg \"there is no current measure attached to this indicator\""]
[null,null,null,"construct.Show"]
[null,null,null,"End Sub"]
[null,27,"Picture20_Click","Sub Picture20_Click()","Opens graph NI4"]
[null,null,null,"NI4.Show"]
[null,null,null,"End Sub"]
[null,28,"Picture22_Click","Sub Picture22_Click()","Opens indicator three plus command buttons"]
[null,null,null,"threepointthree.Show"]
[null,null,null,"End Sub"]
[null,29,"Picture26_Click","Sub Picture26_Click()","Shows msg \"there is no current comparison or benchmark for this indicator.It may be a local indicator or data collected differently\""]
[null,null,null,"comparison.Show"]
[null,null,null,"End Sub"]
[null,30,"Picture28_Click","Sub Picture28_Click()","Opens indicator 6.2"]
[null,null,null,"sixpointtwo.Show"]
[null,null,null,"End Sub"]
[null,31,"Picture 3_Click","Sub Picture3_Click()","Opens Indicator 3.4A"]
[null,null,null,"threepointfourA.Show"]
[null,null,null,"End Sub"]
[null,32,"Picture30_Click","Sub Picture30_Click()","Opens Indicator 6.3"]
[null,null,null,"sixpointthree.Show"]
[null,null,null,"End Sub"]
[null,33,"Picture32_Click","Sub Picture32_Click()","Opens indicator 5.4"]
[null,null,null,"fivepointfour.Show"]
[null,null,null,"End Sub"]
[null,34,"Picture35_Click","Sub Picture35_Click()","Opens indicator 4.3"]
[null,null,null,"fourpointthree.Show"]
[null,null,null,"End Sub"]
[null,35,"Picture36_Click","Sub Picture36_Click()","Opens indicator 4.4"]
[null,null,null,"fourpointfour.Show"]
[null,null,null,"End Sub"]
[null,36,"Picture38_Click","Sub Picture38_Click()","Opens graph NI9"]
[null,null,null,"NI8.Show"]
[null,null,null,"End Sub"]
[null,39,"Picture4_Click","Sub Picture4_Click()","Opens indicator 3.2"]
[null,null,null,"threepointtwo.Show"]
[null,null,null,"End Sub"]
[null,40,"Picture41_Click","Sub Picture41_Click()","Opens indicator 4.5"]
[null,null,null,"fourpointfive.Show"]
[null,null,null,"End Sub"]
[null,41,"Picture5_Click","Sub Picture5_Click()","Shows msg \"no current indicator. It might be discontinued or under construction\""]
[null,null,null,"construct.Show"]
[null,null,null,"End Sub"]
[null,42,"Picture55_Click","Sub Picture55_Click()","Opens indicator 7.3"]
[null,null,null,"sevenpointthreeA.Show"]
[null,null,null,"End Sub"]
[null,43,"Picture56_Click","Sub Picture56_Click()","Opens indicator 2.15"]
[null,null,null,"twopointfifteen.Show"]
[null,null,null,"End Sub"]
[null,44,"Picture57_Click","Sub Picture57_Click()","Opens graph NI5"]
[null,null,null,"NI15.Show"]
[null,null,null,"End Sub"]
[null,45,"Picture58_Click","Sub Picture58_Click()","Opens msg \"there is no current data available for this indicator\""]
[null,null,null,"nodata.Show"]
[null,null,null,"End Sub"]
[null,46,"Picture6_Click","Sub Picture6_Click()","Opens graph NI19"]
[null,null,null,"NI19.Show"]
[null,null,null,"End Sub"]
[null,47,"Picture 62_Click","Sub Picture62_Click()","Opens indicator 8.2"]
[null,null,null,"eightpointtwo.Show"]
[null,null,null,"End Sub"]
[null,48,"Picture69_Click","Sub Picture69_Click()","Opens indicator 8.4"]
[null,null,null,"eightpointfour.Show"]
[null,null,null,"End Sub"]
[null,49,"Picture7_Click","Sub Picture7_Click()","Opens msg \"there is no current measurement attached to this indicator. It may be under construction or discontinued\""]
[null,null,null,"construct.Show"]
[null,null,null,"End Sub"]
[null,50,"Picture72_Click","Sub Picture72_Click()","Opens indicator 8.5"]
[null,null,null,"eightpointfive.Show"]
[null,null,null,"End Sub"]
[null,51,"Picture8_Click","Sub Picture20_Click()","Opens graph NI4"]
[null,null,null,"NI4.Show"]
[null,null,null,"End Sub"]
[null,52,"Picture9_Click","Sub Picture9_Click()","Opens indicator 2.3"]
[null,null,null,"twopointthree.Show"]
[null,null,null,"End Sub"]
[null,53,"RightArrow10_Click","Sub RightArrow10_Click()","Opens indicator 1.3"]
[null,null,null,"indicator1point3.Show"]
[null,null,null,"End Sub"]
[null,54,"RightArrow11_Click","Sub RightArrow11_Click()","Opens indicator 1.4"]
[null,null,null,"indicator1point4.Show"]
[null,null,null,"End Sub"]
[null,55,"RightArrow15_Click","Sub RightArrow15_Click()","Opens indicator 1.5"]
[null,null,null,"indicator1point5.Show"]
[null,null,null,"End Sub"]
[null,56,"RightArrow20_Click","Sub RightArrow20_Click()","Opens indicator 3.1"]
[null,null,null,"threepointone.Show"]
[null,null,null,"End Sub"]
[null,57,"RightArrow26_Click","Sub RightArrow26_Click()"]
[null,null,null,"Rightpic58.Show"]
[null,null,null,"End Sub"]
[null,58,"RightArrow42_Click","Sub RightArrow42_Click()","Opens indicator 6.2"]
[null,null,null,"sixpointtwo.Show"]
[null,null,null,"End Sub"]
[null,59]

{"sheet":"Sheet1","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}