{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Introduction","InputData","Sheet3"],"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":"Introduction","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,1,18,9]]}
[null,null,null,null,null,"www.Tricks12345.com"]
[]
[null,"Consolidation \nof \nIncome Statement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Pavan Kumar Gundlapalli"]

{"sheet":"InputData","index":1,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,7,1,10]]}
["Date","Data Item","Amount",null,null,null,null,"Format"]
["2018-01-01","Sales",1000]
["2018-01-02","Selling and Admin Expenses",224]
["2018-01-03","Power and Fuel Cost",300]
["2018-01-04","Selling and Admin Expenses",224,null,null,null,null,null,"Income Statement Format"]
["2018-01-05","Sales Returns",800]
["2018-01-06","Raw Materials",600,null,null,null,null,null,"Sales"]
["2018-01-07","Power and Fuel Cost",300,null,null,null,null,null,"Sales Returns"]
["2018-01-08","Employees Cost",782,null,null,null,null,null,"Net Sales"]
["2018-01-09","Other Manufacturing Expenses",654,null,null,null,null,null,"Expenditure"]
["2018-01-10","Selling and Admin Expenses",224,null,null,null,null,null,"Selling and Admin Expenses"]
["2018-01-11","Miscellaneous Expenses",478,null,null,null,null,null,"Power and Fuel Cost"]
["2018-01-12","Preoperative Exp Capitalised",364,null,null,null,null,null,"Employees Cost"]
["2018-01-13","Sales",8000,null,null,null,null,null,"Other Manufacturing Expenses"]
["2018-01-14","Depreciation",150,null,null,null,null,null,"Miscellaneous Expenses"]
["2018-01-15","Miscellaneous Expenses",478,null,null,null,null,null,"Total Expenditure"]
["2018-01-16","Miscellaneous Expenses",142,null," ",null,null,null,"PBDIT"]
["2018-01-17","Interest",45,null,null,null,null,null,"Depreciation"]
["2018-01-18","Other Manufacturing Expenses",654,null,null,null,null,null,"PBIT"]
["2018-01-19","Depreciation",150,null,null,null,null,null,"Interest"]
["2018-01-20","Depreciation",150,null,null,null,null,null,"PBT"]
["2018-01-20","Tax",1000,null,null,null,null,null,"Tax"]
["2018-01-20","Dividend",500,null,null,null,null,null,"Reported Net Profit(PAT)"]
["2018-01-20","Miscellaneous Expenses",247,null,null,null,null,null,"Dividend"]
["2018-01-30","Employees Cost",500,null,null,null,null,null,"Amount C\\F to Balance Sheet"]
["2018-01-30","Employees Cost",300]

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