Holarch
课程章节

培训 · 课程 13. 白板 · 第 13.4 章,共 4 章

13.4 实时数据、模型条目和剪贴画 3:17

将单元格粘贴为实时表格,将图表链接到电子表格单元格,将形状关联或转换为模型条目,并添加剪贴画。

演示 Holarch 2.35。

← 13.3 图表 · 所有章节

您将学到

  • 将 Excel 中的单元格粘贴为实时电子表格表格
  • 在“选择数据”中将图表链接到电子表格区域
  • 修改电子表格中的值,查看画板随之更新
  • 将形状关联到模型条目,并将形状转换为新条目
  • 查找、加星标并插入剪贴画

完成 Bike-Share Dock 概念白板:将 Excel 中的 dock 状态单元格粘贴为实时电子表格表格,用“选择数据”将条形图链接到相同的单元格,修改电子表格中的一个数字,查看表格和图表随之更新,将一个形状关联到模型的一个 Asset,将另一个形状转换为新的 Asset,并从“剪贴画”面板添加一张图片。

项目文件

  • 起始项目 (.holarch.json;管理项目 → 项目文件 ▾ → 导入项目 (.json)…)
  • 完成项目 (.holarch.json;管理项目 → 项目文件 ▾ → 导入项目 (.json)…)

视频从 holarch.app 播放;参见隐私政策。

练习

在 Holarch 中基于 Bike-Share Dock 亲自完成此操作。

  1. 打开本章的起始文件和 Dock Concept 白板。单击“画板”栏中的 +。
  2. 在 Excel 中复制一小块带标题行的单元格。单击画板,按 ⌘V / Ctrl+V(或 Ctrl+V),选择 实时电子表格,然后单击 粘贴。
  3. 插入 条形图,打开 选择数据… → 链接到电子表格区域…,选择新电子表格,输入区域,单击 链接,然后单击 确定。
  4. 双击表格,在电子表格中修改一个数字,然后通过其编辑器标签页返回画板。
  5. 在 Board 1 上,选择 Rental Kiosk 形状,单击 关联到…,选择 Rental Kiosk Asset。选择 Rider,单击 转换为模型…,选择 Asset 并单击 转换。
  6. 打开 剪贴画,搜索 bicycle,为一张图片加星标并单击它进行插入。

当表格和图表显示您修改的数字、两个形状都带有类标记,且画板上有一张自行车图片时,即完成练习。

自测

  1. 将单元格粘贴为图表与粘贴为实时电子表格有什么区别?
  2. 图表如何跟随电子表格单元格?
  3. “关联到…”和“转换为模型…”有什么区别?
显示答案
  1. 将单元格粘贴为图表与粘贴为实时电子表格有什么区别?

    图表保留值的副本,不会改变。实时电子表格会用这些单元格创建一个电子表格,并将其显示为随之变化的实时表格。

  2. 图表如何跟随电子表格单元格?

    在“选择数据”中用“链接到电子表格区域…”进行链接;图表随后从该区域绘制。

  3. “关联到…”和“转换为模型…”有什么区别?

    “关联到…”将形状与已有的条目关联。“转换为模型…”根据形状创建新条目,以其文字命名,并建立关联。

延伸阅读

文字稿

显示文字稿 (旁白和屏幕内容)

Introduction

Chapter four: live data, model items and clipart. A board can show figures that stay current, stand for items of the model, and use ready-made pictures.

In this chapter you finish the dock concept board.

Live data from pasted cells

Live data gets a board of its own. Click the plus in the Boards strip.

On screen: Boards strip → +.

The dock status is kept in a workbook: each station's docks, and the bikes available now. In Excel, select the cells and copy them.

On screen: Dock Status.xlsx.

Click the board, and press Command V, or Control V. Holarch asks how to paste the cells. Choose Live spreadsheet, and click Paste.

On screen: Click the board → ⌘V / Ctrl+V → Live spreadsheet → Paste.

Holarch creates a spreadsheet that holds the cells, and shows them on the board as a live table. Drag the table to the left.

On screen: The live table → drag it left.

A chart can follow the same cells. In the Tables and Charts panel, click Bar, and drag the chart beside the table.

On screen: Tables and Charts → Bar → drag it right.

Open Select Data, and click Link to Spreadsheet Range. Choose the new spreadsheet, type A1 to C5 as the range, and click Link.

On screen: Select Data… → Link to Spreadsheet Range… → A1:C5 → Link.

Select Data now names the linked range, and the chart shows the stations' docks and bikes. Click OK.

On screen: Linked range → OK.

The board follows the source

Now change a figure at its source. Double-click the table: its spreadsheet opens, with the cells selected.

On screen: Double-click the table → the spreadsheet.

Two more bikes are back at Riverside. In the Name Box, type C3 and press Enter, then type 6 in the formula bar, and press Enter.

On screen: Name Box C3 → formula bar 6 → Enter.

Go back to the board with its editor tab. The table and the chart already show six bikes at Riverside.

On screen: Editor tab → the board; the new value.

Model items on the board

Shapes on a board can stand for items of the model. Open Board 1, and select the rental kiosk.

On screen: Board 1 → select Rental Kiosk.

In the inspector's Model section, click Link to, search for Rental Kiosk, and choose the asset.

On screen: Link to… → Rental Kiosk (Asset).

The shape shows a badge, and the inspector names the linked asset. Click its name to see the asset's details in the side panel.

On screen: Badge; Model section → the asset.

A shape can also become a new item. Select the rider, and click Convert to Model. Choose Asset as the class, keep the name, and click Convert.

On screen: Rider → Convert to Model… → Asset → Convert.

The rider is now an asset of the model, linked to its shape, and listed in the Database with the other assets.

On screen: The linked Rider.

Clipart

Last, the Clipart panel: thousands of pictures and icons for concept graphics. Open it, and search for bicycle.

On screen: Clipart panel → search bicycle.

The star on a picture adds it to your favorites. Click a picture to add it to the board, and drag it below the rider.

On screen: Star → click the picture → drag it beside the rider.

Recap

To recap: paste cells as a live table, link charts to spreadsheet ranges in Select Data, link or convert shapes in the Model section, and add pictures from the Clipart panel.

That completes the whiteboard track. You can now sketch a concept with shapes and lines, chart its figures, keep them live, and tie the board to the model.

On screen: Track complete card, then end card.