Can XIRR start with a "0" in the first period
I am having issues calculating XIRR. When my first cash flow is 0, I
get an error message, even though a regular IRR calc allows a 0 in the
first period. Is this just the way XIRR works or is there a way I can
get around it? Thanks for you help.
> I am having issues calculating XIRR. When my first cash flow is 0, I
> get an error message, even though a regular IRR calc allows a 0 in the
> first period. Is this just the way XIRR works or is there a way I can
> get around it?
This appears to be a defect in the XIRR algorithm. As you noted, IRR
wo...SBS 2003 to SBS 2008 migration headache!
Hoping someone can help me :(
After spending yesterday prepping the source server- running both SBS 2003
Best Practices Analyzer and Exchange Best Practices Analyzer (and resolving
all issues until they both came back clean), full backup, Migration Prep
Tool, answer file etc I was finally ready to get going with the destination
server today. I was very thorough with the documentation, taking it all step
All looked well, until it seemed to hang on what looked to be a final step.
I don't recall getting the replication delay pop-up that I've seen m...IMPORT PROBLEM #3
I try to import a file from excel. It imports 9 records and stops. The
message is "Map1 Error ox80070057. Try again later"
I try again later and get the same results.
"dancer" <firstname.lastname@example.org> wrote in message
>I try to import a file from excel. It imports 9 records and stops. The
>message is "Map1 Error ox80070057. Try again later"
> I try again later and get the same results.
What is in the file you are trying to import?
It is a name and e-mail address. I'...OWA setup on SBS 2003
I can't access OWA on an SBS 2003 server, for any user.
Not sure what is stopping it - is it ISA settings?
I've checked in Active Directory Users and Domains under the user and they
are permitted to use OWA.
Also tried to connect using Sever Activesync and a smart phone, but that
Hope you can help.
Could be ISA server stopping OWA from functioning, could also be a lot of
other things (like permisions on folders, web site etc).
What happens when you try to access OWA?
"Neil G Jarman" <neil@tNOiSPAMvPLEASEy.co.uk> wrote in mes...Plotting 3 dimensional co-ordinates
I have a series of data in x, y, z co-ordinates and want
to know if it is possible to plot these in excel, as I can
only seem to find thet it plots in the x and y axis.
The best that XL offers is a 3D surface plot in which the x and y axis
are 'category' axis and only the z axis is a numeric one. If your x
and y values are equi-distant, check the Excel/Charts/3D Surface page
of my web site for more on the subject.
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <d97001c4...upgrade #3
I just received an e-mail from my bank which states they will no longer be
supporting MS Money 2000 or 2001. I currently have Money 2000. I am looking
to upgrade, however do NOT wish to lose any of my financial data or the ease
of epaying my bills.
When I upgrade, do I delete the old MS Money and leave the *.mny file ? Or
do I complete an install and let Money 05 remove the old MS Money ?
thanks for your help,
Already replied to.
"dejaking" <email@example.com> wrote in message
news:BB6DD057-70DF-404A-AD65-CE0E914B366D@microsoft.com.....Tool available to install Exchange SP2 on SBS 2008
Works great. Note you need to download and extract Exchange SP2 before
running the tool.
MS-MVP - Windows Desktop Experience: Systems Administration
I hope I'm not the only one who read your post?
I'll just post now even though I read this the day you posted.
Thanks for the much needed info, Kerry
Russell Grover - SBITS.Biz [SBS-MVP]
Microsoft Gold Certified Partner
Microsoft Certifi...new version for 2008-2009
I have Money 2006 and am perfectly happy with it but the stock updates
will stop in September of 2008. I guess I have to upgrade. will there be
a new version this summer?
Only time will tell. I'm wondering if Money Plus wasn't called Money 2008 so
they could break the annual cycle and not have the box label spoil the
"Don" <firstname.lastname@example.org> wrote in message
>I have Money 2006 and am perfectly happy with it but the stock updates will
>stop in September of 2008. I guess I have to upgrade. will ...can't open outlook #3
My Outlook just stopped working all of a sudden. I can't
open it at all. If I have to reload it, is there a way I
can save the emails and calendar stuff so I won't lose it
As long as your emails and calendars are stored in a .pst
file, you shouldn't have to worry about them. Find it and
make a copy prior to re-loading if that will give you a
little piece of mind.
>My Outlook just stopped working all of a sudden. I can't
>open it at all. If I have to reload it, is there a way I
>can save the emails and calendar s...CRM 3.0 - Sales Pipeline
I've created a sales process (event Manual) in the workflow manager and i've
created some oppotunities in which i've applied the sales process.
When i run the Sales Pipeline report the name of the sales process doesn't
appear in the Group by Sales Process field.
Do you know if i have to do somethig else so i can select the sales process
i've created in the Group by Sales Process field?
The sales process will only be picked up for the opportunities that selected
in the report. Does your report have opportuntities on which you ran hte
...I am unable to launch microsoft for mac 2008
Operating System: Mac OS X 10.5 (Leopard)
Everytime I click on one of my icons to open this microsoft office setup assistant pop's up. Unlike the other users with this question i have tried following there instructions and register but the page wont load. I am a student and i depend on excel for school assignments and have been really annoyed with not being able to get this open. PLEASE help me.
On 4/21/09 5:42 PM, "email@example.com"
> Everytime I click on one of my icons to open this micros...if A1=Null and B1=A1 why is result in B1=0 ??
if A1=Null and B1=A1 why is result in B1=0 ??
because of this I get wrong result for average calculations: average for
(6,8,0) <> average for (6,8,null)
(remove nothere from the email address if mailing direct)
"WGeorg" <WGeorg@discussions.microsoft.com> wrote in message
> if A1=Null and B1=A1 why is result in B1=0 ??
> because of this I get wrong result for average calculations: average for
> (6,8,0) <> average for (6,8,null)
Use this ...Migrating AD Back to SBS
We had a domain which was working in a SBS2003 normally but since we had
to change the hardware we added a second DC which is a windows 2008 and
transferred all the roles to it, and let it working alone.
Everything is fine now with the win2008 as a only Domain Controller
We now have to reinstall back the SBS2003 and transfer everything to it
from the win2008, is that possible? is there any how-to or best
practices? As it seems that all i can do is start a new domain from scratch.
There is an official MS document for adding SBS 2003 to a Server 2003 domain,
I wanted to move my CRM Server to a Web Server, off of the SBS 2003 machine.
I accomplished this using CRM 3.0 Professional.
Now I would like to re-import my customizations and my data.
I'm just thinking out loud, but here is what I would presume the
requirements to be for this:
1. Uninstall the CRM 3.0 SBE Server from the SBS 2003 machine (after
backing everything up)
2. Delete the Existing CRM 3.0 / SQL 2005 Database
3. Install CRM 3.0 Pro on Web Server (Windows 2003 R2 Member Server) with
the Same Organization Name
4. Import the Customizations
5. Restore the Datab...Change from SBS 2003 to SBS 2003 R2
Does anyone know if the license from Windows SBS 2003 works on R2
Here's my situation:
I have an old server running Win SBS 2003. This is a new client and i
just found the installation to be all screwed up (they are not even
using Exchange, the domain is not .local, I cant find the SBS
management panel, etc ) and barring any magic solution that allows me
to improve on the current install, what i really want is to start from
scratch, probably on different hardware (new server).
So I whas thinking to my buttons:
During reinstallation, can I now use the latest ver...Printing Gridlines #3
I am having trouble printing the gridlines on my spreadsheet. I have checked
print gridlines in page set up. Draft quality is not checked. I cannot
figure out why they won't print. If I send it to another computer it prints
just fine with the gridlines showing!!
You may have set
Format>Cells>Patterns to something invisible
Microsoft MVP - Excel
"kidme" <firstname.lastname@example.org> wrote in message
>I am having trouble printing the gridlines on my spreadsheet. ...GP 9.0 Login Issues
There are two users that are having issues logging into great plains and
keeping connected. It doesn't happen every day, only sometimes, but whenever
one of them logs in to Great Plains 9.0 it kicks the other user out, even if
they are the only two users on the system with 10 users allowed at a time.
At times when one person logs in she sees the welcome screen of the other
person that usually kicks her out.
I wondered if this has happened to anyone else and how it could possibly be
resolved. As far as I know these are the only two users it happens to. They
both have completely sepa...Money for Mac #3
Any news of Money for Mac?
As much chance as a snowball in a very hot place! They can't even find the
resource to produce Windows versions for anywhere outside the USA!
Microsoft MVP - Money
For unofficial FAQs see
I do not respond to any emails that I have not specifically asked for.
"Dermot" <email@example.com> wrote in message
> Any news of Money for Mac?
And even that's in question.
If there were the business case, they'...Store Operations 2.0 Service Pack 1
I am trying to download the Service Pack 1 for RMS Store Operations 2.0 with
existing version 2.0.0105 and I am getting an error message of "The expected
version of the product was not found on your system." Any suggestions or
solutions? Thank you in advance for your help.
are you sure you didn't download POS sp1?
"knightsbridge" <firstname.lastname@example.org> wrote in message
>I am trying to download the Service Pack 1 for RMS Store Operations 2.0
> existing version 2.0...Roaming Profiles #3
Does any know if when using roaming profiles, can you
limit those profiles to cerain machines on your LAN?
...vc MFC 2008 DocView MFCTableCtrl
in vc 2008 environment
i create a project which is muti-docview,when i open some file,the file show
in the client area ,and also there some table name on the client header,I
can get the MFCTableCtrl by GetMdiTab() ,but all i want is that i want to
replace the tabctrl with my own defined tabCtrl. how can i do this.thanks
forgive for my poor english ...
...SBS 2003 VPN Frustration!
I hope someone here can help. I saw a similar post that someone here was
able to solve so I'm pinning my hopes on that.
Let me try and provide as much information as possible.
I'm trying to setup the software VPN on the SBS so that remote users can
be connected in to the server (so they can use local Outlook Exchange,
can access the shared data folders on the main office server, etc).
Testing this setup on our own system, I can connect into the server
using VPN but cannot access anything on the network.
1. I ran the "Configure...excel 2000 #3
when I open my excel file example Book1.xls-
there are two excel file opens.-"Book1.xls;1" and "Book1.xls;2". they are
how this happen?
only on this file.
You have two windows on the same file. Just close one of the windows with
the X in the top-right of the window, and it will be back to normal.
(remove nothere from email address if mailing direct)
"jaypee" <email@example.com> wrote in message
> good day!
> when I open my excel file example Book1.xls-
...Migrating SBS 2003 to SBS 2008
I really appreciate your inputs regarding my dilemma and made me think to
change course with this migration and obtain private IP's for our network
instead of the public ones. I will need now to figure out where and how to
start changing our IP's! and what is involved.
Hope after changing to private IP's, the migration will run without any
glitches. I'm keeping me fingers and toes crossed.
If you have any suggestion or links on how or where to start to enable me
changing IP's from public to private; then PLEASE let me know.
Thank you for everything guys...Editing Standard CRM 3.0 Reports
I am keen to know if i can edit the inbuilt crm reports. i can find the rdl
files but not the sln files so they can be edited in visual studio 2005. can
someone please advise me how to go about this?
Yes, the inbuilt CRM reports are available for customization. You need to
export the report file. The reports of CRM are built using SRS Reporting
services. So once you have the .rdl files with you can create a new Business
Intelligence Report project and add the .rdl to the project. You can now
Also if you want you can open the .rdl file in ...