[belajar-excel] Digest Number 3800

Milis Belajar Microsoft Excel Group

5 Messages

Digest #3800

1

SUPERHERO LONCAT-LONCAT by "Nafiatul Adawiyah" nafiatula

2a

Minor loss of fidelity by "Harry" hariansyahptk

2b

Bls: [belajar-excel] Minor loss of fidelity [1 Attachment] by "odong nando"

3a

Re: Membuka cmd via code macro by "sofyan mujit"

4a

Re: Mohon bantuan... bagaimana membuat bullets and numbering di exce by "atin tnp"

Messages

1

SUPERHERO LONCAT-LONCAT

Mon Mar 21, 2016 3:16 am (PDT) . Posted by:

"Nafiatul Adawiyah" nafiatula

Assalamu`alaikum
Dear Be Excellersaya mau tanya mengenai jadwal produksiSebenarnya File-nya juga ambil di milis ini,Cuma saya renovasi sedkikityang ingin saya tanyakan apa bisa kita buat jadwal produksi yang tidak sesuai urutan (loncat-loncat)contoh :Order A 5000Order B 7500Order C 10000Kapasitas perharinya 1500kalau secara urutan,mungkin pengerjaannya ;A=3.3 hariB=5 hariC=6.6 hariitu jika prosedurnya kita kerjakan secara langsung / selesai sesuai order,,,(tanpa menghiraukan jenis order)berhubung dengan adanya MINIMAL STOK (sesuai permintaa marketing) maka,prosedurnya di ubah PENGERJAAN MASING-MASING ORDER DI BAGI 2 HARIcontoh :A di kerjakan selama 2 hari,setelah itu B akan di kerjakan selama 2 hari juga,begitupun juga Csetelah pekerjaan C selama 2 hari selesai,otomastis akan kembali ke A lagi untuk melanjutkan jumlah order yang belum terpenuhi ( karna A semestinya butuh waktu 3.3 hari)begitu seterusnya sampai Jumlah Order terpenuhi
Untuk lebih jelasnya saya lampirkan File-nyaAtas bantuannya saya ucapkan terima kasih( kalaupun ribet saya minta saran dan solusinya)

Wassalam Fia

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

2a

Minor loss of fidelity

Mon Mar 21, 2016 6:48 pm (PDT) . Posted by:

"Harry" hariansyahptk

Dear Be-Exceller,
Langsung ke point ya. Di Workbook yang sy buat selalu muncul "Minor loss of fidelity" setiap sy tekan tombol SAVE.Mohon informasi dan solusi dari rekan-rekan master Be-Exceller.
Terima kasih & Wassalam,

Harry

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2b

Bls: [belajar-excel] Minor loss of fidelity [1 Attachment]

Tue Mar 22, 2016 1:22 am (PDT) . Posted by:

"odong nando"

anda memakai excel 2007 atau versi terbarunya, sementara file excel anda adalah file excel 2007 kebawah (2003, 2002,2000, atau yang lebih lama). 
save as dengan format .xls menjadi .xlsx agar pesan tersebut tidak muncul kembali.
atau klik ( unchecklist ) check chcompability when saving this workbook, bila ingin tetap mempertahankan format .xls br,

odong nando


Pada Selasa, 22 Maret 2016 8:48, "Harry hariansyahptk@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Dear Be-Exceller,
Langsung ke point ya. Di Workbook yang sy buat selalu muncul "Minor loss of fidelity" setiap sy tekan tombol SAVE.Mohon informasi dan solusi dari rekan-rekan master Be-Exceller.
Terima kasih & Wassalam,

Harry #yiv0164951019 #yiv0164951019 -- #yiv0164951019ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0164951019 #yiv0164951019ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0164951019 #yiv0164951019ygrp-mkp #yiv0164951019hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0164951019 #yiv0164951019ygrp-mkp #yiv0164951019ads {margin-bottom:10px;}#yiv0164951019 #yiv0164951019ygrp-mkp .yiv0164951019ad {padding:0 0;}#yiv0164951019 #yiv0164951019ygrp-mkp .yiv0164951019ad p {margin:0;}#yiv0164951019 #yiv0164951019ygrp-mkp .yiv0164951019ad a {color:#0000ff;text-decoration:none;}#yiv0164951019 #yiv0164951019ygrp-sponsor #yiv0164951019ygrp-lc {font-family:Arial;}#yiv0164951019 #yiv0164951019ygrp-sponsor #yiv0164951019ygrp-lc #yiv0164951019hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0164951019 #yiv0164951019ygrp-sponsor #yiv0164951019ygrp-lc .yiv0164951019ad {margin-bottom:10px;padding:0 0;}#yiv0164951019 #yiv0164951019actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0164951019 #yiv0164951019activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0164951019 #yiv0164951019activity span {font-weight:700;}#yiv0164951019 #yiv0164951019activity span:first-child {text-transform:uppercase;}#yiv0164951019 #yiv0164951019activity span a {color:#5085b6;text-decoration:none;}#yiv0164951019 #yiv0164951019activity span span {color:#ff7900;}#yiv0164951019 #yiv0164951019activity span .yiv0164951019underline {text-decoration:underline;}#yiv0164951019 .yiv0164951019attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0164951019 .yiv0164951019attach div a {text-decoration:none;}#yiv0164951019 .yiv0164951019attach img {border:none;padding-right:5px;}#yiv0164951019 .yiv0164951019attach label {display:block;margin-bottom:5px;}#yiv0164951019 .yiv0164951019attach label a {text-decoration:none;}#yiv0164951019 blockquote {margin:0 0 0 4px;}#yiv0164951019 .yiv0164951019bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0164951019 .yiv0164951019bold a {text-decoration:none;}#yiv0164951019 dd.yiv0164951019last p a {font-family:Verdana;font-weight:700;}#yiv0164951019 dd.yiv0164951019last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0164951019 dd.yiv0164951019last p span.yiv0164951019yshortcuts {margin-right:0;}#yiv0164951019 div.yiv0164951019attach-table div div a {text-decoration:none;}#yiv0164951019 div.yiv0164951019attach-table {width:400px;}#yiv0164951019 div.yiv0164951019file-title a, #yiv0164951019 div.yiv0164951019file-title a:active, #yiv0164951019 div.yiv0164951019file-title a:hover, #yiv0164951019 div.yiv0164951019file-title a:visited {text-decoration:none;}#yiv0164951019 div.yiv0164951019photo-title a, #yiv0164951019 div.yiv0164951019photo-title a:active, #yiv0164951019 div.yiv0164951019photo-title a:hover, #yiv0164951019 div.yiv0164951019photo-title a:visited {text-decoration:none;}#yiv0164951019 div#yiv0164951019ygrp-mlmsg #yiv0164951019ygrp-msg p a span.yiv0164951019yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0164951019 .yiv0164951019green {color:#628c2a;}#yiv0164951019 .yiv0164951019MsoNormal {margin:0 0 0 0;}#yiv0164951019 o {font-size:0;}#yiv0164951019 #yiv0164951019photos div {float:left;width:72px;}#yiv0164951019 #yiv0164951019photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0164951019 #yiv0164951019photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0164951019 #yiv0164951019reco-category {font-size:77%;}#yiv0164951019 #yiv0164951019reco-desc {font-size:77%;}#yiv0164951019 .yiv0164951019replbq {margin:4px;}#yiv0164951019 #yiv0164951019ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0164951019 #yiv0164951019ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0164951019 #yiv0164951019ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0164951019 #yiv0164951019ygrp-mlmsg select, #yiv0164951019 input, #yiv0164951019 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0164951019 #yiv0164951019ygrp-mlmsg pre, #yiv0164951019 code {font:115% monospace;}#yiv0164951019 #yiv0164951019ygrp-mlmsg * {line-height:1.22em;}#yiv0164951019 #yiv0164951019ygrp-mlmsg #yiv0164951019logo {padding-bottom:10px;}#yiv0164951019 #yiv0164951019ygrp-msg p a {font-family:Verdana;}#yiv0164951019 #yiv0164951019ygrp-msg p#yiv0164951019attach-count span {color:#1E66AE;font-weight:700;}#yiv0164951019 #yiv0164951019ygrp-reco #yiv0164951019reco-head {color:#ff7900;font-weight:700;}#yiv0164951019 #yiv0164951019ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0164951019 #yiv0164951019ygrp-sponsor #yiv0164951019ov li a {font-size:130%;text-decoration:none;}#yiv0164951019 #yiv0164951019ygrp-sponsor #yiv0164951019ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0164951019 #yiv0164951019ygrp-sponsor #yiv0164951019ov ul {margin:0;padding:0 0 0 8px;}#yiv0164951019 #yiv0164951019ygrp-text {font-family:Georgia;}#yiv0164951019 #yiv0164951019ygrp-text p {margin:0 0 1em 0;}#yiv0164951019 #yiv0164951019ygrp-text tt {font-size:120%;}#yiv0164951019 #yiv0164951019ygrp-vital ul li:last-child {border-right:none !important;}#yiv0164951019

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

3a

Re: Membuka cmd via code macro

Mon Mar 21, 2016 6:53 pm (PDT) . Posted by:

"sofyan mujit"

Sub CMD()
On Error Resume Next
Call Shell("cmd.exe", vbNormalFocus)
End

Pada 21 Maret 2016 14.26, Heru Adi hr_adhi@yahoo.com [belajar-excel] <
belajar-excel@yahoogroups.com> menulis:

>
>
> Assalamu'alaikum .
> Rekan-rekan saya mau bertanya , apakan membuka jendela Command prompt via
> code marco bisa dilakukan ?
> Jika bisa mohon di beri contoh kodenya . Terima kasih sebelumnya.
>
> Heru Adhi S
>
> Dikirim dari Yahoo Mail pada Android
> <https://overview.mail.yahoo.com/mobile/?.src=Android>
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

4a

Re: Mohon bantuan... bagaimana membuat bullets and numbering di exce

Tue Mar 22, 2016 1:39 am (PDT) . Posted by:

"atin tnp"

Dear Admin,
Mohon maaf, mohon saya di keluarkan dari group milist ini krn sy tdk bisa aktif dan terus mengikuti.
Terima Kasih


------- M o d e r a t o r --------


Untuk keluar dari milis silakan kirim email kosong ke:

belajar-excel-unsubscribe@yahoogroups.com mailto:belajar-excel-unsubscribe@yahoogroups.com



---------------------------------------


On Mar 21, 2016 2:49 PM, "Dody Irawan dodyirawan84@gmail.com mailto:dodyirawan84@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com mailto:belajar-excel@yahoogroups.com> wrote:

Assalamualaiakum...

Mohon bantuan lagi kpd para master excel berpengalaman...




Bagaimana cara membuat bullets and numbering dalam 1 sel.




Terimakasih.

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• New Members 3

• Privacy • Unsubscribe • Terms of Use