Dear Fran,
Berikut filenya..Jika mengacu ke system FIFO(first In First Out) ini 
memungkinkan, artinya si penjaga parkir harus bisa menetapkan setiap mobil yang 
masuk untuk di parkirkan di pakiran nomer berapa.


TerimaKasih. 

    Pada Rabu, 1 Maret 2017 17:06, "[email protected] [belajar-excel]" 
<[email protected]> menulis:
 

     Dear Bapak Susilo
mohon maaf kurang jelas infonya.untuk parkir mobilnya, tidak perlu no urut.21 
harus di no 1, untuk parkirnya bebas, yang mana dulu kosong,misal no 1 sudah 
keluar, tapi urutan masih di no 10, no 10 bisa di parkir no 1 lagi. dan 
seterusnyasemoga dapat diterima dengan baik.
thxFran Riku
  #yiv4379686061 #yiv4379686061 -- #yiv4379686061ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4379686061 
#yiv4379686061ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4379686061 
#yiv4379686061ygrp-mkp #yiv4379686061hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv4379686061 #yiv4379686061ygrp-mkp #yiv4379686061ads 
{margin-bottom:10px;}#yiv4379686061 #yiv4379686061ygrp-mkp .yiv4379686061ad 
{padding:0 0;}#yiv4379686061 #yiv4379686061ygrp-mkp .yiv4379686061ad p 
{margin:0;}#yiv4379686061 #yiv4379686061ygrp-mkp .yiv4379686061ad a 
{color:#0000ff;text-decoration:none;}#yiv4379686061 #yiv4379686061ygrp-sponsor 
#yiv4379686061ygrp-lc {font-family:Arial;}#yiv4379686061 
#yiv4379686061ygrp-sponsor #yiv4379686061ygrp-lc #yiv4379686061hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4379686061 
#yiv4379686061ygrp-sponsor #yiv4379686061ygrp-lc .yiv4379686061ad 
{margin-bottom:10px;padding:0 0;}#yiv4379686061 #yiv4379686061actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4379686061 
#yiv4379686061activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4379686061
 #yiv4379686061activity span {font-weight:700;}#yiv4379686061 
#yiv4379686061activity span:first-child 
{text-transform:uppercase;}#yiv4379686061 #yiv4379686061activity span a 
{color:#5085b6;text-decoration:none;}#yiv4379686061 #yiv4379686061activity span 
span {color:#ff7900;}#yiv4379686061 #yiv4379686061activity span 
.yiv4379686061underline {text-decoration:underline;}#yiv4379686061 
.yiv4379686061attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv4379686061 .yiv4379686061attach div a 
{text-decoration:none;}#yiv4379686061 .yiv4379686061attach img 
{border:none;padding-right:5px;}#yiv4379686061 .yiv4379686061attach label 
{display:block;margin-bottom:5px;}#yiv4379686061 .yiv4379686061attach label a 
{text-decoration:none;}#yiv4379686061 blockquote {margin:0 0 0 
4px;}#yiv4379686061 .yiv4379686061bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4379686061 
.yiv4379686061bold a {text-decoration:none;}#yiv4379686061 dd.yiv4379686061last 
p a {font-family:Verdana;font-weight:700;}#yiv4379686061 dd.yiv4379686061last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4379686061 
dd.yiv4379686061last p span.yiv4379686061yshortcuts 
{margin-right:0;}#yiv4379686061 div.yiv4379686061attach-table div div a 
{text-decoration:none;}#yiv4379686061 div.yiv4379686061attach-table 
{width:400px;}#yiv4379686061 div.yiv4379686061file-title a, #yiv4379686061 
div.yiv4379686061file-title a:active, #yiv4379686061 
div.yiv4379686061file-title a:hover, #yiv4379686061 div.yiv4379686061file-title 
a:visited {text-decoration:none;}#yiv4379686061 div.yiv4379686061photo-title a, 
#yiv4379686061 div.yiv4379686061photo-title a:active, #yiv4379686061 
div.yiv4379686061photo-title a:hover, #yiv4379686061 
div.yiv4379686061photo-title a:visited {text-decoration:none;}#yiv4379686061 
div#yiv4379686061ygrp-mlmsg #yiv4379686061ygrp-msg p a 
span.yiv4379686061yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4379686061 
.yiv4379686061green {color:#628c2a;}#yiv4379686061 .yiv4379686061MsoNormal 
{margin:0 0 0 0;}#yiv4379686061 o {font-size:0;}#yiv4379686061 
#yiv4379686061photos div {float:left;width:72px;}#yiv4379686061 
#yiv4379686061photos div div {border:1px solid 
#666666;height:62px;overflow:hidden;width:62px;}#yiv4379686061 
#yiv4379686061photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4379686061
 #yiv4379686061reco-category {font-size:77%;}#yiv4379686061 
#yiv4379686061reco-desc {font-size:77%;}#yiv4379686061 .yiv4379686061replbq 
{margin:4px;}#yiv4379686061 #yiv4379686061ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv4379686061 #yiv4379686061ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4379686061 
#yiv4379686061ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4379686061 
#yiv4379686061ygrp-mlmsg select, #yiv4379686061 input, #yiv4379686061 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4379686061 
#yiv4379686061ygrp-mlmsg pre, #yiv4379686061 code {font:115% 
monospace;}#yiv4379686061 #yiv4379686061ygrp-mlmsg * 
{line-height:1.22em;}#yiv4379686061 #yiv4379686061ygrp-mlmsg #yiv4379686061logo 
{padding-bottom:10px;}#yiv4379686061 #yiv4379686061ygrp-msg p a 
{font-family:Verdana;}#yiv4379686061 #yiv4379686061ygrp-msg 
p#yiv4379686061attach-count span {color:#1E66AE;font-weight:700;}#yiv4379686061 
#yiv4379686061ygrp-reco #yiv4379686061reco-head 
{color:#ff7900;font-weight:700;}#yiv4379686061 #yiv4379686061ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv4379686061 #yiv4379686061ygrp-sponsor 
#yiv4379686061ov li a {font-size:130%;text-decoration:none;}#yiv4379686061 
#yiv4379686061ygrp-sponsor #yiv4379686061ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4379686061 
#yiv4379686061ygrp-sponsor #yiv4379686061ov ul {margin:0;padding:0 0 0 
8px;}#yiv4379686061 #yiv4379686061ygrp-text 
{font-family:Georgia;}#yiv4379686061 #yiv4379686061ygrp-text p {margin:0 0 1em 
0;}#yiv4379686061 #yiv4379686061ygrp-text tt {font-size:120%;}#yiv4379686061 
#yiv4379686061ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv4379686061 

   

Attachment: Menghitung Tempat Parkir_Toby1.xlsx
Description: MS-Excel 2007 spreadsheet

Kirim email ke