{"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":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Race No.","Horse","API","Rating"]
[1,"A",3.1,3.4444444444444446]
[1,"B",4.1,4.555555555555555]
[1,"C",3,3.333333333333333]
[1,"D",6,6.666666666666666]
[1,"E",7.8,8.666666666666668]
[1,"F",9,10]
[1,"G",2,2.2222222222222223]
[2,"H",3,3.7974683544303796,"Here's where the problem is ie: I have to manually change the formula at this point to recognise the new race (race 2) and the fact there is not a consistent number of rows in each set of rows for each race…."]
[2,"I",4,5.063291139240506]
[2,"J",5,6.329113924050632]
[2,"K",3,3.7974683544303796]
[2,"L",4.2,5.3164556962025316]
[2,"M",6,7.594936708860759]
[2,"N",7.8,9.873417721518987]
[2,"O",7.9,10]
[2,"P",4.5,5.696202531645569]
[3,"Q",3,6,"And same here………."]
[3,"R",4,8]
[3,"S",5,10]
[3,"T",3,6]
[3,"U",4.2,8.4]
[3,"V",3,6]
[3,"W",4,8]
[3,"X",5,10]
[3,"Y",3,6]
[3,"Z",4.2,8.4]

{"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"]}