Mining Spreadsheet Analysis With Jolene.pro: Tonnage, Haul Cycles and Fuel
A mine moves material through several reporting systems before the daily total reaches a spreadsheet. Dispatch records describe loads. The weighbridge records measurements. Equipment logs describe time, while fuel records describe another part of the operation. The analytical task is to compare those views without pretending they are interchangeable.
Jolene.pro can help examine Excel and CSV exports across multiple sheets and separate tables, produce charts and show the records behind an answer. For a mining analyst, useful questions include which loads explain a tonnage difference, where haul cycles lengthened and whether fuel intensity changed under comparable conditions.
Build an analysis around loads, assets and shifts
Bring dispatch and weighbridge records with load or ticket ID, asset ID, material, origin, destination, timestamps, gross weight, tare and net weight. For cycle analysis, include loading, departure, arrival, tipping and return events where captured. Add equipment-hour records, scheduled time, fuel quantities and the period each fuel figure covers.
Keep metric tonnes, short tons and volume measures distinct. Record whether reported material weights are wet or dry. Use the site’s shift calendar and timezone, especially when shifts cross midnight. State whether a daily report follows departure time, weighing time or destination receipt.
1. Reconcile dispatched and weighed tonnes
Ask: “Match dispatch and weighbridge records by load ID for these shifts. Separate matched loads, dispatch-only loads, weighbridge-only loads and repeated tickets. Compare recorded net tonnes for matched loads and show the source rows.”
Review unmatched records separately from weight differences. A load dispatched before midnight may be weighed after the reporting cutoff. A corrected ticket may supersede an earlier measurement. Confirm those rules before summing both versions. When source values are present, check net weight against gross minus tare and flag disagreements for review.
A mismatch identifies a record or measurement question. It does not establish material loss, theft or the accuracy of a particular instrument. Operations staff can use the matched ticket list to investigate the relevant loads.
2. Break the haul cycle into stages
Ask Jolene.pro to calculate recorded loading, travel, queue and tipping durations by route and equipment class. Request median and 90th-percentile cycle times, the observation count and a weekly trend. Define each interval using the actual timestamps available.
Separate incomplete cycles and invalid timestamp sequences. Do not substitute zero minutes for an event that was never captured. Compare similar haul distances, gradients and material conditions where those fields exist. A higher average can reflect a changed route mix; stage-level results help locate the part of the cycle that changed.
3. Compare payload and productive time
Ask: “For completed loads, compare payload distributions by equipment class and route. Show loads, tonnes moved and tonnes per recorded operating hour at the matching asset-and-shift level. Flag missing hour records.”
Summarize loads before joining them to an equipment-hours table so hours are not repeated for every ticket. Explain what counts as operating time. Compare results with approved equipment and operating limits through the site team; a spreadsheet ranking should never become an instruction to exceed them.
4. Examine fuel intensity on a matching basis
With suitable consumption data, ask for liters consumed per tonne moved and liters per operating hour by asset class and route. Use the same reporting period and request the total liters, tonnes and hours behind every ratio. Keep groups without valid denominators separate.
Fuel issued or purchased is not necessarily fuel consumed during that shift. If the workbook contains refueling transactions only, describe the result as issued-fuel intensity unless tank balances support consumption. Consider idle time, route changes and material conditions before attributing differences to equipment performance.
Take a small set of findings back to operations
Inspect the source trail, then save analyses for the next shift or weekly export. A dashboard can bring together matched tonnage, cycle-time trends and comparable fuel ratios. Start with one route and equipment class. The useful outcome is a precise operational question supported by loads, timestamps and measurements.
Industry context: Caterpillar discusses payload measurement and load-haul efficiency. These workflows analyze exported records; they do not replace mine-control or equipment-monitoring systems.