Spreadsheet

A workbook tab beside Circuit Builder. Pull a snapshot of the live simulation, edit cells with Google Sheets-style formulas, drop charts on the grid, then export XLSX or CSV. Clearing the sheet never touches the Qubi program.

From Circuit

Adds one or more sheets from the current run:

  • Program summary (qubits, depth, scheduling).
  • Sweep table when the file has <…> dimensions. LOOP columns sit first, then P (%), other dims, Combo.
  • Outcome probabilities for the computational basis.
  • Bloch coordinates per visible qubit.
  • State vector (re, im, |amp|²).
  • Chart objects (line for sweeps, bars for probabilities) sitting on the sheet.

Uses the Circuit Builder combo bar, so a sweep import is the active binding. A sweepstate bitstring names the default highlight ket. The imported run still starts in |00…0⟩. Videos From Circuit can pick those chart objects up when you tick Spreadsheet charts.

Grid commands

ActionHow
EditClick a cell, type to replace. Double-click or the formula bar for a long edit. Name box shows the A1 address.
FillDrag the handle on the selection. Relative refs shift; $A$1 stays locked.
Copy / cut / pasteCtrl+C / X / V. Formulas adjust like Excel.
Undo / redoCtrl+Z / Ctrl+Y on the workbook.
SheetsTabs at the bottom. Double-click to rename. + adds a sheet. × closes.
ResizeDrag row/column edges. Double-click auto-fits.
Grow grid+ on the last row or column adds 10 more.
SortClick the arrow on a table header: asc, desc, reset.
Scroll framesToolbar control. Select at least two rows or columns, then scroll that window while the rest of the sheet stays put. From Circuit uses this on tall result tables.
FormatBold, italic, underline, strike, font size, wrap, overflow, text color, fill, links.

Formulas

Start a cell with =. Refs are A1 style (A1, $B$2, A1:D10). Operators: + - * / ^ & percent, comparisons. Errors: #DIV/0! #VALUE! #REF! #NAME? #NUM! #N/A #CYCLE!.

Math and stats

SUMAVERAGEAVERAGEAAVECOUNTCOUNTACOUNTBLANKMAXMINPRODUCTABSSQRTPOWERMODINTROUNDROUNDUPROUNDDOWNCEILINGFLOORPIEXPLNLOGLOG10SIGNRANDRANDBETWEENMEDIANSTDEVSTDEVASTDEVPSTDEVPAVARVARAVARPVARPASINCOSTANASINACOSATANATAN2RADIANSDEGREESFACTCOMBINEVENODDTRUNCQUOTIENTGCDLCM

Logic

IFIFERRORIFNAIFSSWITCHCHOOSEANDORXORNOTTRUEFALSENA

Text

CONCATENATECONCATTEXTJOINLEFTRIGHTMIDLENLOWERUPPERPROPERTRIMSUBSTITUTEREPLACEFINDSEARCHREPTEXACTCHARCODECLEANVALUETN

Lookup and criteria

INDEXMATCHVLOOKUPHLOOKUPSUMIFCOUNTIFAVERAGEIFSUMIFSCOUNTIFSAVERAGEIFS

Info and dates

ISBLANKISNUMBERISTEXTISERRORISERRISNATYPETODAYNOWDATEYEARMONTHDAYWEEKDAYEDATEEOMONTH

Example: =SUMIF(B2:B20,">10",C2:C20) and =IF(D2>0.5,"marked","rest").

Charts

Select a range, click Insert Chart. Types:

ColumnBar (horizontal)LineAreaPieDoughnutScatterRadar

Chart Options (pencil on the widget, or after insert): title, range, bar orientation, axis titles, header row / label column. More Options (scrolling side panel) holds X and Y separately: auto-adjust to largest value, plus min and max when auto is off, plus legend, grid, palette, fonts, background. Drag to move, corner to resize, copy to duplicate. Paste a chart onto Slides as an overlay.

Files

Save Copy writes .qsp to Storage. Open loads one. Export XLSX (default) or CSV from the caret. Clear wipes the current sheet content only.