Skip to main content

Posts

Showing posts from April, 2015

Xenserver 6.2 to 6.5 upgrade notes

With 6.5 released we have started upgrading machines. Our initial upgrades were fairly straightforward and although the install of the Xentools was very slow and required numerous restarts it completed fairly well. We have had issues with 2012 server running Exchange 2013 - insofar that we've lost the network adapter and can't get it back. The solution seems to have been to clone the VM and then remove and add the adaptor back in. The restart took a very long time and there were issues with the Xentools install not working properly and difficulties with getting it to upgrade. We ended up removing it and reinstalling it however that wasn't really optimal and we blew our outage window but quite a margin. Before upgrading Xentools definitely take a snapshot of the VM if it's running Exchange. As we do more I will continue to update this site with more information.

Things to remember - Google Sheets - how to show the last number in a column

I have a Google Sheets file that I put all the water information for our farm into. It's fairly comprehensive with formulas etc to let me know the following once I measure the water level from the top of the tanks: volume of water remaining amount used since the last recording date average usage since last recording date amount of rain we can have until the main collection tank overflows (so I know when to pump it up to the feeder tanks) I would like a summary of the actual levels in each tank in a nice little chart that I can import into our personal intranet site hosted with Google Sites (this part is ridiculously easy), but I don't want to have to change the site information overtime I think about it.  I found this: =FILTER( A10:A100 , ROW(A10:A100) =MAX( FILTER( ArrayFormula(ROW(A10:A100)) , NOT(ISBLANK(A10:A100))))) Now if you put that into a cell, alter the ranges to suit, it will give you the last number in the column (and maybe row, but I haven't