Replace cells and create dummy variables

Hi,

Once again i need help on an issue.

1. The cells containing a dot need to be replaced by zeros. This seems to be a problem as other cells containing numbers also contain dots.
2. Cells in column E, F and G refer to column A,B and C. Whenever there is no value in cells A,B and C i want to display a 0 for no value and a 1 for value in the respective Cells in column A,B and C respectivly. In this case F would refer to B and so on. (I did it manually to make my point clear in the file i uploaded)

If somebody could help me on this, that would be great. Thank you very much in advance. Attached find the file