{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet 1","Required"],"not_rendered":{"charts":0,"images":3,"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":"Sheet 1","index":0,"n_rows":32,"n_cols":37,"rows_kept":32,"cut":false,"hidden":false,"merged":[[22,5,22,10],[28,5,28,10],[1,3,1,21],[3,3,3,21],[5,3,5,42],[8,3,8,12],[12,2,12,6],[10,3,10,42],[6,6,6,10],[12,9,12,14],[14,9,14,14],[6,12,6,15],[16,12,16,15],[14,2,14,6],[16,5,16,10],[1,23,1,31],[3,23,3,31],[8,25,8,27],[19,25,20,27],[25,25,26,27],[6,21,6,25],[16,21,16,25],[22,21,22,25],[8,19,8,23],[19,19,20,23],[25,19,26,23],[6,17,6,19],[16,17,16,19],[22,17,22,19],[8,14,8,17],[19,14,20,17],[31,29,32,33],[6,27,6,29],[16,27,16,29],[22,27,22,29],[28,27,28,29],[31,25,32,27],[28,21,28,25],[31,19,32,23],[28,17,28,19],[25,14,26,17],[31,14,32,17],[22,12,22,15],[28,12,28,15],[19,3,20,12],[25,3,26,12],[31,3,32,12],[22,36,22,38],[24,36,25,40],[28,36,28,38],[30,36,31,40],[3,33,3,42],[6,36,6,38],[8,36,8,39],[16,36,16,38],[18,36,19,40],[6,31,6,33],[16,31,16,33],[22,31,22,33],[28,31,28,33],[8,29,8,33],[19,29,20,33],[25,29,26,33]]}
[]
[]
[]
[]
[]
[]
[null,null,null,"Allocation ID",null,null,"Description",null,null,null,null,null,"From Date",null,null,null,null,"From Time",null,null,null,"To Date",null,null,null,null,null,"To Time",null,null,null,"Charge Type",null,null,null,null,"Booking Charge"]
[]
[null,null,null,"Purpose of Booking",null,null,null,null,null,null,null,null,null,null,"Booked By",null,null,null,null,"Booked For",null,null,null,null,null,"Department",null,null,null,"Account Code",null,null,null,null,null,null,"Staff Name"]
[]
[]
[]
[null,null,"Allocation Status :",null,null,null,null,null,null,"Allocated"]
[]
[null,null,"Date:",null,null,null,null,null,null,"2015-12-18"]
[]
[null,null,null,"PPP891",null,"WXYZ82021",null,null,null,null,null,null,"2015-12-18",null,null,null,null,"00:00:00",null,null,null,null,null,null,null,null,null,"23:59:00",null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maninder Cheema"]
[null,null,null,"Test Allocation",null,null,null,null,null,null,null,null,null,null,"Ketan Kumar",null,null,null,null,"Department",null,null,null,null,null,"Manual"]
[]
[]
[null,null,null,"PPP890",null,"WXYZ82020",null,null,null,null,null,null,"2015-12-18",null,null,null,null,"00:00:00",null,null,null,null,null,null,null,null,null,"23:59:00",null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Abhijeet Samel"]
[null,null,null,"Test Allocation",null,null,null,null,null,null,null,null,null,null,"Ketan Kumar",null,null,null,null,"Department",null,null,null,null,null,"Manual"]
[]
[]
[null,null,null,"PPP889",null,"WXYZ82019",null,null,null,null,null,null,"2015-12-18",null,null,null,null,"00:00:00",null,null,null,null,null,null,null,null,null,"23:59:00",null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anirban Sengupta"]
[null,null,null,"Test Allocation",null,null,null,null,null,null,null,null,null,null,"Ketan Kumar",null,null,null,null,"Department",null,null,null,null,null,"Manual"]

{"sheet":"Required","index":1,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[3,13,3,18],[5,1,5,18],[1,1,1,8],[1,9,1,12],[3,1,3,8],[3,9,3,12]]}
[]
[]
[]
[]
[]
[]
[null,"Allocation ID","Purpose of Booking","Description","From Date","Booked By","From Time","Booked For","To Date","Department","To Time","Account Code","Charge Type","Staff Name","Booking Charge"]
[null,"PPP891","Test Allocation","WXYZ82021","2015-12-18","Ketan Kumar","00:00:00","Department",null,"Manual","23:59:00",null,null,"Maninder Cheema",0]
[null,"PPP890","Test Allocation","WXYZ82020","2015-12-18","Ketan Kumar","00:00:00","Department",null,"Manual","23:59:00",null,null,"Abhijeet Samel",0]
[null,"PPP889","Test Allocation","WXYZ82019","2015-12-18","Ketan Kumar","00:00:00","Department",null,"Manual","23:59:00",null,null,"Anirban Sengupta",0]