Add a macro to extract the highest 25% of the concentration values with the associated date. |
Copy that data to columns G and H. |
|
|
|
|
Sort the copied data in date order. |
Add a button to run the macro. |
|
Write a Visual Basic function to convert coordinates displayed as ddmmss.ss (DegreesMinutesSeconds.SecondFraction) |
to decimal degrees dd.dddddd |
|
|
Name the function COOR() |
|
|
|
|
|
|
|
|
|
|
|
|
Related
https://homeworkyard.com/wp-content/uploads/2022/01/LOGO.png
0
0
Simon
https://homeworkyard.com/wp-content/uploads/2022/01/LOGO.png
Simon2022-01-10 16:48:272022-01-10 16:48:27creating numerical equations to solve questions on excel