Recently I was in a business meeting, the chap from the “other side” suggested that i should stop making posts in the wee small hours! Since I started my new job time has been a bit harder to come by than it was before so I end up thinking about Excel later in the night!!!! […]
NB: See comments for errors and corrections to this code!
Today I needed to get the Standard Deviation for a number of counts of scores. Like this:
I dont know of a way to do this in the worksheet, and a quick google didnt turn anyhting up eirther, so it was off to VBA, this is [...]
Every now and then this blog seems to go a bit nuts and refuses to allow me to load pictures, or even edit post normally. That's whats been happening over the last few days, I could not load images and when I made changes they where not saved! I rocked up to work this morning [...]
I've been morning a bit lately so I thought I would take the time to make a post about some thing good!
I have been using Google notes for about a month or so now and I find it really works well.
Basically it allows you to copy bits of web pages (and stores a link back [...]
hummm, insulting, fun, totally missing the point, a bit of all three?
VBA Person
Recently I've set up a Virtual PC, that is to say I've installed Microsoft Virtual PC 2007. I'm running it on Window Vista Home Premium, which is not actually a supported OS but it seems to work OK all the same:
I set up my “Virtual Machines” like this:
One base XP install with sp2
Then VS6 + [...]
This morning I woke up (always a good start to the day), and had one thing on my mind. Whats the second best spreadsheet?*
As far as I can see there are only really (really) 3 spreadsheets that could be considered .
Excel
OOo
Gnumeric
OOo is working a way on the VBA API, when that gets there [...]
Here at MIE, we strive to bring you cutting edge news and information :
spreadsheet wars
Worth a watch if you have a 1/2 hour with nothing better to do!
Hair cuts have come along way!
What's you gut answer right now; without reading the rest of this post?
In my (seemingly) never-ending quest along the path of Uncapacitated Facility Location problems, I found myself thinking if I would be better of write some core functions in C (unmanaged) and calling them in my VB.net project? I thought that it probably [...]
I've not really had a popper play around with this yet, despite begin in the beat program for quite a while. Now they have released the first full version. The good news is the non-commercial version is completely free! And to be fair the commercial version is only 50 quid!
Why not take a little look? [...]
There is nothing that can be done on Monday mornings that can't be done on Tuesday afternoons - save breakfast - so take a peak at these. And for god sake Mike C, you're spilling your coffee!
Possibly not work safe.
Funny name, but it gets a bit interesting at "Br#####k's formal parent language" - where [...]
You know the score, you've done a pivot table and there are a load of empty cells. You want to fill them up:
[NB: you have to copy the PT as values or the code will fail!]
I use this almost every day:
Sub fill_in()
Dim cell As Object
Application.ScreenUpdating = False
For Each cell In Selection
[...]
Simon (am I obsessed with him?) found this paper about the Excel 2007 bug. It’s not only an excellent investigation in to that bug but is generally very interesting to read, and highlights some of the complexities behind the workings of our favour Spreadsheet(thats Excel btw), well worth a read if you have a few [...]
This years Excel user conference is to be held in sunny Cambridge. New for this year is a Developer day, which looks like it could be good fun – although I’m not sure of the pricing for that day – Simon? Damon?
Simon, such that he is, is taking suggestions for topics, although what he [...]
Over at JMT there was a strange question asked. How do you get the cells that a drawn shape lies over? I'm was amazed to see that there were methods in the OM to get this, heres some example code
Sub MShapesLocation()
''Code by Ross McLean - Methods In Excel
''Tells you the top left and bottom right [...]
Saw this over at ZDnet:
A hasty move to Google Apps a ‘career-limiting move’
Perhaps the most interesting thing is that some consultancy managed to write a 55 page document on what is quite an obvious and well understood area, but I think the main points apply not only to Office (thick client) and Google Apps (web [...]
Well, I've been away for a while, and it's likely that's going to continue for a while - sorry about that! Heres a quick link mainly for Simon, of smurf on spread sheets
http://www.itjobswatch.co.uk/contracts/northamptonshire/csharp.do
who, might already know about this site, but I thought I'd post it here anyway!
Nice little article on using Reporting Services with SQL Server 2005 Express and Visual Studio 2005.
http://www.vsj.co.uk/articles/display.asp?id=608
VSJ, btw is worthwhile joining, they send you a propper printed out mag each month for free and it quite good too!
Clearly having more spare time on his hand than me (or maybe he’s just not as lazy and bad at writing!) Simon has written up an excellent review of the UK OUG in Reading:
Just like Simon I really enjoyed the event. All the speakers came across really well, and the presentations where excellent.
Personally I [...]
The other day a mate asked me to draw him some glass balls, I used Inkscape. Later, because I'm like that, I wondered if I could do it in Excel - this is the result - I don't think Paint Shop has much to worry about!