Creating a utilization report - Formula needed
Greetings, I'm looking to create a "weekly report" of machine usage.
each machine has its own row, followed by its current hours. the hours are fed in automatically through API feed & overwrite daily. (if the machine reports hours in the date will update automatically also)
I think to create a basic utilization I need to reference a date range to pull the data into a column that represents a previous day. (such as "if Date -1 =Current hours"), followed by a string of 6 additional columns to "store" a weeks worth of data, then from there I can create a basic =sum formula to get my weekly utilization.
Any thoughts on what type of formula to grab the current hours for today-1, today-2, today-3, etc...
note* this is machine operation time (such as a operator using a machine 8 hours a day) but the number is always different - can be zero all the way to 24 hour operation per day
sample chart below for reference
Help Article Resources
Check out the Formula Handbook template!