*Important*: Our office is located in Richmond Circle in Bangalore & you might have to come for a small initial meeting where we will finalize the scope in detail. We will also introduce you to our stakeholders who are currently providing us server to run the code to ensure compatibility with server
I have written a complex logic in Excel and I am able to process this only on small datasets on Excel (~30MB). I want someone who can program a R code for this logic where the data is processed in real time and generate reports.
I am describing the logic briefly here
*Input* Excel: 5 columns
1- Truck Id
4- GPS location in Text
5- Halt report in Text ( contains minutes of stoppage during the interval)
Action: Basis the GPS location data in text format, the system has to identify and segment the Truck locations into Parking areas, Plant Area, in Transit.
Output: The stoppage time of each segment should be displayed as chart ( waterfall chart- showing the contribution of each segment)
PS: please contact me for any clarifications