I want to create a excel sheet in which there will be some column which will get the input in alphabets and numeric values. The last column will be for total. Irrespective of any alphabets and numeric values in the backend the excel should take 10 by default and if the cell is left blank then it should take value as 0. So in the total it should add all cell.

Ex: A B C D Total
SAM 34 yes 30 (10+10+0+10)...