{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["rej"],"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":"rej","index":0,"n_rows":219,"n_cols":6,"rows_kept":219,"cut":false,"hidden":false,"merged":[[0,0,0,5],[89,0,89,5],[135,0,135,5],[180,0,180,5],[44,0,44,5]],"flags":["formulas_cached_only"]}
["Record Structure for for ASI  2005-2006"]
[]
["BLOCK-A (IDENTIFICATION BLOCK FOR OFFICIAL USE)"]
["Srl.No.","Field Name","Sch. Ref.","Description","Type","Width"]
[1,"YR","-"," '06' for ASI 2005-2006","Character",2]
[2,"BLK","-","Block code, Always 'A'","Character",2]
[3,"A1","Item 1","DSL","Numeric",5]
[4,"A2","Item 2","PSL No.","Character",5]
[5,"A3","Item 3","Scheme code","Numeric",1]
[6,"A4","Item4","Ind. Code as per Frame (4-digit level of NIC-04)","Numeric",4]
[7,"A5","Item 5","Ind Code as per Return (5-digit, NIC-04)","Numeric",5]
[8,"A7","Item 7","State Code","Numeric",2]
[9,"A8","Item 8","District code","Numeric",2]
[10,"A9","Item 9","Rural/Urban code","Numeric",1]
[11,"A10","Item 10","RO/SRO code","Numeric",5]
[12,"A11","Item 11","No. of units","Numeric",3]
[13,"A12","Item 12","Status of Unit (Code 17 to 20, Extracted data from ASI, 03-04)","Numeric",2]
[14,"MWDAYS","E Blk item 11","Number of working days ( Manufacturing days)","Numeric",3]
[15,"NWDAYS","E Blk item 11","Number of working days (Non-Manufacturing days)","Numeric",3]
[16,"WDAYS","E Blk item 11","Number of working days ( Total)","Numeric",3]
[17,"COSTOP","E Blk item 12","Cost of Production","Numeric",12]
[18,"MULT","-","Inflation/Multiplier factor (in 9999.9999 format)","Numeric",9]
[19,"FILLER","-","Padded with 0 or blank",null,109]
[null,"TOTAL",null,null,null,178]
["* Record Identification Key for Block-A: A1X BLK"]
[]
["BLOCK-B (TO BE FILLED BY OWNERS)"]
["Srl.No.","Field Name","Sch. Ref.","Description","Type","Width"]
[1,"YR","-"," '06' for ASI 2005-2006","Character",2]
[2,"BLK","-","Block code, Always 'B'","Character",2]
[3,"AB01","-","DSL (Block-A, Item 1)","Numeric",5]
[4,"B02","Item 2","Type of organisation(code)","Numeric",2]
[5,"B03","Item 3","Type of ownership(code)","Numeric",1]
[6,"B04","Item 4","Total number of units the company has","Numeric",4]
[7,"B05","Item 5","How many units located in the same state","Numeric",4]
[8,"B06","Item 6 ","Year of initial production","Numeric",4]
[9,"B07F","Item 7","Accounting year (From)","Character",9]
[10,"B07T","Item 7","Accounting year (To)","Character",9]
[11,"B08","Item 8","Number of months of operation","Numeric",2]
[12,"B09","Item 9","Does your unit have computerised A/C system? (Yes-1, No-2)","Numeric",1]
[13,"B10","item 10","Can your unit supply ASI data in Computer Floppy(Yes-1,No-2)","Numeric",1]
[14,"FILLER","-","Padded with 0 or blank",null,132]
[null,"TOTAL",null,null,null,178]
["* Record Identification Key for Block-B:AB01 X BLK"]
["Record Structure for for ASI  2005-2006"]
[]
["BLOCK-C (FIXED ASSETS)"]
["Srl.No.","Field Name","Sch. Ref.","Description","Type","Width"]
[1,"YR","-"," '06' for ASI 2005-2006","Character",2]
[2,"BLK","-","Block code, Always 'C'","Character",2]
[3,"AC01","-","DSL (Block-A, Item 1)","Numeric",5]
[4,"C_I1","Col. 1","S. No. (to be entered as printed in the schedule)","Numeric",2]
[5,"C_I3","Col. 3","Opening as on ","Numeric",12]
[6,"C_I4","Col. 4","Due to revaluation","Numeric",12]
[7,"C_I5","Col. 5","Actual addition","Numeric",12]
[8,"C_I6","Col. 6","Deduction & adjustment during the year","Numeric",12]
[9,"C_I7","Col. 7","Closing as on","Numeric",12]
[10,"C_I8","Col. 8","Up to year beginning ","Numeric",12]
[11,"C_I9","Col. 9","Provided during the year","Numeric",12]
[12,"C_I10","Col. 10","Up to year end","Numeric",12]
[13,"C_I11","Col. 11","Opening as on ","Numeric",12]
[14,"C_I12","Col. 12","Closing as on","Numeric",12]
[15,"FILLER","-","Padded with 0 or blank",null,47]
[null,"TOTAL",null,null,null,178]
["* Record Identification Key for Block-C: AC01 X BLK X C_I1"]
[]
[]
["BLOCK-D (WORKING CAPITAL AND LOANS)"]
["Srl.No.","Field Name","Sch. Ref.","Description","Type","Width"]
[1,"YR","-"," '06' for ASI 2005-2006","Character",2]
[2,"BLK","-","Block code, Always 'D'","Character",2]
[3,"AD01","-","DSL (Block-A, Item 1)","Numeric",5]
[4,"D_I1","Col. 1","S. No. (to be entered as printed in the schedule)","Numeric",2]
[5,"D_I3","Col. 3","Opening (Rs.)","Numeric",12]
[6,"D_I4","Col. 4","Closing (Rs.)","Numeric",12]
[7,"FILLER","-","Padded with 0 or blank",null,143]
[null,"TOTAL",null,null,null,178]
["* Record Identification Key for Block-D:AD01 X BLK X D_I1"]
{"$rows_empty":11}
["Record Structure for for ASI  2005-2006"]
[]
["BLOCK-E (EMPLOYMENT AND LABOUR COST)"]
["Srl.No.","Field Name","Sch. Ref.","Description","Type","Width"]
[1,"YR","-"," '06' for ASI 2005-2006","Character",2]
[2,"BLK","-","Block code, Always 'E'","Character",2]
[3,"AE01","-","DSL (Block-A, Item 1)","Numeric",5]
[4,"E_I1","Col. 1","S. No. (to be entered as printed in the schedule)","Numeric",2]
[5,"E_I3","Col. 3","Mandays Worked (Manufacturing)","Numeric",8]
[6,"E_I4","Col. 4","Mandays Worked (Non Manufacturing)","Numeric",8]
[7,"E_I5","Col. 5","Mandays Worked (Total)","Numeric",10]
[8,"E_I6","Col. 6","Average Number of persons worked","Numeric",8]
[9,"E_I7","Col. 7","No. of mandays paid for","Numeric",10]
[9,"E_I8","Col. 8","Wages/salaries (in Rs.)","Numeric",12]
[10,"E_I9","Col. 9","Bonus (in Rs.)","Numeric",12]
[11,"E_I10","Col.10","Contribution to Provident Fund and other funds","Numeric",12]
[12,"E_I11","Col.11","Workmen & Staff Welfare Expenses","Numeric",12]
[13,"FILLER","-","Padded with 0 or blank",null,75]
[null,"TOTAL",null,null,null,178]
["* Record Identification Key for Block-E:AE01 X BLK X E_I1"]
[]
["BLOCK-F (OTHER EXPENSES)"]
["Srl.No.","Field Name","Sch. Ref.","Description","Type","Width"]
[1,"YR","-"," '06' for ASI 2005-2006","Character",2]
[2,"BLK","-","Block code, Always 'F'","Character",2]
[3,"AF01","-","DSL (Block-A, Item 1)","Numeric",5]
[4,"F1","Item 1","Work done by others ","Numeric",12]
[5,"F2A","Item 2i)","Repair & maintenance of Building","Numeric",12]
[6,"F2B","Item 2ii)","Repair & maintenance of Plant & Machinery","Numeric",12]
[7,"F2C","Item 2iii)","Repair & maintenance of Pollution control equipment","Numeric",12]
[8,"F2D","Item 2iv)","Repair & maintenance of Other fixed assets","Numeric",12]
[9,"F3","Item 3","Operating expenses","Numeric",12]
[10,"F4","Item 4","Non-operating expenses ","Numeric",12]
[11,"F5","Item 5","Insurance Charges","Numeric",12]
[12,"F6","Item 6","Rent paid for Plant & Machinery and other Fixed assets ","Numeric",12]
[13,"F7","Item 7","Total expenses (1 to 6)","Numeric",12]
[14,"F8","Item 8","Rent paid for Buildings","Numeric",12]
[15,"F9","Item 9","Rent paid for land on lease or royalties on mines, quarries etc.","Numeric",12]
[16,"F10","Item 10","Interest paid ","Numeric",12]
[17,"F11","Item 11","Purchase value of goods sold in the same condition as purchased","Numeric",12]
[null,"TOTAL",null,null,null,178]
["* Record Identification Key for Block-F: AF01 X BLK"]
[]
[]
[]
[]
["Record Structure for for ASI  2005-2006"]
[]
["BLOCK-G (OTHER OUTPUT/RECEIPTS)"]
["Srl.No.","Field Name","Sch. Ref.","Description","Type","Width"]
[1,"YR","-"," '06' for ASI 2005-2006","Character",2]
[2,"BLK","-","Block code, Always 'G'","Character",2]
[3,"AG01","-","DSL (Block-A, Item 1)","Numeric",5]
[4,"G1","Item 1","Income from services","Numeric",12]
[5,"G2","Item 2","Variation in stock of semi-finished goods","Numeric",12]
[6,"G3","Item 3","Value in electricity generated and sold.","Numeric",12]
[7,"G4","Item 4","Value of own construction","Numeric",12]
[8,"G5","Item 5","Net balance of goods sold in the same condition as purchased","Numeric",12]
[9,"G6","Item 5","Rent received for Plant & Machinery and other fixed assets","Numeric",12]
[10,"G7","Item 7","Total receipts (1 to 6)","Numeric",12]
[11,"G8","Item 8","Rent received for building","Numeric",12]
[12,"G9","Item 9","Rent received for land on lease or royalties on mines, quarries etc.","Numeric",12]
[13,"G10","Item 10","Interest received","Numeric",12]
[14,"G11","Item 11","Sale value of goods sold in the same condition as purchased","Numeric",12]
[15,"FILLER","-","Padded with 0 or blank",null,37]
[null,"TOTAL",null,null,null,178]
["* Record Identification Key for Block-G: AG01 X BLK"]
[]
["BLOCK-H (INPUT ITEMS - Indigenous items consumed)"]
["Srl.No.","Field Name","Sch. Ref.","Description","Type","Width"]
[1,"YR","-"," '06' for ASI 2005-2006","Character",2]
[2,"BLK","-","Block code, Always 'H'","Character",2]
[3,"AH01","-","DSL (Block-A, Item 1)","Numeric",5]
[4,"H_I1","Col. 1","Sl. No.","Numeric",2]
[5,"H_I3","Col. 3","Item code (ASICC)","Numeric",5]
[6,"H_I4","Col. 4","Unit of quantity (code)","Numeric",3]
[7,"H_I5","Col. 5","Quantity consumed (as 99999999999.999)","Numeric",16]
[8,"H_I6","Col. 6","Purchase value (in Rs.)","Numeric",12]
[9,"H_I7","Col. 7","Rate per unit (in Rs.0.00) (as 999999999999.99)","Numeric",15]
[10,"FILLER","-","Padded with 0 or blank",null,116]
[null,"TOTAL",null,null,null,178]
["* Record Identification Key for Block-H: AH01X BLK X H_I1"]
{"$rows_empty":9}
["Record Structure for for ASI  2005-2006"]
[]
["BLOCK-I (INPUT ITEMS - Directly imported items only (consumed))"]
["Srl.No.","Field Name","Sch. Ref.","Description","Type","Width"]
[1,"YR","-"," '06' for ASI 2005-2006","Character",2]
[2,"BLK","-","Block code, Always 'I'","Character",2]
[3,"AI01","-","DSL (Block-A, Item 1)","Numeric",5]
[4,"I_I1","Col. 1","Sl. No.","Numeric",2]
[5,"I_I3","Col. 3","Item code (ASICC)","Numeric",5]
[6,"I_I4","Col. 4","Unit of quantity (code)","Numeric",3]
[7,"I_I5","Col. 5","Quantity consumed (as 99999999999.999)","Numeric",16]
[8,"I_I6","Col. 6","Purchase value at delivery (in Rs.)","Numeric",12]
[9,"I_I7","Col. 7","Rate per unit (in Rs.0.00) (as 999999999999.99)","Numeric",15]
[10,"FILLER","-","Padded with 0 or blank",null,116]
[null,"TOTAL",null,null,null,178]
["* Record Identification Key for Block-I:AI01 X BLK X I_I1"]
[]
[]
[]
["BLOCK-J (PRODUCTS AND BY-PRODUCTS (Manufactured by the unit))"]
["Srl.No.","Field Name","Sch. Ref.","Description","Type","Width"]
[1,"YR","-"," '06' for ASI 2005-2006","Character",2]
[2,"BLK","-","Block code, Always 'J'","Character",2]
[3,"AJ01","-","DSL (Block-A, Item 1)","Numeric",5]
[4,"J_I1","Col. 1","Sl.No.","Numeric",2]
[5,"J_I3","Col. 3","Item code (ASICC)","Numeric",5]
[6,"J_I4","Col. 4","Unit of quantity (code)","Numeric",3]
[7,"J_I5","Col. 5","Quantity manufactured (as 99999999999.999)","Numeric",16]
[8,"J_I6","Col. 6","Quantity sold (as 99999999999.999)","Numeric",16]
[9,"J_I7","Col. 7","Gross sale value (Rs.)","Numeric",12]
[10,"J_I8","Col. 8","Excise duty","Numeric",12]
[11,"J_I9","Col. 9","Sales Tax","Numeric",12]
[12,"J_I10","Col. 10","Others ","Numeric",12]
[13,"J_I11","Col. 11","Total","Numeric",12]
[14,"J_I12","Col. 12","Per unit net sale value  (Rs.) [7-11]/6 (as 999999999999.99)","Numeric",15]
[15,"J_I13","Col. 13","Ex-factory value of output (Rs.) (12 x 5)","Numeric",12]
[16,"FILLER","-","Padded with 0 or blank",null,40]
[null,"TOTAL",null,null,null,178]
["* Record Identification Key for Block-J: AJ01 X BLK X J_I1"]