For me this experiment is a testament to the variety of human individuality, and the resilience of the human organism.
I can't imagine wanting to replace most of my food with a powder shake, and I drink them fairly regularly post-gym. Beyond that, I think the author's self-testing and self-evaluations are so lost in noise, and so subjective, that they have virtually no measurement value. Finally, his method of picking out what he needs seems ad-hoc and partial.
While we can show lots of things are wrong with chronically bad diets, the human body is surprisingly good at dealing with sub-optimal quantities and qualities of food. The 'perfect' diet is a curious notion really, since the body is a dynamic system that responds to input.