Speeds, Feeds, Power, and Force (SFPF) Calculator

In the mid-90s a former boss of mine had a NeXTcube sitting under his desk, but he never booted it up as far as I know. He brought it with him from when he worked at NeXT–evidently he knew Steve Jobs too.

1 Like

I just tested the free OpenOffice Calc program on a Windows 10 PC. I opened the “2019-09-12 SPDF Workbook.xlxs” provided in the above posted .zip folder with both Excel and OpenOffice Calc. I then added worksheet tabs for a 0.5" endmill at 38 kRPM using both programs. As shown below and in the attached compressed folder, apparently the only thing OpenOffice Calc doesn’t support is the conditional formatting used for warnings in the Excel wordbook. Other than that, everything works surprisingly well - including Excel opening OpenOffice Calc’s .ods files and OpenOffice inserting individual sheets from the Excel workbook.
2019-09-13.zip (824.5 KB)

2 Likes

It’s good to see that OpenOffice is still being supported. The last time I used it was when Oracle acquired Sun Microsystems and it seemed like the whole OpenOffice suite was going to die off.

1 Like

"Google Docs will open Excel files."
I think that’s what @Vince.Fab uses. :slightly_smiling_face:

1 Like

For those that do not want to pay Microsoft you can get the open source Libre Ofice or Openoffice and they will open MS documents and output them to MS if done in their native file. Both are free and quite robust. I like the Libre Office but I used to work for Oracle and when they bought Sun Microsystems the application was called Star Office which became Openoffice. Oracle is so tight and will not give away anything they donated Openoffice to Apache so they did not have to support a free product.

LibreOffice and OpenOffice use the same source code and will open their native files in both applications.

So if you do not have MS Office you can still open and export in the MS formats.

1 Like

Will you use some wild programs i never heard of haha. not to be off topic but man they seem out there. Opensource/free/underground only? jk

Well, the NeXTstep stuff wasn’t opensource, save for TeX, and the Unix underpinnings.

Mostly, it’s a matter of never being will to accept the limitations and applications everyone else would:

  • Quark wouldn’t hang punctuation (except there was one XTension for Quark 3 which would, but Quark removed the API and it went away)
  • Excel has that ugly/traditional row/number, column/letter labeling convention
  • Illustrator has a Byzantine interface I’ve not grown accustomed to despite using it since v3.2
  • &c.

Mostly, it’s just a matter of having started w/ personal computers back at the beginning, and having access to pretty much all of the platforms — at one point in time, I had daily access to Mac OS, Windows, and NeXT computers of similar CPU-spec.

There are no perfect apps, in fact I think that in some cases, we’ve regressed. Some have not or barely evolved just enough to run on the latest OS. Why is it that no spreadsheet program can natively deal with any type of number value, convert them, heck, the way spreadsheet deal with time and date is arcane. I should be able to define units in cell that include size for example one cell in mm while another would be in inches and the conversion could be done automatically instead of having to enter a formula. Spreadsheets are a great tool as @gmack has shown but unfortunately, they have been abandoned by developers. On the other hand, we now have 10 spreadsheet apps that can open a spreadsheet saved in what used to be a proprietary format.

1 Like

I’m not a software guy, I just use the software tools that I once needed and now know. It would be great if someone would add a pretty GUI or redo the workbook to make it more palatable/useful. The spreadsheet formulas are all available. But please don’t obfuscate the underlying principles/math!:wink:

3 Likes

The workbook was updated to add the following worksheets to help answer @Vandel212’s question and correct cell E32 (i.e. to say “Cutting” instead of “Not Cutting”). Here’s the latest version.
2019-09-15 SFPF Workbook.zip (645.2 KB)

Here’s the latest workbook showing some sheets added to show several plywood cutting approaches.
2019-09-16 SFPF Workbook.zip (2.9 MB)

5 Likes

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.

OOPS - The original results from the SFPF calculator for straight router bits did not consider that it’s the cutter shaft material that determines the cutter deflection. Cutters that are carbide tipped (like the Amana) or use carbide inserts cutters likely have steel shanks - so they aren’t as stiff and deflect more. I’ve corrected this for the Amana bit as shown here.

Yonico makes a bottom cutting/clearing carbide tipped 3/4" diameter 1/4" shank router bit that should be able to plunge (I plan to try that). Since it’s only rated for 24,000 RPM, the 27,000RPM Dewalt trim router should provide more power than the 30,000 RPM Makita. Here’s what the SFPF calculator predicts for that.

As shown below, a 800 Watt HF spindle should enable twice the slot depth (and material removal rate) if the Shapeoko can handle the required doubling of force.

@WillAdams I’d like to update the closed SFPF calculator thread to reflect this correction and other minor changes if you think it’s worthwhile.

1 Like

Which HF router are you mentioning? The new one they released?

Probably the new one we recently discussed in another thread.

This one - but I admit to guesstimating the spindle’s rated current based on the power and voltage shown on it. What “new one”?

Not Harbor freight, High frequency… Harbor freight only has routers

Whoops, sorry. HF means “Harbor Freight” in most conversations I have so I misunderstood. However, I did mean their Makita clone.

1 Like

I’d use the Makita data for both the Harbor Freight and Carbide 3D “clone” router analyses. FYI my new $27 Harbor Freight 40" bolt cutter worked great Saturday to cut a hardened ~3/8" Master lock shackle.

1 Like

Eldar Gerfanov says: “There probably should be a “Max cutting force” value in the machine profile. I will add in the future updates [to HSMAdvisor].” IMO HSMAdvisor is a much more useful SFPF Calculator than GWizard and Eldar is much more responsive to questions and suggestions than BW. Hopefully he’ll make the mods necessary to put me “out of business”! @Vince.Fab and @Julien you might want to watch the steel cutting video in the first link!

1 Like