{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Registration","Drop-down responses","ThankYou","Answers"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":3,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[[7,0,7,11],[8,0,8,11],[10,0,10,11],[14,0,14,11],[13,0,13,11],[20,0,20,11],[19,0,19,11],[16,0,16,11],[17,0,17,11],[18,0,18,11]]}
[]
[]
[]
[]
[]
[]
[]
["Notes on authority to consent to the Terms and Conditions"]
["This registration form gathers information on intended use of ASCOT and forms the basis for the licence to access and use ASCOT. This form includes Terms and Conditions (T&C's) which you must read and have obtained agreement from your organisation to consent to in order to obtain the licence.  Please click on the document below to view the T&C's. \n\nYour employer/University will be the Licensee, therefore, the T&C’s must be agreed by someone with authority to consent to these on behalf of the employer/University; you will be asked to provide this person's name during registration and confirm they agree the T&C’s. \n\nIt is your responsibility to ensure that you have sought appropriate authorisation in order to consent to the T&C’s. If you are a student, your supervisor will be able to assist you in identifying who can agree to these T&C’s.          \n"]
[]
["Instructions"]
["Please complete each of the fields in the registration form."]
["Once each field is complete it will display 'Done' in the cell next to it."]
["If you do not have all the details of how you are planning to use ASCOT, please complete all the required fields with as much information as you can at this stage."]
["Please answer all the required questions as any missing or unclear answers may delay processing of this application and you will be asked to provide clarifications."]
["There is a cell at the end of the form that tells you how many questions need to be completed."]
["If all the required questions have been completed and no specific instructions appear next to any of the answer fields, 'Submit Registration' button will appear at the end of the form. "]
["Clicking on the 'Submit Registration' button will take you to a page from which you will be able to submit the registration form by email. "]
["The 'Submit Registration' button will only appear once all the required questions have been answered and no specific instructions appear next to any of the answer fields. If the 'Submit Registration' button does not appear, review the form and answer all the questions displaying 'Please complete' next to the answer fields. ) "]
["Please keep a copy of the completed registration form for your records because it will form part of the licence once this registration has been approved."]
["Please note that the personal data (names and email addresses) provided in this registration form will be used solely for processing and administration of the licence. We will store and process the data in accordance with data protection legislation.    We have an obligation to demonstrate impact of our work on the society. For this reason, the data submitted will be kept for a reasonable time after the end of the Licence Period to enable us to contact you, if necessary, for a statement of impact or benefit ASCOT has had on policy, practice or research as a result of the Project."]

{"sheet":"Registration","index":1,"n_rows":168,"n_cols":5,"rows_kept":168,"cut":false,"hidden":false,"merged":[[157,0,157,4],[165,1,166,4],[167,1,167,4],[1,0,1,4],[112,1,112,2],[155,0,155,4],[156,0,156,4],[78,1,78,3],[153,2,153,3],[75,1,75,2]]}
[]
["Instructions for Completion: Please complete this form by selecting an answer from the options provided or by entering your own answer where applicable. Once you have completed all the required answers please click the 'Submit Registration' button at the botom of the page to email this registration form to the ASCOT team. The button will only appear once you have completed all the required questions and there are no specific instructions in any of the answer fields. "]
["LICENSEE AND MAIN CONTACT"]
[]
[1,"Do you have the authority to consent to the Terms and Conditions? If yes, please provide your details in questions 3 and 4.(Please note that if you do not have the authority to consent to the Terms and Conditions, you need to seek the person in your organisation who will accept the terms and conditions; it is a requirement for the licence to access and/or use the ASCOT instruments.)",null,null,{"$f":"IF(C5=\"Select from List:\", \"Please Complete\", \"Done\")","v":"Done"}]
[]
[2,"If you do not have authority, have you identified someone who has the authority to consent to the Terms and Conditions in your organisation? (Please note that if you do not have the authority to consent to the terms and conditions and you have not identified someone in your organisation who does have this authority, this application will be rejected.) ","Select from list:",null,{"$f":"IF(COUNTIF(C5:C7,\"Yes\")>=1,\"Done\",\"Please Complete\")","v":"Please Complete"}]
[]
["Please provide the name and job title of the person who has the authority to consent to the Terms and Conditions - Please note that this person will be the licencee for this project"]
[]
[3,"Job Title",null,null,{"$f":"IF(C11=\"\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[4,"Name",null,null,"Please Complete"]
[]
["Licensee's details"]
["Name of the project a licence is being applied for",null,null,null,{"$f":"IF(C15=\"\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[5,"Organisation",null,null,"Please Complete"]
[6,"Address line 1",null,null,"Please Complete"]
[7,"Address line 2"]
[8,"Address line 3"]
[9,"Town/City",null,null,"Please Complete"]
[10,"Region/county",null,null,"Please Complete"]
[11,"Post code",null,null,"Please Complete"]
[12,"Country",null,null,"Please Complete"]
[]
["Licensee organisation type (please select all that apply)."]
[]
[13,"University - Academic "]
[14,"University - Undergraduate Student"]
[15,"University - Postgraduate Student"]
[16,"Local authority (UK)"]
[17,"Local Authority/Municipality (non-UK)"]
[18,"National Government Department (UK)"]
[19,"National government department (non-UK)"]
[20,"Service provider (for-profit) (UK)"]
[21,"Service provider (for-profit) (non-UK)"]
[22,"Service provider (not-for-profit)"]
[23,"Service provider (not-for-profit) (non-UK)"]
[24,"Consultancy agency"]
[25,"Consultant (including self-employed)"]
[26,"National Health Service (NHS; UK only)"]
[27,"National Health Service (non-UK)"]
[28,"Health Care organisation (other than NHS; UK only) "]
[29,"Health Care organisation (other than NHS; non-UK)"]
[30,"Pharmaceutical company                    "]
[31,"Other (please specify) "]
[null,null,null,null,{"$f":"IF(COUNTIF(C23:C44,\"Yes\")>=1,\"Done\",IF(C45=\"\",\"Please Complete\",\"Done\"))","v":"Please Complete"}]
["Project Lead details"]
[32,"Name",null,null,"Please Complete"]
[33,"Job title",null,null,"Please Complete"]
[34,"Phone number (including country code if not UK)",null,null,"Please Complete"]
[35,"Email address",null,null,"Please Complete"]
["Postal address"]
[36,"Address line 1",null,null,"Please Complete"]
[37,"Address line 2",null,null,"Please Complete"]
[38,"Address line 3"]
[39,"Town/City",null,null,"Please Complete"]
[40,"Region/county",null,null,"Please Complete"]
[41,"Post code",null,null,"Please Complete"]
[42,"Country",null,null,"Please Complete"]
[]
["USE OF ASCOT - PROJECT"]
["This section covers the planned use of ASCOT, which is referred to as 'Project' in the Terms and Conditions attached below. "]
[43,"Will ASCOT be used in a for-profit capacity? i.e. Will you/your organisation or the person/organisation on whose behalf you are completing this registration form make a profit/charge for using ASCOT or any materials containing ASCOT? (Please note: for-profit use of ASCOT requires a licence for for-profit use  and will incur a fee.) ","Select from list:",null,{"$f":"IF(C63=\"Yes\",\"Please contact the ASCOT team by email at ascot@kent.ac.uk to discuss a for-profit licence\",IF(C63=\"No\",\"Done\", \"Please Complete\"))","v":"Please Complete"}]
[]
[]
[44,"Title of the project/study in which ASCOT is planned to be used",null,null,"Please Complete"]
[45,"Project’s/study’s website",null,null,"Please Complete"]
[null,"The type of planned use of ASCOT"]
[46,"Research                ","Select from list:"]
[47,"Evaluation ","Select from list:"]
[48,"Quality monitoring         ","Select from list:"]
[49,"Internal auditing    ","Select from list:"]
[50,"Student project        ","Select from list:"]
[51,"Other (please specify)"]
[null,null,null,null,{"$f":"IF(COUNTIF(C69:C73,\"Yes\")>=1,\"Done\",IF(C74=\"\",\"Please Complete\",\"Done\"))","v":"Please Complete"}]
[null,"In the field below, briefly describe the study/project in which ASCOT is planned to be used. Please include purpose/aims and the details of how ASCOT is going to be used (your response can expand over the bottom of this response field; all text will be recorded as long as the total number of characters is up to 4000). "]
[52,null,null,null,{"$f":"IF(B77=\"\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[]
[null,"Please briefly describe what impact and/or public benefit is expected from this project/study (up to 1000 characters)."]
[53,null,null,null,{"$f":"IF(B80=\"\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[]
[]
[54,"What is the population? (Population is the entire pool from which a sample is drawn. An example of population could be all users of social care services funded by local authorities in England.)",null,null,"Please Complete"]
[]
[55,"What is the sample size? (Sample is a subset of population which represents the population. If the population in your study/project is service users of social care services, then your sample size is the number of service users who will participate.)  ","Sample size:",null,{"$f":"IF(C85=\"Sample size:\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[56,"If over 300, please specify"]
[]
[57,"In which country/countries will the study/project take place?",null,null,{"$f":"IF(C88=\"\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[]
[null,"Which ASCOT instrument do you plan to use in the study/project (please select all applicable instruments)."]
[58,"SCT4","Select from list:",null,{"$f":"IF(C91=\"Select from list:\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[59,"INT4","Select from list:",null,{"$f":"IF(C92=\"Select from list:\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[60,"SCT4 Easy Read (Please note that the ASCOT ER was only tested on those with learning disabilities/autism and as such cannot be used for older adults with dementia)","Select from list:",null,"Please Complete"]
[61,"CH3 (Please note that training is required for use of the CH3 instrument. The licence will only be granted upon completion of the training. Please see our website for information on training courses: www.pssru.ac.uk/ascot)","Select from list:",null,"Please Complete"]
[62,"Carer SCT4 ","Select from list:",null,"Please Complete"]
[63,"Carer INT4","Select from list:",null,"Please Complete"]
[64,"Using ASCOT in care planning (Please note that training is required for this. The licence will only be granted upon completion of the training. Please see our website for information on training courses: www.pssru.ac.uk/ascot)","Select from list:"]
[]
[65,"If you are you planning to use a translation of ASCOT, please select the language version that applies. "]
[null,"In the field below, please list all project members involved in the study/project, including affiliation and email addresses, e.g. Prof John Smith, University of Kent, j.smith@kent.ac.uk."]
[66,null,null,null,{"$f":"IF(B101=\"\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[]
[67,"Are you planning to amend ASCOT? (Please note you will not be permitted to amend ASCOT unless explicitly agreed by the ASCOT team.This registration form will be reviewed by the ASCOT team who may request further information regarding any proposed changes.)",null,null,{"$f":"IF(C103=\"\",\"Please Complete\",\"Done\")","v":"Please Complete"}]
[null,"In the field below, please outline what changes you are planning to make, if applicable. "]
[68]
[]
[69,"If you plan on translating ASCOT please confirm which language(s) you would like to translate it into. (Translations must be agreed by the ASCOT team. We may seek further information from you regarding the translation. Translation guidance will be provided and must be followed for an approved translation.)"]
[]
[70,"What is the anticipated start date of the study/project (DD/MM/YYYY)?  (Please provide an approximate date if not certain.)",null,null,{"$f":"IF(C109=\"\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[]
[71,"What is the anticipated end date of the study/project (DD/MM/YYYY)? (Please note the study/project start and end dates are referred to as 'Licence Period' in the Terms and Conditions attached below.",null,null,"Please Complete"]
[]
[null,"What outputs/publications are planned from this study/project and when? Please provide an estimate if not certain, e.g. planned dates of article submissions, etc."]
[null,"Type of output/publication (ie.: report, journal article, blog, etc.)","Expected date (month/year)"]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[]
[]
["ASCOT must be referenced appropriately in any publications from any studies/projects in which ASCOT is used. Guidance on how to reference ASCOT can be found here: "]
[null,"www.pssru.ac.uk/ascot/how-to-reference-ascot"]
[]
[85,"I confirm that I will reference ASCOT in any publications from this study/project.","Select from list:",null,{"$f":"IF(C127=\"\",\"Please Complete\",IF(C127=\"Yes\",\"Done\",\"Please complete\"))","v":"Please complete"}]
[null,null,{"$f":"IF(C127=\"\",\"\",IF(C127=\"No\",\"Please contact ascot@kent.ac.uk to discuss why publications may require a referencing exemption\",\"\"))","v":""}]
["Multi-site Licence "]
[]
[86,"Will the tool be used in more than one site? (A site is defined as one facility. For example, if a provider has a number of care homes, each of them is treated as a site.)","Select from list:",null,{"$f":"IF(C131=\"Select from list:\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[]
[]
[87,"How many sites will the ASCOT tool(s) be used in?",null,null,{"$f":"IF(C134=\"\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[]
[88,"Each ASCOT tool has an accompanying data entry tool which aids data entry; it calculates social care-related quality of life scores and contains useful data presentation features. Upon approval of this registration, you will be emailed a link to a website where you will be able to purchase a data entry tool. If you are registering to use the ASCOT instrument(s) in more than one site, you must purchase a data entry tool for each site. Please select \"Agree\" to acknowledge you have read and agree to this. ","Select from list:",null,{"$f":"IF(C136=\"Agree\", \"Done\",\"Please complete\")","v":"Please complete"}]
[]
["To complete the registration process please read and consent to the terms and conditions."]
["This section should be completed by the person who has the authority to consent to the Terms and Conditions as set out above. "]
[]
[null,"ASCOT Licence Terms and Conditions (please read the pdf on the Instructions tab below)"]
[]
[89,"Please provide the name of the person accepting the Terms and Conditions (please select from the two options provided, which are based on your answers to questions 4 and 32).",null,null,{"$f":"IF(C143=\"\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[]
[]
[90,"I confirm that I have the authority to consent to the attached Terms and Conditions on behalf of my organisation (Licensee).","Select from list:",null,{"$f":"IF(C146=\"Yes\", \"Done\",\"Please complete\")","v":"Please complete"}]
[null,null,{"$f":"IF(C146=\"Yes\",\"\",IF(C146=\"Select from list:\",\"\",IF(C146=\"No\",\"If you do not agree this question 90, registration will not be possible and licence will not be granted\")))","v":""}]
[91,"I confirm that I have read and agree to the Terms and Conditions on behalf of my organisation and I will ensure that all people involved in the Project are aware of the attached Terms and Conditions. ","Select from list:",null,{"$f":"IF(C148=\"Yes\", \"Done\",\"Please Complete\")","v":"Please Complete"}]
[null,null,{"$f":"IF(C148=\"Yes\",\"\",IF(C148=\"Select from list:\",\"\",IF(C148=\"No\",\"If you do not agree this question 91, registration will not be possible and licence will not be granted\")))","v":""}]
[92,"Please provide your email address which will be used for processing of this licence registration. We will not share it with third parties. We reserve the right to contact you within reasonable time after the end of the Licence Period for a statement of impact or benefit ASCOT has had on policy, practice or research as a result of the Project.",null,null,{"$f":"IF(C150=\"\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[]
[93,"We occasionally organise events aiming to share the use of ASCOT in research and practice, such as workshops or webinars. If you would like to receive emails about these events, please select 'Yes'. ","Select from list:",null,{"$f":"IF(C152=\"Select from list:\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[]
[null,null,"Incomplete Answers:",null,{"$f":"IF(A155=\"\",COUNTIF(E4:E152,\"Please Complete\"),COUNTIF(E4:E152,\"Please Complete\")+1)","v":49}]
[{"$f":"IF(E63=\"Please contact the ASCOT team by email at ascot@kent.ac.uk to discuss a for-profit licence\",\"Error wrong from used, please contact the ASCOT team by email at ascot@kent.ac.uk to discuss a for-profit licence\",\"\")","v":""}]
["Form Submission"]
["Once you have completed all the required answers, please click on the 'Submit Registration' button below. This will take you to a page from which you will be able to submit the registration form by email. The 'Submit Registration' button will only appear once you have completed all the required questions and no specific instructions appear next to any of the answer fields."]
["The screen will flicker for a moment when you click on the button, this is normal. "]
[]
[]
[]
[]
[]
[]
[]
[null,"If you wish to use the ASCOT Care Homes (CH3) instrument, you must undergo a training course by the ASCOT team.  The licence for use of this tool is conditional on completion of the training course. Click on the link below for information on forthcoming training courses  "]
[]
[null,"ASCOT website - forthcoming training"]

{"sheet":"Drop-down responses","index":2,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Select from list:","Sample size:","Language:","Select from list:",null,"Name List for Question 89"]
["No","0-50","Dutch","Agree",null,{"$f":"Registration!C12","v":0}]
["Yes","50-100","German","Diasgree",null,{"$f":"Registration!C48","v":0}]
["N/A","101-150","Finnish"]
[null,"151-200","Japanese"]
[null,"201-250"]
[null,"251-300"]
[null,"Over 300"]

{"sheet":"ThankYou","index":3,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
["Thank You"]
["Thank you for completing the registration form"]
["Please save this registration form to your computer and then email the ASCOT team at ascot@kent.ac.uk and attach the registration form to the email"]
["Clicking on the button below will open a new MS Outlook message. You can then attach the form to the email and send it to us. \n\nWe will aim to respond to this registration submission within 10 working days. \n\nPlease note that all required questions must be completed and you will be asked to provide information or clarification to any missing or unclear answers, which may cause a delay in processing of this registration form.  \n\nPlease keep a copy of this completed registration form for your records because it will form part of the licence once this registration has been approved."]

{"sheet":"Answers","index":4,"n_rows":1,"n_cols":93,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93]