Build a web app that tracks work and site status on a dash board. Ideally all status changes will be via emails from employees (plain text). This will trigger an automatic update to the status board and track work metrics. The dashboard must have a color-coded map showing manned work locations and unmanned "monitored locations" with current status. Employees close to un-manned sites will be dispatched if a problem occurs via this app through email. All locations, employees, and their information will be added from an excel file. There must be an easy way to add, change, and remove employees and locations. The ability to anticipate and track travel costs would be a plus. Tracking the time it took for an employee to accept a job and then return the site to operational is also desired.
Interactive Travel Status Dashboard