I'm trying to figure out a way to calculate the total hrs on a tire used on heavy equipment based on the equipment hours.
When a tire is put on a piece of equipment the user will put a record for "installed" and input the equipment hours then when the tire is removed the equipment hours will be inputted again. The tire can be installed and removed multiple times throughout its life.
I would like a way to calculate the hrs based on the oldest install date (first equipment hour input for that certain tire) and the latest install/removal date.
example .... The tire(tire_id) is installed on 1/1/17(date) with 1000 equipment hrs on the equipment, its removed again at 1500 hrs on 2/1/17, its then installed on another equipment on 4/1/17 with 4000 hrs on the new equipment then removed again on 5/1/17 with 4200 hrs on the equipment.
So the tire actually has 700 hrs on it between the two equipment's it was placed on and removed from.
I think I will have to figure out a way to calculate the difference in hrs based on (removal hrs - installed hrs) and put that amount in a table tied to the tire then do another entry for the second equipment(removal hrs-installed hrs). Then have a way to add up all these entries to figure out total hrs on tire.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
mdav20
Hello,
I'm trying to figure out a way to calculate the total hrs on a tire used on heavy equipment based on the equipment hours.
When a tire is put on a piece of equipment the user will put a record for "installed" and input the equipment hours then when the tire is removed the equipment hours will be inputted again. The tire can be installed and removed multiple times throughout its life.
I would like a way to calculate the hrs based on the oldest install date (first equipment hour input for that certain tire) and the latest install/removal date.
example .... The tire(tire_id) is installed on 1/1/17(date) with 1000 equipment hrs on the equipment, its removed again at 1500 hrs on 2/1/17, its then installed on another equipment on 4/1/17 with 4000 hrs on the new equipment then removed again on 5/1/17 with 4200 hrs on the equipment.
So the tire actually has 700 hrs on it between the two equipment's it was placed on and removed from.
I think I will have to figure out a way to calculate the difference in hrs based on (removal hrs - installed hrs) and put that amount in a table tied to the tire then do another entry for the second equipment(removal hrs-installed hrs). Then have a way to add up all these entries to figure out total hrs on tire.
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.