johnamberhawker
New Member
- Joined
- Apr 7, 2009
- Messages
- 2
Can multiple cells containing both calculated and non-calculated data be added to a single cell for export without calculation in the final cell,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I may well be asking a terribly simple question here, but I cannot solve it myself. It concerns writing universal simple programmes in excel to make simple items on a milling machine. For example a spoked wheel as seen on a steam engine, where one wishes to cut a series of circular arcs, some complete and some interrupted and a series of radii. The idea is to decide on a size of wheel add the overall dimensions to the appropriate cells and allow excel to produce all the lines of G code,which tell the cutter where to go.
<o></o>
To create G code for a computer controlled milling machine a G code is given first followed by 2 to 4 coordinates values (normally cartesian, but can be polar) (X,Y,Z and possibly a rotation A,B or C)
<o></o>
The G (G1 straight line, G2 clockwise arc etc) component will indicate a straight line or circle or whatever and the cutter will move from it’s present point to the new coordinates following the G code. If the spinning cutter is at X0 Y0 and the machine is given the code G1 X5Y5 it will cut an oblique line to X5Y5 if it then given the command G1 X10Y10 Z10 it will create another oblique line, this time with some vertical height (3D)
<o></o>
For example if the X position increases by 0.5mm and the Y by 0.75mm per row, this is easy for excel (starting at X0 Y0). However for the simple export the final cell needs to read (G1 X0.5 Y 0.75) and the next cell (G1 X1.0 Y1.50) etc for export to the programme. It is this last cell, which I cannot get to behave. GI would have come from column A, X0.5 form column B and Y0.75 from column C.
<o></o>
For interest the programme to do the cutting or drawing or welding etc comes from the Mach 3 site and is available free of charge.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I may well be asking a terribly simple question here, but I cannot solve it myself. It concerns writing universal simple programmes in excel to make simple items on a milling machine. For example a spoked wheel as seen on a steam engine, where one wishes to cut a series of circular arcs, some complete and some interrupted and a series of radii. The idea is to decide on a size of wheel add the overall dimensions to the appropriate cells and allow excel to produce all the lines of G code,which tell the cutter where to go.
<o></o>
To create G code for a computer controlled milling machine a G code is given first followed by 2 to 4 coordinates values (normally cartesian, but can be polar) (X,Y,Z and possibly a rotation A,B or C)
<o></o>
The G (G1 straight line, G2 clockwise arc etc) component will indicate a straight line or circle or whatever and the cutter will move from it’s present point to the new coordinates following the G code. If the spinning cutter is at X0 Y0 and the machine is given the code G1 X5Y5 it will cut an oblique line to X5Y5 if it then given the command G1 X10Y10 Z10 it will create another oblique line, this time with some vertical height (3D)
<o></o>
For example if the X position increases by 0.5mm and the Y by 0.75mm per row, this is easy for excel (starting at X0 Y0). However for the simple export the final cell needs to read (G1 X0.5 Y 0.75) and the next cell (G1 X1.0 Y1.50) etc for export to the programme. It is this last cell, which I cannot get to behave. GI would have come from column A, X0.5 form column B and Y0.75 from column C.
<o></o>
For interest the programme to do the cutting or drawing or welding etc comes from the Mach 3 site and is available free of charge.