This sheet can calculate the value of your name or any word by summing every letter with alphabetical order.
Here I have created a box to input a word.
I have put this formula =LEN(B2) to calculate the length of the word.
Now I have written A-Z in a column and in the next column I have written the order of alphabet.
In the next column I will put the formula =IFERROR(VLOOKUP(UPPER(J2),$P$2:$Q$27,2,FALSE),0). This formula will lookup the value of every letter as per alphabetical order.
This is how it works.
I have provided the download link of the file. Download and try it.