Assalamu'alaikum Mr. Kid, setelah saya membaca kiriman file tersebut saya masih belum bisa bagiamana cara membuat grapik tersebut atau step-step langkah pembuatannya dan berikut filenya yang sudah saya tambah dengan code status sebenarnya. WassalamSamsudin
Pada Minggu, 12 Juni 2016 18:38, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
Wa'alaikumussalam wr wb
Hai Samsudin,
Biasanya, data seperti kolom Status milik Anda ini sudah memiliki daftar isian
standard beserta definisi setiap isian. Jadi, user biasanya menuliskan status
tersebut berdasar bunyi-bunyi teks standar yang sudah ditetapkan dan disepakati.
Dengan meletakkan daftar teks status standar (semua item) disebuah sheet
referensi, maka bisa lebih mudah penyusunan outputnya (misal untuk monitoring
seperti dashboard dsb).
Contohnya adalah file terlampir.
Wassalamu'alaikum wr wb
Kid
2016-06-11 7:44 GMT+07:00 Samsudin Sam [email protected] [belajar-excel]
<[email protected]>:
Assalamu'alaikum
Master Excel,
Mohon bantuan dan pencerahan untuk masalah code status.
Sebelumnya saya mengucapkan terima kasih atas pencerahannya.
Wassalam
Samsudin
#yiv3787672237 #yiv3787672237 -- #yiv3787672237ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3787672237
#yiv3787672237ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3787672237
#yiv3787672237ygrp-mkp #yiv3787672237hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3787672237 #yiv3787672237ygrp-mkp #yiv3787672237ads
{margin-bottom:10px;}#yiv3787672237 #yiv3787672237ygrp-mkp .yiv3787672237ad
{padding:0 0;}#yiv3787672237 #yiv3787672237ygrp-mkp .yiv3787672237ad p
{margin:0;}#yiv3787672237 #yiv3787672237ygrp-mkp .yiv3787672237ad a
{color:#0000ff;text-decoration:none;}#yiv3787672237 #yiv3787672237ygrp-sponsor
#yiv3787672237ygrp-lc {font-family:Arial;}#yiv3787672237
#yiv3787672237ygrp-sponsor #yiv3787672237ygrp-lc #yiv3787672237hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3787672237
#yiv3787672237ygrp-sponsor #yiv3787672237ygrp-lc .yiv3787672237ad
{margin-bottom:10px;padding:0 0;}#yiv3787672237 #yiv3787672237actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3787672237
#yiv3787672237activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3787672237
#yiv3787672237activity span {font-weight:700;}#yiv3787672237
#yiv3787672237activity span:first-child
{text-transform:uppercase;}#yiv3787672237 #yiv3787672237activity span a
{color:#5085b6;text-decoration:none;}#yiv3787672237 #yiv3787672237activity span
span {color:#ff7900;}#yiv3787672237 #yiv3787672237activity span
.yiv3787672237underline {text-decoration:underline;}#yiv3787672237
.yiv3787672237attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3787672237 .yiv3787672237attach div a
{text-decoration:none;}#yiv3787672237 .yiv3787672237attach img
{border:none;padding-right:5px;}#yiv3787672237 .yiv3787672237attach label
{display:block;margin-bottom:5px;}#yiv3787672237 .yiv3787672237attach label a
{text-decoration:none;}#yiv3787672237 blockquote {margin:0 0 0
4px;}#yiv3787672237 .yiv3787672237bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3787672237
.yiv3787672237bold a {text-decoration:none;}#yiv3787672237 dd.yiv3787672237last
p a {font-family:Verdana;font-weight:700;}#yiv3787672237 dd.yiv3787672237last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3787672237
dd.yiv3787672237last p span.yiv3787672237yshortcuts
{margin-right:0;}#yiv3787672237 div.yiv3787672237attach-table div div a
{text-decoration:none;}#yiv3787672237 div.yiv3787672237attach-table
{width:400px;}#yiv3787672237 div.yiv3787672237file-title a, #yiv3787672237
div.yiv3787672237file-title a:active, #yiv3787672237
div.yiv3787672237file-title a:hover, #yiv3787672237 div.yiv3787672237file-title
a:visited {text-decoration:none;}#yiv3787672237 div.yiv3787672237photo-title a,
#yiv3787672237 div.yiv3787672237photo-title a:active, #yiv3787672237
div.yiv3787672237photo-title a:hover, #yiv3787672237
div.yiv3787672237photo-title a:visited {text-decoration:none;}#yiv3787672237
div#yiv3787672237ygrp-mlmsg #yiv3787672237ygrp-msg p a
span.yiv3787672237yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3787672237
.yiv3787672237green {color:#628c2a;}#yiv3787672237 .yiv3787672237MsoNormal
{margin:0 0 0 0;}#yiv3787672237 o {font-size:0;}#yiv3787672237
#yiv3787672237photos div {float:left;width:72px;}#yiv3787672237
#yiv3787672237photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv3787672237
#yiv3787672237photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3787672237
#yiv3787672237reco-category {font-size:77%;}#yiv3787672237
#yiv3787672237reco-desc {font-size:77%;}#yiv3787672237 .yiv3787672237replbq
{margin:4px;}#yiv3787672237 #yiv3787672237ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3787672237 #yiv3787672237ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3787672237
#yiv3787672237ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3787672237
#yiv3787672237ygrp-mlmsg select, #yiv3787672237 input, #yiv3787672237 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3787672237
#yiv3787672237ygrp-mlmsg pre, #yiv3787672237 code {font:115%
monospace;}#yiv3787672237 #yiv3787672237ygrp-mlmsg *
{line-height:1.22em;}#yiv3787672237 #yiv3787672237ygrp-mlmsg #yiv3787672237logo
{padding-bottom:10px;}#yiv3787672237 #yiv3787672237ygrp-msg p a
{font-family:Verdana;}#yiv3787672237 #yiv3787672237ygrp-msg
p#yiv3787672237attach-count span {color:#1E66AE;font-weight:700;}#yiv3787672237
#yiv3787672237ygrp-reco #yiv3787672237reco-head
{color:#ff7900;font-weight:700;}#yiv3787672237 #yiv3787672237ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3787672237 #yiv3787672237ygrp-sponsor
#yiv3787672237ov li a {font-size:130%;text-decoration:none;}#yiv3787672237
#yiv3787672237ygrp-sponsor #yiv3787672237ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3787672237
#yiv3787672237ygrp-sponsor #yiv3787672237ov ul {margin:0;padding:0 0 0
8px;}#yiv3787672237 #yiv3787672237ygrp-text
{font-family:Georgia;}#yiv3787672237 #yiv3787672237ygrp-text p {margin:0 0 1em
0;}#yiv3787672237 #yiv3787672237ygrp-text tt {font-size:120%;}#yiv3787672237
#yiv3787672237ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3787672237
re-Code Status.xlsx
Description: application/download
