VBA-Forum - Das Forum zu Microsoft VBA

VBA Excel VBA Word VBA Access VBA VBScript VB C# Objective-C C++ SQL JAVA VBA (English) Jobs Übersicht

Thema	Datum	Von Nutzer	Rating	Antwort
Daten automatisch auslesen und auswerten	18.09.2017 10:30:56	Clemens Klasen
Daten automatisch auslesen und auswerten	18.09.2017 11:07:27	Gast10776
Mustermappe	18.09.2017 20:59:55	Gast70117

Ansicht des Beitrags:

Von:
Clemens Klasen

Datum:
18.09.2017 10:30:56

Views:
942

Rating:

Antwort:

Thema:
Daten automatisch auslesen und auswerten

Moin,

ich habe ein 'kleines' Problem. Ich würde gerne Daten aus einem Excel-Sheet auslesen und auswerten per VBA. Die Daten werden pro KW gezogen und im selben Ordner abgespeichert.

Die Daten werden in einer Spalte ausgegeben (Daten unten anhängend). Diese sollen in einem ersten Schritt automatisch in Spalten aufgeteilt werden. Die Daten sind durch Kommata getrennt.
Bei bestimmten Key-Words, wie 'placed components, 'Operation Time und , sollen dann die darunterstehenden Werte ausgelesen werden. Diese sollen als Summe ausgegeben werden. Für die Linie 1, welche sich in Maschine 1-3 unterteilt.. Dazu soll jeweils der 'Program Name ausgelesen werden.
Aufbau Tabellenblatt wäre idealerweise:

program Name Operation TimeM01-1 Out of Component Stop Time M01-1 Placed Components M01-1 program Name Operation TimeM02-1...

Kann mir da jemand helfen?

Ich bin für jede Hilfe dankbar.

Grüße

Clemens

Result Totalization List

Reservation File Name,Program Name,PWB ID,Planned Start Date,Planned Start Time,Planned End Date,Planned End Time,Planned No.,Production Start Date,Production Start Time,Production End Date,Production End Time,Produced

900-2317R Neso LT.rsv,"900-2317-1964R-Top_NESO-LT V1.1a GP CAN.iss","",6/9/2017,6:14:00 PM,---,---,250,7/13/2017,2:40:40 PM,7/17/2017,10:35:57 AM,250

900-2317R Neso LT2.rsv,"900-2317R-Bot_NESO-LT V1.1a GP RS485.iss","",6/9/2017,6:15:00 PM,---,---,250,7/17/2017,10:44:06 AM,7/18/2017,3:16:24 PM,250

900-2317R Neso LT2.rsv,"900-2317-1964R-Top_NESO-LT V1.1a GP CAN.iss","",6/9/2017,6:14:00 PM,---,---,250,7/18/2017,3:16:42 PM,7/19/2017,7:18:34 PM,249

900-2317R Neso LT2.rsv,"900-2317R-Bot_NESO-LT V1.1a GP RS485.iss","",6/9/2017,6:15:00 PM,---,---,251,7/19/2017,7:26:36 PM,7/20/2017,7:31:14 PM,233

Production Management Information

Program Name,Line Name,Machine Name,Produced,Operation Time,Mounting Percentage,Work Ratio,Picked Component Number,Placed Component Number,Total number of dispensing

900-2317-1964R-Top_NESO-LT V1.1a GP CAN.iss,"Line1","M01",250,08:11:41,99.96,35.65,85032,85000,***

900-2317-1964R-Top_NESO-LT V1.1a GP CAN.iss,"Line1","M02",250,08:06:06,99.98,37.42,58010,57998,***

900-2317-1964R-Top_NESO-LT V1.1a GP CAN.iss,"Line1","M03",250,09:18:35,99.93,42.99,22981,22966,***

900-2317R-Bot_NESO-LT V1.1a GP RS485.iss,"Line1","M01",250,11:03:52,99.98,54.99,134032,134000,***

900-2317R-Bot_NESO-LT V1.1a GP RS485.iss,"Line1","M02",250,10:20:05,99.98,52.60,99019,99000,***

900-2317R-Bot_NESO-LT V1.1a GP RS485.iss,"Line1","M03",250,10:59:53,99.96,56.42,47018,47000,***

900-2317-1964R-Top_NESO-LT V1.1a GP CAN.iss,"Line1","M01",249,08:10:50,99.95,41.66,84703,84658,***

900-2317-1964R-Top_NESO-LT V1.1a GP CAN.iss,"Line1","M02",249,08:14:12,99.99,41.90,57776,57768,***

900-2317-1964R-Top_NESO-LT V1.1a GP CAN.iss,"Line1","M03",249,09:15:38,99.94,47.16,22904,22890,***

900-2317R-Bot_NESO-LT V1.1a GP RS485.iss,"Line1","M01",233,09:39:51,99.98,61.85,124919,124888,***

900-2317R-Bot_NESO-LT V1.1a GP RS485.iss,"Line1","M02",233,09:34:56,99.94,60.63,92326,92268,***

900-2317R-Bot_NESO-LT V1.1a GP RS485.iss,"Line1","M03",233,10:08:13,99.89,63.88,43854,43804,***

Line1,"M01"

Machine Information

Produced,Produced (circuits),Pick Ratio,Retry Ratio,Place Ratio,Mounting Percentage,Work Ratio,Picked Component Number,Placed Component Number,Fiducial Mark Recognition Errors,Bad marks detected,Out of Component Stops,Area Fiducial Mark Errors,Production Start Time,Production End Time,Operation Time,Transport Wait Time (in),Transport Wait Time (out),Transport Wait Time,Quick Stop Time,Maintenance Time,Trouble Stop Time,Out of Component Stop Time,Stop Time

250,1000,99.87,0.13,99.84,99.96,35.65,85032,85000,0,0,0,0,7/13/2017 4:07 PM,7/17/2017 9:31 AM,08:11:41,04:30:45,05:26:28,10:12:56,02:02:43,00:01:20,00:02:48,01:59:54,02:04:03

Feeder Management Information

Bank,Component Name,Pick Tries,Picked Component Number,Placed Component Number,Pick Errors,Empty,Retry,Laser,Vision,Lead Bend,Dimension Error,Verify/sot,Tombstone,Coplanarity,Other,

F-03,"690-0877",1002,1000,1000,2,1,1,0,0,0,0,0,0,0,0

F-05,"240-0333",2029,2000,2000,29,9,9,0,0,0,0,0,0,0,0

F-07,"183-0020",2018,2009,2000,9,2,2,4,0,0,5,4,0,0,0

F-09,"240-0345",2003,2000,2000,3,1,1,0,0,0,0,0,0,0,0

F-11,"601-0056",2000,2000,2000,0,0,0,0,0,0,0,0,0,0,0

F-13,"150-0013",3000,3000,3000,0,0,0,0,0,0,0,0,0,0,0

F-15,"690-0632",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-17,"600-0027",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-19,"183-0082",1002,1000,1000,2,1,1,0,0,0,0,3,0,0,0

F-21,"182-0068",1003,1000,1000,3,1,1,0,0,0,0,2,0,0,0

F-23,"181-0081",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-49,"105-0007",5163,5159,5158,4,2,2,0,0,0,0,0,1,0,0

F-51,"105-0007",9850,9847,9842,3,1,1,1,0,0,0,0,4,0,0

F-53,"105-0001",1000,1000,1000,0,0,0,0,0,0,0,1,0,0,0

F-55,"184-0010",14218,14210,14208,8,3,3,0,0,0,2,0,0,0,0

F-57,"184-0010",15803,15793,15792,10,4,4,0,0,0,1,0,0,0,0

F-59,"184-0009",4003,4000,4000,3,1,1,0,0,0,0,4,0,0,0

R-40,"470-1015",1003,1000,1000,3,1,1,0,0,0,0,0,0,0,0

R-45,"470-0550",1002,1000,1000,2,2,2,0,0,0,0,0,0,0,0

R-47,"101-0001",1016,1000,1000,16,5,5,0,0,0,0,0,0,0,0

R-49,"105-0038",1001,1001,1000,0,0,0,1,0,0,0,1,0,0,0

R-51,"105-0035",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

R-53,"105-0037",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

R-55,"105-0045",1001,1001,1000,0,0,0,1,0,0,0,0,0,0,0

R-57,"180-0017",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

R-59,"105-0043",2007,2006,2000,1,0,0,0,0,0,0,0,6,0,0

R-61,"105-0039",1001,1001,1000,0,0,0,1,0,0,0,0,0,0,0

R-63,"101-0262",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

R-65,"105-0024",1002,1001,1000,1,0,0,0,0,0,0,0,1,0,0

R-67,"101-0109",1001,1000,1000,1,0,0,0,0,0,0,0,0,0,0

R-69,"101-0080",1007,1000,1000,7,2,2,0,0,0,0,0,0,0,0

R-71,"184-0028",1001,1000,1000,1,0,0,0,0,0,0,5,0,0,0

R-73,"184-0054",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

R-75,"105-0036",1004,1004,1000,0,0,0,0,0,0,0,0,4,0,0

Total,"",85140,85032,85000,108,36,36,8,0,0,8,20,16,0,0

Line1,"M02"

Machine Information

250,1000,99.81,0.19,99.79,99.98,37.42,58010,57998,0,0,0,0,7/3/2017 1:12 PM,7/17/2017 9:39 AM,08:06:06,03:47:02,06:58:14,11:01:55,01:32:04,00:02:09,00:04:32,01:27:32,01:34:17

Feeder Management Information

Bank,Component Name,Pick Tries,Picked Component Number,Placed Component Number,Pick Errors,Empty,Retry,Laser,Vision,Lead Bend,Dimension Error,Verify/sot,Tombstone,Coplanarity,Other,

F-03,"240-0167",1003,1001,1000,2,1,1,0,0,0,0,0,0,0,1

F-06,"230-0104",1006,1000,1000,6,3,3,0,0,0,0,0,0,0,0

F-09,"690-0164",1001,1001,1000,0,0,0,1,0,0,0,0,0,0,0

F-13,"690-0630",1002,1000,1000,2,1,1,0,0,0,0,0,0,0,0

F-17,"240-0030",1010,1001,1000,9,4,4,1,0,0,0,0,0,0,0

F-20,"105-0009",2000,2000,2000,0,0,0,0,0,0,0,0,0,0,0

F-22,"105-0033",2000,2000,2000,0,0,0,0,0,0,0,1,0,0,0

F-24,"105-0005",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-26,"180-0102",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-28,"184-0027",5051,5001,5000,50,0,0,0,0,0,1,1,0,0,0

F-30,"105-0019",3000,3000,3000,0,0,0,0,0,0,0,0,0,0,0

F-32,"105-0004",4006,4004,4000,2,0,0,2,0,0,0,0,2,0,0

F-34,"240-0352",15002,15000,15000,2,1,1,0,0,0,0,0,0,0,0

F-36,"180-0031",2003,2000,2000,3,1,1,0,0,0,0,0,0,0,0

F-40,"180-0091",12009,12000,12000,9,3,3,0,0,0,0,6,0,0,0

F-61,"601-0049",2004,2002,2000,2,0,0,2,0,0,0,0,0,0,2

R-57,"470-1551",1005,1001,1000,4,4,4,0,0,0,0,0,0,0,0

R-61,"470-0748",1001,998,998,3,3,3,0,0,0,0,0,0,0,0

R-64,"030-0023",1015,1001,1000,14,4,4,1,0,0,0,0,0,0,0

R-69,"470-1277",1001,1000,1000,1,1,1,0,0,0,0,0,0,0,0

Total,"",58119,58010,57998,109,26,26,7,0,0,1,8,2,0,3

Line1,"M03"

Machine Information

250,1000,99.51,0.49,99.44,99.93,42.99,22981,22966,0,0,72,0,7/3/2017 1:12 PM,7/17/2017 9:45 AM,09:18:35,03:12:53,01:29:31,04:59:08,05:59:28,00:31:22,00:00:04,05:59:24,06:30:52

Feeder Management Information

Bank,Component Name,Pick Tries,Picked Component Number,Placed Component Number,Pick Errors,Empty,Retry,Laser,Vision,Lead Bend,Dimension Error,Verify/sot,Tombstone,Coplanarity,Other,

F-03,"470-1291",1003,1000,1000,3,3,3,0,0,0,0,0,0,0,0

F-07,"240-0112",1004,998,998,6,3,3,0,0,0,0,0,0,0,0

F-18,"240-0270",2006,2000,2000,6,3,3,0,0,0,0,0,0,0,0

F-28,"180-0071",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-30,"184-0002",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-32,"105-0046",1003,1001,1000,2,1,1,0,0,0,0,0,1,0,0

F-36,"470-1053",1002,1000,1000,2,1,1,0,0,0,0,0,0,0,0

F-39,"600-0061",2000,2000,2000,0,0,0,0,0,0,0,0,0,0,0

F-42,"184-0029",1004,1001,1000,3,1,1,1,0,0,0,0,0,0,0

F-44,"181-0071",1003,1000,1000,3,1,1,0,0,0,0,4,0,0,0

F-48,"150-0016",3003,3000,3000,3,1,1,0,0,0,0,0,0,0,0

F-58,"240-0353",1010,1004,1000,6,0,0,2,0,0,2,0,0,0,0

R-33,"460-0239",1002,1000,1000,2,1,1,0,0,0,0,0,0,0,0

R-41,"906-0133",1015,1000,1000,15,3,3,0,0,0,0,0,0,0,0

R-46,"010-0058",1019,1000,999,19,5,5,0,0,0,0,0,0,0,1

R-49,"680-0136",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

R-56,"470-1119",1006,1003,1000,3,1,1,0,3,0,0,0,0,0,0

R-60,"470-1409",998,984,984,14,14,14,0,0,0,0,0,0,0,0

R-68,"470-0728",1017,990,985,27,27,27,0,5,0,0,0,0,0,0

Total,"",23095,22981,22966,114,65,65,3,8,0,2,4,1,0,1

Line1,"M01"

Machine Information

250,1000,99.84,0.16,99.81,99.98,54.99,134032,134000,0,0,0,0,7/17/2017 11:04 AM,7/18/2017 2:42 PM,11:03:52,02:38:07,02:08:14,05:04:27,02:56:32,00:07:44,00:11:17,02:45:15,03:04:18

Feeder Management Information

Bank,Component Name,Pick Tries,Picked Component Number,Placed Component Number,Pick Errors,Empty,Retry,Laser,Vision,Lead Bend,Dimension Error,Verify/sot,Tombstone,Coplanarity,Other,

F-25,"630-0044",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-27,"105-0018",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-29,"105-0003",1002,1001,1000,1,0,0,0,0,0,0,0,1,0,0

F-31,"105-0011",1001,1000,1000,1,0,0,0,0,0,0,0,0,0,0

F-33,"101-0016",1003,1000,1000,3,1,1,0,0,0,0,0,0,0,0

F-35,"101-0063",1003,1000,1000,3,1,1,0,0,0,0,0,0,0,0

F-37,"120-0020",1006,1000,1000,6,2,2,0,0,0,0,0,0,0,0

F-39,"110-0683",1002,1002,1000,0,0,0,0,0,0,2,0,0,0,0

F-41,"105-0023",1010,1009,1000,1,0,0,0,0,0,0,0,9,0,0

F-43,"105-0021",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-45,"105-0041",1000,1000,1000,0,0,0,0,0,0,0,2,0,0,0

F-47,"240-0039",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-49,"105-0007",15402,15396,15395,6,2,2,0,0,0,0,0,1,0,0

F-51,"105-0007",14619,14613,14605,6,1,1,4,0,0,0,0,4,0,0

F-53,"105-0001",18010,18003,18000,7,2,2,0,0,0,0,3,3,0,0

F-55,"184-0010",19265,19258,19258,7,3,3,0,0,0,0,0,0,0,0

F-57,"184-0010",19751,19743,19742,8,3,3,1,0,0,0,0,0,0,0

F-59,"184-0009",26015,26000,26000,15,6,6,0,0,0,0,7,0,0,0

F-61,"101-0004",2011,2000,2000,11,3,3,0,0,0,0,0,0,0,0

F-63,"101-0108",2005,2004,2000,1,0,0,1,0,0,0,0,3,0,0

F-65,"101-0089",2003,2000,2000,3,1,1,0,0,0,0,0,0,0,0

F-67,"105-0034",1002,1000,1000,2,1,1,0,0,0,0,0,0,0,0

F-69,"180-0041",1003,1000,1000,3,1,1,0,0,0,0,1,0,0,0

F-71(3),"672-0103",563,501,498,62,30,30,2,0,0,0,0,1,0,1

F-71(4),"672-0103",575,502,502,73,32,32,0,0,0,0,0,0,0,0

Total,"",134251,134032,134000,219,89,89,8,0,0,2,13,22,0,1

Line1,"M02"

Machine Information

250,1000,99.93,0.07,99.91,99.98,52.60,99019,99000,0,0,0,0,7/17/2017 11:05 AM,7/18/2017 2:52 PM,10:20:05,02:53:36,02:55:34,06:08:56,02:15:45,00:09:37,00:15:36,02:00:09,02:25:22

Feeder Management Information

Bank,Component Name,Pick Tries,Picked Component Number,Placed Component Number,Pick Errors,Empty,Retry,Laser,Vision,Lead Bend,Dimension Error,Verify/sot,Tombstone,Coplanarity,Other,

F-24,"105-0005",3004,3001,3000,3,1,1,1,0,0,0,0,0,0,0

F-26,"180-0102",5006,5000,5000,6,2,2,0,0,0,0,0,0,0,0

F-28,"184-0027",7003,7000,7000,3,1,1,0,0,0,0,2,0,0,0

F-30,"105-0019",7003,7000,7000,3,1,1,0,0,0,0,0,0,0,0

F-32,"105-0004",9010,9007,9000,3,1,1,3,0,0,0,0,4,0,0

F-34,"240-0352",27009,27001,27000,8,3,3,0,0,0,1,0,0,0,0

F-36,"180-0031",5003,5000,5000,3,1,1,0,0,0,0,0,0,0,0

F-38,"184-0015",4011,4003,4000,8,1,1,0,0,0,3,4,0,0,0

F-40,"180-0091",4003,4000,4000,3,1,1,0,0,0,0,4,0,0,0

F-42,"105-0030",4008,4005,4000,3,1,1,3,0,0,0,1,2,0,0

F-44,"646-0005",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-47,"672-0033",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-50,"690-0811",1004,1000,1000,4,1,1,0,0,0,0,0,0,0,0

F-53,"690-0807",1003,1000,1000,3,1,1,0,0,0,0,0,0,0,0

F-56,"680-0199",1004,1000,1000,4,2,2,0,0,0,0,0,0,0,0

F-59,"600-0231",5004,5000,5000,4,2,2,0,0,0,0,0,0,0,0

F-61,"601-0049",6006,6002,6000,4,1,1,2,0,0,0,0,0,0,2

F-63,"610-0248",3003,3000,3000,3,1,1,0,0,0,0,0,0,0,0

F-65,"230-0197",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-68,"240-0216",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-71,"690-0456",1003,1000,1000,3,1,1,0,0,0,0,0,0,0,0

F-74,"649-0006",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-78,"672-0074",1003,1000,1000,3,1,1,0,0,0,0,0,0,0,0

Total,"",99090,99019,99000,71,23,23,9,0,0,4,11,6,0,2

Line1,"M03"

Machine Information

250,1000,99.88,0.12,99.84,99.96,56.42,47018,47000,0,0,48,0,7/17/2017 11:07 AM,7/18/2017 2:58 PM,10:59:53,02:57:51,00:49:18,04:02:00,03:41:43,00:04:37,00:09:43,03:32:00,03:46:21

Feeder Management Information

Bank,Component Name,Pick Tries,Picked Component Number,Placed Component Number,Pick Errors,Empty,Retry,Laser,Vision,Lead Bend,Dimension Error,Verify/sot,Tombstone,Coplanarity,Other,

F-11,"690-0268",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-15,"690-0410",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-18,"240-0270",1006,1000,1000,6,3,3,0,0,0,0,0,0,0,0

F-22,"601-0023",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-25,"230-0103",1008,1000,1000,8,4,4,0,0,0,0,0,0,0,0

F-28,"180-0071",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-30,"184-0002",1000,1000,1000,0,0,0,0,0,0,0,2,0,0,0

F-32,"105-0046",1001,1001,1000,0,0,0,0,0,0,1,0,0,0,0

F-34,"500-0162",1003,1000,1000,3,1,1,0,0,0,0,0,0,0,0

F-39,"600-0061",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-42,"184-0029",1003,1001,1000,2,1,1,0,0,0,1,0,0,0,0

F-44,"181-0071",2007,2000,2000,7,2,2,0,0,0,0,4,0,0,0

F-46,"646-0070",2002,2000,2000,2,1,1,0,0,0,0,0,0,0,0

F-48,"150-0016",3000,3000,3000,0,0,0,0,0,0,0,0,0,0,0

F-50,"183-0019",2019,2011,2000,8,2,2,1,0,0,10,1,0,0,0

F-52,"105-0026",2002,2000,2000,2,1,1,0,0,0,0,1,0,0,0

F-54,"105-0002",2000,2000,2000,0,0,0,0,0,0,0,1,0,0,0

F-56,"180-0057",5002,5000,5000,2,1,1,0,0,0,0,0,0,0,0

F-58,"240-0353",3003,3000,3000,3,1,1,0,0,0,0,0,0,0,0

F-60,"605-0106",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-62,"130-0038",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-64,"170-0014",1001,1001,1000,0,0,0,0,0,0,1,0,0,0,0

F-66,"105-0020",2002,2000,2000,2,1,1,0,0,0,0,0,0,0,0

F-68,"690-0572",1002,1000,1000,2,1,1,0,0,0,0,0,0,0,0

F-70,"610-0224",1001,1000,1000,1,0,0,0,0,0,0,0,0,0,0

F-72,"646-0027",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-74,"610-0086",1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0

F-76,"690-0803",1006,1000,1000,6,2,2,0,0,0,0,0,0,0,0

R-49,"680-0253",1004,1000,1000,4,1,1,0,0,0,0,0,0,0,0

R-52,"480-0499",2000,2000,2000,0,0,0,0,0,0,0,0,0,0,0

MTC-01,"670-0162",1000,1000,1000,0,10,7,0,0,0,---,0,---,0,0

MTC-02,"680-0231",1004,1004,1000,0,10,1,0,4,0,---,0,---,0,0

Total,"",47076,47018,47000,58,42,30,1,4,0,13,9,0,0,0

Line1,"M01"

Machine Information

249,996,99.88,0.12,99.83,99.95,41.66,84703,84658,0,0,0,0,7/18/2017 3:33 PM,7/19/2017 7:14 PM,08:10:50,03:20:59,05:18:34,08:54:37,02:06:59,00:05:24,00:00:56,02:06:03,02:12:25

Feeder Management Information

Bank,Component Name,Pick Tries,Picked Component Number,Placed Component Number,Pick Errors,Empty,Retry,Laser,Vision,Lead Bend,Dimension Error,Verify/sot,Tombstone,Coplanarity,Other,

F-03,"690-0877",996,996,996,0,0,0,0,0,0,0,0,0,0,0

F-05,"240-0333",2002,1992,1992,10,3,3,0,0,0,0,0,0,0,0

F-07,"183-0020",2010,2004,1992,6,2,2,2,0,0,10,3,0,0,0

F-09,"240-0345",1995,1992,1992,3,1,1,0,0,0,0,0,0,0,0

F-11,"601-0056",1994,1992,1992,2,1,1,0,0,0,0,0,0,0,0

F-13,"150-0013",2992,2988,2988,4,1,1,0,0,0,0,0,0,0,0

F-15,"690-0632",999,996,996,3,1,1,0,0,0,0,0,0,0,0

F-17,"600-0027",1000,996,996,4,1,1,0,0,0,0,0,0,0,0

F-19,"183-0082",1001,996,996,5,2,2,0,0,0,0,2,0,0,0

F-21,"182-0068",999,996,996,3,1,1,0,0,0,0,2,0,0,0

F-23,"181-0081",999,996,996,3,1,1,0,0,0,0,0,0,0,0

F-49,"105-0007",5703,5698,5698,5,2,2,0,0,0,0,0,0,0,0

F-51,"105-0007",9248,9246,9242,2,1,1,1,0,0,0,0,3,0,0

F-53,"105-0001",996,996,996,0,0,0,0,0,0,0,1,0,0,0

F-55,"184-0010",14325,14321,14318,4,2,2,0,0,0,3,0,0,0,0

F-57,"184-0010",15566,15562,15562,4,2,2,0,0,0,0,0,0,0,0

F-59,"184-0009",3989,3984,3984,5,2,2,0,0,0,0,3,0,0,0

R-40,"470-1015",999,996,996,3,1,1,0,0,0,0,0,0,0,0

R-45,"470-0550",999,997,994,2,2,2,3,0,0,0,0,0,0,1

R-47,"101-0001",1003,997,996,6,2,2,0,0,0,0,1,1,0,0

R-49,"105-0038",996,996,996,0,0,0,0,0,0,0,1,0,0,0

R-51,"105-0035",996,996,996,0,0,0,0,0,0,0,0,0,0,0

R-53,"105-0037",997,997,996,0,0,0,1,0,0,0,0,0,0,0

R-55,"105-0045",998,997,996,1,0,0,0,0,0,0,0,1,0,0

R-57,"180-0017",1001,996,996,5,1,1,0,0,0,0,0,0,0,0

R-59,"105-0043",2007,2003,1992,4,1,1,1,0,0,0,0,10,0,0

R-61,"105-0039",1002,998,996,4,2,2,1,0,0,0,1,1,0,0

R-63,"101-0262",999,996,996,3,1,1,0,0,0,0,0,0,0,0

R-65,"105-0024",1003,1000,996,3,1,1,2,0,0,0,0,2,0,0

R-67,"101-0109",996,996,996,0,0,0,0,0,0,0,0,0,0,0

R-69,"101-0080",1004,999,996,5,0,0,1,0,0,0,0,2,0,0

R-71,"184-0028",998,996,996,2,1,1,0,0,0,0,3,0,0,0

R-73,"184-0054",996,996,996,0,0,0,0,0,0,0,0,0,0,0

R-75,"105-0036",997,996,996,1,0,0,0,0,0,0,0,0,0,0

Total,"",84805,84703,84658,102,35,35,12,0,0,13,17,20,0,1

Line1,"M02"

Machine Information

249,996,99.90,0.10,99.88,99.99,41.90,57776,57768,0,0,0,0,7/18/2017 3:29 PM,7/19/2017 7:14 PM,08:14:12,03:19:15,05:15:54,08:51:34,02:15:55,00:00:57,00:02:42,02:13:13,02:16:53

Feeder Management Information

Bank,Component Name,Pick Tries,Picked Component Number,Placed Component Number,Pick Errors,Empty,Retry,Laser,Vision,Lead Bend,Dimension Error,Verify/sot,Tombstone,Coplanarity,Other,

F-03,"240-0167",998,996,996,2,1,1,0,0,0,0,0,0,0,0

F-06,"230-0104",999,996,996,3,1,1,0,0,0,0,0,0,0,0

F-09,"690-0164",999,996,996,3,1,1,0,0,0,0,0,0,0,0

F-13,"690-0630",998,996,996,2,1,1,0,0,0,0,0,0,0,0

F-17,"240-0030",996,996,996,0,0,0,0,0,0,0,0,0,0,0

F-20,"105-0009",1995,1993,1992,2,1,1,0,0,0,0,0,1,0,0

F-22,"105-0033",1992,1992,1992,0,0,0,0,0,0,0,0,0,0,0

F-24,"105-0005",996,996,996,0,0,0,0,0,0,0,0,0,0,0

F-26,"180-0102",996,996,996,0,0,0,0,0,0,0,0,0,0,0

F-28,"184-0027",4981,4981,4980,0,0,0,0,0,0,1,1,0,0,0

F-30,"105-0019",2989,2989,2988,0,0,0,0,0,0,0,0,1,0,0

F-32,"105-0004",3986,3984,3984,2,0,0,0,0,0,0,1,0,0,0

F-34,"240-0352",14943,14940,14940,3,1,1,0,0,0,0,0,0,0,0

F-36,"180-0031",1998,1993,1992,5,1,1,0,0,0,1,0,0,0,0

F-40,"180-0091",11968,11952,11952,16,5,5,0,0,0,0,8,0,0,0

F-61,"601-0049",1992,1992,1992,0,0,0,0,0,0,0,0,0,0,0

R-57,"470-1551",998,996,996,2,2,2,0,0,0,0,0,0,0,0

R-61,"470-0748",1004,997,996,7,7,7,0,0,0,0,0,0,0,1

R-64,"030-0023",1006,996,996,10,3,3,0,0,0,0,0,0,0,0

R-69,"470-1277",1001,999,996,2,2,2,0,0,0,3,0,0,0,0

Total,"",57835,57776,57768,59,26,26,0,0,0,5,10,2,0,1

Line1,"M03"

Machine Information

249,996,99.47,0.53,99.41,99.94,47.16,22904,22890,0,0,73,0,7/18/2017 3:34 PM,7/19/2017 7:14 PM,09:15:38,02:39:34,01:40:35,04:36:48,04:22:41,01:02:19,00:14:03,04:08:38,05:25:01

Feeder Management Information

Bank,Component Name,Pick Tries,Picked Component Number,Placed Component Number,Pick Errors,Empty,Retry,Laser,Vision,Lead Bend,Dimension Error,Verify/sot,Tombstone,Coplanarity,Other,

F-03,"470-1291",1001,996,996,5,5,5,0,0,0,0,0,0,0,0

F-07,"240-0112",1002,996,996,6,2,2,0,0,0,0,0,0,0,0

F-18,"240-0270",2002,1992,1992,10,4,4,0,0,0,0,0,0,0,0

F-28,"180-0071",996,996,996,0,0,0,0,0,0,0,0,0,0,0

F-30,"184-0002",996,996,996,0,0,0,0,0,0,0,1,0,0,0

F-32,"105-0046",998,996,996,2,1,1,0,0,0,0,2,0,0,0

F-36,"470-1053",1000,998,996,2,1,1,0,0,0,2,0,0,0,0

F-39,"600-0061",1995,1992,1992,3,1,1,0,0,0,0,0,0,0,0

F-42,"184-0029",997,997,996,0,0,0,1,0,0,0,0,0,0,0

F-44,"181-0071",999,996,996,3,1,1,0,0,0,0,2,0,0,0

F-48,"150-0016",2991,2988,2988,3,1,1,0,0,0,0,0,0,0,0

F-58,"240-0353",996,996,996,0,0,0,0,0,0,0,0,0,0,0

R-33,"460-0239",1000,997,996,3,1,1,0,1,0,0,0,0,0,0

R-41,"906-0133",1011,996,996,15,3,3,0,0,0,0,0,0,0,0

R-46,"010-0058",1010,986,983,24,6,6,0,2,0,0,0,0,0,0

R-49,"680-0136",996,996,996,0,0,0,0,0,0,0,0,0,0,0

R-56,"470-1119",1001,999,996,2,1,1,0,3,0,0,0,0,0,0

R-60,"470-1409",1018,996,996,22,22,22,0,0,0,0,0,0,0,0

R-68,"470-0728",1017,995,991,22,22,22,0,4,0,0,0,0,0,0

Total,"",23026,22904,22890,122,71,71,1,10,0,2,5,0,0,0

Line1,"M01"

Machine Information

233,932,99.91,0.09,99.89,99.98,61.85,124919,124888,0,0,0,0,7/19/2017 7:41 PM,7/20/2017 6:49 PM,09:39:51,01:19:39,01:22:19,02:58:38,01:58:15,00:03:59,00:08:37,01:49:36,02:02:19

Feeder Management Information

Bank,Component Name,Pick Tries,Picked Component Number,Placed Component Number,Pick Errors,Empty,Retry,Laser,Vision,Lead Bend,Dimension Error,Verify/sot,Tombstone,Coplanarity,Other,

F-25,"630-0044",932,932,932,0,0,0,0,0,0,0,0,0,0,0

F-27,"105-0018",932,932,932,0,0,0,0,0,0,0,0,0,0,0

F-29,"105-0003",935,935,932,0,0,0,0,0,0,0,0,3,0,0

F-31,"105-0011",932,932,932,0,0,0,0,0,0,0,0,0,0,0

F-33,"101-0016",932,932,932,0,0,0,0,0,0,0,0,0,0,0

F-35,"101-0063",932,932,932,0,0,0,0,0,0,0,0,0,0,0

F-37,"120-0020",932,932,932,0,0,0,0,0,0,0,0,0,0,0

F-39,"110-0683",944,935,932,9,3,3,0,0,0,1,1,2,0,0

F-41,"105-0023",936,932,932,4,0,0,0,0,0,0,0,0,0,0

F-43,"105-0021",934,932,932,2,1,1,0,0,0,0,2,0,0,0

F-45,"105-0041",933,932,932,1,0,0,0,0,0,0,1,0,0,0

F-47,"240-0039",932,932,932,0,0,0,0,0,0,0,0,0,0,0

F-49,"105-0007",13421,13411,13409,10,4,4,0,0,0,0,0,1,0,0

F-51,"105-0007",14572,14560,14551,12,3,3,5,0,0,0,1,3,0,0

F-53,"105-0001",16781,16777,16776,4,2,2,0,0,0,0,3,0,0,0

F-55,"184-0010",16549,16541,16540,8,4,4,0,0,0,0,0,0,0,0

F-57,"184-0010",19823,19810,19808,13,5,5,0,0,0,1,0,0,0,0

F-59,"184-0009",24235,24233,24232,2,1,1,0,0,0,0,1,0,0,0

F-61,"101-0004",1864,1864,1864,0,0,0,0,0,0,0,0,0,0,0

F-63,"101-0108",1881,1871,1864,10,1,1,2,0,0,3,0,2,0,0

F-65,"101-0089",1872,1865,1864,7,1,1,0,0,0,0,1,0,0,0

F-67,"105-0034",932,932,932,0,0,0,0,0,0,0,0,0,0,0

F-69,"180-0041",935,932,932,3,1,1,0,0,0,0,1,0,0,0

F-71(3),"672-0103",502,488,487,14,7,7,1,0,0,0,0,0,0,0

F-71(4),"672-0103",458,445,445,13,6,6,0,0,0,0,0,0,0,0

Total,"",125031,124919,124888,112,39,39,8,0,0,5,11,11,0,0

Line1,"M02"

Machine Information

233,932,99.93,0.07,99.87,99.94,60.63,92326,92268,0,0,0,0,7/19/2017 7:41 PM,7/20/2017 7:23 PM,09:34:56,02:04:26,02:08:49,04:43:05,01:07:25,00:00:46,00:00:51,01:06:34,01:08:13

Feeder Management Information

Bank,Component Name,Pick Tries,Picked Component Number,Placed Component Number,Pick Errors,Empty,Retry,Laser,Vision,Lead Bend,Dimension Error,Verify/sot,Tombstone,Coplanarity,Other,

F-24,"105-0005",2797,2797,2796,0,0,0,0,0,0,1,0,0,0,0

F-26,"180-0102",4666,4660,4660,6,2,2,0,0,0,0,0,0,0,0

F-28,"184-0027",6527,6525,6524,2,1,1,0,0,0,1,2,0,0,0

F-30,"105-0019",6527,6525,6524,2,1,1,1,0,0,0,0,0,0,0

F-32,"105-0004",8412,8404,8388,8,2,2,10,0,0,0,1,6,0,0

F-34,"240-0352",25172,25164,25164,8,3,3,0,0,0,0,0,0,0,0

F-36,"180-0031",4666,4660,4660,6,2,2,0,0,0,0,0,0,0,0

F-38,"184-0015",3729,3728,3728,1,0,0,0,0,0,0,1,0,0,0

F-40,"180-0091",3731,3728,3728,3,1,1,0,0,0,0,2,0,0,0

F-42,"105-0030",3766,3766,3728,0,0,0,0,0,0,0,0,38,0,0

F-44,"646-0005",932,932,932,0,0,0,0,0,0,0,0,0,0,0

F-47,"672-0033",941,932,932,9,3,3,0,0,0,0,0,0,0,0

F-50,"690-0811",932,932,932,0,0,0,0,0,0,0,0,0,0,0

F-53,"690-0807",932,932,932,0,0,0,0,0,0,0,0,0,0,0

F-56,"680-0199",932,932,932,0,0,0,0,0,0,0,0,0,0,0

F-59,"600-0231",4665,4660,4660,5,2,2,0,0,0,0,0,0,0,0

F-61,"601-0049",5599,5593,5592,6,2,2,1,0,0,0,0,0,0,1

F-63,"610-0248",2798,2796,2796,2,1,1,0,0,0,0,0,0,0,0

F-65,"230-0197",932,932,932,0,0,0,0,0,0,0,0,0,0,0

F-68,"240-0216",935,932,932,3,1,1,0,0,0,0,0,0,0,0

F-71,"690-0456",932,932,932,0,0,0,0,0,0,0,0,0,0,0

F-74,"649-0006",936,932,932,4,1,1,0,0,0,0,0,0,0,0

F-78,"672-0074",932,932,932,0,0,0,0,0,0,0,0,0,0,0

Total,"",92391,92326,92268,65,22,22,12,0,0,2,6,44,0,1

Line1,"M03"

Machine Information

233,932,99.86,0.14,99.75,99.89,63.88,43854,43804,0,0,41,0,7/19/2017 7:41 PM,7/20/2017 7:29 PM,10:08:13,01:30:40,01:22:37,03:08:56,02:17:16,00:00:52,00:00:00,02:17:16,02:18:08

Feeder Management Information

Bank,Component Name,Pick Tries,Picked Component Number,Placed Component Number,Pick Errors,Empty,Retry,Laser,Vision,Lead Bend,Dimension Error,Verify/sot,Tombstone,Coplanarity,Other,

F-11,"690-0268",932,932,932,0,0,0,0,0,0,0,0,0,0,0

F-15,"690-0410",935,932,932,3,1,1,0,0,0,0,0,0,0,0

F-18,"240-0270",937,932,932,5,2,2,0,0,0,0,0,0,0,0

F-22,"601-0023",933,933,932,0,0,0,0,0,0,1,0,0,0,0

F-25,"230-0103",935,932,932,3,1,1,0,0,0,0,0,0,0,0

F-28,"180-0071",932,932,932,0,0,0,0,0,0,0,0,0,0,0

F-30,"184-0002",932,932,932,0,0,0,0,0,0,0,1,0,0,0

F-32,"105-0046",932,932,932,0,0,0,0,0,0,0,0,0,0,0

F-34,"500-0162",934,934,932,0,0,0,1,0,0,1,0,0,0,0

F-39,"600-0061",932,932,932,0,0,0,0,0,0,0,0,0,0,0

F-42,"184-0029",932,932,932,0,0,0,0,0,0,0,0,0,0,0

F-44,"181-0071",1864,1864,1864,0,0,0,0,0,0,0,1,0,0,0

F-46,"646-0070",1864,1864,1864,0,0,0,0,0,0,0,0,0,0,0

F-48,"150-0016",2805,2796,2796,9,2,2,0,0,0,0,0,0,0,0

F-50,"183-0019",1902,1895,1864,7,2,2,5,0,0,26,2,0,0,0

F-52,"105-0026",1865,1865,1864,0,0,0,1,0,0,0,0,0,0,0

F-54,"105-0002",1866,1864,1864,2,1,1,0,0,0,0,2,0,0,0

F-56,"180-0057",4667,4660,4660,7,3,3,0,0,0,0,0,0,0,0

F-58,"240-0353",2802,2796,2796,6,1,1,0,0,0,0,0,0,0,0

F-60,"605-0106",936,932,932,4,1,1,0,0,0,0,0,0,0,0

F-62,"130-0038",935,932,932,3,1,1,0,0,0,0,0,0,0,0

F-64,"170-0014",935,932,932,3,1,1,0,0,0,0,0,0,0,0

F-66,"105-0020",1864,1864,1864,0,0,0,0,0,0,0,0,0,0,0

F-68,"690-0572",935,932,932,3,1,1,0,0,0,0,0,0,0,0

F-70,"610-0224",934,932,932,2,1,1,0,0,0,0,0,0,0,0

F-72,"646-0027",932,932,932,0,0,0,0,0,0,0,0,0,0,0

F-74,"610-0086",935,932,932,3,1,1,0,0,0,0,0,0,0,0

F-76,"690-0803",932,932,932,0,0,0,0,0,0,0,0,0,0,0

R-49,"680-0253",932,932,932,0,0,0,0,0,0,0,0,0,0,0

R-52,"480-0499",1865,1864,1864,1,1,1,0,0,0,0,0,0,0,0

MTC-01,"670-0162",932,932,932,0,10,0,0,0,0,---,0,---,0,0

MTC-02,"680-0231",947,947,932,0,9,6,0,13,2,---,0,---,0,0

Total,"",43915,43854,43804,61,39,26,7,13,2,28,6,0,0,0

Ihre Antwort

Bitte beschreiben Sie Ihr Problem möglichst ausführlich. (Wichtige Info z.B.: Office Version, Betriebssystem, Wo genau kommen Sie nicht weiter)
Bitte helfen Sie ebenfalls wenn Ihnen geholfen werden konnte und markieren Sie Ihre Anfrage als erledigt (Klick auf Häckchen)
Bei Crossposting, entsprechende Links auf andere Forenbeiträge beifügen / nachtragen
Codeschnipsel am besten über den Code-Button im Text-Editor einfügen
Die Angabe der Emailadresse ist freiwillig und wird nur verwendet, um Sie bei Antworten auf Ihren Beitrag zu benachrichtigen

Thema:		Name:		Email:

Bitte beschreiben Sie Ihr Problem möglichst ausführlich. (Wichtige Info z.B.: Office Version, Betriebssystem, Wo genau kommen Sie nicht weiter)
Bitte helfen Sie ebenfalls wenn Ihnen geholfen werden konnte und markieren Sie Ihre Anfrage als erledigt (Klick auf Häckchen)
Bei Crossposting, entsprechende Links auf andere Forenbeiträge beifügen / nachtragen
Codeschnipsel am besten über den Code-Button im Text-Editor einfügen
Die Angabe der Emailadresse ist freiwillig und wird nur verwendet, um Sie bei Antworten auf Ihren Beitrag zu benachrichtigen

Thema	Datum	Von Nutzer	Rating	Antwort
Daten automatisch auslesen und auswerten	18.09.2017 10:30:56	Clemens Klasen
Daten automatisch auslesen und auswerten	18.09.2017 11:07:27	Gast10776
Mustermappe	18.09.2017 20:59:55	Gast70117