ℹ️ 提问
问题：NSW / VIC 2026년도 신규 업체 리스트를 받고 싶어. 당사의 신규업체 기준은 전년도 인보이스 발행이 1건 이하이면서, 올해 인보이스 발행이 2건 이상인 업체를 뜻 해. 우리 Sales Database를 토대로 리스트업 해줘
提问者： Nathan时间：2026-08-19T01:55:10.180Z
回答
📝 更新（2026-08-19）— 替代之前"无数据依据"的回答
最初回答时，传给 turboairbrain.uk/ask 的上下文仅有"经销商销售额 Top 5 汇总表"，缺少完整经销商名单和逐年开票数原始数据，因此无法给出准确答案。此后负责人（David）确认了精确的统计方法（Inv No 存在即视为已开票，同一 Inv No 去重计为 1 次，年份以 Inv Date 为准，客户以 Company 字段为准），并据此直接解析 05_SalesReport/sales-data.js（服务账号每小时刷新的 Sales Data 表实时镜像，见下方"数据来源"）重新计算。
符合条件的 NSW/VIC 新客户：15 家（2025 年去重 Inv No ≤1 次 且 2026 年去重 Inv No ≥2 次，截至 2026-08-19 12:01 快照，基于全部 16,926 行中的 326 家 NSW/VIC 经销商重新计算）
| 排名 |
客户 (Company) |
地区 |
2025年开票数 |
2026年开票数 |
2026年销售额（白名单口径） |
| 1 |
Cucina Pty Ltd |
NSW |
0 |
4 |
$51,792 |
| 2 |
ELITE Catering Equipment |
VIC |
1 |
9 |
$50,486 |
| 3 |
Host Hospitality |
NSW |
1 |
2 |
$32,463 |
| 4 |
Kitchen Kapers |
NSW |
0 |
2 |
$24,113 |
| 5 |
Air Everywhere |
VIC |
0 |
4 |
$17,948 |
| 6 |
Blue Coral Concepts |
NSW/VIC |
0 |
4 |
$15,171 |
| 7 |
Solutions and Innovations |
NSW |
1 |
2 |
$12,409 |
| 8 |
Sluurp (HPMQ PTY LTD) |
NSW/VIC |
0 |
3 |
$11,585 |
| 9 |
K&S Food Services |
NSW/VIC |
0 |
2 |
$11,375 |
| 10 |
Built |
NSW/VIC |
0 |
2 |
$7,846 |
| 11 |
Inner Hospitality Design |
NSW/VIC |
0 |
2 |
$6,538 |
| 12 |
Norfolk Food Service |
VIC |
1 |
2 |
$5,753 |
| 13 |
MALLEE FOOD DISTRIBUTORS |
NSW/VIC |
1 |
2 |
$5,271 |
| 14 |
Core Serve |
NSW |
0 |
2 |
$5,012 |
| 15 |
Efendi Catering Equipment |
NSW |
0 |
2 |
$3,626 |
15家合计2026年销售额（白名单口径）：约 $261,388
ℹ️ "2026年销售额"列采用不同口径
开票数（2025/2026列）按问题中指示的方式统计（仅看Inv No是否存在+去重，不考虑Status），但销售额列另按"营业销售实绩查询流程"中的正式收入确认规则（Status ∈ Credit/Invoiced/Confirmed 白名单）单独计算——特意将"件数口径"与"金额口径"分开列示，以免混淆。
判定新客户所用的数据来源及新鲜度
- 来源：Google Sheets"Turbo Air"
Sales Data 标签页——直接读取服务账号（tab-wiki-sheets-reader@...）按表头名称映射、每小时（工作日9~18点）重新生成到 05_SalesReport/sales-data.js 的实时镜像（参见"Google Sheets 实时联动仪表盘构建指南（TAB Dashboard 案例）"§1——与 TAB Live Dashboard 使用的是同一数据管线）。
- 快照时间：
syncedAt: 2026-08-19 12:01（澳洲本地时间），rowCount: 16,926。
- 本次会话中尝试通过 Google Drive 连接器直接（xlsx）重新查询两次均超时（大文件导出失败），因此改用上述实时镜像文件——由于同一服务账号在问题提出后的1小时内刚刚刷新过，实质上具有相同的时效性。
统计方法（严格按指示执行）
- 仅取
State ∈ {NSW, VIC} 的行。
- 仅当
Inv No 和 Inv Date 均有值时，才视为"已开票"行（任一为空则视为未开票，排除）。
- 按
Company 取 Inv Date 所属年份，对同一 Inv No 去重，统计该年份的去重 Inv No 数量作为开票数。
- 筛选出 2025 年开票数 ≤1 且 2026 年开票数 ≥2 的客户。
❓ 待确认问题 — 同时跨 NSW/VIC 的 6 家客户如何处理
Blue Coral Concepts、Sluurp (HPMQ PTY LTD)、Built、K&S Food Services、MALLEE FOOD DISTRIBUTORS、Inner Hospitality Design 这6家客户的2026年开票同时发生在 NSW 和 VIC 两个地区。本表将"NSW/VIC"视为我方直营地区（参见"营业销售실적 조회 절차" §"地区"）将两地合并统计件数——若 Nathan 经理需要按地区完全分开的两份独立名单，这6家需要重新拆分。请确认所需口径。
⚠️ 偏差检查
Cucina Pty Ltd 2026年4笔开票中有1笔（E063095）的 Status 为 Restocked——按问题指示的规则（仅看Inv No是否存在）会被计入，但按"营业销售실적 조회 절차"的正式收入确认白名单（Credit/Invoiced/Confirmed）则不计为销售额。即使剔除这1笔，Cucina Pty Ltd 仍有3笔（≥2），不影响其入选资格——但需要意识到**"开票数"这个词在这里被用于两种不同定义**。这是15家客户中唯一发现的例外情况（其余14家全部由白名单状态的 Inv No 构成）。
- 数据缺口：326家 NSW/VIC 客户总数中是否恰好有15家满足条件，尚未与 David/Nathan 已知的特定新客户（例如最近拜访过的客户）进行人工核对——如需要，可提供具体公司名称进行逐一核对。
参考文档
- 营业销售实绩查询流程 — 定义收入确认规则（白名单）及数据查询方法，本次销售额列的计算依据
- Google Sheets 实时联动仪表盘构建指南（TAB Dashboard 案例）— 本次实际读取的
sales-data.js 实时镜像生成管线（§1）
- Sales Data 表结构说明及 KPI 定义
已识别的知识缺口
⚠️ 知识缺口
最初的回答是通过 turboairbrain.uk/ask 网站聊天自动生成的（因上下文不足而回答"无数据依据"），本次更新则是在 Claude Code 会话中直接解析 sales-data.js 原始数据重新计算的结果。在用于实际营业行动（如联系新客户）之前，请先review以上两个提示框（合并地区处理、Cucina Pty Ltd 状态例外）。
ℹ️ Query
Question: NSW / VIC 2026년도 신규 업체 리스트를 받고 싶어. 당사의 신규업체 기준은 전년도 인보이스 발행이 1건 이하이면서, 올해 인보이스 발행이 2건 이상인 업체를 뜻 해. 우리 Sales Database를 토대로 리스트업 해줘
Asked by: NathanDate: 2026-08-19T01:55:10.180Z
Answer
📝 Update (2026-08-19) — replaces the earlier "no basis" answer
At the time of the initial answer, the only context passed to turboairbrain.uk/ask was a "Top-5 revenue by dealer" summary table, with no full dealer list or year-by-year invoice-count source data, so an accurate answer wasn't possible. The operator (David) subsequently confirmed the exact counting method (Inv No present = invoice issued; the same Inv No is deduped to one invoice; year is taken from Inv Date; dealer = the Company field), and this answer was recalculated by parsing 05_SalesReport/sales-data.js directly (the hourly-refreshed live mirror of the Sales Data sheet via service account — see "Data Source" below).
NSW/VIC dealers meeting the new-dealer criteria: 15 (2025 distinct Inv No ≤ 1 AND 2026 distinct Inv No ≥ 2, as of the 2026-08-19 12:01 snapshot, recalculated across 326 NSW/VIC dealers out of 16,926 total rows)
| Rank |
Dealer (Company) |
Region |
2025 Invoices |
2026 Invoices |
2026 Revenue (whitelist basis) |
| 1 |
Cucina Pty Ltd |
NSW |
0 |
4 |
$51,792 |
| 2 |
ELITE Catering Equipment |
VIC |
1 |
9 |
$50,486 |
| 3 |
Host Hospitality |
NSW |
1 |
2 |
$32,463 |
| 4 |
Kitchen Kapers |
NSW |
0 |
2 |
$24,113 |
| 5 |
Air Everywhere |
VIC |
0 |
4 |
$17,948 |
| 6 |
Blue Coral Concepts |
NSW/VIC |
0 |
4 |
$15,171 |
| 7 |
Solutions and Innovations |
NSW |
1 |
2 |
$12,409 |
| 8 |
Sluurp (HPMQ PTY LTD) |
NSW/VIC |
0 |
3 |
$11,585 |
| 9 |
K&S Food Services |
NSW/VIC |
0 |
2 |
$11,375 |
| 10 |
Built |
NSW/VIC |
0 |
2 |
$7,846 |
| 11 |
Inner Hospitality Design |
NSW/VIC |
0 |
2 |
$6,538 |
| 12 |
Norfolk Food Service |
VIC |
1 |
2 |
$5,753 |
| 13 |
MALLEE FOOD DISTRIBUTORS |
NSW/VIC |
1 |
2 |
$5,271 |
| 14 |
Core Serve |
NSW |
0 |
2 |
$5,012 |
| 15 |
Efendi Catering Equipment |
NSW |
0 |
2 |
$3,626 |
Combined 2026 revenue for these 15 dealers (whitelist basis): approx. $261,388
ℹ️ A separate basis for the "2026 Revenue" column
Invoice counts (the 2025/2026 columns) were counted exactly as instructed in the question (Inv No presence + dedup, regardless of Status), but the revenue column was calculated separately, for reference, using the formal revenue-recognition rule from the "Sales Performance Lookup Procedure" (Status ∈ Credit/Invoiced/Confirmed whitelist) — this split is deliberate, to avoid confusing the two different definitions of "count" and "revenue."
Data source and freshness used to identify new dealers
- Source: The Google Sheets "Turbo Air"
Sales Data tab — read directly from the live mirror that a service account (tab-wiki-sheets-reader@...) regenerates hourly (weekdays 9am-6pm) into 05_SalesReport/sales-data.js by mapping the sheet's full contents by header name (see "Google Sheets-Backed Live Dashboard Build Guide (TAB Dashboard Case Study)" §1 — the same data pipeline the TAB Live Dashboard uses).
- Snapshot time:
syncedAt: 2026-08-19 12:01 (AU local), rowCount: 16,926.
- Two direct re-query attempts via the Google Drive connector (xlsx export) timed out this session (large-file export failure), so the live mirror file above was used instead — since the same service account had refreshed it within the last hour (right after the question came in), it's effectively equally current.
Aggregation method (exactly as instructed)
- Only rows where
State ∈ {NSW, VIC}.
- A row counts as "invoiced" only if both
Inv No and Inv Date have values (missing either one excludes it as not-yet-invoiced).
- For each
Company, take the year from Inv Date, dedup by Inv No (the same Inv No counts once), and tally the number of distinct Inv Nos for that year.
- Filter to companies where the 2025 count ≤ 1 AND the 2026 count ≥ 2.
❓ Open Question — how to treat the 6 dealers spanning both NSW and VIC
Blue Coral Concepts, Sluurp (HPMQ PTY LTD), Built, K&S Food Services, MALLEE FOOD DISTRIBUTORS, and Inner Hospitality Design all had 2026 invoices in both NSW and VIC. This table treats "NSW/VIC" as our own directly-operated region (see "Sales Performance Lookup Procedure" § "Region") and combines both regions into a single count — if Nathan wants two fully separate per-region lists, these 6 dealers would need to be split back out. Please confirm which is wanted.
⚠️ Bias Check
One of Cucina Pty Ltd's four 2026 invoices (E063095) has a Status of Restocked — under the rule specified in the question (Inv No presence only), it's included, but under the formal revenue-recognition whitelist (Credit/Invoiced/Confirmed) in the "Sales Performance Lookup Procedure," it would not count as revenue. Even excluding this one invoice, Cucina Pty Ltd still has 3 (≥2), so its inclusion in the list doesn't change — but it's worth being aware that the term "invoice count" is being used under two different definitions here. This is the only such exception found among the 15 dealers (the other 14 consist entirely of whitelist-status Inv Nos).
- Data gap: Whether exactly 15 of the 326 total NSW/VIC dealers meet the criteria hasn't yet been cross-checked against any specific new dealers David/Nathan may know of by name (e.g. from a recent meeting) — happy to check individual companies on request.
Referenced Pages
- Sales Performance Lookup Procedure — defines the revenue-recognition rule (whitelist) and the data-lookup method; the basis for this answer's revenue column
- Google Sheets-Backed Live Dashboard Build Guide (TAB Dashboard Case Study) — the pipeline that generates the
sales-data.js live mirror actually read here (§1)
- Sales Data Table Spec & KPI Definitions
Gaps Identified
⚠️ Knowledge Gap
The initial answer was auto-generated via the turboairbrain.uk/ask site chat (and returned "no basis" due to insufficient context), but this update was recalculated by parsing the sales-data.js source data directly in a Claude Code session. Review the two callouts above (combined-region handling, the Cucina Pty Ltd status exception) before using this for actual sales actions (e.g. contacting new dealers).