RogerPenna
New Member
- Joined
- Mar 27, 2017
- Messages
- 20
Hello. I work on a small construction company and I am trying to sort out a kind of communication problem between the engineering/maintenance/logistics sectors of the company.
Basically, maintenance sector has to request engineers to stop trucks, motorgraders, diggers, etc, from working, and to send them to the Maintenance sector for Scheduled Lubrification/Maintenance every 250 worked hours.
We however do not have fixed machines and vehicles available to each engineer. So an engineer wants to produce and he will hold out the vehicle after he is warned, 50 hours before deadline. Then the machine is sent to another engineer, who will say “hey, nobody warned me, now I need this machine to produce, I have a construction deadline to meet!”
And so on. Ok, long and boring story short, I created a complicated Excel calendar that always shows the next 30 days of the month, and has in order the vehicles/machines nearing their scheduled Revision/Lubrification Plans and hours to meet the deadline based on the average worked hour by day.
My intention: to have a 50 inches TV on the engineering office, where engineers go at least once a day (when they are not on the field), showing this and in the future, other important info to the engineers. So they can better visualize the monthly scheduled for the vehicles, which ones are nearing deadlines, how long it will take for that, etc.
Problem is: how to do that? The spreadsheet is ready. How to send it to a TV and update it daily?
I initially thought of getting a cheap Chromecast and then send the image of a computer monitor to the TV through the Chromecast. But I guess that would require a dedicated computer. And how would it work and we need more spreadsheets or other info displayed on that TV?
Ideal situation seems to me would be to export images from a spreadsheet/sheets into a folder. And then run a sort of screensaver (using images from that folder) on the background of that computer, and the computer sending to the Chromecast ONLY the screensaver feed…
If anyone has any tip or idea or already worked with a similar solution, please help me here.
Basically, maintenance sector has to request engineers to stop trucks, motorgraders, diggers, etc, from working, and to send them to the Maintenance sector for Scheduled Lubrification/Maintenance every 250 worked hours.
We however do not have fixed machines and vehicles available to each engineer. So an engineer wants to produce and he will hold out the vehicle after he is warned, 50 hours before deadline. Then the machine is sent to another engineer, who will say “hey, nobody warned me, now I need this machine to produce, I have a construction deadline to meet!”
And so on. Ok, long and boring story short, I created a complicated Excel calendar that always shows the next 30 days of the month, and has in order the vehicles/machines nearing their scheduled Revision/Lubrification Plans and hours to meet the deadline based on the average worked hour by day.
My intention: to have a 50 inches TV on the engineering office, where engineers go at least once a day (when they are not on the field), showing this and in the future, other important info to the engineers. So they can better visualize the monthly scheduled for the vehicles, which ones are nearing deadlines, how long it will take for that, etc.
Problem is: how to do that? The spreadsheet is ready. How to send it to a TV and update it daily?
I initially thought of getting a cheap Chromecast and then send the image of a computer monitor to the TV through the Chromecast. But I guess that would require a dedicated computer. And how would it work and we need more spreadsheets or other info displayed on that TV?
Ideal situation seems to me would be to export images from a spreadsheet/sheets into a folder. And then run a sort of screensaver (using images from that folder) on the background of that computer, and the computer sending to the Chromecast ONLY the screensaver feed…
If anyone has any tip or idea or already worked with a similar solution, please help me here.
