NCG Appendix F – CSV Format
By selecting “CSV” as the type of statistics data to be saved in the NC Gage Settings screen, a CSV file can be output every time a measurement program is executed.
CSV File Format | |
|---|---|
Line | Content |
1 | Blank |
2 | DateTime, "<yyyy><MM><dd><hh><mm><ss><fff>" (Time stamp at file output) <yyyy> - Four-digit year <MM> - Two-digit month <dd> - Two-digit day <hh> - Two-digit hour (24-hour time) <mm> - Two-digit minute <ss> - Two-digit second <fff> - Three-digit microsecond |
3 | Part Name, measurement program |
4 | Blank |
5 | Measurement data column headings as here: FEATURE, AXIS, NOMINAL, MEAS, +TOL, -TOL., DEV, OUTTOL |
6 … | Measurement data Note: Each field is enclosed in quotation marks |
Field Contents | ||||||||
|---|---|---|---|---|---|---|---|---|
Field: | FEATURE | AXIS | NOMINAL | MEAS | +TOL | -TOL | DEV | OUTTOL |
Type: | String | Decimal (4 decimal places) | ||||||
Valid Entries: | POINT1 CIRCLE1(Bore) CIRCLE1(Boss) CIRCLE1(Shaft) WEB1 POCKET1 CORNER1(Outside) CORNER1(Inside) PLANE1 LINE1 CYLINDER1(Bore) CYLINDER1(Boss) CONE1(Inside) CONE1(Outside) SPHERE1 KEYWAY1 KEY1 FLAT1 POINT1(Constructed) LINE1(Constructed) CIRCLE1(Constructed) | X Y Z D Roundness Position Concentricity Angle |XY| |YZ| |ZX| |X| |Y| |Z| |3D| Straightness Perpendicularity Parallelism Width Flatness Cylindricity Cone Form Sphericity | +9999.9999 to -9999.9999 | |||||
Example: |
|---|
DateTime, "20190110152512946" Part Name, A20180716.NCG FEATURE, AXIS, NOMINAL, MEAS, +TOL, -TOL, DEV, OUTTOL "CIRCLE1(inside)","X","-210.6240","-210.6242",".1000","-.1000","-.0002",".0000" "CIRCLE1(inside)","Y","-49.9940","-49.9943",".1000","-.1000","-.0003",".0000" "CIRCLE1(inside)","Z","77.0260","77.0260",".1000","-.1000",".0000",".0000" "CIRCLE1(inside)","D","60.3540","60.3770",".1000","-.1000",".0230",".0000" "CIRCLE1(inside)","Roundness",".0000",".0225",".1000",".0000",".0225",".0000" "CIRCLE1(inside)","Position",".0000",".0007",".1000",".0000",".0007",".0000" "CIRCLE2(inside)","X","-210.6100","-210.6093",".1000","-.1000",".0007",".0000" "CIRCLE2(inside)","Y","-49.9940","-49.9946",".1000","-.1000","-.0006",".0000" "CIRCLE2(inside)","Z","57.0260","57.0260",".1000","-.1000",".0000",".0000" "CIRCLE2(inside)","D","43.8860","43.9071",".1000","-.1000",".0211",".0000" "CIRCLE2(inside)","Roundness",".0000",".0225",".1000",".0000",".0225",".0000" |