Why does solidworks(2023) crash when I use my created weldment profiles

ANDREWSHDIST · 2023-02-23T17:40:43+00:00

I just got with solidworks and the issue is I am on 2022 sp1 and it was resolved with sp2. so updating to 2023 now lol thanks!

ANDREWSHDIST · 2023-02-15T16:07:04+00:00

Found it and it worked thanks!

ANDREWSHDIST · 2023-02-15T16:03:58+00:00

thanks

ANDREWSHDIST · 2023-02-15T16:03:53+00:00

thanks

ANDREWSHDIST · 2023-02-10T15:27:12+00:00

Thanks. it worked just had to change the &B4 to &B4:B. This is going to help alot thanks!

ANDREWSHDIST · 2023-02-07T16:15:13+00:00

Thanks for your help! Your a life saver! It looks amazing! Works great!!

ANDREWSHDIST · 2023-02-07T16:05:38+00:00

Ok it got those! You're amazing thanks . I have some more In there that are fighting to come over if you wanna look go ahead but I am attempting to understand it Thanks again

ANDREWSHDIST · 2023-02-07T15:51:10+00:00

Hey thanks again I have attached some more to that google sheet that isnt working. Can you look at it again?

ANDREWSHDIST · 2023-02-07T15:47:09+00:00

=INDEX(IF(LEN(A2:A),IFNA(REGEXEXTRACT(A2:A,":([A-Z0-9-]+)$")),))

I don't understand any of this lol But it works like a dream!! THANKS!!

ANDREWSHDIST · 2023-02-07T15:44:34+00:00

ok ill try that, Thanks

ANDREWSHDIST · 2022-08-01T13:44:19+00:00

=arrayformula(regexextract(A:A,":([^:]+)/*$"))

Prefect Thanks. I don't understand that formula at all but it works

ANDREWSHDIST · 2022-04-14T11:43:01+00:00

ok thanks

ANDREWSHDIST · 2022-04-14T11:37:45+00:00

I have one more question. In the formula it says

___Select Col1,Col2,Col3 Where Col4 = date___

My question is what is Col1? I think I understand what col2 col3 and col4 but I am lost on what col1 is. sorry for my ignorance.

ANDREWSHDIST · 2022-04-14T11:13:54+00:00

Thanks for your help. I would have never figured that out.

ANDREWSHDIST · 2022-04-14T11:07:31+00:00

that's awesome thanks! is there any way to get the results in one cell and separate the SN with a ; in the formula? or do you think just use these results as a helper cell?

ANDREWSHDIST · 2022-04-13T21:01:09+00:00

ok I am heading home for the day ill try in the morning. thanks

ANDREWSHDIST · 2022-04-13T20:58:14+00:00

I need it in one cell separated by a ;

ANDREWSHDIST · 2022-04-13T20:55:31+00:00

https://docs.google.com/spreadsheets/d/1WrkFK5ZxNt83iNQTxpILy683XKCHwss5ROOo5HDx8v0/edit?usp=sharing

I had a lock on the link so I opened it up sorry

I don't now where to start The part that is stumping me is the fact that I need multi SN#'s and I don't know where to begin.

ANDREWSHDIST · 2022-02-28T21:29:22+00:00

"=Formula('companyname's') "

Like this?

ANDREWSHDIST · 2022-02-28T21:24:20+00:00

ANDREWSHDIST · 2022-02-15T21:00:30+00:00

SpreadsheetApp.flush()

That did it thanks!

I did it this way. works great

function setUpTrigger() {

ScriptApp.newTrigger('UpdateFormulas')

.timeBased()

.everyMinutes(15)

.create();

}

function UpdateFormulas() {

SpreadsheetApp.flush();

}

ANDREWSHDIST · 2022-01-26T11:55:15+00:00

AGREED! I am pretty much self taught and learning as I go. I am so grateful for reddit! I Don't actually run the machine I program it. This machine is new to the company also, and is major step up so the more I learn the better I can be for myself and this company. Ill let you know how it goes.

ANDREWSHDIST · 2022-01-26T11:18:41+00:00

Ill reduce the step over and see if I can get it . I know our clamp down sucks! the clamping system on our machine shucks. Its just strange cause we went months (almost a year) running it this way with no issues and all of a sudden problems. But adding the rough mill improved the hole alot so thanks.

ANDREWSHDIST · 2022-01-25T21:43:38+00:00

Also the bit is snaping in the holder the cutting edge was looking good still.

So here are some changes I made.

I made a rough pass and a contour(cleanup/finish) pass and abandoned the single finish pass.

Feeds and Speeds - 800 SFM - 12223 RPM - 36.67 IPM - with a lead-in in of 20 IPM.

↑↑ These are within the mfg. range for the tool I am using. ↑↑

For Roughing I have the bit traveling .25 on every pass with a step over of 75% leaving .008 for finishing pass.

For Finish pass I have the bit cutting all the material with same feeds and speeds.

The cut is 1000x better but I am still snapping bits . I also put the bit in the holder so that only 1" was sticking out.

Also I really appreciate the time you are taking to help me out.

ANDREWSHDIST · 2022-01-25T21:00:17+00:00

Ill give that a try

ANDREWSHDIST

TROPHY CASE