{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Indent","Solution Required in Master ","Add data here ","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":"Indent","index":0,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[23,1,23,2],[24,1,24,2],[25,1,25,2],[21,1,21,2],[7,7,7,9],[8,7,8,9],[9,7,9,9],[10,7,10,9],[11,7,11,9],[12,7,12,9],[13,7,13,9],[14,7,14,9],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[26,1,26,2],[27,1,27,2],[33,1,33,9],[1,4,1,6],[2,4,2,6],[3,4,3,6],[4,4,4,6],[5,4,5,6],[28,1,28,2],[29,1,29,2],[30,1,30,2],[6,7,6,9],[5,7,5,9],[6,4,6,6],[7,4,7,6],[8,4,8,6],[0,1,0,9],[10,4,10,6],[11,4,11,6],[12,4,12,6],[13,4,13,6],[1,7,1,9],[2,7,2,9],[3,7,3,9],[4,7,4,9],[1,2,1,3],[2,2,2,3],[3,2,3,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[4,2,4,3],[5,2,5,3],[9,4,9,6],[22,1,22,2],[15,1,15,9],[14,4,14,6],[19,1,19,2],[20,1,20,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[10,2,10,3]]}
[null,"INDENT FOR MATERIAL REQUIREMENTS"]
[null,"Indent No","Ind 123",null,"Nature of Expenditure",null,null,"Opex"]
[null,"Indent Date","2013-08-29",null,"Budgeted ?",null,null,"YES "]
[null,"Name of the Indentor",null,null,"Budget Code Number",null,null,"<to be allocated by Finance team>"]
[null,"Department","O&M",null,"Budget Amount"]
[null,"Requirement","Replacement",null,"Procurement Value"]
[null,"Customer Name","Customer Name 22",null,"Customer PO Ref No",null,null,"CO2343"]
[null,"Delivery/Destination Address","Suit No.2",null,"Deployment  Address",null,null,"2nd Floor, "]
[null,null,"Road No 33",null,null,null,null,"Swimming Pool Road"]
[null,null,"Quite State 23343",null,null,null,null,"Quite State 23344"]
[null,null,"Pin 9090",null,null,null,null,"Pin 9090"]
[null,"Contact Person ",null,null,"Contact Person "]
[null,"Contact Person's Phone No",null,null,"Contact Person's Phone No"]
[null,"Contact Person's email ID",null,null,"Contact Person's email ID"]
[null,"CST/LST Number",null,null,"CST/LST Number"]
[null,"Description of Products/ Service / Upgrade with Brand , Code No and  all required config."]
[null,"Item",null,"Requirement","Del.Req.Dt","Unit ","Qty","Unit Price","Tax Rate","Total Cost"]
[null,"ABCD",null,"Replacement","2013-08-29","Nos",6,17000,5.5E-2,{"$f":"+(G18*H18)+(G18*H18)*I18","v":107610}]
[null,"EFGH",null,"Replacement","2013-08-29","Nos",6,17500,5.5E-2,{"$f":"+(G19*H19)+(G19*H19)*I19","v":110775}]
[null,"IJKL",null,"Replacement","2013-08-29","Nos",6,300,5.5E-2,1899]
[null,"MNLP",null,"Replacement","2013-08-29","Nos",5,1200,5.5E-2,6330]
[null,"QRST",null,"Upgrade","2013-08-29","Nos",4,17000,5.5E-2,71740]
[null,"UVWX",null,"Upgrade","2013-08-29","Nos",4,17500,5.5E-2,73850]
[null,null,null,null,null,null,null,null,5.5E-2,0]
[null,null,null,null,null,null,null,null,5.5E-2,0]
[null,null,null,null,null,null,null,null,5.5E-2,0]
[null,null,null,null,null,null,null,null,5.5E-2,0]
[null,null,null,null,null,null,null,null,5.5E-2,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,"Other Costs/Freight/",null,null,null,null,null,null,null,0]
[null,"Total",null,null,null,null,null,null,null,{"$f":"SUM(J18:J31)","v":372204}]
[null,"Justification for above Indent"]
[null,"The update will substantially enhance the capacity of the equipemnts"]

{"sheet":"Solution Required in Master ","index":1,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[6,6,6,7],[7,6,7,7],[1,6,1,7],[2,6,2,7],[3,6,3,7],[4,6,4,7],[5,6,5,7]]}
["Master Sheet"]
["Ind.No","Ind.Date","Customer Name","Cust.PO Ref","Delivery Address","Deployment Add","Item",null,"Requirement","Del.Req.Dt","Unit ","Qty","Unit Price","Tax Rate","Total Cost","Justification given"]
["Ind 123","2013-08-29","Customer Name 22","CO2343","Suit No.2 ,Quite State 23343, Pin 9090","2nd Floor, Swimming Pool Road,Quite State 23344, Pin 9090","ABCD",null,"Replacement","2013-08-29","Nos",6,17000,5.5E-2,{"$f":"+(L3*M3)+(L3*M3)*N3","v":107610},{"$f":"Just","v":"The update will substantially enhance the capacity of the equipemnts"}]
["Ind 123","2013-08-29","Customer Name 22","CO2343","Suit No.2 ,Quite State 23343, Pin 9090","2nd Floor, Swimming Pool Road,Quite State 23344, Pin 9090","EFGH",null,"Replacement","2013-08-29","Nos",6,17500,5.5E-2,{"$f":"+(L4*M4)+(L4*M4)*N4","v":110775}]
["Ind 123","2013-08-29","Customer Name 22","CO2343","Suit No.2 ,Quite State 23343, Pin 9090","2nd Floor, Swimming Pool Road,Quite State 23344, Pin 9090","IJKL",null,"Replacement","2013-08-29","Nos",6,300,5.5E-2,1899]
["Ind 123","2013-08-29","Customer Name 22","CO2343","Suit No.2 ,Quite State 23343, Pin 9090","2nd Floor, Swimming Pool Road,Quite State 23344, Pin 9090","MNLP",null,"Replacement","2013-08-29","Nos",5,1200,5.5E-2,6330]
["Ind 123","2013-08-29","Customer Name 22","CO2343","Suit No.2 ,Quite State 23343, Pin 9090","2nd Floor, Swimming Pool Road,Quite State 23344, Pin 9090","QRST",null,"Upgrade","2013-08-29","Nos",4,17000,5.5E-2,71740]
["Ind 123","2013-08-29","Customer Name 22","CO2343","Suit No.2 ,Quite State 23343, Pin 9090","2nd Floor, Swimming Pool Road,Quite State 23344, Pin 9090","UVWX",null,"Upgrade","2013-08-29","Nos",4,17500,5.5E-2,73850]
[]
[]
["<It has indent sheet and master sheet.  Indent sheet is the sheet where data are updated on regular basis and needs to be updated in Master sheet>"]
["<There should be button in Indent sheet to click to update. On clicking the buttong, It should update the rows that are there from row number 18 to the row till The row with Total amount to the master sheet>"]
["< On each change the users update the master by clicking the click to update button. The data should be updated below the present data in master sheet>"]
["<The user can insert rows in between row number 18 and Total amount row>  It should take the range dynamically.>"]

{"sheet":"Add data here ","index":2,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Department","Type of Requirement","Unit of Measurement","Indentor","Nature of Expenditure"]
["O&M","New Project","Kgs","Ajith","Capex"]
["Networking","Replacement","Mtrs","Krishna Bhat","Opex"]
[null,"Upgrade","Nos","Somashekar"]
[null,"Spare","Box","Ramaprasad"]
[null,null,"MB"]
[null,null,"STM"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Name of the Customer","Customer Address Line1","Customer Address Line 2","Customer Address Line3"]
[null,"Internal"]
[null,"MEMG"]
[null,"Convergent"]
[null,"MULPL"]

{"sheet":"Sheet3","index":3,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[]
["YES "]
["NO"]