Bust Common Myths About Java Programming
Loading
Tensile Strength and Capacity Control of the W-Shape Sections According to AISC 360-16
Loading
Concrete Cylinder Strength Vs Cube Strength
Loading
Earthquake Design Action Calculation
EM Wave Propagation Calculator
İKSA YAPILARI PROJELENDİRME HİZMET BEDELİ (2024)
section properties with units
GEOTEKNİK RAPOR (EK-B) ASGARİ HİZMET BEDELİ (2024)
Forward Kinematics of Robotic Arm with 6 Degrees of Freedom
ZEMİN İYİLEŞTİRME/DERİN TEMEL PROJELENDİRME ASGARİ HİZMET BEDELİ (2024)
İKSA YAPILARI PROJELENDİRME HİZMET BEDELİ (2023)
Loading
Dezi et. al (2010)
🤾
Projectile motion
The AEC industry is built on spreadsheets. Spreadsheets are intuitive for data entry and visualisation. You can easily organise data in the "visual" tabulated interface, from which common data manipulation can be performed. However, spreadsheets do have their limitations. They can get very complicated very quickly. Often only the author really understands how the sheet works and what assumptions and simplifications are baked in. Spreadsheets also have limitations in shareability.
CalcTree offers a solution enabling you to convert your Spreadsheet scripts into web applications, making them more accessible and shareable. This article will show you how to transform your Spreadsheet into a web app using CalcTree.
What is CalcTree?
Let's explore the three basic steps to convert your spreadsheet into a web app using CalcTree.
We will follow with an example calculation of a Concrete Column Designer to AS3600.
Step 1: Add a Spreadsheet Integration to CalcTree
In CalcTree, add a "Spreadsheet" source using the Integrations panel on the right-hand side of your page.
Step 2: Map Input and Output Parameters into CalcTree
Click on the spreadsheet source in the Integrations panel to open up the spreadsheet 'source viewer', which is a view of the spreadsheet that appears at the bottom of your page. In the source viewer, map the required inputs to your CalcTree page by clicking on the "+" in each cell. Alternatively you can map whole tables.
👉Tip: type "/" on your CalcTree page to open up the list of page components. Add text, headings, bullet points and columns to layout your report however you please. Move the parameters around your page to lay out your calculation in a logical order.
Here's an example of what the input and output parameters might look like for the column design:
Inputs
Material Properties
γc
:24.1kN/m3
f'c
:40MPa
Ec
:32.8 GPa
Es
:200 GPa
fsy
:500 MPa
Loads
N*
:30 MN
V*
:50 kN
M*
:350 kN m
Column Restraints
End #1:
Rotation - #1
:Fixed
Translation - #1
:FixedEnd #2:
Rotation - #2
:Fixed
Translation - #2
:FixedSection and Reinforcement Geometry
Lu
:6 m
D
:600 mm
b
:600 mm
Tensile Reinforcement,
:
d_Ast
:32 mm
No. of Ast bars
:4
cst
:30 mm
Compressive Reinforcement,
:
d_Asc
:32 mm
No. of Asc bars
:4
csc
:30 mm
Shear Reinforcement:
Stirrup diameter
:12 mm
Spacing of legs
:200 mm
Number of legs
:2
Output
Interaction Curve (combined flexural and axial check)
(M*, N*) < Interaction curve
:FAILSquash Load:
SL - ϕ
:0.65
SL - φNuo
:9905kN
Decompression Point:
DP - ku
:1
DP - ϕ
:0.6
DP - ϕNu
:6398.4kN
DP - ϕMu
:594.8kN m
Balanced Point:
BP - ku
:0.54545
BP - ϕ
:0.6
BP - ϕNu
:2892kN
BP - ϕMu
:960kN m
Pure Bending:
PB - kuo
:0.135
PB - ϕ
:0.85
PB - ϕMu
:689kN m
Step 3: Publish and Share Your Web App
Publish your app using the Share button in the top right-hand corner of your CalcTree page, making it available for your team or clients to use from anywhere.
👉See the live calculation here: Concrete Column Designer to AS3600
Conclusion
CalcTree offers a solution for transforming your spreadsheet calculations into interactive web applications. By following the three basic steps outlined in this article, you can convert your spreadsheet into a user-friendly web app, benefitting from enhanced transparency, better variable naming and easy sharing. This not only streamlines the calculation process but also promotes a more collaborative and efficient workflow within your organisation.
Related Articles
- Streamlining Your Workflow: How to Connect Spreadsheets and Python Scripts with CalcTree
- Embedding Spreadsheet Values in Reports with CalcTree