{"uid":"cap_MwvscVN_Ct7cIyJ-pb4rX","slug":"proposal-preparation-numeric-interval-filter-secondary-measure-c95e3c7b","name":"Proposal Preparation — Numeric Interval Filter + Secondary-Measure Weighted Mean","description":"Proposal preparation — Numeric interval filter + Secondary-measure weighted mean: Numeric interval filter + Secondary-measure weighted mean for supplied proposal preparation records (completed_sections, planned_sections). Up to 200 rows; 2 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 2 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-writing-08-132?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","document_group","date","completed_sections","planned_sections"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"document_group":{"type":"string","default":"","maxLength":80},"planned_sections":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"completed_sections":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","document_group":"group-a","planned_sections":1,"completed_sections":10},{"date":"2026-10-02","row_id":"row-2","document_group":"group-b","planned_sections":2,"completed_sections":20},{"date":"2026-10-03","row_id":"row-3","document_group":"group-a","planned_sections":3,"completed_sections":15},{"date":"2026-10-04","row_id":"row-4","document_group":"group-b","planned_sections":4,"completed_sections":30}],"maxItems":200,"minItems":1},"field":{"enum":["completed_sections","planned_sections"],"type":"string","default":"completed_sections"},"maximum":{"type":"number","default":100,"maximum":1000000000000,"minimum":-1000000000000},"minimum":{"type":"number","default":0,"maximum":1000000000000,"minimum":-1000000000000}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_ERmhLSTxQzuqNMcSROABP","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Filters proposal preparation records by a numeric interval on a chosen field, then computes a secondary-measure weighted mean; returns two analytical reports for up to 200 rows.","exampleAgentPrompt":"I have 4 proposal records with completed_sections and planned_sections values — can you filter them to only rows where completed_sections is between 0 and 100, then compute the weighted mean of planned_sections? Here are the rows: row-1 group-a 2026-10-01 completed=10 planned=1, row-2 group-b 2026-10-02 completed=20 planned=2, row-3 group-a 2026-10-03 completed=15 planned=3, row-4 group-b 2026-10-04 completed=30 planned=4.","exampleUseCases":[{"title":"Proposal completion range analysis","prompt":"I have a batch of 50 proposal records with completed_sections and planned_sections. Can you filter to only the ones where completed_sections is between 5 and 80, then give me the weighted mean of planned_sections across those filtered rows?"},{"title":"Document group section progress audit","prompt":"Here are 120 proposal preparation rows across document groups alpha and beta — filter them to where planned_sections is between 10 and 200, and compute the weighted mean of completed_sections for me."},{"title":"Grant proposal readiness summary","prompt":"I need two analytical reports on my 30 grant proposal records: first filter them to proposals where completed_sections falls between 0 and 25, then compute the weighted mean of planned_sections on that filtered set."}],"resultDescription":"Two analytical reports derived from the supplied proposal preparation rows: (1) the subset of rows whose chosen field (completed_sections or planned_sections) falls within the specified numeric interval [minimum, maximum], and (2) the secondary-measure weighted mean computed over those filtered records. Results are generated locally without external lookups.","failureModes":["Empty rows array or missing required fields (row_id, date, completed_sections, planned_sections) returns validation error","More than 200 rows submitted exceeds maxItems limit","minimum greater than maximum produces empty filtered result set","All rows filtered out by interval results in undefined or null weighted mean","Invalid date format (not YYYY-MM-DD) causes schema validation failure","field enum value not one of completed_sections or planned_sections is rejected"],"whenToPreferThis":"Choose this endpoint when you need a two-step analytical pipeline on proposal preparation data: first narrowing records to a numeric range on a specific field, then computing a weighted mean on the secondary measure. Ideal for lightweight, local batch analytics on up to 200 rows without needing external data lookups, predictions, or live integrations. Cost-effective at $0.01 USDC for two reports.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T12:33:34.968Z","isFirstParty":false,"canonicalSlug":"proposal-preparation-numeric-interval-filter-secondary-measure-c95e3c7b"}