Formula required from set of data

  • Context: Undergrad 
  • Thread starter Thread starter Mytheral
  • Start date Start date
  • Tags Tags
    Data Formula Set
Click For Summary

Discussion Overview

The discussion revolves around deriving a formula for quoting purposes related to radial bending on a press brake machine, using a provided set of data points that relate bend radius to distance between presses. The scope includes mathematical reasoning and exploratory approaches to modeling the relationship.

Discussion Character

  • Exploratory
  • Mathematical reasoning

Main Points Raised

  • Katie requests assistance in deriving a formula based on specific data points related to radial bending increments on steel.
  • Some participants suggest plotting the data to visualize the relationship and explore different types of curves for fitting.
  • One participant mentions using Excel's trendline option to fit various curves (linear, polynomial, exponential) to the data.
  • A participant provides a cubic polynomial formula for the relationship between bend radius and distance between presses.
  • Another participant offers a linear approximation as an alternative to the cubic polynomial function.

Areas of Agreement / Disagreement

There is no consensus on a single formula, as multiple approaches (cubic polynomial and linear approximation) are presented, reflecting differing preferences among participants.

Contextual Notes

The discussion includes various mathematical models and approaches, but the appropriateness of each model for the specific application remains unresolved.

Mytheral
Messages
5
Reaction score
0
Hi Guys,
Im doing my work placement at a steel processing facility and have been asked to derive a formula for quoting purposes that relates to radial bending on a press brake machine,

The formula is needed to show the radial pressing increments on steel and the data they have given me is as follows


At 150mm radius the distance between presses is 10mm
at 200mm radius it is 20mm
at 400mm radius it is 25mm
at 600mm radius it is 30mm
at 900mm radius it is 40mm
at 1500mm radius it is 50mm
at 2000mm radius it is 70mm

the formula does not need to be exact, it just needs to be a guideline for an entry level quoter.

any help would be greatly appriciated.

Katie
 
Physics news on Phys.org
Plot it and look at what the graph looks like.

BTW, are you allowed to seek help with this?

Zz.
 
Yes my manager advised me to post it on this forum. i have graphed it but am just having a mental block at the moment, must be due to the approaching weekend

i was originaly going to use a graph incorperated into excel for the quoters but my boss wants a formula :(

Katie
 
Hi Guys,
I am doing my work placement at a steel processing facility and have been asked to derive a formula for quoting purposes that relates to radial bending on a press brake machine,

The formula is needed to show the radial pressing increments on steel and the data they have given me is as follows


At 150mm radius the distance between presses is 10mm
at 200mm radius it is 20mm
at 400mm radius it is 25mm
at 600mm radius it is 30mm
at 900mm radius it is 40mm
at 1500mm radius it is 50mm
at 2000mm radius it is 70mm

the formula does not need to be exact, it just needs to be a guideline for an entry level quoter.

any help would be greatly appriciated.

Katie
 
Excel's "trendline" option allows you to fit various kinds of curves to the data (linear, polynomial, exponential) and display the equation. Play around with the different kinds of curves and see which one gives the best-looking result.
 
i can plot the info in excel but cannot find how to derive a formula. any help is greatly appriciated
 
y = (1.57e-8)(x^3) - (5.094e-5)(x^2) + (0.0724)(x) + 3.35, for 150 ≤ x ≤ 2000 mm, where x = bend radius (mm), and y = distance between presses (mm).
 
Last edited:
thankyou so much, your help is greatly appriciated
 
Mytheral: Here is another approach, a linear approximation, in case you prefer it more than the cubic polynomial function in post 7.

y = 0.0285*x + 11.6, where x = bend radius (mm), and y = distance between presses (mm).