{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Sheet1"],"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":44,"n_cols":11,"rows_kept":44,"cut":false,"hidden":false,"merged":[[15,5,31,5],[25,8,26,8],[28,8,29,8],[3,9,11,9],[15,9,31,9],[21,7,23,7],[3,8,4,8],[6,8,7,8],[9,8,10,8],[15,8,16,8],[18,8,19,8],[21,8,23,8],[25,6,26,6],[28,6,29,6],[18,7,19,7],[25,7,26,7],[28,7,29,7],[15,6,16,6],[18,6,19,6],[21,6,23,6],[3,7,4,7],[6,7,7,7],[9,7,10,7],[15,7,16,7],[1,3,1,4],[1,6,1,8],[3,6,4,6],[6,6,7,6],[3,5,10,5],[9,6,10,6]],"flags":["formulas_cached_only"]}
[]
["Round","Partner Site",null,"HC - B forms",null,null,"DBS "]
[null,null,null,"B forms collected ","B forms entered","File name","DBS collected","visually inspected","back from Hyd","DBS File name","Merged file name"]
["Phase I","Hyderabad","rural",586,586,"Phase I- Form A+B data 15.01.09",751,767,767,"Final DBS InventorySHISR121208"]
[null,null,"urban",172,172]
[]
[null,null,"rural",512,512,null,695,743,743]
[null,"Bangalore","urban",214,214]
[]
[null,null,"rural",500,500,null,902,886,886]
[null,"Chandigarh","urban",408,408]
[]
[null,null,"subtotal ",2392,2392,1,2348,2396,2396,2,3]
[]
[]
["Phase II","Hyderabad","rural",548,548,"FinalphaseII form A+ Form B data 15.01.09",1054,1050,1050,"Final DBS InventorySHISR121208"]
[null,null,"urban",551,551]
[]
[null,"Bangalore","rural",649,649,null,1134,1107,1107]
[null,null,"urban",541,541]
[]
[null,"Chandigarh","rural",503,503,null,1388,1054,1054]
[null,null,"rural",432,432]
[null,null,"urban",427,427]
[]
[null,"Ahmedabad","rural",543,543,null,979,986,986]
[null,null,"urban",520,520]
[]
[null,null,"rural",330,330,null,970,968,968]
[null,"Jaipur","urban",500,500]
[]
[null,"Delhi","urban",745,745,null,727,725,725]
[]
[null,null,"subtotal ",6289,6289,4,6252,5890,5890,5,6]
[]
[null,"Grand total",null,8681,8681,7,8600,8286,8286,8,9]
[]
[]
["Imp:","Forms A to be linked to Forms B via Individual ID #"]
[null,"Forms B to be linked to Lab data (visual reports & STI results) via Sample ID #"]
[]
[null,"Total of 9 files with logical naming system (eg. Name, date) to be sent to CGHR Toronto (by CD/ FTP)"]
[null,"Merged files 3 & 6 to have complete data for each phase"]
[null,"Merged file 9 to be the final cleaned & updated dataset"]