Intra- and inter-atomic optical transitions of Fe, Co, and Ni ferrocyanides studied using first-principles many-electron calculations