excel formula: contoh borang input

COMPANY NAME : KULUMPANG DEV. CORPN. SDN BHDNO SYARIKAT : 23937-AOPERATING CENTER : LADANG SUBUROPERATING CENTER CODE : 027MONTH/YEAR : 0410 (mmyy :- e.i January 2010 type as 0110)

MANAGER'S NAME : CHIN TONG LAIDESIGNATION : MANAGER

DIV

01 ADP1608 127 171 12 HM0203 BGT7895 216 502 HM04 ACQ3446 144 170 12 SP05 ADT5893 150 220 4 SP06 ADT1535 70 110 HM070809 ADF2846 909 100 NS101112 BJR2145 243 320 15 NS13 ADP1614 96 100 8 HM14 AFG7090 240 320 18 NS15 AEB4417 208 349 4 HM1617 AFV7317 4764 524 HM18 ACX5230 594 33 SP19 ADS80542021 AGE2350 594 33 HM22 BKH4239 304 580 NS23 BKH5771 241 320 NS24 AGY3241 432 24 NS25262728293031323334353637

Vehicle Code

Registration No

Total Units of

WorkPetrol (Litre)

Lubricants (Litre)

383940

17 16 16 7 1616

DIESOLINE/PETROL (litre)


VEHICLE/MACHINE CODE


COPY & PASTE TOOLS

REMARKS PAGE LINK

PG1 OK

PG1 OKPG1 OKPG1 OKPG2 OK

PG2 OK


PG3 OKPG3 OK


TYPE OK IF DONE

IF NOT IN USE PLEASE STATE REASON.

0 16 16

EFS VLG 1

VEHICLE / MACHINE LOGDDE Prog : EFSLOGO

S/36 Procedure : EFSEDTJL

OPERATING CENTRE LADANG SUBUROPERATING CENTRE CODE 0 2 7

0 1 1 2 7 *

VEHICLE REGISTRATION NO. A D P 1 6 0 8 1 7 1 *

MONTH-YEAR 0 4 1 0 LUBRICANTS (litre) 1 2 *

Subhead Total Units HM

I C 2 3 0 1 2 3P M 4 5 2 0 1 0 4

VEHICLE/MACHINE CODE 1 5 TOTAL UNITS 2 0 8 *

VEHICLE REGISTRATION NO. A E B 4 4 1 7 3 4 9 *

MONTH-YEAR 0 4 1 0 LUBRICANTS (litre) 4 *


I C 2 3 0 1 1 3 9P M 4 5 2 0 6 9


VEHICLE REGISTRATION NO. B G T 7 8 9 5 5 0 2 *

MONTH-YEAR 0 4 1 0 LUBRICANTS (litre) *


P M 3 7 2 0 2 1 6

VEHICLE/MACHINE CODE 0 6 TOTAL UNITS 7 0 *

VEHICLE REGISTRATION NO. A D T 1 5 3 5 1 1 0 *



I C 2 3 0 1 2 0P M 4 5 2 0 5 0

KULUMPANG DEV. CORPN. SDN BHD

NO SYARIKAT : 23937-A

LADANG SUBUR

VEHICLE/MACHINE CODE TOTAL UNITS


LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.


LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.


LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.


LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.

* No decimal place allowed.

CHIN TONG LAIK01123 MANAGER

EFS VLG 1




2 1 5 9 4 *

VEHICLE REGISTRATION NO. A G E 2 3 5 0 3 3 *



I C 1 0 0 3 5 9 4

VEHICLE/MACHINE CODE 1 7 TOTAL UNITS 4 7 6 4 *

VEHICLE REGISTRATION NO. A F V 7 3 1 7 5 2 4 *



I C 1 0 2 0 4 7 6 4


VEHICLE REGISTRATION NO. A D F 2 8 4 6 1 0 0 *


Subhead Total Units NS

I C 1 0 2 0 9 0 9


VEHICLE REGISTRATION NO. A G Y 3 2 4 1 2 4 *



I C 1 0 0 3 4 3 2



LADANG SUBUR



LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.


LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.


LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.


LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.


EFS VLG 1




1 8 TOTAL UNITS 5 9 4 *

VEHICLE REGISTRATION NO. A C X 5 2 3 0 3 3 *


Subhead Total Units SP

I C 1 0 0 3 5 9 4


VEHICLE REGISTRATION NO. A C Q 3 4 4 6 1 7 0 *



I C 2 3 0 1 4 6P R 1 0 A 1 8 2 0 5 7P R 1 0 A 1 4 2 0 4 1


VEHICLE REGISTRATION NO. A D T 5 8 9 3 2 2 0 *



I C 2 3 0 1 4 6P M 4 5 2 0 1 0 4

VEHICLE/MACHINE CODE 1 3 TOTAL UNITS 9 6 *

VEHICLE REGISTRATION NO. A D P 1 6 1 4 1 0 0 *



I C 2 3 0 1 3 6P R 1 0 A 1 8 2 0 6 0



LADANG SUBUR

CHIN TONG LAI



LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.


LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.


LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.


LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.


K01123 MANAGER

EFS VLG 1




1 2 2 4 3 *

VEHICLE REGISTRATION NO. B J R 2 1 4 5 3 2 0 *



I C 2 3 0 1 5 0P M 3 7 2 0 4 1P M 4 5 2 0 1 5 2


VEHICLE REGISTRATION NO. A F G 7 0 9 0 3 2 0 *



I C 2 3 0 1 4 8P M 3 7 2 0 5 3P M 4 5 2 0 1 3 9


B K H 5 7 7 1 3 2 0 *



I C 2 3 0 1 5 8P M 3 7 2 0 9 2P M 4 5 2 0 9 1


VEHICLE REGISTRATION NO. B K H 4 2 3 9 5 8 0 *



P M 3 7 2 0 3 0 4



LADANG SUBUR

CHIN TONG LAI



LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.


LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.

VEHICLE/MACHINE CODE DIESOLINE/PETROL (litre)

LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.


LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.


K01123 MANAGER

EFS VLG 1




1 9 TOTAL UNITS *

VEHICLE REGISTRATION NO. A D S 8 0 5 4 *


Subhead Total Units

VEHICLE/MACHINE CODE TOTAL UNITS *

VEHICLE REGISTRATION NO. *

MONTH-YEAR LUBRICANTS (litre) *

Subhead Total Units


VEHICLE REGISTRATION NO. ### ### ### ### ### *

MONTH-YEAR LUBRICANTS (litre) ### ### ### ### *

Subhead Total Units ###


VEHICLE REGISTRATION NO. ### ### ### ### ### *

MONTH-YEAR LUBRICANTS (litre) ### ### ### ### *

Subhead Total Units ###



LADANG SUBUR



LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.


LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.


LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.


LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.


excel formula: contoh borang input

Documents