Excel work - build surveying monitoring data display
Budget: $250 – $750 AUD
Excel spread sheet required to track the movement of a land slip.
The data is for a monitoring survey project.
The data is received about every month, each data set has a title with the date in the title.
The data is received as Point, Easting, Northing Height Code.
I have attached the data sets.
220314 Base was the first survey, the number is the date backwards , so it was completed on 14/03/22. This is the first survey and the remaining data will need to be compared to this, as well as compared to the last survey.
The raw data sets are attached. The point numbers are different every run, but the code can be used to compile the data.
Also attached are 2 attempts to track and visualise the data.
Attempt 1 and Attempt 2 where attempts to show the data, they are not well structured. They require a lot of manual handling and dont offer a good solution.
Attempt 2 has charts to show the movement but they would be better if they showed the amount of movement and not the actual coordinate.
The output needs to be easy to visualise the amount of movement of the site.
I would like the data better presented to show the movement of the monitoring points.
The data is for a monitoring survey project.
The data is received about every month, each data set has a title with the date in the title.
The data is received as Point, Easting, Northing Height Code.
I have attached the data sets.
220314 Base was the first survey, the number is the date backwards , so it was completed on 14/03/22. This is the first survey and the remaining data will need to be compared to this, as well as compared to the last survey.
The raw data sets are attached. The point numbers are different every run, but the code can be used to compile the data.
Also attached are 2 attempts to track and visualise the data.
Attempt 1 and Attempt 2 where attempts to show the data, they are not well structured. They require a lot of manual handling and dont offer a good solution.
Attempt 2 has charts to show the movement but they would be better if they showed the amount of movement and not the actual coordinate.
The output needs to be easy to visualise the amount of movement of the site.
I would like the data better presented to show the movement of the monitoring points.