MoonPoint Support Logo


Shop Amazon Warehouse Deals - Deep Discounts on Open-box and Used ProductsAmazon Warehouse Deals

Advanced Search
Sun Mon Tue Wed Thu Fri Sat
19 20 21 22 23 24
25 26 27 28 29 30 31
Apr May Jun
Jul Aug Sep
Oct Nov Dec

Thu, Mar 01, 2018 10:44 pm

Determining the the elapsed time between two timestamps in Excel

If you have an Excel workbook containing two cells that contain a date and time and you want to know the time difference between them in days and hours, you can subtract one from the other and get the elapsed time between the two timestamps in days and hours by using a custom date and time format for the cell that will hold the results. E.g., suppose I have a spreadsheet with the following timestamps in columns A and B:

  A B C
1 Start Time End Time Elapsed Time
2 1/1/18 0:01 3/1/18 15:03  
3 2/6/18 15:18 2/7/18 18:07  
4 3/1/18 7:55 3/1/18 13:01  

The cells containing the date and time have the custom format m/d/yy h:mm.

[ More Info ]

[/software/office/excel] permanent link

Tue, Feb 27, 2018 11:10 pm

Error message "You don't have permission to access / on this server."

I had been running an Apache webserver under OS X El Capitan on my MacBook Pro laptop. After an upgrade on the laptop, now running OS X El Capitan (10.11.6), when I tried accessing the site via http://localhost, I saw a page with the title "403 Forbidden" and the following text displayed on the page:


You don't have permission to access / on this server.

[ More Info ]

[/os/os-x/apache] permanent link

Mon, Feb 26, 2018 11:46 pm

Outlook reports a security problem with an encryption certificate

When I attempted to send a PKI-encrypted email message to several recipients from Microsoft Outlook for Mac 2016 (version 15.41), I saw the message "Encryption certificates for some recipients could not be found in the Outlook Contacts. Do you want to search the Active Directory servers for them?"

Encryption certificates for some recipients could not be found in the 
Outlook Contacts

I clicked on OK and then saw the message "The following recipients have encryption certificates with security problems. Do you still want to send this encrypted message?"

Outlook - encryption certificate with security problem

I clicked on Cancel and checked on whether Outlook was storing a public key certificate for the person in my contacts list. He was in the contact list, but there was no certificate associated with the person in the contacts list when I clicked on the Certificates tab.

[ More Info ]

[/network/email/clients/outlook] permanent link

Sat, Feb 24, 2018 10:51 pm

Installing gnuplot and using it for a simple graph

Gnuplot is a command-line interface (CLI) program that can be used to create two and three-dimensional plots on a variety of operating systems including Linux, OS X/macOS, Unix, and Microsoft Windows systems. If you use CentOS Linux, you can install it with the yum package management utility with yum install gnuplot. The information shown below is for the gnuplot 4.6.2 package on a CentOS system.

$ rpm -qi gnuplot
Name        : gnuplot
Version     : 4.6.2
Release     : 3.el7
Architecture: x86_64
Install Date: Fri 23 Feb 2018 09:30:00 PM EST
Group       : Applications/Engineering
Size        : 1551543
License     : gnuplot and MIT
Signature   : RSA/SHA256, Thu 03 Jul 2014 09:41:15 PM EDT, Key ID 24c6a8a7f4a80eb5
Source RPM  : gnuplot-4.6.2-3.el7.src.rpm
Build Date  : Tue 10 Jun 2014 12:07:58 AM EDT
Build Host  :
Relocations : (not relocatable)
Packager    : CentOS BuildSystem <>
Vendor      : CentOS
URL         :
Summary     : A program for plotting mathematical expressions and data
Description :
Gnuplot is a command-line driven, interactive function plotting
program especially suited for scientific data representation.  Gnuplot
can be used to plot functions and data points in both two and three
dimensions and in many different formats.

Install gnuplot if you need a graphics package for scientific data

Once you've installed the software on a Linux system, you can start the program by typing gnuplot and hitting Enter. You will get a gnuplot prompt where you can type commands, e.g., help for information on using the program. You can terminate the program by typing exit at the prompt.

[ More Info ]

[/software/graph/gnuplot] permanent link

Thu, Feb 22, 2018 11:01 pm

Installing GIMP on OS X

To install the GNU Image Manipulation Program (GIMP) on OS X systems, take the following steps:
  1. Download the GIMP installation file from GIMP - Downloads. The file is an Apple Disk Image .dmg file.
  2. Double-click on the downloaded file to start the installation process.
  3. When the GIMP installation window opens, you will see "" in the window that opens. Click on "" and drag it over into a Finder window with the Applications folder displayed to complete the installation of the GIMP application into that folder.

[ More Info ]

[/os/os-x] permanent link

Mon, Feb 19, 2018 11:24 pm

xlrd and hidden worksheets

I use the xlrd module in Python scripts to extract data from Excel workbooks. You can use the Python xlrd module to list the worksheets in a workbook and you can use the xlrd.sheet "visibility" value to determine whether a sheet is hidden and, if it is hidden, whether a user can unhide the sheet. The value should be either 0, 1, or 2 with the numbers having the following meaning:

Visibility of the sheet:

0 = visible
1 = hidden (can be unhidden by user -- Format -> Sheet -> Unhide)
2 = "very hidden" (can be unhidden only by VBA macro)

[ More Info ]

[/languages/python/excel] permanent link

Sun, Feb 18, 2018 10:10 pm

Displaying a tooltip

A tooltip, aka infotip or hint, is a small box of text that appears when a user hovers the mouse pointer over an item, such as a particular word or phrase, on a webpage. If you wish to display a tooltip when a user hovers the mouse pointer over text on a webpage, there are a number of ways you can do so. The simplest way to do so is to specify a title attribute, which is an HTML global attribute with the span tag. E.g.:

<span title="This is the tooltip text to be displayed when the mouse is hovered over the spanned text.">example text</span>

This is an example using the above technique with example text.

[ More Info ]

[/network/web/html] permanent link

Sat, Feb 17, 2018 1:43 pm

Windows 10 Blue Screen - Page Fault in Nonpaged Area

When we awoke this morning, my wife found a blue screen displayed on her PC running Windows 10 Professional with the message "Your PC ran into a problem and needs to restart. We'll restart for you." and "Stop Code: PAGE FAULT in NONPAGED AREA". She tried rebooting the system several times and powering the system off and on, but the message kept reappearing. I rebooted the system and hit the F8 key before Windows started - you may have to reboot several times to hit the key right before Windows starts to have it take effect. That took me to a Recovery window where I saw the message It looks like Windows didn't load correctly. If you'd like to restart and try again, choose "Restart my PC" below. Otherwise, choose "See advanced repair options" for troubleshooting tools and advanced options.

Recovery - Didn't load correctly

[ More Info ]

[/os/windows/win10] permanent link

Thu, Feb 15, 2018 10:22 pm

Enabling the Developer Tab in Excel for Mac 2016

To be able to view the Developer Tab in Microsoft Excel for Mac 2016, take the following steps:
  1. Click on Excel at the top, left-hand corner of the Excel window and the select Preferences.
  2. On the Excel Preferences window, click on View in the Authoring section.
  3. In the View window, click on the check box next to Developer tab, which you will see in the In Ribbon, Show section.
  4. You can close that window by clicking on the "x" in the red circle at the top, left-hand corner of the window. You should then see Developer as a selectable option to the right of Data, Review, and View on the menu bar at the top of the Excel window.
  5. If you click on the Developer tab, you should see options that include Visual Basic, Macros, Record Macro, Add-ins, Excel Add-ins, Button, Group Box, Combo Box, Label, Check Box, Scroll Bar, List Box, Option Button, and Spinner.

[ More Info ]

[/software/office/excel] permanent link

Wed, Feb 14, 2018 9:31 pm

Extracting embedded Microsoft Office files from an Excel spreadsheet

I work with Excel workbooks on my MacBook Pro laptop that have embedded PowerPoint slides on some worksheets. The workbooks, which I need to review, are created by others. When I review them, I extract information from the Excel workbooks to an SQLite database with Python and also have begun extracting information embedded by Object Linking and Embedding (OLE) into files as noted in Extracting the contents of a directory in a zipfile using Python. Some of the embedded files are PowerPoint files, but when they are extracted they have a .bin extension, which I can't open in PowerPoint without changing the filename extension from .bin to .ppt. To automate the renaming process, I created a Python script, that will extract the embedded information to files in an "embedded" directory beneath the current working directory and then rename any .bin files that are PowerPoint files to have a .ppt extension. The script is shown below.

[ More Info ]

[/languages/python/excel] permanent link

Once You Know, You Newegg AliExpress by

Shop Amazon Local - Subscribe to Deals in Your Neighborhood

Valid HTML 4.01 Transitional

Privacy Policy   Contact

Blosxom logo