{"uid":"cap_DvDMINQ1wwZfi1TkLMIvh","slug":"time-entries-secondary-measure-weighted-mean-calculator-ef4273b8","name":"Time Entries Secondary-Measure Weighted Mean Calculator","description":"Time entries - Secondary-measure weighted mean: Secondary-measure weighted mean for Time entries. Up to 200 supplied typed records. Local numeric and data-quality processing; no external enrichment or forecasting. One of 25 profiles or calculations across 20 shared operations in this sector. 0.01 USDC includes one bounded secondary-measure weighted mean deliverable.","url":"https://market.datapackvibe.com/x402/assistant-sector-analytics-time-entries-weighted-average?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","project","date","hours","billable_hours"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"hours":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"project":{"type":"string","default":"","maxLength":80},"billable_hours":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","hours":10,"row_id":"row-1","project":"group-a","billable_hours":1},{"date":"2026-10-02","hours":20,"row_id":"row-2","project":"group-b","billable_hours":2},{"date":"2026-10-03","hours":15,"row_id":"row-3","project":"group-a","billable_hours":3},{"date":"2026-10-04","hours":30,"row_id":"row-4","project":"group-b","billable_hours":4}],"maxItems":200,"minItems":1},"field":{"enum":["hours","billable_hours"],"type":"string","default":"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_kskuS7fwNg_chQ3vC7t7I","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 a secondary-measure weighted mean (e.g. billable_hours-weighted average of hours) across up to 200 time entry records, using local numeric processing.","exampleAgentPrompt":"I have 4 time entries — row-1 for group-a on 2026-10-01 with 10 hours and 1 billable hour, row-2 for group-b on 2026-10-02 with 20 hours and 2 billable hours, row-3 for group-a on 2026-10-03 with 15 hours and 3 billable hours, row-4 for group-b on 2026-10-04 with 30 hours and 4 billable hours — can you calculate the billable-hours-weighted mean of the hours field across all these entries?","exampleUseCases":[{"title":"Billable-weighted average hours by project","prompt":"I have a list of time entries across multiple projects — each has total hours logged and billable hours. Can you calculate the billable-hours-weighted average of the hours field across all entries so I know the effective rate weighted by billability?"},{"title":"Freelancer time log analysis","prompt":"Here are 12 time entries from my freelance work this month — each row has a date, project name, total hours, and billable hours. Compute the weighted mean of billable_hours using hours as the secondary weight measure."},{"title":"Sprint effort normalization","prompt":"I tracked work across two teams this sprint with 50 time entries — each has hours and billable_hours. Can you give me a secondary-measure weighted mean of the hours field, weighted by billable_hours, so I can normalize effort across the sprint?"}],"resultDescription":"Returns a single numeric weighted mean value representing the secondary-measure (billable_hours) weighted average of the chosen target field (hours or billable_hours) across all submitted time entry rows.","failureModes":["Empty rows array or missing required fields (row_id, project, date, hours, billable_hours) returns validation error","More than 200 rows submitted exceeds maxItems limit","Invalid date format (not YYYY-MM-DD) causes schema rejection","All secondary-measure weights are zero or null, making weighted mean undefined","Non-numeric values in hours or billable_hours fields cause processing failure"],"whenToPreferThis":"Choose this endpoint when you need a statistically correct secondary-measure weighted mean over time entry records (up to 200 rows) and want fast, local numeric computation without external enrichment. Prefer it over simple averaging when the relative weight of each entry (e.g. billable hours) should influence the mean of the target field.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T12:56:35.446Z","isFirstParty":false,"canonicalSlug":"time-entries-secondary-measure-weighted-mean-calculator-ef4273b8"}