{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Policy","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":44,"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":"Policy","index":0,"n_rows":142,"n_cols":265,"rows_kept":142,"cut":false,"hidden":false,"merged":[[14,3,21,6]]}
[null,null,null,null,null,null,null,null,null,"@ 14.50%",null,null,null,null,null,"Email - 29/07/2015",null,"Wts 29/07/2015"]
[null,{"$f":"B32","v":2},null,null,null,null,null,null,877,{"$f":"ROUND(I2*101.901%,0)","v":894},null,"2015-07-01",null,{"$f":"B2","v":2},null,"sms 29/06/2015",null,null,null,null,null,null,"14210042140100000006","m",null,"SMS - 23/6/13","14210034142500008513","14210042140100001328",null,null,null,null,null,null,null,null,null,{"$f":"Z2","v":"SMS - 23/6/13"},"2015-16",{"$f":"A2&$AP$4&$AQ$4&E2&$AR$3&$AR$4&J2&$AL$4&TEXT(AL2,\"dd-mm-yyyy\")&$AS$4","v":"---Reminder New India Policy of   Renewal  -----Premium  Approx Rs . --894   Pay Before SMS - 23/6/13    Cheque - THE NEW INDIA ASSURANCE CO LTD            "}]
["Name",null,{"$f":"AN3","v":0},{"$f":"A3&$G$3\n&E3&$G$3&$AA$4&                                                                                                                                                                                                                                                              AA3&$G$3\n&$AE$4&AE3&$G$3\n&$F$4&TEXT(F3,\"dd - mm - yyy\")&$G$3\n&$R$4&R3&$G$3\n&$O$4&TEXT(O3,\"DD - MM - yyy\")&$G$3\n&$T$4&T3","v":"Name\nMotor\nPolicy No --  111\nRs.   11450\nDue Date -  04 - 05 - 2016\nDetails -  Vehicle\nDOC -  01 - 01 - 2009\nSum Insured - 17000"},"Motor",{"$f":"Z3","v":"2016-05-04"},{"$f":"CHAR(10)","v":"\n"},"  '   ------",{"$f":"AE3","v":11450},"Renewal ","Renewal ",null,null,null,"2009-01-01",null,null,"Vehicle",null,17000,10000,15,{"$f":"ROUND((U3*V3)%,0)","v":1500},null,"2015-05-05",{"$f":"Y3+365","v":"2016-05-04"},111,{"$f":"LEN(AA3)","v":3},{"$f":"U3","v":10000},{"$f":"ROUNDUP(AC3*0.145,0)","v":1450},{"$f":"AC3+AD3","v":11450},{"$f":"ROUNDUP(AC3*0.145,0)+AC3","v":11450},null,null,null,null,null,null,null,null,null,null,null,"  Renewal  --"]
["Name","FILE NO.","Mobile Updated","Entry Module ","Type","Due Date -  ","Area","Reference",{"$f":"AE4","v":"Rs.   "},"Amount","Done","Busines Month","New / Ren Business","Branch","DOC -  ","SMS SEND","Confirmation","Details -  ","Person","Sum Insured - ","Premium","Rate"," Net","Bill","Period From","Period To","Policy No --  ",{"$f":"LEN(AA4)","v":14},"Premium","     Ser. Tax","Rs.   ","Charges Paid","Edort. No.","Reason For Eod.","Nomination","Raw","Calender entry","   Pay Before ","Financial Year","Renewal Entry","---Pay 10 days Before --","---","Reminder New India Policy of ","---Premium  Approx Rs . --","    Cheque - THE NEW INDIA ASSURANCE CO LTD            ","  Final Last Date"]
["Vaishali Mahendra Savla",null,null,{"$f":"A5&$G$3\n&E5&$G$3&$AA$4&                                                                                                                                                                                                                                                              AA5&$G$3\n&$AE$4&AE5&$G$3\n&$F$4&TEXT(F5,\"dd - mm - yyy\")&$G$3\n&$R$4&R5&$G$3\n&$O$4&TEXT(O5,\"DD - MM - yyy\")&$G$3\n&$T$4&T5","v":"Vaishali Mahendra Savla\nMotor\nPolicy No --  14230031150100004634\nRs.   946\nDue Date -  31 - 12 - 2016\nDetails -   MH- 01-AQ-3954 -- Honda Activa ---  \nYear  2009   \nDOC -  01 - 01 - 2009\nSum Insured - 17000"},"Motor",{"$f":"Z5","v":"2016-12-31"},"Wadala","Direct",{"$f":"AE5","v":946},null,null,"2015-12-01",null,null,"2009-01-01",null,null," MH- 01-AQ-3954 -- Honda Activa ---  \nYear  2009   ",1,17000,826,10,17,null,"2016-01-01",{"$f":"Y5+365","v":"2016-12-31"},"14230031150100004634",{"$f":"LEN(AA5)","v":20},{"$f":"U5","v":826},{"$f":"ROUNDUP(AC5*0.145,0)","v":120},{"$f":"AC5+AD5","v":946},null,null,null,null,null,null,null,"2015-16",{"$f":"A5&$AP$4&$AQ$4&E5&$AR$3&$AR$4&J5&$AL$4&TEXT(AL5,\"dd-mm-yyyy\")&$AS$4","v":"Vaishali Mahendra Savla---Reminder New India Policy of Motor  Renewal  -----Premium  Approx Rs . --   Pay Before 00-01-1900    Cheque - THE NEW INDIA ASSURANCE CO LTD            "}]
["Manish Chheda ",null,null,{"$f":"A6&$G$3\n&E6&$G$3&$AA$4&                                                                                                                                                                                                                                                              AA6&$G$3\n&$AE$4&AE6&$G$3\n&$F$4&TEXT(F6,\"dd - mm - yyy\")&$G$3\n&$R$4&R6&$G$3\n&$O$4&TEXT(O6,\"DD - MM - yyy\")&$G$3\n&$T$4&T6","v":"Manish Chheda \nMediclaim\nPolicy No --  14230031150100004635\nRs.   5245\nDue Date -  16 - 01 - 2016\nDetails -  Manish M/32 - SI 5 Lacs\nDOC -  24 - 10 - 2010\nSum Insured - 500000"},"Mediclaim",{"$f":"Z6","v":"2016-01-16"},"Dadar ","Direct",{"$f":"AE6","v":5245},null,null,"2016-01-01",null,null,"2010-10-24",null,null,"Manish M/32 - SI 5 Lacs",1,500000,4580,15,{"$f":"ROUND((U6*V6)%,0)","v":687},null,"2015-01-16",{"$f":"Y6+365","v":"2016-01-16"},"14230031150100004635",{"$f":"LEN(AA6)","v":20},{"$f":"U6","v":4580},{"$f":"ROUNDUP(AC6*0.145,0)","v":665},{"$f":"AC6+AD6","v":5245},null,null,null,null,null,null,null,"2015-16",{"$f":"A6&$AP$4&$AQ$4&E6&$AR$3&$AR$4&J6&$AL$4&TEXT(AL6,\"dd-mm-yyyy\")&$AS$4","v":"Manish Chheda ---Reminder New India Policy of Mediclaim  Renewal  -----Premium  Approx Rs . --   Pay Before 00-01-1900    Cheque - THE NEW INDIA ASSURANCE CO LTD            "}]
[]
[]
[]
[]
[]
[]
[]
[]
["It works properly  --- >",null,null,{"$f":"D6","v":"Manish Chheda \nMediclaim\nPolicy No --  14230031150100004635\nRs.   5245\nDue Date -  16 - 01 - 2016\nDetails -  Manish M/32 - SI 5 Lacs\nDOC -  24 - 10 - 2010\nSum Insured - 500000"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"SUBTOTAL(3,H5:H30)","v":2},null,null,{"$f":"SUBTOTAL(3,E5:E29)","v":2},null,null,null,{"$f":"SUBTOTAL(9,I5:I29)","v":6191},null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUBTOTAL(9,#REF!)","v":{"$error":"#REF!"}},null,{"$f":"SUBTOTAL(9,#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"SUBTOTAL(9,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUBTOTAL(9,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUBTOTAL(9,#REF!)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Haresh P. Maru"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reminder of Your Accident Policy / Mediclaim "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cheque - The New India Assurance Co Ltd. ",null,null,null,null,"Cheque - The New India Assurance Co Ltd. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Approx Premium will be Rs. ","1100/-/- [ Do not write in Cheque ] ",null,null,null,"Please check last year policy "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Accident Policy Rs.  ","738/- [ Do not write in Cheque ] ",null,null,null,"any correction or change then let me know "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"confirm & Pay Before ","2015-07-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!/AC42*100","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shreya Securites -- Due date is 15/12/2013 "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Send last year copy with mark any correction and addition "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"With Blank Cheque -- in favour of  \" THE NEW INDIA ASSURANCE CO LTD \" "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Send the confirmation of mail . "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"Sheet1","index":1,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[26,2,26,6],[6,2,6,4],[15,2,15,6],[16,2,16,6],[22,2,22,5],[24,2,24,6],[42,2,42,3],[29,2,29,6],[35,2,35,6]]}
[]
[]
[]
[]
[]
[]
[null,null,"Respected Excel Masters"]
[]
[null,null,"Thanks a lot Abhishekji  Jain "]
[null,null,"It works properly"]
[null,null,"I have also enclosed corrected files so that it can help some one "]
[null,null,"It also save my lot of time now ",null,null,null,null,null,{"$f":"A3&$G$3","v":""}]
[null,null,null,null,null,null,null,null,"&E3&$G$3&$AA$4&                                                                                                                                                                                                                                                              AA3&$G$3"]
[null,null,"Some still queries ",null,null,null,null,null,"&$AE$4&AE3&$G$3"]
[null,"1]","If u see my formula in -- D3 ",null,null,null,null,null,"&$F$4&TEXT(F3,\"dd - mm - yyy\")&$G$3"]
[null,null,"I have to use many time same text  i.e. -- $G$3Alt+Tab",null,null,null,null,null,"&$R$4&R3&$G$3"]
[null,null,"can we have some solution that if I put in one cell then [ $G$3Alt+Tab ]",null,null,null,null,null,"&$O$4&TEXT(O3,\"DD - MM - yyy\")&$G$3"]
[null,null,"& I have to simply use that cell every time then it automatically ",null,null,null,null,null,"&$T$4&T3"]
[null,null,"use $g$3Al+ Tab"]
[]
[null,"2]","In Cell - D 15 "]
[null,null,"I have to always put cell which I have added last & then "]
[null,null,"I can copy to my Gmail Contact note "]
[]
[null,null,"Can we have solution for this as -- what ever is last added/corrected in any cell  "]
[null,null,"cell or in the Column D --- "]
[]
[null,null,"it automatically comes in the cell d15"]
[]
[null,null,"Or can u make any macro which I run ex -- I use Ctl + A "]
[null,null,"then last added cell automatically displaced in d15"]
[]
[null,null,"If it can be done without macro then it will be more helpful"]
[]
[null,"3] ","Can we have conditional formating like if my due date comes --- F -coulm entry"]
[null,null,"near 15 days of today then automatically full raw turns to yellor or other colour "]
[]
[null,null,"Ex -- full Raw 6 turns to any choice colur if  --F6 comes "]
[null,null,"near 15 days of today.."]
[]
[null,"4]","Or Due Date Cell Flash/ Blink if due date is near 15 days "]
[]
[null,"9] ","Thanks in advance "]