Calculate price of hotel room according to season

If you can post a file (maybe mine with the updated tariff table) and some examples of the room categories/client categories calculations , then I will look to update the file.

I did look at the original image but was too idle to input the data into my table!!!

With regard to the second image: can please provide that is table in Excel. It is very easy to "lookup" such a table given we have Room/Client categories.