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

{"sheet":"Instructions","index":0,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,0,17,11],[6,0,6,11],[13,0,13,12],[10,0,10,11],[11,0,11,11],[15,0,15,11]]}
[]
[]
[]
[]
[]
[]
["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 enquiry form and you will be asked to provide clarifications."]
["There is a cell at the end of the form that tells you how many fields 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 Form' button will appear at the end of the form. "]
["Clicking on the 'Submit Form' button will take you to a page from which you will be able to submit the form by email. "]
["The 'Submit Form' 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 Form' button does not appear, review the form and answer all the questions displaying 'Please complete' next to the answer fields."]
["The completed enquiry form will passed to the University of Kent Innovation & Enterprise to negotiate a licence and a fee for for-profit use. "]
["Please note that the personal data (names and email addresses) provided in this enquiry form will be used solely for processing of this enquiry form and administration of the licence, if granted.  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 in this form 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":130,"n_cols":5,"rows_kept":130,"cut":false,"hidden":false,"merged":[[1,0,1,4],[51,0,51,4],[3,0,3,4],[128,1,128,4],[129,1,129,4],[63,1,63,2],[72,0,72,2],[114,0,115,4],[94,1,94,2],[118,0,118,4],[116,2,116,3],[119,0,119,4],[105,1,105,4]]}
[]
["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 Form' button at the botom of the page. The button will only appear once you have completed all the required questions. "]
["APPLICANT"]
["This section refers to the person or organisation applying for ASCOT. "]
[]
[1,"Will ASCOT be used in a for-profit/commercial capacity? i.e. Will you/your organisation or the person/organisation on whose behalf you are completing this enquiry form generate income from the use of ASCOT or any materials containing ASCOT? (Please note: for-profit/commercial use of ASCOT requires a for-profit licence and will incur a fee.)",null,null,{"$f":"IF(C6=\"No\",\"Please contact the ASCOT team by email at ascot@kent.ac.uk to discuss a not-for-profit licence\",IF(C6=\"Yes\",\"Done\", \"Please Complete\"))","v":"Please Complete"}]
[]
[2,"Applicant’s name",null,null,{"$f":"IF(C8=\"\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[]
["Applicant’s address"]
[3,"Organisation",null,null,"Please Complete"]
[4,"Address line 1",null,null,"Please Complete"]
[5,"Address line 2"]
[6,"Address line 3"]
[7,"Town/City",null,null,"Please Complete"]
[8,"Region/county",null,null,"Please Complete"]
[9,"Post code",null,null,"Please Complete"]
[10,"Country",null,null,"Please Complete"]
[]
[]
["Who is the Applicant? (please select all that apply)."]
[11,"Academic (e.g. university)  "]
[12,"Local authority/municipality"]
[13,"National government department"]
[14,"Service provider (for-profit)"]
[15,"Service provider (not-for-profit)"]
[16,"Consultancy agency"]
[17,"Consultant (self-employed)"]
[18,"Student – undergraduate "]
[19,"Student - Masters or PhD                  "]
[20,"NHS"]
[21,"Health Care organisation (other than NHS)"]
[22,"Pharmaceutical company                    "]
[23,"Other (please specify) "]
[null,null,null,null,{"$f":"IF(COUNTIF(C22:C33,\"Yes\")>=1,\"Done\",IF(C34=\"\",\"Please Complete\",\"Done\"))","v":"Please Complete"}]
["Main contact person (please complete even if the same as Applicant)."]
[24,"Name ",null,null,"Please Complete"]
[25,"Phone number (including country code if not UK)",null,null,"Please Complete"]
[26,"Email address",null,null,"Please Complete"]
[null,"Postal address"]
[27,"Address line 1",null,null,"Please Complete"]
[28,"Address line 2",null,null,"Please Complete"]
[29,"Address line 3"]
[30,"Town/City",null,null,"Please Complete"]
[31,"Region/county",null,null,"Please Complete"]
[32,"Post code",null,null,"Please Complete"]
[33,"Country",null,null,"Please Complete"]
[]
[34,"Briefly describe the organisation wishing to use ASCOT, including its remit. Example: business organisation whose aim is to generate profit.",null,null,"Please Complete"]
[]
["USE OF ASCOT"]
["This section is about the planned use of ASCOT."]
[35,"Title of the project/study in which ASCOT is planned to be used",null,null,"Please Complete"]
[36,"Project’s/study’s website",null,null,"Please Complete"]
[null,"The type of planned use of the translation of ASCOT"]
[37,"Research                "]
[38,"Evaluation "]
[39,"Quality monitoring         "]
[40,"Internal auditing    "]
[41,"student project        "]
[42,"other (please specify)"]
[null,null,null,null,{"$f":"IF(COUNTIF(C56:C60,\"Yes\")>=1,\"Done\",IF(C61=\"\",\"Please Complete\",\"Done\"))","v":"Please Complete"}]
[null,"Briefly describe the study/project in which ASCOT is planned to be used, including purpose/aims (up to 4000 characters)."]
[43,null,null,null,{"$f":"IF(B64=\"\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[]
[44,"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"]
[]
[45,"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(C68=\"Sample size:\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[46,"If over 300, please specify"]
[]
[47,"In which country/countries will the study/project take place?",null,null,{"$f":"IF(C71=\"\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[]
["Which ASCOT instrument do you plan to use in the study/project (please select all applicable instruments)."]
[48,"SCT4","Select from list:",null,{"$f":"IF(C74=\"Select from list:\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[49,"INT4","Select from list:",null,{"$f":"IF(C75=\"Select from list:\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[50,"SCT4 Easy Read","Select from list:",null,"Please Complete"]
[51,"CH3 (Please note that training is required for use of the CH3 instrument. A for-profit licence for use of CH3, if agreed, will be conditional on completion of a CH3 training course. Please see our website for information on training courses: www.pssru.ac.uk/ascot/forthcoming)","Select from list:",null,"Please Complete"]
[52,"Carer SCT4 ","Select from list:",null,"Please Complete"]
[53,"Carer INT4","Select from list:",null,"Please Complete"]
[]
[54,"If you are you planning to use a translation of ASCOT, please select the language version that applies.","Language:",null,{"$f":"IF(C81=\"Language:\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[]
[55,"How will ASCOT be used in the study/project? ",null,null,"Please Complete"]
[]
[56,"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.)","Select from list:",null,{"$f":"IF(C85=\"Select from list:\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[]
[57,"Please outline what changes you are planning to make, if applicable. "]
[]
[58,"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 approval.)"]
[]
[59,"What is the anticipated start date of the study/project?  (please provide an approximate date if not certain. DD/MM/YYYY)",null,null,"Please Complete"]
[]
[60,"What is the anticipated end date of the study / project?  (DD/MM/YYYY)",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 (i.e. report, journal article, blog)","Expected date (month/year)"]
[61]
[63]
[65]
[67]
[69]
[71]
[73]
[]
[]
[null,"ASCOT must be referenced appropriately in any publications from any studies/projects in which ASCOT has been used. Click on the link below for guidance on how to reference ASCOT. "]
[null,"https://www.pssru.ac.uk/ascot/how-to-reference-ascot"]
[]
[75,"I confirm that I will reference ASCOT in any publications from this study/project.","Select from list:",null,{"$f":"IF(C109=\"Select from list:\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[]
[76,"Please provide your email address which will be used for processing of this enquiry form and licence agreement. 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(C111=\"\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[]
[77,"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(C113=\"Select from list:\", \"Please Complete\", \"Done\")","v":"Please Complete"}]
[]
["Please note that any use of ASCOT, including for-profit/commercial, requires a licence. We reserve the right to decline to grant a licence. "]
[]
[null,null,"Incomplete Questions: ",null,{"$f":"IF(A118=\"\",COUNTIF(E4:E113,\"Please Complete\"),(COUNTIF(E4:E113,\"Please Complete\")+1))","v":40}]
[{"$f":"IF(E6=\"Please contact the ASCOT team by email ascot@kent.ac.uk to discuss a not-for-profit licence\",\"Error wrong from used, please contact the ASCOT team by email ascot@kent.ac.uk to discuss a not-for-profit licence\",\"\")","v":""}]
["Form Submission"]
["Once you have completed all the required answers please click the 'Submit Form' button below.  This will take you to a page from which you will be able to submit the enquiry form by email. The 'Submit Form' button will only appear once you have completed all the required questions no specific instructions appear next to any of the answer fields.\nThe screen will flicker for a moment when you click on the button, this is normal. "]
[" "]
[]
[]
[]
[]
[]
[]
[]
[null,"If you wish to use ASCOT CH3 (Care Homes) instrument, you must complete a training course by the ASCOT team. A for-profit licence for use of CH3, if agreed, will be conditional on completion of a CH3 training course. Click on the link below for information on upcoming training courses.\n"]
[null,"ASCOT website - forthcoming training"]

{"sheet":"Drop-down responses","index":2,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Select from list:","Sample size:","Language:"]
["No","0-50","N/A"]
["Yes","50-100","Dutch"]
["Unknown","101-150","German"]
[null,"151-200","Finnish"]
[null,"201-250","Japanese"]
[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 enquiry 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 enquiry form 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 form.    \n\nPlease keep a copy of this completed enquiry form for your records. \n\nPlease note this enquiry form will passed to the University of Kent Innovation & Enterprise to negotiate a licence agreement and a fee for for-profit use. "]

{"sheet":"Answers","index":4,"n_rows":4,"n_cols":78,"rows_kept":4,"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,null,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]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"    "]