Problem developed "BEND CALCULATION TABLES"

Hello

I have a problem with the " bend calculation " option in sheet metal.
I would like to use the calculation method according to the DIN6935 standard for my complex part developments. The other methods that work and that I used are too far from the expected and desired result.

The message " The unit is invalid " appears when the function is executed.
It seems to me that the problem would come from the B7 box of the corresponding excel file (bend calculation table).
Link where to find the Excel file:
C:\Program Files\SOLIDWORKS Corp\SOLIDWORKS\lang\english\Sheetmetal Bend Tables
box B7 corresponds to " s " the thickness which is in mm in the standard and in the software.

Inconclusive methods of solving the problem have already been tried:

-I tried to change the units in solidworks 2021 (MKS. CGS. MMGS. IPS) I'm currently in MMGS.
-I tried to fill in the mm unit in box B7 of the excel file.
-I replaced the letter " s " with " D1 " in the formulas of the excel file, which corresponds to the name of my thickness dimension in my sketch.
-I tried the " bend calculate " option on a part from a step, on a part traced/extruded and then converted into sheet metal and on a sheet metal part creation starting from a flat rectangle and adding a fold. The result is the same with the error message.
-I tried to point the array to a folder on my C: disk containing my personal settings.

If someone could help me please
Sincerely,
Thank you

NB: Software installed SOLIDWORKS 2021 in English language used only in the interface.
License SOLIDWORKS STD
Excel under the latest generation office 365 pack.

Hello
The first idea that comes to mind is the decimal separator (" ." or " , ").
I had the problem with Inventor, where although the machine is configured in France, you have to use the point in the tables.

1 Like

Hello stefbeno,

Thank you for your quick feedback, I just tried but unfortunately it doesn't change anything.

See this topic where I shared my steel and stainless steel bending template table and the bend loss table (steel and stainless steel too)
These 2 files must be modified because they are linked.

Functional table with French tongue.
If it works, you can then modify them.

1 Like

Hello sbadenis,

Thank you for your feedback, however, as I mentioned before, I really need the solution according to the DIN6935 standard corresponding to folding in the air.
I only have a problem with this very specific method (bend calculate), the others work very well but the result of the development is too far away.
I am looking for precisions to 0.01mm on heavily hardened materials and low thicknesses in order to set pitch lengths to make tools tapping at 200 cps/min.
I'm really on a macro vision of the sheet metal function with a specific need that doesn't correspond to bending with abacus on press brakes like AMADA/PROMECAM etc...

Thank you for your interest
Yours sincerely

Can you attach the excel file?
And show which option exactly is selected, I don't understand the desired difference.
And for the standard I don't really know it, I just had the impression from your path that you wanted to set up the folding area table (and therefore the template):
image
Oops too late already clearer with the new posts!

1 Like

If you can attach a sample file and the desired value of dev, I can take a look.

I could indeed, however I don't know the LD and that's why I have to apply this method of calculating the K factor following DIN6935, in order to apply the neutral fiber in the right place using the equations (see attached photos 3) and thus determine my LD as accurately as possible.

Thank you

I understand your problem a little better.
Via this link:
https://www.goengineer.com/blog/solidworks-sheet-metal-bend-calculations-explained

I understand that the 1st excel table will look for the s and r values in the 2nd file.
If the drawn radius and ep doesn't match anything in the said file, I guess it shows the error.

3 Likes

Thank you sbadenis I'll look at this during the day or tomorrow, I had tried with the thickness " s " but not with the radius " r ".

I'll keep you posted
Thank you

Hello sbadenis,

So after checking and testing for the "Bend calculation " option, the only table used is the one attached above.
The second table in the link you shared is for the " Bend Table " option.

In the desired Excel table " bend calculation " it is impossible for me to fill in several values instead of " r " (example: D1 AND D2 which are the names of my rays in the sketch) and the converse is impossible here again because it is impossible for me to enter the same letter " r " for two different rays in my sketch.
That's why I would always have a name difference between my SolidWorks sketches and my calculation equations from the Excel file, which makes me think that the error doesn't come from the SolidWorks option or its table.

The most likely would be a problem due to the installation, I'll see with my SolidWorks support.

Sincerely,
Thank you

Ok keep us informed for the community and then close your topic.