Where can I find the file ABC Sales.xls used in the Book "Running.
I have just purchased "Running Microsoft Excel2000". It gives me an address
to where I can get the files used in the examples, I just can't find them.
The address given is http://mspress.microsoft.com/mspress/products/2050. I
would appreciate any help you can give me.
|| I have just purchased "Running Microsoft Excel2000". It gives me an
|| address to where I can get the files used in the examples, I just
|| can't find them. The address given is
|| http://mspress.microsoft.com/mspress/products/2050. I would
|| appreciate any help you can give me....Error installing CRM Sales for Outlook
When running the CRM Sales for Outlook it requires a url
I get an error message that states the
following "Microsoft CRM Sales for Outlook cannot find an
instance of the Micrososoft CRM Server components
Yes it says "...Micrososoft..." besides the point. I also
try WINS name and FQDN with no success.
What type of permission settings are needed on IIS, or am
I way off base.... Thanks in advance for your help
there is an option to create a log so you can work out issues like this
here is the line
After about a year of working fine, Money 2003 has suddenly stopped updating
2 stocks in a 10 stock portfolio. The stocks both still exist and Yahoo
updates them instantly.
What do I have to do to get 2003 to resume updating?
Thanks in advance.
Which Stocks? What are the symbols you're using?
Does MSN Money (http://money.msn.com) recognize them?
"igorx" <email@example.com> wrote in message
> After about a year of working fine, Money 2003 has suddenly stopped
> 2 stocks in a 10 stock portfolio. The stoc...Stock Quotes download to Money 2004
Unable to download MSN money quotes to Money 2004
portfolio. Call runs, may or may not complete,update
status changes, but stock prices don't change. Same
result with 2002, two different ISP's, with Norton
Internet Security Disabled or not, Firewall disabled or
not. On XP-home. No synchronization Base Articles re
2004 vs MSN Money. Started 3/4 months ago with 2002,
continued with 2004, gradually getting worse until now
almost never updates. Call summary always says error,
money could not connect to online quotes server.
RE- base articles 312818, 276018 sound good but have n...Graphing A Time Series OF Stocks
My data looks like so:
Stock TradePrice TradeVolume ExecutionDateTime
EFG 5.2 8 2:40:04 PM
EFG 5.5 8 2:40:02 PM
EFG 5.1 10 2:40:01 PM
EFG 5.3 10 2:40:01 PM
EFG 5.1 10 2:40:00 PM
EFG 5.1 10 2:40:00 PM
ABC 1.5 4 2:31:17 PM
ABC 1.6 ...Stock commission is greater than proceeds of stock sale.
I recently sold 2000 shares of stock for $0.0001 per share. Gross proceeds
were $0.20. Commissions for the sale were $29.95. Net proceeds were
-$29.75. I tried to enter this into Money 2004 and it will not allow
negative proceeds of a stock sale. How should I record this sale?
In microsoft.public.money, go3049 wrote:
>I recently sold 2000 shares of stock for $0.0001 per share. Gross proceeds
>were $0.20. Commissions for the sale were $29.95. Net proceeds were
>-$29.75. I tried to enter this into Money 2004 and it will not allow
>negative proceeds of a stock sale. ...Setting Up Sales Processes 02-02-05
BACKGROUND: I'm wanting to create sales processes that have NO ACTIVITIES
automatically assigned . . . I just want the reps to update the sales stage
as it moves along. And I know the sales rep can manually move it along even
if there are activities, but I would have to create a lot of unnecessary
QUESTION: So, how would I go about creating a 4 stage sales process that is
COMPLETELY dependant on the sales rep, not whether or not activities are
done? When I tried to do this by creating a 4 stage manual process, the
opportunity was just automatically ...REPORTS: Sales vs. Tender -- difference ???
How do you define what is a Tender report? Better yet, what is the
difference between the Detailed Sales Report and the Miscellaneous/Tender
The numbers are always different and completely off... Shouldn't they be
exactly the same?
Sales represent the product portion of the sale only, not Tax or Shipping.
Tenders represent it all.
"Zorian" <Zorian@discussions.microsoft.com> wrote in message
> How do you define what is a Tender report? Better yet, what is the
> difference between the D...How to record a stock award
My company started giving out stock awards instead of
stock options. How should these be recorded in Money
(using 2004)? I have put it in as a stock option, when
they "vest" they are sold and taxes are taken out. How
do you record the transaction so that the taxes are shown
...Stock Market Challenge
I have been delegated the task of running a share competition at work
I want to get the process fully automated.
Is there a way of building a workbook that imports all the stock marke
data, then have each team on a separate worksheet that is passwor
Each team can update their portfolio on their sheet and it will use th
stock market data to adjust accordingly.
I hope you get what I mean! Has anyone done this before, or know how
should go about setting it up?
mevetts...thick stock legal sized paper printing... How?
I am unable to have the setting stick to legal sized thick stock paper...
could anyone please advise how to do so?
Do you want legal as the default? What version Publisher? 2007 is a little
Are you setting up your printer to legal first and then the page setup?
Mary Sauer MSFT MVP
"Myiatrou" <Myiatrou@discussions.microsoft.com> wrote in message
>I am unable to have the setting stick to legal sized thick stock paper......Edits to Sales Process
We currently have a sales process active on a large number of opportunities.
Some of the reps are now asking for some minor edits to the existing process.
Can anyone tell me what will happen to the active processes if I deactivate
the existing process, make the edits and then reactivate? Will all the
processes have to be restarted from stage 1? Will they continue running as
Does anyone have experience with this and know the best methodology for
implementing edits to an active process?
Thanks in advance.
Your users will only see the change if they are reactivated. I added a...How do I get real time stock quotes to my excel worksheet?
I would like to be able to get realtime stock quotes to an excel worksheet. I
can receive quotes from moneycentral but they are delay 15 to 20 minutes.
Please, advice me on how to get that service.
> I would like to be able to get realtime stock quotes to an excel worksheet. I
> can receive quotes from moneycentral but they are delay 15 to 20 minutes.
> Please, advice me on how to get that service.
There is a small group on Yahoo devoted to using Excel to do various
stock market tricks. You can find it at:
ht...Differences between Outlook and Web Sales?
Has anyone compiled an analysis that shows the functionality differences
between the Outlook and Web client versions of MS CRM? i.e. what's available
in one but not in the other?
The outlook client is actually "Sales For Outlook". It focuses almost
exclusively on sales components. The good news it sits in Outlook and is
familiar to most Outlook users, and it can 'go offline' so the data goes with
you. When you have time, you re-synchronize and everything that you did
offline gets uploaded.
The web client is the full version. No option for offline use, but you can ...stock transfer
transferring an amount from one mutual fund to another within the same fund
so its just like a transfer from your saving account to your checking
account within the same bank.
what is the correct way to document this transaction, just a typical sell
and credit to cash contributions and then a buy with the new fund? I only ask
because there is not "transfer shares" choice Thank You in advance
In microsoft.public.money, wildwood178 wrote:
>transferring an amount from one mutual fund to another within the same fund
>so its just like a transfer from your...Online Stock Trading Guide and How the Stock Market Works #2
Here you can learn more about investing, and some specifics about
You'll also find a wide range of investing products and services to
help you plan toward financial independence - however you define it.
...stock on hand by lot number
any idea how to get the stock qty on hand per lot number?
Inquiry >> Inventory >> Lots
> any idea how to get the stock qty on hand per lot number?
You can also run the stock status report and include lot numbers. It's a
'point in time' report so you can't run it historically, but would give you
the current on hand quantity by lot number.
"Brenner Klenzman" wrote:
> Inquiry >> Inventory >> Lots
&g...My own stock chart with open/close same level?
I have made my own stock chart (or candle chart) with high,low,open close...
When my open and close are at the same level... I just get a line for the
highs and lows but no "body" to my candle... how can I get some sort of
indication where the open and the close simotaneously happened?
Any thoughts are appreciated
Try this approach instead:
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
"John" <John@discussions.microsoft.com&g...Count Contacts on Sales Orders
I am working with CRM 4.0, I like save Sales Orders only if have Contacts and
It is possible count navContacts o Products.
...Automatically adding stocks to Stock Alerts?
I've got Money 2004, and have several investment accounts setup. I
want to add all the stocks in those accounts to stock alerts. It lets
me add my "MSN Stock List" which adds the stocks that I have listed on
my home page on the Money Web site. Is there any automatic way to get
it to add all the stocks I have in an account in Money?
...Multi-currency sales invoice and payments at different rates.
We have a situation where we set up a sales invoice at a particular foreign
exchange rate, but receive the cash at a different point in time at a
different exchange rate.
In the AR subledger, how do these items clear in functional currency?
If I revalue at the customer level, will this clear the foreign exchange
difference in the subledger?
Any help would be greatly appreciated.
We have developed a solution -Ability to import currency rates from an
external web ser-vice. This will automatically import current currency
exchange rates into GP at configurable inter...Stock Status Report and Historical Stock Status Report
I have been doing some experimentation, and I want to confirm this.
If FIFO Perpetual or LIFO Perpetual is being used, the Unit Cost on the
Stock Status Report equals the Current Cost as it appears in the Item
But, on the Historical Stock Status Report, the Unit Cost is the Current
Cost from the purchased receipts layer according to the inventory valuation
Are these two statements correct?
And, if so, I am surprised that any report including the Stock Status Report
reflects Current Cost exactly as it is from Item Maintenance. I have always
understoo...Stock and Stock Fund
I have both Alcoa stock and money in a 401k Alcoa Stock
Fund. The Stock Fund share price is not the same as the
Alcoa stock. I tried renaming one and Money 2003 renames
the othe as well. Is there any way to set these up to be
able to have separate share prices. I removed the ticker
symbol from one and Money removes it from the other.
In microsoft.public.money, C. Zuck wrote:
>I have both Alcoa stock and money in a 401k Alcoa Stock
>Fund. The Stock Fund share price is not the same as the
>Alcoa stock. I tried renaming one and Money 2003 renames
>the othe as well. Is...Stock lookup
I want to do a web query,
how do I get a the current price for a certain ticker symbol.
Ticker symbol is in cell A1
Price should output in cell A2
The ticker symbol is updated?
THanks for your help
> I want to do a web query,
> how do I get a the current price for a certain ticker symbol.
> Ticker symbol is in cell A1
> Price should output in cell A2
> The ticker symbol is updated?
> Any ideas
> THanks for your help
There's a group devoted to Excel issues with stock tradin...Sales History Conversion
Does anyone have a utility or ever done a data conversion
into MRM 1.2 for invoice history. I have extracted the
invoices into excel, but MBS has no import tool to bring
the data in.
Thanks in advance,