I want to create a short code ID for for each of my tasks by hashing the task name ie “Take out the garbage” == XDYP or “Clean my room” == HGCP. I was inspired by the second answer to this Stack Overflow:

which is essential to use this formula:

`=MOD(MOD(MOD(MOD(MOD(IF(LEN(Z2)>=1,CODE(MID(Z2,1,1))+10,31),1009)*IF(LEN(Z2)>=3,CODE(MID(Z2,3,1))+10,41),1009)*IF(LEN(Z2)>=5,CODE(MID(Z2,5,1))+10,59),1009)*IF(LEN(Z2)>=7,CODE(MID(Z2,7,1))+10,26),1009)*IF(LEN(Z2)>=9,CODE(MID(Z2,9,1))+10,53),1009)`

Its a clever way to convert each character into a number and then perform some maths. It doesn’t need to be encryption grade because a collision is no big deal for my tasks.

The key to making it work above is the CODE function in excel which gives you the unicode numeric value of the character, kind of like the inverse of the `character()`

function in coda.

Any ideas on how to do this in Coda?