I am trying to make a spreadsheet for our shop.

We are not allowed to spend time and material on trial and error on test bending. We can only use the in built software in the bending machine to calculate cut measures.

But as we experienced it is not always right and, neither does it give us any information the software uses to calculate k-factor.

So is there any way, by using a variety of formulas, depending on the bending angle, to make a spreadsheet with near accurate k-factors? Or if any have any spreadsheets made out already that works good? It have to be in mm, because those I have forund has been in inches and it will come out wrong if I try to fill in data in mm.

Wow! You are being asked to make perfect parts without doing the proper investigation, yet they don't like it when the parts come out wrong? They (management) obviously are not listening to themselves!!

Here are a couple things you CAN do. Start with the simplest part, one with the fewest bends, preferably a simple angle bracket. Measure the flat length and the flange lengths after bending. MEASURE the actual thickness. (This is the BIGGEST thing people overlook as they just

assumetheir thickness is in the middle of the listed range for the given gauge. It NEVER is and this plays a huge affect on the bending calculations.) Use the attached information to calculate a K-factor for this part and for this bend radius. Parts of similar thickness and bend radius can then use this K-factor. Properly done this is amazingly accurate.Do the same for any other parts with different thicknesses or different bend radius.

Inches vs. mm does not matter so long as the units are consistent within your calculations. If you share an example or two it will be easier to help you.