How do I create a bell curve? I have my z, p, std. dev., mean,etc
I am trying to take my std dev, mean, z, p, Confidence level, etc...plot and
shade areas using excel.
See the ShadedNormalDensityCurve workbook at
- Mike Middleton
Decision Analysis Add-ins for Excel
"Brian" <Brian@discussions.microsoft.com> wrote in message
>I am trying to take my std dev, mean, z, p, Confidence level, etc...plot
> shade areas using excel.
...Adding new rows
I have a spreadsheet with 100 rows in, I need to add a row after each
current row, is there a quick way to do this or have i got to insert
each new row individually?
Paul Sheppard's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24783
View this thread: http://www.excelforum.com/showthread.php?threadid=390760
I assume you want to add an empty new row in between the existing rows.
One way would be with an extra column
Save as "trial" first.......just in case thi...Publisher will not recognize new printer
I just replaced my Brother MFC model 7150 with a new Brother MFC model 210C.
The printer will function with all the features of Office 2003 except
Publisher. Every time I select print or print preview, I receive a message
that a printer has not been installed on the system. I asks that I install a
printer for Publisher use. My old Brother worked fine with the Publisher
program. What can I do to make Publisher recognize the new printer??
Did you completely remove all traces of your old printer?
How to clean up printer drivers
When y...I would like to design a logo for a new superstore
I just can't seem to get an inspiration to design a logo to use for this
superstore. Even coming up with a name seems to be a difficult task.
Inspiration here, over 7,000,000 hits
Mary Sauer MSFT MVP
"tinard" <email@example.com> wrote in message
>I just can't seem to get an inspiration to desig...Help creating a script in SQL or Calculated field in Crystal
How do I take this script and manipulate it to give me one long string with
static text as well as SQL data in specific positions within the string.
Positions / Data:
1-3 / 173 (Static text)
4-6 / spaces
7-10 / "X_UPR30300"."YEAR1", (has to show up as 2007. Showing up as 2,007)
11 / 4 (Static text)
12-22 / "UPR00100"."SOCSCNUM"
23-57 / "UPR00100"."LASTNAME"
58-92 / "UPR00100"."FRSTNAME"
93 / "UPR00100"."MIDLNAME"
94-120 / "UPR00102"."ADDRESS1"
121-148 / &q...Help Creating A Formula #2
I need to make a formula for alook up. The first spreadsheet i
inventory, the second one is pg 103 strapping. I want to enter the fee
and inches for pg 103 on the inventory and have it look up the feet an
inches on strapping chart and enter the appropriate gallons in column
Attachment filename: p & g 101 strapping.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=50210
Message posted from http://www.ExcelForum.com
...Moving my files to a new computer
So I've copied my old .pst file to my new computer, used Tools>options>mail
setup>data files to introduce outlook to it, and reset it to to default and
removed the old entry so there is just the one entry in the list. Both my
new and old outlooks are 2003.
So far so good and I can see my mail folders and contacts in the left hand
pane, *but* tools>address book is not showing any of my contact addresses,
nor will check names show them. Anyone know whay or can point me at an
article that tells me what to do?
Also, I have several email accounts is there an easy way of movi...Looking for Easiest Way to Create Report
We need to create a report from our accounting program which contains about
200 .db files. I have determined that the required information is contained
in only 3 of those files.
Out of those 3 files I need about 30 fields of data.
The end result is that those 30 fields of data have to be placed into an
existing excel spreadsheet in specific columns which has 97 total columns.
For example one db file contains data which has to be placed into column c
of the excel spreadsheet. another db file has data which has to be placed
into column z of that same spreadsheet and so on
Th...Creating a Browse for Folder
I have seen programs where there is an edit field for defining the location
of a file and then to the right of the field is a button with 3 periods on
it which when clicked brings up a browse for folder file box where the user
can choose a directory and file and then it is populated in the edit field.
Is there a custom control to use for this or do I have to develop this
Take a look at SHBrowseForFolder and CFileDialog. You probably want CFileDialog.
Ajay Kalra [MVP - VC++]
"William Gower" <firstname.lastname@example.org> wrote in message
news:Olf0wrmk...How to display mfc control in new look style?
Hi, anybody knows how to show mfc controls like button or other controls in
new look style?
Please see below link to know about what i mean by new look style is.
I want to make my controls in dialog shown as Picture 2, not as Picture 1
(look at the button). Are there lack of some defines or codes or something
else, because when I create new project again, the dialog will be displayed
as I want in Picture 2.
I use MFC 9 (vs2008).
Thank you for any help!
"Saitama" <Saitama@discussions.microsoft.com> wrote in message
ne...synchronizing new e-mail ( headers only option)
there is an option to synchronize mail full message or
header only or new message in outlook express.
I just want to synchronize Headers of new e-mail only
wheni check for new e-mail..( you know there is so much
spam now ad ays..i just do't want to open any new e-mail
in my e-mail inbox until i know it is not spam...)
please reply with a solution.
You can use an IMAP account in OE to accomplish this.
Please note, This newsgroup is for support of Outlook 97, 98, 2000 & 2002
from the Office
family for Windows PCs. For Outlook Express (OE) support try posting...CONCATENATE text to create a formula to be evaluated
I am wanting to concatenate a set of text to create a formula. I have done
The result is: =MAX('2009'!A3:A65536)
....but it treats this as a text string when I try to use INDIRECT
Cell O1 contains the year minus 1. In this case O1 = 2009. All of my
worksheets are named as a year e.g. 2007....2008....2009...2010. I am
entering this on sheet 2010.
Now the real question: How do I make another cell evaluate this string as an
actual formula and spit out the highest number for ...CRM 1.2
I am going to move the CRM SQL databases to a new server. We will also
be moving Great Plains off the CRM server and on to the new SQL server.
We are bouncing around the idea of naming the new SQL server to the
name that the current CRM server uses and renaming the current CRM
server. The thinking here is that we won't have to touch the Great
What kinds of issues can I expect in this scenario? I believe that CRM
"might" make us of the SID in which case I would need to use SysPrep to
create the new one?
I wouldn't think that this is that unusal of a proje...New version of RMS
I received a call from Microsoft yesterday wanting me to go ahead and extend
my support for RMS which still isn't due for a couple of months and that
makes me really angry that they are so fast to want my support extended.
It's a little hard for me to consider extending my support with Microsoft
when I have yet to receive an upgrade to RMS for yet another year and at this
point I have had this version installed so long I no longer have had a need
to make a support call for over a year. I have no idea if I will see a new
release even in the next year because apparently it is so...Sharing tasks, group task list
I have a team of account people who assign tasks to a production team.
I want to create a shared task list that I (and others) can assign tasks
to my team that also updates me when progress on the tasks has been made
(ex. marked complete). I know I can do this from my personal task list,
but is there a way to have a shared task list where items can be
assigned and will also be updated through exchange? Public folders
Using Outlook 2003 on exchange server.
Set up a shared Mailbox and make Tasks there, Assign them to team members.
In that Tasks folder, show t...NEW LAPTOPS & LCD's CAN HAVE A BAD REFLECTION PROBLEM
Since a couple years ago, there're 2 types of LCD coatings.
Many new consumer laptops come with "BriteView" (also known as "Glossy")
which makes them look STUNNING shiny - an eye candy as long as you see it in
a store. But when you use for professional purposes you'll find reflections
can offset the benefit of "BriteView's "looking cool"
The traditional coating until "BriteView" was forced upon us, was
"Antiglare" (also known as "Matte"), the good news they both co-exist.
Which oen you prefer is a matt...Creating Formula with Embedded Variable ID
I need to create a single formula for my workbook that references cells from various tabs (over 20) in another workbook.
I want to copy this formula into multiple tabs within my workbook.
My workbook and the external workbook have the same number of and identically named tabs.
I want to embed a variable into the formula that will take on the name of the tab that the formula is copied to.
I imagine the formula would look something like this:
='K:\Sales Reports\[Ohio Team, Mar-21-2004.xls]variable_identifying_the_tab_goes_here'!D1
I know I can use the following formula to derive th...Creating Purchase order worksheets in HQ through rules
I would like put some code in a web service in order to create a purchase
order work sheet.
Could I access to work sheets logic using qsrules to construct a worksheet?
I looking for a method like QSRULES.CreatePOWorkSheet
...Creating a e-mail contact list which has "undisclosed recipients"
Can anyone help me with a contact list for my e-mail which
does not disclose all recipients names.
I would like to send an e-mail regarding company
information to several people which answers questions, but
I don't want everyone to know who I am addressing it to.
You need enter the names under the Bcc option when you address the email. That way, each recipient will only see their own name, but the email will go to everyone.
Actually, the recipients won't see their own name in the To field. They
will only see what the sender puts there, if anything (some ISPs require
that you...Migrating E5.5 Mailboxes with ADC created disabled accounts to to E2K3
I am getting to the end of my migration but still have all the resource
mailboxes with ADC generated diabled accounts in AD to migrate. I'm not
sure how to proceed with this. Can I just enable the accounts in AD migrate
the mailbox and disable it again or do I have to create a whole new account
in AD delete the ADC generated account and re-attached the new account to
the mailbox in E5.5 then migrate it to E2K3?
You can use the accounts it created.
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"JoeAHM" <joseph.gonzalez@a...Creating navigation buttons on a worksheet
I'm trying to link togethor different pages on excel so i can navigate to
them from each page.
Also does anyone know how to create a drop down menu in excel?
Many Thanks in advance
Maybe by using a hyperlink:
using the =hyperlink() worksheet function:
David McRitchie posted this and it might help you:
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)
ryan_...Creating opportunity using CRM api
Looking for an example of how to load the crm api to create an
opportunity using C#. I'm way new to this and have downloaded the CRM
3.0 sdk but not sure how I access the information it contains. What
I'm hoping to find is an example of creating an opportunity with just
the necessary information so I can build on it from there.
I appreciate any help!
When you install the SDk you will notice there is a help file in the
installed directory of the SDK, I think it is crmsdk3_0.chm
Open the helpfile and search for create, there are lots of examples
let me know if you get s...New-systemmessage
I am trying to customize a few of the Exchange 2007 system message. I have
been able to change a system message so that if users send to an invalid
address at our domain, the messages replies that the address doesn't exist on
our company's mail server.
I am trying to customize the message so that if a user sends to a
non-existent domain. Currently they get this:
"A problem occurred during the delivery of this message. Microsoft Exchange
will not try to redeliver this message for you. Please try resending this
message later, or provide the following d...Template driver code for a new USB Touchscreen XP driver
We want to develop a new Touchscreen driver having a USB interface for
Windows XP. Which driver template will be the most suitable to start the
make your device a HID and then you not have to write a driver at all.
This posting is provided "AS IS" with no warranties, and confers no rights.
"sanju_emb" <email@example.com> wrote in message
> We want to develop a new Touchscreen driver having a USB interface for
> Windows XP. Which driver te...how do I take task off of startbar menu
Need to know how to take a task of the startbar menu. Something from the
internet got on my taskbar and it keeps my computer transmitting hour glass
on my screen.
this is not an excel question. post in the windows
run virus scan too.
>Need to know how to take a task of the startbar menu.
Something from the
>internet got on my taskbar and it keeps my computer
transmitting hour glass
>on my screen.
It might not be enough to remove it from the Start Menu--(unless it's under the
windows start|Programs|startup menu??).