---
# System prepended metadata

title: Interpolated Tool Consumption Rates

---

# Interpolated Tool Consumption Rates

Challenge: We can't use requisition rate directly in our Tools datasets, as it does not correlate seriously to labor curves.

Revised approach: Use the total count & duration of tools onsite vs. labor curve to interpolate a tool consumption rate. 

## Approach to Interpolating Tool Consumption:
1. Label tool categories with 'likely' trades (with AdV)
2. Calc Equip-months (from req dataset) onsite and labor-months per discpline (from timecards).
3. Separately for each project,  rolling weekly (monthly) basis, calculate tool utilisation rate per tool category (sum of unitized tools onsite vs sum of applicable trades' hours onsite).
4. For top X categories, compare and  visualize rates across projects. 
5. Provide rates per category as a minimum and maximum historical value, along with an estimated CI.   

## Thoughts 
- if 