Training Excel LV 1a

Ubah header tabel dibawah agar menjadi seperti ini
Customer Data
Date
Customer Code Customer Name
3/30/12 T.G. T.G. INTERNATIONAL
5/30/12 APSA APSARATEX
6/30/12 MDRA INDIAN RAYON & INDUSTRIES
6/30/12 KL G.KALLIS MFRS.LTD
6/30/12 HJ HOCK JOO
6/30/12 ROSE ROSE E DEE
6/30/12 RGF RGF INTERNATIONAL LTD
6/30/12 KAYT KAYTEE CORPORATION
6/30/12 HJC H.J.C. (I&E) PRIVATE LTD
6/30/12 ITL ITL
6/30/12 MAHE MAHENDER ENT
6/30/12 DSGN DESIGN TEX
7/30/12 FAMI FAMILY CARE
7/15/12 GOLD GOLDEN COAST
7/31/12 BUSA BUSALEH TRADING
7/31/12 GREN GREENWORTH INT'L PTE LTD
7/31/12 HUES HUESPE E HIJOS
7/31/12 DAFA DHAFAF DUBAI GENERAL TRAD
7/31/12 SW SWEE WAN ENTERPRISES
7/31/12 ITL ITL
Customer Data Sales Data
Customer Address Product Price/Unit Qty Ammout
275 YOUNG ST., WATERLOO PW3131 $ 2.26 65 $ 146.90
111 SOMMERSET RD., #14-01 DEVONSHIRE WING PW2121 $ 3.60 75 $ 270.00
WORLD TRADE CENTRE-1 TW8251 $ 3.80 65 $ 247.00
23RD FL. GEDUNG WISMA 76 ( WISMA CALINDRA ) PW6161 $ 2.60 75 $ 195.00
NSW, AUSTRALIA TW8251 $ 2.75 100 $ 275.00
SINGAPORE POWER BUILDING PSF256 $ 1.81 100 $ 181.00
12TH FLOOR, TS1851 $ 2.20 65 $ 143.00
JL. LET. JEND. S. PARMAN KAV. 76, PW3131 $ 2.26 70 $ 158.20
SINGAPORE 238164 PW2121 $ 3.60 100 $ 360.00
JL JEND SUDIRMAN KAV.29-31 TW8251 $ 3.80 100 $ 380.00
SLIPI, PALMERAH. PW6161 $ 2.60 65 $ 169.00
OFF AL-FAHIDI STREET TW8251 $ 2.75 75 $ 206.25
yye PSF256 $ 1.81 100 $ 181.00
WORLD TRADE CENTRE-1 TS1851 $ 2.20 75 $ 165.00
45RD FL. GEDUNG BINAKARNA PW3131 $ 2.26 65 $ 146.90
JL. LET. JEND. S. PARMAN KAV. 341 PW2121 $ 3.60 100 $ 360.00
12TH FLOOR, TW8251 $ 3.80 100 $ 380.00
DUBAI ( U.A.E ) PW6161 $ 2.60 100 $ 260.00
SLIPI, PALMERAH. TW8251 $ 2.75 100 $ 275.00
JL JEND SUDIRMAN KAV.29-31 PSF256 $ 1.81 100 $ 181.00
Berikut adalah hasil penjualan PT. QWERTY
Amount adalah harga * Qty
Gross amount adalah pendapat sebelum dipotong pajak. Nett amount adalah pendapatan setelah dipotong pajak
Buat agar kolom Price dan Amount memiliki 2 angka dibelakang koma (2 decimal), dalam satuan Dollar
Bulatkan keatas nominal pada kolom Amount, dan letakan didalam kotak Rounded Amount
Pada kolom Rounded Amount, memiliki 1 angka dibelakang koma (1 decimal)
Baris pertama (row 16) merupakan contoh
Copy lah hasil perhitungan Gross Amount, Nett Amout dan Average Amount dari tabel dibawah kedalam kotak Summary berik
Summary
Gross Amout $ 10,450.00
Nett Amout $ 9,405.00
Average Amount $ 213.35
Total Transaction $ 9,405.00
Product Invoice No. Price/Unit Qty Amount

PW3131 12JG-235MXMEX/YALE $ 2.26 65 $ 146.90
PW2121 12JG-247NZAKL/JOHN $ 3.60 75 $ 270.00
TW8251 12JG-247NZAKL/JOHN $ 3.80 65 $ 247.00
PW6161 12JG-250BNMUA/DAYANG $ 2.60 75 $ 195.00
TW8251 12JG-252MXMEX/YALE $ 2.75 100 $ 275.00
PSF256 12JG-252MXMEX/YALE $ 1.81 100 $ 181.00
TS1851 12JG-260FJSUV/U.APPAREL $ 2.20 65 $ 143.00
PW3131 12JW-233AEJEA/RATTI $ 2.26 70 $ 158.20
PW2121 12JW-233AEJEA/RATTI $ 3.60 100 $ 360.00
TW8251 12JW-234SAJED/AL-KHANBASHI $ 3.80 100 $ 380.00
PW6161 12JW-234SAJED/AL-KHANBASHI $ 2.60 65 $ 169.00
PSF256 12JW-234SAJED/AL-KHANBASHI $ 1.81 100 $ 181.00
TS1851 12JW-236AEJEA/DEEPAK'S $ 2.20 75 $ 165.00
PW3131 12JW-236AEJEA/DEEPAK'S $ 2.26 65 $ 146.90
PW2121 12JW-236AEJEA/DEEPAK'S $ 3.60 100 $ 360.00
TW8251 12JW-236AEJEA/DEEPAK'S $ 3.80 100 $ 380.00
PW6161 12JW-237AEJEA/SHREE $ 2.60 100 $ 260.00
TW8251 12JW-237AEJEA/SHREE $ 2.75 100 $ 275.00
PSF256 12JW-237AEJEA/SHREE $ 1.81 100 $ 181.00
TS1851 12JW-237AEJEA/SHREE $ 2.20 100 $ 220.00
PW3131 12JW-237AEJEA/SHREE $ 2.26 65 $ 146.90
PW2121 12JW-238SGSIN/HJ $ 3.60 65 $ 234.00
TW8251 12JW-238SGSIN/HJ $ 3.80 65 $ 247.00
PW6161 12JW-238SGSIN/HJ $ 2.60 81 $ 210.60
TW8251 12JW-239QADOH/RAZAK $ 2.75 65 $ 178.75
PSF256 12JW-239QADOH/RAZAK $ 1.81 65 $ 117.65
TS1851 12JW-240TZDAR/FLORIDA $ 2.20 65 $ 143.00
PW3131 12JW-240TZDAR/FLORIDA $ 2.26 65 $ 146.90
PW2121 12JW-261SGSIN/HJ $ 3.60 65 $ 234.00
TW8251 12JW-261SGSIN/HJ $ 3.80 65 $ 247.00
PW6161 12JW-261SGSIN/HJ $ 2.60 65 $ 169.00
TW8251 12JW-262KWKWI/GULF-1ST $ 2.75 65 $ 178.75
PSF256 12JW-262KWKWI/GULF-1ST $ 1.81 65 $ 117.65
TS1851 12JW-262KWKWI/GULF-1ST $ 2.20 75 $ 165.00
PW3131 12JW-256SAJED/BORJ $ 2.26 65 $ 146.90
PW2121 12JW-256SAJED/BORJ $ 3.60 65 $ 234.00
TW8251 12JW-256SAJED/BORJ $ 3.80 75 $ 285.00
PW6161 12JW-256SAJED/BORJ $ 2.60 100 $ 260.00
TW8251 12JW-257MYPKG/GL $ 2.75 100 $ 275.00
PSF256 12JW-257MYPKG/GL $ 1.81 100 $ 181.00
TS1851 12JW-257MYPKG/GL $ 2.20 100 $ 220.00
PW3131 12JW-257MYPKG/GL $ 2.26 100 $ 226.00
PW2121 12JW-257MYPKG/GL $ 3.60 65 $ 234.00
PW6161 12JW-251SAJED/AL-KHANBASHI $ 2.60 65 $ 169.00
PSF256 12JW-254AEJEA/RATTI $ 1.81 65 $ 117.65
TS1851 12JW-254AEJEA/RATTI $ 2.20 65 $ 143.00
Total Transaction Gross Ammout 10,450
Tax 10%
Nett Amount
Average Amount 213.27
an setelah dipotong pajak
m satuan Dollar
bawah kedalam kotak Summary berikut ini
Rounded Amount 123.00 Kg

147.0 2,345.00 Kg
$ 270.00 4,521.00 Kg
$ 247.00
$ 195.00
$ 275.00
$ 181.00
$ 143.00
$ 159.00
$ 360.00
$ 380.00
$ 169.00
$ 207.00
$ 181.00
$ 165.00
$ 147.00
$ 360.00
$ 380.00
$ 260.00
$ 275.00
$ 181.00
$ 220.00
$ 147.00
$ 234.00
$ 247.00
$ 211.00
$ 179.00
$ 118.00
$ 143.00
$ 147.00
$ 234.00
$ 247.00
$ 169.00
$ 179.00
$ 118.00
$ 165.00
$ 147.00
$ 234.00
$ 285.00
$ 260.00
$ 275.00
$ 181.00
$ 220.00
$ 226.00
$ 234.00
$ 247.00
$ 169.00
$ 275.00
$ 118.00
$ 143.00
$10,450.0
$1,045.0
$9,405.0
213.35
Hilangkan garis/grid pada worksheet ini, sehingga seperti gambar dibawah ini
Laporan Penjualan Bulanan PT. Kiri Kanan Oke
Data Penjualan Bulanan PT. Kiri Kanan Oke

erti gambar dibawah ini
an Bulanan PT. Kiri Kanan Oke
ualan Bulanan PT. Kiri Kanan Oke

Berikan Header berupa tanggal hari ini
Footer berupa halaman lembar
Dan jadikan baris 5 dan 6 sebagai Line header agar akan selalu muncul disetiap page
Atur orientasi halaman dengan benar
Customer Data
Date
Customer Code Customer Name
3/30/12 T.G. T.G. INTERNATIONAL
5/30/12 APSA APSARATEX
6/30/12 MDRA INDIAN RAYON & INDUSTRIES
6/30/12 KL G.KALLIS MFRS.LTD
6/30/12 HJ HOCK JOO
6/30/12 ROSE ROSE E DEE
6/30/12 RGF RGF INTERNATIONAL LTD
6/30/12 HJC H.J.C. (I&E) PRIVATE LTD
6/30/12 ITL ITL
6/30/12 MAHE MAHENDER ENT
6/30/12 DSGN DESIGN TEX
7/30/12 FAMI FAMILY CARE
7/15/12 GOLD GOLDEN COAST
7/31/12 BUSA BUSALEH TRADING
7/31/12 GREN GREENWORTH INT'L PTE LTD
7/31/12 HUES HUESPE E HIJOS
7/31/12 DAFA DHAFAF DUBAI GENERAL TRAD
7/31/12 SW SWEE WAN ENTERPRISES
7/31/12 ITL ITL
7/31/12 GALA GALAXY TEXTILE
7/30/12 ABDL ABDUL RAZAK
7/30/12 ROYA ROYAL TRADER
7/30/12 AG AGHA
7/30/12 LARR TEXTIL LARREA S.A.C.I
7/15/12 ST IE A WOEN / PD.SENTOSA JAYA
7/30/12 MKM MIKOMI
7/30/12 SURY PD. SURYA MANGGALA
7/30/12 BSL BRUCE SMITH LTD
7/30/12 GERS GERSTLER
7/5/12 TREF AL-TAREEF TEXTILE EST
7/5/12 FERM FERMIN CHAN
7/30/12 GURT GURTEEN
7/30/12 OTHM AL-OTHMAN TEXTILE
7/30/12 GOOD GOOD LUCK TEXTILE EST
7/30/12 FAIS FAISAL AL-HULAIFY
7/30/12 ALL BMD TEXTILES (OTY) LTD
7/30/12 GEM GEM SCHOOLWEAR
7/30/12 NABI NABIL
7/30/12 ALHU AL-HUSAIKI
7/30/12 DELT DELTA TRADE
7/30/12 CROC CROCHET
7/31/12 ALI ALI HASAN SAFAR
7/30/12 NAJM NAJMA AL-AGHAR
7/30/12 ROJA ROJA TRADING
7/30/12 TRI PD. TRI KENCANA
7/30/12 SP PD. SURYA PRATAMA
8/30/12 AJLN AF AL AJLAN
akan selalu muncul disetiap page
Customer Data Sales Data

Customer Address Product Price/Unit Qty Ammout
275 YOUNG ST., WATERLOO PW3131 $ 2.26 65 $ 146.90
WORLD TRADE CENTRE-1 TW8251 $ 3.80 65 $ 247.00
23RD FL. GEDUNG WISMA 76 ( WISMA CALINDRA ) PW6161 $ 2.60 75 $ 195.00
NSW, AUSTRALIA TW8251 $ 2.75 100 $ 275.00
SINGAPORE POWER BUILDING PSF256 $ 1.81 100 $ 181.00
12TH FLOOR, TS1851 $ 2.20 65 $ 143.00
JL. LET. JEND. S. PARMAN KAV. 76, PW3131 $ 2.26 70 $ 158.20
SINGAPORE 238164 PW2121 $ 3.60 100 $ 360.00
JL JEND SUDIRMAN KAV.29-31 TW8251 $ 3.80 100 $ 380.00
SLIPI, PALMERAH. PW6161 $ 2.60 65 $ 169.00
OFF AL-FAHIDI STREET TW8251 $ 2.75 75 $ 206.25
23RD FL. GEDUNG WISMA 76 ( WISMA CALINDRA ) PSF256 $ 1.81 100 $ 181.00
WORLD TRADE CENTRE-1 TS1851 $ 2.20 75 $ 165.00
45RD FL. GEDUNG BINAKARNA PW3131 $ 2.26 65 $ 146.90
JL. LET. JEND. S. PARMAN KAV. 341 PW2121 $ 3.60 100 $ 360.00
12TH FLOOR, TW8251 $ 3.80 100 $ 380.00
DUBAI ( U.A.E ) PW6161 $ 2.60 100 $ 260.00
SLIPI, PALMERAH. TW8251 $ 2.75 100 $ 275.00
JL JEND SUDIRMAN KAV.29-31 PSF256 $ 1.81 100 $ 181.00
23RD FL. GEDUNG WISMA 76 ( WISMA CALINDRA ) TS1851 $ 2.20 100 $ 220.00
WORLD TRADE CENTRE-1 PW3131 $ 2.26 65 $ 146.90
JL. LET. JEND. S. PARMAN KAV. 76, TW8251 $ 3.80 65 $ 247.00
BCA TOWER 12TH FLOOR, PW6161 $ 2.60 81 $ 210.60
SINGAPORE POWER BUILDING TW8251 $ 2.75 65 $ 178.75
JL. PINTU KECILL NO.12 RT/RW :002/02 PSF256 $ 1.81 65 $ 117.65
ROA MALAKA-TAMBORA TS1851 $ 2.20 65 $ 143.00
AGUNG TENGAH 4 BLOK 1-2/6A PW3131 $ 2.26 65 $ 146.90
JL. PINTU KECILL NO.12 RT/RW :002/02 PW2121 $ 3.60 65 $ 234.00
JL. RAYA DAAN MOGOT KM 20NO. 43 TW8251 $ 3.80 65 $ 247.00
JL. KRAWANG NO. 1 KEBON WARU PW6161 $ 2.60 65 $ 169.00
JL RAYA KOPO SOREANG KM 11.5 TW8251 $ 2.75 65 $ 178.75
JL. SOEKARNO HATTA NO. 571 PSF256 $ 1.81 65 $ 117.65
JL. KRAWANG NO. 1 KEBON WARU TS1851 $ 2.20 75 $ 165.00
JL RAYA KOPO SOREANG KM 11.5 PW3131 $ 2.26 65 $ 146.90
JL. MEKAR MULYA NO. 33 PW2121 $ 3.60 65 $ 234.00
THE PLAZA OFFICE TOWER LT 25-26 TW8251 $ 3.80 75 $ 285.00
JL. INHOFTANK KOMPLEK JATI PERMAI NO. 56 PW6161 $ 2.60 100 $ 260.00
JL. MEKAR MULYA NO. 33 TW8251 $ 2.75 100 $ 275.00
KOMP. PERGUDANGAN RAWA MELATI, PSF256 $ 1.81 100 $ 181.00
GREENWORTH INTERNATIONAL PTE LTD TS1851 $ 2.20 100 $ 220.00
19TH FLOOR, SUN LIFE TOWER PW3131 $ 2.26 100 $ 226.00
#08 - 03 HIGH STREET PLAZA TW8251 $ 3.80 65 $ 247.00
THE GATEWAY, HARBOUR CITY KOWLOON PW6161 $ 2.60 65 $ 169.00
SINGAPORE POWER BUILDING TW8251 $ 2.75 100 $ 275.00
77 HIGH STREET SINGAPORE PSF256 $ 1.81 65 $ 117.65
JL. M. H. THAMRIN KAV 28-30 TS1851 $ 2.20 65 $ 143.00
Gross Ammout $ 10,450.00
Tax 10%
$ 1,045.00
Nett Ammount $ 9,405.00
Isilah tanggal hari ini dengan menggunakan rumus TODAY/NOW/DATE
Masukan umur karyawan dengan menggunakan rumus
Tanggal Hari Ini: 8/23/2017
Nama Karyawan Tgl Lahir Umur

Agung 3-Dec-76 40
Hercules 4-Oct-81 35
Putra 31-Oct-84 32
Emy 26-Nov-85 31
Susi 14-Jul-86 31
Kuncoro 2-Apr-87 30
Jayanto 26-Jun-74 43
Susan 1-Aug-84 33
Yusuf 18-Sep-81 35
Budi 12-Aug-82 35
Doni 12-Jan-72 45
Sisca 12-Jan-84 33
Yanti 31-May-88 29
Suminah 5-Jun-86 31
Asep 20-Sep-85 31
Yayan 7-Mar-76 41
Eko 4-Sep-70 46
Pedro 6-Jul-83 34
Yaser 6-Nov-86 30
Diego 21-Feb-81 36
Lo Ping San 15-Aug-79 38
Makele 3-Jul-80 37
Isilah kolom yang kosong berdasarkan keterangan di table kuning dengan menggunakan VLOOKUP
Customer Name Code Purshased Item Price

T.G. INTERNATIONAL FSA4A6 ASWL 70/30/0 2/28 DMM DOC 11,000.00
APSARATEX K9630 GHHB 100/0/0 2/28 DMM DOC 6,000.00
INDIAN RAYON & INDUSTRIES OX3017 PPHB 100/0/0 2/28 DMM DOC 12,000.00
G.KALLIS MFRS.LTD PS9532 PPME 70/30/0 2/28 DMM DOC 8,780.00
HOCK JOO PSS597 COWL 85/15/0 1/34 SMM RWH 1,300.00
ROSE E DEE PW6161 TOSW 90/10/0 1/28 DMM DOC 8,400.00
RGF INTERNATIONAL LTD SCRAB TJWL 70/30/0 2/36 SMM RWC 8,400.00
KAYTEE CORPORATION TSF136 COWL 85/15/0 1/28 DMM DOC 16,800.00
H.J.C. (I&E) PRIVATE LTD TWP541 SSFL 60/40/0 2/36 SMM RWH 8,016.00
ITL W5104 SSWH 60/40/0 2/48 SMM RWC 5,000.00
MAHENDER ENT ZI3335 TNWS 80/15/5 1/35 SMM RWH 8,480.00
DESIGN TEX 04G-19 SSTW 70/30/0 1/28 DMM DOC 3,000.00
FAMILY CARE A3508 KFWK 50/50/0 2/28 SMM RWC 1,008.00
GOLDEN COAST BS1346 ENWJ TW 85/10/5 2/28 DMM DOC 8,400.00
BUSALEH TRADING FSA4A6 ASWL 70/30/0 2/28 DMM DOC 11,000.00
GREENWORTH INT'L PTE LTD K9630 GHHB 100/0/0 2/28 DMM DOC 6,000.00
HUESPE E HIJOS OX3017 PPHB 100/0/0 2/28 DMM DOC 12,000.00
DHAFAF DUBAI GENERAL TRAD PS9532 PPME 70/30/0 2/28 DMM DOC 8,780.00
SWEE WAN ENTERPRISES PSS597 COWL 85/15/0 1/34 SMM RWH 1,300.00
PT. ANEKA PRODUKSI NUSAJAYA PW6161 TOSW 90/10/0 1/28 DMM DOC 8,400.00
DADI W5104 SSWH 60/40/0 2/48 SMM RWC 5,000.00
H. IDIN ZI3335 TNWS 80/15/5 1/35 SMM RWH 8,480.00
PT. MIGI PS2831 PPHB 100/0/0 2/28 DMM DOC 12,000.00
WANDI PSS446 PPME 70/30/0 2/28 DMM DOC 8,780.00
PT. GOLDINDO PRIMATAMA SWEATER PW3241 COWL 85/15/0 1/34 SMM RWH 1,300.00
H. YUSRIL SS100 TJWL 70/30/0 2/36 SMM RWC 8,400.00
PT. GUNZE SOCKS INDONESIA TS1681 TJWL 70/30/0 2/36 SMM RWC 8,400.00
KISHOR TRADERS BS1346 ENWJ TW 85/10/5 2/28 DMM DOC 8,400.00
RATTI FSA4A6 ASWL 70/30/0 2/28 DMM DOC 11,000.00
LUCKY TEXTILE K9630 GHHB 100/0/0 2/28 DMM DOC 6,000.00
AL KHANBASHI OX3017 PPHB 100/0/0 2/28 DMM DOC 12,000.00
GREENWORTH INT'L PTE LTD PS9532 PPME 70/30/0 2/28 DMM DOC 8,780.00
HOCK JOO PSS597 COWL 85/15/0 1/34 SMM RWH 1,300.00
GULF UNION PW6161 TOSW 90/10/0 1/28 DMM DOC 8,400.00
AL JEDAIE SCRAB TJWL 70/30/0 2/36 SMM RWC 8,400.00
SMART GARMENT 04G-19 SSTW 70/30/0 1/28 DMM DOC 3,000.00
DAFFAH A3508 KFWK 50/50/0 2/28 SMM RWC 1,008.00
ABD.GFFAR RAHEEM ANDIGANI BS1346 ENWJ TW 85/10/5 2/28 DMM DOC 8,400.00
MAGADAN S.A. FSA4A6 ASWL 70/30/0 2/28 DMM DOC 11,000.00
PT.SERASI ADIBUSANA K9630 GHHB 100/0/0 2/28 DMM DOC 6,000.00
TIEMME S.R.L OX3017 PPHB 100/0/0 2/28 DMM DOC 12,000.00
LA OPERA PS9532 PPME 70/30/0 2/28 DMM DOC 8,780.00
ALMACENES RODRIGUES ZI3335 TNWS 80/15/5 1/35 SMM RWH 8,480.00
ALMACENES SANTIAGO PS2831 PPHB 100/0/0 2/28 DMM DOC 12,000.00
GALERIA DUMIT PSS446 PPME 70/30/0 2/28 DMM DOC 8,780.00
AL HUR PW3241 COWL 85/15/0 1/34 SMM RWH 1,300.00
PT.THAI INTERNATIONAL STA SS100 TJWL 70/30/0 2/36 SMM RWC 8,400.00
YOUSUF BROTHERS TS1681 TJWL 70/30/0 2/36 SMM RWC 8,400.00
MUZAREH PSS446 PPME 70/30/0 2/28 DMM DOC 8,780.00
AHMED SHARAFI & PARTNERS BS1346 ENWJ TW 85/10/5 2/28 DMM DOC 8,400.00
SINA TEX EXB FSA4A6 ASWL 70/30/0 2/28 DMM DOC 11,000.00
JOHN RAINGER K9630 GHHB 100/0/0 2/28 DMM DOC 6,000.00
CHYANG SHENG OX3017 PPHB 100/0/0 2/28 DMM DOC 12,000.00
NOOR TALIB PS9532 PPME 70/30/0 2/28 DMM DOC 8,780.00
DAVID COOPER PSS597 COWL 85/15/0 1/34 SMM RWH 1,300.00
DE'LA MINS SDN. BERHAD. PW6161 TOSW 90/10/0 1/28 DMM DOC 8,400.00
LAMONIQUE 04G-19 SSTW 70/30/0 1/28 DMM DOC 3,000.00
AL KESAYI A3508 KFWK 50/50/0 2/28 SMM RWC 1,008.00
AL AYADI BS1346 ENWJ TW 85/10/5 2/28 DMM DOC 8,400.00
FFF AJLAN FSA4A6 ASWL 70/30/0 2/28 DMM DOC 11,000.00
AL BASAM K9630 GHHB 100/0/0 2/28 DMM DOC 6,000.00
OTTO KAUF OX3017 PPHB 100/0/0 2/28 DMM DOC 12,000.00
NAJMA AL-AGAR PS9532 PPME 70/30/0 2/28 DMM DOC 8,780.00
ABDULLAH ABDUL AAL PSS597 COWL 85/15/0 1/34 SMM RWH 1,300.00
ABDUL RAHMAN PW6161 TOSW 90/10/0 1/28 DMM DOC 8,400.00
BROMLEY WEAR CLOTHING LTD SCRAB TJWL 70/30/0 2/36 SMM RWC 8,400.00
QUALITEX TSF136 COWL 85/15/0 1/28 DMM DOC 16,800.00
TEXTILE W TWP541 SSFL 60/40/0 2/36 SMM RWH 8,016.00
KEWALRAM W5104 SSWH 60/40/0 2/48 SMM RWC 5,000.00
AL KASIM ZI3335 TNWS 80/15/5 1/35 SMM RWH 8,480.00
LA ISABELLA PS2831 PPHB 100/0/0 2/28 DMM DOC 12,000.00
FLORIDA TEXTILES PSS446 PPME 70/30/0 2/28 DMM DOC 8,780.00
BAHWAL PW3241 COWL 85/15/0 1/34 SMM RWH 1,300.00
AL AWADI SS100 TJWL 70/30/0 2/36 SMM RWC 8,400.00
AL JADABI TS1681 TJWL 70/30/0 2/36 SMM RWC 8,400.00
NIMER TSF136 COWL 85/15/0 1/28 DMM DOC 16,800.00
JACKAL TWP541 SSFL 60/40/0 2/36 SMM RWH 8,016.00
MSM HOLDING PTE LTD W5104 SSWH 60/40/0 2/48 SMM RWC 5,000.00
SHELLAL ZI3335 TNWS 80/15/5 1/35 SMM RWH 8,480.00
KAKOLI PS2831 PPHB 100/0/0 2/28 DMM DOC 12,000.00
BLD PSS446 PPME 70/30/0 2/28 DMM DOC 8,780.00
BINYAMEEN PW3241 COWL 85/15/0 1/34 SMM RWH 1,300.00
VICKY'S TRADING SS100 TJWL 70/30/0 2/36 SMM RWC 8,400.00
STUNCROFT LTD TS1681 TJWL 70/30/0 2/36 SMM RWC 8,400.00
ARTISTIC FINE A3508 KFWK 50/50/0 2/28 SMM RWC 1,008.00
CHINA INDUSTRIAL MATERIAL BS1346 ENWJ TW 85/10/5 2/28 DMM DOC 8,400.00
AL SALMAN FSA4A6 ASWL 70/30/0 2/28 DMM DOC 11,000.00
PETER DREW CONTRACT K9630 GHHB 100/0/0 2/28 DMM DOC 6,000.00
PT MITSUI SHOJI INDOTAMA OX3017 PPHB 100/0/0 2/28 DMM DOC 12,000.00
KUTUBALDIN PS9532 PPME 70/30/0 2/28 DMM DOC 8,780.00
TOGAR PSS597 COWL 85/15/0 1/34 SMM RWH 1,300.00
MERENGUE 04G-19 SSTW 70/30/0 1/28 DMM DOC 3,000.00
SALIM AL QATAR A3508 KFWK 50/50/0 2/28 SMM RWC 1,008.00
AL HALAFI BS1346 ENWJ TW 85/10/5 2/28 DMM DOC 8,400.00
YOUSUF A.L. AL ATEEQI FSA4A6 ASWL 70/30/0 2/28 DMM DOC 11,000.00
PT.CITA HAWARD GARMINDO K9630 GHHB 100/0/0 2/28 DMM DOC 6,000.00
AL HAMEED EST OX3017 PPHB 100/0/0 2/28 DMM DOC 12,000.00
CONFECCIONES BOSTON PS9532 PPME 70/30/0 2/28 DMM DOC 8,780.00
LORATEX TSF136 COWL 85/15/0 1/28 DMM DOC 16,800.00
REGAL TRADERS TWP541 SSFL 60/40/0 2/36 SMM RWH 8,016.00
GEM TRADING CO. W5104 SSWH 60/40/0 2/48 SMM RWC 5,000.00
LULU FURNITURE ZI3335 TNWS 80/15/5 1/35 SMM RWH 8,480.00
LAWMAN PS2831 PPHB 100/0/0 2/28 DMM DOC 12,000.00
DKNY PSS446 PPME 70/30/0 2/28 DMM DOC 8,780.00
AL MAUDY PW3241 COWL 85/15/0 1/34 SMM RWH 1,300.00
PT.TRISULA GARMINDO MANUFACTURING SS100 TJWL 70/30/0 2/36 SMM RWC 8,400.00
ABU HAMAD TS1681 TJWL 70/30/0 2/36 SMM RWC 8,400.00
Kode Name Price/Unit
04G-19 SSTW 70/30/0 1/28 DMM DOC 3,000.00
A3508 KFWK 50/50/0 2/28 SMM RWC 1,008.00
BS1346 ENWJ TW 85/10/5 2/28 DMM DOC 8,400.00
FSA4A6 ASWL 70/30/0 2/28 DMM DOC 11,000.00
K9630 GHHB 100/0/0 2/28 DMM DOC 6,000.00
OX3017 PPHB 100/0/0 2/28 DMM DOC 12,000.00
PS9532 PPME 70/30/0 2/28 DMM DOC 8,780.00
PSS597 COWL 85/15/0 1/34 SMM RWH 1,300.00
PW6161 TOSW 90/10/0 1/28 DMM DOC 8,400.00
SCRAB TJWL 70/30/0 2/36 SMM RWC 8,400.00
TSF136 COWL 85/15/0 1/28 DMM DOC 16,800.00
TWP541 SSFL 60/40/0 2/36 SMM RWH 8,016.00
W5104 SSWH 60/40/0 2/48 SMM RWC 5,000.00
ZI3335 TNWS 80/15/5 1/35 SMM RWH 8,480.00
PS2831 PPHB 100/0/0 1/28 SMM RWC 1,985.00
PSS446 GHHB-Regular-DOC-R 7,008.00
PW3241 CLHB-Regular-DOC-S 8,616.00
SS100 PKHB-Regular-DOC-R 1,496.00
TS1681 ENWJ-Regular-DOC-W 9,912.00
Berikut adalah data penjualan PT. Senang Bahagia
Pada kolom keterangan berisi data apakah customer tersebut mendapat diskon atau tidak.
Isi kolom Keterangan dengan menggunakan rumus, dengan ketentuan :

Jika qty pembelian lebih dari 66, maka akan mendapat DISKON
Jika kurang dari 66, maka NORMAL
Jika qty lebih dari 99, maka akan mendapatkan SPECIAL
Jika Special Price, maka tambahkan pada cell tersebut dengan Conditional Formating-->
Customer Qty Keterangan

MAZALOSA 65 NORMAL
YAGMOUR 75 DISKON
SK TEXTILE 65 NORMAL
GEFA I TRANAMO 75 DISKON
JALEEL 100 SPECIAL
CARRY WEALTH LIMITED 100 SPECIAL
ALKARAM 100 SPECIAL
LIVELY LAD 70 DISKON
DESMOND MERCURY (PVT) LTD 100 SPECIAL
CEYLON KNIT TREND LTD 100 SPECIAL
AL KHANBASHI 65 NORMAL
CITEX WEAGAN MACPHERSON 75 DISKON
ADEL SALEH 100 SPECIAL
PLATINO 75 DISKON
BRIGHT GARMENT LTD 100 SPECIAL
KABUL TEXTILE 100 SPECIAL
ABU SUFION 100 SPECIAL
KHALID MALIK 120 SPECIAL
PHUONG DONG GARMENT 100 SPECIAL
TARS 100 SPECIAL
AMEDE BEFEKADU 100 SPECIAL
SEYOUM 65 NORMAL
MICRODENIER 65 NORMAL
FIFTH AVENUE 65 NORMAL
MATYAS 81 DISKON
ASIPEK 65 NORMAL
FASHION TEXTILE 65 NORMAL
UNITED GARMENTS 65 NORMAL
ESCO LTD 65 NORMAL
CONTINENTAL FASHION 65 NORMAL
MUSLEH TRADING CO 65 NORMAL
MEDHI STORE 65 NORMAL
NEPGREN 65 NORMAL
MEDHI STORE 65 NORMAL
AL MUSELEM 75 DISKON
COLLECTION DESIGN GROUP 65 NORMAL
AL DIRA 65 NORMAL
DUMIT 75 DISKON
PT. GALAYA MULIA SARANA 100 SPECIAL
BLOSSOM 100 SPECIAL
KAILASH TRADING LLC 100 SPECIAL
CV.INMOR TAMA 100 SPECIAL
KALPANA 100 SPECIAL
MARBUTTI 100 SPECIAL
AL TAMIMI 65 NORMAL
BAHWAL BRANCH 65 NORMAL
DAHAN 100 SPECIAL
AL AWANI 100 SPECIAL
M.BAKERMOON 65 NORMAL
OK AL ESAYI 75 DISKON
SHALIMAR 65 NORMAL
AL AINE 100 SPECIAL
AL OWAIS 100 SPECIAL
ABU SALEH 100 SPECIAL
AL ESSA 65 NORMAL
A.F AJLAN 65 NORMAL
GOLDEN ARCH 75 DISKON
GULFAR 100 SPECIAL
SULTAN 100 SPECIAL
EMKAY 100 SPECIAL
HEERO'S 150 SPECIAL
PT.NIKAWA TEXTILE IND. 100 SPECIAL
MASTINA 100 SPECIAL
NORMAN BUCK 100 SPECIAL
PT.PRIMA MANDIRI INTISENTOSA 100 SPECIAL
AL FAIHA 100 SPECIAL
RAHMANI 65 NORMAL
GARTEX 65 NORMAL
MUSSALAM 65 NORMAL
PT. CENTURY TEXTILE INDUSTRY TBK 100 SPECIAL
PRESTIGE CLOTHING 65 NORMAL
AL KHARAM 65 NORMAL
BAHAMIL 65 NORMAL
MIDO INDONESIA 65 NORMAL
RAJA BUSANA MAHAMERU 65 NORMAL
UNIFORM PLUS 65 NORMAL
PT.BUANA MAKMUR MAJU ABAD 65 NORMAL
UD. WALET 65 NORMAL
TOMEN GERMAN 81 DISKON
FROST TEXTILE LTD 65 NORMAL
PIETRI 72 DISKON
AMBA TEXTILE 72 DISKON
HUSSAIN ALI HASAN 65 NORMAL
PT.ACRYL TEXTILE MILLS 65 NORMAL
TORRE 65 NORMAL
NATAFGI 65 NORMAL
HAMAD AL YAHYA 65 NORMAL
ARJAY TRADING 65 NORMAL
PT.CEMARA CITRA INDOGARMI 65 NORMAL
PT. OST FIBRE INDUSTRIES 65 NORMAL
ESSA GHULOOM 65 NORMAL
MORAL TRADING 65 NORMAL
PT. DAESE GARMIN 65 NORMAL
AL WAROOD 65 NORMAL
KOPERASI PT. ISTEM 65 NORMAL
AL WASEEF 65 NORMAL
ELGO 65 NORMAL
TEJICA 65 NORMAL
ABUSAFI 65 NORMAL
TORAY INTERNATIONAL SINGAPORE 65 NORMAL
TIKSATEX 65 NORMAL
WOOL WORLD EST. 65 NORMAL
ABDUL MAJEED A.A. SAIF 65 NORMAL
TRITHON SA. 65 NORMAL
VENTURE INTERNATIONAL 65 NORMAL
TIGAR HARTATO/PD.SUPRATEX 65 NORMAL
AL-SAIKHAN 65 NORMAL
ALSHAMTEX 65 NORMAL
PT.HIROTA INDONESIA 65 NORMAL
SAVILLE HEATON 65 NORMAL
TEJICA 65 NORMAL
LUCKY TEXTILE 65 NORMAL
JOTTA ENTERPRISE 65 NORMAL
RABOO ALFAIHA 65 NORMAL
AL QATTAN 65 NORMAL
PT.TRIMAS 65 NORMAL
AL HUMAID EST 65 NORMAL
KASMON 65 NORMAL
FIRST CHOICE 65 NORMAL
AN PHUOC 65 NORMAL
AHMED ALI IBRAHIM 65 NORMAL
AL MISBAHI 65 NORMAL
UNIFORM MANAGEMENT SERVICES PTY LTD 65 NORMAL
GOLDEN MEASURE 65 NORMAL
CYC SHANGHAI 65 NORMAL
NISHJEET TRADERS LLC 65 NORMAL
MOHAMMED SIDDIQ AND MOHD. AQEEL TAW 65 NORMAL
MEKONNEN DEMISSIE 65 NORMAL
DAFAF 110 SPECIAL
JABAL AL ARAB TRDG 65 NORMAL
PT.SURYA SATRIA YUDHAKARSA 65 NORMAL
PD. SEMANGAT BARU 65 NORMAL
PD. SEMANGAT BARU 65 NORMAL
PT. RUKUN CITRA SEJATI 65 NORMAL
AYADI INTERNATIONAL 65 NORMAL
ALATTAS 65 NORMAL
AL SAILAMI 65 NORMAL
AL HASSINI 65 NORMAL
AL MARZOUKI 65 NORMAL
MUSALEH TRADING 65 NORMAL
M ASSAGAF 65 NORMAL
AL KHALIDY 65 NORMAL
MM SAEED 65 NORMAL
DEMISSIE DIBABA 75 DISKON
NEGUSSIE SEYOUM 65 NORMAL
ALEMAHEYU SEYOUM 65 NORMAL
PT.TAE YUNG INDONESIA 75 DISKON
SELDEX 65 NORMAL
ADEL KAREEM 65 NORMAL
DANDELION'S 65 NORMAL
AFRAH 75 DISKON
ASSAGAF 75 DISKON
ABDI ABDULLA SALEH ASALY 65 NORMAL
M.A. AL GAITH 65 NORMAL
ROBOO AL FAIHA 65 NORMAL
NAJAR BAGIS 65 NORMAL
ABDUL M WASE 65 NORMAL
SELAMAWIT TESFAYE 65 NORMAL
REDHA TRADERS 65 NORMAL
PT. WOVEN MULTI USAHA 65 NORMAL
TRIMAS SARANA GARMENT INDUSTRY 84 DISKON
AL HORAIBI 81 DISKON
ABDULLAH AHMAD ALASFOOR + CO 72 DISKON
BAKADAM 76 DISKON
M/S ELON P.L.C 65 NORMAL
SUWANTO LUKMAN 81 DISKON
NARAINDAS BHAGWANDAS 81 DISKON
JADE CORPORATE WEAR 65 NORMAL
AN PHUOC GARMENT 65 NORMAL
YUSUF OBAID 90 DISKON
VIETTIEN 65 NORMAL
P.T.HOPERINDO PRIMA 65 NORMAL
PT. PRIMATAMA BUSINDO 65 NORMAL
ASB EST-NAJRAN 80 DISKON
ABU WALEED 65 NORMAL
AKRAM SHAWOSH 65 NORMAL
MEHDI STORE 72 DISKON
ABDULLAH MOHAMMAD SAUD 97 DISKON
ALTIMO CLOTHING COMPANY 81 DISKON
ABDULRAHMAN YAHYA MUNSHI EST. 64 NORMAL
M/S. ABDULLAH GAED AL-KHALIDY EST 65 NORMAL
P.T. SIMRAN JAYA 65 NORMAL
PT. PRIMATAMA BUSINDO 65 NORMAL
RAJU MAMA 65 NORMAL
OMER KASSEM AL ESAYI TEXTILE CO.LTD 65 NORMAL
PT. MANNA PRATAMA SANTOSA 65 NORMAL
PT. PRONTO MODA 75 DISKON
MONTGOMERY TEXTILE PTY LIMITED 65 NORMAL
ADNAN OMAR BASALAMAH EST 130 SPECIAL
BIN HILABI 100 SPECIAL
EVE FABRIC 100 SPECIAL
PT.ADHIKARYA SURYA JAYA 100 SPECIAL
P.T.SURYA PRASETYA TEKSTIL INDUSTRI 70 DISKON
JAVIER MARTIN 100 SPECIAL
SUPER TREND HOUSE 100 SPECIAL
NAJEEM 65 NORMAL
AL YAMANI 75 DISKON
BAGAIS 100 SPECIAL
OMEER IBRAHIM KHAWAJI 75 DISKON
DIM-LIGHT 100 SPECIAL
KG OSAKA 100 SPECIAL
ICHIMURA SANGYO CO.,LTD 100 SPECIAL
AL KAHWAJI 100 SPECIAL
ACTION CRAFT FASHION LTD 100 SPECIAL
ADEL KAREEM 100 SPECIAL
REGENT 100 SPECIAL
ABUL HASAN 65 NORMAL
PT.MITRA SELARAS SEMPURNA 65 NORMAL
PT. FIT-U GARMENT INDUSTRIES 65 NORMAL
PT.BENUA HAMPARAN LUAS 81 DISKON
GOLDEN MEASURE 65 NORMAL
NAJAM AL AGHAR 65 NORMAL
THAI TORAY TEXTILE MILLS PUBLIC CO.,LTD 65 NORMAL
AYNALEM GERU 65 NORMAL
PT. SLIONTEC EKADHARMA INDONESIA 140 SPECIAL
AYESH AL-KHALIFA 65 NORMAL
YASIN SALMAN 65 NORMAL
PT. MIDO INDONESIA 65 NORMAL
RAHIM 65 NORMAL
Contoh :
Customer Qty Keterangan
MAZALOSA 65 NORMAL
YAGMOUR 75 DISKON
SK TEXTILE 65 NORMAL
GEFA I TRANAMO 75 DISKON
JALEEL 100 SPECIAL
CARRY WEALTH LIMITED 100 SPECIAL
ALKARAM 100 SPECIAL
LIVELY LAD 70 DISKON
DESMOND MERCURY (PVT) LTD 100 SPECIAL
CEYLON KNIT TREND LTD 100 SPECIAL
Berikut adalah Data Penjualan PT. Suka Sama Suka, yang diurutkan berdasarkan tanggal
Namun terdapat kesalahan nama customer, yaitu :
Tertulis Seharusnya
PT CENTRINO MODIS PT CENTRINO MODIS
TOMOSATSU MORITA TOMOSATSU MORITA
AL ZARA AL ZARA
I.M.S I.M.S
Anda diminta untuk :

1. Ubahlah setiap kesalahan nama yang terdapat dalam tabel penjualan menggunakan FIND-REPLACE
2. Ganti format penulisan tanggal menjadi dd/mm/yyyy (Misalnya 17-Agt-1945)
Data Penjualan PT. Suka Sama Suka
Tanggal Pembelian Nama Customer

8-Feb-12 PT. SUSILIA INDAH SYNTHETIC FIBERS INDUSTRIES
28-Feb-12 OLGA PONT-FICE
8-Mar-12 BEAURICH GARMENT FACTORY LIMITED
12-Mar-12 TORRE CONFECCOES
14-Mar-12 PT. BINTANG MAS APPARELINDO
14-Mar-12 PT. ITOCHU INDONESIA
19-Mar-12 DOWD
19-Mar-12 AMANAH CORP.
19-Mar-12 SUWANTO LUKMAN
19-Mar-12 AL ZARA
19-Mar-12 HADI ISWANTO
19-Mar-12 PT. CAKRAPERKASA TUNASJAYA
19-Mar-12 OXFORD CLOTHING
22-Mar-12 SOLOMON TADESSE
22-Mar-12 I.M.S
26-Mar-12 AKMAL MALIK OEI
26-Mar-12 AL ZARA
26-Mar-12 HADI ISWANTO
27-Mar-12 OXFORD SCHOOL UNIFORMS
27-Mar-12 PT. ANUGERAH GEMILANG KURNIA
13-Apr-12 AKBAR GARMENT
13-Apr-12 CV. JAYA INDAH MAKMUR
27-Apr-12 JAWAD BUSALEH
27-Apr-12 YUSUF OBAID
30-Apr-12 AL NOOR
30-Apr-12 PT. CAKRAPERKASA TUNASJAYA
8-May-12 PT. INDHIRA JALA SUTERA
8-May-12 PT. KURITA INDONESIA
8-May-12 TOMOSATSU MORITA
8-May-12 TRANS STARS TRADING
18-May-12 SHISHI AURO-PARK FASHION DEVELOPMENT CO.
18-May-12 PT CENTRINO MODIS
21-May-12 PT. LESTARI SURYA ABADI
21-May-12 OXFORD CLOTHING
21-May-12 AKMAL MALIK OEI
21-May-12 OXFORD SCHOOL UNIFORMS
21-May-12 PT. ANUGERAH GEMILANG KURNIA
25-May-12 AKBAR GARMENT
30-May-12 SCHOOL GEAR
30-May-12 CV. JAYA INDAH MAKMUR
4-Jun-12 PT. BINTANG MAS APPARELINDO
5-Jun-12 PT. SUSILIA INDAH SYNTHETIC FIBERS INDUSTRIES
5-Jun-12 PT. ITOCHU INDONESIA
5-Jun-12 SOLOMON TADESSE
5-Jun-12 I.M.S
5-Jun-12 OLGA PONT-FICE
5-Jun-12 TORRE CONFECCOES
5-Jun-12 DOWD
5-Jun-12 AMANAH CORP.
5-Jun-12 SUWANTO LUKMAN
5-Jun-12 AL ZARA
5-Jun-12 HADI ISWANTO
5-Jun-12 PT. CAKRAPERKASA TUNASJAYA
5-Jun-12 OXFORD CLOTHING
6-Jun-12 JAWAD BUSALEH
7-Jun-12 AKMAL MALIK OEI
7-Jun-12 OXFORD SCHOOL UNIFORMS
7-Jun-12 BEAURICH GARMENT FACTORY LIMITED
7-Jun-12 I.M.S
11-Jun-12 PT. ANUGERAH GEMILANG KURNIA
11-Jun-12 PT. INDHIRA JALA SUTERA
11-Jun-12 TOMOSATSU MORITA
12-Jun-12 AKBAR GARMENT
12-Jun-12 CV. JAYA INDAH MAKMUR
14-Jun-12 AL NOOR
14-Jun-12 PT CENTRINO MODIS
14-Jun-12 PT. LESTARI SURYA ABADI
14-Jun-12 SCHOOL GEAR
14-Jun-12 JAWAD BUSALEH
14-Jun-12 DOWD
15-Jun-12 PT. KURITA INDONESIA
15-Jun-12 TOMOSATSU MORITA
18-Jun-12 TRANS STARS TRADING
18-Jun-12 I.M.S
19-Jun-12 SHISHI AURO-PARK FASHION DEVELOPMENT CO.
19-Jun-12 AL ZARA
21-Jun-12 PT. SUSILIA INDAH SYNTHETIC FIBERS INDUSTRIES
21-Jun-12 DOWD
22-Jun-12 YUSUF OBAID
22-Jun-12 YUSUF OBAID
25-Jun-12 I.M.S
25-Jun-12 PT. KURITA INDONESIA
25-Jun-12 AL ZARA
25-Jun-12 AL ZARA
29-Jun-12 PT. ANUGERAH GEMILANG KURNIA
29-Jun-12 AKBAR GARMENT
1-Jul-12 PT. ANUGERAH GEMILANG KURNIA
2-Jul-12 TORRE CONFECCOES
2-Jul-12 DOWD
2-Jul-12 HADI ISWANTO
2-Jul-12 AKBAR GARMENT
3-Jul-12 PT. CAKRAPERKASA TUNASJAYA
3-Jul-12 OXFORD CLOTHING
3-Jul-12 AKMAL MALIK OEI
3-Jul-12 OXFORD SCHOOL UNIFORMS
3-Jul-12 CV. JAYA INDAH MAKMUR
4-Jul-12 AL NOOR
4-Jul-12 AL NOOR
5-Jul-12 OLGA PONT-FICE
5-Jul-12 AMANAH CORP.
5-Jul-12 SUWANTO LUKMAN
5-Jul-12 PT. INDHIRA JALA SUTERA
5-Jul-12 PT. LESTARI SURYA ABADI
5-Jul-12 SCHOOL GEAR
5-Jul-12 AL NOOR
5-Jul-12 PT. KURITA INDONESIA
5-Jul-12 TOMOSATSU MORITA
5-Jul-12 TRANS STARS TRADING
5-Jul-12 SHISHI AURO-PARK FASHION DEVELOPMENT CO.
6-Jul-12 PT CENTRINO MODIS
10-Jul-12 PT. SUSILIA INDAH SYNTHETIC FIBERS INDUSTRIES
10-Jul-12 YUSUF OBAID
12-Jul-12 JAWAD BUSALEH
12-Jul-12 BEAURICH GARMENT FACTORY LIMITED
16-Jul-12 PT. BINTANG MAS APPARELINDO
16-Jul-12 PT. ITOCHU INDONESIA
16-Jul-12 AL ZARA
17-Jul-12 SOLOMON TADESSE
17-Jul-12 I.M.S
17-Jul-12 DOWD
17-Jul-12 PT. BINTANG MAS APPARELINDO
18-Jul-12 AL NOOR
18-Jul-12 PT. ITOCHU INDONESIA
19-Jul-12 SOLOMON TADESSE
20-Jul-12 I.M.S
23-Jul-12 DOWD
25-Jul-12 AL NOOR
26-Jul-12 AL ZARA
1-Aug-12 PT. ANUGERAH GEMILANG KURNIA
2-Aug-12 AKBAR GARMENT
3-Aug-12 CV. JAYA INDAH MAKMUR
4-Aug-12 AL NOOR
5-Aug-12 PT. INDHIRA JALA SUTERA
6-Aug-12 PT. KURITA INDONESIA
7-Aug-12 TOMOSATSU MORITA
8-Aug-12 AL ZARA
9-Aug-12 HADI ISWANTO
10-Aug-12 PT. CAKRAPERKASA TUNASJAYA
11-Aug-12 OXFORD CLOTHING
12-Aug-12 AKMAL MALIK OEI
13-Aug-12 OXFORD SCHOOL UNIFORMS
14-Aug-12 PT. ANUGERAH GEMILANG KURNIA
15-Aug-12 AKBAR GARMENT
16-Aug-12 CV. JAYA INDAH MAKMUR
17-Aug-12 AL NOOR
18-Aug-12 PT. INDHIRA JALA SUTERA
19-Aug-12 PT. KURITA INDONESIA
20-Aug-12 TOMOSATSU MORITA
21-Aug-12 TRANS STARS TRADING
22-Aug-12 SHISHI AURO-PARK FASHION DEVELOPMENT CO.
23-Aug-12 PT CENTRINO MODIS
24-Aug-12 PT. LESTARI SURYA ABADI
25-Aug-12 SCHOOL GEAR
26-Aug-12 PT. SUSILIA INDAH SYNTHETIC FIBERS INDUSTRIES
27-Aug-12 JAWAD BUSALEH
28-Aug-12 YUSUF OBAID
29-Aug-12 BEAURICH GARMENT FACTORY LIMITED
30-Aug-12 PT. BINTANG MAS APPARELINDO
31-Aug-12 PT. ITOCHU INDONESIA
1-Sep-12 SOLOMON TADESSE
2-Sep-12 I.M.S
3-Sep-12 OLGA PONT-FICE
4-Sep-12 TORRE CONFECCOES
5-Sep-12 DOWD
6-Sep-12 AMANAH CORP.
7-Sep-12 SUWANTO LUKMAN
8-Sep-12 AL ZARA
9-Sep-12 HADI ISWANTO
10-Sep-12 PT. CAKRAPERKASA TUNASJAYA
11-Sep-12 OXFORD CLOTHING
12-Sep-12 AKMAL MALIK OEI
13-Sep-12 OXFORD SCHOOL UNIFORMS
14-Sep-12 PT. ANUGERAH GEMILANG KURNIA
15-Sep-12 AKBAR GARMENT
16-Sep-12 CV. JAYA INDAH MAKMUR
17-Sep-12 AL NOOR
18-Sep-12 PT. INDHIRA JALA SUTERA
19-Sep-12 PT. KURITA INDONESIA
20-Sep-12 TOMOSATSU MORITA
Gambar dibawah ini terlalu besar. Kecil kan size gambar dibawah ini agar size nya lbh ringan, tanpa merubah ukuran gamba
merubah ukuran gambar
Dibawah ini adalah data penjualan PT. XYZ. Suatu ketika, manager perusahaan PT. XYZ ingin melihat transaksi penjualan ole
Filterkan transaksi penjualan yang dilakukan oleh PT LESTARI SURYA ABADI saja
Tanggal Pembelian Nama Customer Qty

21-May-2012 PT. LESTARI SURYA ABADI 65
5-Jul-2012 PT. LESTARI SURYA ABADI 100
14-Jun-2012 PT. LESTARI SURYA ABADI 65
24-Aug-2012 PT. LESTARI SURYA ABADI 100
melihat transaksi penjualan oleh PT LESTARI SURYA ABADI saja.
Gabungkan kolom Address 1 - 4 ke dalam kolom Full Address dengan memakai fungsi yang tepat
Address 1 Address 2
23RD FL. GEDUNG WISMA 76 ( WISMA CALINDRA ) JL. LET. JEND. S. PARMAN KAV. 76,
111 SOMMERSET RD., #14-01 DEVONSHIRE WING SINGAPORE POWER BUILDING
WORLD TRADE CENTRE-1 12TH FLOOR,
OFF AL-FAHIDI STREET P.O. BOX 51370
275 YOUNG ST., WATERLOO NSW, AUSTRALIA
MID PLAZA 1, 4TH FLOOR JL JEND SUDIRMAN KAV.10-11
GREENWORTH INTERNATIONAL PTE LTD #08 - 03 HIGH STREET PLAZA
19TH FLOOR, SUN LIFE TOWER THE GATEWAY, HARBOUR CITY KOWLO
3-6 BINGOMACHI, 2-CHOME CHUO-KU, OSAKA 541
GREENWORTH INTERNATIONAL PTE LTD #08 - 03 HIGH STREET PLAZA
WISMA STANDARD CHARTERED BANK, 15TH FLOOR JL JEND SUDIRMAN KAV.33A
JL. PINTU KECILL NO.12 RT/RW :002/02 ROA MALAKA-TAMBORA
JL. PINTU KECIL NO. 17 JAKARTA BARAT
JL. KP. BASMOL RT. 07 RW. 06 NO. 7 KEMBANGAN, JAKARTA BARAT 11610
JL. PINTU KECIL NO 28 ROA MALAKA-TAMBORRA
JL. MANGGA DUA C2/5 JAKARTA UTARA
JL. PETAK BARU NO. 5 ROA MALAKA
JL. PETAK BARU NO.5 JAKARTA
AGUNG TENGAH 4 BLOK 1-2/6A SUNTER AGUNG
JL. RAYA DAAN MOGOT KM 20NO. 43 BATUCEPER, TANGERANG
JL. PINTU KECIL NO 28 ROA MALAKA-TAMBORRA
JL.PINTU KECIL NO.57C, ROA MALAKA TAMBORA JAKARTA BARAT - 11230
JL. RAYA DAAN MOGOT KM 20NO. 43 BATUCEPER, TANGERANG
VIKAMAS TIMUR 1-B NO. 9 RT.006 RW.005, KAPUK MUAR PENJARINGAN JAKARTA UTARA
JL. KRAWANG NO. 1 KEBON WARU BATUNUNGGAL BANDUNG
JL. MEKAR MULYA NO. 33 CIPADUNG KULON, CIBIRU
SUMMITMAS II LT. 3 JL. JEND. SUDIRMAN KAV. 61-62
JL. BANTEN NO. 5 - 7 KEBONWARU-BATUNUNGGAL
JL. BANTEN NO. 5 - 7 KEBONWARU-BATUNUNGGAL
JL RAYA KOPO SOREANG KM 11.5 CILAMPENI KATAPANG
JL. SOEKARNO HATTA NO. 571 BANDUNG
JL RAYA KOPO SOREANG KM 11.5 CILAMPENI KATAPANG
THE PLAZA OFFICE TOWER LT 25-26 JL. M. H. THAMRIN KAV 28-30
JL. INHOFTANK KOMPLEK JATI PERMAI NO. 56 PELINDUNG HEWAN
JL.RAYA KOPO SOREANG KM 11,5 CILAMPENI KATAPAN KABUPATEN BANDUNG
JL.RAYA KOPO SOREANG KM 11,5 CILAMPENI KATAPAN KABUPATEN BANDUNG
KOMP. PERGUDANGAN RAWA MELATI, JL. KAPUK KAMAL, KAYU BESAR 3
memakai fungsi yang tepat
Address 3 Address 4
SLIPI, PALMERAH. JAKARTA 11410
SINGAPORE 238164
JL JEND SUDIRMAN KAV.29-31 JAKARTA
DUBAI ( U.A.E )
DUBAI ( U.A.E )
DUBAI ( U.A.E )
DUBAI ( U.A.E )
SINGAPORE 238164
SINGAPORE 238164
DUBAI ( U.A.E )
SINGAPORE 238164
DUBAI ( U.A.E )
JAKARTA 10220, INDONESIA
77 HIGH STREET SINGAPORE
HONG KONG
SINGAPORE 238164
DUBAI ( U.A.E )
SINGAPORE 238164
SINGAPORE 238164
JAPAN
JAPAN
JAPAN
JAKARTA 10220 INDONESIA
DUBAI ( U.A.E )
JAKARTA BARAT-11230
JAKARTA BARAT-11230
JAKARTA BARAT-11230
JAKARTA BARAT-11230
JAKARTA BARAT-11230
JAKARTA BARAT-11230
JAKARTA BARAT-11230
JAKARTA BARAT
JAKARTA BARAT
JAKARTA BARAT-11230
JAKARTA BARAT-11230
JAKARTA BARAT-11230
TANJUNG PRIOK JAKARTA UTARA

JAKARTA BARAT
JAKARTA BARAT
JAKARTA BARAT

JAKARTA BARAT-11230
JAKARTA BARAT-11230
JAKARTA BARAT-11230
JAKARTA BARAT
JAKARTA BARAT-11230
JAKARTA BARAT-11230
JAKARTA BARAT-11230
JAKARTA BARAT-11230
JAKARTA BARAT
JAKARTA BARAT
JAKARTA BARAT-11230
JAKARTA BARAT-11230
DKI JAKARTA
JAKARTA BARAT
JAKARTA BARAT-11230

JAWA BARAT
BANDUNG
JAKARTA
BANDUNG
BANDUNG
JAWA BARAT
BANDUNG
JAWA BARAT
BANDUNG
BANDUNG
JAKARTA 10350
ASTANA ANYAR BANDUNG
BANDUNG
BANDUNG
BANDUNG
BANDUNG
BLOK M 12 NO. 1, KEL. TEGAL ALUR, JAKARTA 11820

Full Address
23RD FL. GEDUNG WISMA 76 (WISMA CALINDRA) JL. LET. JEND. S. PARMAN KAV 76, SLIPI, PALMERAH.
111 SOMMERSET RD., #14-01 DEVONSHIRE WINGSINGAPORE POWER BUILDINGSINGAPORE 238164
WORLD TRADE CENTRE-112TH FLOOR,JL JEND SUDIRMAN KAV.29-31JAKARTA
OFF AL-FAHIDI STREETP.O. BOX 51370DUBAI ( U.A.E )
23RD FL. GEDUNG WISMA 76 ( WISMA CALINDRA )JL. LET. JEND. S. PARMAN KAV. 76,SLIPI, PALMERAH.JAKARTA 11410
275 YOUNG ST., WATERLOONSW, AUSTRALIA
MID PLAZA 1, 4TH FLOORJL JEND SUDIRMAN KAV.10-11JAKARTA 10220, INDONESIA
GREENWORTH INTERNATIONAL PTE LTD#08 - 03 HIGH STREET PLAZA77 HIGH STREET SINGAPORE
19TH FLOOR, SUN LIFE TOWERTHE GATEWAY, HARBOUR CITY KOWLOONHONG KONG
3-6 BINGOMACHI, 2-CHOMECHUO-KU, OSAKA 541JAPAN
GREENWORTH INTERNATIONAL PTE LTD#08 - 03 HIGH STREET PLAZA77 HIGH STREET SINGAPORE
WISMA STANDARD CHARTERED BANK, 15TH FLOORJL JEND SUDIRMAN KAV.33AJAKARTA 10220 INDONESIA
Ubah agar cell yg berwarna pink agar menjadi baris, dan tanggal menjadi kolom hingga menjadi seperti gambar dibawa ini:
InvoiceDate CustomerCode Item Name Quantity Unit Price

11.09.12 YALE PW3131 65,929 $ 2.26
21.09.12 JOHN PW2121 429 $ 3.60
21.09.12 JOHN TW8251 1,161 $ 3.80
27.09.12 DLA PW6161 4,872 $ 2.60
26.09.12 YALE TW8251 2,072 $ 2.75
26.09.12 YALE PW3131 63,366 $ 2.26
28.09.12 BUXW TW8251 4,386 $ 3.32
27.09.12 SOM TW8251 2,910 $ 3.85
27.09.12 SOM PW3131 519 $ 3.40 Letakan dibawah ini :
28.09.12 SOM TW8251 200 $ 6.85
04.09.12 RATI PW3131 19,639 $ 1.91
04.09.12 RATI PW3131 19,765 $ 1.91 InvoiceDate
10.09.12 KHAN PSF256 9,800 $ 1.81 CustomerCode
10.09.12 KHAN PSF256 10,016 $ 1.81 Item Name
10.09.12 KHAN PSF256 5,022 $ 1.81 Quantity
10.09.12 KHAN PSF256 5,037 $ 1.81 Unit Price
10.09.12 KHAN PSF256 9,963 $ 1.81
10.09.12 KHAN PSF256 4,922 $ 1.81
10.09.12 KHAN PSF256 4,899 $ 1.81
enjadi seperti gambar dibawa ini:
akan dibawah ini :
11.09.12 21.09.12 21.09.12 27.09.12 26.09.12 26.09.12 28.09.12 27.09.12 27.09.12

YALE JOHN JOHN DLA YALE YALE BUXW SOM SOM
PW3131 PW2121 TW8251 PW6161 TW8251 PW3131 TW8251 TW8251 PW3131
65,929 429 1,161 4,872 2,072 63,366 4,386 2,910 519
$ 2.26 $ 3.60 $ 3.80 $ 2.60 $ 2.75 $ 2.26 $ 3.32 $ 3.85 $ 3.40
28.09.12 04.09.12 04.09.12 10.09.12 10.09.12 10.09.12 10.09.12 10.09.12 10.09.12 10.09.12
SOM RATI RATI KHAN KHAN KHAN KHAN KHAN KHAN KHAN
TW8251 PW3131 PW3131 PSF256 PSF256 PSF256 PSF256 PSF256 PSF256 PSF256
200 19,639 19,765 9,800 10,016 5,022 5,037 9,963 4,922 4,899
$ 6.85 $ 1.91 $ 1.91 $ 1.81 $ 1.81 $ 1.81 $ 1.81 $ 1.81 $ 1.81 $ 1.81
# InvoiceDate CustomerCode Customer/Vendor Name Invoice No Document CItem No. Item/Servic Quantity Price Curre Unit Price
7 30-Jun-12 TI TORAY INTERNATIONAL INC. ACEX-276/VIII/12/KTI USD ENWJ ENWJ TW 85 522 USD 10.85
10 30-Jun-12 HUN HUNT TEXTILES PTY LTD ACEX-277/VIII/12/HTT USD ASWL ASWL 50/50 284 USD 13.15
11 30-Jun-12 HUN HUNT TEXTILES PTY LTD ACEX-277/VIII/12/HTT USD ASWL ASWL 70/30 187 USD 11.15
12 30-Jun-12 HUN HUNT TEXTILES PTY LTD ACEX-277/VIII/12/HTT USD ASWH ASWH 50/50 445 USD 18.2
13 30-Jun-12 VML VIMAL INTERNATIONAL ACEX-278/VIII/12/VIM USD GHHB GHHB 100/0 9,967.00 USD 5.35
14 30-Jun-12 VML VIMAL INTERNATIONAL ACEX-278/VIII/12/VIM USD PPHB PPHB 100/0 499 USD 5.35
15 30-Jun-12 HUN HUNT TEXTILES PTY LTD ACEX-279/IX/12/HTT USD PDWL PDWL 70/30 601 USD 9.6
16 30-Jun-12 HUN HUNT TEXTILES PTY LTD ACEX-279/IX/12/HTT USD PPHB PPHB 100/0 1,275.00 USD 5.75
17 30-Jun-12 HUN HUNT TEXTILES PTY LTD ACEX-279/IX/12/HTT USD ASWH ASWH 50/50 107 USD 15.4
18 30-Jun-12 HUN HUNT TEXTILES PTY LTD ACEX-279/IX/12/HTT USD PPHB PPHB 100/0 390 USD 5.65
19 30-Jun-12 HUN HUNT TEXTILES PTY LTD ACEX-279/IX/12/HTT USD PDWL PDWL 70/30 197 USD 9.6
20 30-Jun-12 HUN HUNT TEXTILES PTY LTD ACEX-279/IX/12/HTT USD CLHB CLHB 100/0 393 USD 6.25
21 30-Jun-12 HUN HUNT TEXTILES PTY LTD ACEX-279/IX/12/HTT USD PPHB PPHB 100/0 270 USD 5.75
22 30-Jun-12 HUN HUNT TEXTILES PTY LTD ACEX-279/IX/12/HTT USD PPME PPME 70/30 197 USD 6.25
23 30-Jun-12 TI TORAY INTERNATIONAL INC. ACEX-280/IX/12/KTI USD COWL COWL 85/15 5,000.00 USD 7.8
24 30-Jun-12 TI TORAY INTERNATIONAL INC. ACEX-280/IX/12/KTI USD TNWF TNWF 80/10 999 USD 11.8
25 30-Jun-12 TI TORAY INTERNATIONAL INC. ACEX-280/IX/12/KTI USD COWL COWL 85/15 122 USD 9.6
26 30-Jun-12 TI TORAY INTERNATIONAL INC. ACEX-280/IX/12/KTI USD ENWJ ENWJ 85/10 250 USD 7.75
27 30-Jun-12 TI TORAY INTERNATIONAL INC. ACEX-281/IX/12/KTI USD SSTW SSTW 70/30 833 USD 15.3
30 30-Jun-12 TI TORAY INTERNATIONAL INC. ACEX-284/IX/12/TI USD CPAB CPAB 100/0 14,220.00 USD 4.86
33 30-Jun-12 TI TORAY INTERNATIONAL INC. ACEX-286/IX/12/TI USD TNDK TNDK 85/10 12,000.00 USD 7.02
34 30-Jun-12 TI TORAY INTERNATIONAL INC. ACEX-287/IX/12/TI USD ASWL ASWL 70/30 9,912.00 USD 9.5
35 30-Jun-12 TI TORAY INTERNATIONAL INC. ACEX-287/IX/12/TI USD TNDK TNDK 85/10 3,000.00 USD 7.02
36 30-Jun-12 TI TORAY INTERNATIONAL INC. ACEX-287/IX/12/TI USD ASWL ASWL 70/30 9,912.00 USD 9.5
37 5-Jul-12 TI TORAY INTERNATIONAL INC. ACEX-287/IX/12/TI USD TNDK TNDK 85/10 3,000.00 USD 7.02
38 5-Jul-12 TI TORAY INTERNATIONAL INC. ACEX-288/IX/12/KTI USD TOSW TOSW 90/10 204 USD 11.4
39 5-Jul-12 TI TORAY INTERNATIONAL INC. ACEX-288/IX/12/KTI USD TOSW TOSW 90/10 2,972.00 USD 11.4
40 5-Jul-12 TI TORAY INTERNATIONAL INC. ACEX-288/IX/12/KTI USD TOSW TOSW 90/10 9 USD 11.4
41 15-Jul-12 TI TORAY INTERNATIONAL INC. ACEX-289/IX/12/TI USD TJWL TJWL 70/30 15,000.00 USD 7.9
42 15-Jul-12 HUN HUNT TEXTILES PTY LTD ACEX-290/IX/12/HTT USD ASWL ASWL 50/50 499 USD 13.15
43 15-Jul-12 FNW FURNIWEB MANUFACTURING SDN BH ACEX-291/IX/12/FNW USD PPHB PPHB 100/0 3,981.00 USD 5.7
44 15-Jul-12 TYT TOYOTA TSUSHO ACEX-292/IX/12/TYT USD EPNB EPNB 100/0 2,000.00 USD 4.55
45 15-Jul-12 TYT TOYOTA TSUSHO ACEX-292/IX/12/TYT USD EPNB EPNB 100/0 2,960.00 USD 6.05
46 30-Jul-12 TI TORAY INTERNATIONAL INC. ACEX-293/IX/12/KTI USD COWL COWL 85/15 4,168.00 USD 9.6
47 30-Jul-12 TI TORAY INTERNATIONAL INC. ACEX-293/IX/12/KTI USD COWL COWL 85/15 193 USD 9.6
48 30-Jul-12 TI TORAY INTERNATIONAL INC. ACEX-293/IX/12/KTI USD COWL COWL TW 1/ 194 USD 10.6
50 30-Jul-12 TI TORAY INTERNATIONAL INC. ACEX-293/IX/12/KTI USD COWL COWL 85/15 3,000.00 USD 7.8
52 30-Jul-12 ASK ASAHI KASEI TRADING CO. LTD. ACEX-294/IX/12/ASK USD SSFL SSFL 60/40 8,000.00 USD 11.5
53 30-Jul-12 ASK ASAHI KASEI TRADING CO. LTD. ACEX-294/IX/12/ASK USD SSWH SSWH 60/40 4,008.00 USD 11.9
54 30-Jul-12 TI TORAY INTERNATIONAL INC. ACEX-295/IX/12/TI USD CPAB CPAB 100/0 10,000.00 USD 4.86
55 30-Jul-12 TI TORAY INTERNATIONAL INC. ACEX-295/IX/12/TI USD TFMW TFMW 70/30 350 USD 11.8
56 30-Jul-12 TI TORAY INTERNATIONAL INC. ACEX-295/IX/12/TI USD PPHB PPHB 100/0 3,000.00 USD 4.2
57 30-Jul-12 TI TORAY INTERNATIONAL INC. ACEX-295/IX/12/TI USD TNWS TNWS 80/15 1,008.00 USD 6.92
59 30-Jul-12 TI TORAY INTERNATIONAL INC. ACEX-295/IX/12/TI USD TFMW TFMW 70/30 350 USD 11.8
60 30-Jul-12 TI TORAY INTERNATIONAL INC. ACEX-295/IX/12/TI USD PPHB PPHB 100/0 3,000.00 USD 4.2
62 30-Jul-12 SW SUNWOO CORPORATION ACEX-296/IX/12/SW USD ASWH ASWH 50/50 8,400.00 USD 11.6
65 30-Jul-12 TI TORAY INTERNATIONAL INC. ACEX-299/IX/12/TI USD TPWL TPWL 70/30 12,000.00 USD 8.65
68 30-Jul-12 XIN SHANGHAI XIN SONG HONG TEXTILE ACEX-301/IX/12/XIN USD PPHB PPHB 100/0 8,400.00 USD 4.7
69 30-Jul-12 XIN SHANGHAI XIN SONG HONG TEXTILE ACEX-301/IX/12/XIN USD CPAB CPAB 100/0 8,400.00 USD 5.7
70 30-Jul-12 MYM MIYAMA CO. LTD. ACEX-302/IX/12/MY USD TNWS TNWS 80/15 16,800.00 USD 7.35
71 30-Jul-12 ASK ASAHI KASEI TRADING CO. LTD. ACEX-303/IX/12/ASK USD SSWH SSWH 60/40 8,016.00 USD 11.9
72 30-Jul-12 ASK ASAHI KASEI TRADING CO. LTD. ACEX-303/IX/12/ASK USD SSFL SSFL 60/40 5,000.00 USD 11.5
73 30-Jul-12 VML VIMAL INTERNATIONAL ACEX-304/IX/12/VIM USD GHHB GHHB 100/0 8,480.00 USD 5.35
74 30-Jul-12 VML VIMAL INTERNATIONAL ACEX-304/IX/12/VIM USD PPME PPME 100/0 1,985.00 USD 5.85
75 30-Jul-12 MTM MITSUI & CO (THAILAND) LTD ACEX-305/IX/12/MTH USD PPHB PPHB 100/0 7,008.00 USD 4.85
76 30-Jul-12 MTM MITSUI & CO (THAILAND) LTD ACEX-305/IX/12/MTH USD PPHB PPHB 100/0 8,616.00 USD 4.9
77 30-Jul-12 JRX JOREX SDN BHD ACEX-306/IX/12/JRX USD HTJB HTJB 100/0 1,496.00 USD 5.8
78 30-Jul-12 JRX JOREX SDN BHD ACEX-306/IX/12/JRX USD HTJB HTJB 100/0 843 USD 4.9
79 30-Jul-12 SW SUNWOO CORPORATION ACEX-307/IX/12/SW USD ASWH ASWH 70/30 8,500.00 USD 10.2
82 30-Jul-12 KCS KC SMART TRADING ACEX-309/IX/12/KCS USD PPHB PPHB 100/0 1,067.00 USD 5.55
83 30-Jul-12 KCS KC SMART TRADING ACEX-309/IX/12/KCS USD PPHB PPHB 100/0 1,905.00 USD 5.6
84 30-Jul-12 KCS KC SMART TRADING ACEX-309/IX/12/KCS USD PPHB PPHB 100/0 979 USD 5.7
87 30-Jul-12 APN PT. ANEKA PRODUKSI NUSAJAYA Y-0906/APN/IX/2012 IDR PPHB PPHB-Regul 609 IDR 47,272.73
89 30-Jul-12 CMB PT CIPTAGRIA MUTIARA BUSANA Y-0907/CMBU/IX/2012 USD PKHB PKHB-Regul 306 USD 5.4
91 30-Jul-12 APN PT. ANEKA PRODUKSI NUSAJAYA Y-0908/APN/IX/2012 IDR PKHB PKHB-Regul 15 IDR 47,272.73
94 30-Jul-12 APN PT. ANEKA PRODUKSI NUSAJAYA Y-0908/APN/IX/2012 IDR GHHB GHHB-Regu 178 IDR 47,272.72
95 30-Jul-12 V00 PT. ANEKA PRODUKSI NUSAJAYA Y-0908/APN/IX/2012 IDR PKHB PKHB-Regul 1 IDR 70,909.00
100 30-Jul-12 DAD DADI Y-0909/DAD/IX/2012 IDR PKHB PKHB-Regul 39 IDR 53,181.82
101 30-Jul-12 HID H. IDIN Y-0910/HID/IX/2012 IDR PPHB PPHB-Regul 770 IDR 52,727.27
110 31-Jul-12 HYU H. YUSRIL Y-0911/HYU/IX/2012 IDR PPHB PPHB-Regul 330 IDR 52,727.27
111 31-Jul-12 MIG PT. MIGI Y-0912/MIG/IX/2012 USD CLHB CLHB-Regul 400 USD 5.75455
112 31-Jul-12 MIG PT. MIGI Y-0912/MIG/IX/2012 USD CLHB CLHB-Regul 352 USD 5.75455
120 31-Jul-12 WAN WANDI Y-0913/WAN/IX/2012 IDR PPHB PPHB-Regul 494 IDR 53,181.82
125 31-Jul-12 GPS PT. GOLDINDO PRIMATAMA SWEATER Y-0914/GPS/IX/2012 USD PKHB PKHB-Regul 420 USD 5.55455
124.43774 30-Jun-12 TI TORAY INTERNATIONAL INC. ACEX-276/VIII/12/KTI USD ENWJ ENWJ TW 852297.7299191 USD 38364.045
Copy alamat dari kotak merah ke kotak hijau, namun dengan penulisan huruf kapital yang sesuai seperti pada kotak biru, dan
Pada kotak hijau, berikan komentar yg bertuliskan "Format penulisan yang benar"
pt toray industries indonesia PT TORAY INDUSTRIES INDONESIA

summitmas 2 lt. 3 Summitmas 2 Lt. 3
jl jendral sudirman kav 61-62 Jl. Jendral Sudirman Kav 61-62
jakarta 12190 Jakarta 12190
telp : 520-1231 Telp : 520-1231
fax : 520-2041 Fax : 520-2041
pt toray industries indonesia PT TORAY INDUSTRIES INDONESIA

summitmas 2 lt. 3 Summitmas 2 Lt. 3
jl jendral sudirman kav 61-62 Jl Jendral Sudirman Kav 61-62
jakarta 12190 Jakarta 12190
telp : 520-1231 Telp : 520-1231
fax : 520-2041 Fax : 520-2041
seperti pada kotak biru, dan dengan menggunakan rumus
Dibawah ini adalah data alamat customer
Urutkan data dibawah ini secara alfabet berdasarkan nama customer. Jangan sampai alamat dan kode nya tertukar
Kode Customer Nama Customer

YASI YASIN SALMAN
TTTM THAI TORAY TEXTILE MILLS PUBLIC CO.,LTD
TAKI TAKISADA OSAKA CO.,LTD
SUPE SUPER TREND HOUSE
REGE REGENT
RAJU RAJU MAMA
RAHI RAHIM
MITR PT.MITRA SELARAS SEMPURNA
BENU PT.BENUA HAMPARAN LUAS
ADHI PT.ADHIKARYA SURYA JAYA
SEI PT. SLIONTEC EKADHARMA INDONESIA
PRON PT. PRONTO MODA
PRI PT. PRIMATAMA BUSINDO
PRMA PT. PRIMATAMA BUSINDO
MID PT. MIDO INDONESIA
MANA PT. MANNA PRATAMA SANTOSA
FITU PT. FIT-U GARMENT INDUSTRIES
SRYA P.T.SURYA PRASETYA TEKSTIL INDUSTRI
HOPE P.T.HOPERINDO PRIMA
SIMR P.T. SIMRAN JAYA
OME OMER KASSEM AL ESAYI TEXTILE CO.LTD
KHAW OMEER IBRAHIM KHAWAJI
NAJE NAJEEM
AJAM NAJAM AL AGHAR
MONT MONTGOMERY TEXTILE PTY LIMITED
MEHD MEHDI STORE
GAED M/S. ABDULLAH GAED AL-KHALIDY EST
KG KG OSAKA
JAVI JAVIER MARTIN
ICHI ICHIMURA SANGYO CO.,LTD
MEAS GOLDEN MEASURE
EVE EVE FABRIC
DIML DIM-LIGHT
HILA BIN HILABI
BAGA BAGAIS
AYNA AYNALEM GERU
AYES AYESH AL-KHALIFA
NAJR ASB EST-NAJRAN
ALTM ALTIMO CLOTHING COMPANY
ALYA AL YAMANI
KAWA AL KAHWAJI
SHAW AKRAM SHAWOSH
ADNA ADNAN OMAR BASALAMAH EST
REEM ADEL KAREEM
ACTI ACTION CRAFT FASHION LTD
ABUL ABUL HASAN
WALD ABU WALEED
YAHY ABDULRAHMAN YAHYA MUNSHI EST.
SAUD ABDULLAH MOHAMMAD SAUD
a customer. Jangan sampai alamat dan kode nya tertukar
Alamat Customer
THE GATEWAY, HARBOUR CITY KOWLOON
GREENWORTH INTERNATIONAL PTE LTD
JL. M. H. THAMRIN KAV 28-30
JL. LET. JEND. S. PARMAN KAV. 76,
JL. KRAWANG NO. 1 KEBON WARU
23RD FL. GEDUNG WISMA 76 ( WISMA CALINDRA )
JL. MEKAR MULYA NO. 33
JL. INHOFTANK KOMPLEK JATI PERMAI NO. 56
111 SOMMERSET RD., #14-01 DEVONSHIRE WING
JL. LET. JEND. S. PARMAN KAV. 341
OFF AL-FAHIDI STREET
SINGAPORE POWER BUILDING
45RD FL. GEDUNG BINAKARNA
THE PLAZA OFFICE TOWER LT 25-26
WORLD TRADE CENTRE-1
275 YOUNG ST., WATERLOO
SLIPI, PALMERAH.
ROA MALAKA-TAMBORA
BCA TOWER 12TH FLOOR,
KOMP. PERGUDANGAN RAWA MELATI,
12TH FLOOR,
JL JEND SUDIRMAN KAV.29-31
JL. PINTU KECILL NO.12 RT/RW :002/02
JL. RAYA DAAN MOGOT KM 20NO. 43
JL. MEKAR MULYA NO. 33
JL JEND SUDIRMAN KAV.29-31
AGUNG TENGAH 4 BLOK 1-2/6A
SLIPI, PALMERAH.
JL. PINTU KECILL NO.12 RT/RW :002/02
19TH FLOOR, SUN LIFE TOWER
#08 - 03 HIGH STREET PLAZA
JL. LET. JEND. S. PARMAN KAV. 76,
JL. KRAWANG NO. 1 KEBON WARU
NSW, AUSTRALIA
DUBAI ( U.A.E )
JL. SOEKARNO HATTA NO. 571
JL RAYA KOPO SOREANG KM 11.5
JL RAYA KOPO SOREANG KM 11.5
SINGAPORE 238164
12TH FLOOR,
Berikut adalah data stok gudang PT. Senang Senang Susah
Banyak stok yang kosong.
Anda diminta untuk membuat angka 0 (nol) menjadi blank page
Item Harga Qty Total

SSTW 70/30/0 1/28 DMM DOC 120,000 20 2,400,000
KFWK 50/50/0 2/28 SMM RWC 120,000 20 2,400,000
KFWK 50/50/0 2/48 SMM RWC 70,000 20 1,400,000
ENWJ 85/10/5 1/28 DMM DOC 40,000 0 0
ENWJ 85/10/5 1/28 DMM DOC 120,000 20 2,400,000
ENWJ TW 85/10/5 2/28 DMM DOC 25,000 40 1,000,000
ENWJ TW 85/10/5 2/28 DMM DOC 100,000 20 2,000,000
ENWJ TW 85/10/5 2/28 DMM DOC 100,000 40 4,000,000
ENWJ TW 85/10/5 2/28 DMM DOC 100,000 20 2,000,000
ASWL 50/50/0 2/28 DMM DOC 50,000 0 0
ASWL 70/30/0 2/28 DMM DOC 160,000 40 6,400,000
ASWH 50/50/0 2/48 DMM DOC 160,000 40 6,400,000
GHHB 100/0/0 2/28 DMM DOC 160,000 40 6,400,000
PPHB 100/0/0 2/28 DMM DOC 160,000 40 6,400,000
PDWL 70/30/0 2/25 DMM DOC 160,000 0 0
PPHB 100/0/0 2/28 DMM DOC 85,000 20 1,700,000
ASWH 50/50/0 2/48 DMM DOC 160,000 40 6,400,000
PPHB 100/0/0 1/18 DMM DOC 60,000 40 2,400,000
PDWL 70/30/0 2/25 DMM DOC 85,000 20 1,700,000
CLHB 100/0/0 2/28 DMM DOC 85,000 20 1,700,000
PPHB 100/0/0 2/28 DMM DOC 160,000 40 6,400,000
PPME 70/30/0 2/28 DMM DOC 26,000 0 0
COWL 85/15/0 1/34 SMM RWH 85,000 20 1,700,000
TNWF 80/10/10 1/24 DMM DOC 42,500 20 850,000
COWL 85/15/0 1/28 DMM DOC 118,000 0 0
ENWJ 85/10/5 1/35 SMM RWH 118,000 40 4,720,000
SSTW 70/30/0 1/28 DMM DOC 118,000 0 0
ENWJ 85/10/5 1/18 DMM DOC 118,000 40 4,720,000
ENWJ 85/10/5 1/18 DMM DOC 118,000 40 4,720,000
CPAB 100/0/0 2/20 SMM RWC 118,000 40 4,720,000
CPAB 100/0/0 2/20 SMM RWC 118,000 0 0
CPAB 100/0/0 2/20 SMM RWC 25,000 20 500,000
TNDK 85/10/5 1/35 SMM RWH 30,000 20 600,000
ASWL 70/30/0 2/48 SMM RWC 9,000 0 0
TNDK 85/10/5 1/35 SMM RWH 20,000 20 400,000
ASWL 70/30/0 2/48 SMM RWC 85,000 20 1,700,000
TNDK 85/10/5 1/35 SMM RWH 85,000 0 0
TOSW 90/10/0 1/28 DMM DOC 38,000 20 760,000
TOSW 90/10/0 1/28 DMM DOC 50,000 20 1,000,000
TOSW 90/10/0 1/28 DMM DOC 62,000 0 0
TJWL 70/30/0 2/36 SMM RWC 85,000 20 1,700,000
ASWL 50/50/0 2/28 DMM DOC 85,000 20 1,700,000
PPHB 100/0/0 1/28 DMM DOC 75,000 20 1,500,000
EPNB 100/0/0 2/34 SMM RWH 18,000 20 360,000
EPNB 100/0/0 2/34 DMM DOC 18,000 20 360,000
COWL 85/15/0 1/28 DMM DOC 53,000 0 0
COWL 85/15/0 1/28 DMM DOC 53,000 20 1,060,000
COWL TW 1/34 X 1/34 85/15/0 2/28 53,000 0 0
COWL 85/15/0 1/28 DMM DOC 53,000 20 1,060,000
COWL 85/15/0 1/30 SMM RWH 7,000 20 140,000
COWL 85/15/0 1/28 DMM DOC 75,000 20 1,500,000
SSFL 60/40/0 2/36 SMM RWH 75,000 0 0
SSWH 60/40/0 2/48 SMM RWC 75,000 20 1,500,000
CPAB 100/0/0 2/20 SMM RWH 47,000 20 940,000
TFMW 70/30/0 2/53 SMM RWH 75,000 20 1,500,000
PPHB 100/0/0 1/10 SMM RWC 44,000 20 880,000
TNWS 80/15/5 1/35 SMM RWC 75,000 20 1,500,000
CPAB 100/0/0 2/20 SMM RWH 140,000 0 0
TFMW 70/30/0 2/53 SMM RWH 37,500 20 750,000
PPHB 100/0/0 1/10 SMM RWC 53,000 20 1,060,000
TNWS 80/15/5 1/35 SMM RWC 23,000 20 460,000
ASWH 50/50/0 2/48 SMM RWH 23,000 20 460,000
TNWS 80/15/5 1/35 SMM RWH 53,000 0 0
TNDK 85/10/5 1/35 SMM RWH 31,000 0 0
TPWL 70/30/0 2/38 SMM RWH 26,000 20 520,000
CPAB 100/0/0 2/20 SMM RWC 53,000 20 1,060,000
TNWS 80/15/5 1/35 SMM RWH 25,000 20 500,000
PPHB 100/0/0 2/20 SMM RWH 23,000 20 460,000
CPAB 100/0/0 2/20 SMM RWH 23,000 0 0
TNWS 80/15/5 1/35 SMM RWH 31,000 20 620,000
SSWH 60/40/0 2/48 SMM RWC 20,000 20 400,000
SSFL 60/40/0 2/36 SMM RWH 45,000 20 900,000
GHHB 100/0/0 2/28 DMM DOC 80,000 0 0
PPME 100/0/0 2/28 DMM DOC 80,000 20 1,600,000
PPHB 100/0/0 1/28 SMM RWC 80,000 20 1,600,000
PPHB 100/0/0 1/36 SMM RWC 15,000 20 300,000
HTJB 100/0/0 4/15 DMM DOC 80,000 0 0
HTJB 100/0/0 4/18 SMM RWH 80,000 20 1,600,000
ASWH 70/30/0 2/48 SMM RWH 25,000 0 0
TNDK 85/10/5 1/35 SMM RWH 35,000 20 700,000
TNWS 80/15/5 1/35 SMM RWH 75,000 20 1,500,000
PPHB 100/0/0 1/22 DMM DOC 75,000 0 0
PPHB 100/0/0 1/24 DMM DOC 75,000 20 1,500,000
PPHB 100/0/0 1/28 DMM DOC 75,000 0 0
PPHB-Regular-DOC-R 75,000 20 1,500,000
PKHB-Regular-DOC-R 75,000 0 0
PKHB-Regular-DOC-R 75,000 20 1,500,000
GHHB-Regular-DOC-R 53,000 0 0
PPHB-Regular-DOC-R 75,000 0 0
PPHB-Regular-DOC-R 48,000 20 960,000
CLHB-Regular-DOC-S 49,000 20 980,000
CLHB-Regular-DOC-S 44,000 20 880,000
PPHB-Regular-DOC-R 7,000 20 140,000
Freeze cell A7 hingga N7, dan Coloum A dan B
deliv_date vesel container_no ship_comp

08-Dec-10 SINAR SANGIR V. 109W OOLU-3725066 SAMUDERA PACIFIC MAJU
16-Dec-10 CONVENT V. 1012 MSKU-3455328 SAMUDERA PACIFIC MAJU
23-Dec-10 CAPE MOLLINI V.1026 MSKU-5581500 SAMUDERA PACIFIC MAJU
11-Dec-10 SANYA V. 031W CRXU-3153969 PT. ANDALAN PACIFIC SAMUDRA
28-Dec-10 CAPE SORREL V. 002N TCKU-2842837 PT. ANDALAN PACIFIC SAMUDRA
10-Dec-10 FRISIA BONN V.017N TGHU-2019002 SAMUDERA PACIFIC MAJU
27-Dec-10 SANYA V. 033W CLHU-2928459 SAMUDERA PACIFIC MAJU
24-Dec-10 MSC HOBART V.21051A MSCU5051054 SAMUDERA PACIFIC MAJU
07-Dec-10 SAYLEMOON RICKMERS V. 21049A MSCU-4807018 PT. ANDALAN PACIFIC SAMUDRA
22-Dec-10 MSC HOBART V. 21051A WLNU-4906264 PT. ANDALAN PACIFIC SAMUDRA
29-Dec-10 MSC HOBART 21051A CRXU4101152 PT. ANDALAN PACIFIC SAMUDRA
28-Dec-10 HENRY SCHULTE V. 004 TOLU-2668304 SAMUDERA PACIFIC MAJU
10-Dec-10 SAYLEMOON RICKMERS V. 21049A MSCU-6366626 PT. QUALITY PRIMA LOGISTINDO
14-Dec-10 CONVENT V.1012 MRKU-0485899 PT. ANDALAN PACIFIC SAMUDRA
17-Dec-10 SINAR SANGIR V. 110 SIKU-2958473 SAMUDERA PACIFIC MAJU
13-Dec-10 YM INTERACTION V.046N TCLU-2519436 SAMUDERA PACIFIC MAJU
10-Dec-10 VISION V.1002 PONU-1515979 PT. ANDALAN PACIFIC SAMUDRA
03-Dec-10 SAYLEMOON RICKMERS V.21048A MEDU-1675193 SAMUDERA PACIFIC MAJU
16-Dec-10 MSC HOBART V.21051A TCLU-2053754 PT. ANDALAN PACIFIC SAMUDRA
10-Dec-10 SINAR SANGIR V.109 SIKU-2975911 SAMUDERA PACIFIC MAJU
07-Dec-10 KMTC SHANGHAI V.1016N KMTU-9232176 SAMUDERA PACIFIC MAJU
10-Dec-10 CAMELLIA V.284N CCLU-7327384 SAMUDERA PACIFIC MAJU
17-Dec-10 STADT ROSTOCK V.QA286N TCKU-9584360 SAMUDERA PACIFIC MAJU
23-Dec-10 PONTREMOLI V.QA288N TGHU-8962456 SAMUDERA PACIFIC MAJU
27-Dec-10 KMTC SHANGHAI V.1017N KMTU-9231694 SAMUDERA PACIFIC MAJU
14-Dec-10 KMTC INCHEON V.1017N KMTU-9230682 SAMUDERA PACIFIC MAJU
02-Dec-10 SINAR SANGIR V. 108 CRXU-3179881 PT. ANDALAN PACIFIC SAMUDRA
03-Dec-10 SINAR SANGIR V. 108 SIKU-2952686 PT. ANDALAN PACIFIC SAMUDRA
08-Dec-10 SINAR SUBANG V. 081 SIKU-3009240 PT. ANDALAN PACIFIC SAMUDRA
16-Dec-10 SINAR SANGIR V. 110 CRSU-1002600 PT. ANDALAN PACIFIC SAMUDRA
21-Dec-10 SINAR SUBANG V. 083 CRXU-3154203 PT. ANDALAN PACIFIC SAMUDRA
08-Dec-10 KMTC SHANGHAI V.1016N KMTU-7309582 PT. ANDALAN PACIFIC SAMUDRA
14-Dec-10 YM INTERACTION V. 046N GLDU-3362540 SAMUDERA PACIFIC MAJU
20-Dec-10 KMTC PORTKELANG 1017N KMTU-7333423 PT. ANDALAN PACIFIC SAMUDRA
23-Dec-10 MSC HOBART V.21051A GLDU-5063614 PT. ANDALAN PACIFIC SAMUDRA
23-Dec-10 MSC HOBART V. 21051A MEDU-1254759 PT. ANDALAN PACIFIC SAMUDRA
27-Dec-10 APE MAGNUS 1102 TTNU5865941 SAMUDERA PACIFIC MAJU
10-Dec-10 SINAR SANGIR V.109 SIKU-2975911 SAMUDERA PACIFIC MAJU
14-Dec-10 CONVENT V.1012 MSKU-7274884 SAMUDERA PACIFIC MAJU
14-Dec-10 SANYA V. 031W SIKU-3006791 PT. QUALITY PRIMA LOGISTINDO
23-Dec-10 SINAR SANGIR V. 111 ILSU-2021410 PT. ANDALAN PACIFIC SAMUDRA
27-Dec-10 SINAR SUBANG V. 084 ILSU-2014112 PT. ANDALAN PACIFIC SAMUDRA
28-Dec-10 CAPE SORREL V. 002N REGU-3106714 PT. ANDALAN PACIFIC SAMUDRA
10-Dec-10 SINAR SANGIR V.109W SIKU-2983368 PT. ANDALAN PACIFIC SAMUDRA
16-Dec-10 SINAR SANGIR V. 110 CRSU-1002600 PT. ANDALAN PACIFIC SAMUDRA
23-Dec-10 SINAR SANGIR V. 111 ILSU-2021410 PT. ANDALAN PACIFIC SAMUDRA
28-Dec-10 CAPE SORREL V. 002N REGU-3106714 PT. ANDALAN PACIFIC SAMUDRA
29-Dec-10 HENRY SCHULTE V. 004 GLDU-5297886 SAMUDERA PACIFIC MAJU
10-Dec-10 UNI-POPULAR V.0385-113W BSIU-2177918 PT. QUALITY PRIMA LOGISTINDO
21-Dec-10 HENRY SCHULTE V. 003 APZU-3721822 SAMUDERA PACIFIC MAJU
02-Dec-10
16-Dec-10 CONVENT V. 1012 MSKU-5684540 SAMUDERA PACIFIC MAJU
23-Dec-10 SINAR SANGIR V.111 SIKU-2955181 PT. ANDALAN PACIFIC SAMUDRA
11-Dec-10 SANYA V. 031W SIKU-2947463 PT. ANDALAN PACIFIC SAMUDRA
08-Dec-10 CAMELLIA V. 284N CCLU-2361004 SAMUDERA PACIFIC MAJU
17-Dec-10 STADT ROSTOCK QA286NCNC ECMU-1961571 SAMUDERA PACIFIC MAJU
27-Dec-10 KMTC SHANGHAI V. 1017N TGHU-3066610 SAMUDERA PACIFIC MAJU
29-Dec-10 CAPE MAGNUS V. 1102 MSKU-7434750 SAMUDERA PACIFIC MAJU
30-Dec-10 CAPE MAGNUS V.1102 MSKU-5530652 SAMUDERA PACIFIC MAJU
07-Dec-10 UNI POPULAR V.0385-113W EMCU-3648381 PT. QUALITY PRIMA LOGISTINDO
11-Dec-10 MEDCORAL V. 069R ZIMU-1118363 PT. ANDALAN PACIFIC SAMUDRA
11-Dec-10 SAYLEMOON RICKMERS V. 21049A MEDU-2711335 PT. ANDALAN PACIFIC SAMUDRA
21-Dec-10 HENRY SCHULTE V.003 APZU-3946794 PT. ANDALAN PACIFIC SAMUDRA
03-Dec-10
16-Dec-10 MSC HOBART V. 21050A MEDU-1697192 PT. ANDALAN PACIFIC SAMUDRA
23-Dec-10 MSC HOBART V. 21051A MEDU-1920705 SAMUDERA PACIFIC MAJU
28-Dec-10 HENRY SCHULTE V. 004 GLDU-5243920 SAMUDERA PACIFIC MAJU
13-Dec-10 SANYA V.031W OKCU-2002133 PT. SARI SAMUDRA
07-Dec-10 SINAR SUBANG V. 081 ILSU-2019921 PT. ANDALAN PACIFIC SAMUDRA
11-Dec-10 SANYA V. 031W SIKU-2947463 PT. ANDALAN PACIFIC SAMUDRA
container_type document_no pay_code pack_qty gross_weight yds_qty uprice_yds
20 GT-2010-12052 L/C90 71 14261.22 120254 0.52
20 GT-2010-12073 L/C90 72 14306.1 120630 0.52
20 GT-2010-12071 T/T60 41 8244.29 69518 0.565
20 GT-2010-12063 T/T15 30 6009.35 50672 0.4557
20 GT-2010-12092 T/T15 71 14269.39 120323 0.5233
40 GT-2010-12053 T/T60 15 3413.7 25215 0.63
20 GT-2010-12090 L/C90 60 13597.11 100433 0.57
40 GT-2010-12053 T/T60 13 2980.7 22017 0.62
20 GT-2010-12071 T/T60 22 5033.79 37182 0.62
20 GT-2010-12063 T/T15 30 6875.64 50787 0.5083
40 GT-2010-12088 L/C45 97 25362.61 159910 0.62179
40 GT-2010-12050 LCS 94 25345.17 159812 0.62636
40 GT-2010-12083 LCS 95 25453.52 160493 0.62636
40 GT-2010-12097 LCS 95 25419.71 160279 0.62636
40 GT-2010-12096 LCS 96 25407.05 160195 0.63094
20 GT-2010-12061 LCS 52 13567.99 85545 0.64008
40 GT-2010-12066 L/C90 95 25263.69 159293 0.64
40 GT-2010-12053 T/T60 26 6859.37 43249 0.68
20 GT-2010-12079 LCS 50 13404.35 84519 0.65
20 GT-2010-12065 L/C 50 13415.11 84587 0.66
40 GT-2010-12057 L/C90 96 25464.96 160561 0.7
20 GT-2010-12041B LC120 15 4037.02 25455 0.65837
20 GT-2010-12075 L/C 51 13534.12 85335 0.70409
20 GT-2010-12056 L/C60 25 6750.19 42563 0.657
40 GT-2010-12049 T/T60 24 19103.94 118081 0.59756
40 GT-2010-12060 T/T60 24 19136.66 118219 0.59756
40 GT-2010-12077 T/T60 24 19115.99 118127 0.59756
40 GT-2010-12087 T/T60 24 19051.24 117793 0.59756
40 GT-2010-12091 T/T60 24 19127.96 118193 0.59756
40 GT-2010-12082 T/T60 24 19118.78 118135 0.59756
40 GT-2010-12064 T/T60 24 19125.91 118180 0.59756
20 GT-2010-12044 T/T15 5 3974.98 24694 0.611
20 GT-2010-12047 T/T15 5 3980.36 24588 0.611
20 GT-2010-12044 T/T15 5 1327.63 8371 0.606
20 GT-2010-12047 T/T15 12 3199.24 20172 0.606
20 GT-2010-12055 T/T15 50 13404.51 84520 0.606
20 GT-2010-12068 T/T15 50 13426.63 84660 0.606
20 GT-2010-12074 T/T15 23 6068.74 38264 0.606
20 GT-2010-12081 T/T15 30 7978.95 50309 0.606
20 GT-2010-12048 T/T15 37 9874.26 62260 0.606
20 GT-2010-12101 T/T15 11 8756.54 54092 0.701
20 GT-2010-12098 T/T15 25 6812.53 42957 0.696
20 GT-2010-12054 L/C 45 13492.16 75458 0.7
20 GT-2010-12044 T/T30 4 3220.99 17740 0.6619
20 GT-2010-12047 T/T30 4 3185.65 17633 0.6619
20 GT-2010-12051 T/T30 12 9483.46 52474 0.6619
20 GT-2010-12072 T/T30 7 5598.45 30975 0.6619
20 GT-2010-12058 T/T30 12 9526.81 52690 0.6619
20 GT-2010-12078 T/T30 12 9498.98 52502 0.6619
20 GT-2010-12044 T/T30 4 1187.1 6639 0.6569
20 GT-2010-12081 T/T30 18 5258.53 29408 0.6569
20 GT-2010-12072 T/T30 15 4481.2 25062 0.6569
20 GT-2010-12070 LCS 45 13382.3 74842 0.72
20 GT-2010-12076 LCS 45 13424.55 75079 0.71
20 GT-2010-12045B L/C 27 7876.8 44050 0.73152
20 GT-2010-12084 LCS 45 13275.96 74246 0.73152
40 GT-2010-12093 L/C90 86 25009.31 139860 0.72
20 GT-2010-12056 L/C60 22 6640.66 37140 0.706
20 GT-2010-12069 T/T60 12 9480.8 52471 0.66102
20 GT-2010-12059 T/T15 12 9455.79 52425 0.681
20 GT-2010-12067 T/T15 12 9460.78 52362 0.681
20 GT-2010-12080 T/T15 12 9516.64 52631 0.681
20 GT-2010-12085 T/T15 7 5611.31 31035 0.681
20 GT-2010-12089 T/T15 6 4703.71 26093 0.681
20 GT-2010-12094 T/T15 12 9498.96 52593 0.681
20 GT-2010-12095 T/T15 5 4006.88 22156 0.681
20 GT-2010-12062 T/T15 43 12764.51 71387 0.676
20 GT-2010-12074 T/T15 14 4187.59 23420 0.676
20 GT-2010-12085 T/T15 18 5320.12 29753 0.676
20 GT-2010-12048 T/T15 12 3584.49 20047 0.676
20 GT-2010-12095 T/T15 27 8006.49 44777 0.676
20 GC-2010-1461 LCS 48 12719.65 79886 0.73152
20 GC-2010-1443 L/C 47 12640.73 79393 0.71
20 GC-2010-1450 LCS 48 12818.32 80507 0.73152
20 GC-2010-1434B L/C90 9 2417.72 15185 0.72
20 GC-2010-1448 L/C90 48 12820.86 80523 0.72
20 GC-2010-1454 L/C90 47 12816.43 80499 0.73
20 GC-2010-1446 T/T15 5 3981.24 24586 0.681
20 GC-2010-1463 T/T15 20 5462.71 34311 0.776
20 GC-2010-1441 LCS 45 13524.03 75253 0.75
20 GC-2010-1449 LCS 45 13564.58 75479 0.75
20 GC-2010-1459 LCS 45 13526.91 75269 0.75
20 GC-2010-1462 LCS 45 13585.03 75593 0.75
20 GC-2010-1464 L/C90 46 13526.99 75266 0.8
20 GC-2010-1439 L/C 45 13535.89 75319 0.77
20 GC-2010-1452 L/C 45 13485.67 75039 0.77
20 GC-2010-1437B LCS 20 5836.04 32472 0.81382
20 GC-2010-1436B LCS 15 4379.18 24366 0.82296
20 GC-2010-1453 L/C 46 13381.53 74455 0.80467
20 GC-2010-1435B LCS 32 9619.57 53527 0.80467
20 GC-2010-1447 LCS 45 13401.57 74570 0.80467
20 GC-2010-1455 LCS 45 13389.16 74501 0.80467
20 GC-2010-1460 LCS 45 13601.53 75685 0.80467
20 GC-2010-1445 TT 45 13577.85 75553 0.79
20 GC-2010-1451 T/T60 11 8872.83 48822 0.73097
20 GC-2010-1440 T/T15 12 9587.76 52639 0.751
20 GC-2010-1457 T/T15 6 4824.61 26529 0.751
20 GC-2010-1444 T/T15 11 8843.49 48703 0.751
20 GC-2010-1442 T/T15 10 8026.1 44168 0.751
20 GC-2010-1446 T/T15 7 5559.21 30498 0.751
20 GC-2010-1456 T/T15 12 9598.62 52721 0.751
20 GC-2010-1442 T/T15 9 2673.68 14877 0.746
20 GC-2010-1444 T/T15 4 1196.19 6656 0.746
inv_amount freight insurance
62532.08 1700 0
62727.6 1700 0
39277.67 374.63 76.83
23091.2304 199.77 0
62965.0259 400 0
15885.45 160.24 31.08
57246.81 1700 0
13650.54 139.92 27.14
23052.84 200.37 41.1
25815.0321 200.23 0
99430.76 4000 188.123
100100.48 4000 189.39
100527.04 4000 190.197
100393 4000 0
101072.79 4000 191.23
54755.64 2150 103.598
101947.52 1600 192.885
29409.32 274.84 53.31
54937.35 325 103.941
55827.42 700 105.625
112392.7 1600 212.647
16758.76 800 31.708
60083.35 2150 113.678
27963.891 173.56 54.75
70560.53 525 133.501
70642.99 525 133.657
70588.02 525 133.553
70388.43 525 133.175
70627.46 525 133.627
70592.8 525 132.09
70619.69 525 132.14
15088.034 0 0
15023.268 0 0
5072.826 0 0
12224.232 0 0
51219.12 400 0
51303.96 400 0
23187.984 248.13 0
30487.254 0 0
37729.56 302.57 0
37918.492 400 0
29898.072 200 0
52820.6 550 0
11742.106 0 0
11671.2827 0 0
34732.5406 400 0
20502.3525 221.1 0
34875.511 400 0
34751.0738 400 0
4361.1591 0 0
19318.1152 0 0
16463.2278 178.9 0
53886.24 700 100.537
53306.09 550 0
32223.46 1150 60.967
54312.43 2150 102.759
100699.2 2675 0
26220.84 151.44 47.77
34684.37 325 65.623
35701.425 400 0
35658.522 400 0
35841.711 400 0
21134.835 204.22 0
17769.333 200 0
35815.833 400 0
15088.236 132.41 0
48257.612 400 0
15831.92 151.87 0
20113.028 195.78 0
13551.772 97.43 0
30269.252 267.59 0
58438.21 2150 110.565
56369.03 710 106.65
58892.48 2150 111.425
10933.2 850 0
57976.56 1700 0
58764.27 1150 111.182
16743.066 178.53 0
26625.336 200 0
56439.75 325 106.784
56609.25 325 107.105
56451.75 325 0
56694.75 325 107.266
60212.8 1100 113.923
57995.63 710 109.728
57780.03 700 109.32
26426.23 1075 0
20052.24 1075 0
59911.85 2150 113.353
43071.68 1075 0
60004.39 2150 113.528
59948.87 2150 113.423
60901.6 2150 115.226
59686.87 390 112.928
35687.48 325 67.521
39531.889 400 0
19923.279 200 0
36575.953 351.91 0
33170.168 299.22 0
22903.998 221.47 0
39593.471 400 0
11098.242 100.78 0
4965.376 48.09 0
Ubah sedemikian rupa agar tabel dibawah ini menjadi seperti gambar disebelah kanan ini didalam kotak orange (menggunaka
Customer Data
Date
Customer Customer Name Customer Address
3/30/12 T.G. T.G. INTERNATI 275 YOUNG ST., WATERLOO
5/30/12 APSA APSARATEX 111 SOMMERSET RD., #14-01 DEV
6/30/12 MDRA INDIAN RAYON WORLD TRADE CENTRE-1
6/30/12 KL G.KALLIS MFRS 23RD FL. GEDUNG WISMA 76 ( WIS
6/30/12 HJ HOCK JOO NSW, AUSTRALIA
6/30/12 ROSE ROSE E DEE SINGAPORE POWER BUILDING
6/30/12 RGF RGF INTERNATI 12TH FLOOR,
6/30/12 KAYT KAYTEE CORPOJL. LET. JEND. S. PARMAN KAV. 76,
6/30/12 HJC H.J.C. (I&E) PR SINGAPORE 238164
6/30/12 ITL ITL JL JEND SUDIRMAN KAV.29-31
6/30/12 MAHE MAHENDER ENTSLIPI, PALMERAH.
6/30/12 DSGN DESIGN TEX OFF AL-FAHIDI STREET
7/30/12 FAMI FAMILY CARE yye
7/15/12 GOLD GOLDEN COASTWORLD TRADE CENTRE-1
7/31/12 BUSA BUSALEH TRAD 45RD FL. GEDUNG BINAKARNA
7/31/12 GREN GREENWORTH IN JL. LET. JEND. S. PARMAN KAV. 34
7/31/12 HUES HUESPE E HIJO 12TH FLOOR,
7/31/12 DAFA DHAFAF DUBAI DUBAI ( U.A.E )
7/31/12 SW SWEE WAN ENTSLIPI, PALMERAH.
7/31/12 ITL ITL JL JEND SUDIRMAN KAV.29-31
mbar disebelah kanan ini didalam kotak orange (menggunakan auto shape)
Sales Data
Product Price/Unit Qty Ammout
PW3131 $ 2.26 65 $ 146.90
PW2121 $ 3.60 75 $ 270.00
TW8251 $ 3.80 65 $ 247.00
PW6161 $ 2.60 75 $ 195.00
TW8251 $ 2.75 100 $ 275.00
PSF256 $ 1.81 100 $ 181.00
TS1851 $ 2.20 65 $ 143.00
PW3131 $ 2.26 70 $ 158.20
PW2121 $ 3.60 100 $ 360.00
TW8251 $ 3.80 100 $ 380.00
PW6161 $ 2.60 65 $ 169.00
TW8251 $ 2.75 75 $ 206.25
PSF256 $ 1.81 100 $ 181.00
TS1851 $ 2.20 75 $ 165.00
PW3131 $ 2.26 65 $ 146.90
PW2121 $ 3.60 100 $ 360.00
TW8251 $ 3.80 100 $ 380.00
PW6161 $ 2.60 100 $ 260.00
TW8251 $ 2.75 100 $ 275.00
PSF256 $ 1.81 100 $ 181.00
$ 4,680.25
Copy sheet "Q19" ke sheet terakhir , dan beri judul "Sheet Copy" dengan tanda kurung
Lalu simpan seluruh file excel ini, dan set default location nya di Desktop
Customer Name Customer Address

T.G. INTERNATIONAL 275 YOUNG ST., WATERLOO
APSARATEX 111 SOMMERSET RD., #14-01 DEVONSHIRE WING
INDIAN RAYON & INDUSTRIES WORLD TRADE CENTRE-1
G.KALLIS MFRS.LTD 23RD FL. GEDUNG WISMA 76 ( WISMA CALINDRA )
HOCK JOO NSW, AUSTRALIA
ROSE E DEE SINGAPORE POWER BUILDING
RGF INTERNATIONAL LTD 12TH FLOOR,
KAYTEE CORPORATION JL. LET. JEND. S. PARMAN KAV. 76,
H.J.C. (I&E) PRIVATE LTD SINGAPORE 238164
ITL JL JEND SUDIRMAN KAV.29-31
MAHENDER ENT SLIPI, PALMERAH.
DESIGN TEX OFF AL-FAHIDI STREET
FAMILY CARE 23RD FL. GEDUNG WISMA 76 ( WISMA CALINDRA )
GOLDEN COAST WORLD TRADE CENTRE-1
BUSALEH TRADING 45RD FL. GEDUNG BINAKARNA
GREENWORTH INT'L PTE LTD JL. LET. JEND. S. PARMAN KAV. 341
HUESPE E HIJOS 12TH FLOOR,
DHAFAF DUBAI GENERAL TRAD DUBAI ( U.A.E )
SWEE WAN ENTERPRISES SLIPI, PALMERAH.
ITL JL JEND SUDIRMAN KAV.29-31
GALAXY TEXTILE 23RD FL. GEDUNG WISMA 76 ( WISMA CALINDRA )
ABDUL RAZAK WORLD TRADE CENTRE-1
ROYAL TRADER 111 SOMMERSET RD., #14-01 DEVONSHIRE WING
KAYTEE CORPORATION JL. LET. JEND. S. PARMAN KAV. 76,
AGHA BCA TOWER 12TH FLOOR,
TEXTIL LARREA S.A.C.I SINGAPORE POWER BUILDING
IE A WOEN / PD.SENTOSA JAYA JL. PINTU KECILL NO.12 RT/RW :002/02
MIKOMI ROA MALAKA-TAMBORA
PD. SURYA MANGGALA AGUNG TENGAH 4 BLOK 1-2/6A
BRUCE SMITH LTD JL. PINTU KECILL NO.12 RT/RW :002/02
GERSTLER JL. RAYA DAAN MOGOT KM 20NO. 43
AL-TAREEF TEXTILE EST JL. KRAWANG NO. 1 KEBON WARU
FERMIN CHAN JL RAYA KOPO SOREANG KM 11.5
GURTEEN JL. SOEKARNO HATTA NO. 571
AL-OTHMAN TEXTILE JL. KRAWANG NO. 1 KEBON WARU
Buatlah Pivot table dengan menggunakan data dibawah dengan urutan label nya :
Row Area : Vendor Code - Vendor Name - Invoice No - Invoice Date - Document Currency
Data Area : Sum of Document Total - Sum of Document Total (FC)
InvoiceDate Due Date VendorCode Vendor Name Document Currency

11.10.12 11.10.12 VT0008-U TORAY INTERNATIONAL INC USD
11.10.12 11.10.12 VS0015-U SUDAMERICANA DE FIBRAS SA USD
16.10.12 16.10.12 VF0005-U FORMOSA PLASTICS CORPORATION USD
16.10.12 16.10.12 VF0005-U FORMOSA PLASTICS CORPORATION USD
18.10.12 18.10.12 VM0007-U MOTOHIRO & CO. LTD USD
23.10.12 31.12.12 VT0011-U TONG-HWA SYNTHETIC FIBER CO.LTD USD
19.10.12 19.10.12 VT0014-U TORAY TRADING SHANGHAI USD
08.10.12 11.10.12 VN0004-U NICHIRYU TRADING CO LTD USD
08.10.12 18.10.12 VT0008-Y TORAY INTERNATIONAL INC USD
15.10.12 31.10.12 VM0006-Y MURATA PARTS SALES LTD JPY
15.10.12 15.10.12 VT0008-Y TORAY INTERNATIONAL INC JPY
08.10.12 07.11.12 VZ0001-R ZETA GRAFIKA IDR
08.10.12 07.11.12 VP0009-R PANCA MULIA BERSAMA IDR
05.10.12 05.11.12 VI0002-R INDOTEXMAT PRIMA PT IDR
03.10.12 02.11.12 VJ0003-R JAYA TEKNIK IDR
01.10.12 31.10.12 VN0006-R NUGRAHA SITI KUMALA PT IDR
08.10.12 07.11.12 VD0006-R DUTA PHOTOCOPY IDR
01.10.12 31.10.12 VB0004-R BUANA RAJA TEHNIK PT IDR
08.10.12 07.11.12 VK0001-R KARYAMULYA TEKNINDO PT IDR
01.10.12 31.10.12 VA0002-U ALPHA CIPTA COMPUTINDO PT USD
19.10.12 24.10.12 VF0006-U FAJAR BUANA INTERNUSA TRANS PT USD
22.10.12 21.11.12 VA0005-R ANUGRAH ELECTRIC CV IDR
23.10.12 22.11.12 VE0001-R EKAJAYA KOMPUTER IDR
04.10.12 05.11.12 VM0001-R MAJU JAYA TEKNIK CV IDR
04.10.12 05.11.12 VS0001-R SADIKUN NIAGAMAS RAYA PT IDR
02.10.12 01.11.12 VI0003-R INDOGEMA GEMILANG PT IDR
01.10.12 31.10.12 VS0007-R SLS BEARINDO PT IDR
10.10.12 09.11.12 VN0007-R ND ELECTRO IDR
01.10.12 31.10.12 VG0004-R GEMILANG JAYA TOKO IDR
01.10.12 31.10.12 VP0005-R PROMINANTOR IDR
01.10.12 31.10.12 VM0008-R MITRA MUDA MANGGALA CV IDR
08.10.12 07.11.12 VJ0002-R JAYA KAWATI ENGINEERING CV IDR
16.10.12 15.11.12 VK0015-R KSO PRIMA ROLL PT IDR
10.10.12 09.11.12 VD0008-R DWIMITRA SEJAHTERA MANDIRI PT IDR
01.10.12 31.10.12 VK0003-R KAWAN LAMA SEJAHTERA PT IDR
23.10.12 22.11.12 VK0008-R KOPERASI KARYAWAN ACTEM IDR
08.10.12 07.11.12 VD0005-U DUNIA KIMIA JAYA PT USD
05.10.12 05.11.12 VD0001-U DAI-CHI KIMIA RAYA PT USD
04.10.12 05.11.12 VD0001-U DAI-CHI KIMIA RAYA PT USD
05.10.12 05.11.12 VP0004-R PRATAMA ABADI IDR
11.10.12 12.11.12 VS0003-Y SEKAWAN PT JPY
04.10.12 05.11.12 VP0002-R PD 21 IDR
01.10.12 31.10.12 VN0006-R NUGRAHA SITI KUMALA PT IDR
05.10.12 05.11.12 VM0005-U MITRA ASMOCO UTAMA PT USD
02.10.12 01.11.12 VI0003-R INDOGEMA GEMILANG PT IDR
09.10.12 08.11.12 VK0015-R KSO PRIMA ROLL PT IDR
11.10.12 12.11.12 VA0002-R ALPHA CIPTA COMPUTINDO PT IDR
05.10.12 05.11.12 VL0001-U LAUTAN LUAS PT USD
08.10.12 07.11.12 VM0004-R MITRA MARGA SEJAHTERA IDR
05.10.12 05.11.12 VP0001-U PANCA KUSUMA RAYA PT USD
09.10.12 08.11.12 VP0008-R PENZ STAR PANCA PERSADA PT IDR
01.10.12 31.10.12 VJ0001-R JAYA ELECTRIC UTAMA TOKO IDR
09.10.12 08.11.12 VJ0001-R JAYA ELECTRIC UTAMA TOKO IDR
11.10.12 12.11.12 VP0014-R PRIMA REKSA INTERNUSA PT IDR
11.10.12 12.11.12 VM0002-U MATSUMO TOYUSHI INDONSIA PT USD
11.10.12 12.11.12 VD0009-R DWI MAKMUR CV IDR
01.10.12 31.10.12 VJ0002-R JAYA KAWATI ENGINEERING CV IDR
Document Total Document Total (FC) Invoice No
74,100.00 0 300.PI.IMP.201210.0004
157,195.00 0 300.PI.IMP.201210.0005
160,048.00 0 300.PI.IMP.201210.0006
65,608.66 0 300.PI.IMP.201210.0007
212,550.82 0 300.PI.IMP.201210.0008
114,753.60 0 300.PI.IMP.201210.0009
115,892.40 0 300.PI.IMP.201210.0010
11,314.50 0 300.PI.IMP.201210.0011
29,210.71 0 300.PI.IMP.201210.0014
137,170.00 0 300.PI.IMP.201210.0015
15 0 300.PI.IMP.201210.0019
156,697.96 0 300.PI.IMP.201210.0020
66,341.76 0 300.PI.IMP.201210.0021
2,025.00 0 400.PI.IMP.201210.0009
3,828,000.00 0 400.PI.IMP.201210.0010
5,868.57 455,400.00 400.PI.IMP.201210.0019
858.66 67,405.00 400.PI.IMP.201210.0020
188.14 14,600.00 400.PI.IMP.201210.0023
11,279.64 875,300.00 400.PI.IMP.201210.0078
39,247.50 0 400.PI.IMP.201210.0089
6,105.00 0 400.PI.IMP.201210.0090
49,329.90 3,828,000.00 400.PI.IMP.201210.0165
12.52 120,000.00 400.PI.LOC.201210.0012
141.89 1,360,000.00 400.PI.LOC.201210.0015
1,043.84 10,000,000.00 400.PI.LOC.201210.0016
114.82 1,100,000.00 400.PI.LOC.201210.0021
286.91 2,750,000.00 400.PI.LOC.201210.0022
68.89 659,950.00 400.PI.LOC.201210.0030
40.69 390,000.00 400.PI.LOC.201210.0033
159.1 1,525,000.00 400.PI.LOC.201210.0034
177.36 1,700,000.00 400.PI.LOC.201210.0038
37.56 360,000.00 400.PI.LOC.201210.0039
51.13 490,000.00 400.PI.LOC.201210.0040
95.2 912,000.00 400.PI.LOC.201210.0041
13.56 130,000.00 400.PI.LOC.201210.0044
65.72 630,000.00 400.PI.LOC.201210.0046
308 0 400.PI.LOC.201210.0047
6,670.00 0 400.PI.LOC.201210.0049
386.35 0 400.PI.LOC.201210.0051
31.3 300,000.00 400.PI.LOC.201210.0053
1,815.00 0 400.PI.LOC.201210.0055
130.41 1,250,000.00 400.PI.LOC.201210.0056
12.52 120,000.00 400.PI.LOC.201210.0057
32.86 315,000.00 400.PI.LOC.201210.0058
234.74 2,250,000.00 400.PI.LOC.201210.0062
53.73 515,000.00 400.PI.LOC.201210.0066
28.17 270,000.00 400.PI.LOC.201210.0068
155 0 400.PI.LOC.201210.0070
234.74 2,250,000.00 400.PI.LOC.201210.0073
610.65 5,850,000.00 400.PI.LOC.201210.0074
356.24 3,414,545.48 400.PI.LOC.201210.0075
31.3 300,000.00 400.PI.LOC.201210.0077
54.25 520,000.00 400.PI.LOC.201210.0080
312.21 2,992,500.00 400.PI.LOC.201210.0081
243.64 2,334,000.00 400.PI.LOC.201210.0082
636.41 6,100,000.00 400.PI.LOC.201210.0083
625.98 6,000,000.00 400.PI.LOC.201210.0084
327.6 3,140,000.00 400.PI.LOC.201210.0085
832.55 7,980,000.00 400.PI.LOC.201210.0086
35.99 345,000.00 400.PI.LOC.201210.0091
495.57 4,750,000.00 400.PI.LOC.201210.0092
167.97 1,610,000.00 400.PI.LOC.201210.0096
5.65 54,150.00 400.PI.LOC.201210.0101
37.56 360,000.00 400.PI.LOC.201210.0102
816.9 7,830,000.00 400.PI.LOC.201210.0107
477.83 4,580,000.00 400.PI.LOC.201210.0108
952.01 9,125,000.00 400.PI.LOC.201210.0109
581.74 5,576,000.00 400.PI.LOC.201210.0110
2,305.58 22,087,500.00 400.PI.LOC.201210.0111
1,141.36 10,940,000.00 400.PI.LOC.201210.0112
2,389.16 22,900,000.00 400.PI.LOC.201210.0113
2,295.25 22,000,000.00 400.PI.LOC.201210.0114
1,756.66 16,837,500.00 400.PI.LOC.201210.0115
581.36 5,572,450.00 400.PI.LOC.201210.0116
1,508.35 14,450,000.00 400.PI.LOC.201210.0121
430.58 4,125,000.00 400.PI.LOC.201210.0123
550.24 5,274,000.00 400.PI.LOC.201210.0124
759.97 7,284,000.00 400.PI.LOC.201210.0127
276 0 400.PI.LOC.201210.0130
2,920.00 0 400.PI.LOC.201210.0131
1,698.00 0 400.PI.LOC.201210.0132
332.07 3,183,000.00 400.PI.LOC.201210.0133
219.97 17,070.00 400.PI.LOC.201210.0137
1,346.29 12,897,500.00 400.PI.LOC.201210.0138
245.3 2,350,000.00 400.PI.LOC.201210.0139
79.42 761,250.00 400.PI.LOC.201210.0140
5,007.82 48,000,000.00 400.PI.LOC.201210.0141
65.73 630,000.00 400.PI.LOC.201210.0142
378.39 3,625,000.00 400.PI.LOC.201210.0143
52.61 504,000.00 400.PI.LOC.201210.0144
27.56 263,980.00 400.PI.LOC.201210.0145
2,680.00 0 400.PI.LOC.201210.0146
522.54 5,008,500.00 400.PI.LOC.201210.0147
2,571.73 24,650,000.00 400.PI.LOC.201210.0148
114.76 1,100,000.00 400.PI.LOC.201210.0150
1,444.00 0 400.PI.LOC.201210.0152
18.26 175,000.00 400.PI.LOC.201210.0153
867 0 400.PI.LOC.201210.0154
156.49 1,500,000.00 400.PI.LOC.201210.0155
59.71 572,000.00 400.PI.LOC.201210.0156
23.47 225,000.00 400.PI.LOC.201210.0157
610.33 5,850,000.00 400.PI.LOC.201210.0158
610.65 5,850,000.00 400.PI.LOC.201210.0159
610.65 5,850,000.00 400.PI.LOC.201210.0160
820.03 7,860,000.00 400.PI.LOC.201210.0161
825 0 400.PI.LOC.201210.0162
164.84 1,580,000.00 400.PI.LOC.201210.0164
56.49 541,500.00 400.PI.LOC.201210.0166
1,201.42 11,515,500.00 400.PI.LOC.201210.0170
180.48 1,730,000.00 400.PI.LOC.201210.0171
1,252.61 12,000,000.00 400.PI.LOC.201210.0172
37.56 360,000.00 400.PI.LOC.201210.0173
782.88 7,500,000.00 400.PI.LOC.201210.0174
83.46 800,000.00 400.PI.LOC.201210.0175
345.65 3,313,050.00 400.PI.LOC.201210.0176
152.85 1,465,000.00 400.PI.LOC.201210.0177
Berikut adalah data penjualan PT. Suka Duka.
Buatlah grafik dari data dibawah ini menjadi seperti gambar di sebelah kanan
Date Product Qty

3/30/12 PW3131 65
5/30/12 PW2121 75
6/30/12 TW8251 65
6/30/12 PW6161 75
6/30/12 TW8251 100
6/30/12 PSF256 100
6/30/12 TS1851 65
6/30/12 PW3131 70
6/30/12 PW2121 100
6/30/12 TW8251 100
6/30/12 PW6161 65
6/30/12 TW8251 75
7/30/12 PSF256 100
7/15/12 TS1851 75
7/31/12 PW3131 65
7/31/12 PW2121 100
7/31/12 TW8251 100
7/31/12 PW6161 100
7/31/12 TW8251 100
7/31/12 PSF256 100
7/31/12 TS1851 100
7/30/12 PW3131 65
7/30/12 PW2121 65
7/30/12 TW8251 65
7/30/12 PW6161 81 100 3/30/12 PW3131 5/30/12 PW
7/30/12 TW8251 65
6/30/12 PW6161 6/30/12 TW
7/15/12 PSF256 65
7/30/12 TS1851 65 90 6/30/12 TS1851 6/30/12 PW
7/30/12 PW3131 65 6/30/12 TW8251 6/30/12 PW
7/30/12 PW2121 65
7/30/12 TW8251 65
80 7/30/12 PSF256 7/15/12 TS1
7/5/12 PW6161 65 7/31/12 PW2121 7/31/12 TW
7/5/12 TW8251 65 70
7/30/12 PSF256 65 7/31/12 TW8251 7/31/12 PS
7/30/12 TS1851 75
60 7/30/12 PW3131 7/30/12 PW
7/30/12 PW3131 65
7/30/12 PW2121 65 7/30/12 PW6161 7/30/12 TW
7/30/12 TW8251 75 50 7/30/12 TS1851 7/30/12 PW
7/30/12 PW6161 100
7/30/12 TW8251 100
7/30/12 TW8251 7/5/12 PW6
7/30/12 PSF256 100 40 7/30/12 PSF256 7/30/12 TS1
7/30/12 TS1851 100
7/30/12 PW3131 100
7/30/12 PW2121 7/30/12 TW
7/31/12 PW2121 65
30 7/30/12 TW8251 7/30/12 PS
7/30/12 PW3131 7/31/12 PW
20
7/30/12 PW6161 7/30/12 TW
10 8/30/12 TS1851
Qyt
7/30/12 TW8251 7/5/12 PW6
40 7/30/12 PSF256 7/30/12 TS1
7/30/12 PW2121 7/30/12 TW
30 7/30/12 TW8251 7/30/12 PS
7/30/12 TW8251 65 7/30/12 PW3131 7/31/12 PW
7/30/12 PW6161 65 20
7/30/12 TW8251 100 7/30/12 PW6161 7/30/12 TW
7/30/12 PSF256 65
10 8/30/12 TS1851
8/30/12 TS1851 65
Qyt
0
31 5/30/12 PW2121 6/30/12 TW8251
61 6/30/12 TW8251 6/30/12 PSF256
1 6/30/12 PW3131 6/30/12 PW2121
51 6/30/12 PW6161 6/30/12 TW8251
56 7/15/12 TS1851 7/31/12 PW3131
21 7/31/12 TW8251 7/31/12 PW6161
51 7/31/12 PSF256 7/31/12 TS1851
31 7/30/12 PW2121 7/30/12 TW8251
61 7/30/12 TW8251 7/15/12 PSF256
1 7/30/12 PW3131 7/30/12 PW2121
51 7/5/12 PW6161 7/5/12 TW8251
56 7/30/12 TS1851 7/30/12 PW3131
21 7/30/12 TW8251 7/30/12 PW6161
51 7/30/12 PSF256 7/30/12 TS1851
31 7/31/12 PW2121 7/30/12 TW8251
61 7/30/12 TW8251 7/30/12 PSF256
1
51 7/5/12 PW6161 7/5/12 TW8251
56 7/30/12 TS1851 7/30/12 PW3131
21 7/30/12 TW8251 7/30/12 PW6161
51 7/30/12 PSF256 7/30/12 TS1851
31 7/31/12 PW2121 7/30/12 TW8251
61 7/30/12 TW8251 7/30/12 PSF256
1

Training Excel LV 1a

Uploaded by

Copyright:

Available Formats

Training Excel LV 1a

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Training Excel LV 1a

Uploaded by

Copyright:

Available Formats

Ubah header tabel dibawah agar menjadi seperti ini

Product Invoice No. Price/Unit Qty Amount

bawah kedalam kotak Summary berikut ini

Rounded Amount 123.00 Kg

Laporan Penjualan Bulanan PT. Kiri Kanan Oke

Data Penjualan Bulanan PT. Kiri Kanan Oke

an Bulanan PT. Kiri Kanan Oke

ualan Bulanan PT. Kiri Kanan Oke

Customer Data Sales Data

Tanggal Hari Ini: 8/23/2017

Nama Karyawan Tgl Lahir Umur

Customer Name Code Purshased Item Price

Isi kolom Keterangan dengan menggunakan rumus, dengan ketentuan :

Customer Qty Keterangan

Anda diminta untuk :

Tanggal Pembelian Nama Customer

Tanggal Pembelian Nama Customer Qty

TANJUNG PRIOK JAKARTA UTARA

TANJUNG PRIOK JAKARTA UTARA

TANJUNG PRIOK JAKARTA UTARA

TANJUNG PRIOK JAKARTA UTARA

BLOK M 12 NO. 1, KEL. TEGAL ALUR, JAKARTA 11820

InvoiceDate CustomerCode Item Name Quantity Unit Price

akan dibawah ini :

11.09.12 21.09.12 21.09.12 27.09.12 26.09.12 26.09.12 28.09.12 27.09.12 27.09.12

pt toray industries indonesia PT TORAY INDUSTRIES INDONESIA

pt toray industries indonesia PT TORAY INDUSTRIES INDONESIA

Kode Customer Nama Customer

Item Harga Qty Total

deliv_date vesel container_no ship_comp

Customer Name Customer Address

InvoiceDate Due Date VendorCode Vendor Name Document Currency

Date Product Qty

You might also like