FRAME | Gallery Visitor Flow Sample Analysis

Prompt

Use the current VIFE Lite to generate an editable XLSX, "FRAME | Gallery Visitor Flow Sample Analysis", for a public Example. All visitor data are fictional samples; label every sheet "Simulated data · Not real visitors". Build 7 days × 4 galleries × 4 time slots, 112 rows in total, with the fields Date, Gallery, Time slot, Entries, Average dwell (minutes) and Interactive participants, and calculate the participation rate with a formula. At least four sheets: (1) Sample detail (frozen panes, filters, distinct colors for inputs and formulas); (2) Gallery summary (SUMIFS/AVERAGEIFS showing visitors, dwell time and participation rate); (3) Time slot heatmap (conditional formatting with clear notes); (4) Operations dashboard (KPIs, a gallery bar chart, a time slot trend chart, three observations limited to the sample, and recommendations that need validation with real measurement). Style it like a modern art museum guide: deep ink, ivory white and ochre red. Output the final XLSX with the existing openpyxl and check the 112 rows, formula references, charts, that no key values are blank and that it opens. Do not install software; after checking, deliver the final file and finish. Write all content, headings, labels, sheet names and file names in English.

Result

A1fxFRAME / VISITOR FLOW SAMPLE
ABCDEF1FRAME / VISITOR FLOW SAMPLE2Gallery Visitor Flow — Sample Analysis3Seven days · Four galleries · Four time…4Simulated data · Not real visitors5INPUT CELLS / Sample fields A–FFORMULA CELLS / Participation rate = In…67DateGalleryTime slotEntriesAverage dwell (minutes)Interactive participants846314Ink Hall10:00–12:0010333.222910

Built and checked the requested workbook with the existing openpyxl; nothing was installed.

Contents

  • 4 sheets: Sample detail, Gallery summary, Time slot heatmap, Operations dashboard
  • 112 rows: 7 days × 4 galleries × 4 time slots
  • 201 formula cells, including participation rate = Interactive participants ÷ Entries, SUMIFS/AVERAGEIFS, and dashboard KPIs
  • 2 charts: gallery bar chart and time-slot trend chart
  • Exact label on every sheet: “Simulated data · Not real visitors”

Verification

  • Opens in both openpyxl formula view and pandas
  • 112/112 detail rows complete; 112/112 participation formulas present
  • No blank key cells; all 201 formulas have matching cached results
  • No formula error tokens; 2 charts with correct source references
  • 0 text-fit flags across all sheets
  • Layout note: no native XLSX renderer is installed, so visual checking used a deterministic width/text-fit audit rather than a rendered PDF preview.

The workbook is a fictional public example; all visitor figures are synthetic.

How it was made

Mode
Spreadsheet
Try this prompt

Related spreadsheet prompts