SkyCiv文档

您的SkyCiv软件指南 - 教程, 使用指南和技术文章

SkyCiv API

  1. SkyCiv API
  2. 外挂程式
  3. SkyCiv for Excel

SkyCiv for Excel

Excel Add-in for SkyCiv API V3 Structural Analysis Design and Modelling

介绍

Excel is iconic spreadsheet software used widely in science and engineering. In structural engineering the power of Excel, 特别是结合宏, 以无障碍而闻名, 灵活性和计算能力. SkyCiv for Excel breaks new ground in engineering software integration by providing users with a full suite of structural analysis and design tools from within Microsoft Excel. It’s also worth noting that the plugin is a built-in app, not just a sheet or VBA macro.

This documentation page covers the following aspects of the SkyCiv Excel plugin:

入门

安装

To install SkyCiv for Excel, navigate to this page 然后点击 “Get it now”. Follow the install prompts and once installed, you should see the SkyCiv tab in the Excel client. 或者, you can install this add-on directly from Excel (just search the AppSource for SkyCiv):

Once installed, click the tab and you will be presented with a new ribbon of tools as seen below.

SkyCiv for Excel ribbon

Available Tools & 功能性

Here is a brief explanation of each button in the ribbon from left to right.

  • Auth: This is where you enter your SkyCiv API credentials. These are required to allow you to run analysis, 设计, access the sections database and open or save models. This is not required to build your model or to view it in the renderer.
  • 打开: This is where you can access all of your SkyCiv models, even those built on the website. Upon selection, the model will be imported into the workbook. If you have not selected the Setup button prior to selecting a model, this will automatically be done for you to create the tables.
  • 救: This is where you can save your model to the SkyCiv platform.
  • 在S3D中打开: This will save your excel model under the name ‘temp-exceland then open it in the browser. Allow 10 seconds or so for this action to complete.
  • 设置: This will create empty tables enabling you to build a model from scratch.
  • 栏目: This will present an interface where you can select various member sections and insert them into the sections table.
  • Analyze: This is where you can run an analysis on your model. The results will be provided in new sheets.
  • 设计: This is where you can run a design on your model. The results will be provided in new sheets.
  • 使成为: This will open the SkyCiv renderer inside Excel. You will see your model update live in the renderer as it is edited.
  • 关于: This button will open this page in the default browser.
  • 文件: This button will open the SkyCiv API docs in the default browser. This is where you can see what the allowable input is for each column of the SkyCiv worksheet.

造型

The best way to get started modeling is by clicking the Setup button and then choosing metric or imperial. The SkyCiv worksheet will be created with various tables. Expand the nodes and members sections by clicking the small + buttons above the column labels. Now click the Render button in the SkyCiv ribbon and you will see the Renderer task pane open on the right side of the workbook.

‘Id’ column for any table should start at 1 并增加 – 所以输入 1,0,0,0 在第一个节点表中. 这将创建一个ID为的节点 1 在x,和,z坐标 0,0,0. 现在在下一行, 添加另一个节点: 2,0,1,0. 这将创建一个ID为的节点 2 在 0,1,0. The renderer should now show two nodes, one at the origin, and another above it. If you do not see the two nodes, double-check that both rows are inside the nodes table by dragging the tiny arrow at the bottom right of the table to include both rows. This is what you should have so far.

SkyCiv for Excel - adding nodes to an excel model

Now let’s add a member. In the members’ SkyCiv 的 3D 建模和分析工具, create a new member by adding ‘1for the ID in the first row of the members’ SkyCiv 的 3D 建模和分析工具. Set ‘node_A’ 至 1, ‘node_B’ 至 2 and give a section ID of ‘1’. The section ID corresponds to the row in the sections table with that ID. Note that at this stage, the renderer will only represent sections as solid squares. Now your tables should look like the following.

Another great way to get familiar with the Add-in is to open a basic model via the Open button and inspecting how the model looks when represented by tables.

请注意,输入必须准确, 例如, if we were to change one of the units such as kg/m3 to g/m^3, 使用'^’ 会导致失败. To see allowable inputs for any column, click the Docs button and you will land on the API Documentation page for creating a model. This goes for table headers too, do not change these.

分析

Once authenticated using the Auth tab, you can run an Analysis through the Analyze tab. You can choose the type of analysis, and which load cases and combinations to run. Note that including all cases and combinations is a lot of data! To increase speed, only select those that you need.

Once completed, new worksheets will be created with the name of the load case and combination and each sheet will contain all the results data. We have created a Results Lookup section to help you quickly check data across all result sheets.

SkyCiv for Excel - 分析任务窗格

设计

Once authenticated using the Auth tab, you can run design checks through the Design tab. Choose the correct design code for your model and click design. Once completed, the design results will be added to a new sheet named “设计结果”. The Design task pane will provide a summary of the entire design and also a section to quickly inspect any member and even download a design report for the member. Using the model from the above analysis, the following image is the result of the Design. The CSA code was selected as the model was created using Canadian sections and the metric system.

SkyCiv for Excel - Design task pane

目前, the Excel plugin supports the following design codes checks:

  • 学会 360 2016 自卫队 & LRFD provisions
  • 欧洲规范 3
  • 如 4100
  • CSA S16 2014
  • 学士学位 5950
  • AISI S100
  • 如 4600
  • 是 800 非政府组织 & WSM

支持

Need help along the way? Feel free to email us at [email protected] or via our Live Chat once you are logged in to the platform. For information on our terms and conditions for this app, 访问我们的 Term’s and Conditions page.

本文对您有帮助吗??
是的 没有

我们能帮你什么吗?

回到顶部