Faulty cost basis calculation
I just re-installed Money 2003 Delux afyter a hardware
problem, and am using a backup copy of the Money file. I
hav eone investment that shows the correct purchase
amounts and quantities, but has calculated the cost basis
incorrectly. ( i.e. purchase 4000 shares at 2.35, cost
basis $52,000 when it should be about $11,000). I can
not find any way to edit the cost basis, or a way to get
this program to re-calculate it correctly.
Anyone else have this problem and solve it?
In microsoft.public.money, <firstname.lastname@example.org>
>I just re-installed Money 200...Help with Input Mask
I'm a complete newbie trying to design a relatively simple data base for
organizing choir music. I need to store arranger and composer names and be
able to search for them. I will not need to track or display first and last
names separately, so I would rather not use separate fields. But I need to
have the data input consistently. Is there a way to create an input mask or
validation rule to insure "Last name, First Name" format?
On Thu, 18 Oct 2007 13:12:00 -0700, leslie1165 wrote:
> I'm a complete newbie trying t...Need help with modifying VLookUp
I need some help with modifying a VLOOKUP function.
I have the following data in cell range E1:G9.
Col_E Col_F Col_G
===== ===== =====
Richard 1 A
Richard 2 B
Richard 3 C
Sue 4 D
Sue 5 E
Sue 6 F
Tom 7 G
Tom 8 H
Tom 9 I
Cell A1 will have either one of the 3 names: Richard, Sue, Tom
Then, in cell range A15:B17, I want to show the associated values of either
- F1:G3, or
- F4:G6, or
So, if A1 = ...Question about total cast basis calculation for an investment acco
I am using Money 2004 to track my mutual fund investments, among other things.
I had the portfolio manager options set to show closed positions. When
configured as such, the the cost basis from the closed positions was added
into the total cost basis for the investment. In my case, the closed
positions were a result of a non-taxable sell and reinvest into another
investment. Long story short, some money shows up twice in the total cost
After clearing the option to show closed positions, the total cost basis
calculation appears to be correct.
I would expect to see...Help with labels and lines in chart
i am tracking a few things and i wanted to make some objects in the my
chart reposition dynamicly as i change the scale
i dont care if i have to do a little clean up but just that the
postions stay correct
i have attached a picture
any suggestion would be greatly appreshated
|Filename: Unti.png |
|Download: http://www.excelforum.com/attachment.php?postid=5056 |
---------------...uploading a website, dumb stuff, but I need help
This is my first time, and go figure, Verizon is no help
(my ISP). How can I make it work. I'm dumfounded. I
created the html files in Publisher, but when I upload
them using WS FTP, only the default (1st) page works, and
none of the links work.
How about you tell us what version of Windows and Publisher you are using?
I'm going to guess you are using version 2002.
I recommend you review my 2002 tutorial at
I also recommend you use our forum at
David Bartosik - Microsoft MVP
Visit www.davidbartosi...Net Worth increase calculated incorrectly?!
I've noticed what seems to be a bug to me. Let say for example that my net
worth was negative $5,000 and then the next month it became positve $7,500,
money then says on it's monthly report that my net worth went up 25% in the
last month. Using some sort of logic, wouldn't it be more like 225% ?
"Dan Andersen" <email@example.com> wrote in message
> I've noticed what seems to be a bug to me. Let say for example that my
> worth was negative $5,000 and then the next month it became positve
...Please help me!!! Migrating from Outsourced Exchange to In-House
I am faced with a rather difficult task and dilemma. Here is my
My company currently hosts Microsoft Exchange 2003 with a third-party
solution that hosts several thousand accounts from different companies
on the same exchange server.
We have built an in-house exchange server that is ready for deployment.
I need to know the best and most seamless way to transition from the
outsourced company to our in-house exchange so that mail delivery is
not disrupted. The email address and domain name will remain the
I have contacted several companies that offer tools for e...HELP RE: DISPLAY CHECK NUMBER ON PAYEE REPORT WITH
How do I get a historic payment reoport for a specific
payee including check number, date, amount, and payee name?
"Car Loan Payment history for the period 1/1/01 thru today"
Payee: Check # : Date: Amount:
(and perhaps a running total or a final total)
I think I have tried all the built in reports and can't
find one to do this or modify existing to do this.
I see this information in the "view payee details" window,
listed in the format I require but when I select PRINT all
that prints is the bar graph that is also displayed on
I ca...How do I paste a email screen shot into the message area please?
One of my users has a problem which is hard to explain in words. I need to
paste the screen shot in this space that he sent me via email, and I'm unable
to do so.
How do I paste a email screen shot into this message area please?
Thanks in advance
Not possible, but you can use any free image hosting service on the net and
let us know where we check it out.
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
"GP Guy in AZ" wrote:
> Hey Everyone:
> One of my users has a pro...Help #7
Question1. How to recover or check consitency using eseutil and other
Question 2. At Present Exchange Server is in Live containing Database of 110
Can We do clustering in exchange to fail over recovery. Did it will affect
the existing data base
Waiting for your reply
Eseutil is located at "C:\Program Files\Exchsrvr\BIN". This utility can be
used for several things go to this directory then run eseutil, it will
display all the options available.
You can do exchange cluster, but you need to make sure you got Exchange
E...Help with this code please !!!!!!!
I have use the code set below in other files but in this new file I am
getting an error on "Cells.Select". "Select method of Range class failed"
Any idea whats going on?
Application.CutCopyMode = False
are you sure you have the sheet name correct?
no need to select, i'd use something like this:
With Worksheets("Completions Summary").Cells
...help with weekdays between two dates
A little rusty with access - been away for a while.
Wondering if someone could help me with determining the weekdays between two
a simple function of somekind using the date or count functions?
Be great if it did stat holidays too but I know that's asking more than is
"Jim" <firstname.lastname@example.org> wrote in message
>A little rusty with access - been away for a while.
> Wondering if someone could help me with determining the weekdays between
> two dates.
> a simple function of somekind us...Excel help>>>>>
Hey all :)
i'm new to this forum and have a question.
I'm working with windows and doors in wood in my own firm.
I use excel to calculate the price and also to calculate the windows
So here is the question : is it in any way to get excel to draw the
frames for the windows based on what i set for Width and Height or is
it not possible ??
Something like this : http://www.windowmaker.com/eng/udd2.htm
Thanks for any reply. :)
Globel's Profile: http://www.excelforum.com/member.php?action...Date Help
I have linked two columns on a worksheet so that when I type in the date in
cell C6 it also appears in cell J6. I entered =$C$6 in J6, and this works
except sometimes I don’t need to use the date cells. My problem is in cell J6
the date appears as 1/0/00 until I type the date into cell C6. What am I
use this formula instead
> I have linked two columns on a worksheet so that when I type in the date in
> cell C6 it also appears in cell J6. I entered =$C$6 in J6, and ...averaging without zero
I need help with following what is the formula for obtaining of three
numbers when there are zeros in the column
How do I average the above without zero making this six lnumber ro
Or how can I use only the two lower numbers.
which is an array formula, so commit with Ctrl-Shift-Enter
(remove nothere from the email address if mailing direct)
"zetatstrat" <email@example.com> wrote in message
news:9C3D7586-55A7-4E2A-91FF-035A3BEBFDA9@micros...Calculating entries in a group
I have a database that lists all applicants, and I have a report that sorts
them according to which Institution they are attending. How can I have the
report display the number of applicants that are attending each Institution.
For example , Four applicants from Harvard, 10 Applicants from Columbia, ect.
Use this query ---
SELECT YourTable.[Institution], Count(YourTable.[Institution]) AS
GROUP BY YourTable.[Institution];
Build a little - Test a little
> I have a database that lists all applicants, and ...Help with debugging query (Rolling Average)
I'm trying to do a rolling average on data that is ordered by a date
I'm after adivce about how best to do this, I've tried this -
SELECT Time, ValueX, (HOUR(Time) * 3600 + Minute(Time) * 60 +
Second(Time)) As TickTock
WHERE TickTock Between (TickTock) AND (TickTock) + 30) AS
Basically my thinking was that it would be easier to work on this
datetime data as Seconds, So that my rolling average can be based on
10, at 3 second intervals
When I try this I get nothing in my RollingAverage box and also a...Help with query-dont want to see dupes
I've made a query to find customers that have ordered a certain product
between a period of time. Some customers order a lot so they'll appear
multiple times but I only want to show each customer once.
The field to compare is ContactID
On Tue, 10 Apr 2007 10:02:51 -0700, "Rob" <firstname.lastname@example.org> wrote:
>I've made a query to find customers that have ordered a certain product
>between a period of time. Some customers order a lot so they'll appear
>multiple times but I only want to show each customer once.
>The field to compare is Contac...How do i calculate a 50 moving averager?
When generating a trendline, the original data still remains. Is there a way
to get rid of the data (other than changing the color to white) and simply
having the trendline? I was thinking if it is not an option i can calculate
the moving averager and merely graph that column. Let me know what is the
best way to go about this....Thank you
I don't think you can maintain the trendline if you remove the underlying
data. You can simply create a new column to graph which is the moving
average by using the average command and then dragging it down. By this I
mean lets say you had a ...Please Help: Character Insertion
I have an excel database full of product from my supplier. One of th
columns contains UPC codes. A full UPC code is 11 digits, but for som
reason my supplier omits the number zero in which the first number i
zero. Right now, I have half a list of correct 11 digit codes, and th
other half I need to insert a zero in front og very first digit. I
there any way for me to do this in bulk instead of doing one by one?
9999999999 (I need zeroes entered on these in the beginning
Message posted from http://www.ExcelForum.com
Maybe change the format to custom 00000...SendMessage Question/Problem
I have a dialog box with a toolbar subclassed in it that has a combo box. I
have embedded the toolbar in a static control on the dialog box. When an
item in the combo box is selected, I am getting the OnSelChange message
being triggered in the subclassed tool bar class. I then get the item that
was selected and call GetOwner()->SendMessage(WM_NOTIFY......) In the
dialog box I have a ON_NOTIFY message command for the IDR_TOOLBAR. when I
debug the OnSelChange method in the subclassed toolbar class, I can see it
setting up the call, but when I place my cursor and do run to cursor in the
O...Can someone help me print a 4 up post card in publisher 2007
I have been trying to print 4 postcards on a page but can not figure out how
to do it. Please help!
I'm a Publisher 2000 user and this is how I would do it using 8�"x11" stock.
Page Options button (lower left corner of Print window)
Select Print multiple copies per sheet
Custom Options button All margins set to 0"
"JustAlice" <JustAlice@discussions.microsoft.com> wrote in message
news:5A7FC53C-3357-41FB-B650-...Public Folder Replication Problem [need help]
I'm 90% done migrating my Exchange 2003 server to new hardware, I'm having
trouble finishing this step - replicating the Public Mail Store.. I've added
the new server to the replication tab in ESM, the folders are showing up
under the new server, and are in sync! However in ESM when I go
Administrative Groups -> First Admin Group -> Folders -> Public Folders,
there is a list here.. this list is what shows on Outlook clients under
"public folders".. when I right click this folder and say Connect to.. and
select the new server's public mail store, I get ...Re: HELP ! Browser disaster !!
I meant do a System Restore to a point in time PRIOR in time to saving those
test files below, obviously.
Bill in Co. wrote:
> Daave wrote:
>> Trying to untangle this web...
>> Ken Blake, MVP wrote:
>>> On Mon, 14 Dec 2009 17:54:55 -0700, "Bill in Co."
>>> <email@example.com> wrote:
>>>> HeyBub wrote:
>>>>> Bill in Co. wrote:
>>>>>> Yes, I know you said that, but I asked specifically about what
>>>>>> would be the cons...