Calculating Net Worth
I want to project my net worth forward by hand. It seems like this
should be a simple calculation, but I'm having troubles making the
numbers add up ;)
As far as I see it, I should be able to calculate future net worth
Future Worth = Net Worth Now + Income - Expenses + Asset
But I can't /always/ make these numbers work out. when I test the
scheme out by "predicting" my current net worth based on real values
from a few months ago Here's what I'm doing:
1) I take the net worth (from the net worth over time report) six
2) Then...using subtotals with other data to calculate
I need help!! I'm trying to use the subtotals of one
worksheet to paste into another to calculate out costs but
when I paste them over, I get all of the cells including
the subtotals. I only want the subtotals & to be able to
match them to another group of data for calculations. Can
anyone help me?
To copy just the subtotal amounts:
1. Collapse the Subtotals, and select the range of cells that
you want to copy.
2. Choose Edit>Go To, click Special
3. Select Visible cells only, click OK
4. Choose Edit> Copy
5. Select the cell where the paste should start
6. Choos...Calculating in Payroll
We are on 7.5 with Pervasive using Wennsoft for job cost and Windows 2000.
There are 3 workstations exactally alike. There's only one that can do any
calculations within payroll such as manual checks, building check files and
month end and quarterly reports. The other 2 hang up when they go to
calculate. Since we are still on Pervasive we don't have the use of MS or
Wennsoft for assistance.
So far I have:
1. Removed and reinstalled Dynamics and Wennsoft.
2. Copied the .dic files from the one that works.
3. Replaced all files from the C drive (pertaining to Dynamics and WS) of
the on...Calculations in Time Problem
im sure this is obvious but
say ive got 2 times
how can i do the maths A2-A1 etc , ive formatted everything t
mm:ss.000 as ive read that when searching on forum but when i put thi
in B1 =A2-A1 i just get #VALUE
how do i get it so it gives me the answer 0:00.004 in B1
any help would be much appreciated:
scottymelloty's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=380
View this thread: http://www.excelforum.com/showthread.php?threadid=48882
Sound...Calculate the total overlapping time of multiple tasks, excluding non-working times
I am developing a tracking calculator for an overall process. Within the
overall process, there are 3 steps which are completed. These steps can
be completed independently from one another, but can also (sometimes)
I am trying to determine the total time for the overall process (from
beginning to end), without counting the duplicated times where the
steps are running parallel to one another, or times when some steps may
be completed and are waiting for another to start.
I have outlined the basic design of the worksheet below, with times in
mm/dd/yyyy hh:mm format.
S...Replace using wildcards??
I have a text field that contains both numbers and text. At the end of some
of the data in this field , it has a partial date -- such as 12/24 - 01/23.
This date could be different for each record that contains it. I would
like this date portion stripped out completely as it is not needed and
interferes with queries when grouping. I have been unable to accomplish this
using wildcards. Is there another alternative?
If you could figure out a defining pattern in the string, such as the date
starting at position 25, you could use the Right, Mid, or Left functions to
strip o...How do I use exchange tools to identify who is sending virus from network
What tool can we use to help identify who is sending out virus email through
our exchange server?
We thought we had all computers protected, but it seems somehow they got in.
We are trying to determine where the virus are originating from and not
having much luck.
Does anyone have any ideas on what tools could help with this?
Paul Stephenson wrote:
> What tool can we use to help identify who is sending out virus email
> through our exchange server?
> We thought we had all computers protected, but it seems somehow they
> got in. We are trying to d...Optimum Calculation using VBA
I have developed a file to advise me when I should rise the weight of a
airfreight shipment to receive the best rates available. (It's still
quite rudimentary at this stage)
How it works is like this...let's assume anything up to 45 kgs will
cost $4.70 per kg, anything equal or above 45 kgs will cost $4.00 per
kg. If we consider that 45 kgs X $4.00 costs $180.00, then any shipment
above 38 kgs at $4.70 per kg will cost more (39 kgs X $4.70 will cost
$183.33, nothing less than a whole kg is valid). Therefore, it is best
to raise the shipment weight to 45 kgs to avoid paying undue shi...When was a DL last used? #2
I am trying to script or develop some sort of way to see which DLs are not
being used. I know promodag has something to this effect but I am at a new
job that apparently does not have message tracking turned on. Can this be
retrieved by date or other means?
...2-way integration using callouts
Am doing 2-way integration with CRM and biztalk.
Problem is when updating CRM from an external system the integration callout
will fire, causing cyclic behaviour.
Is there any way to avoid firing a callout when using the SDK?
No easy way to do this. You basically need to add logic to check to see where
the update came from or to check the values to see if they've changed.
MVP - Microsoft CRM
On Fri, 11 Feb 2005 05:29:01 -0800, "Nick Doyle"
How do I locate the Aucto Calulate function in Excel 2000? I use to be able to highlight cells and have the sum appear at the bottom. Now it has "min=".
Right click in that min and select sum in the popup menu.
* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
"Linda A" <LAdams@shamrockcompanies.net> wrote in message
> How do I locate the Aucto Calulate function in Excel 2000? I use to be
able to highlight cells and have the sum appear ...How is GP Calculating the Suggested
I have an issue where the Order Point Quantity is set to a number e.g. 200.
When the PO is generated using PO Generator it doesn't create a Suggested
Purchase Order. When the Order Point Quantity is increased to 400 it
generates a suggested Purchase Order for 98. Where is the PO Generator basing
its calculation for the suggested quantities. In the above Scenario, there
are no stock in the Site/Warehouse and should create 200 as suggested
esage, PO Generator is seeing some quantity somewhere. Do you have
other Sites where this item is stocked that PO Gen may be seein...Excel calculate the z factor automatically
How do Excel calculate the z factor automatically
EggHeadCafe - .NET Developer Portal of Choice
...Using POS in Grocery Store
1. I want to use the system in Grocery store. I have to set up a servers and
10 registers. I will accept FoodStamp and some other types of cards. What is
the way to set up system accept Food Stamp. I mean I have set up all
configurations for it, but I just want to know if I slide a FoodStamp card ,
how to make system charge from it. I need to set up FoodStamp merchant
account separately or just purchase merchant account with food stamp support.
I don't know ... can anybody help me with this ?
2. I will need 10 scale-scanners. is there any roght scheme to set up all
t...Perform a calculation????
I'm curious if anybody knows how I can do a calculation on two fields
in CRM. In the Opportunity form I created a Gross Profit custom field
and what I want to do is calculate Gross Margin by taking the Est.
Revenue minus the estimated Gross Profit then calculate the Gross
Margin and populate a field with the result.
Any help out there?
Only way to do this is when you create some event code which is attached to
picklist fields. An eaxmple would be a picklist where you have shipping
methods such as UPS, Fedex etc. When you choose the method the event code
updates the shipping cost etc
&q...Calculate fees based on the percentage given
Based on the example and table in the attachment, I want to calculat
Total Cost based on a specific percentage.
At first, I need to calculate based on Class 2 minus Class1.
The Total Cost is calculated after a fees is entered.
I want the steps of calculation (shaded in blue in my worksheet)
to be displayed in the worksheet too.
How can i do that?
Any and all help are appreciated!
p/s Please refer to the attachment
| Attachment filename: book1.xls
|Download attachmen...IF calculations
number in "A1", number in"A2". I want to calculate difference and put the
difference in "A3" except if "A2" is input as "0", I want to put "0" in "A3".
Gord Dibben MS Excel MVP
On Fri, 11 Jul 2008 16:46:06 -0700, jpmiii <firstname.lastname@example.org>
>number in "A1", number in"A2". I want to calculate difference and put the
>difference in "A3" except if "A2" is input as "0", I...Using calculated filenames
Ok, Here's another thing I'm having trouble getting to work. I would
like to concatenate a file and cell name to use to retrieve a value. I
have a master sheet that contains a filename value in a cell. I would
then use the filename value contained in that cell to call a value from
another sheet. Here is an example of what I mean:
['FILE_SALES_JUNE_2006' is concatenated, cell contains value...]
I would then use that value to call a concatenated cell value from
Sales_June_2006.xls!S_1001...Use with Work and Home Accounts
When I click an IM link in WLMD I get the message "Windows Live Messenger is
currently not signed-in with the same user acocunt...". I am using my work
Win Live ID in Win Live Messenger and Home Win Live ID with WLMD. I want to
stay logged in Messenger with thw Work Live ID. I have Linked my Win Live IDs
but it still asks me to log out. Is there any way I can stay logged in to
Messenger with by Work Live ID and access Messenger with WLMD using Home Live
If accessing the IM link from a contact in WLM, then no.
You can open WLM with one ID and open WLMsg with anot...calculation sundays between two dates
cell A1 has start date (eg) 12/08/05
cell A2 has end date (eg) 25/08/05
and cell A3 has the formular that displays a the number of sundays occured
(in this example the result is 2)
jeff thinkin Wrote:
> cell A1 has start date (eg) 12/08/05
> cell A2 has end date (eg) 25/08/05
> and cell A3 has the formular that displays a the number of sundays
> (in this example the result is 2)
Try this >
Where the red 1 indicates a Sunday, 2 would be Monday etc
--...Once only calculation
I'd be very grateful if someone can help me with a bit of macro cod
that might achieve this. Really having trouble as my programming skil
I want to perform a "once only" calculation on rows of cells. When
reference cell changes from blank to a value it will trigger
calculation in another cell. When the reference cell change
subsequenlty it will not affect the value in the calculated cell.
Cell - Formula - Value
B1 =A1 value blank
A1 value 10
B1 =A1 value 10
A1 value 20
B1 =A1 val...accessing the internet via optimum
I currently use optimum for access to the internet. How do i figure out what
the "pop server" is? i have no idea of how to set up the server information
needed to send and receive emails.
Optimum may be your ISP but are they also your preferred mail
service provider? If so, see here:
Gary VanderMolen, Microsoft MVP (Mail)
"Lavada" <Lavada@discussions.microso...calculate percentile for indexed numbers. Thanks #2
Hi, I have a large series of numbers saved in one column
[34,5,21,98,34,3,432,55,27,90,1125,......]. These data are indexed, e.g. by
[1,1,1,1,1,1,2,2,2,2,2,2,2,2,2,......N] which are in another column.
Basically I am calculating the 25% percentiles for numbers indexed "1", "2",
"3",...., "N" respectivelly. There are a lot of numbers with a big uplimit of
index "N" so that selecting numbers of each index manually is not easy.
In another word, if N = 9999, then I need to calculate N 25% percentiles
with one for each indexed number cla...Subtotal not calculating fully
I have a simple function to subtotal a long column.
The function is =SUBTOTAL(9,P7:P850)
some of the cells in the column have values but don't add to th
Any help would be appreciated
Message posted from http://www.ExcelForum.com
Some of the values are most likely entered as Text. Coerce them to
numbers by selecting an empty cell, copying it, selecting your numbers
and choosing Edit/Paste Special, selecting the Values and Add radio
In article <email@example.com>,
marvontherim <<firstname.lastname@example.org>>...CheckBox Calculation
I have a check box on a table. When I click it I want it to perform a
calculation plugging in a new service date.
I want to basically auto calculate after a task is completed and plug that
value into the table. can you please help me in a good direction or approach
to conquer this task.
First, if you're editing or entering data directly into your table...
that should be avoided. That's what forms are for.
A table has no events, like a check box AfterUpdate event, on which to
trigger your code.
Setting a checkbox to True on a form, would f...