674 reputation
817
bio website plus.google.com/u/0/…
location London, United Kingdom
age
visits member for 2 years
seen Aug 26 at 23:52

I'm an applied mathematician & engineer, living & working just outside the London metro area.

Over the years and on both sides of the Atlantic, I've led a variety of quantitative & operational challenges across intelligent systems & software engineering, sonar, defense, environmental technology, robotics, and most recently the complex world of multi-channel retail.

The common thread that links passion, profession, and play is applying technology, good design, and quantitative modelling and simulation, to build better products, enable better decisions, and optimise performance.

I'm always experimenting and tinkering, so feel free to get in touch with ideas.

My Google+ profile, Google+ posts (active), and blog (older)


Mar
10
awarded  Notable Question
Feb
4
awarded  Necromancer
Dec
9
awarded  Popular Question
Nov
1
comment Fill in Excel template with data from SQL sever
Ah, missed the link! As a potentially useful summary: If the connection is successful, you'll see available tables > Choose a table. You'll then see an Import Data dialog box. Select how you want to view the data in your workbook... (table, pivot, etc.) > Properties... gives access to the Definition tab where you can write specific SQL the Command Text edit box. Clicking OK will pull back a table to the location you specified, including header row.
Nov
1
comment Fill in Excel template with data from SQL sever
Does this not address just one of the two parts? i.e. it describes how to make a connection but doesn't explain how to get the results of the query into a data range in Excel?
Aug
18
awarded  Yearling
Jul
29
awarded  Notable Question
Jul
26
awarded  Necromancer
Jul
26
awarded  Nice Answer
Jun
13
revised Is there an Excel function to create a hash value?
Added Trim to make it useful for fixed width fields
Jun
13
answered Is there an Excel function to create a hash value?
May
4
awarded  Popular Question
Apr
29
comment VLC 2 Frozen / stuck on first frame of AVI video
(+1) for good alternative resolution. Though this would likely not have applied to my situation (I had no audio since my video was created from a collection of images), it's a useful possibility to catalogue. Cheers!
Mar
24
awarded  Popular Question
Feb
13
comment VLC 2 Frozen / stuck on first frame of AVI video
@fayyazkl: Hm, UDP is not a format of its own, it is just a protocol for sending data between machines connected via a network. However, it defines maximum packet size, and (typically) does not check for dropped packets or packets out of order (TCP does). You might start by checking what underlying video format is being streaming, and then doing some google'ing to find out how VLC handles UDP streams. Good luck!
Jan
22
comment Possibility to translate all mouse clicks with shifted coords. (Or touchscreen issue with non native screen resolution.)
Great. Have a look at my answer below -- could it be as simple as that?
Jan
21
answered Possibility to translate all mouse clicks with shifted coords. (Or touchscreen issue with non native screen resolution.)
Jan
21
comment Possibility to translate all mouse clicks with shifted coords. (Or touchscreen issue with non native screen resolution.)
(+1) - that should help getting to the required 10...
Dec
17
comment What program to use to compare big files under Windows?
Did you know TC also splits files? File > Split File...
Dec
17
suggested suggested edit on Restore previous file selection in Total Commander