{"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":144,"n_cols":265,"rows_kept":144,"cut":false,"hidden":false,"merged":[[11,3,16,6],[19,3,26,6]]}
[null,null,null,null,"Mediclaim",null,null,null,null,"@ 14.50%",null,null,null,null,null,"Email - 29/07/2015",null,"Wts 29/07/2015"]
[null,{"$f":"B34","v":1},null,null,{"$f":"E34","v":1},null,null,null,877,{"$f":"ROUND(I2*101.901%,0)","v":894},null,"2015-07-01",null,{"$f":"B2","v":1},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 1  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&\" --\"&E3&\" --\"& \"Policy No. -- \"& AA3&\" --\"&\" Rs. \"&AE3&\"\"&\"   Due Date--\"&TEXT(F3,\"dd-mm-yyyy\")\n&\" --\"&\"-- Details --- \"&R3&\" -- First Date of Insurance --\"&TEXT(O3,\"dd-mm-yyyy\")&\"  ---  Sum Insured  -- \"&T3","v":"Name ---- --Policy No. -- 111 -- Rs. 11450   Due Date--04-05-2016 ---- Details --- Vehicle -- First Date of Insurance --26-03-2000  ---  Sum Insured  -- 17000"},"--",{"$f":"Z3","v":"2016-05-04"},null,null,{"$f":"AE3","v":11450},"Renewal ","Renewal ",null,null,null,"2000-03-26",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":" Total"},"Amount","Done","Busines Month","New / Ren Business","Branch","Date of 1 st Insurance ","SMS SEND","Confirmation","DETAILS ","Person","Sum Isured","Premium","Rate"," Net","Bill","Period From","Period To","Policy No.",{"$f":"LEN(AA4)","v":10},"Premium","     Ser. Tax"," Total","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","GGG",null,{"$f":"A5&\" --\"&E5&\" --\"& \"Policy No. -- \"& AA5&\" --\"&\" Rs. \"&AE5&\"\"&\"   Due Date--\"&TEXT(F5,\"dd-mm-yyyy\")\n&\" --\"&\"-- Details --- \"&R5&\" -- First Date of Insurance --\"&TEXT(O5,\"dd-mm-yyyy\")&\"  ---  Sum Insured  -- \"&T5","v":"Vaishali Mahendra Savla --Motor --Policy No. -- 14230031150100004634 -- Rs. 946   Due Date--31-12-2016 ---- Details ---  MH- 01-AQ-3954 -- Honda Activa ---  Year   2009    -- First Date of Insurance --01-01-2009  ---  Sum 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 ---  Year   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            "}]
[]
[]
[]
[]
[]
[]
["This is as per formula -- = D778",null,null,{"$f":"D5","v":"Vaishali Mahendra Savla --Motor --Policy No. -- 14230031150100004634 -- Rs. 946   Due Date--31-12-2016 ---- Details ---  MH- 01-AQ-3954 -- Honda Activa ---  Year   2009    -- First Date of Insurance --01-01-2009  ---  Sum Insured  -- 17000"}]
["By default "]
[]
[]
[]
[]
[]
[]
["I want this way ----- >>",null,null,"Vaishali Mahendra Savla --Motor\nPolicy No. -- 14230031150100004634\n Amt-- Rs. 946  \n Due Date--31-12-2016 --\nDetails --- MH- 01-AQ-3954 --\n Honda Activa ---\n  Year   2009    --\n First Date of Insurance --01-01-2009  \n---  Sum Insured  -- 17000"]
["with formula"]
[]
["I have try  use Alt + Enter "]
["But it can not work"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"SUBTOTAL(3,H5:H32)","v":1},null,null,{"$f":"SUBTOTAL(3,E5:E31)","v":1},null,null,null,{"$f":"SUBTOTAL(9,I5:I31)","v":946},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!/AC44*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":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[16,2,16,6],[6,2,6,4],[10,2,10,6],[11,2,11,6],[12,2,12,5],[14,2,14,6],[26,2,26,4],[32,2,32,3],[17,2,17,3],[19,2,19,6],[20,2,20,6],[22,2,22,5],[24,2,24,6],[25,2,25,6]]}
[]
[]
[]
[]
[]
[]
[null,null,"Respected Excel Masters"]
[]
[]
[]
[null,"1]","I am doing entries in Insurance files  in each cell separately"]
[null,"2]","Then I am clubbing all separate entries by using & formula"]
[null,"3] ","But I am getting result as shown in  d12"]
[]
[null,"4]","I want the same thing should be shown as d20"]
[]
[null,"5]","I am trying to use Alt + Enter to get the second row/ line  in down "]
[null,null,"But it not work"]
[]
[null,"6] ","This is required as I am pasting the same d20 in contact "]
[null,null,"so that in my mobile it shows correctly & not mix match"]
[]
[null,"7] ","Can anybody please help me in this "]
[]
[null,"8]","I want to make about 100 entries per month so "]
[null,null,"Kindly share the formula or way out so that I can use "]
[null,null,"same formula in  other files too "]
[]
[null,"9] ","How to check any spelling mistake in excel "]
[null,null,"Like in word we get red mark for wrong  spelling"]
[]
[]
[null,"9] ","Thanks in advance "]