How to add the new quotation Number automatically

here we needed to create a quotation Number automatically updated mentioned in the excel sheet. could you please refer the excel sheet.