I have four Excel files that contain email addresses. I need to find out how many unique addresses are in the first three, but not in the fourth.
What's the easiest way to do that?
I am attempting to create a wind rose graph (i.e.- here or here). My data is wind speed and cardinal wind direction in separate columns:
Wind (mph) Wind Direction
3.66 SE
2.69 SE
2.62 SW
2.76 SW
2.11 NW
3.13 NW
3.55 SW
3.62 W
My final goal is to actually create the graph with a VBA macro,…
A bit of background before I dive into the gritty details: I have a single server running Windows 2003 Server where I host my ASP.net website and SQL Server + Reports. I've been creating ordinary windows user accounts to authenticate my users, and I enabled integrated windows authentication with impersonation. I've set up a bunch of user groups…
hi,
I'm browsing a server with my ftp client. When I try to get the information about a folder, I cannot see the permissions (all rwx checkboxes are uncecked).
If i try to check one of it, the opeartion is succesfull (I don't get any error), but then when I come back it is again unchecked.
What does it mean ? I don't have privilegies to read…
Hey all,
I am able to hit my company's VPN while I am at home using a dedicated IP with no issue.
When I am at work, the VPN we use (a Sonicwall router/VPN/wifi access point), I can get outside internet fine, but am unable to connect to the VPN.
I know that the wifi puts me on a different subnet, and when I try to connect to the normal VPN…
Is there any regulation preventing the use/sale of SIP trunks in mainland China?
I've set up and used commercial-grade SIP trunks in places where previously we would have used ISDN T1/E1 connections. Here in Shanghai I'm looking for a similar service, and while E1 30B+D services are readily available, every telecoms company we speak with…
hi,
I get the following error when I try to install Parallel Tools on my Ubuntu in Parallel Desktop.
I follow the istructions, running sh install from terminal: I follow the UI istructions and then the installation stops with this error message:
E: Couldn't find package dkms
Fri May 7 14:34:20 PDT 2010
Start installation or upgrade of…
Is it possible to auto-execute a command in a folder if you move to it via the cd command?
Of course I can define my own command (e.g. CHD.BAT) doing something like this:
@echo off
cd %1
if exist init.bat (
init.bat
) else (
color 0F
title Command Prompt
)
But I wonder if something like this would be possible using the…
I've setup a nginx server running php 5.3.6 and mysql 5.5.1.3.
My computer is an AMD quadcore 9650, 4gb ram, 500gb 7200rpm HD.
I ran the PHP MySQL Benchmark Tool v. 0.1, and got the following results:
Testing a(n) MYISAM table using 100000 rows.
Successfully created database speedtestdb
Sucessfully created table speedtesttable…
I've setup a few catalogs on an Windows Server 2003 IIS6 install, each tracking files within a website. In the Properties - Generation Dialog for each catalog, 'Index files with unknown extensions' is turned OFF. 'Inherit above settings from Service' in that dialog is also turned off.
However, the index is returning results for .cs…
I have a VPS running NGINX and virtual hosts, with a configuration such as this:
Domains directing to it:
lolpics.no
smscloud.no
idmag.no
Root folders:
/home/vds/www/lolpics
/home/vds/www/smscloud
/home/vds/www/idmag
SMSCloud.no is the site that keeps getting 502 errors, but if I make the domain direct to any of the other…
we just transferred a pilot group from our old(!!) Netware infrastructure to an Microsoft infrastructure. Since then, our users got problems accessing their files. They all experience disconnection from the mapped drives.
The file server is access via a WAN connection by a firewall (Sonicwall) between both network and we do…
I recently started using a Kinesis Advantage with my MacBook and one of the things I've really missed since switching from my Apple keyboard is having the functionality of the OS X media keys.
I know the Advantage keyboards are pretty customisable but having Googled for quite a while I haven't been able to find any sources…
I got a certificate from my network administrator and the passphrase for it. Put everything in the Tunnelblick configuration folder, but always get an error:
2010-11-20 13:22:10 Cannot load private key file vpn-pass.key: error:06065064:digital envelope routines:EVP_DecryptFinal:bad decrypt: error:0906A065:PEM…
I would like to create a read-only copy of my SQL Server 2008 database on a secondary server for reporting and analysis. I've been testing log shipping, configured to run every 5 minutes or so. Alas, there appears to be a stumbling block, for exclusive access is required on the target database during the…
I have a wordpress MU database with something like 10,000+ tables for various user's blogs. I need to upgrade wordpress MU to newest version, but want to backup the DB before hand.
PHPMyAdmin fails to even load the page when i click export. Ive tried going into the server (windows) and using dos command…
I'm copying large files (3 x 30G) between 2 filesystems on a Linux server (kernel 2.6.37, 16 cores, 32G RAM) and I'm getting poor performance. I suspect that the usage of the buffer cache is killing the I/O performance.
To try and narrow down the problem I used fio directly on the SAS disk to monitor…
1) Can I use time capsule as server ?
Can I run operating systems on it ?
2) I'm using time machine with my mac with time capsule.
Let's say my mac crashes, and I cannot use it anymore. Can i restore my mac disk on another laptop from time capsule ?
In other words, can I have a perfect copy of my…
I have two load balancers that balance incoming traffic across multiple data centers. These work fine. I can test them out by doing an 'nslookup mydomain.com xIP'
I have now taken out DNS services with DYN.com to allow me to manage the DNS Zone file so that typing mydomain.com will ask my load…
I'm trying to write an access control for OpenLDAP to allow a user to search with a certain base dn, but only get results back from certain sub dn's.
I've played with lots of different rules but cant get it to work. I'm not sure its even possible.
For example:
I have the user with the dn…
Let's say I have two public network addresses on my server: one NAT through an ISP (192.168.99.0/24), and a VPN through a different ISP (192.168.1.0/24), already configured with a per-host route to the VPN server through my ISP.
Here is my initial routing table. I am currently routing…
Windows Explorer in Windows 7 seems to jump around more than previous versions. The directory forlders seem to want to reposition the directory "just right" in the display. So opening a subfolder can cause a significant shift in the display. Aside from annoying, this has also caused a…
I just built a new computer and when I first powered it on I got a continuous beeping which according to the manual means a power failure. After moving the voltage switch to the left a little I was able to get the beeping to stop. Even after the stopping though the CPU fan doesn't…