I’m not sure if you are taking your future weight into account when you do your daily allowances per week but it looks ok to me. I think the only reason why the amount of water is of any importance is to tell you how many bottles you will need in case you work away from home.
I have done my own calculations based on my own targets. I see the magic “4.1” in your calculations, meaning you chose vanilla flavour, but I decided to go on a 500cal deficit continuously on 100% Huel until I reach my target “weight”.
I say “weight” in brackets because I think the last time I felt like I didn’t need to lose any weight was at around 60kg. So what I’ve done is make a spreadsheet that predicts, based on the generic “500cal daily deficit is half kilo weight loss”, exactly how much Huel to use, how much water to mix with it (assuming 500ml per 100g until I find the perfect mix) and how long it would take to reach my target.
My spreadsheet says if I start on the 1st of March at my current weight, I will hit 60kg just before my birthday! However, 60kg may be too thin, I might decide to stop losing weight before that, but Huel will make it easy to control my weight by calories.
This spreadsheet assumes 1kg weight loss per 2 weeks with a 500cal deficit using the formula at http://www.calculator.net/calorie-calculator.html
It also has red separators where I need to adjust my Huel measurements, and keeps them rounded to simple numbers. I’ve also decided that my dinner should only be 100g of Huel because my lifestyle is the epitome of sedentary - I work in an office full time and when I get home I do my freelance work in front of the computer again - I have little time for anything, let alone gym. At work I will consume my Huel slowly, over 15-45 minute periods with plenty of water.
Having said that, I think my weight could be a lot worse. I’m not very fat, but my beer belly is showing my age. It’s horrible to look at myself in the mirror. I’ve had acne on my face, shoulders and back since I was a teenager, and I’ve recently developed lactose intolerance. Paying closer attention to what I’ve been eating to avoid lactose has inadvertently improved my skin condition - presumably because I’m eating less junk. I don’t get spots on my face any more. I think my daily calorie intake is around 2000 and I never eat breakfast.
I can update my spreadsheet every 2 weeks with my actual weight and see the forecast adjust itself, but before I share the file, I want to actually do it. I want to prove that weight loss can be converted into maths and treated like a puzzle game. Mostly, I want to lose weight, have better skin, have better sleep, and produce better quality of work by being more alert without depending on coffee.
If I were to begin a journal of my Huel adventure, I’m sure I would get bored of updating it before I even get through one bag. Forecasting and proving my Huel journey is (and there’s no better phrase for this) for science!
I will start my own thread one month into the spreadsheet and make it public on Google Docs. By then I will be sure it’s right. I don’t want to give anyone false recommendations.