Excel then showed the differences between Sheet1 and Sheet2 in Sheet3 where I had used a formula to compare cells in the two other sheets. If the contents of a cell differed, Excel showed the differences. E.g. for cell A71, I saw Sheet1:I13-0003 vs Sheet2:I97-0033, since Sheet1 had I13-0003 in that cell whereas Sheet2 had I97-0033 . If the cells matched, the corresponding cell in Sheet3 was empty.

So, even though the Mac version of Excel doesn't include the workbook comparison feature found in Windows versions of the program described at How to compare two Excel files for differences, you still may be able to compare sheets in two Excel files by copying relevant sheets into a new sheet where you can see the differences displayed. In the exmple above, the contents of E71 in Sheet3 showed the values for the other sheets as numeric values, though there were dates in the corresponding cells in Sheet1 and Sheet2.

[ More Info ]

[/software/office/excel] permanent link

[ More Info ]

[/hardware/pc/memory] permanent link

For anyone who might receive such a call and think it could be legitimate, Publishers Clearing House states on their Fraud Protection page that "Our major winners are notified by mail or in person (at our option) and we never phone ahead to disclose that someone has won a major prize."

I filed a complaint at the Federal Communications Commission (FCC) Consumer Complaints website as I usually do when I get calls from such scammers intent on defrauding those they call. I also filed a complaint at the Federal Trade Commission (FTC) Complaint Assistant site at where you can select the "Rip-offs and Impostor Scams" option.

[/security/scams] permanent link

Security number is used for some fraudulent activities and due to that we have in order to suspend your social security number right away from the Law and enforcement Department and also to freeze your bank accounts before we go ahead and do that. If you need any further information about it kindly call back at 210-361-8678. Once again that's 210-361-8678. Thank you.

There were numerous other people reporting similar calls where someone was referencing a problem with the person's SSN and advising the person to call 210-361-8678. The call is obviously an attempt to defraud those called. I went to the FCC Consumer Complaint webpage and filed a complaint. I received an email response to the form I submitted with a ticket number. The email response from the FCC stated "The FCC is committed to doing what we can to protect you from these unwelcome interruptions to your day. Unwanted calls, including illegal and spoofed robocalls, are the largest category of complaints the FCC receives." It is troubling, though, that some fraudster has been engaged in this activity using the 210-361-8678 number for a year with no action taken against him. The first report I saw on the Whycall.me site was on July 16, 2018, but I saw others reporting the same issue on that webpage from that date through July 15, 2019. The Whycall.me site allows one to search for reports filed by other people on calls from telemarkers and scammers. The site describes itself thusly:

Whycall.me is a consumer complaints board used to report telemarketers, robocallers, scammers, and debt collectors that violate the law. We receive more than 6,000 complaints each month, which helps potential victims identify and avoid answering calls from problematic phone numbers. Our global phone book of numbers is powered by crowdsourcing and online data sources.

The site's homepage advises users of the site to also report the calls to relevant government agencies, which it lists. For the number that called me, the site listed the following information:

San Benito, Texas
Its exchange 361 is managed by SOUTHWESTERN BELL - TX
The number is currently on switch number SNBNTXSBDS0 (switch is a technical specification, provided here for phone hobbyists)
Around 20% of people reported it as "Recorded Message"
You are the 2nd person to search for it here.
There has been a total of 30 comments left about the number.
Latest people reported the number as that of "SCAM, "Social Security'"

I registed an account at the site and posted a note about the call I received today.

[/security/scams] permanent link

You can use the PyMuPDF module with Python to extract images from a PDF file. You can install PyMuPDF using the pip package manager with the command pip install PyMuPDF . You can determine if it is already installed with the command pip list | grep PyMuPDF or pip freeze | grep PyMuPDF.

# pip list | grep PyMuPDF
DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Ple
ase upgrade your Python as Python 2.7 won't be maintained after that date. A fut
ure version of pip will drop support for Python 2.7.
PyMuPDF                          1.14.13
# pip freeze | grep PyMuPDF
DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Ple
ase upgrade your Python as Python 2.7 won't be maintained after that date. A fut
ure version of pip will drop support for Python 2.7.
PyMuPDF==1.14.13
#

The code for the file is in extract-PDF-image.py.

[ More Info ]

[/languages/python] permanent link

When I attempted to copy an Outlook .ost file to an external USB flash drive, I saw the message below:

I didn't have Outlook open and didn't know what other process was using the file. One way to find out which process has a lock on a file is to use the Process Explorer utility provided by Microsoft. The program is free and you don't need administrator rights on a system to use it. To determine a process that is using the file, you can hit the Ctrl and F keys simultaneously, which will bring up a search box where you can type the name of the relevant file. When you click on the Search button, you should be able to see the name of the process that has a lock on the file as well as the process ID (PID) for that process. E.g., in this case I could see that lync.exe was using the file.

[ More Info ]

[/os/windows/processes] permanent link

I upgraded a MacBook Pro laptop that was running OS X El Capitan to macOS High Sierra (10.13.6) this week. The laptop was running Apache webserver software. After the upgrade, the system wasn't listening on port 80 for HTTP connections, but I was able to start it listening again with sudo apachectl start.

$ netstat -a | grep http | grep LISTEN
$ sudo apachectl start
Enter PIN for 'Certificate For PIV Authentication (JAMES CAMERON)': 
$ netstat -a | grep http | grep LISTEN
tcp46      0      0  *.http                 *.*                    LISTEN     
$

I was then able to access the default webpage at http://localhost which displayed the page contained in index.html.en file in the DocumentRoot directory at /Library/WebServer/Documents, but whenever I attempted to display pages I had created elsewhere, I kept getting a "404 Not Found" page indicating the requested URL was not found on the server. When I checked /private/etc/apache2/extra/httpd-vhosts.conf, I found it had a April 4, 2018 timestamp, but no longer had the virtual host information I had previously put in the file.

[ More Info ]

[/os/macOS] permanent link

If you need to rip a CD from a command-line interface (CLI) on a CentOS Linux system, cdparanoia will allow you to do so. The cdparanoia CD ripper program will allow you to produce Waveform Audio File Format, i.e., .WAV, files from the tracks on a CD. You can use the yum package management software to install the software with by issuing the command yum install cdparanoia from the root account.

[ More Info ]

[/os/unix/linux/centos/music] permanent link

Sometimes you may find that a software package that you would like to use on a CentOS Linux system is unavailable from the default software repositories, aka "repos." In such cases adding alternative repos, such as Extra Packages for Enterprise Linux (EPEL) or RPM Fusion may allow you to locate the desired package. E.g., the VLC media player is available in the RPM Fusion repository, but not the default ones nor in EPEL. RPM Fusion has two separate software repositories, one that contains free and open-source software (FOSS) and another named "nonfree". Packages in the "nonfree" repository still won't cost you anything, but there may be restrictions on the use of the software, e.g., you may be forbidden from using the software for commercial use. The RPM Fusion site defines the nonfree repo as being 'for redistributable software that is not Open Source Software (as defined by the Fedora Licensing Guidelines); this includes software with publicly available source-code that has "no commercial use"-like restrictions.'

[ More Info ]

[/os/unix/linux/centos] permanent link

I wanted to try the Pale Moon web browser, which is free and open-source software (FOSS) on a CentOS 7 Linux system, but when I tried installing it with yum, the package was not found.

# yum install palemoon
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
 * base: centos-distro.1gservers.com
 * epel: archive.linux.duke.edu
 * extras: centos.host-engine.com
 * updates: centos.den.host-engine.com
No package palemoon available.
Error: Nothing to do
#

I was able to resolve the problem, by adding the Pale Moon repository.

[ More Info ]

[/network/web/browser] permanent link