Kition

Kit 11 / 16 · 41 samples · 7 categories

Sheet samples

Spreadsheets: formulas, number formats, styles, merged cells, tables, charts and several sheets. Saved as .xlsx.

Café Chain Quarterly Roll-up — Sheet sample rendered by Kition

saved → cafe-chain-quarterly-rollup.xlsx ✓96 commands · 145 ms

agent · sheet kit+ 90 more commands · 145 ms
  1. sheet.rename(name)
  2. range.setValues(range, values)
  3. home.fontSize(range, size)
  4. home.bold(range, on)
  5. home.fontColor(range, color)
  6. home.fontColor(range, color)

Kits

Business Templates 5

sheetBusiness Templates

Payroll Register

A fortnight's payroll for a small bistro, from hours and rates through overtime, pre-tax retirement, withholding and FICA to net pay.

1 sheet; used range A1:L14
sheetBusiness Templates

Print Shop Invoice

A ready-to-send invoice with line discounts, rounded sales tax, a deposit and the balance due, laid out without gridlines.

1 sheet; used range A1:F24
sheetBusiness Templates

Renovation Estimate

A contractor's bathroom quote with labour and materials, optional extras switched by a Yes/No list, markup, contingency, tax and deposit.

1 sheet; used range A1:F26
sheetBusiness Templates

Travel Expense Report

A conference trip's receipts in two currencies, converted, split into company-paid and reimbursable, and summed by category.

1 sheet; used range A1:L16
sheetBusiness Templates

Weekly Timesheet

Clock-in and clock-out times turned into daily hours, daily overtime past eight hours and the week's pay, with time arithmetic.

1 sheet; used range A1:I17

Charts 5

sheetCharts

Market Share Doughnut

Unit sales of five coffee brands turned into shares, a change-in-points column and a labelled doughnut chart.

1 sheet; used range A1:E10
sheetCharts

Profit Bridge Waterfall

A waterfall chart that walks operating profit from last year to this year through its drivers.

1 sheet; used range A1:B16
sheetCharts

Revenue and Margin Combo

Monthly revenue and gross profit as columns with gross margin as a line on a secondary axis.

1 sheet; used range A1:D17
sheetCharts

Sign-up Trend Forecast

Twenty weeks of trial sign-ups as columns with a linear trendline, the fit worked out in cells and a week-24 forecast.

1 sheet; used range A1:F24
sheetCharts

Employee Survey Results

Five-point agreement answers for eight survey statements, shown as a 100% stacked bar chart with a net-agreement score.

1 sheet; used range A1:H12

Finance & Budgets 9

sheetFinance & Budgets

Break-Even Analysis

How many coffee drippers a small pottery has to sell each month to cover its costs, with the revenue and cost lines crossing on a chart.

1 sheet; used range A1:F20
sheetFinance & Budgets

12-Month Cash Flow Forecast

A bakery's year of cash in and cash out, month by month, with running balances, a colour scale and a warning when cash dips under the buffer.

1 sheet; used range A1:N25
sheetFinance & Budgets

Depreciation Schedule

One machine depreciated four ways, with SLN, SYD, DDB and VDB side by side and the book value each leaves behind.

1 sheet; used range A1:H19
sheetFinance & Budgets

Household Budget

A monthly budget with planned and actual spending, variance formulas, a total row and a column chart.

1 sheet; used range A1:E12
sheetFinance & Budgets

Investment Growth Projection

Twenty-five years of monthly saving projected with FV, split into money paid in and growth earned, with a line chart of the gap opening up.

1 sheet; used range A1:F36
sheetFinance & Budgets

Loan Amortization Schedule

A five-year car loan paid off month by month, with PMT, IPMT and PPMT splitting every payment into interest and principal.

1 sheet; used range A1:H69
sheetFinance & Budgets

Mortgage Comparison

Three ways to finance the same house side by side, from the monthly bill to the interest paid over the life of the loan.

1 sheet; used range A1:D20
sheetFinance & Budgets

Mortgage Rate Sensitivity

A two-variable data table of monthly payments for every loan size and interest rate, shaded from affordable to stretched.

1 sheet; used range A1:J12
sheetFinance & Budgets

Project Appraisal (NPV & IRR)

Two capital projects compared on NPV, IRR, MIRR, profitability index and payback, with a verdict for each.

1 sheet; used range A1:H20

Formatting & Styles 4

sheetFormatting & Styles

Number Format Gallery

A reference card that shows the same numbers, dates and codes through a dozen built-in and custom number formats.

1 sheet; used range A1:I15
sheetFormatting & Styles

Regional Sales Heat Map

Twelve months of sales for ten regions, shaded by a three-colour scale so the peaks and the quiet months stand out.

1 sheet; used range A1:N17
sheetFormatting & Styles

Support KPI Scorecard

A monthly customer-support scorecard with attainment data bars, coloured trend arrows and rule-driven status pills.

1 sheet; used range A1:H15
sheetFormatting & Styles

Team Skills Matrix

An engineering team's skills grid with angled column headers, dot ratings from a number format and named cell styles.

1 sheet; used range A1:L17

Formulas & Functions 7

sheetFormulas & Functions

Dynamic Array Event Report

Three spilling summaries of a conference sign-up list, built with UNIQUE, SORT, FILTER, SORTBY, CHOOSECOLS and TAKE.

1 sheet; used range A1:I23
sheetFormulas & Functions

Exam Score Statistics

A class's test scores described with AVERAGE, MEDIAN, MODE, STDEV, QUARTILE and PERCENTILE, binned with FREQUENCY into a histogram.

1 sheet; used range A1:L28
sheetFormulas & Functions

Invoice Due-Date Tracker

Due dates that skip weekends and office holidays with WORKDAY, business days with NETWORKDAYS, and a status for every invoice.

1 sheet; used range A1:M19
sheetFormulas & Functions

Sales Commission Calculator

Quarterly payouts for eight reps with tiered marginal commission from a named LAMBDA, VLOOKUP rate bands and IFS bonuses.

1 sheet; used range A1:M13
sheetFormulas & Functions

SUMIFS Regional Sales Summary

A quarter's deal log rolled up by region and product with SUMIFS, COUNTIFS, AVERAGEIFS and MAXIFS.

1 sheet; used range A1:M28
sheetFormulas & Functions

Text Cleanup with Functions

A messy contact import tidied with TRIM, PROPER, TEXTBEFORE, TEXTAFTER, TEXTJOIN and a LET formula that rebuilds every phone number.

1 sheet; used range A1:H17
sheetFormulas & Functions

XLOOKUP Order Form

An order form that fills in item names, categories, prices and volume discounts from a catalog with XLOOKUP and INDEX/MATCH.

1 sheet; used range A1:L21

Planners & Trackers 5

sheetPlanners & Trackers

Class Timetable

A secondary-school week with double lessons as merged cells, merged break rows and subject colours from text rules.

1 sheet; used range A1:J12
sheetPlanners & Trackers

Monthly Habit Tracker

A November habit grid where a 1 becomes a dot through a number format, with completion rates, data bars and a daily heat row.

1 sheet; used range A1:AG13
sheetPlanners & Trackers

Swim Club Attendance

Twelve training sessions for 24 swimmers, with frozen names and dates, letter codes from a dropdown and colour-coded attendance rates.

1 sheet; used range A1:Q30
sheetPlanners & Trackers

Website Relaunch Gantt

A seven-week project plan whose Gantt bars, progress fill and status-date column are all drawn by conditional formatting.

1 sheet; used range A1:AJ18
sheetPlanners & Trackers

Weekly Meal Planner

A seven-day meal grid with wrapped text, merged cells for batch-cooked meals and a costed shopping list.

1 sheet; used range A1:H18

Tables & Data 6

sheetTables & Data

Bug Triage Log

A triage sheet with dropdown lists for severity, status and owner, number and date rules, input messages and review notes.

2 sheets; used range A1:G20
sheetTables & Data

Café Chain Quarterly Roll-up

Three store sheets with coloured tabs feed a summary sheet through cross-sheet and 3-D references.

4 sheets; used range A1:F15
sheetTables & Data

Department Expense Subtotals

A month of expense claims sorted by department, with automatic subtotal rows, a grand total and an outline to collapse the detail.

1 sheet; used range A1:E20
sheetTables & Data

Filtered Sales Orders

A quarter's order list sorted by region and amount, with an AutoFilter that keeps only orders of $1,000 or more.

1 sheet; used range A1:H33
sheetTables & Data

Orders Pivot Summary

A PivotTable that turns a quarter's order list into sales by region and product, with grand totals.

2 sheets; used range A1:H9
sheetTables & Data

Warehouse Inventory Table

A stock list formatted as a structured table, with calculated columns, a total row and reorder alerts.

1 sheet; used range A1:H19