{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Index","General Info","Details of Transaction","Taxonomy"],"not_rendered":{"charts":0,"images":1,"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":"Index","index":0,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[[20,3,20,9],[5,4,5,8],[6,5,6,8],[7,5,7,8],[8,5,8,8],[9,5,9,8],[10,5,10,8],[13,3,13,9],[14,3,14,9],[17,3,17,9],[18,3,18,9],[19,3,19,9],[31,3,31,9],[32,3,32,9],[21,3,21,9],[22,3,22,9],[26,3,26,9],[27,4,27,8],[28,4,28,8],[23,3,23,9],[46,3,46,9],[33,3,33,9],[34,3,34,9],[35,3,35,9],[36,3,36,9],[37,3,37,9],[40,3,40,9],[41,3,41,9],[42,3,42,9],[43,3,43,9],[44,3,44,9],[45,3,45,9]]}
[]
[]
[]
[]
[]
[null,null,null,null,"                                      XBRL Excel Utility"]
[null,null,null,null,"1.","Overview"]
[null,null,null,null,"2.","Before you begin"]
[null,null,null,null,"3.","Index"]
[null,null,null,null,"4.","Steps for Filing Trading Plan Report"]
[null,null,null,null,"5.","Fill up the data in excel utility"]
[]
[]
[null,null,null,"1. Overview"]
[null,null,null,"The excel utility can be used for creating the XBRL/XML file for efiling of Trading Plan Report"]
[]
[]
[null,null,null," 2.  Before you begin"]
[null,null,null,"1. The version of Microsoft Excel in your system should be Microsoft Office Excel 2007 and above."]
[null,null,null,"2. The system should have a file compression software to unzip excel utility file."]
[null,null,null,"3. Make sure that you have downloaded the latest Excel Utility."]
[null,null,null,"4. Make sure that you have downloaded the Chrome Browser to view report generated from Excel utility"]
[null,null,null,"5. Please enable the Macros (if disabled) as per instructions given in manual, so that all the functionalities of  Excel Utility works fine. Please first go through Enable Macro - Manual attached with zip file."]
[null,null,null,"6. Kindly use this file in local system instead of OneDrive/shared drive.\nBecause it may gives an error \"Run-time error '52' : Bad file name or number\" While clicking on textblock button if files saved on OneDrive/shared drive."]
[]
[]
[null,null,null,"3. Index "]
[null,null,null,1,"General Info",null,null,null,null,"General Info"]
[null,null,null,{"$f":"+D28+1","v":2},"Details of Transaction",null,null,null,null,"Details of Transaction"]
[]
[]
[null,null,null,"4. Steps for Filing Trading Plan Report"]
[null,null,null,"I.  Fill up the data: Navigate to each field of every section in the sheet to provide applicable data in correct format. (Formats will get reflected while filling data.)  \n   - Use paste special command to paste data from other sheet."]
[null,null,null,"II. Validating Sheets:  Click on the ''Validate\" button to ensure that the sheet has been properly filled and also data has been furnished in proper format. If there are some errors on the sheet, excel utility will prompt you about the same."]
[null,null,null,"III. Validate All Sheets:  Click on the ''Home\" button. And then click on \"Validate All Sheet\" button to ensure that all sheets has been properly filled and validated successfully. If there are some errors on the sheet, excel utility will prompt you about the same and stop validation at the same time. After correction, once again follow the same procedure to validate all sheets."]
[null,null,null,"Excel Utility will not allow you to generate XBRL/XML until you rectify all errors."]
[null,null,null,"IV. Generate XML :   Excel Utility will not allow you to generate XBRL/XML unless successful validation of all sheet is completed. Now click on 'Generate XML'' to generate XBRL/XML file. \n    - Save the XBRL/XML file in your desired folder in local system."]
[null,null,null,"V. Generate Report :   Excel Utility will allow you to generate Report. Now click on 'Generate Report'' to generate html report.   \n     - Save the HTML Report file in your desired folder in local system.     \n     - To view HTML Report open \"Chrome Web Browser\" . \n     - To print report in PDF Format, Click on print button and save as PDF."]
[]
[]
[null,null,null,"5. Fill up the data in excel utility"]
[null,null,null,"1. Cells with red asterisk mark indicate mandatory fields."]
[null,null,null,"2. If mandatory field is left empty, then Utility will not allow you to proceed further for generating XML."]
[null,null,null,"3. You are not allowed to enter data in the Grey Cells."]
[null,null,null,"4. If fields are not applicable to your company then leave it blank. Do not insert Zero unless it is a mandatory field."]
[null,null,null,"5. Data provided must be in correct format, otherwise Utility will not allow you to proceed further for generating XML."]
[null,null,null,"6. Select data from \"Dropdown list\" wherever applicable."]

{"sheet":"General Info","index":1,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[6,3,6,4]]}
[null,null,null,null,null,null,null,null,null,null,"Buy","Director"]
[null,null,null,null,null,null,null,null,null,null,"Sell","KMP"]
[null,null,null,null,null,null,null,null,null,null,null,"Promoter"]
[]
[]
[]
[null,null,null,"General Information"]
[null,null,null,"NSE Symbol",null,null,null,null,null,"NSESymbol"]
[null,null,null,"BSE Scrip Code",null,null,null,null,null,"ScripCode"]
[null,null,null,"MSEI Symbol",null,null,null,null,null,"MSEISymbol"]
[null,null,null,"Name of the company",null,null,null,null,null,"NameOfTheCompany"]
[null,null,null,"ISIN",null,null,null,null,null,"ISIN"]
[null,null,null,"Name of the insider",null,null,null,null,null,"NameOfTheInsider"]
[null,null,null,"PAN",null,null,null,null,null,"PANOfTheInsider"]
[null,null,null,"Designation",null,null,null,null,null,"DesignationOfTheInsider"]
[null,null,null,"Category",null,null,null,null,null,"CategoryOfTheInsider"]
[null,null,null,"Date of submission",{"$f":"TODAY()","v":"2024-09-24"},null,null,null,null,"DateOfSubmission"]
[null,null,null,"Transaction",null,null,null,null,null,"TypeOfTransactionOfInsiderTrading"]
[null,null,null,"Closing price at BSE on [Date of Submission] minus 1 trading day",null,null,null,null,null,"ClosingPriceAtBombayStockExchangeOnDateOfSubmissionMinusOneTradingDay"]
[null,null,null,"Closing price at NSE on [Date of Submission] minus 1 trading day",null,null,null,null,null,"ClosingPriceAtNationalStockExchangeOnDateOfSubmissionMinusOneTradingDay"]

{"sheet":"Details of Transaction","index":2,"n_rows":20,"n_cols":24,"rows_kept":20,"cut":false,"hidden":false,"merged":[[7,9,8,9],[6,3,6,9],[7,3,8,3],[7,4,7,5],[7,6,8,6],[7,7,8,7],[7,8,8,8]]}
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"On Market","Off Market",null,null,null,null,null,null,"22-01-2024"]
[5,null,null,null,"StartDateOfTransaction","EndDateOfTransaction","NumberOfSharesTransacted","PriceOfSharesTransacted","AmountOfTransaction","NatureOfTrade",null,null,null,null,null,null,null,null,null,null,null,null,null,"26-01-2024"]
[{"$f":"SUM(P10:P14)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08-03-2024"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25-03-2024"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"29-03-2024"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11-04-2024"]
[null,null,null,"Details of Transaction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17-04-2024"]
[null,null,null,"Sr.","Period of trading",null,"No. of shares","Price","Value of shares","Nature of trade",null,null,null,null,null,null,null,null,null,null,null,null,null,"01-05-2024"]
[null,null,null,null,"From Date","To Date",null,null,null,null,null,null,null,null,null,"Day Different","Form Date Sat and Sun","To Date Sat and Sun","From Date Holi","To Date Holi",null,null,null,"17-06-2024"]
[null,"InsiderTradingTransaction1Member",null,1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(OR(ISBLANK(E10),ISBLANK(F10)),\"0\",MAX(0, NETWORKDAYS.INTL(E10,F10,1,$X$1:$X$20))),\"0\")","v":"0"},{"$f":"IFERROR(IF(E10=\"\",\"\",WEEKDAY(E10)),\"0\")","v":""},{"$f":"IFERROR(IF(F10=\"\",\"\",WEEKDAY(F10)),\"0\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E10, $X:$X, 1, FALSE)), \"0\", \"1\")","v":"0"},{"$f":"IF(ISNA(VLOOKUP(F10, $X:$X, 1, FALSE)), \"0\", \"1\")","v":"0"},null,null,null,"17-07-2024"]
[null,"InsiderTradingTransaction2Member",null,2,null,null,null,null,null,null,null,null,null,null,null,"0","","",{"$f":"IF(ISNA(VLOOKUP(E11, $X:$X, 1, FALSE)), \"0\", \"1\")","v":"0"},{"$f":"IF(ISNA(VLOOKUP(F11, $X:$X, 1, FALSE)), \"0\", \"1\")","v":"0"},null,null,null,"15-08-2024"]
[null,"InsiderTradingTransaction3Member",null,3,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(OR(ISBLANK(E12),ISBLANK(F12)),\"0\",MAX(0, NETWORKDAYS.INTL(E12,F12,1,$X$1:$X$20))),\"0\")","v":"0"},{"$f":"IFERROR(IF(E12=\"\",\"\",WEEKDAY(E12)),\"0\")","v":""},{"$f":"IFERROR(IF(F12=\"\",\"\",WEEKDAY(F12)),\"0\")","v":""},"0","0",null,null,null,"02-10-2024"]
[null,"InsiderTradingTransaction4Member",null,4,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(OR(ISBLANK(E13),ISBLANK(F13)),\"0\",MAX(0, NETWORKDAYS.INTL(E13,F13,1,$X$1:$X$20))),\"0\")","v":"0"},{"$f":"IFERROR(IF(E13=\"\",\"\",WEEKDAY(E13)),\"0\")","v":""},{"$f":"IFERROR(IF(F13=\"\",\"\",WEEKDAY(F13)),\"0\")","v":""},"0","0",null,null,null,"01-11-2024"]
[null,"InsiderTradingTransaction5Member",null,5,null,null,null,null,null,null,null,null,null,null,null,"0","","","0","0",null,null,null,"15-11-2024"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25-12-2024"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14-04-2024"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"21-04-2024"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07-09-2024"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12-10-2024"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02-11-2024"]

{"sheet":"Taxonomy","index":3,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Elemnt ","Label","Datatype","PeriodType","Errormessage"]
["NSESymbol","NSE Symbol","xbrli:stringItemType","instant","1) This field is mandatory.\n2) Space is not allowed.\n3) Maximum 10 characters allowed."]
["ScripCode","BSE Scrip Code","in-capmkt-types:ScripCode","instant","1) This field is mandatory.\n2) Enter a valid Scrip code.\n3) Please enter 6 digit Scrip code."]
["MSEISymbol","MSEI Symbol","xbrli:stringItemType","instant","1) This field is mandatory.\n2) Space is not allowed.\n3) Maximum 10 characters allowed."]
["NameOfTheCompany","Name of the company","xbrli:stringItemType","instant"]
["ISIN","ISIN","in-capmkt-types:ISINNumber","instant","1) This field is mandatory.\n2) Please enter 12 digit ISIN number."]
["NameOfTheInsider","Name of the insider","xbrli:stringItemType","instant"]
["PANOfTheInsider","PAN","in-capmkt-types:PermanentAccountNumber","instant","1) This field is mandatory.\n2) Please enter valid PAN number."]
["DesignationOfTheInsider","Designation","xbrli:stringItemType","instant"]
["CategoryOfTheInsider","Category","in-capmkt-types:InsiderTradingCategory","instant","1) This field is mandatory.\n2) Please select from drop down only."]
["DateOfSubmission","Date of submission","xbrli:dateItemType","instant"]
["TypeOfTransactionOfInsiderTrading","Transaction","in-capmkt-types:TradingTransactionType","instant","1) This field is mandatory.\n2) Please select from drop down only."]
["ClosingPriceAtBombayStockExchangeOnDateOfSubmissionMinusOneTradingDay","Closing price at BSE on [Date of Submission] minus 1 trading day","num:perShareItemType","instant","1) This field is mandatory.\n2) Upto 2 decimal value allowed."]
["ClosingPriceAtNationalStockExchangeOnDateOfSubmissionMinusOneTradingDay","Closing price at NSE on [Date of Submission] minus 1 trading day","num:perShareItemType","instant","1) This field is mandatory.\n2) Upto 2 decimal value allowed."]
["StartDateOfTransaction","From Date","xbrli:dateItemType","instant","1) This is a mandatory field.\n2) Date shall be accepted only after 120 days of \"Date of Submission\".\n3) Dates shall be accepted only for trading days. (i.g.: accepted only 5 days of trading days. not allowed on Saturday, Sunday and Holidays date)\n4) Enter date in \"DD-MM-YYYY\" format.\n5) Enter a valid Date."]
["EndDateOfTransaction","To Date","xbrli:dateItemType","instant","1) This is a mandatory field.\n2) It should be greater than or equal to \"From Date\" of trading period.\n3) No. of trading days exceeds 5 and hence not permitted.\n4) Dates shall be accepted only for trading days. (i.g.: accepted only 5 days of trading days. not allowed on Saturday, Sunday and Holidays date)\n5) Enter date in \"DD-MM-YYYY\" format.\n6) Enter a valid Date."]
["NumberOfSharesTransacted","No. of shares","xbrli:sharesItemType","instant","1) This field is mandatory, if “Value of shares” is not given.\n2) \"No. of shares\" or \"Value of shares\" is required.\n3) Only numeric value allowed."]
["PriceOfSharesTransacted","Price","num:perShareItemType","instant","1) Price cannot be allowed more than 20% of the higher of Closing Price at BSE or NSE if Transaction selected as \"Buy\".\n2) Price should not be lower than 20% of the lower of Closing Price at BSE or NSE if Transaction selected as \"Sell\".\n3) Upto 2 decimal value allowed."]
["AmountOfTransaction","Value of shares","xbrli:monetaryItemType","instant","1) This field is mandatory, if “No. of shares” is not given.\n2) \"No. of shares\" or \"Value of shares\" is required.\n3) Upto 2 decimal value allowed."]
["NatureOfTrade","Nature of trade","in-capmkt-types:NatureOfTrade","instant","1) This field is mandatory.\n2) Please select from drop down only."]