Tugas MS.Excel - Ticketing Pesawat

  • Published on
    11-Dec-2015

  • View
    13

  • Download
    9

Embed Size (px)

DESCRIPTION

Tampilan akhir tugas.

Transcript

  • No Kode Tiket Penumpang Nama PesawatJu

    rusa

    n

    Fasil

    itas

    Biaya/HargaPa

    jak Harga Tiket

    1 GA-0001J-BB Ahmad Syukur Garuda Airlines Jakarta-Bangkok Breakfast 1,100,000.00Rp 55,000.00Rp 1,155,000.00Rp

    2 SA-0002J-SL Diana Meriana Singapore Airlines Jakarta-Singapura Lunch 1,200,000.00Rp 60,000.00Rp 1,260,000.00Rp

    3 MA-0003J-MD Fahmi Hassan Malaysia Airlines Jakarta-Malaysia Dinner 1,000,000.00Rp 50,000.00Rp 1,050,000.00Rp

    4 LA-0002J-TD Erna Setiawan Lion Air Jakarta-Tokyo Dinner 2,500,000.00Rp 125,000.00Rp 2,625,000.00Rp

    5 HK-0001J-HD Miciko Hongkong Airlines Jakarta-Hongkong Dinner 2,400,000.00Rp 120,000.00Rp 2,520,000.00Rp

    6 GA-0002J-TB Yahya Setiawan Garuda Airlines Jakarta-Tokyo Breakfast 2,500,000.00Rp 125,000.00Rp 2,625,000.00Rp

    7 LA-0003J-BL Yusuf Erozz Lion Air Jakarta-Bangkok Lunch 1,100,000.00Rp 55,000.00Rp 1,155,000.00Rp

    8 MA-0002J-MB Titis Mega Ningtyas Malaysia Airlines Jakarta-Malaysia Breakfast 1,000,000.00Rp 50,000.00Rp 1,050,000.00Rp

    Tabel Jurusan Tabel Nama PesawatKode Tiket Jurusan Biaya/Harga Kode Tiket Nama Pesawat

    J-B Jakarta-Bangkok 1,100,000.00Rp GA Garuda Airlines

    J-S Jakarta-Singapura 1,200,000.00Rp SA Singapore Airlines

    J-M Jakarta-Malaysia 1,000,000.00Rp MA Malaysia Airlines

    J-T Jakarta-Tokyo 2,500,000.00Rp LA Lion Air

    J-H Jakarta-Hongkong 2,400,000.00Rp HK Hongkong Airlines

    Tabel FasilitasKode Tiket B L D

    Fasilitas Breakfast Lunch Dinner