Order No Order Date Destination Customer Type Product Quantity Price Total Price
5023-1 6/1/2023 Home Office HBF-375
5050-1 6/1/2023 Corporate MC-720
5024-1 6/2/2023 Corporate HN-222T
5052-1 6/2/2023 Small Business MC-720
5025-1 6/4/2023 Consumer HBF-375
5043-1 6/5/2023 Small Business MC-720
5027-1 6/6/2023 Small Business HN-222T
5029-1 6/7/2023 Corporate HN-289
5045-1 6/8/2023 Consumer MC-720
5047-1 6/9/2023 Home Office HBF-375
5048-1 6/9/2023 Small Business HN-222T
5055-1 6/9/2023 Home Office MC-245
5031-1 6/9/2023 Corporate MC-245
5033-1 6/9/2023 Corporate MC-720
5034-1 6/10/2023 Corporate HBF-375
5049-1 6/12/2023 Corporate HBF-375
5036-1 6/19/2023 Corporate HN-289
5037-1 6/23/2023 Home Office HN-289
5038-1 6/25/2023 Corporate MC-245
5014-1 6/26/2023 Home Office MC-720
5016-1 6/26/2023 Home Office HN-222T
5018-1 6/27/2023 Corporate HBF-375
5039-1 6/27/2023 Corporate HN-222T
5019-1 6/28/2023 Home Office HN-222T
5040-1 6/28/2023 Small Business HN-289
5020-1 6/29/2023 Consumer MC-720
5095-1 7/1/2023 Corporate HN-222T
5097-1 7/1/2023 Small Business MC-245
5135-1 7/2/2023 Small Business MC-245
5099-1 7/2/2023 Consumer MC-720
5137-1 7/3/2023 Corporate HN-289
5103-1 7/3/2023 Corporate HBF-375
5138-1 7/3/2023 Small Business HN-289
5101-1 7/3/2023 Small Business HBF-375
5104-1 7/4/2023 Home Office MC-245
5140-1 7/6/2023 Corporate HN-289
5106-1 7/7/2023 Small Business HN-289
5142-1 7/7/2023 Home Office HBF-375
5108-1 7/8/2023 Home Office HBF-375
5144-1 7/8/2023 Corporate HN-289
5109-1 7/9/2023 Corporate HN-222T
5059-1 7/10/2023 Corporate HBF-375
5057-1 7/10/2023 Corporate HBF-375
5111-1 7/10/2023 Home Office HBF-375
5112-1 7/10/2023 Small Business HN-222T
5150-1 7/11/2023 Small Business MC-245
5148-1 7/11/2023 Home Office HN-289
5113-1 7/12/2023 Corporate HN-222T
5114-1 7/12/2023 Small Business HN-222T
5060-1 7/12/2023 Corporate HBF-375
5115-1 7/12/2023 Consumer HN-289
5061-1 7/12/2023 Small Business HN-222T
5062-1 7/12/2023 Consumer HN-289
5152-1 7/12/2023 Small Business HN-222T
5063-1 7/13/2023 Corporate HBF-375
5066-1 7/14/2023 Small Business HBF-375
5117-1 7/14/2023 Small Business HBF-375
5154-1 7/14/2023 Consumer MC-720
5064-1 7/14/2023 Home Office MC-245
5068-1 7/15/2023 Small Business MC-245
5158-1 7/15/2023 Corporate HBF-375
5156-1 7/15/2023 Home Office MC-720
5070-1 7/16/2023 Corporate HN-222T
5119-1 7/16/2023 Small Business MC-720
5159-1 7/16/2023 Small Business HBF-375
5071-1 7/17/2023 Corporate HBF-375
5071-2 7/17/2023 Corporate HN-289
5120-1 7/17/2023 Home Office MC-245
5122-1 7/17/2023 Corporate MC-245
5075-1 7/17/2023 Corporate HN-289
5160-1 7/17/2023 Corporate MC-245
5160-2 7/17/2023 Corporate HN-289
5124-1 7/18/2023 Small Business MC-720
5163-1 7/18/2023 Small Business HN-289
5077-1 7/19/2023 Small Business HN-222T
5125-1 7/19/2023 Corporate HN-222T
5079-1 7/21/2023 Home Office HBF-375
5127-1 7/21/2023 Corporate HN-222T
5081-1 7/21/2023 Consumer HN-222T
5128-1 7/22/2023 Small Business HBF-375
5165-1 7/22/2023 Corporate HN-222T
5166-1 7/22/2023 Corporate HN-289
5129-1 7/23/2023 Consumer HN-289
5084-1 7/25/2023 Home Office MC-245
5087-1 7/26/2023 Corporate HBF-375
5086-1 7/26/2023 Home Office HBF-375
5089-1 7/27/2023 Consumer MC-245
5131-1 7/27/2023 Small Business HBF-375
5168-1 7/27/2023 Consumer HN-222T
5133-1 7/27/2023 Consumer HBF-375
5134-1 7/28/2023 Corporate HN-222T
5091-1 7/31/2023 Home Office HBF-375
5093-1 7/31/2023 Home Office HBF-375
5177-1 8/1/2023 Small Business HBF-375
5178-1 8/2/2023 Corporate HBF-375
5215-1 8/2/2023 Home Office HBF-375
5216-1 8/2/2023 Small Business HN-289
5180-1 8/3/2023 Corporate MC-245
5181-1 8/3/2023 Corporate HBF-375
5183-1 8/4/2023 Corporate HBF-375
5218-1 8/4/2023 Small Business MC-245
5185-1 8/5/2023 Home Office HN-222T
5220-1 8/6/2023 Home Office HBF-375
5222-1 8/7/2023 Small Business HN-222T
5188-1 8/7/2023 Corporate HBF-375
5186-1 8/7/2023 Consumer HBF-375
5221-1 8/7/2023 Home Office HN-289
5189-1 8/8/2023 Small Business MC-720
5191-1 8/9/2023 Corporate HN-222T
5224-1 8/10/2023 Consumer MC-245
5193-1 8/10/2023 Small Business HN-222T
5194-1 8/11/2023 Corporate HBF-375
5225-1 8/11/2023 Consumer HBF-375
5226-1 8/11/2023 Home Office HBF-375
5195-2 8/12/2023 Consumer MC-720
5227-1 8/12/2023 Home Office HN-289
5195-1 8/12/2023 Consumer HN-289
5198-1 8/14/2023 Corporate MC-245
5229-1 8/14/2023 Home Office HBF-375
5231-1 8/15/2023 Corporate MC-245
5232-1 8/16/2023 Corporate MC-720
5235-1 8/17/2023 Corporate HN-222T
5234-1 8/17/2023 Small Business HN-289
5200-1 8/18/2023 Home Office MC-720
5201-1 8/19/2023 Home Office MC-720
5202-1 8/20/2023 Home Office HBF-375
5204-1 8/21/2023 Home Office HN-222T
5207-1 8/21/2023 Corporate HN-222T
5206-1 8/21/2023 Small Business HN-222T
5208-1 8/22/2023 Consumer HBF-375
5236-1 8/22/2023 Corporate HN-222T
5238-1 8/23/2023 Corporate HBF-375
5209-1 8/23/2023 Corporate HBF-375
5211-1 8/24/2023 Small Business MC-720
5239-1 8/25/2023 Small Business HN-222T
5240-1 8/25/2023 Consumer MC-245
5241-1 8/25/2023 Corporate HN-289
5212-1 8/26/2023 Corporate MC-245
5168-2 8/27/2023 Consumer HBF-375
5213-1 8/27/2023 Corporate HBF-375
5242-1 8/27/2023 Home Office MC-720
5171-1 8/28/2023 Home Office HBF-375
5173-1 8/28/2023 Corporate MC-245
5246-1 8/29/2023 Home Office HN-289
5174-1 8/29/2023 Consumer MC-245
5214-1 8/29/2023 Corporate HN-222T
5244-1 8/30/2023 Corporate HN-222T
5175-1 8/30/2023 Home Office HN-222T
Shipping Insurance CS Line
Destination Order No Qty Type Insurance
Jakarta 5014-1 29 Standard Full Product MC-245 HN-222T
Jakarta 5016-1 29 Flash Price Rp 845,000 Rp 465,000
Surabaya 5018-1 42 Standard Shipping
Jakarta 5019-1 6 Cargo Shipping
Surabaya 5020-1 17 Flash Shipping
Jakarta 5023-1 47 Standard
Surabaya 5024-1 32 Cargo
Bandung 5025-1 33 Cargo Shipping
Surabaya 5027-1 8 Standard Full
Surabaya 5029-1 48 Standard Full
Jakarta 5031-1 18 Flash Shipping
Bandung 5033-1 3 Flash
Surabaya 5034-1 50 Cargo Shipping
Jakarta 5036-1 50 Cargo
Surabaya 5037-1 16 Cargo
Jakarta 5038-1 38 Cargo Full
Surabaya 5039-1 22 Standard
Bandung 5040-1 48 Standard
Surabaya 5043-1 22 Standard Full
Surabaya 5045-1 30 Flash Full
Surabaya 5047-1 37 Cargo
Surabaya 5048-1 24 Flash Full
Surabaya 5049-1 4 Cargo Full
Jakarta 5050-1 36 Cargo Shipping
Jakarta 5052-1 31 Cargo Shipping
Surabaya 5055-1 29 Flash Shipping
Jakarta 5057-1 9 Flash
Surabaya 5059-1 7 Flash
Jakarta 5060-1 16 Cargo Full
Bandung 5061-1 27 Standard Shipping
Bandung 5062-1 39 Cargo
Jakarta 5063-1 7 Flash Full
Jakarta 5064-1 42 Flash Shipping
Surabaya 5066-1 15 Cargo Shipping
Surabaya 5068-1 20 Flash
Surabaya 5070-1 41 Standard Shipping
Surabaya 5071-1 41 Cargo Shipping
Surabaya 5071-2 2 Standard
Jakarta 5075-1 34 Cargo Full
Surabaya 5077-1 18 Standard
Surabaya 5079-1 8 Standard Full
Jakarta 5081-1 18 Cargo Shipping
Jakarta 5084-1 19 Standard Shipping
Jakarta 5086-1 26 Cargo Full
Surabaya 5087-1 45 Cargo Shipping
Surabaya 5089-1 14 Standard Full
Surabaya 5091-1 7 Standard Full
Jakarta 5093-1 29 Flash
Surabaya 5095-1 35 Flash Shipping
Surabaya 5097-1 47 Flash Full
Jakarta 5099-1 24 Flash Full
Bandung 5101-1 2 Standard
Jakarta 5103-1 4 Cargo
Surabaya 5104-1 33 Standard
Bandung 5106-1 42 Standard
Surabaya 5108-1 14 Cargo
Surabaya 5109-1 38 Flash Full
Bandung 5111-1 35 Flash
Bandung 5112-1 13 Standard Full
Surabaya 5113-1 14 Cargo
Surabaya 5114-1 33 Flash Full
Jakarta 5115-1 29 Flash Full
Surabaya 5117-1 38 Cargo Shipping
Surabaya 5119-1 34 Standard
Surabaya 5120-1 10 Flash
Surabaya 5122-1 38 Flash Shipping
Surabaya 5124-1 30 Flash Shipping
Surabaya 5125-1 29 Standard Shipping
Surabaya 5127-1 2 Flash Shipping
Surabaya 5128-1 39 Standard
Surabaya 5129-1 49 Cargo
Surabaya 5131-1 5 Flash Shipping
Jakarta 5133-1 27 Cargo Shipping
Jakarta 5134-1 3 Cargo
Surabaya 5135-1 10 Flash
Surabaya 5137-1 7 Cargo
Jakarta 5138-1 34 Standard Shipping
Bandung 5140-1 25 Cargo
Bandung 5142-1 26 Flash Full
Bandung 5144-1 3 Cargo
Jakarta 5148-1 44 Standard Full
Surabaya 5150-1 49 Flash
Bandung 5152-1 19 Flash
Surabaya 5154-1 32 Flash
Jakarta 5156-1 23 Standard
Surabaya 5158-1 34 Cargo Full
Jakarta 5159-1 21 Cargo Full
Jakarta 5160-1 41 Cargo Shipping
Jakarta 5160-2 26 Standard Shipping
Surabaya 5163-1 28 Standard Shipping
Surabaya 5165-1 11 Standard Full
Jakarta 5166-1 6 Flash Shipping
Surabaya 5168-1 20 Standard Shipping
Surabaya 5168-2 39 Cargo
Surabaya 5171-1 10 Flash Shipping
Jakarta 5173-1 13 Flash Shipping
Jakarta 5174-1 35 Standard Shipping
Jakarta 5175-1 15 Standard Shipping
Jakarta 5177-1 23 Flash Full
Surabaya 5178-1 12 Cargo Shipping
Surabaya 5180-1 11 Cargo Full
Surabaya 5181-1 29 Cargo
Jakarta 5183-1 11 Flash
Surabaya 5185-1 14 Standard Full
Bandung 5186-1 37 Cargo Shipping
Jakarta 5188-1 8 Cargo
Jakarta 5189-1 31 Flash
Bandung 5191-1 30 Standard Full
Jakarta 5193-1 38 Standard Shipping
Surabaya 5194-1 24 Cargo Full
Bandung 5195-1 11 Standard
Surabaya 5195-2 43 Cargo
Surabaya 5198-1 40 Standard Full
Jakarta 5200-1 46 Flash Shipping
Jakarta 5201-1 23 Flash
Surabaya 5202-1 44 Standard Full
Surabaya 5204-1 8 Cargo Shipping
Jakarta 5206-1 40 Flash Full
Surabaya 5207-1 35 Cargo Full
Jakarta 5208-1 50 Cargo
Jakarta 5209-1 19 Flash Full
Surabaya 5211-1 37 Flash Shipping
Surabaya 5212-1 12 Flash
Surabaya 5213-1 13 Flash
Bandung 5214-1 41 Cargo Full
Surabaya 5215-1 41 Cargo Full
Surabaya 5216-1 5 Flash Full
Bandung 5218-1 23 Cargo Shipping
Surabaya 5220-1 45 Standard Full
Bandung 5221-1 42 Flash Shipping
Surabaya 5222-1 32 Cargo Shipping
Surabaya 5224-1 45 Flash Full
Surabaya 5225-1 8 Flash Shipping
Bandung 5226-1 12 Standard
Surabaya 5227-1 32 Cargo Shipping
Bandung 5229-1 43 Flash Shipping
Surabaya 5231-1 9 Cargo Full
Jakarta 5232-1 26 Flash
Jakarta 5234-1 37 Cargo Shipping
Surabaya 5235-1 39 Cargo
Bandung 5236-1 24 Flash Full
Surabaya 5238-1 27 Standard Shipping
Surabaya 5239-1 37 Standard
Surabaya 5240-1 44 Flash
Bandung 5241-1 34 Cargo Full
Bandung 5242-1 46 Cargo Full
Surabaya 5244-1 3 Standard Shipping
Surabaya 5246-1 16 Flash
HN-289 HBF-375 MC-720
Rp 1,439,000 Rp 218,000 Rp 365,000
1. Lengkapi tabel di sheet 'Data' menggunakan lookup dari tabel 'Returned'
2. Lengkapi informasi CS Line dengan ketentuan sebagai berikut:
Nilai transaksi
< 5 jt --> Email
5 jt s/d 49,999 jt --> Agent
>=50 jt --> Priority
