|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
[ More Info ]
[ More Info ]
A just below the
header row to make it the current cell. Then click on Window
and select Freeze Panes. Now, when you scroll down through the
spreadsheet, the header row will "float" at the top of the Excel
window, so that it is always visible and you don't have to scroll back
to the top again to remind yourself what data is found in each column.
If you have other rows above the column heading row you selected, those
will remain visible as well as everything above the row you were on
when you selected Freeze Panes.
If you later want to turn the display of the header row or rows when you scroll through the spreadhseet, click on Window and select Unfreeze Panes.
Note: this works in Microsoft Excel 2000 and later on Microsoft Windows systems and Microsoft Excel 2008 for Mac and should work on other versions of Excel as well.
Sum 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 =SUM(J4:J63) 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 sumif function, e.g.,
assuming the date of sale for each item is in column F, I could use the
formula =SUMIF(F4:F63,">=2012-04-01",J4:J63) 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
the month.
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 SUMIF calculation
for all the values greater than or equal the starting date and then subtract
from that total the value calculated using another SUMIF formula
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
below:
=SUMIF(F4:F63,">=2012-02-01",J4:J63)-SUMIF(F4:F63,">2012-02-29",J4:J63)
The first 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 SUMIF will
be the total for all entries on or after February 1, 2012. The result of
the second 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.
A program that can be run on one of those operating systems is rdesktop. If you have a Linux system, you may find that it is already installed. If not you can download and install it for free.
You can determine if rdesktop is already installed by using the
command which rdesktop.
$ which rdesktop /usr/bin/rdesktop
Rdesktop allows you not only to remotely manage a Microsoft Windows system, but also map a directory on the system running rdesktop to what appears to be a shared network drive on the Microsoft Windows system.
$ rdesktop -0 -r 'disk:Linux=/home/jdoe/Documents/' -u administrator 192.168.0.5
I used the following options with the rdesktop command
issued on a Ubuntu Linux system:
-0
The -0 option allows you to attach to the console of the server (requires Windows Server 2003 or newer), which would be akin to sitting down at the system to which you are logging on, i.e., it doesn't establish a session separate from the login session you would get when sitting at the system. So, if you were already logged into the system locally, when you connect remotely via rdesktop, you will see all of the open programs and files.
-r disk:<sharename>=<path>,...
Redirects a path to the share \\tsclient\<sharename> on the server (requires Windows XP or newer). The share name is limited to 8 characters.
In this case I used -r 'disk:Linux=/home/jdoe/Documents/'.
I picked "Linux" for the sharename, but you can use whatever name you like.
The name you select is the name the Microsoft Windows system will see for
a shared network drive. The /home/jdoe/Documents/ means that
if, from the Microsoft Windows system, I use the Explorer or an application
to browse to the shared network drive named Linux it is really
pointing to /home/jdoe/Documents on the Linux system. So I
can place a file in /home/jdoe/Documents/ on the Linux
system and access it from the Microsoft Windows system. Or I can save
a file with an application on the Microsoft Windows system to the directory
/home/jdoe/Documents on the Linux system.
-u <username>
The -u option allows you to spcify the Username for authentication on the Microsoft Windows system to which you wish to logon. In this case, I'm logging in as the administrator.
The 192.168.0.5 is the IP address of the Microsoft Windows system
to which I wish to connect. You can also use a
fully qualified domain name
(FQDN) as well, e.g., a.example.com.
on a Windows 7 system, take the following steps:
If you want to use the default settings, click on the button labeled Use Default Settings. E.g., you might want to choose that option if some items have disappeared from the Start Menu. The default settings are listed below:
Computer (default: "Display as a link)
Connect To (default: checked)
Control Panel (default: "Display as a link")
Default Programs (default: checked)
Devices and Printers (default: checked)
Documents (default: "Display as a link)
Downloads (default: "Don't display this item")
Help (default: checked)
Highlight newly installed programs (default: checked)
Homegroup (default: unchecked)
Music (default: "Display as a link")
Network (default: unchecked)
Personal folder (default: "Display as a link")
Pictures (default: "Display as a link")
Recent Items (default: unchecked)
Recorded TV (default: "Don't display this item)
Run command (default: unchecked)
Search other files and libraries (default: "Search with public folders")
Search All Programs menu by name (default: checked)
System administrative tools (default: unchecked)
Use large icons (default: checked)
Videos (default: "Don't display this item)
Start menu size
Number of recent programs to display (default: 10)
Number of recent items to display in Jump Lists (default: 10)
C:\ProgramData. Navigate to
C:\ProgramData\Microsoft\Windows\Start Menu\Programs.
Within this directory you will see the folders and programs that appear
when you view the items within All Programs after you click on
the Windows Start button.
You can then move folders and shortcuts about or right-click and choose New to create a new folder.
Some entries you see under All Programs may be under
C:\Users\Username\AppData\Roaming\Microsoft\Windows\Start
Menu\Programs, where Username is the relevant user account,
instead. E.g., if you are logged into the account
Jane, some of entries may be under
C:\Users\Jane\AppData\Roaming\Microsoft\Windows\Start Menu\Programs
. These are entries that appear under All Programs just
for that account, whereas those under
C:\ProgramData\Microsoft\Windows\Start Menu\Programs apply
to all accounts on the system.
at
the lower, left-hand corner of your screen.
You can follow a similar process to reverse the changes to hide the files again after you've accessed the files you need to access to protect yourself from accidentally modifying any system files.
In the registry, I found the following key associated with the software:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Nucor
When I right-clicked on the subkeys and checked their permissions, I saw that user accounts had read permissions for them.
I used Microsoft's free
Process
Monitor utiltity to check the file access and registry access
of the NBS.NuBert.Bootstrapper.Loader.exe process when
it was run from the domain administrator account and from the user's
account. I noticed that when it was run from the administrator's account,
it was accessing the directory
C:\Users\Administrator\AppData\Local\Nucor_Building_Systems.
I copied that directory to
C:\Users\useracct\AppData\Local\Nucor_Building_Systems
where useracct was the user's account name.
For the administrator account the following files were in the directory:
DefaultPerisssions
NuBertTreelistLayout
PermissionMetadata
There was also a directory with a name that began with
NBS.BERT.HostEnvironment._Url_ followed by a very long
string of digits and letters. There was a directory named
2011.7.7.1 within it and a file named
user.config within that directory.
For the users account, the following files were the only ones initially
in the Nucor_Building_Systems directory:
DefaultPerisssions
PermissionMetadata
I copied the directory and all of the files from the
Nucor_Building_Systems folder under the administrators
account into the same one under the user's account, replacing the files
already there.
I logged off the administrator's account and tested again from the user's account. Again, I was prompted for the product key, however.
I then logged into the administrator's account again. I right-clicked
on the NuBert shortcut on the desktop, chose Properties
then clicked on the Advanced button under the Shortcut tab.
Run as administrator was grayed out, so I could not select it.
So, from the administrator account,
I created a new shortcut on the desktop that pointed to
"C:\Program Files (x86)\NBS\BERT\NBS.NuBert.Bootstrapper.Loader.exe"
. I right-clicked on the NuBert shortcut on the desktop,
chose Properties then clicked on the Advanced button under
the Shortcut tab. I then checked Run as administrator and
clicked on OK.
I then clicked on the Security tab, clicked
on the Edit button and added Domain Users, since the
user logs into a domain account. I then clicked on OK to close the
Properties window for the shortcut. I then copied the shortcut
from the domain administrator's desktop to the user's desktop at
C:\Users\useracct\Desktop, where useracct is
the username for the user's account.
Then when the user clicked on the shortcut, he would be prompted for a user name and password. I had him put in pcname\administrator, where pcname was the name of his computer, as the user name to use the local administrator account for his PC and the password for that account. I also created a .cmd file with just the following command in it and put a shortcut to it on his desktop as well:
runas /user:administrator "C:\Program Files (x86)\NBS\BERT\NBS.NuBert.Bootstrapper.Loader.exe
That would allow him to just put in the password for the local administrator account to save him a small amount of typing, if he preferred using it to the other shortcut.
Of course, running the software under the local administrator account is a poor solution, due to the security implications, but the only one I could get to work. Why do some software developers seemingly assume that their software will be run from an account with administrator privileges or that a system won't even employ the very minimum of security measures?
