{"uid":"cap_0DrzW0c54uNhU6Q1tqRfO","slug":"shot-schedules-adjacent-row-changes-secondary-measure-weighted-mean-7b708705","name":"Shot Schedules — Adjacent Row Changes + Secondary-Measure Weighted Mean","description":"Shot schedules — Adjacent row changes + Secondary-measure weighted mean: Adjacent row changes + Secondary-measure weighted mean for supplied shot schedules records (planned_hours, actual_hours). 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-creative-13-159?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","asset_group","date","planned_hours","actual_hours"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"asset_group":{"type":"string","default":"","maxLength":80},"actual_hours":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"planned_hours":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","asset_group":"group-a","actual_hours":1,"planned_hours":10},{"date":"2026-10-02","row_id":"row-2","asset_group":"group-b","actual_hours":2,"planned_hours":20},{"date":"2026-10-03","row_id":"row-3","asset_group":"group-a","actual_hours":3,"planned_hours":15},{"date":"2026-10-04","row_id":"row-4","asset_group":"group-b","actual_hours":4,"planned_hours":30}],"maxItems":200,"minItems":1},"field":{"enum":["planned_hours","actual_hours"],"type":"string","default":"planned_hours"}}},"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_7DTSgZHlH4aG-Q3449pUT","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":"Computes adjacent row changes and secondary-measure weighted mean for shot schedule records (planned_hours, actual_hours) — two analytical reports on up to 200 rows.","exampleAgentPrompt":"Can you analyze my shot schedule data and give me the adjacent row changes plus a secondary-measure weighted mean for planned_hours? Here are 4 rows: row-1 on 2026-10-01 for group-a with 10 planned and 1 actual, row-2 on 2026-10-02 for group-b with 20 planned and 2 actual, row-3 on 2026-10-03 for group-a with 15 planned and 3 actual, row-4 on 2026-10-04 for group-b with 30 planned and 4 actual.","exampleUseCases":[{"title":"Tracking shot schedule hour drifts","prompt":"I have daily shot schedule records for two asset groups over the past week — can you compute the adjacent row changes and weighted mean for actual_hours so I can see how far each day drifted from the previous one?"},{"title":"Production planning deviation analysis","prompt":"Run adjacent row change and secondary-measure weighted mean reports on my shot schedule for planned_hours — I've got 8 rows across groups A and B from October 2026 and I want to understand the sequential patterns."},{"title":"Post-production schedule audit","prompt":"We wrapped a shoot and I need to audit our shot schedule. Can you take these 12 rows of planned and actual hours by asset group and date, and give me both the row-to-row changes and a weighted mean for planned_hours?"}],"resultDescription":"Returns two analytical reports: (1) adjacent row changes showing the delta in the selected measure (planned_hours or actual_hours) between consecutive rows, and (2) a secondary-measure weighted mean that weights the primary field by the secondary measure across the supplied records. Both reports are computed locally with no external lookups.","failureModes":["Fewer than 1 row supplied — minimum of 1 row required","More than 200 rows supplied — exceeds maxItems limit","Missing required fields (row_id, date, asset_group, planned_hours, actual_hours) on any row","Invalid date format — must match YYYY-MM-DD pattern","field enum value not recognized — must be 'planned_hours' or 'actual_hours'","Null values in both numeric fields may reduce weighted mean accuracy"],"whenToPreferThis":"Choose this endpoint when you have shot schedule tabular data (with planned_hours and actual_hours fields) and need two specific statistical reports — adjacent row deltas and a weighted mean — without requiring live data lookup, prediction, or external integrations. It is cost-effective at $0.01 USDC for up to 200 rows and two reports simultaneously.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-22T00:49:21.651Z","isFirstParty":false,"canonicalSlug":"shot-schedules-adjacent-row-changes-secondary-measure-weighted-mean-7b708705"}