This site is now in read-only archive mode. Please move all discussion, and create a new account at the new Victron Community site.
I have a very simple solar system on my camper that I use VRM to monitor. When I download the spreadsheet of past activity, most of the columns I don't care about. Is there a way in VRM to design a custom spreadsheet that has only the columns I want? Or, if not, is there a way to make a spreadsheet macro that would hide the columns I don't want just by running the macro?
Thanks, Ralph
I just answered my own question! I took a VRM spreadsheet with “too many” columns and used standard spreadsheet commands to “hide” the columns I didn't want. The data is still there, but invisible until I unhide the columns. I then saved only the column headers as a “template”. For future spreadsheets, all I have to do is download them, copy the numbers in them, paste them to the template spreadsheet and then save it under a new name. Works perfectly and didn’t take very long. Yay!!! Probably obvious to spreadsheet gurus, but I had to think a bit. :)
