Binary Integer Programming Solver Help

Hi,

I am working through developing a binary integer programming exersie in excel and using OpenSolver (because there are more than 200 variables) to solve it. My problem is that I have no idea what I am doing, as the solver is not treating the variables as binary. This is what I have developed already
yMi3hIk.png.

The book has provided the algebra for this problem:
172RAup.png

This is the problem for reference:
yZ8zEvj.jpg
Using the decision variables I should be able to draw the paths like this (after adding a load of constraints of course)
zRTqyvC.png

Could someone help me out with implementing the decision variables as I don't think I've done it correct, possibly over complicated it. This first step is preventing me with the rest of the problem.

Thank you all