Gantt Chart in Excel. Do I need conditional formatting?
I have created a Gantt chart that shows approx. 15 tasks in each project. I
am using this to show percentage of completion for each task.
It is working just fine and looks great but I need it to insert a date when
a task is at 100% completion to show the client the date that particular task
was completed. How would I do this without ruining my chart I already have
working fine? I know this is probably easy to do but I cannot seem to keep
the rest of the chart intact. Is conditional formatting the answer?
You could use Rob Bovey's XY Chart Labeler to do this:
h...timeclock report help
We use the timeclock report to print out total hours worked for any given
two-week pay period.
I am trying to modify the timeclock report by adding an additional column
that will tell me whether the date on the report was in week 1 of the pay
period, or week 2. I would like to return the string 'Week1' if the TimeIn
value for that row is less than or equal to the FilterLoLim value + 7, but
this does not work, i can't refer to this in my SQL formula.
here is a simple select statement to demonstrate what i'm trying to accomplish:
select cas...Calendar in Publishing
I am creating a calendar in Publisher 2003. I am manually inputting my
personal important dates, but would like to import general holidays - I
couldn't find a template that has them. Are there any?
"Snickerdodle" <Snickerdodle@discussions.microsoft.com> wrote in message
>I am creating a calendar in Publisher 2003. I am manually inputting my
> personal important dates, but would like to import general holidays - I
> couldn't find a template that has them. Are there any?
I don't know the ...Xpath Newbie Mistake, Please Help!
This code throws an exception when it should just print "C$" to the screen.
What is messed up in my xpath?
static void Main(string args)
XmlDocument xmlDocument = new XmlDocument();
GetExecutingAssembly().Location) + "\\test.xml" );
System.Xml.XmlNode xmlNode = xmlDocument.SelectSingleNode(
Console.WriteLine(...cannot open entourage
Operating System: Mac OS X 10.5 (Leopard)
Email Client: pop
The message I get is"Cannot open this database with this version of Entourage". I have already tried rebuilding the database, doesn't work. Is there anything else you could sugeest?
On 2010-06-03 07:27:04 -0400, MacIan@officeformac.com said:
> The message I get is"Cannot open this database with this version of
> Entourage". I have already tried rebuilding the database, doesn't work.
> Is there anything else you could sugeest?
Update Entourage...Help on displaying recession periods in a financial/ stock chart
Using excel version (10.6501.6626)sp3
How do you shade the chart background to show economic recession periods in a financial/ stock chart. I've fiddled with the drawing function-rectangle box, transparency, etc- but it isn't very satisfactory since it corrupts the column/ line colors and usually washes out when printed. So that doesn't appear to be the solution. And after checking thru Microsoft help and the discussion group messages I haven't found a message addressing my problem. Since we see charts all the time with the recession periods shown I know there is a way to acco...File in 2007 form
I was trying the Beta Office 2007 and made the mistake of saving one of
you Excel file in the new 2007 form. I really need it back in the 2003 form.
Problem: due to a variety of issues, I de-installed the Beta version and
went back to 2003 but for got about the one file..
So; are there any utilities that anyone knows of the will convert this
file back two 2003 form?? It is a simple Excel file, meaning that there
are no clever or fancy formula or macros, just a collection of parts and
part numbers gathered over MUCH time surfing various web sites.
Any help or advise (beside the obvious....Need help removing characters in multiple cells
I have an excel 2007 sheet that has over 300 cells in a column that have a
name of a store plus a number between paranethesis. Is there a one step way
I can remove the paranethesis? Here is an example:
and I want to have just the following
Each cell has a different store name and set of numbers within the
Select the range to fix.
what: _(* (spacebar, open paren, asterisk)
with: (leave blank)
It looked like you'd want to remove the space character after the t in k-mart.
"<----- Mardm...Help Understanding Microsoft Server Products
We are looking to upgrade servers (currently running WinServer 2003) - new
hardware and software.
The Essential Business Server Premium pack appears to be ideal in terms of
the software and package offered.
BUT it appears that there will not be a version of this supporting Exchange
2010 for some months.
This means we put a significant investment into 3 year old software, rather
than catching the up-to-date flavour.
So what's the difference between buying the EBS package and buying
individual software applications separately?
Also, is there additional software i...Mail Security
I am running Exchange 5.5 on Windows advanced server2K.
From my Exchange server, logged in as Administrator, you
can do the following:
start->settings->control panel->mail....then change the
mailbox user to anyone in the company......open MS
Outlook and read their email...
Is there a way I can prevent this from happening (even if
only for my own mailbox)
If Administrator has the role of Service Account Admin on the site object,
then this can happen. You wouldn't be the first person who used this
account as the service account. You could change the service ac...help with range lookup and date criteria
Hello, I have a list of doctors (column A) that are each on-cal
through a number of days. My argument is: if the date value of B1 an
C1 is within the current date, then repeat the value of A1
James Spalding's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2567
View this thread: http://www.excelforum.com/showthread.php?threadid=39088
hi, James !
> ... a list of doctors (column A) that are each on-call through a number of days.
> ... argument is: if the date value ...Help with complex query 05-09-07
I've got a query that I'm not sure how to develop.
Quotes - QuoteNo, RaisedBy, Customer
QuoteItems - RecordID, QuoteNo, PartNo, Lifecycle, Value
There's a one-to-many relationship between Quotes and QuoteItems, i.e. one
quote can have many items.
I need to run a query to show a list of quotes with totals from the
QuoteItems table i.e.
QuoteNo, RaisedBy, Customer, List of PartNos, List of Lifecycles, TotalValue
I haven't got a clue how to start this, I know it needs to be nested
queries, but the listing of parts and lifecycles is particularly stumpin...Email deletion over X amount of time for subfolders
I'm trying to configure the mailbox manager so it cleans out everyone's
mailbox once a week for emails that are over a year old. I had no problem
with cleaning out the Inbox, but none of the emails in the subfolders are
deleted. I selected 'All Other Mail Folders' option, but that didn't work.
Anyone know how to go about doing this or having this same problem?
...Help with Date/Time Function
I am working with date/time functions trying to figure out how many
hours were spent doing a job. I have a start time and a finish time.
But I need to subtract out any time between five pm and six am and
weekends from the times. These would be times that no one was actually
working on the job. For example I have
4/5/2005 18:23 4/6/2005 17:04
Could someone give me a clue as to how this might be done?
It's not a trivial thing, here's an example
R...I need installation software.
I write my software in Visual C++ version 6. It has been many years
since I used InstallShield and I don't think I have that software
anymore. Right now I need a fairly simple installation utility program.
Is there any good FREE (or low cost) installation software that I can
> I write my software in Visual C++ version 6. It has been many years
> since I used InstallShield and I don't think I have that software
> anymore. Right now I need a fairly simple installation utility program.
> Is there any good FREE (or low cost) installation soft...Problem with a Array formula, Please help !!
What is the problem with the array formula (see cells in column R, which
are highlighted coloured yellow) ?
>0,"Y...Money 2002 opens very slowly! Started few days ago!!! HELP
Hi to all,
I have problem with Money2002. It is full with data from
last year and until few days ago everything was ok. In
average it would took about 3-5sec for MsMoney to open
all the data, but since yesterday I need to wait app 10-
15sec for MsMoney to open. I tried everything but no
luck. Anybody have a clue what this could be.
Thanks in advance
Is 15 seconds really that long to wait? What other programs and data have
you installes/saved in the last year. Is your drives getting full?
In microsoft.public.money, John wrote:
>I have problem with Money2002. It is full with...the new excel help is horrible!!!! (way to go, limiting comments)
how do I get the previoulsy found HELP to list the typical formulas, or use
of special characters, like the & symble in excel.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=102753c7-0f12-402b-9da0-3...Import from Excel #2
Is there any way I can import from MS Excel to Money?
> Is there any way I can import from MS Excel to Money?
See also http://umpmfaq.info/faqdb.php?q=8.
"cndesu" <firstname.lastname@example.org> wrote in message
> Is there any way I can import from MS Excel to Money?
I have a pdf file consists of transactions which bank gave me online. Now
Can I import this file to money?
-- ...OnNewWindow2 message help.
I have the following code:
void CMFCIEEvtSpyDlg::OnNewWindow2(LPDISPATCH* ppDisp, BOOL* Cancel)
// create new instance of iespy
CMFCIEEvtSpyDlg* dlgPop = new CMFCIEEvtSpyDlg;
// create form
// register as browser
tmpDisp = dlgPop->m_webBrowser.GetApplication();
*ppDisp = tmpDisp;
// dump data to the window.
which is kinda edited from the MSDN example of c...help with CRM1.2 deployment
I installed MS CRM1.2 on a Windows 2003 server. The sample database
(Adventure Cycles Work) and license key provided used; CRM server
added to the Pre-Windows 2000 compatible access group; installed and
accessed as domain administrator.
When I access the web application at the server with localhost or
server name, it works just fine. However, when I try to access it
through client machines in the same domain, IE will simplely
crash/disappear after I input my user name and password.
Someone please help me...
Thanks in advance!
It is due to the fact that MBS CRM uses pop-up wi...Help with monitoring software
We have a several exchange 2003 servers running on windows 2003. I was asked
to find a monitoring software that will allow us to monitor exchange server
(services, uptime, connitivity, logs,database,...) and windows 2003 in very
comprehensive way for under $5K. Can any one recommend a good product? By the
way, we have MOM but it's handled by a different group so we need something
On Sat, 2 Dec 2006 07:02:00 -0800, desert-mania
>We have a several exchange 2003 servers running on windows 2003...Importing specific content into an Excel 2002 worksheet
I have some word documents that contain data I need throughout the
document. As it stand, Ctrl+C and Ctrl+V are the easiest ways because
the data is never in the same location on each document.
Is there a way of capturing this data, and adding it to a selected field
The Word documents have a lot of 'noise' before, and after the data
which is mostly contained in a table. This table also contains 'noise'
that is not needed for the end result.
Any suggestions are welcomed.
> I have some word documents that contain data I need throughout the
&...unable to sign you in to Windows Live ID .. Please HELP
I get the following error when I try to access my email from the Messanger
icon (Messanger knowes the number of unread emails). I have been
experiencing the problem for several months and have been searching for a
solution but have not been able to find one. I am able to login to my
Windows Live Email via the web. I have deleted my account and reinstalled it
and I have coppied all my email to a backup folder neither of these have
Unable to send or receive messages for the Live (Kellyr02) account. Sorry,
we were unable to sign you in to Windows Live ID at this time. ...import outlook canendar into publisher calendar
Is there a way to feed my scheduled dates from my Outlook calendar into a
Publisher calendar template?