{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Research contracts","Consultation Analysis contracts"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Research contracts","index":0,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Contract Number","Project Name","Supplier Name","How awarded","total cost","Project start date","Project end date"]
["SG/RES/2014/027","Impacts of Migration into Scotland","GRAMNet","Quick Quote",24901,"2015-04-30","2015-10-02"]
["SG/RES/2014/028","Scottish Maternity Care Experience Survey 2015","Quality Health Ltd","Quick Quote Via a Framework (Patient experience surveys framework)",13129.68,"2015-04-27","31/04/2015"]
["SG/RES/2015/029","Increasing gender diversity on private sector boards","TERU, Univ Glasgow","Quick Quote",26050,"2015-07-13","2015-12-31"]
["SG/RES/2015/030","Literature Review on the Impact of digital technology on learning and teaching","ICF Consulting Services Ltd","Dual Stage Open ",19250,"2015-07-06","2015-09-11"]
["SG/RES/2015/031","Scotland’s Future Employment Services –Literature Review","Inclusion","Quick Quote",24780,"2015-07-17","2015-10-31"]
["SG/RES/2015/032","Parents views towards uptake of 30 hours of childcare per week ","Why Research","Quick quote ",13860,"2015-06-15","2015-08-31"]
["SG/RES/2015/033","The Commission on Widening Access - Call for Evidence Analysis ","Craigforth Ltd"," Framework ","Picked \"R\" when it should have been \"CA\" - transferred details to Consultation Analysis Worksheet "]
["SG/RES/2015/034","Identifying the prevalence and harms of New Psychoactive Substances (NPS) amongst vulnerable groups in Scotland","Scottish Drugs Forum","Dual stage ",79624,"2015-07-27","2016-05-05"]
["SG/RES/2015/035","Understanding forced marriage in Scotland","Individual","Single stage open",38957,"2015-10-09","2016-05-31"]
["SG/RES/2015/036","Creating an interactive wellbeing data visualisation tool","Scotcen","Quick quote",33863,"2015-07-31","2016-03-31"]
["SG/RES/2015/037","Teaching Scotland’s Future Evaluation","Ipsos MORI","Dual stage open",95387,"2015-06-15","31/02/2016"]
["SG/RES/2015/038","Behaviour in Scottish Schools","Ipsos Mori","OJEU/ Dual stage ",165379.5,"2015-12-07","2017-02-06"]
["SG/RES/2015/039","Engagement on the National Strategy for Community Justice","Liddel Thomson Consultancy","Quick Quote",34100,"2015-11-01","2016-02-28"]
["SG/RES/2015/040","The Scottish Cancer Patient Experience Survey 2015","Quality Health Ltd","Contract via Framewprk",13259.52,"2015-09-24","2016-05-31"]
["SG/RES/2015/041","Evaluation of Participatory Budgeting Activity","Glasgow Caledonia Univesity","Quick Quote",39812,"2015-11-02","2017-10-31"]
["SG/RES/2015/042","Scottish Performance Under the PIPS Assessment","Centre for Evaluation & M","NCA",37000,"2015-08-20","2015-11-13"]
["SG/RES/2015/043","Health and Care Experience Survey","Quality Health Ltd","Contract Via Framework",375724.61,"2015-10-26","2016-06-30"]
["SG/RES/2015/044","Review of the Autism Network Scotland","Jennifer Waterton Consultancy","QuickQuote",14120,"2015-11-02","2016-02-28"]
["SG/RES/2015/045","Inpatient Experience Survey 2016","Quality Health Ltd","Contract via Framework",67848.160000000003,"2016-11-30","2016-09-01"]
["SG/RES/2015/046","Review Autism Network Scotland","Jennifer Waterton Consultancy","Health Analytical Services",14120,"2015-11-18","2016-03-11"]
["SG/RES/2015/047","Qualitative Research with Young Adults on E-cigarettes","Griesbach & Associates ","Quick Quote",18360,"2015-10-28","2016-03-21"]
["SG/RES/2015/048","Review of the Scottish Allocation Formulla: Modelling the Pattern of Need in Primary Care","Deloitte MCS Limited ","Quick Quote",41450,"2015-11-30","2016-03-31"]
["SG/RES/2015/049","Evaluation of the Caledonian Men's Programme ","Ipsos Mori ","Quick Quote",44996,"2016-02-02","2016-08-30"]
["SG/RES/2015/050","Evaluation of VAS and TSIs ","Arrivo Consultaing and Blake Stevenson","Quick Quote",40000,"2016-02-09","2016-07-31"]
["SG/RES/2015/051","Review of the Scottish Allocation Formula: Modelling the Variation in Unit Costs of Providing Primary Care ","Deloitte LLP","Quick Quote ",41450,"Jan. 2016","2016-04-30"]
["SG/RES/2015/052","Data collection from Partner providers","Ipsos Mori","Quick Quote",35000,"2016-03-23","2016-07-31"]
["SG/RES/2015/053","National workforce planning for adult social care and social services: A review of current approaches and needs for workforce planning in the social care and wider social services sector ","Why Research","Quick Quotes",9000,"2016-02-19","2016-07-29"]
["SG/RES/2015/054","The position on recruitment and retention in the social service workforce in Scotland ","Why Research","Quick Quotes",10000,"2016-02-19","2016-07-29"]
["SG/RES/2015/055","Early Years Change Fund Summary Report ","Why Research","Quick Quotes",10000,"2016-02-19","2016-07-29"]
["SG/RES/2015/056","Active Scotland Outcomes: Outcome 3 Evidence Review ",null,"Quick Quotes","Did Not Receive Any Bids - Not Going Ahead "]
["SG/RES/2015/057","A survey of Scottish public attitudes towards drug users and people in recovery","Progressive Partnership","Single stage - Quick quote via  public contracts ",12480,"2016-03-10","2016-03-30"]
["SG/RES/2015/058","Social Attitudes Surey Vehicle 2016","ScotCen","Single Stage Open",79342,"2016-04-06","2017-01-31"]
["SG/RES/2016/063","Fieldwork Programme for International Student Assessment (PISA)","National Foundation for Educational Research (NFER)","OJEU Single Stage",691030,"2015-11-01","2019-06-30","Retrospective Contract Number - Given April 2016"]
[null,"Analysis of Scottish data taken from the Performance in Primary Schools instrument","Centre for Evaluation and Monitoring, University of Durham","Non-competitive action",37000,"2015-08-01","2015-11-30"]
[]
[null,null,null,null,{"$f":"SUM(E2:E36)","v":2201273.4699999997}]

{"sheet":"Consultation Analysis contracts","index":1,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Contract Number","Project Name","Supplier Name","How awarded","total cost","Project start date","Project end date"]
["SG/RES/2015/033","The Commission on Widening Access - Call for Evidence Analysis ","Craigforth Ltd"," Framework ",5125.5,"2015-07-17","2015-08-28","Originally Picked \"R\" instead of \"CA\""]
["SG/CONS/2014/017","Non-Domestic Rating Valuation Appeals System Consultation Analysis ","Craigforth","Quick Quote",7453.75,"2015-04-09","2015-04-30"]
["SG/CONS/2014/018","Second Consultation on a New Tenancy for the Private Sedctor : Analysis of Responses","Craigforth","Housing Consultation Analysis Framework",12632.5,"2015-04-20","2015-07-10"]
["SG/CONS/2015/019","Regulatory Guidance Consultation Analysis","Commisioned on behalf of Scottish Housing Regulator","Quick Quote via Housing Consultation Analysis Framework Agreement",9212.5,"2015-04-08","2015-06-12"]
["SG/CONS/2015/020","Regulation of energy efficiency in the private sector - consultation analysis","Not going ahead until after 2016 election","Contract via Framework","Not going ahead until probably after the election","2015-07-27","2015-11-30"]
["SG/CONS/2015/021","Analysis of written evidence for the commission o local tax reform","ODS","Quick quote",11000,"2015-06-24","2015-09-09"]
["SG/CONS/2015/022","Proposals for a Lobbying Transparenct Bill: Consultation Analysis","Individual","Contract via Framework Agreement",7974.56,"2015-06-29","2015-09-19"]
["SG/CONS/2015/023","Equally Safe - Reforming the criminal law to address domestic abuse and sexual offences: Consultation Analysis","Craigforth","Contract via Framework",7872.5,"2015-06-25","2015-08-21"]
["SG/CONS/2015/024","PPYP Strategy Consultation Analysis","The Research Shop","OJEU/ Dual stage open/Single stage open/ Quick quote/ Contract via Framework / NCA",6786,"2015-08-31","2015-12-02"]
["SG/CONS/2015/025","Consultation on a draft Statutory code of practice and training requirements for letting agents in Scotland","Research Scotland","Housing Consultation Analysis Framework",6500,"2015-09-28","2016-01-11"]
["SG/CONS/2015/026","Employability Support Discussion Paper: Anaysis of Written Responses","Director, Rocket Science UK Ltd","Quick quote/Contract Via Framework",8875,"2015-09-11","2015-11-23"]
["SG/CONS/2015/027","Law of Succession: Consultation Analysis","Research Scotland","Conreact Via  Framework",9480,"2015-09-14","2015-11-30"]
["SG/CONS/2015/028","The removal of the 3 year limitation period from civil actions for damages for personal injury for in care survivors of historical child abuse: Consultation analysis.",null,"Conreact Via  Framework",5000,"2015-09-14","2015-10-30"]
["SG/CONS/2015/029","Analysis of responses to the consultation on Independent National (Whistleblowing) Officer","The Research Shop","Quick Quote via Framework/NCA",3795,"2016-12-08","2016-04-25"]
["SG/CONS/2015/030","Rehabilitation of Offenders Act 1974 - Consultation Analysis ","Griesbach & Associates","Quick Quote",3990,"2015-10-12","2015-11-20"]
["SG/CONS/2015/031","Scottish Welfare Fund Consultation Analysis ","Griesbach & Associates","Contract via Framework",3575,"2015-09-30","2015-11-06"]
["SG/CONS/2015/032","Review of Civil Partnership Consultation Analysis","Lucy Robertson, Craigforth","Contract via Framework",6768.75,"2015-12-16","2016-02-19"]
["SG/CONS/2015/033","National Improvement Framework","******","Contract via Framework","To be Resourced Internally","2015-10-26","2015-12-15"]
["SG/CONS/2015/034","Allotments Compensation Consultation","The Research Shop ","Quick Quote","Aprrox. £7,000 - Dependent on how many responses","2015-11-02","2015-11-16"]
["SG/CONS/2015/035","Analysis of Responses to Consultation on Supporter Involvement in Scottish Footbal Clubs","The Research Shop","Contract via Framework",10051.9,"2015-11-11","2016-03-31"]
["SG/CONS/2015/036","Consultation on Proposals to Strengthen the Presumption Against Short Periods of Imprisonment (PASS)","Griesbach Assoc.","Contract via Framework",3233,"2015-12-02","2016-03-31"]
["SG/CONS/2015/037","Consultation Analysis: New Regulations for Mobile Home Sites","Craigforth","Contract via Framework",2680,"2016-02-17","2016-04-25"]
["SG/CONS/2015/038","Analysis of responses to the Scottish Government Consultation on its Draft Delivery Plan 2016-2020 for the United Nations Convention on the Rights of Persons with Disabilities (UNCRPD)","********","Contract Via Framework","Didn't receive any tenders for this work - will be carried out in-house instead","2015-12-17","2015-03-24"]
["SG/CONS/2015/039","Consultation Analysis: Land Use Strategy 2016-2021","Research Scotland","Contract Let Via Consultation Analysis Framework Agreement",8000,"2016-01-06","2016-03-18","Final Number Dependent on Final Number of Responses Received"]
["SG/CONS/2015/040","Provisions for Future Islands Bills ","Reid Howie Associates","Framework",6000,"2016-01-05","2016-03-31"]
["SG/CONS/2015/041","Consultation on \"Potential controls or prohibition of electronic training aids in Scotland","Craigforth","Contract via Framework",20000,"2016-02-01","2016-04-15"]
["SG/CONS/2015/042","Digital Learning Strategy Consultation Analysis","Craigforth ","Quick quote/Contract Via Framework",3601.25,"2015-12-15","2016-02-29"]
["SG/CONS/2015/043","Analysis of responses to the consultation on\nInternational Development Policy:\n“Meeting Global Challenges & Making a Difference\n\n","Griesbach and Associates ","Quick Quote Contract via Framework",8227,"2016-04-12","2016-07-20"]
[]
[]
[null,null,null,null,{"$f":"SUM(E2:E30)","v":177834.21}]