VBA excel
Budget: ₹600 – ₹1,500 INR
I am a Surveyor on a Motorway project. I am looking after the deformation Surveys of the project. Monitoring the amount of settlement we are getting on the 3 Bridges we are building.
Data is captured with a Total Station and exported as a *.csv File. (Point, Northing, Easting, Relative level, Code) I have a series of Master Excel Work books containing various disiplines of measurements
eg 1. Settlement plates, 2. Retainig Walls, Abutments, Houses to name a few.
Each *csv contains data that can include all at least 3 of the Types of measurement. I have to copy each point then match its code to the one in the Work book, I then paste this in under the previous weeks entry. Add the new weeks date. There dat output is in adjacent sheets in the work book the show the Delta in position in mm. This is then also show in another Data Table graphically in a general downward trend. There are a number of other little things that need to be done that can be discussed
Data is captured with a Total Station and exported as a *.csv File. (Point, Northing, Easting, Relative level, Code) I have a series of Master Excel Work books containing various disiplines of measurements
eg 1. Settlement plates, 2. Retainig Walls, Abutments, Houses to name a few.
Each *csv contains data that can include all at least 3 of the Types of measurement. I have to copy each point then match its code to the one in the Work book, I then paste this in under the previous weeks entry. Add the new weeks date. There dat output is in adjacent sheets in the work book the show the Delta in position in mm. This is then also show in another Data Table graphically in a general downward trend. There are a number of other little things that need to be done that can be discussed