Additionally, we now have an Excel macro that can help translate your data from a horizontal format to the vertical bulk upload template format for the Chesapeake Data Explorer! We recognize all of the hard work that goes into translating data for upload to the Data Explorer and we hope this helps ease that burden. Please feel free to use it, edit it and tweak it to meet your programs needs! You can find the macro and a brief “how to” user guide on the Toolkits page of the CMC Website. Contact your CMC Service Provider with any other questions!
Special thanks to Jake Beley, a graduate student at Dickinson College for building the macro, and Andy Fitch at the Chesapeake Bay Program for making final edits to handle duplicates, depths and station conditions!