{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Info","Input data","Summary statistics","Animation"],"not_rendered":{"charts":0,"images":1,"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":"Info","index":0,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["HIGHLIGHT",null,null,null,"Version 2.1. Apr 4, 2010"]
[" - a VBA program for sequential highlighting of subsets of data"]
[]
["Program development: Anders Grimvall"]
["Department of Computer and Information Science, Linköping University"]
[]
["The main output of HIGHLIGHT is an animated bubble-chart. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The open markers represent the set of all observed cases and is fixed throughout the animation."]
[]
["The sets of solid markers, which represent subsets of observations, are updated when the value of"]
["an animation key (shown in the chart title) is updated."]
[]
["A group variable can be used to assign different markers to different groups of observations."]
["A bubble-size variable can provide additional information about the displayed cases."]
[]
["A VBA macro attached to the worksheet \"Input data\" is used to select variables for the animation"]
["and make a standardized table of the selected data in a new worksheet called \"Animation\"."]
[]
["Four control buttons and three scroll-bars attached to the \"Animation\" sheet can then be used"]
["to produce motion-charts."]
[]
["Inputs to HIGHLIGHT are pasted as a table where each row represents a case and each column"]
["a variable. The first row is used for variable names, and blank cells stand for missing values. "]
[]
[null,"Year","Month","Lab","Water_temp.","pH","Salinity"]
[null,1994,2,"Lab 1",3.5,7.81,9.4]
[null,1994,8,"Lab 2",14.1,8.65,9]
[null,1997,2,"Lab 1",4.0999999999999996,7.63,10.1]
[null,1997,8,"Lab 2",10.9,8.44,10.3]
[null,2000,2,"Lab 1",2.9,6.1,8.8000000000000007]
[null,2000,8,"Lab 1",11.7]
[null,2005,8,"Lab 2",8.5,8.5,8.6]
[null,2007,8,"Lab 1",8.3000000000000007,7.3,8.6999999999999993]
[null,2009,4,"Lab 2",6,7,9.6]
[null,2009,4,"Lab 2",6.1,8.1,9.8000000000000007]
[null,".",".",".",".",".","."]
[]
["The VBA macros are developed for a PC on which Excel 2007 is installed."]
["A relatively fast PC can handle datasets comprising up to about 100,000 cases."]

{"sheet":"Input data","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Summary statistics","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Animation","index":3,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[0]
[1000]
[40]
[]
[{"$f":"1+INT($A$3*$A$1/1001)","v":1}]
[{"$f":"MAX(1+INT($A$3*$A$2/1001),$A$5)","v":40}]
[5]
[2]
[478]
[1]
[1000]