need to solve mathematical model

[excelprofessional17]

Hi all,

I have an excel spreadsheet that can predict the air composition of a room based on the room size, number of occupants, leakage rate inside the room and gas infiltration. I would like to develop this model one stage further.

Please see the attached spreadsheet where in red text I have mentioned needs.

Thanks for your solution.