{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Source","Unemployment rates","Data for template chart","Legend example"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":16,"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":"Source","index":0,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["Inputs describing the data"]
["Number of series per chart",3]
["Number of charts",12]
[]
[]
["Inputs to control layout and design of small multiples"]
["Width of first column of worksheet (mm)",9]
["Width of column after last chart (mm)",9]
["Width of one small chart (mm)",47]
["Height of one small chart (mm)",45]
["Horizontal gap between charts (mm)",10]
["Vertical gap between charts (mm)",10]
["Charts per row",4]
["Rename series with template names?",true]
["Increase width by this factor:",1.2]
["Increase height by this factor:",1.2]
["Remove some tick mark labels",false]
["Titles on charts? ('False' for titles in cells)",false]
[]
[]
["Description of output charts (don't edit)"]
["Number of rows of charts",{"$f":"ROUNDUP(NumberOfCharts/ChartsPerRow,0)","v":3}]
["Total width (mm)",{"$f":"ChartsPerRow*ChtWidth+(ChartsPerRow-1)*HorizontalGap","v":218}]
["Total height (mm)",{"$f":"B27*ChtHeight+B27*VerticalGap","v":165}]

{"sheet":"Unemployment rates","index":1,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[null,"Unemployment rates"]
[null,"Source: ONS"]
[null,"Dowloaded from Nomis on 24 March 2013"]
[null,"https://www.nomisweb.co.uk/default.asp"]
[]
[null,null,2004,"05","06","07","08","09","10","11"]
["All","North East",5.9,5.7,6.9,6.2,7.5,9.6,9.8000000000000007,10.6]
[null,"Yorkshire and The Humber",4.5,4.8,5.6,5.5,6.3,8.6,8.8000000000000007,9.5]
[null,"West Midlands",5.2,5.0999999999999996,5.6,5.9,7,9.4,8.8000000000000007,9.3000000000000007]
[null,"London",7.2,7.2,7.6,6.8,6.9,9,8.6999999999999993,9.1999999999999993]
[null,"North West",4.7,5.2,5.4,5.6,6.3,8.6,8,8.5]
[null,"Wales",4.8,5.2,5.2,5.6,6.3,8.3000000000000007,8.4,8.3000000000000007]
[null,"East Midlands",4.3,4.7,5.2,5,5.9,7.3,7.5,8.1]
[null,"Scotland",5.3,5.3,5.2,4.7,4.9000000000000004,7,7.7,8.1]
[null,"Northern Ireland",5.2,4.5,4.8,4.0999999999999996,4,6.7,7.1,7.3]
[null,"East",3.7,4,4.5999999999999996,4.3,4.9000000000000004,6.3,6.6,6.6]
[null,"South West",3.4,3.4,3.8,4,4.2,6.2,6,6.1]
[null,"South East",3.7,3.7,4.5,4.2,4.4000000000000004,5.9,6,5.9]
["Males","North East",6.5,6.4,8,7,8,11.2,11.3,12.1]
[null,"Yorkshire and The Humber",5.3,5.2,6.5,5.9,7.4,10,9.9,11.3]
[null,"West Midlands",5.5,5.6,5.9,6.3,7.7,11,10.4,10.3]
[null,"London",7.2,7.8,7.9,6.6,6.8,8.8000000000000007,8.8000000000000007,9.1]
[null,"North West",5.0999999999999996,5.9,6.2,6.1,7.3,9.9,9.1,9.6999999999999993]
[null,"Wales",5.2,6.1,5.8,5.9,6.9,10.1,10.3,9.5]
[null,"East Midlands",4.5999999999999996,5.2,5.6,4.9000000000000004,6.3,7.8,8.4,8]
[null,"Scotland",6.2,6.3,6.2,5.0999999999999996,5.2,8.1,9.1,8.6999999999999993]
[null,"Northern Ireland",6.5,5.3,5.8,4.5999999999999996,5.3,8.6,9.3000000000000007,9.1999999999999993]
[null,"East",3.8,4.0999999999999996,4.5,4.4000000000000004,5.0999999999999996,6.8,7,6.5]
[null,"South West",3.9,3.7,3.9,4.0999999999999996,4.4000000000000004,7.2,6.5,6.9]
[null,"South East",3.8,3.8,4.5,4.5,4.4000000000000004,6.6,6.7,6.1]
["Females","North East",5.0999999999999996,4.9000000000000004,5.7,5.3,7,7.8,8.1,8.8000000000000007]
[null,"Yorkshire and The Humber",3.7,4.3,4.5999999999999996,5.0999999999999996,5,6.9,7.4,7.4]
[null,"West Midlands",4.7,4.5,5.0999999999999996,5.4,6.1,7.5,7,8.1]
[null,"London",7.2,6.4,7.2,7,7.1,9.1999999999999993,8.6,9.1999999999999993]
[null,"North West",4.0999999999999996,4.5,4.4000000000000004,5.0999999999999996,5.3,6.9,6.7,7]
[null,"Wales",4.3,4.0999999999999996,4.5,5.3,5.7,6.1,6.2,7]
[null,"East Midlands",3.9,4.2,4.8,5.2,5.4,6.8,6.4,8.1999999999999993]
[null,"Scotland",4.4000000000000004,4.3,4.0999999999999996,4.3,4.5999999999999996,5.8,6.2,7.3]
[null,"Northern Ireland",3.6,3.4,3.7,3.6,2.2999999999999998,4.4000000000000004,4.4000000000000004,5]
[null,"East",3.5,3.9,4.5999999999999996,4.2,4.5999999999999996,5.8,6,6.9]
[null,"South West",2.8,3.1,3.6,3.7,3.9,5.0999999999999996,5.5,5.0999999999999996]
[null,"South East",3.5,3.6,4.5,3.8,4.5,5.0999999999999996,5.0999999999999996,5.7]

{"sheet":"Data for template chart","index":2,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Data series for template chart"]
["(Not real data)"]
[]
[null,2004,"05","06","07","08","09","10","11"]
["All",3,3,3,3,3,3,3,3]
["Males",2,2,2,2,2,2,2,2]
["Females",1,1,1,1,1,1,1,1]

{"sheet":"Legend example","index":3,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Legend example"]
["All",-1,-1]
["Males",-1,-1]
["Females",-1,-1]