Appendix Thread 2. ( Codes for other Threads, HTML Tables, etc.)

[DocAElstein]

To support solution to this Thread:
http://www.excelfox.com/forum/showth...and-send-email


Test data supplied by Thainguyen for this Thread :
http://www.excelfox.com/forum/showth...and-send-email

Using Excel 2007 32 bit
Row\Col
A
B
C
D
E
F
G
H
I
J
K
N

1
Equipment PM












2
Machine EQ.ID
Manufacture
Model
Description
Serial Number
Weekly
 Date of Service
Weekly
 Next Service 
Monthly
Date of Service
Monthly 
Next  Service
Quarterly
Date of Service
Quarterly 
Next Service
Softwear 

3













4
1
JUKI
GKG GL
GL SCREEN PRINTER
A123
06.04.2018
13.04.2018
15.03.2018
12.04.2018
N/A
N/A


5
2
JUKI
KE-1070L
SMT Placement Machine
A124
11.04.2018
18.04.2018
28.03.2018
25.04.2018
N/A
N/A


6
9
ACE Production
KISS-101B
Selective  Wave Solder
A125
06.04.2018
13.04.2018
15.03.2018
12.04.2018
N/A
N/A


7
59
Heller
1826 MK5
Reflow Oven
A126
N/A
N/A
16.03.2018
13.04.2018
N/A
N/A


8
62
Exit Sign -- N/A -- Exit Lights
N/A
N/A
A127
N/A
N/A
N/A
N/A
N/A
N/A


9
69
South-Tek System
N2-Gen 35ST
Nitrogen Generator
A128
10.04.2018
17.04.2018
N/A
N/A
09.03.2018
06.04.2018


10
75
ACE Production
KISS-102
Selective  Wave Solder
A129
16.04.2018
23.04.2018
N/A
N/A
N/A
N/A


11
101
FKN system
N100 Nibbler
Dispensing
A130
N/A
N/A
N/A
N/A
04.04.2018
02.05.2018


12
109
Mycronic
MY200sx
SMT Machine
A131
N/A
N/A
N/A
N/A
N/A
N/A


13
112
X-TEK
XTV-160
X-Ray System
A132
N/A
N/A
N/A
N/A
N/A
N/A


14
113
MIRTEC
MV-6 OMNI
AOI
A133
N/A
N/A
N/A
N/A
N/A
N/A


15
116
JUKI
KE-2060RL
SMT Placement Machine
A134
N/A
N/A
N/A
N/A
N/A
N/A


16
127
ELGI
EG22-150
Air Compressor
A135
N/A
N/A
N/A
N/A
N/A
N/A


17
128
Juki
KE-2050
SMT
A136
N/A
N/A
N/A
N/A
N/A
N/A


18
137
Juki
K3
Screen printer
A137
06.04.2018
13.04.2018
N/A
N/A
N/A
N/A


19
141
Heller
1826 MK5
Reflow Oven
A138
N/A
N/A
N/A
N/A
N/A
N/A


20
142
NISSAN
MCU-112A331.V
Forklift
A139
N/A
N/A
N/A
N/A
15.02.2018
15.03.2018


21
142
NISSAN/yearly oil change and lube
MCU-112A331.V
Forklift
A140
N/A
N/A
N/A
N/A
N/A
N/A


22










28.01.1900


23














Worksheet: Equipment PM