# reversal of concrete pressure calc.

• 06-19-2019, 02:05 PM
jon_horton
reversal of concrete pressure calc.
hi I'm trying to reverse a pressure calc for concrete.

I can calculate the pressure easily and have set up an excel document to do this.

I would know like to use all the same variables except I know the pressure, and know want to know the rise rate.
basically allowing me to change the temp co efficient and get an output of different rise rates.

formuale is

[TABLE="width: 662"]
[TR]
[TD="class: xl76, bgcolor: #E2EFDA, colspan: 4, align: center"]P = D[C1√R+C2K√(H- (C1√R)])

[/TD]
[/TR]
[/TABLE]

so want to make R the value to be found.

[TABLE="width: 662"]
[TR]
[TD="class: xl65, width: 71"] [/TD]
[TD="class: xl75, width: 502, colspan: 7, align: center"]Walls = where width or breadth > 2.0m, Columns were Width and Breadth <2.0m[/TD]
[TD="width: 89"][/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]C_Struc = [/TD]
[TD="class: xl68, bgcolor: yellow, align: center"]Column[/TD]
[TD]Unitless[/TD]
[TD="class: xl73, colspan: 6"](Wall = 1, Column = 1.5) , Concrete Stucture Type[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]C1 = [/TD]
[TD="class: xl67, align: center"]1.5[/TD]
[TD="width: 73"][TABLE]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="width: 37"][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[/TABLE]
[/TD]
[TD="class: xl73, colspan: 6"]Coeffcient dependant on size & shape of formwork[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]C_Type= [/TD]
[TD="class: xl69, bgcolor: yellow, align: center"]Retarded[/TD]
[TD]unitless[/TD]
[TD="class: xl73, colspan: 6"](Normal = 0.3, Retarded = 0.45, Heavily Retarded=0.6) Cement Type[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]C2 = [/TD]
[TD="class: xl67, align: center"]0.45[/TD]
[TD="width: 73"][TABLE]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="width: 43"][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[/TABLE]
[/TD]
[TD="class: xl73, colspan: 6"]Coefficent dependant on the constituent of Concrete[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl70"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]D[/TD]
[TD="class: xl69, bgcolor: yellow, align: center"]25[/TD]
[TD]kN/m³[/TD]
[TD="class: xl73, colspan: 4"]Weight Density of Concrete[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]h[/TD]
[TD="class: xl69, bgcolor: yellow, align: center"]9.05[/TD]
[TD]m[/TD]
[TD="class: xl73, colspan: 3"]Vertical Pour Height[/TD]
[TD="class: xl70"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]H[/TD]
[TD="class: xl69, bgcolor: yellow, align: center"]9.05[/TD]
[TD]m[/TD]
[TD="class: xl73, colspan: 3"]Vertical Form Height[/TD]
[TD="class: xl70"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]R[/TD]
[TD="class: xl69, bgcolor: yellow, align: center"]1[/TD]
[TD]m/hr[/TD]
[TD="class: xl73, colspan: 6"]rate at which the concrete rises vertically up the form[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]T[/TD]
[TD="class: xl69, bgcolor: yellow, align: center"]12.5[/TD]
[TD]°C[/TD]
[TD="class: xl73, colspan: 5"]Concrete Temperature ( Not Ambient Temp)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]K[/TD]
[TD="class: xl74, align: center"]1.60[/TD]
[TD]Unitless[/TD]
[TD="class: xl73, colspan: 4"](36/T+16)², Temp Coeffcient[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71, colspan: 3"]Cira 108 Provisions[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"][TABLE]
[TR]
[TD="class: xl72"]-When C1 R > H, the fluid pressure (Dh) Should be taken as the design pressure[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl70"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="width: 358, colspan: 5"][TABLE]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="width: 13"][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]P1 = [/TD]
[TD="class: xl67, align: center"]1.5[/TD]
[TD]m[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]H = [/TD]
[TD="class: xl67, align: center"]9.05[/TD]
[TD]m[/TD]
[TD="class: xl73, colspan: 3"]Vertical Form Height[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]Pd1 = [/TD]
[TD="class: xl76, bgcolor: #E2EFDA, colspan: 4, align: center"]Pressure is, D[C1√R+C2K√(H- (C1√R)])[/TD]
[TD][/TD]
[TD="class: xl79, bgcolor: #E2EFDA, colspan: 3, align: center"]Design Pressure = 86.82 kN/m²[/TD]
[/TR]
[TR]
[TD="class: xl63"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]Pd1 =[/TD]
[TD="class: xl74, align: center"]86.82[/TD]
[TD]kN/m²[/TD]
[TD="class: xl73, colspan: 3"]Calculated Pressure[/TD]
[TD="class: xl82, width: 266, colspan: 3, align: center"] - The Design Pressure is the smallest between the two calculated values[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]Pd2 = [/TD]
[TD="class: xl67, align: center"]226.25[/TD]
[TD]kN/m²[/TD]
[TD="class: xl73, colspan: 2"]Dh, Pressure[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]Hz= [/TD]
[TD="class: xl66, align: right"]3.47[/TD]
[TD]m[/TD]
[TD="class: xl73, colspan: 4"]Height of Hydrostatic Zone[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[/TABLE]
• 06-21-2019, 04:07 PM
JAlberts
If you have M***cel, one way to solve equations like this is to set up a sheet where you have inputs for all know data including a cells for P and R, then place the equation for P in a cell and use Excel's "Goal Seeking Function" and have it seek the desired (known) value for P by changing R. Note: Before starting the Goal Seeking enter an arbirary positive value in the R cell to give Goal Seeking a starting point.

If you are not familiar with the "Goal Seeking" function, you can find it under the "Data" tab, by picking the scroll down arrow on "What If Analysis" and you find the "Goal Seeking" function there.

See the below sample excel sheet with the goal seeking function selected:

[ATTACH]2306[/ATTACH]