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.