{"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":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":"Research contracts","index":0,"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/CONS/2014/007"," The Housing Aspirations of People in Scotland","Centre For Housing Research, St Andrews University ","Quick Quote",50000,"2014-11-07","2015-06-26","C.A. Contract Number requested - Should have been Research Contract"]
["SG/CONS/2014/010","Housing and Reoffending; Trigger Points and Models of Service","Reid Howe Associates","Quick Quote",46080,"2014-12-05","2015-06-30","C.A. Contract Number requested - Should have been Research Contract"]
["SG/RES/2014/001. (amdt 27/8/14)","Scottish Schools Adolescent Lifestyle and Substance Use Survey (SALSUS) 2015","Ipsos Mori","OJEU/ /Single stage open",254496,"2014-08-25","2016-12-31","Amdt to form 27/8/14 with text in cost \"if the electronic survey runs.  Less if it doesn’t.  Decision will be made after feasibility study\". "]
["SG/RES/2014/002","Five Year Review of the Home Report","Rettie & Co","Dual Stage Open",50650,"09/06/2014.","2014-11-28"]
["SG/RES/2014/003","Developing Regulation of the Energy Efficiency of Private Sector Housing: Technical Underpinnigs","IPSOS MORI Scotland","Contract Via Framework",46020,"2014-05-16","2014-12-12"]
["SG/RES/2014/004","Public Perception of Sectarianism in Scotland","Scotcen/Natcen Social Research","Dual Stage Open",76235,"2014-03-10","2014-12-19"]
["SG/RES/2014/005","Community Unity Experiences of Sectarianism in Scotland","University of Sirling","Dual Stage Open",73281,"2014-03-18","2014-12-19"]
["SG/RES/2014/006","Flexible Evaluation for Community Safety","5 Suppliers: 1.ODS Consuting 2. Rocket Science 3. Research for Real 4.Iconic Consulting 5. Blake Stevenson","Dual Stage Contract via Framework",100000,"2014-12-01","2016-12-01","Cost Anticipated"]
["SG/RES/2014/007","Review of the Alliance","ODS Consulting","Quick Quote",14790,"2014-07-31","2014-10-31"]
["SG/RES/2014/008","Whole Systems Approach Evalaution","SCCJR (Glasgow and Edinburgh Universities)","Quick Quote",50000,"2014-08-19","2015-03-31"]
["SG/RES/2014/009","Doran Review: Needs Analysis for Strategic Commissioning of Services for Children with Complex Additional Support Needs","ODS Consulting","Dual stage competition tender",84240,"2014-09-16","2015-03-31"]
["SG/RES/2014/010","Young People in Scotland Survey","IPSOS-MORI","NCA",50000,"2014-09-19","2015-02-28"]
["SG/RES/2014/011","Impact Evaluation of the Community Right to Buy","Ipsos MORI Scotland","Dual Stage Open",59883.6,"2014-10-30","2015-05-29"]
["SG/RES/2014/012","Future Support and Advice to Rural Communities","Rocket Science UK Ltd","OJEU/ Dual stage open/Single stage open/ Quick quote/ Contract via Framework / NCA",26090,"2014-10-06","2015-01-09"]
["SG/RES/2014/013","Young People in Scotland Survey Questions (2014)",null,"/NCA","0**","2015-09-19","31/02/2015","** Mistake, requested a contract number twice."]
["SG/RES/2014/014","Evaluation of Police and Fire Reform","University of Dundee","OJEU",268626,"2015-02-01","2019-01-31"]
["SG/RES/2014/015","Survey of the Economic and Financial Conditions in Crofting","Exodus Market Research Ltd","Quick Quote",21930,"2014-09-26","2014-11-21"]
["SG/RES/2014/016","Scottish Maternity Care Experience  Follow-Up Survey","Quality Care Experience Follow Up Survey","NCA (from a Framework Agreement)",7128.85,"2014-09-02","2015-01-30"]
["SG/RES/2014/017","Evidence Review on Scaling up Inovation","What Works Scotland Centre","Quick Quote",0,"2014-11-24","2015-02-28","Undertaken by What Works Scotland Centre as part of Existing Funding - Did not proceed with commissioning externally"]
["SG/RES/2014/018","Mapping Flood Disadvantage in Scotland 2015","Cardiff University ","Single stage open",31682,"2015-02-16","2015-07-13"]
["SG/RES/2014/019","Review of the Climate Challenge Fund","Changeworks","Quick Quote",47595.6,"2015-04-23","2015-09-30"]
["SG/RES/2014/020","New Psychoactive Substances – Public Opinion Research",null,"Quick Quote","Research Did Not Go Ahead  ","2014-12-15","2015-01-31"]
["SG/RES/2014/021","Cosmetic Intervention","YouGov","Quick Quote",11998,"2014-12-18","30/02/2015"]
["SG/RES/2014/022","Scottish Schools Adolescent Lifestyle and Substance Use Survey (SALSUS): Creating a Simplified Dataset for Time Series Analysis","Ipsos Mori","Quick Quote",34500,"2015-02-12","2015-09-30"]
["SG/RES/2014/023","Peer Review of Scottish Government Carers Publication","****","NCA",962,"2015-02-23","2015-03-13"]
["SG/RES/2014/024","Qualitative Research into the Views of Parents and Teachers on Online Privacy and GLOW","Reid Howie Associates","Quick Quote",7755,"2014-11-13","2015-03-31"]
["SG/RES/2014/025","A Poverty Typology for Scotland: Latent Class Analysis","City University London","Quick Quote",24900,"2015-02-24","2015-07-24"]
["SG/RES/2014/026","Identifying the prevalence and harms of New Psychoactive Substances (NPS) amongst vulnerable groups in Scotland","contract not signed moved to 2015/16","Dual stage ",0,"Contract not awarded  ","Expected March 2016"]
[null,"Young People in Scotland Omnibus Survey Questions","IPSOS Mori","Non-competitive action",50000,"2014-07-01","2015-01-31"]
[]
[null,null,null,null,{"$f":"SUM(E2:E30)","v":1488843.0500000003}]

{"sheet":"Consultation Analysis contracts","index":1,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[7,0,7,6],[10,0,10,6]]}
["Contract Number","Project Name","Supplier Name","How awarded","total cost","Project start date","Project end date"]
["SG/CONS/2014/001","Consultation Analysis of Responses to the Draft Heat Generation Policy Statement","Reid Howie Associates Ltd","Quick Quote/Contract via Framework/NCA",6972,"2014-07-11","2014-09-12"]
["SG/CONS/2014/002","Consultation Analysis – Land and Building Transactions (Scotland) Act 2013","Research Shop","Quick quote/ Contract via Framework ",5760,"2014-08-04","2014-09-19"]
["SG/CONS/2014/003","Drug Driving: Proposed Regulations Consultation Analysis","Griesbach and Associates","Contract Via Framework",2397,"2014-11-17","2015-01-23"]
["SG/CONS/2014/004","National Care Standards Review Consultation Analysis","The Research Shop","Contract Via Framework",12965,"2014-10-15","2014-12-19"]
["SG/CONS/2014/005","Consultation Analysis, Gaelic Medium Education Bill","The Research Shop","Framework contract – mini competition",3842.5,"2014-09-01","2014-10-31"]
["SG/CONS/2014/006","Consultation on Proposals to Reform Fatal Accident Inquires legislation","Craigforth Research and Consultancy","Contract Via Framework",3936.25,"2014-09-22","2014-11-07"]
["Transferred to Research Contracts Spreadsdheet (SG/CONS/2014/007)"]
["SG/CONS/2014/008","Tobacco and E-cigarettes: Consultation Analysis 2014-15","Craigforth Research and Consultancy Research","Quick quote/Contract via Framework",13764,"2014-12-03","2015-03-23"]
["SG/CONS/2014/009","Becoming a Good Food Nation: An Analysis of Consultation Responses","Griesbach & Associates ","Contract Via Framework",6754,"2014-12-01","2015-01-31"]
["Transferred to Research Contracts Spreadsdheet (SG/CONS/2014/010)"]
["SG/CONS/2014/011","Consultation Analysis: A New Tenancy for the Private Rented Sector","Craigforth Consultancy","Contract Via Framework",19889.5,"2014-11-11","2015-02-19"]
["SG/CONS/2014/012","Analysis of Responses to Consultation on Proposals for an Offence of Wilful Neglect or ill-Treatment in Health and Social Care Settings; and Proposals\n","Griesbach and Associates","Quick Quote Contract Via Framework",7959,"2014-12-18","2015-05-29"]
["SG/CONS/2014/013","Higher Education Governance (Scotland) Bill Call for Evidence: Analysis of Written Responses","Research Shop","Contract Via Framework",5742,"2015-01-19","2015-02-27"]
["SG/CONS/2014/014","Procurement Reform Consultation Analysis","Why Research","Contract Via Framework",12000,"2015-04-20","2015-09-30"]
["SG/CONS/2014/015","National Directory of Interventions","Griesbach and Associates","Contract Via Framework",4977.5,"2015-03-19","2015-05-15"]
["SG/CONS/2014/016","Analysis of responses to the Public Health Review","Griesbach and Associates","Contract Via Framework",8390.2000000000007,"2015-03-11","2015-06-17"]
[]
[null,null,null,null,{"$f":"SUM(E2:E18)","v":115348.95}]