This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
1. ENTER DATA ON YELLOW CELLS HERE:
1.1
MATERIAL
name=
ONLY THE YELLOW CELLS HAVE TO BE FILLED !!!
E =
N/mm
2
Ftu=
N/mm
2
ALL OTHER VALUES ARE CALCULATED
Fty=
N/mm
2
e
max =
%
1.2. LINEAR STRESS (that you want to correct using the NEUBER plasticity correction))
K
t
S =
N/mm
2
2. BE SURE THAT THE VALUE OF
KtS . Kte (cell
G40
) - AFTER FILLING DATA ON THE YELLOW CELLS - WAS AUTOMATICALLY COPIED TO CELL
D17
(blue).
K
t
S . K
t
e =
(used for the goal-seek macro)
<---- this cell is used for the macro and should present the same value of C17 when the calculation is finished
3. PRESS THE BUTTON FOR RUNNING THE NEUBER MACRO AND SEE MESSAGE BESIDE BUTTON
.
4. COPY THE BLOCK FOR THE CONDITION YOU WANT TO YOUR REPORT - FOUR POSSIBILITIES - AS THE BLUE TITLES
CALCULATION FOR LIMIT AND ULTIMATE LOAD WITH RESULT AS RESERVE FACTOR (RF)
CALCULATION FOR LIMIT AND ULTIMATE LOAD WITH RESULT AS MARGIN OF SAFETY (MS)
E =
N/mm
2
E =
N/mm
2
Ftu =
N/mm
2
Ftu =
N/mm
2
Fty =
N/mm
2
Fty =
N/mm
2
e
max =
%
e
max
=
%
e
y =
(Fty
/
E
)
e
y
=
(Fty
/
E
)
K
t
S =
-->
K
t
e =
KtS =
-->
K
t
e =
K
t
S . K
t
e =
KtS . Kte =
e
max -
e
y =
e
max
- e
y
=
Dp = Ftu - Fty =
Dp = Ftu - Fty =
R1 = Dp / (
e
max -
e
y ) =
R1 = Dp / ( e max - e y ) =
for given
e
p
in the plastic region:
S
p
=
Fty + R1(
e
p
-
e
y
)
(1)
for given
e
p
in the plastic region:
S
p
=
Fty + R1(
e
p
-
e
y
)
(1)
NEUBER
states that:
K
t
S . K
t
e =
e
p
. S
p
(2)
NEUBER
states that:
K
t
S . K
t
e =
e
p
. S
p
(2)
Finding the values of
e
p
and S
p
that match equations (1) and (2):
Finding the values of
e
p
and S
p
that match equations (1) and (2):
S
p
=
N/mm
2
(corrected stress value)
S
p
=
N/mm
2
(corrected stress value)
e
p
=
(corrected strain value)
e
p
=
(corrected strain value)
K
t
S / 1.5 =
<
( KtS / 1.5 <
Fty )
K
t
S / 1.5 =
<
( KtS / 1.5 <
Fty )
For Ultimate Load
RF =
( Ftu / Sp )
For Ultimate Load
MS =
( Ftu / Sp )
For Limit Load
RF =
( Fty / ( Sp / 1.5) )
For Limit Load
MS =
( Fty / ( Sp / 1.5) )
CALCULATION FOR ULTIMATE LOAD WITH RESULT AS RESERVE FACTOR (RF)
CALCULATION FOR ULTIMATE LOAD WITH RESULT AS MARGIN OF SAFETY (MS)
E =
N/mm
2
E =
N/mm
2
Ftu =
N/mm
2
Ftu =
N/mm
2
Fty =
N/mm
2
Fty =
N/mm
2
e
max =
%
e
max
=
%
e
y =
(Fty
/
E
)
e
y
=
(Fty
/
E
)
K
t
S =
-->
K
t
e =
KtS =
-->
K
t
e =
K
t
S . K
t
e =
KtS . Kte =
e
max -
e
y =
e
max
- e
y
=
Dp = Ftu - Fty =
Dp = Ftu - Fty =
R1 = Dp / (
e
max -
e
y ) =
R1 = Dp / ( e max - e y ) =
for given
e
p
in the plastic region:
S
p
=
Fty + R1(
e
p
-
e
y
)
(1)
for given
e
p
in the plastic region:
S
p
=
Fty + R1(
e
p
-
e
y
)
(1)
NEUBER
states that:
K
t
S . K
t
e =
e
p
. S
p
(2)
NEUBER
states that:
K
t
S . K
t
e =
e
p
. S
p
(2)
Finding the values of
e
p
and S
p
that match equations (1) and (2):
Finding the values of
e
p
and S
p
that match equations (1) and (2):
S
p
=
N/mm
2
(corrected stress value)
S
p
=
N/mm
2
(corrected stress value)
e
p
=
(corrected strain value)
e
p
=
(corrected strain value)
For Ultimate Load
RF =
( Ftu / Sp )
For Ultimate Load
MS =
( Ftu / Sp )
Print All Information
Please host the converted page in server to use Print All.
Evaluation only
The page is only for evaluating
SpreadsheetConverter
The page as a whole or parts of it is only allowed to be used for evaluating
SpreadsheetConverter
. All publishing on a webserver, for other purposes than evaluation, requires a license of SpreadsheetConverter.
Do not show next time
Update
Reset
Print All
Submit