More on problems with HiRes screens

In one of my previous posts, I showed how to adjust the properties of the executable of a program under Windows 10 that has a fuzzy look: Right-click on the executable and choose “”the “ Compatibility” tab where you have to activate the “Disable display scaling on high DPI settings”. This trick works fine for non-windows programs. However, Outlook or Excel still look terrible.

If you go to http://windows10_dpi_blurry_fix.xpexplorer.com/ you can download a free, small utility, where you can set your overall DPI-Settings back those from Windows 8 (which doesn’t have this problem).

2017-02-01 13_50_48-XP Explorer - Windows 10 DPI Fix

Just click on “Use Windows 8.1 DPI scaling (our fix)” and you are set.

Following up on Outlook E-Mails in Org-Mode

The combination of Org-Mode and Remember-Mode helps me to organize my projects. One special task category is “WAIT”, if I have to wait for some input from somebody else or waiting for a delivery to arrive. An example is ordering a book at Amazon. As soon as I make the order, I generate a “WAIT” which would look like this

** WAIT [#C] [2014-09-16 Tu] Book on Modeling by Morgan

In this case, I ordered the book on September 9th and it has not a high priority. Once a week I check this category in a customized agenda view which sorts the WAITs according to their priority. If necessary, I take action (for example resending an E-Mail). 

One nuisance is that I use Outlook for my E-Mails and Org-Mode for my tasks.If I send an E-Mail and are waiting for an answer, or if I receive an E-Mail with information on my order, I can’t generate a direct link between the E-Mail and the WAIT-task and I loose time looking for the original E-Mail.

I googled around and found the following solution by John Hilliard here (there is org-outlook, but I did not find a good explanation, how that works). He suggests to write a macro in Outlook that looks like this

The macro gets the unique id for the email message and writes an Org Mode link to that message to the clip board.

Note that in order to write a macro, you have to activate the “Developer” tab in Outook, image

which can be done by right-clicking on the tabs and choosing “Customizing the Ribbon”. After defining the macro, you can add it to the quick access toolbar (same procedure as adding the developer tab), and choose a nice icon

image 

There might be an error, when running the macro, but you John nicely describes how to get rid of that one:

“When I first ran the macro, I actually got an error saying “Compile error: User-defined type not defined.” That was a little mysterious. In order to fix that error:

Click “Tools” then “References” in the menu.

Check “Microsoft Forms 2.0 Object Library” in the list of available references. 

  • This option wasn’t available to me at first so I clicked “Browse”
  • Then I opened “c:\windows\system32\FM20.DLL”

Then I clicked “OK”

I finally added the code for opening Outlook in my .emacs file.

(defcustom org-outlook-location (w32-short-file-name “c:/Program Files/Microsoft Office 15/root/office15/OUTLOOK.exe”)
  “* Microsoft Outlook 2013 location.”
  :type ‘string
  :group ‘org-outlook)

Now, I can select a message, click on the macro symbol which copies the link, jump to Emacs (I have a script for that) and insert the link. The WAIIT-Task would look like this: image

If I click on the Message-link, Outlook opens the message.

Matrix inversion in Excel

Even the newest version of Excel has a limit on taking the inverse of a matrix. The maximum size is 52×52 (don’t ask me why this limit exists). What you get if you use minverse(your matrix) for a big matrix is this:

image

Fortunately, there is a nice add-in programmed in C that does the trick. It was developed for Excel 2007 and earlier but it works fine in the newest version (2013).

You can download it from http://www.xcell.excelabo.net/english and it works like the inverse function in excel. Instead of minverse(….) you use minverse.ext(…).

PS. If you want to take the inverse of a matrix in excel, you mark the region, where the inverse should appear and then enter minverse(your matrix) and hit Ctrl-Shift-Enter (like for all array-operations in Excel).

image

and after hitting Ctrl-Shift-Enter you get this:

 image

Getting rid of some annoyances when opening or saving in Excel 2013 (and Word, Access)

The new Office version (2013) has lots of new features, but also some annoyances. Especially saving and opening files need much more clicks.

If you want to open a file, Excel opens with a start screen. Disabling this one is easy: just go to File-Options-General Tab and disable “Show the Start Screen…”.

If you want to save a file, this is what appears in Excel

image

Now you have to click on Browse to search the directory you want to save your files. It goes faster as follow, if you set the following options (see arrows) and set your favorite directory:

image

Afterwards, it will look likes this if you want to save (Ctrl+S is the short-cut for that):

image

Note, that if you use Ctrl-O for opening a file, you get the same results (instead of the “Backstage view”).