Terima kasih Mr. Kid. Salam,Hk Sent from Yahoo Mail on Android On Mon, Jan 22, 2018 at 10:01, 'Mr. Kid' [email protected] [belajar-excel]<[email protected]> wrote:
Ini bisa untuk belajar query : (sql -> bahasa internasional-nya data, seperti bahasa Inggris sebagai bahasa intersional-nya manusia) https://www.w3schools.com/sql/ 2018-01-22 9:47 GMT+07:00 hendrik karnadi [email protected] [belajar-excel] <[email protected]>: Mr Kid,Terima kasih atas infonya Mr. Kid. Saya sdh search di internet, dapatnya cuma untuk satu produk (pernah saya share di grup milis ini).Macronyapun bukan dalam bentuk SQL, sedangkan pengetahuan saya mengenai SQL masih sangat kurang. Salam,HK On Sunday, 21 January 2018, 11:57:36 PM GMT+7, 'Mr. Kid' [email protected] [belajar-excel] <[email protected] > wrote: Google atau Yahoo Jaman now dah umum nyari sesuatu disana. ;P On Sun, Jan 21, 2018 at 9:58 PM, hendrik karnadi [email protected] [belajar-excel] <[email protected] > wrote: Maaf Mr. Kid, Searchnya dimana ya ?Terima kasih. Salam,HK Sent from Yahoo Mail on Android On Sun, Jan 21, 2018 at 21:25, 'Mr. Kid' [email protected] [belajar-excel]<[email protected] > wrote: Sila search dengan key query fifo. Sederhana kan... Regards, Kid On Fri, Jan 19, 2018 at 8:13 PM, hendrik karnadi [email protected] [belajar-excel] <[email protected] > wrote: Sama2 pak Sony. Mudah2 an ada yang berkenan mengubahnya menjadi FIFO. Salam,HK Sent from Yahoo Mail on Android On Fri, Jan 19, 2018 at 17:38, Sony Ario [email protected] [belajar-excel]<[email protected] > wrote: Wah ilmu baru nih pak Hendrik. Terima kasih. gnl-excelinfo.blogspot.co.id 2018-01-19 16:30 GMT+07:00 hendrik karnadi [email protected] [belajar-excel] <[email protected] >: Selamat sore rekan2 BeExcel, Walaupun ilmu SQL saya masih tahap uji coba, namun berkat ilmu dari sesepuh yang ada di grup ini saya mencoba merekam SQL Get External Data.Rekaman ini khusus saya buat untuk menghitung Gross Margin dan Stock Akhir dengan menggunakan Average Cost untuk menghitung harga pokok per unitnya. Sistim kerjanya: - File terdiri dari File Sumber (STOCK_PL) yang terdiri dari tiga Sheets (Stock, Beli dan Jual), dengan 5 (lima) variasi transaksi berikut ini: - Ada Stock Awal, Pembelian dan Penjulan - Ada Stock Awal dan Pembelian saja - Ada Stock Awal dan Penjualan saja - Tidak ada Stock Awal, hanya Pembelian dan Penjualan saja - Tidak ada Stock Awal, Pembelian maupun Penjualan - SQL yang saya peroleh melalui Get External Data saya coba rekam dengan Macro Recording kemudian saya edit variabelnya, agar bila terjadi perubahan2 pada Nama File Sumber, Nama2 Sheets pada FIle Sumber dan lokasi penempatan hasil Querynya maka kita tidak perlu merubah Macronya lagi. Semoga bermanfaat. Salam,HK Note: Extract Zip File (WinRar) terlampir ke dalam suatu folder (mis. D) sehingga muncul Sub Folder SQL yang berisi dua file, yaitu STOCK_PL dan Query from STOCK_PL (Flexi Range) #yiv6407076467 #yiv6407076467 -- #yiv6407076467ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6407076467 #yiv6407076467ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6407076467 #yiv6407076467ygrp-mkp #yiv6407076467hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6407076467 #yiv6407076467ygrp-mkp #yiv6407076467ads {margin-bottom:10px;}#yiv6407076467 #yiv6407076467ygrp-mkp .yiv6407076467ad {padding:0 0;}#yiv6407076467 #yiv6407076467ygrp-mkp .yiv6407076467ad p {margin:0;}#yiv6407076467 #yiv6407076467ygrp-mkp .yiv6407076467ad a {color:#0000ff;text-decoration:none;}#yiv6407076467 #yiv6407076467ygrp-sponsor #yiv6407076467ygrp-lc {font-family:Arial;}#yiv6407076467 #yiv6407076467ygrp-sponsor #yiv6407076467ygrp-lc #yiv6407076467hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6407076467 #yiv6407076467ygrp-sponsor #yiv6407076467ygrp-lc .yiv6407076467ad {margin-bottom:10px;padding:0 0;}#yiv6407076467 #yiv6407076467actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6407076467 #yiv6407076467activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6407076467 #yiv6407076467activity span {font-weight:700;}#yiv6407076467 #yiv6407076467activity span:first-child {text-transform:uppercase;}#yiv6407076467 #yiv6407076467activity span a {color:#5085b6;text-decoration:none;}#yiv6407076467 #yiv6407076467activity span span {color:#ff7900;}#yiv6407076467 #yiv6407076467activity span .yiv6407076467underline {text-decoration:underline;}#yiv6407076467 .yiv6407076467attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6407076467 .yiv6407076467attach div a {text-decoration:none;}#yiv6407076467 .yiv6407076467attach img {border:none;padding-right:5px;}#yiv6407076467 .yiv6407076467attach label {display:block;margin-bottom:5px;}#yiv6407076467 .yiv6407076467attach label a {text-decoration:none;}#yiv6407076467 blockquote {margin:0 0 0 4px;}#yiv6407076467 .yiv6407076467bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6407076467 .yiv6407076467bold a {text-decoration:none;}#yiv6407076467 dd.yiv6407076467last p a {font-family:Verdana;font-weight:700;}#yiv6407076467 dd.yiv6407076467last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6407076467 dd.yiv6407076467last p span.yiv6407076467yshortcuts {margin-right:0;}#yiv6407076467 div.yiv6407076467attach-table div div a {text-decoration:none;}#yiv6407076467 div.yiv6407076467attach-table {width:400px;}#yiv6407076467 div.yiv6407076467file-title a, #yiv6407076467 div.yiv6407076467file-title a:active, #yiv6407076467 div.yiv6407076467file-title a:hover, #yiv6407076467 div.yiv6407076467file-title a:visited {text-decoration:none;}#yiv6407076467 div.yiv6407076467photo-title a, #yiv6407076467 div.yiv6407076467photo-title a:active, #yiv6407076467 div.yiv6407076467photo-title a:hover, #yiv6407076467 div.yiv6407076467photo-title a:visited {text-decoration:none;}#yiv6407076467 div#yiv6407076467ygrp-mlmsg #yiv6407076467ygrp-msg p a span.yiv6407076467yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6407076467 .yiv6407076467green {color:#628c2a;}#yiv6407076467 .yiv6407076467MsoNormal {margin:0 0 0 0;}#yiv6407076467 o {font-size:0;}#yiv6407076467 #yiv6407076467photos div {float:left;width:72px;}#yiv6407076467 #yiv6407076467photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6407076467 #yiv6407076467photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6407076467 #yiv6407076467reco-category {font-size:77%;}#yiv6407076467 #yiv6407076467reco-desc {font-size:77%;}#yiv6407076467 .yiv6407076467replbq {margin:4px;}#yiv6407076467 #yiv6407076467ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6407076467 #yiv6407076467ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6407076467 #yiv6407076467ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6407076467 #yiv6407076467ygrp-mlmsg select, #yiv6407076467 input, #yiv6407076467 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6407076467 #yiv6407076467ygrp-mlmsg pre, #yiv6407076467 code {font:115% monospace;}#yiv6407076467 #yiv6407076467ygrp-mlmsg * {line-height:1.22em;}#yiv6407076467 #yiv6407076467ygrp-mlmsg #yiv6407076467logo {padding-bottom:10px;}#yiv6407076467 #yiv6407076467ygrp-msg p a {font-family:Verdana;}#yiv6407076467 #yiv6407076467ygrp-msg p#yiv6407076467attach-count span {color:#1E66AE;font-weight:700;}#yiv6407076467 #yiv6407076467ygrp-reco #yiv6407076467reco-head {color:#ff7900;font-weight:700;}#yiv6407076467 #yiv6407076467ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6407076467 #yiv6407076467ygrp-sponsor #yiv6407076467ov li a {font-size:130%;text-decoration:none;}#yiv6407076467 #yiv6407076467ygrp-sponsor #yiv6407076467ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6407076467 #yiv6407076467ygrp-sponsor #yiv6407076467ov ul {margin:0;padding:0 0 0 8px;}#yiv6407076467 #yiv6407076467ygrp-text {font-family:Georgia;}#yiv6407076467 #yiv6407076467ygrp-text p {margin:0 0 1em 0;}#yiv6407076467 #yiv6407076467ygrp-text tt {font-size:120%;}#yiv6407076467 #yiv6407076467ygrp-vital ul li:last-child {border-right:none !important;}#yiv6407076467
