{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Introduction","g_cloud_api"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":81,"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":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,1,8]]}
[]
["Welcome to the GovSpend.Org.UK G-Cloud Analysis spreadsheet"]
[]
["This spreadsheet is a demonstration of how to implement the GovSpend.Org.UK G-Cloud API"]
[]
["Use the 'g_cloud_api' spreadsheet to query the data hosted on the GovSpend.Org.UK web site."]
[]
["For develipers there is also a macro (g_cloud_api) that aims to demonstrate how the API works."]
[]
["Please send us your feedback at:",null,null,"support@govspend.org.uk"]
[]
["Many thanks"]

{"sheet":"g_cloud_api","index":1,"n_rows":109,"n_cols":7,"rows_kept":109,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["G-Cloud Spend Analysis"]
["Instructions - enter your query in the cells of Row 4 (and 6 for Date to and Amount to) then press Search G-Cloud Spend button"]
["Framework","Lot","Supplier","Customer","Date From","Product","Amount From"]
[null,4,null,"Council","2013-01-01",null,100]
["Notes - text searches use 'contains' so you don’t need to be exact with your query",null,null,null,"Date To",null,"Amount To"]
["            - to run a search you must be connected to the internet,",null,null,null,"2014-01-01",null,5000]
[]
[]
["Framework","Lot","Supplier","Customer","Date","Product","Amount"]
[null,null,null,null,null,"TOTAL",{"$f":"SUM(G13:G15000)","v":179536.35}]
[]
["Framework","Lot","Supplier","Customer","Date","Product","Amount"]
["G-Cloud III",4,"ARCUS GLOBAL LTD","Buckinghamshire County Council","2013-11-01",null,3846.1]
["G-Cloud Services II",4,"JADU LTD","Melton Borough Council","2013-12-01",null,705.6]
["G-Cloud III",4,"Methods Consulting Ltd","London Borough of Hounslow Council","2013-11-01",null,2100]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-08-01",null,425]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-08-01",null,425]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-08-01",null,850]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-12-01",null,850]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-12-01",null,850]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-12-01",null,425]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-12-01",null,850]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-12-01",null,850]
["G-Cloud III",4,"InProc Ltd","Bristol City Council","2013-08-01",null,4375]
["G-Cloud III",4,"InProc Ltd","Bristol City Council","2013-09-01",null,3622.5]
["G-Cloud 4",4,"Alpine Resourcing Limited","Bristol City Council","2014-01-01",null,4315.7]
["G-Cloud III",4,"Digirati","Bristol City Council","2013-10-01",null,2609.67]
["G-Cloud III",4,"Parity Group PLC","Bristol City Council","2013-07-01",null,1725]
["G-Cloud III",4,"IXIS IT LTD","British Council","2013-08-01",null,4500]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Bury Metropolitan Borough Council","2013-11-01",null,637.5]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Bury Metropolitan Borough Council","2013-12-01",null,850]
["G-Cloud III",4,"Connection Point Technology Ltd","City of Edinburgh Council","2013-12-01",null,4982.5200000000004]
["G-Cloud Services II",4,"JADU LTD","Melton Borough Council","2013-12-01",null,1843.2]
["G-Cloud III",4,"Methods Consulting Ltd","London Borough of Hounslow Council","2014-01-01",null,4200]
["G-Cloud III",4,"Methods Consulting Ltd","London Borough of Hounslow Council","2013-12-01",null,1375]
["G-Cloud III",4,"Methods Consulting Ltd","London Borough of Hounslow Council","2013-12-01",null,3900]
["G-Cloud III",4,"Methods Consulting Ltd","London Borough of Hounslow Council","2014-01-01",null,2000]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-08-01",null,850]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-08-01",null,425]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-08-01",null,850]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-12-01",null,425]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-12-01",null,425]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-12-01",null,850]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-12-01",null,425]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-12-01",null,212.5]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-12-01",null,850]
["G-Cloud III",4,"Methods Consulting Ltd","London Borough of Hounslow Council","2014-01-01",null,1687.5]
["G-Cloud Services II",4,"Methods Consulting Ltd","London Borough of Hounslow Council","2013-07-01",null,3900]
["G-Cloud III",4,"Methods Consulting Ltd","London Borough of Hounslow Council","2013-10-01",null,4000]
["G-Cloud III",4,"ARCUS GLOBAL LTD","London Borough of Hounslow Council","2013-12-01",null,4500]
["G-Cloud III",4,"ARCUS GLOBAL LTD","London Borough of Hounslow Council","2013-12-01",null,1075]
["G-Cloud III",4,"ARCUS GLOBAL LTD","London Borough of Hounslow Council","2013-12-01",null,750]
["G-Cloud III",4,"Methods Consulting Ltd","London Borough of Hounslow Council","2013-12-01",null,3750]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-08-01",null,850]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-08-01",null,850]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-12-01",null,425]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-12-01",null,425]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-12-01",null,212.5]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-12-01",null,637.5]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-12-01",null,850]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-12-01",null,850]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-12-01",null,850]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Walsall Metropolitan Borough Council","2013-12-01",null,850]
["G-Cloud III",4,"ARCUS GLOBAL LTD","Tandridge District Council","2013-12-01",null,5000]
["G-Cloud III",4,"Parity Group PLC","Bristol City Council","2013-07-01",null,1035]
["G-Cloud III",4,"Parity Group PLC","Bristol City Council","2013-07-01",null,1725]
["G-Cloud III",4,"InProc Ltd","Bristol City Council","2013-05-01",null,3750]
["G-Cloud III",4,"InProc Ltd","Bristol City Council","2013-10-01",null,1875]
["G-Cloud III",4,"InProc Ltd","Bristol City Council","2013-10-01",null,2300]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Bury Metropolitan Borough Council","2013-11-01",null,425]
["G-Cloud III",4,"InProc Ltd","Bristol City Council","2013-09-01",null,1627.5]
["G-Cloud 4",4,"Alpine Resourcing Limited","Bristol City Council","2014-01-01",null,2157.85]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Bury Metropolitan Borough Council","2013-11-01",null,2550]
["G-Cloud III",4,"NCC GROUP PLC","Advisory Council on National Records and Archives","2013-12-01",null,2992.5]
["G-Cloud Services II",4,"IO1 LTD","London Borough of Lambeth Council","2013-03-01",null,4500]
["G-Cloud III",4,"North Highland UK Ltd","Westminster City Council","2013-11-01",null,4380]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Wirral Metropolitan Borough Council","2013-09-01",null,850]
["G-Cloud III",4,"4C Strategies Ltd","Wiltshire Council","2013-10-01",null,3500]
["G-Cloud III",4,"4C Strategies Ltd","Wiltshire Council","2013-11-01",null,700]
["G-Cloud III",4,"Methods Consulting Ltd","Argyll and Bute Council","2013-12-01",null,2666.66]
["G-Cloud III",4,"ARCUS GLOBAL LTD","Buckinghamshire County Council","2013-06-01",null,2394.35]
["G-Cloud Services II",4,"JADU LTD","Melton Borough Council","2013-12-01",null,2073.6]
["G-Cloud Services II",4,"JADU LTD","Melton Borough Council","2013-12-01",null,1176]
["G-Cloud Services II",4,"JADU LTD","Melton Borough Council","2013-12-01",null,3057.6]
["G-Cloud Services II",4,"Methods Consulting Ltd","London Borough of Hounslow Council","2013-07-01",null,2275]
["G-Cloud III",4,"Methods Consulting Ltd","London Borough of Hounslow Council","2013-11-01",null,4500]
["G-Cloud III",4,"Methods Consulting Ltd","London Borough of Hounslow Council","2013-11-01",null,3000]
["G-Cloud Services II",4,"Methods Consulting Ltd","London Borough of Hounslow Council","2013-06-01",null,3900]
["G-Cloud III",4,"ARCUS GLOBAL LTD","London Borough of Hounslow Council","2013-10-01",null,4125]
["G-Cloud III",4,"Methods Consulting Ltd","London Borough of Hounslow Council","2013-12-01",null,3500]
["G-Cloud III",4,"Methods Consulting Ltd","London Borough of Hounslow Council","2013-12-01",null,1750]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-08-01",null,850]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-08-01",null,850]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-08-01",null,850]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-08-01",null,425]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-12-01",null,425]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-12-01",null,637.5]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-12-01",null,212.5]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-12-01",null,850]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-12-01",null,850]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Northumberland County Council","2013-12-01",null,850]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Walsall Metropolitan Borough Council","2013-12-01",null,850]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Walsall Metropolitan Borough Council","2013-12-01",null,850]
["G-Cloud III",4,"Steria Ltd","Worcestershire County Council","2014-01-01",null,1560]
["G-Cloud 4",4,"InProc Ltd","Bristol City Council","2013-11-01",null,2415]
["G-Cloud 4",4,"InProc Ltd","Bristol City Council","2013-11-01",null,1497.5]
["G-Cloud III",4,"Parity Group PLC","Bristol City Council","2013-08-01",null,690]
["G-Cloud III",4,"SCC (Specialist Computer Centre)","Bury Metropolitan Borough Council","2013-09-01",null,1700]
["G-Cloud Services II",4,"IO1 LTD","London Borough of Lambeth Council","2013-03-01",null,4500]