Register now to participate in the forums, access the download area, buy Mastercam training materials, post processors and more. This message will be removed once you have signed in.
Use your display name or email address to sign in:
Just curious if a tool breaks, the machine changes tools, hauls a$$ into the next cut. How long before the behind the door checker recognizes there is a problem?
We run Cooljet chillers in a cell with three machines. They work well controlling growth of tombstones since HP coolant heats the coolant up to around 99 deg. without chillers.
They also help a great deal reducing the makeup coolant we have to add. Our shop is "climate controlled" although the AC gets stretched pretty thin with the outside temp is around 100. We aim to keep the coolant at ambient temp., usually around 72ish
I was too slow Joe.....
http://www.cncci.com/resources/tips/how%20g28%20works.htm
Basically it is go home via a point. It requires that "via" point. If you put in G90 G28 Z-.5, the machine will move to z-.5 realtive to you current work offset z then return home. So G91 G28 Z0 returns to zero via an incremental move of 0.
In a Fanuc control G53 is the machine coordinate system. G28 is first zero return. If you command G28 Z0., it's going home. You just might not like how it gets there if you leave out the G91 Z0.
In Excel use
code:
=IF(ISBLANK(B3)=FALSE,IF(B3/64<L$9,B3/64,L$9),"")
The difference being ISBLANK(B3)=False
My Open Office autocorrected False to 0. I guess that doesn't work in Excel.
Learn something everyday
Good luck
BTW for some reason I was thinking the Excel function is ISEmpty.... That is incorrect. There is no such thing. They both use ISBlank. I was posting at home without access to Excel.
Sorry bout that.
The easiest thing for you might be to use a formula (using your chipload column formula as an example) like:
code:
=IF(ISBLANK(B3)=0;(IF(B3/64<$L$9;B3/64;$L$9));"blank")
Replace "blank" in the above formula with "" so it gives you a blank cell. I just put that there for illustration.
Note there is a difference between a cell where you don't see anything and a truly blank cell. If you get 0.000 as a result, its because you have a space or other character in the B column. Highlight the cells and press Delete -> Delete All
This example is just nesting another IF statement with what you have. It tests to see if B3 is blank. If it is not blank, it uses your formula, if it is blank it gives "". Since the cell reference is not absolute, as you copy it should populate with a cell address from the proper row.
You could just copy that formula down the column for a few hundred cells or however many then lock them. To do that without dragging the little crosshair, you can select the cells you want using Shift+PgDn then Edit -> Fill -> Down
There are other ways to do this also. This is one might not be the most elegant, but it's pretty simple.
For Excel you could use the ISEmpty function
[ 03-19-2008, 01:17 AM: Message edited by: Jerosu ]
Also, a shortcut to get the absolute reference is to press F4 in Excel, or Shift+F4 in Open Office after you either type in a cell value, or click on a cell to input that value in a formula.
Example for Open Office:
in a cell enter "=B2" then press Shift+F4.
It will change to $B$2, as you press Shift+F4 additional times it will toggle through $B2, B$2, $B$2. What that is doing is giving you an abolute reference to the column, the row, or the column and row.
The example above didn't work because the $ needs to proceed the column or row, so F$2$ is invalid (should be $F$2). F$2 is absolute reference to only row 2 although it works for your application apparently.
eMastercam - your online source for all things Mastercam.
Together, we are the strongest Mastercam community on the web with over 56,000 members, and our online store offers a wide selection of training materials for all applications and skill levels.