Programming in Excel VBA Compared To LibreOffice (OpenOffice) Calc

, 2 min read

Programming in Excel VBA is quite easy. Below are some simple basic concepts to access and change the spreadsheet data. Worksheets(i) references the i-th sheet, usually they are called Sheet1, Sheet2, Sheet3 Cells(i,j) references i-th row, j-th column, e.g., Cells(2,3) is C2 Cells(i,j).Value is…

Why Brian Koberlein Is In The Dark Matter Camp

, 1 min read

Brian Koberlein blogged in Ugly Theory, Beautiful Data why he is in the dark matter camp, and not in the MOND camp. He very nicely weights each of the arguments of each theory to conclude why there is compelling evidence for dark matter. He concludes with: Of course dark matter still has a serious…

Google Earth Used to Reunite Australian Boy With His Indian Mother

, 1 min read

Saroo Brierley used Google Earth to find his lost mother in India after more than 25 years of separation. When Saroo was 5 years old he wrongly took a train to Calcutta near from his home-town which was more than 1,500 km away. In Calcutta he was adopted by an Australian couple. It is amazing what…

Clearing Cookie Junk in Google Chrome Web Browser

, 1 min read

From time to time I check what I have collected as cookies in my browser and I spot web sites which I probably have never visited directly but somehow set cookies. Instead of deleting them individually I now use sqlite3 to do this. cd ~/.config/google-chrome/Default sqlite3 Cookies "delete…

What Makes a Good Programming Environment?

, 4 min read

I was recently asked about my opinion regarding agile software development. I think the core problem is not agile or extreme programming, or object-oriented or structured. I think this simply misses the point. Below are the key ingredients to succeed in software development when it comes to…

JavaScript grid editor: I want to be Excel

, 1 min read

Good summary of some current JavaScript grid solutions. See also JavaScript Open-Source Spreadsheets and Data Grids.

AMD Bulldozer CPU Architecture Overview

, 1 min read

Architecture per core: At the chip level, 8 cores per CPU: Registers per core: Unfortunately I didn't find opcode clock cycles on AMD's website. AMD's website seems to be almost unmaintained, i.e., lots of dead links. Below are some clock cycles gathered through experiment by Agner Fog. I took…

NASA Shutdown due to USA Government Shutdown

, 1 min read

The world largest economy shut down its most prestigious space center agency. Wikipedia provides some background information here: government shutdown. Regarding NASA it says: NASA will furlough 98% of its staff, leaving fewer than 600 out of more than 18,000 employees on the job. NASA will…

Patrick Pichette on Google Fiber

, 1 min read

Google CFO, Patrick Pichette, on the evolution of computing power storage capacity network bandwith He shows the following remarkable slide on the disparity of the latter to the former. It was this disparity which apparently led Google to enter the broadband market with its own…

Force rsync Not To Use Timestamps

, 1 min read

Most common usage of rsync is rsync -anv ./ user@remote:/dir/ But when the timestamps of the files on source and target vary wildly it is better to use: rsync -crntlv ./ user@remote:/dir/ The option -c stands for checksum. The option -n is used to not overwrite anything (dry run). Drop -n to…

Photographs from Space by Karen L. Nyberg

, 1 min read

Amazing photographs from astronaut and engineer Karen L. Nyberg on Twitter during ISS-Expeditionen 36/37: The astronauts and engineers in space have internet: NASA Extends the World Wide Web Out Into Space. BTW, Karen L. Nyberg also posted a photo of a dinosaur in space.

Electronic Mathematical Journals

, 1 min read

Below journals, loosely related to topics in Numerical Analysis, offer unencumbered full text: Electronic Transactions on Numerical Analysis Applied Mathematics E-Notes (no longer active) The Electronic Journal of Linear Algebra arXiv Unfortunately, Numerische Mathematik, BIT, SIAM Journal on…

Re-installing Grub when MS Windows Destroyed It

, 1 min read

I have now done it a couple of times, but always have to look it up. Here are the steps to re-install Grub from a live Ubuntu CD, when you have Windows and Linux on your hard disk. You must be root, or run these commands with sudo. Change /dev/sdaXY accordingly. mount /dev/sda2 /mnt mount…

Gil Kalai on Zhang's Breakthrough in Number Theory

, 2 min read

Below I copy some paragraphs from a recent article in Polymath 8 – a Success! | Combinatorics and more by Gil Kalai on Zhang’s breakthrough regarding prime numbers: Twin primes are two primes $p$ and $p+2$. The ancient twin prime conjecture asserts that there are infinitely many twin primes.…

My Blog Statistics by Country

, 1 min read

Except notably Russia and Africa this blog has been visited by quite a number of countries. I am surprised. Also see Statistics of this Blog: Top Views by Country.

dotScale 2013 MySQL Talk

, 1 min read

Very interesting talk on the scaling challenge at WordPress.com given by Barry Abrahamson, CTO of WordPress. Some key points: 500 million database tables 3 data centers in USA 400.000 shards moved per day storage on SSD ~10% of total infrastructure costs are related to backups ~500 GB / shard 50…

WordPress/Automattic: Monthly Unique Visits and Employees

, 1 min read

Below table is from work-with-us (data as of 22-Sep-2013): One of these things is not like the other. Company NameMonthly Uniques…

Georg Hager's Blog: Intel vs. GCC for the OpenMP vector triad: Barrier shootout!

, 1 min read

Georg Hager's Blog posted an illustrative article on icc versus g++ performance w.r.t. OpenMP. Dr. Georg Hager is one of the authors of Introduction to High Performance Computing for Scientists and Engineers. Measurement of double precision, dimension(N) :: a,b,c,d ! initialization etc. omitted s =…

Graphs with JpGraph by Asial

, 1 min read

JpGraph is a library of PHP code to draw a variety of graphs: line+bar+pie charts radar+polar+contour graphs bar+QR codes Gantt charts a couple of other chart types Here are two examples: JpGraph is a free product by Asial if used in a non-commercial context. Installation is quite easy on…

Line Integral of a Vector Field

, 1 min read

Inspired by a discussion with my son regarding movement of a point-charge between two other charges I revisited the definition of the line integral. Wikipedia offers an excellent visualization of the definition of the line integral for a vector field. See animated graphic below: This is something…



← Older       Newer →