{
  "schema_version": "1.0",
  "company": "QBD",
  "report_year": 2026,
  "report_month": 7,
  "as_of_date": "2026-07-20",
  "filename": "QBD-July-2026.xlsx",
  "headers": [
    "ARRIVAL",
    "DEPARTURE",
    "NIGHTS",
    "BLOCK_CODE",
    "RES_COMMENT",
    "Booking Room",
    "Total Booking Price"
  ],
  "periods": [
    {
      "period": "01-10",
      "active": true,
      "sheet_name": "QBD 01-10 Jul 2026",
      "rows": [
        {
          "arrival": "2026-07-07",
          "departure": "2026-07-10",
          "nights": 3,
          "block_code": "SYN-BLOCK-A",
          "res_comment": "SYN-GROUP-A",
          "booking_room": "【SYN-SUP-TWN】2；【SYN-SUP-TRP】1",
          "total_booking_price": "【SYN-RM2】900×1 + 【SYN-RM2】1,800×1 = 2,700",
          "duplicate_group": true,
          "multi_price_review": true
        },
        {
          "arrival": "2026-07-08",
          "departure": "2026-07-10",
          "nights": 2,
          "block_code": "SYN-BLOCK-B",
          "res_comment": "SYN-GROUP-B",
          "booking_room": "【SYN-DELUXE-KNG】1",
          "total_booking_price": "【SYN-RM3】3,400×1 = 3,400",
          "duplicate_group": false,
          "multi_price_review": false
        }
      ]
    },
    {
      "period": "11-20",
      "active": true,
      "sheet_name": "QBD 11-20 Jul 2026",
      "rows": [
        {
          "arrival": "2026-07-17",
          "departure": "2026-07-20",
          "nights": 3,
          "block_code": "SYN-BLOCK-C",
          "res_comment": "SYN-GROUP-A",
          "booking_room": "【SYN-SUP-TWN】3",
          "total_booking_price": "【SYN-RM2】900×3 = 2,700",
          "duplicate_group": true,
          "multi_price_review": false
        }
      ]
    },
    {
      "period": "21-31",
      "active": false,
      "sheet_name": "QBD 21-31 Jul 2026",
      "rows": []
    }
  ]
}
