# Weekly trading workbook — saved cell values

The tables below are extracted from the recalculated baseline workbook. The complete workbook and the 150-order scenario are included in the download bundle.

## Inputs

| Row | A | B | C | D | E | F |
| --- | --- | --- | --- | --- | --- | --- |
| 1 | Week | Orders | Gross revenue (USD) | Refunds (USD) | Ad spend (USD) | Sessions |
| 2 | Prior | 100 | 2400 | 120 | 300 | 4000 |
| 3 | Current | 120 | 2880 | 144 | 360 | 4800 |
| 4 |  |  |  |  |  |  |
| 5 | Edit yellow cells B2:F3. Prior and Current are the two supplied example weeks. |  |  |  |  |  |
| 6 | Source: weekly.csv; fictional merchant data. |  |  |  |  |  |
| 7 | All money values are USD. Orders and sessions are nonnegative whole counts. |  |  |  |  |  |

## Summary

| Row | A | B | C | D | E |
| --- | --- | --- | --- | --- | --- |
| 1 | Weekly trading summary |  |  |  |  |
| 2 | Metric | Prior | Current | Change | WoW change |
| 3 | Orders | 100 | 120 | 20 | 20.00% |
| 4 | Gross revenue (USD) | 2400 | 2880 | 480 | 20.00% |
| 5 | Refunds (USD) | 120 | 144 | 24 | 20.00% |
| 6 | Ad spend (USD) | 300 | 360 | 60 | 20.00% |
| 7 | Sessions | 4000 | 4800 | 800 | 20.00% |
| 8 | Net revenue (USD) | 2280 | 2736 | 456 | 20.00% |
| 9 | Conversion rate | 2.50% | 2.50% | 0 | 0 |
| 10 | Average order value (USD) | 22.8 | 22.8 | 0 | 0 |
| 11 | Ad-spend ratio | 13.16% | 13.16% | 0 | 0 |
| 12 |  |  |  |  |  |
| 13 | Rate changes in column D are percentage-point differences; column E is relative growth. |  |  |  |  |
| 14 | N/A means the denominator is zero or a comparison is undefined. |  |  |  |  |

## Guide

| Row | A |
| --- | --- |
| 1 | Workbook guide |
| 2 | 1. Edit Inputs!B2:F3 (yellow). Rows 2 and 3 are the supplied Prior and Current examples. |
| 3 | 2. Open Summary to compare weeks. Excel automatic calculation updates formulas after edits. |
| 4 | 3. Net revenue = gross revenue minus refunds; no other costs or taxes are deducted. |
| 5 | 4. Conversion rate = orders / sessions. |
| 6 | 5. Average order value = net revenue / orders (net AOV). |
| 7 | 6. Ad-spend ratio = ad spend / net revenue. This is a spend share, not ROAS. |
| 8 | 7. Change = Current minus Prior; WoW change = Current / Prior minus 1. |
| 9 | 8. Zero denominators show N/A. A zero Prior value makes relative WoW undefined. |
| 10 | 9. USD is the supplied currency. No dates, order-level data or profit costs were supplied. |
| 11 | 10. The 150-order scenario changes only Inputs!B3; revenue, refunds, spend and sessions stay fixed. |
| 12 | 11. Scenario AOV falls because the same net revenue is divided across more orders. |
| 13 | Data note: supplied fictional merchant examples; scenario is a sensitivity calculation. |