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)

DIESOLINE/PETROL (litre)

VEHICLE/MACHINE CODE

VEHICLE/MACHINE CODE

COPY & PASTE TOOLS

REMARKS PAGE LINK

PG1 OK

PG1 OKPG1 OKPG1 OKPG2 OK

PG2 OK

PG2 OKPG2 OKPG3 OKPG3 OK

PG3 OKPG3 OK

PG4 OKPG4 OKPG4 OKPG4 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 *

Subhead Total Units HM

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

VEHICLE/MACHINE CODE 0 3 TOTAL UNITS 2 1 6 *

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

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

Subhead Total Units HM

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 *

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

Subhead Total Units HM

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

DIESOLINE/PETROL (litre)

LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.

DIESOLINE/PETROL (litre)

LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.

DIESOLINE/PETROL (litre)

LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.

DIESOLINE/PETROL (litre)

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

VEHICLE / MACHINE LOGDDE Prog : EFSLOGO

S/36 Procedure : EFSEDTJL

OPERATING CENTRE LADANG SUBUROPERATING CENTRE CODE 0 2 7

2 1 5 9 4 *

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

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

Subhead Total Units HM

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 *

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

Subhead Total Units HM

I C 1 0 2 0 4 7 6 4

VEHICLE/MACHINE CODE 0 9 TOTAL UNITS 9 0 9 *

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

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

Subhead Total Units NS

I C 1 0 2 0 9 0 9

VEHICLE/MACHINE CODE 2 4 TOTAL UNITS 4 3 2 *

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

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

Subhead Total Units NS

I C 1 0 0 3 4 3 2

KULUMPANG DEV. CORPN. SDN BHD

NO SYARIKAT : 23937-A

LADANG SUBUR

VEHICLE/MACHINE CODE TOTAL UNITS

DIESOLINE/PETROL (litre)

LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.

DIESOLINE/PETROL (litre)

LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.

DIESOLINE/PETROL (litre)

LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.

DIESOLINE/PETROL (litre)

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

VEHICLE / MACHINE LOGDDE Prog : EFSLOGO

S/36 Procedure : EFSEDTJL

OPERATING CENTRE LADANG SUBUROPERATING CENTRE CODE 0 2 7

1 8 TOTAL UNITS 5 9 4 *

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

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

Subhead Total Units SP

I C 1 0 0 3 5 9 4

VEHICLE/MACHINE CODE 0 4 TOTAL UNITS 1 4 4 *

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

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

Subhead Total Units SP

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/MACHINE CODE 0 5 TOTAL UNITS 1 5 0 *

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

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

Subhead Total Units SP

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 *

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

Subhead Total Units HM

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

KULUMPANG DEV. CORPN. SDN BHD

NO SYARIKAT : 23937-A

LADANG SUBUR

CHIN TONG LAI

VEHICLE/MACHINE CODE

DIESOLINE/PETROL (litre)

LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.

DIESOLINE/PETROL (litre)

LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.

DIESOLINE/PETROL (litre)

LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.

DIESOLINE/PETROL (litre)

LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.

* No decimal place allowed.

K01123 MANAGER

EFS VLG 1

VEHICLE / MACHINE LOGDDE Prog : EFSLOGO

S/36 Procedure : EFSEDTJL

OPERATING CENTRE LADANG SUBUROPERATING CENTRE CODE 0 2 7

1 2 2 4 3 *

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

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

Subhead Total Units NS

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

VEHICLE/MACHINE CODE 1 4 TOTAL UNITS 2 4 0 *

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

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

Subhead Total Units NS

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

VEHICLE/MACHINE CODE 2 3 TOTAL UNITS 2 4 1 *

B K H 5 7 7 1 3 2 0 *

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

Subhead Total Units NS

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

VEHICLE/MACHINE CODE 2 2 TOTAL UNITS 3 0 4 *

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

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

Subhead Total Units NS

P M 3 7 2 0 3 0 4

KULUMPANG DEV. CORPN. SDN BHD

NO SYARIKAT : 23937-A

LADANG SUBUR

CHIN TONG LAI

VEHICLE/MACHINE CODE TOTAL UNITS

DIESOLINE/PETROL (litre)

LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.

DIESOLINE/PETROL (litre)

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.

DIESOLINE/PETROL (litre)

LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.

* No decimal place allowed.

K01123 MANAGER

EFS VLG 1

VEHICLE / MACHINE LOGDDE Prog : EFSLOGO

S/36 Procedure : EFSEDTJL

OPERATING CENTRE LADANG SUBUROPERATING CENTRE CODE 0 2 7

1 9 TOTAL UNITS *

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

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

Subhead Total Units

VEHICLE/MACHINE CODE TOTAL UNITS *

VEHICLE REGISTRATION NO. *

MONTH-YEAR LUBRICANTS (litre) *

Subhead Total Units

VEHICLE/MACHINE CODE TOTAL UNITS *

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

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

Subhead Total Units ###

VEHICLE/MACHINE CODE TOTAL UNITS *

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

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

Subhead Total Units ###

KULUMPANG DEV. CORPN. SDN BHD

NO SYARIKAT : 23937-A

LADANG SUBUR

VEHICLE/MACHINE CODE

DIESOLINE/PETROL (litre)

LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.

DIESOLINE/PETROL (litre)

LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.

DIESOLINE/PETROL (litre)

LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.

DIESOLINE/PETROL (litre)

LedgerA/c No.

Exp.Class

Area/GradeCode

ItemNo.

Rate Per UnitRM

VLA/c No.

* No decimal place allowed.

CHIN TONG LAIK01123 MANAGER