Problem.... Nested countifs?
I want to be able to count the number of clients who are marked as "X" in
column Q .... and who are marked as "Low" in column M.
I tried countif... but it counted the number of clients marked Low and added
it to the number of X's.
"Nick" <firstname.lastname@example.org> wrote in message
> I want to be able to count the number of clients who are marked as "X" in
> column Q .....Backup/Restore Project 2007
Have single servers complete backup taken with Backup option from Central
Installed new W2K3 server, installed Project server 2007 Trial, trying to do
complete restore and encounter errors.
What is correct way of restoring Project 2007 server to different computer ?
This way of restoring is correct.
But usually there are errors related to different level of Service Packs,
hotfixes applied to the servers.
> Have single servers complete backup taken with Backup option from Central
You cannot to my knowledge directly querry the XValues or Values from a chart
series. For example, this does NOT work:
Dim i As Integer
For i = LBound(.XValues) To UBound(.XValues)
However, if you set a variant to the XValues or Values, it returns an
variant array that you can querry. Prior to xl2007, the following code works:
Dim arr As Variant
Dim i As Integer
arr = .XValues
For...Reports.config has invalid schema, and could not be loaded
We are trying to do our production install of CRM 3.0 which has CRM running
on one server and the SQL and SRS services running on another server. The
install seems to be working just fine except for reports. Whenever someone
clicks on reports in the CRM interface they get the following error and do
not get a list of reports.
Reports.config has invalid schema, and could not be loaded
We have followed all the post install recommendations in the install guide
for using an existing SRS installation when we install CRM. When the same
users go directly to the SRS server they can see and run ...How do I import a Fasttrack Schedule Plus file into Project?
I have a project file produced in an older version of FastTrack Schedule 6.0
for the Mac which I need to import into Microsoft Project 2007.
So far my efforts have been futile, and extremely labor intensive.
Does anyone in the community have a solution based on experience?
So far the import wizard in Project has been no help.
contact the developers of fasttrack schedule, aecsoftware. they provide free technical support. they should be able to convert the file for you. here is their tech support number(US): 1.703.450.2318
email info: email@example.com
...Web Client marking messages read
Need help with Blackberry web client marking messages read
when it copies messages from Web mail. I just brought up
about 15 blackberry 7230s using T-Mobile as a carrier. We
are using Exchange 5.5 and have web mail setup. I am
getting the mail messages to go to blackberry devices, but
the messages are being marked as read in
Exchange/Outlook. Basically, when the users are sitting
at their desks their messages are being marked as read
even though they haven't read the messages. I saw some
kind of fix for Exchange 2000, does anyone know if there
is anything I can do other than...Read Receipts #4
How do I turn off read receipts? I would like to insure the sender does not
know if I read the email sent to me.
Thx in advance
You could either swich it off globally in your exchange settings or use
tools like aloaha to remove the delivery/read receitpt requests from
"rgm" <firstname.lastname@example.org> schrieb im Newsbeitrag
> How do I turn off read receipts? I would like to insure the sender does
> know if I read the email sent to me.
> Thx in advance
How do you switch i...Outlook 2003 HTML Reply Selection Spell Check Bug
I received an email in Outlook. The email was in HTML format. I
started a reply to the message. I then selected only part of the
reply text and hit F7 to check the spelling of the selection (selected
text only). A message box pops up stating "Finished checking the
selection. Do you want to check the rest of the item?" There were
obvious misspelled words that simply were not checked. If I say Yes
to "check the rest of the item" the misspelled words are found as
would be expected. If the reply is only one word (not likely
normally) and you select it and check spelling...Indent xml
Is there a simple way to indent xml with dotnet? SQL Server returns a long xml string that is hard
> Is there a simple way to indent xml with dotnet? SQL Server returns a long xml string that is hard
> to read.
XmlReader r = new XmlTextReader(new StringReader(myXML));
StringWriter sw = new StringWriter();
XmlTextWriter w = new XmlTextWriter(sw);
w.Formatting = Formatting.Indented;
Oleg Tkachenko [XML MVP]
On Tue, 11 May 2004 12:34:50 +0...BUG !!! Excel 2002 save as csv coma not works in windows xp
BUG !!! Excel 2002 save as csv coma not works in windows
Changing list separator still not working.
Thanks in advance.
It's difficult to help if you don't say what's not working...
What format do you expect, and what does XL produce? Give an example of
your data in your post.
In article <email@example.com>,
"Macaco" <firstname.lastname@example.org> wrote:
> BUG !!! Excel 2002 save as csv coma not works in windows
> Changing list separator still not working.
> please help!!...XML load problem
im using VBScript to open generated .XML files off the local file
system and do stuff with them. the problem i'm running into is:
sometimes the .XML is invalid and contains an ampersand that is not
<FOO>$.01 & Greater</FOO>
....which causes problems when i attempt to load via:
Dim xml : Set xml = CreateObject("Microsoft.XMLDOM")
xml.async = "false"
If xml.load(sXmlPath) Then
what can i do? is there a way get back an exac...PWA Project Workspaces Visibility
My question involves the rules for which projects appear in the Project
Workspaces section of the PWA for different categories of users.
My particular question involves users who have been declared as proposed or
committed resources for a project or proposal, but have no 'elevated' rights
(not a PM, not the project owner, etc.).
It appears to me that as long as the workspace belongs to a PROPOSAL, such a
user will not have that project workspace listed in this section. However,
once it is converted to a PROJECT, it will be listed. Is that correct? Can
that behavi...Unable to filter properly because of merged cells
Hi all, my name is Sebastiaan of Holland and i could sure use your help!!!
Thanks for taking some of your time to give me some advice, very
To summarize my problem: I want to export a huge database, and then start a
macro on it which will select the data according to country and put it on
different worksheets per country. However, the way the database is being
exported out of Siebel Analytic, it is impossible for me to filter the
countries as I THINK, the column in which the country is stated has been
For my work I want to create a model where I...Compile error: label not defined
I have two forms; I'm trying to requery a couple of fields on the
first form when I close out of the second form. I have the following
code on the OnClose event of the second form:
Private Sub Form_Close()
On Error GoTo Err_Handler
MsgBox Err.Number & " - " & Err.Description & " - Form_Close()"
This is giving me a "Compile error: Label n...Project Gallery
I asked this question on the Excel newsgroup a week ago, with no response:
In Excel 2004, a file I use on a daily basis doesn't show up under the
"Recent" tab in Project Gallery. I've tried narrowing down the choices to
Excel files only (default is All Office Documents) and played with the
"Today", "Yesterday", "This Week" options, all to no avail.
The file was originally an MS Works timesheet template that I converted to
Excel 97 on a PC back in 1998, and now use daily on a TiBook running OS X
It does show up in my recent file list un...Outloo reads aloud emails
I have Outlook 2002 installed. I usually send an email by using the key
combination Alt/S but occasionally, instead of the email being sent, a
voice starts reading aloud the email I have written.
Now I have tried all sorts of Alt key combinations to make it happen on
purpose but it won't so my question is, what is happening, why, and can
I use the speech recognition program in other MS products?
sounds like you are enabling narrator. look in accessories on the start
menu. If it's not that, then it could be speech - look in control panel for
the lauguage applet.
--...ValidationType.Auto and reading schema attribute
I would like my default ValidationType to be Auto.
Now let's say I have both a DTD and an XSD file for this XML file being
validated. While it's ValidationType.Auto, it will validate the DTD,
but will not even attempt to read/validate the namespace or even check
if schema file exists.
I suppose it's a resolver problem; anyone have any insight on how I can
have it check the schema File while Auto (without setting
Validation can not perform DTD and XSD validation at the same time. If you
have ValidationType set to Auto, and have a DTD decl...XML/XSL #2
I am performing an XSL transformation on IIS 5 with a dot net application
and I am getting the following error message:
This is an unexpected token. The expected token is 'WHITESPACE'. Line 2,
Error Dump: System.Xml.XmlException: This is an unexpected token. The
expected token is 'WHITESPACE'. Line 2, position 62. at
System.Xml.Schema.DtdParser.SkipWhitespace(Boolean fRequired) at
System.Xml.XmlTextReader....Reading contents CHttpFile file starting from the end of file.
I have a CHttpFile which contains records per day. The records in the file
are ordered date descending. I need to have my records with date ascending.
So, if I read the file starting with last record back up to first record I'll
get my data sorted correctly. There is a huge amount of data, that's why I
want to read the data in the correct order instead of reading it, placing in
memory and then sorting. I'm using CHttpFile.ReadString to read the contents
right now but it read from the top. Is there any way for me search through
the contents of the file of a '\n' ...Validating enumeration of a schema using XmlReader / XmlDocument . c#
I am validating a xmlDocument in .net using XmlReaderSettings ,
XmlReader and the .Validate method of XmlDocument. The validation is
working properly except for the fact I am receiving no errors when the
values do not match the enumeration defined in the Schema. Is there a
setting I can modify to force validation on the values defined in the
ex. If I pass in 5, I do not receive an error or warning.
<xsd:enumeration value="1" />
<xsd:enumeration value="2" />
<xsd:en...XML Desialization of array list
Here's a simple example (VB.NET):
What would the code look like to deserialize this example?
Public Class App1
Shared Sub Main()
Dim list As ArrayList = New ArrayList()
Dim out As StreamWriter = New StreamWriter("array.xml")
Dim ser As XmlSerializer = New XMLSerializer(list.GetType())
I have read several posts regarding nesting, but I haven't quite found
what has perplexed me for the last couple of hours.
I'm using a set of IF functions to check 12 different cells to see if
they match a particular cell. If it does, it returns a value of a
different cell, if false it returns zero. These are contained within a
Now, here is the perplexing part. They aren't "nested" per se, because
they are all on the same level. I can get it to work by checking up to
11 of the cells, but on the 12th, it breaks.
Here is the formula with only the 11 entries...XML file loaded and stored as cached dataset?
Have loaded balanced web servers that we do not allow to connect to our
database. Content is created and pushed to these sites. I want to add a web
service that may get multiple requests a second depending on peak access. I
have built an XML file from SQL DB and pushed this file to web server. I
want to load XML file at application startup and leave it cached if possible
(it will vary in size from 1-2MB) and treat it like an SQL table (rows &
columns) that I can filter on and send XML subset back to caller. Maybe I
should keep XML document loaded as XML Doc and pull my nodes/da...how do you insert an element into an xml document with namespace
<bac:BACnetDevice APDUTimeout='' ApplicationSoftwareVersion=''
FirmwareRevision='' InstanceNumber='3744' MaxAPDULengthAccepted=''
ModelName='' NumberOfAPDURetries='' ProtocolConformanceClass=''
ProtocolVersion='' SegmentationSupported='' VendorIdentifier='' VendorName=''
<bac:baseAnalogInput EventState='0' Insta...Extranet Configuration of project web access
I have installed Microsoft EPM with in two server installation.
and now I need to configure extranet environment .
but I am confused to understant host header , load balance url , alternate
I extended my web access site . but further what i need to do . then my site
will be an accessible from anywhere. I am bit confused.
although I study technet pages . but confused
kindly tell me step by step.
Kindly tell me the solution as soon as poosible.
Hello Sam. Hopefully this link will help explain some of those keywords and
how you go about configuring ...