Dear P. Maulana,
tolong review rumusan bapak ini, ada beberapa textbox yang tidak punya
dasar perhitungan, padahal dia dipakai juga untuk proses yang lain.
lainkali jika ingin di review bareng, beri nama textbox yang mewakili
fieldnya pak, susah nge-trace-nya ...
pegel pisan ... :)
Description Text Table Value Agency
DAILY MAINTENANCE TIME 121 T_DAILY_PRODUCTION_DETAIL SUM(DELAY)/60
MAINT','SECTION','PC'
ELECTRICAL DOWNTIME 124 T_DAILY_PRODUCTION_DETAIL SUM(DELAY)/60
EL
HOLIDAY SHUTDOWN TIME 86 T_DAILY_PRODUCTION_DETAIL SUM(DELAY)/60
HD
MECHANICAL DOWNTIME 123 T_DAILY_PRODUCTION_DETAIL SUM(DELAY)/60
MK
OPERATION DOWNTIME 122 T_DAILY_PRODUCTION_DETAIL SUM(DELAY)/60
OP
PEAKHOUR SHUTDOWN 126 T_DAILY_PRODUCTION_DETAIL SUM(DELAY)/60
PK
PLANNED SHUTDOWN TIME 85 T_DAILY_PRODUCTION_DETAIL SUM(DELAY)/60
PS
UNCONTROLLABLE + MATERIAL + QC 125 T_DAILY_PRODUCTION_DETAIL
SUM(DELAY)/60 UNC','MAT','QC'
GAS CONSUMPTION ON COIL 127 T_FUEL_CONSUMPTION SUM(GAS) /
{COBBLE}
POWER CONSUMPTION 128 T_FUEL_CONSUMPTION SUM(POWER) / {COBBLE}
COBBLE 42 T_PROFILE_ROLLED SUM(COBBLES)*100/SUM(BILLETS_ROLLED)
PRODUCTION 40 T_PROFILE_ROLLED
SUM(BILLETS_ROLLED)-SUM(COBBLES)-SUM(THROWN_OUT))*1.308
YIELD - BILLET/WIRE ROD 129 T_PROFILE_ROLLED {COBBLE} * 100 /
SUM(BILLETS_ROLLED)*1.325
ACTUAL ROLLING TIME 89 {AVAILABLE ROLLING TIME} - {DAILY MAINTENANCE
TIME} - {OPERATION DOWNTIME} - {MECHANICAL DOWNTIME} - {ELECTRICAL
DOWNTIME} - {UNCONTROLLABLE + MATERIAL + QC}
ACTUAL ROLLING TIME - DAILY 81 {ACTUAL ROLLING TIME} / {AVAILABLE
ROLLING DAYS}
AVAILABLE ROLLING DAYS 87 ({AVAILABLE ROLLING TIME} + {PEAKHOUR
SHUTDOWN}) / 24
AVAILABLE ROLLING TIME 88 {CALENDAR TIME} - {PLANNED SHUTDOWN TIME} -
{PEAKHOUR SHUTDOWN} - {HOLIDAY SHUTDOWN}
CALENDAR DAYS 83 ???
CALENDAR TIME 84 ???
HOLIDAYS 364 ???
ROLLING RATE 80 {PRODUCTION} / {ACTUAL ROLLING TIME}
UTILIZATION 353 {ACTUAL ROLLING TIME} * 100 / {AVAILABLE
ROLLING TIME}
aksan kurdin
On 5/24/2010 1:03 PM, Maulana wrote:
o y gimana nih kabarnya yg ini Bang. Aksan....
sangat d harap" cemas... :-)
----- Original Message -----
*From:* aksankurdin <mailto:[email protected]>
*To:* [email protected]
<mailto:[email protected]>
*Sent:* Saturday, May 22, 2010 2:21 PM
*Subject:* [belajar-access] Re: Default value
ngga ada, saya create sendiri, ngira2 ....
aksan kurdin
--- In [email protected]
<mailto:[email protected]>, "Maulana"
<maulana_...@...> wrote:
>
> disana sudah di sertakan semua kalau ngga salah...Bang
>
>
> ----- Original Message -----
> From: Aksan Kurdin
> To: [email protected]
<mailto:[email protected]>
> Sent: Friday, May 21, 2010 5:49 PM
> Subject: Re: [belajar-access] Default value
>
>
>
> Nilai Agency di T_DAILY_PRODUCTION_DETAIL ada master kan ?
sekalian di kopikan pak maulana.
>
> aksan kurdin
>
>
> On 5/20/2010 10:39 AM, Maulana wrote:
>
>
>
> Dear Bang Aksan, Haer
>
> dilampiran disertakan form yg kmrin belum terselesaikan,
> untuk itu ingin solusinya, trims atas bantuannya
>
> salam
>
