Sun, Apr 22, 2012 4:01 pm
Sumif for Date Range
function allows you to sum the values
in a column. E.g., if I have a column, column J, that contains revenue in
dollars for items sold with the first entry in row 4 and the last entry in
row 62, I could use the formula
to calculate the
total revenue for all items (I use "63" instead of "62" presuming that new
entries will continue to be added by inserting new rows above row 63). But,
if you wanted to determine the revenue just for the current month, presuming
the month is April 2012, you could use the
assuming the date of sale for each item is in column F, I could use the
to calculate the
revenue for any items sold on or after April 1, 2012, presuming that I am
still in the month of April 2012. In this case any row that has a date
value of April 1, 2012 or later in column F will have the sales amount in
column J for that entry added to the total sales calculation for April.
I could also have used "01-Apr-12" for the date value in the formula, if
I wished, instead of "2012-04-01", i.e., I could use YYYY-MM-DD where YYYY
is the year, MM is the two digit value for the month and DD is the two digit
value for the day or DD-Mon-YY, where Mon is the 3 letter abbreviation for
Presuming that the only entries on the worksheet are for the year 2012,
I could find the total sales for January using the formula
=SUMIF(F4:F63,"<=31-Jan-12",J4:J63). But, if I want to
determine the sales for February, I need to add only entries where the
date is between February 1, 2012 and February 29, 2012. One simple way to
do so that will work even for older versions of Excel, such as
Microsoft® Excel 2000, is to perform one
for all the values greater than or equal the starting date and then subtract
from that total the value calculated using another
that adds all the values where the date is greater than the ending date. E.g.,
if I wanted to determine the total revenue for February, I could use the forumla
SUMIF adds the sales amount in column J whenever the
date value in column F is greater than or equal February 1, 2012. The next
SUMIF adds the sales amount in column J whenever the date
value stored in column F is greater than the last day in Feburary of 2012,
which is February 29, 2012. The result of the first
be the total for all entries on or after February 1, 2012. The result of
SUMIF will be the total for all entries after February
29, 2012. The difference between those two values will be the total for all
sales in the month of February 2012.
Thu, Apr 19, 2012 5:58 pm
Thu, Apr 12, 2012 10:39 pm
Mac OS X Hibernate Mode
Mac OS X
feature, which allows you to save the current state of the system to
memory or the hard drive. You might wish to use this feature if you
are going to be away from the system for awhile and don't want to close
all of the applications you have open or you can't power the system from
a wall electrical outlet and wish to conserve battery power.
OS X supports five different hibernate modes. The default mode is "3",
which means when you put the system to "sleep" it saves the current state
of the system to Random Access Memory (RAM), blanks the display, and goes
to a low power consumption state.
0 - Old style sleep mode, with RAM powered on while sleeping, safe sleep
disabled, and super-fast wake.
1 - Hibernation mode, with RAM contents written to disk, system
totally shut down while “sleeping,” and slower wake up, due to
reading the contents of RAM off the hard drive.
3 - The default mode on machines introduced since about fall 2005.
RAM is powered on while sleeping, but RAM contents are also written
to disk before sleeping. In the event of total power loss, the
system enters hibernation mode automatically.
5 - This is the same as mode 1, but it‘s for those using secure virtual
memory (in System Preferences –> Security).
7 - This is the same as mode 3, but it‘s for those using secure virtual
You can determine the current hibernate mode by opening a Terminal window
(use the Finder to go to Applications then Utilities
then double-click on Terminal) using
pmset -g | grep hibernatemode.
$ pmset -g | grep hibernatemode
You can change the hibernation mode by using
sudo pmset -a
hibernatemode n where n is one of the above integers
representing a supported hibernation mode. E.g., to write the current state
of the system, which includes the open applications and files in memory,
to the hard drive and completely shut down the system, you can set the
hibernatioon mode to
1. This is akin to hibernate mode on a
Microsoft Windows system.
$ sudo pmset -a hibernatemode 1
$ pmset -g | grep hibernatemode
To put the system in hibernation, you can click on the Apple icon in the
upper, left-hand corner of the screen and select Sleep. The system
will then be put in the selected hibernate mode.
Does Mac OS X support hibernation?
Thu, Apr 12, 2012 9:50 pm
Copying a Disc with Burn under Mac OS X
The Disk Utility
application that comes with Mac
, at least as of
OS X 10.6 ,aka
, does not permit
one to copy an audio CD. An alternative application that can be used to
create an .iso
file from an
audio CD is
which is free software licensed under the
GNU General Public License (GPL)
[ More Info ]
Wed, Apr 11, 2012 10:48 pm
Show the list of installed packages on a Ubuntu system
To display the list of installed packages on a
system from a shell prompt,
you can use
. You can also use the
Ubuntu Software Center
, if you prefer a
method of checking.
$ dpkg --get-selections | more
If you only want to determine whether a paricular package is installed,
you can use
grep to filter the results.
$ dpkg --get-selections | grep libboost
You can find the locations for the files installed when the package was
installed by using the
-L option with
$ dpkg -L libboost-filesystem1.46.1
To obtain information regarding a package, including its description,
you can use the
--status option followed
by the complete package name.
$ dpkg -s libboost-filesystem1.46.1
Status: install ok installed
Maintainer: Ubuntu Developers <email@example.com>
Depends: libboost-system1.46.1 (>= 1.46.1-1), libc6 (>= 2.4), libgcc1 (>= 1:4.1.1), libstdc++6 (>= 4.1.1)
Description: filesystem operations (portable paths, iteration over directories, etc) in C++
This package forms part of the Boost C++ Libraries collection.
The Boost Filesystem Library provides portable facilities to query and
manipulate paths, files, and directories. The goal is to
facilitate portable script-like operations from within C++ programs.
Original-Maintainer: Debian Boost Team <firstname.lastname@example.org>
Tue, Apr 10, 2012 8:00 am
Memory for Asus P4P800-E
I installed two additional memory modules in an ASUS
motherboard. The motherboard has 4 memory slots that
modules. The system had two 1 GB memory modules already installed.
I installed two additional 1 GB memory modules giving the system 4 GB
, which is the maximum
amount of memory the P4P800-E motherboard will support. I used
modules. After I installed the additional memory, I used the free
software to test all of the memory in the system. I let the
test run over night for six complete passes and part of a seventh pass with
no errors found.
Note: you can download the MemScope Memory Tester software
here. At the
moment there is a missing image on the page that has a link associated with
it for downloading the software. The link appears immediately below the
"Test 7 Random Data Sequence Test" paragraph or you can click
here to access the form you need to fill out to download the software.
Thu, Apr 05, 2012 7:57 pm
Recovering Lost Photos with DEFT Linux and PhotoRec
can be used for
forensics examination of a disk drive or to recover deleted or otherwise
lost files from a disk drive.
If you have lost files on a device, such as a memory card from a camera,
perhaps because you accidentally deleted them, you can use DEFT and
utility that comes with
DEFT 7 to search for and recover
those files. PhotoRec
6.13 comes with
DEFT 7. PhotoRec was created by Christophe Grenier. It is also
Mac OS X and Microsoft Windows
[ More Info ]