Holarch
Course chapters

Training · Track 14. Spreadsheets · Chapter 14.5 of 5

14.5 Excel Import and AI Formula Help 2:26

Import an Excel workbook and read its Import Summary, then let AI explain a formula and write one.

Shows Holarch 2.35.

What you’ll learn

  • Import an Excel workbook from the Spreadsheets page
  • Read the Import Summary and find cells that keep Excel's value
  • Have AI explain a formula
  • Have AI write a formula from a request, previewed before it is inserted

Finish the EO-1 mass budget: import an older subsystem budget kept in Excel and read the Import Summary, which recalculates every formula and compares it with Excel's result and lists the cells kept as Excel's values, then ask AI to explain the margin formula and to write a new formula, previewed with its result before it is inserted as one undo step.

Project files

  • Starting project (.holarch.json; Manage Projects → Project Files ▾ → Import Project (.json)…)
  • Finished project (.holarch.json; Manage Projects → Project Files ▾ → Import Project (.json)…)

The video plays from holarch.app; see the Privacy Policy.

Practice

Do this yourself in Holarch, on CubeSat EO-1.

  1. Open the chapter's starting file, or your workbook from chapter 14.4.
  2. Open Plan → Spreadsheets, click Import from Excel and choose an .xlsx workbook of your own.
  3. In the Import Summary, check the counts and the formula check. Click Show Cells if any cells keep Excel's value.
  4. Open the EO-1 Mass Budget. Right-click E11 and choose Explain Formula.
  5. Type Heaviest in B13. Right-click C13, choose Write a Formula, ask for the subsystem with the largest mass with contingency in rows 3 to 8, and insert the previewed formula.

You're done when the imported workbook is in the Spreadsheets list and C13 shows the name of the heaviest subsystem.

Check yourself

  1. What happens to a cell whose function Holarch does not calculate yet?
  2. Does Write a Formula change the sheet straight away?
  3. Which AI provider does formula help use?
Show the answers
  1. What happens to a cell whose function Holarch does not calculate yet?

    It keeps Excel's last value; the Import Summary lists it and a note under the formula bar says so.

  2. Does Write a Formula change the sheet straight away?

    No. It shows the formula and its result in a preview; Insert puts it in the cell as one undo step.

  3. Which AI provider does formula help use?

    The AI provider set up for Holarch; it is the same for every AI feature.

Read more

Transcript

Show the transcript (narration and what is on screen)

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.