Spreadsheet: 513582d1492614959-calculate-price-of-hotel-room-according-to-season-room_bookings
Sheet: Tariffs

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tariff_Table |  |  |  | Adult | Child 6-14 | Child 2-5 | Child > 2
2017-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-01-01 00:00:00 |  |  | Low
 | M | M | M | M | M | M | M | M | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L |  |  |  |  |  |  | [NAME] | 42 | 31.5 | 27.5 | 0
2017-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Half B | 58.5 | 42.5 | 34.5 | 0
 | L | L | L | L | L | L | L | L | L | M | M | L | L | L | L | L | L | L | L | L | L | L | L | M | M | M | M | M |  |  |  |  |  |  |  |  |  | Full B | 70 | 51.5 | 40.5 | 0
2017-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mid
 | M | M | M | M | M | L | L | L | L | M | M | L | L | L | L | L | L | L | L | L | L | L | L | M | M | L | L | L | L | L | M |  |  |  |  |  |  | [NAME] | 45 | 31.5 | 27.5 | 0
2017-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Half B | 61.5 | 42.5 | 34.5 | 0
 | M | M | M | M | M | M | M | M | M | M | M | M | M | H | H | H | H | L | L | L | M | M | L | L | L | L | L | H | H | H |  |  |  |  |  |  |  | Full B | 73 | 51.5 | 40.5 | 0
2017-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High
 | H | L | L | L | M | M | L | L | L | L | L | M | M | L | L | L | L | L | H | H | M | M | M | H | H | H | H | M | L | L | L |  |  |  |  |  |  | [NAME] | 48 | 31.5 | 27.5 | 0
2017-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Half B | 64.5 | 42.5 | 34.5 | 0
 | L | H | H | H | H | L | L | L | H | H | L | L | L | L | L | H | H | L | L | L | L | L | H | H | L | L | L | L | L | H |  |  |  |  |  |  |  | Full B | 78 | 51.5 | 40.5 | 0
2017-07-01 00:00:00
 | H | M | M | M | M | M | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H
2017-08-01 00:00:00
 | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | M | M | M | M | M | H | H | M | M | M | M | M |  |  |  |  |  |  | Examples
2017-09-01 00:00:00
 | H | H | M | L | L | L | L | H | H | L | L | L | L | L | M | M | L | L | L | L | L | M | M | L | L | L | L | L | M | M |  |  |  |  |  |  |  | Room type | Dates |  | People
2017-10-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Arrive | 2017-03-14 00:00:00 | Adult | Child 6- 14 | Child 2-5 | Child > 2
 | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | M | M | M |  |  |  |  |  |  |  | Leave | 2017-03-28 00:00:00 | 1 | 2 | 0 | 0
2017-11-01 00:00:00
 | M | M | M | M | M | L | L | L | M | M | M | M | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L |  |  |  |  |  |  |  | Price:
2017-12-01 00:00:00
 | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | M | M | M | M | M | M | M | M | M | M |  |  |  |  |  |  | Room | Date | People | Price | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2017-05-14 00:00:00 | 1 Adult
Enter "H", "M", "L" for each day. Conditional formatting used to highlight cells. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-05-28 00:00:00 | 1 Child 6 - 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Room | Date | People | Price | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Half B | 2017-12-01 00:00:00 | 2 Adult
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-12-20 00:00:00 | 1 Child 6 - 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 Child 2-5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Room | Date | People | Price | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full B | 2017-06-01 00:00:00 | 1 Adult
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-06-14 00:00:00 | 2 Child 2-5