{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Sheet1","index":0,"n_rows":12,"n_cols":31,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,1,2,2],[0,1,0,2]]}
["Path of File","C:/Deskstop"]
["Subject","Urgent- Reminder Mail"]
["Body","Please respond to the mail"]
[]
[]
["Sr No","Vendor code","Vendor Name ","Type of service","Country"," Status","Rate","Status2","Status of npa","Status of NO npa","abc Expiring Date",{"$f":"TODAY()","v":"2014-02-17"},"Status of def","ghi expiring Date",{"$f":"TODAY()","v":"2014-02-17"},"Form uvw","Form uvw Expiring Date",{"$f":"TODAY()","v":"2014-02-17"},"Currency","Contact Person Name","Vendor Email ID","Vendor Email ID - 2","Letter Prepared","Letter Sent","Comments","Remark","Remark","Attachment","Attachment","Attachment","Email Status"]
[null,"Vikas",null,null,null,"Yes",0.15,"Y","Not available","Available (No date mention)",null,{"$f":"IF($L$6>K7,\"Certificate Expired\",\"Valid Certificate\")","v":"Certificate Expired"},"Not available",null,{"$f":"IF($O$6>N7,\"Certificate Expired\",\"Valid Certificate\")","v":"Certificate Expired"},"Not required",null,{"$f":"IF(I7=\"Not Available\",\"\",IF(AND(I7=\"Available\",$R$6>2),\"Certificate Expired\",\"\"))","v":""},"INR","A","vverma@ajssoft.com","vverma@ajssoft.com","No","No",null,null,null,{"$f":"IF(L7=\"Certificate Expired\",\"Form abc\",\"\")","v":"Form abc"},{"$f":"IF(O7=\"Certificate Expired\",\"Form def\",\"\")","v":"Form def"},{"$f":"IF(R7=\"Certificate Expired\",\"Form ghi\",\"\")","v":""},{"$f":"IF(OR(AB7=\"\",AC7=\"\",AD7=\"\"),\"Y\",\"N\")","v":"Y"}]
[null,"Vikas",null,null,null,"Yes",0.15,"N","Not available","Available","2010-12-01",{"$f":"IF($L$6>K8,\"Certificate Expired\",\"Valid Certificate\")","v":"Certificate Expired"},"Not available",null,{"$f":"IF($O$6>N8,\"Certificate Expired\",\"Valid Certificate\")","v":"Certificate Expired"},"Not required",null,{"$f":"IF(I8=\"Not Available\",\"\",IF(AND(I8=\"Available\",$R$6>2),\"Certificate Expired\",\"\"))","v":""},"INR","B","abc@hotmail.com","abc@hotmail.com","Yes","Yes",null,null,null,{"$f":"IF(L8=\"Certificate Expired\",\"Form abc\",\"\")","v":"Form abc"},{"$f":"IF(O8=\"Certificate Expired\",\"Form def\",\"\")","v":"Form def"},{"$f":"IF(R8=\"Certificate Expired\",\"Form ghi\",\"\")","v":""},{"$f":"IF(OR(AB8=\"\",AC8=\"\",AD8=\"\"),\"Y\",\"N\")","v":"Y"}]
[null,"Vikas",null,null,null,"Yes",0.15,"N","Available","Available","2013-12-01","Certificate Expired","Available","2013-12-01","Certificate Expired","Available","2013-12-01","Certificate Expired","INR","C","abc@hotmail.com","abc@hotmail.com","Yes","Yes",null,null,null,"Form abc","Form def","Form ghi","N"]
[null,"Vikas",null,null,null,"Yes",0.15,"N","Not available","Available","2013-12-01","Certificate Expired","Available","2013-12-01","Certificate Expired","Not required",null,"","INR","D","abc@hotmail.com","abc@hotmail.com","Yes","No",null,null,null,"Form abc","Form def","","Y"]
[null,"Vikas",null,null,null,"Yes",0.15,"N","Not available","Available","2012-12-01","Certificate Expired","Available","2012-12-01","Certificate Expired","Not required",null,"","INR","E","abc@hotmail.com","abc@hotmail.com","No","No",null,null,null,"Form abc","Form def","","Y"]
[null,"Vikas",null,null,null,"No",0,"Y","Not available","Available","2012-12-01","Certificate Expired","Not available",null,"Certificate Expired","Not required",null,"","INR","F","abc@hotmail.com","abc@hotmail.com","No","No",null,null,null,"Form abc","Form def","","Y"]