Incorrect beam deflections

Hello all,

First off, I am a noob to Simulation.

I am getting a deflection that is not even close to what my hand calculations are telling me.  I have attached the excel file with hand calcs and the assembly file for the beams.  What have I done wrong?  Is it something to do with how I set up the mesh?  Is it something to do with the fixed ends? 

Thanks in advance,

Dave

SolidworksSimulation