课程章节
培训 · 课程 14. 电子表格 · 第 14.5 章,共 5 章
14.5 Excel 导入和 AI 公式帮助 2:26
导入 Excel 工作簿并阅读其导入摘要,然后让 AI 解释一个公式并编写一个公式。
演示 Holarch 2.35。
您将学到
- 从“电子表格”页面导入 Excel 工作簿
- 阅读导入摘要,找出保留 Excel 值的单元格
- 让 AI 解释一个公式
- 让 AI 根据请求编写公式,插入前先预览
完成 EO-1 质量预算:导入保存在 Excel 中的旧子系统预算并阅读导入摘要(它会重新计算每个公式并与 Excel 的结果比较,并列出保留 Excel 值的单元格);然后让 AI 解释余量公式并编写一个新公式,公式及其结果会先预览,再作为一个撤销步骤插入。
练习
在 Holarch 中基于 CubeSat EO-1 亲自完成此操作。
- 打开本章的起始文件,或第 14.4 章中的工作簿。
- 打开 计划 → 电子表格,单击 从 Excel 导入,选择您自己的
.xlsx工作簿。 - 在 导入摘要 中检查数量和公式检查结果。如果有单元格保留 Excel 的值,单击 显示单元格。
- 打开 EO-1 Mass Budget。右键单击 E11,选择 解释公式。
- 在 B13 中输入
Heaviest。右键单击 C13,选择 编写公式,请求第 3 至 8 行中含裕度质量最大的子系统,并插入预览的公式。
当导入的工作簿出现在“电子表格”列表中,且 C13 显示最重子系统的名称时,即完成练习。
自测
- 如果单元格使用的函数 Holarch 尚不能计算,会怎样?
- “编写公式”会立即修改工作表吗?
- 公式帮助使用哪个 AI 提供商?
显示答案
如果单元格使用的函数 Holarch 尚不能计算,会怎样?
它保留 Excel 的最后一个值;导入摘要会列出该单元格,编辑栏下方的提示也会说明这一点。
“编写公式”会立即修改工作表吗?
不会。它在预览中显示公式及其结果;单击“插入”才会将公式写入单元格,并作为一个撤销步骤。
公式帮助使用哪个 AI 提供商?
为 Holarch 设置的 AI 提供商;所有 AI 功能使用同一个提供商。
延伸阅读
文字稿
显示文字稿 (旁白和屏幕内容)
Introduction
Chapter five: Excel import and AI formula help. Workbooks you already keep in Excel come into a project with their formulas live. And AI can explain a formula, or write one from a request.
In this last chapter, you bring in an Excel workbook and work with AI.
Import an Excel workbook
An older subsystem budget is kept in Excel. Open Plan, then Spreadsheets, and click Import from Excel. Choose the workbook.
On screen: Plan → Spreadsheets → Import from Excel… → EO-1 Subsystem Budget.xlsx.
Every sheet comes in, with its values, live formulas, formats, names and charts, in one undo step. The Import Summary counts what arrived.
On screen: The Import Summary: counts.
Then Holarch recalculates every formula and compares each result with Excel's. Here, every compared formula matches.
On screen: The recalculation check.
A function Holarch does not calculate yet keeps Excel's value. The summary lists those cells, with the reason. Show Cells marks them in the sheet, and the note under the formula bar says the value is Excel's last result.
On screen: Value only cells → Show Cells → the note.
Everything else is live, as in the budget you built. Go back to the EO-1 Mass Budget.
On screen: Spreadsheets → EO-1 Mass Budget.
AI formula help
AI helps with formulas. Right-click the margin in E11, and choose Explain Formula. The answer says what the formula calculates, step by step, with the cells it uses.
On screen: Right-click E11 → Explain Formula: the explanation.
Write a Formula turns a request into a formula. In B13, type Heaviest. Right-click C13, choose Write a Formula, and ask for the subsystem with the largest mass with contingency.
On screen: B13 Heaviest; right-click C13 → Write a Formula… → the request → Write Formula.
The preview shows the formula and its result before anything changes. Insert puts it in the cell, as one undo step.
On screen: The preview → Insert.
Recap
To recap: import Excel workbooks from the Spreadsheets page and check the Import Summary, and let AI explain or write formulas, always previewed first.
That completes the spreadsheet track. You can now build a workbook, format and organize it, chart it, feed it from the model, bring in Excel files, and get AI help with formulas.
On screen: Track complete card, then end card.