Sheet Metal Development in Excel
baptiste-02
Posted messages
279
Status
Member
-
Vaucluse Posted messages 27336 Registration date Status Contributor Last intervention -
Vaucluse Posted messages 27336 Registration date Status Contributor Last intervention -
Hello everyone,
At work, I was asked to create an Excel or Access file to calculate the unfolding of a sheet metal.
Let me explain, we do sheet metal bending (from different materials), during bending we have a "phenomenon" of loss at the bend, which means that the unfolded sheet is always larger than the piece drawn on the plan. Because we have to compensate for the loss at the bend.
This loss varies depending on the material and the thickness.
I tried to create an Excel file to calculate the loss at the bend we will have depending on the material and the thickness. But I'm stuck on how to display the "result". I tried using a =VLOOKUP but nothing works... If you could give me a hand, that would be great.
I am attaching the file I created: https://www.cjoint.com/c/FEpkh5BfBn7
At work, I was asked to create an Excel or Access file to calculate the unfolding of a sheet metal.
Let me explain, we do sheet metal bending (from different materials), during bending we have a "phenomenon" of loss at the bend, which means that the unfolded sheet is always larger than the piece drawn on the plan. Because we have to compensate for the loss at the bend.
This loss varies depending on the material and the thickness.
I tried to create an Excel file to calculate the loss at the bend we will have depending on the material and the thickness. But I'm stuck on how to display the "result". I tried using a =VLOOKUP but nothing works... If you could give me a hand, that would be great.
I am attaching the file I created: https://www.cjoint.com/c/FEpkh5BfBn7
