summerofgeorge

<style>
  .sf {
    /* Light (default) */
    --sf-bg: #EEECE1;
    --sf-surface: #FFFFFF;
    --sf-ink: #1F2120;
    --sf-body: #707070;
    --sf-accent: #CF3338;
    --sf-accent-deep: #C00000;
    --sf-accent-text: #CF3338;

summerofgeorge

## DATA
Never edit the Data tab directly. Treat it as read-only source data.
Fiscal year runs July through June. "FY26" means July 2025 through June 2026.

## CALCULATIONS
Gross margin = (Revenue - COGS) / Revenue, calculated at the product level.
Round margin percentages to one decimal place.

## OUTPUT
Put executive summaries on the Dashboard tab.

summerofgeorge

name	variance-commentary
description	Use when I ask for a monthly variance analysis or budget-vs-actual commentary on a P&L or department summary. Compare actuals to budget and to the prior period, surface the material movers, and write exec-ready commentary.

Monthly variance commentary

When I point you at a P&L or a department summary and ask for variance commentary, follow this process.

Comparisons

summerofgeorge

summerofgeorge

summerofgeorge

function main(workbook: ExcelScript.Workbook) {

  const totalRevenue = workbook
    .getNamedItem("TotalRevenue")
    .getRange()
    .getValue() as number;

  console.log(totalRevenue);
}

summerofgeorge

Goal:
Update missing Expense Code and Expense Name fields in the uploaded Excel workbook using the official "Accounting Expense Codes.pdf".

Instructions:

1. Open the uploaded Excel workbook.
2. Identify the worksheet containing the expense report.
3. Locate the following columns by header name:
   - Description
   - Vendor

summerofgeorge

This topic analyzes an uploaded Excel workbook and generates a simple data dictionary of all structured Excel tables. 

It identifies each table’s name, worksheet location, column headers, and provides a brief plain-English description of what the table appears to track. 

The workbook is not modified.

summerofgeorge

You are a data profiler assistant for Excel workbooks.

Your job is to:

1. Open the uploaded Excel workbook.
2. Identify all structured Excel tables in every worksheet.
- Ignore raw ranges that are not defined as structured tables.
3. Count the total number of structured Excel tables.
4. For each structured table:
- Extract the table name.

summerofgeorge

This topic profiles an uploaded Excel workbook and generates a structured overview of all defined Excel tables it contains. 

It identifies each table’s name, worksheet location, column structure, and provides a brief plain-English summary of what the table appears to track. 

Only structured Excel tables are evaluated, and the workbook is not modified.