Re: [CAD_CAM_EDM_DRO] Latest Design Created with my SherlineCNC

Hi Dan,

OK, I confess, I've had to import vehicle data from it for an automotive
test program (the ECU computer). And I have a spreadsheet for timing
belt pulleys.

The PLC works great!

Dan Statman wrote:

>
> I could not live without Excel. I use it for my consulting job (analytical
> chemistry) on all data analysis, statistical analysis, and graphical
> presentation of the data. Because I am so familiar with its functions and
> data manipulation techniques, it was natural for me to use it to create
> G-Code. The program is flat-out AWESOME. Excel...not just for accountants
> anymore, ;-).
>
> Yes I "import" the data using the PLC paste special function which Fred
> showed me early on when I was demo-ing the program.
>
> Dan.
>
> ----- Original Message -----
> From: "Alan Marconett KM6VV" <KM6VV@...>
> To: <CAD_CAM_EDM_DRO@yahoogroups.com>
> Sent: Friday, May 31, 2002 3:57 PM
> Subject: Re: [CAD_CAM_EDM_DRO] Latest Design Created with my SherlineCNC
>
> > Hi Dan,
> >
> > Sounds like it works quite well for you. And by "import" I assume you
> > mean "PLC". True, you do have to convert to metric measure for the
> > PLC's, but I found out that it is really no extra code there, as my
> > controller program accommodates G20/G21 words, and thus needs to do a
> > mm/in conversions. For generating PLC's, the same choice is made
> > depending on the state variable set by G20/G21, just backwards in this
> > case. I found that the PLC arc's and lines are very similar to Gcode,
> > which made it easy.
> >
> > Yeah, but using spreadsheets! Aren't they for accountants? ;>)
> >
> > Alan KM6VV
> >
> >
> > Dan Statman wrote:
> > >
> > > You know I thought I would give up the Excel spreadsheet technique also,
> but
> > > it is so damn easy and convenient. For the same patterns on varying
> width
> > > rings, I just scale the x-axis to the new width with a simple factor and
> > > then the macro regenerates the G-code in about 10 seconds. I put my
> z-axis
> > > moves in a separate spreadsheet column so that I can vary them depending
> on
> > > the cutter width, and I ALWAYS know exactly what I am going to get when
> the
> > > program runs since you can make a graph of all of the data points
> connected
> > > via straight line segments. This is exactly the G01 move.
> > >
> > > The only limitation that it has is I cannot scale the line width in the
> > > diagram accurately. However, you can take the x and y data points and
> > > import them back into Vector and scale the angular measurements to
> linear
> > > (and then scale from metric to imperial since the import always assumes
> > > metric), and then set the line width to see if there are overlaps.
> > >
> > > The reason there are so many programs out there is because everyone uses
> > > them differently. The Excel spreadsheet is the most intuitive for me,
> but I
> > > have never been accused of being normal.
> > >
> > > Dan.