{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Introduction","1 - Company Details","2 - Sales and exports","3 - Barriers to int business","4 - Future Export Destinations","5 - Overseas relationships","6 - Your comments","Form Submission"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[13,1,13,2],[14,1,14,2],[18,1,18,2],[17,1,17,2],[16,1,16,2],[15,1,15,2],[1,1,1,11],[7,1,7,11],[11,1,11,2],[12,1,12,2],[3,1,3,10]]}
[]
[null,"SCOTLAND'S GLOBAL CONNECTIONS SURVEY 2019"]
[]
[null,"For guidance on completing the questionnaire please refer to guidance notes which can be found alongside this form on the same web page, which can be found ",null,null,null,null,null,null,null,null,null,"here."]
[]
[null,"Please enter your Unique Reference Number in the space provided:"]
[]
[null,"Your unique reference number is an 11 digit number which can be found on the top left of the letter sent to you (below your address) or the bottom left of each page of the survey form sent to you. "]
[]
[null,"For any assistance please email","exports.statistics@gov.scot ","or contact us on 0300 244 0330."]
[]
[null,"Sections"]
[null,"Section 1: Company details"]
[null,"Section 2: Sales and exports"]
[null,"Section 3: Barriers to International Business"]
[null,"Section 4: Future export destinations"]
[null,"Section 5: Overseas relationships"]
[null,"Section 6: Your comments"]
[null,"Form Submission"]

{"sheet":"1 - Company Details","index":1,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[[33,2,33,11],[1,1,1,12],[31,2,31,10],[20,6,20,11],[14,3,14,11],[13,3,13,11],[12,3,12,11],[11,3,11,11],[10,3,10,11],[9,3,9,11],[8,3,8,11],[7,3,7,11],[6,3,6,11],[5,3,5,11],[24,2,28,11]]}
[]
[null,"Section 1: Company Details"]
[]
[null,1,"Please enter your company details below"]
[]
[null,null,"Contact Name"]
[null,null,"Company name"]
[null,null,"Postal Address"]
[]
[]
[]
[null,null,"Postcode"]
[null,null,"Tel No."]
[null,null,"Email"]
[null,null,"Website"]
[]
[null,2,"Which country are your headquarters based in?"]
[null,null,"Refer to notes and attached country list for additional guidance"]
[null,null,null,"Scotland"]
[]
[null,null,null,"Other - Please Specify"]
[]
[null,3,"Please describe in words the main business activity of your Scottish branch(es)/operation(s)."]
[]
[]
[]
[]
[]
[]
[]
[null,4,"How many people are employed at the Scottish branch(es)/operation(s) of your company?"]
[null,null,"Count all those persons who are on the payroll at the end of 2019 (including part time staff)"]

{"sheet":"2 - Sales and exports","index":2,"n_rows":62,"n_cols":18,"rows_kept":62,"cut":false,"hidden":false,"merged":[[1,1,1,17],[33,2,34,17],[60,2,62,2],[39,8,39,10],[38,8,38,10],[39,12,39,13],[61,3,61,6],[59,3,59,6],[58,3,58,6],[57,3,57,6],[49,3,49,6],[48,3,48,6],[47,3,47,6],[46,3,46,6],[45,3,45,6],[44,3,44,6],[43,3,43,6],[42,3,42,6],[41,3,41,6],[40,3,40,6],[56,3,56,6],[50,3,50,6]]}
[]
[null,"Section 2: Sales and exports"]
[]
[null,5,"Please give the total sales of goods and services from the Scottish branch(es) of your company in 2019, to the nearest £1,000."]
[null,null,"Please refer to notes on particular service sectors."]
[]
[null,"Goods","£",null,",000","+ ","Services","£",null,",000","= ","Total","£",null,",000"]
[]
[null,"5a","Are the above figures based on?"]
[null,null,"Please put an X in the appropriate box"]
[]
[null,null,null,"Recorded sales of branch(es) in Scotland",null,null,null,null,null,"Value estimated by other means"]
[]
[null,null,null,"Calculated share of a UK or GB total, e.g. an employment share"]
[]
[null,"6","What percentage of your sales in 2019 (as reported in Q5) were to customers in the following locations?"]
[null,null,"Refer to notes and attached country list for additional guidance"]
[null,"Goods*"]
[null,"Scotland",null,"%","+","Rest of UK",null,"%","+ ","Rest of EU",null,"%","+ ","Rest of World",null,"%","=",1]
[null,"Services*"]
[null,"Scotland",null,"%","+","Rest of UK",null,"%","+ ","Rest of EU",null,"%","+ ","Rest of World",null,"%","=",1]
[]
[null,"*If you cannot provide a breakdown of goods and services, please provide a total sales breakdown"]
[null,"Total*"]
[null,"Scotland",null,"%","+","Rest of UK",null,"%","+ ","Rest of EU",null,"%","+ ","Rest of World",null,"%","=",1]
[]
[]
[null,"6a","If you have sales to the rest of the UK, please provide a percentage breakdown if possible:"]
[null,"Rest of UK"]
[null,"England",null,"%","+","Wales",null,"%","+ ","Northern Ireland",null,"%","+ ","UK Continental Shelf",null,"%","=",1]
[]
[null,"If you have no sales to customers outside the UK",null,null,null,null,null,null,null,null,null,null,null,null,"Go to",null,8]
[]
[null,7,"Please list the countries where most of your non-UK customers are based, and the amount or percent of your total sales (as provided in question 5) that was accounted for by those customers (exports)."]
[]
[null,null,"Values should exclude VAT and any overseas freight costs and insurance ('free on board basis')."]
[null,null,"If the information cannot be broken down into specific countries please provide the region totals."]
[null,null,"Refer to notes and attached country list for additional guidance."]
[null,null,null,null,null,null,null,null,"Amount"]
[null,null,"Country",null,null,null,null,null,"(to the nearest (£1,000)",null,null,null,"Percentage of Total Sales"]
[null,null,"1.",null,null,null,null,null,"£",null,",000",null,null,"%"]
[null,null,"2.",null,null,null,null,null,"£",null,",000",null,null,"%"]
[null,null,"3.",null,null,null,null,null,"£",null,",000",null,null,"%"]
[null,null,"4.",null,null,null,null,null,"£",null,",000",null,null,"%"]
[null,null,"5.",null,null,null,null,null,"£",null,",000",null,null,"%"]
[null,null,"6.",null,null,null,null,null,"£",null,",000",null,null,"%"]
[null,null,"7.",null,null,null,null,null,"£",null,",000",null,null,"%"]
[null,null,"8.",null,null,null,null,null,"£",null,",000",null,null,"%"]
[null,null,"9.",null,null,null,null,null,"£",null,",000",null,null,"%"]
[null,null,"10.",null,null,null,null,null,"£",null,",000",null,null,"%"]
[null,null,"11.",null,null,null,null,null,"£",null,",000",null,null,"%"]
[null,null,"12.",null,null,null,null,null,"£",null,",000",null,null,"%"]
[null,null,"13.",null,null,null,null,null,"£",null,",000",null,null,"%"]
[null,null,"14.",null,null,null,null,null,"£",null,",000",null,null,"%"]
[null,null,"15.",null,null,null,null,null,"£",null,",000",null,null,"%"]
[null,null,"16.",null,null,null,null,null,"£",null,",000",null,null,"%"]
[null,null,"17.",null,null,null,null,null,"£",null,",000",null,null,"%"]
[null,null,"18.",null,null,null,null,null,"£",null,",000",null,null,"%"]
[null,null,"19.",null,null,null,null,null,"£",null,",000",null,null,"%"]
[null,null,"20.",null,null,null,null,null,"£",null,",000",null,null,"%"]
[]
[null,null,null,"Total for any remaining countries:",null,null,null,null,"£",null,",000",null,null,"%"]

{"sheet":"3 - Barriers to int business","index":3,"n_rows":61,"n_cols":10,"rows_kept":61,"cut":false,"hidden":false,"merged":[[66,2,66,6],[66,9,66,13],[1,1,1,14],[3,2,3,14],[34,2,34,14],[59,2,59,14],[27,2,32,13],[53,2,57,13],[62,2,62,6],[62,9,62,13],[64,2,64,6],[64,9,64,13],[35,2,35,5]]}
[]
[null,"Section 3: Barriers to international business"]
[]
[null,8,"What barriers to future international business development exist for the Scottish branch(es)/operation(s) of your company?"]
[null,null,"Please put an X in the boxes that apply"]
[]
[null,null,null,"Products/services unsuitable for exports",null,null,null,null,null,"Lack of resources/management time"]
[]
[null,null,null,"Lack of market information",null,null,null,null,null,"High import tariffs in target markets"]
[]
[null,null,null,"Language/cultural differences",null,null,null,null,null,"Currency/exchange rates"]
[]
[null,null,null,"Export documentation",null,null,null,null,null,"Legislation and standards"]
[]
[null,null,null,"Export credit insurance",null,null,null,null,null,"Setting competitive prices"]
[]
[null,null,null,"Export finance",null,null,null,null,null,"No spare production capacity"]
[]
[null,null,null,"Access to finance in general",null,null,null,null,null,"After sales service"]
[]
[null,null,null,"Lack of trained staff",null,null,null,null,null,"Lack of international e-commerce capability"]
[]
[null,null,null,"Impact of EU Exit",null,null,null,null,null,"Transport costs"]
[]
[null,null,null,null,null,null,null,null,null,"Non tariff barriers"]
[null,null,"Other (please be as specific as possible)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,9,"Which form(s) of assistance would encourage the Scottish branch(es)/operation(s) of your company to improve International performance?"]
[null,null,"Please put an X in the boxes that apply"]
[]
[null,null,null,"Export Training",null,null,null,null,"International marketing"]
[]
[null,null,null,"Export documentation",null,null,null,null,"International mentoring/placements"]
[]
[null,null,null,"International e-commerce",null,null,null,null,"Introduction to overseas customers"]
[]
[null,null,null,"Developing an international strategy",null,null,null,null,"Introduction to agents/distributors/jv partners"]
[]
[null,null,null,"Market Research",null,null,null,null,"Information on business opportunities"]
[]
[null,null,null,"Exhibiting at trade fairs",null,null,null,null,"Information on world aid funded business"]
[]
[null,null,null,"Overseas Trade missions",null,null,null,null,"Start up facilities overseas"]
[]
[null,null,"Other (please be as specific as possible)"]
[]
[]
[]
[]
[]
[]
[]
[null,10,"If you need help with exporting which organisations would you approach?"]
[null,null,"Please name the different organisations you would approach in the space below."]

{"sheet":"4 - Future Export Destinations","index":4,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,8],[12,6,12,7],[11,6,11,7],[10,6,10,7],[9,6,9,7],[8,6,8,7],[12,3,12,4],[11,3,11,4],[10,3,10,4],[9,3,9,4],[8,3,8,4]]}
[]
[null,"Section 4: Future export destinations"]
[]
[null,"11","Please list any countries or regions that you see as future export markets."]
[null,null,"Include all countries that you are targeting in the next 12 months."]
[null,null,"Refer to the attached country list for additional guidance."]
[]
[null,null,"Country"]
[null,null,"1.",null,null,"6."]
[null,null,"2.",null,null,"7."]
[null,null,"3.",null,null,"8."]
[null,null,"4.",null,null,"9."]
[null,null,"5.",null,null,"10."]

{"sheet":"5 - Overseas relationships","index":5,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,1,1,10],[22,3,22,5],[23,3,23,5],[24,3,24,5],[25,3,25,5],[9,9,10,9],[9,8,10,8],[9,7,10,7],[9,6,10,6],[11,3,11,5],[20,3,20,5],[19,3,19,5],[18,3,18,5],[17,3,17,5],[16,3,16,5],[15,3,15,5],[28,3,28,5],[29,3,29,5],[30,3,30,5],[31,3,31,5],[3,2,3,9],[26,3,26,5],[27,3,27,5],[14,3,14,5],[13,3,13,5],[12,3,12,5]]}
[]
[null,"Section 5: Overseas relationships"]
[]
[null,12,"Please list the countries, if any, that your company has existing, or planned relationships with, and state the number of each."]
[]
[null,null,"Answer only if your business headquarters are based in Scotland."]
[null,null,"If the information cannot be broken down into specific countries please provide the region totals."]
[null,null,"Refer to notes and attached country list for additional guidance. "]
[]
[null,null,"Country",null,null,null,"Number of subsidiaries","Number of sales offices/agencies","Number of joint ventures","Number of other relationships"]
[null,null,"Current"]
[null,null,"1."]
[null,null,"2."]
[null,null,"3."]
[null,null,"4."]
[null,null,"5."]
[null,null,"6."]
[null,null,"7."]
[null,null,"8."]
[null,null,"9."]
[null,null,"10."]
[null,null,"Planned"]
[null,null,"1."]
[null,null,"2."]
[null,null,"3."]
[null,null,"4."]
[null,null,"5."]
[null,null,"6."]
[null,null,"7."]
[null,null,"8."]
[null,null,"9."]
[null,null,"10."]

{"sheet":"6 - Your comments","index":6,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[11,2,20,12],[1,1,1,13]]}
[]
[null,"Section 6: Your comments"]
[]
[null,"13a","Could you please indicate how long this survey form has taken to complete"]
[null,null,null,"hrs",null,"mins"]
[]
[null,"13b","Could you indicate the cost of completing this survey form to your business, to the nearest £?"]
[null,null,"£"]
[]
[null,14,"We would welcome any comments you have regarding this questionnaire. Please use the space provided below."]

{"sheet":"Form Submission","index":7,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,1,3,7],[10,1,11,7]]}
[]
[null,"Thank you for taking the time to complete this questionnaire."]
[]
[null,"Please return this form by using the button below. "]
[]
[]
[]
[]
[]
[]
[null,"If the above button does not work, then please submit this form in an email to exports.statistics@gov.scot"]