To split no. of pax into single, double and triple rooms

I would like to know if we can get a formula/macro/power query for outcome below:
Single=1 bed, Double=2 beds, Triple=3 beds
Ignore 1 & 2 no. of passengers (abbreviated pax)
All i want is results that can go upto 20 or even 30 if possible.

Click to zoom on image below. and i've attached an xlsx file as well.
Am on office 365.

I have crossposted it to https://chandoo.org/forum/threads/to-split-no-of-pax-into-single-double-and-triple-rooms.47553/