{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["31.03.2016","31.03.2018","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"}

{"sheet":"31.03.2016","index":0,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[19,0,20,5]]}
["XXXXXXXXXXXXX"]
["Profit & Loss Account for the year ending 31-03-2016"]
["Opening Stock",212200,null,"Sales",1625220]
["Purchase",495450,null,"Closing Stock",220550]
["Direct Expenses",{"$f":"329500","v":329500}]
["Gross Profit",{"$f":"E8-SUM(B3:B5)","v":808620}]
[]
[null,{"$f":"SUM(B3:B7)","v":1845770},null,null,{"$f":"SUM(E3:E7)","v":1845770}]
[]
["Staff Salary",{"$f":"70880","v":70880},null,"Gross Profit",{"$f":"B6","v":808620}]
["Administration Expense",{"$f":"52556","v":52556},null,"Other Income",19250]
["Rent & Electricity",175450]
["Conveyance & Travelling",{"$f":"25202","v":25202}]
["Net Profit",{"$f":"E16-SUM(B10:B13)","v":503782}]
[]
[null,{"$f":"SUM(B10:B14)","v":827870},null,null,{"$f":"SUM(E10:E15)","v":827870}]
[]
[]
[]
["Balancesheet as on 31-03-2016"]
[]
["Capital",500000,null,"Closing Stock",null,{"$f":"'31.03.2016'!E4","v":220550}]
["Add- Net Profit",{"$f":"'31.03.2016'!B14","v":503782},null,"Sundry Debtor",null,{"$f":"'31.03.2016'!E3/12","v":135435}]
["Less- Drawings",360000,{"$f":"B22+B23-B24","v":643782},"Cash in Hand",null,{"$f":"F27-F22-F23","v":370372}]
["Creditors",null,{"$f":"'31.03.2016'!B4/12*2","v":82575}]
[]
[null,null,{"$f":"C24+C25","v":726357},null,null,{"$f":"C27","v":726357}]

{"sheet":"31.03.2018","index":1,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[23,0,23,1],[17,0,17,4],[15,2,15,3],[2,2,2,3],[3,2,3,3],[9,2,9,3],[10,2,10,3]]}
["XXXXXXXXXX"]
["Profit & Loss Account for the year ending 31-03-2018"]
["Opening Stock",325220,"Sales",null,12721550]
["Purchase",10702200,"Closing Stock",null,255220]
["Direct Expenses",{"$f":"955220-75340-5100","v":874780}]
["Gross Profit",{"$f":"E8-SUM(B3:B5)","v":1074570}]
[]
[null,{"$f":"SUM(B3:B7)","v":12976770},null,null,{"$f":"SUM(E3:E7)","v":12976770}]
[]
["Staff Salary",{"$f":"120520","v":120520},"Gross Profit",null,{"$f":"B6","v":1074570}]
["Administration Expense",{"$f":"95252","v":95252},"Other Income",null,{"$f":"36592","v":36592}]
["Rent & Electricity",{"$f":"165250-45380","v":119870}]
["Conveyance & Travelling",{"$f":"120520","v":120520}]
["Net Profit",{"$f":"E16-SUM(B10:B13)","v":655000}]
[]
["Total",{"$f":"SUM(B10:B14)","v":1111162},"Total",null,{"$f":"SUM(E10:E15)","v":1111162}]
[]
["Balancesheet as on 31-03-2018"]
["Capital",{"$f":"643782","v":643782},null,"Closing Stock",{"$f":"E4","v":255220}]
["Add- Net Profit",{"$f":"B14","v":655000},null,"Sundry Debtor",{"$f":"368520","v":368520}]
["Less- Drawings",{"$f":"385200","v":385200},{"$f":"B19+B20-B21","v":913582},"Cash & Bank",{"$f":"E24-E19-E20","v":392342}]
["Creditors",null,{"$f":"102500","v":102500}]
[]
["Total",null,{"$f":"C21+C22","v":1016082},"Total",{"$f":"C24","v":1016082}]
[]
["For Abhilesh Jha & Company",null,null,"xxxxxx"]
[]
[]
[null,null,null,"            Prop."]
[null,null,null,"xxxxxx"]
[]
[]
["Date: 01/10/2018"]
["Place: Delhi"]

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