Hello Guest it is April 01, 2020, 11:19:21 PM

Author Topic: Axis Drive Design Helper Spreadsheet  (Read 6658 times)

0 Members and 1 Guest are viewing this topic.

Re: Axis Drive Design Helper Spreadsheet
« Reply #10 on: October 27, 2009, 06:26:43 PM »
Here is the formula for the thrust at target feedrate for both metric and inch: IF(B6="Stepper";IF(B3="Metric";B49*B30*B22*6280/B27;B49*B30*B22*0,392/B27);"")

Edit: I think......  ;)

More edit: Changed the constant "6140" to "6280"

Yet more edit: Changed the constant "0,384" to "0,392"
« Last Edit: October 27, 2009, 08:55:26 PM by SteinarN »
Re: Axis Drive Design Helper Spreadsheet
« Reply #11 on: October 28, 2009, 05:09:47 PM »
Ray, a couple questions, I'm not very familiar with excel, is it possible to make the "white" cells read only? It is easy to accidentally remove the formulas in those cells. Of course, if not saved, you can reopen the document to recover the lost formulas but it would be better if you couldn't erase the cells in the first place.

I like the "drop down" list. How do you make one? I couldn't find this function.

Steinar
Re: Axis Drive Design Helper Spreadsheet
« Reply #12 on: October 28, 2009, 05:32:12 PM »
Ray, a couple questions, I'm not very familiar with excel, is it possible to make the "white" cells read only? It is easy to accidentally remove the formulas in those cells. Of course, if not saved, you can reopen the document to recover the lost formulas but it would be better if you couldn't erase the cells in the first place.

I like the "drop down" list. How do you make one? I couldn't find this function.

Steinar
Steinar,

I don't know of any way to protect individual cells, but I'm no expert either.

To create a drop-down, create the list of values you want to allow (they're at the bottom of column A in my spreadsheet), select the cell you want to have the drop-down, then select Data->Validation, and in the drop-down in the dialog that pops up, select "List", then put in the range of cells containing the allowable values.

Regards,
Ray L.
Regards,
Ray L.
Re: Axis Drive Design Helper Spreadsheet
« Reply #13 on: October 28, 2009, 05:53:37 PM »
Ahh, many thanks Ray :)

Offline alenz

*
  •  137 137
    • View Profile
Re: Axis Drive Design Helper Spreadsheet
« Reply #14 on: October 29, 2009, 12:19:53 AM »
Ray, a couple questions, I'm not very familiar with excel, is it possible to make the "white" cells read only?

Steiner, unlock the green cells and then protect the sheet as follows:

Select a green cell(s), right click, select Format Cells.. > Protection and remove the check from the “Locked” box.
Repeat for all green cells.

Go to Tools > Protection > Protect Sheet..
Check the “Protect worksheet and contents of locked cells”.
It’s OK to leave the password entry blank.
In the bottom window uncheck everything except “Select unlocked cells”.

Now excel will only let you select the green cells.

Al
Re: Axis Drive Design Helper Spreadsheet
« Reply #15 on: October 29, 2009, 04:29:22 PM »
Ray,

have you updated the spreadsheet yet?