Newbie problem with amortization calculations
I've just today installed Money 2006 Deluxe trial version; a full
version is on the way, which I am beginning to regret.
I've only gotten as far as downloading my checking account from my bank
and TRYING to establish an account for my mortgage. I have entered the
information five times now, but the mortgage amortization Money
calculates simply will NOT match my bank's. It starts off being off by
a few pennies at best, and escalates by the end of the amortization to
being off by anywhere from a few dollars to fifty or more. Money also
will not allow me to make the mortgage ...Automatic incremental of records
I have a table with several records and arranged serially, i.e 1,2,3 .....25.
When I delete arecod like record number 3 I would like record number 4 to
become record number 3. But in my case Record number 4 still remains serial
number 4 although it is actually the third record. Is there a way it can be
> I have a table with several records and arranged serially, i.e 1,2,3
> .....25. When I delete arecod like record number 3 I would like
> record number 4 to become record number 3. But in my case Record
> number 4 still remains serial number ...Calculate Due Date
Kindly guide me in calculating Due Date in Excel worksheet.
In Column "B" there are some dates.
I want to calculate due dates after adding 40 days from date mentioned in Column "B" to be displayed in Column "C"
In column "B" Date is 01/06/2004 then after adding 40 days date in column "C" must be 10/07/2004
Pls guide me
In cell C5, for instance, the formula should be: =B5+40; enter the formula
in your top cell in column C, copy down and format the column as date and
"Ajit" <Ajit@d...How do I stop automatic copies going to Adminstrator
SBS 2003 with Exc2003 - all current on SPs
How do I stop what appears to be an automatic copy of every message sent
going to the Adminstrator's account?
Also, when an appointment is scheduled or altered by a user, a blank e-mail
gets deposited in the Administrator's account.
I don't want nor need these extra copies.
Anyone have an clues what is causing this and how to stop it?
> SBS 2003 with Exc2003 - all current on SPs
> How do I stop what appears to be an automatic copy of every message
> sent going to the Adminstrator's account?
&...automatic transfers of payments and deposits
I have no problem setting up payments to be made by check but have'nt figured
out how to set up pre-authorized utility payments and pension and social
"Ron AACS" <Ron@cox.net> wrote in message
>I have no problem setting up payments to be made by check but have'nt
> out how to set up pre-authorized utility payments and pension and
> security deposts
Record an example in your register as you'd like it categorized.
Right-click it, pick ...Calculations #5
i was wondering if anybody would know how to re-create the calculation
done at this web site:
I'm not sure what formulas to use to re-create the calculations.
I'd like to know the formulas I can use in Excel to perform th
calculations done in both sections of the webpage.
Would all formulas be exclusive to the PV function only?
Can anybody help?
I would appreciate it if someone could lead me in the right direction
vbc22'...Creating a Formula to Format Column automatically? #3
Can I record it as a macro or anything like that? I have to run it o
five sheets. I've tried to conditional formatting, and it works only o
one cell, unless I'm doing it wrong
bludovico's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1480
View this thread: http://www.excelforum.com/showthread.php?threadid=26434
not sure what you are trying to do but conditional
formating can be coped and pasted. you have also
conditional format an entire column/row by selected the
en...Changing text automatically
After typing in AUGUST 2004 my text automatically changes to
Aug-04. Is there something in Excel which prohibits typing the ful
month? Any help gratefully received
Message posted from http://www.ExcelForum.com
Have you tried to right click the cell and click format
cell. Then select Date and on the right side box select
the format you want?
>After typing in AUGUST 2004 my text automatically changes
>Aug-04. Is there something in Excel which prohibits
typing the full
>month? Any help gratefully received.
>Message posted ...Need SOMETHING that updates a linked spreadsheet automatically
I have two Excel 2000 spreadsheets, S1 and S2. S1 is linked to S2. Bot
reside in a Windows 2000 server.
When values in S2 are changed and saved, I need SOMETHING (a trigger
program, or script, whatever) that automatically updates values in S1
without me having to open S1 and update it myself.
Is there a solution to this problem? What could do it?
Thanks vey much for your help
Message posted from http://www.ExcelForum.com
"kpax >" <<firstname.lastname@example.org> wrote...
>I have two Excel 2000 spreadsheets, S1 and S2. S1 is linked to S2. Bo...Don't automatically clear my transactions
When I balance an account, all my electronically
downloaded transactions are automatically marked cleared.
I want to clear them myself, so I first have to unclear
all of them. How do I turn off this "feature"?
...SOP Transaction Automatic Fulfillment Occuring
My apologizes for this post ahead of time as I am a developer, not a GP guru.
I have what is probably a configuration issue I am trying to resolve, but I
am unsure of the settings that need to be configured.
GP is configured to utilize a separate fulfillment process. When online we
are submitting invoices using a SOP transaction with SOPNubmer = 3. When a
customer submits an order, the order is placed in Great Plains, the pick
ticket prints properly, BUT the order is AUTOMATICALLY fulfilled. Which
setting in the SOP transaction needs to be set to prevent automatic
Th..."Special" Mortgage payment situation
Scenario: one mortgage paid with two checks from two accounts - one account
tracked by Money (mine) and one not (gf's). I would like to track my
mortgage payments and include my gf's contribution (easily done on a credit
account). How can I set up this scenario so each of the two payments are
automatically divided into P & I and entered as one or two monthly bills? I
hope this explanation is clear.
I used to track half of the mortgage (and home value), but need to track the
total due to differences in our contributions.
I think the easiest way is to just brute force the ...MS Excel 2003 cannot auto calculate formula, need to press F9 each time
I don't know why my excel 2003 new worksheet cannot auto calulate
formula (eg. summation), i need to press F9 and it will refresh and
show the new figure. there is "calculate" word at the left hand bottom
of the screen.
what is the likely reason ? it was running fine 2 weeks ago.
any advise is greatly appreciated.
Tools>Options>Calculation tab, check Automatic
Microsoft MVP - Excel
<email@example.com> wrote in message news:firstname.lastname@example.org...
| I don't know w...calculations 07-18-07
Hi, I have a question. I have reports and average totals now I want to
build reports by week or month or whatever how do I add my totals to
give me a team average or individual totals per week not just per
report. example. I have a team of 10 employes each have different
amount of reports and different scores now I want to get a sum total
of thier dayly reports and come up with a dayly, weekly and monthly
report to give me the grand total of what they have done during the
week or month.
Currently I have a table that has all the reports and totals, and I
also have a query that separates them p...xmlns="" automatically generated
I have the following code:
XmlElement parent= m_xmlDoc.CreateElement("parent", "http://tempuri.org/myns");
parent.InnerXml = "<child1>text</child1><child2>text</child2>";
"http://tempuri.org/myns" is declared as the default namespace for this xml file.
When I set InnerXml above, each <child> node gets the following extra attribute: xmlns="". I'd like child nodes to inherit the default namespace instead of the empty namespace. How can I do it?
Posted by a user from .N...outlook is deleting my e-mails automatically
Everything about my outlook is working except when I open
an e-mail and then close it out using the "x" the e-mail
automatically is deleted. It is gone, it is not in the
deleted items, it is completely gone. Can anybody help?
Check View | Current View
What view is selected?
PATRICK REED [Outlook - MVP]~~~~~~
-Microsoft Certified Professional (MCP)
-Have you checked http://www.slipstick.com?
-Please post your Outlook version!
"Ken" <email@example.com> wrote in message
> Everything ...Calculating the days in a month
I have a Control which is a Date field named 'NEWTOPD'. Based on the date
entered in the field it calculates the days offor the whole month making
amends for Leap-year as well. If I want only the number of days in that month
starting from the date entered in 'NEWTOPD' - to be entered in a calculated
text field (which is a number field) named 'Text361' how should I modify the
following code? Text361 stores the data in (PDDAYS).
'UPDATE (PDDAYS) BASED ON NEWTOPD DATE
Dim iMon As Integer
Dim sDate As String
...Stoping Excel from Calculating?
Can you stop excel from executing any formulas temporarily? Meaning while I
update info in the workbook nothing will calculate till I say go? Thanks
Tools/ Options/ Calculation/ Manual.
"John" <John@discussions.microsoft.com> wrote in message
> Can you stop excel from executing any formulas temporarily? Meaning while
> update info in the workbook nothing will calculate till I say go? Thanks
Tool > Options > Calculation > select Manual > OK out
I am new at excel. I have inputs done by group 1 of 5410. Inputs done by
group 2 of 2420. So, I have a total of 7830 inputs. How do I calculate the
percentage done by group 1 over group 2?
Thanks - Lindamac
You can use:
to count the number of "Group1"'s in column A.
will count the number of entries (text, numbers, formulas) in column A.
So maybe something like:
=countif(a:a,"group1") / counta(a:a)
would give you the percentage of group1's
> I am new at exc...How does Money calculate formulas
Hi - is there a reference doc or an FAQ somewhere that details how MS Money
calculates its various investment fomulas. I have investments that show
different returns in Money vs what the various investment companies are
reporting. I've looked around and haven't been able to find anything.
In microsoft.public.money, Ian wrote:
>Hi - is there a reference doc or an FAQ somewhere that details how MS Money
>calculates its various investment fomulas. I have investments that show
>different returns in Money vs what the various investment companies are
&g...Calculated Field in Extender
Is it possible to create a calculation in extender that uses fields from
different tables? Thanks
The fields have to be visible within the calculation window.
> Is it possible to create a calculation in extender that uses fields from
> different tables? Thanks
> Marisol Mortera
...Automatically set categories on events
can anyone tell me a way to automatically set categories to events by
rules? Not the colorize of events, just the "real" Categories.
Thanks for your help.
firstname.lastname@example.org <email@example.com> wrote:
> can anyone tell me a way to automatically set categories to events by
> rules? Not the colorize of events, just the "real" Categories.
I use the "assign it to the _category_ category" action.
...How to Select Multiple Cells Conforming to A Certain Criteria Automatically?
I have a big table containing a lot of data in my worksheet. Within a
particular column, I want to select cells whose row numbers form an
arithmetic progression with a common difference 8(e.g. G6, G14,
G22, ...). At the moment, I can only perform this task by selecting
the cells individually while pressing "Ctrl", however, due to the
large number of data in the table, this work is very tedious.
Does anyone know if there is an automatic way to select these cells?
This code can do the job for you.
Dim rng1 As Range
...Calculating on alphabetic cell content
A selection of 4 different letters in a column representing different values
to be used in a formula shall be run through. The calculated result of each
cell in the column shall be placed in the cell next to the read one that
holds the letter.
Thanks in advance.
i think you're after the COUNTIF function
with your column of letters in A1:A100
and the letter you're interested in in C1
then in D1
this will count the number of times the value in C1 occurs in your range.
If this isn't what you're after, could you type out a few examples of your
...how do I create fields in word 2007 to automatic update in excel?
Each day I create a new document that contains several patient's info which
includes history, names, patient numbers, etc. At the end of the month I
copy and select only data that I need, which is name, patient numbers, and
date (not the entire document) and copy into a new document. How do I create
a template that will mark specific text and have it automatically update in a
Hope this helps,
Doug Robbins - Word MVP
Please reply only t...