{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":30,"n_cols":17,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,3,0,5],[0,7,0,11],[0,13,0,16],[29,0,31,16]],"flags":["formulas_cached_only"]}
[null,"All",null,"Malaria severity",null,null,null,"Temporal",{"$nulls":5},"Geographic"]
[null,1,null,2,3,4,null,5,6,7,8,9,null,10,11,12,13]
["A"]
["Variance",0.67,null,0.63,0.7,0.63,null,0.67,0.65,0.67,0.67,0.67,null,0.58,0.75,0.65,0.62]
["%Pf",0.36,null,0.31,0.33,0.26,null,0.36,0.37,0.38,0.36,0.35,null,0.3,0.35,0.35,0.33]
["ABER",0.23,null,0.2,0.19,0.17,null,0.25,0.23,0.21,0.21,0.25,null,0.21,0.34,0.34,0.22]
["API",0.43,null,0.43,0.43,0.45,null,0.42,0.42,0.43,0.43,0.43,null,0.43,0.42,0.43,0.45]
["AFI",0.45,null,0.47,0.45,0.47,null,0.45,0.45,0.45,0.45,0.45,null,0.48,0.43,0.46,0.47]
["SPR",0.4,null,0.41,0.41,0.44,null,0.41,0.4,0.4,0.4,0.4,null,0.41,0.39,0.35,0.43]
["SFR",0.44,null,0.45,0.44,0.45,null,0.44,0.44,0.44,0.44,0.44,null,0.47,0.42,0.44,0.46]
["MR",0.27,null,0.29,0.33,0.29,null,0.27,0.26,0.28,0.28,0.27,null,0.24,0.27,0.21,0.15]
["B"]
["Variance",0.58,null,0.54,0.61,0.53,null,0.59,0.58,0.59,0.59,0.59,null,0.49,0.68,0.56,0.51]
["%Pf",0.49,null,0.46,0.45,0.42,null,0.49,0.5,0.5,0.49,0.48,null,0.45,0.46,0.49,0.48]
["ABER",0.27,null,0.19,0.2,0.12,null,0.27,0.25,0.24,0.24,0.3,null,0.28,0.41,0.44,0.25]
["SPR",0.48,null,0.48,0.5,0.54,null,0.49,0.48,0.48,0.49,0.48,null,0.47,0.47,0.4,0.53]
["SFR",0.56,null,0.58,0.55,0.59,null,0.55,0.56,0.55,0.56,0.55,null,0.6,0.52,0.56,0.61]
["MR",0.39,null,0.43,0.45,0.42,null,0.38,0.38,0.39,0.39,0.38,null,0.38,0.37,0.32,0.24]
["C"]
["Variance",0.65,null,0.58,0.64,0.58,null,0.65,0.64,0.65,0.65,0.65,null,0.55,0.75,0.65,0.61]
["%Pf",0.52,null,0.5,0.52,0.45,null,0.52,0.53,0.54,0.53,0.51,null,0.49,0.49,0.51,0.5]
["ABER",0.29,null,0.19,0.2,0.11,null,0.3,0.27,0.25,0.26,0.33,null,0.28,0.43,0.44,0.25]
["SPR",0.53,null,0.55,0.56,0.61,null,0.53,0.52,0.53,0.54,0.52,null,0.52,0.51,0.43,0.55]
["SFR",0.6,null,0.65,0.62,0.65,null,0.6,0.6,0.6,0.6,0.59,null,0.65,0.56,0.59,0.63]
["F"]
["Variance",null,null,0.85,0.89,0.8,null,0.86,0.86,0.87,0.84,0.83,null,0.84,0.84,0.84,0.79]
["%Pf",null,null,0.53,0.55,0.51,null,0.54,0.54,0.55,0.53,0.52,null,0.52,0.52,0.53,0.49]
["AFI",null,null,0.59,0.59,0.6,null,0.59,0.59,0.59,0.6,0.6,null,0.6,0.6,0.61,0.61]
["SFR",null,null,0.6,0.6,0.62,null,0.6,0.6,0.59,0.6,0.6,null,0.61,0.61,0.6,0.62]
["Variance: Total variance explained by the first axis of each PCA.  Values in other rows are loadings of the row variable on the first PCA axis.  For each PCA, all loadings had the same sign within each first axis, so here we present absolute values.  Individual measures are: %Pf= percent of positive slides that are falciparum-positive; ABER= annual blood examination rate; API= annual parasite index; AFI= annual falciparum index; SPR= slide positivity rate; SFR= slide falciparum rate; MR=deaths/population.  Analyses were run on the following variable subsets: A: all; B: Not API or AFI; C: Not API, AFI, or MR; F: Only falciparum measures.  Column numbers refer to subsets of observations used: 1=all, 2=SFR>0, 3=deaths>0, 4=%Pf>15, 5=1995-1996, 6=1997-98, 7=1999-2000, 8=2001-02, 9=2003-05, 10=Northern states, 11=Northeastern states, 12=Central states, 13=Southern states."]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}