活 用 す る 測 デ ー タ を
Contents
1. NR STO4 NR C512 CAN 10V 80mA 50OV CAN Hgih speed Single Wire ch 8ch 4ch 8ch 5 12 14bit 16bit 16Dit IMHz 50kHZ 10Hz 1MDps 4M 4M 200k 2M 100 Excel 25 26 PC WAVE LOGGER PRO NR 3WAY PC PC 3WAY USB ID USB CF LAN 100Base TX 3 Mini B CF LED2. LINEST A1 A100 LINEST A1 A100 F2 Ctrl Shift Enter C1 D1 Y aX b a C1 b y D1 x D 0 0 X 25 2 100 2 0 ID AltFB R Visual Basic Editorw Alt F11 x y Ctrlt ff Dy 200376718 APSULT Ed Microsoft Excel Book1 FE E
3. A Microsoft Excel Excel Book1_xls CE GE SS 4 g 2002 10 04 173851 Excel x D X 2 8 lt 2 2002 1 0 3 924803 2002 10 4 229502 2002 10 4 523629 2002 10 4 806449 2002 1 0 5 077256 2002 1 0 5 335372 _ 2002 10 5 5801 53 _ 2002 10 5 81 0886 2002 10 6 027294 1 200271 G 22853 2002 10 6 41 4213 2002 10 6 583B56 2002 107 6 737043 2002 107 6 873391 2002 10 6 992559 2002 10 7 094249 2002 107 7 178207 1 4 NS2 OZSheeti lt 0 A ss 4 df 1 A lt x A NUM 2 100 Excel 13 TE T M Visual Basic Editor V
4. os E11 T1 0 15 Eon E2 PI 4 E1 16 1 2 100 Ss to Lrg i as is E3 2 4 SIN E2 100 E2 O00 02020992 aA AG48874 656849 0 E2 F3 TT mas ll OD RN a OrYUMD 6 AD DO AUD x PIE E3 meGSIKEEET CE Hi 1 k 1 Dooonooo 3 MAD7 1 BBB 1 HGS 1 3823 1 13 nnnmn BMB rrcr BB OO OGA TED B55373 i rr EP Ti i oan Sl NW ngn 95 On TE5H i OOCmn7n 3 mL DT ER ti h k 2 ll HF x EFID SE 9 O _017 1 7 E3 1 PE3 55 5 1 3 1 8 1 1 KE 1 L 4 1 FREES t TE gt LS gt DO 304437 th 436 1 83363 1 130 16 nnnl 580487 ET 4 SET 55BH4B nM B1 lt B1 B1
5. 7 ieresalt Wual asm Beok1 Moduls1 1 GO aw pf TD 8 gt a mm nr WE Pisot ub Maer 1 th si HATPUWRAEM LA PU M Visual VEAProject 09 x VEAPraject Hmk1 Basic Editor V Visual Basic Editor een Gwe 6 WE a RS hlTEEglm CT Sub Macro10 a DEL Top DEL End P003 3 28 KEYENCE a Keyboard Shortcut Ctrl s Dim DEL Top As String Dim DEL_End As String MABIKL P 10 1710 lt N eB 1 E MS a Do Loop
6. Loop 0 open close Close FileNumber End Sub CSV a a Es EB k Fy ET CG U lt i FE GE 0 N LE N a 0 100 5 OK DGP Fi LuW x y RR y HH ET II ER
7. WWW e KeisOKuKi jD
8. Do a ells Now_Row 1 Then GQK If then Cells 1 1 Activate A1 Exit Do Exit Do EndIE _ End Tf DEL Top Now_Row 1 1 10 1 10 1 DEL_End Now_Row MABIKI_P 1 Rows DEL Top DEL End Select Selection Delete Shift xIUp DEL _ Top Now_Row Now_Row 1 DEL_ End LOOD Rows 2 10 Select DEL Top DEL_End End Sub Visual Basic Editor Book Ctrl s 100 Excel lt 3 Excel 1
9. liil 51 G 5B 5 LU 5 ah aoi HE 1L 5 PT OZ54 57 BB 27448 6 22682 457 8841 41263 Rf 83 27451 58242 459 7385 RT kuLLT1 1 lo 4 aute Taulof0 9 Jaulg WW EE lt 0 0 lt Fm lt GO lt lt HU HU Excel T M R I MD KK 1 D OK M et
10. 3 gt XY FFT X Y FFT e4 e5 e e dB e a a 2 0 CSV Excel
11. FF inft Enel mtn 1 Pa RU Book1 xls B ET AO HOD FD PO NF x LE JP HLEIIEEIEI 1 a Fi mm AD Fms F FF 8 FF UT1 LTS LT LT UTS LTE PUT 1 LT LT LT LT LT IT MLIT 1 FF IFETT maln ES a Em 0 Fpm Mr gt 100 Excel CSV CSV T M Visual Basic Editor V Visual Basic Editor Sub Macro1 Macro1 Macro 20
12. A 65536 X 256 255 32767 lt 1024 gt A 15 9 99999999999999E307 1900 1 1 9999 12 31 1 32 000 1 256 000 256 000 32 000 8 gt 1 T gt O 2 S 3 M OK 4 ET
13. _ NR 600 PC 0 FTP CF amp 2 PC NR 600 LAN TOOL NR 600 Oo o ER 100 Excel WWW KeVence CO jD KeisOKkuKi
14. 100 EXCel index FD DE grain 3 7 ee 10 VTA ee 13 TM A CE 17 ON NT DENN ECE 21 Excel 25 Excel www e keisokuki jp Excel VBA EO Microsoft Excel Book1 x FE CE 0 0 D 0 2 MS P 1 BUu
15. K Excel i c CSV Book1 sal Erel Mookl xi Visuml masi PdaorMn Ai1 E 1 11 he E 5 lt hh A la uF RE Hz 0 x H MM wacrol 1 Grlc ff lt Di H i 200375713 APFSULT tn av Weicrnsnft Fcml au mTJMF E WO D DD DD TH I ws lt RI 1 g 1 rg 9 rm
16. EE I M 5 bra TP Wancmms FUREREGML A VAPrsject Maoky ET ie arml thins heal head TEL VBA Sub CSV_File_Cut CSV File_Cut Macro 003 6 1 KEYENCE Corp APSULT Div 1 Sheet Num RU P 12 Column_Num Filename Application Get0penFilename CSV TXT CSV FileNumber FreeFile Open Filename For Input As FileNumber Do While Not EOF FileNumben EOF LOOP
17. lt 0 A NUMM 100 Excel Excel irnmeit ipual yeic Book lis Idulm1 tHE Mi FETA picrP70 TH mk Visual Basic Editor iprbhas ie Uh TEUTATH HL A 1 Pr hoek Yszle T M Visual Basic Ei Editor V Visual Basic Editor TT geli so 1 Me Er Be End 1 DE Tee Nae Fm 1 DL Ed Hee am CEET Fel oni EL Tap Hr _ hi ti Excel Do If CellS Now_Row 1 Then OK Cells 1 1 Activate A1 Exit Do End If Cells Now_Row Activate ActiveCell Application Work
18. LOGEST y b m x Ontime Application Ontime 10 00 Application Ontime TimeValue 10 00 00 10 Application Ontime NOW TimeValue 00 10 00 Excel FFT LPF Th 1 1 MI 1 IL Al OO oO DD mm oO ma 1 1 1 1 1 1 l 1 AAA
19. Excel a Excel E NO ics 6 ExcoF 1 650 NR Ee mR 2000 Eh RC Ts NR 600 100 yy Excel 100 yy Excel Excel Excel VBA Visual Basic WAVE LOGGER PRO MT
20. If Row_Num 1 Then 1 Sheets Add ActiveSheet Name CStr Sheet_Num 1 End If Line Input FileNumber DataBuffer DataBuffer 1 Data Split DataBuffer data Excel If DataBuffer lt gt Then DatalnputCH UBound Data 1 0 1 Deta ActiveSheet Range Cells Row_Num 1 CellsS Row_Num DatalnputCH Data End If If Row_Num 65536 Then 65536 B5536 Excel Row_Num 1 Sheet Num Sheet Num 1 Else Row _Num Row_ Num 1 End If Erase Data
21. h k h k 2 fc fs sin r k r k r k 2r fc k n 1 2 fs Excel NR_ 600 500 EYEHmTE ue HHTTT mm Robust LAN or A A _EE PC NR 500 USB ee 1 PC NR 600 NR 500 3
22. 8 A 0 D E F G H 171000 EA Microsoft Excel Book1 x FE GE 0 0 DD D X 37493 gt iwMspho 1 gt BU 9 A 37494 37495 C D E F sd IN 4 p Sheetl lt NN EE FR ci GO KT CO IFS 3 lg Sheet1 uF 9 gt O v NUM 100 Excel 3 Excel T M R i ER fk W 1R 1 RAE Weel Bsie
23. Re E11 Micrnsnft Excel Book1_ xls 6 100 100 Excel 15 CSV Excel csv txt csv 65536 txt csv txt Excel VBA EE Miernanit
24. WorksheetFunction Excel MAX A1 A2 A11 Cells 1 1 Activate A1 ActiveCell Application W orksheetFunction Max Range A2 A11 Excel VBA 1 10 Ma rezni rcal Wsk1 als Ma reenli Toral osk1 rle ED 7 hh mi gmGN CoFPTMMT nHFJUW Eu eyeli i EE EE I NT UL NDNA ED LMLMMUMMIMIMMMI
25. wonnkk TE i os 1 5388 Part EE Pu 1 lnint 1 has dj hr JJ RUM Tj PE Aa mED er FT MI LL NR RR Ln RA mr iL TRI LITE ECT hh bad TT sm LPF P24 3a 4 1 11 C12 11 AVERAGE B2B12 B RG om iC auP7OWD HY 5 IS 1 ET TU 3 LMMU LIL_ NZLU TOMUT NIIT HU 16 FIR pz 4 h k 9 E E M0 9 5 P WAM7 lt
26. 0 o COUNT UNEST F CE 4 lt LINESTCAI A100 1 Microsoft Excel Book1 FE E 0 1 9 lt C1 LTNEST A1 AT 00 D TP ma PP 0 D gt gt lt 2 1 Y aX b lt COUNTIF i J C 1 ROWWKA1 TD1 X ROW a C1 X 1 ROW A1 se 100 ROW A100 GO D DD 9 b D1 I o 2 FOR COUNTIF CE1 kROWKA1 00 D1 C 1 ROWKA1 00 D 1 FE
27. C Program Files KEYENCE TP3000s data auto 0 1 csv Workbooks Open Filename C Program Files KEYENCE TP3000s data auto 0 1 csv GetOpenFilename gg gt lt CSV gt CSV_Filename Application GetOpenFilename CSV 9 Workbooks Open CSV_Filename 12 CSV VBA CSV Microsoft Excel Book1 xls CE W si lt 00W 2 C D WW u mm F x D H X 8 EE GSV
28. ET _ Excel at 1 VBA Microsoft Excel Book1 _ FE E C DD WO HD X IMSP 2 1 lt Bml A B3752B _ 171000 EA Microsoft Excel Book1_ xls x FE GE 05 DD H xX Ms Pp 1 v BZII gt la msla Ei Al BE E H 3 iMKSheet1 14
29. E Y 8 4 1 COUNTF J At E1 EN2 1 00 1 F C D 1 75 A1 E 1 E5P 1 00 1 ROWKA1 1 1 37 24 75343 3 100 100 1 1 E 1 E 2 B1 A1 E 1 E 2 100 1 ROW A1 1 EE Microsoft Excel Bnnk1 B1 B100 G L lt A E1 ER2JCT 8 4 B 0 100 Excel 19 20 HE Excel 2 LINEST y axx b
30. 1 100 Excel 9 CSV Excel VBA CSV 1 Excel 1 EC Ewenl Bmnkl sks Er 1 MD 9 UN ry 0 _ RGi _ 27434 1 91572 451 3B 7 27435 2 26711 452 0506 i Nr 2743 2 0 453 0A gt 4 8 452 5 2373 387T4E 4
31. CF X Y FFT RUN USB RS 232C GPIB ee el
32. Edtor ty lmW11 Monesh rt dian akeshiHhe 11 1 mr M KK OD 5 EE OK mw e M Gll fo Macro1 Di 200373728 KEYENCE K Excel Ctrl s Excel 5 EE TT rT a a LO EM ET 1 10 2 10 2 10 D ad H F HMIIS MR 300 9001 NUM T M R
33. Eseel SinpeDitetil lg Eh FE hi 1 2 AA Jl a a Ra a nm Miefngnlt EmEl nh pentfee wm Fr nk Jararh1 UE Pf TF eC FY lm RE LF 100 Excel 17 Excel T M R M RO D OK M NN K Excel
34. Excel 23 24 2P4 9 Hz 0 443 X Hz 1 10ms 100Hz 4 Hz 0 443 X 100Hz 4 11 1 Hz An EE 4 ODN T 0 HH 2 NE 16 16 h k k 0 15 Y h 0 0 h1 XX 1 Th 15 X 15 2
35. G B14 H OO OOLOZO BB37 0 nn 2 4375 7 3 0 3 3 nnnm nn Ti 3 B13 I 3 B12 3 B11 K 3 B10 L EE ooocso sass nnn 3 B9YM 3 B8SYN 3 B7 O 3 B6 P 3 oooooo ssele B5 QO53TB4TR53TB3YS 3TB2 T 3 0000100 2 BB8D1 oo00130 172888 0 ta 6 oooi5o 153206 2H5045l FIR Finite Impulse Response sa ld psd00s s 3 IIR Infinite Impulse Response EC salt Excel Booke 9 O r JLGE GE 0 Q EY rrFOGWT AL x 3 Ew a FIR E Graphl haat i OO NU Di 100
36. IT TUTT W T1 LUUTL 1AON NT 1 LU LN 1UUI NN RAW 1 1 1 1 1 1 1 1 100 Excel 21 1 Excel CSV Excel CSV BS Excel PC Excel CSV A B 10ms 1 2 5 0 4Hz 4Hz TE FT mn PD TD MI cn ET E F ato RmTERT tat a AST totoocea ah FR nn tatoo Elerd cotta PF ol caro HTM5a nnh Iriil io ocen 1 i cca EE i oon ET ie OCG4T A 1 rm liml is ns 17
37. InnHshsss RAE LAN TOOL 2 FTP ease RSS CE LAN TOOL 9 9 LL ri ci pe a Excel CSV Excel 0 CSV a Excel 65 000 1 LAN Ethernet 100Base TX LAN PC 1 1 100m
38. 03 4 22 APSULT ChDir C Program FileS KEYENCE TP3000s data Workbooks Open Filename C Program FileS KEYENCE TP3000s data auto O 1 csV Sheets auto 0 1 Select Sheets auto 0 1 Move After Workbooks Book1 Sheets 1 End Sub Sub Macro1 Macro1 Macro CSV Filename Application GetOpenFilename CSV CSV pm CSV prn CSV True FileCount UBound CSV_Filename ae Workbooks 0pen CSV_Filenamei TOON CSV SheetName Worksheets 1 Name Sheets CSV SheetName Move After Workbooks Book1 Sheets Sheets Count 1 Next End Sub Visual Basic Editor Book Ctrl s KS Open
39. 55 2072 TA TE 453 5740 27441 4 22684 456 5191 1 B kl FL OO TAd 4 4 DB 5 BCM1 eSd3414 58 155 FE Fa r BH bb 2 8 1 ls Pa 274E1 5242 457 hosti1 JE mi Rn huf4U0 gt sw lt Ed Micrasnft Excel Bankl sls 8 PR E 0 WA FADD CP A Fx 5 27450 41265 456 3293 ID IE LE Bl 27451 G 58242 459 7385 w _ FMIOCE mE _ a WE tos sl IE Ey mi 1 RE 1 5 dE A cie he A he RD Li A 27435 226711 452 0806 27145 2601954 4532 E78 df TAT A HO NA tao 47 rh 3 n 4 5n74 55 BT 0 lt bm lt w lt lt 4 2744n 92o05 453 574H of 27441 4 226B4 45H 5191 7448 45210 Ti a 2744 4BOBB 45H5M1 27444 OTA 45 7 27445 533314 45B155 FO SH 7 E78 i EI 0 lt 0
40. sheetFunction Max Range Cells Now_RHow 1 CellsS Now_RHow MABIKI_P 1 1 Excel Cells Now_Row 3 Activate ActiveCell Application WorksheetFunction Min Range Cells Now_RHow 1 Cells Now_Row MABIKI_P 1 1 Excel Cells Now_Row 4 Activate ActiveCell Application WorksheetFunctioN Average Range Cells Now_ Row 1 Cells Now_Row MABIKI Excel DEL Top Now_Row 1 1 10 1 10 1 DEL_End Now_Row MABIKI_P 1 Rows DEL Top DEL_End Select Selection Delete Shift xlUp Now_RHow Now Row 1 Visual Basic Editor Book Ctr1I s 9 Excel
Download Pdf Manuals
Related Search