{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Policy","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":37,"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":150,"n_cols":265,"rows_kept":150,"cut":false,"hidden":false,"merged":[[24,2,30,5]]}
[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":"B40","v":15},null,null,null,null,null,null,877,{"$f":"ROUND(I2*101.901%,0)","v":894},null,"2015-07-01",null,{"$f":"B2","v":15},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":"GetConcat(A3)","v":"Name\r\nMotor\r\nPolicy No --  111\r\nRs.   11450\r\nDue Date -  04/05/2016\r\nDetails -  Vehicle\r\nDOC -  01/01/2009\r\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 ",null,null,{"$f":"GetConcat(A5)","v":"Vaishali Mahendra \r\nMotor\r\nPolicy No --  14230031150100004634\r\nRs.   946\r\nDue Date -  31/12/2016\r\nDetails -   MH- 01-AQ-3954 -- Honda Activa ---  \nYear  2009   \r\nDOC -  01/01/2009\r\nSum Insured - 17000"},"Motor",{"$f":"Z5","v":"2016-12-31"},"Wadala  ","Direct 4",{"$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 ---Reminder New India Policy of Motor  Renewal  -----Premium  Approx Rs . --   Pay Before 00-01-1900    Cheque - THE NEW INDIA ASSURANCE CO LTD            "}]
["Manish Chheda  5",null,null,"Manish Chheda  5\r\nMediclaim 2007\r\nPolicy No --  14230031150100004635\r\nRs.   6870\r\nDue Date -  15/12/2015\r\nDetails -  Manish M/32 - SI 5 Lacs\r\nDOC -  24/10/2010\r\nSum Insured - 500000","Mediclaim 2007","2015-12-15","Dadar  ","Direct 2",6870,null,null,"2016-01-01",null,null,"2010-10-24",null,null,"Manish M/32 - SI 5 Lacs",1,500000,6000,15,{"$f":"ROUND((U6*V6)%,0)","v":900},null,"2014-12-15","2015-12-15","14230031150100004635",20,6000,870,6870,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  5---Reminder New India Policy of Mediclaim 2007  Renewal  -----Premium  Approx Rs . --   Pay Before 00-01-1900    Cheque - THE NEW INDIA ASSURANCE CO LTD            "}]
["Bhart chheda ",null,null,"Bhart chheda \r\nMediclaim \r\nPolicy No --  14230031150100004\r\nRs.   7443\r\nDue Date -  15/12/2015\r\nDetails -  Manish M/32 - SI 5 Lacs\r\nDOC -  24/10/2010\r\nSum Insured - 500000","Mediclaim ","2015-12-15","Area B","Direct  ",7443,null,null,"2016-01-01",null,null,"2010-10-24",null,null,"Manish M/32 - SI 5 Lacs",1,500000,6500,15,975,null,"2015-02-15","2016-02-15","14230031150100004",17,6500,943,7443]
["Ramesh Gala",null,null,"Ramesh Gala\r\nMediclaim\r\nPolicy No --  173\r\nRs.   1718\r\nDue Date -  01/03/2016\r\nDetails -  Manish M/32 - SI 10 Lacs\r\nDOC -  24/10/2011\r\nSum Insured - 500000","Mediclaim","2016-03-01","Dadar  ","Vibha 2   ",1718,null,null,"2016-01-01",null,null,"2011-10-24",null,null,"Manish M/32 - SI 10 Lacs",1,500000,1500,15,225,null,"2015-01-23","2016-01-23",173,3,1500,218,1718]
["Shah Vaibhav 123",null,null,"Shah Vaibhav 123\r\nMediclaim 123\r\nPolicy No --  145\r\nRs.   4351\r\nDue Date -  02/04/2016\r\nDetails -  Good 5 Lacs \r\nDOC -  24/10/2015\r\nSum Insured - 500000","Mediclaim 123","2016-04-02","Area","Vibha 2  ",4351,null,null,"2016-01-01",null,null,"2015-10-24",null,null,"Good 5 Lacs ",1,500000,3800,15,570,null,"2015-03-16","2016-03-15",145,3,3800,551,4351]
["Vibha MedicAL  123",null,null,"Vibha MedicAL  123\r\nShop \r\nPolicy No --  145\r\nRs.   4351\r\nDue Date -  15/03/2016\r\nDetails -  Good 5 Lacs \r\nDOC -  24/10/2015\r\nSum Insured - 500000","Shop ","2016-03-15","Area","Vibha 2  ",4351,null,null,"2016-01-01",null,null,"2015-10-24",null,null,"Good 5 Lacs ",1,500000,3800,15,570,null,"2015-03-16",{"$f":"Y10+365","v":"2016-03-15"},145,3,3800,551,4351]
["Shah Vaibhav ",null,null,{"$f":"GetConcat(A11)","v":"Shah Vaibhav \r\nShop \r\nPolicy No --  145\r\nRs.   4351\r\nDue Date -  01/03/2016\r\nDetails -  Good 5 Lacs \r\nDOC -  24/10/2015\r\nSum Insured - 500000"},"Shop ","2016-03-01","Area","Vibha 2  ",{"$f":"AE11","v":4351},null,null,"2016-01-01",null,null,"2015-10-24",null,null,"Good 5 Lacs ",1,500000,3800,15,570,null,"2015-03-16",{"$f":"Y11+365","v":"2016-03-15"},145,3,{"$f":"U11","v":3800},551,{"$f":"AC11+AD11","v":4351}]
["Pankaj K.  Gala  ",null,null,"Pankaj K.  Gala  \r\nMediclaim \r\nPolicy No --  \r\nRs.   14045\r\nDue Date -  01/03/2016\r\nDetails -  Pankaj -800 + B150\r\nDOC -  21/03/2005\r\nSum Insured - 1600000","Mediclaim ","2016-03-01","Matunga","Gala ",14045,null,"Yes","2015-03-01",null,null,"2005-03-21",null,null,"Pankaj -800 + B150",2,1600000,12500,15,1875,null,"2015-03-21",{"$f":"Y12+364","v":"2016-03-19"},null,0,12500,{"$f":"ROUNDUP(AC12*0.1236,0)","v":1545},14045,null,null,null,null,null,null,null,"2014-15"]
["Jenis P. Gala   123",null,null,"Jenis P. Gala   123\r\nMediclaim 2007\r\nPolicy No --  1223\r\nRs.   20731\r\nDue Date -  19/03/2016\r\nDetails -  Jenis -800+ 100 +Jay - 800+ 150\r\nDOC -  21/03/2005\r\nSum Insured - 800000","Mediclaim 2007",{"$f":"Z13","v":"2016-03-19"},"Matunga","Gala ",20731,null,"Yes","2015-03-01",null,null,"2005-03-21",null,null,"Jenis -800+ 100 +Jay - 800+ 150",1,800000,18450,15,2768,null,"2015-03-21","2016-03-19",1223,4,18450,2281,20731,null,null,null,null,null,null,null,"2014-15"]
["Jenis P. Gala    123",null,null,{"$f":"GetConcat(A14)","v":"Jenis P. Gala    123\r\nMediclaim\r\nPolicy No --  \r\nRs.   20731\r\nDue Date -  19/03/2016\r\nDetails -  Jenis -800+ 100 +Jay - 800+ 150\r\nDOC -  21/03/2005\r\nSum Insured - 800000"},"Mediclaim",{"$f":"Z14","v":"2016-03-19"},"Matunga","Gala ",20731,null,"Yes","2015-03-01",null,null,"2005-03-21",null,null,"Jenis -800+ 100 +Jay - 800+ 150",1,800000,18450,15,2768,null,"2015-03-21","2016-03-19",null,0,{"$f":"U14","v":18450},{"$f":"ROUNDUP(AC14*0.1236,0)","v":2281},{"$f":"AC14+AD14","v":20731},null,null,null,null,null,null,null,"2014-15"]
["Ramesh Chheda 11",null,null,{"$f":"GetConcat(A15)","v":"Ramesh Chheda 11\r\nMediclaim 2008\r\nPolicy No --  \r\nRs.   20731\r\nDue Date -  19/03/2016\r\nDetails -  Jenis -800+ 100 +Jay - 800+ 150\r\nDOC -  21/03/2005\r\nSum Insured - 800000"},"Mediclaim 2008",{"$f":"Z15","v":"2016-03-19"},"Matunga","Gala ",20731,null,"Yes","2015-03-01",null,null,"2005-03-21",null,null,"Jenis -800+ 100 +Jay - 800+ 150",1,800000,18450,15,{"$f":"ROUND((U15*V15)%,0)","v":2768},null,"2015-03-21","2016-03-19",null,{"$f":"LEN(AA15)","v":0},{"$f":"U15","v":18450},{"$f":"ROUNDUP(AC15*0.1236,0)","v":2281},{"$f":"AC15+AD15","v":20731},null,null,null,null,null,null,null,"2014-15"]
["Ramesh Chheda 11",null,null,{"$f":"GetConcat(A16)","v":"Ramesh Chheda 11\r\nMediclaim 2008\r\nPolicy No --  \r\nRs.   20731\r\nDue Date -  19/03/2016\r\nDetails -  Jenis -800+ 100 +Jay - 800+ 150\r\nDOC -  21/03/2005\r\nSum Insured - 800000"},"Mediclaim 2008",{"$f":"Z16","v":"2016-03-19"},"Matunga","Gala ",20731,null,"Yes","2015-03-01",null,null,"2005-03-21",null,null,"Jenis -800+ 100 +Jay - 800+ 150",1,800000,18450,15,{"$f":"ROUND((U16*V16)%,0)","v":2768},null,"2015-03-21","2016-03-19",null,{"$f":"LEN(AA16)","v":0},{"$f":"U16","v":18450},{"$f":"ROUNDUP(AC16*0.1236,0)","v":2281},{"$f":"AC16+AD16","v":20731},null,null,null,null,null,null,null,"2014-15"]
["Jenis P. Gala    112",null,null,"Jenis P. Gala    112\r\nMediclaim \r\nPolicy No --  1223\r\nRs.   20731\r\nDue Date -  19/03/2016\r\nDetails -  Jenis -800+ 100 +Jay - 800+ 150\r\nDOC -  21/03/2005\r\nSum Insured - 800000","Mediclaim ","2016-03-19","Matunga","Gala ",20731,null,"Yes","2015-03-01",null,null,"2005-03-21",null,null,"Jenis -800+ 100 +Jay - 800+ 150",1,800000,18450,15,2768,null,"2015-03-21","2016-03-19",1223,4,18450,2281,20731,null,null,null,null,null,null,null,"2014-15"]
["Jenis P. Gala    112",null,null,"Jenis P. Gala    112\r\nMediclaim 2007\r\nPolicy No --  \r\nRs.   20731\r\nDue Date -  19/03/2016\r\nDetails -  Jenis -800+ 100 +Jay - 800+ 150\r\nDOC -  21/03/2005\r\nSum Insured - 800000","Mediclaim 2007","2016-03-19","Matunga","Gala ",20731,null,"Yes","2015-03-01",null,null,"2005-03-21",null,null,"Jenis -800+ 100 +Jay - 800+ 150",1,800000,18450,15,2768,null,"2015-03-21","2016-03-19",null,0,18450,2281,20731,null,null,null,null,null,null,null,"2014-15"]
["Ramesh Chheda 11",null,null,"Ramesh Chheda 11\r\nMediclaim 2008\r\nPolicy No --  \r\nRs.   20731\r\nDue Date -  19/03/2016\r\nDetails -  Jenis -800+ 100 +Jay - 800+ 150\r\nDOC -  21/03/2005\r\nSum Insured - 800000","Mediclaim 2008","2016-03-19","Matunga","Gala ",20731,null,"Yes","2015-03-01",null,null,"2005-03-21",null,null,"Jenis -800+ 100 +Jay - 800+ 150",1,800000,18450,15,2768,null,"2015-03-21","2016-03-19",null,0,18450,2281,20731,null,null,null,null,null,null,null,"2014-15"]
[]
[]
[]
[]
[]
[null,null,{"$f":"OFFSET($D$1,16,0)","v":"Jenis P. Gala    112\r\nMediclaim \r\nPolicy No --  1223\r\nRs.   20731\r\nDue Date -  19/03/2016\r\nDetails -  Jenis -800+ 100 +Jay - 800+ 150\r\nDOC -  21/03/2005\r\nSum Insured - 800000"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"SUBTOTAL(3,H5:H38)","v":15},null,null,{"$f":"SUBTOTAL(3,E5:E37)","v":15},null,null,null,{"$f":"SUBTOTAL(9,I5:I37)","v":189192},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!/AC50*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":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,2,39,3],[28,2,28,6],[35,2,35,6],[6,2,6,4],[16,2,16,6],[23,2,23,6]]}
[]
[]
[]
[]
[]
[]
[null,null,"Respected All"]
[]
[null,null,"Last time some brothers have help to make this file perfect ",null,null,null,null,"It has some still issue . I think there is some correction required  "]
[null,null,null,null,null,null,null,"in the formulla "]
[null,null,"I want some clarification / suggestion on this file "]
[]
[]
[]
[null,null,"I have approx more than 1000 entries to do in this file "]
[null,"1] ","when I start inserting lines & copy paste data  from other files "]
[null,null,"then it does not work properly"]
[]
[null,null,"What is the logic of this "]
[]
[null,"2] ","when I make the entry in this file & some other files open at the same time "]
[null,null,"then all the formula "]
[]
[]
[]
[null,null,"Then all the details pertaining -- respectively "]
[null,null,"change in D 15"]
[]
[null,null,"at present it not change for D 15"]
[]
[null,"3]","I have to refesh my cell entry then It show change"]
[]
[null,null,"I want that if I make any changes in any raw "]
[null,null,"then last updated raw details "]
[null,null,"then it should automatically updates all "]
[null,null,"details of that raw "]
[null,null,"& show it on Cell D15"]
[]
[]
[null,null,"Thanks in advance "]