I don’t think the nutrition plan was all wrong, it looks ok to me. I wouldn’t go for sausage and fries though.
You need a 3-5 hrs (one ride) ride on a weekly basis on top of 3-5hrs spread through the rest of the week at least. Plus a 5-7 hr ride every once in a while. That’d be a very simplistic approach that might work.
Does drinking slightly salty water fix that?
I never had that thought in my life
It turns into a dehydration situation when you don’t have enough electrolytes which can cause you to bonk. So on the day of an event, if it’s warm out, I shoot for 90g carbs an hour and 750mg of sodium.
don’t drink slightly salty, drink very salty. You can lose around 1000mg of sodium an hour on the bike. That’s half your daily caloric intake. I will ingest between 1000-2000 mg on rides between 2-4 hours.
I wish I could take in 1000+. I’ve found that anything much higher than 750mg starts to give me GI issues. That’s using sodium citrate.
yes, recommended daily amount.
Yeah dude like others mentioned, you were wildly undertrained but I am surprised it took 150km of 200 for you to finally hit the wall. I’d call it a success from that perspective. I understand you were I’ll in Feb but 4-5hrs a week before that still wasn’t enough for the distance.
I rode the RVV full course two weeks ago. It was my first time riding such a distance, and the conditions were awful for the first five hours. My biggest takeaway is that you must stay on top of your eating. I didn’t drink much water but ate food like a champ at every aid station and in between.
For your next event, you need to double your load IMO. Do VO2max/sub treshold intervals on week days and some low cadence climbing drills. Save your weekends for long rides. I found out that doing two slightly longer rides around Z2 with minimal stops on Saturday and Sunday has more gains than doing one very long ride on the weekend and taking a rest/recovery day. Save the recovery for Monday/Tue. Your stops are insanely long.
You have a decent base but need to do more no doubt. Good luck!
This is me
Only been riding semi seriously or with any kind of plan to improve for 3 years. Many years of commuting before that.
I don’t have much more time than to dedicate around 3 hours of structured training plus one long ride a week, with an occasional 2 long rides.
With the comments flying in and 10 weeks until my next 200+km ride, I’ve planned out more long rides so they I can gradually ramp up the distance, weekly TSS and climbing. It was good to have this weekend where things didn’t go right, so I can learn from it.
The first 150km I felt absolutely fine. If it had ended there I would have walked away and thought everything had gone to plan.
I had planned about 85g/hr but didn’t get through everything. I’ll try to train with 90+g/hr and see if I can get anything close to 100-120 by my next event. After this I think I’m going to rein in the longer distances. I’m finding I’m enjoying the 100km rides more than the 200 
Set a reminder on your head unity to eat. If you had a reminder, you would have gotten through your food, or gotten sick trying 
Just checked a few ‘best efforts’ and Saturday I had my fastest ever:
40km
50km
80km
50miles
100miles
180km
200km
and my 5th fastest 100km
So, as I already said above - lots of lessons learned, but some really good positives from the ride to build on rather than to get frustrated about.