Reconstruct reference-aware SUBTOTAL/AGGREGATE results without counting filtered...
https://detect.halowerk.com/v1/F-TD2000-DOCUMENTS-07/excel-subtotal-aggregate-reference-provenance-visibility-error-ledgerOverview
Reconstruct reference-aware SUBTOTAL/AGGREGATE results without counting filtered, hidden or nested values incorrectly.
Protocol
x402 (POST)
Price
$0.0030
Payment Asset
USD Coin
Payment Network
eip155:8453
Category
uncategorized
Provider
detect
Source
bazaar
Indexed
2026-11-02 17:26:03
Health
Status
unknown
Latency (p50)
—
Uptime (30d)
—
Reliability Score
—
Last Checked
Never
Last Healthy
Never
Consecutive Failures
0
x402 Payment Validation
Payment Requirements
—
Asset Verified
—
Facilitator
—
Input Schema
{
"body": {
"artifact": {
"spreadsheetAggregate": {
"claim": {
"error": null,
"included_cell_indices": [
0,
1,
2,
5,
6
],
"numeric_cell_indices": [
0,
1,
2
],
"value": 6
},
"data": {
"cells": [
{
"filtered": false,
"hidden": false,
"nested": "none",
"type": "number",
"value": 1
},
{
"filtered": false,
"hidden": false,
"nested": "none",
"type": "number",
"value": 2
},
{
"filtered": false,
"hidden": true,
"nested": "none",
"type": "number",
"value": 2
},
{
"filtered": false,
"hidden": false,
"nested": "subtotal",
"type": "number",
"value": 8
},
{
"filtered": true,
"hidden": false,
"nested": "none",
"type": "number",
"value": 15
},
{
"filtered": false,
"hidden": false,
"nested": "none",
"type": "text",
"value": "label0"
},
{
"filtered": false,
"hidden": false,
"nested": "none",
"type": "blank",
"value": null
}
],
"function_num": 9,
"k": null,
"mode": "SUBTOTAL",
"options": 0
}
}
}
},
"bodyType": "json",
"method": "POST",
"type": "http"
}
Output Schema
{
"example": {
"billable": true,
"findings": [
{
"confidence": 1,
"evidence": [
{
"page_indices": [],
"page_url": null,
"pattern": "excel-subtotal-aggregate-reference-provenance-visibility-error-ledger_scoped_evidence",
"type": "artifact"
}
],
"limits": [
"Explicit bounded artifact; stated technical computation only. Numeric result fields rounded to 6dp. No external lookup, legal/tax opinion, signer trust or identity certification."
],
"module": "excel-subtotal-aggregate-reference-provenance-visibility-error-ledger",
"state": "observed",
"value": {
"claim_matches": false,
"computed": {
"error": null,
"included_cell_indices": [
0,
1,
2,
5,
6
],
"numeric_cell_indices": [
0,
1,
2
],
"value": 5
}
},
"warnings": []
}
],
"known_count": 1,
"scope": {
"contact_values_returned": false,
"network": false,
"supplied_artifact_only": true
},
"warnings": []
},
"type": "json"
}