Sebagai tambahan informasi Jika pada tahun 2019 ada rencana penggantian tetapi 
belum ada realisasi penggantian maka rencana penggantian di tahun 2020 
mengikuti rencana penggantian, tetapi kalau di tahun 2019 sudah ada realisasi 
penggantian maka rencana penggantian berdasarkan realisasi penggantian. Antara 
rencana dan realisasi belum tentu di bulan yang sama (sesuai rencana 
penggantian)

Dikirim dari Yahoo Mail di Android

  Pada Min, 13 Okt 2019 pada 13:59, Marsidi MP marsidi.2...@gmail.com 
[belajar-excel]<belajar-excel@yahoogroups.com> menulis:    

Para master, tolong formula untuk kasus seperti ini  #yiv0531014555 
#yiv0531014555 -- #yiv0531014555ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0531014555 
#yiv0531014555ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0531014555 
#yiv0531014555ygrp-mkp #yiv0531014555hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv0531014555 #yiv0531014555ygrp-mkp #yiv0531014555ads 
{margin-bottom:10px;}#yiv0531014555 #yiv0531014555ygrp-mkp .yiv0531014555ad 
{padding:0 0;}#yiv0531014555 #yiv0531014555ygrp-mkp .yiv0531014555ad p 
{margin:0;}#yiv0531014555 #yiv0531014555ygrp-mkp .yiv0531014555ad a 
{color:#0000ff;text-decoration:none;}#yiv0531014555 #yiv0531014555ygrp-sponsor 
#yiv0531014555ygrp-lc {font-family:Arial;}#yiv0531014555 
#yiv0531014555ygrp-sponsor #yiv0531014555ygrp-lc #yiv0531014555hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0531014555 
#yiv0531014555ygrp-sponsor #yiv0531014555ygrp-lc .yiv0531014555ad 
{margin-bottom:10px;padding:0 0;}#yiv0531014555 #yiv0531014555actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0531014555 
#yiv0531014555activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0531014555
 #yiv0531014555activity span {font-weight:700;}#yiv0531014555 
#yiv0531014555activity span:first-child 
{text-transform:uppercase;}#yiv0531014555 #yiv0531014555activity span a 
{color:#5085b6;text-decoration:none;}#yiv0531014555 #yiv0531014555activity span 
span {color:#ff7900;}#yiv0531014555 #yiv0531014555activity span 
.yiv0531014555underline {text-decoration:underline;}#yiv0531014555 
.yiv0531014555attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv0531014555 .yiv0531014555attach div a 
{text-decoration:none;}#yiv0531014555 .yiv0531014555attach img 
{border:none;padding-right:5px;}#yiv0531014555 .yiv0531014555attach label 
{display:block;margin-bottom:5px;}#yiv0531014555 .yiv0531014555attach label a 
{text-decoration:none;}#yiv0531014555 blockquote {margin:0 0 0 
4px;}#yiv0531014555 .yiv0531014555bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0531014555 
.yiv0531014555bold a {text-decoration:none;}#yiv0531014555 dd.yiv0531014555last 
p a {font-family:Verdana;font-weight:700;}#yiv0531014555 dd.yiv0531014555last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0531014555 
dd.yiv0531014555last p span.yiv0531014555yshortcuts 
{margin-right:0;}#yiv0531014555 div...yiv0531014555attach-table div div a 
{text-decoration:none;}#yiv0531014555 div.yiv0531014555attach-table 
{width:400px;}#yiv0531014555 div.yiv0531014555file-title a, #yiv0531014555 
div.yiv0531014555file-title a:active, #yiv0531014555 
div.yiv0531014555file-title a:hover, #yiv0531014555 div.yiv0531014555file-title 
a:visited {text-decoration:none;}#yiv0531014555 div.yiv0531014555photo-title a, 
#yiv0531014555 div.yiv0531014555photo-title a:active, #yiv0531014555 
div.yiv0531014555photo-title a:hover, #yiv0531014555 
div.yiv0531014555photo-title a:visited {text-decoration:none;}#yiv0531014555 
div#yiv0531014555ygrp-mlmsg #yiv0531014555ygrp-msg p a 
span.yiv0531014555yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0531014555 
.yiv0531014555green {color:#628c2a;}#yiv0531014555 .yiv0531014555MsoNormal 
{margin:0 0 0 0;}#yiv0531014555 o {font-size:0;}#yiv0531014555 
#yiv0531014555photos div {float:left;width:72px;}#yiv0531014555 
#yiv0531014555photos div div {border:1px solid 
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv0531014555 
#yiv0531014555photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0531014555
 #yiv0531014555reco-category {font-size:77%;}#yiv0531014555 
#yiv0531014555reco-desc {font-size:77%;}#yiv0531014555 .yiv0531014555replbq 
{margin:4px;}#yiv0531014555 #yiv0531014555ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv0531014555 #yiv0531014555ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0531014555 
#yiv0531014555ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0531014555 
#yiv0531014555ygrp-mlmsg select, #yiv0531014555 input, #yiv0531014555 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0531014555 
#yiv0531014555ygrp-mlmsg pre, #yiv0531014555 code {font:115% 
monospace;}#yiv0531014555 #yiv0531014555ygrp-mlmsg * 
{line-height:1.22em;}#yiv0531014555 #yiv0531014555ygrp-mlmsg #yiv0531014555logo 
{padding-bottom:10px;}#yiv0531014555 #yiv0531014555ygrp-msg p a 
{font-family:Verdana;}#yiv0531014555 #yiv0531014555ygrp-msg 
p#yiv0531014555attach-count span {color:#1E66AE;font-weight:700;}#yiv0531014555 
#yiv0531014555ygrp-reco #yiv0531014555reco-head 
{color:#ff7900;font-weight:700;}#yiv0531014555 #yiv0531014555ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv0531014555 #yiv0531014555ygrp-sponsor 
#yiv0531014555ov li a {font-size:130%;text-decoration:none;}#yiv0531014555 
#yiv0531014555ygrp-sponsor #yiv0531014555ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0531014555 
#yiv0531014555ygrp-sponsor #yiv0531014555ov ul {margin:0;padding:0 0 0 
8px;}#yiv0531014555 #yiv0531014555ygrp-text 
{font-family:Georgia;}#yiv0531014555 #yiv0531014555ygrp-text p {margin:0 0 1em 
0;}#yiv0531014555 #yiv0531014555ygrp-text tt {font-size:120%;}#yiv0531014555 
#yiv0531014555ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv0531014555

Attachment: Penggantian Spare Part.xls
Description: MS-Excel spreadsheet

Kirim email ke