That is... Beautiful!

I love it when people creatively use software for things it wasn't meant for. Of course, there's a fine line between "creatively" and "stupidly". In a work situation, people stupidly using software for things it wasn't meant for is terribly annoying. I've seen shitloads of helpdesk cases where stupid users have attached screenshots in Word documents, for instance.

But I've also seen many wonderful things done in Excel, and done a few myself.

Once, I made a visual simulation of gravitic (gravitonic?) interaction between planets in Excel. I've also prototyped functionality for a Sudoku app in it.

However, the most impressive thing I've seen done in Excel was a port of the Arcade version of PacMan. All the rows and columns were minimized to the smallest possible size, and each cell acted as a pixel in the game. That was crazy.

Here is a true definition of stupid..... Microsoft know the world is full of stupid people, so they put allot of effort into making software user friendly then turn around and change everything in the new version so that even smart people have a hard time figuring out, STUPID!

Excel (and other Office applications related) use two separate sets of methods. One is on singular cells, and one is for groups or arrays. Arrays are easily identified with the Colon, so A1:A5 takes all elements between A1 and A5 as a single block.

If you're working with individual elements you could just do =A1/B1 or something like that, but with arrays you need to cycle over every element. That's what the helper functions are for, the sum/sumproduct.



Other maddness is involved when you start adding the $ to the array/cell names, allowing you to grow the formulas via copy/paste in bulk :P So =sumproduct(A$1$:A$5$,B$1$:B$5$)/sum(A$1$:A$5$) will work too, but has a different meaning if you copy/paste the formula :P

My mom also has a Windows phone from Nokia, I am having a very hard time figuring out how to do just about anything at all with that phone. Yet she always comes to me for help. Personally I have a Galaxy Note 2 that I am quite happy about.

Oh well if Microsoft had anything to do with how my phone is programmed, then of course i can understand why it is so completely basted. they would have earlier phones programmed really well and totally user friendly, then created mine/yours at that stage where it is time to change everything around nonsensically.

Microsoft's motto is, when you need something new and cannot improve the old sufficiently to justify it, then make it so confusing no one will be able to tell!