Where's the Problem?

I still can't figure out what's wrong.  I think I must have made a mistake on some of the more basic magnitude equations.  My CCD transformations are definitely right, so the problem must be deeper.  The spreadsheets I make to do these equations are a little confusing.  I probably told the computer to look in the wrong box for a number.  Now I just have to find that number.