If you only use Excel to occasionally tote up the family budget, you probably don't appreciate how slowly it can run when dealing with massively large spreadsheets. The official Excel Blog looks at a common scenario — making a series of calculations on a very large number of rows — and examines which kind of macro will produce the quickest results. Turns out the obvious approach (moving through the data using an offset) is a lot less efficient than writing some slightly smarter code. Hit the post for the full details.
Make Excel Work Better With Large Data Ranges
Trending Stories Right Now
The NBN is a painful political boil on the government's arse. After the promise of fast 100Mbps connections was squashed by the Abbott/Turnbull government, in favour of a program that said 25Mbps qualified as broadband, there have been all sorts of delays and issues with the service. A recent survey, albeit with a small sample size, quantified some of that pain, with many NBN customers saying they'd prefer to go back to their old ADSL connections. You know things are bad when ADSL looks like a better option. So, what can you do about it if you're on the NBN but it sucks?
Alas, my McDouble-loving friends, it appears McDonald's has sent the popular burger off into the sunset. From what we know, it won't be replaced with the McSingle, or the McTriple, leaving fans to make do with less-thrifty substitutes.